View | Details | Raw Unified | Return to bug 26346
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_26346.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if ( CheckVersion($DBversion) ) {
3
    if ( !column_exists( 'virtualshelves', 'allow_change_from_staff' ) ) {
4
        $dbh->do(q{ALTER TABLE virtualshelves ADD COLUMN `allow_change_from_staff` tinyint(1) DEFAULT '0' COMMENT 'can staff change contents?'});
5
    }
6
7
    $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (20, 'edit_public_lists', 'Edit public lists') });
8
    NewVersion( $DBversion, 26346, "Add allow_change_from_staff to virtualshelves table" );
9
}
(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 5340-5345 CREATE TABLE `virtualshelves` ( Link Here
5340
  `created_on` datetime NOT NULL COMMENT 'creation time',
5340
  `created_on` datetime NOT NULL COMMENT 'creation time',
5341
  `allow_change_from_owner` tinyint(1) DEFAULT 1 COMMENT 'can owner change contents?',
5341
  `allow_change_from_owner` tinyint(1) DEFAULT 1 COMMENT 'can owner change contents?',
5342
  `allow_change_from_others` tinyint(1) DEFAULT 0 COMMENT 'can others change contents?',
5342
  `allow_change_from_others` tinyint(1) DEFAULT 0 COMMENT 'can others change contents?',
5343
  `allow_change_from_staff` tinyint(1) DEFAULT 0 COMMENT 'can staff change contents?',
5343
  PRIMARY KEY (`shelfnumber`),
5344
  PRIMARY KEY (`shelfnumber`),
5344
  KEY `virtualshelves_ibfk_1` (`owner`),
5345
  KEY `virtualshelves_ibfk_1` (`owner`),
5345
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL
5346
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL
(-)a/installer/data/mysql/mandatory/userpermissions.sql (-1 / +1 lines)
Lines 127-132 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
127
   (19, 'report', 'Use report plugins'),
127
   (19, 'report', 'Use report plugins'),
128
   (19, 'configure', 'Configure plugins'),
128
   (19, 'configure', 'Configure plugins'),
129
   (20, 'delete_public_lists', 'Delete public lists'),
129
   (20, 'delete_public_lists', 'Delete public lists'),
130
   (20, 'edit_public_lists', 'Edit public lists'),
130
   (21, 'edit_templates', 'Create and update club templates'),
131
   (21, 'edit_templates', 'Create and update club templates'),
131
   (21, 'edit_clubs', 'Create and update clubs'),
132
   (21, 'edit_clubs', 'Create and update clubs'),
132
   (21, 'enroll', 'Enroll patrons in clubs'),
133
   (21, 'enroll', 'Enroll patrons in clubs'),
133
- 

Return to bug 26346