-- Create faqs table
CREATE TABLE IF NOT EXISTS faqs (
  id INT AUTO_INCREMENT PRIMARY KEY,
  question VARCHAR(500) NOT NULL,
  answer TEXT NOT NULL,
  category VARCHAR(100) DEFAULT NULL,
  sort_order INT DEFAULT 0,
  is_active TINYINT(1) DEFAULT 1,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Seed FAQ data
INSERT INTO faqs (question, answer, category, sort_order) VALUES
('What is Nuhge?', 'Nuhge is an app designed to keep you connected to your loved ones by providing you with personalized, heartfelt messages that you can then send them. It helps you regularly show them specific appreciation for who they are and what they do. It also provides timely reminders of important dates, such as birthdays and anniversaries, and can even give gift recommendations tailored to them.', 'General', 1),
('How do you say "Nuhge"?', '"Nuhge" is pronounced like "nudge", as in Nuhge is nudging you to connect with your friends and family.', 'General', 2),
('Is Nuhge insincere or disingenuous?', 'No! You think of your loved ones often. Nuhge is simply helping you tell them you are thinking of them. You will complete a profile for each of your loved ones that captures what you love about them. So even though Nuhge creates the messages, you provided the content.', 'General', 3),
('How do we manage your data?', 'We take the handling and storage of your information very seriously. Your information is stored securely in AWS S3 using AES-256 encryption. Messages are sent using SSL/TLS secure communication protocols. And we will never sell or share your data.', 'Privacy', 4),
('How many profiles can be created in Nuhge?', 'Depending on the selected plan, you can create up to 4 profiles (Standard and Premium) or up to 6 profiles (Standard Plus and Premium Plus).', 'Plans', 5),
('How many messages does Nuhge send?', 'Nuhge will send up to 3 messages per week for each profile.', 'Messages', 6),
('What if I don\'t like the message sent to me?', 'You can request Nuhge to create a new message up to 2 times for each message for each profile. Additionally, you can edit any message prior to sending it.', 'Messages', 7),
('Can I edit the messages Nuhge sends me?', 'Yes! You can edit any message before sending it to your loved one. This allows you to add your personal touch or adjust the wording to better fit your relationship.', 'Messages', 8),
('How many reminders does Nuhge send?', 'You can set reminders for up to 12 important dates for each profile across all plans.', 'Reminders', 9),
('How many gift ideas does Nuhge send?', 'Premium and Premium Plus plan users receive 5-7 personalized gift ideas per profile based on their interests and preferences. Gift ideas are provided around important dates. Standard plans do not include gift ideas.', 'Gift Ideas', 10),
('What if I don\'t like the gift ideas sent to me?', 'You can request new gift recommendations at any time. Our AI learns from your preferences to provide better suggestions over time.', 'Gift Ideas', 11),
('Do you have an app?', 'Yes! Nuhge is available on both iOS and Android. You can download it from the App Store or Google Play Store.', 'General', 12),
('How much does it cost?', 'Nuhge offers four plans: Standard at $5.99/month, Standard Plus at $7.99/month, Premium at $7.99/month, and Premium Plus at $9.99/month. All plans come with a 2-week free trial so you can try before you commit.', 'Plans', 13);
