AiDOPWarehouse/doc/migrations/2026-04-17_aidopdev_demo_item_cust.sql

-- aidopdev：演示用物料 / 客户各 1 条（与后端 Database.json 中库名一致）
-- 原因说明：若仅在其它库（如 dopdemo）插入，在 aidopdev 连接下看不到数据。
-- 执行：mysql -h HOST -P 3306 -u USER -p aidopdev < 2026-04-17_aidopdev_demo_item_cust.sql

INSERT INTO ItemMaster (
  company_ref_id, factory_ref_id, ItemNum, Descr,
  KeyItem, Inspect, IssuePolicy, AutoLotNums, Install, LotSerialControl, AllocateSingleLot,
  Status, TraceDetail, IsMainMas, IsActive, IsConfirm, CreateTime, cust_supplied
)
SELECT
  0, 0, 'AIDOP-DEMO-001', 'AiDOP演示物料-001',
  0, 1, 0, 0, 0, 0, 0,
  'A', 0, 0, 1, 1, NOW(), 0
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ItemMaster WHERE ItemNum = 'AIDOP-DEMO-001' LIMIT 1);

INSERT INTO CustMaster (company_ref_id, factory_ref_id, Cust, TaxIn, IsActive, IsConfirm, CreateTime, SortName)
SELECT 0, 0, 'AIDOP-DEMO-C1', 0, 1, 1, NOW(), 'AiDOP演示客户'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM CustMaster WHERE Cust = 'AIDOP-DEMO-C1' LIMIT 1);