Author: vhalbert(a)redhat.com
Date: 2009-11-25 10:29:33 -0500 (Wed, 25 Nov 2009)
New Revision: 1592
Modified:
trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql
Log:
Teiid 773 - fixed sql
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-25
15:26:10 UTC (rev 1591)
+++ trunk/test-integration/db/src/main/resources/ddl/mysql/create_tables.sql 2009-11-25
15:29:33 UTC (rev 1592)
@@ -1,10 +1,12 @@
-- these tables are used by custom junit test for testing transactions
-
-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;
+
+--create Table g1 (e1 NUMERIC(5) PRIMARY KEY, e2 varchar(50));
+--create Table g2 (e1 NUMERIC(5) REFERENCES g1 (e1), e2 varchar(50));
+
+
+
\ No newline at end of file
Show replies by date