Gitiles
Code Review
Sign In
gerrit-public.fairphone.software
/
platform
/
external
/
autotest
/
8b110eeff624e9724c1b717394d0828b3371221f
/
.
/
frontend
/
migrations
/
085_lease_hosts.py
blob: fd277bb4a0835bfa53981dc5ccc4ebae2f19567e [
file
] [
log
] [
blame
]
UP_SQL
=
"""
ALTER TABLE afe_hosts ADD COLUMN leased TINYINT(1) NOT NULL DEFAULT '1';
CREATE INDEX leased_hosts ON afe_hosts (leased, locked);
"""
DOWN_SQL
=
"""
DROP INDEX leased_hosts ON afe_hosts;
ALTER TABLE afe_hosts DROP COLUMN leased;
"""