-- PakTournaments / PakSports seed data
-- Import AFTER the schema file, into the same empty database.
SET NAMES utf8mb4;
SET time_zone = '+00:00';

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('0001_01_01_000000_create_users_table', 1),
('0001_01_01_000001_create_cache_table', 1),
('0001_01_01_000002_create_jobs_table', 1),
('2026_08_16_124551_create_personal_access_tokens_table', 1),
('2026_08_16_180000_add_role_phone_and_status_to_users_table', 1),
('2026_08_16_180001_create_provinces_table', 1),
('2026_08_16_180002_create_cities_table', 1),
('2026_08_16_180003_create_broadcaster_profiles_table', 1),
('2026_08_16_180004_create_player_profiles_table', 1),
('2026_08_16_180005_create_wallets_table', 1),
('2026_08_16_180006_create_credit_transactions_table', 1),
('2026_08_16_180007_create_credit_requests_table', 1),
('2026_08_16_180008_create_tournaments_table', 1),
('2026_08_16_180009_create_tournament_images_table', 1),
('2026_08_16_180010_create_home_sliders_table', 1),
('2026_08_16_180011_create_advertisements_table', 1),
('2026_08_16_180012_create_settings_table', 1),
('2026_08_16_180013_create_notifications_table', 1),
('2026_08_16_180014_create_device_tokens_table', 1),
('2026_08_16_190000_make_users_email_nullable', 1),
('2026_08_16_200000_add_package_and_jazzcash_number_to_credit_requests', 1),
('2026_08_16_210000_seed_settings_catalog', 1),
('2026_08_16_220000_add_performance_indexes', 1),
('2026_08_22_010000_allow_same_phone_for_player_and_broadcaster', 1);

