IoT - Kubus
JNP3 16/17
server/kubus.sql@68:e88f3fd2e9cf, 2017-01-23 (annotated)
- Committer:
- pannaanna
- Date:
- Mon Jan 23 14:18:23 2017 +0100
- Revision:
- 68:e88f3fd2e9cf
- Parent:
- 35:0f01042765d6
port changed
Who changed what in which revision?
| User | Revision | Line number | New contents of line |
|---|---|---|---|
| Jan Kopa?ski | 16:1569130916f1 | 1 | CREATE TABLE pir1 ( |
| Jan Kopa?ski | 16:1569130916f1 | 2 | id INTEGER PRIMARY KEY, |
| Jan Kopa?ski | 35:0f01042765d6 | 3 | value INTEGER NOT NULL, |
| Jan Kopa?ski | 35:0f01042765d6 | 4 | timestamp DATE |
| Jan Kopa?ski | 16:1569130916f1 | 5 | ); |
| Jan Kopa?ski | 16:1569130916f1 | 6 | |
| Jan Kopa?ski | 16:1569130916f1 | 7 | CREATE TABLE pir2 ( |
| Jan Kopa?ski | 16:1569130916f1 | 8 | id INTEGER PRIMARY KEY, |
| Jan Kopa?ski | 35:0f01042765d6 | 9 | value INTEGER NOT NULL, |
| Jan Kopa?ski | 35:0f01042765d6 | 10 | timestamp DATE |
| Jan Kopa?ski | 16:1569130916f1 | 11 | ); |
| Jan Kopa?ski | 16:1569130916f1 | 12 | |
| Jan Kopa?ski | 16:1569130916f1 | 13 | CREATE TABLE distance ( |
| Jan Kopa?ski | 16:1569130916f1 | 14 | id INTEGER PRIMARY KEY, |
| Jan Kopa?ski | 35:0f01042765d6 | 15 | value REAL NOT NULL, |
| Jan Kopa?ski | 35:0f01042765d6 | 16 | timestamp DATE |
| Jan Kopa?ski | 16:1569130916f1 | 17 | ); |
| Jan Kopa?ski | 16:1569130916f1 | 18 | |
| Jan Kopa?ski | 16:1569130916f1 | 19 | CREATE TABLE volume ( |
| Jan Kopa?ski | 16:1569130916f1 | 20 | id INTEGER PRIMARY KEY, |
| Jan Kopa?ski | 35:0f01042765d6 | 21 | value REAL NOT NULL, |
| Jan Kopa?ski | 35:0f01042765d6 | 22 | timestamp DATE |
| Jan Kopa?ski | 16:1569130916f1 | 23 | ); |