11

[任亚军]

ALTER TABLE b_shanghu_statistics ADD yesterday_uv INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '昨天的uv';
ALTER TABLE b_shanghu_statistics ADD init_uv INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '初始值';
ALTER TABLE b_shanghu_statistics ADD display_uv INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '累计值';
alter table youa.b_shanghu add column expire_time int unsigned not  null default 0comment '付费过期时间';
alter table youa.b_shanghu add column qq varchar(32)  null default null comment 'qqnumber';

CREATE TABLE IF NOT EXISTS `b_shanghu_pay_type_history` (
 `sh_id` bigint(20) unsigned NOT NULL COMMENT '商户id',
 `operator_uid` bigint(20) NOT NULL COMMENT '操作员id',
 `ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时用户的ip地址',
 `original_pay_type` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '0:未认领 1:付费认领 2:免费认领, 操作之前的状态',
 `current_pay_type` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '0:未认领 1:付费认领 2:免费认领, 当前的状态',
 `original_expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新前的付费的最后时间',
 `current_expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当前的付费的最后时间',
 `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
 `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
 KEY `sh_id_time` (`sh_id`,`create_time`),
 KEY `expire_time` (`original_expire_time`, `current_expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;