You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2002/06/20 07:14:45 UTC
cvs commit: jakarta-jetspeed/build/torque/schema security-schema.xml
taylor 2002/06/19 22:14:45
Modified: build/torque/schema Tag: security_14 security-schema.xml
Log:
added cascade deletes
Revision Changes Path
No revision
No revision
1.1.2.8 +6 -6 jakarta-jetspeed/build/torque/schema/Attic/security-schema.xml
Index: security-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/schema/Attic/security-schema.xml,v
retrieving revision 1.1.2.7
retrieving revision 1.1.2.8
diff -u -r1.1.2.7 -r1.1.2.8
--- security-schema.xml 18 Jun 2002 06:49:33 -0000 1.1.2.7
+++ security-schema.xml 20 Jun 2002 05:14:45 -0000 1.1.2.8
@@ -75,11 +75,11 @@
<column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/>
- <foreign-key foreignTable="TURBINE_ROLE">
+ <foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
- <foreign-key foreignTable="TURBINE_PERMISSION">
+ <foreign-key foreignTable="TURBINE_PERMISSION" onDelete="cascade">
<reference local="PERMISSION_ID" foreign="PERMISSION_ID"/>
</foreign-key>
</table>
@@ -89,15 +89,15 @@
<column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
- <foreign-key foreignTable="TURBINE_USER">
+ <foreign-key foreignTable="TURBINE_USER" onDelete="cascade">
<reference local="USER_ID" foreign="USER_ID"/>
</foreign-key>
- <foreign-key foreignTable="TURBINE_GROUP">
+ <foreign-key foreignTable="TURBINE_GROUP" onDelete="cascade">
<reference local="GROUP_ID" foreign="GROUP_ID"/>
</foreign-key>
- <foreign-key foreignTable="TURBINE_ROLE">
+ <foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
</table>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>