Author: david
Date: Tue Sep 8 15:12:02 2009
New Revision: 3196
Log:
add 'created_at' and 'updated_at' columns for ACL groups and permissions.
Modified:
trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql
trunk/plugins/qbAclPlugin/config/schema.yml
trunk/plugins/qbAclPlugin/lib/model/map/AclGroupMapBuilder.php
trunk/plugins/qbAclPlugin/lib/model/map/AclPermissionMapBuilder.php
trunk/plugins/qbAclPlugin/lib/model/om/BaseAclGroup.php
trunk/plugins/qbAclPlugin/lib/model/om/BaseAclPermission.php
Modified: trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql
==============================================================================
--- trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql Tue Sep 8
15:08:10 2009 (r3195)
+++ trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql Tue Sep 8
15:12:02 2009 (r3196)
@@ -51,6 +51,8 @@
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
+ `created_at` DATETIME NOT NULL,
+ `updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_acl_group_FI_1` (`parent_id`),
@@ -96,6 +98,8 @@
`action_id` INTEGER NOT NULL,
`grant_deny` INTEGER default 0 NOT NULL,
`conditional` TEXT,
+ `created_at` DATETIME NOT NULL,
+ `updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_acl_permission_FI_1` (`group_id`),
CONSTRAINT `q_acl_permission_FK_1`
Modified: trunk/plugins/qbAclPlugin/config/schema.yml
==============================================================================
--- trunk/plugins/qbAclPlugin/config/schema.yml Tue Sep 8 15:08:10 2009
(r3195)
+++ trunk/plugins/qbAclPlugin/config/schema.yml Tue Sep 8 15:12:02 2009
(r3196)
@@ -16,6 +16,8 @@
parent_id: { type: integer, foreignTable: acl_group,
foreignReference: id, onDelete: cascade }
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
+ created_at:
+ updated_at:
acl_group_i18n:
_attributes: { phpName: aclGroupI18n }
@@ -30,6 +32,8 @@
action_id: { type: integer, required: true, foreignTable: acl_action,
foreignReference: id, onDelete: cascade }
grant_deny: { type: integer, required: true, default: 0 }
conditional: { type: longvarchar }
+ created_at:
+ updated_at:
acl_user_group:
_attributes: { phpName: aclUserGroup }
Modified: trunk/plugins/qbAclPlugin/lib/model/map/AclGroupMapBuilder.php
==============================================================================
--- trunk/plugins/qbAclPlugin/lib/model/map/AclGroupMapBuilder.php Tue Sep
8 15:08:10 2009 (r3195)
+++ trunk/plugins/qbAclPlugin/lib/model/map/AclGroupMapBuilder.php Tue Sep
8 15:12:02 2009 (r3196)
@@ -41,6 +41,10 @@
$tMap->addColumn('RGT', 'rgt', 'INTEGER', true, null);
+ $tMap->addColumn('CREATED_AT', 'createdAt', 'TIMESTAMP', true,
null);
+
+ $tMap->addColumn('UPDATED_AT', 'updatedAt', 'TIMESTAMP', true,
null);
+
$tMap->addColumn('SOURCE_CULTURE', 'sourceCulture', 'VARCHAR',
true, 7);
}
Modified: trunk/plugins/qbAclPlugin/lib/model/map/AclPermissionMapBuilder.php
==============================================================================
--- trunk/plugins/qbAclPlugin/lib/model/map/AclPermissionMapBuilder.php Tue Sep
8 15:08:10 2009 (r3195)
+++ trunk/plugins/qbAclPlugin/lib/model/map/AclPermissionMapBuilder.php Tue Sep
8 15:12:02 2009 (r3196)
@@ -45,5 +45,9 @@
$tMap->addColumn('CONDITIONAL', 'conditional', 'LONGVARCHAR',
false, null);
+ $tMap->addColumn('CREATED_AT', 'createdAt', 'TIMESTAMP', true,
null);
+
+ $tMap->addColumn('UPDATED_AT', 'updatedAt', 'TIMESTAMP', true,
null);
+
}
}
\ No newline at end of file
Modified: trunk/plugins/qbAclPlugin/lib/model/om/BaseAclGroup.php
==============================================================================
--- trunk/plugins/qbAclPlugin/lib/model/om/BaseAclGroup.php Tue Sep 8
15:08:10 2009 (r3195)
+++ trunk/plugins/qbAclPlugin/lib/model/om/BaseAclGroup.php Tue Sep 8
15:12:02 2009 (r3196)
@@ -11,6 +11,8 @@
PARENT_ID = 'q_acl_group.PARENT_ID',
LFT = 'q_acl_group.LFT',
RGT = 'q_acl_group.RGT',
+ CREATED_AT = 'q_acl_group.CREATED_AT',
+ UPDATED_AT = 'q_acl_group.UPDATED_AT',
SOURCE_CULTURE = 'q_acl_group.SOURCE_CULTURE';
public static function addSelectColumns(Criteria $criteria)
@@ -19,6 +21,8 @@
$criteria->addSelectColumn(QubitAclGroup::PARENT_ID);
$criteria->addSelectColumn(QubitAclGroup::LFT);
$criteria->addSelectColumn(QubitAclGroup::RGT);
+ $criteria->addSelectColumn(QubitAclGroup::CREATED_AT);
+ $criteria->addSelectColumn(QubitAclGroup::UPDATED_AT);
$criteria->addSelectColumn(QubitAclGroup::SOURCE_CULTURE);
return $criteria;
Modified: trunk/plugins/qbAclPlugin/lib/model/om/BaseAclPermission.php
==============================================================================
--- trunk/plugins/qbAclPlugin/lib/model/om/BaseAclPermission.php Tue Sep
8 15:08:10 2009 (r3195)
+++ trunk/plugins/qbAclPlugin/lib/model/om/BaseAclPermission.php Tue Sep
8 15:12:02 2009 (r3196)
@@ -12,7 +12,9 @@
OBJECT_ID = 'q_acl_permission.OBJECT_ID',
ACTION_ID = 'q_acl_permission.ACTION_ID',
GRANT_DENY = 'q_acl_permission.GRANT_DENY',
- CONDITIONAL = 'q_acl_permission.CONDITIONAL';
+ CONDITIONAL = 'q_acl_permission.CONDITIONAL',
+ CREATED_AT = 'q_acl_permission.CREATED_AT',
+ UPDATED_AT = 'q_acl_permission.UPDATED_AT';
public static function addSelectColumns(Criteria $criteria)
{
@@ -22,6 +24,8 @@
$criteria->addSelectColumn(QubitAclPermission::ACTION_ID);
$criteria->addSelectColumn(QubitAclPermission::GRANT_DENY);
$criteria->addSelectColumn(QubitAclPermission::CONDITIONAL);
+ $criteria->addSelectColumn(QubitAclPermission::CREATED_AT);
+ $criteria->addSelectColumn(QubitAclPermission::UPDATED_AT);
return $criteria;
}
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
