diff options
author | Julien Dessaux | 2023-05-31 01:19:31 +0200 |
---|---|---|
committer | Julien Dessaux | 2023-05-31 01:19:31 +0200 |
commit | 61b5c8493e57c73469f31a795037922bd9d34931 (patch) | |
tree | 2bfc62120d393efa0664111997dec6e23bcd6642 /database/001_systems.sql | |
parent | Refactoring (diff) | |
download | spacetraders-61b5c8493e57c73469f31a795037922bd9d34931.tar.gz spacetraders-61b5c8493e57c73469f31a795037922bd9d34931.tar.bz2 spacetraders-61b5c8493e57c73469f31a795037922bd9d34931.zip |
Reworked the systems handling and caching with sqlite
Diffstat (limited to '')
-rw-r--r-- | database/001_systems.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/database/001_systems.sql b/database/001_systems.sql index 8448955..9ad76b1 100644 --- a/database/001_systems.sql +++ b/database/001_systems.sql @@ -1,6 +1,6 @@ CREATE TABLE systems ( id INTEGER PRIMARY KEY, - symbol TEXT NOT NULL UNIQUE, - data TEXT NOT NULL, - updated DATE DEFAULT (datetime('now')) + data JSON NOT NULL, + updated DATE DEFAULT NULL ); +CREATE UNIQUE INDEX systems_data_symbol on systems (json_extract(data, '$.symbol')); |