-- Bot direct conversations support
-- Allows bot_direct conversation type and stores bot messages with null authorId

ALTER TABLE "conversation_messages" ALTER COLUMN "author_id" DROP NOT NULL;--> statement-breakpoint
ALTER TABLE "conversations" ALTER COLUMN "type" SET DATA TYPE varchar(20);--> statement-breakpoint
ALTER TABLE "conversation_messages" ADD COLUMN IF NOT EXISTS "bot_id" integer;--> statement-breakpoint
ALTER TABLE "conversations" ADD COLUMN IF NOT EXISTS "bot_id" integer;