-- ------------------------------------------------------------------- Michael Watzek [EMAIL PROTECTED] Engineering GmbH mailto:[EMAIL PROTECTED] Buelowstr. 66 Tel.: ++49/30/235 520 36 10783 Berlin - Germany Fax.: ++49/30/217 520 12 http://www.spree.de/ -------------------------------------------------------------------
Index: test/sql/derby/applicationidentity/schema.sql =================================================================== --- test/sql/derby/applicationidentity/schema.sql (revision 209442) +++ test/sql/derby/applicationidentity/schema.sql (working copy) @@ -62,6 +62,99 @@ ); ------------------------- +-- singlefieldidentity +------------------------- + +DROP TABLE PCPointSingleFieldPrimitivebyte; +DROP TABLE PCPointSingleFieldByte; +DROP TABLE PCPointSingleFieldPrimitivechar; +DROP TABLE PCPointSingleFieldCharacter; +DROP TABLE PCPointSingleFieldPrimitiveint; +DROP TABLE PCPointSingleFieldInteger; +DROP TABLE PCPointSingleFieldPrimitivelong; +DROP TABLE PCPointSingleFieldLong; +DROP TABLE PCPointSingleFieldPrimitiveshort; +DROP TABLE PCPointSingleFieldShort; +DROP TABLE PCPointSingleFieldString; + +CREATE TABLE PCPointSingleFieldPrimitivebyte ( + ID DECIMAL(1) NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFPb_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldByte ( + ID DECIMAL(1) NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFB_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldPrimitivechar ( + ID CHAR(2) NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFPc_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldCharacter ( + ID CHAR(2) NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFC_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldPrimitiveint ( + ID INTEGER NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFPi_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldInteger ( + ID INTEGER NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFI_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldPrimitivelong ( + ID BIGINT NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFPl_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldLong ( + ID BIGINT NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFL_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldPrimitiveshort ( + ID SMALLINT NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFPs_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldShort ( + ID SMALLINT NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFS_PK PRIMARY KEY (ID) +); + +CREATE TABLE PCPointSingleFieldString ( + ID VARCHAR(20) NOT NULL, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_SFSTR_PK PRIMARY KEY (ID) +); + +------------------------- -- company -------------------------
