1 DROP TABLE IF EXISTS `oai_sets_descriptions`;
2 DROP TABLE IF EXISTS `oai_sets_mappings`;
3 DROP TABLE IF EXISTS `oai_sets_biblios`;
4 DROP TABLE IF EXISTS `oai_sets`;
6 CREATE TABLE `oai_sets` (
7 `id` int(11) NOT NULL auto_increment,
8 `spec` varchar(80) NOT NULL UNIQUE,
9 `name` varchar(80) NOT NULL,
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13 CREATE TABLE `oai_sets_descriptions` (
14 `set_id` int(11) NOT NULL,
15 `description` varchar(255) NOT NULL,
16 CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19 CREATE TABLE `oai_sets_mappings` (
20 `set_id` int(11) NOT NULL,
21 `marcfield` char(3) NOT NULL,
22 `marcsubfield` char(1) NOT NULL,
23 `marcvalue` varchar(80) NOT NULL,
24 CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27 CREATE TABLE `oai_sets_biblios` (
28 `biblionumber` int(11) NOT NULL,
29 `set_id` int(11) NOT NULL,
30 PRIMARY KEY (`biblionumber`, `set_id`),
31 CONSTRAINT `oai_sets_biblios_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
32 CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
33 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OAI-PMH:AutoUpdateSets','0','Automatically update OAI sets when a bibliographic record is created or updated','','YesNo');