Attachment #101160 for bug #24131

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





$DBversion = '19.11.00.000';
if( CheckVersion( $DBversion ) ) {
    NewVersion( $DBversion, undef, '19.11.00 release' );
}

$DBversion = '19.12.00.000';

    if ( !column_exists( 'marc_tag_structure', 'important') ){
        $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
    }

    NewVersion( $DBversion, 8643, 'Add important constraint to marc subfields' );
}

$DBversion = '19.12.00.021';

          ( 'Lost Item Found' )
    });

    NewVersion( $DBversion, 24592, 'Update LOST_RETURN to LOST_FOUND');
    print "Upgrade to $DBversion done (Bug 24592 - Update LOST_RETURN to LOST_FOUND)\n";
}

$DBversion = '19.12.00.022';

    $dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );
    $dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );

    NewVersion( $DBversion, 20882, 'items.uri to MEDIUMTEXT');
    print "Upgrade to $DBversion done (Bug 20882 - items.uri to MEDIUMTEXT)\n";
}

$DBversion = '19.12.00.023';
if( CheckVersion( $DBversion ) ) {
    $dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );

    NewVersion( $DBversion, 24640, 'Allow quotes.timestamp to be NULL');
    print "Upgrade to $DBversion done (Bug 24640 - Allow quotes.timestamp to be NULL)\n";
}

$DBversion = '19.12.00.024';

        explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines).  Requires accruefines cronjob or CalculateFinesOnReturn system preference."
        WHERE variable = 'finesMode'
    });

    NewVersion( $DBversion, 21633, 'Remove finesMode "test"');
}

$DBversion = '19.12.00.025';

        INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)
        VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')
    });

    NewVersion( $DBversion, 24103, 'add DumpSearchQueryTemplate syspref');
}

$DBversion = '19.12.00.026';

        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
    }

    NewVersion( $DBversion, 11297, 'Add support for custom PQF attributes for Z39.50 server searches');
    print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";
}

$DBversion = '19.12.00.027';

        debit_type_code IS NOT NULL
    });

    NewVersion( $DBversion, 24532, 'Fix pathological cases of negative debits');
    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 24532 - Fix pathological cases of negative debits)\n";
}

$DBversion = '19.12.00.028';

        VALUES
        ('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')
    });

    NewVersion( $DBversion, 14567, 'Add OpacBrowseSearch syspref');
}

$DBversion = '19.12.00.029';
- 

Return to bug 24131

