

CREATE TABLE IF NOT EXISTS `migrations` (`id` integer primary key AUTO_INCREMENT not NULL, `migration` varchar not NULL, `batch` integer not NULL);
INSERT INTO migrations VALUES(1,'0001_01_01_000000_create_users_table',1),
  (2,'0001_01_01_000001_create_cache_table',1),
  (3,'0001_01_01_000002_create_jobs_table',1),
  (4,'2026_08_05_000001_add_role_fields_to_users_table',1),
  (5,'2026_08_05_000002_create_service_categories_table',1),
  (6,'2026_08_05_000003_create_services_table',1),
  (7,'2026_08_05_000004_create_areas_table',1),
  (8,'2026_08_05_000005_create_partner_profiles_table',1),
  (9,'2026_08_05_000006_create_bookings_table',1),
  (10,'2026_08_05_000007_create_booking_photos_table',1),
  (11,'2026_08_05_000008_create_settings_table',1),
  (12,'2026_08_05_000009_convert_bookings_to_subscriptions',1),
  (13,'2026_08_06_000001_create_partner_leaves_and_attendances_table',2),
  (14,'2026_08_08_171222_update_subscription_visits_for_daily_attendance',3),
  (15,'2026_08_08_171653_add_visit_id_to_booking_photos',4),
  (16,'2026_08_09_101930_add_suspend_fields_to_partner_profiles',5),
  (17,'2026_08_09_102851_create_partner_team_members_table',6),
  (18,'2026_08_09_110000_add_team_member_role',7),
  (19,'2026_08_10_120000_add_commission_to_partner_profiles',8);
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (`email` varchar not NULL, `token` varchar not NULL, `created_at` datetime, primary key (`email`));
CREATE TABLE IF NOT EXISTS `sessions` (`id` varchar not NULL, `user_id` integer, `ip_address` varchar, `user_agent` text, `payload` text not NULL, `last_activity` integer not NULL, primary key (`id`));
INSERT INTO sessions VALUES('7dxBNHT6iCFLbVzuz8oiqAd3kELOXjmSeyTiRWHc',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.129.1 Chrome/148.0.7778.280 Electron/42.6.0 Safari/537.36','eyJfdG9rZW4iOiJWZDV2S1p5dXVXbUd1QXJWYmVHS05wSzJqaW1yTE14ZGpNdXNVZGxHIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwNzBcL3BhcnRuZXJcL3Zpc2l0XC82Iiwicm91dGUiOiJwYXJ0bmVyLnZpc2l0In0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786366451),
  ('8CZE883LRw3UucoeDG8jSmb7rVGQkss1JrhwTL5r',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiI1QTVlVGYxRTZ4bFBETUpXZTBKWlRCWTNVaDJBTDZ3YXdrQTBrRHBrIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1786366931),
  ('7Ddy8LMCmvf8NzED36rdj526BFUUa6vB48WzZuBK',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiIwUjR5TEp3SDBna09vZGJYZTNSbGhpZ1o2TTRtSjBON2lqeERUY1NxIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJ1cmwiOnsiaW50ZW5kZWQiOiJodHRwOlwvXC8xMjcuMC4wLjE6ODA3MFwvcGFydG5lclwvYm9va2luZ3MifSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifX0=',1786366932),
  ('c2pzbh1IGBmsDQhSVMHPbUws2syvyqvZHGQYUM1y',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJIYjJJTG43a2lUYVpuZURwV1I0S00xMzB3M0FJRWRCZ3pFamFjTFVGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==',1786367877),
  ('2eMWYZQLPxnn7M7gwhv9R9oU0b6F7DPf9HQTMBxx',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJWcVVsU0pISFJyY3VpVWtXQnNYeEhxZ0pCd1h6VnF5STRiU2VGV29aIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pbiIsInJvdXRlIjoiYWRtaW4uZGFzaGJvYXJkIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786367887),
  ('TN4NsAHQBOazIGgs9gCb3FZnCSftIFkMYT4UgDxv',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJWWVBzU3JwN1hFbklSMGwzSDZFVmNqSUJhSVlLakVQVUZzclhFU0RVIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786368498),
  ('MZeab1ypCsKpUmmHix0e3oi6OXOpRaNaOPY9OpaR',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJXcGg5QTdQQVhZZm5hSlVHbFNWbXJ2VFZ4cWJZY0xFdm50aVpVZVo2IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786368639);
INSERT INTO sessions VALUES('tK75ppJriT10gspqG4EHjHj69wFCCvFR87FUQMwf',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJubHJhNGJwUzY2d3YweEhDbXhUMXRubE1HQWFnbVYxYXFSSmVRdkkzIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC9lYXJuaW5ncyIsInJvdXRlIjoicGFydG5lci5lYXJuaW5ncyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786368665),
  ('huepDaDtFOUQJ1HnQWDuUW1gv3g5OAhk1jCEA4ml',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJrR0JudWpzak5oWUJkTlYyTTNYVHVVUm1oeWs5T1RLdDdnOFBaZFduIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC9lYXJuaW5ncyIsInJvdXRlIjoicGFydG5lci5lYXJuaW5ncyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786368903),
  ('dcby3DQNFwyuA9aoevBhGudAIYJS5BEBQypFvVqY',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJ6T0tuMVpvWDl2YmxhWVR5c1VYaU96WXhzb3VYZVBiVzM1NGlYSXJBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC9ib29raW5nc1wvQkZLLUxIUUJHNiIsInJvdXRlIjoicGFydG5lci5ib29raW5nLnNob3cifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6M30=',1786368919),
  ('kzCzxrV1FjcPF45eeFFAQi0FN5y0kYtqlk9Ll0g3',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJyWlRPbU90azIwUENkaEVlbnBJWkJJVmd5bGZHZTBkdXFDaUN6UmFBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC92aXNpdFwvNiIsInJvdXRlIjoicGFydG5lci52aXNpdCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786368956),
  ('ZjTPSk6QGkKch6EZSCOz28ZlGwznDbYsByP9ubaW',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJOVllwSllpTHJHYmFxaVYzQ0lLS2JRM3BWQ0Rsdlp5Q3VRZjIwWFR3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvcGFydG5lcnMiLCJyb3V0ZSI6ImFkbWluLnBhcnRuZXJzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786368967),
  ('VYvCJJimQSoiw4SNxn3k2IPR5yscWx222lkmerGF',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJrZmtPTmc1bFJsdUw5QURWbjF0OUtrTDRqdk5qN3QxRTkxbzd6dnBjIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvcGFydG5lcnNcLzNcL2VkaXQiLCJyb3V0ZSI6ImFkbWluLnBhcnRuZXJzLmVkaXQifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MX0=',1786368980),
  ('VugomWsgvmobi4c6NmwxkfdqgUtp7yMcAZQFI1ay',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJwTmpKVGlIV2lCZjdYNGp0SHE3NzlRTkxxcFBOVWVhRjdod3kwd3NBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786368989);
INSERT INTO sessions VALUES('czGuOkIqUBoYgmpi0FLjZG3q3PINeOxIob5NLokO',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJsR3pLRXZjTzhlb2FTZW1xSVNEbE55Sm5RaEFqSE5VZDFMelJraE8zIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786369006),
  ('dhjr4QyC0SBcKypSYKRxjtVFYKx46rNZd5vNSI6e',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiIybzV0TDhnSUR6YklYeGhRaGFxNExPbXlCUDNqM1VrT2VuTXphdkpBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvcGFydG5lcnNcLzNcL2VkaXQiLCJyb3V0ZSI6ImFkbWluLnBhcnRuZXJzLmVkaXQifSwiX2ZsYXNoIjp7Im9sZCI6WyJzdWNjZXNzIl0sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwic3VjY2VzcyI6IlBhcnRuZXIgdXBkYXRlZC4ifQ==',1786369024),
  ('dlg0nVIiM8XNNL6VWkTz9d6nPJzPXGpqMwsg28GV',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJTTENDUnZHaUdXVmN4TmdtQW5NTG5vYzVjOGxXb3FyMjFCenRJdFY5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC9lYXJuaW5ncyIsInJvdXRlIjoicGFydG5lci5lYXJuaW5ncyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786369033),
  ('ntQbf9yNidIVVW9hwkraH0fJMm8uyrhePzwRqN9B',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJwYWt1WGI5bnNKZ3M0ZVBUVjBENFZDTnk1RmpCUnQ0Z2JyUmxvM29WIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC92aXNpdFwvNiIsInJvdXRlIjoicGFydG5lci52aXNpdCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjozfQ==',1786369043),
  ('gi2C3dYQfLWaojBUOZxjD7Vf0ONuaiIII2wSwP1q',3,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiI2UnRTY3VhTzFwd2Q0NWhwdGczMDV0T3hUZlU0SGRRZW5jNkxtcldWIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9wYXJ0bmVyXC9ib29raW5nc1wvQkZLLUxIUUJHNiIsInJvdXRlIjoicGFydG5lci5ib29raW5nLnNob3cifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6M30=',1786369051),
  ('LJwYNZ9EMte3Vzn01flk4pXeIJAT3vKB9qvw3nyD',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJMTDR1TWF0ZktqYVBKRHB4bE9pelNFUXlUa3RTVjB5OHVBbHJSMURJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvcGFydG5lcnNcLzMiLCJyb3V0ZSI6ImFkbWluLnBhcnRuZXJzLnNob3cifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MX0=',1786369059),
  ('6qYlmNTI7kDFXifx8wVoFPKeIBo8CsYo7mcMNSkY',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJjYW1ucmp3MnIzbW15a1pwajlyd3JLbDlQRkFiOWRqb2xZQ1RHZ2c4IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786369444);
INSERT INTO sessions VALUES('CLQVqb9xoDIhyF53vutyqnWolBevVVc5PtzQfEUJ',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJnUTlTZmY3U0RwSGROekx1QktZWG9BZFMzWVpUSkZ2Rk5OMlNiazNDIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786369456),
  ('PU5bb8JD5BsTV4aJthCxDwmY6OXnztgIwbB7bDeu',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiIycm0wN0h6Y1hvdGZEN3FreGlSYXpUNW53Z3V5SWNteWIxTzNJYURXIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786369477),
  ('IqdRnz2uG0BLl8l1lQlFOMcV0O4Won2B5jNIdFjO',1,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiI2a0FkQ2ViQW56amZDcTU5elhaZW9Zb01lR0QxeUREeTdoeUpsR1FWIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwXC9hZG1pblwvc2V0dGluZ3MiLCJyb3V0ZSI6ImFkbWluLnNldHRpbmdzIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9',1786369488),
  ('4FQuyH6OELJoGfi9H1QBLdmC116oXkoGw6BRJ7AA',3,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.129.1 Chrome/148.0.7778.280 Electron/42.6.0 Safari/537.36','eyJfdG9rZW4iOiIzRnp4UlBqU3Rpc2JIb3hQSzYzRnNDbDJ3eFZPT2RaQkdFR3F5WkhWIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwNzAiLCJyb3V0ZSI6ImhvbWUifSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjN9',1786371244),
  ('Z1HGAkEe8FSWOOugctok3EXwv8AIjQgDrUlI5Zu3',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJhNExaa2JkcDExVDl1a0pxU3ltOHB6NFlEMU95WjM5QmRlSzJqS0xMIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1786375751),
  ('a2vAMIww8434bOlISojy1nQb9PR7mxm6bcTkv5Jq',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJHa2RuUFhGWU9FME1MOU9XSzE0ZWxvQVBvMlJPb2FvdW5YUHJMMzh1IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1786375757),
  ('tpWQOR0AgWfbZq0uGRCVAm6zuKLo1gnUtvjf6Jic',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.20348.558','eyJfdG9rZW4iOiJmZkxucHFqTjdYVnJtNWVqVUx4WlNSeHBaSFV5VTNKMWsyVmp1bTFWIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1786375764),
  ('UR6G8l9wViCqv8IYcRnZz77nmUQgAxcQMabwliDt',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.129.1 Chrome/148.0.7778.280 Electron/42.6.0 Safari/537.36','eyJfdG9rZW4iOiJveGRYUTRQUUhUWnA4OTFrU0Q1aVUxVlNqUk1GWEZ5M0V4RVhQRHJiIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDcwIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=',1786382503);
CREATE TABLE IF NOT EXISTS `cache` (`key` varchar not NULL, `value` text not NULL, `expiration` integer not NULL, primary key (`key`));
CREATE TABLE IF NOT EXISTS `cache_locks` (`key` varchar not NULL, `owner` varchar not NULL, `expiration` integer not NULL, primary key (`key`));
CREATE TABLE IF NOT EXISTS `jobs` (`id` integer primary key AUTO_INCREMENT not NULL, `queue` varchar not NULL, `payload` text not NULL, `attempts` integer not NULL, `reserved_at` integer, `available_at` integer not NULL, `created_at` integer not NULL);
CREATE TABLE IF NOT EXISTS `job_batches` (`id` varchar not NULL, `name` varchar not NULL, `total_jobs` integer not NULL, `pending_jobs` integer not NULL, `failed_jobs` integer not NULL, `failed_job_ids` text not NULL, `options` text, `cancelled_at` integer, `created_at` integer not NULL, `finished_at` integer, primary key (`id`));
CREATE TABLE IF NOT EXISTS `failed_jobs` (`id` integer primary key AUTO_INCREMENT not NULL, `uuid` varchar not NULL, `connection` varchar not NULL, `queue` varchar not NULL, `payload` text not NULL, `exception` text not NULL, `failed_at` datetime not NULL default CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS `service_categories` (`id` integer primary key AUTO_INCREMENT not NULL, `name` varchar not NULL, `slug` varchar not NULL, `icon` varchar, `image` varchar, `description` text, `is_active` tinyint(1) not NULL default '1', `sort_order` integer not NULL default '0', `created_at` datetime, `updated_at` datetime);
INSERT INTO service_categories VALUES(1,'Car Wash','car-care','🚗','storage/categories/car-care.jpg',NULL,1,1,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (2,'Property Care','property-care','🏠','storage/categories/property-care.jpg',NULL,1,2,'2026-08-05 16:28:05','2026-08-05 17:53:20');
CREATE TABLE IF NOT EXISTS `services` (`id` integer primary key AUTO_INCREMENT not NULL, `category_id` integer, `name` varchar not NULL, `slug` varchar not NULL, `tagline` varchar, `description` text, `image` varchar, `icon` varchar, `price_paise` integer not NULL default '0', `original_price_paise` integer, `duration_minutes` integer not NULL default '60', `is_featured` tinyint(1) not NULL default '0', `is_active` tinyint(1) not NULL default '1', `sort_order` integer not NULL default '0', `whats_included` text, `faqs` text, `created_at` datetime, `updated_at` datetime, foreign key(`category_id`) references `service_categories`(`id`) on delete set NULL);
INSERT INTO services VALUES(1,1,'Car Wash (Sedan)','car-wash-sedan','Sedan · monthly doorstep car wash','Premium doorstep car wash monthly for sedan cars.','storage/services/car-wash-sedan.jpg',NULL,150000,200000,60,1,1,1,'[`Exterior foam wash`,`Tyre dressing`,`Interior vacuum`,`Dashboard polish`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (2,1,'Car Wash (Hatchback)','car-wash-hatchback','Hatchback · monthly doorstep car wash','Premium doorstep car wash monthly for hatchback cars.','storage/services/car-wash-hatchback.jpg',NULL,100000,150000,45,0,1,2,'[`Exterior foam wash`,`Tyre dressing`,`Interior vacuum`,`Dashboard polish`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (3,1,'Car Wash (SUV)','car-wash-suv','SUV · most popular monthly doorstep wash','Car wash monthly for SUV — our most popular service.','storage/services/car-wash-suv.jpg',NULL,200000,250000,60,1,1,3,'[`Exterior foam wash`,`Tyre dressing`,`Interior vacuum`,`Dashboard polish`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (4,1,'Premium Car Wash (Luxury)','premium-car-wash-luxury','Luxury · premium hand-wash + wax','Premium car wash for luxury vehicles — hand-wash, wax and detailing.','storage/services/premium-car-wash-luxury.jpg',NULL,300000,400000,90,1,1,4,'[`pH neutral shampoo`,`Hand wax protection`,`Premium interior detailing`,`Tyre & chrome shine`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (5,2,'Property Care (1 BHK)','property-care-1bhk','1 BHK · monthly property care','Professional property maintenance and caretaker service for 1 BHK vacant and tenanted flats.','storage/services/property-care-1bhk.jpg',NULL,150000,200000,60,0,1,1,'[`Monthly visit`,`Photo report`,`WhatsApp update`,`Maintenance flags`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (6,2,'Property Care (2 BHK)','property-care-2bhk','2 BHK · most popular monthly property care','Property maintenance and caretaker service for 2 BHK flats.','storage/services/property-care-2bhk.jpg',NULL,200000,250000,60,1,1,2,'[`Monthly visit`,`Photo report`,`WhatsApp update`,`Maintenance flags`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (7,2,'Property Care (3 BHK)','property-care-3bhk','3 BHK · monthly property care','Property maintenance and caretaker service for 3 BHK flats.','storage/services/property-care-3bhk.jpg',NULL,250000,300000,75,0,1,3,'[`Monthly visit`,`Photo report`,`WhatsApp update`,`Maintenance flags`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (8,2,'Property Care (4 BHK)','property-care-4bhk','4 BHK · monthly property care','Property maintenance and caretaker service for 4 BHK flats.','storage/services/property-care-4bhk.jpg',NULL,300000,350000,90,0,1,4,'[`Monthly visit`,`Photo report`,`WhatsApp update`,`Maintenance flags`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20'),
  (9,2,'Property Care (5 BHK)','property-care-5bhk','5 BHK · monthly property care','Property maintenance and caretaker service for 5 BHK flats.','storage/services/property-care-5bhk.jpg',NULL,350000,400000,120,0,1,5,'[`Monthly visit`,`Photo report`,`WhatsApp update`,`Maintenance flags`]',NULL,'2026-08-05 16:28:05','2026-08-05 17:53:20');
CREATE TABLE IF NOT EXISTS `areas` (`id` integer primary key AUTO_INCREMENT not NULL, `name` varchar not NULL, `slug` varchar not NULL, `city` varchar not NULL default 'Noida', `pincode` varchar, `lat` numeric, `lng` numeric, `is_active` tinyint(1) not NULL default '1', `created_at` datetime, `updated_at` datetime);
INSERT INTO areas VALUES(1,'Sector 137, Noida','sector-137','Noida','201305',28.5018,77.4055,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (2,'Sector 135, Noida','sector-135','Noida','201301',28.497,77.3995,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (3,'Sector 142, Noida','sector-142','Noida','201306',28.496,77.412,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (4,'Sector 144, Noida','sector-144','Noida','201306',28.485,77.415,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (5,'Sector 168, Noida','sector-168','Noida','201306',28.467,77.438,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (6,'Sector 50, Noida','sector-50','Noida','201301',28.572,77.369,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (7,'Sector 62, Noida','sector-62','Noida','201301',28.62,77.364,1,'2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (8,'Sector 18, Noida','sector-18','Noida','201301',28.57,77.326,1,'2026-08-05 16:28:05','2026-08-05 16:28:05'),
  (9,'Greater Noida West','greater-noida-west','Noida','201306',28.48,77.43,1,'2026-08-05 16:28:05','2026-08-05 16:28:05'),
  (10,'Indirapuram, Ghaziabad','indirapuram','Ghaziabad','201014',28.641,77.37,1,'2026-08-05 16:28:05','2026-08-05 16:28:05');
CREATE TABLE IF NOT EXISTS `partner_profiles` (`id` integer primary key AUTO_INCREMENT not NULL, `user_id` integer not NULL, `display_name` varchar not NULL, `photo` varchar, `bio` text, `experience_years` integer not NULL default '0', `aadhaar_verified` tinyint(1) not NULL default '0', `police_verified` tinyint(1) not NULL default '0', `is_online` tinyint(1) not NULL default '0', `is_available` tinyint(1) not NULL default '1', `rating_avg` numeric not NULL default '0', `rating_count` integer not NULL default '0', `jobs_done` integer not NULL default '0', `working_hours` text, `lat` numeric, `lng` numeric, `created_at` datetime, `updated_at` datetime, `suspend_new_bookings` tinyint(1) not NULL default '0', `suspend_reason` varchar, `aadhaar_number` varchar, `aadhaar_doc_path` varchar, `police_doc_path` varchar, `aadhaar_verified_at` datetime, `police_verified_at` datetime, `admin_notes` text, `commission_percent` numeric, `commission_notes` text, `wallet_balance_paise` integer not NULL default '0', `pending_balance_paise` integer not NULL default '0', foreign key(`user_id`) references `users`(`id`) on delete cascade);
INSERT INTO partner_profiles VALUES(1,3,'Rajesh Kumar',NULL,NULL,0,0,0,1,1,4.8,142,142,NULL,NULL,NULL,'2026-08-05 16:28:05','2026-08-10 13:37:04',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,'Top-rated partner, gets premium 12% rate',0,0),
  (2,4,'Suresh Yadav',NULL,'Specialist in AC & appliance repair',6,1,1,1,1,4.7,98,98,NULL,NULL,NULL,'2026-08-05 16:28:05','2026-08-05 16:28:05',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),
  (3,5,'Amit Sharma',NULL,'Plumbing & electrical expert',5,1,1,1,1,4.9,76,76,NULL,NULL,NULL,'2026-08-05 16:28:06','2026-08-05 16:28:06',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),
  (4,6,'Manoj Singh',NULL,'Painter & home renovator',7,1,1,1,1,4.6,64,64,NULL,NULL,NULL,'2026-08-05 16:28:06','2026-08-05 16:28:06',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),
  (5,7,'Vijay Verma',NULL,'Pest control & sanitisation',4,1,1,1,1,4.5,52,52,NULL,NULL,NULL,'2026-08-05 16:28:07','2026-08-09 10:24:06',1,'Customer complaint — investigating',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),
  (7,1,'Befikreyy Admin',NULL,NULL,0,0,0,0,1,0,0,0,NULL,NULL,NULL,'2026-08-05 17:11:27','2026-08-05 17:11:27',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),
  (8,2,'Demo Customer',NULL,NULL,0,0,0,0,1,0,0,0,NULL,NULL,NULL,'2026-08-06 14:57:21','2026-08-06 14:57:21',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0);
CREATE TABLE IF NOT EXISTS `partner_service` (`id` integer primary key AUTO_INCREMENT not NULL, `partner_id` integer not NULL, `service_id` integer not NULL, `custom_price_paise` integer, `is_active` tinyint(1) not NULL default '1', foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade, foreign key(`service_id`) references `services`(`id`) on delete cascade);
INSERT INTO partner_service VALUES(1,1,1,NULL,1),
  (2,1,3,NULL,1),
  (3,1,8,NULL,1),
  (4,1,9,NULL,1),
  (5,2,4,NULL,1),
  (6,2,6,NULL,1),
  (7,2,8,NULL,1),
  (8,2,9,NULL,1),
  (9,3,1,NULL,1),
  (10,3,4,NULL,1),
  (11,3,6,NULL,1),
  (12,3,7,NULL,1),
  (13,3,8,NULL,1),
  (14,4,4,NULL,1),
  (15,4,5,NULL,1),
  (16,4,7,NULL,1),
  (17,4,9,NULL,1),
  (18,5,3,NULL,1),
  (19,5,7,NULL,1),
  (20,5,8,NULL,1);
CREATE TABLE IF NOT EXISTS `partner_area` (`id` integer primary key AUTO_INCREMENT not NULL, `partner_id` integer not NULL, `area_id` integer not NULL, `is_active` tinyint(1) not NULL default '1', foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade, foreign key(`area_id`) references `areas`(`id`) on delete cascade);
INSERT INTO partner_area VALUES(1,1,1,1),
  (2,1,3,1),
  (3,1,8,1),
  (4,2,2,1),
  (5,2,3,1),
  (6,2,6,1),
  (7,2,7,1),
  (8,2,10,1),
  (9,3,5,1),
  (10,3,6,1),
  (11,3,7,1),
  (12,3,8,1),
  (13,3,9,1),
  (14,4,1,1),
  (15,4,7,1),
  (16,4,8,1),
  (17,4,9,1),
  (18,4,10,1),
  (19,5,1,1),
  (20,5,3,1),
  (21,5,7,1);
CREATE TABLE IF NOT EXISTS `bookings` (`id` integer primary key AUTO_INCREMENT not NULL, `booking_code` varchar not NULL, `customer_id` integer not NULL, `partner_id` integer, `service_id` integer not NULL, `area_id` integer not NULL, `customer_name` varchar not NULL, `customer_phone` varchar not NULL, `address` text not NULL, `pincode` varchar, `lat` numeric, `lng` numeric, `scheduled_date` date not NULL, `scheduled_slot` varchar, `notes` text, `amount_paise` integer not NULL default '0', `tax_paise` integer not NULL default '0', `total_paise` integer not NULL default '0', `status` varchar check (`status` in ('pending', 'accepted', 'rejected', 'on_the_way', 'arrived', 'in_progress', 'completed', 'cancelled')) not NULL default 'pending', `payment_status` varchar not NULL default 'pending', `payment_method` varchar not NULL default 'cod', `transaction_id` varchar, `start_otp` varchar, `start_otp_verified_at` datetime, `completion_otp` varchar, `completion_otp_verified_at` datetime, `accepted_at` datetime, `started_at` datetime, `completed_at` datetime, `cancelled_at` datetime, `created_at` datetime, `updated_at` datetime, `is_subscription` tinyint(1) not NULL default '0', `visits_per_period` integer not NULL default '1', `visits_used` integer not NULL default '0', `subscription_code` varchar, `billing_period` varchar not NULL default 'monthly', `current_period_start` date, `current_period_end` date, `next_billing_date` date, `auto_renew` tinyint(1) not NULL default '1', `subscription_status` varchar check (`subscription_status` in ('inactive', 'active', 'paused', 'cancelled', 'expired')) not NULL default 'inactive', foreign key(`customer_id`) references `users`(`id`) on delete cascade, foreign key(`partner_id`) references `partner_profiles`(`id`) on delete set NULL, foreign key(`service_id`) references `services`(`id`), foreign key(`area_id`) references `areas`(`id`));
INSERT INTO bookings VALUES(1,'BFK-INZQHQ',2,1,3,1,'Demo Customer','9876500001','Tower B, Supertech Ecociti, Sector 137, Noida',NULL,NULL,NULL,'2026-08-06 00:00:00','10:00 AM - 11:00 AM',NULL,200000,10000,210000,'pending','pending','cod',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-05 16:37:37','2026-08-08 17:13:42',1,30,0,'SUB-GDKZVA','monthly','2026-08-06 00:00:00','2026-08-31 00:00:00','2026-09-06 00:00:00',1,'active'),
  (2,'BFK-LQYEJA',2,1,1,1,'Demo Customer','9876500001','Tower A, Supertech Ecociti, Sector 137, Noida','201305',NULL,NULL,'2026-08-05 00:00:00','10:00 AM - 11:00 AM',NULL,150000,7500,157500,'accepted','paid','cod',NULL,NULL,NULL,NULL,NULL,'2026-08-05 17:18:51',NULL,NULL,NULL,'2026-08-05 17:18:51','2026-08-08 17:13:42',1,30,0,'SUB-OAEGDG','monthly','2026-08-05 00:00:00','2026-08-31 00:00:00','2026-09-05 00:00:00',1,'active'),
  (3,'BFK-6AKWOG',2,1,1,1,'Demo Customer','9876500001','Tower A, Supertech Ecociti, Sector 137, Noida','201305',NULL,NULL,'2026-08-05 00:00:00','10:00 AM - 11:00 AM',NULL,150000,7500,157500,'accepted','paid','cod',NULL,NULL,NULL,NULL,NULL,'2026-08-05 17:18:58',NULL,NULL,NULL,'2026-08-05 17:18:58','2026-08-08 17:13:42',1,30,0,'SUB-ZA5G3G','monthly','2026-08-05 00:00:00','2026-08-31 00:00:00','2026-09-05 00:00:00',1,'active'),
  (4,'BFK-YTPXW',2,1,1,1,'Demo Customer','9876500001','Tower A, Supertech Ecociti, Sector 137, Noida','201305',NULL,NULL,'2026-08-05 00:00:00','10:00 AM - 11:00 AM',NULL,150000,7500,157500,'accepted','paid','cod',NULL,NULL,NULL,NULL,NULL,'2026-08-05 17:19:03',NULL,NULL,NULL,'2026-08-05 17:19:03','2026-08-08 17:13:42',1,30,0,'SUB-NNNYVA','monthly','2026-08-05 00:00:00','2026-08-31 00:00:00','2026-09-05 00:00:00',1,'active'),
  (5,'BFK-LHQBG6',2,1,1,9,'Demo Customer','9876500001','Tower A, Supertech Ecociti, Sector 137, Noida','201305',NULL,NULL,'2026-08-10 00:00:00','10:00 AM - 11:00 AM',NULL,3900000,195000,4095000,'accepted','paid','cash',NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14',NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',1,26,0,'BFK-LHQBG6','monthly','2026-08-10 00:00:00','2026-09-09 00:00:00','2026-09-09 00:00:00',1,'active');
CREATE TABLE IF NOT EXISTS `ratings` (`id` integer primary key AUTO_INCREMENT not NULL, `booking_id` integer not NULL, `customer_id` integer not NULL, `partner_id` integer not NULL, `rating` integer not NULL, `review` text, `tags` text, `created_at` datetime, `updated_at` datetime, foreign key(`booking_id`) references `bookings`(`id`) on delete cascade, foreign key(`customer_id`) references `users`(`id`), foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade);
CREATE TABLE IF NOT EXISTS `booking_status_logs` (`id` integer primary key AUTO_INCREMENT not NULL, `booking_id` integer not NULL, `status` varchar not NULL, `note` varchar, `changed_by` integer, `created_at` datetime, `updated_at` datetime, foreign key(`booking_id`) references `bookings`(`id`) on delete cascade, foreign key(`changed_by`) references `users`(`id`) on delete set NULL);
INSERT INTO booking_status_logs VALUES(1,1,'pending','Subscription created — first visit scheduled',2,'2026-08-05 16:37:37','2026-08-05 16:37:37');
CREATE TABLE IF NOT EXISTS `customer_addresses` (`id` integer primary key AUTO_INCREMENT not NULL, `customer_id` integer not NULL, `label` varchar not NULL default 'Home', `address` text not NULL, `pincode` varchar, `lat` numeric, `lng` numeric, `is_default` tinyint(1) not NULL default '0', `created_at` datetime, `updated_at` datetime, foreign key(`customer_id`) references `users`(`id`) on delete cascade);
INSERT INTO customer_addresses VALUES(1,2,'My current location','ATS Pristine, Noida','201306',28.4744,77.504,1,'2026-08-08 16:59:28','2026-08-08 16:59:28');
CREATE TABLE IF NOT EXISTS `settings` (`id` integer primary key AUTO_INCREMENT not NULL, `key` varchar not NULL, `value` text, `type` varchar not NULL default 'text', `group` varchar not NULL default 'general', `created_at` datetime, `updated_at` datetime);
INSERT INTO settings VALUES(1,'site_name','Befikreyy','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (2,'site_tagline','Handyman & Home Services Marketplace','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (3,'site_phone','+91 7291061623','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (4,'site_email','contactus@befikreyyhomes.com','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (5,'site_address','Flat F701, Supertech Ecociti, Sector 137, Noida','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (6,'site_whatsapp','917291061623','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (7,'tax_percent','5','text','billing','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (8,'currency','₹','text','general','2026-08-05 16:28:04','2026-08-05 16:28:04'),
  (9,'commission.platform_percent','15','int','commission','2026-08-10 13:21:58','2026-08-10 13:37:46'),
  (10,'commission.first_month_bonus_paise','0','int','commission','2026-08-10 13:21:58','2026-08-10 13:37:46'),
  (11,'commission.tds_percent','0','int','commission','2026-08-10 13:21:58','2026-08-10 13:37:46'),
  (12,'commission.min_payout_paise','10000','int','commission','2026-08-10 13:21:58','2026-08-10 13:37:46'),
  (13,'commission.policy_note','Updated policy text','text','commission','2026-08-10 13:21:58','2026-08-10 13:36:46');
CREATE TABLE IF NOT EXISTS `partner_leaves` (`id` integer primary key AUTO_INCREMENT not NULL, `partner_id` integer not NULL, `booking_id` integer, `leave_date` date not NULL, `leave_end_date` date, `leave_type` varchar check (`leave_type` in ('full_day', 'half_day', 'multi_day')) not NULL default 'full_day', `reason` varchar, `status` varchar check (`status` in ('pending', 'approved', 'rejected', 'cancelled')) not NULL default 'pending', `replacement_partner_id` varchar, `admin_notes` text, `responded_at` datetime, `created_at` datetime, `updated_at` datetime, foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade, foreign key(`booking_id`) references `bookings`(`id`) on delete set NULL);
INSERT INTO partner_leaves VALUES(1,1,NULL,'2026-08-20 00:00:00','2026-08-20 00:00:00','full_day','Family function','pending',NULL,NULL,NULL,'2026-08-06 14:50:04','2026-08-06 14:50:04');
CREATE TABLE IF NOT EXISTS `partner_attendances` (`id` integer primary key AUTO_INCREMENT not NULL, `partner_id` integer not NULL, `attendance_date` date not NULL, `attendance_type` varchar check (`attendance_type` in ('check_in', 'check_out')) not NULL default 'check_in', `logged_at` datetime not NULL, `lat` numeric, `lng` numeric, `screenshot_path` varchar, `note` varchar, `created_at` datetime, `updated_at` datetime, foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade);
INSERT INTO partner_attendances VALUES(1,1,'2026-08-06 00:00:00','check_in','2026-08-06 14:52:42',NULL,NULL,NULL,'Arrived at Sector 137 customer location','2026-08-06 14:52:42','2026-08-06 14:52:42');
CREATE TABLE IF NOT EXISTS `booking_photos` (`id` integer primary key AUTO_INCREMENT not NULL, `booking_id` integer not NULL, `partner_id` integer not NULL, `stage` varchar not NULL default ('before'), `photo_path` varchar not NULL, `caption` varchar, `lat` numeric, `lng` numeric, `created_at` datetime, `updated_at` datetime, `visit_id` integer, `uploaded_by` integer, foreign key(`partner_id`) references partner_profiles(`id`) on delete cascade on update no action, foreign key(`booking_id`) references bookings(`id`) on delete cascade on update no action, foreign key(`visit_id`) references `subscription_visits`(`id`) on delete set NULL, foreign key(`uploaded_by`) references `users`(`id`) on delete set NULL);
CREATE TABLE IF NOT EXISTS `partner_team_members` (`id` integer primary key AUTO_INCREMENT not NULL, `partner_id` integer not NULL, `user_id` integer, `name` varchar not NULL, `phone` varchar, `email` varchar, `role` varchar not NULL default 'Helper', `photo` varchar, `is_active` tinyint(1) not NULL default '1', `aadhaar_verified` tinyint(1) not NULL default '0', `police_verified` tinyint(1) not NULL default '0', `aadhaar_doc_path` varchar, `police_doc_path` varchar, `aadhaar_verified_at` datetime, `police_verified_at` datetime, `last_login_at` datetime, `admin_notes` text, `created_at` datetime, `updated_at` datetime, foreign key(`partner_id`) references `partner_profiles`(`id`) on delete cascade, foreign key(`user_id`) references `users`(`id`) on delete set NULL);
INSERT INTO partner_team_members VALUES(1,5,8,'Ramesh Kumar','9876543299','ramesh.vijay@partner.befikreyy.com','Helper',NULL,1,0,0,NULL,NULL,NULL,NULL,'2026-08-10 09:41:31',NULL,'2026-08-09 11:35:18','2026-08-10 09:41:31'),
  (2,5,8,'Ramesh Kumar','9876543299','ramesh.vijay@partner.befikreyy.com','Helper',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:35:36','2026-08-09 11:35:36');
CREATE TABLE IF NOT EXISTS `subscription_visits` (`id` integer primary key AUTO_INCREMENT not NULL, `booking_id` integer not NULL, `partner_id` integer, `scheduled_date` date not NULL, `scheduled_slot` varchar, `default_time` time, `status` varchar not NULL default ('scheduled'), `attendance_status` varchar not NULL default ('pending'), `marked_present_at` datetime, `arrival_time` time, `departure_time` time, `attendance_note` text, `customer_visible` tinyint(1) not NULL default (1), `photos_required` tinyint(1) not NULL default (0), `photos_count` integer not NULL default (0), `auto_absent_marked` tinyint(1) not NULL default (0), `auto_absent_at` datetime, `start_otp` varchar, `start_otp_verified_at` datetime, `completion_otp` varchar, `completion_otp_verified_at` datetime, `started_at` datetime, `completed_at` datetime, `cancelled_at` datetime, `notes` text, `created_at` datetime, `updated_at` datetime, `team_member_id` integer, foreign key(`partner_id`) references partner_profiles(`id`) on delete set NULL on update no action, foreign key(`booking_id`) references bookings(`id`) on delete cascade on update no action, foreign key(`team_member_id`) references `partner_team_members`(`id`) on delete set NULL);
INSERT INTO subscription_visits VALUES(1,1,1,'2026-08-06 00:00:00','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-05 16:37:37','2026-08-08 17:23:51',NULL),
  (2,4,1,'2026-08-05 00:00:00','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-05 17:19:03','2026-08-08 17:23:51',NULL),
  (4,1,1,'2026-08-07','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (5,1,1,'2026-08-08','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (6,1,1,'2026-08-09','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (7,1,1,'2026-08-10','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (8,1,1,'2026-08-11','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (9,1,1,'2026-08-12','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (10,1,1,'2026-08-13','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (11,1,1,'2026-08-14','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (12,1,1,'2026-08-15','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (13,1,1,'2026-08-16','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (14,1,1,'2026-08-17','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (15,1,1,'2026-08-18','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(16,1,1,'2026-08-19','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (17,1,1,'2026-08-20','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (18,1,1,'2026-08-21','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (19,1,1,'2026-08-22','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (20,1,1,'2026-08-23','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (21,1,1,'2026-08-24','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (22,1,1,'2026-08-25','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (23,1,1,'2026-08-26','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (24,1,1,'2026-08-27','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (25,1,1,'2026-08-28','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (26,1,1,'2026-08-29','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (27,1,1,'2026-08-30','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (28,1,1,'2026-08-31','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (29,1,1,'2026-09-01','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (30,1,1,'2026-09-02','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (31,1,1,'2026-09-03','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(32,1,1,'2026-09-04','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (33,2,1,'2026-08-05','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (34,2,1,'2026-08-06','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (35,2,1,'2026-08-07','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (36,2,1,'2026-08-08','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (37,2,1,'2026-08-09','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (38,2,1,'2026-08-10','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (39,2,1,'2026-08-11','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (40,2,1,'2026-08-12','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (41,2,1,'2026-08-13','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (42,2,1,'2026-08-14','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (43,2,1,'2026-08-15','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (44,2,1,'2026-08-16','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (45,2,1,'2026-08-17','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(46,2,1,'2026-08-18','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (47,2,1,'2026-08-19','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (48,2,1,'2026-08-20','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (49,2,1,'2026-08-21','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (50,2,1,'2026-08-22','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (51,2,1,'2026-08-23','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (52,2,1,'2026-08-24','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (53,2,1,'2026-08-25','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (54,2,1,'2026-08-26','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (55,2,1,'2026-08-27','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (56,2,1,'2026-08-28','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (57,2,1,'2026-08-29','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (58,2,1,'2026-08-30','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (59,2,1,'2026-08-31','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (60,2,1,'2026-09-01','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (61,2,1,'2026-09-02','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(62,2,1,'2026-09-03','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (63,3,1,'2026-08-05','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (64,3,1,'2026-08-06','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (65,3,1,'2026-08-07','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (66,3,1,'2026-08-08','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (67,3,1,'2026-08-09','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (68,3,1,'2026-08-10','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (69,3,1,'2026-08-11','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (70,3,1,'2026-08-12','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (71,3,1,'2026-08-13','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (72,3,1,'2026-08-14','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (73,3,1,'2026-08-15','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (74,3,1,'2026-08-16','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (75,3,1,'2026-08-17','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(76,3,1,'2026-08-18','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (77,3,1,'2026-08-19','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (78,3,1,'2026-08-20','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (79,3,1,'2026-08-21','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (80,3,1,'2026-08-22','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (81,3,1,'2026-08-23','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (82,3,1,'2026-08-24','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (83,3,1,'2026-08-25','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (84,3,1,'2026-08-26','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (85,3,1,'2026-08-27','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (86,3,1,'2026-08-28','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (87,3,1,'2026-08-29','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (88,3,1,'2026-08-30','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (89,3,1,'2026-08-31','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (90,3,1,'2026-09-01','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (91,3,1,'2026-09-02','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(92,3,1,'2026-09-03','10:00 AM - 11:00 AM',NULL,'accepted','present','2026-08-08 17:34:36','17:34','17:34',NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:34:36',NULL),
  (93,4,1,'2026-08-06','10:00 AM - 11:00 AM',NULL,'accepted','present','2026-08-08 17:59:31','10:00','11:00','Test',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:59:31',NULL),
  (94,4,1,'2026-08-07','10:00 AM - 11:00 AM',NULL,'accepted','absent',NULL,NULL,NULL,'Auto-marked absent — partner did not mark attendance within 24 hours',1,0,0,1,'2026-08-08 17:23:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:23:51',NULL),
  (95,4,1,'2026-08-08','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (96,4,1,'2026-08-09','10:00 AM - 11:00 AM',NULL,'accepted','present','2026-08-09 09:47:57','10:00','11:00','Test by Rajesh',1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-09 09:47:57',NULL),
  (97,4,1,'2026-08-10','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (98,4,1,'2026-08-11','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (99,4,1,'2026-08-12','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (100,4,1,'2026-08-13','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (101,4,1,'2026-08-14','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (102,4,1,'2026-08-15','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (103,4,1,'2026-08-16','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (104,4,1,'2026-08-17','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (105,4,1,'2026-08-18','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (106,4,1,'2026-08-19','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL);
INSERT INTO subscription_visits VALUES(107,4,1,'2026-08-20','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (108,4,1,'2026-08-21','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (109,4,1,'2026-08-22','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (110,4,1,'2026-08-23','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (111,4,1,'2026-08-24','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (112,4,1,'2026-08-25','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (113,4,1,'2026-08-26','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (114,4,1,'2026-08-27','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (115,4,1,'2026-08-28','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (116,4,1,'2026-08-29','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (117,4,1,'2026-08-30','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (118,4,1,'2026-08-31','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (119,4,1,'2026-09-01','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (120,4,1,'2026-09-02','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (121,4,1,'2026-09-03','10:00 AM - 11:00 AM',NULL,'accepted','pending',NULL,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-08 17:13:42','2026-08-08 17:13:42',NULL),
  (122,5,1,'2026-08-10 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL);
INSERT INTO subscription_visits VALUES(123,5,1,'2026-08-11 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (124,5,1,'2026-08-12 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (125,5,1,'2026-08-13 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (126,5,1,'2026-08-14 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (127,5,1,'2026-08-15 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (128,5,1,'2026-08-16 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (129,5,1,'2026-08-17 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (130,5,1,'2026-08-18 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (131,5,1,'2026-08-19 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (132,5,1,'2026-08-20 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (133,5,1,'2026-08-21 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (134,5,1,'2026-08-22 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (135,5,1,'2026-08-23 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (136,5,1,'2026-08-24 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL);
INSERT INTO subscription_visits VALUES(137,5,1,'2026-08-25 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:14','2026-08-09 11:54:14',NULL),
  (138,5,1,'2026-08-26 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (139,5,1,'2026-08-27 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (140,5,1,'2026-08-28 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (141,5,1,'2026-08-29 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (142,5,1,'2026-08-30 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (143,5,1,'2026-08-31 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (144,5,1,'2026-09-01 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (145,5,1,'2026-09-02 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (146,5,1,'2026-09-03 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL),
  (147,5,1,'2026-09-04 00:00:00','10:00 AM - 11:00 AM','10:00 AM - 11:00 AM','scheduled','pending',NULL,NULL,NULL,NULL,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-08-09 11:54:15','2026-08-09 11:54:15',NULL);
CREATE TABLE IF NOT EXISTS `users` (`id` integer primary key AUTO_INCREMENT not NULL, `name` varchar not NULL, `email` varchar not NULL, `email_verified_at` datetime, `password` varchar not NULL, `remember_token` varchar, `created_at` datetime, `updated_at` datetime, `phone` varchar, `role` varchar not NULL default 'customer', `is_partner_approved` tinyint(1) not NULL default '0', `avatar` varchar, `address` text, `city` varchar, `pincode` varchar, `lat` numeric, `lng` numeric);
INSERT INTO users VALUES(1,'Befikreyy Admin','admin@befikreyy.com',NULL,'$2y$12$/Q09hfgOlO5XLxaFCHOZCOUaY9DV1y36mf6zgTdobWizbsY0wZjNG',NULL,'2026-08-05 16:28:04','2026-08-05 16:28:04','7291061623','admin',1,NULL,NULL,NULL,NULL,NULL,NULL),
  (2,'Demo Customer','customer@demo.com',NULL,'$2y$12$de1v9sL2iLASN8hZuqvMD.PZJwtfgSMjVDppaLRgXgHpDe3Yc/y/u','kU22HMoj3ybQQ2OmoYpn93OT630Mf56y6Rvwy0BBXtIfoD1elqHv10wF30kH','2026-08-05 16:28:04','2026-08-08 17:00:31','9876500001','customer',0,NULL,NULL,NULL,NULL,NULL,NULL),
  (3,'Rajesh Kumar','rajesh@partner.befikreyy.com',NULL,'$2y$12$Qq20vd8qQ4CXsVxqdhkSruLCPA/w1h4rC/Xzc6s36SPsSOdJKCkRy','DSNYbRgqyrS7bAXnupXJecHXtdN6hwUED3CXszgHvhMUsBZ1oS4PnR3tranr','2026-08-05 16:28:05','2026-08-10 13:51:23','9876500002','partner',0,NULL,NULL,NULL,NULL,NULL,NULL),
  (4,'Suresh Yadav','suresh@partner.befikreyy.com',NULL,'$2y$12$/PAn.M4p5BAa118lpF6u/.vg1GFAxLkXVX9SCP/hgjZbngUGlGmIO',NULL,'2026-08-05 16:28:05','2026-08-05 16:28:05','9876543211','partner',1,NULL,NULL,NULL,NULL,NULL,NULL),
  (5,'Amit Sharma','amit@partner.befikreyy.com',NULL,'$2y$12$TBxDfAyx/QGMdWT9lyT.0e198SqElAF2XvFVVyRK69kfLAd5XWf52',NULL,'2026-08-05 16:28:06','2026-08-05 16:28:06','9876543212','partner',1,NULL,NULL,NULL,NULL,NULL,NULL),
  (6,'Manoj Singh','manoj@partner.befikreyy.com',NULL,'$2y$12$k6gSfaFDjnd.IhvmcC.0tuzKpCElzlIm13v.dU3xUXGv7k5rXE21i',NULL,'2026-08-05 16:28:06','2026-08-05 16:28:06','9876543213','partner',1,NULL,NULL,NULL,NULL,NULL,NULL),
  (7,'Vijay Verma','vijay@partner.befikreyy.com',NULL,'$2y$12$laQvVfqbAYKkKOY1oHmyKeYkJR7KW1oJD2WpSr6m8QqNHm08yUN3q',NULL,'2026-08-05 16:28:07','2026-08-05 16:28:07','9876543214','partner',1,NULL,NULL,NULL,NULL,NULL,NULL),
  (8,'Ramesh Kumar','ramesh.vijay@partner.befikreyy.com',NULL,'$2y$12$NR2w08Zycxc6zIzp92V13uwQ3QJ/F73dSbKY3m90d6L1FklRqYske',NULL,'2026-08-09 11:35:18','2026-08-10 09:37:09','9876543299','team_member',0,NULL,NULL,NULL,NULL,NULL,NULL);
PRAGMA writable_schema=ON;
CREATE TABLE IF NOT EXISTS sqlite_sequence(name,seq);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('migrations',19),
  ('settings',13),
  ('areas',10),
  ('service_categories',2),
  ('services',9),
  ('partner_profiles',8),
  ('partner_area',21),
  ('partner_service',20),
  ('bookings',5),
  ('booking_status_logs',1),
  ('partner_leaves',1),
  ('partner_attendances',1),
  ('customer_addresses',1),
  ('booking_photos',0),
  ('subscription_visits',147),
  ('users',8),
  ('partner_team_members',2);
CREATE INDEX `sessions_user_id_index` on `sessions` (`user_id`);
CREATE INDEX `sessions_last_activity_index` on `sessions` (`last_activity`);
CREATE INDEX `cache_expiration_index` on `cache` (`expiration`);
CREATE INDEX `cache_locks_expiration_index` on `cache_locks` (`expiration`);
CREATE INDEX `jobs_queue_index` on `jobs` (`queue`);
CREATE INDEX `failed_jobs_connection_queue_failed_at_index` on `failed_jobs` (`connection`, `queue`, `failed_at`);
CREATE UNIQUE INDEX `failed_jobs_uuid_unique` on `failed_jobs` (`uuid`);
CREATE UNIQUE INDEX `service_categories_slug_unique` on `service_categories` (`slug`);
CREATE UNIQUE INDEX `services_slug_unique` on `services` (`slug`);
CREATE UNIQUE INDEX `areas_slug_unique` on `areas` (`slug`);
CREATE UNIQUE INDEX `partner_profiles_user_id_unique` on `partner_profiles` (`user_id`);
CREATE INDEX `bookings_status_scheduled_date_index` on `bookings` (`status`, `scheduled_date`);
CREATE INDEX `bookings_customer_id_index` on `bookings` (`customer_id`);
CREATE INDEX `bookings_partner_id_index` on `bookings` (`partner_id`);
CREATE UNIQUE INDEX `bookings_booking_code_unique` on `bookings` (`booking_code`);
CREATE UNIQUE INDEX `ratings_booking_id_unique` on `ratings` (`booking_id`);
CREATE UNIQUE INDEX `settings_key_unique` on `settings` (`key`);
CREATE UNIQUE INDEX `bookings_subscription_code_unique` on `bookings` (`subscription_code`);
CREATE INDEX `partner_leaves_partner_id_leave_date_index` on `partner_leaves` (`partner_id`, `leave_date`);
CREATE INDEX `partner_leaves_leave_date_status_index` on `partner_leaves` (`leave_date`, `status`);
CREATE INDEX `partner_attendances_partner_id_attendance_date_index` on `partner_attendances` (`partner_id`, `attendance_date`);
CREATE INDEX `booking_photos_visit_id_index` on `booking_photos` (`visit_id`);
CREATE INDEX `partner_team_members_partner_id_is_active_index` on `partner_team_members` (`partner_id`, `is_active`);
CREATE INDEX `subscription_visits_attendance_status_index` on `subscription_visits` (`attendance_status`);
CREATE INDEX `subscription_visits_booking_id_index` on `subscription_visits` (`booking_id`);
CREATE INDEX `subscription_visits_scheduled_date_attendance_status_index` on `subscription_visits` (`scheduled_date`, `attendance_status`);
CREATE INDEX `subscription_visits_scheduled_date_status_index` on `subscription_visits` (`scheduled_date`, `status`);
CREATE INDEX `subscription_visits_team_member_id_index` on `subscription_visits` (`team_member_id`);
CREATE UNIQUE INDEX `users_email_unique` on `users` (`email`);
CREATE UNIQUE INDEX `users_phone_unique` on `users` (`phone`);
PRAGMA writable_schema=OFF;


