diff options
| author | Random Hacker <random_hacker@xapek.org> | 2013-02-23 01:32:51 +0100 |
|---|---|---|
| committer | Random Hacker <random_hacker@xapek.org> | 2013-02-23 01:33:43 +0100 |
| commit | 946eb7d95fc04d465802c8fc00e5d4130a52c8f2 (patch) | |
| tree | 3f2ca0a604a6f2ea4e572b9f8664cb29725e2712 /ebus-racket/doc | |
| parent | 3b286fc39032d3a6249a61b6ec6f9c95672c5d8b (diff) | |
| download | ebus-alt-946eb7d95fc04d465802c8fc00e5d4130a52c8f2.tar.gz ebus-alt-946eb7d95fc04d465802c8fc00e5d4130a52c8f2.zip | |
racket: aufgraeumt, data2c gefixt
Diffstat (limited to 'ebus-racket/doc')
| -rw-r--r-- | ebus-racket/doc/database-schema.sql | 18 | ||||
| -rw-r--r-- | ebus-racket/doc/sample_dump_1_1min.bin | bin | 0 -> 1300 bytes |
2 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); diff --git a/ebus-racket/doc/sample_dump_1_1min.bin b/ebus-racket/doc/sample_dump_1_1min.bin Binary files differnew file mode 100644 index 0000000..f0ec73e --- /dev/null +++ b/ebus-racket/doc/sample_dump_1_1min.bin |