jive_forums_mckoi_date_conversion.sql

Jive Forums 论坛源码 v4.2.3

--
-- Jive Forums Upgrade Script - Converts string dates to BIGINT's
--
-- $RCSfile$
-- $Revision: 14844 $
-- $Date: 2005-04-03 19:25:03 -0700 (Sun, 03 Apr 2005) $

ALTER TABLE jiveUser ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveUser SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveUser DROP COLUMN creationDate;
      ALTER TABLE jiveUser ADD COLUMN creationDate BIGINT;
        UPDATE jiveUser SET creationDate = creationDateTemp;
          ALTER TABLE jiveUser DROP COLUMN creationDateTemp;
            ALTER TABLE jiveUser ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveUser ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveUser SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveUser DROP COLUMN modificationDate;
      ALTER TABLE jiveUser ADD COLUMN modificationDate BIGINT;
        UPDATE jiveUser SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveUser DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveUser ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveGroup ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveGroup SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveGroup DROP COLUMN creationDate;
      ALTER TABLE jiveGroup ADD COLUMN creationDate BIGINT;
        UPDATE jiveGroup SET creationDate = creationDateTemp;
          ALTER TABLE jiveGroup DROP COLUMN creationDateTemp;
            ALTER TABLE jiveGroup ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveGroup ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveGroup SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveGroup DROP COLUMN modificationDate;
      ALTER TABLE jiveGroup ADD COLUMN modificationDate BIGINT;
        UPDATE jiveGroup SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveGroup DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveGroup ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveCategory ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveCategory SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveCategory DROP COLUMN creationDate;
      ALTER TABLE jiveCategory ADD COLUMN creationDate BIGINT;
        UPDATE jiveCategory SET creationDate = creationDateTemp;
          ALTER TABLE jiveCategory DROP COLUMN creationDateTemp;
            ALTER TABLE jiveCategory ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveCategory ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveCategory SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveCategory DROP COLUMN modificationDate;
      ALTER TABLE jiveCategory ADD COLUMN modificationDate BIGINT;
        UPDATE jiveCategory SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveCategory DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveCategory ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveForum ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveForum SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveForum DROP COLUMN creationDate;
      ALTER TABLE jiveForum ADD COLUMN creationDate BIGINT;
        UPDATE jiveForum SET creationDate = creationDateTemp;
          ALTER TABLE jiveForum DROP COLUMN creationDateTemp;
            ALTER TABLE jiveForum ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveForum ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveForum SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveForum DROP COLUMN modificationDate;
      ALTER TABLE jiveForum ADD COLUMN modificationDate BIGINT;
        UPDATE jiveForum SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveForum DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveForum ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveThread ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveThread SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveThread DROP COLUMN creationDate;
      ALTER TABLE jiveThread ADD COLUMN creationDate BIGINT;
        UPDATE jiveThread SET creationDate = creationDateTemp;
          ALTER TABLE jiveThread DROP COLUMN creationDateTemp;
            ALTER TABLE jiveThread ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveThread ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveThread SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveThread DROP COLUMN modificationDate;
      ALTER TABLE jiveThread ADD COLUMN modificationDate BIGINT;
        UPDATE jiveThread SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveThread DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveThread ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveMessage ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveMessage SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveMessage DROP COLUMN creationDate;
      ALTER TABLE jiveMessage ADD COLUMN creationDate BIGINT;
        UPDATE jiveMessage SET creationDate = creationDateTemp;
          ALTER TABLE jiveMessage DROP COLUMN creationDateTemp;
            ALTER TABLE jiveMessage ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveMessage ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveMessage SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveMessage DROP COLUMN modificationDate;
      ALTER TABLE jiveMessage ADD COLUMN modificationDate BIGINT;
        UPDATE jiveMessage SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveMessage DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveMessage ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jiveAnnounce ADD COLUMN startDateTemp BIGINT;
  UPDATE jiveAnnounce SET startDateTemp = TONUMBER(startDate);
    ALTER TABLE jiveAnnounce DROP COLUMN startDate;
      ALTER TABLE jiveAnnounce ADD COLUMN startDate BIGINT;
        UPDATE jiveAnnounce SET startDate = startDateTemp;
          ALTER TABLE jiveAnnounce DROP COLUMN startDateTemp;
            ALTER TABLE jiveAnnounce ALTER COLUMN startDate SET NOT NULL;

ALTER TABLE jiveAnnounce ADD COLUMN endDateTemp BIGINT;
  UPDATE jiveAnnounce SET endDateTemp = TONUMBER(endDate);
    ALTER TABLE jiveAnnounce DROP COLUMN endDate;
      ALTER TABLE jiveAnnounce ADD COLUMN endDate BIGINT;
        UPDATE jiveAnnounce SET endDate = endDateTemp;
          ALTER TABLE jiveAnnounce DROP COLUMN endDateTemp;

