Added some constraint tests

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

diff --git a/t/data/mysql/create.sql b/t/data/mysql/create.sql
index 51dbcc7..9802baa 100644 (file)
--- a/t/data/mysql/create.sql
+++ b/t/data/mysql/create.sql
@@ -8,3 +8,10 @@ create table person (
 ) 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)
+) ENGINE=InnoDB;
+