| | |
| | | |
| | | -- 用户 |
| | | INSERT INTO `tcm_app_user` |
| | | (`id`, `nickname`, `phone`, `avatar`, `wechat_openid`, `wechat_nickname`, `wechat_avatar`, `wechat_bound_at`, `type`, `gender`, `age`, `intro`, `status`, `clinic_id`, `member_expire_at`, `deleted`, `created_by`, `updated_by`) |
| | | (`id`, `nickname`, `phone`, `avatar`, `wechat_openid`, `wechat_nickname`, `wechat_avatar`, `wechat_bound_at`, `apple_user_identifier`, `apple_identity_subject`, `apple_bound_at`, `type`, `gender`, `age`, `intro`, `status`, `clinic_id`, `member_expire_at`, `deleted`, `created_by`, `updated_by`) |
| | | VALUES |
| | | (9001, '岐黄学员A', '13900000001', 'https://example.com/mock/avatar-9001.png', 'mock_openid_9001', '岐黄学员A', 'https://example.com/mock/wx-9001.png', '2026-03-01 09:00:00', 1, 1, 32, '积分兑换 mock 用户 A', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9002, '岐黄学员B', '13900000002', 'https://example.com/mock/avatar-9002.png', 'mock_openid_9002', '岐黄学员B', 'https://example.com/mock/wx-9002.png', '2026-03-02 09:00:00', 0, 0, 29, '积分兑换 mock 用户 B', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9003, '岐黄学员C', '13900000003', 'https://example.com/mock/avatar-9003.png', 'mock_openid_9003', '岐黄学员C', 'https://example.com/mock/wx-9003.png', '2026-03-03 09:00:00', 1, 1, 35, '积分兑换 mock 用户 C', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9004, '岐黄学员D', '13900000004', 'https://example.com/mock/avatar-9004.png', 'mock_openid_9004', '岐黄学员D', 'https://example.com/mock/wx-9004.png', '2026-03-04 09:00:00', 0, 0, 27, '积分兑换 mock 用户 D', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9005, '岐黄学员E', '13900000005', 'https://example.com/mock/avatar-9005.png', 'mock_openid_9005', '岐黄学员E', 'https://example.com/mock/wx-9005.png', '2026-03-05 09:00:00', 1, 1, 41, '积分兑换 mock 用户 E', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9006, '岐黄学员F', '13900000006', 'https://example.com/mock/avatar-9006.png', 'mock_openid_9006', '岐黄学员F', 'https://example.com/mock/wx-9006.png', '2026-03-06 09:00:00', 0, 0, 38, '积分兑换 mock 用户 F', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9007, '岐黄学员G', '13900000007', 'https://example.com/mock/avatar-9007.png', 'mock_openid_9007', '岐黄学员G', 'https://example.com/mock/wx-9007.png', '2026-03-07 09:00:00', 0, 1, 30, '积分兑换 mock 用户 G', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'); |
| | | (9001, '岐黄学员A', '13900000001', 'https://example.com/mock/avatar-9001.png', 'mock_openid_9001', '岐黄学员A', 'https://example.com/mock/wx-9001.png', '2026-03-01 09:00:00', NULL, NULL, NULL, 1, 1, 32, '积分兑换 mock 用户 A', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9002, '岐黄学员B', '13900000002', 'https://example.com/mock/avatar-9002.png', 'mock_openid_9002', '岐黄学员B', 'https://example.com/mock/wx-9002.png', '2026-03-02 09:00:00', NULL, NULL, NULL, 0, 0, 29, '积分兑换 mock 用户 B', 1, 8001, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9003, '岐黄学员C', '13900000003', 'https://example.com/mock/avatar-9003.png', 'mock_openid_9003', '岐黄学员C', 'https://example.com/mock/wx-9003.png', '2026-03-03 09:00:00', NULL, NULL, NULL, 1, 1, 35, '积分兑换 mock 用户 C', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9004, '岐黄学员D', '13900000004', 'https://example.com/mock/avatar-9004.png', 'mock_openid_9004', '岐黄学员D', 'https://example.com/mock/wx-9004.png', '2026-03-04 09:00:00', NULL, NULL, NULL, 0, 0, 27, '积分兑换 mock 用户 D', 1, 8002, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9005, '岐黄学员E', '13900000005', 'https://example.com/mock/avatar-9005.png', 'mock_openid_9005', '岐黄学员E', 'https://example.com/mock/wx-9005.png', '2026-03-05 09:00:00', NULL, NULL, NULL, 1, 1, 41, '积分兑换 mock 用户 E', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9006, '岐黄学员F', '13900000006', 'https://example.com/mock/avatar-9006.png', 'mock_openid_9006', '岐黄学员F', 'https://example.com/mock/wx-9006.png', '2026-03-06 09:00:00', NULL, NULL, NULL, 0, 0, 38, '积分兑换 mock 用户 F', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'), |
| | | (9007, '岐黄学员G', '13900000007', 'https://example.com/mock/avatar-9007.png', 'mock_openid_9007', '岐黄学员G', 'https://example.com/mock/wx-9007.png', '2026-03-07 09:00:00', NULL, NULL, NULL, 0, 1, 30, '积分兑换 mock 用户 G', 1, 8003, '2027-03-01 00:00:00', 0, 'mock', 'mock'); |
| | | |
| | | -- 积分设置 |
| | | INSERT INTO `tcm_points_config` |