portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed-2/services/registry/src/sql/hsql drop-db.sql
Date Thu, 05 Feb 2004 02:59:20 GMT
taylor      2004/02/04 18:59:20

  Modified:    .        .classpath
               cps/test/rewriter test-001-output.html
               plugin   project.xml
               portal   maven.xml project.xml
               portal/src/sql/hsql drop-db.sql
               portal/src/webapp/WEB-INF/conf jetspeed.properties
               portal/src/webapp/WEB-INF/db/hsql Registry.script
               services/registry/src/sql/hsql drop-db.sql
  Log:
  due to missing semicolons, drop db statements weren't executing all drops, this was causing
databases not to create
  
  Revision  Changes    Path
  1.14      +4 -1      jakarta-jetspeed-2/.classpath
  
  Index: .classpath
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/.classpath,v
  retrieving revision 1.13
  retrieving revision 1.14
  diff -u -r1.13 -r1.14
  --- .classpath	12 Jan 2004 06:37:52 -0000	1.13
  +++ .classpath	5 Feb 2004 02:59:20 -0000	1.14
  @@ -36,11 +36,14 @@
       <classpathentry kind="var" path="MAVEN_REPO/mx4j/jars/mx4j-jmx-1.1.1.jar"/>
       <classpathentry kind="var" path="MAVEN_REPO/mx4j/jars/mx4j-tools-1.1.1.jar"/>
       <classpathentry kind="var" path="MAVEN_REPO/commons-modeler/jars/commons-modeler-1.1M1.jar"/>
  -    <classpathentry kind="var" path="MAVEN_REPO/ojb/jars/ojb-1.0.rc3-PATCHED.jar"/>
       <classpathentry kind="var" path="MAVEN_REPO/xerces/jars/xerces-2.3.0.jar"/>
       <classpathentry kind="var" path="MAVEN_REPO/xml-apis/jars/xml-apis-2.0.2.jar"/>
       <classpathentry kind="src" path="/jakarta-pluto"/>
       <classpathentry kind="var" path="MAVEN_REPO/regexp/jars/regexp-1.2.jar"/>
       <classpathentry kind="var" path="MAVEN_REPO/velocity/jars/velocity-dep-1.3.1.jar"/>
  +    <classpathentry kind="var" path="MAVEN_REPO/tyrex/jars/tyrex-1.0.1.jar"/>
  +    <classpathentry kind="var" path="MAVEN_REPO/ojb/jars/db-ojb-1.0.rc5.jar"/>
  +    <classpathentry kind="var" path="MAVEN_REPO/commons-httpclient/jars/commons-httpclient-2.0-rc3.jar"/>
  +    <classpathentry kind="var" path="MAVEN_REPO/velocity-tools/jars/velocity-tools-view-1.1-beta1.jar"/>
       <classpathentry kind="output" path="bin"/>
   </classpath>
  
  
  
  1.16      +3 -3      jakarta-jetspeed-2/cps/test/rewriter/test-001-output.html
  
  Index: test-001-output.html
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cps/test/rewriter/test-001-output.html,v
  retrieving revision 1.15
  retrieving revision 1.16
  diff -u -r1.15 -r1.16
  --- test-001-output.html	3 Feb 2004 23:58:07 -0000	1.15
  +++ test-001-output.html	5 Feb 2004 02:59:20 -0000	1.16
  @@ -1,8 +1,8 @@
   <p>
   This is a test</p>
  -<a href="http://www.bluesunrise.com/suffix" name="1" target="_BLANK">keep this</a>
  - <a href="http://www.rewriter.com/stuff/junk/stuffedjunk.html/suffix" name="2" target="_BLANK">junk</a>
  - <a href="http://www.rewriter.com/stuff/junk/stuffedjunk.html/suffix" name="3" target="_BLANK">junk2</a>
  +<a target="_BLANK" href="http://www.bluesunrise.com/suffix" name="1">keep this</a>
  + <a target="_BLANK" href="http://www.rewriter.com/stuff/junk/stuffedjunk.html/suffix"
name="2">junk</a>
  + <a target="_BLANK" href="http://www.rewriter.com/stuff/junk/stuffedjunk.html/suffix"
