| 1234567891011121314151617181920 |
- -- 商户设备绑定测试台账，可重复执行。
- -- 测试设备均由超级管理员（ID 1）管理，初始未绑定商户。
- INSERT IGNORE INTO `sa_device` (
- `goods_name`, `goods_type`, `goods_sn`, `device_code`, `model`, `status`,
- `belong_agent_id`, `manage_agent_id`, `is_locked`, `is_active`, `device_status`,
- `created_by`, `updated_by`, `create_time`, `update_time`, `delete_time`
- ) VALUES
- ('车载充电器', 107, 'TEST-VEHICLE-0001', '860521080428701', 'VEHICLE-V1', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('车载充电器', 107, 'TEST-VEHICLE-0002', '860521080428702', 'VEHICLE-V1', 1, 1, 1, 0, 0, 0, 1, 1, NOW(), NOW(), NULL),
- ('K霸宝', 100, 'TEST-KBATTERY-0001', 'KB000001', 'KB-PRO', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('K霸宝 Blue', 102, 'TEST-KBATTERY-0002', 'KB000002', 'KB-BLUE', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('共享充电宝', 101, 'TEST-POWER-0001', 'PB000001', 'PB-8', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('共享充电宝', 101, 'TEST-POWER-0002', 'PB000002', 'PB-12', 1, 1, 1, 0, 0, 0, 1, 1, NOW(), NOW(), NULL),
- ('密码线充', 103, 'TEST-PASSWORD-0001', 'PL000001', 'LINE-PASS', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('密码线充', 103, 'TEST-PASSWORD-0002', 'PL000002', 'LINE-PASS', 2, 1, 1, 0, 0, 2, 1, 1, NOW(), NOW(), NULL),
- ('蓝牙线充', 104, 'TEST-BLUETOOTH-0001', 'BL000001', 'LINE-BT', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('蓝牙线充', 104, 'TEST-BLUETOOTH-0002', 'BL000002', 'LINE-BT', 1, 1, 1, 0, 0, 0, 1, 1, NOW(), NOW(), NULL),
- ('密码蓝牙线充', 105, 'TEST-PASSBT-0001', 'PBL000001', 'LINE-PASS-BT', 1, 1, 1, 0, 0, 1, 1, 1, NOW(), NOW(), NULL),
- ('密码蓝牙线充', 105, 'TEST-PASSBT-0002', 'PBL000002', 'LINE-PASS-BT', 0, 1, 1, 0, 0, 0, 1, 1, NOW(), NOW(), NULL);
|
