IoT - Kubus / Mbed 2 deprecated Kubus

JNP3 16/17

Dependencies:   mbed nRF24L01P

Diff: server/kubus.sql

Revision:
35:0f01042765d6
Parent:
16:1569130916f1
--- a/server/kubus.sql	Tue Jan 17 11:44:16 2017 +0100
+++ b/server/kubus.sql	Tue Jan 17 11:50:16 2017 +0100
@@ -1,19 +1,23 @@
 CREATE TABLE pir1 (
   id INTEGER PRIMARY KEY,
-  value INTEGER NOT NULL
+  value INTEGER NOT NULL,
+  timestamp DATE
 );
 
 CREATE TABLE pir2 (
   id INTEGER PRIMARY KEY,
-  value INTEGER NOT NULL
+  value INTEGER NOT NULL,
+  timestamp DATE
 );
 
 CREATE TABLE distance (
   id INTEGER PRIMARY KEY,
-  value REAL NOT NULL
+  value REAL NOT NULL,
+  timestamp DATE
 );
 
 CREATE TABLE volume (
   id INTEGER PRIMARY KEY,
-  value REAL NOT NULL
+  value REAL NOT NULL,
+  timestamp DATE
 );
\ No newline at end of file