Parser::MySQL to handle CHECK CONSTRAINT

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

diff --git a/t/data/mysql/create2.sql b/t/data/mysql/create2.sql
index 54cf4bb..037b182 100644 (file)
--- a/t/data/mysql/create2.sql
+++ b/t/data/mysql/create2.sql
@@ -16,6 +16,7 @@ create table employee (
        position varchar(50),
        employee_id INTEGER,
        CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id),
+       CONSTRAINT `demo_constraint` CHECK (`employee_id` > 0 and `employee_id` IS NOT NULL and `employee_id` not in (0)),
        PRIMARY KEY  (employee_id, position)
 ) ENGINE=InnoDB;