~aleteoryx/muditaos

ref: 6533aba24ef55cde97a89ef8040b9da21425d571 muditaos/image/user/db/alarms_001.sql -rw-r--r-- 450 bytes
6533aba2 — KacperLewandowski [EGD-4073] Alarms database rework (#1006) 5 years ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE TABLE IF NOT EXISTS alarms(
                  _id INTEGER PRIMARY KEY,
                  time DATETIME,
                  snooze INTEGER,
                  status INTEGER,
                  repeat INTEGER,
                  path TEXT DEFAULT '',
                  FOREIGN KEY(status) REFERENCES alarmStatuses(_id)
);

CREATE TABLE IF NOT EXISTS alarmStatuses(
                  _id INTEGER PRIMARY KEY,
                  name TEXT NOT NULL
);