Author: vhalbert(a)redhat.com Date: 2009-11-16 16:02:32 -0500 (Mon, 16 Nov 2009) New Revision: 1562 Modified: trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql Log: Teiid 773 - fixed the create table statements for MySQL Modified: trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql =================================================================== --- trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql 2009-11-16 21:01:58 UTC (rev 1561) +++ trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql 2009-11-16 21:02:32 UTC (rev 1562) @@ -3,4 +3,8 @@ create Table g1 (e1 NUMERIC(5) PRIMARY KEY, e2 varchar(50)); create Table g2 (e1 NUMERIC(5) REFERENCES g1 (e1), e2 varchar(50)); + +create Table g1 (e1 NUMERIC(5) PRIMARY KEY, e2 varchar(50))ENGINE=INNODB; +create Table g2 (e1 NUMERIC(5), e2 varchar(50), FOREIGN KEY (e1) REFERENCES g1(e1))ENGINE=INNODB; + \ No newline at end of file