MAss diff changes imported from Ash's local diff-refactor branch

[dbsrgits/SQL-Translator.git] / t / data / mysql / create2.sql

diff --git a/t/data/mysql/create2.sql b/t/data/mysql/create2.sql
index 8a9e768..54cf4bb 100644 (file)
--- a/t/data/mysql/create2.sql
+++ b/t/data/mysql/create2.sql
@@ -5,8 +5,21 @@ create table person (
   weight double(11,2),
   iq int default '0',
   is_rock_star tinyint default '1',
-  description text,
-  UNIQUE KEY UC_person_id (person_id)
+  physical_description text,
+  UNIQUE KEY UC_person_id (person_id),
+  UNIQUE KEY UC_age_name (age, name)
 ) ENGINE=InnoDB;
 
-create unique index u_name on person (name);
+create unique index unique_name on person (name);
+
+create table employee (
+       position varchar(50),
+       employee_id INTEGER,
+       CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
+       PRIMARY KEY  (employee_id, position)
+) ENGINE=InnoDB;
+
+create table added (
+  id integer
+);
+