[dbunit-commit] dbunit/src/sql mysql.sql,1.2,1.3

[<mla...@us...>]

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 ----