graphicek/server/database/migrations/1661668805489_sensors_table...

8 lines
198 B
SQL

CREATE TABLE IF NOT EXISTS sensors (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
auth_key TEXT NOT NULL,
/* Temporary column used for migration */
ident TEXT NOT NULL
);