-- Starter templates seed — safe to re-run (INSERT IGNORE).
-- json_data encodes a section list, colour palette, and font choices per template.

INSERT IGNORE INTO `templates`
    (`id`, `name`, `description`, `industry`, `style`, `thumbnail`, `json_data`, `tags`, `is_active`, `sort_order`)
VALUES

-- ── Hotel ─────────────────────────────────────────────────────────────────────
(1, 'Grand Retreat', 'A luxury hotel landing page with full-screen imagery and room booking.', 'hotel', 'luxury',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','rooms','amenities','booking','gallery','testimonials','contact'),
   'colors',   JSON_OBJECT('primary','#b8962e','secondary','#1a1a2e','accent','#e8d5a3','text','#1a1a2e','bg','#fdfaf5'),
   'fonts',    JSON_OBJECT('heading','Playfair Display','body','Lato'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('hotel','luxury','booking','rooms'), 1, 10),

(2, 'Urban Stay', 'A clean modern hotel site with dark photography and minimal layout.', 'hotel', 'dark',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','rooms','features','gallery','map','contact'),
   'colors',   JSON_OBJECT('primary','#6366f1','secondary','#0f172a','accent','#f1f5f9','text','#f8fafc','bg','#0f172a'),
   'fonts',    JSON_OBJECT('heading','Inter','body','Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('hotel','dark','modern'), 1, 20),

-- ── Restaurant ────────────────────────────────────────────────────────────────
(3, 'Bistro Luxe', 'An elegant restaurant website with a full menu and table reservation.', 'restaurant', 'luxury',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','about','menu','gallery','reservation','testimonials','contact'),
   'colors',   JSON_OBJECT('primary','#c0392b','secondary','#2c2c2c','accent','#f5cba7','text','#2c2c2c','bg','#fffdf8'),
   'fonts',    JSON_OBJECT('heading','Cormorant Garamond','body','Source Sans Pro'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('restaurant','luxury','menu','reservation'), 1, 10),

(4, 'Street Eats', 'A vibrant casual dining site with delivery ordering and a bold colour scheme.', 'restaurant', 'modern',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','menu','delivery','gallery','reviews','contact'),
   'colors',   JSON_OBJECT('primary','#f97316','secondary','#fff7ed','accent','#ea580c','text','#1c1917','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','Poppins','body','Open Sans'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('restaurant','modern','delivery','menu'), 1, 20),

-- ── Church ────────────────────────────────────────────────────────────────────
(5, 'Grace & Light', 'A warm church website with service times, sermons, and giving.', 'church', 'modern',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','about','services','sermons','events','giving','contact'),
   'colors',   JSON_OBJECT('primary','#7c3aed','secondary','#ede9fe','accent','#a78bfa','text','#1e1b4b','bg','#fafafa'),
   'fonts',    JSON_OBJECT('heading','Merriweather','body','Open Sans'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('church','sermons','giving','events'), 1, 10),

(6, 'The Cornerstone', 'A bold, dark ministry site with video sermons and prayer request form.', 'church', 'dark',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','mission','sermons','events','prayer','giving','contact'),
   'colors',   JSON_OBJECT('primary','#f59e0b','secondary','#1c1917','accent','#fbbf24','text','#f5f5f4','bg','#0c0a09'),
   'fonts',    JSON_OBJECT('heading','Bebas Neue','body','Roboto'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('church','dark','ministry','prayer'), 1, 20),

-- ── Shipping / Logistics ──────────────────────────────────────────────────────
(7, 'SwiftCargo', 'A professional logistics site with shipment tracking and quote forms.', 'shipping', 'corporate',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','services','tracking','coverage','fleet','team','contact'),
   'colors',   JSON_OBJECT('primary','#1d4ed8','secondary','#eff6ff','accent','#f59e0b','text','#1e3a5f','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','Montserrat','body','Roboto'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('shipping','tracking','quote','logistics'), 1, 10),

-- ── Visa / Immigration ────────────────────────────────────────────────────────
(8, 'PassPro', 'A clean immigration consultancy site with eligibility tool and booking.', 'visa', 'apple',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','services','eligibility','process','team','testimonials','contact'),
   'colors',   JSON_OBJECT('primary','#0ea5e9','secondary','#f0f9ff','accent','#0284c7','text','#0c4a6e','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','SF Pro Display, Inter','body','SF Pro Text, Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('visa','immigration','booking','eligibility'), 1, 10),

-- ── Store / E-Commerce ────────────────────────────────────────────────────────
(9, 'ShopFlow', 'A clean e-commerce store with product catalogue, cart, and checkout.', 'store', 'modern',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','featured','categories','products','testimonials','newsletter','contact'),
   'colors',   JSON_OBJECT('primary','#ec4899','secondary','#fdf2f8','accent','#db2777','text','#1e1b2e','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','Poppins','body','Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('store','ecommerce','products','cart'), 1, 10),

-- ── Education ─────────────────────────────────────────────────────────────────
(10, 'EduReach', 'A modern school or academy site with course catalogue and enrolment.', 'education', 'modern',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','courses','features','teachers','testimonials','enrolment','contact'),
   'colors',   JSON_OBJECT('primary','#10b981','secondary','#ecfdf5','accent','#059669','text','#064e3b','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','Nunito','body','Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('education','courses','enrolment','school'), 1, 10),

-- ── Agency ────────────────────────────────────────────────────────────────────
(11, 'ApexStudio', 'A bold dark agency site with portfolio, services, and team.', 'agency', 'dark',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','services','portfolio','process','team','testimonials','contact'),
   'colors',   JSON_OBJECT('primary','#6366f1','secondary','#1e1b4b','accent','#a5b4fc','text','#e0e7ff','bg','#0f0e17'),
   'fonts',    JSON_OBJECT('heading','Space Grotesk','body','Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('agency','portfolio','dark','creative'), 1, 10),

(12, 'ClearMark', 'A minimal Apple-inspired agency site with case studies and elegant type.', 'agency', 'apple',
 NULL,
 JSON_OBJECT(
   'sections', JSON_ARRAY('hero','services','work','process','team','contact'),
   'colors',   JSON_OBJECT('primary','#000000','secondary','#f5f5f7','accent','#0071e3','text','#1d1d1f','bg','#ffffff'),
   'fonts',    JSON_OBJECT('heading','SF Pro Display, Inter','body','SF Pro Text, Inter'),
   'layout',   'full-width'
 ),
 JSON_ARRAY('agency','minimal','apple','portfolio'), 1, 20);
