|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.217.3 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/admin/backup/SNENG/../ORPS/../smrkp/ |
| [ 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_smrkp_Fees
-- ------------------------------------------------------
-- Server version 10.11.10-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Receipt_Head`
--
DROP TABLE IF EXISTS `Receipt_Head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Receipt_Head` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Section` varchar(1000) DEFAULT NULL,
`Head1` varchar(1000) DEFAULT NULL,
`Head2` varchar(1000) DEFAULT NULL,
`Head3` varchar(1000) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receipt_Head`
--
LOCK TABLES `Receipt_Head` WRITE;
/*!40000 ALTER TABLE `Receipt_Head` DISABLE KEYS */;
INSERT INTO `Receipt_Head` VALUES
(1,'school','Smt Rudramma S M Rudrayya swami English medium lower primary school','Kampli','');
/*!40000 ALTER TABLE `Receipt_Head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`accountnumber` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account`
--
LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_accounts`
--
DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`passwd` varchar(50) NOT NULL,
`admin_type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_accounts`
--
LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bankaccounts`
--
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Bank_Name` varchar(1000) NOT NULL,
`IFSC` varchar(1000) NOT NULL,
`Account_Number` varchar(1000) NOT NULL,
`AccountHolderName` varchar(1000) NOT NULL,
`PayuKey` bigint(20) NOT NULL,
`SaltKey` bigint(20) NOT NULL,
`MerchantKey` bigint(20) NOT NULL,
`AccountType` varchar(1000) NOT NULL,
`Link` varchar(10000) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'varalaxmi co op socity','','200200007310 ','Smt rudramma S M rudrayya swami ',0,0,0,'','');
/*!40000 ALTER TABLE `bankaccounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `budget`
--
DROP TABLE IF EXISTS `budget`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budget` (
`budgetid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fromdate` date NOT NULL,
`todate` date DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`budgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `budget`
--
LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`categoryid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`type` int(11) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `class`
--
DROP TABLE IF EXISTS `class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class` (
`Name` varchar(100) NOT NULL,
`Cls_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Cls_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 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
('6',17,NULL),
('Nursery',16,NULL),
('UKG',15,NULL),
('LKG',14,NULL),
('1',9,NULL),
('2',10,NULL),
('3',11,NULL),
('4',12,NULL),
('5',13,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=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `head`
--
LOCK TABLES `head` WRITE;
/*!40000 ALTER TABLE `head` DISABLE KEYS */;
INSERT INTO `head` VALUES
('School Fees NLU',1,'1/2','2026-06-01','No','0','1','SCHL'),
('School Fees 1-6',2,'2/5','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=7 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
('varalaxmi co op socity-310 ',1,'Current Assets'),
('TUTION FEE',2,'Income/Revenue'),
('DEVELOPMENT FEE',3,'Income/Revenue'),
('EXAM FEE',4,'Income/Revenue'),
('COMPUTER FEE ETC',5,'Income/Revenue'),
('TUTION FEE 1-6',6,'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=144 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,118,'SCHL-1',1,'SCHL','SCHL-1',1,'2','/2/5','/1500/000','2024-05-29','Cash','2437',0,0,1500,1500,1,'adminFees303',NULL),
(2,88,'SCHL-2',2,'SCHL','SCHL-2',2,'2','/2/5','/2000/000','2024-05-30','Cash','2438',0,0,2000,2000,1,'adminFees303',NULL),
(3,100,'SCHL-3',3,'SCHL','SCHL-3',3,'2','/2/5','/2000/000','2024-05-30','Cash','2439',0,0,2000,2000,1,'adminFees303',NULL),
(4,72,'SCHL-4',4,'SCHL','SCHL-4',4,'2','/2/5','/2000/3000','2024-05-30','Cash','2440',0,0,5000,5000,1,'adminFees303',NULL),
(5,174,'SCHL-5',5,'SCHL','SCHL-5',5,'1','/1/2/3/4','/3000/000/0/0','2024-05-30','Cash','2441',0,0,3000,3000,1,'adminFees303',NULL),
(6,188,'SCHL-6',6,'SCHL','SCHL-6',6,'1','/1/2','/000/2000','2024-05-31','Cash','2442',0,0,2000,2000,1,'adminFees303',NULL),
(7,139,'SCHL-7',7,'SCHL','SCHL-7',7,'2','/2/5','/1500/000','2024-05-31','Cash','2443',0,0,1500,1500,1,'adminFees303',NULL),
(8,126,'SCHL-8',8,'SCHL','SCHL-8',8,'2','/2/5','/2000/000','2024-05-31','Cash','2444',0,0,2000,2000,1,'adminFees303',NULL),
(9,82,'SCHL-9',9,'SCHL','SCHL-9',9,'2','/2/5','/1500/000','2024-05-31','Cash','2445',0,0,1500,1500,1,'adminFees303',NULL),
(10,92,'SCHL-10',10,'SCHL','SCHL-10',10,'2','/2/5','/1500/0','2024-05-31','Cash','2446',0,0,1500,1500,1,'adminFees303',NULL),
(11,62,'SCHL-11',11,'SCHL','SCHL-11',11,'2','/2/5','/2000/000','2024-05-31','Cash','2447',0,0,2000,2000,1,'adminFees303',NULL),
(12,170,'SCHL-12',12,'SCHL','SCHL-12',12,'1','/1/2/3/4','/000/2000/0/0','2024-05-31','Cash','2448',0,0,2000,2000,1,'adminFees303',NULL),
(13,175,'SCHL-13',13,'SCHL','SCHL-13',13,'1','/1/2/3/4','/1000/000/0/0','2024-05-31','Cash','2449',0,0,1000,1000,1,'adminFees303',NULL),
(14,150,'SCHL-14',14,'SCHL','SCHL-14',14,'2','/2/5','/2000/1000','2024-05-31','Cash','2450',0,0,3000,3000,1,'adminFees303',NULL),
(15,42,'SCHL-15',15,'SCHL','SCHL-15',15,'2','/2/5','/2000/1000','2024-05-31','Cash','2451',0,0,3000,3000,1,'adminFees303',NULL),
(16,169,'SCHL-16',16,'SCHL','SCHL-16',16,'1','/1/2/3/4','/000/2000/0/0','2024-06-01','Cash','2452',0,0,2000,2000,1,'adminFees303',NULL),
(17,142,'SCHL-17',17,'SCHL','SCHL-17',17,'2','/2/5','/2000/000','2024-06-03','Cash','2453',0,0,2000,2000,1,'adminFees303',NULL),
(18,134,'SCHL-18',18,'SCHL','SCHL-18',18,'2','/2/5','/1000/000','2024-06-03','Cash','2454',0,0,1000,1000,1,'adminFees303',NULL),
(19,159,'SCHL-19',19,'SCHL','SCHL-19',19,'2','/2/5','/2000/1000','2024-06-03','Cash','2455',0,0,3000,3000,1,'adminFees303',NULL),
(20,56,'SCHL-20',20,'SCHL','SCHL-20',20,'2','/2/5','/2000/000','2024-06-03','Cash','2456',0,0,2000,2000,1,'adminFees303',NULL),
(21,56,'SCHL-21',21,'SCHL','SCHL-21',21,'2','/5','/2000','2024-06-03','Cash','2457',0,0,2000,2000,1,'adminFees303',NULL),
(22,121,'SCHL-22',22,'SCHL','SCHL-22',22,'2','/2/5','/1500/000','2024-06-03','Cash','2458',0,0,1500,1500,1,'adminFees303',NULL),
(23,70,'SCHL-23',23,'SCHL','SCHL-23',23,'2','/2/5','/2000/1000','2024-06-03','Cash','2461',0,0,3000,3000,1,'adminFees303',NULL),
(24,198,'SCHL-24',24,'SCHL','SCHL-24',24,'1','/1/2/3/4','/1000/2000/0/0','2024-06-03','Cash','2462',0,0,3000,3000,1,'adminFees303',NULL),
(25,30,'SCHL-25',25,'SCHL','SCHL-25',25,'1','/1/2','/4000/000','2024-06-03','Cash','2463',0,0,4000,4000,1,'adminFees303',NULL),
(26,45,'SCHL-26',26,'SCHL','SCHL-26',26,'2','/2/5','/2000/1000','2024-06-03','Cash','2464',0,0,3000,3000,1,'adminFees303',NULL),
(27,47,'SCHL-27',27,'SCHL','SCHL-27',27,'2','/2/5','/1000/000','2024-06-03','Cash','2465',0,0,1000,1000,1,'adminFees303',NULL),
(28,194,'SCHL-28',28,'SCHL','SCHL-28',28,'1','/1/2/3/4','/000/2000/0/0','2024-06-03','Cash','2466',0,0,2000,2000,1,'adminFees303',NULL),
(29,89,'SCHL-29',29,'SCHL','SCHL-29',29,'2','/2/5','/1000/000','2024-06-04','Cash','2467',0,0,1000,1000,1,'adminFees303',NULL),
(30,175,'SCHL-30',30,'SCHL','SCHL-30',30,'1','/1/2/3/4','/000/1000/0/0','2024-06-04','Cash','2468',0,0,1000,1000,1,'adminFees303',NULL),
(31,29,'SCHL-31',31,'SCHL','SCHL-31',31,'1','/1/2','/000/2000','2024-06-04','Cash','2469',0,0,2000,2000,1,'adminFees303',NULL),
(32,165,'SCHL-32',32,'SCHL','SCHL-32',32,'1','/1/2/3/4','/1000/2000/0/0','2024-06-05','Cash','2470',0,0,3000,3000,1,'adminFees303',NULL),
(33,85,'SCHL-33',33,'SCHL','SCHL-33',33,'2','/2/5','/2000/0000','2024-06-05','Cash','2471',0,0,2000,2000,1,'adminFees303',NULL),
(34,155,'SCHL-34',34,'SCHL','SCHL-34',34,'2','/2/5','/2000/1500','2024-06-05','Cash','2472',0,0,3500,3500,1,'adminFees303',NULL),
(35,86,'SCHL-35',35,'SCHL','SCHL-35',35,'2','/2/5','/2000/1000','2024-06-05','Cash','2473',0,0,3000,3000,1,'adminFees303',NULL),
(36,44,'SCHL-36',36,'SCHL','SCHL-36',36,'2','/2/5','/2000/1000','2024-06-05','Cash','2474',0,0,3000,3000,1,'adminFees303',NULL),
(37,95,'SCHL-37',37,'SCHL','SCHL-37',37,'2','/2/5','/2000/000','2024-06-05','Cash','2475',0,0,2000,2000,1,'adminFees303',NULL),
(38,167,'SCHL-38',38,'SCHL','SCHL-38',38,'1','/1/2/3/4','/1000/2000/0/0','2024-06-05','Cash','2476',0,0,3000,3000,1,'adminFees303',NULL),
(39,128,'SCHL-39',39,'SCHL','SCHL-39',39,'2','/2/5','/1000/000','2024-06-05','Cash','2477',0,0,1000,1000,1,'adminFees303',NULL),
(40,84,'SCHL-40',40,'SCHL','SCHL-40',40,'2','/2/5','/1000/000','2024-06-05','Cash','2478',0,0,1000,1000,1,'adminFees303',NULL),
(41,168,'SCHL-41',41,'SCHL','SCHL-41',41,'1','/1/2/3/4','/000/2000/0/0','2024-06-05','Cash','2479',0,0,2000,2000,1,'adminFees303',NULL),
(42,33,'SCHL-42',42,'SCHL','SCHL-42',42,'1','/1/2','/000/1000','2024-06-06','Cash','2480',0,0,1000,1000,1,'adminFees303',NULL),
(43,122,'SCHL-43',43,'SCHL','SCHL-43',43,'2','/2/5','/2000/000','2024-06-06','Cash','2481',0,0,2000,2000,1,'adminFees303',NULL),
(44,177,'SCHL-44',44,'SCHL','SCHL-44',44,'1','/1/2/3/4','/000/2000/0/0','2024-06-06','Cash','2482',0,0,2000,2000,1,'adminFees303',NULL),
(45,178,'SCHL-45',45,'SCHL','SCHL-45',45,'1','/1/2/3/4','/000/2000/0/0','2024-06-06','Cash','2483',0,0,2000,2000,1,'adminFees303',NULL),
(46,176,'SCHL-46',46,'SCHL','SCHL-46',46,'1','/1/2/3/4','/000/2000/0/0','2024-06-07','Cash','2484',0,0,2000,2000,1,'adminFees303',NULL),
(47,172,'SCHL-47',47,'SCHL','SCHL-47',47,'1','/1/2/3/4','/000/2000/0/0','2024-06-07','Cash','2485',0,0,2000,2000,1,'adminFees303',NULL),
(48,108,'SCHL-48',48,'SCHL','SCHL-48',48,'2','/2/5','/2000/2000','2024-06-07','Cash','2486',0,0,4000,4000,1,'adminFees303',NULL),
(49,48,'SCHL-49',49,'SCHL','SCHL-49',49,'2','/2/5','/1000/0','2024-06-07','Cash','2487',0,0,1000,1000,1,'adminFees303',NULL),
(50,53,'SCHL-50',50,'SCHL','SCHL-50',50,'2','/2/5','/1500/000','2024-06-07','Cash','2488',0,0,1500,1500,1,'adminFees303',NULL),
(51,67,'SCHL-51',51,'SCHL','SCHL-51',51,'2','/2/5','/1000/000','2024-06-07','Cash','2489',0,0,1000,1000,1,'adminFees303',NULL),
(52,22,'SCHL-52',52,'SCHL','SCHL-52',52,'1','/1/2','/000/2000','2024-06-07','Cash','2490',0,0,2000,2000,1,'adminFees303',NULL),
(53,103,'SCHL-53',53,'SCHL','SCHL-53',53,'2','/2/5','/500/000','2024-06-07','Cash','2492',0,0,500,500,1,'adminFees303',NULL),
(54,78,'SCHL-54',54,'SCHL','SCHL-54',54,'2','/2/5','/500/000','2024-06-08','Cash','2493',0,0,500,500,1,'adminFees303',NULL),
(55,27,'SCHL-55',55,'SCHL','SCHL-55',55,'1','/1/2','/000/1000','2024-06-08','Cash','2494',0,0,1000,1000,1,'adminFees303',NULL),
(56,140,'SCHL-56',56,'SCHL','SCHL-56',56,'2','/2/5','/1500/000','2024-06-08','Cash','2495',0,0,1500,1500,1,'adminFees303',NULL),
(57,136,'SCHL-57',57,'SCHL','SCHL-57',57,'2','/2/5','/1500/000','2024-06-08','Cash','2496',0,0,1500,1500,1,'adminFees303',NULL),
(58,107,'SCHL-58',58,'SCHL','SCHL-58',58,'2','/2/5','/1000/00','2024-06-10','Cash','2498',0,0,1000,1000,1,'adminFees303',NULL),
(59,87,'SCHL-59',59,'SCHL','SCHL-59',59,'2','/2/5','/1000/000','2024-06-10','Cash','2499',0,0,1000,1000,1,'adminFees303',NULL),
(60,96,'SCHL-60',60,'SCHL','SCHL-60',60,'2','/2/5','/1000/000','2024-06-10','Cash','2500',0,0,1000,1000,1,'adminFees303',NULL),
(61,117,'SCHL-61',61,'SCHL','SCHL-61',61,'2','/2/5','/2000/000','2024-06-10','Cash','2501',0,0,2000,2000,1,'adminFees303',NULL),
(62,197,'SCHL-62',62,'SCHL','SCHL-62',62,'1','/1/2/3/4','/000/1000/0/0','2024-06-10','Cash','2502',0,0,1000,1000,1,'adminFees303',NULL),
(63,182,'SCHL-63',63,'SCHL','SCHL-63',63,'1','/1/2/3/4','/000/1000/0/0','2024-06-10','Cash','2503',0,0,1000,1000,1,'adminFees303',NULL),
(64,79,'SCHL-64',64,'SCHL','SCHL-64',64,'2','/2/5','/1000/000','2024-06-10','Cash','2504',0,0,1000,1000,1,'adminFees303',NULL),
(65,55,'SCHL-65',65,'SCHL','SCHL-65',65,'2','/2/5','/2000/2000','2024-06-10','Cash','2505',0,0,4000,4000,1,'adminFees303',NULL),
(66,190,'SCHL-66',66,'SCHL','SCHL-66',66,'1','/1/2/3/4','/000/1000/0/0','2024-06-10','Cash','2506',0,0,1000,1000,1,'adminFees303',NULL),
(67,171,'SCHL-67',67,'SCHL','SCHL-67',67,'1','/1/2/3/4','/000/2000/0/0','2024-06-10','Cash','2507',0,0,2000,2000,1,'adminFees303',NULL),
(68,179,'SCHL-68',68,'SCHL','SCHL-68',68,'1','/1/2/3/4','/000/2000/0/0','2024-06-10','Cash','2508',0,0,2000,2000,1,'adminFees303',NULL),
(69,58,'SCHL-69',69,'SCHL','SCHL-69',69,'2','/2/5','/2000/000','2024-06-10','Cash','2509',0,0,2000,2000,1,'adminFees303',NULL),
(70,114,'SCHL-70',70,'SCHL','SCHL-70',70,'2','/2/5','/2000/000','2024-06-10','Cash','2510',0,0,2000,2000,1,'adminFees303',NULL),
(71,26,'SCHL-71',71,'SCHL','SCHL-71',71,'1','/1/2','/000/2000','2024-06-10','Cash','2511',0,0,2000,2000,1,'adminFees303',NULL),
(72,91,'SCHL-72',72,'SCHL','SCHL-72',72,'2','/2/5','/2000/000','2024-06-10','Cash','2512',0,0,2000,2000,1,'adminFees303',NULL),
(73,152,'SCHL-73',73,'SCHL','SCHL-73',73,'2','/2/5','/1000/000','2024-06-10','Cash','2513',0,0,1000,1000,1,'adminFees303',NULL),
(74,192,'SCHL-74',74,'SCHL','SCHL-74',74,'1','/1/2/3/4','/1000/000/0/0','2024-06-10','Cash','2514',0,0,1000,1000,1,'adminFees303',NULL),
(75,130,'SCHL-75',75,'SCHL','SCHL-75',75,'2','/2/5','/2000/1500','2024-06-11','Cash','2515',0,0,3500,3500,1,'adminFees303',NULL),
(76,28,'SCHL-76',76,'SCHL','SCHL-76',76,'1','/1/2','/1000/2000','2024-06-11','Cash','2516',0,0,3000,3000,1,'adminFees303',NULL),
(77,189,'SCHL-77',77,'SCHL','SCHL-77',77,'1','/1/2/3/4','/500/2000/0/0','2024-06-11','Cash','2517',0,0,2500,2500,1,'adminFees303',NULL),
(78,57,'SCHL-78',78,'SCHL','SCHL-78',78,'2','/2/5','/1000/000','2024-06-11','Cash','2518',0,0,1000,1000,1,'adminFees303',NULL),
(79,98,'SCHL-79',79,'SCHL','SCHL-79',79,'2','/2/5','/1000/000','2024-06-11','Cash','2519',0,0,1000,1000,1,'adminFees303',NULL),
(80,134,'SCHL-80',80,'SCHL','SCHL-80',80,'2','/2/5','/1000/000','2024-06-12','Cash','2520',0,0,1000,1000,1,'adminFees303',NULL),
(81,49,'SCHL-81',81,'SCHL','SCHL-81',81,'2','/2/5','/2000/000','2024-06-12','Cash','2521',0,0,2000,2000,1,'adminFees303',NULL),
(82,49,'SCHL-82',82,'SCHL','SCHL-82',82,'2','/5','/2000','2024-06-12','Cash','2522',0,0,2000,2000,1,'adminFees303',NULL),
(83,33,'SCHL-83',83,'SCHL','SCHL-83',83,'1','/1/2','/2000/1000','2024-06-12','Cash','2523',0,0,3000,3000,1,'adminFees303',NULL),
(84,138,'SCHL-84',84,'SCHL','SCHL-84',84,'2','/2/5','/2000/000','2024-06-12','Cash','2524',0,0,2000,2000,1,'adminFees303',NULL),
(85,23,'SCHL-85',85,'SCHL','SCHL-85',85,'1','/1/2','/000/2000','2024-06-12','Cash','2525',0,0,2000,2000,1,'adminFees303',NULL),
(86,60,'SCHL-86',86,'SCHL','SCHL-86',86,'2','/2/5','/2000/000','2024-06-12','Cash','2526',0,0,2000,2000,1,'adminFees303',NULL),
(87,52,'SCHL-87',87,'SCHL','SCHL-87',87,'2','/2/5','/1000/000','2024-06-12','Cash','2527',0,0,1000,1000,1,'adminFees303',NULL),
(88,149,'SCHL-88',88,'SCHL','SCHL-88',88,'2','/2/5','/2000/1000','2024-06-13','Cash','2528',0,0,3000,3000,1,'adminFees303',NULL),
(89,83,'SCHL-89',89,'SCHL','SCHL-89',89,'2','/2/5','/1000/000','2024-06-13','Cash','2529',0,0,1000,1000,1,'adminFees303',NULL),
(90,166,'SCHL-90',90,'SCHL','SCHL-90',90,'1','/1/2/3/4','/4000/000/0/0','2024-06-13','Cash','2530',0,0,4000,4000,1,'adminFees303',NULL),
(91,77,'SCHL-91',91,'SCHL','SCHL-91',91,'2','/2/5','/1000/000','2024-06-13','Cash','2531',0,0,1000,1000,1,'adminFees303',NULL),
(92,99,'SCHL-92',92,'SCHL','SCHL-92',92,'2','/2/5','/1000/000','2024-06-13','Cash','2532',0,0,1000,1000,1,'adminFees303',NULL),
(93,146,'SCHL-93',93,'SCHL','SCHL-93',93,'2','/2/5','/2000/000','2024-06-13','Cash','2533',0,0,2000,2000,1,'adminFees303',NULL),
(94,102,'SCHL-94',94,'SCHL','SCHL-94',94,'2','/2/5','/000/5000','2024-06-13','Cash','2534',0,0,5000,5000,1,'adminFees303',NULL),
(95,102,'SCHL-95',95,'SCHL','SCHL-95',95,'2','/2','/2000','2024-06-13','Cash','2535',0,0,2000,2000,1,'adminFees303',NULL),
(96,104,'SCHL-96',96,'SCHL','SCHL-96',96,'2','/2/5','/2000/000','2024-06-13','Cash','2537',0,0,2000,2000,1,'adminFees303',NULL),
(97,73,'SCHL-97',97,'SCHL','SCHL-97',97,'2','/2/5','/2000/2000','2024-06-13','Cash','2538',0,0,4000,4000,1,'adminFees303',NULL),
(98,195,'SCHL-98',98,'SCHL','SCHL-98',98,'1','/1/2/3/4','/4000/000/0/0','2024-06-13','Cash','2539',0,0,4000,4000,1,'adminFees303',NULL),
(99,97,'SCHL-99',99,'SCHL','SCHL-99',99,'2','/2/5','/2000/1000','2024-06-13','Cash','2540',0,0,3000,3000,1,'adminFees303',NULL),
(100,160,'SCHL-100',100,'SCHL','SCHL-100',100,'2','/2/5','/2000/000','2024-06-13','Cash','2542',0,0,2000,2000,1,'adminFees303',NULL),
(101,61,'SCHL-101',101,'SCHL','SCHL-101',101,'2','/2/5','/2000/1500','2024-06-14','Cash','2543',0,0,3500,3500,1,'adminFees303',NULL),
(102,131,'SCHL-102',102,'SCHL','SCHL-102',102,'2','/2/5','/1000/000','2024-06-14','Cash','2544',0,0,1000,1000,1,'adminFees303',NULL),
(103,156,'SCHL-103',103,'SCHL','SCHL-103',103,'2','/2/5','/2000/500','2024-06-14','Cash','2545',0,0,2500,2500,1,'adminFees303',NULL),
(104,147,'SCHL-104',104,'SCHL','SCHL-104',104,'2','/2/5','/2000/000','2024-06-18','Cash','2546',0,0,2000,2000,1,'adminFees303',NULL),
(105,63,'SCHL-105',105,'SCHL','SCHL-105',105,'2','/2/5','/2000/1500','2024-06-18','Cash','2547',0,0,3500,3500,1,'adminFees303',NULL),
(106,76,'SCHL-106',106,'SCHL','SCHL-106',106,'2','/2/5','/1000/000','2024-06-18','Cash','2548',0,0,1000,1000,1,'adminFees303',NULL),
(107,161,'SCHL-107',107,'SCHL','SCHL-107',107,'2','/2/5','/2000/1000','2024-06-19','Cash','2550',0,0,3000,3000,1,'adminFees303',NULL),
(108,71,'SCHL-108',108,'SCHL','SCHL-108',108,'2','/2/5','/2000/500','2024-06-19','Cash','2551',0,0,2500,2500,1,'adminFees303',NULL),
(109,24,'SCHL-109',109,'SCHL','SCHL-109',109,'1','/1/2','/000/2000','2024-06-19','Cash','2552',0,0,2000,2000,1,'adminFees303',NULL),
(110,65,'SCHL-110',110,'SCHL','SCHL-110',110,'2','/2/5','/1500/0.0','2024-06-19','Cash','2553',0,0,1500,1500,1,'adminFees303',NULL),
(111,25,'SCHL-111',111,'SCHL','SCHL-111',111,'1','/1/2','/1000/000','2024-06-20','Cash','2556',0,0,1000,1000,1,'adminFees303',NULL),
(112,145,'SCHL-112',112,'SCHL','SCHL-112',112,'2','/2/5','/1000/000','2024-06-24','Cash','2555',0,0,1000,1000,1,'adminFees303',NULL),
(113,94,'SCHL-113',113,'SCHL','SCHL-113',113,'2','/2/5','/1000/000','2024-06-24','Cash','2557',0,0,1000,1000,1,'adminFees303',NULL),
(114,68,'SCHL-114',114,'SCHL','SCHL-114',114,'2','/2/5','/1000/000','2024-06-24','Cash','2558',0,0,1000,1000,1,'adminFees303',NULL),
(115,69,'SCHL-115',115,'SCHL','SCHL-115',115,'2','/2/5','/1000/000','2024-06-24','Cash','2559',0,0,1000,1000,1,'adminFees303',NULL),
(116,184,'SCHL-116',116,'SCHL','SCHL-116',116,'1','/1/2/3/4','/1000/000/0/0','2024-06-24','Cash','2560',0,0,1000,1000,1,'adminFees303',NULL),
(117,47,'SCHL-117',117,'SCHL','SCHL-117',117,'2','/2/5','/1000/1000','2024-06-24','Cash','2561',0,0,2000,2000,1,'adminFees303',NULL),
(118,106,'SCHL-118',118,'SCHL','SCHL-118',118,'2','/2/5','/2000/2000','2024-06-24','Cash','2562',0,0,4000,4000,1,'adminFees303',NULL),
(119,124,'SCHL-119',119,'SCHL','SCHL-119',119,'2','/2/5','/2000/2000','2024-06-24','Cash','2563',0,0,4000,4000,1,'adminFees303',NULL),
(120,196,'SCHL-120',120,'SCHL','SCHL-120',120,'1','/1/2/3/4','/1000/000/0/0','2024-06-24','Cash','2564',0,0,1000,1000,1,'adminFees303',NULL),
(121,32,'SCHL-121',121,'SCHL','SCHL-121',121,'1','/1/2','/1000/000','2024-06-24','Cash','2565',0,0,1000,1000,1,'adminFees303',NULL),
(122,135,'SCHL-122',122,'SCHL','SCHL-122',122,'2','/2/5','/2000/1000','2024-06-24','Cash','2566',0,0,3000,3000,1,'adminFees303',NULL),
(123,105,'SCHL-123',123,'SCHL','SCHL-123',123,'2','/2/5','/2000/1000','2024-06-24','Cash','2567',0,0,3000,3000,1,'adminFees303',NULL),
(124,54,'SCHL-124',124,'SCHL','SCHL-124',124,'2','/2/5','/2000/1000','2024-06-24','Cash','2568',0,0,3000,3000,1,'adminFees303',NULL),
(125,170,'SCHL-125',125,'SCHL','SCHL-125',125,'1','/1/3/4','/1000/0/0','2024-06-24','Cash','2569',0,0,1000,1000,1,'adminFees303',NULL),
(126,35,'SCHL-126',126,'SCHL','SCHL-126',126,'1','/1/2','/1000/2000','2024-06-24','Cash','2570',0,0,3000,3000,1,'adminFees303',NULL),
(127,46,'SCHL-127',127,'SCHL','SCHL-127',127,'2','/2/5','/2000/000','2024-06-27','Cash','2571',0,0,2000,2000,1,'adminFees303',NULL),
(128,111,'SCHL-128',128,'SCHL','SCHL-128',128,'2','/2/5','/2000/000','2024-06-27','Cash','2572',0,0,2000,2000,1,'adminFees303',NULL),
(129,59,'SCHL-129',129,'SCHL','SCHL-129',129,'2','/2/5','/2000/000','2024-06-27','Cash','2573',0,0,2000,2000,1,'adminFees303',NULL),
(130,137,'SCHL-130',130,'SCHL','SCHL-130',130,'2','/2/5','/1000/000','2024-06-28','Cash','2574',0,0,1000,1000,1,'adminFees303',NULL),
(131,31,'SCHL-131',131,'SCHL','SCHL-131',131,'1','/1/2','/000/2000','2024-07-01','Cash','2575',0,0,2000,2000,1,'adminFees303',NULL),
(132,185,'SCHL-132',132,'SCHL','SCHL-132',132,'1','/1/2/3/4','/000/2000/0/0','2024-07-01','Cash','2576',0,0,2000,2000,1,'adminFees303',NULL),
(133,51,'SCHL-133',133,'SCHL','SCHL-133',133,'2','/2/5','/2000/000','2024-07-01','Cash','2577',0,0,2000,2000,1,'adminFees303',NULL),
(134,43,'SCHL-134',134,'SCHL','SCHL-134',134,'2','/2/5','/1500/000','2024-07-01','Cash','2578',0,0,1500,1500,1,'adminFees303',NULL),
(135,151,'SCHL-135',135,'SCHL','SCHL-135',135,'2','/2/5','/1500/000','2024-07-01','Cash','2579',0,0,1500,1500,1,'adminFees303',NULL),
(136,153,'SCHL-136',136,'SCHL','SCHL-136',136,'2','/2/5','/1000/000','2024-07-01','Cash','2580',0,0,1000,1000,1,'adminFees303',NULL),
(137,152,'SCHL-137',137,'SCHL','SCHL-137',137,'2','/2/5','/1000/000','2024-07-02','Cash','2581',0,0,1000,1000,1,'adminFees303',NULL),
(138,180,'SCHL-138',138,'SCHL','SCHL-138',138,'1','/1/2/3/4','/1000/000/0/0','2024-07-02','Cash','2582',0,0,1000,1000,1,'adminFees303',NULL),
(139,74,'SCHL-139',139,'SCHL','SCHL-139',139,'2','/2/5','/1500/000','2024-07-03','Cash','2583',0,0,1500,1500,1,'adminFees303',NULL),
(140,181,'SCHL-140',140,'SCHL','SCHL-140',140,'1','/1/2/3/4','/1000/000/0/0','2024-07-03','Cash','2584',0,0,1000,1000,1,'adminFees303',NULL),
(141,162,'SCHL-141',141,'SCHL','SCHL-141',141,'2','/2/5','/2000/1500','2024-07-03','Cash','2585',0,0,3500,3500,1,'adminFees303',NULL),
(142,187,'SCHL-142',142,'SCHL','SCHL-142',142,'1','/1/2/3/4','/1000/000/0/0','2024-07-05','Cash','2586',0,0,1000,1000,1,'adminFees303',NULL),
(143,186,'SCHL-143',143,'SCHL','SCHL-143',143,'1','/1/2/3/4','/1000/000/0/0','2024-07-09','Cash','2587',0,0,1000,1000,1,'adminFees303',NULL);
/*!40000 ALTER TABLE `paid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees_delete`
--
DROP TABLE IF EXISTS `paid_fees_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees_delete` (
`Fees_id` bigint(20) NOT NULL DEFAULT 0,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_No` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Subhead_Ids` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Sub_Amounts` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`DateNumber` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Message` varchar(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees_delete`
--
LOCK TABLES `paid_fees_delete` WRITE;
/*!40000 ALTER TABLE `paid_fees_delete` DISABLE KEYS */;
INSERT INTO `paid_fees_delete` VALUES
(1,12,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1/2/3/4','/10000/600/4000/300','2023-05-30','Cash','1851',0,0,14900,14900,1,'adminFees303','2023-12-18 06:31 23'),
(2,97,'SCHL-2',2,'SCHL','SCHL-2',2,'1','/1/2/3/4','/40000/600/4000/300','2023-12-18','Cash','',0,0,44900,44900,1,'adminFees303','2023-12-18 06:31 35');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=199 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
('YADVIK KUMAR AMBIGER S/O RAJASHEKHARA AMBIGER',34,'','UKG','A','13',8496864126,'',NULL,0,NULL),
('AVANTHIKA D/O UMESHA',33,'','UKG','A','12',9611029550,'',NULL,0,NULL),
('BHOVI NAGARAJA S/O BHOVI SHIVAPPA',32,'','UKG','A','11',7026575286,'',NULL,0,NULL),
('BHARATH KUMAR K S/O MUTTANNA K',31,'','UKG','A','10',7996065718,'',NULL,0,NULL),
('DHANYA D/O BASAVARAJA MATTI',30,'','UKG','A','9',9353632962,'',NULL,0,NULL),
('SAKSHI CHALUVADI D/O MANJUNATHA CHALUVADI',29,'','UKG','A','8',9611568889,'',NULL,0,NULL),
('MANASA D/O KANAKAPPA',28,'','UKG','A','7',9986514356,'',NULL,0,NULL),
('C PRIYANKA D/O C HALESHA',27,'','UKG','A','6',9902762132,'',NULL,0,NULL),
('H GANESH S/O H SURESH ',25,'','UKG','A','4',7829210907,'',NULL,0,NULL),
('M PREETHI D/O PRAKASH A',26,'','UKG','A','5',7760143490,'',NULL,0,NULL),
('NITHIN KUMAR S/O G RAVICHANDRA',24,'','UKG','A','3',9591085526,'',NULL,0,NULL),
('C PUNITH KUMAR S/O C PAMANNA',23,'','UKG','A','2',9742321399,'',NULL,0,NULL),
('S YASHAVANTH KUMAR S/O RAMESH SIDDAPURA',22,'','UKG','A','1',9972268873,'',NULL,0,NULL),
('MOHAMMAD ZAIN S/O M SHEKSHAVALI',35,'','UKG','A','14',9731350528,'',NULL,0,NULL),
('C NAIRUTHI D/O C SHIVU ',36,'','UKG','A','15',8147093558,'',NULL,0,NULL),
('M RAJEEV S/O M SHARANABASAVARAJA',37,'','UKG','A','16',9481235099,'',NULL,0,NULL),
('SIDDITA KUSHWAN D/O RAJA HANS KUMAR',38,'','UKG','A','17',8461952535,'',NULL,0,NULL),
('LAVANYA D/O RAMESH ',39,'','UKG','A','18',8139989983,'',NULL,0,NULL),
('SAMARTHA S/O SURESH SIDDAPURA ',40,'','UKG','A','19',9611349898,'',NULL,0,NULL),
('H JANU S/ORAJASHEKHAR',42,'','1','A','1',0,'',NULL,0,NULL),
('H AHARAN KUMAR S/ORAVI KUMAR',43,'','1','A','2',0,'',NULL,0,NULL),
('J MANIDEEPAK S/OSHIVU',44,'','1','A','3',0,'',NULL,0,NULL),
('SANA S/OKAMPLI SHAMSHUDDIN',45,'','1','A','4',0,'',NULL,0,NULL),
('GOUSIYA KASAB S/OK PYARA SAB',46,'','1','A','5',0,'',NULL,0,NULL),
('C N RUTWIKA S/OC N SURYA NARAYANA',47,'','1','A','6',0,'',NULL,0,NULL),
('ROHITH S/OSHEKHARI',48,'','1','A','7',0,'',NULL,0,NULL),
('SAMRUDDI P S S/OMALLIKARJUN P S',49,'','1','A','8',0,'',NULL,0,NULL),
('S KRANTI KUMAR S/ORAMU',50,'','1','A','9',0,'',NULL,0,NULL),
('KAVYA S/OKRISHNA',51,'','1','A','10',0,'',NULL,0,NULL),
('BHARAT S/OHULAGAPPA',52,'','1','A','11',0,'',NULL,0,NULL),
('PRABHANJAN S/ORAMACHANDRA',53,'','1','A','12',0,'',NULL,0,NULL),
('DHRUV S/OKANA RAM',54,'','1','A','13',0,'',NULL,0,NULL),
('D PRAMOD S/OD RAVIKUMAR',55,'','1','A','14',0,'',NULL,0,NULL),
('SHARAT KUMAR S/OAMARESHA',56,'','1','A','15',0,'',NULL,0,NULL),
('N GOUTHAM S/OURUKUNDA',57,'','1','A','16',0,'',NULL,0,NULL),
('AFIYA AFREEN S/OAMEER H',58,'','1','A','17',0,'',NULL,0,NULL),
('K MALLIKARJUNA S/OK HULLIGAPPA',59,'','1','A','18',0,'',NULL,0,NULL),
('TEJA KUMAR S/ONAGARAJ',60,'','1','A','19',0,'',NULL,0,NULL),
('MUPPURI UDAY S/OMUPPURINARASIMHARAO',61,'','1','A','20',0,'',NULL,0,NULL),
('KIRAN S/OTHIPPERUDRA',62,'','1','A','21',0,'',NULL,0,NULL),
('TARUN S/OGIRIBABU',63,'','1','A','22',0,'',NULL,0,NULL),
('GOUTHAM S/OPARASHURAAMA',64,'','1','A','23',0,'',NULL,0,NULL),
('C V AKSHAY KUMAR S/OCHALUVUDI VENKOBA',65,'','1','A','24',0,'',NULL,0,NULL),
('AHEMAD RAZA S/ONAJIR BASHA',66,'','1','A','25',0,'',NULL,0,NULL),
('B GOUTHAMI S/OBUDUGUMPI BHAGYAVANTHA',67,'','1','A','26',0,'',NULL,0,NULL),
('P ROSHANI MOHAMMADIYA S/OP MOHAMMED GOUSE',68,'','1','A','27',0,'',NULL,0,NULL),
('MAHNOOR FATIMAH S/OP MOHAMMAD KHALEEL',69,'','1','A','28',0,'',NULL,0,NULL),
('ANISA S/ONOOR',70,'','1','A','29',0,'',NULL,0,NULL),
('ROHITH S/OK SHANKARA',71,'','1','A','30',0,'',NULL,0,NULL),
('K ARFIYA S/OALLA BAKSHI',72,'','1','A','31',0,'',NULL,0,NULL),
('AKSHAY KUMAR S/ORAJA',73,'','1','A','32',0,'',NULL,0,NULL),
('PRAJWAL C S S/O C A SHEKHAR',74,'','2','A','',0,'',NULL,0,NULL),
('B THANVITHA S/O B MARUTHI',75,'','2','A','',0,'',NULL,0,NULL),
('G H SAI SAMARTHA S/O G HONNURUSWAMY',76,'','2','A','',0,'',NULL,0,NULL),
('D M KHUSHI S/O CHENNADASARA MURARI',77,'','2','A','',0,'',NULL,0,NULL),
('NIHARIKA S/O H KANAKAPPA',78,'','2','A','',0,'',NULL,0,NULL),
('MOHAMMAD ATHIKQ S/O S ANSAR BASHA',79,'','2','A','',0,'',NULL,0,NULL),
('ABDUL REHAMAN S/O IMRAN K',80,'','2','A','',0,'',NULL,0,NULL),
('N ANUSHKA S/O N NAGARAJA',81,'','2','A','',0,'',NULL,0,NULL),
('DHANUSH S/O RAMANJINI',82,'','2','A','',0,'',NULL,0,NULL),
('B CHINMAYA S/O THIPPANNA BALLARY',83,'','2','A','',0,'',NULL,0,NULL),
('YOONESH S/O SHIVARAJA C',84,'','2','A','',0,'',NULL,0,NULL),
('C SRUSTI S/O VIRESH C',85,'','2','A','',0,'',NULL,0,NULL),
('GANGADHARA S/O HULUGAPPA H',86,'','2','A','',0,'',NULL,0,NULL),
('OWIZA KULSUM S/O MAHAMMAD GOUS',87,'','2','A','',0,'',NULL,0,NULL),
('G JEEVAN KUMAR S/O VIJAYAKUMARA',88,'','2','A','',0,'',NULL,0,NULL),
('LABEDA PRUTHVI S/O LABED SOMASHEKHAR',89,'','3','A','',0,'',NULL,0,NULL),
('P TANUSHREE S/O P THIMMAPPA',90,'','3','A','',0,'',NULL,0,NULL),
('RITHIKA S/O PRAKASHA A',91,'','3','A','',0,'',NULL,0,NULL),
('SAI S/O RAMANJINI',92,'','3','A','',0,'',NULL,0,NULL),
('VINAY S/O T JAYARAMUDU',93,'','3','A','',0,'',NULL,0,NULL),
('P ABDUL RAHIMAN S/O P MOHAMMED GOUSE',94,'','3','A','',0,'',NULL,0,NULL),
('J SMITA S/O SHIVU',95,'','3','A','',0,'',NULL,0,NULL),
('M D RAYAN S/O MAHAMMAD GOUS',96,'','3','A','',0,'',NULL,0,NULL),
('VEENA S/O RAJA',97,'','3','A','',0,'',NULL,0,NULL),
('N TEJASHWINI S/O URUKUNDA',98,'','3','A','',0,'',NULL,0,NULL),
('D M GAGANASRI S/O CHENNADASARA MURALI',99,'','3','A','',0,'',NULL,0,NULL),
('G NIKHIL KUMAR S/O G VIJAYA KUMARA',100,'','3','A','',0,'',NULL,0,NULL),
('AKHIL S/O RAGHAVENDRA',101,'','3','A','',0,'',NULL,0,NULL),
('SIDDI SAMARTH S/O SIDDI SHANMUKA',102,'','4','A','',0,'',NULL,0,NULL),
('N MADHUMATI S/O N NAGARAJA',103,'','4','A','',0,'',NULL,0,NULL),
('SANTOSH N S/O N ASHOK',104,'','4','A','',0,'',NULL,0,NULL),
('SAKSHI PALIWAL S/O KANARAM',105,'','4','A','',0,'',NULL,0,NULL),
('C N SUNANDANA S/O C N SURYANARAYANA',106,'','4','A','',0,'',NULL,0,NULL),
('C D NIVEDITA S/O VEERESH A D',107,'','4','A','',0,'',NULL,0,NULL),
('SPANDANA S/O SINAPPA',108,'','4','A','',0,'',NULL,0,NULL),
('GEETHANJALI S/O PARASHURAAMA',109,'','4','A','',0,'',NULL,0,NULL),
('VIKRAM S/O RAGHAVENDRA',110,'','4','A','',0,'',NULL,0,NULL),
('MUPPURI ANAND MOHAN S/O M KONDAYYA',111,'','4','A','',0,'',NULL,0,NULL),
('K RENUKA S/O K RAVI',112,'','4','A','',0,'',NULL,0,NULL),
('INDU S/O C KUMAR',113,'','4','A','',0,'',NULL,0,NULL),
('AFSA JABIN S/O AMEER',114,'','4','A','',0,'',NULL,0,NULL),
('N JAYSORYA S/O N SHEKHARA',115,'','4','A','',0,'',NULL,0,NULL),
('S P SRUJAN S/O S PRADEEP',116,'','5','A','',0,'',NULL,0,NULL),
('C NANDINI S/O CHANNAYYA',117,'','5','A','',0,'',NULL,0,NULL),
('B SAI VINAYAKA S/O B RAJASHEKAR',118,'','5','A','',0,'',NULL,0,NULL),
('PRASAD S/O KRISHNA',119,'','5','A','',0,'',NULL,0,NULL),
('M ARUNKUMAR S/O M VEERESH',120,'','5','A','',0,'',NULL,0,NULL),
('D VIRAT ACHARI S/O D MALLIKARJUNA',121,'','5','A','',0,'',NULL,0,NULL),
('VINAYAKA S/O SHRINIVASA',122,'','5','A','',0,'',NULL,0,NULL),
('H NAYANA S/O H MAHESH',123,'','5','A','',0,'',NULL,0,NULL),
('C N NARASIMHA S/O C SURYA NARAYANA',124,'','5','A','',0,'',NULL,0,NULL),
('T GOUTHAMAKRISHNA S/O T JAYARAMUDU',125,'','5','A','',0,'',NULL,0,NULL),
('HARISH S/O THIPPERUDRA',126,'','5','A','',0,'',NULL,0,NULL),
('AKHIL SINGH S/O R MOHAN SINGH',127,'','5','A','',0,'',NULL,0,NULL),
('SANDEEP CHALAVADI S/O PAMANNA CHALAVADI',128,'','5','A','',0,'',NULL,0,NULL),
('R SAPAN MARIYAM S/O R MABBASHA',129,'','5','A','',0,'',NULL,0,NULL),
('T DIVYA S/O T HANUMANTHAPPA',130,'','5','A','',0,'',NULL,0,NULL),
('SURENDRA S/O VEERANNA',131,'','5','A','',0,'',NULL,0,NULL),
('INDU S/O HANUMAIAH',132,'','6','A','',0,'',NULL,0,NULL),
('CHANDRA MUKHI S/O RAJAHOUSA KUMAR',133,'','6','A','',0,'',NULL,0,NULL),
('HEMANTH S/O HANUMANTHA',134,'','6','A','',0,'',NULL,0,NULL),
('M DHANUNJAYA S/O M NAGENDRA',135,'','6','A','',0,'',NULL,0,NULL),
('SHASHANK K S/O LOKESHA K',136,'','6','A','',0,'',NULL,0,NULL),
('KRUPAVARAM S/O PRABHAKAR',137,'','6','A','',0,'',NULL,0,NULL),
('H M SHIVAKUMAR S/O H M SHASHIDHAR SWAMY',138,'','6','A','',0,'',NULL,0,NULL),
('M TANUSHRE S/O M BHASKAR',139,'','6','A','',0,'',NULL,0,NULL),
('K B ROHIT S/O BASAVARAJ',140,'','6','A','',0,'',NULL,0,NULL),
('A NITHIN KUMAR S/O A SRINIVAS',141,'','6','A','',0,'',NULL,0,NULL),
('KARTHIK S/O DEVIDAS M SHETH',142,'','6','A','',0,'',NULL,0,NULL),
('MOHAMMAD JUNED S/O R MABBASHA',143,'','6','A','',0,'',NULL,0,NULL),
('K RAJU S/O K RAVI',144,'','6','A','',0,'',NULL,0,NULL),
('P ABDUL RAHIM S/O P MAHAMAD GOUSE',145,'','6','A','',0,'',NULL,0,NULL),
('K SUHASHINI S/O K MANJUNATHA',146,'','6','A','',0,'',NULL,0,NULL),
('NIKHIL S/O RAGHAVENDRA',147,'','3','A','',0,'',NULL,0,NULL),
('C ANILA S/O C YALLAPPA',148,'','3','A','',0,'',NULL,0,NULL),
('MAYURI K S/O K VEERASHEKHAR',149,'','3','A','',0,'',NULL,0,NULL),
('JEEVAN BABU S/O RAJASHEKHAR',150,'','4','A','',0,'',NULL,0,NULL),
('VINAY KUMAR S/O RAVI KUMAR',151,'','4','A','',0,'',NULL,0,NULL),
('DEEKSHA G S/O G SHREEKARA',152,'','4','A','',0,'',NULL,0,NULL),
('VIJAY NIRMALA S/O RAVI KUMAR',153,'','4','A','',0,'',NULL,0,NULL),
('M AJAY KUMAR S/O M SHARANA BASAVARAJA',154,'','4','A','',0,'',NULL,0,NULL),
('C M NANDEESHA S/O C M MANJUNATHA SWAMY',155,'','4','A','',0,'',NULL,0,NULL),
('H SHRIDHAR S/O H HULUGAPPA',156,'','5','A','',0,'',NULL,0,NULL),
('M SHREYA S/O M SHARANABASAVARAJA',157,'','6','A','',0,'',NULL,0,NULL),
('THOHID S/O UMAR BASHA',158,'','6','A','',0,'',NULL,0,NULL),
('U VASU S/O VENKOBA',159,'','6','A','',0,'',NULL,0,NULL),
('AYISHA S/O MABASHA',160,'','6','A','',0,'',NULL,0,NULL),
('U SABA TABASUM S/O U SHAKIR AHMED',161,'','6','A','',0,'',NULL,0,NULL),
('K VIRUPAKSHI S/O K YARRISWAMY',162,'','6','A','',0,'',NULL,0,NULL),
('MAHAMMED ROSHAN JAMEER S/O HUSEN BASHA',163,'','6','A','',0,'',NULL,0,NULL),
('CHETAN S/O KOMANEPPA',164,'','6','A','',0,'',NULL,0,NULL),
('ROSHINI D/O K MARUTHI',165,'Male','Nursery','A','1',9742321104,'',NULL,0,NULL),
('SHREENIDHI P S D/O MALLIKARJUNA ',166,'Male','Nursery','A','2',9449245758,'',NULL,0,NULL),
('B VARSHITHA D/O BASAVARAJA',167,'Male','Nursery','A','3',9741765050,'',NULL,0,NULL),
('MAHERA D/O MEHABOOB BASHA',168,'Male','Nursery','A','4',9632642740,'',NULL,0,NULL),
('VARUNI SATHISH D/O SATHISH RAMPURA',169,'Male','Nursery','A','5',9448694977,'',NULL,0,NULL),
('M MAHERA D/O M SHEKSHAVALI',170,'Male','Nursery','A','6',9731350528,'',NULL,0,NULL),
('VAISHNAVI M D/O M VEERESH',171,'Male','Nursery','A','7',8431936372,'',NULL,0,NULL),
('NANDINI D/O NARASIMHALU ',172,'Male','Nursery','A','8',9742567880,'',NULL,0,NULL),
('EIMAAN A R D/O A RAJASAB',173,'Male','Nursery','A','9',8431633432,'',NULL,0,NULL),
('K ALTAF S/O ALLABAKSHI',174,'Male','Nursery','A','10',9663811862,'',NULL,0,NULL),
('KRISHNA CHALUVADI S/O MANJUNATHA CHALUVADI',175,'Male','Nursery','A','11',9611568889,'',NULL,0,NULL),
('DHANUSH S/O NAGARAJA ',176,'Male','Nursery','A','12',8867485675,'',NULL,0,NULL),
('PRABHU S/O SUNDAR RAJ',177,'Male','Nursery','A','13',8722002316,'',NULL,0,NULL),
('ARYAVARDHAN S/O ANJANEYA',178,'Male','Nursery','A','14',7026310589,'',NULL,0,NULL),
('NANDAN M S/O M VEERESH',179,'Male','LKG','A','1',8431936372,'',NULL,0,NULL),
('SHARATH S/O HULUGAPPA',180,'Male','LKG','A','2',9108194546,'',NULL,0,NULL),
('SATVIK M C S/O NAGARAJ CHALUVADI',181,'Male','LKG','A','3',7619165918,'',NULL,0,NULL),
('MAHAMAD AFAN S/O ANSAR BASHA',182,'Male','LKG','A','4',7760678738,'',NULL,0,NULL),
('S KOUSHIK S/O RAMU',183,'Male','LKG','A','5',7619230215,'',NULL,0,NULL),
('P MAHAMAD ZUNOORAIN S/O P MAHAMAD KHALIL',184,'Male','LKG','A','6',0,'',NULL,0,NULL),
('SAMARTH S/O KRISHNA',185,'Male','LKG','A','7',7676247406,'',NULL,0,NULL),
('C CHETAN KUMAR S/O C KOTRESH',186,'Male','LKG','A','8',9880876842,'',NULL,0,NULL),
('PRITHAM S/O C HALESH',187,'Male','LKG','A','9',9731465912,'',NULL,0,NULL),
('BINDU D/O RAVI',188,'Male','LKG','A','10',9731458826,'',NULL,0,NULL),
('FARNAZ D/O ALLAUDDIN',189,'Male','LKG','A','11',8904228105,'',NULL,0,NULL),
('REKHA D/O S BHIMANNA',190,'Male','LKG','A','12',7090983270,'',NULL,0,''),
('T AMMU D/O JAIRAMUDU',191,'Male','LKG','A','13',9071133525,'',NULL,0,NULL),
('V SHAKTI PRIYA D/O V SHANKARACHARYA',192,'Male','LKG','A','14',9036932166,'',NULL,0,NULL),
('ARFA D/O NAJIR BASHA',193,'Male','LKG','A','15',9743554187,'',NULL,0,NULL),
('R GIRIJA D/O RAGHU',194,'Male','LKG','A','16',6363652828,'',NULL,0,NULL),
('SANGEETHA D/O RAJA',195,'Male','LKG','A','17',9743845067,'',NULL,0,NULL),
('H HARINI D/O H MARUTHI ',196,'Male','LKG','A','18',8722908490,'',NULL,0,NULL),
('S AFIYA TAJ D/O ASLAM BASHA ',197,'Male','LKG','A','19',7760678738,'',NULL,0,NULL),
('ALIYA D/O NOOR ',198,'Male','LKG','A','20',8095057797,'',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=421 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stud_basic2`
--
LOCK TABLES `stud_basic2` WRITE;
/*!40000 ALTER TABLE `stud_basic2` DISABLE KEYS */;
INSERT INTO `stud_basic2` VALUES
(1,165,1,1,4000,1000,3000,0,'',NULL),
(2,165,1,2,2000,2000,0,0,'',NULL),
(3,165,1,3,0,0,0,0,'',NULL),
(4,165,1,4,0,0,0,0,'',NULL),
(5,166,1,1,4000,4000,0,0,'',NULL),
(6,166,1,2,2000,0,2000,0,'',NULL),
(7,166,1,3,0,0,0,0,'',NULL),
(8,166,1,4,0,0,0,0,'',NULL),
(9,167,1,1,4000,1000,3000,0,'',NULL),
(10,167,1,2,2000,2000,0,0,'',NULL),
(11,167,1,3,0,0,0,0,'',NULL),
(12,167,1,4,0,0,0,0,'',NULL),
(13,168,1,1,4000,0,4000,0,'',NULL),
(14,168,1,2,2000,2000,0,0,'',NULL),
(15,168,1,3,0,0,0,0,'',NULL),
(16,168,1,4,0,0,0,0,'',NULL),
(17,169,1,1,4000,0,4000,0,'',NULL),
(18,169,1,2,2000,2000,0,0,'',NULL),
(19,169,1,3,0,0,0,0,'',NULL),
(20,169,1,4,0,0,0,0,'',NULL),
(21,170,1,1,4000,1000,3000,0,'',NULL),
(22,170,1,2,2000,2000,0,0,'',NULL),
(23,170,1,3,0,0,0,0,'',NULL),
(24,170,1,4,0,0,0,0,'',NULL),
(25,171,1,1,4000,0,4000,0,'',NULL),
(26,171,1,2,2000,2000,0,0,'',NULL),
(27,171,1,3,0,0,0,0,'',NULL),
(28,171,1,4,0,0,0,0,'',NULL),
(29,172,1,1,4000,0,4000,0,'',NULL),
(30,172,1,2,2000,2000,0,0,'',NULL),
(31,172,1,3,0,0,0,0,'',NULL),
(32,172,1,4,0,0,0,0,'',NULL),
(33,173,1,1,4000,0,4000,0,'',NULL),
(34,173,1,2,2000,0,2000,0,'',NULL),
(35,173,1,3,0,0,0,0,'',NULL),
(36,173,1,4,0,0,0,0,'',NULL),
(37,174,1,1,4000,3000,1000,0,'',NULL),
(38,174,1,2,2000,0,2000,0,'',NULL),
(39,174,1,3,0,0,0,0,'',NULL),
(40,174,1,4,0,0,0,0,'',NULL),
(41,175,1,1,4000,1000,3000,0,'',NULL),
(42,175,1,2,2000,1000,1000,0,'',NULL),
(43,175,1,3,0,0,0,0,'',NULL),
(44,175,1,4,0,0,0,0,'',NULL),
(45,176,1,1,4000,0,4000,0,'',NULL),
(46,176,1,2,2000,2000,0,0,'',NULL),
(47,176,1,3,0,0,0,0,'',NULL),
(48,176,1,4,0,0,0,0,'',NULL),
(49,177,1,1,4000,0,4000,0,'',NULL),
(50,177,1,2,2000,2000,0,0,'',NULL),
(51,177,1,3,0,0,0,0,'',NULL),
(52,177,1,4,0,0,0,0,'',NULL),
(53,178,1,1,4000,0,4000,0,'',NULL),
(54,178,1,2,2000,2000,0,0,'',NULL),
(55,178,1,3,0,0,0,0,'',NULL),
(56,178,1,4,0,0,0,0,'',NULL),
(57,179,1,1,4000,0,4000,0,'',NULL),
(58,179,1,2,2000,2000,0,0,'',NULL),
(59,179,1,3,0,0,0,0,'',NULL),
(60,179,1,4,0,0,0,0,'',NULL),
(61,180,1,1,4000,1000,3000,0,'',NULL),
(62,180,1,2,2000,0,2000,0,'',NULL),
(63,180,1,3,0,0,0,0,'',NULL),
(64,180,1,4,0,0,0,0,'',NULL),
(65,181,1,1,4000,1000,3000,0,'',NULL),
(66,181,1,2,2000,0,2000,0,'',NULL),
(67,181,1,3,0,0,0,0,'',NULL),
(68,181,1,4,0,0,0,0,'',NULL),
(69,182,1,1,4000,0,4000,0,'',NULL),
(70,182,1,2,2000,1000,1000,0,'',NULL),
(71,182,1,3,0,0,0,0,'',NULL),
(72,182,1,4,0,0,0,0,'',NULL),
(73,183,1,1,4000,0,4000,0,'',NULL),
(74,183,1,2,2000,0,2000,0,'',NULL),
(75,183,1,3,0,0,0,0,'',NULL),
(76,183,1,4,0,0,0,0,'',NULL),
(77,184,1,1,4000,1000,3000,0,'',NULL),
(78,184,1,2,2000,0,2000,0,'',NULL),
(79,184,1,3,0,0,0,0,'',NULL),
(80,184,1,4,0,0,0,0,'',NULL),
(81,185,1,1,4000,0,4000,0,'',NULL),
(82,185,1,2,2000,2000,0,0,'',NULL),
(83,185,1,3,0,0,0,0,'',NULL),
(84,185,1,4,0,0,0,0,'',NULL),
(85,186,1,1,4000,1000,3000,0,'',NULL),
(86,186,1,2,2000,0,2000,0,'',NULL),
(87,186,1,3,0,0,0,0,'',NULL),
(88,186,1,4,0,0,0,0,'',NULL),
(89,187,1,1,4000,1000,3000,0,'',NULL),
(90,187,1,2,2000,0,2000,0,'',NULL),
(91,187,1,3,0,0,0,0,'',NULL),
(92,187,1,4,0,0,0,0,'',NULL),
(93,188,1,1,4000,0,4000,0,'',NULL),
(94,188,1,2,2000,2000,0,0,'',NULL),
(97,189,1,1,4000,500,3500,0,'',NULL),
(98,189,1,2,2000,2000,0,0,'',NULL),
(99,189,1,3,0,0,0,0,'',NULL),
(100,189,1,4,0,0,0,0,'',NULL),
(101,190,1,1,4000,0,4000,0,'',NULL),
(102,190,1,2,2000,1000,1000,0,'',NULL),
(103,190,1,3,0,0,0,0,'',NULL),
(104,190,1,4,0,0,0,0,'',NULL),
(105,191,1,1,4000,0,4000,0,'',NULL),
(106,191,1,2,2000,0,2000,0,'',NULL),
(107,191,1,3,0,0,0,0,'',NULL),
(108,191,1,4,0,0,0,0,'',NULL),
(109,192,1,1,4000,1000,3000,0,'',NULL),
(110,192,1,2,2000,0,2000,0,'',NULL),
(111,192,1,3,0,0,0,0,'',NULL),
(112,192,1,4,0,0,0,0,'',NULL),
(113,193,1,1,4000,0,4000,0,'',NULL),
(114,193,1,2,2000,0,2000,0,'',NULL),
(115,193,1,3,0,0,0,0,'',NULL),
(116,193,1,4,0,0,0,0,'',NULL),
(117,194,1,1,4000,0,4000,0,'',NULL),
(118,194,1,2,2000,2000,0,0,'',NULL),
(119,194,1,3,0,0,0,0,'',NULL),
(120,194,1,4,0,0,0,0,'',NULL),
(121,195,1,1,4000,4000,0,0,'',NULL),
(122,195,1,2,2000,0,2000,0,'',NULL),
(123,195,1,3,0,0,0,0,'',NULL),
(124,195,1,4,0,0,0,0,'',NULL),
(125,196,1,1,4000,1000,3000,0,'',NULL),
(126,196,1,2,2000,0,2000,0,'',NULL),
(127,196,1,3,0,0,0,0,'',NULL),
(128,196,1,4,0,0,0,0,'',NULL),
(129,197,1,1,4000,0,4000,0,'',NULL),
(130,197,1,2,2000,1000,1000,0,'',NULL),
(131,197,1,3,0,0,0,0,'',NULL),
(132,197,1,4,0,0,0,0,'',NULL),
(133,198,1,1,4000,1000,3000,0,'',NULL),
(134,198,1,2,2000,2000,0,0,'',NULL),
(135,198,1,3,0,0,0,0,'',NULL),
(136,198,1,4,0,0,0,0,'',NULL),
(137,33,1,1,4000,2000,2000,0,'',NULL),
(138,33,1,2,2000,2000,0,0,'',NULL),
(139,31,1,1,4000,0,4000,0,'',NULL),
(140,31,1,2,2000,2000,0,0,'',NULL),
(141,32,1,1,4000,1000,3000,0,'',NULL),
(142,32,1,2,2000,0,2000,0,'',NULL),
(143,36,1,1,4000,0,4000,0,'',NULL),
(144,36,1,2,2000,0,2000,0,'',NULL),
(145,27,1,1,4000,0,4000,0,'',NULL),
(146,27,1,2,2000,1000,1000,0,'',NULL),
(147,23,1,1,4000,0,4000,0,'',NULL),
(148,23,1,2,2000,2000,0,0,'',NULL),
(149,30,1,1,4000,4000,0,0,'',NULL),
(150,30,1,2,2000,0,2000,0,'',NULL),
(151,25,1,1,4000,1000,3000,0,'',NULL),
(152,25,1,2,2000,0,2000,0,'',NULL),
(153,39,1,1,4000,0,4000,0,'',NULL),
(154,39,1,2,2000,0,2000,0,'',NULL),
(155,26,1,1,4000,0,4000,0,'',NULL),
(156,26,1,2,2000,2000,0,0,'',NULL),
(157,37,1,1,4000,0,4000,0,'',NULL),
(158,37,1,2,2000,0,2000,0,'',NULL),
(159,28,1,1,4000,1000,3000,0,'',NULL),
(160,28,1,2,2000,2000,0,0,'',NULL),
(161,35,1,1,4000,1000,3000,0,'',NULL),
(162,35,1,2,2000,2000,0,0,'',NULL),
(163,24,1,1,4000,0,4000,0,'',NULL),
(164,24,1,2,2000,2000,0,0,'',NULL),
(165,22,1,1,4000,0,4000,0,'',NULL),
(166,22,1,2,2000,2000,0,0,'',NULL),
(167,29,1,1,4000,0,4000,0,'',NULL),
(168,29,1,2,2000,2000,0,0,'',NULL),
(169,40,1,1,4000,0,4000,0,'',NULL),
(170,40,1,2,2000,0,2000,0,'',NULL),
(171,38,1,1,4000,0,4000,0,'',NULL),
(172,38,1,2,2000,0,2000,0,'',NULL),
(173,34,1,1,4000,0,4000,0,'',NULL),
(174,34,1,2,2000,0,2000,0,'',NULL),
(175,58,2,2,2000,2000,0,0,'',NULL),
(176,58,2,5,5000,0,5000,0,'',NULL),
(177,66,2,2,2000,0,2000,0,'',NULL),
(178,66,2,5,5000,0,5000,0,'',NULL),
(179,73,2,2,2000,2000,0,0,'',NULL),
(180,73,2,5,5000,2000,3000,0,'',NULL),
(181,70,2,2,2000,2000,0,0,'',NULL),
(182,70,2,5,5000,1000,4000,0,'',NULL),
(183,67,2,2,2000,1000,1000,0,'',NULL),
(184,67,2,5,5000,0,5000,0,'',NULL),
(185,52,2,2,2000,1000,1000,0,'',NULL),
(186,52,2,5,5000,0,5000,0,'',NULL),
(187,47,2,2,2000,2000,0,0,'',NULL),
(188,47,2,5,5000,1000,4000,0,'',NULL),
(189,65,2,2,2000,1500,500,0,'',NULL),
(190,65,2,5,5000,0,5000,0,'',NULL),
(191,55,2,2,2000,2000,0,0,'',NULL),
(192,55,2,5,5000,2000,3000,0,'',NULL),
(193,54,2,2,2000,2000,0,0,'',NULL),
(194,54,2,5,5000,1000,4000,0,'',NULL),
(195,46,2,2,2000,2000,0,0,'',NULL),
(196,46,2,5,5000,0,5000,0,'',NULL),
(197,64,2,2,2000,0,2000,0,'',NULL),
(198,64,2,5,5000,0,5000,0,'',NULL),
(199,43,2,2,2000,1500,500,0,'',NULL),
(200,43,2,5,5000,0,5000,0,'',NULL),
(201,42,2,2,2000,2000,0,0,'',NULL),
(202,42,2,5,5000,1000,4000,0,'',NULL),
(203,44,2,2,2000,2000,0,0,'',NULL),
(204,44,2,5,5000,1000,4000,0,'',NULL),
(205,72,2,2,2000,2000,0,0,'',NULL),
(206,72,2,5,5000,3000,2000,0,'',NULL),
(207,59,2,2,2000,2000,0,0,'',NULL),
(208,59,2,5,5000,0,5000,0,'',NULL),
(209,51,2,2,2000,2000,0,0,'',NULL),
(210,51,2,5,5000,0,5000,0,'',NULL),
(211,62,2,2,2000,2000,0,0,'',NULL),
(212,62,2,5,5000,0,5000,0,'',NULL),
(213,69,2,2,2000,1000,1000,0,'',NULL),
(214,69,2,5,5000,0,5000,0,'',NULL),
(215,61,2,2,2000,2000,0,0,'',NULL),
(216,61,2,5,5000,1500,3500,0,'',NULL),
(217,57,2,2,2000,1000,1000,0,'',NULL),
(218,57,2,5,5000,0,5000,0,'',NULL),
(219,68,2,2,2000,1000,1000,0,'',NULL),
(220,68,2,5,5000,0,5000,0,'',NULL),
(221,53,2,2,2000,1500,500,0,'',NULL),
(222,53,2,5,5000,0,5000,0,'',NULL),
(223,71,2,2,2000,2000,0,0,'',NULL),
(224,71,2,5,5000,500,4500,0,'',NULL),
(225,48,2,2,2000,1000,1000,0,'',NULL),
(226,48,2,5,5000,0,5000,0,'',NULL),
(227,50,2,2,2000,0,2000,0,'',NULL),
(228,50,2,5,5000,0,5000,0,'',NULL),
(229,49,2,2,2000,2000,0,0,'',NULL),
(230,49,2,5,5000,2000,3000,0,'',NULL),
(231,45,2,2,2000,2000,0,0,'',NULL),
(232,45,2,5,5000,1000,4000,0,'',NULL),
(233,56,2,2,2000,2000,0,0,'',NULL),
(234,56,2,5,5000,2000,3000,0,'',NULL),
(235,63,2,2,2000,2000,0,0,'',NULL),
(236,63,2,5,5000,1500,3500,0,'',NULL),
(237,60,2,2,2000,2000,0,0,'',NULL),
(238,60,2,5,5000,0,5000,0,'',NULL),
(239,80,2,2,2000,0,2000,0,'',NULL),
(240,80,2,5,5000,0,5000,0,'',NULL),
(241,83,2,2,2000,1000,1000,0,'',NULL),
(242,83,2,5,5000,0,5000,0,'',NULL),
(243,75,2,2,2000,0,2000,0,'',NULL),
(244,75,2,5,5000,0,5000,0,'',NULL),
(245,85,2,2,2000,2000,0,0,'',NULL),
(246,85,2,5,5000,0,5000,0,'',NULL),
(247,77,2,2,2000,1000,1000,0,'',NULL),
(248,77,2,5,5000,0,5000,0,'',NULL),
(249,82,2,2,2000,1500,500,0,'',NULL),
(250,82,2,5,5000,0,5000,0,'',NULL),
(251,76,2,2,2000,1000,1000,0,'',NULL),
(252,76,2,5,5000,0,5000,0,'',NULL),
(253,88,2,2,2000,2000,0,0,'',NULL),
(254,88,2,5,5000,0,5000,0,'',NULL),
(255,86,2,2,2000,2000,0,0,'',NULL),
(256,86,2,5,5000,1000,4000,0,'',NULL),
(257,79,2,2,2000,1000,1000,0,'',NULL),
(258,79,2,5,5000,0,5000,0,'',NULL),
(259,81,2,2,2000,0,2000,0,'',NULL),
(260,81,2,5,5000,0,5000,0,'',NULL),
(261,78,2,2,2000,500,1500,0,'',NULL),
(262,78,2,5,5000,0,5000,0,'',NULL),
(263,87,2,2,2000,1000,1000,0,'',NULL),
(264,87,2,5,5000,0,5000,0,'',NULL),
(265,74,2,2,2000,1500,500,0,'',NULL),
(266,74,2,5,5000,0,5000,0,'',NULL),
(267,84,2,2,2000,1000,1000,0,'',NULL),
(268,84,2,5,5000,0,5000,0,'',NULL),
(269,101,2,2,2000,0,2000,0,'',NULL),
(270,101,2,5,5000,0,5000,0,'',NULL),
(271,148,2,2,2000,0,2000,0,'',NULL),
(272,148,2,5,5000,0,5000,0,'',NULL),
(273,99,2,2,2000,1000,1000,0,'',NULL),
(274,99,2,5,5000,0,5000,0,'',NULL),
(275,100,2,2,2000,2000,0,0,'',NULL),
(276,100,2,5,5000,0,5000,0,'',NULL),
(277,95,2,2,2000,2000,0,0,'',NULL),
(278,95,2,5,5000,0,5000,0,'',NULL),
(279,89,2,2,2000,1000,1000,0,'',NULL),
(280,89,2,5,5000,0,5000,0,'',NULL),
(281,96,2,2,2000,1000,1000,0,'',NULL),
(282,96,2,5,5000,0,5000,0,'',NULL),
(283,149,2,2,2000,2000,0,0,'',NULL),
(284,149,2,5,5000,1000,4000,0,'',NULL),
(285,98,2,2,2000,1000,1000,0,'',NULL),
(286,98,2,5,5000,0,5000,0,'',NULL),
(287,147,2,2,2000,2000,0,0,'',NULL),
(288,147,2,5,5000,0,5000,0,'',NULL),
(289,94,2,2,2000,1000,1000,0,'',NULL),
(290,94,2,5,5000,0,5000,0,'',NULL),
(291,90,2,2,2000,0,2000,0,'',NULL),
(292,90,2,5,5000,0,5000,0,'',NULL),
(293,91,2,2,2000,2000,0,0,'',NULL),
(294,91,2,5,5000,0,5000,0,'',NULL),
(295,92,2,2,2000,1500,500,0,'',NULL),
(296,92,2,5,5000,0,5000,0,'',NULL),
(297,97,2,2,2000,2000,0,0,'',NULL),
(298,97,2,5,5000,1000,4000,0,'',NULL),
(299,93,2,2,2000,0,2000,0,'',NULL),
(300,93,2,5,5000,0,5000,0,'',NULL),
(301,114,2,2,2000,2000,0,0,'',NULL),
(302,114,2,5,5000,0,5000,0,'',NULL),
(303,107,2,2,2000,1000,1000,0,'',NULL),
(304,107,2,5,5000,0,5000,0,'',NULL),
(305,155,2,2,2000,2000,0,0,'',NULL),
(306,155,2,5,5000,1500,3500,0,'',NULL),
(307,106,2,2,2000,2000,0,0,'',NULL),
(308,106,2,5,5000,2000,3000,0,'',NULL),
(309,152,2,2,2000,2000,0,0,'',NULL),
(310,152,2,5,5000,0,5000,0,'',NULL),
(311,109,2,2,2000,0,2000,0,'',NULL),
(312,109,2,5,5000,0,5000,0,'',NULL),
(313,113,2,2,2000,0,2000,0,'',NULL),
(314,113,2,5,5000,0,5000,0,'',NULL),
(315,150,2,2,2000,2000,0,0,'',NULL),
(316,150,2,5,5000,1000,4000,0,'',NULL),
(317,112,2,2,2000,0,2000,0,'',NULL),
(318,112,2,5,5000,0,5000,0,'',NULL),
(319,154,2,2,2000,0,2000,0,'',NULL),
(320,154,2,5,5000,0,5000,0,'',NULL),
(321,111,2,2,2000,2000,0,0,'',NULL),
(322,111,2,5,5000,0,5000,0,'',NULL),
(323,115,2,2,2000,0,2000,0,'',NULL),
(324,115,2,5,5000,0,5000,0,'',NULL),
(325,103,2,2,2000,500,1500,0,'',NULL),
(326,103,2,5,5000,0,5000,0,'',NULL),
(327,105,2,2,2000,2000,0,0,'',NULL),
(328,105,2,5,5000,1000,4000,0,'',NULL),
(329,104,2,2,2000,2000,0,0,'',NULL),
(330,104,2,5,5000,0,5000,0,'',NULL),
(331,102,2,2,2000,2000,0,0,'',NULL),
(332,102,2,5,5000,5000,0,0,'',NULL),
(333,108,2,2,2000,2000,0,0,'',NULL),
(334,108,2,5,5000,2000,3000,0,'',NULL),
(335,153,2,2,2000,1000,1000,0,'',NULL),
(336,153,2,5,5000,0,5000,0,'',NULL),
(337,110,2,2,2000,0,2000,0,'',NULL),
(338,110,2,5,5000,0,5000,0,'',NULL),
(339,151,2,2,2000,1500,500,0,'',NULL),
(340,151,2,5,5000,0,5000,0,'',NULL),
(341,127,2,2,2000,0,2000,0,'',NULL),
(342,127,2,5,5000,0,5000,0,'',NULL),
(343,118,2,2,2000,1500,500,0,'',NULL),
(344,118,2,5,5000,0,5000,0,'',NULL),
(345,124,2,2,2000,2000,0,0,'',NULL),
(346,124,2,5,5000,2000,3000,0,'',NULL),
(347,117,2,2,2000,2000,0,0,'',NULL),
(348,117,2,5,5000,0,5000,0,'',NULL),
(349,121,2,2,2000,1500,500,0,'',NULL),
(350,121,2,5,5000,0,5000,0,'',NULL),
(351,123,2,2,2000,0,2000,0,'',NULL),
(352,123,2,5,5000,0,5000,0,'',NULL),
(353,156,2,2,2000,2000,0,0,'',NULL),
(354,156,2,5,5000,500,4500,0,'',NULL),
(355,126,2,2,2000,2000,0,0,'',NULL),
(356,126,2,5,5000,0,5000,0,'',NULL),
(357,120,2,2,2000,0,2000,0,'',NULL),
(358,120,2,5,5000,0,5000,0,'',NULL),
(359,119,2,2,2000,0,2000,0,'',NULL),
(360,119,2,5,5000,0,5000,0,'',NULL),
(361,129,2,2,2000,0,2000,0,'',NULL),
(362,129,2,5,5000,0,5000,0,'',NULL),
(363,116,2,2,2000,0,2000,0,'',NULL),
(364,116,2,5,5000,0,5000,0,'',NULL),
(365,128,2,2,2000,1000,1000,0,'',NULL),
(366,128,2,5,5000,0,5000,0,'',NULL),
(367,131,2,2,2000,1000,1000,0,'',NULL),
(368,131,2,5,5000,0,5000,0,'',NULL),
(369,130,2,2,2000,2000,0,0,'',NULL),
(370,130,2,5,5000,1500,3500,0,'',NULL),
(371,125,2,2,2000,0,2000,0,'',NULL),
(372,125,2,5,5000,0,5000,0,'',NULL),
(373,122,2,2,2000,2000,0,0,'',NULL),
(374,122,2,5,5000,0,5000,0,'',NULL),
(375,141,2,2,2000,0,2000,0,'',NULL),
(376,141,2,5,5000,0,5000,0,'',NULL),
(377,160,2,2,2000,2000,0,0,'',NULL),
(378,160,2,5,5000,0,5000,0,'',NULL),
(379,133,2,2,2000,0,2000,0,'',NULL),
(380,133,2,5,5000,0,5000,0,'',NULL),
(381,164,2,2,2000,0,2000,0,'',NULL),
(382,164,2,5,5000,0,5000,0,'',NULL),
(383,138,2,2,2000,2000,0,0,'',NULL),
(384,138,2,5,5000,0,5000,0,'',NULL),
(385,134,2,2,2000,2000,0,0,'',NULL),
(386,134,2,5,5000,0,5000,0,'',NULL),
(387,132,2,2,2000,0,2000,0,'',NULL),
(388,132,2,5,5000,0,5000,0,'',NULL),
(389,140,2,2,2000,1500,500,0,'',NULL),
(390,140,2,5,5000,0,5000,0,'',NULL),
(391,144,2,2,2000,0,2000,0,'',NULL),
(392,144,2,5,5000,0,5000,0,'',NULL),
(393,146,2,2,2000,2000,0,0,'',NULL),
(394,146,2,5,5000,0,5000,0,'',NULL),
(395,162,2,2,2000,2000,0,0,'',NULL),
(396,162,2,5,5000,1500,3500,0,'',NULL),
(397,142,2,2,2000,2000,0,0,'',NULL),
(398,142,2,5,5000,0,5000,0,'',NULL),
(399,137,2,2,2000,1000,1000,0,'',NULL),
(400,137,2,5,5000,0,5000,0,'',NULL),
(401,135,2,2,2000,2000,0,0,'',NULL),
(402,135,2,5,5000,1000,4000,0,'',NULL),
(403,157,2,2,2000,0,2000,0,'',NULL),
(404,157,2,5,5000,0,5000,0,'',NULL),
(405,139,2,2,2000,1500,500,0,'',NULL),
(406,139,2,5,5000,0,5000,0,'',NULL),
(407,163,2,2,2000,0,2000,0,'',NULL),
(408,163,2,5,5000,0,5000,0,'',NULL),
(409,143,2,2,2000,0,2000,0,'',NULL),
(410,143,2,5,5000,0,5000,0,'',NULL),
(411,145,2,2,2000,1000,1000,0,'',NULL),
(412,145,2,5,5000,0,5000,0,'',NULL),
(413,136,2,2,2000,1500,500,0,'',NULL),
(414,136,2,5,5000,0,5000,0,'',NULL),
(415,158,2,2,2000,0,2000,0,'',NULL),
(416,158,2,5,5000,0,5000,0,'',NULL),
(417,161,2,2,2000,2000,0,0,'',NULL),
(418,161,2,5,5000,1000,4000,0,'',NULL),
(419,159,2,2,2000,2000,0,0,'',NULL),
(420,159,2,5,5000,1000,4000,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=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sub_head`
--
LOCK TABLES `sub_head` WRITE;
/*!40000 ALTER TABLE `sub_head` DISABLE KEYS */;
INSERT INTO `sub_head` VALUES
('TUTION FEE',1,'4000','N'),
('DEVELOPMENT FEE',2,'2000','N'),
('EXAM FEE',3,'400','N'),
('COMPUTER FEE ETC',4,'300','N'),
('TUTION FEE 1-6',5,'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 AUTO_INCREMENT,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`subcategoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbladmin`
--
LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblbrand`
--
DROP TABLE IF EXISTS `tblbrand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblbrand` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BrandName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblbrand`
--
LOCK TABLES `tblbrand` WRITE;
/*!40000 ALTER TABLE `tblbrand` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblbrand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcart`
--
DROP TABLE IF EXISTS `tblcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcart` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductId` int(5) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`ProductQty` int(11) DEFAULT NULL,
`IsCheckOut` int(5) DEFAULT NULL,
`CartDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcart`
--
LOCK TABLES `tblcart` WRITE;
/*!40000 ALTER TABLE `tblcart` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcategory`
--
DROP TABLE IF EXISTS `tblcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategory`
--
LOCK TABLES `tblcategory` WRITE;
/*!40000 ALTER TABLE `tblcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcustomer`
--
DROP TABLE IF EXISTS `tblcustomer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcustomer` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BillingNumber` varchar(120) DEFAULT NULL,
`CustomerName` varchar(120) DEFAULT NULL,
`MobileNumber` bigint(11) DEFAULT NULL,
`ModeofPayment` varchar(50) DEFAULT NULL,
`BillingDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`),
KEY `BillingNumber` (`BillingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcustomer`
--
LOCK TABLES `tblcustomer` WRITE;
/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblproducts`
--
DROP TABLE IF EXISTS `tblproducts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblproducts` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(200) DEFAULT NULL,
`CatID` int(5) DEFAULT NULL,
`SubcatID` int(5) DEFAULT NULL,
`BrandName` varchar(200) DEFAULT NULL,
`ModelNumber` varchar(200) DEFAULT NULL,
`Stock` int(10) DEFAULT NULL,
`Price` decimal(10,0) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblproducts`
--
LOCK TABLES `tblproducts` WRITE;
/*!40000 ALTER TABLE `tblproducts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblproducts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblsubcategory`
--
DROP TABLE IF EXISTS `tblsubcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblsubcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CatID` int(5) DEFAULT NULL,
`SubCategoryname` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblsubcategory`
--
LOCK TABLES `tblsubcategory` WRITE;
/*!40000 ALTER TABLE `tblsubcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`reference` varchar(255) DEFAULT NULL,
`transactiondate` date NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
`file` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transaction`
--
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_permission`
--
DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`menu` varchar(500) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_permission`
--
LOCK TABLES `user_permission` WRITE;
/*!40000 ALTER TABLE `user_permission` DISABLE KEYS */;
INSERT INTO `user_permission` VALUES
(1,76,'class_division',1),
(2,76,'head',1),
(3,76,'update_student',1),
(4,76,'pay_fees',1),
(5,76,'balance_reports',1),
(6,76,'discount',1),
(7,76,'sub_head',1),
(8,76,'fees_receipt_head',1),
(9,76,'apply_fees_code',1),
(10,76,'payment_approve',1),
(11,76,'inventory',1),
(12,76,'bank',1),
(13,76,'new_student',1),
(14,76,'remove_fees_code',1),
(15,76,'daily_reports',1),
(16,76,'utility',1),
(17,94,'pay_fees',1),
(18,94,'new_student',1);
/*!40000 ALTER TABLE `user_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usermanagement`
--
DROP TABLE IF EXISTS `usermanagement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usermanagement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usermanagement`
--
LOCK TABLES `usermanagement` WRITE;
/*!40000 ALTER TABLE `usermanagement` DISABLE KEYS */;
/*!40000 ALTER TABLE `usermanagement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` char(64) NOT NULL,
`salt` char(16) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`passwordText` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(76,'adminFees303','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'),
(93,'123','c87c5a00de39b8fa3d9bdce1a89890c67480e3c47fe2dcbdcf4232d06809b3a2','b63dee4518ccd9b',NULL,'Teacher','123@rfwerwA'),
(94,'test1','b3410bef9fbd70fcb9c82b5f00970498bdef85a2538c1360485ef50314468d95','4fb2c5091b4c302',NULL,'Fees_Management','123456@Test');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_new`
--
DROP TABLE IF EXISTS `users_new`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_new` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(60) NOT NULL,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role` varchar(20) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`status` varchar(20) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`updated_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_new`
--
LOCK TABLES `users_new` WRITE;
/*!40000 ALTER TABLE `users_new` DISABLE KEYS */;
INSERT INTO `users_new` VALUES
(1,'admin@admin.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','QN2yBnEUMTmrT45NRvlYG4g5Sh9gVUSFzjKeb20HcGFJLEm04H3uyBrNZlDO','0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'rdk@example.com','rdk','$2y$10$2XvoA3Wh2KiFCJXsdIlw.ek83S.km8QNLiCXJjCrbjq0Vzo7hvPJO','Administrator','1234567890','Active','W3EFnZsmRLwuN4t4kZztQ820d7JS8NPJo3vzqQW4rgi1gUTNyIHUcJFdStqA','2022-07-23 07:50:22','2022-07-23 07:50:22');
/*!40000 ALTER TABLE `users_new` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vochers`
--
DROP TABLE IF EXISTS `vochers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vochers` (
`Date` date NOT NULL,
`Cheque_Drop_Date` int(100) DEFAULT NULL,
`V_Id` int(11) NOT NULL AUTO_INCREMENT,
`v_counter` bigint(20) NOT NULL,
`Type` varchar(1000) NOT NULL,
`Cr_Ledger` varchar(1000) NOT NULL,
`Dr_Ledger` varchar(1000) NOT NULL,
`Cr_Ledger_Type` varchar(1000) NOT NULL,
`Dr_Ledger_Type` varchar(1000) NOT NULL,
`Cr_Amount` varchar(1000) NOT NULL,
`Dr_Amount` varchar(1000) NOT NULL,
`Nrtn` varchar(5000) NOT NULL,
PRIMARY KEY (`V_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vochers`
--
LOCK TABLES `vochers` WRITE;
/*!40000 ALTER TABLE `vochers` DISABLE KEYS */;
INSERT INTO `vochers` VALUES
('2024-05-29',NULL,1,1,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-05-29',NULL,2,2,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-05-30',NULL,3,3,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-05-30',NULL,4,4,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-05-30',NULL,5,5,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-05-30',NULL,6,6,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-05-30',NULL,7,7,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-05-31',NULL,8,8,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-05-31',NULL,9,9,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','16500','16500','Fees Collected'),
('2024-05-31',NULL,10,10,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-05-31',NULL,11,11,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-05-31',NULL,12,12,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-01',NULL,13,13,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-01',NULL,14,14,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-01',NULL,15,15,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-01',NULL,16,16,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-03',NULL,17,17,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','17500','17500','Fees Collected'),
('2024-06-03',NULL,18,18,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-06-03',NULL,19,19,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-06-03',NULL,20,20,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-03',NULL,21,21,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-04',NULL,22,22,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-06-04',NULL,23,23,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-04',NULL,24,24,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-04',NULL,25,25,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-04',NULL,26,26,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-05',NULL,27,27,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-05',NULL,28,28,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2024-06-05',NULL,29,29,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-05',NULL,30,30,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-05',NULL,31,31,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2024-06-06',NULL,32,32,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-06',NULL,33,33,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2024-06-06',NULL,34,34,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-06',NULL,35,35,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-06',NULL,36,36,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-07',NULL,37,37,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-07',NULL,38,38,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','12000','12000','Fees Collected'),
('2024-06-07',NULL,39,39,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-07',NULL,40,40,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-07',NULL,41,41,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-08',NULL,42,42,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','4500','4500','Fees Collected'),
('2024-06-08',NULL,43,43,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-08',NULL,44,44,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-10',NULL,45,45,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','24000','24000','Fees Collected'),
('2024-06-10',NULL,46,46,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-10',NULL,47,47,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-10',NULL,48,48,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-10',NULL,49,49,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-11',NULL,50,50,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-11',NULL,51,51,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-06-11',NULL,52,52,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-06-11',NULL,53,53,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-11',NULL,54,54,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-12',NULL,55,55,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-06-12',NULL,56,56,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-12',NULL,57,57,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-13',NULL,58,58,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','17000','17000','Fees Collected'),
('2024-06-13',NULL,59,59,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2024-06-13',NULL,60,60,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-13',NULL,61,61,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-13',NULL,62,62,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-14',NULL,63,63,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-06-14',NULL,64,64,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-18',NULL,65,65,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-06-18',NULL,66,66,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-06-19',NULL,67,67,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2024-06-19',NULL,68,68,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-06-19',NULL,69,69,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-20',NULL,70,70,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-20',NULL,71,71,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-06-24',NULL,72,72,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','17000','17000','Fees Collected'),
('2024-06-24',NULL,73,73,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2024-06-24',NULL,74,74,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2024-06-24',NULL,75,75,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-24',NULL,76,76,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-27',NULL,77,77,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-06-27',NULL,78,78,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-06-28',NULL,79,79,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-28',NULL,80,80,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-07-01',NULL,81,81,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-01',NULL,82,82,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2024-07-01',NULL,83,83,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-01',NULL,84,84,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-01',NULL,85,85,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-02',NULL,86,86,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-02',NULL,87,87,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-07-02',NULL,88,88,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-02',NULL,89,89,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-02',NULL,90,90,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-03',NULL,91,91,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2024-07-03',NULL,92,92,'Recipt','TUTION FEE 1-6','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-07-03',NULL,93,93,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-03',NULL,94,94,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-03',NULL,95,95,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-05',NULL,96,96,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-05',NULL,97,97,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-07-05',NULL,98,98,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-05',NULL,99,99,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-09',NULL,100,100,'Recipt','TUTION FEE','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-09',NULL,101,101,'Recipt','DEVELOPMENT FEE','Cash','Income/Revenue','Current Assets','000','000','Fees Collected'),
('2024-07-09',NULL,102,102,'Recipt','EXAM FEE','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2024-07-09',NULL,103,103,'Recipt','COMPUTER FEE ETC','Cash','Income/Revenue','Current Assets','0','0','Fees Collected');
/*!40000 ALTER TABLE `vochers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-05 0:00:38