-- MySQL dump 10.13 Distrib 8.0.44, for Linux (x86_64) -- -- Host: localhost Database: u849362929_productdb -- ------------------------------------------------------ -- Server version 8.0.44-0ubuntu0.22.04.1 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `account_configuration` -- DROP TABLE IF EXISTS `account_configuration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_configuration` ( `account_configuration_id` int NOT NULL AUTO_INCREMENT, `domain_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `language` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `timezone` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `currency_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `currency_symbol` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `theme_colour` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `theme_font` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `precision_count` int DEFAULT NULL, `branch_id` int DEFAULT NULL, `package_id` int DEFAULT NULL, `package_history_id` int DEFAULT NULL, `package_start_datetime` datetime DEFAULT NULL, `package_end_datetime` datetime DEFAULT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `no_of_card_issued` int DEFAULT NULL, `account_created_on` date DEFAULT NULL, `account_status` int DEFAULT NULL, `database_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `date_format` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `date_separator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `time_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `no_of_student` int DEFAULT NULL, `no_of_employee` int DEFAULT NULL, `approx_visitor_card` int DEFAULT NULL, `student_employee_card` int DEFAULT NULL, `visitor_card` int DEFAULT NULL, `setup_fee` decimal(20,2) DEFAULT NULL, `created_on` datetime DEFAULT NULL, `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`account_configuration_id`), KEY `ac_cus_id_fk` (`branch_id`), KEY `ac_package_id_fk` (`package_id`), CONSTRAINT `ac_cus_id_fk` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`branch_id`), CONSTRAINT `ac_package_id_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_configuration` -- LOCK TABLES `account_configuration` WRITE; /*!40000 ALTER TABLE `account_configuration` DISABLE KEYS */; INSERT INTO `account_configuration` 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','tgtest2019@gmail.com','25d55ad283aa400af464c76d713c07ad',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','2025-08-31 19:17:55'),(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); /*!40000 ALTER TABLE `account_configuration` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity_log` -- DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_log` ( `activity_log_id` int NOT NULL AUTO_INCREMENT, `description` text, `created_on` datetime DEFAULT NULL, `created_by` varchar(500) DEFAULT NULL, `activity_type` int DEFAULT NULL, PRIMARY KEY (`activity_log_id`), KEY `act_log_act-type_id_fk` (`activity_type`), CONSTRAINT `act_log_act-type_id_fk` FOREIGN KEY (`activity_type`) REFERENCES `activity_type` (`activity_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_log` -- LOCK TABLES `activity_log` WRITE; /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity_type` -- DROP TABLE IF EXISTS `activity_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_type` ( `activity_type_id` int NOT NULL AUTO_INCREMENT, `activity_type_name` varchar(250) DEFAULT NULL, PRIMARY KEY (`activity_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_type` -- LOCK TABLES `activity_type` WRITE; /*!40000 ALTER TABLE `activity_type` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assets` -- DROP TABLE IF EXISTS `assets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assets` ( `asset_id` int NOT NULL, `asset_name` varchar(255) DEFAULT NULL, `status` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assets` -- LOCK TABLES `assets` WRITE; /*!40000 ALTER TABLE `assets` DISABLE KEYS */; /*!40000 ALTER TABLE `assets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attendance` -- DROP TABLE IF EXISTS `attendance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance` ( `attendance_id` bigint NOT NULL, `employee_id` bigint NOT NULL, `service_location_id` bigint 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 NOT NULL DEFAULT '0', `device_type` tinyint(1) NOT NULL COMMENT '1-mobile, 2-web', `device_information` text, `created_on` datetime DEFAULT NULL, `created_by` bigint DEFAULT NULL, `updated_by` bigint DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `status` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance` -- LOCK TABLES `attendance` WRITE; /*!40000 ALTER TABLE `attendance` DISABLE KEYS */; /*!40000 ALTER TABLE `attendance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_login_attempts` -- DROP TABLE IF EXISTS `auth_login_attempts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_login_attempts` ( `id` int NOT NULL, `ip_address` varchar(39) DEFAULT '0', `timestamp` datetime DEFAULT NULL, `login_attempts` tinyint DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_login_attempts` -- LOCK TABLES `auth_login_attempts` WRITE; /*!40000 ALTER TABLE `auth_login_attempts` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_login_attempts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blood_group` -- DROP TABLE IF EXISTS `blood_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blood_group` ( `blood_group_id` int NOT NULL, `name` varchar(20) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blood_group` -- LOCK TABLES `blood_group` WRITE; /*!40000 ALTER TABLE `blood_group` DISABLE KEYS */; /*!40000 ALTER TABLE `blood_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `branch` -- DROP TABLE IF EXISTS `branch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `branch` ( `branch_id` int NOT NULL AUTO_INCREMENT, `customer_id` int DEFAULT NULL, `school_name` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `logo` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `address_line1` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `address_line2` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `state_id` int DEFAULT NULL, `city_id` int DEFAULT NULL, `country_id` int DEFAULT NULL, `zipcode` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL, `registration_code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL, `phone` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL, `mobile` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `website` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` int DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `firebase_token` text COLLATE utf8mb4_general_ci, PRIMARY KEY (`branch_id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `branch` -- LOCK TABLES `branch` WRITE; /*!40000 ALTER TABLE `branch` DISABLE KEYS */; INSERT INTO `branch` 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','2025-08-31 19:17:55',NULL),(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); /*!40000 ALTER TABLE `branch` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cancel_hour` -- DROP TABLE IF EXISTS `cancel_hour`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cancel_hour` ( `cancel_hour_id` int NOT NULL, `cancel_hours` varchar(25) DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` int DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cancel_hour` -- LOCK TABLES `cancel_hour` WRITE; /*!40000 ALTER TABLE `cancel_hour` DISABLE KEYS */; /*!40000 ALTER TABLE `cancel_hour` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_type` -- DROP TABLE IF EXISTS `category_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category_type` ( `category_type_id` int NOT NULL, `category_type` varchar(255) DEFAULT NULL, `status` tinyint NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_type` -- LOCK TABLES `category_type` WRITE; /*!40000 ALTER TABLE `category_type` DISABLE KEYS */; /*!40000 ALTER TABLE `category_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_page` -- DROP TABLE IF EXISTS `cms_page`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_page` ( `cms_page_id` int NOT NULL, `slug` varchar(500) DEFAULT NULL, `content` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_page` -- LOCK TABLES `cms_page` WRITE; /*!40000 ALTER TABLE `cms_page` DISABLE KEYS */; /*!40000 ALTER TABLE `cms_page` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `code_standard` -- DROP TABLE IF EXISTS `code_standard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `code_standard` ( `code_standard_id` int NOT NULL, `customer_id` int DEFAULT NULL, `standard_name` varchar(255) DEFAULT NULL, `status` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `code_standard` -- LOCK TABLES `code_standard` WRITE; /*!40000 ALTER TABLE `code_standard` DISABLE KEYS */; /*!40000 ALTER TABLE `code_standard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_document` -- DROP TABLE IF EXISTS `company_document`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company_document` ( `company_document_id` int NOT NULL, `document_type_id` int NOT NULL, `document_name` text NOT NULL, `created_on` datetime NOT NULL, `created_by` int NOT NULL, `status` tinyint NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_document` -- LOCK TABLES `company_document` WRITE; /*!40000 ALTER TABLE `company_document` DISABLE KEYS */; INSERT INTO `company_document` 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); /*!40000 ALTER TABLE `company_document` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_information` -- DROP TABLE IF EXISTS `company_information`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `company_information` ( `company_id` int NOT NULL AUTO_INCREMENT, `company_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `mobile` int 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 NOT NULL, `state_id` int DEFAULT NULL, `city_id` int DEFAULT NULL, `created_on` datetime DEFAULT NULL, `created_by` varchar(255) DEFAULT NULL, PRIMARY KEY (`company_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_information` -- LOCK TABLES `company_information` WRITE; /*!40000 ALTER TABLE `company_information` DISABLE KEYS */; INSERT INTO `company_information` 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'); /*!40000 ALTER TABLE `company_information` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `country` ( `country_id` int NOT NULL AUTO_INCREMENT, `country_name` varchar(255) NOT NULL, PRIMARY KEY (`country_id`) ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country` -- LOCK TABLES `country` WRITE; /*!40000 ALTER TABLE `country` DISABLE KEYS */; INSERT INTO `country` VALUES (102,'India'); /*!40000 ALTER TABLE `country` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cr_prd_image` -- DROP TABLE IF EXISTS `cr_prd_image`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cr_prd_image` ( `cr_prd_image_id` int NOT NULL, `captured_image` varchar(500) DEFAULT NULL, `reason` char(255) DEFAULT NULL, `cr_type_id` int DEFAULT NULL, `customer_id` int DEFAULT NULL, `status` int 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 DEFAULT NULL, `employee_id` int DEFAULT NULL, `reviewed_by` int DEFAULT NULL COMMENT 'customer contact person id', `reviewed_on` datetime DEFAULT NULL, `comment` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cr_prd_image` -- LOCK TABLES `cr_prd_image` WRITE; /*!40000 ALTER TABLE `cr_prd_image` DISABLE KEYS */; /*!40000 ALTER TABLE `cr_prd_image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cr_type` -- DROP TABLE IF EXISTS `cr_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cr_type` ( `cr_type_id` int NOT NULL, `name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cr_type` -- LOCK TABLES `cr_type` WRITE; /*!40000 ALTER TABLE `cr_type` DISABLE KEYS */; /*!40000 ALTER TABLE `cr_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `crm_menu` -- DROP TABLE IF EXISTS `crm_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `crm_menu` ( `crm_menu_id` int NOT NULL AUTO_INCREMENT, `menu_name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL, `icon_type` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL, `icon` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL, `url_type` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL, `url` text COLLATE utf8mb4_general_ci, `menu_action` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `menu_group_id` int DEFAULT NULL, `url_target` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL, `menu_class` text COLLATE utf8mb4_general_ci, `active` tinyint(1) DEFAULT NULL, `parent` int DEFAULT '0', `sort` int NOT NULL DEFAULT '0', `accesskey` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`crm_menu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `crm_menu` -- LOCK TABLES `crm_menu` WRITE; /*!40000 ALTER TABLE `crm_menu` DISABLE KEYS */; INSERT INTO `crm_menu` 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); /*!40000 ALTER TABLE `crm_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_field_aspect_reason` -- DROP TABLE IF EXISTS `custom_field_aspect_reason`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `custom_field_aspect_reason` ( `custom_field_aspect_reason_id` int NOT NULL, `customer_id` int DEFAULT NULL, `quality_aspects_id` int DEFAULT NULL, `aspect_reasons_id` int DEFAULT NULL, `type` int DEFAULT NULL, `rules` text, `options` text, `status` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_field_aspect_reason` -- LOCK TABLES `custom_field_aspect_reason` WRITE; /*!40000 ALTER TABLE `custom_field_aspect_reason` DISABLE KEYS */; /*!40000 ALTER TABLE `custom_field_aspect_reason` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_field_type` -- DROP TABLE IF EXISTS `custom_field_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `custom_field_type` ( `custom_field_type_id` int NOT NULL, `type_name` varchar(255) DEFAULT NULL, `status` tinyint NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_field_type` -- LOCK TABLES `custom_field_type` WRITE; /*!40000 ALTER TABLE `custom_field_type` DISABLE KEYS */; /*!40000 ALTER TABLE `custom_field_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer` ( `customer_id` int NOT NULL AUTO_INCREMENT, `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 DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(100) DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(100) DEFAULT NULL, PRIMARY KEY (`customer_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer` VALUES (1,'Sathish',NULL,NULL,NULL,'','John','9533443526','tgtest2019@gmail.com','Head Mistress','contact-person-1587471405-3IVcLPzLOu.png','tgtest2019@gmail.com','25d55ad283aa400af464c76d713c07ad',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','25d55ad283aa400af464c76d713c07ad','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); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer_contact` -- DROP TABLE IF EXISTS `customer_contact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_contact` ( `customer_contact_id` int NOT NULL AUTO_INCREMENT, `branch_id` int DEFAULT NULL, `contact_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `phone` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL, `mobile` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `photo` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `notes` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` int NOT NULL DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`customer_contact_id`), KEY `cus_contact_cus_id_fk` (`branch_id`), CONSTRAINT `cus_contact_cus_id_fk` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`branch_id`) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_contact` -- LOCK TABLES `customer_contact` WRITE; /*!40000 ALTER TABLE `customer_contact` DISABLE KEYS */; INSERT INTO `customer_contact` 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); /*!40000 ALTER TABLE `customer_contact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer_document` -- DROP TABLE IF EXISTS `customer_document`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_document` ( `customer_document_id` int NOT NULL, `customer_id` int DEFAULT NULL, `document` varchar(500) DEFAULT NULL, `status` tinyint 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_document` -- LOCK TABLES `customer_document` WRITE; /*!40000 ALTER TABLE `customer_document` DISABLE KEYS */; /*!40000 ALTER TABLE `customer_document` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer_events` -- DROP TABLE IF EXISTS `customer_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_events` ( `type_of_event` varchar(16) DEFAULT NULL, `type_id` int DEFAULT NULL, `event_name` text, `event_desc` text, `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_events` -- LOCK TABLES `customer_events` WRITE; /*!40000 ALTER TABLE `customer_events` DISABLE KEYS */; /*!40000 ALTER TABLE `customer_events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dc_wtime_sl` -- DROP TABLE IF EXISTS `dc_wtime_sl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `dc_wtime_sl` ( `service_location_id` int 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dc_wtime_sl` -- LOCK TABLES `dc_wtime_sl` WRITE; /*!40000 ALTER TABLE `dc_wtime_sl` DISABLE KEYS */; /*!40000 ALTER TABLE `dc_wtime_sl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department` -- DROP TABLE IF EXISTS `department`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `department` ( `department_id` int 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department` -- LOCK TABLES `department` WRITE; /*!40000 ALTER TABLE `department` DISABLE KEYS */; /*!40000 ALTER TABLE `department` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `device_assignment` -- DROP TABLE IF EXISTS `device_assignment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `device_assignment` ( `device_assignment_id` int NOT NULL AUTO_INCREMENT, `device_name` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `mac_address` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `description` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `device_maker_id` int DEFAULT NULL, `created_on` datetime NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `updated_on` datetime NOT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`device_assignment_id`), KEY `dev_assign_dev_maker_id_fk` (`device_maker_id`), CONSTRAINT `dev_assign_dev_maker_id_fk` FOREIGN KEY (`device_maker_id`) REFERENCES `device_maker` (`device_maker_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `device_assignment` -- LOCK TABLES `device_assignment` WRITE; /*!40000 ALTER TABLE `device_assignment` DISABLE KEYS */; /*!40000 ALTER TABLE `device_assignment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `device_maker` -- DROP TABLE IF EXISTS `device_maker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `device_maker` ( `device_maker_id` int NOT NULL AUTO_INCREMENT, PRIMARY KEY (`device_maker_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `device_maker` -- LOCK TABLES `device_maker` WRITE; /*!40000 ALTER TABLE `device_maker` DISABLE KEYS */; /*!40000 ALTER TABLE `device_maker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `district` -- DROP TABLE IF EXISTS `district`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `district` ( `district_id` int NOT NULL AUTO_INCREMENT, `state_id` int DEFAULT NULL, `district_name` varchar(1500) DEFAULT NULL, PRIMARY KEY (`district_id`) ) ENGINE=InnoDB AUTO_INCREMENT=719 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `district` -- LOCK TABLES `district` WRITE; /*!40000 ALTER TABLE `district` DISABLE KEYS */; INSERT INTO `district` 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'); /*!40000 ALTER TABLE `district` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `domains` -- DROP TABLE IF EXISTS `domains`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `domains` ( `domain` varchar(255) NOT NULL, `tenant_id` varchar(36) DEFAULT NULL, `customer_id` int DEFAULT NULL, PRIMARY KEY (`domain`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `domains` -- LOCK TABLES `domains` WRITE; /*!40000 ALTER TABLE `domains` DISABLE KEYS */; INSERT INTO `domains` VALUES ('queenmira.tgsstest.com','tgsstest_queenmira',1),('schoolportalapi.technogenesis.co.in','school',1),('vidyaavikas.tgsstest.com','tgsstest_vidyaavikas',NULL); /*!40000 ALTER TABLE `domains` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice` -- DROP TABLE IF EXISTS `invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `invoice` ( `invoice_id` int NOT NULL AUTO_INCREMENT, `branch_id` int DEFAULT NULL, `customer_id` int DEFAULT NULL, `package_history_id` int 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 DEFAULT NULL COMMENT '1-cash,2-bank', `reference_id` varchar(255) DEFAULT NULL, `payment_status` int DEFAULT NULL COMMENT '0-failure, 1-success', `notes` text, `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 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, PRIMARY KEY (`invoice_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice` -- LOCK TABLES `invoice` WRITE; /*!40000 ALTER TABLE `invoice` DISABLE KEYS */; INSERT INTO `invoice` 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'); /*!40000 ALTER TABLE `invoice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_group` -- DROP TABLE IF EXISTS `menu_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menu_group` ( `menu_group_id` int NOT NULL AUTO_INCREMENT, `menu_name` varchar(500) DEFAULT NULL, `status` int DEFAULT '1', PRIMARY KEY (`menu_group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_group` -- LOCK TABLES `menu_group` WRITE; /*!40000 ALTER TABLE `menu_group` DISABLE KEYS */; INSERT INTO `menu_group` 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); /*!40000 ALTER TABLE `menu_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification` -- DROP TABLE IF EXISTS `notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notification` ( `notification_id` int NOT NULL AUTO_INCREMENT, `title` varchar(500) DEFAULT NULL, `body` text, `user_type` int DEFAULT NULL COMMENT '5-product portal', `sender` int DEFAULT NULL, `receiver` int DEFAULT NULL, `module_name` text, `page` text, `portal` varchar(255) DEFAULT NULL, `data` text, `msg_read` int DEFAULT '0', `created_on` datetime NOT NULL, `status` int DEFAULT '1', `db_type` int NOT NULL DEFAULT '1', PRIMARY KEY (`notification_id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification` -- LOCK TABLES `notification` WRITE; /*!40000 ALTER TABLE `notification` DISABLE KEYS */; INSERT INTO `notification` 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); /*!40000 ALTER TABLE `notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `package_history` -- DROP TABLE IF EXISTS `package_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `package_history` ( `package_history_id` int NOT NULL AUTO_INCREMENT, `package_id` int DEFAULT NULL, `package_price_id` int NOT NULL, `no_of_student_from` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `no_of_student_to` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `duration` int DEFAULT NULL, `start_datetime` datetime DEFAULT NULL, `end_datetime` datetime DEFAULT NULL, `price` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `branch_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `no_of_card_issued` int DEFAULT NULL, `setup_fee` decimal(20,2) DEFAULT NULL, `card_price` decimal(20,2) DEFAULT NULL, `type_of_transaction` int 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`package_history_id`), KEY `package_history_fk` (`package_id`), CONSTRAINT `package_history_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `package_history` -- LOCK TABLES `package_history` WRITE; /*!40000 ALTER TABLE `package_history` DISABLE KEYS */; INSERT INTO `package_history` 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); /*!40000 ALTER TABLE `package_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `package_price` -- DROP TABLE IF EXISTS `package_price`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `package_price` ( `package_price_id` int NOT NULL AUTO_INCREMENT, `package_id` int DEFAULT NULL, `duration` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `price` decimal(20,2) DEFAULT NULL, `status` int DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`package_price_id`), KEY `package_id` (`package_id`), CONSTRAINT `package_price_fk` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `package_price` -- LOCK TABLES `package_price` WRITE; /*!40000 ALTER TABLE `package_price` DISABLE KEYS */; INSERT INTO `package_price` 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); /*!40000 ALTER TABLE `package_price` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `packages` -- DROP TABLE IF EXISTS `packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `packages` ( `package_id` int NOT NULL AUTO_INCREMENT, `no_of_student_from` int DEFAULT NULL, `no_of_student_to` int DEFAULT NULL, `status` int DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`package_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `packages` -- LOCK TABLES `packages` WRITE; /*!40000 ALTER TABLE `packages` DISABLE KEYS */; INSERT INTO `packages` 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'); /*!40000 ALTER TABLE `packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `passwordreset` -- DROP TABLE IF EXISTS `passwordreset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `passwordreset` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `customer_id` int DEFAULT NULL, `branch_id` int DEFAULT NULL, `token` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `created_on` datetime NOT NULL, `validity_hours` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `acl_user_id` int DEFAULT NULL, `employee_id` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `passwordreset` -- LOCK TABLES `passwordreset` WRITE; /*!40000 ALTER TABLE `passwordreset` DISABLE KEYS */; INSERT INTO `passwordreset` 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); /*!40000 ALTER TABLE `passwordreset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rfid_cards` -- DROP TABLE IF EXISTS `rfid_cards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rfid_cards` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int DEFAULT NULL, `rfid_card_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL, `uuid` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `read_on` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `mac_address` varchar(355) COLLATE utf8mb4_general_ci DEFAULT NULL, `signal_strength_rssi` decimal(3,2) DEFAULT NULL, `battery_level_percentage` decimal(3,2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `rfid_card_cus_id_fk` (`customer_id`), CONSTRAINT `rfid_card_cus_id_fk` FOREIGN KEY (`customer_id`) REFERENCES `branch` (`branch_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rfid_cards` -- LOCK TABLES `rfid_cards` WRITE; /*!40000 ALTER TABLE `rfid_cards` DISABLE KEYS */; /*!40000 ALTER TABLE `rfid_cards` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_permissions` ( `role_permissions_id` int NOT NULL AUTO_INCREMENT, `role_id` int DEFAULT NULL, `crm_menu_id` int DEFAULT NULL, `menu_group_id` int DEFAULT NULL, PRIMARY KEY (`role_permissions_id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` 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); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int NOT NULL AUTO_INCREMENT, `role_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint(1) DEFAULT '1', `created_on` datetime DEFAULT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` 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); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `school_layout` -- DROP TABLE IF EXISTS `school_layout`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `school_layout` ( `layout_id` int NOT NULL AUTO_INCREMENT, `customer_id` int DEFAULT NULL, `layout_data` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_on` datetime NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `updated_on` datetime NOT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`layout_id`), KEY `school_layout_cus_id_fk` (`customer_id`), CONSTRAINT `school_layout_cus_id_fk` FOREIGN KEY (`customer_id`) REFERENCES `branch` (`branch_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `school_layout` -- LOCK TABLES `school_layout` WRITE; /*!40000 ALTER TABLE `school_layout` DISABLE KEYS */; /*!40000 ALTER TABLE `school_layout` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `setup_fee` -- DROP TABLE IF EXISTS `setup_fee`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `setup_fee` ( `setup_fee_id` int NOT NULL AUTO_INCREMENT, `setup_fee` decimal(20,2) DEFAULT NULL, `is_all_package` int DEFAULT NULL, `status` int 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, PRIMARY KEY (`setup_fee_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `setup_fee` -- LOCK TABLES `setup_fee` WRITE; /*!40000 ALTER TABLE `setup_fee` DISABLE KEYS */; INSERT INTO `setup_fee` 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'); /*!40000 ALTER TABLE `setup_fee` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `setup_package` -- DROP TABLE IF EXISTS `setup_package`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `setup_package` ( `setup_package_id` int NOT NULL AUTO_INCREMENT, `setup_fee_id` int DEFAULT NULL, `package_id` int DEFAULT NULL, `status` int 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, PRIMARY KEY (`setup_package_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `setup_package` -- LOCK TABLES `setup_package` WRITE; /*!40000 ALTER TABLE `setup_package` DISABLE KEYS */; INSERT INTO `setup_package` 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'); /*!40000 ALTER TABLE `setup_package` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `state` -- DROP TABLE IF EXISTS `state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `state` ( `state_id` int NOT NULL AUTO_INCREMENT, `country_id` int DEFAULT NULL, `state_name` varchar(1500) DEFAULT NULL, `state_code` varchar(50) DEFAULT NULL, PRIMARY KEY (`state_id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `state` -- LOCK TABLES `state` WRITE; /*!40000 ALTER TABLE `state` DISABLE KEYS */; INSERT INTO `state` 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'); /*!40000 ALTER TABLE `state` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax` -- DROP TABLE IF EXISTS `tax`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tax` ( `tax_id` int NOT NULL AUTO_INCREMENT, `tax_percentage` decimal(20,2) NOT NULL, `created_on` datetime NOT NULL, `created_by` varchar(255) NOT NULL, PRIMARY KEY (`tax_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tax` -- LOCK TABLES `tax` WRITE; /*!40000 ALTER TABLE `tax` DISABLE KEYS */; INSERT INTO `tax` VALUES (1,18.00,'2020-10-20 16:46:46','0'); /*!40000 ALTER TABLE `tax` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenants` -- DROP TABLE IF EXISTS `tenants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tenants` ( `id` varchar(255) NOT NULL, `data` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenants` -- LOCK TABLES `tenants` WRITE; /*!40000 ALTER TABLE `tenants` DISABLE KEYS */; INSERT INTO `tenants` 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\"}'); /*!40000 ALTER TABLE `tenants` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary view structure for view `transaction` -- DROP TABLE IF EXISTS `transaction`; /*!50001 DROP VIEW IF EXISTS `transaction`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `transaction` AS SELECT 1 AS `account_configuration_id`, 1 AS `package_history_id`, 1 AS `customer_id`, 1 AS `branch_id`, 1 AS `no_of_student_from`, 1 AS `no_of_student_to`, 1 AS `duration`, 1 AS `package_id`, 1 AS `city`, 1 AS `city_id`, 1 AS `school_name`, 1 AS `total_amount`, 1 AS `paid_amount`, 1 AS `balance_amount`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `role_id` int DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL, `name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL, `last_login` datetime DEFAULT NULL, `date_created` datetime DEFAULT NULL, `active` tinyint(1) DEFAULT '1', `remember_time` text COLLATE utf8mb4_general_ci, `remember_expire` text COLLATE utf8mb4_general_ci, `verification_code` text COLLATE utf8mb4_general_ci, `ip_address` text COLLATE utf8mb4_general_ci, `new_pass_key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `new_pass_key_requested` datetime DEFAULT NULL, `last_password_change` datetime DEFAULT NULL, `date_updated` datetime DEFAULT NULL, `email_verification` tinyint DEFAULT NULL, `mobile_no` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `api_token` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_on` datetime NOT NULL, `created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `updated_on` datetime DEFAULT NULL, `updated_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `logged_in_date` datetime DEFAULT NULL, `logged_ip_address` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL, `firebase_token` text COLLATE utf8mb4_general_ci, PRIMARY KEY (`id`), KEY `users_role_id_fk` (`role_id`), CONSTRAINT `users_role_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (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','25d55ad283aa400af464c76d713c07ad','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); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Final view structure for view `transaction` -- /*!50001 DROP VIEW IF EXISTS `transaction`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`u849362929_productuser`@`127.0.0.1` SQL SECURITY DEFINER */ /*!50001 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) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-11-25 6:51:20
cải xoăn