database/001_systems.sql


1
2
3
4
5
6

CREATE TABLE systems (
       id INTEGER PRIMARY KEY,
       symbol TEXT NOT NULL UNIQUE,
       data TEXT NOT NULL,
       updated DATE DEFAULT (datetime('now'))
);