Bugzilla – Attachment 36792 Details for
Bug 13068
New feature for DB update and sandbox
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13068: (follow-up) Remove old files, use C4::Installer
Bug-13068-follow-up-Remove-old-files-use-C4Install.patch (text/plain), 4.60 KB, created by
Jonathan Druart
on 2015-03-11 13:28:16 UTC
(
hide
)
Description:
Bug 13068: (follow-up) Remove old files, use C4::Installer
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2015-03-11 13:28:16 UTC
Size:
4.60 KB
patch
obsolete
>From b1c53e96efab94cb996bddfc2af7971129b69ae5 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Wed, 11 Mar 2015 14:27:31 +0100 >Subject: [PATCH] Bug 13068: (follow-up) Remove old files, use C4::Installer > > The do method does not accept more than 1 sql query. >--- > installer/data/mysql/updatedatabase.pl | 74 +++++++++++++++++++--------------- > 1 file changed, 41 insertions(+), 33 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index e3c45ec..e38e468 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -4942,44 +4942,52 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > > $DBversion = "3.07.00.029"; > if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >- $dbh->do(qq{ >-DROP TABLE IF EXISTS `oai_sets_descriptions`; >-DROP TABLE IF EXISTS `oai_sets_mappings`; >-DROP TABLE IF EXISTS `oai_sets_biblios`; >-DROP TABLE IF EXISTS `oai_sets`; >- >-CREATE TABLE `oai_sets` ( >- `id` int(11) NOT NULL auto_increment, >- `spec` varchar(80) NOT NULL UNIQUE, >- `name` varchar(80) NOT NULL, >- PRIMARY KEY (`id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ $dbh->do(q{DROP TABLE IF EXISTS `oai_sets_descriptions`;}); >+ $dbh->do(q{DROP TABLE IF EXISTS `oai_sets_mappings`;}); >+ $dbh->do(q{DROP TABLE IF EXISTS `oai_sets_biblios`;}); >+ $dbh->do(q{DROP TABLE IF EXISTS `oai_sets`;}); > >-CREATE TABLE `oai_sets_descriptions` ( >- `set_id` int(11) NOT NULL, >- `description` varchar(255) NOT NULL, >- CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ $dbh->do(q{ >+ CREATE TABLE `oai_sets` ( >+ `id` int(11) NOT NULL auto_increment, >+ `spec` varchar(80) NOT NULL UNIQUE, >+ `name` varchar(80) NOT NULL, >+ PRIMARY KEY (`id`) >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ }); > >-CREATE TABLE `oai_sets_mappings` ( >- `set_id` int(11) NOT NULL, >- `marcfield` char(3) NOT NULL, >- `marcsubfield` char(1) NOT NULL, >- `marcvalue` varchar(80) NOT NULL, >- CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ $dbh->do(q{ >+ CREATE TABLE `oai_sets_descriptions` ( >+ `set_id` int(11) NOT NULL, >+ `description` varchar(255) NOT NULL, >+ CONSTRAINT `oai_sets_descriptions_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ }); > >-CREATE TABLE `oai_sets_biblios` ( >- `biblionumber` int(11) NOT NULL, >- `set_id` int(11) NOT NULL, >- PRIMARY KEY (`biblionumber`, `set_id`), >- CONSTRAINT `oai_sets_biblios_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >-) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ $dbh->do(q{ >+ CREATE TABLE `oai_sets_mappings` ( >+ `set_id` int(11) NOT NULL, >+ `marcfield` char(3) NOT NULL, >+ `marcsubfield` char(1) NOT NULL, >+ `marcvalue` varchar(80) NOT NULL, >+ CONSTRAINT `oai_sets_mappings_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ }); > >-INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OAI-PMH:AutoUpdateSets','0','Automatically update OAI sets when a bibliographic record is created or updated','','YesNo'); >+ $dbh->do(q{ >+ CREATE TABLE `oai_sets_biblios` ( >+ `biblionumber` int(11) NOT NULL, >+ `set_id` int(11) NOT NULL, >+ PRIMARY KEY (`biblionumber`, `set_id`), >+ CONSTRAINT `oai_sets_biblios_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ }); >+ >+ $dbh->do(q{ >+ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OAI-PMH:AutoUpdateSets','0','Automatically update OAI sets when a bibliographic record is created or updated','','YesNo'); >+ }); > >-}); > print "Upgrade to $DBversion done (Atomic update for OAI-PMH sets management)\n"; > SetVersion($DBversion); > } >-- >2.1.0
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 13068
:
32173
|
32174
|
32175
|
32177
|
32178
|
32179
|
32180
|
32185
|
32294
|
32300
|
32398
|
32399
|
32525
|
32526
|
32658
|
32659
|
32784
|
32785
|
32839
|
32840
|
32841
|
32842
|
32843
|
32919
|
32921
|
33859
|
34070
|
34071
|
34072
|
34949
|
34950
|
34951
|
34960
|
34998
|
35000
|
35001
|
35002
|
35003
|
35366
|
35367
|
35368
|
35370
|
36716
|
36717
|
36718
|
36719
|
36779
|
36780
|
36781
|
36792
|
37061
|
37062
|
37063
|
37064
|
37065
|
37066
|
37075
|
37076
|
37491