-- 1.0.571 · F-1 来源登记、system_code、Q13 存量来源码迁移。幂等。不删行。

CREATE TABLE IF NOT EXISTS mdp_tenant_std_source (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  tenant_id BIGINT NOT NULL,
  std_object VARCHAR(48) NOT NULL COMMENT '附录 A 编码',
  source_system VARCHAR(50) NOT NULL COMMENT 'AIDOP_NATIVE/T8/DOPDEMORQ_SQLSERVER/第三方 source_code',
  source_scope VARCHAR(100) NOT NULL DEFAULT '' COMMENT 'T8=账套 ztid；165=domain；自有与第三方可空',
  remark VARCHAR(500) NULL,
  create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uk_tenant_std_source (tenant_id, std_object)
) COMMENT='租户标准对象来源登记：一租户一对象一来源';

CREATE TABLE IF NOT EXISTS mdp_tenant_std_source_log (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  tenant_id BIGINT NOT NULL,
  std_object VARCHAR(48) NOT NULL,
  old_source_system VARCHAR(50) NULL,
  new_source_system VARCHAR(50) NOT NULL,
  changed_by VARCHAR(64) NOT NULL,
  changed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  rebuild_job_id VARCHAR(64) NULL,
  KEY idx_tenant_obj (tenant_id, std_object, changed_at)
);

CREATE TABLE IF NOT EXISTS mdp_source_gate_log (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  tenant_id BIGINT NOT NULL,
  std_object VARCHAR(48) NOT NULL,
  source_system VARCHAR(50) NOT NULL,
  gate_reason VARCHAR(32) NOT NULL COMMENT 'SOURCE_NOT_REGISTERED/SOURCE_MISMATCH/POSITION_UNMAPPED/WO_NOT_FOUND',
  row_count INT NOT NULL,
  sample_keys VARCHAR(1000) NULL,
  sync_batch_id VARCHAR(64) NULL,
  create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_gate (tenant_id, std_object, create_time)
);

SET @sql := IF((SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_source' AND COLUMN_NAME='system_code')=0, 'ALTER TABLE `mdp_source` ADD COLUMN `system_code` VARCHAR(50) NULL', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

UPDATE mdp_source SET system_code = CASE source_code
  WHEN 'T8_V5_SQLSERVER' THEN 'T8'
  WHEN 'DOPDEMORQ_SQLSERVER' THEN 'DOPDEMORQ_SQLSERVER'
  WHEN 'AIDOPDEV_MYSQL' THEN 'AIDOP_NATIVE'
  ELSE source_code END
WHERE system_code IS NULL OR system_code = '';

-- Q13 存量来源码迁移。同键已有目标码的行留下。

UPDATE mdp_source_table_registry SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_action_event`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_action_event`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_action_event`.source_table AND clash.source_biz_key=`mdp_std_action_event`.source_biz_key
);

UPDATE `mdp_std_action_event`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_action_event`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_action_event`.source_table AND clash.source_biz_key=`mdp_std_action_event`.source_biz_key
);

UPDATE `mdp_std_delivery_exception` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_delivery_exception` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_delivery_exception` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_delivery_exception` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_delivery_result` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_delivery_result` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_delivery_result` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_delivery_result` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_delivery_schedule` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_delivery_schedule` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_delivery_schedule` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_delivery_schedule` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_employee` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `domain`, `employee_no` FROM `mdp_std_employee` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`domain` <=> a.`domain` AND c.`employee_no` <=> a.`employee_no`
);

UPDATE `mdp_std_employee` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `domain`, `employee_no` FROM `mdp_std_employee` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`domain` <=> a.`domain` AND c.`employee_no` <=> a.`employee_no`
);

UPDATE `mdp_std_fqc_result` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_fqc_task` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_row_id` FROM `mdp_std_fqc_task` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_row_id` <=> a.`source_row_id`
);

UPDATE `mdp_std_fqc_task` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_row_id` FROM `mdp_std_fqc_task` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_row_id` <=> a.`source_row_id`
);

UPDATE `mdp_std_inv_trans` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `src_rec_id` FROM `mdp_std_inv_trans` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`src_rec_id` <=> a.`src_rec_id`
);

UPDATE `mdp_std_inv_trans` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `src_rec_id` FROM `mdp_std_inv_trans` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`src_rec_id` <=> a.`src_rec_id`
);

UPDATE `mdp_std_inventory` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `domain`, `location`, `lot_serial`, `item_num`, `dimension1`, `dimension2`, `refs`, `site` FROM `mdp_std_inventory` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`domain` <=> a.`domain` AND c.`location` <=> a.`location` AND c.`lot_serial` <=> a.`lot_serial` AND c.`item_num` <=> a.`item_num` AND c.`dimension1` <=> a.`dimension1` AND c.`dimension2` <=> a.`dimension2` AND c.`refs` <=> a.`refs` AND c.`site` <=> a.`site`
);

