-- Sample Data for Sports Equipment Shop POS System
-- This file contains comprehensive test data

USE az_pos;

-- Clear existing data (optional - comment out if you want to keep existing data)
TRUNCATE TABLE invoice_items;
TRUNCATE TABLE invoices;
TRUNCATE TABLE grn_items;
TRUNCATE TABLE grns;
TRUNCATE TABLE stock_movements;
TRUNCATE TABLE customers;
TRUNCATE TABLE products;
TRUNCATE TABLE categories;
TRUNCATE TABLE activity_logs;

-- =====================================================
-- CATEGORIES
-- =====================================================
INSERT INTO categories (name, description, is_active, created_by) VALUES
('Team Sports', 'Equipment for football, basketball, volleyball, rugby, cricket', TRUE, 1),
('Racquet Sports', 'Tennis, badminton, table tennis, squash equipment', TRUE, 1),
('Fitness Equipment', 'Gym and workout equipment, weights, machines', TRUE, 1),
('Water Sports', 'Swimming, diving, water polo, surfing equipment', TRUE, 1),
('Outdoor Sports', 'Camping, hiking, cycling, climbing equipment', TRUE, 1),
('Athletic Wear', 'Sports clothing, jerseys, tracksuits, footwear', TRUE, 1),
('Accessories', 'Sports bags, water bottles, protective gear, bands', TRUE, 1),
('Martial Arts', 'Boxing, karate, taekwondo, MMA equipment', TRUE, 1),
('Winter Sports', 'Skiing, snowboarding, ice skating equipment', TRUE, 1),
('Golf & Disc Sports', 'Golf clubs, balls, disc golf equipment', TRUE, 1);

-- =====================================================
-- PRODUCTS - Team Sports (50 items)
-- =====================================================
INSERT INTO products (name, description, barcode, category_id, unit_price, cost_price, current_stock, min_stock_level, unit, is_active, created_by) VALUES
('Nike Premier League Football Size 5', 'Official match ball replica, FIFA Quality certified', '8801234567890', 1, 2500.00, 1800.00, 0, 5, 'pcs', TRUE, 1),
('Adidas Tango Football Size 4', 'Training football, durable TPU material', '8801234567891', 1, 1800.00, 1200.00, 0, 8, 'pcs', TRUE, 1),
('Molten Basketball GG7X', 'FIBA approved basketball, composite leather', '8801234567892', 1, 3500.00, 2500.00, 0, 5, 'pcs', TRUE, 1),
('Spalding NBA Street Basketball', 'Official size 7, indoor/outdoor', '8801234567893', 1, 2200.00, 1600.00, 0, 6, 'pcs', TRUE, 1),
('Mikasa Volleyball MVA200', 'Olympic volleyball, synthetic leather', '8801234567894', 1, 4500.00, 3200.00, 0, 4, 'pcs', TRUE, 1),
('Gilbert Rugby Ball Size 5', 'Match quality rugby ball', '8801234567895', 1, 3200.00, 2300.00, 0, 5, 'pcs', TRUE, 1),
('Cricket Leather Ball SG Test', 'Red leather cricket ball, 4 piece', '8801234567896', 1, 800.00, 550.00, 0, 20, 'pcs', TRUE, 1),
('Cricket Bat Kookaburra Ghost', 'English willow bat, short handle', '8801234567897', 1, 12000.00, 8500.00, 0, 3, 'pcs', TRUE, 1),
('Football Goal Net 24x8 ft', 'Heavy duty polyethylene net', '8801234567898', 1, 4500.00, 3000.00, 0, 2, 'pcs', TRUE, 1),
('Basketball Hoop Portable', 'Adjustable height, shatterproof backboard', '8801234567899', 1, 25000.00, 18000.00, 0, 2, 'pcs', TRUE, 1),
('Volleyball Net Professional', 'Competition grade net with cable', '8801234567900', 1, 3500.00, 2400.00, 0, 2, 'pcs', TRUE, 1),
('Football Shin Guards Nike', 'Mercurial lite guards with ankle protection', '8801234567901', 1, 1200.00, 800.00, 0, 15, 'pair', TRUE, 1),
('Basketball Knee Pads', 'Compression knee sleeves, breathable', '8801234567902', 1, 600.00, 400.00, 0, 20, 'pair', TRUE, 1),
('Cricket Helmet Masuri Vision', 'Steel grille, titanium shell', '8801234567903', 1, 8500.00, 6000.00, 0, 4, 'pcs', TRUE, 1),
('Football Goalkeeper Gloves', 'Professional latex palm gloves', '8801234567904', 1, 2500.00, 1700.00, 0, 10, 'pair', TRUE, 1),
('Basketball Shooting Sleeves', 'Compression arm sleeves, UV protection', '8801234567905', 1, 500.00, 300.00, 0, 25, 'pair', TRUE, 1),
('Rugby Shoulder Pads', 'Impact protection pads', '8801234567906', 1, 3500.00, 2400.00, 0, 8, 'pcs', TRUE, 1),
('Cricket Wicket Keeping Gloves', 'Leather palm, foam protection', '8801234567907', 1, 3500.00, 2400.00, 0, 6, 'pair', TRUE, 1),
('Football Training Cones Set', '20 pieces, multi-color cones', '8801234567908', 1, 800.00, 500.00, 0, 10, 'set', TRUE, 1),
('Basketball Training Ladder', 'Agility ladder, 15 rungs', '8801234567909', 1, 1500.00, 1000.00, 0, 8, 'pcs', TRUE, 1),
('Volleyball Knee Pads', 'Professional grade protection', '8801234567910', 1, 1200.00, 800.00, 0, 15, 'pair', TRUE, 1),
('Football Captain Armband', 'Elastic armband with C letter', '8801234567911', 1, 200.00, 120.00, 0, 30, 'pcs', TRUE, 1),
('Basketball Air Pump', 'Dual action pump with needle', '8801234567912', 1, 400.00, 250.00, 0, 20, 'pcs', TRUE, 1),
('Cricket Batting Pads', 'Lightweight, ambidextrous pads', '8801234567913', 1, 4500.00, 3200.00, 0, 5, 'pair', TRUE, 1),
('Football Referee Kit', 'Whistle, cards, coin, armband', '8801234567914', 1, 1500.00, 1000.00, 0, 8, 'set', TRUE, 1),
('Mini Football Size 1', 'Skills ball for training', '8801234567915', 1, 600.00, 400.00, 0, 15, 'pcs', TRUE, 1),
('Basketball Training Ball Size 6', 'Womens official size', '8801234567916', 1, 1800.00, 1300.00, 0, 8, 'pcs', TRUE, 1),
('Volleyball Beach Edition', 'Water resistant, bright colors', '8801234567917', 1, 2500.00, 1800.00, 0, 6, 'pcs', TRUE, 1),
('Cricket Ball Tennis', 'Practice ball, rubber core', '8801234567918', 1, 150.00, 90.00, 0, 50, 'pcs', TRUE, 1),
('Football Training Bibs Set', '10 pieces, reversible mesh bibs', '8801234567919', 1, 2000.00, 1400.00, 0, 5, 'set', TRUE, 1),
('Basketball Scoreboard Digital', 'LED display, wireless remote', '8801234567920', 1, 15000.00, 11000.00, 0, 2, 'pcs', TRUE, 1),
('Volleyball Antenna Set', 'Flexible antenna with net clips', '8801234567921', 1, 800.00, 550.00, 0, 10, 'set', TRUE, 1),
('Cricket Stumps Wooden', 'Full size stumps with bails', '8801234567922', 1, 2500.00, 1800.00, 0, 4, 'set', TRUE, 1),
('Football Corner Flags', 'Spring loaded base, set of 4', '8801234567923', 1, 3000.00, 2100.00, 0, 3, 'set', TRUE, 1),
('Basketball Shot Clock', '24 second shot clock system', '8801234567924', 1, 12000.00, 8500.00, 0, 2, 'pcs', TRUE, 1),
('Rugby Kicking Tee', 'Professional grade tee', '8801234567925', 1, 600.00, 400.00, 0, 15, 'pcs', TRUE, 1),
('Cricket Bowling Machine', 'Speed adjustable, battery powered', '8801234567926', 1, 45000.00, 32000.00, 0, 1, 'pcs', TRUE, 1),
('Football Speed Radar Gun', 'Measure shot speed, LCD display', '8801234567927', 1, 8500.00, 6000.00, 0, 2, 'pcs', TRUE, 1),
('Basketball Dribble Goggles', 'Training aid for ball handling', '8801234567928', 1, 800.00, 550.00, 0, 12, 'pcs', TRUE, 1),
('Volleyball Training Cart', 'Ball storage cart, holds 24 balls', '8801234567929', 1, 6500.00, 4500.00, 0, 2, 'pcs', TRUE, 1),
('Cricket Practice Net', '10x10 ft practice cage net', '8801234567930', 1, 8500.00, 6000.00, 0, 2, 'pcs', TRUE, 1),
('Football Free Kick Dummy', 'Inflatable wall dummy', '8801234567931', 1, 3500.00, 2500.00, 0, 5, 'pcs', TRUE, 1),
('Basketball Return System', 'Ball return attachment for hoop', '8801234567932', 1, 4500.00, 3200.00, 0, 3, 'pcs', TRUE, 1),
('Rugby Training Tackle Bags', 'Heavy duty tackle shield', '8801234567933', 1, 8500.00, 6000.00, 0, 3, 'pcs', TRUE, 1),
('Cricket Sight Screen', 'Portable sight screen on wheels', '8801234567934', 1, 15000.00, 11000.00, 0, 1, 'pcs', TRUE, 1),
('Football Agility Poles', 'Set of 6 flexible poles', '8801234567935', 1, 2500.00, 1800.00, 0, 6, 'set', TRUE, 1),
('Basketball Rebounder Net', 'Spring loaded return net', '8801234567936', 1, 12000.00, 8500.00, 0, 2, 'pcs', TRUE, 1),
('Volleyball Serving Trainer', 'Target zones training aid', '8801234567937', 1, 3500.00, 2500.00, 0, 4, 'pcs', TRUE, 1),
('Cricket Slip Cradle', 'Catching practice cradle', '8801234567938', 1, 5500.00, 4000.00, 0, 3, 'pcs', TRUE, 1),
('Football Wall Rebounder', 'Kickback training wall', '8801234567939', 1, 6500.00, 4800.00, 0, 3, 'pcs', TRUE, 1);

-- =====================================================
-- PRODUCTS - Racquet Sports (30 items)
-- =====================================================
INSERT INTO products (name, description, barcode, category_id, unit_price, cost_price, current_stock, min_stock_level, unit, is_active, created_by) VALUES
('Yonex Badminton Racket Nanoflare', 'Professional grade, sonic flare system', '8801234568001', 2, 8500.00, 6000.00, 0, 4, 'pcs', TRUE, 1),
('Wilson Tennis Racket Pro Staff', 'Advanced player racket, 97 sq inch', '8801234568002', 2, 15000.00, 11000.00, 0, 3, 'pcs', TRUE, 1),
('Butterfly Table Tennis Blade', 'Competition blade, all wood', '8801234568003', 2, 6500.00, 4800.00, 0, 5, 'pcs', TRUE, 1),
('Head Squash Racket Graphene', 'Lightweight graphene frame', '8801234568004', 2, 12000.00, 8500.00, 0, 3, 'pcs', TRUE, 1),
('Li-Ning Badminton Shuttlecock', 'Feather shuttlecock, tournament grade', '8801234568005', 2, 1500.00, 1100.00, 0, 20, 'tube', TRUE, 1),
('Wilson Tennis Balls Championship', 'Yellow felt balls, ITF approved', '8801234568006', 2, 800.00, 550.00, 0, 30, 'can', TRUE, 1),
('DHS Table Tennis Balls 3 Star', 'Competition balls, 40mm+', '8801234568007', 2, 350.00, 250.00, 0, 40, 'box', TRUE, 1),
('Dunlop Squash Balls Double Yellow', 'Professional level balls', '8801234568008', 2, 600.00, 400.00, 0, 25, 'box', TRUE, 1),
('Yonex Badminton Shoes SHB', 'Power cushion, toe assist shape', '8801234568009', 2, 6500.00, 4800.00, 0, 8, 'pair', TRUE, 1),
('Nike Tennis Shoes Court Vapor', 'All court tennis shoes', '8801234568010', 2, 8500.00, 6200.00, 0, 6, 'pair', TRUE, 1),
('Butterfly Table Tennis Shoes', 'Professional playing shoes', '8801234568011', 2, 5500.00, 4000.00, 0, 8, 'pair', TRUE, 1),
('Asics Squash Shoes Gel Court', 'Indoor court shoes, gel cushion', '8801234568012', 2, 7500.00, 5500.00, 0, 6, 'pair', TRUE, 1),
('Victor Badminton Racket Thruster', 'Attacking racket, aerodynamic frame', '8801234568013', 2, 7500.00, 5500.00, 0, 5, 'pcs', TRUE, 1),
('Babolat Tennis Racket Pure Drive', 'Power and control racket', '8801234568014', 2, 18000.00, 13000.00, 0, 3, 'pcs', TRUE, 1),
('Stiga Table Tennis Blade Pro', 'Offensive blade, 7 ply wood', '8801234568015', 2, 5500.00, 4000.00, 0, 6, 'pcs', TRUE, 1),
('Tecnifibre Squash Racket Carboflex', 'Ultra-light racket, carbon frame', '8801234568016', 2, 14000.00, 10000.00, 0, 3, 'pcs', TRUE, 1),
('Li-Ning Badminton Grip Overgrip', 'Sweat absorbent grip tape', '8801234568017', 2, 200.00, 130.00, 0, 50, 'pcs', TRUE, 1),
('Wilson Tennis String NXT', 'Multifilament string, 16 gauge', '8801234568018', 2, 1200.00, 850.00, 0, 20, 'set', TRUE, 1),
('Tibhar Table Tennis Rubber', 'Smooth rubber with sponge', '8801234568019', 2, 2500.00, 1800.00, 0, 15, 'sheet', TRUE, 1),
('Dunlop Squash String Iconic', 'Premium string, 1.20mm', '8801234568020', 2, 800.00, 550.00, 0, 20, 'set', TRUE, 1),
('Yonex Badminton Bag Tournament', 'Racket bag, holds 6 rackets', '8801234568021', 2, 4500.00, 3200.00, 0, 8, 'pcs', TRUE, 1),
('Wilson Tennis Bag Pro Staff', 'Thermal bag, 12 racket capacity', '8801234568022', 2, 8500.00, 6200.00, 0, 5, 'pcs', TRUE, 1),
('Butterfly Table Tennis Case', 'Hard case for blade and rubber', '8801234568023', 2, 1500.00, 1100.00, 0, 12, 'pcs', TRUE, 1),
('Head Squash Bag Tour Team', 'Backpack style, multiple compartments', '8801234568024', 2, 5500.00, 4000.00, 0, 6, 'pcs', TRUE, 1),
('Victor Badminton Net Tournament', 'Competition net with posts', '8801234568025', 2, 8500.00, 6200.00, 0, 3, 'set', TRUE, 1),
('Tennis Net Professional Grade', 'Heavy duty net with cable', '8801234568026', 2, 12000.00, 8800.00, 0, 2, 'pcs', TRUE, 1),
('Table Tennis Net Clip-On', 'Retractable net and post set', '8801234568027', 2, 1500.00, 1100.00, 0, 15, 'set', TRUE, 1),
('Squash Court Lines Tape', 'Self-adhesive court marking tape', '8801234568028', 2, 2500.00, 1800.00, 0, 8, 'roll', TRUE, 1),
('Badminton Court Mat Portable', 'Foldable court mat with lines', '8801234568029', 2, 15000.00, 11000.00, 0, 2, 'pcs', TRUE, 1),
('Tennis Ball Machine', 'Battery powered ball launcher', '8801234568030', 2, 55000.00, 40000.00, 0, 1, 'pcs', TRUE, 1);

-- =====================================================
-- PRODUCTS - Fitness Equipment (40 items)
-- =====================================================
INSERT INTO products (name, description, barcode, category_id, unit_price, cost_price, current_stock, min_stock_level, unit, is_active, created_by) VALUES
('Dumbbell Set 2.5kg Pair', 'Rubber coated hex dumbbells', '8801234569001', 3, 1500.00, 1100.00, 0, 10, 'pair', TRUE, 1),
('Dumbbell Set 5kg Pair', 'Rubber coated hex dumbbells', '8801234569002', 3, 2500.00, 1800.00, 0, 10, 'pair', TRUE, 1),
('Dumbbell Set 10kg Pair', 'Rubber coated hex dumbbells', '8801234569003', 3, 4500.00, 3200.00, 0, 8, 'pair', TRUE, 1),
('Dumbbell Set 15kg Pair', 'Rubber coated hex dumbbells', '8801234569004', 3, 6500.00, 4800.00, 0, 6, 'pair', TRUE, 1),
('Kettlebell 8kg', 'Cast iron kettlebell with vinyl coating', '8801234569005', 3, 2500.00, 1800.00, 0, 8, 'pcs', TRUE, 1),
('Kettlebell 12kg', 'Cast iron kettlebell with vinyl coating', '8801234569006', 3, 3500.00, 2500.00, 0, 6, 'pcs', TRUE, 1),
('Kettlebell 16kg', 'Cast iron kettlebell with vinyl coating', '8801234569007', 3, 4500.00, 3200.00, 0, 6, 'pcs', TRUE, 1),
('Resistance Bands Set', '5 levels resistance band set with handles', '8801234569008', 3, 1500.00, 1000.00, 0, 15, 'set', TRUE, 1),
('Yoga Mat Premium 6mm', 'Non-slip TPE yoga mat with bag', '8801234569009', 3, 1800.00, 1300.00, 0, 20, 'pcs', TRUE, 1),
('Yoga Mat Thick 10mm', 'Extra thick NBR foam mat', '8801234569010', 3, 2500.00, 1800.00, 0, 15, 'pcs', TRUE, 1),
('Exercise Ball 65cm', 'Anti-burst gym ball with pump', '8801234569011', 3, 1200.00, 850.00, 0, 12, 'pcs', TRUE, 1),
('Exercise Ball 75cm', 'Anti-burst gym ball with pump', '8801234569012', 3, 1500.00, 1100.00, 0, 10, 'pcs', TRUE, 1),
('Ab Roller Wheel', 'Dual wheel ab trainer with knee pad', '8801234569013', 3, 800.00, 550.00, 0, 20, 'pcs', TRUE, 1),
('Push Up Bars', 'Sturdy push up stands, foam grip', '8801234569014', 3, 600.00, 400.00, 0, 25, 'pair', TRUE, 1),
('Pull Up Bar Doorway', 'Adjustable door frame pull up bar', '8801234569015', 3, 2500.00, 1800.00, 0, 10, 'pcs', TRUE, 1),
('Jump Rope Speed', 'Adjustable steel cable jump rope', '8801234569016', 3, 400.00, 280.00, 0, 30, 'pcs', TRUE, 1),
('Gym Gloves Half Finger', 'Padded weight lifting gloves', '8801234569017', 3, 800.00, 550.00, 0, 20, 'pair', TRUE, 1),
('Weight Lifting Belt', 'Leather lifting belt, 4 inch wide', '8801234569018', 3, 2500.00, 1800.00, 0, 12, 'pcs', TRUE, 1),
('Barbell 20kg Olympic', 'Standard Olympic barbell, 7ft', '8801234569019', 3, 12000.00, 8800.00, 0, 3, 'pcs', TRUE, 1),
('Weight Plates 5kg Pair', 'Cast iron weight plates', '8801234569020', 3, 3500.00, 2500.00, 0, 8, 'pair', TRUE, 1),
('Weight Plates 10kg Pair', 'Cast iron weight plates', '8801234569021', 3, 6500.00, 4800.00, 0, 6, 'pair', TRUE, 1),
('Weight Bench Adjustable', 'Multi-position workout bench', '8801234569022', 3, 15000.00, 11000.00, 0, 3, 'pcs', TRUE, 1),
('Power Rack Home Gym', 'Heavy duty squat rack with pull up bar', '8801234569023', 3, 45000.00, 32000.00, 0, 2, 'pcs', TRUE, 1),
('Treadmill Electric', 'Motorized treadmill, 3HP motor', '8801234569024', 3, 85000.00, 62000.00, 0, 1, 'pcs', TRUE, 1),
('Exercise Bike Upright', 'Magnetic resistance bike, LCD display', '8801234569025', 3, 25000.00, 18000.00, 0, 2, 'pcs', TRUE, 1),
('Elliptical Trainer', 'Cross trainer with heart rate monitor', '8801234569026', 3, 55000.00, 40000.00, 0, 1, 'pcs', TRUE, 1),
('Rowing Machine', 'Air resistance rowing machine', '8801234569027', 3, 35000.00, 25000.00, 0, 2, 'pcs', TRUE, 1),
('Foam Roller 33cm', 'High density foam massage roller', '8801234569028', 3, 800.00, 550.00, 0, 15, 'pcs', TRUE, 1),
('Massage Ball Lacrosse', 'Trigger point therapy ball', '8801234569029', 3, 300.00, 200.00, 0, 30, 'pcs', TRUE, 1),
('Yoga Block Set', 'Cork yoga blocks, set of 2', '8801234569030', 3, 800.00, 550.00, 0, 20, 'set', TRUE, 1),
('Yoga Strap 8ft', 'Cotton yoga strap with D-ring', '8801234569031', 3, 400.00, 280.00, 0, 25, 'pcs', TRUE, 1),
('Medicine Ball 5kg', 'Rubber medicine ball with grip', '8801234569032', 3, 2500.00, 1800.00, 0, 8, 'pcs', TRUE, 1),
('Medicine Ball 8kg', 'Rubber medicine ball with grip', '8801234569033', 3, 3500.00, 2500.00, 0, 6, 'pcs', TRUE, 1),
('Battle Rope 15m', 'Heavy duty training rope', '8801234569034', 3, 8500.00, 6200.00, 0, 3, 'pcs', TRUE, 1),
('Suspension Trainer', 'TRX style bodyweight trainer', '8801234569035', 3, 4500.00, 3200.00, 0, 8, 'set', TRUE, 1),
('Agility Ladder 6m', 'Speed training ladder, 12 rungs', '8801234569036', 3, 1500.00, 1100.00, 0, 12, 'pcs', TRUE, 1),
('Plyo Box Set', 'Stackable plyo boxes 20/24/30 inch', '8801234569037', 3, 12000.00, 8800.00, 0, 3, 'set', TRUE, 1),
('Ankle Weights 1kg Pair', 'Adjustable ankle weights', '8801234569038', 3, 800.00, 550.00, 0, 15, 'pair', TRUE, 1),
('Wrist Weights 0.5kg Pair', 'Comfortable wrist weights', '8801234569039', 3, 600.00, 400.00, 0, 20, 'pair', TRUE, 1),
('Gym Mat Interlocking', 'EVA foam floor mat, 60x60cm', '8801234569040', 3, 400.00, 280.00, 0, 50, 'pcs', TRUE, 1);

