?? onetforums_mysql_4_0_3_to_4_0_4.sql
字號:
/**
* Database script upgrading from 4.0.3 to 4.0.4 for onet forums
* This scripts could apply to all database server.
* Creation Date:2006/5/15
* Please manually change the database according to the following guide:
*
* **** TABLE:onetVoteTrack *****
* 1.drop CONSTRAINT 'onet_pk_votr'
* 2.drop column 'key_id' , 'objectType'
* 3.change column name 'objectID' to 'itemID'
* 4.add CONSTRAINT 'CONSTRAINT onet_pk_votak PRIMARY KEY (itemID,userID)'
*
* **** TABLE:onetWatch *****
* 1.drop column 'key_id'
*/
CREATE INDEX onet_ix_foth_fxa ON onetForumThread (forumID,categoryID);
CREATE INDEX onet_ix_fome_fxa ON onetForumMessage (parentID,forumID,userID,modValue,delValue);
CREATE INDEX onet_ix_poca_fi ON onetPointCategory (forumID);
CREATE INDEX onet_ix_retr_rt ON onetReadTrack (readTime);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -