10 lines
620 B
SQL
Executable File
10 lines
620 B
SQL
Executable File
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
ALTER TABLE `pearproject`.`pear_member` ADD COLUMN `dingtalk_openid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '钉钉openid' AFTER `code`;
|
|
|
|
ALTER TABLE `pearproject`.`pear_member` ADD COLUMN `dingtalk_unionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '钉钉unionid' AFTER `dingtalk_openid`;
|
|
|
|
ALTER TABLE `pearproject`.`pear_member` ADD COLUMN `dingtalk_userid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '钉钉用户id' AFTER `dingtalk_unionid`;
|
|
|
|
SET FOREIGN_KEY_CHECKS=1;
|