|
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/../KPCM/../SJVVS/ |
| [ 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_SJVVS_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 Name','Shri Jagadamba Vidya Vardhak Sangh ','SJVVS English medium Primary School','Gajendragad-582114');
/*!40000 ALTER TABLE `Receipt_Head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`accountnumber` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account`
--
LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_accounts`
--
DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`passwd` varchar(50) NOT NULL,
`admin_type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_accounts`
--
LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bankaccounts`
--
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Bank_Name` varchar(1000) NOT NULL,
`IFSC` varchar(1000) NOT NULL,
`Account_Number` varchar(1000) NOT NULL,
`AccountHolderName` varchar(1000) NOT NULL,
`PayuKey` bigint(20) NOT NULL,
`SaltKey` bigint(20) NOT NULL,
`MerchantKey` bigint(20) NOT NULL,
`AccountType` varchar(1000) NOT NULL,
`Link` varchar(10000) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'Union Bank - 7882','','7882','SJVVS PRIMARY',0,0,0,'',''),
(2,'Union Bank - 8030','','8030','SJVVS - HIGH SCHOOL',0,0,0,'',''),
(3,'Union Bank - 8410','','8410','SJVVS - VAN',0,0,0,'',''),
(4,'Union Bank - 8173','','8173','SJVVS LKG UKG',0,0,0,'',''),
(5,'Union Bank -6064','','6064','SJVVS DEVELOPMENT',0,0,0,'','');
/*!40000 ALTER TABLE `bankaccounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `budget`
--
DROP TABLE IF EXISTS `budget`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budget` (
`budgetid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fromdate` date NOT NULL,
`todate` date DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`budgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `budget`
--
LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`type` int(11) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `class`
--
DROP TABLE IF EXISTS `class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class` (
`Name` varchar(100) NOT NULL,
`Cls_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Cls_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `class`
--
LOCK TABLES `class` WRITE;
/*!40000 ALTER TABLE `class` DISABLE KEYS */;
INSERT INTO `class` VALUES
('LKG',1,NULL),
('UKG',2,NULL),
('2',6,NULL),
('1',5,NULL),
('3',7,NULL),
('4',8,NULL),
('5',9,NULL),
('6',10,NULL),
('7',11,NULL),
('8',12,NULL),
('9',13,NULL),
('10',14,NULL),
('CASH',15,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=11 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
('LKG-UKG',1,'1','2023-06-01','No','0','4','SCHL'),
('PRIMARY FEES',2,'2','2023-06-01','No','0','1','SCHL'),
('HIGH SCHOOL FEES',3,'3','2023-06-01','No','0','2','SCHL'),
('VAN PRE -PRIMARY FEES',4,'4','2023-06-01','No','0','3','VANR'),
('VAN I-X',5,'5','2023-06-01','No','0','3','VANR'),
('Development Fees',6,'6','2023-06-01','No','0','5','DEVP'),
('School Fees I - IV',7,'7','2026-06-01','No','0','1','SCHL'),
('School fees V-VII',8,'2','2026-06-01','No','0','1','SCHL'),
('out side',9,'9','2026-06-01','No','0','1','VANR'),
('school fees VIII-X',10,'3','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=15 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
('School Fees LKG-UKG',1,'Income/Revenue'),
('School Fees LKG-UKG',2,'Income/Revenue'),
('School Fees LKG-UKG',3,'Income/Revenue'),
('Van Fees',4,'Income/Revenue'),
('va',5,'Income/Revenue'),
('Union Bank-7882',6,'Current Assets'),
('Union Bank-8030',7,'Current Assets'),
('Union Bank-8410',8,'Current Assets'),
('Union Bank-8173',9,'Current Assets'),
('Union Bank-6064',10,'Current Assets'),
('Development Fees V-X',11,'Income/Revenue'),
('School Fees I -IV ',12,'Income/Revenue'),
('School Fees V-VII',13,'Income/Revenue'),
('van fees out side area',14,'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=291 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,1,'SCHL-1',1,'SCHL','SCHL-1',1,'7','/7','/6000','2023-06-01','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(2,1,'VANR-1',1,'VANR','VANR-1',1,'5','/5','/3000','2023-06-01','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(3,2,'DEVP-1',1,'DEVP','DEVP-1',1,'6','/6','/5000','2023-06-01','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(4,2,'SCHL-2',2,'SCHL','SCHL-2',2,'7','/7','/6000','2023-06-01','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(5,3,'SCHL-3',3,'SCHL','SCHL-3',3,'7','/7','/6000','2023-05-29','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(6,4,'VANR-2',2,'VANR','VANR-2',2,'5','/5','/3000','2023-06-01','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(7,4,'SCHL-4',4,'SCHL','SCHL-4',4,'7','/7','/6000','2023-06-01','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(8,5,'SCHL-5',5,'SCHL','SCHL-5',5,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(9,6,'DEVP-2',2,'DEVP','DEVP-2',2,'6','/6','/5000','2023-06-02','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(10,6,'SCHL-6',6,'SCHL','SCHL-6',6,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(11,7,'VANR-3',3,'VANR','VANR-3',3,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(12,7,'DEVP-3',3,'DEVP','DEVP-3',3,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(13,7,'SCHL-7',7,'SCHL','SCHL-7',7,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(14,9,'VANR-4',4,'VANR','VANR-4',4,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(15,9,'DEVP-4',4,'DEVP','DEVP-4',4,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(16,10,'VANR-5',5,'VANR','VANR-5',5,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(17,10,'DEVP-5',5,'DEVP','DEVP-5',5,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(18,11,'VANR-6',6,'VANR','VANR-6',6,'5','/5','/3000','2023-05-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(19,11,'SCHL-8',8,'SCHL','SCHL-8',8,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(20,12,'VANR-7',7,'VANR','VANR-7',7,'5','/5','/3000','2023-05-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(21,12,'SCHL-9',9,'SCHL','SCHL-9',9,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(22,13,'VANR-8',8,'VANR','VANR-8',8,'5','/5','/3000','2023-05-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(23,13,'SCHL-10',10,'SCHL','SCHL-10',10,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(24,14,'DEVP-6',6,'DEVP','DEVP-6',6,'6','/6','/5000','2023-05-31','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(25,14,'SCHL-11',11,'SCHL','SCHL-11',11,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(26,15,'SCHL-12',12,'SCHL','SCHL-12',12,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(27,16,'VANR-9',9,'VANR','VANR-9',9,'5','/5','/3000','2023-05-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(28,16,'DEVP-7',7,'DEVP','DEVP-7',7,'6','/6','/5000','2023-05-31','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(29,16,'SCHL-13',13,'SCHL','SCHL-13',13,'7','/7','/6000','2023-05-31','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(30,8,'VANR-10',10,'VANR','VANR-10',10,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(31,8,'DEVP-8',8,'DEVP','DEVP-8',8,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(32,8,'SCHL-14',14,'SCHL','SCHL-14',14,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(33,17,'SCHL-15',15,'SCHL','SCHL-15',15,'7','/7','/6000','2023-05-30','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(34,18,'VANR-11',11,'VANR','VANR-11',11,'5','/5','/3000','2023-05-30','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(35,18,'SCHL-16',16,'SCHL','SCHL-16',16,'7','/7','/6000','2023-05-30','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(36,19,'SCHL-17',17,'SCHL','SCHL-17',17,'7','/7','/6000','2023-05-29','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(37,20,'VANR-12',12,'VANR','VANR-12',12,'5','/5','/3000','2023-05-29','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(38,20,'DEVP-9',9,'DEVP','DEVP-9',9,'6','/6','/5000','2023-05-29','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(39,21,'SCHL-18',18,'SCHL','SCHL-18',18,'7','/7','/6000','2023-05-24','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(40,22,'DEVP-10',10,'DEVP','DEVP-10',10,'6','/6','/5000','2023-05-18','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(41,22,'SCHL-19',19,'SCHL','SCHL-19',19,'7','/7','/6000','2023-05-18','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(42,23,'SCHL-20',20,'SCHL','SCHL-20',20,'7','/7','/12000','2023-05-15','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(43,21,'SCHL-21',21,'SCHL','SCHL-21',21,'7','/7','/6000','2023-05-24','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(44,25,'VANR-13',13,'VANR','VANR-13',13,'4','/4','/2000','2023-06-02','Cash','',0,0,2000,2000,1,'adminFees',NULL),
(45,26,'VANR-14',14,'VANR','VANR-14',14,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(46,26,'SCHL-22',22,'SCHL','SCHL-22',22,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(47,27,'SCHL-23',23,'SCHL','SCHL-23',23,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(48,28,'VANR-15',15,'VANR','VANR-15',15,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(49,28,'SCHL-24',24,'SCHL','SCHL-24',24,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(50,29,'DEVP-11',11,'DEVP','DEVP-11',11,'6','/6','/5000','2023-06-02','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(51,29,'SCHL-25',25,'SCHL','SCHL-25',25,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(52,30,'VANR-16',16,'VANR','VANR-16',16,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(53,30,'SCHL-26',26,'SCHL','SCHL-26',26,'7','/7','/12000','2023-06-02','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(54,31,'VANR-17',17,'VANR','VANR-17',17,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(55,31,'DEVP-12',12,'DEVP','DEVP-12',12,'6','/6','/5000','2023-06-02','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(56,31,'SCHL-27',27,'SCHL','SCHL-27',27,'7','/7','/12000','2023-06-02','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(57,32,'VANR-18',18,'VANR','VANR-18',18,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(58,32,'SCHL-28',28,'SCHL','SCHL-28',28,'7','/7','/6000','2023-06-02','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(122,64,'DEVP-28',28,'DEVP','DEVP-28',28,'6','/6','/5000','2023-06-01','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(60,33,'SCHL-30',30,'SCHL','SCHL-30',30,'8','/2','/7000','2023-06-05','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(61,33,'VANR-19',19,'VANR','VANR-19',19,'5','/5','/3000','2023-06-05','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(62,33,'DEVP-13',13,'DEVP','DEVP-13',13,'6','/6','/5000','2023-06-05','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(63,34,'DEVP-14',14,'DEVP','DEVP-14',14,'6','/6','/5000','2023-06-01','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(64,34,'SCHL-31',31,'SCHL','SCHL-31',31,'8','/2','/7000','2023-06-01','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(118,62,'SCHL-57',57,'SCHL','SCHL-57',57,'8','/2','/7000','2023-06-06','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(117,35,'SCHL-56',56,'SCHL','SCHL-56',56,'8','/2','/7000','2023-06-01','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(67,35,'VANR-20',20,'VANR','VANR-20',20,'5','/5','/3000','2023-06-01','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(68,35,'DEVP-15',15,'DEVP','DEVP-15',15,'6','/6','/5000','2023-06-01','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(69,36,'VANR-21',21,'VANR','VANR-21',21,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(70,36,'DEVP-16',16,'DEVP','DEVP-16',16,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(71,36,'SCHL-34',34,'SCHL','SCHL-34',34,'8','/2','/7000','2023-06-02','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(72,37,'VANR-22',22,'VANR','VANR-22',22,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(73,37,'DEVP-17',17,'DEVP','DEVP-17',17,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(74,38,'VANR-23',23,'VANR','VANR-23',23,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(75,38,'DEVP-18',18,'DEVP','DEVP-18',18,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(76,38,'SCHL-35',35,'SCHL','SCHL-35',35,'8','/2','/7000','2023-06-02','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(77,39,'VANR-24',24,'VANR','VANR-24',24,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(78,39,'DEVP-19',19,'DEVP','DEVP-19',19,'6','/6','/4000','2023-06-02','Cash','',0,0,4000,4000,1,'adminFees',NULL),
(79,39,'SCHL-36',36,'SCHL','SCHL-36',36,'8','/2','/7000','2023-06-02','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(80,40,'VANR-25',25,'VANR','VANR-25',25,'5','/5','/3000','2023-05-29','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(81,40,'DEVP-20',20,'DEVP','DEVP-20',20,'6','/6','/5000','2023-05-29','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(82,40,'SCHL-37',37,'SCHL','SCHL-37',37,'8','/2','/7000','2023-05-29','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(83,41,'SCHL-38',38,'SCHL','SCHL-38',38,'8','/2','/7000','2023-05-30','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(84,42,'VANR-26',26,'VANR','VANR-26',26,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(85,42,'SCHL-39',39,'SCHL','SCHL-39',39,'7','/7','/6000','2023-06-06','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(86,43,'VANR-27',27,'VANR','VANR-27',27,'5','/5','/3000','2023-06-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(87,43,'SCHL-40',40,'SCHL','SCHL-40',40,'7','/7','/6000','2023-06-07','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(88,44,'SCHL-41',41,'SCHL','SCHL-41',41,'7','/7','/12000','2023-06-06','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(89,45,'DEVP-21',21,'DEVP','DEVP-21',21,'6','/6','/5000','2023-06-06','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(90,45,'SCHL-42',42,'SCHL','SCHL-42',42,'7','/7','/12000','2023-06-06','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(91,46,'DEVP-22',22,'DEVP','DEVP-22',22,'6','/6','/5000','2023-06-06','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(92,46,'SCHL-43',43,'SCHL','SCHL-43',43,'7','/7','/12000','2023-06-06','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(93,47,'VANR-28',28,'VANR','VANR-28',28,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(94,48,'VANR-29',29,'VANR','VANR-29',29,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(95,49,'SCHL-44',44,'SCHL','SCHL-44',44,'7','/7','/12000','2023-06-06','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(96,50,'SCHL-45',45,'SCHL','SCHL-45',45,'7','/7','/12000','2023-06-06','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(97,51,'VANR-30',30,'VANR','VANR-30',30,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(98,51,'SCHL-46',46,'SCHL','SCHL-46',46,'7','/7','/6000','2023-06-06','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(99,52,'VANR-31',31,'VANR','VANR-31',31,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(100,52,'SCHL-47',47,'SCHL','SCHL-47',47,'7','/7','/6000','2023-06-06','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(101,53,'SCHL-48',48,'SCHL','SCHL-48',48,'7','/7','/6000','2023-06-05','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(102,54,'VANR-32',32,'VANR','VANR-32',32,'5','/5','/3000','2023-06-02','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(103,54,'SCHL-49',49,'SCHL','SCHL-49',49,'7','/7','/12000','2023-06-02','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(104,55,'VANR-33',33,'VANR','VANR-33',33,'5','/5','/3000','2023-06-05','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(105,55,'SCHL-50',50,'SCHL','SCHL-50',50,'7','/7','/6000','2023-06-05','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(106,56,'DEVP-23',23,'DEVP','DEVP-23',23,'6','/6','/5000','2023-06-03','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(107,56,'SCHL-51',51,'SCHL','SCHL-51',51,'7','/7','/6000','2023-06-03','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(108,57,'SCHL-52',52,'SCHL','SCHL-52',52,'8','/2','/7000','2023-06-09','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(109,58,'DEVP-24',24,'DEVP','DEVP-24',24,'6','/6','/5000','2023-06-08','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(110,59,'VANR-34',34,'VANR','VANR-34',34,'5','/5','/3000','2023-06-08','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(111,59,'DEVP-25',25,'DEVP','DEVP-25',25,'6','/6','/5000','2023-06-08','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(112,59,'SCHL-53',53,'SCHL','SCHL-53',53,'8','/2','/7000','2023-06-08','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(113,60,'SCHL-54',54,'SCHL','SCHL-54',54,'8','/2','/7000','2023-06-07','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(114,61,'VANR-35',35,'VANR','VANR-35',35,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(115,61,'DEVP-26',26,'DEVP','DEVP-26',26,'6','/6','/5000','2023-06-06','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(116,61,'SCHL-55',55,'SCHL','SCHL-55',55,'8','/2','/7000','2023-06-06','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(119,63,'VANR-36',36,'VANR','VANR-36',36,'5','/5','/3000','2023-06-06','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(120,63,'DEVP-27',27,'DEVP','DEVP-27',27,'6','/6','/5000','2023-06-06','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(121,63,'SCHL-58',58,'SCHL','SCHL-58',58,'8','/2','/7000','2023-06-06','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(123,64,'SCHL-59',59,'SCHL','SCHL-59',59,'8','/2','/7000','2023-06-01','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(124,65,'VANR-37',37,'VANR','VANR-37',37,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(125,65,'DEVP-29',29,'DEVP','DEVP-29',29,'6','/6','/5000','2023-06-09','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(126,66,'DEVP-30',30,'DEVP','DEVP-30',30,'6','/6','/5000','2023-06-12','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(127,66,'SCHL-60',60,'SCHL','SCHL-60',60,'8','/2','/7000','2023-06-12','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(128,67,'VANR-38',38,'VANR','VANR-38',38,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(129,67,'SCHL-61',61,'SCHL','SCHL-61',61,'8','/2','/7000','2023-06-12','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(130,68,'VANR-39',39,'VANR','VANR-39',39,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(131,69,'VANR-40',40,'VANR','VANR-40',40,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(132,69,'SCHL-62',62,'SCHL','SCHL-62',62,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(133,70,'SCHL-63',63,'SCHL','SCHL-63',63,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(134,71,'SCHL-64',64,'SCHL','SCHL-64',64,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(135,72,'VANR-41',41,'VANR','VANR-41',41,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(136,72,'SCHL-65',65,'SCHL','SCHL-65',65,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(137,73,'VANR-42',42,'VANR','VANR-42',42,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(138,73,'SCHL-66',66,'SCHL','SCHL-66',66,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(139,74,'SCHL-67',67,'SCHL','SCHL-67',67,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(140,75,'SCHL-68',68,'SCHL','SCHL-68',68,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(141,76,'VANR-43',43,'VANR','VANR-43',43,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(142,76,'SCHL-69',69,'SCHL','SCHL-69',69,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(145,77,'VANR-45',45,'VANR','VANR-45',45,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(144,17,'VANR-44',44,'VANR','VANR-44',44,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(146,77,'SCHL-70',70,'SCHL','SCHL-70',70,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(147,78,'VANR-46',46,'VANR','VANR-46',46,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(148,78,'SCHL-71',71,'SCHL','SCHL-71',71,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(149,79,'VANR-47',47,'VANR','VANR-47',47,'5','/5','/3000','2023-06-12','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(150,79,'DEVP-31',31,'DEVP','DEVP-31',31,'6','/6','/5000','2023-06-12','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(151,79,'SCHL-72',72,'SCHL','SCHL-72',72,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(152,80,'VANR-48',48,'VANR','VANR-48',48,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(153,80,'SCHL-73',73,'SCHL','SCHL-73',73,'7','/7','/6000','2023-06-09','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(154,81,'VANR-49',49,'VANR','VANR-49',49,'5','/5','/3000','2023-06-08','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(155,81,'DEVP-32',32,'DEVP','DEVP-32',32,'6','/6','/5000','2023-06-08','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(156,81,'SCHL-74',74,'SCHL','SCHL-74',74,'7','/7','/6000','2023-06-08','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(157,82,'VANR-50',50,'VANR','VANR-50',50,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(158,82,'SCHL-75',75,'SCHL','SCHL-75',75,'7','/7','/6000','2023-06-09','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(159,83,'VANR-51',51,'VANR','VANR-51',51,'5','/5','/3000','2023-06-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(160,83,'SCHL-76',76,'SCHL','SCHL-76',76,'7','/7','/12000','2023-06-07','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(161,84,'VANR-52',52,'VANR','VANR-52',52,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(162,84,'SCHL-77',77,'SCHL','SCHL-77',77,'7','/7','/6000','2023-06-09','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(163,85,'VANR-53',53,'VANR','VANR-53',53,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(164,85,'SCHL-78',78,'SCHL','SCHL-78',78,'7','/7','/6000','2023-06-09','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(165,86,'SCHL-79',79,'SCHL','SCHL-79',79,'7','/7','/12000','2023-06-08','Cash','',0,0,12000,12000,1,'adminFees',NULL),
(166,87,'VANR-54',54,'VANR','VANR-54',54,'5','/5','/3000','2023-06-09','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(167,87,'SCHL-80',80,'SCHL','SCHL-80',80,'7','/7','/6000','2023-06-09','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(168,88,'VANR-55',55,'VANR','VANR-55',55,'5','/5','/3000','2023-06-08','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(169,88,'DEVP-33',33,'DEVP','DEVP-33',33,'6','/6','/5000','2023-06-08','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(170,89,'DEVP-34',34,'DEVP','DEVP-34',34,'6','/6','/5000','2023-06-13','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(171,90,'SCHL-81',81,'SCHL','SCHL-81',81,'7','/7','/6000','2023-06-13','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(172,91,'VANR-56',56,'VANR','VANR-56',56,'5','/5','/3000','2023-06-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(173,91,'DEVP-35',35,'DEVP','DEVP-35',35,'6','/6','/5000','2023-06-13','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(174,92,'VANR-57',57,'VANR','VANR-57',57,'5','/5','/3000','2023-06-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(175,92,'SCHL-82',82,'SCHL','SCHL-82',82,'7','/7','/6000','2023-06-13','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(176,93,'VANR-58',58,'VANR','VANR-58',58,'5','/5','/3000','2023-06-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(177,94,'VANR-59',59,'VANR','VANR-59',59,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(178,94,'SCHL-83',83,'SCHL','SCHL-83',83,'7','/7','/6000','2023-06-16','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(179,95,'SCHL-84',84,'SCHL','SCHL-84',84,'7','/7','/6000','2023-06-16','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(180,96,'VANR-60',60,'VANR','VANR-60',60,'5','/5','/3000','2023-06-14','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(181,96,'DEVP-36',36,'DEVP','DEVP-36',36,'6','/6','/5000','2023-06-14','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(182,96,'SCHL-85',85,'SCHL','SCHL-85',85,'7','/7','/6000','2023-06-14','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(183,97,'VANR-61',61,'VANR','VANR-61',61,'5','/5','/3000','2023-06-14','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(184,97,'SCHL-86',86,'SCHL','SCHL-86',86,'7','/7','/6000','2023-06-14','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(185,98,'SCHL-87',87,'SCHL','SCHL-87',87,'7','/7','/6000','2023-06-14','Cash','',0,0,6000,6000,1,'adminFees',NULL),
(186,99,'VANR-62',62,'VANR','VANR-62',62,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(187,99,'DEVP-37',37,'DEVP','DEVP-37',37,'6','/6','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(188,99,'SCHL-88',88,'SCHL','SCHL-88',88,'8','/2','/7000','2023-06-16','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(189,100,'VANR-63',63,'VANR','VANR-63',63,'9','/9','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(190,101,'VANR-64',64,'VANR','VANR-64',64,'5','/5','/3000','2023-06-15','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(191,101,'SCHL-89',89,'SCHL','SCHL-89',89,'8','/2','/7000','2023-06-15','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(192,102,'SCHL-90',90,'SCHL','SCHL-90',90,'8','/2','/14000','2023-08-01','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(193,103,'VANR-65',65,'VANR','VANR-65',65,'5','/5','/3000','2023-07-27','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(194,103,'SCHL-91',91,'SCHL','SCHL-91',91,'8','/2','/7000','2023-07-27','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(195,104,'VANR-66',66,'VANR','VANR-66',66,'5','/5','/3000','2023-07-15','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(196,104,'SCHL-92',92,'SCHL','SCHL-92',92,'8','/2','/14000','2023-07-15','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(197,105,'VANR-67',67,'VANR','VANR-67',67,'5','/5','/3000','2023-07-15','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(198,105,'SCHL-93',93,'SCHL','SCHL-93',93,'8','/2','/14000','2023-07-15','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(199,106,'VANR-68',68,'VANR','VANR-68',68,'5','/5','/3000','2023-07-24','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(200,106,'DEVP-38',38,'DEVP','DEVP-38',38,'6','/6','/5000','2023-07-24','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(201,106,'SCHL-94',94,'SCHL','SCHL-94',94,'8','/2','/7000','2023-07-24','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(202,107,'VANR-69',69,'VANR','VANR-69',69,'5','/5','/3000','2023-07-24','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(203,107,'DEVP-39',39,'DEVP','DEVP-39',39,'6','/6','/5000','2023-07-24','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(204,107,'SCHL-95',95,'SCHL','SCHL-95',95,'8','/2','/7000','2023-07-24','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(205,108,'SCHL-96',96,'SCHL','SCHL-96',96,'8','/2','/7000','2023-07-21','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(206,109,'VANR-70',70,'VANR','VANR-70',70,'5','/5','/3000','2023-07-21','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(207,109,'SCHL-97',97,'SCHL','SCHL-97',97,'8','/2','/7000','2023-07-21','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(208,110,'SCHL-98',98,'SCHL','SCHL-98',98,'8','/2','/14000','2023-07-01','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(209,111,'VANR-71',71,'VANR','VANR-71',71,'5','/5','/3000','2023-07-19','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(210,111,'SCHL-99',99,'SCHL','SCHL-99',99,'8','/2','/7000','2023-07-19','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(214,112,'VANR-73',73,'VANR','VANR-73',73,'5','/5','/3000','2023-07-14','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(212,108,'VANR-72',72,'VANR','VANR-72',72,'5','/5','/3000','2023-07-19','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(213,108,'DEVP-40',40,'DEVP','DEVP-40',40,'6','/6','/5000','2023-07-19','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(215,112,'DEVP-41',41,'DEVP','DEVP-41',41,'6','/6','/5000','2023-07-14','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(216,112,'SCHL-100',100,'SCHL','SCHL-100',100,'8','/2','/7000','2023-07-14','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(217,113,'SCHL-101',101,'SCHL','SCHL-101',101,'8','/2','/14000','2023-07-13','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(218,114,'SCHL-102',102,'SCHL','SCHL-102',102,'8','/2','/14000','2023-07-07','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(219,115,'SCHL-103',103,'SCHL','SCHL-103',103,'8','/2','/7000','2023-01-07','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(220,116,'SCHL-104',104,'SCHL','SCHL-104',104,'8','/2','/14000','2023-07-04','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(221,47,'SCHL-105',105,'SCHL','SCHL-105',105,'8','/2','/7000','2023-06-28','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(222,117,'SCHL-106',106,'SCHL','SCHL-106',106,'8','/2','/7000','2023-06-19','Cash','',0,0,7000,7000,1,'adminFees',NULL),
(223,118,'DEVP-42',42,'DEVP','DEVP-42',42,'6','/6','/5000','2023-06-17','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(224,119,'VANR-74',74,'VANR','VANR-74',74,'5','/5','/3000','2023-08-03','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(225,119,'SCHL-107',107,'SCHL','SCHL-107',107,'10','/3','/16000','2023-08-03','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(226,120,'SCHL-108',108,'SCHL','SCHL-108',108,'10','/3','/8000','2023-08-04','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(227,121,'SCHL-109',109,'SCHL','SCHL-109',109,'10','/3','/8000','2023-08-04','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(228,122,'VANR-75',75,'VANR','VANR-75',75,'5','/5','/3000','2023-08-03','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(229,122,'SCHL-110',110,'SCHL','SCHL-110',110,'10','/3','/16000','2023-08-03','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(230,123,'SCHL-111',111,'SCHL','SCHL-111',111,'10','/3','/16000','2023-08-01','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(231,124,'VANR-76',76,'VANR','VANR-76',76,'5','/5','/3000','2023-07-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(232,124,'DEVP-43',43,'DEVP','DEVP-43',43,'6','/6','/3000','2023-07-31','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(233,124,'SCHL-112',112,'SCHL','SCHL-112',112,'10','/3','/8000','2023-07-31','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(234,125,'SCHL-113',113,'SCHL','SCHL-113',113,'10','/3','/8000','2023-07-27','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(235,126,'SCHL-114',114,'SCHL','SCHL-114',114,'10','/3','/8000','2023-07-16','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(236,127,'VANR-77',77,'VANR','VANR-77',77,'5','/5','/3000','2023-07-25','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(237,127,'SCHL-115',115,'SCHL','SCHL-115',115,'10','/3','/16000','2023-07-25','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(238,128,'VANR-78',78,'VANR','VANR-78',78,'5','/5','/3000','2023-07-19','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(239,128,'DEVP-44',44,'DEVP','DEVP-44',44,'6','/6','/5000','2023-07-19','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(240,128,'SCHL-116',116,'SCHL','SCHL-116',116,'10','/3','/8000','2023-07-19','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(241,129,'SCHL-117',117,'SCHL','SCHL-117',117,'10','/3','/16000','2023-07-14','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(242,130,'SCHL-118',118,'SCHL','SCHL-118',118,'10','/3','/14000','2023-08-07','Cash','',0,0,14000,14000,1,'adminFees',NULL),
(243,131,'VANR-79',79,'VANR','VANR-79',79,'5','/5','/3000','2023-07-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(244,131,'DEVP-45',45,'DEVP','DEVP-45',45,'6','/6','/5000','2023-07-07','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(245,131,'SCHL-119',119,'SCHL','SCHL-119',119,'10','/3','/8000','2023-07-07','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(246,132,'VANR-80',80,'VANR','VANR-80',80,'5','/5','/3000','2023-07-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(247,132,'DEVP-46',46,'DEVP','DEVP-46',46,'6','/6','/3000','2023-07-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(248,132,'SCHL-120',120,'SCHL','SCHL-120',120,'10','/3','/8000','2023-07-07','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(249,133,'VANR-81',81,'VANR','VANR-81',81,'5','/5','/3000','2023-07-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(250,133,'DEVP-47',47,'DEVP','DEVP-47',47,'6','/6','/5000','2023-07-07','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(251,134,'SCHL-121',121,'SCHL','SCHL-121',121,'10','/3','/8000','2023-07-06','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(252,135,'VANR-82',82,'VANR','VANR-82',82,'5','/5','/3000','2023-06-20','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(253,135,'DEVP-48',48,'DEVP','DEVP-48',48,'6','/6','/5000','2023-06-20','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(254,135,'SCHL-122',122,'SCHL','SCHL-122',122,'10','/3','/8000','2023-06-20','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(255,136,'SCHL-123',123,'SCHL','SCHL-123',123,'10','/3','/16000','2023-08-08','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(256,137,'VANR-83',83,'VANR','VANR-83',83,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(257,137,'SCHL-124',124,'SCHL','SCHL-124',124,'10','/3','/16000','2023-06-16','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(258,138,'VANR-84',84,'VANR','VANR-84',84,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(259,138,'SCHL-125',125,'SCHL','SCHL-125',125,'10','/3','/16000','2023-06-16','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(260,139,'VANR-85',85,'VANR','VANR-85',85,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(261,139,'DEVP-49',49,'DEVP','DEVP-49',49,'6','/6','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(262,139,'SCHL-126',126,'SCHL','SCHL-126',126,'10','/3','/16000','2023-06-16','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(263,140,'DEVP-50',50,'DEVP','DEVP-50',50,'6','/6','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(264,140,'VANR-86',86,'VANR','VANR-86',86,'9','/9','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(265,141,'VANR-87',87,'VANR','VANR-87',87,'5','/5','/3000','2023-06-16','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(266,141,'DEVP-51',51,'DEVP','DEVP-51',51,'6','/6','/5000','2023-06-16','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(267,141,'SCHL-127',127,'SCHL','SCHL-127',127,'10','/3','/8000','2023-06-16','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(268,142,'VANR-88',88,'VANR','VANR-88',88,'5','/5','/3000','2023-06-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(269,142,'DEVP-52',52,'DEVP','DEVP-52',52,'6','/6','/5000','2023-06-13','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(270,143,'VANR-89',89,'VANR','VANR-89',89,'5','/5','/3000','2023-06-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(271,143,'DEVP-53',53,'DEVP','DEVP-53',53,'6','/6','/5000','2023-06-13','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(272,143,'SCHL-128',128,'SCHL','SCHL-128',128,'10','/3','/8000','2023-06-13','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(273,144,'VANR-90',90,'VANR','VANR-90',90,'5','/5','/3000','2023-08-10','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(274,144,'SCHL-129',129,'SCHL','SCHL-129',129,'10','/3','/8000','2023-08-10','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(275,145,'SCHL-130',130,'SCHL','SCHL-130',130,'10','/3','/16000','2023-08-02','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(276,146,'SCHL-131',131,'SCHL','SCHL-131',131,'10','/3','/16000','2023-08-08','Cash','',0,0,16000,16000,1,'adminFees',NULL),
(277,147,'SCHL-132',132,'SCHL','SCHL-132',132,'10','/3','/8000','2023-08-08','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(278,148,'VANR-91',91,'VANR','VANR-91',91,'5','/5','/3000','2023-08-08','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(279,148,'SCHL-133',133,'SCHL','SCHL-133',133,'10','/3','/8000','2023-08-08','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(280,149,'VANR-92',92,'VANR','VANR-92',92,'5','/5','/3000','2023-08-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(281,149,'SCHL-134',134,'SCHL','SCHL-134',134,'10','/3','/8000','2023-08-07','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(282,150,'VANR-93',93,'VANR','VANR-93',93,'5','/5','/3000','2023-08-07','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(283,150,'SCHL-135',135,'SCHL','SCHL-135',135,'10','/3','/8000','2023-08-07','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(284,151,'SCHL-136',136,'SCHL','SCHL-136',136,'10','/3','/8000','2023-08-13','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(285,152,'VANR-94',94,'VANR','VANR-94',94,'5','/5','/3000','2023-08-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(286,152,'DEVP-54',54,'DEVP','DEVP-54',54,'6','/6','/5000','2023-08-13','Cash','',0,0,5000,5000,1,'adminFees',NULL),
(287,153,'VANR-95',95,'VANR','VANR-95',95,'5','/5','/3000','2023-08-13','Cash','',0,0,3000,3000,1,'adminFees',NULL),
(288,153,'DEVP-55',55,'DEVP','DEVP-55',55,'6','/6','/2500','2023-08-13','Cash','',0,0,2500,2500,1,'adminFees',NULL),
(289,154,'SCHL-137',137,'SCHL','SCHL-137',137,'10','/3','/8000','2023-06-12','Cash','',0,0,8000,8000,1,'adminFees',NULL),
(290,155,'SCHL-138',138,'SCHL','SCHL-138',138,'10','/3','/8000','2023-06-06','Cash','',0,0,8000,8000,1,'adminFees',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
(65,35,'SCHL-32',32,'SCHL','SCHL-32',32,'8','/2','/7000','2023-06-01','Cash','',0,0,7000,7000,1,'adminFees','2023-06-12 05:35 18'),
(66,35,'SCHL-33',33,'SCHL','SCHL-33',33,'8','/2','/7000','2023-06-01','Cash','',0,0,7000,7000,1,'adminFees','2023-06-12 05:35 34'),
(59,33,'SCHL-29',29,'SCHL','SCHL-29',29,'8','/2','/7000','2023-06-05','Cash','',0,0,7000,7000,1,'adminFees','2023-06-13 08:48 23'),
(143,17,'SCHL-70',70,'SCHL','SCHL-70',70,'7','/7','/6000','2023-06-12','Cash','',0,0,6000,6000,1,'adminFees','2023-06-13 09:57 40'),
(211,108,'SCHL-100',100,'SCHL','SCHL-100',100,'8','/2','/7000','2023-07-19','Cash','',0,0,7000,7000,1,'adminFees','2023-08-07 05:35 48');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES
(2,'Transactions'),
(3,'Income'),
(4,'Expense'),
(5,'Accounts'),
(6,'Track Budget'),
(7,'Set Goals'),
(8,'Calendar'),
(9,'Income Category'),
(10,'Expense Category'),
(11,'Income Reports'),
(12,'Expense Category'),
(13,'Income vs Expense Reports'),
(14,'Income Monthly Report'),
(15,'Expense Monthly Report'),
(16,'Account Transaction Reports'),
(17,'User Role'),
(18,'Application Setting'),
(19,'Upcoming Income'),
(20,'Upcoming Expense');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
INSERT INTO `roleaccess` VALUES
(18,2,1),
(19,3,1),
(20,4,1),
(21,5,1),
(22,6,1),
(23,7,1),
(24,8,1),
(25,9,1),
(26,10,1),
(27,11,1),
(28,12,1),
(29,13,1),
(30,14,1),
(31,15,1),
(32,16,1),
(33,17,1),
(34,18,1),
(35,19,1),
(36,20,1);
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(1,'Evi money','Batam','Golden Land Btams','E vision infotech','0898999893434','mplogo.png','Rs','en','d/m/Y');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=156 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
('Vinayak D Sonti',1,'Male','1','A','',0,'',NULL,0,NULL),
('Shreya B Wali',2,'Male','2','A','',0,'',NULL,0,NULL),
('Srujan B Sankanur',3,'Male','1','A','',0,'',NULL,0,NULL),
('Abhishek R Angadi',4,'Male','1','A','',0,'',NULL,0,NULL),
('Sanvi K Shabadi',5,'Male','1','A','',0,'',NULL,0,NULL),
('Jeevan K Shabadi',6,'Male','4','A','',0,'',NULL,0,NULL),
('Amit M Gora',7,'Male','3','A','',0,'',NULL,0,NULL),
('Rohan K Gora',8,'Male','2','A','',0,'',NULL,0,NULL),
('Prasanna P Gora',9,'Male','3','A','',0,'',NULL,0,NULL),
('Mahesh K Gora',10,'Male','3','A','',0,'',NULL,0,NULL),
('Santosh Pawar',11,'Male','1','A','',0,'',NULL,0,NULL),
('Preetam Joshi',12,'Male','1','A','',0,'',NULL,0,NULL),
('Satvik Halabagil',13,'Male','1','A','',0,'',NULL,0,NULL),
('Harish K Raibagi',14,'Male','3','A','',0,'',NULL,0,NULL),
('Satvik R Bhajantri',15,'Male','1','A','',0,'',NULL,0,NULL),
('Pranavi A Ranjanagi',16,'Male','2','A','',0,'',NULL,0,NULL),
('Faheem Hullur',17,'Male','1','A','',0,'',NULL,0,NULL),
('Anushree S Chalawadi',18,'Male','1','A','',0,'',NULL,0,NULL),
('Priyanka Koli',19,'Male','1','A','',0,'',NULL,0,NULL),
('Aishwara P Kalalbandi',20,'Male','2','A','',0,'',NULL,0,NULL),
('Priyanka K Kattimani',21,'Male','1','A','',0,'',NULL,0,NULL),
('Raghav R Khonapur',22,'Male','3','A','',0,'',NULL,0,NULL),
('Prasad Dharekar ',23,'Male','1','A','',0,'',NULL,0,NULL),
('Sindhu Koli',25,'Male','LKG','A','',0,'',NULL,0,NULL),
('Sinchana S Kambali',26,'Male','1','A','',0,'',NULL,0,NULL),
('Mehaboob Alishah N Makandar',27,'Male','1','A','',0,'',NULL,0,NULL),
('Punarvi Cholin',28,'Male','1','A','',0,'',NULL,0,NULL),
('Akash M Gudur',29,'Male','2','A','',0,'',NULL,0,NULL),
('Sanidhya N Savadi',30,'Male','1','A','',0,'',NULL,0,NULL),
('Adhya N Savadi',31,'Male','4','A','',0,'',NULL,0,NULL),
('Mohammad Adil Tatagar',32,'Male','1','A','',0,'',NULL,0,NULL),
('Shifa Maranabasari',33,'Male','5','A','',0,'',NULL,0,NULL),
('Vfeeresh B Wali',34,'Male','5','A','',0,'',NULL,0,NULL),
('Vijayalaxmi D Sonti',35,'Male','5','A','',0,'','',0,NULL),
('Bhavani M Gora',36,'Male','6','A','',0,'',NULL,0,NULL),
('Shreya N Gora',37,'Male','6','A','',0,'',NULL,0,NULL),
('Malakoji K Gora',38,'Male','6','A','',0,'',NULL,0,NULL),
('Arjun N Gora',39,'Male','5','A','',0,'',NULL,0,NULL),
('Shivakumar V Chalageri',40,'Male','6','A','',0,'',NULL,0,NULL),
('Safeeena Hullur',41,'Male','6','A','',0,'',NULL,0,NULL),
('Sinchana Baliger',42,'Male','3','A','',0,'',NULL,0,NULL),
('Manushree Yewoor',43,'Male','4','A','',0,'',NULL,0,NULL),
('Pratham Rangrej',44,'Male','2','A','',0,'',NULL,0,NULL),
('Roshi Rangrej',45,'Male','4','A','',0,'',NULL,0,NULL),
('Sakshi Rangrej',46,'Male','4','A','',0,'',NULL,0,NULL),
('Afifa Toragal',47,'Male','5','A','',0,'',NULL,0,NULL),
('Arif Toragal',48,'Male','2','A','',0,'',NULL,0,NULL),
('Prem Raibagi',49,'Male','1','A','',0,'',NULL,0,NULL),
('Prajwal Raibagi',50,'Male','4','A','',0,'',NULL,0,NULL),
('Premanjali Pommar',51,'Male','1','A','',0,'',NULL,0,NULL),
('Harsha Pujar',52,'Male','2','A','',0,'',NULL,0,NULL),
('Samnvita Pagi',53,'Male','1','A','',0,'',NULL,0,NULL),
('Noorain Fathima Dindawad',54,'Male','1','A','',0,'',NULL,0,NULL),
('Ganavi S Changali',55,'Male','1','A','',0,'',NULL,0,NULL),
('Chandan Raibagi',56,'Male','4','A','',0,'',NULL,0,NULL),
('Harshagouda B',57,'Male','5','A','',0,'',NULL,0,NULL),
('Shashanth Hugar',58,'Male','6','A','',0,'',NULL,0,NULL),
('Prathibha Ingale',59,'Male','5','A','',0,'',NULL,0,NULL),
('Sinchana Javoor',60,'Male','5','A','',0,'',NULL,0,NULL),
('Manojaraj P Savanur',61,'Male','7','A','',0,'',NULL,0,NULL),
('Vaibhav Ghorpade',62,'Male','5','A','',0,'',NULL,0,NULL),
('Subhash Mudaliyar',63,'Male','7','A','',0,'',NULL,0,NULL),
('Veeresh B Wali',64,'Male','5','A','',0,'',NULL,0,NULL),
('Husena K Shinganagutti',65,'Male','6','A','',0,'',NULL,0,NULL),
('Malatesh Chavani',66,'Male','6','A','',0,'',NULL,0,NULL),
('Ajit Medar',67,'Male','5','A','',0,'',NULL,0,NULL),
('Anjali Medar',68,'Male','6','A','',0,'',NULL,0,NULL),
('Sangamesh Cholin',69,'Male','3','A','',0,'',NULL,0,NULL),
('Soujanya Goudar',70,'Male','1','A','',0,'',NULL,0,NULL),
('Kalakanagouda Goudar',71,'Male','1','A','',0,'',NULL,0,NULL),
('Varsha Motagi',72,'Male','2','A','',0,'',NULL,0,NULL),
('Achintya Cholin',73,'Male','1','A','',0,'',NULL,0,NULL),
('Suchit Myageri',74,'Male','1','A','',0,'',NULL,0,NULL),
('Dhanya Jalihal',75,'Male','4','A','',0,'',NULL,0,NULL),
('Tejas Kalal',76,'Male','1','A','',0,'',NULL,0,NULL),
('Ashwat Medar',77,'Male','3','A','',0,'',NULL,0,NULL),
('Naveen Savanoor',78,'Male','2','A','',0,'',NULL,0,NULL),
('Shreyas V Rajur',79,'Male','2','A','',0,'',NULL,0,NULL),
('Govind Baliger',80,'Male','2','A','',0,'',NULL,0,NULL),
('Dakshit Rangej',81,'Male','4','A','',0,'',NULL,0,NULL),
('Nehal Bakali',82,'Male','1','A','',0,'',NULL,0,NULL),
('Poorvi Chavadimani',83,'Male','2','A','',0,'',NULL,0,NULL),
('Veda Bakale',84,'Male','3','A','',0,'',NULL,0,NULL),
('Tejas Bakale',85,'Male','2','A','',0,'',NULL,0,NULL),
('Akanksha Mahendrakar',86,'Male','2','A','',0,'',NULL,0,NULL),
('Aravind Nidagundi',87,'Male','1','A','',0,'',NULL,0,NULL),
('Sampat Nidagundi',88,'Male','3','A','',0,'',NULL,0,NULL),
('Ayush Miskin',89,'Male','2','A','',0,'',NULL,0,NULL),
('Vijayamahantesh S Shilaveri',90,'Male','1','A','',0,'',NULL,0,NULL),
('Akshara Meharwade',91,'Male','2','A','',0,'',NULL,0,NULL),
('Zaiba Vanti',92,'Male','1','A','',0,'',NULL,0,NULL),
('Nikhat Banu Vanti',93,'Male','6','A','',0,'',NULL,0,NULL),
('Amruta Hiremani',94,'Male','1','A','',0,'',NULL,0,NULL),
('Fayaz Hosapeti',95,'Male','1','A','',0,'',NULL,0,NULL),
('Sindhu M Koppal',96,'Male','2','A','',0,'',NULL,0,NULL),
('Bhuvan Pattanashetti',97,'Male','2','A','',0,'',NULL,0,NULL),
('Harish Raibagi',98,'Male','3','A','',0,'',NULL,0,NULL),
('Sanjana Shirur',99,'Male','6','A','',0,'',NULL,0,NULL),
('Adarsh Halagi',100,'Male','5','A','',0,'',NULL,0,NULL),
('Vishwanath S Sanganal',101,'Male','5','A','',0,'',NULL,0,NULL),
('Pratik Chavhan',102,'Male','7','A','',0,'',NULL,0,NULL),
('Ameer R Sankad',103,'Male','7','A','',0,'',NULL,0,NULL),
('Samarth S Malagi',104,'Male','6','A','',0,'',NULL,0,NULL),
('Keerti S Malagi',105,'Male','6','A','',0,'',NULL,0,NULL),
('Akshata Jalagar',106,'Male','7','A','',0,'',NULL,0,NULL),
('Amruta Jalagar',107,'Male','7','A','',0,'',NULL,0,NULL),
('Prasanna Maranabasari',108,'Male','6','A','',0,'',NULL,0,NULL),
('Sinchana Mudaliyar',109,'Male','6','A','',0,'',NULL,0,NULL),
('Kartik Kalagudi',110,'Male','5','A','',0,'',NULL,0,NULL),
('Bhimanna Yadahalli',111,'Male','6','A','',0,'',NULL,0,NULL),
('Shafeeya Vanti',112,'Male','7','A','',0,'',NULL,0,NULL),
('Vaishnavi F Dharekar',113,'Male','6','A','',0,'',NULL,0,NULL),
('Shreya Rangreji',114,'Male','5','A','',0,'',NULL,0,NULL),
('Samarth Chavani',115,'Male','5','A','',0,'',NULL,0,NULL),
('Sanvi Munji',116,'Male','5','A','',0,'',NULL,0,NULL),
('Pruthviraj N Kumbar',117,'Male','6','A','',0,'',NULL,0,NULL),
('Soumya P Adavi',118,'Male','6','A','',0,'',NULL,0,NULL),
('Sakshi Raibagi',119,'Male','8','A','',0,'',NULL,0,NULL),
('Vikas Palamari',120,'Male','8','A','',0,'',NULL,0,NULL),
('Vittal Palamari',121,'Male','9','A','',0,'',NULL,0,NULL),
('Bharat Maralabavi',122,'Male','9','A','',0,'',NULL,0,NULL),
('Preetham Chavhan',123,'Male','9','A','',0,'',NULL,0,NULL),
('Darshan Pattar',124,'Male','8','A','',0,'',NULL,0,NULL),
('Sahana Raibagi',125,'Male','10','A','',0,'',NULL,0,NULL),
('Almas Ronad',126,'Male','8','A','',0,'',NULL,0,NULL),
('Haseema M Jangleppanavar',127,'Male','8','A','',0,'',NULL,0,NULL),
('Vishal Gadag',128,'Male','8','A','',0,'',NULL,0,NULL),
('Anusha Sheelavantar',129,'Male','8','A','',0,'',NULL,0,NULL),
('Vaishnavi Kammar',130,'Male','8','A','',0,'',NULL,0,NULL),
('Pavan K Pande',131,'Male','8','A','',0,'',NULL,0,NULL),
('Santosh S Vyapari',132,'Male','8','A','',0,'',NULL,0,NULL),
('Rohit N Jadav',133,'Male','9','A','',0,'',NULL,0,NULL),
('Nutan Dollin',134,'Male','8','A','',0,'',NULL,0,NULL),
('Pruthvi Boragi',135,'Male','10','A','',0,'',NULL,0,NULL),
('Nikhil K Shettar',136,'Male','10','A','',0,'',NULL,0,NULL),
('Chetan Chavadimani',137,'Male','10','A','',0,'',NULL,0,NULL),
('Niraj Chavadimani',138,'Male','10','A','',0,'',NULL,0,NULL),
('Adesh A Gunde',139,'Male','8','A','',0,'',NULL,0,NULL),
('Megha Halagi',140,'Male','9','A','',0,'',NULL,0,NULL),
('Shankar Shirur',141,'Male','8','A','',0,'',NULL,0,NULL),
('Pradeep Savadi',142,'Male','8','A','',0,'',NULL,0,NULL),
('Sainath Dhumale',143,'Male','9','A','',0,'',NULL,0,NULL),
('Chinmayi Goudar',144,'Male','9','A','',0,'',NULL,0,NULL),
('Suhas S Mathad',145,'Male','8','A','',0,'',NULL,0,NULL),
('Samarth Parabat',146,'Male','8','A','',0,'',NULL,0,NULL),
('Punitkumar Kammar',147,'Male','8','A','',0,'',NULL,0,NULL),
('Amit Vasnad',148,'Male','9','A','',0,'',NULL,0,NULL),
('Veeresh Angadi',149,'Male','10','A','',0,'',NULL,0,NULL),
('Vinod Angadi',150,'Male','9','A','',0,'',NULL,0,NULL),
('Juniyad Nainapur',151,'Male','10','A','',0,'',NULL,0,NULL),
('Bhuvaneshwari Pujar',152,'Male','9','A','',0,'',NULL,0,NULL),
('Tilak G Chavadimani',153,'Male','8','A','',0,'',NULL,0,NULL),
('Venkatesh Potadar',154,'Male','8','A','',0,'',NULL,0,NULL),
('Nitin Chavadimani',155,'Male','9','A','',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=290 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
(4,1,7,7,12000,6000,6000,0,'',NULL),
(3,1,5,5,3000,3000,0,0,'',NULL),
(5,2,6,6,5000,5000,0,0,'',NULL),
(6,2,7,7,12000,6000,6000,0,'',NULL),
(10,4,5,5,3000,3000,0,0,'',NULL),
(8,3,7,7,12000,6000,6000,0,'',NULL),
(11,4,7,7,12000,6000,6000,0,'',NULL),
(12,5,7,7,12000,6000,6000,0,'',NULL),
(13,6,6,6,5000,5000,0,0,'',NULL),
(14,6,7,7,12000,6000,6000,0,'',NULL),
(15,7,5,5,3000,3000,0,0,'',NULL),
(16,7,6,6,5000,4000,1000,0,'',NULL),
(17,7,7,7,12000,6000,6000,0,'',NULL),
(18,8,5,5,3000,3000,0,0,'',NULL),
(19,8,6,6,5000,4000,1000,0,'',NULL),
(20,8,7,7,12000,6000,6000,0,'',NULL),
(21,9,5,5,3000,3000,0,0,'',NULL),
(22,9,6,6,5000,4000,1000,0,'',NULL),
(23,10,5,5,3000,3000,0,0,'',NULL),
(24,10,6,6,5000,4000,1000,0,'',NULL),
(25,11,5,5,3000,3000,0,0,'',NULL),
(26,11,7,7,12000,6000,6000,0,'',NULL),
(27,12,5,5,3000,3000,0,0,'',NULL),
(28,12,7,7,12000,6000,6000,0,'',NULL),
(29,13,5,5,3000,3000,0,0,'',NULL),
(30,13,7,7,12000,6000,6000,0,'',NULL),
(31,14,6,6,5000,5000,0,0,'',NULL),
(32,14,7,7,12000,6000,6000,0,'',NULL),
(33,15,7,7,12000,6000,6000,0,'',NULL),
(34,16,5,5,3000,3000,0,0,'',NULL),
(35,16,6,6,5000,5000,0,0,'',NULL),
(36,16,7,7,12000,6000,6000,0,'',NULL),
(37,17,7,7,12000,6000,6000,0,'',NULL),
(38,18,5,5,3000,3000,0,0,'',NULL),
(39,18,7,7,12000,6000,6000,0,'',NULL),
(40,19,7,7,12000,6000,6000,0,'',NULL),
(41,20,5,5,3000,3000,0,0,'',NULL),
(42,20,6,6,5000,5000,0,0,'',NULL),
(43,21,7,7,12000,12000,0,0,'',NULL),
(44,22,6,6,5000,5000,0,0,'',NULL),
(45,22,7,7,12000,6000,6000,0,'',NULL),
(46,23,7,7,12000,12000,0,0,'',NULL),
(48,25,4,4,2000,2000,0,0,'',NULL),
(49,26,5,5,3000,3000,0,0,'',NULL),
(50,26,7,7,12000,6000,6000,0,'',NULL),
(51,27,7,7,12000,6000,6000,0,'',NULL),
(52,28,5,5,3000,3000,0,0,'',NULL),
(53,28,7,7,12000,6000,6000,0,'',NULL),
(54,29,6,6,5000,5000,0,0,'',NULL),
(55,29,7,7,12000,6000,6000,0,'',NULL),
(56,30,5,5,3000,3000,0,0,'',NULL),
(57,30,7,7,12000,12000,0,0,'',NULL),
(58,31,5,5,3000,3000,0,0,'',NULL),
(59,31,6,6,5000,5000,0,0,'',NULL),
(60,31,7,7,12000,12000,0,0,'',NULL),
(61,32,5,5,3000,3000,0,0,'',NULL),
(62,32,7,7,12000,6000,6000,0,'',NULL),
(63,33,8,2,14000,7000,7000,0,'',NULL),
(64,33,5,5,3000,3000,0,0,'',NULL),
(65,33,6,6,5000,5000,0,0,'',NULL),
(66,34,6,6,5000,5000,0,0,'',NULL),
(67,34,8,2,14000,7000,7000,0,'',NULL),
(68,35,8,2,14000,7000,7000,0,'',NULL),
(69,35,5,5,3000,3000,0,0,'',NULL),
(70,35,6,6,5000,5000,0,0,'',NULL),
(71,36,5,5,3000,3000,0,0,'',NULL),
(72,36,6,6,5000,4000,1000,0,'',NULL),
(73,36,8,2,14000,7000,7000,0,'',NULL),
(74,37,5,5,3000,3000,0,0,'',NULL),
(75,37,6,6,5000,4000,1000,0,'',NULL),
(76,38,5,5,3000,3000,0,0,'',NULL),
(77,38,6,6,5000,4000,1000,0,'',NULL),
(78,38,8,2,14000,7000,7000,0,'',NULL),
(79,39,5,5,3000,3000,0,0,'',NULL),
(80,39,6,6,5000,4000,1000,0,'',NULL),
(81,39,8,2,14000,7000,7000,0,'',NULL),
(82,40,5,5,3000,3000,0,0,'',NULL),
(83,40,6,6,5000,5000,0,0,'',NULL),
(84,40,8,2,14000,7000,7000,0,'',NULL),
(85,41,8,2,14000,7000,7000,0,'',NULL),
(86,42,5,5,3000,3000,0,0,'',NULL),
(87,42,7,7,12000,6000,6000,0,'',NULL),
(88,43,5,5,3000,3000,0,0,'',NULL),
(89,43,7,7,12000,6000,6000,0,'',NULL),
(90,44,7,7,12000,12000,0,0,'',NULL),
(91,45,6,6,5000,5000,0,0,'',NULL),
(92,45,7,7,12000,12000,0,0,'',NULL),
(93,46,6,6,5000,5000,0,0,'',NULL),
(94,46,7,7,12000,12000,0,0,'',NULL),
(95,47,5,5,3000,3000,0,0,'',NULL),
(96,48,5,5,3000,3000,0,0,'',NULL),
(97,49,7,7,12000,12000,0,0,'',NULL),
(98,50,7,7,12000,12000,0,0,'',NULL),
(99,51,5,5,3000,3000,0,0,'',NULL),
(100,51,7,7,12000,6000,6000,0,'',NULL),
(101,52,5,5,3000,3000,0,0,'',NULL),
(102,52,7,7,12000,6000,6000,0,'',NULL),
(103,53,7,7,12000,6000,6000,0,'',NULL),
(104,54,5,5,3000,3000,0,0,'',NULL),
(105,54,7,7,12000,12000,0,0,'',NULL),
(106,55,5,5,3000,3000,0,0,'',NULL),
(107,55,7,7,12000,6000,6000,0,'',NULL),
(108,56,6,6,5000,5000,0,0,'',NULL),
(109,56,7,7,12000,6000,6000,0,'',NULL),
(110,57,8,2,14000,7000,7000,0,'',NULL),
(111,58,6,6,5000,5000,0,0,'',NULL),
(112,59,5,5,3000,3000,0,0,'',NULL),
(113,59,6,6,5000,5000,0,0,'',NULL),
(114,59,8,2,14000,7000,7000,0,'',NULL),
(115,60,8,2,14000,7000,7000,0,'',NULL),
(116,61,5,5,3000,3000,0,0,'',NULL),
(117,61,6,6,5000,5000,0,0,'',NULL),
(118,61,8,2,14000,7000,7000,0,'',NULL),
(119,62,8,2,14000,7000,7000,0,'',NULL),
(120,63,5,5,3000,3000,0,0,'',NULL),
(121,63,6,6,5000,5000,0,0,'',NULL),
(122,63,8,2,14000,7000,7000,0,'',NULL),
(123,64,6,6,5000,5000,0,0,'',NULL),
(124,64,8,2,14000,7000,7000,0,'',NULL),
(125,65,5,5,3000,3000,0,0,'',NULL),
(126,65,6,6,5000,5000,0,0,'',NULL),
(127,66,6,6,5000,5000,0,0,'',NULL),
(128,66,8,2,14000,7000,7000,0,'',NULL),
(129,67,5,5,3000,3000,0,0,'',NULL),
(130,67,8,2,14000,7000,7000,0,'',NULL),
(131,68,5,5,3000,3000,0,0,'',NULL),
(132,69,5,5,3000,3000,0,0,'',NULL),
(133,69,7,7,12000,6000,6000,0,'',NULL),
(134,70,7,7,12000,6000,6000,0,'',NULL),
(135,71,7,7,12000,6000,6000,0,'',NULL),
(136,72,5,5,3000,3000,0,0,'',NULL),
(137,72,7,7,12000,6000,6000,0,'',NULL),
(138,73,5,5,3000,3000,0,0,'',NULL),
(139,73,7,7,12000,6000,6000,0,'',NULL),
(140,74,7,7,12000,6000,6000,0,'',NULL),
(141,75,7,7,12000,6000,6000,0,'',NULL),
(142,76,5,5,3000,3000,0,0,'',NULL),
(143,76,7,7,12000,6000,6000,0,'',NULL),
(144,17,5,5,3000,3000,0,0,'',NULL),
(145,77,5,5,3000,3000,0,0,'',NULL),
(146,77,7,7,12000,6000,6000,0,'',NULL),
(147,78,5,5,3000,3000,0,0,'',NULL),
(148,78,7,7,12000,6000,6000,0,'',NULL),
(149,79,5,5,3000,3000,0,0,'',NULL),
(150,79,6,6,5000,5000,0,0,'',NULL),
(151,79,7,7,12000,6000,6000,0,'',NULL),
(152,80,5,5,3000,3000,0,0,'',NULL),
(153,80,7,7,12000,6000,6000,0,'',NULL),
(154,81,5,5,3000,3000,0,0,'',NULL),
(155,81,6,6,5000,5000,0,0,'',NULL),
(156,81,7,7,12000,6000,6000,0,'',NULL),
(157,82,5,5,3000,3000,0,0,'',NULL),
(158,82,7,7,12000,6000,6000,0,'',NULL),
(159,83,5,5,3000,3000,0,0,'',NULL),
(160,83,7,7,12000,12000,0,0,'',NULL),
(161,84,5,5,3000,3000,0,0,'',NULL),
(162,84,7,7,12000,6000,6000,0,'',NULL),
(163,85,5,5,3000,3000,0,0,'',NULL),
(164,85,7,7,12000,6000,6000,0,'',NULL),
(165,86,7,7,12000,12000,0,0,'',NULL),
(166,87,5,5,3000,3000,0,0,'',NULL),
(167,87,7,7,12000,6000,6000,0,'',NULL),
(168,88,5,5,3000,3000,0,0,'',NULL),
(169,88,6,6,5000,5000,0,0,'',NULL),
(170,89,6,6,5000,5000,0,0,'',NULL),
(171,90,7,7,12000,6000,6000,0,'',NULL),
(172,91,5,5,3000,3000,0,0,'',NULL),
(173,91,6,6,5000,5000,0,0,'',NULL),
(174,92,5,5,3000,3000,0,0,'',NULL),
(175,92,7,7,12000,6000,6000,0,'',NULL),
(176,93,5,5,3000,3000,0,0,'',NULL),
(177,94,5,5,3000,3000,0,0,'',NULL),
(178,94,7,7,12000,6000,6000,0,'',NULL),
(179,95,7,7,12000,6000,6000,0,'',NULL),
(180,96,5,5,3000,3000,0,0,'',NULL),
(181,96,6,6,5000,5000,0,0,'',NULL),
(182,96,7,7,12000,6000,6000,0,'',NULL),
(183,97,5,5,3000,3000,0,0,'',NULL),
(184,97,7,7,12000,6000,6000,0,'',NULL),
(185,98,7,7,12000,6000,6000,0,'',NULL),
(186,99,5,5,3000,3000,0,0,'',NULL),
(187,99,6,6,5000,5000,0,0,'',NULL),
(188,99,8,2,14000,7000,7000,0,'',NULL),
(189,100,9,9,5000,5000,0,0,'',NULL),
(190,101,5,5,3000,3000,0,0,'',NULL),
(191,101,8,2,14000,7000,7000,0,'',NULL),
(192,102,8,2,14000,14000,0,0,'',NULL),
(193,103,5,5,3000,3000,0,0,'',NULL),
(194,103,8,2,14000,7000,7000,0,'',NULL),
(195,104,5,5,3000,3000,0,0,'',NULL),
(196,104,8,2,14000,14000,0,0,'',NULL),
(197,105,5,5,3000,3000,0,0,'',NULL),
(198,105,8,2,14000,14000,0,0,'',NULL),
(199,106,5,5,3000,3000,0,0,'',NULL),
(200,106,6,6,5000,5000,0,0,'',NULL),
(201,106,8,2,14000,7000,7000,0,'',NULL),
(202,107,5,5,3000,3000,0,0,'',NULL),
(203,107,6,6,5000,5000,0,0,'',NULL),
(204,107,8,2,14000,7000,7000,0,'',NULL),
(205,108,8,2,14000,7000,7000,0,'',NULL),
(206,109,5,5,3000,3000,0,0,'',NULL),
(207,109,8,2,14000,7000,7000,0,'',NULL),
(208,110,8,2,14000,14000,0,0,'',NULL),
(209,111,5,5,3000,3000,0,0,'',NULL),
(210,111,8,2,14000,7000,7000,0,'',NULL),
(211,108,5,5,3000,3000,0,0,'',NULL),
(212,108,6,6,5000,5000,0,0,'',NULL),
(213,112,5,5,3000,3000,0,0,'',NULL),
(214,112,6,6,5000,5000,0,0,'',NULL),
(215,112,8,2,14000,7000,7000,0,'',NULL),
(216,113,8,2,14000,14000,0,0,'',NULL),
(217,114,8,2,14000,14000,0,0,'',NULL),
(218,115,8,2,14000,7000,7000,0,'',NULL),
(219,116,8,2,14000,14000,0,0,'',NULL),
(220,47,8,2,14000,7000,7000,0,'',NULL),
(221,117,8,2,14000,7000,7000,0,'',NULL),
(222,118,6,6,5000,5000,0,0,'',NULL),
(223,119,5,5,3000,3000,0,0,'',NULL),
(224,119,10,3,16000,16000,0,0,'',NULL),
(225,120,10,3,16000,8000,8000,0,'',NULL),
(226,121,10,3,16000,8000,8000,0,'',NULL),
(227,122,5,5,3000,3000,0,0,'',NULL),
(228,122,10,3,16000,16000,0,0,'',NULL),
(229,123,10,3,16000,16000,0,0,'',NULL),
(230,124,5,5,3000,3000,0,0,'',NULL),
(231,124,6,6,5000,3000,2000,0,'',NULL),
(232,124,10,3,16000,8000,8000,0,'',NULL),
(233,125,10,3,16000,8000,8000,0,'',NULL),
(234,126,10,3,16000,8000,8000,0,'',NULL),
(235,127,5,5,3000,3000,0,0,'',NULL),
(236,127,10,3,16000,16000,0,0,'',NULL),
(237,128,5,5,3000,3000,0,0,'',NULL),
(238,128,6,6,5000,5000,0,0,'',NULL),
(239,128,10,3,16000,8000,8000,0,'',NULL),
(240,129,10,3,16000,16000,0,0,'',NULL),
(241,130,10,3,16000,14000,2000,0,'',NULL),
(242,131,5,5,3000,3000,0,0,'',NULL),
(243,131,6,6,5000,5000,0,0,'',NULL),
(244,131,10,3,16000,8000,8000,0,'',NULL),
(245,132,5,5,3000,3000,0,0,'',NULL),
(246,132,6,6,5000,3000,2000,0,'',NULL),
(247,132,10,3,16000,8000,8000,0,'',NULL),
(248,133,5,5,3000,3000,0,0,'',NULL),
(249,133,6,6,5000,5000,0,0,'',NULL),
(250,134,10,3,16000,8000,8000,0,'',NULL),
(251,135,5,5,3000,3000,0,0,'',NULL),
(252,135,6,6,5000,5000,0,0,'',NULL),
(253,135,10,3,16000,8000,8000,0,'',NULL),
(254,136,10,3,16000,16000,0,0,'',NULL),
(255,137,5,5,3000,3000,0,0,'',NULL),
(256,137,10,3,16000,16000,0,0,'',NULL),
(257,138,5,5,3000,3000,0,0,'',NULL),
(258,138,10,3,16000,16000,0,0,'',NULL),
(259,139,5,5,3000,3000,0,0,'',NULL),
(260,139,6,6,5000,5000,0,0,'',NULL),
(261,139,10,3,16000,16000,0,0,'',NULL),
(262,140,6,6,5000,5000,0,0,'',NULL),
(263,140,9,9,5000,5000,0,0,'',NULL),
(264,141,5,5,3000,3000,0,0,'',NULL),
(265,141,6,6,5000,5000,0,0,'',NULL),
(266,141,10,3,16000,8000,8000,0,'',NULL),
(267,142,5,5,3000,3000,0,0,'',NULL),
(268,142,6,6,5000,5000,0,0,'',NULL),
(269,143,5,5,3000,3000,0,0,'',NULL),
(270,143,6,6,5000,5000,0,0,'',NULL),
(271,143,10,3,16000,8000,8000,0,'',NULL),
(272,144,5,5,3000,3000,0,0,'',NULL),
(273,144,10,3,16000,8000,8000,0,'',NULL),
(274,145,10,3,16000,16000,0,0,'',NULL),
(275,146,10,3,16000,16000,0,0,'',NULL),
(276,147,10,3,16000,8000,8000,0,'',NULL),
(277,148,5,5,3000,3000,0,0,'',NULL),
(278,148,10,3,16000,8000,8000,0,'',NULL),
(279,149,5,5,3000,3000,0,0,'',NULL),
(280,149,10,3,16000,8000,8000,0,'',NULL),
(281,150,5,5,3000,3000,0,0,'',NULL),
(282,150,10,3,16000,8000,8000,0,'',NULL),
(283,151,10,3,16000,8000,8000,0,'',NULL),
(284,152,5,5,3000,3000,0,0,'',NULL),
(285,152,6,6,5000,5000,0,0,'',NULL),
(286,153,5,5,3000,3000,0,0,'',NULL),
(287,153,6,6,5000,2500,2500,0,'',NULL),
(288,154,10,3,16000,8000,8000,0,'',NULL),
(289,155,10,3,16000,8000,8000,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=10 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
('School Fees LKG-UKG',1,'10000','N'),
('School Fees V-VII',2,'14000','N'),
('School Fees VIII-X',3,'16000','N'),
('Van Fees',4,'2000','N'),
('Van Fees I-X',5,'3000','N'),
('Development Fees V-X',6,'5000','N'),
('School Fees I -IV ',7,'12000','N'),
('School Fees V-VII',8,'14000','N'),
('van fees out side area',9,'5000','N');
/*!40000 ALTER TABLE `sub_head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subcategory`
--
DROP TABLE IF EXISTS `subcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subcategory` (
`subcategoryid` int(11) NOT NULL,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbladmin`
--
LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblbrand`
--
DROP TABLE IF EXISTS `tblbrand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblbrand` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BrandName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblbrand`
--
LOCK TABLES `tblbrand` WRITE;
/*!40000 ALTER TABLE `tblbrand` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblbrand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcart`
--
DROP TABLE IF EXISTS `tblcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcart` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductId` int(5) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`ProductQty` int(11) DEFAULT NULL,
`IsCheckOut` int(5) DEFAULT NULL,
`CartDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcart`
--
LOCK TABLES `tblcart` WRITE;
/*!40000 ALTER TABLE `tblcart` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcategory`
--
DROP TABLE IF EXISTS `tblcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategory`
--
LOCK TABLES `tblcategory` WRITE;
/*!40000 ALTER TABLE `tblcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcustomer`
--
DROP TABLE IF EXISTS `tblcustomer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcustomer` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BillingNumber` varchar(120) DEFAULT NULL,
`CustomerName` varchar(120) DEFAULT NULL,
`MobileNumber` bigint(11) DEFAULT NULL,
`ModeofPayment` varchar(50) DEFAULT NULL,
`BillingDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`),
KEY `BillingNumber` (`BillingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcustomer`
--
LOCK TABLES `tblcustomer` WRITE;
/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblproducts`
--
DROP TABLE IF EXISTS `tblproducts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblproducts` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(200) DEFAULT NULL,
`CatID` int(5) DEFAULT NULL,
`SubcatID` int(5) DEFAULT NULL,
`BrandName` varchar(200) DEFAULT NULL,
`ModelNumber` varchar(200) DEFAULT NULL,
`Stock` int(10) DEFAULT NULL,
`Price` decimal(10,0) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblproducts`
--
LOCK TABLES `tblproducts` WRITE;
/*!40000 ALTER TABLE `tblproducts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblproducts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblsubcategory`
--
DROP TABLE IF EXISTS `tblsubcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblsubcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CatID` int(5) DEFAULT NULL,
`SubCategoryname` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblsubcategory`
--
LOCK TABLES `tblsubcategory` WRITE;
/*!40000 ALTER TABLE `tblsubcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`reference` varchar(255) DEFAULT NULL,
`transactiondate` date NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
`file` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transaction`
--
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_permission`
--
DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`menu` varchar(500) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 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);
/*!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=93 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,'adminFees','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,'adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732');
/*!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@example.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','64qDSbAMpCJvTKQn9SKf7mBc2CERoU52i9ranCRCSRFCYUXUUUC9GbK43cxq','0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'rdk@example.com','rdk','$2y$10$2XvoA3Wh2KiFCJXsdIlw.ek83S.km8QNLiCXJjCrbjq0Vzo7hvPJO','Administrator','1234567890','Active','g7vopv4WL9XDdFijxOQwn1wATXsMQIqAZBGD9WIWsk8oXGVyOH94T1YxQyDa','2022-07-23 07:50:22','2022-07-23 07:50:22');
/*!40000 ALTER TABLE `users_new` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vochers`
--
DROP TABLE IF EXISTS `vochers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vochers` (
`Date` date NOT NULL,
`Cheque_Drop_Date` int(100) DEFAULT NULL,
`V_Id` int(11) NOT NULL AUTO_INCREMENT,
`v_counter` bigint(20) NOT NULL,
`Type` varchar(1000) NOT NULL,
`Cr_Ledger` varchar(1000) NOT NULL,
`Dr_Ledger` varchar(1000) NOT NULL,
`Cr_Ledger_Type` varchar(1000) NOT NULL,
`Dr_Ledger_Type` varchar(1000) NOT NULL,
`Cr_Amount` varchar(1000) NOT NULL,
`Dr_Amount` varchar(1000) NOT NULL,
`Nrtn` varchar(5000) NOT NULL,
PRIMARY KEY (`V_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vochers`
--
LOCK TABLES `vochers` WRITE;
/*!40000 ALTER TABLE `vochers` DISABLE KEYS */;
INSERT INTO `vochers` VALUES
('2023-06-01',NULL,1,1,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-01',NULL,2,2,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-06-01',NULL,3,3,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-05-29',NULL,4,4,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-06-02',NULL,5,5,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','90000','90000','Fees Collected'),
('2023-06-02',NULL,6,6,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','47000','47000','Fees Collected'),
('2023-06-02',NULL,7,7,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','42000','42000','Fees Collected'),
('2023-05-31',NULL,8,8,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-05-31',NULL,9,9,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','36000','36000','Fees Collected'),
('2023-05-31',NULL,10,10,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-30',NULL,11,11,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-05-30',NULL,12,12,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-05-29',NULL,13,13,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-05-29',NULL,14,14,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-05-24',NULL,15,15,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-05-18',NULL,16,16,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-05-18',NULL,17,17,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-05-15',NULL,18,18,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-06-02',NULL,19,19,'Recipt','Van Fees','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2023-06-05',NULL,20,20,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-05',NULL,21,21,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-05',NULL,22,22,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-01',NULL,23,23,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2023-06-02',NULL,24,24,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2023-05-29',NULL,25,25,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-05-30',NULL,26,26,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-06',NULL,27,27,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2023-06-06',NULL,28,28,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','78000','78000','Fees Collected'),
('2023-06-07',NULL,29,29,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-07',NULL,30,30,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-06',NULL,31,31,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-06-05',NULL,32,32,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-06-03',NULL,33,33,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-03',NULL,34,34,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-09',NULL,35,35,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-08',NULL,36,36,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-06-08',NULL,37,37,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-06-08',NULL,38,38,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-07',NULL,39,39,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-06',NULL,40,40,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2023-06-09',NULL,41,41,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-09',NULL,42,42,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-12',NULL,43,43,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-12',NULL,44,44,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-06-12',NULL,45,45,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','30000','30000','Fees Collected'),
('2023-06-12',NULL,46,46,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','66000','66000','Fees Collected'),
('2023-06-09',NULL,47,47,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','30000','30000','Fees Collected'),
('2023-06-08',NULL,48,48,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-13',NULL,49,49,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-06-13',NULL,50,50,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-06-13',NULL,51,51,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','15000','15000','Fees Collected'),
('2023-06-16',NULL,52,52,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-16',NULL,53,53,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2023-06-14',NULL,54,54,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-06-14',NULL,55,55,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-14',NULL,56,56,'Recipt','School Fees I -IV ','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-06-16',NULL,57,57,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-06-16',NULL,58,58,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-16',NULL,59,59,'Recipt','van fees out side area','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-06-15',NULL,60,60,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-06-15',NULL,61,61,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-08-01',NULL,62,62,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-07-27',NULL,63,63,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-27',NULL,64,64,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-07-15',NULL,65,65,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-07-15',NULL,66,66,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','28000','28000','Fees Collected'),
('2023-07-24',NULL,67,67,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-07-24',NULL,68,68,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-07-24',NULL,69,69,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-07-21',NULL,70,70,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-07-21',NULL,71,71,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-01',NULL,72,72,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-07-19',NULL,73,73,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-07-19',NULL,74,74,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-07-19',NULL,75,75,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-07-14',NULL,76,76,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-14',NULL,77,77,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-07-14',NULL,78,78,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-07-13',NULL,79,79,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-07-07',NULL,80,80,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-01-07',NULL,81,81,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-07-04',NULL,82,82,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2023-06-28',NULL,83,83,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-19',NULL,84,84,'Recipt','School Fees V-VII','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-06-17',NULL,85,85,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-08-03',NULL,86,86,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-08-03',NULL,87,87,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','32000','32000','Fees Collected'),
('2023-08-04',NULL,88,88,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-08-01',NULL,89,89,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-07-31',NULL,90,90,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-31',NULL,91,91,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-31',NULL,92,92,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-07-27',NULL,93,93,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-07-16',NULL,94,94,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-07-25',NULL,95,95,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-07-25',NULL,96,96,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-07-19',NULL,97,97,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-07-14',NULL,98,98,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-08-07',NULL,99,99,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','30000','30000','Fees Collected'),
('2023-07-07',NULL,100,100,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-07-07',NULL,101,101,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-07-07',NULL,102,102,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-07-06',NULL,103,103,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-06-20',NULL,104,104,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-06-20',NULL,105,105,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-20',NULL,106,106,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-08-08',NULL,107,107,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','48000','48000','Fees Collected'),
('2023-06-16',NULL,108,108,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','56000','56000','Fees Collected'),
('2023-06-13',NULL,109,109,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-08-10',NULL,110,110,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-10',NULL,111,111,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-08-02',NULL,112,112,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2023-08-08',NULL,113,113,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-08-07',NULL,114,114,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-08-13',NULL,115,115,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-08-13',NULL,116,116,'Recipt','Van Fees I-X','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-08-13',NULL,117,117,'Recipt','Development Fees V-X','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-08-12',NULL,118,118,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-06-06',NULL,119,119,'Recipt','School Fees VIII-X','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected');
/*!40000 ALTER TABLE `vochers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-07-18 0:00:18