jive_forums_postgres_date_conversion.sql

Jive Forums 论坛源码 v4.2.3

--
-- Jive Forums Upgrade Script - Converts string dates to BIGINT's
--
-- $RCSfile$
-- $Revision: 14365 $
-- $Date: 2005-02-14 12:11:28 -0800 (Mon, 14 Feb 2005) $

ALTER TABLE jiveUser ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveUser SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveUser DROP COLUMN creationDate;
      ALTER TABLE jiveUser RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveUser ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveUser ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveUser SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveUser DROP COLUMN modificationDate;
      ALTER TABLE jiveUser RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveUser ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveGroup ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveGroup SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveGroup DROP COLUMN creationDate;
      ALTER TABLE jiveGroup RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveGroup ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveGroup ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveGroup SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveGroup DROP COLUMN modificationDate;
      ALTER TABLE jiveGroup RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveGroup ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveCategory ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveCategory SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveCategory DROP COLUMN creationDate;
      ALTER TABLE jiveCategory RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveCategory ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveCategory ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveCategory SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveCategory DROP COLUMN modificationDate;
      ALTER TABLE jiveCategory RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveCategory ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveForum ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveForum SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveForum DROP COLUMN creationDate;
      ALTER TABLE jiveForum RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveForum ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveForum ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveForum SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveForum DROP COLUMN modificationDate;
      ALTER TABLE jiveForum RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveForum ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveThread ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveThread SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveThread DROP COLUMN creationDate;
      ALTER TABLE jiveThread RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveThread ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveThread ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveThread SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveThread DROP COLUMN modificationDate;
      ALTER TABLE jiveThread RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveThread ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveMessage ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveMessage SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveMessage DROP COLUMN creationDate;
      ALTER TABLE jiveMessage RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveMessage ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveMessage ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveMessage SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveMessage DROP COLUMN modificationDate;
      ALTER TABLE jiveMessage RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveMessage ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveAnnounce ADD COLUMN startDateTemp BIGINT;
  UPDATE jiveAnnounce SET startDateTemp = CAST(startDate AS BIGINT);
    ALTER TABLE jiveAnnounce DROP COLUMN startDate;
      ALTER TABLE jiveAnnounce RENAME COLUMN startDateTemp TO startDate;
        ALTER TABLE jiveAnnounce ALTER COLUMN startDate SET NOT NULL;

ALTER TABLE jiveAnnounce ADD COLUMN endDateTemp BIGINT;
  UPDATE jiveAnnounce SET endDateTemp = CAST(endDate AS BIGINT);
    ALTER TABLE jiveAnnounce DROP COLUMN endDate;
      ALTER TABLE jiveAnnounce RENAME COLUMN endDateTemp TO endDate;

ALTER TABLE jivePMessage ADD COLUMN pMessageDateTemp BIGINT;
  UPDATE jivePMessage SET pMessageDateTemp = CAST(pMessageDate AS BIGINT);
    ALTER TABLE jivePMessage DROP COLUMN pMessageDate;
      ALTER TABLE jivePMessage RENAME COLUMN pMessageDateTemp TO pMessageDate;
        ALTER TABLE jivePMessage ALTER COLUMN pMessageDate SET NOT NULL;

ALTER TABLE jiveModeration ADD COLUMN modDateTemp BIGINT;
  UPDATE jiveModeration SET modDateTemp = CAST(modDate AS BIGINT);
    ALTER TABLE jiveModeration DROP COLUMN modDate;
      ALTER TABLE jiveModeration RENAME COLUMN modDateTemp TO modDate;
        ALTER TABLE jiveModeration ALTER COLUMN modDate SET NOT NULL;

ALTER TABLE jiveBatchWatch ADD COLUMN prevEmailDateTemp BIGINT;
  UPDATE jiveBatchWatch SET prevEmailDateTemp = CAST(prevEmailDate AS BIGINT);
    ALTER TABLE jiveBatchWatch DROP COLUMN prevEmailDate;
      ALTER TABLE jiveBatchWatch RENAME COLUMN prevEmailDateTemp TO prevEmailDate;
        ALTER TABLE jiveBatchWatch ALTER COLUMN prevEmailDate SET NOT NULL;

ALTER TABLE jiveReward ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReward SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveReward DROP COLUMN creationDate;
      ALTER TABLE jiveReward RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveReward ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveReadTracker ADD COLUMN readDateTemp BIGINT;
  UPDATE jiveReadTracker SET readDateTemp = CAST(readDate AS BIGINT);
    ALTER TABLE jiveReadTracker DROP COLUMN readDate;
      ALTER TABLE jiveReadTracker RENAME COLUMN readDateTemp TO readDate;
        ALTER TABLE jiveReadTracker ALTER COLUMN readDate SET NOT NULL;

