portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wea...@apache.org
Subject cvs commit: jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql Registry.script
Date Wed, 06 Aug 2003 19:54:01 GMT
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"
  
  
  

Mime
View raw message