UPDATE `mdp_std_inventory` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `domain`, `location`, `lot_serial`, `item_num`, `dimension1`, `dimension2`, `refs`, `site` FROM `mdp_std_inventory` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`domain` <=> a.`domain` AND c.`location` <=> a.`location` AND c.`lot_serial` <=> a.`lot_serial` AND c.`item_num` <=> a.`item_num` AND c.`dimension1` <=> a.`dimension1` AND c.`dimension2` <=> a.`dimension2` AND c.`refs` <=> a.`refs` AND c.`site` <=> a.`site`
);

UPDATE `mdp_std_inventory_balance_monthly` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `period_ym`, `category_code`, `warehouse_code`, `item_code` FROM `mdp_std_inventory_balance_monthly` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`period_ym` <=> a.`period_ym` AND c.`category_code` <=> a.`category_code` AND c.`warehouse_code` <=> a.`warehouse_code` AND c.`item_code` <=> a.`item_code`
);

UPDATE `mdp_std_inventory_balance_monthly` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `period_ym`, `category_code`, `warehouse_code`, `item_code` FROM `mdp_std_inventory_balance_monthly` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`period_ym` <=> a.`period_ym` AND c.`category_code` <=> a.`category_code` AND c.`warehouse_code` <=> a.`warehouse_code` AND c.`item_code` <=> a.`item_code`
);

UPDATE `mdp_std_ipqc_inspection` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_iqc_inspection` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_iqc_receipt_state` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_item` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_item` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_item` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_item` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_material_readiness` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_material_readiness` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_material_readiness` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_material_readiness` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_operation_schedule` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_outsource_issue` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_process_outsource_order` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_process_outsource_order` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_process_outsource_order` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `factory_id`, `source_biz_key` FROM `mdp_std_process_outsource_order` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`factory_id` <=> a.`factory_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_production_issue` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_production_receipt` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_production_return` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_purchase_order` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_purchase_order` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_purchase_order` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_purchase_order` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_purchase_order_completion` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_purchase_receipt` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_purchase_request` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_purchase_request` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_purchase_request` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_purchase_request` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_s4_iqc` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_s4_return` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_s4_shipment` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_s4_shortage` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_std_s6_report` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_s6_report` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_s6_report` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_s6_report` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_ship_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_ship_trans`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_ship_trans`.source_table AND clash.source_biz_key=`mdp_std_ship_trans`.source_biz_key
);

UPDATE `mdp_std_ship_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_ship_trans`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_ship_trans`.source_table AND clash.source_biz_key=`mdp_std_ship_trans`.source_biz_key
);

UPDATE `mdp_std_so`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_so`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_so`.source_table AND clash.source_biz_key=`mdp_std_so`.source_biz_key
);

UPDATE `mdp_std_so`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_std_so`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_std_so`.source_table AND clash.source_biz_key=`mdp_std_so`.source_biz_key
);

UPDATE `mdp_std_supplier` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supplier` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_supplier` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supplier` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_supplier_item` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supplier_item` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_supplier_item` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supplier_item` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_supply_demand` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supply_demand` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_supply_demand` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_supply_demand` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_work_order_bom` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_work_order_bom` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_work_order_bom` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_work_order_bom` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_work_order_line` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOP'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_work_order_line` WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_work_order_line` a
SET a.source_system='AIDOP_NATIVE'
WHERE a.source_system='AIDOPDEV_MYSQL'
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT `tenant_id`, `source_biz_key` FROM `mdp_std_work_order_line` WHERE source_system IN ('AIDOP_NATIVE')
  ) c
  WHERE c.`tenant_id` <=> a.`tenant_id` AND c.`source_biz_key` <=> a.`source_biz_key`
);

UPDATE `mdp_std_work_order_schedule` SET source_system='AIDOP_NATIVE' WHERE source_system IN ('AIDOP','AIDOPDEV_MYSQL');

UPDATE `mdp_stg_action_run`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_action_run`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_action_run`.source_table AND clash.source_biz_key=`mdp_stg_action_run`.source_biz_key
);

UPDATE `mdp_stg_action_run`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_action_run`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_action_run`.source_table AND clash.source_biz_key=`mdp_stg_action_run`.source_biz_key
);

UPDATE `mdp_stg_customer`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_customer`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_customer`.source_table AND clash.source_biz_key=`mdp_stg_customer`.source_biz_key
);

