sql语句建立数据库表

来源：互联网发布：淘宝能发到韩国吗编辑：程序博客网时间：2024/06/11 06:05

建立了一个微信公众号关注者用户信息资料表

DROP TABLE IF EXISTS `user_profile`;CREATE TABLE IF NOT EXISTS `user_profile` (  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户资料表id',  `openid` VARCHAR(32) NOT NULL COMMENT '用户UID',  `headimgurl` VARCHAR(255) NOT NULL COMMENT '用户头像文件url',  `nickname` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',   `sex` TINYINT(1) UNSIGNED NOT NULL COMMENT '用户性别',   `la`   VARCHAR(255) NOT NULL COMMENT '用户经度',   `lo`    VARCHAR(255) NOT NULL COMMENT '用户纬度',  `city` VARCHAR(255) NOT NULL COMMENT '用户城市',  `province` VARCHAR(255) NOT NULL COMMENT '用户省份',    `country` VARCHAR(255) NOT NULL COMMENT '用户国家',  `subscribe_time` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '关注的时间',    `unsubscribe_time` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '取消关注的时间',   `subscribe` TINYINT(1) UNSIGNED NOT NULL COMMENT '关注状态',  PRIMARY KEY (`id`) ,  UNIQUE KEY `openid` (`openid`) ,  INDEX `headimgurl` (`headimgurl`) ,  INDEX `nickname` (`nickname`) ,  INDEX `sex` (`sex`) ,   INDEX `la` (`la`) ,    INDEX `lo` (`lo`) ,   INDEX `city` (`city`) ,   INDEX `province` (`province`) ,   INDEX `country` (`country`) ,  INDEX `subscribe_time` (`subscribe_time`) ,  INDEX `unsubscribe_time` (`unsubscribe_time`) , INDEX `subscribe` (`subscribe`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户资料表';

0 0