From 95a203d055bf2452e58621b396e54d45cccc44a0 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Wed, 28 Mar 2012 16:43:15 -0400 Subject: [PATCH] remove XXXX script Signed-off-by: Jason Etheridge --- .../sql/Pg/upgrade/XXXX.schema.custom_toolbars.sql | 56 ---------------------- 1 file changed, 56 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.custom_toolbars.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.custom_toolbars.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.custom_toolbars.sql deleted file mode 100644 index 63c7a61b4e..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.custom_toolbars.sql +++ /dev/null @@ -1,56 +0,0 @@ - -CREATE TABLE actor.toolbar ( - id BIGSERIAL PRIMARY KEY, - ws INT REFERENCES actor.workstation (id) ON DELETE CASCADE, - org INT REFERENCES actor.org_unit (id) ON DELETE CASCADE, - usr INT REFERENCES actor.usr (id) ON DELETE CASCADE, - label TEXT NOT NULL, - layout TEXT NOT NULL, - CONSTRAINT only_one_type CHECK ( - (ws IS NOT NULL AND COALESCE(org,usr) IS NULL) OR - (org IS NOT NULL AND COALESCE(ws,usr) IS NULL) OR - (usr IS NOT NULL AND COALESCE(org,ws) IS NULL) - ), - CONSTRAINT layout_must_be_json CHECK ( is_json(layout) ) -); -CREATE UNIQUE INDEX label_once_per_ws ON actor.toolbar (ws, label) WHERE ws IS NOT NULL; -CREATE UNIQUE INDEX label_once_per_org ON actor.toolbar (org, label) WHERE org IS NOT NULL; -CREATE UNIQUE INDEX label_once_per_usr ON actor.toolbar (usr, label) WHERE usr IS NOT NULL; - --- this one unrelated to toolbars but is a gap in the upgrade scripts -INSERT INTO permission.perm_list ( id, code, description ) - SELECT - 522, - 'IMPORT_AUTHORITY_MARC', - oils_i18n_gettext( - 522, - 'Allows a user to create new authority records', - 'ppl', - 'description' - ) - WHERE NOT EXISTS ( - SELECT 1 - FROM permission.perm_list - WHERE - id = 522 - ); - -INSERT INTO permission.perm_list ( id, code, description ) VALUES ( - 523, - 'ADMIN_TOOLBAR', - oils_i18n_gettext( - 523, - 'Allows a user to create, edit, and delete custom toolbars', - 'ppl', - 'description' - ) -); - --- Don't want to assume stock perm groups in an upgrade script, but here for ease of testing --- INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT pgt.id, perm.id, aout.depth, FALSE FROM permission.grp_tree pgt, permission.perm_list perm, actor.org_unit_type aout WHERE pgt.name = 'Staff' AND aout.name = 'Branch' AND perm.code = 'ADMIN_TOOLBAR'; - -INSERT INTO actor.toolbar(org,label,layout) VALUES - ( 1, 'circ', '["circ_checkout","circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","patron_search","patron_register","toolbarspacer.3","hotkeys_toggle"]' ), - ( 1, 'cat', '["circ_checkin","toolbarseparator.1","search_opac","copy_status","toolbarseparator.2","create_marc","authority_manage","retrieve_last_record","toolbarspacer.3","hotkeys_toggle"]' ); - --- delete from permission.grp_perm_map where perm in (select id from permission.perm_list where code ~ 'TOOLBAR'); delete from permission.perm_list where code ~ 'TOOLBAR'; drop table actor.toolbar ; -- 2.11.0