CREATE TABLE "email_messages" (
	"id" serial PRIMARY KEY,
	"user_id" text NOT NULL,
	"kind" text NOT NULL,
	"to_email" text NOT NULL,
	"subject" text NOT NULL,
	"reference" text,
	"status" text NOT NULL,
	"error" text,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE INDEX "email_messages_created_idx" ON "email_messages" ("created_at");--> statement-breakpoint
ALTER TABLE "email_messages" ADD CONSTRAINT "email_messages_user_id_accounts_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "accounts"("user_id");--> statement-breakpoint
INSERT INTO "app_settings" ("key", "value", "updated_by") VALUES ('email.address', 'creativeakotoansah@gmail.com', 'setup') ON CONFLICT ("key") DO NOTHING;
