diff options
| author | Kujtim Hoxha <[email protected]> | 2025-04-17 13:45:26 +0200 |
|---|---|---|
| committer | Kujtim Hoxha <[email protected]> | 2025-04-21 13:42:02 +0200 |
| commit | c24e3c18e0177e2e059f622a63e87249c52db2d5 (patch) | |
| tree | 51900cfe51292d61aa137ea03d43039aff627a71 /internal/db | |
| parent | caea29375994373f6027c8dc4d8aa536c4e135e7 (diff) | |
| download | opencode-c24e3c18e0177e2e059f622a63e87249c52db2d5.tar.gz opencode-c24e3c18e0177e2e059f622a63e87249c52db2d5.zip | |
small improvements
Diffstat (limited to 'internal/db')
| -rw-r--r-- | internal/db/migrations/000001_initial.up.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/internal/db/migrations/000001_initial.up.sql b/internal/db/migrations/000001_initial.up.sql index 4ac297dc5..b846ec600 100644 --- a/internal/db/migrations/000001_initial.up.sql +++ b/internal/db/migrations/000001_initial.up.sql @@ -27,7 +27,8 @@ CREATE TABLE IF NOT EXISTS files ( version TEXT NOT NULL, created_at INTEGER NOT NULL, -- Unix timestamp in milliseconds updated_at INTEGER NOT NULL, -- Unix timestamp in milliseconds - FOREIGN KEY (session_id) REFERENCES sessions (id) ON DELETE CASCADE + FOREIGN KEY (session_id) REFERENCES sessions (id) ON DELETE CASCADE, + UNIQUE(path, session_id, version) ); CREATE INDEX IF NOT EXISTS idx_files_session_id ON files (session_id); |