onetforums_mysql_4_0_5_to_4_1.sql

tapestry的例子

/**
  * Database script upgrading from onet forums 4.0.5 to 4.1
  * MYSQL script
  * Creation Date:2006/7/25
  */

DROP INDEX onet_ix_ip ON onetSynchronize;
DROP INDEX onet_ix_ct ON onetSynchronize;
DROP TABLE onetSynchronize;

ALTER TABLE onetPluginProp CHANGE COLUMN key_id objectID VARCHAR (50) NOT NULL;
ALTER TABLE onetGroup CHANGE description description TEXT NOT NULL;
ALTER TABLE onetZone CHANGE description description TEXT NOT NULL;
ALTER TABLE onetForum CHANGE description description TEXT NOT NULL;
ALTER TABLE onetFaction CHANGE description description TEXT NOT NULL;
ALTER TABLE onetForumMessage CHANGE body body TEXT NOT NULL;
ALTER TABLE onetPMessage CHANGE body body TEXT NOT NULL;
ALTER TABLE onetForumMessage CHANGE tface tface VARCHAR(20) NOT NULL;
ALTER TABLE onetForumMessage CHANGE IP ip VARCHAR(30) NOT NULL;
ALTER TABLE onetAttachment CHANGE objectID objectID BIGINT NOT NULL;
ALTER TABLE onetAttachment CHANGE fileSpecs fileSpecs VARCHAR (50) NOT NULL;
ALTER TABLE onetAvatar CHANGE ownerID ownerID BIGINT NOT NULL;
ALTER TABLE onetStatusLevel CHANGE description description TEXT NOT NULL;
ALTER TABLE onetStatusLevel CHANGE minPoints minPoints INTEGER NOT NULL;
ALTER TABLE onetStatusLevel CHANGE maxPoints maxPoints INTEGER NOT NULL;
ALTER TABLE onetStatusLevel CHANGE groupID groupID BIGINT NOT NULL;
ALTER TABLE onetLayout CHANGE description description TEXT NOT NULL;
ALTER TABLE onetSkin CHANGE description description TEXT NOT NULL;
ALTER TABLE onetStyle CHANGE description description TEXT NOT NULL;
ALTER TABLE onetAnnounce CHANGE annType annType INTEGER DEFAULT 1 NOT NULL;
ALTER TABLE onetAnnounce CHANGE subject subject VARCHAR (255) NOT NULL;

CREATE INDEX onet_ix_uprm_fxa ON onetUserPerm (objectID,objectType);
CREATE INDEX onet_ix_uprm_fxb ON onetUserPerm (objectID,objectType,permission);
CREATE INDEX onet_ix_uprm_fxc ON onetUserPerm (objectType,userID,permission);
CREATE INDEX onet_ix_uprm_fxd ON onetUserPerm (userID,permission);
CREATE INDEX onet_ix_gprm_fxa ON onetGroupPerm (objectID,objectType);
CREATE INDEX onet_ix_gprm_fxb ON onetGroupPerm (objectID,objectType,permission);
CREATE INDEX onet_ix_gprm_fxc ON onetGroupPerm (objectType,groupID,permission);
CREATE INDEX onet_ix_gprm_fxd ON onetGroupPerm (groupID,permission);
CREATE INDEX onet_ix_foth_fxd ON onetForumThread (forumID,modValue,delValue,modificationTime DESC);
CREATE INDEX onet_ix_foth_fxe ON onetForumThread (forumID,userID,modValue,delValue);
CREATE INDEX onet_ix_fome_th ON onetForumMessage (threadID);
CREATE INDEX onet_ix_fome_fxb ON onetForumMessage (parentID,threadID,modValue);
CREATE INDEX onet_ix_fome_fxc ON onetForumMessage (threadID,parentID,delValue,modValue,key_id);
CREATE INDEX onet_ix_fome_fxd ON onetForumMessage (threadID,modValue,creationTime DESC);
CREATE INDEX onet_ix_fome_fxe ON onetForumMessage (userID,modValue,delValue,key_id DESC);
CREATE INDEX onet_ix_ftt_fxa ON onetForumThreadTop (objectID,objectType,creationTime DESC);
CREATE INDEX onet_ix_attch_fxa ON onetAttachment (objectID,creationTime);
CREATE INDEX onet_ix_fri_fxa ON onetFriend (userID,memberID,groupID);
CREATE INDEX onet_ix_poit_fxa ON onetPollItem (pollID,key_id);
CREATE INDEX onet_ix_votak_it ON onetVoteTrack (itemID);
CREATE INDEX onet_ix_sl_fxa ON onetStatusLevel (groupID,minPoints DESC);
CREATE INDEX onet_ix_wch_ui ON onetWatch (userID);
CREATE INDEX onet_ix_wch_fxa ON onetWatch (userID,objectType);
CREATE INDEX onet_ix_wch_fxb ON onetWatch (objectID,objectType);
CREATE INDEX onet_ix_wch_fxc ON onetWatch (objectType,expirable);
CREATE INDEX onet_ix_wch_fxd ON onetWatch (objectID,objectType,watchType,scheduled);
CREATE INDEX onet_ix_ann_fxa ON onetAnnounce (key_id,annType);
CREATE INDEX onet_ix_ann_fxb ON onetAnnounce (objectID,objectType,annType);
CREATE INDEX onet_ix_ann_fxc ON onetAnnounce (userID,annType);
CREATE INDEX onet_ix_ann_fxd ON onetAnnounce (objectID,objectType,annType,creationTime DESC);
CREATE INDEX onet_ix_trde_fxa ON onetTrade(userID,orderStatus,creationTime DESC);
CREATE INDEX onet_ix_aper_fxa ON onetAPerm (objectID,objectType DESC,userID,userType);
CREATE INDEX onet_ix_aper_fxb ON onetAPerm (userID,userType);
CREATE INDEX onet_ix_aper_fxc ON onetAPerm (objectID,objectType);
CREATE INDEX onet_ix_fome_fxf ON onetForumMessage (forumID,modValue,delValue,modificationTime DESC);
CREATE INDEX onet_ix_fome_fxg ON onetForumMessage (forumID,modValue,delValue,creationTime DESC);