diff options
| author | Julien Dessaux | 2023-06-02 00:00:09 +0200 |
|---|---|---|
| committer | Julien Dessaux | 2023-06-02 00:00:09 +0200 |
| commit | 7008c91c6fb74f7106c4d9903849d3f1fc17b2f1 (patch) | |
| tree | a180768c196025bb4b4e5b27c81a3e1a521bb40d /database/002_ships.sql | |
| parent | Another big refactoring (diff) | |
| download | spacetraders-7008c91c6fb74f7106c4d9903849d3f1fc17b2f1.tar.gz spacetraders-7008c91c6fb74f7106c4d9903849d3f1fc17b2f1.tar.bz2 spacetraders-7008c91c6fb74f7106c4d9903849d3f1fc17b2f1.zip | |
Improved ships lib with ships db caching
Diffstat (limited to 'database/002_ships.sql')
| -rw-r--r-- | database/002_ships.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/database/002_ships.sql b/database/002_ships.sql new file mode 100644 index 0000000..629f739 --- /dev/null +++ b/database/002_ships.sql @@ -0,0 +1,6 @@ +CREATE TABLE ships ( + id INTEGER PRIMARY KEY, + data JSON NOT NULL, + updated DATE DEFAULT NULL +); +CREATE UNIQUE INDEX ships_data_symbol on ships (json_extract(data, '$.symbol')); |