Calling `drop_table` in deployment migrations can cause downtime as
there might still be code that uses tables.

This MR adds a cop that checks that tables get droppped only in
post-deployment migrations.