Ticket #334: [mysql]7.0.4亲子需要执行的.sql

--ŽŽœšÒ»ÖÜÈÈÌûͳŒÆ±í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');