-- Table structure for table `autosmsshortcode`
--

CREATE TABLE `autosmsshortcode` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `type` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `autosmsshortcode`
--

INSERT INTO `autosmsshortcode` (`id`, `name`, `type`) VALUES
(1, '{name}', 'payment'),
(2, '{firstname}', 'payment'),
(3, '{lastname}', 'payment'),
(4, '{amount}', 'payment'),
(55, '{appoinmentdate}', 'appoinment_confirmation'),
(54, '{doctorname}', 'appoinment_confirmation'),
(53, '{name}', 'appoinment_confirmation'),
(52, '{lastname}', 'appoinment_confirmation'),
(51, '{firstname}', 'appoinment_confirmation'),
(50, '{time_slot}', 'appoinment_creation'),
(49, '{appoinmentdate}', 'appoinment_creation'),
(48, '{hospital_name}', 'appoinment_creation'),
(47, '{doctorname}', 'appoinment_creation'),
(46, '{name}', 'appoinment_creation'),
(45, '{lastname}', 'appoinment_creation'),
(44, '{firstname}', 'appoinment_creation'),
(28, '{firstname}', 'doctor'),
(29, '{lastname}', 'doctor'),
(30, '{name}', 'doctor'),
(31, '{company}', 'doctor'),
(43, '{doctor}', 'patient'),
(42, '{company}', 'patient'),
(41, '{lastname}', 'patient'),
(40, '{firstname}', 'patient'),
(39, '{name}', 'patient'),
(38, '{department}', 'doctor'),
(56, '{time_slot}', 'appoinment_confirmation'),
(57, '{hospital_name}', 'appoinment_confirmation'),
(58, '{start_time}', 'meeting_creation'),
(59, '{patient_name}', 'meeting_creation'),
(60, '{doctor_name}', 'meeting_creation'),
(61, '{hospital_name}', 'meeting_creation'),
(62, '{meeting_link}', 'meeting_creation'),
(63, '{time_slot}', 'appoinment_remainder'),
(64, '{appoinmentdate}', 'appoinment_remainder'),
(65, '{hospital_name}', 'appoinment_remainder'),
(66, '{doctorname}', 'appoinment_remainder'),
(67, '{name}', 'appoinment_remainder'),
(68, '{lastname}', 'appoinment_remainder'),
(69, '{firstname}', 'appoinment_remainder');

-- --------------------------------------------------------

--
-- Table structure for table `autosmstemplate`
--

CREATE TABLE `autosmstemplate` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `type` varchar(1000) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `autosmstemplate`
--

