@@ -, +, @@ userflags.sql --- installer/data/mysql/en/mandatory/userflags.sql | 39 ++++++++++++----------- 1 file changed, 20 insertions(+), 19 deletions(-) --- a/installer/data/mysql/en/mandatory/userflags.sql +++ a/installer/data/mysql/en/mandatory/userflags.sql @@ -1,19 +1,20 @@ -INSERT INTO `userflags` VALUES(0,'superlibrarian','Access to all librarian functions',0); -INSERT INTO `userflags` VALUES(1,'circulate','Check out and check in items',0); -INSERT INTO `userflags` VALUES(2,'catalogue','Required for staff login. Staff access, allows viewing of catalogue in staff client.',0); -INSERT INTO `userflags` VALUES(3,'parameters','Manage Koha system settings (Administration panel)',0); -INSERT INTO `userflags` VALUES(4,'borrowers','Add or modify patrons',0); -INSERT INTO `userflags` VALUES(5,'permissions','Set user permissions',0); -INSERT INTO `userflags` VALUES(6,'reserveforothers','Place and modify holds for patrons',0); -INSERT INTO `userflags` VALUES(7,'borrow','Borrow books',1); -INSERT INTO `userflags` VALUES(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0); -INSERT INTO `userflags` VALUES(10,'updatecharges','Manage patrons fines and fees',0); -INSERT INTO `userflags` VALUES(11,'acquisition','Acquisition and/or suggestion management',0); -INSERT INTO `userflags` VALUES(12,'management','Set library management parameters (deprecated)',0); -INSERT INTO `userflags` VALUES(13,'tools','Use all tools (expand for granular tools permissions)',0); -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(18,'coursereserves','Course Reserves',0); -INSERT INTO `userflags` VALUES(19, 'plugins', 'Koha plugins', '0'); +INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES +(0,'superlibrarian','Access to all librarian functions',0), +(1,'circulate','Check out and check in items',0), +(2,'catalogue','Required for staff login. Staff access, allows viewing of catalogue in staff client.',0), +(3,'parameters','Manage Koha system settings (Administration panel)',0), +(4,'borrowers','Add or modify patrons',0), +(5,'permissions','Set user permissions',0), +(6,'reserveforothers','Place and modify holds for patrons',0), +(7,'borrow','Borrow books',1), +(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0), +(10,'updatecharges','Manage patrons fines and fees',0), +(11,'acquisition','Acquisition and/or suggestion management',0), +(12,'management','Set library management parameters (deprecated)',0), +(13,'tools','Use all tools (expand for granular tools permissions)',0), +(14,'editauthorities','Edit Authorities',0), +(15,'serials','Manage serial subscriptions',0), +(16,'reports','Allow access to the reports module',0), +(17,'staffaccess','Allow staff members to modify permissions for other staff members',0), +(18,'coursereserves','Course Reserves',0), +(19, 'plugins', 'Koha plugins', '0'); --