INSERT INTO `settings` (`key`, `value`, `type`, `created_at`, `updated_at`) VALUES
('credit_price_pkr', '100', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('credit_packages', '[{"credits":1,"price_pkr":100},{"credits":5,"price_pkr":500,"badge":"Popular"},{"credits":20,"price_pkr":1800,"badge":"Best Value"}]', 'json', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('app_name', 'PakTournaments', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('support_email', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('support_phone', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('support_whatsapp', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('facebook_page_url', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('jazzcash_account_title', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('jazzcash_account_number', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('payment_instructions', 'Send the selected package amount via JazzCash, then submit your transaction ID and screenshot in the app.', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('maintenance_mode', '0', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('registration_enabled', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('tournament_posting_enabled', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('show_tournaments_tab', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('show_events_tab', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('show_offers_in_header', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('home_live_poster_count', '4', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('home_upcoming_poster_count', '4', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('home_event_poster_count', '4', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('notify_admins_on_new_tournament', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('notify_admins_on_credit_request', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('metal_price_enabled', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('metal_price_url', 'https://api.metalpriceapi.com/v1/latest', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('metal_feed_access', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('metal_price_base', 'PKR', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('metal_price_interval_minutes', '30', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_countdown_minutes', '35', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('pathoor_difference_per_tola', '5500', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_local_notice_enabled', '1', 'boolean', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_local_notice_min', '500', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_local_notice_max', '1000', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_local_notice_text', 'Local market rates may vary by approximately Rs 500–1,000 per tola due to local market and shipping costs.', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('min_app_version', '', 'string', '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
('gold_page_brand_category_id', '0', 'integer', '2026-11-19 04:55:47', '2026-11-19 04:55:47');

INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Punjab', 'punjab', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (2, 'Sindh', 'sindh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (3, 'Khyber Pakhtunkhwa', 'khyber-pakhtunkhwa', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (4, 'Balochistan', 'balochistan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (5, 'Islamabad Capital Territory', 'islamabad-capital-territory', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (6, 'Gilgit-Baltistan', 'gilgit-baltistan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
INSERT INTO `provinces` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES (7, 'Azad Jammu and Kashmir', 'azad-jammu-and-kashmir', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');

INSERT INTO `cities` (`province_id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Ahmadpur East', 'ahmadpur-east', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Ali Pur', 'ali-pur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Arifwala', 'arifwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Attock', 'attock', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Bahawalnagar', 'bahawalnagar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Bahawalpur', 'bahawalpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Bhakkar', 'bhakkar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Bhalwal', 'bhalwal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Burewala', 'burewala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Chakwal', 'chakwal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Chichawatni', 'chichawatni', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Chiniot', 'chiniot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Chishtian', 'chishtian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Choa Saidan Shah', 'choa-saidan-shah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Chunian', 'chunian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Daska', 'daska', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Dera Ghazi Khan', 'dera-ghazi-khan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Dijkot', 'dijkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Dina', 'dina', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Dipalpur', 'dipalpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Dunya Pur', 'dunya-pur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Faisalabad', 'faisalabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Farooqabad', 'farooqabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Fateh Jang', 'fateh-jang', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Ferozewala', 'ferozewala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Fort Abbas', 'fort-abbas', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Ghakhar Mandi', 'ghakhar-mandi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Gojra', 'gojra', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Gujar Khan', 'gujar-khan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Gujranwala', 'gujranwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Gujrat', 'gujrat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Hafizabad', 'hafizabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Haroonabad', 'haroonabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Hasilpur', 'hasilpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Hassan Abdal', 'hassan-abdal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Haveli Lakha', 'haveli-lakha', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Isa Khel', 'isa-khel', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jahanian', 'jahanian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jalalpur Jattan', 'jalalpur-jattan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jalalpur Pirwala', 'jalalpur-pirwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jampur', 'jampur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jaranwala', 'jaranwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jauharabad', 'jauharabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jhang', 'jhang', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Jhelum', 'jhelum', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kabirwala', 'kabirwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kahror Pacca', 'kahror-pacca', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kahuta', 'kahuta', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kallar Kahar', 'kallar-kahar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kallar Syedan', 'kallar-syedan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kamalia', 'kamalia', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kamoke', 'kamoke', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Karor Lal Esan', 'karor-lal-esan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kasur', 'kasur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Khairpur Tamewali', 'khairpur-tamewali', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Khanewal', 'khanewal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Khanpur', 'khanpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kharian', 'kharian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Khushab', 'khushab', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kot Addu', 'kot-addu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kot Momin', 'kot-momin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Kot Radha Kishan', 'kot-radha-kishan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Lahore', 'lahore', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Lalamusa', 'lalamusa', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Layyah', 'layyah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Liaquatpur', 'liaquatpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Lodhran', 'lodhran', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Mailsi', 'mailsi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Malakwal', 'malakwal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Mandi Bahauddin', 'mandi-bahauddin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Mian Channu', 'mian-channu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Mianwali', 'mianwali', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Minchinabad', 'minchinabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Multan', 'multan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Muridke', 'muridke', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Murree', 'murree', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Mustafabad', 'mustafabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Muzaffargarh', 'muzaffargarh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Nankana Sahib', 'nankana-sahib', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Narowal', 'narowal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Noorpur Thal', 'noorpur-thal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Nowshera Virkan', 'nowshera-virkan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Okara', 'okara', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pakpattan', 'pakpattan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pasrur', 'pasrur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pattoki', 'pattoki', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Phalia', 'phalia', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pindi Bhattian', 'pindi-bhattian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pindi Gheb', 'pindi-gheb', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Pir Mahal', 'pir-mahal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Qila Didar Singh', 'qila-didar-singh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Quaidabad', 'quaidabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Rahim Yar Khan', 'rahim-yar-khan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Rajanpur', 'rajanpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Rawalpindi', 'rawalpindi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Renala Khurd', 'renala-khurd', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sadiqabad', 'sadiqabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Safdarabad', 'safdarabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sahiwal', 'sahiwal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sambrial', 'sambrial', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Samundri', 'samundri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sarai Alamgir', 'sarai-alamgir', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sargodha', 'sargodha', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Shakargarh', 'shakargarh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sheikhupura', 'sheikhupura', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Shorkot', 'shorkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sialkot', 'sialkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Sillanwali', 'sillanwali', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Talagang', 'talagang', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Tandlianwala', 'tandlianwala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Taunsa', 'taunsa', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Taxila', 'taxila', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Toba Tek Singh', 'toba-tek-singh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Vehari', 'vehari', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Wah Cantonment', 'wah-cantonment', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Wazirabad', 'wazirabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Yazman', 'yazman', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(1, 'Zafarwal', 'zafarwal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Badin', 'badin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Bhiria', 'bhiria', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Dadu', 'dadu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Daharki', 'daharki', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Digri', 'digri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Gambat', 'gambat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Gharo', 'gharo', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Ghotki', 'ghotki', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Hala', 'hala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Hyderabad', 'hyderabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Islamkot', 'islamkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Jacobabad', 'jacobabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Jamshoro', 'jamshoro', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Kandhkot', 'kandhkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Karachi', 'karachi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Kashmore', 'kashmore', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Khairpur', 'khairpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Khipro', 'khipro', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Kotri', 'kotri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Kunri', 'kunri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Larkana', 'larkana', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Matiari', 'matiari', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Matli', 'matli', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Mehrabpur', 'mehrabpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Mirpur Khas', 'mirpur-khas', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Mithi', 'mithi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Moro', 'moro', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Naushahro Feroze', 'naushahro-feroze', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Nawabshah', 'nawabshah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Pano Aqil', 'pano-aqil', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Qambar Shahdadkot', 'qambar-shahdadkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Ratodero', 'ratodero', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Rohri', 'rohri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Sakrand', 'sakrand', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Sanghar', 'sanghar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Sehwan', 'sehwan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Shahdadkot', 'shahdadkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Shahdadpur', 'shahdadpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Shaheed Benazirabad', 'shaheed-benazirabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Shikarpur', 'shikarpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Sujawal', 'sujawal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Sukkur', 'sukkur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Tando Adam', 'tando-adam', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Tando Allahyar', 'tando-allahyar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Tando Muhammad Khan', 'tando-muhammad-khan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Tharparkar', 'tharparkar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Thatta', 'thatta', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Thul', 'thul', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Ubauro', 'ubauro', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(2, 'Umerkot', 'umerkot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Abbottabad', 'abbottabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Alpuri', 'alpuri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Bajaur', 'bajaur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Bannu', 'bannu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Batkhela', 'batkhela', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Battagram', 'battagram', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Buner', 'buner', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Charsadda', 'charsadda', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Chitral', 'chitral', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Daggar', 'daggar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Dera Ismail Khan', 'dera-ismail-khan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Hangu', 'hangu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Haripur', 'haripur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Havelian', 'havelian', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Jehangira', 'jehangira', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Karak', 'karak', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Katlang', 'katlang', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Khar Bajaur', 'khar-bajaur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Khyber', 'khyber', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Kohat', 'kohat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Kohistan', 'kohistan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Kolai Palas', 'kolai-palas', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Kurram', 'kurram', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Lakki Marwat', 'lakki-marwat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Landi Kotal', 'landi-kotal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Lower Chitral', 'lower-chitral', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Lower Dir', 'lower-dir', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Lower Kohistan', 'lower-kohistan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Malakand', 'malakand', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Mansehra', 'mansehra', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Mardan', 'mardan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Mingora', 'mingora', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Miranshah', 'miranshah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Mohmand', 'mohmand', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'North Waziristan', 'north-waziristan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Nowshera', 'nowshera', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Orakzai', 'orakzai', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Parachinar', 'parachinar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Peshawar', 'peshawar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Shabqadar', 'shabqadar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Shangla', 'shangla', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'South Waziristan', 'south-waziristan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Swabi', 'swabi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Swat', 'swat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Takht Bhai', 'takht-bhai', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Tank', 'tank', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Timergara', 'timergara', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Topi', 'topi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Torghar', 'torghar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Upper Chitral', 'upper-chitral', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Upper Dir', 'upper-dir', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Upper Kohistan', 'upper-kohistan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(3, 'Wana', 'wana', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Awaran', 'awaran', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Barkhan', 'barkhan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Bela', 'bela', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Chagai', 'chagai', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Chaman', 'chaman', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Dalbandin', 'dalbandin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Dera Allah Yar', 'dera-allah-yar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Dera Bugti', 'dera-bugti', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Dera Murad Jamali', 'dera-murad-jamali', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Dhadar', 'dhadar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Duki', 'duki', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Gandawa', 'gandawa', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Gwadar', 'gwadar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Harnai', 'harnai', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Hub', 'hub', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Jafarabad', 'jafarabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Jhal Magsi', 'jhal-magsi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Kachhi', 'kachhi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Kalat', 'kalat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Kech', 'kech', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Kharan', 'kharan', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Khuzdar', 'khuzdar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Killa Abdullah', 'killa-abdullah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Killa Saifullah', 'killa-saifullah', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Kohlu', 'kohlu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Lasbela', 'lasbela', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Loralai', 'loralai', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Mastung', 'mastung', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Musakhel', 'musakhel', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Muslim Bagh', 'muslim-bagh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Nasirabad', 'nasirabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Nushki', 'nushki', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Ormara', 'ormara', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Panjgur', 'panjgur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Pasni', 'pasni', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Pishin', 'pishin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Quetta', 'quetta', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Sherani', 'sherani', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Sibi', 'sibi', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Sohbatpur', 'sohbatpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Sui', 'sui', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Surab', 'surab', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Turbat', 'turbat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Usta Muhammad', 'usta-muhammad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Uthal', 'uthal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Washuk', 'washuk', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Zhob', 'zhob', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(4, 'Ziarat', 'ziarat', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(5, 'Bhara Kahu', 'bhara-kahu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(5, 'Islamabad', 'islamabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(5, 'Tarnol', 'tarnol', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Aliabad', 'aliabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Astore', 'astore', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Chilas', 'chilas', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Danyor', 'danyor', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Darel', 'darel', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Gahkuch', 'gahkuch', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Ghanche', 'ghanche', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Ghizer', 'ghizer', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Gilgit', 'gilgit', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Gupis-Yasin', 'gupis-yasin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Hunza', 'hunza', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Karimabad', 'karimabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Khaplu', 'khaplu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Kharmang', 'kharmang', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Nagar', 'nagar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Roundu', 'roundu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Shigar', 'shigar', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Skardu', 'skardu', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(6, 'Tangir', 'tangir', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Athmuqam', 'athmuqam', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Bagh', 'bagh', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Bhimber', 'bhimber', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Dadyal', 'dadyal', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Forward Kahuta', 'forward-kahuta', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Hattian Bala', 'hattian-bala', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Haveli', 'haveli', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Kotli', 'kotli', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Mirpur', 'mirpur', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Muzaffarabad', 'muzaffarabad', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Neelum', 'neelum', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Pallandri', 'pallandri', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Poonch', 'poonch', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Rawalakot', 'rawalakot', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47'),
(7, 'Sudhanoti', 'sudhanoti', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');

INSERT INTO `users` (`name`, `email`, `phone`, `password`, `role`, `is_active`, `created_at`, `updated_at`) VALUES ('Admin', 'admin@paktournaments.test', '03000000000', '$2y$10$rTrNy345AM0e2Kq1eJ8CpOft4EWkgOqdC7OealFLJg.tukGz41blS', 'admin', 1, '2026-11-19 04:55:47', '2026-11-19 04:55:47');