UPDATE `mdp_stg_customer`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_customer`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_customer`.source_table AND clash.source_biz_key=`mdp_stg_customer`.source_biz_key
);

UPDATE `mdp_stg_delivery`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_delivery`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_delivery`.source_table AND clash.source_biz_key=`mdp_stg_delivery`.source_biz_key
);

UPDATE `mdp_stg_delivery`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_delivery`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_delivery`.source_table AND clash.source_biz_key=`mdp_stg_delivery`.source_biz_key
);

UPDATE `mdp_stg_emp_duty`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_emp_duty`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_emp_duty`.source_table AND clash.source_biz_key=`mdp_stg_emp_duty`.source_biz_key
);

UPDATE `mdp_stg_emp_duty`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_emp_duty`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_emp_duty`.source_table AND clash.source_biz_key=`mdp_stg_emp_duty`.source_biz_key
);

UPDATE `mdp_stg_emp_work`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_emp_work`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_emp_work`.source_table AND clash.source_biz_key=`mdp_stg_emp_work`.source_biz_key
);

UPDATE `mdp_stg_emp_work`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_emp_work`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_emp_work`.source_table AND clash.source_biz_key=`mdp_stg_emp_work`.source_biz_key
);

UPDATE `mdp_stg_employee`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_employee`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_employee`.source_table AND clash.source_biz_key=`mdp_stg_employee`.source_biz_key
);

UPDATE `mdp_stg_employee`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_employee`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_employee`.source_table AND clash.source_biz_key=`mdp_stg_employee`.source_biz_key
);

UPDATE `mdp_stg_fqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_fqc_pull`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_fqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_fqc_pull`.source_biz_key
);

UPDATE `mdp_stg_fqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_fqc_pull`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_fqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_fqc_pull`.source_biz_key
);

UPDATE `mdp_stg_inv_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_inv_trans`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_inv_trans`.source_table AND clash.source_biz_key=`mdp_stg_inv_trans`.source_biz_key
);

UPDATE `mdp_stg_inv_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_inv_trans`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_inv_trans`.source_table AND clash.source_biz_key=`mdp_stg_inv_trans`.source_biz_key
);

UPDATE `mdp_stg_inventory`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_inventory`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_inventory`.source_table AND clash.source_biz_key=`mdp_stg_inventory`.source_biz_key
);

UPDATE `mdp_stg_inventory`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_inventory`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_inventory`.source_table AND clash.source_biz_key=`mdp_stg_inventory`.source_biz_key
);

UPDATE `mdp_stg_ipqc_inspection`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_inspection`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_inspection`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_inspection`.source_biz_key
);

UPDATE `mdp_stg_ipqc_inspection`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_inspection`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_inspection`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_inspection`.source_biz_key
);

UPDATE `mdp_stg_ipqc_inspection_detail`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_inspection_detail`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_inspection_detail`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_inspection_detail`.source_biz_key
);

UPDATE `mdp_stg_ipqc_inspection_detail`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_inspection_detail`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_inspection_detail`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_inspection_detail`.source_biz_key
);

UPDATE `mdp_stg_ipqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_pull`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_pull`.source_biz_key
);

UPDATE `mdp_stg_ipqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ipqc_pull`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ipqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_ipqc_pull`.source_biz_key
);

UPDATE `mdp_stg_iqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_iqc_pull`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_iqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_iqc_pull`.source_biz_key
);

UPDATE `mdp_stg_iqc_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_iqc_pull`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_iqc_pull`.source_table AND clash.source_biz_key=`mdp_stg_iqc_pull`.source_biz_key
);

UPDATE `mdp_stg_item`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_item`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_item`.source_table AND clash.source_biz_key=`mdp_stg_item`.source_biz_key
);

UPDATE `mdp_stg_item`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_item`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_item`.source_table AND clash.source_biz_key=`mdp_stg_item`.source_biz_key
);

UPDATE `mdp_stg_label`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_label`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_label`.source_table AND clash.source_biz_key=`mdp_stg_label`.source_biz_key
);

UPDATE `mdp_stg_label`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_label`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_label`.source_table AND clash.source_biz_key=`mdp_stg_label`.source_biz_key
);

UPDATE `mdp_stg_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line`.source_table AND clash.source_biz_key=`mdp_stg_line`.source_biz_key
);

UPDATE `mdp_stg_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line`.source_table AND clash.source_biz_key=`mdp_stg_line`.source_biz_key
);

UPDATE `mdp_stg_line_run_rest`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line_run_rest`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line_run_rest`.source_table AND clash.source_biz_key=`mdp_stg_line_run_rest`.source_biz_key
);

