Skip to content

Instantly share code, notes, and snippets.

@johannilsson

johannilsson/phplifestream fix for createUniqueId.sql

Created March 27, 2009 07:09
Show Gist options
  • Save johannilsson/86582 to your computer and use it in GitHub Desktop.
Save johannilsson/86582 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
phplifestream fix for createUniqueId.sql
# This is a bug fix for http://github.com/johannilsson/phplifestream/commit/bec96770f848f68a48a4e20339fe13ee5f556853 that is now reverted.
DELETE FROM tagged_streams WHERE stream_id IN (SELECT id FROM streams WHERE unique_id = SHA1( CONCAT( content_unique_id, service_id)));
DELETE FROM streams WHERE unique_id = SHA1( CONCAT( content_unique_id, service_id ) );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment