Author: david
Date: Fri Sep  4 16:01:30 2009
New Revision: 3174

Log:
Add ACL plugin and initial schema.

Added:
   trunk/plugins/qbAclPlugin/
   trunk/plugins/qbAclPlugin/config/
   trunk/plugins/qbAclPlugin/config/schema.yml

Added: trunk/plugins/qbAclPlugin/config/schema.yml
==============================================================================
--- /dev/null   00:00:00 1970   (empty, because file is newly added)
+++ trunk/plugins/qbAclPlugin/config/schema.yml Fri Sep  4 16:01:30 2009        
(r3174)
@@ -0,0 +1,36 @@
+propel:
+  _attributes:      { package: plugins.qbAclPlugin.lib.model }
+
+  acl_condition:
+    id:             ~
+    name:           { type: varchar, size: 255 }
+    definition:     { type: longvarchar }
+  
+  acl_group:
+    _attributes:    { phpName: aclRole }
+    id:             ~
+    parent_id:      { type: integer, required: false, foreignTable: acl_group, 
foreignReference: id, onDelete: cascade }
+    name:           { type: varchar, size: 255, required: true, index: unique }
+    description:    { type: longvarchar }
+    condition_id:   { type: integer, foreignTable: acl_condition, 
foreignReference: id, onDelete: setnull }
+  
+  acl_permission:
+    _attributes:    { phpName: aclPermission }
+    id:             ~
+    name:           { type: varchar, size: 255, required: true, index: unique }
+    description:    { type: longvarchar }
+    condition_id:   { type: integer, foreignTable: acl_condition, 
foreignReference: id, onDelete: setnull }
+  
+  acl_user_group:
+    _attributes:    { phpName: aclUserRole }
+    user_id:        { type: integer, primaryKey: true, required: true, 
foreignTable: user, foreignReference: id, onDelete: cascade }
+    group_id:        { type: integer, primaryKey: true, required: true, 
foreignTable: acl_group, foreignReference: id, onDelete: cascade }
+    condition_id:   { type: integer, foreignTable: acl_condition, 
foreignReference: id, onDelete: setnull }
+  
+  acl_group_object_permission:
+    _attributes:    { phpName: aclRoleObjectPermission }
+    group_id:        { type: integer, foreignTable: acl_group, 
foreignReference: id, onDelete: cascade }
+    object_id:      { type: integer, foreignTable: object, foreignReference: 
id, onDelete: cascade }
+    permission_id:  { type: integer, required: true, foreignTable: 
acl_permission, foreignReference: id, onDelete: cascade }
+    grant_deny:     { type: integer, required: true, default: 0 }
+    condition_id:   { type: integer, foreignTable: acl_condition, 
foreignReference: id, onDelete: setnull }

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.ca/group/qubit-commits?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to