You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@continuum.apache.org by ca...@apache.org on 2006/09/07 03:55:04 UTC

svn commit: r440938 - /maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql

Author: carlos
Date: Wed Sep  6 18:55:03 2006
New Revision: 440938

URL: http://svn.apache.org/viewvc?view=rev&rev=440938
Log:
Add ON DELETE constraints

Modified:
    maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql

Modified: maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql
URL: http://svn.apache.org/viewvc/maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql?view=diff&rev=440938&r1=440937&r2=440938
==============================================================================
--- maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql (original)
+++ maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql Wed Sep  6 18:55:03 2006
@@ -6,7 +6,7 @@
      parent_object INTEGER,
      acl_class VARCHAR(250) NOT NULL,
      CONSTRAINT unique_object_identity UNIQUE(object_identity),
-     FOREIGN KEY (parent_object) REFERENCES acl_object_identity(id)
+     FOREIGN KEY (parent_object) REFERENCES acl_object_identity(id) ON DELETE CASCADE
 );
 
 CREATE TABLE acl_permission (
@@ -15,7 +15,7 @@
      recipient VARCHAR(100) NOT NULL,
      mask INTEGER NOT NULL,
      CONSTRAINT unique_recipient UNIQUE(acl_object_identity, recipient),
-     FOREIGN KEY (acl_object_identity) REFERENCES acl_object_identity(id)
+     FOREIGN KEY (acl_object_identity) REFERENCES acl_object_identity(id) ON DELETE CASCADE
 );
 
 --INSERT INTO acl_object_identity (object_identity, parent_object, acl_class) VALUES ('org.apache.maven.continuum.model.project.ProjectGroup:1', null, 'org.acegisecurity.acl.basic.SimpleAclEntry');