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

(-)a/installer/data/mysql/atomicupdate/bug_20133.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( !column_exists( 'library_groups', 'ft_hide_patron_info' ) ) {
5
        $dbh->do( "ALTER TABLE library_groups ADD COLUMN ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0 AFTER description" );
6
    }
7
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug XXXXX - Add library_groups.ft_hide_patron_info)\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4143-4148 CREATE TABLE library_groups ( Link Here
4143
    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
4143
    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
4144
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
4144
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
4145
    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
4145
    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
4146
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4146
    created_on DATETIME NOT NULL,          -- Date and time of creation
4147
    created_on DATETIME NOT NULL,          -- Date and time of creation
4147
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
4148
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
4148
    PRIMARY KEY id ( id ),
4149
    PRIMARY KEY id ( id ),
4149
- 

Return to bug 20133