taylor 2004/04/22 10:21:04
Added: src/torque-schema registry-schema.xml
Log:
added registry schema for DB Registry
still doubtful i'll get this in the release today
Revision Changes Path
1.1 jakarta-jetspeed/src/torque-schema/registry-schema.xml
Index: registry-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";>
<!-- ==================================================================== -->
<!-- -->
<!-- R E G I S T R Y S C H E M A -->
<!-- -->
<!-- ==================================================================== -->
<!-- This is the the XML schema used by Torque to generate the necessary -->
<!-- sources used to create/initialize the base Jetspeed default security -->
<!-- Torque creates SQL for the database required by Jetspeed, and the -->
<!-- Peer-based Object Model used by Jetspeed internally to manage -->
<!-- users, and security. -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:[EMAIL PROTECTED]">David Sean Taylor</a> -->
<!-- @version $Id: registry-schema.xml,v 1.1 2004/04/22 17:21:04 taylor Exp $
-->
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.dbregistry">
<table name="PORTLET" idMethod="native" javaName="PortletDbEntry">
<column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="NAME" required="true" size="128" type="VARCHAR"/>
<column name="HIDDEN" type="BOOLEANINT" default="0"/>
<column name="CLASSNAME" size="265" type="VARCHAR"/>
<column name="TYPE" size="32" type="VARCHAR" required="true"/>
<column name="APPLICATION" type="BOOLEANINT" default="0"/>
<column name="PARENT" type="BIGINT" javaName="parentRef"/>
<column name="URL" size="265" type="VARCHAR" javaName="URL"/>
<column name="CACHEDONURL" type="BOOLEANINT" default="1"/>
<column name="ROLE" size="99" type="VARCHAR"/>
<column name="TITLE" size="128" type="VARCHAR"/>
<column name="DESCRIPTION" size="256" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
<column name="SECURITY" size="500" type="VARCHAR" javaName="securityRef"/>
<unique name="uk_portlet_name">
<unique-column name="NAME"/>
</unique>
</table>
<table name="MEDIATYPE" idMethod="native">
<column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="NAME" required="true" size="128" type="VARCHAR"/>
<column name="HIDDEN" type="BOOLEANINT" default="0"/>
<column name="MIMETYPE" size="128" type="VARCHAR"/>
<column name="ROLE" size="99" type="VARCHAR"/>
<column name="TITLE" size="128" type="VARCHAR"/>
<column name="DESCRIPTION" size="256" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
<unique name="uk_mediatype_name">
<unique-column name="NAME"/>
</unique>
</table>
<table name="CATEGORY" idMethod="native" javaName="PortletCategory">
<column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="NAME" required="true" size="128" type="VARCHAR"/>
<column name="GROUPE" size="128" type="VARCHAR" required="true"
javaName="Group"/>
<column name="OWNER" type="BIGINT"/>
<foreign-key foreignTable="PORTLET" onDelete="cascade">
<reference local="OWNER" foreign="ID"/>
</foreign-key>
</table>
<table name="PORTLET_PARAMETER" idMethod="native">
<column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="NAME" required="true" size="128" type="VARCHAR"/>
<column name="VALUE" size="256" type="VARCHAR" default="0"/>
<column name="TYPE" size="64" type="VARCHAR"/>
<column name="HIDDEN" type="BOOLEANINT" default="0"/>
<column name="ROLE" size="99" type="VARCHAR"/>
<column name="CACHEDONVALUE" type="BOOLEANINT" default="1"/>
<column name="CACHEDONNAME" type="BOOLEANINT" default="1"/>
<column name="TITLE" size="128" type="VARCHAR"/>
<column name="DESCRIPTION" size="256" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
<column name="PORTLET_ID" type="BIGINT" />
<column name="SECURITY" size="500" type="VARCHAR" javaName="securityRef"/>
<foreign-key foreignTable="PORTLET" onDelete="cascade">
<reference local="PORTLET_ID" foreign="ID"/>
</foreign-key>
</table>
<table name="PORTLET_MEDIATYPE" idMethod="native">
<column name="ID" required="true" type="BIGINT"/>
<column name="MEDIA_ID" type="BIGINT"/>
<foreign-key foreignTable="PORTLET" onDelete="cascade">
<reference local="ID" foreign="ID"/>
</foreign-key>
<foreign-key foreignTable="MEDIATYPE" onDelete="cascade">
<reference local="MEDIA_ID" foreign="ID"/>
</foreign-key>
</table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
