题解 | #创建一张新表#

CREATE TABLE
    IF NOT EXISTS user_info_vip (
        id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID',
        uid int(11) NOT NULL UNIQUE NOT NULL COMMENT '用户ID',
        nick_name varchar(64) COMMENT '昵称',
        achievement int(11) DEFAULT 0 COMMENT '成就值',
        level int(11) COMMENT '用户等级',
        job varchar(32) COMMENT '职业方向',
        register_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间'
    ) CHARACTER SET utf8 COLLATE utf8_general_ci;