INSERT INTO `p2p_system_log` (`logid`, `employee_id`, `designation`, `department`, `module_id`, `description`, `ip`, `updated_by`, `log_title`, `table_affected`, `reference_id`, `from_data`, `to_data`, `operation`, `date_updated`, `transaction_done_by`) VALUES
(785, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division Add Operation', ' mm_sub_division', 21, '[]', '{\"plant_code\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"demo 1\",\"sub_division_name\":\"demo 1\",\"description\":\"demo 1\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 14:12:33', 1),
(786, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 23, '[]', '{\"plant_id\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"demo 1\",\"department_code\":\"DEPT 1\",\"department_name\":\"DEPT 1\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 14:13:04', 1),
(787, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 24, '[]', '{\"plant_id\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"Subdivison0123\",\"department_code\":\"DEPARTMENT \",\"department_name\":\"DEPARTMENT \",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 14:13:51', 1),
(788, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 25, '[]', '{\"plant_id\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"demo 1\",\"department_code\":\"TESTING \",\"department_name\":\"TESTING 1\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 14:14:23', 1),
(789, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 26, '[]', '{\"plant_id\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"Testing 1234\",\"department_code\":\"DEPT1122\",\"department_name\":\"Hibiscus\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 17:53:03', 1),
(790, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 0, '[]', '{\"division_id\":\"8\",\"budget\":\"20000\",\"plant_id\":\"10\",\"plant_budget\":\"50000\",\"available_budget\":\"50000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 17:55:00', 1),
(791, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 19, '[]', '{\"plant_id\":\"10\",\"division_id\":\"8\",\"sub_division_id\":\"15\",\"division_budget\":\"20000\",\"budget\":\"6000\",\"available_budget\":\"-40000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 17:55:37', 1),
(792, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 20, '[]', '{\"plant_id\":\"10\",\"division_id\":\"8\",\"sub_division_id\":\"15\",\"division_budget\":\"20000\",\"budget\":\"6000\",\"available_budget\":\"-46000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-30 17:56:41', 1),
(793, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Category Add Operation', 'mm_material_category', 29, '[]', '{\"category_name\":\"Demo Testing 123\",\"description\":\"Demo Testing 123\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 10:05:35', 1),
(794, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Plant Add Operation', 'mm_plants', 11, '[]', '{\"plant_code\":\"PLT011\",\"plant_name\":\"MUMBAI \",\"location_one\":\"Thane \",\"location_two\":\"Thane 1\",\"location_three\":\"Mumbai \",\"description\":\"Testing \",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-08-31 10:09:18', 1),
(795, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":11,\"c_name\":\"Bhagyashri Patil\",\"c_number\":\"07058102616\",\"c_email\":\"bhagyashri.patil@salasarauction.com\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-08-31 10:09:18', 1),
(796, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division Add Operation', 'mm_plants', 0, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV011\",\"division_name\":\"Testing 011\",\"description\":\"Testing 011\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 10:10:00', 1),
(797, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division Add Operation', ' mm_sub_division', 22, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV011\",\"sub_division_code\":\"SUB 011\",\"sub_division_name\":\"Testing 011\",\"description\":\"Testing 011\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 10:14:47', 1),
(798, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 27, '[]', '{\"plant_id\":\"PLT011\",\"division_code\":\"DIV011\",\"sub_division_code\":\"SUB 011\",\"department_code\":\"Dept 011\",\"department_name\":\"Testing 011\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 10:15:42', 1),
(799, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 0, '[]', '{\"division_id\":\"3\",\"budget\":\"50000\",\"plant_id\":\"2\",\"plant_budget\":\"400000\",\"available_budget\":\"400000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 11:10:16', 1),
(800, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 21, '[]', '{\"plant_id\":\"2\",\"division_id\":\"3\",\"sub_division_id\":\"5\",\"division_budget\":\"50000\",\"budget\":\"10000\",\"available_budget\":\"20000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 11:10:30', 1),
(801, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 0, '[]', '{\"division_id\":\"15\",\"budget\":\"50000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"200000\",\"available_budget\":\"200000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 11:33:45', 1),
(802, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 0, '[]', '{\"division_id\":\"15\",\"budget\":\"50000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"200000\",\"available_budget\":\"150000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 11:59:59', 1),
(803, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 1, '[]', '{\"division_id\":\"DIV011\",\"budget\":\"20000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"100000\",\"available_budget\":\"100000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 13:08:05', 1),
(804, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 2, '[]', '{\"division_id\":\"DIV011\",\"budget\":\"10000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"100000\",\"available_budget\":\"80000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 13:27:59', 1),
(805, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division_budget Add Operation', 'mm_division_budget', 3, '[]', '{\"division_id\":\"DIV011\",\"budget\":\"10000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"100000\",\"available_budget\":\"70000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 13:28:58', 1),
(806, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division Budget Edit Operation', 'mm_division_budget_id', 2, '\"{\\\"division_id\\\":\\\"DIV011\\\",\\\"budget\\\":\\\"10000\\\",\\\"plant_id\\\":\\\"PLT011\\\",\\\"plant_budget\\\":\\\"100000\\\",\\\"available_budget\\\":\\\"80000\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"division_id\":\"DIV011\",\"budget\":\"10000\",\"plant_id\":\"PLT011\",\"plant_budget\":\"100000\",\"available_budget\":\"80000\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-08-31 13:34:21', 1),
(807, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-08-31 14:00:01', 1),
(808, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-08-31 14:00:10', 1),
(809, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-08-31 14:00:20', 1),
(810, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-08-31 14:00:34', 1),
(811, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-08-31 14:00:43', 1),
(812, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Add Operation', 'mm_materials', 10, '[]', '{\"plant_code\":\"PLT001,PLT003\",\"material_code\":\"MAT010\",\"material_name\":\"demo321\",\"brief_description\":\"demo321\",\"unit_code\":\"54,54,52\",\"average_price\":\"3000\",\"bin_location\":\"mumbai,mumbai\",\"preservation_code\":\"P001\",\"category\":\"3\",\"hsn_code\":\"Hsn001\",\"minimum_balance\":\"5000\",\"reorder_level\":\"5\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 14:37:08', 1),
(813, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division Add Operation', 'mm_plants', 24, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV001111\",\"division_name\":\"D Division\",\"description\":\"D Division\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 15:17:38', 1),
(814, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Division Edit Operation', 'mm_division', 15, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV011\",\"division_name\":\"Testing 011\",\"description\":\"Testing 011\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-08-31 15:17:53', 1),
(815, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Sub Division Add Operation', ' mm_sub_division', 23, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV001111\",\"sub_division_code\":\"Subdivison001111\",\"sub_division_name\":\"S SUB-DIVISION001111\",\"description\":\"S SUB-DIVISION001111\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 15:19:32', 1),
(816, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Department Add Operation', 'mm_department', 28, '[]', '{\"plant_id\":\"PLT011\",\"division_code\":\"DIV001111\",\"sub_division_code\":\"Subdivison001111\",\"department_code\":\"DEPARTMENT001111\",\"department_name\":\"DEPARTMENT\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-08-31 16:41:05', 1),
(817, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Company Edit Operation', 'mm_company', 10, '\"{\\\"company_name\\\":\\\"SURAJ PVT LTD \\\",\\\"owner_name\\\":\\\"Suraj Yadav\\\",\\\"city\\\":\\\"Mumbai\\\",\\\"address_one\\\":\\\"Opal Square, Thane West, Mumbai \\\",\\\"address_two\\\":\\\"Mumbai 400604 \\\",\\\"state\\\":\\\"Maharashtra\\\",\\\"pin_code\\\":\\\"400604\\\",\\\"pan_no\\\":\\\"GFH1122KK\\\",\\\"gst_no\\\":\\\"09AAACH7409R1ZZ\\\",\\\"cin\\\":\\\"sgh24567\\\",\\\"email\\\":\\\"bhagyashri.patil@salasarauction.com\\\",\\\"contact\\\":\\\"7887557950\\\",\\\"website\\\":\\\"https: mm.aonesalasar.com\\\\\\/\\\",\\\"type_of_business\\\":\\\"Manufacturer\\\",\\\"description_of_company\\\":\\\"Materials management uses inventories and production requirements for planning and control to ensure materials are available as required to meet production schedules. This material planning includes managing logistics, stock levels, materials quality, cost and more.\\\",\\\"no_of_units\\\":\\\"1\\\",\\\"spoc_name\\\":\\\"Suraj Yadav \\\",\\\"spoc_mob\\\":\\\"7887557950\\\",\\\"spoc_email\\\":\\\"suraj.yadav@salasarauction.com\\\",\\\"spoc_designation\\\":\\\"Test 111\\\",\\\"created_by\\\":\\\"\\\"}\"', '{\"company_name\":\"SURAJ PVT LTD 1\",\"owner_name\":\"Suraj Yadav\",\"city\":\"Mumbai\",\"address_one\":\"Opal Square, Thane West, Mumbai \",\"address_two\":\"Mumbai 400604 \",\"state\":\"Maharashtra\",\"pin_code\":\"400604\",\"pan_no\":\"GFH1122KK\",\"gst_no\":\"09AAACH7409R1ZZ\",\"cin\":\"sgh24567\",\"email\":\"bhagyashri.patil@salasarauction.com\",\"contact\":\"2147483647\",\"website\":\"https: mm.aonesalasar.com\\/\",\"type_of_business\":\"Manufacturer\",\"description_of_company\":\"Materials management uses inventories and production requirements for planning and control to ensure materials are available as required to meet production schedules. This material planning includes m\",\"no_of_units\":\"1\",\"spoc_name\":\"Suraj Yadav \",\"spoc_mob\":\"2147483647\",\"spoc_email\":\"suraj.yadav@salasarauction.com\",\"spoc_designation\":\"Test 111\",\"updated_by\":\"\"}', 'Edit', '2024-09-02 14:51:01', 1),
(818, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Company Add Operation', 'mm_company', 0, '[]', '{\"company_name\":\"demo company\",\"owner_name\":\"Arun nimma\",\"city\":\"sion\",\"address_one\":\"sion\",\"address_two\":\"thane\",\"state\":\"maharashtra\",\"pin_code\":\"400607\",\"pan_no\":\"Bk54Jk001\",\"gst_no\":\"GST001\",\"cin\":\"C001\",\"email\":\"Arun@gmail.com\",\"contact\":\"8956236582\",\"website\":\"\",\"type_of_business\":\"\",\"description_of_company\":\"\",\"no_of_units\":\"\",\"spoc_name\":\"arun \",\"spoc_mob\":\"9638529562\",\"spoc_email\":\"\",\"spoc_designation\":\"\",\"created_by\":\"\"}', 'Add', '2024-09-02 14:52:23', 1),
(819, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Company Edit Operation', 'mm_company', 0, '\"{\\\"company_name\\\":\\\"demo company\\\",\\\"owner_name\\\":\\\"Arun nimma\\\",\\\"city\\\":\\\"sion\\\",\\\"address_one\\\":\\\"sion\\\",\\\"address_two\\\":\\\"thane\\\",\\\"state\\\":\\\"maharashtra\\\",\\\"pin_code\\\":\\\"400607\\\",\\\"pan_no\\\":\\\"Bk54Jk001\\\",\\\"gst_no\\\":\\\"GST001\\\",\\\"cin\\\":\\\"C001\\\",\\\"email\\\":\\\"Arun@gmail.com\\\",\\\"contact\\\":\\\"8956236582\\\",\\\"website\\\":\\\"\\\",\\\"type_of_business\\\":\\\"\\\",\\\"description_of_company\\\":\\\"\\\",\\\"no_of_units\\\":\\\"\\\",\\\"spoc_name\\\":\\\"arun \\\",\\\"spoc_mob\\\":\\\"9638529562\\\",\\\"spoc_email\\\":\\\"\\\",\\\"spoc_designation\\\":\\\"\\\",\\\"created_by\\\":\\\"\\\"}\"', '{\"company_name\":\"demo company\",\"owner_name\":\"Arun nimma\",\"city\":\"sion\",\"address_one\":\"sion\",\"address_two\":\"thane\",\"state\":\"maharashtra\",\"pin_code\":\"400607\",\"pan_no\":\"Bk54Jk001\",\"gst_no\":\"GST001\",\"cin\":\"C001\",\"email\":\"Arun@gmail.com\",\"contact\":\"8956236582\",\"website\":\"\",\"type_of_business\":\"\",\"description_of_company\":\"\",\"no_of_units\":\"0\",\"spoc_name\":\"arun \",\"spoc_mob\":\"9638529562\",\"spoc_email\":\"\",\"spoc_designation\":\"\",\"updated_by\":\"\"}', 'Edit', '2024-09-02 14:52:53', 1),
(820, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"c_name\":\"suraj yadav\",\"c_number\":\"5236589652\",\"c_email\":\"suraj@gmail.com\",\"cmp_id\":\"\",\"plant_id\":\"11\",\"created_by\":\"1\"}', 'Add', '2024-09-02 14:53:24', 1),
(821, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Contact Person Edit Operation', 'mm_contact_person', 0, '\"{\\\"c_name\\\":\\\"suraj yadav\\\",\\\"c_number\\\":\\\"5236589652\\\",\\\"c_email\\\":\\\"suraj@gmail.com\\\",\\\"cmp_id\\\":\\\"\\\",\\\"plant_id\\\":\\\"11\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"c_name\":\"Bhagyashri Patil \",\"c_number\":\"70581026165\",\"c_email\":\"bhagyashri.patil@salasarauction.com\",\"cmp_id\":\"\",\"plant_id\":\"11\",\"updated_by\":\"1\"}', 'Edit', '2024-09-02 14:53:32', 1),
(822, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Contact Person Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-02 14:53:43', 1),
(823, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Contact Person Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-02 14:53:47', 1),
(824, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Edit Operation', 'mm_materials', 4, '\"{\\\"plant_code\\\":\\\"PLT001\\\",\\\"material_code\\\":\\\"M003\\\",\\\"material_name\\\":\\\"ACID\\\",\\\"brief_description\\\":\\\" Some acids made by the body, such as gastric acid, can help organs work the way they should.\\\",\\\"unit_code\\\":\\\"LTR \\\",\\\"average_price\\\":\\\"5000\\\",\\\"title \\\":\\\"acid \\\",\\\"bin_location\\\":\\\"Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PRC123\\\",\\\"category\\\":\\\"vital\\\",\\\"hsn_code\\\":\\\"HSN0123\\\",\\\"minimum_balance\\\":\\\"5000\\\",\\\"reorder_level\\\":\\\"REO0123\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT001\",\"material_code\":\"M003\",\"material_name\":\"ACID\",\"brief_description\":\" Some acids made by the body, such as gastric acid, can help organs work the way they should.\",\"unit_code\":\"KG,LTR \",\"average_price\":\"5000\",\"bin_location\":\"Thane Mumbai \",\"preservation_code\":\"PRC123\",\"category\":\"\",\"hsn_code\":\"HSN0123\",\"minimum_balance\":\"5000\",\"reorder_level\":\"REO0123\",\"updated_by\":\"1\"}', 'Edit', '2024-09-02 18:35:00', 1),
(825, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'RFQ Delete Operation', 'mm_rfq', 0, '[]', 'null', 'Delete', '2024-09-02 18:43:26', 1),
(826, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Edit Operation', 'mm_materials', 4, '\"{\\\"plant_code\\\":\\\"PLT001\\\",\\\"material_code\\\":\\\"M003\\\",\\\"material_name\\\":\\\"ACID\\\",\\\"brief_description\\\":\\\" Some acids made by the body, such as gastric acid, can help organs work the way they should.\\\",\\\"unit_code\\\":\\\"KG,LTR \\\",\\\"average_price\\\":\\\"5000\\\",\\\"bin_location\\\":\\\"Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PRC123\\\",\\\"category\\\":\\\"\\\",\\\"hsn_code\\\":\\\"HSN0123\\\",\\\"minimum_balance\\\":\\\"5000\\\",\\\"reorder_level\\\":\\\"REO0123\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT001\",\"material_code\":\"M003\",\"material_name\":\"ACID\",\"brief_description\":\" A chemical that gives off hydrogen ions in water and forms salts by combining with certain metals. Acids have a sour taste and turn certain dyes red. Some acids made by the body, such as gastric acid, can help organs work the way they should.\",\"unit_code\":\"KG,LTR \",\"average_price\":\"5000\",\"bin_location\":\"Thane Mumbai \",\"preservation_code\":\"PRC123\",\"category\":\"\",\"hsn_code\":\"HSN0123\",\"minimum_balance\":\"5000\",\"reorder_level\":\"REO0123\",\"updated_by\":\"1\"}', 'Edit', '2024-09-11 14:57:33', 1),
(827, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Edit Operation', 'mm_materials', 4, '\"{\\\"plant_code\\\":\\\"PLT001\\\",\\\"material_code\\\":\\\"M003\\\",\\\"material_name\\\":\\\"ACID\\\",\\\"brief_description\\\":\\\" A chemical that gives off hydrogen ions in water and forms salts by combining with certain metals. Acids have a sour taste and turn certain dyes red. Some acids made by the body, such as gastric acid, can help organs work the way they should.\\\",\\\"unit_code\\\":\\\"KG,LTR \\\",\\\"average_price\\\":\\\"5000\\\",\\\"bin_location\\\":\\\"Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PRC123\\\",\\\"category\\\":\\\"\\\",\\\"hsn_code\\\":\\\"HSN0123\\\",\\\"minimum_balance\\\":\\\"5000\\\",\\\"reorder_level\\\":\\\"REO0123\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT010,PLT001,PLT001\",\"material_code\":\"M003\",\"material_name\":\"ACID\",\"brief_description\":\" A chemical that gives off hydrogen ions in water and forms salts by combining with certain metals. Acids have a sour taste and turn certain dyes red. Some acids made by the body, such as gastric acid, can help organs work the way they should.\",\"unit_code\":\"KG,LTR ,KG,LTR \",\"average_price\":\"5000\",\"bin_location\":\"united kingdom,Thane Mumbai ,Thane Mumbai \",\"preservation_code\":\"PRC123\",\"category\":\"\",\"hsn_code\":\"HSN0123\",\"minimum_balance\":\"5000\",\"reorder_level\":\"REO0123\",\"updated_by\":\"1\"}', 'Edit', '2024-09-11 15:28:49', 1),
(828, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'sanket', 'Material Edit Operation', 'mm_materials', 4, '\"{\\\"plant_code\\\":\\\"PLT010,PLT001,PLT001\\\",\\\"material_code\\\":\\\"M003\\\",\\\"material_name\\\":\\\"ACID\\\",\\\"brief_description\\\":\\\" A chemical that gives off hydrogen ions in water and forms salts by combining with certain metals. Acids have a sour taste and turn certain dyes red. Some acids made by the body, such as gastric acid, can help organs work the way they should.\\\",\\\"unit_code\\\":\\\"KG,LTR ,KG,LTR \\\",\\\"average_price\\\":\\\"5000\\\",\\\"bin_location\\\":\\\"united kingdom,Thane Mumbai ,Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PRC123\\\",\\\"category\\\":\\\"\\\",\\\"hsn_code\\\":\\\"HSN0123\\\",\\\"minimum_balance\\\":\\\"5000\\\",\\\"reorder_level\\\":\\\"REO0123\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT010,PLT001,PLT001,PLT010,PLT001,PLT001\",\"material_code\":\"M003\",\"material_name\":\"ACID\",\"brief_description\":\" A chemical that gives off hydrogen ions in water and forms salts by combining with certain metals. Acids have a sour taste and turn certain dyes red. Some acids made by the body, such as gastric acid, can help organs work the way they should.\",\"unit_code\":\"KG,LTR \",\"average_price\":\"5000\",\"bin_location\":\"united kingdom,Thane Mumbai ,Thane Mumbai ,united kingdom,Thane Mumbai ,Thane Mumbai \",\"preservation_code\":\"PRC123\",\"category\":\"\",\"hsn_code\":\"HSN0123\",\"minimum_balance\":\"5000\",\"reorder_level\":\"REO0123\",\"updated_by\":\"1\"}', 'Edit', '2024-09-11 15:29:37', 1),
(829, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Add Operation', 'mm_plants', 12, '[]', '{\"plant_code\":\"PLT012\",\"plant_name\":\"Demoyd789\",\"location_one\":\"1\",\"location_two\":\"2\",\"location_three\":\"3\",\"description\":\"testing\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-09-20 11:42:28', 1),
(830, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":12,\"c_name\":\"yd\",\"c_number\":\"987654321\",\"c_email\":\"yd.123@email.com\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-09-20 11:42:28', 1),
(831, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Add Operation', 'mm_plants', 25, '[]', '{\"plant_code\":\"PLT012\",\"division_code\":\"Div789\",\"division_name\":\"Div789\",\"description\":\"Div789\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:42:54', 1),
(832, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Sub Division Add Operation', ' mm_sub_division', 24, '[]', '{\"plant_code\":\"PLT012\",\"division_code\":\"Div789\",\"sub_division_code\":\"SubDiv789\",\"sub_division_name\":\"SubDiv789\",\"description\":\"SubDiv789\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:43:14', 1),
(833, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Department Add Operation', 'mm_department', 29, '[]', '{\"plant_id\":\"PLT012\",\"division_code\":\"Div789\",\"sub_division_code\":\"SubDiv789\",\"department_code\":\"Dep789\",\"department_name\":\"Dep789\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:43:44', 1),
(834, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Designation Add Operation', 'mm_designation', 0, '[]', '{\"designation\":\"P2P exe\",\"department\":\"29\",\"description\":\"Test\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:44:37', 1),
(835, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Permission Module Add Operation', 'mm_permission_module', 0, '[]', '{\"module\":\"MOD789\",\"description\":\"MOD789\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:45:59', 1),
(836, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Permission Sub Module Add Operation', ' mm_permission_submodule', 0, '[]', '{\"permission_module_id\":\"0\",\"sub_module\":\"SubMod789\",\"description\":\"SubMod789\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:46:14', 1),
(837, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Permission Add Operation', 'mm_designation', 0, '[]', '{\"module\":\"0\",\"sub_module\":\"0\",\"permissions\":\"AED\",\"department\":\"29\",\"designation\":\"0\",\"description\":\"test\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:46:36', 1),
(838, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Edit Operation', 'mm_company', 11, '\"{\\\"plant_code\\\":\\\"PLT011\\\",\\\"plant_name\\\":\\\"MUMBAI \\\",\\\"location_one\\\":\\\"Thane \\\",\\\"location_two\\\":\\\"Thane 1\\\",\\\"location_three\\\":\\\"Mumbai \\\",\\\"description\\\":\\\"Testing \\\",\\\"cmp_id\\\":\\\"1\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT011\",\"plant_name\":\"MUMBAI 12123423235\",\"location_one\":\"Thane \",\"location_two\":\"Thane 1\",\"location_three\":\"Mumbai \",\"description\":\"Testing \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:49:38', 1),
(839, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Edit Operation', 'mm_company', 11, '\"{\\\"c_name\\\":\\\"Saurav\\\",\\\"c_number\\\":\\\"7865789876\\\",\\\"c_email\\\":\\\"saurav712000@gmail.com\\\",\\\"company_id\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"c_name\":\"Bhagyashri Patil \",\"c_number\":\"70581026165\",\"c_email\":\"bhagyashri.patil@salasarauction.com\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:49:38', 1),
(840, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-20 11:49:41', 1),
(841, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Edit Operation', 'mm_division', 24, '[]', '{\"plant_code\":\"PLT011\",\"division_code\":\"DIV00111123r3fr3\",\"division_name\":\"D Division\",\"description\":\"D Division\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:49:49', 1),
(842, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Delete Operation', 'mm_division', 0, '[]', 'null', 'Delete', '2024-09-20 11:49:53', 1),
(843, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Sub Division Edit Operation', 'mm_sub_division', 23, '[]', '{\"plant_code\":\"PLT010\",\"division_code\":\"DIV00015353\",\"sub_division_code\":\"Subdivison001111 descwcwcw\",\"sub_division_name\":\"S SUB-DIVISION001111\",\"description\":\"S SUB-DIVISION001111\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:50:26', 1),
(844, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'subDivision Delete Operation', 'mm_sub_division', 0, '[]', 'null', 'Delete', '2024-09-20 11:50:30', 1),
(845, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Employee Delete Operation', 'mm_employee', 0, '[]', 'null', 'Delete', '2024-09-20 11:52:01', 1),
(846, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Add Operation', 'mm_materials', 11, '[]', '{\"plant_code\":\"PLT009,PLT012\",\"material_code\":\"MAT011\",\"material_name\":\"demo Material 789\",\"brief_description\":\"789\",\"unit_code\":\"Kg,Ton,MT\",\"average_price\":\"15000\",\"bin_location\":\"Section 2, warehouse 9,Section 2, warehouse 1 \",\"preservation_code\":\"no need\",\"category\":\"29\",\"hsn_code\":\"0001.01.01\",\"minimum_balance\":\"200\",\"reorder_level\":\"100\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:53:46', 1),
(847, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Edit Operation', 'mm_materials', 9, '\"{\\\"plant_code\\\":\\\"PLT006,PLT006,PLT009,PLT008\\\",\\\"material_code\\\":\\\"MAT09\\\",\\\"material_name\\\":\\\"Nikalo \\\",\\\"brief_description\\\":\\\"ok ok \\\",\\\"quantity\\\":\\\"0\\\",\\\"unit_code\\\":\\\"MT,MT,Kg,Ton\\\",\\\"average_price\\\":\\\"1500\\\",\\\"title \\\":\\\"Jabba456\\\",\\\"bin_location\\\":\\\"Section 2, warehouse 3,Section 2, warehouse 3,Section 2, warehouse 1 ,Section 2, warehouse 8\\\",\\\"preservation_code\\\":\\\"Khulla Rakh\\\",\\\"category\\\":\\\"essential\\\",\\\"hsn_code\\\":\\\"0001.01.01\\\",\\\"minimum_balance\\\":\\\"200\\\",\\\"reorder_level\\\":\\\"100\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT006,PLT006,PLT009,PLT008\",\"material_code\":\"MAT09\",\"material_name\":\"Nikalo wwwwww\",\"brief_description\":\"ok ok \",\"unit_code\":\"MT,MT,Kg,Ton\",\"average_price\":\"1500\",\"bin_location\":\"Section 2, warehouse 3,Section 2, warehouse 3\",\"preservation_code\":\"Khulla Rakh\",\"category\":\"\",\"hsn_code\":\"0001.01.01\",\"minimum_balance\":\"200\",\"reorder_level\":\"100\",\"updated_by\":\"1\"}', 'Edit', '2024-09-20 11:54:26', 1),
(848, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Delete Operation', 'mm_materials', 0, '[]', 'null', 'Delete', '2024-09-20 11:54:34', 1),
(849, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Edit Operation', 'mm_materials', 7, '\"{\\\"plant_code\\\":\\\"PLT003\\\",\\\"material_code\\\":\\\"M006\\\",\\\"material_name\\\":\\\"Copper \\\",\\\"brief_description\\\":\\\"Copper is a chemical element; it has symbol Cu from Latin cuprum and atomic number 29. It is a soft, malleable, and ductile metal with very high thermal and electrical conductivity. A freshly exposed surface of pure copper has a pinkish-orange color.\\\",\\\"unit_code\\\":\\\"KG \\\",\\\"average_price\\\":\\\"7000\\\",\\\"title \\\":\\\"Copperrrrrrrrrrrrrrrrrrrrr\\\",\\\"bin_location\\\":\\\"Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PREC87890\\\",\\\"category\\\":\\\"essential\\\",\\\"hsn_code\\\":\\\"HSNC87890\\\",\\\"minimum_balance\\\":\\\"2000\\\",\\\"reorder_level\\\":\\\"1000\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT006,PLT006,PLT009,PLT008,PLT003\",\"material_code\":\"M006\",\"material_name\":\"Copperererferererefre\",\"brief_description\":\"Copper is a chemical element; it has symbol Cu from Latin cuprum and atomic number 29. It is a soft, malleable, and ductile metal with very high thermal and electrical conductivity. A freshly exposed surface of pure copper has a pinkish-orange color.\",\"unit_code\":\"MT,MT,Kg,Ton,KG \",\"average_price\":\"7000\",\"bin_location\":\"Section 2, warehouse 3,Section 2, warehouse 3,Thane Mumbai \",\"preservation_code\":\"PREC87890\",\"category\":\"\",\"hsn_code\":\"HSNC87890\",\"minimum_balance\":\"2000\",\"reorder_level\":\"1000\",\"updated_by\":\"1\"}', 'Edit', '2024-09-20 11:55:07', 1),
(850, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Edit Operation', 'mm_materials', 7, '\"{\\\"plant_code\\\":\\\"PLT006,PLT006,PLT009,PLT008,PLT003\\\",\\\"material_code\\\":\\\"M006\\\",\\\"material_name\\\":\\\"Copperererferererefre\\\",\\\"brief_description\\\":\\\"Copper is a chemical element; it has symbol Cu from Latin cuprum and atomic number 29. It is a soft, malleable, and ductile metal with very high thermal and electrical conductivity. A freshly exposed surface of pure copper has a pinkish-orange color.\\\",\\\"unit_code\\\":\\\"MT,MT,Kg,Ton,KG \\\",\\\"average_price\\\":\\\"7000\\\",\\\"bin_location\\\":\\\"Section 2, warehouse 3,Section 2, warehouse 3,Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PREC87890\\\",\\\"category\\\":\\\"\\\",\\\"hsn_code\\\":\\\"HSNC87890\\\",\\\"minimum_balance\\\":\\\"2000\\\",\\\"reorder_level\\\":\\\"1000\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT006,PLT006,PLT009,PLT008,PLT003\",\"material_code\":\"M006\",\"material_name\":\"Copperererferererefre\",\"brief_description\":\"ok\",\"unit_code\":\"MT,MT,Kg,Ton,KG \",\"average_price\":\"7000\",\"bin_location\":\"Section 2, warehouse 3,Section 2, warehouse 3,Thane Mumbai \",\"preservation_code\":\"PREC87890\",\"category\":\"\",\"hsn_code\":\"HSNC87890\",\"minimum_balance\":\"2000\",\"reorder_level\":\"1000\",\"updated_by\":\"1\"}', 'Edit', '2024-09-20 11:55:25', 1),
(851, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Taxes Add Operation', 'mm_taxes', 14, '[]', '{\"tax_name\":\"demo tax789\",\"tax_code\":\"Demo789\",\"short_description\":\"ok\",\"long_description\":\"ok\",\"inr\":\"10\",\"tax_type\":\"direct\",\"hsn_code\":\"0001.01.01\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:56:39', 1),
(852, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Tax Edit Operation', 'mm_taxes', 7, '\"{\\\"tax_name\\\":\\\"demo tax123\\\",\\\"tax_code\\\":\\\"Demo123\\\",\\\"short_description\\\":\\\"123\\\",\\\"long_description\\\":\\\"123\\\",\\\"inr\\\":\\\"18\\\",\\\"tax_type\\\":\\\"direct\\\",\\\"hsn_code\\\":\\\"0003.04.02\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"tax_name\":\"demo tax123\",\"tax_code\":\"Demo1233455\",\"short_description\":\"123\",\"long_description\":\"123\",\"inr\":\"18\",\"tax_type\":\"direct\",\"hsn_code\":\"0003.04.02\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:56:52', 1),
(853, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Tax Delete Operation', 'mm_taxes', 0, '[]', 'null', 'Delete', '2024-09-20 11:56:55', 1),
(854, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Category Add Operation', 'mm_material_category', 30, '[]', '{\"category_name\":\"Metals\",\"description\":\"Loha\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 11:57:24', 1),
(855, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 29, '\"{\\\"category_name\\\":\\\"Demo Testing 123\\\",\\\"description\\\":\\\"Demo Testing 123\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\"Demo Testing 1233333333\",\"description\":\"Demo Testing 123\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 11:57:30', 1),
(856, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Category Delete Operation', 'mm_division', 0, '[]', 'null', 'Delete', '2024-09-20 11:57:32', 1),
(857, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division_budget Add Operation', 'mm_division_budget', 1, '[]', '{\"division_id\":\"undefined\",\"budget\":\"1000\",\"plant_id\":\"12\",\"plant_budget\":\"\",\"available_budget\":\"\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 12:00:37', 1),
(858, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Budget Edit Operation', 'mm_division_budget_id', 1, '\"{\\\"division_id\\\":\\\"undefined\\\",\\\"budget\\\":\\\"1000\\\",\\\"plant_id\\\":\\\"12\\\",\\\"plant_budget\\\":\\\"\\\",\\\"available_budget\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"division_id\":\"undefined\",\"budget\":\"10000\",\"plant_id\":\"12\",\"plant_budget\":\"\",\"available_budget\":\"\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 12:00:43', 1),
(859, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Budget Delete Operation', 'mm_division_budget', 0, '[]', 'null', 'Delete', '2024-09-20 12:00:45', 1),
(860, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Budget Edit Operation', 'mm_division_budget_id', 1, '\"{\\\"division_id\\\":\\\"undefined\\\",\\\"budget\\\":\\\"1000\\\",\\\"plant_id\\\":\\\"12\\\",\\\"plant_budget\\\":\\\"\\\",\\\"available_budget\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"division_id\":\"undefined\",\"budget\":\"5000\",\"plant_id\":\"12\",\"plant_budget\":\"\",\"available_budget\":\"\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 12:01:00', 1),
(861, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 22, '[]', '{\"plant_id\":\"PLT012\",\"division_id\":\"Div789\",\"sub_division_id\":\"undefined\",\"division_budget\":\"0\",\"budget\":\"1000\",\"available_budget\":\"-4999.7\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 12:01:42', 1),
(862, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Sub Division Budget Edit Operation', 'mm_sub_division_budget_id ', 21, '\"{\\\"plant_id\\\":\\\"2\\\",\\\"division_id\\\":\\\"3\\\",\\\"sub_division_id\\\":\\\"5\\\",\\\"division_budget\\\":\\\"50000\\\",\\\"budget\\\":\\\"10000\\\",\\\"available_budget\\\":\\\"20000\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"plant_id\":\"PLT011\",\"division_id\":\"DIV011\",\"sub_division_id\":\"undefined\",\"division_budget\":\"0\",\"budget\":\"15000\",\"available_budget\":\"-5999.7\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-20 12:02:29', 1),
(863, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Sub Division Budget Delete Operation', 'mm_subdivision_budget', 0, '[]', 'null', 'Delete', '2024-09-20 12:02:33', 1),
(864, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Add Operation', 'mm_plants', 26, '[]', '{\"plant_code\":\"PLT012\",\"division_code\":\"demo321\",\"division_name\":\"demo321\",\"description\":\"demo321\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 13:37:28', 1),
(865, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-20 13:43:23', 1),
(866, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Add Operation', 'mm_plants', 13, '[]', '{\"plant_code\":\"PLT013\",\"plant_name\":\"Thane\",\"location_one\":\"demo add 1\",\"location_two\":\"demo add 2\",\"location_three\":\"demo add 3\",\"description\":\"test321\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-09-20 13:47:30', 1),
(867, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":13,\"c_name\":\"test 321\",\"c_number\":\"9638525622\",\"c_email\":\"AAAA@gmail.com\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2024-09-20 13:47:30', 1),
(868, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Add Operation', 'mm_plants', 27, '[]', '{\"plant_code\":\"PLT013\",\"division_code\":\"thane division\",\"division_name\":\"divisiobn thane\",\"description\":\"demo321\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-20 13:48:33', 1),
(869, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Delete Operation', 'mm_materials', 0, '[]', 'null', 'Delete', '2024-09-21 16:07:08', 1),
(870, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Edit Operation', 'mm_materials', 7, '\"{\\\"plant_code\\\":\\\"PLT006,PLT006,PLT009,PLT008,PLT003\\\",\\\"material_code\\\":\\\"M006\\\",\\\"material_name\\\":\\\"Copperererferererefre\\\",\\\"brief_description\\\":\\\"ok\\\",\\\"unit_code\\\":\\\"MT,MT,Kg,Ton,KG \\\",\\\"average_price\\\":\\\"7000\\\",\\\"bin_location\\\":\\\"Section 2, warehouse 3,Section 2, warehouse 3,Thane Mumbai \\\",\\\"preservation_code\\\":\\\"PREC87890\\\",\\\"category\\\":\\\"\\\",\\\"hsn_code\\\":\\\"HSNC87890\\\",\\\"minimum_balance\\\":\\\"2000\\\",\\\"reorder_level\\\":\\\"1000\\\",\\\"updated_by\\\":\\\"1\\\"}\"', '{\"plant_code\":\"PLT006,PLT006,PLT009,PLT008,PLT003\",\"material_code\":\"M006\",\"material_name\":\"Copper\",\"brief_description\":\"ok\",\"unit_code\":\"MT,Kg,Ton\",\"average_price\":\"7000\",\"bin_location\":\"Section 2, warehouse 3,Section 2, warehouse 3,Thane Mumbai \",\"preservation_code\":\"PREC87890\",\"category\":\"\",\"hsn_code\":\"HSNC87890\",\"minimum_balance\":\"2000\",\"reorder_level\":\"1000\",\"updated_by\":\"1\"}', 'Edit', '2024-09-21 16:07:42', 1),
(871, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Arun', 'Plant Add Operation', 'mm_plants', 14, '[]', '{\"plant_code\":\"PLT014\",\"plant_name\":\"Navi mumbai\",\"location_one\":\"mumbai\",\"location_two\":\"Navi mumbai, \",\"location_three\":\"mumbai, 600704\",\"description\":\"PLT014, Navi mumbai\",\"cmp_id\":\"4\",\"created_by\":\"3\"}', 'Add', '2024-09-23 13:28:49', 3),
(872, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Arun', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":14,\"c_name\":\"Yash Desai\",\"c_number\":\"12345667899\",\"c_email\":\"YD1234@gmail.com\",\"cmp_id\":\"4\",\"created_by\":\"3\"}', 'Add', '2024-09-23 13:28:49', 3),
(873, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Add Operation', 'mm_plants', 15, '[]', '{\"plant_code\":\"PLT015\",\"plant_name\":\"wwwwwwwwwwwww\",\"location_one\":\"sssssssssssssss\",\"location_two\":\"aaaaaaaaaaaaaaaa\",\"location_three\":\"a112121\",\"description\":\"demo 1\",\"cmp_id\":\"4\",\"created_by\":\"1\"}', 'Add', '2024-09-23 14:40:00', 1),
(874, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":15,\"c_name\":\"121212\",\"c_number\":\"1121212\",\"c_email\":\"Yash@salasarauction.com\",\"cmp_id\":\"4\",\"created_by\":\"1\"}', 'Add', '2024-09-23 14:40:00', 1),
(875, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Priyanka Kulkarni ', 'Plant Add Operation', 'mm_plants', 16, '[]', '{\"plant_code\":\"PLT016\",\"plant_name\":\"aaaaaaaaaa\",\"location_one\":\"aaaaaaaaaaaaa\",\"location_two\":\"aaaaaaaaaaaaaa\",\"location_three\":\"aaaaaaaaaaaaaaa\",\"description\":\"aaaaaaaaaaaaaaaa\",\"cmp_id\":\"3\",\"created_by\":\"12\"}', 'Add', '2024-09-25 14:28:23', 12),
(876, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Priyanka Kulkarni ', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"plant_id\":16,\"c_name\":\"aaaaaaaaaaaaaa\",\"c_number\":\"aaaaaaaaaaaaaaaaaaaaa\",\"c_email\":\"aaaaaaaaaaa\",\"cmp_id\":\"3\",\"created_by\":\"12\"}', 'Add', '2024-09-25 14:28:23', 12),
(877, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Priyanka Kulkarni ', 'Plant Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-25 14:28:45', 12),
(878, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Division Add Operation', 'mm_plants', 28, '[]', '{\"plant_code\":\"16\",\"division_code\":\"DID0010\",\"division_name\":\"Testing0010\",\"description\":\"Testing0010\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 16:02:35', 1),
(879, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Sub Division Add Operation', ' mm_sub_division', 25, '[]', '{\"plant_code\":\"PLT016\",\"division_code\":\"DID0010\",\"sub_division_code\":\"SD0010\",\"sub_division_name\":\"SDTesting0010\",\"description\":\"SDTesting0010\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 16:07:14', 1),
(880, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Department Add Operation', 'mm_department', 30, '[]', '{\"plant_id\":\"PLT016\",\"division_code\":\"DID0010\",\"sub_division_code\":\"SD0010\",\"department_code\":\"Dpart0010\",\"department_name\":\"DpartTesting \",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 16:08:01', 1),
(881, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Company Add Operation', 'mm_company', 19, '[]', '{\"company_name\":\"TESTING COMPANY\",\"owner_name\":\"Demo Person\",\"city\":\"Mumbai \",\"address_one\":\"Thane\",\"address_two\":\"Thane \",\"state\":\"Maharashtra\",\"pin_code\":\"400604\",\"pan_no\":\"ABCDE01234FGH\",\"gst_no\":\"09AAACH7409R1ZZ\",\"cin\":\"abcd012345e\",\"email\":\"ABCD@salasarauction.com\",\"contact\":\"1234567890\",\"website\":\"https: mm.aonesalasar.com\\/\",\"type_of_business\":\"Manufacturer\",\"description_of_company\":\"aaaaaaaa bbbbbbbbbbbbb ccccccccccc dddddddd\",\"no_of_units\":\"1\",\"spoc_name\":\"Demo Person \",\"spoc_mob\":\"1234567890\",\"spoc_email\":\"ABCD123@gmail.com\",\"spoc_designation\":\"Test \",\"created_by\":\"\"}', 'Add', '2024-09-25 16:25:45', 1),
(882, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Add Operation', 'mm_materials', 12, '[]', '{\"plant_code\":\"PLT016\",\"material_code\":\"MAT012\",\"material_name\":\"Steel \",\"brief_description\":\"Steel is the world s most important engineering and construction material.\",\"unit_code\":\"Ton,KG\",\"average_price\":\"3000\",\"bin_location\":\"Thane \",\"preservation_code\":\"Pcode120001\",\"category\":\"30\",\"hsn_code\":\"MAT120001\",\"minimum_balance\":\"5000\",\"reorder_level\":\"1000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 16:35:37', 1),
(883, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Taxes Add Operation', 'mm_taxes', 15, '[]', '{\"tax_name\":\"Service Tax\",\"tax_code\":\"Txax\",\"short_description\":\"Service Tax 15\",\"long_description\":\"Service tax is charged at a rate of 15, and is applicable to services provided by companies.Service tax is a part of Central Excise in India. It is a tax levied on services provided in India, except the State of Jammu and Kashmir.\",\"inr\":\"15\",\"tax_type\":\"direct\",\"hsn_code\":\"0001.01.05\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:39:13', 1),
(884, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 31, '[]', '{\"category_name\":\" Metals\",\"description\":\"Ferrous metals include wrought iron, cast iron, steel, and carbon steel etc.,\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:41:38', 1),
(885, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 32, '[]', '{\"category_name\":\"Composite material\",\"description\":\"Composites are the mixture of multiple materials, which in combination offer superior properties to the materials alone.\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:42:22', 1),
(886, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 33, '[]', '{\"category_name\":\"Glass\",\"description\":\"Glass. Glassy materials are hard, brittle, and noncrystalline. The lack of crystalline grains often results in optical transparency.\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:43:08', 1),
(887, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 34, '[]', '{\"category_name\":\"Wood\",\"description\":\"Wood is a composite material made from lignin and cellulose. Wood makes use of a lignin matrix and cellulose fibers to form a polymer composite.\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:43:36', 1),
(888, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 35, '[]', '{\"category_name\":\"Plastic\",\"description\":\"Thermoplastics are heated and then moulded into shape.\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:44:15', 1),
(889, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Add Operation', 'mm_material_category', 36, '[]', '{\"category_name\":\"Alloys\",\"description\":\"a mixture of chemical elements of which at least one is often a metal. \",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-25 17:45:03', 1),
(890, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 36, '\"{\\\"category_name\\\":\\\"Alloys\\\",\\\"description\\\":\\\"a mixture of chemical elements of which at least one is often a metal. \\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\"Alloys\",\"description\":\"a mixture of chemical elements\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:45:37', 1),
(891, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 34, '\"{\\\"category_name\\\":\\\"Wood\\\",\\\"description\\\":\\\"Wood is a composite material made from lignin and cellulose. Wood makes use of a lignin matrix and cellulose fibers to form a polymer composite.\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\"Wood\",\"description\":\"Wood is a composite material \",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:45:53', 1),
(892, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 33, '\"{\\\"category_name\\\":\\\"Glass\\\",\\\"description\\\":\\\"Glass. Glassy materials are hard, brittle, and noncrystalline. The lack of crystalline grains often results in optical transparency.\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\"Glass\",\"description\":\"materials are hard, brittle, and noncrystalline\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:46:13', 1),
(893, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 32, '\"{\\\"category_name\\\":\\\"Composite material\\\",\\\"description\\\":\\\"Composites are the mixture of multiple materials, which in combination offer superior properties to the materials alone.\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\"Composite material\",\"description\":\"the mixture of multiple materials\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:46:46', 1);
INSERT INTO `p2p_system_log` (`logid`, `employee_id`, `designation`, `department`, `module_id`, `description`, `ip`, `updated_by`, `log_title`, `table_affected`, `reference_id`, `from_data`, `to_data`, `operation`, `date_updated`, `transaction_done_by`) VALUES
(894, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Material Category Edit Operation', 'mm_material_category', 31, '\"{\\\"category_name\\\":\\\" Metals\\\",\\\"description\\\":\\\"Ferrous metals include wrought iron, cast iron, steel, and carbon steel etc.,\\\",\\\"status\\\":\\\"active\\\",\\\"created_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"category_name\":\" Metals\",\"description\":\"iron, cast iron, steel, and carbon steel etc\",\"status\":\"active\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:47:12', 1),
(895, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Plant Edit Operation', 'mm_company', 16, '\"{\\\"plant_code\\\":\\\"PLT016\\\",\\\"plant_name\\\":\\\"aaaaaaaaaa\\\",\\\"location_one\\\":\\\"aaaaaaaaaaaaa\\\",\\\"location_two\\\":\\\"aaaaaaaaaaaaaa\\\",\\\"location_three\\\":\\\"aaaaaaaaaaaaaaa\\\",\\\"description\\\":\\\"aaaaaaaaaaaaaaaa\\\",\\\"cmp_id\\\":\\\"3\\\",\\\"created_by\\\":\\\"12\\\"}\"', '{\"plant_code\":\"PLT016\",\"plant_name\":\"PLANT 001\",\"location_one\":\"THANE\",\"location_two\":\"THANE WEST\",\"location_three\":\"Mumbai\",\"description\":\"TESTING\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:50:35', 1),
(896, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Contact Person Edit Operation', 'mm_company', 16, '\"{\\\"c_name\\\":\\\"Priyanka \\\",\\\"c_number\\\":\\\"09874652130\\\",\\\"c_email\\\":\\\"salasar_123@gmail.com\\\",\\\"company_id\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"c_name\":\"DEMO PERSON\",\"c_number\":\"1234567890\",\"c_email\":\"demoperson@gmail.com\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 17:50:35', 1),
(897, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 0, '[]', '{\"c_name\":\"DEMO PERSON \",\"c_number\":\"1234567890\",\"c_email\":\"demoperson@gmail.com\",\"cmp_id\":\"\",\"plant_id\":\"16\",\"created_by\":\"1\"}', 'Add', '2024-09-25 17:52:18', 1),
(898, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Contact Person Delete Operation', 'mm_plants', 0, '[]', 'null', 'Delete', '2024-09-25 17:52:21', 1),
(899, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Plant Edit Operation', 'mm_company', 16, '\"{\\\"plant_code\\\":\\\"PLT016\\\",\\\"plant_name\\\":\\\"aaaaaaaaaa\\\",\\\"location_one\\\":\\\"aaaaaaaaaaaaa\\\",\\\"location_two\\\":\\\"aaaaaaaaaaaaaa\\\",\\\"location_three\\\":\\\"aaaaaaaaaaaaaaa\\\",\\\"description\\\":\\\"aaaaaaaaaaaaaaaa\\\",\\\"cmp_id\\\":\\\"3\\\",\\\"created_by\\\":\\\"12\\\"}\"', '{\"plant_code\":\"PLT016\",\"plant_name\":\"PLANT 001\",\"location_one\":\"THANE\",\"location_two\":\"THANE WEST\",\"location_three\":\"Mumbai\",\"description\":\"TESTING\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 18:02:38', 1),
(900, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Contact Person Edit Operation', 'mm_company', 16, '\"{\\\"c_name\\\":\\\"Priyanka \\\",\\\"c_number\\\":\\\"09874652130\\\",\\\"c_email\\\":\\\"salasar_123@gmail.com\\\",\\\"company_id\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"c_name\":\"DEMO PERSON \",\"c_number\":\"1234567890\",\"c_email\":\"demoperson@gmail.com\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 18:02:38', 1),
(901, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 106, '[]', '{\"c_name\":\"DEMO PERSON 2\",\"c_number\":\"7777888899\",\"c_email\":\"demoperson2@gmail.com\",\"cmp_id\":\"\",\"plant_id\":\"16\",\"created_by\":\"1\"}', 'Add', '2024-09-25 18:03:29', 1),
(902, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Division Edit Operation', 'mm_division', 28, '[]', '{\"plant_code\":\"16\",\"division_code\":\"DID0010\",\"division_name\":\"Testing0010\",\"description\":\"Testing0010\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 18:03:48', 1),
(903, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Division Edit Operation', 'mm_division', 28, '\"{\\\"plant_code\\\":\\\"16\\\",\\\"division_code\\\":\\\"DID0010\\\",\\\"division_name\\\":\\\"Testing0010\\\",\\\"description\\\":\\\"Testing0010\\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"plant_code\":\"16\",\"division_code\":\"DID0010\",\"division_name\":\"Testing0010\",\"description\":\"Testing0010\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-25 18:03:58', 1),
(904, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Division_budget Add Operation', 'mm_division_budget', 2, '[]', '{\"division_id\":\"undefined\",\"budget\":\"50000\",\"plant_id\":\"16\",\"plant_budget\":\"200000\",\"available_budget\":\"200000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-26 09:58:24', 1),
(905, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Division_budget Add Operation', 'mm_division_budget', 3, '[]', '{\"division_id\":\"undefined\",\"budget\":\"50000\",\"plant_id\":\"16\",\"plant_budget\":\"200000\",\"available_budget\":\"200000\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-26 09:58:25', 1),
(906, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 23, '[]', '{\"plant_id\":\"PLT016\",\"division_id\":\"DID0010\",\"sub_division_id\":\"undefined\",\"division_budget\":\"0\",\"budget\":\"6000\",\"available_budget\":\"-5999.7\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-27 12:07:44', 1),
(907, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Sub Division_budget Add Operation', 'mm_subdivision_budget', 24, '[]', '{\"plant_id\":\"PLT016\",\"division_id\":\"DID0010\",\"sub_division_id\":\"undefined\",\"division_budget\":\"0\",\"budget\":\"10000\",\"available_budget\":\"-11999.7\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-27 12:08:18', 1),
(908, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Edit Operation', 'mm_designation', 29, '\"{\\\"designation\\\":\\\"TESTER\\\",\\\"department\\\":\\\"14\\\",\\\"description\\\":\\\"demo \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"designation\":\"TESTER\",\"department\":\"2\",\"description\":\"bhagyashri \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:03:30', 1),
(909, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Edit Operation', 'mm_designation', 29, '\"{\\\"designation\\\":\\\"TESTER\\\",\\\"department\\\":\\\"2\\\",\\\"description\\\":\\\"bhagyashri \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"designation\":\"TESTER\",\"department\":\"2\",\"description\":\"bhagyashri \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:03:30', 1),
(910, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Edit Operation', 'mm_designation', 29, '\"{\\\"designation\\\":\\\"TESTER\\\",\\\"department\\\":\\\"2\\\",\\\"description\\\":\\\"bhagyashri \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"designation\":\"TESTER 2\",\"department\":\"25\",\"description\":\"demo \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:03:48', 1),
(911, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Edit Operation', 'mm_designation', 29, '\"{\\\"designation\\\":\\\"TESTER 2\\\",\\\"department\\\":\\\"25\\\",\\\"description\\\":\\\"demo \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"designation\":\"TESTER 2\",\"department\":\"25\",\"description\":\"demo \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:03:48', 1),
(912, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Edit Operation', 'mm_designation', 29, '\"{\\\"designation\\\":\\\"TESTER 2\\\",\\\"department\\\":\\\"25\\\",\\\"description\\\":\\\"demo \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"designation\":\"TESTER 2\",\"department\":\"25\",\"description\":\"demo \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:03:48', 1),
(913, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Designation Add Operation', 'mm_designation', 0, '[]', '{\"designation\":\"TESTER\",\"department\":\"22\",\"description\":\"bhagyashri \",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-27 13:10:58', 1),
(914, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Permission Edit Operation', 'mm_permissions', 17, '\"{\\\"module\\\":\\\"20\\\",\\\"sub_module\\\":\\\"17\\\",\\\"permissions\\\":\\\"All permissions\\\",\\\"department\\\":\\\"15\\\",\\\"designation\\\":\\\"29\\\",\\\"description\\\":\\\"testing \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"module\":\"20\",\"sub_module\":\"17\",\"permissions\":\"All permissions\",\"department\":\"22\",\"designation\":\"0\",\"description\":\"testing \",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:18:15', 1),
(915, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Permission Edit Operation', 'mm_permissions', 17, '\"{\\\"module\\\":\\\"20\\\",\\\"sub_module\\\":\\\"17\\\",\\\"permissions\\\":\\\"All permissions\\\",\\\"department\\\":\\\"22\\\",\\\"designation\\\":\\\"0\\\",\\\"description\\\":\\\"testing \\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"module\":\"18\",\"sub_module\":\"2\",\"permissions\":\"add edit delete\",\"department\":\"22\",\"designation\":\"0\",\"description\":\"demo test\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:23:54', 1),
(916, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Permission Edit Operation', 'mm_permissions', 17, '\"{\\\"module\\\":\\\"18\\\",\\\"sub_module\\\":\\\"2\\\",\\\"permissions\\\":\\\"add edit delete\\\",\\\"department\\\":\\\"22\\\",\\\"designation\\\":\\\"0\\\",\\\"description\\\":\\\"demo test\\\",\\\"updated_by\\\":\\\"1\\\",\\\"cmp_id\\\":\\\"1\\\"}\"', '{\"module\":\"18\",\"sub_module\":\"2\",\"permissions\":\"add edit delete\",\"department\":\"22\",\"designation\":\"36\",\"description\":\"demo test\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-09-27 13:28:09', 1),
(917, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Permission Module Add Operation', 'mm_permission_module', 0, '[]', '{\"module\":\"test 27-09-24\",\"description\":\"test 27-09-24\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-27 13:38:16', 1),
(918, NULL, NULL, NULL, NULL, '', '202.88.210.37', 'Admin', 'Permission Sub Module Add Operation', ' mm_permission_submodule', 0, '[]', '{\"permission_module_id\":\"0\",\"sub_module\":\"testing 27-09-24\",\"description\":\"testing 27-09-24\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-09-27 13:39:55', 1),
(919, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Material Category Add Operation', 'mm_material_category', 37, '[]', '{\"category_name\":\"Metal12\",\"description\":\"dd\",\"status\":\"active\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2024-10-10 17:28:19', 1),
(920, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Company Add Operation', 'mm_company', 20, '[]', '{\"company_name\":\"ABC LTD\",\"owner_name\":\"Ashok\",\"city\":\"Anand\",\"address_one\":\"Plot No 8, 1-2, Vithal Udyognagar, GIDC Main road , Anand, Gujarat 388121\",\"address_two\":\"Anand Nagar\",\"state\":\"Gujarat\",\"pin_code\":\"388121\",\"pan_no\":\"ADZPY125456k\",\"gst_no\":\"27AAAJS1679K1ZL\",\"cin\":\"12541521236411452165\",\"email\":\"purchase@abc.com\",\"contact\":\"9799802888\",\"website\":\"\",\"type_of_business\":\"\",\"description_of_company\":\"\",\"no_of_units\":\"\",\"spoc_name\":\" Askok\",\"spoc_mob\":\"7581251245\",\"spoc_email\":\"\",\"spoc_designation\":\"\",\"created_by\":\"\"}', 'Add', '2024-10-24 09:59:05', 1),
(921, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Edit Operation', 'mm_company', 16, '\"{\\\"plant_code\\\":\\\"PLT016\\\",\\\"plant_name\\\":\\\"aaaaaaaaaa\\\",\\\"location_one\\\":\\\"aaaaaaaaaaaaa\\\",\\\"location_two\\\":\\\"aaaaaaaaaaaaaa\\\",\\\"location_three\\\":\\\"aaaaaaaaaaaaaaa\\\",\\\"description\\\":\\\"aaaaaaaaaaaaaaaa\\\",\\\"cmp_id\\\":\\\"3\\\",\\\"created_by\\\":\\\"12\\\"}\"', '{\"plant_code\":\"PLT016\",\"plant_name\":\"PLANT 001\",\"location_one\":\"THANE\",\"location_two\":\"THANE WEST\",\"location_three\":\"Mumbai\",\"description\":\"TESTING\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-10-25 17:33:53', 1),
(922, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Edit Operation', 'mm_company', 16, '\"{\\\"c_name\\\":\\\"Priyanka \\\",\\\"c_number\\\":\\\"09874652130\\\",\\\"c_email\\\":\\\"salasar_123@gmail.com\\\",\\\"company_id\\\":\\\"\\\",\\\"created_by\\\":\\\"1\\\"}\"', '{\"c_name\":\"DEMO PERSON \",\"c_number\":\"1234567890\",\"c_email\":\"demoperson@gmail.com\",\"updated_by\":\"1\",\"cmp_id\":\"1\"}', 'Edit', '2024-10-25 17:33:53', 1),
(923, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Company Add Operation', 'mm_company', 21, '[]', '{\"company_name\":\"ABCC pvt ltd\",\"owner_name\":\"Dinesh\",\"city\":\"Goregaon East\",\"address_one\":\"Near aarey check Naka\",\"address_two\":\"Anand Nagar\",\"state\":\"Maharashtra\",\"pin_code\":\"400065\",\"pan_no\":\"ADZPY125456k\",\"gst_no\":\"27AAAJS1679K1ZL\",\"cin\":\"12541521236411452165\",\"email\":\"Redevelopment@doodhsagar.in\",\"contact\":\"9799802882\",\"website\":\"https: www.bajajfinserv.in\\/private-limited-company-explained\",\"type_of_business\":\"Steel Plant\",\"description_of_company\":\"Manufacturer of steel.\",\"no_of_units\":\"3\",\"spoc_name\":\"Dinesh\",\"spoc_mob\":\"7208415241\",\"spoc_email\":\"Dinesh21@gmail.com\",\"spoc_designation\":\"VP\",\"created_by\":\"\"}', 'Add', '2024-12-18 09:59:18', 1),
(924, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Company Add Operation', 'mm_company', 22, '[]', '{\"company_name\":\"Megha\",\"owner_name\":\"Megha\",\"city\":\"Mumbai\",\"address_one\":\"Mumbai\",\"address_two\":\"fgghj\",\"state\":\"Maharashtra\",\"pin_code\":\"400078\",\"pan_no\":\"DJSHDSJDJS\",\"gst_no\":\"adsdffffsffdfsfd\",\"cin\":\"fdsfds\",\"email\":\"megha.saboo@salasarauction.com\",\"contact\":\"7400050342\",\"website\":\"\",\"type_of_business\":\"\",\"description_of_company\":\"\",\"no_of_units\":\"\",\"spoc_name\":\"Megha\",\"spoc_mob\":\"7400050342\",\"spoc_email\":\"\",\"spoc_designation\":\"\",\"created_by\":\"\"}', 'Add', '2025-02-19 16:09:04', 1),
(925, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Plant Add Operation', 'mm_plants', 17, '[]', '{\"plant_code\":\"PLT017\",\"plant_name\":\"Mumbai\",\"location_one\":\"\",\"location_two\":\"Mumbai\",\"location_three\":\"Mumbai\",\"description\":\"sfsfsd\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2025-02-19 16:10:16', 1),
(926, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Contact Person Add Operation', 'mm_contact_person', 107, '[]', '{\"plant_id\":17,\"c_name\":\"Megha Saboo\",\"c_number\":\"07400050342\",\"c_email\":\"megha.saboo@salasarauction.com\",\"cmp_id\":\"1\",\"created_by\":\"1\"}', 'Add', '2025-02-19 16:10:16', 1),
(927, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Add Operation', 'mm_plants', 29, '[]', '{\"plant_code\":\"17\",\"division_code\":\"1\",\"division_name\":\"Procurement\",\"description\":\"Procurement\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2025-02-19 16:11:51', 1),
(928, NULL, NULL, NULL, NULL, '', '122.179.137.173', 'Admin', 'Division Add Operation', 'mm_plants', 30, '[]', '{\"plant_code\":\"17\",\"division_code\":\"1\",\"division_name\":\"Procurement\",\"description\":\"Procurement\",\"created_by\":\"1\",\"cmp_id\":\"1\"}', 'Add', '2025-02-19 16:12:40', 1);

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

--
-- Table structure for table `rev_auc_t_c`
--

CREATE TABLE `rev_auc_t_c` (
  `rev_t_c_id` int(11) NOT NULL,
  `rev_auction_id` varchar(255) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `t_c` enum('0','1') NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL DEFAULT '0',
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_delete` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `userloginlog`
--

CREATE TABLE `userloginlog` (
  `log_id` int(11) NOT NULL,
  `sup_id` int(11) NOT NULL,
  `login_dt` date NOT NULL,
  `logout_dt` date NOT NULL,
  `login_time` time NOT NULL,
  `logout_time` time NOT NULL,
  `ip` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `userloginlog`
--

INSERT INTO `userloginlog` (`log_id`, `sup_id`, `login_dt`, `logout_dt`, `login_time`, `logout_time`, `ip`) VALUES
(1, 1, '2024-06-07', '2024-06-07', '07:46:56', '08:16:14', '127.0.0.1'),
(2, 1, '2024-06-11', '2024-06-11', '04:38:13', '06:26:15', '127.0.0.1'),
(3, 1, '2024-06-11', '0000-00-00', '11:51:43', '00:00:00', '127.0.0.1'),
(4, 1, '2024-06-12', '2024-06-12', '03:55:03', '04:13:58', '127.0.0.1'),
(5, 1, '2024-06-12', '2024-06-12', '04:11:30', '04:13:58', '127.0.0.1'),
(6, 1, '2024-06-12', '0000-00-00', '04:14:08', '00:00:00', '127.0.0.1'),
(7, 1, '2024-06-14', '2024-06-14', '05:26:43', '09:00:58', '127.0.0.1'),
(8, 1, '2024-06-14', '0000-00-00', '11:10:39', '00:00:00', '127.0.0.1'),
(9, 1, '2024-06-15', '0000-00-00', '03:55:02', '00:00:00', '127.0.0.1'),
(10, 1, '2024-06-15', '0000-00-00', '08:34:50', '00:00:00', '127.0.0.1'),
(11, 1, '2024-06-15', '0000-00-00', '10:44:55', '00:00:00', '127.0.0.1'),
(12, 1, '2024-06-15', '0000-00-00', '11:56:51', '00:00:00', '127.0.0.1'),
(13, 1, '2024-06-17', '2024-06-17', '03:53:08', '11:57:32', '127.0.0.1'),
(14, 1, '2024-06-17', '2024-06-17', '09:29:05', '11:57:32', '127.0.0.1'),
(15, 1, '2024-06-17', '0000-00-00', '11:57:39', '00:00:00', '127.0.0.1'),
(16, 1, '2024-06-18', '0000-00-00', '03:53:40', '00:00:00', '127.0.0.1'),
(17, 1, '2024-06-19', '0000-00-00', '04:04:58', '00:00:00', '127.0.0.1'),
(18, 1, '2024-06-19', '0000-00-00', '07:43:21', '00:00:00', '127.0.0.1'),
(19, 1, '2024-06-19', '0000-00-00', '10:42:49', '00:00:00', '127.0.0.1'),
(20, 1, '2024-06-20', '0000-00-00', '03:56:50', '00:00:00', '127.0.0.1'),
(21, 1, '2024-06-20', '0000-00-00', '10:59:39', '00:00:00', '127.0.0.1'),
(22, 1, '2024-06-21', '0000-00-00', '04:03:18', '00:00:00', '127.0.0.1'),
(23, 1, '2024-06-21', '0000-00-00', '07:57:46', '00:00:00', '127.0.0.1'),
(24, 1, '2024-06-28', '0000-00-00', '07:42:10', '00:00:00', '127.0.0.1'),
(25, 1, '2024-06-29', '0000-00-00', '03:58:39', '00:00:00', '127.0.0.1'),
(26, 1, '2024-07-01', '0000-00-00', '07:12:39', '00:00:00', '127.0.0.1'),
(27, 1, '2024-07-08', '0000-00-00', '10:37:15', '00:00:00', '127.0.0.1'),
(28, 1, '2024-07-25', '0000-00-00', '08:16:15', '00:00:00', '127.0.0.1'),
(29, 1, '2024-07-26', '0000-00-00', '06:46:53', '00:00:00', '127.0.0.1'),
(30, 2, '2024-08-06', '0000-00-00', '05:16:11', '00:02:00', '127.0.0.1'),
(31, 1, '2024-08-06', '0000-00-00', '11:46:00', '00:00:00', '127.0.0.1'),
(32, 1, '2024-08-07', '0000-00-00', '04:11:40', '00:00:00', '127.0.0.1'),
(33, 2, '2024-08-07', '0000-00-00', '05:20:20', '00:00:00', '127.0.0.1'),
(34, 1, '2024-08-08', '0000-00-00', '04:01:20', '00:00:00', '127.0.0.1'),
(35, 1, '2024-08-08', '0000-00-00', '06:53:28', '00:00:00', '127.0.0.1'),
(36, 1, '2024-08-08', '0000-00-00', '12:37:17', '00:00:00', '122.179.137.173'),
(37, 3, '2024-08-08', '0000-00-00', '12:39:59', '00:00:00', '122.179.137.173'),
(38, 1, '2024-08-08', '0000-00-00', '15:54:09', '00:00:00', '122.179.137.173'),
(39, 1, '2024-08-09', '2024-08-09', '10:23:21', '18:14:55', '122.179.137.173'),
(40, 3, '2024-08-09', '2024-08-09', '13:05:15', '17:19:48', '122.179.137.173'),
(41, 1, '2024-08-09', '2024-08-09', '13:32:31', '18:14:55', '122.179.137.173'),
(42, 3, '2024-08-09', '2024-08-09', '13:43:20', '17:19:48', '122.179.137.173'),
(43, 3, '2024-08-09', '2024-08-09', '14:13:09', '17:19:48', '122.179.137.173'),
(44, 3, '2024-08-09', '2024-08-09', '14:22:10', '17:19:48', '122.179.137.173'),
(45, 9, '2024-08-09', '2024-08-09', '14:25:12', '14:33:45', '122.179.137.173'),
(46, 3, '2024-08-09', '2024-08-09', '14:31:03', '17:19:48', '122.179.137.173'),
(47, 9, '2024-08-09', '2024-08-09', '14:32:48', '14:33:45', '122.179.137.173'),
(48, 1, '2024-08-09', '2024-08-09', '14:34:00', '18:14:55', '122.179.137.173'),
(49, 1, '2024-08-09', '2024-08-09', '14:44:44', '18:14:55', '122.179.137.173'),
(50, 1, '2024-08-09', '2024-08-09', '14:51:13', '18:14:55', '122.179.137.173'),
(51, 3, '2024-08-09', '2024-08-09', '14:56:10', '17:19:48', '122.179.137.173'),
(52, 3, '2024-08-09', '2024-08-09', '14:57:16', '17:19:48', '122.179.137.173'),
(53, 2, '2024-08-09', '2024-08-09', '15:50:52', '18:14:34', '122.179.137.173'),
(54, 3, '2024-08-09', '2024-08-09', '15:51:37', '17:19:48', '122.179.137.173'),
(55, 3, '2024-08-09', '2024-08-09', '15:51:41', '17:19:48', '122.179.137.173'),
(56, 3, '2024-08-09', '2024-08-09', '15:56:31', '17:19:48', '122.179.137.173'),
(57, 3, '2024-08-09', '2024-08-09', '16:04:08', '17:19:48', '122.179.137.173'),
(58, 2, '2024-08-09', '2024-08-09', '16:24:51', '18:14:34', '122.179.137.173'),
(59, 2, '2024-08-09', '2024-08-09', '16:24:56', '18:14:34', '122.179.137.173'),
(60, 2, '2024-08-09', '2024-08-09', '16:25:01', '18:14:34', '122.179.137.173'),
(61, 2, '2024-08-09', '2024-08-09', '16:25:06', '18:14:34', '122.179.137.173'),
(62, 2, '2024-08-09', '2024-08-09', '16:25:11', '18:14:34', '122.179.137.173'),
(63, 2, '2024-08-09', '2024-08-09', '16:25:41', '18:14:34', '122.179.137.173'),
(64, 2, '2024-08-09', '2024-08-09', '16:25:49', '18:14:34', '122.179.137.173'),
(65, 2, '2024-08-09', '2024-08-09', '16:26:17', '18:14:34', '122.179.137.173'),
(66, 3, '2024-08-09', '2024-08-09', '16:32:48', '17:19:48', '122.179.137.173'),
(67, 3, '2024-08-09', '2024-08-09', '16:52:57', '17:19:48', '122.179.137.173'),
(68, 2, '2024-08-09', '2024-08-09', '16:55:14', '18:14:34', '122.179.137.173'),
(69, 2, '2024-08-09', '2024-08-09', '17:02:13', '18:14:34', '122.179.137.173'),
(70, 3, '2024-08-09', '2024-08-09', '17:14:13', '17:19:48', '122.179.137.173'),
(71, 9, '2024-08-09', '0000-00-00', '17:20:21', '00:00:00', '122.179.137.173'),
(72, 2, '2024-08-09', '2024-08-09', '17:51:36', '18:14:34', '122.179.137.173'),
(73, 26, '2024-08-09', '2024-08-09', '17:52:26', '17:56:30', '122.179.137.173'),
(74, 2, '2024-08-09', '2024-08-09', '17:56:50', '18:14:34', '122.179.137.173'),
(75, 1, '2024-08-09', '2024-08-09', '18:05:22', '18:14:55', '122.179.137.173'),
(76, 2, '2024-08-09', '2024-08-09', '18:09:33', '18:14:34', '122.179.137.173'),
(77, 1, '2024-08-09', '2024-08-09', '18:14:38', '18:14:55', '122.179.137.173'),
(78, 3, '2024-08-09', '0000-00-00', '18:15:11', '00:00:00', '122.179.137.173'),
(79, 1, '2024-08-09', '0000-00-00', '20:59:38', '00:00:00', '113.30.219.60'),
(80, 1, '2024-08-09', '0000-00-00', '21:00:18', '00:00:00', '113.30.219.60'),
(81, 2, '2024-08-12', '2024-08-12', '11:40:14', '15:40:52', '122.179.137.173'),
(82, 3, '2024-08-12', '2024-08-12', '11:43:29', '17:03:49', '122.179.137.173'),
(83, 3, '2024-08-12', '2024-08-12', '11:43:39', '17:03:49', '122.179.137.173'),
(84, 3, '2024-08-12', '2024-08-12', '11:43:40', '17:03:49', '122.179.137.173'),
(85, 3, '2024-08-12', '2024-08-12', '11:44:20', '17:03:49', '122.179.137.173'),
(86, 3, '2024-08-12', '2024-08-12', '11:44:54', '17:03:49', '122.179.137.173'),
(87, 1, '2024-08-12', '2024-08-12', '12:03:22', '17:04:51', '122.179.137.173'),
(88, 3, '2024-08-12', '2024-08-12', '12:03:39', '17:03:49', '122.179.137.173'),
(89, 3, '2024-08-12', '2024-08-12', '12:18:39', '17:03:49', '122.179.137.173'),
(90, 2, '2024-08-12', '2024-08-12', '12:19:09', '15:40:52', '122.179.137.173'),
(91, 3, '2024-08-12', '2024-08-12', '12:39:15', '17:03:49', '122.179.137.173'),
(92, 3, '2024-08-12', '2024-08-12', '12:51:49', '17:03:49', '122.179.137.173'),
(93, 9, '2024-08-12', '2024-08-12', '12:58:55', '13:01:11', '122.179.137.173'),
(94, 1, '2024-08-12', '2024-08-12', '13:01:16', '17:04:51', '122.179.137.173'),
(95, 1, '2024-08-12', '2024-08-12', '13:02:00', '17:04:51', '122.179.137.173'),
(96, 2, '2024-08-12', '2024-08-12', '13:06:57', '15:40:52', '122.179.137.173'),
(97, 3, '2024-08-12', '2024-08-12', '13:07:26', '17:03:49', '122.179.137.173'),
(98, 1, '2024-08-12', '2024-08-12', '13:07:57', '17:04:51', '122.179.137.173'),
(99, 3, '2024-08-12', '2024-08-12', '15:30:44', '17:03:49', '122.179.137.173'),
(100, 2, '2024-08-12', '2024-08-12', '15:31:12', '15:40:52', '122.179.137.173'),
(101, 22, '2024-08-12', '2024-08-12', '15:40:40', '17:00:20', '122.179.137.173'),
(102, 23, '2024-08-21', '2024-08-21', '14:17:00', '17:41:45', '122.179.137.173'),
(103, 1, '2024-08-12', '2024-08-12', '16:59:38', '17:04:51', '122.179.137.173'),
(104, 3, '2024-08-12', '2024-08-12', '17:01:16', '17:03:49', '122.179.137.173'),
(105, 3, '2024-08-12', '0000-00-00', '17:03:54', '00:00:00', '122.179.137.173'),
(106, 1, '2024-08-12', '0000-00-00', '17:04:58', '00:00:00', '122.179.137.173'),
(107, 22, '2024-08-13', '0000-00-00', '09:04:35', '00:00:00', '122.179.137.173'),
(108, 23, '2024-08-13', '0000-00-00', '09:05:51', '00:00:00', '122.179.137.173'),
(109, 1, '2024-08-13', '0000-00-00', '09:43:23', '00:00:00', '122.179.137.173'),
(110, 22, '2024-08-13', '0000-00-00', '09:49:38', '00:00:00', '122.179.137.173'),
(111, 23, '2024-08-13', '0000-00-00', '09:51:07', '00:00:00', '122.179.137.173'),
(112, 16, '2024-08-13', '0000-00-00', '11:19:04', '00:00:00', '122.179.137.173'),
(113, 23, '2024-08-13', '0000-00-00', '11:19:27', '00:00:00', '122.179.137.173'),
(114, 23, '2024-08-13', '0000-00-00', '11:25:00', '00:00:00', '122.179.137.173'),
(115, 3, '2024-08-13', '0000-00-00', '15:55:47', '00:00:00', '122.179.137.173'),
(116, 1, '2024-08-14', '0000-00-00', '12:09:42', '00:00:00', '122.179.137.173'),
(117, 1, '2024-08-14', '0000-00-00', '16:31:59', '00:00:00', '122.179.137.173'),
(118, 1, '2024-08-16', '0000-00-00', '16:48:43', '00:00:00', '122.179.137.173'),
(119, 3, '2024-08-16', '0000-00-00', '17:10:56', '00:00:00', '122.179.137.173'),
(120, 2, '2024-08-16', '0000-00-00', '17:11:29', '00:00:00', '122.179.137.173'),
(121, 1, '2024-08-16', '0000-00-00', '18:34:05', '00:00:00', '122.179.137.173'),
(122, 1, '2024-08-17', '2024-08-17', '10:25:56', '17:40:02', '122.179.137.173'),
(123, 1, '2024-08-17', '2024-08-17', '11:36:09', '17:40:02', '122.179.137.173'),
(124, 1, '2024-08-17', '2024-08-17', '12:06:18', '17:40:02', '122.179.137.173'),
(125, 1, '2024-08-17', '2024-08-17', '12:13:06', '17:40:02', '122.179.137.173'),
(126, 1, '2024-08-17', '2024-08-17', '12:43:01', '17:40:02', '122.179.137.173'),
(127, 1, '2024-08-17', '2024-08-17', '12:46:03', '17:40:02', '122.179.137.173'),
(128, 3, '2024-08-17', '2024-08-17', '12:53:39', '16:55:08', '122.179.137.173'),
(129, 9, '2024-08-17', '0000-00-00', '12:55:55', '00:00:00', '122.179.137.173'),
(130, 1, '2024-08-17', '2024-08-17', '16:28:01', '17:40:02', '122.179.137.173'),
(131, 3, '2024-08-17', '2024-08-17', '16:30:29', '16:55:08', '122.179.137.173'),
(132, 1, '2024-08-17', '2024-08-17', '16:55:13', '17:40:02', '122.179.137.173'),
(133, 1, '2024-08-17', '2024-08-17', '17:39:48', '17:40:02', '122.179.137.173'),
(134, 3, '2024-08-17', '0000-00-00', '17:40:14', '00:00:00', '122.179.137.173'),
(135, 1, '2024-08-17', '0000-00-00', '17:41:24', '00:00:00', '122.179.137.173'),
(136, 1, '2024-08-19', '2024-08-19', '10:38:49', '17:09:30', '122.179.137.173'),
(137, 1, '2024-08-19', '2024-08-19', '11:42:02', '17:09:30', '122.179.137.173'),
(138, 1, '2024-08-19', '2024-08-19', '14:09:47', '17:09:30', '122.179.137.173'),
(139, 1, '2024-08-19', '2024-08-19', '14:33:20', '17:09:30', '122.179.137.173'),
(140, 1, '2024-08-19', '2024-08-19', '14:34:28', '17:09:30', '122.179.137.173'),
(141, 1, '2024-08-19', '2024-08-19', '15:23:54', '17:09:30', '122.179.137.173'),
(142, 1, '2024-08-19', '2024-08-19', '15:35:38', '17:09:30', '122.179.137.173'),
(143, 1, '2024-08-19', '2024-08-19', '15:47:05', '17:09:30', '122.179.137.173'),
(144, 1, '2024-08-19', '2024-08-19', '15:58:32', '17:09:30', '122.179.137.173'),
(145, 1, '2024-08-19', '0000-00-00', '17:09:36', '00:00:00', '122.179.137.173'),
(146, 1, '2024-08-20', '0000-00-00', '09:42:30', '00:00:00', '122.179.137.173'),
(147, 1, '2024-08-20', '0000-00-00', '16:21:22', '00:00:00', '122.179.137.173'),
(148, 16, '2024-08-21', '2024-08-21', '09:08:45', '17:42:09', '122.179.137.173'),
(149, 22, '2024-08-21', '2024-08-21', '09:44:07', '10:09:12', '122.179.137.173'),
(150, 16, '2024-08-21', '2024-08-21', '10:09:31', '17:42:09', '122.179.137.173'),
(151, 22, '2024-08-21', '0000-00-00', '10:19:36', '00:00:00', '122.179.137.173'),
(152, 1, '2024-08-21', '2024-08-21', '10:56:18', '17:42:33', '122.179.137.173'),
(153, 1, '2024-08-21', '2024-08-21', '12:48:33', '17:42:33', '122.179.137.173'),
(154, 22, '2024-08-21', '0000-00-00', '12:56:24', '00:00:00', '122.179.137.173'),
(155, 3, '2024-08-21', '2024-08-21', '13:04:21', '14:50:57', '122.179.137.173'),
(156, 1, '2024-08-21', '2024-08-21', '14:28:07', '17:42:33', '122.179.137.173'),
(157, 1, '2024-08-21', '2024-08-21', '14:30:11', '17:42:33', '122.179.137.173'),
(158, 23, '2024-08-21', '2024-08-21', '14:37:09', '17:41:45', '122.179.137.173'),
(159, 3, '2024-08-21', '2024-08-21', '14:50:54', '14:50:57', '122.179.137.173'),
(160, 23, '2024-08-21', '2024-08-21', '14:51:13', '17:41:45', '122.179.137.173'),
(161, 16, '2024-08-21', '2024-08-21', '17:41:51', '17:42:09', '122.179.137.173'),
(162, 1, '2024-08-21', '2024-08-21', '17:42:28', '17:42:33', '122.179.137.173'),
(163, 1, '2024-08-21', '0000-00-00', '18:17:47', '00:00:00', '122.179.137.173'),
(164, 1, '2024-08-22', '0000-00-00', '10:28:06', '00:00:00', '122.179.137.173'),
(165, 1, '2024-08-27', '2024-08-27', '12:56:29', '13:01:53', '122.179.137.173'),
(166, 1, '2024-08-27', '0000-00-00', '16:06:54', '00:00:00', '122.179.137.173'),
(167, 1, '2024-08-31', '2024-08-31', '10:30:05', '16:06:17', '122.179.137.173'),
(168, 1, '2024-08-31', '2024-08-31', '10:50:19', '16:06:17', '122.179.137.173'),
(169, 1, '2024-08-31', '2024-08-31', '10:50:38', '16:06:17', '122.179.137.173'),
(170, 1, '2024-08-31', '2024-08-31', '12:42:33', '16:06:17', '122.179.137.173'),
(171, 1, '2024-08-31', '2024-08-31', '14:18:45', '16:06:17', '122.179.137.173'),
(172, 1, '2024-08-31', '2024-08-31', '15:59:46', '16:06:17', '122.179.137.173'),
(173, 16, '2024-08-31', '2024-08-31', '16:06:26', '17:34:02', '122.179.137.173'),
(174, 1, '2024-08-31', '0000-00-00', '17:34:23', '00:00:00', '122.179.137.173'),
(175, 1, '2024-09-02', '0000-00-00', '11:24:00', '00:00:00', '122.179.137.173'),
(176, 1, '2024-09-02', '0000-00-00', '11:58:41', '00:00:00', '122.179.137.173'),
(177, 26, '2024-09-02', '0000-00-00', '14:03:37', '00:00:00', '122.179.137.173'),
(178, 1, '2024-09-02', '0000-00-00', '17:31:31', '00:00:00', '122.179.137.173'),
(179, 1, '2024-09-03', '2024-09-03', '11:47:41', '11:48:07', '122.179.137.173'),
(180, 2, '2024-09-03', '0000-00-00', '11:51:11', '00:00:00', '122.179.137.173'),
(181, 1, '2024-09-03', '0000-00-00', '15:52:34', '00:00:00', '122.179.137.173'),
(182, 1, '2024-09-03', '0000-00-00', '15:53:13', '00:00:00', '122.179.137.173'),
(183, 1, '2024-09-03', '0000-00-00', '16:02:48', '00:00:00', '122.179.137.173'),
(184, 1, '2024-09-04', '0000-00-00', '11:07:31', '00:00:00', '122.179.137.173'),
(185, 1, '2024-09-04', '0000-00-00', '12:03:37', '00:00:00', '122.179.137.173'),
(186, 1, '2024-09-04', '0000-00-00', '15:32:17', '00:00:00', '49.33.206.45'),
(187, 1, '2024-09-05', '2024-09-05', '14:22:38', '17:55:11', '122.179.137.173'),
(188, 16, '2024-09-05', '2024-09-05', '14:26:57', '19:02:43', '122.179.137.173'),
(189, 1, '2024-09-05', '2024-09-05', '14:31:24', '17:55:11', '122.179.137.173'),
(190, 1, '2024-09-05', '2024-09-05', '15:48:25', '17:55:11', '122.179.137.173'),
(191, 22, '2024-09-05', '2024-09-05', '15:49:20', '16:24:00', '122.179.137.173'),
(192, 23, '2024-09-05', '2024-09-05', '16:06:36', '17:17:47', '122.179.137.173'),
(193, 2, '2024-09-05', '2024-09-05', '16:10:16', '16:23:15', '122.179.137.173'),
(194, 23, '2024-09-05', '2024-09-05', '16:23:40', '17:17:47', '122.179.137.173'),
(195, 26, '2024-09-05', '2024-09-05', '16:55:47', '17:57:02', '122.179.137.173'),
(196, 23, '2024-09-05', '2024-09-05', '17:03:25', '17:17:47', '122.179.137.173'),
(197, 1, '2024-09-05', '2024-09-05', '17:10:20', '17:55:11', '122.179.137.173'),
(198, 26, '2024-09-05', '2024-09-05', '17:18:11', '17:57:02', '122.179.137.173'),
(199, 22, '2024-09-05', '0000-00-00', '17:55:19', '00:00:00', '122.179.137.173'),
(200, 16, '2024-09-05', '2024-09-05', '17:57:08', '19:02:43', '122.179.137.173'),
(201, 23, '2024-09-05', '0000-00-00', '19:04:17', '00:00:00', '122.179.137.173'),
(202, 22, '2024-09-06', '2024-09-06', '09:24:10', '10:17:28', '122.179.137.173'),
(203, 1, '2024-09-06', '2024-09-06', '09:35:14', '17:51:26', '122.179.137.173'),
(204, 23, '2024-09-06', '2024-09-06', '09:39:04', '17:27:37', '122.179.137.173'),
(205, 1, '2024-09-06', '2024-09-06', '09:51:05', '17:51:26', '122.179.137.173'),
(206, 1, '2024-09-06', '2024-09-06', '09:53:42', '17:51:26', '122.179.137.173'),
(207, 16, '2024-09-06', '2024-09-06', '10:07:48', '16:09:59', '122.179.137.173'),
(208, 23, '2024-09-06', '2024-09-06', '10:11:37', '17:27:37', '122.179.137.173'),
(209, 26, '2024-09-06', '2024-09-06', '10:12:05', '17:51:19', '122.179.137.173'),
(210, 1, '2024-09-06', '2024-09-06', '10:12:51', '17:51:26', '122.179.137.173'),
(211, 22, '2024-09-06', '2024-09-06', '10:15:01', '10:17:28', '122.179.137.173'),
(212, 26, '2024-09-06', '2024-09-06', '10:17:41', '17:51:19', '122.179.137.173'),
(213, 1, '2024-09-06', '2024-09-06', '12:58:05', '17:51:26', '122.179.137.173'),
(214, 1, '2024-09-06', '2024-09-06', '13:09:06', '17:51:26', '122.179.137.173'),
(215, 23, '2024-09-06', '2024-09-06', '13:35:30', '17:27:37', '122.179.137.173'),
(216, 2, '2024-09-06', '0000-00-00', '13:55:12', '00:00:00', '122.179.137.173'),
(217, 1, '2024-09-06', '2024-09-06', '14:18:39', '17:51:26', '122.179.137.173'),
(218, 9, '2024-09-06', '0000-00-00', '14:56:36', '00:00:00', '122.179.137.173'),
(219, 2, '2024-09-06', '0000-00-00', '14:57:36', '00:00:00', '122.179.137.173'),
(220, 1, '2024-09-06', '2024-09-06', '14:58:00', '17:51:26', '122.179.137.173'),
(221, 22, '2024-09-06', '0000-00-00', '15:01:21', '00:00:00', '122.179.137.173'),
(222, 16, '2024-09-06', '2024-09-06', '16:06:32', '16:09:59', '122.179.137.173'),
(223, 1, '2024-09-06', '2024-09-06', '16:07:08', '17:51:26', '122.179.137.173'),
(224, 22, '2024-09-06', '0000-00-00', '16:07:55', '00:00:00', '122.179.137.173'),
(225, 23, '2024-09-06', '2024-09-06', '16:09:10', '17:27:37', '122.179.137.173'),
(226, 16, '2024-09-06', '0000-00-00', '16:44:42', '00:00:00', '122.179.137.173'),
(227, 1, '2024-09-06', '2024-09-06', '17:10:48', '17:51:26', '122.179.137.173'),
(228, 1, '2024-09-06', '2024-09-06', '17:42:20', '17:51:26', '122.179.137.173'),
(229, 23, '2024-09-06', '0000-00-00', '17:46:17', '00:00:00', '122.179.137.173'),
(230, 22, '2024-09-09', '0000-00-00', '17:21:27', '00:00:00', '122.179.137.173'),
(231, 22, '2024-09-09', '0000-00-00', '17:23:35', '00:00:00', '122.179.137.173'),
(232, 22, '2024-09-10', '2024-09-10', '10:17:26', '15:53:13', '122.179.137.173'),
(233, 22, '2024-09-10', '2024-09-10', '11:28:58', '15:53:13', '122.179.137.173'),
(234, 1, '2024-09-10', '2024-09-10', '12:04:16', '13:32:26', '122.179.137.173'),
(235, 16, '2024-09-10', '2024-09-10', '12:29:39', '13:33:04', '122.179.137.173'),
(236, 2, '2024-09-10', '2024-09-10', '12:30:11', '12:30:57', '122.179.137.173'),
(237, 23, '2024-09-10', '2024-09-10', '12:31:03', '13:34:13', '122.179.137.173'),
(238, 22, '2024-09-10', '2024-09-10', '12:31:32', '15:53:13', '122.179.137.173'),
(239, 1, '2024-09-10', '2024-09-10', '12:35:30', '13:32:26', '122.179.137.173'),
(240, 1, '2024-09-10', '2024-09-10', '13:26:57', '13:32:26', '122.179.137.173'),
(241, 3, '2024-09-10', '0000-00-00', '13:32:49', '00:00:00', '122.179.137.173'),
(242, 9, '2024-09-10', '2024-09-10', '13:33:40', '18:26:02', '122.179.137.173'),
(243, 26, '2024-09-10', '0000-00-00', '13:34:47', '00:00:00', '122.179.137.173'),
(244, 1, '2024-09-10', '0000-00-00', '15:08:15', '00:00:00', '122.179.137.173'),
(245, 22, '2024-09-10', '2024-09-10', '15:14:08', '15:53:13', '122.179.137.173'),
(246, 9, '2024-09-10', '2024-09-10', '15:20:43', '18:26:02', '122.179.137.173'),
(247, 9, '2024-09-10', '2024-09-10', '15:53:21', '18:26:02', '122.179.137.173'),
(248, 26, '2024-09-10', '0000-00-00', '16:50:21', '00:00:00', '122.179.137.173'),
(249, 26, '2024-09-10', '0000-00-00', '18:26:21', '00:00:00', '122.179.137.173'),
(250, 22, '2024-09-11', '2024-09-11', '11:11:42', '13:09:38', '122.179.137.173'),
(251, 1, '2024-09-11', '2024-09-11', '12:27:31', '13:13:49', '122.179.137.173'),
(252, 3, '2024-09-11', '2024-09-11', '12:28:50', '12:46:30', '122.179.137.173'),
(253, 22, '2024-09-11', '2024-09-11', '12:46:36', '13:09:38', '122.179.137.173'),
(254, 26, '2024-09-11', '2024-09-11', '12:55:47', '13:20:10', '122.179.137.173'),
(255, 23, '2024-09-11', '2024-09-11', '13:10:37', '13:20:15', '122.179.137.173'),
(256, 16, '2024-09-11', '2024-09-11', '13:14:12', '13:20:19', '122.179.137.173'),
(257, 1, '2024-09-12', '2024-09-12', '12:00:22', '12:00:27', '122.179.137.173'),
(258, 1, '2024-09-13', '0000-00-00', '13:07:20', '00:00:00', '122.179.137.173'),
(259, 3, '2024-09-13', '0000-00-00', '14:01:20', '00:00:00', '122.179.137.173'),
(260, 22, '2024-09-13', '0000-00-00', '14:01:50', '00:00:00', '122.179.137.173'),
(261, 1, '2024-09-16', '2024-09-16', '14:04:37', '14:09:10', '122.179.137.173'),
(262, 21, '2024-09-16', '2024-09-16', '14:09:17', '17:27:01', '122.179.137.173'),
(263, 1, '2024-09-18', '2024-09-18', '15:29:17', '15:30:37', '122.179.137.173'),
(264, 1, '2024-09-18', '0000-00-00', '15:32:03', '00:00:00', '122.179.137.173'),
(265, 1, '2024-09-19', '2024-09-19', '16:38:46', '19:14:21', '122.179.137.173'),
(266, 9, '2024-09-19', '2024-09-19', '16:53:53', '17:30:06', '122.179.137.173'),
(267, 1, '2024-09-19', '2024-09-19', '17:30:12', '19:14:21', '122.179.137.173'),
(268, 9, '2024-09-19', '0000-00-00', '18:03:00', '00:00:00', '122.179.137.173'),
(269, 1, '2024-09-19', '2024-09-19', '18:11:15', '19:14:21', '122.179.137.173'),
(270, 1, '2024-09-19', '2024-09-19', '18:46:30', '19:14:21', '122.179.137.173'),
(271, 1, '2024-09-19', '0000-00-00', '21:00:01', '00:00:00', '103.253.202.202'),
(272, 1, '2024-09-20', '0000-00-00', '09:38:56', '00:00:00', '122.179.137.173'),
(273, 3, '2024-09-20', '0000-00-00', '09:40:06', '00:00:00', '122.179.137.173'),
(274, 1, '2024-09-20', '0000-00-00', '10:42:16', '00:00:00', '122.179.137.173'),
(275, 3, '2024-09-20', '0000-00-00', '12:38:12', '00:00:00', '122.179.137.173'),
(276, 1, '2024-09-20', '0000-00-00', '15:30:16', '00:00:00', '122.179.137.173'),
(277, 1, '2024-09-20', '0000-00-00', '16:19:18', '00:00:00', '122.179.137.173'),
(278, 1, '2024-09-21', '2024-09-21', '16:03:00', '16:03:12', '122.179.137.173'),
(279, 1, '2024-09-24', '0000-00-00', '12:13:34', '00:00:00', '202.88.210.37'),
(280, 1, '2024-09-24', '0000-00-00', '17:17:31', '00:00:00', '202.88.210.37'),
(281, 1, '2024-09-25', '2024-09-25', '13:33:30', '13:41:39', '202.88.210.37'),
(282, 1, '2024-09-28', '0000-00-00', '17:02:44', '00:00:00', '202.88.210.37'),
(283, 1, '2024-10-09', '2024-10-09', '12:43:07', '12:44:59', '122.179.137.173'),
(284, 1, '2024-10-09', '2024-10-09', '12:44:27', '12:44:59', '122.179.137.173'),
(285, 1, '2024-10-19', '0000-00-00', '17:08:31', '00:00:00', '122.179.137.173'),
(286, 1, '2024-10-21', '0000-00-00', '17:36:49', '00:00:00', '122.179.137.173'),
(287, 1, '2024-10-24', '0000-00-00', '16:28:09', '00:00:00', '122.179.137.173'),
(288, 1, '2024-10-24', '0000-00-00', '17:01:53', '00:00:00', '122.179.137.173'),
(289, 1, '2024-10-25', '2024-10-25', '10:28:40', '16:01:06', '122.179.137.173'),
(290, 1, '2024-10-25', '2024-10-25', '11:52:31', '16:01:06', '122.179.137.173'),
(291, 1, '2024-10-25', '2024-10-25', '12:13:47', '16:01:06', '122.179.137.173'),
(292, 1, '2024-10-25', '2024-10-25', '13:11:05', '16:01:06', '122.179.137.173'),
(293, 1, '2024-10-25', '2024-10-25', '15:52:22', '16:01:06', '122.179.137.173'),
(294, 1, '2024-10-25', '0000-00-00', '17:25:07', '00:00:00', '122.179.137.173'),
(295, 1, '2024-10-28', '0000-00-00', '12:28:47', '00:00:00', '122.179.137.173'),
(296, 1, '2024-11-06', '0000-00-00', '17:16:00', '00:00:00', '122.179.137.173'),
(297, 1, '2024-11-14', '0000-00-00', '10:03:40', '00:00:00', '122.179.137.173'),
(298, 1, '2024-11-15', '0000-00-00', '13:09:54', '00:00:00', '122.179.137.173'),
(299, 1, '2024-12-04', '0000-00-00', '13:38:21', '00:00:00', '122.179.137.173'),
(300, 1, '2024-12-05', '0000-00-00', '10:01:39', '00:00:00', '122.179.137.173'),
(301, 1, '2024-12-16', '0000-00-00', '09:52:30', '00:00:00', '122.179.137.173'),
(302, 1, '2025-02-19', '0000-00-00', '16:32:32', '00:00:00', '122.179.137.173');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mm_commercial_questions`
--
ALTER TABLE `mm_commercial_questions`
  ADD PRIMARY KEY (`rfq_commercial_id`);

--
-- Indexes for table `mm_company`
--
ALTER TABLE `mm_company`
  ADD PRIMARY KEY (`company_id`);

--
-- Indexes for table `mm_contact_person`
--
ALTER TABLE `mm_contact_person`
  ADD PRIMARY KEY (`contact_person_id`);

--
-- Indexes for table `mm_department`
--
ALTER TABLE `mm_department`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `mm_designation`
--
ALTER TABLE `mm_designation`
  ADD PRIMARY KEY (`designation_id`);

--
-- Indexes for table `mm_division`
--
ALTER TABLE `mm_division`
  ADD PRIMARY KEY (`division_id`);

--
-- Indexes for table `mm_division_budget`
--
ALTER TABLE `mm_division_budget`
  ADD PRIMARY KEY (`mm_division_budget_id`);

--
-- Indexes for table `mm_employee_permissions`
--
ALTER TABLE `mm_employee_permissions`
  ADD PRIMARY KEY (`employee_permission_id`);

--
-- Indexes for table `mm_financial_document`
--
ALTER TABLE `mm_financial_document`
  ADD PRIMARY KEY (`financial_document_id`);

--
-- Indexes for table `mm_financial_document_approvals`
--
ALTER TABLE `mm_financial_document_approvals`
  ADD PRIMARY KEY (`financial_document_approval_id`);

--
-- Indexes for table `mm_financial_document_materials`
--
ALTER TABLE `mm_financial_document_materials`
  ADD PRIMARY KEY (`financial_document_material_id`);

--
-- Indexes for table `mm_grn`
--
ALTER TABLE `mm_grn`
  ADD PRIMARY KEY (`grn_id`),
  ADD UNIQUE KEY `uc_bill_no` (`bill_no`),
  ADD KEY `grn_no` (`grn_no`),
  ADD KEY `suppplier_id` (`supplier_id`);

--
-- Indexes for table `mm_grn_approved`
--
ALTER TABLE `mm_grn_approved`
  ADD PRIMARY KEY (`approved_id`),
  ADD KEY `grn_id` (`grn_id`);

--
-- Indexes for table `mm_grn_inspected_materials`
--
ALTER TABLE `mm_grn_inspected_materials`
  ADD PRIMARY KEY (`inspected_mat_id`);

--
-- Indexes for table `mm_grn_inspection`
--
ALTER TABLE `mm_grn_inspection`
  ADD PRIMARY KEY (`inspection_id`),
  ADD KEY `grn_id` (`grn_id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `po_id_2` (`po_id`);

--
-- Indexes for table `mm_grn_materials`
--
ALTER TABLE `mm_grn_materials`
  ADD PRIMARY KEY (`grn_mat_id`);

--
-- Indexes for table `mm_grn_sended`
--
ALTER TABLE `mm_grn_sended`
  ADD PRIMARY KEY (`grn_sended_id`),
  ADD KEY `grn_id` (`grn_id`);

--
-- Indexes for table `mm_inventory_flow`
--
ALTER TABLE `mm_inventory_flow`
  ADD PRIMARY KEY (`inventory_id`);

--
-- Indexes for table `mm_inventory_grn`
--
ALTER TABLE `mm_inventory_grn`
  ADD PRIMARY KEY (`grn_id`);

--
-- Indexes for table `mm_invoices`
--
ALTER TABLE `mm_invoices`
  ADD PRIMARY KEY (`invoice_id`);

--
-- Indexes for table `mm_invoices_approval`
--
ALTER TABLE `mm_invoices_approval`
  ADD PRIMARY KEY (`approved_id`);

--
-- Indexes for table `mm_invoices_company_approvals`
--
ALTER TABLE `mm_invoices_company_approvals`
  ADD PRIMARY KEY (`mm_invoices_company_approvals_id`);

--
-- Indexes for table `mm_invoices_materials`
--
ALTER TABLE `mm_invoices_materials`
  ADD PRIMARY KEY (`mm_invoice_material_id`);

--
-- Indexes for table `mm_invoices_taxes`
--
ALTER TABLE `mm_invoices_taxes`
  ADD PRIMARY KEY (`mm_invoices_taxes_id`);

--
-- Indexes for table `mm_invoice_closed`
--
ALTER TABLE `mm_invoice_closed`
  ADD PRIMARY KEY (`invoice_closed_id`);

--
-- Indexes for table `mm_materials`
--
ALTER TABLE `mm_materials`
  ADD PRIMARY KEY (`material_id`);

--
-- Indexes for table `mm_material_category`
--
ALTER TABLE `mm_material_category`
  ADD PRIMARY KEY (`material_category_id`);

--
-- Indexes for table `mm_material_consumed`
--
ALTER TABLE `mm_material_consumed`
  ADD PRIMARY KEY (`mm_material_consumed_id`);

--
-- Indexes for table `mm_payments_terms`
--
ALTER TABLE `mm_payments_terms`
  ADD PRIMARY KEY (`payment_terms_id`);

--
-- Indexes for table `mm_permissions`
--
ALTER TABLE `mm_permissions`
  ADD PRIMARY KEY (`permission_id`);

--
-- Indexes for table `mm_plants`
--
ALTER TABLE `mm_plants`
  ADD PRIMARY KEY (`plant_id`);

--
-- Indexes for table `mm_plant_budget`
--
ALTER TABLE `mm_plant_budget`
  ADD PRIMARY KEY (`plant_budget_id`);

--
-- Indexes for table `mm_po_masters`
--
ALTER TABLE `mm_po_masters`
  ADD PRIMARY KEY (`po_id`);

--
-- Indexes for table `mm_po_materials`
--
ALTER TABLE `mm_po_materials`
  ADD PRIMARY KEY (`po_material_id`);

--
-- Indexes for table `mm_po_supplier_suggestion`
--
ALTER TABLE `mm_po_supplier_suggestion`
  ADD PRIMARY KEY (`po_supplier_suggestion_id`);

--
-- Indexes for table `mm_pr_allocated`
--
ALTER TABLE `mm_pr_allocated`
  ADD PRIMARY KEY (`pr_allocated_id`);

--
-- Indexes for table `mm_pr_approvals`
--
ALTER TABLE `mm_pr_approvals`
  ADD PRIMARY KEY (`pr_approval_id`);

--
-- Indexes for table `mm_pr_master`
--
ALTER TABLE `mm_pr_master`
  ADD PRIMARY KEY (`pr_id`);

--
-- Indexes for table `mm_pr_materials`
--
ALTER TABLE `mm_pr_materials`
  ADD PRIMARY KEY (`pr_material_id`);

--
-- Indexes for table `mm_pr_supplier_suggestion`
--
ALTER TABLE `mm_pr_supplier_suggestion`
  ADD PRIMARY KEY (`supplier_suggestion_id`);

--
-- Indexes for table `mm_reverse_auction`
--
ALTER TABLE `mm_reverse_auction`
  ADD PRIMARY KEY (`rev_auc_id`);

--
-- Indexes for table `mm_rev_auc_bid_details`
--
ALTER TABLE `mm_rev_auc_bid_details`
  ADD PRIMARY KEY (`rev_auc_bid_id`);

--
-- Indexes for table `mm_rev_auc_lots`
--
ALTER TABLE `mm_rev_auc_lots`
  ADD PRIMARY KEY (`rev_lot_id`);

--
-- Indexes for table `mm_rev_auc_sup`
--
ALTER TABLE `mm_rev_auc_sup`
  ADD PRIMARY KEY (`rev_auc_sup_id`);

--
-- Indexes for table `mm_rfq`
--
ALTER TABLE `mm_rfq`
  ADD PRIMARY KEY (`rfq_id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `pr_id` (`pr_id`);

--
-- Indexes for table `mm_rfq_ans`
--
ALTER TABLE `mm_rfq_ans`
  ADD PRIMARY KEY (`rfq_comm_ans_id`);

--
-- Indexes for table `mm_rfq_materials_data`
--
ALTER TABLE `mm_rfq_materials_data`
  ADD PRIMARY KEY (`rfq_mat_data_id`);

--
-- Indexes for table `mm_rfq_oldII`
--
ALTER TABLE `mm_rfq_oldII`
  ADD PRIMARY KEY (`rfq_id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `pr_id` (`pr_id`);

--
-- Indexes for table `mm_rfq_pp_tax_amt`
--
ALTER TABLE `mm_rfq_pp_tax_amt`
  ADD PRIMARY KEY (`pp_tax_amt_id`);

--
-- Indexes for table `mm_rfq_purchase_proposal`
--
ALTER TABLE `mm_rfq_purchase_proposal`
  ADD PRIMARY KEY (`pp_id`);

--
-- Indexes for table `mm_rfq_purchase_proposal_materials`
--
ALTER TABLE `mm_rfq_purchase_proposal_materials`
  ADD PRIMARY KEY (`pp_auto_id`);

--
-- Indexes for table `mm_rfq_settings`
--
ALTER TABLE `mm_rfq_settings`
  ADD PRIMARY KEY (`mm_rfq_setting_id`);

--
-- Indexes for table `mm_rfq_settings_docs`
--
ALTER TABLE `mm_rfq_settings_docs`
  ADD PRIMARY KEY (`mm_rfq_settings_docs_id`);

--
-- Indexes for table `mm_rfq_suppliers`
--
ALTER TABLE `mm_rfq_suppliers`
  ADD PRIMARY KEY (`rfq_sup_id`);

--
-- Indexes for table `mm_rfq_sup_mats`
--
ALTER TABLE `mm_rfq_sup_mats`
  ADD PRIMARY KEY (`rfq_mat_id`);

--
-- Indexes for table `mm_rfq_t_c`
--
ALTER TABLE `mm_rfq_t_c`
  ADD PRIMARY KEY (`t_c_id`),
  ADD KEY `rfq_id` (`rfq_id`);

--
-- Indexes for table `mm_rolewise_emp_permissions`
--
ALTER TABLE `mm_rolewise_emp_permissions`
  ADD PRIMARY KEY (`rolewise_emp_permission_id`);

--
-- Indexes for table `mm_states`
--
ALTER TABLE `mm_states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mm_subdivision_budget`
--
ALTER TABLE `mm_subdivision_budget`
  ADD PRIMARY KEY (`mm_sub_division_budget_id`);

--
-- Indexes for table `mm_sub_division`
--
ALTER TABLE `mm_sub_division`
  ADD PRIMARY KEY (`sub_division_id`);

--
-- Indexes for table `mm_supplier_material_group`
--
ALTER TABLE `mm_supplier_material_group`
  ADD PRIMARY KEY (`sup_mat_group_id`);

--
-- Indexes for table `mm_taxes`
--
ALTER TABLE `mm_taxes`
  ADD PRIMARY KEY (`tax_id`);

--
-- Indexes for table `mm_technical_questions`
--
ALTER TABLE `mm_technical_questions`
  ADD PRIMARY KEY (`rfq_technical_id`),
  ADD KEY `rfq_id` (`rfq_id`);

--
-- Indexes for table `p2p_system_log`
--
ALTER TABLE `p2p_system_log`
  ADD PRIMARY KEY (`logid`);

--
-- Indexes for table `rev_auc_t_c`
--
ALTER TABLE `rev_auc_t_c`
  ADD PRIMARY KEY (`rev_t_c_id`),
  ADD KEY `rev_auction_id` (`rev_auction_id`),
  ADD KEY `supplier_id` (`supplier_id`);

--
-- Indexes for table `userloginlog`
--
ALTER TABLE `userloginlog`
  ADD PRIMARY KEY (`log_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mm_commercial_questions`
--
ALTER TABLE `mm_commercial_questions`
  MODIFY `rfq_commercial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=474;

--
-- AUTO_INCREMENT for table `mm_company`
--
ALTER TABLE `mm_company`
  MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `mm_contact_person`
--
ALTER TABLE `mm_contact_person`
  MODIFY `contact_person_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `mm_department`
--
ALTER TABLE `mm_department`
  MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `mm_designation`
--
ALTER TABLE `mm_designation`
  MODIFY `designation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `mm_division`
--
ALTER TABLE `mm_division`
  MODIFY `division_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `mm_division_budget`
--
ALTER TABLE `mm_division_budget`
  MODIFY `mm_division_budget_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mm_employee_permissions`
--
ALTER TABLE `mm_employee_permissions`
  MODIFY `employee_permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `mm_financial_document`
--
ALTER TABLE `mm_financial_document`
  MODIFY `financial_document_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mm_financial_document_approvals`
--
ALTER TABLE `mm_financial_document_approvals`
  MODIFY `financial_document_approval_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mm_financial_document_materials`
--
ALTER TABLE `mm_financial_document_materials`
  MODIFY `financial_document_material_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mm_grn`
--
ALTER TABLE `mm_grn`
  MODIFY `grn_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mm_grn_approved`
--
ALTER TABLE `mm_grn_approved`
  MODIFY `approved_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mm_grn_inspected_materials`
--
ALTER TABLE `mm_grn_inspected_materials`
  MODIFY `inspected_mat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mm_grn_inspection`
--
ALTER TABLE `mm_grn_inspection`
  MODIFY `inspection_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mm_grn_materials`
--
ALTER TABLE `mm_grn_materials`
  MODIFY `grn_mat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `mm_grn_sended`
--
ALTER TABLE `mm_grn_sended`
  MODIFY `grn_sended_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mm_inventory_flow`
--
ALTER TABLE `mm_inventory_flow`
  MODIFY `inventory_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mm_inventory_grn`
--
ALTER TABLE `mm_inventory_grn`
  MODIFY `grn_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mm_invoices`
--
ALTER TABLE `mm_invoices`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mm_invoices_approval`
--
ALTER TABLE `mm_invoices_approval`
  MODIFY `approved_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mm_invoices_company_approvals`
--
ALTER TABLE `mm_invoices_company_approvals`
  MODIFY `mm_invoices_company_approvals_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mm_invoices_materials`
--
ALTER TABLE `mm_invoices_materials`
  MODIFY `mm_invoice_material_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `mm_invoices_taxes`
--
ALTER TABLE `mm_invoices_taxes`
  MODIFY `mm_invoices_taxes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `mm_invoice_closed`
--
ALTER TABLE `mm_invoice_closed`
  MODIFY `invoice_closed_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mm_materials`
--
ALTER TABLE `mm_materials`
  MODIFY `material_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `mm_material_category`
--
ALTER TABLE `mm_material_category`
  MODIFY `material_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `mm_material_consumed`
--
ALTER TABLE `mm_material_consumed`
  MODIFY `mm_material_consumed_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mm_payments_terms`
--
ALTER TABLE `mm_payments_terms`
  MODIFY `payment_terms_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `mm_permissions`
--
ALTER TABLE `mm_permissions`
  MODIFY `permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `mm_plants`
--
ALTER TABLE `mm_plants`
  MODIFY `plant_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `mm_plant_budget`
--
ALTER TABLE `mm_plant_budget`
  MODIFY `plant_budget_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mm_po_masters`
--
ALTER TABLE `mm_po_masters`
  MODIFY `po_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `mm_po_materials`
--
ALTER TABLE `mm_po_materials`
  MODIFY `po_material_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `mm_po_supplier_suggestion`
--
ALTER TABLE `mm_po_supplier_suggestion`
  MODIFY `po_supplier_suggestion_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `mm_pr_allocated`
--
ALTER TABLE `mm_pr_allocated`
  MODIFY `pr_allocated_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `mm_pr_approvals`
--
ALTER TABLE `mm_pr_approvals`
  MODIFY `pr_approval_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `mm_pr_master`
--
ALTER TABLE `mm_pr_master`
  MODIFY `pr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `mm_pr_materials`
--
ALTER TABLE `mm_pr_materials`
  MODIFY `pr_material_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `mm_pr_supplier_suggestion`
--
ALTER TABLE `mm_pr_supplier_suggestion`
  MODIFY `supplier_suggestion_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=148;

--
-- AUTO_INCREMENT for table `mm_reverse_auction`
--
ALTER TABLE `mm_reverse_auction`
  MODIFY `rev_auc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `mm_rev_auc_bid_details`
--
ALTER TABLE `mm_rev_auc_bid_details`
  MODIFY `rev_auc_bid_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mm_rev_auc_lots`
--
ALTER TABLE `mm_rev_auc_lots`
  MODIFY `rev_lot_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `mm_rev_auc_sup`
--
ALTER TABLE `mm_rev_auc_sup`
  MODIFY `rev_auc_sup_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `mm_rfq`
--
ALTER TABLE `mm_rfq`
  MODIFY `rfq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `mm_rfq_ans`
--
ALTER TABLE `mm_rfq_ans`
  MODIFY `rfq_comm_ans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=568;

--
-- AUTO_INCREMENT for table `mm_rfq_materials_data`
--
ALTER TABLE `mm_rfq_materials_data`
  MODIFY `rfq_mat_data_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `mm_rfq_oldII`
--
ALTER TABLE `mm_rfq_oldII`
  MODIFY `rfq_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mm_rfq_pp_tax_amt`
--
ALTER TABLE `mm_rfq_pp_tax_amt`
  MODIFY `pp_tax_amt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `mm_rfq_purchase_proposal`
--
ALTER TABLE `mm_rfq_purchase_proposal`
  MODIFY `pp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `mm_rfq_purchase_proposal_materials`
--
ALTER TABLE `mm_rfq_purchase_proposal_materials`
  MODIFY `pp_auto_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `mm_rfq_settings`
--
ALTER TABLE `mm_rfq_settings`
  MODIFY `mm_rfq_setting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mm_rfq_settings_docs`
--
ALTER TABLE `mm_rfq_settings_docs`
  MODIFY `mm_rfq_settings_docs_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `mm_rfq_suppliers`
--
ALTER TABLE `mm_rfq_suppliers`
  MODIFY `rfq_sup_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170;

--
-- AUTO_INCREMENT for table `mm_rfq_sup_mats`
--
ALTER TABLE `mm_rfq_sup_mats`
  MODIFY `rfq_mat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=491;

--
-- AUTO_INCREMENT for table `mm_rfq_t_c`
--
ALTER TABLE `mm_rfq_t_c`
  MODIFY `t_c_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `mm_rolewise_emp_permissions`
--
ALTER TABLE `mm_rolewise_emp_permissions`
  MODIFY `rolewise_emp_permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `mm_states`
--
ALTER TABLE `mm_states`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `mm_subdivision_budget`
--
ALTER TABLE `mm_subdivision_budget`
  MODIFY `mm_sub_division_budget_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `mm_sub_division`
--
ALTER TABLE `mm_sub_division`
  MODIFY `sub_division_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `mm_supplier_material_group`
--
ALTER TABLE `mm_supplier_material_group`
  MODIFY `sup_mat_group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `mm_taxes`
--
ALTER TABLE `mm_taxes`
  MODIFY `tax_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `mm_technical_questions`
--
ALTER TABLE `mm_technical_questions`
  MODIFY `rfq_technical_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=330;

--
-- AUTO_INCREMENT for table `p2p_system_log`
--
ALTER TABLE `p2p_system_log`
  MODIFY `logid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=929;

--
-- AUTO_INCREMENT for table `rev_auc_t_c`
--
ALTER TABLE `rev_auc_t_c`
  MODIFY `rev_t_c_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userloginlog`
--
ALTER TABLE `userloginlog`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=303;
COMMIT;

