18F_C2.sql

UPDATE proposals SET status = approved  WHERE status = completed
UPDATE versions SET item_type = Steps WHERE item_type = Approval
SELECT proposal_id, user_id FROM observations WHERE user_id IN (SELECT id FROM users) GROUP BY proposal_id, user_id
UPDATE steps SET type = Steps WHERE type = Approvals
UPDATE proposals SET status = canceled  WHERE status = cancelled
UPDATE steps SET type = Steps WHERE type = Approvals
UPDATE steps SET type = Approvals WHERE type = Steps
UPDATE steps SET type = Approvals WHERE type = Steps
UPDATE approvals SET approved_at = updated_at  WHERE status = approved
UPDATE gsa18f_procurements SET recurring_interval = Daily  WHERE recurring_interval IS NULL
CREATE TABLE payload (name text, value blob)
UPDATE steps SET type = Steps WHERE type = Approvals
UPDATE proposals SET status = completed  WHERE status = approved
UPDATE proposals SET status = cancelled  WHERE status = canceled
UPDATE gsa18f_procurements SET recurring = false  WHERE recurring IS NULL
UPDATE gsa18f_procurements SET purchase_type = 0  WHERE purchase_type IS NULL
UPDATE steps SET status = completed  WHERE status = approved
UPDATE steps SET type = Approvals WHERE type = Steps
UPDATE users SET timezone=Eastern  WHERE timezone = UTC
UPDATE steps SET status = approved  WHERE status = completed