IoT - Kubus / Mbed 2 deprecated Kubus

Important changes to repositories hosted on mbed.com

Mbed hosted mercurial repositories are deprecated and are due to be permanently deleted in July 2026.

To keep a copy of this software download the repository Zip archive or clone locally using Mercurial.

It is also possible to export all your personal repositories from the account settings page.

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