UPDATE `mdp_stg_line_run_rest`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line_run_rest`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line_run_rest`.source_table AND clash.source_biz_key=`mdp_stg_line_run_rest`.source_biz_key
);

UPDATE `mdp_stg_line_status`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line_status`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line_status`.source_table AND clash.source_biz_key=`mdp_stg_line_status`.source_biz_key
);

UPDATE `mdp_stg_line_status`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_line_status`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_line_status`.source_table AND clash.source_biz_key=`mdp_stg_line_status`.source_biz_key
);

UPDATE `mdp_stg_location`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_location`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_location`.source_table AND clash.source_biz_key=`mdp_stg_location`.source_biz_key
);

UPDATE `mdp_stg_location`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_location`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_location`.source_table AND clash.source_biz_key=`mdp_stg_location`.source_biz_key
);

UPDATE `mdp_stg_mobile_task`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_mobile_task`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_mobile_task`.source_table AND clash.source_biz_key=`mdp_stg_mobile_task`.source_biz_key
);

UPDATE `mdp_stg_mobile_task`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_mobile_task`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_mobile_task`.source_table AND clash.source_biz_key=`mdp_stg_mobile_task`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue_detail`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue_detail`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue_detail`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue_detail`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue_detail`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue_detail`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue_detail`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue_detail`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue_pull`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue_pull`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue_pull`.source_biz_key
);

UPDATE `mdp_stg_outsource_issue_pull`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_outsource_issue_pull`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_outsource_issue_pull`.source_table AND clash.source_biz_key=`mdp_stg_outsource_issue_pull`.source_biz_key
);

UPDATE `mdp_stg_production_issue`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_issue`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_issue`.source_table AND clash.source_biz_key=`mdp_stg_production_issue`.source_biz_key
);

UPDATE `mdp_stg_production_issue`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_issue`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_issue`.source_table AND clash.source_biz_key=`mdp_stg_production_issue`.source_biz_key
);

UPDATE `mdp_stg_production_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_receipt`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_receipt`.source_table AND clash.source_biz_key=`mdp_stg_production_receipt`.source_biz_key
);

UPDATE `mdp_stg_production_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_receipt`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_receipt`.source_table AND clash.source_biz_key=`mdp_stg_production_receipt`.source_biz_key
);

UPDATE `mdp_stg_production_return`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_return`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_return`.source_table AND clash.source_biz_key=`mdp_stg_production_return`.source_biz_key
);

UPDATE `mdp_stg_production_return`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_production_return`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_production_return`.source_table AND clash.source_biz_key=`mdp_stg_production_return`.source_biz_key
);

UPDATE `mdp_stg_purchase_order`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_purchase_order`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_purchase_order`.source_table AND clash.source_biz_key=`mdp_stg_purchase_order`.source_biz_key
);

UPDATE `mdp_stg_purchase_order`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_purchase_order`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_purchase_order`.source_table AND clash.source_biz_key=`mdp_stg_purchase_order`.source_biz_key
);

UPDATE `mdp_stg_purchase_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_purchase_receipt`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_purchase_receipt`.source_table AND clash.source_biz_key=`mdp_stg_purchase_receipt`.source_biz_key
);

UPDATE `mdp_stg_purchase_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_purchase_receipt`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_purchase_receipt`.source_table AND clash.source_biz_key=`mdp_stg_purchase_receipt`.source_biz_key
);

UPDATE `mdp_stg_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_receipt`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_receipt`.source_table AND clash.source_biz_key=`mdp_stg_receipt`.source_biz_key
);

UPDATE `mdp_stg_receipt`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_receipt`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_receipt`.source_table AND clash.source_biz_key=`mdp_stg_receipt`.source_biz_key
);

UPDATE `mdp_stg_s0_customer`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_customer`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_customer`.source_table AND clash.source_biz_key=`mdp_stg_s0_customer`.source_biz_key
);

UPDATE `mdp_stg_s0_customer`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_customer`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_customer`.source_table AND clash.source_biz_key=`mdp_stg_s0_customer`.source_biz_key
);

UPDATE `mdp_stg_s0_department`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_department`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_department`.source_table AND clash.source_biz_key=`mdp_stg_s0_department`.source_biz_key
);

UPDATE `mdp_stg_s0_department`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_department`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_department`.source_table AND clash.source_biz_key=`mdp_stg_s0_department`.source_biz_key
);

UPDATE `mdp_stg_s0_emp_work_duty`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_emp_work_duty`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_emp_work_duty`.source_table AND clash.source_biz_key=`mdp_stg_s0_emp_work_duty`.source_biz_key
);

