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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 3006-3012 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3006
  `datecancellationprinted` date default NULL, -- the date the line item was deleted
3006
  `datecancellationprinted` date default NULL, -- the date the line item was deleted
3007
  `order_internalnote` mediumtext, -- notes related to this order line, made for staff
3007
  `order_internalnote` mediumtext, -- notes related to this order line, made for staff
3008
  `order_vendornote` mediumtext, -- notes related to this order line, made for vendor
3008
  `order_vendornote` mediumtext, -- notes related to this order line, made for vendor
3009
  `supplierreference` mediumtext, -- not used? always NULL
3010
  `purchaseordernumber` mediumtext, -- not used? always NULL
3009
  `purchaseordernumber` mediumtext, -- not used? always NULL
3011
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3010
  `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3012
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified
3011
  `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 (+10 lines)
Lines 8570-8575 if ( CheckVersion($DBversion) ) { Link Here
8570
    SetVersion($DBversion);
8570
    SetVersion($DBversion);
8571
}
8571
}
8572
8572
8573
$DBversion = "3.17.00.XXX";
8574
if ( CheckVersion($DBversion) ) {
8575
    $dbh->do(q|
8576
        ALTER TABLE aqorders DROP COLUMN supplierreference;
8577
    |);
8578
8579
    print "Upgrade to $DBversion done (Bug 11008 - DROP column aqorders.supplierreference)\n";
8580
    SetVersion($DBversion);
8581
}
8582
8573
=head1 FUNCTIONS
8583
=head1 FUNCTIONS
8574
8584
8575
=head2 TableExists($table)
8585
=head2 TableExists($table)
(-)a/t/db_dependent/Acquisition.t (-4 lines)
Lines 365-371 my @expectedfields = qw( Link Here
365
  quantityreceived
365
  quantityreceived
366
  cancelledby
366
  cancelledby
367
  datecancellationprinted
367
  datecancellationprinted
368
  supplierreference
369
  purchaseordernumber
368
  purchaseordernumber
370
  basketno
369
  basketno
371
  timestamp
370
  timestamp
Lines 483-489 my @base_expectedfields = qw( Link Here
483
  biblioitemnumber
482
  biblioitemnumber
484
  datereceived
483
  datereceived
485
  orderstatus
484
  orderstatus
486
  supplierreference
487
  agerestriction
485
  agerestriction
488
  budget_branchcode
486
  budget_branchcode
489
  gstrate
487
  gstrate
Lines 603-609 ok( Link Here
603
  creationdate
601
  creationdate
604
  datereceived
602
  datereceived
605
  orderstatus
603
  orderstatus
606
  supplierreference
607
  cancelledby
604
  cancelledby
608
  isbn
605
  isbn
609
  copyrightdate
606
  copyrightdate
610
- 

Return to bug 11008