-- Add FAQ fields to campaigns table
-- Run this SQL to add FAQ question/answer fields

ALTER TABLE `campaigns`
  ADD COLUMN `faq_1_question` VARCHAR(255) DEFAULT '' AFTER `reviews_title`,
  ADD COLUMN `faq_1_answer` TEXT DEFAULT '' AFTER `faq_1_question`,
  ADD COLUMN `faq_2_question` VARCHAR(255) DEFAULT '' AFTER `faq_1_answer`,
  ADD COLUMN `faq_2_answer` TEXT DEFAULT '' AFTER `faq_2_question`,
  ADD COLUMN `faq_3_question` VARCHAR(255) DEFAULT '' AFTER `faq_2_answer`,
  ADD COLUMN `faq_3_answer` TEXT DEFAULT '' AFTER `faq_3_question`,
  ADD COLUMN `faq_4_question` VARCHAR(255) DEFAULT '' AFTER `faq_3_answer`,
  ADD COLUMN `faq_4_answer` TEXT DEFAULT '' AFTER `faq_4_question`,
  ADD COLUMN `faq_5_question` VARCHAR(255) DEFAULT '' AFTER `faq_4_answer`,
  ADD COLUMN `faq_5_answer` TEXT DEFAULT '' AFTER `faq_5_question`,
  ADD COLUMN `faq_6_question` VARCHAR(255) DEFAULT '' AFTER `faq_5_answer`,
  ADD COLUMN `faq_6_answer` TEXT DEFAULT '' AFTER `faq_6_question`,
  ADD COLUMN `faq_7_question` VARCHAR(255) DEFAULT '' AFTER `faq_6_answer`,
  ADD COLUMN `faq_7_answer` TEXT DEFAULT '' AFTER `faq_7_question`,
  ADD COLUMN `faq_8_question` VARCHAR(255) DEFAULT '' AFTER `faq_7_answer`,
  ADD COLUMN `faq_8_answer` TEXT DEFAULT '' AFTER `faq_8_question`,
  ADD COLUMN `faq_9_question` VARCHAR(255) DEFAULT '' AFTER `faq_8_answer`,
  ADD COLUMN `faq_9_answer` TEXT DEFAULT '' AFTER `faq_9_question`,
  ADD COLUMN `faq_10_question` VARCHAR(255) DEFAULT '' AFTER `faq_9_answer`,
  ADD COLUMN `faq_10_answer` TEXT DEFAULT '' AFTER `faq_10_question`;