racket: aufgraeumt, data2c gefixt

1 files changed, 18 insertions, 0 deletions

diff --git a/ebus-racket/doc/database-schema.sql b/ebus-racket/doc/database-schema.sql
new file mode 100644
index 0000000..281659c
--- /dev/null
+++ b/ebus-racket/doc/database-schema.sql
@@ -0,0 +1,18 @@
+CREATE TABLE sensor (
+        id INTEGER PRIMARY KEY AUTOINCREMENT,
+        name TEXT,
+        description TEXT
+);
+CREATE TABLE value (
+        id INTEGER PRIMARY KEY AUTOINCREMENT,
+        "timestamp" timestamp without time zone,
+        sensor_id integer,
+        type TEXT,
+        value_float real,
+        value_int integer,
+        value_string TEXT,
+        FOREIGN KEY(sensor_id) REFERENCES sensor(id)
+);
+CREATE INDEX sensor_idx_001 on sensor(id);
+CREATE INDEX sensor_idx_002 on sensor(name);
+CREATE INDEX value_idx_001 on value(sensor_id, timestamp);