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

(-)a/installer/data/mysql/atomicupdate/bug_10662.sql (-6 / +6 lines)
Lines 4-14 Link Here
4
4
5
CREATE TABLE IF NOT EXISTS `oai_harvester_biblios` (
5
CREATE TABLE IF NOT EXISTS `oai_harvester_biblios` (
6
  `import_oai_biblio_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6
  `import_oai_biblio_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
7
  `oai_repository` varchar(255) NOT NULL,
7
  `oai_repository` varchar(191) NOT NULL,
8
  `oai_identifier` varchar(255) DEFAULT NULL,
8
  `oai_identifier` varchar(191) DEFAULT NULL,
9
  `biblionumber` int(11) NOT NULL,
9
  `biblionumber` int(11) NOT NULL,
10
  PRIMARY KEY (`import_oai_biblio_id`),
10
  PRIMARY KEY (`import_oai_biblio_id`),
11
  UNIQUE KEY `oai_record` (`oai_identifier`,`oai_repository`) USING BTREE,
11
  UNIQUE KEY `oai_record` (`oai_identifier`,`oai_repository` (191)) USING BTREE,
12
  KEY `FK_import_oai_biblio_1` (`biblionumber`),
12
  KEY `FK_import_oai_biblio_1` (`biblionumber`),
13
  CONSTRAINT `FK_import_oai_biblio_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE NO ACTION
13
  CONSTRAINT `FK_import_oai_biblio_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE NO ACTION
14
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
14
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Lines 39-47 CREATE TABLE IF NOT EXISTS `oai_harvester_history` ( Link Here
39
39
40
CREATE TABLE IF NOT EXISTS `oai_harvester_import_queue` (
40
CREATE TABLE IF NOT EXISTS `oai_harvester_import_queue` (
41
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
41
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
42
  `uuid` varchar(45) CHARACTER SET utf8 NOT NULL,
42
  `uuid` varchar(45) NOT NULL,
43
  `status` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT 'new',
43
  `status` varchar(45) NOT NULL DEFAULT 'new',
44
  `result` text CHARACTER SET utf8 NOT NULL,
44
  `result` text NOT NULL,
45
  `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
45
  `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
46
  PRIMARY KEY (`id`)
46
  PRIMARY KEY (`id`)
47
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
47
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 4386-4394 CREATE TABLE `oai_harvester_history` ( Link Here
4386
DROP TABLE IF EXISTS `oai_harvester_import_queue`;
4386
DROP TABLE IF EXISTS `oai_harvester_import_queue`;
4387
CREATE TABLE `oai_harvester_import_queue` (
4387
CREATE TABLE `oai_harvester_import_queue` (
4388
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4388
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4389
  `uuid` varchar(45) CHARACTER SET utf8 NOT NULL,
4389
  `uuid` varchar(45) NOT NULL,
4390
  `status` varchar(45) CHARACTER SET utf8 NOT NULL DEFAULT 'new',
4390
  `status` varchar(45) NOT NULL DEFAULT 'new',
4391
  `result` text CHARACTER SET utf8 NOT NULL,
4391
  `result` text NOT NULL,
4392
  `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4392
  `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4393
  PRIMARY KEY (`id`)
4393
  PRIMARY KEY (`id`)
4394
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4394
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4395
- 

Return to bug 10662