Created At: 2026-06-14T15:33:14Z
Completed At: 2026-06-14T15:33:14Z
File Path: `file:///c:/Users/HP/Downloads/climate-system/climate-system/index.php`
Total Lines: 4711
Total Bytes: 198658
Showing lines 235 to 265
The following code has been modified to include a line number before every line, in the format: <line_number>: <original_line>. Please note that any changes targeting the original code should remove the line number, colon, and leading space.
235:                 image_monthly_map_url TEXT DEFAULT '',
236:                 image_monthly_graph_url TEXT DEFAULT '',
237:                 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
238:                 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
239:                 FOREIGN KEY (location_id) REFERENCES locations(id) ON DELETE CASCADE,
240:                 FOREIGN KEY (variable_id) REFERENCES variables(id) ON DELETE CASCADE,
241:                 UNIQUE (location_id, variable_id)
242:             );
243: 
244:             CREATE TABLE IF NOT EXISTS future_climate (
245:                 id INTEGER PRIMARY KEY AUTOINCREMENT,
246:                 location_id INTEGER NOT NULL,
247:                 variable_id INTEGER NOT NULL,
248:                 period_id INTEGER NOT NULL,
249:                 description TEXT DEFAULT '',
250:                 image_climate_map_url TEXT DEFAULT '',
251:                 image_climate_map_url_2 TEXT DEFAULT '',
252:                 image_time_series_url TEXT DEFAULT '',
253:                 image_climate_stripe_url TEXT DEFAULT '',
254:                 csv_data TEXT DEFAULT NULL,
255:                 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
256:                 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
257:                 FOREIGN KEY (location_id) REFERENCES locations(id) ON DELETE CASCADE,
258:                 FOREIGN KEY (variable_id) REFERENCES variables(id) ON DELETE CASCADE,
259:                 FOREIGN KEY (period_id) REFERENCES periods(id) ON DELETE CASCADE,
260:                 UNIQUE (location_id, variable_id, period_id)
261:             );
262:         ");
263: 
264:         // Seed Data Master Lokasi
265:         $locations = ['Indonesia'];
The above content does NOT show the entire file contents. If you need to view any lines of the file which were not shown to complete your task, call this tool again to view those lines.
