From 4469b4e52d632f2661cc9472ef651887c91b8e36 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 17 May 2019 09:06:04 -0500 Subject: [PATCH] Bug 22844: Add the new DB column borrower_attribute_types.mandatory Signed-off-by: David Nind Signed-off-by: Kyle M Hall Signed-off-by: Victor Grousset/tuxayo Signed-off-by: Katrin Fischer https://bugs.koha-community.org/show_bug.cgi?id=23391 Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug_22844.perl | 14 ++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 15 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_22844.perl diff --git a/installer/data/mysql/atomicupdate/bug_22844.perl b/installer/data/mysql/atomicupdate/bug_22844.perl new file mode 100644 index 0000000000..4b1d12f19c --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_22844.perl @@ -0,0 +1,14 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + if( !column_exists( 'borrower_attribute_types', 'mandatory' ) ) { + $dbh->do(q| + ALTER TABLE borrower_attribute_types + ADD COLUMN mandatory TINYINT(1) NOT NULL DEFAULT 0 + AFTER keep_for_pseudonymization + |); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug XXXXX - Add borrower_attribute_types.mandatory)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ba718985b1..d64b31d120 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -229,6 +229,7 @@ CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field `category_code` VARCHAR(10) NULL DEFAULT NULL,-- defines a category for an attribute_type `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type `keep_for_pseudonymization` tinyint(1) NOT NULL default 0, -- defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no) + `mandatory` tinyint(1) NOT NULL DEFAULT 0, -- defines if the attribute is mandatory or not PRIMARY KEY (`code`), KEY `auth_val_cat_idx` (`authorised_value_category`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2.39.5