-- Seed Data for Analytics Pipeline
-- Run after schema.sql: mysql -u root -p analytics < seed.sql

USE analytics;

-- ============================================================
-- pageviews — 30 rows across 5 sessions over 7 days
-- ============================================================
INSERT INTO pageviews (url, type, user_agent, viewport_width, viewport_height, referrer, client_timestamp, server_timestamp, client_ip, session_id, payload) VALUES
-- Session 1: sess_a1b2c3 — Desktop Chrome user from Google (Day 1)
('/index.html',          'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, 'https://www.google.com/search?q=analytics+demo', '2026-02-10 09:00:00', '2026-02-10 09:00:01', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 100}'),
('/about.html',          'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/index.html',                                   '2026-02-10 09:02:30', '2026-02-10 09:02:31', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 75}'),
('/products.html',       'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/about.html',                                   '2026-02-10 09:05:12', '2026-02-10 09:05:13', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 50}'),
('/contact.html',        'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/products.html',                                '2026-02-10 09:08:45', '2026-02-10 09:08:46', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 100}'),
('/blog/post-1.html',    'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/contact.html',                                 '2026-02-10 09:12:00', '2026-02-10 09:12:01', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 60}'),
('/blog/post-2.html',    'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/blog/post-1.html',                             '2026-02-10 09:18:30', '2026-02-10 09:18:31', '203.0.113.10', 'sess_a1b2c3', '{"scrollDepth": 80}'),

-- Session 2: sess_d4e5f6 — Mobile Safari user, direct visit (Day 2)
('/index.html',          'pageview', 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 390, 844, NULL, '2026-02-11 14:22:00', '2026-02-11 14:22:01', '198.51.100.22', 'sess_d4e5f6', '{"scrollDepth": 100}'),
('/products.html',       'pageview', 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 390, 844, '/index.html', '2026-02-11 14:23:15', '2026-02-11 14:23:16', '198.51.100.22', 'sess_d4e5f6', '{"scrollDepth": 40}'),
('/products.html',       'event',    'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 390, 844, '/index.html', '2026-02-11 14:24:00', '2026-02-11 14:24:01', '198.51.100.22', 'sess_d4e5f6', '{"event": "add_to_cart", "productId": "SKU-1234"}'),
('/contact.html',        'pageview', 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 390, 844, '/products.html', '2026-02-11 14:26:30', '2026-02-11 14:26:31', '198.51.100.22', 'sess_d4e5f6', '{"scrollDepth": 100}'),

-- Session 3: sess_g7h8i9 — Firefox on Linux, from Twitter (Day 3-4)
('/blog/post-1.html',    'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, 'https://twitter.com/someuser/status/123456789', '2026-02-12 20:10:00', '2026-02-12 20:10:01', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 100}'),
('/blog/post-2.html',    'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, '/blog/post-1.html', '2026-02-12 20:15:30', '2026-02-12 20:15:31', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 90}'),
('/blog/post-3.html',    'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, '/blog/post-2.html', '2026-02-12 20:22:00', '2026-02-12 20:22:01', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 65}'),
('/index.html',          'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, '/blog/post-3.html', '2026-02-12 20:28:00', '2026-02-12 20:28:01', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 100}'),
('/about.html',          'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, '/index.html', '2026-02-12 20:30:45', '2026-02-12 20:30:46', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 55}'),
-- Same session_id, next day (new session due to >30 min gap)
('/index.html',          'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, 'https://www.google.com/search?q=cse135+site', '2026-02-13 10:00:00', '2026-02-13 10:00:01', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 100}'),
('/products.html',       'pageview', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, '/index.html', '2026-02-13 10:03:20', '2026-02-13 10:03:21', '192.0.2.45', 'sess_g7h8i9', '{"scrollDepth": 70}'),

-- Session 4: sess_j0k1l2 — Edge on Windows, from Google (Day 5)
('/index.html',          'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 1366, 768, 'https://www.google.com/search?q=web+analytics+project', '2026-02-14 11:30:00', '2026-02-14 11:30:01', '203.0.113.55', 'sess_j0k1l2', '{"scrollDepth": 100}'),
('/about.html',          'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 1366, 768, '/index.html', '2026-02-14 11:32:10', '2026-02-14 11:32:11', '203.0.113.55', 'sess_j0k1l2', '{"scrollDepth": 80}'),
('/products.html',       'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 1366, 768, '/about.html', '2026-02-14 11:35:45', '2026-02-14 11:35:46', '203.0.113.55', 'sess_j0k1l2', '{"scrollDepth": 90}'),
('/blog/post-3.html',    'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 1366, 768, '/products.html', '2026-02-14 11:40:00', '2026-02-14 11:40:01', '203.0.113.55', 'sess_j0k1l2', '{"scrollDepth": 100}'),

-- Session 5: sess_m3n4o5 — Tablet iPad, direct visit (Day 6-7)
('/index.html',          'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, NULL, '2026-02-15 16:00:00', '2026-02-15 16:00:01', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 100}'),
('/about.html',          'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, '/index.html', '2026-02-15 16:02:00', '2026-02-15 16:02:01', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 60}'),
('/contact.html',        'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, '/about.html', '2026-02-15 16:05:30', '2026-02-15 16:05:31', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 100}'),
('/index.html',          'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, 'https://www.google.com/search?q=analytics+tutorial', '2026-02-16 08:15:00', '2026-02-16 08:15:01', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 100}'),
('/blog/post-1.html',    'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, '/index.html', '2026-02-16 08:18:00', '2026-02-16 08:18:01', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 85}'),
('/blog/post-2.html',    'pageview', 'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1', 1024, 1366, '/blog/post-1.html', '2026-02-16 08:22:30', '2026-02-16 08:22:31', '198.51.100.88', 'sess_m3n4o5', '{"scrollDepth": 70}'),

-- Additional pageviews with error and performance types
('/products.html',       'error',       'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, '/index.html', '2026-02-11 10:05:00', '2026-02-11 10:05:01', '203.0.113.10', 'sess_a1b2c3', '{"error": "TypeError: Cannot read properties of undefined"}'),
('/index.html',          'performance', 'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0', 1440, 900, NULL, '2026-02-12 20:10:05', '2026-02-12 20:10:06', '192.0.2.45', 'sess_g7h8i9', '{"lcp": 2150.30, "cls": 0.05}'),
('/contact.html',        'pageview', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 1920, 1080, 'https://www.google.com/search?q=contact+form', '2026-02-16 14:00:00', '2026-02-16 14:00:01', '203.0.113.77', 'sess_a1b2c3', '{"scrollDepth": 100}');

-- ============================================================
-- events — 10 custom events
-- ============================================================
INSERT INTO events (session_id, event_name, event_category, event_data, url, server_timestamp) VALUES
('sess_a1b2c3', 'click',        'navigation',  '{"target": "nav-link-about", "text": "About Us"}',              '/index.html',       '2026-02-10 09:00:45'),
('sess_a1b2c3', 'click',        'navigation',  '{"target": "nav-link-products", "text": "Products"}',           '/about.html',       '2026-02-10 09:02:50'),
('sess_a1b2c3', 'scroll',       'engagement',  '{"depth": 75, "direction": "down"}',                            '/products.html',    '2026-02-10 09:06:00'),
('sess_d4e5f6', 'click',        'conversion',  '{"target": "btn-add-to-cart", "productId": "SKU-1234"}',        '/products.html',    '2026-02-11 14:24:00'),
('sess_d4e5f6', 'form_submit',  'conversion',  '{"formId": "contact-form", "fields": 4}',                       '/contact.html',     '2026-02-11 14:27:15'),
('sess_g7h8i9', 'scroll',       'engagement',  '{"depth": 100, "direction": "down"}',                           '/blog/post-1.html', '2026-02-12 20:13:00'),
('sess_g7h8i9', 'click',        'navigation',  '{"target": "related-post-link", "text": "Read more"}',          '/blog/post-2.html', '2026-02-12 20:18:30'),
('sess_j0k1l2', 'scroll',       'engagement',  '{"depth": 50, "direction": "down"}',                            '/about.html',       '2026-02-14 11:33:00'),
('sess_j0k1l2', 'click',        'navigation',  '{"target": "cta-button", "text": "View Products"}',             '/about.html',       '2026-02-14 11:33:45'),
('sess_m3n4o5', 'form_submit',  'conversion',  '{"formId": "newsletter-signup", "fields": 2, "email": true}',   '/contact.html',     '2026-02-15 16:06:00');

-- ============================================================
-- errors — 8 JavaScript errors
-- ============================================================
INSERT INTO errors (session_id, error_message, error_source, error_line, error_column, stack_trace, url, user_agent, server_timestamp) VALUES
('sess_a1b2c3', 'TypeError: Cannot read properties of undefined (reading ''map'')',
    'https://example.com/assets/js/app.bundle.js', 142, 18,
    'TypeError: Cannot read properties of undefined (reading ''map'')\n    at renderProducts (app.bundle.js:142:18)\n    at Object.init (app.bundle.js:85:5)\n    at HTMLDocument.<anonymous> (app.bundle.js:12:3)',
    '/products.html',
    'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',
    '2026-02-10 09:05:20'),

('sess_d4e5f6', 'ReferenceError: analytics is not defined',
    'https://example.com/assets/js/tracking.js', 8, 1,
    'ReferenceError: analytics is not defined\n    at sendEvent (tracking.js:8:1)\n    at HTMLButtonElement.onclick (products.html:45:12)',
    '/products.html',
    'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1',
    '2026-02-11 14:24:05'),

('sess_g7h8i9', 'SyntaxError: Unexpected token < in JSON at position 0',
    'https://example.com/assets/js/api-client.js', 56, 22,
    'SyntaxError: Unexpected token < in JSON at position 0\n    at JSON.parse (<anonymous>)\n    at fetchData (api-client.js:56:22)\n    at async loadComments (comments.js:12:15)',
    '/blog/post-1.html',
    'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0',
    '2026-02-12 20:11:30'),

('sess_g7h8i9', 'TypeError: document.querySelector(...) is null',
    'https://example.com/assets/js/carousel.js', 23, 5,
    'TypeError: document.querySelector(...) is null\n    at initCarousel (carousel.js:23:5)\n    at onDOMReady (app.bundle.js:18:9)',
    '/index.html',
    'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0',
    '2026-02-12 20:28:05'),

('sess_j0k1l2', 'TypeError: Failed to fetch',
    'https://example.com/assets/js/api-client.js', 34, 10,
    'TypeError: Failed to fetch\n    at fetchWithRetry (api-client.js:34:10)\n    at async loadProducts (products.js:22:18)',
    '/products.html',
    'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0',
    '2026-02-14 11:36:00'),

('sess_m3n4o5', 'ReferenceError: submitForm is not defined',
    'https://example.com/assets/js/forms.js', 67, 3,
    'ReferenceError: submitForm is not defined\n    at HTMLFormElement.onsubmit (contact.html:78:5)',
    '/contact.html',
    'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1',
    '2026-02-15 16:06:10'),

('sess_a1b2c3', 'TypeError: Cannot read properties of null (reading ''addEventListener'')',
    'https://example.com/assets/js/app.bundle.js', 205, 32,
    'TypeError: Cannot read properties of null (reading ''addEventListener'')\n    at bindEvents (app.bundle.js:205:32)\n    at Object.init (app.bundle.js:88:5)\n    at HTMLDocument.<anonymous> (app.bundle.js:12:3)',
    '/contact.html',
    'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36',
    '2026-02-16 14:00:10'),

('sess_m3n4o5', 'SyntaxError: Unexpected end of input',
    'https://example.com/assets/js/utils.js', 112, 1,
    'SyntaxError: Unexpected end of input\n    at parseConfig (utils.js:112:1)\n    at initApp (app.bundle.js:5:8)',
    '/index.html',
    'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1',
    '2026-02-16 08:15:05');

-- ============================================================
-- performance — 15 rows with realistic timing values
-- ============================================================
INSERT INTO performance (session_id, url, ttfb, dom_content_loaded, dom_complete, load_time, lcp, cls, inp, fcp, transfer_size, resource_count, server_timestamp) VALUES
('sess_a1b2c3', '/index.html',       85,  420,  890,  950,  1850.45, 0.0320, 95.00,  1120.30, 524288,  42, '2026-02-10 09:00:02'),
('sess_a1b2c3', '/about.html',       72,  380,  720,  780,  1520.80, 0.0150, 72.50,  980.20,  312400,  28, '2026-02-10 09:02:32'),
('sess_a1b2c3', '/products.html',    210, 950,  1800, 2100, 3200.15, 0.1850, 245.00, 1680.40, 1048576, 67, '2026-02-10 09:05:14'),
('sess_d4e5f6', '/index.html',       320, 1200, 2400, 2800, 3450.60, 0.2100, 380.00, 2100.50, 524288,  42, '2026-02-11 14:22:02'),
('sess_d4e5f6', '/products.html',    280, 1100, 2100, 2500, 3100.25, 0.1920, 310.50, 1950.30, 1048576, 67, '2026-02-11 14:23:17'),
('sess_d4e5f6', '/contact.html',     95,  450,  850,  920,  1680.90, 0.0280, 88.00,  1050.10, 204800,  22, '2026-02-11 14:26:32'),
('sess_g7h8i9', '/blog/post-1.html', 110, 520,  980,  1050, 2050.30, 0.0450, 120.50, 1240.60, 409600,  35, '2026-02-12 20:10:02'),
('sess_g7h8i9', '/blog/post-2.html', 98,  480,  920,  990,  1920.70, 0.0380, 105.00, 1180.20, 385024,  33, '2026-02-12 20:15:32'),
('sess_g7h8i9', '/blog/post-3.html', 105, 500,  950,  1020, 1980.50, 0.0410, 115.30, 1200.80, 393216,  34, '2026-02-12 20:22:02'),
('sess_g7h8i9', '/index.html',       78,  400,  810,  870,  1750.20, 0.0290, 82.00,  1080.50, 524288,  42, '2026-02-13 10:00:02'),
('sess_j0k1l2', '/index.html',       92,  440,  860,  930,  1800.60, 0.0350, 90.50,  1100.40, 524288,  42, '2026-02-14 11:30:02'),
('sess_j0k1l2', '/about.html',       68,  360,  700,  760,  1480.30, 0.0120, 68.00,  960.50,  312400,  28, '2026-02-14 11:32:12'),
('sess_j0k1l2', '/products.html',    195, 920,  1750, 2050, 3150.40, 0.1780, 235.00, 1650.20, 1048576, 67, '2026-02-14 11:35:47'),
('sess_m3n4o5', '/index.html',       180, 780,  1500, 1800, 2680.90, 0.0980, 190.50, 1520.30, 524288,  42, '2026-02-15 16:00:02'),
('sess_m3n4o5', '/contact.html',     150, 620,  1200, 1400, 2250.10, 0.0720, 155.00, 1350.80, 204800,  22, '2026-02-15 16:05:32');

-- ============================================================
-- sessions — 5 sessions (note: sess_g7h8i9 has 2 sessions due to >30 min gap)
-- ============================================================
INSERT INTO sessions (session_id, first_page, last_page, page_count, start_time, last_activity, duration_seconds, referrer, user_agent) VALUES
('sess_a1b2c3', '/index.html',       '/blog/post-2.html', 6, '2026-02-10 09:00:01', '2026-02-10 09:18:31', 1110,
    'https://www.google.com/search?q=analytics+demo',
    'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36'),

('sess_d4e5f6', '/index.html',       '/contact.html',     3, '2026-02-11 14:22:01', '2026-02-11 14:26:31', 270,
    NULL,
    'Mozilla/5.0 (iPhone; CPU iPhone OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1'),

('sess_g7h8i9', '/blog/post-1.html', '/about.html',       5, '2026-02-12 20:10:01', '2026-02-12 20:30:46', 1245,
    'https://twitter.com/someuser/status/123456789',
    'Mozilla/5.0 (X11; Linux x86_64; rv:121.0) Gecko/20100101 Firefox/121.0'),

('sess_j0k1l2', '/index.html',       '/blog/post-3.html', 4, '2026-02-14 11:30:01', '2026-02-14 11:40:01', 600,
    'https://www.google.com/search?q=web+analytics+project',
    'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0'),

('sess_m3n4o5', '/index.html',       '/contact.html',     3, '2026-02-15 16:00:01', '2026-02-15 16:05:31', 330,
    NULL,
    'Mozilla/5.0 (iPad; CPU OS 17_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2 Mobile/15E148 Safari/604.1');

-- ============================================================
-- users — 3 dashboard accounts
-- ============================================================
INSERT INTO users (email, password_hash, display_name, role, last_login) VALUES
('owner@example.com', '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LJZdL17lhWy', 'Alice Owner',  'owner',  '2026-02-16 09:30:00'),
('admin@example.com', '$2b$10$EixZaYVK1fsbw1ZfbX3OXePaWxn96p36WQoeG6Lruj3vjPGga31lW', 'Bob Admin',    'admin',  '2026-02-15 14:22:00'),
('viewer@example.com','$2b$10$YbB8M2VkjZGBB7R7g.1stO1B9OvL5X0OCzAQ3c8M.0j7yZK1e05Wy', 'Carol Viewer', 'viewer', '2026-02-14 11:00:00');
