-- $Id: pgsql.sql 2369 2012-08-01 21:06:31Z jberanek $

-- Fixes a mistake in the previous upgrade.  If we've got an individual member of a
-- series that has been modified, ie has entry_type=2, then the sequence number 
-- cannot be 0.   We will set it to 1.

ALTER TABLE %DB_TBL_PREFIX%entry ADD COLUMN saved_ts DATETIME;
UPDATE %DB_TBL_PREFIX%entry SET saved_ts=timestamp;
UPDATE %DB_TBL_PREFIX%entry 
  SET ical_sequence=1 WHERE ical_sequence=0 AND entry_type=2;
UPDATE %DB_TBL_PREFIX%entry SET timestamp=saved_ts;
ALTER TABLE %DB_TBL_PREFIX%entry DROP COLUMN saved_ts;
