Attachment 67908 Details for Bug 15685 – Bug 15685: Fix DB columns order

[patch] Bug 15685: Fix DB columns order

Bug-15685-Fix-DB-columns-order.patch (text/plain), 2.05 KB, created by Jonathan Druart on 2017-10-10 20:48:42 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2017-10-10 20:48:42 UTC

Size: 2.05 KB

patch

obsolete

>From c40a15af2118fe371cf4da5f8c7ed4b4aabf3e9d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Tue, 10 Oct 2017 17:01:25 -0300
>Subject: [PATCH] Bug 15685: Fix DB columns order
>
>---
> installer/data/mysql/atomicupdate/bug15685.perl | 2 +-
> installer/data/mysql/kohastructure.sql          | 2 +-
> 2 files changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug15685.perl b/installer/data/mysql/atomicupdate/bug15685.perl
>index 7721df59fa..620696b49b 100644
>--- a/installer/data/mysql/atomicupdate/bug15685.perl
>+++ b/installer/data/mysql/atomicupdate/bug15685.perl
>@@ -4,7 +4,7 @@ if( CheckVersion( $DBversion ) ) {
>     unless( column_exists('aqbasket','create_items') ){
>         $dbh->do(q{
>             ALTER TABLE aqbasket
>-                ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL
>+                ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL AFTER is_standing
>         });
>     }
> 
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 9b00860da2..3cdee18be9 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2992,9 +2992,9 @@ CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
>   `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id)
>   `deliveryplace` varchar(10) default NULL, -- basket delivery place
>   `billingplace` varchar(10) default NULL, -- basket billing place
>-  create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL, -- when items should be created for orders in this basket
>   branch varchar(10) default NULL, -- basket branch
>   is_standing TINYINT(1) NOT NULL DEFAULT 0, -- orders in this basket are standing
>+  create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL, -- when items should be created for orders in this basket
>   PRIMARY KEY  (`basketno`),
>   KEY `booksellerid` (`booksellerid`),
>   KEY `basketgroupid` (`basketgroupid`),
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 15685: 47783 | 55094 | 55096 | 57390 | 57392 | 57395 | 57424 | 57425 | 57426 | 57427 | 64918 | 64919 | 64920 | 64921 | 64922 | 65119 | 65120 | 65121 | 65122 | 65895 | 65896 | 65897 | 65898 | 65899 | 65900 | 66119 | 66120 | 66121 | 66122 | 66123 | 66124 | 67638 | 67639 | 67640 | 67641 | 67642 | 67643 | 67644 | 67645 | 67646 | 67647 | 67689 | 67690 | 67691 | 67692 | 67693 | 67694 | 67695 | 67696 | 67697 | 67698 | 67884 | 67898 | 67899 | 67900 | 67901 | 67902 | 67903 | 67904 | 67905 | 67906 | 67907 | 67908 | 67909 | 67910 | 67911