IoT - Kubus / Mbed 2 deprecated Kubus

JNP3 16/17

Dependencies:   mbed nRF24L01P

server/kubus.sql

Committer:
Jan Kopa?ski
Date:
2017-01-17
Revision:
35:0f01042765d6
Parent:
16:1569130916f1

File content as of revision 35:0f01042765d6:

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
);