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 3795-3800 CREATE TABLE `hold_fill_targets` ( Link Here
3795
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3793
    REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
3796
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3794
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3797
3795
3796
--
3797
-- Table structure for table `biblio_metadata`
3798
--
3799
3800
CREATE TABLE biblio_metadata (
3801
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3802
    `biblionumber` INT(11) NOT NULL,
3803
    `format` VARCHAR(16) NOT NULL,
3804
    `marcflavour` VARCHAR(16) NOT NULL,
3805
    `metadata` LONGTEXT NOT NULL,
3806
    PRIMARY KEY(id),
3807
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3808
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3809
3810
--
3811
-- Table structure for table `deletedbiblio_metadata`
3812
--
3813
3814
CREATE TABLE deletedbiblio_metadata (
3815
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3816
    `biblionumber` INT(11) NOT NULL,
3817
    `format` VARCHAR(16) NOT NULL,
3818
    `marcflavour` VARCHAR(16) NOT NULL,
3819
    `metadata` LONGTEXT NOT NULL,
3820
    PRIMARY KEY(id),
3821
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3822
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3823
3824
3798
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3825
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3799
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3826
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3800
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3827
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3801
- 

Return to bug 17196