continuum-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From car...@apache.org
Subject 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
Date Thu, 07 Sep 2006 01:55:04 GMT
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');



Mime
View raw message