32 lines
881 B
SQL
32 lines
881 B
SQL
DROP TABLE IF EXISTS current_forecasts;
|
|
DROP TABLE IF EXISTS daily_forecasts;
|
|
|
|
CREATE TABLE "current_forecasts" (
|
|
"id" Integer NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"start_time" DateTime NOT NULL,
|
|
"end_time" DateTime NOT NULL,
|
|
"is_daytime" Integer NOT NULL,
|
|
"temperature" Integer NOT NULL,
|
|
"precipitation_probability" Integer,
|
|
"relative_humidity" Integer,
|
|
"wind_speed" Text,
|
|
"wind_direction" Text,
|
|
"icon_url" Text,
|
|
"short_forecast" Text,
|
|
"detailed_forecast" Text,
|
|
"created_at" DateTime,
|
|
"updated_at" DateTime
|
|
);
|
|
|
|
CREATE TABLE "daily_forecasts" (
|
|
"id" Integer NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"forecasted_date" DateTime NOT NULL,
|
|
"temperature_high" Integer NOT NULL,
|
|
"precipitation_probability" Integer,
|
|
"icon_url" Text,
|
|
"short_forecast" Text,
|
|
"created_at" DateTime,
|
|
"updated_at" DateTime
|
|
);
|
|
|