1.0.352.sql 418 B

12345
  1. -- 1.0.352:清除旧节点无作用域重算残留的 tenant_id=0/1 可重建派生数据。
  2. CREATE TABLE IF NOT EXISTS `dwd_process_outsource_delivery_bak_1_0_352` LIKE `dwd_process_outsource_delivery`;
  3. INSERT IGNORE INTO `dwd_process_outsource_delivery_bak_1_0_352`
  4. SELECT * FROM `dwd_process_outsource_delivery` WHERE `tenant_id` IN (0,1);
  5. DELETE FROM `dwd_process_outsource_delivery` WHERE `tenant_id` IN (0,1);