1 UP_SQL = """ 2 ALTER TABLE afe_shards ADD COLUMN hostname VARCHAR(255) NOT NULL; 3 ALTER TABLE afe_hosts ADD COLUMN shard_id INT NULL; 4 ALTER TABLE afe_hosts ADD CONSTRAINT hosts_to_shard_ibfk 5 FOREIGN KEY (shard_id) REFERENCES afe_shards(id); 6 """ 7 8 DOWN_SQL = """ 9 ALTER TABLE afe_hosts DROP FOREIGN KEY hosts_to_shard_ibfk; 10 ALTER TABLE afe_hosts DROP COLUMN shard_id; 11 12 ALTER TABLE afe_shards DROP COLUMN hostname; 13 """ 14
