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