ALTER TABLE jivePMessage ADD COLUMN pMessageDateTemp BIGINT;
  UPDATE jivePMessage SET pMessageDateTemp = TONUMBER(pMessageDate);
    ALTER TABLE jivePMessage DROP COLUMN pMessageDate;
      ALTER TABLE jivePMessage ADD COLUMN pMessageDate BIGINT;
        UPDATE jivePMessage SET pMessageDate = pMessageDateTemp;
          ALTER TABLE jivePMessage DROP COLUMN pMessageDateTemp;
            ALTER TABLE jivePMessage ALTER COLUMN pMessageDate SET NOT NULL;

ALTER TABLE jiveModeration ADD COLUMN modDateTemp BIGINT;
  UPDATE jiveModeration SET modDateTemp = TONUMBER(modDate);
    ALTER TABLE jiveModeration DROP COLUMN modDate;
      ALTER TABLE jiveModeration ADD COLUMN modDate BIGINT;
        UPDATE jiveModeration SET modDate = modDateTemp;
          ALTER TABLE jiveModeration DROP COLUMN modDateTemp;
            ALTER TABLE jiveModeration ALTER COLUMN modDate SET NOT NULL;

ALTER TABLE jiveBatchWatch ADD COLUMN prevEmailDateTemp BIGINT;
  UPDATE jiveBatchWatch SET prevEmailDateTemp = TONUMBER(prevEmailDate);
    ALTER TABLE jiveBatchWatch DROP COLUMN prevEmailDate;
      ALTER TABLE jiveBatchWatch ADD COLUMN prevEmailDate BIGINT;
        UPDATE jiveBatchWatch SET prevEmailDate = prevEmailDateTemp;
          ALTER TABLE jiveBatchWatch DROP COLUMN prevEmailDateTemp;

ALTER TABLE jiveReward ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReward SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveReward DROP COLUMN creationDate;
      ALTER TABLE jiveReward ADD COLUMN creationDate BIGINT;
        UPDATE jiveReward SET creationDate = creationDateTemp;
          ALTER TABLE jiveReward DROP COLUMN creationDateTemp;
            ALTER TABLE jiveReward ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveReadTracker ADD COLUMN readDateTemp BIGINT;
  UPDATE jiveReadTracker SET readDateTemp = TONUMBER(readDate);
    ALTER TABLE jiveReadTracker DROP COLUMN readDate;
      ALTER TABLE jiveReadTracker ADD COLUMN readDate BIGINT;
        UPDATE jiveReadTracker SET readDate = readDateTemp;
          ALTER TABLE jiveReadTracker DROP COLUMN readDateTemp;
            ALTER TABLE jiveReadTracker ALTER COLUMN readDate SET NOT NULL;

ALTER TABLE jiveAttachment ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveAttachment SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveAttachment DROP COLUMN creationDate;
      ALTER TABLE jiveAttachment ADD COLUMN creationDate BIGINT;
        UPDATE jiveAttachment SET creationDate = creationDateTemp;
          ALTER TABLE jiveAttachment DROP COLUMN creationDateTemp;
            ALTER TABLE jiveAttachment ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveAttachment ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jiveAttachment SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jiveAttachment DROP COLUMN modificationDate;
      ALTER TABLE jiveAttachment ADD COLUMN modificationDate BIGINT;
        UPDATE jiveAttachment SET modificationDate = modificationDateTemp;
          ALTER TABLE jiveAttachment DROP COLUMN modificationDateTemp;
            ALTER TABLE jiveAttachment ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN creationDateTemp BIGINT;
  UPDATE jivePoll SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jivePoll DROP COLUMN creationDate;
      ALTER TABLE jivePoll ADD COLUMN creationDate BIGINT;
        UPDATE jivePoll SET creationDate = creationDateTemp;
          ALTER TABLE jivePoll DROP COLUMN creationDateTemp;
            ALTER TABLE jivePoll ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN modificationDateTemp BIGINT;
  UPDATE jivePoll SET modificationDateTemp = TONUMBER(modificationDate);
    ALTER TABLE jivePoll DROP COLUMN modificationDate;
      ALTER TABLE jivePoll ADD COLUMN modificationDate BIGINT;
        UPDATE jivePoll SET modificationDate = modificationDateTemp;
          ALTER TABLE jivePoll DROP COLUMN modificationDateTemp;
            ALTER TABLE jivePoll ALTER COLUMN modificationDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN startDateTemp BIGINT;
  UPDATE jivePoll SET startDateTemp = TONUMBER(startDate);
    ALTER TABLE jivePoll DROP COLUMN startDate;
      ALTER TABLE jivePoll ADD COLUMN startDate BIGINT;
        UPDATE jivePoll SET startDate = startDateTemp;
          ALTER TABLE jivePoll DROP COLUMN startDateTemp;
            ALTER TABLE jivePoll ALTER COLUMN startDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN endDateTemp BIGINT;
  UPDATE jivePoll SET endDateTemp = TONUMBER(endDate);
    ALTER TABLE jivePoll DROP COLUMN endDate;
      ALTER TABLE jivePoll ADD COLUMN endDate BIGINT;
        UPDATE jivePoll SET endDate = endDateTemp;
          ALTER TABLE jivePoll DROP COLUMN endDateTemp;
            ALTER TABLE jivePoll ALTER COLUMN endDate SET NOT NULL;

