-- Seed data: Storm King's Thunder campaign with 10 sessions of transcript data
-- Players:
--   DM: zackpollard (185097470215192579)
--   Theron (human paladin): akeboshiwind / Oliver (228227391007227904)
--   Bramble (halfling rogue): jellybain / JellyBain (99270555361902592)
--   Elara (elf wizard): alice.mary / alice (758311077204459571)
--   Grimnir (dwarf fighter): happy.moose / HappyMoose (794021028254187530)
--   Lyra (half-elf bard): rorymcdihroy / Gelfip (299691308010831874)

BEGIN;

-- Create campaign
INSERT INTO campaigns (guild_id, name, is_active, dm_user_id)
VALUES ('573985236828946443', 'Storm Kings Thunder', false, '185097470215192579')
RETURNING id;

-- We'll use currval to reference the campaign
-- Character mappings
INSERT INTO character_mappings (user_id, guild_id, campaign_id, character_name) VALUES
('228227391007227904', '573985236828946443', currval('campaigns_id_seq'), 'Theron Brightblade'),
('99270555361902592', '573985236828946443', currval('campaigns_id_seq'), 'Bramble Thornwick'),
('758311077204459571', '573985236828946443', currval('campaigns_id_seq'), 'Elara Moonwhisper'),
('794021028254187530', '573985236828946443', currval('campaigns_id_seq'), 'Grimnir Stonefist'),
('299691308010831874', '573985236828946443', currval('campaigns_id_seq'), 'Lyra Stormwind');

-- ============================================================
-- SESSION 1: A Giant Problem (Nightstone under attack)
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-01-05 19:00:00+00', '2026-01-05 22:30:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 2: The Dripping Caves
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-01-12 19:00:00+00', '2026-01-12 22:15:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 3: The Road North
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-01-19 19:00:00+00', '2026-01-19 22:00:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 4: The Siege of Bryn Shander
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-01-26 19:00:00+00', '2026-01-26 22:45:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 5: Finding Harshnag
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-02-02 19:00:00+00', '2026-02-02 22:00:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 6: The Eye of the All-Father
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-02-09 19:00:00+00', '2026-02-09 22:30:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 7: Journey to the Coast
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-02-16 19:00:00+00', '2026-02-16 22:00:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 8: The Maelstrom
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-02-23 19:00:00+00', '2026-02-23 22:30:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 9: The Morkoth - Rescuing Hekaton
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-03-02 19:00:00+00', '2026-03-02 23:00:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

-- ============================================================
-- SESSION 10: The Final Battle - Iymrith
-- ============================================================
INSERT INTO sessions (guild_id, channel_id, status, started_at, ended_at, summary, campaign_id, audio_dir)
VALUES ('573985236828946443', '578288492275302400', 'complete',
  '2026-03-09 19:00:00+00', '2026-03-09 23:30:00+00', NULL, currval('campaigns_id_seq'), '')
RETURNING id;

COMMIT;
