src/sql/create-recent_files-table.sql
raw| 1 | -- SPDX-FileCopyrightText: 2025 George Florea Bănuș <[email protected]> |
| 2 | -- SPDX-License-Identifier: CC-BY-4.0 |
| 3 | |
| 4 | CREATE TABLE recent_files ( |
| 5 | recent_file_id INTEGER NOT NULL UNIQUE, |
| 6 | url TEXT NOT NULL UNIQUE, |
| 7 | filename TEXT NOT NULL, |
| 8 | opened_from TEXT NOT NULL, |
| 9 | timestamp INTEGER NOT NULL, |
| 10 | PRIMARY KEY(recent_file_id) |
| 11 | ); |