Files
opensourcepos/app/Database/Migrations/sqlscripts/3.3.0_indiagst1.sql
2024-06-15 17:19:15 +02:00

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 '';