IoT - Kubus
JNP3 16/17
server/kubus.sql@35:0f01042765d6, 2017-01-17 (annotated)
- Committer:
- Jan Kopa?ski
- Date:
- Tue Jan 17 11:50:16 2017 +0100
- Revision:
- 35:0f01042765d6
- Parent:
- 16:1569130916f1
server timestamp
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 | ); |