5 description => "DB schema sync for deleteditems",
8 my ($dbh, $out) = @$args{qw(dbh out)};
10 my $sql = "ALTER TABLE deleteditems MODIFY COLUMN `stocknumber` varchar(32) default NULL"; # removes comment in db
12 if( unique_key_exists('deleteditems', 'deleteditemsstocknumberidx') ) {
13 $sql = "ALTER TABLE deleteditems DROP KEY deleteditemsstocknumberidx";
16 if( !index_exists('deleteditems', 'delitemstocknumberidx') ) {
17 $sql = "ALTER TABLE deleteditems ADD INDEX `delitemstocknumberidx` (`stocknumber`)";