-- fix locidispid should be bigint

ALTER TABLE connections DROP COLUMN locidispid;
ALTER TABLE connections ADD COLUMN locidispid BIGINT;
ALTER TABLE connections ALTER COLUMN locidispid SET NOT NULL;
CREATE INDEX connections_locidispid_ndx ON connections (locidispid);