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 we...@apache.org on 2003/10/07 02:17:34 UTC
cvs commit: jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql Registry.script
weaver 2003/10/06 17:17:34
Modified: portal/src/webapp/WEB-INF/db/hsql Registry.script
Log:
Adjusted to new OM.
Revision Changes Path
1.4 +9 -1 jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql/Registry.script
Index: Registry.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql/Registry.script,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- Registry.script 6 Aug 2003 19:54:01 -0000 1.3
+++ Registry.script 7 Oct 2003 00:17:33 -0000 1.4
@@ -9,7 +9,7 @@
CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID LONGVARBINARY)
CREATE TABLE PORTLET_APPLICATION(APPLICATION_ID INTEGER NOT NULL PRIMARY KEY,APP_NAME VARCHAR(80) NOT NULL,APP_IDENTIFIER VARCHAR(80),VERSION VARCHAR(80),DESCRIPTION VARCHAR(80),WEB_APP_ID INTEGER NOT NULL,CONSTRAINT UK_APPLICATION UNIQUE(APP_NAME))
CREATE TABLE WEB_APPLICATION(ID INTEGER NOT NULL PRIMARY KEY,CONTEXT_ROOT VARCHAR(255) NOT NULL)
-CREATE TABLE PORTLET_DEFINITION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),CLASS_NAME VARCHAR(100),APPLICATION_ID INTEGER NOT NULL,PORTLET_IDENTIFIER VARCHAR(80),EXPIRATION_CACHE VARCHAR(30))
+CREATE TABLE PORTLET_DEFINITION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),CLASS_NAME VARCHAR(100),APPLICATION_ID INTEGER NOT NULL,PORTLET_IDENTIFIER VARCHAR(80),EXPIRATION_CACHE VARCHAR(30),CONSTRAINT SYS_CT_2 UNIQUE(APPLICATION_ID,NAME))
CREATE TABLE LANGUAGE(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_ID INTEGER NOT NULL,TITLE VARCHAR(100),SHORT_TITLE VARCHAR(50),LOCALE_STRING VARCHAR(50) NOT NULL,KEYWORDS LONGVARCHAR)
CREATE TABLE PORTLET_CONTENT_TYPE(CONTENT_TYPE_ID INTEGER NOT NULL PRIMARY KEY,PORTLET_ID INTEGER NOT NULL,CONTENT_TYPE VARCHAR(30) NOT NULL,MODES LONGVARCHAR)
CREATE TABLE PARAMETER(PARAMETER_ID INTEGER NOT NULL PRIMARY KEY,PARENT_ID INTEGER NOT NULL,CLASS_NAME VARCHAR(30) NOT NULL,NAME VARCHAR(80) NOT NULL,VALUE LONGVARCHAR NOT NULL)
@@ -19,6 +19,14 @@
CREATE TABLE USER_PORTLET_PREFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_ENTITY_ID INTEGER NOT NULL,USER_NAME VARCHAR(50),NAME VARCHAR(80) NOT NULL)
CREATE TABLE LOCALIZED_DESCRITPION(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,TYPE VARCHAR(25) NOT NULL,DESCRIPTION LONGVARCHAR NOT NULL,LOCALE_STRING VARCHAR(50) NOT NULL)
CREATE TABLE LOCALIZED_DISPLAY_NAME(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,TYPE VARCHAR(25) NOT NULL,DISPLAY_NAME LONGVARCHAR NOT NULL,LOCALE_STRING VARCHAR(50) NOT NULL)
+CREATE TABLE MEDIA_TYPE(MEDIATYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL,CHARACTER_SET VARCHAR(40),TITLE VARCHAR(80),DESCRIPTION LONGVARCHAR)
+CREATE TABLE CLIENT(CLIENT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL,USER_AGENT_PATTERN VARCHAR(128),MANUFACTURER VARCHAR(80),MODEL VARCHAR(80),VERSION VARCHAR(40))
+CREATE TABLE MIMETYPE(MIMETYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL)
+CREATE TABLE CAPABILITY(CAPABILITY_ID INTEGER NOT NULL PRIMARY KEY,CAPABILITY VARCHAR(80) NOT NULL)
+CREATE TABLE CLIENT_TO_CAPABILITY(CLIENT_ID INTEGER NOT NULL,CAPABILITY_ID INTEGER NOT NULL)
+CREATE TABLE CLIENT_TO_MIMETYPE(CLIENT_ID INTEGER NOT NULL,MIMETYPE_ID INTEGER NOT NULL)
+CREATE TABLE MEDIATYPE_TO_CAPABILITY(MEDIATYPE_ID INTEGER NOT NULL,CAPABILITY_ID INTEGER NOT NULL)
+CREATE TABLE MEDIATYPE_TO_MIMETYPE(MEDIATYPE_ID INTEGER NOT NULL,MIMETYPE_ID INTEGER NOT NULL)
CREATE TABLE PSML(PSML_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(32),PSML_TYPE SMALLINT NOT NULL,MEDIA_TYPE VARCHAR(128),LANGUAGE VARCHAR(2),COUNTRY VARCHAR(2),PAGE VARCHAR(128),CONSTRAINT UK_PSML UNIQUE(PSML_TYPE,NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE TABLE PSML_ENTRY(PSML_ENTRY_ID INTEGER NOT NULL PRIMARY KEY,PSML_ID INTEGER NOT NULL,ENTRY_TYPE SMALLINT NOT NULL,PARENT_ID INTEGER,PORTLET_ID INTEGER,LAYOUT_ID INTEGER,CONTROL_ID INTEGER,SKIN_ID INTEGER,SECURITY_ID INTEGER,CONSTRAINT FK_PSML_ENTRY_1 FOREIGN KEY(PSML_ID) REFERENCES PSML(PSML_ID) ON DELETE CASCADE,CONSTRAINT FK_PSML_ENTRY_2 FOREIGN KEY(PARENT_ID) REFERENCES PSML_ENTRY(PSML_ENTRY_ID) ON DELETE CASCADE)
CREATE INDEX IX_PSML_ENTRY_1 ON PSML_ENTRY(PSML_ID,PARENT_ID)
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org