mirror of
https://github.com/lobehub/lobehub.git
synced 2026-09-20 04:56:13 +08:00
Arvin Xu
af1f71572f
* move db * refactor db import * refactor eval types * fix tests * fix tests * fix tests * fix db migration issues * fix docker issue * fix tests * update alias * fix tests * update db test for client and server * refactor db * update codecov * update codecov * update codecov * add docker pr comments
10 lines
841 B
SQL
10 lines
841 B
SQL
ALTER TABLE "messages" ADD COLUMN "client_id" text;--> statement-breakpoint
|
|
ALTER TABLE "session_groups" ADD COLUMN "client_id" text;--> statement-breakpoint
|
|
ALTER TABLE "sessions" ADD COLUMN "client_id" text;--> statement-breakpoint
|
|
ALTER TABLE "topics" ADD COLUMN "client_id" text;--> statement-breakpoint
|
|
CREATE INDEX IF NOT EXISTS "messages_client_id_idx" ON "messages" ("client_id");--> statement-breakpoint
|
|
ALTER TABLE "messages" ADD CONSTRAINT "messages_client_id_unique" UNIQUE("client_id");--> statement-breakpoint
|
|
ALTER TABLE "session_groups" ADD CONSTRAINT "session_groups_client_id_unique" UNIQUE("client_id");--> statement-breakpoint
|
|
ALTER TABLE "sessions" ADD CONSTRAINT "sessions_client_id_unique" UNIQUE("client_id");--> statement-breakpoint
|
|
ALTER TABLE "topics" ADD CONSTRAINT "topics_client_id_unique" UNIQUE("client_id");
|