Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.08 KB | None | 0 0
  1. START TRANSACTION;
  2. INSERT INTO `acl_rules` (`module`, `controller`, `action`) VALUES ('partner', 'supplier', 'contract-pdf');
  3. SET @new_acl_rule_id = last_insert_id();
  4. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (31, @new_acl_rule_id, 'ALLOW');
  5. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (35, @new_acl_rule_id, 'ALLOW');
  6. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (92, @new_acl_rule_id, 'ALLOW');
  7. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (16, @new_acl_rule_id, 'ALLOW');
  8. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (27, @new_acl_rule_id, 'ALLOW');
  9. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (37, @new_acl_rule_id, 'ALLOW');
  10. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (17, @new_acl_rule_id, 'ALLOW');
  11. INSERT INTO `acl_settings` (`acl_roles_id`, `acl_rules_id`, `access_type`) VALUES (15, @new_acl_rule_id, 'ALLOW');
  12. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement