Author: ate
Date: Wed Sep 24 14:07:52 2008
New Revision: 698736
URL: http://svn.apache.org/viewvc?rev=698736&view=rev
Log:
dropping not used principal parent_id field (now fully covered through
associations)
Modified:
portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
Modified:
portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
URL:
http://svn.apache.org/viewvc/portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml?rev=698736&r1=698735&r2=698736&view=diff
==============================================================================
---
portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
(original)
+++
portals/jetspeed-2/portal/branches/security-refactoring/jetspeed-portal-resources/src/main/ddl-schema/security-schema.xml
Wed Sep 24 14:07:52 2008
@@ -42,7 +42,6 @@
<column name="PRINCIPAL_TYPE" required="true" size="20"
type="VARCHAR"/>
<column name="PRINCIPAL_NAME" required="true" size="200"
type="VARCHAR"/>
<column name="IS_MAPPED" required="true" type="BOOLEANINT"/>
- <column name="PARENT_ID" required="false" type="INTEGER"/>
<column name="IS_ENABLED" required="true" type="BOOLEANINT"/>
<column name="IS_READONLY" required="true" type="BOOLEANINT"/>
<column name="IS_REMOVABLE" required="true" type="BOOLEANINT"/>
@@ -52,12 +51,6 @@
<unique-column name="PRINCIPAL_TYPE" />
<unique-column name="PRINCIPAL_NAME" />
</unique>
- <index name="IX_PARENT_PRINCIPAL">
- <index-column name="PARENT_ID"/>
- </index>
- <foreign-key foreignTable="SECURITY_PRINCIPAL"
name="FK_PARENT_PRINCIPAL" onDelete="cascade">
- <reference foreign="PRINCIPAL_ID" local="PARENT_ID"/>
- </foreign-key>
</table>
<!--
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
