· 7 years ago · Feb 25, 2019, 03:02 PM
1CREATE TABLE IF NOT EXISTS "Tenants" ("id" UUID NOT NULL , "domain" VARCHAR(255) NOT NULL UNIQUE, "name" VARCHAR(255) NOT NULL, "schema" VARCHAR(255) NOT NULL UNIQUE, "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY ("id"));
2
3INSERT INTO "Tenants" ("id","domain","name","schema","createdAt","updatedAt") VALUES ('3b6b220b-2690-4279-8343-cbe6167f7596','test1.stage-domain.io','Test1','test1','2019-02-25 14:29:33.475 +00:00','2019-02-25 14:29:33.475 +00:00') RETURNING *;