taylor 2004/07/18 23:05:51
Modified: src/torque-schema registry-schema.xml
Log:
a few adjustments to work with MySQL
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.8 +24 -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.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- registry-schema.xml 15 Jul 2004 01:14:59 -0000 1.7
+++ registry-schema.xml 19 Jul 2004 06:05:51 -0000 1.8
@@ -32,21 +32,21 @@
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.dbregistry">
- <table name="PORTLET" idMethod="native" javaName="PortletDbEntry">
+ <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="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="URL" size="265" type="VARCHAR" javaName="URL"/>
+ <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="TITLE" size="128" type="VARCHAR"/>
- <column name="DESCRIPTION" size="256" type="VARCHAR"/>
+ <column name="DESCRIPTION" size="255" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
- <column name="SECURITY" size="500" type="VARCHAR" javaName="securityRef"/>
+ <column name="SECURITY" size="128" type="VARCHAR" javaName="securityRef"/>
<unique name="uk_portlet_name">
<unique-column name="NAME"/>
@@ -54,14 +54,14 @@
</table>
- <table name="MEDIATYPE" idMethod="native">
+ <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="DESCRIPTION" size="255" type="VARCHAR"/>
<column name="IMAGE" size="128" type="VARCHAR"/>
<unique name="uk_mediatype_name">
@@ -69,59 +69,59 @@
</unique>
</table>
- <table name="CATEGORY" idMethod="native" javaName="PortletCategory">
+ <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">
+ <foreign-key foreignTable="portlet" onDelete="cascade">
<reference local="OWNER" foreign="ID"/>
</foreign-key>
</table>
- <table name="PORTLET_PARAMETER" idMethod="native">
+ <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="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="TITLE" size="128" type="VARCHAR"/>
- <column name="DESCRIPTION" size="256" 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="500" type="VARCHAR" javaName="securityRef"/>
+ <column name="SECURITY" size="128" type="VARCHAR" javaName="securityRef"/>
- <foreign-key foreignTable="PORTLET" onDelete="cascade">
+ <foreign-key foreignTable="portlet" onDelete="cascade">
<reference local="PORTLET_ID" foreign="ID"/>
</foreign-key>
</table>
- <table name="PORTLET_MEDIATYPE" idMethod="native">
+ <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">
+ <foreign-key foreignTable="portlet" onDelete="cascade">
<reference local="ID" foreign="ID"/>
</foreign-key>
- <foreign-key foreignTable="MEDIATYPE" onDelete="cascade">
+ <foreign-key foreignTable="mediatype" onDelete="cascade">
<reference local="MEDIA_ID" foreign="ID"/>
</foreign-key>
</table>
- <table name="SECURITY_ENTRY" idMethod="native" javaName="SecurityDbEntry">
+ <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"/>
+ <column name="DESCRIPTION" size="255" type="VARCHAR"/>
<unique name="uk_constraint_name">
<unique-column name="NAME"/>
@@ -129,26 +129,26 @@
</table>
- <table name="SECURITY_ACCESS" idMethod="native"
javaName="SecurityAccessDbEntry">
+ <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">
+ <foreign-key foreignTable="security_entry" onDelete="cascade">
<reference local="ENTRY_ID" foreign="ID"/>
</foreign-key>
</table>
- <table name="SECURITY_ALLOW" idMethod="native" javaName="SecurityAllowDbEntry">
+ <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="ALLOW_GROUP" required="false" size="32" type="VARCHAR"/>
<column name="ACCESS_ID" type="BIGINT"/>
- <foreign-key foreignTable="SECURITY_ACCESS" onDelete="cascade">
+ <foreign-key foreignTable="security_access" onDelete="cascade">
<reference local="ACCESS_ID" foreign="ID"/>
</foreign-key>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
