Al-HUWAITI Shell
Apache/2.4.52 (Ubuntu) Linux srv913213 5.15.0-179-generic #189-Ubuntu SMP Tue May 5 18:20:56 UTC 2026 x86_64 www-data ( 33 )7.4.33 pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, / var /www / Upload File :
Current File : //var/www/u849362929_productdb.sql -- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 29, 2025 at 10:51 AM
-- Server version: 10.11.10-MariaDB
-- PHP Version: 7.2.34
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `u849362929_productdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `account_configuration`
--
CREATE TABLE `account_configuration` (
`account_configuration_id` int(11) NOT NULL,
`domain_name` varchar(255) DEFAULT NULL,
`language` varchar(200) DEFAULT NULL,
`timezone` text DEFAULT NULL,
`currency_code` varchar(255) DEFAULT NULL,
`currency_symbol` varchar(100) DEFAULT NULL,
`theme_colour` varchar(100) DEFAULT NULL,
`theme_font` varchar(100) DEFAULT NULL,
`precision_count` int(11) DEFAULT NULL,
`branch_id` int(11) DEFAULT NULL,
`package_id` int(11) DEFAULT NULL,
`package_history_id` int(11) DEFAULT NULL,
`package_start_datetime` datetime DEFAULT NULL,
`package_end_datetime` datetime DEFAULT NULL,
`username` varchar(100) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`no_of_card_issued` int(50) DEFAULT NULL,
`account_created_on` date DEFAULT NULL,
`account_status` int(11) DEFAULT NULL,
`database_name` varchar(50) DEFAULT NULL,
`date_format` varchar(11) DEFAULT NULL,
`date_separator` varchar(255) DEFAULT NULL,
`time_format` varchar(255) DEFAULT NULL,
`no_of_student` int(11) DEFAULT NULL,
`no_of_employee` int(11) DEFAULT NULL,
`approx_visitor_card` int(11) DEFAULT NULL,
`student_employee_card` int(11) DEFAULT NULL,
`visitor_card` int(11) DEFAULT NULL,
`setup_fee` decimal(20,2) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `account_configuration`
--
INSERT INTO `account_configuration` (`account_configuration_id`, `domain_name`, `language`, `timezone`, `currency_code`, `currency_symbol`, `theme_colour`, `theme_font`, `precision_count`, `branch_id`, `package_id`, `package_history_id`, `package_start_datetime`, `package_end_datetime`, `username`, `password`, `no_of_card_issued`, `account_created_on`, `account_status`, `database_name`, `date_format`, `date_separator`, `time_format`, `no_of_student`, `no_of_employee`, `approx_visitor_card`, `student_employee_card`, `visitor_card`, `setup_fee`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, NULL, 'en', 'Asia/Kolkata', 'INR', 'Rs', 'tgss-navy', 'Trebuchet MS', NULL, 1, 9, 40, '2020-09-21 21:57:16', '2020-11-16 18:05:40', 'test@petalpurple.com', 'f925916e2754e5e03f75dd58a5733251', 601, '2020-08-22', NULL, NULL, 'MM DD YYYY', '/', '24', 500, 100, 600, NULL, 600, 0.00, '2020-04-14 11:15:17', '1', '2020-10-16 18:05:40', '1'),
(24, NULL, 'en', 'Asia/Kolkata', 'INR', 'Rs', 'tgss-navy', 'Roboto', NULL, 24, 9, 39, '2020-08-25 18:43:57', '2023-08-25 18:43:57', 'nivedha@technogenesis.in', 'f925916e2754e5e03f75dd58a5733251', 600, '2020-08-25', NULL, NULL, 'DD MM YYYY', '-', '12', 500, 100, 600, NULL, 600, 100000.00, '2020-08-25 18:38:20', '1', '2020-08-25 18:43:57', '1'),
(25, NULL, 'en', 'Asia/Kolkata', 'INR', 'Rs', 'tgss-navy', 'Roboto', NULL, 25, 9, 41, '2020-10-20 16:25:34', '2021-10-20 16:25:34', 'aravind@gmail.com', '8800aa96cfd68ed3e987108a39233c3b', 1100, '2020-10-20', NULL, NULL, 'DD MM YYYY', '/', '24', 1000, 100, 100, NULL, 100, 100000.00, '2020-10-20 16:21:53', '1', '2020-10-20 16:25:34', '1'),
(26, NULL, 'en', 'Asia/Kolkata', 'INR', 'Rs', 'tgss-navy', 'Roboto', NULL, 26, 9, 42, '2020-12-17 10:41:13', '2023-12-17 10:41:13', 'nivee@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 1150, '2020-12-17', NULL, NULL, 'YYYY MM DD', '-', '24', 1000, 150, 1150, NULL, 1150, 100000.00, '2020-12-17 10:41:13', '1', NULL, NULL),
(27, NULL, 'en', 'Asia/Kolkata', 'INR', 'Rs', 'tgss-navy', 'Roboto', NULL, 27, 10, 43, '2020-12-17 10:54:04', '2021-01-17 10:54:04', 'niv@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 15, '2020-12-17', NULL, NULL, 'DD MM YYYY', '-', '12', 10, 5, 15, NULL, 15, 0.00, '2020-12-17 10:54:04', '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `activity_log`
--
CREATE TABLE `activity_log` (
`activity_log_id` int(11) NOT NULL,
`description` text DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(500) DEFAULT NULL,
`activity_type` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `activity_type`
--
CREATE TABLE `activity_type` (
`activity_type_id` int(11) NOT NULL,
`activity_type_name` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `assets`
--
CREATE TABLE `assets` (
`asset_id` int(11) NOT NULL,
`asset_name` varchar(255) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(25) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `attendance`
--
CREATE TABLE `attendance` (
`attendance_id` bigint(20) NOT NULL,
`employee_id` bigint(20) NOT NULL,
`service_location_id` bigint(20) NOT NULL,
`check_in_date` date NOT NULL,
`check_in_time` time NOT NULL,
`check_in_latitude` varchar(2000) DEFAULT NULL,
`check_in_longitude` varchar(2000) DEFAULT NULL,
`check_out_date` date DEFAULT NULL,
`check_out_time` time DEFAULT NULL,
`check_out_latitude` varchar(2000) DEFAULT NULL,
`check_out_longitude` varchar(2000) DEFAULT NULL,
`parent_id` int(11) NOT NULL DEFAULT 0,
`device_type` tinyint(1) NOT NULL COMMENT '1-mobile, 2-web',
`device_information` text DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`updated_by` bigint(20) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0-inactive, 1-active',
`check_in_address` varchar(500) DEFAULT NULL,
`check_out_address` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `auth_login_attempts`
--
CREATE TABLE `auth_login_attempts` (
`id` int(11) NOT NULL,
`ip_address` varchar(39) DEFAULT '0',
`timestamp` datetime DEFAULT NULL,
`login_attempts` tinyint(2) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `blood_group`
--
CREATE TABLE `blood_group` (
`blood_group_id` int(11) NOT NULL,
`name` varchar(20) DEFAULT NULL,
`status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `branch`
--
CREATE TABLE `branch` (
`branch_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`school_name` varchar(355) DEFAULT NULL,
`logo` varchar(355) DEFAULT NULL,
`address_line1` varchar(355) DEFAULT NULL,
`address_line2` varchar(355) DEFAULT NULL,
`state_id` int(11) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`zipcode` varchar(20) DEFAULT NULL,
`registration_code` varchar(50) DEFAULT NULL,
`phone` varchar(15) DEFAULT NULL,
`mobile` varchar(15) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`website` varchar(355) DEFAULT NULL,
`status` int(11) DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL,
`firebase_token` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `branch`
--
INSERT INTO `branch` (`branch_id`, `customer_id`, `school_name`, `logo`, `address_line1`, `address_line2`, `state_id`, `city_id`, `country_id`, `zipcode`, `registration_code`, `phone`, `mobile`, `email`, `website`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`, `firebase_token`) VALUES
(1, 1, 'Cute hearts little school', 'Cute-Hearts-Play-School-1598029803-BqVFbgIhrH.png', '1-2-2a1', 'Old post office street', 33, 647, 102, '624211', '12345456', '9080022702', '9090909909', 'tgtest2020@gmail.com', NULL, 1, '2020-04-14 11:15:17', '1', '2020-10-16 17:46:49', '1', 'fCnzQTBvWW7B7vyBq0_k7h:APA91bGOI8zQt-Y6Oiy9xavPwlwqjExX7ds_25hlxeKHX9iZH3BIHqHg8bcfDcRJF0fy7uxdJ__HjYYF-dFgjncgnG9GPdwTHby2HnJoas6C6kpsNxlbZHEPuLPwL1vxyXR9e-zIX0Vn'),
(24, 3, 'TVS International School', 'TVS-International-School-1598360900-SbiDwPRyoy.png', '123, Vallabha Street', '4th Avenue', 33, 647, 102, '625010', 'TVS001234', '04529090900', '9790261892', 'nivedha@technogenesis.in', 'https://www.tvs.in', 1, '2020-08-25 18:38:20', '1', '2020-08-25 18:43:57', '1', NULL),
(25, 7, 'Aravind Petal School', 'Aravind-Petal-School-1603191113-FHIfzrwJYG.png', 'No 40, Meenakshi Nagar', 'Needhi Nagar ,Othakadai', 33, 647, 102, '625107', 'REG001', '4916161651651', '7502532515', 'ak@gmail.edu', 'https://www.aravind.petalpurple.com', 1, '2020-10-20 16:21:53', '1', '2020-10-20 16:25:34', '1', NULL),
(26, 8, 'Krishnamal Ramasubbaiyer CBSE School', '', 'Eliyarpatti', NULL, 33, 647, 102, '625022', 'KRS123', '096777 61917', '9677761917', 'nivedha@technogenesis.in', NULL, 1, '2020-12-17 10:41:13', '1', NULL, NULL, NULL),
(27, 7, 'Dolphin School', '', '12/1 Nehru street', NULL, 33, 638, 102, '625010', 'fd3', NULL, '7987879789', 'niv@mail.com', NULL, 2, '2020-12-17 10:54:04', '1', '2020-12-17 10:54:17', '1', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cancel_hour`
--
CREATE TABLE `cancel_hour` (
`cancel_hour_id` int(11) NOT NULL,
`cancel_hours` varchar(25) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `category_type`
--
CREATE TABLE `category_type` (
`category_type_id` int(11) NOT NULL,
`category_type` varchar(255) DEFAULT NULL,
`status` tinyint(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cms_page`
--
CREATE TABLE `cms_page` (
`cms_page_id` int(11) NOT NULL,
`slug` varchar(500) DEFAULT NULL,
`content` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `code_standard`
--
CREATE TABLE `code_standard` (
`code_standard_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`standard_name` varchar(255) DEFAULT NULL,
`status` tinyint(11) NOT NULL DEFAULT 1,
`created_by` varchar(11) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_by` varchar(25) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `company_document`
--
CREATE TABLE `company_document` (
`company_document_id` int(11) NOT NULL,
`document_type_id` int(11) NOT NULL,
`document_name` text NOT NULL,
`created_on` datetime NOT NULL,
`created_by` int(11) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `company_document`
--
INSERT INTO `company_document` (`company_document_id`, `document_type_id`, `document_name`, `created_on`, `created_by`, `status`) VALUES
(1, 1, '1582354632.odt', '2020-02-22 12:27:12', 1, 2),
(2, 1, '1582354651.xlsx', '2020-02-22 12:27:31', 1, 2),
(3, 1, '1582544760.pdf', '2020-02-24 05:16:00', 1, 1),
(4, 1, '1582603683.pdf', '2020-02-25 09:38:03', 1, 1),
(5, 1, '1583230867.rtf', '2020-03-03 03:51:07', 1, 2),
(6, 1, '1583230879.bmp', '2020-03-03 03:51:19', 1, 1),
(7, 1, '1583230890.txt', '2020-03-03 03:51:30', 1, 1),
(8, 1, '1583230913.odt', '2020-03-03 03:51:53', 1, 2),
(9, 1, '1583303625.odt', '2020-03-04 12:03:45', 1, 2);
-- --------------------------------------------------------
--
-- Table structure for table `company_information`
--
CREATE TABLE `company_information` (
`company_id` int(11) NOT NULL,
`company_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`mobile` int(50) DEFAULT NULL,
`alternate_email` varchar(255) DEFAULT NULL,
`landline` varchar(12) DEFAULT NULL,
`gst_no` varchar(21) DEFAULT NULL,
`pan_no` varchar(21) DEFAULT NULL,
`web_site` varchar(255) DEFAULT NULL,
`address_line_1` varchar(255) DEFAULT NULL,
`address_line_2` varchar(255) DEFAULT NULL,
`landmark` varchar(255) DEFAULT NULL,
`pincode` varchar(6) DEFAULT NULL,
`country_id` int(11) NOT NULL,
`state_id` int(21) DEFAULT NULL,
`city_id` int(21) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `company_information`
--
INSERT INTO `company_information` (`company_id`, `company_name`, `email`, `mobile`, `alternate_email`, `landline`, `gst_no`, `pan_no`, `web_site`, `address_line_1`, `address_line_2`, `landmark`, `pincode`, `country_id`, `state_id`, `city_id`, `created_on`, `created_by`) VALUES
(1, 'Petals automation', 'nivedha@technogenesis.in', 98989898, '', '', '12345', '6666777888', '', '1/2 north steert', 'madurai', '', '624211', 0, 12, 121, '2020-03-13 00:00:00', '1');
-- --------------------------------------------------------
--
-- Table structure for table `country`
--
CREATE TABLE `country` (
`country_id` int(11) NOT NULL,
`country_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `country`
--
INSERT INTO `country` (`country_id`, `country_name`) VALUES
(102, 'India');
-- --------------------------------------------------------
--
-- Table structure for table `crm_menu`
--
CREATE TABLE `crm_menu` (
`crm_menu_id` int(11) NOT NULL,
`menu_name` varchar(150) DEFAULT NULL,
`icon_type` varchar(15) DEFAULT NULL,
`icon` varchar(150) DEFAULT NULL,
`url_type` varchar(150) DEFAULT NULL,
`url` text DEFAULT NULL,
`menu_action` varchar(255) DEFAULT NULL,
`menu_group_id` int(11) DEFAULT NULL,
`url_target` varchar(150) DEFAULT NULL,
`menu_class` text DEFAULT NULL,
`active` tinyint(1) DEFAULT NULL,
`parent` int(111) DEFAULT 0,
`sort` int(111) NOT NULL DEFAULT 0,
`accesskey` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `crm_menu`
--
INSERT INTO `crm_menu` (`crm_menu_id`, `menu_name`, `icon_type`, `icon`, `url_type`, `url`, `menu_action`, `menu_group_id`, `url_target`, `menu_class`, `active`, `parent`, `sort`, `accesskey`) VALUES
(1, 'Users.create', NULL, NULL, '', 'users_create', 'create', 1, NULL, NULL, 1, 0, 0, NULL),
(2, 'Users.update', NULL, NULL, '', 'users_update', 'update', 1, NULL, NULL, 1, 0, 0, NULL),
(4, 'Users.activate/inactivate/delete', NULL, NULL, '', 'users_status', 'activate/inactivate/delete', 1, NULL, NULL, 1, 0, 0, NULL),
(5, 'Customer.create', NULL, NULL, '', 'customer_create', 'create', 2, NULL, NULL, 1, 0, 0, NULL),
(6, 'Customer.update', NULL, NULL, '', 'customer_update', 'update', 2, NULL, NULL, 1, 0, 0, NULL),
(8, 'Customer.activate/inactivate/delete', NULL, NULL, '', 'customer_status', 'activate/inactivate/delete', 2, NULL, NULL, 1, 0, 0, NULL),
(9, 'School.renew', NULL, NULL, '', 'school_renew', 'renew', 12, NULL, NULL, 1, 0, 0, NULL),
(10, 'Customer.download', NULL, NULL, '', 'customer_download', 'download', 2, NULL, NULL, 0, 0, 0, NULL),
(11, 'Roles.create', NULL, NULL, '', 'roles_create', 'create', 3, NULL, NULL, 1, 0, 0, NULL),
(12, 'Roles.update', NULL, NULL, '', 'roles_update', 'update', 3, NULL, NULL, 1, 0, 0, NULL),
(14, 'Roles.activate/inactivate/delete', NULL, NULL, '', 'roles_status', 'activate/inactivate/delete', 3, NULL, NULL, 1, 0, 0, NULL),
(17, 'Transaction.list', NULL, NULL, '', 'transaction_list', 'list', 5, NULL, NULL, 1, 0, 0, NULL),
(18, 'Transaction.paynow', NULL, NULL, '', 'transaction_paynow', 'paynow', 5, NULL, NULL, 1, 0, 0, NULL),
(19, 'Transaction.view', NULL, NULL, '', 'transaction_view', 'view', 5, NULL, NULL, 1, 0, 0, NULL),
(20, 'Transaction.cancel', NULL, NULL, '', 'transaction_cancel', 'cancel', 5, NULL, NULL, 1, 0, 0, NULL),
(23, 'Setupfee.create', NULL, NULL, '', 'setupfee_create', 'create', 6, NULL, NULL, 1, 0, 0, NULL),
(24, 'Setupfee.update', NULL, NULL, '', 'setupfee_update', 'update', 6, NULL, NULL, 1, 0, 0, NULL),
(26, 'Setupfee.activate/inactivate/delete', NULL, NULL, '', 'setupfee_status', 'activate/inactivate/delete', 6, NULL, NULL, 1, 0, 0, NULL),
(27, 'Package.create', NULL, NULL, '', 'package_create', 'create', 7, NULL, NULL, 1, 0, 0, NULL),
(28, 'Package.update', NULL, NULL, '', 'package_update', 'update', 7, NULL, NULL, 1, 0, 0, NULL),
(30, 'Package.activate/inactivate/delete', NULL, NULL, '', 'package_status', 'activate/inactivate/delete', 7, NULL, NULL, 1, 0, 0, NULL),
(31, 'Packageplan.create', NULL, NULL, '', 'packageplan_create', 'create', 8, NULL, NULL, 1, 0, 0, NULL),
(32, 'Packageplan.update', NULL, NULL, '', 'packageplan_update', 'update', 8, NULL, NULL, 1, 0, 0, NULL),
(34, 'Packageplan.activate/inactivate/delete', NULL, NULL, '', 'packageplan_status', 'activate/inactivate/delete', 8, NULL, NULL, 1, 0, 0, NULL),
(36, 'Tax.update', NULL, NULL, '', 'tax_update', 'update', 9, NULL, NULL, 1, 0, 0, NULL),
(37, 'Ticket.list', NULL, NULL, '', 'ticket_list', 'list', 10, NULL, NULL, 0, 0, 0, NULL),
(39, 'Users.list', NULL, NULL, '', 'users_list', 'list', 1, NULL, NULL, 1, 0, 0, NULL),
(40, 'Users.change password', NULL, NULL, '', 'users_changepassword', 'change password', 1, NULL, NULL, 1, 0, 0, NULL),
(42, 'Customer.view', NULL, NULL, '', 'customer_view', 'view', 2, NULL, NULL, 1, 0, 0, NULL),
(43, 'Customer.list', NULL, NULL, '', 'customer_list', 'list', 2, NULL, NULL, 1, 0, 0, NULL),
(45, 'Package.list', NULL, NULL, '', 'package_list', 'list', 7, NULL, NULL, 1, 0, 0, NULL),
(46, 'Packageplan.view', NULL, NULL, '', 'packageplan_view', 'view', 8, NULL, NULL, 1, 0, 0, NULL),
(47, 'Packageplan.list', NULL, NULL, '', 'packageplan_list', 'list', 8, NULL, NULL, 1, 0, 0, NULL),
(48, 'Setupfee.list', NULL, NULL, '', 'setupfee_list', 'list', 6, NULL, NULL, 1, 0, 0, NULL),
(50, 'Roles.list', NULL, NULL, '', 'roles_list', 'list', 3, NULL, NULL, 1, 0, 0, NULL),
(52, 'Ticket.view', NULL, NULL, '', 'ticket_view', 'view', 10, NULL, NULL, 1, 0, 0, NULL),
(54, 'Ticket.action', NULL, NULL, '', 'ticket_action', 'action', 10, NULL, NULL, 0, 0, 0, NULL),
(55, 'Ticket.reply', NULL, NULL, '', 'ticket_reply', 'reply', 10, NULL, NULL, 0, 0, 0, NULL),
(56, 'Ticket.assignee', NULL, NULL, '', 'ticket_assignee', 'assignee', 10, NULL, NULL, 0, 0, 0, NULL),
(57, 'School.create', NULL, NULL, '', 'branch_create', 'create', 12, NULL, NULL, 1, 0, 0, NULL),
(58, 'School.update', NULL, NULL, '', 'branch_update', 'update', 12, NULL, NULL, 1, 0, 0, NULL),
(59, 'School.list', NULL, NULL, '', 'branch_list', 'list', 12, NULL, NULL, 1, 0, 0, NULL),
(60, 'School.view', NULL, NULL, '', 'branch_view', 'view', 12, NULL, NULL, 1, 0, 0, NULL),
(61, 'School.activate/inactivate/delete', NULL, NULL, '', 'branch_status', 'activate/inactivate/delete', 12, NULL, NULL, 1, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cr_prd_image`
--
CREATE TABLE `cr_prd_image` (
`cr_prd_image_id` int(11) NOT NULL,
`captured_image` varchar(500) DEFAULT NULL,
`reason` char(255) DEFAULT NULL,
`cr_type_id` int(11) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL COMMENT '0-mail not sent , 1- mail sent',
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`product_management_id` int(11) DEFAULT NULL,
`employee_id` int(11) DEFAULT NULL,
`reviewed_by` int(11) DEFAULT NULL COMMENT 'customer contact person id',
`reviewed_on` datetime DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cr_type`
--
CREATE TABLE `cr_type` (
`cr_type_id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `customer`
--
CREATE TABLE `customer` (
`customer_id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`owner` varchar(255) DEFAULT NULL,
`mobile` varchar(20) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`photo` varchar(255) DEFAULT NULL,
`contact_name` varchar(255) DEFAULT NULL,
`contact_mobile` varchar(20) DEFAULT NULL,
`contact_email` varchar(100) DEFAULT NULL,
`contact_position` varchar(255) DEFAULT NULL,
`contact_photo` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`domain` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(100) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` (`customer_id`, `name`, `owner`, `mobile`, `email`, `photo`, `contact_name`, `contact_mobile`, `contact_email`, `contact_position`, `contact_photo`, `username`, `password`, `domain`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 'Sathish', NULL, NULL, NULL, '', 'John', '9533443526', 'tgtest2019@gmail.com', 'Head Mistress', 'contact-person-1587471405-3IVcLPzLOu.png', 'tgtest2019@gmail.com', '37a6259cc0c1dae299a7866489dff0bd', NULL, 1, '2020-04-21 14:16:54', '1', '2020-10-20 16:13:16', '1'),
(3, 'TVS Group of Institution', 'Siva', '7200584644', 'tgtest2020@gmail.com', 'TVS-Group-of-Institution-1603002415-kWDSLpNT7N.png', 'Raja Pandi', '7200584644', 'raja@gmail.com', 'Managing Director', 'contact-person-1603002415-WMmEJXUj2y.png', 'raja@gmail.com', 'f925916e2754e5e03f75dd58a5733251', 'demo', 1, '2020-08-25 18:30:29', '1', '2020-10-20 16:07:06', '1'),
(4, 'Raj kamal Group of Institution', 'Chairman', '8610095013', 'rajkamal@petalpurple.com', 'Raj-kamal-Group-of-Institution-1603002756-JEFJx3872H.png', 'Raj Kamal', '8610095013', 'rajkamal@petalpurple.com', 'Managing Director', 'contact-person-1603002756-1cXkB8QfSF.png', 'rajkamal@petalpurple.com', 'f925916e2754e5e03f75dd58a5733251', 'Raj Kamal', 1, '2020-10-18 12:01:36', '1', '2020-10-20 16:07:06', '1'),
(5, 'Aravind BackiaRaj School', 'Aravind Backiaraj', '8072804882', 'aravindbacki@gmail.com', 'Aravind-BackiaRaj-School-1603190419-IKxSDwfu1L.png', 'Aravind Backi', '8072804882', 'aravindbacki@gmail.com', 'Owner', 'contact-person-1603190419-HYUM2a6mcd.png', 'aravindbacki@gmail.com', '38bed0efa135c8666268cef19115617e', 'aravind.petalpurple.com', 2, '2020-10-20 16:10:19', '1', '2020-10-20 16:11:18', '1'),
(6, 'Ak', 'ak@petalpurple.com', '7502532514', 'ak@petalpurple.com', 'Ak-1603190588-NIYeN12dBz.png', 'ak@petalpurple.com', '7502532514', 'ak@petalpurple.com', 'ak@petalpurple.com', 'contact-person-1603190588-b3SKMysNex.png', 'ak@gmail.com', 'c02a3ae21ee98f513489a0cb3e59616d', 'ak@petalpurple.com', 2, '2020-10-20 16:13:08', '1', '2020-10-20 16:13:16', '1'),
(7, 'Aravind School', 'aravin', '7868704545', 'aravind@petalpurple.com', 'Aravind--School-1603190832-FAQfbVUJrc.png', 'Suriya Prakash', '7867079711', 'suriya@gmail.com', 'Admin', 'contact-person-1603190832-LAX1KQDU46.png', 'suriya@gmail.com', '413882e418d7a4e907f37c40de39899b', 'aravind@petalpurpl.com', 1, '2020-10-20 16:17:12', '1', '2020-10-20 16:59:31', '1'),
(8, 'KRS Group of schools', NULL, NULL, NULL, 'KRS-Group-of-schools-1608181517-wFlVM2FVRF.png', 'Nivedha', '7200584644', 'nivedha@technogenesis.in', 'Owner', 'contact-person-1608181518-2w0p7Nc4Ez.png', 'nivedhaa@technogenesis.in', 'e10adc3949ba59abbe56e057f20f883e', 'krs.com', 1, '2020-12-17 10:35:18', '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `customer_contact`
--
CREATE TABLE `customer_contact` (
`customer_contact_id` int(11) NOT NULL,
`branch_id` int(11) DEFAULT NULL,
`contact_name` varchar(255) DEFAULT NULL,
`phone` varchar(25) DEFAULT NULL,
`mobile` varchar(15) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`photo` varchar(355) DEFAULT NULL,
`notes` varchar(355) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `customer_contact`
--
INSERT INTO `customer_contact` (`customer_contact_id`, `branch_id`, `contact_name`, `phone`, `mobile`, `email`, `photo`, `notes`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 2, 'raja', '04523223', '7845231123', 'tgtest2019@gmail.com', '2-contact-person-1586864084-SbGlIxsAU5.png', 'null', 2, NULL, NULL, '2020-04-16 10:39:55', '1'),
(2, 2, 'Raja', NULL, NULL, NULL, '2-contact-person-1586864209-BJ4kSfWzGv.png', NULL, 2, NULL, NULL, '2020-04-15 14:28:09', '1'),
(3, 9, 'raja', '04523223', '7845231123', 'raja@gmail.com', '9-contact-person-1586958227-jabjkTY20Q.png', 'dsfgsg', 2, '2020-04-15 13:43:47', '1', '2020-04-15 14:27:21', '1'),
(4, 9, 'kumar', '04523223', '7845231123', 'tgtest2019@gmail.com', '9-contact-person-1586959720-j1SpZkPvaz.png', 'sdfdsf', 2, NULL, NULL, '2020-04-15 14:26:52', '1'),
(5, 9, 'sivan', '04523223', '7845231123', 'tgtest2019@gmail.com', '9-contact-person-1586959882-K7m7PYSGGs.png', 'dsfgsg', 1, NULL, NULL, '2020-04-15 14:11:22', '1'),
(6, 9, 'fdgdfgd', '04523223', '7845231123', 'tgtest2019@gmail.com', '9-contact-person-1586959915-NeRk7ighL2.png', 'dfgdfg', 1, NULL, NULL, '2020-04-15 14:11:55', '1'),
(7, 9, 'ganesh', '04523223', '7845231123', 'ganesh@gmail.com', '9-contact-person-1586959957-krg1ZGUHkM.png', 'dsasdsf', 1, NULL, NULL, '2020-04-15 14:12:37', '1'),
(8, 13, 'raja', '04523223', '7845231123', 'tgtest2019@gmail.com', '13-contact-person-1587019703-9mgG9ncaPF.png', 'fdfgdfgd', 1, NULL, NULL, '2020-04-16 06:48:23', '1'),
(9, 11, 'raja', '04523223', '7845231123', 'tgtest2019@gmail.com', '11-contact-person-1587032607-Wa97ywuHXX.png', 'sfsdg', 1, NULL, NULL, '2020-04-16 10:23:27', '1'),
(10, 14, 'john', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'sadfaf', 2, NULL, NULL, '2020-04-16 10:42:57', '1'),
(11, 14, 'siva', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'safasfaf', 2, NULL, NULL, '2020-04-16 10:42:43', '1'),
(12, 14, 'john', '04523223', '7845231123', 'tgtest2019@gmail.com', '14-contact-person-1587033911-Q19wNx2TiJ.png', 'xvcxbvdfxb', 1, NULL, NULL, '2020-04-16 10:46:18', '1'),
(13, 16, 'raja', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-16 13:37:56', '1'),
(14, 16, 'siva', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-16 14:12:06', '1'),
(15, 16, 'raja', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-16 14:25:52', '1'),
(16, 17, 'nivedha', '', '', '', '17-contact-person-1587109870-UtMDPEclCk.png', '', 1, '2020-04-17 07:51:10', '1', NULL, NULL),
(17, 17, 'ganesh', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'dfgdfgdg', 1, '2020-04-17 07:51:10', '1', NULL, NULL),
(18, 18, 'siva', '', '', '', '18-contact-person-1587110494-DeqOTNB1PL.png', '', 1, '2020-04-17 08:01:34', '1', NULL, NULL),
(19, 18, 'kumar', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'fdffghfg', 1, '2020-04-17 08:01:34', '1', NULL, NULL),
(20, 19, 'Sathish', '0441234567', '9533443526', 'fhfgbn@ff.com', '19-contact-person-1587212486-WmbzJNULFU.png', 'wow', 1, '2020-04-18 17:51:26', '1', NULL, NULL),
(21, 20, 'raja', '', '', '', '20-contact-person-1587298287-4AiyCO4utA.png', '', 1, '2020-04-19 17:41:27', '1', NULL, NULL),
(22, 20, 'siva', '04523223', '7845231123', 'tgtest2019@gmail.com', '20-contact-person-1587298287-klM8N7FCSV.png', 'dxfedgsdx', 1, '2020-04-19 17:41:27', '1', NULL, NULL),
(23, 20, 'ganesh', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'hjkhuk', 1, '2020-04-19 17:41:27', '1', NULL, NULL),
(24, 20, 'nivedha', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'hgjgjg', 1, '2020-04-19 17:41:27', '1', NULL, NULL),
(25, 21, 'ganesh', '', '', '', '', '', 1, '2020-04-19 19:30:19', '1', NULL, NULL),
(26, 21, 'pandi', '04523223', '7845231123', 'tgtest2019@gmail.com', '', 'fgfghfh', 1, '2020-04-19 19:30:19', '1', NULL, NULL),
(27, 21, 'gp', '', '', '', '', '', 1, '2020-04-19 19:30:19', '1', NULL, NULL),
(28, 21, 'malik', '', '', '', '', '', 1, '2020-04-19 19:30:19', '1', NULL, NULL),
(29, 22, 'sivan', '', '', '', '', '', 1, '2020-04-19 19:40:44', '1', NULL, NULL),
(30, 22, 'kumar', '', '', '', '', '', 1, '2020-04-19 19:40:44', '1', NULL, NULL),
(31, 22, 'gp', '', '', '', '', '', 1, '2020-04-19 19:40:44', '1', NULL, NULL),
(32, NULL, 'johnn', NULL, NULL, NULL, '23-contact-person-1587306535-e25MmasJvK.png', NULL, 1, '2020-04-19 19:58:55', '1', '2020-04-20 19:43:49', '1'),
(33, NULL, 'siva', NULL, NULL, NULL, '', NULL, 1, '2020-04-19 19:58:55', '1', '2020-04-20 19:42:03', '1'),
(34, NULL, 'seeni', NULL, NULL, NULL, '', NULL, 1, '2020-04-19 19:58:55', '1', '2020-04-20 19:41:09', '1'),
(35, NULL, 'sivan', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-20 19:45:57', '1'),
(36, NULL, 'siva', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-20 19:52:31', '1'),
(37, NULL, 'sivan', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-20 19:54:08', '1'),
(38, 23, 'john212', '04523223', '7845231123', 'tgtest2019@gmail.com', '23-contact-person-1588075410-HDt1JY0vzs.png', 'dsgdsg', 2, NULL, NULL, '2020-04-28 17:36:36', '1'),
(39, 23, 'siva', NULL, NULL, NULL, '', NULL, 2, NULL, NULL, '2020-04-28 17:38:53', '1'),
(40, 23, 'sivan', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-28 17:39:04', '1'),
(41, 23, 'rajesh', 'null', 'null', 'null', '', 'null', 1, NULL, NULL, '2020-04-28 17:50:03', '1'),
(42, 23, 'kumar', NULL, NULL, NULL, '', 'vxfds', 1, NULL, NULL, '2020-04-28 18:05:00', '1'),
(43, 23, 'sivaaa', NULL, NULL, NULL, '', NULL, 1, NULL, NULL, '2020-04-28 18:02:46', '1'),
(44, 2, 'siva', '9898989898', '9999999999', 'sample@gmail.com', '2-contact-person-1588770516-N2t5hnmg7O.png', 'null', 2, '2020-05-04 13:28:07', '2', '2020-05-09 19:15:13', '2'),
(45, 2, NULL, NULL, NULL, NULL, '2-contact-person-1588757141-VP9dfuCxyQ.png', NULL, 2, '2020-05-06 14:55:41', '2', '2020-05-06 15:39:48', '2'),
(46, 2, NULL, NULL, NULL, NULL, '', NULL, 2, '2020-05-06 14:56:14', '2', '2020-05-06 15:39:41', '2'),
(47, 2, NULL, '04542009009', '9999999999', 'tgtest2019@gmail.com', '2-contact-person-1588759442-QmXMWYLguu.png', 'sdgdsgdsgh', 2, '2020-05-06 15:34:02', '2', '2020-05-06 15:39:39', '2'),
(48, 2, 'siva', '04542009009', '9999999999', 'tgtest2019@gmail.com', '2-contact-person-1588759838-QMqAD8a6j0.png', 'dsgsdgs', 2, '2020-05-06 15:40:38', '2', '2020-05-09 19:24:57', '2'),
(49, 2, 'Nivedha', '04522383876', '8888888888', 'tgtest2019@gmail.com', '2-contact-person-1588770411-92QKnw1e6g.png', 'Am the contact person', 2, '2020-05-06 18:36:51', '2', '2020-05-09 19:24:57', '2'),
(50, 2, 'Selvi', 'null', 'null', 'tgtest2019@gmail.com', '2-contact-person-1588770443-Wolojc1e5L.png', 'null', 2, '2020-05-06 18:37:23', '2', '2020-05-09 19:15:15', '2'),
(51, 2, 'Deva', NULL, NULL, NULL, '', NULL, 2, '2020-05-06 18:37:31', '2', '2020-05-06 18:40:58', '2'),
(52, 2, 'Dev', 'null', 'null', 'null', '2-contact-person-1588771152-rs27do47V1.png', 'null', 2, '2020-05-06 18:46:21', '2', '2020-05-09 19:10:14', '2'),
(53, 2, 'Aadhi', '04522383876', '8888888888', 'adhi@gmail,com', '2-contact-person-1589031511-7c2DYPKGee.png', 'Am the contact person', 2, '2020-05-09 19:07:59', '2', '2020-05-09 19:15:16', '2'),
(54, 2, 'NIsha', NULL, NULL, NULL, '', NULL, 2, '2020-05-09 19:10:33', '2', '2020-05-09 19:15:18', '2'),
(55, 2, 'Nimmi', NULL, NULL, 'tgtest2019@gmail.com', '', NULL, 2, '2020-05-09 19:10:39', '2', '2020-05-09 19:15:21', '2'),
(56, 2, 'Nivedha', '04522383876', '7200584644', 'nivedha@technogenesis.in', '', 'Contact me for admission details...', 1, '2020-05-11 17:04:49', '2', NULL, NULL),
(57, 2, 'Jessy', 'null', 'null', 'jessy@gmail.com', '2-contact-person-1596269994-Caos3L5Trv.png', 'null', 1, '2020-05-11 17:05:28', '2', '2020-08-01 13:49:54', '5'),
(58, 2, 'Surya', 'null', 'null', 'null', '2-contact-person-1596269975-llURHYxI1v.png', 'null', 1, '2020-05-11 17:06:15', '2', '2020-08-01 13:49:35', '5'),
(59, 2, 'testt', 'null', 'null', 'test@gmaikl.com', '2-contact-person-1596269981-9MtVRXDL72.png', 'null', 1, '2020-05-11 17:08:00', '2', '2020-08-01 13:49:41', '5'),
(60, 2, 'Ganesh', NULL, NULL, NULL, '2-contact-person-1596269973-S6OuRL6zwv.png', NULL, 1, '2020-05-27 10:01:43', '1', '2020-08-01 13:49:33', '5'),
(61, 2, NULL, NULL, NULL, NULL, '2-contact-person-1591680767-66mYvTKspQ.png', NULL, 2, '2020-06-09 11:02:47', '1', '2020-07-19 21:20:02', '1'),
(62, 2, NULL, NULL, NULL, NULL, '2-contact-person-1596269966-owX5JE33Bf.png', NULL, 2, '2020-08-01 13:49:26', '5', '2020-08-02 23:35:52', '5'),
(63, 2, NULL, NULL, NULL, NULL, '2-contact-person-1596269973-cVfmvK4bMW.png', NULL, 2, '2020-08-01 13:49:33', '5', '2020-08-02 23:35:47', '5'),
(64, 2, NULL, NULL, NULL, NULL, '2-contact-person-1596269974-vmuB9Ncq56.png', NULL, 2, '2020-08-01 13:49:34', '5', '2020-08-02 23:35:44', '5'),
(65, 1, 'Nivedha', '04522383876', '7200584644', 'nivedha@technogenesis.in', '1-contact-person-1598028553-BgtQE4Yj1S.png', 'Contact me', 2, NULL, NULL, '2020-08-21 22:21:20', '1'),
(66, 1, 'vinot', 'null', 'null', 'null', '1-contact-person-1598079821-8L3PMjwbgA.png', 'null', 1, '2020-08-21 22:19:04', '1', '2020-08-22 12:33:41', '1'),
(67, 1, 'Nivedha', '04522383876', '7200584644', 'nivedha@technogenesis.in', '1-contact-person-1598029079-RVsIvZMkNi.png', 'Contact me', 2, NULL, NULL, '2020-08-21 22:28:32', '1'),
(68, 1, 'hari', NULL, NULL, NULL, '1-contact-person-1598029171-Thfn3P5IlF.png', NULL, 2, '2020-08-21 22:29:31', '1', '2020-08-22 12:55:49', '1'),
(69, 1, NULL, NULL, NULL, NULL, '1-contact-person-1598029172-ckm3QkRn5j.png', NULL, 2, '2020-08-21 22:29:32', '1', '2020-08-21 22:39:57', '1'),
(70, 1, 'hari', '15025325', '155218292', 'ad', '1-contact-person-1602850605-qEKf1pSpqJ.png', 'errtr', 1, '2020-08-22 12:57:44', '1', '2020-10-16 17:46:45', '1'),
(71, 24, 'Ganesh Pandi', '04522383876', '7200584644', 'ganesh@gmail.com', '', 'For admission contact me..', 1, '2020-08-25 18:38:20', '1', NULL, NULL),
(72, 1, NULL, '78181', NULL, NULL, '', NULL, 1, '2020-10-16 17:45:40', '1', NULL, NULL),
(73, 25, 'Suriya', '98498191499', '', 'suriya@gmail.com', '25-contact-person-1603191113-xl61DLmNgn.png', '', 2, '2020-10-20 16:21:53', '1', '2020-10-20 16:24:47', '1'),
(74, 25, 'Ajith', NULL, NULL, NULL, '25-contact-person-1603191318-7KvKrpurhf.png', NULL, 1, NULL, NULL, '2020-10-20 16:25:18', '1'),
(75, 1, 'Test', NULL, NULL, NULL, '', NULL, 1, '2020-10-21 18:19:39', '1', NULL, NULL),
(76, 26, 'Nivedha', '', '', '', '', '', 1, '2020-12-17 10:41:13', '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `customer_document`
--
CREATE TABLE `customer_document` (
`customer_document_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`document` varchar(500) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(1) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `customer_events`
--
CREATE TABLE `customer_events` (
`type_of_event` varchar(16) DEFAULT NULL,
`type_id` int(11) DEFAULT NULL,
`event_name` text DEFAULT NULL,
`event_desc` text DEFAULT NULL,
`start_date` datetime DEFAULT NULL,
`end_date` datetime DEFAULT NULL,
`event_color` varchar(250) DEFAULT NULL,
`visibility` varchar(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `custom_field_aspect_reason`
--
CREATE TABLE `custom_field_aspect_reason` (
`custom_field_aspect_reason_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`quality_aspects_id` int(11) DEFAULT NULL,
`aspect_reasons_id` int(11) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`rules` text DEFAULT NULL,
`options` text DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(25) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `custom_field_type`
--
CREATE TABLE `custom_field_type` (
`custom_field_type_id` int(11) NOT NULL,
`type_name` varchar(255) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `dc_wtime_sl`
--
CREATE TABLE `dc_wtime_sl` (
`service_location_id` int(11) DEFAULT NULL,
`total_quantity` decimal(65,0) DEFAULT NULL,
`total_weight` decimal(64,2) DEFAULT NULL,
`total_waiting_seconds` decimal(42,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `department`
--
CREATE TABLE `department` (
`department_id` int(21) NOT NULL,
`department_name` varchar(255) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_on` datetime NOT NULL,
`created_by` varchar(255) NOT NULL,
`updated_on` datetime NOT NULL,
`updated_by` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `device_assignment`
--
CREATE TABLE `device_assignment` (
`device_assignment_id` int(11) NOT NULL,
`device_name` varchar(355) DEFAULT NULL,
`mac_address` varchar(355) DEFAULT NULL,
`description` varchar(355) DEFAULT NULL,
`device_maker_id` int(50) DEFAULT NULL,
`created_on` datetime NOT NULL,
`created_by` varchar(255) NOT NULL,
`updated_on` datetime NOT NULL,
`updated_by` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `device_maker`
--
CREATE TABLE `device_maker` (
`device_maker_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `district`
--
CREATE TABLE `district` (
`district_id` int(11) NOT NULL,
`state_id` int(11) DEFAULT NULL,
`district_name` varchar(1500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `district`
--
INSERT INTO `district` (`district_id`, `state_id`, `district_name`) VALUES
(1, 1, 'Kathuna'),
(2, 1, 'Jammu'),
(3, 1, 'Samba'),
(4, 1, 'Udhampur'),
(5, 1, 'Reasi'),
(6, 1, 'Rajouri'),
(7, 1, 'Poonch'),
(8, 1, 'Doda'),
(9, 1, 'Ramban'),
(10, 1, 'Kishtwar'),
(11, 1, 'Anantnag'),
(12, 1, 'Kulgam'),
(13, 1, 'Pulwama'),
(14, 1, 'Shopian'),
(15, 1, 'Badgam'),
(16, 1, 'Srinagar'),
(17, 1, 'Ganderbal'),
(18, 1, 'Bandipora'),
(19, 1, 'Baramulla'),
(20, 1, 'Kupwara'),
(21, 1, 'Kargil'),
(22, 1, 'Leh'),
(23, 2, 'Chamba'),
(24, 2, 'Kangra'),
(25, 2, 'Lahaul and spiti'),
(26, 2, 'Kullu'),
(27, 2, 'Mandi'),
(28, 2, 'Hamirpur'),
(29, 2, 'Una'),
(30, 2, 'Bilaspur'),
(31, 2, 'Solan'),
(32, 2, 'Sirmaur'),
(33, 2, 'Shimla'),
(34, 2, 'Kinnaur'),
(35, 3, 'Amritsar'),
(36, 3, 'Bathinda'),
(37, 3, 'Faridkot'),
(38, 3, 'Fatehgarh Sahib'),
(39, 3, 'Ferozepur'),
(40, 3, 'Gurdaspur'),
(41, 3, 'Hoshiarpur'),
(42, 3, 'Jalandhar'),
(43, 3, 'Kapurthala'),
(44, 3, 'Ludhiana'),
(45, 3, 'Mansa'),
(46, 3, 'Moga'),
(47, 3, 'Muktsar'),
(48, 3, 'Nawanshehar'),
(49, 3, 'Patiala\r\n'),
(50, 3, 'Rupnagar'),
(51, 3, 'Sangrur'),
(52, 3, 'Barnala'),
(53, 3, 'Mohali'),
(54, 3, 'Tarn Taran'),
(55, 3, 'Pathankot'),
(56, 3, 'Fazilka'),
(57, 5, 'Almora'),
(58, 5, 'Bageshwar'),
(59, 5, 'Chamoli'),
(60, 5, 'Champawat'),
(61, 5, 'Dehradun'),
(62, 5, 'Haridwar'),
(63, 5, 'Nainital'),
(64, 5, 'Pauri Garhwal'),
(65, 5, 'Pithoragarh'),
(66, 5, 'Rudraprayag'),
(67, 5, 'New Tehri'),
(68, 5, 'Udhm Singh Nagar'),
(69, 5, 'Uttarkashi'),
(70, 6, 'Ambala'),
(71, 6, 'Bhiwani'),
(72, 6, 'Faridabad'),
(73, 6, 'Fatehabad'),
(74, 6, 'Gurgaon'),
(75, 6, 'Hissar'),
(76, 6, 'Jhajjar'),
(77, 6, 'Jind'),
(78, 6, 'Karnal'),
(79, 6, '\nKaithal'),
(80, 6, 'Kurukshetra'),
(81, 6, 'Narnaul'),
(82, 6, 'Nuh'),
(83, 6, 'Palwal'),
(84, 6, 'Panchkula'),
(85, 6, 'Panipat'),
(86, 6, 'Rewari'),
(87, 6, 'Rohtak'),
(88, 6, 'Sirsa'),
(89, 6, 'Sonipat'),
(90, 6, 'Yamuna Nagar'),
(91, 6, 'Charkhi Dhari'),
(92, 7, 'New Delhi'),
(93, 7, 'North Delhi'),
(94, 7, 'NorthWest Delhi'),
(95, 7, 'West Delhi'),
(96, 7, 'South West Delhi'),
(97, 7, 'South Delhi'),
(98, 7, 'South East Delhi'),
(99, 7, 'Central Delhi'),
(100, 7, 'North East Delhi'),
(101, 7, 'Shahdara'),
(102, 7, 'East Delhi'),
(103, 8, 'Ajmer'),
(104, 8, 'Alwar'),
(105, 8, 'Banswara'),
(106, 8, 'Baran'),
(107, 8, 'Barmer'),
(108, 8, 'Bharatpur'),
(109, 8, 'Bhilwara'),
(110, 8, 'Bikaner'),
(111, 8, 'Bundi'),
(112, 8, 'Chittorgarh'),
(113, 8, '\nChuru'),
(114, 8, 'Dausa'),
(115, 8, 'Dholpur'),
(116, 8, 'Dungarpur'),
(117, 8, 'Hanumangarh'),
(118, 8, 'Jaipur'),
(119, 8, 'Jaisalmer'),
(120, 8, 'Jalore'),
(121, 8, 'Jhalawar'),
(122, 8, 'Jhunjhunu'),
(123, 8, 'Jodhpur'),
(124, 8, 'Karauli'),
(125, 8, 'Kota'),
(126, 8, 'Nagaur'),
(127, 8, 'Pali'),
(128, 8, 'Pratapgarh'),
(129, 8, 'Rajsamand'),
(130, 8, 'Sawai Madhopur'),
(131, 8, 'Sikar'),
(132, 8, 'Sirohi'),
(133, 8, ' Sri Ganganagar'),
(134, 8, 'Tonk'),
(135, 8, 'Udaipur'),
(136, 9, 'Agra'),
(137, 9, 'Aligarh'),
(138, 9, 'Allahabad\r\n'),
(139, 9, 'Ambedkar Nagar'),
(140, 9, 'Auraiya'),
(141, 9, 'Azamgarh'),
(142, 9, 'Baghpat'),
(143, 9, 'Bahraich'),
(144, 9, 'Ballia'),
(145, 9, 'Balrampur'),
(146, 9, 'Banda'),
(147, 9, 'Barabanki'),
(148, 9, 'Bareilly'),
(149, 9, 'Basti'),
(150, 9, 'Bijnor'),
(151, 9, 'Badaun'),
(152, 9, 'Bulandshahr'),
(153, 9, 'Chandauli'),
(154, 9, 'Chitrakoot'),
(155, 9, 'Deoria'),
(156, 9, 'Etah'),
(157, 9, 'Etawah'),
(158, 9, 'Faizabad'),
(159, 9, 'Farrukhabed'),
(160, 9, 'Fatehpur'),
(161, 9, 'Firozabad'),
(162, 9, 'Noida'),
(163, 9, 'Ghaziabad'),
(164, 9, 'Ghazipur'),
(165, 9, 'Gonda'),
(166, 9, 'Gorakhpur'),
(167, 9, 'Hamirpur'),
(168, 9, 'Hardoi'),
(169, 9, 'Hathras'),
(170, 9, 'Orai'),
(171, 9, 'jaunpur'),
(172, 9, 'Jhansi'),
(173, 9, 'jyotiba phule nagar'),
(174, 9, 'Kannauj'),
(175, 9, 'Akbarpur'),
(176, 9, 'Kanpur'),
(177, 9, 'Kaushambi'),
(178, 9, 'Lakhimpur'),
(179, 9, 'Koshi Nagar'),
(180, 9, 'Lalitpur'),
(181, 9, 'Lucknow'),
(182, 9, 'Mahoba\r\n'),
(183, 9, 'Maharajganj'),
(184, 9, 'Mainpuri'),
(185, 9, 'Mathura\r\n'),
(186, 9, 'Mau'),
(187, 9, 'Meerut'),
(188, 9, 'Mirzapur'),
(189, 9, 'Moradabad'),
(190, 9, 'Muzaffarnagar'),
(191, 9, 'Pilibhit'),
(192, 9, 'Pratapgarh'),
(193, 9, 'RaeBareli'),
(194, 9, 'Rampur'),
(195, 9, 'Saharanpur'),
(196, 9, 'Sant Kabir Nagar'),
(197, 9, 'Sant Ravidas Nagar'),
(198, 9, 'Shahjahanpur'),
(199, 9, 'Shravasti'),
(200, 9, 'Siddharthnagar '),
(201, 9, 'Sitapur'),
(202, 9, 'Sonbhadra'),
(203, 9, 'Sultanpur'),
(204, 9, 'Unnao'),
(205, 9, 'Varanasi'),
(206, 9, 'Manyavar Knshiram Nagar (Kasganj)\r\n'),
(207, 9, 'Shamli'),
(208, 9, 'Hapur'),
(209, 9, 'Chandausi '),
(210, 9, 'Gauriganj'),
(211, 10, 'Araria'),
(212, 10, 'Aurangabad'),
(213, 10, 'Banka'),
(214, 10, 'Begusarai'),
(215, 10, 'Bhagalpur'),
(216, 10, 'Bhojpur'),
(217, 10, 'Buxar'),
(218, 10, 'Darbhanga'),
(219, 10, 'East Champaran'),
(220, 10, 'Gaya'),
(221, 10, 'Gopalganj'),
(222, 10, 'Jamui'),
(223, 10, 'Jehanabad'),
(224, 10, 'Kaimur'),
(225, 10, 'Katihar'),
(226, 10, 'Khagaria'),
(227, 10, 'Kishanganj'),
(228, 10, 'Lakhisarai'),
(229, 10, 'Madhepura'),
(230, 10, 'Madhubani'),
(231, 10, 'Munger'),
(232, 10, 'Muzzaffarpur '),
(233, 10, 'Nalanda'),
(234, 10, 'Nawada'),
(235, 10, 'Patna'),
(236, 10, 'Purnia'),
(237, 10, 'Rohtaas'),
(238, 10, 'Saharsa'),
(239, 10, 'Samastipur'),
(240, 10, 'Sheikhpura'),
(241, 10, 'Sheoghar'),
(242, 10, 'Sitamarhi'),
(243, 10, 'Supaul'),
(244, 10, 'Siwan'),
(245, 10, 'Vaishali\r\n'),
(246, 10, 'West Champaran'),
(247, 11, 'East Sikkim'),
(248, 11, 'North Sikkim'),
(249, 11, 'South Sikkim'),
(250, 11, 'West Sikkim'),
(251, 12, 'Hawai'),
(252, 12, 'Changlang'),
(253, 12, 'Seppa '),
(254, 12, 'East Siang'),
(255, 12, 'Tezu'),
(256, 12, 'Ziro'),
(257, 12, 'Yupia'),
(258, 12, 'Tawang'),
(259, 12, 'Khonsa'),
(260, 12, 'Roing'),
(261, 12, 'Yingkiong'),
(262, 12, 'Daporijo'),
(263, 12, 'Bomdila'),
(264, 12, 'Along'),
(265, 12, 'Anini'),
(266, 12, 'Koloriang'),
(267, 13, 'Dimapur'),
(268, 13, 'Kohima'),
(269, 13, 'Mon'),
(270, 13, 'Tuensang'),
(271, 13, 'Mokokchung'),
(272, 13, 'Wokha'),
(273, 13, 'phek'),
(274, 13, 'Zenheboto'),
(275, 13, 'Peren'),
(276, 13, 'Kiphire'),
(277, 13, 'Longleng'),
(278, 14, 'Bishenpur'),
(279, 14, 'Thoubal'),
(280, 14, 'Imphal East'),
(281, 14, 'Imphal West'),
(282, 14, 'Senapati'),
(283, 14, 'Ukhrul'),
(284, 14, 'Chandel'),
(285, 14, 'Churachabdpur'),
(286, 14, 'Tamenglong'),
(287, 14, 'Jiribam'),
(288, 14, 'Kamjong'),
(289, 14, 'Noney'),
(290, 14, 'pherzawl'),
(291, 15, 'Aizwal'),
(292, 15, 'Champhai'),
(293, 15, 'Kolasib'),
(294, 15, 'Lawngtlai'),
(295, 15, 'Lunglei'),
(296, 15, 'Mamit'),
(297, 15, 'Saiha'),
(298, 15, 'Serchhip'),
(299, 16, 'Dhalai'),
(300, 16, 'Gomati'),
(301, 16, 'Khowai'),
(302, 16, 'NorthTripura'),
(303, 16, 'Unakoti'),
(304, 16, 'West Tripura'),
(305, 17, 'East Garo Hils'),
(306, 17, 'East Jaintia Hils'),
(307, 17, 'East Khasi Hils'),
(308, 17, 'North Garo Hils'),
(309, 17, 'Ri Bhoi'),
(310, 17, 'South Gero Hils'),
(311, 17, 'South West Garo Hils'),
(312, 17, 'South West Khasi Hils'),
(313, 17, 'West Jaintia Hils'),
(314, 17, 'West Khasi Hils'),
(315, 18, 'Baksa'),
(316, 18, 'Barpeta'),
(317, 18, 'Biswanath'),
(318, 18, 'Bongaigaon'),
(319, 18, 'Cachar'),
(320, 18, 'Charaideo'),
(321, 18, 'Chirang'),
(322, 18, 'Darrang'),
(323, 18, 'Dhemaji'),
(324, 18, 'Dhubri'),
(325, 18, 'Dibrugarh'),
(326, 18, 'Goalpara'),
(327, 18, 'Golaghat'),
(328, 18, 'Hailakandi'),
(329, 18, 'Hojai'),
(330, 18, 'Jorhat'),
(331, 18, 'Kamrup Metropolitan'),
(332, 18, 'Kamrup Rural'),
(333, 18, 'Karbi Anglong'),
(334, 18, 'Karimganj'),
(335, 18, 'Kokrajhar'),
(336, 18, 'Lakhimpur'),
(337, 18, 'Majuli'),
(338, 18, 'Morigaon'),
(339, 18, 'Nagaon'),
(340, 18, 'Nalbari'),
(341, 18, 'Dima Hasao'),
(342, 18, 'Sivasagar'),
(343, 18, 'Sonitpur'),
(344, 18, 'South Salmara-Mankachar'),
(345, 18, 'Tinsukia'),
(346, 18, 'Udalguri'),
(347, 18, 'West Karbi Anglong'),
(348, 19, 'Alipurduar'),
(349, 19, 'Bankura'),
(350, 19, 'Birbhum'),
(351, 19, 'Cooch Behar'),
(352, 19, 'Dakshin Dinajpur'),
(353, 19, 'Darjeeling'),
(354, 19, 'Hooghly'),
(355, 19, 'Howrah'),
(356, 19, 'Jalpaiguri'),
(357, 19, 'Jhargram'),
(358, 19, 'Kalimpong'),
(359, 19, 'Kolkata'),
(360, 19, 'Malda'),
(361, 19, 'Murshidabad'),
(362, 19, 'Nadia'),
(363, 19, 'North 24 Parganas'),
(364, 19, 'Paschim Medinipur'),
(365, 19, 'Paschim(west)Burdwan'),
(366, 19, 'Purba Burdwan'),
(367, 19, 'Purba Medinipur'),
(368, 19, 'Purulia'),
(369, 19, 'South 24 Paraganas'),
(370, 19, 'Uttar Dinaipur'),
(371, 20, 'Bokaro'),
(372, 20, 'Chatra'),
(373, 20, 'Deoghar'),
(374, 20, 'Dhanbad'),
(375, 20, 'Dumka'),
(376, 20, 'East Singhbhum'),
(377, 20, 'Garhwa'),
(378, 20, 'Giridih'),
(379, 20, 'Godda'),
(380, 20, 'Gumla'),
(381, 20, 'Hazaribagh'),
(382, 20, 'Jamtara'),
(383, 20, 'Khunti'),
(384, 20, 'Koderma'),
(385, 20, 'Latehar'),
(386, 20, 'Lohardaga'),
(387, 20, 'Pakur'),
(388, 20, 'Palamu'),
(389, 20, 'Ramgarh'),
(390, 20, 'Ranchi'),
(391, 20, 'Sahibganj'),
(392, 20, 'Simdega'),
(393, 20, 'West Singhbhum'),
(394, 20, 'Seraikella Kharsawan'),
(395, 21, 'Anugul'),
(396, 21, 'Boudh'),
(397, 21, 'Balangir'),
(398, 21, 'Bargarh'),
(399, 21, 'Balasore'),
(400, 21, 'Bhadrak'),
(401, 21, 'Cuttack'),
(402, 21, 'Debagarh'),
(403, 21, 'Dhenkanal'),
(404, 21, 'Ganjam'),
(405, 21, 'Gajapati'),
(406, 21, 'Jarsuguda'),
(407, 21, 'Jaipur'),
(408, 21, 'Jagatsinghapur'),
(409, 21, 'Khordha'),
(410, 21, 'Kendujhar'),
(411, 21, 'Kalahandi'),
(412, 21, 'Kanshamal'),
(413, 21, 'Koraput'),
(414, 21, 'Kendrapara'),
(415, 21, 'Malkangiri'),
(416, 21, 'Mayurbhanj'),
(417, 21, 'Nabarangpur'),
(418, 21, 'Nuapada'),
(419, 21, 'Nayagarh'),
(420, 21, 'Puri'),
(421, 21, 'Rayagada'),
(422, 21, 'Sambalpur'),
(423, 21, 'Sundergarh'),
(424, 22, 'Balod'),
(425, 22, 'Baloda Bazer'),
(426, 22, 'Balrampur'),
(427, 22, 'Bastar'),
(428, 22, 'Bemetara'),
(429, 22, 'Bijapur'),
(430, 22, 'Dantewada '),
(431, 22, 'Dhamtari'),
(432, 22, 'Durg'),
(433, 22, 'Gariyaband'),
(434, 22, 'Janjgir-Champa'),
(435, 22, 'Jashpur'),
(436, 22, 'Kabirdham'),
(437, 22, 'Kanker'),
(438, 22, 'Kondagaon'),
(439, 22, 'Korba'),
(440, 22, 'Korea'),
(441, 22, 'Mahasamund'),
(442, 22, 'Mungeli'),
(443, 22, 'Nayayanpur'),
(444, 22, 'Raigarh'),
(445, 22, 'Raipur'),
(446, 22, 'Raijandgaon'),
(447, 22, 'Sukma'),
(448, 22, 'Surajpur'),
(449, 22, 'Surguja'),
(450, 23, 'Indore'),
(451, 23, 'Jabalpur'),
(452, 23, 'Sagar'),
(453, 23, 'Bhopal'),
(454, 23, 'Rewa'),
(455, 23, 'Satna'),
(456, 23, 'Dhar'),
(457, 23, 'Chhindwara'),
(458, 23, 'Ujjain'),
(459, 23, 'Morena'),
(460, 23, 'West Nimar'),
(461, 23, 'Chhattarpur'),
(462, 23, 'Shivpuri'),
(463, 23, 'Bhind'),
(464, 23, 'Dewas'),
(465, 23, 'Rajarh'),
(466, 23, 'Shajapur'),
(467, 23, 'Vidisha'),
(468, 23, 'Ratlam'),
(469, 23, 'Tikamgarh'),
(470, 23, 'Barwani'),
(471, 23, 'Seoni'),
(472, 23, 'Mandsaur'),
(473, 23, 'Raisen'),
(474, 23, 'Sehore'),
(475, 23, 'East Nimar'),
(476, 23, 'Katni'),
(477, 23, 'Damoh'),
(478, 23, 'Guna'),
(479, 23, 'Hoshangabad'),
(480, 23, 'Singrauil'),
(481, 23, 'Sidhi'),
(482, 23, 'Narsimhapur'),
(483, 23, 'Shahdol'),
(484, 23, 'Mandla'),
(485, 23, 'Jhabua'),
(486, 23, 'Panna'),
(487, 23, 'Ashoknagar'),
(488, 23, 'Neemuch'),
(489, 23, 'Datia'),
(490, 23, 'Burhanpur'),
(491, 23, 'Anuppur'),
(492, 23, 'Aliraipur'),
(493, 23, 'Dindori'),
(494, 23, 'Sheopur'),
(495, 23, 'Umaria'),
(496, 23, 'Harda'),
(497, 24, 'Ahmedabad'),
(498, 24, 'Amreli'),
(499, 24, 'Aravalli'),
(500, 24, 'Banaskantha'),
(501, 24, 'Bharuch'),
(502, 24, 'Bhavnagar'),
(503, 24, 'Boted'),
(504, 24, 'Chhota Udepur'),
(505, 24, 'Dahod'),
(506, 24, 'Dangs'),
(507, 24, 'Devbhoomi Dwarka'),
(508, 24, 'Gandhinagar'),
(509, 24, 'Gir Somnath'),
(510, 24, 'Jamnagar'),
(511, 24, 'Junagadh'),
(512, 24, 'Kachchh'),
(513, 24, 'Kheda'),
(514, 24, 'Mahisagar'),
(515, 24, 'Mehsana'),
(516, 24, 'Morbi'),
(517, 24, 'Narmada'),
(518, 24, 'Navsari'),
(519, 24, 'Panchmahal'),
(520, 24, 'Patan'),
(521, 24, 'Porbandar'),
(522, 24, 'Rajkat'),
(523, 24, 'Sabarkantha'),
(524, 24, 'Surat'),
(525, 24, 'Surendrangar'),
(526, 24, 'Tapi'),
(527, 24, 'Vadadara'),
(528, 24, 'Valsad'),
(529, 25, 'Daman'),
(530, 25, 'Diu'),
(531, 26, 'Dadra and Nagar Haveli'),
(532, 27, 'Thane'),
(533, 27, 'Pune'),
(534, 27, 'Mumbai Suburban'),
(535, 27, 'Nashik'),
(536, 27, 'Nagpur'),
(537, 27, 'Ahmednagar'),
(538, 27, 'Solpur'),
(539, 27, 'Jalgaon'),
(540, 27, 'Kolhapur'),
(541, 27, 'Aurangabad'),
(542, 27, 'Nanded'),
(543, 27, 'Mumbai City'),
(544, 27, 'Satara'),
(545, 27, 'Amraoti'),
(546, 27, 'Sabngil'),
(547, 27, 'Yavatmal'),
(548, 27, 'Raigarh'),
(549, 27, 'Buldana'),
(550, 27, 'Bid'),
(551, 27, 'Latur'),
(552, 27, 'Chandrapur'),
(553, 27, 'Dhule'),
(554, 27, 'Jalna'),
(555, 27, 'Parbhani'),
(556, 27, 'Akola'),
(557, 27, 'Osmanabad'),
(558, 27, 'Nandurbad'),
(559, 27, 'Ratnagiri'),
(560, 27, 'Gondiya'),
(561, 27, 'Wardha'),
(562, 27, 'Bhandara'),
(563, 27, 'Washim'),
(564, 27, 'Hingoli'),
(565, 27, 'Gadchiroli'),
(566, 27, 'Sindhudurg'),
(567, 28, 'Ragareddy'),
(568, 28, 'East Govdari'),
(569, 28, 'Guntur'),
(570, 28, 'Krishna'),
(571, 28, 'Visakhapatnam'),
(572, 28, 'Chittor'),
(573, 28, 'Anantapur'),
(574, 28, 'Kurnool'),
(575, 28, 'Mahbubnager'),
(576, 28, 'Hyderabad'),
(577, 28, 'West Godavari'),
(578, 28, 'Karimagar'),
(579, 28, 'Warangal'),
(580, 28, 'Nalgonda'),
(581, 28, 'Prakasam'),
(582, 28, 'Medak'),
(583, 28, 'Sri Potti Sriramulu Nellore'),
(584, 28, 'YSR'),
(585, 28, 'Khammam'),
(586, 28, 'Adilbad'),
(587, 28, 'Srikakulam'),
(588, 28, 'Nizamabad'),
(589, 28, 'Vizianangaram'),
(590, 29, 'Bangalore'),
(591, 29, 'Belgaum'),
(592, 29, 'Mysore'),
(593, 29, 'Tumkur'),
(594, 29, 'Gulbarga'),
(595, 29, 'Bellary'),
(596, 29, 'Beijapur'),
(597, 29, 'Dakshina Kannada'),
(598, 29, 'Davanagere'),
(599, 29, 'Raichur'),
(600, 29, 'Bagalkot'),
(601, 29, 'Dharwad'),
(602, 29, 'Mandya'),
(603, 29, 'Hassan'),
(604, 29, 'Shimoga'),
(605, 29, 'Bidar'),
(606, 29, 'Chitradurga'),
(607, 29, 'Haveri'),
(608, 29, 'Kolar'),
(609, 29, 'Uttara Kannada'),
(610, 29, 'Koppal'),
(611, 29, 'Chikkaballapura'),
(612, 29, 'Udupi'),
(613, 29, 'Yadgir'),
(614, 29, 'Chilkmagalur'),
(615, 29, 'Ramanangara'),
(616, 29, 'Gadag'),
(617, 29, 'Chamarajanagar'),
(618, 29, 'Bangalore Rural'),
(619, 29, 'kodagu'),
(620, 30, 'North Goa'),
(621, 30, 'South Goa'),
(622, 31, 'Lakashadweep'),
(623, 32, 'Malappuram'),
(624, 32, 'Thiruvananthapuram'),
(625, 32, 'Ernakulam'),
(626, 32, 'Thrissur'),
(627, 32, 'Kozhikode'),
(628, 32, 'Palakkad'),
(629, 32, 'Kollam'),
(630, 32, 'Kannur'),
(631, 32, 'Alappuzha'),
(632, 32, 'Kottayam'),
(633, 32, 'Kasaragod'),
(634, 32, 'Pathanmthitta'),
(635, 32, 'Idulkki'),
(636, 32, 'Wayanad'),
(637, 33, 'Ariyalur'),
(638, 33, 'Chennai'),
(639, 33, 'Coimbatore'),
(640, 33, 'Cuddalore'),
(641, 33, 'Dharmapuri'),
(642, 33, 'Dindigul'),
(643, 33, 'Erode'),
(644, 33, 'Kancheepuram'),
(645, 33, 'Karur'),
(646, 33, 'Krishnagiri'),
(647, 33, 'Madurai'),
(648, 33, 'Nagapattinam'),
(649, 33, 'Kanyakumari'),
(650, 33, 'Namakkal'),
(651, 33, 'Perambalur'),
(652, 33, 'Puthukkottai'),
(653, 33, 'Ramananthapuram'),
(654, 33, 'Salem'),
(655, 33, 'Sivagangai'),
(656, 33, 'Thanjavur'),
(657, 33, 'Theni'),
(658, 33, 'Thiruvallur'),
(659, 33, 'Thiruvarur'),
(660, 33, 'Tuticorin'),
(661, 33, 'Thiruchirappalli'),
(662, 33, 'Thirunelveli'),
(663, 33, 'Thriuppur'),
(664, 33, 'Tiruvanaamalai'),
(665, 33, 'Udagamandalam'),
(666, 33, 'Vellore'),
(667, 33, 'Vilupuram'),
(668, 33, 'Viruthunagar'),
(669, 34, 'Karaikal'),
(670, 34, 'Mahe'),
(671, 34, 'Puthucherry'),
(672, 34, 'Yanam'),
(673, 35, 'Niconbar'),
(674, 35, 'North And Middle Andaman'),
(675, 35, 'South Andaman'),
(676, 36, 'Adilabad'),
(677, 36, 'Asifabad'),
(678, 36, 'Kothagudem'),
(679, 36, 'Bhupalpalle'),
(680, 36, 'Gadwal'),
(681, 36, 'Hyderabad'),
(682, 36, 'Jagtial'),
(683, 36, 'Jangaon'),
(684, 36, 'Kamareddy'),
(685, 36, 'Karimnagar'),
(686, 36, 'Khammam'),
(687, 36, 'Mahabubabad'),
(688, 36, 'Mahbubnagar'),
(689, 36, 'Mancherial'),
(690, 36, 'Medak'),
(691, 36, 'Malkajgiri'),
(692, 36, 'Nalgonda'),
(693, 36, 'Nagarkurnool'),
(694, 36, 'Nirmal'),
(695, 36, 'Nizamabad'),
(696, 36, 'Shamshabad'),
(697, 36, 'Peddapalle'),
(698, 36, 'Sircilla'),
(699, 36, 'Sangareddy'),
(700, 36, 'Siddipet'),
(701, 36, 'Suryapet'),
(702, 36, 'Vikarabad'),
(703, 36, 'Wanaparthy'),
(704, 36, 'Warangal'),
(705, 36, 'Warangal'),
(706, 36, 'Bhongiri'),
(707, 6, 'Mohindergarh'),
(708, 4, 'Chandigarh'),
(709, 9, 'Gautam budha Nagar'),
(710, 9, 'jalaun'),
(711, 24, 'Anand'),
(712, 23, 'Balaghat'),
(713, 21, 'Baleshwar'),
(714, 19, 'Bardhaman'),
(715, 21, 'Baudh'),
(716, 27, 'Beed'),
(717, 23, 'Betul'),
(718, 3, 'Bhatinda');
-- --------------------------------------------------------
--
-- Table structure for table `domains`
--
CREATE TABLE `domains` (
`domain` varchar(255) NOT NULL,
`tenant_id` varchar(36) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `domains`
--
INSERT INTO `domains` (`domain`, `tenant_id`, `customer_id`) VALUES
('queenmira.tgsstest.com', 'tgsstest_queenmira', 1),
('schoolportalapi.technogenesis.co.in', 'school', 1),
('vidyaavikas.tgsstest.com', 'tgsstest_vidyaavikas', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `invoice`
--
CREATE TABLE `invoice` (
`invoice_id` int(11) NOT NULL,
`branch_id` int(11) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`package_history_id` int(11) DEFAULT NULL,
`invoice_no` varchar(100) DEFAULT NULL,
`invoice_date` date DEFAULT NULL,
`paid_amount` decimal(20,2) DEFAULT NULL,
`previous_balance` decimal(20,2) DEFAULT NULL,
`current_package_paid` decimal(20,2) DEFAULT NULL,
`already_paid_amount` decimal(20,2) DEFAULT NULL,
`payment_mode` int(10) DEFAULT NULL COMMENT '1-cash,2-bank',
`reference_id` varchar(255) DEFAULT NULL,
`payment_status` int(11) DEFAULT NULL COMMENT '0-failure, 1-success',
`notes` text DEFAULT NULL,
`payment_reference_id` varchar(355) DEFAULT NULL,
`payment_gateway` varchar(100) DEFAULT NULL,
`payment_gateway_paid_amount` decimal(20,2) DEFAULT NULL,
`is_refund` int(11) DEFAULT 0 COMMENT '0-no, 1-yes',
`created_by` varchar(255) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`refund_amount` decimal(20,2) DEFAULT NULL,
`refund_date` date DEFAULT NULL,
`refund_reason` varchar(500) DEFAULT NULL,
`refund_created_on` datetime DEFAULT NULL,
`refund_created_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `invoice`
--
INSERT INTO `invoice` (`invoice_id`, `branch_id`, `customer_id`, `package_history_id`, `invoice_no`, `invoice_date`, `paid_amount`, `previous_balance`, `current_package_paid`, `already_paid_amount`, `payment_mode`, `reference_id`, `payment_status`, `notes`, `payment_reference_id`, `payment_gateway`, `payment_gateway_paid_amount`, `is_refund`, `created_by`, `created_on`, `updated_by`, `updated_on`, `refund_amount`, `refund_date`, `refund_reason`, `refund_created_on`, `refund_created_by`) VALUES
(1, 1, 1, 1, 'INV2021001', '2020-08-25', 1980.00, 0.00, 0.00, 0.00, NULL, 'pay_FUuA0BgxzPBpJ4', NULL, 'undefined', NULL, NULL, NULL, 0, '1', '2020-08-25 12:28:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 24, 24, 39, 'INV2021002', '2020-08-25', 500000.00, 0.00, 0.00, 0.00, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1', '2020-08-25 18:46:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 1, 1, 40, 'INV2021003', '2020-10-16', 336.30, 70000.00, 0.00, 1980.00, NULL, 'pay_FpZglk4hXUbU9g', 1, NULL, NULL, 'Razorpay', 336.30, 0, '1', '2020-10-16 18:05:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 25, 25, 41, 'INV2021004', '2020-10-20', 90000.00, 0.00, 0.00, 0.00, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1', '2020-10-20 16:31:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 1, 1, 40, 'INV2021005', '2020-10-20', 60000.00, 69663.70, 69663.70, 2316.30, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1', '2020-10-20 16:32:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 1, 1, 40, 'INV2021006', '2020-10-20', 10000.00, 9663.70, 79327.40, 62316.30, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1', '2020-10-20 16:32:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 26, 26, 42, 'INV2021007', '2020-12-17', 31600.00, 0.00, 0.00, 0.00, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1', '2020-12-17 10:47:16', NULL, NULL, 31600.00, '1970-01-01', 'wrong', '2020-12-17 00:00:00', '1'),
(8, 26, 26, 42, 'INV2021008', '2020-12-17', 31600.00, 0.00, 0.00, 0.00, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1', '2020-12-17 14:59:04', NULL, NULL, 31600.00, '1970-01-01', 'wrong data', '2020-12-17 00:00:00', '1');
-- --------------------------------------------------------
--
-- Table structure for table `menu_group`
--
CREATE TABLE `menu_group` (
`menu_group_id` int(11) NOT NULL,
`menu_name` varchar(500) DEFAULT NULL,
`status` int(11) DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `menu_group`
--
INSERT INTO `menu_group` (`menu_group_id`, `menu_name`, `status`) VALUES
(1, 'users', 1),
(2, 'customer', 1),
(3, 'roles', 1),
(12, 'branch', 1),
(5, 'transaction', 1),
(6, 'setupfee', 1),
(7, 'package', 1),
(8, 'packageplan', 1),
(9, 'tax', 1),
(10, 'ticket', 1),
(11, 'company_info', 1);
-- --------------------------------------------------------
--
-- Table structure for table `notification`
--
CREATE TABLE `notification` (
`notification_id` int(11) NOT NULL,
`title` varchar(500) DEFAULT NULL,
`body` text DEFAULT NULL,
`user_type` int(11) DEFAULT NULL COMMENT '5-product portal',
`sender` int(11) DEFAULT NULL,
`receiver` int(11) DEFAULT NULL,
`module_name` text DEFAULT NULL,
`page` text DEFAULT NULL,
`portal` varchar(255) DEFAULT NULL,
`data` text DEFAULT NULL,
`msg_read` int(11) DEFAULT 0,
`created_on` datetime NOT NULL,
`status` int(11) DEFAULT 1,
`db_type` int(11) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `notification`
--
INSERT INTO `notification` (`notification_id`, `title`, `body`, `user_type`, `sender`, `receiver`, `module_name`, `page`, `portal`, `data`, `msg_read`, `created_on`, `status`, `db_type`) VALUES
(5, 'Ticket status update', 'Your TIC021 has been moved to new status successfully', 1, 7, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"21\"}', NULL, '2020-08-24 19:40:32', 1, 1),
(4, 'Ticket created', 'Ticket TIC021 created by Cute Hearts Play School', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":21}', 1, '2020-08-24 19:30:11', 1, 1),
(6, 'Ticket created', 'Ticket TIC022 created by Cute Hearts Play School', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":22}', 1, '2020-08-25 13:29:53', 1, 1),
(7, 'Ticket status update', 'Your TIC022 has been moved to open status successfully', 1, 7, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"22\"}', 0, '2020-08-25 13:30:35', 1, 1),
(8, 'Ticket created', 'Ticket TIC023 created by Cute Hearts Play School', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":23}', 1, '2020-08-26 20:07:51', 1, 1),
(9, 'Ticket status update', 'Your TIC023 has been moved to open status successfully', 1, 7, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"23\"}', 0, '2020-08-26 20:09:13', 1, 1),
(10, 'Ticket status update', 'Your TIC023 has been moved to open status successfully', 1, 7, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"23\"}', 0, '2020-08-26 20:10:27', 1, 1),
(11, 'Ticket status update', 'Your TIC023 has been moved to resolved status successfully', 1, 7, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"23\"}', 0, '2020-08-31 13:12:39', 1, 1),
(12, 'Ticket created', 'Ticket TIC001 created by Cute Hearts Play School', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":1}', 1, '2020-09-11 12:50:34', 1, 1),
(13, 'Ticket created', 'Ticket TIC002 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":2}', 1, '2020-10-16 18:13:13', 1, 1),
(14, 'Ticket created', 'Ticket TIC003 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":3}', 1, '2020-10-16 18:14:51', 1, 1),
(15, 'Ticket created', 'Ticket TIC004 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":4}', 1, '2020-10-20 18:03:33', 1, 1),
(16, 'Ticket status update', 'Your TIC004 has been moved to new status successfully', 1, 2, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"4\"}', 0, '2020-10-20 18:10:51', 1, 1),
(17, 'Ticket status update', 'Your TIC004 has been moved to open status successfully', 1, 1, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"4\"}', 0, '2020-10-20 18:11:45', 1, 1),
(18, 'Ticket status update', 'Your TIC004 has been moved to closed status successfully', 1, 1, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"4\"}', 0, '2020-10-20 18:13:57', 1, 1),
(19, 'Ticket created', 'Ticket TIC005 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":5}', 1, '2020-10-20 18:19:48', 1, 1),
(20, 'Ticket status update', 'Your TIC005 has been moved to closed status successfully', 1, 1, 1, 'ticket', 'ticket_view', 'school', '{\"ticket_id\":\"5\"}', 0, '2020-10-20 18:21:11', 1, 1),
(21, 'Ticket created', 'Ticket TIC001 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":1}', 0, '2020-10-28 15:32:33', 1, 1),
(22, 'Ticket created', 'Ticket TIC002 created by Cute hearts little school', 5, 1, 0, 'ticket', 'ticket_view', 'product', '{\"ticket_id\":2}', 0, '2020-12-23 11:37:59', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `packages`
--
CREATE TABLE `packages` (
`package_id` int(11) NOT NULL,
`no_of_student_from` int(11) DEFAULT NULL,
`no_of_student_to` int(11) DEFAULT NULL,
`status` int(11) DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `packages`
--
INSERT INTO `packages` (`package_id`, `no_of_student_from`, `no_of_student_to`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 1, 500, 1, '2020-04-14 10:54:47', '0', NULL, NULL),
(9, 1, 2500, 1, '2020-08-25 18:39:36', '0', NULL, NULL),
(10, 1, 300, 1, '2020-10-20 16:37:05', '0', '2020-10-20 16:39:12', '0');
-- --------------------------------------------------------
--
-- Table structure for table `package_history`
--
CREATE TABLE `package_history` (
`package_history_id` int(11) NOT NULL,
`package_id` int(11) DEFAULT NULL,
`package_price_id` int(11) NOT NULL,
`no_of_student_from` varchar(50) DEFAULT NULL,
`no_of_student_to` varchar(50) DEFAULT NULL,
`duration` int(50) DEFAULT NULL,
`start_datetime` datetime DEFAULT NULL,
`end_datetime` datetime DEFAULT NULL,
`price` varchar(50) DEFAULT NULL,
`branch_id` varchar(100) DEFAULT NULL,
`no_of_card_issued` int(11) DEFAULT NULL,
`setup_fee` decimal(20,2) DEFAULT NULL,
`card_price` decimal(20,2) DEFAULT NULL,
`type_of_transaction` int(11) DEFAULT NULL COMMENT '0-initial, 1-renewal, 2-upgrade',
`tax_percentage` decimal(20,2) DEFAULT NULL,
`tax_amount` decimal(20,2) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `package_history`
--
INSERT INTO `package_history` (`package_history_id`, `package_id`, `package_price_id`, `no_of_student_from`, `no_of_student_to`, `duration`, `start_datetime`, `end_datetime`, `price`, `branch_id`, `no_of_card_issued`, `setup_fee`, `card_price`, `type_of_transaction`, `tax_percentage`, `tax_amount`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 1, 1, '1', '500', 1, '2020-08-21 21:57:16', '2020-09-21 21:57:16', '100.00', '1', 600, 1000.00, 60000.00, 0, 18.00, 10980.00, NULL, NULL, '2020-08-21 21:57:16', '1'),
(39, 9, 48, '1', '2500', 36, '2020-08-25 18:43:57', '2023-08-25 18:43:57', '4800.00', '24', 600, 100000.00, 2880000.00, 0, 18.00, 536400.00, '2020-08-25 18:38:20', '1', '2020-08-25 18:43:57', '1'),
(40, 9, 43, '1', '2500', 1, '2020-09-21 21:57:16', '2020-11-16 18:05:40', '285.00', '1', 1, 0.00, 285.00, 2, 18.00, 51.30, '2020-10-16 18:05:40', '1', NULL, NULL),
(41, 9, 46, '1', '2500', 12, '2020-10-20 16:25:34', '2021-10-20 16:25:34', '2950.00', '25', 1100, 100000.00, 3245000.00, 0, 18.00, 602100.00, '2020-10-20 16:21:53', '1', '2020-10-20 16:25:34', '1'),
(42, 9, 48, '1', '2500', 36, '2020-12-17 10:41:13', '2023-12-17 10:41:13', '4800.00', '26', 1150, 100000.00, 5520000.00, 0, 18.00, 1011600.00, '2020-12-17 10:41:13', '1', NULL, NULL),
(43, 10, 49, '1', '300', 1, '2020-12-17 10:54:04', '2021-01-17 10:54:04', '50.00', '27', 15, 0.00, 750.00, 0, 18.00, 135.00, '2020-12-17 10:54:04', '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `package_price`
--
CREATE TABLE `package_price` (
`package_price_id` int(11) NOT NULL,
`package_id` int(50) DEFAULT NULL,
`duration` varchar(100) DEFAULT NULL,
`price` decimal(20,2) DEFAULT NULL,
`status` int(11) DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `package_price`
--
INSERT INTO `package_price` (`package_price_id`, `package_id`, `duration`, `price`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 1, '1', 100.00, 1, '2020-04-14 00:00:00', '0', NULL, NULL),
(2, 1, '3', 200.00, 1, '2020-04-14 00:00:00', '0', NULL, NULL),
(3, 1, '6', 300.00, 1, '2020-04-14 10:56:17', '0', NULL, NULL),
(4, 1, '12', 400.00, 1, '2020-04-14 00:00:00', '0', NULL, NULL),
(5, 1, '24', 500.00, 1, '2020-04-14 00:00:00', '0', NULL, NULL),
(6, 1, '36', 600.00, 1, '2020-04-14 00:00:00', '0', NULL, NULL),
(43, 9, '1', 285.00, 1, '2020-08-25 00:00:00', '0', NULL, NULL),
(44, 9, '3', 810.00, 1, '2020-08-25 00:00:00', '0', NULL, NULL),
(45, 9, '6', 1550.00, 1, '2020-08-25 18:41:38', '0', NULL, NULL),
(46, 9, '12', 2950.00, 1, '2020-08-25 00:00:00', '0', NULL, NULL),
(47, 9, '24', 3100.00, 1, '2020-08-25 00:00:00', '0', NULL, NULL),
(48, 9, '36', 4800.00, 1, '2020-08-25 00:00:00', '0', NULL, NULL),
(49, 10, '1', 50.00, 1, '2020-10-20 00:00:00', '0', NULL, NULL),
(50, 10, '3', 150.00, 1, '2020-10-20 00:00:00', '0', NULL, NULL),
(51, 10, '6', 300.00, 1, '2020-10-20 16:40:15', '0', NULL, NULL),
(52, 10, '12', 600.00, 1, '2020-10-20 00:00:00', '0', NULL, NULL),
(53, 10, '24', 1200.00, 1, '2020-10-20 00:00:00', '0', NULL, NULL),
(54, 10, '36', 1800.00, 1, '2020-10-20 00:00:00', '0', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `passwordreset`
--
CREATE TABLE `passwordreset` (
`id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`branch_id` int(11) DEFAULT NULL,
`token` varchar(255) NOT NULL,
`created_on` datetime NOT NULL,
`validity_hours` varchar(255) NOT NULL,
`acl_user_id` int(11) DEFAULT NULL,
`employee_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `passwordreset`
--
INSERT INTO `passwordreset` (`id`, `user_id`, `customer_id`, `branch_id`, `token`, `created_on`, `validity_hours`, `acl_user_id`, `employee_id`) VALUES
(1, NULL, NULL, 24, '5e974e83858b8e506bae697bf1b793eb', '2020-09-19 16:42:50', '24', NULL, NULL),
(3, NULL, NULL, 1, 'd061312fb633c4210f05d1f179049d7b', '2020-09-19 16:50:00', '24', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `rfid_cards`
--
CREATE TABLE `rfid_cards` (
`id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`rfid_card_id` varchar(50) DEFAULT NULL,
`uuid` varchar(100) DEFAULT NULL,
`read_on` varchar(100) DEFAULT NULL,
`mac_address` varchar(355) DEFAULT NULL,
`signal_strength_rssi` decimal(3,2) DEFAULT NULL,
`battery_level_percentage` decimal(3,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` int(20) NOT NULL,
`role_name` varchar(255) DEFAULT NULL,
`status` tinyint(1) DEFAULT 1,
`created_on` datetime DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `role_name`, `status`, `created_on`, `created_by`, `updated_on`, `updated_by`) VALUES
(1, 'Support Engineer', 1, '2020-04-14 11:00:28', '0', NULL, NULL),
(2, 'Data Entry', 1, '2020-04-14 11:00:37', '0', '2020-10-20 16:48:23', '1'),
(3, 'Teacher', 1, '2020-04-14 11:05:43', '0', '2020-10-20 16:48:23', '1'),
(4, 'Driver', 1, '2020-04-14 11:05:53', '0', '2020-10-20 16:48:23', '1'),
(5, 'Sub Admin', 1, '2020-08-25 18:48:24', '0', '2020-10-20 16:48:23', '1'),
(6, 'Head Master', 2, '2020-08-30 18:25:38', '0', '2020-08-30 18:25:58', '1'),
(7, 'Data Entry 1', 1, '2020-08-31 13:04:49', '0', '2020-10-20 16:48:23', '1'),
(8, 'Admin', 1, '2020-10-20 16:50:46', '0', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `role_permissions`
--
CREATE TABLE `role_permissions` (
`role_permissions_id` int(50) NOT NULL,
`role_id` int(255) DEFAULT NULL,
`crm_menu_id` int(255) DEFAULT NULL,
`menu_group_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `role_permissions`
--
INSERT INTO `role_permissions` (`role_permissions_id`, `role_id`, `crm_menu_id`, `menu_group_id`) VALUES
(1, 4, 2, 1),
(2, 3, 35, 2),
(3, 3, 52, 10),
(4, 3, 5, 2),
(5, 4, 8, 2),
(6, 4, 10, 2),
(7, 3, 14, 3),
(8, 4, 17, 5),
(9, 3, 20, 5),
(10, 4, 20, 5),
(11, 6, 20, 5),
(12, 6, 23, 6),
(13, 4, 27, 7),
(14, 6, 1, 1),
(15, 6, 4, 1),
(16, 6, 8, 2),
(17, 6, 10, 2),
(18, 6, 40, 1),
(19, 3, 27, 7),
(20, 3, 28, 7),
(21, 4, 28, 7),
(22, 3, 30, 7),
(23, 4, 30, 7),
(24, 5, 5, 2),
(25, 5, 6, 2),
(26, 5, 8, 2),
(27, 5, 9, 12),
(28, 5, 57, 12),
(29, 5, 58, 12),
(30, 5, 59, 12),
(31, 5, 60, 12),
(32, 5, 61, 12),
(33, 2, 23, 6),
(34, 2, 26, 6),
(35, 2, 42, 2),
(36, 2, 43, 2),
(37, 2, 11, 3),
(38, 2, 12, 3),
(39, 2, 52, 10),
(40, 3, 6, 2),
(41, 3, 8, 2),
(42, 3, 60, 12),
(43, 8, 9, 12),
(44, 8, 8, 2),
(45, 8, 5, 2),
(46, 8, 14, 3);
-- --------------------------------------------------------
--
-- Table structure for table `school_layout`
--
CREATE TABLE `school_layout` (
`layout_id` int(11) NOT NULL,
`customer_id` int(11) DEFAULT NULL,
`layout_data` varchar(255) DEFAULT NULL,
`created_on` datetime NOT NULL,
`created_by` varchar(255) NOT NULL,
`updated_on` datetime NOT NULL,
`updated_by` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `setup_fee`
--
CREATE TABLE `setup_fee` (
`setup_fee_id` int(11) NOT NULL,
`setup_fee` decimal(20,2) DEFAULT NULL,
`is_all_package` int(11) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_by` varchar(100) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_by` varchar(100) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `setup_fee`
--
INSERT INTO `setup_fee` (`setup_fee_id`, `setup_fee`, `is_all_package`, `status`, `created_by`, `created_on`, `updated_by`, `updated_on`) VALUES
(1, 1000.00, 0, 2, '1', '2020-04-14 11:04:31', NULL, '2020-10-20 16:35:01'),
(2, 10000.00, 0, 2, '1', '2020-04-14 11:04:59', NULL, '2020-10-20 16:35:01'),
(3, 100000.00, 0, 2, '1', '2020-08-25 18:43:14', NULL, '2020-10-20 16:36:27'),
(4, 12050.00, 0, 2, '1', '2020-10-20 16:35:29', NULL, '2020-10-20 16:36:27'),
(5, 20000.00, 0, 1, '1', '2020-10-20 16:36:34', '1', '2020-10-20 16:37:41');
-- --------------------------------------------------------
--
-- Table structure for table `setup_package`
--
CREATE TABLE `setup_package` (
`setup_package_id` int(11) NOT NULL,
`setup_fee_id` int(11) DEFAULT NULL,
`package_id` int(11) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_by` varchar(100) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_by` varchar(100) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `setup_package`
--
INSERT INTO `setup_package` (`setup_package_id`, `setup_fee_id`, `package_id`, `status`, `created_by`, `created_on`, `updated_by`, `updated_on`) VALUES
(1, 1, 1, 2, '1', '2020-04-14 11:04:31', NULL, '2020-10-20 16:35:01'),
(2, 2, 4, 2, '1', '2020-04-14 11:04:59', NULL, '2020-10-20 16:35:01'),
(3, 3, 9, 2, '1', '2020-08-25 18:43:14', NULL, '2020-10-20 16:36:27'),
(5, 4, 1, 2, NULL, NULL, NULL, '2020-10-20 16:36:27'),
(7, 5, 0, 1, NULL, NULL, '1', '2020-10-20 16:37:41');
-- --------------------------------------------------------
--
-- Table structure for table `state`
--
CREATE TABLE `state` (
`state_id` int(11) NOT NULL,
`country_id` int(11) DEFAULT NULL,
`state_name` varchar(1500) DEFAULT NULL,
`state_code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `state`
--
INSERT INTO `state` (`state_id`, `country_id`, `state_name`, `state_code`) VALUES
(1, 102, 'Jummu and kashmir', '1'),
(2, 102, 'Himachal pradesh', '2'),
(3, 102, 'Punjab', '3'),
(4, 102, 'Chandigarh', '4'),
(5, 102, 'Uttarakhand', '5'),
(6, 102, 'Haryana', '6'),
(7, 102, 'Delhi', '7'),
(8, 102, 'Rajasthan', '8'),
(9, 102, 'Uttar Pradesh', '9'),
(10, 102, 'Bihar', '10'),
(11, 102, 'Sikkim', '11'),
(12, 102, 'Arunachal Pradesh', '12'),
(13, 102, 'Nagaland', '13'),
(14, 102, 'Manipur', '14'),
(15, 102, 'Mizoram', '15'),
(16, 102, 'Tripura', '16'),
(17, 102, 'Meghalaya', '17'),
(18, 102, 'Assam', '18'),
(19, 102, 'West Bengal', '19'),
(20, 102, 'Jharkhand', '20'),
(21, 102, 'Orissa', '21'),
(22, 102, 'Chhattisgarh', '22'),
(23, 102, 'Madhya Pradesh', '23'),
(24, 102, 'Gujarat', '24'),
(25, 102, 'Daman & Diu', '25'),
(26, 102, 'Dadra & Nagar Haveli', '26'),
(27, 102, 'Maharashtra', '27'),
(28, 102, 'Andhra Pradesh', '28'),
(29, 102, 'Karnataka', '29'),
(30, 102, 'Goa', '30'),
(31, 102, 'Lakshadweep', '31'),
(32, 102, 'Kerala', '32'),
(33, 102, 'Tamil Nadu', '33'),
(34, 102, 'Puducherry', '34'),
(35, 102, 'Andaman & Nicobar Islands', '35'),
(36, 102, 'Telengana', '36');
-- --------------------------------------------------------
--
-- Table structure for table `tax`
--
CREATE TABLE `tax` (
`tax_id` int(11) NOT NULL,
`tax_percentage` decimal(20,2) NOT NULL,
`created_on` datetime NOT NULL,
`created_by` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `tax`
--
INSERT INTO `tax` (`tax_id`, `tax_percentage`, `created_on`, `created_by`) VALUES
(1, 18.00, '2020-10-20 16:46:46', '0');
-- --------------------------------------------------------
--
-- Table structure for table `tenants`
--
CREATE TABLE `tenants` (
`id` varchar(255) NOT NULL,
`data` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `tenants`
--
INSERT INTO `tenants` (`id`, `data`) VALUES
('tgsstest_queenmira', '{\"_tenancy_db_name\":\"tgsstest_queenmira\",\"id\":\"6b180\"}'),
('school', '{\"_tenancy_db_name\":\"u849362929_velammaldb\",\"id\":\"6b180\"}'),
('tgsstest_vidyaavikas', '{\"_tenancy_db_name\":\"tgsstest_vidyaa\",\"id\":\"6b180\"}');
-- --------------------------------------------------------
--
-- Stand-in structure for view `transaction`
-- (See below for the actual view)
--
CREATE TABLE `transaction` (
`account_configuration_id` int(11)
,`package_history_id` int(11)
,`customer_id` int(11)
,`branch_id` int(11)
,`no_of_student_from` varchar(50)
,`no_of_student_to` varchar(50)
,`duration` int(50)
,`package_id` int(11)
,`city` varchar(1500)
,`city_id` int(11)
,`school_name` varchar(355)
,`total_amount` decimal(44,2)
,`paid_amount` decimal(42,2)
,`balance_amount` decimal(45,2)
);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`role_id` int(11) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`password` varchar(250) DEFAULT NULL,
`name` varchar(250) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
`active` tinyint(1) DEFAULT 1,
`remember_time` text DEFAULT NULL,
`remember_expire` text DEFAULT NULL,
`verification_code` text DEFAULT NULL,
`ip_address` text DEFAULT NULL,
`new_pass_key` varchar(255) DEFAULT NULL,
`new_pass_key_requested` datetime DEFAULT NULL,
`last_password_change` datetime DEFAULT NULL,
`date_updated` datetime DEFAULT NULL,
`email_verification` tinyint(4) DEFAULT NULL,
`mobile_no` varchar(255) DEFAULT NULL,
`api_token` varchar(500) DEFAULT NULL,
`created_on` datetime NOT NULL,
`created_by` varchar(255) NOT NULL,
`updated_on` datetime DEFAULT NULL,
`updated_by` varchar(255) DEFAULT NULL,
`logged_in_date` datetime DEFAULT NULL,
`logged_ip_address` varchar(500) DEFAULT NULL,
`firebase_token` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `role_id`, `email`, `password`, `name`, `last_login`, `date_created`, `active`, `remember_time`, `remember_expire`, `verification_code`, `ip_address`, `new_pass_key`, `new_pass_key_requested`, `last_password_change`, `date_updated`, `email_verification`, `mobile_no`, `api_token`, `created_on`, `created_by`, `updated_on`, `updated_by`, `logged_in_date`, `logged_ip_address`, `firebase_token`) VALUES
(1, 1, 'tgtest2019@gmail.com', '25d55ad283aa400af464c76d713c07ad', 'Super Admin', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9876543210', 'dGd0ZXN0MjAxOUBnbWFpbC5jb20', '2020-03-24 00:00:00', '1', '2020-04-05 08:35:29', '1', '2025-08-29 11:05:47', '117.120.56.58', 'sasdeddcedfe'),
(36, 2, 'rajapandi.nr@gmail.com', 'd8d3a06c78eea6c55ac41340345aca68', 'sam', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7639311390', NULL, '2020-04-14 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-04-15 15:21:22', '106.217.6.13', NULL),
(37, 2, 'projectmanager@technogenesis.in', 'd8d3a06c78eea6c55ac41340345aca68', 'Raja', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9790261892', NULL, '2020-04-14 00:00:00', '0', '2020-10-20 16:51:56', '1', NULL, NULL, NULL),
(38, 3, 'nivedha@technogenesis.in', 'f925916e2754e5e03f75dd58a5733251', 'Nivedha', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8888888888', NULL, '2020-04-14 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-08-31 10:58:10', '157.46.87.87', NULL),
(39, 2, 'admin@gmail.com', 'f925916e2754e5e03f75dd58a5733251', 'Ganesh', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7777777777', NULL, '2020-04-14 00:00:00', '0', '2020-10-20 16:51:56', '1', NULL, NULL, NULL),
(40, 3, 'tgtest20@gmail.com', 'f925916e2754e5e03f75dd58a5733251', 'John', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9999999999', NULL, '2020-04-14 00:00:00', '0', '2020-04-14 13:04:25', '1', NULL, NULL, NULL),
(41, 3, 'tgtest2000@gmail.com', '0d786fc261358dc21491b646a1459004', 'admin', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7856432123', NULL, '2020-04-14 00:00:00', '0', '2020-04-14 13:04:06', '1', NULL, NULL, NULL),
(42, 2, 'ganesh@gmail.com', '0c09803542850718277b10fd17d5ebd4', 'ganesh', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216741', NULL, '2020-04-14 00:00:00', '0', '2020-04-14 13:03:49', '1', NULL, NULL, NULL),
(43, 3, 'siva@gmail.com', '8907fc2282ea176b029fd7819a83dc2f', 'siva', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6745326754', NULL, '2020-04-15 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-04-16 11:30:52', '157.51.255.59', NULL),
(44, 5, 'nive@gmail.com', 'f925916e2754e5e03f75dd58a5733251', 'Nivedha', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7200584645', NULL, '2020-08-25 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-08-25 18:50:17', '106.198.78.109', NULL),
(45, 3, 'ganeshpandi@gmail.com', '0c09803542850718277b10fd17d5ebd4', 'Ganesh Gp', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216741', NULL, '2020-08-30 00:00:00', '0', '2020-08-30 18:21:55', '1', NULL, NULL, NULL),
(46, 3, 'ganeshpandi@technogenesis.in', 'e89b7c2a5b0bea24c278e7557ad14851', 'Ganesh Gp', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216741', NULL, '2020-08-30 00:00:00', '0', '2020-08-30 18:28:08', '1', NULL, NULL, NULL),
(47, 3, 'ganeshpandi@technogenesis.in', 'e89b7c2a5b0bea24c278e7557ad14851', 'Ganesh Gp', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216741', NULL, '2020-08-30 00:00:00', '0', '2020-08-30 18:39:39', '1', NULL, NULL, NULL),
(48, 3, 'ganeshpandi@technogenesis.in', 'e83c8a9c13bbc92c97d0757c986bd277', 'Ganesh Gp', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216741', NULL, '2020-08-30 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-08-31 14:08:02', '122.178.21.67', NULL),
(49, 2, 'devi@gmail.com', 'f925916e2754e5e03f75dd58a5733251', 'Devi', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7878778909', NULL, '2020-08-31 00:00:00', '0', '2020-10-20 16:51:56', '1', '2020-08-31 13:21:22', '106.198.67.49', NULL),
(50, 3, 'vijayi@gmail.com', 'd41d8cd98f00b204e9800998ecf8427e', 'Vijay', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8798789098', NULL, '2020-08-31 00:00:00', '0', '2020-10-20 00:00:00', '0', NULL, NULL, NULL),
(51, 3, 'kumar@gmail.com', '51cceafee3e2329af9522255baaaa5ed', 'kumar', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7845216742', NULL, '2020-08-31 00:00:00', '0', '2020-10-20 16:51:56', '1', NULL, NULL, NULL),
(52, 8, 'ak@gmail.com', 'fe5998bf55874cf9449d4d60141d91e8', 'Ajith Kumar', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7502532515', NULL, '2020-10-20 00:00:00', '0', NULL, NULL, NULL, NULL, NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `account_configuration`
--
ALTER TABLE `account_configuration`
ADD PRIMARY KEY (`account_configuration_id`),
ADD KEY `ac_cus_id_fk` (`branch_id`),
ADD KEY `ac_package_id_fk` (`package_id`);
--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
ADD PRIMARY KEY (`activity_log_id`),
ADD KEY `act_log_act-type_id_fk` (`activity_type`);
--
-- Indexes for table `activity_type`
--
ALTER TABLE `activity_type`
ADD PRIMARY KEY (`activity_type_id`);
--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
ADD PRIMARY KEY (`branch_id`);
--
-- Indexes for table `company_information`
--
ALTER TABLE `company_information`
ADD PRIMARY KEY (`company_id`);
--
-- Indexes for table `country`
--
ALTER TABLE `country`
ADD PRIMARY KEY (`country_id`);
--
-- Indexes for table `crm_menu`
--
ALTER TABLE `crm_menu`
ADD PRIMARY KEY (`crm_menu_id`);
--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
ADD PRIMARY KEY (`customer_id`);
--
-- Indexes for table `customer_contact`
--
ALTER TABLE `customer_contact`
ADD PRIMARY KEY (`customer_contact_id`),
ADD KEY `cus_contact_cus_id_fk` (`branch_id`);
--
-- Indexes for table `device_assignment`
--
ALTER TABLE `device_assignment`
ADD PRIMARY KEY (`device_assignment_id`),
ADD KEY `dev_assign_dev_maker_id_fk` (`device_maker_id`);
--
-- Indexes for table `device_maker`
--
ALTER TABLE `device_maker`
ADD PRIMARY KEY (`device_maker_id`);
--
-- Indexes for table `district`
--
ALTER TABLE `district`
ADD PRIMARY KEY (`district_id`);
--
-- Indexes for table `domains`
--
ALTER TABLE `domains`
ADD PRIMARY KEY (`domain`);
--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
ADD PRIMARY KEY (`invoice_id`);
--
-- Indexes for table `menu_group`
--
ALTER TABLE `menu_group`
ADD PRIMARY KEY (`menu_group_id`);
--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
ADD PRIMARY KEY (`notification_id`);
--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
ADD PRIMARY KEY (`package_id`);
--
-- Indexes for table `package_history`
--
ALTER TABLE `package_history`
ADD PRIMARY KEY (`package_history_id`),
ADD KEY `package_history_fk` (`package_id`);
--
-- Indexes for table `package_price`
--
ALTER TABLE `package_price`
ADD PRIMARY KEY (`package_price_id`),
ADD KEY `package_id` (`package_id`);
--
-- Indexes for table `passwordreset`
--
ALTER TABLE `passwordreset`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `rfid_cards`
--
ALTER TABLE `rfid_cards`
ADD PRIMARY KEY (`id`),
ADD KEY `rfid_card_cus_id_fk` (`customer_id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
ADD PRIMARY KEY (`role_permissions_id`);
--
-- Indexes for table `school_layout`
--
ALTER TABLE `school_layout`
ADD PRIMARY KEY (`layout_id`),
ADD KEY `school_layout_cus_id_fk` (`customer_id`);
--
-- Indexes for table `setup_fee`
--
ALTER TABLE `setup_fee`
ADD PRIMARY KEY (`setup_fee_id`);
--
-- Indexes for table `setup_package`
--
ALTER TABLE `setup_package`
ADD PRIMARY KEY (`setup_package_id`);
--
-- Indexes for table `state`
--
ALTER TABLE `state`
ADD PRIMARY KEY (`state_id`);
--
-- Indexes for table `tax`
--
ALTER TABLE `tax`
ADD PRIMARY KEY (`tax_id`);
--
-- Indexes for table `tenants`
--
ALTER TABLE `tenants`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD KEY `users_role_id_fk` (`role_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `account_configuration`
--
ALTER TABLE `account_configuration`
MODIFY `account_configuration_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
MODIFY `activity_log_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `activity_type`
--
ALTER TABLE `activity_type`
MODIFY `activity_type_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
MODIFY `branch_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `company_information`
--
ALTER TABLE `company_information`
MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;
--
-- AUTO_INCREMENT for table `crm_menu`
--
ALTER TABLE `crm_menu`
MODIFY `crm_menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `customer_contact`
--
ALTER TABLE `customer_contact`
MODIFY `customer_contact_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
--
-- AUTO_INCREMENT for table `device_assignment`
--
ALTER TABLE `device_assignment`
MODIFY `device_assignment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `device_maker`
--
ALTER TABLE `device_maker`
MODIFY `device_maker_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `district`
--
ALTER TABLE `district`
MODIFY `district_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=719;
--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `menu_group`
--
ALTER TABLE `menu_group`
MODIFY `menu_group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
MODIFY `notification_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `package_history`
--
ALTER TABLE `package_history`
MODIFY `package_history_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT for table `package_price`
--
ALTER TABLE `package_price`
MODIFY `package_price_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
--
-- AUTO_INCREMENT for table `passwordreset`
--
ALTER TABLE `passwordreset`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `rfid_cards`
--
ALTER TABLE `rfid_cards`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
MODIFY `role_permissions_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table `school_layout`
--
ALTER TABLE `school_layout`
MODIFY `layout_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `setup_fee`
--
ALTER TABLE `setup_fee`
MODIFY `setup_fee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `setup_package`
--
ALTER TABLE `setup_package`
MODIFY `setup_package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `state`
--
ALTER TABLE `state`
MODIFY `state_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `tax`
--
ALTER TABLE `tax`
MODIFY `tax_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
-- --------------------------------------------------------
--
-- Structure for view `transaction`
--
DROP TABLE IF EXISTS `transaction`;
CREATE ALGORITHM=UNDEFINED DEFINER=`u849362929_productuser`@`127.0.0.1` SQL SECURITY DEFINER VIEW `transaction` AS SELECT `account_configuration`.`account_configuration_id` AS `account_configuration_id`, `package_history`.`package_history_id` AS `package_history_id`, `branch`.`customer_id` AS `customer_id`, `branch`.`branch_id` AS `branch_id`, `package_history`.`no_of_student_from` AS `no_of_student_from`, `package_history`.`no_of_student_to` AS `no_of_student_to`, `package_history`.`duration` AS `duration`, `package_history`.`package_id` AS `package_id`, `district`.`district_name` AS `city`, `district`.`district_id` AS `city_id`, `branch`.`school_name` AS `school_name`, ifnull((select sum(`package_history`.`card_price`) + sum(`package_history`.`setup_fee`) + sum(`package_history`.`tax_amount`) from `package_history` where `package_history`.`branch_id` = `account_configuration`.`branch_id`),0) AS `total_amount`, ifnull((select sum(`invoice`.`paid_amount`) from `invoice` where `invoice`.`branch_id` = `account_configuration`.`branch_id` and `invoice`.`is_refund` = 0),0) AS `paid_amount`, ifnull((select ifnull(sum(`package_history`.`card_price`),0) + ifnull(sum(`package_history`.`setup_fee`),0) + ifnull(sum(`package_history`.`tax_amount`),0) from `package_history` where `package_history`.`branch_id` = `account_configuration`.`branch_id`),0) - ifnull((select sum(`invoice`.`paid_amount`) from `invoice` where `invoice`.`branch_id` = `account_configuration`.`branch_id` and `invoice`.`is_refund` = 0),0) AS `balance_amount` FROM (((`account_configuration` left join `branch` on(`branch`.`branch_id` = `account_configuration`.`branch_id`)) left join `package_history` on(`package_history`.`package_history_id` = `account_configuration`.`package_history_id`)) left join `district` on(`district`.`district_id` = `branch`.`city_id`)) WHERE `branch`.`status` <> 2 ;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `account_configuration`
--
ALTER TABLE `account_configuration`
ADD CONSTRAINT `ac_cus_id_fk` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`branch_id`),
ADD CONSTRAINT `ac_package_id_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`);
--
-- Constraints for table `activity_log`
--
ALTER TABLE `activity_log`
ADD CONSTRAINT `act_log_act-type_id_fk` FOREIGN KEY (`activity_type`) REFERENCES `activity_type` (`activity_type_id`);
--
-- Constraints for table `customer_contact`
--
ALTER TABLE `customer_contact`
ADD CONSTRAINT `cus_contact_cus_id_fk` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`branch_id`);
--
-- Constraints for table `device_assignment`
--
ALTER TABLE `device_assignment`
ADD CONSTRAINT `dev_assign_dev_maker_id_fk` FOREIGN KEY (`device_maker_id`) REFERENCES `device_maker` (`device_maker_id`);
--
-- Constraints for table `package_history`
--
ALTER TABLE `package_history`
ADD CONSTRAINT `package_history_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`);
--
-- Constraints for table `package_price`
--
ALTER TABLE `package_price`
ADD CONSTRAINT `package_price_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`);
--
-- Constraints for table `rfid_cards`
--
ALTER TABLE `rfid_cards`
ADD CONSTRAINT `rfid_card_cus_id_fk` FOREIGN KEY (`customer_id`) REFERENCES `branch` (`branch_id`);
--
-- Constraints for table `school_layout`
--
ALTER TABLE `school_layout`
ADD CONSTRAINT `school_layout_cus_id_fk` FOREIGN KEY (`customer_id`) REFERENCES `branch` (`branch_id`);
--
-- Constraints for table `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_role_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
COMMIT;
/*!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 */;
