|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.217.3 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/admin/backup/SNENG/../dpdwd/../SHSK/ |
| [ 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_SHSK_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=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receipt_Head`
--
LOCK TABLES `Receipt_Head` WRITE;
/*!40000 ALTER TABLE `Receipt_Head` DISABLE KEYS */;
INSERT INTO `Receipt_Head` VALUES
(1,'HIGH SCHOOL','Shri Huchcheshwar High School','Kamatagi. - 587120',''),
(2,'CLOG ','Shri. Huchcheshwar pu college ','Kamatagi. - 587120',''),
(8,'S.H.V.V.S','S.H.V.V.S','Kamatagi. - 587120','');
/*!40000 ALTER TABLE `Receipt_Head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`accountnumber` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account`
--
LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_accounts`
--
DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`passwd` varchar(50) NOT NULL,
`admin_type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_accounts`
--
LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bankaccounts`
--
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Bank_Name` varchar(1000) NOT NULL,
`IFSC` varchar(1000) NOT NULL,
`Account_Number` varchar(1000) NOT NULL,
`AccountHolderName` varchar(1000) NOT NULL,
`PayuKey` bigint(20) NOT NULL,
`SaltKey` bigint(20) NOT NULL,
`MerchantKey` bigint(20) NOT NULL,
`AccountType` varchar(1000) NOT NULL,
`Link` varchar(10000) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'HUCHESHWAR BANK','','0000','H M SHHS',0,0,0,'','');
/*!40000 ALTER TABLE `bankaccounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `budget`
--
DROP TABLE IF EXISTS `budget`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `budget` (
`budgetid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fromdate` date NOT NULL,
`todate` date DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`budgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `budget`
--
LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`categoryid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`type` int(11) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `class`
--
DROP TABLE IF EXISTS `class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class` (
`Name` varchar(100) NOT NULL,
`Cls_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Cls_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 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
('10 ',1,NULL),
('Puc II Year',3,NULL),
('PUC',4,NULL);
/*!40000 ALTER TABLE `class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commission`
--
DROP TABLE IF EXISTS `commission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commission` (
`Commission` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commission`
--
LOCK TABLES `commission` WRITE;
/*!40000 ALTER TABLE `commission` DISABLE KEYS */;
/*!40000 ALTER TABLE `commission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
`id1` int(10) NOT NULL AUTO_INCREMENT,
`f_name` varchar(25) NOT NULL,
`l_name` varchar(25) NOT NULL,
`gender` varchar(6) NOT NULL,
`address` varchar(100) DEFAULT NULL,
`city` varchar(15) NOT NULL,
`state` varchar(30) NOT NULL,
`phone` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`date_of_birth` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customers`
--
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `division`
--
DROP TABLE IF EXISTS `division`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `division` (
`Name` varchar(100) NOT NULL,
`Div_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Div_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 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),
('Kala',3,NULL),
('EDUCATION',4,NULL),
('Commerce',5,NULL);
/*!40000 ALTER TABLE `division` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goals`
--
DROP TABLE IF EXISTS `goals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goals` (
`goalsid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`accountid` int(5) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`deposit` decimal(10,2) NOT NULL,
`deadline` date NOT NULL,
PRIMARY KEY (`goalsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goals`
--
LOCK TABLES `goals` WRITE;
/*!40000 ALTER TABLE `goals` DISABLE KEYS */;
/*!40000 ALTER TABLE `goals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `head`
--
DROP TABLE IF EXISTS `head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `head` (
`Name` varchar(1000) NOT NULL,
`Head_Id` int(11) NOT NULL AUTO_INCREMENT,
`SubHeads` varchar(1000) NOT NULL,
`Last_Date` date NOT NULL,
`One_Time_Payment` varchar(100) NOT NULL,
`Fine_Amount` varchar(100) NOT NULL,
`Bank_Code` varchar(10) NOT NULL,
`ReciptName` varchar(1000) NOT NULL,
PRIMARY KEY (`Head_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 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
('DONATION',1,'1','2026-06-01','No','0','1','SCHL'),
('Donation-',2,'4','2026-06-01','No','0','1','CLOG'),
('DONATION ....',3,'5','2026-06-01','No','0','1','SCHL');
/*!40000 ALTER TABLE `head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ledger`
--
DROP TABLE IF EXISTS `ledger`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ledger` (
`Name` varchar(1000) NOT NULL,
`Ledger_Id` int(11) NOT NULL AUTO_INCREMENT,
`Type` varchar(1000) NOT NULL,
PRIMARY KEY (`Ledger_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 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
('DONATION',1,'Income/Revenue'),
('HUCHESHWAR BANK-0000',2,'Current Assets'),
('DONATION',3,'Income/Revenue'),
('SPORTS FEES ',4,'Income/Revenue'),
('DONATION-',5,'Income/Revenue'),
('DONATION',6,'Income/Revenue'),
('Donation --',7,'Income/Revenue');
/*!40000 ALTER TABLE `ledger` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `onlinetemp`
--
DROP TABLE IF EXISTS `onlinetemp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `onlinetemp` (
`Fees_id` bigint(20) NOT NULL AUTO_INCREMENT,
`TID` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL,
`Head_Id` varchar(200) NOT NULL,
`Subhead_Ids` varchar(1000) NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) DEFAULT NULL,
`DateNumber` varchar(1000) NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`Status` varchar(1000) NOT NULL,
`user` varchar(1000) NOT NULL,
PRIMARY KEY (`Fees_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `onlinetemp`
--
LOCK TABLES `onlinetemp` WRITE;
/*!40000 ALTER TABLE `onlinetemp` DISABLE KEYS */;
/*!40000 ALTER TABLE `onlinetemp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees`
--
DROP TABLE IF EXISTS `paid_fees`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees` (
`Fees_id` bigint(20) NOT NULL AUTO_INCREMENT,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) NOT NULL,
`Recp_Book_No` varchar(500) NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) NOT NULL,
`Subhead_Ids` varchar(1000) NOT NULL,
`Sub_Amounts` varchar(1000) NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) DEFAULT NULL,
`DateNumber` varchar(1000) NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
PRIMARY KEY (`Fees_id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 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,16,'SCHL-1',1,'SCHL','SCHL-1',1,'3','/5','/500','2025-05-15','Cash','',0,0,500,500,1,'adminFees507',NULL),
(2,290,'CLOG-1',1,'CLOG','CLOG-1',1,'2','/4','/300','2025-05-17','Cash','',0,0,300,300,1,'adminFees507',NULL),
(3,291,'CLOG-2',2,'CLOG','CLOG-2',2,'2','/4','/300','2025-05-17','Cash','',0,0,300,300,1,'adminFees507',NULL),
(4,184,'SCHL-2',2,'SCHL','SCHL-2',2,'3','/5','/500','2025-05-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(5,111,'SCHL-3',3,'SCHL','SCHL-3',3,'3','/5','/500','2025-05-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(6,116,'SCHL-4',4,'SCHL','SCHL-4',4,'3','/5','/500','2025-05-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(7,86,'SCHL-5',5,'SCHL','SCHL-5',5,'3','/5','/500','2025-05-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(8,190,'SCHL-6',6,'SCHL','SCHL-6',6,'3','/5','/500','2025-05-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(9,70,'SCHL-7',7,'SCHL','SCHL-7',7,'3','/5','/500','2025-05-19','Cash','',0,0,500,500,1,'adminFees507',NULL),
(10,67,'SCHL-8',8,'SCHL','SCHL-8',8,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(11,171,'SCHL-9',9,'SCHL','SCHL-9',9,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(12,177,'SCHL-10',10,'SCHL','SCHL-10',10,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(13,74,'SCHL-11',11,'SCHL','SCHL-11',11,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(14,76,'SCHL-12',12,'SCHL','SCHL-12',12,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(15,50,'SCHL-13',13,'SCHL','SCHL-13',13,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(16,85,'SCHL-14',14,'SCHL','SCHL-14',14,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(17,12,'SCHL-15',15,'SCHL','SCHL-15',15,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(18,68,'SCHL-16',16,'SCHL','SCHL-16',16,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(19,122,'SCHL-17',17,'SCHL','SCHL-17',17,'3','/5','/500','2025-05-20','Cash','',0,0,500,500,1,'adminFees507',NULL),
(20,58,'SCHL-18',18,'SCHL','SCHL-18',18,'3','/5','/500','2025-05-21','Cash','',0,0,500,500,1,'adminFees507',NULL),
(21,25,'SCHL-19',19,'SCHL','SCHL-19',19,'3','/5','/500','2025-05-21','Cash','',0,0,500,500,1,'adminFees507',NULL),
(22,180,'SCHL-20',20,'SCHL','SCHL-20',20,'3','/5','/500','2025-05-21','Cash','',0,0,500,500,1,'adminFees507',NULL),
(23,173,'SCHL-21',21,'SCHL','SCHL-21',21,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(24,175,'SCHL-22',22,'SCHL','SCHL-22',22,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(25,5,'SCHL-23',23,'SCHL','SCHL-23',23,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(26,93,'SCHL-24',24,'SCHL','SCHL-24',24,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(27,28,'SCHL-25',25,'SCHL','SCHL-25',25,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(28,47,'SCHL-26',26,'SCHL','SCHL-26',26,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(29,185,'SCHL-27',27,'SCHL','SCHL-27',27,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(30,81,'SCHL-28',28,'SCHL','SCHL-28',28,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(31,183,'SCHL-29',29,'SCHL','SCHL-29',29,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(32,94,'SCHL-30',30,'SCHL','SCHL-30',30,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(33,96,'SCHL-31',31,'SCHL','SCHL-31',31,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(34,98,'SCHL-32',32,'SCHL','SCHL-32',32,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(35,147,'SCHL-33',33,'SCHL','SCHL-33',33,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(36,193,'SCHL-34',34,'SCHL','SCHL-34',34,'3','/5','/500','2025-05-22','Cash','',0,0,500,500,1,'adminFees507',NULL),
(37,130,'SCHL-35',35,'SCHL','SCHL-35',35,'3','/5','/500','2025-05-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(38,149,'SCHL-36',36,'SCHL','SCHL-36',36,'3','/5','/500','2025-05-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(39,34,'SCHL-37',37,'SCHL','SCHL-37',37,'3','/5','/500','2025-05-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(40,23,'SCHL-38',38,'SCHL','SCHL-38',38,'3','/5','/500','2025-05-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(41,128,'SCHL-39',39,'SCHL','SCHL-39',39,'3','/5','/500','2025-05-26','Cash','',0,0,500,500,1,'adminFees507',NULL),
(42,131,'SCHL-40',40,'SCHL','SCHL-40',40,'3','/5','/500','2025-05-27','Cash','',0,0,500,500,1,'adminFees507',NULL),
(43,182,'SCHL-41',41,'SCHL','SCHL-41',41,'3','/5','/500','2025-05-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(44,292,'SCHL-42',42,'SCHL','SCHL-42',42,'1','/1','/100','2025-05-28','Cash','',0,0,100,100,1,'adminFees507',NULL),
(45,17,'SCHL-43',43,'SCHL','SCHL-43',43,'3','/5','/500','2025-05-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(46,82,'SCHL-44',44,'SCHL','SCHL-44',44,'3','/5','/500','2025-05-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(47,109,'SCHL-45',45,'SCHL','SCHL-45',45,'3','/5','/500','2025-05-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(48,64,'SCHL-46',46,'SCHL','SCHL-46',46,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(49,46,'SCHL-47',47,'SCHL','SCHL-47',47,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(50,51,'SCHL-48',48,'SCHL','SCHL-48',48,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(51,157,'SCHL-49',49,'SCHL','SCHL-49',49,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(52,170,'SCHL-50',50,'SCHL','SCHL-50',50,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(53,153,'SCHL-51',51,'SCHL','SCHL-51',51,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(54,44,'SCHL-52',52,'SCHL','SCHL-52',52,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(55,73,'SCHL-53',53,'SCHL','SCHL-53',53,'3','/5','/500','2025-05-29','Cash','',0,0,500,500,1,'adminFees507',NULL),
(56,117,'SCHL-54',54,'SCHL','SCHL-54',54,'3','/5','/500','2025-05-30','Cash','',0,0,500,500,1,'adminFees507',NULL),
(57,196,'SCHL-55',55,'SCHL','SCHL-55',55,'3','/5','/500','2025-05-30','Cash','',0,0,500,500,1,'adminFees507',NULL),
(58,164,'SCHL-56',56,'SCHL','SCHL-56',56,'3','/5','/500','2025-05-30','Cash','',0,0,500,500,1,'adminFees507',NULL),
(59,108,'SCHL-57',57,'SCHL','SCHL-57',57,'3','/5','/500','2025-05-30','Cash','',0,0,500,500,1,'adminFees507',NULL),
(60,69,'SCHL-58',58,'SCHL','SCHL-58',58,'3','/5','/500','2025-05-31','Cash','',0,0,500,500,1,'adminFees507',NULL),
(61,135,'SCHL-59',59,'SCHL','SCHL-59',59,'3','/5','/500','2025-05-31','Cash','',0,0,500,500,1,'adminFees507',NULL),
(62,176,'SCHL-60',60,'SCHL','SCHL-60',60,'3','/5','/500','2025-06-02','Cash','',0,0,500,500,1,'adminFees507',NULL),
(63,188,'SCHL-61',61,'SCHL','SCHL-61',61,'3','/5','/500','2025-06-02','Cash','',0,0,500,500,1,'adminFees507',NULL),
(64,281,'SCHL-62',62,'SCHL','SCHL-62',62,'1','/1','/100','2025-06-02','Cash','',0,0,100,100,1,'adminFees507',NULL),
(65,91,'SCHL-63',63,'SCHL','SCHL-63',63,'3','/5','/500','2025-06-02','Cash','',0,0,500,500,1,'adminFees507',NULL),
(66,155,'SCHL-64',64,'SCHL','SCHL-64',64,'3','/5','/500','2025-06-02','Cash','',0,0,500,500,1,'adminFees507',NULL),
(67,65,'SCHL-65',65,'SCHL','SCHL-65',65,'3','/5','/500','2025-06-05','Cash','',0,0,500,500,1,'adminFees507',NULL),
(68,95,'SCHL-66',66,'SCHL','SCHL-66',66,'3','/5','/500','2025-06-05','Cash','',0,0,500,500,1,'adminFees507',NULL),
(69,169,'SCHL-67',67,'SCHL','SCHL-67',67,'3','/5','/500','2025-06-05','Cash','',0,0,500,500,1,'adminFees507',NULL),
(70,88,'SCHL-68',68,'SCHL','SCHL-68',68,'3','/5','/500','2025-06-06','Cash','',0,0,500,500,1,'adminFees507',NULL),
(71,118,'SCHL-69',69,'SCHL','SCHL-69',69,'3','/5','/500','2025-06-06','Cash','',0,0,500,500,1,'adminFees507',NULL),
(72,61,'SCHL-70',70,'SCHL','SCHL-70',70,'3','/5','/500','2025-06-06','Cash','',0,0,500,500,1,'adminFees507',NULL),
(73,152,'SCHL-71',71,'SCHL','SCHL-71',71,'3','/5','/500','2025-06-06','Cash','',0,0,500,500,1,'adminFees507',NULL),
(74,129,'SCHL-72',72,'SCHL','SCHL-72',72,'3','/5','/500','2025-06-06','Cash','',0,0,500,500,1,'adminFees507',NULL),
(75,97,'SCHL-73',73,'SCHL','SCHL-73',73,'3','/5','/500','2025-06-09','Cash','',0,0,500,500,1,'adminFees507',NULL),
(76,293,'CLOG-3',3,'CLOG','CLOG-3',3,'2','/4','/200','2025-06-09','Cash','',0,0,200,200,1,'adminFees507',NULL),
(77,156,'SCHL-74',74,'SCHL','SCHL-74',74,'3','/5','/500','2025-06-09','Cash','',0,0,500,500,1,'adminFees507',NULL),
(78,92,'SCHL-75',75,'SCHL','SCHL-75',75,'3','/5','/500','2025-06-09','Cash','',0,0,500,500,1,'adminFees507',NULL),
(79,103,'SCHL-76',76,'SCHL','SCHL-76',76,'3','/5','/500','2025-06-10','Cash','',0,0,500,500,1,'adminFees507',NULL),
(80,89,'SCHL-77',77,'SCHL','SCHL-77',77,'3','/5','/400','2025-06-10','Cash','',0,0,400,400,1,'adminFees507',NULL),
(81,162,'SCHL-78',78,'SCHL','SCHL-78',78,'3','/5','/500','2025-06-10','Cash','',0,0,500,500,1,'adminFees507',NULL),
(82,26,'SCHL-79',79,'SCHL','SCHL-79',79,'3','/5','/500','2025-06-12','Cash','',0,0,500,500,1,'adminFees507',NULL),
(83,1,'SCHL-80',80,'SCHL','SCHL-80',80,'3','/5','/500','2025-06-13','Cash','',0,0,500,500,1,'adminFees507',NULL),
(84,191,'SCHL-81',81,'SCHL','SCHL-81',81,'3','/5','/500','2025-06-13','Cash','',0,0,500,500,1,'adminFees507',NULL),
(85,158,'SCHL-82',82,'SCHL','SCHL-82',82,'3','/5','/500','2025-06-14','Cash','',0,0,500,500,1,'adminFees507',NULL),
(86,104,'SCHL-83',83,'SCHL','SCHL-83',83,'3','/5','/500','2025-06-14','Cash','',0,0,500,500,1,'adminFees507',NULL),
(87,84,'SCHL-84',84,'SCHL','SCHL-84',84,'3','/5','/500','2025-06-16','Cash','',0,0,500,500,1,'adminFees507',NULL),
(88,150,'SCHL-85',85,'SCHL','SCHL-85',85,'3','/5','/500','2025-06-16','Cash','',0,0,500,500,1,'adminFees507',NULL),
(89,24,'SCHL-86',86,'SCHL','SCHL-86',86,'3','/5','/500','2025-06-16','Cash','',0,0,500,500,1,'adminFees507',NULL),
(91,43,'SCHL-87',87,'SCHL','SCHL-87',87,'3','/5','/500','2025-06-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(92,63,'SCHL-88',88,'SCHL','SCHL-88',88,'3','/5','/500','2025-06-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(93,145,'SCHL-89',89,'SCHL','SCHL-89',89,'3','/5','/500','2025-06-17','Cash','',0,0,500,500,1,'adminFees507',NULL),
(94,38,'SCHL-90',90,'SCHL','SCHL-90',90,'3','/5','/500','2025-06-18','Cash','',0,0,500,500,1,'adminFees507',NULL),
(95,66,'SCHL-91',91,'SCHL','SCHL-91',91,'3','/5','/500','2025-06-19','Cash','',0,0,500,500,1,'adminFees507',NULL),
(96,141,'SCHL-92',92,'SCHL','SCHL-92',92,'3','/5','/500','2025-06-19','Cash','',0,0,500,500,1,'adminFees507',NULL),
(97,3,'SCHL-93',93,'SCHL','SCHL-93',93,'3','/5','/300','2025-06-19','Cash','',0,0,300,300,1,'adminFees507',NULL),
(98,40,'SCHL-94',94,'SCHL','SCHL-94',94,'3','/5','/500','2025-06-21','Cash','',0,0,500,500,1,'adminFees507',NULL),
(99,48,'SCHL-95',95,'SCHL','SCHL-95',95,'3','/5','/500','2025-06-21','Cash','',0,0,500,500,1,'adminFees507',NULL),
(100,167,'SCHL-96',96,'SCHL','SCHL-96',96,'3','/5','/500','2025-06-23','Cash','',0,0,500,500,1,'adminFees507',NULL),
(101,100,'SCHL-97',97,'SCHL','SCHL-97',97,'3','/5','/500','2025-06-23','Cash','',0,0,500,500,1,'adminFees507',NULL),
(102,31,'SCHL-98',98,'SCHL','SCHL-98',98,'3','/5','/500','2025-06-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(103,2,'SCHL-99',99,'SCHL','SCHL-99',99,'3','/5','/500','2025-06-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(104,139,'SCHL-100',100,'SCHL','SCHL-100',100,'3','/5','/500','2025-06-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(105,140,'SCHL-101',101,'SCHL','SCHL-101',101,'3','/5','/500','2025-06-24','Cash','',0,0,500,500,1,'adminFees507',NULL),
(106,168,'SCHL-102',102,'SCHL','SCHL-102',102,'3','/5','/500','2025-06-26','Cash','',0,0,500,500,1,'adminFees507',NULL),
(107,148,'SCHL-103',103,'SCHL','SCHL-103',103,'3','/5','/500','2025-06-27','Cash','',0,0,500,500,1,'adminFees507',NULL),
(108,30,'SCHL-104',104,'SCHL','SCHL-104',104,'3','/5','/500','2025-06-27','Cash','',0,0,500,500,1,'adminFees507',NULL),
(109,146,'SCHL-105',105,'SCHL','SCHL-105',105,'3','/5','/500','2025-06-27','Cash','',0,0,500,500,1,'adminFees507',NULL),
(110,178,'SCHL-106',106,'SCHL','SCHL-106',106,'3','/5','/500','2025-06-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(111,18,'SCHL-107',107,'SCHL','SCHL-107',107,'3','/5','/500','2025-06-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(112,60,'SCHL-108',108,'SCHL','SCHL-108',108,'3','/5','/500','2025-06-28','Cash','',0,0,500,500,1,'adminFees507',NULL),
(113,8,'SCHL-109',109,'SCHL','SCHL-109',109,'3','/5','/500','2025-06-30','Cash','',0,0,500,500,1,'adminFees507',NULL),
(114,107,'SCHL-110',110,'SCHL','SCHL-110',110,'3','/5','/400','2025-07-01','Cash','',0,0,400,400,1,'adminFees507',NULL),
(116,142,'SCHL-111',111,'SCHL','SCHL-111',111,'3','/5','/400','2025-07-01','Cash','',0,0,400,400,1,'adminFees507',NULL),
(117,294,'CLOG-4',4,'CLOG','CLOG-4',4,'2','/4','/300','2025-07-01','Cash','',0,0,300,300,1,'adminFees507',NULL),
(118,195,'SCHL-112',112,'SCHL','SCHL-112',112,'3','/5','/500','2025-07-03','Cash','',0,0,500,500,1,'adminFees507',NULL),
(119,154,'SCHL-113',113,'SCHL','SCHL-113',113,'3','/5','/500','2025-07-07','Cash','',0,0,500,500,1,'adminFees507',NULL),
(120,207,'CLOG-5',5,'CLOG','CLOG-5',5,'2','/4','/300','2025-07-07','Cash','',0,0,300,300,1,'adminFees507',NULL),
(121,37,'SCHL-114',114,'SCHL','SCHL-114',114,'3','/5','/500','2025-07-08','Cash','',0,0,500,500,1,'adminFees507',NULL),
(123,295,'CLOG-6',6,'CLOG','CLOG-6',6,'2','/4','/200','2025-07-11','Cash','',0,0,200,200,1,'adminFees507',NULL),
(124,296,'CLOG-7',7,'CLOG','CLOG-7',7,'2','/4','/200','2025-07-11','Cash','',0,0,200,200,1,'adminFees507',NULL),
(126,297,'CLOG-8',8,'CLOG','CLOG-8',8,'2','/4','/200','2025-07-14','Cash','',0,0,200,200,1,'adminFees507',NULL),
(127,19,'SCHL-115',115,'SCHL','SCHL-115',115,'3','/5','/500','2025-07-14','Cash','',0,0,500,500,1,'adminFees507',NULL);
/*!40000 ALTER TABLE `paid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees_delete`
--
DROP TABLE IF EXISTS `paid_fees_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees_delete` (
`Fees_id` bigint(20) NOT NULL DEFAULT 0,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_No` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Subhead_Ids` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Sub_Amounts` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`DateNumber` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Message` varchar(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees_delete`
--
LOCK TABLES `paid_fees_delete` WRITE;
/*!40000 ALTER TABLE `paid_fees_delete` DISABLE KEYS */;
INSERT INTO `paid_fees_delete` VALUES
(2,1,'SCHL-2',2,'SCHL','SCHL-2',2,'1','/1','/250','2023-09-18','Cash','',0,0,250,250,1,'adminFees507','2023-09-18 10:29 25'),
(1,1,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1/1','/0/0','2023-08-26','Cash','',0,0,0,0,1,'adminFees507','2023-09-18 10:29 31'),
(15,14,'SCHL-15',15,'SCHL','SCHL-15',15,'1','/1','/250','2023-09-25','Cash','',0,0,250,250,1,'adminFees507','2023-09-25 10:04 36'),
(30,28,'SCHL-29',29,'SCHL','SCHL-29',29,'1','/1','/100','2023-09-27','Cash','',0,0,100,100,1,'adminFees507','2023-10-03 05:16 28'),
(174,171,'CLOG-5',5,'CLOG','CLOG-5',5,'2','/4','/300','2024-02-26','Cash','',0,0,300,300,1,'adminFees507','2024-02-27 07:18 07'),
(179,176,'CLOG-8',8,'CLOG','CLOG-8',8,'2','/4','/100','2024-05-17','Cash','',0,0,100,100,1,'adminFees507','2024-05-17 05:58 48'),
(178,175,'CLOG-7',7,'CLOG','CLOG-7',7,'2','/4','/100','2024-05-16','Cash','',0,0,100,100,1,'adminFees507','2024-05-17 07:10 52'),
(184,180,'CLOG-12',12,'CLOG','CLOG-12',12,'2','/4','/300','2024-06-03','Cash','',0,0,300,300,1,'adminFees507','2024-06-03 08:58 51'),
(194,190,'SCHL-179',179,'SCHL','SCHL-179',179,'1','/1','/100','2024-06-04','Cash','',0,0,100,100,1,'adminFees507','2024-06-04 10:30 26'),
(203,199,'SCHL-187',187,'SCHL','SCHL-187',187,'1','/1','/100','2024-06-05','Cash','',0,0,100,100,1,'adminFees507','2024-06-05 07:19 20'),
(204,181,'SCHL-187',187,'SCHL','SCHL-187',187,'1','/1','/-400','2024-06-05','Cash','',0,0,-400,-400,1,'adminFees507','2024-06-05 07:24 15'),
(185,181,'SCHL-170',170,'SCHL','SCHL-170',170,'1','/1','/500','2024-06-03','Cash','',0,0,500,500,1,'adminFees507','2024-06-05 07:24 30'),
(208,201,'CLOG-12',12,'CLOG','CLOG-12',12,'2','/4','/300','2024-06-05','Cash','',0,0,300,300,1,'adminFees507','2024-06-05 08:45 29'),
(207,201,'SCHL-189',189,'SCHL','SCHL-189',189,'1','/1','/100','2024-06-05','Cash','',0,0,100,100,1,'adminFees507','2024-06-05 08:45 34'),
(220,213,'SCHL-200',200,'SCHL','SCHL-200',200,'1','/1','/500','2024-06-08','Cash','',0,0,500,500,1,'adminFees507','2024-06-08 05:32 01'),
(237,228,'SCHL-214',214,'SCHL','SCHL-214',214,'1','/1','/500','2024-06-11','Cash','',0,0,500,500,1,'adminFees507','2024-06-11 08:14 50'),
(236,228,'SCHL-213',213,'SCHL','SCHL-213',213,'1','/1','/500','2024-06-11','Cash','',0,0,500,500,1,'adminFees507','2024-06-11 08:14 57'),
(250,240,'SCHL-225',225,'SCHL','SCHL-225',225,'1','/1','/500','2024-06-13','Cash','',0,0,500,500,1,'adminFees507','2024-06-13 07:12 23'),
(252,241,'SCHL-226',226,'SCHL','SCHL-226',226,'1','/1','/500','2024-06-15','Cash','',0,0,500,500,1,'adminFees507','2024-06-15 04:17 22'),
(254,242,'CLOG-15',15,'CLOG','CLOG-15',15,'2','/4','/200','2024-06-15','Cash','',0,0,200,200,1,'adminFees507','2024-06-15 04:21 38'),
(257,245,'SCHL-228',228,'SCHL','SCHL-228',228,'1','/1','/500','2024-06-15','Cash','',0,0,500,500,1,'adminFees507','2024-06-15 05:40 41'),
(279,266,'SCHL-247',247,'SCHL','SCHL-247',247,'1','/1','/500','2024-06-19','Cash','',0,0,500,500,1,'adminFees507','2024-06-19 10:12 51'),
(282,268,'SCHL-248',248,'SCHL','SCHL-248',248,'1','/1','/500','2024-06-20','Cash','',0,0,500,500,1,'adminFees507','2024-06-20 05:44 23'),
(295,282,'SCHL-260',260,'SCHL','SCHL-260',260,'1','/1','/500','2024-06-24','Cash','',0,0,500,500,1,'adminFees507','2024-06-24 10:26 21'),
(299,283,'SCHL-263',263,'SCHL','SCHL-263',263,'1','/1','/500','2024-06-25','Cash','',0,0,500,500,1,'adminFees507','2024-06-25 09:29 39'),
(353,337,'SCHL-315',315,'SCHL','SCHL-315',315,'3','/5','/500','2024-07-08','Cash','',0,0,500,500,1,'adminFees507','2024-07-08 06:10 10'),
(370,354,'CLOG-21',21,'CLOG','CLOG-21',21,'2','/4','/300','2024-07-26','Cash','',0,0,300,300,1,'adminFees507','2024-07-26 05:11 02'),
(387,370,'CLOG-37',37,'CLOG','CLOG-37',37,'2','/4','/300','2024-08-28','Cash','',0,0,300,300,1,'adminFees507','2024-08-28 05:02 37'),
(405,387,'CLOG-54',54,'CLOG','CLOG-54',54,'2','/4','/300','2024-09-05','Cash','',0,0,300,300,1,'adminFees507','2024-09-05 05:55 45'),
(389,371,'CLOG-38',38,'CLOG','CLOG-38',38,'2','/4','/200','2024-08-28','Cash','',0,0,200,200,1,'adminFees507','2024-09-09 05:43 14'),
(409,371,'CLOG-58',58,'CLOG','CLOG-58',58,'2','/4','/100','2024-09-09','Cash','',0,0,100,100,1,'adminFees507','2024-09-09 05:44 46'),
(415,393,'CLOG-62',62,'CLOG','CLOG-62',62,'2','/4','/300','2024-09-12','Cash','',0,0,300,300,1,'adminFees507','2024-09-12 05:18 05'),
(437,357,'SCHL-333',333,'SCHL','SCHL-333',333,'1','/1','/100','2024-09-21','Cash','',0,0,100,100,1,'adminFees507','2024-09-21 04:35 01'),
(442,408,'CLOG-82',82,'CLOG','CLOG-82',82,'2','/4','/300','2024-09-26','Cash','',0,0,300,300,1,'adminFees507','2024-09-26 05:42 46'),
(449,289,'SCHL-336',336,'SCHL','SCHL-336',336,'3','/5','/100','2024-10-15','Cash','',0,0,100,100,1,'adminFees507','2024-10-15 06:43 28'),
(571,426,'DEVP-115',115,'DEVP','DEVP-115',115,'4','/6','/100','2024-11-04','Cash','',0,0,100,100,1,'adminFees507','2024-11-04 06:22 36'),
(585,433,'DEVP-128',128,'DEVP','DEVP-128',128,'4','/6','/100','2024-11-08','Cash','',0,0,100,100,1,'adminFees507','2024-11-11 05:31 14'),
(602,444,'CLOG-100',100,'CLOG','CLOG-100',100,'2','/4','/200','2024-11-22','Cash','',0,0,200,200,1,'adminFees507','2024-11-22 05:28 40'),
(506,410,'DEVP-56',56,'DEVP','DEVP-56',56,'4','/6','/100','2024-10-21','Cash','',0,0,100,100,1,'adminFees507','2024-11-28 06:33 17'),
(337,320,'SCHL-299',299,'SCHL','SCHL-299',299,'3','/5','/500','2024-07-04','Cash','',0,0,500,500,1,'adminFees507','2025-03-21 06:10 54'),
(633,461,'CLOG-113',113,'CLOG','CLOG-113',113,'2','/4','/200','2025-04-05','Cash','',0,0,200,200,1,'adminFees507','2025-04-05 06:45 45'),
(637,464,'CLOG-115',115,'CLOG','CLOG-115',115,'2','/4','/200','2025-05-03','Cash','',0,0,200,200,1,'adminFees507','2025-05-03 05:28 55'),
(639,465,'CLOG-116',116,'CLOG','CLOG-116',116,'2','/4','/200','2025-05-12','Cash','',0,0,200,200,1,'adminFees507','2025-05-12 07:19 08'),
(90,19,'SCHL-87',87,'SCHL','SCHL-87',87,'3','/5','/500','2025-06-16','Cash','',0,0,500,500,1,'adminFees507','2025-06-16 09:15 50'),
(115,142,'SCHL-111',111,'SCHL','SCHL-111',111,'3','/5','/500','2025-07-01','Cash','',0,0,500,500,1,'adminFees507','2025-07-01 06:59 21'),
(122,37,'SCHL-115',115,'SCHL','SCHL-115',115,'3','/5','/500','2025-07-08','Cash','',0,0,500,500,1,'adminFees507','2025-07-10 06:44 32'),
(125,297,'CLOG-8',8,'CLOG','CLOG-8',8,'2','/4','/300','2025-07-14','Cash','',0,0,300,300,1,'adminFees507','2025-07-14 05:40 53');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
`Photos` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=298 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
('ABHAY S ABADI',1,'None','10','A','449',0,'',NULL,0,NULL,NULL),
('AISHAWARYA NARASINGAPPANAVAR',2,'None','10','B','352',9019504057,'',NULL,0,NULL,NULL),
('ARCHANA SHIVAPPA DULLI',3,'None','10','B','482',0,'','Patil Sir',0,NULL,NULL),
('ARUNA TOTLAPPA MADAR',4,'None','10','A','197',7411087793,'',NULL,0,NULL,NULL),
('ASHWINI BADAKANNAVAR',5,'None','10','B','390',9483061701,'',NULL,0,NULL,NULL),
('BANDEPPA ASHOK NEELANUR',6,'None','10','A','463',0,'',NULL,0,NULL,NULL),
('BASAVARAJ HUCHAPPA NEKKARGUNDI',7,'None','10','A','091 244 978',0,'',NULL,0,NULL,NULL),
('BASAVARAJ SANGAPPA AMBIGER',8,'None','10','A','313',7022667097,'',NULL,0,NULL,NULL),
('BASAVVA KALAKAPPA KELUR',9,'None','10','B','088 697 455',0,'',NULL,0,NULL,NULL),
('BHAGYASHRI KELUR',10,'None','10','B','495',0,'',NULL,0,NULL,NULL),
('BORAMMA JUMMANNA KURI',11,'None','10','B','029 739 809',0,'',NULL,0,NULL,NULL),
('CHAITRA SHEKHAPPA KAMANAKERI',12,'None','10','B','473',0,'',NULL,0,NULL,NULL),
('CHETAN KONANNAWAR',13,'None','10','A','314',8296762691,'',NULL,0,NULL,NULL),
('CHETAN BDAMI',14,'None','10','A','422',7026944531,'',NULL,0,NULL,NULL),
('DEVARAJ SHASHIDHAR ANKAD',15,'None','10','A','303',9663702502,'',NULL,0,NULL,NULL),
('DHARMARAJa WALIKARa',16,'None','10','A','336',7337859414,'',NULL,0,NULL,NULL),
('GANESH YARAGALLA',17,'None','10','A','409',9880642587,'',NULL,0,NULL,NULL),
('HUCHESH ANGADI',18,'None','10','A','476',0,'',NULL,0,NULL,NULL),
('HUCHCHESH BASAVARAJ MAaGUNDAPPANAVAR',19,'None','10','A','453',0,'',NULL,0,NULL,NULL),
('ISHWAR KUMBaAR',20,'None','10','A','460',0,'',NULL,0,NULL,NULL),
('JAGADISH HUCHHAPPA MALLI',21,'None','10','A','413',8431443002,'',NULL,0,NULL,NULL),
('KARTEEK WALIKAR',22,'None','10','A','481',0,'',NULL,0,NULL,NULL),
('KAVITA CHANNAPPA TELI',23,'None','10','B','369',7676093047,'',NULL,0,NULL,NULL),
('KAVYA GADEDGOUDARA',24,'None','10','B','338',7204209962,'',NULL,0,NULL,NULL),
('KAVYA TOTAGeR',25,'None','10','B','311',7892725859,'',NULL,0,NULL,NULL),
('KIRTANA GADEDGOUDAR',26,'None','10','B','342',9902848919,'',NULL,0,NULL,NULL),
('KRISHNA PATIL',27,'None','10','A','292',0,'',NULL,0,NULL,NULL),
('LAXMI RAMESH PINDARAKI',28,'None','10','B','353',9880709311,'',NULL,0,NULL,NULL),
('LAXiMIBAI GULEDAGUDDA',29,'None','10','B','364',9108535103,'',NULL,0,NULL,NULL),
('MADHU HUNGUND',30,'None','10','B','392',9611660437,'',NULL,0,NULL,NULL),
('MAHADEVI KALLUR',31,'None','10','B','395',9972159270,'',NULL,0,NULL,NULL),
('MAHAMMADMATIN MURTUJSAB PAKKANNAVAR',32,'None','10','A','488',0,'',NULL,0,NULL,NULL),
('MALiYAPPA JAGGAL',33,'None','10','A','372',8970821010,'',NULL,0,NULL,NULL),
('MALLAMMA BISANALa',34,'None','10','B','397',9945282076,'',NULL,0,NULL,NULL),
('MALLESH HUCHCHAPPA YANKANCHI',35,'None','10','A','459',0,'',NULL,0,NULL,NULL),
('MALLIKARJUN SHIVAPPA NIMBALAGUNDI',36,'None','10','A','496',0,'',NULL,0,NULL,NULL),
('MANJUNATH MUDDAPPA HALAWAR',37,'None','10','A','305',8618194931,'',NULL,0,NULL,NULL),
('MANJUNATH YALLAPPA MAGUNDAPPANAVAR',38,'None','10','A','382',9880307607,'',NULL,0,NULL,NULL),
('MOHAN VEERESH CHAWAN',39,'None','10','A','025 920 768',0,'',NULL,0,NULL,NULL),
('NAVEENKUMAR KUMACHAGI',40,'None','10','A','438',0,'',NULL,0,NULL,NULL),
('NETRAA HANGARGI',41,'None','10','B','310',9972391718,'',NULL,0,NULL,NULL),
('NINGARAJA ANGADI',42,'None','10','A','434',9740030628,'',NULL,0,NULL,NULL),
('PARASHURAM GOUDARa',43,'None','10','A','468',0,'',NULL,0,NULL,NULL),
('PARASHURAM JAGGAL',44,'None','10','A','361',9945365809,'',NULL,0,NULL,NULL),
('PAVITRA MUTTATTI',45,'None','10','B','431',9841787144,'',NULL,0,NULL,NULL),
('POOJA DIGGI',46,'None','10','B','363',8073295543,'',NULL,0,NULL,NULL),
('PRAJWAL BALABATTI',47,'None','10','A','447',0,'',NULL,0,NULL,NULL),
('PRAJWAL HADAPAD',48,'None','10','A','462',0,'',NULL,0,NULL,NULL),
('PRAJWAL NASAGUNI',49,'None','10','A','326',6360247393,'',NULL,0,NULL,NULL),
('PREETAM DANDAVATHI',50,'None','10','A','426',9860271493,'',NULL,0,NULL,NULL),
('PREMA SHIVUKUMAR UPANAL',51,'None','10','B','356',9353992273,'',NULL,0,NULL,NULL),
('Poornima R',52,'None','10','B','347',8867114843,'',NULL,0,NULL,NULL),
('Ramzanabhi',53,'None','10','A','452',0,'',NULL,0,NULL,NULL),
('RAMESH YALAGURADAPPA HERAKAL',54,'None','10','A','343',9980536529,'',NULL,0,NULL,NULL),
('RAMESH BADWADAGI',55,'None','10','A','295',9632947558,'',NULL,0,NULL,NULL),
('RAMESH NEELANUR',56,'None','10','A','487',0,'',NULL,0,NULL,NULL),
('RANGAPPA BALAPPA BANAD',57,'None','10','A','021 166 013',0,'',NULL,0,NULL,NULL),
('REKHA KOtahaL',58,'None','10','B','367',9611858592,'',NULL,0,NULL,NULL),
('ROOPAA SULIKERI',59,'None','10','B','355',7204732526,'',NULL,0,NULL,NULL),
('SACHIN KOKATI',60,'None','10','A','428',7022332790,'',NULL,0,NULL,NULL),
('SAGAR BENAKATTI',61,'None','10','A','450',0,'',NULL,0,NULL,NULL),
('SAGAR SINNUR',62,'None','10','A','485',0,'',NULL,0,NULL,NULL),
('SAMPATH KALUNGAR',63,'None','10','A','360',9844918289,'',NULL,0,NULL,NULL),
('SAMSKRUTI CHALMI',64,'None','10','B','351',9986900358,'',NULL,0,NULL,NULL),
('SANDEEP MADARa',65,'None','10','A','412',8722133440,'',NULL,0,NULL,NULL),
('SANDEEP MADIWALAR',66,'None','10','A','465',0,'',NULL,0,NULL,NULL),
('SANGEETHA GADEDAGOUDAR',67,'None','10','B','307',9663016749,'',NULL,0,NULL,NULL),
('SANJANA MANKANI',68,'None','10','B','393',9632409682,'',NULL,0,NULL,NULL),
('SANJAY JAMAKHANDI',69,'None','10','A','408',9980789316,'',NULL,0,NULL,NULL),
('SHAMBHAVI GADEDGOUDAR',70,'None','10','B','306',8904790968,'',NULL,0,NULL,NULL),
('SHANKAR NYAMAGOUDRA',71,'None','10','A','429',7349173902,'',NULL,0,NULL,NULL),
('SHIVANAND AMARAPPANAVAR',72,'None','10','A','294',8861549001,'',NULL,0,NULL,NULL),
('SHIVANGOWDA NAGARADDI',73,'None','10','A','380',8904700636,'',NULL,0,NULL,NULL),
('SHRUSHThI DUNDAPPA GURIKAR',74,'None','10','B','354',7248855426,'',NULL,0,NULL,NULL),
('SIDDAROODHA METI',75,'None','10','A','116',0,'',NULL,0,NULL,NULL),
('SIDDAVVA HARADOLLI',76,'None','10','B','357',7259964372,'',NULL,0,NULL,NULL),
('SIDDU PARASAPPA METI',77,'None','10','A','420',7795614204,'',NULL,0,NULL,NULL),
('SIDRAMESH KONAPPA HIREMANI',78,'None','10','A','021 165 954',0,'',NULL,0,NULL,NULL),
('SOUBHAGYA KANAKAPPA MADAR',79,'None','10','B','053 379 868',0,'',NULL,0,NULL,NULL),
('SPOORTI GULEDAGUDDA',80,'None','10','B','486',0,'',NULL,0,NULL,NULL),
('SUCHITRA TIPPANNA GOUDaRA',81,'None','10','B','394',7259750613,'',NULL,0,NULL,NULL),
('SUMANTH ACHANUR',82,'None','10','A','436',7975134181,'',NULL,0,NULL,NULL),
('SUMANTH SINNUR',83,'None','10','A','029 895 777',0,'',NULL,0,NULL,NULL),
('SUPREETA SANGAMESH SHINNUR',84,'None','10','B','332',9449958609,'',NULL,0,NULL,NULL),
('SUSHMITA GOUDAR',85,'None','10','B','399',9880028049,'',NULL,0,NULL,NULL),
('VEERABHADRAPPA MOUNESH HADAPAD',86,'None','10','A','451',0,'',NULL,0,NULL,NULL),
('VIJAYANAND SANGAPPA MADAR',87,'None','10','A','114 042 172',0,'',NULL,0,NULL,NULL),
('YALLAPPA BALiMADU',88,'None','10','A','398',8904686372,'',NULL,0,NULL,NULL),
('YAMANAPPA PUJARI',89,'None','10','A','411',7204803898,'','',0,NULL,NULL),
('YANKANNA PARASAPPA MADAR',90,'None','10','A','073 305 966',0,'',NULL,0,NULL,NULL),
('PAVITRA NAGAPPA MULIMANI',91,'None','10','B','78',9845645212,'',NULL,0,NULL,NULL),
('SRUSHTI VAALAPPA KATTIMANI',92,'None','10','B','79',8495059844,'',NULL,0,NULL,NULL),
('BHARAMAVVA MEESI',93,'None','10','B','80',9945850368,'',NULL,0,NULL,NULL),
('NABEEBI NADAFA',94,'None','10','B','81',9611675781,'',NULL,0,NULL,NULL),
('SRUSHTHI KADLIMATTI',95,'None','10','B','82',9902522348,'',NULL,0,NULL,NULL),
('PAVITRA JAGGALA',96,'None','10','B','83',8884177739,'',NULL,0,NULL,NULL),
('DIVAYA HALLAADA',97,'None','10','B','84',9741696543,'',NULL,0,NULL,NULL),
('VINITA NILUGL',98,'None','10','B','85',9632941934,'',NULL,0,NULL,NULL),
('LAXIMIBAI BEVOOR',99,'None','10','B','86',9740321977,'',NULL,0,NULL,NULL),
('GIRIJA BADAKANNAVARA',100,'None','10','B','87',8861908202,'',NULL,0,NULL,NULL),
('NINGAMMA HULYALA',101,'None','10','B','88',9902523108,'',NULL,0,NULL,NULL),
('ANKITA MULIMANI',102,'None','10','B','89',8105806090,'',NULL,0,NULL,NULL),
('SARSWATI BADAKANNAVARA',103,'None','10','B','90',8861561136,'',NULL,0,NULL,NULL),
('SAVITA ITAGI',104,'None','10','B','91',9886842808,'',NULL,0,NULL,NULL),
('ASHWINI MADARA',105,'None','10','B','92',8050826625,'',NULL,0,NULL,NULL),
('PALLAVI CHAVHANA',106,'None','10','B','93',7795855358,'',NULL,0,NULL,NULL),
('SRUSHTI BASAVARAJA JAYYA',107,'None','10','B','94',9538650935,'','',0,NULL,NULL),
('SUMIT LAMANI',108,'None','10','A','104',9972241151,'',NULL,0,NULL,NULL),
('MANJUNATH YARAGALLA',109,'None','10','A','105',8904598637,'',NULL,0,NULL,NULL),
('PRADEEP HADAPDA',110,'None','10','A','106',9901670274,'',NULL,0,NULL,NULL),
('MUTTUSWAMI DEVANGAMATH',111,'None','10','A','107',9448735364,'',NULL,0,NULL,NULL),
('SAVITA HOULGERI',112,'None','10','B','95',9880133034,'',NULL,0,NULL,NULL),
('AISHWARYA NAYANEGALI',113,'None','10','B','96',9019069454,'',NULL,0,NULL,NULL),
('TANUJA PATIL',114,'None','10','B','97',9448466024,'',NULL,0,NULL,NULL),
('BASAVARAJ BADAKANNAVAR',115,'None','10','A','108',8861908202,'',NULL,0,NULL,NULL),
('MAHAMMADSADIK TALAGADE',116,'None','10','A','109',9880967886,'',NULL,0,NULL,NULL),
('YAMANAVVA KAMBAR',117,'None','10','B','98',9900764993,'',NULL,0,NULL,NULL),
('NAYANA INJINERI',118,'None','10','B','99',8123532166,'',NULL,0,NULL,NULL),
('SANJANA SUNAAAGARA',119,'None','10','B','100',6362349181,'',NULL,0,NULL,NULL),
('LAXMAN KENCHAPPA GODI',120,'None','10','A','110',9606782742,'',NULL,0,NULL,NULL),
('HANAMANTH YAMANAPPA VALMIKI',121,'None','10','A','111',6361157883,'',NULL,0,NULL,NULL),
('NAVEEN PUJARI',122,'None','10','A','112',9741667855,'',NULL,0,NULL,NULL),
('JAGANNATHA PUJAR',123,'None','10','A','113',9036334509,'',NULL,0,NULL,NULL),
('REKHA OMKAR RATHODA',124,'None','10','B','101',7676454848,'',NULL,0,NULL,NULL),
('JYOTHI BHAGAVATI',125,'None','10','B','102',7204857264,'',NULL,0,NULL,NULL),
('BORAMMA H PUJARI',126,'None','10','B','103',9741951795,'',NULL,0,NULL,NULL),
('SHIVUKUMAR KARABHARI',127,'None','10','A','114',9964368099,'',NULL,0,NULL,NULL),
('PRAVEEN KATTIMANI',128,'None','10','A','115',9164916544,'',NULL,0,NULL,NULL),
('SUDEEPAKUMAR AMBIGERA',129,'None','10','A','117',0,'',NULL,0,NULL,NULL),
('MUBARAK AMIRAMAJAN TAHASHILDARA',130,'None','10','A','118',9972555482,'',NULL,0,NULL,NULL),
('SHANKARAPPA CHANDRASHEKARA MEESI',131,'None','10','A','199',6364796782,'',NULL,0,NULL,NULL),
('YALLAPPA SANGAPPA CHALAVADI',132,'None','10','A','200',7259964780,'',NULL,0,NULL,NULL),
('VITTHALA BASAVRAJ HOSMANI',133,'None','10','A','201',0,'',NULL,0,NULL,NULL),
('NAVEENA SHRESHAIL BARAKERA',134,'None','10','A','206',8151059498,'',NULL,0,NULL,NULL),
('DEEPA P TEGGI',135,'None','10','B','207',8073142120,'',NULL,0,NULL,NULL),
('KENCHAPPA NAGAPPA GOUDARA',136,'None','10','A','208',0,'',NULL,0,NULL,NULL),
('SHIVARAJ BASAVRAJ ANGADI',137,'None','10','A','211',9731963013,'',NULL,0,NULL,NULL),
('AKASHA YALLAPPA MAGI',138,'None','10','A','293',9880019293,'',NULL,0,NULL,NULL),
('SIDDAPPA SOMAPPA VAANADANA',139,'None','10','A','315',7795517984,'',NULL,0,NULL,NULL),
('KRISHNAKUMARA HANAMAPPA KENGARA',140,'None','10','A','302',9483736984,'',NULL,0,NULL,NULL),
('DaVALASAB SAIDANI',141,'None','10','A','304',8431942354,'',NULL,0,NULL,NULL),
('SIRSHTI KADAM',142,'None','10','B','308',0,'','',0,NULL,NULL),
('AKASHA PARASAPPA MADAR',143,'None','10','A','464',0,'',NULL,0,NULL,NULL),
('AKSHATA TIPPANNA WADDAR',144,'None','10','B','',0,'',NULL,0,NULL,NULL),
('ARUN RAVINDRA HOTI',145,'None','10','A','340',9945280686,'',NULL,0,NULL,NULL),
('ASHWINI BASANAGOUDA PUJARI',146,'None','10','B','477',0,'',NULL,0,NULL,NULL),
('BASAVARAJ JAGADEESH AMBIGERA',147,'None','10','A','362',8151058016,'',NULL,0,NULL,NULL),
('BHAGYALKAXMI YANKAPPA KARADI',148,'None','10','B','421',9970591489,'',NULL,0,NULL,NULL),
('BHARATHI UNNIBHAVI',149,'None','10','B','391',9731001862,'',NULL,0,NULL,NULL),
('BHUVANESHWARI SANGMESH JEEVANGI',150,'None','10','B','344',9019567787,'',NULL,0,NULL,NULL),
('DHARSHAN SHREENIVAS KALAGI',151,'None','10','A','381',7829887428,'',NULL,0,NULL,NULL),
('GANESH SHARANAPPA RATHODA',152,'None','10','A','346',6363707656,'',NULL,0,NULL,NULL),
('GANESH YAMANAPPA PUJARI',153,'None','10','A','327',9740823524,'',NULL,0,NULL,NULL),
('GURURAJ KOPPAD',154,'None','10','A','444',0,'',NULL,0,NULL,NULL),
('HANAMANTA MANKANI',155,'None','10','A','430',95135130360,'',NULL,0,NULL,NULL),
('HANAMANTH KENCHAPPA KADIVALA',156,'None','10','A','443',0,'',NULL,0,NULL,NULL),
('HANAMAVVA MEESI',157,'None','10','B','389',9901104381,'',NULL,0,NULL,NULL),
('HUSEN SAB NABISAB NADAF',158,'None','10','A','442',0,'',NULL,0,NULL,NULL),
('JAGADEESH HOOVINAHALLI',159,'None','10','A','',0,'',NULL,0,NULL,NULL),
('JANAKI KANAKAPPA KAMBALI',160,'None','10','B','341',9740320482,'',NULL,0,NULL,NULL),
('KALLAPPA MADAR',161,'None','10','A','',0,'',NULL,0,NULL,NULL),
('KRUSHNA SANGAPPA KANAKERI',162,'None','10','A','374',9980150666,'',NULL,0,NULL,NULL),
('KUMAR NAGAPPA CHIMMALAGI',163,'None','10','A','',0,'',NULL,0,NULL,NULL),
('LATA SHANKRAPPA BALLA',164,'None','10','B','457',0,'',NULL,0,NULL,NULL),
('MAHESH KHIRAPPA CHAVAN',165,'None','10','A','',0,'',NULL,0,NULL,NULL),
('MANIKANTH GURULINGAPPA HOOGAR',166,'None','10','A','458',0,'',NULL,0,NULL,NULL),
('MANOJ GURUPADAPPA PATIL',167,'None','10','A','373',9986632766,'',NULL,0,NULL,NULL),
('MUTTURAJ BASAVRAJ BaDDUR',168,'None','10','A','455',0,'',NULL,0,NULL,NULL),
('NETRA HUCHAPPA WADDAR',169,'None','10','B','345',7411236282,'',NULL,0,NULL,NULL),
('NISARAAHMAD KHAJESAB GATTARAGI',170,'None','10','A','467',0,'',NULL,0,NULL,NULL),
('NITIN VEERABHDRAPPA PERMI',171,'None','10','A','425',6362189362,'',NULL,0,NULL,NULL),
('PARASAPPA JAGADEESH MELDAPURA',172,'None','10','A','',0,'',NULL,0,NULL,NULL),
('PRAJWLA SANGAPPA GADDI',173,'None','10','A','441',0,'',NULL,0,NULL,NULL),
('PRASHANTH MULIMANI',174,'None','10','A','',0,'',NULL,0,NULL,NULL),
('PRAVEEN SANGAPPA GADDI',175,'None','10','A','439',0,'',NULL,0,NULL,NULL),
('PRAVEENA SHEKHAPPA ADIN',176,'None','10','A','350',7619535336,'',NULL,0,NULL,NULL),
('PREETI MANOHAR BASAKALI',177,'None','10','B','368',9900167876,'',NULL,0,NULL,NULL),
('RAMESH HUCHAPPA ITAGI',178,'None','10','A','440',0,'',NULL,0,NULL,NULL),
('RIYAZ MALIKASAB THASILDHAR',179,'None','10','A','445',0,'',NULL,0,NULL,NULL),
('ROHIT KATTIMANI',180,'None','10','A','414',9916647503,'',NULL,0,NULL,NULL),
('SAMPREET SHREEKANTH VANDAL',181,'None','10','A','410',9844061819,'',NULL,0,NULL,NULL),
('SANDHYA BASAVARAJ CHITTARAGI',182,'None','10','B','370',900892566,'',NULL,0,NULL,NULL),
('SHANKAR NINGAPPA KANDAGAL',183,'None','10','A','446',0,'',NULL,0,NULL,NULL),
('SANJAYA SHANKARAPPA BHAPRI',184,'None','10','A','435',7829168036,'',NULL,0,NULL,NULL),
('SHRIDEVI GOUDAR',185,'None','10','B','400',9880825028,'',NULL,0,NULL,NULL),
('SHANKARAVVA CHANDARAPPA BADIGERa',186,'None','10','B','396',8296286131,'',NULL,0,NULL,NULL),
('SUMITRA PUJARI',187,'None','10','B','348',7892597230,'',NULL,0,NULL,NULL),
('SUNEEL PUNDALIK PUJARI',188,'None','10','A','469',0,'',NULL,0,NULL,NULL),
('SWAPNA GYANAPPA DODAMANI',189,'None','10','B','',0,'',NULL,0,NULL,NULL),
('TANNVEER MAHMDarafik LATI',190,'None','10','A','427',9481838761,'',NULL,0,NULL,NULL),
('VIJAYAKUMAR SHIVAANAD BOOSANNAVAR',191,'None','10','A','433',9686514056,'',NULL,0,NULL,NULL),
('VIKAS PARASHURAMa DHAYAMANNAVAR',192,'None','10','A','470',0,'',NULL,0,NULL,NULL),
('VINAYAK SURESH GARUDA',193,'None','10','A','454',0,'',NULL,0,NULL,NULL),
('PREMKUMAR RAVIKUMAR CHITTAWADGI',194,'None','10','A','333',9901867717,'',NULL,0,NULL,NULL),
('Laxshmibai Bevoor',195,'None','10','B','432',8105577154,'',NULL,0,NULL,NULL),
('NAGAPPA GAdIGEPPA METI',196,'None','10','A','437',0,'',NULL,0,NULL,NULL),
('SHLIPA',197,'None','10','B','',0,'',NULL,0,NULL,NULL),
('AKASH BILAGI',198,'None','Puc II Year','Kala','93',9632954468,'',NULL,0,NULL,NULL),
('BASAVARAJ AIHOLLI',199,'None','Puc II Year','Kala','103',9741524584,'',NULL,0,NULL,NULL),
('BASAVARAJ KOPPAD',200,'None','Puc II Year','Kala','78',8971557131,'',NULL,0,NULL,NULL),
('BHAGYA METI',201,'None','Puc II Year','Kala','97',8105902933,'',NULL,0,NULL,NULL),
('BHEEMAMMA KAMAT',202,'None','Puc II Year','Kala','96',7022244502,'',NULL,0,NULL,NULL),
('BHEEMAVVA GOUDAR',203,'None','Puc II Year','Kala','82',8747949647,'',NULL,0,NULL,NULL),
('BHIMAMBIKE MEESHI',204,'None','Puc II Year','Kala','88',9338069606,'',NULL,0,NULL,NULL),
('BHIMAPPA MUTTAPPA GODI',205,'None','Puc II Year','Kala','98',8951368811,'',NULL,0,NULL,NULL),
('BHIMASHI INJINERI',206,'None','Puc II Year','Kala','77',9945011693,'',NULL,0,NULL,NULL),
('DEEPA BASAPPA KOPPAD',207,'None','Puc II Year','Kala','144',9972139530,'',NULL,0,NULL,NULL),
('DURAGAMMA MADAR',208,'None','Puc II Year','Kala','68',0,'',NULL,0,NULL,NULL),
('DURAGAPPA HUCHAPPA MADAR',209,'None','Puc II Year','Kala','89',9019318267,'',NULL,0,NULL,NULL),
('HANAMANTA RUDRAPPA GOUDAR',210,'None','Puc II Year','Kala','70',9008744385,'',NULL,0,NULL,NULL),
('HANAMAVVA NINGAPPA MEESI',211,'None','Puc II Year','Kala','86',9591495044,'',NULL,0,NULL,NULL),
('HAREESH IRAPPA SUNKAD',212,'None','Puc II Year','Kala','10',8660732714,'',NULL,0,NULL,NULL),
('HUCHCHESH MANTESH MADAR',213,'None','Puc II Year','Kala','91',6360343892,'',NULL,0,NULL,NULL),
('KIRAN BEVURA',214,'None','Puc II Year','Kala','104',9740321977,'',NULL,0,NULL,NULL),
('KIRAN HIRIYAPPA MADAR',215,'None','Puc II Year','Kala','92',7259721419,'',NULL,0,NULL,NULL),
('KIRAN UKKALI',216,'None','Puc II Year','Kala','102',9901104266,'',NULL,0,NULL,NULL),
('LAKSHMAVVA YALLAPPA BHUTAL',217,'None','Puc II Year','Kala','106',8088748050,'',NULL,0,NULL,NULL),
('LAXMI CHALAWADI',218,'None','Puc II Year','Kala','76',8197340713,'',NULL,0,NULL,NULL),
('MAHAMMAD BEFARI',219,'None','Puc II Year','Kala','146',9880448315,'',NULL,0,NULL,NULL),
('MAHESH TOTAGERA',220,'None','Puc II Year','Kala','109',9844863958,'',NULL,0,NULL,NULL),
('MAHMADRAFEEK CHOUDHARI',221,'None','Puc II Year','Kala','95',8867193226,'',NULL,0,NULL,NULL),
('MARUTI WARI',222,'None','Puc II Year','EDUCATION','115',6360158851,'',NULL,0,NULL,NULL),
('MUKKANAGOUD PUJARI',223,'None','Puc II Year','Kala','66',7975407299,'',NULL,0,NULL,NULL),
('NEELAPPA KELUR',224,'None','Puc II Year','Kala','108',9148373682,'',NULL,0,NULL,NULL),
('NINGAPPA BISANAL',225,'None','Puc II Year','Kala','81',0,'',NULL,0,NULL,NULL),
('PARASHURAM YALLAPPA MADIWALAR',226,'None','Puc II Year','Kala','85',9731000582,'',NULL,0,NULL,NULL),
('PARVATEVVA HIREKURUBAR',227,'None','Puc II Year','EDUCATION','116',6360158851,'',NULL,0,NULL,NULL),
('PAVITRA KADAPATTI',228,'None','Puc II Year','Kala','147',7022666029,'',NULL,0,NULL,NULL),
('POOJA GOUDAR',229,'None','Puc II Year','Kala','83',6366708396,'',NULL,0,NULL,NULL),
('POOJA MALAGAVI',230,'None','Puc II Year','EDUCATION','148',7259675369,'',NULL,0,NULL,NULL),
('POOJA PUJARI',231,'None','Puc II Year','Kala','105',7348861808,'',NULL,0,NULL,NULL),
('PRASHANT HUVINAHALLI',232,'None','Puc II Year','Kala','65',6364794858,'',NULL,0,NULL,NULL),
('PRASHANT IRAPPA KAMASHETTI',233,'None','Puc II Year','Kala','197',7996223302,'',NULL,0,NULL,NULL),
('PRAVEEN HUGAR',234,'None','Puc II Year','Kala','74',9036614813,'',NULL,0,NULL,NULL),
('RAKSHITA ALLICHANDI',235,'None','Puc II Year','Kala','100',9880747545,'',NULL,0,NULL,NULL),
('REKHA DODAMANI',236,'None','Puc II Year','Kala','203',0,'',NULL,0,NULL,NULL),
('SACHIN HANAMANTH MADAR',237,'None','Puc II Year','Kala','73',7899269620,'',NULL,0,NULL,NULL),
('SALIM KALLIGUDD',238,'None','Puc II Year','Kala','107',9986331203,'',NULL,0,NULL,NULL),
('SANJANA WADDAR',239,'None','Puc II Year','Kala','75',9535561022,'',NULL,0,NULL,NULL),
('SANTOSH BASAPPA KAMBALI',240,'None','Puc II Year','Kala','99',9611161521,'',NULL,0,NULL,NULL),
('SAROJA MADAR',241,'None','Puc II Year','Kala','71',8618165262,'',NULL,0,NULL,NULL),
('SHIVAKUMAR METI',242,'None','Puc II Year','Kala','145',9480481040,'',NULL,0,NULL,NULL),
('SHOBHA TEGGI',243,'None','Puc II Year','Kala','87',9901966580,'',NULL,0,NULL,NULL),
('SHRADDHA GURUPADAPPA KADLIMATTI',244,'None','Puc II Year','Kala','111',7406875410,'',NULL,0,NULL,NULL),
('SHRIDEVI HIREKURUBAR',245,'None','Puc II Year','EDUCATION','113',6360158851,'',NULL,0,NULL,NULL),
('SOUMYA BANNATTI',246,'None','Puc II Year','Kala','67',9284556321,'',NULL,0,NULL,NULL),
('VISHWANATH KAMALADINNI',247,'None','Puc II Year','Kala','90',9019321447,'',NULL,0,NULL,NULL),
('VITTAL SHIVAPUTRAPPA HADAPAD',248,'None','Puc II Year','Kala','101',6363627543,'',NULL,0,NULL,NULL),
('YALLAVVA BADAKANNAVAR',249,'None','Puc II Year','Kala','84',8867601669,'',NULL,0,NULL,NULL),
('YALLAVVA MULIMANI',250,'None','Puc II Year','Kala','94',7204793615,'',NULL,0,NULL,NULL),
('ADARSH ALAGUNDI',251,'None','Puc II Year','Commerce','128',9380346196,'',NULL,0,NULL,NULL),
('AFSANABANU BANDENAWAZ KALAL',252,'None','Puc II Year','Commerce','130',8310537748,'',NULL,0,NULL,NULL),
('AISHWARYA WALIKAR',253,'None','Puc II Year','Commerce','120',9611422041,'',NULL,0,NULL,NULL),
('ANITA SHASHIDHAR HUBBALLI',254,'None','Puc II Year','Commerce','133',6363439443,'',NULL,0,NULL,NULL),
('ANUSHA GANESH BOMBALE',255,'None','Puc II Year','Commerce','125',8884166474,'',NULL,0,NULL,NULL),
('ASHWINI BASAVARAJ BADAGANDI',256,'None','Puc II Year','Commerce','141',9741062576,'',NULL,0,NULL,NULL),
('BASAVARAJ NARAYANAPPA HOTI',257,'None','Puc II Year','Commerce','129',9901885249,'',NULL,0,NULL,NULL),
('BIBIJAN SHARIFSAB NADAF',258,'None','Puc II Year','Commerce','138',8971559194,'',NULL,0,NULL,NULL),
('BOOMIKA GADEDAGOUDRA',259,'None','Puc II Year','Commerce','140',9902848919,'',NULL,0,NULL,NULL),
('DANAMMA DEGAL',260,'None','Puc II Year','Commerce','143',9008947661,'',NULL,0,NULL,NULL),
('DANAMMA SADASHIV ATHANI',261,'None','Puc II Year','Commerce','142',7975485493,'',NULL,0,NULL,NULL),
('DEEPAK MADIWALAR',262,'None','Puc II Year','Commerce','137',8088237780,'',NULL,0,NULL,NULL),
('HEENA MUJAVAR',263,'None','Puc II Year','Commerce','200',8660197470,'',NULL,0,NULL,NULL),
('MUTTAVVA GOUDAR',264,'None','Puc II Year','Commerce','127',8296839259,'',NULL,0,NULL,NULL),
('PAVITRA GOUDAR',265,'None','Puc II Year','Commerce','119',7483341309,'',NULL,0,NULL,NULL),
('PAVITRA HUNAGUND',266,'None','Puc II Year','Commerce','117',8971559481,'',NULL,0,NULL,NULL),
('PRAJWAL SHIVABASAPPA GALI',267,'None','Puc II Year','Commerce','79',8861337684,'',NULL,0,NULL,NULL),
('PRIYANKA GURUNATHA KAMBAR',268,'None','Puc II Year','Commerce','126',7019386005,'',NULL,0,NULL,NULL),
('PRIYANKA HADAPAD',269,'None','Puc II Year','Commerce','124',9980790588,'',NULL,0,NULL,NULL),
('RAHUL RACHAPPA KANKANAWADI',270,'None','Puc II Year','Commerce','131',9972518457,'',NULL,0,NULL,NULL),
('RANJITA GIRISH KYADIGGERI',271,'None','Puc II Year','Commerce','132',9731650072,'',NULL,0,NULL,NULL),
('REKHA SURESH WAGANAGERI',272,'None','Puc II Year','Commerce','122',9742610214,'',NULL,0,NULL,NULL),
('SANJANA VADAVADAGI',273,'None','Puc II Year','Commerce','135',9535632617,'',NULL,0,NULL,NULL),
('SANTOSH MUDIYAPPA HOSAGOUDRA',274,'None','Puc II Year','Commerce','63',9108944110,'',NULL,0,NULL,NULL),
('SOUBHAGYA MAHANTESH KIRAGI',275,'None','Puc II Year','Commerce','121',9019839887,'',NULL,0,NULL,NULL),
('SRUSHTI WADDAR',276,'None','Puc II Year','Commerce','123',7899807528,'',NULL,0,NULL,NULL),
('SUREKHA KOBANNA BHAPRI',277,'None','Puc II Year','Commerce','134',9738729717,'',NULL,0,NULL,NULL),
('SUSHMITA ANGADI',278,'None','Puc II Year','Commerce','118',8105913612,'',NULL,0,NULL,NULL),
('SWATI BHAPRI',279,'None','Puc II Year','Commerce','139',9481628252,'',NULL,0,NULL,NULL),
('SWATI IRAPPA SULIKERI',280,'None','Puc II Year','Commerce','136',8861589602,'',NULL,0,NULL,NULL),
('VITTAL BAMMAPPA DYAPUR',281,'None','Puc II Year','Commerce','80',9901272228,'',NULL,0,NULL,NULL),
('BASAPPA P KAGI',282,'None','Puc II Year','EDUCATION','112',9353507393,'',NULL,0,NULL,NULL),
('HUCHESH G HOSUR',283,'None','Puc II Year','EDUCATION','201',0,'',NULL,0,NULL,NULL),
('MALINGARAYA M HIREKURABAR',284,'None','Puc II Year','EDUCATION','114',7760908714,'',NULL,0,NULL,NULL),
('ABDULLA L MURAL',285,'None','Puc II Year','Kala','72',9972134581,'',NULL,0,NULL,NULL),
('BASAVARAJ CHALAVADI',286,'None','Puc II Year','Kala','64',9902917811,'',NULL,0,NULL,NULL),
('SANJANA YAMANAPPA WADDAR',287,'None','Puc II Year','Kala','202',0,'',NULL,0,NULL,NULL),
('RANJITA BASAVARAJ KOPPAD',288,'None','Puc II Year','Kala','110',9740783825,'',NULL,0,NULL,NULL),
('Bhimappa Dattandi',289,'None','Puc II Year','Kala','199',8147204290,'',NULL,0,NULL,NULL),
('Parasuram Chalavadi ',290,'Male','PUC','A','',0,'',NULL,0,NULL,NULL),
('Mallikarjun Katari',291,'Male','PUC','A','',0,'',NULL,0,NULL,NULL),
('Vijet Nilugalla',292,'Male','10 ','A','',0,'',NULL,0,NULL,NULL),
('Sangmesh Hiremath ',293,'Male','PUC','A','',0,'','',0,NULL,NULL),
('Saraswati Daddamani (2022-23)',294,'Male','Puc II Year','A','12',0,'',NULL,0,'',NULL),
('Gangamma Alur',295,'Male','PUC','A','',0,'','',0,NULL,NULL),
('Savitri Madar',296,'Male','PUC','A','',0,'','',0,NULL,NULL),
('Jyoti Majjagi',297,'Male','PUC','A','',0,'','',0,NULL,NULL);
/*!40000 ALTER TABLE `stud_basic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic2`
--
DROP TABLE IF EXISTS `stud_basic2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic2` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discount` bigint(20) NOT NULL,
`discription` varchar(200) NOT NULL,
`year` varchar(20) DEFAULT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=208 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,16,3,5,500,500,0,0,'',NULL),
(2,290,2,4,300,300,0,0,'',NULL),
(3,291,2,4,300,300,0,0,'',NULL),
(4,184,3,5,500,500,0,0,'',NULL),
(5,111,3,5,500,500,0,0,'',NULL),
(6,116,3,5,500,500,0,0,'',NULL),
(7,86,3,5,500,500,0,0,'',NULL),
(8,190,3,5,500,500,0,0,'',NULL),
(9,70,3,5,500,500,0,0,'',NULL),
(10,67,3,5,500,500,0,0,'',NULL),
(11,171,3,5,500,500,0,0,'',NULL),
(12,1,3,5,500,500,0,0,'',NULL),
(13,2,3,5,500,500,0,0,'',NULL),
(14,113,3,5,500,0,500,0,'',NULL),
(15,143,3,5,500,0,500,0,'',NULL),
(16,138,3,5,500,0,500,0,'',NULL),
(17,144,3,5,500,0,500,0,'',NULL),
(18,102,3,5,500,0,500,0,'',NULL),
(19,3,3,5,300,300,0,200,'',NULL),
(20,145,3,5,500,500,0,0,'',NULL),
(21,4,3,5,500,0,500,0,'',NULL),
(22,105,3,5,500,0,500,0,'',NULL),
(23,5,3,5,500,500,0,0,'',NULL),
(24,146,3,5,500,500,0,0,'',NULL),
(25,6,3,5,500,0,500,0,'',NULL),
(26,115,3,5,500,0,500,0,'',NULL),
(27,7,3,5,500,0,500,0,'',NULL),
(28,147,3,5,500,500,0,0,'',NULL),
(29,8,3,5,500,500,0,0,'',NULL),
(30,9,3,5,500,0,500,0,'',NULL),
(31,148,3,5,500,500,0,0,'',NULL),
(32,10,3,5,500,0,500,0,'',NULL),
(33,93,3,5,500,500,0,0,'',NULL),
(34,149,3,5,500,500,0,0,'',NULL),
(35,150,3,5,500,500,0,0,'',NULL),
(36,126,3,5,500,0,500,0,'',NULL),
(37,11,3,5,500,0,500,0,'',NULL),
(38,12,3,5,500,500,0,0,'',NULL),
(39,14,3,5,500,0,500,0,'',NULL),
(40,13,3,5,500,0,500,0,'',NULL),
(41,141,3,5,500,500,0,0,'',NULL),
(42,135,3,5,500,500,0,0,'',NULL),
(43,15,3,5,500,0,500,0,'',NULL),
(44,151,3,5,500,0,500,0,'',NULL),
(45,97,3,5,500,500,0,0,'',NULL),
(46,152,3,5,500,500,0,0,'',NULL),
(47,153,3,5,500,500,0,0,'',NULL),
(48,17,3,5,500,500,0,0,'',NULL),
(49,100,3,5,500,500,0,0,'',NULL),
(50,154,3,5,500,500,0,0,'',NULL),
(51,155,3,5,500,500,0,0,'',NULL),
(52,156,3,5,500,500,0,0,'',NULL),
(53,121,3,5,500,0,500,0,'',NULL),
(54,157,3,5,500,500,0,0,'',NULL),
(55,19,3,5,500,500,0,0,'',NULL),
(56,18,3,5,500,500,0,0,'',NULL),
(57,158,3,5,500,500,0,0,'',NULL),
(58,20,3,5,500,0,500,0,'',NULL),
(59,159,3,5,500,0,500,0,'',NULL),
(60,21,3,5,500,0,500,0,'',NULL),
(61,123,3,5,500,0,500,0,'',NULL),
(62,160,3,5,500,0,500,0,'',NULL),
(63,125,3,5,500,0,500,0,'',NULL),
(64,161,3,5,500,0,500,0,'',NULL),
(65,22,3,5,500,0,500,0,'',NULL),
(66,23,3,5,500,500,0,0,'',NULL),
(67,24,3,5,500,500,0,0,'',NULL),
(68,25,3,5,500,500,0,0,'',NULL),
(69,136,3,5,500,0,500,0,'',NULL),
(70,26,3,5,500,500,0,0,'',NULL),
(71,27,3,5,500,0,500,0,'',NULL),
(72,140,3,5,500,500,0,0,'',NULL),
(73,162,3,5,500,500,0,0,'',NULL),
(74,163,3,5,500,0,500,0,'',NULL),
(75,164,3,5,500,500,0,0,'',NULL),
(76,99,3,5,500,0,500,0,'',NULL),
(77,29,3,5,500,0,500,0,'',NULL),
(78,120,3,5,500,0,500,0,'',NULL),
(79,28,3,5,500,500,0,0,'',NULL),
(80,195,3,5,500,500,0,0,'',NULL),
(81,30,3,5,500,500,0,0,'',NULL),
(82,31,3,5,500,500,0,0,'',NULL),
(83,32,3,5,500,0,500,0,'',NULL),
(84,165,3,5,500,0,500,0,'',NULL),
(85,33,3,5,500,0,500,0,'',NULL),
(86,34,3,5,500,500,0,0,'',NULL),
(87,35,3,5,500,0,500,0,'',NULL),
(88,36,3,5,500,0,500,0,'',NULL),
(89,166,3,5,500,0,500,0,'',NULL),
(90,37,3,5,500,500,0,0,'',NULL),
(91,38,3,5,500,500,0,0,'',NULL),
(92,109,3,5,500,500,0,0,'',NULL),
(93,167,3,5,500,500,0,0,'',NULL),
(94,39,3,5,500,0,500,0,'',NULL),
(95,130,3,5,500,500,0,0,'',NULL),
(96,168,3,5,500,500,0,0,'',NULL),
(97,94,3,5,500,500,0,0,'',NULL),
(98,196,3,5,500,500,0,0,'',NULL),
(99,122,3,5,500,500,0,0,'',NULL),
(100,134,3,5,500,0,500,0,'',NULL),
(101,40,3,5,500,500,0,0,'',NULL),
(102,118,3,5,500,500,0,0,'',NULL),
(103,169,3,5,500,500,0,0,'',NULL),
(104,41,3,5,500,0,500,0,'',NULL),
(105,101,3,5,500,0,500,0,'',NULL),
(106,42,3,5,500,0,500,0,'',NULL),
(107,170,3,5,500,500,0,0,'',NULL),
(108,106,3,5,500,0,500,0,'',NULL),
(109,172,3,5,500,0,500,0,'',NULL),
(110,43,3,5,500,500,0,0,'',NULL),
(111,44,3,5,500,500,0,0,'',NULL),
(112,96,3,5,500,500,0,0,'',NULL),
(113,45,3,5,500,0,500,0,'',NULL),
(114,91,3,5,500,500,0,0,'',NULL),
(115,46,3,5,500,500,0,0,'',NULL),
(116,52,3,5,500,0,500,0,'',NULL),
(117,110,3,5,500,0,500,0,'',NULL),
(118,47,3,5,500,500,0,0,'',NULL),
(119,48,3,5,500,500,0,0,'',NULL),
(120,49,3,5,500,0,500,0,'',NULL),
(121,173,3,5,500,500,0,0,'',NULL),
(122,174,3,5,500,0,500,0,'',NULL),
(123,128,3,5,500,500,0,0,'',NULL),
(124,175,3,5,500,500,0,0,'',NULL),
(125,176,3,5,500,500,0,0,'',NULL),
(126,50,3,5,500,500,0,0,'',NULL),
(127,177,3,5,500,500,0,0,'',NULL),
(128,51,3,5,500,500,0,0,'',NULL),
(129,194,3,5,500,0,500,0,'',NULL),
(130,55,3,5,500,0,500,0,'',NULL),
(131,178,3,5,500,500,0,0,'',NULL),
(132,56,3,5,500,0,500,0,'',NULL),
(133,54,3,5,500,0,500,0,'',NULL),
(134,53,3,5,500,0,500,0,'',NULL),
(135,57,3,5,500,0,500,0,'',NULL),
(136,58,3,5,500,500,0,0,'',NULL),
(137,124,3,5,500,0,500,0,'',NULL),
(138,179,3,5,500,0,500,0,'',NULL),
(139,180,3,5,500,500,0,0,'',NULL),
(140,59,3,5,500,0,500,0,'',NULL),
(141,60,3,5,500,500,0,0,'',NULL),
(142,61,3,5,500,500,0,0,'',NULL),
(143,62,3,5,500,0,500,0,'',NULL),
(144,63,3,5,500,500,0,0,'',NULL),
(145,181,3,5,500,0,500,0,'',NULL),
(146,64,3,5,500,500,0,0,'',NULL),
(147,65,3,5,500,500,0,0,'',NULL),
(148,66,3,5,500,500,0,0,'',NULL),
(149,182,3,5,500,500,0,0,'',NULL),
(150,68,3,5,500,500,0,0,'',NULL),
(151,119,3,5,500,0,500,0,'',NULL),
(152,69,3,5,500,500,0,0,'',NULL),
(153,103,3,5,500,500,0,0,'',NULL),
(154,112,3,5,500,0,500,0,'',NULL),
(155,104,3,5,500,500,0,0,'',NULL),
(156,183,3,5,500,500,0,0,'',NULL),
(157,71,3,5,500,0,500,0,'',NULL),
(158,131,3,5,500,500,0,0,'',NULL),
(159,186,3,5,500,0,500,0,'',NULL),
(160,72,3,5,500,0,500,0,'',NULL),
(161,73,3,5,500,500,0,0,'',NULL),
(162,137,3,5,500,0,500,0,'',NULL),
(163,127,3,5,500,0,500,0,'',NULL),
(164,197,3,5,500,0,500,0,'',NULL),
(165,185,3,5,500,500,0,0,'',NULL),
(166,74,3,5,500,500,0,0,'',NULL),
(167,139,3,5,500,500,0,0,'',NULL),
(168,75,3,5,500,0,500,0,'',NULL),
(169,76,3,5,500,500,0,0,'',NULL),
(170,77,3,5,500,0,500,0,'',NULL),
(171,78,3,5,500,0,500,0,'',NULL),
(172,142,3,5,400,400,0,100,'',NULL),
(173,79,3,5,500,0,500,0,'',NULL),
(174,80,3,5,500,0,500,0,'',NULL),
(175,95,3,5,500,500,0,0,'',NULL),
(176,107,3,5,400,400,0,100,'',NULL),
(177,92,3,5,500,500,0,0,'',NULL),
(178,81,3,5,500,500,0,0,'',NULL),
(179,129,3,5,500,500,0,0,'',NULL),
(180,82,3,5,500,500,0,0,'',NULL),
(181,83,3,5,500,0,500,0,'',NULL),
(182,108,3,5,500,500,0,0,'',NULL),
(183,187,3,5,500,0,500,0,'',NULL),
(184,188,3,5,500,500,0,0,'',NULL),
(185,84,3,5,500,500,0,0,'',NULL),
(186,85,3,5,500,500,0,0,'',NULL),
(187,189,3,5,500,0,500,0,'',NULL),
(188,114,3,5,500,0,500,0,'',NULL),
(189,191,3,5,500,500,0,0,'',NULL),
(190,87,3,5,500,0,500,0,'',NULL),
(191,192,3,5,500,0,500,0,'',NULL),
(192,193,3,5,500,500,0,0,'',NULL),
(193,98,3,5,500,500,0,0,'',NULL),
(194,133,3,5,500,0,500,0,'',NULL),
(195,88,3,5,500,500,0,0,'',NULL),
(196,132,3,5,500,0,500,0,'',NULL),
(197,89,3,5,400,400,0,100,'',NULL),
(198,117,3,5,500,500,0,0,'',NULL),
(199,90,3,5,500,0,500,0,'',NULL),
(200,292,1,1,100,100,0,0,'',NULL),
(201,281,1,1,100,100,0,0,'',NULL),
(202,293,2,4,200,200,0,100,'',NULL),
(203,294,2,4,300,300,0,0,'',NULL),
(204,207,2,4,300,300,0,0,'',NULL),
(205,295,2,4,200,200,0,100,'',NULL),
(206,296,2,4,200,200,0,100,'',NULL),
(207,297,2,4,200,200,0,100,'',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=7 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
('DONATION',1,'100','N'),
('DONATION',2,'100','N'),
('SPORTS FEES ',3,'552','N'),
('DONATION-',4,'300','N'),
('DONATION',5,'500','N'),
('Donation --',6,'100','N');
/*!40000 ALTER TABLE `sub_head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subcategory`
--
DROP TABLE IF EXISTS `subcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subcategory` (
`subcategoryid` int(11) NOT NULL AUTO_INCREMENT,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`subcategoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB 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 AUTO_INCREMENT=5 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 */;
INSERT INTO `tblbrand` VALUES
(1,'Ruled Paper',1,'2024-02-19 09:56:14'),
(2,'Chalk Box',1,'2024-02-19 09:56:32'),
(3,'B2B',1,'2024-02-19 09:59:27'),
(4,'Rubber',1,'2024-02-20 07:06:49');
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `tblcart` VALUES
(1,1,388627940,1,1,'2024-02-19 10:08:43');
/*!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 AUTO_INCREMENT=5 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 */;
INSERT INTO `tblcategory` VALUES
(1,'Paper',1,'2024-02-19 09:53:51'),
(2,'Chalk box',1,'2024-02-19 09:54:22'),
(3,'B2B',1,'2024-02-19 09:55:15'),
(4,'Rubber Bands',1,'2024-02-20 07:05:22');
/*!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 AUTO_INCREMENT=7 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 */;
INSERT INTO `tblcustomer` VALUES
(1,'516465978','Smt YRP BE-d',1,'cash','2024-02-19 10:06:44'),
(2,'388627940','shhps',55,'cash','2024-02-19 10:08:43'),
(3,'342448438','shhps',55,'cash','2024-02-19 10:10:52'),
(4,'882719511','Rajguru Hubbali',0,'cash','2024-02-20 07:07:44'),
(5,'855065235','Rajguru Hubbli',0,'cash','2024-02-20 07:21:49'),
(6,'298643730','shhps',55,'cash','2024-02-20 07:26:16');
/*!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 AUTO_INCREMENT=2 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 */;
INSERT INTO `tblproducts` VALUES
(1,'B2B',3,3,'B2B','0',40,225,1,'2024-02-19 10:05:17');
/*!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 AUTO_INCREMENT=5 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 */;
INSERT INTO `tblsubcategory` VALUES
(1,1,'Rule Paper',1,'2024-02-19 09:57:24'),
(2,1,'Xerox Paper',1,'2024-02-19 09:58:12'),
(3,3,'Xerox Paper',1,'2024-02-19 10:04:13'),
(4,4,'Note Rabber',1,'2024-02-20 07:06:03');
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`reference` varchar(255) DEFAULT NULL,
`transactiondate` date NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
`file` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transaction`
--
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_permission`
--
DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`menu` varchar(500) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_permission`
--
LOCK TABLES `user_permission` WRITE;
/*!40000 ALTER TABLE `user_permission` DISABLE KEYS */;
INSERT INTO `user_permission` VALUES
(1,76,'class_division',1),
(2,76,'head',1),
(3,76,'update_student',1),
(4,76,'pay_fees',1),
(5,76,'balance_reports',1),
(6,76,'discount',1),
(7,76,'sub_head',1),
(8,76,'fees_receipt_head',1),
(9,76,'apply_fees_code',1),
(10,76,'payment_approve',1),
(11,76,'inventory',1),
(12,76,'bank',1),
(13,76,'new_student',1),
(14,76,'remove_fees_code',1),
(15,76,'daily_reports',1),
(16,76,'utility',1),
(17,94,'pay_fees',1),
(18,94,'new_student',1);
/*!40000 ALTER TABLE `user_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usermanagement`
--
DROP TABLE IF EXISTS `usermanagement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usermanagement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usermanagement`
--
LOCK TABLES `usermanagement` WRITE;
/*!40000 ALTER TABLE `usermanagement` DISABLE KEYS */;
/*!40000 ALTER TABLE `usermanagement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` char(64) NOT NULL,
`salt` char(16) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`passwordText` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(76,'adminFees507','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'Adminstudent507','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_new`
--
DROP TABLE IF EXISTS `users_new`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_new` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(60) NOT NULL,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role` varchar(20) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`status` varchar(20) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`updated_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_new`
--
LOCK TABLES `users_new` WRITE;
/*!40000 ALTER TABLE `users_new` DISABLE KEYS */;
INSERT INTO `users_new` VALUES
(1,'admin@admin.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','QN2yBnEUMTmrT45NRvlYG4g5Sh9gVUSFzjKeb20HcGFJLEm04H3uyBrNZlDO','0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'rdk@example.com','rdk','$2y$10$2XvoA3Wh2KiFCJXsdIlw.ek83S.km8QNLiCXJjCrbjq0Vzo7hvPJO','Administrator','1234567890','Active','W3EFnZsmRLwuN4t4kZztQ820d7JS8NPJo3vzqQW4rgi1gUTNyIHUcJFdStqA','2022-07-23 07:50:22','2022-07-23 07:50:22');
/*!40000 ALTER TABLE `users_new` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vochers`
--
DROP TABLE IF EXISTS `vochers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vochers` (
`Date` date NOT NULL,
`Cheque_Drop_Date` int(100) DEFAULT NULL,
`V_Id` int(11) NOT NULL AUTO_INCREMENT,
`v_counter` bigint(20) NOT NULL,
`Type` varchar(1000) NOT NULL,
`Cr_Ledger` varchar(1000) NOT NULL,
`Dr_Ledger` varchar(1000) NOT NULL,
`Cr_Ledger_Type` varchar(1000) NOT NULL,
`Dr_Ledger_Type` varchar(1000) NOT NULL,
`Cr_Amount` varchar(1000) NOT NULL,
`Dr_Amount` varchar(1000) NOT NULL,
`Nrtn` varchar(5000) NOT NULL,
PRIMARY KEY (`V_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vochers`
--
LOCK TABLES `vochers` WRITE;
/*!40000 ALTER TABLE `vochers` DISABLE KEYS */;
INSERT INTO `vochers` VALUES
('2025-05-15',NULL,1,1,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-05-17',NULL,2,2,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','600','600','Fees Collected'),
('2025-05-17',NULL,3,3,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2025-05-19',NULL,4,4,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-05-20',NULL,5,5,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','5000','5000','Fees Collected'),
('2025-05-21',NULL,6,6,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-05-22',NULL,7,7,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','7000','7000','Fees Collected'),
('2025-05-24',NULL,8,8,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-05-26',NULL,9,9,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-05-27',NULL,10,10,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-05-28',NULL,11,11,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2100','2100','Fees Collected'),
('2025-05-29',NULL,12,12,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','4000','4000','Fees Collected'),
('2025-05-30',NULL,13,13,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-05-31',NULL,14,14,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-06-02',NULL,15,15,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2100','2100','Fees Collected'),
('2025-06-05',NULL,16,16,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-06',NULL,17,17,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2025-06-09',NULL,18,18,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-09',NULL,19,19,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2025-06-10',NULL,20,20,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1400','1400','Fees Collected'),
('2025-06-12',NULL,21,21,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-06-13',NULL,22,22,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-06-14',NULL,23,23,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-06-16',NULL,24,24,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-17',NULL,25,25,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-18',NULL,26,26,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-06-19',NULL,27,27,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1300','1300','Fees Collected'),
('2025-06-21',NULL,28,28,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-06-23',NULL,29,29,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2025-06-24',NULL,30,30,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2025-06-26',NULL,31,31,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-06-27',NULL,32,32,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-28',NULL,33,33,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','1500','1500','Fees Collected'),
('2025-06-30',NULL,34,34,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-07-01',NULL,35,35,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','800','800','Fees Collected'),
('2025-07-01',NULL,36,36,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','300','300','Fees Collected'),
('2025-07-03',NULL,37,37,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-07-07',NULL,38,38,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-07-07',NULL,39,39,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','300','300','Fees Collected'),
('2025-07-08',NULL,40,40,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2025-07-11',NULL,41,41,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','400','400','Fees Collected'),
('2025-07-14',NULL,42,42,'Recipt','DONATION-','Cash','Income/Revenue','Current Assets','200','200','Fees Collected'),
('2025-07-14',NULL,43,43,'Recipt','DONATION','Cash','Income/Revenue','Current Assets','500','500','Fees Collected');
/*!40000 ALTER TABLE `vochers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-07-18 0:00:30