-- Insert realistic customers with proper TIN numbers for POS system
-- This ensures the POS customer list shows realistic names with TIN numbers

INSERT INTO customers (customer_id, customer_type, name, email, phone_number, address, tin, risk_rating, compliance_status, balance, org_id, user_id, isDeleted, updatedAt)
VALUES
  (uuid_generate_v7(), 'Individual', 'Rajesh Sharma', 'rajesh.sharma@gmail.com', '+679-9876543', '15 Queens Road, Suva', '20240001234', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Priya Patel', 'priya.patel@yahoo.com', '+679-8765432', '32 Victoria Parade, Suva', '20240002345', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Business', 'Sunrise Trading Ltd', 'accounts@sunrisetrading.fj', '+679-3301234', '7 Cumming Street, Suva', '20240003456', 'Medium', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Maria Santos', 'maria.santos@email.com', '+679-7654321', '18 Ratu Sukuna Road, Nausori', '20240004567', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Business', 'Pacific Hardware Co', 'info@pacifichardware.fj', '+679-3305678', '45 Thomson Street, Suva', '20240005678', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'John Williams', 'john.williams@hotmail.com', '+679-9988776', '22 Amy Street, Lautoka', '20240006789', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Sita Devi', 'sita.devi@gmail.com', '+679-8877665', '8 Princes Road, Tamavua', '20240007890', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Business', 'Island Fresh Supermarket', 'manager@islandfresh.fj', '+679-3309876', '12 Naviti Street, Lami', '20240008901', 'Medium', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Vinod Kumar', 'vinod.kumar@outlook.com', '+679-8876655', '25 Rewa Street, Suva', '20240009012', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Asha Reddy', 'asha.reddy@yahoo.com', '+679-7765544', '14 Gordon Street, Suva', '20240010123', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Business', 'Suva Electronics Ltd', 'sales@suvaelectronics.fj', '+679-6654433', '88 Renwick Road, Suva', '20240011234', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now()),
  (uuid_generate_v7(), 'Individual', 'Mere Ratunabuabua', 'mere.ratu@gmail.com', '+679-5543322', '33 Flagstaff Road, Suva', '20240012345', 'Low', 'Compliant', 0.00, (SELECT org_id FROM orgs LIMIT 1), NULL, FALSE, now())
ON CONFLICT DO NOTHING;

-- Add comment for reference
COMMENT ON TABLE customers IS 'Customers table includes realistic Fijian customers with proper TIN numbers for POS system';