diff options
Diffstat (limited to '')
| -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 |