ALTER TABLE "posts" DROP CONSTRAINT "posts_topic_check";--> statement-breakpoint
ALTER TABLE "posts" DROP CONSTRAINT "posts_status_check";--> statement-breakpoint
ALTER TABLE "reactions" DROP CONSTRAINT "reactions_reaction_type_check";--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "first_name" text DEFAULT '';--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "last_name" text DEFAULT '';--> statement-breakpoint
ALTER TABLE "posts" ADD CONSTRAINT "posts_topic_check" CHECK (topic IN ('foto', 'kort', 'kbhplus', 'opinion', 'indhold', 'visioner', 'byens-rum', 'byens-liv', 'projekter', 'anmeldelser'));--> statement-breakpoint
ALTER TABLE "posts" ADD CONSTRAINT "posts_status_check" CHECK (status IN ('draft', 'published', 'archived'));--> statement-breakpoint
ALTER TABLE "reactions" ADD CONSTRAINT "reactions_reaction_type_check" CHECK (reaction_type IN ('like', 'dislike'));