CREATE UNIQUE INDEX `county_state_unique_idx` ON `locations` (`full_county_name`,`state_code`);
CREATE UNIQUE INDEX `state_unique_idx` ON `locations` (`state_code`) WHERE ("locations"."full_county_name" is null and "locations"."type" = 'state');
CREATE UNIQUE INDEX `county_state_unique_idx` ON `locations` (`full_county_name`,`state_code`);
CREATE UNIQUE INDEX `state_unique_idx` ON `locations` (`state_code`) WHERE ("locations"."full_county_name" is null and "locations"."type" = 'state');