db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r526905 - in /db/jdo/trunk/tck20/src/sql/derby: applicationidentity/ datastoreidentity/
Date Mon, 09 Apr 2007 20:43:06 GMT
Author: mcaisse
Date: Mon Apr  9 13:43:00 2007
New Revision: 526905

URL: http://svn.apache.org/viewvc?view=rev&rev=526905
Log:
JDO-480 VARCHAR -> TIMESTAMP; also fixed line endings on some files.

Modified:
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema1.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema10.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema2.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema3.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema4.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema5.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema6.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema7.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema8.sql
    db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema9.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema1.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema10.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema2.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema3.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema4.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema8.sql
    db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema.sql Mon Apr  9 13:43:00 2007
@@ -218,7 +218,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -244,14 +244,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema1.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema1.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema1.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema1.sql Mon Apr  9 13:43:00 2007
@@ -50,7 +50,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -73,7 +73,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -85,7 +85,7 @@
 
 CREATE TABLE employees (
     PERSONID INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema10.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema10.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema10.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema10.sql Mon Apr  9 13:43:00
2007
@@ -38,7 +38,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     CONSTRAINT COMPS_PK PRIMARY KEY (ID)
 );
 
@@ -57,10 +57,10 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     DISCRIMINATOR varchar(64) NOT NULL,
     ORDER_COL INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema2.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema2.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema2.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema2.sql Mon Apr  9 13:43:00 2007
