5 description => "Add type option to vendors",
8 my ($dbh, $out) = @$args{qw(dbh out)};
9 unless( column_exists('aqbooksellers','type') ){
11 ALTER TABLE aqbooksellers ADD COLUMN type varchar(255) DEFAULT NULL AFTER accountnumber
13 say $out "Added type column to aqbooksellers";
16 INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('VENDOR_TYPE', 1);
18 say $out "Added VENDOR_TYPE authorised value category";