-- CreateEnum
CREATE TYPE "public"."ZiodicSignEnum" AS ENUM ('ARIES', 'TAURUS', 'GEMINI', 'CANCER', 'LEO', 'VIRGO', 'LIBRA', 'SCORPIO', 'SAGITTARIUS', 'CAPRICORN', 'AQUARIUS', 'PISCES');

-- AlterTable
ALTER TABLE "public"."users" ADD COLUMN     "subscriptionTier" "public"."TierTypeProps" NOT NULL DEFAULT 'FREE_TIER';

-- CreateTable
CREATE TABLE "public"."Astrology" (
    "id" TEXT NOT NULL,
    "zioDicSign" "public"."ZiodicSignEnum" NOT NULL DEFAULT 'GEMINI',
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "Astrology_pkey" PRIMARY KEY ("id")
);
