diff options
| author | Julien Dessaux | 2025-02-19 00:19:58 +0100 |
|---|---|---|
| committer | Julien Dessaux | 2025-02-19 00:19:58 +0100 |
| commit | 312ef2eb5792cd145d6829e2abc017dd304c5819 (patch) | |
| tree | cf782f8356bea73eacb5495631794cf5584e00cb /golang/pkg/database/sql/001_trading.sql | |
| parent | [golang] update error handling and bootstrap trade procurement (diff) | |
| download | spacetraders-312ef2eb5792cd145d6829e2abc017dd304c5819.tar.gz spacetraders-312ef2eb5792cd145d6829e2abc017dd304c5819.tar.bz2 spacetraders-312ef2eb5792cd145d6829e2abc017dd304c5819.zip | |
[golang] implement trading and contracting
Diffstat (limited to 'golang/pkg/database/sql/001_trading.sql')
| -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, |