Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

数据库加表

mysql变更格式

数据库：ucs

表名：tb_wiki_vip

sql：

CREATE TABLE `tb_wiki_vip` (
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `level` tinyint(1) NOT NULL COMMENT '等级，1代表1998，2代表6998',
  `year_number` int(11) NOT NULL,
  `operation` varchar(255) NOT NULL,
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `expir_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8