AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.562.verify.sql

-- 1.0.562.verify.sql · 中立标准层建表与补列（单列 ok：1=通过）
SELECT CASE WHEN
    (SELECT COUNT(*) FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = DATABASE()
        AND TABLE_NAME IN (
          'mdp_std_work_order_line','mdp_std_work_order_bom',
          'mdp_std_employee','mdp_std_inventory_balance_monthly')) = 4
AND (SELECT COUNT(*) FROM information_schema.COLUMNS
      WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'mdp_std_inv_trans'
        AND COLUMN_NAME IN ('biz_doc_type','src_biz_doc_type_raw','src_trans_type_raw',
                            'approved_time','approved_flag','void_flag','summary_flag','ref_task_no')) = 8
AND (SELECT COUNT(*) FROM information_schema.STATISTICS
      WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'mdp_std_work_order_schedule'
        AND INDEX_NAME = 'uk_std_wo_sched_type') > 0
AND (SELECT COUNT(*) FROM information_schema.COLUMNS
      WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'mdp_std_s6_report'
        AND COLUMN_NAME = 'start_work_date') = 1
AND (SELECT COUNT(*) FROM information_schema.COLUMNS
      WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'mdp_std_fqc_task'
        AND COLUMN_NAME IN ('sales_order_no','sales_order_line','apply_flag')) = 3
THEN 1 ELSE 0 END AS ok;