
INSERT INTO locations (name, type, lat, lng) VALUES
 ('Colombo','district',6.9271,79.8612),
 ('Jaffna','district',9.6615,80.0255),
 ('Kandy','district',7.2906,80.6337),
 ('Galle','district',6.0535,80.2210),
 ('Trincomalee','district',8.5874,81.2152);

INSERT INTO stores (name, vertical, location_id, address, phone, featured_image, rating) VALUES
 ('PizzaHub LK','food',1,'Colombo 03','011 234 5678','https://images.unsplash.com/photo-1601924582971-b0c5be3bb4a1?q=80&w=1000&auto=format&fit=crop',4.7),
 ('FreshMart','grocery',1,'Colombo 05','011 111 1111','https://images.unsplash.com/photo-1542831371-29b0f74f9713?q=80&w=1000&auto=format&fit=crop',4.6),
 ('TechZone','retail',1,'Colombo 04','011 222 2222','https://images.unsplash.com/photo-1518779578993-ec3579fee39f?q=80&w=1000&auto=format&fit=crop',4.5),
 ('SeaCatch','meat_fish',4,'Galle Fort','091 123 4567','https://images.unsplash.com/photo-1544025162-d76694265947?q=80&w=1000&auto=format&fit=crop',4.8),
 ('MedPlus','pharmacy',3,'Kandy City','081 987 6543','https://images.unsplash.com/photo-1582719478250-c89cae4dc85b?q=80&w=1000&auto=format&fit=crop',4.4),
 ('FixIt Services','maintenance',2,'Jaffna','021 555 1234','https://images.unsplash.com/photo-1503387762-592deb58ef4e?q=80&w=1000&auto=format&fit=crop',4.9);

INSERT INTO store_categories (store_id,name,slug) VALUES
 (1,'Classics','classics'),
 (1,'Premium','premium'),
 (2,'Fruits & Veg','fruits-veg'),
 (2,'Dairy','dairy'),
 (3,'Mobiles','mobiles'),
 (3,'Laptops','laptops'),
 (4,'Fish','fish'),
 (4,'Meat','meat');

INSERT INTO store_products (store_id,category_id,name,description,price,image,stock,sku) VALUES
 (1,1,'Margherita Pizza','Fresh basil, mozzarella, tomato',1800,'https://images.unsplash.com/photo-1548365328-8b88e3b0c76b?q=80&w=1000&auto=format&fit=crop',50,'PZ-001'),
 (1,2,'BBQ Chicken Pizza','Smoky BBQ with mozzarella',2400,'https://images.unsplash.com/photo-1542281286-9e0a16bb7366?q=80&w=1000&auto=format&fit=crop',40,'PZ-002'),
 (2,3,'Tomatoes (1kg)','Farm fresh',450,'https://images.unsplash.com/photo-1567306226416-28f0efdc88ce?q=80&w=1000&auto=format&fit=crop',100,'GR-001'),
 (2,4,'Fresh Milk (1L)','Daily delivery',380,'https://images.unsplash.com/photo-1582719478250-c89cae4dc85b?q=80&w=1000&auto=format&fit=crop',80,'GR-002'),
 (3,5,'Smartphone A1','64GB, 4G',59990,'https://images.unsplash.com/photo-1511707171634-5f897ff02aa9?q=80&w=1000&auto=format&fit=crop',20,'RT-001'),
 (3,6,'Laptop L5','i5, 8GB, 512GB',199990,'https://images.unsplash.com/photo-1517336714731-489689fd1ca8?q=80&w=1000&auto=format&fit=crop',10,'RT-002'),
 (4,7,'Yellowfin Tuna (1kg)','Fresh catch',2400,'https://images.unsplash.com/photo-1604908177070-0e3b716af8b7?q=80&w=1000&auto=format&fit=crop',30,'MF-001'),
 (4,8,'Chicken Breast (1kg)','Premium cut',1750,'https://images.unsplash.com/photo-1604908554007-29eaeae5f02d?q=80&w=1000&auto=format&fit=crop',30,'MF-002');

INSERT INTO pharmacy_items (name,brand,price,image,prescription_required,stock,description) VALUES
 ('Paracetamol 500mg','MediCeylon',120,'https://images.unsplash.com/photo-1582719478250-c89cae4dc85b?q=80&w=1000&auto=format&fit=crop',0,200,'Pain relief'),
 ('Vitamin C 1000mg','NutriPlus',850,'https://images.unsplash.com/photo-1580281657521-6c39e63a5c49?q=80&w=1000&auto=format&fit=crop',0,100,'Immunity support');

INSERT INTO maintenance_services (name,category,base_price,unit,description,image) VALUES
 ('Plumbing — Leak Repair','Plumbing',2500,'per visit','Fix common leaks and clogs','https://images.unsplash.com/photo-1503387762-592deb58ef4e?q=80&w=1000&auto=format&fit=crop'),
 ('Electrical — Socket Install','Electrical',3000,'per socket','Install/replace electrical sockets','https://images.unsplash.com/photo-1503387762-592deb58ef4e?q=80&w=1000&auto=format&fit=crop');
