mirror of
https://github.com/duplicati/duplicati.git
synced 2025-11-28 11:30:24 +08:00
568cc60856
- Fixed SQL to create temp table for lookup of last backup's file entries - Removed temp table by writing directly to internal lookup struct. - Direct lookup of single file entries from DB
29 lines
No EOL
864 B
SQL
29 lines
No EOL
864 B
SQL
BEGIN TRANSACTION;
|
|
|
|
DROP INDEX "FilesetentryIndex";
|
|
|
|
ALTER TABLE "FilesetEntry"
|
|
RENAME TO "UPGRADE_FilesetEntry";
|
|
|
|
-- ["WITHOUT ROWID" works with SQLite v3.8.2 (eq System.Data.SQLite v1.0.90.0, rel 2013-12-23) and later]
|
|
CREATE TABLE "FilesetEntry" (
|
|
"FilesetID" INTEGER NOT NULL,
|
|
"FileID" INTEGER NOT NULL,
|
|
"Lastmodified" INTEGER NOT NULL,
|
|
CONSTRAINT "FilesetEntry_PK_FilesetIdFileId" PRIMARY KEY ("FilesetID", "FileID")
|
|
) {#if sqlite_version >= 3.8.2} WITHOUT ROWID {#endif};
|
|
|
|
INSERT INTO "FilesetEntry" ("FilesetID", "FileID", "Lastmodified")
|
|
SELECT "FilesetID", "FileID", "Lastmodified"
|
|
FROM "UPGRADE_FilesetEntry";
|
|
|
|
DROP TABLE "UPGRADE_FilesetEntry";
|
|
|
|
/* Improved reverse lookup for joining Fileset and File table */
|
|
CREATE INDEX "FilesetentryFileIdIndex" on "FilesetEntry" ("FileID");
|
|
|
|
UPDATE "Version" SET "Version" = 6;
|
|
|
|
COMMIT;
|
|
|
|
VACUUM; |