Attachment 15533 Details for Bug 7804 – Bug 7804 - Add Koha Plugin System - QA Followup - Add flags and permissions sql

[patch] Bug 7804 - Add Koha Plugin System - QA Followup - Add flags and permissions sql

Bug-7804---Add-Koha-Plugin-System---QA-Followup---.patch (text/plain), 14.83 KB, created by Jonathan Druart on 2013-02-19 09:48:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2013-02-19 09:48:55 UTC

Size: 14.83 KB

patch

obsolete

>From 5574d7703a24b0f5388bdc0bc57b8262750206ef Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Fri, 8 Feb 2013 09:48:38 -0500
>Subject: [PATCH] Bug 7804 - Add Koha Plugin System - QA Followup - Add flags
> and permissions sql
>
>Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
>---
> installer/data/mysql/de-DE/mandatory/userflags.sql             |    1 +
> installer/data/mysql/de-DE/mandatory/userpermissions.sql       |    5 ++++-
> installer/data/mysql/en/mandatory/userflags.sql                |    1 +
> installer/data/mysql/en/mandatory/userpermissions.sql          |    6 +++++-
> installer/data/mysql/es-ES/mandatory/userflags.sql             |    1 +
> installer/data/mysql/es-ES/mandatory/userpermissions.sql       |    5 ++++-
> installer/data/mysql/fr-FR/1-Obligatoire/userflags.sql         |    1 +
> installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql   |    5 ++++-
> installer/data/mysql/it-IT/necessari/userflags.sql             |    1 +
> installer/data/mysql/it-IT/necessari/userpermissions.sql       |    5 ++++-
> installer/data/mysql/nb-NO/1-Obligatorisk/userflags.sql        |    1 +
> installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql  |    5 ++++-
> installer/data/mysql/pl-PL/mandatory/userflags.sql             |    1 +
> installer/data/mysql/pl-PL/mandatory/userpermissions.sql       |    5 ++++-
> .../data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql  |    8 ++++++--
> .../data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql  |    8 ++++++--
> 16 files changed, 48 insertions(+), 11 deletions(-)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/userflags.sql b/installer/data/mysql/de-DE/mandatory/userflags.sql
>index aeccf76..50b567e 100644
>--- a/installer/data/mysql/de-DE/mandatory/userflags.sql
>+++ b/installer/data/mysql/de-DE/mandatory/userflags.sql
>@@ -15,3 +15,4 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Normdaten Ã¤ndern',0);
> INSERT INTO `userflags` VALUES(15,'serials','Zugang auf Abonnementverwaltung/Zeitschriftenmodul',0);
> INSERT INTO `userflags` VALUES(16,'reports','Zugang auf Reportmodul',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen fÃ¼r Bibliotheksmitarbeiter vergeben',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>diff --git a/installer/data/mysql/de-DE/mandatory/userpermissions.sql b/installer/data/mysql/de-DE/mandatory/userpermissions.sql
>index ec5a22a..731f85b 100644
>--- a/installer/data/mysql/de-DE/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/de-DE/mandatory/userpermissions.sql
>@@ -51,5 +51,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Abonnements verlÃ¤ngern'),
>    (15, 'routing', 'Umlauflisten verwalten'),
>    (16, 'execute_reports', 'SQL-Reports ausfÃ¼hren'),
>-   (16, 'create_reports', 'SQL-Reports erstellen')
>+   (16, 'create_reports', 'SQL-Reports erstellen'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
>diff --git a/installer/data/mysql/en/mandatory/userflags.sql b/installer/data/mysql/en/mandatory/userflags.sql
>index 926e53b..c098dd1 100644
>--- a/installer/data/mysql/en/mandatory/userflags.sql
>+++ b/installer/data/mysql/en/mandatory/userflags.sql
>@@ -15,3 +15,4 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Edit Authorities',0);
> INSERT INTO `userflags` VALUES(15,'serials','Manage serial subscriptions',0);
> INSERT INTO `userflags` VALUES(16,'reports','Allow access to the reports module',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','Allow staff members to modify permissions for other staff members',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>\ No newline at end of file
>diff --git a/installer/data/mysql/en/mandatory/userpermissions.sql b/installer/data/mysql/en/mandatory/userpermissions.sql
>index 070e8f5..4056a4c 100644
>--- a/installer/data/mysql/en/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/en/mandatory/userpermissions.sql
>@@ -51,5 +51,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Renew a subscription'),
>    (15, 'routing', 'Routing'),
>    (16, 'execute_reports', 'Execute SQL reports'),
>-   (16, 'create_reports', 'Create SQL Reports')
>+   (16, 'create_reports', 'Create SQL Reports'),
>+   (19, 'manage', 'Manage plugins ( install / uninstall )'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'), 
>+   (19, 'configure', 'Configure plugins')
> ;
>diff --git a/installer/data/mysql/es-ES/mandatory/userflags.sql b/installer/data/mysql/es-ES/mandatory/userflags.sql
>index e9d9b2e..85b977a 100644
>--- a/installer/data/mysql/es-ES/mandatory/userflags.sql
>+++ b/installer/data/mysql/es-ES/mandatory/userflags.sql
>@@ -15,3 +15,4 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Allow to edit authorities',
> INSERT INTO `userflags` VALUES(15,'serials','Allow to manage serials subscriptions',0);
> INSERT INTO `userflags` VALUES(16,'reports','Allow to access to the reports module',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','Modify login / permissions for staff users',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>diff --git a/installer/data/mysql/es-ES/mandatory/userpermissions.sql b/installer/data/mysql/es-ES/mandatory/userpermissions.sql
>index 070e8f5..f2b7051 100644
>--- a/installer/data/mysql/es-ES/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/es-ES/mandatory/userpermissions.sql
>@@ -51,5 +51,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Renew a subscription'),
>    (15, 'routing', 'Routing'),
>    (16, 'execute_reports', 'Execute SQL reports'),
>-   (16, 'create_reports', 'Create SQL Reports')
>+   (16, 'create_reports', 'Create SQL Reports'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
>diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/userflags.sql b/installer/data/mysql/fr-FR/1-Obligatoire/userflags.sql
>index 68fea6e..7c3c233 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/userflags.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/userflags.sql
>@@ -16,3 +16,4 @@ INSERT INTO `userflags` VALUES(13,'tools','Outils (export, import, impression de
> INSERT INTO `userflags` VALUES(14,'editauthorities','Gestion des autoritÃ©s',0);
> INSERT INTO `userflags` VALUES(15,'serials','Gestion du module pÃ©riodique',0);
> INSERT INTO `userflags` VALUES(16,'reports','AccÃ¨s aux statistiques',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql b/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql
>index 3147bed..87fdec5 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql
>@@ -51,6 +51,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Renouveler les abonnements'),
>    (15, 'routing', 'Mettre en circulation'),
>    (16, 'execute_reports', 'Lancer les rapports SQL'),
>-   (16, 'create_reports', 'CrÃ©er les rapports SQL Reports')
>+   (16, 'create_reports', 'CrÃ©er les rapports SQL Reports'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> 
> ;
>diff --git a/installer/data/mysql/it-IT/necessari/userflags.sql b/installer/data/mysql/it-IT/necessari/userflags.sql
>index eaabb50..6f551ad 100644
>--- a/installer/data/mysql/it-IT/necessari/userflags.sql
>+++ b/installer/data/mysql/it-IT/necessari/userflags.sql
>@@ -17,5 +17,6 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','autorizza la modifica delle
> INSERT INTO `userflags` VALUES(15,'serials','autorizza la gestione degli abbonamenti ai periodici',0);
> INSERT INTO `userflags` VALUES(16,'reports','autorizza accesso al modulo dei reports',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','modifica la login o i permessi degli staff users',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
> 
> SET FOREIGN_KEY_CHECKS=1;
>\ No newline at end of file
>diff --git a/installer/data/mysql/it-IT/necessari/userpermissions.sql b/installer/data/mysql/it-IT/necessari/userpermissions.sql
>index cf5424e..b06e251 100644
>--- a/installer/data/mysql/it-IT/necessari/userpermissions.sql
>+++ b/installer/data/mysql/it-IT/necessari/userpermissions.sql
>@@ -53,6 +53,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Rinnova un abbonamento'),
>    (15, 'routing', 'Crea/Manipola liste di distribuzione dei fascicoli ( routing list)'),
>    (16, 'execute_reports', 'Esegui reports SQL'),
>-   (16, 'create_reports', 'Crea reports SQL')
>+   (16, 'create_reports', 'Crea reports SQL'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
> SET FOREIGN_KEY_CHECKS=1;
>diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/userflags.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/userflags.sql
>index 2e73c7f4..c9062fa 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/userflags.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/userflags.sql
>@@ -36,3 +36,4 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Tilgang til Ã¥ endre autori
> INSERT INTO `userflags` VALUES(15,'serials','Tilgang til Ã¥ endre abonnementer',0);
> INSERT INTO `userflags` VALUES(16,'reports','Tilgang til rapportmodulen',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','Endre innlogging og rettigheter for bibliotekansatte',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql
>index 36c03f3..e8a52a7 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql
>@@ -71,5 +71,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Fornye abonnementer'),
>    (15, 'routing', 'Sirkulasjon'),
>    (16, 'execute_reports', 'KjÃ¸re SQL-rapporter'),
>-   (16, 'create_reports', 'Opprette SQL-rapporter')
>+   (16, 'create_reports', 'Opprette SQL-rapporter'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
>diff --git a/installer/data/mysql/pl-PL/mandatory/userflags.sql b/installer/data/mysql/pl-PL/mandatory/userflags.sql
>index e9d9b2e..85b977a 100644
>--- a/installer/data/mysql/pl-PL/mandatory/userflags.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/userflags.sql
>@@ -15,3 +15,4 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Allow to edit authorities',
> INSERT INTO `userflags` VALUES(15,'serials','Allow to manage serials subscriptions',0);
> INSERT INTO `userflags` VALUES(16,'reports','Allow to access to the reports module',0);
> INSERT INTO `userflags` VALUES(17,'staffaccess','Modify login / permissions for staff users',0);
>+INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0');
>diff --git a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql b/installer/data/mysql/pl-PL/mandatory/userpermissions.sql
>index 1165af1..e280c25 100644
>--- a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/userpermissions.sql
>@@ -52,5 +52,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription', 'Renew a subscription'),
>    (15, 'routing', 'Routing'),
>    (16, 'execute_reports', 'Execute SQL reports'),
>-   (16, 'create_reports', 'Create SQL Reports')
>+   (16, 'create_reports', 'Create SQL Reports'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
>diff --git a/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql
>index 00d6538..da651d4 100644
>--- a/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql
>@@ -17,7 +17,8 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
>    (14,'editauthorities', 'Ð Ð°Ð·ÑÐµÑÐµÐ½Ð¸Ðµ Ð½Ð° Ð¸Ð·Ð¼ÐµÐ½ÐµÐ½Ð¸Ðµ Ð°Ð²ÑÐ¾ÑÐ¸ÑÐµÑÐ½ÑÑ Ð¸ÑÑÐ¾ÑÐ½Ð¸ÐºÐ¾Ð²',0),
>    (15,'serials',         'Ð Ð°Ð·ÑÐµÑÐµÐ½Ð¸Ðµ Ð½Ð° ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð´Ð¿Ð¸ÑÐºÐ¾Ð¹ Ð¿ÐµÑÐ¸Ð¾Ð´Ð¸ÑÐµÑÐºÐ¸Ñ Ð¸Ð·Ð´Ð°Ð½Ð¸Ð¹',0),
>    (16,'reports',         'Ð Ð°Ð·ÑÐµÑÐµÐ½Ð¸Ðµ Ð½Ð° Ð´Ð¾ÑÑÑÐ¿ Ðº Ð¼Ð¾Ð´ÑÐ»Ñ Ð¾ÑÑÐµÑÐ¾Ð²',0),
>-   (17,'staffaccess',     'Ð¡Ð¼ÐµÐ½Ð° Ð¸Ð¼ÐµÐ½Ð¸(Ð»Ð¾Ð³Ð¸Ð½Ð°)/Ð¿ÑÐ¸Ð²Ð¸Ð»ÐµÐ³Ð¸Ð¹ Ð´Ð»Ñ ÑÐ°Ð±Ð¾ÑÐ½Ð¸ÐºÐ¾Ð² Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸',0)
>+   (17,'staffaccess',     'Ð¡Ð¼ÐµÐ½Ð° Ð¸Ð¼ÐµÐ½Ð¸(Ð»Ð¾Ð³Ð¸Ð½Ð°)/Ð¿ÑÐ¸Ð²Ð¸Ð»ÐµÐ³Ð¸Ð¹ Ð´Ð»Ñ ÑÐ°Ð±Ð¾ÑÐ½Ð¸ÐºÐ¾Ð² Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸',0),
>+   (19,'plugins',         'Koha plugins', '0')
> ;
> 
> TRUNCATE permissions;
>@@ -75,6 +76,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription',          'Renew a subscription'),
>    (15, 'routing',                     'Routing'),
>    (16, 'execute_reports', 'Execute SQL reports'),
>-   (16, 'create_reports', 'Create SQL Reports')
>+   (16, 'create_reports', 'Create SQL Reports'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
> 
>diff --git a/installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql b/installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql
>index 188a146..30a4805 100644
>--- a/installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql
>@@ -17,7 +17,8 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
>    (14,'editauthorities', 'ÐÐ¾Ð·Ð²ÑÐ» Ð½Ð° ÑÐµÐ´Ð°Ð³ÑÐ²Ð°Ð½Ð½Ñ Ð°Ð²ÑÐ¾ÑÐ¸ÑÐµÑÐ½Ð¸Ñ Ð´Ð¶ÐµÑÐµÐ»',0),
>    (15,'serials',         'ÐÐ¾Ð·Ð²ÑÐ» Ð½Ð° ÐºÐµÑÑÐ²Ð°Ð½Ð½Ñ Ð¿ÑÐ´Ð¿Ð¸ÑÐºÐ¾Ñ Ð¿ÐµÑÑÐ¾Ð´Ð¸ÑÐ½Ð¸Ñ Ð²Ð¸Ð´Ð°Ð½Ñ',0),
>    (16,'reports',         'ÐÐ¾Ð·Ð²ÑÐ» Ð½Ð° Ð´Ð¾ÑÑÑÐ¿ Ð´Ð¾ Ð¼Ð¾Ð´ÑÐ»Ñ Ð·Ð²ÑÑÑÐ²',0),
>-   (17,'staffaccess',     'ÐÐ¼ÑÐ½Ð° ÑÐ¼ÐµÐ½Ñ(Ð»Ð¾Ð³ÑÐ½Ñ)/Ð¿ÑÐ¸Ð²ÑÐ»ÐµÑÐ² Ð´Ð»Ñ Ð¿ÑÐ°ÑÑÐ²Ð½Ð¸ÐºÑÐ² Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ¸',0)
>+   (17,'staffaccess',     'ÐÐ¼ÑÐ½Ð° ÑÐ¼ÐµÐ½Ñ(Ð»Ð¾Ð³ÑÐ½Ñ)/Ð¿ÑÐ¸Ð²ÑÐ»ÐµÑÐ² Ð´Ð»Ñ Ð¿ÑÐ°ÑÑÐ²Ð½Ð¸ÐºÑÐ² Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÐºÐ¸',0),
>+   (19,'plugins',         'Koha plugins', '0')
> ;
> 
> TRUNCATE permissions;
>@@ -75,6 +76,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
>    (15, 'renew_subscription',          'Renew a subscription'),
>    (15, 'routing',                     'Routing'),
>    (16, 'execute_reports', 'Execute SQL reports'),
>-   (16, 'create_reports', 'Create SQL Reports')
>+   (16, 'create_reports', 'Create SQL Reports'),
>+   (19, 'tool', 'Use tool plugins'),
>+   (19, 'report', 'Use report plugins'),
>+   (19, 'configure', 'Configure plugins')
> ;
> 
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 7804: 8525 | 8528 | 8545 | 8546 | 8591 | 8595 | 8596 | 8597 | 8607 | 8608 | 8609 | 9565 | 9636 | 9637 | 9644 | 9755 | 11606 | 14506 | 14508 | 14509 | 14510 | 14511 | 14512 | 14513 | 14514 | 14530 | 14531 | 14538 | 14539 | 14540 | 14541 | 14542 | 14543 | 14545 | 14562 | 14563 | 14632 | 14633 | 14731 | 15166 | 15167 | 15168 | 15531 | 15532 | 15533 | 15570 | 15571 | 15572 | 15653 | 15654 | 15655 | 15656 | 16220 | 16221 | 16222 | 16223 | 16297 | 16298 | 16299