-- MySQL dump 10.13  Distrib 8.0.44, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: dayloan
-- ------------------------------------------------------
-- Server version	8.0.44

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `area` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `main_area` varchar(255) NOT NULL,
  `sub_area` varchar(255) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` VALUES (1,9,'Kumarapalayam','','2025-09-16 11:47:27'),(4,9,'Chennai','','2025-09-22 04:28:00'),(6,9,'thiruppur','','2025-09-22 05:11:41'),(7,15,'Kollampalayam','','2025-11-21 05:35:36'),(8,15,'Gobi','','2025-11-21 05:39:41'),(9,15,'Mollapalayam','','2025-11-21 05:40:11'),(10,15,'Karungalpalayam','','2025-11-21 05:40:21'),(11,15,'P.S.Park','','2025-11-21 05:40:37'),(12,15,'Fire Service','','2025-11-21 05:41:04'),(13,15,'Bus Stand','','2025-11-21 05:41:11'),(14,15,'VOC Park','','2025-11-21 05:41:23');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `collection_agent`
--

DROP TABLE IF EXISTS `collection_agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `collection_agent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile_no` varchar(15) NOT NULL,
  `address` text NOT NULL,
  `aadhar_no` varchar(30) NOT NULL,
  `photo` longblob NOT NULL,
  `report_in` datetime NOT NULL,
  `reporting_time` datetime NOT NULL,
  `status` varchar(100) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `device_token` varchar(255) DEFAULT NULL,
  `device_type` enum('android','ios','web') DEFAULT NULL,
  `auth_token` varchar(255) DEFAULT NULL,
  `token_expires_at` datetime DEFAULT NULL,
  `is_logged_in` tinyint(1) DEFAULT '0',
  `login_attempts` int DEFAULT '0',
  `last_attempt` datetime DEFAULT NULL,
  `line` varchar(300) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_device_id` (`device_id`),
  UNIQUE KEY `unique_auth_token` (`auth_token`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `collection_agent`
--

LOCK TABLES `collection_agent` WRITE;
/*!40000 ALTER TABLE `collection_agent` DISABLE KEYS */;
INSERT INTO `collection_agent` VALUES (5,15,'Raja','8825948300','Erode','882594830012','','2025-12-03 09:00:00','2025-12-03 20:00:00','Active','2025-12-08 08:01:13','device_1765180872668','test_fcm_token_1765180872669','web','ab0f81694f5d48c99d18f08ec21512f946cfa0fe74c7206efd9c73f5da5646f8','2025-12-09 08:01:13',1,0,NULL,'Line 2','2025-12-03 17:31:14');
/*!40000 ALTER TABLE `collection_agent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `collection_agent_otp`
--

