|
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/../ORPS/../sojkp/ |
| [ 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_sojkp_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=2 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','SMT ODSO JADEMMA GURUSIDDAIAH\'S HIGH SCHOOL','KAMPLI','');
/*!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=2 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,'VARALAXMI ','','1540','HIGH SCHOOL',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=4 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
('8th',1,NULL),
('9th',2,NULL),
('10th',3,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=2 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=4 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
('SCHOOL FEES -8',1,'1/2','2026-06-01','No','0','1','SCHL'),
('SCHOOL FEES - 9',2,'2/3','2026-06-01','No','0','1','SCHL'),
('SCHOOL FEES - 10',3,'2/4','2026-06-01','No','0','1','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=6 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
('TUTION FEE (8)',1,'Income/Revenue'),
('DEVELOPMENT FEE (8)',2,'Income/Revenue'),
('VARALAXMI -1540',3,'Current Assets'),
('TUITION FEE (9)',4,'Income/Revenue'),
('TUITION FEE (10)',5,'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=388 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees`
--
LOCK TABLES `paid_fees` WRITE;
/*!40000 ALTER TABLE `paid_fees` DISABLE KEYS */;
INSERT INTO `paid_fees` VALUES
(1,125,'SCHL-1',1,'SCHL','SCHL-1',1,'2','/2/3','/1000/4000','2024-05-31','Cash','5737',0,0,5000,5000,1,'adminFees304',NULL),
(2,121,'SCHL-2',2,'SCHL','SCHL-2',2,'2','/2/3','/1000/2000','2024-06-05','Cash','5738',0,0,3000,3000,1,'adminFees304',NULL),
(3,194,'SCHL-3',3,'SCHL','SCHL-3',3,'2','/2/3','/1000/6000','2024-06-07','Cash','5739',0,0,7000,7000,1,'adminFees304',NULL),
(4,86,'SCHL-4',4,'SCHL','SCHL-4',4,'1','/1/2','/3000/1000','2024-06-07','Cash','5740',0,0,4000,4000,1,'adminFees304',NULL),
(5,151,'SCHL-5',5,'SCHL','SCHL-5',5,'2','/2/3','/1000/1000','2024-06-07','Cash','5741',0,0,2000,2000,1,'adminFees304',NULL),
(6,310,'SCHL-6',6,'SCHL','SCHL-6',6,'3','/2/4','/1000/4000','2024-06-08','Cash','5742',0,0,5000,5000,1,'adminFees304',NULL),
(7,252,'SCHL-7',7,'SCHL','SCHL-7',7,'3','/2/4','/1000/4000','2024-06-10','Cash','5743',0,0,5000,5000,1,'adminFees304',NULL),
(8,44,'SCHL-8',8,'SCHL','SCHL-8',8,'1','/1/2','/4000/1000','2024-06-10','Cash','5744',0,0,5000,5000,1,'adminFees304',NULL),
(9,16,'SCHL-9',9,'SCHL','SCHL-9',9,'1','/1/2','/3000/1000','2024-06-10','Cash','5745',0,0,4000,4000,1,'adminFees304',NULL),
(10,38,'SCHL-10',10,'SCHL','SCHL-10',10,'1','/1/2','/3000/1000','2024-06-10','Cash','5746',0,0,4000,4000,1,'adminFees304',NULL),
(11,85,'SCHL-11',11,'SCHL','SCHL-11',11,'1','/1/2','/1000/1000','2024-06-10','Cash','5747',0,0,2000,2000,1,'adminFees304',NULL),
(12,26,'SCHL-12',12,'SCHL','SCHL-12',12,'1','/1/2','/3000/1000','2024-06-10','Cash','5748',0,0,4000,4000,1,'adminFees304',NULL),
(13,80,'SCHL-13',13,'SCHL','SCHL-13',13,'1','/1/2','/2500/1000','2024-06-10','Cash','5749',0,0,3500,3500,1,'adminFees304',NULL),
(14,108,'SCHL-14',14,'SCHL','SCHL-14',14,'2','/2/3','/1000/6000','2024-06-10','Cash','5750',0,0,7000,7000,1,'adminFees304',NULL),
(15,71,'SCHL-15',15,'SCHL','SCHL-15',15,'1','/1/2','/3000/1000','2024-06-10','Cash','5751',0,0,4000,4000,1,'adminFees304',NULL),
(16,28,'SCHL-16',16,'SCHL','SCHL-16',16,'1','/1/2','/3000/1000','2024-06-10','Cash','5752',0,0,4000,4000,1,'adminFees304',NULL),
(17,61,'SCHL-17',17,'SCHL','SCHL-17',17,'1','/1/2','/2000/1000','2024-06-11','Cash','5753',0,0,3000,3000,1,'adminFees304',NULL),
(18,80,'SCHL-18',18,'SCHL','SCHL-18',18,'1','/1','/500','2024-06-11','Cash','5754',0,0,500,500,1,'adminFees304',NULL),
(19,10,'SCHL-19',19,'SCHL','SCHL-19',19,'1','/1/2','/4000/1000','2024-06-11','Cash','5755',0,0,5000,5000,1,'adminFees304',NULL),
(20,308,'SCHL-20',20,'SCHL','SCHL-20',20,'3','/2/4','/1000/4000','2024-06-11','Cash','5756',0,0,5000,5000,1,'adminFees304',NULL),
(21,87,'SCHL-21',21,'SCHL','SCHL-21',21,'1','/1/2','/4500/1000','2024-06-11','Cash','5757',0,0,5500,5500,1,'adminFees304',NULL),
(22,6,'SCHL-22',22,'SCHL','SCHL-22',22,'1','/1/2','/2000/1000','2024-06-11','Cash','5758',0,0,3000,3000,1,'adminFees304',NULL),
(23,93,'SCHL-23',23,'SCHL','SCHL-23',23,'1','/1/2','/4500/1000','2024-06-11','Cash','5759',0,0,5500,5500,1,'adminFees304',NULL),
(24,19,'SCHL-24',24,'SCHL','SCHL-24',24,'1','/1/2','/1000/1000','2024-06-11','Cash','5760',0,0,2000,2000,1,'adminFees304',NULL),
(25,40,'SCHL-25',25,'SCHL','SCHL-25',25,'1','/1/2','/500/1000','2024-06-11','Cash','5761',0,0,1500,1500,1,'adminFees304',NULL),
(26,32,'SCHL-26',26,'SCHL','SCHL-26',26,'1','/1/2','/3000/1000','2024-06-11','Cash','5762',0,0,4000,4000,1,'adminFees304',NULL),
(27,310,'SCHL-27',27,'SCHL','SCHL-27',27,'3','/4','/2000','2024-06-11','Cash','5763',0,0,2000,2000,1,'adminFees304',NULL),
(28,29,'SCHL-28',28,'SCHL','SCHL-28',28,'1','/1/2','/3000/1000','2024-06-11','Cash','5764',0,0,4000,4000,1,'adminFees304',NULL),
(29,7,'SCHL-29',29,'SCHL','SCHL-29',29,'1','/1/2','/2000/1000','2024-06-11','Cash','5765',0,0,3000,3000,1,'adminFees304',NULL),
(30,143,'SCHL-30',30,'SCHL','SCHL-30',30,'2','/2/3','/1000/1000','2024-06-11','Cash','5766',0,0,2000,2000,1,'adminFees304',NULL),
(31,51,'SCHL-31',31,'SCHL','SCHL-31',31,'1','/1/2','/5000/1000','2024-06-11','Cash','5767',0,0,6000,6000,1,'adminFees304',NULL),
(32,13,'SCHL-32',32,'SCHL','SCHL-32',32,'1','/1/2','/2000/1000','2024-06-11','Cash','5768',0,0,3000,3000,1,'adminFees304',NULL),
(33,101,'SCHL-33',33,'SCHL','SCHL-33',33,'2','/2/3','/1000/2000','2024-06-11','Cash','5769',0,0,3000,3000,1,'adminFees304',NULL),
(34,53,'SCHL-34',34,'SCHL','SCHL-34',34,'1','/1/2','/3000/1000','2024-06-11','Cash','5770',0,0,4000,4000,1,'adminFees304',NULL),
(35,15,'SCHL-35',35,'SCHL','SCHL-35',35,'1','/1/2','/2000/1000','2024-06-11','Cash','5771',0,0,3000,3000,1,'adminFees304',NULL),
(36,126,'SCHL-36',36,'SCHL','SCHL-36',36,'2','/2/3','/1000/2000','2024-06-11','Cash','5772',0,0,3000,3000,1,'adminFees304',NULL),
(37,69,'SCHL-37',37,'SCHL','SCHL-37',37,'1','/1/2','/5000/1000','2024-06-11','Cash','5773',0,0,6000,6000,1,'adminFees304',NULL),
(38,130,'SCHL-38',38,'SCHL','SCHL-38',38,'2','/2/3','/1000/6000','2024-06-11','Cash','5774',0,0,7000,7000,1,'adminFees304',NULL),
(39,59,'SCHL-39',39,'SCHL','SCHL-39',39,'1','/1/2','/3000/1000','2024-06-11','Cash','5775',0,0,4000,4000,1,'adminFees304',NULL),
(40,70,'SCHL-40',40,'SCHL','SCHL-40',40,'1','/1/2','/4000/1000','2024-06-11','Cash','5776',0,0,5000,5000,1,'adminFees304',NULL),
(41,45,'SCHL-41',41,'SCHL','SCHL-41',41,'1','/1/2','/3000/1000','2024-06-11','Cash','5777',0,0,4000,4000,1,'adminFees304',NULL),
(42,174,'SCHL-42',42,'SCHL','SCHL-42',42,'2','/2/3','/1000/6000','2024-06-11','Cash','5778',0,0,7000,7000,1,'adminFees304',NULL),
(43,3,'SCHL-43',43,'SCHL','SCHL-43',43,'1','/1/2','/5000/1000','2024-06-11','Cash','5779',0,0,6000,6000,1,'adminFees304',NULL),
(44,89,'SCHL-44',44,'SCHL','SCHL-44',44,'1','/1/2','/2000/1000','2024-06-11','Cash','5780',0,0,3000,3000,1,'adminFees304',NULL),
(45,170,'SCHL-45',45,'SCHL','SCHL-45',45,'2','/2/3','/1000/4000','2024-06-11','Cash','5781',0,0,5000,5000,1,'adminFees304',NULL),
(46,65,'SCHL-46',46,'SCHL','SCHL-46',46,'1','/1/2','/5000/1000','2024-06-11','Cash','5782',0,0,6000,6000,1,'adminFees304',NULL),
(47,81,'SCHL-47',47,'SCHL','SCHL-47',47,'1','/1/2','/2000/1000','2024-06-11','Cash','5783',0,0,3000,3000,1,'adminFees304',NULL),
(48,5,'SCHL-48',48,'SCHL','SCHL-48',48,'1','/1/2','/2000/1000','2024-06-11','Cash','5784',0,0,3000,3000,1,'adminFees304',NULL),
(49,76,'SCHL-49',49,'SCHL','SCHL-49',49,'1','/1/2','/5000/1000','2024-06-11','Cash','5785',0,0,6000,6000,1,'adminFees304',NULL),
(50,58,'SCHL-50',50,'SCHL','SCHL-50',50,'1','/1/2','/2500/1000','2024-06-12','Cash','5786',0,0,3500,3500,1,'adminFees304',NULL),
(51,189,'SCHL-51',51,'SCHL','SCHL-51',51,'2','/2/3','/1000/6000','2024-06-12','Cash','5787',0,0,7000,7000,1,'adminFees304',NULL),
(52,82,'SCHL-52',52,'SCHL','SCHL-52',52,'1','/1/2','/2000/1000','2024-06-12','Cash','5788',0,0,3000,3000,1,'adminFees304',NULL),
(53,12,'SCHL-53',53,'SCHL','SCHL-53',53,'1','/1/2','/3000/1000','2024-06-12','Cash','5789',0,0,4000,4000,1,'adminFees304',NULL),
(54,17,'SCHL-54',54,'SCHL','SCHL-54',54,'1','/1/2','/5000/1000','2024-06-12','Cash','5790',0,0,6000,6000,1,'adminFees304',NULL),
(55,54,'SCHL-55',55,'SCHL','SCHL-55',55,'1','/1/2','/3000/1000','2024-06-12','Cash','5791',0,0,4000,4000,1,'adminFees304',NULL),
(56,56,'SCHL-56',56,'SCHL','SCHL-56',56,'1','/1/2','/4000/1000','2024-06-12','Cash','5792',0,0,5000,5000,1,'adminFees304',NULL),
(57,49,'SCHL-57',57,'SCHL','SCHL-57',57,'1','/1/2','/4000/1000','2024-06-12','Cash','5793',0,0,5000,5000,1,'adminFees304',NULL),
(58,52,'SCHL-58',58,'SCHL','SCHL-58',58,'1','/1/2','/1000/1000','2024-06-12','Cash','5794',0,0,2000,2000,1,'adminFees304',NULL),
(59,14,'SCHL-59',59,'SCHL','SCHL-59',59,'1','/1/2','/2000/1000','2024-06-12','Cash','5795',0,0,3000,3000,1,'adminFees304',NULL),
(60,22,'SCHL-60',60,'SCHL','SCHL-60',60,'1','/1/2','/3000/1000','2024-06-12','Cash','5796',0,0,4000,4000,1,'adminFees304',NULL),
(61,20,'SCHL-61',61,'SCHL','SCHL-61',61,'1','/1/2','/4000/1000','2024-06-12','Cash','5797',0,0,5000,5000,1,'adminFees304',NULL),
(62,79,'SCHL-62',62,'SCHL','SCHL-62',62,'1','/1/2','/3000/1000','2024-06-12','Cash','5798',0,0,4000,4000,1,'adminFees304',NULL),
(63,94,'SCHL-63',63,'SCHL','SCHL-63',63,'1','/1/2','/3000/1000','2024-06-12','Cash','5799',0,0,4000,4000,1,'adminFees304',NULL),
(64,60,'SCHL-64',64,'SCHL','SCHL-64',64,'1','/1/2','/2000/1000','2024-06-12','Cash','5800',0,0,3000,3000,1,'adminFees304',NULL),
(65,34,'SCHL-65',65,'SCHL','SCHL-65',65,'1','/1/2','/3000/1000','2024-06-12','Cash','5801',0,0,4000,4000,1,'adminFees304',NULL),
(66,33,'SCHL-66',66,'SCHL','SCHL-66',66,'1','/1/2','/2000/1000','2024-06-12','Cash','5802',0,0,3000,3000,1,'adminFees304',NULL),
(67,84,'SCHL-67',67,'SCHL','SCHL-67',67,'1','/1/2','/3000/1000','2024-06-12','Cash','5803',0,0,4000,4000,1,'adminFees304',NULL),
(68,36,'SCHL-68',68,'SCHL','SCHL-68',68,'1','/1/2','/5000/1000','2024-06-12','Cash','5804',0,0,6000,6000,1,'adminFees304',NULL),
(69,21,'SCHL-69',69,'SCHL','SCHL-69',69,'1','/1/2','/3000/1000','2024-06-12','Cash','5805',0,0,4000,4000,1,'adminFees304',NULL),
(70,57,'SCHL-70',70,'SCHL','SCHL-70',70,'1','/1/2','/3000/1000','2024-06-12','Cash','5806',0,0,4000,4000,1,'adminFees304',NULL),
(71,43,'SCHL-71',71,'SCHL','SCHL-71',71,'1','/1/2','/4000/1000','2024-06-12','Cash','5807',0,0,5000,5000,1,'adminFees304',NULL),
(72,39,'SCHL-72',72,'SCHL','SCHL-72',72,'1','/1/2','/3000/1000','2024-06-12','Cash','5808',0,0,4000,4000,1,'adminFees304',NULL),
(73,8,'SCHL-73',73,'SCHL','SCHL-73',73,'1','/1/2','/1500/1000','2024-06-12','Cash','5809',0,0,2500,2500,1,'adminFees304',NULL),
(74,4,'SCHL-74',74,'SCHL','SCHL-74',74,'1','/1/2','/5000/1000','2024-06-13','Cash','5810',0,0,6000,6000,1,'adminFees304',NULL),
(75,35,'SCHL-75',75,'SCHL','SCHL-75',75,'1','/1/2','//1000','2024-06-13','Cash','5811',0,0,1000,1000,1,'adminFees304',NULL),
(76,42,'SCHL-76',76,'SCHL','SCHL-76',76,'1','/1/2','/4000/1000','2024-06-13','Cash','5812',0,0,5000,5000,1,'adminFees304',NULL),
(77,23,'SCHL-77',77,'SCHL','SCHL-77',77,'1','/1/2','/3000/1000','2024-06-13','Cash','5813',0,0,4000,4000,1,'adminFees304',NULL),
(78,50,'SCHL-78',78,'SCHL','SCHL-78',78,'1','/1/2','/1000/1000','2024-06-13','Cash','5814',0,0,2000,2000,1,'adminFees304',NULL),
(79,46,'SCHL-79',79,'SCHL','SCHL-79',79,'1','/1/2','/3000/1000','2024-06-13','Cash','5816',0,0,4000,4000,1,'adminFees304',NULL),
(80,68,'SCHL-80',80,'SCHL','SCHL-80',80,'1','/1/2','/2500/1000','2024-06-13','Cash','5817',0,0,3500,3500,1,'adminFees304',NULL),
(81,75,'SCHL-81',81,'SCHL','SCHL-81',81,'1','/1/2','/1000/1000','2024-06-13','Cash','5818',0,0,2000,2000,1,'adminFees304',NULL),
(82,27,'SCHL-82',82,'SCHL','SCHL-82',82,'1','/1/2','/5000/1000','2024-06-13','Cash','5819',0,0,6000,6000,1,'adminFees304',NULL),
(83,63,'SCHL-83',83,'SCHL','SCHL-83',83,'1','/1/2','/2000/1000','2024-06-13','Cash','5820',0,0,3000,3000,1,'adminFees304',NULL),
(84,73,'SCHL-84',84,'SCHL','SCHL-84',84,'1','/1/2','/2000/1000','2024-06-13','Cash','5821',0,0,3000,3000,1,'adminFees304',NULL),
(85,67,'SCHL-85',85,'SCHL','SCHL-85',85,'1','/1/2','/3000/1000','2024-06-13','Cash','5822',0,0,4000,4000,1,'adminFees304',NULL),
(86,41,'SCHL-86',86,'SCHL','SCHL-86',86,'1','/1/2','/2000/1000','2024-06-14','Cash','5823',0,0,3000,3000,1,'adminFees304',NULL),
(87,90,'SCHL-87',87,'SCHL','SCHL-87',87,'1','/1/2','/5000/1000','2024-06-14','Cash','5824',0,0,6000,6000,1,'adminFees304',NULL),
(88,37,'SCHL-88',88,'SCHL','SCHL-88',88,'1','/1/2','/2000/1000','2024-06-14','Cash','5825',0,0,3000,3000,1,'adminFees304',NULL),
(89,66,'SCHL-89',89,'SCHL','SCHL-89',89,'1','/1/2','/5000/1000','2024-06-19','Cash','5826',0,0,6000,6000,1,'adminFees304',NULL),
(90,212,'SCHL-90',90,'SCHL','SCHL-90',90,'3','/2/4','/1000/3000','2024-06-19','Cash','5827',0,0,4000,4000,1,'adminFees304',NULL),
(91,109,'SCHL-91',91,'SCHL','SCHL-91',91,'2','/2/3','/1000/6000','2024-06-19','Cash','5829',0,0,7000,7000,1,'adminFees304',NULL),
(92,158,'SCHL-92',92,'SCHL','SCHL-92',92,'2','/2/3','/1000/2000','2024-06-19','Cash','5830',0,0,3000,3000,1,'adminFees304',NULL),
(93,257,'SCHL-93',93,'SCHL','SCHL-93',93,'3','/2/4','/1000/3000','2024-06-19','Cash','5831',0,0,4000,4000,1,'adminFees304',NULL),
(94,30,'SCHL-94',94,'SCHL','SCHL-94',94,'1','/1/2','/3000/1000','2024-06-19','Cash','5832',0,0,4000,4000,1,'adminFees304',NULL),
(95,9,'SCHL-95',95,'SCHL','SCHL-95',95,'1','/1/2','/3500/1000','2024-06-19','Cash','5833',0,0,4500,4500,1,'adminFees304',NULL),
(96,25,'SCHL-96',96,'SCHL','SCHL-96',96,'1','/1/2','/3000/1000','2024-06-19','Cash','5834',0,0,4000,4000,1,'adminFees304',NULL),
(97,24,'SCHL-97',97,'SCHL','SCHL-97',97,'1','/1/2','/5000/1000','2024-06-19','Cash','5835',0,0,6000,6000,1,'adminFees304',NULL),
(98,309,'SCHL-98',98,'SCHL','SCHL-98',98,'3','/2/4','/1000/4000','2024-06-20','Cash','5836',0,0,5000,5000,1,'adminFees304',NULL),
(99,62,'SCHL-99',99,'SCHL','SCHL-99',99,'1','/1/2','/3000/1000','2024-06-20','Cash','5837',0,0,4000,4000,1,'adminFees304',NULL),
(100,96,'SCHL-100',100,'SCHL','SCHL-100',100,'1','/1/2','/5000/1000','2024-06-20','Cash','5838',0,0,6000,6000,1,'adminFees304',NULL),
(101,290,'SCHL-101',101,'SCHL','SCHL-101',101,'3','/2/4','/1000/2000','2024-06-21','Cash','5839',0,0,3000,3000,1,'adminFees304',NULL),
(102,91,'SCHL-102',102,'SCHL','SCHL-102',102,'1','/1/2','/2000/1000','2024-06-21','Cash','5840',0,0,3000,3000,1,'adminFees304',NULL),
(103,47,'SCHL-103',103,'SCHL','SCHL-103',103,'1','/1/2','/4000/1000','2024-06-21','Cash','5841',0,0,5000,5000,1,'adminFees304',NULL),
(104,175,'SCHL-104',104,'SCHL','SCHL-104',104,'2','/2/3','/1000/6000','2024-06-24','Cash','5842',0,0,7000,7000,1,'adminFees304',NULL),
(105,129,'SCHL-105',105,'SCHL','SCHL-105',105,'2','/2/3','/1000/2000','2024-06-24','Cash','5843',0,0,3000,3000,1,'adminFees304',NULL),
(106,312,'SCHL-106',106,'SCHL','SCHL-106',106,'3','/2/4','/1000/1000','2024-06-24','Cash','5844',0,0,2000,2000,1,'adminFees304',NULL),
(107,95,'SCHL-107',107,'SCHL','SCHL-107',107,'1','/1/2','/1000/1000','2024-06-24','Cash','5845',0,0,2000,2000,1,'adminFees304',NULL),
(108,288,'SCHL-108',108,'SCHL','SCHL-108',108,'3','/2/4','/1000/1000','2024-06-24','Cash','5846',0,0,2000,2000,1,'adminFees304',NULL),
(109,148,'SCHL-109',109,'SCHL','SCHL-109',109,'2','/2/3','/1000/1000','2024-06-24','Cash','5847',0,0,2000,2000,1,'adminFees304',NULL),
(110,179,'SCHL-110',110,'SCHL','SCHL-110',110,'2','/2/3','/1000/6000','2024-06-24','Cash','5848',0,0,7000,7000,1,'adminFees304',NULL),
(111,273,'SCHL-111',111,'SCHL','SCHL-111',111,'3','/2/4','/1000/2000','2024-06-24','Cash','5849',0,0,3000,3000,1,'adminFees304',NULL),
(112,180,'SCHL-112',112,'SCHL','SCHL-112',112,'2','/2/3','/1000/6000','2024-06-24','Cash','5850',0,0,7000,7000,1,'adminFees304',NULL),
(113,168,'SCHL-113',113,'SCHL','SCHL-113',113,'2','/2/3','/1000/6000','2024-06-24','Cash','5851',0,0,7000,7000,1,'adminFees304',NULL),
(114,165,'SCHL-114',114,'SCHL','SCHL-114',114,'2','/2/3','/1000/2000','2024-06-24','Cash','5852',0,0,3000,3000,1,'adminFees304',NULL),
(115,166,'SCHL-115',115,'SCHL','SCHL-115',115,'2','/2/3','/1000/2000','2024-06-24','Cash','5853',0,0,3000,3000,1,'adminFees304',NULL),
(116,78,'SCHL-116',116,'SCHL','SCHL-116',116,'1','/1/2','/2000/1000','2024-06-24','Cash','5854',0,0,3000,3000,1,'adminFees304',NULL),
(117,144,'SCHL-117',117,'SCHL','SCHL-117',117,'2','/2/3','/1000/1500','2024-06-24','Cash','5855',0,0,2500,2500,1,'adminFees304',NULL),
(118,55,'SCHL-118',118,'SCHL','SCHL-118',118,'1','/1/2','/5000/1000','2024-06-24','Cash','5856',0,0,6000,6000,1,'adminFees304',NULL),
(119,5,'SCHL-119',119,'SCHL','SCHL-119',119,'1','/1','/3000','2024-06-25','Cash','5857',0,0,3000,3000,1,'adminFees304',NULL),
(120,18,'SCHL-120',120,'SCHL','SCHL-120',120,'1','/1/2','/3000/1000','2024-06-25','Cash','5858',0,0,4000,4000,1,'adminFees304',NULL),
(121,120,'SCHL-121',121,'SCHL','SCHL-121',121,'2','/2/3','/1000/1000','2024-06-25','Cash','5859',0,0,2000,2000,1,'adminFees304',NULL),
(122,303,'SCHL-122',122,'SCHL','SCHL-122',122,'3','/2/4','/1000/4000','2024-06-25','Cash','5860',0,0,5000,5000,1,'adminFees304',NULL),
(123,186,'SCHL-123',123,'SCHL','SCHL-123',123,'2','/2/3','/1000/3000','2024-06-25','Cash','5861',0,0,4000,4000,1,'adminFees304',NULL),
(124,138,'SCHL-124',124,'SCHL','SCHL-124',124,'2','/2/3','/1000/3000','2024-06-25','Cash','5862',0,0,4000,4000,1,'adminFees304',NULL),
(125,83,'SCHL-125',125,'SCHL','SCHL-125',125,'1','/1/2','/5000/1000','2024-06-25','Cash','5863',0,0,6000,6000,1,'adminFees304',NULL),
(126,240,'SCHL-126',126,'SCHL','SCHL-126',126,'3','/2/4','/1000/1000','2024-06-26','Cash','5864',0,0,2000,2000,1,'adminFees304',NULL),
(127,135,'SCHL-127',127,'SCHL','SCHL-127',127,'2','/2/3','/1000/1000','2024-06-26','Cash','5865',0,0,2000,2000,1,'adminFees304',NULL),
(128,271,'SCHL-128',128,'SCHL','SCHL-128',128,'3','/2/4','/1000/','2024-06-26','Cash','5866',0,0,1000,1000,1,'adminFees304',NULL),
(129,242,'SCHL-129',129,'SCHL','SCHL-129',129,'3','/2/4','/1000/3000','2024-06-27','Cash','5867',0,0,4000,4000,1,'adminFees304',NULL),
(130,236,'SCHL-130',130,'SCHL','SCHL-130',130,'3','/2/4','/1000/1000','2024-06-27','Cash','5868',0,0,2000,2000,1,'adminFees304',NULL),
(131,133,'SCHL-131',131,'SCHL','SCHL-131',131,'2','/2/3','/1000/2000','2024-06-27','Cash','5869',0,0,3000,3000,1,'adminFees304',NULL),
(132,105,'SCHL-132',132,'SCHL','SCHL-132',132,'2','/2/3','/1000/2000','2024-06-28','Cash','5870',0,0,3000,3000,1,'adminFees304',NULL),
(133,74,'SCHL-133',133,'SCHL','SCHL-133',133,'1','/1/2','/2000/1000','2024-06-28','Cash','5871',0,0,3000,3000,1,'adminFees304',NULL),
(134,218,'SCHL-134',134,'SCHL','SCHL-134',134,'3','/2/4','/1000/2000','2024-06-28','Cash','5872',0,0,3000,3000,1,'adminFees304',NULL),
(386,216,'SCHL-386',386,'SCHL','SCHL-386',386,'3','/2/4','/1000/4000','2024-06-28','Cash','5873',0,0,5000,5000,1,'adminFees304',NULL),
(136,103,'SCHL-136',136,'SCHL','SCHL-136',136,'2','/2/3','/1000/1000','2024-06-28','Cash','5874',0,0,2000,2000,1,'adminFees304',NULL),
(137,152,'SCHL-137',137,'SCHL','SCHL-137',137,'2','/2/3','/1000/2500','2024-06-28','Cash','5875',0,0,3500,3500,1,'adminFees304',NULL),
(138,220,'SCHL-138',138,'SCHL','SCHL-138',138,'3','/2/4','/1000/1000','2024-06-29','Cash','5876',0,0,2000,2000,1,'adminFees304',NULL),
(139,275,'SCHL-139',139,'SCHL','SCHL-139',139,'3','/2/4','/1000/3000','2024-07-01','Cash','5877',0,0,4000,4000,1,'adminFees304',NULL),
(140,302,'SCHL-140',140,'SCHL','SCHL-140',140,'3','/2/4','/1000/','2024-07-01','Cash','5878',0,0,1000,1000,1,'adminFees304',NULL),
(141,244,'SCHL-141',141,'SCHL','SCHL-141',141,'3','/2/4','/1000/3000','2024-07-01','Cash','5879',0,0,4000,4000,1,'adminFees304',NULL),
(142,207,'SCHL-142',142,'SCHL','SCHL-142',142,'2','/2/3','/1000/000','2024-07-01','Cash','5880',0,0,1000,1000,1,'adminFees304',NULL),
(143,119,'SCHL-143',143,'SCHL','SCHL-143',143,'2','/2/3','/1000/3000','2024-07-01','Cash','5881',0,0,4000,4000,1,'adminFees304',NULL),
(144,205,'SCHL-144',144,'SCHL','SCHL-144',144,'2','/2/3','/1000/1000','2024-07-02','Cash','5882',0,0,2000,2000,1,'adminFees304',NULL),
(145,48,'SCHL-145',145,'SCHL','SCHL-145',145,'1','/1/2','/1500/1000','2024-07-02','Cash','5883',0,0,2500,2500,1,'adminFees304',NULL),
(146,196,'SCHL-146',146,'SCHL','SCHL-146',146,'2','/2/3','/1000/1000','2024-07-02','Cash','5884',0,0,2000,2000,1,'adminFees304',NULL),
(147,64,'SCHL-147',147,'SCHL','SCHL-147',147,'1','/1/2','/1000/1000','2024-07-02','Cash','5885',0,0,2000,2000,1,'adminFees304',NULL),
(148,239,'SCHL-148',148,'SCHL','SCHL-148',148,'3','/2/4','/1000/5000','2024-07-02','Cash','5886',0,0,6000,6000,1,'adminFees304',NULL),
(149,305,'SCHL-149',149,'SCHL','SCHL-149',149,'3','/2/4','/1000/2000','2024-07-02','Cash','5887',0,0,3000,3000,1,'adminFees304',NULL),
(150,250,'SCHL-150',150,'SCHL','SCHL-150',150,'3','/2/4','/1000/5000','2024-07-03','Cash','5888',0,0,6000,6000,1,'adminFees304',NULL),
(151,134,'SCHL-151',151,'SCHL','SCHL-151',151,'2','/2/3','/1000/3000','2024-07-03','Cash','5889',0,0,4000,4000,1,'adminFees304',NULL),
(152,270,'SCHL-152',152,'SCHL','SCHL-152',152,'3','/2/4','/1000/3000','2024-07-03','Cash','5890',0,0,4000,4000,1,'adminFees304',NULL),
(153,284,'SCHL-153',153,'SCHL','SCHL-153',153,'3','/2/4','/1000/1000','2024-07-03','Cash','5891',0,0,2000,2000,1,'adminFees304',NULL),
(154,116,'SCHL-154',154,'SCHL','SCHL-154',154,'2','/2/3','/1000/2000','2024-07-03','Cash','5892',0,0,3000,3000,1,'adminFees304',NULL),
(155,243,'SCHL-155',155,'SCHL','SCHL-155',155,'3','/2/4','/1000/3000','2024-07-04','Cash','5893',0,0,4000,4000,1,'adminFees304',NULL),
(156,234,'SCHL-156',156,'SCHL','SCHL-156',156,'3','/2/4','/1000/1000','2024-07-05','Cash','5894',0,0,2000,2000,1,'adminFees304',NULL),
(157,249,'SCHL-157',157,'SCHL','SCHL-157',157,'3','/2/4','/1000/1000','2024-07-05','Cash','5895',0,0,2000,2000,1,'adminFees304',NULL),
(158,99,'SCHL-158',158,'SCHL','SCHL-158',158,'2','/2/3','/1000/3000','2024-07-05','Cash','5896',0,0,4000,4000,1,'adminFees304',NULL),
(159,279,'SCHL-159',159,'SCHL','SCHL-159',159,'3','/2/4','/1000/3000','2024-07-05','Cash','5897',0,0,4000,4000,1,'adminFees304',NULL),
(160,295,'SCHL-160',160,'SCHL','SCHL-160',160,'3','/2/4','/1000/4000','2024-07-08','Cash','5898',0,0,5000,5000,1,'adminFees304',NULL),
(161,195,'SCHL-161',161,'SCHL','SCHL-161',161,'2','/2/3','/1000/2000','2024-07-08','Cash','5899',0,0,3000,3000,1,'adminFees304',NULL),
(162,283,'SCHL-162',162,'SCHL','SCHL-162',162,'3','/2/4','/1000/1000','2024-07-08','Cash','5900',0,0,2000,2000,1,'adminFees304',NULL),
(163,314,'SCHL-163',163,'SCHL','SCHL-163',163,'3','/2/4','/1000/3000','2024-07-08','Cash','5901',0,0,4000,4000,1,'adminFees304',NULL),
(164,92,'SCHL-164',164,'SCHL','SCHL-164',164,'1','/1/2','/3000/1000','2024-07-08','Cash','5902',0,0,4000,4000,1,'adminFees304',NULL),
(165,198,'SCHL-165',165,'SCHL','SCHL-165',165,'2','/2/3','/1000/4000','2024-07-08','Cash','5903',0,0,5000,5000,1,'adminFees304',NULL),
(225,269,'SCHL-225',225,'SCHL','SCHL-225',225,'3','/2/4','/1000/1000','2024-07-09','Cash','5904',0,0,2000,2000,1,'adminFees304',NULL),
(167,262,'SCHL-167',167,'SCHL','SCHL-167',167,'3','/2/4','/1000/3000','2024-07-09','Cash','5905',0,0,4000,4000,1,'adminFees304',NULL),
(168,248,'SCHL-168',168,'SCHL','SCHL-168',168,'3','/2/4','/1000/4000','2024-07-09','Cash','5906',0,0,5000,5000,1,'adminFees304',NULL),
(169,11,'SCHL-169',169,'SCHL','SCHL-169',169,'1','/1/2','/2000/1000','2024-07-09','Cash','5908',0,0,3000,3000,1,'adminFees304',NULL),
(170,286,'SCHL-170',170,'SCHL','SCHL-170',170,'3','/2/4','/1000/4000','2024-07-09','Cash','5907',0,0,5000,5000,1,'adminFees304',NULL),
(171,233,'SCHL-171',171,'SCHL','SCHL-171',171,'3','/2/4','/1000/3000','2024-07-10','Cash','5909',0,0,4000,4000,1,'adminFees304',NULL),
(172,317,'SCHL-172',172,'SCHL','SCHL-172',172,'3','/2/4','/1000/1500','2024-07-10','Cash','5910',0,0,2500,2500,1,'adminFees304',NULL),
(173,246,'SCHL-173',173,'SCHL','SCHL-173',173,'3','/2/4','/1000/1500','2024-07-10','Cash','5911',0,0,2500,2500,1,'adminFees304',NULL),
(174,267,'SCHL-174',174,'SCHL','SCHL-174',174,'3','/2/4','/1000/0000','2024-07-10','Cash','5913',0,0,1000,1000,1,'adminFees304',NULL),
(175,311,'SCHL-175',175,'SCHL','SCHL-175',175,'3','/2/4','/1000/3000','2024-07-10','Cash','5914',0,0,4000,4000,1,'adminFees304',NULL),
(176,225,'SCHL-176',176,'SCHL','SCHL-176',176,'3','/2/4','/1000/3000','2024-07-10','Cash','5915',0,0,4000,4000,1,'adminFees304',NULL),
(177,293,'SCHL-177',177,'SCHL','SCHL-177',177,'3','/2/4','/1000/3000','2024-07-10','Cash','5916',0,0,4000,4000,1,'adminFees304',NULL),
(178,265,'SCHL-178',178,'SCHL','SCHL-178',178,'3','/2/4','/1000/00','2024-07-11','Cash','5917',0,0,1000,1000,1,'adminFees304',NULL),
(179,221,'SCHL-179',179,'SCHL','SCHL-179',179,'3','/2/4','/1000/3000','2024-07-11','Cash','5918',0,0,4000,4000,1,'adminFees304',NULL),
(180,227,'SCHL-180',180,'SCHL','SCHL-180',180,'3','/2/4','/1000/3000','2024-07-13','Cash','5919',0,0,4000,4000,1,'adminFees304',NULL),
(181,281,'SCHL-181',181,'SCHL','SCHL-181',181,'3','/2/4','/1000/000','2024-07-13','Cash','5920',0,0,1000,1000,1,'adminFees304',NULL),
(182,156,'SCHL-182',182,'SCHL','SCHL-182',182,'2','/2/3','/1000/2000','2024-07-13','Cash','5921',0,0,3000,3000,1,'adminFees304',NULL),
(183,229,'SCHL-183',183,'SCHL','SCHL-183',183,'3','/2/4','/1000/3000','2024-07-15','Cash','5922',0,0,4000,4000,1,'adminFees304',NULL),
(187,306,'SCHL-187',187,'SCHL','SCHL-187',187,'3','/2/4','/1000/6000','2024-07-16','Cash','5924',0,0,7000,7000,1,'adminFees304',NULL),
(185,187,'SCHL-185',185,'SCHL','SCHL-185',185,'2','/2/3','/1000/5000','2024-07-16','Cash','5925',0,0,6000,6000,1,'adminFees304',NULL),
(186,127,'SCHL-186',186,'SCHL','SCHL-186',186,'2','/2/3','/1000/2000','2024-07-18','Cash','5926',0,0,3000,3000,1,'adminFees304',NULL),
(188,52,'SCHL-188',188,'SCHL','SCHL-188',188,'1','/1','/2000','2024-07-18','Cash','5927',0,0,2000,2000,1,'adminFees304',NULL),
(226,269,'SCHL-226',226,'SCHL','SCHL-226',226,'3','/4','/2000','2024-07-18','Cash','5927',0,0,2000,2000,1,'adminFees304',NULL),
(190,147,'SCHL-190',190,'SCHL','SCHL-190',190,'2','/2/3','/1000/1000','2024-07-22','Cash','5930',0,0,2000,2000,1,'adminFees304',NULL),
(191,155,'SCHL-191',191,'SCHL','SCHL-191',191,'2','/2/3','/1000/500','2024-07-22','Cash','5931',0,0,1500,1500,1,'adminFees304',NULL),
(192,102,'SCHL-192',192,'SCHL','SCHL-192',192,'2','/2/3','/1000/2000','2024-07-22','Cash','5932',0,0,3000,3000,1,'adminFees304',NULL),
(193,254,'SCHL-193',193,'SCHL','SCHL-193',193,'3','/2/4','/1000/3000','2024-07-22','Cash','5933',0,0,4000,4000,1,'adminFees304',NULL),
(194,137,'SCHL-194',194,'SCHL','SCHL-194',194,'2','/2/3','/1000/2000','2024-07-22','Cash','5934',0,0,3000,3000,1,'adminFees304',NULL),
(195,145,'SCHL-195',195,'SCHL','SCHL-195',195,'2','/2/3','/1000/6000','2024-07-22','Cash','5935',0,0,7000,7000,1,'adminFees304',NULL),
(196,177,'SCHL-196',196,'SCHL','SCHL-196',196,'2','/2/3','/1000/2000','2024-07-22','Cash','5936',0,0,3000,3000,1,'adminFees304',NULL),
(197,260,'SCHL-197',197,'SCHL','SCHL-197',197,'3','/2/4','/1000/2000','2024-07-22','Cash','5937',0,0,3000,3000,1,'adminFees304',NULL),
(198,224,'SCHL-198',198,'SCHL','SCHL-198',198,'3','/2/4','/1000/1000','2024-07-23','Cash','5938',0,0,2000,2000,1,'adminFees304',NULL),
(199,162,'SCHL-199',199,'SCHL','SCHL-199',199,'2','/2/3','/1000/0000','2024-07-23','Cash','5939',0,0,1000,1000,1,'adminFees304',NULL),
(200,178,'SCHL-200',200,'SCHL','SCHL-200',200,'2','/2/3','/1000/1000','2024-07-24','Cash','5940',0,0,2000,2000,1,'adminFees304',NULL),
(201,316,'SCHL-201',201,'SCHL','SCHL-201',201,'3','/2/4','/1000/1000','2024-07-24','Cash','5941',0,0,2000,2000,1,'adminFees304',NULL),
(202,188,'SCHL-202',202,'SCHL','SCHL-202',202,'2','/2/3','/1000/2000','2024-07-24','Cash','5942',0,0,3000,3000,1,'adminFees304',NULL),
(203,230,'SCHL-203',203,'SCHL','SCHL-203',203,'3','/2/4','/1000/1000','2024-07-24','Cash','5943',0,0,2000,2000,1,'adminFees304',NULL),
(204,169,'SCHL-204',204,'SCHL','SCHL-204',204,'2','/2/3','/1000/1500','2024-07-24','Cash','5944',0,0,2500,2500,1,'adminFees304',NULL),
(205,149,'SCHL-205',205,'SCHL','SCHL-205',205,'2','/2/3','/1000/3000','2024-07-25','Cash','5946',0,0,4000,4000,1,'adminFees304',NULL),
(206,88,'SCHL-206',206,'SCHL','SCHL-206',206,'1','/1/2','/2000/1000','2024-07-24','Cash','5945',0,0,3000,3000,1,'adminFees304',NULL),
(207,155,'SCHL-207',207,'SCHL','SCHL-207',207,'2','/3','/2500','2024-07-25','Cash','5947',0,0,2500,2500,1,'adminFees304',NULL),
(208,237,'SCHL-208',208,'SCHL','SCHL-208',208,'3','/2/4','/1000/3000','2024-07-25','Cash','5948',0,0,4000,4000,1,'adminFees304',NULL),
(209,125,'SCHL-209',209,'SCHL','SCHL-209',209,'2','/3','/2000','2024-07-25','Cash','5949',0,0,2000,2000,1,'adminFees304',NULL),
(210,271,'SCHL-210',210,'SCHL','SCHL-210',210,'3','/4','/1000','2024-07-26','Cash','5950',0,0,1000,1000,1,'adminFees304',NULL),
(211,139,'SCHL-211',211,'SCHL','SCHL-211',211,'2','/2/3','/1000/3000','2024-07-29','Cash','5951',0,0,4000,4000,1,'adminFees304',NULL),
(212,202,'SCHL-212',212,'SCHL','SCHL-212',212,'2','/2/3','/1000/3000','2024-07-29','Cash','5952',0,0,4000,4000,1,'adminFees304',NULL),
(213,172,'SCHL-213',213,'SCHL','SCHL-213',213,'2','/2/3','/1000/1000','2024-07-29','Cash','5953',0,0,2000,2000,1,'adminFees304',NULL),
(214,185,'SCHL-214',214,'SCHL','SCHL-214',214,'2','/2/3','/1000/3000','2024-07-30','Cash','5954',0,0,4000,4000,1,'adminFees304',NULL),
(215,241,'SCHL-215',215,'SCHL','SCHL-215',215,'3','/2/4','/1000/4000','2024-08-05','Cash','5956',0,0,5000,5000,1,'adminFees304',NULL),
(216,217,'SCHL-216',216,'SCHL','SCHL-216',216,'3','/2/4','/1000/1000','2024-08-05','Cash','5957',0,0,2000,2000,1,'adminFees304',NULL),
(217,201,'SCHL-217',217,'SCHL','SCHL-217',217,'2','/2/3','/1000/1000','2024-08-07','Cash','5958',0,0,2000,2000,1,'adminFees304',NULL),
(218,204,'SCHL-218',218,'SCHL','SCHL-218',218,'2','/2/3','/1000/000','2024-08-07','Cash','5959',0,0,1000,1000,1,'adminFees304',NULL),
(219,214,'SCHL-219',219,'SCHL','SCHL-219',219,'3','/2/4','/1000/1000','2024-08-08','Cash','5960',0,0,2000,2000,1,'adminFees304',NULL),
(220,161,'SCHL-220',220,'SCHL','SCHL-220',220,'2','/2/3','/1000/2000','2024-08-08','Cash','5961',0,0,3000,3000,1,'adminFees304',NULL),
(221,115,'SCHL-221',221,'SCHL','SCHL-221',221,'2','/2/3','/1000/1000','2024-08-13','Cash','5962',0,0,2000,2000,1,'adminFees304',NULL),
(222,106,'SCHL-222',222,'SCHL','SCHL-222',222,'2','/2/3','/1000/1000','2024-08-13','Cash','5963',0,0,2000,2000,1,'adminFees304',NULL),
(223,249,'SCHL-223',223,'SCHL','SCHL-223',223,'3','/4','/2000','2024-08-13','Cash','5964',0,0,2000,2000,1,'adminFees304',NULL),
(224,124,'SCHL-224',224,'SCHL','SCHL-224',224,'2','/2/3','/1000/1000','2024-08-13','Cash','5965',0,0,2000,2000,1,'adminFees304',NULL),
(227,269,'SCHL-227',227,'SCHL','SCHL-227',227,'3','/4','/1000','2024-08-16','Cash','5966',0,0,1000,1000,1,'adminFees304',NULL),
(228,52,'SCHL-228',228,'SCHL','SCHL-228',228,'1','/1','/1000','2024-08-16','Cash','5967',0,0,1000,1000,1,'adminFees304',NULL),
(229,299,'SCHL-229',229,'SCHL','SCHL-229',229,'3','/2/4','/1000/2000','2024-08-16','Cash','5968',0,0,3000,3000,1,'adminFees304',NULL),
(230,218,'SCHL-230',230,'SCHL','SCHL-230',230,'3','/4','/3000','2024-08-17','Cash','5969',0,0,3000,3000,1,'adminFees304',NULL),
(231,104,'SCHL-231',231,'SCHL','SCHL-231',231,'2','/2/3','/1000/000','2024-08-17','Cash','5970',0,0,1000,1000,1,'adminFees304',NULL),
(232,213,'SCHL-232',232,'SCHL','SCHL-232',232,'3','/2/4','/1000/3000','2024-08-20','Cash','5971',0,0,4000,4000,1,'adminFees304',NULL),
(233,264,'SCHL-233',233,'SCHL','SCHL-233',233,'3','/2/4','/1000/3000','2024-08-22','Cash','5972',0,0,4000,4000,1,'adminFees304',NULL),
(234,77,'SCHL-234',234,'SCHL','SCHL-234',234,'1','/1/2','/2000/1000','2024-08-22','Cash','5973',0,0,3000,3000,1,'adminFees304',NULL),
(235,217,'SCHL-235',235,'SCHL','SCHL-235',235,'3','/4','/2000','2024-08-22','Cash','5974',0,0,2000,2000,1,'adminFees304',NULL),
(236,281,'SCHL-236',236,'SCHL','SCHL-236',236,'3','/4','/2000','2024-08-23','Cash','5975',0,0,2000,2000,1,'adminFees304',NULL),
(237,113,'SCHL-237',237,'SCHL','SCHL-237',237,'2','/2/3','/1000/1000','2024-08-29','Cash','5976',0,0,2000,2000,1,'adminFees304',NULL),
(238,238,'SCHL-238',238,'SCHL','SCHL-238',238,'3','/2/4','/1000/3000','2024-08-29','Cash','5977',0,0,4000,4000,1,'adminFees304',NULL),
(239,122,'SCHL-239',239,'SCHL','SCHL-239',239,'2','/2/3','/1000/4000','2024-08-31','Cash','5978',0,0,5000,5000,1,'adminFees304',NULL),
(240,273,'SCHL-240',240,'SCHL','SCHL-240',240,'3','/4','/500','2024-09-02','Cash','5979',0,0,500,500,1,'adminFees304',NULL),
(241,291,'SCHL-241',241,'SCHL','SCHL-241',241,'3','/2/4','/1000/3000','2024-09-09','Cash','5980',0,0,4000,4000,1,'adminFees304',NULL),
(242,204,'SCHL-242',242,'SCHL','SCHL-242',242,'2','/3','/1000','2024-09-09','Cash','5981',0,0,1000,1000,1,'adminFees304',NULL),
(243,232,'SCHL-243',243,'SCHL','SCHL-243',243,'3','/2/4','/1000/4000','2024-09-10','Cash','5982',0,0,5000,5000,1,'adminFees304',NULL),
(244,301,'SCHL-244',244,'SCHL','SCHL-244',244,'3','/2/4','/1000/7000','2024-09-11','Cash','5983',0,0,8000,8000,1,'adminFees304',NULL),
(245,277,'SCHL-245',245,'SCHL','SCHL-245',245,'3','/2/4','/1000/4000','2024-09-11','Cash','5984',0,0,5000,5000,1,'adminFees304',NULL),
(246,117,'SCHL-246',246,'SCHL','SCHL-246',246,'2','/2/3','/1000/2000','2024-09-11','Cash','5985',0,0,3000,3000,1,'adminFees304',NULL),
(247,114,'SCHL-247',247,'SCHL','SCHL-247',247,'2','/2/3','/1000/6000','2024-09-11','Cash','5986',0,0,7000,7000,1,'adminFees304',NULL),
(248,178,'SCHL-248',248,'SCHL','SCHL-248',248,'2','/3','/1500','2024-09-12','Cash','5987',0,0,1500,1500,1,'adminFees304',NULL),
(249,147,'SCHL-249',249,'SCHL','SCHL-249',249,'2','/3','/2000','2024-09-12','Cash','5988',0,0,2000,2000,1,'adminFees304',NULL),
(250,193,'SCHL-250',250,'SCHL','SCHL-250',250,'2','/2/3','/1000/1000','2024-09-12','Cash','5989',0,0,2000,2000,1,'adminFees304',NULL),
(251,210,'SCHL-251',251,'SCHL','SCHL-251',251,'3','/2/4','/1000/4000','2024-09-12','Cash','5990',0,0,5000,5000,1,'adminFees304',NULL),
(252,300,'SCHL-252',252,'SCHL','SCHL-252',252,'3','/2/4','/1000/1000','2024-09-13','Cash','5991',0,0,2000,2000,1,'adminFees304',NULL),
(253,140,'SCHL-253',253,'SCHL','SCHL-253',253,'2','/2/3','/1000/1000','2024-09-13','Cash','5992',0,0,2000,2000,1,'adminFees304',NULL),
(254,255,'SCHL-254',254,'SCHL','SCHL-254',254,'3','/2/4','/1000/2000','2024-09-17','Cash','5993',0,0,3000,3000,1,'adminFees304',NULL),
(255,35,'SCHL-255',255,'SCHL','SCHL-255',255,'1','/1','/2000','2024-09-17','Cash','5994',0,0,2000,2000,1,'adminFees304',NULL),
(256,199,'SCHL-256',256,'SCHL','SCHL-256',256,'2','/2/3','/1000/3000','2024-09-17','Cash','5995',0,0,4000,4000,1,'adminFees304',NULL),
(257,63,'SCHL-257',257,'SCHL','SCHL-257',257,'1','/1','/500','2024-09-18','Cash','5996',0,0,500,500,1,'adminFees304',NULL),
(258,223,'SCHL-258',258,'SCHL','SCHL-258',258,'3','/2/4','/1000/3000','2024-09-18','Cash','5997',0,0,4000,4000,1,'adminFees304',NULL),
(259,191,'SCHL-259',259,'SCHL','SCHL-259',259,'2','/2/3','/1000/3000','2024-09-18','Cash','5998',0,0,4000,4000,1,'adminFees304',NULL),
(260,259,'SCHL-260',260,'SCHL','SCHL-260',260,'3','/2/4','/1000/2000','2024-09-18','Cash','5999',0,0,3000,3000,1,'adminFees304',NULL),
(261,205,'SCHL-261',261,'SCHL','SCHL-261',261,'2','/3','/2000','2024-09-19','Cash','6000',0,0,2000,2000,1,'adminFees304',NULL),
(262,103,'SCHL-262',262,'SCHL','SCHL-262',262,'2','/3','/3000','2024-09-19','Cash','6001',0,0,3000,3000,1,'adminFees304',NULL),
(263,153,'SCHL-263',263,'SCHL','SCHL-263',263,'2','/2/3','/1000/2000','2024-09-21','Cash','6002',0,0,3000,3000,1,'adminFees304',NULL),
(264,7,'SCHL-264',264,'SCHL','SCHL-264',264,'1','/1','/2000','2024-09-21','Cash','6003',0,0,2000,2000,1,'adminFees304',NULL),
(265,143,'SCHL-265',265,'SCHL','SCHL-265',265,'2','/3','/2000','2024-09-21','Cash','6004',0,0,2000,2000,1,'adminFees304',NULL),
(266,41,'SCHL-266',266,'SCHL','SCHL-266',266,'1','/1','/500','2024-09-21','Cash','6005',0,0,500,500,1,'adminFees304',NULL),
(267,102,'SCHL-267',267,'SCHL','SCHL-267',267,'2','/3','/1000','2024-09-21','Cash','6006',0,0,1000,1000,1,'adminFees304',NULL),
(268,116,'SCHL-268',268,'SCHL','SCHL-268',268,'2','/3','/1000','2024-09-21','Cash','6007',0,0,1000,1000,1,'adminFees304',NULL),
(269,127,'SCHL-269',269,'SCHL','SCHL-269',269,'2','/3','/1000','2024-09-21','Cash','6008',0,0,1000,1000,1,'adminFees304',NULL),
(270,161,'SCHL-270',270,'SCHL','SCHL-270',270,'2','/3','/1000','2024-09-21','Cash','6009',0,0,1000,1000,1,'adminFees304',NULL),
(271,178,'SCHL-271',271,'SCHL','SCHL-271',271,'2','/3','/500','2024-09-21','Cash','6010',0,0,500,500,1,'adminFees304',NULL),
(272,165,'SCHL-272',272,'SCHL','SCHL-272',272,'2','/3','/1000','2024-09-21','Cash','6011',0,0,1000,1000,1,'adminFees304',NULL),
(273,160,'SCHL-273',273,'SCHL','SCHL-273',273,'2','/2/3','/1000/500','2024-09-21','Cash','6012',0,0,1500,1500,1,'adminFees304',NULL),
(274,169,'SCHL-274',274,'SCHL','SCHL-274',274,'2','/3','/2000','2024-09-21','Cash','6013',0,0,2000,2000,1,'adminFees304',NULL),
(275,105,'SCHL-275',275,'SCHL','SCHL-275',275,'2','/3','/1000','2024-09-21','Cash','6014',0,0,1000,1000,1,'adminFees304',NULL),
(276,126,'SCHL-276',276,'SCHL','SCHL-276',276,'2','/3','/1000','2024-09-21','Cash','6015',0,0,1000,1000,1,'adminFees304',NULL),
(277,133,'SCHL-277',277,'SCHL','SCHL-277',277,'2','/3','/1000','2024-09-21','Cash','6016',0,0,1000,1000,1,'adminFees304',NULL),
(278,113,'SCHL-278',278,'SCHL','SCHL-278',278,'2','/3','/2000','2024-09-21','Cash','6017',0,0,2000,2000,1,'adminFees304',NULL),
(279,182,'SCHL-279',279,'SCHL','SCHL-279',279,'2','/2/3','/1000/2000','2024-09-21','Cash','6018',0,0,3000,3000,1,'adminFees304',NULL),
(280,136,'SCHL-280',280,'SCHL','SCHL-280',280,'2','/2/3','/1000/2500','2024-09-21','Cash','6019',0,0,3500,3500,1,'adminFees304',NULL),
(281,171,'SCHL-281',281,'SCHL','SCHL-281',281,'2','/2/3','/1000/2000','2024-09-21','Cash','6020',0,0,3000,3000,1,'adminFees304',NULL),
(282,112,'SCHL-282',282,'SCHL','SCHL-282',282,'2','/2/3','/1000/2000','2024-09-21','Cash','6021',0,0,3000,3000,1,'adminFees304',NULL),
(283,140,'SCHL-283',283,'SCHL','SCHL-283',283,'2','/3','/2000','2024-09-21','Cash','6022',0,0,2000,2000,1,'adminFees304',NULL),
(284,121,'SCHL-284',284,'SCHL','SCHL-284',284,'2','/3','/1000','2024-09-21','Cash','6023',0,0,1000,1000,1,'adminFees304',NULL),
(285,137,'SCHL-285',285,'SCHL','SCHL-285',285,'2','/3','/1000','2024-09-21','Cash','6024',0,0,1000,1000,1,'adminFees304',NULL),
(286,195,'SCHL-286',286,'SCHL','SCHL-286',286,'2','/3','/1000','2024-09-21','Cash','6025',0,0,1000,1000,1,'adminFees304',NULL),
(287,196,'SCHL-287',287,'SCHL','SCHL-287',287,'2','/3','/1000','2024-09-21','Cash','6026',0,0,1000,1000,1,'adminFees304',NULL),
(288,201,'SCHL-288',288,'SCHL','SCHL-288',288,'2','/3','/2000','2024-09-21','Cash','6027',0,0,2000,2000,1,'adminFees304',NULL),
(289,177,'SCHL-289',289,'SCHL','SCHL-289',289,'2','/3','/2000','2024-09-21','Cash','6028',0,0,2000,2000,1,'adminFees304',NULL),
(290,203,'SCHL-290',290,'SCHL','SCHL-290',290,'2','/2/3','/1000/1000','2024-09-21','Cash','6029',0,0,2000,2000,1,'adminFees304',NULL),
(291,192,'SCHL-291',291,'SCHL','SCHL-291',291,'2','/2/3','/1000/2000','2024-09-21','Cash','6030',0,0,3000,3000,1,'adminFees304',NULL),
(292,152,'SCHL-292',292,'SCHL','SCHL-292',292,'2','/3','/500','2024-09-21','Cash','6031',0,0,500,500,1,'adminFees304',NULL),
(293,8,'SCHL-293',293,'SCHL','SCHL-293',293,'1','/1','/500','2024-09-21','Cash','6032',0,0,500,500,1,'adminFees304',NULL),
(294,95,'SCHL-294',294,'SCHL','SCHL-294',294,'1','/1','/500','2024-09-21','Cash','6033',0,0,500,500,1,'adminFees304',NULL),
(295,288,'SCHL-295',295,'SCHL','SCHL-295',295,'3','/4','/3000','2024-09-21','Cash','6034',0,0,3000,3000,1,'adminFees304',NULL),
(296,75,'SCHL-296',296,'SCHL','SCHL-296',296,'1','/1','/2000','2024-09-21','Cash','6035',0,0,2000,2000,1,'adminFees304',NULL),
(297,219,'SCHL-297',297,'SCHL','SCHL-297',297,'3','/2/4','/1000/2000','2024-09-21','Cash','6036',0,0,3000,3000,1,'adminFees304',NULL),
(298,307,'SCHL-298',298,'SCHL','SCHL-298',298,'3','/2/4','/1000/3000','2024-09-21','Cash','6037',0,0,4000,4000,1,'adminFees304',NULL),
(299,298,'SCHL-299',299,'SCHL','SCHL-299',299,'3','/2/4','/1000/3000','2024-09-21','Cash','6038',0,0,4000,4000,1,'adminFees304',NULL),
(300,173,'SCHL-300',300,'SCHL','SCHL-300',300,'2','/2/3','/1000/3000','2024-09-21','Cash','6039',0,0,4000,4000,1,'adminFees304',NULL),
(301,156,'SCHL-301',301,'SCHL','SCHL-301',301,'2','/3','/1000','2024-09-21','Cash','6040',0,0,1000,1000,1,'adminFees304',NULL),
(302,64,'SCHL-302',302,'SCHL','SCHL-302',302,'1','/1','/2000','2024-09-23','Cash','6041',0,0,2000,2000,1,'adminFees304',NULL),
(303,283,'SCHL-303',303,'SCHL','SCHL-303',303,'3','/4','/3000','2024-09-23','Cash','6042',0,0,3000,3000,1,'adminFees304',NULL),
(304,273,'SCHL-304',304,'SCHL','SCHL-304',304,'3','/4','/1000','2024-09-23','Cash','6043',0,0,1000,1000,1,'adminFees304',NULL),
(305,249,'SCHL-305',305,'SCHL','SCHL-305',305,'3','/4','/1000','2024-09-23','Cash','6044',0,0,1000,1000,1,'adminFees304',NULL),
(306,257,'SCHL-306',306,'SCHL','SCHL-306',306,'3','/4','/1000','2024-09-23','Cash','6045',0,0,1000,1000,1,'adminFees304',NULL),
(307,158,'SCHL-307',307,'SCHL','SCHL-307',307,'2','/3','/1000','2024-09-23','Cash','6046',0,0,1000,1000,1,'adminFees304',NULL),
(308,214,'SCHL-308',308,'SCHL','SCHL-308',308,'3','/4','/2000','2024-09-23','Cash','6047',0,0,2000,2000,1,'adminFees304',NULL),
(309,224,'SCHL-309',309,'SCHL','SCHL-309',309,'3','/4','/2000','2024-09-23','Cash','6048',0,0,2000,2000,1,'adminFees304',NULL),
(310,148,'SCHL-310',310,'SCHL','SCHL-310',310,'2','/3','/1500','2024-09-23','Cash','6049',0,0,1500,1500,1,'adminFees304',NULL),
(311,106,'SCHL-311',311,'SCHL','SCHL-311',311,'2','/3','/1000','2024-09-23','Cash','6050',0,0,1000,1000,1,'adminFees304',NULL),
(312,193,'SCHL-312',312,'SCHL','SCHL-312',312,'2','/3','/2000','2024-09-23','Cash','6051',0,0,2000,2000,1,'adminFees304',NULL),
(313,107,'SCHL-313',313,'SCHL','SCHL-313',313,'2','/2/3','/1000/3000','2024-09-23','Cash','6052',0,0,4000,4000,1,'adminFees304',NULL),
(314,40,'SCHL-314',314,'SCHL','SCHL-314',314,'1','/1','/1000','2024-09-23','Cash','6053',0,0,1000,1000,1,'adminFees304',NULL),
(315,312,'SCHL-315',315,'SCHL','SCHL-315',315,'3','/4','/1000','2024-09-23','Cash','6054',0,0,1000,1000,1,'adminFees304',NULL),
(316,312,'SCHL-316',316,'SCHL','SCHL-316',316,'3','/4','/2000','2024-09-23','Cash','6055',0,0,2000,2000,1,'adminFees304',NULL),
(317,135,'SCHL-317',317,'SCHL','SCHL-317',317,'2','/3','/1000','2024-09-23','Cash','6056',0,0,1000,1000,1,'adminFees304',NULL),
(318,151,'SCHL-318',318,'SCHL','SCHL-318',318,'2','/3','/1500','2024-09-23','Cash','6057',0,0,1500,1500,1,'adminFees304',NULL),
(319,120,'SCHL-319',319,'SCHL','SCHL-319',319,'2','/3','/2000','2024-09-23','Cash','6058',0,0,2000,2000,1,'adminFees304',NULL),
(320,268,'SCHL-320',320,'SCHL','SCHL-320',320,'3','/2/4','/1000/500','2024-09-23','Cash','6059',0,0,1500,1500,1,'adminFees304',NULL),
(321,260,'SCHL-321',321,'SCHL','SCHL-321',321,'3','/4','/2000','2024-09-23','Cash','6060',0,0,2000,2000,1,'adminFees304',NULL),
(322,261,'SCHL-322',322,'SCHL','SCHL-322',322,'3','/2/4','/1000/1000','2024-09-23','Cash','6061',0,0,2000,2000,1,'adminFees304',NULL),
(323,176,'SCHL-323',323,'SCHL','SCHL-323',323,'2','/2/3','/1000/1000','2024-09-23','Cash','6062',0,0,2000,2000,1,'adminFees304',NULL),
(324,150,'SCHL-324',324,'SCHL','SCHL-324',324,'2','/2/3','/1000/2000','2024-09-23','Cash','6063',0,0,3000,3000,1,'adminFees304',NULL),
(325,183,'SCHL-325',325,'SCHL','SCHL-325',325,'2','/2/3','/1000/000','2024-09-23','Cash','6064',0,0,1000,1000,1,'adminFees304',NULL),
(326,281,'SCHL-326',326,'SCHL','SCHL-326',326,'3','/4','/1000','2024-09-23','Cash','6065',0,0,1000,1000,1,'adminFees304',NULL),
(327,299,'SCHL-327',327,'SCHL','SCHL-327',327,'3','/4','/1000','2024-09-23','Cash','6066',0,0,1000,1000,1,'adminFees304',NULL),
(328,305,'SCHL-328',328,'SCHL','SCHL-328',328,'3','/4','/2000','2024-09-23','Cash','6067',0,0,2000,2000,1,'adminFees304',NULL),
(329,253,'SCHL-329',329,'SCHL','SCHL-329',329,'3','/2/4','/1000/3000','2024-09-23','Cash','6068',0,0,4000,4000,1,'adminFees304',NULL),
(330,166,'SCHL-330',330,'SCHL','SCHL-330',330,'2','/3','/1000','2024-09-23','Cash','6069',0,0,1000,1000,1,'adminFees304',NULL),
(331,236,'SCHL-331',331,'SCHL','SCHL-331',331,'3','/4','/2000','2024-09-23','Cash','6070',0,0,2000,2000,1,'adminFees304',NULL),
(332,188,'SCHL-332',332,'SCHL','SCHL-332',332,'2','/3','/1000','2024-09-23','Cash','6071',0,0,1000,1000,1,'adminFees304',NULL),
(333,124,'SCHL-333',333,'SCHL','SCHL-333',333,'2','/3','/1500','2024-09-23','Cash','6073',0,0,1500,1500,1,'adminFees304',NULL),
(334,172,'SCHL-334',334,'SCHL','SCHL-334',334,'2','/3','/1000','2024-09-23','Cash','6072',0,0,1000,1000,1,'adminFees304',NULL),
(335,230,'SCHL-335',335,'SCHL','SCHL-335',335,'3','/4','/2000','2024-09-23','Cash','6074',0,0,2000,2000,1,'adminFees304',NULL),
(336,204,'SCHL-336',336,'SCHL','SCHL-336',336,'2','/3','/1500','2024-09-23','Cash','6075',0,0,1500,1500,1,'adminFees304',NULL),
(337,115,'SCHL-337',337,'SCHL','SCHL-337',337,'2','/3','/2000','2024-09-23','Cash','6076',0,0,2000,2000,1,'adminFees304',NULL),
(338,317,'SCHL-338',338,'SCHL','SCHL-338',338,'3','/4','/2000','2024-09-23','Cash','6077',0,0,2000,2000,1,'adminFees304',NULL),
(339,246,'SCHL-339',339,'SCHL','SCHL-339',339,'3','/4','/2000','2024-09-23','Cash','6078',0,0,2000,2000,1,'adminFees304',NULL),
(340,132,'SCHL-340',340,'SCHL','SCHL-340',340,'2','/2/3','/1000/3000','2024-09-23','Cash','6079',0,0,4000,4000,1,'adminFees304',NULL),
(341,163,'SCHL-341',341,'SCHL','SCHL-341',341,'2','/2/3','/1000/2000','2024-09-23','Cash','6080',0,0,3000,3000,1,'adminFees304',NULL),
(342,85,'SCHL-342',342,'SCHL','SCHL-342',342,'1','/1','/1000','2024-09-23','Cash','6081',0,0,1000,1000,1,'adminFees304',NULL),
(343,263,'SCHL-343',343,'SCHL','SCHL-343',343,'3','/2/4','/1000/1000','2024-09-23','Cash','6082',0,0,2000,2000,1,'adminFees304',NULL),
(344,280,'SCHL-344',344,'SCHL','SCHL-344',344,'3','/2/4','/1000/2000','2024-09-23','Cash','6083',0,0,3000,3000,1,'adminFees304',NULL),
(345,111,'SCHL-345',345,'SCHL','SCHL-345',345,'2','/2/3','/1000/1000','2024-09-24','Cash','6084',0,0,2000,2000,1,'adminFees304',NULL),
(346,316,'SCHL-346',346,'SCHL','SCHL-346',346,'3','/4','/1500','2024-09-24','Cash','6085',0,0,1500,1500,1,'adminFees304',NULL),
(347,256,'SCHL-347',347,'SCHL','SCHL-347',347,'3','/2/4','/1000/2500','2024-09-24','Cash','6086',0,0,3500,3500,1,'adminFees304',NULL),
(348,207,'SCHL-348',348,'SCHL','SCHL-348',348,'2','/3','/2000','2024-09-24','Cash','6087',0,0,2000,2000,1,'adminFees304',NULL),
(349,6,'SCHL-349',349,'SCHL','SCHL-349',349,'1','/1','/2000','2024-09-24','Cash','6088',0,0,2000,2000,1,'adminFees304',NULL),
(350,233,'SCHL-350',350,'SCHL','SCHL-350',350,'3','/4','/2000','2024-09-24','Cash','6089',0,0,2000,2000,1,'adminFees304',NULL),
(351,123,'SCHL-351',351,'SCHL','SCHL-351',351,'2','/2/3','/1000/2000','2024-09-24','Cash','6090',0,0,3000,3000,1,'adminFees304',NULL),
(352,271,'SCHL-352',352,'SCHL','SCHL-352',352,'3','/4','/2000','2024-09-24','Cash','6091',0,0,2000,2000,1,'adminFees304',NULL),
(353,284,'SCHL-353',353,'SCHL','SCHL-353',353,'3','/4','/3000','2024-09-25','Cash','6092',0,0,3000,3000,1,'adminFees304',NULL),
(354,302,'SCHL-354',354,'SCHL','SCHL-354',354,'3','/4','/2000','2024-09-25','Cash','6094',0,0,2000,2000,1,'adminFees304',NULL),
(355,251,'SCHL-355',355,'SCHL','SCHL-355',355,'3','/2/4','/1000/2000','2024-09-25','Cash','6095',0,0,3000,3000,1,'adminFees304',NULL),
(356,314,'SCHL-356',356,'SCHL','SCHL-356',356,'3','/4','/2000','2024-09-25','Cash','6096',0,0,2000,2000,1,'adminFees304',NULL),
(357,240,'SCHL-357',357,'SCHL','SCHL-357',357,'3','/4','/1000','2024-09-25','Cash','6097',0,0,1000,1000,1,'adminFees304',NULL),
(358,220,'SCHL-358',358,'SCHL','SCHL-358',358,'3','/4','/1000','2024-09-25','Cash','6098',0,0,1000,1000,1,'adminFees304',NULL),
(359,234,'SCHL-359',359,'SCHL','SCHL-359',359,'3','/4','/2000','2024-09-25','Cash','6099',0,0,2000,2000,1,'adminFees304',NULL),
(360,297,'SCHL-360',360,'SCHL','SCHL-360',360,'3','/2/4','/1000/3000','2024-09-25','Cash','6100',0,0,4000,4000,1,'adminFees304',NULL),
(361,222,'SCHL-361',361,'SCHL','SCHL-361',361,'3','/2/4','/1000/2000','2024-09-26','Cash','6101',0,0,3000,3000,1,'adminFees304',NULL),
(362,282,'SCHL-362',362,'SCHL','SCHL-362',362,'3','/2/4','/1000/1000','2024-09-26','Cash','6102',0,0,2000,2000,1,'adminFees304',NULL),
(363,226,'SCHL-363',363,'SCHL','SCHL-363',363,'3','/2/4','/1000/4000','2024-09-26','Cash','6103',0,0,5000,5000,1,'adminFees304',NULL),
(364,296,'SCHL-364',364,'SCHL','SCHL-364',364,'3','/2/4','/1000/2000','2024-09-26','Cash','6104',0,0,3000,3000,1,'adminFees304',NULL),
(365,231,'SCHL-365',365,'SCHL','SCHL-365',365,'3','/2/4','/1000/1000','2024-09-26','Cash','6105',0,0,2000,2000,1,'adminFees304',NULL),
(366,160,'SCHL-366',366,'SCHL','SCHL-366',366,'2','/3','/1000','2024-09-26','Cash','6106',0,0,1000,1000,1,'adminFees304',NULL),
(367,294,'SCHL-367',367,'SCHL','SCHL-367',367,'3','/2/4','/1000/1000','2024-09-26','Cash','6107',0,0,2000,2000,1,'adminFees304',NULL),
(368,63,'SCHL-368',368,'SCHL','SCHL-368',368,'1','/1','/1000','2024-09-26','Cash','6108',0,0,1000,1000,1,'adminFees304',NULL),
(369,154,'SCHL-369',369,'SCHL','SCHL-369',369,'2','/2/3','/1000/4000','2024-09-26','Cash','6109',0,0,5000,5000,1,'adminFees304',NULL),
(370,285,'SCHL-370',370,'SCHL','SCHL-370',370,'3','/2/4','/1000/4000','2024-09-26','Cash','6110',0,0,5000,5000,1,'adminFees304',NULL),
(371,290,'SCHL-371',371,'SCHL','SCHL-371',371,'3','/4','/1000','2024-09-27','Cash','6111',0,0,1000,1000,1,'adminFees304',NULL),
(387,287,'SCHL-387',387,'SCHL','SCHL-387',387,'3','/2/4','/1000/2000','2024-09-27','Cash','6112',0,0,3000,3000,1,'adminFees304',NULL),
(373,228,'SCHL-373',373,'SCHL','SCHL-373',373,'3','/2/4','/1000/2000','2024-09-27','Cash','6113',0,0,3000,3000,1,'adminFees304',NULL),
(374,258,'SCHL-374',374,'SCHL','SCHL-374',374,'3','/2/4','/1000/2000','2024-09-27','Cash','6114',0,0,3000,3000,1,'adminFees304',NULL),
(375,267,'SCHL-375',375,'SCHL','SCHL-375',375,'3','/4','/1000','2024-09-27','Cash','6115',0,0,1000,1000,1,'adminFees304',NULL),
(376,274,'SCHL-376',376,'SCHL','SCHL-376',376,'3','/2/4','/1000/000','2024-09-28','Cash','6117',0,0,1000,1000,1,'adminFees304',NULL),
(377,292,'SCHL-377',377,'SCHL','SCHL-377',377,'3','/2/4','/1000/7000','2024-09-28','Cash','6118',0,0,8000,8000,1,'adminFees304',NULL),
(378,164,'SCHL-378',378,'SCHL','SCHL-378',378,'2','/2/3','/1000/2500','2024-09-30','Cash','6119',0,0,3500,3500,1,'adminFees304',NULL),
(379,263,'SCHL-379',379,'SCHL','SCHL-379',379,'3','/4','/1000','2024-09-30','Cash','6120',0,0,1000,1000,1,'adminFees304',NULL),
(380,68,'SCHL-380',380,'SCHL','SCHL-380',380,'1','/1','/2500','2024-11-04','Cash','6121',0,0,2500,2500,1,'adminFees304',NULL),
(381,263,'SCHL-381',381,'SCHL','SCHL-381',381,'3','/4','/3000','2024-11-12','Cash','6122',0,0,3000,3000,1,'adminFees304',NULL),
(382,268,'SCHL-382',382,'SCHL','SCHL-382',382,'3','/4','/1000','2024-11-12','Cash','6123',0,0,1000,1000,1,'adminFees304',NULL),
(383,315,'SCHL-383',383,'SCHL','SCHL-383',383,'3','/2/4','/1000/4000','2024-11-13','Cash','6124',0,0,5000,5000,1,'adminFees304',NULL),
(384,95,'SCHL-384',384,'SCHL','SCHL-384',384,'1','/1','/500','2024-11-19','Cash','6125',0,0,500,500,1,'adminFees304',NULL),
(385,42,'SCHL-385',385,'SCHL','SCHL-385',385,'1','/1','/1000','2024-11-22','Cash','6126',0,0,1000,1000,1,'adminFees304',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
(1,1,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1/2','/500/1000','2024-09-02','Cash','5737',0,0,1500,1500,1,'adminFees304','2024-09-17 06:14 48'),
(184,306,'SCHL-184',184,'SCHL','SCHL-184',184,'3','/2/4','/1000/6000','2024-07-16','Cash','5924',0,0,7000,7000,1,'adminFees304','2024-10-29 05:52 13'),
(189,269,'SCHL-189',189,'SCHL','SCHL-189',189,'3','/4','/2000','2024-07-18','Cash','5928',0,0,2000,2000,1,'adminFees304','2024-10-29 09:06 26'),
(166,269,'SCHL-166',166,'SCHL','SCHL-166',166,'3','/2/4','/1000/1000','2024-07-09','Cash','5904',0,0,2000,2000,1,'adminFees304','2024-10-29 09:07 21'),
(135,216,'SCHL-135',135,'SCHL','SCHL-135',135,'3','/2/4','/1000/7000','2024-06-28','Cash','5873',0,0,8000,8000,1,'adminFees304','2025-02-17 10:10 06'),
(372,287,'SCHL-372',372,'SCHL','SCHL-372',372,'3','/2/4','/1000/4000','2024-09-27','Cash','6112',0,0,5000,5000,1,'adminFees304','2025-02-18 10:21 28');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL 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,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=318 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
('K SRIKANTHA S/O K MALLIKARJUNA',3,'','8TH ','A','1',0,'',NULL,0,NULL),
('A SANGEETHA D/O TIRUMALESH',4,'','8TH ','A','2',0,'',NULL,0,NULL),
('AJAY KUMAR S/O BHIMANNA',5,'','8th ','A','3',0,'',NULL,0,NULL),
('AKSHAYA D/O MANJUNATHA',6,'','8th ','A','4',0,'',NULL,0,NULL),
('AKSHAYA D/O OBALESHA',7,'','8th ','A','5',0,'',NULL,0,NULL),
('B AKASHA S/O B SURESH',8,'','8th ','A','6',0,'',NULL,0,NULL),
('B BASAVARAJA S/O B PRAKASH ',9,'','8th ','A','7',0,'',NULL,0,NULL),
('B LAKSHMI D/O B RAMESH',10,'','8th ','A','8',0,'',NULL,0,NULL),
('B MUNSIRA D/O BASHA SAB',11,'','8th ','A','9',0,'',NULL,0,NULL),
('B PRUTHVI S/O B NAGARAJA',12,'','8th ','A','10',0,'',NULL,0,NULL),
('B VIKAS S/O B SOMASHEKHAR',13,'','8th ','A','11',0,'',NULL,0,NULL),
('BHARATH S/O RAGHU',14,'','8th ','A','12',0,'',NULL,0,NULL),
('BHAVITHA D/O NAGARAJA',15,'','8th ','A','13',0,'',NULL,0,NULL),
('C NAGALAKSHMI D/O C SATYANARAYANA',16,'','8th ','A','14',0,'',NULL,0,NULL),
('C SAI PRIYA D/O RAGHAVENDRA',17,'','8th ','A','15',0,'',NULL,0,NULL),
('CHAITRA N D/O ANJINI N',18,'','8th ','A','16',0,'',NULL,0,NULL),
('D NIKHIL CHANDRA S/O SUBHASH CHANDRA',19,'','8th ','A','17',0,'',NULL,0,NULL),
('E SOMANATHA S/O E HULUGAPPA',20,'','8th ','A','18',0,'',NULL,0,NULL),
('ERANNA BARAKER S/O SHIVANANDA BARAKER',21,'','8th ','A','19',0,'',NULL,0,NULL),
('G B VITTAL KUMAR S/O G S BASAVANA GOUDA ',22,'','8th ','A','20',0,'',NULL,0,NULL),
('G HULESHA S/O G RAGHAVENDFRA',23,'','8th ','A','21',0,'',NULL,0,NULL),
('G K JEEVAN S/O KRISHNA',24,'','8th ','A','22',0,'',NULL,0,NULL),
('G MANOJ S/O G MANJUNATHA ',25,'','8th ','A','23',0,'',NULL,0,NULL),
('G NAYANA D/O G MANJUNATHA',26,'','8th ','A','24',0,'',NULL,0,NULL),
('G PRATAP S/O G URUKUNDI',27,'','8th ','A','25',0,'',NULL,0,NULL),
('G SINDHU D/O G SHIVAKUMAR',28,'','8th ','A','26',0,'',NULL,0,NULL),
('GOUTAM S/O RAMESH',29,'','8th ','A','27',0,'',NULL,0,NULL),
('GURU S/O YALLAPPA',30,'','8th ','A','28',0,'',NULL,0,NULL),
('H M DEVIKA D/O H M BASAVARAJ',31,'','8th ','A','29',0,'',NULL,0,NULL),
('HANUMESHA S/O YANKOBI',32,'','8th ','A','30',0,'',NULL,0,NULL),
('HEMANTH S/O CHANNAYYA',33,'','8th ','A','31',0,'',NULL,0,NULL),
('JEERU VISHNU S/O JEER MANJULA',34,'','8th ','A','32',0,'',NULL,0,NULL),
('K ARSHIYABANU D/O K MEHABOOB BASHA',35,'','8th ','A','33',0,'',NULL,0,NULL),
('K GURUPAMPAPATHI S/O K ASHOK',36,'','8th ','A','34',0,'',NULL,0,NULL),
('K NANDITA D/O K DURUGAPPA',37,'','8th ','A','35',0,'',NULL,0,NULL),
('K NARASIMHA S/O K VEERESH',38,'','8th ','A','36',0,'',NULL,0,NULL),
('K NAYANA D/O K JADESH',39,'','8th ','A','37',0,'',NULL,0,NULL),
('K PRIYANKA D/O K THIMMAYYA',40,'','8th ','A','38',0,'',NULL,0,NULL),
('K RAJA S/O K SAKRAPPA',41,'','8th ','A','39',0,'',NULL,0,NULL),
('K SAMREEN D/O K RIHAN BASHA',42,'','8th ','A','40',0,'',NULL,0,NULL),
('K USHA D/O K BASAVARAJA',43,'','8th ','A','41',0,'',NULL,0,NULL),
('KAMBATHU SAHANA D/O KAMBATHU VENKATESHA',44,'','8th ','A','42',0,'',NULL,0,NULL),
('KANAKARAYA S/O HANUMANTHA',45,'','8th ','A','43',0,'',NULL,0,NULL),
('KARTHIK S/O ADIVEPPA',46,'','8th ','A','44',0,'',NULL,0,NULL),
('KARTHIK H S/O H VEERESHAPPA',47,'','8th ','A','45',0,'',NULL,0,NULL),
('KAVERI D/O MAHESH',48,'','8th ','A','46',0,'',NULL,0,NULL),
('M AFRID S/O M HUSENSAB',49,'','8th ','A','47',0,'',NULL,0,NULL),
('M C THANUJ S/O M C PARASHURAM',50,'','8th ','A','48',0,'',NULL,0,NULL),
('M CHOUDESHWARI D/O SHIVAKRISHNA M',51,'','8th ','A','49',0,'',NULL,0,NULL),
('M GANESHA S/O M SHANKARA',52,'','8th ','A','50',0,'',NULL,0,NULL),
('M MAHESHWARI D/O VENKATA KONDAYYA M',53,'','8th ','A','51',0,'',NULL,0,NULL),
('M MANJUNATHA S/O SANNA MARENNA M',54,'','8th ','A','52',0,'',NULL,0,NULL),
('M SIDDALINGA S/O MUKAPPA',55,'','8th ','A','53',0,'',NULL,0,NULL),
('MANOJ S/O VEERSH H',56,'','8th ','A','54',0,'',NULL,0,NULL),
('MOHAMMAD TAHIR S/O CHAND BASHA',57,'','8th ','A','55',0,'',NULL,0,NULL),
('MOHAMMED FAYAZ S/O KHADAR ',58,'','8th ','A','56',0,'',NULL,0,NULL),
('MOHAMMED RASOOL S/O MEHABOOB BASHA',59,'','8th ','A','57',0,'',NULL,0,NULL),
('MOUNIKA H D/O GANGADHARA H',60,'','8th ','A','58',0,'',NULL,0,NULL),
('N CHANDU S/O RANGASWAMY',61,'','8th ','A','59',0,'',NULL,0,NULL),
('N SANTOSH S/O NAGENDRA',62,'','8th ','A','60',0,'',NULL,0,NULL),
('NOOR JAA D/O SHEKSHAVALI',63,'','8th ','A','61',0,'',NULL,0,NULL),
('P ABDUL NABI S/O P SUBAN',64,'','8th ','A','62',0,'',NULL,0,NULL),
('PRADEEP S/O SRINIVASA',65,'','8th ','A','63',0,'',NULL,0,NULL),
('PRAJWAL S/O HANUMANTHA',66,'','8th ','A','64',0,'',NULL,0,NULL),
('PRASAD KUMAR S/O SARASWATHI',67,'','8th ','A','65',0,'',NULL,0,NULL),
('PREMANATH D S/O D JAMBAYYA',68,'','8th ','A','66',0,'',NULL,0,NULL),
('R MARUTHI S/O R ERANNA',69,'','8th ','A','67',0,'',NULL,0,NULL),
('RADHA D/O THIMMAYYA',70,'','8th ','A','68',0,'',NULL,0,NULL),
('RENUKA D/O VIRUPAMMA',71,'','8th ','A','69',0,'',NULL,0,NULL),
('ROJA D/O NAGARAJA',72,'','8th ','A','70',0,'',NULL,0,NULL),
('S N AKUL S/O C NAGABHUSHANA',73,'','8th ','A','71',0,'',NULL,0,NULL),
('SACHIN S/O GURURAJA',74,'','8th ','A','72',0,'',NULL,0,NULL),
('SANJANA D/O YERRISWAMI',75,'','8th ','A','73',0,'',NULL,0,NULL),
('SANTHOSH S/O MARESH',76,'','8th ','A','74',0,'',NULL,0,NULL),
('SANTOSH S/O GOVINDA',77,'','8th ','A','75',0,'',NULL,0,NULL),
('SARASWATHI S D/O YALAVAPPA',78,'','8th ','A','76',0,'',NULL,0,NULL),
('SAYYED ABDUL S/O JAMALUDDIN',79,'','8th ','A','77',0,'',NULL,0,NULL),
('SHANTHAMURTHY S/O GADILINGAPPA',80,'','8th ','A','78',0,'',NULL,0,NULL),
('SHASHANK S/O BASAVARAJ',81,'','8th ','A','79',0,'',NULL,0,NULL),
('SHIFA TABASUM D/O U SHAKIR',82,'','8th ','A','80',0,'',NULL,0,NULL),
('SONIYA BANU D/O PATEL SAB',83,'','8th ','A','81',0,'',NULL,0,NULL),
('SUHANA K D/O GOUSE BASHA',84,'','8th ','A','82',0,'',NULL,0,NULL),
('SUJATHA D/O PRAKSHA',85,'','8th ','A','83',0,'',NULL,0,NULL),
('T MALLIKA D/O JAGADEESH T',86,'','8th ','A','84',0,'',NULL,0,NULL),
('T VINAYA KUMAR S/O T GANGADHARA',87,'','8th ','A','85',0,'',NULL,0,NULL),
('U DURGESH S/O U MALLAYYA',88,'','8th ','A','86',0,'',NULL,0,NULL),
('U PAVAN S/O RAGHAVENDRA',89,'','8th ','A','87',0,'',NULL,0,NULL),
('UMADEVI D/O UMESHA',90,'','8th ','A','88',0,'',NULL,0,NULL),
('V KRISHNA S/O MARESHA',91,'','8th ','A','89',0,'',NULL,0,NULL),
('V VENNELA D/O V GOVINDA',92,'','8th ','A','90',0,'',NULL,0,NULL),
('VEENA D/O ANJINAPPA',93,'','8th ','A','91',0,'',NULL,0,NULL),
('VEERESHA M S/O VENKATESHA',94,'','8th ','A','92',0,'',NULL,0,NULL),
('VINAY G S/O PAMPAPATHI G',95,'','8th ','A','93',0,'',NULL,0,NULL),
('YOGESH S/O HUSENAPPA',96,'','8th ','A','94',0,'',NULL,0,NULL),
('SUHANA D/O RAJASAB',99,'','9TH ','A','1',0,'',NULL,0,NULL),
('A SAI CHARAN S/O ANNAPURNA',100,'','9TH ','A','2',0,'','son of aya ( Annapurna ) school staff',0,NULL),
('ABDUL RAZAK S/O REHAMAN BASHA',101,'','9th ','A','3',0,'',NULL,0,NULL),
('ADIL S/O MEHABOOB BASHA',102,'','9th ','A','4',0,'',NULL,0,NULL),
('AHARONU S/O SRINIVAS',103,'','9th ','A','5',0,'',NULL,0,NULL),
('ANGAJALARA MANJUNATHA S/O A RENUKAPPA',104,'','9th ','A','6',0,'',NULL,0,NULL),
('ANITHA D/O YALLAPPA',105,'','9th ','A','7',0,'',NULL,0,NULL),
('ANKITA D/O NARAYANAPPA',106,'','9th ','A','8',0,'',NULL,0,NULL),
('ARCHANA D/O BASAVARAJ',107,'','9th ','A','9',0,'',NULL,0,NULL),
('ASHWINI D/O THIPPANNA SADDALAGI',108,'','9th ','A','10',0,'',NULL,0,NULL),
('ASLAM S/O IMAM SAB',109,'','9th ','A','11',0,'',NULL,0,NULL),
('B CHINMAYI D/O PANDURANGA',110,'','9th ','A','12',0,'',NULL,0,NULL),
('B DILEEP KUMAR S/O PADMAVATHI',111,'','9th ','A','13',0,'',NULL,0,NULL),
('B GOUTHAMI D/O BALLARI NINGAPPA',112,'','9th ','A','14',0,'',NULL,0,NULL),
('B KUSUMA D/O B DURUGAPPA',113,'','9th ','A','15',0,'',NULL,0,NULL),
('B MOHAMMED GOUSE S/O B KHAJAVALI',114,'','9th ','A','16',0,'',NULL,0,NULL),
('B RAMAKUMAR S/O B ANANDA',115,'','9th ','A','17',0,'',NULL,0,NULL),
('B SATHISHA S/O B PARAMESHAPPA',116,'','9th ','A','18',0,'',NULL,0,NULL),
('B VASUNDHARA D/O B SHYAM',117,'','9th ','A','19',0,'',NULL,0,NULL),
('BANNI S/O NINGAPPA',118,'','9th ','A','20',0,'',NULL,0,NULL),
('BASAVA S/O HANUMANTHAPPA',119,'','9th ','A','21',0,'','Comit Concession ',0,NULL),
('BASAVARAJA M S/O YALLAPPA',120,'','9th ','A','22',0,'',NULL,0,NULL),
('BHAVYA BHARATHI D/O NINGANNA',121,'','9th ','A','23',0,'',NULL,0,NULL),
('C BINDU D/O JADESH',122,'','9th ','A','24',0,'',NULL,0,NULL),
('C D SAHANA D/O C D THIMMAYYA',123,'','9th ','A','25',0,'',NULL,0,NULL),
('C K HULIGEMMA D/O K RAMANNA',124,'','9th ','A','26',0,'',NULL,0,NULL),
('C SACHIN S/O C HUCCHAYYA SWAMY',125,'','9th ','A','27',0,'',NULL,0,NULL),
('C SANDHYA D/O C SUNKANNA',126,'','9th ','A','28',0,'',NULL,0,NULL),
('CHANNAPATNA AMEER PHASHA S/O HARSHADULLA',127,'','9th ','A','29',0,'',NULL,0,NULL),
('CHARAN KUMAR S/O RAJA',128,'','9th ','A','30',0,'',NULL,0,NULL),
('CHOUDARI ABDULLA S/O ABDUL GAFUR',129,'','9th ','A','31',0,'',NULL,0,NULL),
('D AJAY D/O D GOPAL',130,'','9th ','A','32',0,'',NULL,0,NULL),
('D AMARANATH S/O SUMNGALA',131,'','9th ','A','33',0,'','son of cook ( Sumangala ) school staff',0,NULL),
('DEVENDRA N N S/O NATARAJA',132,'','9th ','A','34',0,'',NULL,0,NULL),
('ERAMMA D/O VEERESH',133,'','9th ','A','35',0,'',NULL,0,NULL),
('G B VEERANA GOUDA S/O G S BASAVANAGOUDA',134,'','9th ','A','36',0,'',NULL,0,NULL),
('G DODDANAGOUDA S/O G NAGARAJA',135,'','9th ','A','37',0,'',NULL,0,NULL),
('G GANESH S/O G MANJUNATHA',136,'','9th ','A','38',0,'',NULL,0,NULL),
('G SAHANA D/O G RAJA',137,'','9th ','A','39',0,'',NULL,0,NULL),
('GIRISHA C S/O PAMPAPATHI',138,'','9th ','A','40',0,'',NULL,0,NULL),
('H RAHUL S/O SALEEM H',139,'','9th ','A','41',0,'',NULL,0,NULL),
('HADAPADA SHARADA D/O H KUMARASWAMY',140,'','9th ','A','42',0,'',NULL,0,NULL),
('HAMEED S/O SHEKSHAVALI',141,'','9th ','A','43',0,'',NULL,0,NULL),
('HS MUTTHAMMA D/O CHIRANJEEVI',142,'','9th ','A','44',0,'',NULL,0,NULL),
('HULIGAMMA D/O OBALESHA',143,'','9th ','A','45',0,'',NULL,0,NULL),
('K DARSHAN S/O KORI SHARANAPPA',144,'','9th ','A','46',0,'',NULL,0,NULL),
('K M RAKESH S/O K VENKATESH',145,'','9th ','A','47',0,'',NULL,0,NULL),
('K NAGAVENI D/O K NAGARAJA',146,'','9th ','A','48',0,'',NULL,0,NULL),
('K NAMITHA D/O K DODDANAGOUDA',147,'','9th ','A','49',0,'',NULL,0,NULL),
('K PRASHANTHA S/O K RAMALISWAMY',148,'','9th ','A','50',0,'',NULL,0,NULL),
('K PRIYANKA D/O K HOLEYAPPA',149,'','9th ','A','51',0,'',NULL,0,NULL),
('K ROHITH S/O K KUMAR',150,'','9th ','A','52',0,'',NULL,0,NULL),
('K SHANKAR S/O K VEERESH',151,'','9th ','A','53',0,'',NULL,0,NULL),
('K SHEKMEHAK D/O SHEK ABDUL JABEER',152,'','9th ','A','54',0,'',NULL,0,NULL),
('K SREENIVASA S/O K HULUGAPPA',153,'','9th ','A','55',0,'',NULL,0,NULL),
('K SUREKHA D/O K MALLIKARJUNA',154,'','9th ','A','56',0,'',NULL,0,NULL),
('K VARSHINI D/O K VITTOBHA',155,'','9th ','A','57',0,'',NULL,0,NULL),
('KADABUR KAVYA D/O K MANJUNATHA',156,'','9th ','A','58',0,'',NULL,0,NULL),
('KARTHIKA S/O RAVI CHITRAGARA',157,'','9th ','A','59',0,'',NULL,0,NULL),
('KM SWETHA D/O KEDARANATHA',158,'','9th ','A','60',0,'',NULL,0,NULL),
('KUMAR V S/O ',159,'','9th ','A','61',0,'',NULL,0,NULL),
('L YASHVANTHA S/O L BASAVARAJA',160,'','9th ','A','62',0,'',NULL,0,NULL),
('M ABHIJEETH S/O M SOMAPPA',161,'','9th ','A','63',0,'',NULL,0,NULL),
('M MABU SUBHANI S/O SANNA BALESAB',162,'','9th ','A','64',0,'',NULL,0,NULL),
('M SHARATH KUMAR S/O M NAGARAJ',163,'','9th ','A','65',0,'',NULL,0,NULL),
('M SULEMAN S/O M RAFIQ',164,'','9th ','A','66',0,'',NULL,0,NULL),
('MADDI GANESH S/O M CHANDRA',165,'','9th ','A','67',0,'',NULL,0,NULL),
('MADDI MANJUNATH S/O MADDI VEERESHA',166,'','9th ','A','68',0,'',NULL,0,NULL),
('MAHAMADGOUSE S/O BADESAB',167,'','9th ','A','69',0,'',NULL,0,NULL),
('MALADRI CHANDRAPPA',168,'','9th ','A','70',0,'',NULL,0,NULL),
('MAMATHA D/O DODDA ERANNA ',169,'','9th ','A','71',0,'',NULL,0,NULL),
('MANOJ Y S/O Y HULUGAPPA',170,'','9th ','A','72',0,'',NULL,0,NULL),
('MUTTHARAJA S/O HANUMANTHAPPA',171,'','9th ','A','73',0,'',NULL,0,NULL),
('N AKASH S/O BASAVARAJA',172,'','9th ','A','74',0,'',NULL,0,NULL),
('N VINOD S/O SADASHIVA',173,'','9th ','A','75',0,'',NULL,0,NULL),
('ORBAVI RESHMA BEGAM D/O KASIM SAB',174,'','9th ','A','76',0,'',NULL,0,NULL),
('P HEMANTHKUMAR S/O P CHIRANJEEVI',175,'','9th ','A','77',0,'',NULL,0,NULL),
('P MANOJA S/O P SHIVANARAYANA',176,'','9th ','A','78',0,'',NULL,0,NULL),
('PAIROZ D/O YUNIS',177,'','9th ','A','79',0,'',NULL,0,NULL),
('PARVATHI H D/O HULUGAPPA',178,'','9th ','A','80',0,'',NULL,0,NULL),
('PAVITRA M D/O MARESH M',179,'','9th ','A','81',0,'',NULL,0,NULL),
('PRAJVAL S/O UMESH',180,'','9th ','A','82',0,'',NULL,0,NULL),
('PRUTHVI S/O RAJAPPA',181,'','9th ','A','83',0,'',NULL,0,NULL),
('RAGHAVENDRA P S/O GURURAJ P',182,'','9th ','A','84',0,'',NULL,0,NULL),
('RAKESHA S/O YALLAPPA',183,'','9th ','A','85',0,'',NULL,0,NULL),
('RAMAKRISHNA S/O ',184,'','9th ','A','86',0,'',NULL,0,NULL),
('RAMAKRUSHNA GUBAJI S/O PAKKIRAPPA',185,'','9th ','A','87',0,'',NULL,0,NULL),
('SABEER ALI K S/O HONNURAVALI K',186,'','9th ','A','88',0,'',NULL,0,NULL),
('SAHANABAYI D/O MOHAN SINGH',187,'','9th ','A','89',0,'','president sir concession\n',0,NULL),
('SATEESH S/O BASAVARAJA K',188,'','9th ','A','90',0,'',NULL,0,NULL),
('SHABBIR HUSEN S/O ISMAIL',189,'','9th ','A','91',0,'',NULL,0,NULL),
('SHAMBHAVI D/O DODDA SHARANAYYA',190,'','9th ','A','92',0,'',NULL,0,NULL),
('SHEKAR S/O GOVINDA',191,'','9th ','A','93',0,'',NULL,0,NULL),
('SINDHU D/O YERRISWAMY',192,'','9th ','A','94',0,'',NULL,0,NULL),
('SUJATHA D/O RANGAPPA',193,'','9th ','A','95',0,'',NULL,0,NULL),
('SWATHI D/O SRIRAMULU',194,'','9th ','A','96',0,'',NULL,0,NULL),
('U PRAVEENA S/O CHANDRAPPA',195,'','9th ','A','97',0,'',NULL,0,NULL),
('UMMAR FHARUQ S/O AYUB',196,'','9th ','A','98',0,'',NULL,0,NULL),
('V GURURAJA S/O ',197,'','9th ','A','99',0,'',NULL,0,NULL),
('V KRISHNA S/O V GOVINDA',198,'','9th ','A','100',0,'',NULL,0,NULL),
('V MUSKAN D/O KHAJA SAB',199,'','9th ','A','101',0,'',NULL,0,NULL),
('V PURUSHOTHAM S/O YAMANOORI',200,'','9th ','A','102',0,'',NULL,0,NULL),
('V SUKANYA D/O MANJUNATHA',201,'','9th ','A','103',0,'',NULL,0,NULL),
('VAISHANVI D/O GANGANNA',202,'','9th ','A','104',0,'',NULL,0,NULL),
('VASTHALYA D/O PARASHURAM',203,'','9th ','A','105',0,'',NULL,0,NULL),
('VENKATESHA S/O HANUMANTHA',204,'','9th ','A','106',0,'',NULL,0,NULL),
('VIJAYALAKSHMI D/O VEERABHADRA',205,'','9th ','A','107',0,'',NULL,0,NULL),
('VINAYAKA V S/O ANJINAPPA',206,'','9th ','A','108',0,'','Son of Aya (Umadevi ) School staff',0,NULL),
('YESANNA B S/O B DEVARAJA',207,'','9th ','A','109',0,'',NULL,0,NULL),
('YOGESH J S/O RAMESH J',208,'','9th ','A','110',0,'',NULL,0,NULL),
('A VEERESH S/O A NINGAPPA',210,'','10TH ','A','1',0,'',NULL,0,NULL),
('A.KASIM S/O ',211,'','10TH ','A','2',0,'',NULL,0,NULL),
('ABBUBAKAR S/O ALLABHAKSHI',212,'','10th ','A','3',0,'',NULL,0,NULL),
('AKHIL KHAN S/O IRFAN KHAN',213,'','10th ','A','4',0,'',NULL,0,NULL),
('ANJAYYA S/O MAREPPA',214,'','10th ','A','5',0,'',NULL,0,NULL),
('ASHA T D/O YUVARAJ',215,'','10th ','A','6',0,'',NULL,0,NULL),
('AYYODHI DHARSHAN S/O SANNA JADEPPA',216,'','10th ','A','7',0,'',NULL,0,NULL),
('B KARTIK S/O B ANJINAPPA',217,'','10th ','A','8',0,'',NULL,0,NULL),
('B SOUMYA D/O B SRINIVASA',218,'','10th ','A','9',0,'',NULL,0,NULL),
('B.ARATI D/O B SURESH',219,'','10th ','A','10',0,'',NULL,0,NULL),
('B.GOUTHAM S/O B SOMSHEKHAR',220,'','10th ','A','11',0,'',NULL,0,NULL),
('B.PRASHANTH S/O B SRINIVAS',221,'','10th ','A','12',0,'',NULL,0,NULL),
('BOVI.ERAMMA D/O BOVI PAMPAPATHI',222,'','10th ','A','13',0,'',NULL,0,NULL),
('C AISHWARYA D/O PAMANNA C',223,'','10th ','A','14',0,'',NULL,0,NULL),
('C RAJASHEKARA S/O YALLAMMA',224,'','10th ','A','15',0,'',NULL,0,NULL),
('C.AMRUTHA D/O MOULAPPA',225,'','10th ','A','16',0,'',NULL,0,NULL),
('C.D.BHAGYALAKSHMI D NALLAREDDY',226,'','10th ','A','17',0,'',NULL,0,NULL),
('C.RAJESHA S/O C VIRUPANNA',227,'','10th ','A','18',0,'',NULL,0,NULL),
('C.SHUSHMA D/O CHALUVADI JADEPPA',228,'','10th ','A','19',0,'',NULL,0,NULL),
('D.GOUTAM S/O D BALARAJU',229,'','10th ','A','20',0,'',NULL,0,NULL),
('D.PALLAVI D/O DURGAPRASAD',230,'','10th ','A','21',0,'',NULL,0,NULL),
('DEVARAJA S/O H THIMMAPPA',231,'','10th ','A','22',0,'',NULL,0,NULL),
('FAIROJA D/O RAFIQ',232,'','10th ','A','23',0,'',NULL,0,NULL),
('G K ADITHYA S/O VEERABHADRAPPA G K',233,'','10th ','A','24',0,'',NULL,0,NULL),
('G. NAVEENA S/O G VIRUPAKSHI',234,'','10th ','A','25',0,'',NULL,0,NULL),
('G.K.PAVITHRA D/O G K VIRUPAKSHI',235,'','10th ','A','26',0,'',NULL,0,NULL),
('G.LAKSHMI D/O G MALLIKARJUNA',236,'','10th ','A','27',0,'',NULL,0,NULL),
('G.MANOJ S/O G JADEPPA',237,'','10th ','A','28',0,'',NULL,0,NULL),
('G.NANDANA S/O J MADHUSUDHANA',238,'','10th ','A','29',0,'',NULL,0,NULL),
('G.PANDURANGA S/O G VIRUPAKSHI',239,'','10th ','A','30',0,'',NULL,0,NULL),
('G.POOJA D/O G LINGAPPA',240,'','10th ','A','31',0,'',NULL,0,NULL),
('G.RADIKA D/O G DHANUNJAYA',241,'','10th ','A','32',0,'',NULL,0,NULL),
('G.VINEETA D/O G MAHADEVAPPA',242,'','10th ','A','33',0,'',NULL,0,NULL),
('GAULI. SANJAY KUMAR S/O GOULI RAMAPPA',243,'','10th ','A','34',0,'',NULL,0,NULL),
('H M AMRUTHA D/O BASAVARAJA',244,'','10th ','A','35',0,'',NULL,0,NULL),
('H VEERESH S/O',245,'','10th ','A','36',0,'',NULL,0,NULL),
('H.MONIKA D/O NAGENDRA',246,'','10th ','A','37',0,'',NULL,0,NULL),
('H.S.NITIN S/O CHIRANJEEVI',247,'','10th ','A','38',0,'',NULL,0,NULL),
('HUSAINBASHA.P S/O MARDAN SAB',248,'','10th ','A','39',0,'',NULL,0,NULL),
('ISHWARYA D/O MALLIKARJUNA',249,'','10th ','A','40',0,'',NULL,0,NULL),
('J PAVAN S/O J RAJASHEKHAR',250,'','10th ','A','41',0,'',NULL,0,NULL),
('J V MANJUNATHA S/O J V VEERESH ',251,'','10th ','A','42',0,'',NULL,0,NULL),
('JANARDHANA S/O VEERESH',252,'','10th ','A','43',0,'',NULL,0,NULL),
('K G VEERESHA S/O K G GANESH',253,'','10th ','A','44',0,'',NULL,0,NULL),
('K JAGADISHA S/O K DURUGAPPA',254,'','10th ','A','45',0,'',NULL,0,NULL),
('K SANIYA BEGUM D/O MEHABOOB BASHA',255,'','10th ','A','46',0,'',NULL,0,NULL),
('K.ARAVINDA S/O K RAMU',256,'','10th ','A','47',0,'',NULL,0,NULL),
('K.M.RAJASHEKAR S/O KEDARNATHA',257,'','10th ','A','48',0,'',NULL,0,NULL),
('K.MAHAMMAD HUSSEN S/O K ISMAIL',258,'','10th ','A','49',0,'',NULL,0,NULL),
('K.MAHESHA S/O LINGAPPA',259,'','10th ','A','50',0,'',NULL,0,NULL),
('K.MOHAMAD GOUSE S/O YUNUS',260,'','10th ','A','51',0,'',NULL,0,NULL),
('K.VINAYA S/O K VIRUPANNA',261,'','10th ','A','52',0,'',NULL,0,NULL),
('KAVYA D/O DODDA BASAVARAJA',262,'','10th ','A','53',0,'',NULL,0,NULL),
('KHADAR BASHA S/O KASIM ALI',263,'','10th ','A','54',0,'',NULL,0,NULL),
('L.SUMETHRA D/O L NAGARAJA',264,'','10th ','A','55',0,'',NULL,0,NULL),
('LINGADALLI HOONURSWAMI S/O YAMANAPPA',265,'','10th ','A','56',0,'',NULL,0,NULL),
('M GANESH S/O ',266,'','10th ','A','57',0,'',NULL,0,NULL),
('M HANUMANTAPPA S/O PAKKIRAPPA',267,'','10th ','A','58',0,'',NULL,0,NULL),
('M NOORBASHA S/O BUDNESAB',268,'','10th ','A','59',0,'',NULL,0,NULL),
('M RAKSHITHA D/O M SHANKARA',269,'','10th ','A','60',0,'','s s m channabsavaraj sir concession',0,NULL),
('M..PRADEEP S/O KASHIRAO',270,'','10th ','A','61',0,'',NULL,0,NULL),
('M.MADHU D/O M AYYAPPA',271,'','10th ','A','62',0,'',NULL,0,''),
('M.MAHAMAD GOUSE S/O ',272,'','10th ','A','63',0,'',NULL,0,NULL),
('M.RAKSHITA D/O NAGENDRA',273,'','10th ','A','64',0,'',NULL,0,NULL),
('M.REKHA D/O RAMAPPA',274,'','10th ','A','65',0,'',NULL,0,NULL),
('MAHAMMAD ROSHAN S/O HASEN SAB',275,'','10th ','A','66',0,'',NULL,0,NULL),
('MANIKANTHA HUGAR S/O ',276,'','10th ','A','67',0,'',NULL,0,NULL),
('MAREEN BI D/O MUTTURAJ',277,'','10th ','A','68',0,'',NULL,0,NULL),
('MEHABOOB S/O RAMALI',278,'','10th ','A','69',0,'',NULL,0,NULL),
('MOULABEE D/O RAJASAB',279,'','10th ','A','70',0,'',NULL,0,NULL),
('N.SHIVU KUMAR S/O N MANJUNATHA',280,'','10th ','A','71',0,'',NULL,0,''),
('N.SUSHMITHA D/O GIRIYAPPA',281,'','10th ','A','72',0,'',NULL,0,NULL),
('P JAGAN S/O P TUKARAM',282,'','10th ','A','73',0,'',NULL,0,NULL),
('P MOHAMMAD GOUSE S/O SUBAN',283,'','10th ','A','74',0,'',NULL,0,NULL),
('P.SHAILAJA D/O GANESH',284,'','10th ','A','75',0,'',NULL,0,NULL),
('PALLAVI D/O MALLIKARJUNA',285,'','10th ','A','76',0,'',NULL,0,NULL),
('PAVAN S S D/O N SURESH',286,'','10th ','A','77',0,'',NULL,0,NULL),
('PRAKASHA S/O SHIVALINGA',287,'','10th ','A','78',0,'',NULL,0,NULL),
('R KAVERI D/O RAJA',288,'','10th ','A','79',0,'',NULL,0,NULL),
('RAFIQUE S/O SARVAR HUSEN',289,'','10th ','A','80',0,'',NULL,0,NULL),
('RAJA S/O CHANDUSAB',290,'','10th ','A','81',0,'',NULL,0,NULL),
('RENUKA D/O THIPPESWAMY',291,'','10th ','A','82',0,'',NULL,0,NULL),
('RENUKESHA.S S/O RAGHAVENDRA',292,'','10th ','A','83',0,'',NULL,0,NULL),
('RESHMA D/O SAIYYAD RAJASAB',293,'','10th ','A','84',0,'',NULL,0,NULL),
('S MAHALAKSHMI D/O S YALAVAPPA',294,'','10th ','A','85',0,'',NULL,0,NULL),
('S.GOPALA S/O S SURESH',295,'','10th ','A','86',0,'',NULL,0,NULL),
('S.PRAJWAL S/O YAMANURI',296,'','10th ','A','87',0,'',NULL,0,NULL),
('S.REKHA D/O S PRAKASH',297,'','10th ','A','88',0,'',NULL,0,NULL),
('S.ROHITH S/O GANGADHARA',298,'','10th ','A','89',0,'',NULL,0,NULL),
('S.SAJIDA D/O NABISAB',299,'','10th ','A','90',0,'',NULL,0,NULL),
('SADIKA D/O SHAMID',300,'','10th ','A','91',0,'',NULL,0,NULL),
('SARASWATHI D/O HANUMAYYA',301,'','10th ','A','92',0,'',NULL,0,NULL),
('SHEKSHAVALI H S/O SABANNA',302,'','10th ','A','93',0,'',NULL,0,''),
('SHIVAKUMAR E S/O BASAVARAJ E',303,'','10th ','A','94',0,'',NULL,0,NULL),
('SHIVALINGA VALMIKI S/O RAMANJINI',304,'','10th ','A','95',0,'',NULL,0,NULL),
('SHWETHA C D/O C MAHADEVA',305,'','10th ','A','96',0,'',NULL,0,NULL),
('SONABAI B D/O MOHAN SINGH',306,'','10th ','A','97',0,'','president sir concession ',0,NULL),
('SUGURU HEMANTHAKUMARA S/O RAGHAVENDRA',307,'','10th ','A','98',0,'',NULL,0,NULL),
('SUSMA B D/O B RAMESH',308,'','10th ','A','99',0,'',NULL,0,NULL),
('U PRADEEP S/O U MALLAYYA',309,'','10th ','A','100',0,'',NULL,0,NULL),
('V SHRIHARI S/O V SHIVARAJA',310,'','10th ','A','101',0,'',NULL,0,NULL),
('V UMME SALMA D/O HUSEN BASHA',311,'','10th ','A','102',0,'',NULL,0,NULL),
('V.CHANDRAMMA D/O V RAMESH',312,'','10th ','A','103',0,'',NULL,0,NULL),
('V.DIVYA D/O V HARISH',313,'','10th ','A','104',0,'',NULL,0,NULL),
('V.HONNURUVALI SAB S/O V RAJA SAB',314,'','10th ','A','105',0,'',NULL,0,NULL),
('V.VENKATA RAMANA S/O V ISHWAR',315,'','10th ','A','106',0,'',NULL,0,NULL),
('VEERESH S/O MAHESH',316,'','10th ','A','107',0,'',NULL,0,NULL),
('YASWANTA S/O NAGENDRA',317,'','10th ','A','108',0,'',NULL,0,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=625 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,4,1,1,5000,5000,0,0,'',NULL),
(2,4,1,2,1000,1000,0,0,'',NULL),
(3,5,1,1,5000,5000,0,0,'',NULL),
(4,5,1,2,1000,1000,0,0,'',NULL),
(5,6,1,1,5000,4000,1000,0,'',NULL),
(6,6,1,2,1000,1000,0,0,'',NULL),
(7,7,1,1,5000,4000,1000,0,'',NULL),
(8,7,1,2,1000,1000,0,0,'',NULL),
(9,8,1,1,5000,2000,3000,0,'',NULL),
(10,8,1,2,1000,1000,0,0,'',NULL),
(11,9,1,1,5000,3500,1500,0,'',NULL),
(12,9,1,2,1000,1000,0,0,'',NULL),
(13,10,1,1,5000,4000,1000,0,'',NULL),
(14,10,1,2,1000,1000,0,0,'',NULL),
(15,11,1,1,5000,2000,3000,0,'',NULL),
(16,11,1,2,1000,1000,0,0,'',NULL),
(17,12,1,1,5000,3000,2000,0,'',NULL),
(18,12,1,2,1000,1000,0,0,'',NULL),
(19,13,1,1,5000,2000,3000,0,'',NULL),
(20,13,1,2,1000,1000,0,0,'',NULL),
(21,14,1,1,5000,2000,3000,0,'',NULL),
(22,14,1,2,1000,1000,0,0,'',NULL),
(23,15,1,1,5000,2000,3000,0,'',NULL),
(24,15,1,2,1000,1000,0,0,'',NULL),
(25,16,1,1,5000,3000,2000,0,'',NULL),
(26,16,1,2,1000,1000,0,0,'',NULL),
(27,17,1,1,5000,5000,0,0,'',NULL),
(28,17,1,2,1000,1000,0,0,'',NULL),
(29,18,1,1,5000,3000,2000,0,'',NULL),
(30,18,1,2,1000,1000,0,0,'',NULL),
(31,19,1,1,5000,1000,4000,0,'',NULL),
(32,19,1,2,1000,1000,0,0,'',NULL),
(33,20,1,1,5000,4000,1000,0,'',NULL),
(34,20,1,2,1000,1000,0,0,'',NULL),
(35,21,1,1,5000,3000,2000,0,'',NULL),
(36,21,1,2,1000,1000,0,0,'',NULL),
(37,22,1,1,5000,3000,2000,0,'',NULL),
(38,22,1,2,1000,1000,0,0,'',NULL),
(39,23,1,1,5000,3000,2000,0,'',NULL),
(40,23,1,2,1000,1000,0,0,'',NULL),
(41,24,1,1,5000,5000,0,0,'',NULL),
(42,24,1,2,1000,1000,0,0,'',NULL),
(43,25,1,1,5000,3000,2000,0,'',NULL),
(44,25,1,2,1000,1000,0,0,'',NULL),
(45,26,1,1,5000,3000,2000,0,'',NULL),
(46,26,1,2,1000,1000,0,0,'',NULL),
(47,27,1,1,5000,5000,0,0,'',NULL),
(48,27,1,2,1000,1000,0,0,'',NULL),
(49,28,1,1,5000,3000,2000,0,'',NULL),
(50,28,1,2,1000,1000,0,0,'',NULL),
(51,29,1,1,5000,3000,2000,0,'',NULL),
(52,29,1,2,1000,1000,0,0,'',NULL),
(53,30,1,1,5000,3000,2000,0,'',NULL),
(54,30,1,2,1000,1000,0,0,'',NULL),
(55,31,1,1,5000,0,5000,0,'',NULL),
(56,31,1,2,1000,0,1000,0,'',NULL),
(57,32,1,1,5000,3000,2000,0,'',NULL),
(58,32,1,2,1000,1000,0,0,'',NULL),
(59,33,1,1,5000,2000,3000,0,'',NULL),
(60,33,1,2,1000,1000,0,0,'',NULL),
(61,34,1,1,5000,3000,2000,0,'',NULL),
(62,34,1,2,1000,1000,0,0,'',NULL),
(63,35,1,1,5000,2000,3000,0,'',NULL),
(64,35,1,2,1000,1000,0,0,'',NULL),
(65,36,1,1,5000,5000,0,0,'',NULL),
(66,36,1,2,1000,1000,0,0,'',NULL),
(67,37,1,1,5000,2000,3000,0,'',NULL),
(68,37,1,2,1000,1000,0,0,'',NULL),
(69,38,1,1,5000,3000,2000,0,'',NULL),
(70,38,1,2,1000,1000,0,0,'',NULL),
(71,39,1,1,5000,3000,2000,0,'',NULL),
(72,39,1,2,1000,1000,0,0,'',NULL),
(73,40,1,1,5000,1500,3500,0,'',NULL),
(74,40,1,2,1000,1000,0,0,'',NULL),
(75,41,1,1,5000,2500,2500,0,'',NULL),
(76,41,1,2,1000,1000,0,0,'',NULL),
(77,42,1,1,5000,5000,0,0,'',NULL),
(78,42,1,2,1000,1000,0,0,'',NULL),
(79,3,1,1,5000,5000,0,0,'',NULL),
(80,3,1,2,1000,1000,0,0,'',NULL),
(81,43,1,1,5000,4000,1000,0,'',NULL),
(82,43,1,2,1000,1000,0,0,'',NULL),
(83,44,1,1,5000,4000,1000,0,'',NULL),
(84,44,1,2,1000,1000,0,0,'',NULL),
(85,45,1,1,5000,3000,2000,0,'',NULL),
(86,45,1,2,1000,1000,0,0,'',NULL),
(87,47,1,1,5000,4000,1000,0,'',NULL),
(88,47,1,2,1000,1000,0,0,'',NULL),
(89,46,1,1,5000,3000,2000,0,'',NULL),
(90,46,1,2,1000,1000,0,0,'',NULL),
(91,48,1,1,5000,1500,3500,0,'',NULL),
(92,48,1,2,1000,1000,0,0,'',NULL),
(93,49,1,1,5000,4000,1000,0,'',NULL),
(94,49,1,2,1000,1000,0,0,'',NULL),
(95,50,1,1,5000,1000,4000,0,'',NULL),
(96,50,1,2,1000,1000,0,0,'',NULL),
(97,51,1,1,5000,5000,0,0,'',NULL),
(98,51,1,2,1000,1000,0,0,'',NULL),
(99,52,1,1,5000,4000,1000,0,'',NULL),
(100,52,1,2,1000,1000,0,0,'',NULL),
(101,53,1,1,5000,3000,2000,0,'',NULL),
(102,53,1,2,1000,1000,0,0,'',NULL),
(103,54,1,1,5000,3000,2000,0,'',NULL),
(104,54,1,2,1000,1000,0,0,'',NULL),
(105,55,1,1,5000,5000,0,0,'',NULL),
(106,55,1,2,1000,1000,0,0,'',NULL),
(107,56,1,1,5000,4000,1000,0,'',NULL),
(108,56,1,2,1000,1000,0,0,'',NULL),
(109,57,1,1,5000,3000,2000,0,'',NULL),
(110,57,1,2,1000,1000,0,0,'',NULL),
(111,58,1,1,5000,2500,2500,0,'',NULL),
(112,58,1,2,1000,1000,0,0,'',NULL),
(113,59,1,1,5000,3000,2000,0,'',NULL),
(114,59,1,2,1000,1000,0,0,'',NULL),
(115,60,1,1,5000,2000,3000,0,'',NULL),
(116,60,1,2,1000,1000,0,0,'',NULL),
(117,61,1,1,5000,2000,3000,0,'',NULL),
(118,61,1,2,1000,1000,0,0,'',NULL),
(119,62,1,1,5000,3000,2000,0,'',NULL),
(120,62,1,2,1000,1000,0,0,'',NULL),
(121,63,1,1,5000,3500,1500,0,'',NULL),
(122,63,1,2,1000,1000,0,0,'',NULL),
(123,64,1,1,5000,3000,2000,0,'',NULL),
(124,64,1,2,1000,1000,0,0,'',NULL),
(125,65,1,1,5000,5000,0,0,'',NULL),
(126,65,1,2,1000,1000,0,0,'',NULL),
(127,66,1,1,5000,5000,0,0,'',NULL),
(128,66,1,2,1000,1000,0,0,'',NULL),
(129,67,1,1,5000,3000,2000,0,'',NULL),
(130,67,1,2,1000,1000,0,0,'',NULL),
(131,68,1,1,5000,5000,0,0,'',NULL),
(132,68,1,2,1000,1000,0,0,'',NULL),
(133,69,1,1,5000,5000,0,0,'',NULL),
(134,69,1,2,1000,1000,0,0,'',NULL),
(135,70,1,1,5000,4000,1000,0,'',NULL),
(136,70,1,2,1000,1000,0,0,'',NULL),
(137,71,1,1,5000,3000,2000,0,'',NULL),
(138,71,1,2,1000,1000,0,0,'',NULL),
(139,72,1,1,5000,0,5000,0,'',NULL),
(140,72,1,2,1000,0,1000,0,'',NULL),
(141,73,1,1,5000,2000,3000,0,'',NULL),
(142,73,1,2,1000,1000,0,0,'',NULL),
(143,74,1,1,5000,2000,3000,0,'',NULL),
(144,74,1,2,1000,1000,0,0,'',NULL),
(145,75,1,1,5000,3000,2000,0,'',NULL),
(146,75,1,2,1000,1000,0,0,'',NULL),
(147,76,1,1,5000,5000,0,0,'',NULL),
(148,76,1,2,1000,1000,0,0,'',NULL),
(149,77,1,1,5000,2000,3000,0,'',NULL),
(150,77,1,2,1000,1000,0,0,'',NULL),
(151,78,1,1,5000,2000,3000,0,'',NULL),
(152,78,1,2,1000,1000,0,0,'',NULL),
(153,79,1,1,5000,3000,2000,0,'',NULL),
(154,79,1,2,1000,1000,0,0,'',NULL),
(155,80,1,1,5000,3000,2000,0,'',NULL),
(156,80,1,2,1000,1000,0,0,'',NULL),
(157,81,1,1,5000,2000,3000,0,'',NULL),
(158,81,1,2,1000,1000,0,0,'',NULL),
(159,82,1,1,5000,2000,3000,0,'',NULL),
(160,82,1,2,1000,1000,0,0,'',NULL),
(161,83,1,1,5000,5000,0,0,'',NULL),
(162,83,1,2,1000,1000,0,0,'',NULL),
(163,84,1,1,5000,3000,2000,0,'',NULL),
(164,84,1,2,1000,1000,0,0,'',NULL),
(165,85,1,1,5000,2000,3000,0,'',NULL),
(166,85,1,2,1000,1000,0,0,'',NULL),
(167,86,1,1,5000,3000,2000,0,'',NULL),
(168,86,1,2,1000,1000,0,0,'',NULL),
(169,87,1,1,5000,4500,500,0,'',NULL),
(170,87,1,2,1000,1000,0,0,'',NULL),
(171,88,1,1,5000,2000,3000,0,'',NULL),
(172,88,1,2,1000,1000,0,0,'',NULL),
(173,89,1,1,5000,2000,3000,0,'',NULL),
(174,89,1,2,1000,1000,0,0,'',NULL),
(175,90,1,1,5000,5000,0,0,'',NULL),
(176,90,1,2,1000,1000,0,0,'',NULL),
(177,91,1,1,5000,2000,3000,0,'',NULL),
(178,91,1,2,1000,1000,0,0,'',NULL),
(179,92,1,1,5000,3000,2000,0,'',NULL),
(180,92,1,2,1000,1000,0,0,'',NULL),
(181,93,1,1,5000,4500,500,0,'',NULL),
(182,93,1,2,1000,1000,0,0,'',NULL),
(183,94,1,1,5000,3000,2000,0,'',NULL),
(184,94,1,2,1000,1000,0,0,'',NULL),
(185,95,1,1,5000,2000,3000,0,'',NULL),
(186,95,1,2,1000,1000,0,0,'',NULL),
(187,96,1,1,5000,5000,0,0,'',NULL),
(188,96,1,2,1000,1000,0,0,'',NULL),
(189,100,2,2,0,0,0,1000,'',NULL),
(190,100,2,3,0,0,0,6000,'',NULL),
(191,101,2,2,1000,1000,0,0,'',NULL),
(192,101,2,3,6000,2000,4000,0,'',NULL),
(193,102,2,2,1000,1000,0,0,'',NULL),
(194,102,2,3,6000,3000,3000,0,'',NULL),
(195,103,2,2,1000,1000,0,0,'',NULL),
(196,103,2,3,6000,4000,2000,0,'',NULL),
(197,104,2,2,1000,1000,0,0,'',NULL),
(198,104,2,3,6000,0,6000,0,'',NULL),
(199,105,2,2,1000,1000,0,0,'',NULL),
(200,105,2,3,6000,3000,3000,0,'',NULL),
(201,106,2,2,1000,1000,0,0,'',NULL),
(202,106,2,3,6000,2000,4000,0,'',NULL),
(203,107,2,2,1000,1000,0,0,'',NULL),
(204,107,2,3,6000,3000,3000,0,'',NULL),
(205,108,2,2,1000,1000,0,0,'',NULL),
(206,108,2,3,6000,6000,0,0,'',NULL),
(207,109,2,2,1000,1000,0,0,'',NULL),
(208,109,2,3,6000,6000,0,0,'',NULL),
(209,110,2,2,1000,0,1000,0,'',NULL),
(210,110,2,3,6000,0,6000,0,'',NULL),
(211,111,2,2,1000,1000,0,0,'',NULL),
(212,111,2,3,6000,1000,5000,0,'',NULL),
(213,112,2,2,1000,1000,0,0,'',NULL),
(214,112,2,3,6000,2000,4000,0,'',NULL),
(215,113,2,2,1000,1000,0,0,'',NULL),
(216,113,2,3,6000,3000,3000,0,'',NULL),
(217,114,2,2,1000,1000,0,0,'',NULL),
(218,114,2,3,6000,6000,0,0,'',NULL),
(219,115,2,2,1000,1000,0,0,'',NULL),
(220,115,2,3,6000,3000,3000,0,'',NULL),
(221,116,2,2,1000,1000,0,0,'',NULL),
(222,116,2,3,6000,3000,3000,0,'',NULL),
(223,117,2,2,1000,1000,0,0,'',NULL),
(224,117,2,3,6000,2000,4000,0,'',NULL),
(225,118,2,2,1000,0,1000,0,'',NULL),
(226,118,2,3,6000,0,6000,0,'',NULL),
(227,119,2,2,1000,1000,0,0,'',NULL),
(228,119,2,3,6000,3000,3000,0,'',NULL),
(229,120,2,2,1000,1000,0,0,'',NULL),
(230,120,2,3,6000,3000,3000,0,'',NULL),
(231,121,2,2,1000,1000,0,0,'',NULL),
(232,121,2,3,6000,3000,3000,0,'',NULL),
(233,122,2,2,1000,1000,0,0,'',NULL),
(234,122,2,3,6000,4000,2000,0,'',NULL),
(235,123,2,2,1000,1000,0,0,'',NULL),
(236,123,2,3,6000,2000,4000,0,'',NULL),
(237,124,2,2,1000,1000,0,0,'',NULL),
(238,124,2,3,6000,2500,3500,0,'',NULL),
(239,125,2,2,1000,1000,0,0,'',NULL),
(240,125,2,3,6000,6000,0,0,'',NULL),
(241,126,2,2,1000,1000,0,0,'',NULL),
(242,126,2,3,6000,3000,3000,0,'',NULL),
(243,127,2,2,1000,1000,0,0,'',NULL),
(244,127,2,3,6000,3000,3000,0,'',NULL),
(245,128,2,2,1000,0,1000,0,'',NULL),
(246,128,2,3,6000,0,6000,0,'',NULL),
(247,129,2,2,1000,1000,0,0,'',NULL),
(248,129,2,3,6000,2000,4000,0,'',NULL),
(249,130,2,2,1000,1000,0,0,'',NULL),
(250,130,2,3,6000,6000,0,0,'',NULL),
(251,131,2,2,0,0,0,1000,'',NULL),
(252,131,2,3,0,0,0,6000,'',NULL),
(253,132,2,2,1000,1000,0,0,'',NULL),
(254,132,2,3,6000,3000,3000,0,'',NULL),
(255,133,2,2,1000,1000,0,0,'',NULL),
(256,133,2,3,6000,3000,3000,0,'',NULL),
(257,134,2,2,1000,1000,0,0,'',NULL),
(258,134,2,3,6000,3000,3000,0,'',NULL),
(259,135,2,2,1000,1000,0,0,'',NULL),
(260,135,2,3,6000,2000,4000,0,'',NULL),
(261,136,2,2,1000,1000,0,0,'',NULL),
(262,136,2,3,6000,2500,3500,0,'',NULL),
(263,137,2,2,1000,1000,0,0,'',NULL),
(264,137,2,3,6000,3000,3000,0,'',NULL),
(265,138,2,2,1000,1000,0,0,'',NULL),
(266,138,2,3,6000,3000,3000,0,'',NULL),
(267,139,2,2,1000,1000,0,0,'',NULL),
(268,139,2,3,6000,3000,3000,0,'',NULL),
(269,140,2,2,1000,1000,0,0,'',NULL),
(270,140,2,3,6000,3000,3000,0,'',NULL),
(271,141,2,2,1000,0,1000,0,'',NULL),
(272,141,2,3,6000,0,6000,0,'',NULL),
(273,142,2,2,1000,0,1000,0,'',NULL),
(274,142,2,3,6000,0,6000,0,'',NULL),
(275,143,2,2,1000,1000,0,0,'',NULL),
(276,143,2,3,6000,3000,3000,0,'',NULL),
(277,144,2,2,1000,1000,0,0,'',NULL),
(278,144,2,3,6000,1500,4500,0,'',NULL),
(279,145,2,2,1000,1000,0,0,'',NULL),
(280,145,2,3,6000,6000,0,0,'',NULL),
(281,146,2,2,1000,0,1000,0,'',NULL),
(282,146,2,3,6000,0,6000,0,'',NULL),
(283,147,2,2,1000,1000,0,0,'',NULL),
(284,147,2,3,6000,3000,3000,0,'',NULL),
(285,148,2,2,1000,1000,0,0,'',NULL),
(286,148,2,3,6000,2500,3500,0,'',NULL),
(287,149,2,2,1000,1000,0,0,'',NULL),
(288,149,2,3,6000,3000,3000,0,'',NULL),
(289,150,2,2,1000,1000,0,0,'',NULL),
(290,150,2,3,6000,2000,4000,0,'',NULL),
(291,151,2,2,1000,1000,0,0,'',NULL),
(292,151,2,3,6000,2500,3500,0,'',NULL),
(293,152,2,2,1000,1000,0,0,'',NULL),
(294,152,2,3,6000,3000,3000,0,'',NULL),
(295,153,2,2,1000,1000,0,0,'',NULL),
(296,153,2,3,6000,2000,4000,0,'',NULL),
(297,154,2,2,1000,1000,0,0,'',NULL),
(298,154,2,3,6000,4000,2000,0,'',NULL),
(299,155,2,2,1000,1000,0,0,'',NULL),
(300,155,2,3,6000,3000,3000,0,'',NULL),
(301,156,2,2,1000,1000,0,0,'',NULL),
(302,156,2,3,6000,3000,3000,0,'',NULL),
(303,157,2,2,1000,0,1000,0,'',NULL),
(304,157,2,3,6000,0,6000,0,'',NULL),
(305,158,2,2,1000,1000,0,0,'',NULL),
(306,158,2,3,6000,3000,3000,0,'',NULL),
(307,159,2,2,1000,0,1000,0,'',NULL),
(308,159,2,3,6000,0,6000,0,'',NULL),
(309,160,2,2,1000,1000,0,0,'',NULL),
(310,160,2,3,6000,1500,4500,0,'',NULL),
(311,161,2,2,1000,1000,0,0,'',NULL),
(312,161,2,3,6000,3000,3000,0,'',NULL),
(313,162,2,2,1000,1000,0,0,'',NULL),
(314,162,2,3,6000,0,6000,0,'',NULL),
(315,163,2,2,1000,1000,0,0,'',NULL),
(316,163,2,3,6000,2000,4000,0,'',NULL),
(317,164,2,2,1000,1000,0,0,'',NULL),
(318,164,2,3,6000,2500,3500,0,'',NULL),
(319,165,2,2,1000,1000,0,0,'',NULL),
(320,165,2,3,6000,3000,3000,0,'',NULL),
(321,166,2,2,1000,1000,0,0,'',NULL),
(322,166,2,3,6000,3000,3000,0,'',NULL),
(323,167,2,2,1000,0,1000,0,'',NULL),
(324,167,2,3,6000,0,6000,0,'',NULL),
(325,168,2,2,1000,1000,0,0,'',NULL),
(326,168,2,3,6000,6000,0,0,'',NULL),
(327,169,2,2,1000,1000,0,0,'',NULL),
(328,169,2,3,6000,3500,2500,0,'',NULL),
(329,170,2,2,1000,1000,0,0,'',NULL),
(330,170,2,3,6000,4000,2000,0,'',NULL),
(331,171,2,2,1000,1000,0,0,'',NULL),
(332,171,2,3,6000,2000,4000,0,'',NULL),
(333,172,2,2,1000,1000,0,0,'',NULL),
(334,172,2,3,6000,2000,4000,0,'',NULL),
(335,173,2,2,1000,1000,0,0,'',NULL),
(336,173,2,3,6000,3000,3000,0,'',NULL),
(337,174,2,2,1000,1000,0,0,'',NULL),
(338,174,2,3,6000,6000,0,0,'',NULL),
(339,175,2,2,1000,1000,0,0,'',NULL),
(340,175,2,3,6000,6000,0,0,'',NULL),
(341,176,2,2,1000,1000,0,0,'',NULL),
(342,176,2,3,6000,1000,5000,0,'',NULL),
(343,177,2,2,1000,1000,0,0,'',NULL),
(344,177,2,3,6000,4000,2000,0,'',NULL),
(345,178,2,2,1000,1000,0,0,'',NULL),
(346,178,2,3,6000,3000,3000,0,'',NULL),
(347,179,2,2,1000,1000,0,0,'',NULL),
(348,179,2,3,6000,6000,0,0,'',NULL),
(349,180,2,2,1000,1000,0,0,'',NULL),
(350,180,2,3,6000,6000,0,0,'',NULL),
(351,181,2,2,1000,0,1000,0,'',NULL),
(352,181,2,3,6000,0,6000,0,'',NULL),
(353,182,2,2,1000,1000,0,0,'',NULL),
(354,182,2,3,6000,2000,4000,0,'',NULL),
(355,183,2,2,1000,1000,0,0,'',NULL),
(356,183,2,3,6000,0,6000,0,'',NULL),
(357,184,2,2,1000,0,1000,0,'',NULL),
(358,184,2,3,6000,0,6000,0,'',NULL),
(359,185,2,2,1000,1000,0,0,'',NULL),
(360,185,2,3,6000,3000,3000,0,'',NULL),
(361,186,2,2,1000,1000,0,0,'',NULL),
(362,186,2,3,6000,3000,3000,0,'',NULL),
(363,187,2,2,1000,1000,0,0,'',NULL),
(364,187,2,3,5000,5000,0,1000,'',NULL),
(365,188,2,2,1000,1000,0,0,'',NULL),
(366,188,2,3,6000,3000,3000,0,'',NULL),
(367,189,2,2,1000,1000,0,0,'',NULL),
(368,189,2,3,6000,6000,0,0,'',NULL),
(369,190,2,2,1000,0,1000,0,'',NULL),
(370,190,2,3,6000,0,6000,0,'',NULL),
(371,191,2,2,1000,1000,0,0,'',NULL),
(372,191,2,3,6000,3000,3000,0,'',NULL),
(373,192,2,2,1000,1000,0,0,'',NULL),
(374,192,2,3,6000,2000,4000,0,'',NULL),
(375,99,2,2,1000,1000,0,0,'',NULL),
(376,99,2,3,6000,3000,3000,0,'',NULL),
(377,193,2,2,1000,1000,0,0,'',NULL),
(378,193,2,3,6000,3000,3000,0,'',NULL),
(379,194,2,2,1000,1000,0,0,'',NULL),
(380,194,2,3,6000,6000,0,0,'',NULL),
(381,195,2,2,1000,1000,0,0,'',NULL),
(382,195,2,3,6000,3000,3000,0,'',NULL),
(383,196,2,2,1000,1000,0,0,'',NULL),
(384,196,2,3,6000,2000,4000,0,'',NULL),
(385,197,2,2,1000,0,1000,0,'',NULL),
(386,197,2,3,6000,0,6000,0,'',NULL),
(387,198,2,2,1000,1000,0,0,'',NULL),
(388,198,2,3,6000,4000,2000,0,'',NULL),
(389,199,2,2,1000,1000,0,0,'',NULL),
(390,199,2,3,6000,3000,3000,0,'',NULL),
(391,200,2,2,1000,0,1000,0,'',NULL),
(392,200,2,3,6000,0,6000,0,'',NULL),
(393,201,2,2,1000,1000,0,0,'',NULL),
(394,201,2,3,6000,3000,3000,0,'',NULL),
(395,202,2,2,1000,1000,0,0,'',NULL),
(396,202,2,3,6000,3000,3000,0,'',NULL),
(397,203,2,2,1000,1000,0,0,'',NULL),
(398,203,2,3,6000,1000,5000,0,'',NULL),
(399,204,2,2,1000,1000,0,0,'',NULL),
(400,204,2,3,6000,2500,3500,0,'',NULL),
(401,205,2,2,1000,1000,0,0,'',NULL),
(402,205,2,3,6000,3000,3000,0,'',NULL),
(403,206,2,2,0,0,0,1000,'',NULL),
(404,206,2,3,0,0,0,6000,'',NULL),
(405,207,2,2,1000,1000,0,0,'',NULL),
(406,207,2,3,6000,2000,4000,0,'',NULL),
(407,208,2,2,1000,0,1000,0,'',NULL),
(408,208,2,3,6000,0,6000,0,'',NULL),
(409,210,3,2,1000,1000,0,0,'',NULL),
(410,210,3,4,7000,4000,3000,0,'',NULL),
(411,211,3,2,1000,0,1000,0,'',NULL),
(412,211,3,4,7000,0,7000,0,'',NULL),
(413,212,3,2,1000,1000,0,0,'',NULL),
(414,212,3,4,7000,3000,4000,0,'',NULL),
(415,213,3,2,1000,1000,0,0,'',NULL),
(416,213,3,4,7000,3000,4000,0,'',NULL),
(417,214,3,2,1000,1000,0,0,'',NULL),
(418,214,3,4,7000,3000,4000,0,'',NULL),
(419,215,3,2,1000,0,1000,0,'',NULL),
(420,215,3,4,7000,0,7000,0,'',NULL),
(421,216,3,2,1000,1000,0,0,'',NULL),
(422,216,3,4,7000,4000,3000,0,'',NULL),
(423,217,3,2,1000,1000,0,0,'',NULL),
(424,217,3,4,7000,3000,4000,0,'',NULL),
(425,218,3,2,1000,1000,0,0,'',NULL),
(426,218,3,4,7000,5000,2000,0,'',NULL),
(427,219,3,2,1000,1000,0,0,'',NULL),
(428,219,3,4,7000,2000,5000,0,'',NULL),
(429,220,3,2,1000,1000,0,0,'',NULL),
(430,220,3,4,7000,2000,5000,0,'',NULL),
(431,221,3,2,1000,1000,0,0,'',NULL),
(432,221,3,4,7000,3000,4000,0,'',NULL),
(433,222,3,2,1000,1000,0,0,'',NULL),
(434,222,3,4,7000,2000,5000,0,'',NULL),
(435,223,3,2,1000,1000,0,0,'',NULL),
(436,223,3,4,7000,3000,4000,0,'',NULL),
(437,224,3,2,1000,1000,0,0,'',NULL),
(438,224,3,4,7000,3000,4000,0,'',NULL),
(439,225,3,2,1000,1000,0,0,'',NULL),
(440,225,3,4,7000,3000,4000,0,'',NULL),
(441,226,3,2,1000,1000,0,0,'',NULL),
(442,226,3,4,7000,4000,3000,0,'',NULL),
(443,227,3,2,1000,1000,0,0,'',NULL),
(444,227,3,4,7000,3000,4000,0,'',NULL),
(445,228,3,2,1000,1000,0,0,'',NULL),
(446,228,3,4,7000,2000,5000,0,'',NULL),
(447,229,3,2,1000,1000,0,0,'',NULL),
(448,229,3,4,7000,3000,4000,0,'',NULL),
(449,230,3,2,1000,1000,0,0,'',NULL),
(450,230,3,4,7000,3000,4000,0,'',NULL),
(451,231,3,2,1000,1000,0,0,'',NULL),
(452,231,3,4,7000,1000,6000,0,'',NULL),
(453,232,3,2,1000,1000,0,0,'',NULL),
(454,232,3,4,7000,4000,3000,0,'',NULL),
(455,233,3,2,1000,1000,0,0,'',NULL),
(456,233,3,4,7000,5000,2000,0,'',NULL),
(457,234,3,2,1000,1000,0,0,'',NULL),
(458,234,3,4,7000,3000,4000,0,'',NULL),
(459,235,3,2,1000,0,1000,0,'',NULL),
(460,235,3,4,7000,0,7000,0,'',NULL),
(461,236,3,2,1000,1000,0,0,'',NULL),
(462,236,3,4,7000,3000,4000,0,'',NULL),
(463,237,3,2,1000,1000,0,0,'',NULL),
(464,237,3,4,7000,3000,4000,0,'',NULL),
(465,238,3,2,1000,1000,0,0,'',NULL),
(466,238,3,4,7000,3000,4000,0,'',NULL),
(467,239,3,2,1000,1000,0,0,'',NULL),
(468,239,3,4,7000,5000,2000,0,'',NULL),
(469,240,3,2,1000,1000,0,0,'',NULL),
(470,240,3,4,7000,2000,5000,0,'',NULL),
(471,241,3,2,1000,1000,0,0,'',NULL),
(472,241,3,4,7000,4000,3000,0,'',NULL),
(473,242,3,2,1000,1000,0,0,'',NULL),
(474,242,3,4,7000,3000,4000,0,'',NULL),
(475,243,3,2,1000,1000,0,0,'',NULL),
(476,243,3,4,7000,3000,4000,0,'',NULL),
(477,244,3,2,1000,1000,0,0,'',NULL),
(478,244,3,4,7000,3000,4000,0,'',NULL),
(479,245,3,2,1000,0,1000,0,'',NULL),
(480,245,3,4,7000,0,7000,0,'',NULL),
(481,246,3,2,1000,1000,0,0,'',NULL),
(482,246,3,4,7000,3500,3500,0,'',NULL),
(483,247,3,2,1000,0,1000,0,'',NULL),
(484,247,3,4,7000,0,7000,0,'',NULL),
(485,248,3,2,1000,1000,0,0,'',NULL),
(486,248,3,4,7000,4000,3000,0,'',NULL),
(487,249,3,2,1000,1000,0,0,'',NULL),
(488,249,3,4,7000,4000,3000,0,'',NULL),
(489,250,3,2,1000,1000,0,0,'',NULL),
(490,250,3,4,7000,5000,2000,0,'',NULL),
(491,251,3,2,1000,1000,0,0,'',NULL),
(492,251,3,4,7000,2000,5000,0,'',NULL),
(493,252,3,2,1000,1000,0,0,'',NULL),
(494,252,3,4,7000,4000,3000,0,'',NULL),
(495,253,3,2,1000,1000,0,0,'',NULL),
(496,253,3,4,7000,3000,4000,0,'',NULL),
(497,254,3,2,1000,1000,0,0,'',NULL),
(498,254,3,4,7000,3000,4000,0,'',NULL),
(499,255,3,2,1000,1000,0,0,'',NULL),
(500,255,3,4,7000,2000,5000,0,'',NULL),
(501,256,3,2,1000,1000,0,0,'',NULL),
(502,256,3,4,7000,2500,4500,0,'',NULL),
(503,257,3,2,1000,1000,0,0,'',NULL),
(504,257,3,4,7000,4000,3000,0,'',NULL),
(505,258,3,2,1000,1000,0,0,'',NULL),
(506,258,3,4,7000,2000,5000,0,'',NULL),
(507,259,3,2,1000,1000,0,0,'',NULL),
(508,259,3,4,7000,2000,5000,0,'',NULL),
(509,260,3,2,1000,1000,0,0,'',NULL),
(510,260,3,4,7000,4000,3000,0,'',NULL),
(511,261,3,2,1000,1000,0,0,'',NULL),
(512,261,3,4,7000,1000,6000,0,'',NULL),
(513,262,3,2,1000,1000,0,0,'',NULL),
(514,262,3,4,7000,3000,4000,0,'',NULL),
(515,263,3,2,1000,1000,0,0,'',NULL),
(516,263,3,4,7000,5000,2000,0,'',NULL),
(517,264,3,2,1000,1000,0,0,'',NULL),
(518,264,3,4,7000,3000,4000,0,'',NULL),
(519,265,3,2,1000,1000,0,0,'',NULL),
(520,265,3,4,7000,0,7000,0,'',NULL),
(521,266,3,2,1000,0,1000,0,'',NULL),
(522,266,3,4,7000,0,7000,0,'',NULL),
(523,267,3,2,1000,1000,0,0,'',NULL),
(524,267,3,4,7000,1000,6000,0,'',NULL),
(525,268,3,2,1000,1000,0,0,'',NULL),
(526,268,3,4,7000,1500,5500,0,'',NULL),
(527,269,3,2,1000,1000,0,0,'',NULL),
(528,269,3,4,4000,4000,0,3000,'',NULL),
(529,270,3,2,1000,1000,0,0,'',NULL),
(530,270,3,4,7000,3000,4000,0,'',NULL),
(531,271,3,2,1000,1000,0,0,'',NULL),
(532,271,3,4,7000,3000,4000,0,'',NULL),
(533,272,3,2,1000,0,1000,0,'',NULL),
(534,272,3,4,7000,0,7000,0,'',NULL),
(535,273,3,2,1000,1000,0,0,'',NULL),
(536,273,3,4,7000,3500,3500,0,'',NULL),
(537,274,3,2,1000,1000,0,0,'',NULL),
(538,274,3,4,7000,0,7000,0,'',NULL),
(539,275,3,2,1000,1000,0,0,'',NULL),
(540,275,3,4,7000,3000,4000,0,'',NULL),
(541,276,3,2,1000,0,1000,0,'',NULL),
(542,276,3,4,7000,0,7000,0,'',NULL),
(543,277,3,2,1000,1000,0,0,'',NULL),
(544,277,3,4,7000,4000,3000,0,'',NULL),
(545,278,3,2,1000,0,1000,0,'',NULL),
(546,278,3,4,7000,0,7000,0,'',NULL),
(547,279,3,2,1000,1000,0,0,'',NULL),
(548,279,3,4,7000,3000,4000,0,'',NULL),
(549,280,3,2,1000,1000,0,0,'',NULL),
(550,280,3,4,7000,2000,5000,0,'',NULL),
(551,281,3,2,1000,1000,0,0,'',NULL),
(552,281,3,4,7000,3000,4000,0,'',NULL),
(553,282,3,2,1000,1000,0,0,'',NULL),
(554,282,3,4,7000,1000,6000,0,'',NULL),
(555,283,3,2,1000,1000,0,0,'',NULL),
(556,283,3,4,7000,4000,3000,0,'',NULL),
(557,284,3,2,1000,1000,0,0,'',NULL),
(558,284,3,4,7000,4000,3000,0,'',NULL),
(559,285,3,2,1000,1000,0,0,'',NULL),
(560,285,3,4,7000,4000,3000,0,'',NULL),
(561,286,3,2,1000,1000,0,0,'',NULL),
(562,286,3,4,7000,4000,3000,0,'',NULL),
(563,287,3,2,1000,1000,0,0,'',NULL),
(564,287,3,4,7000,2000,5000,0,'',NULL),
(565,288,3,2,1000,1000,0,0,'',NULL),
(566,288,3,4,7000,4000,3000,0,'',NULL),
(567,289,3,2,1000,0,1000,0,'',NULL),
(568,289,3,4,7000,0,7000,0,'',NULL),
(569,290,3,2,1000,1000,0,0,'',NULL),
(570,290,3,4,7000,3000,4000,0,'',NULL),
(571,291,3,2,1000,1000,0,0,'',NULL),
(572,291,3,4,7000,3000,4000,0,'',NULL),
(573,292,3,2,1000,1000,0,0,'',NULL),
(574,292,3,4,7000,7000,0,0,'',NULL),
(575,293,3,2,1000,1000,0,0,'',NULL),
(576,293,3,4,7000,3000,4000,0,'',NULL),
(577,294,3,2,1000,1000,0,0,'',NULL),
(578,294,3,4,7000,1000,6000,0,'',NULL),
(579,295,3,2,1000,1000,0,0,'',NULL),
(580,295,3,4,7000,4000,3000,0,'',NULL),
(581,296,3,2,1000,1000,0,0,'',NULL),
(582,296,3,4,7000,2000,5000,0,'',NULL),
(583,297,3,2,1000,1000,0,0,'',NULL),
(584,297,3,4,7000,3000,4000,0,'',NULL),
(585,298,3,2,1000,1000,0,0,'',NULL),
(586,298,3,4,7000,3000,4000,0,'',NULL),
(587,299,3,2,1000,1000,0,0,'',NULL),
(588,299,3,4,7000,3000,4000,0,'',NULL),
(589,300,3,2,1000,1000,0,0,'',NULL),
(590,300,3,4,7000,1000,6000,0,'',NULL),
(591,301,3,2,1000,1000,0,0,'',NULL),
(592,301,3,4,7000,7000,0,0,'',NULL),
(593,302,3,2,1000,1000,0,0,'',NULL),
(594,302,3,4,7000,2000,5000,0,'',NULL),
(595,303,3,2,1000,1000,0,0,'',NULL),
(596,303,3,4,7000,4000,3000,0,'',NULL),
(597,304,3,2,1000,0,1000,0,'',NULL),
(598,304,3,4,7000,0,7000,0,'',NULL),
(599,305,3,2,1000,1000,0,0,'',NULL),
(600,305,3,4,7000,4000,3000,0,'',NULL),
(601,306,3,2,1000,1000,0,0,'',NULL),
(602,306,3,4,6000,6000,0,1000,'',NULL),
(603,307,3,2,1000,1000,0,0,'',NULL),
(604,307,3,4,7000,3000,4000,0,'',NULL),
(605,308,3,2,1000,1000,0,0,'',NULL),
(606,308,3,4,7000,4000,3000,0,'',NULL),
(607,309,3,2,1000,1000,0,0,'',NULL),
(608,309,3,4,7000,4000,3000,0,'',NULL),
(609,310,3,2,1000,1000,0,0,'',NULL),
(610,310,3,4,7000,6000,1000,0,'',NULL),
(611,311,3,2,1000,1000,0,0,'',NULL),
(612,311,3,4,7000,3000,4000,0,'',NULL),
(613,312,3,2,1000,1000,0,0,'',NULL),
(614,312,3,4,7000,4000,3000,0,'',NULL),
(615,313,3,2,1000,0,1000,0,'',NULL),
(616,313,3,4,7000,0,7000,0,'',NULL),
(617,314,3,2,1000,1000,0,0,'',NULL),
(618,314,3,4,7000,5000,2000,0,'',NULL),
(619,315,3,2,1000,1000,0,0,'',NULL),
(620,315,3,4,7000,4000,3000,0,'',NULL),
(621,316,3,2,1000,1000,0,0,'',NULL),
(622,316,3,4,7000,2500,4500,0,'',NULL),
(623,317,3,2,1000,1000,0,0,'',NULL),
(624,317,3,4,7000,3500,3500,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=5 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
('TUTION FEE (8)',1,'5000','N'),
('DEVELOPMENT FEE (8)',2,'1000','N'),
('TUITION FEE (9)',3,'6000','N'),
('TUITION FEE (10)',4,'7000','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,'adminFees304','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'Adminstudent','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'adminaccount304','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=193 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
('2024-05-31',NULL,1,1,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-05-31',NULL,2,2,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-05',NULL,3,3,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-05',NULL,4,4,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-07',NULL,5,5,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-07',NULL,6,6,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-06-07',NULL,7,7,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-08',NULL,8,8,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-08',NULL,9,9,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-10',NULL,10,10,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2024-06-10',NULL,11,11,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-10',NULL,12,12,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','22500','22500','Fees Collected'),
('2024-06-10',NULL,13,13,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-11',NULL,14,14,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','75000','75000','Fees Collected'),
('2024-06-11',NULL,15,15,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','31000','31000','Fees Collected'),
('2024-06-11',NULL,16,16,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-11',NULL,17,17,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2024-06-12',NULL,18,18,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','69000','69000','Fees Collected'),
('2024-06-12',NULL,19,19,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','24000','24000','Fees Collected'),
('2024-06-12',NULL,20,20,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-13',NULL,21,21,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','31500','31500','Fees Collected'),
('2024-06-13',NULL,22,22,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2024-06-14',NULL,23,23,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2024-06-14',NULL,24,24,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-19',NULL,25,25,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','19500','19500','Fees Collected'),
('2024-06-19',NULL,26,26,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2024-06-19',NULL,27,27,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-19',NULL,28,28,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-20',NULL,29,29,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-20',NULL,30,30,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-20',NULL,31,31,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-21',NULL,32,32,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-21',NULL,33,33,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-21',NULL,34,34,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-24',NULL,35,35,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected'),
('2024-06-24',NULL,36,36,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','32500','32500','Fees Collected'),
('2024-06-24',NULL,37,37,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-24',NULL,38,38,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-25',NULL,39,39,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-06-25',NULL,40,40,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-25',NULL,41,41,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-06-25',NULL,42,42,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-26',NULL,43,43,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-26',NULL,44,44,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-26',NULL,45,45,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-27',NULL,46,46,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-06-27',NULL,47,47,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-27',NULL,48,48,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-28',NULL,49,49,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-28',NULL,50,50,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2024-06-28',NULL,51,51,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-28',NULL,52,52,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-29',NULL,53,53,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-29',NULL,54,54,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-01',NULL,55,55,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-01',NULL,56,56,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-01',NULL,57,57,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-02',NULL,58,58,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-02',NULL,59,59,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-02',NULL,60,60,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2024-07-02',NULL,61,61,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-07-03',NULL,62,62,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-03',NULL,63,63,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2024-07-03',NULL,64,64,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-04',NULL,65,65,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-04',NULL,66,66,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-05',NULL,67,67,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-07-05',NULL,68,68,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-05',NULL,69,69,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-08',NULL,70,70,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-08',NULL,71,71,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-07-08',NULL,72,72,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-08',NULL,73,73,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-09',NULL,74,74,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-09',NULL,75,75,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2024-07-09',NULL,76,76,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-10',NULL,77,77,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-07-10',NULL,78,78,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected'),
('2024-07-11',NULL,79,79,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-11',NULL,80,80,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-13',NULL,81,81,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-13',NULL,82,82,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-13',NULL,83,83,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-15',NULL,84,84,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-15',NULL,85,85,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-16',NULL,86,86,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-16',NULL,87,87,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-16',NULL,88,88,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-18',NULL,89,89,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-18',NULL,90,90,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-18',NULL,91,91,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-18',NULL,92,92,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-22',NULL,93,93,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-07-22',NULL,94,94,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','13500','13500','Fees Collected'),
('2024-07-22',NULL,95,95,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-07-23',NULL,96,96,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-23',NULL,97,97,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-23',NULL,98,98,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','0000','0000','Fees Collected'),
('2024-07-24',NULL,99,99,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-24',NULL,100,100,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2024-07-24',NULL,101,101,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-25',NULL,102,102,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-25',NULL,103,103,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2024-07-24',NULL,104,104,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-07-25',NULL,105,105,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-26',NULL,106,106,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-29',NULL,107,107,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-29',NULL,108,108,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-07-30',NULL,109,109,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-30',NULL,110,110,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-05',NULL,111,111,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-05',NULL,112,112,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-08-07',NULL,113,113,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-07',NULL,114,114,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-08',NULL,115,115,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-08',NULL,116,116,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-08',NULL,117,117,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-13',NULL,118,118,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-13',NULL,119,119,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-13',NULL,120,120,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-16',NULL,121,121,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-16',NULL,122,122,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-16',NULL,123,123,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-17',NULL,124,124,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-17',NULL,125,125,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-17',NULL,126,126,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-08-20',NULL,127,127,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-20',NULL,128,128,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-22',NULL,129,129,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-22',NULL,130,130,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-08-22',NULL,131,131,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-23',NULL,132,132,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-29',NULL,133,133,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-08-29',NULL,134,134,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-29',NULL,135,135,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-08-31',NULL,136,136,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-08-31',NULL,137,137,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-02',NULL,138,138,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-09-09',NULL,139,139,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-09',NULL,140,140,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-09',NULL,141,141,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-10',NULL,142,142,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-10',NULL,143,143,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-11',NULL,144,144,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-11',NULL,145,145,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-09-11',NULL,146,146,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-09-12',NULL,147,147,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2024-09-12',NULL,148,148,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-12',NULL,149,149,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-13',NULL,150,150,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-13',NULL,151,151,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-13',NULL,152,152,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-17',NULL,153,153,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-17',NULL,154,154,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-17',NULL,155,155,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-17',NULL,156,156,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-18',NULL,157,157,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-09-18',NULL,158,158,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-18',NULL,159,159,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-09-18',NULL,160,160,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-19',NULL,161,161,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-09-21',NULL,162,162,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2024-09-21',NULL,163,163,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','43000','43000','Fees Collected'),
('2024-09-21',NULL,164,164,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','5500','5500','Fees Collected'),
('2024-09-21',NULL,165,165,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-09-23',NULL,166,166,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-23',NULL,167,167,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','34500','34500','Fees Collected'),
('2024-09-23',NULL,168,168,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','29000','29000','Fees Collected'),
('2024-09-23',NULL,169,169,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-09-24',NULL,170,170,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-24',NULL,171,171,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-09-24',NULL,172,172,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-09-24',NULL,173,173,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-25',NULL,174,174,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2024-09-25',NULL,175,175,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-26',NULL,176,176,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-09-26',NULL,177,177,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected'),
('2024-09-26',NULL,178,178,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-09-26',NULL,179,179,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-27',NULL,180,180,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-09-27',NULL,181,181,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-28',NULL,182,182,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-28',NULL,183,183,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-09-30',NULL,184,184,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-30',NULL,185,185,'Recipt','TUITION FEE (9)','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2024-09-30',NULL,186,186,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-11-04',NULL,187,187,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2024-11-12',NULL,188,188,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-11-13',NULL,189,189,'Recipt','DEVELOPMENT FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-11-13',NULL,190,190,'Recipt','TUITION FEE (10)','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-11-19',NULL,191,191,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-11-22',NULL,192,192,'Recipt','TUTION FEE (8)','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected');
/*!40000 ALTER TABLE `vochers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-05 0:00:39