-- Create Course Description Overrides Table
-- This table stores custom course descriptions that override WordPress data
-- Run this on your live database

CREATE TABLE IF NOT EXISTS `course_description_overrides` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `course_id` BIGINT(20) UNSIGNED NOT NULL COMMENT 'wp_posts.ID for the course',
  `description` TEXT NOT NULL COMMENT 'Custom description that overrides WordPress',
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `course_id_unique` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert all custom course descriptions
-- These will override any WordPress content

INSERT INTO `course_description_overrides` (`course_id`, `description`) VALUES
(43, 'What is The Historic Faith? What is the Kingdom of God? What is life all about? How do I know who to trust? These are big questions that you will explore during this foundational introduction to The Historic Faith.'),
(289, 'The Bible wasn''t written in a vacuum, and it isn''t interpreted in one either. Join David Bercot to explore the cultural and historical background of the New Testament and the interpretive debates that followed in the early church.'),
(4133, 'In the Sermon on the Mount, Jesus called his followers to love their enemies and avoid violence. Explore how early Christians responded to war, violence, and government. Discover what it means to give your allegiance to the Kingdom of God.'),
(281, 'Explore what it meant to be a citizen of the Kingdom of God in the earliest years of the faith. Early Christians recognized God''s Kingdom as the primary authority in their lives, avoiding entanglements with worldly politics and war.'),
(8268, 'Join Dean Taylor as he surveys the landscape of Christian involvement in politics throughout history. This series exposes the devastating results when Christians get involved in the political arena using a historical approach.'),
(285, 'Explore the practice of the early Church and compare it to modern Christianity. Studying church life shortly after the last apostle died will strengthen your faith and provide a clearer picture of authentic Christian community.'),
(4396, 'A collection of assorted lectures from David Bercot on historical church doctrines and his autobiographical journey of faith. These standalone lessons cover the Trinity, the origin of evil, and humanity''s ultimate destiny.'),
(4852, 'Can Christians really identify the Antichrist or the mark of the beast? Will Jesus set up a future earthly kingdom? Explore what the early Christians believed about end-time prophecy and separate biblical truth from popular speculation.'),
(11333, 'A church is only as strong as its teaching. Join David Bercot as he demonstrates how to use early Christian writings and the Septuagint to gain deeper insights when teaching through books of the Bible verse by verse.'),
(3992, 'Paul''s instructions on headship clash with modern ideas of women''s liberation. Finny Kuruvilla carefully exegetes the biblical text and shows how Christians have understood this passage historically, offering practical advice for today.'),
(299, 'What is Calvinism''s view of God? Where did it originate? Is it a biblical system of thought? In this engaging course, Finny Kuruvilla slices through the theological jargon and offers an accessible, historical response to TULIP.'),
(287, 'Have you ever wondered if there have always been faithful kingdom Christian movements? Explore movements throughout church history who remained faithful to the kingdom gospel, from the early church through the Radical Reformation.'),
(29986, 'A comprehensive academic study of Christian theology throughout history. Trace the development of key doctrines from the apostolic era through the early church fathers in this college-level course from Zollikon Institute.'),
(20508, 'Develop essential critical thinking skills for evaluating truth claims. Learn to spot logical fallacies, recognize manipulation tactics, and reason clearly through complex theological and practical questions.'),
(11037, 'Too often Christians interpret the Gospels through contemporary lenses, missing important details. Join David Bercot as he explores Matthew''s Gospel using insights from the earliest Christian writings to illuminate the text.'),
(6215, 'Few Christians today present the story of Jesus using the tactics of the earliest evangelists. Join Chuck Pike as he demonstrates the time-tested relevance of scriptural prophecies that prove Jesus is the promised Messiah.'),
(297, 'To the early Christians, what many today consider radical was simply Christianity without compromises. Join David Bercot to understand why the faith of the first believers looked so different from much of modern Christianity.'),
(6374, 'Are you a history maker? Dean Taylor invites you to draw on the prophetic voice of faithful believers from the early church through the Radical Reformation. Let their courage and conviction inspire your faith today.'),
(11009, 'Explore Old Testament prophecies pointing to Christ''s resurrection. Discover how these ancient predictions were fulfilled and why the resurrection stands at the very center of the Christian faith and message.'),
(22964, 'A detailed verse-by-verse study of Romans chapters 1-8 exploring how early Christians understood Paul''s letter before Augustine''s influence. Discover Paul''s foundational teaching on sin, grace, and life in the Spirit.'),
(27655, 'Continue through Romans chapters 9-16 with insights from early Christian interpreters. Study Paul''s teaching on Israel, practical Christian living, and the outworking of the gospel in everyday life.'),
(283, 'Did the early Christians believe we are saved by faith alone? Does obedience play a role in salvation? What the early Christians believed about salvation, works, and free will may surprise you.'),
(16830, 'Discover how Old Testament stories and figures foreshadow the coming Messiah. Join Chuck Pike as he explores the rich typology woven throughout the Hebrew Scriptures that points unmistakably to Jesus Christ.'),
(293, 'Are we reading the same Bible as the Apostles? Should we only use the King James Version? David Bercot digs into controversial questions about Bible translations, the Apocrypha, and the Word of God.'),
(6354, 'Most Protestants struggle to understand Catholic and Orthodox doctrines around Mary, images, icons, and saints. Explore whether such practices are grounded in the New Testament and the faith of the early church.'),
(24997, 'Selected episodes from The Historic Faith Podcast featuring discussions on early Christianity, kingdom living, and practical faith applications. Join our teachers for insightful conversations on timely topics.'),
(10664, 'If you have more confusion than clarity about the Holy Spirit, you''re not alone. Explore the person and work of the Spirit from an early Christian perspective and discover what the first believers taught.'),
(276, 'Have you ever wondered what Christians believed in the first few generations after the apostles? Before there were state churches, councils, and denominations? Explore the deeply challenging life of early believers.'),
(1128, 'Explore the history of the United States from its European roots through the Constitution—but from a kingdom perspective. These stimulating messages examine American history through the lens of early Christian values.'),
(295, 'Embark on a journey through history to discover what it means to be a great leader in the Kingdom of Heaven. David Bercot explores the lives of exemplary Christians from the Apostles to Alexander Campbell.'),
(16458, 'Explore the historical debate between infant baptism and believers'' baptism. Discover what the earliest Christians actually practiced and taught about this foundational sacrament of the faith.'),
(20330, 'A comprehensive collection of Q&A episodes covering a wide range of topics about early Christianity, kingdom living, and practical faith. Get answers to your questions from our experienced teachers.'),
(27332, 'Explore how Christians can faithfully respond to modern cultural trends while maintaining unity. Learn biblical principles for navigating controversial topics and social movements in the church today.'),
(20103, 'Examine common Calvinist doctrines and discover how early Christians understood predestination, free will, and God''s sovereignty. Get clear, historically-grounded answers to challenging theological questions.'),
(24606, 'Discover what the early Christians believed and practiced regarding baptism. Explore questions about baptismal timing, mode, and meaning from a historical Christian perspective.'),
(27157, 'Learn practical wisdom for planting, building, and finding kingdom-focused churches. Explore how to gather believers in areas with few like-minded Christians and build authentic community.'),
(27297, 'What was the early Christian attitude toward government, voting, and political involvement? Discover the historical perspective on how the first believers related to worldly powers and authorities.'),
(27406, 'Navigate the complexities of church relationships and family dynamics with wisdom. Learn how to maintain friendships across disagreements and build healthy, loving Christian community.'),
(28050, 'Explore what the early church taught about leadership, elders, and church governance. Discover biblical and historical patterns for organizing and leading Christian communities effectively.'),
(24661, 'Examine questions about church standards, modesty, and applying biblical principles when Scripture doesn''t give specifics. Learn how early Christians approached matters of Christian liberty.'),
(24650, 'Explore various Christian practices from an early church perspective. Learn what the first Christians believed about everyday matters of faith and how those practices remain relevant today.'),
(22553, 'Separate fact from fiction in popular Christian beliefs. Examine commonly held traditions and teachings to discover which have genuine historical and scriptural support.'),
(22491, 'Discover how the early Christians understood and practiced communion. Explore questions about the Lord''s Supper, its meaning, frequency, and how believers today can honor this sacred ordinance.'),
(20068, 'Study end-times prophecy from an early Christian perspective. Explore what the first believers taught about Christ''s return, the millennium, and the future of God''s eternal kingdom.'),
(27249, 'Learn effective approaches to sharing the faith drawn from early church practices. Discover how kingdom teachings can enhance rather than hinder genuine evangelistic efforts.'),
(24641, 'Examine the five solas of the Protestant Reformation from a historical perspective. Discover how these foundational doctrines compare with what the early Christians actually believed.'),
(22953, 'Investigate the historical accuracy and reliability of Christian writings. Build confidence in the authenticity of Scripture and early church documents through careful examination of the evidence.'),
(27423, 'Explore questions about the Holy Spirit from an early Christian perspective. Discover what the first believers taught about the Spirit''s work, gifts, and presence in the life of the church.'),
(27525, 'Explore the relationship between Jesus'' teachings and the Mosaic Law. Understand how early Christians navigated the continuity and discontinuity between the old and new covenants.'),
(27180, 'Discover how Jesus'' kingdom teachings transform daily life in practical ways. Explore the real-world impact of living as a citizen of God''s kingdom in today''s modern world.'),
(27533, 'Examine what the early Christians taught about marriage, divorce, and remarriage. Discover biblical principles and historical wisdom for navigating these important life decisions.'),
(20130, 'A verse-by-verse journey through the Gospel of Matthew enriched with insights from early Christian writings. Discover fresh perspectives on familiar passages and deeper meaning in Jesus'' words.'),
(22561, 'Explore questions about miracles, signs, and wonders from Scripture and early church history. Discover what the first Christians believed about God''s supernatural work in the world.'),
(27541, 'Personal questions answered by David Bercot about his background, spiritual journey, and experiences. Get to know the teacher behind many Historic Faith courses on a more personal level.'),
(27454, 'Thoughtful answers to common questions about Anabaptist beliefs and practices. Explore the historical roots and modern applications of this important Christian tradition.'),
(27515, 'Discover what the early Christians taught about the roles of women in the church and home. Explore historical perspectives on gender, ministry, and Christian community life.'),
(27431, 'Examine what the early Christians believed about salvation and the possibility of apostasy. Discover historical perspectives on perseverance, eternal security, and faithful endurance.'),
(20120, 'Study Jesus'' most famous sermon with insights from early Christian interpreters. Discover practical applications of kingdom principles that transform everyday Christian living.'),
(27444, 'Explore the doctrine of the Trinity from an early Christian perspective. Discover how the first believers understood and expressed the nature of Father, Son, and Holy Spirit.'),
(27398, 'Examine different theories of how Christ''s death provides salvation. Discover what the early Christians believed about the atonement and its profound significance for believers.')
ON DUPLICATE KEY UPDATE description = VALUES(description), updated_at = NOW();

