BEGIN;

SELECT setval('alternatenames_alternatenameid_seq', (SELECT max(alternatenameid) FROM alternatenames));

-- 4m45.368s

-- index alternatenames

CREATE INDEX "alternatenames_alternatename_idx" ON alternateNames (alternateName);

-- 10m42.827s

CREATE INDEX "alternatenames_geonameid_idx" ON alternateNames (geonameid);

COMMIT;