`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
`label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
- `type` ENUM('string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
+ `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
PRIMARY KEY (`id`),
UNIQUE KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
});
$dbh->do(q{
- UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ';';
+ UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = '';
});
# If the DB has been created before 3.19.00.006, the default collate for marc_subfield_structure if not set to utf8_unicode_ci and the new FK will not be create (MariaDB or MySQL will raise err 150)
$dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|);
}
- my ( $used_in_templates ) = $dbh->selectrow_array(q|
- SELECT COUNT(*) FROM letter WHERE content LIKE "%<<opac_news.new>>%";
+ $dbh->do(q|
+ UPDATE letter SET content = REPLACE(content, "<<opac_news.new>>", "<<opac_news.content>>") WHERE content LIKE "%<<opac_news.new>>%"
|);
- if ( $used_in_templates ) {
- print "WARNING - It seems that you are using the opac_news.new column in your notice templates\n";
- print "Since it has now been renamed with opac_news.content, you should update them.\n";
- }
SetVersion( $DBversion );
- print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content)\n";
+ print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content (template notices have been updated!))\n";
}
$DBversion = "16.12.00.008";
print "Upgrade to $DBversion done (Bug 17453 - Inter-site holds improvement)\n";
}
+$DBversion = "16.12.00.010";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ ALTER TABLE borrowers ADD overdrive_auth_token text default NULL AFTER lastseen;
+ });
+
+ $dbh->do(q{
+ ALTER TABLE deletedborrowers ADD overdrive_auth_token text default NULL AFTER lastseen;
+ });
+
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
+ VALUES ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo');
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 16034 - Integration with OverDrive Patron API)\n";
+}
+
+$DBversion = "16.12.00.011";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ ALTER TABLE search_field CHANGE COLUMN type type ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL
+ COMMENT 'what type of data this holds, relevant when storing it in the search engine';
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 17260 - updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns)\n";
+}
+
+$DBversion = "16.12.00.012";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`)
+ VALUES ('OpacNewsLibrarySelect', '0', '', 'Show selector for branches on OPAC news page', 'YesNo');
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 14764 - Add OPAC News branch selector)\n";
+}
+
+$DBversion = "16.12.00.013";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`, `explanation`, `type`)
+ VALUES ('CircSidebar','0','','Activate or deactivate the navigation sidebar on all Circulation pages','YesNo');
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 16530 - Add a circ sidebar navigation menu)\n";
+}
+
+$DBversion = "16.12.00.014";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
+ ('LoadSearchHistoryToTheFirstLoggedUser', '1', NULL, 'If ON, the next user will automatically get the last searches in his history', 'YesNo');
+ });
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 8010 - Search history can be added to the wrong patron)\n";
+ }
+
+$DBversion = "16.12.00.015";
+if( CheckVersion( $DBversion ) ) {
+ unless( column_exists( 'branches', 'geolocation' ) ) {
+ $dbh->do(q|
+ ALTER TABLE branches ADD COLUMN geolocation VARCHAR(255) DEFAULT NULL after opac_info
+ |);
+ }
+
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsGeolocation', '', NULL, 'Geolocation of the main library', 'Free');
+ |);
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsLibrariesInfo', '', NULL, 'Share libraries information', 'YesNo');
+ |);
+ $dbh->do(q|
+ INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsPublicID', '', NULL, 'Public ID for Hea website', 'Free');
+ |);
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 18066 - Hea version 2)\n";
+}
+
+$DBversion = "16.12.00.016";
+if ( CheckVersion($DBversion) ) {
+ unless ( column_exists( 'borrower_attribute_types', 'opac_editable' ) )
+ {
+ $dbh->do(q{
+ ALTER TABLE borrower_attribute_types
+ ADD COLUMN `opac_editable` tinyint(1) NOT NULL default 0 AFTER `opac_display`
+ });
+ }
+
+ print "Upgrade to $DBversion done (Bug 13757: Make patron attributes editable in the opac if set to 'editable in OPAC)'\n";
+ SetVersion($DBversion);
+}
+
+$DBversion = "16.12.00.017";
+if ( CheckVersion($DBversion) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
+ VALUES ('CumulativeRestrictionPeriods', 0, NULL, 'Cumulate the restriction periods instead of keeping the highest', 'YesNo')
+ });
+
+ print "Upgrade to $DBversion done (Bug 14146 - Additional days are not added to restriction period when checking-in several overdues for same patron)'\n";
+ SetVersion($DBversion);
+}
+
+$DBversion = "16.12.00.018";
+if ( CheckVersion($DBversion) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type )
+ SELECT 'ExportCircHistory', COUNT(*), NULL, "Display the export circulation options", 'YesNo'
+ FROM systempreferences
+ WHERE ( variable = 'ExportRemoveFields' AND value != "" AND value IS NOT NULL )
+ OR ( variable = 'ExportWithCsvProfile' AND value != "" AND value IS NOT NULL );
+ });
+
+ $dbh->do(q{
+ DELETE FROM systempreferences WHERE variable="ExportWithCsvProfile";
+ });
+
+ print "Upgrade to $DBversion done (Bug 15498 - Replace ExportWithCsvProfile with ExportCircHistory)'\n";
+ SetVersion($DBversion);
+}
+
+$DBversion = "16.12.00.019";
+if( CheckVersion( $DBversion ) ) {
+ if ( column_exists( 'issues', 'return' ) ) {
+ $dbh->do(q|ALTER TABLE issues DROP column `return`|);
+ }
+
+ if ( column_exists( 'old_issues', 'return' ) ) {
+ $dbh->do(q|ALTER TABLE old_issues DROP column `return`|);
+ }
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 18173 - Remove issues.return DB field)\n";
+}
+
+$DBversion = "16.12.00.020";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ UPDATE systempreferences SET options="any_time_is_placed|not_always|any_time_is_collected" WHERE variable="HoldFeeMode";
+ });
+
+ $dbh->do(q{
+ UPDATE systempreferences SET value="any_time_is_placed" WHERE variable="HoldFeeMode" AND value="always";
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 17560 - Hold fee placement at point of checkout)\n";
+}
+
+$DBversion = "16.12.00.021";
+if( CheckVersion( $DBversion ) ) {
+ $dbh->do(q{
+ INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
+ ('RenewalLog','0','','If ON, log information about renewals','YesNo');
+ });
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 17708 - Renewal log seems empty)\n";
+}
+
+$DBversion = "16.12.00.022";
+if( CheckVersion( $DBversion ) ) {
+ print "NOTE: The sender for claim notifications has been corrected. The email address of the staff member is no longer used. We will use the branch email address or KohaAdminEmailAddress, as is done for other notices.\n";
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 17866 - Change sender for serial claim notifications)\n";
+}
+
+$DBversion = '16.12.00.023';
+if( CheckVersion( $DBversion ) ) {
+ my $oldval = C4::Context->preference('dontmerge');
+ my $newval = $oldval ? 0 : 50;
+
+ # Remove dontmerge, add AuthorityMergeLimit
+ $dbh->do(q{
+ DELETE FROM systempreferences WHERE variable = 'dontmerge';
+ });
+ $dbh->do(qq{
+ INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES ('AuthorityMergeLimit','$newval',NULL,'Maximum number of biblio records updated immediately when an authority record has been modified.','integer');
+ });
+
+ $dbh->do(q{
+ ALTER TABLE need_merge_authorities
+ ADD COLUMN authid_new BIGINT AFTER authid,
+ ADD COLUMN reportxml text AFTER authid_new,
+ ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
+ });
+
+ $dbh->do(q{
+ UPDATE need_merge_authorities SET authid_new=authid WHERE done <> 1
+ });
+
+ SetVersion( $DBversion );
+ if( $newval == 0 ) {
+ print "NOTE: Since dontmerge was enabled, we have initialized AuthorityMergeLimit to 0 records. Please consider raising this value. This will allow for performing smaller merges directly and only postponing larger merges.\n";
+ }
+ print "IMPORTANT NOTE: If you are not using a Debian package install, please verify that you no longer use misc/migration_tools/merge_authority.pl in your cron files AND add misc/cronjobs/merge_authorities.pl to cron now. This job is no longer optional! You need it to perform larger authority merges.\n";
+ print "Upgrade to $DBversion done (Bug 9988 - Add AuthorityMergeLimit)\n";
+}
+
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
projects / koha.git / blobdiff