CREATE TYPE "public"."age_range" AS ENUM('under_18', '18_25', '26_30', '31_35', '36_plus');--> statement-breakpoint
CREATE TYPE "public"."user_role" AS ENUM('user', 'admin');--> statement-breakpoint
CREATE TABLE "profiles" (
	"id" uuid PRIMARY KEY NOT NULL,
	"email" text NOT NULL,
	"full_name" text,
	"role" "user_role" DEFAULT 'user' NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL,
	CONSTRAINT "profiles_email_unique" UNIQUE("email")
);
--> statement-breakpoint
ALTER TABLE "registrations" ADD COLUMN "age_range" "age_range" NOT NULL;--> statement-breakpoint
ALTER TABLE "registrations" ADD COLUMN "referral_code" text;--> statement-breakpoint
ALTER TABLE "registrations" DROP COLUMN "date_of_birth";--> statement-breakpoint
ALTER TABLE "registrations" DROP COLUMN "state";--> statement-breakpoint
ALTER TABLE "registrations" DROP COLUMN "experience";