/*
  Warnings:

  - The primary key for the `settings` table will be changed. If it partially fails, the table could be left without primary key constraint.
  - Added the required column `address` to the `reservations` table without a default value. This is not possible if the table is not empty.
  - Added the required column `city` to the `reservations` table without a default value. This is not possible if the table is not empty.
  - Added the required column `country` to the `reservations` table without a default value. This is not possible if the table is not empty.
  - Added the required column `gdpr_consent` to the `reservations` table without a default value. This is not possible if the table is not empty.
  - Added the required column `marketing_consent` to the `reservations` table without a default value. This is not possible if the table is not empty.

*/
-- DropIndex
DROP INDEX "public"."blog_posts_author_id_idx";

-- DropIndex
DROP INDEX "public"."blog_posts_is_published_idx";

-- DropIndex
DROP INDEX "public"."blog_posts_published_at_idx";

-- DropIndex
DROP INDEX "public"."reservations_check_in_idx";

-- DropIndex
DROP INDEX "public"."reservations_check_out_idx";

-- DropIndex
DROP INDEX "public"."reservations_created_at_idx";

-- DropIndex
DROP INDEX "public"."reservations_status_idx";

-- DropIndex
DROP INDEX "public"."room_images_room_id_idx";

-- DropIndex
DROP INDEX "public"."room_images_sort_order_idx";

-- DropIndex
DROP INDEX "public"."rooms_capacity_idx";

-- DropIndex
DROP INDEX "public"."rooms_is_active_idx";

-- AlterTable
ALTER TABLE "public"."blog_categories" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" SET DATA TYPE TEXT,
ALTER COLUMN "slug" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."blog_posts" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "slug" SET DATA TYPE TEXT,
ALTER COLUMN "title" SET DATA TYPE TEXT,
ALTER COLUMN "cover_url" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."blog_tags" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "name" SET DATA TYPE TEXT,
ALTER COLUMN "slug" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."reservations" ADD COLUMN     "address" TEXT NOT NULL,
ADD COLUMN     "city" TEXT NOT NULL,
ADD COLUMN     "country" TEXT NOT NULL,
ADD COLUMN     "gdpr_consent" BOOLEAN NOT NULL,
ADD COLUMN     "marketing_consent" BOOLEAN NOT NULL,
ADD COLUMN     "room_preference" TEXT,
ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "first_name" SET DATA TYPE TEXT,
ALTER COLUMN "last_name" SET DATA TYPE TEXT,
ALTER COLUMN "email" SET DATA TYPE TEXT,
ALTER COLUMN "phone" SET DATA TYPE TEXT,
ALTER COLUMN "status" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."room_images" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "url" SET DATA TYPE TEXT,
ALTER COLUMN "alt_text" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."rooms" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "slug" SET DATA TYPE TEXT,
ALTER COLUMN "title" SET DATA TYPE TEXT,
ALTER COLUMN "bed_type" SET DATA TYPE TEXT,
ALTER COLUMN "view" SET DATA TYPE TEXT;

-- AlterTable
ALTER TABLE "public"."settings" DROP CONSTRAINT "settings_pkey",
ALTER COLUMN "key" SET DATA TYPE TEXT,
ADD CONSTRAINT "settings_pkey" PRIMARY KEY ("key");

-- AlterTable
ALTER TABLE "public"."users" ALTER COLUMN "id" DROP DEFAULT,
ALTER COLUMN "email" SET DATA TYPE TEXT,
ALTER COLUMN "role" SET DATA TYPE TEXT;
