Lines 7130-7136
if ( CheckVersion($DBversion) ) {
Link Here
|
7130 |
SetVersion($DBversion); |
7130 |
SetVersion($DBversion); |
7131 |
} |
7131 |
} |
7132 |
|
7132 |
|
7133 |
|
|
|
7134 |
$DBversion = "3.13.00.020"; |
7133 |
$DBversion = "3.13.00.020"; |
7135 |
if ( CheckVersion($DBversion) ) { |
7134 |
if ( CheckVersion($DBversion) ) { |
7136 |
$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')"); |
7135 |
$dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')"); |
Lines 7882-7887
$DBversion = "3.15.00.011";
Link Here
|
7882 |
if(CheckVersion($DBversion)) { |
7881 |
if(CheckVersion($DBversion)) { |
7883 |
$dbh->do("UPDATE marc_subfield_structure SET maxlength=9999 WHERE maxlength IS NULL OR maxlength=0;"); |
7882 |
$dbh->do("UPDATE marc_subfield_structure SET maxlength=9999 WHERE maxlength IS NULL OR maxlength=0;"); |
7884 |
print "Upgrade to $DBversion done (Bug 8018: set 9999 as default max length for subfields)\n"; |
7883 |
print "Upgrade to $DBversion done (Bug 8018: set 9999 as default max length for subfields)\n"; |
|
|
7884 |
SetVersion ($DBversion); |
7885 |
} |
7886 |
|
7887 |
|
7888 |
|
7889 |
|
7890 |
|
7891 |
|
7892 |
$DBversion = "3.15.00.XXX"; |
7893 |
if ( CheckVersion($DBversion) ) { |
7894 |
$dbh->do(q| |
7895 |
CREATE TABLE `additional_fields` ( |
7896 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
7897 |
`tablename` varchar(255) NOT NULL DEFAULT '', |
7898 |
`name` varchar(255) NOT NULL DEFAULT '', |
7899 |
`authorised_value_category` varchar(16) NOT NULL DEFAULT '', |
7900 |
`marcfield` varchar(16) NOT NULL DEFAULT '', |
7901 |
`searchable` tinyint(1) NOT NULL DEFAULT '0', |
7902 |
PRIMARY KEY (`id`), |
7903 |
UNIQUE KEY `fields_uniq` (`tablename`,`name`) |
7904 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
7905 |
|); |
7906 |
$dbh->do(q| |
7907 |
CREATE TABLE `additional_field_values` ( |
7908 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
7909 |
`field_id` int(11) NOT NULL, |
7910 |
`record_id` int(11) NOT NULL, |
7911 |
`value` varchar(255) NOT NULL DEFAULT '', |
7912 |
PRIMARY KEY (`id`), |
7913 |
UNIQUE KEY `field_record` (`field_id`,`record_id`), |
7914 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
7915 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
7916 |
|); |
7917 |
print "Upgrade to $DBversion done (Bug 10855: Add tables additional_fields and additional_field_values)\n"; |
7885 |
SetVersion($DBversion); |
7918 |
SetVersion($DBversion); |
7886 |
} |
7919 |
} |
7887 |
|
7920 |
|
7888 |
- |
|
|