jford 2004/03/11 11:15:21
Modified: components/registry/src/sql/hsql create-db.sql drop-db.sql
Log:
Added metadata to the PortletDefnition
Revision Changes Path
1.5 +14 -2
jakarta-jetspeed-2/components/registry/src/sql/hsql/create-db.sql
Index: create-db.sql
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed-2/components/registry/src/sql/hsql/create-db.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- create-db.sql 10 Mar 2004 01:17:14 -0000 1.4
+++ create-db.sql 11 Mar 2004 19:15:21 -0000 1.5
@@ -1,7 +1,19 @@
----------------------------------------------------------------------------
--- Create Metadata Fields Table
+-- Create Portlet Application Metadata Fields Table
----------------------------------------------------------------------------
-CREATE TABLE METADATA_FIELDS
+CREATE TABLE PA_METADATA_FIELDS
+(
+ ID INTEGER NOT NULL PRIMARY KEY,
+ OBJECT_ID INTEGER NOT NULL,
+ VALUE LONGVARCHAR NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL
+);
+
+----------------------------------------------------------------------------
+-- Create Portlet Definition Metadata Fields Table
+----------------------------------------------------------------------------
+CREATE TABLE PD_METADATA_FIELDS
(
ID INTEGER NOT NULL PRIMARY KEY,
OBJECT_ID INTEGER NOT NULL,
1.5 +2 -1 jakarta-jetspeed-2/components/registry/src/sql/hsql/drop-db.sql
Index: drop-db.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/components/registry/src/sql/hsql/drop-db.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- drop-db.sql 10 Mar 2004 01:17:14 -0000 1.4
+++ drop-db.sql 11 Mar 2004 19:15:21 -0000 1.5
@@ -1,5 +1,6 @@
-DROP TABLE METADATA_FIELDS IF EXISTS;
+DROP TABLE PA_METADATA_FIELDS IF EXISTS;
+DROP TABLE PD_METADATA_FIELDS IF EXISTS;
DROP TABLE PARAMETER IF EXISTS;
DROP TABLE PORTLET_CONTENT_TYPE IF EXISTS;
DROP TABLE LANGUAGE IF EXISTS;
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
