Skip to content

Instantly share code, notes, and snippets.

@brianherbert

brianherbert/duplicate_feed_fix.sql

Created July 10, 2012 07:52
Show Gist options
  • Save brianherbert/3081924 to your computer and use it in GitHub Desktop.
Save brianherbert/3081924 to your computer and use it in GitHub Desktop.
Download ZIP
Add a unique key to feed item in an Ushahidi deployment destroying duplicates
Raw
duplicate_feed_fix.sql
ALTER IGNORE TABLE `feed_item` ADD UNIQUE INDEX `name` (`item_link`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment