You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2004/02/28 21:52:07 UTC
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
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