From c40a15af2118fe371cf4da5f8c7ed4b4aabf3e9d Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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