1 $DBversion = 'XXX'; # will be replaced by the RM
2 if ( CheckVersion($DBversion) ) {
15 `account_offset_types`
17 type = 'OVERDUE_INCREASE'
19 type = 'fine_increase';
24 `account_offset_types`
26 type = 'OVERDUE_DECREASE'
28 type = 'fine_decrease';
31 if ( column_exists( 'accountlines', 'accounttype' ) ) {
34 ALTER TABLE `accountlines`
35 CHANGE COLUMN `accounttype`
36 `accounttype` varchar(16) DEFAULT NULL;
45 accounttype = 'OVERDUE',
55 accounttype = 'OVERDUE',
65 accounttype = 'OVERDUE',
70 SetVersion($DBversion);
71 print "Upgrade to $DBversion done (Bug 22521 - Update accountlines.accounttype to varchar(16), and map new statuses)\n";