diff options
| author | Julien Dessaux | 2025-02-17 00:40:43 +0100 |
|---|---|---|
| committer | Julien Dessaux | 2025-02-17 00:40:43 +0100 |
| commit | bd2fb50c819c2b180758308ef3751e7ea73e6ab7 (patch) | |
| tree | 19632f7098691a1147357039a5efedf7c40a8d53 /golang/pkg/database/sql | |
| parent | [golang] handle paginated requests (diff) | |
| download | spacetraders-bd2fb50c819c2b180758308ef3751e7ea73e6ab7.tar.gz spacetraders-bd2fb50c819c2b180758308ef3751e7ea73e6ab7.tar.bz2 spacetraders-bd2fb50c819c2b180758308ef3751e7ea73e6ab7.zip | |
[golang] implement shipyards visits
Diffstat (limited to 'golang/pkg/database/sql')
| -rw-r--r-- | golang/pkg/database/sql/001_trading.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/golang/pkg/database/sql/001_trading.sql b/golang/pkg/database/sql/001_trading.sql index 68f2568..89dd77c 100644 --- a/golang/pkg/database/sql/001_trading.sql +++ b/golang/pkg/database/sql/001_trading.sql @@ -10,7 +10,12 @@ CREATE TABLE markets ( ); CREATE INDEX markets_systemSymbol on markets (systemSymbol); CREATE UNIQUE INDEX markets_data_symbol on markets(json_extract(data, '$.symbol')); - +CREATE TABLE shipyards ( + id INTEGER PRIMARY KEY, + data JSON NOT NULL, + updated DATE DEFAULT NULL +); +CREATE UNIQUE INDEX shipyards_data_symbol on shipyards (json_extract(data, '$.symbol')); CREATE TABLE systems ( id INTEGER PRIMARY KEY, data JSON NOT NULL |