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