diff options
| -rw-r--r-- | haskell/src/SpaceTraders/Database/000_init.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/haskell/src/SpaceTraders/Database/000_init.sql b/haskell/src/SpaceTraders/Database/000_init.sql index 78a62cd..08a8553 100644 --- a/haskell/src/SpaceTraders/Database/000_init.sql +++ b/haskell/src/SpaceTraders/Database/000_init.sql @@ -13,11 +13,14 @@ CREATE TABLE contracts ( id INTEGER PRIMARY KEY, data TEXT NOT NULL ); +CREATE UNIQUE INDEX contracts_data_id ON contracts (json_extract(data, '$.id')); +CREATE UNIQUE INDEX contracts_data_fulfilled ON contracts (json_extract(data, '$.fulfilled')); CREATE TABLE ships ( id INTEGER PRIMARY KEY, data TEXT NOT NULL ); CREATE UNIQUE INDEX ships_data_symbol ON ships (json_extract(data, '$.symbol')); +CREATE INDEX ships_data_nav_systemSymbol ON ships (json_extract(data, '$.nav.systemSymbol')); CREATE TABLE systems ( id INTEGER PRIMARY KEY, data TEXT NOT NULL |