taylor 2004/07/19 21:13:00
Modified: src/torque-schema registry-schema.xml
Log:
update registry schema
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.9 +18 -24 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.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- registry-schema.xml 19 Jul 2004 06:05:51 -0000 1.8
+++ registry-schema.xml 20 Jul 2004 04:13:00 -0000 1.9
@@ -39,10 +39,9 @@
<column name="CLASSNAME" size="255" 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="PARENT" size="128" type="VARCHAR"/>
<column name="URL" size="255" type="VARCHAR" javaName="URL"/>
- <column name="CACHEDONURL" type="BOOLEANINT" default="1"/>
- <column name="ROLE" size="99" type="VARCHAR"/>
+ <column name="CACHED_ON_URL" type="BOOLEANINT" default="1"/>
<column name="TITLE" size="128" type="VARCHAR"/>
<column name="DESCRIPTION" size="255" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
@@ -53,7 +52,8 @@
</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"/>
@@ -66,17 +66,18 @@
<unique name="uk_mediatype_name">
<unique-column name="NAME"/>
- </unique>
-
+ </unique>
</table>
- <table name="category" idMethod="native" javaName="PortletCategory">
+-->
+
+ <table name="portlet_category" idMethod="native">
<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"/>
+ <column name="PORTLET_ID" type="BIGINT"/>
<foreign-key foreignTable="portlet" onDelete="cascade">
- <reference local="OWNER" foreign="ID"/>
+ <reference local="PORTLET_ID" foreign="ID"/>
</foreign-key>
</table>
@@ -88,15 +89,13 @@
<column name="VALUE" size="255" 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="CACHED_ON_VALUE" type="BOOLEANINT" default="1"/>
+ <column name="CACHED_ON_NAME" type="BOOLEANINT" default="1"/>
<column name="TITLE" size="128" type="VARCHAR"/>
<column name="DESCRIPTION" size="255" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
<column name="PORTLET_ID" type="BIGINT" />
<column name="SECURITY" size="128" type="VARCHAR" javaName="securityRef"/>
-
<foreign-key foreignTable="portlet" onDelete="cascade">
<reference local="PORTLET_ID" foreign="ID"/>
</foreign-key>
@@ -105,16 +104,11 @@
<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="NAME" required="true" size="128" type="VARCHAR"/>
+ <column name="PORTLET_ID" type="BIGINT" />
+ <foreign-key foreignTable="portlet" onDelete="cascade">
+ <reference local="PORTLET_ID" foreign="ID"/>
+ </foreign-key>
</table>
<table name="security_entry" idMethod="native" javaName="SecurityDbEntry">
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
