summaryrefslogtreecommitdiff
path: root/nodejs/database/001_systems.sql
blob: 9ad76b12567b8af66f2474e05c347cdbf5f0c82c (plain)
1
2
3
4
5
6
CREATE TABLE systems (
       id INTEGER PRIMARY KEY,
       data JSON NOT NULL,
       updated DATE DEFAULT NULL
);
CREATE UNIQUE INDEX systems_data_symbol on systems (json_extract(data, '$.symbol'));