diff options
Diffstat (limited to 'nodejs/database/002_ships.sql')
-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')); |