From 2e483b8d1b6dee535ddfca46830ba21cce2490d3 Mon Sep 17 00:00:00 2001 From: Nicole Engard Date: Sun, 16 Aug 2009 17:23:03 -0400 Subject: [PATCH] BUG 2611: Changed catalogue to catalog and fixed capitalization. Signed-off-by: Galen Charlton --- installer/data/mysql/en/mandatory/userflags.sql | 10 +++++----- installer/data/mysql/updatedatabase.pl | 11 +++++++++++ 2 files changed, 16 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/en/mandatory/userflags.sql b/installer/data/mysql/en/mandatory/userflags.sql index 0c1493f685..9f84d78a2e 100644 --- a/installer/data/mysql/en/mandatory/userflags.sql +++ b/installer/data/mysql/en/mandatory/userflags.sql @@ -1,17 +1,17 @@ INSERT INTO `userflags` VALUES(0,'superlibrarian','Access to all librarian functions',0); INSERT INTO `userflags` VALUES(1,'circulate','Circulate books',0); -INSERT INTO `userflags` VALUES(2,'catalogue','View Catalogue (Librarian Interface)',0); +INSERT INTO `userflags` VALUES(2,'catalogue','View Catalog (Librarian Interface)',0); INSERT INTO `userflags` VALUES(3,'parameters','Set Koha system parameters',0); INSERT INTO `userflags` VALUES(4,'borrowers','Add or modify borrowers',0); INSERT INTO `userflags` VALUES(5,'permissions','Set user permissions',0); INSERT INTO `userflags` VALUES(6,'reserveforothers','Reserve books for patrons',0); INSERT INTO `userflags` VALUES(7,'borrow','Borrow books',1); -INSERT INTO `userflags` VALUES(9,'editcatalogue','Edit Catalogue (Modify bibliographic/holdings data)',0); +INSERT INTO `userflags` VALUES(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0); INSERT INTO `userflags` VALUES(10,'updatecharges','Update borrower charges',0); INSERT INTO `userflags` VALUES(11,'acquisition','Acquisition and/or suggestion management',0); INSERT INTO `userflags` VALUES(12,'management','Set library management parameters',0); INSERT INTO `userflags` VALUES(13,'tools','Use tools (export, import, barcodes)',0); -INSERT INTO `userflags` VALUES(14,'editauthorities','allow to edit authorities',0); -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(14,'editauthorities','Allow to edit authorities',0); +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); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 4d93a2876d..c34e19acef 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2554,6 +2554,17 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = '3.01.00.043'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("UPDATE userflags SET flagdesc='View Catalog (Librarian Interface)' WHERE bit=2;"); + $dbh->do("UPDATE userflags SET flagdesc='Edit Catalog (Modify bibliographic/holdings data)' WHERE bit=9;"); + $dbh->do("UPDATE userflags SET flagdesc='Allow to edit authorities' WHERE bit=14;"); + $dbh->do("UPDATE userflags SET flagdesc='Allow to access to the reports module' WHERE bit=16;"); + $dbh->do("UPDATE userflags SET flagdesc='Allow to manage serials subscriptions' WHERE bit=15;"); + SetVersion ($DBversion); + print " Upgrade to $DBversion done (fix spelling/capitalization to make things match the standard.)\n"; +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.2