diff options
author | Julien Dessaux | 2023-09-12 23:06:10 +0200 |
---|---|---|
committer | Julien Dessaux | 2023-09-12 23:06:39 +0200 |
commit | e52662f829cecb71ec4dd7624df948b0f7e62de9 (patch) | |
tree | 83b1a159c2718f0c90534d2fff6910b00036f650 /nodejs/database/002_ships.sql | |
parent | [javascript] implement the api call to fetch information about all ships (diff) | |
download | spacetraders-e52662f829cecb71ec4dd7624df948b0f7e62de9.tar.gz spacetraders-e52662f829cecb71ec4dd7624df948b0f7e62de9.tar.bz2 spacetraders-e52662f829cecb71ec4dd7624df948b0f7e62de9.zip |
[javascript] added database function to fetch all the ships present in a specific system
Diffstat (limited to '')
-rw-r--r-- | nodejs/database/002_ships.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/nodejs/database/002_ships.sql b/nodejs/database/002_ships.sql index 32b6ffb..402adef 100644 --- a/nodejs/database/002_ships.sql +++ b/nodejs/database/002_ships.sql @@ -3,3 +3,4 @@ CREATE TABLE ships ( data JSON 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')); |