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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +4 lines)
Lines 2818-2823 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
2818
2818
2819
$DBversion = '3.01.00.073';
2819
$DBversion = '3.01.00.073';
2820
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
2820
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
2821
    $dbh->do('SET FOREIGN_KEY_CHECKS=0 ');
2821
    $dbh->do(<<'END_SQL');
2822
    $dbh->do(<<'END_SQL');
2822
CREATE TABLE IF NOT EXISTS `aqcontract` (
2823
CREATE TABLE IF NOT EXISTS `aqcontract` (
2823
  `contractnumber` int(11) NOT NULL auto_increment,
2824
  `contractnumber` int(11) NOT NULL auto_increment,
Lines 2831-2836 CREATE TABLE IF NOT EXISTS `aqcontract` ( Link Here
2831
        REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2832
        REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2832
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2833
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2833
END_SQL
2834
END_SQL
2835
    $dbh->do('SET FOREIGN_KEY_CHECKS=1 ');
2834
    print "Upgrade to $DBversion done (adding aqcontract table)\n";
2836
    print "Upgrade to $DBversion done (adding aqcontract table)\n";
2835
    SetVersion ($DBversion);
2837
    SetVersion ($DBversion);
2836
}
2838
}
Lines 2856-2861 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
2856
2858
2857
$DBversion = '3.01.00.076';
2859
$DBversion = '3.01.00.076';
2858
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
2860
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
2861
    $dbh->do('SET FOREIGN_KEY_CHECKS=0 ');
2859
    $dbh->do("CREATE TABLE IF NOT EXISTS `aqbasketgroups` (
2862
    $dbh->do("CREATE TABLE IF NOT EXISTS `aqbasketgroups` (
2860
                         `id` int(11) NOT NULL auto_increment,
2863
                         `id` int(11) NOT NULL auto_increment,
2861
                         `name` varchar(50) default NULL,
2864
                         `name` varchar(50) default NULL,
Lines 2868-2873 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
2868
    $dbh->do("ALTER TABLE aqbasket ADD COLUMN `basketgroupid` int(11)");
2871
    $dbh->do("ALTER TABLE aqbasket ADD COLUMN `basketgroupid` int(11)");
2869
    $dbh->do("ALTER TABLE aqbasket ADD FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE ON DELETE SET NULL");
2872
    $dbh->do("ALTER TABLE aqbasket ADD FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE ON DELETE SET NULL");
2870
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('pdfformat','pdfformat::layout2pages','Controls what script is used for printing (basketgroups)','','free')");
2873
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('pdfformat','pdfformat::layout2pages','Controls what script is used for printing (basketgroups)','','free')");
2874
    $dbh->do('SET FOREIGN_KEY_CHECKS=1 ');
2871
    print "Upgrade to $DBversion done (adding basketgroups)\n";
2875
    print "Upgrade to $DBversion done (adding basketgroups)\n";
2872
    SetVersion ($DBversion);
2876
    SetVersion ($DBversion);
2873
}
2877
}
2874
- 

Return to bug 4972