jford 2004/03/09 17:17:14
Modified: components/registry/src/sql/hsql create-db.sql drop-db.sql
Log:
Removed metadata table
Revision Changes Path
1.4 +3 -12
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.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- create-db.sql 26 Feb 2004 19:16:03 -0000 1.3
+++ create-db.sql 10 Mar 2004 01:17:14 -0000 1.4
@@ -1,15 +1,7 @@
----------------------------------------------------------------------------
--- Create Portlet Application Metadata Table
+-- Create Metadata Fields Table
----------------------------------------------------------------------------
-CREATE TABLE PA_METADATA
-(
- ID INTEGER NOT NULL PRIMARY KEY
-);
-
-----------------------------------------------------------------------------
--- Create Portlet Application Metadata Fields Table
-----------------------------------------------------------------------------
-CREATE TABLE PA_METADATA_FIELDS
+CREATE TABLE METADATA_FIELDS
(
ID INTEGER NOT NULL PRIMARY KEY,
OBJECT_ID INTEGER NOT NULL,
@@ -29,8 +21,7 @@
VERSION VARCHAR(80),
APP_TYPE INTEGER,
DESCRIPTION VARCHAR(80),
- WEB_APP_ID INTEGER NOT NULL,
- METADATA_ID INTEGER NOT NULL
+ WEB_APP_ID INTEGER NOT NULL
);
ALTER TABLE PORTLET_APPLICATION ADD CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME);
1.4 +1 -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.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- drop-db.sql 26 Feb 2004 19:16:03 -0000 1.3
+++ drop-db.sql 10 Mar 2004 01:17:14 -0000 1.4
@@ -1,6 +1,5 @@
-DROP TABLE PA_METADATA IF EXISTS;
-DROP TABLE PA_METADATA_FIELDS IF EXISTS;
+DROP TABLE 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]
