Attachment 74267 Details for Bug 8643 – Bug 8643: (follow-up) Atomic update

[patch] Bug 8643: (follow-up) Atomic update

Bug-8643-follow-up-Atomic-update.patch (text/plain), 1.51 KB, created by Charles Farmer on 2018-04-16 20:15:39 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Charles Farmer

Created: 2018-04-16 20:15:39 UTC

Size: 1.51 KB

patch

obsolete

>From 45beb9eb3985fb42bc118b4ce4fe0fdd42aa79eb Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Fri, 18 Dec 2015 11:40:02 -0300
>Subject: [PATCH] Bug 8643: (follow-up) Atomic update
>
>Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../mysql/atomicupdate/bug-8643-add_important_constraint.sql   | 10 ++++++++++
> 1 file changed, 10 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql b/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql
>new file mode 100644
>index 0000000..0ffb746
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql
>@@ -0,0 +1,10 @@
>+ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory;
>+ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER frameworkcode;
>+
>+-- $DBversion = "3.23.00.XXX";
>+-- if ( CheckVersion($DBversion) ) {
>+--     $dbh->do("ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
>+--     $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER frameworkcode");
>+--     print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n";
>+--     SetVersion($DBversion);
>+-- }
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 8643: 11621 | 11622 | 30640 | 31032 | 40232 | 40237 | 41259 | 41261 | 41264 | 41265 | 45834 | 45835 | 45836 | 45837 | 60554 | 60555 | 65148 | 65149 | 65682 | 72154 | 72155 | 72156 | 72157 | 73591 | 73808 | 73809 | 73810 | 73811 | 73812 | 73813 | 73814 | 73815 | 73816 | 73817 | 73818 | 74267 | 74268 | 74269 | 74270 | 74271 | 74272 | 74273 | 81032 | 85982 | 91537 | 92081 | 92384 | 96625 | 96627 | 97325 | 97326 | 98607 | 98608 | 98702 | 98703 | 98712