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