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/src/schema cornerstonedemo-schema.xml phase1-schema.xml phase2-schema.xml phase3ojb-schema.xml prefs-schema.xml registry-schema.xml security-schema.xml
Date Sat, 28 Feb 2004 20:52:07 GMT
taylor      2004/02/28 12:52:07

  Added:       src/schema cornerstonedemo-schema.xml phase1-schema.xml
                        phase2-schema.xml phase3ojb-schema.xml
                        prefs-schema.xml registry-schema.xml
                        security-schema.xml
  Log:
  Torque schema for J2 from Serge Huber
  Please do not make any changes to SQL files from here out
  To change SQL, modify these files and regen
  
  Revision  Changes    Path
  1.1                  jakarta-jetspeed-2/src/schema/cornerstonedemo-schema.xml
  
  Index: cornerstonedemo-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
      <table name="TEST_USER">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="LOGIN_NAME" type="VARCHAR"/>
          <column name="FIRST_NAME" type="VARCHAR"/>
          <column name="LAST_NAME" type="VARCHAR"/>
      </table>
      <table name="TEST_GROUP">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="NAME" type="VARCHAR"/>
      </table>
      <table name="TEST_USER_GROUP">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="USER_ID" type="INTEGER"/>
          <column name="GROUP_ID" type="INTEGER"/>
          <foreign-key foreignTable="TEST_GROUP">
              <reference foreign="ID" local="GROUP_ID"/>
          </foreign-key>
          <foreign-key foreignTable="TEST_USER">
              <reference foreign="ID" local="USER_ID"/>
          </foreign-key>
      </table>
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/phase1-schema.xml
  
  Index: phase1-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
      <!--
         Tables for Capability mapping
      -->
  
      <!--
         Media Type
      -->
  
      <table name="MEDIA_TYPE">
          <column name="MEDIATYPE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="CHARACTER_SET" size="40" type="VARCHAR"/>
          <column name="TITLE" size="80" type="VARCHAR"/>
          <column name="DESCRIPTION" type="LONGVARCHAR"/>
      </table>
      
      <!--
         Client
      -->
  
      <table name="CLIENT">
          <column name="CLIENT_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="USER_AGENT_PATTERN" size="128" type="VARCHAR"/>
          <column name="MANUFACTURER" size="80" type="VARCHAR"/>
          <column name="MODEL" size="80" type="VARCHAR"/>
          <column name="VERSION" size="40" type="VARCHAR"/>
          <column name="PREFERRED_MIMETYPE_ID" required="true" type="INTEGER"/>
      </table>
      
      <!--
         Mimetype
      -->
  
      <table name="MIMETYPE">
          <column name="MIMETYPE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
      </table>
      
      <!--
         Capability
      -->
      
      <table name="CAPABILITY">
          <column name="CAPABILITY_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="CAPABILITY" required="true" size="80" type="VARCHAR"/>
      </table>
      
      <!--
         Client association
      -->
      
      <table name="CLIENT_TO_CAPABILITY">
          <column name="CLIENT_ID" required="true" type="INTEGER"/>
          <column name="CAPABILITY_ID" required="true" type="INTEGER"/>
      </table>
      
      <table name="CLIENT_TO_MIMETYPE">
          <column name="CLIENT_ID" required="true" type="INTEGER"/>
          <column name="MIMETYPE_ID" required="true" type="INTEGER"/>
      </table>
      
      <!--
         Media Type association
      -->
      
      <table name="MEDIATYPE_TO_CAPABILITY">
          <column name="MEDIATYPE_ID" required="true" type="INTEGER"/>
          <column name="CAPABILITY_ID" required="true" type="INTEGER"/>
      </table>
      
      <table name="MEDIATYPE_TO_MIMETYPE">
          <column name="MEDIATYPE_ID" required="true" type="INTEGER"/>
          <column name="MIMETYPE_ID" required="true" type="INTEGER"/>
      </table>
      
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/phase2-schema.xml
  
  Index: phase2-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
  
      <!--
         Desktop 
      -->
      
      <table name="DESKTOP">
          <column name="DESKTOP_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
          <column name="COMPONENT_NAME" size="100" type="VARCHAR"/>
          <column name="ACL" size="80" type="VARCHAR"/>
          <column name="DEFAULT_PAGE_ID" size="80" type="VARCHAR"/>
          <column name="DEFAULT_THEME" size="100" type="VARCHAR"/>
          <column name="DEFAULT_DECORATOR" size="100" type="VARCHAR"/>
          <column name="DEFAULT_PORTLET_DECORATOR" size="100" type="VARCHAR"/>
      </table>
      
      <!-- associates a desktop with its top level pages -->
      <table name="DESKTOP_PAGES">
          <column name="DESKTOP_ID" required="true" size="80" type="VARCHAR"/>
          <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>
          <index name="IX_DESKTOP_PAGES_1">
              <index-column name="DESKTOP_ID" />
              <index-column name="PAGE_ID" />
          </index>
      </table>
      
      <!-- associates a page with its sub group pages -->
      <table name="SUB_PAGES">
          <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>
          <column name="SUB_PAGE_ID" required="true" size="80" type="VARCHAR"/>
          <index name="IX_SUB_PAGES_1">
              <index-column name="PAGE_ID" />
              <index-column name="SUB_PAGE_ID" />
          </index>
      </table>
      
      <!--
         Page Definitions
      -->
  
      <table name="PAGE">
          <column name="PAGE_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
          <column name="DEFAULT_SKIN" size="100" type="VARCHAR"/>
          <column name="DEFAULT_DECORATOR" size="100" type="VARCHAR"/>
          <column name="DEFAULT_PORTLET_DECORATOR" size="100" type="VARCHAR"/>
          <column name="ACL" size="80" type="VARCHAR"/>
      </table>
      
      <!--
         Fragments (portlets, layouts)
      -->
  
      <table name="FRAGMENT">
          <column name="FRAGMENT_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="COMPONENT_NAME" size="100" type="VARCHAR"/>
          <column name="ACL" size="80" type="VARCHAR"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
          <column name="TYPE" size="40" type="VARCHAR"/>
          <column name="SKIN" size="80" type="VARCHAR"/>
          <column name="DECORATOR" size="80" type="VARCHAR"/>
          <column name="STATE" size="40" type="VARCHAR"/>
      </table>
      
      <!-- associates a page with its top level fragments -->
      <table name="PAGE_FRAGMENTS">
          <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>
          <column name="FRAGMENT_ID" required="true" size="80" type="VARCHAR"/>
          <index name="IX_PAGE_FRAGMENTS_1">
              <index-column name="PAGE_ID" />
              <index-column name="FRAGMENT_ID" />
          </index>
      </table>
      
      <!-- associates a fragment with its top level fragments -->
      <table name="SUB_FRAGMENTS">
          <column name="FRAGMENT_ID" required="true" size="80" type="VARCHAR"/>
          <column name="SUB_FRAGMENT_ID" required="true" size="80" type="VARCHAR"/>
          <index name="IX_SUB_FRAGMENTS_1">
              <index-column name="FRAGMENT_ID" />
              <index-column name="SUB_FRAGMENT_ID" />
          </index>
      </table>
      
      <table name="FRAGMENT_PARAMETER">
          <column name="PARAMETER_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="FRAGMENT_ID" required="true" type="INTEGER"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="VALUE" required="true" type="LONGVARCHAR"/>
          <unique name="UN_FRAGMENT_PARAMETER_1">
            <unique-column name="FRAGMENT_ID" />
            <unique-column name="PARAMETER_ID" />
          </unique>
      </table>
      
      <!-- names a reference to a fragment subtree -->
      <table name="FRAGMENT_REF">
          <column name="FRAGMENT_REF_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="FRAGMENT_ID" required="true" size="80" type="VARCHAR"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
      </table>
      
      <table name="FRAGMENT_REFS">
          <column name="FRAGMENT_REF_ID" required="true" size="80" type="VARCHAR"/>
          <column name="FRAGMENT_ID" required="true" size="80" type="VARCHAR"/>
      </table>
      
      <!--
         Profiler
      -->
  
      <table name="PROFILING_RULE">
          <column name="RULE_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="CLASS_NAME" required="true" size="100" type="VARCHAR"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
      </table>
      
      <table name="RULE_CRITERION">
          <column name="CRITERION_ID" primaryKey="true" required="true"
              size="80" type="VARCHAR"/>
          <column name="RULE_ID" required="true" size="80" type="VARCHAR"/>
          <column name="FALLBACK_ORDER" required="true" type="INTEGER"/>
          <column name="REQUEST_TYPE" required="true" size="40" type="VARCHAR"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="VALUE" size="128" type="VARCHAR"/>
          <column default="1" name="FALLBACK_TYPE" type="INTEGER"/>
          <index name="IX_RULE_CRITERION_1">
              <index-column name="RULE_ID" />
              <index-column name="FALLBACK_ORDER" />
          </index>
      </table>
      
      <table name="PRINCIPAL_RULE_ASSOC">
          <column name="PRINCIPAL_NAME" required="true" size="80" type="VARCHAR"/>
          <column name="RULE_ID" required="true" size="80" type="VARCHAR"/>
      </table>
      
      <table name="PROFILE_DESKTOP_ASSOC">
          <column name="LOCATOR_HASH" required="true" size="40" type="VARCHAR"/>
          <column name="DESKTOP_ID" required="true" size="80" type="VARCHAR"/>
          <unique name="UN_PROFILE_DESKTOP_1">
            <unique-column name="LOCATOR_HASH" />
            <unique-column name="DESKTOP_ID" />
          </unique>
      </table>
      
      <table name="PROFILE_PAGE_ASSOC">
          <column name="LOCATOR_HASH" required="true" size="40" type="VARCHAR"/>
          <column name="PAGE_ID" required="true" size="80" type="VARCHAR"/>
          <unique name="UN_PROFILE_PAGE_1">
            <unique-column name="LOCATOR_HASH" />
            <unique-column name="PAGE_ID" />
          </unique>
      </table>
      
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/phase3ojb-schema.xml
  
  Index: phase3ojb-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
      <table name="OJB_HL_SEQ">
          <column name="TABLENAME" primaryKey="true" required="true"
              size="175" type="VARCHAR"/>
          <column name="FIELDNAME" primaryKey="true" required="true"
              size="70" type="VARCHAR"/>
          <column name="MAX_KEY" type="INTEGER"/>
          <column name="GRAB_SIZE" type="INTEGER"/>
          <column name="VERSION" type="INTEGER"/>
      </table>
      
      <table name="OJB_LOCKENTRY">
          <column name="OID_" primaryKey="true" required="true" size="250" type="VARCHAR"/>
          <column name="TX_ID" primaryKey="true" required="true" size="50" type="VARCHAR"/>
          <column name="TIMESTAMP_" type="TIMESTAMP"/>
          <column name="ISOLATIONLEVEL" type="INTEGER"/>
          <column name="LOCKTYPE" type="INTEGER"/>
      </table>
      
      <table name="OJB_NRM">
          <column name="NAME" primaryKey="true" required="true" size="250" type="VARCHAR"/>
          <column name="OID_" type="LONGVARBINARY"/>
      </table>
      
      <table name="OJB_DLIST">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="SIZE_" type="INTEGER"/>
      </table>
      
      <table name="OJB_DLIST_ENTRIES">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="DLIST_ID" type="INTEGER"/>
          <column name="POSITION_" type="INTEGER"/>
          <column name="OID_" type="LONGVARBINARY"/>
      </table>
      
      <table name="OJB_DSET">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="SIZE_" type="INTEGER"/>
      </table>
      
      <table name="OJB_DSET_ENTRIES">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="DLIST_ID" type="INTEGER"/>
          <column name="POSITION_" type="INTEGER"/>
          <column name="OID_" type="LONGVARBINARY"/>
      </table>
      
      <table name="OJB_DMAP">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="SIZE_" type="INTEGER"/>
      </table>
      
      <table name="OJB_DMAP_ENTRIES">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="DMAP_ID" type="INTEGER"/>
          <column name="KEY_OID" type="BINARY"/>
          <column name="VALUE_OID" type="BINARY"/>
      </table>
      
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/prefs-schema.xml
  
  Index: prefs-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
  
      <!-- 
         pref_property_set_def
      -->
      <table name="PREF_PROPERTY_SET_DEF">
          <column name="PROPERTY_SET_DEF_ID" primaryKey="true"
              required="true" type="INTEGER"/>
          <column name="PROPERTY_SET_NAME" size="100" type="VARCHAR"/>
          <column name="PROPERTY_SET_TYPE" type="SMALLINT"/>
          <column name="CREATION_DATE" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" type="TIMESTAMP"/>
      </table>
      
      <!--
         pref_node
      -->
      <table name="PREF_NODE">
          <column name="NODE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PARENT_NODE_ID" type="INTEGER"/>
          <column name="PROPERTY_SET_DEF_ID" type="INTEGER"/>
          <column name="NODE_NAME" size="100" type="VARCHAR"/>
          <column name="NODE_TYPE" type="SMALLINT"/>
          <column name="FULL_PATH" size="254" type="VARCHAR"/>
          <column name="CREATION_DATE" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" type="TIMESTAMP"/>
          <foreign-key foreignTable="PREF_PROPERTY_SET_DEF">
              <reference foreign="PROPERTY_SET_DEF_ID" local="PROPERTY_SET_DEF_ID"/>
          </foreign-key>
          <foreign-key foreignTable="PREF_NODE">
              <reference foreign="NODE_ID" local="PARENT_NODE_ID"/>
          </foreign-key>
      </table>
      
      <!--
         pref_property_value
      -->
      <table name="PREF_PROPERTY_VALUE">
          <column name="PROPERTY_VALUE_ID" primaryKey="true"
              required="true" type="INTEGER"/>
          <column name="PROPERTY_KEY_ID" type="INTEGER"/>
          <column name="NODE_ID" type="INTEGER"/>
          <column name="BOOLEAN_VALUE" type="BIT"/>
          <column name="DATETIME_VALUE" type="TIMESTAMP"/>
          <column name="LONG_VALUE" type="INTEGER"/>
          <column name="DOUBLE_VALUE" type="DOUBLE"/>
          <column name="TEXT_VALUE" size="254" type="VARCHAR"/>
          <column name="CREATION_DATE" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" type="TIMESTAMP"/>
          <foreign-key foreignTable="PREF_PROPERTY_KEY">
              <reference foreign="PROPERTY_KEY_ID" local="PROPERTY_KEY_ID"/>
          </foreign-key>
          <foreign-key foreignTable="PREF_NODE">
              <reference foreign="NODE_ID" local="NODE_ID"/>
          </foreign-key>
      </table>
      
      <!--
         pref_property_key
      -->
      <table name="PREF_PROPERTY_KEY">
          <column name="PROPERTY_KEY_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PROPERTY_SET_DEF_ID" type="INTEGER"/>
          <column name="PROPERTY_NAME" size="100" type="VARCHAR"/>
          <column name="PROPERTY_TYPE" type="SMALLINT"/>
          <column name="CREATION_DATE" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" type="TIMESTAMP"/>
          <foreign-key foreignTable="PREF_PROPERTY_SET_DEF">
              <reference foreign="PROPERTY_SET_DEF_ID" local="PROPERTY_SET_DEF_ID"/>
          </foreign-key>
      </table>
      
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/registry-schema.xml
  
  Index: registry-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
  
      <!--
         Create Portlet Application Metadata Table 
      -->
      <table name="PA_METADATA">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
      </table>
      
      <!--
         Create Portlet Application Metadata Fields Table
      -->    
      <table name="PA_METADATA_FIELDS">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="OBJECT_ID" required="true" type="INTEGER"/>
          <column name="VALUE" required="true" type="LONGVARCHAR"/>
          <column name="NAME" required="true" size="100" type="VARCHAR"/>
          <column name="LOCALE_STRING" required="true" size="50" type="VARCHAR"/>
      </table>
      
      <!--
         Create Portlet Application Table
      -->
      <table name="PORTLET_APPLICATION">
          <column name="APPLICATION_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="APP_NAME" required="true" size="80" type="VARCHAR"/>
          <column name="APP_IDENTIFIER" size="80" type="VARCHAR"/>
          <column name="VERSION" size="80" type="VARCHAR"/>
          <column name="APP_TYPE" type="INTEGER"/>
          <column name="DESCRIPTION" size="80" type="VARCHAR"/>
          <column name="WEB_APP_ID" required="true" type="INTEGER"/>
          <column name="METADATA_ID" required="true" type="INTEGER"/>
          <unique name="UK_APPLICATION">
              <unique-column name="APP_NAME"/>
          </unique>
      </table>
      
      <!--
         Create Web Application Table
      -->
      <table name="WEB_APPLICATION">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="CONTEXT_ROOT" required="true" size="255" type="VARCHAR"/>
      </table>
      
      <!--
         Create Portlet Definition Table
      -->
      <table name="PORTLET_DEFINITION">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="NAME" size="80" type="VARCHAR"/>
          <column name="CLASS_NAME" size="100" type="VARCHAR"/>
          <column name="APPLICATION_ID" required="true" type="INTEGER"/>
          <column name="PORTLET_IDENTIFIER" size="80" type="VARCHAR"/>
          <column name="EXPIRATION_CACHE" size="30" type="VARCHAR"/>
          <column name="PREFERENCE_VALIDATOR" size="255" type="VARCHAR"/>
          <!-- This breaks some tests since portlet identifier is not required
          <unique name="UK_PORTLET_IDENT">
              <unique-column name="PORTLET_IDENTIFIER"/>
          </unique>
          -->
      </table>
      
      <!--
         Create Language Table
      -->
      <table name="LANGUAGE">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PORTLET_ID" required="true" type="INTEGER"/>
          <column name="TITLE" size="100" type="VARCHAR"/>
          <column name="SHORT_TITLE" size="50" type="VARCHAR"/>
          <column name="LOCALE_STRING" required="true" size="50" type="VARCHAR"/>
          <column name="KEYWORDS" type="LONGVARCHAR"/>
      </table>
      
      <!--
         Create Content Type Table
      -->
      <table name="PORTLET_CONTENT_TYPE">
          <column name="CONTENT_TYPE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PORTLET_ID" required="true" type="INTEGER"/>
          <column name="CONTENT_TYPE" required="true" size="30" type="VARCHAR"/>
          <column name="MODES" type="LONGVARCHAR"/>
      </table>
      
      <!--
         Create Parameter Table
         NOTE : This table supports both Servlet and Portlet parameters
         Class Name is required to decide if this is a portlet or servlet parameter
      -->
      <table name="PARAMETER">
          <column name="PARAMETER_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PARENT_ID" required="true" type="INTEGER"/>
          <column name="CLASS_NAME" required="true" size="30" type="VARCHAR"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="PARAMETER_VALUE" required="true" type="LONGVARCHAR"/>
      </table>
      
      <!--
        Preference and Preference Values
      -->
      <table name="PORTLET_PREFERENCE">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PARENT_ID" required="true" type="INTEGER"/>
          <column name="NAME" required="true" size="80" type="VARCHAR"/>
          <column name="CLASS_NAME" required="true" size="50" type="VARCHAR"/>
          <column default="1" name="READ_ONLY" size="1" type="CHAR"/>
      </table>
      
      <table name="PREFERENCE_VALUE">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PREFERENCE_ID" type="INTEGER"/>
          <column name="VALUE" type="LONGVARCHAR"/>
      </table>
      
      <!--
         Portlet Entity
         Represents the managed state of individual portlet
         instance within a "page"
      -->
      <table name="PORTLET_ENTITY">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PORTLET_DEFINITION_ID" required="true" type="INTEGER"/>
          <column name="GUID" required="true" size="255" type="VARCHAR"/>
      </table>
      
      <!--
         Security Role Reference
      -->
      <table name="SECURITY_ROLE_REFERENCE">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PORTLET_DEFINITION_ID" required="true" type="INTEGER"/>
          <column name="ROLE_NAME" size="150" type="VARCHAR"/>
          <column name="ROLE_LINK" size="150" type="VARCHAR"/>
      </table>
      
      <!-- 
         Localized Descriptions
      -->
      <table name="LOCALIZED_DESCRIPTION">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="OBJECT_ID" required="true" type="INTEGER"/>
          <column name="CLASS_NAME" required="true" size="255" type="VARCHAR"/>
          <column name="DESCRIPTION" required="true" type="LONGVARCHAR"/>
          <column name="LOCALE_STRING" required="true" size="50" type="VARCHAR"/>
      </table>
      
      <!--
         Localized Display Names
      -->
      <table name="LOCALIZED_DISPLAY_NAME">
          <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="OBJECT_ID" required="true" type="INTEGER"/>
          <column name="CLASS_NAME" size="255" type="VARCHAR"/>
          <column name="DISPLAY_NAME" required="true" type="LONGVARCHAR"/>
          <column name="LOCALE_STRING" required="true" size="50" type="VARCHAR"/>
      </table>
  </database>
  
  
  
  1.1                  jakarta-jetspeed-2/src/schema/security-schema.xml
  
  Index: security-schema.xml
  ===================================================================
  <?xml version="1.0"?>
  <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
  <!-- Autogenerated by JDBCToXMLSchema! -->
  <database>
  
      <!--
         Create Security Principal Table
      -->
      <table name="SECURITY_PRINCIPAL">
          <column name="PRINCIPAL_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="CLASSNAME" required="true" size="254" type="VARCHAR"/>
          <column name="FULL_PATH" required="true" size="254" type="VARCHAR"/>
          <column name="CREATION_DATE" required="true" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" required="true" type="TIMESTAMP"/>
      </table>
      
      <!--
         Create Security Credential Table
      -->
      <table name="SECURITY_CREDENTIAL">
          <column name="CREDENTIAL_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PRINCIPAL_ID" required="true" type="INTEGER"/>
          <column name="VALUE" required="true" size="254" type="VARCHAR"/>
          <column name="TYPE" required="true" type="SMALLINT"/>
          <column name="CLASSNAME" size="254" type="VARCHAR"/>
          <column name="CREATION_DATE" required="true" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" required="true" type="TIMESTAMP"/>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
          </foreign-key>
      </table>
      
      <!--
         Create Security User Role Table
      -->
      <table name="SECURITY_USER_ROLE">
          <column name="USER_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="ROLE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="ROLE_ID"/>
          </foreign-key>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="USER_ID"/>
          </foreign-key>
      </table>
      
      <!-- 
         Create Security User Group Table
      -->
      <table name="SECURITY_USER_GROUP">
          <column name="USER_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="GROUP_ID" primaryKey="true" required="true" type="INTEGER"/>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="GROUP_ID"/>
          </foreign-key>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="USER_ID"/>
          </foreign-key>
      </table>
      
      <!--
         Create Security Group Role Table
      -->
      <table name="SECURITY_GROUP_ROLE">
          <column name="GROUP_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="ROLE_ID" primaryKey="true" required="true" type="INTEGER"/>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="GROUP_ID"/>
          </foreign-key>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="ROLE_ID"/>
          </foreign-key>
      </table>
      
      <!--
         Create Security Permission Table
      -->
      <table name="SECURITY_PERMISSION">
          <column name="PERMISSION_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="CLASSNAME" required="true" size="254" type="VARCHAR"/>
          <column name="NAME" required="true" size="254" type="VARCHAR"/>
          <column name="ACTIONS" required="true" size="254" type="VARCHAR"/>
          <column name="CREATION_DATE" required="true" type="TIMESTAMP"/>
          <column name="MODIFIED_DATE" required="true" type="TIMESTAMP"/>
      </table>
      
      <!--
         Create Security Principal Permission Table
      -->
      <table name="SECURITY_PRINCIPAL_PERMISSION">
          <column name="PRINCIPAL_ID" primaryKey="true" required="true" type="INTEGER"/>
          <column name="PERMISSION_ID" primaryKey="true" required="true" type="INTEGER"/>
          <foreign-key foreignTable="SECURITY_PERMISSION">
              <reference foreign="PERMISSION_ID" local="PERMISSION_ID"/>
          </foreign-key>
          <foreign-key foreignTable="SECURITY_PRINCIPAL">
              <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
          </foreign-key>
      </table>
  </database>
  
  
  

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