You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
1.1 KiB
22 lines
1.1 KiB
-- 创建数据库
|
|
CREATE DATABASE IF NOT EXISTS wx_miniapp DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
|
|
|
-- 使用数据库
|
|
USE wx_miniapp;
|
|
|
|
-- 创建微信用户表
|
|
CREATE TABLE IF NOT EXISTS `wx_user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
`openid` varchar(100) NOT NULL COMMENT '微信openid',
|
|
`nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
|
|
`avatar_url` varchar(500) DEFAULT NULL COMMENT '头像URL',
|
|
`gender` tinyint(4) DEFAULT NULL COMMENT '性别 0-未知 1-男 2-女',
|
|
`country` varchar(50) DEFAULT NULL COMMENT '国家',
|
|
`province` varchar(50) DEFAULT NULL COMMENT '省份',
|
|
`city` varchar(50) DEFAULT NULL COMMENT '城市',
|
|
`language` varchar(50) DEFAULT NULL COMMENT '语言',
|
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_openid` (`openid`) COMMENT 'openid唯一索引'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信用户表'; |