35583-vm/db/003_add_uuid_to_work_orders.sql
Flatlogic Bot 58e3bb7010 1.2
2025-11-09 03:37:51 +00:00

3 lines
129 B
SQL

ALTER TABLE work_orders ADD COLUMN uuid CHAR(36) NOT NULL;
UPDATE work_orders SET uuid = UUID() WHERE uuid IS NULL OR uuid = '';