Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $triggers[] = Trigger::afterInsert($class->getTableName(), 'audit')
- ->declare('audit_revision', 'BIGINT')
- ->insert('db_audit_revisions', array(
- 'type' => 'INS',
- 'className' => $class->name,
- 'entityId%sql' => 'NEW.' . $class->getSingleIdentifierColumnName(),
- 'createdAt%sql' => 'NOW()',
- 'author%sql' => '@kdyby_current_user'
- ))
- ->set('audit_revision', 'LAST_INSERT_ID()')
- ->insert($auditTable, "SELECT * FROM `{$entityTable}`")
- ->update($auditTable, array('_revision%sql' => '@audit_revision'))
- ->update($entityTable, array('_revision%sql' => '@audit_revision'));
Advertisement
Add Comment
Please, Sign In to add comment