1 CREATE TABLE biblio_metadata (
2 `id` INT(11) NOT NULL AUTO_INCREMENT,
3 `biblionumber` INT(11) NOT NULL,
4 `format` VARCHAR(16) NOT NULL,
5 `marcflavour` VARCHAR(16) NOT NULL,
6 `metadata` LONGTEXT NOT NULL,
8 UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
9 CONSTRAINT `biblio_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12 CREATE TABLE deletedbiblio_metadata (
13 `id` INT(11) NOT NULL AUTO_INCREMENT,
14 `biblionumber` INT(11) NOT NULL,
15 `format` VARCHAR(16) NOT NULL,
16 `marcflavour` VARCHAR(16) NOT NULL,
17 `metadata` LONGTEXT NOT NULL,
19 UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
20 CONSTRAINT `deletedbiblio_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
24 INSERT INTO biblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM biblioitems;
25 INSERT INTO deletedbiblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM deletedbiblioitems;
26 UPDATE biblio_metadata SET marcflavour = (SELECT value FROM systempreferences WHERE variable="marcflavour");
27 UPDATE deletedbiblio_metadata SET marcflavour = (SELECT value FROM systempreferences WHERE variable="marcflavour");
28 ALTER TABLE biblioitems DROP COLUMN marcxml;
29 ALTER TABLE deletedbiblioitems DROP COLUMN marcxml;