-- AlterTable
ALTER TABLE `user_details` ADD COLUMN `car_owner` BOOLEAN NULL DEFAULT false,
    ADD COLUMN `city_id` BIGINT UNSIGNED NULL,
    ADD COLUMN `contratto` ENUM('piva', 'busta_paga') NULL,
    ADD COLUMN `prezzo_max` BIGINT NULL,
    ADD COLUMN `prezzo_min` BIGINT NULL,
    ADD COLUMN `turno` ENUM('mattina', 'pomeriggio', 'giorno', 'h24') NULL;

-- AlterTable
ALTER TABLE `users` ADD COLUMN `imported` BOOLEAN NOT NULL DEFAULT false,
    ADD COLUMN `slug` VARCHAR(100) NULL,
    MODIFY `name` varchar(255) NOT NULL DEFAULT '',
    MODIFY `surname` varchar(255) NOT NULL DEFAULT '';

-- CreateTable
CREATE TABLE `cities` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `nome` VARCHAR(100) NOT NULL,
    `provincia_id` BIGINT UNSIGNED NOT NULL,
    `deleted_at` TIMESTAMP(0) NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,

    INDEX `cities_FK`(`provincia_id` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `contracts` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `deleted_at` TIMESTAMP(0) NULL,

    UNIQUE INDEX `contracts_name_unique`(`name` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `days` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `deleted_at` TIMESTAMP(0) NULL,

    UNIQUE INDEX `tags_name_unique`(`name` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `documents` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `deleted_at` TIMESTAMP(0) NULL,

    UNIQUE INDEX `documents_name_unique`(`name` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `guides` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `type` ENUM('pdf', 'video') NULL,
    `path_name` VARCHAR(255) NULL,
    `youtube_link` VARCHAR(255) NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `name` VARCHAR(100) NULL,
    `path_image` VARCHAR(255) NULL,

    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `reviews` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `from_id` BIGINT NOT NULL,
    `to_id` BIGINT NOT NULL,
    `rating` FLOAT NOT NULL,
    `body` VARCHAR(5000) NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `validated` BOOLEAN NOT NULL DEFAULT false,
    `rating_1` FLOAT NULL,
    `rating_2` FLOAT NULL,
    `rating_3` FLOAT NULL,
    `rating_4` FLOAT NULL,

    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `turni` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `deleted_at` TIMESTAMP(0) NULL,

    UNIQUE INDEX `turni_name_unique`(`name` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `user_detail_contract` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_detail_id` BIGINT UNSIGNED NULL,
    `contract_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,

    INDEX `user_detail_contract_contract_id_foreign`(`contract_id` ASC),
    INDEX `user_detail_contract_user_detail_id_foreign`(`user_detail_id` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `user_detail_day` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_detail_id` BIGINT UNSIGNED NULL,
    `day_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,

    INDEX `user_detail_day_day_id_foreign`(`day_id` ASC),
    INDEX `user_detail_day_user_detail_id_foreign`(`user_detail_id` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `user_detail_turno` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_detail_id` BIGINT UNSIGNED NULL,
    `turno_id` BIGINT UNSIGNED NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,

    INDEX `user_detail_turno_contract_id_foreign`(`turno_id` ASC),
    INDEX `user_detail_turno_user_detail_id_foreign`(`user_detail_id` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `user_document` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `document_id` BIGINT UNSIGNED NOT NULL,
    `user_id` BIGINT UNSIGNED NOT NULL,
    `path_name` VARCHAR(255) NULL,
    `created_at` TIMESTAMP(0) NULL,
    `updated_at` TIMESTAMP(0) NULL,
    `month` BIGINT NULL,
    `year` BIGINT NULL,

    INDEX `document_user_document_id_foreign`(`document_id` ASC),
    INDEX `document_user_user_id_foreign`(`user_id` ASC),
    PRIMARY KEY (`id` ASC)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateIndex
CREATE INDEX `user_details_FK` ON `user_details`(`city_id` ASC);

-- AddForeignKey
ALTER TABLE `cities` ADD CONSTRAINT `cities_FK` FOREIGN KEY (`provincia_id`) REFERENCES `states`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_contract` ADD CONSTRAINT `user_detail_contract_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_contract` ADD CONSTRAINT `user_detail_contract_user_detail_id_foreign` FOREIGN KEY (`user_detail_id`) REFERENCES `user_details`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_day` ADD CONSTRAINT `user_detail_day_day_id_foreign` FOREIGN KEY (`day_id`) REFERENCES `days`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_day` ADD CONSTRAINT `user_detail_day_user_detail_id_foreign` FOREIGN KEY (`user_detail_id`) REFERENCES `user_details`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_turno` ADD CONSTRAINT `user_detail_turno_turno_id_foreign` FOREIGN KEY (`turno_id`) REFERENCES `turni`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_detail_turno` ADD CONSTRAINT `user_detail_turno_user_detail_id_foreign` FOREIGN KEY (`user_detail_id`) REFERENCES `user_details`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_details` ADD CONSTRAINT `user_details_FK` FOREIGN KEY (`city_id`) REFERENCES `cities`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_document` ADD CONSTRAINT `document_user_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `documents`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

-- AddForeignKey
ALTER TABLE `user_document` ADD CONSTRAINT `document_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;