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 |
- |
|
|