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 / +28 lines)
Lines 193-199 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
193
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
193
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
194
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
194
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
195
  `totalissues` int(10),
195
  `totalissues` int(10),
196
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
197
  PRIMARY KEY  (`biblioitemnumber`),
196
  PRIMARY KEY  (`biblioitemnumber`),
198
  KEY `bibinoidx` (`biblioitemnumber`),
197
  KEY `bibinoidx` (`biblioitemnumber`),
199
  KEY `bibnoidx` (`biblionumber`),
198
  KEY `bibnoidx` (`biblionumber`),
Lines 547-553 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
547
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
546
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
548
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
547
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
549
  `totalissues` int(10),
548
  `totalissues` int(10),
550
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
551
  PRIMARY KEY  (`biblioitemnumber`),
549
  PRIMARY KEY  (`biblioitemnumber`),
552
  KEY `bibinoidx` (`biblioitemnumber`),
550
  KEY `bibinoidx` (`biblioitemnumber`),
553
  KEY `bibnoidx` (`biblionumber`),
551
  KEY `bibnoidx` (`biblionumber`),
Lines 3922-3927 CREATE TABLE `article_requests` ( Link Here
3922
  CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
3920
  CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE
3923
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3921
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3924
3922
3923
--
3924
-- Table structure for table `biblio_metadata`
3925
--
3926
3927
CREATE TABLE biblio_metadata (
3928
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3929
    `biblionumber` INT(11) NOT NULL,
3930
    `format` VARCHAR(16) NOT NULL,
3931
    `marcflavour` VARCHAR(16) NOT NULL,
3932
    `metadata` LONGTEXT NOT NULL,
3933
    PRIMARY KEY(id),
3934
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3935
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3936
3937
--
3938
-- Table structure for table `deletedbiblio_metadata`
3939
--
3940
3941
CREATE TABLE deletedbiblio_metadata (
3942
    `id` INT(11) NOT NULL AUTO_INCREMENT,
3943
    `biblionumber` INT(11) NOT NULL,
3944
    `format` VARCHAR(16) NOT NULL,
3945
    `marcflavour` VARCHAR(16) NOT NULL,
3946
    `metadata` LONGTEXT NOT NULL,
3947
    PRIMARY KEY(id),
3948
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3949
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3950
3925
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3951
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3926
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3952
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3927
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3953
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3928
- 

Return to bug 17196