jive_forums_mysql_date_conversion.sql

Jive Forums 论坛源码 v4.2.3

#
# Jive Forums Upgrade Script - Converts string dates to BIGINT's
#
# $RCSFile$
# $Revision: 14306 $
# $Date: 2005-02-13 15:18:02 -0800 (Sun, 13 Feb 2005) $

# Change string column types for dates to longs for tables from 4.0 or earlier (any new
# tables introduced in 4.1 will already have the correct date type).

ALTER TABLE jiveUser CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveUser CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveGroup CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveGroup CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveCategory CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveCategory CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveForum CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveForum CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveThread CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveThread CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveMessage CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveMessage CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jiveAnnounce CHANGE startDate startDate BIGINT NOT NULL;
ALTER TABLE jiveAnnounce CHANGE endDate endDate BIGINT;

ALTER TABLE jivePMessage CHANGE pMessageDate pMessageDate BIGINT NOT NULL;

ALTER TABLE jiveModeration CHANGE modDate modDate BIGINT NOT NULL;

ALTER TABLE jiveBatchWatch CHANGE prevEmailDate prevEmailDate BIGINT NOT NULL;

ALTER TABLE jiveReward CHANGE creationDate creationDate BIGINT NOT NULL;

ALTER TABLE jiveReadTracker CHANGE readDate readDate BIGINT NOT NULL;

ALTER TABLE jiveAttachment CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveAttachment CHANGE modificationDate modificationDate BIGINT NOT NULL;

ALTER TABLE jivePoll CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jivePoll CHANGE modificationDate modificationDate BIGINT NOT NULL;
ALTER TABLE jivePoll CHANGE startDate startDate BIGINT NOT NULL;
ALTER TABLE jivePoll CHANGE endDate endDate BIGINT NOT NULL;
ALTER TABLE jivePoll CHANGE expireDate expireDate BIGINT NOT NULL;

ALTER TABLE jivePollVote CHANGE voteDate voteDate BIGINT NOT NULL;

ALTER TABLE jiveSearch CHANGE searchDate searchDate BIGINT NOT NULL;

ALTER TABLE jiveSearchClick CHANGE clickDate clickDate BIGINT NOT NULL;

ALTER TABLE jiveReadStat CHANGE creationDate creationDate BIGINT NOT NULL;

ALTER TABLE jiveReadStatSession CHANGE creationDate creationDate BIGINT NOT NULL;
ALTER TABLE jiveNNTPReadStatSession CHANGE endDate endDate BIGINT;