Advertisement
xXCalleManXx

Untitled

Jul 10th, 2020
1,197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.41 KB | None | 0 0
  1. INSERT INTO permissions (permission, method, label, description) VALUE ('events/saveCommute', 'POST', 'LABEL', 'DESCRIPTION');
  2. SET @id = LAST_INSERT_ID();
  3. INSERT INTO userRolePermissions (ROLE, permission) VALUES (1, @id), (2, @id);
  4. INSERT INTO companyGroupPermissions (companyGroup, permission) VALUES (1, @id), (2, @id), (3, @id);
  5. INSERT INTO permissionBundlesPermissions (bundleId, permissionId) VALUE (9, @id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement