mirror of
https://github.com/paperclipai/paperclip.git
synced 2026-10-12 08:19:54 +02:00
DottaandPaperclip
6abeb67334
Add dormant provider contracts, qualified patched adapters, tenant-scoped persistence and lifecycle ownership without activating chat routes. Preserve the experimental integration as dependent PR #13038. Co-Authored-By: Paperclip <noreply@paperclip.ing>
8 lines
976 B
SQL
8 lines
976 B
SQL
DROP INDEX "chat_message_links_provider_message_uq";--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "chat_endpoints_live_bot_external_uq" ON "chat_endpoints" USING btree ("provider","provider_account_id","bot_external_id") WHERE "chat_endpoints"."status" in ('verifying', 'active', 'paused', 'attention')
|
|
and "chat_endpoints"."provider_account_id" is not null
|
|
and "chat_endpoints"."bot_external_id" is not null;--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "chat_endpoints_live_bot_username_uq" ON "chat_endpoints" USING btree ("provider","provider_account_id","bot_username") WHERE "chat_endpoints"."status" in ('verifying', 'active', 'paused', 'attention')
|
|
and "chat_endpoints"."provider_account_id" is not null
|
|
and "chat_endpoints"."bot_username" is not null;--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "chat_message_links_provider_message_uq" ON "chat_message_links" USING btree ("endpoint_id","conversation_id","provider_message_id"); |