@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl +++ a/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"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3169,7 +3169,8 @@ CREATE TABLE `aqorders` ( -- information related to the basket line items `purchaseordernumber` mediumtext, -- 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 --