summaryrefslogtreecommitdiff
path: root/database/002_ships.sql
blob: 629f739def3740aa12b2d9df8ba7a5977cc48970 (plain)
1
2
3
4
5
6
CREATE TABLE ships (
       id INTEGER PRIMARY KEY,
       data JSON NOT NULL,
       updated DATE DEFAULT NULL
);
CREATE UNIQUE INDEX ships_data_symbol on ships (json_extract(data, '$.symbol'));