-- ============================================================
-- OPTIONAL SEED DATA (Migration 002)
-- Run this AFTER 001_core_schema.sql if you want a demo journal
-- to test the submission + tracking flow immediately.
-- Safe to skip or delete later — nothing here is hardcoded into PHP.
-- ============================================================

INSERT INTO journals (journal_code, journal_name, short_name, description, status, display_order)
VALUES ('demo', 'Demo Journal of Testing', 'DJT', 'A placeholder journal for testing the submission workflow.', 'Active', 1)
ON DUPLICATE KEY UPDATE journal_name = VALUES(journal_name);

INSERT INTO sections (journal_id, section_name, status, display_order)
SELECT id, 'Research Articles', 'Active', 1 FROM journals WHERE journal_code = 'demo';