CREATE TABLE IF NOT EXISTS blogs (
  id INT AUTO_INCREMENT PRIMARY KEY,
  slug VARCHAR(255) NOT NULL UNIQUE,
  title VARCHAR(500) NOT NULL,
  excerpt TEXT,
  body LONGTEXT NOT NULL,
  category VARCHAR(100),
  author VARCHAR(255) DEFAULT 'Nuhge Team',
  read_time VARCHAR(50),
  cover_gradient VARCHAR(100),
  is_published TINYINT(1) DEFAULT 1,
  published_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO blogs (slug, title, excerpt, body, category, author, read_time, cover_gradient, published_at) VALUES
(
  '5-simple-ways-to-show-loved-ones-you-care',
  '5 Simple Ways to Show Your Loved Ones You Care',
  'In our busy lives, it''s easy to forget the small gestures that strengthen our relationships. Here are five thoughtful ways to let the people in your life know they matter.',
  '<p>Life moves quickly, and sometimes the people we care about most can feel taken for granted. But staying connected doesn''t have to be complicated. Here are five simple, meaningful ways to show your loved ones you care.</p><h2>1. Send a Thinking of You Message</h2><p>A short, heartfelt message out of the blue means more than most people realize. It doesn''t have to be long — just a sentence letting someone know they crossed your mind.</p><h2>2. Remember the Small Details</h2><p>Ask follow-up questions about things they''ve mentioned before. Remembering that your friend had a big presentation last Tuesday and asking how it went shows you truly listen.</p><h2>3. Celebrate Their Wins</h2><p>Whether big or small, acknowledging someone''s achievements makes them feel seen and appreciated. A quick congratulations goes a long way.</p><h2>4. Mark Important Dates</h2><p>Birthdays, anniversaries, and personal milestones matter. Set reminders so you never miss an opportunity to make someone feel special on their big day.</p><h2>5. Give a Thoughtful Gift</h2><p>A personalized gift tailored to someone''s interests shows you pay attention. It doesn''t need to be expensive — it just needs to be thoughtful.</p><p>Nuhge makes all of these easier by helping you stay on top of important dates, craft personalized messages, and find gift ideas tailored to the people you love.</p>',
  'Relationships',
  'Nuhge Team',
  '5 min read',
  'linear-gradient(135deg, #FFD147 0%, #F49D00 100%)',
  '2026-02-10 00:00:00'
),
(
  'the-art-of-meaningful-gift-giving',
  'The Art of Meaningful Gift-Giving',
  'A truly meaningful gift doesn''t have to break the bank. Discover how personalized, thoughtful presents create lasting memories and deeper connections.',
  '<p>Gift-giving can feel daunting, especially when you want to get it just right. The good news? The most meaningful gifts aren''t always the most expensive ones.</p><h2>It''s About the Thought</h2><p>A gift that reflects the recipient''s personality, hobbies, or current needs shows you truly know and care about them. Think about what they''ve been talking about lately, what they need, or what would make their day easier or more enjoyable.</p><h2>Personalization Is Everything</h2><p>Generic gifts are forgotten. Personalized gifts become stories. A book by their favorite author, a custom item related to their hobby, or something that references an inside joke — these are the gifts people remember for years.</p><h2>Timing Matters</h2><p>Giving a gift on an important occasion — a birthday, a work anniversary, a difficult time — amplifies its impact. Knowing someone''s important dates means you''re always prepared.</p><h2>How Nuhge Helps</h2><p>Nuhge builds a profile around each of your loved ones — their interests, preferences, and important dates. When the time comes, Nuhge suggests personalized gift ideas so you''re never scrambling at the last minute.</p>',
  'Gift Ideas',
  'Nuhge Team',
  '4 min read',
  'linear-gradient(135deg, #948A54 0%, #EEDBA4 100%)',
  '2026-02-03 00:00:00'
),
(
  'why-consistent-communication-matters',
  'Why Consistent Communication Matters More Than Grand Gestures',
  'Research shows that frequent small check-ins build stronger bonds than occasional big displays. Learn why consistency is the secret to staying close.',
  '<p>We often think that big gestures — surprise parties, elaborate gifts, grand declarations — are what strengthen relationships. But research in relationship psychology tells a different story.</p><h2>The Power of Small Moments</h2><p>Dr. John Gottman''s research shows that the quality of a relationship is built in small, everyday interactions. A quick text, a shared laugh, a simple "I''m thinking of you" — these micro-moments of connection compound over time into deep, lasting bonds.</p><h2>Consistency Over Intensity</h2><p>An occasional grand gesture can''t make up for months of silence. But consistent, small acts of connection keep relationships warm and resilient. Think of it like exercise — a daily walk beats an annual marathon.</p><h2>Why People Drift Apart</h2><p>Most relationships don''t end with a dramatic falling out. They fade quietly through neglect — not because people stop caring, but because life gets busy and connection gets deprioritized.</p><h2>Making It Habit</h2><p>The solution isn''t to care more — it''s to make showing you care easier and more automatic. That''s exactly what Nuhge is designed to do.</p>',
  'Communication',
  'Nuhge Team',
  '6 min read',
  'linear-gradient(135deg, #F49D00 0%, #FFD147 100%)',
  '2026-01-28 00:00:00'
),
(
  'how-nuhge-uses-ai-to-personalize-messages',
  'How Nuhge Uses AI to Personalize Your Messages',
  'Ever wonder how Nuhge crafts messages that feel genuinely personal? Take a behind-the-scenes look at the technology that powers thoughtful communication.',
  '<p>When people first hear about Nuhge, a common question is: "How can an AI write something that feels personal?" It''s a fair question. Here''s how it works.</p><h2>It Starts With You</h2><p>Nuhge doesn''t generate generic messages. Everything begins with the profiles you create for your loved ones — their personality traits, things you admire about them, shared memories, hobbies, and interests. You provide the raw material; Nuhge shapes it into something meaningful.</p><h2>Context-Aware Messaging</h2><p>Our AI considers the occasion, the relationship type, and the specific attributes of the person when crafting each message. A birthday message for your mom feels different from one for your college friend — and Nuhge knows the difference.</p><h2>Editing and Refinement</h2><p>Every message can be reviewed and edited before you send it. You can request a new version if the first doesn''t feel right, or tweak the wording to add your personal voice. Nuhge is a tool to help you communicate — not a replacement for your voice.</p><h2>Getting Better Over Time</h2><p>As you use Nuhge and provide feedback, the system learns your preferences and communication style, leading to better, more personalized suggestions over time.</p>',
  'Technology',
  'Nuhge Team',
  '3 min read',
  'linear-gradient(135deg, #EEDBA4 0%, #948A54 100%)',
  '2026-01-20 00:00:00'
),
(
  'never-miss-an-important-date-again',
  'Never Miss an Important Date Again',
  'Birthdays, anniversaries, and milestones slip by when life gets hectic. Here''s how setting up reminders can transform your relationships.',
  '<p>It happens to everyone. You wake up, check your phone, and realize it''s your sister''s birthday — and you completely forgot. The guilt hits immediately.</p><h2>Why We Forget</h2><p>It''s not that we don''t care. Modern life is packed with responsibilities, notifications, and to-dos. Important dates simply get buried under the noise.</p><h2>The Impact of Remembering</h2><p>When someone remembers your birthday or reaches out on your work anniversary, it signals that you matter to them. These moments build trust, closeness, and goodwill that carry relationships through harder times.</p><h2>Beyond Birthdays</h2><p>Nuhge lets you track any important date — not just birthdays and anniversaries. A friend''s job interview, a family member''s surgery, a child''s graduation — these milestones matter and deserve acknowledgment.</p><h2>Setting Up Reminders the Right Way</h2><p>The key is to set reminders early enough to act on them. Nuhge sends you advance notice so you have time to send a message, plan a gift, or make a call — not just a last-minute ping on the day itself.</p>',
  'Tips',
  'Nuhge Team',
  '5 min read',
  'linear-gradient(135deg, #FFD147 0%, #948A54 100%)',
  '2026-01-12 00:00:00'
),
(
  'real-stories-how-nuhge-helped-families-reconnect',
  'Real Stories: How Nuhge Helped Families Reconnect',
  'From coast-to-coast siblings to busy parents, hear from real users who have used Nuhge to rebuild and strengthen their most important relationships.',
  '<p>Behind every Nuhge profile is a real relationship — and a real story of connection. Here are a few of the ways our users have used Nuhge to bring people closer.</p><h2>The Siblings Across the Country</h2><p>"My brother and I used to go months without talking — not because we didn''t love each other, but because neither of us would make the first move. Nuhge gives me something to send him every week. Now we actually have conversations again." — Sarah, 34</p><h2>The Busy Parent</h2><p>"Between work and kids, I was terrible at staying in touch with my own parents. Nuhge reminds me to reach out and gives me thoughtful things to say. My mom tells me she loves hearing from me more." — James, 41</p><h2>The Long-Distance Friendship</h2><p>"My best friend moved to another country three years ago. Nuhge has helped me stay consistent about reaching out. She says it makes her feel like we''re still close even though we''re far apart." — Maria, 29</p><h2>Start Your Own Story</h2><p>Every meaningful relationship deserves attention. Nuhge is designed to make showing up for the people you love easier, more consistent, and more personal.</p>',
  'Stories',
  'Nuhge Team',
  '7 min read',
  'linear-gradient(135deg, #F49D00 0%, #EEDBA4 100%)',
  '2026-01-05 00:00:00'
);
