You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by ar...@apache.org on 2005/12/05 16:05:59 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.script
arminw 2005/12/05 07:05:58
Modified: src/test/org/apache/ojb/quick-db Tag: OJB_1_0_RELEASE
OJB.script
Log:
update hsql quick-DB script
Revision Changes Path
No revision
No revision
1.33.2.4 +24 -21 db-ojb/src/test/org/apache/ojb/quick-db/OJB.script
Index: OJB.script
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/quick-db/OJB.script,v
retrieving revision 1.33.2.3
retrieving revision 1.33.2.4
diff -u -r1.33.2.3 -r1.33.2.4
--- OJB.script 3 Nov 2005 13:13:31 -0000 1.33.2.3
+++ OJB.script 5 Dec 2005 15:05:49 -0000 1.33.2.4
@@ -15,7 +15,6 @@
CREATE MEMORY TABLE FAMILY_MEMBER(ID INTEGER NOT NULL PRIMARY KEY,FIRSTNAME VARCHAR(150),LASTNAME VARCHAR(150),MOTHER_ID INTEGER,FATHER_ID INTEGER)
CREATE MEMORY TABLE LOCKED_BY_VERSION(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),VERSION_ INTEGER)
CREATE MEMORY TABLE LOCKED_BY_TIMESTAMP(ID INTEGER NOT NULL PRIMARY KEY,VALUE_ VARCHAR(150),TIMESTAMP_ TIMESTAMP)
-CREATE MEMORY TABLE BLOB_TEST(ID INTEGER NOT NULL PRIMARY KEY,BLOB_VALUE_ LONGVARBINARY,CLOB_VALUE_ VARCHAR)
CREATE MEMORY TABLE CHARACTER_TEST(ID INTEGER NOT NULL PRIMARY KEY,CHAR_1 VARCHAR(1),CHAR_10 VARCHAR(10),VARCHAR_1 VARCHAR(1),VARCHAR_10 VARCHAR(10))
CREATE MEMORY TABLE MDTEST_MASTER(MASTERID INTEGER NOT NULL PRIMARY KEY,MASTER_TEXT VARCHAR(255))
CREATE MEMORY TABLE MDTEST_DETAIL_FKINPK(MASTERID INTEGER NOT NULL,DETAILID INTEGER NOT NULL,DETAIL_TEXT VARCHAR(255),PRIMARY KEY(MASTERID,DETAILID),CONSTRAINT MDTEST_DETAIL_FKINPK_FK_1 FOREIGN KEY(MASTERID) REFERENCES MDTEST_MASTER(MASTERID))
@@ -48,15 +47,16 @@
CREATE MEMORY TABLE GUIDTEST(GUID_ VARCHAR(60) NOT NULL PRIMARY KEY,GUIDVALUE VARCHAR(60))
CREATE MEMORY TABLE CONV_REFERER(PK1 INTEGER NOT NULL PRIMARY KEY,REF1 INTEGER,TEST_ID INTEGER)
CREATE MEMORY TABLE CONV_REFERED(PK1 INTEGER NOT NULL PRIMARY KEY,TEST_ID INTEGER)
-CREATE MEMORY TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_95 UNIQUE(NAME))
+CREATE MEMORY TABLE SITE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),SITEYEAR INTEGER,SEMESTER INTEGER,CONSTRAINT SYS_CT_94 UNIQUE(NAME))
CREATE MEMORY TABLE ODMG_DLIST(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),RND_NAME VARCHAR(100))
CREATE MEMORY TABLE ROLLBACK_ONE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
CREATE MEMORY TABLE ROLLBACK_TWO(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(100))
CREATE MEMORY TABLE NEWS(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50))
CREATE MEMORY TABLE PAPER(ID INTEGER NOT NULL PRIMARY KEY,HEADLINE VARCHAR(50),ISSUEDATE VARCHAR(50),AUTHOR VARCHAR(50))
CREATE MEMORY TABLE TOPIC(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),IMPORTANCE VARCHAR(50))
+CREATE MEMORY TABLE TOPIC_EXT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),IMPORTANCE VARCHAR(50),DESCRIPTION VARCHAR(50))
CREATE MEMORY TABLE CATEGORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION VARCHAR(50))
-CREATE MEMORY TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50))
+CREATE MEMORY TABLE AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(50),DESCRIPTION VARCHAR(50))
CREATE MEMORY TABLE CONTENT_QUALIFIER(CONTENT_ID INTEGER NOT NULL,QUALIFIER_ID INTEGER NOT NULL,PRIMARY KEY(CONTENT_ID,QUALIFIER_ID))
CREATE MEMORY TABLE SM_TAB_A(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
CREATE MEMORY TABLE SM_TAB_AA(SM_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
@@ -106,10 +106,12 @@
CREATE MEMORY TABLE READTEST_ARTICLE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),DESCRIPTION VARCHAR(150),FK_REF INTEGER)
CREATE MEMORY TABLE READTEST_ADDRESS(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
CREATE MEMORY TABLE READTEST_ADDRESS_TYPE(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),FK_REF INTEGER)
-CREATE MEMORY TABLE M2N_TEST_ACTOR(OBJ_ID INTEGER NOT NULL,OBJ_ID2 INTEGER NOT NULL,NAME VARCHAR(150),PRIMARY KEY(OBJ_ID,OBJ_ID2))
-CREATE MEMORY TABLE M2N_TEST_MOVIE(OBJ_ID_INT INTEGER NOT NULL,OBJ_ID2_INT INTEGER NOT NULL,OBJ_ID_STR VARCHAR(150) NOT NULL,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250),PRIMARY KEY(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
-CREATE MEMORY TABLE M2N_TEST_ROLE(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_TEST_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
-CREATE MEMORY TABLE M2N_TEST_ROLE_2(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_TEST_ROLE_2_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_TEST_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_TEST_ROLE_2_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_TEST_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE MEMORY TABLE M2N_ACTOR(OBJ_ID INTEGER NOT NULL,OBJ_ID2 INTEGER NOT NULL,NAME VARCHAR(150),PRIMARY KEY(OBJ_ID,OBJ_ID2))
+CREATE MEMORY TABLE M2N_MOVIE(OBJ_ID_INT INTEGER NOT NULL,OBJ_ID2_INT INTEGER NOT NULL,OBJ_ID_STR VARCHAR(150) NOT NULL,TITLE VARCHAR(150),DESCRIPTION VARCHAR(250),PRIMARY KEY(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE MEMORY TABLE M2N_ROLE(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_ROLE_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_ROLE_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE MEMORY TABLE M2N_ROLE_2(ACTOR_ID INTEGER NOT NULL,ACTOR_ID2 INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,MOVIE_ID_STR VARCHAR(150) NOT NULL,PRIMARY KEY(ACTOR_ID,ACTOR_ID2,MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR),CONSTRAINT M2N_ROLE_2_FK_1 FOREIGN KEY(ACTOR_ID,ACTOR_ID2) REFERENCES M2N_ACTOR(OBJ_ID,OBJ_ID2),CONSTRAINT M2N_ROLE_2_FK_2 FOREIGN KEY(MOVIE_ID_INT,MOVIE_ID2_INT,MOVIE_ID_STR) REFERENCES M2N_MOVIE(OBJ_ID_INT,OBJ_ID2_INT,OBJ_ID_STR))
+CREATE MEMORY TABLE M2N_PRODUCER(ID_ INTEGER NOT NULL,ID_STR VARCHAR(150) NOT NULL,NAME VARCHAR(150),PRIMARY KEY(ID_,ID_STR))
+CREATE MEMORY TABLE M2N_MOVIE_PRODUCER(PRODUCER_ID INTEGER NOT NULL,MOVIE_ID_INT INTEGER NOT NULL,MOVIE_ID2_INT INTEGER NOT NULL,ID_STR_SHARED VARCHAR(150) NOT NULL,PRIMARY KEY(PRODUCER_ID,MOVIE_ID_INT,MOVIE_ID2_INT,ID_STR_SHARED))
CREATE MEMORY TABLE M2N_OFFICE(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
CREATE MEMORY TABLE M2N_OFFICE_COUNTY(OFFICE_ID INTEGER NOT NULL,COUNTY_ID VARCHAR(150) NOT NULL,PRIMARY KEY(OFFICE_ID,COUNTY_ID))
CREATE MEMORY TABLE M2N_COUNTY(OBJ_ID VARCHAR(150) NOT NULL PRIMARY KEY,NAME VARCHAR(150))
@@ -139,8 +141,8 @@
CREATE MEMORY TABLE ABSTRACT_COL_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
CREATE MEMORY TABLE XCONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
CREATE MEMORY TABLE COL_BOOKSHELFS(PK INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
-CREATE MEMORY TABLE COL_BOOKS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
-CREATE MEMORY TABLE COL_DVDS(PK INTEGER NOT NULL,BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
+CREATE MEMORY TABLE COL_BOOKS(PK INTEGER NOT NULL,NAME VARCHAR(100),BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
+CREATE MEMORY TABLE COL_DVDS(PK INTEGER NOT NULL,NAME VARCHAR(100),BOOKSHELF_FK INTEGER NOT NULL,PRIMARY KEY(PK,BOOKSHELF_FK))
CREATE MEMORY TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL(15) NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
CREATE MEMORY TABLE NESTED_FIELDS_ENTRY(OBJ_ID INTEGER NOT NULL PRIMARY KEY,FK_ID DECIMAL(15),NAME VARCHAR(150))
CREATE MEMORY TABLE TAB_COMPONENT(PK_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150),PARENT_ID INTEGER,CHILD_ID INTEGER,GROUP_ID INTEGER)
@@ -168,15 +170,15 @@
CREATE MEMORY TABLE IC_PUBLISHER(OJB_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),OJB_VERSION INTEGER)
CREATE MEMORY TABLE IC_PUBLICATION(BOOK_ID INTEGER NOT NULL,AUTHOR_ID INTEGER NOT NULL,PRIMARY KEY(BOOK_ID,AUTHOR_ID))
CREATE MEMORY TABLE IC_REVIEW(OJB_ID INTEGER NOT NULL PRIMARY KEY,SUMMARY VARCHAR(250),FK_BOOK INTEGER,OJB_VERSION INTEGER,AUTHOR_FK INTEGER)
-CREATE MEMORY TABLE CT_SHOP(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),DETAIL_FK INTEGER)
CREATE MEMORY TABLE CT_DETAIL(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER)
+CREATE MEMORY TABLE CT_SHOP(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),DETAIL_FK INTEGER,CONSTRAINT CT_SHOP_FK_1 FOREIGN KEY(DETAIL_FK) REFERENCES CT_DETAIL(OBJ_ID))
CREATE MEMORY TABLE CT_DISTRIBUTOR(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
CREATE MEMORY TABLE CT_PRODUCT(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),SHOP_FK INTEGER,SUB_PRODUCT_FK INTEGER,CONSTRAINT CT_PRODUCT_FK_1 FOREIGN KEY(SUB_PRODUCT_FK) REFERENCES CT_PRODUCT(OBJ_ID),CONSTRAINT CT_PRODUCT_FK_2 FOREIGN KEY(SHOP_FK) REFERENCES CT_SHOP(OBJ_ID))
CREATE MEMORY TABLE CT_SHOP_DISTRIBUTOR(SHOP_ID INTEGER,DISTRIBUTOR_ID INTEGER,CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_1 FOREIGN KEY(SHOP_ID) REFERENCES CT_SHOP(OBJ_ID),CONSTRAINT CT_SHOP_DISTRIBUTOR_FK_2 FOREIGN KEY(DISTRIBUTOR_ID) REFERENCES CT_DISTRIBUTOR(OBJ_ID))
-CREATE MEMORY TABLE CT_OBJECT_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
-CREATE MEMORY TABLE CT_OBJECT_AA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
-CREATE MEMORY TABLE CT_OBJECT_AAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,FK_ID_A INTEGER)
CREATE MEMORY TABLE CT_OBJECT_AAAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER)
+CREATE MEMORY TABLE CT_OBJECT_AAA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,FK_ID_A INTEGER,CONSTRAINT CT_OBJECT_AAA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAAA(OBJ_ID))
+CREATE MEMORY TABLE CT_OBJECT_AA(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,CONSTRAINT CT_OBJECT_AA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAA(OBJ_ID))
+CREATE MEMORY TABLE CT_OBJECT_A(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),FK_ID INTEGER,CONSTRAINT CT_OBJECT_A_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AA(OBJ_ID))
CREATE MEMORY TABLE CRT_EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(150))
CREATE MEMORY TABLE CRT_MEMBER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_MEMBER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
CREATE MEMORY TABLE CRT_LEADER(ROLE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_ID INTEGER,NAME VARCHAR(150),CONSTRAINT CRT_LEADER_FK_1 FOREIGN KEY(EMPLOYEE_ID) REFERENCES CRT_EMPLOYEE(EMPLOYEE_ID))
@@ -193,6 +195,7 @@
CREATE MEMORY TABLE P_B_TABLE(ID BIGINT NOT NULL PRIMARY KEY,B_ATTRIB INTEGER,A_ID BIGINT,CONSTRAINT P_B_TABLE_FK_1 FOREIGN KEY(A_ID) REFERENCES P_A_TABLE(ID))
CREATE MEMORY TABLE P_C_TABLE(ID BIGINT NOT NULL PRIMARY KEY,C_ATTRIB INTEGER,C1_ATTRIB INTEGER,B_ID BIGINT,D_ID BIGINT,CONSTRAINT P_C_TABLE_FK_1 FOREIGN KEY(B_ID) REFERENCES P_B_TABLE(ID))
CREATE MEMORY TABLE P_D_TABLE(ID BIGINT NOT NULL PRIMARY KEY,D_ATTRIB INTEGER)
+CREATE MEMORY TABLE EMPTY_TABLE(ID_ INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250))
CREATE MEMORY TABLE OJB_HL_SEQ(TABLENAME VARCHAR(250) NOT NULL PRIMARY KEY,MAX_KEY BIGINT,GRAB_SIZE INTEGER,VERSION INTEGER)
CREATE MEMORY TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
CREATE MEMORY TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
@@ -200,11 +203,7 @@
CREATE MEMORY TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
CREATE MEMORY TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
CREATE MEMORY TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE MEMORY TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
-ALTER TABLE CT_SHOP ADD CONSTRAINT CT_SHOP_FK_1 FOREIGN KEY(DETAIL_FK) REFERENCES CT_DETAIL(OBJ_ID)
-ALTER TABLE CT_OBJECT_A ADD CONSTRAINT CT_OBJECT_A_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AA(OBJ_ID)
-ALTER TABLE CT_OBJECT_AA ADD CONSTRAINT CT_OBJECT_AA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAA(OBJ_ID)
-ALTER TABLE CT_OBJECT_AAA ADD CONSTRAINT CT_OBJECT_AAA_FK_1 FOREIGN KEY(FK_ID) REFERENCES CT_OBJECT_AAAA(OBJ_ID)
+CREATE MEMORY TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
@@ -353,15 +352,19 @@
INSERT INTO PAPER VALUES(11,'SALES','yesterday','SALES MAN')
INSERT INTO TOPIC VALUES(10,'Buyers','important')
INSERT INTO TOPIC VALUES(11,'Sellers','unimportant')
+INSERT INTO TOPIC_EXT VALUES(30,'Buyers_Ext','important','The buyer')
+INSERT INTO TOPIC_EXT VALUES(31,'Sellers_Ext','unimportant','The seller')
INSERT INTO CATEGORY VALUES(1,'Cars','The cars category')
INSERT INTO CATEGORY VALUES(2,'Sports',NULL)
-INSERT INTO AREA VALUES(20,'Human')
-INSERT INTO AREA VALUES(21,'NotHuman')
+INSERT INTO AREA VALUES(20,'Human',NULL)
+INSERT INTO AREA VALUES(21,'NotHuman',NULL)
INSERT INTO CONTENT_QUALIFIER VALUES(2,1)
INSERT INTO CONTENT_QUALIFIER VALUES(2,10)
+INSERT INTO CONTENT_QUALIFIER VALUES(2,30)
INSERT INTO CONTENT_QUALIFIER VALUES(3,2)
INSERT INTO CONTENT_QUALIFIER VALUES(10,20)
INSERT INTO CONTENT_QUALIFIER VALUES(11,11)
+INSERT INTO CONTENT_QUALIFIER VALUES(11,31)
INSERT INTO SM_TAB_MAX_A VALUES(120,'A')
INSERT INTO SM_TAB_MAX_A VALUES(121,'A')
INSERT INTO SM_TAB_MAX_AA VALUES(101,'AA')
@@ -371,4 +374,4 @@
INSERT INTO SM_TAB_MAX_B VALUES(115,'B')
INSERT INTO SM_TAB_MAX_B VALUES(116,'B')
INSERT INTO SM_TAB_MAX_BB VALUES(130,'BB')
-INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
+INSERT INTO SM_TAB_MAX_BB VALUES(131,'BB')
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org