DROP TABLE IF EXISTS `collection_agent_otp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `collection_agent_otp` (
  `id` int NOT NULL AUTO_INCREMENT,
  `agent_id` int NOT NULL,
  `mobile_no` varchar(15) NOT NULL,
  `otp` varchar(6) NOT NULL,
  `is_verified` tinyint(1) NOT NULL DEFAULT '0',
  `expires_at` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `mobile_no_idx` (`mobile_no`),
  KEY `expires_at_idx` (`expires_at`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `collection_agent_otp`
--

LOCK TABLES `collection_agent_otp` WRITE;
/*!40000 ALTER TABLE `collection_agent_otp` DISABLE KEYS */;
INSERT INTO `collection_agent_otp` VALUES (31,5,'8825948300','927619',1,'2025-12-08 08:05:58','2025-12-08 08:00:58'),(32,6,'9360500657','200259',0,'2025-12-08 08:11:33','2025-12-08 08:06:33');
/*!40000 ALTER TABLE `collection_agent_otp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company` (
  `com_id` int NOT NULL AUTO_INCREMENT,
  `reg_id` int DEFAULT NULL,
  `com_name` varchar(255) NOT NULL,
  `mob_num` varchar(15) NOT NULL,
  `off_num` varchar(15) DEFAULT NULL,
  `logo` longtext,
  `street` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `district` varchar(100) DEFAULT NULL,
  `pincode` varchar(10) DEFAULT NULL,
  `gst_no` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`com_id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `username` (`user_name`),
  UNIQUE KEY `reg_id` (`reg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company`
--

LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;
INSERT INTO `company` VALUES (9,5,'KanInfoTech','9788777788','1234567890',NULL,'100/4, Perundurai Road','Erode','Erode','638002','1234567890','kaninfotech@gmail.com','admin','123456','2025-09-15 02:58:00'),(15,6,'Nasreen','9360500657','9360500657',NULL,'Erode','Erode','Erode','638012','','nasreen@gmail.com','ayaan','123456','2025-11-21 05:13:25');
/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `cust_name` varchar(255) NOT NULL,
  `cust_mobile` varchar(15) NOT NULL,
  `cust_mobile2` varchar(15) NOT NULL,
  `building_no` varchar(100) NOT NULL,
  `street` varchar(200) NOT NULL,
  `area` varchar(200) NOT NULL,
  `city` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL,
  `pincode` varchar(20) NOT NULL,
  `image` longblob NOT NULL,
  `aadhar_no` varchar(50) NOT NULL,
  `pan_no` varchar(50) NOT NULL,
  `latitude` decimal(10,0) NOT NULL,
  `longitude` decimal(10,0) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` VALUES (1,9,'Ayaan','1234567890','1234567890','Erode','Erode','Kumarapalayam','','','','','1234567890','',0,0,'2025-10-01 13:14:26'),(2,9,'Ayaan1','1234567891','1234567891','Erode','Erode','Kumarapalayam','','','','','1234567891','',0,0,'2025-10-01 13:25:59'),(3,9,'Savi','5645656876','7345346557','Erode','Erode','Kumarapalayam','','','','','456465768678','',0,0,'2025-11-06 09:05:10'),(4,9,'Raja','8825948300','8825948300','Erode','Erode','Chennai','','','','','788259483007','',0,0,'2025-11-18 06:39:22'),(5,9,'Priya','8765427676','8675645467','Erode','Erode','Chennai','','','','','466879352345','',0,0,'2025-11-20 05:05:40'),(6,9,'Varun','8776564534','8767564563','Erode','Erode','Kumarapalayam','','','','','456576978098','',0,0,'2025-11-20 05:17:44'),(7,9,'Vikram','7564537686','9878767564','Erode','Erode','Kumarapalayam','','','','','897867564343','',0,0,'2025-11-20 05:22:11'),(8,15,'Pavithra','5346876764','5346876764','Erode','Erode','Mollapalayam','','','','','534687676476','',0,0,'2025-11-21 05:51:03'),(9,15,'Hari','9879878675','9879786756','Erode','Erode','Mollapalayam','','','','','878675645434','',0,0,'2025-12-03 17:37:03'),(10,15,'Arshaf','9856564546','8979768657','Erode','Erode','Kollampalayam','','','','','768979567545','',0,0,'2025-12-04 06:44:25'),(11,15,'Baby','6787687656','6798789676','Erode','Erode','Gobi','','','','','768768797896','',0,0,'2025-12-04 06:48:50');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deposit_entry`
--

DROP TABLE IF EXISTS `deposit_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deposit_entry` (
  `deposit_no` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `uid` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `pan_no` varchar(20) DEFAULT NULL,
  `deposit_date` date NOT NULL,
  `exist_flag` tinyint(1) DEFAULT '0',
  `address` varchar(255) DEFAULT NULL,
  `deposit_amt` decimal(12,2) NOT NULL,
  `interest_percent` decimal(5,2) DEFAULT NULL,
  `deposit_type` varchar(50) DEFAULT NULL,
  `deposit_mode` varchar(50) DEFAULT NULL,
  `cheque_no` varchar(50) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `interest_type` varchar(50) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `int_amt` decimal(12,2) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `remarks` text,
  `signature` blob,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`deposit_no`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deposit_entry`
--

LOCK TABLES `deposit_entry` WRITE;
/*!40000 ALTER TABLE `deposit_entry` DISABLE KEYS */;
INSERT INTO `deposit_entry` VALUES (4,9,0,'raja','9789650694','4584964564','2025-10-06',0,'erode',100000.00,12.00,'Capital','Bank','','iob','Fixed','2025-09-18',12000.00,'Cash A/c','fsjkdfjsds',NULL,'2025-10-06 05:58:49'),(5,9,0,'thangamani','7373259203','dfjsklfdsgsl','2025-10-07',0,'komarapalayam',100000.00,0.00,'Capital','Bank','','iob','Monthly','2025-09-18',12000.00,'','payment testing',NULL,'2025-10-07 06:35:11'),(6,9,0,'djsoidfjs','9568596045','jrrje','2025-10-07',0,'fhskjdfshjk',200.00,0.00,'Deposit','Bank','ssjdksfsk','iob','Daily','2025-09-18',12.00,'','',NULL,'2025-10-07 06:42:45'),(7,9,0,'djsoidfjs','9568596045','jrrje','2025-10-07',0,'fhskjdfshjk',200.00,6.00,'Deposit','Bank','ssjdksfsk','iob','','2025-09-18',12.00,'','',NULL,'2025-10-07 06:50:33'),(8,9,0,'Rithanya','6383216665','JDFKSDFJS345','2025-09-01',0,'komarapalayam',100000.00,10.00,'Capital','Bank','','iob','Daily','2025-09-01',10000.00,'Cash A/c','tesitng purpose',NULL,'2025-10-07 07:20:20'),(9,9,0,'dharshan','8667345724','JFDLKFGJFKL','2025-08-01',0,'KOMARAPALAYAM',10000.00,12.00,'Capital','Cash','','IOB','Monthly','2025-10-07',1200.00,'Cash A/c','DEPSOIT INTEREST 1200',NULL,'2025-10-07 09:01:16'),(10,9,0,'elango','9878787779','crcpr4353s','2025-11-21',0,'djfsdfsks',120000.00,12.00,'Deposit','Cash','','','','2025-09-18',0.00,'','',NULL,'2025-11-21 05:05:27'),(11,9,0,'nirmla','8789667676','cgcpr1231','2025-11-01',0,'erode',200000.00,12.00,'Deposit','Cash','122121','121212','Simple','0000-00-00',2312312.00,'','',NULL,'2025-11-21 05:34:37');
/*!40000 ALTER TABLE `deposit_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ledger_day_wise`
--

DROP TABLE IF EXISTS `ledger_day_wise`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ledger_day_wise` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` varchar(11) NOT NULL,
  `uid` varchar(11) NOT NULL,
  `date` date NOT NULL,
  `ledger` varchar(200) NOT NULL,
  `particulars` varchar(200) NOT NULL,
  `voucher_type` varchar(200) NOT NULL,
  `voucher_number` varchar(200) NOT NULL,
  `credit` decimal(10,0) NOT NULL,
  `debit` decimal(10,0) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ledger_day_wise`
--

LOCK TABLES `ledger_day_wise` WRITE;
/*!40000 ALTER TABLE `ledger_day_wise` DISABLE KEYS */;
INSERT INTO `ledger_day_wise` VALUES (83,'9','','2025-11-04','Cash A/c','IOB','Master Receipt','RC2025015',0,30000,'2025-11-04 11:09:25'),(84,'9','','2025-11-04','IOB','Cash A/c','Master Receipt','RC2025015',30000,0,'2025-11-04 11:09:25'),(85,'9','','2025-11-05','IOB','Cash A/c','Master Receipt','RC2025016',0,10000,'2025-11-05 06:07:10'),(86,'9','','2025-11-05','Cash A/c','IOB','Master Receipt','RC2025016',10000,0,'2025-11-05 06:07:10'),(94,'9','1','2025-11-06','Cash A/c','DL2025012-Aadhi','Loan','',10000,0,'2025-11-06 06:56:01'),(100,'9','1','2025-11-01','Cash A/c','DL2025013-Savi','Loan','',10000,0,'2025-11-06 09:05:10'),(101,'9','1','2025-11-01','Cash A/c','DL2025013-Savi','Pre Interest','',0,1000,'2025-11-06 09:05:10'),(102,'9','1','2025-11-06','Cash A/c','DL2025013-Savi','Loan Interest','011',0,5000,'2025-11-06 09:23:16'),(107,'9','1','2025-11-07','Cash A/c','DL2025007-Ayaan','Loan Interest','012',0,12000,'2025-11-07 05:49:22'),(108,'9','1','2025-11-07','Cash A/c','IOB','Transaction','RC2025017',0,20000,'2025-11-07 05:58:55'),(109,'9','1','2025-11-07','IOB','Cash A/c','Transaction','RC2025017',20000,0,'2025-11-07 05:58:55'),(116,'9','1','2025-10-29','Cash A/c','DL2025013-Savi','Principal','015',1000,0,'2025-11-07 10:29:44'),(120,'9','1','2025-11-08','Cash A/c','DL2025013-Savi','Principal','017',1000,0,'2025-11-07 11:02:06'),(121,'9','1','2025-11-08','Cash A/c','EB bill ','Expenses','RC2025018',0,10000,'2025-11-08 07:12:32'),(122,'9','1','2025-11-08','EB bill ','Cash A/c','Expenses','RC2025018',10000,0,'2025-11-08 07:12:32'),(142,'9','1','2025-11-18','Cash A/c','DL2025011-Raja Saravanan','Principal','018',0,167,'2025-11-18 08:04:10'),(143,'9','1','2025-11-18','Cash A/c','DL2025011-Raja Saravanan','Interest','018',0,33,'2025-11-18 08:04:10'),(144,'9','1','2025-11-18','Cash A/c','DL2025009-Ayaan1','Principal','019',0,167,'2025-11-18 09:14:54'),(145,'9','1','2025-11-18','Cash A/c','DL2025009-Ayaan1','Interest','019',33,33,'2025-11-18 09:14:54'),(146,'9','1','2025-10-03','Cash A/c','DL2025012-Priya','Loan','',100000,0,'2025-11-20 05:05:40'),(147,'9','1','2025-10-16','Cash A/c','DL2025013-Varun','Loan','',200000,0,'2025-11-20 05:17:44'),(148,'9','1','2025-11-20','Cash A/c','DL2025014-Vikram','Loan','',10000,0,'2025-11-20 05:22:12'),(149,'9','1','2025-11-20','Cash A/c','DL2025012-Priya','Principal','020',0,100000,'2025-11-20 05:27:19'),(150,'9','1','2025-11-20','Cash A/c','DL2025012-Priya','Interest','020',0,20000,'2025-11-20 05:27:19'),(151,'9','1','2025-11-20','Raja',' ',' ',' ',1000,0,'2025-11-20 10:33:50'),(152,'9','1','2025-11-21','','DL000010-elango','Deposit','',120000,0,'2025-11-20 23:35:27'),(153,'15','4','2025-11-21','Cash A/c',' ',' ',' ',0,1000000,'2025-11-21 05:19:05'),(154,'9','1','2025-11-01','','DL000011-nirmla','Deposit','',200000,0,'2025-11-21 00:04:37'),(155,'15','4','2025-11-10','Cash A/c','DL2025001-Pavithra','Loan','',5000,0,'2025-11-21 05:51:03'),(156,'15','4','2025-12-03','Cash A/c','DL2025002-Hari','Loan','',10000,0,'2025-12-03 17:37:03'),(157,'15','4','2025-12-04','Cash A/c','DL2025003-Arshaf','Loan','',10000,0,'2025-12-04 06:44:25'),(158,'15','4','2025-12-02','Cash A/c','DL2025004-Baby','Loan','',10000,0,'2025-12-04 06:48:50'),(159,'15','5','2025-12-04','','Cash A/c','Expense','RC2025001',551,0,'2025-12-04 12:26:17'),(160,'15','5','2025-12-04','','Raja','Expense','RC2025001',0,551,'2025-12-04 12:26:17');
/*!40000 ALTER TABLE `ledger_day_wise` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ledger_entry`
--

DROP TABLE IF EXISTS `ledger_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ledger_entry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `com_id` int NOT NULL,
  `ledger_name` varchar(255) NOT NULL,
  `ledger_under` varchar(100) NOT NULL,
  `opening` decimal(10,0) NOT NULL,
  `acc_type` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ledger_entry`
--

LOCK TABLES `ledger_entry` WRITE;
/*!40000 ALTER TABLE `ledger_entry` DISABLE KEYS */;
INSERT INTO `ledger_entry` VALUES (13,1,9,'Cash A/c','Cash in hand',100000,'Credit','Active','2025-10-16 11:06:31'),(14,1,9,'IOB','Bank',100000,'Debit','Active','2025-10-16 11:06:55'),(15,1,9,'EB bill ','Expenses',30000,'Debit','Active','2025-10-21 04:57:38'),(16,1,9,'Vehicle ','Fixed Assets',200000,'Debit','Active','2025-11-07 06:06:34'),(17,1,9,'Loan Interest','Income',0,'Credit','Active','2025-11-08 07:15:51'),(18,1,9,'Loan Deff','Income',0,'Debit','Active','2025-11-08 08:35:05'),(19,1,9,'Raja','Broker',1000,'Credit','Active','2025-11-20 10:33:50'),(20,4,15,'Cash A/c','Cash in hand',1000000,'Credit','Active','2025-11-21 05:19:05');
/*!40000 ALTER TABLE `ledger_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ledger_under`
--

DROP TABLE IF EXISTS `ledger_under`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ledger_under` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `under_name` varchar(255) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ledger_under`
--

LOCK TABLES `ledger_under` WRITE;
/*!40000 ALTER TABLE `ledger_under` DISABLE KEYS */;
INSERT INTO `ledger_under` VALUES (1,9,'Bank','2025-09-15 08:28:00'),(2,9,'Expenses','2025-09-15 08:28:00'),(3,9,'Cash in hand','2025-09-15 08:28:00'),(4,9,'Broker','2025-09-15 08:28:00'),(5,9,'Others','2025-09-15 08:28:00'),(6,9,'Income','2025-09-15 08:28:00'),(7,9,'Capital A/C','2025-09-15 08:28:00'),(8,9,'Sundry Debtors','2025-09-15 08:28:00'),(9,9,'Customer','2025-09-15 08:28:00'),(10,9,'Sundry Creditors','2025-09-15 08:28:00'),(11,9,'Supplier','2025-09-15 08:28:00'),(12,9,'Current Assets','2025-09-15 08:28:00'),(13,9,'Loan And Advances','2025-09-15 08:28:00'),(14,9,'Fixed Assets','2025-09-15 08:28:00'),(15,9,'Loans (Liability)','2025-09-15 08:28:00'),(16,9,'Unsecured Loans','2025-09-15 08:28:00'),(17,9,'Profit And Loss Account','2025-09-15 08:28:00'),(18,9,'Expenditure Accounts','2025-09-15 08:28:00'),(19,15,'Bank','2025-11-21 05:13:25'),(20,15,'Expenses','2025-11-21 05:13:25'),(21,15,'Cash in hand','2025-11-21 05:13:25'),(22,15,'Broker','2025-11-21 05:13:25'),(23,15,'Others','2025-11-21 05:13:25'),(24,15,'Income','2025-11-21 05:13:25'),(25,15,'Capital A/C','2025-11-21 05:13:25'),(26,15,'Sundry Debtors','2025-11-21 05:13:25'),(27,15,'Customer','2025-11-21 05:13:25'),(28,15,'Sundry Creditors','2025-11-21 05:13:25'),(29,15,'Supplier','2025-11-21 05:13:25'),(30,15,'Current Assets','2025-11-21 05:13:25'),(31,15,'Loan And Advances','2025-11-21 05:13:25'),(32,15,'Fixed Assets','2025-11-21 05:13:25'),(33,15,'Loans (Liability)','2025-11-21 05:13:25'),(34,15,'Unsecured Loans','2025-11-21 05:13:25'),(35,15,'Profit And Loss Account','2025-11-21 05:13:25'),(36,15,'Expenditure Accounts','2025-11-21 05:13:25');
/*!40000 ALTER TABLE `ledger_under` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `line_entry`
--

DROP TABLE IF EXISTS `line_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `line_entry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `area` varchar(200) NOT NULL,
  `line` varchar(200) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `line_entry`
--

LOCK TABLES `line_entry` WRITE;
/*!40000 ALTER TABLE `line_entry` DISABLE KEYS */;
INSERT INTO `line_entry` VALUES (1,9,'erode','main line','0000-00-00 00:00:00'),(2,9,'salem','main line','0000-00-00 00:00:00'),(3,9,'Kollampalayam','second','2025-09-22 04:49:43'),(4,9,'chennai','second','2025-09-22 04:49:43'),(5,9,'covai','primary','2025-09-22 05:12:00'),(6,9,'thiruppur','primary','2025-09-22 05:12:00'),(7,9,'thiruppur','Line1','2025-11-04 06:27:10'),(8,9,'Chennai','Line1','2025-11-04 06:27:10'),(9,15,'VOC Park','Line 1','2025-11-21 05:42:53'),(10,15,'Bus Stand','Line 1','2025-11-21 05:42:53'),(11,15,'Karungalpalayam','Line 1','2025-11-21 05:42:53'),(12,15,'Kollampalayam','Line 2','2025-11-21 05:43:29'),(13,15,'Mollapalayam','Line 2','2025-11-21 05:43:29'),(14,15,'P.S.Park','Line 2','2025-11-21 05:43:29'),(15,15,'Fire Service','Line 2','2025-11-21 05:43:29'),(16,15,'Gobi','Line 3','2025-11-21 05:43:44');
/*!40000 ALTER TABLE `line_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loan_entry`
--

DROP TABLE IF EXISTS `loan_entry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loan_entry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `loan_id` varchar(50) NOT NULL,
  `com_id` int NOT NULL,
  `loan_date` date NOT NULL,
  `cust_id` int NOT NULL,
  `cus_name` varchar(100) NOT NULL,
  `cust_mobile` varchar(15) NOT NULL,
  `cust_contact` varchar(15) NOT NULL,
  `aadhaar_no` varchar(100) NOT NULL,
  `cust_address` varchar(500) NOT NULL,
  `cust_address2` varchar(500) NOT NULL,
  `area` varchar(255) NOT NULL,
  `loan_type` varchar(20) NOT NULL,
  `loan_amt` decimal(10,0) NOT NULL,
  `dues` varchar(50) NOT NULL,
  `interest` decimal(10,0) NOT NULL,
  `interest_amt` decimal(10,0) NOT NULL,
  `ledger` varchar(50) NOT NULL,
  `due_schedule` json DEFAULT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total_amt` decimal(10,0) NOT NULL,
  `per_due_amt` decimal(10,0) NOT NULL,
  `next_due_date` date NOT NULL,
  `last_due_date` date NOT NULL,
  `pre_interest` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loan_entry`
--

LOCK TABLES `loan_entry` WRITE;
/*!40000 ALTER TABLE `loan_entry` DISABLE KEYS */;
INSERT INTO `loan_entry` VALUES (4,'DL2025001',9,'0000-00-00',0,'djfshkh','4508734603','9849096374','905690346753','fsushsdflsdfksjdflsdkfjsdkl','jdflksdfjslkdfjsd','Kollampalayam','Weekly',2000000,'10',12,240000,'',NULL,'2025-09-22 03:29:01',2240000,224000,'0000-00-00','0000-00-00','No',''),(5,'DL2025002',9,'2025-09-22',0,'Raja','1234567890','1234567890','1234567890','Erode','Erode','salem','Daily',10000,'60',20,2000,'',NULL,'2025-09-22 05:49:31',12000,167,'2025-09-23','2025-11-21','Yes',''),(6,'DL2025003',9,'2025-09-24',0,'Mani','9800998899','9878876786','','23/9,veppadai , erode','','Kumarapalayam','Daily',10000,'60',0,0,'',NULL,'2025-09-24 10:03:41',10000,167,'2025-09-25','2025-11-23','No',''),(7,'DL2025004',9,'2025-09-24',0,'fvf','12345678','3456789','1234567890','dfghj','fgvfgfs','thiruppur','Weekly',10000,'10',0,0,'Cash A/c',NULL,'2025-09-24 10:20:47',10000,1000,'2025-10-01','2025-12-03','No',''),(10,'DL2025005',9,'2025-09-27',0,'Raja','1234567890','1234567890','1234567890','Erode','Erode','Kumarapalayam','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-09-27 07:46:52',12000,200,'2025-09-28','2025-11-26','0',''),(11,'DL2025006',9,'2025-10-01',1,'Ayaan','4565756756','5465756767','565756876876','Erode','Erode','Kumarapalayam','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-10-01 13:17:21',12000,200,'2025-10-02','2025-11-30','0',''),(13,'DL2025008',9,'2025-10-01',1,'Ayaan','1234567890','1234567890','1234567890','Erode','Erode','Kumarapalayam','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-10-01 13:23:06',12000,200,'2025-10-02','2025-11-30','No',''),(15,'DL2025009',9,'2025-10-01',2,'Ayaan1','1234567891','1234567891','1234567891','Erode','Erode','Kumarapalayam','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-10-01 13:25:59',12000,200,'2025-10-02','2025-11-30','No',''),(16,'DL2025010',9,'2025-10-01',2,'Ayaan1234354','1234567891','1234567891','1234567891','Erode','Erode','Kumarapalayam','Daily',15000,'60',20,3000,'Cash A/c',NULL,'2025-10-01 13:28:15',18000,300,'2025-10-02','2025-11-30','0','Active'),(23,'DL2025011',9,'2025-11-17',4,'Raja Saravanan','8825948300','8825948300','988259483009','Erode','Erode','Chennai','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-11-18 07:28:10',12000,200,'2025-11-18','2026-01-16','0','Active'),(24,'DL2025012',9,'2025-10-03',5,'Priya','8765427676','8675645467','466879352345','Erode','Erode','Chennai','Daily',100000,'60',20,20000,'Cash A/c',NULL,'2025-11-20 05:05:40',120000,2000,'2025-10-04','2025-12-02','0','Closed'),(25,'DL2025013',9,'2025-10-16',6,'Varun','8776564534','8767564563','456576978098','Erode','Erode','Kumarapalayam','Weekly',200000,'10',20,40000,'Cash A/c',NULL,'2025-11-20 05:17:44',240000,24000,'2025-10-23','2025-12-25','0','Active'),(26,'DL2025014',9,'2025-11-20',7,'Vikram','7564537686','9878767564','897867564343','Erode','Erode','Kumarapalayam','Daily',10000,'60',10,1000,'Cash A/c',NULL,'2025-11-20 05:22:11',11000,183,'2025-11-21','2026-01-19','0','Active'),(27,'DL2025001',15,'2025-11-10',8,'Pavithra','5346876764','5346876764','534687676476','Erode','Erode','Mollapalayam','Daily',5000,'60',10,500,'Cash A/c',NULL,'2025-11-21 05:51:03',5500,92,'2025-11-11','2026-01-09','0','Active'),(28,'DL2025002',15,'2025-12-03',9,'Hari','9879878675','9879786756','878675645434','Erode','Erode','Mollapalayam','Daily',10000,'60',20,2000,'Cash A/c',NULL,'2025-12-03 17:37:03',12000,200,'2025-12-04','2026-02-01','0','Active'),(29,'DL2025003',15,'2025-12-04',10,'Arshaf','9856564546','8979768657','768979567545','Erode','Erode','Kollampalayam','Daily',10000,'60',10,1000,'Cash A/c',NULL,'2025-12-04 06:44:25',11000,183,'2025-12-05','2026-02-02','0','Active'),(30,'DL2025004',15,'2025-12-02',11,'Baby','6787687656','6798789676','768768797896','Erode','Erode','Gobi','Daily',10000,'60',10,1000,'Cash A/c',NULL,'2025-12-04 06:48:50',11000,183,'2025-12-03','2026-01-31','0','Active');
/*!40000 ALTER TABLE `loan_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loan_receipt`
--

DROP TABLE IF EXISTS `loan_receipt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loan_receipt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `loan_id` varchar(50) NOT NULL,
  `rec_no` varchar(50) NOT NULL,
  `rec_date` date NOT NULL,
  `cust_id` int NOT NULL,
  `cust_name` varchar(255) NOT NULL,
  `cust_mobile` varchar(15) NOT NULL,
  `num_dues` int NOT NULL,
  `due_amnt` decimal(10,0) NOT NULL,
  `paid_amnt` decimal(10,0) NOT NULL,
  `paid_dues` int NOT NULL,
  `balance_dues` int NOT NULL,
  `pending_dues` int NOT NULL,
  `next_date` date NOT NULL,
  `remark` text NOT NULL,
  `agent` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loan_receipt`
--

LOCK TABLES `loan_receipt` WRITE;
/*!40000 ALTER TABLE `loan_receipt` DISABLE KEYS */;
INSERT INTO `loan_receipt` VALUES (34,9,'DL2025011','018','2025-11-18',2147483647,'Raja Saravanan','',60,200,400,2,60,2,'2025-11-20','jhgyfyt','baby','2025-11-18 07:35:00'),(35,9,'DL2025009','019','2025-11-18',1234567891,'Ayaan1','',60,200,9600,48,60,48,'2025-11-19','kjhjghjy','baby','2025-11-18 09:14:53'),(36,9,'DL2025012','020','2025-11-20',2147483647,'Priya','',60,2000,120000,48,60,48,'2025-11-21','closed','baby','2025-11-20 05:27:19'),(37,15,'DL2025001','001','2025-12-04',8,'Pavithra','5346876764',60,92,2208,24,60,24,'2025-12-05','hvhjfgh','Raja','2025-12-04 11:20:07'),(38,15,'DL2025001','REC1765116719895','2025-12-07',8,'Pavithra','',0,276,276,1,0,0,'2025-12-08','','','2025-12-07 14:11:59');
/*!40000 ALTER TABLE `loan_receipt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loan_type`
--

DROP TABLE IF EXISTS `loan_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loan_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `loan_type` varchar(50) NOT NULL,
  `due_count` varchar(200) NOT NULL,
  `createdOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loan_type`
--

LOCK TABLES `loan_type` WRITE;
/*!40000 ALTER TABLE `loan_type` DISABLE KEYS */;
INSERT INTO `loan_type` VALUES (1,9,'Daily','60','2025-09-16 11:12:40'),(2,9,'Weekly','10','2025-09-18 08:18:23'),(4,9,'Monthly','5','2025-09-24 07:39:29'),(5,15,'Daily','60','2025-11-21 05:34:47'),(6,15,'Weekly','10','2025-11-21 05:35:01');
/*!40000 ALTER TABLE `loan_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mask`
--

DROP TABLE IF EXISTS `mask`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mask` (
  `id` int NOT NULL,
  `com_id` int NOT NULL,
  `status` enum('yes','no') DEFAULT 'yes',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mask`
--

LOCK TABLES `mask` WRITE;
/*!40000 ALTER TABLE `mask` DISABLE KEYS */;
/*!40000 ALTER TABLE `mask` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment`
--

DROP TABLE IF EXISTS `payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment` (
  `payment_no` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `deposit_no` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `add_less` enum('Add','Less') DEFAULT 'Less',
  `principal_amt` decimal(15,2) DEFAULT '0.00',
  `int_pay_for` varchar(50) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT '0.00',
  `int_amt` decimal(15,2) DEFAULT '0.00',
  `bal_amt` decimal(15,2) DEFAULT '0.00',
  `pay_amt` decimal(15,2) DEFAULT '0.00',
  `deposit_amt` decimal(15,2) DEFAULT '0.00',
  `interest_type` varchar(50) DEFAULT NULL,
  `deposit_date` date DEFAULT NULL,
  `amt` decimal(15,2) DEFAULT '0.00',
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `payment_mode` varchar(50) DEFAULT NULL,
  `cash_ac` varchar(100) DEFAULT NULL,
  `cheque_no` varchar(50) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `balance_amount` decimal(15,2) DEFAULT '0.00',
  `remarks` text,
  `close_flag` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`payment_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment`
--

LOCK TABLES `payment` WRITE;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
INSERT INTO `payment` VALUES (1,9,1,'0000-00-00','baby thangamani',NULL,'Less',10.00,'1',NULL,12.00,12.00,12.00,NULL,'ddsffsd',NULL,NULL,NULL,NULL,'Bank','ddasa','2','0000-00-00',NULL,NULL,'sdsdsgs',NULL,'2025-10-03 10:31:58','2025-10-03 10:44:03');
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `registration`
--

DROP TABLE IF EXISTS `registration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `registration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_name` varchar(255) NOT NULL,
  `mob_num` varchar(15) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registration`
--

LOCK TABLES `registration` WRITE;
/*!40000 ALTER TABLE `registration` DISABLE KEYS */;
INSERT INTO `registration` VALUES (5,'KanInfoTech','9788777788','kaninfotech@gmail.com','active','2025-09-15 08:28:00'),(6,'Nasreen','9360500657','nasreen@gmail.com','active','2025-11-21 05:13:25');
/*!40000 ALTER TABLE `registration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `report_time`
--

DROP TABLE IF EXISTS `report_time`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `report_time` (
  `id` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `time_from` time NOT NULL,
  `time_to` time NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `report_time`
--

LOCK TABLES `report_time` WRITE;
/*!40000 ALTER TABLE `report_time` DISABLE KEYS */;
/*!40000 ALTER TABLE `report_time` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `value` text,
  `description` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'allow_multiple_devices','false','Allow users to login from multiple devices simultaneously. Set to \"true\" to allow, \"false\" to restrict to single device.','2025-11-21 06:23:46','2025-11-21 06:23:46');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff` (
  `uid` int NOT NULL AUTO_INCREMENT,
  `com_id` int NOT NULL,
  `reg_id` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `user_type` varchar(200) NOT NULL,
  `user_name` varchar(200) NOT NULL,
  `password` varchar(300) NOT NULL,
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1,9,'1','baby','admin','admin','123456','All','2025-09-24 08:02:38'),(3,9,'1','Nasreen','normal','user','123456','[\"Loan:Entry\",\"Masters:Customer Creations\",\"Masters:Deposit Entry\",\"Reports:Loan Report\",\"Reports:Customer Report\",\"Reports:Collection Agent Report\",\"Log Out:\"]','2025-09-25 05:58:44'),(4,15,'6','Nasreen','admin','ayaan','123456','All','2025-11-21 05:13:25');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `voucher`
--

DROP TABLE IF EXISTS `voucher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `voucher` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(11) NOT NULL,
  `com_id` varchar(11) NOT NULL,
  `voucher_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `date` date NOT NULL,
  `from` varchar(45) NOT NULL,
  `to` varchar(45) NOT NULL,
  `purpose` varchar(45) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `notes` varchar(200) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `voucher`
--

LOCK TABLES `voucher` WRITE;
/*!40000 ALTER TABLE `voucher` DISABLE KEYS */;
INSERT INTO `voucher` VALUES (28,'1','9','RC2025001','2025-10-14','EB','Salary','Transaction',8000.00,'','2025-10-14 07:03:08'),(29,'1','9','RC2025002','2025-10-01','Cash A/c','Salary','Transaction',520000.00,'','2025-10-14 08:59:42'),(30,'1','9','RC2025003','2025-10-14','Cash A/c','EB','Transaction',40000.00,'','2025-10-14 09:24:00'),(31,'1','9','RC2025004','2025-10-14','Cash A/c','EB','Transaction',50000.00,'','2025-10-14 09:25:30'),(32,'1','9','RC2025005','2025-10-14','Salary','Cash A/c','Payment',100000.00,'','2025-10-14 09:26:17'),(33,'1','9','RC2025006','2025-10-14','EB','Salary','Payment',12000.00,'','2025-10-14 09:26:46'),(34,'1','9','RC2025007','2025-10-14','EB','Cash A/c','Transaction',70000.00,'','2025-10-14 09:27:15'),(35,'1','9','RC2025008','2025-10-14','Cash A/c','EB','Expenses',19000.00,'','2025-10-14 09:27:46'),(36,'1','9','RC2025009','2025-10-14','Cash A/c','EB','Salary',999999.00,'','2025-10-14 09:28:28'),(37,'1','9','RC2025010','2025-10-14','Cash A/c','EB','Transaction',40000.00,'','2025-10-14 09:42:48'),(38,'1','9','RC2025011','2025-10-14','Salary','EB','Salary',510000.00,'','2025-10-14 09:43:10'),(39,'1','9','RC2025012','2025-10-14','Salary','EB','Salary',30000.00,'','2025-10-14 09:47:41'),(40,'1','9','RC2025013','2025-10-14','EB','Salary','Salary',818888.00,'','2025-10-14 10:01:44'),(41,'1','9','RC2025014','2025-10-16','EB','Cash A/c','Transaction',20000.00,'','2025-10-16 10:44:05'),(42,'1','9','RC2025015','2025-11-04','Cash A/c','IOB','Master Receipt',30000.00,'','2025-11-04 11:09:25'),(43,'1','9','RC2025016','2025-11-05','IOB','Cash A/c','Master Receipt',10000.00,'','2025-11-05 06:07:10'),(45,'1','9','RC2025017','2025-11-07','Cash A/c','IOB','Transaction',20000.00,'','2025-11-07 05:58:55'),(46,'1','9','RC2025018','2025-11-08','Cash A/c','EB bill ','Expenses',10000.00,'','2025-11-08 07:12:32'),(47,'1','9','RC2025019','2025-11-08','Cash A/c','Loan Interest','Payment',300000.00,'','2025-11-08 08:31:00'),(48,'1','9','RC2025020','2025-11-08','Cash A/c','Loan Deff','Payment',30000.00,'','2025-11-08 08:38:41'),(49,'5','15','1','2025-12-04','Raja','Cash A/c','Expense',250.75,'Fuel expense for daily collection','2025-12-04 12:17:47'),(50,'5','15','RC2025001','2025-12-04','Raja','Cash A/c','Expense',550.75,'Fuel expense for daily collection','2025-12-04 12:26:17');
/*!40000 ALTER TABLE `voucher` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `year_posting`
--

DROP TABLE IF EXISTS `year_posting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `year_posting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(11) NOT NULL,
  `com_id` varchar(11) NOT NULL,
  `year` varchar(11) NOT NULL,
  `status` varchar(45) NOT NULL,
  `create_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `year_posting`
--

LOCK TABLES `year_posting` WRITE;
/*!40000 ALTER TABLE `year_posting` DISABLE KEYS */;
INSERT INTO `year_posting` VALUES (1,'1','9','2025 - 2026','Active','2025-10-06 07:20:44');
/*!40000 ALTER TABLE `year_posting` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-08 13:52:52