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

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

diff --git a/t/data/mysql/create.sql b/t/data/mysql/create.sql
index 3e7d603..e8c955e 100644 (file)
--- a/t/data/mysql/create.sql
+++ b/t/data/mysql/create.sql
@@ -4,7 +4,8 @@ create table person (
   age integer,
   weight double(11,2),
   iq tinyint default '0',
-  description text
+  description text,
+  UNIQUE KEY UC_age_name (age)
 ) ENGINE=MyISAM;
 
 create unique index u_name on person (name);
@@ -12,7 +13,11 @@ create unique index u_name on person (name);
 create table employee (
        position varchar(50),
        employee_id integer,
+  job_title varchar(255),
        CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id),
        PRIMARY KEY  (position, employee_id)
 ) ENGINE=InnoDB;
 
+create table deleted (
+  id integer
+);