-- ============================================================================
-- Optional demo/seed data. Safe to skip in production.
-- Demo password for the seeded user is "Password123!" (bcrypt hash below).
-- ============================================================================

INSERT INTO users (name, email, password) VALUES
('Demo Merchant', 'demo@microshopify.test', '$2a$10$1Kd0Q1TzR7z9m1r9m2iCwOe4o2m9d3nCw5b1F0k9m0hR6uF1t9G0e');

INSERT INTO stores (user_id, name, slug, description) VALUES
(1, 'BreadCraft Bakery', 'breadcraft', 'Handmade artisan bread and pastries, baked fresh daily.');

INSERT INTO categories (store_id, name, slug) VALUES
(1, 'Breads', 'breads'),
(1, 'Pastries', 'pastries'),
(1, 'Beverages', 'beverages');

INSERT INTO products (store_id, category_id, title, description, price, compare_price, inventory, status) VALUES
(1, 1, 'Sourdough Loaf', 'Naturally leavened sourdough with a crisp crust.', 6.50, 8.00, 25, 'active'),
(1, 1, 'Whole Wheat Loaf', '100% whole wheat, soft crumb.', 5.00, NULL, 30, 'active'),
(1, 2, 'Butter Croissant', 'Flaky, buttery, baked fresh every morning.', 3.25, NULL, 40, 'active'),
(1, 3, 'Cold Brew Coffee', 'Smooth 16oz cold brew.', 4.00, NULL, 50, 'active');