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 (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    unless( column_exists( 'aqorders', 'estimated_delivery_date' ) ) {
4
        $dbh->do(q{ ALTER TABLE aqorders ADD estimated_delivery_date date default null AFTER suppliers_report });
5
6
        NewVersion( $DBversion, 15348, "Add new column aqorders.estimated_delivery_date" );
7
    }
8
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3319-3324 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3319
  suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref
3319
  suppliers_reference_number varchar(35) default NULL, -- Suppliers unique edifact quote ref
3320
  suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI'
3320
  suppliers_reference_qualifier varchar(3) default NULL, -- Type of number above usually 'QLI'
3321
  `suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers
3321
  `suppliers_report` MEDIUMTEXT COLLATE utf8mb4_unicode_ci, -- reports received from suppliers
3322
  `estimated_delivery_date` date default null,
3322
  PRIMARY KEY  (`ordernumber`),
3323
  PRIMARY KEY  (`ordernumber`),
3323
  KEY `basketno` (`basketno`),
3324
  KEY `basketno` (`basketno`),
3324
  KEY `biblionumber` (`biblionumber`),
3325
  KEY `biblionumber` (`biblionumber`),
3325
- 

Return to bug 15348