21 lines
665 B
SQL
21 lines
665 B
SQL
-- CreateTable
|
|
CREATE TABLE "ConsulKVEntry" (
|
|
"key" TEXT NOT NULL PRIMARY KEY,
|
|
"value" TEXT NOT NULL,
|
|
"flags" INTEGER NOT NULL DEFAULT 0,
|
|
"createIndex" INTEGER NOT NULL,
|
|
"modifyIndex" INTEGER NOT NULL,
|
|
"lockIndex" INTEGER NOT NULL DEFAULT 0,
|
|
"session" TEXT,
|
|
"datacenter" TEXT NOT NULL DEFAULT 'dc1',
|
|
"namespace" TEXT NOT NULL DEFAULT 'default',
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" DATETIME NOT NULL
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "ConsulKVEntry_datacenter_idx" ON "ConsulKVEntry"("datacenter");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "ConsulKVEntry_namespace_idx" ON "ConsulKVEntry"("namespace");
|