|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.217.3 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/admin/backup/SNENG/../SNCBSE/../PEAS/ |
| [ 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_PEAS_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, `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 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, `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 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 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, `year` varchar(20) DEFAULT NULL, PRIMARY KEY (`UID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stud_basic2` -- LOCK TABLES `stud_basic2` WRITE; /*!40000 ALTER TABLE `stud_basic2` DISABLE KEYS */; /*!40000 ALTER TABLE `stud_basic2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `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 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`) ) 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=101 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,'adminFees912','8c66a07ea8beee2c8326d6d66b7750159d592accfe5527478a2a566422392f4b','182f20f77d05fd13','e.vision.infotech56@gmail.com','Fees_Management','Admin@531'), (77,'Adminstudent912','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'), (96,'tcg','4125794df8b62147beb85227005f9eb113d4c894dc492d1150cc16de2afa4d31','55799e1029f1acc7',NULL,'Teacher','123456@Rr'), (97,'Highschool','201f5edf749d933fc2e2b0916de08ded613cd31ddb3f035f79bdd29698bb5152','7624c4e87dbaf4ca',NULL,'Student_Management','Admin@123'), (98,'primary','e77a3a3cf76aaa970f41284becb25975c0eaf0afb6d6f0681b1d3cff8442c53c','2a763c3b6d90c977',NULL,'Student_Management','Admin@123'), (99,'preprimary','4e32fad005879bd4ee08d12b869f96e56c1b0db705313bcc0d1a7c755931776c','5e934ba64cd77c6f',NULL,'Student_Management','Admin@123'), (100,'MUNNOLLI','e52d7fb89393bd0d3e99e7f481e384654dbc3064ee751f92f2d88fdf4a0b2a66','287e23a940dfe88f',NULL,'Student_Management','Skm@98444'); /*!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 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-06-05 0:00:41