USE `content_engine`;

INSERT INTO `page_types` (`name`, `slug`, `category`, `description`, `structure_rules`, `seo_rules`, `content_blocks`, `min_word_count`, `max_word_count`) VALUES

('Blog Article', 'blog-article', 'on_page', 'Long-form SEO blog post designed to rank for informational keywords.',
 '{"has_intro":true,"has_conclusion":true,"has_toc":true,"heading_structure":["H1","H2","H3"],"recommended_sections":["Introduction","Main Body","FAQ","Conclusion"]}',
 '{"keyword_in_title":true,"keyword_in_first_100_words":true,"meta_description_required":true,"internal_links_min":2,"external_links_min":1,"keyword_density_min":0.5,"keyword_density_max":2.0}',
 '{"intro":{"required":true,"word_count":"100-150","has_hook":true},"body":{"required":true,"min_h2":3,"min_h3":2},"faq":{"required":false,"questions":"3-5"},"conclusion":{"required":true,"has_cta":true}}',
 1000, 2500),

('Landing Page', 'landing-page', 'on_page', 'High-conversion landing page focused on a single offer or CTA.',
 '{"has_hero":true,"has_benefits":true,"has_social_proof":true,"has_cta":true,"heading_structure":["H1","H2"]}',
 '{"keyword_in_title":true,"keyword_in_first_paragraph":true,"meta_description_required":true,"conversion_focused":true}',
 '{"hero":{"required":true,"has_headline":true,"has_subheadline":true},"benefits":{"required":true,"min_points":3},"social_proof":{"required":false},"cta_sections":{"required":true,"min_ctas":2}}',
 500, 1500),

('Service Page', 'service-page', 'on_page', 'Detailed service description page targeting commercial intent keywords.',
 '{"has_intro":true,"has_features":true,"has_process":true,"has_cta":true,"heading_structure":["H1","H2","H3"]}',
 '{"keyword_in_title":true,"keyword_in_first_100_words":true,"meta_description_required":true,"local_seo":false}',
 '{"intro":{"required":true},"features":{"required":true,"min_items":4},"process":{"required":false},"pricing":{"required":false},"cta":{"required":true}}',
 800, 2000),

('Guest Post', 'guest-post', 'off_page', 'High-quality article for third-party publication with natural backlink placement.',
 '{"has_intro":true,"has_conclusion":true,"heading_structure":["H1","H2","H3"],"bio_required":true}',
 '{"natural_link_placement":true,"keyword_density_min":0.3,"keyword_density_max":1.0,"no_promotional_tone":true}',
 '{"intro":{"required":true},"body":{"required":true,"min_h2":3},"backlink_anchor":{"required":true,"max_links":2},"bio":{"required":true,"word_count":"50-100"}}',
 800, 2000),

('PR Article', 'pr-article', 'off_page', 'Press release style article for news distribution and brand mentions.',
 '{"inverted_pyramid":true,"has_dateline":true,"has_boilerplate":true,"heading_structure":["H1","H2"]}',
 '{"brand_name_in_title":true,"keyword_density_min":0.2,"keyword_density_max":0.8,"journalistic_tone":true}',
 '{"headline":{"required":true},"dateline":{"required":true},"lead":{"required":true,"word_count":"50-75"},"body":{"required":true},"quote":{"required":false},"boilerplate":{"required":true}}',
 400, 1000),

('Quora Answer', 'quora-answer', 'off_page', 'Authoritative Quora-style answer that provides value and drives traffic.',
 '{"conversational":true,"has_hook":true,"heading_structure":["H2","H3"],"short_paragraphs":true}',
 '{"keyword_in_first_sentence":true,"answer_the_question_directly":true,"no_keyword_stuffing":true}',
 '{"hook":{"required":true,"word_count":"20-40"},"answer":{"required":true,"structured":true},"elaboration":{"required":true},"cta":{"required":false}}',
 200, 600);
