订单表
ucs. tb_register_msg_send_log
需要添加give_away字段
alter table `tb_register_msg_send_log` add give_away tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否需要赠送,0不需要赠送,1需要赠送,2已经赠送' AFTER `pay`
CREATE TABLE `tb_app_msg_page_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`phone` varchar(32) NOT NULL,
`contents` varchar(255) NOT NULL,
`digest` 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`),
KEY `phone` (`phone`),
KEY `digest` (`digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8