diff options
Diffstat (limited to '')
| -rw-r--r-- | golang/pkg/database/sql/001_trading.sql | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/golang/pkg/database/sql/001_trading.sql b/golang/pkg/database/sql/001_trading.sql index 89dd77c..e218962 100644 --- a/golang/pkg/database/sql/001_trading.sql +++ b/golang/pkg/database/sql/001_trading.sql @@ -4,11 +4,9 @@ CREATE TABLE agents ( ); CREATE TABLE markets ( id INTEGER PRIMARY KEY, - systemSymbol TEXT NOT NULL, data JSON NOT NULL, updated DATE NOT NULL ); -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, |