name="3">junk2</a>
    <a href="javascript:whatever()" name="4">script</a>
    <a href="mailto:david@bluesunrise.com" name="5">script</a>
    <a href="#INTERNAL" name="6">internal</a>
  
  
  
  1.9       +1 -1      jakarta-jetspeed-2/plugin/project.xml
  
  Index: project.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/plugin/project.xml,v
  retrieving revision 1.8
  retrieving revision 1.9
  diff -u -r1.8 -r1.9
  --- project.xml	4 Feb 2004 21:41:33 -0000	1.8
  +++ project.xml	5 Feb 2004 02:59:20 -0000	1.9
  @@ -58,7 +58,7 @@
       </dependency>
       <dependency>
         <id>commons-collections</id>
  -      <version>3.0</version>
  +      <version>2.1</version>
         <properties>
           <war.bundle.jar>true</war.bundle.jar>
         </properties>
  
  
  
  1.35      +2 -1      jakarta-jetspeed-2/portal/maven.xml
  
  Index: maven.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/maven.xml,v
  retrieving revision 1.34
  retrieving revision 1.35
  diff -u -r1.34 -r1.35
  --- maven.xml	4 Feb 2004 21:44:33 -0000	1.34
  +++ maven.xml	5 Feb 2004 02:59:20 -0000	1.35
  @@ -104,7 +104,7 @@
               <arg value="-PortletAppName" />
               <arg value="testsuite" />
               <arg value="-warfilename" />
  -            <arg value="../../jakarta-pluto/testsuite/target/testsuite.war" />
  +            <arg value="../../SAVE-jakarta-pluto/testsuite/target/testsuite.war" />
               <arg value="-webappDir" />
               <arg value="${pam.deploy.dir}/" />
               <arg value="-PortalName" />
  @@ -252,6 +252,7 @@
         <copy  file="./target/jetspeed.war" tofile="${deploy.war.dir}/${webapp.name}.war"/>
         <unwar src="${deploy.war.dir}/${webapp.name}.war" dest="${deploy.war.dir}/${webapp.name}"/>
         <copy  file="./src/resources/jetspeed.xml" tofile="${deploy.war.dir}/jetspeed.xml"/>
  +      <copy  file="./src/resources/jetspeed.xml" tofile="${tomcat.root}/conf/Catalina/localhost/jetspeed.xml"/>
         <attainGoal name="catalina:base-shared" />
         <attainGoal name="catalina:shared" />
     </goal>
  
  
  
  1.31      +1 -1      jakarta-jetspeed-2/portal/project.xml
  
  Index: project.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/project.xml,v
  retrieving revision 1.30
  retrieving revision 1.31
  diff -u -r1.30 -r1.31
  --- project.xml	4 Feb 2004 21:39:13 -0000	1.30
  +++ project.xml	5 Feb 2004 02:59:20 -0000	1.31
  @@ -65,7 +65,7 @@
       </dependency>
       <dependency>
         <id>commons-collections</id>
  -      <version>3.0</version>
  +      <version>2.1</version>
         <properties>
           <war.bundle.jar>true</war.bundle.jar>
         </properties>
  
  
  
  1.10      +42 -42    jakarta-jetspeed-2/portal/src/sql/hsql/drop-db.sql
  
  Index: drop-db.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/sql/hsql/drop-db.sql,v
  retrieving revision 1.9
  retrieving revision 1.10
  diff -u -r1.9 -r1.10
  --- drop-db.sql	12 Jan 2004 06:45:26 -0000	1.9
  +++ drop-db.sql	5 Feb 2004 02:59:20 -0000	1.10
  @@ -1,51 +1,51 @@
  -DROP TABLE SECURITY IF EXISTS 
  -DROP TABLE SKIN IF EXISTS 
  -DROP TABLE CONTROL IF EXISTS 
  -DROP TABLE LAYOUT IF EXISTS 
  -DROP TABLE PSML_ENTRY IF EXISTS 
  -DROP TABLE PSML IF EXISTS 
  +DROP TABLE SECURITY IF EXISTS; 
  +DROP TABLE SKIN IF EXISTS; 
  +DROP TABLE CONTROL IF EXISTS; 
  +DROP TABLE LAYOUT IF EXISTS; 
  +DROP TABLE PSML_ENTRY IF EXISTS; 
  +DROP TABLE PSML IF EXISTS; 
   
  -DROP TABLE OJB_HL_SEQ IF EXISTS 
  -DROP TABLE OJB_LOCKENTRY IF EXISTS 
  -DROP TABLE OJB_NRM IF EXISTS 
  -DROP TABLE OJB_DLIST IF EXISTS 
  -DROP TABLE OJB_DLIST_ENTRIES IF EXISTS 
  -DROP TABLE OJB_DSET IF EXISTS 
  -DROP TABLE OJB_DSET_ENTRIES IF EXISTS 
  -DROP TABLE OJB_DMAP IF EXISTS 
  -DROP TABLE OJB_DMAP_ENTRIES IF EXISTS
  +DROP TABLE OJB_HL_SEQ IF EXISTS; 
  +DROP TABLE OJB_LOCKENTRY IF EXISTS; 
  +DROP TABLE OJB_NRM IF EXISTS; 
  +DROP TABLE OJB_DLIST IF EXISTS; 
  +DROP TABLE OJB_DLIST_ENTRIES IF EXISTS; 
  +DROP TABLE OJB_DSET IF EXISTS; 
  +DROP TABLE OJB_DSET_ENTRIES IF EXISTS; 
  +DROP TABLE OJB_DMAP IF EXISTS; 
  +DROP TABLE OJB_DMAP_ENTRIES IF EXISTS;
   
  -DROP TABLE CAPABILITY IF EXISTS
  -DROP TABLE MIMETYPE IF EXISTS
  -DROP TABLE CLIENT IF EXISTS
  -DROP TABLE MEDIA_TYPE IF EXISTS
  +DROP TABLE CAPABILITY IF EXISTS;
  +DROP TABLE MIMETYPE IF EXISTS;
  +DROP TABLE CLIENT IF EXISTS;
  +DROP TABLE MEDIA_TYPE IF EXISTS;
   
  -DROP TABLE CLIENT_TO_CAPABILITY IF EXISTS
  -DROP TABLE CLIENT_TO_MIMETYPE IF EXISTS
  -DROP TABLE MEDIATYPE_TO_CAPABILITY IF EXISTS
  -DROP TABLE MEDIATYPE_TO_MIMETYPE IF EXISTS
  +DROP TABLE CLIENT_TO_CAPABILITY IF EXISTS;
  +DROP TABLE CLIENT_TO_MIMETYPE IF EXISTS;
  +DROP TABLE MEDIATYPE_TO_CAPABILITY IF EXISTS;
  +DROP TABLE MEDIATYPE_TO_MIMETYPE IF EXISTS;
   
  -DROP TABLE DESKTOP IF EXISTS
  -DROP TABLE DESKTOP_PAGES IF EXISTS
  -DROP TABLE SUB_PAGES IF EXISTS
  -DROP TABLE PAGE IF EXISTS
  -DROP TABLE FRAGMENT IF EXISTS
  -DROP TABLE PAGE_FRAGMENTS IF EXISTS
  -DROP TABLE SUB_FRAGMENTS IF EXISTS
  -DROP TABLE FRAGMENT_PARAMETER IF EXISTS
  -DROP TABLE FRAGMENT_REF IF EXISTS
  -DROP TABLE FRAGMENT_REFS IF EXISTS
  -DROP TABLE PROFILING_RULE IF EXISTS
  -DROP TABLE RULE_CRITERION IF EXISTS
  -DROP TABLE PRINCIPAL_RULE_ASSOC IF EXISTS
  -DROP TABLE PROFILE_DESKTOP_ASSOC IF EXISTS
  -DROP TABLE PROFILE_PAGE_ASSOC IF EXISTS
  +DROP TABLE DESKTOP IF EXISTS;
  +DROP TABLE DESKTOP_PAGES IF EXISTS;
  +DROP TABLE SUB_PAGES IF EXISTS;
  +DROP TABLE PAGE IF EXISTS;
  +DROP TABLE FRAGMENT IF EXISTS;
  +DROP TABLE PAGE_FRAGMENTS IF EXISTS;
  +DROP TABLE SUB_FRAGMENTS IF EXISTS;
  +DROP TABLE FRAGMENT_PARAMETER IF EXISTS;
  +DROP TABLE FRAGMENT_REF IF EXISTS;
  +DROP TABLE FRAGMENT_REFS IF EXISTS;
  +DROP TABLE PROFILING_RULE IF EXISTS;
  +DROP TABLE RULE_CRITERION IF EXISTS;
  +DROP TABLE PRINCIPAL_RULE_ASSOC IF EXISTS;
  +DROP TABLE PROFILE_DESKTOP_ASSOC IF EXISTS;
  +DROP TABLE PROFILE_PAGE_ASSOC IF EXISTS;
   
   -----------------------------------------------------------------------------
   -- drop preferences schema
   -----------------------------------------------------------------------------
  -DROP TABLE pref_property_value IF EXISTS
  -DROP TABLE pref_property_key IF EXISTS
  -DROP TABLE pref_node IF EXISTS
  -DROP TABLE pref_property_set_def IF EXISTS
  +DROP TABLE pref_property_value IF EXISTS;
  +DROP TABLE pref_property_key IF EXISTS;
  +DROP TABLE pref_node IF EXISTS;
  +DROP TABLE pref_property_set_def IF EXISTS;
   
  
  
  
  1.31      +2 -13     jakarta-jetspeed-2/portal/src/webapp/WEB-INF/conf/jetspeed.properties
  
  Index: jetspeed.properties
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/webapp/WEB-INF/conf/jetspeed.properties,v
  retrieving revision 1.30
  retrieving revision 1.31
  diff -u -r1.30 -r1.31
  --- jetspeed.properties	4 Feb 2004 21:48:55 -0000	1.30
  +++ jetspeed.properties	5 Feb 2004 02:59:20 -0000	1.31
  @@ -240,18 +240,13 @@
   # services.profiler.ruletype.handler.name = request-parameter
   # services.profiler.ruletype.handler.impl = org.apache.jetspeed.profiler.impl.RequestParameterHandler
   
  -#--------------------------------------------------------------------
  -# P O R T L E T  D E P L O Y M E N T  D E S C R I P T O R
  -#--------------------------------------------------------------------
  -deployment.descriptor.mapping.xml=/WEB-INF/conf/portletdefinitionmapping.xml
  -
  -
   #-------------------------------------------------------------------------
   # J M X   S E R V I C E 
   #-------------------------------------------------------------------------
   services.JMXService.classname=org.apache.jetspeed.services.jmx.JetspeedJMXService
   services.JMXService.mbeans=Registry
   services.JMXService.mbeans.Registry=org.apache.jetspeed.mbeans.registry.RegistryMBeanImpl
  +services.JMXService.mbean.descriptor=/WEB-INF/conf/jetspeed-mbeans-descriptors.xml
   
   #-------------------------------------------------------------------------
   # C A P A B I L I T Y,  C O N T E N T  E N C O D I N G  
  @@ -330,9 +325,3 @@
   #--------------------------------------------------------------------
   preferences.factory=org.apache.jetspeed.spi.services.prefs.impl.PreferencesFactoryImpl
   
  -# -------------------------------------------------------------------
  -# Page Registry (Castor based)            
  -# -------------------------------------------------------------------
  -# services.PageRegistry.classname=org.apache.jetspeed.services.page.impl.CastorXmlPageRegistryService
  -# services.PageRegistry.file=/WEB-INF/pages/pages.xreg
  -# services.PageRegistry.mapping=/WEB-INF/conf/pageregistry-mapping.xml
  
  
  
  1.22      +13 -13    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.21
  retrieving revision 1.22
  diff -u -r1.21 -r1.22
  --- Registry.script	23 Jan 2004 20:40:34 -0000	1.21
  +++ Registry.script	5 Feb 2004 02:59:20 -0000	1.22
  @@ -1,15 +1,3 @@
  -CREATE TABLE PORTLET_APPLICATION(APPLICATION_ID INTEGER NOT NULL PRIMARY KEY,APP_NAME VARCHAR(80)
NOT NULL,APP_IDENTIFIER VARCHAR(80),VERSION VARCHAR(80),APP_TYPE INTEGER,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),PREFERENCE_VALIDATOR VARCHAR(255),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)
  -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 OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY
INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
   CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT NULL,TIMESTAMP_
TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT SYS_PK_OJB_LOCKENTRY PRIMARY
KEY(OID_,TX_ID))
   CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
  @@ -18,7 +6,7 @@
   CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
   CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_
INTEGER,OID_ LONGVARBINARY)
   CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  -CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID
LONGVARBINARY)
  +CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID BINARY,VALUE_OID
BINARY)
   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),PREFERRED_MIMETYPE_ID
INTEGER NOT NULL)
   CREATE TABLE MIMETYPE(MIMETYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL)
  @@ -54,6 +42,18 @@
   CREATE TABLE PREF_NODE(NODE_ID INTEGER NOT NULL PRIMARY KEY,PARENT_NODE_ID INTEGER,PROPERTY_SET_DEF_ID
INTEGER,NODE_NAME VARCHAR(100),NODE_TYPE SMALLINT,FULL_PATH VARCHAR(254),CREATION_DATE TIMESTAMP,MODIFIED_DATE
TIMESTAMP,CONSTRAINT PREF_NODE_FK1 FOREIGN KEY(PARENT_NODE_ID) REFERENCES PREF_NODE(NODE_ID),CONSTRAINT
PREF_NODE_FK_2 FOREIGN KEY(PROPERTY_SET_DEF_ID) REFERENCES PREF_PROPERTY_SET_DEF(PROPERTY_SET_DEF_ID))
   CREATE TABLE PREF_PROPERTY_VALUE(PROPERTY_VALUE_ID INTEGER NOT NULL PRIMARY KEY,PROPERTY_KEY_ID
INTEGER,NODE_ID INTEGER,BOOLEAN_VALUE BIT,DATETIME_VALUE TIMESTAMP,LONG_VALUE INTEGER,DOUBLE_VALUE
DOUBLE,TEXT_VALUE VARCHAR(254),CREATION_DATE TIMESTAMP,MODIFIED_DATE TIMESTAMP,CONSTRAINT
PREF_PROPERTY_VALUE_FK_1 FOREIGN KEY(NODE_ID) REFERENCES PREF_NODE(NODE_ID))
   CREATE TABLE PREF_PROPERTY_KEY(PROPERTY_KEY_ID INTEGER NOT NULL PRIMARY KEY,PROPERTY_SET_DEF_ID
INTEGER,PROPERTY_NAME VARCHAR(100),PROPERTY_TYPE SMALLINT,CREATION_DATE TIMESTAMP,MODIFIED_DATE
TIMESTAMP,CONSTRAINT PREF_PROPERTY_KEY_FK_1 FOREIGN KEY(PROPERTY_SET_DEF_ID) REFERENCES PREF_PROPERTY_SET_DEF(PROPERTY_SET_DEF_ID))
  +CREATE TABLE PORTLET_APPLICATION(APPLICATION_ID INTEGER NOT NULL PRIMARY KEY,APP_NAME VARCHAR(80)
NOT NULL,APP_IDENTIFIER VARCHAR(80),VERSION VARCHAR(80),APP_TYPE INTEGER,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),PREFERENCE_VALIDATOR VARCHAR(255),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,PARAMETER_VALUE LONGVARCHAR
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,CLASS_NAME VARCHAR(255) 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,CLASS_NAME VARCHAR(255),DISPLAY_NAME LONGVARCHAR NOT NULL,LOCALE_STRING VARCHAR(50) NOT
NULL)
   ALTER TABLE PREF_PROPERTY_VALUE ADD CONSTRAINT PREF_PROPERTY_VALUE_FK_2 FOREIGN KEY(PROPERTY_KEY_ID)
