-- CreateTable
CREATE TABLE `us_zip_codes` (
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `zip` VARCHAR(10) NOT NULL,
    `city` VARCHAR(128) NOT NULL,
    `stateCode` VARCHAR(2) NOT NULL,
    `stateName` VARCHAR(64) NOT NULL,
    `county` VARCHAR(128) NULL,
    `latitude` DOUBLE NULL,
    `longitude` DOUBLE NULL,

    UNIQUE INDEX `us_zip_codes_zip_city_state_key`(`zip`, `city`, `stateCode`),
    INDEX `us_zip_codes_zip_idx`(`zip`),
    INDEX `us_zip_codes_city_stateCode_idx`(`city`, `stateCode`),
    INDEX `us_zip_codes_stateCode_idx`(`stateCode`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
