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

(-)a/installer/data/mysql/atomicupdate/bug_17196.sql (+29 lines)
Line 0 Link Here
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,
7
    PRIMARY KEY(id),
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;
11
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,
18
    PRIMARY KEY(id),
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;
22
23
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;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +29 lines)
Lines 181-187 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
181
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
181
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
182
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
182
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
183
  `totalissues` int(10),
183
  `totalissues` int(10),
184
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
185
  PRIMARY KEY  (`biblioitemnumber`),
184
  PRIMARY KEY  (`biblioitemnumber`),
186
  KEY `bibinoidx` (`biblioitemnumber`),
185
  KEY `bibinoidx` (`biblioitemnumber`),
187
  KEY `bibnoidx` (`biblionumber`),
186
  KEY `bibnoidx` (`biblionumber`),
Lines 535-541 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
535
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
534
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
536
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
535
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
537
  `totalissues` int(10),
536
  `totalissues` int(10),
538
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
539
  PRIMARY KEY  (`biblioitemnumber`),
537
  PRIMARY KEY  (`biblioitemnumber`),
540
  KEY `bibinoidx` (`biblioitemnumber`),
538
  KEY `bibinoidx` (`biblioitemnumber`),
541
  KEY `bibnoidx` (`biblionumber`),
539
  KEY `bibnoidx` (`biblionumber`),
Lines 3790-3795 CREATE TABLE `hold_fill_targets` ( Link Here
3790
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3788
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3791
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3789
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3792
3790
3791
--
3792
-- Table structure for table `biblio_metadata`
3793
--
3794
3795
CREATE TABLE biblio_metadata (
3796
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3797
    `biblionumber` INT(11) NOT NULL,
3798
    `format` VARCHAR(16) NOT NULL,
3799
    `marcflavour` VARCHAR(16) NOT NULL,
3800
    `metadata` LONGTEXT NOT NULL,
3801
    PRIMARY KEY(id),
3802
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3803
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3804
3805
--
3806
-- Table structure for table `deletedbiblio_metadata`
3807
--
3808
3809
CREATE TABLE deletedbiblio_metadata (
3810
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3811
    `biblionumber` INT(11) NOT NULL,
3812
    `format` VARCHAR(16) NOT NULL,
3813
    `marcflavour` VARCHAR(16) NOT NULL,
3814
    `metadata` LONGTEXT NOT NULL,
3815
    PRIMARY KEY(id),
3816
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3817
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3818
3819
3793
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3820
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3794
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3821
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3795
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3822
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3796
- 

Return to bug 17196