|
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/../KPCM/../svgkp/ |
| [ 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_svgkp_Fees
-- ------------------------------------------------------
-- Server version 10.11.10-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Receipt_Head`
--
DROP TABLE IF EXISTS `Receipt_Head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Receipt_Head` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Section` varchar(1000) DEFAULT NULL,
`Head1` varchar(1000) DEFAULT NULL,
`Head2` varchar(1000) DEFAULT NULL,
`Head3` varchar(1000) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Receipt_Head`
--
LOCK TABLES `Receipt_Head` WRITE;
/*!40000 ALTER TABLE `Receipt_Head` DISABLE KEYS */;
INSERT INTO `Receipt_Head` VALUES
(1,'SCHOOL ','SMT VALISHETRU GANGAMMA GURUPADAPPA POORVA PRATHAMIKA SHALE','KAMPLI','');
/*!40000 ALTER TABLE `Receipt_Head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
`accountid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`accountnumber` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account`
--
LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_accounts`
--
DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`passwd` varchar(50) NOT NULL,
`admin_type` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_accounts`
--
LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bankaccounts`
--
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Bank_Name` varchar(1000) NOT NULL,
`IFSC` varchar(1000) NOT NULL,
`Account_Number` varchar(1000) NOT NULL,
`AccountHolderName` varchar(1000) NOT NULL,
`PayuKey` bigint(20) NOT NULL,
`SaltKey` bigint(20) NOT NULL,
`MerchantKey` bigint(20) NOT NULL,
`AccountType` varchar(1000) NOT NULL,
`Link` varchar(10000) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bankaccounts`
--
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES
(1,'VARALAXMI ','','1539','pre primary school ',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=3 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
('Aruna ',1,NULL),
('Udaya',2,NULL);
/*!40000 ALTER TABLE `class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `commission`
--
DROP TABLE IF EXISTS `commission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commission` (
`Commission` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `commission`
--
LOCK TABLES `commission` WRITE;
/*!40000 ALTER TABLE `commission` DISABLE KEYS */;
/*!40000 ALTER TABLE `commission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
`id1` int(10) NOT NULL AUTO_INCREMENT,
`f_name` varchar(25) NOT NULL,
`l_name` varchar(25) NOT NULL,
`gender` varchar(6) NOT NULL,
`address` varchar(100) DEFAULT NULL,
`city` varchar(15) NOT NULL,
`state` varchar(30) NOT NULL,
`phone` varchar(15) NOT NULL,
`email` varchar(50) NOT NULL,
`date_of_birth` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customers`
--
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `division`
--
DROP TABLE IF EXISTS `division`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `division` (
`Name` varchar(100) NOT NULL,
`Div_Id` int(11) NOT NULL AUTO_INCREMENT,
`Discription` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Div_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `division`
--
LOCK TABLES `division` WRITE;
/*!40000 ALTER TABLE `division` DISABLE KEYS */;
INSERT INTO `division` VALUES
('a',1,NULL);
/*!40000 ALTER TABLE `division` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goals`
--
DROP TABLE IF EXISTS `goals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goals` (
`goalsid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`accountid` int(5) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`balance` decimal(10,2) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`deposit` decimal(10,2) NOT NULL,
`deadline` date NOT NULL,
PRIMARY KEY (`goalsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goals`
--
LOCK TABLES `goals` WRITE;
/*!40000 ALTER TABLE `goals` DISABLE KEYS */;
/*!40000 ALTER TABLE `goals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `head`
--
DROP TABLE IF EXISTS `head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `head` (
`Name` varchar(1000) NOT NULL,
`Head_Id` int(11) NOT NULL AUTO_INCREMENT,
`SubHeads` varchar(1000) NOT NULL,
`Last_Date` date NOT NULL,
`One_Time_Payment` varchar(100) NOT NULL,
`Fine_Amount` varchar(100) NOT NULL,
`Bank_Code` varchar(10) NOT NULL,
`ReciptName` varchar(1000) NOT NULL,
PRIMARY KEY (`Head_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 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
('Tuition Fee',1,'1','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=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ledger`
--
LOCK TABLES `ledger` WRITE;
/*!40000 ALTER TABLE `ledger` DISABLE KEYS */;
INSERT INTO `ledger` VALUES
('TUITION FEE ',1,'Income/Revenue'),
('VARALAXMI -1539',2,'Current Assets'),
('VARALAXMI -1539',3,'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 AUTO_INCREMENT=127 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
(2,257,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1','/1000','2024-05-30','Cash','1811',0,0,1000,1000,1,'adminFees302',NULL),
(3,250,'SCHL-2',2,'SCHL','SCHL-2',2,'1','/1','/1000','2024-05-31','Cash','1812',0,0,1000,1000,1,'adminFees302',NULL),
(4,146,'SCHL-3',3,'SCHL','SCHL-3',3,'1','/1','/1200','2024-05-31','Cash','1813',0,0,1200,1200,1,'adminFees302',NULL),
(5,166,'SCHL-4',4,'SCHL','SCHL-4',4,'1','/1','/1000','2024-06-03','Cash','1814',0,0,1000,1000,1,'adminFees302',NULL),
(7,167,'SCHL-5',5,'SCHL','SCHL-5',5,'1','/1','/1000','2024-06-03','Cash','1815',0,0,1000,1000,1,'adminFees302',NULL),
(8,165,'SCHL-6',6,'SCHL','SCHL-6',6,'1','/1','/500','2024-06-03','Cash','1816',0,0,500,500,1,'adminFees302',NULL),
(9,172,'SCHL-7',7,'SCHL','SCHL-7',7,'1','/1','/1000','2024-06-04','Cash','1817',0,0,1000,1000,1,'adminFees302',NULL),
(10,189,'SCHL-8',8,'SCHL','SCHL-8',8,'1','/1','/900','2024-06-04','Cash','1818',0,0,900,900,1,'adminFees302',NULL),
(11,174,'SCHL-9',9,'SCHL','SCHL-9',9,'1','/1','/1500','2024-06-05','Cash','1819',0,0,1500,1500,1,'adminFees302',NULL),
(12,213,'SCHL-10',10,'SCHL','SCHL-10',10,'1','/1','/1500','2024-06-05','Cash','1820',0,0,1500,1500,1,'adminFees302',NULL),
(13,188,'SCHL-11',11,'SCHL','SCHL-11',11,'1','/1','/1000','2024-06-05','Cash','1821',0,0,1000,1000,1,'adminFees302',NULL),
(14,164,'SCHL-12',12,'SCHL','SCHL-12',12,'1','/1','/1000','2024-06-05','Cash','1822',0,0,1000,1000,1,'adminFees302',NULL),
(15,241,'SCHL-13',13,'SCHL','SCHL-13',13,'1','/1','/500','2024-06-05','Cash','1823',0,0,500,500,1,'adminFees302',NULL),
(16,187,'SCHL-14',14,'SCHL','SCHL-14',14,'1','/1','/1000','2024-06-05','Cash','1824',0,0,1000,1000,1,'adminFees302',NULL),
(17,249,'SCHL-15',15,'SCHL','SCHL-15',15,'1','/1','/700','2024-06-05','Cash','1825',0,0,700,700,1,'adminFees302',NULL),
(18,163,'SCHL-16',16,'SCHL','SCHL-16',16,'1','/1','/1000','2024-06-05','Cash','1826',0,0,1000,1000,1,'adminFees302',NULL),
(19,258,'SCHL-17',17,'SCHL','SCHL-17',17,'1','/1','/1000','2024-06-05','Cash','1827',0,0,1000,1000,1,'adminFees302',NULL),
(20,162,'SCHL-18',18,'SCHL','SCHL-18',18,'1','/1','/1000','2024-06-06','Cash','1828',0,0,1000,1000,1,'adminFees302',NULL),
(21,226,'SCHL-19',19,'SCHL','SCHL-19',19,'1','/1','/1000','2024-06-06','Cash','1829',0,0,1000,1000,1,'adminFees302',NULL),
(22,161,'SCHL-20',20,'SCHL','SCHL-20',20,'1','/1','/1200','2024-06-07','Cash','1830',0,0,1200,1200,1,'adminFees302',NULL),
(23,186,'SCHL-21',21,'SCHL','SCHL-21',21,'1','/1','/1000','2024-06-07','Cash','1831',0,0,1000,1000,1,'adminFees302',NULL),
(24,160,'SCHL-22',22,'SCHL','SCHL-22',22,'1','/1','/1000','2024-06-07','Cash','1832',0,0,1000,1000,1,'adminFees302',NULL),
(25,159,'SCHL-23',23,'SCHL','SCHL-23',23,'1','/1','/1000','2024-06-08','Cash','1833',0,0,1000,1000,1,'adminFees302',NULL),
(26,184,'SCHL-24',24,'SCHL','SCHL-24',24,'1','/1','/1200','2024-06-08','Cash','1834',0,0,1200,1200,1,'adminFees302',NULL),
(27,185,'SCHL-25',25,'SCHL','SCHL-25',25,'1','/1','/1000','2024-06-08','Cash','1835',0,0,1000,1000,1,'adminFees302',NULL),
(28,183,'SCHL-26',26,'SCHL','SCHL-26',26,'1','/1','/500','2024-06-08','Cash','1836',0,0,500,500,1,'adminFees302',NULL),
(29,208,'SCHL-27',27,'SCHL','SCHL-27',27,'1','/1','/1000','2024-06-08','Cash','1837',0,0,1000,1000,1,'adminFees302',NULL),
(30,175,'SCHL-28',28,'SCHL','SCHL-28',28,'1','/1','/1000','2024-08-06','Cash','1838',0,0,1000,1000,1,'adminFees302',NULL),
(31,173,'SCHL-29',29,'SCHL','SCHL-29',29,'1','/1','/1000','2024-06-10','Cash','1839',0,0,1000,1000,1,'adminFees302',NULL),
(32,228,'SCHL-30',30,'SCHL','SCHL-30',30,'1','/1','/1200','2024-06-10','Cash','1840',0,0,1200,1200,1,'adminFees302',NULL),
(33,158,'SCHL-31',31,'SCHL','SCHL-31',31,'1','/1','/1100','2024-06-10','Cash','1841',0,0,1100,1100,1,'adminFees302',NULL),
(34,251,'SCHL-32',32,'SCHL','SCHL-32',32,'1','/1','/1200','2024-06-10','Cash','1842',0,0,1200,1200,1,'adminFees302',NULL),
(35,182,'SCHL-33',33,'SCHL','SCHL-33',33,'1','/1','/2000','2024-06-10','Cash','1843',0,0,2000,2000,1,'adminFees302',NULL),
(36,233,'SCHL-34',34,'SCHL','SCHL-34',34,'1','/1','/1000','2024-06-10','Cash','1844',0,0,1000,1000,1,'adminFees302',NULL),
(37,148,'SCHL-35',35,'SCHL','SCHL-35',35,'1','/1','/1000','2024-06-10','Cash','1845',0,0,1000,1000,1,'adminFees302',NULL),
(38,180,'SCHL-36',36,'SCHL','SCHL-36',36,'1','/1','/500','2024-06-10','Cash','1846',0,0,500,500,1,'adminFees302',NULL),
(39,195,'SCHL-37',37,'SCHL','SCHL-37',37,'1','/1','/500','2024-06-11','Cash','1847',0,0,500,500,1,'adminFees302',NULL),
(40,194,'SCHL-38',38,'SCHL','SCHL-38',38,'1','/1','/1500','2024-06-11','Cash','1848',0,0,1500,1500,1,'adminFees302',NULL),
(41,181,'SCHL-39',39,'SCHL','SCHL-39',39,'1','/1','/2200','2024-06-11','Cash','1849',0,0,2200,2200,1,'adminFees302',NULL),
(42,242,'SCHL-40',40,'SCHL','SCHL-40',40,'1','/1','/1000','2024-06-11','Cash','1850',0,0,1000,1000,1,'adminFees302',NULL),
(43,245,'SCHL-41',41,'SCHL','SCHL-41',41,'1','/1','/1500','2024-06-11','Cash','1851',0,0,1500,1500,1,'adminFees302',NULL),
(44,179,'SCHL-42',42,'SCHL','SCHL-42',42,'1','/1','/1000','2024-06-11','Cash','1852',0,0,1000,1000,1,'adminFees302',NULL),
(45,209,'SCHL-43',43,'SCHL','SCHL-43',43,'1','/1','/1000','2024-06-12','Cash','1853',0,0,1000,1000,1,'adminFees302',NULL),
(46,198,'SCHL-44',44,'SCHL','SCHL-44',44,'1','/1','/2000','2024-06-12','Cash','1854',0,0,2000,2000,1,'adminFees302',NULL),
(47,203,'SCHL-45',45,'SCHL','SCHL-45',45,'1','/1','/1100','2024-06-12','Cash','1855',0,0,1100,1100,1,'adminFees302',NULL),
(48,218,'SCHL-46',46,'SCHL','SCHL-46',46,'1','/1','/1000','2024-06-12','Cash','1856',0,0,1000,1000,1,'adminFees302',NULL),
(49,156,'SCHL-47',47,'SCHL','SCHL-47',47,'1','/1','/1000','2024-06-12','Cash','1857',0,0,1000,1000,1,'adminFees302',NULL),
(50,223,'SCHL-48',48,'SCHL','SCHL-48',48,'1','/1','/1000','2024-06-13','Cash','1858',0,0,1000,1000,1,'adminFees302',NULL),
(51,157,'SCHL-49',49,'SCHL','SCHL-49',49,'1','/1','/1000','2024-06-13','Cash','1859',0,0,1000,1000,1,'adminFees302',NULL),
(52,244,'SCHL-50',50,'SCHL','SCHL-50',50,'1','/1','/500','2024-06-14','Cash','1860',0,0,500,500,1,'adminFees302',NULL),
(53,206,'SCHL-51',51,'SCHL','SCHL-51',51,'1','/1','/1000','2024-06-19','Cash','1861',0,0,1000,1000,1,'adminFees302',NULL),
(54,155,'SCHL-52',52,'SCHL','SCHL-52',52,'1','/1','/1000','2024-06-19','Cash','1862',0,0,1000,1000,1,'adminFees302',NULL),
(55,215,'SCHL-53',53,'SCHL','SCHL-53',53,'1','/1','/1100','2024-06-20','Cash','1863',0,0,1100,1100,1,'adminFees302',NULL),
(56,178,'SCHL-54',54,'SCHL','SCHL-54',54,'1','/1','/1000','2024-06-21','Cash','1864',0,0,1000,1000,1,'adminFees302',NULL),
(57,259,'SCHL-55',55,'SCHL','SCHL-55',55,'1','/1','/1100','2024-06-24','Cash','1865',0,0,1100,1100,1,'adminFees302',NULL),
(58,222,'SCHL-56',56,'SCHL','SCHL-56',56,'1','/1','/1000','2024-06-24','Cash','1866',0,0,1000,1000,1,'adminFees302',NULL),
(59,154,'SCHL-57',57,'SCHL','SCHL-57',57,'1','/1','/1000','2024-06-24','Cash','1867',0,0,1000,1000,1,'adminFees302',NULL),
(60,169,'SCHL-58',58,'SCHL','SCHL-58',58,'1','/1','/1000','2024-06-24','Cash','1868',0,0,1000,1000,1,'adminFees302',NULL),
(61,168,'SCHL-59',59,'SCHL','SCHL-59',59,'1','/1','/500','2024-06-24','Cash','1869',0,0,500,500,1,'adminFees302',NULL),
(62,236,'SCHL-60',60,'SCHL','SCHL-60',60,'1','/1','/500','2024-06-25','Cash','1870',0,0,500,500,1,'adminFees302',NULL),
(63,153,'SCHL-61',61,'SCHL','SCHL-61',61,'1','/1','/1000','2024-06-26','Cash','1871',0,0,1000,1000,1,'adminFees302',NULL),
(64,177,'SCHL-62',62,'SCHL','SCHL-62',62,'1','/1','/1000','2024-06-26','Cash','1872',0,0,1000,1000,1,'adminFees302',NULL),
(65,248,'SCHL-63',63,'SCHL','SCHL-63',63,'1','/1','/1000','2024-06-27','Cash','1873',0,0,1000,1000,1,'adminFees302',NULL),
(66,235,'SCHL-64',64,'SCHL','SCHL-64',64,'1','/1','/500','2024-06-29','Cash','1874',0,0,500,500,1,'adminFees302',NULL),
(67,171,'SCHL-65',65,'SCHL','SCHL-65',65,'1','/1','/1000','2024-07-01','Cash','1875',0,0,1000,1000,1,'adminFees302',NULL),
(68,255,'SCHL-66',66,'SCHL','SCHL-66',66,'1','/1','/1000','2024-07-01','Cash','1876',0,0,1000,1000,1,'adminFees302',NULL),
(69,191,'SCHL-67',67,'SCHL','SCHL-67',67,'1','/1','/1000','2024-07-01','Cash','1877',0,0,1000,1000,1,'adminFees302',NULL),
(70,190,'SCHL-68',68,'SCHL','SCHL-68',68,'1','/1','/1000','2024-07-03','Cash','1878',0,0,1000,1000,1,'adminFees302',NULL),
(71,239,'SCHL-69',69,'SCHL','SCHL-69',69,'1','/1','/500','2024-07-04','Cash','1879',0,0,500,500,1,'adminFees302',NULL),
(72,204,'SCHL-70',70,'SCHL','SCHL-70',70,'1','/1','/1000','2024-07-06','Cash','1880',0,0,1000,1000,1,'adminFees302',NULL),
(73,229,'SCHL-71',71,'SCHL','SCHL-71',71,'1','/1','/1000','2024-07-25','Cash','1881',0,0,1000,1000,1,'adminFees302',NULL),
(74,196,'SCHL-72',72,'SCHL','SCHL-72',72,'1','/1','/1000','2024-07-26','Cash','1882',0,0,1000,1000,1,'adminFees302',NULL),
(75,197,'SCHL-73',73,'SCHL','SCHL-73',73,'1','/1','/500','2024-07-31','Cash','1883',0,0,500,500,1,'adminFees302',NULL),
(76,197,'SCHL-74',74,'SCHL','SCHL-74',74,'1','/1','/500','2024-08-26','Cash','1884',0,0,500,500,1,'adminFees302',NULL),
(77,210,'SCHL-75',75,'SCHL','SCHL-75',75,'1','/1','/1000','2024-08-29','Cash','1885',0,0,1000,1000,1,'adminFees302',NULL),
(78,202,'SCHL-76',76,'SCHL','SCHL-76',76,'1','/1','/1200','2024-09-09','Cash','1886',0,0,1200,1200,1,'adminFees302',NULL),
(79,162,'SCHL-77',77,'SCHL','SCHL-77',77,'1','/1','/500','2024-09-09','Cash','1887',0,0,500,500,1,'adminFees302',NULL),
(80,195,'SCHL-78',78,'SCHL','SCHL-78',78,'1','/1','/500','2024-09-11','Cash','1888',0,0,500,500,1,'adminFees302',NULL),
(81,218,'SCHL-79',79,'SCHL','SCHL-79',79,'1','/1','/1200','2024-09-12','Cash','1889',0,0,1200,1200,1,'adminFees302',NULL),
(82,221,'SCHL-80',80,'SCHL','SCHL-80',80,'1','/1','/500','2024-09-12','Cash','1890',0,0,500,500,1,'adminFees302',NULL),
(83,226,'SCHL-81',81,'SCHL','SCHL-81',81,'1','/1','/1200','2024-09-13','Cash','1891',0,0,1200,1200,1,'adminFees302',NULL),
(84,199,'SCHL-82',82,'SCHL','SCHL-82',82,'1','/1','/1500','2024-09-13','Cash','1892',0,0,1500,1500,1,'adminFees302',NULL),
(85,247,'SCHL-83',83,'SCHL','SCHL-83',83,'1','/1','/1200','2024-09-13','Cash','1893',0,0,1200,1200,1,'adminFees302',NULL),
(86,232,'SCHL-84',84,'SCHL','SCHL-84',84,'1','/1','/1000','2024-09-17','Cash','1894',0,0,1000,1000,1,'adminFees302',NULL),
(87,254,'SCHL-85',85,'SCHL','SCHL-85',85,'1','/1','/1000','2024-09-18','Cash','1895',0,0,1000,1000,1,'adminFees302',NULL),
(88,200,'SCHL-86',86,'SCHL','SCHL-86',86,'1','/1','/1000','2024-09-18','Cash','1896',0,0,1000,1000,1,'adminFees302',NULL),
(89,225,'SCHL-87',87,'SCHL','SCHL-87',87,'1','/1','/1000','2024-09-18','Cash','1897',0,0,1000,1000,1,'adminFees302',NULL),
(92,231,'SCHL-90',90,'SCHL','SCHL-90',90,'1','/1','/1100','2024-09-19','Cash','1898',0,0,1100,1100,1,'adminFees302',NULL),
(91,236,'SCHL-89',89,'SCHL','SCHL-89',89,'1','/1','/500','2024-09-19','Cash','1899',0,0,500,500,1,'adminFees302',NULL),
(93,201,'SCHL-91',91,'SCHL','SCHL-91',91,'1','/1','/500','2024-09-19','Cash','1890',0,0,500,500,1,'adminFees302',NULL),
(94,238,'SCHL-92',92,'SCHL','SCHL-92',92,'1','/1','/1000','2024-09-19','Cash','1901',0,0,1000,1000,1,'adminFees302',NULL),
(96,246,'SCHL-93',93,'SCHL','SCHL-93',93,'1','/1','/1000','2024-09-19','Cash','1902',0,0,1000,1000,1,'adminFees302',NULL),
(97,205,'SCHL-94',94,'SCHL','SCHL-94',94,'1','/1','/1000','2024-09-22','Cash','1903',0,0,1000,1000,1,'adminFees302',NULL),
(98,241,'SCHL-95',95,'SCHL','SCHL-95',95,'1','/1','/500','2024-09-20','Cash','1904',0,0,500,500,1,'adminFees302',NULL),
(99,186,'SCHL-96',96,'SCHL','SCHL-96',96,'1','/1','/1200','2024-09-20','Cash','1905',0,0,1200,1200,1,'adminFees302',NULL),
(100,224,'SCHL-97',97,'SCHL','SCHL-97',97,'1','/1','/1000','2024-09-20','Cash','1906',0,0,1000,1000,1,'adminFees302',NULL),
(101,172,'SCHL-98',98,'SCHL','SCHL-98',98,'1','/1','/1200','2024-09-20','Cash','1907',0,0,1200,1200,1,'adminFees302',NULL),
(102,207,'SCHL-99',99,'SCHL','SCHL-99',99,'1','/1','/500','2024-09-20','Cash','1908',0,0,500,500,1,'adminFees302',NULL),
(103,227,'SCHL-100',100,'SCHL','SCHL-100',100,'1','/1','/1000','2024-09-23','Cash','1909',0,0,1000,1000,1,'adminFees302',NULL),
(104,249,'SCHL-101',101,'SCHL','SCHL-101',101,'1','/1','/500','2024-09-23','Cash','1910',0,0,500,500,1,'adminFees302',NULL),
(105,244,'SCHL-102',102,'SCHL','SCHL-102',102,'1','/1','/500','2024-09-23','Cash','1911',0,0,500,500,1,'adminFees302',NULL),
(106,239,'SCHL-103',103,'SCHL','SCHL-103',103,'1','/1','/500','2024-09-23','Cash','1912',0,0,500,500,1,'adminFees302',NULL),
(107,217,'SCHL-104',104,'SCHL','SCHL-104',104,'1','/1','/1000','2024-09-23','Cash','1913',0,0,1000,1000,1,'adminFees302',NULL),
(108,219,'SCHL-105',105,'SCHL','SCHL-105',105,'1','/1','/1000','2024-09-24','Cash','1914',0,0,1000,1000,1,'adminFees302',NULL),
(109,211,'SCHL-106',106,'SCHL','SCHL-106',106,'1','/1','/500','2024-09-25','Cash','1915',0,0,500,500,1,'adminFees302',NULL),
(110,240,'SCHL-107',107,'SCHL','SCHL-107',107,'1','/1','/2000','2024-09-25','Cash','1916',0,0,2000,2000,1,'adminFees302',NULL),
(111,147,'SCHL-108',108,'SCHL','SCHL-108',108,'1','/1','/2000','2024-09-25','Cash','1917',0,0,2000,2000,1,'adminFees302',NULL),
(112,159,'SCHL-109',109,'SCHL','SCHL-109',109,'1','/1','/500','2024-09-25','Cash','1918',0,0,500,500,1,'adminFees302',NULL),
(113,180,'SCHL-110',110,'SCHL','SCHL-110',110,'1','/1','/1200','2024-09-25','Cash','1919',0,0,1200,1200,1,'adminFees302',NULL),
(114,237,'SCHL-111',111,'SCHL','SCHL-111',111,'1','/1','/1000','2024-09-26','Cash','1920',0,0,1000,1000,1,'adminFees302',NULL),
(115,214,'SCHL-112',112,'SCHL','SCHL-112',112,'1','/1','/1000','2024-09-27','Cash','1921',0,0,1000,1000,1,'adminFees302',NULL),
(116,166,'SCHL-113',113,'SCHL','SCHL-113',113,'1','/1','/500','2024-09-30','Cash','1922',0,0,500,500,1,'adminFees302',NULL),
(117,197,'SCHL-114',114,'SCHL','SCHL-114',114,'1','/1','/500','2024-09-30','Cash','1923',0,0,500,500,1,'adminFees302',NULL),
(118,158,'SCHL-115',115,'SCHL','SCHL-115',115,'1','/1','/500','2024-10-01','Cash','1924',0,0,500,500,1,'adminFees302',NULL),
(119,208,'SCHL-116',116,'SCHL','SCHL-116',116,'1','/1','/1200','2024-10-24','Cash','1925',0,0,1200,1200,1,'adminFees302',NULL),
(120,256,'SCHL-117',117,'SCHL','SCHL-117',117,'1','/1','/500','2024-10-25','Cash','1926',0,0,500,500,1,'adminFees302',NULL),
(121,209,'SCHL-118',118,'SCHL','SCHL-118',118,'1','/1','/1200','2024-10-25','Cash','1927',0,0,1200,1200,1,'adminFees302',NULL),
(122,162,'SCHL-119',119,'SCHL','SCHL-119',119,'1','/1','/500','2024-11-04','Cash','1928',0,0,500,500,1,'adminFees302',NULL),
(123,197,'SCHL-120',120,'SCHL','SCHL-120',120,'1','/1','/500','2024-11-04','Cash','1929',0,0,500,500,1,'adminFees302',NULL),
(124,166,'SCHL-121',121,'SCHL','SCHL-121',121,'1','/1','/700','2024-11-09','Cash','1930',0,0,700,700,1,'adminFees302',NULL),
(125,202,'SCHL-122',122,'SCHL','SCHL-122',122,'1','/1','/1000','2024-11-11','Cash','1931',0,0,1000,1000,1,'adminFees302',NULL),
(126,175,'SCHL-123',123,'SCHL','SCHL-123',123,'1','/1','/1200','2024-11-21','Cash','1933',0,0,1200,1200,1,'adminFees302',NULL);
/*!40000 ALTER TABLE `paid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paid_fees_delete`
--
DROP TABLE IF EXISTS `paid_fees_delete`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid_fees_delete` (
`Fees_id` bigint(20) NOT NULL DEFAULT 0,
`Stud_Id` int(11) NOT NULL,
`Recipt_No` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`ReciptCounter` bigint(20) NOT NULL,
`Recp_Book_Name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_No` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Recp_Book_Counter` bigint(20) NOT NULL,
`Head_Id` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Subhead_Ids` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Sub_Amounts` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Paid_date` date DEFAULT NULL,
`Mode` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`DateNumber` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Fine_Amount` int(11) DEFAULT NULL,
`Online_Charge` int(11) DEFAULT NULL,
`Total_Amount` int(11) DEFAULT NULL,
`Grand_Total` int(11) DEFAULT NULL,
`flag` tinyint(4) NOT NULL,
`user` varchar(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`Message` varchar(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paid_fees_delete`
--
LOCK TABLES `paid_fees_delete` WRITE;
/*!40000 ALTER TABLE `paid_fees_delete` DISABLE KEYS */;
INSERT INTO `paid_fees_delete` VALUES
(1,146,'SCHL-1',1,'SCHL','SCHL-1',1,'1','/1','/1000','2024-09-30','Cash','111111',0,0,1000,1000,1,'adminFees302','2024-09-30 06:29 39'),
(6,167,'SCHL-5',5,'SCHL','SCHL-5',5,'1','/1','/1000','2024-06-03','Cash','',0,0,1000,1000,1,'adminFees302','2024-10-23 06:02 31'),
(90,231,'SCHL-88',88,'SCHL','SCHL-88',88,'1','/1','/1000','2024-09-18','Cash','1897',0,0,1000,1000,1,'adminFees302','2024-10-25 06:58 38'),
(95,246,'SCHL-93',93,'SCHL','SCHL-93',93,'1','/1','/1000','2024-09-19','Cash','1892',0,0,1000,1000,1,'adminFees302','2024-10-25 07:04 47');
/*!40000 ALTER TABLE `paid_fees_delete` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `role`
--
DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
`roleid` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `role`
--
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `roleaccess`
--
DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
`roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
`roleid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
PRIMARY KEY (`roleaccessid`),
KEY `deleteroleaccess` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `roleaccess`
--
LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`settingsid` int(11) NOT NULL,
`company` varchar(255) NOT NULL,
`city` varchar(200) NOT NULL,
`address` text NOT NULL,
`website` varchar(255) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`logo` text NOT NULL,
`currency` varchar(5) NOT NULL,
`languages` varchar(10) NOT NULL,
`dateformat` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic`
--
DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
`Name` varchar(1000) NOT NULL,
`Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
`Gender` varchar(100) NOT NULL DEFAULT 'None',
`Class` varchar(100) NOT NULL,
`Division` varchar(100) NOT NULL,
`Reg_No` varchar(100) DEFAULT NULL,
`Phone` bigint(20) NOT NULL,
`Email` varchar(30) NOT NULL,
`Message` varchar(10000) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`bus_info` varchar(500) DEFAULT NULL,
PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=260 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
('MOHAMAD ATAHAR S/O MAHAMAD RAFIQ',257,'Male','Aruna ','a','4',9741228442,'',NULL,0,NULL),
('ADITYA PATIL S/O HANUMANA GOUDA',146,'','Aruna','A','1',9880765655,'',NULL,0,NULL),
('SANDEEP S/O RAVI',147,'','Aruna','A','2',8050813082,'',NULL,0,NULL),
('BHUVAN L S/O UMAPATHI L',148,'','Aruna','A','3',9886407935,'',NULL,0,NULL),
('H ERANNA S/O H VEERESH',149,'','Aruna','A','4',8123227083,'',NULL,0,NULL),
('K AKASH S/O K JALALI',150,'','Aruna','A','5',9632305369,'',NULL,0,NULL),
('TUSHAR S/O LINGAPPA',151,'','Aruna','A','6',8496804779,'',NULL,0,NULL),
('GANESH S/O LATE MANJUNATH',152,'','Aruna','A','7',8884645919,'',NULL,0,NULL),
('T KOTRESH S/O T BASAVARAJ',153,'','Aruna','A','8',9663812483,'',NULL,0,NULL),
('MOHAMAD FARAN S/O K JUBERA',154,'','Aruna','A','9',8494892938,'',NULL,0,NULL),
('V A ARYAN S/O V A VENKATASWAMY',155,'','Aruna','A','10',8095052450,'',NULL,0,NULL),
('K YASHVANTH S/O K VEERESH',156,'','Aruna','A','11',9845581255,'',NULL,0,NULL),
('VIRAJU S/O GANESH',157,'','Aruna','A','12',9535345378,'',NULL,0,NULL),
('GURURAJ S/O C ANJANEYA',158,'','Aruna','A','13',8971421018,'',NULL,0,NULL),
('GULAM RASOOL S/O MUSTAF',159,'','Aruna','A','14',9353487846,'',NULL,0,NULL),
('YUVARAJ R S/O RAMESH',160,'','Aruna','A','15',9535815951,'',NULL,0,NULL),
('H YAKSHITH S/O RAMACHANDRA',161,'','Aruna','A','16',7353413061,'',NULL,0,NULL),
('SARTHAKA S/O M ERANNA',162,'','Aruna','A','17',8050662924,'',NULL,0,NULL),
('SAITEJA S/O VIJAYAKUMAR',163,'','Aruna','A','18',8095708804,'',NULL,0,NULL),
('MOULASAB S/O RAJASAB',164,'','Aruna','A','19',7338271042,'',NULL,0,NULL),
('C ABHAY S/O C RAGHAVENDRA',165,'','Aruna','A','20',8867004083,'',NULL,0,NULL),
('SANTOSH CHALUVADI S/O BASAVARAJA',166,'','Aruna','A','21',9739686370,'',NULL,0,NULL),
('MAHAMAD ARIF S/O KAMPLI SHAMSHUDDIN',167,'','Aruna','A','22',9535346161,'',NULL,0,NULL),
('N ABUBAKAR S/O N KASIM',168,'','Aruna','A','23',7996668498,'',NULL,0,NULL),
('V DURGAPRASAD S/O V MANJUNATH',169,'','Aruna','A','24',9538492327,'',NULL,0,NULL),
('H M SAMARTH S/O GAVISIDDAYYASWAMY',170,'','Aruna','A','25',7996424214,'',NULL,0,NULL),
('D DILEEP S/O MANJUNATH',171,'','Aruna','A','26',8105225088,'',NULL,0,NULL),
('BHUVAN S/O SHANMUKHA',172,'','Aruna','A','27',7026712155,'',NULL,0,NULL),
('MANVITHA D/O G NAGARAJA',173,'','Aruna','A','28',9353498348,'',NULL,0,NULL),
('BHARGHAVI CHITRAGARA D/O VENKATESH CHITRAGARA',174,'','Aruna','A','29',9945679497,'',NULL,0,NULL),
('NUSARATHJAHA D/O HAJARATH THAIYAB SAB',175,'','Aruna','A','30',9972341728,'',NULL,0,NULL),
('RISHIKA D/O PRASANNA KUMAR',176,'','Aruna','A','31',9590238659,'',NULL,0,NULL),
('SNEHALATHA D/O HUSEN',177,'','Aruna','A','32',9964480475,'',NULL,0,NULL),
('C NITYA D/O SWAMY C',178,'','Aruna','A','33',8151821908,'',NULL,0,NULL),
('B JAHNAVI D/O B LOKESH',179,'','Aruna','A','34',8867959031,'',NULL,0,NULL),
('JNYANESHWARI D/O HANUMANTH A K',180,'','Aruna','A','35',8150016735,'',NULL,0,NULL),
('J BHUMIKA D/O J VISHWANTHA',181,'','Aruna','A','36',9035095771,'',NULL,0,NULL),
('DHANYASHRI C D D/O GOPAL C',182,'','Aruna','A','37',9071064055,'',NULL,0,NULL),
('NAYANA D/O HULUGAPPA (LATE)',183,'','Aruna','A','38',9743784439,'',NULL,0,NULL),
('H GOUTHAMI D/O H HULUGANNA',184,'','Aruna','A','39',8861645439,'',NULL,0,NULL),
('VANAJAKSHI D/O INDRA',185,'','Aruna','A','40',6360453505,'',NULL,0,NULL),
('MANASA D/O PAMANNA MATUR',186,'','Aruna','A','41',9986264465,'',NULL,0,NULL),
('UMMI KULSUM D/O USMAN BASHA',187,'','Aruna','A','42',6363676509,'',NULL,0,NULL),
('DEEKSHA D/O NINGANNA',188,'','Aruna','A','43',9741604191,'',NULL,0,NULL),
('AKRUTHI P S/O UMESH P',189,'','Aruna','A','44',8904845196,'',NULL,0,NULL),
('FARIDA BEGAM D/O HONNURASAB',190,'','Aruna','A','45',9741968671,'',NULL,0,NULL),
('BHUMIKA D/O U UMESH',191,'','Aruna','A','46',7829091279,'',NULL,0,NULL),
('ARPITHA DEVARAL D/O DEVARAL VEERESH',192,'','Aruna','A','47',7090751819,'',NULL,0,NULL),
('K AKASH S/O K NAGARAJ',194,'','Udaya','A','1',9071981553,'',NULL,0,NULL),
('MANIKANTHA S/O BASAVARAJ',195,'','Udaya','A','2',9035507665,'',NULL,0,NULL),
('DHANUSH S/O SRINIVASA',196,'','Udaya','A','3',9513650650,'',NULL,0,NULL),
('SAMRUDH S/O M ERANNA',197,'','Udaya','A','4',7406947098,'',NULL,0,NULL),
('V MANOJ KUMAR S/O V KUMAR',198,'','Udaya','A','5',7483679105,'',NULL,0,NULL),
('MOHAMAD ISHAK S/O KAMPLI SHAMSHUDDIN',199,'','Udaya','A','6',9535346161,'',NULL,0,NULL),
('P BANGARA LAKKANNA S/O P GANGAPPA',200,'','Udaya','A','7',8884264844,'',NULL,0,NULL),
('GANESH S/O RAMANJINI',201,'','Udaya','A','8',0,'',NULL,0,NULL),
('SIDDI MOULA HUSEN S/O S DASTAGIRI SAB',202,'','Udaya','A','9',8105540122,'',NULL,0,NULL),
('H M SAMARTH S/O H M SHASHIDHAR',203,'','Udaya','A','10',8971671978,'',NULL,0,NULL),
('G HONNUR SAB S/O RAJA SAB',204,'','Udaya','A','11',7795944551,'',NULL,0,NULL),
('JISHAN S/O K JUBER',205,'','Udaya','A','12',9448071501,'',NULL,0,NULL),
('BHOVI THIPPESWAMI S/O BALAJEPPA BHOVI',206,'','Udaya','A','13',7795949706,'',NULL,0,NULL),
('PRAVEEN S/O VIJAY KUMAR P',207,'','Udaya','A','14',0,'',NULL,0,NULL),
('MAHAMMAD MUKHTADIR S/O HAJARATH THAYAB SAB',208,'','Udaya','A','15',9148873642,'',NULL,0,NULL),
('JEEVAN S/O RAJA KATTE',209,'','Udaya','A','16',8105429055,'',NULL,0,NULL),
('MEGHARAJ A S/O ANJINAPPA',210,'','Udaya','A','17',8151019017,'',NULL,0,NULL),
('IRANNA SANTOSH B S/O NANDIBASAVA B ',211,'','Udaya','A','18',8050596430,'',NULL,0,NULL),
('ARVIN S/O THAYAPPA',212,'','Udaya','A','19',8147321945,'',NULL,0,NULL),
('SAMRUDH CHITRAGARA S/O VENKATESH CHITRAGARA',213,'','Udaya','A','20',9945679497,'',NULL,0,NULL),
('G LOKESH S/O G HONNURASWAMI',214,'','Udaya','A','21',7829019792,'',NULL,0,NULL),
('ABHISHEK S/O MOULAPPA',215,'','Udaya','A','22',8660119017,'',NULL,0,NULL),
('DRUVA PAVADASHETTI S/O PRAVEEN PAVADASHETTI',216,'','Udaya','A','23',9900575812,'',NULL,0,NULL),
('N SANTOSH VALIMI S/O N MANJUNATHA VALMIKI',217,'','Udaya','A','24',9008529082,'',NULL,0,NULL),
('G VIGNESHA S/O NATARAJA',218,'','Udaya','A','25',9961147776,'',NULL,0,NULL),
('RAGHAVENDRA S/O BASAVA ',219,'','Udaya','A','26',8792686815,'',NULL,0,NULL),
('CHANNADASARA SHARATH S/O D ANANDA',220,'','Udaya','A','27',8867400413,'',NULL,0,NULL),
('H PURUSHOTTHAM S/O H SOMASHEKHAR',221,'','Udaya','A','28',8971273370,'',NULL,0,NULL),
('C MALLIKARJUNA S/O C VEERESH',222,'','Udaya','A','29',9740305152,'',NULL,0,NULL),
('R CHANDRASHEKHAR S/O R JAGADISH ',223,'','Udaya','A','30',7795899003,'',NULL,0,NULL),
('TEJAS S/O RAMAKRISHNA',224,'','Udaya','A','31',9980988438,'',NULL,0,NULL),
('VAISHNAVI D/O RAVI',225,'','Udaya','A','32',9743906794,'',NULL,0,NULL),
('ANAM D/O REHAMATH ULLAH',226,'','Udaya','A','33',9901590326,'',NULL,0,NULL),
('ANANYA D/O HUSENAPPA',227,'','Udaya','A','34',7338544915,'',NULL,0,NULL),
('K DURGASHREE D/O N K YALLAPPA',228,'','Udaya','A','35',8722990933,'',NULL,0,NULL),
('PRANITHA D/O ASHOK',229,'','Udaya','A','36',7899533175,'',NULL,0,NULL),
('J SOUJANYA D/O J SHIVANANDA',230,'','Udaya','A','37',9036697776,'',NULL,0,NULL),
('P SHAILAJA D/O P BALASHEKHAR',231,'','Udaya','A','38',9480065431,'',NULL,0,NULL),
('JANANI D/O KUMAR',232,'','Udaya','A','39',7795021605,'',NULL,0,NULL),
('RISHIKA D/O UMAPATHI L ',233,'','Udaya','A','40',9886407932,'',NULL,0,NULL),
('ANUM ATHIRA D/O MOHAMMAD JAFAR',234,'','Udaya','A','41',8105578660,'',NULL,0,NULL),
('B SONU D/O B SANTOSH',235,'','Udaya','A','42',8496814566,'',NULL,0,NULL),
('SATVIKA D/O JADIYAPPA',236,'','Udaya','A','43',8722501305,'',NULL,0,NULL),
('PRIYANKA D/O M HANUMESHA',237,'','Udaya','A','44',9380914328,'',NULL,0,NULL),
('G NITYASHREE D/O G SHRIGURU',238,'','Udaya','A','45',9611653576,'',NULL,0,NULL),
('C ANANYA D/O C ASHOK',239,'','Udaya','A','46',8088414953,'',NULL,0,NULL),
('PRITIKA D/O RAVI',240,'','Udaya','A','47',8050813082,'',NULL,0,NULL),
('ARFA D/O A IQBAL BASHA',241,'','Udaya','A','48',9739404521,'',NULL,0,NULL),
('SNEHA D/O RAGHAVENDRA ',242,'','Udaya','A','49',9686536728,'',NULL,0,NULL),
('NISHA D/O KRISHNA',243,'','Udaya','A','50',8546895365,'',NULL,0,NULL),
('AYISHA D/O JAKIR SAB',244,'','Udaya','A','51',9886899154,'',NULL,0,NULL),
('S MEGHANA D/O S TAYAPPA',245,'','Udaya','A','52',9972448557,'',NULL,0,NULL),
('G CHINMAYI D/O G UMESHA',246,'','Udaya','A','53',7026282523,'',NULL,0,NULL),
('HITASHREE D/O VEERANNA AMBIGERA',247,'','Udaya','A','54',6360446395,'',NULL,0,NULL),
('SPOORTHI D/O JANAKI',248,'','Udaya','A','55',9902146505,'',NULL,0,NULL),
('KEERTHANA D/O SHIVARAJ C ',249,'','Udaya','A','56',7676440086,'',NULL,0,NULL),
('U ANANYA D/O CHANDRANNA',250,'','Udaya','A','57',7829485387,'',NULL,0,NULL),
('B MANASA D/O B VEERSHA',251,'','Udaya','A','58',9164850414,'',NULL,0,NULL),
('ANANYA D/O KURUBARA KANAMESHA ',252,'','Udaya','A','59',9916698834,'',NULL,0,NULL),
('RITIKA D/O RAMANJINI',253,'','Udaya','A','60',9392390452,'',NULL,0,NULL),
('AISHWARYA D/O RAVIDAS',254,'','Udaya','A','61',0,'',NULL,0,NULL),
('MEENAKSHI D/O U UMESHA',255,'','Udaya','A','62',7829091279,'',NULL,0,NULL),
('K SUSHMITHA D/O BASAVARAJ ',256,'','Udaya','A','63',6364156416,'',NULL,0,NULL),
('ANJANA D/O M S RAGHAVENDRA',258,'Male','Aruna ','a','49',9739411964,'',NULL,0,NULL),
('HULUGESH S/O GABARI NEELAPPA',259,'Male','Aruna ','a','50',6363817674,'',NULL,0,NULL);
/*!40000 ALTER TABLE `stud_basic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic2`
--
DROP TABLE IF EXISTS `stud_basic2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic2` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discount` bigint(20) NOT NULL,
`discription` varchar(200) NOT NULL,
`year` varchar(20) DEFAULT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=114 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,146,1,1,2200,1200,1000,0,'',NULL),
(2,189,1,1,2200,900,1300,0,'',NULL),
(3,192,1,1,2200,0,2200,0,'',NULL),
(4,179,1,1,2200,1000,1200,0,'',NULL),
(5,174,1,1,2200,1500,700,0,'',NULL),
(6,191,1,1,2200,1000,1200,0,'',NULL),
(7,148,1,1,2200,1000,1200,0,'',NULL),
(8,172,1,1,2200,2200,0,0,'',NULL),
(9,165,1,1,2200,500,1700,0,'',NULL),
(10,178,1,1,2200,1000,1200,0,'',NULL),
(11,171,1,1,2200,1000,1200,0,'',NULL),
(12,188,1,1,2200,1000,1200,0,'',NULL),
(13,182,1,1,2200,2000,200,0,'',NULL),
(14,190,1,1,2200,1000,1200,0,'',NULL),
(15,152,1,1,2200,0,2200,0,'',NULL),
(16,159,1,1,2200,1500,700,0,'',NULL),
(17,158,1,1,2200,1600,600,0,'',NULL),
(18,149,1,1,2200,0,2200,0,'',NULL),
(19,184,1,1,2200,1200,1000,0,'',NULL),
(20,170,1,1,2200,0,2200,0,'',NULL),
(21,161,1,1,2200,1200,1000,0,'',NULL),
(22,181,1,1,2200,2200,0,0,'',NULL),
(23,180,1,1,2200,1700,500,0,'',NULL),
(24,150,1,1,2200,0,2200,0,'',NULL),
(25,156,1,1,2200,1000,1200,0,'',NULL),
(26,167,1,1,2200,1000,1200,0,'',NULL),
(27,186,1,1,2200,2200,0,0,'',NULL),
(28,173,1,1,2200,1000,1200,0,'',NULL),
(29,154,1,1,2200,1000,1200,0,'',NULL),
(30,164,1,1,2200,1000,1200,0,'',NULL),
(31,168,1,1,2200,500,1700,0,'',NULL),
(32,183,1,1,2200,500,1700,0,'',NULL),
(33,175,1,1,2200,2200,0,0,'',NULL),
(34,176,1,1,2200,0,2200,0,'',NULL),
(35,163,1,1,2200,1000,1200,0,'',NULL),
(36,147,1,1,2200,2000,200,0,'',NULL),
(37,166,1,1,2200,2200,0,0,'',NULL),
(38,162,1,1,2200,2000,200,0,'',NULL),
(39,177,1,1,2200,1000,1200,0,'',NULL),
(40,153,1,1,2200,1000,1200,0,'',NULL),
(41,151,1,1,2200,0,2200,0,'',NULL),
(42,187,1,1,2200,1000,1200,0,'',NULL),
(43,155,1,1,2200,1000,1200,0,'',NULL),
(44,169,1,1,2200,1000,1200,0,'',NULL),
(45,185,1,1,2200,1000,1200,0,'',NULL),
(46,157,1,1,2200,1000,1200,0,'',NULL),
(47,160,1,1,2200,1000,1200,0,'',NULL),
(48,215,1,1,2200,1100,1100,0,'',NULL),
(49,254,1,1,2200,1000,1200,0,'',NULL),
(50,226,1,1,2200,2200,0,0,'',NULL),
(51,227,1,1,2200,1000,1200,0,'',NULL),
(52,252,1,1,2200,0,2200,0,'',NULL),
(53,234,1,1,2200,0,2200,0,'',NULL),
(54,241,1,1,2200,1000,1200,0,'',NULL),
(55,212,1,1,2200,0,2200,0,'',NULL),
(56,244,1,1,2200,1000,1200,0,'',NULL),
(57,251,1,1,2200,1200,1000,0,'',NULL),
(58,235,1,1,2200,500,1700,0,'',NULL),
(59,206,1,1,2200,1000,1200,0,'',NULL),
(60,239,1,1,2200,1000,1200,0,'',NULL),
(61,222,1,1,2200,1000,1200,0,'',NULL),
(62,220,1,1,2200,0,2200,0,'',NULL),
(63,196,1,1,2200,1000,1200,0,'',NULL),
(64,216,1,1,2200,0,2200,0,'',NULL),
(65,246,1,1,2200,1000,1200,0,'',NULL),
(66,204,1,1,2200,1000,1200,0,'',NULL),
(67,214,1,1,2200,1000,1200,0,'',NULL),
(68,238,1,1,2200,1000,1200,0,'',NULL),
(69,218,1,1,2200,2200,0,0,'',NULL),
(70,201,1,1,2200,500,1700,0,'',NULL),
(71,203,1,1,2200,1100,1100,0,'',NULL),
(72,221,1,1,2200,500,1700,0,'',NULL),
(73,247,1,1,2200,1200,1000,0,'',NULL),
(74,211,1,1,2200,500,1700,0,'',NULL),
(75,230,1,1,2200,0,2200,0,'',NULL),
(76,232,1,1,2200,1000,1200,0,'',NULL),
(77,209,1,1,2200,2200,0,0,'',NULL),
(78,205,1,1,2200,1000,1200,0,'',NULL),
(79,194,1,1,2200,1500,700,0,'',NULL),
(80,228,1,1,2200,1200,1000,0,'',NULL),
(81,256,1,1,2200,500,1700,0,'',NULL),
(82,249,1,1,2200,1200,1000,0,'',NULL),
(83,208,1,1,2200,2200,0,0,'',NULL),
(84,195,1,1,2200,1000,1200,0,'',NULL),
(85,255,1,1,2200,1000,1200,0,'',NULL),
(86,210,1,1,2200,1000,1200,0,'',NULL),
(87,199,1,1,2200,1500,700,0,'',NULL),
(88,217,1,1,2200,1000,1200,0,'',NULL),
(89,243,1,1,2200,0,2200,0,'',NULL),
(90,200,1,1,2200,1000,1200,0,'',NULL),
(91,231,1,1,2200,1100,1100,0,'',NULL),
(92,229,1,1,2200,1000,1200,0,'',NULL),
(93,207,1,1,2200,500,1700,0,'',NULL),
(94,240,1,1,2200,2000,200,0,'',NULL),
(95,237,1,1,2200,1000,1200,0,'',NULL),
(96,223,1,1,2200,1000,1200,0,'',NULL),
(97,219,1,1,2200,1000,1200,0,'',NULL),
(98,233,1,1,2200,1000,1200,0,'',NULL),
(99,253,1,1,2200,0,2200,0,'',NULL),
(100,245,1,1,2200,1500,700,0,'',NULL),
(101,213,1,1,2200,1500,700,0,'',NULL),
(102,197,1,1,2200,2000,200,0,'',NULL),
(103,236,1,1,2200,1000,1200,0,'',NULL),
(104,202,1,1,2200,2200,0,0,'',NULL),
(105,242,1,1,2200,1000,1200,0,'',NULL),
(106,248,1,1,2200,1000,1200,0,'',NULL),
(107,224,1,1,2200,1000,1200,0,'',NULL),
(108,250,1,1,2200,1000,1200,0,'',NULL),
(109,198,1,1,2200,2000,200,0,'',NULL),
(110,225,1,1,2200,1000,1200,0,'',NULL),
(111,257,1,1,2200,1000,1200,0,'',NULL),
(112,258,1,1,2200,1000,1200,0,'',NULL),
(113,259,1,1,2200,1100,1100,0,'',NULL);
/*!40000 ALTER TABLE `stud_basic2` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stud_basic3`
--
DROP TABLE IF EXISTS `stud_basic3`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic3` (
`UID` bigint(11) NOT NULL AUTO_INCREMENT,
`Stud_Id` bigint(11) NOT NULL,
`Head_Id` bigint(11) NOT NULL,
`Subhead_Id` bigint(11) NOT NULL,
`Total_Amount` bigint(11) NOT NULL,
`Paid` bigint(11) NOT NULL,
`Balance` bigint(11) NOT NULL,
`discription` varchar(200) NOT NULL,
PRIMARY KEY (`UID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stud_basic3`
--
LOCK TABLES `stud_basic3` WRITE;
/*!40000 ALTER TABLE `stud_basic3` DISABLE KEYS */;
/*!40000 ALTER TABLE `stud_basic3` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sub_head`
--
DROP TABLE IF EXISTS `sub_head`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_head` (
`Name` varchar(1000) NOT NULL,
`Sub_Id` int(11) NOT NULL AUTO_INCREMENT,
`Amount` varchar(1000) NOT NULL,
`Status` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Sub_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sub_head`
--
LOCK TABLES `sub_head` WRITE;
/*!40000 ALTER TABLE `sub_head` DISABLE KEYS */;
INSERT INTO `sub_head` VALUES
('TUITION FEE ',1,'2200','N');
/*!40000 ALTER TABLE `sub_head` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subcategory`
--
DROP TABLE IF EXISTS `subcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subcategory` (
`subcategoryid` int(11) NOT NULL AUTO_INCREMENT,
`categoryid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
PRIMARY KEY (`subcategoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subcategory`
--
LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbladmin`
--
DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`AdminName` varchar(200) DEFAULT NULL,
`UserName` varchar(200) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
`Email` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
`AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbladmin`
--
LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblbrand`
--
DROP TABLE IF EXISTS `tblbrand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblbrand` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BrandName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblbrand`
--
LOCK TABLES `tblbrand` WRITE;
/*!40000 ALTER TABLE `tblbrand` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblbrand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcart`
--
DROP TABLE IF EXISTS `tblcart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcart` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductId` int(5) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`ProductQty` int(11) DEFAULT NULL,
`IsCheckOut` int(5) DEFAULT NULL,
`CartDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcart`
--
LOCK TABLES `tblcart` WRITE;
/*!40000 ALTER TABLE `tblcart` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcategory`
--
DROP TABLE IF EXISTS `tblcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcategory`
--
LOCK TABLES `tblcategory` WRITE;
/*!40000 ALTER TABLE `tblcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblcustomer`
--
DROP TABLE IF EXISTS `tblcustomer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblcustomer` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`BillingNumber` varchar(120) DEFAULT NULL,
`CustomerName` varchar(120) DEFAULT NULL,
`MobileNumber` bigint(11) DEFAULT NULL,
`ModeofPayment` varchar(50) DEFAULT NULL,
`BillingDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`ID`),
KEY `BillingNumber` (`BillingNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcustomer`
--
LOCK TABLES `tblcustomer` WRITE;
/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblproducts`
--
DROP TABLE IF EXISTS `tblproducts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblproducts` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ProductName` varchar(200) DEFAULT NULL,
`CatID` int(5) DEFAULT NULL,
`SubcatID` int(5) DEFAULT NULL,
`BrandName` varchar(200) DEFAULT NULL,
`ModelNumber` varchar(200) DEFAULT NULL,
`Stock` int(10) DEFAULT NULL,
`Price` decimal(10,0) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblproducts`
--
LOCK TABLES `tblproducts` WRITE;
/*!40000 ALTER TABLE `tblproducts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblproducts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tblsubcategory`
--
DROP TABLE IF EXISTS `tblsubcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tblsubcategory` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`CatID` int(5) DEFAULT NULL,
`SubCategoryname` varchar(200) DEFAULT NULL,
`Status` int(2) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblsubcategory`
--
LOCK TABLES `tblsubcategory` WRITE;
/*!40000 ALTER TABLE `tblsubcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `tblsubcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transaction`
--
DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
`transactionid` int(5) NOT NULL,
`userid` int(5) NOT NULL,
`categoryid` int(5) NOT NULL,
`accountid` int(5) NOT NULL,
`name` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`reference` varchar(255) DEFAULT NULL,
`transactiondate` date NOT NULL,
`type` int(11) NOT NULL,
`description` text DEFAULT NULL,
`file` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transaction`
--
LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_permission`
--
DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`menu` varchar(500) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_permission`
--
LOCK TABLES `user_permission` WRITE;
/*!40000 ALTER TABLE `user_permission` DISABLE KEYS */;
INSERT INTO `user_permission` VALUES
(1,76,'class_division',1),
(2,76,'head',1),
(3,76,'update_student',1),
(4,76,'pay_fees',1),
(5,76,'balance_reports',1),
(6,76,'discount',1),
(7,76,'sub_head',1),
(8,76,'fees_receipt_head',1),
(9,76,'apply_fees_code',1),
(10,76,'payment_approve',1),
(11,76,'inventory',1),
(12,76,'bank',1),
(13,76,'new_student',1),
(14,76,'remove_fees_code',1),
(15,76,'daily_reports',1),
(16,76,'utility',1),
(17,94,'pay_fees',1),
(18,94,'new_student',1);
/*!40000 ALTER TABLE `user_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usermanagement`
--
DROP TABLE IF EXISTS `usermanagement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usermanagement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usermanagement`
--
LOCK TABLES `usermanagement` WRITE;
/*!40000 ALTER TABLE `usermanagement` DISABLE KEYS */;
/*!40000 ALTER TABLE `usermanagement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` char(64) NOT NULL,
`salt` char(16) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`passwordText` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(76,'adminFees302','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'Adminstudent','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732'),
(93,'123','c87c5a00de39b8fa3d9bdce1a89890c67480e3c47fe2dcbdcf4232d06809b3a2','b63dee4518ccd9b',NULL,'Teacher','123@rfwerwA'),
(94,'test1','b3410bef9fbd70fcb9c82b5f00970498bdef85a2538c1360485ef50314468d95','4fb2c5091b4c302',NULL,'Fees_Management','123456@Test');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_new`
--
DROP TABLE IF EXISTS `users_new`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_new` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(60) NOT NULL,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role` varchar(20) DEFAULT NULL,
`phone` varchar(50) DEFAULT NULL,
`status` varchar(20) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`updated_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_new`
--
LOCK TABLES `users_new` WRITE;
/*!40000 ALTER TABLE `users_new` DISABLE KEYS */;
INSERT INTO `users_new` VALUES
(1,'admin@admin.com','Admin','$2y$10$BFUbZ85l0oJHsQSnVt30rO9KhPsIwV21OI56CrUWHh9U1ooj/1sHK','Administrator','085761449873','Active','QN2yBnEUMTmrT45NRvlYG4g5Sh9gVUSFzjKeb20HcGFJLEm04H3uyBrNZlDO','0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'rdk@example.com','rdk','$2y$10$2XvoA3Wh2KiFCJXsdIlw.ek83S.km8QNLiCXJjCrbjq0Vzo7hvPJO','Administrator','1234567890','Active','W3EFnZsmRLwuN4t4kZztQ820d7JS8NPJo3vzqQW4rgi1gUTNyIHUcJFdStqA','2022-07-23 07:50:22','2022-07-23 07:50:22');
/*!40000 ALTER TABLE `users_new` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vochers`
--
DROP TABLE IF EXISTS `vochers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vochers` (
`Date` date NOT NULL,
`Cheque_Drop_Date` int(100) DEFAULT NULL,
`V_Id` int(11) NOT NULL AUTO_INCREMENT,
`v_counter` bigint(20) NOT NULL,
`Type` varchar(1000) NOT NULL,
`Cr_Ledger` varchar(1000) NOT NULL,
`Dr_Ledger` varchar(1000) NOT NULL,
`Cr_Ledger_Type` varchar(1000) NOT NULL,
`Dr_Ledger_Type` varchar(1000) NOT NULL,
`Cr_Amount` varchar(1000) NOT NULL,
`Dr_Amount` varchar(1000) NOT NULL,
`Nrtn` varchar(5000) NOT NULL,
PRIMARY KEY (`V_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vochers`
--
LOCK TABLES `vochers` WRITE;
/*!40000 ALTER TABLE `vochers` DISABLE KEYS */;
INSERT INTO `vochers` VALUES
('2024-09-30',NULL,1,1,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-03-05',NULL,2,2,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-05-31',NULL,3,3,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2200','2200','Fees Collected'),
('2024-06-03',NULL,4,4,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2500','2500','Fees Collected'),
('2024-06-04',NULL,5,5,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1900','1900','Fees Collected'),
('2024-06-05',NULL,6,6,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','9200','9200','Fees Collected'),
('2024-06-06',NULL,7,7,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-07',NULL,8,8,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','3200','3200','Fees Collected'),
('2024-06-08',NULL,9,9,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','4700','4700','Fees Collected'),
('2024-08-06',NULL,10,10,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-10',NULL,11,11,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','9000','9000','Fees Collected'),
('2024-06-11',NULL,12,12,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','7700','7700','Fees Collected'),
('2024-06-12',NULL,13,13,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','6100','6100','Fees Collected'),
('2024-06-13',NULL,14,14,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-14',NULL,15,15,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-06-19',NULL,16,16,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-20',NULL,17,17,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1100','1100','Fees Collected'),
('2024-06-21',NULL,18,18,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-24',NULL,19,19,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','4600','4600','Fees Collected'),
('2024-06-25',NULL,20,20,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-06-26',NULL,21,21,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','2000','2000','Fees Collected'),
('2024-06-27',NULL,22,22,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-06-29',NULL,23,23,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-07-01',NULL,24,24,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-07-03',NULL,25,25,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-04',NULL,26,26,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-07-06',NULL,27,27,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-25',NULL,28,28,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-26',NULL,29,29,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-07-31',NULL,30,30,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-08-26',NULL,31,31,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-08-29',NULL,32,32,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-09',NULL,33,33,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1700','1700','Fees Collected'),
('2024-09-11',NULL,34,34,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-09-12',NULL,35,35,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1700','1700','Fees Collected'),
('2024-09-13',NULL,36,36,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','3900','3900','Fees Collected'),
('2024-09-17',NULL,37,37,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-18',NULL,38,38,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','3000','3000','Fees Collected'),
('2024-09-19',NULL,39,39,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','4100','4100','Fees Collected'),
('2024-09-22',NULL,40,40,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-20',NULL,41,41,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','4400','4400','Fees Collected'),
('2024-09-23',NULL,42,42,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','3500','3500','Fees Collected'),
('2024-09-24',NULL,43,43,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-25',NULL,44,44,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','6200','6200','Fees Collected'),
('2024-09-26',NULL,45,45,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-09-27',NULL,46,46,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-10-01',NULL,47,47,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','500','500','Fees Collected'),
('2024-10-24',NULL,48,48,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1200','1200','Fees Collected'),
('2024-10-25',NULL,49,49,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1700','1700','Fees Collected'),
('2024-11-04',NULL,50,50,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-11-09',NULL,51,51,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','700','700','Fees Collected'),
('2024-11-11',NULL,52,52,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1000','1000','Fees Collected'),
('2024-11-21',NULL,53,53,'Recipt','TUITION FEE ','Cash','Income/Revenue','Current Assets','1200','1200','Fees Collected');
/*!40000 ALTER TABLE `vochers` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-05 0:00:38