whitespace

[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..64ab685 100644 (file)
--- a/t/data/mysql/create.sql
+++ b/t/data/mysql/create.sql
@@ -4,15 +4,21 @@ 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);
 
 create table employee (
-       position varchar(50),
-       employee_id integer,
-       CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id),
-       PRIMARY KEY  (position, employee_id)
+  position varchar(50),
+  employee_id integer,
+  job_title varchar(255),
+  CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id),
+  CONSTRAINT `demo_constraint` CHECK (`employee_id` > 0 and `employee_id` IS NOT NULL),
+  PRIMARY KEY  (position, employee_id) USING BTREE
 ) ENGINE=InnoDB;
 
+create table deleted (
+  id integer
+);