MeasureDevice/db.sql at main · KiSki-Dev/MeasureDevice · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
--
-- File generated with SQLiteStudio v3.4.17 on Do Feb 27 22:18:45 2025
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: heatIndexDays
CREATE TABLE IF NOT EXISTS heatIndexDays (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: heatIndexHours
CREATE TABLE IF NOT EXISTS heatIndexHours (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: heatIndexMin
CREATE TABLE IF NOT EXISTS heatIndexMin (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: humidityDays
CREATE TABLE IF NOT EXISTS humidityDays (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: humidityHours
CREATE TABLE IF NOT EXISTS humidityHours (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: humidityMin
CREATE TABLE IF NOT EXISTS humidityMin (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: lightDays
CREATE TABLE IF NOT EXISTS lightDays (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: lightHours
CREATE TABLE IF NOT EXISTS lightHours (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: lightMin
CREATE TABLE IF NOT EXISTS lightMin (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: temperatureDays
CREATE TABLE IF NOT EXISTS temperatureDays (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: temperatureHours
CREATE TABLE IF NOT EXISTS temperatureHours (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: temperatureMin
CREATE TABLE IF NOT EXISTS temperatureMin (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: voltageDays
CREATE TABLE IF NOT EXISTS voltageDays (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: voltageHours
CREATE TABLE IF NOT EXISTS voltageHours (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


-- Table: voltageMin
CREATE TABLE IF NOT EXISTS voltageMin (
    value     INT,
    timestamp INT,
    id        INTEGER PRIMARY KEY
);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;