Skip to content

Instantly share code, notes, and snippets.

@amygdala

amygdala/gist:cffeba6df6043c328d42 Secret

Created February 24, 2011 15:21
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 amygdala/cffeba6df6043c328d42 to your computer and use it in GitHub Desktop.
Save amygdala/cffeba6df6043c328d42 to your computer and use it in GitHub Desktop.
Download ZIP
schema changes to existing tables (streaming3 branch -> streaming 4 branch)
Raw
gistfile1.sql
alter table tu_hashtags drop key hashtag;
alter table tu_hashtags add unique key hashtag (network, hashtag);
alter table tu_post_locations add network varchar(20) not NULL default 'twitter';
alter table tu_post_locations drop index post_id;
alter table tu_post_locations add unique key post_id (network, post_id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment