Once bug 1182455 is deployed we need to drop several columns from the datasource table. We can't do this until that bug is deployed, but equally we must do so before the next time we add a new repo we'll get errors due to the columns not being defined in the SQL statements in-repo (since there are no defaults on those columns). Columns to be dropped: * host * read_only_host * type * creation_date eg ALTER TABLE treeherder.datasource DROP COLUMN host, read_only_host, type, creation_date;

Run on Heroku: ALTER TABLE treeherder.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date; Stage: [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell mysql> ALTER TABLE treeherder_stage.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date; Query OK, 0 rows affected (0.22 sec) Records: 0 Duplicates: 0 Warnings: 0

No errors on New Relic; run on prod: [emorley@treeherder-rabbitmq1.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell mysql> ALTER TABLE treeherder.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date; Query OK, 0 rows affected (0.11 sec) Records: 0 Duplicates: 0 Warnings: 0