-- CreateTable
CREATE TABLE `service_zones` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `code` VARCHAR(50) NOT NULL,
    `name` VARCHAR(150) NOT NULL,
    `city` VARCHAR(120) NOT NULL,
    `state` VARCHAR(120) NOT NULL,
    `country` VARCHAR(100) NOT NULL DEFAULT 'India',
    `centerLat` DECIMAL(10, 7) NULL,
    `centerLng` DECIMAL(10, 7) NULL,
    `radiusKm` DECIMAL(8, 2) NULL,
    `timezone` VARCHAR(80) NOT NULL DEFAULT 'Asia/Kolkata',
    `status` ENUM('ACTIVE', 'INACTIVE') NOT NULL DEFAULT 'ACTIVE',
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `service_zones_publicId_key`(`publicId`),
    UNIQUE INDEX `service_zones_code_key`(`code`),
    INDEX `service_zones_city_state_idx`(`city`, `state`),
    INDEX `service_zones_status_idx`(`status`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `vehicle_categories` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `code` VARCHAR(40) NOT NULL,
    `name` VARCHAR(100) NOT NULL,
    `description` VARCHAR(255) NULL,
    `vehicleType` ENUM('BIKE', 'AUTO', 'MINI', 'SEDAN', 'SUV', 'XL', 'PREMIUM') NOT NULL,
    `seatingCapacity` INTEGER NULL,
    `sortOrder` INTEGER NOT NULL DEFAULT 0,
    `iconUrl` VARCHAR(500) NULL,
    `status` ENUM('ACTIVE', 'INACTIVE') NOT NULL DEFAULT 'ACTIVE',
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `vehicle_categories_publicId_key`(`publicId`),
    UNIQUE INDEX `vehicle_categories_code_key`(`code`),
    INDEX `vehicle_categories_vehicleType_idx`(`vehicleType`),
    INDEX `vehicle_categories_status_sortOrder_idx`(`status`, `sortOrder`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `fare_rules` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `serviceZoneId` BIGINT NOT NULL,
    `vehicleCategoryId` BIGINT NOT NULL,
    `ruleType` ENUM('STANDARD', 'AIRPORT', 'RENTAL', 'OUTSTATION') NOT NULL DEFAULT 'STANDARD',
    `baseFare` DECIMAL(12, 2) NOT NULL,
    `baseDistanceKm` DECIMAL(8, 2) NOT NULL DEFAULT 0,
    `perKmRate` DECIMAL(12, 2) NOT NULL,
    `perMinuteRate` DECIMAL(12, 2) NOT NULL DEFAULT 0,
    `minimumFare` DECIMAL(12, 2) NOT NULL,
    `bookingFee` DECIMAL(12, 2) NOT NULL DEFAULT 0,
    `waitingFreeMinutes` INTEGER NOT NULL DEFAULT 0,
    `waitingPerMinute` DECIMAL(12, 2) NOT NULL DEFAULT 0,
    `cancellationFee` DECIMAL(12, 2) NOT NULL DEFAULT 0,
    `driverAllowance` DECIMAL(12, 2) NOT NULL DEFAULT 0,
    `nightChargePercent` DECIMAL(6, 2) NOT NULL DEFAULT 0,
    `surgeMultiplierMax` DECIMAL(6, 2) NOT NULL DEFAULT 1,
    `taxPercent` DECIMAL(6, 2) NOT NULL DEFAULT 0,
    `effectiveFrom` DATETIME(3) NOT NULL,
    `effectiveTo` DATETIME(3) NULL,
    `status` ENUM('ACTIVE', 'INACTIVE') NOT NULL DEFAULT 'ACTIVE',
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `fare_rules_publicId_key`(`publicId`),
    INDEX `fare_rules_serviceZoneId_vehicleCategoryId_status_idx`(`serviceZoneId`, `vehicleCategoryId`, `status`),
    INDEX `fare_rules_ruleType_idx`(`ruleType`),
    INDEX `fare_rules_effectiveFrom_effectiveTo_idx`(`effectiveFrom`, `effectiveTo`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `fare_rules` ADD CONSTRAINT `fare_rules_serviceZoneId_fkey` FOREIGN KEY (`serviceZoneId`) REFERENCES `service_zones`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `fare_rules` ADD CONSTRAINT `fare_rules_vehicleCategoryId_fkey` FOREIGN KEY (`vehicleCategoryId`) REFERENCES `vehicle_categories`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

