View | Details | Raw Unified | Return to bug 18639
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_18639_add_replacementprice_field_to_aqorders.perl (+6 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE  aqorders ADD COLUMN replacementprice DECIMAL(28,6)" );
4
    SetVersion( $DBversion );
5
    print "Upgrade to $DBversion done (Bug 18639 - Add replacementprice field to aqorders table)\n";
6
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 3169-3175 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3169
  `purchaseordernumber` mediumtext, -- not used? always NULL
3169
  `purchaseordernumber` mediumtext, -- not used? always NULL
3170
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3170
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3171
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3171
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3172
  `rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3172
  `rrp` decimal(13,2) DEFAULT NULL, -- the retail cost for this line item
3173
  `replacementprice` decimal(28,6) DEFAULT NULL, -- the replacement cost for this line item
3173
  `rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax
3174
  `rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax
3174
  `rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax
3175
  `rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax
3175
  `ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3176
  `ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3176
- 

Return to bug 18639