|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.217.3 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/admin/backup/SNENG/../SKVKMH/../PSNS/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.11.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: u926327694_PSNS_fees
-- ------------------------------------------------------
-- Server version 10.11.10-MariaDB
/*!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 */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 `Receipt_Head`
--
DROP TABLE IF EXISTS `Receipt_Head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Receipt_Head` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Section` varchar(1000) DEFAULT NULL,
`Head1` varchar(1000) DEFAULT NULL,
`Head2` varchar(1000) DEFAULT NULL,
`Head3` varchar(1000) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receipt_Head`
--
LOCK TABLES `Receipt_Head` WRITE;
/*!40000 ALTER TABLE `Receipt_Head` DISABLE KEYS */;
INSERT INTO `Receipt_Head` VALUES
(3,'SCHOOL','DR V S SADHUNAVAR FOUNDATION','PRERANA PRE PRIMARY SCHOOL','NESARAGI');
/*!40000 ALTER TABLE `Receipt_Head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`accountnumber` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account`
--
LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_accounts`
--
DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`passwd` varchar(50) NOT NULL,
`admin_type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_accounts`
--
LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bankaccounts`
--
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Bank_Name` varchar(1000) NOT NULL,
`IFSC` varchar(1000) NOT NULL,
`Account_Number` varchar(1000) NOT NULL,
`AccountHolderName` varchar(1000) NOT NULL,
`PayuKey` bigint(20) NOT NULL,
`SaltKey` bigint(20) NOT NULL,
`MerchantKey` bigint(20) NOT NULL,
`AccountType` varchar(1000) NOT NULL,
`Link` varchar(10000) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'KRCS','','9743','V S S FOUNDATION ',0,0,0,'',''),
(2,'SBI','','4370','V S S FOUNDATION ',0,0,0,'','');
/*!40000 ALTER TABLE `bankaccounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `budget`
--
DROP TABLE IF EXISTS `budget`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budget` (
`budgetid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fromdate` date NOT NULL,
`todate` date DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`budgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `budget`
--
LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`type` int(11) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `class`
--
DROP TABLE IF EXISTS `class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class` (
`Name` varchar(100) NOT NULL,
`Cls_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Cls_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `class`
--
LOCK TABLES `class` WRITE;
/*!40000 ALTER TABLE `class` DISABLE KEYS */;
INSERT INTO `class` VALUES
('LKG',5,NULL),
('NURSRY',4,NULL),
('UKG',6,NULL),
('PLAY GROUP',7,NULL),
('1ST STD',8,NULL);
/*!40000 ALTER TABLE `class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commission`
--
DROP TABLE IF EXISTS `commission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commission` (
`Commission` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commission`
--
LOCK TABLES `commission` WRITE;
/*!40000 ALTER TABLE `commission` DISABLE KEYS */;
/*!40000 ALTER TABLE `commission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
`id1` int(10) NOT NULL AUTO_INCREMENT,
`f_name` varchar(25) NOT NULL,
`l_name` varchar(25) NOT NULL,
`gender` varchar(6) NOT NULL,
`address` varchar(100) DEFAULT NULL,
`city` varchar(15) NOT NULL,
`state` varchar(30) NOT NULL,
`phone` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`date_of_birth` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customers`
--
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `division`
--
DROP TABLE IF EXISTS `division`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `division` (
`Name` varchar(100) NOT NULL,
`Div_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Div_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `division`
--
LOCK TABLES `division` WRITE;
/*!40000 ALTER TABLE `division` DISABLE KEYS */;
INSERT INTO `division` VALUES
('A',2,NULL);
/*!40000 ALTER TABLE `division` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goals`
--
DROP TABLE IF EXISTS `goals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goals` (
`goalsid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`accountid` int(5) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`deposit` decimal(10,2) NOT NULL,
`deadline` date NOT NULL,
PRIMARY KEY (`goalsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goals`
--
LOCK TABLES `goals` WRITE;
/*!40000 ALTER TABLE `goals` DISABLE KEYS */;
/*!40000 ALTER TABLE `goals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `head`
--
DROP TABLE IF EXISTS `head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `head` (
`Name` varchar(1000) NOT NULL,
`Head_Id` int(11) NOT NULL AUTO_INCREMENT,
`SubHeads` varchar(1000) NOT NULL,
`Last_Date` date NOT NULL,
`One_Time_Payment` varchar(100) NOT NULL,
`Fine_Amount` varchar(100) NOT NULL,
`Bank_Code` varchar(10) NOT NULL,
`ReciptName` varchar(1000) NOT NULL,
PRIMARY KEY (`Head_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `head`
--
LOCK TABLES `head` WRITE;
/*!40000 ALTER TABLE `head` DISABLE KEYS */;
INSERT INTO `head` VALUES
('TUTION FEES- NURSERY',4,'2','2026-06-01','No','0','1','TUTN'),
('TUTION FEES-PLAY GROUP',3,'1','2026-06-01','No','0','1','TUTN'),
('TUTION FEES - LKG',5,'3','2026-06-01','No','0','1','TUTN'),
('TUTION FEES - UKG',6,'4','2026-06-01','No','0','1','TUTN'),
('TRSP- NESARGI',7,'5','2026-06-01','No','0','1','TRSP'),
('TRSP- KOLADUR',8,'6','2026-06-01','No','0','1','TRSP'),
('TRSP- MOHARE',9,'7','2026-06-01','No','0','1','TRSP'),
('TRSP- DESNUR',10,'8','2026-06-01','No','0','1','TRSP'),
('TRSP-SUTAGATTI',11,'9','2026-06-01','No','0','1','TRSP'),
('TRSP-MATHIKOPP',12,'10','2026-06-01','No','0','1','TRSP'),
('TRSP-MADANBHAVI',13,'11','2026-06-01','No','0','1','TRSP'),
('TRSP-SOMANATTI',14,'12','2026-06-01','No','0','1','TRSP'),
('TRSP-MEKALMARDI',15,'13','2026-06-01','No','0','1','TRSP'),
('TRSP- HANBARATTI',16,'14','2026-06-01','No','0','1','TRSP'),
('TRSP-MALLAPUR',17,'15','2026-06-01','No','0','1','TRSP'),
('TRSP- HOGARTI',18,'17','2026-06-01','No','0','1','TRSP'),
('TRSP- KOLANATTI',19,'18','2026-06-01','No','0','1','TRSP');
/*!40000 ALTER TABLE `head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ledger`
--
DROP TABLE IF EXISTS `ledger`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ledger` (
`Name` varchar(1000) NOT NULL,
`Ledger_Id` int(11) NOT NULL AUTO_INCREMENT,
`Type` varchar(1000) NOT NULL,
PRIMARY KEY (`Ledger_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ledger`
--
LOCK TABLES `ledger` WRITE;
/*!40000 ALTER TABLE `ledger` DISABLE KEYS */;
INSERT INTO `ledger` VALUES
('PLAY GROUP',1,'Income/Revenue'),
('NURSERY',2,'Income/Revenue'),
('LKG',3,'Income/Revenue'),
('UKG',4,'Income/Revenue'),
('PLAY GROUP',5,'Income/Revenue'),
('TRSP- KOLADUR',6,'Income/Revenue'),
('TRSP- MOHARE',7,'Income/Revenue'),
('TRSP- DESNUR',8,'Income/Revenue'),
('TRSP-SUTAGATTI',9,'Income/Revenue'),
('TRSP-MATHIKOPP',10,'Income/Revenue'),
('TRSP-MADANBHAVI',11,'Income/Revenue'),
('12/TRSP-SOMANATTI/5000',12,'Income/Revenue'),
('TRSP-MEKALMARDI',13,'Income/Revenue'),
('TRSP- HANBARATTI',14,'Income/Revenue'),
('TRSP- MALLAPUR',15,'Income/Revenue'),
('TRSP- MALLAPUR',16,'Income/Revenue'),
('TRSP- HOGARTI',17,'Income/Revenue'),
('TRSP- KOLANATTI',18,'Income/Revenue');
/*!40000 ALTER TABLE `ledger` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `onlinetemp`
--
DROP TABLE IF EXISTS `onlinetemp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `onlinetemp` (
`Fees_id` bigint(20) NOT NULL AUTO_INCREMENT,
`TID` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL,
`Head_Id` varchar(200) NOT NULL,
`Subhead_Ids` varchar(1000) NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) DEFAULT NULL,
`DateNumber` varchar(1000) NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`Status` varchar(1000) NOT NULL,
`user` varchar(1000) NOT NULL,
PRIMARY KEY (`Fees_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `onlinetemp`
--
LOCK TABLES `onlinetemp` WRITE;
/*!40000 ALTER TABLE `onlinetemp` DISABLE KEYS */;
/*!40000 ALTER TABLE `onlinetemp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees`
--
DROP TABLE IF EXISTS `paid_fees`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees` (
`Fees_id` bigint(20) NOT NULL AUTO_INCREMENT,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) NOT NULL,
`Recp_Book_No` varchar(500) NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) NOT NULL,
`Subhead_Ids` varchar(1000) NOT NULL,
`Sub_Amounts` varchar(1000) NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) DEFAULT NULL,
`DateNumber` varchar(1000) NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
PRIMARY KEY (`Fees_id`)
) ENGINE=MyISAM AUTO_INCREMENT=217 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees`
--
LOCK TABLES `paid_fees` WRITE;
/*!40000 ALTER TABLE `paid_fees` DISABLE KEYS */;
INSERT INTO `paid_fees` VALUES
(1,54,'TRSP-1',1,'TRSP','TRSP-1',1,'18','/17','/7000','2023-04-18','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(2,54,'TUTN-1',1,'TUTN','TUTN-1',1,'6','/4','/14000','2023-04-18','Cash','',0,0,14000,14000,1,'MEGHA',NULL),
(20,63,'TRSP-9',9,'TRSP','TRSP-9',9,'13','/11','/','2023-05-02','Online','',0,0,0,0,1,'MEGHA',NULL),
(29,64,'TUTN-16',16,'TUTN','TUTN-16',16,'6','/4','/14000','2023-04-25','Cash','',0,0,14000,14000,1,'MEGHA',NULL),
(5,62,'TUTN-3',3,'TUTN','TUTN-3',3,'6','/4','/5000','2023-04-28','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(6,62,'TRSP-3',3,'TRSP','TRSP-3',3,'11','/9','/','2023-04-28','Cash','',0,0,0,0,1,'MEGHA',NULL),
(214,63,'TRSP-97',97,'TRSP','TRSP-97',97,'13','/11','/3500','2024-03-01','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(213,63,'TUTN-114',114,'TUTN','TUTN-114',114,'6','/4','/2000','2024-03-01','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(28,64,'TRSP-12',12,'TRSP','TRSP-12',12,'14','/12','/5000','2023-04-25','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(19,63,'TUTN-10',10,'TUTN','TUTN-10',10,'6','/4','/3000','2023-05-02','Online','',0,0,3000,3000,1,'MEGHA',NULL),
(14,57,'TUTN-7',7,'TUTN','TUTN-7',7,'6','/4','/7000','2023-03-31','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(15,57,'TRSP-7',7,'TRSP','TRSP-7',7,'10','/8','/3000','2023-03-31','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(16,58,'TUTN-8',8,'TUTN','TUTN-8',8,'6','/4','/14000','2023-04-21','Cash','',0,0,14000,14000,1,'MEGHA',NULL),
(17,52,'TUTN-9',9,'TUTN','TUTN-9',9,'5','/3','/13000','2023-04-27','Online','',0,0,13000,13000,1,'MEGHA',NULL),
(18,52,'TRSP-8',8,'TRSP','TRSP-8',8,'17','/15','/4500','2023-04-27','Online','',0,0,4500,4500,1,'MEGHA',NULL),
(21,23,'TUTN-11',11,'TUTN','TUTN-11',11,'6','/4','/14000','2023-04-24','Cash','',0,0,14000,14000,1,'MEGHA',NULL),
(22,59,'TUTN-12',12,'TUTN','TUTN-12',12,'4','/2','/12000','2023-04-05','Cash','',0,0,12000,12000,1,'MEGHA',NULL),
(23,59,'TRSP-10',10,'TRSP','TRSP-10',10,'14','/12','/5000','2023-04-05','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(24,61,'TUTN-13',13,'TUTN','TUTN-13',13,'6','/4','/7500','2023-04-24','Cash','',0,0,7500,7500,1,'MEGHA',NULL),
(25,61,'TRSP-11',11,'TRSP','TRSP-11',11,'16','/14','/3500','2023-04-24','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(26,8,'TUTN-14',14,'TUTN','TUTN-14',14,'5','/3','/13000','2023-04-27','Cash','',0,0,13000,13000,1,'MEGHA',NULL),
(27,42,'TUTN-15',15,'TUTN','TUTN-15',15,'5','/3','/5000','2023-04-29','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(30,17,'TUTN-17',17,'TUTN','TUTN-17',17,'6','/4','/14000','2023-05-08','Online','',0,0,14000,14000,1,'MEGHA',NULL),
(31,17,'TRSP-13',13,'TRSP','TRSP-13',13,'12','/10','/6500','2023-05-08','Online','',0,0,6500,6500,1,'MEGHA',NULL),
(32,65,'TUTN-18',18,'TUTN','TUTN-18',18,'6','/4','/14000','2023-05-08','Online','',0,0,14000,14000,1,'MEGHA',NULL),
(33,65,'TRSP-14',14,'TRSP','TRSP-14',14,'12','/10','/6500','2023-05-08','Online','',0,0,6500,6500,1,'MEGHA',NULL),
(44,71,'TRSP-19',19,'TRSP','TRSP-19',19,'12','/10','/6500','2023-05-08','Online','',0,0,6500,6500,1,'MEGHA',NULL),
(45,71,'TUTN-25',25,'TUTN','TUTN-25',25,'5','/3','/13000','2023-05-08','Online','',0,0,13000,13000,1,'MEGHA',NULL),
(36,67,'TUTN-20',20,'TUTN','TUTN-20',20,'6','/4','/14000','2023-05-08','Online','',0,0,14000,14000,1,'MEGHA',NULL),
(37,67,'TRSP-16',16,'TRSP','TRSP-16',16,'12','/10','/6500','2023-05-08','Online','',0,0,6500,6500,1,'MEGHA',NULL),
(38,68,'TUTN-21',21,'TUTN','TUTN-21',21,'5','/3','/5000','2023-05-09','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(39,68,'TRSP-17',17,'TRSP','TRSP-17',17,'9','/7','/','2023-05-09','Cash','',0,0,0,0,1,'MEGHA',NULL),
(40,69,'TUTN-22',22,'TUTN','TUTN-22',22,'4','/2','/12000','2023-05-09','Cash','',0,0,12000,12000,1,'MEGHA',NULL),
(41,70,'TUTN-23',23,'TUTN','TUTN-23',23,'4','/2','/12000','2023-05-09','Cash','',0,0,12000,12000,1,'MEGHA',NULL),
(42,28,'TRSP-18',18,'TRSP','TRSP-18',18,'13','/11','/','2023-05-09','Cash','',0,0,0,0,1,'MEGHA',NULL),
(43,28,'TUTN-24',24,'TUTN','TUTN-24',24,'6','/4','/10000','2023-05-09','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(46,19,'TUTN-26',26,'TUTN','TUTN-26',26,'6','/4','/10000','2023-05-16','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(47,19,'TRSP-20',20,'TRSP','TRSP-20',20,'9','/7','/0','2023-05-16','Cash','',0,0,0,0,1,'MEGHA',NULL),
(48,21,'TUTN-27',27,'TUTN','TUTN-27',27,'6','/4','/10000','2023-05-16','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(49,21,'TRSP-21',21,'TRSP','TRSP-21',21,'9','/7','/0','2023-05-16','Cash','',0,0,0,0,1,'MEGHA',NULL),
(50,13,'TUTN-28',28,'TUTN','TUTN-28',28,'6','/4','/10000','2023-05-26','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(51,13,'TRSP-22',22,'TRSP','TRSP-22',22,'7','/5','/','2023-05-26','Cash','',0,0,0,0,1,'MEGHA',NULL),
(52,72,'TUTN-29',29,'TUTN','TUTN-29',29,'4','/2','/6500','2023-05-27','Online','',0,0,6500,6500,1,'MEGHA',NULL),
(53,73,'TUTN-30',30,'TUTN','TUTN-30',30,'5','/3','/13000','2023-05-29','Online','',0,0,13000,13000,1,'MEGHA',NULL),
(54,73,'TRSP-23',23,'TRSP','TRSP-23',23,'7','/5','/4000','2023-05-29','Online','',0,0,4000,4000,1,'MEGHA',NULL),
(55,74,'TUTN-31',31,'TUTN','TUTN-31',31,'5','/3','/5000','2023-05-29','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(56,74,'TRSP-24',24,'TRSP','TRSP-24',24,'8','/6','/','2023-05-29','Cash','',0,0,0,0,1,'MEGHA',NULL),
(57,75,'TUTN-32',32,'TUTN','TUTN-32',32,'5','/3','/5000','2023-05-29','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(58,75,'TRSP-25',25,'TRSP','TRSP-25',25,'8','/6','/','2023-05-29','Cash','',0,0,0,0,1,'MEGHA',NULL),
(59,77,'TUTN-33',33,'TUTN','TUTN-33',33,'5','/3','/13000','2023-05-30','Cash','',0,0,13000,13000,1,'MEGHA',NULL),
(71,85,'TRSP-31',31,'TRSP','TRSP-31',31,'11','/9','/','2023-05-30','Cash','',0,0,0,0,1,'MEGHA',NULL),
(72,85,'TUTN-40',40,'TUTN','TUTN-40',40,'4','/2','/10000','2023-05-30','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(210,101,'TRSP-95',95,'TRSP','TRSP-95',95,'16','/14','/3500','2024-01-24','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(197,101,'TUTN-106',106,'TUTN','TUTN-106',106,'5','/3','/6500','2023-06-26','Cash','',0,0,6500,6500,1,'MEGHA',NULL),
(81,91,'TRSP-36',36,'TRSP','TRSP-36',36,'14','/12','/00','2023-05-31','Cash','',0,0,0,0,1,'MEGHA',NULL),
(82,91,'TUTN-45',45,'TUTN','TUTN-45',45,'5','/3','/1000','2023-05-31','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(202,101,'TRSP-91',91,'TRSP','TRSP-91',91,'16','/14','/3500','2024-01-24','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(203,101,'TUTN-109',109,'TUTN','TUTN-109',109,'5','/3','/7500','2024-01-24','Cash','',0,0,7500,7500,1,'MEGHA',NULL),
(68,83,'TUTN-38',38,'TUTN','TUTN-38',38,'4','/2','/10000','2023-06-03','Online','',0,0,10000,10000,1,'MEGHA',NULL),
(69,84,'TUTN-39',39,'TUTN','TUTN-39',39,'5','/3','/5000','2023-06-02','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(70,84,'TRSP-30',30,'TRSP','TRSP-30',30,'10','/8','/','2023-06-02','Cash','',0,0,0,0,1,'MEGHA',NULL),
(73,26,'TRSP-32',32,'TRSP','TRSP-32',32,'13','/11','/','2023-06-05','Online','',0,0,0,0,1,'MEGHA',NULL),
(74,26,'TUTN-41',41,'TUTN','TUTN-41',41,'6','/4','/10000','2023-06-05','Online','',0,0,10000,10000,1,'MEGHA',NULL),
(75,89,'TUTN-42',42,'TUTN','TUTN-42',42,'4','/2','/8000','2023-06-08','Cash','',0,0,8000,8000,1,'MEGHA',NULL),
(76,89,'TRSP-33',33,'TRSP','TRSP-33',33,'7','/5','/2000','2023-06-08','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(77,87,'TUTN-43',43,'TUTN','TUTN-43',43,'6','/4','/4000','2023-06-08','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(78,87,'TRSP-34',34,'TRSP','TRSP-34',34,'11','/9','/','2023-06-08','Cash','',0,0,0,0,1,'MEGHA',NULL),
(79,88,'TUTN-44',44,'TUTN','TUTN-44',44,'6','/4','/4000','2023-06-08','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(80,88,'TRSP-35',35,'TRSP','TRSP-35',35,'11','/9','/','2023-06-08','Cash','',0,0,0,0,1,'MEGHA',NULL),
(83,91,'TRSP-37',37,'TRSP','TRSP-37',37,'14','/12','/2500','2023-06-10','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(84,91,'TUTN-46',46,'TUTN','TUTN-46',46,'5','/3','/7500','2023-06-10','Cash','',0,0,7500,7500,1,'MEGHA',NULL),
(85,86,'TUTN-47',47,'TUTN','TUTN-47',47,'6','/4','/10000','2023-06-10','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(86,92,'TUTN-48',48,'TUTN','TUTN-48',48,'4','/2','/7500','2023-06-16','Cash','',0,0,7500,7500,1,'MEGHA',NULL),
(87,92,'TRSP-38',38,'TRSP','TRSP-38',38,'13','/11','/','2023-06-16','Cash','',0,0,0,0,1,'MEGHA',NULL),
(88,93,'TUTN-49',49,'TUTN','TUTN-49',49,'4','/2','/6500','2023-06-19','Cash','',0,0,6500,6500,1,'MEGHA',NULL),
(89,93,'TRSP-39',39,'TRSP','TRSP-39',39,'13','/11','/2300','2023-06-19','Cash','',0,0,2300,2300,1,'MEGHA',NULL),
(90,94,'TUTN-50',50,'TUTN','TUTN-50',50,'4','/2','/6000','2023-06-20','Cash','',0,0,6000,6000,1,'MEGHA',NULL),
(91,94,'TRSP-40',40,'TRSP','TRSP-40',40,'14','/12','/2500','2023-06-20','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(92,90,'TUTN-51',51,'TUTN','TUTN-51',51,'4','/2','/6000','2023-06-23','Cash','',0,0,6000,6000,1,'MEGHA',NULL),
(93,90,'TRSP-41',41,'TRSP','TRSP-41',41,'7','/5','/1000','2023-06-23','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(94,76,'TUTN-52',52,'TUTN','TUTN-52',52,'5','/3','/7000','2023-06-23','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(95,76,'TRSP-42',42,'TRSP','TRSP-42',42,'7','/5','/1000','2023-06-23','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(199,102,'TUTN-107',107,'TUTN','TUTN-107',107,'5','/3','/5000','2023-05-30','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(198,102,'TRSP-89',89,'TRSP','TRSP-89',89,'16','/14','/','2023-05-30','Cash','',0,0,0,0,1,'MEGHA',NULL),
(98,95,'TUTN-54',54,'TUTN','TUTN-54',54,'6','/4','/10000','2023-06-26','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(99,96,'TUTN-55',55,'TUTN','TUTN-55',55,'4','/2','/10000','2023-06-24','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(100,96,'TRSP-44',44,'TRSP','TRSP-44',44,'11','/9','/','2023-06-24','Cash','',0,0,0,0,1,'MEGHA',NULL),
(101,97,'TUTN-56',56,'TUTN','TUTN-56',56,'5','/3','/14000','2023-06-26','Cash','',0,0,14000,14000,1,'MEGHA',NULL),
(102,97,'TRSP-45',45,'TRSP','TRSP-45',45,'17','/15','/4500','2023-06-26','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(106,87,'TRSP-46',46,'TRSP','TRSP-46',46,'11','/9','/2000','2023-06-30','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(105,87,'TUTN-57',57,'TUTN','TUTN-57',57,'6','/4','/3000','2023-06-30','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(107,88,'TUTN-58',58,'TUTN','TUTN-58',58,'6','/4','/3000','2023-06-30','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(108,88,'TRSP-47',47,'TRSP','TRSP-47',47,'11','/9','/2000','2023-06-30','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(192,103,'TRSP-86',86,'TRSP','TRSP-86',86,'10','/8','/','2023-07-07','Cash','',0,0,0,0,1,'MEGHA',NULL),
(193,103,'TUTN-104',104,'TUTN','TUTN-104',104,'5','/3','/2000','2023-07-07','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(111,84,'TUTN-60',60,'TUTN','TUTN-60',60,'5','/3','/3000','2023-07-08','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(112,84,'TRSP-49',49,'TRSP','TRSP-49',49,'10','/8','/2000','2023-07-08','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(113,62,'TUTN-61',61,'TUTN','TUTN-61',61,'6','/4','/3000','2023-07-10','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(114,62,'TRSP-50',50,'TRSP','TRSP-50',50,'11','/9','/3000','2023-07-10','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(115,68,'TUTN-62',62,'TUTN','TUTN-62',62,'5','/3','/9000','2023-07-28','Cash','',0,0,9000,9000,1,'MEGHA',NULL),
(116,68,'TRSP-51',51,'TRSP','TRSP-51',51,'9','/7','/4500','2023-07-28','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(117,42,'TUTN-63',63,'TUTN','TUTN-63',63,'5','/3','/5000','2023-08-03','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(118,75,'TUTN-64',64,'TUTN','TUTN-64',64,'5','/3','/3500','2023-08-04','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(119,75,'TRSP-52',52,'TRSP','TRSP-52',52,'8','/6','/1500','2023-08-04','Cash','',0,0,1500,1500,1,'MEGHA',NULL),
(120,74,'TUTN-65',65,'TUTN','TUTN-65',65,'5','/3','/3500','2023-08-04','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(121,74,'TRSP-53',53,'TRSP','TRSP-53',53,'8','/6','/1500','2023-08-04','Cash','',0,0,1500,1500,1,'MEGHA',NULL),
(122,99,'TUTN-66',66,'TUTN','TUTN-66',66,'4','/2','/7000','2023-08-05','Online','',0,0,7000,7000,1,'MEGHA',NULL),
(123,99,'TRSP-54',54,'TRSP','TRSP-54',54,'12','/10','/3000','2023-08-05','Online','',0,0,3000,3000,1,'MEGHA',NULL),
(124,100,'TUTN-67',67,'TUTN','TUTN-67',67,'6','/4','/10000','2023-08-05','Cash','',0,0,10000,10000,1,'MEGHA',NULL),
(125,57,'TUTN-68',68,'TUTN','TUTN-68',68,'6','/4','/5000','2023-08-08','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(126,57,'TRSP-55',55,'TRSP','TRSP-55',55,'10','/8','/','2023-08-08','Cash','',0,0,0,0,1,'MEGHA',NULL),
(127,57,'TUTN-69',69,'TUTN','TUTN-69',69,'6','/4','/3000','2023-08-08','Online','',0,0,3000,3000,1,'MEGHA',NULL),
(128,57,'TRSP-56',56,'TRSP','TRSP-56',56,'10','/8','/3000','2023-08-08','Online','',0,0,3000,3000,1,'MEGHA',NULL),
(131,63,'TUTN-71',71,'TUTN','TUTN-71',71,'6','/4','/4000','2023-08-09','Online','',0,0,4000,4000,1,'MEGHA',NULL),
(132,63,'TRSP-58',58,'TRSP','TRSP-58',58,'13','/11','/1000','2023-08-09','Online','',0,0,1000,1000,1,'MEGHA',NULL),
(133,89,'TUTN-72',72,'TUTN','TUTN-72',72,'4','/2','/5000','2023-08-18','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(134,89,'TRSP-59',59,'TRSP','TRSP-59',59,'7','/5','/2000','2023-08-18','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(135,85,'TRSP-60',60,'TRSP','TRSP-60',60,'11','/9','/7000','2023-08-24','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(136,85,'TUTN-73',73,'TUTN','TUTN-73',73,'4','/2','/3000','2023-08-24','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(137,92,'TUTN-74',74,'TUTN','TUTN-74',74,'4','/2','/5500','2023-08-24','Cash','',0,0,5500,5500,1,'MEGHA',NULL),
(138,92,'TRSP-61',61,'TRSP','TRSP-61',61,'13','/11','/4500','2023-08-24','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(194,103,'TRSP-87',87,'TRSP','TRSP-87',87,'10','/8','/2000','2023-07-19','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(195,103,'TUTN-105',105,'TUTN','TUTN-105',105,'5','/3','/4000','2023-07-19','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(149,96,'TUTN-80',80,'TUTN','TUTN-80',80,'4','/2','/3000','2023-08-29','Online','',0,0,3000,3000,1,'MEGHA',NULL),
(142,61,'TRSP-63',63,'TRSP','TRSP-63',63,'16','/14','/','2023-08-28','Cash','',0,0,0,0,1,'MEGHA',NULL),
(148,61,'TRSP-66',66,'TRSP','TRSP-66',66,'16','/14','/','2023-08-28','Cash','',0,0,0,0,1,'MEGHA',NULL),
(147,61,'TUTN-79',79,'TUTN','TUTN-79',79,'6','/4','/5000','2023-08-28','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(145,84,'TUTN-78',78,'TUTN','TUTN-78',78,'5','/3','/6000','2023-08-28','Cash','',0,0,6000,6000,1,'MEGHA',NULL),
(146,84,'TRSP-65',65,'TRSP','TRSP-65',65,'10','/8','/4000','2023-08-28','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(150,96,'TRSP-67',67,'TRSP','TRSP-67',67,'11','/9','/7000','2023-08-29','Online','',0,0,7000,7000,1,'MEGHA',NULL),
(151,62,'TUTN-81',81,'TUTN','TUTN-81',81,'6','/4','/7000','2023-08-31','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(152,62,'TRSP-68',68,'TRSP','TRSP-68',68,'11','/9','/4000','2023-08-31','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(153,19,'TUTN-82',82,'TUTN','TUTN-82',82,'6','/4','/5000','2023-09-01','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(154,19,'TRSP-69',69,'TRSP','TRSP-69',69,'9','/7','/4500','2023-09-01','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(155,21,'TUTN-83',83,'TUTN','TUTN-83',83,'6','/4','/5000','2023-09-01','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(156,21,'TRSP-70',70,'TRSP','TRSP-70',70,'9','/7','/4500','2023-09-01','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(157,93,'TUTN-84',84,'TUTN','TUTN-84',84,'4','/2','/6500','2023-09-01','Cash','',0,0,6500,6500,1,'MEGHA',NULL),
(158,93,'TRSP-71',71,'TRSP','TRSP-71',71,'13','/11','/2200','2023-09-01','Cash','',0,0,2200,2200,1,'MEGHA',NULL),
(159,91,'TRSP-72',72,'TRSP','TRSP-72',72,'14','/12','/2500','2023-09-09','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(160,91,'TUTN-85',85,'TUTN','TUTN-85',85,'5','/3','/5500','2023-09-09','Cash','',0,0,5500,5500,1,'MEGHA',NULL),
(161,95,'TRSP-73',73,'TRSP','TRSP-73',73,'9','/7','/4500','2023-10-05','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(162,95,'TUTN-86',86,'TUTN','TUTN-86',86,'6','/4','/5000','2023-10-05','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(163,61,'TUTN-87',87,'TUTN','TUTN-87',87,'6','/4','/2500','2023-10-05','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(164,61,'TRSP-74',74,'TRSP','TRSP-74',74,'16','/14','/3500','2023-10-05','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(165,99,'TUTN-88',88,'TUTN','TUTN-88',88,'4','/2','/6000','2023-11-07','Cash','',0,0,6000,6000,1,'MEGHA',NULL),
(166,99,'TRSP-75',75,'TRSP','TRSP-75',75,'12','/10','/3500','2023-11-07','Cash','',0,0,3500,3500,1,'MEGHA',NULL),
(167,13,'TUTN-89',89,'TUTN','TUTN-89',89,'6','/4','/5000','2023-11-06','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(168,13,'TRSP-76',76,'TRSP','TRSP-76',76,'7','/5','/4000','2023-11-06','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(169,94,'TUTN-90',90,'TUTN','TUTN-90',90,'4','/2','/7000','2023-11-07','Cash','',0,0,7000,7000,1,'MEGHA',NULL),
(170,94,'TRSP-77',77,'TRSP','TRSP-77',77,'14','/12','/2500','2023-11-07','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(171,28,'TRSP-78',78,'TRSP','TRSP-78',78,'13','/11','/4500','2023-11-20','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(172,28,'TUTN-91',91,'TUTN','TUTN-91',91,'6','/4','/4500','2023-11-20','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(173,72,'TUTN-92',92,'TUTN','TUTN-92',92,'4','/2','/4000','2023-11-20','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(174,87,'TUTN-93',93,'TUTN','TUTN-93',93,'6','/4','/5000','2023-11-20','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(175,87,'TRSP-79',79,'TRSP','TRSP-79',79,'11','/9','/1000','2023-11-20','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(176,88,'TUTN-94',94,'TUTN','TUTN-94',94,'6','/4','/5000','2023-11-20','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(177,88,'TRSP-80',80,'TRSP','TRSP-80',80,'11','/9','/1000','2023-11-20','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(178,42,'TUTN-95',95,'TUTN','TUTN-95',95,'5','/3','/4000','2023-11-22','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(179,26,'TRSP-81',81,'TRSP','TRSP-81',81,'13','/11','/4500','2023-11-27','Cash','',0,0,4500,4500,1,'MEGHA',NULL),
(180,26,'TUTN-96',96,'TUTN','TUTN-96',96,'6','/4','/5000','2023-11-27','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(181,74,'TUTN-97',97,'TUTN','TUTN-97',97,'5','/3','/5500','2023-11-27','Cash','',0,0,5500,5500,1,'MEGHA',NULL),
(182,74,'TRSP-82',82,'TRSP','TRSP-82',82,'8','/6','/3000','2023-11-27','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(183,86,'TUTN-98',98,'TUTN','TUTN-98',98,'6','/4','/5000','2023-12-04','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(184,72,'TUTN-99',99,'TUTN','TUTN-99',99,'4','/2','/2500','2023-12-05','Cash','',0,0,2500,2500,1,'MEGHA',NULL),
(185,87,'TUTN-100',100,'TUTN','TUTN-100',100,'6','/4','/1000','2023-12-30','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(186,87,'TRSP-83',83,'TRSP','TRSP-83',83,'11','/9','/4000','2023-12-30','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(187,88,'TUTN-101',101,'TUTN','TUTN-101',101,'6','/4','/1000','2023-12-30','Cash','',0,0,1000,1000,1,'MEGHA',NULL),
(188,88,'TRSP-84',84,'TRSP','TRSP-84',84,'11','/9','/4000','2023-12-30','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(189,63,'TUTN-102',102,'TUTN','TUTN-102',102,'6','/4','/6000','2023-12-22','Cash','',0,0,6000,6000,1,'MEGHA',NULL),
(190,63,'TRSP-85',85,'TRSP','TRSP-85',85,'13','/11','/','2023-12-22','Cash','',0,0,0,0,1,'MEGHA',NULL),
(191,83,'TUTN-103',103,'TUTN','TUTN-103',103,'4','/2','/3000','2023-12-30','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(200,102,'TRSP-90',90,'TRSP','TRSP-90',90,'16','/14','/2000','2023-08-09','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(201,102,'TUTN-108',108,'TUTN','TUTN-108',108,'5','/3','/4000','2023-08-09','Cash','',0,0,4000,4000,1,'MEGHA',NULL),
(204,102,'TRSP-92',92,'TRSP','TRSP-92',92,'16','/14','/5000','2024-01-24','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(205,102,'TUTN-110',110,'TUTN','TUTN-110',110,'5','/3','/5000','2024-01-24','Cash','',0,0,5000,5000,1,'MEGHA',NULL),
(206,103,'TRSP-93',93,'TRSP','TRSP-93',93,'10','/8','/2000','2024-01-24','Cash','',0,0,2000,2000,1,'MEGHA',NULL),
(207,103,'TUTN-111',111,'TUTN','TUTN-111',111,'5','/3','/8000','2024-01-24','Cash','',0,0,8000,8000,1,'MEGHA',NULL),
(208,75,'TUTN-112',112,'TUTN','TUTN-112',112,'5','/3','/5500','2024-01-24','Cash','',0,0,5500,5500,1,'MEGHA',NULL),
(209,75,'TRSP-94',94,'TRSP','TRSP-94',94,'8','/6','/3000','2024-01-24','Cash','',0,0,3000,3000,1,'MEGHA',NULL),
(216,105,'TUTN-115',115,'TUTN','TUTN-115',115,'6','/4','/15000','2023-08-29','Cash','',0,0,15000,15000,1,'MEGHA',NULL),
(215,105,'TRSP-98',98,'TRSP','TRSP-98',98,'7','/5','/4500','2023-08-29','Cash','',0,0,4500,4500,1,'MEGHA',NULL);
/*!40000 ALTER TABLE `paid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees_delete`
--
DROP TABLE IF EXISTS `paid_fees_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees_delete` (
`Fees_id` bigint(20) NOT NULL DEFAULT 0,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_No` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Subhead_Ids` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Sub_Amounts` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`DateNumber` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Message` varchar(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees_delete`
--
LOCK TABLES `paid_fees_delete` WRITE;
/*!40000 ALTER TABLE `paid_fees_delete` DISABLE KEYS */;
INSERT INTO `paid_fees_delete` VALUES
(160,23,'TUTN-86',86,'TUTN','TUTN-86',86,'5','/3','/3500','2022-11-08','Cash','',0,0,3500,3500,1,'MEGHA','2022-11-08 10:55 42'),
(159,23,'TUTN-85',85,'TUTN','TUTN-85',85,'5','/3','/3500','2022-11-08','Cash','',0,0,3500,3500,1,'MEGHA','2022-11-08 10:56 07'),
(156,48,'TRSP-60',60,'TRSP','TRSP-60',60,'9','/7','/1000','2022-11-04','Cash','',0,0,1000,1000,1,'MEGHA','2022-11-17 06:07 14'),
(157,48,'TUTN-83',83,'TUTN','TUTN-83',83,'4','/2','/3000','2022-11-04','Cash','',0,0,3000,3000,1,'MEGHA','2022-11-17 06:07 19'),
(191,53,'TUTN-103',103,'TUTN','TUTN-103',103,'4','/2','/5000','2022-12-16','Cash','',0,0,5000,5000,1,'MEGHA','2022-12-20 05:33 51'),
(190,53,'TRSP-74',74,'TRSP','TRSP-74',74,'18','/17','/3500','2022-12-16','Cash','',0,0,3500,3500,1,'MEGHA','2022-12-20 05:33 56'),
(27,12,'TUTN-11',11,'TUTN','TUTN-11',11,'4','/2','/1000','2022-06-27','Cash','',0,0,1000,1000,1,'PSNS','2022-12-27 05:33 44'),
(28,12,'TRSP-6',6,'TRSP','TRSP-6',6,'7','/5','/','2022-06-27','Cash','',0,0,0,0,1,'PSNS','2022-12-27 05:34 00'),
(29,12,'TUTN-12',12,'TUTN','TUTN-12',12,'4','/2','/4000','2022-07-06','Cash','',0,0,4000,4000,1,'PSNS','2022-12-27 05:34 05'),
(30,12,'TRSP-7',7,'TRSP','TRSP-7',7,'7','/5','/','2022-07-06','Cash','',0,0,0,0,1,'PSNS','2022-12-27 05:34 11'),
(99,12,'TUTN-53',53,'TUTN','TUTN-53',53,'4','/2','/1500','2022-08-04','Cash','',0,0,1500,1500,1,'PSNS','2022-12-27 05:34 14'),
(100,12,'TRSP-35',35,'TRSP','TRSP-35',35,'7','/5','/2000','2022-08-04','Cash','',0,0,2000,2000,1,'PSNS','2022-12-27 05:34 17'),
(181,12,'TUTN-98',98,'TUTN','TUTN-98',98,'4','/2','/3000','2022-11-30','Cash','',0,0,3000,3000,1,'MEGHA','2022-12-27 05:34 20'),
(182,12,'TRSP-70',70,'TRSP','TRSP-70',70,'7','/5','/1000','2022-11-30','Cash','',0,0,1000,1000,1,'MEGHA','2022-12-27 05:34 23'),
(132,24,'TRSP-48',48,'TRSP','TRSP-48',48,'11','/9','/','2022-09-10','Cash','',0,0,0,0,1,'MEGHA','2023-04-01 15:31 32'),
(130,24,'TRSP-47',47,'TRSP','TRSP-47',47,'11','/9','/','2022-09-10','Online','',0,0,0,0,1,'MEGHA','2023-04-01 15:31 48'),
(217,56,'TUTN-118',118,'TUTN','TUTN-118',118,'4','/2','/2500','2023-01-13','Cash','',0,0,2500,2500,1,'MEGHA','2023-04-05 06:23 46'),
(50,29,'TUTN-24',24,'TUTN','TUTN-24',24,'6','/4','/7000','2022-05-10','Cash','',0,0,7000,7000,1,'PSNS','2023-04-20 05:26 57'),
(51,29,'TRSP-16',16,'TRSP','TRSP-16',16,'16','/14','/3500','2022-05-10','Cash','',0,0,3500,3500,1,'PSNS','2023-04-20 05:27 00'),
(106,29,'TRSP-37',37,'TRSP','TRSP-37',37,'16','/14','/1000','2022-08-10','Online','',0,0,1000,1000,1,'MEGHA','2023-04-20 05:27 04'),
(105,29,'TUTN-55',55,'TUTN','TUTN-55',55,'6','/4','/3500','2022-08-10','Online','',0,0,3500,3500,1,'MEGHA','2023-04-20 05:28 04'),
(152,29,'TUTN-81',81,'TUTN','TUTN-81',81,'6','/4','/3500','2022-11-01','Online','',0,0,3500,3500,1,'MEGHA','2023-04-20 05:28 08'),
(153,29,'TRSP-58',58,'TRSP','TRSP-58',58,'16','/14','/2500','2022-11-01','Online','',0,0,2500,2500,1,'MEGHA','2023-04-20 05:28 10'),
(76,30,'TUTN-40',40,'TUTN','TUTN-40',40,'6','/4','/7000','2022-05-16','Cash','',0,0,7000,7000,1,'PSNS','2023-04-20 05:28 40'),
(77,30,'TRSP-25',25,'TRSP','TRSP-25',25,'11','/9','/3500','2022-05-16','Cash','',0,0,3500,3500,1,'PSNS','2023-04-20 05:28 44'),
(144,30,'TUTN-77',77,'TUTN','TUTN-77',77,'6','/4','/7000','2022-09-27','Cash','',0,0,7000,7000,1,'MEGHA','2023-04-20 05:28 47'),
(145,30,'TRSP-54',54,'TRSP','TRSP-54',54,'11','/9','/3500','2022-09-27','Cash','',0,0,3500,3500,1,'MEGHA','2023-04-20 05:28 51'),
(31,32,'TUTN-13',13,'TUTN','TUTN-13',13,'6','/4','/3000','2022-05-18','Cash','',0,0,3000,3000,1,'PSNS','2023-04-20 05:29 49'),
(32,32,'TRSP-8',8,'TRSP','TRSP-8',8,'11','/9','/','2022-05-18','Cash','',0,0,0,0,1,'PSNS','2023-04-20 05:29 53'),
(33,32,'TUTN-14',14,'TUTN','TUTN-14',14,'6','/4','/4000','2022-05-30','Online','',0,0,4000,4000,1,'PSNS','2023-04-20 05:30 00'),
(34,32,'TRSP-9',9,'TRSP','TRSP-9',9,'11','/9','/3500','2022-05-30','Online','',0,0,3500,3500,1,'PSNS','2023-04-20 05:32 47'),
(124,32,'TUTN-66',66,'TUTN','TUTN-66',66,'6','/4','/5000','2022-08-24','Cash','',0,0,5000,5000,1,'MEGHA','2023-04-20 05:33 02'),
(125,32,'TRSP-45',45,'TRSP','TRSP-45',45,'11','/9','/','2022-08-24','Cash','',0,0,0,0,1,'MEGHA','2023-04-20 05:33 05'),
(128,32,'TRSP-46',46,'TRSP','TRSP-46',46,'11','/9','/','2022-08-24','Cash','',0,0,0,0,1,'MEGHA','2023-04-20 05:33 16'),
(176,32,'TUTN-95',95,'TUTN','TUTN-95',95,'6','/4','/2000','2022-11-25','Cash','',0,0,2000,2000,1,'MEGHA','2023-04-20 05:33 45'),
(177,32,'TRSP-68',68,'TRSP','TRSP-68',68,'11','/9','/3500','2022-11-25','Cash','',0,0,3500,3500,1,'MEGHA','2023-04-20 05:33 57'),
(78,31,'TUTN-41',41,'TUTN','TUTN-41',41,'6','/4','/12500','2022-05-17','Cash','',0,0,12500,12500,1,'PSNS','2023-04-20 05:34 25'),
(79,31,'TRSP-26',26,'TRSP','TRSP-26',26,'11','/9','/7000','2022-05-17','Cash','',0,0,7000,7000,1,'PSNS','2023-04-20 05:34 29'),
(3,27,'TUTN-2',2,'TUTN','TUTN-2',2,'6','/4','/14000','2023-04-25','Cash','',0,0,14000,14000,1,'MEGHA','2023-05-06 06:15 31'),
(4,27,'TRSP-2',2,'TRSP','TRSP-2',2,'14','/12','/5000','2023-04-25','Cash','',0,0,5000,5000,1,'MEGHA','2023-05-06 06:15 37'),
(9,27,'TRSP-5',5,'TRSP','TRSP-5',5,'14','/12','/-500','2023-04-25','Cash','',0,0,-500,-500,1,'MEGHA','2023-05-06 06:15 43'),
(12,63,'TUTN-6',6,'TUTN','TUTN-6',6,'6','/4','/3000','2023-05-02','Cash','',0,0,3000,3000,1,'MEGHA','2023-05-06 06:26 27'),
(13,63,'TRSP-6',6,'TRSP','TRSP-6',6,'13','/11','/','2023-05-02','Cash','',0,0,0,0,1,'MEGHA','2023-05-06 06:26 32'),
(11,27,'TRSP-5',5,'TRSP','TRSP-5',5,'14','/12','/5000','2023-04-25','Cash','',0,0,5000,5000,1,'MEGHA','2023-05-06 06:52 07'),
(10,27,'TUTN-5',5,'TUTN','TUTN-5',5,'6','/4','/14000','2023-04-25','Cash','',0,0,14000,14000,1,'MEGHA','2023-05-06 06:52 11'),
(35,66,'TRSP-15',15,'TRSP','TRSP-15',15,'12','/10','/6500','2023-05-08','Online','',0,0,6500,6500,1,'MEGHA','2023-05-11 07:25 52'),
(34,66,'TUTN-19',19,'TUTN','TUTN-19',19,'4','/2','/12000','2023-05-08','Online','',0,0,12000,12000,1,'MEGHA','2023-05-11 07:25 58'),
(61,78,'TRSP-26',26,'TRSP','TRSP-26',26,'11','/9','/','2023-05-30','Cash','',0,0,0,0,1,'MEGHA','2023-06-03 05:37 44'),
(60,78,'TUTN-34',34,'TUTN','TUTN-34',34,'4','/2','/10000','2023-05-30','Cash','',0,0,10000,10000,1,'MEGHA','2023-06-03 05:37 50'),
(65,82,'TRSP-28',28,'TRSP','TRSP-28',28,'14','/12','/0','2023-05-31','Cash','',0,0,0,0,1,'MEGHA','2023-06-10 04:42 29'),
(64,82,'TUTN-36',36,'TUTN','TUTN-36',36,'5','/3','/1000','2023-05-31','Cash','',0,0,1000,1000,1,'MEGHA','2023-06-10 04:42 33'),
(103,87,'TUTN-57',57,'TUTN','TUTN-57',57,'6','/4','/3000','2023-07-30','Cash','',0,0,3000,3000,1,'MEGHA','2023-07-01 05:15 28'),
(104,87,'TRSP-46',46,'TRSP','TRSP-46',46,'11','/9','/2000','2023-07-30','Cash','',0,0,2000,2000,1,'MEGHA','2023-07-01 05:15 34'),
(141,61,'TUTN-76',76,'TUTN','TUTN-76',76,'6','/4','/5000','2023-08-28','Cash','',0,0,5000,5000,1,'MEGHA','2023-08-28 06:26 51'),
(143,61,'TUTN-77',77,'TUTN','TUTN-77',77,'6','/4','/5000','2023-08-28','Cash','',0,0,5000,5000,1,'MEGHA','2023-08-28 06:27 02'),
(144,61,'TRSP-64',64,'TRSP','TRSP-64',64,'16','/14','/','2023-08-28','Cash','',0,0,0,0,1,'MEGHA','2023-08-28 06:27 11'),
(96,43,'TUTN-53',53,'TUTN','TUTN-53',53,'5','/3','/6500','2023-06-26','Cash','',0,0,6500,6500,1,'MEGHA','2024-01-22 07:46 46'),
(97,43,'TRSP-43',43,'TRSP','TRSP-43',43,'16','/14','/3500','2023-06-26','Cash','',0,0,3500,3500,1,'MEGHA','2024-01-22 07:46 52'),
(62,81,'TUTN-35',35,'TUTN','TUTN-35',35,'5','/3','/5000','2023-05-30','Cash','',0,0,5000,5000,1,'MEGHA','2024-01-22 07:47 34'),
(63,81,'TRSP-27',27,'TRSP','TRSP-27',27,'16','/14','/','2023-05-30','Cash','',0,0,0,0,1,'MEGHA','2024-01-22 07:47 40'),
(129,81,'TUTN-70',70,'TUTN','TUTN-70',70,'5','/3','/4000','2023-08-09','Cash','',0,0,4000,4000,1,'MEGHA','2024-01-22 07:47 44'),
(130,81,'TRSP-57',57,'TRSP','TRSP-57',57,'16','/14','/2000','2023-08-09','Cash','',0,0,2000,2000,1,'MEGHA','2024-01-22 07:47 49'),
(140,98,'TRSP-62',62,'TRSP','TRSP-62',62,'10','/8','/2000','2023-07-19','Cash','',0,0,2000,2000,1,'MEGHA','2024-01-22 07:48 38'),
(110,98,'TRSP-48',48,'TRSP','TRSP-48',48,'10','/8','/','2023-07-07','Cash','',0,0,0,0,1,'MEGHA','2024-01-22 07:48 49'),
(139,98,'TUTN-75',75,'TUTN','TUTN-75',75,'5','/3','/4000','2023-07-19','Cash','',0,0,4000,4000,1,'MEGHA','2024-01-22 07:48 54'),
(109,98,'TUTN-59',59,'TUTN','TUTN-59',59,'5','/3','/2000','2023-07-07','Cash','',0,0,2000,2000,1,'MEGHA','2024-01-22 07:49 05'),
(67,20,'TUTN-37',37,'TUTN','TUTN-37',37,'6','/4','/14000','2023-06-02','Cash','',0,0,14000,14000,1,'MEGHA','2024-01-24 09:18 02'),
(66,20,'TRSP-29',29,'TRSP','TRSP-29',29,'7','/5','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'MEGHA','2024-01-24 09:18 08'),
(196,101,'TRSP-88',88,'TRSP','TRSP-88',88,'16','/14','/3500','2023-06-26','Cash','',0,0,3500,3500,1,'MEGHA','2024-02-01 05:40 26'),
(7,60,'TUTN-4',4,'TUTN','TUTN-4',4,'5','/3','/13000','2023-04-19','Online','',0,0,13000,13000,1,'MEGHA','2024-03-10 17:11 16'),
(8,60,'TRSP-4',4,'TRSP','TRSP-4',4,'19','/18','/6500','2023-04-19','Online','',0,0,6500,6500,1,'MEGHA','2024-03-10 17:11 22'),
(211,104,'TRSP-96',96,'TRSP','TRSP-96',96,'7','/5','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'MEGHA','2024-03-11 08:26 23'),
(212,104,'TUTN-113',113,'TUTN','TUTN-113',113,'6','/4','/14000','2023-06-02','Cash','',0,0,14000,14000,1,'MEGHA','2024-03-11 08:26 28');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES
(2,'Transactions'),
(3,'Income'),
(4,'Expense'),
(5,'Accounts'),
(6,'Track Budget'),
(7,'Set Goals'),
(8,'Calendar'),
(9,'Income Category'),
(10,'Expense Category'),
(11,'Income Reports'),
(12,'Expense Category'),
(13,'Income vs Expense Reports'),
(14,'Income Monthly Report'),
(15,'Expense Monthly Report'),
(16,'Account Transaction Reports'),
(17,'User Role'),
(18,'Application Setting'),
(19,'Upcoming Income'),
(20,'Upcoming Expense');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
INSERT INTO `roleaccess` VALUES
(18,2,1),
(19,3,1),
(20,4,1),
(21,5,1),
(22,6,1),
(23,7,1),
(24,8,1),
(25,9,1),
(26,10,1),
(27,11,1),
(28,12,1),
(29,13,1),
(30,14,1),
(31,15,1),
(32,16,1),
(33,17,1),
(34,18,1),
(35,19,1),
(36,20,1);
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_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,'Evi money','Batam','Golden Land Btams','E vision infotech','0898999893434','mplogo.png','Rs','en','d/m/Y');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stud_basic`
--
LOCK TABLES `stud_basic` WRITE;
/*!40000 ALTER TABLE `stud_basic` DISABLE KEYS */;
INSERT INTO `stud_basic` VALUES
('VRUSHAB N BALIKAI',42,'Male','LKG','A','7',7006215953,'','Only for two months transport fees applied',1,NULL),
('MohammadHussain ',103,'Male','LKG','A','28',0,'',NULL,0,NULL),
('Prajwal Talwar',75,'Male','LKG','A','15',9611183089,'',NULL,1,NULL),
('Ashwita Mathapati',88,'Male','UKG','A','21',9538144510,'',NULL,1,NULL),
('Saheet R Bill',102,'Male','LKG','A','',0,'',NULL,0,NULL),
('Veernagouda M Chikkangoudar',8,'','LKG','A','2',9900554815,'','1000 concession appplied',1,NULL),
('Tanushree Chikkappanavar',83,'Male','NURSRY','A','25',6362951206,'',NULL,1,NULL),
('Arohi S Dandavatimath',77,'Male','LKG','A','16',7353605352,'','1000 concession applied',1,NULL),
('Shravan Talwar',74,'Male','LKG','A','14',9611183089,'',NULL,1,NULL),
('Sannidhi S Huded',13,'','UKG','A','10',9900272564,'',NULL,1,NULL),
('Anvita Mathapati',87,'Male','UKG','A','20',9538144510,'',NULL,1,NULL),
('Tejas I Tigadi',91,'Male','LKG','A','18',9148340289,'',NULL,1,NULL),
('Sukruta B Rahut',17,'','UKG','A','14',8073015807,'','1000 concession applied',1,NULL),
('Vaishnavi G Ballodi',19,'','UKG','A','16',9113643850,'',NULL,1,NULL),
('Vaibhavi Ambali',105,'Male','UKG','A','',0,'','',0,NULL),
('Vishwanath P Ballodi',21,'','UKG','A','18',9731721597,'','',1,NULL),
('Shivam Kasali',23,'','UKG','A','20',9380701793,'','1000 concession applied',1,NULL),
('Devi S Mareppagol',76,'Male','LKG','A','28',7795626791,'','van for only half trem',1,NULL),
('Harshita M Beedi',26,'','UKG','A','23',9880557197,'',NULL,1,NULL),
('Samanvi P Sangammanavar',28,'','UKG','A','25',9113522951,'','500 concession applied',1,NULL),
('Shreyas Hudali',59,'Male','NURSRY','A','02',9148318776,'','1000 concession applied',1,NULL),
('Sahana Yaraguddi',64,'Male','UKG','A','08',9902419596,'','1000 concession applied',1,NULL),
('Nakshathra I Tulajannavar',94,'Male','NURSRY','A','25',8105390849,'',NULL,1,NULL),
('Manikanta N Koladur',92,'Male','NURSRY','A','23',9901625476,'',NULL,1,NULL),
('Amit C Bhavikatti',73,'Male','LKG','A','13',7483818630,'','1000 concession',1,NULL),
('Advik I Angadi',85,'Male','NURSRY','A','17',8792555929,'',NULL,1,NULL),
('Naveen N Kedari',84,'Male','LKG','A','19',9535653164,'',NULL,1,NULL),
('Pratham N Somanatti',72,'Male','NURSRY','A','',8861023914,'',NULL,1,NULL),
('Satvik Y Ballodi',52,'Male','LKG','A','41',9380704901,'','1000 concession applied',1,NULL),
('Sachin B Mareppanavar',54,'Male','UKG','A','42',9741425389,'','1000 concession applied',1,NULL),
('Vihan Ambalimath',86,'Male','UKG','A','31',9845171872,'',NULL,1,NULL),
('Samarthgoud V Patil',57,'Male','UKG','A','1',9741756605,'',NULL,1,NULL),
('Pruthvi Nalafaroshi',93,'Male','LKG','A','24',9902714649,'',NULL,1,NULL),
('Sandeep B Khilari',58,'Male','UKG','A','7',7899510490,'','1000 concession applied',1,NULL),
('Prince Mareppagol',90,'Male','NURSRY','A','28',7338456791,'','',1,NULL),
('Nandan Hanamantgol',89,'Male','NURSRY','A','19',9113098458,'',NULL,1,NULL),
('Veda I Bhadri',61,'Male','UKG','A','04',9844707664,'',NULL,1,NULL),
('Khushi S Munenni',62,'Male','UKG','A','05',8126404258,'',NULL,1,NULL),
('Sakshi Karaveeranavar',63,'Male','UKG','A','06',9164303578,'',NULL,1,NULL),
('Anvita Rahut',65,'Male','UKG','A','08',9632878952,'','1000 concession applied',1,NULL),
('Adhvit Rahut',71,'Male','LKG','A','07',9632878952,'','1000 concession applied',1,NULL),
('Satvik Deyannavar',67,'Male','UKG','A','09',8951486224,'','1000 concession applied',1,NULL),
('Sandeep Gajamanal',68,'Male','LKG','A','10',9980346542,'',NULL,1,NULL),
('Manoj Khilari',69,'Male','NURSRY','A','11',7899510490,'','1000 concession applied',1,NULL),
('Vaishnavi Pujeri',70,'Male','NURSRY','A','12',9149583863,'','1000 concession applied',1,NULL),
('Samanvi S Patil',95,'Male','UKG','A','48',9538352069,'',NULL,1,NULL),
('Vikrant M Janagonda',96,'Male','NURSRY','A','47',9886556970,'',NULL,1,NULL),
('Bhoomika V Kotagi',97,'Male','LKG','A','49',9844112120,'',NULL,1,NULL),
('Sachit Kulkarni',101,'Male','LKG','A','8',9740465579,'',NULL,0,NULL),
('Siddharth Bailawad ',99,'Male','NURSRY','A','29',8904242210,'',NULL,1,NULL),
('Mayuri Hammannavar',100,'Male','UKG','A','30',9611183089,'','came school for 1month only [5000]',1,NULL);
/*!40000 ALTER TABLE `stud_basic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic2`
--
DROP TABLE IF EXISTS `stud_basic2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic2` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discount` bigint(20) NOT NULL,
`discription` varchar(200) NOT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stud_basic2`
--
LOCK TABLES `stud_basic2` WRITE;
/*!40000 ALTER TABLE `stud_basic2` DISABLE KEYS */;
INSERT INTO `stud_basic2` VALUES
(1,54,18,17,7000,7000,0,0,''),
(6,8,5,3,13000,13000,0,1000,''),
(5,54,6,4,14000,14000,0,1000,''),
(7,42,5,3,14000,14000,0,0,''),
(27,64,14,12,5000,5000,0,0,''),
(9,23,6,4,14000,14000,0,1000,''),
(10,52,5,3,13000,13000,0,1000,''),
(11,57,6,4,15000,15000,0,0,''),
(12,57,10,8,6000,6000,0,0,''),
(26,64,6,4,14000,14000,0,1000,''),
(14,58,6,4,14000,14000,0,1000,''),
(15,59,4,2,12000,12000,0,1000,''),
(16,59,14,12,5000,5000,0,0,''),
(117,105,7,5,4500,4500,0,-500,''),
(19,61,6,4,15000,15000,0,0,''),
(20,61,16,14,7000,7000,0,0,''),
(21,62,6,4,15000,15000,0,0,''),
(22,62,11,9,7000,7000,0,0,''),
(23,63,6,4,15000,15000,0,0,''),
(24,63,13,11,4500,4500,0,0,''),
(25,52,17,15,4500,4500,0,0,''),
(28,17,6,4,14000,14000,0,1000,''),
(29,17,12,10,6500,6500,0,0,''),
(30,65,6,4,14000,14000,0,1000,''),
(31,65,12,10,6500,6500,0,0,''),
(44,71,12,10,6500,6500,0,0,''),
(43,71,5,3,13000,13000,0,1000,''),
(34,67,6,4,14000,14000,0,1000,''),
(35,67,12,10,6500,6500,0,0,''),
(36,68,5,3,14000,14000,0,0,''),
(37,68,9,7,4500,4500,0,0,''),
(38,69,4,2,12000,12000,0,1000,''),
(40,70,4,2,12000,12000,0,1000,''),
(41,28,13,11,4500,4500,0,0,''),
(42,28,6,4,14500,14500,0,500,''),
(45,19,6,4,15000,15000,0,0,''),
(46,19,9,7,4500,4500,0,0,''),
(47,21,6,4,15000,15000,0,0,''),
(48,21,9,7,4500,4500,0,0,''),
(107,95,9,7,4500,4500,0,0,''),
(49,13,6,4,15000,15000,0,0,''),
(50,13,7,5,4000,4000,0,0,''),
(51,72,4,2,13000,13000,0,0,''),
(52,73,5,3,13000,13000,0,1000,''),
(53,73,7,5,4000,4000,0,0,''),
(54,74,5,3,14000,14000,0,0,''),
(55,74,8,6,4500,4500,0,0,''),
(56,75,5,3,14000,14000,0,0,''),
(57,75,8,6,4500,4500,0,0,''),
(58,76,5,3,14000,7000,7000,0,''),
(59,76,7,5,2000,1000,1000,2000,''),
(60,77,5,3,13000,13000,0,1000,''),
(77,85,11,9,7000,7000,0,0,''),
(76,85,4,2,13000,13000,0,0,''),
(111,102,16,14,7000,7000,0,0,''),
(110,102,5,3,14000,14000,0,0,''),
(88,91,14,12,5000,5000,0,0,''),
(116,105,6,4,15000,15000,0,0,''),
(71,26,13,11,4500,4500,0,0,''),
(72,26,6,4,15000,15000,0,0,''),
(73,83,4,2,13000,13000,0,0,''),
(74,84,5,3,14000,14000,0,0,''),
(75,84,10,8,6000,6000,0,0,''),
(78,86,6,4,15000,15000,0,0,''),
(79,87,6,4,15000,13000,2000,0,''),
(80,87,11,9,7000,7000,0,0,''),
(81,88,6,4,15000,13000,2000,0,''),
(82,88,11,9,7000,7000,0,0,''),
(83,89,4,2,13000,13000,0,0,''),
(84,89,7,5,4000,4000,0,0,''),
(85,90,4,2,13000,6000,7000,0,''),
(86,90,7,5,2000,1000,1000,2000,''),
(113,103,10,8,6000,4000,2000,0,''),
(87,91,5,3,14000,14000,0,0,''),
(112,103,5,3,14000,14000,0,0,''),
(91,92,4,2,13000,13000,0,0,''),
(92,92,13,11,4500,4500,0,0,''),
(93,93,4,2,13000,13000,0,0,''),
(94,93,13,11,4500,4500,0,0,''),
(95,94,4,2,13000,13000,0,0,''),
(96,94,14,12,5000,5000,0,0,''),
(97,95,6,4,15000,15000,0,0,''),
(98,96,4,2,13000,13000,0,0,''),
(99,96,11,9,7000,7000,0,0,''),
(100,97,5,3,14000,14000,0,0,''),
(101,97,17,15,4500,4500,0,0,''),
(109,101,16,14,7000,7000,0,0,''),
(108,101,5,3,14000,14000,0,0,''),
(104,99,4,2,13000,13000,0,0,''),
(105,99,12,10,6500,6500,0,0,''),
(106,100,6,4,10000,10000,0,5000,'');
/*!40000 ALTER TABLE `stud_basic2` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic3`
--
DROP TABLE IF EXISTS `stud_basic3`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic3` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discription` varchar(200) NOT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stud_basic3`
--
LOCK TABLES `stud_basic3` WRITE;
/*!40000 ALTER TABLE `stud_basic3` DISABLE KEYS */;
/*!40000 ALTER TABLE `stud_basic3` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sub_head`
--
DROP TABLE IF EXISTS `sub_head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_head` (
`Name` varchar(1000) NOT NULL,
`Sub_Id` int(11) NOT NULL AUTO_INCREMENT,
`Amount` varchar(1000) NOT NULL,
`Status` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Sub_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sub_head`
--
LOCK TABLES `sub_head` WRITE;
/*!40000 ALTER TABLE `sub_head` DISABLE KEYS */;
INSERT INTO `sub_head` VALUES
('PLAY GROUP',1,'13000','N'),
('NURSERY',2,'13000','N'),
('LKG',3,'14000','N'),
('UKG',4,'15000','N'),
('TRSP- NESARGI',5,'4000','N'),
('TRSP- KOLADUR',6,'4500','N'),
('TRSP- MOHARE',7,'4500','N'),
('TRSP- DESNUR',8,'6000','N'),
('TRSP-SUTAGATTI',9,'7000','N'),
('TRSP-MATHIKOPP',10,'6500','N'),
('TRSP-MADANBHAVI',11,'4500','N'),
('12/TRSP-SOMANATTI/5000',12,'5000','N'),
('TRSP-MEKALMARDI',13,'5000','N'),
('TRSP- HANBARATTI',14,'7000','N'),
('TRSP- MALLAPUR',15,'4500','N'),
('TRSP- MALLAPUR',16,'4500','N'),
('TRSP- HOGARTI',17,'7000','N'),
('TRSP- KOLANATTI',18,'6500','N');
/*!40000 ALTER TABLE `sub_head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subcategory`
--
DROP TABLE IF EXISTS `subcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subcategory` (
`subcategoryid` int(11) NOT NULL,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbladmin`
--
LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblbrand`
--
DROP TABLE IF EXISTS `tblbrand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblbrand` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BrandName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblbrand`
--
LOCK TABLES `tblbrand` WRITE;
/*!40000 ALTER TABLE `tblbrand` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblbrand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcart`
--
DROP TABLE IF EXISTS `tblcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcart` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductId` int(5) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`ProductQty` int(11) DEFAULT NULL,
`IsCheckOut` int(5) DEFAULT NULL,
`CartDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcart`
--
LOCK TABLES `tblcart` WRITE;
/*!40000 ALTER TABLE `tblcart` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcategory`
--
DROP TABLE IF EXISTS `tblcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategory`
--
LOCK TABLES `tblcategory` WRITE;
/*!40000 ALTER TABLE `tblcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcustomer`
--
DROP TABLE IF EXISTS `tblcustomer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcustomer` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BillingNumber` varchar(120) DEFAULT NULL,
`CustomerName` varchar(120) DEFAULT NULL,
`MobileNumber` bigint(11) DEFAULT NULL,
`ModeofPayment` varchar(50) DEFAULT NULL,
`BillingDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`),
KEY `BillingNumber` (`BillingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcustomer`
--
LOCK TABLES `tblcustomer` WRITE;
/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblproducts`
--
DROP TABLE IF EXISTS `tblproducts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblproducts` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(200) DEFAULT NULL,
`CatID` int(5) DEFAULT NULL,
`SubcatID` int(5) DEFAULT NULL,
`BrandName` varchar(200) DEFAULT NULL,
`ModelNumber` varchar(200) DEFAULT NULL,
`Stock` int(10) DEFAULT NULL,
`Price` decimal(10,0) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblproducts`
--
LOCK TABLES `tblproducts` WRITE;
/*!40000 ALTER TABLE `tblproducts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblproducts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblsubcategory`
--
DROP TABLE IF EXISTS `tblsubcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblsubcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CatID` int(5) DEFAULT NULL,
`SubCategoryname` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblsubcategory`
--
LOCK TABLES `tblsubcategory` WRITE;
/*!40000 ALTER TABLE `tblsubcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`reference` varchar(255) DEFAULT NULL,
`transactiondate` date NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
`file` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transaction`
--
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_permission`
--
DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`menu` varchar(500) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_permission`
--
LOCK TABLES `user_permission` WRITE;
/*!40000 ALTER TABLE `user_permission` DISABLE KEYS */;
INSERT INTO `user_permission` VALUES
(1,76,'class_division',1),
(2,76,'head',1),
(3,76,'update_student',1),
(4,76,'pay_fees',1),
(5,76,'balance_reports',1),
(6,76,'discount',1),
(7,76,'sub_head',1),
(8,76,'fees_receipt_head',1),
(9,76,'apply_fees_code',1),
(10,76,'payment_approve',1),
(11,76,'inventory',1),
(12,76,'bank',1),
(13,76,'new_student',1),
(14,76,'remove_fees_code',1),
(15,76,'daily_reports',1),
(16,76,'utility',1),
(17,93,'class_division',1),
(18,93,'head',1),
(19,93,'update_student',1),
(20,93,'pay_fees',1),
(21,93,'balance_reports',1),
(22,93,'sub_head',1),
(23,93,'fees_receipt_head',1),
(24,93,'apply_fees_code',1),
(25,93,'payment_approve',1),
(26,93,'inventory',1),
(27,93,'bank',1),
(28,93,'new_student',1),
(29,93,'remove_fees_code',1),
(30,93,'daily_reports',1),
(31,93,'utility',1),
(32,97,'class_division',1),
(33,97,'head',1),
(34,97,'update_student',1),
(35,97,'pay_fees',1),
(36,97,'balance_reports',1),
(37,97,'discount',1),
(38,97,'sub_head',1),
(39,97,'fees_receipt_head',1),
(40,97,'apply_fees_code',1),
(41,97,'payment_approve',1),
(42,97,'inventory',1),
(43,97,'bank',1),
(44,97,'new_student',1),
(45,97,'remove_fees_code',1),
(46,97,'daily_reports',1),
(47,97,'utility',1),
(48,98,'class_division',1),
(49,98,'head',1),
(50,98,'update_student',1),
(51,98,'pay_fees',1),
(52,98,'balance_reports',1),
(53,98,'sub_head',1),
(54,98,'fees_receipt_head',1),
(55,98,'apply_fees_code',1),
(56,98,'payment_approve',1),
(57,98,'inventory',1),
(58,98,'bank',1),
(59,98,'new_student',1),
(60,98,'remove_fees_code',1),
(61,98,'daily_reports',1),
(62,98,'utility',1),
(63,99,'class_division',1),
(64,99,'head',1),
(65,99,'update_student',1),
(66,99,'pay_fees',1),
(67,99,'balance_reports',1),
(68,99,'discount',1),
(69,99,'sub_head',1),
(70,99,'fees_receipt_head',1),
(71,99,'apply_fees_code',1),
(72,99,'payment_approve',1),
(73,99,'inventory',1),
(74,99,'bank',1),
(75,99,'new_student',1),
(76,99,'remove_fees_code',1),
(77,99,'daily_reports',1),
(78,99,'utility',1);
/*!40000 ALTER TABLE `user_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usermanagement`
--
DROP TABLE IF EXISTS `usermanagement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usermanagement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usermanagement`
--
LOCK TABLES `usermanagement` WRITE;
/*!40000 ALTER TABLE `usermanagement` DISABLE KEYS */;
/*!40000 ALTER TABLE `usermanagement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` char(64) NOT NULL,
`salt` char(16) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`passwordText` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(94,'PSNS1','301bb581067e9c3518eab8b98d367a70f9d2276b1c48c9321f9eb12b3a954a66','3b89e5c277d20c43',NULL,'Account','Psns01234'),
(95,'PSNS2','a8481fa0a8ebe1ca77d78037558f499b8cb0f7643bd947443e613e8f2f5cb5be','6796a94975fbcd75',NULL,'Student_Management','Psns012345'),
(97,'PSNS','3396787f7be79bb7aca43b2833996807a3d7a4f3e4e8160f3e08829f082511e6','22e68983164c7d08',NULL,'Fees_Management','Psns0123'),
(99,'MEGHA','8463c18bf847327b39ee0f14db64e38ee1f1ed0344556e432a99269dc3e8d214','343f30221a4907f6',NULL,'Fees_Management','Megham25');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_new`
--
DROP TABLE IF EXISTS `users_new`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_new` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(60) NOT NULL,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role` varchar(20) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`status` varchar(20) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`updated_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_new`
--
LOCK TABLES `users_new` WRITE;
/*!40000 ALTER TABLE `users_new` DISABLE KEYS */;
INSERT INTO `users_new` VALUES
(1,'admin@admin.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','x0FRKT45z0UuQB3VGLklwksp0yKe1q4q4eg81BGKgq2ZmVpyUYLudqevDNN1','0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'rdk@example.com','rdk','$2y$10$2XvoA3Wh2KiFCJXsdIlw.ek83S.km8QNLiCXJjCrbjq0Vzo7hvPJO','Administrator','1234567890','Active','g7vopv4WL9XDdFijxOQwn1wATXsMQIqAZBGD9WIWsk8oXGVyOH94T1YxQyDa','2022-07-23 07:50:22','2022-07-23 07:50:22');
/*!40000 ALTER TABLE `users_new` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vochers`
--
DROP TABLE IF EXISTS `vochers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vochers` (
`Date` date NOT NULL,
`Cheque_Drop_Date` int(100) DEFAULT NULL,
`V_Id` int(11) NOT NULL AUTO_INCREMENT,
`v_counter` bigint(20) NOT NULL,
`Type` varchar(1000) NOT NULL,
`Cr_Ledger` varchar(1000) NOT NULL,
`Dr_Ledger` varchar(1000) NOT NULL,
`Cr_Ledger_Type` varchar(1000) NOT NULL,
`Dr_Ledger_Type` varchar(1000) NOT NULL,
`Cr_Amount` varchar(1000) NOT NULL,
`Dr_Amount` varchar(1000) NOT NULL,
`Nrtn` varchar(5000) NOT NULL,
PRIMARY KEY (`V_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=156 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vochers`
--
LOCK TABLES `vochers` WRITE;
/*!40000 ALTER TABLE `vochers` DISABLE KEYS */;
INSERT INTO `vochers` VALUES
('2023-04-18',NULL,1,1,'Recipt','TRSP- HOGARTI','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-04-18',NULL,2,2,'Recipt','UKG','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-04-25',NULL,3,3,'Recipt','UKG','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-04-25',NULL,4,4,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-04-28',NULL,5,5,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-04-28',NULL,6,6,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-04-19',NULL,7,7,'Recipt','LKG','KRCS-9743','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-04-19',NULL,8,8,'Recipt','TRSP- KOLANATTI','KRCS-9743','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-02',NULL,9,9,'Recipt','UKG','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-02',NULL,10,10,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-03-31',NULL,11,11,'Recipt','UKG','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-03-31',NULL,12,12,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-04-21',NULL,13,13,'Recipt','UKG','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-04-27',NULL,14,14,'Recipt','LKG','KRCS-9743','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-04-27',NULL,15,15,'Recipt','TRSP- MALLAPUR','KRCS-9743','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-05-02',NULL,16,16,'Recipt','UKG','KRCS-9743','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-05-02',NULL,17,17,'Recipt','TRSP-MADANBHAVI','KRCS-9743','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-04-24',NULL,18,18,'Recipt','UKG','Cash','Income/Revenue','Current Assets','21500','21500','Fees Collected'),
('2023-04-05',NULL,19,19,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-04-05',NULL,20,20,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-04-24',NULL,21,21,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2023-04-27',NULL,22,22,'Recipt','LKG','Cash','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-04-29',NULL,23,23,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-05-08',NULL,24,24,'Recipt','UKG','KRCS-9743','Income/Revenue','Current Assets','42000','42000','Fees Collected'),
('2023-05-08',NULL,25,25,'Recipt','TRSP-MATHIKOPP','KRCS-9743','Income/Revenue','Current Assets','26000','26000','Fees Collected'),
('2023-05-08',NULL,26,26,'Recipt','NURSERY','KRCS-9743','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-09',NULL,27,27,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-05-09',NULL,28,28,'Recipt','TRSP- MOHARE','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-05-09',NULL,29,29,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','24000','24000','Fees Collected'),
('2023-05-09',NULL,30,30,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-05-09',NULL,31,31,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-08',NULL,32,32,'Recipt','LKG','KRCS-9743','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-05-16',NULL,33,33,'Recipt','UKG','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-05-16',NULL,34,34,'Recipt','TRSP- MOHARE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-26',NULL,35,35,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-26',NULL,36,36,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-05-27',NULL,37,37,'Recipt','NURSERY','KRCS-9743','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2023-05-29',NULL,38,38,'Recipt','LKG','KRCS-9743','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-05-29',NULL,39,39,'Recipt','TRSP- NESARGI','KRCS-9743','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-05-29',NULL,40,40,'Recipt','LKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-29',NULL,41,41,'Recipt','TRSP- KOLADUR','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-30',NULL,42,42,'Recipt','LKG','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-05-30',NULL,43,43,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-30',NULL,44,44,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-30',NULL,45,45,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-05-31',NULL,46,46,'Recipt','LKG','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2023-05-31',NULL,47,47,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-02',NULL,48,48,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-02',NULL,49,49,'Recipt','UKG','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-03',NULL,50,50,'Recipt','NURSERY','KRCS-9743','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-02',NULL,51,51,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-02',NULL,52,52,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-06-05',NULL,53,53,'Recipt','TRSP-MADANBHAVI','KRCS-9743','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-06-05',NULL,54,54,'Recipt','UKG','KRCS-9743','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-08',NULL,55,55,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-06-08',NULL,56,56,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-06-08',NULL,57,57,'Recipt','UKG','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-06-08',NULL,58,58,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-10',NULL,59,59,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2023-06-10',NULL,60,60,'Recipt','LKG','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-06-10',NULL,61,61,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-16',NULL,62,62,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-06-16',NULL,63,63,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-06-19',NULL,64,64,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2023-06-19',NULL,65,65,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','2300','2300','Fees Collected'),
('2023-06-20',NULL,66,66,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-20',NULL,67,67,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2023-06-23',NULL,68,68,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-23',NULL,69,69,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-06-23',NULL,70,70,'Recipt','LKG','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-26',NULL,71,71,'Recipt','LKG','Cash','Income/Revenue','Current Assets','20500','20500','Fees Collected'),
('2023-06-26',NULL,72,72,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-26',NULL,73,73,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-24',NULL,74,74,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-24',NULL,75,75,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-06-26',NULL,76,76,'Recipt','TRSP- MALLAPUR','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-07-30',NULL,77,77,'Recipt','UKG','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-07-30',NULL,78,78,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-06-30',NULL,79,79,'Recipt','UKG','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-30',NULL,80,80,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-07-07',NULL,81,81,'Recipt','LKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-07-07',NULL,82,82,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-07-08',NULL,83,83,'Recipt','LKG','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-08',NULL,84,84,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-07-10',NULL,85,85,'Recipt','UKG','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-10',NULL,86,86,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-28',NULL,87,87,'Recipt','LKG','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-07-28',NULL,88,88,'Recipt','TRSP- MOHARE','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-08-03',NULL,89,89,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-08-04',NULL,90,90,'Recipt','LKG','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-04',NULL,91,91,'Recipt','TRSP- KOLADUR','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-05',NULL,92,92,'Recipt','NURSERY','KRCS-9743','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-05',NULL,93,93,'Recipt','TRSP-MATHIKOPP','KRCS-9743','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-05',NULL,94,94,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-08-08',NULL,95,95,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-08-08',NULL,96,96,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-08-08',NULL,97,97,'Recipt','UKG','KRCS-9743','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-08',NULL,98,98,'Recipt','TRSP- DESNUR','KRCS-9743','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-09',NULL,99,99,'Recipt','LKG','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-08-09',NULL,100,100,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-08-09',NULL,101,101,'Recipt','UKG','KRCS-9743','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-08-09',NULL,102,102,'Recipt','TRSP-MADANBHAVI','KRCS-9743','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2023-08-18',NULL,103,103,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-08-18',NULL,104,104,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-08-24',NULL,105,105,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-24',NULL,106,106,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','8500','8500','Fees Collected'),
('2023-08-24',NULL,107,107,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-07-19',NULL,108,108,'Recipt','LKG','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-07-19',NULL,109,109,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-08-28',NULL,110,110,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-08-28',NULL,111,111,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2023-08-29',NULL,114,114,'Recipt','NURSERY','KRCS-9743','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-28',NULL,112,112,'Recipt','LKG','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-08-28',NULL,113,113,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-08-29',NULL,115,115,'Recipt','TRSP-SUTAGATTI','KRCS-9743','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-31',NULL,116,116,'Recipt','UKG','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-31',NULL,117,117,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-09-01',NULL,118,118,'Recipt','UKG','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-09-01',NULL,119,119,'Recipt','TRSP- MOHARE','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-09-01',NULL,120,120,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2023-09-01',NULL,121,121,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','2200','2200','Fees Collected'),
('2023-09-09',NULL,122,122,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2023-09-09',NULL,123,123,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2023-10-05',NULL,124,124,'Recipt','TRSP- MOHARE','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-10-05',NULL,125,125,'Recipt','UKG','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-10-05',NULL,126,126,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2023-11-07',NULL,127,127,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-11-07',NULL,128,128,'Recipt','TRSP-MATHIKOPP','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2023-11-06',NULL,129,129,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-11-06',NULL,130,130,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-11-07',NULL,131,131,'Recipt','12/TRSP-SOMANATTI/5000','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2023-11-20',NULL,132,132,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-11-20',NULL,133,133,'Recipt','UKG','Cash','Income/Revenue','Current Assets','14500','14500','Fees Collected'),
('2023-11-20',NULL,134,134,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-11-20',NULL,135,135,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-11-22',NULL,136,136,'Recipt','LKG','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-11-27',NULL,137,137,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-11-27',NULL,138,138,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-11-27',NULL,139,139,'Recipt','LKG','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2023-11-27',NULL,140,140,'Recipt','TRSP- KOLADUR','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-12-04',NULL,141,141,'Recipt','UKG','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-12-05',NULL,142,142,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2023-12-30',NULL,143,143,'Recipt','UKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-12-30',NULL,144,144,'Recipt','TRSP-SUTAGATTI','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-12-22',NULL,145,145,'Recipt','UKG','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-12-22',NULL,146,146,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','','','Fees Collected'),
('2023-12-30',NULL,147,147,'Recipt','NURSERY','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-01-24',NULL,148,148,'Recipt','TRSP- HANBARATTI','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2024-01-24',NULL,149,149,'Recipt','LKG','Cash','Income/Revenue','Current Assets','26000','26000','Fees Collected'),
('2024-01-24',NULL,150,150,'Recipt','TRSP- DESNUR','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-01-24',NULL,151,151,'Recipt','TRSP- KOLADUR','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-03-01',NULL,152,152,'Recipt','UKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-03-01',NULL,153,153,'Recipt','TRSP-MADANBHAVI','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2023-08-29',NULL,154,154,'Recipt','TRSP- NESARGI','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2023-08-29',NULL,155,155,'Recipt','UKG','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected');
/*!40000 ALTER TABLE `vochers` 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-06-05 0:00:30