From 530223344e9fffba9d95bb1403cc4e159d2c9630 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 29 Dec 2017 16:14:07 +0000 Subject: [PATCH] Bug 18639: Add replacementprice field to aqorders Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer --- .../bug_18639_add_replacementprice_field_to_aqorders.perl | 6 ++++++ installer/data/mysql/kohastructure.sql | 3 ++- 2 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl diff --git a/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl b/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl new file mode 100644 index 0000000000..004d6ab29b --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE aqorders ADD COLUMN replacementprice DECIMAL(28,6)" ); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 18639 - Add replacementprice field to aqorders table)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a15d4164de..120c72a6f2 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3190,7 +3190,8 @@ CREATE TABLE `aqorders` ( -- information related to the basket line items `purchaseordernumber` LONGTEXT, -- not used? always NULL `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified - `rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item + `rrp` decimal(13,2) DEFAULT NULL, -- the retail cost for this line item + `replacementprice` decimal(28,6) DEFAULT NULL, -- the replacement cost for this line item `rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax `rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax `ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item -- 2.17.1