|
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/../SGSS/../SHHP/ |
| [ 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_SHHP_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
(1,'School','Shri. Huchcheshwar Higher Primary School','Kamatagi. - 587120',''),
(3,' PRIMARY SCHOOL','Shri. Huchcheshwar Higher Primary School','Kamatagi. - 587120','');
/*!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 AUTO_INCREMENT,
`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=6 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,'Canara Bank - 1111','','1111','Head Master',0,0,0,'',''),
(2,'Canara Bank - 1111','','5555','Head Master',0,0,0,'',''),
(3,'Canara Bank - 1111','','6666','Head Master ',0,0,0,'',''),
(4,'Canara Bank - 1111','','7777','Head Master ',0,0,0,'',''),
(5,'HUCHESHWAR BANK','','2095','H M SHHPS',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 AUTO_INCREMENT,
`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=22 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',1,NULL),
('UKG',2,NULL),
('1',3,NULL),
('2',4,NULL),
('3',5,NULL),
('4',6,NULL),
('5',7,NULL),
('6',8,NULL),
('7',9,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',1,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=85 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
('6th to 7th school fees',44,'50','2026-06-01','No','0','5','SCHL'),
('SCHOOL FEES LKG/UKG',45,'51','2026-06-01','No','0','5','SCHL'),
('SCHOOL FEES 1ST STANDARD',46,'52','2026-06-01','No','0','5','SCHL'),
('SCHOOL FEES 2na to 5th standard ',47,'53','2026-06-01','No','0','5','SCHL'),
('KAMATAGI..',48,'54','2026-06-01','No','0','5','SCHL'),
('INGALAGI',49,'55','2026-06-01','No','0','5','SCHL'),
('KADIVAL KALLAPUR ..',50,'56','2026-06-01','No','0','5','SCHL'),
('CHIKKAMAGI..',51,'57','2026-06-01','No','0','5','SCHL'),
('RAMTHAL..',52,'58','2026-06-01','No','0','5','SCHL'),
('BASARIKATTI..',53,'59','2026-06-01','No','0','5','SCHL'),
('MUGUNUR MARDADI BUDIHAL BASAVNAL..',54,'60','2026-06-01','No','0','5','SCHL'),
('BOOK FEES LKG',55,'61','2026-06-01','No','0','1','SCHL'),
('BOOK FEES UKG',56,'62','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 1ST ',57,'63','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 2ND ',58,'64','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 3RD',59,'65','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 4TH',60,'66','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 5TH',61,'67','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 6TH',62,'68','2026-06-01','No','0','1','SCHL'),
('BOOK FEES 7TH',63,'69','2026-06-01','No','0','1','SCHL'),
('RTE Books',64,'70','2026-06-01','No','0','5','SCHL'),
('TRACK SUIT LKG TO 3rd Standard Boys and Girls',65,'72','2026-06-01','No','0','5','SCHL'),
('TRACK SUIT 4th TO 5th Standard Boys and Girls',66,'73','2026-06-01','No','0','5','SCHL'),
('TRACK SUIT 6th TO 7th Standard Boys and Girls',67,'74','2026-06-01','No','0','5','SCHL'),
('REGULAR UNIFORM LKG to 4th BOYS',68,'75','2026-06-01','No','0','5','SCHL'),
('REGULAR UNIFORM LKG to 4th GIRLS ',69,'76','2026-06-01','No','0','5','SCHL'),
('REGULAR UNIFORM 5th to 7th BOYS',70,'77','2026-06-01','No','0','5','SCHL'),
('REGULAR UNIFORM 5th to 7th GIRLS',71,'78','2026-06-01','No','0','5','SCHL'),
('ID CARD 2024-25',72,'79','2026-06-01','No','0','4','SCHL'),
('BELT 2024-25',73,'80','2026-06-01','No','0','5','SCHL'),
('Suralikalla',84,'117','2026-06-01','No','0','5','SCHL');
/*!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=125 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
('CHIKKAMAGI',1,'Income/Revenue'),
('MUGUNUR MARDADI BUDIHAL BASAVNAL',2,'Income/Revenue'),
('BASARIKATTI',3,'Income/Revenue'),
('KADIVAL KALLAPUR',4,'Income/Revenue'),
('KAMATAGI',5,'Income/Revenue'),
('RAMTHAL',6,'Income/Revenue'),
('Canara Bank - 1111-1111',7,'Current Assets'),
('SCHOOL FEES ',8,'Income/Revenue'),
('SCHOOL FEES ',9,'Income/Revenue'),
('BOOK 1',10,'Income/Revenue'),
('BOOKS 3',11,'Income/Revenue'),
('BOOK 4',12,'Income/Revenue'),
('BOOK -5',13,'Income/Revenue'),
('BOOK 6',14,'Income/Revenue'),
('Books RTE 4',15,'Income/Revenue'),
('books RTE 5',16,'Income/Revenue'),
('BOOK RTE 5',17,'Income/Revenue'),
('BOOK -7',18,'Income/Revenue'),
('Benakatti',19,'Income/Revenue'),
('BENALA',20,'Income/Revenue'),
('GULEDAGUDDA',21,'Income/Revenue'),
('HALLUR',22,'Income/Revenue'),
('HALADUR',23,'Income/Revenue'),
('Canara Bank - 1111-5555',24,'Current Assets'),
('Canara Bank - 1111-5555',25,'Current Assets'),
('Canara Bank - 1111-6666',26,'Current Assets'),
('SCHOOL FEES AB 1',27,'Income/Revenue'),
('SCHOOL FEES ',28,'Income/Revenue'),
('LKG BOOK ',29,'Income/Revenue'),
('LKG BOOK ',30,'Income/Revenue'),
('1 ST STANDERD BOOK',31,'Income/Revenue'),
('2ND STANDERD BOOK',32,'Income/Revenue'),
('3RD STANDERD BOOK',33,'Income/Revenue'),
('4TH STANDERD BOOK',34,'Income/Revenue'),
('5TH STANDERD BOOK',35,'Income/Revenue'),
('6 TH STANDERD BOOK',36,'Income/Revenue'),
('7TH STANDERD BOOK',37,'Income/Revenue'),
('Canara Bank - 1111-5555',38,'Current Assets'),
('Canara Bank - 1111-7777',39,'Current Assets'),
('SCHOOL FEES ',40,'Income/Revenue'),
('BOOK2',41,'Income/Revenue'),
('BOOK2',42,'Income/Revenue'),
('LKG BOOK',46,'Income/Revenue'),
('BENALA',43,'Income/Revenue'),
('BENALA',44,'Income/Revenue'),
('BENALA',45,'Income/Revenue'),
('RTE6',47,'Income/Revenue'),
('5 TH TO 7TH STANDARD REGULAR UNIFORM BOYS ',48,'Income/Revenue'),
('HUCHESHWAR BANK-2095',49,'Current Assets'),
('LKG TO 4TH STANDARD REGULAR UNIFORM GIRLS ',50,'Income/Revenue'),
('LKG TO 4TH STANDARD TRACK SUIT BOYS AND GIRLS',51,'Income/Revenue'),
('BELT',52,'Income/Revenue'),
('ID CARD',53,'Income/Revenue'),
('LKG TO 4TH STANDARD REGULAR UNIFORM BOYS ',54,'Income/Revenue'),
('5 TH TO 7TH STANDARD REGULAR UNIFORM GIRLS',55,'Income/Revenue'),
('5 TH TO 7TH STANDARD TRACK SUIT BOYS AND GIRLS ',56,'Income/Revenue'),
('School Fees',57,'Income/Revenue'),
('School Fee LKG UKG',58,'Income/Revenue'),
('school fees 1st ',59,'Income/Revenue'),
('School Fees',60,'Income/Revenue'),
('VAN FEES',61,'Income/Revenue'),
('VAN FEES',62,'Income/Revenue'),
('VAN FEES',63,'Income/Revenue'),
('VAN FEES',64,'Income/Revenue'),
('VAN FEES',65,'Income/Revenue'),
('VAN FEES',66,'Income/Revenue'),
('VAN FEES',67,'Income/Revenue'),
('books fees',68,'Income/Revenue'),
('books fees',69,'Income/Revenue'),
('books fees',70,'Income/Revenue'),
('books fees ',71,'Income/Revenue'),
('books fees',72,'Income/Revenue'),
('books fees',73,'Income/Revenue'),
('books fees',74,'Income/Revenue'),
('books fees',75,'Income/Revenue'),
('books fees',76,'Income/Revenue'),
('RTE Student',77,'Income/Revenue'),
('LKG TO 3rd Standard Boys and Girls Track Suit ',78,'Income/Revenue'),
('TRACK SUITE (YELLOW)',79,'Income/Revenue'),
('TRACK SUITE (YELLOW)',80,'Income/Revenue'),
('TRACK SUITE (YELLOW)',81,'Income/Revenue'),
('REGULAR UNIFORM',82,'Income/Revenue'),
('REGULAR UNIFORM',83,'Income/Revenue'),
('REGULAR UNIFORM',84,'Income/Revenue'),
('REGULAR UNIFORM',85,'Income/Revenue'),
('ID CARD',86,'Income/Revenue'),
('BELT',87,'Income/Revenue'),
('SURALIKAL--',88,'Income/Revenue'),
('xyz',89,'Income/Revenue'),
('kamatagi',90,'Income/Revenue'),
('regular',91,'Income/Revenue'),
('chikkamagi',92,'Income/Revenue'),
('MARADI BUDIHAL',93,'Income/Revenue'),
('uniform',94,'Income/Revenue'),
('BELT',95,'Income/Revenue'),
('uniform ',96,'Income/Revenue'),
('BELT',97,'Income/Revenue'),
('ID CARD',98,'Income/Revenue'),
('RAMTA',99,'Income/Revenue'),
('REGULAR UNIFORM',100,'Income/Revenue'),
('books fees',101,'Income/Revenue'),
('ID CARD',102,'Income/Revenue'),
('CHIKKAMAGI',103,'Income/Revenue'),
('REGULAR UNIFORM',104,'Income/Revenue'),
('books fees',105,'Income/Revenue'),
('BELT',106,'Income/Revenue'),
('ID CARD',107,'Income/Revenue'),
('CHIKKAMAGI',108,'Income/Revenue'),
('bus fees',109,'Income/Revenue'),
('books fees',110,'Income/Revenue'),
('books fees',111,'Income/Revenue'),
('Belt',112,'Income/Revenue'),
('uniform',113,'Income/Revenue'),
('VAN FEES',114,'Income/Revenue'),
('bavuta',115,'Income/Revenue'),
('Hearing fee',116,'Income/Revenue'),
('Painting ',117,'Income/Revenue'),
('MEDICAL',118,'Income/Revenue'),
('CLEANLINESS',119,'Income/Revenue'),
('CAREER EDUCATION FEE',120,'Income/Revenue'),
('SPORTS FEE',121,'Income/Revenue'),
('VAACHANALAY FEE',122,'Income/Revenue'),
('Laboratory fee',123,'Income/Revenue'),
('VAN FEES',124,'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=321 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
(2,298,'SCHL-1',1,'SCHL','SCHL-1',1,'47','/53','/5500','2025-06-10','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(3,298,'SCHL-2',2,'SCHL','SCHL-2',2,'48','/54','/500','2025-06-10','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(4,300,'SCHL-3',3,'SCHL','SCHL-3',3,'47','/53','/5500','2025-06-10','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(5,300,'SCHL-4',4,'SCHL','SCHL-4',4,'48','/54','/500','2025-06-10','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(6,51,'SCHL-5',5,'SCHL','SCHL-5',5,'44','/50','/6000','2025-06-10','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(7,46,'SCHL-6',6,'SCHL','SCHL-6',6,'44','/50','/5000','2025-06-10','Cash','',0,0,5000,5000,1,'2306adminFees',NULL),
(8,295,'SCHL-7',7,'SCHL','SCHL-7',7,'47','/53','/4500','2025-06-10','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(9,199,'SCHL-8',8,'SCHL','SCHL-8',8,'47','/53','/5500','2025-06-10','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(10,199,'SCHL-9',9,'SCHL','SCHL-9',9,'54','/60','/4500','2025-06-10','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(11,318,'SCHL-10',10,'SCHL','SCHL-10',10,'47','/53','/2000','2025-06-10','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(12,419,'SCHL-11',11,'SCHL','SCHL-11',11,'46','/52','/4500','2025-06-10','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(13,196,'SCHL-12',12,'SCHL','SCHL-12',12,'47','/53','/3000','2025-06-10','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(14,67,'SCHL-13',13,'SCHL','SCHL-13',13,'44','/50','/3000','2025-06-10','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(15,415,'SCHL-14',14,'SCHL','SCHL-14',14,'47','/53','/1500','2025-06-10','Cash','',0,0,1500,1500,1,'2306adminFees',NULL),
(16,416,'SCHL-15',15,'SCHL','SCHL-15',15,'44','/50','/3500','2025-06-10','Cash','',0,0,3500,3500,1,'2306adminFees',NULL),
(17,417,'SCHL-16',16,'SCHL','SCHL-16',16,'47','/53','/3000','2025-06-10','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(18,420,'SCHL-17',17,'SCHL','SCHL-17',17,'44','/50','/6000','2025-06-10','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(19,160,'SCHL-18',18,'SCHL','SCHL-18',18,'44','/50','/6000','2025-06-10','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(20,400,'SCHL-19',19,'SCHL','SCHL-19',19,'45','/51','/4500','2025-06-10','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(21,421,'SCHL-20',20,'SCHL','SCHL-20',20,'45','/51','/3000','2025-06-10','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(22,34,'SCHL-21',21,'SCHL','SCHL-21',21,'47','/53','/3000','2025-06-10','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(23,422,'SCHL-22',22,'SCHL','SCHL-22',22,'45','/51','/1500','2025-06-10','Cash','',0,0,1500,1500,1,'2306adminFees',NULL),
(24,403,'SCHL-23',23,'SCHL','SCHL-23',23,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(25,423,'SCHL-24',24,'SCHL','SCHL-24',24,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(26,423,'SCHL-25',25,'SCHL','SCHL-25',25,'48','/54','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(41,346,'SCHL-40',40,'SCHL','SCHL-40',40,'45','/51','/4000','2025-06-11','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(42,395,'SCHL-41',41,'SCHL','SCHL-41',41,'45','/51','/3500','2025-06-11','Cash','',0,0,3500,3500,1,'2306adminFees',NULL),
(43,395,'SCHL-42',42,'SCHL','SCHL-42',42,'54','/60','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(44,298,'SCHL-43',43,'SCHL','SCHL-43',43,'48','/54','/2500','2025-06-12','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(31,424,'SCHL-30',30,'SCHL','SCHL-30',30,'47','/53','/2000','2025-06-11','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(32,425,'SCHL-31',31,'SCHL','SCHL-31',31,'44','/50','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(33,426,'SCHL-32',32,'SCHL','SCHL-32',32,'44','/50','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(34,390,'SCHL-33',33,'SCHL','SCHL-33',33,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(35,427,'SCHL-34',34,'SCHL','SCHL-34',34,'47','/53','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(36,241,'SCHL-35',35,'SCHL','SCHL-35',35,'47','/53','/5500','2025-06-11','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(37,377,'SCHL-36',36,'SCHL','SCHL-36',36,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(38,277,'SCHL-37',37,'SCHL','SCHL-37',37,'47','/53','/5500','2025-06-11','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(39,376,'SCHL-38',38,'SCHL','SCHL-38',38,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(40,376,'SCHL-39',39,'SCHL','SCHL-39',39,'53','/59','/3500','2025-06-11','Cash','',0,0,3500,3500,1,'2306adminFees',NULL),
(45,300,'SCHL-44',44,'SCHL','SCHL-44',44,'48','/54','/2500','2025-06-12','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(46,428,'SCHL-45',45,'SCHL','SCHL-45',45,'45','/51','/4000','2025-06-13','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(47,424,'SCHL-46',46,'SCHL','SCHL-46',46,'47','/53','/1000','2025-06-13','Cash','',0,0,1000,1000,1,'2306adminFees',NULL),
(48,429,'SCHL-47',47,'SCHL','SCHL-47',47,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(49,291,'SCHL-48',48,'SCHL','SCHL-48',48,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(50,232,'SCHL-49',49,'SCHL','SCHL-49',49,'47','/53','/5500','2025-06-13','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(51,430,'SCHL-50',50,'SCHL','SCHL-50',50,'47','/53','/5000','2025-06-13','Cash','',0,0,5000,5000,1,'2306adminFees',NULL),
(52,430,'SCHL-51',51,'SCHL','SCHL-51',51,'84','/117','/4000','2025-06-13','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(53,354,'SCHL-52',52,'SCHL','SCHL-52',52,'44','/50','/6000','2025-06-13','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(54,354,'SCHL-53',53,'SCHL','SCHL-53',53,'84','/117','/4000','2025-06-13','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(55,355,'SCHL-54',54,'SCHL','SCHL-54',54,'44','/50','/6000','2025-06-13','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(56,355,'SCHL-55',55,'SCHL','SCHL-55',55,'84','/117','/4000','2025-06-13','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(57,431,'SCHL-56',56,'SCHL','SCHL-56',56,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(58,381,'SCHL-57',57,'SCHL','SCHL-57',57,'44','/50','/6000','2025-06-13','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(59,387,'SCHL-58',58,'SCHL','SCHL-58',58,'45','/51','/4000','2025-06-13','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(60,339,'SCHL-59',59,'SCHL','SCHL-59',59,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(61,338,'SCHL-60',60,'SCHL','SCHL-60',60,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(62,432,'SCHL-61',61,'SCHL','SCHL-61',61,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(63,432,'SCHL-62',62,'SCHL','SCHL-62',62,'48','/54','/3000','2025-06-13','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(64,287,'SCHL-63',63,'SCHL','SCHL-63',63,'45','/51','/4500','2025-06-13','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(65,357,'SCHL-64',64,'SCHL','SCHL-64',64,'47','/53','/5500','2025-06-14','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(66,356,'SCHL-65',65,'SCHL','SCHL-65',65,'47','/53','/5500','2025-06-14','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(67,302,'SCHL-66',66,'SCHL','SCHL-66',66,'47','/53','/5500','2025-06-14','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(68,243,'SCHL-67',67,'SCHL','SCHL-67',67,'47','/53','/5500','2025-06-14','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(69,29,'SCHL-68',68,'SCHL','SCHL-68',68,'47','/53','/5000','2025-06-14','Cash','',0,0,5000,5000,1,'2306adminFees',NULL),
(70,415,'SCHL-69',69,'SCHL','SCHL-69',69,'47','/53','/4000','2025-06-14','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(71,433,'SCHL-70',70,'SCHL','SCHL-70',70,'45','/51','/4500','2025-06-14','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(72,433,'SCHL-71',71,'SCHL','SCHL-71',71,'54','/60','/4500','2025-06-14','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(75,87,'SCHL-74',74,'SCHL','SCHL-74',74,'44','/50','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(74,424,'SCHL-73',73,'SCHL','SCHL-73',73,'47','/53','/2500','2025-06-16','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(76,350,'SCHL-75',75,'SCHL','SCHL-75',75,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(77,350,'SCHL-76',76,'SCHL','SCHL-76',76,'54','/60','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(78,237,'SCHL-77',77,'SCHL','SCHL-77',77,'47','/53','/5500','2025-06-16','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(79,237,'SCHL-78',78,'SCHL','SCHL-78',78,'54','/60','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(80,422,'SCHL-79',79,'SCHL','SCHL-79',79,'45','/51','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(81,434,'SCHL-80',80,'SCHL','SCHL-80',80,'44','/50','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(84,154,'SCHL-83',83,'SCHL','SCHL-83',83,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(101,363,'SCHL-100',100,'SCHL','SCHL-100',100,'45','/51','/4000','2025-06-16','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(85,349,'SCHL-84',84,'SCHL','SCHL-84',84,'47','/53','/4000','2025-06-16','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(86,404,'SCHL-85',85,'SCHL','SCHL-85',85,'47','/53','/5500','2025-06-16','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(87,435,'SCHL-86',86,'SCHL','SCHL-86',86,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(88,437,'SCHL-87',87,'SCHL','SCHL-87',87,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(89,436,'SCHL-88',88,'SCHL','SCHL-88',88,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(90,392,'SCHL-89',89,'SCHL','SCHL-89',89,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(91,391,'SCHL-90',90,'SCHL','SCHL-90',90,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(92,438,'SCHL-91',91,'SCHL','SCHL-91',91,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(93,342,'SCHL-92',92,'SCHL','SCHL-92',92,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(94,389,'SCHL-93',93,'SCHL','SCHL-93',93,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(95,378,'SCHL-94',94,'SCHL','SCHL-94',94,'45','/51','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(96,378,'SCHL-95',95,'SCHL','SCHL-95',95,'54','/60','/4500','2025-06-16','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(97,171,'SCHL-96',96,'SCHL','SCHL-96',96,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(98,171,'SCHL-97',97,'SCHL','SCHL-97',97,'52','/58','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(99,18,'SCHL-98',98,'SCHL','SCHL-98',98,'47','/53','/5500','2025-06-16','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(100,434,'SCHL-99',99,'SCHL','SCHL-99',99,'44','/50','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(102,196,'SCHL-101',101,'SCHL','SCHL-101',101,'47','/53','/2500','2025-06-16','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(103,439,'SCHL-102',102,'SCHL','SCHL-102',102,'44','/50','/6000','2025-06-16','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(104,332,'SCHL-103',103,'SCHL','SCHL-103',103,'45','/51','/4500','2025-06-17','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(105,349,'SCHL-104',104,'SCHL','SCHL-104',104,'47','/53','/1500','2025-06-17','Cash','',0,0,1500,1500,1,'2306adminFees',NULL),
(106,29,'SCHL-105',105,'SCHL','SCHL-105',105,'47','/53','/500','2025-06-18','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(107,248,'SCHL-106',106,'SCHL','SCHL-106',106,'47','/53','/3500','2025-06-19','Cash','',0,0,3500,3500,1,'2306adminFees',NULL),
(108,248,'SCHL-107',107,'SCHL','SCHL-107',107,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(109,158,'SCHL-108',108,'SCHL','SCHL-108',108,'44','/50','/3500','2025-06-19','Cash','',0,0,3500,3500,1,'2306adminFees',NULL),
(110,158,'SCHL-109',109,'SCHL','SCHL-109',109,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(118,382,'SCHL-117',117,'SCHL','SCHL-117',117,'47','/53','/5500','2025-06-19','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(119,382,'SCHL-118',118,'SCHL','SCHL-118',118,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(117,440,'SCHL-116',116,'SCHL','SCHL-116',116,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(116,440,'SCHL-115',115,'SCHL','SCHL-115',115,'47','/53','/5500','2025-06-19','Cash','',0,0,5500,5500,1,'2306adminFees',NULL),
(115,28,'SCHL-114',114,'SCHL','SCHL-114',114,'47','/53','/4000','2025-06-19','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(120,441,'SCHL-119',119,'SCHL','SCHL-119',119,'46','/52','/3000','2025-06-20','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(121,441,'SCHL-120',120,'SCHL','SCHL-120',120,'54','/60','/2500','2025-06-20','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(122,203,'SCHL-121',121,'SCHL','SCHL-121',121,'47','/53','/2000','2025-06-23','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(123,203,'SCHL-122',122,'SCHL','SCHL-122',122,'51','/57','/2000','2025-06-23','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(124,442,'SCHL-123',123,'SCHL','SCHL-123',123,'45','/51','/2000','2025-06-24','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(125,442,'SCHL-124',124,'SCHL','SCHL-124',124,'53','/59','/2000','2025-06-24','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(126,305,'SCHL-125',125,'SCHL','SCHL-125',125,'47','/53','/6000','2025-06-24','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(127,212,'SCHL-126',126,'SCHL','SCHL-126',126,'44','/50','/6000','2025-06-27','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(128,313,'SCHL-127',127,'SCHL','SCHL-127',127,'44','/50','/3000','2025-06-27','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(129,444,'SCHL-128',128,'SCHL','SCHL-128',128,'44','/50','/2500','2025-06-27','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(130,444,'SCHL-129',129,'SCHL','SCHL-129',129,'54','/60','/2000','2025-06-27','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(131,445,'SCHL-130',130,'SCHL','SCHL-130',130,'45','/51','/2000','2025-06-27','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(132,445,'SCHL-131',131,'SCHL','SCHL-131',131,'51','/57','/2000','2025-06-27','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(133,353,'SCHL-132',132,'SCHL','SCHL-132',132,'44','/50','/2000','2025-06-28','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(134,353,'SCHL-133',133,'SCHL','SCHL-133',133,'63','/69','/670','2025-06-28','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(135,28,'SCHL-134',134,'SCHL','SCHL-134',134,'61','/67','/520','2025-06-28','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(136,447,'SCHL-135',135,'SCHL','SCHL-135',135,'45','/51','/2000','2025-06-28','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(137,446,'SCHL-136',136,'SCHL','SCHL-136',136,'46','/52','/2000','2025-06-28','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(138,448,'SCHL-137',137,'SCHL','SCHL-137',137,'44','/50','/2000','2025-06-28','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(139,388,'SCHL-138',138,'SCHL','SCHL-138',138,'47','/53','/2000','2025-06-28','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(140,226,'SCHL-139',139,'SCHL','SCHL-139',139,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(141,342,'SCHL-140',140,'SCHL','SCHL-140',140,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(142,33,'SCHL-141',141,'SCHL','SCHL-141',141,'61','/67','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(143,236,'SCHL-142',142,'SCHL','SCHL-142',142,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(144,449,'SCHL-143',143,'SCHL','SCHL-143',143,'44','/50','/3000','2025-06-30','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(145,300,'SCHL-144',144,'SCHL','SCHL-144',144,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(146,298,'SCHL-145',145,'SCHL','SCHL-145',145,'58','/64','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(147,302,'SCHL-146',146,'SCHL','SCHL-146',146,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(148,404,'SCHL-147',147,'SCHL','SCHL-147',147,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(149,450,'SCHL-148',148,'SCHL','SCHL-148',148,'61','/67','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(150,435,'SCHL-149',149,'SCHL','SCHL-149',149,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(151,439,'SCHL-150',150,'SCHL','SCHL-150',150,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(152,18,'SCHL-151',151,'SCHL','SCHL-151',151,'60','/66','/550','2025-06-30','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(153,313,'SCHL-152',152,'SCHL','SCHL-152',152,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(154,34,'SCHL-153',153,'SCHL','SCHL-153',153,'61','/67','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(155,87,'SCHL-154',154,'SCHL','SCHL-154',154,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(156,84,'SCHL-155',155,'SCHL','SCHL-155',155,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(157,417,'SCHL-156',156,'SCHL','SCHL-156',156,'61','/67','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(158,248,'SCHL-157',157,'SCHL','SCHL-157',157,'60','/66','/550','2025-06-30','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(159,154,'SCHL-158',158,'SCHL','SCHL-158',158,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(160,158,'SCHL-159',159,'SCHL','SCHL-159',159,'63','/69','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(161,41,'SCHL-160',160,'SCHL','SCHL-160',160,'47','/53','/3000','2025-06-30','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(162,41,'SCHL-161',161,'SCHL','SCHL-161',161,'61','/67','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(163,21,'SCHL-162',162,'SCHL','SCHL-162',162,'47','/53','/3000','2025-06-30','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(164,21,'SCHL-163',163,'SCHL','SCHL-163',163,'60','/66','/550','2025-06-30','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(165,420,'SCHL-164',164,'SCHL','SCHL-164',164,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(166,416,'SCHL-165',165,'SCHL','SCHL-165',165,'54','/60','/2500','2025-06-30','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(167,327,'SCHL-166',166,'SCHL','SCHL-166',166,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(168,74,'SCHL-167',167,'SCHL','SCHL-167',167,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(169,323,'SCHL-168',168,'SCHL','SCHL-168',168,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(170,451,'SCHL-169',169,'SCHL','SCHL-169',169,'44','/50','/3000','2025-06-30','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(171,451,'SCHL-170',170,'SCHL','SCHL-170',170,'54','/60','/2500','2025-06-30','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(172,451,'SCHL-171',171,'SCHL','SCHL-171',171,'62','/68','/670','2025-06-30','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(173,358,'SCHL-172',172,'SCHL','SCHL-172',172,'60','/66','/550','2025-06-30','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(320,290,'SCHL-319',319,'SCHL','SCHL-319',319,'46','/52','/4500','2025-06-30','Cash','',0,0,4500,4500,1,'2306adminFees',NULL),
(175,199,'SCHL-174',174,'SCHL','SCHL-174',174,'60','/66','/550','2025-06-30','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(176,443,'SCHL-175',175,'SCHL','SCHL-175',175,'58','/64','/520','2025-06-30','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(177,427,'SCHL-176',176,'SCHL','SCHL-176',176,'59','/65','/540','2025-06-30','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(178,26,'SCHL-177',177,'SCHL','SCHL-177',177,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(179,365,'SCHL-178',178,'SCHL','SCHL-178',178,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(180,196,'SCHL-179',179,'SCHL','SCHL-179',179,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(181,452,'SCHL-180',180,'SCHL','SCHL-180',180,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(182,195,'SCHL-181',181,'SCHL','SCHL-181',181,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(183,376,'SCHL-182',182,'SCHL','SCHL-182',182,'57','/63','/500','2025-07-01','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(184,304,'SCHL-183',183,'SCHL','SCHL-183',183,'60','/66','/550','2025-07-01','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(185,424,'SCHL-184',184,'SCHL','SCHL-184',184,'58','/64','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(186,31,'SCHL-185',185,'SCHL','SCHL-185',185,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(187,419,'SCHL-186',186,'SCHL','SCHL-186',186,'57','/63','/500','2025-07-01','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(188,453,'SCHL-187',187,'SCHL','SCHL-187',187,'45','/51','/4000','2025-07-01','Cash','',0,0,4000,4000,1,'2306adminFees',NULL),
(189,415,'SCHL-188',188,'SCHL','SCHL-188',188,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(190,357,'SCHL-189',189,'SCHL','SCHL-189',189,'60','/66','/550','2025-07-01','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(191,217,'SCHL-190',190,'SCHL','SCHL-190',190,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(192,64,'SCHL-191',191,'SCHL','SCHL-191',191,'62','/68','/670','2025-07-01','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(193,382,'SCHL-192',192,'SCHL','SCHL-192',192,'61','/67','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(194,440,'SCHL-193',193,'SCHL','SCHL-193',193,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(195,51,'SCHL-194',194,'SCHL','SCHL-194',194,'62','/68','/670','2025-07-01','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(196,46,'SCHL-195',195,'SCHL','SCHL-195',195,'62','/68','/670','2025-07-01','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(197,295,'SCHL-196',196,'SCHL','SCHL-196',196,'57','/63','/500','2025-07-01','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(198,291,'SCHL-197',197,'SCHL','SCHL-197',197,'57','/63','/500','2025-07-01','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(199,232,'SCHL-198',198,'SCHL','SCHL-198',198,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(200,369,'SCHL-199',199,'SCHL','SCHL-199',199,'58','/64','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(201,349,'SCHL-200',200,'SCHL','SCHL-200',200,'58','/64','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(202,292,'SCHL-201',201,'SCHL','SCHL-201',201,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(203,434,'SCHL-202',202,'SCHL','SCHL-202',202,'62','/68','/670','2025-07-01','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(204,384,'SCHL-203',203,'SCHL','SCHL-203',203,'60','/66','/550','2025-07-01','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(205,290,'SCHL-204',204,'SCHL','SCHL-204',204,'57','/63','/500','2025-07-01','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(206,14,'SCHL-205',205,'SCHL','SCHL-205',205,'47','/53','/2000','2025-07-01','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(207,14,'SCHL-206',206,'SCHL','SCHL-206',206,'60','/66','/550','2025-07-01','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(208,318,'SCHL-207',207,'SCHL','SCHL-207',207,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(209,243,'SCHL-208',208,'SCHL','SCHL-208',208,'59','/65','/540','2025-07-01','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(210,294,'SCHL-209',209,'SCHL','SCHL-209',209,'58','/64','/520','2025-07-01','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(211,354,'SCHL-210',210,'SCHL','SCHL-210',210,'63','/69','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(212,355,'SCHL-211',211,'SCHL','SCHL-211',211,'63','/69','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(213,430,'SCHL-212',212,'SCHL','SCHL-212',212,'61','/67','/520','2025-07-02','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(214,345,'SCHL-213',213,'SCHL','SCHL-213',213,'58','/64','/520','2025-07-02','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(215,67,'SCHL-214',214,'SCHL','SCHL-214',214,'62','/68','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(216,237,'SCHL-215',215,'SCHL','SCHL-215',215,'59','/65','/540','2025-07-02','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(217,223,'SCHL-216',216,'SCHL','SCHL-216',216,'47','/53','/6000','2025-07-02','Cash','',0,0,6000,6000,1,'2306adminFees',NULL),
(218,223,'SCHL-217',217,'SCHL','SCHL-217',217,'59','/65','/540','2025-07-02','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(219,441,'SCHL-218',218,'SCHL','SCHL-218',218,'57','/63','/500','2025-07-02','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(220,203,'SCHL-219',219,'SCHL','SCHL-219',219,'60','/66','/550','2025-07-02','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(221,17,'SCHL-220',220,'SCHL','SCHL-220',220,'47','/53','/1000','2025-07-02','Cash','',0,0,1000,1000,1,'2306adminFees',NULL),
(222,17,'SCHL-221',221,'SCHL','SCHL-221',221,'60','/66','/550','2025-07-02','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(223,381,'SCHL-222',222,'SCHL','SCHL-222',222,'63','/69','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(224,390,'SCHL-223',223,'SCHL','SCHL-223',223,'57','/63','/500','2025-07-02','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(225,367,'SCHL-224',224,'SCHL','SCHL-224',224,'62','/68','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(226,287,'SCHL-225',225,'SCHL','SCHL-225',225,'57','/63','/500','2025-07-02','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(227,454,'SCHL-226',226,'SCHL','SCHL-226',226,'45','/51','/2500','2025-07-02','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(228,373,'SCHL-227',227,'SCHL','SCHL-227',227,'59','/65','/540','2025-07-02','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(229,285,'SCHL-228',228,'SCHL','SCHL-228',228,'47','/53','/2500','2025-07-02','Cash','',0,0,2500,2500,1,'2306adminFees',NULL),
(230,285,'SCHL-229',229,'SCHL','SCHL-229',229,'58','/64','/520','2025-07-02','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(231,209,'SCHL-230',230,'SCHL','SCHL-230',230,'62','/68','/670','2025-07-02','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(232,350,'SCHL-231',231,'SCHL','SCHL-231',231,'57','/63','/500','2025-07-02','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(233,289,'SCHL-232',232,'SCHL','SCHL-232',232,'58','/64','/520','2025-07-03','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(234,171,'SCHL-233',233,'SCHL','SCHL-233',233,'63','/69','/670','2025-07-03','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(235,289,'SCHL-234',234,'SCHL','SCHL-234',234,'47','/53','/2000','2025-07-03','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(236,289,'SCHL-235',235,'SCHL','SCHL-235',235,'48','/54','/2000','2025-07-03','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(237,89,'SCHL-236',236,'SCHL','SCHL-236',236,'63','/69','/670','2025-07-03','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(238,444,'SCHL-237',237,'SCHL','SCHL-237',237,'62','/68','/670','2025-07-03','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(239,416,'SCHL-238',238,'SCHL','SCHL-238',238,'62','/68','/670','2025-07-03','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(240,204,'SCHL-239',239,'SCHL','SCHL-239',239,'60','/66','/550','2025-07-03','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(241,384,'SCHL-240',240,'SCHL','SCHL-240',240,'47','/53','/3000','2025-07-03','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(242,339,'SCHL-241',241,'SCHL','SCHL-241',241,'57','/63','/500','2025-07-03','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(243,371,'SCHL-242',242,'SCHL','SCHL-242',242,'63','/69','/670','2025-07-03','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(244,370,'SCHL-243',243,'SCHL','SCHL-243',243,'61','/67','/520','2025-07-03','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(245,277,'SCHL-244',244,'SCHL','SCHL-244',244,'58','/64','/520','2025-07-03','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(246,397,'SCHL-245',245,'SCHL','SCHL-245',245,'58','/64','/520','2025-07-03','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(247,385,'SCHL-246',246,'SCHL','SCHL-246',246,'59','/65','/540','2025-07-03','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(248,305,'SCHL-247',247,'SCHL','SCHL-247',247,'60','/66','/550','2025-07-04','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(249,356,'SCHL-248',248,'SCHL','SCHL-248',248,'58','/64','/520','2025-07-04','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(250,321,'SCHL-249',249,'SCHL','SCHL-249',249,'58','/64','/520','2025-07-04','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(251,212,'SCHL-250',250,'SCHL','SCHL-250',250,'63','/69','/670','2025-07-04','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(252,361,'SCHL-251',251,'SCHL','SCHL-251',251,'62','/68','/670','2025-07-04','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(253,379,'SCHL-252',252,'SCHL','SCHL-252',252,'62','/68','/670','2025-07-04','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(254,59,'SCHL-253',253,'SCHL','SCHL-253',253,'62','/68','/670','2025-07-04','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(255,245,'SCHL-254',254,'SCHL','SCHL-254',254,'58','/64','/520','2025-07-04','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(256,299,'SCHL-255',255,'SCHL','SCHL-255',255,'57','/63','/500','2025-07-04','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(257,395,'SCHL-256',256,'SCHL','SCHL-256',256,'57','/63','/500','2025-07-04','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(258,71,'SCHL-257',257,'SCHL','SCHL-257',257,'44','/50','/2000','2025-07-04','Cash','',0,0,2000,2000,1,'2306adminFees',NULL),
(259,71,'SCHL-258',258,'SCHL','SCHL-258',258,'62','/68','/670','2025-07-04','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(260,241,'SCHL-259',259,'SCHL','SCHL-259',259,'59','/65','/540','2025-07-04','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(261,54,'SCHL-260',260,'SCHL','SCHL-260',260,'62','/68','/670','2025-07-05','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(262,29,'SCHL-261',261,'SCHL','SCHL-261',261,'61','/67','/520','2025-07-05','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(263,86,'SCHL-262',262,'SCHL','SCHL-262',262,'63','/69','/670','2025-07-05','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(264,80,'SCHL-263',263,'SCHL','SCHL-263',263,'63','/69','/670','2025-07-05','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(265,448,'SCHL-264',264,'SCHL','SCHL-264',264,'62','/68','/670','2025-07-05','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(272,280,'SCHL-271',271,'SCHL','SCHL-271',271,'58','/64','/500','2025-07-07','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(267,400,'SCHL-266',266,'SCHL','SCHL-266',266,'57','/63','/500','2025-07-07','Cash','',0,0,500,500,1,'2306adminFees',NULL),
(268,54,'SCHL-267',267,'SCHL','SCHL-267',267,'44','/50','/3000','2025-07-07','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(269,386,'SCHL-268',268,'SCHL','SCHL-268',268,'58','/64','/520','2025-07-07','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(270,79,'SCHL-269',269,'SCHL','SCHL-269',269,'63','/69','/670','2025-07-07','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(271,27,'SCHL-270',270,'SCHL','SCHL-270',270,'61','/67','/520','2025-07-07','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(273,280,'SCHL-272',272,'SCHL','SCHL-272',272,'58','/64','/20','2025-07-03','Cash','',0,0,20,20,1,'2306adminFees',NULL),
(274,449,'SCHL-273',273,'SCHL','SCHL-273',273,'62','/68','/670','2025-07-07','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(275,55,'SCHL-274',274,'SCHL','SCHL-274',274,'62','/68','/670','2025-07-07','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(276,401,'SCHL-275',275,'SCHL','SCHL-275',275,'56','/62','/580','2025-07-07','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(277,160,'SCHL-276',276,'SCHL','SCHL-276',276,'63','/69','/670','2025-07-08','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(278,16,'SCHL-277',277,'SCHL','SCHL-277',277,'60','/66','/550','2025-07-08','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(279,30,'SCHL-278',278,'SCHL','SCHL-278',278,'61','/67','/520','2025-07-08','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(280,72,'SCHL-279',279,'SCHL','SCHL-279',279,'62','/68','/670','2025-07-08','Cash','',0,0,670,670,1,'2306adminFees',NULL),
(281,198,'SCHL-280',280,'SCHL','SCHL-280',280,'61','/67','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(306,456,'SCHL-305',305,'SCHL','SCHL-305',305,'45','/51','/1000','2025-07-14','Cash','',0,0,1000,1000,1,'2306adminFees',NULL),
(307,193,'SCHL-306',306,'SCHL','SCHL-306',306,'61','/67','/520','2025-07-14','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(284,195,'SCHL-283',283,'SCHL','SCHL-283',283,'47','/53','/3000','2025-07-09','Cash','',0,0,3000,3000,1,'2306adminFees',NULL),
(305,432,'SCHL-304',304,'SCHL','SCHL-304',304,'55','/61','/550','2025-07-12','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(286,312,'SCHL-285',285,'SCHL','SCHL-285',285,'61','/67','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(287,192,'SCHL-286',286,'SCHL','SCHL-286',286,'61','/67','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(288,240,'SCHL-287',287,'SCHL','SCHL-287',287,'59','/65','/540','2025-07-09','Cash','',0,0,540,540,1,'2306adminFees',NULL),
(289,362,'SCHL-288',288,'SCHL','SCHL-288',288,'56','/62','/580','2025-07-09','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(290,423,'SCHL-289',289,'SCHL','SCHL-289',289,'55','/61','/550','2025-07-09','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(291,388,'SCHL-290',290,'SCHL','SCHL-290',290,'58','/64','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(292,332,'SCHL-291',291,'SCHL','SCHL-291',291,'56','/62','/580','2025-07-09','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(293,35,'SCHL-292',292,'SCHL','SCHL-292',292,'61','/67','/520','2025-07-10','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(294,283,'SCHL-293',293,'SCHL','SCHL-293',293,'58','/64','/520','2025-07-10','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(295,455,'SCHL-294',294,'SCHL','SCHL-294',294,'56','/62','/580','2025-07-10','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(296,437,'SCHL-295',295,'SCHL','SCHL-295',295,'55','/61','/550','2025-07-10','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(297,436,'SCHL-296',296,'SCHL','SCHL-296',296,'56','/62','/580','2025-07-10','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(298,346,'SCHL-297',297,'SCHL','SCHL-297',297,'56','/62','/580','2025-07-10','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(299,433,'SCHL-298',298,'SCHL','SCHL-298',298,'55','/61','/550','2025-07-10','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(300,378,'SCHL-299',299,'SCHL','SCHL-299',299,'56','/62','/580','2025-07-11','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(301,421,'SCHL-300',300,'SCHL','SCHL-300',300,'55','/61','/550','2025-07-11','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(302,377,'SCHL-301',301,'SCHL','SCHL-301',301,'56','/62','/580','2025-07-11','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(303,363,'SCHL-302',302,'SCHL','SCHL-302',302,'56','/62','/580','2025-07-12','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(304,428,'SCHL-303',303,'SCHL','SCHL-303',303,'55','/61','/550','2025-07-12','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(308,457,'SCHL-307',307,'SCHL','SCHL-307',307,'56','/62','/580','2025-07-14','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(309,422,'SCHL-308',308,'SCHL','SCHL-308',308,'55','/61','/550','2025-07-15','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(310,431,'SCHL-309',309,'SCHL','SCHL-309',309,'56','/62','/580','2025-07-15','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(311,442,'SCHL-310',310,'SCHL','SCHL-310',310,'55','/61','/550','2025-07-15','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(312,210,'SCHL-311',311,'SCHL','SCHL-311',311,'61','/67','/520','2025-07-15','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(313,38,'SCHL-312',312,'SCHL','SCHL-312',312,'61','/67','/520','2025-07-15','Cash','',0,0,520,520,1,'2306adminFees',NULL),
(314,429,'SCHL-313',313,'SCHL','SCHL-313',313,'55','/61','/550','2025-07-16','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(315,338,'SCHL-314',314,'SCHL','SCHL-314',314,'56','/62','/580','2025-07-16','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(316,392,'SCHL-315',315,'SCHL','SCHL-315',315,'56','/62','/580','2025-07-17','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(317,391,'SCHL-316',316,'SCHL','SCHL-316',316,'56','/62','/580','2025-07-17','Cash','',0,0,580,580,1,'2306adminFees',NULL),
(318,438,'SCHL-317',317,'SCHL','SCHL-317',317,'55','/61','/550','2025-07-17','Cash','',0,0,550,550,1,'2306adminFees',NULL),
(319,453,'SCHL-318',318,'SCHL','SCHL-318',318,'56','/62','/580','2025-07-17','Cash','',0,0,580,580,1,'2306adminFees',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
(2,146,'BOOK-1',1,'BOOK','BOOK-1',1,'9','/9','/100','2023-06-26','Cash','',0,0,100,100,1,'2306adminFees','2023-06-27 06:40 33'),
(1,146,'SCHL-1',1,'SCHL','SCHL-1',1,'7','/8','/3000','2023-06-26','Cash','',0,0,3000,3000,1,'2306adminFees','2023-06-27 06:40 42'),
(5,20,'SCHL-2',2,'SCHL','SCHL-2',2,'25','/2','/450','2023-06-27','Cash','',0,0,450,450,1,'2306adminFees','2023-06-27 10:05 46'),
(4,20,'TRNP-1',1,'TRNP','TRNP-1',1,'1','/1/1','/5000/5000','2023-06-27','Cash','',0,0,10000,10000,1,'2306adminFees','2023-06-27 10:05 55'),
(3,20,'SCHL-1',1,'SCHL','SCHL-1',1,'18','/24','/7000','2023-06-27','Cash','',0,0,7000,7000,1,'2306adminFees','2023-06-27 10:06 08'),
(14,92,'BOOK-4',4,'BOOK','BOOK-4',4,'16','/16','/70','2023-06-28','Cash','',0,0,70,70,1,'2306adminFees','2023-06-28 11:01 54'),
(13,92,'BOOK-3',3,'BOOK','BOOK-3',3,'16','/16','/70','2023-06-28','Cash','',0,0,70,70,1,'2306adminFees','2023-06-28 11:01 59'),
(9,148,'TRNP-2',2,'TRNP','TRNP-2',2,'4','/4','/2000','2023-06-28','Cash','',0,0,2000,2000,1,'2306adminFees','2023-06-28 11:03 04'),
(8,148,'SCHL-2',2,'SCHL','SCHL-2',2,'8','/7','/3000','2023-06-28','Cash','',0,0,3000,3000,1,'2306adminFees','2023-06-28 11:03 34'),
(10,148,'SCHL-3',3,'SCHL','SCHL-3',3,'25','/2','/450','2023-06-28','Cash','',0,0,450,450,1,'2306adminFees','2023-06-28 11:04 27'),
(7,148,'TRNP-1',1,'TRNP','TRNP-1',1,'4','/4','/2000','2023-06-28','Cash','',0,0,2000,2000,1,'2306adminFees','2023-06-28 11:04 32'),
(6,148,'SCHL-1',1,'SCHL','SCHL-1',1,'8','/7','/3000','2023-06-28','Cash','',0,0,3000,3000,1,'2306adminFees','2023-06-28 11:04 39'),
(22,79,'TRNP-3',3,'TRNP','TRNP-3',3,'2','/2','/','2023-06-28','Cash','',0,0,0,0,1,'2306adminFees','2023-06-30 05:56 45'),
(21,79,'BOOK-8',8,'BOOK','BOOK-8',8,'12','/12','/250','2023-06-28','Cash','',0,0,250,250,1,'2306adminFees','2023-06-30 05:56 51'),
(20,79,'SCHL-6',6,'SCHL','SCHL-6',6,'7','/8','/','2023-06-28','Cash','',0,0,0,0,1,'2306adminFees','2023-06-30 05:56 57'),
(41,79,'BOOK-20',20,'BOOK','BOOK-20',20,'12','/12','/250','2023-06-30','Cash','',0,0,250,250,1,'2306adminFees','2023-06-30 08:59 33'),
(25,79,'BOOK-11',11,'BOOK','BOOK-11',11,'12','/12','/250','2023-06-30','Cash','',0,0,250,250,1,'2306adminFees','2023-06-30 08:59 37'),
(47,83,'BOOK-25',25,'BOOK','BOOK-25',25,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-06-30 10:09 53'),
(53,135,'BOOK-28',28,'BOOK','BOOK-28',28,'14','/17','/530','2023-06-30','Cash','',0,0,530,530,1,'2306adminFees','2023-06-30 10:42 09'),
(51,84,'BOOK-26',26,'BOOK','BOOK-26',26,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-07-01 04:57 46'),
(50,84,'SCHL-13',13,'SCHL','SCHL-13',13,'7','/8','/3500','2023-06-30','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-01 04:57 51'),
(49,84,'SCHL-12',12,'SCHL','SCHL-12',12,'7','/8','/3500','2023-06-30','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-01 04:57 57'),
(40,84,'SCHL-11',11,'SCHL','SCHL-11',11,'7','/8','/3500','2023-06-30','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-01 04:58 01'),
(39,84,'BOOK-19',19,'BOOK','BOOK-19',19,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-07-01 04:59 31'),
(38,84,'SCHL-10',10,'SCHL','SCHL-10',10,'7','/8','/3500','2023-06-30','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-01 04:59 37'),
(60,83,'BOOK-32',32,'BOOK','BOOK-32',32,'12','/12','/-350','2023-07-01','Cash','',0,0,-350,-350,1,'2306adminFees','2023-07-01 05:13 11'),
(48,83,'BOOK-25',25,'BOOK','BOOK-25',25,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-07-01 05:13 18'),
(101,25,'TRNP-5',5,'TRNP','TRNP-5',5,'5','/5','/2500','2023-07-04','Cash','',0,0,2500,2500,1,'2306adminFees','2023-07-04 06:57 56'),
(100,25,'BOOK-60',60,'BOOK','BOOK-60',60,'10','/10','/480','2023-07-04','Cash','',0,0,480,480,1,'2306adminFees','2023-07-04 06:58 01'),
(99,25,'SCHL-20',20,'SCHL','SCHL-20',20,'7','/8','/5000','2023-07-04','Cash','',0,0,5000,5000,1,'2306adminFees','2023-07-04 06:58 05'),
(121,30,'SCHL-29',29,'SCHL','SCHL-29',29,'7','/8','/1500','2023-07-04','Cash','',0,0,1500,1500,1,'2306adminFees','2023-07-04 07:15 07'),
(119,30,'SCHL-28',28,'SCHL','SCHL-28',28,'7','/8','/1500','2023-07-04','Cash','',0,0,1500,1500,1,'2306adminFees','2023-07-04 07:15 13'),
(120,30,'BOOK-70',70,'BOOK','BOOK-70',70,'10','/10','/480','2023-07-04','Cash','',0,0,480,480,1,'2306adminFees','2023-07-04 07:22 27'),
(84,30,'SCHL-18',18,'SCHL','SCHL-18',18,'7','/8','/1500','2023-07-03','Cash','',0,0,1500,1500,1,'2306adminFees','2023-07-04 07:22 32'),
(135,150,'SCHL-40',40,'SCHL','SCHL-40',40,'7','/8','/3500','2023-07-04','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-04 09:13 56'),
(95,37,'SCHL-19',19,'SCHL','SCHL-19',19,'7','/8','/5000','2023-07-04','Cash','',0,0,5000,5000,1,'2306adminFees','2023-07-05 07:33 51'),
(96,37,'BOOK-57',57,'BOOK','BOOK-57',57,'10','/10','/480','2023-07-04','Cash','',0,0,480,480,1,'2306adminFees','2023-07-05 07:46 14'),
(182,24,'BOOK-91',91,'BOOK','BOOK-91',91,'10','/10','/480','2023-07-05','Cash','',0,0,480,480,1,'2306adminFees','2023-07-06 05:13 18'),
(37,83,'BOOK-18',18,'BOOK','BOOK-18',18,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-07-06 05:37 32'),
(35,166,'BOOK-16',16,'BOOK','BOOK-16',16,'16','/16','/70','2023-06-30','Cash','',0,0,70,70,1,'2306adminFees','2023-07-06 05:59 38'),
(59,162,'BOOK-31',31,'BOOK','BOOK-31',31,'12','/12','/350','2023-07-01','Cash','',0,0,350,350,1,'2306adminFees','2023-07-06 06:16 00'),
(58,162,'SCHL-11',11,'SCHL','SCHL-11',11,'7','/8','/3000','2023-07-01','Cash','',0,0,3000,3000,1,'2306adminFees','2023-07-06 06:16 05'),
(57,162,'TRNP-2',2,'TRNP','TRNP-2',2,'2','/2','/2000','2023-07-01','Cash','',0,0,2000,2000,1,'2306adminFees','2023-07-06 06:16 10'),
(32,162,'BOOK-15',15,'BOOK','BOOK-15',15,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-07-06 06:16 15'),
(31,162,'SCHL-7',7,'SCHL','SCHL-7',7,'7','/8','/3000','2023-06-30','Cash','',0,0,3000,3000,1,'2306adminFees','2023-07-06 06:16 19'),
(30,162,'TRNP-1',1,'TRNP','TRNP-1',1,'2','/2','/2000','2023-06-30','Cash','',0,0,2000,2000,1,'2306adminFees','2023-07-06 06:16 24'),
(68,126,'BOOK-37',37,'BOOK','BOOK-37',37,'14','/17','/-530','2023-07-01','Cash','',0,0,-530,-530,1,'2306adminFees','2023-07-07 10:08 19'),
(52,126,'BOOK-27',27,'BOOK','BOOK-27',27,'14','/17','/530','2023-06-30','Cash','',0,0,530,530,1,'2306adminFees','2023-07-07 10:08 25'),
(61,126,'BOOK-32',32,'BOOK','BOOK-32',32,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-07-07 10:09 19'),
(62,134,'BOOK-33',33,'BOOK','BOOK-33',33,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-07-07 10:27 50'),
(54,134,'BOOK-29',29,'BOOK','BOOK-29',29,'14','/17','/530','2023-06-30','Cash','',0,0,530,530,1,'2306adminFees','2023-07-07 10:27 59'),
(200,229,'BOOK-104',104,'BOOK','BOOK-104',104,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-10 06:48 23'),
(199,229,'SCHL-67',67,'SCHL','SCHL-67',67,'7','/8','/3500','2023-07-10','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-10 06:48 28'),
(201,238,'SCHL-67',67,'SCHL','SCHL-67',67,'7','/8','/3500','2023-07-10','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-10 07:00 01'),
(202,238,'BOOK-104',104,'BOOK','BOOK-104',104,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-10 07:00 07'),
(198,234,'BOOK-103',103,'BOOK','BOOK-103',103,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-10 07:08 40'),
(224,228,'BOOK-113',113,'BOOK','BOOK-113',113,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-10 09:30 48'),
(244,205,'SCHL-82',82,'SCHL','SCHL-82',82,'7','/8','/3000','2023-07-10','Cash','',0,0,3000,3000,1,'2306adminFees','2023-07-10 10:28 22'),
(243,205,'TRNP-16',16,'TRNP','TRNP-16',16,'2','/2','/2500','2023-07-10','Cash','',0,0,2500,2500,1,'2306adminFees','2023-07-10 10:28 26'),
(153,205,'SCHL-55',55,'SCHL','SCHL-55',55,'28','/35','/420','2023-07-04','Cash','',0,0,420,420,1,'2306adminFees','2023-07-10 10:28 30'),
(152,205,'SCHL-54',54,'SCHL','SCHL-54',54,'7','/8','/3000','2023-07-04','Cash','',0,0,3000,3000,1,'2306adminFees','2023-07-10 10:28 35'),
(151,205,'TRNP-9',9,'TRNP','TRNP-9',9,'2','/2','/2000','2023-07-04','Cash','',0,0,2000,2000,1,'2306adminFees','2023-07-10 10:28 39'),
(251,141,'SCHL-86',86,'SCHL','SCHL-86',86,'7','/8','/6500','2023-12-07','Cash','',0,0,6500,6500,1,'2306adminFees','2023-07-12 05:25 20'),
(67,141,'BOOK-36',36,'BOOK','BOOK-36',36,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-07-12 05:25 24'),
(74,124,'BOOK-43',43,'BOOK','BOOK-43',43,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-07-12 10:14 19'),
(266,278,'TRNP-20',20,'TRNP','TRNP-20',20,'5','/5','/2500','2023-07-15','Cash','',0,0,2500,2500,1,'2306adminFees','2023-07-15 06:52 35'),
(268,278,'SCHL-97',97,'SCHL','SCHL-97',97,'31','/26','/520','2023-07-15','Cash','',0,0,520,520,1,'2306adminFees','2023-07-15 06:54 18'),
(267,278,'SCHL-96',96,'SCHL','SCHL-96',96,'7','/8','/3500','2023-07-15','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-15 06:54 23'),
(259,288,'SCHL-90',90,'SCHL','SCHL-90',90,'30','/25','/480','2023-07-15','Cash','',0,0,480,480,1,'2306adminFees','2023-07-17 05:21 33'),
(258,288,'SCHL-89',89,'SCHL','SCHL-89',89,'30','/25','/480','2023-07-15','Cash','',0,0,480,480,1,'2306adminFees','2023-07-17 05:21 37'),
(231,219,'BOOK-116',116,'BOOK','BOOK-116',116,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-17 05:47 41'),
(230,219,'SCHL-78',78,'SCHL','SCHL-78',78,'7','/8','/3500','2023-07-10','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-17 05:47 46'),
(204,239,'BOOK-104',104,'BOOK','BOOK-104',104,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-07-17 05:52 02'),
(203,239,'SCHL-67',67,'SCHL','SCHL-67',67,'7','/8','/3500','2023-07-10','Cash','',0,0,3500,3500,1,'2306adminFees','2023-07-17 05:52 07'),
(126,13,'SCHL-31',31,'SCHL','SCHL-31',31,'28','/35','/440','2023-07-04','Cash','',0,0,440,440,1,'2306adminFees','2023-07-17 10:10 48'),
(136,150,'SCHL-41',41,'SCHL','SCHL-41',41,'28','/35','/450','2023-07-04','Cash','',0,0,450,450,1,'2306adminFees','2023-07-17 10:17 25'),
(137,150,'SCHL-42',42,'SCHL','SCHL-42',42,'7','/8','/5000','2023-07-04','Cash','',0,0,5000,5000,1,'2306adminFees','2023-07-17 10:17 38'),
(65,120,'BOOK-35',35,'BOOK','BOOK-35',35,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-07-17 10:50 26'),
(255,124,'SCHL-87',87,'SCHL','SCHL-87',87,'7','/8','/3000','2023-07-12','Cash','',0,0,3000,3000,1,'2306adminFees','2023-07-17 10:53 35'),
(254,124,'TRNP-17',17,'TRNP','TRNP-17',17,'3','/3','/2000','2023-07-12','Cash','',0,0,2000,2000,1,'2306adminFees','2023-07-17 10:53 40'),
(83,188,'SCHL-17',17,'SCHL','SCHL-17',17,'7','/8','/2000','2023-07-03','Cash','',0,0,2000,2000,1,'2306adminFees','2023-07-17 10:59 30'),
(256,188,'TRNP-18',18,'TRNP','TRNP-18',18,'1','/1','/1000','2023-07-12','Cash','',0,0,1000,1000,1,'2306adminFees','2023-07-17 10:59 36'),
(195,188,'BOOK-100',100,'BOOK','BOOK-100',100,'14','/17','/530','2023-07-07','Cash','',0,0,530,530,1,'2306adminFees','2023-07-17 10:59 42'),
(253,276,'SCHL-86',86,'SCHL','SCHL-86',86,'7','/8','/6000','2023-07-12','Cash','',0,0,6000,6000,1,'2306adminFees','2023-07-18 09:20 04'),
(252,276,'BOOK-125',125,'BOOK','BOOK-125',125,'14','/17','/530','2023-07-12','Cash','',0,0,530,530,1,'2306adminFees','2023-07-18 09:20 09'),
(36,96,'BOOK-17',17,'BOOK','BOOK-17',17,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-08-12 05:43 32'),
(514,94,'SCHL-310',310,'SCHL','SCHL-310',310,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 05:26 55'),
(476,94,'SCHL-272',272,'SCHL','SCHL-272',272,'37','/46','/65','2023-08-12','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 05:28 04'),
(45,94,'BOOK-23',23,'BOOK','BOOK-23',23,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 05:28 09'),
(526,98,'SCHL-322',322,'SCHL','SCHL-322',322,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 05:34 27'),
(605,296,'SCHL-400',400,'SCHL','SCHL-400',400,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 07:00 20'),
(604,296,'SCHL-399',399,'SCHL','SCHL-399',399,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 07:00 25'),
(603,296,'SCHL-398',398,'SCHL','SCHL-398',398,'40','/44','/400','2023-08-14','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 07:00 29'),
(602,296,'SCHL-397',397,'SCHL','SCHL-397',397,'38','/43','/380','2023-08-14','Cash','',0,0,380,380,1,'2306adminFees','2023-08-14 07:00 32'),
(358,296,'SCHL-155',155,'SCHL','SCHL-155',155,'31','/26','/520','2023-07-24','Cash','',0,0,520,520,1,'2306adminFees','2023-08-14 07:00 37'),
(610,173,'SCHL-401',401,'SCHL','SCHL-401',401,'40','/44','/400','2023-08-14','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 07:12 48'),
(612,173,'SCHL-403',403,'SCHL','SCHL-403',403,'42','/48','/420','2023-08-14','Cash','',0,0,420,420,1,'2306adminFees','2023-08-14 07:13 20'),
(611,173,'SCHL-402',402,'SCHL','SCHL-402',402,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 07:13 24'),
(609,173,'SCHL-400',400,'SCHL','SCHL-400',400,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 07:13 28'),
(42,173,'BOOK-20',20,'BOOK','BOOK-20',20,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 07:14 08'),
(337,108,'SCHL-141',141,'SCHL','SCHL-141',141,'32','/41','/0','2023-07-17','Cash','',0,0,0,0,1,'2306adminFees','2023-08-14 07:36 03'),
(635,301,'SCHL-425',425,'SCHL','SCHL-425',425,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 08:05 19'),
(634,301,'SCHL-424',424,'SCHL','SCHL-424',424,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 08:12 33'),
(633,301,'SCHL-423',423,'SCHL','SCHL-423',423,'40','/44','/400','2023-08-14','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 08:12 39'),
(469,301,'SCHL-265',265,'SCHL','SCHL-265',265,'40','/44','/400','2023-08-12','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 08:12 46'),
(632,301,'SCHL-422',422,'SCHL','SCHL-422',422,'38','/43','/380','2023-08-14','Cash','',0,0,380,380,1,'2306adminFees','2023-08-14 08:13 04'),
(300,301,'SCHL-122',122,'SCHL','SCHL-122',122,'7','/8','/3500','2023-07-17','Cash','',0,0,3500,3500,1,'2306adminFees','2023-08-14 08:13 18'),
(471,301,'SCHL-267',267,'SCHL','SCHL-267',267,'37','/46','/65','2023-08-12','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 08:13 39'),
(470,301,'SCHL-266',266,'SCHL','SCHL-266',266,'36','/45','/35','2023-08-12','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 08:13 44'),
(468,301,'SCHL-264',264,'SCHL','SCHL-264',264,'39','/47','/350','2023-08-12','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 08:13 50'),
(299,301,'BOOK-127',127,'BOOK','BOOK-127',127,'9','/9','/450','2023-07-17','Cash','',0,0,450,450,1,'2306adminFees','2023-08-14 08:13 54'),
(560,157,'SCHL-355',355,'SCHL','SCHL-355',355,'43','/49','/420','2023-08-14','Cash','',0,0,420,420,1,'2306adminFees','2023-08-14 09:45 48'),
(559,157,'SCHL-354',354,'SCHL','SCHL-354',354,'41','/42','/360','2023-08-14','Cash','',0,0,360,360,1,'2306adminFees','2023-08-14 09:46 00'),
(558,157,'SCHL-353',353,'SCHL','SCHL-353',353,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 09:46 11'),
(556,157,'SCHL-351',351,'SCHL','SCHL-351',351,'43','/49','/420','2023-08-14','Cash','',0,0,420,420,1,'2306adminFees','2023-08-14 09:46 17'),
(557,157,'SCHL-352',352,'SCHL','SCHL-352',352,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 09:46 24'),
(554,157,'SCHL-349',349,'SCHL','SCHL-349',349,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 09:46 29'),
(555,157,'SCHL-350',350,'SCHL','SCHL-350',350,'41','/42','/360','2023-08-14','Cash','',0,0,360,360,1,'2306adminFees','2023-08-14 09:46 35'),
(28,157,'SCHL-6',6,'SCHL','SCHL-6',6,'7','/8','/3000','2023-06-30','Cash','',0,0,3000,3000,1,'2306adminFees','2023-08-14 09:46 42'),
(553,157,'SCHL-348',348,'SCHL','SCHL-348',348,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 09:46 44'),
(27,157,'BOOK-13',13,'BOOK','BOOK-13',13,'12','/12','/350','2023-06-30','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 09:46 50'),
(574,279,'SCHL-369',369,'SCHL','SCHL-369',369,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 10:47 40'),
(568,279,'SCHL-363',363,'SCHL','SCHL-363',363,'40','/44','/400','2023-08-14','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 10:47 45'),
(569,279,'SCHL-364',364,'SCHL','SCHL-364',364,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 10:47 51'),
(570,279,'SCHL-365',365,'SCHL','SCHL-365',365,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-14 10:47 58'),
(573,279,'SCHL-368',368,'SCHL','SCHL-368',368,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-14 10:48 55'),
(572,279,'SCHL-367',367,'SCHL','SCHL-367',367,'40','/44','/400','2023-08-14','Cash','',0,0,400,400,1,'2306adminFees','2023-08-14 10:49 01'),
(571,279,'SCHL-366',366,'SCHL','SCHL-366',366,'39','/47','/350','2023-08-14','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 10:49 05'),
(271,279,'SCHL-99',99,'SCHL','SCHL-99',99,'31','/26','/520','2023-07-15','Cash','',0,0,520,520,1,'2306adminFees','2023-08-14 10:49 10'),
(270,279,'SCHL-98',98,'SCHL','SCHL-98',98,'7','/8','/3500','2023-07-15','Cash','',0,0,3500,3500,1,'2306adminFees','2023-08-14 10:49 15'),
(567,279,'SCHL-362',362,'SCHL','SCHL-362',362,'39','/47','/350','2023-08-14','Cash','',0,0,350,350,1,'2306adminFees','2023-08-14 10:49 21'),
(269,279,'TRNP-21',21,'TRNP','TRNP-21',21,'5','/5','/2500','2023-07-15','Cash','',0,0,2500,2500,1,'2306adminFees','2023-08-14 10:49 26'),
(585,303,'SCHL-380',380,'SCHL','SCHL-380',380,'43','/49','/420','2023-08-14','Cash','',0,0,420,420,1,'2306adminFees','2023-08-16 10:08 56'),
(583,303,'SCHL-378',378,'SCHL','SCHL-378',378,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-08-16 10:09 03'),
(582,303,'SCHL-377',377,'SCHL','SCHL-377',377,'36','/45','/35','2023-08-14','Cash','',0,0,35,35,1,'2306adminFees','2023-08-16 10:09 10'),
(584,303,'SCHL-379',379,'SCHL','SCHL-379',379,'41','/42','/360','2023-08-14','Cash','',0,0,360,360,1,'2306adminFees','2023-08-16 10:09 17'),
(330,303,'SCHL-134',134,'SCHL','SCHL-134',134,'7','/8','/3000','2023-07-17','Cash','',0,0,3000,3000,1,'2306adminFees','2023-08-16 10:09 25'),
(329,303,'TRNP-29',29,'TRNP','TRNP-29',29,'1','/1','/2500','2023-07-17','Cash','',0,0,2500,2500,1,'2306adminFees','2023-08-16 10:09 30'),
(762,69,'SCHL-548',548,'SCHL','SCHL-548',548,'37','/46','/65','2023-08-17','Cash','',0,0,65,65,1,'2306adminFees','2023-08-17 05:42 46'),
(764,55,'SCHL-550',550,'SCHL','SCHL-550',550,'37','/46','/65','2023-08-17','Cash','',0,0,65,65,1,'2306adminFees','2023-08-17 07:04 21'),
(566,136,'SCHL-361',361,'SCHL','SCHL-361',361,'37','/46','/65','2023-08-14','Cash','',0,0,65,65,1,'2306adminFees','2023-09-22 06:09 23'),
(71,136,'BOOK-40',40,'BOOK','BOOK-40',40,'14','/17','/530','2023-07-01','Cash','',0,0,530,530,1,'2306adminFees','2023-09-22 06:09 30'),
(744,216,'SCHL-531',531,'SCHL','SCHL-531',531,'37','/46','/65','2023-08-16','Cash','',0,0,65,65,1,'2306adminFees','2023-09-27 10:19 52'),
(743,216,'SCHL-530',530,'SCHL','SCHL-530',530,'36','/45','/35','2023-08-16','Cash','',0,0,35,35,1,'2306adminFees','2023-09-27 10:19 57'),
(742,216,'SCHL-529',529,'SCHL','SCHL-529',529,'40','/44','/400','2023-08-16','Cash','',0,0,400,400,1,'2306adminFees','2023-09-27 10:20 02'),
(741,216,'SCHL-528',528,'SCHL','SCHL-528',528,'39','/47','/350','2023-08-16','Cash','',0,0,350,350,1,'2306adminFees','2023-09-27 10:20 07'),
(776,218,'SCHL-562',562,'SCHL','SCHL-562',562,'37','/46','/65','2023-08-17','Cash','',0,0,65,65,1,'2306adminFees','2023-11-03 10:42 31'),
(775,218,'SCHL-561',561,'SCHL','SCHL-561',561,'40','/44','/400','2023-08-17','Cash','',0,0,400,400,1,'2306adminFees','2023-11-03 10:42 51'),
(774,218,'SCHL-560',560,'SCHL','SCHL-560',560,'38','/43','/380','2023-08-17','Cash','',0,0,380,380,1,'2306adminFees','2023-11-03 10:42 57'),
(217,218,'BOOK-109',109,'BOOK','BOOK-109',109,'9','/9','/450','2023-07-10','Cash','',0,0,450,450,1,'2306adminFees','2023-11-03 10:43 04'),
(216,218,'SCHL-73',73,'SCHL','SCHL-73',73,'7','/8','/3500','2023-07-10','Cash','',0,0,3500,3500,1,'2306adminFees','2023-11-03 10:43 15'),
(215,218,'TRNP-12',12,'TRNP','TRNP-12',12,'5','/5','/1000','2023-07-10','Cash','',0,0,1000,1000,1,'2306adminFees','2023-11-03 10:43 21'),
(29,158,'BOOK-14',14,'BOOK','BOOK-14',14,'16','/16','/70','2023-06-30','Cash','',0,0,70,70,1,'2306adminFees','2023-11-17 05:43 30'),
(313,111,'BOOK-134',134,'BOOK','BOOK-134',134,'13','/13','/500','2023-07-17','Cash','',0,0,500,500,1,'2306adminFees','2023-11-24 08:58 20'),
(921,111,'BOOK-153',153,'BOOK','BOOK-153',153,'13','/13','/500','2023-11-24','Cash','',0,0,500,500,1,'2306adminFees','2023-11-24 08:58 43'),
(920,111,'SCHL-693',693,'SCHL','SCHL-693',693,'41','/42','/360','2023-11-24','Cash','',0,0,360,360,1,'2306adminFees','2023-11-24 08:59 06'),
(312,111,'SCHL-127',127,'SCHL','SCHL-127',127,'7','/8','/4000','2023-07-17','Cash','',0,0,4000,4000,1,'2306adminFees','2023-11-24 08:59 13'),
(138,151,'TRNP-7',7,'TRNP','TRNP-7',7,'2','/2','/2000','2023-07-04','Cash','',0,0,2000,2000,1,'2306adminFees','2024-02-26 07:21 10'),
(288,295,'TRNP-23',23,'TRNP','TRNP-23',23,'1','/1','/1500','2023-07-15','Cash','',0,0,1500,1500,1,'2306adminFees','2024-03-14 10:45 52'),
(1019,295,'TRNP-79',79,'TRNP','TRNP-79',79,'2','/2','/4500','2024-03-13','Cash','',0,0,4500,4500,1,'2306adminFees','2024-03-14 10:55 23'),
(1073,230,'TRNP-94',94,'TRNP','TRNP-94',94,'1','/1','/5000','2024-03-19','Cash','',0,0,5000,5000,1,'2306adminFees','2024-03-18 10:48 04'),
(1074,230,'SCHL-794',794,'SCHL','SCHL-794',794,'7','/8','/1000','2024-03-19','Cash','',0,0,1000,1000,1,'2306adminFees','2024-03-18 10:48 09'),
(1076,102,'SCHL-794',794,'SCHL','SCHL-794',794,'7','/8','/4000','2024-03-19','Cash','',0,0,4000,4000,1,'2306adminFees','2024-03-19 04:58 56'),
(1104,214,'TRNP-106',106,'TRNP','TRNP-106',106,'2','/2','/1500','2024-03-22','Cash','',0,0,1500,1500,1,'2306adminFees','2024-03-22 07:42 11'),
(4,333,'SCHL-4',4,'SCHL','SCHL-4',4,'48','/54','/3500','2024-05-27','Cash','',0,0,3500,3500,1,'2306adminFees','2024-05-27 09:38 42'),
(17,300,'SCHL-16',16,'SCHL','SCHL-16',16,'47','/53','/6000','2024-06-03','Cash','',0,0,6000,6000,1,'2306adminFees','2024-06-03 05:28 30'),
(103,334,'SCHL-101',101,'SCHL','SCHL-101',101,'45','/51','/4000','2024-06-10','Cash','',0,0,4000,4000,1,'2306adminFees','2024-06-10 09:09 29'),
(147,294,'SCHL-143',143,'SCHL','SCHL-143',143,'46','/52','/2500','2024-06-26','Cash','',0,0,2500,2500,1,'2306adminFees','2024-06-26 06:44 17'),
(197,295,'SCHL-192',192,'SCHL','SCHL-192',192,'56','/62','/530','2024-07-02','Cash','',0,0,530,530,1,'2306adminFees','2024-07-02 05:17 34'),
(272,95,'SCHL-266',266,'SCHL','SCHL-266',266,'62','/68','/560','2024-07-04','Cash','',0,0,560,560,1,'2306adminFees','2024-07-04 04:58 18'),
(325,11,'SCHL-318',318,'SCHL','SCHL-318',318,'61','/67','/450','2024-07-08','Cash','',0,0,450,450,1,'2306adminFees','2024-07-08 10:35 22'),
(256,339,'SCHL-250',250,'SCHL','SCHL-250',250,'55','/61','/480','2024-07-03','Cash','',0,0,480,480,1,'2306adminFees','2024-07-10 05:08 38'),
(296,363,'SCHL-289',289,'SCHL','SCHL-289',289,'56','/62','/530','2024-07-04','Cash','',0,0,530,530,1,'2306adminFees','2024-07-15 07:34 55'),
(281,334,'SCHL-274',274,'SCHL','SCHL-274',274,'56','/62','/530','2024-07-04','Cash','',0,0,530,530,1,'2306adminFees','2024-07-18 09:13 07'),
(18,298,'SCHL-16',16,'SCHL','SCHL-16',16,'45','/51','/4500','2024-06-03','Cash','',0,0,4500,4500,1,'2306adminFees','2024-07-26 05:46 01'),
(104,334,'SCHL-101',101,'SCHL','SCHL-101',101,'45','/51','/3000','2024-06-10','Cash','',0,0,3000,3000,1,'2306adminFees','2024-07-26 05:49 35'),
(5,334,'SCHL-4',4,'SCHL','SCHL-4',4,'45','/51','/1200','2024-05-29','Cash','',0,0,1200,1200,1,'2306adminFees','2024-07-26 05:52 54'),
(23,232,'SCHL-21',21,'SCHL','SCHL-21',21,'46','/52','/5500','2024-06-03','Cash','',0,0,5500,5500,1,'2306adminFees','2024-07-26 06:00 36'),
(372,335,'SCHL-364',364,'SCHL','SCHL-364',364,'37','/46','/65','2024-07-29','Cash','',0,0,65,65,1,'2306adminFees','2024-07-29 08:02 28'),
(371,335,'SCHL-363',363,'SCHL','SCHL-363',363,'36','/45','/35','2024-07-29','Cash','',0,0,35,35,1,'2306adminFees','2024-07-29 08:02 56'),
(373,335,'SCHL-365',365,'SCHL','SCHL-365',365,'65','/72','/370','2024-07-29','Cash','',0,0,370,370,1,'2306adminFees','2024-07-29 08:03 05'),
(374,335,'SCHL-366',366,'SCHL','SCHL-366',366,'69','/76','/470','2024-07-29','Cash','',0,0,470,470,1,'2306adminFees','2024-07-29 08:03 10'),
(44,359,'SCHL-42',42,'SCHL','SCHL-42',42,'44','/50','/6000','2024-06-05','Cash','',0,0,6000,6000,1,'2306adminFees','2024-08-02 06:01 38'),
(553,27,'SCHL-545',545,'SCHL','SCHL-545',545,'73','/80','/30','2024-08-02','Cash','',0,0,30,30,1,'2306adminFees','2024-08-02 10:54 08'),
(779,56,'SCHL-770',770,'SCHL','SCHL-770',770,'73','/80','/30','2024-08-13','Cash','',0,0,30,30,1,'2306adminFees','2024-08-13 05:12 32'),
(778,56,'SCHL-769',769,'SCHL','SCHL-769',769,'72','/79','/60','2024-08-13','Cash','',0,0,60,60,1,'2306adminFees','2024-08-13 05:12 38'),
(777,56,'SCHL-768',768,'SCHL','SCHL-768',768,'68','/75','/420','2024-08-13','Cash','',0,0,420,420,1,'2306adminFees','2024-08-13 05:12 42'),
(776,56,'SCHL-767',767,'SCHL','SCHL-767',767,'66','/73','/400','2024-08-13','Cash','',0,0,400,400,1,'2306adminFees','2024-08-13 05:12 46'),
(224,56,'SCHL-218',218,'SCHL','SCHL-218',218,'61','/67','/450','2024-07-02','Cash','',0,0,450,450,1,'2306adminFees','2024-08-13 05:12 50'),
(830,316,'SCHL-821',821,'SCHL','SCHL-821',821,'73','/80','/30','2024-08-19','Cash','',0,0,30,30,1,'2306adminFees','2024-08-19 07:23 11'),
(829,316,'SCHL-820',820,'SCHL','SCHL-820',820,'72','/79','/60','2024-08-19','Cash','',0,0,60,60,1,'2306adminFees','2024-08-19 07:23 15'),
(828,316,'SCHL-819',819,'SCHL','SCHL-819',819,'68','/75','/420','2024-08-19','Cash','',0,0,420,420,1,'2306adminFees','2024-08-19 07:23 21'),
(827,316,'SCHL-818',818,'SCHL','SCHL-818',818,'66','/73','/400','2024-08-19','Cash','',0,0,400,400,1,'2306adminFees','2024-08-19 07:23 29'),
(853,189,'SCHL-840',840,'SCHL','SCHL-840',840,'68','/75','/420','2024-09-13','Cash','',0,0,420,420,1,'2306adminFees','2024-09-13 05:32 35'),
(855,189,'SCHL-842',842,'SCHL','SCHL-842',842,'73','/80','/30','2024-09-13','Cash','',0,0,30,30,1,'2306adminFees','2024-09-13 05:33 26'),
(271,19,'SCHL-265',265,'SCHL','SCHL-265',265,'59','/65','/590','2024-07-04','Cash','',0,0,590,590,1,'2306adminFees','2024-09-24 05:30 03'),
(903,105,'SCHL-889',889,'SCHL','SCHL-889',889,'72','/79','/60','2024-09-25','Cash','',0,0,60,60,1,'2306adminFees','2024-09-25 07:44 12'),
(902,105,'SCHL-888',888,'SCHL','SCHL-888',888,'44','/50','/3000','2024-09-25','Cash','',0,0,3000,3000,1,'2306adminFees','2024-09-25 07:44 16'),
(369,105,'SCHL-361',361,'SCHL','SCHL-361',361,'63','/69','/600','2024-07-26','Cash','',0,0,600,600,1,'2306adminFees','2024-09-25 07:44 21'),
(738,105,'SCHL-729',729,'SCHL','SCHL-729',729,'70','/77','/460','2024-08-06','Cash','',0,0,460,460,1,'2306adminFees','2024-09-25 07:44 25'),
(944,195,'SCHL-928',928,'SCHL','SCHL-928',928,'47','/53','/3500','2024-11-30','Cash','',0,0,3500,3500,1,'2306adminFees','2024-11-30 04:33 58'),
(961,410,'SCHL-944',944,'SCHL','SCHL-944',944,'45','/51','/4000','2024-12-04','Cash','',0,0,4000,4000,1,'2306adminFees','2024-12-04 09:15 10'),
(126,244,'TRNP-1',1,'TRNP','TRNP-1',1,'4','/4','/3000','2024-06-14','Cash','',0,0,3000,3000,1,'2306adminFees','2024-12-06 09:16 22'),
(983,240,'SCHL-965',965,'SCHL','SCHL-965',965,'47','/53','/4000','2024-12-18','Cash','',0,0,4000,4000,1,'2306adminFees','2024-12-18 06:23 30'),
(984,240,'SCHL-966',966,'SCHL','SCHL-966',966,'72','/79','/60','2024-12-18','Cash','',0,0,60,60,1,'2306adminFees','2024-12-18 06:23 34'),
(994,334,'SCHL-974',974,'SCHL','SCHL-974',974,'50','/56','/3500','2025-01-03','Cash','',0,0,3500,3500,1,'2306adminFees','2025-01-03 06:44 05'),
(1061,242,'SCHL-1040',1040,'SCHL','SCHL-1040',1040,'53','/59','/500','2025-03-01','Cash','',0,0,500,500,1,'2306adminFees','2025-03-01 05:11 39'),
(1154,55,'SCHL-1132',1132,'SCHL','SCHL-1132',1132,'47','/53','/4000','2025-03-19','Cash','',0,0,4000,4000,1,'2306adminFees','2025-03-19 07:20 18'),
(55,285,'SCHL-53',53,'SCHL','SCHL-53',53,'46','/52','/4000','2024-06-07','Cash','',0,0,4000,4000,1,'2306adminFees','2025-03-24 09:52 26'),
(143,285,'SCHL-139',139,'SCHL','SCHL-139',139,'46','/52','/500','2024-06-25','Cash','',0,0,500,500,1,'2306adminFees','2025-03-24 09:52 29'),
(1,298,'SCHL-1',1,'SCHL','SCHL-1',1,'47','/53','/5500','2025-06-10','Cash','',0,0,5500,5500,1,'2306adminFees','2025-06-10 07:07 14'),
(30,423,'SCHL-29',29,'SCHL','SCHL-29',29,'48','/54','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees','2025-06-11 07:06 00'),
(29,423,'SCHL-28',28,'SCHL','SCHL-28',28,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees','2025-06-11 07:06 04'),
(28,423,'SCHL-27',27,'SCHL','SCHL-27',27,'48','/54','/3000','2025-06-11','Cash','',0,0,3000,3000,1,'2306adminFees','2025-06-11 07:06 19'),
(27,423,'SCHL-26',26,'SCHL','SCHL-26',26,'45','/51','/4500','2025-06-11','Cash','',0,0,4500,4500,1,'2306adminFees','2025-06-11 07:06 44'),
(73,87,'SCHL-72',72,'SCHL','SCHL-72',72,'44','/50','/4000','2025-06-16','Cash','',0,0,4000,4000,1,'2306adminFees','2025-06-16 05:03 10'),
(82,154,'SCHL-81',81,'SCHL','SCHL-81',81,'44','/50','/3000','2025-06-16','Cash','',0,0,3000,3000,1,'2306adminFees','2025-06-16 06:28 08'),
(83,363,'SCHL-82',82,'SCHL','SCHL-82',82,'45','/51','/3500','2025-06-16','Cash','',0,0,3500,3500,1,'2306adminFees','2025-06-16 10:24 27'),
(113,440,'SCHL-112',112,'SCHL','SCHL-112',112,'47','/53','/5500','2025-06-19','Cash','',0,0,5500,5500,1,'2306adminFees','2025-06-20 06:27 21'),
(114,440,'SCHL-113',113,'SCHL','SCHL-113',113,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees','2025-06-20 06:27 24'),
(112,382,'SCHL-111',111,'SCHL','SCHL-111',111,'54','/60','/4500','2025-06-19','Cash','',0,0,4500,4500,1,'2306adminFees','2025-06-20 06:28 49'),
(111,382,'SCHL-110',110,'SCHL','SCHL-110',110,'47','/53','/5500','2025-06-19','Cash','',0,0,5500,5500,1,'2306adminFees','2025-06-20 06:28 53'),
(266,280,'SCHL-265',265,'SCHL','SCHL-265',265,'58','/64','/520','2025-07-07','Cash','',0,0,520,520,1,'2306adminFees','2025-07-07 07:01 29'),
(283,198,'SCHL-282',282,'SCHL','SCHL-282',282,'61','/67','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees','2025-07-12 05:23 46'),
(282,198,'SCHL-281',281,'SCHL','SCHL-281',281,'61','/67','/520','2025-07-09','Cash','',0,0,520,520,1,'2306adminFees','2025-07-12 05:23 51'),
(285,195,'SCHL-284',284,'SCHL','SCHL-284',284,'47','/53','/3000','2025-07-09','Cash','',0,0,3000,3000,1,'2306adminFees','2025-07-12 05:25 24'),
(174,290,'SCHL-173',173,'SCHL','SCHL-173',173,'46','/52','/4500','2025-06-30','Cash','',0,0,4500,4500,1,'2306adminFees','2025-07-17 10:11 25');
/*!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 AUTO_INCREMENT,
`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 */;
/*!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 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 */;
/*!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 */;
/*!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,
`Photos` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=458 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
('NIKHILA MALLAYYA HIREMATH',14,'None','4','A','225 109 956',9535471050,'',NULL,0,NULL,NULL),
('MALLIKARJUN GURULINGAPPA PATIL',12,'None','4','A','225 633 396',7411806282,'',NULL,0,NULL,NULL),
('CHANNABASAYYA SHARANABASAYYA HIREMATH',11,'None','4','A','229 942 135',9611642757,'',NULL,0,NULL,NULL),
('PUTTARAJ CHANNABASAPPA HUGAR',15,'None','4','A','231 507 281',9901104310,'',NULL,0,NULL,NULL),
('SAMARTH PARASAPPA BILAGI',16,'None','4','A','229 942 588',8296583539,'',NULL,0,NULL,NULL),
('SANJAYA BASAVARAJA SHIRAGUMPI',17,'None','4','A','225 102 835',9663679132,'',NULL,0,NULL,NULL),
('SANVI NINGAPPA KADLIMATTI',18,'None','4','A','225 113 545',9740881741,'','UP TO JUN 15',0,NULL,NULL),
('SNEHITH SHARANAPPA CHAVAN',305,'Male','4','A','123',9325832505,'','up to jun 10 2024',0,'',NULL),
('VAISHNAVI RAJASHEKHAR BILEBHAVI',21,'None','4','A','225 115 593',8095463155,'',NULL,0,NULL,NULL),
('AISHWARY BHEEMAPPA GURIKAR',22,'None','5','A','209 579 195',9741318862,'',NULL,0,NULL,NULL),
('AKASH JAKKAPPA GURIKAR',23,'None','5','A','209 575 628',9741318862,'','',0,NULL,NULL),
('ARPITA KALLAYYA DHARAWAD',26,'None','5','A','221 951 935',7975618155,'','REFFERS BY SWAMIJI',0,NULL,NULL),
('ARYAN BASAVARAJ GORABAL',27,'None','5','A','209 776 407',7259704872,'',NULL,0,NULL,NULL),
('MAHEBOOB BANDENAVAJ GUBYADI',28,'None','5','A','221 208 333',9740384709,'',NULL,0,NULL,NULL),
('MANJUNATH GANESH PUJARI',29,'None','5','A','219 335 062',9945369452,'','up to 15 jun 2025',0,NULL,NULL),
('MANOJ PARASAPPA BILAGI',30,'None','5','A','221 208 254',8296583539,'',NULL,0,NULL,NULL),
('MOHAMMED AATEEF ABDULREHMAN TAHASHILDAR',31,'None','5','A','221 951 981',0,'','REFERS FROM NIDGUNDI SIR',0,NULL,NULL),
('MUKKUNGOUDA PRASHANTGOUDA GOUDAR',189,'Male','5','A','1',0,'',NULL,0,NULL,NULL),
('PRAJWAL MUKAPPA JAGGAL',33,'None','5','A','221 951 968',9945365809,'',NULL,0,NULL,NULL),
('PREMKUMAR MANJUNATH TOTAGER',34,'None','5','A','214 114 959',7795830677,'','',0,NULL,NULL),
('RENUKA BASAVARAJ MULIMANI',35,'None','5','A','221 208 074',7760722477,'',NULL,0,NULL,NULL),
('Anil Sanganagouda Doddagoudar ',444,'Male','6','A','',9845461069,'',NULL,0,NULL,NULL),
('SHRADDA IRANNA BILAGI',38,'None','5','A','214 115 242',9108945883,'',NULL,0,NULL,NULL),
('VAIBHAV RAJASHEKAR BELEBHAVI',41,'None','5','A','214 115 556',8095463155,'',NULL,0,NULL,NULL),
('Renuka B Hadapad',443,'Male','2','A','',0,'',NULL,0,NULL,NULL),
('VINAYAK KALLAPPA KUMBAR',44,'None','5','A','219 334 882',9740770819,'',NULL,0,NULL,NULL),
('AMARUTH SIDDANAGOUDA GOUDAR',46,'None','6','A','202 032 379',9611213891,'','UP TO JUN 10 2024',0,NULL,NULL),
('BASAVARAJ SANGAPPA KAJAGALL',47,'None','6','A','172 407 701',0,'','Absent',0,NULL,NULL),
('BASAVARAJ SHIVAPPA DATTANDI',48,'None','6','A','172 408 678',0,'','Abasent',0,NULL,NULL),
('BHAGYASRI INDI',49,'None','6','A','148 707 088',99022115408,'','RTE',0,NULL,NULL),
('BHARATH INDI',50,'None','6','A','149 006 687',99022115408,'','RTE\r\n',0,NULL,NULL),
('DIVYA MALLANAGOUDA GOUDAR',51,'None','6','A','202 033 112',9611213891,'','UP 15/06/25 REFFERS BY HEAD MASATER',0,NULL,NULL),
('MAHEEN AMEER HAMAJA TEGGINAMANI',54,'None','6','A','204 061 432',8546808282,'','3000 cannera bank',0,NULL,NULL),
('MALIYAPPA KALLESH KUMBAR',55,'None','6','A','172 406 981',9740770819,'','',0,NULL,NULL),
('MEHABOOBSAB DASTAGIRASAB GANJIHAL',56,'None','6','A','204 232 713',9741953864,'',NULL,0,NULL,NULL),
('NIRMALA HUCHESH NIDGUNDI',58,'None','6','A','148 794 186',8147132120,'','RTE',0,NULL,NULL),
('PRAVEEN HANAMANT DIGGI',59,'None','6','A','172 406 658',7019062551,'','',0,NULL,NULL),
('PRADEEP ISHVARAPPA TEGGI',60,'None','6','A','148 799 035',0,'','RTE',0,NULL,NULL),
('SAIVAIBHAV GANGADHAR MANGALAGUDDA',63,'None','6','A','172 404 224',0,'','Abesent',0,NULL,NULL),
('SAKSHI GURULINGAPPA PATIL',64,'None','6','A','204 232 408',9611316073,'',NULL,0,NULL,NULL),
('SANGAMESH IRAPPA GANIGER',66,'None','6','A','172 408 577',0,'','Abasent',0,NULL,NULL),
('SANGAMESH SANGANABASAPPA BARAKER',67,'None','6','A','200 790 335',9901968390,'',NULL,0,NULL,NULL),
('SANGEETA MALLIKARJUN HADAPAD',68,'None','6','A','204 048 695',0,'','Abasent',0,NULL,NULL),
('SHRISHAIL NIJAPPA BILAKERI',71,'None','6','A','172 404 854',9591646458,'','',0,NULL,NULL),
('SNEHA CHANNABASAPPA HUGAR',72,'None','6','A','206 817 603',9901104310,'',NULL,0,NULL,NULL),
('SHABARISH RAMESH HADAPAD',73,'None','6','A','148 667 793',9945542134,'','RTE',0,NULL,NULL),
('TANUSHREE DAYANADA KALLIMANI',74,'None','6','A','156 765 071',8050694224,'',NULL,0,NULL,NULL),
('VIJAYALAXMI PARASAPPA KOKATI',75,'None','6','A','172 409 018',0,'','TC',0,NULL,NULL),
('VITHAL DYAMANNA PUJARI',76,'None','6','A','172 408 869',0,'','DOUBLE ENTRY',0,NULL,NULL),
('VITTAL ADIVEPPA MULIMANI',77,'None','6','A','172 407 363',0,'','Abasent',0,NULL,NULL),
('VIVAN KUSHAL RAMESH HIRAL',78,'None','6','A','206 017 367',0,'','Abasent',0,NULL,NULL),
('ABHINAV BASAVARAJ GORABAL',79,'None','7','A','189 098 064',7259704872,'','',0,NULL,NULL),
('ABHISHEK YAMANAPPA CHALAWADI',80,'None','7','A','189 524 655',9019398245,'',NULL,0,NULL,NULL),
('ANUP PRAKASH JAYA',81,'None','7','A','162 501 557',9945356360,'','RTE',0,NULL,NULL),
('ANUSHKA KALLAYYA DHARAVAD',82,'None','7','A','162 709 997',9916890158,'','',0,NULL,NULL),
('BHARAMAVVA BASAPPA JAGGAL',84,'None','7','A','194 073 243',8970821010,'','',0,NULL,NULL),
('BHARATKUMAR HUCHAPPA GULEDAGUDD',85,'None','7','A','194 822 392',0,'',NULL,0,NULL,NULL),
('HANAMANT PARASAPPA SUNAGAR',86,'None','7','A','194 072 894',8884785009,'','',0,NULL,NULL),
('LAKSHMIBAI RAGHAVENDRA MALLI',87,'None','7','A','194 071 738',0,'','Ir Regular',0,NULL,NULL),
('MALLIKARJUN BASAVARAJ MULIMANI',88,'None','7','A','194 116 263',9972135438,'','TC',0,NULL,NULL),
('MUTTURAJ CHANDRASHEKHAR TOTAGER',89,'None','7','A','194 072 128',7829723725,'',NULL,0,NULL,NULL),
('PRANITH HUCHESH BAPRI',91,'None','7','A','162 268 255',8050211883,'','RTE',0,NULL,NULL),
('REHAN ABDULREHAMAN TAHASHILDAR',92,'None','7','A','162 335 687',9986162696,'',NULL,0,NULL,NULL),
('TARUN RAJSHEKHAR RUDGI',320,'Male','7','A','1256',9880899409,'','TC',0,NULL,NULL),
('SHREYA IRANNA BILAGI',95,'None','7','A','162 455 591',7975981967,'','RTE',0,NULL,NULL),
('VARUN BASAVARAJ SAJJANAR',97,'None','7','A','194 072 473',9686471069,'','Abasent',0,NULL,NULL),
('VIDHYA PATTIL',98,'None','7','A','162 453 565',9740825142,'','RTE',0,NULL,NULL),
('VIRUPAKSHAPPA ANGADI',99,'None','7','A','162 544 724',9731884497,'','RTE',0,NULL,NULL),
('YALLAPPA KAMANNA KATARI',348,'Male','7','A','',8197477413,'','DISCONTINUE',0,NULL,NULL),
('SANTOSH UMESH ADIN',347,'Male','3','A','',9632772959,'','UP TO JUN 10 2024',0,NULL,NULL),
('VITTAL SHREEKANT BILAGI',346,'Male','UKG','A','0',9740384753,'','UP TO JUN 2024',0,'',NULL),
('NIRANJAN CHINNAPPA MANGALGUDDA ',345,'Male','2','A','0',8792272524,'','UP TO JUN 10 2024',0,'',NULL),
('AJITA SOMAPPA RATHOD ',402,'Male','7','A','',0,'','Abasent',0,NULL,NULL),
('HUCHCHESH BASAPPA GANIGER',343,'Male','UKG','A','',9591088316,'','UP TO JUN 10',0,NULL,NULL),
('CHETAN AGOUDA RAVI',342,'Male','7','A','',7483420778,'','UP TO JUN 15',0,NULL,NULL),
('ADARSH SURESH PUJARI',341,'Male','LKG','A','',7889975552,'','UP TO JUN 10 2024',0,NULL,NULL),
('AKASHA YAMANAPPA KADEMANI',340,'Male','7','A','',9164410701,'',NULL,0,NULL,NULL),
('PRAJWAL YAMANAPPA SULIKERI',339,'Male','1','A','12',7022766438,'',' UP TO JUN 15 2025',0,'',NULL),
('DURGAPPA HANAMAT TALAWAR',154,'Male','7','A','123',8867221661,'','UP TO JUN 15',0,NULL,NULL),
('ANUSHKA WALIKAR',242,'Male','3','A','',9900726312,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,NULL,NULL),
('SAMARTHA MUTTAPPA MULIMANI',151,'Male','4','A','',0,'',NULL,0,NULL,NULL),
('APHIK CANDUSAB VALIKAR',158,'Male','7','A','',9945048436,'','',0,NULL,NULL),
('ANAND SOMASHEKHARAYYA HUCHHESHVARMATHA',222,'Male','3','A','',7975684141,'','REMARK BY SWAMIJI',0,NULL,NULL),
('MAHANTESH SURESHA MAGI',160,'Male','7','A','',0,'','up to 15/06/2025',0,NULL,NULL),
('SANDEEP BASAVARAJ MULIMANI',289,'Male','2','A','00',9972135438,'',' REFFERS TO HEAD MASTER',0,'',NULL),
('HASANSAB AMINSAB VALIKAR',213,'Male','7','A','',8197987167,'',NULL,0,NULL,NULL),
('GURULINGPPA MAHADEV BIRADAR',163,'Male','7','A','',9008710136,'','',0,NULL,NULL),
('VERESH MUTTAPPA MANTUR',164,'Male','7','A','',9008318715,'','',0,NULL,NULL),
('RANGNATH BANNIDINNI',318,'Male','3','A','82',0,'','REFERS TO HEAD MASTER UP TO 10/06/2023',0,NULL,NULL),
('SHRAVANI SHIVANAD NAYMGOUDA',171,'Male','7','A','23',7483403872,'','UP TO JUN 15',0,'',NULL),
('ANITA BIMAPPA GURIKAR',172,'Male','7','A','',9663893263,'','',0,NULL,NULL),
('AKSHATA JAKKAPPA GURIKAR',316,'Male','7','A','1',9741318862,'','',0,NULL,NULL),
('ALFIYA RAJASAB BANDGI',217,'Male','3','A','',8123610422,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,NULL,NULL),
('PRATIKSHA YAMANAPPA SULIKERI',338,'Male','UKG','A','0',7022766438,'','up to jun 15 2025',0,'',NULL),
('SIDHARTH MANJUNATH DODAMANI',336,'Male','UKG','A','',7204102418,'','DISKCOUNT',0,NULL,NULL),
('SHREYS PARASAPPA MISI',335,'Male','3','A','',9902017632,'','UP TO JUN 10 2024',0,NULL,NULL),
('BASAMMA DYAMANNA HULLUR',212,'Male','7','A','',7676365346,'','',0,NULL,NULL),
('SIDDALINGAYYA SHIVKUMAR HUCHCHESHWARAMATHT',314,'Male','7','A','194822867',9591249444,'','REMARKS BY SWAMIJI',0,NULL,NULL),
('TANUSHREE MANJUNATH TOTAGER',313,'Male','7','A','123',0,'','',0,NULL,NULL),
('PRITAM IRANNA KUMBAR',299,'Male','1','A','0',9663064921,'',NULL,0,'',NULL),
('YASHAVANTAKUMAR ASANGEPPA MISHI',334,'Male','2','A','0',9902017632,'','UP TO JUN 10 2024',0,'',NULL),
('BHARAMAPPA MANJUNATH JAGGAL',332,'Male','UKG','A','1',8197238515,'','up to jun 15 2025',0,'',NULL),
('ANUSHREE YAMANAPPA CHALAVADI',198,'Male','5','A','',8951239132,'',NULL,0,NULL,NULL),
('SHAMBAVI SHANKARAPPA BALLA',210,'Male','5','A','',9845710453,'',NULL,0,NULL,NULL),
('DILIP SHIVAPPA YANKANNAVVAR',190,'Male','5','A','',9113000892,'',NULL,0,NULL,NULL),
('YALAGURESHA KANAKAPPA GOUDR',191,'Male','5','A','',9886630655,'',NULL,0,NULL,NULL),
('MANJUNATH HUCHAPPA SHIRAGUMPI',192,'Male','5','A','',9019637208,'',NULL,0,NULL,NULL),
('MALLIKARJUN PARASAPPA MADIKERI',193,'Male','5','A','',0,'',NULL,0,NULL,NULL),
('PRAKRUTI KASHINATH KUMBAR',194,'Male','5','A','',0,'',NULL,0,NULL,NULL),
('APIKSHA GURUBASYYA HIREMATH',195,'Male','5','A','',7760933757,'',NULL,0,NULL,NULL),
('TUNGASREE SOMAPPA LAMANI',196,'Male','5','A','',8792306486,'','UP TO 15 JUN 2025',0,NULL,NULL),
('MAHAMMAD ARFAN TASILDAR',304,'Male','4','A','123',0,'','',0,NULL,NULL),
('PARASU BASAVRAJ HADAPAD',199,'Male','4','A','12',8088037517,'','UP TO 15/06/2025 REFFERS BY HEAD MASTER',0,NULL,NULL),
('ARADHYA ANILKUMAR HUCHESHWARMATH',310,'Male','3','A','',0,'','REFFERS BY SWAMIJI',0,NULL,NULL),
('SHASHIDHAR SANGANA GANJIYAL',202,'Male','4','A','',9845370242,'','TC',0,NULL,NULL),
('SANGANGOUDA PAPANGOUDA GOUDAR',203,'Male','4','A','',7483066754,'',NULL,0,NULL,NULL),
('HANMANTH MANJUNATH BHOVI',204,'Male','4','A','',8618303729,'',NULL,0,NULL,NULL),
('APHIYA CHANSAB VALIKAR',248,'Male','4','A','',9945048436,'','',0,NULL,NULL),
('RAKSHITA PARASAPPA GHANTI',206,'Male','4','A','',7204632232,'','TC',0,NULL,NULL),
('SHRAVANA ASHOK ITAGI',323,'Male','6','A','206817704',0,'','',0,NULL,NULL),
('PRABHAVATI KANKESH GOUDAR',207,'Male','6','A','',9886630655,'',NULL,0,NULL,NULL),
('PAVITRA DYAMANNA KUDARIMANI',209,'Male','6','A','',8970056380,'','',0,NULL,NULL),
('NIRANJAN SHIVKUMAR HUCHESHWARMATH',211,'Male','5','A','',9535184233,'','REMARKS BY SWAMIJI',0,NULL,NULL),
('PRATEKSHA HUCCHESH BAPRI',223,'Male','3','A','',8050211883,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,NULL,NULL),
('AROHI ANILKUMAR KALYANASHETTI',292,'Male','3','A','',9901174103,'','Up To 6-07-2023',0,NULL,NULL),
('SANVI SHIVKUMAR BENAKATTI',243,'Male','3','A','',7406049814,'','UP TO 15-6-2025\r\n REFFERSTO HEAD MASTER',0,NULL,NULL),
('SANNIDI KALLAYYA DHARWAD',226,'Male','3','A','',0,'','REFFERS BY SWAMIJI',0,NULL,NULL),
('BASAVARAJ SHRIKANTH HUGAR',227,'Male','3','A','',6363817266,'','TC',0,NULL,NULL),
('BHARATA HUCHCHAPPA MEESI',247,'Male','3','A','',6364794089,'','TC ',0,NULL,NULL),
('LAXMAN HANAMANTH KALERI',230,'Male','3','A','',9611675612,'','TC out',0,NULL,NULL),
('KARTIK TULAJAPPA PUJARI',231,'Male','3','A','',9663065415,'','Transfer to TC',0,NULL,NULL),
('ABHISHEKAGOUDA SIDAPPA SHIRGUMPI',232,'Male','3','A','',9353717720,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,NULL,NULL),
('SIDDARTH HANAMANT MALANNAVAR',300,'Male','3','A','',0,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,NULL,NULL),
('ARADHYA AMBARISH TALAWAR',240,'Male','3','A','',7795118629,'','UP TO 10-6-2023 ERFFERS TO HEAD MASER',0,NULL,NULL),
('ABHISHEK RAMESH ILAKAL',236,'Male','3','A','0',8095803897,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,'',NULL),
('VITTAL PARASAPPA PUJARI',237,'Male','3','A','',9980056276,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER\r\n',0,NULL,NULL),
('MADHU HUCHAPPA SIRAGUMPI',302,'Male','3','A','',0,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,NULL,NULL),
('MALLAMMA HUCHESH GOUDAR',241,'Male','3','A','',7406064937,'','up to 15-06-25 reffers by head master',0,NULL,NULL),
('SANJANA HADAPAD ',327,'Male','3','A','',0,'','REFFER BY HEAD MASTER',0,NULL,NULL),
('VIJAY NAGAPPA MULIMANI',244,'Male','3','A','123',9845645212,'','up to 10-6-2023 REFFERS TO HEAD MASTER',0,NULL,NULL),
('BASAVARAJ IRAPPA KUMBAR',245,'Male','2','A','0',9663064921,'','up to 10-06-2023',0,'',NULL),
('BHARAMAPPA RAMESH MULIMANI',249,'Male','4','A','',0,'','TC',0,NULL,NULL),
('YALLAPPA MANGALGUDDA',457,'Male','UKG','A','',0,'',NULL,0,NULL,NULL),
('NANDEESH CHAPI',456,'Male','LKG','A','0',9740796363,'',NULL,0,NULL,NULL),
('PREETAM PREMARAJ BILAGI',287,'Male','1','A','00',7204466839,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,'',NULL),
('RENUKA PARASAPPA MADIKERI',285,'Male','2','A','02',8792315046,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,'',NULL),
('VEEDA RAJU IRAL',414,'Male','LKG','A','',0,'',NULL,0,NULL,NULL),
('MAHESH ANDANAPPA JAMBAGI',277,'Male','2','A','0',9591081967,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,'',NULL),
('CHANDU YAMANAPPA MALAKSAMUDRA',280,'Male','2','A','0',9741359917,'','UP TO 10-6-2024 REFFERS TO HEAD MASTER',0,'',NULL),
('MALIKARJUN PUJARI',409,'Male','7','A','',0,'','RTE',0,NULL,NULL),
('MALLESH BASAVRAJ MULIMANI',283,'Male','2','A','00',7760722477,'',NULL,0,'',NULL),
('RAJANI MAHANTESH TAPALDAR',294,'Male','2','A','01',8197491985,'','UP TO 10-6-2023 REFFERS TO HEAD MASTER',0,'',NULL),
('ANUPURNA MALLANGOUDA GOUDAR',295,'Male','1','A','00',9611213891,'','UP TO 15-6-2025 REFFERS BY HEAD MASTER',0,'',NULL),
('SADHVANI GURUPADAPPA KADLIMATTI',315,'Male','UKG','A','123',7406875410,'','',0,NULL,NULL),
('ADITHI AMBARISH TALAVAR',406,'Male','UKG','A','0',7795118629,'',NULL,0,'',NULL),
('ARFA TAHSILDAR',290,'Male','1','A','0',0,'','up to jun 15 2025',0,'',NULL),
('BHAGYALAXIMI SIDDAPPA SHIRGUMPI',291,'Male','1','A','1',9535717720,'','UP TO 15-6-2025 REFFERS TO HEAD MASTER',0,'',NULL),
('SRIDHAR HANAMANTH MALANNAVAR',298,'Male','2','A','00',9008120047,'','UP TO 15-6-2025 REFFERS BY HEAD MASTER',0,'',NULL),
('ARUNKUMAR YAMANAPPA CHALAVADI',321,'Male','2','A','1',9019398245,'','REMARK REFFERS TO HEAD MASTER UP TO 10/06/2024',0,'',NULL),
('RANGNATH GURUPADAPPA PUJARI',293,'Male','2','A','0',9902654164,'','UP TO 10-6-2024 REFFERS TO HEAD MASTER',0,'',NULL),
('Sakshi Vijay Hadapad',455,'Male','UKG','A','',7022246478,'',NULL,0,NULL,NULL),
('SUBRAMANYA HANAMANTH CHALVADI',312,'Male','5','A','12',7899367952,'','',0,NULL,NULL),
('VAISHNAVI RAMESHA BILAGI ',454,'Male','LKG','A','',7892015328,'',NULL,0,NULL,NULL),
('Venkatesh Basavaraj Hunakunti',453,'Male','UKG','A','',0,'',NULL,0,NULL,NULL),
('VASISHTA GIRISH SARAGANACHARYA',349,'Male','2','A','0',7899382919,'','up to 15 jun 2025',0,'',NULL),
('Ranganath Pujari',350,'Male','1','A','0',9980056276,'','up to jun 15 2025',0,'',NULL),
('SIDDARTH PRAKASH BILAGI',351,'Male','LKG','A','',9663925474,'',' UP TO JUN 10 2024',0,NULL,NULL),
('SHRISHAIL PRAKASH BILAGI',352,'Male','2','A','0',9663925474,'','UP TO JUN 10 2024',0,'',NULL),
('PRADEEP MALAPPA BILAGI',353,'Male','7','A','',9686409673,'',NULL,0,NULL,NULL),
('KIRATI NINGANGOUDA PATIL',354,'Male','7','A','',9739531077,'','up to 15 jun 2025',0,NULL,NULL),
('MADHU HUCHANGOUDA PATIL',355,'Male','7','A','',9739531077,'','up to 15 jun 2025',0,NULL,NULL),
('RENUKA MALLESH SHIRAGUMPI',356,'Male','2','A','0',0,'','UP TO JUN 15 2025',0,'',NULL),
('APPAJIGOUDA MALESH SHIRAGUMPI',357,'Male','4','A','',0,'','UP TO JUN 15 2025',0,NULL,NULL),
('SHRISHAIL BASAPPA JAGGAL',358,'Male','4','A','0',0,'','',0,'',NULL),
('APIKSHA GYANAPPA MADIKERI',408,'Male','UKG','A','0',9686475661,'',NULL,0,'',NULL),
('Ramya Gurusangappa Meti',452,'Male','5','A','',0,'',NULL,0,NULL,NULL),
('NAVEEN SANGAPPA KOKATI',361,'Male','6','A','',9663938385,'','UP TO JUN 10 2024',0,NULL,NULL),
('Meghana Mallappa Kumbar',362,'Male','UKG','A','0',9945819321,'',NULL,0,'',NULL),
('SAANVI HUCHESHA BILAGI',363,'Male','UKG','A','00',9900688139,'','UP TO JUN 15',0,'',NULL),
('Shantavva Ramappa Hunakunti',365,'Male','5','A','',7259188465,'','up to jun 10 2024',0,NULL,NULL),
('Sandeep Basanagouda Goudar',451,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('SHARANABASAYYA HIREMATH',367,'Male','6','A','',9535181706,'',NULL,0,NULL,NULL),
('KARATIK RAMESH ILAKAL',450,'Male','5','A','0',0,'',NULL,0,'',NULL),
('SHREYAS KIRAN KANDAGAL',369,'Male','2','A','0',9591088904,'','UP TO JUN 10 2024',0,'',NULL),
('SAMARTH JADI',370,'Male','5','A','',7483159979,'',NULL,0,NULL,NULL),
('VITTAL MALAPPA JADI',371,'Male','7','A','',9972599197,'',NULL,0,NULL,NULL),
('Somaya Mupaya Ghanti',449,'Male','6','A','',9880132026,'',NULL,0,NULL,NULL),
('Boramma Siddangouda Goudar',403,'Male','UKG','A','0',0,'','UP TO 15/06/2025 ',0,'',NULL),
('KIRAN HANAMANTH SANGONDI',373,'Male','3','A','',7204102192,'',NULL,0,NULL,NULL),
('Shivu Muttappa Rathod ',448,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('RUKMINI BASAVARAJ AMBIGER',375,'Male','2','A','0',9113825498,'',' UP TO JUN 10 2024',0,'',NULL),
('MADEVI TAMMANEPPA BEVINMATTI',376,'Male','1','A','1',0,'','UP TO JUN 15 2025',0,'',NULL),
('Manasa Hucchesh Goudar',377,'Male','UKG','A','0',7406064937,'','up to jun 15 2025',0,'',NULL),
('ARADHYA TIPPANNA GURIKAR ',378,'Male','UKG','A','5',7899485395,'','UP TO JUN 15',0,'',NULL),
('MANJUNATH SHARANAPPA HUNAKUNTI',379,'Male','6','A','',7204466412,'',' UP TO JUN 10 2024',0,NULL,NULL),
('Krishna Muttappa Chavan',447,'Male','LKG','A','',0,'',NULL,0,NULL,NULL),
('MUDAKAPPA KALIGUDDA',381,'Male','7','A','',9108739916,'','UP TO JUN 15 2025',0,NULL,NULL),
('SANGEETA PANCHAPPA UMACHAGI',382,'Male','5','A','',9900622168,'','',0,NULL,NULL),
('Prutvi Muttappa Chavan',446,'Male','1','A','',0,'',NULL,0,NULL,NULL),
('PRAJJWAL ADIYAPPA KOGANNAVAR',384,'Male','4','A','',9741603502,'','UP TO JUN 10 2024',0,NULL,NULL),
('BHARATH KECHANAGOUDA GOUDAR',385,'Male','3','A','',9916232818,'',NULL,0,NULL,NULL),
('PARASAPPA RAYAPPA CHALAVADI',386,'Male','2','A','0',9148334290,'','UP TO 10 2024',0,'',NULL),
('VEDANT HOOLAGERI ',387,'Male','UKG','A','0',9591796817,'','UP TO JUN 10 2025',0,'',NULL),
('CHANDU MUDAPUJI',388,'Male','2','A','0',7758949283,'','UP TO 10 2024',0,'',NULL),
('PURNANANDA BASAPPA HULASGERI',389,'Male','7','A','',9740769048,'','UP TO JUN 15',0,NULL,NULL),
('AYAAN LATISAB TAHASHILDAR',390,'Male','1','A','0',9880699787,'',' UP TO 15 JUN 2025',0,'',NULL),
('MAHESH ASHOK HARADOLLI',391,'Male','UKG','A','2',7259788765,'','UP TO JUN 15',0,'',NULL),
('SHIVARAJ HANAMANTAPPA HARADOLLI',392,'Male','UKG','A','1',9880610464,'','UP TO JUN 15',0,'',NULL),
('ARADHYA SHANKARAPPA CHAVAN',445,'Male','UKG','A','',9611866143,'',NULL,0,NULL,NULL),
('SHREYA MANJUNATH PUJARI',442,'Male','LKG','A','0',9902439541,'',NULL,0,'',NULL),
('PAVITRA BASAVRAJ HADAPAD',395,'Male','1','A','1',7349699546,'','UP TO15 JUN 2025',0,'',NULL),
('SMITHA NINGAPPA KOLLOLLI',441,'Male','1','A','',9663683416,'',NULL,0,NULL,NULL),
('KRISHNA GOUDAR',397,'Male','2','A','0',9916232818,'',NULL,0,'',NULL),
('MANOJ CHANABASAVARAJ BALEIGER',398,'Male','UKG','A','0',7892510147,'',NULL,0,'',NULL),
('SIDDARTH PARASAPPA SUNAGAR',399,'Male','4','A','',8884785009,'',NULL,0,NULL,NULL),
('PRAJWAL YAMANNAPPA MALAKSAMUDRA',400,'Male','1','A','0',9741359917,'','UP TO 15/06/2025 ',0,'',NULL),
('JYOTI SURESHA ACHANUR',401,'Male','UKG','A','0',8050383840,'',' REFFERS HEAD MASTER',0,'',NULL),
('TANUSHREE HUCHAPPA PATIL',404,'Male','3','A','0',0,'','UP TO JUN 15',0,'',NULL),
('GURU PANCHAPPA UMACHAGI',440,'Male','3','A','',9900622168,'','',0,NULL,NULL),
('BHAGYALAXMI SHRISHAILAPPA BARAKER',415,'Male','5','A','',0,'','UP TO JUN 15',0,NULL,NULL),
('IRANNA BASAVRAJ HUNKUNTI',416,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('VINAYAK MANIKERI',417,'Male','5','A','',0,'',NULL,0,NULL,NULL),
('KARATIK HIREKURUBAR',418,'Male','LKG','A','',0,'',NULL,0,NULL,NULL),
('SAMARTHA BANNIDINI',419,'Male','1','A','',0,'','UP TO 15/06/2025 REFFERS BY HEAD MASTER',0,NULL,NULL),
('Sagar Vadavadgi',420,'Male','6','A','',0,'','UP TO 15/06/2025 REFFERS BY HEAD MASTER',0,NULL,NULL),
('JANVI TOTAGERI',421,'Male','LKG','A','',0,'',NULL,0,NULL,NULL),
('MANOJ TOGUNSI',422,'Male','LKG','A','',0,'','UP TO JUN 10',0,NULL,NULL),
('KARATIK HERIKURUBAR',423,'Male','LKG','A','0',0,'','UP TO 15 JUN 2025',0,NULL,NULL),
('HUSENSAB NABI VALE',424,'Male','2','A','',0,'','UP TO JUN 10',0,NULL,NULL),
('BASAVARAJ BASREGIDA',425,'Male','7','A','',0,'',NULL,0,NULL,NULL),
('MUTTU HERIMANI',426,'Male','7','A','0',0,'',NULL,0,'',NULL),
('MALIKARJUN HADAPAD',427,'Male','3','A','',0,'',NULL,0,NULL,NULL),
('Prashant Hanamantappa Bilagi',428,'Male','LKG','A','0',8867165377,'','UP TO 15/06/2025 REFFERS TO HEAD MASTER .S.H.BILAGI',0,'',NULL),
('Shrirakasha Prakash Yankannavar',429,'Male','LKG','A','',9902366809,'','up to 15 jun 2025',0,NULL,NULL),
('Savitri Ningangouda Patil',430,'Male','5','A','',9739531077,'','up to 15 jun 2025 ',0,NULL,NULL),
('AYISH A DUGI',431,'Male','UKG','A','',9741350853,'','UP TO 15 JUN 2025',0,NULL,NULL),
('Sravani Huchesh Kadalimatti',432,'Male','LKG','A','',9036911370,'','up to 15 jun 2025',0,NULL,NULL),
('Krutika Ningappa Kollolli',433,'Male','LKG','A','',9663683416,'','up to 15 jun 2025',0,NULL,NULL),
('SADHIK BANDENAVAZ PANJABI',434,'Male','6','A','',9731838289,'','UP 15 JUN 2025',0,NULL,NULL),
('JAYASHREE IRANNA BASARAKOD',435,'Male','6','A','',9902640825,'','UP TO JUN 15',0,NULL,NULL),
('SRUSHTI MANTAGOUDA PATIL ',436,'Male','UKG','A','0',9945829328,'','UP TO JUN 15',0,'',NULL),
('SHRISHAILAGOUDA MANTAGOUDA PATIL',437,'Male','LKG','A','',9945829328,'','UP TO JUN 15',0,NULL,NULL),
('SHREYAS',438,'Male','LKG','A','',9880610464,'','UP TO JUN 15',0,NULL,NULL),
('KARAN VALIKAR',439,'Male','6','A','0',7259962819,'','UP TO 15 JUN 2025',0,NULL,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,
`year` varchar(20) DEFAULT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=553 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,295,47,53,4500,4500,0,1500,'',NULL),
(2,321,47,53,6000,0,6000,0,'',NULL),
(3,245,47,53,6000,0,6000,0,'',NULL),
(4,388,47,53,6000,2000,4000,0,'',NULL),
(5,280,47,53,6000,0,6000,0,'',NULL),
(6,397,47,53,6000,0,6000,0,'',NULL),
(7,277,47,53,5500,5500,0,500,'',NULL),
(8,283,47,53,6000,0,6000,0,'',NULL),
(9,345,47,53,6000,0,6000,0,'',NULL),
(10,386,47,53,6000,0,6000,0,'',NULL),
(11,294,47,53,6000,0,6000,0,'',NULL),
(291,22,54,60,5000,0,5000,0,'',NULL),
(13,356,47,53,5500,5500,0,500,'',NULL),
(14,285,47,53,6000,2500,3500,0,'',NULL),
(16,289,47,53,6000,2000,4000,0,'',NULL),
(17,369,47,53,6000,0,6000,0,'',NULL),
(19,298,47,53,5500,5500,0,500,'',NULL),
(20,349,47,53,5500,5500,0,500,'',NULL),
(21,334,47,53,6000,0,6000,0,'',NULL),
(22,341,45,51,6000,0,6000,0,'',NULL),
(23,406,45,51,6000,0,6000,0,'',NULL),
(24,408,45,51,6000,0,6000,0,'',NULL),
(25,378,45,51,4500,4500,0,1500,'',NULL),
(26,390,45,51,4500,4500,0,1500,'',NULL),
(27,332,45,51,4500,4500,0,1500,'',NULL),
(28,403,45,51,4500,4500,0,1500,'',NULL),
(29,401,45,51,6000,0,6000,0,'',NULL),
(30,418,45,51,6000,0,6000,0,'',NULL),
(31,391,45,51,4500,4500,0,1500,'',NULL),
(32,377,45,51,4500,4500,0,1500,'',NULL),
(33,398,45,51,6000,0,6000,0,'',NULL),
(34,362,45,51,6000,0,6000,0,'',NULL),
(35,400,45,51,4500,4500,0,1500,'',NULL),
(36,338,45,51,4500,4500,0,1500,'',NULL),
(37,350,45,51,4500,4500,0,1500,'',NULL),
(38,363,45,51,4000,4000,0,2000,'',NULL),
(39,392,45,51,4500,4500,0,1500,'',NULL),
(40,351,45,51,6000,0,6000,0,'',NULL),
(41,387,45,51,4000,4000,0,2000,'',NULL),
(42,414,45,51,6000,0,6000,0,'',NULL),
(43,346,45,51,6000,4000,2000,0,'',NULL),
(499,290,46,52,4500,4500,0,1500,'',NULL),
(45,291,45,51,4500,4500,0,1500,'',NULL),
(46,343,45,51,6000,0,6000,0,'',NULL),
(47,376,45,51,4500,4500,0,1500,'',NULL),
(48,395,45,51,6000,3500,2500,0,'',NULL),
(49,339,45,51,4500,4500,0,1500,'',NULL),
(50,299,45,51,6000,0,6000,0,'',NULL),
(51,287,45,51,4500,4500,0,1500,'',NULL),
(52,315,45,51,6000,0,6000,0,'',NULL),
(53,336,45,51,6000,0,6000,0,'',NULL),
(285,223,48,54,3500,0,3500,0,'',NULL),
(286,327,48,54,3500,0,3500,0,'',NULL),
(54,236,47,53,6000,0,6000,0,'',NULL),
(55,232,47,53,5500,5500,0,500,'',NULL),
(56,217,47,53,6000,0,6000,0,'',NULL),
(289,445,45,51,6000,2000,4000,0,'',NULL),
(59,240,47,53,6000,0,6000,0,'',NULL),
(60,310,47,53,6000,0,6000,0,'',NULL),
(61,292,47,53,6000,0,6000,0,'',NULL),
(288,444,54,60,5000,2000,3000,0,'',NULL),
(64,385,47,53,6000,0,6000,0,'',NULL),
(66,373,47,53,6000,0,6000,0,'',NULL),
(287,444,44,50,6500,2500,4000,0,'',NULL),
(68,302,47,53,5500,5500,0,500,'',NULL),
(69,241,47,53,5500,5500,0,500,'',NULL),
(70,223,47,53,6000,6000,0,0,'',NULL),
(71,318,47,53,6000,2000,4000,0,'',NULL),
(72,327,47,53,6000,0,6000,0,'',NULL),
(73,226,47,53,6000,0,6000,0,'',NULL),
(290,445,51,57,6000,2000,4000,0,'',NULL),
(75,243,47,53,5500,5500,0,500,'',NULL),
(76,335,47,53,6000,0,6000,0,'',NULL),
(77,300,47,53,5500,5500,0,500,'',NULL),
(78,404,47,53,5500,5500,0,500,'',NULL),
(80,237,47,53,5500,5500,0,500,'',NULL),
(81,248,47,53,6000,3500,2500,0,'',NULL),
(82,357,47,53,5500,5500,0,500,'',NULL),
(83,249,47,53,6000,0,6000,0,'',NULL),
(84,11,47,53,6000,0,6000,0,'',NULL),
(85,204,47,53,6000,0,6000,0,'',NULL),
(86,304,47,53,6000,0,6000,0,'',NULL),
(87,12,47,53,6000,0,6000,0,'',NULL),
(88,14,47,53,6000,2000,4000,0,'',NULL),
(89,199,47,53,5500,5500,0,500,'',NULL),
(90,384,47,53,6000,3000,3000,0,'',NULL),
(91,15,47,53,6000,0,6000,0,'',NULL),
(92,206,47,53,6000,0,6000,0,'',NULL),
(93,16,47,53,6000,0,6000,0,'',NULL),
(94,151,47,53,6000,0,6000,0,'',NULL),
(95,203,47,53,6000,2000,4000,0,'',NULL),
(96,17,47,53,6000,1000,5000,0,'',NULL),
(97,18,47,53,5500,5500,0,500,'',NULL),
(98,202,47,53,6000,0,6000,0,'',NULL),
(99,358,47,53,6000,0,6000,0,'',NULL),
(100,399,47,53,6000,0,6000,0,'',NULL),
(101,305,47,53,6000,6000,0,0,'',NULL),
(102,21,47,53,6000,3000,3000,0,'',NULL),
(103,22,47,53,6000,0,6000,0,'',NULL),
(104,23,47,53,6000,0,6000,0,'',NULL),
(105,198,47,53,6000,0,6000,0,'',NULL),
(106,195,47,53,6000,3000,3000,0,'',NULL),
(107,26,47,53,6000,0,6000,0,'',NULL),
(108,27,47,53,6000,0,6000,0,'',NULL),
(109,415,47,53,5500,5500,0,500,'',NULL),
(294,28,61,67,520,520,0,0,'',NULL),
(111,28,47,53,6000,4000,2000,0,'',NULL),
(112,193,47,53,6000,0,6000,0,'',NULL),
(113,29,47,53,5500,5500,0,500,'',NULL),
(114,192,47,53,6000,0,6000,0,'',NULL),
(115,30,47,53,6000,0,6000,0,'',NULL),
(116,31,47,53,6000,0,6000,0,'',NULL),
(295,446,46,52,6000,2000,4000,0,'',NULL),
(118,211,47,53,6000,0,6000,0,'',NULL),
(119,33,47,53,6000,0,6000,0,'',NULL),
(293,353,63,69,670,670,0,0,'',NULL),
(121,34,47,53,6000,3000,3000,0,'',NULL),
(122,35,47,53,6000,0,6000,0,'',NULL),
(123,370,47,53,6000,0,6000,0,'',NULL),
(124,382,47,53,6000,5500,500,0,'',NULL),
(278,245,48,54,3500,0,3500,0,'',NULL),
(126,210,47,53,6000,0,6000,0,'',NULL),
(127,365,47,53,6000,0,6000,0,'',NULL),
(128,38,47,53,6000,0,6000,0,'',NULL),
(129,312,47,53,6000,0,6000,0,'',NULL),
(130,196,47,53,5500,5500,0,500,'',NULL),
(131,41,47,53,6000,3000,3000,0,'',NULL),
(277,289,48,54,3500,2000,1500,0,'',NULL),
(133,44,47,53,6000,0,6000,0,'',NULL),
(134,417,47,53,6000,3000,3000,0,'',NULL),
(136,46,44,50,6500,5000,1500,0,'',NULL),
(137,47,44,50,6500,0,6500,0,'',NULL),
(138,48,44,50,6500,0,6500,0,'',NULL),
(139,49,44,50,6500,0,6500,0,'',NULL),
(140,50,44,50,6500,0,6500,0,'',NULL),
(141,51,44,50,6000,6000,0,500,'',NULL),
(142,416,44,50,6500,3500,3000,0,'',NULL),
(143,54,44,50,6500,3000,3500,0,'',NULL),
(144,55,44,50,6500,0,6500,0,'',NULL),
(145,379,44,50,6500,0,6500,0,'',NULL),
(146,56,44,50,6500,0,6500,0,'',NULL),
(147,361,44,50,6500,0,6500,0,'',NULL),
(148,58,44,50,6500,0,6500,0,'',NULL),
(149,209,44,50,6500,0,6500,0,'',NULL),
(150,207,44,50,6500,0,6500,0,'',NULL),
(151,60,44,50,6500,0,6500,0,'',NULL),
(152,59,44,50,6500,0,6500,0,'',NULL),
(153,63,44,50,6500,0,6500,0,'',NULL),
(154,64,44,50,6500,0,6500,0,'',NULL),
(155,66,44,50,6500,0,6500,0,'',NULL),
(156,67,44,50,6500,3000,3500,0,'',NULL),
(157,68,44,50,6500,0,6500,0,'',NULL),
(158,73,44,50,6500,0,6500,0,'',NULL),
(159,367,44,50,6500,0,6500,0,'',NULL),
(160,323,44,50,6500,0,6500,0,'',NULL),
(161,71,44,50,6500,2000,4500,0,'',NULL),
(162,72,44,50,6500,0,6500,0,'',NULL),
(163,74,44,50,6500,0,6500,0,'',NULL),
(164,75,44,50,6500,0,6500,0,'',NULL),
(165,76,44,50,6500,0,6500,0,'',NULL),
(166,77,44,50,6500,0,6500,0,'',NULL),
(167,78,44,50,6500,0,6500,0,'',NULL),
(168,79,44,50,6500,0,6500,0,'',NULL),
(169,80,44,50,6500,0,6500,0,'',NULL),
(170,402,44,50,6500,0,6500,0,'',NULL),
(171,340,44,50,6500,0,6500,0,'',NULL),
(172,316,44,50,6500,0,6500,0,'',NULL),
(173,172,44,50,6500,0,6500,0,'',NULL),
(174,81,44,50,6500,0,6500,0,'',NULL),
(175,82,44,50,6500,0,6500,0,'',NULL),
(176,158,44,50,6500,3500,3000,0,'',NULL),
(177,212,44,50,6500,6000,500,0,'',NULL),
(178,84,44,50,6500,0,6500,0,'',NULL),
(179,85,44,50,6500,0,6500,0,'',NULL),
(180,342,44,50,6000,6000,0,500,'',NULL),
(181,154,44,50,6000,6000,0,500,'',NULL),
(182,163,44,50,6500,0,6500,0,'',NULL),
(183,86,44,50,6500,0,6500,0,'',NULL),
(184,213,44,50,6500,0,6500,0,'',NULL),
(185,354,44,50,6000,6000,0,500,'',NULL),
(186,87,44,50,6500,3000,3500,0,'',NULL),
(187,355,44,50,6000,6000,0,500,'',NULL),
(188,160,44,50,6000,6000,0,500,'',NULL),
(189,409,44,50,6500,0,6500,0,'',NULL),
(190,88,44,50,6500,0,6500,0,'',NULL),
(191,381,44,50,6000,6000,0,500,'',NULL),
(192,89,44,50,6500,0,6500,0,'',NULL),
(193,353,44,50,6500,2000,4500,0,'',NULL),
(194,91,44,50,6500,0,6500,0,'',NULL),
(195,389,44,50,6000,6000,0,500,'',NULL),
(196,92,44,50,6500,0,6500,0,'',NULL),
(197,171,44,50,6000,6000,0,500,'',NULL),
(198,95,44,50,6500,0,6500,0,'',NULL),
(199,314,44,50,6500,0,6500,0,'',NULL),
(200,313,44,50,6500,3000,3500,0,'',NULL),
(201,320,44,50,6500,0,6500,0,'',NULL),
(202,97,44,50,6500,0,6500,0,'',NULL),
(203,164,44,50,6500,0,6500,0,'',NULL),
(204,98,44,50,6500,0,6500,0,'',NULL),
(205,99,44,50,6500,0,6500,0,'',NULL),
(206,371,44,50,6500,0,6500,0,'',NULL),
(207,348,44,50,6500,0,6500,0,'',NULL),
(208,300,48,54,3000,3000,0,500,'',NULL),
(209,298,48,54,3000,3000,0,500,'',NULL),
(210,51,54,60,5000,0,5000,0,'',NULL),
(211,199,54,60,4500,4500,0,500,'',NULL),
(212,419,46,52,4500,4500,0,1500,'',NULL),
(213,420,44,50,6000,6000,0,500,'',NULL),
(214,421,45,51,6000,3000,3000,0,'',NULL),
(215,422,45,51,4500,4500,0,1500,'',NULL),
(216,395,54,60,4500,4500,0,500,'',NULL),
(217,423,45,51,4500,4500,0,1500,'',NULL),
(218,423,48,54,3000,3000,0,500,'',NULL),
(219,424,47,53,5500,5500,0,500,'',NULL),
(220,425,44,50,6500,3000,3500,0,'',NULL),
(221,426,44,50,6500,3000,3500,0,'',NULL),
(222,427,47,53,6000,3000,3000,0,'',NULL),
(223,376,53,59,3500,3500,0,500,'',NULL),
(224,428,45,51,4000,4000,0,2000,'',NULL),
(225,429,45,51,4500,4500,0,1500,'',NULL),
(226,429,53,59,4000,0,4000,0,'',NULL),
(227,430,47,53,5000,5000,0,1000,'',NULL),
(228,430,84,117,4000,4000,0,500,'',NULL),
(229,354,84,117,4000,4000,0,500,'',NULL),
(230,355,84,117,4000,4000,0,500,'',NULL),
(231,431,45,51,4500,4500,0,1500,'',NULL),
(232,431,48,54,3500,0,3500,0,'',NULL),
(233,432,45,51,4500,4500,0,1500,'',NULL),
(234,432,48,54,3000,3000,0,500,'',NULL),
(235,433,45,51,4500,4500,0,1500,'',NULL),
(236,433,54,60,4500,4500,0,500,'',NULL),
(237,350,54,60,4500,4500,0,500,'',NULL),
(238,237,54,60,4500,4500,0,500,'',NULL),
(239,434,44,50,6000,6000,0,500,'',NULL),
(240,435,44,50,6000,6000,0,500,'',NULL),
(241,437,45,51,4500,4500,0,1500,'',NULL),
(242,436,45,51,4500,4500,0,1500,'',NULL),
(243,438,45,51,4500,4500,0,1500,'',NULL),
(244,378,54,60,4500,4500,0,500,'',NULL),
(245,171,52,58,3000,3000,0,500,'',NULL),
(246,439,44,50,6000,6000,0,500,'',NULL),
(248,217,54,60,5000,0,5000,0,'',NULL),
(249,248,54,60,5000,4500,500,0,'',NULL),
(250,158,54,60,5000,4500,500,0,'',NULL),
(251,382,54,60,5000,4500,500,0,'',NULL),
(252,440,47,53,6000,5500,500,0,'',NULL),
(253,440,54,60,5000,4500,500,0,'',NULL),
(254,441,46,52,6000,3000,3000,0,'',NULL),
(255,441,54,60,5000,2500,2500,0,'',NULL),
(256,203,51,57,6000,2000,4000,0,'',NULL),
(257,385,53,59,4000,0,4000,0,'',NULL),
(258,427,54,60,5000,0,5000,0,'',NULL),
(259,384,54,60,5000,0,5000,0,'',NULL),
(260,305,51,57,6000,0,6000,0,'',NULL),
(261,23,54,60,5000,0,5000,0,'',NULL),
(262,27,54,60,5000,0,5000,0,'',NULL),
(263,312,54,60,5000,0,5000,0,'',NULL),
(264,365,54,60,5000,0,5000,0,'',NULL),
(265,196,51,57,6000,0,6000,0,'',NULL),
(266,46,54,60,5000,0,5000,0,'',NULL),
(267,379,54,60,5000,0,5000,0,'',NULL),
(268,361,52,58,3500,0,3500,0,'',NULL),
(269,67,51,57,6000,0,6000,0,'',NULL),
(270,416,54,60,5000,2500,2500,0,'',NULL),
(271,79,54,60,5000,0,5000,0,'',NULL),
(273,316,54,60,5000,0,5000,0,'',NULL),
(274,172,54,60,5000,0,5000,0,'',NULL),
(275,442,53,59,4000,2000,2000,0,'',NULL),
(276,442,45,51,6000,2000,4000,0,'',NULL),
(279,283,48,54,3500,0,3500,0,'',NULL),
(280,334,50,56,4000,0,4000,0,'',NULL),
(281,277,53,59,4000,0,4000,0,'',NULL),
(282,369,54,60,5000,0,5000,0,'',NULL),
(283,386,54,60,5000,0,5000,0,'',NULL),
(284,397,53,59,4000,0,4000,0,'',NULL),
(292,417,54,60,5000,0,5000,0,'',NULL),
(296,447,45,51,6000,2000,4000,0,'',NULL),
(297,448,44,50,6500,2000,4500,0,'',NULL),
(298,226,59,65,540,540,0,0,'',NULL),
(299,342,63,69,670,670,0,0,'',NULL),
(300,33,61,67,520,520,0,0,'',NULL),
(301,236,59,65,540,540,0,0,'',NULL),
(302,449,44,50,6500,3000,3500,0,'',NULL),
(303,300,59,65,540,540,0,0,'',NULL),
(304,298,58,64,520,520,0,0,'',NULL),
(305,302,59,65,540,540,0,0,'',NULL),
(306,404,59,65,540,540,0,0,'',NULL),
(307,450,47,53,6000,0,6000,0,'',NULL),
(308,450,61,67,520,520,0,0,'',NULL),
(309,295,57,63,500,500,0,0,'',NULL),
(310,390,57,63,500,500,0,0,'',NULL),
(311,291,57,63,500,500,0,0,'',NULL),
(312,395,57,63,500,500,0,0,'',NULL),
(313,339,57,63,500,500,0,0,'',NULL),
(314,400,57,63,500,500,0,0,'',NULL),
(315,287,57,63,500,500,0,0,'',NULL),
(316,446,57,63,500,0,500,0,'',NULL),
(317,350,57,63,500,500,0,0,'',NULL),
(318,419,57,63,500,500,0,0,'',NULL),
(319,441,57,63,500,500,0,0,'',NULL),
(320,321,58,64,520,520,0,0,'',NULL),
(321,245,58,64,520,520,0,0,'',NULL),
(322,388,58,64,520,520,0,0,'',NULL),
(323,280,58,64,520,520,0,0,'',NULL),
(324,424,58,64,520,520,0,0,'',NULL),
(325,397,58,64,520,520,0,0,'',NULL),
(326,277,58,64,520,520,0,0,'',NULL),
(327,283,58,64,520,520,0,0,'',NULL),
(328,345,58,64,520,520,0,0,'',NULL),
(329,386,58,64,520,520,0,0,'',NULL),
(330,294,58,64,520,520,0,0,'',NULL),
(331,293,58,64,520,0,520,0,'',NULL),
(332,443,58,64,520,520,0,0,'',NULL),
(333,356,58,64,520,520,0,0,'',NULL),
(334,285,58,64,520,520,0,0,'',NULL),
(335,375,58,64,520,0,520,0,'',NULL),
(336,289,58,64,520,520,0,0,'',NULL),
(337,369,58,64,520,520,0,0,'',NULL),
(338,352,58,64,520,0,520,0,'',NULL),
(339,349,58,64,520,520,0,0,'',NULL),
(340,334,58,64,520,0,520,0,'',NULL),
(341,232,59,65,540,540,0,0,'',NULL),
(342,217,59,65,540,540,0,0,'',NULL),
(343,222,59,65,540,0,540,0,'',NULL),
(344,242,59,65,540,0,540,0,'',NULL),
(345,240,59,65,540,540,0,0,'',NULL),
(346,310,59,65,540,0,540,0,'',NULL),
(347,292,59,65,540,540,0,0,'',NULL),
(348,227,59,65,540,0,540,0,'',NULL),
(349,247,59,65,540,0,540,0,'',NULL),
(350,385,59,65,540,540,0,0,'',NULL),
(351,440,59,65,540,540,0,0,'',NULL),
(352,231,59,65,540,0,540,0,'',NULL),
(353,373,59,65,540,540,0,0,'',NULL),
(354,230,59,65,540,0,540,0,'',NULL),
(355,427,59,65,540,540,0,0,'',NULL),
(356,241,59,65,540,540,0,0,'',NULL),
(357,223,59,65,540,540,0,0,'',NULL),
(358,318,59,65,540,540,0,0,'',NULL),
(359,327,59,65,540,540,0,0,'',NULL),
(360,347,59,65,540,0,540,0,'',NULL),
(361,243,59,65,540,540,0,0,'',NULL),
(362,335,59,65,540,0,540,0,'',NULL),
(363,244,59,65,540,0,540,0,'',NULL),
(364,237,59,65,540,540,0,0,'',NULL),
(365,248,60,66,550,550,0,0,'',NULL),
(366,357,60,66,550,550,0,0,'',NULL),
(367,249,60,66,550,0,550,0,'',NULL),
(368,11,60,66,550,0,550,0,'',NULL),
(369,204,60,66,550,550,0,0,'',NULL),
(370,304,60,66,550,550,0,0,'',NULL),
(371,12,60,66,550,0,550,0,'',NULL),
(372,14,60,66,550,550,0,0,'',NULL),
(373,199,60,66,550,550,0,0,'',NULL),
(374,384,60,66,550,550,0,0,'',NULL),
(375,15,60,66,550,0,550,0,'',NULL),
(376,206,60,66,550,0,550,0,'',NULL),
(377,16,60,66,550,550,0,0,'',NULL),
(378,151,60,66,550,0,550,0,'',NULL),
(379,203,60,66,550,550,0,0,'',NULL),
(380,17,60,66,550,550,0,0,'',NULL),
(381,18,60,66,550,550,0,0,'',NULL),
(382,202,60,66,550,0,550,0,'',NULL),
(383,358,60,66,550,550,0,0,'',NULL),
(384,399,60,66,550,0,550,0,'',NULL),
(385,305,60,66,550,550,0,0,'',NULL),
(386,21,60,66,550,550,0,0,'',NULL),
(387,22,61,67,520,0,520,0,'',NULL),
(388,23,61,67,520,0,520,0,'',NULL),
(389,198,61,67,520,520,0,0,'',NULL),
(390,195,61,67,520,520,0,0,'',NULL),
(391,26,61,67,520,520,0,0,'',NULL),
(392,27,61,67,520,520,0,0,'',NULL),
(393,415,61,67,520,520,0,0,'',NULL),
(394,190,61,67,520,0,520,0,'',NULL),
(395,193,61,67,520,520,0,0,'',NULL),
(396,29,61,67,520,520,0,0,'',NULL),
(397,192,61,67,520,520,0,0,'',NULL),
(398,30,61,67,520,520,0,0,'',NULL),
(399,31,61,67,520,520,0,0,'',NULL),
(400,189,61,67,520,0,520,0,'',NULL),
(401,211,61,67,520,0,520,0,'',NULL),
(402,194,61,67,520,0,520,0,'',NULL),
(403,34,61,67,520,520,0,0,'',NULL),
(404,35,61,67,520,520,0,0,'',NULL),
(405,370,61,67,520,520,0,0,'',NULL),
(406,382,61,67,520,520,0,0,'',NULL),
(407,430,61,67,520,520,0,0,'',NULL),
(408,210,61,67,520,520,0,0,'',NULL),
(409,365,61,67,520,520,0,0,'',NULL),
(410,38,61,67,520,520,0,0,'',NULL),
(411,312,61,67,520,520,0,0,'',NULL),
(412,196,61,67,520,520,0,0,'',NULL),
(413,41,61,67,520,520,0,0,'',NULL),
(414,44,61,67,520,0,520,0,'',NULL),
(415,417,61,67,520,520,0,0,'',NULL),
(416,191,61,67,520,0,520,0,'',NULL),
(417,46,62,68,670,670,0,0,'',NULL),
(418,444,62,68,670,670,0,0,'',NULL),
(419,47,62,68,670,0,670,0,'',NULL),
(420,48,62,68,670,0,670,0,'',NULL),
(421,49,62,68,670,0,670,0,'',NULL),
(422,50,62,68,670,0,670,0,'',NULL),
(423,51,62,68,670,670,0,0,'',NULL),
(424,416,62,68,670,670,0,0,'',NULL),
(425,435,62,68,670,670,0,0,'',NULL),
(426,439,62,68,670,670,0,0,'',NULL),
(427,54,62,68,670,670,0,0,'',NULL),
(428,55,62,68,670,670,0,0,'',NULL),
(429,379,62,68,670,670,0,0,'',NULL),
(430,56,62,68,670,0,670,0,'',NULL),
(431,361,62,68,670,670,0,0,'',NULL),
(432,58,62,68,670,0,670,0,'',NULL),
(433,209,62,68,670,670,0,0,'',NULL),
(434,207,62,68,670,0,670,0,'',NULL),
(435,60,62,68,670,0,670,0,'',NULL),
(436,59,62,68,670,670,0,0,'',NULL),
(437,434,62,68,670,670,0,0,'',NULL),
(438,420,62,68,670,670,0,0,'',NULL),
(439,63,62,68,670,0,670,0,'',NULL),
(440,64,62,68,670,670,0,0,'',NULL),
(441,66,62,68,670,0,670,0,'',NULL),
(442,67,62,68,670,670,0,0,'',NULL),
(443,68,62,68,670,0,670,0,'',NULL),
(444,73,62,68,670,0,670,0,'',NULL),
(445,367,62,68,670,670,0,0,'',NULL),
(446,448,62,68,670,670,0,0,'',NULL),
(447,323,62,68,670,670,0,0,'',NULL),
(448,71,62,68,670,670,0,0,'',NULL),
(449,72,62,68,670,670,0,0,'',NULL),
(450,449,62,68,670,670,0,0,'',NULL),
(451,74,62,68,670,670,0,0,'',NULL),
(452,75,62,68,670,0,670,0,'',NULL),
(453,76,62,68,670,0,670,0,'',NULL),
(454,77,62,68,670,0,670,0,'',NULL),
(455,78,62,68,670,0,670,0,'',NULL),
(456,79,63,69,670,670,0,0,'',NULL),
(457,80,63,69,670,670,0,0,'',NULL),
(458,402,63,69,670,0,670,0,'',NULL),
(459,340,63,69,670,0,670,0,'',NULL),
(460,316,63,69,670,0,670,0,'',NULL),
(461,172,63,69,670,0,670,0,'',NULL),
(462,81,63,69,670,0,670,0,'',NULL),
(463,82,63,69,670,0,670,0,'',NULL),
(464,158,63,69,670,670,0,0,'',NULL),
(465,212,63,69,670,670,0,0,'',NULL),
(466,425,63,69,670,0,670,0,'',NULL),
(467,84,63,69,670,670,0,0,'',NULL),
(468,85,63,69,670,0,670,0,'',NULL),
(469,154,63,69,670,670,0,0,'',NULL),
(470,163,63,69,670,0,670,0,'',NULL),
(471,86,63,69,670,670,0,0,'',NULL),
(472,213,63,69,670,0,670,0,'',NULL),
(473,354,63,69,670,670,0,0,'',NULL),
(474,87,63,69,670,670,0,0,'',NULL),
(475,355,63,69,670,670,0,0,'',NULL),
(476,160,63,69,670,670,0,0,'',NULL),
(477,409,63,69,670,0,670,0,'',NULL),
(478,88,63,69,670,0,670,0,'',NULL),
(479,381,63,69,670,670,0,0,'',NULL),
(480,426,63,69,670,0,670,0,'',NULL),
(481,89,63,69,670,670,0,0,'',NULL),
(482,91,63,69,670,0,670,0,'',NULL),
(483,389,63,69,670,0,670,0,'',NULL),
(484,92,63,69,670,0,670,0,'',NULL),
(485,171,63,69,670,670,0,0,'',NULL),
(486,95,63,69,670,0,670,0,'',NULL),
(487,314,63,69,670,0,670,0,'',NULL),
(488,313,63,69,670,670,0,0,'',NULL),
(489,320,63,69,670,0,670,0,'',NULL),
(490,97,63,69,670,0,670,0,'',NULL),
(491,164,63,69,670,0,670,0,'',NULL),
(492,98,63,69,670,0,670,0,'',NULL),
(493,99,63,69,670,0,670,0,'',NULL),
(494,371,63,69,670,670,0,0,'',NULL),
(495,348,63,69,670,0,670,0,'',NULL),
(496,451,44,50,6500,3000,3500,0,'',NULL),
(497,451,54,60,5000,2500,2500,0,'',NULL),
(498,451,62,68,670,670,0,0,'',NULL),
(500,290,57,63,500,500,0,0,'',NULL),
(501,452,61,67,520,520,0,0,'',NULL),
(502,376,57,63,500,500,0,0,'',NULL),
(503,453,45,51,6000,4000,2000,0,'',NULL),
(504,454,45,51,6000,2500,3500,0,'',NULL),
(505,299,57,63,500,500,0,0,'',NULL),
(506,299,48,54,3500,0,3500,0,'',NULL),
(507,406,56,62,580,0,580,0,'',NULL),
(508,408,56,62,580,0,580,0,'',NULL),
(509,378,56,62,580,580,0,0,'',NULL),
(510,445,56,62,580,0,580,0,'',NULL),
(511,431,56,62,580,580,0,0,'',NULL),
(512,403,56,62,580,0,580,0,'',NULL),
(513,343,56,62,580,0,580,0,'',NULL),
(514,401,56,62,580,580,0,0,'',NULL),
(515,391,56,62,580,580,0,0,'',NULL),
(516,377,56,62,580,580,0,0,'',NULL),
(517,362,56,62,580,580,0,0,'',NULL),
(518,338,56,62,580,580,0,0,'',NULL),
(519,363,56,62,580,580,0,0,'',NULL),
(520,315,56,62,580,0,580,0,'',NULL),
(521,392,56,62,580,580,0,0,'',NULL),
(523,336,56,62,580,0,580,0,'',NULL),
(524,453,56,62,580,580,0,0,'',NULL),
(525,346,56,62,580,580,0,0,'',NULL),
(526,332,56,62,580,580,0,0,'',NULL),
(527,398,56,62,580,0,580,0,'',NULL),
(528,436,56,62,580,580,0,0,'',NULL),
(529,387,56,62,580,0,580,0,'',NULL),
(530,341,55,61,550,0,550,0,'',NULL),
(531,421,55,61,550,550,0,0,'',NULL),
(532,423,55,61,550,550,0,0,'',NULL),
(533,418,55,61,550,0,550,0,'',NULL),
(534,447,55,61,550,0,550,0,'',NULL),
(535,433,55,61,550,550,0,0,'',NULL),
(536,422,55,61,550,550,0,0,'',NULL),
(537,428,55,61,550,550,0,0,'',NULL),
(538,438,55,61,550,550,0,0,'',NULL),
(539,429,55,61,550,550,0,0,'',NULL),
(540,437,55,61,550,550,0,0,'',NULL),
(541,351,55,61,550,0,550,0,'',NULL),
(542,432,55,61,550,550,0,0,'',NULL),
(543,454,55,61,550,0,550,0,'',NULL),
(544,414,55,61,550,0,550,0,'',NULL),
(545,455,45,51,6000,0,6000,0,'',NULL),
(546,455,54,60,5000,0,5000,0,'',NULL),
(547,455,56,62,580,580,0,0,'',NULL),
(548,456,45,51,6000,1000,5000,0,'',NULL),
(549,456,55,61,550,0,550,0,'',NULL),
(550,457,45,51,6000,0,6000,0,'',NULL),
(551,457,56,62,580,580,0,0,'',NULL),
(552,442,55,61,550,550,0,0,'',NULL);
/*!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=118 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
('CHIKKAMAGI',1,'5000','N'),
('MUGUNUR MARDADI BUDIHAL BASAVNAL',2,'4500','N'),
('BASARIKATTI',3,'3000','N'),
('KADIVAL KALLAPUR',4,'3000','N'),
('KAMATAGI',5,'2500','N'),
('RAMTHAL',6,'3000','N'),
('SCHOOL FEES 2',7,'6000','N'),
('SCHOOL FEES ',8,'6000','N'),
('BOOK 1',9,'450','N'),
('BOOKS 3',10,'480','D'),
('BOOK 4',11,'520','N'),
('BOOK -5',12,'350','N'),
('BOOK 6',13,'500','N'),
('Books RTE 4',14,'200','N'),
('books RTE 5',15,'70','N'),
('BOOK RTE 5',16,'70','N'),
('BOOK -7',17,'530','N'),
('Benakatti',18,'2500','N'),
('BENALA',19,'2500','N'),
('GULEDAGUDDA',20,'5000','N'),
('HALLUR',21,'2500','N'),
('HALADUR',22,'2500','N'),
('SCHOOL FEES AB 1',23,'6000','N'),
('SCHOOL FEES 2',24,'6000','N'),
('LKG BOOK ',25,'480','N'),
('Ukg Book',26,'580','N'),
('LKG BOOK',40,'480','N'),
('1 ST STANDERD BOOK',27,'470','N'),
('2ND STANDERD BOOK',28,'480','N'),
('3RD STANDERD BOOK',29,'480','N'),
('4TH STANDERD BOOK',30,'490','N'),
('5TH STANDERD BOOK',31,'500','N'),
('6 TH STANDERD BOOK',32,'510','N'),
('7TH STANDERD BOOK',33,'520','N'),
('SCHOOL FEES 2',34,'6000','N'),
('BOOK2',35,'450','N'),
('BOOK FEES 2',36,'450','N'),
('BENALA',37,'2500','N'),
('BENALA',38,'2500','N'),
('BENALA',39,'2500','N'),
('RTE6',41,'0','N'),
('5 TH TO 7TH STANDARD REGULAR UNIFORM BOYS ',42,'360','N'),
('LKG TO 4TH STANDARD REGULAR UNIFORM GIRLS ',43,'380','N'),
('LKG TO 4TH STANDARD TRACK SUIT BOYS AND GIRLS',44,'400','N'),
('BELT',45,'35','N'),
('ID CARD',46,'65','N'),
('LKG TO 4TH STANDARD REGULAR UNIFORM BOYS ',47,'350','N'),
('5 TH TO 7TH STANDARD REGULAR UNIFORM GIRLS',48,'420','N'),
('5 TH TO 7TH STANDARD TRACK SUIT BOYS AND GIRLS ',49,'420','N'),
('School Fees',50,'6500','N'),
('School Fee LKG UKG',51,'6000','N'),
('school fees 1st ',52,'6000','N'),
('School Fees',53,'6000','N'),
('VAN FEES',54,'3500','N'),
('VAN FEES',55,'3500','N'),
('VAN FEES',56,'4000','N'),
('VAN FEES',57,'6000','N'),
('VAN FEES',58,'3500','N'),
('VAN FEES',59,'4000','N'),
('VAN FEES ',60,'5000','N'),
('BOOK FEES',61,'550','N'),
('Book Fees ',62,'580','N'),
('books fees',63,'500','N'),
('books fees ',64,'520','N'),
('books fees',65,'540','N'),
('books fees',66,'550','N'),
('books fees',67,'520','N'),
('books fees',68,'670','N'),
('books fees',69,'670','N'),
('RTE Student',70,'70','N'),
('LKG TO 3rd Standard Boys and Girls Track Suit ',71,'370','N'),
('TRACK SUITE (YELLOW)',72,'370','N'),
('TRACK SUITE (YELLOW)',73,'400','N'),
('TRACK SUITE (YELLOW)',74,'440','N'),
('REGULAR UNIFORM',75,'420','N'),
('REGULAR UNIFORM',76,'470','N'),
('REGULAR UNIFORM',77,'460','N'),
('REGULAR UNIFORM',78,'520','N'),
('ID CARD',79,'60','N'),
('BELT',80,'30','N'),
('SURALIKAL--',81,'4000','N'),
('xyz',82,'4500','N'),
('kamatagi',83,'2500','N'),
('regular',84,'450','D'),
('chikkamagi',85,'5000','D'),
('MARADI BUDIHAL',86,'5000','N'),
('uniform',87,'550','N'),
('BELT',88,'60','N'),
('uniform ',89,'1000','N'),
('BELT',90,'60','N'),
('ID CARD',91,'60','N'),
('RAMTA',92,'3500','N'),
('REGULAR UNIFORM',93,'2000','N'),
('BOOK FEES',94,'600','N'),
('ID CARD',95,'70','N'),
('CHIKKAMAGI',96,'7000','N'),
('REGULAR UNIFORM',97,'2000','N'),
('BOOK FEES',98,'500','N'),
('BELT',99,'80','N'),
('ID CARD',100,'70','N'),
('CHIKKAMAGI',101,'6700','N'),
('bus fees',102,'5000','N'),
('books fees',103,'100','N'),
('books fees',104,'50','N'),
('Belt',105,'25','N'),
('uniform',106,'1000','N'),
('VAN FEES',107,'3000','N'),
('bavuta',108,'10','N'),
('Hearing fee',109,'10','N'),
('Painting ',110,'10','N'),
('MEDICAL',111,'05','N'),
('CLEANLINESS',112,'15','N'),
('CAREER EDUCATION FEE',113,'10','N'),
('SPORTS FEE',114,'25','N'),
('VAACHANALAY FEE',115,'20','N'),
('Laboratory fee',116,'20','N'),
('VAN FEES',117,'4500','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 AUTO_INCREMENT,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`subcategoryid`)
) 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=19 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,94,'pay_fees',1),
(18,94,'new_student',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=95 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
(76,'2306adminFees','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'2306Adminstudent','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'2306adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732'),
(93,'123','c87c5a00de39b8fa3d9bdce1a89890c67480e3c47fe2dcbdcf4232d06809b3a2','b63dee4518ccd9b',NULL,'Teacher','123@rfwerwA'),
(94,'test1','b3410bef9fbd70fcb9c82b5f00970498bdef85a2538c1360485ef50314468d95','4fb2c5091b4c302',NULL,'Fees_Management','123456@Test');
/*!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','QN2yBnEUMTmrT45NRvlYG4g5Sh9gVUSFzjKeb20HcGFJLEm04H3uyBrNZlDO','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','W3EFnZsmRLwuN4t4kZztQ820d7JS8NPJo3vzqQW4rgi1gUTNyIHUcJFdStqA','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=72 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
('2025-06-10',NULL,1,1,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','63000','63000','Fees Collected'),
('2025-06-10',NULL,2,2,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2025-06-10',NULL,3,3,'Recipt','school fees 1st ','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2025-06-10',NULL,4,4,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2025-06-11',NULL,5,5,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','30000','30000','Fees Collected'),
('2025-06-11',NULL,6,6,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2025-06-11',NULL,7,7,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','22000','22000','Fees Collected'),
('2025-06-12',NULL,8,8,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2025-06-13',NULL,9,9,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','39500','39500','Fees Collected'),
('2025-06-13',NULL,10,10,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','29500','29500','Fees Collected'),
('2025-06-13',NULL,11,11,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected'),
('2025-06-14',NULL,12,12,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','31000','31000','Fees Collected'),
('2025-06-14',NULL,13,13,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2025-06-14',NULL,14,14,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2025-06-16',NULL,15,15,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','70500','70500','Fees Collected'),
('2025-06-16',NULL,16,16,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','38500','38500','Fees Collected'),
('2025-06-16',NULL,17,17,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','16500','16500','Fees Collected'),
('2025-06-17',NULL,18,18,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2025-06-17',NULL,19,19,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-18',NULL,20,20,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-06-19',NULL,21,21,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','16500','16500','Fees Collected'),
('2025-06-19',NULL,22,22,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','13500','13500','Fees Collected'),
('2025-06-20',NULL,23,23,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2025-06-20',NULL,24,24,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2025-06-20',NULL,25,25,'Recipt','school fees 1st ','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2025-06-23',NULL,26,26,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-23',NULL,27,27,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-24',NULL,28,28,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-24',NULL,29,29,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-24',NULL,30,30,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2025-06-27',NULL,31,31,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','11500','11500','Fees Collected'),
('2025-06-27',NULL,32,32,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2025-06-27',NULL,33,33,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-28',NULL,34,34,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2025-06-28',NULL,35,35,'Recipt','books fees','Cash','Income/Revenue','Current Assets','1190','1190','Fees Collected'),
('2025-06-28',NULL,36,36,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-28',NULL,37,37,'Recipt','school fees 1st ','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-30',NULL,38,38,'Recipt','books fees','Cash','Income/Revenue','Current Assets','18210','18210','Fees Collected'),
('2025-06-30',NULL,39,39,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2025-06-30',NULL,40,40,'Recipt','VAN FEES ','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2025-06-30',NULL,41,41,'Recipt','school fees 1st ','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2025-07-01',NULL,42,42,'Recipt','books fees','Cash','Income/Revenue','Current Assets','16860','16860','Fees Collected'),
('2025-07-01',NULL,43,43,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2025-07-01',NULL,44,44,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-07-02',NULL,45,45,'Recipt','books fees','Cash','Income/Revenue','Current Assets','10300','10300','Fees Collected'),
('2025-07-02',NULL,46,46,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','9500','9500','Fees Collected'),
('2025-07-02',NULL,47,47,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2025-07-03',NULL,48,48,'Recipt','books fees ','Cash','Income/Revenue','Current Assets','7040','7040','Fees Collected'),
('2025-07-03',NULL,49,49,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2025-07-03',NULL,50,50,'Recipt','VAN FEES','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-07-04',NULL,51,51,'Recipt','books fees','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2025-07-04',NULL,52,52,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-07-05',NULL,53,53,'Recipt','books fees','Cash','Income/Revenue','Current Assets','3200','3200','Fees Collected'),
('2025-07-07',NULL,54,54,'Recipt','books fees ','Cash','Income/Revenue','Current Assets','4050','4050','Fees Collected'),
('2025-07-07',NULL,55,55,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2025-07-07',NULL,56,56,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','580','580','Fees Collected'),
('2025-07-08',NULL,57,57,'Recipt','books fees','Cash','Income/Revenue','Current Assets','2410','2410','Fees Collected'),
('2025-07-09',NULL,58,58,'Recipt','books fees','Cash','Income/Revenue','Current Assets','2620','2620','Fees Collected'),
('2025-07-09',NULL,59,59,'Recipt','School Fees','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2025-07-09',NULL,60,60,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','1710','1710','Fees Collected'),
('2025-07-10',NULL,61,61,'Recipt','books fees','Cash','Income/Revenue','Current Assets','1040','1040','Fees Collected'),
('2025-07-10',NULL,62,62,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','2840','2840','Fees Collected'),
('2025-07-11',NULL,63,63,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','1710','1710','Fees Collected'),
('2025-07-12',NULL,64,64,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','1680','1680','Fees Collected'),
('2025-07-14',NULL,65,65,'Recipt','School Fee LKG UKG','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-07-14',NULL,66,66,'Recipt','books fees','Cash','Income/Revenue','Current Assets','520','520','Fees Collected'),
('2025-07-14',NULL,67,67,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','580','580','Fees Collected'),
('2025-07-15',NULL,68,68,'Recipt','BOOK FEES','Cash','Income/Revenue','Current Assets','1680','1680','Fees Collected'),
('2025-07-15',NULL,69,69,'Recipt','books fees','Cash','Income/Revenue','Current Assets','1040','1040','Fees Collected'),
('2025-07-16',NULL,70,70,'Recipt','BOOK FEES','Cash','Income/Revenue','Current Assets','1130','1130','Fees Collected'),
('2025-07-17',NULL,71,71,'Recipt','Book Fees ','Cash','Income/Revenue','Current Assets','2290','2290','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-07-18 0:00:28