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

8 lines
198 B
MySQL
Raw Permalink Normal View History

2022-08-28 11:56:03 +02:00
CREATE TABLE IF NOT EXISTS sensors (
id INTEGER PRIMARY KEY AUTOINCREMENT,
2022-08-28 11:56:03 +02:00
name TEXT NOT NULL,
auth_key TEXT NOT NULL,
/* Temporary column used for migration */
ident TEXT NOT NULL
);