12// Kept byte-for-byte equivalent to schema.sql; bundled without a runtime fetch.exportdefault"CREATE TABLE locations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n lat REAL NOT NULL,\n lon REAL NOT NULL,\n added_at TEXT DEFAULT (datetime('now'))\n);\nCREATE TABLE weather_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n location_id INTEGER NOT NULL REFERENCES locations(id),\n temperature_c REAL,\n feels_like_c REAL,\n humidity_pct REAL,\n wind_speed_kmh REAL,\n weather_code INTEGER,\n condition TEXT,\n uv_index REAL,\n precipitation_mm REAL,\n fetched_at TEXT DEFAULT (datetime('now'))\n);\nCREATE TABLE forecasts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n location_id INTEGER NOT NULL REFERENCES locations(id),\n date TEXT NOT NULL /* Local calendar date at the saved location, YYYY-MM-DD. */,\n weather_code INTEGER /* Open-Meteo WMO weather code. */,\n condition TEXT /* Same English condition labels as weather_log and weather-updated. */,\n temperature_max_c REAL /* Daily maximum, degrees Celsius. */,\n temperature_min_c REAL /* Daily minimum, degrees Celsius. */,\n precipitation_mm REAL /* Daily total precipitation, millimeters. */,\n fetched_at TEXT DEFAULT (datetime('now')) /* Fetch time, UTC. */,\n UNIQUE(location_id, date)\n);\n";