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 th...@apache.org on 2003/07/08 22:10:47 UTC
cvs commit: db-ojb/src/test/org/apache/ojb/quick-db OJB.properties OJB.script
thma 2003/07/08 13:10:47
Modified: src/test/org/apache/ojb/quick-db OJB.properties OJB.script
Log:
add latest changes to testdata
Revision Changes Path
1.23 +1 -1 db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties
Index: OJB.properties
===================================================================
RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/quick-db/OJB.properties,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -r1.22 -r1.23
--- OJB.properties 26 Jun 2003 20:59:43 -0000 1.22
+++ OJB.properties 8 Jul 2003 20:10:47 -0000 1.23
@@ -1,5 +1,5 @@
#HSQL database
-#Tue Jun 24 21:06:44 CEST 2003
+#Tue Jul 08 21:33:29 CEST 2003
sql.strict_fk=true
readonly=false
sql.strong_fk=true
1.24 +2 -1 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.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- OJB.script 26 Jun 2003 20:59:43 -0000 1.23
+++ OJB.script 8 Jul 2003 20:10:47 -0000 1.24
@@ -68,7 +68,7 @@
CREATE TABLE EJB_PERSON(PERSON_ID INTEGER NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(80),LAST_NAME VARCHAR(80),GRADE VARCHAR(80))
CREATE TABLE FIELD_CONVERSION_NODE(NODE_ID DECIMAL(15) NOT NULL,NODE_STATE INTEGER NOT NULL,PARENT_UID DECIMAL(15),CONSTRAINT SYS_PK_FIELD_CONVERSION_NODE PRIMARY KEY(NODE_ID,NODE_STATE))
CREATE TABLE CONVERSION_VO(PK_WITH_AUTO INTEGER NOT NULL,PK_WITHOUT_AUTO INTEGER NOT NULL,NORMAL_WITH_AUTO INTEGER,NORMAL_WITHOUT_AUTO INTEGER,CONSTRAINT SYS_PK_CONVERSION_VO PRIMARY KEY(PK_WITH_AUTO,PK_WITHOUT_AUTO))
-CREATE TABLE PERF_ARTICLE(ARTICLE_ID DECIMAL NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DECIMAL,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
+CREATE TABLE PERF_ARTICLE(ARTICLE_ID INTEGER NOT NULL PRIMARY KEY,ARTICLE_NAME VARCHAR(150),MINIMUM_STOCK INTEGER,PRICE DOUBLE,UNIT VARCHAR(20),STOCK INTEGER,SUPPLIER_ID INTEGER,PRODUCT_GROUP_ID INTEGER)
CREATE TABLE CACHE_TEST(OBJ_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100))
CREATE TABLE REF_REPOSITORY(REP_ID INTEGER NOT NULL PRIMARY KEY,REF_FK INTEGER,REFA_FK INTEGER,REFB_FK INTEGER,NAME VARCHAR(100))
CREATE TABLE REF_REPOSITORY_FK(REP_ID INTEGER NOT NULL,REF_FK INTEGER NOT NULL,REFA_FK INTEGER NOT NULL,REFB_FK INTEGER NOT NULL,NAME VARCHAR(100),CONSTRAINT SYS_PK_REF_REPOSITORY_FK PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK))
@@ -82,6 +82,7 @@
CREATE TABLE ABSTRACT_COLLECTION_Z(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),SOMEVALUE INTEGER)
CREATE TABLE ABSTRACT_COLLECTION_ZZ(OBJ_ID INTEGER NOT NULL PRIMARY KEY,CONTAINER_ID INTEGER,NAME VARCHAR(150),ZZ_NAME VARCHAR(150),SOMEVALUE INTEGER)
CREATE TABLE ABSTRACT_COLLECTION_CONTAINER(OBJ_ID INTEGER NOT NULL PRIMARY KEY)
+CREATE TABLE NESTED_FIELDS_TAB(OBJ_ID DECIMAL NOT NULL PRIMARY KEY,NAME VARCHAR(150),NESTED_VALUE VARCHAR(150),NESTED_DESCRIPTION VARCHAR(150))
CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org