-- ══════════════════════════════════════════════════════════════
-- seed.sql — random placeholder content, per your instructions
-- ("use random generated texts and image, I will replace it on
-- the admin settings later"). Everything here is editable from
-- Admin -> Feed Manager and Admin -> Control Panel.
-- Run after schema.sql: mysql -u USER -p DBNAME < seed.sql
-- ══════════════════════════════════════════════════════════════

INSERT INTO afn_business_profile (id, name, category_label, logo_url, cover_media_url, rating, review_count, trust_strip, reply_time_label, whatsapp_number, phone_number, address, updated_at)
VALUES (
	1, 'Acrylic Frame Nigeria', 'Acrylic Frame Shop',
	'https://placehold.co/200x200/075E54/ffffff?text=AF',
	'https://placehold.co/960x420/128C7E/ffffff?text=Acrylic+Frame+Nigeria',
	4.9, 523,
	'500+ frames delivered · Lagos, PH, Abuja, Enugu · Secure payments',
	'Replies fast',
	'2348000000000', '2348000000000', 'Placeholder address — update in Feed Manager',
	NOW()
) ON DUPLICATE KEY UPDATE updated_at = NOW();

INSERT INTO afn_products (name, size_label, price, image_url, active, sort_order, created_at, updated_at) VALUES
('24 x 36 Acrylic Frame', '24 x 36', 58000.00, 'https://placehold.co/600x750/1d2b24/ffffff?text=24x36', 1, 1, NOW(), NOW()),
('20 x 24 Acrylic Frame', '20 x 24', 42000.00, 'https://placehold.co/600x750/1d2b24/ffffff?text=20x24', 1, 2, NOW(), NOW()),
('16 x 20 Acrylic Frame', '16 x 20', 32000.00, 'https://placehold.co/600x750/1d2b24/ffffff?text=16x20', 1, 3, NOW(), NOW()),
('12 x 16 Acrylic Frame', '12 x 16', 22000.00, 'https://placehold.co/600x750/1d2b24/ffffff?text=12x16', 1, 4, NOW(), NOW());

INSERT INTO afn_posts (type, product_id, media_url, media_type, thumbnail_url, caption, detail_chips, published, order_index, created_at, updated_at) VALUES
('product', 1, '', 'video', 'https://placehold.co/600x750/1d2b24/ffffff?text=24x36+video', 'Turn your memories into timeless art. Premium quality. Crystal clear. Built to last.', JSON_ARRAY('Size: 24 x 36', '5mm Acrylic', 'Ready to hang'), 1, 1, NOW(), NOW()),
('product', 2, '', 'image', 'https://placehold.co/600x750/1d2b24/ffffff?text=20x24+photo', 'High definition print. Real 5mm acrylic. Perfect for your home and office.', JSON_ARRAY('Size: 20 x 24', '5mm Acrylic', 'Free delivery*'), 1, 2, NOW(), NOW()),
('lifestyle', 3, '', 'image', 'https://placehold.co/600x750/1d2b24/ffffff?text=Lifestyle', 'A living-room-ready frame that survives daily glances and still looks brand new.', JSON_ARRAY('Size: 16 x 20', 'Couple'), 1, 3, NOW(), NOW()),
('social_proof', NULL, '', 'image', 'https://placehold.co/600x750/1d2b24/ffffff?text=Reviews', '"Delivered exactly on time and the quality blew me away." — placeholder review, replace with a real one.', JSON_ARRAY('500+ delivered'), 1, 4, NOW(), NOW());

-- Admin login is NOT seeded here on purpose — the first visit to
-- /admin/login.php auto-creates username "admin" / password
-- "change-me-now" (see admin/auth.php -> afn_ensure_admin_seed()),
-- with a correctly generated bcrypt hash for your actual PHP build.
-- Log in once, then change that password immediately.
