404Forbiden

✏️ Editing: dbdump.sql

-- MySQL dump 10.13  Distrib 5.7.40, for Linux (x86_64)
--
-- Host: mysql.dev.artoonsolutions.com    Database: pricing_quoting_engine_cpq
-- ------------------------------------------------------
-- Server version	8.0.28-0ubuntu0.20.04.3

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 `admin_login`
--

DROP TABLE IF EXISTS `admin_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_login` (
  `admin_id` int NOT NULL AUTO_INCREMENT,
  `role_id` int DEFAULT '2' COMMENT '1-Admin, 2-User',
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `email_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `profile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `token` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_auth`
--

DROP TABLE IF EXISTS `api_auth`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_auth` (
  `id` int NOT NULL AUTO_INCREMENT,
  `auth_key` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `arena_pricebook`
--

DROP TABLE IF EXISTS `arena_pricebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arena_pricebook` (
  `id` int NOT NULL AUTO_INCREMENT,
  `emp_count_from` int NOT NULL,
  `emp_count_to` int NOT NULL,
  `pricebook_id` int NOT NULL,
  `price` double(10,2) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7917 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bounce_email_logs`
--

DROP TABLE IF EXISTS `bounce_email_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bounce_email_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(200) DEFAULT NULL,
  `message` longtext,
  `response` longtext,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cs_entites`
--

DROP TABLE IF EXISTS `cs_entites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cs_entites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cpq_name` varchar(20) NOT NULL,
  `leaga_name` varchar(255) NOT NULL,
  `address_1` text NOT NULL,
  `address_2` text NOT NULL,
  `address_3` text NOT NULL,
  `phone` varchar(30) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `discount`
--

DROP TABLE IF EXISTS `discount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `discount_base_on_pro_plan` int NOT NULL,
  `discount_for_tt` int NOT NULL,
  `type` enum('total_teams','arena') NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `end_discount`
--

DROP TABLE IF EXISTS `end_discount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `end_discount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `discount` float NOT NULL,
  `type` enum('total_teams','arena') NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `function_section`
--

DROP TABLE IF EXISTS `function_section`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `function_section` (
  `id` int NOT NULL AUTO_INCREMENT,
  `item` varchar(255) NOT NULL,
  `cpq_title` varchar(255) NOT NULL,
  `cpq_description` text NOT NULL,
  `proposal_title` varchar(255) NOT NULL,
  `proposal_description` text NOT NULL,
  `visible` varchar(10) NOT NULL COMMENT '1-Admin,2 - Sales Executive, 3- Direct Sales, 4- Partners',
  `driver` float NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mail_template`
--

DROP TABLE IF EXISTS `mail_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mail_template` (
  `mail_id` int NOT NULL AUTO_INCREMENT,
  `template` varchar(50) NOT NULL,
  `mail_subject` varchar(250) NOT NULL,
  `template_content` longtext NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_del` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`mail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `multi_year_discount`
--

DROP TABLE IF EXISTS `multi_year_discount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multi_year_discount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` varchar(100) NOT NULL,
  `discount` float NOT NULL,
  `discount_name` varchar(200) DEFAULT NULL,
  `type_id` int NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `flag` int NOT NULL DEFAULT '0' COMMENT '''0'' => display, ''1''=> not display',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `multifunction_discount`
--

DROP TABLE IF EXISTS `multifunction_discount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `multifunction_discount` (
  `id` int NOT NULL AUTO_INCREMENT,
  `multi_fun_key` int NOT NULL,
  `discount` float NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `offers_pricebook`
--

DROP TABLE IF EXISTS `offers_pricebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offers_pricebook` (
  `id` int NOT NULL AUTO_INCREMENT,
  `offers_id` int NOT NULL,
  `pricebook_id` int NOT NULL,
  `price` double(10,2) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=638 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pilot_plan_pricebook`
--

DROP TABLE IF EXISTS `pilot_plan_pricebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pilot_plan_pricebook` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pilot_plan_id` int NOT NULL,
  `pricebook_id` int NOT NULL,
  `price` double(10,2) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `proposal_total_teams`
--

DROP TABLE IF EXISTS `proposal_total_teams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `proposal_total_teams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `proposal_id` bigint NOT NULL DEFAULT '0' COMMENT 'randomly generted value',
  `created_by` int NOT NULL DEFAULT '0',
  `sales_rep_id` int NOT NULL,
  `partner_id` int NOT NULL DEFAULT '0',
  `quote_name` varchar(250) NOT NULL,
  `organization_name` varchar(100) NOT NULL,
  `organization_website` varchar(100) NOT NULL,
  `total_employee` int NOT NULL DEFAULT '0',
  `employee_year_1` int NOT NULL DEFAULT '0',
  `employee_year_2` int NOT NULL DEFAULT '0',
  `employee_year_3` int NOT NULL DEFAULT '0',
  `employee_size_yearly` longtext,
  `c_id` int NOT NULL DEFAULT '0',
  `firstname` varchar(30) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `expiration_date` date NOT NULL,
  `plan_id` int NOT NULL DEFAULT '0',
  `pilot_plan` longtext,
  `conversion_options` longtext,
  `pilot_plan_modification` longtext,
  `multi_year_id` int NOT NULL DEFAULT '0' COMMENT 'reference table multi_year_discount',
  `year_duration` tinyint NOT NULL DEFAULT '1',
  `annual_cost` double(10,2) NOT NULL DEFAULT '0.00' COMMENT 'reference table total_teams_annual_cost',
  `annual_cost_1` double(10,2) NOT NULL DEFAULT '0.00',
  `annual_cost_2` double(10,2) NOT NULL DEFAULT '0.00',
  `annual_cost_3` double(10,2) NOT NULL DEFAULT '0.00',
  `sub_total_annual_plan` double(10,2) NOT NULL DEFAULT '0.00',
  `multi_year_discount_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `multi_year_discount_rate` int NOT NULL DEFAULT '0',
  `auto_renew` tinyint NOT NULL DEFAULT '1' COMMENT 'if value is 1 then auto renew is enable for 1 year\r\nif value is 0 then auto renew is disable for 1 year\r\n\r\nthis plan is use only for 1 year duration',
  `configuration_total_subcription` double(10,2) NOT NULL DEFAULT '0.00' COMMENT 'total of configuration box',
  `total_value` double(10,2) NOT NULL DEFAULT '0.00' COMMENT 'sum of all box final total',
  `total_discount_applied` double(10,2) NOT NULL DEFAULT '0.00' COMMENT 'sum of all box discount',
  `net_proposal` double(10,2) NOT NULL DEFAULT '0.00',
  `additional_function` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '$array=[					"total_function_count"=>2,					"multifunction_discount_percentage"=>20,						"multifunction_discount_amount"=>5580,					"additional_function_total"=>27900,					"net_additional_function"=>22320,					"additional_function_data"=>[						[							"refFunction_section_id"=>2,							"driver"=>20,							"amount"=>18000						],						[							"refFunction_section_id"=>3,							"driver"=>11,							"amount"=>9900						]					]				];',
  `printed_materials` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '{"p_paper_learner_guide_pack":30,\r\n			"p_paper_learner_guide_pack_check":1,\r\n			"p_paper_learner_guide_pack_amount":5580,\r\n			"p_paper_learner_guide_pack_year_1_qty":10,\r\n			"p_paper_learner_guide_pack_year_2_qty":10,\r\n			"p_paper_learner_guide_pack_year_3_qty":10,\r\n			"p_SDI_2_book":25,	\r\n			"p_SDI_2_book_check":1,\r\n			"p_SDI_2_book_amount":5580,\r\n			"p_SDI_2_book_year_1_qty":10,\r\n			"p_SDI_2_book_year_2_qty":10,\r\n			"p_SDI_2_book_year_3_qty":10						\r\n			}',
  `facilitator_certification` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 'facilitator_certification (json)\r\n{		\r\n	Sub_total_certification\r\n 	 facilitator_total_discount_rate\r\n	facilitator_total_discount_amount\r\n{\r\nfacilitator_id (int)			\r\n			year_1_quantity\r\n			year_2_quantity\r\n			facilitator_certification_amount\r\ntotal_amount \r\n}……repeat based on input\r\n}\r\n',
  `training_delievery` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 'training_delievery (json)\r\n{		\r\n	Sub_total_training_delievery\r\n{\r\ntraining_delievery _id (int)			\r\n			year_1_quantity\r\n			year_2_quantity\r\n			training_delievery_amount\r\ntotal_amount \r\n}……repeat based on input\r\n}\r\n',
  `reimburshable` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 'reimburshable (json)\r\n{		\r\n	Sub_total_ reimburshable\r\n{\r\nreimburshable _id (int)			\r\n			year_1_quantity\r\n			year_2_quantity\r\n			reimburshable _amount\r\ntotal_amount \r\n}……repeat based on input\r\n}\r\n',
  `shipping_charge` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `flag` tinyint NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `additional_discount` double(10,2) NOT NULL DEFAULT '0.00',
  `convenience_fee` double(10,2) NOT NULL,
  `payment_preference` tinyint NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `step` tinyint(1) NOT NULL DEFAULT '1',
  `is_del` tinyint NOT NULL DEFAULT '0',
  `tax_rate` double(10,2) NOT NULL DEFAULT '0.00',
  `tax_name` varchar(30) DEFAULT NULL,
  `apply_tax` tinyint NOT NULL DEFAULT '0',
  `plan_type` tinyint NOT NULL DEFAULT '0',
  `proposal_type` tinyint NOT NULL DEFAULT '0' COMMENT '1 for Plan Modification, 2 for product and services, 0 for none',
  `mod_order_no` varchar(30) NOT NULL DEFAULT '0',
  `pre_paid_current_plan` varchar(30) NOT NULL DEFAULT '0',
  `existing_plan_start_date` date NOT NULL,
  `existing_plan_end_date` date NOT NULL,
  `existing_plan_id` varchar(20) NOT NULL,
  `plan_term` tinyint NOT NULL DEFAULT '0' COMMENT 'use for maintain current plan term on second step (flag)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=363 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_arena_conf`
--

DROP TABLE IF EXISTS `tbl_arena_conf`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_arena_conf` (
  `offers_id` int NOT NULL AUTO_INCREMENT,
  `cpq_title` text NOT NULL,
  `cpq_description` longtext NOT NULL,
  `proposal_title` varchar(255) NOT NULL,
  `proposal_description` longtext NOT NULL,
  `discounts_on` longtext NOT NULL,
  `small_size_partner` int NOT NULL DEFAULT '0',
  `large_size_partner` int NOT NULL DEFAULT '0',
  `small_size_direct_sales` int NOT NULL DEFAULT '0',
  `small_size_over` int NOT NULL DEFAULT '0',
  `medium_size_over` int NOT NULL DEFAULT '0',
  `large_size_over` int NOT NULL DEFAULT '0',
  `small_plan_allowable_increment` int NOT NULL DEFAULT '0',
  `medium_plan_allowable_increment` int NOT NULL DEFAULT '0',
  `large_plan_allowable_increment` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`offers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_countries`
--

DROP TABLE IF EXISTS `tbl_countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_countries` (
  `country_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `country_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pricebook_id` int NOT NULL,
  `currency_symbol_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `top_of_list` tinyint NOT NULL DEFAULT '0',
  `not_listed` tinyint NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_currency`
--

DROP TABLE IF EXISTS `tbl_currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_currency` (
  `c_id` int NOT NULL AUTO_INCREMENT,
  `c_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `c_symbol` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `c_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_logs`
--

DROP TABLE IF EXISTS `tbl_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `operation` enum('add','edit','delete') NOT NULL,
  `user_id` int NOT NULL,
  `section` varchar(250) NOT NULL,
  `msg` text,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_offers`
--

DROP TABLE IF EXISTS `tbl_offers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_offers` (
  `offers_id` int NOT NULL AUTO_INCREMENT,
  `offers_category_id` int NOT NULL,
  `item` varchar(255) NOT NULL,
  `cpq_title` text NOT NULL,
  `cpq_description` longtext NOT NULL,
  `proposal_title` varchar(255) NOT NULL,
  `proposal_description` longtext NOT NULL,
  `sold_by` enum('Attendee','Day','Hour','Session','Unit') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `visible` varchar(20) NOT NULL,
  `depend_on` varchar(20) NOT NULL,
  `override_by` varchar(50) NOT NULL,
  `is_depend` tinyint NOT NULL DEFAULT '0',
  `warning` varchar(255) NOT NULL,
  `pilot_credit_type` tinyint NOT NULL DEFAULT '0' COMMENT '1 for assesments, 2 for training,0 for none or default	',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`offers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_offers_category`
--

DROP TABLE IF EXISTS `tbl_offers_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_offers_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` varchar(50) NOT NULL,
  `display_title` text NOT NULL,
  `plan_type_id` varchar(10) NOT NULL COMMENT 'comma separated plan id for discount',
  `is_depend` tinyint NOT NULL DEFAULT '0',
  `list_in` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_pilot_plan`
--

DROP TABLE IF EXISTS `tbl_pilot_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_pilot_plan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `p_name` varchar(250) NOT NULL,
  `item` varchar(250) NOT NULL,
  `cpq_title` varchar(250) NOT NULL,
  `cpq_description` text NOT NULL,
  `proposal_title` varchar(250) NOT NULL,
  `proposal_description` text NOT NULL,
  `assessment_credits` int NOT NULL,
  `training_credits` int NOT NULL,
  `certification` int NOT NULL,
  `member_limit` int NOT NULL,
  `visible` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '1-Admin,2 - Sales Executive, 3- Direct Sales, 4- Partners',
  `discounts_on` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_plan`
--

DROP TABLE IF EXISTS `tbl_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_plan` (
  `p_id` int NOT NULL AUTO_INCREMENT,
  `p_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `p_discount_on_addon_credits_and_certs` int NOT NULL COMMENT '%',
  `p_assessment_credits` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `p_training_credits` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `p_maximum_members` int DEFAULT NULL,
  `p_facilitator_certifications` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `p_annual_cost` int NOT NULL,
  `p_per_member_cost` int NOT NULL,
  `p_additional_assessment_credits` int NOT NULL,
  `p_additional_training_credits` int NOT NULL,
  `p_additional_learner_toolkits` int NOT NULL,
  `p_open_enrollment_cert` int NOT NULL,
  `p_in_house_cert_per_day` int NOT NULL,
  `p_facilitator_toolkit` int NOT NULL,
  `p_virtual_delivery` int NOT NULL COMMENT 'Virtual Delivery (1-4 hours)',
  `p_in_person_delivery` int NOT NULL,
  `p_coaching_delivery` int NOT NULL,
  `p_paper_learner_guide_pack` int NOT NULL,
  `p_region` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `p_primary` int NOT NULL DEFAULT '0',
  `flag` int NOT NULL DEFAULT '0',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `c_id` int NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_plan_form`
--

DROP TABLE IF EXISTS `tbl_plan_form`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_plan_form` (
  `f_id` int NOT NULL AUTO_INCREMENT,
  `u_id` int DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `region` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `population_size` int NOT NULL,
  `new_learners` int NOT NULL,
  `certifications` int NOT NULL,
  `inhouse_cert` int NOT NULL,
  `facilitator_toolkit` int NOT NULL,
  `virtual_delivery` int NOT NULL,
  `inperson_delivery` int NOT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_plan_form_details`
--

DROP TABLE IF EXISTS `tbl_plan_form_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_plan_form_details` (
  `fd_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `f_id` int DEFAULT NULL,
  `u_id` int DEFAULT NULL,
  `price` int DEFAULT NULL,
  `max_members` int DEFAULT NULL,
  `new_learners_included` int DEFAULT NULL,
  `certifications_included` int DEFAULT NULL,
  `additional_learners` int DEFAULT NULL,
  `price_per_learner` int DEFAULT NULL,
  `total_for_additional_learners` int DEFAULT NULL,
  `add_on_sdi_credits` int DEFAULT NULL,
  `add_on_sdi_price_per_credit` int DEFAULT NULL,
  `add_on_sdi_total_for_additional_credits` int DEFAULT NULL,
  `add_on_training_credits` int DEFAULT NULL,
  `add_on_training_price_per_credit` int DEFAULT NULL,
  `add_on_training_total_for_additional_credits` int DEFAULT NULL,
  `add_on_certifications` int DEFAULT NULL,
  `price_per_oe_cert` int DEFAULT NULL,
  `total_for_additional_credits_oe_certs` int DEFAULT NULL,
  `plan_based_subscription` int DEFAULT NULL,
  `plan_based_additional_learners` int DEFAULT NULL,
  `plan_based_add_on_sdi_total_for_additional_credits` int DEFAULT NULL,
  `plan_based_additional_csr_credits` int DEFAULT NULL,
  `plan_based_additional_certifications` int DEFAULT NULL,
  `plan_based_total` int DEFAULT NULL,
  `in_house_cert` int DEFAULT NULL,
  `facilitator_toolkit` int DEFAULT NULL,
  `additional_costs_total` int DEFAULT NULL,
  `total_financial_commitment` int DEFAULT NULL,
  `current_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`fd_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_plan_type`
--

DROP TABLE IF EXISTS `tbl_plan_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_plan_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `plan_name` varchar(250) NOT NULL,
  `cpq_title` varchar(255) NOT NULL,
  `cpq_desc` longtext NOT NULL,
  `proposal_title` varchar(255) NOT NULL,
  `proposal_desc` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_pricebook`
--

DROP TABLE IF EXISTS `tbl_pricebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_pricebook` (
  `pricebook_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `currency_symbol` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `currency_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `convenience_fee` double(10,2) NOT NULL DEFAULT '0.00',
  `ref_entity_id` int NOT NULL,
  `tax_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `tax_rate` double(10,2) NOT NULL DEFAULT '0.00',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pricebook_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_proposal`
--

DROP TABLE IF EXISTS `tbl_proposal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_proposal` (
  `id` int NOT NULL AUTO_INCREMENT,
  `proposal_id` bigint NOT NULL,
  `organization` varchar(255) NOT NULL,
  `proposal_name` varchar(100) NOT NULL,
  `ac_number` varchar(255) NOT NULL,
  `plan_id` int NOT NULL,
  `plan_name` varchar(255) DEFAULT NULL,
  `plan_year` int NOT NULL,
  `u_id` int DEFAULT NULL,
  `price` int DEFAULT NULL,
  `region` varchar(255) NOT NULL,
  `c_id` int NOT NULL,
  `max_members` varchar(100) DEFAULT NULL,
  `certifications_included` varchar(100) DEFAULT NULL,
  `additional_learners` int DEFAULT NULL,
  `price_per_learner` int DEFAULT NULL,
  `total_for_additional_learners` int DEFAULT NULL,
  `add_on_sdi_credits` int DEFAULT NULL,
  `add_on_sdi_price_per_credit` int DEFAULT NULL,
  `add_on_sdi_total_for_additional_credits` int DEFAULT NULL,
  `add_on_training_credits` int DEFAULT NULL,
  `add_on_training_price_per_credit` int DEFAULT NULL,
  `add_on_training_total_for_additional_credits` int DEFAULT NULL,
  `add_on_certifications` int DEFAULT NULL,
  `price_per_oe_cert` int DEFAULT NULL,
  `total_for_additional_credits_oe_certs` int DEFAULT NULL,
  `add_on_learners_toolkit` int NOT NULL,
  `price_per_learners_toolkit` int NOT NULL,
  `total_for_additional_learners_toolkit` int NOT NULL,
  `add_on_paper_learner_guide_pack` int NOT NULL,
  `price_per_paper_learner_guide_pack` int NOT NULL,
  `total_for_paper_learner_guide_pack` int NOT NULL,
  `plan_based_subscription` int DEFAULT NULL,
  `plan_based_additional_learners` int DEFAULT NULL,
  `plan_based_add_on_sdi_total_for_additional_credits` int DEFAULT NULL,
  `plan_based_additional_csr_credits` int DEFAULT NULL,
  `plan_based_additional_certifications` int DEFAULT NULL,
  `plan_based_total` int DEFAULT NULL,
  `plan_based_additional_learners_toolkit` int NOT NULL,
  `add_on_in_house_cert` int NOT NULL,
  `price_per_in_house_cert` int NOT NULL,
  `total_in_house_cert` int DEFAULT NULL,
  `price_per_facilitator_toolkit` int NOT NULL,
  `total_facilitator_toolkit` int NOT NULL,
  `add_on_facilitator_toolkit` int DEFAULT NULL,
  `price_per_virtual_delivery` int NOT NULL,
  `total_virtual_delivery` int NOT NULL,
  `add_on_virtual_delivery` int NOT NULL,
  `price_per_in_person` int NOT NULL,
  `total_in_person` int NOT NULL,
  `add_on_in_person` int NOT NULL,
  `add_on_coaching_delivery` int NOT NULL,
  `price_per_coaching_delivery` int NOT NULL,
  `total_coaching_delivery` int NOT NULL,
  `additional_costs_total` int DEFAULT NULL,
  `total_financial_commitment` int DEFAULT NULL,
  `training_virtual_session_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `training_virtual_session` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_training_virtual_session` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `training_inperson_day_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `training_inperson_day` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_training_inperson_day` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `coaching_session_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `coaching_session` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_coaching_session` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `coaching_person_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `coaching_person` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_coaching_person` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `consulting_hours_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `consulting_hours` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_consulting_hours` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `consulting_project_price` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `consulting_project` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `total_consulting_project` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `partner_sub_tot` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `expenses` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `partner_final_total` int NOT NULL DEFAULT '0' COMMENT 'partner field	',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=918 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_ratio`
--

DROP TABLE IF EXISTS `tbl_ratio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_ratio` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_at` varchar(10) NOT NULL,
  `certifications_at` varchar(10) NOT NULL,
  `default_ratio` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_settings`
--

DROP TABLE IF EXISTS `tbl_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `output_label` varchar(255) NOT NULL,
  `output_description` text NOT NULL,
  `flag` enum('s','p') NOT NULL DEFAULT 's' COMMENT 'S=>subscription, P=>Partner	',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbl_total_teams_conf`
--

DROP TABLE IF EXISTS `tbl_total_teams_conf`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_total_teams_conf` (
  `offers_id` int NOT NULL AUTO_INCREMENT,
  `cpq_title` text NOT NULL,
  `cpq_description` longtext NOT NULL,
  `proposal_title` varchar(255) NOT NULL,
  `proposal_description` longtext NOT NULL,
  `discounts_on` longtext NOT NULL,
  `large_size_partner` int NOT NULL DEFAULT '0',
  `small_size_direct_sales` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`offers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `text_settings`
--

DROP TABLE IF EXISTS `text_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `text_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` enum('header','descriptive_text','template') NOT NULL,
  `item` varchar(200) DEFAULT NULL,
  `cpq_title` text,
  `proposal_description` text,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_del` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `total_teams_annual_cost`
--

DROP TABLE IF EXISTS `total_teams_annual_cost`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `total_teams_annual_cost` (
  `id` int NOT NULL AUTO_INCREMENT,
  `member_limit_from` int NOT NULL,
  `member_limit_to` int NOT NULL,
  `c_id` int NOT NULL,
  `annual_cost` int NOT NULL,
  `is_del` int NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `total_teams_arena_plan`
--

DROP TABLE IF EXISTS `total_teams_arena_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `total_teams_arena_plan` (
  `p_id` int NOT NULL AUTO_INCREMENT,
  `c_id` int NOT NULL,
  `p_paper_learner_guide_pack` double(10,2) NOT NULL,
  `p_SDI_2_book` double(10,2) NOT NULL,
  `p_open_enrollment_stand` int NOT NULL,
  `p_virtual_in_house_cert_stand` int NOT NULL,
  `p_in_house_cert_stand` int NOT NULL,
  `p_facilitator_toolkit_stand` int NOT NULL,
  `p_virtual_delivery` int NOT NULL,
  `p_in_person_delivery` int NOT NULL,
  `p_reimbursable_expenses` int NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_del` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `total_teams_pricebook`
--

DROP TABLE IF EXISTS `total_teams_pricebook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `total_teams_pricebook` (
  `id` int NOT NULL AUTO_INCREMENT,
  `emp_count_from` int NOT NULL,
  `emp_count_to` int NOT NULL,
  `pricebook_id` int NOT NULL,
  `price` double(10,2) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9347 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_login`
--

DROP TABLE IF EXISTS `user_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_login` (
  `u_id` int NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email_id` varchar(255) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `profile` varchar(255) DEFAULT NULL,
  `role_id` int NOT NULL COMMENT '1-Admin, 2 - Sales Executive, 3- Direct Sales, 4- Partners, 5- Customer Success',
  `user_flag` enum('by_admin','by_web') NOT NULL DEFAULT 'by_admin',
  `created_by` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `change_password` enum('n','y') NOT NULL DEFAULT 'n',
  `temp_pwd` tinyint NOT NULL DEFAULT '0' COMMENT '0- not temporary pwd, 1- temporary pwd ',
  `partner_sales_rep` int NOT NULL DEFAULT '0',
  `partner_org_name` varchar(200) DEFAULT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_login_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=423 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_commentmeta`
--

DROP TABLE IF EXISTS `wp_commentmeta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_comments`
--

DROP TABLE IF EXISTS `wp_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_comments` (
  `comment_ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `comment_karma` int NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'comment',
  `comment_parent` bigint unsigned NOT NULL DEFAULT '0',
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_links`
--

DROP TABLE IF EXISTS `wp_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_links` (
  `link_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `link_owner` bigint unsigned NOT NULL DEFAULT '1',
  `link_rating` int NOT NULL DEFAULT '0',
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_options`
--

DROP TABLE IF EXISTS `wp_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_options` (
  `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`),
  KEY `autoload` (`autoload`)
) ENGINE=InnoDB AUTO_INCREMENT=3454 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_postmeta`
--

DROP TABLE IF EXISTS `wp_postmeta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_postmeta` (
  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_posts`
--

DROP TABLE IF EXISTS `wp_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_posts` (
  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint unsigned NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
  `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `post_parent` bigint unsigned NOT NULL DEFAULT '0',
  `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `menu_order` int NOT NULL DEFAULT '0',
  `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_count` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`(191)),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_term_relationships`
--

DROP TABLE IF EXISTS `wp_term_relationships`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_term_relationships` (
  `object_id` bigint unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',
  `term_order` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_term_taxonomy`
--

DROP TABLE IF EXISTS `wp_term_taxonomy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `parent` bigint unsigned NOT NULL DEFAULT '0',
  `count` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_termmeta`
--

DROP TABLE IF EXISTS `wp_termmeta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_termmeta` (
  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_terms`
--

DROP TABLE IF EXISTS `wp_terms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_terms` (
  `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `term_group` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_usermeta`
--

DROP TABLE IF EXISTS `wp_usermeta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wp_users`
--

DROP TABLE IF EXISTS `wp_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wp_users` (
  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_status` int NOT NULL DEFAULT '0',
  `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2023-04-27  1:27:05

Sid Gifari From Gifari Industries - BD Cyber Security Team