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.sql drop-db.sql
Date Wed, 30 Jul 2003 18:56:16 GMT
weaver      2003/07/30 11:56:16

  Modified:    portal/src/sql/hsql create-db.sql drop-db.sql
  Log:
  Added user preference tables
  
  Revision  Changes    Path
  1.2       +21 -0     jakarta-jetspeed-2/portal/src/sql/hsql/create-db.sql
  
  Index: create-db.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/sql/hsql/create-db.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- create-db.sql	28 Jul 2003 23:47:54 -0000	1.1
  +++ create-db.sql	30 Jul 2003 18:56:16 -0000	1.2
  @@ -95,6 +95,27 @@
   );
   
   ------------------------------------------------------------------------------
  +-- User Preference and User Preference Values
  +------------------------------------------------------------------------------
  +CREATE TABLE USER_PORTLET_PREFERENCE(
  +    ID INTEGER PRIMARY KEY,
  +    PORTLET_ID INTEGER NOT NULL,
  +    USER_NAME VARCHAR(50),
  +    NAME VARCHAR(80) NOT NULL
  +
  +);
  +
  +CREATE TABLE USER_PREFERENCE_VALUE(
  +    PREFERENCE_ID INTEGER,
  +	ID INTEGER,
  +    VALUE LONGVARCHAR,
  +    
  +    CONSTRAINT PK
  + 	PRIMARY KEY (PREFERENCE_ID, ID)
  +
  +);
  +
  +------------------------------------------------------------------------------
   -- Localized Descriptions
   ------------------------------------------------------------------------------
   CREATE TABLE LOCALIZED_DESCRITPION(
  
  
  
  1.2       +2 -0      jakarta-jetspeed-2/portal/src/sql/hsql/drop-db.sql
  
  Index: drop-db.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/sql/hsql/drop-db.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- drop-db.sql	28 Jul 2003 23:47:54 -0000	1.1
  +++ drop-db.sql	30 Jul 2003 18:56:16 -0000	1.2
  @@ -13,6 +13,8 @@
   DROP TABLE PORTLET_APPLICATION IF EXISTS 
   DROP TABLE PORTLET_PREFERENCE IF EXISTS 
   DROP TABLE PREFERENCE_VALUE IF EXISTS 
  +DROP TABLE USER_PORTLET_PREFERENCE IF EXISTS 
  +DROP TABLE USER_PREFERENCE_VALUE IF EXISTS 
   
   DROP TABLE OJB_HL_SEQ IF EXISTS 
   DROP TABLE OJB_LOCKENTRY IF EXISTS 
  
  
  

---------------------------------------------------------------------
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