Skip to content

Instantly share code, notes, and snippets.

@zverok
Created September 3, 2013 10:24
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 zverok/6422157 to your computer and use it in GitHub Desktop.
Save zverok/6422157 to your computer and use it in GitHub Desktop.
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
DROP COLUMN `journal_community_id`
DROP COLUMN `journal_user_id`
DROP COLUMN `journal_is_client_journal`
DROP COLUMN `source_id`
DROP COLUMN `source_url`
DROP COLUMN `deleted`
ADD COLUMN `manual_spam` boolean NULL DEFAULT '0'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment