@@ -, +, @@ table --- ...13757-add_opac_editable_to_borrower_attribute_types.perl | 13 +++++++++++++ ..._13757-add_opac_editable_to_borrower_attribute_types.sql | 1 - 2 files changed, 13 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.perl delete mode 100644 installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.sql --- a/installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.perl +++ a/installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.perl @@ -0,0 +1,13 @@ +$DBversion = "16.12.00.XXX"; +if ( CheckVersion($DBversion) ) { + unless ( column_exists( 'borrower_attribute_types', 'opac_editable' ) ) + { + $dbh->do(q{ + ALTER TABLE borrower_attribute_types + ADD COLUMN `opac_editable` tinyint(1) NOT NULL default 0 AFTER `opac_display` + }); + } + + print "Upgrade to $DBversion done (Bug 13757: Make patron attributes editable in the opac if set to 'editable in OPAC'\n"; + SetVersion($DBversion); +} --- a/installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.sql +++ a/installer/data/mysql/atomicupdate/bug_13757-add_opac_editable_to_borrower_attribute_types.sql @@ -1, +0,0 @@ -ALTER TABLE borrower_attribute_types ADD COLUMN `opac_editable` tinyint(1) NOT NULL default 0 AFTER `opac_display`; --