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 Fri, 17 Oct 2003 20:11:22 GMT
weaver      2003/10/17 13:11:22

  Modified:    portal/src/webapp/WEB-INF/db/hsql Registry.script
  Log:
  added security role table
  fixed misspellings of description
  
  Revision  Changes    Path
  1.7       +6 -99     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.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- Registry.script	14 Oct 2003 22:18:36 -0000	1.6
  +++ Registry.script	17 Oct 2003 20:11:22 -0000	1.7
  @@ -13,11 +13,11 @@
   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,PARENT_ID INTEGER NOT NULL,NAME
VARCHAR(80) NOT NULL,TYPE VARCHAR(30) NOT NULL,READ_ONLY CHAR(1) DEFAULT '1')
  -CREATE TABLE 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 PORTLET_PREFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PARENT_ID INTEGER NOT NULL,NAME
VARCHAR(80) NOT NULL,CLASS_NAME VARCHAR(50) NOT NULL,READ_ONLY CHAR(1) DEFAULT '1')
  +CREATE TABLE PREFERENCE_VALUE(ID INTEGER NOT NULL PRIMARY KEY,PREFERENCE_ID INTEGER,VALUE
LONGVARCHAR)
  +CREATE TABLE PORTLET_ENTITY(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_DEFINITION_ID INTEGER
NOT NULL,GUID VARCHAR(255) NOT NULL)
  +CREATE TABLE SECURITY_ROLE_REFERENCE(ID INTEGER NOT NULL PRIMARY KEY,PORTLET_DEFINITION_ID
INTEGER NOT NULL,ROLE_NAME VARCHAR(150),ROLE_LINK VARCHAR(150))
  +CREATE TABLE LOCALIZED_DESCRIPTION(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))
  @@ -34,8 +34,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"
  @@ -105,96 +105,3 @@
   CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
   CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
   CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
  -/*C1*/CONNECT USER sa PASSWORD ""
  -SET AUTOCOMMIT FALSE
  -/*C2*/CONNECT USER sa PASSWORD ""
  -/*C1*/INSERT INTO OJB_HL_SEQ VALUES('SEQ_WEB_APPLICATION','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_PORTLET_APPLICATION','APPLICATION_ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_LOCALIZED_DISPLAY_NAME','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_PORTLET_DEFINITION','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_LANGUAGE','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_PORTLET_CONTENT_TYPE','CONTENT_TYPE_ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_PARAMETER','PARAMETER_ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_LOCALIZED_DESCRITPION','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -SET AUTOCOMMIT FALSE
  -INSERT INTO OJB_HL_SEQ VALUES('SEQ_PORTLET_PREFERENCE','ID',20,20,1)
  -COMMIT
  -SET AUTOCOMMIT TRUE
  -/*C2*/SET AUTOCOMMIT FALSE
  -INSERT INTO WEB_APPLICATION VALUES(1,'/HW_App')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(1,1,'web application','HW_App','en,US,')
  -INSERT INTO PORTLET_APPLICATION VALUES(1,'HW_App','HW_App','1.0',NULL,1)
  -INSERT INTO PORTLET_DEFINITION VALUES(1,'LoginPortlet','org.apache.jetspeed.portlet.ServletPortlet',1,'LoginPortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(1,1,'Login/Logout  Request Information','Portlet Request Information','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(1,1,'text/html','"view"')
  -INSERT INTO PARAMETER VALUES(1,1,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','ViewPage','/WEB-INF/demo/simple/Login.jsp')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(2,1,'portlet','LoginRequest Portlet Wrapper','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(2,'AttributeScopePortlet','org.apache.jetspeed.demo.simple.AttributeScopeServlet',1,'AttributeScopePortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(2,2,'Attribute Scope Demo Portlet','','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(2,2,'text/html','"view","help"')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(3,2,'portlet','Attribute Scope Demo','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(3,'CustomerInfo','org.apache.jetspeed.demo.customerInfo.CustomerPortlet',1,'CustomerInfo','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(3,3,'Customer Information','Customer Info','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(3,3,'text/html','"view"')
  -INSERT INTO PARAMETER VALUES(2,3,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','ViewPage','/WEB-INF/demo/customerInfo/Page2.jsp')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(4,3,'portlet','Customer Information','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(4,'JMXPortlet','org.apache.jetspeed.demo.jmx.JMXPortlet',1,'JMXPortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(4,4,'JMX Portal Console','JMX Portlet Console','en,,','"JMX"')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(4,4,'text/html','"view"')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(5,4,'portlet','JMX Registry Access portlet','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(5,'CustomerDetail','org.apache.jetspeed.demo.customerInfo.CustomerPortlet',1,'CustomerDetail','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(5,5,'Customer Detail','Customer Detail','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(5,5,'text/html','"view"')
  -INSERT INTO PARAMETER VALUES(3,5,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','ViewPage','/WEB-INF/demo/customerInfo/Page3.jsp')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(6,5,'portlet','Customer Detail','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(6,'PickANumberPortlet','org.apache.jetspeed.demo.simple.PickANumberServlet',1,'PickANumberPortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(6,6,'Pick a Number','','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(6,6,'text/html','"view","help"')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(7,6,'portlet','Pick a number game','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(7,'CustomerList','org.apache.jetspeed.demo.customerInfo.CustomerPortlet',1,'CustomerList','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(7,7,'Customer List','Customer List','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(7,7,'text/html','"view"')
  -INSERT INTO PARAMETER VALUES(4,7,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','ViewPage','/WEB-INF/demo/customerInfo/Page1.jsp')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(8,7,'portlet','Customer List','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(8,'DisplayRequestPortlet','org.apache.jetspeed.portlet.ServletPortlet',1,'DisplayRequestPortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(8,8,'Display the Portlet Request Information','Portlet Request
Information','en,,','')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(8,8,'text/html','"view","help"')
  -INSERT INTO PARAMETER VALUES(5,8,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','ViewPage','/WEB-INF/demo/simple/DisplayRequest.jsp')
  -INSERT INTO PARAMETER VALUES(6,8,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','HelpPage','/WEB-INF/demo/simple/DisplayRequestHelp.jsp')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(9,8,'portlet','DisplayRequest Portlet Wrapper','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(9,'HelloPortlet','org.apache.jetspeed.portlet.helloworld.HelloWorld',1,'HelloPortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(9,9,'HelloWorldTitle','This is the short title','en,,','"Test"')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(9,9,'text/html','"view","help","edit"')
  -INSERT INTO PARAMETER VALUES(7,9,'org.apache.jetspeed.om.impl.PortletInitParameterImpl','hello','Hello
Portlet')
  -INSERT INTO LOCALIZED_DESCRITPION VALUES(1,7,'parameter','test init param','en,US,')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(10,9,'portlet','HelloWorld Portlet Wrapper','en,US,')
  -INSERT INTO PORTLET_DEFINITION VALUES(10,'PreferencePortlet','org.apache.jetspeed.demo.preferences.PreferencePortlet',1,'PreferencePortlet','-1',NULL)
  -INSERT INTO LANGUAGE VALUES(10,10,'Preference Test','Preference Test','en,,','"Preferences"')
  -INSERT INTO PORTLET_CONTENT_TYPE VALUES(10,10,'text/html','"view"')
  -INSERT INTO PORTLET_PREFERENCE VALUES(1,10,'pref1','default preference','FALSE')
  -INSERT INTO LOCALIZED_DISPLAY_NAME VALUES(11,10,'portlet','PreferencePortlet','en,US,')
  -COMMIT
  -SET AUTOCOMMIT TRUE
  
  
  

---------------------------------------------------------------------
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