From 54b83a235ee14e66536bb28322810c6f085ad2ba Mon Sep 17 00:00:00 2001
From: Aleisha Amohia <aleishaamohia@hotmail.com>
Date: Wed, 16 Dec 2020 18:57:42 +1300
Subject: [PATCH] Bug 15348: Add estimated_delivey_date column to aqorders
table
---
.../bug_15348-add_aqorders.estimated_delivery_date.perl | 8 ++++++++
installer/data/mysql/kohastructure.sql | 1 +
2 files changed, 9 insertions(+)
create mode 100644 installer/data/mysql/atomicupdate/bug_15348-add_aqorders.estimated_delivery_date.perl
diff --git a/installer/data/mysql/atomicupdate/bug_15348-add_aqorders.estimated_delivery_date.perl b/installer/data/mysql/atomicupdate/bug_15348-add_aqorders.estimated_delivery_date.perl
new file mode 100644
index 0000000000..6251265c00
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_15348-add_aqorders.estimated_delivery_date.perl
@@ -0,0 +1,8 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+ unless( column_exists( 'aqorders', 'estimated_delivery_date' ) ) {
+ $dbh->do(q{ ALTER TABLE aqorders ADD estimated_delivery_date date default null AFTER suppliers_report });
+
+ NewVersion( $DBversion, 15348, "Add new column aqorders.estimated_delivery_date" );
+ }
+}
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index ef3bff04b0..49cd889934 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3319,6 +3319,7 @@ CREATE TABLE `aqorders` ( -- information related to the basket line items
suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref
suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI'
`suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers
+ `estimated_delivery_date` date default null,
PRIMARY KEY (`ordernumber`),
KEY `basketno` (`basketno`),
KEY `biblionumber` (`biblionumber`),
--
2.11.0