GitLab

#数据库 ucs

CREATE TABLE `tb_app_push_cid` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `cid` varchar(255) NOT NULL,
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

alter table `tb_app_push_cid` add sys varchar(255) not null default '' after cid