UPDATE `mdp_stg_s0_emp_work_duty`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_emp_work_duty`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_emp_work_duty`.source_table AND clash.source_biz_key=`mdp_stg_s0_emp_work_duty`.source_biz_key
);

UPDATE `mdp_stg_s0_employee`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_employee`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_employee`.source_table AND clash.source_biz_key=`mdp_stg_s0_employee`.source_biz_key
);

UPDATE `mdp_stg_s0_employee`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_employee`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_employee`.source_table AND clash.source_biz_key=`mdp_stg_s0_employee`.source_biz_key
);

UPDATE `mdp_stg_s0_item`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item`.source_table AND clash.source_biz_key=`mdp_stg_s0_item`.source_biz_key
);

UPDATE `mdp_stg_s0_item`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item`.source_table AND clash.source_biz_key=`mdp_stg_s0_item`.source_biz_key
);

UPDATE `mdp_stg_s0_item_bom`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_bom`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_bom`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_bom`.source_biz_key
);

UPDATE `mdp_stg_s0_item_bom`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_bom`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_bom`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_bom`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_condition`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_condition`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_condition`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_condition`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_condition`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_condition`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_condition`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_condition`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_image`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_image`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_image`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_image`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_image`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_image`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_image`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_image`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_line`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_line`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_line`.source_biz_key
);

UPDATE `mdp_stg_s0_item_op_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_op_line`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_op_line`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_op_line`.source_biz_key
);

UPDATE `mdp_stg_s0_item_routing_op`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_routing_op`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_routing_op`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_routing_op`.source_biz_key
);

UPDATE `mdp_stg_s0_item_routing_op`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_routing_op`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_routing_op`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_routing_op`.source_biz_key
);

UPDATE `mdp_stg_s0_item_substitute`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_substitute`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_substitute`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_substitute`.source_biz_key
);

UPDATE `mdp_stg_s0_item_substitute`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_item_substitute`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_item_substitute`.source_table AND clash.source_biz_key=`mdp_stg_s0_item_substitute`.source_biz_key
);

UPDATE `mdp_stg_s0_label_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_label_type`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_label_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_label_type`.source_biz_key
);

UPDATE `mdp_stg_s0_label_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_label_type`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_label_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_label_type`.source_biz_key
);

UPDATE `mdp_stg_s0_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_line`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_line`.source_table AND clash.source_biz_key=`mdp_stg_s0_line`.source_biz_key
);

UPDATE `mdp_stg_s0_line`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_line`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_line`.source_table AND clash.source_biz_key=`mdp_stg_s0_line`.source_biz_key
);

UPDATE `mdp_stg_s0_line_post`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_line_post`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_line_post`.source_table AND clash.source_biz_key=`mdp_stg_s0_line_post`.source_biz_key
);

UPDATE `mdp_stg_s0_line_post`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_line_post`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_line_post`.source_table AND clash.source_biz_key=`mdp_stg_s0_line_post`.source_biz_key
);

UPDATE `mdp_stg_s0_location`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_location`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_location`.source_table AND clash.source_biz_key=`mdp_stg_s0_location`.source_biz_key
);

UPDATE `mdp_stg_s0_location`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_location`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_location`.source_table AND clash.source_biz_key=`mdp_stg_s0_location`.source_biz_key
);

UPDATE `mdp_stg_s0_person_skill`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_person_skill`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_person_skill`.source_table AND clash.source_biz_key=`mdp_stg_s0_person_skill`.source_biz_key
);

UPDATE `mdp_stg_s0_person_skill`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_person_skill`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_person_skill`.source_table AND clash.source_biz_key=`mdp_stg_s0_person_skill`.source_biz_key
);

UPDATE `mdp_stg_s0_qms_dict`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_qms_dict`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_qms_dict`.source_table AND clash.source_biz_key=`mdp_stg_s0_qms_dict`.source_biz_key
);

UPDATE `mdp_stg_s0_qms_dict`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_qms_dict`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_qms_dict`.source_table AND clash.source_biz_key=`mdp_stg_s0_qms_dict`.source_biz_key
);

UPDATE `mdp_stg_s0_quality_base_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_quality_base_type`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_quality_base_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_quality_base_type`.source_biz_key
);

UPDATE `mdp_stg_s0_quality_base_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_quality_base_type`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_quality_base_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_quality_base_type`.source_biz_key
);

UPDATE `mdp_stg_s0_sop_file_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_sop_file_type`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_sop_file_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_sop_file_type`.source_biz_key
);

UPDATE `mdp_stg_s0_sop_file_type`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_sop_file_type`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_sop_file_type`.source_table AND clash.source_biz_key=`mdp_stg_s0_sop_file_type`.source_biz_key
);

