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

(-)a/installer/data/mysql/atomicupdate/bug_15348-add_aqorders.estimated_delivery_date.perl (-9 lines)
Lines 1-9 Link Here
1
use Date::Calc qw( Add_Delta_Days );
2
$DBversion = 'XXX';
3
if( CheckVersion( $DBversion ) ) {
4
    unless( column_exists( 'aqorders', 'estimated_delivery_date' ) ) {
5
        $dbh->do(q{ ALTER TABLE aqorders ADD estimated_delivery_date date default null AFTER suppliers_report });
6
7
        NewVersion( $DBversion, 15348, "Add new column aqorders.estimated_delivery_date" );
8
    }
9
}
(-)a/installer/data/mysql/atomicupdate/bug_15348.pl (+18 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "15348",
5
    description => "Add new column aqorders.estimated_delivery_date",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        unless ( column_exists( 'aqorders', 'estimated_delivery_date' ) ) {
11
            $dbh->do(q{
12
                ALTER TABLE aqorders
13
                  ADD estimated_delivery_date date DEFAULT NULL COMMENT 'Estimated delivery date'
14
                  AFTER suppliers_report
15
            });
16
        }
17
    },
18
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 693-699 CREATE TABLE `aqorders` ( Link Here
693
  `suppliers_reference_number` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Suppliers unique edifact quote ref',
693
  `suppliers_reference_number` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Suppliers unique edifact quote ref',
694
  `suppliers_reference_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of number above usually ''QLI''',
694
  `suppliers_reference_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of number above usually ''QLI''',
695
  `suppliers_report` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'reports received from suppliers',
695
  `suppliers_report` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'reports received from suppliers',
696
  `estimated_delivery_date` date default null,
696
  `estimated_delivery_date` date DEFAULT NULL COMMENT 'Estimated delivery date',
697
  PRIMARY KEY (`ordernumber`),
697
  PRIMARY KEY (`ordernumber`),
698
  KEY `basketno` (`basketno`),
698
  KEY `basketno` (`basketno`),
699
  KEY `biblionumber` (`biblionumber`),
699
  KEY `biblionumber` (`biblionumber`),
700
- 

Return to bug 15348