-- Continue with more products in next insert...
-- =====================================================
-- PRODUCTS - Water Sports & Others (30 items)
-- =====================================================
INSERT INTO products (name, description, barcode, category_id, unit_price, cost_price, current_stock, min_stock_level, unit, is_active, created_by) VALUES
('Speedo Swimming Goggles', 'Anti-fog racing goggles', '8801234570001', 4, 1500.00, 1100.00, 0, 15, 'pcs', TRUE, 1),
('Arena Swim Cap Silicone', 'Professional silicone cap', '8801234570002', 4, 600.00, 400.00, 0, 25, 'pcs', TRUE, 1),
('Speedo Competition Swimsuit', 'Mens racing jammers', '8801234570003', 4, 4500.00, 3200.00, 0, 10, 'pcs', TRUE, 1),
('TYR Training Fins', 'Short blade training fins', '8801234570004', 4, 3500.00, 2500.00, 0, 8, 'pair', TRUE, 1),
('Finis Hand Paddles', 'Swimming hand paddles', '8801234570005', 4, 1500.00, 1100.00, 0, 12, 'pair', TRUE, 1),
('Pull Buoy Training', 'Foam pull buoy for training', '8801234570006', 4, 800.00, 550.00, 0, 15, 'pcs', TRUE, 1),
('Kickboard Foam', 'Swimming kickboard', '8801234570007', 4, 600.00, 400.00, 0, 20, 'pcs', TRUE, 1),
('Snorkel Training', 'Center mount swimming snorkel', '8801234570008', 4, 2500.00, 1800.00, 0, 10, 'pcs', TRUE, 1),
('Diving Mask Full Face', 'Anti-fog full face mask', '8801234570009', 4, 3500.00, 2500.00, 0, 8, 'pcs', TRUE, 1),
('Snorkeling Set', 'Mask, snorkel, fins combo', '8801234570010', 4, 5500.00, 4000.00, 0, 6, 'set', TRUE, 1),
('Water Polo Ball', 'Official size water polo ball', '8801234570011', 4, 2500.00, 1800.00, 0, 6, 'pcs', TRUE, 1),
('Swim Bag Waterproof', 'Mesh swim equipment bag', '8801234570012', 4, 1200.00, 850.00, 0, 15, 'pcs', TRUE, 1),
('Ear Plugs Swimming', 'Moldable silicone ear plugs', '8801234570013', 4, 300.00, 200.00, 0, 30, 'pair', TRUE, 1),
('Nose Clip Swimming', 'Adjustable nose clip', '8801234570014', 4, 200.00, 130.00, 0, 30, 'pcs', TRUE, 1),
('Swim Parka Jacket', 'Waterproof changing robe', '8801234570015', 4, 4500.00, 3200.00, 0, 8, 'pcs', TRUE, 1),
('Tennis Racket Junior', 'Kids tennis racket 23 inch', '8801234570016', 2, 3500.00, 2500.00, 0, 8, 'pcs', TRUE, 1),
('Badminton Set Complete', 'Rackets, net, shuttles combo', '8801234570017', 2, 4500.00, 3200.00, 0, 6, 'set', TRUE, 1),
('Table Tennis Table', 'Foldable tournament table', '8801234570018', 2, 45000.00, 32000.00, 0, 1, 'pcs', TRUE, 1),
('Squash Racket Beginner', 'Entry level squash racket', '8801234570019', 2, 3500.00, 2500.00, 0, 8, 'pcs', TRUE, 1),
('Badminton String BG65', 'Yonex string, 10m coil', '8801234570020', 2, 800.00, 550.00, 0, 15, 'coil', TRUE, 1),
('Sports Water Bottle 1L', 'BPA free squeeze bottle', '8801234570021', 7, 400.00, 280.00, 0, 40, 'pcs', TRUE, 1),
('Gym Towel Microfiber', 'Quick dry sports towel', '8801234570022', 7, 600.00, 400.00, 0, 30, 'pcs', TRUE, 1),
('Sports Bag Large', 'Duffel bag with shoe compartment', '8801234570023', 7, 2500.00, 1800.00, 0, 15, 'pcs', TRUE, 1),
('Backpack Sports', 'Multi-pocket sports backpack', '8801234570024', 7, 3500.00, 2500.00, 0, 10, 'pcs', TRUE, 1),
('Knee Support Brace', 'Compression knee support', '8801234570025', 7, 800.00, 550.00, 0, 20, 'pcs', TRUE, 1),
('Ankle Support Brace', 'Adjustable ankle brace', '8801234570026', 7, 600.00, 400.00, 0, 20, 'pcs', TRUE, 1),
('Elbow Support Brace', 'Tennis elbow support', '8801234570027', 7, 600.00, 400.00, 0, 20, 'pcs', TRUE, 1),
('Wrist Support Brace', 'Compression wrist wrap', '8801234570028', 7, 500.00, 350.00, 0, 25, 'pcs', TRUE, 1),
('Sports Tape Athletic', 'Kinesiology tape roll', '8801234570029', 7, 400.00, 280.00, 0, 30, 'roll', TRUE, 1),
('First Aid Kit Sports', 'Complete sports first aid kit', '8801234570030', 7, 2500.00, 1800.00, 0, 10, 'set', TRUE, 1);

