mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2025-12-30 21:17:55 -05:00
7 lines
169 B
SQL
7 lines
169 B
SQL
UPDATE `ospos_suppliers`
|
|
SET `tax_id` = ''
|
|
WHERE `tax_id` IS NULL;
|
|
|
|
ALTER TABLE `ospos_suppliers`
|
|
CHANGE COLUMN `tax_id` `tax_id` varchar(32) NOT NULL DEFAULT '';
|