| 1 | -- Git LFS: track which content-addressed objects (by sha256 oid) each repo has |
| 2 | -- stored. The bytes live on disk under storage.lfs_dir, sharded by oid prefix. |
| 3 | CREATE TABLE lfs_objects ( |
| 4 | id TEXT PRIMARY KEY, |
| 5 | repo_id TEXT NOT NULL REFERENCES repos(id) ON DELETE CASCADE, |
| 6 | oid TEXT NOT NULL, |
| 7 | size BIGINT NOT NULL, |
| 8 | created_at BIGINT NOT NULL |
| 9 | ); |
| 10 | CREATE UNIQUE INDEX idx_lfs_objects_repo_oid ON lfs_objects (repo_id, oid); |