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 |
- |
|
|