mirror of
https://github.com/open-reception/appointment-booking-software.git
synced 2026-08-17 21:25:52 +02:00
4 lines
288 B
SQL
4 lines
288 B
SQL
ALTER TABLE "tenant" ADD COLUMN "domain" text;--> statement-breakpoint
|
|
UPDATE "tenant" SET "domain" = CONCAT("short_name", '.open-reception.example.com');
|
|
ALTER TABLE "tenant" ALTER COLUMN "domain" SET NOT NULL;
|
|
ALTER TABLE "tenant" ADD CONSTRAINT "tenant_domain_unique" UNIQUE("domain"); |