-- Book templates system data with fixed newlines
-- Part 2 of book templates system
-- Depends on: 005_000_book_templates.sql

-- Insert system templates with properly formatted content (newlines fixed)
INSERT INTO book_templates (name, description, is_default, is_system, structure) VALUES
(
    'Comprehensive Writing Assistant',
    'Full-featured structure with guides, templates, examples, and organized folders for serious writers',
    true,
    true,
    '{
        "files": [
            {
                "name": "📖 Welcome to Your New Book",
                "type": "file",
                "content": "# Welcome to Your New Book! 🎉\n\nCongratulations on starting your writing journey with Bookwiz! This structure is designed to help you make the most of our AI-powered writing assistant.\n\n## Quick Start Checklist ✅\n- [ ] Read the Getting Started Guide\n- [ ] Explore the AI Writing Assistant Guide  \n- [ ] Customize your Book Overview in the planning folder\n- [ ] Try the example prompts with the AI chat\n- [ ] Start writing your first chapter!\n\n## What is Included\nThis book comes pre-loaded with:\n- **Guides** - Learn how to write with AI assistance\n- **Templates** - Ready-to-use outlines and character sheets\n- **Examples** - See AI collaboration in action\n- **Planning** - Structure your story\n- **Your Content** - Chapters, characters, research\n\n## Need Help?\nOpen the AI chat panel and try asking:\n- Help me plan my story structure\n- Act as my main character and answer questions\n- Improve this scene I am working on\n\nHappy writing! 📝✨",
                "file_extension": "md",
                "mime_type": "text/markdown",
                "sort_order": 1
            },
            {
                "name": "🚀 Getting Started Guide",
                "type": "file",
                "content": "# Getting Started with Bookwiz 🚀\n\n## How This Works\nBookwiz combines traditional writing with AI assistance. You write, the AI helps enhance, brainstorm, and develop your ideas.\n\n## Basic Workflow\n1. **Plan** - Use templates in planning/ to outline your story\n2. **Create** - Start writing in the chapters/ folder\n3. **Enhance** - Use AI to improve, expand, or brainstorm\n4. **Organize** - Keep research and character notes updated\n\n## Navigation Tips\n- **Left Panel**: File explorer (organize your content)\n- **Center**: Writing area (your main workspace)  \n- **Right Panel**: AI chat (your writing assistant)\n\n## File Organization\n- **guides/** - Educational content about writing with AI\n- **templates/** - Blank forms you can copy and customize\n- **examples/** - See how AI collaboration works\n- **planning/** - Your story structure and outlines\n- **characters/** - Character development and profiles\n- **research/** - Notes, worldbuilding, references\n- **chapters/** - Your actual book content\n\n## Customizing This Structure\nFeel free to:\n- Rename folders to match your book\n- Delete files you do not need\n- Add new folders for specific needs\n- Move files around as needed\n\nStart with the AI Writing Assistant Guide to learn how to collaborate effectively with AI!",
                "file_extension": "md",
                "mime_type": "text/markdown",
                "sort_order": 2
            }
        ],
        "folders": [
            {
                "name": "planning",
                "type": "folder",
                "expanded": true,
                "sort_order": 7,
                "children": [
                    {
                        "name": "book-overview",
                        "type": "file",
                        "content": "# Book Overview\n\n## Basic Information\n- **Title**: \n- **Genre**: \n- **Target Audience**: \n- **Estimated Length**: \n\n## Core Concept\n**Logline** (1-2 sentences):\n\n\n**Premise** (1 paragraph):\n\n\n## Main Elements\n**Protagonist**: \n\n\n**Central Conflict**: \n\n\n**Stakes**: \n\n\n**Theme**: \n\n\n## Setting\n**Time Period**: \n\n**Location(s)**: \n\n**World Details**: \n\n\n## Target Goals\n- **Daily Word Count**: \n- **Total Target**: \n- **Completion Date**: \n\n## AI Collaboration Strategy\n*How do you plan to use AI for this project?*\n- **Research areas where AI can help**: \n- **Character development assistance needed**: \n- **Plot elements to brainstorm**: \n\n---\n**AI Prompt for this book:**\n\"I''m writing a [genre] novel about [brief premise]. The main character is [protagonist description] and the central conflict involves [conflict]. Help me develop [specific areas where you need help].\"",
                        "file_extension": "md",
                        "mime_type": "text/markdown",
                        "sort_order": 1
                    }
                ]
            },
            {
                "name": "characters",
                "type": "folder",
                "expanded": false,
                "sort_order": 8
            },
            {
                "name": "chapters",
                "type": "folder",
                "expanded": true,
                "sort_order": 10
            }
        ]
    }'
),
(
    'Minimal Start',
    'Clean slate with just the essentials - perfect for experienced writers who prefer to build their own structure',
    false,
    true,
    '{
        "files": [
            {
                "name": "Welcome",
                "type": "file",
                "content": "# Your New Book\n\nReady to start writing? This minimal template gives you a clean slate to build exactly what you need.\n\n## Getting Started\n- Create your first chapter in the chapters folder\n- Add any additional folders or files as needed\n- Use the AI chat to brainstorm and enhance your writing\n\nHappy writing! 📝",
                "file_extension": "md",
                "mime_type": "text/markdown",
                "sort_order": 1
            }
        ],
        "folders": [
            {
                "name": "chapters",
                "type": "folder",
                "expanded": true,
                "sort_order": 2
            }
        ]
    }'
);