You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by jf...@apache.org on 2004/02/20 06:28:03 UTC
cvs commit: jakarta-jetspeed-2/services/registry/src/sql/hsql create-db.sql drop-db.sql
jford 2004/02/19 21:28:03
Modified: services/registry/src/sql/hsql create-db.sql drop-db.sql
Log:
Added DublinCore tables
Revision Changes Path
1.3 +22 -1 jakarta-jetspeed-2/services/registry/src/sql/hsql/create-db.sql
Index: create-db.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/services/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 4 Feb 2004 21:54:36 -0000 1.2
+++ create-db.sql 20 Feb 2004 05:28:03 -0000 1.3
@@ -1,4 +1,24 @@
----------------------------------------------------------------------------
+-- Create Portlet Application Dublin Core Table
+----------------------------------------------------------------------------
+CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE
+(
+ ID INTEGER NOT NULL PRIMARY KEY
+);
+
+----------------------------------------------------------------------------
+-- Create Portlet Application Dublin Core Fields Table
+----------------------------------------------------------------------------
+
+CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS
+(
+ ID INTEGER NOT NULL PRIMARY KEY,
+ OBJECT_ID INTEGER NOT NULL,
+ VALUE LONGVARCHAR NOT NULL,
+ LOCALE_STRING VARCHAR(50) NOT NULL
+);
+
+----------------------------------------------------------------------------
-- Create Portlet Application Table
----------------------------------------------------------------------------
CREATE TABLE PORTLET_APPLICATION
@@ -9,7 +29,8 @@
VERSION VARCHAR(80),
APP_TYPE INTEGER,
DESCRIPTION VARCHAR(80),
- WEB_APP_ID INTEGER NOT NULL
+ WEB_APP_ID INTEGER NOT NULL,
+ DUBLIN_CORE_ID INTEGER NOT NULL
);
ALTER TABLE PORTLET_APPLICATION ADD CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME);
1.3 +2 -0 jakarta-jetspeed-2/services/registry/src/sql/hsql/drop-db.sql
Index: drop-db.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/services/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 5 Feb 2004 02:59:20 -0000 1.2
+++ drop-db.sql 20 Feb 2004 05:28:03 -0000 1.3
@@ -1,3 +1,5 @@
+DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE IF EXISTS;
+DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS IF EXISTS;
DROP TABLE PARAMETER IF EXISTS;
DROP TABLE PORTLET_CONTENT_TYPE IF EXISTS;
DROP TABLE LANGUAGE IF EXISTS;
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org