From 69c2c400e6e3393424d704742cd9de0e6da07e2f Mon Sep 17 00:00:00 2001 From: “mitao” <“2763622819@qq.com”> Date: 星期一, 27 四月 2026 20:12:30 +0800 Subject: [PATCH] fix:ios授权登录 --- tcm-training-admin-backend/sql/init.sql | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/tcm-training-admin-backend/sql/init.sql b/tcm-training-admin-backend/sql/init.sql index 2984d09..6f931dd 100644 --- a/tcm-training-admin-backend/sql/init.sql +++ b/tcm-training-admin-backend/sql/init.sql @@ -300,6 +300,9 @@ `wechat_nickname` VARCHAR(64) DEFAULT NULL COMMENT '微信昵称', `wechat_avatar` VARCHAR(255) DEFAULT NULL COMMENT '微信头像URL', `wechat_bound_at` DATETIME DEFAULT NULL COMMENT '微信绑定时间', + `apple_user_identifier` VARCHAR(128) DEFAULT NULL COMMENT '苹果用户标识', + `apple_identity_subject` VARCHAR(128) DEFAULT NULL COMMENT '苹果身份主题标识', + `apple_bound_at` DATETIME DEFAULT NULL COMMENT '苹果绑定时间', `type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '用户类型：0个人 1诊所', `gender` TINYINT(1) DEFAULT NULL COMMENT '性别：0女 1男', `age` TINYINT UNSIGNED DEFAULT NULL COMMENT '年龄', @@ -319,8 +322,8 @@ KEY `idx_app_user_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='APP用户表（C端用户）'; -INSERT IGNORE INTO `tcm_app_user` (`id`, `nickname`, `phone`, `password`, `avatar`, `wechat_openid`, `wechat_nickname`, `wechat_avatar`, `wechat_bound_at`, `type`, `gender`, `age`, `intro`, `status`, `clinic_id`, `superior_clinic_user_id`, `member_expire_at`, `deleted`) -VALUES (200, '张三', '13800008888', NULL, 'https://example.com/avatar/app-user-200.png', 'wx_openid_200', '小张', 'https://example.com/avatar/wechat-200.png', CURRENT_TIMESTAMP, 1, 1, 19, 'If you find an element of your interface requires instructions, then you need to redesign it.', 1, 1, NULL, NULL, 0); +INSERT IGNORE INTO `tcm_app_user` (`id`, `nickname`, `phone`, `password`, `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`, `superior_clinic_user_id`, `member_expire_at`, `deleted`) +VALUES (200, '张三', '13800008888', NULL, 'https://example.com/avatar/app-user-200.png', 'wx_openid_200', '小张', 'https://example.com/avatar/wechat-200.png', CURRENT_TIMESTAMP, NULL, NULL, NULL, 1, 1, 19, 'If you find an element of your interface requires instructions, then you need to redesign it.', 1, 1, NULL, NULL, 0); -- ---------------------------- -- 会员价格配置 -- Gitblit v1.7.1