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