sneak/vaultik
1
0
Fork 0
Code Issues 20 Pull Requests 3 Actions Packages Projects Releases Wiki Activity

uploads table FK on snapshot_id lacks ON DELETE CASCADE #18

New Issue
Open
opened 2026-02-08 17:16:54 +01:00 by clawbot · 0 comments
clawbot commented 2026-02-08 17:16:54 +01:00
Collaborator
Copy Link

In schema.sql, the uploads table has:

FOREIGN KEY (snapshot_id) REFERENCES snapshots(id)

Unlike snapshot_files and snapshot_blobs which have ON DELETE CASCADE, the uploads FK does not cascade. This means deleting a snapshot without first deleting its uploads will fail with a FK violation (if FK enforcement is on). The code works around this by manually deleting uploads first in deleteSnapshotFromLocalDB, but syncWithRemote does NOT do this cleanup.

Ref: parent issue #1

In `schema.sql`, the `uploads` table has: ```sql FOREIGN KEY (snapshot_id) REFERENCES snapshots(id) ``` Unlike `snapshot_files` and `snapshot_blobs` which have `ON DELETE CASCADE`, the `uploads` FK does not cascade. This means deleting a snapshot without first deleting its uploads will fail with a FK violation (if FK enforcement is on). The code works around this by manually deleting uploads first in `deleteSnapshotFromLocalDB`, but `syncWithRemote` does NOT do this cleanup. Ref: parent issue #1
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sneak/vaultik#18
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?