UPDATE `mdp_stg_s0_supplier`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_supplier`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_supplier`.source_table AND clash.source_biz_key=`mdp_stg_s0_supplier`.source_biz_key
);

UPDATE `mdp_stg_s0_supplier`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_supplier`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_supplier`.source_table AND clash.source_biz_key=`mdp_stg_s0_supplier`.source_biz_key
);

UPDATE `mdp_stg_s0_work_center`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_work_center`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_work_center`.source_table AND clash.source_biz_key=`mdp_stg_s0_work_center`.source_biz_key
);

UPDATE `mdp_stg_s0_work_center`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s0_work_center`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s0_work_center`.source_table AND clash.source_biz_key=`mdp_stg_s0_work_center`.source_biz_key
);

UPDATE `mdp_stg_s4_iqc`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_iqc`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_iqc`.source_table AND clash.source_biz_key=`mdp_stg_s4_iqc`.source_biz_key
);

UPDATE `mdp_stg_s4_iqc`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_iqc`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_iqc`.source_table AND clash.source_biz_key=`mdp_stg_s4_iqc`.source_biz_key
);

UPDATE `mdp_stg_s4_return`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_return`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_return`.source_table AND clash.source_biz_key=`mdp_stg_s4_return`.source_biz_key
);

UPDATE `mdp_stg_s4_return`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_return`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_return`.source_table AND clash.source_biz_key=`mdp_stg_s4_return`.source_biz_key
);

UPDATE `mdp_stg_s4_shipment`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_shipment`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_shipment`.source_table AND clash.source_biz_key=`mdp_stg_s4_shipment`.source_biz_key
);

UPDATE `mdp_stg_s4_shipment`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_shipment`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_shipment`.source_table AND clash.source_biz_key=`mdp_stg_s4_shipment`.source_biz_key
);

UPDATE `mdp_stg_s4_shortage`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_shortage`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_shortage`.source_table AND clash.source_biz_key=`mdp_stg_s4_shortage`.source_biz_key
);

UPDATE `mdp_stg_s4_shortage`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s4_shortage`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s4_shortage`.source_table AND clash.source_biz_key=`mdp_stg_s4_shortage`.source_biz_key
);

UPDATE `mdp_stg_s6_report`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s6_report`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s6_report`.source_table AND clash.source_biz_key=`mdp_stg_s6_report`.source_biz_key
);

UPDATE `mdp_stg_s6_report`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_s6_report`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_s6_report`.source_table AND clash.source_biz_key=`mdp_stg_s6_report`.source_biz_key
);

UPDATE `mdp_stg_schedule`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_schedule`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_schedule`.source_table AND clash.source_biz_key=`mdp_stg_schedule`.source_biz_key
);

UPDATE `mdp_stg_schedule`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_schedule`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_schedule`.source_table AND clash.source_biz_key=`mdp_stg_schedule`.source_biz_key
);

UPDATE `mdp_stg_ship_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ship_trans`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ship_trans`.source_table AND clash.source_biz_key=`mdp_stg_ship_trans`.source_biz_key
);

UPDATE `mdp_stg_ship_trans`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_ship_trans`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_ship_trans`.source_table AND clash.source_biz_key=`mdp_stg_ship_trans`.source_biz_key
);

UPDATE `mdp_stg_so`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_so`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_so`.source_table AND clash.source_biz_key=`mdp_stg_so`.source_biz_key
);

UPDATE `mdp_stg_so`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_so`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_so`.source_table AND clash.source_biz_key=`mdp_stg_so`.source_biz_key
);

UPDATE `mdp_stg_source_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_source_list`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_source_list`.source_table AND clash.source_biz_key=`mdp_stg_source_list`.source_biz_key
);

