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

(-)a/installer/data/mysql/atomicupdate/bug_5087_-_add_opac_option_field_to_export_formats.perl (+7 lines)
Lines 8-12 if( CheckVersion( $DBversion ) ) { Link Here
8
        |);
8
        |);
9
    }
9
    }
10
10
11
    unless ( index_exists( 'export_format', 'used_for_idx' ) ) {
12
        $dbh->do(q|
13
            ALTER TABLE export_format
14
                ADD KEY `used_for_idx` (`used_for` (191));
15
        |);
16
    }
17
11
    NewVersion( $DBversion, 5087, "Add export_format.staff_only" );
18
    NewVersion( $DBversion, 5087, "Add export_format.staff_only" );
12
}
19
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 693-698 CREATE TABLE `export_format` ( Link Here
693
  `used_for` varchar(255) DEFAULT 'export_records',
693
  `used_for` varchar(255) DEFAULT 'export_records',
694
  `staff_only` TINYINT(1) NOT NULL DEFAULT 0,
694
  `staff_only` TINYINT(1) NOT NULL DEFAULT 0,
695
  PRIMARY KEY (`export_format_id`),
695
  PRIMARY KEY (`export_format_id`),
696
  KEY `used_for_idx` (`used_for` (191)),
696
  KEY `staff_only_idx` (`staff_only`)
697
  KEY `staff_only_idx` (`staff_only`)
697
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
698
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
698
699
699
- 

Return to bug 5087