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 1068-1073 CREATE TABLE `marc_subfield_structure` ( Link Here
1068
  `link` varchar(80) default NULL,
1068
  `link` varchar(80) default NULL,
1069
  `defaultvalue` MEDIUMTEXT default NULL,
1069
  `defaultvalue` MEDIUMTEXT default NULL,
1070
  `maxlength` int(4) NOT NULL DEFAULT '9999',
1070
  `maxlength` int(4) NOT NULL DEFAULT '9999',
1071
  `display_order` int(2) NOT NULL DEFAULT 0,
1071
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1072
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1072
  KEY `kohafield_2` (`kohafield`),
1073
  KEY `kohafield_2` (`kohafield`),
1073
  KEY `tab` (`frameworkcode`,`tab`),
1074
  KEY `tab` (`frameworkcode`,`tab`),
1074
- 

Return to bug 8976