-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 17, 2023 at 05:11 AM
-- Server version: 5.7.36
-- PHP Version: 7.4.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `interactive_video`
--

-- --------------------------------------------------------

--
-- Table structure for table `master_language`
--

DROP TABLE IF EXISTS `master_language`;
CREATE TABLE IF NOT EXISTS `master_language` (
  `language_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `code` varchar(45) DEFAULT NULL,
  `is_active` varchar(45) DEFAULT '1',
  `added_by` varchar(45) DEFAULT NULL,
  `add_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `master_language`
--

INSERT INTO `master_language` (`language_id`, `name`, `code`, `is_active`, `added_by`, `add_date_time`, `modified_date_time`) VALUES
(1, 'English', 'EN', '1', NULL, '2023-03-09 13:59:28.282', '2023-03-09 13:59:28.282');

-- --------------------------------------------------------

--
-- Table structure for table `video`
--

DROP TABLE IF EXISTS `video`;
CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(45) NOT NULL,
  `title` varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL,
  `description` varchar(2000) CHARACTER SET utf8mb4 DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `added_by` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL,
  `add_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `default_language` int(11) DEFAULT NULL,
  `video_type` tinyint(1) DEFAULT '1' COMMENT '1 for horizontal and 2 for vertical',
  `starter_media_type` varchar(10) DEFAULT NULL,
  `starter_media_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`video_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`video_id`, `code`, `title`, `description`, `is_active`, `added_by`, `add_date_time`, `modified_date_time`, `default_language`, `video_type`, `starter_media_type`, `starter_media_id`) VALUES
(1, 'v0001', 'Auto Move Solutions', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-03-27 15:34:13.534', 1, 1, 'video', 1),
(2, 'v0002', 'DIGO - CX & Digital Omnichannel', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-22 13:22:43.917', 1, 1, 'video', 17),
(3, 'v0003', 'Auto Retail', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-09 14:03:07.398', 1, 1, 'video', 33),
(4, 'v0004', 'Digital Fabric Usecase 1', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-09 14:03:19.332', 1, 1, 'video', 48),
(5, 'v0005', 'Digital Fabric Usecase 2', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-16 15:34:12.516', 1, 1, 'video', 56),
(6, 'v0006', 'Digital Fabric Usecase 3', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-20 10:51:03.351', 1, 1, 'video', 66),
(7, 'v0007', 'Landscape - Auto Move Solutions', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-20 10:51:08.702', 1, 2, 'video', 71),
(8, 'v0008', 'Landscape - DIGO CX & Digital Omnichannel', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-22 13:22:35.774', 1, 2, 'video', 86),
(9, 'v0009', 'Landscape - Auto Retail', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-20 10:51:08.702', 1, 2, 'video', 102),
(10, 'v00010', '2-Wheeler Service', 'dummy', 1, NULL, '2023-03-09 13:31:44.897', '2023-06-22 13:11:54.582', 1, 1, 'video', 117);

-- --------------------------------------------------------

--
-- Table structure for table `video_click`
--

DROP TABLE IF EXISTS `video_click`;
CREATE TABLE IF NOT EXISTS `video_click` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `default_icon` tinyint(1) DEFAULT NULL,
  `icon` int(1) DEFAULT NULL COMMENT '1:home, 2:backward, 3:forward',
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `x_axis_end` varchar(10) DEFAULT NULL,
  `y_axis_end` varchar(10) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `onclick_action` tinyint(1) DEFAULT '1' COMMENT '1: goto video, 2: goto time, 3: goto url, 4:show image, 5:show text, 6: show text+ image',
  `action_video_id` int(11) DEFAULT NULL,
  `action_goto_time` varchar(10) DEFAULT NULL,
  `action_url` varchar(500) DEFAULT NULL,
  `action_image` varchar(45) DEFAULT NULL,
  `action_text` text,
  `ref_video_id` int(11) DEFAULT NULL,
  `open_in_pop_up` tinyint(1) DEFAULT '0',
  `action_video_loop` tinyint(1) DEFAULT '0',
  `open_in_zoom_in` tinyint(1) NOT NULL DEFAULT '0',
  `zoom_in_top_per` float NOT NULL,
  `zoom_in_left_per` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_click`
--

INSERT INTO `video_click` (`id`, `title`, `default_icon`, `icon`, `x_axis_start`, `y_axis_start`, `x_axis_end`, `y_axis_end`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `onclick_action`, `action_video_id`, `action_goto_time`, `action_url`, `action_image`, `action_text`, `ref_video_id`, `open_in_pop_up`, `action_video_loop`, `open_in_zoom_in`, `zoom_in_top_per`, `zoom_in_left_per`) VALUES
(1, 'Move - Overview video', 1, NULL, '36', '14.4', '150', '70', 1, 1, NULL, NULL, 0, 1, 16, NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 0),
(2, 'Back - Overview video', 1, NULL, '5', '92.5', '55', '55', 16, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, 1, 0, 0, 0, 0, 0),
(3, 'Security connectivity & endpoint', 1, NULL, '2', '54.3', '168', '65', 1, 1, NULL, NULL, 0, 1, 2, NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 0),
(4, 'SOTA Updates', 1, NULL, '25', '62.2', '168', '60', 1, 1, '', '', 0, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 0),
(5, 'Intelligent Connectivity', 1, NULL, '54', '55.6', '168', '60', 1, 1, NULL, NULL, 0, 1, 11, NULL, NULL, '', NULL, 1, 0, 0, 0, 0, 0),
(6, 'End-point Security', 1, NULL, '24', '53.5', '126', '56', 2, 1, '', '', 0, 1, 3, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 26, 13),
(7, 'Data Privacy and Regulations', 1, NULL, '42.5', '59', '126', '56', 2, 1, NULL, NULL, 0, 1, 4, NULL, NULL, '', NULL, 1, 0, 0, 1, 24, 12),
(8, 'Secure data, Secure network', 1, NULL, '68.8', '75', '126', '56', 2, 1, NULL, NULL, 0, 1, 5, NULL, NULL, '', NULL, 1, 0, 0, 1, 33, 23),
(9, 'Back - Security', 1, NULL, '5', '92.5', '55', '55', 2, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, 1, 0, 0, 0, 0, 0),
(10, 'Ensuring SOTA success', 1, NULL, '19.6', '41', '126', '56', 6, 1, NULL, NULL, 0, 1, 7, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 7, 18),
(11, 'Move Renewal Assure', 1, NULL, '37.6', '46.6', '165', '56', 6, 1, NULL, NULL, 0, 1, 9, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 7, 18),
(12, 'Secure updates', 1, NULL, '40.4', '59', '126', '56', 6, 1, NULL, NULL, 0, 1, 10, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 6, 19),
(13, 'Back - SOTA', 1, NULL, '5', '92.5', '55', '55', 6, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, 1, 0, 0, 0, 0, 0),
(14, 'eSIM hub', 1, NULL, '37', '45', '126', '56', 11, 1, NULL, NULL, 0, 1, 12, NULL, NULL, '', NULL, 1, 0, 0, 1, 19.4, 20.3),
(15, 'Single pane of glass', 1, NULL, '54', '50.6', '126', '56', 11, 1, NULL, NULL, 0, 1, 13, NULL, NULL, '', NULL, 1, 0, 0, 1, 19.4, 20.3),
(16, 'Bring your own agreement', 1, NULL, '25', '55.6', '126', '56', 11, 1, NULL, NULL, 0, 1, 14, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 19.4, 20.3),
(17, 'Uniterrupted connectivity', 1, NULL, '7.6', '68', '126', '56', 11, 1, NULL, NULL, 0, 1, 15, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 25.6, 3.6),
(18, 'Back - Intelligent connectivity', 1, NULL, '5', '92.5', '55', '55', 11, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, 1, 0, 0, 0, 0, 0),
(19, 'Enhance Car Service', 1, NULL, '5', '22', '250', '195', 17, 1, NULL, NULL, 0, 1, 18, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(20, 'Enhance Pre-purchase experience', 1, NULL, '5', '56', '275', '195', 17, 1, NULL, NULL, 0, 1, 26, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(21, 'U1 - Automatic home', 1, NULL, '5', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(22, 'U1 - Automatic here backward', 1, NULL, '74', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(23, 'U1 - Automatic here forward', 1, NULL, '85', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 19, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(24, 'U1 - IVR call', 1, NULL, '10.5', '74', '215', '140', 19, 0, '2.2', '2.7', 1, 2, NULL, '3', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(25, 'U1 - IVR call home', 1, NULL, '5', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(26, 'U1 - IVR call backward', 1, NULL, '74', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 18, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(27, 'U1 - IVR call forward', 1, NULL, '85', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 20, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(28, 'U1 -Schedule now', 1, NULL, '18.5', '49', '250', '125', 20, 0, '3.5', '4', 1, 2, NULL, '4.7', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(29, 'U1 - Schedule now home', 1, NULL, '5', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(30, 'U1 - Schedule now backward', 1, NULL, '74', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 19, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(31, 'U1 - Schedule now forward', 1, NULL, '85', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 21, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(32, 'U1 - Dent repair', 1, NULL, '17.5', '50.9', '235', '140', 21, 0, '5.2', '5.7', 1, 2, NULL, '6.2', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(35, 'U1 - Dent repair home', 1, NULL, '5', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(36, 'U1 - Dent repair backward', 1, NULL, '74', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 20, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(37, 'U1 - Dent repair forward', 1, NULL, '85', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 22, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(38, 'U1 - Join video chat', 1, NULL, '9.5', '68', '235', '140', 22, 0, '14.7', '15', 1, 1, 23, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(39, 'U1 - Join video chat home', 1, NULL, '5', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(40, 'U1 - Join video chat backward', 1, NULL, '74', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 21, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(41, 'U1 - Join video chat forward', 1, NULL, '85', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 23, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(42, 'U1 - video call home', 1, NULL, '5', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(43, 'U1 - video call backward', 1, NULL, '74', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 22, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(44, 'U1 - video call forward', 1, NULL, '85', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 24, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(45, 'U1 - ETA home', 1, NULL, '5', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(46, 'U1 - ETA backward', 1, NULL, '74', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 23, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(47, 'U1 - ETA forward', 1, NULL, '85', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 25, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(48, 'U1 - Explore more use cases', 1, NULL, '6', '19', '180', '75', 25, 1, NULL, NULL, 0, 1, 17, '', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(49, 'U1 - Explore more home', 1, NULL, '5', '92.5', '55', '55', 25, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(50, 'U1 - Explore more backward', 1, NULL, '85', '92.5', '55', '55', 25, 1, NULL, NULL, NULL, 1, 24, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(51, 'U2 - find out more', 1, NULL, '12', '60', '171', '150', 26, 0, '9.5', '10', 1, 1, 27, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(52, 'U2 - find out more home', 1, NULL, '5', '92.5', '55', '55', 26, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(53, 'U2 - find out more backward', 1, NULL, '74', '92.5', '55', '55', 26, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(54, 'U2 - find out more forward', 1, NULL, '85', '92.5', '55', '55', 26, 1, NULL, NULL, 0, 1, 27, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(55, 'U2 - Car brochures', 1, NULL, '14', '55', '230', '125', 27, 0, '3.8', '4', 1, 2, NULL, '5.2', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(56, 'U2 - Car brochures home', 1, NULL, '5', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(57, 'U2 - Car brochures backward', 1, NULL, '74', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 26, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(58, 'U2 - Car brochures forward', 1, NULL, '85', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 28, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(59, 'U2 - Sendan model 1', 1, NULL, '14.7', '50', '225', '100', 28, 0, '4', '4.5', 1, 2, NULL, '5.2', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(60, 'U2 - Sendan model 1 home', 1, NULL, '5', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(61, 'U2 - Sendan model 1 backward', 1, NULL, '74', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 27, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(62, 'U2 - Sendan model 1 forward', 1, NULL, '85', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(63, 'U2 - Auto co sales rep - video call', 1, NULL, '13', '75', '230', '180', 29, 0, '2.5', '3', 1, 2, NULL, '3.5', NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(64, 'U2 - Book test drive', 1, NULL, '11.5', '70', '235', '195', 29, 0, '12.8', '13.2', 1, 1, 30, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(65, 'U2 - Auto co sales rep - video call home', 1, NULL, '5', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(66, 'U2 - Auto co sales rep - video call backward', 1, NULL, '74', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 28, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(67, 'U2 - Auto co sales rep - video call forward', 1, NULL, '85', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 30, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(68, 'U2 - Fast query home', 1, NULL, '5', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(69, 'U2 - Fast query backward', 1, NULL, '74', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(70, 'U2 - Fast query forward', 1, NULL, '85', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(71, 'U2 - Confirmation home', 1, NULL, '5', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(72, 'U2 - Confirmation backward', 1, NULL, '74', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 30, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(73, 'U2 - Confirmation forward', 1, NULL, '85', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 32, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(74, 'U2 -  Explore more use cases', 1, NULL, '6', '19', '180', '75', 32, 1, NULL, NULL, 0, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(75, 'U2 - Explore more home', 1, NULL, '5', '92.5', '55', '55', 32, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(76, 'U2 - Explore more backward', 1, NULL, '85', '92.5', '55', '55', 32, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, 2, 0, 0, 0, 0, 0),
(77, 'Retail- usecase 1', 1, NULL, '5', '24', '260', '185', 33, 1, NULL, NULL, 0, 1, 34, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(78, 'Retail- usecase 2', 1, NULL, '5', '58', '335', '185', 33, 1, NULL, NULL, 0, 1, 44, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(79, 'U1 - Shopping home', 1, NULL, '5', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(80, 'U1 - Shopping backward', 1, NULL, '74', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(81, 'U1 - Shopping forward', 1, NULL, '85', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 35, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(82, 'U1 - Cart view home', 1, NULL, '5', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(83, 'U1 - Cart view backward', 1, NULL, '74', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 34, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(84, 'U1 - Cart view forward', 1, NULL, '85', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 36, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(85, 'U1 - Message click', 1, NULL, '15', '49', '245', '180', 36, NULL, '3', '4', 1, 2, NULL, '4.5', NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(86, 'U1 - Message home', 1, NULL, '5', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(87, 'U1 - Message backward', 1, NULL, '74', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 35, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(88, 'U1 - Message forward', 1, NULL, '85', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 37, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(89, 'U1 - Add to cart click', 1, NULL, '15', '68', '245', '140', 37, NULL, '4.6', '5', 1, 1, 38, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(90, 'U1 - Add to cart home', 1, NULL, '5', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(91, 'U1 - Add to cart backward', 1, NULL, '74', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 36, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(92, 'U1 - Add to cart forward', 1, NULL, '85', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 38, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(93, 'U1 - Complete purchase click', 1, NULL, '15', '78', '245', '118', 38, NULL, '2', '3', 1, 2, NULL, '3.5', NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(94, 'U1 - Complete purchase home', 1, NULL, '5', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(95, 'U1 - Complete purchase backward', 1, NULL, '74', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 37, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(96, 'U1 - Complete purchase forward', 1, NULL, '85', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 39, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(97, 'U1 - Support experience home', 1, NULL, '5', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(98, 'U1 - Support experience backward', 1, NULL, '74', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 38, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(99, 'U1 - Support experience forward', 1, NULL, '85', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 40, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(100, 'U1 - Support experience click', 1, NULL, '15', '56', '245', '180', 39, NULL, '7.5', '8', 1, 1, 40, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(101, 'U1 - Chat with agent home', 1, NULL, '5', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(102, 'U1 - Chat with agent  backward', 1, NULL, '74', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 39, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(103, 'U1 - Chat with agent forward', 1, NULL, '85', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 41, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(104, 'U1 - Collect feedback home', 1, NULL, '5', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(105, 'U1 - Collect feedback backward', 1, NULL, '74', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 40, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(106, 'U1 - Collect feedback forward', 1, NULL, '85', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 42, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(107, 'U1 - Process request home', 1, NULL, '5', '92.5', '55', '55', 42, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(108, 'U1 - Process request backward', 1, NULL, '74', '92.5', '55', '55', 42, 1, NULL, NULL, NULL, 1, 41, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(109, 'U1 - Process request forward', 1, NULL, '85', '92.5', '55', '55', 42, 1, NULL, NULL, NULL, 1, 43, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(110, 'U1 - Explore more click', 1, NULL, '5.5', '22.5', '245', '90', 43, NULL, '5', '9', 1, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(111, 'U1 - Explore more home', 1, NULL, '5', '92.5', '55', '55', 43, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(112, 'U1 - Explore more backward', 1, NULL, '85', '92.5', '55', '55', 43, 1, NULL, NULL, NULL, 1, 42, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(113, 'U2 - Options click', 1, NULL, '25', '47', '245', '190', 44, NULL, '6.3', '7', 1, 2, NULL, '7.5', NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(114, 'U2 - Options home', 1, NULL, '5', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(115, 'U2 - Options backward', 1, NULL, '74', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(116, 'U2 - Options forward', 1, NULL, '85', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 45, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(117, 'U2 - Initiate video call click', 1, NULL, '18', '67', '245', '190', 44, NULL, '13.5', '14', 1, 1, 45, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(118, 'U2 - 2 way virtual basket click', 1, NULL, '18', '66', '245', '190', 45, NULL, '14.8', '16', 1, 1, 46, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(119, 'U2 - 2 way virtual basket home', 1, NULL, '5', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(120, 'U2 - 2 way virtual basket backward', 1, NULL, '74', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 44, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(121, 'U2 - 2 way virtual basket forward', 1, NULL, '85', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 46, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(122, 'U2 - Complete purchase click', 1, NULL, '18', '70', '245', '190', 46, NULL, '8.1', '8.8', 1, 2, NULL, '9', NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(123, 'U2 - Complete purchase home', 1, NULL, '5', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(124, 'U2 - Complete purchase backward', 1, NULL, '74', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 45, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(125, 'U2 - Complete purchase forward', 1, NULL, '85', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 47, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(126, 'U2 - Explore more click', 1, NULL, '5.5', '22.5', '245', '90', 47, NULL, '4.5', '9', 1, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(127, 'U2 - Explore more home', 1, NULL, '5', '92.5', '55', '55', 47, 1, NULL, NULL, NULL, 1, 33, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(128, 'U2 - Explore more backward', 1, NULL, '85', '92.5', '55', '55', 47, 1, NULL, NULL, NULL, 1, 46, NULL, NULL, '', NULL, 3, 0, 0, 0, 0, 0),
(129, 'U4 - EV charging Application click', 1, NULL, '4', '48', '500', '310', 48, NULL, '1.8', '3.5', 1, 1, 49, '', NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(130, 'U4 - Charging experience home', 1, 1, '5', '92.5', '55', '55', 49, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(131, 'U4 - Charging experience backward', 1, 2, '74', '92.5', '55', '55', 49, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(132, 'U4 - Charging experience forward', 1, 3, '85', '92.5', '55', '55', 49, 1, NULL, NULL, NULL, 1, 50, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(133, 'U4 - Get started download click', 1, NULL, '23', '50', '300', '320', 50, NULL, '1.5', '2', 1, 2, NULL, '2.5', NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(134, 'U4 - Get started open click', 1, NULL, '23', '50', '300', '320', 50, NULL, '6', '7', 1, 1, 51, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(135, 'U4 - Get started home', 1, 1, '5', '92.5', '55', '55', 50, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(136, 'U4 - Get started backward', 1, 2, '74', '92.5', '55', '55', 50, 1, NULL, NULL, NULL, 1, 49, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(137, 'U4 - Get started forward', 1, 3, '85', '92.5', '55', '55', 50, 1, NULL, NULL, NULL, 1, 51, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(138, 'U4 - Hassle-free click', 1, NULL, '5', '47', '295', '255', 51, NULL, '2.6', '3', 1, 2, NULL, '3.7', NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(139, 'U4 - Hassle-free home', 1, 1, '5', '92.5', '55', '55', 51, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(140, 'U4 - Hassle-free backward', 1, 2, '74', '92.5', '55', '55', 51, 1, NULL, NULL, NULL, 1, 50, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(141, 'U4 - Hassle-free forward', 1, 3, '85', '92.5', '55', '55', 51, 1, NULL, NULL, NULL, 1, 52, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(142, 'U4 - Notification click', 1, NULL, '4', '45', '290', '325', 52, NULL, '2.8', '3.2', 1, 1, 53, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(143, 'U4 - Notification home', 1, 1, '5', '92.5', '55', '55', 52, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(144, 'U4 - Notification backward', 1, 2, '74', '92.5', '55', '55', 52, 1, NULL, NULL, NULL, 1, 51, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(145, 'U4 - Notification forward', 1, 3, '85', '92.5', '55', '55', 52, 1, NULL, NULL, NULL, 1, 53, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(146, 'U4 - Conversational AI click', 1, NULL, '6', '43', '290', '255', 53, NULL, '2', '2.5', 1, 2, NULL, '3.6', NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(147, 'U4-3 - Conversational AI home', 1, 1, '5', '92.5', '55', '55', 53, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(148, 'U4 - Conversational AI backward', 1, 2, '74', '92.5', '55', '55', 53, 1, NULL, NULL, NULL, 1, 52, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(149, 'U4 - Conversational AI forward', 1, 3, '85', '92.5', '55', '55', 53, 1, NULL, NULL, NULL, 1, 54, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(150, 'U4 - Trigger Intelligent click', 1, NULL, '5', '42', '295', '290', 54, NULL, '1.5', '2', 1, 2, NULL, '3.4', NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(151, 'U4 - Trigger Intelligent home', 1, 1, '5', '92.5', '55', '55', 54, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(152, 'U4 - Trigger Intelligent backward', 1, 2, '74', '92.5', '55', '55', 54, 1, NULL, NULL, NULL, 1, 53, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(153, 'U4 - Trigger Intelligent forward', 1, 3, '85', '92.5', '55', '55', 54, 1, NULL, NULL, NULL, 1, 55, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(154, 'U4 - Breaker Locate staions home', 1, 1, '5', '92.5', '55', '55', 55, 1, NULL, NULL, NULL, 1, 48, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(155, 'U4 - Breaker Locate staions backward', 1, 2, '85', '92.5', '55', '55', 55, 1, NULL, NULL, NULL, 1, 54, NULL, NULL, '', NULL, 4, 0, 0, 0, 0, 0),
(156, 'U4-2 - Charging station click', 1, NULL, '5', '51', '480', '300', 56, NULL, '1.3', '2', 1, 1, 57, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(157, 'U4-2 - Scan QR click', 1, NULL, '20', '40', '330', '330', 57, NULL, '1.5', '2.5', 1, 2, NULL, '3.5', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(158, 'U4-2 - Scan QR home', 1, 1, '5', '92.5', '55', '55', 57, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(159, 'U4-2 - Scan QR backward', 1, 2, '74', '92.5', '55', '55', 57, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(160, 'U4-2 - Scan QR forward', 1, 3, '85', '92.5', '55', '55', 57, 1, NULL, NULL, NULL, 1, 58, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(161, 'U4-2 - Customer time click', 1, NULL, '5', '42', '295', '350', 58, NULL, '1.8', '2.5', 1, 2, NULL, '2.9', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(162, 'U4-2 - Customer time home', 1, 1, '5', '92.5', '55', '55', 58, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(163, 'U4-2 - Customer time backward', 1, 2, '74', '92.5', '55', '55', 58, 1, NULL, NULL, NULL, 1, 57, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(164, 'U4-2 - Customer time forward', 1, 3, '85', '92.5', '55', '55', 58, 1, NULL, NULL, NULL, 1, 59, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(165, 'U4-2 - Avail offers home', 1, 1, '5', '92.5', '55', '55', 59, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(166, 'U4-2 - Avail offers backward', 1, 2, '74', '92.5', '55', '55', 59, 1, NULL, NULL, NULL, 1, 58, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(167, 'U4-2 - Avail offers forward', 1, 3, '85', '92.5', '55', '55', 59, 1, NULL, NULL, NULL, 1, 60, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(168, 'U4-2 - Breaker wifi stations home', 1, 1, '5', '92.5', '55', '55', 60, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(169, 'U4-2 - Breaker wifi stations backward', 1, 2, '74', '92.5', '55', '55', 60, 1, NULL, NULL, NULL, 1, 59, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(170, 'U4-2 - Breaker wifi stations forward', 1, 3, '85', '92.5', '55', '55', 60, 1, NULL, NULL, NULL, 1, 61, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(171, 'U4-2 - XOTA click', 1, NULL, '5', '40', '480', '275', 61, NULL, '3.8', '4', 1, 2, NULL, '5', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(172, 'U4-2 - XOTA home', 1, 1, '5', '92.5', '55', '55', 61, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(173, 'U4-2 - XOTA backward', 1, 2, '74', '92.5', '55', '55', 61, 1, NULL, NULL, NULL, 1, 60, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(174, 'U4-2 - XOTA forward', 1, 3, '85', '92.5', '55', '55', 61, 1, NULL, NULL, NULL, 1, 62, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(175, 'U4-2 - Breaker Charging home', 1, 1, '5', '92.5', '55', '55', 62, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(176, 'U4-2 - Breaker Charging backward', 1, 2, '74', '92.5', '55', '55', 62, 1, NULL, NULL, NULL, 1, 61, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(177, 'U4-2 - Breaker Charging forward', 1, 3, '85', '92.5', '55', '55', 62, 1, NULL, NULL, NULL, 1, 63, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(178, 'U4-2 - In-App payment click', 1, NULL, '5', '61', '295', '295', 63, NULL, '1.4', '2', 1, 2, NULL, '2.8', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(179, 'U4-2 - In-App payment pay click', 1, NULL, '5', '60', '295', '300', 63, NULL, '8.5', '9', 1, 2, NULL, '9.6', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(180, 'U4-2 - In-App payment home', 1, 1, '5', '92.5', '55', '55', 63, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(181, 'U4-2 - In-App payment backward', 1, 2, '74', '92.5', '55', '55', 63, 1, NULL, NULL, NULL, 1, 62, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(182, 'U4-2 - In-App payment forward', 1, 3, '85', '92.5', '55', '55', 63, 1, NULL, NULL, NULL, 1, 64, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(183, 'U4-2 - Customer feedback click', 1, NULL, '5', '42', '295', '290', 64, NULL, '3.2', '4', 1, 2, NULL, '5.2', NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(184, 'U4-2 - Customer feedback home', 1, 1, '5', '92.5', '55', '55', 64, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(185, 'U4-2 - Customer feedback backward', 1, 2, '74', '92.5', '55', '55', 64, 1, NULL, NULL, NULL, 1, 63, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(186, 'U4-2 - Customer feedback forward', 1, 3, '85', '92.5', '55', '55', 64, 1, NULL, NULL, NULL, 1, 65, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(187, 'U4-2 - Breaker Customer feedback home', 1, 1, '5', '92.5', '55', '55', 65, 1, NULL, NULL, NULL, 1, 56, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(188, 'U4-2 - Breaker Customer feedback backward', 1, 2, '85', '92.5', '55', '55', 65, 1, NULL, NULL, NULL, 1, 64, NULL, NULL, '', NULL, 5, 0, 0, 0, 0, 0),
(189, 'U4-3 - Charging on the go click', 1, NULL, '5', '50', '480', '295', 66, NULL, '1.2', '2.5', 1, 1, 67, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(190, 'U4-3 - Breaker Alert notification home', 1, 1, '5', '92.5', '55', '55', 67, 1, NULL, NULL, NULL, 1, 66, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(191, 'U4-3 - Breaker Alert notification backward', 1, 2, '74', '92.5', '55', '55', 67, 1, NULL, NULL, NULL, 1, 66, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(192, 'U4-3 - Breaker Alert notification forward', 1, 3, '85', '92.5', '55', '55', 67, 1, NULL, NULL, NULL, 1, 68, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(193, 'U4-3 - Trigger notification home', 1, 1, '5', '92.5', '55', '55', 68, 1, NULL, NULL, NULL, 1, 66, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(194, 'U4-3 - Trigger notification backward', 1, 2, '74', '92.5', '55', '55', 68, 1, NULL, NULL, NULL, 1, 67, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(195, 'U4-3 - Trigger notification forward', 1, 3, '85', '92.5', '55', '55', 68, 1, NULL, NULL, NULL, 1, 69, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(196, 'U4-3 - Locate staions click', 1, NULL, '5', '41', '295', '220', 69, NULL, '1.3', '2', 1, 2, NULL, '3', NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(197, 'U4-3 - Locate staions home', 1, 1, '5', '92.5', '55', '55', 69, 1, NULL, NULL, NULL, 1, 66, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(198, 'U4-3 - Locate staions backward', 1, 2, '74', '92.5', '55', '55', 69, 1, NULL, NULL, NULL, 1, 68, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(199, 'U4-3 - Locate staions forward', 1, 3, '85', '92.5', '55', '55', 69, 1, NULL, NULL, NULL, 1, 70, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(200, 'U4-3 - Breaker end screen home', 1, 1, '5', '92.5', '55', '55', 70, 1, NULL, NULL, NULL, 1, 66, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(201, 'U4-3 - Breaker end screen backward', 1, 2, '85', '92.5', '55', '55', 70, 1, NULL, NULL, NULL, 1, 69, NULL, NULL, '', NULL, 6, 0, 0, 0, 0, 0),
(202, 'L - Move - Overview video', 1, NULL, '44', '18.4', '206', '75', 71, 1, NULL, NULL, 0, 1, 72, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0),
(203, 'L - Back - Overview video', 1, 1, '5', '92.5', '55', '55', 72, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, 7, 0, 0, 0, 0, 0),
(204, 'L - Security connectivity & endpoint', 1, NULL, '8', '46.6', '200', '80', 71, 1, NULL, NULL, 0, 1, 73, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0),
(205, 'L - SOTA Updates', 1, NULL, '15.7', '57', '200', '80', 71, 1, '', '', 0, 1, 77, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0),
(206, 'L - Intelligent Connectivity', 1, NULL, '29.5', '55.6', '200', '80', 71, 1, NULL, NULL, 0, 1, 81, NULL, NULL, '', NULL, 7, 0, 0, 0, 0, 0),
(207, 'L - End-point Security', 1, NULL, '36.5', '45.5', '170', '95', 73, 1, '', '', 0, 1, 74, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27, 18),
(208, 'L - Data Privacy and Regulations', 1, NULL, '48.5', '53', '170', '95', 73, 1, NULL, NULL, 0, 1, 75, NULL, NULL, '', NULL, 7, 0, 0, 1, 27, 18),
(209, 'L - Secure data, Secure network', 1, NULL, '61.3', '72', '170', '95', 73, 1, NULL, NULL, 0, 1, 76, NULL, NULL, '', NULL, 7, 0, 0, 1, 27, 18),
(210, 'L - Back - Security', 1, 1, '5', '92.5', '55', '55', 73, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, 7, 0, 0, 0, 0, 0),
(211, 'L - Ensuring SOTA success', 1, NULL, '38.6', '47', '160', '85', 77, 1, NULL, NULL, 0, 1, 78, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18),
(212, 'L - Move Renewal Assure', 1, NULL, '50', '55.6', '180', '85', 77, 1, NULL, NULL, 0, 1, 79, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18),
(213, 'L - Secure updates', 1, NULL, '46', '67', '150', '75', 77, 1, NULL, NULL, 0, 1, 80, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18),
(214, 'L - Back - SOTA', 1, 1, '5', '92.5', '55', '55', 77, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, 7, 0, 0, 0, 0, 0),
(215, 'L - eSIM hub', 1, NULL, '43', '45', '195', '95', 81, 1, NULL, NULL, 0, 1, 82, NULL, NULL, '', NULL, 7, 0, 0, 1, 27.4, 16.3),
(216, 'L - Single pane of glass', 1, NULL, '55', '52.5', '170', '90', 81, 1, NULL, NULL, 0, 1, 83, NULL, NULL, '', NULL, 7, 0, 0, 1, 27.4, 16.3),
(217, 'L - Bring your own agreement', 1, NULL, '37', '61', '182', '90', 81, 1, NULL, NULL, 0, 1, 84, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27.4, 16.3),
(218, 'L - Uniterrupted connectivity', 1, NULL, '32', '77', '185', '90', 81, 1, NULL, NULL, 0, 1, 85, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27.5, 15.2),
(219, 'L - Back - Intelligent connectivity', 1, 1, '5', '92.5', '55', '55', 81, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, 7, 0, 0, 0, 0, 0),
(330, '2-Wheeler Enhance Car Service', 1, NULL, '5', '22', '250', '195', 117, 1, NULL, NULL, 0, 1, 118, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(331, '2-Wheeler Enhance Pre-purchase experience', 1, NULL, '5', '56', '275', '195', 117, 1, NULL, NULL, 0, 1, 126, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(332, '2-Wheeler U1 - Automatic home', 1, 1, '5', '92.5', '55', '55', 118, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(333, '2-Wheeler U1 - Automatic here backward', 1, 2, '74', '92.5', '55', '55', 118, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(334, '2-Wheeler U1 - Automatic here forward', 1, 3, '85', '92.5', '55', '55', 118, 1, NULL, NULL, NULL, 1, 119, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(335, '2-Wheeler U1 - IVR call', 1, NULL, '10.5', '74', '215', '140', 119, 0, '2.2', '2.7', 1, 2, NULL, '3', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(336, '2-Wheeler U1 - IVR call home', 1, 1, '5', '92.5', '55', '55', 119, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(337, '2-Wheeler U1 - IVR call backward', 1, 2, '74', '92.5', '55', '55', 119, 1, NULL, NULL, NULL, 1, 118, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(338, '2-Wheeler U1 - IVR call forward', 1, 3, '85', '92.5', '55', '55', 119, 1, NULL, NULL, NULL, 1, 120, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(339, '2-Wheeler U1 -Schedule now', 1, NULL, '18.5', '49', '250', '125', 120, 0, '3.5', '4', 1, 2, NULL, '4.7', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(340, '2-Wheeler U1 - Schedule now home', 1, 1, '5', '92.5', '55', '55', 120, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(341, '2-Wheeler U1 - Schedule now backward', 1, 2, '74', '92.5', '55', '55', 120, 1, NULL, NULL, NULL, 1, 119, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(342, '2-Wheeler U1 - Schedule now forward', 1, 3, '85', '92.5', '55', '55', 120, 1, NULL, NULL, NULL, 1, 121, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(343, '2-Wheeler U1 - Dent repair', 1, NULL, '17.5', '50.9', '235', '140', 121, 0, '5.2', '5.7', 1, 2, NULL, '6.2', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(344, '2-Wheeler U1 - Dent repair home', 1, 1, '5', '92.5', '55', '55', 121, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(345, '2-Wheeler U1 - Dent repair backward', 1, 2, '74', '92.5', '55', '55', 121, 1, NULL, NULL, NULL, 1, 120, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(346, '2-Wheeler U1 - Dent repair forward', 1, 3, '85', '92.5', '55', '55', 121, 1, NULL, NULL, NULL, 1, 122, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(347, '2-Wheeler U1 - Join video chat', 1, NULL, '9.5', '68', '235', '140', 122, 0, '14.7', '15', 1, 1, 123, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(348, '2-Wheeler U1 - Join video chat home', 1, 1, '5', '92.5', '55', '55', 122, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(349, '2-Wheeler U1 - Join video chat backward', 1, 2, '74', '92.5', '55', '55', 122, 1, NULL, NULL, NULL, 1, 121, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(350, '2-Wheeler U1 - Join video chat forward', 1, 3, '85', '92.5', '55', '55', 122, 1, NULL, NULL, NULL, 1, 123, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(351, '2-Wheeler U1 - video call home', 1, 1, '5', '92.5', '55', '55', 123, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(352, '2-Wheeler U1 - video call backward', 1, 2, '74', '92.5', '55', '55', 123, 1, NULL, NULL, NULL, 1, 122, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(353, '2-Wheeler U1 - video call forward', 1, 3, '85', '92.5', '55', '55', 123, 1, NULL, NULL, NULL, 1, 124, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(354, '2-Wheeler U1 - ETA home', 1, 1, '5', '92.5', '55', '55', 124, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(355, '2-Wheeler U1 - ETA backward', 1, 2, '74', '92.5', '55', '55', 124, 1, NULL, NULL, NULL, 1, 123, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(356, '2-Wheeler U1 - ETA forward', 1, 3, '85', '92.5', '55', '55', 124, 1, NULL, NULL, NULL, 1, 125, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(357, '2-Wheeler U1 - Explore more use cases', 1, NULL, '6', '19', '180', '75', 125, 1, NULL, NULL, 0, 1, 117, '', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(358, '2-Wheeler U1 - Explore more home', 1, 1, '5', '92.5', '55', '55', 125, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(359, '2-Wheeler U1 - Explore more backward', 1, 2, '85', '92.5', '55', '55', 125, 1, NULL, NULL, NULL, 1, 124, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(360, '2-Wheeler U2 - find out more', 1, NULL, '12', '60', '171', '150', 126, 0, '9.5', '10', 1, 1, 127, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(361, '2-Wheeler U2 - find out more home', 1, 1, '5', '92.5', '55', '55', 126, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(362, '2-Wheeler U2 - find out more backward', 1, 2, '74', '92.5', '55', '55', 126, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(363, '2-Wheeler U2 - find out more forward', 1, 3, '85', '92.5', '55', '55', 126, 1, NULL, NULL, 0, 1, 127, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(364, '2-Wheeler U2 - Car brochures', 1, NULL, '14', '55', '230', '125', 127, 0, '3.8', '4', 1, 2, NULL, '5.2', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(365, '2-Wheeler U2 - Car brochures home', 1, 1, '5', '92.5', '55', '55', 127, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(366, '2-Wheeler U2 - Car brochures backward', 1, 2, '74', '92.5', '55', '55', 127, 1, NULL, NULL, NULL, 1, 126, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(367, '2-Wheeler U2 - Car brochures forward', 1, 3, '85', '92.5', '55', '55', 127, 1, NULL, NULL, NULL, 1, 128, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(368, '2-Wheeler U2 - Sendan model 1', 1, NULL, '14.7', '50', '225', '100', 128, 0, '4', '4.5', 1, 2, NULL, '5.2', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(369, '2-Wheeler U2 - Sendan model 1 home', 1, 1, '5', '92.5', '55', '55', 128, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(370, '2-Wheeler U2 - Sendan model 1 backward', 1, 2, '74', '92.5', '55', '55', 128, 1, NULL, NULL, NULL, 1, 127, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(371, '2-Wheeler U2 - Sendan model 1 forward', 1, 3, '85', '92.5', '55', '55', 128, 1, NULL, NULL, NULL, 1, 129, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(372, '2-Wheeler U2 - Auto co sales rep - video call', 1, NULL, '13', '75', '230', '180', 129, 0, '2.5', '3', 1, 2, NULL, '3.5', NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(373, '2-Wheeler U2 - Book test drive', 1, NULL, '11.5', '70', '235', '195', 129, 0, '12.8', '13.2', 1, 1, 130, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(374, '2-Wheeler U2 - Auto co sales rep - video call home', 1, 1, '5', '92.5', '55', '55', 129, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(375, '2-Wheeler U2 - Auto co sales rep - video call backward', 1, 2, '74', '92.5', '55', '55', 129, 1, NULL, NULL, NULL, 1, 128, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(376, '2-Wheeler U2 - Auto co sales rep - video call forward', 1, 3, '85', '92.5', '55', '55', 129, 1, NULL, NULL, NULL, 1, 130, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(377, '2-Wheeler U2 - Fast query home', 1, 1, '5', '92.5', '55', '55', 130, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(378, '2-Wheeler U2 - Fast query backward', 1, 2, '74', '92.5', '55', '55', 130, 1, NULL, NULL, NULL, 1, 129, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(379, '2-Wheeler U2 - Fast query forward', 1, 3, '85', '92.5', '55', '55', 130, 1, NULL, NULL, NULL, 1, 131, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(380, '2-Wheeler U2 - Confirmation home', 1, 1, '5', '92.5', '55', '55', 131, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(381, '2-Wheeler U2 - Confirmation backward', 1, 2, '74', '92.5', '55', '55', 131, 1, NULL, NULL, NULL, 1, 130, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(382, '2-Wheeler U2 - Confirmation forward', 1, 3, '85', '92.5', '55', '55', 131, 1, NULL, NULL, NULL, 1, 132, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(383, '2-Wheeler U2 -  Explore more use cases', 1, NULL, '6', '19', '180', '75', 132, 1, NULL, NULL, 0, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(384, '2-Wheeler U2 - Explore more home', 1, 1, '5', '92.5', '55', '55', 132, 1, NULL, NULL, NULL, 1, 117, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0),
(385, '2-Wheeler U2 - Explore more backward', 1, 2, '85', '92.5', '55', '55', 132, 1, NULL, NULL, NULL, 1, 131, NULL, NULL, '', NULL, 10, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `video_hotspots`
--

DROP TABLE IF EXISTS `video_hotspots`;
CREATE TABLE IF NOT EXISTS `video_hotspots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `default_icon` tinyint(1) DEFAULT NULL,
  `icon` varchar(40) DEFAULT NULL,
  `x_axis` varchar(10) DEFAULT NULL,
  `y_axis` varchar(10) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `onclick_action` tinyint(1) DEFAULT '1' COMMENT '1: goto video, 2: goto time, 3: goto url, 4:show image, 5:show text, 6: show text+ image',
  `action_video_id` int(11) DEFAULT NULL,
  `action_goto_time` varchar(10) DEFAULT NULL,
  `action_url` varchar(500) DEFAULT NULL,
  `action_image` varchar(45) DEFAULT NULL,
  `action_text` text,
  `ref_video_id` int(11) DEFAULT NULL,
  `open_in_pop_up` tinyint(1) DEFAULT '0',
  `action_video_loop` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_hotspots`
--

INSERT INTO `video_hotspots` (`id`, `title`, `default_icon`, `icon`, `x_axis`, `y_axis`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `onclick_action`, `action_video_id`, `action_goto_time`, `action_url`, `action_image`, `action_text`, `ref_video_id`, `open_in_pop_up`, `action_video_loop`) VALUES
(1, 'First', 1, NULL, '10', '50', 1, 1, NULL, NULL, 0, 1, 5, NULL, NULL, NULL, NULL, 1, 1, 1),
(2, 'Second', 1, NULL, '20', '80', 1, 1, NULL, NULL, 0, 1, 5, NULL, NULL, NULL, NULL, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `video_image`
--

DROP TABLE IF EXISTS `video_image`;
CREATE TABLE IF NOT EXISTS `video_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `is_image_uploaded` tinyint(1) DEFAULT NULL,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `image_height` int(11) DEFAULT NULL,
  `image_width` int(11) DEFAULT NULL,
  `padding` int(11) DEFAULT NULL,
  `margin` int(11) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `ref_video_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `video_language`
--

DROP TABLE IF EXISTS `video_language`;
CREATE TABLE IF NOT EXISTS `video_language` (
  `video_language_id` int(11) NOT NULL AUTO_INCREMENT,
  `video_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`video_language_id`),
  KEY `f_video_id_idx` (`video_id`),
  KEY `f_language_id_idx` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `video_language`
--

INSERT INTO `video_language` (`video_language_id`, `video_id`, `language_id`) VALUES
(1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `video_link`
--

DROP TABLE IF EXISTS `video_link`;
CREATE TABLE IF NOT EXISTS `video_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `default_icon` tinyint(1) DEFAULT NULL,
  `icon` varchar(40) DEFAULT NULL,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `onclick_action` tinyint(1) DEFAULT '1' COMMENT '1: goto video, 2: goto time, 3: goto url, 4:show image, 5:show text, 6: show text+ image',
  `action_url` varchar(500) DEFAULT NULL,
  `ref_video_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `video_media`
--

DROP TABLE IF EXISTS `video_media`;
CREATE TABLE IF NOT EXISTS `video_media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `ext` varchar(10) DEFAULT NULL,
  `video_height` varchar(10) DEFAULT NULL,
  `video_width` varchar(10) DEFAULT NULL,
  `duration` varchar(10) DEFAULT NULL,
  `ref_video_id` varchar(45) DEFAULT NULL,
  `on_end_media_type` varchar(45) DEFAULT NULL,
  `on_end_media_id` int(11) DEFAULT NULL,
  `show_play_pause_btn` tinyint(1) DEFAULT '1',
  `replay_btn` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_media`
--

INSERT INTO `video_media` (`id`, `title`, `ext`, `video_height`, `video_width`, `duration`, `ref_video_id`, `on_end_media_type`, `on_end_media_id`, `show_play_pause_btn`, `replay_btn`) VALUES
(1, 'Clip 1', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(2, 'Clip 2', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(3, 'Clip 3', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(4, 'Clip 4', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(5, 'Clip 5', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(6, 'Clip 6', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(7, 'Clip 7', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(8, 'Clip 8', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(9, 'Clip 9', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(10, 'Clip 10', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(11, 'Clip 11', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(12, 'Clip 12', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(13, 'Clip 13', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(14, 'Clip 14', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(15, 'Clip 15', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 0, 0),
(16, 'Clip 16', 'mp4', NULL, NULL, NULL, '1', NULL, NULL, 1, 0),
(17, 'Clip 17', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 0),
(18, 'Clip 18', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(19, 'Clip 19', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(20, 'Clip 20', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(21, 'Clip 21', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(22, 'Clip 22', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(23, 'Clip 23', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(24, 'Clip 24', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(25, 'Clip 25', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(26, 'Clip 26', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(27, 'Clip 27', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(28, 'Clip 28', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(29, 'Clip 29', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(31, 'Clip 31', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(32, 'Clip 32', 'mp4', NULL, NULL, NULL, '2', NULL, NULL, 0, 1),
(33, 'Clip 33', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 0),
(34, 'Clip 34', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(35, 'Clip 35', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(36, 'Clip 36', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(37, 'Clip 37', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(38, 'Clip 38', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(39, 'Clip 39', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(40, 'Clip 40', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(41, 'Clip 41', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(42, 'Clip 42', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(43, 'Clip 43', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(44, 'Clip 44', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(45, 'Clip 45', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(46, 'Clip 46', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(47, 'Clip 47', 'mp4', NULL, NULL, NULL, '3', NULL, NULL, 0, 1),
(48, 'Clip 48', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 0),
(49, 'Clip 49', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(50, 'Clip 50', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(51, 'Clip 51', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(52, 'Clip 52', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(53, 'Clip 53', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(54, 'Clip 54', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 1),
(55, 'Clip 55', 'mp4', NULL, NULL, NULL, '4', NULL, NULL, 0, 0),
(56, 'Clip 56', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 0),
(57, 'Clip 57', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(58, 'Clip 58', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(59, 'Clip 59', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(60, 'Clip 60', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 0),
(61, 'Clip 61', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(62, 'Clip 62', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 0),
(63, 'Clip 63', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(64, 'Clip 64', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 1),
(65, 'Clip 65', 'mp4', NULL, NULL, NULL, '5', NULL, NULL, 0, 0),
(66, 'Clip 66', 'mp4', NULL, NULL, NULL, '6', NULL, NULL, 0, 0),
(67, 'Clip 67', 'mp4', NULL, NULL, NULL, '6', NULL, NULL, 0, 0),
(68, 'Clip 68', 'mp4', NULL, NULL, NULL, '6', NULL, NULL, 0, 1),
(69, 'Clip 69', 'mp4', NULL, NULL, NULL, '6', NULL, NULL, 0, 1),
(70, 'Clip 70', 'mp4', NULL, NULL, NULL, '6', NULL, NULL, 0, 0),
(71, 'Clip 71', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(72, 'Clip 72', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 1, 0),
(73, 'Clip 73', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(74, 'Clip 74', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(75, 'Clip 75', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(76, 'Clip 76', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(77, 'Clip 77', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(78, 'Clip 78', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(79, 'Clip 79', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(80, 'Clip 80', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(81, 'Clip 81', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(82, 'Clip 82', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(83, 'Clip 83', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(84, 'Clip 84', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(85, 'Clip 85', 'mp4', NULL, NULL, NULL, '7', NULL, NULL, 0, 0),
(86, 'Clip 86', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(87, 'Clip 87', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(88, 'Clip 89', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(89, 'Clip 90', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(90, 'Clip 91', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(91, 'Clip 92', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(92, 'Clip 93', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(93, 'Clip 94', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(94, 'Clip 95', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(95, 'Clip 96', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(96, 'Clip 97', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(97, 'Clip 98', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(98, 'Clip 98', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(99, 'Clip 99', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(100, 'Clip 100', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(101, 'Clip 101', 'mp4', NULL, NULL, NULL, '8', NULL, NULL, 0, 0),
(102, 'Clip 102', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(103, 'Clip 103', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(104, 'Clip 104', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(105, 'Clip 105', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(106, 'Clip 106', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(107, 'Clip 107', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(108, 'Clip 108', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(109, 'Clip 109', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(110, 'Clip 110', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(111, 'Clip 111', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(112, 'Clip 112', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(113, 'Clip 113', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(114, 'Clip 114', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(115, 'Clip 115', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(116, 'Clip 116', 'mp4', NULL, NULL, NULL, '9', NULL, NULL, 0, 0),
(117, 'Clip 117', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 0),
(118, 'Clip 118', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(119, 'Clip 119', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(120, 'Clip 120', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(121, 'Clip 121', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(122, 'Clip 122', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(123, 'Clip 123', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(124, 'Clip 124', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(125, 'Clip 124', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(126, 'Clip 125', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(127, 'Clip 126', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(128, 'Clip 127', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(129, 'Clip 128', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(130, 'Clip 129', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(131, 'Clip 130', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1),
(132, 'Clip 132', 'mp4', NULL, NULL, NULL, '10', NULL, NULL, 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `video_subtitle`
--

DROP TABLE IF EXISTS `video_subtitle`;
CREATE TABLE IF NOT EXISTS `video_subtitle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subtitle` varchar(250) DEFAULT NULL,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `font-size` varchar(10) DEFAULT NULL,
  `text_box_width` varchar(10) DEFAULT NULL,
  `padding` int(11) DEFAULT NULL,
  `margin` int(11) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `ref_video_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `video_text`
--

DROP TABLE IF EXISTS `video_text`;
CREATE TABLE IF NOT EXISTS `video_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `text` text,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `font-size` varchar(10) DEFAULT NULL,
  `text_box_width` varchar(10) DEFAULT NULL,
  `padding` int(11) DEFAULT NULL,
  `margin` int(11) DEFAULT NULL,
  `video_id` int(11) DEFAULT NULL,
  `show_in_whole_video` tinyint(1) DEFAULT '0',
  `show_start_time` varchar(10) DEFAULT NULL,
  `show_end_time` varchar(10) DEFAULT NULL,
  `pause_video` tinyint(1) DEFAULT '0' COMMENT 'pause video when interaction start time starts',
  `ref_video_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_text`
--

INSERT INTO `video_text` (`id`, `title`, `text`, `x_axis_start`, `y_axis_start`, `font-size`, `text_box_width`, `padding`, `margin`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `ref_video_id`) VALUES
(1, 'accordion-tabs', '<div class=\"acc-img acc-img1 show\" id=\"data-1\" >\r\n <img src=\"assets/images/whatsApp.png\" alt=\"\">\r\n </div>\r\n <div class=\"acc-img acc-img2\" id=\"data-2\">\r\n <img src=\"assets/images/sms.png\" alt=\"\">\r\n </div>\r\n <div class=\"acc-img acc-img3\" id=\"data-3\" >\r\n <img src=\"assets/images/mail.png\" alt=\"\">\r\n </div>\r\n <div class=\"acc-img acc-img4\" id=\"data-4\" >\r\n <img src=\"assets/images/insta.png\" alt=\"\">\r\n </div>\r\n <div class=\"acc-img acc-img5\" id=\"data-5\">\r\n <img src=\"assets/images/messenger.png\" alt=\"\">\r\n </div>\r\n \r\n <div class=\"accordion timeline-accordion\" id=\"accordionExample\">\r\n \r\n\r\n <div class=\"accordion-item active\" data-id=\"data-1\" >\r\n <div class=\"accordion-header\" id=\"headingOne\">\r\n <h2 class=\"mb-0 accordion-head\" data-toggle=\"collapse\" data-target=\"#collapseOne\" aria-expanded=\"true\" aria-controls=\"collapseOne\">\r\n Personalised service </h2>\r\n </div>\r\n\r\n <div id=\"collapseOne\" class=\"acc-d collapse show\" aria-labelledby=\"headingOne\" data-parent=\"#accordionExample\">\r\n <div class=\"accordion-body\">\r\n Customising and visualising their car before purchase\r\n </div>\r\n </div>\r\n </div>\r\n <div class=\"accordion-item\" data-id=\"data-2\" >\r\n <div class=\"accordion-header\" id=\"headingTwo\">\r\n <h2 class=\"mb-0 accordion-head\" data-toggle=\"collapse\" data-target=\"#collapseTwo\" aria-expanded=\"false\" aria-controls=\"collapseTwo\">\r\n Consistent exprience\r\n </h2>\r\n </div>\r\n <div id=\"collapseTwo\" class=\"acc-d collapse\" aria-labelledby=\"headingTwo\" data-parent=\"#accordionExample\">\r\n <div class=\"accordion-body\">\r\n Across all touchpoints\r\n </div>\r\n </div>\r\n </div>\r\n <div class=\"accordion-item\" data-id=\"data-3\" >\r\n <div class=\"accordion-header\" id=\"headingThree\">\r\n <h2 class=\"mb-0 accordion-head\" data-toggle=\"collapse\" data-target=\"#collapseThree\" aria-expanded=\"false\" aria-controls=\"collapseThree\">\r\n Supported after-sales journey\r\n </h2>\r\n </div>\r\n <div id=\"collapseThree\" class=\"acc-d collapse\" aria-labelledby=\"headingThree\" data-parent=\"#accordionExample\">\r\n <div class=\"accordion-body\">\r\n That\'s consistent, personal, transparent and with self-service feature\r\n </div>\r\n </div>\r\n </div>\r\n <div class=\"accordion-item\" data-id=\"data-4\">\r\n <div class=\"accordion-header\" id=\"headingFour\">\r\n <h2 class=\"mb-0 accordion-head\" data-toggle=\"collapse\" data-target=\"#collapseFour\" aria-expanded=\"false\" aria-controls=\"collapseThree\">\r\n Proactive communication\r\n </h2>\r\n </div>\r\n <div id=\"collapseFour\" class=\"acc-d collapse\" aria-labelledby=\"headingFour\" data-parent=\"#accordionExample\">\r\n <div class=\"accordion-body\">\r\n Backed by expert guidance \r\n </div>\r\n </div>\r\n </div>\r\n <div class=\"accordion-item\" data-id=\"data-5\">\r\n <div class=\"accordion-header\" id=\"headingFive\">\r\n <h2 class=\"mb-0 accordion-head\" data-toggle=\"collapse\" data-target=\"#collapseFive\" aria-expanded=\"false\" aria-controls=\"collapseThree\">\r\n Real-time updates\r\n </h2>\r\n </div>\r\n <div id=\"collapseFive\" class=\"acc-d collapse\" aria-labelledby=\"headingFive\" data-parent=\"#accordionExample\">\r\n <div class=\"accordion-body\">\r\n Plus relevant, data-driven insights\r\n </div>\r\n </div>\r\n </div>', '0', '98', NULL, NULL, NULL, NULL, 25, 1, NULL, NULL, 0, '1');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `video_language`
--
ALTER TABLE `video_language`
  ADD CONSTRAINT `f_language_id` FOREIGN KEY (`language_id`) REFERENCES `master_language` (`language_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `f_video_id` FOREIGN KEY (`video_id`) REFERENCES `video` (`video_id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
