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, 30 Jul 2003 18:56:30 GMT
weaver      2003/07/30 11:56:30

  Modified:    portal/src/webapp/WEB-INF/db/hsql Registry.script
  Log:
  Added user preference tables
  
  Revision  Changes    Path
  1.2       +3 -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.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- Registry.script	28 Jul 2003 23:48:00 -0000	1.1
  +++ Registry.script	30 Jul 2003 18:56:30 -0000	1.2
  @@ -15,6 +15,8 @@
   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 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 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))
  @@ -24,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 "org.hsqldb.Library" TO PUBLIC
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  +GRANT ALL ON CLASS "org.hsqldb.Library" 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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message