-- Selfie Petti — keep users, wipe demo data, load PRODUCTS PRICE.pdf
-- Run this in phpMyAdmin on database: selfiepetti
-- Safe to run more than once.

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

UPDATE invoice_settings SET next_number = 1;

SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO product_categories (name, description, is_active) VALUES
('Photography Products', NULL, 1),
('Arcade Games', NULL, 1),
('Carnival Games', NULL, 1);

INSERT INTO products (public_id, name, category_id, description, base_price, cost, service_duration, image_url, is_active, created_at, updated_at)
SELECT v.public_id, v.name, c.id, NULL, v.price, 0, NULL, NULL, 1, NOW(), NOW()
FROM (
    SELECT 'Selfie-PHO-001' AS public_id, 'Magazine Photobooth' AS name, 'Photography Products' AS category_name, 30000.00 AS price
    UNION ALL SELECT 'Selfie-PHO-002', 'Robot Photobooth', 'Photography Products', 25000.00
    UNION ALL SELECT 'Selfie-PHO-003', 'Mirror Photobooth', 'Photography Products', 15000.00
    UNION ALL SELECT 'Selfie-PHO-004', '360 Degree Video Booth', 'Photography Products', 6000.00
    UNION ALL SELECT 'Selfie-PHO-005', 'Top Model 360 Degree Video Booth', 'Photography Products', 10000.00
    UNION ALL SELECT 'Selfie-ARC-001', 'Bull Rider', 'Arcade Games', 25000.00
    UNION ALL SELECT 'Selfie-ARC-002', 'Hammer Striker', 'Arcade Games', 15000.00
    UNION ALL SELECT 'Selfie-ARC-003', 'Boxing Challenge', 'Arcade Games', 15000.00
    UNION ALL SELECT 'Selfie-ARC-004', 'Car Race Simulator', 'Arcade Games', 10000.00
    UNION ALL SELECT 'Selfie-ARC-005', 'Fruit Ninja', 'Arcade Games', 10000.00
    UNION ALL SELECT 'Selfie-ARC-006', 'VR - Roller Coaster', 'Arcade Games', 8500.00
    UNION ALL SELECT 'Selfie-ARC-007', 'VR - Richie''s Plank', 'Arcade Games', 7000.00
    UNION ALL SELECT 'Selfie-ARC-008', 'Batak Challenge', 'Arcade Games', 7000.00
    UNION ALL SELECT 'Selfie-ARC-009', 'Dragon Egg Catch', 'Arcade Games', 7000.00
    UNION ALL SELECT 'Selfie-ARC-010', 'Catch The Stick', 'Arcade Games', 6000.00
    UNION ALL SELECT 'Selfie-ARC-011', 'Grab it Quick', 'Arcade Games', 5000.00
    UNION ALL SELECT 'Selfie-ARC-012', 'Step and Run', 'Arcade Games', 5000.00
    UNION ALL SELECT 'Selfie-ARC-013', 'Whack the jerry', 'Arcade Games', 5000.00
    UNION ALL SELECT 'Selfie-ARC-014', 'The Vault Game', 'Arcade Games', 5000.00
    UNION ALL SELECT 'Selfie-ARC-015', 'Balloon Blast Game', 'Arcade Games', 4000.00
    UNION ALL SELECT 'Selfie-ARC-016', 'Touch Me Not Challenge', 'Arcade Games', 4000.00
    UNION ALL SELECT 'Selfie-ARC-017', 'Thug Race', 'Arcade Games', 4000.00
    UNION ALL SELECT 'Selfie-ARC-018', '10 Sec Timer Challenge', 'Arcade Games', 3000.00
    UNION ALL SELECT 'Selfie-ARC-019', 'Cyclone LED Challenge', 'Arcade Games', 2500.00
    UNION ALL SELECT 'Selfie-ARC-020', 'Meen Vettai', 'Arcade Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-001', 'Mini Basketball', 'Carnival Games', 7000.00
    UNION ALL SELECT 'Selfie-CAR-002', 'Target Ball Game', 'Carnival Games', 5000.00
    UNION ALL SELECT 'Selfie-CAR-003', 'Foos Ball', 'Carnival Games', 5000.00
    UNION ALL SELECT 'Selfie-CAR-004', 'Table Football 1vs1', 'Carnival Games', 5000.00
    UNION ALL SELECT 'Selfie-CAR-005', 'Wall Ball Maze Game', 'Carnival Games', 4000.00
    UNION ALL SELECT 'Selfie-CAR-006', 'Hanging Challenge', 'Carnival Games', 4000.00
    UNION ALL SELECT 'Selfie-CAR-007', 'Gel Blaster Challenge', 'Carnival Games', 4000.00
    UNION ALL SELECT 'Selfie-CAR-008', 'Air Gun shooting Challenge', 'Carnival Games', 3500.00
    UNION ALL SELECT 'Selfie-CAR-009', 'Archery', 'Carnival Games', 3000.00
    UNION ALL SELECT 'Selfie-CAR-010', 'Magnet Ball Table Game', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-011', 'Roll The Zig Zag Challenge', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-012', 'Toss The Ring', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-013', 'Toss the Ring into the Arch', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-014', 'Knock Down the Pins', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-015', 'Color Ball Matching Challenge', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-016', 'Wooden Sliding Escape Game', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-017', 'Catapult King Challenge', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-018', 'Capture the Kingdom Challenge', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-019', 'Balancing Plate Challenge', 'Carnival Games', 2500.00
    UNION ALL SELECT 'Selfie-CAR-020', 'Bumper Car Game', 'Carnival Games', 2500.00
) AS v
JOIN product_categories c ON c.name = v.category_name;