@@ -58,7 +58,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -81,7 +81,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -96,14 +96,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
@@ -119,14 +119,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema3.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema3.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema3.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema3.sql Mon Apr  9 13:43:00 2007
@@ -51,7 +51,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -74,7 +74,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -86,7 +86,7 @@
 
 CREATE TABLE parttimeemployees (
     PERSONID INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,
@@ -100,7 +100,7 @@
 
 CREATE TABLE fulltimeemployees (
     PERSONID INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema4.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema4.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema4.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema4.sql Mon Apr  9 13:43:00 2007
@@ -46,7 +46,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -69,7 +69,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -81,7 +81,7 @@
 
 CREATE TABLE employees (
     PERSONID INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema5.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema5.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema5.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema5.sql Mon Apr  9 13:43:00 2007
@@ -13,23 +13,23 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
--- SchemaType: application identity orm
-
-connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
-
-CREATE SCHEMA applicationidentity_orm;
-SET SCHEMA applicationidentity_orm;
-
--------------------------
--- mylib
--------------------------
-
-DROP TABLE PCPoint;
-
-CREATE TABLE PCPoint (
-    ID BIGINT NOT NULL,
-    X INTEGER NOT NULL,
-    Y INTEGER,
-    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
-);
-
+-- SchemaType: application identity orm
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA applicationidentity_orm;
+SET SCHEMA applicationidentity_orm;
+
+-------------------------
+-- mylib
+-------------------------
+
+DROP TABLE PCPoint;
+
+CREATE TABLE PCPoint (
+    ID BIGINT NOT NULL,
+    X INTEGER NOT NULL,
+    Y INTEGER,
+    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
+);
+

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema6.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema6.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema6.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema6.sql Mon Apr  9 13:43:00 2007
@@ -13,23 +13,23 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
--- SchemaType: application identity pkg
-
-connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
-
-CREATE SCHEMA applicationidentity_pkg;
-SET SCHEMA applicationidentity_pkg;
-
--------------------------
--- mylib
--------------------------
-
-DROP TABLE PCPoint;
-
-CREATE TABLE PCPoint (
-    ID BIGINT NOT NULL,
-    X INTEGER NOT NULL,
-    Y INTEGER,
-    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
-);
-
+-- SchemaType: application identity pkg
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA applicationidentity_pkg;
+SET SCHEMA applicationidentity_pkg;
+
+-------------------------
+-- mylib
+-------------------------
+
+DROP TABLE PCPoint;
+
+CREATE TABLE PCPoint (
+    ID BIGINT NOT NULL,
+    X INTEGER NOT NULL,
+    Y INTEGER,
+    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
+);
+

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema7.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema7.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema7.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema7.sql Mon Apr  9 13:43:00 2007
@@ -13,23 +13,23 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
--- SchemaType: application identity cls
-
-connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
-
-CREATE SCHEMA applicationidentity_cls;
-SET SCHEMA applicationidentity_cls;
-
--------------------------
--- mylib
--------------------------
-
-DROP TABLE PCPoint;
-
-CREATE TABLE PCPoint (
-    ID BIGINT NOT NULL,
-    X INTEGER NOT NULL,
-    Y INTEGER,
-    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
-);
-
+-- SchemaType: application identity cls
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA applicationidentity_cls;
+SET SCHEMA applicationidentity_cls;
+
+-------------------------
+-- mylib
+-------------------------
+
+DROP TABLE PCPoint;
+
+CREATE TABLE PCPoint (
+    ID BIGINT NOT NULL,
+    X INTEGER NOT NULL,
+    Y INTEGER,
+    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
+);
+

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema8.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema8.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema8.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema8.sql Mon Apr  9 13:43:00 2007
@@ -13,51 +13,51 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
--- SchemaType: application identity
-
-connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
-
-CREATE SCHEMA applicationidentity8;
-SET SCHEMA applicationidentity8;
-
-DROP TABLE CART_ENTRIES;
-DROP TABLE CARTS;
-DROP TABLE PRODUCTS;
-DROP TABLE UNDETACHABLES;
-
-CREATE TABLE CARTS (
-    CART_ID BIGINT NOT NULL,
-    CUSTOMER_ID VARCHAR(128) NOT NULL,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT CARTS_PK PRIMARY KEY (CART_ID)
-);
-
-CREATE TABLE PRODUCTS (
-    SKU VARCHAR(48) NOT NULL,
-    DESCRIPTION VARCHAR(128),
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT PRODUCTS_PK PRIMARY KEY (SKU)
-);
-
-CREATE TABLE CART_ENTRIES (
-    ID BIGINT NOT NULL,
-    QUANTITY INTEGER DEFAULT 0,
-    CART_ID BIGINT NOT NULL,
-    SKU VARCHAR(48) NOT NULL,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT CART_ENTRIES_PK  PRIMARY KEY (ID),
-    CONSTRAINT CARTS_FK         FOREIGN KEY (CART_ID)   REFERENCES CARTS,
-    CONSTRAINT PRODUCTS_FK      FOREIGN KEY (SKU)       REFERENCES PRODUCTS
-);
-
-CREATE TABLE UNDETACHABLES (
-    ID BIGINT NOT NULL,
-    FOO INTEGER,
-    BAR INTEGER,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT UNDETACHABLES_PK PRIMARY KEY (ID)
-);
+-- SchemaType: application identity
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA applicationidentity8;
+SET SCHEMA applicationidentity8;
+
+DROP TABLE CART_ENTRIES;
+DROP TABLE CARTS;
+DROP TABLE PRODUCTS;
+DROP TABLE UNDETACHABLES;
+
+CREATE TABLE CARTS (
+    CART_ID BIGINT NOT NULL,
+    CUSTOMER_ID VARCHAR(128) NOT NULL,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT CARTS_PK PRIMARY KEY (CART_ID)
+);
+
+CREATE TABLE PRODUCTS (
+    SKU VARCHAR(48) NOT NULL,
+    DESCRIPTION VARCHAR(128),
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT PRODUCTS_PK PRIMARY KEY (SKU)
+);
+
+CREATE TABLE CART_ENTRIES (
+    ID BIGINT NOT NULL,
+    QUANTITY INTEGER DEFAULT 0,
+    CART_ID BIGINT NOT NULL,
+    SKU VARCHAR(48) NOT NULL,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT CART_ENTRIES_PK  PRIMARY KEY (ID),
+    CONSTRAINT CARTS_FK         FOREIGN KEY (CART_ID)   REFERENCES CARTS,
+    CONSTRAINT PRODUCTS_FK      FOREIGN KEY (SKU)       REFERENCES PRODUCTS
+);
+
+CREATE TABLE UNDETACHABLES (
+    ID BIGINT NOT NULL,
+    FOO INTEGER,
+    BAR INTEGER,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT UNDETACHABLES_PK PRIMARY KEY (ID)
+);

Modified: db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema9.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema9.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema9.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/applicationidentity/schema9.sql Mon Apr  9 13:43:00 2007
@@ -38,7 +38,7 @@
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     CONSTRAINT COMPS_PK PRIMARY KEY (ID)
 );
 
@@ -57,10 +57,10 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     DISCRIMINATOR varchar(64) NOT NULL,
     ROLE VARCHAR(32),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema.sql Mon Apr  9 13:43:00 2007
@@ -145,7 +145,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -173,14 +173,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema1.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema1.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema1.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema1.sql Mon Apr  9 13:43:00 2007
@@ -51,7 +51,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -78,7 +78,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -91,7 +91,7 @@
 
 CREATE TABLE employees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema10.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema10.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema10.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema10.sql Mon Apr  9 13:43:00 2007
@@ -39,7 +39,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     CONSTRAINT COMPS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 
@@ -60,10 +60,10 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     DISCRIMINATOR varchar(64) NOT NULL,
     ORDER_COL INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema2.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema2.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema2.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema2.sql Mon Apr  9 13:43:00 2007
@@ -59,7 +59,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -86,7 +86,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -103,14 +103,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,
@@ -138,14 +138,14 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
     STATE CHAR(2),
     ZIPCODE CHAR(5),
     COUNTRY VARCHAR(64),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema3.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema3.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema3.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema3.sql Mon Apr  9 13:43:00 2007
@@ -52,7 +52,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -79,7 +79,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAM, NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -92,7 +92,7 @@
 
 CREATE TABLE parttimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,
@@ -117,7 +117,7 @@
 
 CREATE TABLE fulltimeemployees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER REFERENCES departments,
     FUNDINGDEPT INTEGER REFERENCES departments,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema4.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema4.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema4.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema4.sql Mon Apr  9 13:43:00 2007
@@ -47,7 +47,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -74,7 +74,7 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     ADDRID INTEGER,
     STREET VARCHAR(64),
     CITY VARCHAR(64),
@@ -87,7 +87,7 @@
 
 CREATE TABLE employees (
     DATASTORE_IDENTITY INTEGER NOT NULL,
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS DOUBLE,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema8.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema8.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema8.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema8.sql Mon Apr  9 13:43:00 2007
@@ -13,63 +13,63 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
--- SchemaType: datastore identity
-
-connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
-
-CREATE SCHEMA datastoreidentity8;
-SET SCHEMA datastoreidentity8;
-
-DROP TABLE CART_ENTRIES;
-DROP TABLE CARTS;
-DROP TABLE PRODUCTS;
-DROP TABLE UNDETACHABLES;
-
-CREATE TABLE CARTS (
-
-    DATASTORE_ID BIGINT NOT NULL,
-    CART_ID BIGINT NOT NULL,
-    CUSTOMER_ID VARCHAR(128) NOT NULL,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT CARTS_PK PRIMARY KEY (DATASTORE_ID),
-    CONSTRAINT CARTS_UK UNIQUE      (CART_ID)
-);
-
-CREATE TABLE PRODUCTS (
-
-    DATASTORE_ID VARCHAR(48) NOT NULL,
-    SKU VARCHAR(48) NOT NULL,
-    DESCRIPTION VARCHAR(128),
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT PRODUCTS_PK  PRIMARY KEY  (DATASTORE_ID),
-    CONSTRAINT PRODUCTS_UK  UNIQUE       (SKU)
-);
-
-CREATE TABLE CART_ENTRIES (
-
-    DATASTORE_ID BIGINT NOT NULL,
-    ID BIGINT NOT NULL,
-    QUANTITY INTEGER DEFAULT 0,
-    CART_ID BIGINT NOT NULL,
-    SKU VARCHAR(48) NOT NULL,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT CART_ENTRIES_PK  PRIMARY KEY (DATASTORE_ID),
-    CONSTRAINT CART_ENTRIES_UK  UNIQUE      (ID),
-    CONSTRAINT CARTS_FK         FOREIGN KEY (CART_ID)   REFERENCES CARTS,
-    CONSTRAINT PRODUCTS_FK      FOREIGN KEY (SKU)       REFERENCES PRODUCTS
-);
-
-CREATE TABLE UNDETACHABLES (
-
-    DATASTORE_ID BIGINT NOT NULL,
-    ID BIGINT NOT NULL,
-    FOO INTEGER,
-    BAR INTEGER,
-    VERSION INTEGER NOT NULL DEFAULT 0,
-
-    CONSTRAINT UNDETACHABLES_PK PRIMARY KEY (DATASTORE_ID),
-    CONSTRAINT UNDETACHABLES_UK UNIQUE      (ID)
-);
+-- SchemaType: datastore identity
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA datastoreidentity8;
+SET SCHEMA datastoreidentity8;
+
+DROP TABLE CART_ENTRIES;
+DROP TABLE CARTS;
+DROP TABLE PRODUCTS;
+DROP TABLE UNDETACHABLES;
+
+CREATE TABLE CARTS (
+
+    DATASTORE_ID BIGINT NOT NULL,
+    CART_ID BIGINT NOT NULL,
+    CUSTOMER_ID VARCHAR(128) NOT NULL,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT CARTS_PK PRIMARY KEY (DATASTORE_ID),
+    CONSTRAINT CARTS_UK UNIQUE      (CART_ID)
+);
+
+CREATE TABLE PRODUCTS (
+
+    DATASTORE_ID VARCHAR(48) NOT NULL,
+    SKU VARCHAR(48) NOT NULL,
+    DESCRIPTION VARCHAR(128),
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT PRODUCTS_PK  PRIMARY KEY  (DATASTORE_ID),
+    CONSTRAINT PRODUCTS_UK  UNIQUE       (SKU)
+);
+
+CREATE TABLE CART_ENTRIES (
+
+    DATASTORE_ID BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    QUANTITY INTEGER DEFAULT 0,
+    CART_ID BIGINT NOT NULL,
+    SKU VARCHAR(48) NOT NULL,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT CART_ENTRIES_PK  PRIMARY KEY (DATASTORE_ID),
+    CONSTRAINT CART_ENTRIES_UK  UNIQUE      (ID),
+    CONSTRAINT CARTS_FK         FOREIGN KEY (CART_ID)   REFERENCES CARTS,
+    CONSTRAINT PRODUCTS_FK      FOREIGN KEY (SKU)       REFERENCES PRODUCTS
+);
+
+CREATE TABLE UNDETACHABLES (
+
+    DATASTORE_ID BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    FOO INTEGER,
+    BAR INTEGER,
+    VERSION INTEGER NOT NULL DEFAULT 0,
+
+    CONSTRAINT UNDETACHABLES_PK PRIMARY KEY (DATASTORE_ID),
+    CONSTRAINT UNDETACHABLES_UK UNIQUE      (ID)
+);

Modified: db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql?view=diff&rev=526905&r1=526904&r2=526905
==============================================================================
--- db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql (original)
+++ db/jdo/trunk/tck20/src/sql/derby/datastoreidentity/schema9.sql Mon Apr  9 13:43:00 2007
@@ -39,7 +39,7 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     ID INTEGER NOT NULL,
     NAME VARCHAR(32) NOT NULL,
-    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    FOUNDEDDATE TIMESTAMP NOT NULL,
     CONSTRAINT COMPS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 
@@ -60,10 +60,10 @@
     FIRSTNAME VARCHAR(32) NOT NULL,
     LASTNAME VARCHAR(32) NOT NULL,
     MIDDLENAME VARCHAR(32),
-    BIRTHDATE VARCHAR(32) NOT NULL,
+    BIRTHDATE TIMESTAMP NOT NULL,
     DISCRIMINATOR varchar(64) NOT NULL,
     ROLE VARCHAR(32),
-    HIREDATE VARCHAR(32),
+    HIREDATE TIMESTAMP,
     WEEKLYHOURS REAL,
     DEPARTMENT INTEGER,
     FUNDINGDEPT INTEGER,



Mime
View raw message