@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_8976.perl | 13 +++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 14 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_8976.perl --- a/installer/data/mysql/atomicupdate/bug_8976.perl +++ a/installer/data/mysql/atomicupdate/bug_8976.perl @@ -0,0 +1,13 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + unless ( column_exists( 'marc_subfield_structure', 'display_order' ) ) { + $dbh->do(q{ + ALTER TABLE marc_subfield_structure + ADD COLUMN display_order INT(2) NOT NULL DEFAULT 0 AFTER maxlength + }); + } + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, XXXXX, "Description"); +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3454,6 +3454,7 @@ CREATE TABLE `marc_subfield_structure` ( `link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `maxlength` int(4) NOT NULL DEFAULT 9999, + `display_order` int(2) NOT NULL DEFAULT 0, PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), KEY `kohafield_2` (`kohafield`), KEY `tab` (`frameworkcode`,`tab`), --