30 lines
1.3 KiB
SQL
30 lines
1.3 KiB
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to alter the column `flags` on the `ConsulKVEntry` table. The data in that column could be lost. The data in that column will be cast from `Int` to `BigInt`.
|
|
|
|
*/
|
|
-- RedefineTables
|
|
PRAGMA defer_foreign_keys=ON;
|
|
PRAGMA foreign_keys=OFF;
|
|
CREATE TABLE "new_ConsulKVEntry" (
|
|
"key" TEXT NOT NULL PRIMARY KEY,
|
|
"value" TEXT NOT NULL,
|
|
"flags" BIGINT 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
|
|
);
|
|
INSERT INTO "new_ConsulKVEntry" ("createIndex", "createdAt", "datacenter", "flags", "key", "lockIndex", "modifyIndex", "namespace", "session", "updatedAt", "value") SELECT "createIndex", "createdAt", "datacenter", "flags", "key", "lockIndex", "modifyIndex", "namespace", "session", "updatedAt", "value" FROM "ConsulKVEntry";
|
|
DROP TABLE "ConsulKVEntry";
|
|
ALTER TABLE "new_ConsulKVEntry" RENAME TO "ConsulKVEntry";
|
|
CREATE INDEX "ConsulKVEntry_datacenter_idx" ON "ConsulKVEntry"("datacenter");
|
|
CREATE INDEX "ConsulKVEntry_namespace_idx" ON "ConsulKVEntry"("namespace");
|
|
PRAGMA foreign_keys=ON;
|
|
PRAGMA defer_foreign_keys=OFF;
|