/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: u926327694_dpbedblg_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 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 */;
/*!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 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 */;
/*!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 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 */;
/*!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 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 */;
/*!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 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 */;
/*!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 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 */;
/*!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 `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,
  PRIMARY KEY (`Stud_Id`)
) ENGINE=MyISAM 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 */;
/*!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,
  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 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 */;
/*!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 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=97 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);
/*!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=90 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(76,'adminFees','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'),
(77,'Adminstudent','9528a78ef3c71c6312563cb31594f60a1e6b3a54501033f3126ce5056b23fd4f','7240569f5617a266','e.vision.infotech12@gmail.com','Student_Management','Admin@954'),
(78,'adminaccount','75ebfd2926d87eff03c7aa31b35bcc15b828610cbfc3d5de7bb7bf5f6705c0dc','efcc0891535db93','','Accounts','Admin@732'),
(79,'abc','04d05372324fd0bb833d332821d083306ddb2c0b6659a9f74c3465859cdedf30','24dd23bc5d2e9567','asdf@gmail.com','Fees_Management',''),
(80,'demofees','c61555dd4172149c02fe511c722e3747d0735cc7dd35a996edd1adad3b9e27f5','6f731a164d300787',NULL,'Fees_Management','123456@Rr'),
(81,'demostu','b9671d376a4d1bf8d01548a1a0b0625aa31a3265a4c1e7d277f338d73d959a08','783660b47fbe3cd5',NULL,'Student_Management','123456@Rr'),
(82,'demoacc','ef0d2464f006a30e274a2c8a8f80a2f44bce51877ea14b9561c4c298b9d1c85e','552218ec6daf1977',NULL,'Account','123456@Rr'),
(83,'raghu123','58ccef449042cf8682bb9e2f0fe135d1bc9d2a1c3ce0cd9661873b0582645ee6','345564275bcecc34',NULL,'Fees_Management','123456@Rr'),
(84,'test','86cf7935145de12134fa9ef9961c710af79ef8d80458efb473c6a76cf01fe0a8','173656d0f868901',NULL,'Fees_Management','Test@123'),
(85,'testpermission','415d4079633d5ba26b60699517f6074cc793b4e63e5d8651f7f3b62d5c5f6b31','7f2db32e41d9a75e',NULL,'Fees_Management','Test@123'),
(86,'adf','25ac64f0ec7ec1e2bfd9a93b002c5772d9a39af66453d871d2b9588f20839242','1dce52717dd5e896',NULL,'Fees_Management','asdfadfas@345A'),
(87,'test789','90f34a19cb514a6c9867a4e738b7e1f86beb7b08491cdfc760acc9dd2e818281','ea0dc453d03aec6',NULL,'Account','Test@123'),
(88,'checkpermission','c0b03bdde2a8aa77a46060dae3d001e857db04a23b31bcb85c73fa72690263f4','395be3e631ba30f1',NULL,'Fees_Management','Test@123'),
(89,'adminFees1','3075ceceb9caba1996305bb7274f2583cb16675790b026aa5bdd5b79307eed0a','1e15fe1a4736916a',NULL,'Fees_Management','Admin@531');
/*!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:27