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 3190-3196 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3190
  `purchaseordernumber` LONGTEXT, -- not used? always NULL
3190
  `purchaseordernumber` LONGTEXT, -- not used? always NULL
3191
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3191
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3192
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3192
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3193
  `rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3193
  `rrp` decimal(13,2) DEFAULT NULL, -- the retail cost for this line item
3194
  `replacementprice` decimal(28,6) DEFAULT NULL, -- the replacement cost for this line item
3194
  `rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax
3195
  `rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax
3195
  `rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax
3196
  `rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax
3196
  `ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3197
  `ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item
3197
- 

Return to bug 18639