/**
  * Database script upgrading from 4.0 to 4.0.3 for onet forums
  * This scripts could apply to all database server.
  * Creation Date:2006/5/5
  * NOTE:You should manually ADD the following two columns to table "onetForumMessage" before column "modificationTime":
  * 1.tface NVARCHAR(20)
  * 2.IP NVARCHAR(30)
  */

CREATE INDEX onet_ix_usr_fx ON onetUser (username,passwordEncrypted);
CREATE INDEX onet_ix_usr_em ON onetUser (email);
CREATE INDEX onet_ix_usr_rq ON onetUser (reminderQuestion);
CREATE INDEX onet_ix_usr_av ON onetUser (activeValue);
CREATE INDEX onet_ix_usr_ct ON onetUser (creationTime);
CREATE INDEX onet_ix_usr_mt ON onetUser (modificationTime);
CREATE INDEX onet_ix_zone_pi ON onetZone (parentID);
CREATE INDEX onet_ix_zone_iv ON onetZone (indexValue);
CREATE INDEX onet_ix_zone_mt ON onetZone (modificationTime);
CREATE INDEX onet_ix_zone_ct ON onetZone (creationTime);
CREATE INDEX onet_ix_forum_zi ON onetForum (zoneID);
CREATE INDEX onet_ix_forum_iv ON onetForum (indexValue);
CREATE INDEX onet_ix_forum_mt ON onetForum (modificationtime);
CREATE INDEX onet_ix_fforum_ct ON onetForum (creationTime);
CREATE INDEX onet_ix_foth_fi ON onetForumThread (forumID);
CREATE INDEX onet_ix_foth_ci ON onetForumThread (categoryID);
CREATE INDEX onet_ix_foth_ui ON onetForumThread (userID);
CREATE INDEX onet_ix_foth_mv ON onetForumThread (modValue);
CREATE INDEX onet_ix_foth_dv ON onetForumThread (delValue);
CREATE INDEX onet_ix_foth_mc ON onetForumThread (msgCount);
CREATE INDEX onet_ix_foth_vc ON onetForumThread (viewCount);
CREATE INDEX onet_ix_foth_mt ON onetForumThread (modificationTime);
CREATE INDEX onet_ix_foth_ct ON onetForumThread (creationTime);
CREATE INDEX onet_ix_fome_pi ON onetForumMessage (parentID);
CREATE INDEX onet_ix_fome_ti ON onetForumMessage (threadID);
CREATE INDEX onet_ix_fome_fi ON onetForumMessage (forumID);
CREATE INDEX onet_ix_fome_ui ON onetForumMessage (userID);
CREATE INDEX onet_ix_fome_mv ON onetForumMessage (modValue);
CREATE INDEX onet_ix_fome_dv ON onetForumMessage (delValue);
CREATE INDEX onet_ix_fome_mt ON onetForumMessage (modificationTime);
CREATE INDEX onet_ix_fome_ct ON onetForumMessage (creationTime);
CREATE INDEX onet_ix_attch_oi ON onetAttachment (objectID);
CREATE INDEX onet_ix_attch_ct ON onetAttachment (creationTime);
CREATE INDEX onet_ix_focat_fi ON onetForumCategory (forumID);
CREATE INDEX onet_ix_focat_iv ON onetForumCategory (indexValue);
CREATE INDEX onet_ix_focat_ct ON onetForumCategory (creationTime);
CREATE INDEX onet_ix_foau_fi ON onetForumAuthorized (forumID);
CREATE INDEX onet_ix_foau_pt ON onetForumAuthorized (lastPaidTime);
CREATE INDEX onet_ix_foau_ct ON onetForumAuthorized (creationTime);
CREATE INDEX onet_ix_avat_oi ON onetAvatar (ownerID);
CREATE INDEX onet_ix_avusr_au ON onetAvatarUser (userID,avatarID);
CREATE INDEX onet_ix_fri_gi ON onetFriend (groupID);
CREATE INDEX onet_ix_fri_ct ON onetFriend (creationTime);
CREATE INDEX onet_ix_frgp_ui ON onetFriendGroup (userID);
CREATE INDEX onet_ix_pmsg_ui ON onetPMessage (userID);
CREATE INDEX onet_ix_pmsg_si ON onetPMessage (senderID);
CREATE INDEX onet_ix_pmsg_ri ON onetPMessage (recipientID);
CREATE INDEX onet_ix_pmsg_rv ON onetPMessage (readValue);
CREATE INDEX onet_ix_pmsg_fi ON onetPMessage (folderID);
CREATE INDEX onet_ix_pmsg_ct ON onetPMessage (creationTime);
CREATE INDEX onet_ix_poll_pm ON onetPoll (pollMode);
CREATE INDEX onet_ix_poll_lt ON onetPoll (lifeTime);
CREATE INDEX onet_ix_poll_ct ON onetPoll (creationTime);
CREATE INDEX onet_ix_poit_pi ON onetPollItem (pollID);
CREATE INDEX onet_ix_poit_vc ON onetPollItem (voteCount);
CREATE INDEX onet_ix_sl_mip ON onetStatusLevel (minPoints);
CREATE INDEX onet_ix_sl_map ON onetStatusLevel (maxPoints);
CREATE INDEX onet_ix_sl_gi ON onetStatusLevel (groupID);
CREATE INDEX onet_ix_lay_pi ON onetLayout (pathId);
CREATE INDEX onet_ix_lay_ct ON onetLayout (creationtime);
CREATE INDEX onet_ix_skin_ct ON onetSkin (creationtime);
CREATE INDEX onet_ix_sty_si ON onetStyle (skinID);
CREATE INDEX onet_ix_sty_ct ON onetStyle (creationTime);
CREATE INDEX onet_ix_tsk_rt ON onetTask (receiverType);
CREATE INDEX onet_ix_tsk_st ON onetTask (sendType);
CREATE INDEX onet_ix_tsk_at ON onetTask (activeType);
CREATE INDEX onet_ix_tsk_av ON onetTask (activeValue);
CREATE INDEX onet_ix_tsk_cs ON onetTask (currentSequence);
CREATE INDEX onet_ix_tskd_ti ON onetTaskDetail (taskID);
CREATE INDEX onet_ix_tskd_sv ON onetTaskDetail (sequenceValue);
CREATE INDEX onet_ix_tskd_st ON onetTaskDetail (startTime,endTime);
CREATE INDEX onet_ix_alli_ct ON onetAlliance (creationTime);
CREATE INDEX onet_ix_ann_ui ON onetAnnounce (userID);
CREATE INDEX onet_ix_ann_fx ON onetAnnounce (objectID,objectType);
CREATE INDEX onet_ix_ann_at ON onetAnnounce (annType);
CREATE INDEX onet_ix_ann_ct ON onetAnnounce (creationTime);
CREATE INDEX onet_ix_fevt_fi ON onetForumEvent (forumID);
CREATE INDEX onet_ix_fevt_et ON onetForumEvent (eventType);
CREATE INDEX onet_ix_fevt_ui ON onetForumEvent (userID);
CREATE INDEX onet_ix_fevt_fp ON onetForumEvent (fromIP);
CREATE INDEX onet_ix_fevt_ct ON onetForumEvent (creationTime);
CREATE INDEX onet_ix_ptsh_ot ON onetPointsheet (onlineTime);
CREATE INDEX onet_ix_ptsh_ll ON onetPointsheet (lastLogin);
CREATE INDEX onet_ix_trde_ui ON onetTrade (userID);
CREATE INDEX onet_ix_trde_og ON onetTrade (orderGross);
CREATE INDEX onet_ix_trde_ot ON onetTrade (orderType);
CREATE INDEX onet_ix_trde_ct ON onetTrade (creationTime);
CREATE INDEX onet_ix_ip ON onetSynchronize (fromIP);
CREATE INDEX onet_ix_ct ON onetSynchronize (creationTime);
CREATE INDEX onet_ix_slp_pi ON onetStatusLevelPoints (points);