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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]