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

(-)a/installer/data/mysql/atomicupdate/bug_36002.pl (+13 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => 36002,
5
    description => "Remove aqorders.purchaseordernumber",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
        if ( column_exists( 'aqorders', 'purchaseordernumber' ) ) {
10
            $dbh->do(q{ALTER TABLE aqorders DROP COLUMN purchaseordernumber});
11
        }
12
    },
13
};
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 739-745 CREATE TABLE `aqorders` ( Link Here
739
  `cancellationreason` mediumtext DEFAULT NULL COMMENT 'reason of cancellation',
739
  `cancellationreason` mediumtext DEFAULT NULL COMMENT 'reason of cancellation',
740
  `order_internalnote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for staff',
740
  `order_internalnote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for staff',
741
  `order_vendornote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for vendor',
741
  `order_vendornote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for vendor',
742
  `purchaseordernumber` longtext DEFAULT NULL COMMENT 'not used? always NULL',
743
  `basketno` int(11) DEFAULT NULL COMMENT 'links this order line to a specific basket (aqbasket.basketno)',
742
  `basketno` int(11) DEFAULT NULL COMMENT 'links this order line to a specific basket (aqbasket.basketno)',
744
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this order line was last modified',
743
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this order line was last modified',
745
  `rrp` decimal(13,2) DEFAULT NULL COMMENT 'the retail cost for this line item',
744
  `rrp` decimal(13,2) DEFAULT NULL COMMENT 'the retail cost for this line item',
746
- 

Return to bug 36002