nodejs/database/005_shipyards.sql


1
2
3
4
5
6

CREATE TABLE shipyards (
       id INTEGER PRIMARY KEY,
       data JSON NOT NULL,
       updated DATE DEFAULT NULL
);
CREATE UNIQUE INDEX shipyards_data_symbol on shipyards (json_extract(data, '$.symbol'));