数据库加表
数据库:ucs
表名:tb_user_super_vip
sql:
CREATE TABLE `tb_user_super_vip` (
`user_id` bigint(20) NOT NULL,
`company_name_digest` varchar(32) NOT NULL,
`year_number` int(5) NOT NULL,
`old_level` tinyint(1) NOT NULL,
`operation` varchar(60) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表已上线,2代表待操作,3代表已下线',
`start_time` timestamp NULL DEFAULT NULL,
`expir_time` timestamp NULL DEFAULT NULL,
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`),
KEY `ix_company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8