Lines 20228-20234 if( CheckVersion( $DBversion ) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-21 / +14 lines)
20228		20228
20229	$DBversion = '19.11.00.000';	20229	$DBversion = '19.11.00.000';
20230	if( CheckVersion( $DBversion ) ) {	20230	if( CheckVersion( $DBversion ) ) {
20231	NewVersion( $DBversion, undef '19.11.00 release' );	20231	NewVersion( $DBversion, undef, '19.11.00 release' );
20232	}	20232	}
20233		20233
20234	$DBversion = '19.12.00.000';	20234	$DBversion = '19.12.00.000';
Lines 20724-20731 if ( CheckVersion($DBversion) ) { Link Here
20724	if ( !column_exists( 'marc_tag_structure', 'important') ){	20724	if ( !column_exists( 'marc_tag_structure', 'important') ){
20725	$dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER mandatory");	20725	$dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER mandatory");
20726	}	20726	}
20727	SetVersion($DBversion);	20727
20728	print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n";	20728	NewVersion( $DBversion, 8643, 'Add important constraint to marc subfields' );
20729	}	20729	}
20730		20730
20731	$DBversion = '19.12.00.021';	20731	$DBversion = '19.12.00.021';
Lines 20774-20781 if( CheckVersion( $DBversion ) ) { Link Here
20774	( 'Lost Item Found' )	20774	( 'Lost Item Found' )
20775	});	20775	});
20776		20776
20777	SetVersion( $DBversion );	20777	NewVersion( $DBversion, 24592, 'Update LOST_RETURN to LOST_FOUND');
20778	print "Upgrade to $DBversion done (Bug 24592 - Update LOST_RETURN to LOST_FOUND)\n";
20779	}	20778	}
20780		20779
20781	$DBversion = '19.12.00.022';	20780	$DBversion = '19.12.00.022';
Lines 20783-20798 if( CheckVersion( $DBversion ) ) { Link Here
20783	$dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );	20782	$dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );
20784	$dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );	20783	$dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );
20785		20784
20786	SetVersion( $DBversion );	20785	NewVersion( $DBversion, 20882, 'items.uri to MEDIUMTEXT');
20787	print "Upgrade to $DBversion done (Bug 20882 - items.uri to MEDIUMTEXT)\n";
20788	}	20786	}
20789		20787
20790	$DBversion = '19.12.00.023';	20788	$DBversion = '19.12.00.023';
20791	if( CheckVersion( $DBversion ) ) {	20789	if( CheckVersion( $DBversion ) ) {
20792	$dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );	20790	$dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );
20793		20791
20794	SetVersion( $DBversion );	20792	NewVersion( $DBversion, 24640, 'Allow quotes.timestamp to be NULL');
20795	print "Upgrade to $DBversion done (Bug 24640 - Allow quotes.timestamp to be NULL)\n";
20796	}	20793	}
20797		20794
20798	$DBversion = '19.12.00.024';	20795	$DBversion = '19.12.00.024';
Lines 20806-20813 if( CheckVersion( $DBversion ) ) { Link Here
20806	explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines). Requires accruefines cronjob or CalculateFinesOnReturn system preference."	20803	explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines). Requires accruefines cronjob or CalculateFinesOnReturn system preference."
20807	WHERE variable = 'finesMode'	20804	WHERE variable = 'finesMode'
20808	});	20805	});
20809	SetVersion( $DBversion );	20806
20810	print "Upgrade to $DBversion done (Bug 21633 - Remove finesMode 'test')\n";	20807	NewVersion( $DBversion, 21633, 'Remove finesMode "test"');
20811	}	20808	}
20812		20809
20813	$DBversion = '19.12.00.025';	20810	$DBversion = '19.12.00.025';
Lines 20816-20823 if( CheckVersion( $DBversion ) ) { Link Here
20816	INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)	20813	INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)
20817	VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')	20814	VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')
20818	});	20815	});
20819	SetVersion( $DBversion );	20816
20820	print "Upgrade to $DBversion done (Bug 24103 - add DumpSearchQueryTemplate syspref)\n";	20817	NewVersion( $DBversion, 24103, 'add DumpSearchQueryTemplate syspref');
20821	}	20818	}
20822		20819
20823	$DBversion = '19.12.00.026';	20820	$DBversion = '19.12.00.026';
Lines 20826-20833 if( CheckVersion( $DBversion ) ) { Link Here
20826	$dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );	20823	$dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
20827	}	20824	}
20828		20825
20829	SetVersion( $DBversion );	20826	NewVersion( $DBversion, 11297, 'Add support for custom PQF attributes for Z39.50 server searches');
20830	print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";
20831	}	20827	}
20832		20828
20833	$DBversion = '19.12.00.027';	20829	$DBversion = '19.12.00.027';
Lines 20869-20877 if( CheckVersion( $DBversion ) ) { Link Here
20869	debit_type_code IS NOT NULL	20865	debit_type_code IS NOT NULL
20870	});	20866	});
20871		20867
20872	# Always end with this (adjust the bug info)	20868	NewVersion( $DBversion, 24532, 'Fix pathological cases of negative debits');
20873	SetVersion( $DBversion );
20874	print "Upgrade to $DBversion done (Bug 24532 - Fix pathological cases of negative debits)\n";
20875	}	20869	}
20876		20870
20877	$DBversion = '19.12.00.028';	20871	$DBversion = '19.12.00.028';
Lines 20881-20888 if( CheckVersion( $DBversion ) ) { Link Here
20881	VALUES	20875	VALUES
20882	('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')	20876	('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')
20883	});	20877	});
20884	SetVersion( $DBversion );	20878
20885	print "Upgrade to $DBversion done (Bug 14567: Add OpacBrowseSearch syspref)\n";	20879	NewVersion( $DBversion, 14567, 'Add OpacBrowseSearch syspref');
20886	}	20880	}
20887		20881
20888	$DBversion = '19.12.00.029';	20882	$DBversion = '19.12.00.029';
20889	-