jive_forums_sqlserver2000_date_conversion.sql

Jive Forums 论坛源码 v4.2.3

/**
 * Jive Forums Upgrade Script - Converts string dates to BIGINT's
 *
 * $RCSfile$
 * $Revision: 14366 $
 * $Date: 2005-02-14 12:48:41 -0800 (Mon, 14 Feb 2005) $
 */

DROP INDEX jiveUser.jiveUser_cDate_idx;
GO
ALTER TABLE jiveUser ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveUser ALTER COLUMN modificationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveUser_cDate_idx ON jiveUser (creationDate);
GO

DROP INDEX jiveGroup.jiveGroup_cDate_idx;
GO
ALTER TABLE jiveGroup ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveGroup ALTER COLUMN modificationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveGroup_cDate_idx ON jiveGroup (creationDate);
GO

ALTER TABLE jiveCategory ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveCategory ALTER COLUMN modificationDate BIGINT NOT NULL;
GO

DROP INDEX jiveForum.jiveFourm_cDate_idx;
DROP INDEX jiveForum.jiveFourm_mDate_idx;
GO
ALTER TABLE jiveForum ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveForum ALTER COLUMN modificationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveForum_cDate_idx ON jiveForum (creationDate);
CREATE INDEX jiveForum_mDate_idx ON jiveForum (modificationDate);
GO

DROP INDEX jiveThread.jiveThread_cDate_idx;
DROP INDEX jiveThread.jiveThread_mDate_idx;
GO
ALTER TABLE jiveThread ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveThread ALTER COLUMN modificationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveThread_cDate_idx ON jiveThread (creationDate);
CREATE INDEX jiveThread_mDate_idx ON jiveThread (modificationDate);
GO

DROP INDEX jiveMessage.jiveMessage_cDate_idx;
DROP INDEX jiveMessage.jiveMessage_mDate_idx;
GO
ALTER TABLE jiveMessage ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveMessage ALTER COLUMN modificationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveMessage_cDate_idx ON jiveMessage (creationDate);
CREATE INDEX jiveMessage_mDate_idx ON jiveMessage (modificationDate);
GO

DROP INDEX jiveAnnounce.jiveAnnounce_sDate_idx;
DROP INDEX jiveAnnounce.jiveAnnounce_eDate_idx;
GO
ALTER TABLE jiveAnnounce ALTER COLUMN startDate BIGINT NOT NULL;
ALTER TABLE jiveAnnounce ALTER COLUMN endDate BIGINT NULL;
GO
CREATE INDEX jiveAnnounce_sDate_idx ON jiveAnnounce (startDate);
CREATE INDEX jiveAnnounce_eDate_idx ON jiveAnnounce (endDate);
GO

ALTER TABLE jivePMessage ALTER COLUMN pMessageDate BIGINT NOT NULL;
ALTER TABLE jiveModeration ALTER COLUMN modDate BIGINT NOT NULL;
ALTER TABLE jiveBatchWatch ALTER COLUMN prevEmailDate BIGINT NOT NULL;
GO

DROP INDEX jiveReward.jiveReward_creationDate_idx;
GO
ALTER TABLE jiveReward ALTER COLUMN creationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveReward_creationDate_idx ON jiveReward (creationDate);
GO

ALTER TABLE jiveReadTracker ALTER COLUMN readDate BIGINT NOT NULL;
ALTER TABLE jiveAttachment ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveAttachment ALTER COLUMN modificationDate BIGINT NOT NULL;
GO

DROP INDEX jivePoll.jivePoll_cDate_idx;
DROP INDEX jivePoll.jivePoll_mDate_idx;
DROP INDEX jivePoll.jivePoll_sDate_idx;
DROP INDEX jivePoll.jivePoll_eDate_idx;
GO
ALTER TABLE jivePoll ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jivePoll ALTER COLUMN modificationDate BIGINT NOT NULL;
ALTER TABLE jivePoll ALTER COLUMN startDate BIGINT NOT NULL;
ALTER TABLE jivePoll ALTER COLUMN endDate BIGINT NOT NULL;
ALTER TABLE jivePoll ALTER COLUMN expireDate BIGINT NOT NULL;
GO
CREATE INDEX jivePoll_cDate_idx ON jivePoll (creationDate ASC);
CREATE INDEX jivePoll_mDate_idx ON jivePoll (modificationDate DESC);
CREATE INDEX jivePoll_sDate_idx ON jivePoll (startDate DESC);
CREATE INDEX jivePoll_eDate_idx ON jivePoll (endDate DESC);
GO

ALTER TABLE jivePollVote ALTER COLUMN voteDate BIGINT NOT NULL;
ALTER TABLE jiveSearch ALTER COLUMN searchDate BIGINT NOT NULL;
GO

ALTER TABLE jiveSearchClick DROP CONSTRAINT jiveSearchClick_pk;
GO
ALTER TABLE jiveSearchClick ALTER COLUMN clickDate BIGINT NOT NULL;
GO
ALTER TABLE jiveSearchClick ADD CONSTRAINT jiveSearchClick_pk PRIMARY KEY (searchID, messageID, clickDate);
GO

DROP INDEX jiveReadStat.jiveReadStat_cd_idx;
GO
ALTER TABLE jiveReadStat ALTER COLUMN creationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveReadStat_cd_idx ON jiveReadStat (creationDate);
GO

DROP INDEX jiveReadStatSession.jiveRSS_cd_idx;
GO
ALTER TABLE jiveReadStatSession ALTER COLUMN creationDate BIGINT NOT NULL;
GO
CREATE INDEX jiveRSS_cd_idx ON jiveReadStatSession (creationDate);
GO

DROP INDEX jiveNNTPReadStatSession.jiveNRSS_cd_idx;
DROP INDEX jiveNNTPReadStatSession.jiveNRSS_ed_idx;
GO
ALTER TABLE jiveNNTPReadStatSession ALTER COLUMN creationDate BIGINT NOT NULL;
ALTER TABLE jiveNNTPReadStatSession ALTER COLUMN endDate BIGINT NOT NULL;
GO
CREATE INDEX jiveNRSS_cd_idx ON jiveNNTPReadStatSession (creationDate);
CREATE INDEX jiveNRSS_ed_idx ON jiveNNTPReadStatSession (endDate);
GO