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 691-696 CREATE TABLE `export_format` ( Link Here
691
  `used_for` varchar(255) DEFAULT 'export_records',
691
  `used_for` varchar(255) DEFAULT 'export_records',
692
  `staff_only` TINYINT(1) NOT NULL DEFAULT 0,
692
  `staff_only` TINYINT(1) NOT NULL DEFAULT 0,
693
  PRIMARY KEY (`export_format_id`),
693
  PRIMARY KEY (`export_format_id`),
694
  KEY `used_for_idx` (`used_for` (191)),
694
  KEY `staff_only_idx` (`staff_only`)
695
  KEY `staff_only_idx` (`staff_only`)
695
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
696
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
696
697
697
- 

Return to bug 5087