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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 3055-3061 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3055
  `cancellationreason` text default NULL, -- reason of cancellation
3055
  `cancellationreason` text default NULL, -- reason of cancellation
3056
  `order_internalnote` mediumtext, -- notes related to this order line, made for staff
3056
  `order_internalnote` mediumtext, -- notes related to this order line, made for staff
3057
  `order_vendornote` mediumtext, -- notes related to this order line, made for vendor
3057
  `order_vendornote` mediumtext, -- notes related to this order line, made for vendor
3058
  `supplierreference` mediumtext, -- not used? always NULL
3059
  `purchaseordernumber` mediumtext, -- not used? always NULL
3058
  `purchaseordernumber` mediumtext, -- not used? always NULL
3060
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3059
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3061
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3060
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
(-)a/installer/data/mysql/updatedatabase.pl (+9 lines)
Lines 9531-9536 if( CheckVersion($DBversion) ){ Link Here
9531
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueLostValue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')");
9531
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueLostValue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')");
9532
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueDays', 'Set the LOST value of an item when the item has been overdue for more than n days.',  'integer')");
9532
    $dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueDays', 'Set the LOST value of an item when the item has been overdue for more than n days.',  'integer')");
9533
    print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";
9533
    print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";
9534
}
9535
9536
$DBversion = "3.17.00.XXX";
9537
if ( CheckVersion($DBversion) ) {
9538
    $dbh->do(q|
9539
        ALTER TABLE aqorders DROP COLUMN supplierreference;
9540
    |);
9541
9542
    print "Upgrade to $DBversion done (Bug 11008 - DROP column aqorders.supplierreference)\n";
9534
    SetVersion($DBversion);
9543
    SetVersion($DBversion);
9535
}
9544
}
9536
9545
(-)a/t/db_dependent/Acquisition.t (-4 lines)
Lines 339-345 my @expectedfields = qw( Link Here
339
  unitprice
339
  unitprice
340
  quantityreceived
340
  quantityreceived
341
  datecancellationprinted
341
  datecancellationprinted
342
  supplierreference
343
  purchaseordernumber
342
  purchaseordernumber
344
  basketno
343
  basketno
345
  timestamp
344
  timestamp
Lines 457-463 my @base_expectedfields = qw( Link Here
457
  biblioitemnumber
456
  biblioitemnumber
458
  datereceived
457
  datereceived
459
  orderstatus
458
  orderstatus
460
  supplierreference
461
  agerestriction
459
  agerestriction
462
  budget_branchcode
460
  budget_branchcode
463
  gstrate
461
  gstrate
Lines 578-584 ok( Link Here
578
  creationdate
576
  creationdate
579
  datereceived
577
  datereceived
580
  orderstatus
578
  orderstatus
581
  supplierreference
582
  isbn
579
  isbn
583
  copyrightdate
580
  copyrightdate
584
  gstrate
581
  gstrate
585
- 

Return to bug 11008