Author: roberto
Date: Wed Mar 29 20:52:58 2006
New Revision: 389989
URL: http://svn.apache.org/viewcvs?rev=389989&view=rev
Log:
~Updating C# DataMapper test Oracle scripts
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/Nullable-init.sql
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/simple-init.sql
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/DataBase.sql
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/DataBase.sql
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/DataBase.sql?rev=389989&r1=389988&r2=389989&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/DataBase.sql
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/DataBase.sql
Wed Mar 29 20:52:58 2006
@@ -31,8 +31,14 @@
DROP TABLE DOCUMENTS CASCADE CONSTRAINTS;
+DROP TABLE SIMPLES CASCADE CONSTRAINTS;
+
+DROP TABLE NULLABLE CASCADE CONSTRAINTS;
+
DROP SEQUENCE S_CATEGORIES;
+DROP SEQUENCE S_NULLABLE;
+
CREATE SEQUENCE S_CATEGORIES
START WITH 1
MAXVALUE 1E27
@@ -41,6 +47,14 @@
CACHE 20
NOORDER;
+CREATE SEQUENCE S_NULLABLE
+ START WITH 1
+ MAXVALUE 1E27
+ MINVALUE 1
+ NOCYCLE
+ CACHE 20
+ NOORDER;
+
/*==============================================================*/
/* Table : ACCOUNTS */
/*==============================================================*/
@@ -246,3 +260,46 @@
NOLOGGING
NOCACHE
NOPARALLEL;
+
+
+/*==============================================================*/
+/* Table : SIMPLES */
+/*==============================================================*/
+
+
+CREATE TABLE SIMPLES (
+ ID INTEGER NOT NULL,
+ NAME VARCHAR(64) NULL ,
+ ADDRESS VARCHAR(64) NULL ,
+ COUNT INTEGER NULL ,
+ "DATE" DATE NULL,
+ PAY DECIMAL(18,2) NULL,
+ CONSTRAINT PK_SIMPLES PRIMARY KEY (ID)
+)
+NOLOGGING
+NOCACHE
+NOPARALLEL;
+
+
+/*==============================================================*/
+/* Table : NULLABLE */
+/*==============================================================*/
+
+CREATE TABLE NULLABLE (
+ ID INTEGER NOT NULL,
+ TESTBOOL SMALLINT NULL ,
+ TESTBYTE SMALLINT NULL ,
+ TESTCHAR CHAR(1) NULL ,
+ TESTDATETIME DATE NULL ,
+ TESTDECIMAL DECIMAL(9,2) NULL ,
+ TESTDOUBLE FLOAT NULL ,
+ TESTGUID VARCHAR2(36) NULL ,
+ TESTINT16 SMALLINT NULL ,
+ TESTINT32 INTEGER NULL ,
+ TESTINT64 NUMBER NULL ,
+ TESTSINGLE REAL NULL ,
+ CONSTRAINT PK_NULLABLE PRIMARY KEY (ID)
+)
+NOLOGGING
+NOCACHE
+NOPARALLEL;
\ No newline at end of file
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/Nullable-init.sql
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/Nullable-init.sql?rev=389989&view=auto
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/Nullable-init.sql
(added)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/Nullable-init.sql
Wed Mar 29 20:52:58 2006
@@ -0,0 +1,30 @@
+DROP TABLE NULLABLE CASCADE CONSTRAINTS;
+
+DROP SEQUENCE S_NULLABLE;
+
+CREATE SEQUENCE S_NULLABLE
+ START WITH 1
+ MAXVALUE 1E27
+ MINVALUE 1
+ NOCYCLE
+ CACHE 20
+ NOORDER;
+
+CREATE TABLE NULLABLE (
+ ID INTEGER NOT NULL,
+ TESTBOOL SMALLINT NULL ,
+ TESTBYTE SMALLINT NULL ,
+ TESTCHAR CHAR(1) NULL ,
+ TESTDATETIME DATE NULL ,
+ TESTDECIMAL DECIMAL(9,2) NULL ,
+ TESTDOUBLE FLOAT NULL ,
+ TESTGUID VARCHAR2(36) NULL ,
+ TESTINT16 SMALLINT NULL ,
+ TESTINT32 INTEGER NULL ,
+ TESTINT64 NUMBER NULL ,
+ TESTSINGLE REAL NULL ,
+ CONSTRAINT PK_NULLABLE PRIMARY KEY (ID)
+)
+NOLOGGING
+NOCACHE
+NOPARALLEL;
\ No newline at end of file
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/simple-init.sql
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/simple-init.sql?rev=389989&view=auto
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/simple-init.sql
(added)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/Oracle/simple-init.sql
Wed Mar 29 20:52:58 2006
@@ -0,0 +1,14 @@
+DROP TABLE SIMPLES CASCADE CONSTRAINTS;
+
+CREATE TABLE SIMPLES (
+ ID INTEGER NOT NULL,
+ NAME VARCHAR(64) NULL ,
+ ADDRESS VARCHAR(64) NULL ,
+ COUNT INTEGER NULL ,
+ "DATE" DATE NULL,
+ PAY DECIMAL(18,2) NULL,
+ CONSTRAINT PK_SIMPLES PRIMARY KEY (ID)
+)
+NOLOGGING
+NOCACHE
+NOPARALLEL;
\ No newline at end of file
