11 lines
338 B
SQL
11 lines
338 B
SQL
CREATE TABLE "configuracoes" (
|
|
"id" TEXT NOT NULL,
|
|
"chave" TEXT NOT NULL,
|
|
"valor" JSONB NOT NULL,
|
|
"criadoEm" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"atualizadoEm" TIMESTAMP(3) NOT NULL,
|
|
CONSTRAINT "configuracoes_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
CREATE UNIQUE INDEX "configuracoes_chave_key" ON "configuracoes"("chave");
|