You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by we...@apache.org on 2004/02/04 22:47:24 UTC
cvs commit: jakarta-jetspeed-2/portal/src/sql/hsql create-db-phase3-ojb.sql
weaver 2004/02/04 13:47:24
Modified: portal/src/sql/hsql create-db-phase3-ojb.sql
Log:
updated ojb internal tables
Revision Changes Path
1.2 +9 -58 jakarta-jetspeed-2/portal/src/sql/hsql/create-db-phase3-ojb.sql
Index: create-db-phase3-ojb.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/sql/hsql/create-db-phase3-ojb.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- create-db-phase3-ojb.sql 28 Jul 2003 23:47:53 -0000 1.1
+++ create-db-phase3-ojb.sql 4 Feb 2004 21:47:24 -0000 1.2
@@ -1,58 +1,9 @@
-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
-);
-
-CREATE TABLE OJB_DLIST(
- ID INTEGER NOT NULL PRIMARY KEY,
- SIZE_ INTEGER
-);
-
-CREATE TABLE OJB_DLIST_ENTRIES(
- ID INTEGER NOT NULL PRIMARY KEY,
- DLIST_ID INTEGER,
- POSITION_ INTEGER,
- OID_ LONGVARBINARY
-);
-
-CREATE TABLE OJB_DSET(
- ID INTEGER NOT NULL PRIMARY KEY,
- SIZE_ INTEGER
-);
-
-CREATE TABLE OJB_DSET_ENTRIES(
- ID INTEGER NOT NULL PRIMARY KEY,
- DLIST_ID INTEGER,
- POSITION_ INTEGER,
- OID_ LONGVARBINARY
-);
-
-CREATE TABLE OJB_DMAP(
- ID INTEGER NOT NULL PRIMARY KEY,
- SIZE_ INTEGER
-);
-
-CREATE TABLE OJB_DMAP_ENTRIES(
- ID INTEGER NOT NULL PRIMARY KEY,
- DMAP_ID INTEGER,
- KEY_OID LONGVARBINARY,
- VALUE_OID LONGVARBINARY
-);
\ No newline at end of file
+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);
+CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER);
+CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY);
+CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER);
+CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY);
+CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER);
+CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID BINARY);
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org