-- =====================================================
-- CUSTOMERS (50 customers)
-- =====================================================
INSERT INTO customers (name, mobile, email, address, is_active, created_by) VALUES
('Aung Kyaw Moe', '09123456789', 'aungkyaw@email.com', 'Yangon, Myanmar', TRUE, 1),
('Thin Thin Aye', '09234567890', 'thinthin@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Zaw Win Htut', '09345678901', 'zawwin@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('Su Su Khaing', '09456789012', 'susukhaing@email.com', 'Bago, Myanmar', TRUE, 1),
('Ko Ko Lwin', '09567890123', 'kokolwin@email.com', 'Yangon, Myanmar', TRUE, 1),
('Nay Chi Win', '09678901234', 'naychiwin@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Min Min Oo', '09789012345', 'minminoo@email.com', 'Yangon, Myanmar', TRUE, 1),
('Aye Aye Mar', '09890123456', 'ayeayemar@email.com', 'Yangon, Myanmar', TRUE, 1),
('Kyaw Kyaw Htun', '09901234567', 'kyawkyaw@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('May Thazin Oo', '09123456788', 'maythazin@email.com', 'Yangon, Myanmar', TRUE, 1),
('Htet Htet Aung', '09234567891', 'htethtet@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Phone Myat Kyaw', '09345678902', 'phonemyat@email.com', 'Yangon, Myanmar', TRUE, 1),
('Yadanar Win', '09456789013', 'yadanarwin@email.com', 'Bago, Myanmar', TRUE, 1),
('Sithu Aung', '09567890124', 'sithuaung@email.com', 'Yangon, Myanmar', TRUE, 1),
('Ei Thandar Phyo', '09678901235', 'eithandar@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Soe Moe Kyaw', '09789012346', 'soemoe@email.com', 'Yangon, Myanmar', TRUE, 1),
('Khin Sabai Oo', '09890123457', 'khinsabai@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('Aung Aung Oo', '09901234568', 'aungaung@email.com', 'Yangon, Myanmar', TRUE, 1),
('Mya Mya Thet', '09123456787', 'myamya@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Win Win Maw', '09234567892', 'winwinmaw@email.com', 'Yangon, Myanmar', TRUE, 1),
('Kyaw Zin Latt', '09345678903', 'kyawzin@email.com', 'Yangon, Myanmar', TRUE, 1),
('Hnin Yu Wai', '09456789014', 'hninyuwai@email.com', 'Bago, Myanmar', TRUE, 1),
('Thet Paing Soe', '09567890125', 'thetpaing@email.com', 'Yangon, Myanmar', TRUE, 1),
('Nandar Hlaing', '09678901236', 'nandarhlaing@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Ye Min Oo', '09789012347', 'yeminoo@email.com', 'Yangon, Myanmar', TRUE, 1),
('Thida Aye', '09890123458', 'thidaaye@email.com', 'Yangon, Myanmar', TRUE, 1),
('Hein Htet Aung', '09901234569', 'heinhtet@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('Myat Noe Lwin', '09123456786', 'myatnoe@email.com', 'Yangon, Myanmar', TRUE, 1),
('Kaung Myat Min', '09234567893', 'kaungmyat@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Shwe Yi Oo', '09345678904', 'shweyioo@email.com', 'Yangon, Myanmar', TRUE, 1),
('Wai Yan Tun', '09456789015', 'waiyan@email.com', 'Bago, Myanmar', TRUE, 1),
('Pyae Phyo Aung', '09567890126', 'pyaephyo@email.com', 'Yangon, Myanmar', TRUE, 1),
('Khaing Zar Chi', '09678901237', 'khaingzar@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Lin Htet Aung', '09789012348', 'linhtet@email.com', 'Yangon, Myanmar', TRUE, 1),
('Aye Chan Moe', '09890123459', 'ayechan@email.com', 'Yangon, Myanmar', TRUE, 1),
('Zin Mar Oo', '09901234570', 'zinmaroo@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('Thiha Kyaw', '09123456785', 'thihakyaw@email.com', 'Yangon, Myanmar', TRUE, 1),
('Yoon Yoon Aye', '09234567894', 'yoonyoon@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Zaw Zaw Htun', '09345678905', 'zawzaw@email.com', 'Yangon, Myanmar', TRUE, 1),
('Khin Khin Htay', '09456789016', 'khinkhin@email.com', 'Bago, Myanmar', TRUE, 1),
('Myo Min Htun', '09567890127', 'myomin@email.com', 'Yangon, Myanmar', TRUE, 1),
('Nwe Ni Oo', '09678901238', 'nwenioo@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Kyaw Swar Oo', '09789012349', 'kyawswar@email.com', 'Yangon, Myanmar', TRUE, 1),
('Phyu Phyu Thin', '09890123460', 'phyuphyu@email.com', 'Yangon, Myanmar', TRUE, 1),
('Thu Ya Kyaw', '09901234571', 'thuyakyaw@email.com', 'Naypyidaw, Myanmar', TRUE, 1),
('Honey Nway Oo', '09123456784', 'honeynway@email.com', 'Yangon, Myanmar', TRUE, 1),
('Htet Myat Aung', '09234567895', 'htetmyat@email.com', 'Mandalay, Myanmar', TRUE, 1),
('Shwe Zin Thant', '09345678906', 'shwezin@email.com', 'Yangon, Myanmar', TRUE, 1),
('Wai Phyo Maung', '09456789017', 'waiphyo@email.com', 'Bago, Myanmar', TRUE, 1),
('Cherry Htet', '09567890128', 'cherryhtet@email.com', 'Yangon, Myanmar', TRUE, 1);

-- Note: GRNs, Invoices, and other transaction data will be added in a separate script
-- after products have stock through GRN process

-- Display summary
SELECT 'Database populated with sample data!' as Status;
