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

(-)a/installer/data/mysql/updatedatabase.pl (-23 / +22 lines)
Lines 22703-22730 if( CheckVersion( $DBversion ) ) { Link Here
22703
    NewVersion( $DBversion, 22789, "Add non_priority column on reserves and old_reserves tables");
22703
    NewVersion( $DBversion, 22789, "Add non_priority column on reserves and old_reserves tables");
22704
}
22704
}
22705
22705
22706
$DBversion = '20.06.00.032';
22707
if( CheckVersion( $DBversion ) ) {
22708
    if( !column_exists( 'items', 'exclude_from_local_holds_priority' ) ) {
22709
        $dbh->do(q{
22710
            ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`
22711
        });
22712
    }
22713
22714
    if( !column_exists( 'deleteditems', 'exclude_from_local_holds_priority' ) ) {
22715
        $dbh->do(q{
22716
            ALTER TABLE `deleteditems` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`
22717
        });
22718
    }
22719
22720
    if( !column_exists( 'categories', 'exclude_from_local_holds_priority' ) ) {
22721
        $dbh->do(q{
22722
            ALTER TABLE `categories` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `require_strong_password`
22723
        });
22724
    }
22725
    NewVersion( $DBversion, 19889, "Add exclude_from_local_holds_priority column to items, deleteditems and categories tables");
22726
}
22727
22728
$DBversion = '20.06.00.033';
22706
$DBversion = '20.06.00.033';
22729
if( CheckVersion( $DBversion ) ) {
22707
if( CheckVersion( $DBversion ) ) {
22730
    if( column_exists( 'opac_news', 'timestamp' ) ) {
22708
    if( column_exists( 'opac_news', 'timestamp' ) ) {
Lines 22807-22812 if( CheckVersion( $DBversion ) ) { Link Here
22807
    NewVersion( $DBversion, 18958, "Add reserve_id to hold_fill_targets");
22785
    NewVersion( $DBversion, 18958, "Add reserve_id to hold_fill_targets");
22808
}
22786
}
22809
22787
22788
$DBversion = '20.06.00.040';
22789
if( CheckVersion( $DBversion ) ) {
22790
    if( !column_exists( 'items', 'exclude_from_local_holds_priority' ) ) {
22791
        $dbh->do(q{
22792
            ALTER TABLE `items` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`
22793
        });
22794
    }
22795
22796
    if( !column_exists( 'deleteditems', 'exclude_from_local_holds_priority' ) ) {
22797
        $dbh->do(q{
22798
            ALTER TABLE `deleteditems` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`
22799
        });
22800
    }
22801
22802
    if( !column_exists( 'categories', 'exclude_from_local_holds_priority' ) ) {
22803
        $dbh->do(q{
22804
            ALTER TABLE `categories` ADD COLUMN `exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `require_strong_password`
22805
        });
22806
    }
22807
    NewVersion( $DBversion, 19889, "Add exclude_from_local_holds_priority column to items, deleteditems and categories tables");
22808
}
22809
22810
# SEE bug 13068
22810
# SEE bug 13068
22811
# if there is anything in the atomicupdate, read and execute it.
22811
# if there is anything in the atomicupdate, read and execute it.
22812
my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';
22812
my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';
22813
- 

Return to bug 26513