UPDATE `mdp_stg_source_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_source_list`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_source_list`.source_table AND clash.source_biz_key=`mdp_stg_source_list`.source_biz_key
);

UPDATE `mdp_stg_supplier`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_supplier`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_supplier`.source_table AND clash.source_biz_key=`mdp_stg_supplier`.source_biz_key
);

UPDATE `mdp_stg_supplier`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_supplier`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_supplier`.source_table AND clash.source_biz_key=`mdp_stg_supplier`.source_biz_key
);

UPDATE `mdp_stg_supply_demand`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_supply_demand`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_supply_demand`.source_table AND clash.source_biz_key=`mdp_stg_supply_demand`.source_biz_key
);

UPDATE `mdp_stg_supply_demand`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_supply_demand`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_supply_demand`.source_table AND clash.source_biz_key=`mdp_stg_supply_demand`.source_biz_key
);

UPDATE `mdp_stg_t8_cj_bg_head_rep`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_cj_bg_head_rep`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_cj_bg_head_rep`.source_table AND clash.source_biz_key=`mdp_stg_t8_cj_bg_head_rep`.source_biz_key
);

UPDATE `mdp_stg_t8_cj_bg_head_rep`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_cj_bg_head_rep`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_cj_bg_head_rep`.source_table AND clash.source_biz_key=`mdp_stg_t8_cj_bg_head_rep`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_head`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_head`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_head`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_head`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_head`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_head`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_head`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_head`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_list`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_list`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_list`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_list`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_list_cllist`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_list_cllist`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_list_cllist`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_list_cllist`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_dd_list_cllist`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_dd_list_cllist`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_dd_list_cllist`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_dd_list_cllist`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_tz_head`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_tz_head`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_tz_head`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_tz_head`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_tz_head`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_tz_head`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_tz_head`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_tz_head`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_tz_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_tz_list`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_tz_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_tz_list`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_tz_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_tz_list`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_tz_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_tz_list`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_zj_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_zj_list`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_zj_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_zj_list`.source_biz_key
);

UPDATE `mdp_stg_t8_kc_zj_list`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_kc_zj_list`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_kc_zj_list`.source_table AND clash.source_biz_key=`mdp_stg_t8_kc_zj_list`.source_biz_key
);

UPDATE `mdp_stg_t8_sys_pelist`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_sys_pelist`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_sys_pelist`.source_table AND clash.source_biz_key=`mdp_stg_t8_sys_pelist`.source_biz_key
);

UPDATE `mdp_stg_t8_sys_pelist`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_t8_sys_pelist`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_t8_sys_pelist`.source_table AND clash.source_biz_key=`mdp_stg_t8_sys_pelist`.source_biz_key
);

UPDATE `mdp_stg_work_order_material`
SET source_system='AIDOP_NATIVE'
WHERE source_system='AIDOP' AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_work_order_material`
    WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_work_order_material`.source_table AND clash.source_biz_key=`mdp_stg_work_order_material`.source_biz_key
);

UPDATE `mdp_stg_work_order_material`
SET source_system='AIDOP_NATIVE'
WHERE source_system IN ('AIDOPDEV_MYSQL','AIDOP_NATIVE') AND source_biz_key IS NOT NULL
AND NOT EXISTS (
  SELECT 1 FROM (
    SELECT source_table, source_biz_key FROM `mdp_stg_work_order_material`
    WHERE source_system='AIDOP_NATIVE' AND source_biz_key IS NOT NULL
  ) clash
  WHERE clash.source_table=`mdp_stg_work_order_material`.source_table AND clash.source_biz_key=`mdp_stg_work_order_material`.source_biz_key
);


SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_work_order_line')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_work_order_line' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_work_order_line` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_work_order_bom')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_work_order_bom' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_work_order_bom` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_employee')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_employee' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_employee` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_s6_report')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_s6_report' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_s6_report` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_fqc_task')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_fqc_task' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_fqc_task` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;

SET @sql := IF((SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_inventory_balance_monthly')>0 AND (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_inventory_balance_monthly' AND COLUMN_NAME='written_by')=0, 'ALTER TABLE `mdp_std_inventory_balance_monthly` ADD COLUMN `written_by` VARCHAR(32) NOT NULL DEFAULT ''LEGACY_UNVERIFIED''', 'DO 0');
PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;


