summaryrefslogtreecommitdiff
path: root/database/001_systems.sql
blob: 844895500eec1229bdf82b123183b9dcd395130c (plain)
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'))
);