migration00003.sql 295 Bytes
Newer Older
David Morley's avatar
David Morley committed
1
CREATE INDEX idx_clicks ON clicks (domain);
dmorley's avatar
dmorley committed
2 3 4 5 6 7 8 9 10 11 12
UPDATE pods SET status=0 WHERE status = 'Down';
UPDATE pods SET status=1 WHERE status = 'Up';
/*
0 = Down
1 = Up
2 = Recheck
3 = Paused
4 = System Deleted
5 = User Deleted
*/
ALTER TABLE pods ALTER COLUMN status TYPE smallint USING status::smallint;
David Morley's avatar
David Morley committed
13