gistfile1.sql

## Cornice migration phase one 
ALTER TABLE engagements                      ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE engagement_interactions          ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE tracking_events                  ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE tracking_events                  ADD COLUMN creative_id integer DEFAULT NULL encode RAW;
ALTER TABLE partner_revenue_events           ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE advertiser_cost_events           ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE session_recordings               ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE engagement_quality_calculations  ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;
ALTER TABLE feedbacks                        ADD COLUMN campaign_id integer DEFAULT NULL encode RAW;