weaver 2003/08/01 13:14:46
Modified: portal/src/sql/hsql create-db.sql drop-db.sql
Log:
Added tables
Revision Changes Path
1.3 +15 -1 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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create-db.sql 30 Jul 2003 18:56:16 -0000 1.2
+++ create-db.sql 1 Aug 2003 20:14:46 -0000 1.3
@@ -74,6 +74,8 @@
VALUE LONGVARCHAR NOT NULL
);
+
+
------------------------------------------------------------------------------
-- Preference and Preference Values
------------------------------------------------------------------------------
@@ -94,12 +96,24 @@
);
+
+-------------------------------------------------------------------------------
+-- Portlet Entity
+-- Represents the managed state of individual portlet
+-- intance within a "page"
+-------------------------------------------------------------------------------
+CREATE TABLE PORTLET_ENTITY(
+ ID INTEGER PRIMARY KEY,
+ PORTLET_DEFINITION_ID INTEGER NOT NULL
+);
+
+
------------------------------------------------------------------------------
-- User Preference and User Preference Values
------------------------------------------------------------------------------
CREATE TABLE USER_PORTLET_PREFERENCE(
ID INTEGER PRIMARY KEY,
- PORTLET_ID INTEGER NOT NULL,
+ PORTLET_ENTITY_ID INTEGER NOT NULL,
USER_NAME VARCHAR(50),
NAME VARCHAR(80) NOT NULL
1.3 +4 -2 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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- drop-db.sql 30 Jul 2003 18:56:16 -0000 1.2
+++ drop-db.sql 1 Aug 2003 20:14:46 -0000 1.3
@@ -15,6 +15,9 @@
DROP TABLE PREFERENCE_VALUE IF EXISTS
DROP TABLE USER_PORTLET_PREFERENCE IF EXISTS
DROP TABLE USER_PREFERENCE_VALUE IF EXISTS
+DROP TABLE PORTLET_ENTITY IF EXISTS
+DROP TABLE LOCALIZED_DESCRITPION IF EXISTS
+DROP TABLE LOCALIZED_DISPLAY_NAME IF EXISTS
DROP TABLE OJB_HL_SEQ IF EXISTS
DROP TABLE OJB_LOCKENTRY IF EXISTS
@@ -26,7 +29,6 @@
DROP TABLE OJB_DMAP IF EXISTS
DROP TABLE OJB_DMAP_ENTRIES IF EXISTS
-DROP TABLE LOCALIZED_DESCRITPION IF EXISTS
-DROP TABLE LOCALIZED_DISPLAY_NAME IF EXISTS
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