INSERT INTO `autosmstemplate` (`id`, `name`, `message`, `type`, `status`, `hospital_id`) VALUES
(507, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '75'),
(506, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '75'),
(505, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '75'),
(504, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '75'),
(503, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '74'),
(502, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '74'),
(501, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '74'),
(500, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '74'),
(499, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '74'),
(498, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '74'),
(497, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '74'),
(496, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '73'),
(494, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '73'),
(495, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '73'),
(493, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '73'),
(492, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '73'),
(491, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '73'),
(490, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '73'),
(488, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '72'),
(489, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '72'),
(487, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '72'),
(486, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '72'),
(485, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '72'),
(483, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '72'),
(484, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '72'),
(482, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '71'),
(481, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '71'),
(480, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '71'),
(479, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '71'),
(478, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '71'),
(477, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '71'),
(476, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '71'),
(475, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '70'),
(474, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '70'),
(473, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '70'),
(472, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '70'),
(471, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '70'),
(470, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '70'),
(469, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '70'),
(468, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '69'),
(467, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '69'),
(466, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '69'),
(465, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '69'),
(464, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '69'),
(463, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '69'),
(462, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '69'),
(461, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(459, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(460, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(458, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(457, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(456, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(455, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(453, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(454, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(452, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(451, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(450, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(448, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(449, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(447, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '65'),
(446, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '65'),
(445, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '65'),
(444, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '65'),
(443, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '65'),
(442, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '65'),
(441, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '65'),
(440, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '64'),
(439, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '64'),
(438, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '64'),
(437, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '64'),
(436, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '64'),
(435, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '64'),
(434, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '64'),
(433, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(432, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(431, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(430, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(429, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(428, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(427, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(426, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '15'),
(425, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '15'),
(424, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '15'),
(423, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '15'),
(422, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '15'),
(421, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '15'),
(420, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '15'),
(418, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '14'),
(419, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '14'),
(417, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '14'),
(416, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '14'),
(415, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '14'),
(413, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '14'),
(414, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '14'),
(412, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '13'),
(411, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '13'),
(410, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '13'),
(409, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '13'),
(408, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '13'),
(407, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '13'),
(406, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '13'),
(405, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '12'),
(404, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '12'),
(403, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '12'),
(402, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '12'),
(401, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '12'),
(400, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '12'),
(399, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '12'),
(398, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '11'),
(396, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '11'),
(397, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '11'),
(395, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '11'),
(394, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '11'),
(393, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '11'),
(392, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '11'),
(391, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '10'),
(390, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '10'),
(389, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '10'),
(388, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '10'),
(387, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '10'),
(386, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '10'),
(385, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '10'),
(383, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '9'),
(384, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '9'),
(382, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '9'),
(381, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '9'),
(380, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '9'),
(379, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '9'),
(378, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '9'),
(377, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '8'),
(376, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '8'),
(375, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '8'),
(374, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '8'),
(373, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '8'),
(372, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '8'),
(371, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '8'),
(370, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '7'),
(369, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '7'),
(368, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '7'),
(367, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '7'),
(366, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '7'),
(365, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '7'),
(364, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '7'),
(363, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '6'),
(361, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '6'),
(362, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '6'),
(360, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '6'),
(359, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '6'),
(358, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '6'),
(357, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '6'),
(355, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '5'),
(356, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '5'),
(354, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '5'),
(353, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '5'),
(352, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '5'),
(350, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '5'),
(351, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '5'),
(349, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '4'),
(348, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '4'),
(347, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '4'),
(346, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '4'),
(345, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '4'),
(344, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '4'),
(343, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '4'),
(342, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!! You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '1'),
(341, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!! You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '3'),
(339, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '3'),
(340, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!! You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '2'),
(338, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '3'),
(337, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '3'),
(336, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '3'),
(334, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '3'),
(335, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '3'),
(333, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '2'),
(332, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '2'),
(331, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '2'),
(330, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '2'),
(329, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '2'),
(328, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '2'),
(327, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '1'),
(326, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '1'),
(325, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '1'),
(324, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '1'),
(323, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '1'),
(322, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '1'),
(508, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '75'),
(509, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '75'),
(510, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '75'),
(511, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '76'),
(512, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '76'),
(513, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '76'),
(514, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '76'),
(515, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '76'),
(516, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '76'),
(517, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '76'),
(518, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '77'),
(519, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '77'),
(520, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '77'),
(521, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '77'),
(522, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '77'),
(523, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '77'),
(524, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '77'),
(525, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '78'),
(526, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '78'),
(527, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '78'),
(528, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '78'),
(529, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '78'),
(530, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '78'),
(531, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '78'),
(532, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '79'),
(533, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '79'),
(534, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '79'),
(535, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '79'),
(536, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '79'),
(537, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '79'),
(538, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '79'),
(539, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '82'),
(540, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '82'),
(541, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '82'),
(542, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '82'),
(543, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '82'),
(544, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '82'),
(545, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '82'),
(546, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(547, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(548, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(549, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(550, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(551, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(552, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(553, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL);
INSERT INTO `autosmstemplate` (`id`, `name`, `message`, `type`, `status`, `hospital_id`) VALUES
(554, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(555, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(556, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(557, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(558, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(559, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(560, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(561, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(562, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(563, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(564, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(565, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(566, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(567, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', NULL),
(568, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', NULL),
(569, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', NULL),
(570, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', NULL),
(571, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', NULL),
(572, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', NULL),
(573, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', NULL),
(574, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '83'),
(575, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '83'),
(576, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '83'),
(577, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '83'),
(578, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '83'),
(579, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '83'),
(580, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '83'),
(581, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '84'),
(582, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '84'),
(583, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '84'),
(584, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '84'),
(585, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '84'),
(586, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '84'),
(587, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '84'),
(588, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '85'),
(589, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '85'),
(590, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '85'),
(591, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '85'),
(592, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '85'),
(593, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '85'),
(594, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '85'),
(595, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '86'),
(596, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '86'),
(597, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '86'),
(598, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '86'),
(599, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '86'),
(600, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '86'),
(601, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '86'),
(602, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '87'),
(603, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '87'),
(604, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '87'),
(605, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '87'),
(606, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '87'),
(607, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '87'),
(608, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '87'),
(609, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '88'),
(610, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '88'),
(611, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '88'),
(612, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '88'),
(613, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '88'),
(614, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '88'),
(615, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '88'),
(616, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '89'),
(617, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '89'),
(618, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '89'),
(619, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '89'),
(620, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '89'),
(621, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '89'),
(622, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '89'),
(623, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '90'),
(624, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '90'),
(625, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '90'),
(626, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '90'),
(627, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '90'),
(628, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '90'),
(629, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '90'),
(630, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '91'),
(631, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '91'),
(632, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '91'),
(633, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '91'),
(634, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '91'),
(635, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '91'),
(636, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '91'),
(637, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '92'),
(638, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '92'),
(639, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '92'),
(640, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '92'),
(641, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '92'),
(642, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '92'),
(643, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '92'),
(644, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '93'),
(645, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '93'),
(646, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '93'),
(647, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '93'),
(648, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '93'),
(649, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '93'),
(650, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '93'),
(651, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '94'),
(652, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '94'),
(653, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '94'),
(654, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '94'),
(655, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '94'),
(656, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '94'),
(657, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '94'),
(658, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '95'),
(659, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '95'),
(660, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '95'),
(661, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '95'),
(662, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '95'),
(663, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '95'),
(664, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '95'),
(665, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '96'),
(666, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '96'),
(667, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '96'),
(668, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '96'),
(669, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '96'),
(670, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '96'),
(671, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '96'),
(672, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '97'),
(673, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '97'),
(674, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '97'),
(675, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '97'),
(676, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '97'),
(677, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '97'),
(678, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '97'),
(679, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '98'),
(680, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '98'),
(681, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '98'),
(682, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . \r\nyour video link: {meeting_link}\r\nRegards', 'meeting_creation', 'Active', '98'),
(683, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '98'),
(684, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '98'),
(685, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '98'),
(686, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '99'),
(687, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '99'),
(688, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '99'),
(689, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '99'),
(690, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '99'),
(691, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '99'),
(692, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '99'),
(693, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '100'),
(694, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '100'),
(695, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '100'),
(696, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '100'),
(697, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '100'),
(698, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '100'),
(699, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '100'),
(700, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '101'),
(701, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '101'),
(702, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '101'),
(703, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '101'),
(704, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '101'),
(705, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '101'),
(706, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '101'),
(707, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '102'),
(708, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '102'),
(709, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '102'),
(710, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '102'),
(711, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '102'),
(712, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '102'),
(713, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '102'),
(714, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '103'),
(715, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '103'),
(716, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '103'),
(717, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '103'),
(718, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '103'),
(719, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '103'),
(720, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '103'),
(721, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '104'),
(722, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '104'),
(723, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '104'),
(724, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '104'),
(725, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '104'),
(726, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '104'),
(727, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '104'),
(728, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '105'),
(729, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '105'),
(730, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '105'),
(731, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '105'),
(732, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '105'),
(733, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '105'),
(734, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '105'),
(735, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '106'),
(736, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '106'),
(737, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '106'),
(738, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '106'),
(739, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '106'),
(740, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '106'),
(741, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '106'),
(742, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '107'),
(743, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '107'),
(744, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '107'),
(745, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '107'),
(746, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '107'),
(747, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '107'),
(748, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '107'),
(749, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '108'),
(750, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '108'),
(751, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '108'),
(752, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '108'),
(753, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '108'),
(754, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '108'),
(755, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '108'),
(756, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '109'),
(757, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '109'),
(758, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '109'),
(759, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '109'),
(760, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '109'),
(761, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '109'),
(762, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '109'),
(763, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '110'),
(764, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '110'),
(765, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '110'),
(766, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '110'),
(767, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '110'),
(768, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '110'),
(769, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '110'),
(770, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '111'),
(771, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '111'),
(772, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '111'),
(773, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '111'),
(774, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '111'),
(775, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '111'),
(776, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '111'),
(777, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '112'),
(778, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '112'),
(779, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '112'),
(780, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '112'),
(781, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '112'),
(782, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '112'),
(783, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '112'),
(784, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '113');
INSERT INTO `autosmstemplate` (`id`, `name`, `message`, `type`, `status`, `hospital_id`) VALUES
(785, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '113'),
(786, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '113'),
(787, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '113'),
(788, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '113'),
(789, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '113'),
(790, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '113'),
(791, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '114'),
(792, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '114'),
(793, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '114'),
(794, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '114'),
(795, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '114'),
(796, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '114'),
(797, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '114'),
(798, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '115'),
(799, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '115'),
(800, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '115'),
(801, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '115'),
(802, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '115'),
(803, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '115'),
(804, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '115'),
(805, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '116'),
(806, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '116'),
(807, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '116'),
(808, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '116'),
(809, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '116'),
(810, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '116'),
(811, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '116'),
(812, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '117'),
(813, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '117'),
(814, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '117'),
(815, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '117'),
(816, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '117'),
(817, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '117'),
(818, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '117'),
(819, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '118'),
(820, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '118'),
(821, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '118'),
(822, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '118'),
(823, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '118'),
(824, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '118'),
(825, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '118'),
(826, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '119'),
(827, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '119'),
(828, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '119'),
(829, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '119'),
(830, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '119'),
(831, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '119'),
(832, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '119'),
(833, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '120'),
(834, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '120'),
(835, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '120'),
(836, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '120'),
(837, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '120'),
(838, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '120'),
(839, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '120'),
(840, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '121'),
(841, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '121'),
(842, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '121'),
(843, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '121'),
(844, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '121'),
(845, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '121'),
(846, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '121'),
(847, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '122'),
(848, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '122'),
(849, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '122'),
(850, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '122'),
(851, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '122'),
(852, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '122'),
(853, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '122'),
(854, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '123'),
(855, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '123'),
(856, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '123'),
(857, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '123'),
(858, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '123'),
(859, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '123'),
(860, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '123'),
(861, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '124'),
(862, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '124'),
(863, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '124'),
(864, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '124'),
(865, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '124'),
(866, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '124'),
(867, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '124'),
(868, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '125'),
(869, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '125'),
(870, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '125'),
(871, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '125'),
(872, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '125'),
(873, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '125'),
(874, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '125'),
(875, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '126'),
(876, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '126'),
(877, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '126'),
(878, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '126'),
(879, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '126'),
(880, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '126'),
(881, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '126'),
(882, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '127'),
(883, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '127'),
(884, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '127'),
(885, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '127'),
(886, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '127'),
(887, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '127'),
(888, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '127'),
(889, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '128'),
(890, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '128'),
(891, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '128'),
(892, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '128'),
(893, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '128'),
(894, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '128'),
(895, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '128'),
(896, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '129'),
(897, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '129'),
(898, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '129'),
(899, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '129'),
(900, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '129'),
(901, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '129'),
(902, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '129'),
(903, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '130'),
(904, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '130'),
(905, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '130'),
(906, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '130'),
(907, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '130'),
(908, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '130'),
(909, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '130'),
(910, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '131'),
(911, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '131'),
(912, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '131'),
(913, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '131'),
(914, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '131'),
(915, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '131'),
(916, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '131'),
(917, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '132'),
(918, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '132'),
(919, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '132'),
(920, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '132'),
(921, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '132'),
(922, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '132'),
(923, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '132'),
(924, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '133'),
(925, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '133'),
(926, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '133'),
(927, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '133'),
(928, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '133'),
(929, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '133'),
(930, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '133'),
(931, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '134'),
(932, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '134'),
(933, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '134'),
(934, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '134'),
(935, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '134'),
(936, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '134'),
(937, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '134'),
(938, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '135'),
(939, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '135'),
(940, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '135'),
(941, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '135'),
(942, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '135'),
(943, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '135'),
(944, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '135'),
(945, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '136'),
(946, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '136'),
(947, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '136'),
(948, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '136'),
(949, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '136'),
(950, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '136'),
(951, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '136'),
(952, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '137'),
(953, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '137'),
(954, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '137'),
(955, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '137'),
(956, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '137'),
(957, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '137'),
(958, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '137'),
(959, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '138'),
(960, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '138'),
(961, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '138'),
(962, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '138'),
(963, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '138'),
(964, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '138'),
(965, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '138'),
(966, 'Payment successful sms to patient', 'Dear {name}, Your paying amount - Tk {amount} was successful. Thank You Please contact our support for further queries.', 'payment', 'Active', '139'),
(967, 'Appointment Confirmation sms to patient', 'Dear {name}, Your appointment with {doctorname} on {appoinmentdate} at {time_slot} is confirmed. For more information contact with {hospital_name} Regards', 'appoinment_confirmation', 'Active', '139'),
(968, 'Appointment creation sms to patient', 'Dear {name}, You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} .Please confirm your appointment. For more information contact with {hospital_name} Regards', 'appoinment_creation', 'Active', '139'),
(969, 'Meeting Schedule Notification To Patient', 'Dear {patient_name}, You have a Live Video Meeting with {doctor_name} on {start_time}. For more information contact with {hospital_name} . Regards', 'meeting_creation', 'Active', '139'),
(970, 'send appoint confirmation to Doctor', 'Dear {name}, You are appointed as a doctor in {department} . Thank You {company}', 'doctor', 'Active', '139'),
(971, 'Patient Registration Confirmation', 'Dear {name}, You are registred to {company} as a patient to {doctor}. Regards', 'patient', 'Active', '139'),
(972, 'Appointment Remainder sms to patient', 'Dear {name}, REMAINDER!!<br> You have an appointment with {doctorname} on {appoinmentdate} at {time_slot} . For more information contact with {hospital_name} Regards', 'appoinment_remainder', 'Active', '139');

-- --------------------------------------------------------

--
-- Table structure for table `bankb`
--

CREATE TABLE `bankb` (
  `id` int(100) NOT NULL,
  `group` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bankb`
--

INSERT INTO `bankb` (`id`, `group`, `status`, `hospital_id`) VALUES
(1, 'A+', '0 Bags', '1'),
(2, 'A-', '0 Bags', '1'),
(3, 'B+', '0 Bags', '1'),
(4, 'B-', '0 Bags', '1'),
(5, 'AB+', '0 Bags', '1'),
(6, 'AB-', '0 Bags', '1'),
(7, 'O+', '0 Bags', '1'),
(8, 'O-', '0 Bags', '1'),
(9, 'A+', '0 Bags', '2'),
(10, 'A-', '0 Bags', '2'),
(11, 'B+', '0 Bags', '2'),
(12, 'B-', '0 Bags', '2'),
(13, 'AB+', '0 Bags', '2'),
(14, 'AB-', '0 Bags', '2'),
(15, 'O+', '0 Bags', '2'),
(16, 'O-', '0 Bags', '2'),
(17, 'A+', '0 Bags', '3'),
(18, 'A-', '0 Bags', '3'),
(19, 'B+', '0 Bags', '3'),
(20, 'B-', '0 Bags', '3'),
(21, 'AB+', '0 Bags', '3'),
(22, 'AB-', '0 Bags', '3'),
(23, 'O+', '0 Bags', '3'),
(24, 'O-', '0 Bags', '3'),
(25, 'A+', '0 Bags', '4'),
(26, 'A-', '0 Bags', '4'),
(27, 'B+', '0 Bags', '4'),
(28, 'B-', '0 Bags', '4'),
(29, 'AB+', '0 Bags', '4'),
(30, 'AB-', '0 Bags', '4'),
(31, 'O+', '0 Bags', '4'),
(32, 'O-', '0 Bags', '4'),
(33, 'A+', '0 Bags', '5'),
(34, 'A-', '0 Bags', '5'),
(35, 'B+', '0 Bags', '5'),
(36, 'B-', '0 Bags', '5'),
(37, 'AB+', '0 Bags', '5'),
(38, 'AB-', '0 Bags', '5'),
(39, 'O+', '0 Bags', '5'),
(40, 'O-', '0 Bags', '5'),
(41, 'A+', '0 Bags', '6'),
(42, 'A-', '0 Bags', '6'),
(43, 'B+', '0 Bags', '6'),
(44, 'B-', '0 Bags', '6'),
(45, 'AB+', '0 Bags', '6'),
(46, 'AB-', '0 Bags', '6'),
(47, 'O+', '0 Bags', '6'),
(48, 'O-', '0 Bags', '6'),
(49, 'A+', '0 Bags', '7'),
(50, 'A-', '0 Bags', '7'),
(51, 'B+', '0 Bags', '7'),
(52, 'B-', '0 Bags', '7'),
(53, 'AB+', '0 Bags', '7'),
(54, 'AB-', '0 Bags', '7'),
(55, 'O+', '0 Bags', '7'),
(56, 'O-', '0 Bags', '7'),
(57, 'A+', '0 Bags', '8'),
(58, 'A-', '0 Bags', '8'),
(59, 'B+', '0 Bags', '8'),
(60, 'B-', '0 Bags', '8'),
(61, 'AB+', '0 Bags', '8'),
(62, 'AB-', '0 Bags', '8'),
(63, 'O+', '0 Bags', '8'),
(64, 'O-', '0 Bags', '8'),
(65, 'A+', '0 Bags', '9'),
(66, 'A-', '0 Bags', '9'),
(67, 'B+', '0 Bags', '9'),
(68, 'B-', '0 Bags', '9'),
(69, 'AB+', '0 Bags', '9'),
(70, 'AB-', '0 Bags', '9'),
(71, 'O+', '0 Bags', '9'),
(72, 'O-', '0 Bags', '9'),
(73, 'A+', '0 Bags', '10'),
(74, 'A-', '0 Bags', '10'),
(75, 'B+', '0 Bags', '10'),
(76, 'B-', '0 Bags', '10'),
(77, 'AB+', '0 Bags', '10'),
(78, 'AB-', '0 Bags', '10'),
(79, 'O+', '0 Bags', '10'),
(80, 'O-', '0 Bags', '10'),
(81, 'A+', '0 Bags', '11'),
(82, 'A-', '0 Bags', '11'),
(83, 'B+', '0 Bags', '11'),
(84, 'B-', '0 Bags', '11'),
(85, 'AB+', '0 Bags', '11'),
(86, 'AB-', '0 Bags', '11'),
(87, 'O+', '0 Bags', '11'),
(88, 'O-', '0 Bags', '11'),
(89, 'A+', '0 Bags', '12'),
(90, 'A-', '0 Bags', '12'),
(91, 'B+', '0 Bags', '12'),
(92, 'B-', '0 Bags', '12'),
(93, 'AB+', '0 Bags', '12'),
(94, 'AB-', '0 Bags', '12'),
(95, 'O+', '0 Bags', '12'),
(96, 'O-', '0 Bags', '12'),
(97, 'A+', '0 Bags', '13'),
(98, 'A-', '0 Bags', '13'),
(99, 'B+', '0 Bags', '13'),
(100, 'B-', '0 Bags', '13'),
(101, 'AB+', '0 Bags', '13'),
(102, 'AB-', '0 Bags', '13'),
(103, 'O+', '0 Bags', '13'),
(104, 'O-', '0 Bags', '13'),
(105, 'A+', '0 Bags', '14'),
(106, 'A-', '0 Bags', '14'),
(107, 'B+', '0 Bags', '14'),
(108, 'B-', '0 Bags', '14'),
(109, 'AB+', '0 Bags', '14'),
(110, 'AB-', '0 Bags', '14'),
(111, 'O+', '0 Bags', '14'),
(112, 'O-', '0 Bags', '14'),
(113, 'A+', '0 Bags', '15'),
(114, 'A-', '0 Bags', '15'),
(115, 'B+', '0 Bags', '15'),
(116, 'B-', '0 Bags', '15'),
(117, 'AB+', '0 Bags', '15'),
(118, 'AB-', '0 Bags', '15'),
(119, 'O+', '0 Bags', '15'),
(120, 'O-', '0 Bags', '15'),
(121, 'A+', '0 Bags', NULL),
(122, 'A-', '0 Bags', NULL),
(123, 'B+', '0 Bags', NULL),
(124, 'B-', '0 Bags', NULL),
(125, 'AB+', '0 Bags', NULL),
(126, 'AB-', '0 Bags', NULL),
(127, 'O+', '0 Bags', NULL),
(128, 'O-', '0 Bags', NULL),
(129, 'A+', '0 Bags', '64'),
(130, 'A-', '0 Bags', '64'),
(131, 'B+', '0 Bags', '64'),
(132, 'B-', '0 Bags', '64'),
(133, 'AB+', '0 Bags', '64'),
(134, 'AB-', '0 Bags', '64'),
(135, 'O+', '0 Bags', '64'),
(136, 'O-', '0 Bags', '64'),
(137, 'A+', '0 Bags', '65'),
(138, 'A-', '0 Bags', '65'),
(139, 'B+', '0 Bags', '65'),
(140, 'B-', '0 Bags', '65'),
(141, 'AB+', '0 Bags', '65'),
(142, 'AB-', '0 Bags', '65'),
(143, 'O+', '0 Bags', '65'),
(144, 'O-', '0 Bags', '65'),
(145, 'A+', '0 Bags', NULL),
(146, 'A-', '0 Bags', NULL),
(147, 'B+', '0 Bags', NULL),
(148, 'B-', '0 Bags', NULL),
(149, 'AB+', '0 Bags', NULL),
(150, 'AB-', '0 Bags', NULL),
(151, 'O+', '0 Bags', NULL),
(152, 'O-', '0 Bags', NULL),
(153, 'A+', '0 Bags', NULL),
(154, 'A-', '0 Bags', NULL),
(155, 'B+', '0 Bags', NULL),
(156, 'B-', '0 Bags', NULL),
(157, 'AB+', '0 Bags', NULL),
(158, 'AB-', '0 Bags', NULL),
(159, 'O+', '0 Bags', NULL),
(160, 'O-', '0 Bags', NULL),
(161, 'A+', '0 Bags', '69'),
(162, 'A-', '0 Bags', '69'),
(163, 'B+', '0 Bags', '69'),
(164, 'B-', '0 Bags', '69'),
(165, 'AB+', '0 Bags', '69'),
(166, 'AB-', '0 Bags', '69'),
(167, 'O+', '0 Bags', '69'),
(168, 'O-', '0 Bags', '69'),
(169, 'A+', '0 Bags', '70'),
(170, 'A-', '0 Bags', '70'),
(171, 'B+', '0 Bags', '70'),
(172, 'B-', '0 Bags', '70'),
(173, 'AB+', '0 Bags', '70'),
(174, 'AB-', '0 Bags', '70'),
(175, 'O+', '0 Bags', '70'),
(176, 'O-', '0 Bags', '70'),
(177, 'A+', '0 Bags', '71'),
(178, 'A-', '0 Bags', '71'),
(179, 'B+', '0 Bags', '71'),
(180, 'B-', '0 Bags', '71'),
(181, 'AB+', '0 Bags', '71'),
(182, 'AB-', '0 Bags', '71'),
(183, 'O+', '0 Bags', '71'),
(184, 'O-', '0 Bags', '71'),
(185, 'A+', '0 Bags', '72'),
(186, 'A-', '0 Bags', '72'),
(187, 'B+', '0 Bags', '72'),
(188, 'B-', '0 Bags', '72'),
(189, 'AB+', '0 Bags', '72'),
(190, 'AB-', '0 Bags', '72'),
(191, 'O+', '0 Bags', '72'),
(192, 'O-', '0 Bags', '72'),
(193, 'A+', '0 Bags', '73'),
(194, 'A-', '0 Bags', '73'),
(195, 'B+', '0 Bags', '73'),
(196, 'B-', '0 Bags', '73'),
(197, 'AB+', '0 Bags', '73'),
(198, 'AB-', '0 Bags', '73'),
(199, 'O+', '0 Bags', '73'),
(200, 'O-', '0 Bags', '73'),
(201, 'A+', '0 Bags', '74'),
(202, 'A-', '0 Bags', '74'),
(203, 'B+', '0 Bags', '74'),
(204, 'B-', '0 Bags', '74'),
(205, 'AB+', '0 Bags', '74'),
(206, 'AB-', '0 Bags', '74'),
(207, 'O+', '0 Bags', '74'),
(208, 'O-', '0 Bags', '74'),
(209, 'A+', '0 Bags', '75'),
(210, 'A-', '0 Bags', '75'),
(211, 'B+', '0 Bags', '75'),
(212, 'B-', '0 Bags', '75'),
(213, 'AB+', '0 Bags', '75'),
(214, 'AB-', '0 Bags', '75'),
(215, 'O+', '0 Bags', '75'),
(216, 'O-', '0 Bags', '75'),
(217, 'A+', '0 Bags', '76'),
(218, 'A-', '0 Bags', '76'),
(219, 'B+', '0 Bags', '76'),
(220, 'B-', '0 Bags', '76'),
(221, 'AB+', '0 Bags', '76'),
(222, 'AB-', '0 Bags', '76'),
(223, 'O+', '0 Bags', '76'),
(224, 'O-', '0 Bags', '76'),
(225, 'A+', '0 Bags', '77'),
(226, 'A-', '0 Bags', '77'),
(227, 'B+', '0 Bags', '77'),
(228, 'B-', '0 Bags', '77'),
(229, 'AB+', '0 Bags', '77'),
(230, 'AB-', '0 Bags', '77'),
(231, 'O+', '0 Bags', '77'),
(232, 'O-', '0 Bags', '77'),
(233, 'A+', '0 Bags', '78'),
(234, 'A-', '0 Bags', '78'),
(235, 'B+', '0 Bags', '78'),
(236, 'B-', '0 Bags', '78'),
(237, 'AB+', '0 Bags', '78'),
(238, 'AB-', '0 Bags', '78'),
(239, 'O+', '0 Bags', '78'),
(240, 'O-', '0 Bags', '78'),
(241, 'A+', '0 Bags', '79'),
(242, 'A-', '0 Bags', '79'),
(243, 'B+', '0 Bags', '79'),
(244, 'B-', '0 Bags', '79'),
(245, 'AB+', '0 Bags', '79'),
(246, 'AB-', '0 Bags', '79'),
(247, 'O+', '0 Bags', '79'),
(248, 'O-', '0 Bags', '79'),
(249, 'A+', '0 Bags', '82'),
(250, 'A-', '0 Bags', '82'),
(251, 'B+', '0 Bags', '82'),
(252, 'B-', '0 Bags', '82'),
(253, 'AB+', '0 Bags', '82'),
(254, 'AB-', '0 Bags', '82'),
(255, 'O+', '0 Bags', '82'),
(256, 'O-', '0 Bags', '82'),
(257, 'A+', '0 Bags', NULL),
(258, 'A-', '0 Bags', NULL),
(259, 'B+', '0 Bags', NULL),
(260, 'B-', '0 Bags', NULL),
(261, 'AB+', '0 Bags', NULL),
(262, 'AB-', '0 Bags', NULL),
(263, 'O+', '0 Bags', NULL),
(264, 'O-', '0 Bags', NULL),
(265, 'A+', '0 Bags', NULL),
(266, 'A-', '0 Bags', NULL),
(267, 'B+', '0 Bags', NULL),
(268, 'B-', '0 Bags', NULL),
(269, 'AB+', '0 Bags', NULL),
(270, 'AB-', '0 Bags', NULL),
(271, 'O+', '0 Bags', NULL),
(272, 'O-', '0 Bags', NULL),
(273, 'A+', '0 Bags', NULL),
(274, 'A-', '0 Bags', NULL),
(275, 'B+', '0 Bags', NULL),
(276, 'B-', '0 Bags', NULL),
(277, 'AB+', '0 Bags', NULL),
(278, 'AB-', '0 Bags', NULL),
(279, 'O+', '0 Bags', NULL),
(280, 'O-', '0 Bags', NULL),
(281, 'A+', '0 Bags', NULL),
(282, 'A-', '0 Bags', NULL),
(283, 'B+', '0 Bags', NULL),
(284, 'B-', '0 Bags', NULL),
(285, 'AB+', '0 Bags', NULL),
(286, 'AB-', '0 Bags', NULL),
(287, 'O+', '0 Bags', NULL),
(288, 'O-', '0 Bags', NULL),
(289, 'A+', '0 Bags', '83'),
(290, 'A-', '0 Bags', '83'),
(291, 'B+', '0 Bags', '83'),
(292, 'B-', '0 Bags', '83'),
(293, 'AB+', '0 Bags', '83'),
(294, 'AB-', '0 Bags', '83'),
(295, 'O+', '0 Bags', '83'),
(296, 'O-', '0 Bags', '83'),
(297, 'A+', '0 Bags', '84'),
(298, 'A-', '0 Bags', '84'),
(299, 'B+', '0 Bags', '84'),
(300, 'B-', '0 Bags', '84'),
(301, 'AB+', '0 Bags', '84'),
(302, 'AB-', '0 Bags', '84'),
(303, 'O+', '0 Bags', '84'),
(304, 'O-', '0 Bags', '84'),
(305, 'A+', '0 Bags', '85'),
(306, 'A-', '0 Bags', '85'),
(307, 'B+', '0 Bags', '85'),
(308, 'B-', '0 Bags', '85'),
(309, 'AB+', '0 Bags', '85'),
(310, 'AB-', '0 Bags', '85'),
(311, 'O+', '0 Bags', '85'),
(312, 'O-', '0 Bags', '85'),
(313, 'A+', '0 Bags', '86'),
(314, 'A-', '0 Bags', '86'),
(315, 'B+', '0 Bags', '86'),
(316, 'B-', '0 Bags', '86'),
(317, 'AB+', '0 Bags', '86'),
(318, 'AB-', '0 Bags', '86'),
(319, 'O+', '0 Bags', '86'),
(320, 'O-', '0 Bags', '86'),
(321, 'A+', '0 Bags', '87'),
(322, 'A-', '0 Bags', '87'),
(323, 'B+', '0 Bags', '87'),
(324, 'B-', '0 Bags', '87'),
(325, 'AB+', '0 Bags', '87'),
(326, 'AB-', '0 Bags', '87'),
(327, 'O+', '0 Bags', '87'),
(328, 'O-', '0 Bags', '87'),
(329, 'A+', '0 Bags', '88'),
(330, 'A-', '0 Bags', '88'),
(331, 'B+', '0 Bags', '88'),
(332, 'B-', '0 Bags', '88'),
(333, 'AB+', '0 Bags', '88'),
(334, 'AB-', '0 Bags', '88'),
(335, 'O+', '0 Bags', '88'),
(336, 'O-', '0 Bags', '88'),
(337, 'A+', '0 Bags', '89'),
(338, 'A-', '0 Bags', '89'),
(339, 'B+', '0 Bags', '89'),
(340, 'B-', '0 Bags', '89'),
(341, 'AB+', '0 Bags', '89'),
(342, 'AB-', '0 Bags', '89'),
(343, 'O+', '0 Bags', '89'),
(344, 'O-', '0 Bags', '89'),
(345, 'A+', '0 Bags', '90'),
(346, 'A-', '0 Bags', '90'),
(347, 'B+', '0 Bags', '90'),
(348, 'B-', '0 Bags', '90'),
(349, 'AB+', '0 Bags', '90'),
(350, 'AB-', '0 Bags', '90'),
(351, 'O+', '0 Bags', '90'),
(352, 'O-', '0 Bags', '90'),
(353, 'A+', '0 Bags', '91'),
(354, 'A-', '0 Bags', '91'),
(355, 'B+', '0 Bags', '91'),
(356, 'B-', '0 Bags', '91'),
(357, 'AB+', '0 Bags', '91'),
(358, 'AB-', '0 Bags', '91'),
(359, 'O+', '0 Bags', '91'),
(360, 'O-', '0 Bags', '91'),
(361, 'A+', '0 Bags', '92'),
(362, 'A-', '0 Bags', '92'),
(363, 'B+', '0 Bags', '92'),
(364, 'B-', '0 Bags', '92'),
(365, 'AB+', '0 Bags', '92'),
(366, 'AB-', '0 Bags', '92'),
(367, 'O+', '0 Bags', '92'),
(368, 'O-', '0 Bags', '92'),
(369, 'A+', '0 Bags', '93'),
(370, 'A-', '0 Bags', '93'),
(371, 'B+', '0 Bags', '93'),
(372, 'B-', '0 Bags', '93'),
(373, 'AB+', '0 Bags', '93'),
(374, 'AB-', '0 Bags', '93'),
(375, 'O+', '0 Bags', '93'),
(376, 'O-', '0 Bags', '93'),
(377, 'A+', '0 Bags', '94'),
(378, 'A-', '0 Bags', '94'),
(379, 'B+', '0 Bags', '94'),
(380, 'B-', '0 Bags', '94'),
(381, 'AB+', '0 Bags', '94'),
(382, 'AB-', '0 Bags', '94'),
(383, 'O+', '0 Bags', '94'),
(384, 'O-', '0 Bags', '94'),
(385, 'A+', '0 Bags', '95'),
(386, 'A-', '0 Bags', '95'),
(387, 'B+', '0 Bags', '95'),
(388, 'B-', '0 Bags', '95'),
(389, 'AB+', '0 Bags', '95'),
(390, 'AB-', '0 Bags', '95'),
(391, 'O+', '0 Bags', '95'),
(392, 'O-', '0 Bags', '95'),
(393, 'A+', '0 Bags', '96'),
(394, 'A-', '0 Bags', '96'),
(395, 'B+', '0 Bags', '96'),
(396, 'B-', '0 Bags', '96'),
(397, 'AB+', '0 Bags', '96'),
(398, 'AB-', '0 Bags', '96'),
(399, 'O+', '0 Bags', '96'),
(400, 'O-', '0 Bags', '96'),
(401, 'A+', '0 Bags', '97'),
(402, 'A-', '0 Bags', '97'),
(403, 'B+', '0 Bags', '97'),
(404, 'B-', '0 Bags', '97'),
(405, 'AB+', '0 Bags', '97'),
(406, 'AB-', '0 Bags', '97'),
(407, 'O+', '0 Bags', '97'),
(408, 'O-', '0 Bags', '97'),
(409, 'A+', '0 Bags', '98'),
(410, 'A-', '0 Bags', '98'),
(411, 'B+', '0 Bags', '98'),
(412, 'B-', '0 Bags', '98'),
(413, 'AB+', '0 Bags', '98'),
(414, 'AB-', '0 Bags', '98'),
(415, 'O+', '0 Bags', '98'),
(416, 'O-', '10 Bags', '98'),
(417, 'A+', '0 Bags', '99'),
(418, 'A-', '0 Bags', '99'),
(419, 'B+', '0 Bags', '99'),
(420, 'B-', '0 Bags', '99'),
(421, 'AB+', '0 Bags', '99'),
(422, 'AB-', '0 Bags', '99'),
(423, 'O+', '0 Bags', '99'),
(424, 'O-', '0 Bags', '99'),
(425, 'A+', '0 Bags', '100'),
(426, 'A-', '0 Bags', '100'),
(427, 'B+', '0 Bags', '100'),
(428, 'B-', '0 Bags', '100'),
(429, 'AB+', '0 Bags', '100'),
(430, 'AB-', '0 Bags', '100'),
(431, 'O+', '0 Bags', '100'),
(432, 'O-', '0 Bags', '100'),
(433, 'A+', '0 Bags', '101'),
(434, 'A-', '0 Bags', '101'),
(435, 'B+', '0 Bags', '101'),
(436, 'B-', '0 Bags', '101'),
(437, 'AB+', '0 Bags', '101'),
(438, 'AB-', '0 Bags', '101'),
(439, 'O+', '0 Bags', '101'),
(440, 'O-', '0 Bags', '101'),
(441, 'A+', '0 Bags', '102'),
(442, 'A-', '0 Bags', '102'),
(443, 'B+', '0 Bags', '102'),
(444, 'B-', '0 Bags', '102'),
(445, 'AB+', '0 Bags', '102'),
(446, 'AB-', '0 Bags', '102'),
(447, 'O+', '0 Bags', '102'),
(448, 'O-', '0 Bags', '102'),
(449, 'A+', '0 Bags', '103'),
(450, 'A-', '0 Bags', '103'),
(451, 'B+', '0 Bags', '103'),
(452, 'B-', '0 Bags', '103'),
(453, 'AB+', '0 Bags', '103'),
(454, 'AB-', '0 Bags', '103'),
(455, 'O+', '0 Bags', '103'),
(456, 'O-', '0 Bags', '103'),
(457, 'A+', '0 Bags', '104'),
(458, 'A-', '0 Bags', '104'),
(459, 'B+', '0 Bags', '104'),
(460, 'B-', '0 Bags', '104'),
(461, 'AB+', '0 Bags', '104'),
(462, 'AB-', '0 Bags', '104'),
(463, 'O+', '0 Bags', '104'),
(464, 'O-', '0 Bags', '104'),
(465, 'A+', '0 Bags', '105'),
(466, 'A-', '0 Bags', '105'),
(467, 'B+', '0 Bags', '105'),
(468, 'B-', '0 Bags', '105'),
(469, 'AB+', '0 Bags', '105'),
(470, 'AB-', '0 Bags', '105'),
(471, 'O+', '0 Bags', '105'),
(472, 'O-', '0 Bags', '105'),
(473, 'A+', '0 Bags', '106'),
(474, 'A-', '0 Bags', '106'),
(475, 'B+', '0 Bags', '106'),
(476, 'B-', '0 Bags', '106'),
(477, 'AB+', '0 Bags', '106'),
(478, 'AB-', '0 Bags', '106'),
(479, 'O+', '0 Bags', '106'),
(480, 'O-', '0 Bags', '106'),
(481, 'A+', '0 Bags', '107'),
(482, 'A-', '0 Bags', '107'),
(483, 'B+', '0 Bags', '107'),
(484, 'B-', '0 Bags', '107'),
(485, 'AB+', '0 Bags', '107'),
(486, 'AB-', '0 Bags', '107'),
(487, 'O+', '0 Bags', '107'),
(488, 'O-', '0 Bags', '107'),
(489, 'A+', '0 Bags', '108'),
(490, 'A-', '0 Bags', '108'),
(491, 'B+', '0 Bags', '108'),
(492, 'B-', '0 Bags', '108'),
(493, 'AB+', '0 Bags', '108'),
(494, 'AB-', '0 Bags', '108'),
(495, 'O+', '0 Bags', '108'),
(496, 'O-', '0 Bags', '108'),
(497, 'A+', '0 Bags', '109'),
(498, 'A-', '0 Bags', '109'),
(499, 'B+', '0 Bags', '109'),
(500, 'B-', '0 Bags', '109'),
(501, 'AB+', '0 Bags', '109'),
(502, 'AB-', '0 Bags', '109'),
(503, 'O+', '0 Bags', '109'),
(504, 'O-', '0 Bags', '109'),
(505, 'A+', '0 Bags', '110'),
(506, 'A-', '0 Bags', '110'),
(507, 'B+', '0 Bags', '110'),
(508, 'B-', '0 Bags', '110'),
(509, 'AB+', '0 Bags', '110'),
(510, 'AB-', '0 Bags', '110'),
(511, 'O+', '0 Bags', '110'),
(512, 'O-', '0 Bags', '110'),
(513, 'A+', '0 Bags', '111'),
(514, 'A-', '0 Bags', '111'),
(515, 'B+', '0 Bags', '111'),
(516, 'B-', '0 Bags', '111'),
(517, 'AB+', '0 Bags', '111'),
(518, 'AB-', '0 Bags', '111'),
(519, 'O+', '0 Bags', '111'),
(520, 'O-', '0 Bags', '111'),
(521, 'A+', '0 Bags', '112'),
(522, 'A-', '0 Bags', '112'),
(523, 'B+', '0 Bags', '112'),
(524, 'B-', '0 Bags', '112'),
(525, 'AB+', '0 Bags', '112'),
(526, 'AB-', '0 Bags', '112'),
(527, 'O+', '0 Bags', '112'),
(528, 'O-', '0 Bags', '112'),
(529, 'A+', '0 Bags', '113'),
(530, 'A-', '0 Bags', '113'),
(531, 'B+', '0 Bags', '113'),
(532, 'B-', '0 Bags', '113'),
(533, 'AB+', '0 Bags', '113'),
(534, 'AB-', '0 Bags', '113'),
(535, 'O+', '0 Bags', '113'),
(536, 'O-', '0 Bags', '113'),
(537, 'A+', '0 Bags', '114'),
(538, 'A-', '0 Bags', '114'),
(539, 'B+', '0 Bags', '114'),
(540, 'B-', '0 Bags', '114'),
(541, 'AB+', '0 Bags', '114'),
(542, 'AB-', '0 Bags', '114'),
(543, 'O+', '0 Bags', '114'),
(544, 'O-', '0 Bags', '114'),
(545, 'A+', '0 Bags', '115'),
(546, 'A-', '0 Bags', '115'),
(547, 'B+', '0 Bags', '115'),
(548, 'B-', '0 Bags', '115'),
(549, 'AB+', '0 Bags', '115'),
(550, 'AB-', '0 Bags', '115'),
(551, 'O+', '0 Bags', '115'),
(552, 'O-', '0 Bags', '115'),
(553, 'A+', '0 Bags', '116'),
(554, 'A-', '0 Bags', '116'),
(555, 'B+', '0 Bags', '116'),
(556, 'B-', '0 Bags', '116'),
(557, 'AB+', '0 Bags', '116'),
(558, 'AB-', '0 Bags', '116'),
(559, 'O+', '0 Bags', '116'),
(560, 'O-', '0 Bags', '116'),
(561, 'A+', '0 Bags', '117'),
(562, 'A-', '0 Bags', '117'),
(563, 'B+', '0 Bags', '117'),
(564, 'B-', '0 Bags', '117'),
(565, 'AB+', '0 Bags', '117'),
(566, 'AB-', '0 Bags', '117'),
(567, 'O+', '0 Bags', '117'),
(568, 'O-', '0 Bags', '117'),
(569, 'A+', '0 Bags', '118'),
(570, 'A-', '0 Bags', '118'),
(571, 'B+', '0 Bags', '118'),
(572, 'B-', '0 Bags', '118'),
(573, 'AB+', '0 Bags', '118'),
(574, 'AB-', '0 Bags', '118'),
(575, 'O+', '0 Bags', '118'),
(576, 'O-', '0 Bags', '118'),
(577, 'A+', '0 Bags', '119'),
(578, 'A-', '0 Bags', '119'),
(579, 'B+', '0 Bags', '119'),
(580, 'B-', '0 Bags', '119'),
(581, 'AB+', '0 Bags', '119'),
(582, 'AB-', '0 Bags', '119'),
(583, 'O+', '0 Bags', '119'),
(584, 'O-', '0 Bags', '119'),
(585, 'A+', '0 Bags', '120'),
(586, 'A-', '0 Bags', '120'),
(587, 'B+', '0 Bags', '120'),
(588, 'B-', '0 Bags', '120'),
(589, 'AB+', '0 Bags', '120'),
(590, 'AB-', '0 Bags', '120'),
(591, 'O+', '0 Bags', '120'),
(592, 'O-', '0 Bags', '120'),
(593, 'A+', '0 Bags', '121'),
(594, 'A-', '0 Bags', '121'),
(595, 'B+', '0 Bags', '121'),
(596, 'B-', '0 Bags', '121'),
(597, 'AB+', '0 Bags', '121'),
(598, 'AB-', '0 Bags', '121'),
(599, 'O+', '0 Bags', '121'),
(600, 'O-', '0 Bags', '121'),
(601, 'A+', '0 Bags', '122'),
(602, 'A-', '0 Bags', '122'),
(603, 'B+', '0 Bags', '122'),
(604, 'B-', '0 Bags', '122'),
(605, 'AB+', '0 Bags', '122'),
(606, 'AB-', '0 Bags', '122'),
(607, 'O+', '0 Bags', '122'),
(608, 'O-', '0 Bags', '122'),
(609, 'A+', '0 Bags', '123'),
(610, 'A-', '0 Bags', '123'),
(611, 'B+', '0 Bags', '123'),
(612, 'B-', '0 Bags', '123'),
(613, 'AB+', '0 Bags', '123'),
(614, 'AB-', '0 Bags', '123'),
(615, 'O+', '0 Bags', '123'),
(616, 'O-', '0 Bags', '123'),
(617, 'A+', '0 Bags', '124'),
(618, 'A-', '0 Bags', '124'),
(619, 'B+', '0 Bags', '124'),
(620, 'B-', '0 Bags', '124'),
(621, 'AB+', '0 Bags', '124'),
(622, 'AB-', '0 Bags', '124'),
(623, 'O+', '0 Bags', '124'),
(624, 'O-', '0 Bags', '124'),
(625, 'A+', '0 Bags', '125'),
(626, 'A-', '0 Bags', '125'),
(627, 'B+', '0 Bags', '125'),
(628, 'B-', '0 Bags', '125'),
(629, 'AB+', '0 Bags', '125'),
(630, 'AB-', '0 Bags', '125'),
(631, 'O+', '0 Bags', '125'),
(632, 'O-', '0 Bags', '125'),
(633, 'A+', '0 Bags', '126'),
(634, 'A-', '0 Bags', '126'),
(635, 'B+', '0 Bags', '126'),
(636, 'B-', '0 Bags', '126'),
(637, 'AB+', '0 Bags', '126'),
(638, 'AB-', '0 Bags', '126'),
(639, 'O+', '0 Bags', '126'),
(640, 'O-', '0 Bags', '126'),
(641, 'A+', '0 Bags', '127'),
(642, 'A-', '0 Bags', '127'),
(643, 'B+', '0 Bags', '127'),
(644, 'B-', '0 Bags', '127'),
(645, 'AB+', '0 Bags', '127'),
(646, 'AB-', '0 Bags', '127'),
(647, 'O+', '0 Bags', '127'),
(648, 'O-', '0 Bags', '127'),
(649, 'A+', '0 Bags', '128'),
(650, 'A-', '0 Bags', '128'),
(651, 'B+', '0 Bags', '128'),
(652, 'B-', '0 Bags', '128'),
(653, 'AB+', '0 Bags', '128'),
(654, 'AB-', '0 Bags', '128'),
(655, 'O+', '0 Bags', '128'),
(656, 'O-', '0 Bags', '128'),
(657, 'A+', '0 Bags', '129'),
(658, 'A-', '0 Bags', '129'),
(659, 'B+', '0 Bags', '129'),
(660, 'B-', '0 Bags', '129'),
(661, 'AB+', '0 Bags', '129'),
(662, 'AB-', '0 Bags', '129'),
(663, 'O+', '0 Bags', '129'),
(664, 'O-', '0 Bags', '129'),
(665, 'A+', '0 Bags', '130'),
(666, 'A-', '0 Bags', '130'),
(667, 'B+', '0 Bags', '130'),
(668, 'B-', '0 Bags', '130'),
(669, 'AB+', '0 Bags', '130'),
(670, 'AB-', '0 Bags', '130'),
(671, 'O+', '0 Bags', '130'),
(672, 'O-', '0 Bags', '130'),
(673, 'A+', '0 Bags', '131'),
(674, 'A-', '0 Bags', '131'),
(675, 'B+', '0 Bags', '131'),
(676, 'B-', '0 Bags', '131'),
(677, 'AB+', '0 Bags', '131'),
(678, 'AB-', '0 Bags', '131'),
(679, 'O+', '0 Bags', '131'),
(680, 'O-', '0 Bags', '131'),
(681, 'A+', '0 Bags', '132'),
(682, 'A-', '0 Bags', '132'),
(683, 'B+', '0 Bags', '132'),
(684, 'B-', '0 Bags', '132'),
(685, 'AB+', '0 Bags', '132'),
(686, 'AB-', '0 Bags', '132'),
(687, 'O+', '0 Bags', '132'),
(688, 'O-', '0 Bags', '132'),
(689, 'A+', '0 Bags', '133'),
(690, 'A-', '0 Bags', '133'),
(691, 'B+', '0 Bags', '133'),
(692, 'B-', '0 Bags', '133'),
(693, 'AB+', '0 Bags', '133'),
(694, 'AB-', '0 Bags', '133'),
(695, 'O+', '0 Bags', '133'),
(696, 'O-', '0 Bags', '133'),
(697, 'A+', '0 Bags', '134'),
(698, 'A-', '0 Bags', '134'),
(699, 'B+', '0 Bags', '134'),
(700, 'B-', '0 Bags', '134'),
(701, 'AB+', '0 Bags', '134'),
(702, 'AB-', '0 Bags', '134'),
(703, 'O+', '0 Bags', '134'),
(704, 'O-', '0 Bags', '134'),
(705, 'A+', '0 Bags', '135'),
(706, 'A-', '0 Bags', '135'),
(707, 'B+', '0 Bags', '135'),
(708, 'B-', '0 Bags', '135'),
(709, 'AB+', '0 Bags', '135'),
(710, 'AB-', '0 Bags', '135'),
(711, 'O+', '0 Bags', '135'),
(712, 'O-', '0 Bags', '135'),
(713, 'A+', '0 Bags', '136'),
(714, 'A-', '0 Bags', '136'),
(715, 'B+', '0 Bags', '136'),
(716, 'B-', '0 Bags', '136'),
(717, 'AB+', '0 Bags', '136'),
(718, 'AB-', '0 Bags', '136'),
(719, 'O+', '0 Bags', '136'),
(720, 'O-', '0 Bags', '136'),
(721, 'A+', '0 Bags', '137'),
(722, 'A-', '0 Bags', '137'),
(723, 'B+', '0 Bags', '137'),
(724, 'B-', '0 Bags', '137'),
(725, 'AB+', '0 Bags', '137'),
(726, 'AB-', '0 Bags', '137'),
(727, 'O+', '0 Bags', '137'),
(728, 'O-', '0 Bags', '137'),
(729, 'A+', '0 Bags', '138'),
(730, 'A-', '0 Bags', '138'),
(731, 'B+', '0 Bags', '138'),
(732, 'B-', '0 Bags', '138'),
(733, 'AB+', '0 Bags', '138'),
(734, 'AB-', '0 Bags', '138'),
(735, 'O+', '0 Bags', '138'),
(736, 'O-', '0 Bags', '138'),
(737, 'A+', '0 Bags', '139'),
(738, 'A-', '0 Bags', '139'),
(739, 'B+', '0 Bags', '139'),
(740, 'B-', '0 Bags', '139'),
(741, 'AB+', '0 Bags', '139'),
(742, 'AB-', '0 Bags', '139'),
(743, 'O+', '0 Bags', '139'),
(744, 'O-', '0 Bags', '139');

-- --------------------------------------------------------

--
-- Table structure for table `bed`
--

CREATE TABLE `bed` (
  `id` int(10) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `number` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `last_a_time` varchar(100) DEFAULT NULL,
  `last_d_time` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `bed_id` varchar(100) DEFAULT NULL,
  `current_allotment_id` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bed_category`
--

CREATE TABLE `bed_category` (
  `id` int(100) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bed_category`
--

INSERT INTO `bed_category` (`id`, `category`, `description`, `hospital_id`) VALUES
(6, 'Room 302', 'Room 203', '133');

-- --------------------------------------------------------

--
-- Table structure for table `bed_checkout`
--

CREATE TABLE `bed_checkout` (
  `id` int(100) NOT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `final_diagnosis` varchar(1000) DEFAULT NULL,
  `anatomopatologic_diagnosis` varchar(1000) DEFAULT NULL,
  `dikordance` varchar(1000) DEFAULT NULL,
  `alloted_bed_id` varchar(1000) DEFAULT NULL,
  `doctor` varchar(1000) DEFAULT NULL,
  `epicrisis` varchar(1000) DEFAULT NULL,
  `checkout_state` varchar(1000) DEFAULT NULL,
  `checkout_diagnosis` varchar(1000) DEFAULT NULL,
  `instruction` varchar(1000) DEFAULT NULL,
  `medicine_to_take` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bed_checkout`
--

INSERT INTO `bed_checkout` (`id`, `date`, `final_diagnosis`, `anatomopatologic_diagnosis`, `dikordance`, `alloted_bed_id`, `doctor`, `epicrisis`, `checkout_state`, `checkout_diagnosis`, `instruction`, `medicine_to_take`, `hospital_id`) VALUES
(22, '09 November 2022 - 04:05 PM', ' ljbkj', ' ', NULL, '76', NULL, ' ', ' ', ' ', '', '', '98'),
(23, '2025-01-12 13:15', ' cxvcxvcxv', ' xcvxcvxc', NULL, '91', '44', ' xcvxcv', ' xcvxcvx', ' xcvxcvx', '<p>xcvcxvxcv</p>', '<p>xcvcxvxcv</p>', '98'),
(24, '2025-01-12 13:20', ' sdfdsfdsf', ' sdfsdf', NULL, '92', '44', ' sdfsdf', ' fsdfsf', ' sfsdf', '<p>sdfdsf</p>', '<p>fsdfsdf</p>', '98');

-- --------------------------------------------------------

--
-- Table structure for table `bed_diagnostic`
--

CREATE TABLE `bed_diagnostic` (
  `id` int(100) NOT NULL,
  `date` varchar(100) DEFAULT NULL,
  `nurse` varchar(100) DEFAULT NULL,
  `payment_procedure` varchar(500) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `quantity` varchar(100) DEFAULT NULL,
  `total` varchar(100) DEFAULT NULL,
  `alloted_bed_id` varchar(100) DEFAULT NULL,
  `payment_id` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bed_diagnostic`
--

INSERT INTO `bed_diagnostic` (`id`, `date`, `nurse`, `payment_procedure`, `price`, `quantity`, `total`, `alloted_bed_id`, `payment_id`, `hospital_id`) VALUES
(85, '1670401902', NULL, '66', '500', '1', '500', '76', '278', '98');

-- --------------------------------------------------------

--
-- Table structure for table `bed_medicine`
--

CREATE TABLE `bed_medicine` (
  `id` int(100) NOT NULL,
  `generic_name` varchar(1000) DEFAULT NULL,
  `medicine_name` varchar(1000) DEFAULT NULL,
  `medicine_id` varchar(1000) DEFAULT NULL,
  `s_price` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL,
  `quantity` varchar(1000) DEFAULT NULL,
  `total` varchar(1000) DEFAULT NULL,
  `alloted_bed_id` varchar(1000) DEFAULT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `payment_id` varchar(1000) DEFAULT NULL,
  `medicine_pharmacy_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bed_service`
--

CREATE TABLE `bed_service` (
  `id` int(100) NOT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `nurse` varchar(1000) DEFAULT NULL,
  `service` varchar(1000) DEFAULT NULL,
  `price` varchar(1000) DEFAULT NULL,
  `quantity` varchar(100) DEFAULT NULL,
  `total` varchar(100) DEFAULT NULL,
  `alloted_bed_id` varchar(1000) DEFAULT NULL,
  `payment_id` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blood_group`
--

CREATE TABLE `blood_group` (
  `id` int(100) NOT NULL,
  `bloodgroup` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `blood_group`
--

INSERT INTO `blood_group` (`id`, `bloodgroup`) VALUES
(1, 'A+'),
(2, 'O+'),
(3, 'B+'),
(4, 'AB+'),
(5, 'A-'),
(6, 'O-'),
(7, 'B-'),
(8, 'AB-');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(100) NOT NULL,
  `category` varchar(1000) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category`, `description`, `hospital_id`) VALUES
(11, 'Blood Test', 'Blood Test', '98'),
(12, 'Pathology', 'Pathology', '133');

-- --------------------------------------------------------

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` int(100) NOT NULL,
  `sender_id` varchar(100) DEFAULT NULL,
  `receiver_id` varchar(100) DEFAULT NULL,
  `chat_text` text DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `date_time` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `chat`
--

INSERT INTO `chat` (`id`, `sender_id`, `receiver_id`, `chat_text`, `status`, `date_time`) VALUES
(3, '992', '998', 'Hi', 'read', '2022-07-23 09:44:48'),
(4, '992', '998', 'How are you?', 'read', '2022-09-08 16:00:14'),
(5, '992', '998', 'fvbjkdbvkd', 'read', '2023-03-12 12:56:47'),
(6, '992', '997', 'jdbkbfv', 'read', '2023-03-12 12:57:28'),
(7, '992', '999', 'hi', 'read', '2025-01-06 14:04:07'),
(8, '999', '992', 'hello', 'read', '2025-01-06 14:04:55'),
(9, '999', '1140', 'hi Mr Opu', 'unread', '2025-01-13 13:33:04');

-- --------------------------------------------------------

--
-- Table structure for table `daily_progress`
--

CREATE TABLE `daily_progress` (
  `id` int(100) NOT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `datestamp` varchar(1000) DEFAULT NULL,
  `daily_description` varchar(1000) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `alloted_bed_id` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL,
  `time` varchar(1000) DEFAULT NULL,
  `nurse` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int(10) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `x` varchar(10) DEFAULT NULL,
  `y` varchar(10) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `diagnosis`
--

CREATE TABLE `diagnosis` (
  `id` int(100) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `disease_with_outbreak_potential` varchar(100) DEFAULT NULL,
  `maximum_expected_number_of_patient_in_a_week` varchar(255) DEFAULT NULL,
  `hospital_id` int(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `diagnosis`
--

INSERT INTO `diagnosis` (`id`, `name`, `description`, `code`, `disease_with_outbreak_potential`, `maximum_expected_number_of_patient_in_a_week`, `hospital_id`) VALUES
(8, 'Dengue', '<p>ICD-10 code&nbsp;<strong>A90</strong>&nbsp;for Dengue fever [classical dengue] is a medical classification as listed by WHO under the range - Certain infectious and parasitic diseases .</p>', 'A90', '1', '1', 98);

-- --------------------------------------------------------

--
-- Table structure for table `diagnostic_report`
--

CREATE TABLE `diagnostic_report` (
  `id` int(100) NOT NULL,
  `date` varchar(100) DEFAULT NULL,
  `invoice` varchar(100) DEFAULT NULL,
  `report` varchar(10000) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `doctor`
--

CREATE TABLE `doctor` (
  `id` int(10) NOT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `profile` varchar(1000) DEFAULT NULL,
  `x` varchar(100) DEFAULT NULL,
  `y` varchar(10) DEFAULT NULL,
  `ion_user_id` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `department_name` varchar(1000) DEFAULT NULL,
  `appointment_confirmation` varchar(1000) DEFAULT NULL,
  `signature` varchar(1000) DEFAULT NULL,
  `language` varchar(300) DEFAULT NULL,
  `available` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `doctor`
--

INSERT INTO `doctor` (`id`, `img_url`, `name`, `email`, `address`, `phone`, `department`, `profile`, `x`, `y`, `ion_user_id`, `hospital_id`, `department_name`, `appointment_confirmation`, `signature`, `language`, `available`) VALUES
(27, NULL, 'Demo Doctor', 'doctor1@hms.com', 'Binodpur, Rajbari', '01749335505', NULL, '<p>sdfdsf</p>', NULL, NULL, '1070', '114', NULL, 'Active', NULL, NULL, NULL),
(44, 'uploads/UntitledDesign-removebg-preview.png', 'Mr Doctor', 'doctor@hms.com', 'Bashundhara, Dhaka', '01749335508', '30', '<p>sdfsfsdf</p>', NULL, NULL, '1131', '98', 'Medicine', 'Active', 'uploads/d382ea39-715e-4a42-ad8a-0c5090ce43a0-removebg-preview.png', NULL, '1'),
(42, NULL, 'Dr Rahmatullah', 'rahmatullah@example.com', NULL, '1234556788', NULL, NULL, NULL, NULL, '1114', '133', NULL, 'Active', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `doctor_visit`
--

CREATE TABLE `doctor_visit` (
  `id` int(100) NOT NULL,
  `doctor_id` varchar(1000) DEFAULT NULL,
  `doctor_name` varchar(1000) DEFAULT NULL,
  `visit_description` varchar(1000) DEFAULT NULL,
  `visit_charges` varchar(1000) DEFAULT NULL,
  `status` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `doctor_visit`
--

INSERT INTO `doctor_visit` (`id`, `doctor_id`, `doctor_name`, `visit_description`, `visit_charges`, `status`, `hospital_id`) VALUES
(18, '44', 'Mr Doctor', '2nd visit', '500', 'active', '98');

-- --------------------------------------------------------

--
-- Table structure for table `donor`
--

CREATE TABLE `donor` (
  `id` int(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `group` varchar(10) DEFAULT NULL,
  `age` varchar(10) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `ldd` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `add_date` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `draft_payment`
--

CREATE TABLE `draft_payment` (
  `id` int(100) NOT NULL,
  `category_name` varchar(1000) DEFAULT NULL,
  `patient` varchar(1000) DEFAULT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `amount` varchar(1000) DEFAULT NULL,
  `doctor` varchar(1000) DEFAULT NULL,
  `discount` varchar(1000) DEFAULT NULL,
  `flat_discount` varchar(1000) DEFAULT NULL,
  `gross_total` varchar(1000) DEFAULT NULL,
  `user` varchar(1000) DEFAULT NULL,
  `patient_name` varchar(1000) DEFAULT NULL,
  `patient_phone` varchar(1000) DEFAULT NULL,
  `patient_address` varchar(1000) DEFAULT NULL,
  `patient_email` varchar(1000) DEFAULT NULL,
  `patient_gender` varchar(1000) DEFAULT NULL,
  `date_string` varchar(1000) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  `date_delivery` varchar(1000) DEFAULT NULL,
  `doctor_phone` varchar(1000) DEFAULT NULL,
  `age` varchar(100) DEFAULT NULL,
  `birthdate` varchar(100) DEFAULT NULL,
  `deposit_type` varchar(1000) DEFAULT NULL,
  `doctor_name` varchar(1000) DEFAULT NULL,
  `doctor_email` varchar(1000) DEFAULT NULL,
  `time_delivery` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `amount_received` varchar(100) DEFAULT NULL,
  `vat` varchar(100) DEFAULT NULL,
  `percent_discount` varchar(100) DEFAULT NULL,
  `vat_amount_percent` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email`
--

CREATE TABLE `email` (
  `id` int(100) NOT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `message` varchar(10000) DEFAULT NULL,
  `reciepient` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` int(100) NOT NULL,
  `admin_email` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `smtp_host` varchar(1000) DEFAULT NULL,
  `smtp_port` varchar(1000) DEFAULT NULL,
  `send_multipart` varchar(1000) DEFAULT NULL,
  `mail_provider` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `admin_email`, `type`, `user`, `password`, `hospital_id`, `smtp_host`, `smtp_port`, `send_multipart`, `mail_provider`) VALUES
(34, 'info@codearistos.nett', 'Domain Email', '', '', 'superadmin', '', '', '', NULL),
(190, NULL, 'Smtp', NULL, NULL, '9', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(191, 'Admin Email', 'Domain Email', NULL, NULL, '9', NULL, NULL, NULL, NULL),
(192, NULL, 'Smtp', NULL, NULL, '10', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(188, 'Admin Email', 'Domain Email', NULL, NULL, '8', NULL, NULL, NULL, NULL),
(189, 'rizvi.mahmud.plabon@gmail.com', NULL, NULL, NULL, 'contactus', NULL, NULL, NULL, NULL),
(187, NULL, 'Smtp', NULL, NULL, '8', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(186, 'Admin Email', 'Domain Email', NULL, NULL, '7', NULL, NULL, NULL, NULL),
(185, NULL, 'Smtp', NULL, NULL, '7', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(184, 'Admin Email', 'Domain Email', NULL, NULL, '6', NULL, NULL, NULL, NULL),
(183, NULL, 'Smtp', NULL, NULL, '6', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(182, 'Admin Email', 'Domain Email', NULL, NULL, '5', NULL, NULL, NULL, NULL),
(181, NULL, 'Smtp', NULL, NULL, '5', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(180, 'Admin Email', 'Domain Email', NULL, NULL, '4', NULL, NULL, NULL, NULL),
(178, 'Admin Email', 'Domain Email', NULL, NULL, '3', NULL, NULL, NULL, NULL),
(177, NULL, 'Smtp', NULL, NULL, '3', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(176, 'Admin Email', 'Domain Email', NULL, NULL, '2', NULL, NULL, NULL, NULL),
(175, NULL, 'Smtp', 'sahashaibal9@gmail.com', '', '2', 'smtp.gmail.com', '587', '1', 'gmail'),
(174, 'Admin Email', 'Domain Email', NULL, NULL, '1', NULL, NULL, NULL, NULL),
(179, NULL, 'Smtp', 'rizvi.mahmud.plabon@gmail.com@gmail.com', '', '4', 'smtp.gmail.com', '587', '1', 'gmail'),
(173, NULL, 'Smtp', 'sahashaibal22@gmail.com', '', '1', 'smtp.gmail.com', '587', '1', 'gmail'),
(193, 'Admin Email', 'Domain Email', NULL, NULL, '10', NULL, NULL, NULL, NULL),
(194, NULL, 'Smtp', NULL, NULL, '11', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(195, 'Admin Email', 'Domain Email', NULL, NULL, '11', NULL, NULL, NULL, NULL),
(196, NULL, 'Smtp', NULL, NULL, '12', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(197, 'Admin Email', 'Domain Email', NULL, NULL, '12', NULL, NULL, NULL, NULL),
(198, NULL, 'Smtp', NULL, NULL, '13', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(199, 'Admin Email', 'Domain Email', NULL, NULL, '13', NULL, NULL, NULL, NULL),
(200, NULL, 'Smtp', NULL, NULL, '14', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(201, 'Admin Email', 'Domain Email', NULL, NULL, '14', NULL, NULL, NULL, NULL),
(202, NULL, 'Smtp', NULL, NULL, '15', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(203, 'Admin Email', 'Domain Email', NULL, NULL, '15', NULL, NULL, NULL, NULL),
(204, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(205, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(206, NULL, 'Smtp', NULL, NULL, '64', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(207, 'Admin Email', 'Domain Email', NULL, NULL, '64', NULL, NULL, NULL, NULL),
(208, NULL, 'Smtp', NULL, NULL, '65', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(209, 'Admin Email', 'Domain Email', NULL, NULL, '65', NULL, NULL, NULL, NULL),
(210, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(211, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(212, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(213, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(214, NULL, 'Smtp', NULL, NULL, '69', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(215, 'Admin Email', 'Domain Email', NULL, NULL, '69', NULL, NULL, NULL, NULL),
(216, NULL, 'Smtp', NULL, NULL, '70', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(217, 'Admin Email', 'Domain Email', NULL, NULL, '70', NULL, NULL, NULL, NULL),
(218, NULL, 'Smtp', NULL, NULL, '71', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(219, 'Admin Email', 'Domain Email', NULL, NULL, '71', NULL, NULL, NULL, NULL),
(220, NULL, 'Smtp', NULL, NULL, '72', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(221, 'Admin Email', 'Domain Email', NULL, NULL, '72', NULL, NULL, NULL, NULL),
(222, NULL, 'Smtp', NULL, NULL, '73', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(223, 'Admin Email', 'Domain Email', NULL, NULL, '73', NULL, NULL, NULL, NULL),
(224, NULL, 'Smtp', NULL, NULL, '74', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(225, 'Admin Email', 'Domain Email', NULL, NULL, '74', NULL, NULL, NULL, NULL),
(226, NULL, 'Smtp', NULL, NULL, '75', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(227, 'Admin Email', 'Domain Email', NULL, NULL, '75', NULL, NULL, NULL, NULL),
(228, NULL, 'Smtp', NULL, NULL, '76', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(229, 'Admin Email', 'Domain Email', NULL, NULL, '76', NULL, NULL, NULL, NULL),
(230, NULL, 'Smtp', NULL, NULL, '77', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(231, 'Admin Email', 'Domain Email', NULL, NULL, '77', NULL, NULL, NULL, NULL),
(232, NULL, 'Smtp', NULL, NULL, '78', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(233, 'Admin Email', 'Domain Email', NULL, NULL, '78', NULL, NULL, NULL, NULL),
(234, NULL, 'Smtp', NULL, NULL, '79', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(235, 'Admin Email', 'Domain Email', NULL, NULL, '79', NULL, NULL, NULL, NULL),
(236, NULL, 'Smtp', NULL, NULL, '82', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(237, 'Admin Email', 'Domain Email', NULL, NULL, '82', NULL, NULL, NULL, NULL),
(238, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(239, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(240, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(241, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(242, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(243, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(244, NULL, 'Smtp', NULL, NULL, NULL, 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(245, 'Admin Email', 'Domain Email', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(246, NULL, 'Smtp', NULL, NULL, '83', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(247, 'Admin Email', 'Domain Email', NULL, NULL, '83', NULL, NULL, NULL, NULL),
(248, NULL, 'Smtp', NULL, NULL, '84', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(249, 'Admin Email', 'Domain Email', NULL, NULL, '84', NULL, NULL, NULL, NULL),
(250, NULL, 'Smtp', NULL, NULL, '85', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(251, 'Admin Email', 'Domain Email', NULL, NULL, '85', NULL, NULL, NULL, NULL),
(252, NULL, 'Smtp', NULL, NULL, '86', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(253, 'Admin Email', 'Domain Email', NULL, NULL, '86', NULL, NULL, NULL, NULL),
(254, NULL, 'Smtp', NULL, NULL, '87', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(255, 'Admin Email', 'Domain Email', NULL, NULL, '87', NULL, NULL, NULL, NULL),
(256, NULL, 'Smtp', NULL, NULL, '88', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(257, 'Admin Email', 'Domain Email', NULL, NULL, '88', NULL, NULL, NULL, NULL),
(258, NULL, 'Smtp', NULL, NULL, '89', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(259, 'Admin Email', 'Domain Email', NULL, NULL, '89', NULL, NULL, NULL, NULL),
(260, NULL, 'Smtp', NULL, NULL, '90', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(261, 'Admin Email', 'Domain Email', NULL, NULL, '90', NULL, NULL, NULL, NULL),
(262, NULL, 'Smtp', NULL, NULL, '91', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(263, 'Admin Email', 'Domain Email', NULL, NULL, '91', NULL, NULL, NULL, NULL),
(264, NULL, 'Smtp', NULL, NULL, '92', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(265, 'Admin Email', 'Domain Email', NULL, NULL, '92', NULL, NULL, NULL, NULL),
(266, NULL, 'Smtp', NULL, NULL, '93', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(267, 'Admin Email', 'Domain Email', NULL, NULL, '93', NULL, NULL, NULL, NULL),
(268, NULL, 'Smtp', NULL, NULL, '94', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(269, 'Admin Email', 'Domain Email', NULL, NULL, '94', NULL, NULL, NULL, NULL),
(270, NULL, 'Smtp', NULL, NULL, '95', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(271, 'Admin Email', 'Domain Email', NULL, NULL, '95', NULL, NULL, NULL, NULL),
(272, NULL, 'Smtp', NULL, NULL, '96', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(273, 'Admin Email', 'Domain Email', NULL, NULL, '96', NULL, NULL, NULL, NULL),
(274, NULL, 'Smtp', NULL, NULL, '97', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(275, 'Admin Email', 'Domain Email', NULL, NULL, '97', NULL, NULL, NULL, NULL),
(276, NULL, 'Smtp', 'tanvir.wakeupict@gmail.com', 'a3ZmcyB6ZXViIHZwdXggZWtsag==', '98', 'smtp.gmail.com', '587', '1', 'gmail'),
(277, 'Admin Email', 'Domain Email', NULL, NULL, '98', NULL, NULL, NULL, NULL),
(278, NULL, 'Smtp', NULL, NULL, '99', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(279, 'Admin Email', 'Domain Email', NULL, NULL, '99', NULL, NULL, NULL, NULL),
(280, NULL, 'Smtp', NULL, NULL, '100', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(281, 'Admin Email', 'Domain Email', NULL, NULL, '100', NULL, NULL, NULL, NULL),
(282, NULL, 'Smtp', NULL, NULL, '101', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(283, 'Admin Email', 'Domain Email', NULL, NULL, '101', NULL, NULL, NULL, NULL),
(284, NULL, 'Smtp', NULL, NULL, '102', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(285, 'Admin Email', 'Domain Email', NULL, NULL, '102', NULL, NULL, NULL, NULL),
(286, NULL, 'Smtp', NULL, NULL, '103', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(287, 'Admin Email', 'Domain Email', NULL, NULL, '103', NULL, NULL, NULL, NULL),
(288, NULL, 'Smtp', NULL, NULL, '104', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(289, 'Admin Email', 'Domain Email', NULL, NULL, '104', NULL, NULL, NULL, NULL),
(290, NULL, 'Smtp', NULL, NULL, '105', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(291, 'Admin Email', 'Domain Email', NULL, NULL, '105', NULL, NULL, NULL, NULL),
(292, NULL, 'Smtp', NULL, NULL, '106', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(293, 'Admin Email', 'Domain Email', NULL, NULL, '106', NULL, NULL, NULL, NULL),
(294, NULL, 'Smtp', NULL, NULL, '107', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(295, 'Admin Email', 'Domain Email', NULL, NULL, '107', NULL, NULL, NULL, NULL),
(296, NULL, 'Smtp', NULL, NULL, '108', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(297, 'Admin Email', 'Domain Email', NULL, NULL, '108', NULL, NULL, NULL, NULL),
(298, NULL, 'Smtp', NULL, NULL, '109', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(299, 'Admin Email', 'Domain Email', NULL, NULL, '109', NULL, NULL, NULL, NULL),
(300, NULL, 'Smtp', NULL, NULL, '110', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(301, 'Admin Email', 'Domain Email', NULL, NULL, '110', NULL, NULL, NULL, NULL),
(302, NULL, 'Smtp', NULL, NULL, '111', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(303, 'Admin Email', 'Domain Email', NULL, NULL, '111', NULL, NULL, NULL, NULL),
(304, NULL, 'Smtp', NULL, NULL, '112', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(305, 'Admin Email', 'Domain Email', NULL, NULL, '112', NULL, NULL, NULL, NULL),
(306, NULL, 'Smtp', NULL, NULL, '113', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(307, 'Admin Email', 'Domain Email', NULL, NULL, '113', NULL, NULL, NULL, NULL),
(308, NULL, 'Smtp', NULL, NULL, '114', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(309, 'Admin Email', 'Domain Email', NULL, NULL, '114', NULL, NULL, NULL, NULL),
(310, NULL, 'Smtp', NULL, NULL, '115', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(311, 'Admin Email', 'Domain Email', NULL, NULL, '115', NULL, NULL, NULL, NULL),
(312, NULL, 'Smtp', NULL, NULL, '116', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(313, 'Admin Email', 'Domain Email', NULL, NULL, '116', NULL, NULL, NULL, NULL),
(314, NULL, 'Smtp', NULL, NULL, '117', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(315, 'Admin Email', 'Domain Email', NULL, NULL, '117', NULL, NULL, NULL, NULL),
(316, NULL, 'Smtp', NULL, NULL, '118', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(317, 'Admin Email', 'Domain Email', NULL, NULL, '118', NULL, NULL, NULL, NULL),
(318, NULL, 'Smtp', NULL, NULL, '119', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(319, 'Admin Email', 'Domain Email', NULL, NULL, '119', NULL, NULL, NULL, NULL),
(320, NULL, 'Smtp', NULL, NULL, '120', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(321, 'Admin Email', 'Domain Email', NULL, NULL, '120', NULL, NULL, NULL, NULL),
(322, NULL, 'Smtp', NULL, NULL, '121', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(323, 'Admin Email', 'Domain Email', NULL, NULL, '121', NULL, NULL, NULL, NULL),
(324, NULL, 'Smtp', NULL, NULL, '122', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(325, 'Admin Email', 'Domain Email', NULL, NULL, '122', NULL, NULL, NULL, NULL),
(326, NULL, 'Smtp', NULL, NULL, '123', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(327, 'Admin Email', 'Domain Email', NULL, NULL, '123', NULL, NULL, NULL, NULL),
(328, NULL, 'Smtp', NULL, NULL, '124', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(329, 'Admin Email', 'Domain Email', NULL, NULL, '124', NULL, NULL, NULL, NULL),
(330, NULL, 'Smtp', NULL, NULL, '125', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(331, 'Admin Email', 'Domain Email', NULL, NULL, '125', NULL, NULL, NULL, NULL),
(332, NULL, 'Smtp', NULL, NULL, '126', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(333, 'Admin Email', 'Domain Email', NULL, NULL, '126', NULL, NULL, NULL, NULL),
(334, NULL, 'Smtp', NULL, NULL, '127', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(335, 'Admin Email', 'Domain Email', NULL, NULL, '127', NULL, NULL, NULL, NULL),
(336, NULL, 'Smtp', NULL, NULL, '128', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(337, 'Admin Email', 'Domain Email', NULL, NULL, '128', NULL, NULL, NULL, NULL),
(338, NULL, 'Smtp', NULL, NULL, '129', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(339, 'Admin Email', 'Domain Email', NULL, NULL, '129', NULL, NULL, NULL, NULL),
(340, NULL, 'Smtp', NULL, NULL, '130', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(341, 'Admin Email', 'Domain Email', NULL, NULL, '130', NULL, NULL, NULL, NULL),
(342, NULL, 'Smtp', NULL, NULL, '131', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(343, 'Admin Email', 'Domain Email', NULL, NULL, '131', NULL, NULL, NULL, NULL),
(344, NULL, 'Smtp', 'example@gmail.com', 'MTIzNDU=', '132', 'smtp.gmail.com', '587', '1', 'gmail'),
(345, 'Admin Email', 'Domain Email', NULL, NULL, '132', NULL, NULL, NULL, NULL),
(346, NULL, 'Smtp', 'example@gmail.com', 'MTIzNDU=', '133', 'smtp.gmail.com', '587', '1', 'gmail'),
(347, 'Admin Email', 'Domain Email', NULL, NULL, '133', NULL, NULL, NULL, NULL),
(348, NULL, 'Smtp', NULL, NULL, '134', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(349, 'Admin Email', 'Domain Email', NULL, NULL, '134', NULL, NULL, NULL, NULL),
(350, NULL, 'Smtp', NULL, NULL, '135', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(351, 'Admin Email', 'Domain Email', NULL, NULL, '135', NULL, NULL, NULL, NULL),
(352, NULL, 'Smtp', NULL, NULL, '136', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(353, 'Admin Email', 'Domain Email', NULL, NULL, '136', NULL, NULL, NULL, NULL),
(354, NULL, 'Smtp', NULL, NULL, '137', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(355, 'Admin Email', 'Domain Email', NULL, NULL, '137', NULL, NULL, NULL, NULL),
(356, NULL, 'Smtp', NULL, NULL, '138', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(357, 'Admin Email', 'Domain Email', NULL, NULL, '138', NULL, NULL, NULL, NULL),
(358, NULL, 'Smtp', NULL, NULL, '139', 'smtp_host', 'smtp_port', 'send_multipart', 'mail_provider'),
(359, 'Admin Email', 'Domain Email', NULL, NULL, '139', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `emergency`
--

CREATE TABLE `emergency` (
  `id` int(11) NOT NULL,
  `patient` varchar(100) NOT NULL,
  `doctor` varchar(100) NOT NULL,
  `emergency_type` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(50) NOT NULL,
  `hospital_id` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `emergency`
--

INSERT INTO `emergency` (`id`, `patient`, `doctor`, `emergency_type`, `description`, `status`, `hospital_id`, `date`) VALUES
(1, '1', '7', 'Covid - 19', 'Sars Virus', '', 'Active', '2024-09-15 05:58:05');

-- --------------------------------------------------------

--
-- Table structure for table `expense`
--

CREATE TABLE `expense` (
  `id` int(10) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `datestring` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expense_category`
--

CREATE TABLE `expense_category` (
  `id` int(10) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `x` varchar(100) DEFAULT NULL,
  `y` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `facilitie`
--

CREATE TABLE `facilitie` (
  `id` int(100) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `align` varchar(100) DEFAULT NULL,
  `z` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `facilitie`
--

INSERT INTO `facilitie` (`id`, `title`, `align`, `z`) VALUES
(1, 'Open source for easy customization.', 'Right', NULL),
(2, 'Host in your secure server.', 'Right', NULL),
(3, 'No monthly or yearly fees.', 'Right', NULL),
(4, '24/7 customer support.', 'Right', NULL),
(5, 'Multi-language system', 'Right', NULL),
(6, 'Admin and customer has separate UI and login system', 'Right', NULL),
(7, 'Email and SMS gateway adding for marketing', 'Right', NULL),
(8, 'Project mobile app integration module', 'Right', NULL),
(9, 'Complete hospital management solution', 'Right', NULL),
(10, 'Prescription management system', 'Right', NULL),
(11, 'Doctor management system', 'Right', NULL),
(12, 'Insurance management systemm', 'Right', NULL),
(13, 'Billing management system', 'Right', NULL),
(14, 'Role-based permission setup system', 'Right', NULL),
(15, 'Multiple Email and SMS gateway added', 'Left', NULL),
(16, 'Human resource system', 'Left', NULL),
(17, 'Complete bed management system', 'Left', NULL),
(18, 'Medication and visits system', 'Left', NULL),
(19, 'Case manager management system', 'Left', NULL),
(20, 'Patient separate login and appointment system', 'Left', NULL),
(21, 'Hospital inquiry system', 'Left', NULL),
(22, 'LTR and RTL version', 'Left', NULL),
(23, 'Any language changes from frontend and backend', 'Left', NULL),
(24, 'Pharmacy management system', 'Left', NULL),
(25, 'Appointment management system', 'Left', NULL),
(26, 'Investigation system report', 'Left', NULL),
(27, 'Paid android apps system if you need', 'Left', NULL),
(28, 'Full accounting system of hospital and its report', 'Left', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(100) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `title`, `description`) VALUES
(1, 'Administrative Module', 'We have designed the administrative module for a hospital owner or the person who is accountable to operate the entire hospital smoothly. Using this module, you can manage the entire system easily and efficiently. Because this module includes every important feature like doctors portal, patient portal, appointment scheduling, prescription management, human resource management, bed management, employee, accounts, software settings, role assigning, etc.'),
(2, 'Doctor Module', 'A doctor is the most important person to ensure the health condition of any patient. For this purpose, this software has a doctor module. Using this module, doctors can access all important functions that belong to them. As a result, they can maintain patient portals, appointment scheduling & maintaining, prescription making, and any other things that are related to hospital activities.'),
(3, 'Accountants Module', 'Accountants are responsible to control monetary flow, profit-and- loss calculation. Patients are considered the main factor of this software. Moreover, they are the key earning source of this system. So this module allows access to the patient portal. Besides, the Accountant module also has the access account creation option, like debit or credit account based on expense and earning, employee name, and billing. With this software, you can get a complete clinic management system that helps to understand both technical or non-technical people.');

-- --------------------------------------------------------

--
-- Table structure for table `featured`
--

CREATE TABLE `featured` (
  `id` int(100) NOT NULL,
  `img_url` varchar(1000) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `profile` varchar(100) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `featured`
--

INSERT INTO `featured` (`id`, `img_url`, `name`, `profile`, `description`, `hospital_id`) VALUES
(1, 'uploads/images.jpg', 'Dr Momenuzzaman', 'Cardiac Specialized', '<p>Redantium, totam rem aperiam, eaque ipsa qu ab illo inventore veritatis et quasi architectos beatae vitae dicta sunt explicabo. Nemo enims sadips ipsums un.sd</p>\r\n', '466'),
(2, 'uploads/doctor.png', 'Dr RahmatUllah Asif', 'Cardiac Specialized', 'Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence', '466'),
(3, 'uploads/download_(2)2.png', 'Dr A.R.M. Jamil', 'Cardiac Specialized', 'Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence Cardiac Excellence', '466'),
(4, 'uploads/inlinePreview.jpg', 'Hospital Management Syatem', 'Cardiac Specialized', '<p>bfbjfbsjbjsbfjsbf</p>\r\n', '466');

-- --------------------------------------------------------

--
-- Table structure for table `file`
--

CREATE TABLE `file` (
  `id` int(50) NOT NULL,
  `title` varchar(300) DEFAULT NULL,
  `img_url` varchar(300) DEFAULT NULL,
  `module` varchar(500) DEFAULT NULL,
  `hospital_id` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `folder`
--

CREATE TABLE `folder` (
  `id` int(50) NOT NULL,
  `folder_name` varchar(500) DEFAULT NULL,
  `patient` varchar(50) DEFAULT NULL,
  `add_date` varchar(50) DEFAULT NULL,
  `folder_path` varchar(500) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `folder`
--

INSERT INTO `folder` (`id`, `folder_name`, `patient`, `add_date`, `folder_path`, `hospital_id`) VALUES
(101, 'Testing', '10', '01/13/22', '/uploads/documents/Testing', '98'),
(109, 'New folder', '11', '03/05/24', '/uploads/documents/New folder', '98');

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(10) NOT NULL,
  `img` varchar(500) NOT NULL,
  `position` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `img`, `position`, `status`) VALUES
(1, 'uploads/gallery-img-1.png', '1', 'Active'),
(2, 'uploads/gallery-img-2.png', '2', 'Active'),
(3, 'uploads/gallery-img-3.png', '3', 'Active'),
(4, 'uploads/gallery-img-4.png', '4', 'Active'),
(5, 'uploads/gallery-img-5.png', '5', 'Active'),
(6, 'uploads/gallery-img-6.png', '6', 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `google_captcha`
--

CREATE TABLE `google_captcha` (
  `id` int(100) NOT NULL,
  `site_key` varchar(1000) DEFAULT NULL,
  `secret_key` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `google_captcha`
--

INSERT INTO `google_captcha` (`id`, `site_key`, `secret_key`, `hospital_id`) VALUES
(1, '6LeuBKYrAAAAAMUwep7iUED6WLbtSQ4EMCo1Iw0D', '6LeuBKYrAAAAAJKU599x_oBsMYjgOEfjvxxmQuu3', '98');

-- --------------------------------------------------------

--
-- Table structure for table `gpt_memory`
--

CREATE TABLE `gpt_memory` (
  `id` int(100) NOT NULL,
  `module_name` varchar(100) DEFAULT NULL,
  `module_row_id` varchar(100) DEFAULT NULL,
  `session_id` varchar(100) DEFAULT NULL,
  `history` longtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `gpt_memory`
--

INSERT INTO `gpt_memory` (`id`, `module_name`, `module_row_id`, `session_id`, `history`) VALUES
(4, 'case', '23', '98-case-23', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: . \\n\\nPatient Case:\\n\\nDemographics: John Smith, a 25-year-old male.\\nPresenting Complaint: Sore throat for three days, which worsens with swallowing.\\nHistory of Present Illness: The patient reports no cough, rhinorrhea, or other cold symptoms. He mentions that his roommate was recently diagnosed with strep throat.\\nPast Medical History: No significant history.\\nSocial History: Non-smoker, occasional alcohol, university student living in shared accommodation.\\nReview of Systems: No fever, rash, joint pains, or breathing difficulties.\\n\\nPhysical Examination:\\n\\nVital Signs: Normal.\\nThroat: Red, swollen pharynx with no exudates; no tonsillar enlargement.\\nNeck: No palpable lymphadenopathy.\\nThe rest of the physical examination is unremarkable.\\n\\n\\n\"},{\"role\":\"system\",\"content\":\"Based on the patient\'s history and physical examination findings, it is likely that John Smith has developed a viral pharyngitis, which is a common cause of sore throat in young adults. However, given his close contact with a roommate diagnosed with strep throat, it is important to consider testing for streptococcal pharyngitis as well.\\n\\nI would recommend performing a rapid strep test to rule out strep throat, as this would require antibiotic treatment. In the meantime, I would advise John to rest, stay hydrated, and take over-the-counter pain relievers such as acetaminophen or ibuprofen to help with his symptoms. Gargling with warm salt water or using throat lozenges may also provide some relief.\\n\\nI would also advise John to practice good hand hygiene to prevent spreading the infection to others in his shared accommodation. If the rapid strep test is positive, he should follow up with his healthcare provider for further evaluation and treatment.\\n\\nOverall, it is important for John to monitor his symptoms and seek medical attention if they worsen or if he develops any new concerning symptoms.\"},{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Now what to do?\"},{\"role\":\"system\",\"content\":\"Based on the information provided, it is likely that John Smith is experiencing symptoms of a viral pharyngitis or possibly streptococcal pharyngitis. Here are the steps to take:\\n\\n1. **Testing**: Consider performing a rapid strep test to rule out strep throat, especially given his close contact with a roommate who was diagnosed with strep throat.\\n\\n2. **Treatment**: If the rapid strep test is positive, John will likely need antibiotic treatment. If it is negative, the sore throat is likely viral in nature and will resolve on its own. In either case, symptomatic treatment with rest, hydration, and over-the-counter pain relievers is recommended.\\n\\n3. **Prevention**: Encourage John to practice good hand hygiene to prevent spreading the infection to others in his shared accommodation.\\n\\n4. **Follow-up**: Advise John to monitor his symptoms and seek medical attention if they worsen or if he develops any new concerning symptoms.\\n\\nIt is important for John to follow these recommendations and seek medical advice if needed for proper management of his sore throat.\"}]'),
(5, 'case', '24', '98-case-24', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: \\nPersistent fatigue and weakness.\\nShortness of breath, especially during physical activities.\\nSwelling in the legs, ankles, and feet.\\nRapid or irregular heartbeat.\\nReduced ability to exercise.\\nPersistent cough or wheezing with white or pink blood-tinged phlegm.\\nSwelling of the abdomen due to fluid buildup.\\nLack of appetite and nausea.\\nDifficulty concentrating or decreased alertness.\\nSudden weight gain from fluid retention.\\n\"},{\"role\":\"system\",\"content\":\"Based on the symptoms described, it is possible that the patient may be experiencing heart failure. It is important for the patient to seek medical attention immediately for a proper diagnosis and treatment plan. In the meantime, it is important for the patient to rest and avoid strenuous physical activities. It is also important to monitor fluid intake and follow a low-sodium diet to help reduce fluid retention. Medications may be prescribed to help manage symptoms and improve heart function. It is crucial for the patient to follow up with their healthcare provider regularly to monitor their condition and make any necessary adjustments to their treatment plan.\"},{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Suggest medicine\\n\"},{\"role\":\"system\",\"content\":\"As a doctor, I cannot prescribe specific medications without conducting a proper evaluation and diagnosis of the patient. However, based on the symptoms described, the patient may require medications such as diuretics to help reduce fluid retention, ACE inhibitors or beta-blockers to improve heart function, and possibly medications to manage symptoms such as cough or wheezing. It is important for the patient to consult with a healthcare provider for a thorough evaluation and to receive a personalized treatment plan.\"}]'),
(6, 'case', '29', '98-case-29', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Vomitting, high fever and sort breath\"},{\"role\":\"system\",\"content\":\"Based on the symptoms of vomiting, high fever, and shortness of breath, it is important to seek medical attention immediately. These symptoms could indicate a serious infection, such as pneumonia or sepsis, or a respiratory condition like asthma or bronchitis. It is important to get a proper diagnosis and treatment as soon as possible to prevent any complications. In the meantime, stay hydrated, rest, and avoid any triggers that may worsen the symptoms. Do not hesitate to seek emergency medical care if the symptoms worsen or if there is any difficulty breathing.\"}]'),
(7, 'case', '96', '98-case-96', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Alhamdulillahi rabbil alamin Masha Allajsjsjsksksksh\"},{\"role\":\"system\",\"content\":\"It seems like you may have accidentally typed some random characters. If you have a specific medical concern or question, please provide more information so that I can offer appropriate advice.\"},{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Alhamdulillahi rabbil alamin Masha Allajsjsjsksksksh\"},{\"role\":\"system\",\"content\":\"It appears that the case description provided is not related to a medical issue. If you have any health concerns or questions, please feel free to share them so that I can provide you with appropriate medical advice.\"}]'),
(8, 'case', '94', '98-case-94', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: Alhamdulillahi rabbil alamin Masha Allajsjsjsksksksh\"},{\"role\":\"system\",\"content\":\"It seems like you may have accidentally typed a random string of characters. If you have a specific medical concern or question, please provide more information so that I can offer appropriate advice.\"}]'),
(9, 'case', '147', '98-case-147', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: dfgdfg\"},{\"role\":\"system\",\"content\":\"I\'m sorry, but the case description provided is not clear or complete enough for me to offer any specific medical advice. If you could provide more details or context, I would be happy to help. In the meantime, I recommend seeking medical attention from a healthcare professional for a proper evaluation and treatment.\"}]'),
(10, 'case', '149', '98-case-149', '[{\"role\":\"user\",\"content\":\"You are a doctor. Advice according to the case described here. This is the case: sdfdsfdsf\\nwhat is the name of this patient?\"},{\"role\":\"system\",\"content\":null}]');

-- --------------------------------------------------------

--
-- Table structure for table `grid`
--

CREATE TABLE `grid` (
  `id` int(10) NOT NULL,
  `category` varchar(100) NOT NULL,
  `title` varchar(500) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `img` varchar(1000) NOT NULL,
  `position` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `grid`
--

INSERT INTO `grid` (`id`, `category`, `title`, `description`, `img`, `position`, `status`) VALUES
(3, 'FEATURED', 'Professional surgeons', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Eum tenetur, aut veritatis maxime ducimus modi delectus vero expedita illo ratione, eveniet laboriosam cupiditate reiciendis, repellat minima. Optio consectetur inventore ipsa!', 'uploads/frature-img-1.png', '1', 'Active'),
(4, 'FEATURED', 'Good Care', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Eum tenetur, aut veritatis maxime ducimus modi delectus vero expedita illo ratione, eveniet laboriosam cupiditate reiciendis, repellat minima. Optio consectetur inventore ipsa!', 'uploads/frature-img-2.png', '2', 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`) VALUES
(1, 'superadmin', 'Super Admin'),
(2, 'members', 'General User'),
(3, 'Accountant', 'For Financial Activities'),
(4, 'Doctor', ''),
(5, 'Patient', ''),
(6, 'Nurse', ''),
(7, 'Pharmacist', ''),
(8, 'Laboratorist', ''),
(10, 'Receptionist', 'Receptionist'),
(11, 'admin', 'Administrator');

-- --------------------------------------------------------

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` int(100) NOT NULL,
  `doctor` varchar(100) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `x` varchar(100) DEFAULT NULL,
  `y` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `holidays`
--

INSERT INTO `holidays` (`id`, `doctor`, `date`, `x`, `y`, `hospital_id`) VALUES
(2, '3', '1638295200', NULL, NULL, '4');

-- --------------------------------------------------------

--
-- Table structure for table `hospital`
--

CREATE TABLE `hospital` (
  `id` int(100) NOT NULL,
  `name` varchar(500) DEFAULT NULL,
  `email` varchar(500) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `location` varchar(500) DEFAULT NULL,
  `location_coordinates` varchar(500) DEFAULT NULL,
  `phone` varchar(500) DEFAULT NULL,
  `package` varchar(100) DEFAULT NULL,
  `p_limit` varchar(100) DEFAULT NULL,
  `d_limit` varchar(100) DEFAULT NULL,
  `module` varchar(1000) DEFAULT NULL,
  `ion_user_id` varchar(100) DEFAULT NULL,
  `country` varchar(1000) DEFAULT NULL,
  `from_where` varchar(1000) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `hospital`
--

INSERT INTO `hospital` (`id`, `name`, `email`, `password`, `address`, `location`, `location_coordinates`, `phone`, `package`, `p_limit`, `d_limit`, `module`, `ion_user_id`, `country`, `from_where`, `username`) VALUES
(98, 'Hospital Admin', 'admin@hms.com', NULL, 'Ka/5, Bashundhara R/A Gate', NULL, NULL, '+8801777024443', '1', '2000', '1000', 'accountant,appointment,lab,bed,department,doctor,donor,finance,pharmacy,laboratorist,medicine,nurse,patient,pharmacist,prescription,receptionist,report,notice,email,sms,file,payroll,attendance,leave,chat,site', '992', '', NULL, 'apollo');

-- --------------------------------------------------------

--
-- Table structure for table `hospital_deposit`
--

CREATE TABLE `hospital_deposit` (
  `id` int(100) NOT NULL,
  `payment_id` varchar(1000) DEFAULT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `package_id` varchar(50) DEFAULT NULL,
  `deposited_amount` varchar(1000) DEFAULT NULL,
  `deposited_amount_id` varchar(1000) DEFAULT NULL,
  `gateway` varchar(1000) DEFAULT NULL,
  `hospital_user_id` varchar(1000) DEFAULT NULL,
  `next_due_date_stamp` varchar(1000) DEFAULT NULL,
  `next_due_date` varchar(1000) DEFAULT NULL,
  `add_date_stamp` varchar(1000) DEFAULT NULL,
  `add_date` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `hospital_deposit`
--

INSERT INTO `hospital_deposit` (`id`, `payment_id`, `date`, `package_id`, `deposited_amount`, `deposited_amount_id`, `gateway`, `hospital_user_id`, `next_due_date_stamp`, `next_due_date`, `add_date_stamp`, `add_date`) VALUES
(64, '52', '1646978208', '1', '100000', NULL, 'Cash', '98', '1678514208', '11-03-2023', '1646978208', '11-03-2022'),
(59, '52', '1640871501', '1', '100000', '52gp', 'Cash', '98', '1672407501', '30-12-2022', '1640871501', '30-12-2021'),
(61, '52', '1643008561', NULL, '10000', NULL, 'Cash', '98', '1645600561', '23-02-2022', '1643008561', '24-01-2022'),
(71, '52', '1666566362', '2', '50000', NULL, 'Cash', '98', '1698102362', '24-10-2023', '1666566362', '24-10-2022'),
(72, '52', '1666566398', '1', '100000', NULL, 'Cash', '98', '1698102398', '24-10-2023', '1666566398', '24-10-2022'),
(77, '52', '1669880254', '2', '50000', NULL, 'Cash', '98', '1701416254', '01-12-2023', '1669880254', '01-12-2022'),
(78, '52', '1669880307', '1', '100000', NULL, 'Cash', '98', '1701416307', '01-12-2023', '1669880307', '01-12-2022'),
(81, '52', '1670593500', '1', '100000', NULL, 'Cash', '98', '1702129500', '09-12-2023', '1670593500', '09-12-2022'),
(85, '52', '1696768878', '7', '10', NULL, 'Stripe', '98', '1699360878', '07-11-2023', '1696768878', '08-10-2023'),
(86, '52', '1700390198', '7', '1000', NULL, 'Cash', '98', '1731926198', '18-11-2024', '1700390198', '19-11-2023'),
(89, '52', '1705929792', '1', '100000', NULL, 'Cash', '98', '1737465792', '21-01-2025', '1705929792', '22-01-2024'),
(93, '73', '1725789076', NULL, '0', '73gp', 'trial', '119', '1727085076', '23-09-2024', '1725789076', '08-09-2024'),
(94, '74', '1725789244', NULL, '10', '74gp', 'Stripe', '120', '1728381243', '08-10-2024', '1725789244', '08-09-2024'),
(95, '75', '1725789908', NULL, '0', '75gp', 'trial', '121', '1727085907', '23-09-2024', '1725789908', '08-09-2024'),
(96, '76', '1725790201', NULL, '10', '76gp', 'Stripe', '122', '1728382201', '08-10-2024', '1725790201', '08-09-2024'),
(97, '77', '1725790498', NULL, '0', '77gp', 'trial', '123', '1727086498', '23-09-2024', '1725790498', '08-09-2024'),
(98, '78', '1725796678', NULL, '0', '78gp', 'trial', '124', '1727092677', '23-09-2024', '1725796678', '08-09-2024'),
(99, '79', '1725796919', NULL, '10', '79gp', 'Stripe', '125', '1728388919', '08-10-2024', '1725796919', '08-09-2024'),
(100, '80', '1725797123', NULL, '10', '80gp', 'Stripe', '126', '1728389123', '08-10-2024', '1725797123', '08-09-2024'),
(101, '81', '1725797342', NULL, '10', '81gp', 'Stripe', '127', '1728389342', '08-10-2024', '1725797342', '08-09-2024'),
(102, '82', '1725797994', NULL, '10', '82gp', 'Stripe', '128', '1728389993', '08-10-2024', '1725797994', '08-09-2024'),
(103, '83', '1725798126', NULL, '10', '83gp', 'Stripe', '129', '1728390126', '08-10-2024', '1725798126', '08-09-2024'),
(104, '84', '1725798968', NULL, '10', '84gp', 'Stripe', '130', '1728390968', '08-10-2024', '1725798968', '08-09-2024'),
(105, '85', '1725799021', NULL, '0', '85gp', 'trial', '131', '1727095021', '23-09-2024', '1725799021', '08-09-2024'),
(106, '86', '1727877652', '1', '10000', '86gp', 'Cash', '132', '1730469651', '01-11-2024', '1727877652', '02-10-2024'),
(107, '87', '1728283018', '1', '10000', '87gp', 'Cash', '133', '1730875018', '06-11-2024', '1728283018', '07-10-2024'),
(108, '88', '1729207546', NULL, '0', '88gp', 'trial', '134', '1730503546', '02-11-2024', '1729207546', '18-10-2024'),
(109, '89', '1730607856', NULL, '0', '89gp', 'trial', '135', '1731903856', '18-11-2024', '1730607856', '03-11-2024'),
(110, '90', '1737883307', NULL, '0', '90gp', 'trial', '136', '1739179306', '10-02-2025', '1737883307', '26-01-2025'),
(111, '52', '1737890319', '1', '100000', NULL, 'Cash', '98', '1769426319', '26-01-2026', '1737890319', '26-01-2025'),
(112, '91', '1740655729', NULL, '0', '91gp', 'trial', '137', '1741951728', '14-03-2025', '1740655729', '27-02-2025'),
(113, '92', '1740655879', NULL, '0', '92gp', 'trial', '138', '1741951878', '14-03-2025', '1740655879', '27-02-2025'),
(114, '93', '1741165016', NULL, '0', '93gp', 'trial', '139', '1742461016', '20-03-2025', '1741165016', '05-03-2025');

-- --------------------------------------------------------

--
-- Table structure for table `hospital_payment`
--

CREATE TABLE `hospital_payment` (
  `id` int(100) NOT NULL,
  `hospital_user_id` varchar(1000) DEFAULT NULL,
  `price` varchar(1000) DEFAULT NULL,
  `package_duration` varchar(1000) DEFAULT NULL,
  `next_due_date_stamp` varchar(1000) DEFAULT NULL,
  `next_due_date` varchar(1000) DEFAULT NULL,
  `add_date_stamp` varchar(1000) DEFAULT NULL,
  `add_date` varchar(1000) DEFAULT NULL,
  `package` varchar(1000) DEFAULT NULL,
  `status` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `hospital_payment`
--

INSERT INTO `hospital_payment` (`id`, `hospital_user_id`, `price`, `package_duration`, `next_due_date_stamp`, `next_due_date`, `add_date_stamp`, `add_date`, `package`, `status`) VALUES
(52, '98', '100000', 'yearly', '1769426319', '26-01-2026', '1640871501', '30-12-2021', '1', 'paid'),
(73, '119', '0', 'monthly', '1727085076', '23-09-2024', '1725789076', '08-09-2024', '1', 'paid'),
(74, '120', '10', 'monthly', '1728381243', '08-10-2024', '1725789244', '08-09-2024', '6', 'paid'),
(75, '121', '0', 'monthly', '1727085907', '23-09-2024', '1725789908', '08-09-2024', '1', 'paid'),
(76, '122', '10', 'monthly', '1728382201', '08-10-2024', '1725790201', '08-09-2024', '6', 'paid'),
(77, '123', '0', 'monthly', '1727086498', '23-09-2024', '1725790498', '08-09-2024', '1', 'paid'),
(78, '124', '0', 'yearly', '1727092677', '23-09-2024', '1725796678', '08-09-2024', '2', 'paid'),
(79, '125', '10', 'monthly', '1728388919', '08-10-2024', '1725796919', '08-09-2024', '6', 'paid'),
(80, '126', '10', 'monthly', '1728389123', '08-10-2024', '1725797123', '08-09-2024', '6', 'paid'),
(81, '127', '10', 'monthly', '1728389342', '08-10-2024', '1725797342', '08-09-2024', '6', 'paid'),
(82, '128', '10', 'monthly', '1728389993', '08-10-2024', '1725797994', '08-09-2024', '6', 'paid'),
(83, '129', '10', 'monthly', '1728390126', '08-10-2024', '1725798126', '08-09-2024', '6', 'paid'),
(84, '130', '10', 'monthly', '1728390968', '08-10-2024', '1725798968', '08-09-2024', '6', 'paid'),
(85, '131', '0', 'monthly', '1727095021', '23-09-2024', '1725799021', '08-09-2024', '3', 'paid'),
(86, '132', '10000', 'monthly', '1730469651', '01-11-2024', '1727877652', '02-10-2024', '1', 'paid'),
(87, '133', '10000', 'monthly', '1730875018', '06-11-2024', '1728283018', '07-10-2024', '1', 'paid'),
(88, '134', '0', 'monthly', '1730503546', '02-11-2024', '1729207546', '18-10-2024', '2', 'paid'),
(89, '135', '0', 'yearly', '1731903856', '18-11-2024', '1730607856', '03-11-2024', '8', 'paid'),
(91, '137', '0', 'monthly', '1741951728', '14-03-2025', '1740655729', '27-02-2025', '1', 'paid'),
(90, '136', '0', 'monthly', '1739179306', '10-02-2025', '1737883307', '26-01-2025', '1', 'paid'),
(92, '138', '0', 'monthly', '1741951878', '14-03-2025', '1740655879', '27-02-2025', '1', 'paid'),
(93, '139', '0', 'monthly', '1742461016', '20-03-2025', '1741165016', '05-03-2025', '1', 'paid');

-- --------------------------------------------------------

--
-- Table structure for table `insurance_company`
--

CREATE TABLE `insurance_company` (
  `id` int(100) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `hospital_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `insurance_company`
--

INSERT INTO `insurance_company` (`id`, `name`, `description`, `hospital_id`) VALUES
(1, 'Meghna Insurance', '<p>Description</p>', '98'),
(4, 'Delta Insurance', '<p>dsfsdfsf</p>', '98');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_categories`
--

CREATE TABLE `inventory_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `hospital_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_categories`
--

INSERT INTO `inventory_categories` (`id`, `name`, `description`, `parent_id`, `status`, `hospital_id`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'Medical Equipment', 'Medical devices and equipment', NULL, 'active', 98, '2025-08-07 12:31:35', '2025-08-07 13:56:24', 1),
(2, 'Surgical Instruments', 'Surgical tools and instruments', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(3, 'Pharmaceuticals', 'Medicines and drugs', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(4, 'Laboratory Supplies', 'Lab consumables and reagents', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(5, 'Office Supplies', 'Administrative and office materials', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(6, 'Cleaning Supplies', 'Sanitation and cleaning materials', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(7, 'Patient Care Items', 'Patient care consumables', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(8, 'PPE', 'Personal Protective Equipment', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(9, 'IT Equipment', 'Information technology hardware', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(10, 'Furniture', 'Hospital furniture and fixtures', NULL, 'active', 1, '2025-08-07 12:31:35', '2025-08-07 12:31:35', 1),
(11, 'Klinicx Health solutions', 'sfsdfsd', NULL, 'active', 98, '2025-08-08 00:07:56', '2025-08-07 14:07:56', 992),
(12, 'Goods', 'sfsdfsdfsdf', 11, 'active', 98, '2025-08-08 00:15:39', '2025-08-07 14:15:39', 992),
(14, 'Emily Davis', 'dsfsdfs', 12, 'active', 98, '2025-09-03 00:00:16', '2025-09-02 14:00:16', 992),
(15, 'Stationary', 'dsgsdfdgfg', 12, 'active', 98, '2025-09-04 14:25:15', '2025-09-04 04:25:15', 992);

-- --------------------------------------------------------

--
-- Table structure for table `inventory_items`
--

CREATE TABLE `inventory_items` (
  `id` int(11) NOT NULL,
  `item_code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `subcategory` varchar(100) DEFAULT NULL,
  `unit_of_measure` varchar(50) DEFAULT 'pieces',
  `minimum_stock` int(11) DEFAULT 0,
  `maximum_stock` int(11) DEFAULT 0,
  `reorder_level` int(11) DEFAULT 0,
  `current_stock` int(11) DEFAULT 0,
  `unit_cost` decimal(10,2) DEFAULT 0.00,
  `selling_price` decimal(10,2) DEFAULT 0.00,
  `storage_location` varchar(255) DEFAULT NULL,
  `expiry_tracking` enum('yes','no') DEFAULT 'no',
  `barcode` varchar(255) DEFAULT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `model_number` varchar(255) DEFAULT NULL,
  `specifications` text DEFAULT NULL,
  `status` enum('active','inactive','discontinued') DEFAULT 'active',
  `hospital_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_items`
--

INSERT INTO `inventory_items` (`id`, `item_code`, `name`, `description`, `category`, `subcategory`, `unit_of_measure`, `minimum_stock`, `maximum_stock`, `reorder_level`, `current_stock`, `unit_cost`, `selling_price`, `storage_location`, `expiry_tracking`, `barcode`, `manufacturer`, `brand`, `model_number`, `specifications`, `status`, `hospital_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'ITM20250807202813', 'Test Item 1', 'asdadsad', 'Goods', '', 'pieces', 0, 0, 10, 980, 10.00, 0.00, '', 'no', '', 'dsfsdfdsf', '', '', '', 'active', 98, '2025-08-08 00:28:42', '2025-08-07 14:39:50', 992, NULL),
(2, 'ITM20250807202842', 'Test Item 2', 'sdfsdfsdf', 'Klinicx Health solutions', '', 'pieces', 0, 0, 10, 900, 12.00, 0.00, '', 'no', '', 'dsfsdff', '', '', '', 'active', 98, '2025-08-08 00:29:17', '2025-09-03 04:41:01', 992, NULL),
(3, 'ITM20250807203034', 'Test Item 3', 'sdadasdsad', NULL, '', 'kg', 0, 0, 20, 1200, 12.00, 0.00, '', 'no', '', 'sdfsdfsdfsdf', '', '', '', 'active', 98, '2025-08-08 00:31:05', '2025-08-27 17:35:16', 992, 992),
(4, 'ITM20250904102722', 'Pen', 'sdfdsfdsf', 'Stationary', '', 'pieces', 10, 1000, 100, 0, 10.00, 10.00, 'dsfdsfsdfdsf', 'no', '', 'fdgfdgdfgd', '', '', '', 'active', 98, '2025-09-04 14:28:07', '2025-09-04 04:34:20', 992, 992);

-- --------------------------------------------------------

--
-- Table structure for table `lab`
--

CREATE TABLE `lab` (
  `id` int(100) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `patient` varchar(100) DEFAULT NULL,
  `doctor` varchar(100) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `category_name` varchar(1000) DEFAULT NULL,
  `report` longtext DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `patient_name` varchar(100) DEFAULT NULL,
  `patient_phone` varchar(100) DEFAULT NULL,
  `patient_address` varchar(100) DEFAULT NULL,
  `doctor_name` varchar(100) DEFAULT NULL,
  `date_string` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `invoice_id` varchar(1000) DEFAULT NULL,
  `category_id` varchar(1000) DEFAULT NULL,
  `test_status` varchar(500) DEFAULT NULL,
  `test_status_date` varchar(500) DEFAULT NULL,
  `delivery_status` varchar(500) DEFAULT NULL,
  `delivery_status_date` varchar(500) DEFAULT NULL,
  `receiver_name` varchar(500) DEFAULT NULL,
  `updated_on` varchar(500) DEFAULT NULL,
  `reported_by` varchar(500) DEFAULT NULL,
  `done_by` varchar(500) DEFAULT NULL,
  `signed_by` varchar(100) DEFAULT NULL,
  `alloted_bed_id` varchar(100) DEFAULT NULL,
  `bed_diagnostic_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `lab`
--

INSERT INTO `lab` (`id`, `category`, `patient`, `doctor`, `date`, `category_name`, `report`, `status`, `user`, `patient_name`, `patient_phone`, `patient_address`, `doctor_name`, `date_string`, `hospital_id`, `invoice_id`, `category_id`, `test_status`, `test_status_date`, `delivery_status`, `delivery_status_date`, `receiver_name`, `updated_on`, `reported_by`, `done_by`, `signed_by`, `alloted_bed_id`, `bed_diagnostic_id`) VALUES
(787, NULL, '34', '42', '1728287982', NULL, NULL, NULL, '1112', ' Rizvi Mahmud', ' 012345678', NULL, 'Dr Rahmatullah', '07-10-24', '133', '579', '83', 'not_done', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(788, NULL, '34', '42', '1728288019', NULL, NULL, NULL, '1112', ' Rizvi Mahmud', ' 012345678', NULL, 'Dr Rahmatullah', '07-10-24', '133', '580', '83', 'not_done', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(789, NULL, '34', '42', '1728288157', NULL, NULL, NULL, '1112', ' Rizvi Mahmud', ' 012345678', NULL, 'Dr Rahmatullah', '07-10-24', '133', '581', '83', 'not_done', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `laboratorist`
--

CREATE TABLE `laboratorist` (
  `id` int(100) NOT NULL,
  `img_url` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `x` varchar(100) DEFAULT NULL,
  `y` varchar(100) DEFAULT NULL,
  `ion_user_id` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `profile` varchar(1000) DEFAULT NULL,
  `signature` varchar(1000) DEFAULT NULL,
  `available` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `laboratorist`
--

INSERT INTO `laboratorist` (`id`, `img_url`, `name`, `email`, `address`, `phone`, `x`, `y`, `ion_user_id`, `hospital_id`, `profile`, `signature`, `available`) VALUES
(3, 'uploads/userIcon3.png', 'Mr. Laboratorist', 'laboratorist@hms.com', 'Ka/5, Bashundhara R/A Gate', '123456789', NULL, NULL, '997', '98', '<p>&nbsp; vjhvjgjgj</p>\r\n<p>&nbsp;</p>\r\n<p>jhjhgjgjh</p>', 'uploads/Screenshot_from_2022-03-24_13-04-152.png', '0');

-- --------------------------------------------------------

--
-- Table structure for table `lab_category`
--

CREATE TABLE `lab_category` (
  `id` int(10) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `reference_value` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `lab_category`
--

INSERT INTO `lab_category` (`id`, `category`, `description`, `reference_value`, `hospital_id`) VALUES
(35, 'Troponin-I', 'Pathological Test', '', NULL),
(36, 'CBC (DIGITAL)', 'Pathological Test', '', NULL),
(37, 'Eosinophil', 'Pathological Test', '', NULL),
(38, 'Platelets', 'Pathological Test', '', NULL),
(39, 'Malarial Parasites (MP)', 'Pathological Test', '', NULL),
(40, 'BT/ CT', 'Pathological Test', '', NULL),
(41, 'ASO Titre', 'Pathological Test', '', NULL),
(42, 'CRP', 'Pathological Test', '', NULL),
(43, 'R/A test', 'Pathological Test', '', NULL),
(44, 'VDRL', 'Pathological Test', '', NULL),
(45, 'TPHA', 'Pathological Test', '', NULL),
(46, 'HBsAg (Screening)', 'Pathological Test', '', NULL),
(47, 'HBsAg (Confirmatory)', 'Pathological Test', '', NULL),
(48, 'CFT for Kala Zar', 'Pathological Test', '', NULL),
(49, 'CFT for Filaria', 'Pathological Test', '', NULL),
(50, 'Pregnancy Test', 'Pathological Test', '', NULL),
(51, 'Blood Grouping', 'Pathological Test', '', NULL),
(52, 'Widal Test', 'Pathological Test', '(70-110)mg/dl', NULL),
(53, 'RBS', 'Pathological Test', '', NULL),
(54, 'Blood Urea', 'Pathological Test', '', NULL),
(55, 'S. Creatinine', 'Pathological Test', '', NULL),
(56, 'S. cholesterol', 'Pathological Test', '', NULL),
(57, 'Fasting Lipid Profile', 'Pathological Test', '', NULL),
(58, 'S. Bilirubin', 'Pathological Test', '', NULL),
(59, 'S. Alkaline Phosohare', 'Pathological Test', '', NULL),
(61, 'S. Calcium', 'Pathological Test', '', NULL),
(62, 'RBS with CUS', 'Pathological Test', '', NULL),
(63, 'SGPT', 'Pathological Test', '', NULL),
(64, 'SGOT', 'Pathological Test', '', NULL),
(65, 'Urine for R/E', 'Pathological Test', '', NULL),
(66, 'Urine C/S', 'Pathological Test', '', NULL),
(67, 'Stool for R/E', 'Pathological Test', '', NULL),
(68, 'Semen Analysis', 'Pathological Test', '', NULL),
(69, 'S. Electrolyte', 'Pathological Test', '', NULL),
(70, 'S. T3/ T4/ THS', 'Pathological Test', '', NULL),
(71, 'MT', 'Pathological Test', '', NULL),
(106, 'ESR', 'Patho Test', '', NULL),
(107, 'FBS CUS', 'Pathological test', '', NULL),
(108, 'Hb%', 'Pathological test', '', NULL),
(114, '2HABF', 'Pathological test', '', NULL),
(113, 'FBS', 'Pathological test', '', NULL),
(115, 'S. TSH', 'Pathological test', '', NULL),
(116, 'S. T3', 'Pathological test', '', NULL),
(117, 'DC', 'Pathological test', '', NULL),
(118, 'TC', 'Pathological test', '', NULL),
(120, 'S. Uric acid', 'Pathological test', '', NULL),
(126, 'eosinphil', 'Pathology Test', '', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int(100) NOT NULL,
  `language` varchar(100) DEFAULT NULL,
  `folder_name` varchar(100) DEFAULT NULL,
  `flag_icon` varchar(100) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`id`, `language`, `folder_name`, `flag_icon`, `description`, `status`) VALUES
(2, 'arabic', 'arabic', 'sa', 'Arabic language', '1'),
(3, 'english', 'english', 'us', 'English Language', '1'),
(5, 'french', 'french', 'fr', 'Français', '1'),
(6, 'italian', 'italian', 'it', 'Italiano', '1'),
(7, 'portuguese', 'portuguese', 'pt', 'Português', '1'),
(8, 'turkish', 'turkish', 'tr', 'Türkçe', '1'),
(14, 'spanish', NULL, 'es', 'spanish', '1');

-- --------------------------------------------------------

--
-- Table structure for table `leaves`
--

CREATE TABLE `leaves` (
  `id` int(100) NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `duration` varchar(100) DEFAULT NULL,
  `date` varchar(1000) DEFAULT NULL,
  `staff` varchar(100) DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) NOT NULL,
  `created_on` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `leave_type`
--

CREATE TABLE `leave_type` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `hospital_id` int(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `email` varchar(1000) DEFAULT NULL,
  `role` varchar(1000) DEFAULT NULL,
  `ip_address` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL,
  `date_time` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `name`, `email`, `role`, `ip_address`, `hospital_id`, `date_time`) VALUES
(2093, 'Mr. Laboratorist', 'laboratorist@hms.com', 'Laboratorist', '110.76.128.67', '992', '09-03-2025 01:35:57'),
(2094, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '09-03-2025 02:27:13'),
(2089, 'Mr Doctor', 'doctor@hms.com', 'Doctor', '103.77.63.71', '992', '08-03-2025 16:45:31'),
(2090, 'Mr Doctor', 'doctor@hms.com', 'Doctor', '110.76.128.67', '992', '08-03-2025 20:39:27'),
(2092, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '09-03-2025 00:34:45'),
(2091, 'Mr Doctor', 'doctor@hms.com', 'Doctor', '110.76.128.67', '992', '09-03-2025 00:26:34'),
(2095, 'Super Admin', 'superadmin@hms.com', 'SuperAdmin', '110.76.128.100', '', '17-03-2025 13:39:40'),
(2096, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.100', '992', '17-03-2025 13:40:06'),
(2097, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.77.63.68', '992', '27-03-2025 15:06:29'),
(2098, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '01-06-2025 10:26:54'),
(2099, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '10-06-2025 11:37:00'),
(2100, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.100', '992', '10-07-2025 12:00:57'),
(2101, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.100', '992', '10-07-2025 16:44:30'),
(2102, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.100', '992', '10-07-2025 17:25:40'),
(2103, 'Mr Patient', 'patient@hms.com', 'Patient', '110.76.128.100', '992', '10-07-2025 17:51:27'),
(2104, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.77.63.70', '992', '21-07-2025 23:57:18'),
(2105, 'Mr Doctor', 'doctor@hms.com', 'Doctor', '103.77.63.70', '992', '21-07-2025 23:58:37'),
(2106, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '07-08-2025 19:28:15'),
(2107, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '08-08-2025 10:54:53'),
(2108, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '10-08-2025 00:34:04'),
(2109, 'Super Admin', 'superadmin@hms.com', 'SuperAdmin', '110.76.128.67', '', '10-08-2025 04:11:25'),
(2110, 'Mr Patient', 'patient@hms.com', 'Patient', '110.76.128.67', '992', '10-08-2025 04:12:06'),
(2111, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '10-08-2025 04:12:28'),
(2112, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.140.13', '992', '12-08-2025 23:54:17'),
(2113, 'Hospital Admin', 'admin@hms.com', 'Admin', '202.134.14.157', '992', '14-08-2025 09:25:13'),
(2114, 'Super Admin', 'superadmin@hms.com', 'SuperAdmin', '202.134.14.157', '', '14-08-2025 09:26:30'),
(2115, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '19-08-2025 00:45:42'),
(2116, 'Super Admin', 'superadmin@hms.com', 'SuperAdmin', '103.231.162.56', '', '25-08-2025 14:14:59'),
(2117, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '27-08-2025 13:04:42'),
(2118, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '27-08-2025 16:14:51'),
(2119, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '29-08-2025 23:46:40'),
(2120, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '30-08-2025 10:46:31'),
(2121, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '01-09-2025 13:37:29'),
(2122, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '02-09-2025 11:53:53'),
(2123, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '02-09-2025 15:49:15'),
(2124, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '03-09-2025 03:28:55'),
(2125, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '03-09-2025 10:39:03'),
(2126, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '04-09-2025 04:16:44'),
(2127, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.159.128.180', '992', '04-09-2025 07:11:43'),
(2128, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.170.141.101', '992', '06-09-2025 04:06:52'),
(2129, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.159.128.180', '992', '06-09-2025 07:44:56'),
(2130, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '06-09-2025 12:58:51'),
(2131, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.112.52.253', '992', '07-09-2025 02:46:11'),
(2132, 'Hospital Admin', 'admin@hms.com', 'Admin', '202.125.75.234', '992', '07-09-2025 04:48:36'),
(2133, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.112.52.253', '992', '07-09-2025 04:58:00'),
(2134, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '07-09-2025 04:59:03'),
(2135, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.112.52.253', '992', '07-09-2025 04:59:10'),
(2136, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '07-09-2025 06:51:40'),
(2137, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.25.250.131', '992', '07-09-2025 13:09:33'),
(2138, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.112.52.253', '992', '07-09-2025 14:48:06'),
(2139, 'Mr Doctor', 'doctor@hms.com', 'Doctor', '103.112.52.253', '992', '08-09-2025 04:00:29'),
(2140, 'Hospital Admin', 'admin@hms.com', 'Admin', '110.76.128.67', '992', '08-09-2025 06:15:26'),
(2141, 'Hospital Admin', 'admin@hms.com', 'Admin', '103.231.162.56', '992', '08-09-2025 06:42:21');

-- --------------------------------------------------------

--
-- Stand-in structure for view `low_stock_items`
-- (See below for the actual view)
--
CREATE TABLE `low_stock_items` (
`id` int(11)
,`item_code` varchar(50)
,`name` varchar(255)
,`category` varchar(100)
,`current_stock` int(11)
,`reorder_level` int(11)
,`minimum_stock` int(11)
,`unit_cost` decimal(10,2)
,`hospital_id` int(11)
,`shortage_quantity` bigint(12)
);

-- --------------------------------------------------------

--
-- Table structure for table `macro`
--

CREATE TABLE `macro` (
  `id` int(100) NOT NULL,
  `short_name` varchar(1000) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_by` varchar(1000) DEFAULT NULL,
  `created_by_name` varchar(1000) DEFAULT NULL,
  `date_time` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `macro`
--

INSERT INTO `macro` (`id`, `short_name`, `description`, `created_by`, `created_by_name`, `date_time`, `hospital_id`) VALUES
(17, 'rtertert', '<p>gvghcgch</p><p>mnnghnghn</p>', '992', 'Hospital', '1659002445', '98');

-- --------------------------------------------------------

--
-- Table structure for table `manualemailshortcode`
--

CREATE TABLE `manualemailshortcode` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `type` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `manualemailshortcode`
--

INSERT INTO `manualemailshortcode` (`id`, `name`, `type`) VALUES
(1, '{firstname}', 'email'),
(2, '{lastname}', 'email'),
(3, '{name}', 'email'),
(6, '{address}', 'email'),
(7, '{company}', 'email'),
(8, '{email}', 'email'),
(9, '{phone}', 'email');

-- --------------------------------------------------------

--
-- Table structure for table `manualsmsshortcode`
--

CREATE TABLE `manualsmsshortcode` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `type` varchar(1000) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `manualsmsshortcode`
--

INSERT INTO `manualsmsshortcode` (`id`, `name`, `type`) VALUES
(1, '{firstname}', 'sms'),
(2, '{lastname}', 'sms'),
(3, '{name}', 'sms'),
(4, '{email}', 'sms'),
(5, '{phone}', 'sms'),
(6, '{address}', 'sms'),
(10, '{company}', 'sms');

-- --------------------------------------------------------

--
-- Table structure for table `manual_email_template`
--

CREATE TABLE `manual_email_template` (
  `id` int(100) NOT NULL,
  `name` varchar(1000) DEFAULT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `type` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL,
  `added_by` varchar(300) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `manual_email_template`
--

INSERT INTO `manual_email_template` (`id`, `name`, `message`, `type`, `hospital_id`, `added_by`) VALUES
(19, 'Super Admin Template', '<p>{phone}</p>\r\n\r\n<p>{email}</p>\r\n', 'email', 'superadmin', '1'),
(20, 'Super Admin Template 2', '<p>{company}</p>\r\n\r\n<p>{address}</p>\r\n', 'email', 'superadmin', '1'),
(21, 'test', '<p>dfgdfgd</p>', 'email', '98', '992');

-- --------------------------------------------------------

--
-- Table structure for table `manual_sms_template`
--

CREATE TABLE `manual_sms_template` (
  `id` int(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `medical_history`
--

CREATE TABLE `medical_history` (
  `id` int(100) NOT NULL,
  `patient_id` varchar(100) DEFAULT NULL,
  `doctor_id` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` varchar(10000) DEFAULT NULL,
  `patient_name` varchar(100) DEFAULT NULL,
  `patient_address` varchar(500) DEFAULT NULL,
  `patient_phone` varchar(100) DEFAULT NULL,
  `img_url` varchar(500) DEFAULT NULL,
  `date` varchar(100) DEFAULT NULL,
  `registration_time` varchar(100) DEFAULT NULL,
  `diagnosis_id` varchar(1000) DEFAULT NULL,
  `treatment_id` varchar(1000) DEFAULT NULL,
  `symptom_id` varchar(1000) DEFAULT NULL,
  `test_id` varchar(1000) DEFAULT NULL,
  `advice_id` varchar(1000) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `medical_history`
--

INSERT INTO `medical_history` (`id`, `patient_id`, `doctor_id`, `title`, `description`, `patient_name`, `patient_address`, `patient_phone`, `img_url`, `date`, `registration_time`, `diagnosis_id`, `treatment_id`, `symptom_id`, `test_id`, `advice_id`, `hospital_id`) VALUES
(150, '53', '44', 'Suspected Dengue Fever', '<p>Patient is a 29-year-old male who returned from a trip to Dhaka 3 days ago. Fever started 2 days after return. No previous history of similar illness. No chronic conditions. No known allergies. No recent vaccinations. Patient is otherwise healthy and not on any regular medication</p>', 'Mr Patient', 'Bashundhara, Dhaka', '01749335508', NULL, '1757008800', NULL, '8', '15', '61', '86', '16', '98');

-- --------------------------------------------------------

--
-- Table structure for table `medicine`
--

CREATE TABLE `medicine` (
  `id` int(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `box` varchar(100) DEFAULT NULL,
  `s_price` varchar(100) DEFAULT NULL,
  `quantity` int(100) DEFAULT NULL,
  `generic` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `effects` varchar(100) DEFAULT NULL,
  `e_date` varchar(70) DEFAULT NULL,
  `add_date` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `medicine`
--

INSERT INTO `medicine` (`id`, `name`, `category`, `price`, `box`, `s_price`, `quantity`, `generic`, `company`, `effects`, `e_date`, `add_date`, `hospital_id`) VALUES
(14, 'Test Medicine', 'Antibiotic', '10', '100', '15', 400, 'dgdfg', 'dgfdg', 'dfgfdg', '30-11-2023', '11/20/23', '114'),
(13, 'O extra', NULL, '30', '44', '35', 2000, 'Pracetimol', 'Square', 'dsdsds', '16-08-2020', '30/04/23', '111'),
(33, 'Napa', 'Categtory', '10', 'A4', '12', 576, 'Parecetamol', 'CODE ARISTOS INC', '', '02-12-2025', '08/10/25', '98'),
(35, 'Ace', 'Antibiotic', '10', '100', '12', 458, 'fdgdfg', 'dgdg', 'dfgfdg', '17-09-2025', '08/27/25', '98');

-- --------------------------------------------------------

--
-- Table structure for table `medicine_batches`
--

CREATE TABLE `medicine_batches` (
  `id` int(11) NOT NULL,
  `medicine_id` int(11) NOT NULL,
  `batch_number` varchar(100) NOT NULL,
  `manufacturing_date` date DEFAULT NULL,
  `expiry_date` date NOT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `purchase_item_id` int(11) DEFAULT NULL,
  `quantity_received` int(11) NOT NULL DEFAULT 0,
  `quantity_sold` int(11) NOT NULL DEFAULT 0,
  `quantity_expired` int(11) NOT NULL DEFAULT 0,
  `quantity_damaged` int(11) NOT NULL DEFAULT 0,
  `quantity_returned` int(11) NOT NULL DEFAULT 0,
  `current_stock` int(11) NOT NULL DEFAULT 0,
  `unit_cost` decimal(10,2) DEFAULT 0.00,
  `selling_price` decimal(10,2) DEFAULT 0.00,
  `mrp` decimal(10,2) DEFAULT 0.00,
  `location` varchar(255) DEFAULT NULL,
  `storage_conditions` varchar(255) DEFAULT NULL,
  `status` enum('active','expired','low_stock','out_of_stock','damaged') DEFAULT 'active',
  `alert_before_days` int(11) DEFAULT 30,
  `notes` text DEFAULT NULL,
  `hospital_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `medicine_batches`
--

INSERT INTO `medicine_batches` (`id`, `medicine_id`, `batch_number`, `manufacturing_date`, `expiry_date`, `manufacturer`, `supplier_id`, `purchase_item_id`, `quantity_received`, `quantity_sold`, `quantity_expired`, `quantity_damaged`, `quantity_returned`, `current_stock`, `unit_cost`, `selling_price`, `mrp`, `location`, `storage_conditions`, `status`, `alert_before_days`, `notes`, `hospital_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 35, 'sdfsdfsf', '2025-08-01', '2025-09-30', 'dsfsdfdsf', 1, 1, 500, 42, 0, 0, 0, 458, 10.00, 12.00, 0.00, NULL, NULL, 'active', 30, NULL, 98, '2025-08-27 07:16:13', '2025-09-06 08:27:27', NULL, NULL),
(2, 33, 'werwerwr', '2025-08-01', '2025-09-27', 'sdfsfsf', 1, 2, 500, 24, 0, 0, 0, 476, 10.00, 12.00, 0.00, NULL, NULL, 'active', 30, NULL, 98, '2025-08-27 07:16:13', '2025-09-06 08:11:21', NULL, NULL),
(3, 33, 'dsfsdfdsf', NULL, '2025-10-31', 'dsfsdfdsf', 1, 3, 100, 0, 0, 0, 0, 100, 10.00, 12.00, 0.00, NULL, NULL, 'active', 30, NULL, 98, '2025-09-04 04:19:18', '2025-09-04 04:19:18', NULL, NULL);

--
-- Triggers `medicine_batches`
--
DELIMITER $$
CREATE TRIGGER `log_stock_movement_on_batch_update` AFTER UPDATE ON `medicine_batches` FOR EACH ROW BEGIN
    IF OLD.current_stock != NEW.current_stock THEN
        INSERT INTO medicine_stock_movements (
            medicine_id, 
            batch_id, 
            movement_type, 
            quantity, 
            unit_cost, 
            movement_date, 
            notes, 
            hospital_id
        ) VALUES (
            NEW.medicine_id,
            NEW.id,
            'adjustment',
            NEW.current_stock - OLD.current_stock,
            NEW.unit_cost,
            NOW(),
            CONCAT('Stock adjusted from ', OLD.current_stock, ' to ', NEW.current_stock),
            NEW.hospital_id
        );
    END IF;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `update_medicine_stock_on_batch_change` AFTER UPDATE ON `medicine_batches` FOR EACH ROW BEGIN
    DECLARE total_stock INT DEFAULT 0;
    DECLARE medicine_exists INT DEFAULT 0;
    
    -- Check if medicine table exists and has the record
    SELECT COUNT(*) INTO medicine_exists 
    FROM information_schema.tables 
    WHERE table_schema = DATABASE() 
    AND table_name = 'medicine';
    
    IF medicine_exists > 0 THEN
        SELECT COUNT(*) INTO medicine_exists
        FROM medicine 
        WHERE id = NEW.medicine_id;
        
        IF medicine_exists > 0 THEN
            SELECT COALESCE(SUM(current_stock), 0) INTO total_stock 
            FROM medicine_batches 
            WHERE medicine_id = NEW.medicine_id;
            
            UPDATE medicine 
            SET quantity = total_stock 
            WHERE id = NEW.medicine_id;
        END IF;
    END IF;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `update_medicine_stock_on_batch_insert` AFTER INSERT ON `medicine_batches` FOR EACH ROW BEGIN
    DECLARE total_stock INT DEFAULT 0;
    DECLARE medicine_exists INT DEFAULT 0;
    
    -- Check if medicine table exists and has the record
    SELECT COUNT(*) INTO medicine_exists 
    FROM information_schema.tables 
    WHERE table_schema = DATABASE() 
    AND table_name = 'medicine';
    
    IF medicine_exists > 0 THEN
        SELECT COUNT(*) INTO medicine_exists
        FROM medicine 
        WHERE id = NEW.medicine_id;
        
        IF medicine_exists > 0 THEN
            SELECT COALESCE(SUM(current_stock), 0) INTO total_stock 
            FROM medicine_batches 
            WHERE medicine_id = NEW.medicine_id;
            
            UPDATE medicine 
            SET quantity = total_stock 
            WHERE id = NEW.medicine_id;
        END IF;
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `medicine_category`
--

CREATE TABLE `medicine_category` (
  `id` int(100) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `hospital_id` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `medicine_category`
--

INSERT INTO `medicine_category` (`id`, `category`, `description`, `hospital_id`) VALUES
(8, 'Antibiotic', 'xcvcxv', '114'),
(11, 'Categtory', 'sdvcdsfvc', '98'),
(12, 'Antibiotic', 'dfgdfgdfg', '98');

-- --------------------------------------------------------

--
-- Stand-in structure for view `medicine_expiring_soon`
-- (See below for the actual view)
--
CREATE TABLE `medicine_expiring_soon` (
`medicine_id` int(100)
,`medicine_name` varchar(100)
,`generic` varchar(100)
,`batch_id` int(11)
,`batch_number` varchar(100)
,`expiry_date` date
,`current_stock` int(11)
,`days_to_expiry` int(8)
,`value_at_risk` decimal(20,2)
,`hospital_id` varchar(100)
,`supplier_name` varchar(255)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `medicine_low_stock`
-- (See below for the actual view)
--
