-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathindex.php
73 lines (60 loc) · 2.29 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<!doctype html>
<!--[if lt IE 7]>
<html class="nojs ms lt_ie7" lang="en">
<![endif]-->
<!--[if IE 7]>
<html class="nojs ms ie7" lang="en">
<![endif]-->
<!--[if IE 8]>
<html class="nojs ms ie8" lang="en">
<![endif]-->
<!--[if gt IE 8]>
<html class="nojs ms" lang="en">
<![endif]-->
<html lang="en">
<head>
<?php include_once("header.php"); ?>
</head>
<body class="blueish">
<div id="main" style="margin-right:15%;margin-left:15%;">
<div class="one_full" align="center" >
<h1>SQL Schema to CodeIgniter DBForge Method</h1>
</div>
<div class="one_half">
<form action="migrate.php" method="POST">
<textarea name="sql" rows="30" cols="80"></textarea><br/>
<input type="submit" value="Forge my DB!" name="migrate" />
</form>
</div>
<div class="one_third">
<strong>3/5/2013</strong>
<p><strong>ALPHA!</strong></p>
<p>This interface allows you to upload your phpMyAdmin create statement (export out of phpMyAdmin) and it will create your CodeIgniter DBForge Methods (used for migrations!). It can only take <em>one</em> create statement at a time currently. </p>
<p>Want to test it out? Copy and paste the code below in the window to the left:</p>
<pre>
CREATE TABLE IF NOT EXISTS `agents` (
`id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`officeid` int(10) unsigned NOT NULL default '0',
`firstname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
`lastname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
`agenttitle` varchar(100) collate utf8_unicode_ci default NULL,
`phone1` varchar(20) collate utf8_unicode_ci default NULL,
`phone2` varchar(20) collate utf8_unicode_ci default NULL,
`mobile` varchar(20) collate utf8_unicode_ci default NULL,
`fax` varchar(20) collate utf8_unicode_ci default NULL,
`email` varchar(100) collate utf8_unicode_ci default NULL,
`url` varchar(100) collate utf8_unicode_ci default NULL,
`location` varchar(100) collate utf8_unicode_ci default NULL,
`information` text collate utf8_unicode_ci,
`testimonials` text collate utf8_unicode_ci,
`dirname` varchar(50) collate utf8_unicode_ci default NULL,
`idx` text collate utf8_unicode_ci,
`active` char(1) character set utf8 NOT NULL default 'y',
PRIMARY KEY (`id`),
KEY `officeid` (`officeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
</pre>
</div>
</div>
</body>
</html>