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

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

diff --git a/t/data/mysql/create2.sql b/t/data/mysql/create2.sql
index 57a02d9..54cf4bb 100644 (file)
--- a/t/data/mysql/create2.sql
+++ b/t/data/mysql/create2.sql
@@ -5,14 +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)
+       CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
+       PRIMARY KEY  (employee_id, position)
 ) ENGINE=InnoDB;
+
+create table added (
+  id integer
+);
+