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

(-)a/installer/data/mysql/atomicupdate/Bug-9525-Add_ft_local_float_group_column.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    # you can use $dbh here like:
4 
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
5 

            

            

              6
              
    $dbh->do("ALTER TABLE library_groups ADD COLUMN IF NOT EXISTS ft_local_float_group tinyint(1) NOT NULL DEFAULT 0 AFTER ft_local_hold_group");

            

            

              7
              

            

            

              8
              
    # Always end with this (adjust the bug info)

            

            

              9
              
    NewVersion( $DBversion, 9525, "Add option to set group as local float group");

            

            

              10
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +1 lines)




  

    
      
            Lines 3329-3334
          CREATE TABLE `library_groups` (
      
      
        Link Here
      
    
  

        

          3329
          
  `ft_search_groups_opac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for staff side search groups',

          3329
          
  `ft_search_groups_opac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for staff side search groups',

        

        

          3330
          
  `ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups',

          3330
          
  `ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups',

        

        

          3331
          
  `ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds',

          3331
          
  `ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds',

        

            

              
              
              3332
              
  `ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group',

            

        

          3332
          
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation',

          3333
          
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation',

        

        

          3333
          
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last',

          3334
          
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last',

        

        

          3334
          
  PRIMARY KEY (`id`),

          3335
          
  PRIMARY KEY (`id`),

        

            

              3335
              
- 

              
              
            






  

  Return to bug 9525