(236736,201,10,'update','vc_appointment',91,'APT-0009','{\"status\":\"pending\"}','{\"status\":\"in_progress\",\"consultation_started_at\":\"2026-06-24T22:31:55.113714Z\"}','[\"status\",\"consultation_started_at\"]','https://localhost/saas-one/public/vet-clinic/appointments/91/status','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0','2026-06-24 22:31:55','816f3141-bf49-43f8-bdb1-9d2fc90860e4',1),(236737,201,10,'update','Modules\\VetClinic\\Entities\\VcAppointment',91,'APT-0009','{\"ai_subjective_hash\":null,\"ai_exam_suggestions_json\":null,\"ai_symptoms_json\":null,\"ai_advice_updated_at\":null}','{\"ai_subjective_hash\":\"642409b609908d21f0b6784365a2ae27f53a29a6\",\"ai_exam_suggestions_json\":\"{\\\"suggested\\\":[],\\\"reason\\\":\\\"\\\"}\",\"ai_symptoms_json\":\"{\\\"findings\\\":[],\\\"overall_concern\\\":\\\"low\\\"}\",\"ai_advice_updated_at\":\"2026-06-24T22:32:19.864434Z\"}','[\"ai_subjective_hash\",\"ai_exam_suggestions_json\",\"ai_symptoms_json\",\"ai_advice_updated_at\"]','https://localhost/saas-one/public/vet-ai/cache-advice','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0','2026-06-24 22:32:19','95724fa6-1c3e-40ed-bf14-5304d3a64346',1),(236738,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-24 23:20:04',NULL,1),(236739,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-24 23:20:30',NULL,1),(236740,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"api_key\":null,\"model\":null,\"enabled\":false,\"use_separate_transcription\":false,\"t_provider\":null}','{\"api_key\":\"eyJpdiI6InU3eUkzbGlTTXhaU0Fua1BvYnNmanc9PSIsInZhbHVlIjoiUUo1TkhvQTh0dmJrNmx0R2hMblU4ZTgrL0lYb2tGd3NabVlIQnV3M3V0RTVERWdtZHhJV2RqOUR4UU5YNWM2bUd1cERUWkVpWHJiZlNJWVFUcElIbFE9PSIsIm1hYyI6IjY4MGZjOTk5YmM3OGNiZGJhN2EyMGRmZDI2NDIyY2Y3OTg0MDU3ZmJmMzY3MTk4YzhjOTlkMWE3MDhmY2QzNWUiLCJ0YWciOiIifQ==\",\"model\":\"mistral-large\",\"enabled\":1,\"use_separate_transcription\":1,\"t_provider\":\"webspeech\"}','[\"api_key\",\"model\",\"enabled\",\"use_separate_transcription\",\"t_provider\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:44:35','119ed7e4-e70b-463c-b21d-16feec6bbe56',1),(236741,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',21,'#21',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"extract_symptoms\",\"provider\":\"openai_compatible\",\"model\":\"mistral-large\",\"tokens_in\":369,\"tokens_out\":121,\"ok\":true,\"error\":null,\"id\":21}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:44:38','119ed7e4-e70b-463c-b21d-16feec6bbe56',0),(236742,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',22,'#22',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"clean_transcript\",\"provider\":\"openai_compatible\",\"model\":\"mistral-large\",\"tokens_in\":342,\"tokens_out\":28,\"ok\":true,\"error\":null,\"id\":22}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:44:40','119ed7e4-e70b-463c-b21d-16feec6bbe56',0),(236743,NULL,10,'create','Modules\\AiCore\\Entities\\AiProvider',9,'fallback',NULL,'{\"business_id\":10,\"name\":\"fallback\",\"provider\":\"openai_compatible\",\"base_url\":\"https:\\/\\/router.bynara.id\\/v1\",\"model\":\"mimo-v2.5-pro-free\",\"api_key\":\"eyJpdiI6IjhXRHNqL0hXdmU5TGFYRTZ6cXNXWkE9PSIsInZhbHVlIjoiaTNjVVhRYitReUxWQmNyRVJwU0dYbVNiVDRkN1BkaTRTVjZhK3JzdTRxOVNzc0JaSVFEZFlkakNXclpOcHJRbkJmUUJBczk5ZUx6dTFnZklhSTc5bVE9PSIsIm1hYyI6IjFhNGQ0OGI3ZDNkNDM1NzAzZTYyOTBhYjE4MzdkMDI0YWFmZTBiZGM1ZjU0MDJkMDc0NzFiYTlmZThkNzUwNmIiLCJ0YWciOiIifQ==\",\"enabled\":1,\"business_vertical\":\"vet_clinic\",\"id\":9}','[\"business_id\",\"name\",\"provider\",\"base_url\",\"model\",\"api_key\",\"enabled\",\"business_vertical\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:49:25','cef1989a-2d5d-43a0-b202-d085ef383b05',1),(236744,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',23,'#23',NULL,'{\"business_id\":10,\"module\":\"test\",\"feature\":\"failover_probe\",\"provider\":\"openai_compatible\",\"model\":\"nonexistent-model-zzz\",\"tokens_in\":0,\"tokens_out\":0,\"ok\":false,\"error\":\"API error 404: The requested model does not exist.\",\"id\":23}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:49:26','cef1989a-2d5d-43a0-b202-d085ef383b05',0),(236745,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',24,'#24',NULL,'{\"business_id\":10,\"module\":\"test\",\"feature\":\"failover_probe:fallback\",\"provider\":\"openai_compatible\",\"model\":\"mimo-v2.5-pro-free\",\"tokens_in\":22,\"tokens_out\":15,\"ok\":true,\"error\":null,\"id\":24}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:49:30','cef1989a-2d5d-43a0-b202-d085ef383b05',0),(236746,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',9,'fallback','{\"base_url\":\"https:\\/\\/router.bynara.id\\/v1\",\"api_key\":\"sk-nry-rcPNgAIbcl-M8CPdDs0BHT-Rlu3zGkLHOyW9Ww439hY\",\"model\":\"mimo-v2.5-pro-free\"}','{\"base_url\":\"https:\\/\\/api.groq.com\\/openai\\/v1\",\"api_key\":\"eyJpdiI6IjN3Y3hCYmFRdEx4SUpqRXRRN3RpSkE9PSIsInZhbHVlIjoiM0xGY0FjWWJTVUZNWXhkQmhDdnR4Y3JreFJ6bmJwTHV5dVJWOE5wL05rQ0VORzZ5SXUxUnY0YzZSaklpbzFwY2NxZkdWNFVtMElRcmwxalUwVElBM1E9PSIsIm1hYyI6IjUxMmVhYzQ4MzM3MjFkNzk4YWQ0YjFkZmZmMjZjMDI5MjYzM2U2N2E3ZmFhMzc2NDlmNTc0ODI3MDkzMGU1ODEiLCJ0YWciOiIifQ==\",\"model\":\"llama-3.3-70b-versatile\"}','[\"base_url\",\"api_key\",\"model\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:59:19','f2592b17-8b6d-4303-8e3e-42dd2efebe8c',1),(236747,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"t_provider\":\"webspeech\",\"t_api_key\":null,\"t_model\":null}','{\"t_provider\":\"whisper_groq\",\"t_api_key\":\"eyJpdiI6InlTMFpOWjNPWVBVTnhRR3FJbWdWVVE9PSIsInZhbHVlIjoiUzJ6WUszV3MvN3dpRW8wbGEvTGk0cGQwTlJvcGdqNnM2aDFObkwyL2lRZFg3bHJMeFBsZGVSaDJOTGJWeTNwdmVRM25BU1Y3WFE5TEVlRnpEc3NDUEE9PSIsIm1hYyI6ImMzM2Y0YjRhNTgyNDNiMzI5YWMzODRjZTI1Y2ExY2VmZjBkMGE0MzY2Y2Q0Njg3ZjIyNWU0MWE1ZDdlOWJhMmEiLCJ0YWciOiIifQ==\",\"t_model\":\"whisper-large-v3-turbo\"}','[\"t_provider\",\"t_api_key\",\"t_model\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:59:19','f2592b17-8b6d-4303-8e3e-42dd2efebe8c',0),(236748,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',25,'#25',NULL,'{\"business_id\":10,\"module\":\"test\",\"feature\":\"groq_fb_probe\",\"provider\":\"openai_compatible\",\"model\":\"nonexistent-zzz\",\"tokens_in\":0,\"tokens_out\":0,\"ok\":false,\"error\":\"API error 404: The requested model does not exist.\",\"id\":25}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:59:20','f2592b17-8b6d-4303-8e3e-42dd2efebe8c',0),(236749,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',26,'#26',NULL,'{\"business_id\":10,\"module\":\"test\",\"feature\":\"groq_fb_probe:fallback\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":45,\"tokens_out\":2,\"ok\":true,\"error\":null,\"id\":26}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 02:59:20','f2592b17-8b6d-4303-8e3e-42dd2efebe8c',0),(236750,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',27,'#27',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"clean_transcript\",\"provider\":\"openai_compatible\",\"model\":\"mistral-large\",\"tokens_in\":342,\"tokens_out\":28,\"ok\":true,\"error\":null,\"id\":27}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:00:36','82259b3b-72c0-49dd-8566-0de52e3acf17',1),(236751,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"base_url\":\"https:\\/\\/router.bynara.id\\/v1\",\"api_key\":\"sk-nry-rcPNgAIbcl-M8CPdDs0BHT-Rlu3zGkLHOyW9Ww439hY\",\"model\":\"mistral-large\"}','{\"base_url\":\"https:\\/\\/api.groq.com\\/openai\\/v1\",\"api_key\":\"eyJpdiI6IjJ5Y0lTT3A1K1pNZmlCaW4xVDRvNUE9PSIsInZhbHVlIjoiZlJ5OC9xTGVXVXY0SHViVTNTa3QvR1F3SlNjenlwUllDUEYxNDBlU0YvcXhNQU5oNHJOSlFyREY4V3ZFQTFoR1RXL3BmNU13MnA1eVh2YWV5N1B4dkE9PSIsIm1hYyI6ImU5YWRkMjZjZTI2OTJiMWY1MjIxZTQzNTcwMDE5N2JkMzAxMzcwMTkyMDlhNWFjYjQ1ZTZkM2NlZTI5NDg3ZTMiLCJ0YWciOiIifQ==\",\"model\":\"llama-3.3-70b-versatile\"}','[\"base_url\",\"api_key\",\"model\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:02:54','2ea73159-12f1-40bc-98f1-3f79b5659f1c',1),(236752,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',9,'fallback','{\"base_url\":\"https:\\/\\/api.groq.com\\/openai\\/v1\",\"api_key\":\"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\",\"model\":\"llama-3.3-70b-versatile\"}','{\"base_url\":\"https:\\/\\/router.bynara.id\\/v1\",\"api_key\":\"eyJpdiI6Imt4aTRPV2c1ZU1UWG9CYXhnblYzVXc9PSIsInZhbHVlIjoidUVjODc5OVNoeWxRQVRVQ0Q2Y3FOVmx5TEg1d0hsU24yOUlUNW9veHl1Z0ZuKzVpQ24wMnliY1FhMDZHbk5WWjBYRzRSQ2ptNG8xUzhOWHIwS3J4WFE9PSIsIm1hYyI6ImZhZDgxYmI1NjYyNzhiYmQzMzQ1ZTY0MmY1YTQxZmMwNjAzMDQ0MmEzMzY5ZmVmNjNmM2Q5NTcwODVmNGQxN2YiLCJ0YWciOiIifQ==\",\"model\":\"mistral-large\"}','[\"base_url\",\"api_key\",\"model\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:02:54','2ea73159-12f1-40bc-98f1-3f79b5659f1c',0),(236753,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',28,'#28',NULL,'{\"business_id\":10,\"module\":\"test\",\"feature\":\"primary_check\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":61,\"tokens_out\":30,\"ok\":true,\"error\":null,\"id\":28}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:02:55','2ea73159-12f1-40bc-98f1-3f79b5659f1c',0),(236754,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"t_provider\":\"whisper_groq\"}','{\"t_provider\":\"webspeech\"}','[\"t_provider\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:21:03','43a0edda-11c3-4bb8-9f5a-8cb6cec843bb',0),(236755,NULL,5,'update','Modules\\AiCore\\Entities\\AiProvider',8,'default','{\"provider\":\"anthropic\",\"base_url\":null,\"api_key\":null,\"model\":null,\"enabled\":false,\"use_separate_transcription\":false,\"t_provider\":null}','{\"provider\":\"openai_compatible\",\"base_url\":\"https:\\/\\/api.groq.com\\/openai\\/v1\",\"api_key\":\"eyJpdiI6InZzRUNXTllHZklLNXh4N1BFdWp6bVE9PSIsInZhbHVlIjoiTGVWSU9aSnZqdjhzWSt0NllUMURDTDZEOEE1VjBQMGFuemg1QnVHNjFQakJlYktyWDBpL3RtY0N4ZzJoWnFZdzh0WXdKSjhDNC8vWHpOUDRtQnl5UVE9PSIsIm1hYyI6IjY4NzNiZDJiM2ViYmVkYThkYzYxZmIwNDE4YmZlYWUzMjM0YjUxNDViYTIzNDc3N2Q1YTVkMzQ1ODc2NDQ3YjciLCJ0YWciOiIifQ==\",\"model\":\"llama-3.3-70b-versatile\",\"enabled\":1,\"use_separate_transcription\":1,\"t_provider\":\"webspeech\"}','[\"provider\",\"base_url\",\"api_key\",\"model\",\"enabled\",\"use_separate_transcription\",\"t_provider\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:21:03','43a0edda-11c3-4bb8-9f5a-8cb6cec843bb',0),(236756,NULL,5,'create','Modules\\AiCore\\Entities\\AiProvider',10,'fallback',NULL,'{\"business_id\":5,\"name\":\"fallback\",\"business_vertical\":\"vet_clinic\",\"provider\":\"openai_compatible\",\"base_url\":\"https:\\/\\/router.bynara.id\\/v1\",\"model\":\"mistral-large\",\"api_key\":\"eyJpdiI6ImFaT2ZnMGtlMnJ6bitldWFQd1A0K3c9PSIsInZhbHVlIjoiTU1XQXd1eUhmWkx5Y1VxVnlYckovV3hvbUpCQk9SdnQ3NVNRTk5Oc2RzUDVGajU2V3hsdFRzK1VRV0x4WXJOU08wRkZxeW5rR1lYMGJ3U25BbFhtOVE9PSIsIm1hYyI6IjA0OTFkYmUwYWMyNzdlNTYxMzIwNzc3MTdjMTFlM2NiNDdlNWFkOTkxMTkzZDZhZjZkYjViNTBlMGYxMWFkZjUiLCJ0YWciOiIifQ==\",\"enabled\":1,\"id\":10}','[\"business_id\",\"name\",\"business_vertical\",\"provider\",\"base_url\",\"model\",\"api_key\",\"enabled\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 03:21:03','43a0edda-11c3-4bb8-9f5a-8cb6cec843bb',0),(236757,201,10,'view','vc_appointment',97,'APT-6A3B10E1ED0E9',NULL,NULL,'[]','https://localhost/saas-one/public/vet-clinic/appointments/97','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-25 03:22:04','0d3f0eae-a055-4681-97c1-c4c7602a26a2',1),(236758,201,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',29,'#29',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"clean_transcript\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":343,\"tokens_out\":22,\"ok\":true,\"error\":null,\"id\":29}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public/vet-ai/clean-transcript','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-25 03:22:32','31d4ea5b-36f7-4a98-a3d3-af4e32cf7509',1),(236759,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"meta\":null}','{\"meta\":\"{\\\"prompts\\\":{\\\"vet.clean\\\":\\\"OVERRIDE TEST\\\"}}\"}','[\"meta\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 15:34:11','58bcb3e4-2375-4080-a7ab-3a581711f565',1),(236760,NULL,10,'update','Modules\\AiCore\\Entities\\AiProvider',7,'default','{\"meta\":{\"prompts\":{\"vet.clean\":\"OVERRIDE TEST\"}}}','{\"meta\":\"{\\\"prompts\\\":[]}\"}','[\"meta\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-25 15:34:11','58bcb3e4-2375-4080-a7ab-3a581711f565',0),(236761,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 01:43:58',NULL,1),(236762,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',30,'#30',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"rx_safety_check\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":0,\"tokens_out\":0,\"ok\":false,\"error\":\"Request failed: cURL error 28: Failed to connect to api.groq.com port 443 after 10008 ms: Timeout was reached (see https:\\/\\/curl.haxx.se\\/libcurl\\/c\\/libcurl-errors.html) for https:\\/\\/api.groq.com\\/openai\\/v1\\/chat\\/completions\",\"id\":30}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 01:48:20','277661ea-f9d4-4307-a315-2a96217a24e5',1),(236763,NULL,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',31,'#31',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"rx_safety_check:fallback\",\"provider\":\"openai_compatible\",\"model\":\"mistral-large\",\"tokens_in\":61,\"tokens_out\":199,\"ok\":true,\"error\":null,\"id\":31}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 01:48:31','277661ea-f9d4-4307-a315-2a96217a24e5',0),(236764,201,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',32,'#32',NULL,'{\"business_id\":10,\"module\":\"VetClinic\",\"feature\":\"rx_safety_check\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":305,\"tokens_out\":63,\"ok\":true,\"error\":null,\"id\":32}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public/vet-clinic/prescriptions/check-safety','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 01:51:57','5d6ed3d0-e9a3-41c6-8f8a-542272aca8b2',1),(236765,201,10,'create','Modules\\AiCore\\Entities\\AiUsageLog',33,'#33',NULL,'{\"business_id\":10,\"module\":\"AiCore\",\"feature\":\"lab_interpret\",\"provider\":\"openai_compatible\",\"model\":\"llama-3.3-70b-versatile\",\"tokens_in\":265,\"tokens_out\":109,\"ok\":true,\"error\":null,\"id\":33}','[\"business_id\",\"module\",\"feature\",\"provider\",\"model\",\"tokens_in\",\"tokens_out\",\"ok\",\"error\",\"id\"]','https://localhost/saas-one/public/ai-core/interpret-lab','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 02:50:34','6234fd38-5734-4382-8601-4512c6d0498f',1),(236766,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 11:10:13',NULL,1),(236767,201,10,'create','App\\System',39,'#39',NULL,'{\"key\":\"neoskin_theme\",\"value\":\"{\\\"accent\\\":\\\"#a78bfa\\\",\\\"accent2\\\":\\\"#22d3ee\\\",\\\"bg\\\":\\\"#0b1020\\\",\\\"surface\\\":\\\"#121a33\\\",\\\"surface2\\\":\\\"#0e1530\\\",\\\"bg_preset\\\":\\\"midnight\\\"}\",\"id\":39}','[\"key\",\"value\",\"id\"]','https://localhost/saas-one/public/neo-skin/settings','POST','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 11:50:58','1f22acd5-b074-466c-b49c-88895f3bdf0a',1),(236768,NULL,10,'create','Modules\\PortalApi\\Entities\\PortalBrand',2,'Guest Test Clinic',NULL,'{\"business_id\":10,\"slug\":\"guesttestab061\",\"name\":\"Guest Test Clinic\",\"is_active\":true,\"public_booking\":true,\"login_methods\":\"[\\\"otp\\\"]\",\"id\":2}','[\"business_id\",\"slug\",\"name\",\"is_active\",\"public_booking\",\"login_methods\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',1),(236769,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaContact',62,'#62',NULL,'{\"business_id\":10,\"wa_id\":\"201096395880\",\"id\":62}','[\"business_id\",\"wa_id\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236770,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',169,'#169',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":62,\"wa_id\":\"201096395880\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Guest Tester, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"contact_welcome\",\"dedupe_key\":\"contact_welcome:6104\",\"available_at\":\"2026-06-26 18:06:48\",\"created_by\":null,\"id\":169}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236771,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57',NULL,'{\"business_id\":10,\"channel_id\":null,\"wa_id\":\"201096395880\",\"status\":\"open\",\"ai_enabled\":true,\"id\":57}','[\"business_id\",\"channel_id\",\"wa_id\",\"status\",\"ai_enabled\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236772,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57','[]','{\"contact_id\":62}','[\"contact_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236773,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',169,'#169','[]','{\"conversation_id\":57}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236774,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57','[]','{\"last_direction\":\"out\",\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Guest Tester, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered...\",\"last_message_at\":\"2026-06-26 18:06:48\"}','[\"last_direction\",\"last_message_excerpt\",\"last_message_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:48','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236775,NULL,10,'create','App\\Contact',6104,'Guest Tester',NULL,'{\"business_id\":10,\"name\":\"Guest Tester\",\"mobile\":\"+201096395880\",\"email\":null,\"type\":\"customer\",\"contact_status\":\"active\",\"created_by\":195,\"id\":6104}','[\"business_id\",\"name\",\"mobile\",\"email\",\"type\",\"contact_status\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236776,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',170,'#170',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":62,\"wa_id\":\"201096395880\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, TestyPet!*\\n\\nHi Guest Tester, *TestyPet* has been added to your profile at VET One.\\n\\nWe\'ll help you keep TestyPet healthy with timely checkups, vaccinations and reminders.\\nReply anytime to book a visit. \\ud83d\\udc9a\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"pet_welcome\",\"dedupe_key\":\"pet_welcome:84\",\"available_at\":\"2026-06-26 18:06:49\",\"created_by\":null,\"id\":170}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236777,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',170,'#170','[]','{\"conversation_id\":57}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236778,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57','{\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Guest Tester, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered...\",\"last_message_at\":\"2026-06-26T15:06:48.000000Z\"}','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, TestyPet!*\\n\\nHi Guest Tester, *TestyPet* has been added to your profile at VET One.\\n\\nWe\'ll help you keep TestyPet healthy with timely checkups, vaccinations and remin...\",\"last_message_at\":\"2026-06-26 18:06:49\"}','[\"last_message_excerpt\",\"last_message_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236779,NULL,10,'create','Modules\\VetClinic\\Entities\\VcPet',84,'#84',NULL,'{\"business_id\":10,\"contact_id\":6104,\"petname\":\"TestyPet\",\"species\":\"Dog\",\"status\":\"active\",\"id\":84}','[\"business_id\",\"contact_id\",\"petname\",\"species\",\"status\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236780,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',171,'#171',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":62,\"wa_id\":\"201096395880\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Guest Tester, the appointment for *TestyPet* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sat, 27 Jun 2026\\n\\u23f0 *Time:* 10:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-92931A\\n\\nPlease arrive 10 minutes early. Reply to reschedule or cancel.\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"appointment_booked\",\"dedupe_key\":\"appt_booked:98\",\"available_at\":\"2026-06-26 18:06:49\",\"created_by\":null,\"id\":171}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236781,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',171,'#171','[]','{\"conversation_id\":57}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236782,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, TestyPet!*\\n\\nHi Guest Tester, *TestyPet* has been added to your profile at VET One.\\n\\nWe\'ll help you keep TestyPet healthy with timely checkups, vaccinations and remin...\"}','{\"last_message_excerpt\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Guest Tester, the appointment for *TestyPet* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sat, 27 Jun 2026\\n\\u23f0 *Time:* 10:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-92931A...\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236783,NULL,10,'create','Modules\\VetClinic\\Entities\\VcAppointment',98,'APT-92931A',NULL,'{\"business_id\":10,\"contact_id\":6104,\"pet_id\":84,\"doctor_id\":null,\"ref_no\":\"APT-92931A\",\"appointment_date\":\"2026-06-27 00:00:00\",\"appointment_time\":\"10:30:00\",\"duration_minutes\":30,\"status\":\"pending\",\"reason\":\"Checkup\",\"notes\":\"[Online booking request via the public portal]\",\"id\":98}','[\"business_id\",\"contact_id\",\"pet_id\",\"doctor_id\",\"ref_no\",\"appointment_date\",\"appointment_time\",\"duration_minutes\",\"status\",\"reason\",\"notes\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236784,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',172,'#172',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":62,\"wa_id\":\"201096395880\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Guest Tester, the appointment for *TestyPet* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sat, 27 Jun 2026\\n\\u23f0 *Time:* 11:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-9460C4\\n\\nPlease arrive 10 minutes early. Reply to reschedule or cancel.\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"appointment_booked\",\"dedupe_key\":\"appt_booked:99\",\"available_at\":\"2026-06-26 18:06:49\",\"created_by\":null,\"id\":172}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236785,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',172,'#172','[]','{\"conversation_id\":57}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236786,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',57,'#57','{\"last_message_excerpt\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Guest Tester, the appointment for *TestyPet* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sat, 27 Jun 2026\\n\\u23f0 *Time:* 10:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-92931A...\"}','{\"last_message_excerpt\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Guest Tester, the appointment for *TestyPet* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sat, 27 Jun 2026\\n\\u23f0 *Time:* 11:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-9460C4...\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236787,NULL,10,'create','Modules\\VetClinic\\Entities\\VcAppointment',99,'APT-9460C4',NULL,'{\"business_id\":10,\"contact_id\":6104,\"pet_id\":84,\"doctor_id\":null,\"ref_no\":\"APT-9460C4\",\"appointment_date\":\"2026-06-27 00:00:00\",\"appointment_time\":\"11:30:00\",\"duration_minutes\":30,\"status\":\"pending\",\"reason\":null,\"notes\":\"[Online booking request via the public portal]\",\"id\":99}','[\"business_id\",\"contact_id\",\"pet_id\",\"doctor_id\",\"ref_no\",\"appointment_date\",\"appointment_time\",\"duration_minutes\",\"status\",\"reason\",\"notes\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236788,NULL,10,'update','Modules\\PortalApi\\Entities\\PortalBrand',2,'Guest Test Clinic','{\"public_booking\":true}','{\"public_booking\":false}','[\"public_booking\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 15:06:49','50b38d4f-c84a-4081-b857-6858773fe3e2',0),(236789,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-26 18:19:27',NULL,1),(236790,NULL,10,'create','Modules\\PortalApi\\Entities\\PortalBrand',3,'OTP Test',NULL,'{\"business_id\":10,\"slug\":\"otptestb33fb\",\"name\":\"OTP Test\",\"is_active\":true,\"public_booking\":true,\"booking_otp\":true,\"login_methods\":\"[\\\"otp\\\"]\",\"id\":3}','[\"business_id\",\"slug\",\"name\",\"is_active\",\"public_booking\",\"booking_otp\",\"login_methods\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:10:14','fb4493ab-df46-41bb-a07c-10495c044929',1),(236791,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',55,'#55df96c4-0ab6-48d5-86c9-bdf36b4d2911',NULL,'{\"id\":\"55df96c4-0ab6-48d5-86c9-bdf36b4d2911\",\"owner_id\":null,\"phone\":\"+201086386340\",\"code_hash\":\"$2y$10$HpyUYjMSD43EyRLzQ\\/xlQO2tFvLfsylihlLH8vlvmEtJqa\\/2bfa46\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:20:15\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:10:15','fb4493ab-df46-41bb-a07c-10495c044929',0),(236792,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',55,'#55df96c4-0ab6-48d5-86c9-bdf36b4d2911','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:10:15','fb4493ab-df46-41bb-a07c-10495c044929',0),(236793,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',54,'#54b32bb0-4f04-4d7f-9652-1d0f7e3cd40c',NULL,'{\"id\":\"54b32bb0-4f04-4d7f-9652-1d0f7e3cd40c\",\"owner_id\":null,\"phone\":\"+201080000001\",\"code_hash\":\"$2y$10$pgcx5uLCl98.yK2V4lurPOq8SX3wh3nRggPfC7.6fcrTEoSlfi.ka\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:21:42\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:11:42','81533fe2-746d-4420-a0e5-4b5826e5158e',1),(236794,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#f5f8cad3-35ce-41fb-8879-22197663123c',NULL,'{\"id\":\"f5f8cad3-35ce-41fb-8879-22197663123c\",\"owner_id\":null,\"phone\":\"+201080000002\",\"code_hash\":\"$2y$10$.70lX1APlaPnlrRiwZxkdug2AUvmxqV\\/OWL2vgisRFqJ08HwUvhOq\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:22:36\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:12:36','30cf2cce-5a77-4fa6-9e04-d2c71edb9ea3',1),(236795,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#f5f8cad3-35ce-41fb-8879-22197663123c','{\"used_at\":null}','{\"used_at\":\"2026-06-27 01:12:36\"}','[\"used_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:12:36','30cf2cce-5a77-4fa6-9e04-d2c71edb9ea3',0),(236796,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#c762e7ab-377b-451a-88da-1c53753d7802',NULL,'{\"id\":\"c762e7ab-377b-451a-88da-1c53753d7802\",\"owner_id\":null,\"phone\":\"+201080000003\",\"code_hash\":\"$2y$10$cDy0GVjiLU0buM6wbaUHy.ZbTM5eW9dJTsPtrkUTmyUU2E.odB2Sa\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:23:32\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:13:33','a1270463-3960-4124-a867-b29f8c08ddb3',1),(236797,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#c762e7ab-377b-451a-88da-1c53753d7802','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:13:33','a1270463-3960-4124-a867-b29f8c08ddb3',0),(236798,NULL,10,'create','Modules\\PortalApi\\Entities\\PortalBrand',4,'R',NULL,'{\"business_id\":10,\"slug\":\"otpr1e0af\",\"name\":\"R\",\"is_active\":true,\"public_booking\":true,\"booking_otp\":true,\"login_methods\":\"[\\\"otp\\\"]\",\"id\":4}','[\"business_id\",\"slug\",\"name\",\"is_active\",\"public_booking\",\"booking_otp\",\"login_methods\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:13:33','a1270463-3960-4124-a867-b29f8c08ddb3',0),(236799,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#df0c9e22-8ec9-4e09-b4fc-ac2931a1273d',NULL,'{\"id\":\"df0c9e22-8ec9-4e09-b4fc-ac2931a1273d\",\"owner_id\":null,\"phone\":\"+201080000005\",\"code_hash\":\"$2y$10$IQTnzLQr5wzz0J2iReHhi.zC3TNJSo8DyFWBqdyPEfilJ5Z5shBV.\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:24:17\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:14:17','53f75e20-54ac-4312-aad7-ec0e62867d4c',1),(236800,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',0,'#df0c9e22-8ec9-4e09-b4fc-ac2931a1273d','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:14:17','53f75e20-54ac-4312-aad7-ec0e62867d4c',0),(236801,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',639,'#639c66fc-8859-4622-9b5f-203ad6ff772d',NULL,'{\"id\":\"639c66fc-8859-4622-9b5f-203ad6ff772d\",\"owner_id\":null,\"phone\":\"+201080000006\",\"code_hash\":\"$2y$10$x.Oc8pivIb1oWv9.indfzeFR5j1ofr8vHl7wJJbzaopkE\\/.2AMnk2\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:25:30\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:15:30','f54ee7a8-7788-4db6-8257-0994c6744693',1),(236802,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',6,'#6fba7ef6-8d14-4674-8e4a-040409522647',NULL,'{\"id\":\"6fba7ef6-8d14-4674-8e4a-040409522647\",\"owner_id\":null,\"phone\":\"+201080000007\",\"code_hash\":\"$2y$10$bOrnTH4fti4Q3Ys3CDtWW.tb1yrSJpWDKggEA6ex2IAGp.kFBmZwS\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:26:15\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:16:15','24d3fab8-0a28-47e1-9583-02ac64b4b215',1),(236803,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',6,'#6fba7ef6-8d14-4674-8e4a-040409522647','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:16:15','24d3fab8-0a28-47e1-9583-02ac64b4b215',0),(236804,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',8,'#8d77f81e-f975-465b-b651-6a526b00e504',NULL,'{\"id\":\"8d77f81e-f975-465b-b651-6a526b00e504\",\"owner_id\":null,\"phone\":\"+201080000008\",\"code_hash\":\"$2y$10$SKlKn9.p7nFa.jIGijT0reCM5pg.QM0kVsQpjW9o1KuRZ0JikTEzW\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:26:51\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:16:51','31ce4808-a13d-41ee-9cc3-0d40a1182f91',1),(236805,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',8,'#8d77f81e-f975-465b-b651-6a526b00e504','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:16:51','31ce4808-a13d-41ee-9cc3-0d40a1182f91',0),(236806,NULL,10,'create','Modules\\PortalApi\\Entities\\PortalBrand',6,'OTP2 Test',NULL,'{\"business_id\":10,\"slug\":\"otp29833f\",\"name\":\"OTP2 Test\",\"is_active\":true,\"public_booking\":true,\"booking_otp\":true,\"login_methods\":\"[\\\"otp\\\"]\",\"id\":6}','[\"business_id\",\"slug\",\"name\",\"is_active\",\"public_booking\",\"booking_otp\",\"login_methods\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',1),(236807,NULL,NULL,'create','Modules\\PortalApi\\Entities\\PortalOtpChallenge',6,'#6fb1fafb-2ea4-4b64-a277-305397306f58',NULL,'{\"id\":\"6fb1fafb-2ea4-4b64-a277-305397306f58\",\"owner_id\":null,\"phone\":\"+201082630698\",\"code_hash\":\"$2y$10$0gc.griwRkjOk12z145QrOF7KZf\\/Rv8eFF11xoyIXk27Lp1RZ47f2\",\"attempts\":0,\"expires_at\":\"2026-06-27 01:29:50\"}','[\"id\",\"owner_id\",\"phone\",\"code_hash\",\"attempts\",\"expires_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236808,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',6,'#6fb1fafb-2ea4-4b64-a277-305397306f58','{\"attempts\":0}','{\"attempts\":1}','[\"attempts\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236809,NULL,NULL,'update','Modules\\PortalApi\\Entities\\PortalOtpChallenge',6,'#6fb1fafb-2ea4-4b64-a277-305397306f58','{\"used_at\":null}','{\"used_at\":\"2026-06-27 01:19:50\"}','[\"used_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236810,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaContact',63,'#63',NULL,'{\"business_id\":10,\"wa_id\":\"201082630698\",\"id\":63}','[\"business_id\",\"wa_id\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236811,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',173,'#173',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":63,\"wa_id\":\"201082630698\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi OTP2, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"contact_welcome\",\"dedupe_key\":\"contact_welcome:6105\",\"available_at\":\"2026-06-27 01:19:50\",\"created_by\":null,\"id\":173}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:50','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236812,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaConversation',58,'#58',NULL,'{\"business_id\":10,\"channel_id\":null,\"wa_id\":\"201082630698\",\"status\":\"open\",\"ai_enabled\":true,\"id\":58}','[\"business_id\",\"channel_id\",\"wa_id\",\"status\",\"ai_enabled\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236813,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',58,'#58','[]','{\"contact_id\":63}','[\"contact_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236814,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',173,'#173','[]','{\"conversation_id\":58}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236815,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',58,'#58','[]','{\"last_direction\":\"out\",\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi OTP2, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by TPS_\",\"last_message_at\":\"2026-06-27 01:19:51\"}','[\"last_direction\",\"last_message_excerpt\",\"last_message_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236816,NULL,10,'create','App\\Contact',6105,'OTP2',NULL,'{\"business_id\":10,\"name\":\"OTP2\",\"mobile\":\"+201082630698\",\"email\":null,\"type\":\"customer\",\"contact_status\":\"active\",\"created_by\":195,\"id\":6105}','[\"business_id\",\"name\",\"mobile\",\"email\",\"type\",\"contact_status\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236817,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',174,'#174',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":63,\"wa_id\":\"201082630698\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, P2!*\\n\\nHi OTP2, *P2* has been added to your profile at VET One.\\n\\nWe\'ll help you keep P2 healthy with timely checkups, vaccinations and reminders.\\nReply anytime to book a visit. \\ud83d\\udc9a\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"pet_welcome\",\"dedupe_key\":\"pet_welcome:85\",\"available_at\":\"2026-06-27 01:19:51\",\"created_by\":null,\"id\":174}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236818,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',174,'#174','[]','{\"conversation_id\":58}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236819,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',58,'#58','{\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi OTP2, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by TPS_\"}','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, P2!*\\n\\nHi OTP2, *P2* has been added to your profile at VET One.\\n\\nWe\'ll help you keep P2 healthy with timely checkups, vaccinations and reminders.\\nReply anytime to boo...\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236820,NULL,10,'create','Modules\\VetClinic\\Entities\\VcPet',85,'#85',NULL,'{\"business_id\":10,\"contact_id\":6105,\"petname\":\"P2\",\"species\":\"Dog\",\"status\":\"active\",\"id\":85}','[\"business_id\",\"contact_id\",\"petname\",\"species\",\"status\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236821,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',175,'#175',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":63,\"wa_id\":\"201082630698\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi OTP2, the appointment for *P2* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sun, 28 Jun 2026\\n\\u23f0 *Time:* 09:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-72CB92\\n\\nPlease arrive 10 minutes early. Reply to reschedule or cancel.\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"appointment_booked\",\"dedupe_key\":\"appt_booked:100\",\"available_at\":\"2026-06-27 01:19:51\",\"created_by\":null,\"id\":175}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236822,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',175,'#175','[]','{\"conversation_id\":58}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236823,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',58,'#58','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, P2!*\\n\\nHi OTP2, *P2* has been added to your profile at VET One.\\n\\nWe\'ll help you keep P2 healthy with timely checkups, vaccinations and reminders.\\nReply anytime to boo...\"}','{\"last_message_excerpt\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi OTP2, the appointment for *P2* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sun, 28 Jun 2026\\n\\u23f0 *Time:* 09:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-72CB92\\n\\nPlease arrive...\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236824,NULL,10,'create','Modules\\VetClinic\\Entities\\VcAppointment',100,'APT-72CB92',NULL,'{\"business_id\":10,\"contact_id\":6105,\"pet_id\":85,\"doctor_id\":null,\"ref_no\":\"APT-72CB92\",\"appointment_date\":\"2026-06-28 00:00:00\",\"appointment_time\":\"09:30:00\",\"duration_minutes\":30,\"status\":\"pending\",\"reason\":null,\"notes\":\"[Online booking request via the public portal]\",\"id\":100}','[\"business_id\",\"contact_id\",\"pet_id\",\"doctor_id\",\"ref_no\",\"appointment_date\",\"appointment_time\",\"duration_minutes\",\"status\",\"reason\",\"notes\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 22:19:51','40d0d896-d46b-4caf-93d0-3a4b0baa9f3e',0),(236825,NULL,10,'create','Modules\\PortalApi\\Entities\\PortalBrand',7,'Drv Test',NULL,'{\"business_id\":10,\"slug\":\"drvtesteee97\",\"name\":\"Drv Test\",\"is_active\":true,\"public_booking\":true,\"booking_otp\":false,\"login_methods\":\"[\\\"otp\\\"]\",\"id\":7}','[\"business_id\",\"slug\",\"name\",\"is_active\",\"public_booking\",\"booking_otp\",\"login_methods\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',1),(236826,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaContact',64,'#64',NULL,'{\"business_id\":10,\"wa_id\":\"201090631049\",\"id\":64}','[\"business_id\",\"wa_id\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236827,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',176,'#176',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":64,\"wa_id\":\"201090631049\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Drv Owner, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"contact_welcome\",\"dedupe_key\":\"contact_welcome:6106\",\"available_at\":\"2026-06-27 02:52:37\",\"created_by\":null,\"id\":176}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236828,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaConversation',59,'#59',NULL,'{\"business_id\":10,\"channel_id\":null,\"wa_id\":\"201090631049\",\"status\":\"open\",\"ai_enabled\":true,\"id\":59}','[\"business_id\",\"channel_id\",\"wa_id\",\"status\",\"ai_enabled\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236829,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',59,'#59','[]','{\"contact_id\":64}','[\"contact_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236830,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',176,'#176','[]','{\"conversation_id\":59}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236831,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',59,'#59','[]','{\"last_direction\":\"out\",\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Drv Owner, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by...\",\"last_message_at\":\"2026-06-27 02:52:37\"}','[\"last_direction\",\"last_message_excerpt\",\"last_message_at\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236832,NULL,10,'create','App\\Contact',6106,'Drv Owner',NULL,'{\"business_id\":10,\"name\":\"Drv Owner\",\"mobile\":\"+201090631049\",\"email\":null,\"type\":\"customer\",\"contact_status\":\"active\",\"created_by\":195,\"id\":6106}','[\"business_id\",\"name\",\"mobile\",\"email\",\"type\",\"contact_status\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236833,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',177,'#177',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":64,\"wa_id\":\"201090631049\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, DrvSubj!*\\n\\nHi Drv Owner, *DrvSubj* has been added to your profile at VET One.\\n\\nWe\'ll help you keep DrvSubj healthy with timely checkups, vaccinations and reminders.\\nReply anytime to book a visit. \\ud83d\\udc9a\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"pet_welcome\",\"dedupe_key\":\"pet_welcome:86\",\"available_at\":\"2026-06-27 02:52:37\",\"created_by\":null,\"id\":177}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236834,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',177,'#177','[]','{\"conversation_id\":59}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236835,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',59,'#59','{\"last_message_excerpt\":\"\\ud83d\\udc4b *Welcome to VET One!*\\n\\nHi Drv Owner, thank you for joining us. We\'re glad to have you!\\n\\nYou can reach us anytime by replying to this message. We\'re here to help. \\ud83d\\ude4c\\n\\n_Powered by...\"}','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, DrvSubj!*\\n\\nHi Drv Owner, *DrvSubj* has been added to your profile at VET One.\\n\\nWe\'ll help you keep DrvSubj healthy with timely checkups, vaccinations and reminders....\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236836,NULL,10,'create','Modules\\VetClinic\\Entities\\VcPet',86,'#86',NULL,'{\"business_id\":10,\"contact_id\":6106,\"petname\":\"DrvSubj\",\"species\":\"Dog\",\"status\":\"active\",\"id\":86}','[\"business_id\",\"contact_id\",\"petname\",\"species\",\"status\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236837,NULL,10,'create','Modules\\WhatsApp\\Entities\\WaMessage',178,'#178',NULL,'{\"business_id\":10,\"channel_id\":null,\"contact_id\":64,\"wa_id\":\"201090631049\",\"direction\":\"out\",\"type\":\"text\",\"template_id\":null,\"body\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Drv Owner, the appointment for *DrvSubj* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sun, 28 Jun 2026\\n\\u23f0 *Time:* 09:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-57CF9B\\n\\nPlease arrive 10 minutes early. Reply to reschedule or cancel.\\n\\n_Powered by TPS_\",\"payload\":\"{\\\"preview_url\\\":false}\",\"status\":\"pending\",\"source\":\"appointment_booked\",\"dedupe_key\":\"appt_booked:101\",\"available_at\":\"2026-06-27 02:52:37\",\"created_by\":null,\"id\":178}','[\"business_id\",\"channel_id\",\"contact_id\",\"wa_id\",\"direction\",\"type\",\"template_id\",\"body\",\"payload\",\"status\",\"source\",\"dedupe_key\",\"available_at\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236838,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaMessage',178,'#178','[]','{\"conversation_id\":59}','[\"conversation_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236839,NULL,10,'update','Modules\\WhatsApp\\Entities\\WaConversation',59,'#59','{\"last_message_excerpt\":\"\\ud83c\\udf89\\ud83d\\udc3e *Welcome, DrvSubj!*\\n\\nHi Drv Owner, *DrvSubj* has been added to your profile at VET One.\\n\\nWe\'ll help you keep DrvSubj healthy with timely checkups, vaccinations and reminders....\"}','{\"last_message_excerpt\":\"\\ud83d\\udcc5 *Appointment confirmed* \\u2014 VET One\\n\\nHi Drv Owner, the appointment for *DrvSubj* is booked:\\n\\n\\ud83d\\uddd3 *Date:* Sun, 28 Jun 2026\\n\\u23f0 *Time:* 09:30\\n\\ud83d\\udc68\\u200d\\u2695\\ufe0f *Doctor:* \\n\\ud83d\\udccd \\nRef: APT-57CF9B\\n\\nPlea...\"}','[\"last_message_excerpt\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236840,NULL,10,'create','Modules\\VetClinic\\Entities\\VcAppointment',101,'APT-57CF9B',NULL,'{\"business_id\":10,\"contact_id\":6106,\"pet_id\":86,\"doctor_id\":null,\"ref_no\":\"APT-57CF9B\",\"appointment_date\":\"2026-06-28 00:00:00\",\"appointment_time\":\"09:30:00\",\"duration_minutes\":30,\"status\":\"pending\",\"reason\":\"Test\",\"notes\":\"[Online booking request via the public portal]\",\"id\":101}','[\"business_id\",\"contact_id\",\"pet_id\",\"doctor_id\",\"ref_no\",\"appointment_date\",\"appointment_time\",\"duration_minutes\",\"status\",\"reason\",\"notes\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-06-26 23:52:37','5be90305-8715-4dda-9fea-a08776a4ca9e',0),(236841,201,10,'login','auth',201,'Demo Admin',NULL,NULL,'[]','https://localhost/saas-one/public/demo/vet/login/admin','GET','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-06-28 03:02:04',NULL,1),(236842,NULL,NULL,'create','App\\User',202,'Test Owner',NULL,'{\"surname\":\"\",\"first_name\":\"Test\",\"last_name\":\"Owner\",\"username\":\"happy-paws-1783662055-admin\",\"email\":\"owner1783662055@vetone.local\",\"language\":\"en\",\"id\":202}','[\"surname\",\"first_name\",\"last_name\",\"username\",\"email\",\"language\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',1),(236843,NULL,NULL,'create','App\\Business',11,'Happy Paws Test 1783662055',NULL,'{\"name\":\"Happy Paws Test 1783662055\",\"currency_id\":35,\"time_zone\":\"Africa\\/Cairo\",\"fy_start_month\":1,\"accounting_method\":\"fifo\",\"owner_id\":202,\"start_date\":\"2026-07-10\",\"enabled_modules\":\"[\\\"purchases\\\",\\\"add_sale\\\",\\\"pos_sale\\\",\\\"stock_transfers\\\",\\\"stock_adjustment\\\",\\\"expenses\\\"]\",\"sell_price_tax\":\"includes\",\"default_profit_percent\":25,\"keyboard_shortcuts\":\"{\\\"pos\\\":{\\\"express_checkout\\\":\\\"shift+e\\\",\\\"pay_n_ckeckout\\\":\\\"shift+p\\\",\\\"draft\\\":\\\"shift+d\\\",\\\"cancel\\\":\\\"shift+c\\\",\\\"edit_discount\\\":\\\"shift+i\\\",\\\"edit_order_tax\\\":\\\"shift+t\\\",\\\"add_payment_row\\\":\\\"shift+r\\\",\\\"finalize_payment\\\":\\\"shift+f\\\",\\\"recent_product_quantity\\\":\\\"f2\\\",\\\"add_new_product\\\":\\\"f4\\\"}}\",\"ref_no_prefixes\":\"{\\\"purchase\\\":\\\"PO\\\",\\\"stock_transfer\\\":\\\"ST\\\",\\\"stock_adjustment\\\":\\\"SA\\\",\\\"sell_return\\\":\\\"CN\\\",\\\"expense\\\":\\\"EP\\\",\\\"contacts\\\":\\\"CO\\\",\\\"purchase_payment\\\":\\\"PP\\\",\\\"sell_payment\\\":\\\"SP\\\",\\\"business_location\\\":\\\"BL\\\"}\",\"enable_inline_tax\":0,\"id\":11}','[\"name\",\"currency_id\",\"time_zone\",\"fy_start_month\",\"accounting_method\",\"owner_id\",\"start_date\",\"enabled_modules\",\"sell_price_tax\",\"default_profit_percent\",\"keyboard_shortcuts\",\"ref_no_prefixes\",\"enable_inline_tax\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236844,NULL,11,'update','App\\User',202,'Test Owner','[]','{\"business_id\":11}','[\"business_id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236845,NULL,11,'create','App\\ReferenceCount',40,'#40',NULL,'{\"ref_type\":\"contacts\",\"business_id\":11,\"ref_count\":1,\"id\":40}','[\"ref_type\",\"business_id\",\"ref_count\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236846,NULL,11,'create','App\\Contact',6107,'Walk-In Customer',NULL,'{\"business_id\":11,\"type\":\"customer\",\"name\":\"Walk-In Customer\",\"created_by\":202,\"is_default\":1,\"contact_id\":\"CO0001\",\"credit_limit\":0,\"id\":6107}','[\"business_id\",\"type\",\"name\",\"created_by\",\"is_default\",\"contact_id\",\"credit_limit\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236847,NULL,11,'create','App\\InvoiceScheme',13,'Default',NULL,'{\"name\":\"Default\",\"scheme_type\":\"blank\",\"prefix\":\"\",\"start_number\":1,\"total_digits\":4,\"is_default\":1,\"business_id\":11,\"id\":13}','[\"name\",\"scheme_type\",\"prefix\",\"start_number\",\"total_digits\",\"is_default\",\"business_id\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236848,NULL,11,'create','App\\InvoiceLayout',13,'Default',NULL,'{\"name\":\"Default\",\"header_text\":null,\"invoice_no_prefix\":\"Invoice No.\",\"invoice_heading\":\"Invoice\",\"sub_total_label\":\"Subtotal\",\"discount_label\":\"Discount\",\"tax_label\":\"Tax\",\"total_label\":\"Total\",\"show_landmark\":1,\"show_city\":1,\"show_state\":1,\"show_zip_code\":1,\"show_country\":1,\"highlight_color\":\"#000000\",\"footer_text\":\"\",\"is_default\":1,\"business_id\":11,\"invoice_heading_not_paid\":\"\",\"invoice_heading_paid\":\"\",\"total_due_label\":\"Total Due\",\"paid_label\":\"Total Paid\",\"show_payments\":1,\"show_customer\":1,\"customer_label\":\"Customer\",\"table_product_label\":\"Product\",\"table_qty_label\":\"Quantity\",\"table_unit_price_label\":\"Unit Price\",\"table_subtotal_label\":\"Subtotal\",\"date_label\":\"Date\",\"id\":13}','[\"name\",\"header_text\",\"invoice_no_prefix\",\"invoice_heading\",\"sub_total_label\",\"discount_label\",\"tax_label\",\"total_label\",\"show_landmark\",\"show_city\",\"show_state\",\"show_zip_code\",\"show_country\",\"highlight_color\",\"footer_text\",\"is_default\",\"business_id\",\"invoice_heading_not_paid\",\"invoice_heading_paid\",\"total_due_label\",\"paid_label\",\"show_payments\",\"show_customer\",\"customer_label\",\"table_product_label\",\"table_qty_label\",\"table_unit_price_label\",\"table_subtotal_label\",\"date_label\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236849,NULL,11,'create','App\\Unit',11,'#11',NULL,'{\"business_id\":11,\"actual_name\":\"Pieces\",\"short_name\":\"Pc(s)\",\"allow_decimal\":0,\"created_by\":202,\"id\":11}','[\"business_id\",\"actual_name\",\"short_name\",\"allow_decimal\",\"created_by\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236850,NULL,11,'create','App\\NotificationTemplate',100,'#100',NULL,'{\"business_id\":11,\"template_for\":\"new_sale\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your invoice number is {invoice_number}<br \\/>\\r\\n                    Total amount: {total_amount}<br \\/>\\r\\n                    Paid amount: {received_amount}<\\/p>\\r\\n\\r\\n                    <p>Thank you for shopping with us.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\\r\\n\\r\\n                    <p>&nbsp;<\\/p>\",\"sms_body\":\"Dear {contact_name}, Thank you for shopping with us. {business_name}\",\"subject\":\"Thank you from {business_name}\",\"auto_send\":\"0\",\"id\":100}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236851,NULL,11,'create','App\\NotificationTemplate',101,'#101',NULL,'{\"business_id\":11,\"template_for\":\"payment_received\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                <p>We have received a payment of {received_amount}<\\/p>\\r\\n\\r\\n                <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, We have received a payment of {received_amount}. {business_name}\",\"subject\":\"Payment Received, from {business_name}\",\"auto_send\":\"0\",\"id\":101}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236852,NULL,11,'create','App\\NotificationTemplate',102,'#102',NULL,'{\"business_id\":11,\"template_for\":\"payment_reminder\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>This is to remind you that you have pending payment of {due_amount}. Kindly pay it as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, You have pending payment of {due_amount}. Kindly pay it as soon as possible. {business_name}\",\"subject\":\"Payment Reminder, from {business_name}\",\"auto_send\":\"0\",\"id\":102}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236853,NULL,11,'create','App\\NotificationTemplate',103,'#103',NULL,'{\"business_id\":11,\"template_for\":\"new_booking\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your booking is confirmed<\\/p>\\r\\n\\r\\n                    <p>Date: {start_time} to {end_time}<\\/p>\\r\\n\\r\\n                    <p>Table: {table}<\\/p>\\r\\n\\r\\n                    <p>Location: {location}<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, Your booking is confirmed. Date: {start_time} to {end_time}, Table: {table}, Location: {location}\",\"subject\":\"Booking Confirmed - {business_name}\",\"auto_send\":\"0\",\"id\":103}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236854,NULL,11,'create','App\\NotificationTemplate',104,'#104',NULL,'{\"business_id\":11,\"template_for\":\"new_order\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have a new order with reference number {order_ref_number}. Kindly process the products as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, We have a new order with reference number {order_ref_number}. Kindly process the products as soon as possible. {business_name}\",\"subject\":\"New Order, from {business_name}\",\"auto_send\":\"0\",\"id\":104}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236855,NULL,11,'create','App\\NotificationTemplate',105,'#105',NULL,'{\"business_id\":11,\"template_for\":\"payment_paid\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have paid amount {paid_amount} again invoice number {order_ref_number}.<br \\/>\\r\\n                    Kindly note it down.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"We have paid amount {paid_amount} again invoice number {order_ref_number}.\\r\\n                    Kindly note it down. {business_name}\",\"subject\":\"Payment Paid, from {business_name}\",\"auto_send\":\"0\",\"id\":105}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236856,NULL,11,'create','App\\NotificationTemplate',106,'#106',NULL,'{\"business_id\":11,\"template_for\":\"items_received\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have received all items from invoice reference number {order_ref_number}. Thank you for processing it.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"We have received all items from invoice reference number {order_ref_number}. Thank you for processing it. {business_name}\",\"subject\":\"Items received, from {business_name}\",\"auto_send\":\"0\",\"id\":106}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236857,NULL,11,'create','App\\NotificationTemplate',107,'#107',NULL,'{\"business_id\":11,\"template_for\":\"items_pending\",\"email_body\":\"<p>Dear {contact_name},<br \\/>\\r\\n                    This is to remind you that we have not yet received some items from invoice reference number {order_ref_number}. Please process it as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"This is to remind you that we have not yet received some items from invoice reference number {order_ref_number} . Please process it as soon as possible.{business_name}\",\"subject\":\"Items Pending, from {business_name}\",\"auto_send\":\"0\",\"id\":107}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236858,NULL,11,'create','App\\NotificationTemplate',108,'#108',NULL,'{\"business_id\":11,\"template_for\":\"new_quotation\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your quotation number is {invoice_number}<br \\/>\\r\\n                    Total amount: {total_amount}<\\/p>\\r\\n\\r\\n                    <p>Thank you for shopping with us.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\\r\\n\\r\\n                    <p>&nbsp;<\\/p>\",\"sms_body\":\"Dear {contact_name}, Thank you for shopping with us. {business_name}\",\"subject\":\"Thank you from {business_name}\",\"auto_send\":\"0\",\"id\":108}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236859,NULL,11,'create','App\\NotificationTemplate',109,'#109',NULL,'{\"business_id\":11,\"template_for\":\"purchase_order\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have a new purchase order with reference number {order_ref_number}. The respective invoice is attached here with.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"We have a new purchase order with reference number {order_ref_number}. {business_name}\",\"subject\":\"New Purchase Order, from {business_name}\",\"auto_send\":\"0\",\"id\":109}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236860,NULL,11,'create','App\\ReferenceCount',41,'#41',NULL,'{\"ref_type\":\"business_location\",\"business_id\":11,\"ref_count\":1,\"id\":41}','[\"ref_type\",\"business_id\",\"ref_count\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236861,NULL,11,'create','App\\BusinessLocation',34,'Main Branch',NULL,'{\"business_id\":11,\"name\":\"Main Branch\",\"landmark\":\"Nasr City\",\"city\":\"Cairo\",\"state\":\"Cairo\",\"zip_code\":\"11511\",\"country\":\"Egypt\",\"invoice_scheme_id\":13,\"invoice_layout_id\":13,\"sale_invoice_layout_id\":13,\"mobile\":\"01000000000\",\"alternate_number\":\"01000000000\",\"website\":\"\",\"email\":\"\",\"location_id\":\"BL0001\",\"default_payment_accounts\":\"{\\\"cash\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"card\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"cheque\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"bank_transfer\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"other\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_1\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_2\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_3\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_4\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_5\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_6\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_7\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null}}\",\"id\":34}','[\"business_id\",\"name\",\"landmark\",\"city\",\"state\",\"zip_code\",\"country\",\"invoice_scheme_id\",\"invoice_layout_id\",\"sale_invoice_layout_id\",\"mobile\",\"alternate_number\",\"website\",\"email\",\"location_id\",\"default_payment_accounts\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236862,NULL,11,'create','Modules\\PortalApi\\Entities\\PortalBrand',8,'Happy Paws Test 1783662055',NULL,'{\"business_id\":11,\"slug\":\"happy-paws-1783662055\",\"name\":\"Happy Paws Test 1783662055\",\"accent_hex\":\"#7c3aed\",\"logo_url\":null,\"contact_phone\":\"01000000000\",\"contact_email\":\"owner1783662055@vetone.local\",\"address\":\"Nasr City, Cairo, Cairo, Egypt\",\"login_methods\":\"[\\\"otp\\\",\\\"magic\\\",\\\"password\\\",\\\"staff\\\"]\",\"is_active\":true,\"id\":8}','[\"business_id\",\"slug\",\"name\",\"accent_hex\",\"logo_url\",\"contact_phone\",\"contact_email\",\"address\",\"login_methods\",\"is_active\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236863,NULL,11,'create','App\\User',203,'Dr. Sarah',NULL,'{\"user_type\":\"user\",\"surname\":\"Hassan\",\"first_name\":\"Dr. Sarah\",\"username\":\"demo-11-dr1\",\"email\":\"demo-11-dr1@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":203}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:55','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236864,NULL,11,'create','App\\User',204,'Dr. Ahmed',NULL,'{\"user_type\":\"user\",\"surname\":\"Fathy\",\"first_name\":\"Dr. Ahmed\",\"username\":\"demo-11-dr2\",\"email\":\"demo-11-dr2@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":204}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236865,NULL,11,'create','App\\User',205,'Dr. Mona',NULL,'{\"user_type\":\"user\",\"surname\":\"Adel\",\"first_name\":\"Dr. Mona\",\"username\":\"demo-11-dr3\",\"email\":\"demo-11-dr3@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":205}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236866,NULL,11,'create','App\\User',206,'Nurse 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Nurse 1\",\"username\":\"demo-11-nurse1\",\"email\":\"demo-11-nurse1@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":206}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236867,NULL,11,'create','App\\User',207,'Nurse 2',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Nurse 2\",\"username\":\"demo-11-nurse2\",\"email\":\"demo-11-nurse2@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":207}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236868,NULL,11,'create','App\\User',208,'Receptionist 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Receptionist 1\",\"username\":\"demo-11-receptionist1\",\"email\":\"demo-11-receptionist1@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":208}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236869,NULL,11,'create','App\\User',209,'Accounting 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Accounting 1\",\"username\":\"demo-11-accounting1\",\"email\":\"demo-11-accounting1@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":209}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236870,NULL,11,'create','App\\User',210,'HR 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"HR 1\",\"username\":\"demo-11-hr1\",\"email\":\"demo-11-hr1@demo.local\",\"language\":\"en\",\"business_id\":11,\"status\":\"active\",\"allow_login\":1,\"id\":210}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:40:56','68091577-ab2b-49f3-bee2-6b69be22bfb6',0),(236871,NULL,NULL,'create','Modules\\ActivityLog\\Entities\\ActivityIncident',1,'#1',NULL,'{\"user_id\":null,\"business_id\":null,\"route\":\"\\/\",\"method\":\"GET\",\"url\":\"https:\\/\\/localhost\\/saas-one\\/public\",\"ip\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"request_id\":\"c1a892c6-9746-45e0-8c68-ef0159debe7c\",\"type\":\"exception\",\"status_code\":500,\"message\":\"Class \\\"PaymentAccountController\\\" does not exist\",\"exception_class\":\"ReflectionException\",\"file\":\"D:\\\\xampp\\\\htdocs\\\\saas-one-vetone\\\\vendor\\\\laravel\\\\framework\\\\src\\\\Illuminate\\\\Foundation\\\\Console\\\\RouteListCommand.php\",\"line\":234,\"id\":1}','[\"user_id\",\"business_id\",\"route\",\"method\",\"url\",\"ip\",\"user_agent\",\"request_id\",\"type\",\"status_code\",\"message\",\"exception_class\",\"file\",\"line\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:42:33','41d011a4-035a-4a57-b5ce-ca0582b73c77',1),(236872,NULL,NULL,'create','Modules\\ActivityLog\\Entities\\ActivityIncident',2,'#2',NULL,'{\"user_id\":null,\"business_id\":null,\"route\":\"\\/\",\"method\":\"GET\",\"url\":\"https:\\/\\/localhost\\/saas-one\\/public\",\"ip\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"request_id\":\"54b7087f-39c8-4c21-b0c3-e5bf3465248c\",\"type\":\"exception\",\"status_code\":500,\"message\":\"Class \\\"PaymentAccountController\\\" does not exist\",\"exception_class\":\"ReflectionException\",\"file\":\"D:\\\\xampp\\\\htdocs\\\\saas-one-vetone\\\\vendor\\\\laravel\\\\framework\\\\src\\\\Illuminate\\\\Foundation\\\\Console\\\\RouteListCommand.php\",\"line\":234,\"id\":2}','[\"user_id\",\"business_id\",\"route\",\"method\",\"url\",\"ip\",\"user_agent\",\"request_id\",\"type\",\"status_code\",\"message\",\"exception_class\",\"file\",\"line\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:42:53','30151cf0-184e-4910-ad75-601ca2207af2',1),(236873,NULL,NULL,'create','Modules\\ActivityLog\\Entities\\ActivityIncident',3,'#3',NULL,'{\"user_id\":null,\"business_id\":null,\"route\":\"\\/\",\"method\":\"GET\",\"url\":\"https:\\/\\/localhost\\/saas-one\\/public\",\"ip\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"request_id\":\"ed68c83a-ae39-4300-9b2e-319d91154e44\",\"type\":\"exception\",\"status_code\":500,\"message\":\"Class \\\"PaymentAccountController\\\" does not exist\",\"exception_class\":\"ReflectionException\",\"file\":\"D:\\\\xampp\\\\htdocs\\\\saas-one-vetone\\\\vendor\\\\laravel\\\\framework\\\\src\\\\Illuminate\\\\Foundation\\\\Console\\\\RouteListCommand.php\",\"line\":234,\"id\":3}','[\"user_id\",\"business_id\",\"route\",\"method\",\"url\",\"ip\",\"user_agent\",\"request_id\",\"type\",\"status_code\",\"message\",\"exception_class\",\"file\",\"line\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:42:54','f3e36135-340b-42b7-a807-67f99b799d50',1),(236874,NULL,NULL,'create','Modules\\ActivityLog\\Entities\\ActivityIncident',4,'#4',NULL,'{\"user_id\":null,\"business_id\":null,\"route\":\"\\/\",\"method\":\"GET\",\"url\":\"https:\\/\\/localhost\\/saas-one\\/public\",\"ip\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"request_id\":\"eadd7c6e-37cf-4e1f-9a92-b9a23ff2585a\",\"type\":\"exception\",\"status_code\":500,\"message\":\"Class \\\"PaymentAccountController\\\" does not exist\",\"exception_class\":\"ReflectionException\",\"file\":\"D:\\\\xampp\\\\htdocs\\\\saas-one-vetone\\\\vendor\\\\laravel\\\\framework\\\\src\\\\Illuminate\\\\Foundation\\\\Console\\\\RouteListCommand.php\",\"line\":234,\"id\":4}','[\"user_id\",\"business_id\",\"route\",\"method\",\"url\",\"ip\",\"user_agent\",\"request_id\",\"type\",\"status_code\",\"message\",\"exception_class\",\"file\",\"line\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:42:55','1a280127-8535-465e-b7a7-747d631ecc1e',1),(236875,NULL,NULL,'create','Modules\\ActivityLog\\Entities\\ActivityIncident',5,'#5',NULL,'{\"user_id\":null,\"business_id\":null,\"route\":\"\\/\",\"method\":\"GET\",\"url\":\"https:\\/\\/localhost\\/saas-one\\/public\",\"ip\":\"127.0.0.1\",\"user_agent\":\"Symfony\",\"request_id\":\"77608720-eaeb-4fa0-a77d-1f205fc1ab2e\",\"type\":\"exception\",\"status_code\":500,\"message\":\"Class \\\"PaymentAccountController\\\" does not exist\",\"exception_class\":\"ReflectionException\",\"file\":\"D:\\\\xampp\\\\htdocs\\\\saas-one-vetone\\\\vendor\\\\laravel\\\\framework\\\\src\\\\Illuminate\\\\Foundation\\\\Console\\\\RouteListCommand.php\",\"line\":234,\"id\":5}','[\"user_id\",\"business_id\",\"route\",\"method\",\"url\",\"ip\",\"user_agent\",\"request_id\",\"type\",\"status_code\",\"message\",\"exception_class\",\"file\",\"line\",\"id\"]','https://localhost/saas-one/public','GET','127.0.0.1','Symfony','2026-07-10 05:42:56','ff24b2ce-be21-44d1-8986-2ddda105f787',1),(236876,NULL,NULL,'create','App\\User',211,'Ahmed Salah',NULL,'{\"surname\":\"\",\"first_name\":\"Ahmed\",\"last_name\":\"Salah\",\"username\":\"sunrise-vet-clinic-admin\",\"email\":\"ahmed@sunrisevet.test\",\"language\":\"en\",\"id\":211}','[\"surname\",\"first_name\",\"last_name\",\"username\",\"email\",\"language\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',1),(236877,NULL,NULL,'create','App\\Business',12,'Sunrise Vet Clinic',NULL,'{\"name\":\"Sunrise Vet Clinic\",\"currency_id\":35,\"time_zone\":\"Africa\\/Cairo\",\"fy_start_month\":1,\"accounting_method\":\"fifo\",\"owner_id\":211,\"start_date\":\"2026-07-10\",\"enabled_modules\":\"[\\\"purchases\\\",\\\"add_sale\\\",\\\"pos_sale\\\",\\\"stock_transfers\\\",\\\"stock_adjustment\\\",\\\"expenses\\\"]\",\"sell_price_tax\":\"includes\",\"default_profit_percent\":25,\"keyboard_shortcuts\":\"{\\\"pos\\\":{\\\"express_checkout\\\":\\\"shift+e\\\",\\\"pay_n_ckeckout\\\":\\\"shift+p\\\",\\\"draft\\\":\\\"shift+d\\\",\\\"cancel\\\":\\\"shift+c\\\",\\\"edit_discount\\\":\\\"shift+i\\\",\\\"edit_order_tax\\\":\\\"shift+t\\\",\\\"add_payment_row\\\":\\\"shift+r\\\",\\\"finalize_payment\\\":\\\"shift+f\\\",\\\"recent_product_quantity\\\":\\\"f2\\\",\\\"add_new_product\\\":\\\"f4\\\"}}\",\"ref_no_prefixes\":\"{\\\"purchase\\\":\\\"PO\\\",\\\"stock_transfer\\\":\\\"ST\\\",\\\"stock_adjustment\\\":\\\"SA\\\",\\\"sell_return\\\":\\\"CN\\\",\\\"expense\\\":\\\"EP\\\",\\\"contacts\\\":\\\"CO\\\",\\\"purchase_payment\\\":\\\"PP\\\",\\\"sell_payment\\\":\\\"SP\\\",\\\"business_location\\\":\\\"BL\\\"}\",\"enable_inline_tax\":0,\"id\":12}','[\"name\",\"currency_id\",\"time_zone\",\"fy_start_month\",\"accounting_method\",\"owner_id\",\"start_date\",\"enabled_modules\",\"sell_price_tax\",\"default_profit_percent\",\"keyboard_shortcuts\",\"ref_no_prefixes\",\"enable_inline_tax\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236878,NULL,12,'update','App\\User',211,'Ahmed Salah','[]','{\"business_id\":12}','[\"business_id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236879,NULL,12,'create','App\\ReferenceCount',42,'#42',NULL,'{\"ref_type\":\"contacts\",\"business_id\":12,\"ref_count\":1,\"id\":42}','[\"ref_type\",\"business_id\",\"ref_count\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236880,NULL,12,'create','App\\Contact',6110,'Walk-In Customer',NULL,'{\"business_id\":12,\"type\":\"customer\",\"name\":\"Walk-In Customer\",\"created_by\":211,\"is_default\":1,\"contact_id\":\"CO0001\",\"credit_limit\":0,\"id\":6110}','[\"business_id\",\"type\",\"name\",\"created_by\",\"is_default\",\"contact_id\",\"credit_limit\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236881,NULL,12,'create','App\\InvoiceScheme',14,'Default',NULL,'{\"name\":\"Default\",\"scheme_type\":\"blank\",\"prefix\":\"\",\"start_number\":1,\"total_digits\":4,\"is_default\":1,\"business_id\":12,\"id\":14}','[\"name\",\"scheme_type\",\"prefix\",\"start_number\",\"total_digits\",\"is_default\",\"business_id\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236882,NULL,12,'create','App\\InvoiceLayout',14,'Default',NULL,'{\"name\":\"Default\",\"header_text\":null,\"invoice_no_prefix\":\"Invoice No.\",\"invoice_heading\":\"Invoice\",\"sub_total_label\":\"Subtotal\",\"discount_label\":\"Discount\",\"tax_label\":\"Tax\",\"total_label\":\"Total\",\"show_landmark\":1,\"show_city\":1,\"show_state\":1,\"show_zip_code\":1,\"show_country\":1,\"highlight_color\":\"#000000\",\"footer_text\":\"\",\"is_default\":1,\"business_id\":12,\"invoice_heading_not_paid\":\"\",\"invoice_heading_paid\":\"\",\"total_due_label\":\"Total Due\",\"paid_label\":\"Total Paid\",\"show_payments\":1,\"show_customer\":1,\"customer_label\":\"Customer\",\"table_product_label\":\"Product\",\"table_qty_label\":\"Quantity\",\"table_unit_price_label\":\"Unit Price\",\"table_subtotal_label\":\"Subtotal\",\"date_label\":\"Date\",\"id\":14}','[\"name\",\"header_text\",\"invoice_no_prefix\",\"invoice_heading\",\"sub_total_label\",\"discount_label\",\"tax_label\",\"total_label\",\"show_landmark\",\"show_city\",\"show_state\",\"show_zip_code\",\"show_country\",\"highlight_color\",\"footer_text\",\"is_default\",\"business_id\",\"invoice_heading_not_paid\",\"invoice_heading_paid\",\"total_due_label\",\"paid_label\",\"show_payments\",\"show_customer\",\"customer_label\",\"table_product_label\",\"table_qty_label\",\"table_unit_price_label\",\"table_subtotal_label\",\"date_label\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236883,NULL,12,'create','App\\Unit',12,'#12',NULL,'{\"business_id\":12,\"actual_name\":\"Pieces\",\"short_name\":\"Pc(s)\",\"allow_decimal\":0,\"created_by\":211,\"id\":12}','[\"business_id\",\"actual_name\",\"short_name\",\"allow_decimal\",\"created_by\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236884,NULL,12,'create','App\\NotificationTemplate',110,'#110',NULL,'{\"business_id\":12,\"template_for\":\"new_sale\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your invoice number is {invoice_number}<br \\/>\\r\\n                    Total amount: {total_amount}<br \\/>\\r\\n                    Paid amount: {received_amount}<\\/p>\\r\\n\\r\\n                    <p>Thank you for shopping with us.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\\r\\n\\r\\n                    <p>&nbsp;<\\/p>\",\"sms_body\":\"Dear {contact_name}, Thank you for shopping with us. {business_name}\",\"subject\":\"Thank you from {business_name}\",\"auto_send\":\"0\",\"id\":110}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236885,NULL,12,'create','App\\NotificationTemplate',111,'#111',NULL,'{\"business_id\":12,\"template_for\":\"payment_received\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                <p>We have received a payment of {received_amount}<\\/p>\\r\\n\\r\\n                <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, We have received a payment of {received_amount}. {business_name}\",\"subject\":\"Payment Received, from {business_name}\",\"auto_send\":\"0\",\"id\":111}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236886,NULL,12,'create','App\\NotificationTemplate',112,'#112',NULL,'{\"business_id\":12,\"template_for\":\"payment_reminder\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>This is to remind you that you have pending payment of {due_amount}. Kindly pay it as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, You have pending payment of {due_amount}. Kindly pay it as soon as possible. {business_name}\",\"subject\":\"Payment Reminder, from {business_name}\",\"auto_send\":\"0\",\"id\":112}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236887,NULL,12,'create','App\\NotificationTemplate',113,'#113',NULL,'{\"business_id\":12,\"template_for\":\"new_booking\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your booking is confirmed<\\/p>\\r\\n\\r\\n                    <p>Date: {start_time} to {end_time}<\\/p>\\r\\n\\r\\n                    <p>Table: {table}<\\/p>\\r\\n\\r\\n                    <p>Location: {location}<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, Your booking is confirmed. Date: {start_time} to {end_time}, Table: {table}, Location: {location}\",\"subject\":\"Booking Confirmed - {business_name}\",\"auto_send\":\"0\",\"id\":113}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236888,NULL,12,'create','App\\NotificationTemplate',114,'#114',NULL,'{\"business_id\":12,\"template_for\":\"new_order\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have a new order with reference number {order_ref_number}. Kindly process the products as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"Dear {contact_name}, We have a new order with reference number {order_ref_number}. Kindly process the products as soon as possible. {business_name}\",\"subject\":\"New Order, from {business_name}\",\"auto_send\":\"0\",\"id\":114}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236889,NULL,12,'create','App\\NotificationTemplate',115,'#115',NULL,'{\"business_id\":12,\"template_for\":\"payment_paid\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have paid amount {paid_amount} again invoice number {order_ref_number}.<br \\/>\\r\\n                    Kindly note it down.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"We have paid amount {paid_amount} again invoice number {order_ref_number}.\\r\\n                    Kindly note it down. {business_name}\",\"subject\":\"Payment Paid, from {business_name}\",\"auto_send\":\"0\",\"id\":115}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236890,NULL,12,'create','App\\NotificationTemplate',116,'#116',NULL,'{\"business_id\":12,\"template_for\":\"items_received\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have received all items from invoice reference number {order_ref_number}. Thank you for processing it.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"We have received all items from invoice reference number {order_ref_number}. Thank you for processing it. {business_name}\",\"subject\":\"Items received, from {business_name}\",\"auto_send\":\"0\",\"id\":116}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236891,NULL,12,'create','App\\NotificationTemplate',117,'#117',NULL,'{\"business_id\":12,\"template_for\":\"items_pending\",\"email_body\":\"<p>Dear {contact_name},<br \\/>\\r\\n                    This is to remind you that we have not yet received some items from invoice reference number {order_ref_number}. Please process it as soon as possible.<\\/p>\\r\\n\\r\\n                    <p>{business_name}<br \\/>\\r\\n                    {business_logo}<\\/p>\",\"sms_body\":\"This is to remind you that we have not yet received some items from invoice reference number {order_ref_number} . Please process it as soon as possible.{business_name}\",\"subject\":\"Items Pending, from {business_name}\",\"auto_send\":\"0\",\"id\":117}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236892,NULL,12,'create','App\\NotificationTemplate',118,'#118',NULL,'{\"business_id\":12,\"template_for\":\"new_quotation\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>Your quotation number is {invoice_number}<br \\/>\\r\\n                    Total amount: {total_amount}<\\/p>\\r\\n\\r\\n                    <p>Thank you for shopping with us.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\\r\\n\\r\\n                    <p>&nbsp;<\\/p>\",\"sms_body\":\"Dear {contact_name}, Thank you for shopping with us. {business_name}\",\"subject\":\"Thank you from {business_name}\",\"auto_send\":\"0\",\"id\":118}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236893,NULL,12,'create','App\\NotificationTemplate',119,'#119',NULL,'{\"business_id\":12,\"template_for\":\"purchase_order\",\"email_body\":\"<p>Dear {contact_name},<\\/p>\\r\\n\\r\\n                    <p>We have a new purchase order with reference number {order_ref_number}. The respective invoice is attached here with.<\\/p>\\r\\n\\r\\n                    <p>{business_logo}<\\/p>\",\"sms_body\":\"We have a new purchase order with reference number {order_ref_number}. {business_name}\",\"subject\":\"New Purchase Order, from {business_name}\",\"auto_send\":\"0\",\"id\":119}','[\"business_id\",\"template_for\",\"email_body\",\"sms_body\",\"subject\",\"auto_send\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236894,NULL,12,'create','App\\ReferenceCount',43,'#43',NULL,'{\"ref_type\":\"business_location\",\"business_id\":12,\"ref_count\":1,\"id\":43}','[\"ref_type\",\"business_id\",\"ref_count\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236895,NULL,12,'create','App\\BusinessLocation',35,'Main Branch',NULL,'{\"business_id\":12,\"name\":\"Main Branch\",\"landmark\":\"12 Pyramids St\",\"city\":\"Giza\",\"state\":\"\",\"zip_code\":\"12511\",\"country\":\"Egypt\",\"invoice_scheme_id\":14,\"invoice_layout_id\":14,\"sale_invoice_layout_id\":14,\"mobile\":\"01011122233\",\"alternate_number\":\"01011122233\",\"website\":\"\",\"email\":\"\",\"location_id\":\"BL0001\",\"default_payment_accounts\":\"{\\\"cash\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"card\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"cheque\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"bank_transfer\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"other\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_1\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_2\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_3\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_4\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_5\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_6\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null},\\\"custom_pay_7\\\":{\\\"is_enabled\\\":1,\\\"account\\\":null}}\",\"id\":35}','[\"business_id\",\"name\",\"landmark\",\"city\",\"state\",\"zip_code\",\"country\",\"invoice_scheme_id\",\"invoice_layout_id\",\"sale_invoice_layout_id\",\"mobile\",\"alternate_number\",\"website\",\"email\",\"location_id\",\"default_payment_accounts\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:14','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236896,NULL,12,'create','Modules\\PortalApi\\Entities\\PortalBrand',9,'Sunrise Vet Clinic',NULL,'{\"business_id\":12,\"slug\":\"sunrise-vet-clinic\",\"name\":\"Sunrise Vet Clinic\",\"accent_hex\":\"#0d9488\",\"logo_url\":null,\"contact_phone\":\"01011122233\",\"contact_email\":\"ahmed@sunrisevet.test\",\"address\":\"12 Pyramids St, Giza, Egypt\",\"login_methods\":\"[\\\"otp\\\",\\\"magic\\\",\\\"password\\\",\\\"staff\\\"]\",\"is_active\":true,\"id\":9}','[\"business_id\",\"slug\",\"name\",\"accent_hex\",\"logo_url\",\"contact_phone\",\"contact_email\",\"address\",\"login_methods\",\"is_active\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236897,NULL,12,'create','App\\User',212,'Dr. Sarah',NULL,'{\"user_type\":\"user\",\"surname\":\"Hassan\",\"first_name\":\"Dr. Sarah\",\"username\":\"demo-12-dr1\",\"email\":\"demo-12-dr1@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":212}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236898,NULL,12,'create','App\\User',213,'Dr. Ahmed',NULL,'{\"user_type\":\"user\",\"surname\":\"Fathy\",\"first_name\":\"Dr. Ahmed\",\"username\":\"demo-12-dr2\",\"email\":\"demo-12-dr2@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":213}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236899,NULL,12,'create','App\\User',214,'Dr. Mona',NULL,'{\"user_type\":\"user\",\"surname\":\"Adel\",\"first_name\":\"Dr. Mona\",\"username\":\"demo-12-dr3\",\"email\":\"demo-12-dr3@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":214}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236900,NULL,12,'create','App\\User',215,'Nurse 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Nurse 1\",\"username\":\"demo-12-nurse1\",\"email\":\"demo-12-nurse1@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":215}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236901,NULL,12,'create','App\\User',216,'Nurse 2',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Nurse 2\",\"username\":\"demo-12-nurse2\",\"email\":\"demo-12-nurse2@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":216}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236902,NULL,12,'create','App\\User',217,'Receptionist 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Receptionist 1\",\"username\":\"demo-12-receptionist1\",\"email\":\"demo-12-receptionist1@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":217}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236903,NULL,12,'create','App\\User',218,'Accounting 1',NULL,'{\"user_type\":\"user\",\"surname\":\"Demo\",\"first_name\":\"Accounting 1\",\"username\":\"demo-12-accounting1\",\"email\":\"demo-12-accounting1@demo.local\",\"language\":\"en\",\"business_id\":12,\"status\":\"active\",\"allow_login\":1,\"id\":218}','[\"user_type\",\"surname\",\"first_name\",\"username\",\"email\",\"language\",\"business_id\",\"status\",\"allow_login\",\"id\"]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15','b75fce95-1be3-45a5-82ac-ad4c04060f13',0),(236904,211,12,'login','auth',211,'Ahmed Salah',NULL,NULL,'[]','http://127.0.0.1:8899/vetone/register','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:43:15',NULL,1),(236905,211,12,'create','Modules\\AiCore\\Entities\\AiProvider',11,'default',NULL,'{\"business_id\":12,\"name\":\"default\",\"provider\":\"openai_compatible\",\"base_url\":\"https:\\/\\/api.groq.com\\/openai\\/v1\",\"model\":\"llama-3.3-70b-versatile\",\"api_key\":\"eyJpdiI6IkxWOU5uTkx3bnF1NTNhbFdtdUVJNGc9PSIsInZhbHVlIjoiTTZCZ2h4Y3p3SGNIWXMxbWNOazcxOEJFM0M0NkwwVTdHVElNUFVlU2NHVT0iLCJtYWMiOiI4NWI0MjM5NDQ3MzNmZWI5MTVmYWJmODBhNjM3YzBiY2JjZGVhZGE1MDdmYjU4M2Q5NTM0MGU3ZDIwZTU4MjRiIiwidGFnIjoiIn0=\",\"enabled\":1,\"id\":11}','[\"business_id\",\"name\",\"provider\",\"base_url\",\"model\",\"api_key\",\"enabled\",\"id\"]','http://127.0.0.1:8899/vetone/onboarding/groq','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:44:24','8e0ff1d7-f300-4891-8a65-e0b4061a3fc9',1),(236906,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourFlow',1,'VetOne — full walkthrough',NULL,'{\"key\":\"vet-full-tour\",\"title\":\"VetOne \\u2014 full walkthrough\",\"vertical\":\"vet\",\"is_active\":true,\"autostart_once\":true,\"id\":1}','[\"key\",\"title\",\"vertical\",\"is_active\",\"autostart_once\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',1),(236907,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',1,'Welcome to VetOne 👋',NULL,'{\"flow_id\":1,\"sort_order\":0,\"route\":null,\"target_selector\":null,\"title\":\"Welcome to VetOne \\ud83d\\udc4b\",\"body_html\":\"This quick tour walks you through the whole clinic \\u2014 appointments, consultations, prescriptions, your pet-owner app and settings. You can replay it any time with the <b>\\u25b6 Tour<\\/b> button, bottom-right.\",\"media_id\":null,\"placement\":\"auto\",\"id\":1}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236908,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',2,'Your dashboard',NULL,'{\"flow_id\":1,\"sort_order\":1,\"route\":\"\\/home\",\"target_selector\":null,\"title\":\"Your dashboard\",\"body_html\":\"Everything starts here: today\'s appointments, quick stats and shortcuts to every part of the clinic.\",\"media_id\":null,\"placement\":\"auto\",\"id\":2}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236909,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',3,'Appointments &amp; doctor schedules',NULL,'{\"flow_id\":1,\"sort_order\":2,\"route\":\"\\/vet-clinic\\/appointments\",\"target_selector\":null,\"title\":\"Appointments &amp; doctor schedules\",\"body_html\":\"Book and manage appointments on the calendar. Each of your doctors has their own weekly schedule and slot length, so the grid only offers times they actually work.\",\"media_id\":null,\"placement\":\"auto\",\"id\":3}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236910,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',4,'Pets &amp; owners',NULL,'{\"flow_id\":1,\"sort_order\":3,\"route\":\"\\/vet-clinic\\/pets\",\"target_selector\":null,\"title\":\"Pets &amp; owners\",\"body_html\":\"Every pet has a full clinical history linked to its owner \\u2014 species, breed, vaccinations, weight trend and past visits.\",\"media_id\":null,\"placement\":\"auto\",\"id\":4}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236911,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',5,'The SOAP consultation',NULL,'{\"flow_id\":1,\"sort_order\":4,\"route\":null,\"target_selector\":null,\"title\":\"The SOAP consultation\",\"body_html\":\"Open an appointment to run a <b>SOAP<\\/b> consultation \\u2014 Subjective, Objective, Assessment, Plan. Chief-complaint chips, lab tests and exam panels are all pre-loaded for you.\",\"media_id\":null,\"placement\":\"auto\",\"id\":5}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236912,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',6,'AI scribe &amp; suggestions',NULL,'{\"flow_id\":1,\"sort_order\":5,\"route\":null,\"target_selector\":null,\"title\":\"AI scribe &amp; suggestions\",\"body_html\":\"Dictate your notes and the AI scribe cleans them, structures them into SOAP, extracts findings and suggests exam panels. (Add a free Groq key in AI settings to switch this on.)\",\"media_id\":null,\"placement\":\"auto\",\"id\":6}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236913,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',7,'Prescriptions &amp; medicines',NULL,'{\"flow_id\":1,\"sort_order\":6,\"route\":\"\\/vet-clinic\\/prescriptions\",\"target_selector\":null,\"title\":\"Prescriptions &amp; medicines\",\"body_html\":\"Prescribe from a ready-made veterinary formulary \\u2014 dosages, frequencies and dispensing all in one place.\",\"media_id\":null,\"placement\":\"auto\",\"id\":7}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236914,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',8,'Your pet-owner app',NULL,'{\"flow_id\":1,\"sort_order\":7,\"route\":null,\"target_selector\":null,\"title\":\"Your pet-owner app\",\"body_html\":\"Every clinic gets a branded pet-owner PWA \\u2014 your logo, your colours. Owners book appointments, see reminders and their pet\'s records from their phone.\",\"media_id\":null,\"placement\":\"auto\",\"id\":8}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236915,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',9,'WhatsApp &amp; AI setup',NULL,'{\"flow_id\":1,\"sort_order\":8,\"route\":\"\\/whatsapp\\/channels\",\"target_selector\":null,\"title\":\"WhatsApp &amp; AI setup\",\"body_html\":\"Connect a WhatsApp number by scanning a QR code to send reminders and let the AI auto-reply. Both WhatsApp and AI are optional.\",\"media_id\":null,\"placement\":\"auto\",\"id\":9}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236916,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',10,'Settings',NULL,'{\"flow_id\":1,\"sort_order\":9,\"route\":\"\\/ai-core\\/settings\",\"target_selector\":null,\"title\":\"Settings\",\"body_html\":\"Fine-tune everything here \\u2014 AI provider keys, editable AI prompts, clinic preferences and staff roles.\",\"media_id\":null,\"placement\":\"auto\",\"id\":10}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236917,NULL,NULL,'create','Modules\\GuidedTour\\Entities\\TourStep',11,'That\'s the tour! 🎉',NULL,'{\"flow_id\":1,\"sort_order\":10,\"route\":null,\"target_selector\":null,\"title\":\"That\'s the tour! \\ud83c\\udf89\",\"body_html\":\"Your demo is active for <b>48 hours<\\/b>. Explore freely \\u2014 and when you\'re ready to keep your clinic, contact TPS. Replay this tour any time from the <b>\\u25b6 Tour<\\/b> button.\",\"media_id\":null,\"placement\":\"auto\",\"id\":11}','[\"flow_id\",\"sort_order\",\"route\",\"target_selector\",\"title\",\"body_html\",\"media_id\",\"placement\",\"id\"]','http://127.0.0.1:8899','GET','127.0.0.1','Symfony','2026-07-10 06:48:43','94111cfc-a259-40cb-88e2-18a007b88a59',0),(236918,211,12,'create','Modules\\GuidedTour\\Entities\\TourProgress',1,'#1',NULL,'{\"user_id\":211,\"flow_id\":1,\"last_step\":0,\"completed_at\":null,\"id\":1}','[\"user_id\",\"flow_id\",\"last_step\",\"completed_at\",\"id\"]','http://127.0.0.1:8899/tour/progress','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:49:00','542d5cbd-78c0-4d51-afee-8389318ce5cd',1),(236919,211,12,'update','Modules\\GuidedTour\\Entities\\TourProgress',1,'#1','{\"last_step\":0}','{\"last_step\":1}','[\"last_step\"]','http://127.0.0.1:8899/tour/progress','POST','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:49:30','b7119908-7200-45f3-bffb-a9c12605c554',1),(236920,211,12,'logout','auth',211,'Ahmed Salah',NULL,NULL,'[]','http://127.0.0.1:8899/get-total-unread','GET','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','2026-07-10 06:54:03',NULL,1),(236921,211,12,'login','auth',211,'Ahmed Salah',NULL,NULL,'[]','http://127.0.0.1:8899/login','POST','127.0.0.1','curl/8.19.0','2026-07-10 06:57:45',NULL,1),(236922,211,12,'logout','auth',211,'Ahmed Salah',NULL,NULL,'[]','http://127.0.0.1:8899/home','GET','127.0.0.1','curl/8.19.0','2026-07-10 06:58:08',NULL,1);
CREATE TABLE `ent_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `hearing` varchar(40) DEFAULT NULL,
  `otoscopy` varchar(40) DEFAULT NULL,
  `audiometry` varchar(120) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ent_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `ent_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_allowances_and_deductions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `description` varchar(191) NOT NULL,
  `type` enum('allowance','deduction') NOT NULL,
  `amount` decimal(22,4) NOT NULL,
  `amount_type` enum('fixed','percent') NOT NULL,
  `applicable_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_allowances_and_deductions_business_id_index` (`business_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_attendances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `business_id` int(11) NOT NULL,
  `clock_in_time` datetime DEFAULT NULL,
  `clock_out_time` datetime DEFAULT NULL,
  `essentials_shift_id` int(11) DEFAULT NULL,
  `ip_address` varchar(191) DEFAULT NULL,
  `clock_in_note` text DEFAULT NULL,
  `clock_out_note` text DEFAULT NULL,
  `clock_in_location` text DEFAULT NULL,
  `clock_out_location` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_attendances_user_id_index` (`user_id`),
  KEY `essentials_attendances_business_id_index` (`business_id`),
  KEY `essentials_attendances_essentials_shift_id_index` (`essentials_shift_id`)
) ENGINE=InnoDB AUTO_INCREMENT=220 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_document_shares` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int(11) NOT NULL,
  `value_type` enum('user','role') NOT NULL,
  `value` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_document_shares_document_id_index` (`document_id`),
  KEY `essentials_document_shares_value_type_index` (`value_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_documents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_holidays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `business_id` int(11) NOT NULL,
  `location_id` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_holidays_business_id_index` (`business_id`),
  KEY `essentials_holidays_location_id_index` (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_kb` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` bigint(20) unsigned NOT NULL,
  `title` varchar(191) NOT NULL,
  `content` longtext DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `kb_type` varchar(191) NOT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL COMMENT 'id from essentials_kb table',
  `share_with` varchar(191) DEFAULT NULL COMMENT 'public, private, only_with',
  `created_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_kb_business_id_index` (`business_id`),
  KEY `essentials_kb_parent_id_index` (`parent_id`),
  KEY `essentials_kb_created_by_index` (`created_by`),
  CONSTRAINT `essentials_kb_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `essentials_kb` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_kb_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kb_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_kb_users_kb_id_index` (`kb_id`),
  KEY `essentials_kb_users_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_leave_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `leave_type` varchar(191) NOT NULL,
  `max_leave_count` int(11) DEFAULT NULL,
  `leave_count_interval` enum('month','year') DEFAULT NULL,
  `business_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_leave_types_business_id_index` (`business_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_leaves` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `essentials_leave_type_id` int(11) DEFAULT NULL,
  `business_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `ref_no` varchar(191) DEFAULT NULL,
  `status` enum('pending','approved','cancelled') DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `status_note` text DEFAULT NULL,
  `is_additional` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_leaves_essentials_leave_type_id_index` (`essentials_leave_type_id`),
  KEY `essentials_leaves_business_id_index` (`business_id`),
  KEY `essentials_leaves_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `location_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_messages_business_id_index` (`business_id`),
  KEY `essentials_messages_user_id_index` (`user_id`),
  KEY `essentials_messages_location_id_index` (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_payroll_group_transactions` (
  `payroll_group_id` bigint(20) unsigned NOT NULL,
  `transaction_id` int(11) NOT NULL,
  KEY `essentials_payroll_group_transactions_payroll_group_id_foreign` (`payroll_group_id`),
  CONSTRAINT `essentials_payroll_group_transactions_payroll_group_id_foreign` FOREIGN KEY (`payroll_group_id`) REFERENCES `essentials_payroll_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_payroll_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `location_id` int(11) DEFAULT NULL COMMENT 'payroll for work location',
  `name` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `payment_status` varchar(191) NOT NULL DEFAULT 'due',
  `gross_total` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_reminders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(191) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `end_time` time DEFAULT NULL,
  `repeat` enum('one_time','every_day','every_week','every_month') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_reminders_business_id_index` (`business_id`),
  KEY `essentials_reminders_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_shifts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `type` enum('fixed_shift','flexible_shift') NOT NULL DEFAULT 'fixed_shift',
  `business_id` int(11) NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `is_allowed_auto_clockout` tinyint(1) NOT NULL DEFAULT 0,
  `auto_clockout_time` time DEFAULT NULL,
  `holidays` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_shifts_type_index` (`type`),
  KEY `essentials_shifts_business_id_index` (`business_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_to_dos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `task` text NOT NULL,
  `date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `task_id` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `estimated_hours` varchar(191) DEFAULT NULL,
  `priority` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_to_dos_status_index` (`status`),
  KEY `essentials_to_dos_priority_index` (`priority`),
  KEY `essentials_to_dos_created_by_index` (`created_by`),
  KEY `essentials_to_dos_business_id_index` (`business_id`),
  KEY `essentials_to_dos_task_id_index` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_todo_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment` text NOT NULL,
  `task_id` int(11) NOT NULL,
  `comment_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_todo_comments_task_id_index` (`task_id`),
  KEY `essentials_todo_comments_comment_by_index` (`comment_by`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_todos_users` (
  `todo_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_user_allowance_and_deductions` (
  `user_id` int(11) NOT NULL,
  `allowance_deduction_id` int(11) NOT NULL,
  KEY `essentials_user_allowance_and_deductions_user_id_index` (`user_id`),
  KEY `allow_deduct_index` (`allowance_deduction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_user_sales_targets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `target_start` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `target_end` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `commission_percent` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `essentials_user_shifts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `essentials_shift_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `essentials_user_shifts_user_id_index` (`user_id`),
  KEY `essentials_user_shifts_essentials_shift_id_index` (`essentials_shift_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `expense_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `business_id` int(10) unsigned NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expense_categories_business_id_foreign` (`business_id`),
  CONSTRAINT `expense_categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `family_medicine_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `bmi` decimal(8,2) DEFAULT NULL,
  `family_history` text DEFAULT NULL,
  `risk_factors` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `family_medicine_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `family_medicine_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `gastroenterology_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `bowel_habit` varchar(40) DEFAULT NULL,
  `endoscopy_findings` text DEFAULT NULL,
  `liver_status` varchar(120) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `gastroenterology_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `gastroenterology_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `general_practice_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `bmi` decimal(8,2) DEFAULT NULL,
  `smoking` varchar(40) DEFAULT NULL,
  `alcohol` varchar(40) DEFAULT NULL,
  `risk_factors` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `general_practice_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `general_practice_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `general_surgery_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `surgical_site` varchar(120) DEFAULT NULL,
  `asa_grade` varchar(40) DEFAULT NULL,
  `planned_procedure` varchar(120) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `general_surgery_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `general_surgery_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `geriatrics_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `adl_status` varchar(40) DEFAULT NULL,
  `falls_risk` varchar(40) DEFAULT NULL,
  `cognition_score` int(11) DEFAULT NULL,
  `frailty` varchar(40) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `geriatrics_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `geriatrics_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `group_sub_taxes` (
  `group_tax_id` int(10) unsigned NOT NULL,
  `tax_id` int(10) unsigned NOT NULL,
  KEY `group_sub_taxes_group_tax_id_foreign` (`group_tax_id`),
  KEY `group_sub_taxes_tax_id_foreign` (`tax_id`),
  CONSTRAINT `group_sub_taxes_group_tax_id_foreign` FOREIGN KEY (`group_tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `group_sub_taxes_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `hematology_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `hemoglobin` decimal(8,2) DEFAULT NULL,
  `wbc` decimal(8,2) DEFAULT NULL,
  `platelets` decimal(8,2) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hematology_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `hematology_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `hepatology_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `alt` decimal(8,2) DEFAULT NULL,
  `ast` decimal(8,2) DEFAULT NULL,
  `bilirubin` decimal(8,2) DEFAULT NULL,
  `fibrosis_stage` varchar(40) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hepatology_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `hepatology_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `internal_medicine_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `bmi` decimal(8,2) DEFAULT NULL,
  `comorbidities` text DEFAULT NULL,
  `active_problems` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `internal_medicine_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `internal_medicine_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `invoice_layouts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `header_text` text DEFAULT NULL,
  `invoice_no_prefix` varchar(191) DEFAULT NULL,
  `quotation_no_prefix` varchar(191) DEFAULT NULL,
  `invoice_heading` varchar(191) DEFAULT NULL,
  `sub_heading_line1` varchar(191) DEFAULT NULL,
  `sub_heading_line2` varchar(191) DEFAULT NULL,
  `sub_heading_line3` varchar(191) DEFAULT NULL,
  `sub_heading_line4` varchar(191) DEFAULT NULL,
  `sub_heading_line5` varchar(191) DEFAULT NULL,
  `invoice_heading_not_paid` varchar(191) DEFAULT NULL,
  `invoice_heading_paid` varchar(191) DEFAULT NULL,
  `quotation_heading` varchar(191) DEFAULT NULL,
  `sub_total_label` varchar(191) DEFAULT NULL,
  `discount_label` varchar(191) DEFAULT NULL,
  `tax_label` varchar(191) DEFAULT NULL,
  `total_label` varchar(191) DEFAULT NULL,
  `round_off_label` varchar(191) DEFAULT NULL,
  `total_due_label` varchar(191) DEFAULT NULL,
  `paid_label` varchar(191) DEFAULT NULL,
  `show_client_id` tinyint(1) NOT NULL DEFAULT 0,
  `client_id_label` varchar(191) DEFAULT NULL,
  `client_tax_label` varchar(191) DEFAULT NULL,
  `date_label` varchar(191) DEFAULT NULL,
  `date_time_format` varchar(191) DEFAULT NULL,
  `show_time` tinyint(1) NOT NULL DEFAULT 1,
  `show_brand` tinyint(1) NOT NULL DEFAULT 0,
  `show_sku` tinyint(1) NOT NULL DEFAULT 1,
  `show_cat_code` tinyint(1) NOT NULL DEFAULT 1,
  `show_expiry` tinyint(1) NOT NULL DEFAULT 0,
  `show_lot` tinyint(1) NOT NULL DEFAULT 0,
  `show_image` tinyint(1) NOT NULL DEFAULT 0,
  `show_sale_description` tinyint(1) NOT NULL DEFAULT 0,
  `sales_person_label` varchar(191) DEFAULT NULL,
  `show_sales_person` tinyint(1) NOT NULL DEFAULT 0,
  `table_product_label` varchar(191) DEFAULT NULL,
  `table_qty_label` varchar(191) DEFAULT NULL,
  `table_unit_price_label` varchar(191) DEFAULT NULL,
  `table_subtotal_label` varchar(191) DEFAULT NULL,
  `cat_code_label` varchar(191) DEFAULT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `show_logo` tinyint(1) NOT NULL DEFAULT 0,
  `show_business_name` tinyint(1) NOT NULL DEFAULT 0,
  `show_location_name` tinyint(1) NOT NULL DEFAULT 1,
  `show_landmark` tinyint(1) NOT NULL DEFAULT 1,
  `show_city` tinyint(1) NOT NULL DEFAULT 1,
  `show_state` tinyint(1) NOT NULL DEFAULT 1,
  `show_zip_code` tinyint(1) NOT NULL DEFAULT 1,
  `show_country` tinyint(1) NOT NULL DEFAULT 1,
  `show_mobile_number` tinyint(1) NOT NULL DEFAULT 1,
  `show_alternate_number` tinyint(1) NOT NULL DEFAULT 0,
  `show_email` tinyint(1) NOT NULL DEFAULT 0,
  `show_tax_1` tinyint(1) NOT NULL DEFAULT 1,
  `show_tax_2` tinyint(1) NOT NULL DEFAULT 0,
  `show_barcode` tinyint(1) NOT NULL DEFAULT 0,
  `show_payments` tinyint(1) NOT NULL DEFAULT 0,
  `show_customer` tinyint(1) NOT NULL DEFAULT 0,
  `customer_label` varchar(191) DEFAULT NULL,
  `commission_agent_label` varchar(191) DEFAULT NULL,
  `show_commission_agent` tinyint(1) NOT NULL DEFAULT 0,
  `show_reward_point` tinyint(1) NOT NULL DEFAULT 0,
  `highlight_color` varchar(10) DEFAULT NULL,
  `footer_text` text DEFAULT NULL,
  `module_info` text DEFAULT NULL,
  `common_settings` text DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `business_id` int(10) unsigned NOT NULL,
  `show_letter_head` tinyint(1) NOT NULL DEFAULT 0,
  `letter_head` varchar(191) DEFAULT NULL,
  `show_qr_code` tinyint(1) NOT NULL DEFAULT 0,
  `qr_code_fields` text DEFAULT NULL,
  `design` varchar(190) DEFAULT 'classic',
  `cn_heading` varchar(191) DEFAULT NULL COMMENT 'cn = credit note',
  `cn_no_label` varchar(191) DEFAULT NULL,
  `cn_amount_label` varchar(191) DEFAULT NULL,
  `table_tax_headings` text DEFAULT NULL,
  `show_previous_bal` tinyint(1) NOT NULL DEFAULT 0,
  `prev_bal_label` varchar(191) DEFAULT NULL,
  `change_return_label` varchar(191) DEFAULT NULL,
  `product_custom_fields` text DEFAULT NULL,
  `contact_custom_fields` text DEFAULT NULL,
  `location_custom_fields` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_layouts_business_id_foreign` (`business_id`),
  CONSTRAINT `invoice_layouts_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `invoice_layouts` VALUES (7,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,5,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-15 17:18:42','2026-06-15 17:18:42'),(8,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,6,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-17 20:54:54','2026-06-17 20:54:54'),(9,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,7,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-17 20:55:44','2026-06-17 20:55:44'),(10,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,8,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-17 20:58:10','2026-06-17 20:58:10'),(11,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,9,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-17 21:00:01','2026-06-17 21:00:01'),(12,'Default',NULL,'Invoice No.',NULL,'Invoice',NULL,NULL,NULL,NULL,NULL,'','',NULL,'Subtotal','Discount','Tax','Total',NULL,'Total Due','Total Paid',0,NULL,NULL,'Date',NULL,1,0,1,1,0,0,0,0,NULL,0,'Product','Quantity','Unit Price','Subtotal',NULL,NULL,0,0,1,1,1,1,1,1,1,0,0,1,0,0,1,1,'Customer',NULL,0,0,'#000000','',NULL,NULL,1,10,0,NULL,0,NULL,'classic',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2026-06-17 21:11:53','2026-06-17 21:11:53');
CREATE TABLE `invoice_schemes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `scheme_type` enum('blank','year') NOT NULL,
  `number_type` varchar(100) NOT NULL DEFAULT 'sequential',
  `prefix` varchar(191) DEFAULT NULL,
  `start_number` int(11) DEFAULT NULL,
  `invoice_count` int(11) NOT NULL DEFAULT 0,
  `total_digits` int(11) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_schemes_business_id_foreign` (`business_id`),
  KEY `invoice_schemes_scheme_type_index` (`scheme_type`),
  KEY `invoice_schemes_number_type_index` (`number_type`),
  CONSTRAINT `invoice_schemes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `invoice_schemes` VALUES (7,5,'Default','blank','sequential','',1,0,4,1,'2026-06-15 17:18:42','2026-06-15 17:18:42'),(8,6,'Default','blank','sequential','',1,0,4,1,'2026-06-17 20:54:54','2026-06-17 20:54:54'),(9,7,'Default','blank','sequential','',1,0,4,1,'2026-06-17 20:55:44','2026-06-17 20:55:44'),(10,8,'Default','blank','sequential','',1,0,4,1,'2026-06-17 20:58:10','2026-06-17 20:58:10'),(11,9,'Default','blank','sequential','',1,0,4,1,'2026-06-17 21:00:01','2026-06-17 21:00:01'),(12,10,'Default','blank','sequential','',1,0,4,1,'2026-06-17 21:11:53','2026-06-17 21:11:53');
CREATE TABLE `ivf_patient_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `clc_patient_id` int(10) unsigned NOT NULL,
  `amh` decimal(8,2) DEFAULT NULL,
  `antral_follicles` int(11) DEFAULT NULL,
  `cycle_day` int(11) DEFAULT NULL,
  `protocol` varchar(120) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ivf_patient_profiles_clc_patient_id_unique` (`clc_patient_id`),
  CONSTRAINT `ivf_patient_profiles_clc_patient_id_foreign` FOREIGN KEY (`clc_patient_id`) REFERENCES `clc_patients` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `jobs` VALUES (21,'whatsapp','{\"uuid\":\"934e8558-04bc-4d5e-87d9-5db3da915a49\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:161;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781617739,1781617739),(22,'whatsapp','{\"uuid\":\"b980c686-807d-4b03-89f7-f9ee93504367\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:162;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781729989,1781729989),(23,'whatsapp','{\"uuid\":\"0517302b-eb0e-4243-8f78-c21759169130\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:163;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781742148,1781742148),(24,'whatsapp','{\"uuid\":\"afbf7418-8399-4598-840f-ac0c089e5597\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:164;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781817990,1781817990),(25,'whatsapp','{\"uuid\":\"5269d56b-9a26-46fd-9bb5-2c4f8f61e031\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:165;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781818366,1781818366),(26,'whatsapp','{\"uuid\":\"5da36bd5-496c-4899-943e-7427f8592f9b\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:166;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781819069,1781819069),(27,'whatsapp','{\"uuid\":\"84924bf3-8c2a-448c-8793-6240c5aeea75\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:167;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1781824048,1781824048),(28,'whatsapp','{\"uuid\":\"3fe1d844-d1db-43ba-8731-6189f41cc61c\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:168;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782255842,1782255842),(29,'whatsapp','{\"uuid\":\"52494a48-b25f-4e84-bd8c-fb1498c36f27\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:169;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782486409,1782486409),(30,'whatsapp','{\"uuid\":\"c45fa725-d9c5-4a80-a0ac-b15e1346fb09\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:170;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782486409,1782486409),(31,'whatsapp','{\"uuid\":\"96a30030-6a50-409f-8975-41690e9fcd51\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:171;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782486409,1782486409),(32,'whatsapp','{\"uuid\":\"5c811dda-4bee-420c-9b1a-bac018aa00e1\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:172;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782486409,1782486409),(33,'whatsapp','{\"uuid\":\"ac581366-82cb-46ad-b206-30abf615451d\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:173;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782512391,1782512391),(34,'whatsapp','{\"uuid\":\"e358b5c3-73dd-4c44-8954-36d2a4a94347\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:174;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782512391,1782512391),(35,'whatsapp','{\"uuid\":\"f8f3377f-b0c7-413e-8794-df8ddc964528\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:175;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782512391,1782512391),(36,'whatsapp','{\"uuid\":\"9b212c50-d6ea-40ba-a1d5-b40b419408db\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:176;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782517957,1782517957),(37,'whatsapp','{\"uuid\":\"1bc7bde0-46f7-4dd1-b3de-7a2eda85f109\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:177;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782517957,1782517957),(38,'whatsapp','{\"uuid\":\"6e9c461c-90ab-4c1c-89d3-37bb02f7cb81\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:178;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782517957,1782517957),(39,'whatsapp','{\"uuid\":\"59cce013-04dd-4bea-80bf-2acbd3010bf8\",\"displayName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":1,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":120,\"retryUntil\":null,\"data\":{\"commandName\":\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\",\"command\":\"O:41:\\\"Modules\\\\WhatsApp\\\\Jobs\\\\SendWhatsAppMessage\\\":3:{s:9:\\\"messageId\\\";i:161;s:10:\\\"connection\\\";s:11:\\\"whatsapp_db\\\";s:5:\\\"queue\\\";s:8:\\\"whatsapp\\\";}\"}}',0,NULL,1782517958,1782517958);
CREATE TABLE `lab_agents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(120) NOT NULL COMMENT 'Clinic / site label',
  `code` varchar(60) NOT NULL COMMENT 'Agent slug used by the agent at registration',
  `api_token` varchar(80) NOT NULL COMMENT 'Bearer token the agent authenticates with',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `agent_version` varchar(20) DEFAULT NULL,
  `last_ip` varchar(45) DEFAULT NULL,
  `last_heartbeat_at` timestamp NULL DEFAULT NULL,
  `queue_depth` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Unsynced items the agent last reported',
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lab_agents_code_unique` (`code`),
  UNIQUE KEY `lab_agents_api_token_unique` (`api_token`),
  KEY `lab_agents_business_id_status_index` (`business_id`,`status`),
  KEY `lab_agents_business_id_index` (`business_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_agents` VALUES (5,5,'Lab Simulator','simulator','4y1lPRO0fEghsDSmTSxEpUhi9CjqCd5bYWoaCUPDTyIJOfCgy6ToVf5BapyjFA2k','active',NULL,NULL,NULL,0,NULL,'2026-06-15 19:25:16','2026-06-15 19:25:16');
CREATE TABLE `lab_analyte_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned DEFAULT NULL COMMENT 'Null = global default',
  `vendor` varchar(30) NOT NULL,
  `model` varchar(60) DEFAULT NULL,
  `analyte_code` varchar(20) NOT NULL,
  `canonical_name` varchar(60) NOT NULL,
  `display_name` varchar(60) DEFAULT NULL,
  `unit` varchar(16) DEFAULT NULL,
  `species` varchar(40) DEFAULT NULL COMMENT 'Reference ranges are species-specific',
  `ref_lower` varchar(16) DEFAULT NULL,
  `ref_upper` varchar(16) DEFAULT NULL,
  `category` varchar(40) DEFAULT NULL COMMENT 'chemistry, hematology, electrolytes...',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_analyte_map_vendor_analyte_code_index` (`vendor`,`analyte_code`),
  KEY `lab_analyte_map_business_id_index` (`business_id`),
  KEY `lab_analyte_map_vendor_index` (`vendor`),
  KEY `lab_analyte_map_analyte_code_index` (`analyte_code`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_analyte_map` VALUES (32,NULL,'idexx',NULL,'GLU','Glucose','Glucose','mg/dL',NULL,NULL,NULL,'chemistry',0,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(33,NULL,'idexx',NULL,'BUN','Urea Nitrogen','Urea Nitrogen','mg/dL',NULL,NULL,NULL,'chemistry',1,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(34,NULL,'idexx',NULL,'CREA','Creatinine','Creatinine','mg/dL',NULL,NULL,NULL,'chemistry',2,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(35,NULL,'idexx',NULL,'SDMA','Symmetric Dimethylarginine (IDEXX SDMA)','Symmetric Dimethylarginine (IDEXX SDMA)','µg/dL',NULL,NULL,NULL,'chemistry',3,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(36,NULL,'idexx',NULL,'PHOS','Phosphorus','Phosphorus','mg/dL',NULL,NULL,NULL,'chemistry',4,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(37,NULL,'idexx',NULL,'TP','Total Protein','Total Protein','g/dL',NULL,NULL,NULL,'chemistry',5,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(38,NULL,'idexx',NULL,'ALB','Albumin','Albumin','g/dL',NULL,NULL,NULL,'chemistry',6,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(39,NULL,'idexx',NULL,'GLOB','Globulin','Globulin','g/dL',NULL,NULL,NULL,'chemistry',7,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(40,NULL,'idexx',NULL,'ALT','Alanine Aminotransferase','Alanine Aminotransferase','U/L',NULL,NULL,NULL,'chemistry',8,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(41,NULL,'idexx',NULL,'ALKP','Alkaline Phosphatase','Alkaline Phosphatase','U/L',NULL,NULL,NULL,'chemistry',9,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(42,NULL,'idexx',NULL,'GGT','Gamma-Glutamyl Transferase','Gamma-Glutamyl Transferase','U/L',NULL,NULL,NULL,'chemistry',10,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(43,NULL,'idexx',NULL,'TBIL','Total Bilirubin','Total Bilirubin','mg/dL',NULL,NULL,NULL,'chemistry',11,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(44,NULL,'idexx',NULL,'CHOL','Cholesterol','Cholesterol','mg/dL',NULL,NULL,NULL,'chemistry',12,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(45,NULL,'idexx',NULL,'AMYL','Amylase','Amylase','U/L',NULL,NULL,NULL,'chemistry',13,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(46,NULL,'idexx',NULL,'LIPA','Lipase','Lipase','U/L',NULL,NULL,NULL,'chemistry',14,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(47,NULL,'idexx',NULL,'Ca','Calcium','Calcium','mg/dL',NULL,NULL,NULL,'chemistry',15,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(48,NULL,'idexx',NULL,'TT4','Total Thyroxine','Total Thyroxine','µg/dL',NULL,NULL,NULL,'chemistry',16,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(49,NULL,'idexx',NULL,'Na','Sodium','Sodium','mmol/L',NULL,NULL,NULL,'electrolytes',17,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(50,NULL,'idexx',NULL,'K','Potassium','Potassium','mmol/L',NULL,NULL,NULL,'electrolytes',18,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(51,NULL,'idexx',NULL,'Cl','Chloride','Chloride','mmol/L',NULL,NULL,NULL,'electrolytes',19,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(52,NULL,'idexx',NULL,'tCO2','Total CO2','Total CO2','mmol/L',NULL,NULL,NULL,'electrolytes',20,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(53,NULL,'idexx',NULL,'WBC','White Blood Cells','White Blood Cells','10^9/L',NULL,NULL,NULL,'hematology',21,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(54,NULL,'idexx',NULL,'RBC','Red Blood Cells','Red Blood Cells','10^12/L',NULL,NULL,NULL,'hematology',22,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(55,NULL,'idexx',NULL,'HGB','Hemoglobin','Hemoglobin','g/dL',NULL,NULL,NULL,'hematology',23,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(56,NULL,'idexx',NULL,'HCT','Hematocrit','Hematocrit','%',NULL,NULL,NULL,'hematology',24,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(57,NULL,'idexx',NULL,'MCV','Mean Corpuscular Volume','Mean Corpuscular Volume','fL',NULL,NULL,NULL,'hematology',25,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(58,NULL,'idexx',NULL,'MCH','Mean Corpuscular Hemoglobin','Mean Corpuscular Hemoglobin','pg',NULL,NULL,NULL,'hematology',26,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(59,NULL,'idexx',NULL,'MCHC','Mean Corpuscular Hemoglobin Concentration','Mean Corpuscular Hemoglobin Concentration','g/dL',NULL,NULL,NULL,'hematology',27,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(60,NULL,'idexx',NULL,'RDW','Red Cell Distribution Width','Red Cell Distribution Width','%',NULL,NULL,NULL,'hematology',28,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(61,NULL,'idexx',NULL,'RETIC','Reticulocytes','Reticulocytes','K/µL',NULL,NULL,NULL,'hematology',29,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(62,NULL,'idexx',NULL,'PLT','Platelets','Platelets','10^9/L',NULL,NULL,NULL,'hematology',30,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(63,NULL,'idexx',NULL,'MPV','Mean Platelet Volume','Mean Platelet Volume','fL',NULL,NULL,NULL,'hematology',31,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(64,NULL,'idexx',NULL,'NEU','Neutrophils','Neutrophils','10^9/L',NULL,NULL,NULL,'hematology',32,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(65,NULL,'idexx',NULL,'LYM','Lymphocytes','Lymphocytes','10^9/L',NULL,NULL,NULL,'hematology',33,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(66,NULL,'idexx',NULL,'MONO','Monocytes','Monocytes','10^9/L',NULL,NULL,NULL,'hematology',34,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(67,NULL,'idexx',NULL,'EOS','Eosinophils','Eosinophils','10^9/L',NULL,NULL,NULL,'hematology',35,'2026-06-15 19:06:53','2026-06-15 19:06:53'),(68,NULL,'idexx',NULL,'BASO','Basophils','Basophils','10^9/L',NULL,NULL,NULL,'hematology',36,'2026-06-15 19:06:53','2026-06-15 19:06:53');
CREATE TABLE `lab_communication_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `device_id` int(10) unsigned DEFAULT NULL,
  `vendor` varchar(30) DEFAULT NULL,
  `level` varchar(10) NOT NULL DEFAULT 'info' COMMENT 'info, success, warning, error',
  `category` varchar(20) NOT NULL DEFAULT 'system' COMMENT 'connection, worklist, result, error, sync, system',
  `direction` enum('in','out') DEFAULT NULL,
  `device_ip` varchar(45) DEFAULT NULL,
  `sample_no` varchar(30) DEFAULT NULL,
  `message` text NOT NULL,
  `raw_message` text DEFAULT NULL COMMENT 'Raw bytes (hex) of the device frame',
  `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`context`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_communication_logs_created_at_index` (`created_at`),
  KEY `lab_communication_logs_level_index` (`level`),
  KEY `lab_communication_logs_category_index` (`category`),
  KEY `lab_communication_logs_agent_id_index` (`agent_id`),
  KEY `lab_communication_logs_device_id_index` (`device_id`),
  KEY `lab_communication_logs_vendor_index` (`vendor`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_communication_logs` VALUES (3,5,NULL,'idexx','info','result','in',NULL,NULL,'Raw result message received from agent','H|\\^&|||IDEXX CatalystOne^1.0|||||||P|1|20260615222544\rP|1|IDX23895|||Simba||20200101|M|Feline\rO|1|IDX23895||^^^CHEM|R|20260615222544\rR|1|^^^GLU|276|mg/dL|74^143|H||F||20260615222544\rR|2|^^^BUN|58|mg/dL|7^27|H||F||20260615222544\rR|3|^^^CREA|3.1|mg/dL|0.5^1.8|H||F||20260615222544\rR|4|^^^SDMA|32|µg/dL|0^14|H||F||20260615222544\rR|5|^^^PHOS|8.9|mg/dL|2.5^6.8|H||F||20260615222544\rR|6|^^^TP|4.6|g/dL|5.2^8.2|L||F||20260615222544\rR|7|^^^ALB|2.0|g/dL|2.3^4.0|L||F||20260615222544\rR|8|^^^ALT|240|U/L|10^125|H||F||20260615222544\rR|9|^^^ALKP|94|U/L|23^212|||F||20260615222544\rL|1|N',NULL,'2026-06-15 19:25:45','2026-06-15 19:25:45',NULL);
CREATE TABLE `lab_device_connections` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `device_id` int(10) unsigned DEFAULT NULL,
  `vendor` varchar(30) DEFAULT NULL,
  `device_ip` varchar(45) DEFAULT NULL,
  `device_port` int(10) unsigned DEFAULT NULL,
  `comm_protocol` varchar(40) DEFAULT NULL,
  `status` enum('connected','disconnected') NOT NULL DEFAULT 'connected',
  `connected_at` timestamp NULL DEFAULT NULL,
  `disconnected_at` timestamp NULL DEFAULT NULL,
  `messages_received` int(10) unsigned NOT NULL DEFAULT 0,
  `results_stored` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_device_connections_agent_id_index` (`agent_id`),
  KEY `lab_device_connections_device_id_index` (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lab_device_errors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `device_id` int(10) unsigned DEFAULT NULL,
  `vendor` varchar(30) DEFAULT NULL,
  `error_code` varchar(30) DEFAULT NULL,
  `error_date` date DEFAULT NULL,
  `error_time` time DEFAULT NULL,
  `message` text DEFAULT NULL,
  `added_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`added_info`)),
  `device_ip` varchar(45) DEFAULT NULL,
  `acknowledged` tinyint(1) NOT NULL DEFAULT 0,
  `acknowledged_at` timestamp NULL DEFAULT NULL,
  `acknowledged_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_device_errors_acknowledged_index` (`acknowledged`),
  KEY `lab_device_errors_agent_id_index` (`agent_id`),
  KEY `lab_device_errors_device_id_index` (`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lab_devices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned DEFAULT NULL,
  `agent_id` int(10) unsigned DEFAULT NULL COMMENT 'Hosting LabBridge Agent',
  `vendor` varchar(30) NOT NULL COMMENT 'Driver key: nx600, abaxis, idexx',
  `model` varchar(60) DEFAULT NULL,
  `name` varchar(120) NOT NULL COMMENT 'Display label',
  `connection_type` enum('tcp','serial','serial2eth') NOT NULL DEFAULT 'tcp',
  `comm_protocol` varchar(40) DEFAULT NULL COMMENT 'e.g. astm-e1394, nx600-type-1',
  `host` varchar(45) DEFAULT NULL,
  `port` int(10) unsigned DEFAULT NULL,
  `com_port` varchar(20) DEFAULT NULL COMMENT 'e.g. COM3',
  `baud` int(10) unsigned DEFAULT NULL,
  `parity` varchar(10) DEFAULT NULL,
  `data_bits` tinyint(3) unsigned DEFAULT NULL,
  `stop_bits` tinyint(3) unsigned DEFAULT NULL,
  `status` enum('online','offline','disabled') NOT NULL DEFAULT 'offline',
  `last_seen_at` timestamp NULL DEFAULT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_devices_business_id_vendor_index` (`business_id`,`vendor`),
  KEY `lab_devices_business_id_index` (`business_id`),
  KEY `lab_devices_agent_id_index` (`agent_id`),
  KEY `lab_devices_vendor_index` (`vendor`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_devices` VALUES (14,10,NULL,'nx600','NX600','NX600 Hematology Analyzer','serial','astm',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'online','2026-06-17 21:11:55',NULL,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(15,10,NULL,'abaxis','VetScan VS2','Abaxis VetScan Chemistry Analyzer','serial','astm',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'online','2026-06-17 21:11:55',NULL,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(16,10,NULL,'idexx','CatalystOne','IDEXX Catalyst One Chemistry Analyzer','tcp','astm',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'online','2026-06-17 21:11:55',NULL,'2026-06-17 21:11:55','2026-06-17 21:11:55');
CREATE TABLE `lab_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned NOT NULL,
  `key` varchar(60) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lab_settings_business_id_key_unique` (`business_id`,`key`),
  KEY `lab_settings_business_id_index` (`business_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lab_test_results` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `test_session_id` int(10) unsigned NOT NULL,
  `analyte_code` varchar(20) NOT NULL COMMENT 'Raw vendor code, e.g. GLU-P',
  `analyte_name` varchar(60) DEFAULT NULL COMMENT 'Canonical name from lab_analyte_map',
  `base_name` varchar(20) DEFAULT NULL,
  `sample_suffix` varchar(5) DEFAULT NULL,
  `equality` varchar(3) NOT NULL DEFAULT '=',
  `value` varchar(30) DEFAULT NULL COMMENT 'Numeric or special (+, -, ****, EXP...)',
  `unit` varchar(16) DEFAULT NULL,
  `dilution_factor` smallint(5) unsigned NOT NULL DEFAULT 1,
  `ref_lower` varchar(16) DEFAULT NULL,
  `ref_upper` varchar(16) DEFAULT NULL,
  `raw_flag` varchar(24) DEFAULT NULL COMMENT 'Raw warning/flag string from the device',
  `flags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Parsed vendor-specific flag set' CHECK (json_valid(`flags`)),
  `is_abnormal` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_test_results_test_session_id_analyte_code_index` (`test_session_id`,`analyte_code`),
  KEY `lab_test_results_analyte_code_index` (`analyte_code`),
  CONSTRAINT `lab_test_results_test_session_id_foreign` FOREIGN KEY (`test_session_id`) REFERENCES `lab_test_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_test_results` VALUES (94,17,'WBC','White Blood Cells',NULL,NULL,'=','12.8','10^9/L',1,'6','17',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(95,17,'RBC','Red Blood Cells',NULL,NULL,'=','5.9','10^12/L',1,'5.5','8.5',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(96,17,'HGB','Hemoglobin',NULL,NULL,'=','11.2','g/dL',1,'12','18','H',NULL,1,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(97,17,'HCT','Hematocrit',NULL,NULL,'=','38','%',1,'37','55',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(98,17,'PLT','Platelets',NULL,NULL,'=','480','10^9/L',1,'200','500',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(99,17,'GLU','Glucose',NULL,NULL,'=','138','mg/dL',1,'70','143',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(100,18,'GLU','Glucose',NULL,NULL,'=','102','mg/dL',1,'74','143',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(101,18,'BUN','Urea Nitrogen',NULL,NULL,'=','24','mg/dL',1,'7','27',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(102,18,'CREA','Creatinine',NULL,NULL,'=','1.4','mg/dL',1,'0.5','1.8',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(103,18,'SDMA','IDEXX SDMA',NULL,NULL,'=','19','µg/dL',1,'0','14','H',NULL,1,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(104,18,'PHOS','Phosphorus',NULL,NULL,'=','5.1','mg/dL',1,'2.5','6.8',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(105,18,'ALT','Alanine Aminotransferase',NULL,NULL,'=','68','U/L',1,'10','125',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55'),(106,18,'ALKP','Alkaline Phosphatase',NULL,NULL,'=','110','U/L',1,'23','212',NULL,NULL,0,'2026-06-17 21:11:55','2026-06-17 21:11:55');
CREATE TABLE `lab_test_sessions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) NOT NULL COMMENT 'Agent-generated idempotency key',
  `business_id` int(10) unsigned DEFAULT NULL,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `device_id` int(10) unsigned DEFAULT NULL,
  `vendor` varchar(30) NOT NULL,
  `sample_no` varchar(30) NOT NULL,
  `patient_id` varchar(30) DEFAULT NULL,
  `patient_name` varchar(80) DEFAULT NULL,
  `test_condition` varchar(20) NOT NULL DEFAULT 'NORMAL' COMMENT 'NORMAL / CONTROL',
  `test_date` date DEFAULT NULL,
  `test_time` time DEFAULT NULL,
  `sample_type` varchar(20) DEFAULT NULL,
  `species` varchar(40) DEFAULT NULL,
  `species_code` varchar(10) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `age` smallint(5) unsigned DEFAULT NULL,
  `operator_id` varchar(30) DEFAULT NULL,
  `analyzer_id` varchar(30) DEFAULT NULL,
  `device_ip` varchar(45) DEFAULT NULL,
  `source` enum('agent','manual','api') NOT NULL DEFAULT 'agent',
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Vendor-specific extras (slide lot, comm type, position...)' CHECK (json_valid(`meta`)),
  `contact_id` int(10) unsigned DEFAULT NULL,
  `vc_pet_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `clc_patient_id` int(10) unsigned DEFAULT NULL,
  `clc_appointment_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lab_test_sessions_uuid_unique` (`uuid`),
  UNIQUE KEY `lab_session_vendor_sample_date_unique` (`vendor`,`sample_no`,`test_date`),
  KEY `lab_test_sessions_test_date_test_time_index` (`test_date`,`test_time`),
  KEY `lab_test_sessions_business_id_index` (`business_id`),
  KEY `lab_test_sessions_agent_id_index` (`agent_id`),
  KEY `lab_test_sessions_device_id_index` (`device_id`),
  KEY `lab_test_sessions_vendor_index` (`vendor`),
  KEY `lab_test_sessions_sample_no_index` (`sample_no`),
  KEY `lab_test_sessions_patient_id_index` (`patient_id`),
  KEY `lab_test_sessions_contact_id_index` (`contact_id`),
  KEY `lab_test_sessions_vc_pet_id_index` (`vc_pet_id`),
  KEY `lab_test_sessions_clc_patient_id_index` (`clc_patient_id`),
  KEY `lab_test_sessions_clc_appointment_id_index` (`clc_appointment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_test_sessions` VALUES (17,'e2d838a0-7f6d-4f8e-8256-1d586ff3566d',10,NULL,14,'nx600','S-1001',NULL,'Rex','NORMAL','2026-06-18','00:11:55','whole blood','Dog',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,6092,70,'2026-06-17 21:11:55','2026-06-17 21:11:55',NULL,NULL),(18,'a11f9e28-38d3-425a-883a-aedf8bfefd55',10,NULL,16,'idexx','IDX-2001',NULL,'Bella','NORMAL','2026-06-18','00:11:55','serum','Dog',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,6094,72,'2026-06-17 21:11:55','2026-06-17 21:11:55',NULL,NULL);
CREATE TABLE `lab_worklist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned DEFAULT NULL,
  `agent_id` int(10) unsigned DEFAULT NULL,
  `device_id` int(10) unsigned DEFAULT NULL,
  `vendor` varchar(30) NOT NULL,
  `sample_no` varchar(30) NOT NULL,
  `patient_id` varchar(30) DEFAULT NULL,
  `patient_name` varchar(80) DEFAULT NULL,
  `species` varchar(40) DEFAULT NULL,
  `species_code` varchar(10) DEFAULT NULL COMMENT 'Vendor numeric/text species code',
  `sex` varchar(10) DEFAULT NULL,
  `age` smallint(5) unsigned DEFAULT NULL,
  `tests` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Analyte codes / panels to run' CHECK (json_valid(`tests`)),
  `status` enum('pending','sent','completed','cancelled') NOT NULL DEFAULT 'pending',
  `sent_at` timestamp NULL DEFAULT NULL,
  `contact_id` int(10) unsigned DEFAULT NULL,
  `vc_pet_id` int(10) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `clc_patient_id` int(10) unsigned DEFAULT NULL,
  `clc_appointment_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lab_worklist_vendor_sample_no_index` (`vendor`,`sample_no`),
  KEY `lab_worklist_status_index` (`status`),
  KEY `lab_worklist_business_id_index` (`business_id`),
  KEY `lab_worklist_agent_id_index` (`agent_id`),
  KEY `lab_worklist_device_id_index` (`device_id`),
  KEY `lab_worklist_vendor_index` (`vendor`),
  KEY `lab_worklist_sample_no_index` (`sample_no`),
  KEY `lab_worklist_contact_id_index` (`contact_id`),
  KEY `lab_worklist_vc_pet_id_index` (`vc_pet_id`),
  KEY `lab_worklist_clc_patient_id_index` (`clc_patient_id`),
  KEY `lab_worklist_clc_appointment_id_index` (`clc_appointment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `lab_worklist` VALUES (7,10,NULL,15,'abaxis','S-1002',NULL,'Luna','Cat',NULL,NULL,NULL,'[\"Chem17\"]','pending',NULL,6093,71,195,'2026-06-17 21:11:55','2026-06-17 21:11:55',NULL,NULL,NULL);
CREATE TABLE `lc_cost_snapshots` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_type` varchar(30) NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `purchase_line_id` int(10) unsigned NOT NULL,
  `variation_id` bigint(20) unsigned DEFAULT NULL,
  `orig_purchase_price` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `orig_purchase_price_inc_tax` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `orig_item_tax` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `orig_pp_without_discount` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `orig_var_default_purchase_price` decimal(22,4) DEFAULT NULL,
  `orig_var_dpp_inc_tax` decimal(22,4) DEFAULT NULL,
  `orig_var_profit_percent` decimal(22,4) DEFAULT NULL,
  `applied_at` datetime DEFAULT NULL,
  `applied_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lc_cost_snapshots_parent_line_unique` (`parent_type`,`parent_id`,`purchase_line_id`),
  KEY `lc_cost_snapshots_purchase_line_id_foreign` (`purchase_line_id`),
  CONSTRAINT `lc_cost_snapshots_purchase_line_id_foreign` FOREIGN KEY (`purchase_line_id`) REFERENCES `purchase_lines` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lc_expense_distributions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lc_expense_id` int(10) unsigned NOT NULL,
  `purchase_line_id` int(10) unsigned NOT NULL,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `distribution_ratio` decimal(10,6) NOT NULL DEFAULT 0.000000,
  `allocated_amount` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `allocated_base_amount` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `is_custom` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lc_expense_distributions_lc_expense_id_foreign` (`lc_expense_id`),
  KEY `lc_expense_distributions_purchase_line_id_foreign` (`purchase_line_id`),
  CONSTRAINT `lc_expense_distributions_lc_expense_id_foreign` FOREIGN KEY (`lc_expense_id`) REFERENCES `lc_expenses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lc_expense_distributions_purchase_line_id_foreign` FOREIGN KEY (`purchase_line_id`) REFERENCES `purchase_lines` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lc_expenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(10) unsigned DEFAULT NULL,
  `parent_type` varchar(30) NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `expense_type` enum('shipping','customs','insurance','handling','freight','other') NOT NULL DEFAULT 'other',
  `amount` decimal(15,4) NOT NULL,
  `currency_id` int(10) unsigned DEFAULT NULL,
  `rate_to_base` decimal(15,6) NOT NULL DEFAULT 1.000000,
  `base_amount` decimal(15,4) NOT NULL,
  `distribution_method` enum('equal_qty','equal_value','equal_lines','custom') NOT NULL DEFAULT 'equal_value',
  `notes` text DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lc_expenses_parent_type_parent_id_index` (`parent_type`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `lc_landed_costs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_type` varchar(30) NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `purchase_line_id` int(10) unsigned NOT NULL,
  `base_unit_price` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `landed_unit_cost` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `landed_unit_cost_base` decimal(22,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lc_landed_costs_parent_line_unique` (`parent_type`,`parent_id`,`purchase_line_id`),
  KEY `lc_landed_costs_purchase_line_id_foreign` (`purchase_line_id`),
  CONSTRAINT `lc_landed_costs_purchase_line_id_foreign` FOREIGN KEY (`purchase_line_id`) REFERENCES `purchase_lines` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `business_id` int(11) NOT NULL,
  `file_name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_media_type` varchar(191) DEFAULT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  KEY `media_business_id_index` (`business_id`),
  KEY `media_uploaded_by_index` (`uploaded_by`)
) ENGINE=InnoDB AUTO_INCREMENT=2668 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1546 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2017_07_05_071953_create_currencies_table',1),(4,'2017_07_05_073658_create_business_table',1),(5,'2017_07_22_075923_add_business_id_users_table',1),(6,'2017_07_23_113209_create_brands_table',1),(7,'2017_07_26_083429_create_permission_tables',1),(8,'2017_07_26_110000_create_tax_rates_table',1),(9,'2017_07_26_122313_create_units_table',1),(10,'2017_07_27_075706_create_contacts_table',1),(11,'2017_08_04_071038_create_categories_table',1),(12,'2017_08_08_115903_create_products_table',1),(13,'2017_08_09_061616_create_variation_templates_table',1),(14,'2017_08_09_061638_create_variation_value_templates_table',1),(15,'2017_08_10_061146_create_product_variations_table',1),(16,'2017_08_10_061216_create_variations_table',1),(17,'2017_08_19_054827_create_transactions_table',1),(18,'2017_08_31_073533_create_purchase_lines_table',1),(19,'2017_10_15_064638_create_transaction_payments_table',1),(20,'2017_10_31_065621_add_default_sales_tax_to_business_table',1),(21,'2017_11_20_051930_create_table_group_sub_taxes',1),(22,'2017_11_20_063603_create_transaction_sell_lines',1),(23,'2017_11_21_064540_create_barcodes_table',1),(24,'2017_11_23_181237_create_invoice_schemes_table',1),(25,'2017_12_25_122822_create_business_locations_table',1),(26,'2017_12_25_160253_add_location_id_to_transactions_table',1),(27,'2017_12_25_163227_create_variation_location_details_table',1),(28,'2018_01_04_115627_create_sessions_table',1),(29,'2018_01_05_112817_create_invoice_layouts_table',1),(30,'2018_01_06_112303_add_invoice_scheme_id_and_invoice_layout_id_to_business_locations',1),(31,'2018_01_08_104124_create_expense_categories_table',1),(32,'2018_01_08_123327_modify_transactions_table_for_expenses',1),(33,'2018_01_09_111005_modify_payment_status_in_transactions_table',1),(34,'2018_01_09_111109_add_paid_on_column_to_transaction_payments_table',1),(35,'2018_01_25_172439_add_printer_related_fields_to_business_locations_table',1),(36,'2018_01_27_184322_create_printers_table',1),(37,'2018_01_30_181442_create_cash_registers_table',1),(38,'2018_01_31_125836_create_cash_register_transactions_table',1),(39,'2018_02_07_173326_modify_business_table',1),(40,'2018_02_08_105425_add_enable_product_expiry_column_to_business_table',1),(41,'2018_02_08_111027_add_expiry_period_and_expiry_period_type_columns_to_products_table',1),(42,'2018_02_08_131118_add_mfg_date_and_exp_date_purchase_lines_table',1),(43,'2018_02_08_155348_add_exchange_rate_to_transactions_table',1),(44,'2018_02_09_124945_modify_transaction_payments_table_for_contact_payments',1),(45,'2018_02_12_113640_create_transaction_sell_lines_purchase_lines_table',1),(46,'2018_02_12_114605_add_quantity_sold_in_purchase_lines_table',1),(47,'2018_02_13_183323_alter_decimal_fields_size',1),(48,'2018_02_14_161928_add_transaction_edit_days_to_business_table',1),(49,'2018_02_15_161032_add_document_column_to_transactions_table',1),(50,'2018_02_17_124709_add_more_options_to_invoice_layouts',1),(51,'2018_02_19_111517_add_keyboard_shortcut_column_to_business_table',1),(52,'2018_02_19_121537_stock_adjustment_move_to_transaction_table',1),(53,'2018_02_20_165505_add_is_direct_sale_column_to_transactions_table',1),(54,'2018_02_21_105329_create_system_table',1),(55,'2018_02_23_100549_version_1_2',1),(56,'2018_02_23_125648_add_enable_editing_sp_from_purchase_column_to_business_table',1),(57,'2018_02_26_103612_add_sales_commission_agent_column_to_business_table',1),(58,'2018_02_26_130519_modify_users_table_for_sales_cmmsn_agnt',1),(59,'2018_02_26_134500_add_commission_agent_to_transactions_table',1),(60,'2018_02_27_121422_add_item_addition_method_to_business_table',1),(61,'2018_02_27_170232_modify_transactions_table_for_stock_transfer',1),(62,'2018_03_05_153510_add_enable_inline_tax_column_to_business_table',1),(63,'2018_03_06_210206_modify_product_barcode_types',1),(64,'2018_03_13_181541_add_expiry_type_to_business_table',1),(65,'2018_03_16_113446_product_expiry_setting_for_business',1),(66,'2018_03_19_113601_add_business_settings_options',1),(67,'2018_03_26_125334_add_pos_settings_to_business_table',1),(68,'2018_03_26_165350_create_customer_groups_table',1),(69,'2018_03_27_122720_customer_group_related_changes_in_tables',1),(70,'2018_03_29_110138_change_tax_field_to_nullable_in_business_table',1),(71,'2018_03_29_115502_add_changes_for_sr_number_in_products_and_sale_lines_table',1),(72,'2018_03_29_134340_add_inline_discount_fields_in_purchase_lines',1),(73,'2018_03_31_140921_update_transactions_table_exchange_rate',1),(74,'2018_04_03_103037_add_contact_id_to_contacts_table',1),(75,'2018_04_03_122709_add_changes_to_invoice_layouts_table',1),(76,'2018_04_09_135320_change_exchage_rate_size_in_business_table',1),(77,'2018_04_17_123122_add_lot_number_to_business',1),(78,'2018_04_17_160845_add_product_racks_table',1),(79,'2018_04_20_182015_create_res_tables_table',1),(80,'2018_04_24_105246_restaurant_fields_in_transaction_table',1),(81,'2018_04_24_114149_add_enabled_modules_business_table',1),(82,'2018_04_24_133704_add_modules_fields_in_invoice_layout_table',1),(83,'2018_04_27_132653_quotation_related_change',1),(84,'2018_05_02_104439_add_date_format_and_time_format_to_business',1),(85,'2018_05_02_111939_add_sell_return_to_transaction_payments',1),(86,'2018_05_14_114027_add_rows_positions_for_products',1),(87,'2018_05_14_125223_add_weight_to_products_table',1),(88,'2018_05_14_164754_add_opening_stock_permission',1),(89,'2018_05_15_134729_add_design_to_invoice_layouts',1),(90,'2018_05_16_183307_add_tax_fields_invoice_layout',1),(91,'2018_05_18_191956_add_sell_return_to_transaction_table',1),(92,'2018_05_21_131349_add_custom_fileds_to_contacts_table',1),(93,'2018_05_21_131607_invoice_layout_fields_for_sell_return',1),(94,'2018_05_21_131949_add_custom_fileds_and_website_to_business_locations_table',1),(95,'2018_05_22_123527_create_reference_counts_table',1),(96,'2018_05_22_154540_add_ref_no_prefixes_column_to_business_table',1),(97,'2018_05_24_132620_add_ref_no_column_to_transaction_payments_table',1),(98,'2018_05_24_161026_add_location_id_column_to_business_location_table',1),(99,'2018_05_25_180603_create_modifiers_related_table',1),(100,'2018_05_29_121714_add_purchase_line_id_to_stock_adjustment_line_table',1),(101,'2018_05_31_114645_add_res_order_status_column_to_transactions_table',1),(102,'2018_06_05_103530_rename_purchase_line_id_in_stock_adjustment_lines_table',1),(103,'2018_06_05_111905_modify_products_table_for_modifiers',1),(104,'2018_06_06_110524_add_parent_sell_line_id_column_to_transaction_sell_lines_table',1),(105,'2018_06_07_152443_add_is_service_staff_to_roles_table',1),(106,'2018_06_07_182258_add_image_field_to_products_table',1),(107,'2018_06_13_133705_create_bookings_table',1),(108,'2018_06_15_173636_add_email_column_to_contacts_table',1),(109,'2018_06_27_182835_add_superadmin_related_fields_business',1),(110,'2018_07_10_101913_add_custom_fields_to_products_table',1),(111,'2018_07_17_103434_add_sales_person_name_label_to_invoice_layouts_table',1),(112,'2018_07_17_163920_add_theme_skin_color_column_to_business_table',1),(113,'2018_07_24_160319_add_lot_no_line_id_to_transaction_sell_lines_table',1),(114,'2018_07_25_110004_add_show_expiry_and_show_lot_colums_to_invoice_layouts_table',1),(115,'2018_07_25_172004_add_discount_columns_to_transaction_sell_lines_table',1),(116,'2018_07_26_124720_change_design_column_type_in_invoice_layouts_table',1),(117,'2018_07_26_170424_add_unit_price_before_discount_column_to_transaction_sell_line_table',1),(118,'2018_07_28_103614_add_credit_limit_column_to_contacts_table',1),(119,'2018_08_08_110755_add_new_payment_methods_to_transaction_payments_table',1),(120,'2018_08_08_122225_modify_cash_register_transactions_table_for_new_payment_methods',1),(121,'2018_08_14_104036_add_opening_balance_type_to_transactions_table',1),(122,'2018_09_04_155900_create_accounts_table',1),(123,'2018_09_06_114438_create_selling_price_groups_table',1),(124,'2018_09_06_154057_create_variation_group_prices_table',1),(125,'2018_09_07_102413_add_permission_to_access_default_selling_price',1),(126,'2018_09_07_134858_add_selling_price_group_id_to_transactions_table',1),(127,'2018_09_10_112448_update_product_type_to_single_if_null_in_products_table',1),(128,'2018_09_10_152703_create_account_transactions_table',1),(129,'2018_09_10_173656_add_account_id_column_to_transaction_payments_table',1),(130,'2018_09_19_123914_create_notification_templates_table',1),(131,'2018_09_22_110504_add_sms_and_email_settings_columns_to_business_table',1),(132,'2018_09_24_134942_add_lot_no_line_id_to_stock_adjustment_lines_table',1),(133,'2018_09_26_105557_add_transaction_payments_for_existing_expenses',1),(134,'2018_09_27_111609_modify_transactions_table_for_purchase_return',1),(135,'2018_09_27_131154_add_quantity_returned_column_to_purchase_lines_table',1),(136,'2018_10_02_131401_add_return_quantity_column_to_transaction_sell_lines_table',1),(137,'2018_10_03_104918_add_qty_returned_column_to_transaction_sell_lines_purchase_lines_table',1),(138,'2018_10_03_185947_add_default_notification_templates_to_database',1),(139,'2018_10_09_153105_add_business_id_to_transaction_payments_table',1),(140,'2018_10_16_135229_create_permission_for_sells_and_purchase',1),(141,'2018_10_22_114441_add_columns_for_variable_product_modifications',1),(142,'2018_10_22_134428_modify_variable_product_data',1),(143,'2018_10_30_181558_add_table_tax_headings_to_invoice_layout',1),(144,'2018_10_31_122619_add_pay_terms_field_transactions_table',1),(145,'2018_10_31_161328_add_new_permissions_for_pos_screen',1),(146,'2018_10_31_174752_add_access_selected_contacts_only_to_users_table',1),(147,'2018_10_31_175627_add_user_contact_access',1),(148,'2018_10_31_180559_add_auto_send_sms_column_to_notification_templates_table',1),(149,'2018_11_02_171949_change_card_type_column_to_varchar_in_transaction_payments_table',1),(150,'2018_11_08_105621_add_role_permissions',1),(151,'2018_11_26_114135_add_is_suspend_column_to_transactions_table',1),(152,'2018_11_28_104410_modify_units_table_for_multi_unit',1),(153,'2018_11_28_170952_add_sub_unit_id_to_purchase_lines_and_sell_lines',1),(154,'2018_11_29_115918_add_primary_key_in_system_table',1),(155,'2018_12_03_185546_add_product_description_column_to_products_table',1),(156,'2018_12_06_114937_modify_system_table_and_users_table',1),(157,'2018_12_13_160007_add_custom_fields_display_options_to_invoice_layouts_table',1),(158,'2018_12_14_103307_modify_system_table',1),(159,'2018_12_18_133837_add_prev_balance_due_columns_to_invoice_layouts_table',1),(160,'2018_12_18_170656_add_invoice_token_column_to_transaction_table',1),(161,'2018_12_20_133639_add_date_time_format_column_to_invoice_layouts_table',1),(162,'2018_12_21_120659_add_recurring_invoice_fields_to_transactions_table',1),(163,'2018_12_24_154933_create_notifications_table',1),(164,'2019_01_08_112015_add_document_column_to_transaction_payments_table',1),(165,'2019_01_10_124645_add_account_permission',1),(166,'2019_01_16_125825_add_subscription_no_column_to_transactions_table',1),(167,'2019_01_28_111647_add_order_addresses_column_to_transactions_table',1),(168,'2019_02_13_173821_add_is_inactive_column_to_products_table',1),(169,'2019_02_19_103118_create_discounts_table',1),(170,'2019_02_21_120324_add_discount_id_column_to_transaction_sell_lines_table',1),(171,'2019_02_21_134324_add_permission_for_discount',1),(172,'2019_03_04_170832_add_service_staff_columns_to_transaction_sell_lines_table',1),(173,'2019_03_09_102425_add_sub_type_column_to_transactions_table',1),(174,'2019_03_09_124457_add_indexing_transaction_sell_lines_purchase_lines_table',1),(175,'2019_03_12_120336_create_activity_log_table',1),(176,'2019_03_15_132925_create_media_table',1),(177,'2019_05_08_130339_add_indexing_to_parent_id_in_transaction_payments_table',1),(178,'2019_05_10_132311_add_missing_column_indexing',1),(179,'2019_05_14_091812_add_show_image_column_to_invoice_layouts_table',1),(180,'2019_05_25_104922_add_view_purchase_price_permission',1),(181,'2019_06_17_103515_add_profile_informations_columns_to_users_table',1),(182,'2019_06_18_135524_add_permission_to_view_own_sales_only',1),(183,'2019_06_19_112058_add_database_changes_for_reward_points',1),(184,'2019_06_28_133732_change_type_column_to_string_in_transactions_table',1),(185,'2019_07_13_111420_add_is_created_from_api_column_to_transactions_table',1),(186,'2019_07_15_165136_add_fields_for_combo_product',1),(187,'2019_07_19_103446_add_mfg_quantity_used_column_to_purchase_lines_table',1),(188,'2019_07_22_152649_add_not_for_selling_in_product_table',1),(189,'2019_07_29_185351_add_show_reward_point_column_to_invoice_layouts_table',1),(190,'2019_08_08_162302_add_sub_units_related_fields',1),(191,'2019_08_26_133419_update_price_fields_decimal_point',1),(192,'2019_09_02_160054_remove_location_permissions_from_roles',1),(193,'2019_09_03_185259_add_permission_for_pos_screen',1),(194,'2019_09_04_163141_add_location_id_to_cash_registers_table',1),(195,'2019_09_04_184008_create_types_of_services_table',1),(196,'2019_09_06_131445_add_types_of_service_fields_to_transactions_table',1),(197,'2019_09_09_134810_add_default_selling_price_group_id_column_to_business_locations_table',1),(198,'2019_09_12_105616_create_product_locations_table',1),(199,'2019_09_17_122522_add_custom_labels_column_to_business_table',1),(200,'2019_09_18_164319_add_shipping_fields_to_transactions_table',1),(201,'2019_09_19_170927_close_all_active_registers',1),(202,'2019_09_23_161906_add_media_description_cloumn_to_media_table',1),(203,'2019_10_18_155633_create_account_types_table',1),(204,'2019_10_22_163335_add_common_settings_column_to_business_table',1),(205,'2019_10_29_132521_add_update_purchase_status_permission',1),(206,'2019_11_09_110522_add_indexing_to_lot_number',1),(207,'2019_11_19_170824_add_is_active_column_to_business_locations_table',1),(208,'2019_11_21_162913_change_quantity_field_types_to_decimal',1),(209,'2019_11_25_160340_modify_categories_table_for_polymerphic_relationship',1),(210,'2019_12_02_105025_create_warranties_table',1),(211,'2019_12_03_180342_add_common_settings_field_to_invoice_layouts_table',1),(212,'2019_12_05_183955_add_more_fields_to_users_table',1),(213,'2019_12_06_174904_add_change_return_label_column_to_invoice_layouts_table',1),(214,'2019_12_11_121307_add_draft_and_quotation_list_permissions',1),(215,'2019_12_12_180126_copy_expense_total_to_total_before_tax',1),(216,'2019_12_19_181412_make_alert_quantity_field_nullable_on_products_table',1),(217,'2019_12_25_173413_create_dashboard_configurations_table',1),(218,'2020_01_08_133506_create_document_and_notes_table',1),(219,'2020_01_09_113252_add_cc_bcc_column_to_notification_templates_table',1),(220,'2020_01_16_174818_add_round_off_amount_field_to_transactions_table',1),(221,'2020_01_28_162345_add_weighing_scale_settings_in_business_settings_table',1),(222,'2020_02_18_172447_add_import_fields_to_transactions_table',1),(223,'2020_03_13_135844_add_is_active_column_to_selling_price_groups_table',1),(224,'2020_03_16_115449_add_contact_status_field_to_contacts_table',1),(225,'2020_03_26_124736_add_allow_login_column_in_users_table',1),(226,'2020_04_13_154150_add_feature_products_column_to_business_loactions',1),(227,'2020_04_15_151802_add_user_type_to_users_table',1),(228,'2020_04_22_153905_add_subscription_repeat_on_column_to_transactions_table',1),(229,'2020_04_28_111436_add_shipping_address_to_contacts_table',1),(230,'2020_06_01_094654_add_max_sale_discount_column_to_users_table',1),(231,'2020_06_12_162245_modify_contacts_table',2),(232,'2020_06_22_103104_change_recur_interval_default_to_one',2),(233,'2020_07_09_174621_add_balance_field_to_contacts_table',2),(234,'2020_07_23_104933_change_status_column_to_varchar_in_transaction_table',2),(235,'2020_03_19_130231_add_contact_id_to_users_table',3),(236,'2020_03_27_133605_create_schedules_table',3),(237,'2020_03_27_133628_create_schedule_users_table',3),(238,'2020_03_30_112834_create_schedule_logs_table',3),(239,'2020_04_02_182331_add_crm_module_version_to_system_table',3),(240,'2020_04_08_153231_modify_cloumn_in_contacts_table',3),(241,'2020_04_09_101052_create_lead_users_table',3),(242,'2020_04_16_114747_create_crm_campaigns_table',3),(243,'2016_06_01_000001_create_oauth_auth_codes_table',4),(244,'2016_06_01_000002_create_oauth_access_tokens_table',4),(245,'2016_06_01_000003_create_oauth_refresh_tokens_table',4),(246,'2016_06_01_000004_create_oauth_clients_table',4),(247,'2016_06_01_000005_create_oauth_personal_access_clients_table',4),(248,'2020_09_07_171059_change_completed_stock_transfer_status_to_final',4),(249,'2020_09_21_123224_modify_booking_status_column_in_bookings_table',4),(250,'2020_09_22_121639_create_discount_variations_table',4),(251,'2020_10_05_121550_modify_business_location_table_for_invoice_layout',4),(252,'2020_10_16_175726_set_status_as_received_for_opening_stock',4),(253,'2020_10_23_170823_add_for_group_tax_column_to_tax_rates_table',4),(254,'2020_11_04_130940_add_more_custom_fields_to_contacts_table',4),(255,'2020_11_10_152841_add_cash_register_permissions',4),(256,'2020_11_17_164041_modify_type_column_to_varchar_in_contacts_table',4),(257,'2020_12_18_181447_add_shipping_custom_fields_to_transactions_table',5),(258,'2020_12_22_164303_add_sub_status_column_to_transactions_table',5),(259,'2020_12_24_153050_add_custom_fields_to_transactions_table',5),(260,'2020_12_28_105403_add_whatsapp_text_column_to_notification_templates_table',5),(261,'2020_12_29_165925_add_model_document_type_to_media_table',5),(262,'2021_02_08_175632_add_contact_number_fields_to_users_table',5),(263,'2021_02_11_172217_add_indexing_for_multiple_columns',5),(264,'2021_02_23_122043_add_more_columns_to_customer_groups_table',5),(265,'2021_02_24_175551_add_print_invoice_permission_to_all_roles',5),(266,'2021_03_03_162021_add_purchase_order_columns_to_purchase_lines_and_transactions_table',5),(267,'2021_03_11_120229_add_sales_order_columns',5),(268,'2021_03_16_120705_add_business_id_to_activity_log_table',6),(269,'2021_03_16_153427_add_code_columns_to_business_table',6),(270,'2021_03_18_173308_add_account_details_column_to_accounts_table',6),(271,'2021_03_18_183119_add_prefer_payment_account_columns_to_transactions_table',6),(272,'2021_03_22_120810_add_more_types_of_service_custom_fields',6),(273,'2021_03_24_183132_add_shipping_export_custom_field_details_to_contacts_table',6),(274,'2021_03_25_170715_add_export_custom_fields_info_to_transactions_table',6),(275,'2021_04_15_063449_add_denominations_column_to_cash_registers_table',6),(276,'2021_05_22_083426_add_indexing_to_account_transactions_table',7),(277,'2021_07_08_065808_add_additional_expense_columns_to_transaction_table',7),(278,'2021_07_13_082918_add_qr_code_columns_to_invoice_layouts_table',7),(279,'2021_07_21_061615_add_fields_to_show_commission_agent_in_invoice_layout',7),(280,'2021_08_13_105549_add_crm_contact_id_to_users_table',7),(281,'2021_08_25_114932_add_payment_link_fields_to_transaction_payments_table',7),(282,'2021_09_01_063110_add_spg_column_to_discounts_table',7),(283,'2021_09_03_061528_modify_cash_register_transactions_table',7),(284,'2021_01_07_155757_add_followup_additional_info_column_to_crm_schedules_table',8),(285,'2021_02_02_140021_add_additional_info_to_crm_campaigns_table',8),(286,'2021_02_02_173651_add_new_columns_to_contacts_table',8),(287,'2021_02_04_120439_create_call_logs_table',8),(288,'2021_02_08_172047_add_mobile_name_column_to_crm_call_logs_table',8),(289,'2021_02_16_190038_add_crm_module_indexing',8),(290,'2021_02_19_120846_create_crm_followup_invoices',8),(291,'2021_02_22_132125_add_follow_up_by_to_crm_schedules_table',8),(292,'2021_03_24_160736_add_department_and_designation_to_users_table',8),(293,'2021_06_15_152924_create_proposal_templates_table',8),(294,'2021_06_16_114448_add_recursive_fields_to_crm_schedules_table',8),(295,'2021_06_16_125740_create_proposals_table',8),(296,'2020_08_18_123107_add_connector_module_version_to_system_table',9),(297,'2021_10_05_061658_add_source_column_to_transactions_table',10),(298,'2021_09_24_065738_add_crm_settings_column_to_business_table',11),(299,'2021_12_16_121851_add_parent_id_column_to_expense_categories_table',12),(300,'2018_10_01_151252_create_documents_table',13),(301,'2018_10_02_151803_create_document_shares_table',13),(302,'2018_10_09_134558_create_reminders_table',13),(303,'2018_11_16_170756_create_to_dos_table',13),(304,'2019_02_22_120329_essentials_messages',13),(305,'2019_02_22_161513_add_message_permissions',13),(306,'2019_03_29_164339_add_essentials_version_to_system_table',13),(307,'2019_05_17_153306_create_essentials_leave_types_table',13),(308,'2019_05_17_175921_create_essentials_leaves_table',13),(309,'2019_05_21_154517_add_essentials_settings_columns_to_business_table',13),(310,'2019_05_21_181653_create_table_essentials_attendance',13),(311,'2019_05_30_110049_create_essentials_payrolls_table',13),(312,'2019_06_04_105723_create_essentials_holidays_table',13),(313,'2019_06_28_134217_add_payroll_columns_to_transactions_table',13),(314,'2019_08_26_103520_add_approve_leave_permission',13),(315,'2019_08_27_103724_create_essentials_allowance_and_deduction_table',13),(316,'2019_08_27_105236_create_essentials_user_allowances_and_deductions',13),(317,'2019_09_20_115906_add_more_columns_to_essentials_to_dos_table',13),(318,'2019_09_23_120439_create_essentials_todo_comments_table',13),(319,'2019_12_05_170724_add_hrm_columns_to_users_table',13),(320,'2019_12_09_105809_add_allowance_and_deductions_permission',13),(321,'2020_03_28_152838_create_essentials_shift_table',13),(322,'2020_03_30_162029_create_user_shifts_table',13),(323,'2020_03_31_134558_add_shift_id_to_attendance_table',13),(324,'2020_11_05_105157_modify_todos_date_column_type',13),(325,'2020_11_11_174852_add_end_time_column_to_essentials_reminders_table',13),(326,'2020_11_26_170527_create_essentials_kb_table',13),(327,'2020_11_30_112615_create_essentials_kb_users_table',13),(328,'2021_02_12_185514_add_clock_in_location_to_essentials_attendances_table',13),(329,'2021_02_16_190203_add_essentials_module_indexing',13),(330,'2021_02_27_133448_add_columns_to_users_table',13),(331,'2021_03_04_174857_create_payroll_groups_table',13),(332,'2021_03_04_175025_create_payroll_group_transactions_table',13),(333,'2021_03_09_123914_add_auto_clockout_to_essentials_shifts',13),(334,'2021_06_17_121451_add_location_id_to_table',13),(335,'2021_09_28_091541_create_essentials_user_sales_targets_table',13),(336,'2022_02_09_055012_create_crm_marketplaces_table',14),(337,'2022_02_17_113045_add_source_id_to_marketplace',14),(338,'2022_03_02_180929_add_followup_category_id',14),(339,'2022_02_07_204342_add_tps_permissions',15),(340,'2022_02_14_145020_create_nst_prepare_products_table',15),(341,'2022_02_25_020459_create_nst_shipping_table',15),(342,'2022_02_28_0101344_add_shipping_columns_to_prepare_table',15),(343,'2022_03_08_223033_create_nst_settings_table',15),(344,'2022_03_10_161543_add_transaction_id_in_nst_prepare',15),(345,'2022_03_11_184028_create_nst_user_locations_table',15),(346,'2022_04_06_173628_add_ref_num_in_nst_shipping',15),(347,'2022_06_12_050854_create_stock_reports_table',16),(348,'2022_06_15_020511_add_soft_delete_to_stock_reports_table',16),(349,'2022_04_14_075120_add_payment_type_column_to_transaction_payments_table',17),(350,'2022_04_21_083327_create_cash_denominations_table',17),(351,'2022_05_10_055307_add_delivery_date_column_to_transactions_table',17),(352,'2022_06_13_123135_add_currency_precision_and_quantity_precision_fields_to_business_table',17),(353,'2022_06_28_133342_add_secondary_unit_columns_to_products_sell_line_purchase_lines_tables',17),(354,'2022_05_26_061553_create_crm_contact_person_commissions_table',18),(355,'2022_06_06_073006_add_cc_and_bcc_columns_to_crm_proposals_table',18),(356,'2022_07_13_114307_create_purchase_requisition_related_columns',19),(357,'2022_08_25_132707_add_service_staff_timer_fields_to_products_and_users_table',19),(358,'2023_01_28_114255_add_letter_head_column_to_invoice_layouts_table',20),(359,'2023_02_11_161510_add_event_column_to_activity_log_table',20),(360,'2023_02_11_161511_add_batch_uuid_column_to_activity_log_table',20),(361,'2023_03_02_170312_add_provider_to_oauth_clients_table',20),(362,'2023_03_21_122731_add_sale_invoice_scheme_id_business_table',21),(363,'2023_03_21_170446_add_number_type_to_invoice_scheme',21),(364,'2023_04_17_155216_add_custom_fields_to_products',21),(365,'2023_04_28_130247_add_price_type_to_group_price_table',21),(366,'2023_06_21_033923_add_delivery_person_in_transactions',21),(367,'2023_09_13_153555_add_service_staff_pin_columns_in_users',21),(368,'2023_09_15_154404_add_is_kitchen_order_in_transactions',21),(369,'2023_12_06_152840_add_contact_type_in_contacts',21),(370,'2025_03_10_023721_create_product_parts_table',22),(371,'2025_03_10_023745_create_product_compatibles_table',23),(372,'2025_04_01_115858_create_shared_products_table',24),(373,'2024_10_03_151459_modify_transaction_sell_lines_purchase_lines_table',25),(374,'2025_03_07_114637_add_more_addresh_column_in_contact',25),(375,'2024_11_01_105811_add_is_addition_in_leave_table',26),(376,'2026_01_29_000001_create_pr_requests_table',27),(377,'2026_01_29_000002_create_pr_products_table',27),(378,'2026_01_29_000003_create_pr_supplier_responses_table',27),(379,'2026_01_29_000004_create_pr_supplier_products_table',27),(380,'2026_01_29_000005_create_pr_currencies_table',27),(381,'2026_01_29_000006_create_pr_settings_table',27),(382,'2026_01_29_000007_add_pr_permissions',27),(383,'2026_01_29_000008_add_pr_column_to_purchase_lines',27),(384,'2026_01_29_000009_create_pr_user_locations_table',27),(385,'2026_02_09_000001_add_ref_no_to_pr_supplier_responses',27),(386,'2026_02_11_000001_add_purchase_and_sales_columns_to_pr_products',28),(387,'2026_02_12_000001_add_generating_status_and_order_qty',28),(388,'2026_02_24_000001_create_enhanced_activity_logs_table',29),(389,'2026_02_24_000002_add_activity_log_permissions',29),(390,'2026_02_25_000003_add_request_id_to_enhanced_activity_logs',30),(391,'2026_03_01_000001_create_pr_purchase_shares_table',31),(392,'2026_03_07_000001_add_notes_to_pr_purchase_shares',32),(393,'2026_03_07_000002_create_pr_purchase_changes_table',33),(394,'2026_03_10_000001_create_pr_purchase_payments_table',34),(395,'2026_03_10_000002_add_document_to_pr_purchase_payments_table',35),(396,'2026_04_16_000001_create_pr_purchase_expenses_table',36),(397,'2026_04_16_000002_create_pr_expense_distributions_table',37),(398,'2026_04_16_000003_add_landed_cost_to_pr_supplier_products',38),(787,'2026_05_07_000001_add_indexes_to_tps_tables',40),(788,'2026_05_07_000002_add_unique_to_nst_user_locations',40),(789,'2026_05_07_000003_fix_fk_cascades_on_nst_prepare_products',41),(790,'2026_05_07_000004_add_partial_status_to_nst_prepare_products',41),(791,'2026_04_20_000001_create_vc_departments_table',42),(792,'2026_04_20_000002_create_vc_doctors_table',42),(793,'2026_04_20_000003_create_vc_pet_owner_details_table',42),(794,'2026_04_20_000004_create_vc_pets_table',42),(795,'2026_04_20_000005_create_vc_medical_conditions_table',42),(796,'2026_04_20_000006_create_vc_pet_conditions_table',42),(797,'2026_04_20_000007_create_vc_appointments_table',42),(798,'2026_04_20_000008_create_vc_appointment_notes_table',42),(799,'2026_04_20_000009_create_vc_vaccine_types_table',42),(800,'2026_04_20_000010_create_vc_vaccinations_table',42),(801,'2026_04_20_000011_create_vc_prescriptions_table',42),(802,'2026_04_20_000012_create_vc_prescription_items_table',42),(803,'2026_04_20_000013_create_vc_medicine_categories_table',42),(804,'2026_04_20_000014_create_vc_medicines_table',42),(805,'2026_04_20_000015_create_vc_medicine_batches_table',42),(806,'2026_04_20_000016_create_vc_medical_reports_table',42),(807,'2026_04_20_000017_create_vc_birth_death_records_table',42),(808,'2026_04_20_000018_add_vet_clinic_permissions',42),(809,'2026_04_21_000001_add_category_to_vc_vaccine_types',42),(810,'2026_04_22_000001_add_weight_to_vc_appointments',42),(811,'2026_04_22_000002_add_dose_to_vc_vaccinations',42),(812,'2026_04_22_000003_add_vitals_soap_to_vc_appointments',42),(813,'2026_04_24_000001_add_taken_status_to_vc_vaccinations',42),(814,'2026_04_25_000001_create_vc_clinic_locations_table',42),(815,'2026_04_25_000002_add_location_id_to_vc_departments',42),(816,'2026_04_25_000003_create_vc_doctor_departments_table',42),(817,'2026_04_25_000004_create_vc_doctor_schedules_table',42),(818,'2026_04_25_000005_create_vc_appointment_types_table',42),(819,'2026_04_25_000006_create_vc_appointment_reasons_table',42),(820,'2026_04_25_000007_update_vc_appointments_for_new_features',42),(821,'2026_04_25_000008_add_business_location_id_to_vc_clinic_locations',42),(822,'2026_04_25_000008_add_vc_settings_columns',42),(823,'2026_04_25_000009_create_vc_module_settings_table',42),(824,'2026_04_25_000010_make_schedule_department_nullable',42),(825,'2026_04_26_000001_add_soap_investigations_to_vc_appointments',42),(826,'2026_04_26_000001_make_apt_type_reason_business_nullable',42),(827,'2026_04_27_000001_create_vc_appointment_documents_table',42),(828,'2026_04_27_000002_add_soap_lab_exam_to_vc_appointments',42),(829,'2026_04_28_000001_add_soap_plan_meds_json_to_vc_appointments',42),(830,'2026_04_29_000001_create_vc_soap_options_table',42),(831,'2026_04_29_000002_add_group_name_to_vc_soap_options',42),(832,'2026_05_01_000001_add_email_confirmed_to_vc_pet_owner_details',42),(833,'2026_05_01_000002_create_vc_reminder_settings_table',42),(834,'2026_05_01_000003_create_vc_reminder_templates_table',42),(835,'2026_05_01_000004_create_vc_reminder_logs_table',42),(836,'2026_05_02_000001_add_email_confirm_token_to_vc_pet_owner_details',42),(837,'2026_05_02_000002_redesign_vc_medicines_remove_stock',42),(838,'2026_05_03_000001_add_waived_columns_to_vc_vaccinations',42),(839,'2026_05_06_000001_add_color_to_vc_doctors',43),(840,'2026_05_06_000002_add_product_id_to_vc_catalogues',43),(841,'2026_05_06_000003_create_vc_exam_not_done_reasons_table',43),(842,'2026_05_06_000004_add_exam_results_and_next_visit_to_vc_appointments',43),(843,'2026_05_19_000001_add_next_visit_type_reason_ids_to_vc_appointments',44),(844,'2026_05_20_000001_create_vc_evaluation_tables',45),(845,'2026_05_20_000002_seed_default_evaluation_questions',45),(846,'2026_05_21_000001_add_time_tracking_to_vc_appointments',46),(847,'2026_05_21_000002_create_vc_appointment_status_logs_table',46),(848,'2026_05_21_000003_create_vc_appointment_edit_requests_table',46),(849,'2026_05_20_100001_create_nx_patients_table',47),(850,'2026_05_20_100002_create_nx_worklist_table',47),(851,'2026_05_20_100003_create_nx_test_sessions_table',47),(852,'2026_05_20_100004_create_nx_test_results_table',47),(853,'2026_05_20_100005_create_nx_device_errors_table',47),(854,'2026_05_20_100006_create_nx_device_connections_table',47),(855,'2026_05_20_100007_create_nx_communication_logs_table',47),(856,'2026_05_20_100008_create_nx_module_settings_table',47),(857,'2026_05_20_100009_add_nx600_lab_permissions',47),(858,'2026_05_22_000001_add_preferred_doctor_to_owners_and_pets',48),(859,'2026_05_22_000002_create_vc_doctor_change_requests_table',48),(860,'2026_05_22_000003_create_vc_preferred_doctor_history_table',48),(861,'2026_05_22_000004_add_sync_columns_to_vc_medical_reports',48),(862,'2026_05_22_100001_create_va_wards_table',49),(863,'2026_05_22_100002_create_va_care_task_types_table',49),(864,'2026_05_22_100003_create_va_admissions_table',49),(865,'2026_05_22_100004_create_va_admission_care_plan_table',49),(866,'2026_05_22_100005_create_va_care_logs_table',49),(867,'2026_05_22_100006_create_va_admission_vitals_table',49),(868,'2026_05_22_100007_add_vet_admission_permissions',49),(869,'2026_05_23_000001_fix_va_care_task_icons',50),(870,'2026_05_23_100001_create_vai_settings_table',51),(871,'2026_05_23_100002_create_vai_queries_table',51),(872,'2026_05_23_100003_add_vet_ai_permissions',51),(873,'2026_05_24_000001_add_base_url_to_vai_settings',52),(874,'2026_05_25_000001_add_stage_to_vai_queries',53),(875,'2026_05_26_000001_create_vp_portal_settings_table',54),(876,'2026_05_26_000002_create_vp_portal_accounts_table',54),(877,'2026_05_26_000003_add_vet_portal_permissions',54),(878,'2026_05_22_000005_create_vc_consent_tables',55),(879,'2026_05_22_000006_add_signed_file_to_vc_consents',56),(880,'2026_05_22_100001_create_lab_agents_table',57),(881,'2026_05_22_100002_create_lab_devices_table',57),(882,'2026_05_22_100003_create_lab_worklist_table',57),(883,'2026_05_22_100004_create_lab_test_sessions_table',57),(884,'2026_05_22_100005_create_lab_test_results_table',57),(885,'2026_05_22_100006_create_lab_analyte_map_table',57),(886,'2026_05_22_100007_create_lab_communication_logs_table',57),(887,'2026_05_22_100008_create_lab_device_connections_table',57),(888,'2026_05_22_100009_create_lab_device_errors_table',57),(889,'2026_05_22_100010_create_lab_settings_table',57),(890,'2026_05_22_100011_add_lab_core_permissions',57),(891,'2026_05_22_200001_seed_abaxis_analyte_map',58),(892,'2026_05_23_000001_create_vc_role_landing_pages_table',59),(893,'2026_05_23_000002_create_vc_role_settings_table',60),(894,'2026_05_23_000003_create_controlled_drug_register',61),(895,'2026_05_23_000004_create_vc_confidential_notes_table',62),(896,'2026_05_24_000001_create_vc_authorized_vets_table',63),(897,'2026_05_25_000001_add_source_to_controlled_movements',64),(898,'2026_05_26_000001_create_vc_controlled_daily_seals_table',65),(899,'2026_05_26_000001_add_transcription_to_vai_settings',66),(900,'2026_05_28_000001_create_vc_consent_signatures_table',67),(901,'2026_05_28_000002_extend_vc_consent_signatures_for_uploads',67),(902,'2026_05_28_000003_create_vc_controlled_reconciliations_table',67),(903,'2026_05_28_000004_add_cert_verify_token_to_vc_pets',68),(904,'2026_05_29_000001_create_vc_quotation_meta_table',68),(905,'2026_05_29_000002_add_sms_to_vet_reminders',68),(906,'2026_05_29_000003_add_dispense_columns_to_vc_prescription_items',68),(907,'2026_05_29_200001_create_vc_vital_ranges_table',68),(908,'2026_05_29_500001_create_vc_wellness_tables',68),(909,'2026_05_29_700001_create_vc_imaging_tables',68),(910,'2026_05_29_100001_create_va_medications_and_fluids',69),(911,'2026_05_29_200001_create_va_alerts_table',69),(912,'2026_05_29_300001_create_va_protocols',69),(913,'2026_05_29_300002_enrich_default_protocol_descriptions',69),(914,'2026_05_29_400001_create_va_discharge_templates_and_billing',69),(915,'2026_05_29_400002_seed_default_discharge_templates',69),(916,'2026_05_29_600001_create_nx_lab_providers_table',69),(917,'2026_05_30_000001_add_silence_limit_to_vai_settings',70),(918,'2026_05_30_000001_create_portal_owners_table',71),(919,'2026_05_30_000002_create_portal_owner_tokens_table',71),(920,'2026_05_30_000003_create_portal_otp_challenges_table',71),(921,'2026_05_30_000004_create_portal_magic_tokens_table',71),(922,'2026_05_30_000005_create_portal_brands_table',72),(923,'2026_05_31_000001_add_contact_id_to_portal_owners',73),(924,'2026_05_31_000002_create_portal_push_subscriptions_table',74),(925,'2026_05_31_000001_create_vc_exam_tables',75),(926,'2026_05_31_000002_seed_general_exam_template',75),(927,'2026_05_31_000003_seed_orthopedic_exam_template',75),(928,'2026_05_31_000001_add_clean_non_medical_to_vai_settings',76),(929,'2026_05_31_000003_add_location_id_to_vc_doctor_schedules',77),(930,'2026_05_31_000004_add_critical_flags_to_appointments',78),(931,'2026_05_31_000005_create_blocking_policy',79),(932,'2026_05_31_000006_seed_neurological_body_system',80),(933,'2026_05_31_000007_backfill_vital_critical_flags',81),(934,'2026_05_31_000004_create_portal_owner_devices_table',82),(935,'2026_05_31_000008_assign_new_vet_clinic_permissions_to_admin',83),(936,'2026_05_31_000009_seed_default_vet_roles',84),(937,'2026_05_31_000010_create_vc_system_findings_table',85),(938,'2026_06_01_000001_seed_comprehensive_vital_ranges',86),(939,'2026_06_01_100001_create_wa_channels_table',87),(940,'2026_06_01_100002_create_wa_contacts_table',87),(941,'2026_06_01_100003_create_wa_templates_table',87),(942,'2026_06_01_100004_create_wa_messages_table',87),(943,'2026_06_01_100005_create_wa_settings_table',87),(944,'2026_06_01_100006_create_jobs_table_if_missing',87),(945,'2026_06_01_100007_add_whatsapp_permissions',87),(946,'2026_06_01_000002_seed_additional_complaint_chips',88),(947,'2026_06_01_000001_create_lc_expenses_table',89),(948,'2026_06_01_000002_create_lc_expense_distributions_table',89),(949,'2026_06_01_000003_create_lc_landed_costs_table',89),(950,'2026_06_01_000004_add_landed_cost_permissions',89),(951,'2026_06_01_000005_migrate_pr_expenses_to_landed_cost',89),(952,'2026_06_02_000001_add_ai_cache_to_appointments',90),(953,'2026_06_02_000002_add_has_whatsapp_to_contacts',90),(954,'2026_06_02_100001_add_wa_availability_to_wa_contacts',91),(955,'2026_06_02_000001_create_portal_feature_tables',92),(956,'2026_06_02_100002_create_wa_conversations_table',92),(957,'2026_06_02_100003_add_conversation_id_to_wa_messages',92),(958,'2026_06_02_100004_create_wa_auto_replies_table',93),(959,'2026_06_02_100005_add_labels_to_wa_conversations',93),(960,'2026_06_02_000004_create_shared_product_items_table',94),(961,'2026_06_01_000006_create_lc_cost_snapshots_table',95),(962,'2026_06_01_000007_add_landed_cost_apply_permission',95),(963,'2026_06_02_100001_create_ai_providers_table',96),(964,'2026_06_02_100002_create_ai_usage_logs_table',96),(965,'2026_06_02_100003_add_ai_core_permissions',96),(966,'2026_06_02_000001_create_pc_part_numbers_table',97),(967,'2026_06_02_000002_create_pc_device_models_table',97),(968,'2026_06_02_000003_create_pc_device_compat_table',97),(969,'2026_06_02_000004_create_pc_compatibles_table',97),(970,'2026_06_02_000005_create_pc_change_reports_table',97),(971,'2026_06_02_000006_create_pc_product_status_table',97),(972,'2026_06_02_000007_create_pc_enrichment_log_table',97),(973,'2026_06_02_000008_migrate_legacy_product_compatibles',97),(974,'2026_06_02_100006_add_address_jid_to_wa_contacts',98),(1156,'2026_06_02_100000_seed_derma_exam_templates',100),(1256,'2026_06_02_000001_create_ss_settings_table',103),(1257,'2026_06_02_000002_create_ss_files_table',103),(1258,'2026_06_02_000003_create_ss_devices_table',103),(1259,'2026_06_02_000004_create_ss_otp_sessions_table',103),(1260,'2026_06_02_000005_create_ss_access_logs_table',103),(1261,'2026_06_02_000006_add_smart_storage_permissions',103),(1262,'2026_06_03_000001_widen_pc_source_columns',104),(1263,'2026_04_20_000001_create_clc_departments_table',105),(1264,'2026_04_20_000002_create_clc_doctors_table',105),(1265,'2026_04_20_000003_create_clc_patient_contact_details_table',105),(1266,'2026_04_20_000004_create_clc_patients_table',105),(1267,'2026_04_20_000005_create_clc_medical_conditions_table',105),(1268,'2026_04_20_000006_create_clc_patient_conditions_table',105),(1269,'2026_04_20_000007_create_clc_appointments_table',105),(1270,'2026_04_20_000008_create_clc_appointment_notes_table',105),(1271,'2026_04_20_000009_create_clc_vaccine_types_table',105),(1272,'2026_04_20_000010_create_clc_vaccinations_table',105),(1273,'2026_04_20_000011_create_clc_prescriptions_table',105),(1274,'2026_04_20_000012_create_clc_prescription_items_table',105),(1275,'2026_04_20_000013_create_clc_medicine_categories_table',105),(1276,'2026_04_20_000014_create_clc_medicines_table',105),(1277,'2026_04_20_000015_create_clc_medicine_batches_table',105),(1278,'2026_04_20_000016_create_clc_medical_reports_table',105),(1279,'2026_04_20_000017_create_clc_birth_death_records_table',105),(1280,'2026_04_20_000018_add_clinic_core_permissions',106),(1281,'2026_04_21_000001_add_category_to_clc_vaccine_types',106),(1282,'2026_04_22_000001_add_weight_to_clc_appointments',106),(1283,'2026_04_22_000002_add_dose_to_clc_vaccinations',106),(1284,'2026_04_22_000003_add_vitals_soap_to_clc_appointments',106),(1285,'2026_04_24_000001_add_taken_status_to_clc_vaccinations',106),(1286,'2026_04_25_000001_create_clc_clinic_locations_table',106),(1287,'2026_04_25_000002_add_location_id_to_clc_departments',106),(1288,'2026_04_25_000003_create_clc_doctor_departments_table',106),(1289,'2026_04_25_000004_create_clc_doctor_schedules_table',106),(1290,'2026_04_25_000005_create_clc_appointment_types_table',106),(1291,'2026_04_25_000006_create_clc_appointment_reasons_table',106),(1292,'2026_04_25_000007_update_clc_appointments_for_new_features',106),(1293,'2026_04_25_000008_add_business_location_id_to_clc_clinic_locations',106),(1294,'2026_04_25_000008_add_clc_settings_columns',106),(1295,'2026_04_25_000009_create_clc_module_settings_table',106),(1296,'2026_04_25_000010_clc_make_schedule_department_nullable',106),(1297,'2026_04_26_000001_add_soap_investigations_to_clc_appointments',106),(1298,'2026_04_26_000001_clc_make_apt_type_reason_business_nullable',106),(1299,'2026_04_27_000001_create_clc_appointment_documents_table',106),(1300,'2026_04_27_000002_add_soap_lab_exam_to_clc_appointments',106),(1301,'2026_04_28_000001_add_soap_plan_meds_json_to_clc_appointments',106),(1302,'2026_04_29_000001_create_clc_soap_options_table',106),(1303,'2026_04_29_000002_add_group_name_to_clc_soap_options',106),(1304,'2026_05_01_000001_add_email_confirmed_to_clc_patient_contact_details',106),(1305,'2026_05_01_000002_create_clc_reminder_settings_table',106),(1306,'2026_05_01_000003_create_clc_reminder_templates_table',106),(1307,'2026_05_01_000004_create_clc_reminder_logs_table',106),(1308,'2026_05_02_000001_add_email_confirm_token_to_clc_patient_contact_details',106),(1309,'2026_05_02_000002_redesign_clc_medicines_remove_stock',106),(1310,'2026_05_03_000001_add_waived_columns_to_clc_vaccinations',106),(1311,'2026_05_06_000001_add_color_to_clc_doctors',106),(1312,'2026_05_06_000002_add_product_id_to_clc_catalogues',106),(1313,'2026_05_06_000003_create_clc_exam_not_done_reasons_table',106),(1314,'2026_05_06_000004_add_exam_results_and_next_visit_to_clc_appointments',106),(1315,'2026_05_19_000001_add_next_visit_type_reason_ids_to_clc_appointments',106),(1316,'2026_05_20_000001_create_clc_evaluation_tables',106),(1317,'2026_05_20_000002_clc_seed_default_evaluation_questions',106),(1318,'2026_05_21_000001_add_time_tracking_to_clc_appointments',106),(1319,'2026_05_21_000002_create_clc_appointment_status_logs_table',106),(1320,'2026_05_21_000003_create_clc_appointment_edit_requests_table',106),(1321,'2026_05_22_000001_clc_add_preferred_doctor_to_owners_and_pets',106),(1322,'2026_05_22_000002_create_clc_doctor_change_requests_table',106),(1323,'2026_05_22_000003_create_clc_preferred_doctor_history_table',106),(1324,'2026_05_22_000004_add_sync_columns_to_clc_medical_reports',106),(1325,'2026_05_22_000005_create_clc_consent_tables',106),(1326,'2026_05_22_000006_add_signed_file_to_clc_consents',106),(1327,'2026_05_23_000001_create_clc_role_landing_pages_table',106),(1328,'2026_05_23_000002_create_clc_role_settings_table',106),(1329,'2026_05_23_000003_clc_create_controlled_drug_register',106),(1330,'2026_05_23_000004_create_clc_confidential_notes_table',106),(1331,'2026_05_24_000001_create_clc_authorized_vets_table',106),(1332,'2026_05_25_000001_clc_add_source_to_controlled_movements',106),(1333,'2026_05_26_000001_create_clc_controlled_daily_seals_table',106),(1334,'2026_05_28_000001_create_clc_consent_signatures_table',106),(1335,'2026_05_28_000002_extend_clc_consent_signatures_for_uploads',106),(1336,'2026_05_28_000003_create_clc_controlled_reconciliations_table',106),(1337,'2026_05_28_000004_add_cert_verify_token_to_clc_patients',106),(1338,'2026_05_29_000001_create_clc_quotation_meta_table',106),(1339,'2026_05_29_000002_clc_add_sms_to_vet_reminders',106),(1340,'2026_05_29_000003_add_dispense_columns_to_clc_prescription_items',106),(1341,'2026_05_29_200001_create_clc_vital_ranges_table',106),(1342,'2026_05_29_500001_create_clc_wellness_tables',106),(1343,'2026_05_29_700001_create_clc_imaging_tables',106),(1344,'2026_05_31_000001_create_clc_exam_tables',106),(1345,'2026_05_31_000002_clc_seed_general_exam_template',106),(1346,'2026_05_31_000003_clc_seed_orthopedic_exam_template',106),(1347,'2026_05_31_000004_clc_add_critical_flags_to_appointments',106),(1348,'2026_05_31_000005_clc_create_blocking_policy',106),(1349,'2026_05_31_000006_clc_seed_neurological_body_system',106),(1350,'2026_05_31_000007_clc_backfill_vital_critical_flags',106),(1351,'2026_05_31_000008_assign_new_clinic_core_permissions_to_admin',106),(1352,'2026_05_31_000009_clc_seed_default_vet_roles',106),(1353,'2026_05_31_000010_create_clc_system_findings_table',106),(1354,'2026_06_01_000001_clc_seed_comprehensive_vital_ranges',106),(1355,'2026_06_01_000002_clc_seed_additional_complaint_chips',106),(1356,'2026_06_02_000001_clc_add_ai_cache_to_appointments',106),(1357,'2026_06_02_000002_clc_add_has_whatsapp_to_contacts',106),(1359,'2026_06_03_000001_create_clc_specialties_table',106),(1360,'2026_06_03_000002_add_specialty_columns',106),(1361,'2026_06_03_000003_seed_clc_specialties',106),(1362,'2026_06_02_100000_seed_clinic_exam_templates',107),(1363,'2026_06_03_000004_drop_derma_columns_from_clc_patients',108),(1364,'2026_06_03_100001_create_derma_patient_profiles_table',109),(1365,'2026_06_03_000002_create_pc_product_barcodes_table',110),(1366,'2026_06_03_200001_create_dental_specialty_tables',111),(1367,'2026_06_03_000005_add_specialty_id_to_clc_exam_templates',112),(1368,'2026_06_03_100002_seed_derma_exam_templates',113),(1369,'2026_06_03_200002_seed_dental_exam_templates',114),(1370,'2026_06_03_120000_create_clc_clinical_photos_table',115),(1371,'2026_06_04_000001_add_capabilities_to_clc_specialties',115),(1372,'2026_06_03_000006_seed_specialty_exam_templates',116),(1373,'2026_06_04_000002_add_constants_to_clc_appointments',116),(1374,'2026_06_04_000003_add_clinic_ai_permission',116),(1375,'2026_06_03_000003_create_pc_settings_and_jobs_tables',117),(1376,'2026_06_04_000004_add_height_to_clc_patients',118),(1377,'2026_06_04_000005_add_specialty_vital_fields',118),(1378,'2026_06_04_100000_create_clc_treatment_package_tables',119),(1379,'2026_06_04_100001_seed_clc_treatment_packages',119),(1380,'2026_06_04_300001_create_ophth_patient_profiles_table',120),(1381,'2026_06_04_300002_make_ophthalmology_structural',120),(1382,'2026_06_04_400001_create_obgyn_patient_profiles_table',121),(1383,'2026_06_04_400002_make_gynaecology_structural',121),(1384,'2026_06_04_900001_create_allergy_patient_profiles_table',122),(1385,'2026_06_04_900002_make_allergy_structural',122),(1386,'2026_06_04_900001_create_andrology_patient_profiles_table',123),(1387,'2026_06_04_900002_make_andrology_structural',123),(1388,'2026_06_04_900001_create_audiology_patient_profiles_table',124),(1389,'2026_06_04_900002_make_audiology_structural',124),(1390,'2026_06_04_900001_create_bariatric_patient_profiles_table',125),(1391,'2026_06_04_900002_make_bariatric_structural',125),(1392,'2026_06_04_900001_create_cardiology_patient_profiles_table',126),(1393,'2026_06_04_900002_make_cardiology_structural',126),(1394,'2026_06_04_900001_create_cardiothoracic_patient_profiles_table',127),(1395,'2026_06_04_900002_make_cardiothoracic_structural',127),(1396,'2026_06_04_900001_create_emergency_patient_profiles_table',128),(1397,'2026_06_04_900002_make_emergency_structural',128),(1398,'2026_06_04_900001_create_endocrinology_patient_profiles_table',129),(1399,'2026_06_04_900002_make_endocrinology_structural',129),(1400,'2026_06_04_900001_create_ent_patient_profiles_table',130),(1401,'2026_06_04_900002_make_ent_structural',130),(1402,'2026_06_04_900001_create_family_medicine_patient_profiles_table',131),(1403,'2026_06_04_900002_make_family_medicine_structural',131),(1404,'2026_06_04_900001_create_gastroenterology_patient_profiles_table',132),(1405,'2026_06_04_900002_make_gastroenterology_structural',132),(1406,'2026_06_04_900001_create_general_practice_patient_profiles_table',133),(1407,'2026_06_04_900002_make_general_practice_structural',133),(1408,'2026_06_04_900001_create_general_surgery_patient_profiles_table',134),(1409,'2026_06_04_900002_make_general_surgery_structural',134),(1410,'2026_06_04_900001_create_geriatrics_patient_profiles_table',135),(1411,'2026_06_04_900002_make_geriatrics_structural',135),(1412,'2026_06_04_900001_create_hematology_patient_profiles_table',136),(1413,'2026_06_04_900002_make_hematology_structural',136),(1414,'2026_06_04_900001_create_hepatology_patient_profiles_table',137),(1415,'2026_06_04_900002_make_hepatology_structural',137),(1416,'2026_06_04_900001_create_internal_medicine_patient_profiles_table',138),(1417,'2026_06_04_900002_make_internal_medicine_structural',138),(1418,'2026_06_04_900001_create_ivf_patient_profiles_table',139),(1419,'2026_06_04_900002_make_ivf_structural',139),(1420,'2026_06_04_900001_create_nephrology_patient_profiles_table',140),(1421,'2026_06_04_900002_make_nephrology_structural',140),(1422,'2026_06_04_900001_create_neurology_patient_profiles_table',141),(1423,'2026_06_04_900002_make_neurology_structural',141),(1424,'2026_06_04_900001_create_neurosurgery_patient_profiles_table',142),(1425,'2026_06_04_900002_make_neurosurgery_structural',142),(1426,'2026_06_04_900001_create_nutrition_patient_profiles_table',143),(1427,'2026_06_04_900002_make_nutrition_structural',143),(1428,'2026_06_04_900001_create_oncology_patient_profiles_table',144),(1429,'2026_06_04_900002_make_oncology_structural',144),(1430,'2026_06_04_900001_create_oncology_surgery_patient_profiles_table',145),(1431,'2026_06_04_900002_make_oncology_surgery_structural',145),(1432,'2026_06_04_900001_create_orthopedics_patient_profiles_table',146),(1433,'2026_06_04_900002_make_orthopedics_structural',146),(1434,'2026_06_04_900001_create_osteopathy_patient_profiles_table',147),(1435,'2026_06_04_900002_make_osteopathy_structural',147),(1436,'2026_06_04_900001_create_pain_management_patient_profiles_table',148),(1437,'2026_06_04_900002_make_pain_management_structural',148),(1438,'2026_06_04_900001_create_pediatric_surgery_patient_profiles_table',149),(1439,'2026_06_04_900002_make_pediatric_surgery_structural',149),(1440,'2026_06_04_900001_create_pediatrics_patient_profiles_table',150),(1441,'2026_06_04_900002_make_pediatrics_structural',150),(1442,'2026_06_04_900001_create_phoniatrics_patient_profiles_table',151),(1443,'2026_06_04_900002_make_phoniatrics_structural',151),(1444,'2026_06_04_900001_create_physiotherapy_patient_profiles_table',152),(1445,'2026_06_04_900002_make_physiotherapy_structural',152),(1446,'2026_06_04_900001_create_plastic_surgery_patient_profiles_table',153),(1447,'2026_06_04_900002_make_plastic_surgery_structural',153),(1448,'2026_06_04_900001_create_primary_care_patient_profiles_table',154),(1449,'2026_06_04_900002_make_primary_care_structural',154),(1450,'2026_06_04_900001_create_psychiatry_patient_profiles_table',155),(1451,'2026_06_04_900002_make_psychiatry_structural',155),(1452,'2026_06_04_900001_create_pulmonology_patient_profiles_table',156),(1453,'2026_06_04_900002_make_pulmonology_structural',156),(1454,'2026_06_04_900001_create_radiology_patient_profiles_table',157),(1455,'2026_06_04_900002_make_radiology_structural',157),(1456,'2026_06_04_900001_create_rheumatology_patient_profiles_table',158),(1457,'2026_06_04_900002_make_rheumatology_structural',158),(1458,'2026_06_04_900001_create_services_patient_profiles_table',159),(1459,'2026_06_04_900002_make_services_structural',159),(1460,'2026_06_04_900001_create_spinal_surgery_patient_profiles_table',160),(1461,'2026_06_04_900002_make_spinal_surgery_structural',160),(1462,'2026_06_04_900001_create_urology_patient_profiles_table',161),(1463,'2026_06_04_900002_make_urology_structural',161),(1464,'2026_06_04_900001_create_vascular_surgery_patient_profiles_table',162),(1465,'2026_06_04_900002_make_vascular_surgery_structural',162),(1466,'2026_06_04_950001_add_clinic_linkage_to_lab_tables',163),(1467,'2026_06_11_000001_create_bms_venue_tables',164),(1468,'2026_06_11_000002_create_bms_catalog_tables',164),(1469,'2026_06_11_000003_create_bms_matching_tables',164),(1470,'2026_06_11_000004_create_bms_funnel_tables',164),(1471,'2026_06_11_000005_create_bms_booking_tables',164),(1472,'2026_06_11_000006_create_bms_settings_table',164),(1473,'2026_06_11_000007_register_bms_version',165),(1474,'2026_06_11_000008_create_bms_api_tables',166),(1475,'2026_06_12_000001_create_bms_task_tables',167),(1476,'2026_06_12_000002_create_bms_transfer_tables',168),(1477,'2026_06_13_000001_create_bms_asset_tables',169),(1478,'2026_06_13_000002_add_asset_id_to_bms_transfer_items',169),(1479,'2026_06_14_000001_create_bms_maintenance_tables',170),(1480,'2026_06_15_000001_extend_bms_package_items',171),(1481,'2026_06_16_000001_package_customization_and_360',172),(1482,'2026_06_17_000001_hall_managers_and_pricing',173),(1483,'2026_06_18_000001_venue_working_hours',174),(1484,'2026_06_19_000001_add_bms_is_asset_to_products',175),(1485,'2026_06_20_000001_package_builder',176),(1486,'2026_06_20_000002_add_addon_price_to_package_items',177),(1487,'2026_06_21_000001_add_event_type_to_hall_media',178),(1488,'2026_06_22_000001_add_description_ar',179),(1489,'2026_06_23_000001_client_portal_auth',180),(1490,'2026_06_24_000001_package_item_media',181),(1491,'2026_06_25_000001_package_item_options',182),(1492,'2026_06_26_000001_booking_finance_and_lifecycle',183),(1493,'2026_06_27_000001_create_bms_documents_table',184),(1494,'2026_06_28_000001_create_bms_qc_tables',185),(1495,'2026_06_29_000001_create_bms_push_subscriptions_table',186),(1496,'2026_06_30_000001_add_whatsapp_to_leads',187),(1497,'2026_06_30_000002_add_contents_to_package_items',188),(1498,'2026_06_30_000003_create_bms_change_requests_table',189),(1499,'2026_07_01_000001_create_bms_product_extension_tables',190),(1500,'2026_07_02_000001_task_acknowledgment',191),(1501,'2026_07_03_000001_cancel_reason_and_qc_events',192),(1502,'2026_07_04_000001_add_package_items_to_bms_booking_halls',193),(1503,'2026_06_15_000001_seed_idexx_analyte_map',194),(1504,'2026_06_16_000001_create_vet_staff_tokens_table',195),(1505,'2026_06_16_000002_create_vet_staff_push_subscriptions_table',196),(1506,'2026_06_18_000001_create_vs_sites_table',197),(1507,'2026_06_18_000002_create_vs_pages_table',197),(1508,'2026_06_18_000003_create_vs_media_table',197),(1509,'2026_06_18_000004_create_vs_messages_table',197),(1510,'2026_06_19_100001_create_va_catalogs_tables',198),(1511,'2026_06_19_100002_add_deposit_status_and_permission',198),(1512,'2026_06_19_100001_add_transcription_to_ai_providers',199),(1513,'2026_06_19_100002_backfill_transcription_from_vai_settings',200),(1514,'2026_06_20_100001_add_charge_capture_stamps',201),(1515,'2026_06_20_100001_add_charge_capture_stamps_to_vaccinations',201),(1526,'2022_10_31_115725_create_accounting_account_types_table',202),(1527,'2022_11_01_104108_create_accounting_accounts_table',202),(1528,'2022_11_10_135427_create_accounts_transactions_table',202),(1529,'2022_11_14_171948_create_accounting_acc_trans_mapping',202),(1530,'2022_12_02_133536_create_accounting_budgets_table',202),(1531,'2022_12_19_124743_add_accounting_settings_column_to_business_table',202),(1532,'2022_12_26_182821_AddAccountingModuleVersionToSystemTable',202),(1533,'2023_05_25_131005_add_default_map_transactions_fields',202),(1534,'2026_06_24_000001_add_module_entitlements_to_business_table',203),(1535,'2026_06_26_100001_create_ai_feedback_table',204),(1536,'2026_06_26_100002_add_public_booking_to_portal_brands',205),(1537,'2026_06_27_100001_add_booking_otp_to_portal_brands',206),(1538,'2026_06_27_100002_fix_portal_otp_expires_at_autoupdate',207),(1539,'2026_07_09_000001_add_demo_columns_to_business_table',208),(1540,'2026_07_09_000101_create_tour_flows_table',209),(1541,'2026_07_09_000102_create_tour_media_table',209),(1542,'2026_07_09_000103_create_tour_steps_table',209),(1543,'2026_07_09_000104_create_tour_progress_table',209),(1544,'2026_07_09_000201_create_activity_incidents_table',210),(1545,'2026_07_09_000105_install_guidedtour_version',211);
