Bugzilla – Attachment 55860 Details for
Bug 17196
Move marcxml out of the biblioitems table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17196: DB Changes
Bug-17196-DB-Changes.patch (text/plain), 5.11 KB, created by
Jonathan Druart
on 2016-09-28 07:40:43 UTC
(
hide
)
Description:
Bug 17196: DB Changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-09-28 07:40:43 UTC
Size:
5.11 KB
patch
obsolete
>From d19bc54abd3880049a4827ec6bcd1b05106b481a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 26 Aug 2016 09:23:30 +0100 >Subject: [PATCH] Bug 17196: DB Changes > >Remove biblioitems.marcxml and deletedbiblioitems.marcxml >and adds 2 table biblio_metadata and deletedbiblio_metadata >--- > installer/data/mysql/atomicupdate/bug_17196.sql | 29 +++++++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 31 +++++++++++++++++++++++-- > 2 files changed, 58 insertions(+), 2 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_17196.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_17196.sql b/installer/data/mysql/atomicupdate/bug_17196.sql >new file mode 100644 >index 0000000..58373fe >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_17196.sql >@@ -0,0 +1,29 @@ >+CREATE TABLE biblio_metadata ( >+ `id` INT(11) NOT NULL AUTO_INCREMENT, >+ `biblionumber` INT(11) NOT NULL, >+ `format` VARCHAR(16) NOT NULL, >+ `marcflavour` VARCHAR(16) NOT NULL, >+ `metadata` LONGTEXT NOT NULL, >+ PRIMARY KEY(id), >+ UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), >+ CONSTRAINT `biblio_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+CREATE TABLE deletedbiblio_metadata ( >+ `id` INT(11) NOT NULL AUTO_INCREMENT, >+ `biblionumber` INT(11) NOT NULL, >+ `format` VARCHAR(16) NOT NULL, >+ `marcflavour` VARCHAR(16) NOT NULL, >+ `metadata` LONGTEXT NOT NULL, >+ PRIMARY KEY(id), >+ UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), >+ CONSTRAINT `deletedbiblio_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+ >+INSERT INTO biblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM biblioitems; >+INSERT INTO deletedbiblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM deletedbiblioitems; >+UPDATE biblio_metadata SET marcflavour = (SELECT value FROM systempreferences WHERE variable="marcflavour"); >+UPDATE deletedbiblio_metadata SET marcflavour = (SELECT value FROM systempreferences WHERE variable="marcflavour"); >+ALTER TABLE biblioitems DROP COLUMN marcxml; >+ALTER TABLE deletedbiblioitems DROP COLUMN marcxml; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 991e37e..eea4f12 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -181,7 +181,6 @@ CREATE TABLE `biblioitems` ( -- information related to bibliographic records in > `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting > `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) > `totalissues` int(10), >- `marcxml` longtext, -- full bibliographic MARC record in MARCXML > PRIMARY KEY (`biblioitemnumber`), > KEY `bibinoidx` (`biblioitemnumber`), > KEY `bibnoidx` (`biblionumber`), >@@ -535,7 +534,6 @@ CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t > `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting > `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) > `totalissues` int(10), >- `marcxml` longtext, -- full bibliographic MARC record in MARCXML > PRIMARY KEY (`biblioitemnumber`), > KEY `bibinoidx` (`biblioitemnumber`), > KEY `bibnoidx` (`biblionumber`), >@@ -3795,6 +3793,35 @@ CREATE TABLE `hold_fill_targets` ( > REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >+-- >+-- Table structure for table `biblio_metadata` >+-- >+ >+CREATE TABLE biblio_metadata ( >+ `id` INT(11) NOT NULL AUTO_INCREMENT, >+ `biblionumber` INT(11) NOT NULL, >+ `format` VARCHAR(16) NOT NULL, >+ `marcflavour` VARCHAR(16) NOT NULL, >+ `metadata` LONGTEXT NOT NULL, >+ PRIMARY KEY(id), >+ CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+-- >+-- Table structure for table `deletedbiblio_metadata` >+-- >+ >+CREATE TABLE deletedbiblio_metadata ( >+ `id` INT(11) NOT NULL AUTO_INCREMENT, >+ `biblionumber` INT(11) NOT NULL, >+ `format` VARCHAR(16) NOT NULL, >+ `marcflavour` VARCHAR(16) NOT NULL, >+ `metadata` LONGTEXT NOT NULL, >+ PRIMARY KEY(id), >+ CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-- >2.8.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 17196
:
54910
|
54911
|
54912
|
54913
|
54914
|
54918
|
55856
|
55857
|
55858
|
55859
|
55860
|
55904
|
55905
|
55906
|
55907
|
55908
|
55921
|
55922
|
55950
|
55951
|
56038
|
57835
|
57836
|
57837
|
57838
|
57839
|
57840
|
57841
|
57842
|
58000
|
58007
|
58008
|
58023
|
58024
|
58025
|
58026
|
58027
|
58028
|
58029
|
58030
|
58031
|
58032
|
58037
|
58038
|
58039
|
58040
|
58041
|
58042
|
58043
|
58044
|
58045
|
58046
|
58047
|
58048
|
58504
|
58505
|
58506
|
58507
|
58508
|
58509
|
58510
|
58511
|
58512
|
58513
|
58514
|
58516
|
58517
|
58923
|
58924
|
58925
|
58926
|
58927
|
58928
|
58929
|
58930
|
58931
|
58932
|
58933
|
58934
|
58935
|
58936
|
58937
|
58938
|
58939
|
58943
|
58946
|
58947