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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 2522-2531 CREATE TABLE `aqorders` ( Link Here
2522
  PRIMARY KEY  (`ordernumber`),
2522
  PRIMARY KEY  (`ordernumber`),
2523
  KEY `basketno` (`basketno`),
2523
  KEY `basketno` (`basketno`),
2524
  KEY `biblionumber` (`biblionumber`),
2524
  KEY `biblionumber` (`biblionumber`),
2525
  KEY `budget_id` (`budget_id`),
2525
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2526
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2526
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2527
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2527
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2528
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2528
2529
2530
2529
--
2531
--
2530
-- Table structure for table `aqorders_items`
2532
-- Table structure for table `aqorders_items`
2531
--
2533
--
(-)a/installer/data/mysql/updatedatabase.pl (+7 lines)
Lines 3548-3553 if (C4::Context->preference('Version') < TransformToNum($DBversion)){ Link Here
3548
    SetVersion ($DBversion);
3548
    SetVersion ($DBversion);
3549
}
3549
}
3550
3550
3551
$DBversion = '3.01.00.128';
3552
if (C4::Context->preference('Version') < TransformToNum($DBversion)){
3553
    $dbh->do('CREATE INDEX budget_id ON aqorders (budget_id );');
3554
    print "Upgrade to $DBversion done (bug 4331: index orders by budget_id)\n";
3555
    SetVersion ($DBversion);
3556
}
3557
3551
=item DropAllForeignKeys($table)
3558
=item DropAllForeignKeys($table)
3552
3559
3553
  Drop all foreign keys of the table $table
3560
  Drop all foreign keys of the table $table
(-)a/kohaversion.pl (-2 / +1 lines)
Lines 10-16 Link Here
10
use strict;
10
use strict;
11
11
12
sub kohaversion {
12
sub kohaversion {
13
    our $VERSION = '3.01.00.127';
13
    our $VERSION = '3.01.00.128';
14
    # version needs to be set this way
14
    # version needs to be set this way
15
    # so that it can be picked up by Makefile.PL
15
    # so that it can be picked up by Makefile.PL
16
    # during install
16
    # during install
17
- 

Return to bug 4331