ushahidi/pingapp — pull request #74 by dkobia (2013-10-14 22:58:31+00:00)
Title: Incorrect Index updated

* incorrect index on contacts resulted in contact dupes
* added unique index on contact+type
* closes #73

* removing dupes and fixing re-ping query dealt with non-stop pings after user has responded
* closes #70

* added an 'optin' and 'unsubscribe' column to contacts table for subscription handling via email