1 $DBversion = 'XXX'; # will be replaced by the RM
2 if ( CheckVersion($DBversion) ) {
4 if ( column_exists( 'accountlines', 'accounttype' ) ) {
7 ALTER TABLE `accountlines`
8 CHANGE COLUMN `accounttype`
9 `accounttype` varchar(16) DEFAULT NULL;
18 accounttype = 'OVERDUE',
28 accounttype = 'OVERDUE',
38 accounttype = 'OVERDUE',
43 SetVersion($DBversion);
44 print "Upgrade to $DBversion done (Bug 22521 - Update accountlines.accounttype to varchar(16), and map new statuses)\n";