ALTER TABLE jivePoll ADD COLUMN expireDateTemp BIGINT;
  UPDATE jivePoll SET expireDateTemp = TONUMBER(expireDate);
    ALTER TABLE jivePoll DROP COLUMN expireDate;
      ALTER TABLE jivePoll ADD COLUMN expireDate BIGINT;
        UPDATE jivePoll SET expireDate = expireDateTemp;
          ALTER TABLE jivePoll DROP COLUMN expireDateTemp;
            ALTER TABLE jivePoll ALTER COLUMN expireDate SET NOT NULL;

ALTER TABLE jivePollVote ADD COLUMN voteDateTemp BIGINT;
  UPDATE jivePollVote SET voteDateTemp = TONUMBER(voteDate);
    ALTER TABLE jivePollVote DROP COLUMN voteDate;
      ALTER TABLE jivePollVote ADD COLUMN voteDate BIGINT;
        UPDATE jivePollVote SET voteDate = voteDateTemp;
          ALTER TABLE jivePollVote DROP COLUMN voteDateTemp;
            ALTER TABLE jivePollVote ALTER COLUMN voteDate SET NOT NULL;

ALTER TABLE jiveSearch ADD COLUMN searchDateTemp BIGINT;
  UPDATE jiveSearch SET searchDateTemp = TONUMBER(searchDate);
    ALTER TABLE jiveSearch DROP COLUMN searchDate;
      ALTER TABLE jiveSearch ADD COLUMN searchDate BIGINT;
        UPDATE jiveSearch SET searchDate = searchDateTemp;
          ALTER TABLE jiveSearch DROP COLUMN searchDateTemp;
            ALTER TABLE jiveSearch ALTER COLUMN searchDate SET NOT NULL;

ALTER TABLE jiveSearchClick ADD COLUMN clickDateTemp BIGINT;
  UPDATE jiveSearchClick SET clickDateTemp = TONUMBER(clickDate);
    ALTER TABLE jiveSearchClick DROP CONSTRAINT jiveSearchClick_pk;
    ALTER TABLE jiveSearchClick DROP COLUMN clickDate;
      ALTER TABLE jiveSearchClick ADD COLUMN clickDate BIGINT;
        UPDATE jiveSearchClick SET clickDate = clickDateTemp;
          ALTER TABLE jiveSearchClick DROP COLUMN clickDateTemp;
            ALTER TABLE jiveSearchClick ALTER COLUMN clickDate SET NOT NULL;
            ALTER TABLE jiveSearchClick ADD CONSTRAINT jiveSearchClick_pk PRIMARY KEY (searchID, messageID, clickDate);

ALTER TABLE jiveReadStat ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReadStat SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveReadStat DROP COLUMN creationDate;
      ALTER TABLE jiveReadStat ADD COLUMN creationDate BIGINT;
        UPDATE jiveReadStat SET creationDate = creationDateTemp;
          ALTER TABLE jiveReadStat DROP COLUMN creationDateTemp;
            ALTER TABLE jiveReadStat ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveReadStatSession ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveReadStatSession SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveReadStatSession DROP COLUMN creationDate;
      ALTER TABLE jiveReadStatSession ADD COLUMN creationDate BIGINT;
        UPDATE jiveReadStatSession SET creationDate = creationDateTemp;
          ALTER TABLE jiveReadStatSession DROP COLUMN creationDateTemp;
            ALTER TABLE jiveReadStatSession ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveNNTPReadStatSession ADD COLUMN creationDateTemp BIGINT;
  UPDATE jiveNNTPReadStatSession SET creationDateTemp = TONUMBER(creationDate);
    ALTER TABLE jiveNNTPReadStatSession DROP COLUMN creationDate;
      ALTER TABLE jiveNNTPReadStatSession ADD COLUMN creationDate BIGINT;
        UPDATE jiveNNTPReadStatSession SET creationDate = creationDateTemp;
          ALTER TABLE jiveNNTPReadStatSession DROP COLUMN creationDateTemp;
            ALTER TABLE jiveNNTPReadStatSession ALTER COLUMN creationDate SET NOT NULL;

ALTER TABLE jiveNNTPReadStatSession ADD COLUMN endDateTemp BIGINT;
  UPDATE jiveNNTPReadStatSession SET endDateTemp = TONUMBER(endDate);
    ALTER TABLE jiveNNTPReadStatSession DROP COLUMN endDate;
      ALTER TABLE jiveNNTPReadStatSession ADD COLUMN endDate BIGINT;
        UPDATE jiveNNTPReadStatSession SET endDate = endDateTemp;
          ALTER TABLE jiveNNTPReadStatSession DROP COLUMN endDateTemp;