View | Details | Raw Unified | Return to bug 8976
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_8976.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    unless ( column_exists( 'marc_subfield_structure', 'display_order' ) ) {
5
        $dbh->do(q{
6
            ALTER TABLE marc_subfield_structure
7
            ADD COLUMN display_order INT(2) NOT NULL DEFAULT 0 AFTER maxlength
8
        });
9
    }
10
11
    # Always end with this (adjust the bug info)
12
    NewVersion( $DBversion, XXXXX, "Description");
13
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3454-3459 CREATE TABLE `marc_subfield_structure` ( Link Here
3454
  `link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3454
  `link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3455
  `defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3455
  `defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3456
  `maxlength` int(4) NOT NULL DEFAULT 9999,
3456
  `maxlength` int(4) NOT NULL DEFAULT 9999,
3457
  `display_order` int(2) NOT NULL DEFAULT 0,
3457
  PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
3458
  PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
3458
  KEY `kohafield_2` (`kohafield`),
3459
  KEY `kohafield_2` (`kohafield`),
3459
  KEY `tab` (`frameworkcode`,`tab`),
3460
  KEY `tab` (`frameworkcode`,`tab`),
3460
- 

Return to bug 8976