IoT - Kubus / Mbed 2 deprecated Kubus

JNP3 16/17

Dependencies:   mbed nRF24L01P

server/kubus.sql

Committer:
pannaanna
Date:
2017-01-23
Revision:
68:e88f3fd2e9cf
Parent:
35:0f01042765d6

File content as of revision 68:e88f3fd2e9cf:

CREATE TABLE pir1 (
  id INTEGER PRIMARY KEY,
  value INTEGER NOT NULL,
  timestamp DATE
);

CREATE TABLE pir2 (
  id INTEGER PRIMARY KEY,
  value INTEGER NOT NULL,
  timestamp DATE
);

CREATE TABLE distance (
  id INTEGER PRIMARY KEY,
  value REAL NOT NULL,
  timestamp DATE
);

CREATE TABLE volume (
  id INTEGER PRIMARY KEY,
  value REAL NOT NULL,
  timestamp DATE
);