Skip to content

Instantly share code, notes, and snippets.

@Aslan
Created August 30, 2014 00:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Aslan/0b8ca01cc3af55121d7d to your computer and use it in GitHub Desktop.
Save Aslan/0b8ca01cc3af55121d7d to your computer and use it in GitHub Desktop.
## 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment