6ea8444d04
Adds migration 0003_seed_seasons.sql that creates the initial season "Season 1: The Founding" with status=active. The index builder already has code to generate seasons/index.json from the database (generateSeasonsIndex in generator.go, fetchSeasons in db.go). The season starts 7 days ago and has no end date or champion yet, allowing it to serve as the active season for the platform. Closes: bf-4w0x
5 lines
443 B
SQL
5 lines
443 B
SQL
-- Seed the first season for AI Code Battle
|
|
-- This creates Season 1: The Founding, the initial competitive season
|
|
|
|
INSERT INTO seasons (id, name, theme, rules_version, status, champion_id, starts_at, ends_at, created_at) VALUES
|
|
(1, 'Season 1: The Founding', 'The dawn of automated competition — bots clash for the first time on symmetrical battlefields.', '1.0', 'active', NULL, NOW() - INTERVAL '7 days', NULL, NOW() - INTERVAL '7 days');
|