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;