t3-code-android-nightly/infra/relay/migrations/postgres/20260603035812_managed_endpoint_allocations/migration.sql
Julius Marminge 5ae77c0d63
feat(relay): Add managed relay tunnels and APN service (#2837)
Co-authored-by: codex <codex@users.noreply.github.com>
2026-06-04 19:53:56 -07:00

15 lines
No EOL
720 B
SQL

CREATE TABLE "relay_managed_endpoint_allocations" (
"user_id" varchar(191),
"environment_id" varchar(191),
"hostname" text NOT NULL,
"tunnel_id" varchar(191),
"tunnel_name" text NOT NULL,
"dns_record_id" varchar(191),
"ready_at" varchar(64),
"created_at" varchar(64) NOT NULL,
"updated_at" varchar(64) NOT NULL,
CONSTRAINT "relay_managed_endpoint_allocations_pkey" PRIMARY KEY("user_id","environment_id")
);
--> statement-breakpoint
CREATE UNIQUE INDEX "idx_relay_managed_endpoint_allocations_hostname" ON "relay_managed_endpoint_allocations" ("hostname");--> statement-breakpoint
CREATE UNIQUE INDEX "idx_relay_managed_endpoint_allocations_tunnel_name" ON "relay_managed_endpoint_allocations" ("tunnel_name");