GitLab

ucs.tb_register_msg_openid_phone_assoc


CREATE TABLE `tb_register_msg_openid_phone_assoc` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `phone` varchar(32) NOT NULL,
 `openid` 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 `openid` (`openid`),
 KEY `phone` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8



ALTER TABLE `tb_register_msg_send_log` ADD `open_mini` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否打开小程序' AFTER `give_away`;

ALTER TABLE `tb_register_msg_send_log` ADD `mini_pay` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否在小程序支付' AFTER `open_mini`;

ALTER TABLE `tb_register_msg_send_log` ADD `mini_subscription` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否在小程序订阅' AFTER `mini_pay`;





ALTER TABLE `tb_register_msg_send_log_count` ADD `open_mini_count` INT(11) NOT NULL DEFAULT '0' COMMENT '打开小程序的量' AFTER `pay_count`;

ALTER TABLE `tb_register_msg_send_log_count` ADD `mini_pay_count` INT(11) NOT NULL DEFAULT '0' COMMENT '在小程序中支付的量' AFTER `open_mini_count`;

ALTER TABLE `tb_register_msg_send_log_count` ADD `mini_subscription_count` INT(11) NOT NULL DEFAULT '0' COMMENT '在小程序中订阅的量' AFTER `mini_pay_count`;