sql语句建立数据库表

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

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='用户资料表';