1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 for my $column ( qw(othersupplier booksellerfax booksellerurl bookselleremail currency) ) {
5 if( column_exists( 'aqbooksellers', $column ) ) {
6 my ($count) = $dbh->selectrow_array(qq|
9 WHERE $column IS NOT NULL AND $column <> ""
12 warn "Warning - Cannot remove column aqbooksellers.$column. At least one value exists";
15 ALTER TABLE aqbooksellers
22 SetVersion( $DBversion );
23 print "Upgrade to $DBversion done (Bug 18177 - Remove some unused columns from aqbooksellers)\n";