GitLab

#数据库 ucs

alter table `tb_person_vip` add person_level int(1) not null default 1 comment '1代表普通vip，2代表svip' after where_from

alter table `tb_person_vip` add avg_price float(11,4) not null default 0 after person_level

CREATE TABLE `tb_person_vip_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `pre_log` varchar(20000) 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

CREATE TABLE `tb_person_order` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL DEFAULT '0',
 `order_no` varchar(64) NOT NULL,
 `mod_day` int(11) 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`),
 KEY `order_no` (`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8