onetforums_mysql_4_0_3_to_4_0_4.sql

来自「tapestry的例子」· SQL 代码 · 共 20 行

 /**
  * 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);