由7.0升X2的BIG5系統，沒建立QQ數據表

今日嘗試開通QQ Connect，不過發現報錯

pre_connect_feedlog
pre_connect_memberbindlog
pre_connect_tlog

這三個表沒在數據庫增加

我在網上找到添加 feedlog的語法，但另外兩個就找不到了，可否提供?

CREATE TABLE IF NOT EXISTS pre_connect_feedlog (
  flid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  tid mediumint(8) unsigned NOT NULL DEFAULT '0',
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
  lastpublished int(10) unsigned NOT NULL DEFAULT '0',
  dateline int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (flid),
  UNIQUE KEY tid (tid)
) TYPE=MyISAM;

1. CREATE TABLE IF NOT EXISTS pre_connect_feedlog (
   
2.   flid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
3.   tid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
4.   uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
5.   publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
   
6.   lastpublished int(10) unsigned NOT NULL DEFAULT '0',
   
7.   dateline int(10) unsigned NOT NULL DEFAULT '0',
   
8.   `status` tinyint(1) NOT NULL DEFAULT '1',
   
9.   PRIMARY KEY (flid),
   
10.   UNIQUE KEY tid (tid)
    
11. ) TYPE=MyISAM;
    
12. 
    
13. CREATE TABLE IF NOT EXISTS pre_connect_memberbindlog (
    
14.   mblid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    
15.   uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
16.   uin char(40) NOT NULL,
    
17.   `type` tinyint(1) NOT NULL DEFAULT '0',
    
18.   dateline int(10) unsigned NOT NULL DEFAULT '0',
    
19.   PRIMARY KEY (mblid),
    
20.   KEY uid (uid),
    
21.   KEY uin (uin),
    
22.   KEY dateline (dateline)
    
23. ) TYPE=MyISAM;
    
24. 
    
25. CREATE TABLE IF NOT EXISTS pre_connect_tlog (
    
26.   tlid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    
27.   tid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
28.   uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
29.   publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
    
30.   lastpublished int(10) unsigned NOT NULL DEFAULT '0',
    
31.   dateline int(10) unsigned NOT NULL DEFAULT '0',
    
32.   `status` tinyint(1) NOT NULL DEFAULT '1',
    
33.   PRIMARY KEY (tlid),
    
34.   UNIQUE KEY tid (tid)
    
35. ) TYPE=MyISAM;
    

复制代码

謝謝你的準確回覆

可以直接升级啊？