Attachment #85229 for bug #10662

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





CREATE TABLE IF NOT EXISTS `oai_harvester_biblios` (
  `import_oai_biblio_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `oai_repository` varchar(191) NOT NULL,
  `oai_identifier` varchar(191) DEFAULT NULL,
  `biblionumber` int(11) NOT NULL,
  PRIMARY KEY (`import_oai_biblio_id`),
  UNIQUE KEY `oai_record` (`oai_identifier`,`oai_repository` (191)) USING BTREE,
  KEY `FK_import_oai_biblio_1` (`biblionumber`),
  CONSTRAINT `FK_import_oai_biblio_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `oai_harvester_import_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'new',
  `result` text NOT NULL,
  `result_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Lines 4386-4394 CREATE TABLE `oai_harvester_history` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
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

Lines 4-14 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_10662.sql (-6 / +6 lines)
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;