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