Attachment 43554 Details for Bug 10363 – [PASSED QA] Bug 10363: (QA followup) DB update / atomic update

[patch] [PASSED QA] Bug 10363: (QA followup) DB update / atomic update

PASSED-QA-Bug-10363-QA-followup-DB-update--atomic-.patch (text/plain), 1.44 KB, created by Katrin Fischer on 2015-10-18 09:02:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-10-18 09:02:49 UTC

Size: 1.44 KB

patch

obsolete

>From 085e58cb9b82c1528bedf5b1df37820778755d84 Mon Sep 17 00:00:00 2001
>From: =?UTF-8?q?Tom=C3=A1s=20Cohen=20Arazi?= <tomascohen@theke.io>
>Date: Fri, 31 Jul 2015 12:41:48 -0300
>Subject: [PATCH] [PASSED QA] Bug 10363: (QA followup) DB update / atomic
> update
>
>This patch just moves the DB update code into an atomicupdate file
>to avoid nasty merge conflicts.
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> .../data/mysql/atomicupdate/bug_10363_av_package.sql     | 16 ++++++++++++++++
> 1 file changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_10363_av_package.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_10363_av_package.sql b/installer/data/mysql/atomicupdate/bug_10363_av_package.sql
>new file mode 100644
>index 0000000..18445d9
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_10363_av_package.sql
>@@ -0,0 +1,16 @@
>+ALTER TABLE authorised_values_branches
>+    CHANGE av_id av_id INT( 11 ) NOT NULL,
>+    CHANGE branchcode branchcode VARCHAR( 10 ) NOT NULL;
>+
>+/*
>+$DBversion = "3.21.00.XXX";
>+if ( CheckVersion($DBversion) ) {
>+   $dbh->do(q{
>+       ALTER TABLE authorised_values_branches
>+         CHANGE av_id av_id INT( 11 ) NOT NULL,
>+         CHANGE branchcode branchcode VARCHAR( 10 ) NOT NULL
>+   });
>+   print "Upgrade to $DBversion done (Bug 10363: There is no package for authorised values)\n";
>+   SetVersion($DBversion);
>+}
>+*/
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 10363: 18430 | 18431 | 18432 | 18751 | 18752 | 18753 | 20729 | 21833 | 21834 | 21835 | 21836 | 25284 | 25285 | 25286 | 25287 | 30583 | 30584 | 30585 | 30710 | 30711 | 30712 | 31565 | 32632 | 32633 | 32634 | 33416 | 33417 | 33422 | 33423 | 33860 | 33861 | 33862 | 33889 | 33949 | 35838 | 35839 | 35840 | 35841 | 41290 | 41291 | 41292 | 41293 | 41294 | 41302 | 41343 | 41344 | 41345 | 43112 | 43113 | 43114 | 43550 | 43551 | 43552 | 43553 | 43554 | 43555 | 43556 | 43557 | 43558 | 43559 | 43696 | 43827