REFERENCES PREF_PROPERTY_KEY(PROPERTY_KEY_ID)
   GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
   GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
  
  
  
  1.2       +13 -14    jakarta-jetspeed-2/services/registry/src/sql/hsql/drop-db.sql
  
  Index: drop-db.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/services/registry/src/sql/hsql/drop-db.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- drop-db.sql	12 Jan 2004 06:19:52 -0000	1.1
  +++ drop-db.sql	5 Feb 2004 02:59:20 -0000	1.2
  @@ -1,15 +1,14 @@
  -DROP TABLE PARAMETER IF EXISTS 
  -DROP TABLE PORTLET_CONTENT_TYPE IF EXISTS 
  -DROP TABLE LANGUAGE IF EXISTS 
  -DROP TABLE PORTLET_DEFINITION IF EXISTS 
  -DROP TABLE WEB_APPLICATION IF EXISTS 
  -DROP TABLE PORTLET_APPLICATION IF EXISTS 
  -DROP TABLE PORTLET_PREFERENCE IF EXISTS 
  -DROP TABLE PREFERENCE_VALUE IF EXISTS 
  -DROP TABLE USER_PORTLET_PREFERENCE IF EXISTS 
  -DROP TABLE USER_PREFERENCE_VALUE IF EXISTS 
  -DROP TABLE PORTLET_ENTITY IF EXISTS 
  -DROP TABLE LOCALIZED_DESCRIPTION IF EXISTS 
  -DROP TABLE LOCALIZED_DISPLAY_NAME IF EXISTS 
  -DROP TABLE SECURITY_ROLE_REFERENCE IF EXISTS
  +DROP TABLE PARAMETER IF EXISTS; 
  +DROP TABLE PORTLET_CONTENT_TYPE IF EXISTS; 
  +DROP TABLE LANGUAGE IF EXISTS; 
  +DROP TABLE PORTLET_DEFINITION IF EXISTS; 
  +DROP TABLE WEB_APPLICATION IF EXISTS; 
  +DROP TABLE PORTLET_APPLICATION IF EXISTS; 
  +DROP TABLE PORTLET_PREFERENCE IF EXISTS; 
  +DROP TABLE PREFERENCE_VALUE IF EXISTS; 
  +DROP TABLE USER_PREFERENCE_VALUE IF EXISTS; 
  +DROP TABLE PORTLET_ENTITY IF EXISTS; 
  +DROP TABLE LOCALIZED_DESCRIPTION IF EXISTS; 
  +DROP TABLE LOCALIZED_DISPLAY_NAME IF EXISTS; 
  +DROP TABLE SECURITY_ROLE_REFERENCE IF EXISTS;
   
  
  
  

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