-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `inetinfo_amc`
--

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `log_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `module` varchar(100) NOT NULL,
  `record_id` int(11) DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` (`log_id`, `user_id`, `action`, `module`, `record_id`, `old_values`, `new_values`, `ip_address`, `user_agent`, `created_at`) VALUES
(1, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-18 17:54:00'),
(2, 1, 'create', 'company', 1, NULL, '{\"company_name\":\"I-Net Infotech\",\"address\":\"Flat 02, BLDG B1, Shantinath, Ostwal Empire,\\r\\nBoisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"aniket143@gmail.com\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"\",\"bank_account\":\"\",\"bank_ifsc\":\"\",\"upi_id\":\"\",\"terms_conditions\":\"\",\"invoice_footer\":\"\",\"status\":1}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-18 18:50:55'),
(3, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 07:13:29'),
(4, 1, 'create', 'customers', 1, NULL, '{\"customer_id\":\"CUS-01001\",\"company_name\":\"Alchemie Gases &amp; Chemical Pvt. Ltd.\",\"contact_person\":\"Sushma Patil\",\"designation\":\"Director\",\"mobile\":\"9619490322\",\"alternate_mobile\":\"\",\"email\":\"tarapur@alchemiegases.com\",\"website\":\"https:\\/\\/www.alchemiegases.com\\/\",\"gst_number\":\"27AABCA4554F1ZW\",\"pan\":\"\",\"customer_type\":\"Enterprise\",\"industry\":\"Pharmaceutical\",\"address\":\"Plot No. T-112, M.I.D.C., Tarapur, Dist. Palghar-401 506. (Maharashtra), India.\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"notes\":\"\",\"status\":\"active\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 07:22:00'),
(5, 1, 'create', 'software', 1, NULL, '{\"software_code\":\"SW001\",\"software_name\":\"Cylinder tracking and Inventory Management System\",\"category\":\"Custom\",\"version\":\"1.6\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql,Jquery,HTML\",\"description\":\"Comprehensive ERP solution for tracking industrial gas cylinders across 50+ distribution centers, also generating auto billing and reminders.\",\"license_type\":\"Single\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":7812,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-07-19 12:57:04\",\"created_at\":\"2026-07-19 12:57:04\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 07:27:04'),
(6, 1, 'create', 'software', 2, NULL, '{\"software_code\":\"SW002\",\"software_name\":\"Gas Manufacturing Process System (MPS)\",\"category\":\"Custom\",\"version\":\"1.5\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql,HTML\",\"description\":\"GAS Manufacturing Details\",\"license_type\":\"Single\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":7080,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-07-19 12:59:40\",\"created_at\":\"2026-07-19 12:59:40\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 07:29:41'),
(7, 1, 'create', 'software', 3, NULL, '{\"software_code\":\"SW003\",\"software_name\":\"GAS CRM(Customer Managment System)\",\"category\":\"Custom\",\"version\":\"1.3\",\"platform\":\"Linux\",\"technology\":\"Php,Mysql,HTML\",\"description\":\"CRM\",\"license_type\":\"Single\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":6150,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-07-19 15:33:59\",\"created_at\":\"2026-07-19 15:33:59\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 10:03:59'),
(8, 1, 'create', 'amc', 1, NULL, '{\"amc_number\":\"AMC-00001\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7812,\"gst_rate\":18,\"gst_amount\":1406.16,\"discount\":0,\"net_amount\":9218.16,\"start_date\":\"2026-03-01\",\"end_date\":\"2027-04-01\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"10 AM- 6PM\",\"response_time\":\"8hrs\",\"priority\":\"Medium\",\"auto_renewal\":0,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:15:18\",\"updated_at\":\"2026-07-19 16:15:18\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 10:45:18'),
(9, 1, 'create', 'amc', 2, NULL, '{\"amc_number\":\"AMC-00002\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7812.5,\"gst_rate\":18,\"gst_amount\":1406.25,\"discount\":0,\"net_amount\":9218.75,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":\"\",\"priority\":\"\",\"auto_renewal\":0,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:18:09\",\"updated_at\":\"2026-07-19 16:18:09\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 10:48:09'),
(10, 1, 'create', 'amc', 3, NULL, '{\"amc_number\":\"AMC-00003\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7812.5,\"gst_rate\":18,\"gst_amount\":1406.25,\"discount\":0,\"net_amount\":9218.75,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"\",\"payment_terms\":\"\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":\"\",\"priority\":\"\",\"auto_renewal\":0,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:29:28\",\"updated_at\":\"2026-07-19 16:29:28\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 10:59:28'),
(11, 1, 'create', 'amc', 4, NULL, '{\"amc_number\":\"AMC-00004\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7812.5,\"gst_rate\":18,\"gst_amount\":1406.25,\"discount\":0,\"net_amount\":9218.75,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"10 AM - 6 PM\",\"response_time\":\"24hrs\",\"priority\":\"medium\",\"auto_renewal\":1,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:37:48\",\"updated_at\":\"2026-07-19 16:37:48\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:07:48'),
(12, 1, 'update', 'amc', 2, '{\"id\":2,\"amc_number\":\"AMC-00002\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":\"7812.50\",\"gst_rate\":\"18.00\",\"gst_amount\":\"1406.25\",\"discount\":\"0.00\",\"net_amount\":\"9218.75\",\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":\"\",\"priority\":\"\",\"auto_renewal\":0,\"agreement_pdf\":null,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:18:09\",\"updated_at\":\"2026-07-19 16:18:09\"}', '{\"customer_id\":1,\"software_id\":2,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7080,\"gst_rate\":18,\"gst_amount\":1274.4,\"discount\":0,\"net_amount\":8354.4,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":0,\"updated_at\":\"2026-07-19 16:42:19\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:12:19'),
(13, 1, 'update', 'amc', 3, '{\"id\":3,\"amc_number\":\"AMC-00003\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":\"7812.50\",\"gst_rate\":\"18.00\",\"gst_amount\":\"1406.25\",\"discount\":\"0.00\",\"net_amount\":\"9218.75\",\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"\",\"payment_terms\":\"\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":\"\",\"priority\":\"\",\"auto_renewal\":0,\"agreement_pdf\":null,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:29:28\",\"updated_at\":\"2026-07-19 16:29:28\"}', '{\"customer_id\":1,\"software_id\":3,\"amc_type\":\"custom\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":6150,\"gst_rate\":18,\"gst_amount\":1107,\"discount\":0,\"net_amount\":7257,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-31\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"\",\"payment_terms\":\"\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":0,\"updated_at\":\"2026-07-19 16:43:36\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:13:36'),
(14, 1, 'create', 'invoice', 1, NULL, '{\"invoice_number\":\"INV-00001\",\"amc_id\":1,\"customer_id\":1,\"invoice_date\":\"2026-03-01\",\"due_date\":\"2026-03-31\",\"subtotal\":7812,\"gst_rate\":18,\"gst_amount\":1406.16,\"discount\":0,\"total_amount\":9218.16,\"paid_amount\":0,\"balance_amount\":9218.16,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"qr_code\":\"https:\\/\\/api.qrserver.com\\/v1\\/create-qr-code\\/?size=200x200&data=1-AMC-00001-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.\",\"status\":\"draft\",\"created_by\":1,\"created_at\":\"2026-07-19 17:04:56\",\"updated_at\":\"2026-07-19 17:04:56\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:34:56'),
(15, 1, 'create', 'payment', 1, NULL, '{\"payment_id\":\"PAY-00001\",\"invoice_id\":1,\"customer_id\":1,\"invoice_amount\":9218.16,\"received_amount\":9218,\"pending_amount\":0.15999999999985448,\"payment_date\":\"2026-04-05\",\"payment_mode\":\"bank_transfer\",\"reference_number\":\"\",\"transaction_id\":\"\",\"bank_name\":\"\",\"cheque_number\":\"\",\"cheque_date\":\"\",\"remarks\":\"\",\"receipt_number\":\"RCT-20260719-00001\",\"status\":\"completed\",\"created_by\":1,\"created_at\":\"2026-07-19 17:08:59\",\"updated_at\":\"2026-07-19 17:08:59\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:38:59'),
(16, 1, 'update', 'amc', 1, '{\"id\":1,\"amc_number\":\"AMC-00001\",\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":\"7812.00\",\"gst_rate\":\"18.00\",\"gst_amount\":\"1406.16\",\"discount\":\"0.00\",\"net_amount\":\"9218.16\",\"start_date\":\"2026-03-01\",\"end_date\":\"2027-04-01\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"10 AM- 6PM\",\"response_time\":\"8hrs\",\"priority\":\"medium\",\"auto_renewal\":0,\"agreement_pdf\":null,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-19 16:15:18\",\"updated_at\":\"2026-07-19 16:15:18\"}', '{\"customer_id\":1,\"software_id\":1,\"amc_type\":\"custom\",\"amc_type_label\":\"Custom\",\"amc_frequency\":\"quarterly\",\"amc_amount\":7812,\"gst_rate\":18,\"gst_amount\":1406.16,\"discount\":0,\"net_amount\":9218.16,\"start_date\":\"2026-03-01\",\"end_date\":\"2027-04-01\",\"renewal_date\":\"2027-03-31\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"30\",\"service_visits\":0,\"support_hours\":\"10 AM- 6PM\",\"response_time\":\"8hrs\",\"priority\":\"medium\",\"auto_renewal\":1,\"updated_at\":\"2026-07-19 17:18:27\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 11:48:27'),
(17, 1, 'create', 'customer_software', 1, NULL, '{\"customer_id\":1,\"software_id\":1,\"license_number\":\"INET-SW001-01\",\"activation_date\":\"2020-07-27\",\"installation_date\":\"2020-07-10\",\"warranty_start\":null,\"warranty_end\":null,\"amc_start\":\"2021-06-19\",\"amc_end\":null,\"number_of_users\":20,\"license_type\":\"Single\",\"installation_engineer\":\"Aniket Dalvi\",\"remarks\":\"\",\"status\":\"active\",\"updated_at\":\"2026-07-19 20:51:37\",\"created_at\":\"2026-07-19 20:51:37\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 15:21:37'),
(18, 1, 'create', 'invoice', 2, NULL, '{\"invoice_number\":\"INV-00002\",\"amc_id\":3,\"customer_id\":1,\"invoice_date\":\"2026-07-19\",\"due_date\":\"2026-08-18\",\"subtotal\":6150,\"gst_rate\":18,\"gst_amount\":1107,\"discount\":0,\"total_amount\":7257,\"paid_amount\":0,\"balance_amount\":7257,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"Service Period - 1-APR-2026 To 31-JUN-2026\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"qr_code\":\"https:\\/\\/api.qrserver.com\\/v1\\/create-qr-code\\/?size=200x200&data=1-AMC-00003-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.\",\"status\":\"draft\",\"created_by\":1,\"created_at\":\"2026-07-19 21:54:35\",\"updated_at\":\"2026-07-19 21:54:35\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 16:24:35'),
(19, 1, 'create', 'invoice', 3, NULL, '{\"invoice_number\":\"INV-00003\",\"amc_id\":4,\"customer_id\":1,\"invoice_date\":\"2026-07-19\",\"due_date\":\"2026-08-18\",\"subtotal\":7812.5,\"gst_rate\":18,\"gst_amount\":1406.25,\"discount\":0,\"total_amount\":9218.75,\"paid_amount\":0,\"balance_amount\":9218.75,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"AMC - AMC-00004 (Alchemie Gases &amp; Chemical Pvt. Ltd.)\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"qr_code\":\"https:\\/\\/api.qrserver.com\\/v1\\/create-qr-code\\/?size=200x200&data=Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.-AMC-00004\",\"status\":\"draft\",\"created_by\":1,\"created_at\":\"2026-07-19 22:01:44\",\"updated_at\":\"2026-07-19 22:01:44\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-19 16:31:44'),
(20, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0', '2026-07-20 09:08:50'),
(21, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 10:26:34'),
(22, 1, 'create', 'invoice', 4, NULL, '{\"invoice_number\":\"INV-00004\",\"amc_id\":2,\"customer_id\":1,\"invoice_date\":\"2026-07-20\",\"due_date\":\"2026-08-19\",\"subtotal\":7080,\"gst_rate\":18,\"gst_amount\":1274.4,\"discount\":0,\"total_amount\":8354.4,\"paid_amount\":0,\"balance_amount\":8354.4,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"qr_code\":\"https:\\/\\/api.qrserver.com\\/v1\\/create-qr-code\\/?size=200x200&data=1-AMC-00002-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.\",\"status\":\"draft\",\"created_by\":1,\"created_at\":\"2026-07-20 16:01:56\",\"updated_at\":\"2026-07-20 16:01:56\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 10:31:56'),
(23, 1, 'login', 'auth', 1, NULL, NULL, '103.48.100.130', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 11:25:54'),
(24, 1, 'login', 'auth', 1, NULL, NULL, '103.48.100.130', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 11:28:04'),
(25, 1, 'update', 'company', 1, '{\"id\":\"1\",\"logo\":null,\"upi_qr\":null,\"signature_image\":null}', '{\"company_name\":\"I-Net Infotech\",\"address\":\"Flat 02, BLDG B1, Shantinath, Ostwal Empire,\\r\\nBoisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"27AAFFI1991R1ZM\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"aniket143@gmail.com\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"Kotak Mahindra Bank\",\"bank_account\":\"6111613955\",\"bank_ifsc\":\"KKBK0000672\",\"upi_id\":\"\",\"terms_conditions\":\"1.Thanks for your business.\\r\\n2.This invoice is generated using I-Net Inventory\",\"invoice_footer\":\"This is a computer generated invoice no signature required\",\"logo\":\"company\\/logod31fb6dca56523f773f29f5ce319abf8.png\"}', '103.48.100.130', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 11:30:26'),
(26, 1, 'update', 'company', 1, '{\"id\":\"1\",\"logo\":\"company\\/logod31fb6dca56523f773f29f5ce319abf8.png\",\"upi_qr\":null,\"signature_image\":null}', '{\"company_name\":\"I-Net Infotech\",\"address\":\"Flat 02, BLDG B1, Shantinath, Ostwal Empire,\\r\\nBoisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"27AAFFI1991R1ZM\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"aniket143@gmail.com\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"Kotak Mahindra Bank\",\"bank_account\":\"6111613955\",\"bank_ifsc\":\"KKBK0000672\",\"upi_id\":\"\",\"terms_conditions\":\"1.Thanks for your business.\\r\\n2.This invoice is generated using I-Net Inventory\",\"invoice_footer\":\"This is a computer generated invoice no signature required\",\"logo\":\"company\\/logoe870f2bccbdb2e69348e6861b2ff4d2d.png\"}', '103.48.100.130', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 11:30:29'),
(27, 1, 'create', 'customers', 2, NULL, '{\"customer_id\":\"CUS-01002\",\"company_name\":\"Autocal Solution Pvt. Ltd.\",\"contact_person\":\"Kiran Dalvi\",\"designation\":\"\",\"mobile\":\"09890624789\",\"alternate_mobile\":\"\",\"email\":\"kiran.a.dalvi2010@gmail.com\",\"website\":\"\",\"gst_number\":\"27AAGCA9480PIZV\",\"pan\":\"\",\"customer_type\":\"Enterprise\",\"industry\":\"Other\",\"address\":\"Unit No.4, Ruby Industrial estate, PCS ltd, Navghar,\",\"city\":\"Vasai(E)\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401 210\",\"notes\":\"\",\"status\":\"active\"}', '103.48.100.130', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-20 11:34:47'),
(28, 1, 'login', 'auth', 1, NULL, NULL, '2401:4900:891e:f7d8:b4c2:d95:414c:3ee4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-21 16:46:09'),
(29, 1, 'update', 'company', 1, '{\"id\":\"1\",\"logo\":\"company\\/logoe870f2bccbdb2e69348e6861b2ff4d2d.png\",\"upi_qr\":null,\"signature_image\":null}', '{\"company_name\":\"I-Net Infotech\",\"address\":\"Flat 02, BLDG B1, Shantinath, Ostwal Empire,\\r\\nBoisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"27AAFFI1991R1ZM\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"admin@sbitinfo.in\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"Kotak Mahindra Bank\",\"bank_account\":\"6111613955\",\"bank_ifsc\":\"KKBK0000672\",\"upi_id\":\"\",\"terms_conditions\":\"1.Thanks for your business.\\r\\n2.This invoice is generated using I-Net Inventory\",\"invoice_footer\":\"This is a computer generated invoice no signature required\"}', '2401:4900:891e:f7d8:b4c2:d95:414c:3ee4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-21 17:03:24'),
(30, 1, 'update', 'customers', 1, '{\"id\":\"1\",\"customer_id\":\"CUS-01001\",\"company_name\":\"Alchemie Gases &amp; Chemical Pvt. Ltd.\",\"contact_person\":\"Sushma Patil\",\"designation\":\"Director\",\"mobile\":\"9619490322\",\"alternate_mobile\":\"\",\"email\":\"tarapur@alchemiegases.com\",\"website\":\"https:\\/\\/www.alchemiegases.com\\/\",\"gst_number\":\"27AABCA4554F1ZW\",\"pan\":\"\",\"address\":\"Plot No. T-112, M.I.D.C., Tarapur, Dist. Palghar-401 506. (Maharashtra), India.\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"customer_type\":\"Enterprise\",\"industry\":\"Pharmaceutical\",\"notes\":\"\",\"logo\":null,\"agreement_copy\":null,\"pan_copy\":null,\"gst_certificate\":null,\"other_documents\":null,\"status\":\"active\",\"created_at\":\"2026-07-19 12:52:00\",\"updated_at\":\"2026-07-19 12:52:00\"}', '{\"company_name\":\"Alchemie Gases and Chemical Pvt. Ltd.\",\"contact_person\":\"Sushma Patil\",\"designation\":\"Director\",\"mobile\":\"9619490322\",\"alternate_mobile\":\"\",\"email\":\"tarapur@alchemiegases.com\",\"website\":\"https:\\/\\/www.alchemiegases.com\\/\",\"gst_number\":\"27AABCA4554F1ZW\",\"pan\":\"\",\"customer_type\":\"Enterprise\",\"industry\":\"Pharmaceutical\",\"address\":\"Plot No. T-112, M.I.D.C., Tarapur, Dist. Palghar-401 506. (Maharashtra), India.\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"notes\":\"\",\"status\":\"active\"}', '2401:4900:891e:f7d8:b4c2:d95:414c:3ee4', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-21 17:04:14'),
(31, 1, 'login', 'auth', 1, NULL, NULL, '103.89.43.187', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-22 06:02:05'),
(32, 1, 'login', 'auth', 1, NULL, NULL, '103.77.153.242', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-29 11:11:47'),
(33, 1, 'create', 'customers', 3, NULL, '{\"customer_id\":\"CUS-01003\",\"company_name\":\"kusmo\",\"contact_person\":\"Nilesh Darade\",\"designation\":\"Manager\",\"mobile\":\"9322314166\",\"alternate_mobile\":\"9311066000\",\"email\":\"kusmochemicals@yahoo.co.in\",\"website\":\"www.kusmochemicals.com\",\"gst_number\":\"\",\"pan\":\"\",\"customer_type\":\"\",\"industry\":\"Pharmaceutical\",\"address\":\"Unit No. 7-8, Kedia Compound, Wada Road,\\r\\nShelar Village, Bhiwandi, Thane-421 302, Maharashtra, India\",\"city\":\"Thane\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"421 302\",\"notes\":\"\",\"status\":\"active\"}', '103.77.153.242', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 06:31:27'),
(34, 1, 'create', 'software', 4, NULL, '{\"software_code\":\"WS-01\",\"software_name\":\"Website\",\"category\":\"Web\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,HTML\",\"description\":\"Kusmochemical website\",\"license_type\":\"Single\",\"annual_amc_amount\":2500,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":0,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-07-30 12:27:59\",\"created_at\":\"2026-07-30 12:27:59\"}', '103.77.153.242', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 06:57:59'),
(35, 1, 'create', 'amc', 5, NULL, '{\"amc_number\":\"AMC-00005\",\"customer_id\":3,\"software_id\":4,\"amc_type\":\"support_only\",\"amc_type_label\":\"\",\"amc_frequency\":\"yearly\",\"amc_amount\":2500,\"gst_rate\":18,\"gst_amount\":450,\"discount\":0,\"net_amount\":2950,\"start_date\":\"2026-04-01\",\"end_date\":\"2027-03-30\",\"renewal_date\":\"2027-03-01\",\"billing_cycle\":\"Yearly\",\"payment_terms\":\"Valid For 30 Days\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":1,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-07-30 12:57:16\",\"updated_at\":\"2026-07-30 12:57:16\"}', '103.77.153.242', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-07-30 07:27:16'),
(36, 1, 'login', 'auth', 1, NULL, NULL, '103.174.30.231', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-08-10 11:15:39'),
(37, 1, 'login', 'auth', 1, NULL, NULL, '2401:4900:891e:93f:f8c8:bf65:b72:b842', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-09-01 12:49:31'),
(38, 1, 'create', 'software', 5, NULL, '{\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Single\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":19000,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-09-01 18:24:36\",\"created_at\":\"2026-09-01 18:24:36\"}', '2401:4900:891e:93f:f8c8:bf65:b72:b842', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-09-01 12:54:36'),
(39, 1, 'create', 'amc', 6, NULL, '{\"amc_number\":\"AMC-00006\",\"customer_id\":2,\"software_id\":5,\"amc_type\":\"support_only\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":19000,\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"net_amount\":22420,\"start_date\":\"2026-03-01\",\"end_date\":\"2027-02-28\",\"renewal_date\":\"2027-03-01\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"Net 15 Days\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":1,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-09-01 18:27:35\",\"updated_at\":\"2026-09-01 18:27:35\"}', '2401:4900:891e:93f:f8c8:bf65:b72:b842', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-09-01 12:57:35'),
(40, 1, 'create', 'invoice', 5, NULL, '{\"invoice_number\":\"INV-00005\",\"amc_id\":6,\"customer_id\":2,\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"subtotal\":19000,\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"total_amount\":22420,\"paid_amount\":0,\"balance_amount\":22420,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"qr_code\":\"https:\\/\\/api.qrserver.com\\/v1\\/create-qr-code\\/?size=200x200&data=2-AMC-00006-Autocal+Solution+Pvt.+Ltd.\",\"status\":\"draft\",\"created_by\":1,\"created_at\":\"2026-09-01 18:28:14\",\"updated_at\":\"2026-09-01 18:28:14\"}', '2401:4900:891e:93f:f8c8:bf65:b72:b842', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-09-01 12:58:14'),
(41, 1, 'login', 'auth', 1, NULL, NULL, '2401:4900:8925:5f02:4d65:5629:3f53:ddcb', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-09-02 10:31:12'),
(42, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 11:35:02'),
(43, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\",\"status\":\"draft\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"total_amount\":22420,\"balance_amount\":22420,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"status\":\"draft\",\"updated_at\":\"2026-09-02 17:12:35\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 11:42:35'),
(44, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\",\"status\":\"draft\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"total_amount\":22420,\"balance_amount\":22420,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"status\":\"draft\",\"updated_at\":\"2026-09-02 17:16:01\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 11:46:01'),
(45, 1, 'update', 'amc', 6, '{\"id\":6,\"amc_number\":\"AMC-00006\",\"customer_id\":2,\"software_id\":5,\"amc_type\":\"support_only\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":\"19000.00\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"net_amount\":\"22420.00\",\"start_date\":\"2026-03-01\",\"end_date\":\"2027-02-28\",\"renewal_date\":\"2027-03-01\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"Net 15 Days\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":1,\"agreement_pdf\":null,\"status\":\"active\",\"created_by\":1,\"created_at\":\"2026-09-01 18:27:35\",\"updated_at\":\"2026-09-01 18:27:35\"}', '{\"customer_id\":2,\"software_id\":5,\"amc_type\":\"support_only\",\"amc_type_label\":\"\",\"amc_frequency\":\"quarterly\",\"amc_amount\":19000,\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"net_amount\":22420,\"start_date\":\"2026-03-01\",\"end_date\":\"2027-02-28\",\"renewal_date\":\"2027-03-01\",\"billing_cycle\":\"Quaterly\",\"payment_terms\":\"Net 15 Days\",\"service_visits\":0,\"support_hours\":\"\",\"response_time\":null,\"priority\":\"medium\",\"auto_renewal\":1,\"updated_at\":\"2026-09-02 17:19:52\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 11:49:52'),
(46, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\",\"status\":\"draft\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"gst_amount\":3420,\"discount\":0,\"total_amount\":22420,\"balance_amount\":22420,\"payment_status\":\"pending\",\"hsn_code\":\"998314\",\"description\":\"\",\"terms\":\"Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.\",\"status\":\"draft\",\"updated_at\":\"2026-09-02 17:30:16\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:00:16'),
(47, 1, 'cache_cleared', 'settings', NULL, NULL, '{\"files_cleared\":1}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:13:41'),
(48, 1, 'update', 'company', 1, '{\"id\":1,\"logo\":\"company\\/logoe870f2bccbdb2e69348e6861b2ff4d2d.png\",\"upi_qr\":null,\"signature_image\":null}', '{\"company_name\":\"I-Net Infotech\",\"address\":\"Shiv Sagar building, 102, khodaram bagh road, behind Don Bosco school, Sainath Nagar, Boisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"27AAFFI1991R1ZM\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"admin@sbitinfo.in\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"Kotak Mahindra Bank\",\"bank_account\":\"6111613955\",\"bank_ifsc\":\"KKBK0000672\",\"upi_id\":\"\",\"terms_conditions\":\"1.Thanks for your business.\\r\\n2.This invoice is generated using I-Net Inventory\",\"invoice_footer\":\"This is a computer generated invoice no signature required\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:15:29'),
(49, 1, 'logout', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:48:53'),
(50, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:54:42'),
(51, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:59:22'),
(52, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 12:59:44'),
(53, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 13:00:29'),
(54, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-02 13:03:29'),
(55, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 04:55:46'),
(56, 1, 'update', 'software', 5, '{\"id\":5,\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Single\",\"annual_amc_amount\":\"0.00\",\"monthly_amc_amount\":\"0.00\",\"quarterly_amc_amount\":\"19000.00\",\"half_yearly_amc_amount\":\"0.00\",\"custom_amc_amount\":\"0.00\",\"installation_charge\":\"0.00\",\"support_charge\":\"0.00\",\"status\":1,\"created_at\":\"2026-09-01 18:24:36\",\"updated_at\":\"2026-09-01 18:24:36\"}', '{\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Open Source\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":19000,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-09-03 10:26:40\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 04:56:40'),
(57, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 08:34:04'),
(58, 1, 'update', 'software', 5, '{\"id\":5,\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Open Source\",\"annual_amc_amount\":\"0.00\",\"monthly_amc_amount\":\"0.00\",\"quarterly_amc_amount\":\"19000.00\",\"half_yearly_amc_amount\":\"0.00\",\"custom_amc_amount\":\"0.00\",\"installation_charge\":\"0.00\",\"support_charge\":\"0.00\",\"status\":1,\"created_at\":\"2026-09-01 18:24:36\",\"updated_at\":\"2026-09-03 10:26:40\"}', '{\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Open Source\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":0,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-09-03 14:14:37\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 08:44:37'),
(59, 1, 'update', 'software', 5, '{\"id\":5,\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Open Source\",\"annual_amc_amount\":\"0.00\",\"monthly_amc_amount\":\"0.00\",\"quarterly_amc_amount\":\"0.00\",\"half_yearly_amc_amount\":\"0.00\",\"custom_amc_amount\":\"0.00\",\"installation_charge\":\"0.00\",\"support_charge\":\"0.00\",\"status\":1,\"created_at\":\"2026-09-01 18:24:36\",\"updated_at\":\"2026-09-03 14:14:37\"}', '{\"software_code\":\"SW-004\",\"software_name\":\"Calibration Management System\",\"category\":\"Custom\",\"version\":\"1.2\",\"platform\":\"Linux\",\"technology\":\"PHP,Mysql\",\"description\":\"Calibration certificate creation, instrument inventory managemnt\",\"license_type\":\"Open Source\",\"annual_amc_amount\":0,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":19000,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-09-03 14:14:56\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 08:44:56'),
(60, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:02:32'),
(61, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:21:25'),
(62, 1, 'update', 'invoice', 5, '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":\"18.00\",\"gst_amount\":\"3420.00\",\"discount\":\"0.00\",\"total_amount\":\"22420.00\"}', '{\"invoice_date\":\"2026-09-01\",\"due_date\":\"2026-09-24\",\"gst_rate\":18,\"discount\":0,\"total_amount\":22420}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:22:07'),
(63, 1, 'update', 'company', 1, '{\"id\":1,\"logo\":\"company\\/logoe870f2bccbdb2e69348e6861b2ff4d2d.png\",\"upi_qr\":null,\"signature_image\":null}', '{\"company_name\":\"I-Net Infotech\",\"address\":\"Shiv Sagar building, 102, khodaram bagh road, behind Don Bosco school, Sainath Nagar, Boisar, Maharashtra 401501\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"gst_number\":\"27AAFFI1991R1ZM\",\"pan\":\"\",\"cin\":\"\",\"mobile\":\"09175418884\",\"email\":\"admin@sbitinfo.in\",\"website\":\"https:\\/\\/inetinfo.in\\/\",\"bank_name\":\"Kotak Mahindra Bank\",\"bank_account\":\"6111613955\",\"bank_ifsc\":\"KKBK0000672\",\"upi_id\":\"\",\"terms_conditions\":\"1.Thanks for your business.\\r\\n2.This invoice is generated using I-Net Inventory\",\"invoice_footer\":\"\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:26:54'),
(64, 1, 'create', 'customers', 4, NULL, '{\"customer_id\":\"CUS-01004\",\"company_name\":\"Adeshwar Meditex Limited\",\"contact_person\":\"Omkar Raut\",\"designation\":\"\",\"mobile\":\"7709176484\",\"alternate_mobile\":\"\",\"email\":\"adeshwarmedi@gmail.com\",\"website\":\"https:\\/\\/adeshwarmeditex.com\\/\",\"gst_number\":\"27AAGCA2560A1Z7\",\"pan\":\"\",\"customer_type\":\"Enterprise\",\"industry\":\"Pharmaceutical\",\"address\":\"17\\/18, Dewan &amp; Sons, Udyog Nagar, Palghar west, Pin- 401404\\r\\nMaharashtra \\u2013 INDIA\",\"city\":\"Palghar\",\"state\":\"Maharashtra\",\"country\":\"India\",\"pin_code\":\"401501\",\"notes\":\"\",\"status\":\"active\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:46:58'),
(65, 1, 'create', 'software', 6, NULL, '{\"software_code\":\"WS-02\",\"software_name\":\"Web Hosting\",\"category\":\"Web\",\"version\":\"1.1\",\"platform\":\"Linux\",\"technology\":\"PHP,HTML,Wordpress\",\"description\":\"\",\"license_type\":\"Single\",\"annual_amc_amount\":5000,\"monthly_amc_amount\":0,\"quarterly_amc_amount\":0,\"half_yearly_amc_amount\":0,\"custom_amc_amount\":0,\"installation_charge\":0,\"support_charge\":0,\"status\":1,\"updated_at\":\"2026-09-03 17:19:28\",\"created_at\":\"2026-09-03 17:19:28\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:49:28'),
(66, 1, 'create', 'customer_software', 2, NULL, '{\"customer_id\":4,\"software_id\":6,\"license_number\":\"\",\"activation_date\":\"2026-06-25\",\"installation_date\":\"2023-05-12\",\"warranty_start\":\"2026-06-25\",\"warranty_end\":\"2027-06-14\",\"amc_start\":\"2026-06-15\",\"amc_end\":\"2027-06-14\",\"number_of_users\":1,\"license_type\":\"Single\",\"installation_engineer\":\"Aniket Dalvi\",\"remarks\":\"\",\"status\":\"active\",\"updated_at\":\"2026-09-03 17:23:18\",\"created_at\":\"2026-09-03 17:23:18\"}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-03 11:53:18'),
(67, 1, 'login', 'auth', 1, NULL, NULL, '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-04 05:26:24'),
(68, 1, 'create', 'role_master', 7, NULL, '{\"role_name\":\"User\",\"role_description\":\"\",\"is_system\":0}', '::1', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36', '2026-09-04 12:11:17');

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

--
-- Table structure for table `ai_conversations`
--

CREATE TABLE `ai_conversations` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `response` text NOT NULL,
  `action_type` varchar(50) DEFAULT 'chat',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_conversations`
--

INSERT INTO `ai_conversations` (`id`, `user_id`, `message`, `response`, `action_type`, `created_at`) VALUES
(1, 1, 'hello', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 11:49:18'),
(2, 1, 'hello', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 11:50:24'),
(3, 1, 'hello', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 12:02:29'),
(4, 1, 'hello', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 12:09:11'),
(5, 1, 'Check pending payments', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 12:14:31'),
(6, 1, 'hello', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 12:15:46'),
(7, 1, 'Check AMC renewals', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 12:22:18'),
(8, 1, 'Check AMC renewals', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 12:22:23'),
(9, 1, 'Check AMC renewals', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 12:32:29'),
(10, 1, 'Check AMC renewals', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 12:32:40'),
(11, 1, 'List all software', 'Fetching list of list...', 'list_records', '2026-09-04 12:33:15'),
(12, 1, 'List all invoices', 'Fetching list of list...', 'list_records', '2026-09-04 12:33:53'),
(13, 1, 'List all customers', 'Fetching list of list...', 'list_records', '2026-09-04 12:34:38'),
(14, 1, 'List all invoices', 'Fetching list of list...', 'list_records', '2026-09-04 12:34:54'),
(15, 1, 'Check pending payments', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 15:07:40'),
(16, 1, 'hi', 'Hello! 👋 I\'m your AMC Assistant. I can help you:\n\n• Create/update/delete AMC contracts\n• Create invoices and bills\n• Manage customers and software\n• Check payment and renewal status\n• Get notifications and reminders\n\nJust tell me what you need!', 'greet', '2026-09-04 15:14:42'),
(17, 1, 'Check payment and renewal status', 'Checking for pending payments and renewals... I can look into:\n• Overdue payments\n• Upcoming AMC expiries\n• Pending invoices\n\nI\'ll pull up the latest notifications.', 'check_notifications', '2026-09-04 15:15:04'),
(18, 1, 'Upcoming AMC expiries', 'I understand. I can help you with AMC management, billing, and notifications. Try asking me to:\n• \"Create AMC for Customer X\"\n• \"Check pending payments\"\n• \"List all invoices\"\n• \"Generate invoice for Customer Y\"\n• \"Check AMC renewals\"', 'chat', '2026-09-04 15:15:24'),
(19, 1, '\"Create AMC for Customer X', 'To create an AMC for X with the software, I\'ll need:\n• Customer name\n• Software name\n• Start and end dates\n• Amount\n\nPlease provide these details and I\'ll create it for you.', 'create_amc', '2026-09-04 15:16:15');

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

--
-- Table structure for table `amc_master`
--

CREATE TABLE `amc_master` (
  `id` int(11) NOT NULL,
  `amc_number` varchar(20) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `software_id` int(11) NOT NULL,
  `amc_type` enum('comprehensive','non_comprehensive','support_only','custom') NOT NULL DEFAULT 'comprehensive',
  `amc_type_label` varchar(100) DEFAULT NULL,
  `amc_frequency` enum('monthly','quarterly','half_yearly','yearly','custom') NOT NULL DEFAULT 'yearly',
  `amc_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `gst_rate` decimal(5,2) NOT NULL DEFAULT 18.00,
  `gst_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `billing_cycle` varchar(50) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `service_visits` int(11) NOT NULL DEFAULT 0,
  `support_hours` varchar(50) DEFAULT NULL,
  `response_time` varchar(100) DEFAULT NULL,
  `priority` enum('low','medium','high','critical') NOT NULL DEFAULT 'medium',
  `auto_renewal` tinyint(1) NOT NULL DEFAULT 0,
  `agreement_pdf` varchar(255) DEFAULT NULL,
  `status` enum('active','expired','cancelled','pending') NOT NULL DEFAULT 'pending',
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amc_master`
--

INSERT INTO `amc_master` (`id`, `amc_number`, `customer_id`, `software_id`, `amc_type`, `amc_type_label`, `amc_frequency`, `amc_amount`, `gst_rate`, `gst_amount`, `discount`, `net_amount`, `start_date`, `end_date`, `renewal_date`, `billing_cycle`, `payment_terms`, `service_visits`, `support_hours`, `response_time`, `priority`, `auto_renewal`, `agreement_pdf`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'AMC-00001', 1, 1, 'custom', 'Custom', 'quarterly', 7812.00, 18.00, 1406.16, 0.00, 9218.16, '2026-03-01', '2027-04-01', '2027-03-31', 'Quaterly', '30', 0, '10 AM- 6PM', '8hrs', 'medium', 1, NULL, 'active', 1, '2026-07-19 10:45:18', '2026-07-19 11:48:27'),
(2, 'AMC-00002', 1, 2, 'custom', 'Custom', 'quarterly', 7080.00, 18.00, 1274.40, 0.00, 8354.40, '2026-04-01', '2027-03-31', '2027-03-31', 'Quterly', '30', 0, '', NULL, 'medium', 0, NULL, 'active', 1, '2026-07-19 10:48:09', '2026-07-19 11:12:19'),
(3, 'AMC-00003', 1, 3, 'custom', '', 'quarterly', 6150.00, 18.00, 1107.00, 0.00, 7257.00, '2026-04-01', '2027-03-31', '2027-03-31', '', '', 0, '', NULL, 'medium', 0, NULL, 'active', 1, '2026-07-19 10:59:28', '2026-07-19 11:13:36'),
(4, 'AMC-00004', 1, 1, 'custom', 'Custom', 'quarterly', 7812.50, 18.00, 1406.25, 0.00, 9218.75, '2026-04-01', '2027-03-31', '2027-03-31', 'Quaterly', '30', 0, '10 AM - 6 PM', '24hrs', 'medium', 1, NULL, 'active', 1, '2026-07-19 11:07:48', '2026-07-19 11:07:48'),
(5, 'AMC-00005', 3, 4, 'support_only', '', 'yearly', 2500.00, 18.00, 450.00, 0.00, 2950.00, '2026-04-01', '2027-03-30', '2027-03-01', 'Yearly', 'Valid For 30 Days', 0, '', NULL, 'medium', 1, NULL, 'active', 1, '2026-07-30 07:27:16', '2026-07-30 07:27:16'),
(6, 'AMC-00006', 2, 5, 'support_only', '', 'quarterly', 19000.00, 18.00, 3420.00, 0.00, 22420.00, '2026-03-01', '2027-02-28', '2027-03-01', 'Quaterly', 'Net 15 Days', 0, '', NULL, 'medium', 1, NULL, 'active', 1, '2026-09-01 12:57:35', '2026-09-02 11:49:52');

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

--
-- Table structure for table `amc_renewal_history`
--

CREATE TABLE `amc_renewal_history` (
  `id` int(11) NOT NULL,
  `old_amc_id` int(11) NOT NULL,
  `new_amc_id` int(11) NOT NULL,
  `renewal_date` date NOT NULL,
  `remarks` text DEFAULT NULL,
  `renewed_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `amc_seq`
--

CREATE TABLE `amc_seq` (
  `id` int(11) NOT NULL,
  `prefix` varchar(10) NOT NULL DEFAULT 'AMC-',
  `current_value` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `amc_seq`
--

INSERT INTO `amc_seq` (`id`, `prefix`, `current_value`, `created_at`, `updated_at`) VALUES
(1, 'AMC-', 0, '2026-07-17 18:59:17', '2026-07-17 18:59:17');

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

--
-- Table structure for table `company_master`
--

CREATE TABLE `company_master` (
  `id` int(11) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `gst_number` varchar(20) DEFAULT NULL,
  `pan` varchar(20) DEFAULT NULL,
  `cin` varchar(30) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_account` varchar(50) DEFAULT NULL,
  `bank_ifsc` varchar(20) DEFAULT NULL,
  `upi_id` varchar(100) DEFAULT NULL,
  `upi_qr` varchar(255) DEFAULT NULL,
  `terms_conditions` text DEFAULT NULL,
  `invoice_footer` text DEFAULT NULL,
  `signature_image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `pin_code` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_master`
--

INSERT INTO `company_master` (`id`, `company_name`, `logo`, `address`, `gst_number`, `pan`, `cin`, `mobile`, `email`, `website`, `bank_name`, `bank_account`, `bank_ifsc`, `upi_id`, `upi_qr`, `terms_conditions`, `invoice_footer`, `signature_image`, `status`, `created_at`, `updated_at`, `city`, `state`, `country`, `pin_code`) VALUES
(1, 'I-Net Infotech', 'company/logoe870f2bccbdb2e69348e6861b2ff4d2d.png', 'Shiv Sagar building, 102, khodaram bagh road, behind Don Bosco school, Sainath Nagar, Boisar, Maharashtra 401501', '27AAFFI1991R1ZM', '', '', '09175418884', 'admin@sbitinfo.in', 'https://inetinfo.in/', 'Kotak Mahindra Bank', '6111613955', 'KKBK0000672', '', NULL, '1.Thanks for your business.\r\n2.This invoice is generated using I-Net Inventory', '', NULL, 1, '2026-07-18 18:50:55', '2026-09-03 11:26:54', 'Palghar', 'Maharashtra', 'India', '401501');

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

--
-- Table structure for table `customer_id_seq`
--

CREATE TABLE `customer_id_seq` (
  `id` int(11) NOT NULL,
  `prefix` varchar(10) NOT NULL DEFAULT 'CUS-',
  `current_value` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_id_seq`
--

INSERT INTO `customer_id_seq` (`id`, `prefix`, `current_value`, `created_at`, `updated_at`) VALUES
(1, 'CUS-', 0, '2026-07-17 18:59:17', '2026-07-17 18:59:17');

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

--
-- Table structure for table `customer_master`
--

CREATE TABLE `customer_master` (
  `id` int(11) NOT NULL,
  `customer_id` varchar(20) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `contact_person` varchar(150) DEFAULT NULL,
  `designation` varchar(100) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `alternate_mobile` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `gst_number` varchar(20) DEFAULT NULL,
  `pan` varchar(20) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT 'India',
  `pin_code` varchar(10) DEFAULT NULL,
  `customer_type` varchar(50) DEFAULT NULL,
  `industry` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `agreement_copy` varchar(255) DEFAULT NULL,
  `pan_copy` varchar(255) DEFAULT NULL,
  `gst_certificate` varchar(255) DEFAULT NULL,
  `other_documents` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_master`
--

INSERT INTO `customer_master` (`id`, `customer_id`, `company_name`, `contact_person`, `designation`, `mobile`, `alternate_mobile`, `email`, `website`, `gst_number`, `pan`, `address`, `city`, `state`, `country`, `pin_code`, `customer_type`, `industry`, `notes`, `logo`, `agreement_copy`, `pan_copy`, `gst_certificate`, `other_documents`, `status`, `created_at`, `updated_at`) VALUES
(1, 'CUS-01001', 'Alchemie Gases and Chemical Pvt. Ltd.', 'Sushma Patil', 'Director', '9619490322', '', 'tarapur@alchemiegases.com', 'https://www.alchemiegases.com/', '27AABCA4554F1ZW', '', 'Plot No. T-112, M.I.D.C., Tarapur, Dist. Palghar-401 506. (Maharashtra), India.', 'Palghar', 'Maharashtra', 'India', '401501', 'Enterprise', 'Pharmaceutical', '', NULL, NULL, NULL, NULL, NULL, 'active', '2026-07-19 07:22:00', '2026-07-21 17:04:14'),
(2, 'CUS-01002', 'Autocal Solution Pvt. Ltd.', 'Kiran Dalvi', '', '09890624789', '', 'kiran.a.dalvi2010@gmail.com', '', '27AAGCA9480PIZV', '', 'Unit No.4, Ruby Industrial estate, PCS ltd, Navghar,', 'Vasai(E)', 'Maharashtra', 'India', '401 210', 'Enterprise', 'Other', '', NULL, NULL, NULL, NULL, NULL, 'active', '2026-07-20 11:34:47', '2026-07-20 11:34:47'),
(3, 'CUS-01003', 'kusmo', 'Nilesh Darade', 'Manager', '9322314166', '9311066000', 'kusmochemicals@yahoo.co.in', 'www.kusmochemicals.com', '', '', 'Unit No. 7-8, Kedia Compound, Wada Road,\r\nShelar Village, Bhiwandi, Thane-421 302, Maharashtra, India', 'Thane', 'Maharashtra', 'India', '421 302', '', 'Pharmaceutical', '', NULL, NULL, NULL, NULL, NULL, 'active', '2026-07-30 06:31:27', '2026-07-30 06:31:27'),
(4, 'CUS-01004', 'Adeshwar Meditex Limited', 'Omkar Raut', '', '7709176484', '', 'adeshwarmedi@gmail.com', 'https://adeshwarmeditex.com/', '27AAGCA2560A1Z7', '', '17/18, Dewan &amp; Sons, Udyog Nagar, Palghar west, Pin- 401404\r\nMaharashtra – INDIA', 'Palghar', 'Maharashtra', 'India', '401501', 'Enterprise', 'Pharmaceutical', '', NULL, NULL, NULL, NULL, NULL, 'active', '2026-09-03 11:46:58', '2026-09-03 11:46:58');

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

--
-- Table structure for table `customer_software`
--

CREATE TABLE `customer_software` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `software_id` int(11) NOT NULL,
  `license_number` varchar(100) DEFAULT NULL,
  `activation_date` date DEFAULT NULL,
  `installation_date` date DEFAULT NULL,
  `warranty_start` date DEFAULT NULL,
  `warranty_end` date DEFAULT NULL,
  `amc_start` date DEFAULT NULL,
  `amc_end` date DEFAULT NULL,
  `number_of_users` int(11) DEFAULT 1,
  `license_type` varchar(50) DEFAULT NULL,
  `installation_engineer` varchar(150) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `status` enum('active','inactive','expired') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_software`
--

INSERT INTO `customer_software` (`id`, `customer_id`, `software_id`, `license_number`, `activation_date`, `installation_date`, `warranty_start`, `warranty_end`, `amc_start`, `amc_end`, `number_of_users`, `license_type`, `installation_engineer`, `remarks`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'INET-SW001-01', '2020-07-27', '2020-07-10', NULL, NULL, '2021-06-19', NULL, 20, 'Single', 'Aniket Dalvi', '', 'active', '2026-07-19 15:21:37', '2026-07-19 15:21:37'),
(2, 4, 6, '', '2026-06-25', '2023-05-12', '2026-06-25', '2027-06-14', '2026-06-15', '2027-06-14', 1, 'Single', 'Aniket Dalvi', '', 'active', '2026-09-03 11:53:18', '2026-09-03 11:53:18');

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

--
-- Table structure for table `document_master`
--

CREATE TABLE `document_master` (
  `id` int(11) NOT NULL,
  `document_type` enum('agreement','invoice','receipt','license','support','other') NOT NULL DEFAULT 'other',
  `entity_type` varchar(50) NOT NULL,
  `entity_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `file_size` int(11) DEFAULT NULL,
  `mime_type` varchar(100) DEFAULT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email_logs`
--

CREATE TABLE `email_logs` (
  `id` int(11) NOT NULL,
  `to_email` varchar(150) NOT NULL,
  `from_email` varchar(150) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `status` enum('sent','failed','queued') NOT NULL DEFAULT 'queued',
  `error_message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `invoice_master`
--

CREATE TABLE `invoice_master` (
  `id` int(11) NOT NULL,
  `invoice_number` varchar(20) NOT NULL,
  `amc_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `invoice_date` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `gst_rate` decimal(5,2) NOT NULL DEFAULT 18.00,
  `gst_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `balance_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('pending','partial','paid','overdue') NOT NULL DEFAULT 'pending',
  `hsn_code` varchar(20) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `terms` text DEFAULT NULL,
  `digital_signature` varchar(255) DEFAULT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `status` enum('draft','sent','paid','overdue','cancelled') NOT NULL DEFAULT 'draft',
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_master`
--

INSERT INTO `invoice_master` (`id`, `invoice_number`, `amc_id`, `customer_id`, `invoice_date`, `due_date`, `subtotal`, `gst_rate`, `gst_amount`, `discount`, `total_amount`, `paid_amount`, `balance_amount`, `payment_status`, `hsn_code`, `description`, `terms`, `digital_signature`, `qr_code`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'INV-00001', 1, 1, '2026-03-01', '2026-03-31', 7812.00, 18.00, 1406.16, 0.00, 9218.16, 9218.00, 0.16, 'partial', '998314', '', 'Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.', NULL, 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=1-AMC-00001-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.', 'draft', 1, '2026-07-19 11:34:56', '2026-07-19 11:38:59'),
(2, 'INV-00002', 3, 1, '2026-07-19', '2026-08-18', 6150.00, 18.00, 1107.00, 0.00, 7257.00, 0.00, 7257.00, 'pending', '998314', 'Service Period - 1-APR-2026 To 31-JUN-2026', 'Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.', NULL, 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=1-AMC-00003-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.', 'draft', 1, '2026-07-19 16:24:35', '2026-07-19 16:24:35'),
(3, 'INV-00003', 4, 1, '2026-07-19', '2026-08-18', 7812.50, 18.00, 1406.25, 0.00, 9218.75, 0.00, 9218.75, 'pending', '998314', 'AMC - AMC-00004 (Alchemie Gases &amp; Chemical Pvt. Ltd.)', 'Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.', NULL, 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.-AMC-00004', 'draft', 1, '2026-07-19 16:31:44', '2026-07-19 16:31:44'),
(4, 'INV-00004', 2, 1, '2026-07-20', '2026-08-19', 7080.00, 18.00, 1274.40, 0.00, 8354.40, 0.00, 8354.40, 'pending', '998314', '', 'Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.', NULL, 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=1-AMC-00002-Alchemie+Gases+%26amp%3B+Chemical+Pvt.+Ltd.', 'draft', 1, '2026-07-20 10:31:56', '2026-07-20 10:31:56'),
(5, 'INV-00005', 6, 2, '2026-09-01', '2026-09-24', 19000.00, 18.00, 3420.00, 0.00, 22420.00, 0.00, 22420.00, 'pending', '998314', 'Billing Of 01-July-2026 - 28-Sep-2026', 'Payment is due within 30 days of invoice date. Late payments will incur a 1.5% monthly interest charge.', NULL, 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=2-AMC-00006-Autocal+Solution+Pvt.+Ltd.', 'draft', 1, '2026-09-01 12:58:14', '2026-09-03 11:22:07');

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

--
-- Table structure for table `invoice_seq`
--

CREATE TABLE `invoice_seq` (
  `id` int(11) NOT NULL,
  `prefix` varchar(10) NOT NULL DEFAULT 'INV-',
  `current_value` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_seq`
--

INSERT INTO `invoice_seq` (`id`, `prefix`, `current_value`, `created_at`, `updated_at`) VALUES
(1, 'INV-', 0, '2026-07-17 18:59:17', '2026-07-17 18:59:17');

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

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `company` varchar(200) DEFAULT NULL,
  `service` varchar(100) NOT NULL,
  `budget` varchar(50) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` enum('new','contacted','qualified','converted','lost') DEFAULT 'new',
  `notes` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `notification_master`
--

CREATE TABLE `notification_master` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `notification_type` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `link` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_master`
--

CREATE TABLE `payment_master` (
  `id` int(11) NOT NULL,
  `payment_id` varchar(20) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `invoice_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `received_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `pending_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `payment_date` date DEFAULT NULL,
  `payment_mode` enum('cash','bank_transfer','cheque','upi','card','online') DEFAULT NULL,
  `reference_number` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `cheque_number` varchar(50) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `receipt_number` varchar(50) DEFAULT NULL,
  `status` enum('pending','completed','failed','refunded') NOT NULL DEFAULT 'completed',
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_master`
--

INSERT INTO `payment_master` (`id`, `payment_id`, `invoice_id`, `customer_id`, `invoice_amount`, `received_amount`, `pending_amount`, `payment_date`, `payment_mode`, `reference_number`, `transaction_id`, `bank_name`, `cheque_number`, `cheque_date`, `remarks`, `receipt_number`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'PAY-00001', 1, 1, 9218.16, 9218.00, 0.16, '2026-04-05', 'bank_transfer', '', '', '', '', '0000-00-00', '', 'RCT-20260719-00001', 'completed', 1, '2026-07-19 11:38:59', '2026-07-19 11:38:59');

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

--
-- Table structure for table `payment_receipts`
--

CREATE TABLE `payment_receipts` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `receipt_number` varchar(50) NOT NULL,
  `receipt_date` date NOT NULL,
  `amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `pdf_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_receipts`
--

INSERT INTO `payment_receipts` (`id`, `payment_id`, `receipt_number`, `receipt_date`, `amount`, `pdf_path`, `created_at`) VALUES
(1, 1, 'RCT-20260719-00001', '2026-04-05', 9218.00, NULL, '2026-07-19 11:38:59');

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

--
-- Table structure for table `payment_seq`
--

CREATE TABLE `payment_seq` (
  `id` int(11) NOT NULL,
  `prefix` varchar(10) NOT NULL DEFAULT 'PAY-',
  `current_value` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_seq`
--

INSERT INTO `payment_seq` (`id`, `prefix`, `current_value`, `created_at`, `updated_at`) VALUES
(1, 'PAY-', 0, '2026-07-17 18:59:17', '2026-07-17 18:59:17');

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

--
-- Table structure for table `permission_master`
--

CREATE TABLE `permission_master` (
  `permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `module` varchar(100) NOT NULL,
  `can_view` tinyint(1) NOT NULL DEFAULT 0,
  `can_create` tinyint(1) NOT NULL DEFAULT 0,
  `can_edit` tinyint(1) NOT NULL DEFAULT 0,
  `can_delete` tinyint(1) NOT NULL DEFAULT 0,
  `can_export` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_master`
--

INSERT INTO `permission_master` (`permission_id`, `role_id`, `module`, `can_view`, `can_create`, `can_edit`, `can_delete`, `can_export`, `created_at`) VALUES
(1, 1, 'dashboard', 1, 0, 0, 0, 0, '2026-07-17 18:59:18'),
(2, 1, 'customers', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(3, 1, 'software', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(4, 1, 'customer_software', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(5, 1, 'amc', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(6, 1, 'invoices', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(7, 1, 'payments', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(8, 1, 'receipts', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(9, 1, 'reminders', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(10, 1, 'documents', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(11, 1, 'users', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(12, 1, 'roles', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(13, 1, 'permissions', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(14, 1, 'settings', 1, 1, 1, 0, 0, '2026-07-17 18:59:18'),
(15, 1, 'reports', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(16, 1, 'activity_logs', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(17, 1, 'email_logs', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(18, 1, 'sms_logs', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(19, 1, 'whatsapp_logs', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(20, 1, 'notifications', 1, 1, 1, 1, 0, '2026-07-17 18:59:18'),
(21, 1, 'company', 1, 1, 1, 0, 0, '2026-07-17 18:59:18'),
(22, 1, 'amc_renewals', 1, 1, 1, 1, 1, '2026-07-17 18:59:18'),
(23, 1, 'reports_customer', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(24, 1, 'reports_amc', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(25, 1, 'reports_invoice', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(26, 1, 'reports_payment', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(27, 1, 'reports_revenue', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(28, 1, 'reports_expiry', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(29, 1, 'reports_due', 1, 0, 0, 0, 1, '2026-07-17 18:59:18'),
(30, 1, 'backup', 1, 1, 0, 1, 0, '2026-07-17 18:59:18');

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

--
-- Table structure for table `reminder_logs`
--

CREATE TABLE `reminder_logs` (
  `id` int(11) NOT NULL,
  `reminder_id` int(11) NOT NULL,
  `channel` enum('email','sms','whatsapp') NOT NULL,
  `status` enum('sent','failed') NOT NULL,
  `response` text DEFAULT NULL,
  `sent_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reminder_master`
--

CREATE TABLE `reminder_master` (
  `id` int(11) NOT NULL,
  `reminder_type` enum('amc_expiry','invoice_due','payment_due') NOT NULL,
  `entity_id` int(11) NOT NULL,
  `entity_type` varchar(50) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `reminder_date` date NOT NULL,
  `reminder_status` enum('pending','sent','failed') NOT NULL DEFAULT 'pending',
  `channel` enum('email','sms','whatsapp','all') NOT NULL DEFAULT 'all',
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_master`
--

CREATE TABLE `role_master` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(100) NOT NULL,
  `role_description` varchar(255) DEFAULT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_master`
--

INSERT INTO `role_master` (`role_id`, `role_name`, `role_description`, `is_system`, `created_at`) VALUES
(1, 'Super Admin', 'Full system access with all permissions', 1, '2026-07-17 18:59:18'),
(2, 'Admin', 'Administrative access to most modules', 1, '2026-07-17 18:59:18'),
(3, 'Accounts', 'Access to invoices, payments, and financial modules', 1, '2026-07-17 18:59:18'),
(4, 'Sales', 'Access to customers, AMC, and sales-related modules', 1, '2026-07-17 18:59:18'),
(5, 'Support Engineer', 'Access to support tickets and customer software', 1, '2026-07-17 18:59:18'),
(6, 'Viewer', 'Read-only access to all modules', 1, '2026-07-17 18:59:18'),
(7, 'User', '', 0, '2026-09-04 12:11:17');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_group` varchar(50) DEFAULT NULL,
  `setting_type` varchar(20) NOT NULL DEFAULT 'text',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `sms_logs`
--

CREATE TABLE `sms_logs` (
  `id` int(11) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `message` text NOT NULL,
  `status` enum('sent','failed','queued') NOT NULL DEFAULT 'queued',
  `response` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `software_master`
--

CREATE TABLE `software_master` (
  `id` int(11) NOT NULL,
  `software_code` varchar(50) NOT NULL,
  `software_name` varchar(255) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `version` varchar(50) DEFAULT NULL,
  `platform` varchar(100) DEFAULT NULL,
  `technology` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `license_type` varchar(50) DEFAULT NULL,
  `annual_amc_amount` decimal(12,2) DEFAULT 0.00,
  `monthly_amc_amount` decimal(12,2) DEFAULT 0.00,
  `quarterly_amc_amount` decimal(12,2) DEFAULT 0.00,
  `half_yearly_amc_amount` decimal(12,2) DEFAULT 0.00,
  `custom_amc_amount` decimal(12,2) DEFAULT 0.00,
  `installation_charge` decimal(12,2) DEFAULT 0.00,
  `support_charge` decimal(12,2) DEFAULT 0.00,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `software_master`
--

INSERT INTO `software_master` (`id`, `software_code`, `software_name`, `category`, `version`, `platform`, `technology`, `description`, `license_type`, `annual_amc_amount`, `monthly_amc_amount`, `quarterly_amc_amount`, `half_yearly_amc_amount`, `custom_amc_amount`, `installation_charge`, `support_charge`, `status`, `created_at`, `updated_at`) VALUES
(1, 'SW001', 'Cylinder tracking and Inventory Management System', 'Custom', '1.6', 'Linux', 'PHP,Mysql,Jquery,HTML', 'Comprehensive ERP solution for tracking industrial gas cylinders across 50+ distribution centers, also generating auto billing and reminders.', 'Single', 0.00, 0.00, 7812.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-07-19 07:27:04', '2026-07-19 07:27:04'),
(2, 'SW002', 'Gas Manufacturing Process System (MPS)', 'Custom', '1.5', 'Linux', 'PHP,Mysql,HTML', 'GAS Manufacturing Details', 'Single', 0.00, 0.00, 7080.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-07-19 07:29:40', '2026-07-19 07:29:40'),
(3, 'SW003', 'GAS CRM(Customer Managment System)', 'Custom', '1.3', 'Linux', 'Php,Mysql,HTML', 'CRM', 'Single', 0.00, 0.00, 6150.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-07-19 10:03:59', '2026-07-19 10:03:59'),
(4, 'WS-01', 'Website', 'Web', '1.2', 'Linux', 'PHP,HTML', 'Kusmochemical website', 'Single', 2500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-07-30 06:57:59', '2026-07-30 06:57:59'),
(5, 'SW-004', 'Calibration Management System', 'Custom', '1.2', 'Linux', 'PHP,Mysql', 'Calibration certificate creation, instrument inventory managemnt', 'Open Source', 0.00, 0.00, 19000.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-09-01 12:54:36', '2026-09-03 08:44:56'),
(6, 'WS-02', 'Web Hosting', 'Web', '1.1', 'Linux', 'PHP,HTML,Wordpress', '', 'Single', 5000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2026-09-03 11:49:28', '2026-09-03 11:49:28');

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

--
-- Table structure for table `whatsapp_logs`
--

CREATE TABLE `whatsapp_logs` (
  `id` int(11) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `message` text NOT NULL,
  `status` enum('sent','failed','queued') NOT NULL DEFAULT 'queued',
  `response` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `idx_alog_user_id` (`user_id`),
  ADD KEY `idx_alog_module` (`module`),
  ADD KEY `idx_alog_action` (`action`),
  ADD KEY `idx_alog_record_id` (`record_id`),
  ADD KEY `idx_alog_created_at` (`created_at`);

--
-- Indexes for table `ai_conversations`
--
ALTER TABLE `ai_conversations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_action_type` (`action_type`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `amc_master`
--
ALTER TABLE `amc_master`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_amc_number` (`amc_number`),
  ADD KEY `idx_amc_customer_id` (`customer_id`),
  ADD KEY `idx_amc_software_id` (`software_id`),
  ADD KEY `idx_amc_status` (`status`),
  ADD KEY `idx_amc_type` (`amc_type`),
  ADD KEY `idx_amc_frequency` (`amc_frequency`),
  ADD KEY `idx_amc_start_date` (`start_date`),
  ADD KEY `idx_amc_end_date` (`end_date`),
  ADD KEY `idx_amc_renewal_date` (`renewal_date`),
  ADD KEY `idx_amc_priority` (`priority`),
  ADD KEY `idx_amc_created_by` (`created_by`);

--
-- Indexes for table `amc_renewal_history`
--
ALTER TABLE `amc_renewal_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_renewal_old_amc` (`old_amc_id`),
  ADD KEY `idx_renewal_new_amc` (`new_amc_id`),
  ADD KEY `idx_renewal_date` (`renewal_date`),
  ADD KEY `idx_renewal_renewed_by` (`renewed_by`);

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

--
-- Indexes for table `company_master`
--
ALTER TABLE `company_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_company_gst` (`gst_number`),
  ADD KEY `idx_company_pan` (`pan`),
  ADD KEY `idx_company_status` (`status`);

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

--
-- Indexes for table `customer_master`
--
ALTER TABLE `customer_master`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_customer_id` (`customer_id`),
  ADD KEY `idx_customer_company` (`company_name`),
  ADD KEY `idx_customer_contact` (`contact_person`),
  ADD KEY `idx_customer_mobile` (`mobile`),
  ADD KEY `idx_customer_email` (`email`),
  ADD KEY `idx_customer_gst` (`gst_number`),
  ADD KEY `idx_customer_pan` (`pan`),
  ADD KEY `idx_customer_status` (`status`),
  ADD KEY `idx_customer_city` (`city`),
  ADD KEY `idx_customer_state` (`state`),
  ADD KEY `idx_customer_type` (`customer_type`);

--
-- Indexes for table `customer_software`
--
ALTER TABLE `customer_software`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cs_customer_id` (`customer_id`),
  ADD KEY `idx_cs_software_id` (`software_id`),
  ADD KEY `idx_cs_status` (`status`),
  ADD KEY `idx_cs_amc_start` (`amc_start`),
  ADD KEY `idx_cs_amc_end` (`amc_end`);

--
-- Indexes for table `document_master`
--
ALTER TABLE `document_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_doc_type` (`document_type`),
  ADD KEY `idx_doc_entity` (`entity_type`,`entity_id`),
  ADD KEY `idx_doc_customer_id` (`customer_id`),
  ADD KEY `idx_doc_uploaded_by` (`uploaded_by`);

--
-- Indexes for table `email_logs`
--
ALTER TABLE `email_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_elog_to` (`to_email`),
  ADD KEY `idx_elog_status` (`status`),
  ADD KEY `idx_elog_created_at` (`created_at`);

--
-- Indexes for table `invoice_master`
--
ALTER TABLE `invoice_master`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_invoice_number` (`invoice_number`),
  ADD KEY `idx_inv_amc_id` (`amc_id`),
  ADD KEY `idx_inv_customer_id` (`customer_id`),
  ADD KEY `idx_inv_invoice_date` (`invoice_date`),
  ADD KEY `idx_inv_due_date` (`due_date`),
  ADD KEY `idx_inv_status` (`status`),
  ADD KEY `idx_inv_payment_status` (`payment_status`),
  ADD KEY `idx_inv_created_by` (`created_by`);

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

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `notification_master`
--
ALTER TABLE `notification_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_notif_user_id` (`user_id`),
  ADD KEY `idx_notif_type` (`notification_type`),
  ADD KEY `idx_notif_read` (`is_read`),
  ADD KEY `idx_notif_created_at` (`created_at`);

--
-- Indexes for table `payment_master`
--
ALTER TABLE `payment_master`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_payment_id` (`payment_id`),
  ADD KEY `idx_pay_invoice_id` (`invoice_id`),
  ADD KEY `idx_pay_customer_id` (`customer_id`),
  ADD KEY `idx_pay_payment_date` (`payment_date`),
  ADD KEY `idx_pay_status` (`status`),
  ADD KEY `idx_pay_mode` (`payment_mode`),
  ADD KEY `idx_pay_created_by` (`created_by`);

--
-- Indexes for table `payment_receipts`
--
ALTER TABLE `payment_receipts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_receipt_payment_id` (`payment_id`),
  ADD KEY `idx_receipt_number` (`receipt_number`),
  ADD KEY `idx_receipt_date` (`receipt_date`);

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

--
-- Indexes for table `permission_master`
--
ALTER TABLE `permission_master`
  ADD PRIMARY KEY (`permission_id`),
  ADD KEY `idx_permission_role_id` (`role_id`),
  ADD KEY `idx_permission_module` (`module`);

--
-- Indexes for table `reminder_logs`
--
ALTER TABLE `reminder_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rlog_reminder_id` (`reminder_id`),
  ADD KEY `idx_rlog_channel` (`channel`),
  ADD KEY `idx_rlog_status` (`status`);

--
-- Indexes for table `reminder_master`
--
ALTER TABLE `reminder_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_reminder_type` (`reminder_type`),
  ADD KEY `idx_reminder_entity` (`entity_type`,`entity_id`),
  ADD KEY `idx_reminder_customer_id` (`customer_id`),
  ADD KEY `idx_reminder_date` (`reminder_date`),
  ADD KEY `idx_reminder_status` (`reminder_status`);

--
-- Indexes for table `role_master`
--
ALTER TABLE `role_master`
  ADD PRIMARY KEY (`role_id`),
  ADD UNIQUE KEY `uk_role_name` (`role_name`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_setting_key` (`setting_key`),
  ADD KEY `idx_setting_group` (`setting_group`);

--
-- Indexes for table `sms_logs`
--
ALTER TABLE `sms_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_smslog_phone` (`phone_number`),
  ADD KEY `idx_smslog_status` (`status`),
  ADD KEY `idx_smslog_created_at` (`created_at`);

--
-- Indexes for table `software_master`
--
ALTER TABLE `software_master`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_software_code` (`software_code`),
  ADD KEY `idx_software_name` (`software_name`),
  ADD KEY `idx_software_category` (`category`),
  ADD KEY `idx_software_status` (`status`);

--
-- Indexes for table `whatsapp_logs`
--
ALTER TABLE `whatsapp_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_walog_phone` (`phone_number`),
  ADD KEY `idx_walog_status` (`status`),
  ADD KEY `idx_walog_created_at` (`created_at`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

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

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

--
-- AUTO_INCREMENT for table `amc_renewal_history`
--
ALTER TABLE `amc_renewal_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `document_master`
--
ALTER TABLE `document_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_logs`
--
ALTER TABLE `email_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_master`
--
ALTER TABLE `notification_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `reminder_logs`
--
ALTER TABLE `reminder_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reminder_master`
--
ALTER TABLE `reminder_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `sms_logs`
--
ALTER TABLE `sms_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `whatsapp_logs`
--
ALTER TABLE `whatsapp_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `amc_master`
--
ALTER TABLE `amc_master`
  ADD CONSTRAINT `fk_amc_created_by` FOREIGN KEY (`created_by`) REFERENCES `user_master` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_amc_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_amc_software` FOREIGN KEY (`software_id`) REFERENCES `software_master` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `amc_renewal_history`
--
ALTER TABLE `amc_renewal_history`
  ADD CONSTRAINT `fk_renewal_new_amc` FOREIGN KEY (`new_amc_id`) REFERENCES `amc_master` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_renewal_old_amc` FOREIGN KEY (`old_amc_id`) REFERENCES `amc_master` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_renewal_user` FOREIGN KEY (`renewed_by`) REFERENCES `user_master` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `customer_software`
--
ALTER TABLE `customer_software`
  ADD CONSTRAINT `fk_cs_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_cs_software` FOREIGN KEY (`software_id`) REFERENCES `software_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `document_master`
--
ALTER TABLE `document_master`
  ADD CONSTRAINT `fk_doc_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_doc_uploaded_by` FOREIGN KEY (`uploaded_by`) REFERENCES `user_master` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `invoice_master`
--
ALTER TABLE `invoice_master`
  ADD CONSTRAINT `fk_inv_amc` FOREIGN KEY (`amc_id`) REFERENCES `amc_master` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_inv_created_by` FOREIGN KEY (`created_by`) REFERENCES `user_master` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_inv_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `payment_master`
--
ALTER TABLE `payment_master`
  ADD CONSTRAINT `fk_pay_created_by` FOREIGN KEY (`created_by`) REFERENCES `user_master` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_pay_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_pay_invoice` FOREIGN KEY (`invoice_id`) REFERENCES `invoice_master` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `payment_receipts`
--
ALTER TABLE `payment_receipts`
  ADD CONSTRAINT `fk_receipt_payment` FOREIGN KEY (`payment_id`) REFERENCES `payment_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `permission_master`
--
ALTER TABLE `permission_master`
  ADD CONSTRAINT `fk_permission_role` FOREIGN KEY (`role_id`) REFERENCES `role_master` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `reminder_logs`
--
ALTER TABLE `reminder_logs`
  ADD CONSTRAINT `fk_rlog_reminder` FOREIGN KEY (`reminder_id`) REFERENCES `reminder_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `reminder_master`
--
ALTER TABLE `reminder_master`
  ADD CONSTRAINT `fk_reminder_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

