Update of /cvsroot/dbunit/dbunit/src/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv788/dbunit/src/sql
Modified Files:
mysql.sql
Log Message:
Refactored test suite to works with MySQL. Problems where mostly hard coded SQL using capitalized table names that I converted to lower case.
Index: mysql.sql
===================================================================
RCS file: /cvsroot/dbunit/dbunit/src/sql/mysql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql.sql 9 Apr 2003 22:52:17 -0000 1.2
--- mysql.sql 10 Apr 2003 02:52:06 -0000 1.3
***************
*** 3,11 ****
-----------------------------------------------------------------------------
CREATE TABLE test_table
! (column0 VARCHAR(32),
! column1 VARCHAR(32),
! column2 VARCHAR(32),
! column3 VARCHAR(32)) TYPE = InnoDB;
-----------------------------------------------------------------------------
--- 3,12 ----
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS test_table;
CREATE TABLE test_table
! (COLUMN0 VARCHAR(32),
! COLUMN1 VARCHAR(32),
! COLUMN2 VARCHAR(32),
! COLUMN3 VARCHAR(32)) TYPE = InnoDB;
-----------------------------------------------------------------------------
***************
*** 13,16 ****
--- 14,18 ----
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS second_table;
CREATE TABLE second_table
(COLUMN0 VARCHAR(32),
***************
*** 23,26 ****
--- 25,29 ----
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS empty_table;
CREATE TABLE empty_table
(COLUMN0 VARCHAR(32),
***************
*** 29,48 ****
COLUMN3 VARCHAR(32)) TYPE = InnoDB;
- /*
- -----------------------------------------------------------------------------
- -- ESCAPED TABLE
- -----------------------------------------------------------------------------
-
- CREATE TABLE "ESCAPED TABLE"
- (COLUMN0 VARCHAR(32),
- COLUMN1 VARCHAR(32),
- COLUMN2 VARCHAR(32),
- "COLUMN 3" VARCHAR(32)) TYPE = InnoDB;
- */
-
-----------------------------------------------------------------------------
-- PK_TABLE
-----------------------------------------------------------------------------
CREATE TABLE pk_table
(PK0 NUMERIC(38, 0) NOT NULL,
--- 32,40 ----
COLUMN3 VARCHAR(32)) TYPE = InnoDB;
-----------------------------------------------------------------------------
-- PK_TABLE
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS pk_table;
CREATE TABLE pk_table
(PK0 NUMERIC(38, 0) NOT NULL,
***************
*** 56,61 ****
-----------------------------------------------------------------------------
CREATE TABLE only_pk_table
! (pk0 NUMERIC(38, 0) NOT NULL PRIMARY KEY) TYPE = InnoDB;
-----------------------------------------------------------------------------
--- 48,54 ----
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS only_pk_table;
CREATE TABLE only_pk_table
! (PK0 NUMERIC(38, 0) NOT NULL PRIMARY KEY) TYPE = InnoDB;
-----------------------------------------------------------------------------
***************
*** 63,66 ****
--- 56,60 ----
-----------------------------------------------------------------------------
+ DROP TABLE IF EXISTS empty_multitype_table;
CREATE TABLE empty_multitype_table
(VARCHAR_COL VARCHAR(32),
***************
*** 68,72 ****
TIMESTAMP_COL TIMESTAMP,
VARBINARY_COL VARBINARY(254)) TYPE = InnoDB;
-
-
-
--- 62,63 ----
|
