AiDOPWarehouse/doc/migrations/2026-09-02_workordtemp_add_tenant_id.sql

-- WorkOrdTemp 补 tenant_id 列（存储过程产出的无租户中间表，需要加租户隔离）
SET @col_exists = (SELECT COUNT(1) FROM information_schema.COLUMNS
    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'WorkOrdTemp' AND COLUMN_NAME = 'tenant_id');
SET @sql = IF(@col_exists = 0,
    'ALTER TABLE WorkOrdTemp ADD COLUMN tenant_id BIGINT NULL',
    'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;