|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.45 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/../SNCBSE/ |
| [ 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_Demo1_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=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receipt_Head`
--
LOCK TABLES `Receipt_Head` WRITE;
/*!40000 ALTER TABLE `Receipt_Head` DISABLE KEYS */;
INSERT INTO `Receipt_Head` VALUES
(3,'primary','sch','asdf','asdf'),
(2,'School','Demo School and college name','Navangar - Hubli','580025'),
(10,'school','head madam','jj school','navanager hublli'),
(11,'H','R s sschool','navangar hubbli','58005');
/*!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 AUTO_INCREMENT=3 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 */;
INSERT INTO `account` VALUES
(1,'STATE BANK OF INDIA',0.00,'4111676764187',NULL);
/*!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=15 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,'SBI BANK -187','','41116764187','MGM UNIVERSAL SCHOOL',0,0,0,'',''),
(2,'Canara Bank','','78412','head master',0,0,0,'',''),
(3,'union bank','','526894','swaroopa',0,0,0,'',''),
(4,'union bank','','655241312','vidya',0,0,0,'',''),
(5,'sbi bank','','4453325666','Aarayna',0,0,0,'',''),
(6,'sbi bank','','12145665435','dhawan r ',0,0,0,'',''),
(7,'sbi bank','','52525252','EV 1',0,0,0,'',''),
(8,'union bank','','52525252','SRR',0,0,0,'',''),
(9,'union bank','','52525252','SRR',0,0,0,'',''),
(10,'sbi bank','','52525252','EGG',0,0,0,'',''),
(11,'sbi bank','','4453325666','EGG 1',0,0,0,'',''),
(12,'sbi bank','','526894','EGG2',0,0,0,'',''),
(13,'sbi bank','','4453325666','EGG 2 ',0,0,0,'',''),
(14,'huchheshwara ','','2012','headmaster',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 AUTO_INCREMENT=7 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 */;
INSERT INTO `category` VALUES
(1,'SBI BANK',NULL,1,'#FFFFFF'),
(2,'Cash',NULL,2,'#FFFFFF'),
(3,'test1','fasd',1,'#FFFFFF'),
(4,'test1','asdf',2,'#FFFFFF'),
(5,'Petrol','petrol',2,'#FFFFFF'),
(6,'Hotel','asdfa',2,'#FFFFFF');
/*!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=34 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',12,NULL),
('5',11,NULL),
('4',10,NULL),
('3',9,NULL),
('2',8,NULL),
('1',7,NULL),
('10',32,NULL),
('10th',31,NULL),
('LKG',16,NULL),
('UKG',17,NULL),
('7',30,NULL),
('8',19,NULL),
('9',21,NULL),
('class 1',23,NULL),
('class I',26,NULL),
('class II',27,NULL),
('class III',28,NULL),
('class IV',29,NULL),
('puc',33,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 AUTO_INCREMENT=2 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 */;
INSERT INTO `customers` VALUES
(1,'','','',NULL,'','','','','0000-00-00',NULL,NULL);
/*!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=18 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),
('B',2,NULL),
('Arts',3,NULL),
('COMMERCE',4,NULL),
('c',5,NULL),
('sem I',6,NULL),
('d',7,NULL),
('E',9,NULL),
('f',10,NULL),
('G',13,NULL),
('H',14,NULL),
('z',15,NULL),
('Y',16,NULL),
('Q',17,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 */;
INSERT INTO `goals` VALUES
(0,1,NULL,'TES',1000.00,1000.00,0.00,'2023-06-15');
/*!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=45 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `head`
--
LOCK TABLES `head` WRITE;
/*!40000 ALTER TABLE `head` DISABLE KEYS */;
INSERT INTO `head` VALUES
('TUTION FEES 1 TO 5 ',1,'1','2026-06-01','No','0','1','SCHL'),
('TUTION FEES 6TH',2,'2','2026-06-01','No','0','1','SCHL'),
('LAXMESHWAR',3,'3','2026-06-01','No','0','1','VANF'),
('other fees',4,'6/7','2026-06-01','No','0','2','OTHR'),
('Others',5,'7/8/9','2026-06-01','No','0','1','OTHR'),
('trust fee',17,'35/36','2026-06-01','No','0','1','CDEF'),
('TEST 50005',7,'1/3/6','2026-06-01','No','0','1','SCHL'),
('auto fees',15,'5/7/9','2026-06-01','No','0','1','ABAB'),
('Transport fee',9,'19','2026-06-01','No','0','1','TRAN'),
('stationary',16,'33/34','2026-06-01','No','0','1','ABCD'),
('school fee',11,'20/21','2026-06-01','No','0','1','ABCD'),
('G g shool',18,'37/38/46','2026-06-01','No','0','8','ABAB'),
('test schoo',14,'28/29/30','2026-06-01','No','0','4','TEST'),
('jj school',19,'6/39/40','2026-06-01','No','0','9','ABAB'),
('fees',20,'25/42/44/45','2026-06-01','No','0','1','ABAB'),
('test 11',21,'49/50','2026-06-01','No','0','1','SCHL'),
('New Head',22,'51/52','2026-06-01','No','0','1','TEST'),
('test final decimal value Head',23,'1/53','2026-06-01','No','0','1','WEWD'),
('dec test',24,'54/55/56','2026-06-01','No','0','1','DECD'),
('other fees',25,'58/59/60','2026-06-01','No','0','14','OTHE'),
('Govt fees 9 & 10',26,'61/62/63/64/65/66','2026-06-01','No','0','14','SCHL'),
('Non Govt fees 9 & 10',27,'67/68/69/70/71/72/73/74/75','2026-06-01','No','0','14','SCHL'),
('9 th Old Development Fees',28,'76','2026-06-01','No','0','14','DEVP'),
('Non-Govt FEES 9 & 10',41,'162/163/164/165/166/167/168/169','2026-06-01','No','0','14','SCHL'),
('Non Govt fees 9 & 10',30,'84/85/86/87/88/89/90/91/92','2026-06-01','No','0','14','SCHL'),
(' 9 & 10 Develoment fees',31,'93','2026-06-01','No','0','14','DEVP'),
('9 & 10 develmopment fees',32,'122','2026-06-01','No','0','14','DEVP'),
('LKG CLASS',33,'123/124/125/126/127/128/129','2026-06-01','No','0','14','SCHL'),
('UKG CLASS',34,'123/124/125/126/127/128/129','2026-06-01','No','0','14','SCHL'),
('UKG SCHOOL FEES',35,'137','2026-06-01','No','0','14','SCHL'),
('CHIKKAMAGI',36,'136','2026-06-01','No','0','14','SCHL'),
('BOOK FEES ',37,'135','2026-06-01','No','0','14','SCHL'),
('SCHOOL FEES',38,'137','2026-06-01','No','0','14','SCHL'),
('ID CARD',39,'142','2026-06-01','No','0','14','SCHL'),
('TRACK SUIT(YELLOW)',40,'141','2026-06-01','No','0','14','SCHL'),
('9th New Development Fees ',42,'171','2026-06-01','No','0','14','SCHL'),
('Society',43,'5/6/9','2026-06-01','No','0','1','SCIT'),
('arrears ',44,'47','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=190 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
('TUITION FEES',1,'Income/Revenue'),
('TUITION FEES',2,'Income/Revenue'),
('LAXMESHWARA',3,'Income/Revenue'),
('MANJALAPUR ',4,'Income/Revenue'),
('SBI BANK -111-1111',5,'Current Assets'),
('SBI BANK -187-4187',6,'Current Assets'),
('PETROL',7,'Expenditure'),
('sports fee',8,'Income/Revenue'),
('application Fees',9,'Income/Revenue'),
('computer Fees',10,'Income/Revenue'),
('Canara Bank-8412',11,'Current Assets'),
('Uniform fees',12,'Income/Revenue'),
('test 100',13,'Income/Revenue'),
('Application 1',14,'Income/Revenue'),
('VAN FEES',15,'Income/Revenue'),
('VAN FEES',16,'Income/Revenue'),
('CKIKKMAGI',17,'Income/Revenue'),
('MUGUNUR MARDADI BUDIHAL BASAVNAL',18,'Income/Revenue'),
('BASARIKATTI',19,'Income/Revenue'),
('KADIVAL KALLAPUR',20,'Income/Revenue'),
('KAMATAGI',21,'Income/Revenue'),
('RAMTHAL',22,'Income/Revenue'),
('van fee',23,'Income/Revenue'),
('van fee',24,'Income/Revenue'),
('uniform fee',25,'Income/Revenue'),
('union bank-6894',26,'Current Assets'),
('bus fees',27,'Income/Revenue'),
('union bank-1312',28,'Current Assets'),
('dance fee',29,'Income/Revenue'),
('tuition fee',30,'Income/Revenue'),
('sbi bank-5666',31,'Current Assets'),
('school fee',32,'Income/Revenue'),
('transport fee',33,'Income/Revenue'),
('school fee',34,'Income/Revenue'),
('sbi bank-5435',35,'Current Assets'),
('test1',36,'Income/Revenue'),
('test2',37,'Income/Revenue'),
('test3',38,'Income/Revenue'),
('school fee',39,'Income/Revenue'),
('school fees ',40,'Income/Revenue'),
('sbi bank-5252',41,'Current Assets'),
('pen',42,'Income/Revenue'),
('pencil',43,'Income/Revenue'),
('class fee',44,'Income/Revenue'),
('application fee',45,'Income/Revenue'),
('book fees',46,'Income/Revenue'),
('uniform fee',47,'Income/Revenue'),
('union bank-5252',48,'Current Assets'),
('book fees',49,'Income/Revenue'),
('uniform fee',50,'Income/Revenue'),
('application fee',51,'Income/Revenue'),
('union bank-5252',52,'Current Assets'),
('application fee',53,'Income/Revenue'),
('school fees ',54,'Income/Revenue'),
('uniform fee',55,'Income/Revenue'),
('bus fees',56,'Income/Revenue'),
('sbi bank-5252',57,'Current Assets'),
('sbi bank-5666',58,'Current Assets'),
('sbi bank-6894',59,'Current Assets'),
('sbi bank-5666',60,'Current Assets'),
('Medical Fees pri',61,'Income/Revenue'),
('Arrears',62,'Income/Revenue'),
('saddasd',63,'Income/Revenue'),
('test dec',64,'Income/Revenue'),
('test 2 dec',65,'Income/Revenue'),
('New Sub head',66,'Income/Revenue'),
('Final Sub Head',67,'Income/Revenue'),
('test final decimal value',68,'Income/Revenue'),
('dec 1',69,'Income/Revenue'),
('dec 2',70,'Income/Revenue'),
('dec 3',71,'Income/Revenue'),
('sdasdadasda',72,'Income/Revenue'),
('Belt',73,'Income/Revenue'),
('id card',74,'Income/Revenue'),
('unform',75,'Income/Revenue'),
('huchheshwara -2012',76,'Current Assets'),
('Enrollment fees',77,'Income/Revenue'),
('school imporvement fees',78,'Income/Revenue'),
('special sports fund',79,'Income/Revenue'),
('student welfare fund',80,'Income/Revenue'),
('teachers welfare fund',81,'Income/Revenue'),
('bavuta',82,'Income/Revenue'),
('Admission application fee',83,'Income/Revenue'),
('sports fee',84,'Income/Revenue'),
('VACHANALAY',85,'Income/Revenue'),
('Laboratory fee',86,'Income/Revenue'),
('Hearing fee',87,'Income/Revenue'),
('Painting ',88,'Income/Revenue'),
('Medical',89,'Income/Revenue'),
('Cleanliness',90,'Income/Revenue'),
('Career education fees',91,'Income/Revenue'),
(' DEVELOPMENT FEES ',92,'Income/Revenue'),
('Enrollvement fee',93,'Income/Revenue'),
('School Impovement fees',94,'Income/Revenue'),
('special sports fund',95,'Income/Revenue'),
('student welfare fund',96,'Income/Revenue'),
('teachers welfare fund',97,'Income/Revenue'),
('teachers welfare fund',98,'Income/Revenue'),
('Bavuta',99,'Income/Revenue'),
('Admission application fee',100,'Income/Revenue'),
('sports fee',101,'Income/Revenue'),
('VACHANALAY',102,'Income/Revenue'),
('Laboratory fee',103,'Income/Revenue'),
('Hearing fee',104,'Income/Revenue'),
('Painting ',105,'Income/Revenue'),
('Medical',106,'Income/Revenue'),
('Cleanliness',107,'Income/Revenue'),
('Career education fees',108,'Income/Revenue'),
('DEVELOPMENT FEES',109,'Income/Revenue'),
('Enrollvement fee',110,'Income/Revenue'),
('school impovement fees',111,'Income/Revenue'),
('school impovement fees',112,'Income/Revenue'),
('special sports fund',113,'Income/Revenue'),
('student welfare fund',114,'Income/Revenue'),
('teachers welfarw fund',115,'Income/Revenue'),
('Bavuta',116,'Income/Revenue'),
('DEVELOPMENT FEES',117,'Income/Revenue'),
('School fees',118,'Income/Revenue'),
('Enrollvellment fees ',119,'Income/Revenue'),
('School improvement fees ',120,'Income/Revenue'),
('Special sports fund',121,'Income/Revenue'),
('Student Welfare fund ',122,'Income/Revenue'),
('teachers welfare fund',123,'Income/Revenue'),
('Bavuta',124,'Income/Revenue'),
('Admission application fee',125,'Income/Revenue'),
('Sports fees ',126,'Income/Revenue'),
('VAACHANAALAYA',127,'Income/Revenue'),
('Laboratory',128,'Income/Revenue'),
('Hearing fee',129,'Income/Revenue'),
('Painting ',130,'Income/Revenue'),
('Science Association',131,'Income/Revenue'),
('Medical',132,'Income/Revenue'),
('Cleanliness',133,'Income/Revenue'),
('Examination fees',134,'Income/Revenue'),
('Associaton',135,'Income/Revenue'),
('Others',136,'Income/Revenue'),
('Career Education fees',137,'Income/Revenue'),
('DEVELOPMENT FEES',138,'Income/Revenue'),
('SCHOOL FEES',139,'Income/Revenue'),
('REGULAR UNIFORM',140,'Income/Revenue'),
('TRACK SUITE (YELLOW)',141,'Income/Revenue'),
('BELT',142,'Income/Revenue'),
('ID CARD',143,'Income/Revenue'),
('CHIKKAMAGI',144,'Income/Revenue'),
('BOOK FEES',145,'Income/Revenue'),
('SCHOOL FEES',146,'Income/Revenue'),
('REGULAR UNIFORM',147,'Income/Revenue'),
('TRACK SUITE (YELLOW)',148,'Income/Revenue'),
('BELT',149,'Income/Revenue'),
('ID CARD',150,'Income/Revenue'),
('BOOK FEES ',151,'Income/Revenue'),
('CHIKKAMAGI',152,'Income/Revenue'),
('SCHOOL FEES',153,'Income/Revenue'),
('UKG SCHOOL FEES',154,'Income/Revenue'),
('CHIKKAMAGI',155,'Income/Revenue'),
('REGULAR UNIFORM',156,'Income/Revenue'),
('TRACK SUITE (YELLOW)',157,'Income/Revenue'),
('ID CARD',158,'Income/Revenue'),
('BELT',159,'Income/Revenue'),
('BOOK FEES',160,'Income/Revenue'),
('Enrollment fee',161,'Income/Revenue'),
('school impovement fees',162,'Income/Revenue'),
('special sports fund',163,'Income/Revenue'),
('student welfare fund',164,'Income/Revenue'),
('teachers welfare fund',165,'Income/Revenue'),
('BAAVUTA',166,'Income/Revenue'),
('sports fee',167,'Income/Revenue'),
('VAACHANALAYA FEE',168,'Income/Revenue'),
('LABRORATORY FE',169,'Income/Revenue'),
('Enrollment fee',170,'Income/Revenue'),
('Enrollment fee',171,'Income/Revenue'),
('Enrollment fee',172,'Income/Revenue'),
('school impoveLment fees',173,'Income/Revenue'),
('special sports fund',174,'Income/Revenue'),
('student welfare fund',175,'Income/Revenue'),
('teachers welfare fund',176,'Income/Revenue'),
('BAAVUTA',177,'Income/Revenue'),
('sports fee',178,'Income/Revenue'),
('VAACHANALAYA FEE',179,'Income/Revenue'),
('Laboratory fee',180,'Income/Revenue'),
('Hearing fee',181,'Income/Revenue'),
('Painting ',182,'Income/Revenue'),
('MEDICAL',183,'Income/Revenue'),
('CLEANLINESS',184,'Income/Revenue'),
('CAREER EDUCATION FEE',185,'Income/Revenue'),
('DEVELOPMENT FEES',186,'Income/Revenue'),
('DEVELOPMENT FEES',187,'Income/Revenue'),
('DEVELOPMENT FEES',188,'Income/Revenue'),
('Keb bill 800',189,'Expenditure');
/*!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` decimal(10,2) DEFAULT NULL,
`Online_Charge` decimal(10,2) DEFAULT NULL,
`Total_Amount` decimal(10,2) DEFAULT NULL,
`Grand_Total` decimal(10,2) 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=168 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,227,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1','/7000','2023-05-23','Cheque','',0.00,0.00,7000.00,7000.00,1,'adminFees',NULL),
(2,229,'SCHL-2',2,'SCHL','SCHL-2',2,'1','/1','/7500','2023-05-24','Cash','',0.00,0.00,7500.00,7500.00,1,'adminFees',NULL),
(3,230,'SCHL-3',3,'SCHL','SCHL-3',3,'1','/1','/6000','2023-05-25','Cash','4567',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(4,230,'SCHL-4',4,'SCHL','SCHL-4',4,'1','/1','/3000','2023-05-25','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(5,232,'SCHL-5',5,'SCHL','SCHL-5',5,'1','/1','/5000','2023-05-30','Cash','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(6,232,'OTHR-1',1,'OTHR','OTHR-1',1,'4','/6/7','/100/450','2023-05-30','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(7,233,'SCHL-6',6,'SCHL','SCHL-6',6,'1','/1','/4000','2023-06-14','Cash','1521',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(8,233,'OTHR-2',2,'OTHR','OTHR-2',2,'4','/6/7','/100/200','2023-06-14','Cash','1521',0.00,0.00,300.00,300.00,1,'adminFees',NULL),
(9,233,'SCHL-7',7,'SCHL','SCHL-7',7,'1','/1','/5000','2023-06-14','Cash','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(10,234,'SCHL-8',8,'SCHL','SCHL-8',8,'2','/2','/5000','2023-06-15','Challan','450',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(11,234,'OTHR-3',3,'OTHR','OTHR-3',3,'5','/7/8/9','/400/1500/600','2023-06-15','Challan','450',0.00,0.00,2500.00,2500.00,1,'adminFees',NULL),
(12,244,'SCHL-9',9,'SCHL','SCHL-9',9,'1','/1','/1000','2023-06-15','Cash','',0.00,0.00,1000.00,1000.00,1,'adminFees',NULL),
(13,244,'OTHR-4',4,'OTHR','OTHR-4',4,'4','/6/7','/100/450','2023-06-15','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(14,246,'SCHL-10',10,'SCHL','SCHL-10',10,'1','/1','/5000','2023-06-16','Cash','501',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(15,246,'SCHL-11',11,'SCHL','SCHL-11',11,'7','/3/6','/1000/100','2023-06-16','Cash','501',0.00,0.00,1100.00,1100.00,1,'adminFees',NULL),
(17,247,'TRAN-1',1,'TRAN','TRAN-1',1,'9','/19','/8000','2023-07-01','Cash','',0.00,0.00,8000.00,8000.00,1,'adminFees',NULL),
(18,248,'SCHL-12',12,'SCHL','SCHL-12',12,'1','/1','/15000','2023-07-24','Cash','',0.00,0.00,15000.00,15000.00,1,'adminFees',NULL),
(19,249,'SCHL-13',13,'SCHL','SCHL-13',13,'1','/1','/15000','2023-07-24','Cash','',0.00,0.00,15000.00,15000.00,1,'adminFees',NULL),
(20,250,'SCHL-14',14,'SCHL','SCHL-14',14,'1','/1','/15000','2023-07-31','Challan','1234',0.00,0.00,15000.00,15000.00,0,'adminFees',NULL),
(21,251,'OTHR-5',5,'OTHR','OTHR-5',5,'4','/6/7','/100/450','2023-08-04','Challan','weqwe',0.00,0.00,550.00,550.00,0,'adminFees',NULL),
(22,253,'SCHL-15',15,'SCHL','SCHL-15',15,'1','/1','/3000','2023-09-01','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(23,253,'OTHR-6',6,'OTHR','OTHR-6',6,'4','/6/7','/100/200','2023-09-01','Cash','',0.00,0.00,300.00,300.00,1,'adminFees',NULL),
(24,254,'SCHL-16',16,'SCHL','SCHL-16',16,'1','/1','/6500','2023-09-08','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(25,254,'VANF-1',1,'VANF','VANF-1',1,'3','/3','/6000','2023-09-08','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(26,255,'SCHL-17',17,'SCHL','SCHL-17',17,'1','/1','/3000','2023-09-08','Cash','7452',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(27,255,'VANF-2',2,'VANF','VANF-2',2,'3','/3','/2000','2023-09-08','Cash','7452',0.00,0.00,2000.00,2000.00,1,'adminFees',NULL),
(28,229,'SCHL-18',18,'SCHL','SCHL-18',18,'1','/1','/7500','2023-09-25','Cash','342343',0.00,0.00,7500.00,7500.00,1,'adminFees',NULL),
(29,229,'VANF-3',3,'VANF','VANF-3',3,'3','/3','/3000','2023-09-25','Cash','342343',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(30,256,'SCHL-19',19,'SCHL','SCHL-19',19,'1','/1','/6500','2023-10-17','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(31,256,'VANF-4',4,'VANF','VANF-4',4,'3','/3','/6000','2023-10-17','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(32,257,'SCHL-20',20,'SCHL','SCHL-20',20,'1','/1','/6500','2023-10-17','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(33,258,'VANF-5',5,'VANF','VANF-5',5,'3','/3','/6000','2023-10-17','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(34,258,'OTHR-7',7,'OTHR','OTHR-7',7,'4','/6/7','/100/450','2023-10-17','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(35,259,'VANF-6',6,'VANF','VANF-6',6,'3','/3','/6000','2023-10-17','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(36,259,'OTHR-8',8,'OTHR','OTHR-8',8,'4','/6/7','/100/450','2023-10-17','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(37,260,'SCHL-21',21,'SCHL','SCHL-21',21,'1','/1','/3000','2023-11-05','DD','DD123',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(38,260,'TRAN-2',2,'TRAN','TRAN-2',2,'9','/19','/5000','2023-11-05','Cash','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(39,261,'SCHL-22',22,'SCHL','SCHL-22',22,'1','/1','/5000','2023-11-05','Cash','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(40,261,'TRAN-3',3,'TRAN','TRAN-3',3,'9','/19','/5000','2023-11-05','Cash','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(41,262,'SCHL-23',23,'SCHL','SCHL-23',23,'1','/1','/3000','2023-11-08','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(42,263,'ABCD-1',1,'ABCD','ABCD-1',1,'11','/20/21','/3000/1000','2023-12-07','Cash','',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(43,265,'TEST-1',1,'TEST','TEST-1',1,'14','/28/29/30','/100/50/50','2023-12-09','Cash','123',0.00,0.00,200.00,200.00,1,'adminFees',NULL),
(44,266,'ABCD-2',2,'ABCD','ABCD-2',2,'11','/20/21','/5000/2000','2023-12-14','Cash','',0.00,0.00,7000.00,7000.00,1,'adminFees',NULL),
(45,267,'ABAB-1',1,'ABAB','ABAB-1',1,'15','/5/7/9','/150/450/600','2023-12-14','Cash','',0.00,0.00,1200.00,1200.00,1,'adminFees',NULL),
(46,268,'TEST-2',2,'TEST','TEST-2',2,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(47,270,'OTHR-9',9,'OTHR','OTHR-9',9,'4','/6/7','/100/450','2023-12-14','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(48,271,'VANF-7',7,'VANF','VANF-7',7,'3','/3','/6000','2023-12-14','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(49,272,'TEST-3',3,'TEST','TEST-3',3,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(50,273,'ABCD-3',3,'ABCD','ABCD-3',3,'11','/20/21','/5000/2000','2023-12-14','Cash','',0.00,0.00,7000.00,7000.00,1,'adminFees',NULL),
(51,274,'ABCD-4',4,'ABCD','ABCD-4',4,'11','/20/21','/5000/2000','2023-12-14','Cash','',0.00,0.00,7000.00,7000.00,1,'adminFees',NULL),
(52,275,'OTHR-10',10,'OTHR','OTHR-10',10,'5','/7/8/9','/450/2600/600','2023-12-14','Cash','',0.00,0.00,3650.00,3650.00,1,'adminFees',NULL),
(53,276,'TEST-4',4,'TEST','TEST-4',4,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(54,276,'TEST-5',5,'TEST','TEST-5',5,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(55,276,'TEST-6',6,'TEST','TEST-6',6,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(56,276,'TEST-7',7,'TEST','TEST-7',7,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(57,276,'TEST-8',8,'TEST','TEST-8',8,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(58,276,'TEST-9',9,'TEST','TEST-9',9,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(59,276,'TEST-10',10,'TEST','TEST-10',10,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(60,276,'TEST-11',11,'TEST','TEST-11',11,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(61,276,'TEST-12',12,'TEST','TEST-12',12,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(62,276,'TEST-13',13,'TEST','TEST-13',13,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(63,276,'TEST-14',14,'TEST','TEST-14',14,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(64,276,'TEST-15',15,'TEST','TEST-15',15,'14','/28/29/30','/100/200/300','2023-12-14','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(65,278,'ABCD-5',5,'ABCD','ABCD-5',5,'16','/33/34','/50/50','2023-12-14','Cash','',0.00,0.00,100.00,100.00,1,'adminFees',NULL),
(66,278,'CDEF-1',1,'CDEF','CDEF-1',1,'17','/35/36','/5000/200','2023-12-14','Cash','',0.00,0.00,5200.00,5200.00,1,'adminFees',NULL),
(67,278,'ABCD-6',6,'ABCD','ABCD-6',6,'16','/33','/50','2023-12-14','Cash','',0.00,0.00,50.00,50.00,1,'adminFees',NULL),
(68,267,'ABCD-7',7,'ABCD','ABCD-7',7,'11','/20/21','/5000/2000','2023-12-14','Cash','',0.00,0.00,7000.00,7000.00,1,'adminFees',NULL),
(69,280,'ABAB-2',2,'ABAB','ABAB-2',2,'18','/37/38','/2000/2000','2023-12-15','Cash','',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(70,281,'ABAB-3',3,'ABAB','ABAB-3',3,'18','/37/38','/2000/2000','2023-12-15','Cash','',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(71,283,'ABAB-4',4,'ABAB','ABAB-4',4,'19','/6/39/40','/100/5000/5000','2023-12-15','Cash','',0.00,0.00,10100.00,10100.00,1,'adminFees',NULL),
(72,292,'SCHL-24',24,'SCHL','SCHL-24',24,'1','/1','/3000','2023-12-24','Cash','145',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(73,292,'TRAN-4',4,'TRAN','TRAN-4',4,'9','/19','/4000','2023-12-24','Cash','145',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(74,293,'SCHL-25',25,'SCHL','SCHL-25',25,'1','/1','/6000','2023-12-30','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(75,294,'SCHL-26',26,'SCHL','SCHL-26',26,'1','/1','/3000','2023-12-30','Cash','34535',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(76,294,'VANF-8',8,'VANF','VANF-8',8,'3','/3','/3000','2023-12-30','Cash','34535',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(77,295,'SCHL-27',27,'SCHL','SCHL-27',27,'1','/1','/4000','2024-01-01','Cash','1',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(78,297,'SCHL-28',28,'SCHL','SCHL-28',28,'1','/1','/6500','2024-01-02','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(79,301,'SCHL-29',29,'SCHL','SCHL-29',29,'1','/1','/6500','2024-01-07','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(80,302,'VANF-9',9,'VANF','VANF-9',9,'3','/3','/650000','2024-01-08','Cash','',0.00,0.00,650000.00,650000.00,1,'adminFees',NULL),
(81,303,'OTHR-11',11,'OTHR','OTHR-11',11,'5','/7/8/9','/650000/2600/600','2024-01-08','Cash','34234234',0.00,0.00,653200.00,653200.00,1,'adminFees',NULL),
(82,305,'SCHL-30',30,'SCHL','SCHL-30',30,'2','/2','/15999','2024-02-07','Cash','',0.00,0.00,15999.00,15999.00,1,'adminFees',NULL),
(83,305,'ABAB-5',5,'ABAB','ABAB-5',5,'15','/5/7/9','/250/450/600','2024-02-07','Cash','',0.00,0.00,1300.00,1300.00,1,'adminFees',NULL),
(84,305,'TRAN-5',5,'TRAN','TRAN-5',5,'9','/19','/11000','2024-02-07','Cash','',0.00,0.00,11000.00,11000.00,1,'adminFees',NULL),
(85,306,'SCHL-31',31,'SCHL','SCHL-31',31,'1','/1','/4000','2024-03-07','Cash','12',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(86,307,'SCHL-32',32,'SCHL','SCHL-32',32,'2','/2','/16000','2024-03-17','Cash','',0.00,0.00,16000.00,16000.00,1,'adminFees',NULL),
(87,307,'SCHL-33',33,'SCHL','SCHL-33',33,'7','/1/3/6','/6500/6000/100','2024-03-17','Cash','',0.00,0.00,12600.00,12600.00,1,'adminFees',NULL),
(88,308,'SCHL-34',34,'SCHL','SCHL-34',34,'1','/1','/3000','2024-04-01','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(89,309,'SCHL-35',35,'SCHL','SCHL-35',35,'1','/1','/3000','2024-04-03','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(90,310,'SCHL-36',36,'SCHL','SCHL-36',36,'1','/1','/300','2024-04-03','Cash','',0.00,0.00,300.00,300.00,1,'adminFees',NULL),
(91,310,'SCHL-37',37,'SCHL','SCHL-37',37,'1','/1','/1000','2024-04-03','Cash','',0.00,0.00,1000.00,1000.00,1,'adminFees',NULL),
(92,310,'SCHL-38',38,'SCHL','SCHL-38',38,'1','/1','/700','2024-04-03','Cash','',0.00,0.00,700.00,700.00,1,'adminFees',NULL),
(93,311,'SCHL-39',39,'SCHL','SCHL-39',39,'2','/2','/16000','2024-04-03','Cash','',0.00,0.00,16000.00,16000.00,1,'adminFees',NULL),
(94,312,'SCHL-40',40,'SCHL','SCHL-40',40,'1','/1','/4000','2024-04-07','Cash','',0.00,0.00,4000.00,4000.00,1,'adminFees',NULL),
(95,312,'SCHL-41',41,'SCHL','SCHL-41',41,'1','/1','/2500','2024-04-07','Cash','',0.00,0.00,2500.00,2500.00,1,'adminFees',NULL),
(96,314,'SCHL-42',42,'SCHL','SCHL-42',42,'1','/1','/3500','2024-04-16','Cash','',0.00,0.00,3500.00,3500.00,1,'adminFees',NULL),
(97,315,'SCHL-43',43,'SCHL','SCHL-43',43,'1','/1','/3000','2024-04-16','Cash','3456',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(98,315,'TRAN-6',6,'TRAN','TRAN-6',6,'9','/19','/1500','2024-04-16','Cash','3456',0.00,0.00,1500.00,1500.00,1,'adminFees',NULL),
(99,316,'SCHL-44',44,'SCHL','SCHL-44',44,'1','/1','/6500','2024-05-05','Cash','3456',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(100,317,'SCHL-45',45,'SCHL','SCHL-45',45,'2','/2','/16000','2024-05-06','Cash','342423',0.00,0.00,16000.00,16000.00,1,'adminFees',NULL),
(101,318,'SCHL-46',46,'SCHL','SCHL-46',46,'1','/1','/6500','2024-05-22','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(102,318,'VANF-10',10,'VANF','VANF-10',10,'3','/3','/6000','2024-05-22','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(103,321,'SCHL-47',47,'SCHL','SCHL-47',47,'1','/1','/3000','2024-07-03','Cash','01',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(104,320,'SCHL-48',48,'SCHL','SCHL-48',48,'1','/1','/3000','2024-07-03','Cash','235',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(105,322,'SCHL-49',49,'SCHL','SCHL-49',49,'2','/2','/3500','2024-07-03','Cash','',0.00,0.00,3500.00,3500.00,1,'adminFees',NULL),
(106,323,'SCHL-50',50,'SCHL','SCHL-50',50,'2','/2','/4500','2024-07-03','Cash','',0.00,0.00,4500.00,4500.00,1,'adminFees',NULL),
(107,324,'ABCD-8',8,'ABCD','ABCD-8',8,'11','/20/21','/2000/1000','2024-09-21','Cash','1234',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(108,324,'ABCD-9',9,'ABCD','ABCD-9',9,'11','/20/21','/2000/1000','2024-09-21','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(109,325,'SCHL-51',51,'SCHL','SCHL-51',51,'1','/1','/3000','2024-09-21','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(110,326,'SCHL-52',52,'SCHL','SCHL-52',52,'1','/1','/6500','2024-09-30','Cash','',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(111,326,'OTHR-12',12,'OTHR','OTHR-12',12,'4','/6/7','/100/450','2024-09-30','Cash','',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(112,327,'SCHL-53',53,'SCHL','SCHL-53',53,'21','/49/50','/103.00/50.00','2024-10-26','Cash','',0.00,0.00,153.00,153.00,1,'adminFees',NULL),
(113,330,'TEST-16',16,'TEST','TEST-16',16,'22','/51/52','/200.50/20.20','2024-10-26','Cash','3242',0.00,0.00,221.00,221.00,1,'adminFees',NULL),
(114,333,'WEWD-1',1,'WEWD','WEWD-1',1,'23','/1/53','/6500.00/22.10','2024-10-31','Cash','',0.00,0.00,6522.00,6522.00,1,'adminFees',NULL),
(115,334,'VANF-11',11,'VANF','VANF-11',11,'3','/3','/6000.00','2024-10-31','Cash','',0.00,0.00,6000.00,6000.00,1,'adminFees',NULL),
(116,334,'WEWD-2',2,'WEWD','WEWD-2',2,'23','/1/53','/6500.00/22.15','2024-10-31','Cash','',0.00,0.00,6522.15,6522.15,1,'adminFees',NULL),
(117,334,'WEWD-3',3,'WEWD','WEWD-3',3,'23','/53','/0.10','2024-10-31','Cash','',0.00,0.00,0.10,0.10,1,'adminFees',NULL),
(118,335,'DECD-1',1,'DECD','DECD-1',1,'24','/54/55/56','/100.10/200.20/250.30','2024-10-31','Cash','12312',0.00,0.00,550.60,550.60,1,'adminFees',NULL),
(119,336,'DECD-2',2,'DECD','DECD-2',2,'24','/54/55/56','/100.10/200.50/300.20','2024-10-31','Cash','',0.00,0.00,600.80,600.80,1,'adminFees',NULL),
(120,337,'SCHL-54',54,'SCHL','SCHL-54',54,'1','/1','/6500.00','2025-01-22','Cash','12',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(121,338,'SCHL-55',55,'SCHL','SCHL-55',55,'1','/1','/600','2025-01-22','Cash','',0.00,0.00,600.00,600.00,1,'adminFees',NULL),
(122,339,'SCHL-56',56,'SCHL','SCHL-56',56,'1','/1','/3000','2025-01-30','Cash','',0.00,0.00,3000.00,3000.00,1,'adminFees',NULL),
(123,340,'OTHR-13',13,'OTHR','OTHR-13',13,'4','/6/7','/100.00/100','2025-01-30','Cash','',0.00,0.00,200.00,200.00,1,'adminFees',NULL),
(124,341,'VANF-12',12,'VANF','VANF-12',12,'3','/3','/6000.00','2025-02-22','Challan','',0.00,0.00,6000.00,6000.00,0,'adminFees',NULL),
(125,341,'TRAN-7',7,'TRAN','TRAN-7',7,'9','/19','/1000.00','2025-02-22','Challan','',0.00,0.00,1000.00,1000.00,0,'adminFees',NULL),
(126,341,'ABCD-10',10,'ABCD','ABCD-10',10,'16','/33/34','/100.00/50.00','2025-02-22','Challan','',0.00,0.00,150.00,150.00,0,'adminFees',NULL),
(131,346,'SCHL-57',57,'SCHL','SCHL-57',57,'26','/61/62/63/64/65/66','/10.00/20.00/20.00/15.00/15.00/10.00','2025-03-07','Cash','',0.00,0.00,90.00,90.00,1,'adminFees',NULL),
(132,346,'SCHL-58',58,'SCHL','SCHL-58',58,'27','/67/68/69/70/71/72/73/74/75','/0.00/25.00/20.00/20.00/10.00/10.00/5.00/15.00/10.00','2025-03-07','Cash','',0.00,0.00,115.00,115.00,1,'adminFees',NULL),
(133,346,'DEVP-3',3,'DEVP','DEVP-3',3,'31','/93','/1795.00','2025-03-07','Cash','',0.00,0.00,1795.00,1795.00,1,'adminFees',NULL),
(130,343,'DEVP-2',2,'DEVP','DEVP-2',2,'31','/93','/1795','2025-03-01','Cash','',0.00,0.00,1795.00,1795.00,1,'adminFees',NULL),
(138,352,'DEVP-4',4,'DEVP','DEVP-4',4,'28','/76','/1795','2025-03-10','Cash','',0.00,0.00,1795.00,1795.00,1,'adminFees',NULL),
(139,353,'SCHL-59',59,'SCHL','SCHL-59',59,'1','/1','/2000','2025-03-17','Challan','1092',0.00,0.00,2000.00,2000.00,1,'adminFees',NULL),
(140,353,'OTHR-14',14,'OTHR','OTHR-14',14,'5','/7/8/9','/450.00/1000/400.00','2025-03-17','Challan','1092',0.00,0.00,1850.00,1850.00,0,'adminFees',NULL),
(141,353,'SCHL-60',60,'SCHL','SCHL-60',60,'1','/1','/2000','2025-03-17','Challan','1093',0.00,0.00,2000.00,2000.00,0,'adminFees',NULL),
(142,353,'OTHR-15',15,'OTHR','OTHR-15',15,'5','/7/8/9','/100/2600.00/300','2025-03-17','Challan','1093',0.00,0.00,3000.00,3000.00,0,'adminFees',NULL),
(143,353,'SCIT-1',1,'SCIT','SCIT-1',1,'43','/5/6/9','/250.00/100.00/600.00','2025-03-17','Challan','',0.00,0.00,950.00,950.00,0,'adminFees',NULL),
(144,354,'SCHL-61',61,'SCHL','SCHL-61',61,'1','/1/1','/1000/1000','2025-03-17','Challan','1002',0.00,0.00,2000.00,2000.00,0,'adminFees',NULL),
(145,354,'SCHL-62',62,'SCHL','SCHL-62',62,'7','/3/6','/200/100.00','2025-03-17','Challan','1002',0.00,0.00,300.00,300.00,0,'adminFees',NULL),
(146,354,'SCHL-63',63,'SCHL','SCHL-63',63,'1','/1/1','/2000.00/2000.00','2025-03-17','Challan','',0.00,0.00,4000.00,4000.00,0,'adminFees',NULL),
(147,354,'SCHL-64',64,'SCHL','SCHL-64',64,'7','/3/6','/6000.00/100.00','2025-03-17','Challan','',0.00,0.00,6100.00,6100.00,0,'adminFees',NULL),
(148,354,'SCHL-65',65,'SCHL','SCHL-65',65,'44','/47','/5000','2025-03-17','Challan','',0.00,0.00,5000.00,5000.00,0,'adminFees',NULL),
(149,355,'SCHL-66',66,'SCHL','SCHL-66',66,'1','/1','/6500.00','2025-03-26','Cash','3242122',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(150,355,'OTHR-16',16,'OTHR','OTHR-16',16,'4','/6/7','/100.00/450.00','2025-03-26','Cash','3242122',0.00,0.00,550.00,550.00,1,'adminFees',NULL),
(151,355,'TRAN-8',8,'TRAN','TRAN-8',8,'9','/19','/10000.00','2025-03-26','Cash','3242122',0.00,0.00,10000.00,10000.00,1,'adminFees',NULL),
(152,355,'SCHL-67',67,'SCHL','SCHL-67',67,'2','/2','/10000.00','2025-03-26','Challan','Challan123',0.00,0.00,10000.00,10000.00,0,'adminFees',NULL),
(153,355,'TRAN-9',9,'TRAN','TRAN-9',9,'9','/19','/5000.00','2025-03-26','Challan','Challan123',0.00,0.00,5000.00,5000.00,0,'adminFees',NULL),
(154,356,'SCHL-68',68,'SCHL','SCHL-68',68,'1','/1','/1499.98','2025-03-26','Challan','Challan123',0.00,0.00,1499.98,1499.98,0,'adminFees',NULL),
(155,356,'VANF-13',13,'VANF','VANF-13',13,'3','/3','/6000.00','2025-03-26','Challan','Challan123',0.00,0.00,6000.00,6000.00,0,'adminFees',NULL),
(156,356,'OTHR-17',17,'OTHR','OTHR-17',17,'4','/6/7','/100.00/450.00','2025-03-26','Challan','Challan123',0.00,0.00,550.00,550.00,0,'adminFees',NULL),
(157,357,'SCHL-69',69,'SCHL','SCHL-69',69,'1','/1','/6500.00','2025-03-27','Challan','27-03-2025/1212',0.00,0.00,6500.00,6500.00,0,'adminFees',NULL),
(158,357,'SCHL-70',70,'SCHL','SCHL-70',70,'2','/2','/1000.00','2025-03-27','Challan','27-03-2025/1212',0.00,0.00,1000.00,1000.00,0,'adminFees',NULL),
(159,357,'VANF-14',14,'VANF','VANF-14',14,'3','/3','/6000.00','2025-03-27','Challan','27-03-2025/1212',0.00,0.00,6000.00,6000.00,0,'adminFees',NULL),
(160,1,'SCHL-71',71,'SCHL','SCHL-71',71,'1','/1','/5000','2025-03-28','Online','',0.00,0.00,5000.00,5000.00,1,'adminFees',NULL),
(161,358,'SCHL-72',72,'SCHL','SCHL-72',72,'1','/1','/6500.00','2025-03-28','Challan','',0.00,0.00,6500.00,6500.00,0,'adminFees',NULL),
(162,358,'VANF-15',15,'VANF','VANF-15',15,'3','/3','/6000.00','2025-03-28','Challan','',0.00,0.00,6000.00,6000.00,0,'adminFees',NULL),
(163,359,'SCHL-73',73,'SCHL','SCHL-73',73,'1','/1','/6500.00','2025-04-02','Challan','12345',0.00,0.00,6500.00,6500.00,0,'adminFees',NULL),
(164,359,'TRAN-10',10,'TRAN','TRAN-10',10,'9','/19','/15000.00','2025-04-02','Challan','12345',0.00,0.00,15000.00,15000.00,0,'adminFees',NULL),
(165,360,'SCHL-74',74,'SCHL','SCHL-74',74,'1','/1','/6500.00','2025-04-12','Cash','12',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL),
(166,361,'SCHL-75',75,'SCHL','SCHL-75',75,'1','/1','/6500.00','2025-05-05','Challan','',0.00,0.00,6500.00,6500.00,0,'adminFees',NULL),
(167,362,'SCHL-76',76,'SCHL','SCHL-76',76,'1','/1','/6500.00','2025-05-06','Cash','123',0.00,0.00,6500.00,6500.00,1,'adminFees',NULL);
/*!40000 ALTER TABLE `paid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees_delete`
--
DROP TABLE IF EXISTS `paid_fees_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees_delete` (
`Fees_id` bigint(20) NOT NULL DEFAULT 0,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_No` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Subhead_Ids` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Sub_Amounts` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`DateNumber` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Fine_Amount` decimal(10,2) DEFAULT NULL,
`Online_Charge` decimal(10,2) DEFAULT NULL,
`Total_Amount` decimal(10,2) DEFAULT NULL,
`Grand_Total` decimal(10,2) 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
(16,247,'TRAN-12',12,'TRAN','TRAN-12',12,'9','/19','/5000','2023-07-01','Cash','1',0.00,0.00,5000.00,5000.00,1,'adminFees','2023-07-01 07:21 47'),
(129,342,'DEVP-1',1,'DEVP','DEVP-1',1,'28','/76','/1795.00','2025-03-01','Cash','',0.00,0.00,1795.00,1795.00,1,'adminFees','2025-03-05 05:44 39'),
(128,342,'SCHL-58',58,'SCHL','SCHL-58',58,'27','/67/68/69/70/71/72/73/74/75','/0.00/0.00/0.00/0.00/.00/.00/.00/.00/.00','2025-03-01','Cash','',0.00,0.00,0.00,0.00,1,'adminFees','2025-03-05 05:44 55'),
(127,342,'SCHL-57',57,'SCHL','SCHL-57',57,'26','/61/62/63/64/65/66','/0.00/0.00/20.00/15.00/15.00/10.00','2025-03-01','Cash','',0.00,0.00,60.00,60.00,1,'adminFees','2025-03-05 05:45 02'),
(137,347,'DEVP-5',5,'DEVP','DEVP-5',5,'31','/93','/800','2025-03-07','Cash','',0.00,0.00,800.00,800.00,1,'adminFees','2025-03-07 07:06 04'),
(136,347,'DEVP-4',4,'DEVP','DEVP-4',4,'31','/93','/500','2025-03-07','Cash','',0.00,0.00,500.00,500.00,1,'adminFees','2025-03-07 07:06 08'),
(135,347,'SCHL-60',60,'SCHL','SCHL-60',60,'30','/84/85/86/87/88/89/90/91/92','/0.00/25.00/20.00/20.00/10.00/10.00/5.00/15.00/10.00','2025-03-07','Cash','',0.00,0.00,115.00,115.00,1,'adminFees','2025-03-07 07:06 12'),
(134,347,'SCHL-59',59,'SCHL','SCHL-59',59,'26','/61/62/63/64/65/66','/10.00/20.00/20.00/15.00/15.00/10.00','2025-03-07','Cash','',0.00,0.00,90.00,90.00,1,'adminFees','2025-03-07 07:06 16');
/*!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 AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES
(2,'Transactions'),
(3,'Income'),
(4,'Expense'),
(5,'Accounts'),
(6,'Track Budget'),
(7,'Set Goals'),
(8,'Calendar'),
(9,'Income Category'),
(10,'Expense Category'),
(11,'Income Reports'),
(12,'Expense Category'),
(13,'Income vs Expense Reports'),
(14,'Income Monthly Report'),
(15,'Expense Monthly Report'),
(16,'Account Transaction Reports'),
(17,'User Role'),
(18,'Application Setting'),
(19,'Upcoming Income'),
(20,'Upcoming Expense');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
INSERT INTO `roleaccess` VALUES
(37,2,1),
(38,3,1),
(39,4,1),
(40,5,1),
(41,6,1),
(42,7,1),
(43,8,1),
(44,9,1),
(45,10,1),
(46,11,1),
(47,12,1),
(48,13,1),
(49,14,1),
(50,15,1),
(51,16,1),
(52,17,1),
(53,18,1),
(54,19,1),
(55,20,1);
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(1,'Evi money','Batam','Golden Land Btams','E vision infotech','0898999893434','mplogo.png','Rs','en','d/m/Y');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
`Photos` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=363 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
('AADYA IRANNA NEKAR',1,'None','1','A','233 061 353',0,'',NULL,0,NULL,NULL),
('AARVI VRUSHAB BARIGALI',2,'None','1','A','233 063 063',0,'',NULL,0,NULL,NULL),
('ADITHYA RAJASHEKHAR RONAD',3,'None','1','A','233 056 436',0,'',NULL,0,NULL,NULL),
('ARYANKUMAR IRANNA BADIGER',4,'None','1','A','233 059 519',0,'',NULL,0,NULL,NULL),
('AYUSH C HOSALLIMATH',5,'None','1','A','233 061 928',0,'',NULL,0,NULL,NULL),
('DIVYA NINGAPPA KATTIMANI',6,'None','1','A','233 037 368',0,'',NULL,0,NULL,NULL),
('DIYANSHU SHIVANAND KAMARADDI',7,'None','1','A','233 057 729',0,'',NULL,0,NULL,NULL),
('GAGAN K B',8,'None','1','A','233 063 314',0,'',NULL,0,NULL,NULL),
('HARIVATSA RAGHAVENDRA SADAVARTI',9,'None','1','A','233 054 239',0,'',NULL,0,NULL,NULL),
('JEEVAN CHANNAPPA MULGUND',10,'None','1','A','233 060 352',0,'',NULL,0,NULL,NULL),
('KRUTHIKA SRIKANTH KAMMAR',11,'None','1','A','233 041 557',0,'',NULL,0,NULL,NULL),
('MAHAMADWAZEED GONAL',12,'None','1','A','233 063 192',0,'',NULL,0,NULL,NULL),
('MANVITHGOWDA V PATIL',13,'None','1','A','233 039 413',0,'',NULL,0,NULL,NULL),
('MD SHOEB HAKKI',14,'None','1','A','233 062 049',0,'',NULL,0,NULL,NULL),
('MOHAMADSUFHIYAN HAJARESAB SUNDAKE',15,'None','1','A','233 062 768',0,'',NULL,0,NULL,NULL),
('MOHAMMEDSHAHNAWAZ M MAKANDAR',16,'None','1','A','233 061 053',0,'',NULL,0,NULL,NULL),
('NAINISHA BASAVARAJ KAMARADDI',17,'None','1','A','233 058 091',0,'',NULL,0,NULL,NULL),
('NAMITGOUDA GURUNATHAGOUDA PATIL',18,'None','1','A','234 689 331',0,'',NULL,0,NULL,NULL),
('NAVISHGOUDA GURUNATHAGOUDA PATIL',19,'None','1','A','234 689 836',0,'',NULL,0,NULL,NULL),
('NITIN GOURISH HUMBI',20,'None','1','A','233 062 535',0,'',NULL,0,NULL,NULL),
('PAVAN MANJUNATH ADARAKATTI',21,'None','1','A','233 062 773',0,'',NULL,0,NULL,NULL),
('PRATEEKSHA YALLAPPA HADAPAD',22,'None','1','A','233 057 303',0,'',NULL,0,NULL,NULL),
('PRATIKSHA UMESHGOUDA HIREGOUDRA',23,'None','1','A','233 053 756',0,'',NULL,0,NULL,NULL),
('PREETAM BHANDIWAD',24,'None','1','A','233 042 635',0,'',NULL,0,NULL,NULL),
('PREETAM SURESH KURUBAR',25,'None','1','A','233 058 735',0,'',NULL,0,NULL,NULL),
('PRITHVIGOUDA R PATIL',26,'None','1','A','233 044 076',0,'',NULL,0,NULL,NULL),
('RIYA MAHAVEER SAVADI',27,'None','1','A','233 041 134',0,'',NULL,0,NULL,NULL),
('SAGAR CHANNAPPA KAMATAD',28,'None','1','A','233 060 936',0,'',NULL,0,NULL,NULL),
('SAMARTH SUNIL PUJAR DESAI',29,'None','1','A','233 055 018',0,'',NULL,0,NULL,NULL),
('SANGEETA SURESH HIRETANAD',30,'None','1','A','233 061 379',0,'',NULL,0,NULL,NULL),
('SANVI BASAVARAJ PADASALI',31,'None','1','A','233 034 408',0,'',NULL,0,NULL,NULL),
('SANVI MAHESHA UPANAL',32,'None','1','A','233 058 864',0,'',NULL,0,NULL,NULL),
('SANVI REVANASIDDAPPA KAMMAR',33,'None','1','A','233 059 847',0,'',NULL,0,NULL,NULL),
('SATVIK BASAVARAJ KAMMAR',34,'None','1','A','234 688 163',0,'',NULL,0,NULL,NULL),
('SHREYA YALLARADDI YARAGUPPI',35,'None','1','A','233 054 595',0,'',NULL,0,NULL,NULL),
('SINDHU HANAMANTAPPA BADNI',36,'None','1','A','233 063 529',0,'',NULL,0,NULL,NULL),
('SINDHU MAILAREPPA NEELNAIKAR',37,'None','1','A','233 063 376',0,'',NULL,0,NULL,NULL),
('SRUJANGOUDA HUDED',38,'None','1','A','233 060 631',0,'',NULL,0,NULL,NULL),
('SWAROOP VERABHADRAYYA CHARANTIMATH',39,'None','1','A','233 056 807',0,'',NULL,0,NULL,NULL),
('TAWAKKALMASTAN SARFARAZ HALEMANI',40,'None','1','A','233 061 611',0,'',NULL,0,NULL,NULL),
('VACHANA M BATAGURKI',41,'None','1','A','233 063 591',0,'',NULL,0,NULL,NULL),
('VEDANT SHRIPAD MURARI',42,'None','1','A','234 266 052',0,'',NULL,0,NULL,NULL),
('VIKASH MURIGEPPA KARADI',43,'None','1','A','233 037 706',0,'',NULL,0,NULL,NULL),
('VINISHKAMANYA A KUMBI',44,'None','1','A','233 062 937',0,'',NULL,0,NULL,NULL),
('VISHWANATH SURESH KARJAGI',45,'None','1','A','233 063 434',0,'',NULL,0,NULL,NULL),
('YASH SANJEEV PATIL',46,'None','1','A','233 059 215',0,'',NULL,0,NULL,NULL),
('AARAV MAHANTESH YALAGI',47,'None','2','A','211 437 778',0,'',NULL,0,NULL,NULL),
('ABHIJNA VITHOB MALODAKAR',48,'None','2','A','212 823 806',0,'',NULL,0,NULL,NULL),
('ADIL HAJARESAB MULLANAVAR',49,'None','2','A','217 150 334',0,'',NULL,0,NULL,NULL),
('ADYVEER MALATESH PUJAR',50,'None','2','A','211 168 223',0,'',NULL,0,NULL,NULL),
('AFNAIN ASHRAF ALI HALAMANI',51,'None','2','A','210 539 667',0,'',NULL,0,NULL,NULL),
('AMOGH SANTOSH BALIKAI',52,'None','2','A','212 849 153',0,'',NULL,0,NULL,NULL),
('AMRUTA RAMANNA BHANDIWAD',53,'None','2','A','208 119 759',0,'',NULL,0,NULL,NULL),
('ANUSHRI SHARANAPPA MADALLI',54,'None','2','A','207 769 841',0,'',NULL,0,NULL,NULL),
('ATHARV BASAVARAJ HATTI',55,'None','2','A','218 341 608',0,'',NULL,0,NULL,NULL),
('ATHARVA FAKKIRAPPA KAMMAR',56,'None','2','A','211 173 577',0,'',NULL,0,NULL,NULL),
('BASAVEERAPPA SHAMBHU PATTANASHETTI',57,'None','2','A','187 856 813',0,'',NULL,0,NULL,NULL),
('BASAYYA NAGAYYA MATHAPATI',58,'None','2','A','187 858 477',0,'',NULL,0,NULL,NULL),
('CHETAN GURUNATH KAMARADDI',59,'None','2','A','196 002 659',0,'',NULL,0,NULL,NULL),
('DHANUSH SURESH HONAKERI',60,'None','2','A','213 518 204',0,'',NULL,0,NULL,NULL),
('DIKSHITA IRAPPA KOUDISHATTAR',61,'None','2','A','210 434 862',0,'',NULL,0,NULL,NULL),
('JAHNAVI VIRENDRA KUMAR KATAGI',62,'None','2','A','212 707 583',0,'',NULL,0,NULL,NULL),
('JEEVAN SURESH SURAGOND',63,'None','2','A','211 626 126',0,'',NULL,0,NULL,NULL),
('KEERTI MALATESH HIREBIDARI',64,'None','2','A','212 728 665',0,'',NULL,0,NULL,NULL),
('KHUSHI GUDADAPPA MALLUR',65,'None','2','A','211 170 462',0,'',NULL,0,NULL,NULL),
('KRUTI BHARAMAGOUDA PATIL',66,'None','2','A','212 709 271',0,'',NULL,0,NULL,NULL),
('MAHELEQA ASIFIQBAL SAIKALGAR',67,'None','2','A','220 696 567',0,'',NULL,0,NULL,NULL),
('MANOJ PUNDALIKAPPA LAMANI',68,'None','2','A','212 699 168',0,'',NULL,0,NULL,NULL),
('NAMAN MANJUNATH BHANDIWAD',69,'None','2','A','212 823 176',0,'',NULL,0,NULL,NULL),
('NANDISH CHANNAVEERESH HOMBAL',70,'None','2','A','212 848 411',0,'',NULL,0,NULL,NULL),
('NANDISH SHIDDAPPA MADIWALAR',71,'None','2','A','211 083 848',0,'',NULL,0,NULL,NULL),
('NIHALRAJ J LAXMESHWAR',72,'None','2','A','218 977 276',0,'',NULL,0,NULL,NULL),
('NIKHITAURVASHI BASAVARAJ ARALI',73,'None','2','A','220 936 159',0,'',NULL,0,NULL,NULL),
('NISHA BASAVARAJ YALAVATTI',74,'None','2','A','215 919 345',0,'',NULL,0,NULL,NULL),
('PRATEEK SHIVAPRAKASHAYYA HIREMATH',75,'None','2','A','215 536 883',0,'',NULL,0,NULL,NULL),
('PRATHAM MANJUNATH BADI',76,'None','2','A','212 847 735',0,'',NULL,0,NULL,NULL),
('PRATIK VIRUPAKSHAYYA HIREMATH',77,'None','2','A','210 298 428',0,'',NULL,0,NULL,NULL),
('PRITHVI RAVI MALALI',78,'None','2','A','212 349 313',0,'',NULL,0,NULL,NULL),
('PRIYA HANAMANTAPPA ADARAKATTI',79,'None','2','A','209 207 747',0,'',NULL,0,NULL,NULL),
('SAANVI VISHWANATH SANKANUR',80,'None','2','A','212 250 329',0,'',NULL,0,NULL,NULL),
('SAMARTH BASAVARAJ MADIWALAR',81,'None','2','A','211 618 145',0,'',NULL,0,NULL,NULL),
('SAMARTH CHANNAPPA KATTIMANI',82,'None','2','A','211 068 548',0,'',NULL,0,NULL,NULL),
('SAMARTH VEERABHADRAPPA MENASINAKAYI',83,'None','2','A','213 631 133',0,'',NULL,0,NULL,NULL),
('SAMARTHA SHARANAYYA PUJAR',84,'None','2','A','215 183 415',0,'',NULL,0,NULL,NULL),
('SAMREENABHANU MAHABOOBALI NADAF',85,'None','2','A','196 156 868',0,'',NULL,0,NULL,NULL),
('SANJAY NAGARAJ SAVANUR',86,'None','2','A','195 973 859',0,'',NULL,0,NULL,NULL),
('SANNIDHI BASAVARAJ JADAR',87,'None','2','A','212 729 115',0,'',NULL,0,NULL,NULL),
('SANNIDHI RAJANNA GULAGANNAVAR',88,'None','2','A','218 494 649',0,'',NULL,0,NULL,NULL),
('SATVIKGOUDA KUMARGOUDA CHIKKAGOUDRA',89,'None','2','A','215 197 405',0,'',NULL,0,NULL,NULL),
('SHREYA VEERANNA HITTINAMATH',90,'None','2','A','212 728 889',0,'',NULL,0,NULL,NULL),
('SHREYA CHETAN RAMPURE',91,'None','2','A','211 936 679',0,'',NULL,0,NULL,NULL),
('SHREYAS SOMAPPA SOPPIN',92,'None','2','A','211 172 047',0,'',NULL,0,NULL,NULL),
('SHRINIVAS RAVI HULAKOTI',93,'None','2','A','210 747 704',0,'',NULL,0,NULL,NULL),
('SHRISHAIL HANAMANTAPPA BHANDIWAD',94,'None','2','A','208 165 312',0,'',NULL,0,NULL,NULL),
('TARUNKUMAR ANAND SANKANUR',95,'None','2','A','213 375 091',0,'',NULL,0,NULL,NULL),
('VANISHRI SIDDAPPA NENAGANAHALLI',96,'None','2','A','207 458 418',0,'',NULL,0,NULL,NULL),
('VINAYAK RUDRAPPA PASHUPATIHAL',97,'None','2','A','210 429 495',0,'',NULL,0,NULL,NULL),
('YALLARADDI SOMARADDI HULIKATTI',98,'None','2','A','210 391 714',0,'',NULL,0,NULL,NULL),
('YASHAVANTH GURUPADAPPA ADRAKATTI',99,'None','2','A','208 200 682',0,'',NULL,0,NULL,NULL),
('AADHYA PRABHAKAR BOMALE',100,'None','3','A','198 409 215',0,'',NULL,0,NULL,NULL),
('AARADHYA KENCHAPPA BHANDIWAD',101,'None','3','A','201 581 434',0,'',NULL,0,NULL,NULL),
('ADARSH SHIVAYOGI HOMBAL',102,'None','3','A','198 439 567',0,'',NULL,0,NULL,NULL),
('ADHITHI SACHIDANAND MATHAD',103,'None','3','A','202 090 136',0,'',NULL,0,NULL,NULL),
('AKHANDESHWAR BASAVARAJ BUDIHAL',104,'None','3','A','198 421 973',0,'',NULL,0,NULL,NULL),
('AKSHAY RAVIKUMAR KALLUR',105,'None','3','A','198 417 438',0,'',NULL,0,NULL,NULL),
('ANUPAMA MAHADEVAYYA KALIWALMATH',106,'None','3','A','202 092 195',0,'',NULL,0,NULL,NULL),
('BHUVAN CHANNABASAPPA KORI',107,'None','3','A','201 983 028',0,'',NULL,0,NULL,NULL),
('BHUVI VINAYAK VETAL',108,'None','3','A','201 582 165',0,'',NULL,0,NULL,NULL),
('BRUNDA ANDANAPPA KORI',109,'None','3','A','202 552 954',0,'',NULL,0,NULL,NULL),
('CHANDAN SURESH DOMBAR',110,'None','3','A','201 585 719',0,'',NULL,0,NULL,NULL),
('CHIRAG PRAKASH PATIL',111,'None','3','A','198 421 242',0,'',NULL,0,NULL,NULL),
('DHANUSH RAJASHEKHAR RONAD',112,'None','3','A','198 439 229',0,'',NULL,0,NULL,NULL),
('DHANYATA DEEPAK KHARATE',113,'None','3','A','198 408 304',0,'',NULL,0,NULL,NULL),
('DHARANI MAHESH DURGAD',114,'None','3','A','202 835 909',0,'',NULL,0,NULL,NULL),
('FHARAN FAKRUSAB GUDARAD',115,'None','3','A','199 192 057',0,'',NULL,0,NULL,NULL),
('HEMA SHARANAPPA BUDIHAL',116,'None','3','A','198 421 477',0,'',NULL,0,NULL,NULL),
('KARUNAKAR HANUMANTNAYAK KALLANNAVAR',117,'None','3','A','198 416 742',0,'',NULL,0,NULL,NULL),
('KUSHAL UPPIN',118,'None','3','A','201 602 273',0,'',NULL,0,NULL,NULL),
('MAHAMMAD AYAN SHIGGAON',119,'None','3','A','195 975 108',0,'',NULL,0,NULL,NULL),
('MAHESHWARI SHARANABASAPPA KORI',120,'None','3','A','202 542 648',0,'',NULL,0,NULL,NULL),
('MALIKREHAN MAHMADALI SHIGGAON',121,'None','3','A','195 974 917',0,'',NULL,0,NULL,NULL),
('MANASWI M MARIGOUDAR',122,'None','3','A','195 980 745',0,'',NULL,0,NULL,NULL),
('MANJUNATH JAVALI',123,'None','3','A','195 978 168',0,'',NULL,0,NULL,NULL),
('MANVIT BASAVARAJ KORI',124,'None','3','A','202 131 618',0,'',NULL,0,NULL,NULL),
('NANDISH GOURISH HUMBI',125,'None','3','A','201 585 056',0,'',NULL,0,NULL,NULL),
('NAVYA PUJAR',126,'None','3','A','204 448 041',0,'',NULL,0,NULL,NULL),
('PRASHANT SHARANAPPA KATTI',127,'None','3','A','197 261 809',0,'',NULL,0,NULL,NULL),
('PREETAM MAHANTESH KOPPAL',128,'None','3','A','207 167 907',0,'',NULL,0,NULL,NULL),
('PREETAM SURESH METI',129,'None','3','A','202 837 529',0,'',NULL,0,NULL,NULL),
('SAANVI LAXMAN SUNAGAR',130,'None','3','A','201 519 281',0,'',NULL,0,NULL,NULL),
('SAFINABANU MUSTAF KOLKAR',131,'None','3','A','164 155 941',0,'',NULL,0,NULL,NULL),
('SAHANA BASAVARAJ JAVALI',132,'None','3','A','201 582 839',0,'',NULL,0,NULL,NULL),
('SANJANA SURESH RANGANAGOUDRA',133,'None','3','A','220 323 155',0,'',NULL,0,NULL,NULL),
('SANJAY SUGANNAVAR',134,'None','3','A','194 182 298',0,'',NULL,0,NULL,NULL),
('SANVI NAGARAJ ANGADI',135,'None','3','A','171 934 167',0,'',NULL,0,NULL,NULL),
('SHASHIKIRAN DURGAPPA PUJAR',136,'None','3','A','198 408 592',0,'',NULL,0,NULL,NULL),
('SPANDANA JANGINAMATH',137,'None','3','A','199 537 462',0,'',NULL,0,NULL,NULL),
('Siddanagouda S hiregoudra',138,'None','3','A','148 816 309',0,'',NULL,0,NULL,NULL),
('TEJAS PRASAD GUDAGERI',139,'None','3','A','198 421 635',0,'',NULL,0,NULL,NULL),
('TEJAS PRASHANT HAVERI',140,'None','3','A','198 421 804',0,'',NULL,0,NULL,NULL),
('THRISHA VEERESH SHALAVADI',141,'None','3','A','198 847 469',0,'',NULL,0,NULL,NULL),
('VAISHNAVI MANJUNATH SANGOLLI',142,'None','3','A','172 225 785',0,'',NULL,0,NULL,NULL),
('VARUN DEVANAGOUDA YALAVATTI',143,'None','3','A','201 579 871',0,'',NULL,0,NULL,NULL),
('VINAYA VITHALKUMAR BADI',144,'None','3','A','202 839 656',0,'',NULL,0,NULL,NULL),
('VISHAL PUNDALIKAPPA LAMANI',145,'None','3','A','198 289 762',0,'',NULL,0,NULL,NULL),
('Vijayalaxmi Vijaymahantesh Ronad',146,'None','3','A','204 443 282',0,'',NULL,0,NULL,NULL),
('ADARSH ANGADI',147,'None','4','A','184 589 729',0,'',NULL,0,NULL,NULL),
('AFJAN ASHRAFALI HALEMANI',148,'None','4','A','186 205 224',0,'',NULL,0,NULL,NULL),
('AKANKSHA VEERABHADRAYYA HIREMATH',149,'None','4','A','183 120 032',0,'',NULL,0,NULL,NULL),
('AYUSH NAYAK',150,'None','4','A','184 591 349',0,'',NULL,0,NULL,NULL),
('CHETANAKUMARA AVIN',151,'None','4','A','184 600 825',0,'',NULL,0,NULL,NULL),
('DHANUSH HATTI',152,'None','4','A','182 763 449',0,'',NULL,0,NULL,NULL),
('DHANUSH MURIGEPPA KARADI',153,'None','4','A','182 891 574',0,'',NULL,0,NULL,NULL),
('GANYA R SHETTI',154,'None','4','A','183 094 267',0,'',NULL,0,NULL,NULL),
('HARSHITH VEERAYYA HIREMATH',155,'None','4','A','203 022 391',0,'',NULL,0,NULL,NULL),
('HEMANT MALLIKARJUN MADAGUNAKI',156,'None','4','A','183 141 144',0,'',NULL,0,NULL,NULL),
('KAVYA MALATESH HIREBIDARI',157,'None','4','A','185 019 044',0,'',NULL,0,NULL,NULL),
('KESHAV MUDAKAPPA YARLAGATTI',158,'None','4','A','172 031 464',0,'',NULL,0,NULL,NULL),
('KHUSHI MAHANTESH HULIKATTI',159,'None','4','A','193 103 851',0,'',NULL,0,NULL,NULL),
('KUSHI BASAVARAJ BETAGERI',160,'None','4','A','185 574 566',0,'',NULL,0,NULL,NULL),
('MAHAMMADSHAHAJAD HAKKI',161,'None','4','A','194 305 234',0,'',NULL,0,NULL,NULL),
('MAHENUR HAMEED SAIKALGAR',162,'None','4','A','185 022 369',0,'',NULL,0,NULL,NULL),
('MOHAMEED ASHIFIQAL SAIKALGAR',163,'None','4','A','189 584 726',0,'',NULL,0,NULL,NULL),
('NAYANA MANJUNATH BHANDIWAD',164,'None','4','A','182 909 834',0,'',NULL,0,NULL,NULL),
('NIJAMUDDIN MOULALISAB GUDARAD',165,'None','4','A','182 861 944',0,'',NULL,0,NULL,NULL),
('PRANAV HATTI',166,'None','4','A','183 084 299',0,'',NULL,0,NULL,NULL),
('PRASAD NAIKAR',167,'None','4','A','187 300 474',0,'',NULL,0,NULL,NULL),
('PREETI ISHWAR LOHAR',168,'None','4','A','166 024 905',0,'',NULL,0,NULL,NULL),
('PRIYANKA PRAKASH SHIRAHATTI',169,'None','4','A','182 911 815',0,'',NULL,0,NULL,NULL),
('PRUTHVI BASAVARAJ BHANDIWAD',170,'None','4','A','184 907 888',0,'',NULL,0,NULL,NULL),
('PRUTHVIGOUDA S HIREGOUDRA',171,'None','4','A','185 383 502',0,'',NULL,0,NULL,NULL),
('ROHIT SURESH KURUBAR',172,'None','4','A','182 904 468',0,'',NULL,0,NULL,NULL),
('SAIKUMAR NEKAR',173,'None','4','A','183 106 962',0,'',NULL,0,NULL,NULL),
('SHANKAR HARAKUNI',174,'None','4','A','183 096 743',0,'',NULL,0,NULL,NULL),
('SHREYA PASHUPATIHAL',175,'None','4','A','183 105 078',0,'',NULL,0,NULL,NULL),
('SHRINIDHI SURESH KODLI',176,'None','4','A','182 916 502',0,'',NULL,0,NULL,NULL),
('SINCHANA HADIMANI',177,'None','4','A','184 588 943',0,'',NULL,0,NULL,NULL),
('SPANDANA R',178,'None','4','A','171 724 114',0,'',NULL,0,NULL,NULL),
('SUPRIT SAVANUR',179,'None','4','A','183 102 268',0,'',NULL,0,NULL,NULL),
('TEJAL MAHAVEER SAVADI',180,'None','4','A','182 864 473',0,'',NULL,0,NULL,NULL),
('VANI PADMARAJ DUNDASI',181,'None','4','A','188 780 247',0,'',NULL,0,NULL,NULL),
('VARSHA BELLATTI',182,'None','4','A','186 050 429',0,'',NULL,0,NULL,NULL),
('VEERESH PRAKASH WALI',183,'None','4','A','182 920 615',0,'',NULL,0,NULL,NULL),
('VIDYASHREE NEKAR',184,'None','4','A','183 105 738',0,'',NULL,0,NULL,NULL),
('VIRAT LIMBAYYASWAMIMATH',185,'None','4','A','183 627 377',0,'',NULL,0,NULL,NULL),
('APEKSHA VEERAPPA JAVALI',186,'None','5','A','149 807 116',0,'',NULL,0,NULL,NULL),
('BASAVARAJ MANJUNATH ADARAKATTI',187,'None','5','A','149 847 149',0,'',NULL,0,NULL,NULL),
('CHANNABASAVA MANJUNATH HADAPAD',188,'None','5','A','149 848 719',0,'',NULL,0,NULL,NULL),
('CHINMAY VENKAPPA MOOLAGI',189,'None','5','A','155 456 521',0,'',NULL,0,NULL,NULL),
('DIVYASHREE CHANNAPPA KATTIMANI',190,'None','5','A','154 620 983',0,'',NULL,0,NULL,NULL),
('GAGAN MENASAGI',191,'None','5','A','149 801 728',0,'',NULL,0,NULL,NULL),
('KANEEZ FATIMA BASHEER AHAMAD KILLEDAR',192,'None','5','A','152 588 809',0,'',NULL,0,NULL,NULL),
('KHUSHI BHARAMAGOUDA PATIL',193,'None','5','A','149 853 464',0,'',NULL,0,NULL,NULL),
('MAHAMMAD HUSEN FAKRUSAB GUDARAD',194,'None','5','A','149 767 438',0,'',NULL,0,NULL,NULL),
('NAVYA SIDDAPPA NENAGANAHALLI',195,'None','5','A','155 719 983',0,'',NULL,0,NULL,NULL),
('PRATIK KENCHANAGOUDA RANGANAGOUDRA',196,'None','5','A','171 342 613',0,'',NULL,0,NULL,NULL),
('SIDDALINGESH NAGARAJ GOUDANNAVAR',197,'None','5','A','149 775 755',0,'',NULL,0,NULL,NULL),
('SRUJAN RAVIKUMAR KODADAL',198,'None','5','A','149 846 391',0,'',NULL,0,NULL,NULL),
('SUJAN JAGADIASH GOJAGOJI',199,'None','5','A','155 509 927',0,'',NULL,0,NULL,NULL),
('YUVARAJ LAXMAN LAMANI',200,'None','5','A','118 402 036',0,'',NULL,0,NULL,NULL),
('BHAVANI BASAVARAJ ARALI',201,'None','6','A','127 518 466',0,'',NULL,0,NULL,NULL),
('HARSH SHANTAKUMAR GADAGINAMATH',202,'None','6','A','129 554 735',0,'',NULL,0,NULL,NULL),
('HARSHA MANJUNATH SANGOLLI',203,'None','6','A','129 794 879',0,'',NULL,0,NULL,NULL),
('HARSHIT RAJESH SHETTI',204,'None','6','A','129 250 709',0,'',NULL,0,NULL,NULL),
('JEEVAN MRITYUNJAY HIREMATH',205,'None','6','A','128 910 934',0,'',NULL,0,NULL,NULL),
('KAVERI PRAVEEN BHOPALAPUR',206,'None','6','A','124 277 266',0,'',NULL,0,NULL,NULL),
('LOKESH RANJEET CHOPRA',207,'None','6','A','128 911 136',0,'',NULL,0,NULL,NULL),
('MALLIKARJUN MAHESH YARAGUPPI',208,'None','6','A','132 058 872',0,'',NULL,0,NULL,NULL),
('NIRANJAN MARUTI GULANNAVAR',209,'None','6','A','125 324 767',0,'',NULL,0,NULL,NULL),
('PRATIKSHA DEVANAGOUDA YALAVATTI',210,'None','6','A','129 063 642',0,'',NULL,0,NULL,NULL),
('REHAN ABDULSAB BUDIHAL',211,'None','6','A','121 616 378',0,'',NULL,0,NULL,NULL),
('RENUKA NAGAPPA NEKAR',212,'None','6','A','074 849 412',0,'',NULL,0,NULL,NULL),
('ROHIT MALLIKARJUN DADANATTI',213,'None','6','A','128 836 019',0,'',NULL,0,NULL,NULL),
('SACHIT SHASHIDHAR MALAVADAKAR',214,'None','6','A','126 341 491',0,'',NULL,0,NULL,NULL),
('SAYEEDA AALIYA SAYED RAFIQ PEERZADE',215,'None','6','A','129 061 561',0,'',NULL,0,NULL,NULL),
('SEMEETA Y HALEMANI',216,'None','6','A','129 117 357',0,'',NULL,0,NULL,NULL),
('SHARANYA BASAVARAJ BATTUR',217,'None','6','A','127 676 358',0,'',NULL,0,NULL,NULL),
('SHREYASRAJ SURESH KODLI',218,'None','6','A','126 864 097',0,'',NULL,0,NULL,NULL),
('SHRIKRISHNAGOUDA YALLAPPAGOUDA PATIL',219,'None','6','A','126 353 235',0,'',NULL,0,NULL,NULL),
('SHRISHANKGOUDA NEELAKHANTGOUDA PATIL',220,'None','6','A','126 336 045',0,'',NULL,0,NULL,NULL),
('SRUSHTI FAKKIRAPPA KORADUR',221,'None','6','A','129 064 217',0,'',NULL,0,NULL,NULL),
('SRUSHTI VEERAPPA KORI',222,'None','6','A','129 110 232',0,'',NULL,0,NULL,NULL),
('SULEMAN ANSAR KANAVI',223,'None','6','A','129 065 677',0,'',NULL,0,NULL,NULL),
('TRISHA REVANASIDDAPPA KAMMAR',224,'None','6','A','127 382 308',0,'',NULL,0,NULL,NULL),
('UDAYAGOUDA SURESHGOUDA HIREGOUDRA',225,'None','6','A','129 134 253',0,'',NULL,0,NULL,NULL),
('VAMSHIKA BASAVARAJ BETAGERI',226,'None','6','A','126 288 109',0,'',NULL,0,NULL,NULL),
('Abc',227,'Male','6','A','',9448085060,'','information abcd',0,NULL,NULL),
('Test1',228,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test2',229,'Male','6','A','',8050482213,'','half term fees',0,NULL,NULL),
('Test 100',230,'Male','6','A','13',9901174103,'','2000 discount by ajjaar',0,NULL,NULL),
('Abc',231,'Male','6','A','3',7975254058,'',NULL,0,NULL,NULL),
('Test100',232,'Male','6','A','',9980067639,'','remark a',0,NULL,NULL),
('Test 555',233,'Male','6','A','123',8050482213,'','Ajjar told make discount',0,NULL,NULL),
('Nagraj',234,'Male','6','A','4521',9590868383,'','Nagraj sir 74',0,NULL,NULL),
('Name',235,'','Class','Division','Reg_No',0,'',NULL,0,NULL,NULL),
('ABC1',236,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC2',237,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC3',238,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC4',239,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC5',240,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC6',241,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC7',242,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC8',243,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC9',244,'','1','A','11',123,'',NULL,0,NULL,NULL),
('ABC10',245,'','1','A','11',123,'',NULL,0,NULL,NULL),
('Pallavi ',246,'Male','6','A','',8147951413,'','part payment',0,NULL,NULL),
('Prajnya Kulkarni',247,'Male','8','c','1',8951182860,'',NULL,0,NULL,NULL),
('Raghu',248,'Male','6','A','1212',9898244359,'',NULL,0,NULL,NULL),
('Est66',249,'Male','6','A','',9898244359,'',NULL,0,NULL,NULL),
('Temp',250,'Male','6','A','123',8050482213,'',NULL,0,NULL,NULL),
('Waeqeqwe',251,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Xyz 500 ',252,'Male','6','A','12',9743979012,'','remark afad',0,NULL,NULL),
('Test 850',253,'Male','6','A','1234',7022126427,'','remark',0,NULL,NULL),
('Test 741',254,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Mahnatesh',255,'Male','6','A','1',9945617839,'','chairman discount',0,NULL,NULL),
('Test111',256,'Male','6','A','111',1235467322,'',NULL,0,NULL,NULL),
('Est664444',257,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Dk 123',258,'Male','6','A','121212',9898244359,'',NULL,0,NULL,NULL),
('Asdasdad',259,'Male','6','A','12333',9898244,'',NULL,0,NULL,NULL),
('Test 500',260,'Male','LKG','A','1',9898244359,'',NULL,0,NULL,NULL),
('Test 902',261,'Male','LKG','A','5656',8050482213,'',NULL,0,NULL,NULL),
('Raghu 1',262,'Male','6','A','123',8050482213,'',NULL,0,NULL,NULL),
('Shweta Rao',263,'Male','9','d','12',1234567895,'',NULL,0,NULL,NULL),
('Dhawan',264,'Male','class 1','A','2',1222222222,'','',0,NULL,NULL),
('Test 900',265,'Male','6','A','125',0,'','remark ',0,NULL,NULL),
('EV I',266,'Male','class I','E','125',9880780808,'',NULL,0,NULL,NULL),
('EV II',267,'Male','class I','E','126',8888888888,'',NULL,0,NULL,NULL),
('EV III',268,'Male','class I','E','127',1212121212,'',NULL,0,NULL,NULL),
('EVIV',269,'Male','class I','E','128',2121212121,'',NULL,0,NULL,NULL),
('EV V',270,'Male','class I','E','129',3232323232,'',NULL,0,NULL,NULL),
('EVVI',271,'Male','class I','E','3636363636',3535353535,'',NULL,0,NULL,NULL),
('EVVII',272,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('EVVIII',273,'Male','class I','E','129',9898989898,'',NULL,0,NULL,NULL),
('EVX',274,'Male','class I','E','129',3634345245,'',NULL,0,NULL,NULL),
('EVXI',275,'Male','class I','A','1235',6846846846,'',NULL,0,NULL,NULL),
('EVXI',276,'Male','class I','E','1245',9969869866,'',NULL,0,NULL,NULL),
('Shw1',277,'Male','6','A','136',8951182860,'',NULL,0,NULL,NULL),
('Shw2',278,'Male','class II','f','258',8995118260,'',NULL,0,NULL,NULL),
('SRR',279,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('SRR 1',280,'Male','class III','f','',9880780808,'',NULL,0,NULL,NULL),
('SRR2',281,'Male','class III','E','126',1222222222,'',NULL,0,NULL,NULL),
('Shh',282,'Male','class IV','G','12',1222222222,'',NULL,0,NULL,NULL),
('Shh 1',283,'Male','class IV','G','',1234567895,'',NULL,0,NULL,NULL),
('Shh 2',284,'Male','class IV','G','127',1212121212,'',NULL,0,NULL,NULL),
('Shh 3',285,'Male','class IV','A','127',8888888888,'',NULL,0,NULL,NULL),
('Shh4',286,'Male','class IV','G','126',1212121212,'',NULL,0,NULL,NULL),
('Shh5',287,'Male','class IV','G','125',1212121212,'',NULL,0,NULL,NULL),
('EGG ',288,'Male','7','H','121',1234567895,'',NULL,0,NULL,NULL),
('EGG1',289,'Male','7','A','122',2121212121,'',NULL,0,NULL,NULL),
('EGG2',290,'Male','7','H','2',1212121212,'',NULL,0,NULL,NULL),
('EGG 1',291,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Xyz ',292,'Male','6','A','1234',9844497775,'','note : asdfd',0,NULL,NULL),
('Rdk Sms',293,'Male','6','A','133',8050482213,'',NULL,0,NULL,NULL),
('Test0987',294,'Male','LKG','A','3453453453453',9898244359,'',NULL,0,NULL,NULL),
('Radk Test2',295,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Test 900',296,'Male','LKG','A','',8050482213,'',NULL,0,NULL,NULL),
('Raghu',297,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Raghu774',298,'Male','6','A','',8050450482,'','',0,NULL,NULL),
('Xyz 45',299,'Male','6','A','',8050482213,'','',0,NULL,NULL),
('Raghu 121212',300,'Male','5','B','e322424234',8050450482,'','',0,NULL,NULL),
('HERT2',301,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test User 987',302,'Male','6','A','834753453',9898244359,'','',0,NULL,NULL),
('Test User 123',303,'Male','LKG','A','344242432',9898244359,'','',0,NULL,NULL),
('Dhawan',304,'Male','1','A','',0,'','',0,NULL,NULL),
('Test 07Jan',305,'Male','6','A','3242423442424',0,'',NULL,0,NULL,NULL),
('Demo 1',306,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('DK Test',307,'Male','6','A','987',9898244359,'',NULL,0,NULL,NULL),
('Rahu Sms Test 4-1',308,'Male','6','A','123',8050482213,'',NULL,0,NULL,NULL),
('Raghu12',309,'Male','6','A','12341',8050482213,'',NULL,0,NULL,NULL),
('Raghu - Sms',310,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Std 3rd April',311,'Male','6','A','03042024',9898244359,'',NULL,0,NULL,NULL),
('Atest 7',312,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test 8901',313,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test 876',314,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Test 9001',315,'Male','6','A','123456',9448629611,'','Chairman - dambal',0,NULL,NULL),
('Rgk111',316,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Test 12121212',317,'Male','6','A','23423434244',0,'',NULL,0,NULL,NULL),
('Raghu2322',318,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Sdadad',319,'Male','6','A','34234243',0,'',NULL,0,NULL,NULL),
('Test3uy',320,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Sbk',321,'Male','6','A','',9902426815,'',NULL,0,NULL,NULL),
('Vsp',322,'Male','6','A','',0,'','',0,NULL,NULL),
('Thfg',323,'Male','6','A','',0,'','With van ',0,NULL,NULL),
('Basavaraj ',324,'Male','6','A','12',9481526686,'',NULL,0,NULL,NULL),
('Test Sms 100',325,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Test Student Data',326,'Male','6','A','32423442423',9898244359,'',NULL,0,NULL,NULL),
('Rrrk',327,'Male','6','A','122',1111222232,'',NULL,0,NULL,NULL),
('Sd Asdasd',328,'Male','6','A','213123132121312',9898244359,'',NULL,0,NULL,NULL),
('Sderwer',329,'Male','6','A','2342423412',9898244359,'',NULL,0,NULL,NULL),
('Final With Point',330,'Male','6','A','3242432423456',9898244359,'',NULL,0,NULL,NULL),
('Test111444',331,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test Data123123',332,'Male','6','A','342423423',9898244359,'',NULL,0,NULL,NULL),
('Test Point Val',333,'Male','6','A','q3424fsdf',9898244359,'',NULL,0,NULL,NULL),
('Kjsd Djasd',334,'Male','6','A','34234234kkk',9898244359,'',NULL,0,NULL,NULL),
('Dec Test',335,'Male','6','A','',0,'','',0,NULL,NULL),
('Tesert Dec',336,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test Sms',337,'Male','6','A','',8050482213,'',NULL,0,NULL,NULL),
('Test Sms Bijapur',338,'Male','6','A','',9738455405,'',NULL,0,NULL,NULL),
('Test 1',339,'Male','6','A','1',8050482213,'',NULL,0,NULL,NULL),
('Pallavi',340,'Male','6','A','',8795462581,'','',0,NULL,NULL),
('Test Channel',341,'Male','6','A','TEST343434',9898244359,'',NULL,0,NULL,NULL),
('Rajendra ',353,'Male','6','A','12',9481562949,'','Meti ',0,NULL,NULL),
('Abcd',343,'Male','10','A','4141',0,'',NULL,0,NULL,NULL),
('Xyz',344,'Male','10th','A','4141',0,'',NULL,0,NULL,NULL),
('Vishal',346,'Male','9','B','014',0,'','',0,'',NULL),
('Abhinava',352,'Male','10','A','9972',0,'','',0,'',NULL),
('Desai',354,'Male','6','A','',8548096442,'','Chairman sir',0,NULL,NULL),
('Test26March2025',355,'Male','6','A','26032025',9898244359,'',NULL,0,'test data','images/students/demor/355.png'),
('Test26March2025 2',356,'Male','6','A','260320252',9898989898,'',NULL,0,NULL,NULL),
('Demo Stufent 27032025-1',357,'Male','6','A','270320251',9898989898,'',NULL,0,NULL,NULL),
('Test 10001',358,'Male','6','A','111',0,'',NULL,0,NULL,NULL),
('Test Cha',359,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test 10011',360,'Male','6','A','11',0,'',NULL,0,NULL,NULL),
('FD111',361,'Male','6','A','',0,'',NULL,0,NULL,NULL),
('Test 11',362,'Male','6','A','',0,'',NULL,0,NULL,NULL);
/*!40000 ALTER TABLE `stud_basic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic2`
--
DROP TABLE IF EXISTS `stud_basic2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic2` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` decimal(10,2) NOT NULL,
`Paid` decimal(10,2) NOT NULL,
`Balance` decimal(10,2) NOT NULL,
`discount` decimal(10,2) NOT NULL,
`discription` varchar(200) NOT NULL,
`year` varchar(20) DEFAULT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=410 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,77,1,1,15000.00,0.00,15000.00,0.00,'',NULL),
(2,227,1,1,13000.00,7000.00,6000.00,2000.00,'',NULL),
(3,228,1,1,15000.00,0.00,15000.00,0.00,'',NULL),
(4,229,1,1,15000.00,15000.00,0.00,0.00,'',NULL),
(5,230,1,1,13000.00,9000.00,4000.00,2000.00,'',NULL),
(6,229,3,3,3000.00,3000.00,0.00,3000.00,'',NULL),
(7,231,1,1,15000.00,0.00,15000.00,0.00,'',NULL),
(8,231,3,3,6000.00,0.00,6000.00,0.00,'',NULL),
(9,232,1,1,10000.00,5000.00,5000.00,5000.00,'',NULL),
(10,232,4,6,100.00,100.00,0.00,0.00,'',NULL),
(11,232,4,7,450.00,450.00,0.00,0.00,'',NULL),
(12,233,1,1,14000.00,9000.00,5000.00,1000.00,'',NULL),
(13,233,4,6,100.00,100.00,0.00,0.00,'',NULL),
(14,233,4,7,450.00,200.00,250.00,0.00,'',NULL),
(15,234,2,2,12000.00,5000.00,7000.00,4000.00,'',NULL),
(16,234,5,7,450.00,400.00,50.00,0.00,'',NULL),
(17,234,5,8,2600.00,1500.00,1100.00,0.00,'',NULL),
(18,234,5,9,600.00,600.00,0.00,0.00,'',NULL),
(19,244,1,1,15000.00,1000.00,14000.00,0.00,'',NULL),
(20,244,4,6,100.00,100.00,0.00,0.00,'',NULL),
(21,244,4,7,450.00,450.00,0.00,0.00,'',NULL),
(22,246,1,1,18000.00,5000.00,13000.00,-3000.00,'',NULL),
(24,246,7,3,6000.00,1000.00,5000.00,0.00,'',NULL),
(25,246,7,6,100.00,100.00,0.00,0.00,'',NULL),
(26,247,9,19,15000.00,8000.00,7000.00,0.00,'',NULL),
(27,248,1,1,15000.00,15000.00,0.00,0.00,'',NULL),
(28,249,1,1,15000.00,15000.00,0.00,0.00,'',NULL),
(29,250,1,1,15000.00,0.00,15000.00,0.00,'',NULL),
(30,251,4,6,100.00,0.00,100.00,0.00,'',NULL),
(31,251,4,7,450.00,0.00,450.00,0.00,'',NULL),
(32,252,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(33,252,7,1,6500.00,0.00,6500.00,0.00,'',NULL),
(34,252,7,3,6000.00,0.00,6000.00,0.00,'',NULL),
(35,252,7,6,100.00,0.00,100.00,0.00,'',NULL),
(36,253,1,1,7500.00,3000.00,4500.00,-1000.00,'',NULL),
(37,253,4,6,100.00,100.00,0.00,0.00,'',NULL),
(38,253,4,7,450.00,200.00,250.00,0.00,'',NULL),
(39,254,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(40,254,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(41,255,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(42,255,3,3,4000.00,2000.00,2000.00,2000.00,'',NULL),
(43,256,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(44,256,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(45,257,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(46,258,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(47,258,4,6,100.00,100.00,0.00,0.00,'',NULL),
(48,258,4,7,450.00,450.00,0.00,0.00,'',NULL),
(49,259,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(50,259,4,6,100.00,100.00,0.00,0.00,'',NULL),
(51,259,4,7,450.00,450.00,0.00,0.00,'',NULL),
(52,260,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(53,260,9,19,15000.00,5000.00,10000.00,0.00,'',NULL),
(54,261,1,1,6500.00,5000.00,1500.00,0.00,'',NULL),
(55,261,9,19,15000.00,5000.00,10000.00,0.00,'',NULL),
(56,262,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(57,263,11,20,5000.00,3000.00,2000.00,0.00,'',NULL),
(58,263,11,21,2000.00,1000.00,1000.00,0.00,'',NULL),
(59,264,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(60,264,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(61,265,14,28,500.00,100.00,400.00,-400.00,'',NULL),
(62,265,14,29,200.00,50.00,150.00,0.00,'',NULL),
(63,265,14,30,300.00,50.00,250.00,0.00,'',NULL),
(64,266,11,20,5000.00,5000.00,0.00,0.00,'',NULL),
(65,266,11,21,2000.00,2000.00,0.00,0.00,'',NULL),
(66,267,15,5,150.00,150.00,0.00,0.00,'',NULL),
(67,267,15,7,450.00,450.00,0.00,0.00,'',NULL),
(68,267,15,9,600.00,600.00,0.00,0.00,'',NULL),
(69,268,14,28,100.00,100.00,0.00,0.00,'',NULL),
(70,268,14,29,200.00,200.00,0.00,0.00,'',NULL),
(71,268,14,30,300.00,300.00,0.00,0.00,'',NULL),
(72,269,9,19,15000.00,0.00,15000.00,0.00,'',NULL),
(73,270,4,6,100.00,100.00,0.00,0.00,'',NULL),
(74,270,4,7,450.00,450.00,0.00,0.00,'',NULL),
(75,271,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(76,272,14,28,100.00,100.00,0.00,0.00,'',NULL),
(77,272,14,29,200.00,200.00,0.00,0.00,'',NULL),
(78,272,14,30,300.00,300.00,0.00,0.00,'',NULL),
(79,273,11,20,5000.00,5000.00,0.00,0.00,'',NULL),
(80,273,11,21,2000.00,2000.00,0.00,0.00,'',NULL),
(81,274,11,20,5000.00,5000.00,0.00,0.00,'',NULL),
(82,274,11,21,2000.00,2000.00,0.00,0.00,'',NULL),
(83,275,5,7,450.00,450.00,0.00,0.00,'',NULL),
(84,275,5,8,2600.00,2600.00,0.00,0.00,'',NULL),
(85,275,5,9,600.00,600.00,0.00,0.00,'',NULL),
(86,276,14,28,100.00,1200.00,-1100.00,0.00,'',NULL),
(87,276,14,29,200.00,2400.00,-2200.00,0.00,'',NULL),
(88,276,14,30,300.00,3600.00,-3300.00,0.00,'',NULL),
(89,267,11,20,5000.00,5000.00,0.00,0.00,'',NULL),
(90,267,11,21,2000.00,2000.00,0.00,0.00,'',NULL),
(91,268,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(92,268,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(93,270,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(94,270,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(95,269,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(96,269,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(97,271,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(98,271,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(99,276,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(100,276,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(101,277,17,35,5000.00,0.00,5000.00,0.00,'',NULL),
(102,277,17,36,200.00,0.00,200.00,0.00,'',NULL),
(103,277,16,33,100.00,0.00,100.00,0.00,'',NULL),
(104,277,16,34,50.00,0.00,50.00,0.00,'',NULL),
(105,278,17,35,5000.00,5000.00,0.00,0.00,'',NULL),
(106,278,17,36,200.00,200.00,0.00,0.00,'',NULL),
(107,278,16,33,100.00,100.00,0.00,0.00,'',NULL),
(108,278,16,34,50.00,50.00,0.00,0.00,'',NULL),
(109,279,18,37,2000.00,0.00,2000.00,0.00,'',NULL),
(110,279,18,38,2000.00,0.00,2000.00,0.00,'',NULL),
(111,280,18,37,2000.00,2000.00,0.00,0.00,'',NULL),
(112,280,18,38,2000.00,2000.00,0.00,0.00,'',NULL),
(113,281,18,37,0.00,0.00,0.00,0.00,'',NULL),
(114,281,18,38,0.00,0.00,0.00,0.00,'',NULL),
(115,282,19,6,100.00,0.00,100.00,0.00,'',NULL),
(116,282,19,39,5000.00,0.00,5000.00,0.00,'',NULL),
(117,282,19,40,5000.00,0.00,5000.00,0.00,'',NULL),
(118,283,19,6,100.00,100.00,0.00,0.00,'',NULL),
(119,283,19,39,5000.00,5000.00,0.00,0.00,'',NULL),
(120,283,19,40,5000.00,5000.00,0.00,0.00,'',NULL),
(121,284,19,6,100.00,0.00,100.00,0.00,'',NULL),
(122,284,19,39,5000.00,0.00,5000.00,0.00,'',NULL),
(123,284,19,40,5000.00,0.00,5000.00,0.00,'',NULL),
(124,285,19,6,100.00,0.00,100.00,0.00,'',NULL),
(125,285,19,39,5000.00,0.00,5000.00,0.00,'',NULL),
(126,285,19,40,5000.00,0.00,5000.00,0.00,'',NULL),
(127,286,19,6,100.00,0.00,100.00,0.00,'',NULL),
(128,286,19,39,5000.00,0.00,5000.00,0.00,'',NULL),
(129,286,19,40,5000.00,0.00,5000.00,0.00,'',NULL),
(130,287,19,6,100.00,0.00,100.00,0.00,'',NULL),
(131,287,19,39,5000.00,0.00,5000.00,0.00,'',NULL),
(132,287,19,40,5000.00,0.00,5000.00,0.00,'',NULL),
(133,288,20,25,10000.00,0.00,10000.00,0.00,'',NULL),
(134,288,20,42,100.00,0.00,100.00,0.00,'',NULL),
(135,288,20,44,2000.00,0.00,2000.00,0.00,'',NULL),
(136,288,20,45,8000.00,0.00,8000.00,0.00,'',NULL),
(137,289,20,25,10000.00,0.00,10000.00,0.00,'',NULL),
(138,289,20,42,100.00,0.00,100.00,0.00,'',NULL),
(139,289,20,44,2000.00,0.00,2000.00,0.00,'',NULL),
(140,289,20,45,8000.00,0.00,8000.00,0.00,'',NULL),
(141,290,20,25,10000.00,0.00,10000.00,0.00,'',NULL),
(142,290,20,42,100.00,0.00,100.00,0.00,'',NULL),
(143,290,20,44,2000.00,0.00,2000.00,0.00,'',NULL),
(144,290,20,45,8000.00,0.00,8000.00,0.00,'',NULL),
(145,291,20,25,10000.00,0.00,10000.00,0.00,'',NULL),
(146,291,20,42,100.00,0.00,100.00,0.00,'',NULL),
(147,291,20,44,2000.00,0.00,2000.00,0.00,'',NULL),
(148,291,20,45,8000.00,0.00,8000.00,0.00,'',NULL),
(149,292,1,1,5000.00,3000.00,2000.00,1500.00,'',NULL),
(150,292,4,6,100.00,0.00,100.00,0.00,'',NULL),
(151,292,4,7,450.00,0.00,450.00,0.00,'',NULL),
(152,292,9,19,10000.00,4000.00,6000.00,5000.00,'',NULL),
(153,293,1,1,6500.00,6000.00,500.00,0.00,'',NULL),
(154,294,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(155,294,3,3,6000.00,3000.00,3000.00,0.00,'',NULL),
(156,295,1,1,6500.00,4000.00,2500.00,0.00,'',NULL),
(157,296,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(158,296,4,6,100.00,0.00,100.00,0.00,'',NULL),
(159,296,4,7,450.00,0.00,450.00,0.00,'',NULL),
(160,296,2,2,16000.00,0.00,16000.00,0.00,'',NULL),
(161,297,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(162,298,1,1,650000.00,0.00,650000.00,-643500.00,'',NULL),
(163,299,1,1,650000.00,0.00,650000.00,-643500.00,'',NULL),
(164,300,2,2,650000.00,0.00,650000.00,-634000.00,'',NULL),
(165,301,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(166,302,3,3,650000.00,650000.00,0.00,-644000.00,'',NULL),
(167,303,5,7,650000.00,650000.00,0.00,-649550.00,'',NULL),
(168,303,5,8,2600.00,2600.00,0.00,0.00,'',NULL),
(169,303,5,9,600.00,600.00,0.00,0.00,'',NULL),
(170,304,15,5,250.00,0.00,250.00,0.00,'',NULL),
(171,304,15,7,450.00,0.00,450.00,0.00,'',NULL),
(172,304,15,9,600.00,0.00,600.00,0.00,'',NULL),
(173,304,9,19,15000.00,0.00,15000.00,0.00,'',NULL),
(174,304,11,20,5000.00,0.00,5000.00,0.00,'',NULL),
(175,304,11,21,2000.00,0.00,2000.00,0.00,'',NULL),
(176,304,20,25,10000.00,0.00,10000.00,0.00,'',NULL),
(177,304,20,42,100.00,0.00,100.00,0.00,'',NULL),
(178,304,20,44,2000.00,0.00,2000.00,0.00,'',NULL),
(179,304,20,45,8000.00,0.00,8000.00,0.00,'',NULL),
(180,305,2,2,16000.00,15999.00,1.00,0.00,'',NULL),
(181,305,15,5,250.00,250.00,0.00,0.00,'',NULL),
(182,305,15,7,450.00,450.00,0.00,0.00,'',NULL),
(183,305,15,9,600.00,600.00,0.00,0.00,'',NULL),
(184,305,9,19,15000.00,11000.00,4000.00,0.00,'',NULL),
(185,306,1,1,9000.00,0.00,9000.00,0.00,'',NULL),
(186,307,2,2,16000.00,16000.00,0.00,0.00,'',NULL),
(187,307,7,1,6500.00,6500.00,0.00,0.00,'',NULL),
(188,307,7,3,6000.00,6000.00,0.00,0.00,'',NULL),
(189,307,7,6,100.00,100.00,0.00,0.00,'',NULL),
(190,308,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(191,309,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(192,310,1,1,6500.00,2000.00,4500.00,0.00,'',NULL),
(193,311,2,2,16000.00,16000.00,0.00,0.00,'',NULL),
(194,312,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(195,312,17,35,5000.00,0.00,5000.00,0.00,'',NULL),
(196,312,17,36,200.00,0.00,200.00,0.00,'',NULL),
(197,313,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(198,314,1,1,6500.00,3500.00,3000.00,0.00,'',NULL),
(199,315,1,1,6000.00,3000.00,3000.00,500.00,'',NULL),
(200,315,9,19,2500.00,1500.00,1000.00,12500.00,'',NULL),
(201,316,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(202,317,2,2,16000.00,16000.00,0.00,0.00,'',NULL),
(203,318,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(204,318,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(205,1,1,1,6500.00,5000.00,1500.00,0.00,'',NULL),
(206,3,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(207,3,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(209,1,2,2,16000.00,0.00,16000.00,0.00,'',NULL),
(210,1,5,7,450.00,0.00,450.00,0.00,'',NULL),
(211,1,5,8,2600.00,0.00,2600.00,0.00,'',NULL),
(212,1,5,9,600.00,0.00,600.00,0.00,'',NULL),
(213,319,2,2,16000.00,0.00,16000.00,0.00,'',NULL),
(214,320,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(215,321,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(216,322,2,2,13500.00,3500.00,10000.00,2500.00,'',NULL),
(217,323,2,2,13500.00,4500.00,9000.00,2500.00,'',NULL),
(218,324,11,20,5000.00,4000.00,1000.00,0.00,'',NULL),
(219,324,11,21,2000.00,2000.00,0.00,0.00,'',NULL),
(220,325,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(221,326,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(222,326,4,6,100.00,100.00,0.00,0.00,'',NULL),
(223,326,4,7,450.00,450.00,0.00,0.00,'',NULL),
(224,327,21,49,102.00,103.00,0.00,0.00,'',NULL),
(225,327,21,50,50.00,50.00,0.00,0.00,'',NULL),
(226,328,4,6,100.00,0.00,100.00,0.00,'',NULL),
(227,328,4,7,450.00,0.00,450.00,0.00,'',NULL),
(228,328,7,1,6500.00,0.00,6500.00,0.00,'',NULL),
(229,328,7,3,6000.00,0.00,6000.00,0.00,'',NULL),
(230,328,7,6,100.00,0.00,100.00,0.00,'',NULL),
(231,328,21,49,102.00,0.00,103.00,0.00,'',NULL),
(232,328,21,50,50.00,0.00,50.00,0.00,'',NULL),
(233,329,22,51,201.00,0.00,201.00,0.00,'',NULL),
(234,330,22,51,201.00,201.00,0.00,0.00,'',NULL),
(235,330,22,52,20.00,20.00,0.00,0.00,'',NULL),
(236,331,22,51,201.00,0.00,201.00,0.00,'',NULL),
(237,331,22,52,20.00,0.00,20.00,0.00,'',NULL),
(238,332,22,51,201.00,0.00,201.00,0.00,'',NULL),
(239,332,22,52,20.00,0.00,20.00,0.00,'',NULL),
(240,333,23,1,6500.00,6500.00,0.00,0.00,'',NULL),
(241,333,23,53,22.00,22.00,0.00,0.00,'',NULL),
(242,334,3,3,6000.00,6000.00,0.00,0.00,'',NULL),
(243,334,23,1,6500.00,6500.00,0.00,0.00,'',NULL),
(244,334,23,53,22.25,22.25,0.00,0.00,'',NULL),
(245,335,24,54,100.50,100.10,0.40,0.00,'',NULL),
(246,335,24,55,200.50,200.20,0.30,0.00,'',NULL),
(247,335,24,56,250.40,250.30,0.10,50.00,'',NULL),
(248,336,24,54,100.50,100.10,0.40,0.00,'',NULL),
(249,336,24,55,200.50,200.50,0.00,0.00,'',NULL),
(250,336,24,56,300.40,300.20,0.20,0.00,'',NULL),
(251,337,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(252,338,1,1,6500.00,600.00,5900.00,0.00,'',NULL),
(253,339,1,1,6500.00,3000.00,3500.00,0.00,'',NULL),
(254,340,4,6,100.00,100.00,0.00,0.00,'',NULL),
(255,340,4,7,300.00,100.00,200.00,150.00,'',NULL),
(256,341,3,3,6000.00,0.00,6000.00,0.00,'',NULL),
(257,341,9,19,15000.00,0.00,15000.00,0.00,'',NULL),
(258,341,16,33,100.00,0.00,100.00,0.00,'',NULL),
(259,341,16,34,50.00,0.00,50.00,0.00,'',NULL),
(386,354,1,1,2000.00,0.00,2000.00,4500.00,'',NULL),
(325,346,31,93,1795.00,1795.00,0.00,205.00,'',NULL),
(324,346,27,75,10.00,10.00,0.00,0.00,'',NULL),
(323,346,27,74,15.00,15.00,0.00,0.00,'',NULL),
(322,346,27,73,5.00,5.00,0.00,0.00,'',NULL),
(321,346,27,72,10.00,10.00,0.00,0.00,'',NULL),
(320,346,27,71,10.00,10.00,0.00,0.00,'',NULL),
(319,346,27,70,20.00,20.00,0.00,0.00,'',NULL),
(318,346,27,69,20.00,20.00,0.00,0.00,'',NULL),
(317,346,27,68,25.00,25.00,0.00,0.00,'',NULL),
(316,346,27,67,0.00,0.00,0.00,0.00,'',NULL),
(315,346,26,66,10.00,10.00,0.00,0.00,'',NULL),
(314,346,26,65,15.00,15.00,0.00,0.00,'',NULL),
(313,346,26,64,15.00,15.00,0.00,0.00,'',NULL),
(312,346,26,63,20.00,20.00,0.00,0.00,'',NULL),
(311,346,26,62,20.00,20.00,0.00,0.00,'',NULL),
(370,352,28,76,1795.00,1795.00,0.00,205.00,'',NULL),
(369,352,26,66,10.00,0.00,10.00,0.00,'',NULL),
(368,352,26,65,15.00,0.00,15.00,0.00,'',NULL),
(367,352,26,64,15.00,0.00,15.00,0.00,'',NULL),
(366,352,26,63,20.00,0.00,20.00,0.00,'',NULL),
(365,352,26,62,20.00,0.00,20.00,0.00,'',NULL),
(364,352,26,61,10.00,0.00,10.00,0.00,'',NULL),
(283,343,31,93,2000.00,1795.00,205.00,0.00,'',NULL),
(284,344,30,84,10.00,0.00,10.00,0.00,'',NULL),
(285,344,30,85,25.00,0.00,25.00,0.00,'',NULL),
(286,344,30,86,20.00,0.00,20.00,0.00,'',NULL),
(287,344,30,87,20.00,0.00,20.00,0.00,'',NULL),
(288,344,30,88,10.00,0.00,10.00,0.00,'',NULL),
(289,344,30,89,10.00,0.00,10.00,0.00,'',NULL),
(290,344,30,90,10.00,0.00,10.00,0.00,'',NULL),
(291,344,30,91,15.00,0.00,15.00,0.00,'',NULL),
(292,344,30,92,10.00,0.00,10.00,0.00,'',NULL),
(310,346,26,61,10.00,10.00,0.00,0.00,'',NULL),
(385,353,43,9,600.00,0.00,600.00,0.00,'',NULL),
(384,353,43,6,100.00,0.00,100.00,0.00,'',NULL),
(383,353,43,5,250.00,0.00,250.00,0.00,'',NULL),
(382,353,5,9,400.00,0.00,400.00,200.00,'',NULL),
(381,353,5,8,2600.00,0.00,2600.00,0.00,'',NULL),
(380,353,5,7,450.00,0.00,450.00,0.00,'',NULL),
(379,353,1,1,6500.00,2000.00,4500.00,0.00,'',NULL),
(378,352,41,169,10.00,0.00,10.00,0.00,'',NULL),
(377,352,41,168,15.00,0.00,15.00,0.00,'',NULL),
(376,352,41,167,5.00,0.00,5.00,0.00,'',NULL),
(375,352,41,166,10.00,0.00,10.00,0.00,'',NULL),
(374,352,41,165,10.00,0.00,10.00,0.00,'',NULL),
(373,352,41,164,20.00,0.00,20.00,0.00,'',NULL),
(372,352,41,163,20.00,0.00,20.00,0.00,'',NULL),
(371,352,41,162,25.00,0.00,25.00,0.00,'',NULL),
(387,354,7,1,2000.00,0.00,2000.00,4500.00,'',NULL),
(388,354,7,3,6000.00,0.00,6000.00,0.00,'',NULL),
(389,354,7,6,100.00,0.00,100.00,0.00,'',NULL),
(390,354,44,47,0.00,0.00,0.00,0.00,'',NULL),
(391,355,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(392,355,4,6,100.00,100.00,0.00,0.00,'',NULL),
(393,355,4,7,450.00,450.00,0.00,0.00,'',NULL),
(394,355,9,19,15000.00,10000.00,5000.00,0.00,'',NULL),
(395,355,2,2,16000.00,0.00,16000.00,0.00,'',NULL),
(396,356,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(397,356,3,3,6000.00,0.00,6000.00,0.00,'',NULL),
(398,356,4,6,100.00,0.00,100.00,0.00,'',NULL),
(399,356,4,7,450.00,0.00,450.00,0.00,'',NULL),
(400,357,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(401,357,2,2,16000.00,0.00,16000.00,0.00,'',NULL),
(402,357,3,3,6000.00,0.00,6000.00,0.00,'',NULL),
(403,358,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(404,358,3,3,6000.00,0.00,6000.00,0.00,'',NULL),
(405,359,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(406,359,9,19,15000.00,0.00,15000.00,0.00,'',NULL),
(407,360,1,1,6500.00,6500.00,0.00,0.00,'',NULL),
(408,361,1,1,6500.00,0.00,6500.00,0.00,'',NULL),
(409,362,1,1,6500.00,6500.00,0.00,0.00,'',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=173 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
('TUITION FEES',1,'6500','D'),
('TUITION FEES',2,'16000','D'),
('LAXMESHWARA',3,'6000','N'),
('MANJALAPUR ',4,'7000','D'),
('sports fee',5,'250','N'),
('application Fees',6,'100','N'),
('computer Fees',7,'450','D'),
('Uniform fees',8,'2600','D'),
('test 100',9,'600','N'),
('Application 1',10,'500','N'),
('VAN FEES',11,'5000','D'),
('VAN FEES',12,'5000','D'),
('CKIKKMAGI',13,'5000','D'),
('MUGUNUR MARDADI BUDIHAL BASAVNAL',14,'4500','D'),
('BASARIKATTI',15,'3000','N'),
('KADIVAL KALLAPUR',16,'3000','D'),
('KAMATAGI',17,'2500','N'),
('RAMTHAL',18,'3000','N'),
('transport fee',19,'15000','N'),
('van fee',20,'4000','N'),
('uniform fee',21,'2000','N'),
('bus fees',22,'8000','N'),
('dance fee',23,'2000','N'),
('tuition fee',24,'5000','N'),
('school fee',25,'10000','N'),
('transport fee',26,'5000','N'),
('school fee',27,'10000','N'),
('test1',28,'100','N'),
('test2',29,'200','N'),
('test3',30,'300','N'),
('school fee',31,'12000','N'),
('school fees ',32,'12000','N'),
('pen',33,'100','N'),
('pencil',34,'50','N'),
('class fee',35,'5000','N'),
('application fee',36,'200','N'),
('book fees',37,'2000','N'),
('uniform fee',38,'2000','N'),
('book fees',39,'5000','N'),
('uniform fee',40,'5000','N'),
('application fee',41,'100','N'),
('application fee',42,'100','N'),
('school fees ',43,'10000','N'),
('uniform fee',44,'2000','N'),
('bus fees',45,'8000','N'),
('Medical Fees pri',46,'5','N'),
('Arrears',47,'0','N'),
('saddasd',48,'12.20','N'),
('test dec',49,'102.25','N'),
('test 2 dec',50,'50.25','N'),
('New Sub head',51,'200.50','N'),
('Final Sub Head',52,'20.20','N'),
('test final decimal value',53,'22.25','N'),
('dec 1',54,'100.50','N'),
('dec 2',55,'200.50','N'),
('dec 3',56,'300.40','N'),
('sdasdadasda',57,'121212','D'),
('Belt',58,'100','N'),
('id card',59,'75','N'),
('unform',60,'1000','N'),
('Enrollment fees',61,'10','N'),
('school imporvement fees',62,'20','N'),
('special sports fund',63,'20','N'),
('student welfare fund',64,'15','N'),
('teachers welfare fund',65,'15','N'),
('bavuta',66,'10','N'),
('Admission application fee',67,'00','N'),
('sports fee',68,'25','N'),
('VACHANALAY',69,'20','N'),
('Laboratory fee',70,'20','N'),
('Hearing fee',71,'10','N'),
('Painting ',72,'10','N'),
('Medical',73,'05','N'),
('Cleanliness',74,'15','N'),
('Career education fees',75,'10','N'),
(' DEVELOPMENT FEES ',76,'2000','N'),
('Enrollvement fee',77,'10','N'),
('School Impovement fees',78,'20','N'),
('special sports fund',79,'20','N'),
('student welfare fund',80,'15','N'),
('teachers welfare fund',81,'15','N'),
('teachers welfare fund',82,'15','N'),
('Bavuta',83,'10','N'),
('Admission application fee',84,'10','N'),
('sports fee',85,'25','N'),
('VACHANALAY',86,'20','N'),
('Laboratory fee',87,'20','N'),
('Hearing fee',88,'10','N'),
('Painting ',89,'10','N'),
('Medical',90,'05','N'),
('Cleanliness',91,'15','N'),
('Career education fees',92,'10','N'),
('DEVELOPMENT FEES',93,'2000','N'),
('Enrollvement fee',94,'10','N'),
('school impovement fees',95,'20','N'),
('school impovement fees',96,'20','D'),
('special sports fund',97,'20','N'),
('student welfare fund',98,'15','N'),
('teachers welfarw fund',99,'15','N'),
('Bavuta',100,'10','N'),
('DEVELOPMENT FEES',101,'2000','N'),
('School fees',102,'6000','N'),
('Enrollvellment fees ',103,'10','N'),
('School improvement fees ',104,'20','N'),
('Special sports fund',105,'20','N'),
('Student Welfare fund ',106,'15','N'),
('teachers welfare fund',107,'15','N'),
('Bavuta',108,'10','N'),
('Admission application fee',109,'00','N'),
('Sports fees ',110,'25','N'),
('VAACHANAALAYA',111,'20','N'),
('Laboratory',112,'20','N'),
('Hearing fee',113,'10','N'),
('Painting ',114,'10','N'),
('Science Association',115,'00','N'),
('Medical',116,'05','N'),
('Cleanliness',117,'15','N'),
('Examination fees',118,'00','N'),
('Associaton',119,'00','N'),
('Others',120,'00','N'),
('Career Education fees',121,'10','N'),
('DEVELOPMENT FEES',122,'2000','N'),
('SCHOOL FEES',123,'6000','N'),
('REGULAR UNIFORM',124,'420','N'),
('TRACK SUITE (YELLOW)',125,'400','N'),
('BELT',126,'30','N'),
('ID CARD',127,'60','N'),
('CHIKKAMAGI',128,'5500','N'),
('BOOK FEES',129,'1500','N'),
('SCHOOL FEES',130,'6000','N'),
('REGULAR UNIFORM',131,'420','N'),
('TRACK SUITE (YELLOW)',132,'370','N'),
('BELT',133,'30','N'),
('ID CARD',134,'60','N'),
('BOOK FEES ',135,'1500','N'),
('CHIKKAMAGI',136,'5500','N'),
('SCHOOL FEES',137,'6000','N'),
('UKG SCHOOL FEES',138,'6000','N'),
('CHIKKAMAGI',139,'550','N'),
('REGULAR UNIFORM',140,'420','N'),
('TRACK SUITE (YELLOW)',141,'400','N'),
('ID CARD',142,'60','N'),
('BELT',143,'30','D'),
('BOOK FEES',144,'1500','N'),
('Enrollment fee',145,'10','N'),
('school impovement fees',146,'20','N'),
('special sports fund',147,'20','D'),
('student welfare fund',148,'15','D'),
('teachers welfare fund',149,'15','D'),
('BAAVUTA',150,'10','D'),
('sports fee',151,'25','D'),
('VAACHANALAYA FEE',152,'20','D'),
('LABRORATORY FE',153,'20','D'),
('Enrollment fee',154,'10','D'),
('Enrollment fee',155,'10','D'),
('Enrollment fee',156,'10','N'),
('school impoveLment fees',157,'20','N'),
('special sports fund',158,'20','N'),
('student welfare fund',159,'15','N'),
('teachers welfare fund',160,'15','N'),
('BAAVUTA',161,'10','N'),
('sports fee',162,'25','N'),
('VAACHANALAYA FEE',163,'20','N'),
('Laboratory fee',164,'20','N'),
('Hearing fee',165,'10','N'),
('Painting ',166,'10','N'),
('MEDICAL',167,'05','N'),
('CLEANLINESS',168,'15','N'),
('CAREER EDUCATION FEE',169,'10','N'),
('DEVELOPMENT FEES',170,'3000','N'),
('DEVELOPMENT FEES',171,'3000','N'),
('DEVELOPMENT FEES',172,'2000','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 AUTO_INCREMENT=6 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 */;
INSERT INTO `subcategory` VALUES
(1,1,'SBI US SCHOOL',1,NULL),
(3,4,'test2',2,'ad'),
(4,5,'ka 25 7845',2,'van'),
(5,6,'tea - xyz',2,NULL);
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `tbladmin` VALUES
(1,'Admin','admin',8050482213,'k.raghu22132@gmail.com','f925916e2754e5e03f75dd58a5733251','2023-10-04 13:29:24');
/*!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 */;
INSERT INTO `transaction` VALUES
(0,1,0,1,'FEES COLLECTION',1000.00,'01','2023-01-16',1,NULL,NULL),
(0,1,4,1,'info',2000.00,'4574','2023-05-25',2,'meter 500002',NULL),
(0,1,5,1,'tea 5',50.00,'123','2023-06-15',2,'asdf adfjassjdf',NULL);
/*!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=103 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(76,'adminFees','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'Adminstudent','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732'),
(93,'123','c87c5a00de39b8fa3d9bdce1a89890c67480e3c47fe2dcbdcf4232d06809b3a2','b63dee4518ccd9b',NULL,'Teacher','123@rfwerwA'),
(94,'test1','b3410bef9fbd70fcb9c82b5f00970498bdef85a2538c1360485ef50314468d95','4fb2c5091b4c302',NULL,'Fees_Management','123456@Test'),
(95,'tch','d6e01778347d03dd64e3b3f8051114612e401048817298ddfb5ada4c7fd2a790','3ab6d0a07972545c',NULL,'Teacher','123456@Rr'),
(96,'SainiketanDwd','3791fae33b10e6539bc6b1ec62dddaef6ea23c200628815771d6ae15685b09ae','5577410785fef95',NULL,'Student_Management','Saidwd@123'),
(97,'ebjam','f4543010881d55ad491d16a5ea1a4cbe1b3b0b84695d743464866f52b30c8fc1','5786e0445ed2f34',NULL,'Student_Management','Ebjam@566'),
(98,'EBMHL','5fd0dab5569b0ffa24b29633f52a76084663ce73b290dcb1051a7a98baf63c2a','163df15c1b0c9fe1',NULL,'Student_Management','Ebmhl@357'),
(99,'DCSNP','60966f0802fe5197a1f2ec597741388e5d08143da2896dfe6dc483ab53a57eeb','36ad931045b4b9e4',NULL,'Student_Management','Dcsnp@680'),
(100,'SNKMS','a17316b09e0308b4b5d46e7ea9fa675bb318f88310e19d22c10d278e03c4d114','6d947aa510ff821a',NULL,'Student_Management','Snkms@852'),
(101,'SNENG','66b1096b6df81e091f1283b6d5e9e795440cba6fab7b92090e9ba35f86712895','5f7f74c92d93564a',NULL,'Student_Management','Sneng@560'),
(102,'SNCBSE','825fbca4ceea3fbadf725a9345151d050eb7be371838580af5838f043f84c224','3e0dec2058ede753',NULL,'Student_Management','Sncbse@700');
/*!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','Xjj6QD344jqSUVhqjGC2Sj5UcJGdCec7r5Psj9tsG0RWEGRhHo5cHJb6UuHI','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=155 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
('2022-07-12',2022,1,1,'Contra','SBI BANK -111-1111','SBI BANK -111-1111','Current Assets','Current Assets','600000','600000','Cash Deposit'),
('2023-05-23',NULL,2,1,'Recipt','TUITION FEES','SBI BANK -187-4187','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2023-05-23',2023,3,1,'Payment','SBI BANK -187-4187','PETROL','Current Assets','Expenditure','2500','2500','78414asd asdfa df'),
('2023-05-24',NULL,4,2,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-05-25',NULL,5,3,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-05-30',NULL,6,4,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-05-30',NULL,7,5,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-05-30',NULL,8,6,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','450','450','Fees Collected'),
('2023-06-14',NULL,9,7,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-06-14',NULL,10,8,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-06-14',NULL,11,9,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2023-06-14',2023,12,2,'Payment','SBI BANK -111-1111','test 100','Current Assets','Income/Revenue','2500','2500','sdDSa'),
('2023-06-15',NULL,13,10,'Recipt','TUITION FEES','SBI BANK -187-4187','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-15',NULL,14,11,'Recipt','computer Fees','SBI BANK -187-4187','Income/Revenue','Current Assets','400','400','Fees Collected'),
('2023-06-15',NULL,15,12,'Recipt','Uniform fees','SBI BANK -187-4187','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2023-06-15',NULL,16,13,'Recipt','test 100','SBI BANK -187-4187','Income/Revenue','Current Assets','600','600','Fees Collected'),
('2023-06-15',NULL,17,14,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2023-06-15',NULL,18,15,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-06-15',NULL,19,16,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','450','450','Fees Collected'),
('2023-06-16',NULL,20,17,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-06-16',NULL,21,18,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2023-06-16',NULL,22,19,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-07-01',NULL,23,20,'Recipt','van fee','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-07-24',NULL,24,21,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','30000','30000','Fees Collected'),
('2023-09-01',NULL,25,22,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-09-01',NULL,26,23,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-09-01',NULL,27,24,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2023-09-08',NULL,28,25,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','9500','9500','Fees Collected'),
('2023-09-08',NULL,29,26,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-09-25',NULL,30,27,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','7500','7500','Fees Collected'),
('2023-09-25',NULL,31,28,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-10-17',NULL,32,29,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2023-10-17',NULL,33,30,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','18000','18000','Fees Collected'),
('2023-10-17',NULL,34,31,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2023-10-17',NULL,35,32,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','900','900','Fees Collected'),
('2023-11-05',NULL,36,33,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-11-05',NULL,37,34,'Recipt','van fee','Cash','Income/Revenue','Current Assets','10000','10000','Fees Collected'),
('2023-11-08',NULL,38,35,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-12-07',NULL,39,36,'Recipt','van fee','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-12-07',NULL,40,37,'Recipt','uniform fee','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2023-12-09',NULL,41,38,'Recipt','test1','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-12-09',NULL,42,39,'Recipt','test2','Cash','Income/Revenue','Current Assets','50','50','Fees Collected'),
('2023-12-09',NULL,43,40,'Recipt','test3','Cash','Income/Revenue','Current Assets','50','50','Fees Collected'),
('2023-12-14',NULL,44,41,'Recipt','van fee','Cash','Income/Revenue','Current Assets','20000','20000','Fees Collected'),
('2023-12-14',NULL,45,42,'Recipt','uniform fee','Cash','Income/Revenue','Current Assets','8000','8000','Fees Collected'),
('2023-12-14',NULL,46,43,'Recipt','sports fee','Cash','Income/Revenue','Current Assets','150','150','Fees Collected'),
('2023-12-14',NULL,47,44,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','1350','1350','Fees Collected'),
('2023-12-14',NULL,48,45,'Recipt','test 100','Cash','Income/Revenue','Current Assets','1200','1200','Fees Collected'),
('2023-12-14',NULL,49,46,'Recipt','test1','Cash','Income/Revenue','Current Assets','1400','1400','Fees Collected'),
('2023-12-14',NULL,50,47,'Recipt','test2','Cash','Income/Revenue','Current Assets','2800','2800','Fees Collected'),
('2023-12-14',NULL,51,48,'Recipt','test3','Cash','Income/Revenue','Current Assets','4200','4200','Fees Collected'),
('2023-12-14',NULL,52,49,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-12-14',NULL,53,50,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2023-12-14',NULL,54,51,'Recipt','Uniform fees','Cash','Income/Revenue','Current Assets','2600','2600','Fees Collected'),
('2023-12-14',NULL,55,52,'Recipt','pen','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-12-14',NULL,56,53,'Recipt','pencil','Cash','Income/Revenue','Current Assets','50','50','Fees Collected'),
('2023-12-14',NULL,57,54,'Recipt','class fee','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2023-12-14',NULL,58,55,'Recipt','application fee','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2023-12-15',NULL,59,56,'Recipt','book fees','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-12-15',NULL,60,57,'Recipt','uniform fee','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-12-15',NULL,61,58,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2023-12-24',NULL,62,59,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2023-12-24',NULL,63,60,'Recipt','transport fee','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2023-12-30',NULL,64,61,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2023-12-30',NULL,65,62,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-01-01',NULL,66,63,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-01-02',NULL,67,64,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-01-07',NULL,68,65,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-01-08',NULL,69,66,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','650000','650000','Fees Collected'),
('2024-01-08',NULL,70,67,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','650000','650000','Fees Collected'),
('2024-01-08',NULL,71,68,'Recipt','Uniform fees','Cash','Income/Revenue','Current Assets','2600','2600','Fees Collected'),
('2024-01-08',NULL,72,69,'Recipt','test 100','Cash','Income/Revenue','Current Assets','600','600','Fees Collected'),
('2024-02-07',NULL,73,70,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','15999','15999','Fees Collected'),
('2024-02-07',NULL,74,71,'Recipt','sports fee','Cash','Income/Revenue','Current Assets','250','250','Fees Collected'),
('2024-02-07',NULL,75,72,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','450','450','Fees Collected'),
('2024-02-07',NULL,76,73,'Recipt','test 100','Cash','Income/Revenue','Current Assets','600','600','Fees Collected'),
('2024-02-07',NULL,77,74,'Recipt','transport fee','Cash','Income/Revenue','Current Assets','11000','11000','Fees Collected'),
('2024-03-07',NULL,78,75,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-03-17',NULL,79,76,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','22500','22500','Fees Collected'),
('2024-03-17',NULL,80,77,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-03-17',NULL,81,78,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2024-04-01',NULL,82,79,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-04-03',NULL,83,80,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','21000','21000','Fees Collected'),
('2024-04-07',NULL,84,81,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-04-16',NULL,85,82,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-04-16',NULL,86,83,'Recipt','transport fee','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2024-05-05',NULL,87,84,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-05-06',NULL,88,85,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','16000','16000','Fees Collected'),
('2024-05-22',NULL,89,86,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-05-22',NULL,90,87,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','6000','6000','Fees Collected'),
('2024-07-03',NULL,91,88,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','14000','14000','Fees Collected'),
('2024-09-21',NULL,92,89,'Recipt','van fee','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2024-09-21',NULL,93,90,'Recipt','uniform fee','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-09-21',NULL,94,91,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-30',NULL,95,92,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500','6500','Fees Collected'),
('2024-09-30',NULL,96,93,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2024-09-30',NULL,97,94,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','450','450','Fees Collected'),
('2024-10-26',NULL,98,95,'Recipt','test dec','Cash','Income/Revenue','Current Assets','103.00','103.00','Fees Collected'),
('2024-10-26',NULL,99,96,'Recipt','test 2 dec','Cash','Income/Revenue','Current Assets','50.00','50.00','Fees Collected'),
('2024-10-26',NULL,100,97,'Recipt','New Sub head','Cash','Income/Revenue','Current Assets','200.50','200.50','Fees Collected'),
('2024-10-26',NULL,101,98,'Recipt','Final Sub Head','Cash','Income/Revenue','Current Assets','20.20','20.20','Fees Collected'),
('2024-10-31',NULL,102,99,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','13000','13000','Fees Collected'),
('2024-10-31',NULL,103,100,'Recipt','test final decimal value','Cash','Income/Revenue','Current Assets','44.35','44.35','Fees Collected'),
('2024-10-31',NULL,104,101,'Recipt','LAXMESHWARA','Cash','Income/Revenue','Current Assets','6000.00','6000.00','Fees Collected'),
('2024-10-31',NULL,105,102,'Recipt','dec 1','Cash','Income/Revenue','Current Assets','200.2','200.2','Fees Collected'),
('2024-10-31',NULL,106,103,'Recipt','dec 2','Cash','Income/Revenue','Current Assets','400.7','400.7','Fees Collected'),
('2024-10-31',NULL,107,104,'Recipt','dec 3','Cash','Income/Revenue','Current Assets','550.5','550.5','Fees Collected'),
('2025-01-22',NULL,108,105,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','7100','7100','Fees Collected'),
('2025-01-30',NULL,109,106,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2025-01-30',NULL,110,107,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100.00','100.00','Fees Collected'),
('2025-01-30',NULL,111,108,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','100','100','Fees Collected'),
('2025-03-01',NULL,112,109,'Recipt','Enrollment fees','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,113,110,'Recipt','school imporvement fees','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,114,111,'Recipt','special sports fund','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,115,112,'Recipt','student welfare fund','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,116,113,'Recipt','teachers welfare fund','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,117,114,'Recipt','bavuta','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,118,115,'Recipt','Admission application fee','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,119,116,'Recipt','sports fee','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,120,117,'Recipt','VACHANALAY','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,121,118,'Recipt','Laboratory fee','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,122,119,'Recipt','Hearing fee','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,123,120,'Recipt','Painting ','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,124,121,'Recipt','Medical','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,125,122,'Recipt','Cleanliness','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,126,123,'Recipt','Career education fees','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,127,124,'Recipt',' DEVELOPMENT FEES ','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-01',NULL,128,125,'Recipt','DEVELOPMENT FEES','Cash','Income/Revenue','Current Assets','1795','1795','Fees Collected'),
('2025-03-07',NULL,129,126,'Recipt','Enrollment fees','Cash','Income/Revenue','Current Assets','10','10','Fees Collected'),
('2025-03-07',NULL,130,127,'Recipt','school imporvement fees','Cash','Income/Revenue','Current Assets','20','20','Fees Collected'),
('2025-03-07',NULL,131,128,'Recipt','special sports fund','Cash','Income/Revenue','Current Assets','20','20','Fees Collected'),
('2025-03-07',NULL,132,129,'Recipt','student welfare fund','Cash','Income/Revenue','Current Assets','15','15','Fees Collected'),
('2025-03-07',NULL,133,130,'Recipt','teachers welfare fund','Cash','Income/Revenue','Current Assets','15','15','Fees Collected'),
('2025-03-07',NULL,134,131,'Recipt','bavuta','Cash','Income/Revenue','Current Assets','10','10','Fees Collected'),
('2025-03-07',NULL,135,132,'Recipt','Admission application fee','Cash','Income/Revenue','Current Assets','0','0','Fees Collected'),
('2025-03-07',NULL,136,133,'Recipt','sports fee','Cash','Income/Revenue','Current Assets','25','25','Fees Collected'),
('2025-03-07',NULL,137,134,'Recipt','VACHANALAY','Cash','Income/Revenue','Current Assets','20','20','Fees Collected'),
('2025-03-07',NULL,138,135,'Recipt','Laboratory fee','Cash','Income/Revenue','Current Assets','20','20','Fees Collected'),
('2025-03-07',NULL,139,136,'Recipt','Hearing fee','Cash','Income/Revenue','Current Assets','10','10','Fees Collected'),
('2025-03-07',NULL,140,137,'Recipt','Painting ','Cash','Income/Revenue','Current Assets','10','10','Fees Collected'),
('2025-03-07',NULL,141,138,'Recipt','Medical','Cash','Income/Revenue','Current Assets','5','5','Fees Collected'),
('2025-03-07',NULL,142,139,'Recipt','Cleanliness','Cash','Income/Revenue','Current Assets','15','15','Fees Collected'),
('2025-03-07',NULL,143,140,'Recipt','Career education fees','Cash','Income/Revenue','Current Assets','10','10','Fees Collected'),
('2025-03-07',NULL,144,141,'Recipt','DEVELOPMENT FEES','Cash','Income/Revenue','Current Assets','1795','1795','Fees Collected'),
('2025-03-10',NULL,145,142,'Recipt',' DEVELOPMENT FEES ','Cash','Income/Revenue','Current Assets','1795','1795','Fees Collected'),
('2025-03-17',NULL,146,143,'Recipt','TUITION FEES','SBI BANK -187-4187','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-03-26',NULL,147,144,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500.00','6500.00','Fees Collected'),
('2025-03-26',NULL,148,145,'Recipt','application Fees','Cash','Income/Revenue','Current Assets','100.00','100.00','Fees Collected'),
('2025-03-26',NULL,149,146,'Recipt','computer Fees','Cash','Income/Revenue','Current Assets','450.00','450.00','Fees Collected'),
('2025-03-26',NULL,150,147,'Recipt','transport fee','Cash','Income/Revenue','Current Assets','10000.00','10000.00','Fees Collected'),
('2025-03-28',NULL,151,148,'Recipt','TUITION FEES','SBI BANK -187-4187','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2025-04-12',NULL,152,149,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500.00','6500.00','Fees Collected'),
('2025-05-06',NULL,153,150,'Recipt','TUITION FEES','Cash','Income/Revenue','Current Assets','6500.00','6500.00','Fees Collected'),
('2025-05-08',2025,154,3,'Payment','Canara Bank-8412','Keb bill 800','Current Assets','Expenditure','8000','8000','Keb bill paid of April Month');
/*!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:46