portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wea...@apache.org
Subject cvs commit: jakarta-jetspeed-2/portal/src/sql/hsql create-db-phase3-ojb.sql
Date Wed, 04 Feb 2004 21:47:24 GMT
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


Mime
View raw message