1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 $dbh->do(q|DROP TABLE IF EXISTS notifys|);
6 if( column_exists( 'accountlines', 'notify_id' ) ) {
7 $dbh->do(q|ALTER TABLE accountlines DROP COLUMN notify_id|);
8 $dbh->do(q|ALTER TABLE accountlines DROP COLUMN notify_level|);
11 # Always end with this (adjust the bug info)
12 SetVersion( $DBversion );
13 print "Upgrade to $DBversion done (Bug 10021 - Drop notifys-related table and columns)\n";