|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.163 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/../best/../SGHCC/ |
| [ 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_SGHCC_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=5 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
(4,'SKVVS GANGAVATHI','SKVV SANGHA (R)','G H N COLLEGE OF COMMERCE ','PAMPANAGARA, GANGAVATHI - 583 227');
/*!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=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'SBI BANK GANGAVATHI','','6220611281','G.H.N. College Gangavathi',0,0,0,'',''),
(2,'Canara Bank','','0547101013916','G.H.N. College Gangavathi',0,0,0,'',''),
(3,'Hanagal Sri Kumareshwara Bank','','MSA/10','G.H.N. College Gangavathi',0,0,0,'',''),
(4,'HANAGAL SRI GURUKUMARESHWARA PA.SA.NI','','MAS/239','PRINCIPAL PG',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 AUTO_INCREMENT,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`fromdate` date NOT NULL,
`todate` date DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`budgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `budget`
--
LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`categoryid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text DEFAULT NULL,
`type` int(11) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!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=13 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
('B.com-1',2,NULL),
('B.com-2',3,NULL),
('B.com-3',4,NULL),
('B.A-1',6,NULL),
('B.A-2',8,NULL),
('M.COM-1',9,NULL),
('M.COM-2',10,NULL),
('B.A-3',11,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=4 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',3,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 AUTO_INCREMENT,
`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=18 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
('B.Com-1',9,'4/18','2026-06-01','No','0','3','GHNM'),
('B.Com-2',10,'4/8','2026-06-01','No','0','3','GHNM'),
('B.Com-3',11,'4/11','2026-06-01','No','0','3','GHNM'),
('B.A-1',12,'4/13','2026-06-01','No','0','1','GHNM'),
('B.A-2',14,'15/16','2026-06-01','No','0','1','GHNM'),
('M.COM-2',15,'15/17','2026-06-01','No','0','4','GHNM'),
('M.COM-1 Managment',16,'15/19','2026-06-01','No','0','4','GHNM'),
('M.COM-1 GOVT',17,'15/20','2026-06-01','No','0','4','GHNM');
/*!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=25 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
('GOVERNMENT FEES',1,'Income/Revenue'),
('UNIVERSITY FEES',2,'Income/Revenue'),
('COLLEGE FEES',3,'Income/Revenue'),
('COLLEGE DEVELOPMENT FUND',4,'Income/Revenue'),
('COLLEGE DEVELOPMENT FUND',5,'Income/Revenue'),
('GUEST LECTURE FEES',6,'Income/Revenue'),
('COMPUTER FEES',7,'Income/Revenue'),
('GUEST LECTURE FEES',8,'Income/Revenue'),
('VI SEM FEES',9,'Income/Revenue'),
('IV SEM FEES',10,'Income/Revenue'),
('SBI BANK GANGAVATHI-1281',11,'Current Assets'),
('Canara Bank-3916',12,'Current Assets'),
('Hanagal Sri Kumareshwara Bank-A/10',13,'Current Assets'),
('GUEST LECTURE FEES',14,'Income/Revenue'),
('devolpment fees',15,'Income/Revenue'),
('GUEST LECTURE FEES',16,'Income/Revenue'),
('GUEST LECTURE FEES ',17,'Income/Revenue'),
('COLLEGE DEVELOPMENT FUND',18,'Income/Revenue'),
('GUEST LECTURER FEES ',19,'Income/Revenue'),
('GUEST LECTURER FEES ',20,'Income/Revenue'),
('GUEST LECTURER FEES ',21,'Income/Revenue'),
('GUEST LECTURER FEES ',22,'Income/Revenue'),
('GUEST LECTURER FEES ',23,'Income/Revenue'),
('HANAGAL SRI GURUKUMARESHWARA PA.SA.NI-/239',24,'Current Assets');
/*!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 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 */;
/*!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,79,'GHND-1',1,'GHND','GHND-1',1,'5','/5','/600','2022-10-07','Cash','1935',0,0,600,600,1,'Adminfees','2023-01-24 08:08 28'),
(1,79,'GHNT-1',1,'GHNT','GHNT-1',1,'7','/11','/2400','2022-10-07','Cash','1935',0,0,2400,2400,1,'Adminfees','2023-01-24 08:08 31'),
(3,80,'GHNT-2',2,'GHNT','GHNT-2',2,'7','/11','/2400','2022-10-07','Cash','1936',0,0,2400,2400,1,'Adminfees','2023-01-24 08:08 41'),
(4,80,'GHND-2',2,'GHND','GHND-2',2,'5','/5','/600','2022-10-07','Cash','1936',0,0,600,600,1,'Adminfees','2023-01-24 08:08 43'),
(5,81,'GHNT-3',3,'GHNT','GHNT-3',3,'7','/11','/2400','2022-10-07','Cash','1937',0,0,2400,2400,1,'Adminfees','2023-01-24 08:08 53'),
(6,81,'GHND-3',3,'GHND','GHND-3',3,'5','/5','/600','2022-10-07','Cash','1937',0,0,600,600,1,'Adminfees','2023-01-24 08:08 55'),
(9,105,'GHNT-5',5,'GHNT','GHNT-5',5,'7','/11','/2400','2022-10-07','Cash','1939',0,0,2400,2400,1,'Adminfees','2023-01-24 08:09 03'),
(10,105,'GHND-5',5,'GHND','GHND-5',5,'5','/5','/600','2022-10-07','Cash','1939',0,0,600,600,1,'Adminfees','2023-01-24 08:09 05'),
(7,97,'GHNT-4',4,'GHNT','GHNT-4',4,'7','/11','/2400','2023-01-23','Cash','1938',0,0,2400,2400,1,'Adminfees','2023-01-24 08:09 11'),
(8,97,'GHND-4',4,'GHND','GHND-4',4,'5','/5','/600','2023-01-23','Cash','1938',0,0,600,600,1,'Adminfees','2023-01-24 08:09 14'),
(270,144,'GHND-130',130,'GHND','GHND-130',130,'5','/5','/600','2023-01-14','Cash','2125',0,0,600,600,1,'Adminfees','2023-02-02 10:20 26'),
(267,144,'GHNT-129',129,'GHNT','GHNT-129',129,'7','/11','/3300','2023-01-14','Cash','2124',0,0,3300,3300,1,'Adminfees','2023-02-02 10:20 28'),
(268,144,'GHND-129',129,'GHND','GHND-129',129,'5','/5','/600','2023-01-14','Cash','2124',0,0,600,600,1,'Adminfees','2023-02-02 10:20 31'),
(269,144,'GHNT-130',130,'GHNT','GHNT-130',130,'7','/11','/2200','2023-01-14','Cash','2125',0,0,2200,2200,1,'Adminfees','2023-02-02 10:20 33'),
(41,243,'GHNT-16',16,'GHNT','GHNT-16',16,'8','/8','/3000','2022-11-02','Cash','2003',0,0,3000,3000,1,'Adminfees','2023-03-02 11:10 51'),
(42,243,'GHND-16',16,'GHND','GHND-16',16,'5','/5','/600','2022-11-02','Cash','2003',0,0,600,600,1,'Adminfees','2023-03-02 11:11 00'),
(53,254,'GHNT-22',22,'GHNT','GHNT-22',22,'8','/8','/3000','2022-11-07','Cash','2009',0,0,3000,3000,1,'Adminfees','2023-03-02 11:12 06'),
(54,254,'GHND-22',22,'GHND','GHND-22',22,'5','/5','/600','2022-11-07','Cash','2009',0,0,600,600,1,'Adminfees','2023-03-02 11:12 11'),
(3,348,'GHNM-3',3,'GHNM','GHNM-3',3,'9','/4/13','/1200/5320','2023-11-24','Cash','2442',0,0,6520,6520,1,'Adminfees','2024-02-14 07:47 15'),
(28,366,'GHNM-27',27,'GHNM','GHNM-27',27,'9','/4/13','/600/1420','2023-11-25','Cash','',0,0,2020,2020,1,'Adminfees','2024-02-14 11:18 09'),
(46,324,'GHNM-45',45,'GHNM','GHNM-45',45,'9','/4/6/13','/600/0/2020','2023-11-25','Cash','',0,0,2620,2620,1,'Adminfees','2024-02-14 11:20 47'),
(105,31,'GHNM-102',102,'GHNM','GHNM-102',102,'10','/4/8','/1200/5500','2023-12-07','Cash','2541',0,0,6700,6700,1,'Adminfees','2024-02-15 12:08 31'),
(106,55,'GHNM-103',103,'GHNM','GHNM-103',103,'10','/4/8','/1200/5500','2023-12-07','Cash','2542',0,0,6700,6700,1,'Adminfees','2024-02-15 12:10 09'),
(1,437,'GHNM-1',1,'GHNM','GHNM-1',1,'12','/14/15','/1000/600','2025-01-01','Cash','',0,0,1600,1600,1,'manju','2025-01-01 08:20 58'),
(2,640,'GHNM-1',1,'GHNM','GHNM-1',1,'9','/4/18','/00/2310','2025-01-10','Cash','',0,0,2310,2310,1,'manju','2025-01-10 10:41 55'),
(3,640,'GHNM-1',1,'GHNM','GHNM-1',1,'9','/4/18','/1200/2310','2025-01-10','Cash','',0,0,3510,3510,1,'manju','2025-01-10 10:42 59');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
/*!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`),
CONSTRAINT `deleteroleaccess` FOREIGN KEY (`userid`) REFERENCES `users_new` (`userid`) ON DELETE CASCADE
) 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 AUTO_INCREMENT,
`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,
PRIMARY KEY (`settingsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`Status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=700 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
('Naveen M Satyanarayana M',498,'','M.COM-2','A','P32JQ23C012008',6363621819,'',NULL,0,NULL),
('Doddabasappa Mallikarjuna',499,'','M.COM-2','A','P32JQ23C012009',9535882286,'',NULL,0,NULL),
('Kotagi Soundarya Kotagi Sharanappa',500,'','M.COM-2','A','P32JQ23C012010',9353870179,'',NULL,0,NULL),
('Rakshitha G Ravikumar',501,'','M.COM-2','A','P32JQ23C012011',9008670364,'',NULL,0,NULL),
('Ravikumar Mareppa',502,'','M.COM-2','A','P32JQ23C012012',6087066201,'',NULL,0,NULL),
('Mohiddin Shah Makthumsab',503,'','M.COM-2','A','P32JQ23C012013',7483346711,'',NULL,0,NULL),
('Maruthi Shivappa Moti',504,'','M.COM-2','A','P32JQ23C012014',9019649901,'',NULL,0,NULL),
('C M Sahana C M Kotturuswamy',505,'','M.COM-2','A','P32JQ23C012015',9019291286,'',NULL,0,NULL),
('SHIVARANJANI',674,'Male','M.COM-1','A','P32JQ24C012016',9880271104,'',NULL,0,NULL),
('Zeba Parveen Muzaffaruddin Siddiqui',496,'','M.COM-2','A','P32JQ23C012006',9482228809,'',NULL,0,NULL),
('Anitha Gavisiddappa',495,'','M.COM-2','A','P32JQ23C012005',9980575660,'',NULL,0,NULL),
('Anil Kumar Mallikarjuna',494,'','M.COM-2','A','P32JQ23C012004',9241849313,'',NULL,0,NULL),
('Shashidhara Dandin Sangappa',493,'','M.COM-2','A','P32JQ23C012003',8861867882,'',NULL,0,NULL),
('D Lakshmi D Nagarajrao',492,'','M.COM-2','A','P32JQ23C012002',7483464343,'',NULL,0,NULL),
('Afsan Babasab',491,'','M.COM-2','A','P32JQ23C012001',9483134143,'',NULL,0,NULL),
('Yamanurappa Holiyappa',490,'','B.A-2','A','U32JQ24A0044',8147638872,'',NULL,0,NULL),
('Yamanura Manjunatha',489,'','B.A-2','A','U32JQ24A0033',7996399002,'',NULL,0,NULL),
('Vikas Nayaka Anjanappa',488,'','B.A-2','A','U32JQ24A0032',6362066608,'',NULL,0,NULL),
('Venkatesha Lakkanna Uppara',487,'','B.A-2','A','U32JQ24A0014',9611919660,'',NULL,0,NULL),
('U Manjunath Jadiyappa',486,'','B.A-2','A','U32JQ24A0040',9019828803,'',NULL,0,NULL),
('T Sridhara T Srinivasa',485,'','B.A-2','A','U32JQ24A0022',6360542022,'',NULL,0,NULL),
('T Muttanna Somappa',484,'','B.A-2','A','U32JQ24A0018',9353868941,'',NULL,0,NULL),
('Suresh Kumar Bheemana Gouda',483,'','B.A-2','A','U32JQ24A0004',6363272458,'',NULL,0,NULL),
('Sunitha Daveed',482,'','B.A-2','A','U32JQ24A0015',9743776125,'',NULL,0,NULL),
('Somaraj Sanna Virupanna Sanna Virupanna',481,'','B.A-2','A','U32JQ24A0051',7795507408,'',NULL,0,NULL),
('Somanatha Basappa Golageri Basappa Golageri',480,'','B.A-2','A','U32JQ24A0029',9380046382,'',NULL,0,NULL),
('Somanath Bhogesh Malakanamaradi',479,'','B.A-2','A','U32JQ24A0016',6360384025,'',NULL,0,NULL),
('Shivakumara Vijayakumara',478,'','B.A-2','A','U32JQ24A0030',9380535454,'',NULL,0,NULL),
('Shivabasana Gouda Mallikarjuna Gouda',477,'','B.A-2','A','U32JQ24A0038',8792145609,'',NULL,0,NULL),
('Premaneela Daveed',470,'','B.A-2','A','U32JQ24A0035',8431973002,'',NULL,0,NULL),
('Ramesh Hanumanta Venkatagiri Hanumanta',471,'','B.A-2','A','U32JQ24A0043',7899495213,'',NULL,0,NULL),
('Ravi Kumar Eshappa',472,'','B.A-2','A','U32JQ24A0002',9008952062,'',NULL,0,NULL),
('Sameer Yamanoora Sab',473,'','B.A-2','A','U32JQ24A0027',8310798083,'',NULL,0,NULL),
('Sankesh Hirehanamanthappa',474,'','B.A-2','A','U32JQ24A0045',9008871649,'',NULL,0,NULL),
('Satyamurti yadav Siddappa Yadav',475,'','B.A-2','A','U32JQ24A0031',9606619089,'',NULL,0,NULL),
('Shashidara Jalihala Basappa Jalihala',476,'','B.A-2','A','U32JQ24A0007',7483885192,'',NULL,0,NULL),
('Nayomi Isrel',464,'','B.A-2','A','U32JQ24A0020',7026795698,'',NULL,0,NULL),
('Neludi Shanmuka Nelludi Kanakappa',465,'','B.A-2','A','U32JQ24A0050',7899752385,'',NULL,0,NULL),
('Parashurama Kanakappa',466,'','B.A-2','A','U32JQ24A0042',8618267855,'',NULL,0,NULL),
('Parashurama Timmanna',467,'','B.A-2','A','U32JQ24A0021',7259713472,'',NULL,0,NULL),
('Prakashagouda Ramesh',468,'','B.A-2','A','U32JQ24A0009',9731613895,'',NULL,0,NULL),
('Pravin Kumar Manjunatha',469,'','B.A-2','A','U32JQ24A0013',9663004454,'',NULL,0,NULL),
('Nandini Mariyappa',463,'','B.A-2','A','U32JQ24A0003',8431907297,'',NULL,0,NULL),
('Mahiboob khan Magdum Husen',456,'','B.A-2','A','U32JQ24A0023',8861764890,'',NULL,0,NULL),
('Mallikarjuna K Ayyappa',457,'','B.A-2','A','U32JQ24A0034',7975701074,'',NULL,0,NULL),
('Manjula Harivana Basappa Harivana',458,'','B.A-2','A','U32JQ24A0048',8310038545,'',NULL,0,NULL),
('Manjunath Anjinappa',459,'','B.A-2','A','U32JQ24A0005',9113227363,'',NULL,0,NULL),
('Manjunatha D Ayyappa',460,'','B.A-2','A','U32JQ24A0047',7483150972,'',NULL,0,NULL),
('Mariyamma Hanumantappa',461,'','B.A-2','A','U32JQ24A0053',0,'',NULL,0,NULL),
('Nagaraj Pampanna',462,'','B.A-2','A','U32JQ24A0011',9739929919,'',NULL,0,NULL),
('Devaraj Beragi Malleppa',449,'','B.A-2','A','U32JQ24A0010',6361098597,'',NULL,0,NULL),
('G.Devaraj G Venkatesh',450,'','B.A-2','A','U32JQ24A0008',6361657422,'',NULL,0,NULL),
('Ganesh Photappa',451,'','B.A-2','A','U32JQ24A0006',8217599139,'',NULL,0,NULL),
('Jhansirani Prakash',452,'','B.A-2','A','U32JQ24A0046',9743489691,'',NULL,0,NULL),
('Kalingappa Basavaraj',453,'','B.A-2','A','U32JQ24A0037',8904928461,'',NULL,0,NULL),
('Karthika Yuvaraj',454,'','B.A-2','A','U32JQ24A0028',8123344607,'',NULL,0,NULL),
('Kirankumar Nagaraja',455,'','B.A-2','A','U32JQ24A0041',8618201486,'',NULL,0,NULL),
('Afreen Alhimiya',438,'','B.A-2','A','U32JQ24A0052',8431522163,'',NULL,0,NULL),
('Aseef Ali Hajibabu',439,'','B.A-2','A','U32JQ24A0024',7676330231,'',NULL,0,NULL),
('Ashoka C Parameshwar',440,'','B.A-2','A','U32JQ24A0019',9731417673,'',NULL,0,NULL),
('Ashoka Krishnappa',441,'','B.A-2','A','U32JQ24A0026',6363590876,'',NULL,0,NULL),
('Baba Ashrafali Husensab Mudenur Husensab Mudenur',442,'','B.A-2','A','U32JQ24A0049',9019876007,'',NULL,0,NULL),
('Basavaraja Lakshmappa Kampli',443,'','B.A-2','A','U32JQ24A0012',6362977657,'',NULL,0,NULL),
('T Farooq T Bashusab',515,'','M.COM-2','A','P32JQ23C012026',7019917158,'',NULL,0,NULL),
('Avinash J Parameshwarappa J',516,'','M.COM-2','A','P32JQ23C012027',9620107185,'',NULL,0,NULL),
('Vijayalakshmi Narabandi Rayappa',508,'','M.COM-2','A','P32JQ23C012018',8310437628,'',NULL,0,NULL),
('TEJAS MUDGAL Shivaraj Mudgal',509,'','M.COM-2','A','P32JQ23C012019',9945363794,'',NULL,0,NULL),
('Pendaylla Kavya N Prabakar',510,'','M.COM-2','A','P32JQ23C012020',9964800775,'',NULL,0,NULL),
('Sharanamma Pandappa Adapoor',511,'','M.COM-2','A','P32JQ23C012021',9902379664,'',NULL,0,NULL),
('Ruheena Sabahat Mohammad Sadiq',506,'','M.COM-2','A','P32JQ23C012016',8861253786,'',NULL,0,NULL),
('Kavya Kulkarni Kanakachala Rao Kulakarni',507,'','M.COM-2','A','P32JQ23C012017',8431893489,'',NULL,0,NULL),
('SUBRAHMANYA Hanumesha',497,'','M.COM-2','A','P32JQ23C012007',8151891960,'',NULL,0,NULL),
('AKSHATHA Nagaraja Bagur',517,'','M.COM-2','A','P32JQ23C012028',9353658836,'',NULL,0,NULL),
('Chaitra S H Sharanappa H',512,'','M.COM-2','A','P32JQ23C012022',7406528652,'',NULL,0,NULL),
('Ruksana Begam Gousemohidin',513,'','M.COM-2','A','P32JQ23C012023',7760982130,'',NULL,0,NULL),
('Shambhavi K Shankrappa K',514,'','M.COM-2','A','P32JQ23C012024',7483597319,'',NULL,0,NULL),
('Basavaraja Tirupathi',444,'','B.A-2','A','U32JQ24A0039',8618739896,'',NULL,0,NULL),
('Bheemesha Siddappa Karadi',445,'','B.A-2','A','U32JQ24A0017',8618955644,'',NULL,0,NULL),
('C Shivaprakasha C Yarriswamy',446,'','B.A-2','A','U32JQ24A0025',7259830093,'',NULL,0,NULL),
('Chandrappa nagappa Sungara Nagappa',447,'','B.A-2','A','U32JQ24A0036',9380807407,'',NULL,0,NULL),
('Channabasava Veeranna',448,'','B.A-2','A','U32JQ24A0001',8792043372,'',NULL,0,NULL),
('Abdul Gaffar Khan Abdul Razaaq Khan',287,'','B.com-3','A','U32JQ23C0050',9008679592,'',NULL,0,NULL),
('Abhishek H Mallikarjuna Huded',289,'','B.com-3','A','U32JQ23C0045',7019621201,'',NULL,0,NULL),
('Adarsh Bisanalli Shankrappa',290,'','B.com-3','A','U32JQ23C0022',8095711914,'',NULL,0,NULL),
('Ananda K Honnesha Kanakagiri',291,'','B.com-3','A','U32JQ23C0071',7676322836,'',NULL,0,NULL),
('Ananya Hosalli Bheemashankar Hosalli',292,'','B.com-3','A','U32JQ23C0066',8867580019,'',NULL,0,NULL),
('Anitha Chennappa',293,'','B.com-3','A','U32JQ23C0021',8095176925,'',NULL,0,NULL),
('Apoorva Angadi Shivayogi Angadi',294,'','B.com-3','A','U32JQ23C0002',8762353530,'',NULL,0,NULL),
('Aravind Shivappa Nagalikar',295,'','B.com-3','A','U32JQ23C0091',8431736923,'',NULL,0,NULL),
('Ashfiya syed Asger Hussain',296,'','B.com-3','A','U32JQ23C0044',9019942913,'',NULL,0,NULL),
('B S Shivashankar Naidu B P Shridhar',297,'','B.com-3','A','U32JQ23C0010',7204717985,'',NULL,0,NULL),
('Basavanagouda Jagadish',298,'','B.com-3','A','U32JQ23C0028',7619425276,'',NULL,0,NULL),
('Basavashri J Thippeswamy',299,'','B.com-3','A','U32JQ23C0025',8431734004,'',NULL,0,NULL),
('Bhimaraj Basavaraj',300,'','B.com-3','A','U32JQ23C0008',8951659115,'',NULL,0,NULL),
('C Nagappa C Manjunath',301,'','B.com-3','A','U32JQ23C0013',8197774493,'',NULL,0,NULL),
('Chetan D K Kotresh D',302,'','B.com-3','A','U32JQ23C0029',8088644685,'',NULL,0,NULL),
('Dada khalandar Mastan vali',304,'','B.com-3','A','U32JQ23C0014',9019403522,'',NULL,0,NULL),
('Darshan Veeresh Bagodi',305,'','B.com-3','A','U32JQ23C0038',8088093235,'',NULL,0,NULL),
('Dhanaraj Rao Girish Rao Gayakwad',306,'','B.com-3','A','U32JQ23C0082',7019032220,'',NULL,0,NULL),
('Dulaira Tanjum D H Honnur Sab',307,'','B.com-3','A','U32JQ23C0067',9060406611,'',NULL,0,NULL),
('Firoj Mahamed Shafi',308,'','B.com-3','A','U32JQ23C0064',8431634412,'',NULL,0,NULL),
('Hamsagamani CH NageshwaraRao CH',309,'','B.com-3','A','U32JQ23C0015',8497098660,'',NULL,0,NULL),
('Hanumesha Basappa Valekar',310,'','B.com-3','A','U32JQ23C0046',8904670639,'',NULL,0,NULL),
('Julan Basha Husensab',313,'','B.com-3','A','U32JQ23C0075',7022729390,'',NULL,0,NULL),
('K Vinayakumar Pampapati kinedar',315,'','B.com-3','A','U32JQ23C0037',8123391893,'',NULL,0,NULL),
('Kalyan Babu V Ramu V',316,'','B.com-3','A','U32JQ23C0073',9019858757,'',NULL,0,NULL),
('Karthik Chandru',317,'','B.com-3','A','U32JQ23C0024',7975365413,'',NULL,0,NULL),
('Kumar Pal Prakash ',319,'','B.com-3','A','U32JQ23C0086',8904334849,'',NULL,0,NULL),
('Lakshmichandrakanth P veerabhramam P',320,'','B.com-3','A','U32JQ23C0089',7019526967,'',NULL,0,NULL),
('M D Afrooz M D Moulahussain',321,'','B.com-3','A','U32JQ23C0033',8546889784,'',NULL,0,NULL),
('NAGARAJ ',673,'Male','M.COM-1','A','P32JQ24C012011',8660955496,'',NULL,0,NULL),
('Mahamad Gouse Dada peer',323,'','B.com-3','A','U32JQ23C0036',7349020243,'',NULL,0,NULL),
('Mahammad Sarparaj Mahammad Shamid',324,'','B.com-3','A','U32JQ23C0049',7204788566,'',NULL,0,NULL),
('Mahesh Krishna',325,'','B.com-3','A','U32JQ23C0048',8073937319,'',NULL,0,NULL),
('Maheshkumar S Yamanurappa',326,'','B.com-3','A','U32JQ23C0012',7795037911,'',NULL,0,NULL),
('Mallikarjun Chandrashekhar',327,'','B.com-3','A','U32JQ23C0058',9606644866,'',NULL,0,NULL),
('Maruthi Gowli Sidramappa Gowli',328,'','B.com-3','A','U32JQ23C0061',8073962239,'',NULL,0,NULL),
('Mohamed altaf Shakshavali',329,'','B.com-3','A','U32JQ23C0020',9019969020,'',NULL,0,NULL),
('Mohammad Irfan Rajesab',330,'','B.com-3','A','U32JQ23C0018',8197340049,'',NULL,0,NULL),
('Mohammed Sami Mohammed Anwar',331,'','B.com-3','A','U32JQ23C0023',8867471889,'',NULL,0,NULL),
('Moshi Narasimhlu',332,'','B.com-3','A','U32JQ23C0076',7975113487,'',NULL,0,NULL),
('Nagaraj Lakshmana',333,'','B.com-3','A','U32JQ23C0054',8310442045,'',NULL,0,NULL),
('Nandeesha Shankrappa',334,'','B.com-3','A','U32JQ23C0007',8217772524,'',NULL,0,NULL),
('Nandini H Doddayya H',335,'','B.com-3','A','U32JQ23C0017',7026077222,'',NULL,0,NULL),
('BHIMASHANKAR ',672,'Male','M.COM-1','A','P32JQ24C012007',7411032464,'',NULL,0,NULL),
('Nitheen kumar G G chandrashekhar Gowda',337,'','B.com-3','A','U32JQ23C0078',8660277155,'',NULL,0,NULL),
('P Prem Kumar P Nelson Babu',338,'','B.com-3','A','U32JQ23C0059',8431293897,'',NULL,0,NULL),
('Pavan Kumar H Manjunath honnali',339,'','B.com-3','A','U32JQ23C0040',7899337563,'',NULL,0,NULL),
('Poshitha D Ramakrishna D',340,'','B.com-3','A','U32JQ23C0063',9036819482,'',NULL,0,NULL),
('Prasanna Virabhadrayyaswamy',341,'','B.com-3','A','U32JQ23C0027',9606087429,'',NULL,0,NULL),
('THABITHA INJYOTHI',671,'Male','M.COM-1','A','P32JQ24C012015',7204345940,'',NULL,0,NULL),
('Puttaraj Pampanna',343,'','B.com-3','A','U32JQ23C0088',829606827,'',NULL,0,NULL),
('Raghavendra Motikar Shamaraj',344,'','B.com-3','A','U32JQ23C0047',7204536528,'',NULL,0,NULL),
('Raju B Ramakrishna B',345,'','B.com-3','A','U32JQ23C0057',6360096277,'',NULL,0,NULL),
('Raju Gattu Pedda Narasimhulu',346,'','B.com-3','A','U32JQ23C0056',7026515798,'',NULL,0,NULL),
('Rakesh Kumar Mallikarjuna sherttar',347,'','B.com-3','A','U32JQ23C0062',6364590580,'',NULL,0,NULL),
('Rohit kumara T Veeresha T',348,'','B.com-3','A','U32JQ23C0001',8660391585,'',NULL,0,NULL),
('Rohitkumar Yamanoorappa',349,'','B.com-3','A','U32JQ23C0016',9972713839,'',NULL,0,NULL),
('S Mohamad Iliyas S mohammad Riyaz',350,'','B.com-3','A','U32JQ23C0032',8951504945,'',NULL,0,NULL),
('Saiteja Aily Nagaraj Aily',351,'','B.com-3','A','U32JQ23C0031',8296728124,'',NULL,0,NULL),
('Sameer Dastageer Sab',352,'','B.com-3','A','U32JQ23C0042',8310091070,'',NULL,0,NULL),
('Sameer Gulam Huseen',353,'','B.com-3','A','U32JQ23C0081',7483624013,'',NULL,0,NULL),
('Sameer Hussain Shabbir Hussain Idli',354,'','B.com-3','A','U32JQ23C0080',7795464920,'',NULL,0,NULL),
('Saniya Anwar shaiksandi Anwar',355,'','B.com-3','A','U32JQ23C0069',8105142365,'',NULL,0,NULL),
('I GRACEE',670,'Male','M.COM-1','A','P32JQ24C012002',9945430653,'',NULL,0,NULL),
('Shaheed Chandpasha',357,'','B.com-3','A','U32JQ23C0030',7892963135,'',NULL,0,NULL),
('Shantha Parusharam',358,'','B.com-3','A','U32JQ23C0003',8497075841,'',NULL,0,NULL),
('Shivakumar Erehola Nagaraj Erehola',359,'','B.com-3','A','U32JQ23C0043',9535190442,'',NULL,0,NULL),
('Shrinivas Yamanoorappa',360,'','B.com-3','A','U32JQ23C0090',7026678731,'',NULL,0,NULL),
('Sneha Shivaram',361,'','B.com-3','A','U32JQ23C0019',9036435160,'',NULL,0,NULL),
('Sonu B Bhagwan Singh L',362,'','B.com-3','A','U32JQ23C0084',9739043765,'',NULL,0,NULL),
('USHARANI SAKARAY',669,'Male','M.COM-1','A','P32JQ24C012001',9481548933,'',NULL,0,NULL),
('Srujan Sampathkumar',364,'','B.com-3','A','U32JQ23C0034',9591050546,'',NULL,0,NULL),
('Sujay CH Ramakrishna CH',365,'','B.com-3','A','U32JQ23C0097',9353006881,'',NULL,0,NULL),
('Sunil Gavisiddappa Betageri',366,'','B.com-3','A','U32JQ23C0026',8618833654,'',NULL,0,NULL),
('Sunil Kumar Malakallappa',367,'','B.com-3','A','U32JQ23C0079',8073204898,'',NULL,0,NULL),
('Sushma Palleda Nijagunappa Palleda',368,'','B.com-3','A','U32JQ23C0004',7204748675,'',NULL,0,NULL),
('Syed Mohammed Reeyan Maqbool Ahmed',369,'','B.com-3','A','U32JQ23C0060',8904747476,'',NULL,0,NULL),
('Tanveer Ahmed Mohammed Kaseem',370,'','B.com-3','A','U32JQ23C0094',6360561050,'',NULL,0,NULL),
('Thimmappa Ambayya',371,'','B.com-3','A','U32JQ23C0092',8310632181,'',NULL,0,NULL),
('S M CHAITRA ',668,'Male','M.COM-1','A','P32JQ24C012023',6361021432,'',NULL,0,NULL),
('Varadharam Malaram Patel',373,'','B.com-3','A','U32JQ23C0077',6360404227,'',NULL,0,NULL),
('Veeresh Gattu Eeranna G',374,'','B.com-3','A','U32JQ23C093',8105330690,'',NULL,0,NULL),
('Veeresh Pampapati',375,'','B.com-3','A','U32JQ23C0065',8904126624,'',NULL,0,NULL),
('Veeresh Singh Rajasingh',376,'','B.com-3','A','U32JQ23C0009',8971392709,'',NULL,0,NULL),
('Vijayakumara Sharanappa',377,'','B.com-3','A','U32JQ23C0096',9999999999,'',NULL,0,NULL),
('Vikas Soodi Kalakappa Soodi',378,'','B.com-3','A','U32JQ23C0070',6363141645,'',NULL,0,NULL),
('Vinayakumara Indresha',379,'','B.com-3','A','U32JQ23C0072',9686340492,'',NULL,0,NULL),
('Virupakshappa Bagavadir Pampapati Bagavadir',380,'','B.com-3','A','U32JQ23C0039',9902914572,'',NULL,0,NULL),
('Vishnu Venktesh',381,'','B.com-3','A','U32JQ23C0011',7975549290,'',NULL,0,NULL),
('Yashwant Patel Bhavararam',382,'','B.com-3','A','U32JQ23C0074',8618266816,'',NULL,0,NULL),
('I Premalatha ',667,'Male','M.COM-1','A','P32JQ24C012005',8088017911,'',NULL,0,NULL),
('Anjanayaih Marishyamappa',385,'','B.A-3','A','U32JQ23A0005',7022730036,'',NULL,0,NULL),
('Bhoomika',386,'','B.A-3','A','U32JQ23A0034',9019444543,'',NULL,0,NULL),
('Chaitanyakumar Veeresh',387,'','B.A-3','A','U32JQ23A0015',8197905001,'',NULL,0,NULL),
('Channabasava Mallikarjuna',389,'','B.A-3','A','U32JQ23A0022',7795965192,'',NULL,0,NULL),
('Choudki Kiranakumara Komareppa',390,'','B.A-3','A','U32JQ23A0013',7349694906,'',NULL,0,NULL),
('Darshan Parashuram',391,'','B.A-3','A','U32JQ23A0018',9972146700,'',NULL,0,NULL),
('Devaraj Durugappa',392,'','B.A-3','A','U32JQ23A0024',6361571094,'',NULL,0,NULL),
('Gadilinga Bheemanna',393,'','B.A-3','A','U32JQ23A0010',9353750356,'',NULL,0,NULL),
('J Rahul J Hanumantappa',394,'','B.A-3','A','U32JQ23A0006',6361617449,'',NULL,0,NULL),
('K Nanditha K Shantveer',395,'','B.A-3','A','U32JQ23A0021',7795179093,'',NULL,0,NULL),
('K Vinayaka Rudresh Kori',396,'','B.A-3','A','U32JQ23A0011',8431646921,'',NULL,0,NULL),
('Manjula',398,'','B.A-3','A','U32JQ23A0033',9945158127,'',NULL,0,NULL),
('Manjunath Vasappa',399,'','B.A-3','A','U32JQ23A0030',9019853152,'',NULL,0,NULL),
('Maruthi Bheemanna',400,'','B.A-3','A','U32JQ23A0001',8746035743,'',NULL,0,NULL),
('N Manoja Nagalapura Hanumantha Reddy',401,'','B.A-3','A','U32JQ23A0012',9611008144,'',NULL,0,NULL),
('N Yogesha N Mallappa',402,'','B.A-3','A','U32JQ23A0014',8861242219,'',NULL,0,NULL),
('Raghu Ramakrishna',406,'','B.A-3','A','U32JQ23A0003',8618272299,'',NULL,0,NULL),
('Ravi Ramanna',407,'','B.A-3','A','U32JQ23A0004',8792657437,'',NULL,0,NULL),
('Sathish',408,'','B.A-3','A','U32JQ23A0032',9008645402,'',NULL,0,NULL),
('Satish Bandargall',409,'','B.A-3','A','U32JQ23A0035',6362497537,'',NULL,0,NULL),
('Sharif Pampapati',410,'','B.A-3','A','U32JQ23A0025',8762242480,'',NULL,0,NULL),
('Sheedhara Anipalled Sharanabasavaraja A',411,'','B.A-3','A','U32JQ23A0016',9916010666,'',NULL,0,NULL),
('Shivamurthi Mariyappa Eragara',412,'','B.A-3','A','U32JQ23A0002',8792396319,'',NULL,0,NULL),
('Sindhu Sharanayya',415,'','B.A-3','A','U32JQ23A0019',6361333488,'',NULL,0,NULL),
('Sohil Khasimsab',416,'','B.A-3','A','U32JQ23A0020',8496024687,'',NULL,0,NULL),
('Veerendrakumar Patil Mallanagouda Patil',418,'','B.A-3','A','U32JQ23A0017',7337779873,'',NULL,0,NULL),
('Manoj Janthli Munesh Janthli',518,'','M.COM-2','A','P32JQ23C012029',9986972282,'',NULL,0,NULL),
('Lakshmee Hanamantha Hulikeri',519,'','M.COM-2','A','P32JQ23C012030',8971431470,'',NULL,0,NULL),
('G H Soubhagya Hulugappa G N',520,'','M.COM-2','A','P32JQ23C012031',9900363299,'',NULL,0,NULL),
('Abdul Samad Mahamaddavud',521,'','M.COM-2','A','P32JQ23C012032',8431049454,'',NULL,0,NULL),
('Sudha Mukkalappa',522,'','M.COM-2','A','P32JQ23C012033',6362767946,'',NULL,0,NULL),
('Shilpa Parasappa',523,'','M.COM-2','A','P32JQ23C012034',6361358397,'',NULL,0,NULL),
('Aili Mallikarjuna Aili Chandrappa',524,'','M.COM-2','A','P32JQ23C012035',9740011658,'',NULL,0,NULL),
('A Pavithra A Earanna',539,'','B.com-2','A','U32JQ24C0067',8105996609,'',NULL,0,NULL),
('A Vinayaka A Rajashekhar',540,'','B.com-2','A','U32JQ24C0063',7019527430,'',NULL,0,NULL),
('Aarthi Dhayapulle Rajesh Dhayapulle',541,'','B.com-2','A','U32JQ24C0001',9611932683,'',NULL,0,NULL),
('Adnan sameer Maibubsab bisti',542,'','B.com-2','A','U32JQ24C0025',8618579165,'',NULL,0,NULL),
('Akash Amaresha bhavikatti',543,'','B.com-2','A','U32JQ24C0046',9353519417,'',NULL,0,NULL),
('Akash Basappa',544,'','B.com-2','A','U32JQ24C0040',9632191853,'',NULL,0,NULL),
('Akashgowda hyati devaraj',545,'','B.com-2','A','U32JQ24C0030',9986271942,'',NULL,0,NULL),
('Altaf Hussainsab',546,'','B.com-2','A','U32JQ24C0027',9019557163,'',NULL,0,NULL),
('Altaf Murtuja sab',547,'','B.com-2','A','U32JQ24C0099',8050390058,'',NULL,0,NULL),
('Archana Ashoka shavi',548,'','B.com-2','A','U32JQ24C0038',8197913869,'',NULL,0,NULL),
('Arunakumar Shivamurtheppa',549,'','B.com-2','A','U32JQ24C0073',9019058580,'',NULL,0,NULL),
('Ashok Kanakaraya',550,'','B.com-2','A','U32JQ24C0019',7676199863,'',NULL,0,NULL),
('B Akshata B Mahantesh',551,'','B.com-2','A','U32JQ24C0006',8431682082,'',NULL,0,NULL),
('B Altafa B Mahammad rafi',552,'','B.com-2','A','U32JQ24C0082',8123194568,'',NULL,0,NULL),
('B Sreenivas Devendrappa',553,'','B.com-2','A','U32JQ24C0084',7337860182,'',NULL,0,NULL),
('Basavaraj Umesh Yavagal Umesh',554,'','B.com-2','A','U32JQ24C0062',8088894356,'',NULL,0,NULL),
('Bhoomika Nagar Omprakash Nagar',555,'','B.com-2','A','U32JQ24C0007',8904714994,'',NULL,0,NULL),
('Busari Kiran Kumar Busuri Ramesh',556,'','B.com-2','A','U32JQ24C0064',6363617434,'',NULL,0,NULL),
('C Vishwas C Parashuram',557,'','B.com-2','A','U32JQ24C0029',9019395275,'',NULL,0,NULL),
('Channabasava Shyamanna',558,'','B.com-2','A','U32JQ24C0037',7483660780,'',NULL,0,NULL),
('Channabasavanna Patttanashetti Mallikarjuna pattanashetti',559,'','B.com-2','A','U32JQ24C0088',6364736604,'',NULL,0,NULL),
('Channaveeresh Somashekarayya',560,'','B.com-2','A','U32JQ24C0081',9880367555,'',NULL,0,NULL),
('Darshan kumar Bettadayya',561,'','B.com-2','A','U32JQ24C0051',8660387437,'',NULL,0,NULL),
('Dinesha Basavaraj Eligara',562,'','B.com-2','A','U32JQ24C0101',9901131615,'',NULL,0,NULL),
('Drushyan Hulagappa',563,'','B.com-2','A','U32JQ24C0010',7892840409,'',NULL,0,NULL),
('G Abhishek Mallayya',564,'','B.com-2','A','U32JQ24C0015',7483485785,'',NULL,0,NULL),
('G Raghavendra G Mallikarjuna',565,'','B.com-2','A','U32JQ24C0002',9945232739,'',NULL,0,NULL),
('G Vishnu prasad Prakash gotur',566,'','B.com-2','A','U32JQ24C0005',9686761131,'',NULL,0,NULL),
('Gopala krishna Prahalad rao',567,'','B.com-2','A','U32JQ24C0053',7899322552,'',NULL,0,NULL),
('H Umesh nayaka Ramappa Hattimarada',568,'','B.com-2','A','U32JQ24C0071',7259997731,'',NULL,0,NULL),
('H Veerabhadrappa Manjunath',569,'','B.com-2','A','U32JQ24C0086',8618329819,'',NULL,0,NULL),
('Hanumantha Basavaraja',570,'','B.com-2','A','U32JQ24C0056',9972491486,'',NULL,0,NULL),
('Hanumeha Durugappa Handi',571,'','B.com-2','A','U32JQ24C0039',9964486675,'',NULL,0,NULL),
('Hemalatha Bettappa',572,'','B.com-2','A','U32JQ24C0060',6363562854,'',NULL,0,NULL),
('Hrushikesh G Raikar',573,'','B.com-2','A','U32JQ24C0091',7204781472,'',NULL,0,NULL),
('Huligemma K Nagaraja',574,'','B.com-2','A','U32JQ24C0090',7760046228,'',NULL,0,NULL),
('Imam Riyazuddin',575,'','B.com-2','A','U32JQ24C0050',9880876811,'',NULL,0,NULL),
('J Sriram J Nagaraj',576,'','B.com-2','A','U32JQ24C0061',8618944008,'',NULL,0,NULL),
('Jeevan jain Arvind kumar',577,'','B.com-2','A','U32JQ24C0054',6363092530,'',NULL,0,NULL),
('K Chetan kumar K Ramesh',578,'','B.com-2','A','U32JQ24C0028',9902080637,'',NULL,0,NULL),
('K Sai Charan Laxmi Narayana',579,'','B.com-2','A','U32JQ24C0074',7676390819,'',NULL,0,NULL),
('Karthik Hanumanthappa',580,'','B.com-2','A','U32JQ24C0077',9844849807,'',NULL,0,NULL),
('Karthik p Shivaputra',581,'','B.com-2','A','U32JQ24C0042',9902431157,'',NULL,0,NULL),
('Karthika Channalli Siddappa',582,'','B.com-2','A','U32JQ24C0003',8792336033,'',NULL,0,NULL),
('M Abubakar M M Hussain',583,'','B.com-2','A','U32JQ24C0093',9110647551,'',NULL,0,NULL),
('M Akash M Shankarappa',584,'','B.com-2','A','U32JQ24C0004',9353445504,'',NULL,0,NULL),
('M Anand M Sharanappa',585,'','B.com-2','A','U32JQ24C0024',8951364473,'',NULL,0,NULL),
('Mahmad Juber hundekar Mahmad Junedali hundekar',586,'','B.com-2','A','U32JQ24C0008',9164138994,'',NULL,0,NULL),
('Mallanagouda M P Muddanagouda M P',587,'','B.com-2','A','U32JQ24C0023',6363241464,'',NULL,0,NULL),
('Mallesh Virupanna',588,'','B.com-2','A','U32JQ24C0076',9880859642,'',NULL,0,NULL),
('Mallikarjuna swami Ayyappaswami hirematha',589,'','B.com-2','A','U32JQ24C0035',7892399343,'',NULL,0,NULL),
('Manjunatha Karadi Durgappa',590,'','B.com-2','A','U32JQ24C0092',9353063484,'',NULL,0,NULL),
('Manoj venkata gupta Gunda venkata satya narayana',591,'','B.com-2','A','U32JQ24C0021',9449995782,'',NULL,0,NULL),
('Manthan chopra Mahaveer chopra',592,'','B.com-2','A','U32JQ24C0055',9113062384,'',NULL,0,NULL),
('MD Ashwal Umar sab',593,'','B.com-2','A','U32JQ24C0096',8971392725,'',NULL,0,NULL),
('Meheboobsaba Husenpeera karadona',594,'','B.com-2','A','U32JQ24C0052',6363162654,'',NULL,0,NULL),
('Meher thabusum Mohammed rafi',595,'','B.com-2','A','U32JQ24C0041',7338494961,'',NULL,0,NULL),
('Mohammad Gouse S Syed rafiq',596,'','B.com-2','A','U32JQ24C0016',6363770705,'',NULL,0,NULL),
('N Kartik N Basavaraj',597,'','B.com-2','A','U32JQ24C0069',7204959483,'',NULL,0,NULL),
('Nuzhat anjum Javeed',598,'','B.com-2','A','U32JQ24C0026',7676874075,'',NULL,0,NULL),
('Pavan kumar Dattatreya',599,'','B.com-2','A','U32JQ24C0070',9945618253,'',NULL,0,NULL),
('Prajwal Rajashekar',600,'','B.com-2','A','U32JQ24C0032',7975764861,'',NULL,0,NULL),
('Prashantha Basavaraj',601,'','B.com-2','A','U32JQ24C0043',6362330665,'',NULL,0,NULL),
('Prashanti Prasad babu',602,'','B.com-2','A','U32JQ24C0075',9035661196,'',NULL,0,NULL),
('Punith gouli Anand',603,'','B.com-2','A','U32JQ24C0014',9632551054,'',NULL,0,NULL),
('Raghavenda Ayli Venkatesh Ayli',604,'','B.com-2','A','U32JQ24C0095',7975912565,'',NULL,0,NULL),
('Rahul G Raghavendra G',605,'','B.com-2','A','U32JQ24C0083',9482238238,'',NULL,0,NULL),
('Rakesh j Ashok jadhav',606,'','B.com-2','A','U32JQ24C0066',9945547339,'',NULL,0,NULL),
('Rizawana Maheboobsab',607,'','B.com-2','A','U32JQ24C0085',9901712913,'',NULL,0,NULL),
('Rudrappa Manjunath',608,'','B.com-2','A','U32JQ24C0020',8431337217,'',NULL,0,NULL),
('S Manjunath S Nirupadi',609,'','B.com-2','A','U32JQ24C0034',9019967922,'',NULL,0,NULL),
('S Sanjeev kumar S Gopal',610,'','B.com-2','A','U32JQ24C0018',6361766953,'',NULL,0,NULL),
('Sameer Gouse pasha',611,'','B.com-2','A','U32JQ24C0044',7019257073,'',NULL,0,NULL),
('Sannaveerappa kataginahalli Sharanappa',612,'','B.com-2','A','U32JQ24C0045',8095112830,'',NULL,0,NULL),
('Shamkumar Nagraj',613,'','B.com-2','A','U32JQ24C0033',8296980022,'',NULL,0,NULL),
('Sharanabasava Basavaraj',614,'','B.com-2','A','U32JQ24C0031',8050466481,'',NULL,0,NULL),
('Shekarappa Metri Ramesh',615,'','B.com-2','A','U32JQ24C0072',8310390361,'',NULL,0,NULL),
('Shivakumar Gururaj Hosagollar',616,'','B.com-2','A','U32JQ24C0097',9148358748,'',NULL,0,NULL),
('Shivaraja b Basavaraja',617,'','B.com-2','A','U32JQ24C0022',7676422355,'',NULL,0,NULL),
('Shivasharana Arathi Eswar Arathi',618,'','B.com-2','A','U32JQ24C0009',8073228092,'',NULL,0,NULL),
('Siddalingesh Shrisailappa',619,'','B.com-2','A','U32JQ24C0078',8431669113,'',NULL,0,NULL),
('Siddanagouda danashetty Mukkanna',620,'','B.com-2','A','U32JQ24C0048',9538462089,'',NULL,0,NULL),
('Sohil Hussain Hussain Sab',621,'','B.com-2','A','U32JQ24C0098',7760453219,'',NULL,0,NULL),
('Sohil Moulasab',622,'','B.com-2','A','U32JQ24C0059',9972839193,'',NULL,0,NULL),
('Sreenivas Anjanappa',623,'','B.com-2','A','U32JQ24C0068',8618708573,'',NULL,0,NULL),
('Surekha Bojaraj',624,'','B.com-2','A','U32JQ24C0057',8328604997,'',NULL,0,NULL),
('Swathi Shankarappa',625,'','B.com-2','A','U32JQ24C0058',7795538032,'',NULL,0,NULL),
('T Pavan Siddarth T Srinivas Rao',626,'','B.com-2','A','U32JQ24C0100',8310548502,'',NULL,0,NULL),
('Uma lingadahalli Ningappa Lingadahalli',627,'','B.com-2','A','U32JQ24C0011',7338099590,'',NULL,0,NULL),
('Umar Farooq Mohammed Davud',628,'','B.com-2','A','U32JQ24C0012',9380926823,'',NULL,0,NULL),
('Uppar Sangeetha Nagaraja U',629,'','B.com-2','A','U32JQ24C0065',6366205266,'',NULL,0,NULL),
('Vikas A P Prashanth',630,'','B.com-2','A','U32JQ24C0079',8660649911,'',NULL,0,NULL),
('Vikas Krishnappa',631,'','B.com-2','A','U32JQ24C0017',7483726893,'',NULL,0,NULL),
('Vikas Mahantesh',632,'','B.com-2','A','U32JQ24C0087',9740749304,'',NULL,0,NULL),
('Vinay kumar Viroopakshi gotur',633,'','B.com-2','A','U32JQ24C0013',8431307632,'',NULL,0,NULL),
('Vinay Manikyappa',634,'','B.com-2','A','U32JQ24C0036',8197787911,'',NULL,0,NULL),
('Vinayakumar reddy',635,'','B.com-2','A','U32JQ24C0080',7019702176,'',NULL,0,NULL),
('Yamanoor Parashurama',636,'','B.com-2','A','U32JQ24C0047',9686461172,'',NULL,0,NULL),
('Yankana gouda Devendrappa goudar',637,'','B.com-2','A','U32JQ24C0049',6363136054,'',NULL,0,NULL),
('Yusuf Shamid',638,'','B.com-2','A','U32JQ24C0094',8867553561,'',NULL,0,NULL),
('Zuber Pasha Afzal Pasha',639,'','B.com-2','A','U32JQ24C0089',9108020936,'',NULL,0,NULL),
('RAKSHITHA JANTLI',675,'Male','M.COM-1','A','P32JQ24C012009',7411794670,'',NULL,0,NULL),
('SHASHIKALA',676,'Male','M.COM-1','A','P32JQ24C012003',8296679827,'',NULL,0,NULL),
('NIVEDITHA ',677,'Male','M.COM-1','A','P32JQ24C012010',9663713641,'',NULL,0,NULL),
('NANDINI BALAGERI ',678,'Male','M.COM-1','A','P32JQ24C012008',8884787410,'',NULL,0,NULL),
('RAVI ',679,'Male','M.COM-1','A','P32JQ24C012013',8088251172,'',NULL,0,NULL),
('SANTOSH',680,'Male','M.COM-1','A','P32JQ24C012006',7892229299,'',NULL,0,NULL),
('K NAGAVENI ',681,'Male','M.COM-1','A','P32JQ24C012031',8867055149,'',NULL,0,NULL),
('RAKSHA JAIN',682,'Male','M.COM-1','A','P32JQ24C012014',9449901373,'',NULL,0,NULL),
('AMBANNA ',683,'Male','M.COM-1','A','P32JQ24C012004',9353668161,'',NULL,0,NULL),
('USMAN KHAN ',684,'Male','M.COM-1','A','P32JQ24C012012',9972452917,'',NULL,0,NULL),
('NAYAKARA LINGARAJA ',685,'Male','M.COM-1','A','P32JQ24C012017',9986389924,'',NULL,0,NULL),
('HANEEFABANU',686,'Male','M.COM-1','A','P32JQ24C012020',7411279759,'',NULL,0,NULL),
('MAHESHA ALADGIDA',687,'Male','M.COM-1','A','P32JQ24C012019',7975804375,'',NULL,0,NULL),
('VIDYA ',688,'Male','M.COM-1','A','P32JQ24C012024',7019328184,'',NULL,0,NULL),
('ERANNA K',689,'Male','M.COM-1','A','P32JQ24C012030',7760678868,'',NULL,0,NULL),
('RANJEETHA SAGAR ',690,'Male','M.COM-1','A','P32JQ24C012018',9482078752,'',NULL,0,NULL),
('ANJUM',691,'Male','M.COM-1','A','P32JQ24C012022',7676106612,'',NULL,0,NULL),
('K JAGADEESHA ',692,'Male','M.COM-1','A','P32JQ24C012034',6360023075,'',NULL,0,NULL),
('VEERANAGOUDA CHIKKANAGOUDRU',693,'Male','M.COM-1','A','P32JQ24C012025',8722838586,'',NULL,0,NULL),
('ANUSH DANDIN ',694,'Male','M.COM-1','A','P32JQ24C012026',9743769687,'',NULL,0,NULL),
('K SIDDU ',695,'Male','M.COM-1','A','P32JQ24C012027',9741852089,'',NULL,0,NULL),
('LATHA S ',696,'Male','M.COM-1','A','P32JQ24C012028',8296740751,'',NULL,0,NULL),
('H BHARATHI ',697,'Male','M.COM-1','A','P32JQ24C012029',9741528047,'',NULL,0,NULL),
('CHANNABASAVA',698,'Male','M.COM-1','A','P32JQ24C012032',6363050427,'',NULL,0,NULL),
('VAISHNAVI H ',699,'Male','M.COM-1','A','P32JQ24C012033',6363877977,'',NULL,0,NULL);
/*!40000 ALTER TABLE `stud_basic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic2`
--
DROP TABLE IF EXISTS `stud_basic2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic2` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discount` bigint(20) NOT NULL,
`discription` varchar(200) NOT NULL,
`year` varchar(20) DEFAULT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM 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 */;
/*!40000 ALTER TABLE `stud_basic2` 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=21 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
('GOVERNMENT FEES',1,'1340','N'),
('UNIVERSITY FEES',2,'2090','N'),
('COLLEGE FEES',3,'860','N'),
('COLLEGE DEVELOPMENT FUND',4,'1200','N'),
('COLLEGE DEVELOPMENT FUND',5,'2000','N'),
('GUEST LECTURE FEES',6,'5120','N'),
('COMPUTER FEES',7,'1000','N'),
('GUEST LECTURE FEES',8,'7000','N'),
('VI SEM FEES',9,'2600','N'),
('IV SEM FEES',10,'2800','N'),
('GUEST LECTURE FEES',11,'5250','N'),
('devolpment fees',12,'40000','N'),
('GUEST LECTURE FEES',13,'1310','N'),
('GUEST LECTURE FEES ',14,'1110','N'),
('COLLEGE DEVELOPMENT FUND',15,'1200','N'),
('GUEST LECTURER FEES ',16,'5000','N'),
('GUEST LECTURER FEES ',17,'4850','N'),
('GUEST LECTURER FEES ',18,'2310','N'),
('GUEST LECTURER FEES ',19,'15750','N'),
('GUEST LECTURER FEES ',20,'3800','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`),
KEY `deletesubquery` (`categoryid`),
CONSTRAINT `deletesubquery` FOREIGN KEY (`categoryid`) REFERENCES `category` (`categoryid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbladmin`
--
LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblbrand`
--
DROP TABLE IF EXISTS `tblbrand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblbrand` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BrandName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblbrand`
--
LOCK TABLES `tblbrand` WRITE;
/*!40000 ALTER TABLE `tblbrand` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblbrand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcart`
--
DROP TABLE IF EXISTS `tblcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcart` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductId` int(5) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`ProductQty` int(11) DEFAULT NULL,
`IsCheckOut` int(5) DEFAULT NULL,
`CartDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcart`
--
LOCK TABLES `tblcart` WRITE;
/*!40000 ALTER TABLE `tblcart` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcategory`
--
DROP TABLE IF EXISTS `tblcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategory`
--
LOCK TABLES `tblcategory` WRITE;
/*!40000 ALTER TABLE `tblcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcustomer`
--
DROP TABLE IF EXISTS `tblcustomer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcustomer` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BillingNumber` varchar(120) DEFAULT NULL,
`CustomerName` varchar(120) DEFAULT NULL,
`MobileNumber` bigint(11) DEFAULT NULL,
`ModeofPayment` varchar(50) DEFAULT NULL,
`BillingDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`),
KEY `BillingNumber` (`BillingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcustomer`
--
LOCK TABLES `tblcustomer` WRITE;
/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblproducts`
--
DROP TABLE IF EXISTS `tblproducts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblproducts` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(200) DEFAULT NULL,
`CatID` int(5) DEFAULT NULL,
`SubcatID` int(5) DEFAULT NULL,
`BrandName` varchar(200) DEFAULT NULL,
`ModelNumber` varchar(200) DEFAULT NULL,
`Stock` int(10) DEFAULT NULL,
`Price` decimal(10,0) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblproducts`
--
LOCK TABLES `tblproducts` WRITE;
/*!40000 ALTER TABLE `tblproducts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblproducts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblsubcategory`
--
DROP TABLE IF EXISTS `tblsubcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblsubcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CatID` int(5) DEFAULT NULL,
`SubCategoryname` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblsubcategory`
--
LOCK TABLES `tblsubcategory` WRITE;
/*!40000 ALTER TABLE `tblsubcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`transactionid`)
) 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=188 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,85,'class_division',1),
(2,85,'head',1),
(3,85,'update_student',1),
(4,85,'pay_fees',1),
(5,85,'balance_reports',1),
(6,85,'discount',1),
(7,85,'fees_receipt_head',1),
(8,85,'apply_fees_code',1),
(9,85,'payment_approve',1),
(10,85,'bank',1),
(11,85,'new_student',1),
(12,85,'remove_fees_code',1),
(13,85,'daily_reports',1),
(14,85,'utility',1),
(15,86,'class_division',1),
(16,86,'head',1),
(17,80,'update_student',1),
(18,80,'pay_fees',1),
(19,80,'balance_reports',1),
(20,80,'sub_head',1),
(21,80,'fees_receipt_head',1),
(22,80,'apply_fees_code',1),
(23,80,'payment_approve',1),
(24,80,'new_student',1),
(25,80,'remove_fees_code',1),
(26,80,'daily_reports',1),
(28,80,'update_student',1),
(29,80,'pay_fees',1),
(30,80,'balance_reports',1),
(32,80,'apply_fees_code',1),
(33,80,'payment_approve',1),
(34,80,'inventory',1),
(35,80,'bank',1),
(36,80,'new_student',1),
(37,80,'remove_fees_code',1),
(38,80,'daily_reports',1),
(39,80,'utility',1),
(40,76,'class_division',1),
(41,76,'head',1),
(42,76,'update_student',1),
(43,76,'pay_fees',1),
(44,76,'balance_reports',1),
(45,76,'discount',1),
(46,76,'sub_head',1),
(47,76,'fees_receipt_head',1),
(48,76,'apply_fees_code',1),
(49,76,'payment_approve',1),
(50,76,'inventory',1),
(51,76,'bank',1),
(52,76,'new_student',1),
(53,76,'remove_fees_code',1),
(54,76,'daily_reports',1),
(55,76,'utility',1),
(56,76,'class_division',1),
(57,76,'head',1),
(58,76,'update_student',1),
(59,76,'pay_fees',1),
(60,76,'balance_reports',1),
(61,76,'discount',1),
(62,76,'fees_receipt_head',1),
(63,76,'apply_fees_code',1),
(64,76,'payment_approve',1),
(65,76,'bank',1),
(66,76,'new_student',1),
(67,76,'remove_fees_code',1),
(68,76,'daily_reports',1),
(69,76,'utility',1),
(70,76,'class_division',1),
(71,76,'head',1),
(72,76,'update_student',1),
(73,76,'pay_fees',1),
(74,76,'balance_reports',1),
(75,76,'sub_head',1),
(76,76,'fees_receipt_head',1),
(77,76,'apply_fees_code',1),
(78,76,'payment_approve',1),
(79,76,'new_student',1),
(80,76,'remove_fees_code',1),
(81,76,'class_division',1),
(82,76,'head',1),
(83,76,'update_student',1),
(84,76,'pay_fees',1),
(85,76,'balance_reports',1),
(86,76,'discount',1),
(87,76,'fees_receipt_head',1),
(88,76,'apply_fees_code',1),
(89,76,'payment_approve',1),
(90,76,'bank',1),
(91,76,'new_student',1),
(92,76,'remove_fees_code',1),
(93,76,'daily_reports',1),
(94,76,'utility',1),
(95,76,'class_division',1),
(96,76,'head',1),
(97,90,'class_division',1),
(98,90,'update_student',1),
(99,90,'pay_fees',1),
(100,90,'balance_reports',1),
(101,90,'fees_receipt_head',1),
(102,90,'apply_fees_code',1),
(103,90,'payment_approve',1),
(104,90,'inventory',1),
(105,90,'bank',1),
(106,90,'new_student',1),
(107,90,'remove_fees_code',1),
(108,90,'daily_reports',1),
(109,90,'utility',1),
(110,91,'class_division',1),
(111,91,'head',1),
(112,91,'update_student',1),
(113,91,'pay_fees',1),
(114,91,'balance_reports',1),
(115,91,'discount',1),
(116,91,'sub_head',1),
(117,91,'fees_receipt_head',1),
(118,91,'apply_fees_code',1),
(119,91,'payment_approve',1),
(120,91,'inventory',1),
(121,91,'bank',1),
(122,91,'new_student',1),
(123,91,'remove_fees_code',1),
(124,91,'daily_reports',1),
(125,91,'utility',1),
(126,92,'class_division',1),
(127,92,'update_student',1),
(128,92,'pay_fees',1),
(129,92,'balance_reports',1),
(130,92,'fees_receipt_head',1),
(131,92,'payment_approve',1),
(132,92,'inventory',1),
(133,92,'bank',1),
(134,92,'new_student',1),
(135,92,'daily_reports',1),
(136,92,'utility',1),
(137,93,'class_division',1),
(138,93,'head',1),
(139,93,'update_student',1),
(140,93,'pay_fees',1),
(141,93,'balance_reports',1),
(142,93,'discount',1),
(143,93,'sub_head',1),
(144,93,'fees_receipt_head',1),
(145,93,'apply_fees_code',1),
(146,93,'payment_approve',1),
(147,93,'inventory',1),
(148,93,'bank',1),
(149,93,'new_student',1),
(150,93,'remove_fees_code',1),
(151,93,'daily_reports',1),
(152,93,'utility',1),
(153,94,'class_division',1),
(154,94,'update_student',1),
(155,94,'pay_fees',1),
(156,94,'balance_reports',1),
(157,94,'sub_head',1),
(158,94,'payment_approve',1),
(159,94,'bank',1),
(160,94,'new_student',1),
(161,94,'daily_reports',1),
(162,95,'class_division',1),
(163,95,'head',1),
(164,95,'update_student',1),
(165,95,'pay_fees',1),
(166,95,'balance_reports',1),
(167,95,'payment_approve',1),
(168,95,'inventory',1),
(169,95,'bank',1),
(170,95,'new_student',1),
(171,95,'daily_reports',1),
(172,95,'utility',1),
(173,96,'class_division',1),
(174,96,'head',1),
(175,96,'update_student',1),
(176,96,'pay_fees',1),
(177,96,'balance_reports',1),
(178,96,'sub_head',1),
(179,96,'fees_receipt_head',1),
(180,96,'apply_fees_code',1),
(181,96,'payment_approve',1),
(182,96,'inventory',1),
(183,96,'bank',1),
(184,96,'new_student',1),
(185,96,'remove_fees_code',1),
(186,96,'daily_reports',1),
(187,96,'utility',1);
/*!40000 ALTER TABLE `user_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usermanagement`
--
DROP TABLE IF EXISTS `usermanagement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usermanagement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usermanagement`
--
LOCK TABLES `usermanagement` WRITE;
/*!40000 ALTER TABLE `usermanagement` DISABLE KEYS */;
/*!40000 ALTER TABLE `usermanagement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` char(64) NOT NULL,
`salt` char(16) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`passwordText` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=97 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
(91,'GHNC','b9a3b293f112bf4d73f212a38540e6691db79e5a77a44c89cbfc665474dd43ca','1648e1ac16e759d9',NULL,'Fees_Management','Ghnccg@1'),
(93,'manju','40a1f17d98c404e18b4d38c26b8519f970e45c43396b64cdaa062ec1eb3ba556','1ad8327c3f412a07',NULL,'Fees_Management','Manju@1432'),
(96,'Adminfees','d03d9312ef241397c3653734608b26e4c1640df148fc10a982aebe308e654d2b','7ade6cb81eb60e46',NULL,'Fees_Management','GHNcollege@123');
/*!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=2 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,'admin123@example.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','6cXBHMLlRQPxXILlWtnvUBNr6D2Urs28n8swddb7h0oUc1O7foyDnscMe2Vf','0000-00-00 00:00:00','0000-00-00 00:00:00');
/*!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 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 */;
/*!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:26