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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
