Commit | Line | Data |
---|---|---|
d0c12b9f | 1 | -- |
2 | -- Created by SQL::Translator::Producer::MySQL | |
3 | -- Created on Thu Aug 7 16:28:01 2003 | |
4 | -- | |
5 | -- SET foreign_key_checks=0; | |
6 | ||
7 | -- | |
8 | -- Table: Basic | |
9 | -- | |
10 | CREATE TABLE Basic ( | |
3731665b | 11 | -- comment on id field |
d0c12b9f | 12 | id integer(10) NOT NULL auto_increment |
13 | ,title varchar(100) NOT NULL DEFAULT 'hello' | |
14 | ,description text DEFAULT '' | |
15 | ,email varchar(255) | |
16 | ,INDEX titleindex (title) | |
17 | ,PRIMARY KEY (id) | |
18 | ,UNIQUE (email) | |
19 | ); | |
20 |