AiDOPWarehouse/doc/db/mdp/qms_add_tenant_id_d4.sql

-- WP0-D4 / P-016: add tenant_id to all qms_* tables (idempotent pattern)
-- Default backfill tenant: 1300000000001
-- Prefer running companion Python: qms_add_tenant_id_d4.py
--
-- Example per table (repeat for each qms_* without tenant_id):
-- ALTER TABLE `qms_qcp_inspbill`
--   ADD COLUMN `tenant_id` BIGINT NOT NULL DEFAULT 1300000000001 COMMENT 'tenant_id WP0-D4' AFTER `id`;
-- CREATE INDEX `idx_qms_qcp_inspbill_tenant` ON `qms_qcp_inspbill` (`tenant_id`);

-- Tables in aidopdev (2026-07-23 inventory, all had no tenant_id):
-- qms_fqcbj, qms_fqcjygf, qms_fqcjygfzb, qms_gcjyd, qms_gcjydzb, qms_gcjygf, qms_gcjygfzb,
-- qms_inspeccrit_entry, qms_inspection_method, qms_inspectioncrit, qms_inspectionfreq,
-- qms_inspectioninstru, qms_inspectionitems, qms_inspectionstd, qms_inspectionstdentry,
-- qms_inspectpro, qms_inspro_ent, qms_jygf, qms_jygfzb, qms_lymjbmd, qms_oqcjygf, qms_oqcjygfzb,
-- qms_qcp_insappnentry, qms_qcp_inspbill, qms_qcp_inspecapplyn, qms_qcpp_inspbill,
-- qms_qcpp_inspbillst, qms_quality_base_type, qms_sampscheme