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

-- 1.0.571.verify.sql
SELECT COUNT(*) = 3
  FROM information_schema.tables
 WHERE table_schema = DATABASE()
   AND table_name IN ('mdp_tenant_std_source','mdp_tenant_std_source_log','mdp_source_gate_log');

SELECT COUNT(*) = 1
  FROM information_schema.statistics
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_tenant_std_source'
   AND index_name = 'uk_tenant_std_source'
   AND column_name = 'std_object';

SELECT COUNT(*) = 1
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_source'
   AND column_name = 'system_code';

SELECT COUNT(*) = 8
  FROM mdp_tenant_std_source
 WHERE tenant_id = 797403760988229
   AND source_system = 'T8'
   AND std_object IN ('INV_TRANS','WO_LINE_PROD','WO_LINE_SALES','WO_BOM','EMPLOYEE','INV_BAL_MONTHLY','S6_REPORT','FQC_TASK');

SELECT COUNT(*) = 4
  FROM mdp_tenant_std_source
 WHERE tenant_id = 838257186181189
   AND source_system = 'DOPDEMORQ_SQLSERVER'
   AND std_object IN ('INV_TRANS','S6_REPORT','FQC_TASK','INV_BAL_MONTHLY');

SELECT (SELECT system_code FROM mdp_source WHERE source_code = 'T8_V5_SQLSERVER') = 'T8';
SELECT (SELECT system_code FROM mdp_source WHERE source_code = 'AIDOPDEV_MYSQL') = 'AIDOP_NATIVE';
SELECT (SELECT system_code FROM mdp_source WHERE source_code = 'DOPDEMORQ_SQLSERVER') = 'DOPDEMORQ_SQLSERVER';
SELECT (SELECT system_code FROM mdp_source WHERE source_code = 'QMS_API') = 'QMS_API';

SELECT COUNT(*) = 0 FROM mdp_std_so WHERE source_system = 'AIDOP';

SELECT COUNT(*) = 6
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND column_name = 'written_by'
   AND table_name IN (
     'mdp_std_work_order_line','mdp_std_work_order_bom','mdp_std_employee',
     'mdp_std_s6_report','mdp_std_fqc_task','mdp_std_inventory_balance_monthly');

SELECT COUNT(*) = 42
  FROM mdp_tenant_std_source
 WHERE tenant_id IN (797403760988229, 838257186181189);

SELECT COUNT(*) = 0
  FROM mdp_tenant_std_source
 WHERE tenant_id NOT IN (797403760988229, 838257186181189);