diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2015-11-16 18:46:56 +0100 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2015-11-16 18:46:56 +0100 |
commit | dda9ef2ae7971bceaa792e328c8489cb0695b77e (patch) | |
tree | f4ce29c170dbd4af136418949a857eb9e89154ca /migrations/sqls | |
parent | f17922bcafe1f2f369c9be0f236570771c8ab214 (diff) | |
download | diller-server-dda9ef2ae7971bceaa792e328c8489cb0695b77e.tar.gz diller-server-dda9ef2ae7971bceaa792e328c8489cb0695b77e.tar.bz2 diller-server-dda9ef2ae7971bceaa792e328c8489cb0695b77e.tar.xz diller-server-dda9ef2ae7971bceaa792e328c8489cb0695b77e.zip |
core:
o Adding device_status table containing the latest device status.
mqtt:
o Listening on $SYS/broker/log, parse out messages about clients connecting and disconnecting and store in database.
Diffstat (limited to 'migrations/sqls')
-rw-r--r-- | migrations/sqls/20151115192327-device-online-down.sql | 1 | ||||
-rw-r--r-- | migrations/sqls/20151115192327-device-online-up.sql | 10 |
2 files changed, 11 insertions, 0 deletions
diff --git a/migrations/sqls/20151115192327-device-online-down.sql b/migrations/sqls/20151115192327-device-online-down.sql new file mode 100644 index 0000000..44f074e --- /dev/null +++ b/migrations/sqls/20151115192327-device-online-down.sql @@ -0,0 +1 @@ +/* Replace with your SQL commands */
\ No newline at end of file diff --git a/migrations/sqls/20151115192327-device-online-up.sql b/migrations/sqls/20151115192327-device-online-up.sql new file mode 100644 index 0000000..bd80a63 --- /dev/null +++ b/migrations/sqls/20151115192327-device-online-up.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS device_status; +CREATE UNLOGGED TABLE device_status( + device BIGINT PRIMARY KEY REFERENCES device, + online BOOLEAN NOT NULL, + timestamp TIMESTAMPTZ NOT NULL, + host VARCHAR(1000) +); + +INSERT INTO device_status(device, online, timestamp) +SELECT id, false, created_timestamp FROM device; |