Skip to content

Instantly share code, notes, and snippets.

@zverok

zverok/gist:6422227

Created September 3, 2013 10:33
Show Gist options
  • Save zverok/6422227 to your computer and use it in GitHub Desktop.
Save zverok/6422227 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
ALTER TABLE mentions_client_2 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';
ALTER TABLE mentions_client_3 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';
ALTER TABLE mentions_client_4 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';
ALTER TABLE mentions_client_5 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';
ALTER TABLE mentions_client_7 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';
ALTER TABLE mentions_client_16 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';
ALTER TABLE mentions_client_2139 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';
ALTER TABLE mentions_client_2142 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';
ALTER TABLE mentions_client_2143 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';
ALTER TABLE mentions_client_2145 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';
ALTER TABLE mentions_client_2150 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';
ALTER TABLE mentions_client_2151 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';
ALTER TABLE mentions_client_2152 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';
ALTER TABLE mentions_client_2157 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';
ALTER TABLE mentions_client_2158 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';
ALTER TABLE mentions_client_2159 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';
ALTER TABLE mentions_client_2160 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';
ALTER TABLE mentions_client_2161 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';
ALTER TABLE mentions_client_2162 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';
ALTER TABLE mentions_client_2164 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';
ALTER TABLE mentions_client_2174 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';
ALTER TABLE mentions_client_2175 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';
ALTER TABLE mentions_client_2188 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';
ALTER TABLE mentions_client_2189 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';
ALTER TABLE mentions_client_2190 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';
ALTER TABLE mentions_client_2192 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';
ALTER TABLE mentions_client_2193 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';
ALTER TABLE mentions_client_2194 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';
ALTER TABLE mentions_client_2195 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';
ALTER TABLE mentions_client_2196 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';
ALTER TABLE mentions_client_2197 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';
ALTER TABLE mentions_client_2198 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';
ALTER TABLE mentions_client_2199 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';
ALTER TABLE mentions_client_2200 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';
ALTER TABLE mentions_client_2201 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';
ALTER TABLE mentions_client_2202 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';
ALTER TABLE mentions_client_2203 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';
ALTER TABLE mentions_client_2204 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';
ALTER TABLE mentions_client_2205 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';
ALTER TABLE mentions_client_2206 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';
ALTER TABLE mentions_client_2207 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';
ALTER TABLE mentions_client_2208 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';
ALTER TABLE mentions_client_2209 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';
ALTER TABLE mentions_client_2210 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';
ALTER TABLE mentions_client_2211 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';
ALTER TABLE mentions_client_2212 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';
ALTER TABLE mentions_client_2213 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';
ALTER TABLE mentions_client_2214 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';
ALTER TABLE mentions_client_2215 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';
ALTER TABLE mentions_client_2216 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';
ALTER TABLE mentions_client_2217 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';
ALTER TABLE mentions_client_2218 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';
ALTER TABLE mentions_client_2219 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';
ALTER TABLE mentions_client_2220 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';
ALTER TABLE mentions_client_2222 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';
ALTER TABLE mentions_client_2223 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';
ALTER TABLE mentions_client_2224 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';
ALTER TABLE mentions_client_2227 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';
ALTER TABLE mentions_client_2228 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';
ALTER TABLE mentions_client_2229 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';
ALTER TABLE mentions_client_2231 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';
ALTER TABLE mentions_client_2232 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';
ALTER TABLE mentions_client_2233 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';
ALTER TABLE mentions_client_2234 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';
ALTER TABLE mentions_client_2237 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';
ALTER TABLE mentions_client_2238 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';
ALTER TABLE mentions_client_2239 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';
ALTER TABLE mentions_client_2241 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';
ALTER TABLE mentions_client_2242 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