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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
Lines 3987-3992 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
3987
    SetVersion ($DBversion);
3987
    SetVersion ($DBversion);
3988
}
3988
}
3989
3989
3990
$DBversion = "3.03.00.XXX";
3991
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
3992
3993
    my ($opac_sug_count);
3994
    eval { $opac_sug_count = $dbh->do("SELECT 1 FROM authorised_values WHERE category='OPAC_SUG'"); };
3995
    if ($opac_sug_count == 0) {
3996
        $dbh->do("INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged')");
3997
        $dbh->do("INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author')");
3998
    }
3999
4000
    print "Upgrade to $DBversion done: Adding some default authorized values in the OPAC_SUG category for patrons to select when submitting a suggestion (Bug 1883)\n";
4001
    SetVersion ($DBversion);
4002
}
4003
3990
=head1 FUNCTIONS
4004
=head1 FUNCTIONS
3991
4005
3992
=head2 DropAllForeignKeys($table)
4006
=head2 DropAllForeignKeys($table)
3993
- 

Return to bug 1883