@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_23309.perl | 10 ++++++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_23309.perl --- a/installer/data/mysql/atomicupdate/bug_23309.perl +++ a/installer/data/mysql/atomicupdate/bug_23309.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + $dbh->do(q| + ALTER TABLE marc_subfield_structure CHANGE COLUMN hidden hidden TINYINT(1) DEFAULT 8 NOT NULL; + |); + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 23309 - Can't add new subfields to bibliographic frameworks in strict mode)\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -1049,7 +1049,7 @@ CREATE TABLE `marc_subfield_structure` ( `authtypecode` varchar(20) default NULL, `value_builder` varchar(80) default NULL, `isurl` tinyint(1) default NULL, - `hidden` tinyint(1) default NULL, + `hidden` tinyint(1) NOT NULL default 8, `frameworkcode` varchar(4) NOT NULL default '', `seealso` varchar(1100) default NULL, `link` varchar(80) default NULL, --