mirror of
https://github.com/duplicati/duplicati.git
synced 2025-11-28 11:30:24 +08:00
18 lines
No EOL
604 B
SQL
18 lines
No EOL
604 B
SQL
CREATE TABLE "Remotevolume_Temp" (
|
|
"ID" INTEGER PRIMARY KEY,
|
|
"OperationID" INTEGER NOT NULL,
|
|
"Name" TEXT NOT NULL,
|
|
"Type" TEXT NOT NULL,
|
|
"Size" INTEGER NULL,
|
|
"Hash" TEXT NULL,
|
|
"State" TEXT NOT NULL,
|
|
"VerificationCount" INTEGER NOT NULL,
|
|
"DeleteGraceTime" INTEGER NOT NULL,
|
|
"ArchiveTime" INTEGER NOT NULL
|
|
);
|
|
|
|
INSERT INTO "RemoteVolume_Temp" SELECT "ID", "OperationID", "Name", "Type", "Size", "Hash", "State", "VerificationCount", "DeleteGraceTime", 0 FROM "RemoteVolume";
|
|
DROP TABLE "RemoteVolume";
|
|
ALTER TABLE "RemoteVolume_Temp" RENAME TO "RemoteVolume";
|
|
|
|
UPDATE "Version" SET "Version" = 15; |