ALTER TABLE jiveAttachment ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveAttachment SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveAttachment DROP COLUMN creationDate;
      ALTER TABLE jiveAttachment RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveAttachment ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveAttachment ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveAttachment SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jiveAttachment DROP COLUMN modificationDate;
      ALTER TABLE jiveAttachment RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jiveAttachment ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN creationDateTemp BIGINT;
  UPDATE jivePoll SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jivePoll DROP COLUMN creationDate;
      ALTER TABLE jivePoll RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jivePoll ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jivePoll SET modificationDateTemp = CAST(modificationDate AS BIGINT);
    ALTER TABLE jivePoll DROP COLUMN modificationDate;
      ALTER TABLE jivePoll RENAME COLUMN modificationDateTemp TO modificationDate;
        ALTER TABLE jivePoll ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN startDateTemp BIGINT;
  UPDATE jivePoll SET startDateTemp = CAST(startDate AS BIGINT);
    ALTER TABLE jivePoll DROP COLUMN startDate;
      ALTER TABLE jivePoll RENAME COLUMN startDateTemp TO startDate;
        ALTER TABLE jivePoll ALTER COLUMN startDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN endDateTemp BIGINT;
  UPDATE jivePoll SET endDateTemp = CAST(endDate AS BIGINT);
    ALTER TABLE jivePoll DROP COLUMN endDate;
      ALTER TABLE jivePoll RENAME COLUMN endDateTemp TO endDate;
        ALTER TABLE jivePoll ALTER COLUMN endDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN expireDateTemp BIGINT;
  UPDATE jivePoll SET expireDateTemp = CAST(expireDate AS BIGINT);
    ALTER TABLE jivePoll DROP COLUMN expireDate;
      ALTER TABLE jivePoll RENAME COLUMN expireDateTemp TO expireDate;
        ALTER TABLE jivePoll ALTER COLUMN expireDate SET NOT NULL;

ALTER TABLE jivePollVote ADD COLUMN voteDateTemp BIGINT;
  UPDATE jivePollVote SET voteDateTemp = CAST(voteDate AS BIGINT);
    ALTER TABLE jivePollVote DROP COLUMN voteDate;
      ALTER TABLE jivePollVote RENAME COLUMN voteDateTemp TO voteDate;
        ALTER TABLE jivePollVote ALTER COLUMN voteDate SET NOT NULL;

ALTER TABLE jiveSearch ADD COLUMN searchDateTemp BIGINT;
  UPDATE jiveSearch SET searchDateTemp = CAST(searchDate AS BIGINT);
    ALTER TABLE jiveSearch DROP COLUMN searchDate;
      ALTER TABLE jiveSearch RENAME COLUMN searchDateTemp TO searchDate;
        ALTER TABLE jiveSearch ALTER COLUMN searchDate SET NOT NULL;

ALTER TABLE jiveSearchClick ADD COLUMN clickDateTemp BIGINT;
  UPDATE jiveSearchClick SET clickDateTemp = CAST(clickDate AS BIGINT);
    ALTER TABLE jiveSearchClick DROP COLUMN clickDate;
      ALTER TABLE jiveSearchClick RENAME COLUMN clickDateTemp TO clickDate;
        ALTER TABLE jiveSearchClick ALTER COLUMN clickDate SET NOT NULL;

ALTER TABLE jiveReadStat ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReadStat SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveReadStat DROP COLUMN creationDate;
      ALTER TABLE jiveReadStat RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveReadStat ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveReadStatSession ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReadStatSession SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveReadStatSession DROP COLUMN creationDate;
      ALTER TABLE jiveReadStatSession RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveReadStatSession ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveNNTPReadStatSession ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveNNTPReadStatSession SET creationDateTemp = CAST(creationDate AS BIGINT);
    ALTER TABLE jiveNNTPReadStatSession DROP COLUMN creationDate;
      ALTER TABLE jiveNNTPReadStatSession RENAME COLUMN creationDateTemp TO creationDate;
        ALTER TABLE jiveNNTPReadStatSession ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveNNTPReadStatSession ADD COLUMN endDateTemp BIGINT;
  UPDATE jiveNNTPReadStatSession SET endDateTemp = CAST(endDate AS BIGINT);
    ALTER TABLE jiveNNTPReadStatSession DROP COLUMN endDate;
      ALTER TABLE jiveNNTPReadStatSession RENAME COLUMN endDateTemp TO endDate;
        ALTER TABLE jiveNNTPReadStatSession ALTER COLUMN endDate SET NOT NULL;