CREATE TABLE "chat_messages" (
	"id" serial PRIMARY KEY,
	"user_id" text NOT NULL,
	"sender" text NOT NULL,
	"body" text NOT NULL,
	"admin_email" text,
	"read_at" timestamp with time zone,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE INDEX "chat_messages_user_created_idx" ON "chat_messages" ("user_id","created_at");--> statement-breakpoint
ALTER TABLE "chat_messages" ADD CONSTRAINT "chat_messages_user_id_accounts_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "accounts"("user_id");