--创建一周热帖统计表bbs7_topic_hot_week
CREATE TABLE bbs7_topic_hot_week(
 tid INT(11) PRIMARY KEY,
 replyCount INT(11) DEFAULT 0,
 updateAt DATETIME
)

-- 创建管理员的昨日热帖统计表bbs7_topic_admin_hot_yesterday
CREATE TABLE bbs7_topic_admin_hot_yesterday(
  tid INT(10) UNSIGNED NOT NULL COMMENT '主题ID',
  replycount INT(10) UNSIGNED NOT NULL COMMENT '主题回复数',
  PRIMARY KEY (tid)
) 

-- 在配置表里插入管理员,appvalue是指定用户的uid，可根据情况增加(也可以在应用管理后台里面配置参数)
INSERT INTO bbs7_app_config(appname,appkey,appvalue) VALUES ('yesterdayHotTopicUid','yesterdayHotTopicUid','9362493');
INSERT INTO bbs7_app_config(appname,appkey,appvalue) VALUES ('yesterdayHotTopicUid','yesterdayHotTopicUid','28104707');
INSERT INTO bbs7_app_config(appname,appkey,appvalue) VALUES ('yesterdayHotTopicUid','yesterdayHotTopicUid','25311587');
INSERT INTO bbs7_app_config(appname,appkey,appvalue) VALUES ('yesterdayHotTopicUid','yesterdayHotTopicUid','24877414');
INSERT INTO bbs7_app_config(appname,appkey,appvalue) VALUES ('yesterdayHotTopicUid','yesterdayHotTopicUid','29189001');