From ffd59e10eff61039508e9ddc7663c7ee98cebf1b Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 13 Jan 2014 07:39:21 -0500 Subject: [PATCH] fixing some copy/paste typos --- .../src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql index 6c662009f3..466edacc31 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql @@ -19,13 +19,9 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELEC INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_ORG'), 0, TRUE); INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_USER'), 0, TRUE); INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_WORKSTATION'), 0, TRUE); -INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR'), 1, TR -UE); -INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_ORG'), 1, TR -UE); -INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_USER'), 1, TR -UE); -INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_WORKSTATION'), 1, TR -UE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR'), 1, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_ORG'), 1, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_USER'), 1, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_WORKSTATION'), 1, TRUE); COMMIT; -- 2.11.0