Add Changes entries for 6c77378 and 1fb4f40
[dbsrgits/SQL-Translator.git] / t / data / mysql / create2.sql
CommitLineData
fb3e4caf 1create table person (
2 person_id INTEGER PRIMARY KEY AUTO_INCREMENT,
3 name varchar(20) not null,
4 age integer default '18',
5 weight double(11,2),
6 iq int default '0',
7 is_rock_star tinyint default '1',
4d438549 8 physical_description text,
9 UNIQUE KEY UC_person_id (person_id),
10 UNIQUE KEY UC_age_name (age, name)
fb3e4caf 11) ENGINE=InnoDB;
12
d990d84b 13create unique index unique_name on person (name);
9ae898b9 14
15create table employee (
16 position varchar(50),
17 employee_id INTEGER,
6a0f3000 18 CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
19 PRIMARY KEY (employee_id, position)
9ae898b9 20) ENGINE=InnoDB;
4d438549 21
22create table added (
23 id integer
24);
25