Only output trigger 'scope' if it's set in YAML and JSON producers

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

diff --git a/t/data/mysql/create.sql b/t/data/mysql/create.sql
index 9802baa..642d9a2 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,6 +13,11 @@ 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)
+  job_title varchar(255),
+       CONSTRAINT FK5302D47D93FE702E FOREIGN KEY (employee_id) REFERENCES person (person_id),
+       PRIMARY KEY  (position, employee_id) USING BTREE
 ) ENGINE=InnoDB;
 
+create table deleted (
+  id integer
+);