taylor 2004/07/13 15:47:07
Modified: src/torque-schema registry-schema.xml
Log:
update database registry schema for Security constraints support
CVS: ----------------------------------------------------------------------
CVS: PR:
CVS: If this change addresses a PR in the problem report tracking
CVS: database, then enter the PR number(s) here.
CVS: Obtained from:
CVS: If this change has been taken from another system, such as NCSA,
CVS: then name the system in this line, otherwise delete it.
CVS: Submitted by:
CVS: If this code has been contributed to Apache by someone else; i.e.,
CVS: they sent us a patch or a new module, then include their name/email
CVS: address here. If this is your work then delete this line.
CVS: Reviewed by:
CVS: If we are doing pre-commit code reviews and someone else has
CVS: reviewed your changes, include their name(s) here.
CVS: If you have not had it reviewed then delete this line.
Revision Changes Path
1.6 +80 -64 jakarta-jetspeed/src/torque-schema/registry-schema.xml
Index: registry-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/torque-schema/registry-schema.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- registry-schema.xml 12 Jul 2004 17:22:27 -0000 1.5
+++ registry-schema.xml 13 Jul 2004 22:47:07 -0000 1.6
@@ -40,18 +40,18 @@
<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>
-
+ <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">
@@ -59,26 +59,26 @@
<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>
-
+ <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>
-
+ <column name="OWNER" type="BIGINT"/>
+
+ <foreign-key foreignTable="PORTLET" onDelete="cascade">
+ <reference local="OWNER" foreign="ID"/>
+ </foreign-key>
+
</table>
@@ -87,55 +87,71 @@
<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"/>
+ <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>
+ <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>
-
+ <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>
- <table name="SECURITY_ENTRY" idMethod="native">
- <column name="ID" required="true" type="BIGINT"/>
+ <table name="SECURITY_ENTRY" idMethod="native" javaName="SecurityDbEntry">
+ <column name="ID" required="true" type="BIGINT" primaryKey="true"
autoIncrement="true"/>
<column name="NAME" required="true" size="128" type="VARCHAR"/>
- <column name="TITLE" size="128" type="VARCHAR"/>
- <column name="DESCRIPTION" size="256" type="VARCHAR"/>
- </table>
+ <column name="TITLE" size="128" type="VARCHAR"/>
+ <column name="DESCRIPTION" size="256" type="VARCHAR"/>
+
+ <unique name="uk_constraint_name">
+ <unique-column name="NAME"/>
+ </unique>
+
+ </table>
- <table name="SECURITY_ACCESS" idMethod="native">
- <column name="ID" required="true" type="BIGINT"/>
+ <table name="SECURITY_ACCESS" idMethod="native"
javaName="SecurityAccessDbEntry">
+ <column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="ACTION" required="true" size="32" type="VARCHAR"/>
+
+ <column name="ENTRY_ID" type="BIGINT"/>
+
+ <foreign-key foreignTable="SECURITY_ENTRY" onDelete="cascade">
+ <reference local="ENTRY_ID" foreign="ID"/>
+ </foreign-key>
+
+ </table>
+
+ <table name="SECURITY_ALLOW" idMethod="native" javaName="SecurityAllowDbEntry">
+ <column name="ID" required="true" primaryKey="true" autoIncrement="true"
type="BIGINT"/>
<column name="ALLOW_TYPE" required="true" size="32" type="VARCHAR"/>
<column name="ALLOW_VALUE" required="true" size="32" type="VARCHAR"/>
- <column name="ENTRY_ID" type="BIGINT"/>
-
- <foreign-key foreignTable="SECURITY_ENTRY" onDelete="cascade">
- <reference local="ENTRY_ID" foreign="ID"/>
- </foreign-key>
-
- </table>
-
+ <column name="ACCESS_ID" type="BIGINT"/>
+
+ <foreign-key foreignTable="SECURITY_ACCESS" onDelete="cascade">
+ <reference local="ACCESS_ID" foreign="ID"/>
+ </foreign-key>
+
+ </table>
+
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
