/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: u926327694_EVI_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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account`
--

LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
INSERT INTO `account` VALUES
(1,'Vision Infotech',0.00,'329','Vision infotech'),
(2,'e vision infotech ( SBI )',0.00,'01','CURRENT ACCOUNT'),
(5,'RAGHU VISION',0.00,'2',NULL),
(6,'CASH',0.00,'3',NULL);
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_accounts`
--

DROP TABLE IF EXISTS `admin_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_accounts` (
  `id` int(25) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) NOT NULL,
  `passwd` varchar(50) NOT NULL,
  `admin_type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_accounts`
--

LOCK TABLES `admin_accounts` WRITE;
/*!40000 ALTER TABLE `admin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bankaccounts`
--

DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Bank_Name` varchar(1000) NOT NULL,
  `IFSC` varchar(1000) NOT NULL,
  `Account_Number` varchar(1000) NOT NULL,
  `AccountHolderName` varchar(1000) NOT NULL,
  `PayuKey` bigint(20) NOT NULL,
  `SaltKey` bigint(20) NOT NULL,
  `MerchantKey` bigint(20) NOT NULL,
  `AccountType` varchar(1000) NOT NULL,
  `Link` varchar(10000) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM 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=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES
(1,'HOTEL','HOTEL',2,'#FFFFFF'),
(2,'ID CARD','ID CARD',2,'#FFFFFF'),
(3,'ID CARD','ID CARD',1,'#FFFFFF'),
(4,'Building fund','Building fund',1,'#FFFFFF'),
(5,'Building fund','Building fund',1,'#FFFFFF'),
(6,'PETROL EXPENSES',NULL,2,'#FFFFFF'),
(7,'Online Student Management',NULL,1,'#FFFFFF'),
(8,'Bio Metric','Bio Metric',1,'#FFFFFF'),
(9,'Computer Sales','Computer Sales',1,'#FFFFFF'),
(10,'WEB SITE',NULL,1,'#FFFFFF'),
(11,'SOFTWARE','SOFTWARE',1,'#FFFFFF'),
(12,'DATA SALES','DATA SALES',1,'#FFFFFF'),
(13,'DADU WEB DEVELOPER','DADU',2,'#FFFFFF'),
(14,'BIO METRIC',NULL,2,'#FFFFFF'),
(15,'COMPUTER SPARE','COMPUTER SPARE',2,'#FFFFFF'),
(16,'Travelling charges','Travelling charges',2,'#FFFFFF'),
(17,'Products',NULL,1,'#FFFFFF'),
(19,'Products',NULL,2,'#FFFFFF'),
(20,'Web Site',NULL,2,'#FFFFFF'),
(21,'Medical Expensess',NULL,2,'#FFFFFF'),
(22,'Home Rent',NULL,2,'#FFFFFF'),
(23,'Prajnya',NULL,2,'#FFFFFF'),
(24,'Personal Account',NULL,2,'#FFFFFF'),
(25,'Content',NULL,1,'#FFFFFF'),
(26,'Content',NULL,2,'#FFFFFF'),
(27,'DXN Ependiture',NULL,2,'#FFFFFF'),
(28,'Smsoft Payments',NULL,1,'#FFFFFF'),
(29,'vidiocon d2h',NULL,2,'#FFFFFF'),
(30,'cylendor',NULL,2,'#FFFFFF'),
(31,'Electrical Bill',NULL,2,'#FFFFFF'),
(32,'vegitables',NULL,2,'#FFFFFF'),
(33,'Milk',NULL,2,'#FFFFFF'),
(34,'Glossarry',NULL,2,'#FFFFFF'),
(35,'Salary',NULL,2,'#FFFFFF'),
(36,'Antivirus',NULL,1,'#FFFFFF'),
(37,'Antivirus',NULL,2,'#FFFFFF'),
(38,'Others',NULL,2,'#FFFFFF'),
(39,'SMS Purchase',NULL,2,'#FFFFFF'),
(40,'Currency',NULL,2,'#FFFFFF'),
(41,'Currency',NULL,2,'#FFFFFF'),
(42,'Salary',NULL,2,'#FFFFFF'),
(43,'Services and Repair',NULL,2,'#FFFFFF'),
(44,'swaroopa exp',NULL,2,'#FFFFFF'),
(45,'Job Reffarence',NULL,1,'#FFFFFF'),
(46,'Other',NULL,1,'#FFFFFF');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `class`
--

DROP TABLE IF EXISTS `class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `class` (
  `Name` varchar(100) NOT NULL,
  `Cls_Id` int(11) NOT NULL AUTO_INCREMENT,
  `Discription` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Cls_Id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `class`
--

LOCK TABLES `class` WRITE;
/*!40000 ALTER TABLE `class` DISABLE KEYS */;
INSERT INTO `class` VALUES
('LKG',2,NULL),
('UKG',3,NULL),
('ISTD',4,NULL),
('II STD',5,NULL),
('PUC   I YEAR',6,NULL),
('PUC II YEAR',7,NULL),
('x',8,NULL),
('III',12,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=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `division`
--

LOCK TABLES `division` WRITE;
/*!40000 ALTER TABLE `division` DISABLE KEYS */;
INSERT INTO `division` VALUES
('A',1,NULL),
('B',2,NULL),
('SCIENCE',3,NULL),
('ARTS',4,NULL),
('C',5,NULL),
('123',7,'test');
/*!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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goals`
--

LOCK TABLES `goals` WRITE;
/*!40000 ALTER TABLE `goals` DISABLE KEYS */;
INSERT INTO `goals` VALUES
(1,1,NULL,'tea',200.00,800.00,0.00,'2022-08-06'),
(2,1,NULL,'VAN',8000.00,8000.00,0.00,'2022-08-31');
/*!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 AUTO_INCREMENT=3 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 */;
INSERT INTO `onlinetemp` VALUES
(1,'c3be531f4e5b6ce42c4c',358,'1','/1/4/6/7/8/25/27/28','2022-04-16','Online','',0,0,1750,1750,'pending','USERNAME'),
(2,'c3be531f4e5b6ce42c4c',358,'2','/34','2022-04-16','Online','',0,0,10000,10000,'pending','USERNAME');
/*!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 */;
INSERT INTO `role` VALUES
(2,'Transactions'),
(3,'Income'),
(4,'Expense'),
(5,'Accounts'),
(6,'Track Budget'),
(7,'Set Goals'),
(8,'Calendar'),
(9,'Income Category'),
(10,'Expense Category'),
(11,'Income Reports'),
(12,'Expense Category'),
(13,'Income vs Expense Reports'),
(14,'Income Monthly Report'),
(15,'Expense Monthly Report'),
(16,'Account Transaction Reports'),
(17,'User Role'),
(18,'Application Setting'),
(19,'Upcoming Income'),
(20,'Upcoming Expense');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roleaccess`
--

DROP TABLE IF EXISTS `roleaccess`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roleaccess` (
  `roleaccessid` int(5) NOT NULL AUTO_INCREMENT,
  `roleid` int(5) NOT NULL,
  `userid` int(5) NOT NULL,
  PRIMARY KEY (`roleaccessid`),
  KEY `deleteroleaccess` (`userid`),
  CONSTRAINT `deleteroleaccess` FOREIGN KEY (`userid`) REFERENCES `users_new` (`userid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roleaccess`
--

LOCK TABLES `roleaccess` WRITE;
/*!40000 ALTER TABLE `roleaccess` DISABLE KEYS */;
INSERT INTO `roleaccess` VALUES
(18,2,1),
(19,3,1),
(20,4,1),
(21,5,1),
(22,6,1),
(23,7,1),
(24,8,1),
(25,9,1),
(26,10,1),
(27,11,1),
(28,12,1),
(29,13,1),
(30,14,1),
(31,15,1),
(32,16,1),
(33,17,1),
(34,18,1),
(35,19,1),
(36,20,1);
/*!40000 ALTER TABLE `roleaccess` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `settingsid` int(11) NOT NULL 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
(1,'evi money','HUBLI','Vidyanagar - hubli','evi','8050482213','evilogo.jpg','Rs','en','d/m/Y');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stud_basic`
--

DROP TABLE IF EXISTS `stud_basic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stud_basic` (
  `Name` varchar(1000) NOT NULL,
  `Stud_Id` int(11) NOT NULL AUTO_INCREMENT,
  `Gender` varchar(100) NOT NULL DEFAULT 'None',
  `Class` varchar(100) NOT NULL,
  `Division` varchar(100) NOT NULL,
  `Reg_No` varchar(100) DEFAULT NULL,
  `Phone` bigint(20) NOT NULL,
  `Email` varchar(30) NOT NULL,
  `Message` varchar(10000) DEFAULT NULL,
  `Status` int(11) NOT NULL DEFAULT 0,
  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 AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subcategory`
--

LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
INSERT INTO `subcategory` VALUES
(1,7,'School',1,'school'),
(2,7,'Offline Management',1,NULL),
(3,7,'College',1,NULL),
(4,8,'AMC',1,NULL),
(5,8,'SALES',1,NULL),
(6,8,'SALES',1,NULL),
(7,10,'DOMAIN AND HOSTING',1,NULL),
(8,11,'SOFTWARE SALES',1,NULL),
(9,12,'SSLC',1,NULL),
(10,12,'PUC',1,NULL),
(11,12,'GAS',1,NULL),
(12,12,'NEET',1,NULL),
(13,12,'STUDENT LIST',1,NULL),
(14,12,'TEACHER LIST',1,NULL),
(15,16,'Personal',2,NULL),
(16,16,'Official',2,NULL),
(17,2,'Tag',2,NULL),
(18,2,'folder',2,NULL),
(19,17,'Laptop',1,NULL),
(20,17,'Desktop',1,NULL),
(21,10,'Domain and Hosting',1,NULL),
(22,10,'Design',1,NULL),
(23,19,'Laptop',2,NULL),
(24,19,'Desktop',2,NULL),
(25,20,'Domain and hosting',2,NULL),
(27,13,'salary',2,NULL),
(28,2,'Ribban',2,NULL),
(29,2,'UHF Card',2,NULL),
(30,2,'RFID Card',2,NULL),
(31,23,'Tution Fee',2,NULL),
(32,24,'Personal Exp',2,NULL),
(33,25,'Content',1,NULL),
(34,26,'Content',2,NULL),
(35,27,'DXN Exp',2,NULL),
(36,3,'Id card income',1,NULL),
(37,7,'Online Softwere',1,NULL),
(38,22,'Rent',2,NULL),
(39,29,'d2h dish',2,NULL),
(40,30,'Gas',2,NULL),
(41,31,'Electrical bill',2,NULL),
(42,32,'vegitables',2,NULL),
(43,33,'Milk',2,NULL),
(44,34,'Glossarry',2,NULL),
(45,35,'Salary',2,NULL),
(46,36,'Antivirus',1,NULL),
(47,37,'Antivirus',2,NULL),
(48,38,'Others',2,NULL),
(49,39,'SMS Purchase',2,NULL),
(51,40,'Currency',2,NULL),
(52,43,'Services and spare',2,NULL),
(53,44,'Swaroopa Exp',2,NULL),
(54,45,'Job Refferance',1,NULL),
(55,46,'Other',1,NULL);
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbladmin`
--

DROP TABLE IF EXISTS `tbladmin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbladmin` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `AdminName` varchar(200) DEFAULT NULL,
  `UserName` varchar(200) DEFAULT NULL,
  `MobileNumber` bigint(10) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `Password` varchar(200) DEFAULT NULL,
  `AdminRegdate` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbladmin`
--

LOCK TABLES `tbladmin` WRITE;
/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
INSERT INTO `tbladmin` VALUES
(1,'Admin','admin',1234567890,'admin@gmail.com','f925916e2754e5e03f75dd58a5733251','2020-06-25 07:19:31');
/*!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 AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction`
--

LOCK TABLES `transaction` WRITE;
/*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
INSERT INTO `transaction` VALUES
(2,1,17,6,'ID TAG',1200.00,'1','2022-08-08',2,'tag for annigeri',NULL),
(3,1,18,6,'card folder',2600.00,'2','2022-08-03',2,'Annigeri folder',NULL),
(4,1,19,6,'Ganachari Bailhongal',16000.00,'1','2022-08-01',1,'Sale of RF Laptop',NULL),
(5,1,23,6,'Lackky RF Computers',13000.00,'1','2022-08-10',2,'Paid 13k by Bailhongal Product Laptop',NULL),
(6,1,22,6,'Bairidevarkoppa',5500.00,'2','2022-08-02',1,'Design receive  amount',NULL),
(7,1,27,1,'Daddubai smsoft',10000.00,'3','2022-08-11',2,'paid smsoft work',NULL),
(8,1,15,6,'swaroopa',500.00,'4','2022-08-09',2,'belagavi expenditure',NULL),
(9,1,28,1,'Id Card Ribban',6000.00,'5','2022-08-02',2,'purchase two ribban',NULL),
(10,1,31,1,'Prajnya T-shirt',250.00,'6','2022-08-02',2,'purchase T-shirt',NULL),
(11,1,32,1,'meshoo top',264.00,'7','2022-08-03',2,'top Purchase in meshoo',NULL),
(12,1,33,1,'Gajendragada Content',67500.00,'8','2022-08-04',1,'vidwat Content Sale',NULL),
(13,1,35,1,'DXN Products',1135.00,'9','2022-08-05',2,'Purchase of noni, tablet, brush,',NULL),
(14,1,36,1,'ID card Annigeri',63120.00,'10','2022-08-06',1,'Annigeri Id card payment receive',NULL),
(15,1,1,1,'Alanda school softwere payment',9000.00,'11','2022-08-06',1,'software purchase amount',NULL),
(16,1,32,1,'Movie Vikrant Rona',624.00,'12','2022-08-07',2,'movie exp',NULL),
(17,1,32,1,'kunda purchase',180.00,'13','2022-08-09',2,'purchase kunda',NULL),
(18,1,2,1,'S.G. Sintri offline software',8000.00,'14','2022-08-10',1,'offline software payment',NULL),
(19,1,27,1,'Daddubai',10000.00,'15','2022-08-11',2,'smsoft Salary',NULL),
(20,1,38,1,'House Rent',7000.00,'16','2022-08-11',2,'Rent for july Month',NULL),
(21,1,39,1,'d2h cable',305.00,'17','2022-07-01',2,'Cable bill',NULL),
(22,1,44,1,'Focus Mart kirani',259.00,'19','2022-07-02',2,'kirani',NULL),
(23,1,7,1,'Website K.H.Patil College',3500.00,'20','2022-07-02',1,'Web Renewal',NULL),
(24,1,46,1,'Jss Sakri Antivirus',3350.00,'22','2022-07-04',1,'Sakri law college Antivirus',NULL),
(25,1,44,1,'Focus mart kirani',4565.00,'23','2022-07-04',2,'Purchase Glossarry',NULL),
(26,1,48,1,'Narsingrao L. Anegondi',250.00,'24','2022-07-05',2,'Other',NULL),
(27,1,27,1,'Daddubhai',2375.00,'25','2022-07-05',2,'salary',NULL),
(28,1,49,1,'Transactional sms purchase',9000.00,'26','2022-07-06',2,'SMS purchase',NULL),
(29,1,32,1,'swaroopa',1000.00,'27','2022-07-09',2,'mounthly pesonal exp',NULL),
(30,1,29,1,'UHF Card purchase',9400.00,'29','2022-07-09',2,'UHF card purchase',NULL),
(31,1,32,1,'Prajnya Exp',1950.00,'30','2022-07-12',2,'Prajnya school bag, tiffen bag',NULL),
(32,1,51,1,'Prajnya Currency',99.00,'31','2022-07-12',2,'Prajnya airtel currency',NULL),
(33,1,27,1,'Daddubhai softwere',10000.00,'32','2022-07-13',2,'softwere Payment',NULL),
(34,1,44,1,'Focus mart',4914.00,'33','2022-07-15',2,'Kirani Purchase',NULL),
(35,1,34,1,'Praveen Naidu (Vishw time) kukanoor content',18700.00,'34','2022-07-16',2,'Kukanoor Content Purchase',NULL),
(36,1,34,1,'Vidyavan Learning Gajendrgad Content',10000.00,'35','2022-07-16',2,'Gajendragada Content purchase',NULL),
(37,1,45,1,'Swaroopa',1500.00,'37','2022-07-15',2,'Swaroopa Salary',NULL),
(38,1,34,1,'Gajendrgada Content Vidyavan learning services',25000.00,'38','2022-07-18',2,'Gajendragada Content Payment',NULL),
(39,1,44,1,'Focus mart',613.00,'39','2022-07-18',2,'Kirani',NULL),
(40,1,32,1,'Prajnya',58.00,'40','2022-07-18',2,'Prajnya xerox other',NULL),
(41,1,32,1,'Prutvi Paradise',1441.00,'41','2022-07-20',2,'Personal exp',NULL),
(42,1,3,2,'ID Pu College Hospet',30685.00,'43','2022-08-12',1,'one year amount Recive',NULL),
(43,1,52,1,'SuperSynic Technology',2301.00,'44','2022-07-21',2,'Annigeri Brodcost machine Repair',NULL),
(44,1,53,1,'Croma Bluetooth',999.00,'46','2022-07-21',2,'Bluetooth Purchase',NULL),
(45,1,27,1,'daddubhai payment',10000.00,'47','2022-07-22',2,'Static website payment',NULL),
(46,1,48,1,'Stationary',9.00,'48','2022-07-26',2,'xerox',NULL),
(47,1,44,1,'Raghavendra store',340.00,'50','2022-07-26',2,'Glossary Pooja saman raghavendra store',NULL),
(48,1,53,1,'Swaroopa',200.00,'51','2022-07-26',2,'Rakhi purchase',NULL),
(49,1,32,1,'swaroopa',1000.00,'55','2022-07-27',2,'vinod saree payment',NULL),
(50,1,39,1,'d2h cable',349.00,'55','2022-07-29',2,'cablebill',NULL),
(51,1,32,1,'online Rakhi purchase',164.00,'56','2022-07-31',2,'Rakhi perchase',NULL),
(52,1,41,1,'current bill',623.00,'54','2022-07-05',2,'current bill june',NULL),
(53,1,38,1,'house rent',7000.00,'56','2022-07-09',2,'June Rent',NULL),
(54,1,54,1,'Lohit MG',10000.00,'57','2022-07-29',1,'Job Refferance',NULL),
(55,1,41,1,'current bill July',1117.00,'58','2022-07-29',2,'current bill july',NULL),
(56,1,31,1,'akrut tution fee',4000.00,'59','2022-07-29',2,'Tution fee',NULL),
(57,1,55,1,'Shruti sagar',100.00,'60','2022-08-12',1,'Rakhi amount',NULL);
/*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_permission`
--

DROP TABLE IF EXISTS `user_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `menu` varchar(500) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=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,'admin@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-02-24  0:00:24