-- Project
INSERT INTO mod_maintenance_projects (name, customer_id, status, created_by, created_at, updated_at)
VALUES ('Test Maintenance Project - بيانات تجريبية', 1, 'in_progress', 1, NOW(), NOW());

-- Project Location (linked to project 1)
INSERT INTO mod_maintenance_project_locations (maintenance_project_id, name, code, type, city, is_main, status, created_at, updated_at)
VALUES (1, 'الموقع الرئيسي', 'LOC-001', 'building', 'الرياض', 1, 'active', NOW(), NOW());

-- Assets (customer_id=1 from sales_clients, location_id=1)
INSERT INTO mod_maintenance_assets (asset_number, customer_id, name, asset_type, brand, model, serial_number, status, created_at, updated_at)
VALUES 
('AST-001', 1, 'مكيف صالون رئيسي', 'air_conditioner', 'Samsung', 'AC-2000', 'SN001', 'active', NOW(), NOW()),
('AST-002', 1, 'مكيف غرفة الاجتماعات', 'air_conditioner', 'LG', 'AC-1500', 'SN002', 'active', NOW(), NOW()),
('AST-003', 1, 'مولد كهربائي', 'generator', 'Caterpillar', 'GEN-500', 'SN003', 'active', NOW(), NOW());

SELECT 'Projects:' as info, COUNT(*) as cnt FROM mod_maintenance_projects;
SELECT 'Locations:' as info, COUNT(*) as cnt FROM mod_maintenance_project_locations;
SELECT 'Assets:' as info, COUNT(*) as cnt FROM mod_maintenance_assets;