INSERT IGNORE INTO mdp_tenant_std_source (tenant_id, std_object, source_system, source_scope, remark) VALUES
(797403760988229,'INV_TRANS','T8','pbxfxp','Q5 模式二'),
(797403760988229,'WO_LINE_PROD','T8','pbxfxp','Q5 模式二'),
(797403760988229,'WO_LINE_SALES','T8','pbxfxp','Q5 模式二'),
(797403760988229,'WO_BOM','T8','pbxfxp','Q5 模式二'),
(797403760988229,'EMPLOYEE','T8','pbxfxp','Q5 模式二'),
(797403760988229,'INV_BAL_MONTHLY','T8','pbxfxp','Q5 模式二'),
(797403760988229,'S6_REPORT','T8','pbxfxp','Q5 模式二'),
(797403760988229,'FQC_TASK','T8','pbxfxp','Q5 模式二'),
(797403760988229,'SO','AIDOP_NATIVE','','Q5 模式二 S1 自有'),
(797403760988229,'WO_SCHEDULE','AIDOP_NATIVE','','Q5 模式二 S2 自有'),
(797403760988229,'SUPPLY_DEMAND','AIDOP_NATIVE','','Q5 模式二 S3 自有'),
(797403760988229,'PURCHASE','AIDOP_NATIVE','','Q5 模式二 S3 自有'),
(797403760988229,'SUPPLIER_DELIVERY','AIDOP_NATIVE','','Q5 模式二 S4 自有'),
(797403760988229,'MASTER_ITEM','AIDOP_NATIVE','','Q5 模式二 S0 自有'),
(838257186181189,'INV_TRANS','DOPDEMORQ_SQLSERVER','8010','Q12 模式一'),
(838257186181189,'S6_REPORT','DOPDEMORQ_SQLSERVER','8010','Q12 模式一'),
(838257186181189,'FQC_TASK','DOPDEMORQ_SQLSERVER','8010','Q12 模式一'),
(838257186181189,'INV_BAL_MONTHLY','DOPDEMORQ_SQLSERVER','8010','Q12 模式一；A-6 不支持时仍保留登记'),
(838257186181189,'WO_LINE_PROD','AIDOP_NATIVE','','Q12 模式一自有工单'),
(838257186181189,'WO_LINE_SALES','AIDOP_NATIVE','','Q12 模式一自有订单'),
(838257186181189,'WO_BOM','AIDOP_NATIVE','','Q12 模式一自有 BOM'),
(838257186181189,'EMPLOYEE','AIDOP_NATIVE','','Q12 模式一员工权威在 S0'),
(838257186181189,'SO','AIDOP_NATIVE','','Q12'),
(838257186181189,'WO_SCHEDULE','AIDOP_NATIVE','','Q12'),
(838257186181189,'SUPPLY_DEMAND','AIDOP_NATIVE','','Q12'),
(838257186181189,'PURCHASE','AIDOP_NATIVE','','Q12'),
(838257186181189,'SUPPLIER_DELIVERY','AIDOP_NATIVE','','Q12'),
(838257186181189,'MASTER_ITEM','AIDOP_NATIVE','','Q12'),
(797403760988229,'INV_SNAPSHOT','DOPDEMORQ_SQLSERVER','8010','未预置对象：现网主来源 53236 行 DOPDEMORQ，T8 快照 0 行'),
(838257186181189,'INV_SNAPSHOT','DOPDEMORQ_SQLSERVER','8010','未预置对象：现网主来源 50364 行 DOPDEMORQ'),
(797403760988229,'IQC','AIDOP_NATIVE','','未预置对象：现网 9 行 source_system=AIDOP，迁为 AIDOP_NATIVE'),
(838257186181189,'IQC','AIDOP_NATIVE','','未预置对象：现网 11 行 source_system=AIDOP，迁为 AIDOP_NATIVE'),
(797403760988229,'IPQC','AIDOP_NATIVE','','未预置对象：该租户现网 0 行，写入方为自有通道'),
(838257186181189,'IPQC','AIDOP_NATIVE','','未预置对象：AIDOP 2 行 + AIDOPDEV_MYSQL 5 行，归一后均为自有'),
(797403760988229,'PROD_DOC','AIDOP_NATIVE','','未预置对象：现网 0 行，生产单据投影写 AIDOP_NATIVE'),
(838257186181189,'PROD_DOC','AIDOP_NATIVE','','未预置对象：现网 0 行，生产单据投影写 AIDOP_NATIVE'),
(797403760988229,'OUTSOURCE','AIDOP_NATIVE','','未预置对象：现网 0 行，外协投影写自有通道'),
(838257186181189,'OUTSOURCE','AIDOP_NATIVE','','未预置对象：现网 0 行，外协投影写自有通道'),
(797403760988229,'ACTION_EVENT','AIDOP_NATIVE','','未预置对象：该租户现网 0 行，S1 自有'),
(838257186181189,'ACTION_EVENT','AIDOP_NATIVE','','未预置对象：现网 75 行 AIDOPDEV_MYSQL，归一为自有'),
(797403760988229,'SUPPLIER','DOPDEMORQ_SQLSERVER','8010','未预置对象：现网主来源 3185 行 DOPDEMORQ，自有 0 行'),
(838257186181189,'SUPPLIER','AIDOP_NATIVE','','未预置对象：现网主来源 AIDOP 13 行，DOPDEMORQ 1 行');

INSERT INTO mdp_tenant_std_source_log (tenant_id, std_object, old_source_system, new_source_system, changed_by)
SELECT s.tenant_id, s.std_object, NULL, s.source_system, '1.0.571'
FROM mdp_tenant_std_source s
WHERE NOT EXISTS (
  SELECT 1 FROM mdp_tenant_std_source_log l
  WHERE l.tenant_id=s.tenant_id AND l.std_object=s.std_object AND l.changed_by='1.0.571'
);