jford 2004/02/26 11:16:03
Modified: components/registry/src/sql/hsql create-db.sql drop-db.sql
Log:
Switched to GenericMetadata
Revision Changes Path
1.3 +6 -6
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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create-db.sql 25 Feb 2004 22:22:04 -0000 1.2
+++ create-db.sql 26 Feb 2004 19:16:03 -0000 1.3
@@ -1,20 +1,20 @@
----------------------------------------------------------------------------
--- Create Portlet Application Dublin Core Table
+-- Create Portlet Application Metadata Table
----------------------------------------------------------------------------
-CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE
+CREATE TABLE PA_METADATA
(
ID INTEGER NOT NULL PRIMARY KEY
);
----------------------------------------------------------------------------
--- Create Portlet Application Dublin Core Fields Table
+-- Create Portlet Application Metadata Fields Table
----------------------------------------------------------------------------
-
-CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE_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
);
@@ -30,7 +30,7 @@
APP_TYPE INTEGER,
DESCRIPTION VARCHAR(80),
WEB_APP_ID INTEGER NOT NULL,
- DUBLIN_CORE_ID INTEGER NOT NULL
+ METADATA_ID INTEGER NOT NULL
);
ALTER TABLE PORTLET_APPLICATION ADD CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME);
1.3 +3 -2 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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- drop-db.sql 24 Feb 2004 15:33:40 -0000 1.2
+++ drop-db.sql 26 Feb 2004 19:16:03 -0000 1.3
@@ -1,5 +1,6 @@
-DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE IF EXISTS;
-DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS IF EXISTS;
+
+DROP TABLE PA_METADATA IF EXISTS;
+DROP TABLE PA_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]
