mirror of
https://github.com/ckaczor/HomeMonitor.git
synced 2026-01-14 09:59:13 -05:00
Chris Kaczor
4ada97fdd8
- New model package - Remove battery level - Change light level decimal scale
28 lines
1008 B
SQL
28 lines
1008 B
SQL
IF NOT EXISTS(SELECT 1 FROM sys.tables WHERE name = 'Reading')
|
|
CREATE TABLE Reading
|
|
(
|
|
Timestamp datetimeoffset NOT NULL
|
|
CONSTRAINT reading_pk
|
|
PRIMARY KEY,
|
|
WindDirection int NOT NULL,
|
|
WindSpeed decimal(4, 1) NOT NULL,
|
|
Humidity decimal(4, 1) NOT NULL,
|
|
HumidityTemperature decimal(4, 1) NOT NULL,
|
|
Rain decimal(2, 2) NOT NULL,
|
|
Pressure decimal(8, 2) NOT NULL,
|
|
PressureTemperature decimal(4, 1) NOT NULL,
|
|
LightLevel decimal(3, 2) NOT NULL,
|
|
Latitude decimal(9, 6) NOT NULL,
|
|
Longitude decimal(9, 6) NOT NULL,
|
|
Altitude decimal(5, 1) NOT NULL,
|
|
SatelliteCount int NOT NULL,
|
|
GpsTimestamp datetimeoffset NOT NULL
|
|
);
|
|
|
|
ALTER TABLE Reading ALTER COLUMN Rain decimal(3, 3);
|
|
|
|
IF COL_LENGTH('Reading', 'BatteryLevel') IS NOT NULL
|
|
ALTER TABLE Reading DROP COLUMN BatteryLevel;
|
|
|
|
ALTER TABLE Reading ALTER COLUMN LightLevel decimal(8, 2);
|