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

(-)a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql (-1 / +1 lines)
Lines 1-7 Link Here
1
insert into `message_attributes`
1
insert into `message_attributes`
2
(`message_attribute_id`, message_name, `takes_days`)
2
(`message_attribute_id`, message_name, `takes_days`)
3
values
3
values
4
(1, 'Item DUE', 0),
4
(1, 'Item Due', 0),
5
(2, 'Advance Notice', 1),
5
(2, 'Advance Notice', 1),
6
(3, 'Upcoming Events', 1),
6
(3, 'Upcoming Events', 1),
7
(4, 'Hold Filled', 0),
7
(4, 'Hold Filled', 0),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 2695-2700 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
2695
	SetVersion ($DBversion);
2695
	SetVersion ($DBversion);
2696
}
2696
}
2697
2697
2698
$DBversion = 'XXX';
2699
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
2700
    $dbh->do("UPDATE `message_attributes` SET message_name='Item Due' WHERE message_attribute_id=1");
2701
	print "Upgrade to $DBversion done ( fix capitalization in message type )\n";
2702
    SetVersion ($DBversion);
2703
}
2704
2698
=item DropAllForeignKeys($table)
2705
=item DropAllForeignKeys($table)
2699
2706
2700
  Drop all foreign keys of the table $table
2707
  Drop all foreign keys of the table $table
2701
- 

Return to bug 3670