ALTER TABLE download_trackers ADD COLUMN fingerprint VARCHAR(1000); CREATE INDEX index_download_trackers_on_fingerprint ON download_trackers USING btree (fingerprint); ALTER TABLE download_trackers ADD COLUMN is_client BOOLEAN DEFAULT FALSE;