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]

Reply via email to