mysql 建表

CREATE TABLE IF NOT EXISTS user_info_vip 
( id int primary KEY AUTO_INCREMENT COMMENT '自增ID',
  uid int unique not null COMMENT '用户ID',
 nick_name varchar(64)  COMMENT '昵称',
 achievement int DEFAULT 0 COMMENT '成就值',
 level int COMMENT '用户等级',
 job varchar(32) COMMENT '职业方向',
 register_time datetime  default current_timestamp COMMENT '注册时间'
 
) DEFAULT CHARSET=UTF8;