| beeps | cc9fc70 | 2013-12-02 12:45:38 -0800 | [diff] [blame] | 1 | UP_SQL = """ |
| 2 | ALTER TABLE afe_hosts ADD COLUMN leased TINYINT(1) NOT NULL DEFAULT '1'; | ||||
| 3 | CREATE INDEX leased_hosts ON afe_hosts (leased, locked); | ||||
| 4 | """ | ||||
| 5 | |||||
| 6 | DOWN_SQL = """ | ||||
| 7 | DROP INDEX leased_hosts ON afe_hosts; | ||||
| 8 | ALTER TABLE afe_hosts DROP COLUMN leased; | ||||
| 9 | """ | ||||