weaver 2003/08/06 12:54:01 Modified: portal/src/webapp/WEB-INF/db/hsql Registry.script Log: Changes to simplify the preference object model Revision Changes Path 1.3 +4 -4 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.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- Registry.script 30 Jul 2003 18:56:30 -0000 1.2 +++ Registry.script 6 Aug 2003 19:54:01 -0000 1.3 @@ -13,10 +13,10 @@ 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) -CREATE TABLE PORTLET_PREFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_ID INTEGER NOT NULL,NAME VARCHAR(80) NOT NULL) +CREATE TABLE PORTLET_PREFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PARENT_ID INTEGER NOT NULL,NAME VARCHAR(80) NOT NULL,TYPE VARCHAR(30) NOT NULL) CREATE TABLE PREFERENCE_VALUE(PREFERENCE_ID INTEGER NOT NULL,ID INTEGER NOT NULL,VALUE LONGVARCHAR,CONSTRAINT PK PRIMARY KEY(PREFERENCE_ID,ID)) -CREATE TABLE USER_PORTLET_PREFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_ID INTEGER NOT NULL,USER_NAME VARCHAR(50),NAME VARCHAR(80) NOT NULL) -CREATE TABLE USER_PREFERENCE_VALUE(PREFERENCE_ID INTEGER NOT NULL,ID INTEGER NOT NULL,VALUE LONGVARCHAR,CONSTRAINT PK PRIMARY KEY(PREFERENCE_ID,ID)) +CREATE TABLE PORTLET_ENTITY(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_DEFINITION_ID INTEGER NOT NULL,GUID VARCHAR(50) NOT NULL) +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 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)) @@ -26,8 +26,8 @@ CREATE TABLE CONTROL(CONTROL_ID INTEGER NOT NULL PRIMARY KEY,CLASSNAME VARCHAR(128),TEMPLATE VARCHAR(128),ACTION VARCHAR(128),TITLE VARCHAR(128),DESCRIPTION VARCHAR(256)) CREATE TABLE SKIN(SKIN_ID INTEGER NOT NULL PRIMARY KEY) CREATE TABLE SECURITY(SECURITY_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(128) NOT NULL,TITLE VARCHAR(128),DESCRIPTION VARCHAR(256)) -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC +GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname" CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
