Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

添加表tb_user_vip_log

数据库：ucs

表名：tb_user_vip_log

sql：

CREATE TABLE `tb_user_vip_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `log_type` smallint(1) NOT NULL COMMENT 'vip日志的类型，0为仅修改开通年限，1为添加，2为升级，3为降级',
  `operation` varchar(60) NOT NULL COMMENT '操作人',
  `vip_change` varchar(255) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8