-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Aug 21, 2023 at 04:05 PM
-- Server version: 5.7.31
-- PHP Version: 7.4.9

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_1.0.0.2`
--

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

--
-- 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`),
  UNIQUE KEY `language_id` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 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
(33, 'English new', 'EN', '1', NULL, '2023-05-16 16:27:39.705', '2023-05-17 10:18:47.570'),
(63, 'Test', 'test', '1', NULL, '2023-05-17 09:05:49.892', '2023-05-17 09:05:49.892'),
(73, 'HELLO', 'TEST1', '1', NULL, '2023-05-17 13:47:45.832', '2023-06-06 06:05:05.148'),
(76, 'Test', 't', '1', NULL, '2023-05-17 14:34:41.983', '2023-05-17 14:34:41.983'),
(77, 'tcics', 'test', '1', NULL, '2023-05-17 14:50:33.803', '2023-05-17 14:50:33.803'),
(79, 'Test', 'test', '0', NULL, '2023-05-17 14:57:12.324', '2023-05-17 14:57:12.324'),
(80, 'h', 'hey', '1', NULL, '2023-05-17 15:03:50.010', '2023-05-17 15:03:50.010'),
(82, 'Test', 'test', '0', NULL, '2023-05-17 15:12:39.983', '2023-05-17 15:12:39.983'),
(83, '1', '1', '0', NULL, '2023-05-17 15:13:07.193', '2023-05-17 15:13:07.193'),
(90, 'Test22', 'test', '1', NULL, '2023-05-17 15:30:24.188', '2023-05-17 15:30:24.188'),
(91, 'tt435', 'test', '1', NULL, '2023-05-17 15:35:38.219', '2023-05-17 15:35:38.219'),
(92, '54353455', '555', '1', NULL, '2023-05-17 15:35:55.503', '2023-05-17 15:35:55.503'),
(95, 'Test', 'fgdfg56', '1', NULL, '2023-05-17 15:51:55.579', '2023-05-17 15:51:55.579'),
(96, 'Test', 'test', '1', NULL, '2023-05-17 16:00:20.784', '2023-05-17 16:00:20.784'),
(97, 'Test', 'test', '1', NULL, '2023-05-17 16:23:12.601', '2023-05-17 16:23:12.601'),
(98, 'Test', 'test', '1', NULL, '2023-05-17 16:23:25.642', '2023-05-17 16:23:25.642'),
(99, 'Test', 'test', '1', NULL, '2023-05-17 16:37:24.747', '2023-05-17 16:37:24.747'),
(100, 'Testing', 'tr', '1', NULL, '2023-05-17 16:44:56.156', '2023-05-17 16:44:56.156'),
(101, 'Test', 'test', '1', NULL, '2023-05-17 16:45:08.626', '2023-05-17 16:45:08.626'),
(103, 'Test', 'test', '1', NULL, '2023-05-18 04:53:21.965', '2023-05-18 04:53:21.965'),
(113, 'Test', 'test', NULL, NULL, '2023-06-06 11:41:34.263', '2023-06-06 11:41:34.263'),
(115, 'Test', 'test', '0', NULL, '2023-06-06 11:51:49.779', '2023-06-06 11:51:49.779'),
(118, 'English', 'EN', '0', NULL, '2023-07-10 09:15:18.743', '2023-07-10 09:15:18.743'),
(119, 'Spanish', 'SP', '0', NULL, '2023-07-10 09:49:09.678', '2023-07-10 09:49:09.678'),
(120, 'Albanian', 'ALB', '0', NULL, '2023-07-10 09:49:24.349', '2023-07-10 09:49:24.349'),
(121, 'German', 'GR', '0', NULL, '2023-07-10 09:49:35.942', '2023-07-10 09:49:35.942'),
(122, 'Romanian', 'RM6', '1', NULL, '2023-07-10 09:49:50.703', '2023-07-11 04:50:38.659');

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

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

DROP TABLE IF EXISTS `video`;
CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL,
  `code` varchar(45) DEFAULT 'V0001',
  `description` varchar(2000) CHARACTER SET utf8mb4 DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `video_thumbnail` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `video_path` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `embed_link` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `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',
  `form_active` tinyint(1) NOT NULL DEFAULT '0',
  `starter_media_type` varchar(10) DEFAULT NULL,
  `starter_media_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`video_id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;

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

INSERT INTO `video` (`video_id`, `title`, `code`, `description`, `is_active`, `video_thumbnail`, `video_path`, `embed_link`, `added_by`, `add_date_time`, `modified_date_time`, `default_language`, `video_type`, `form_active`, `starter_media_type`, `starter_media_id`) VALUES
(1, 'Auto Move Solutions', 'V0001', 'dummy', 1, NULL, NULL, NULL, NULL, '2023-03-09 13:31:44.897', '2023-04-19 16:00:23.361', 1, 1, 0, 'video', 1),
(2, 'CX & Digital Omnichannel', 'V0002', 'dummy', 1, NULL, NULL, NULL, NULL, '2023-03-09 13:31:44.897', '2023-06-05 15:43:07.671', 1, 1, 0, 'video', 17),
(7, 'Landscape - Auto Move Solutions', 'v0007', 'dummy', 1, NULL, NULL, NULL, NULL, '2023-03-09 08:01:44.897', '2023-08-16 06:16:27.401', 1, 2, 1, 'video', 100),
(8, 'Landscape - DIGO CX & Digital Omnichannel', 'v0008', 'dummy', 1, NULL, NULL, NULL, NULL, '2023-03-09 08:01:44.897', '2023-06-22 07:52:35.774', 1, 2, 0, 'video', 86),
(9, 'Landscape - Auto Retail', 'v0009', 'dummy', 1, NULL, NULL, NULL, NULL, '2023-03-09 08:01:44.897', '2023-06-20 05:21:08.702', 1, 2, 0, 'video', 102),
(12, 'Test', 'V0003', 'Lorem Ipsum', 1, 'L', 'Lorem Ipsum', 'www.google.com', NULL, '2023-06-01 15:18:51.152', '2023-06-05 15:43:11.959', NULL, 1, 0, NULL, NULL),
(13, 'Test', 'V0004', 'Lorem Ipsum', 1, 'L', 'Lorem Ipsum', 'www.google.com', NULL, '2023-06-01 15:19:57.224', '2023-06-05 15:43:15.321', NULL, 1, 0, NULL, NULL),
(15, 'Test', 'V0005', 'Lorem Ipsum', 1, '', 'test.mp4', 'www.google.com', NULL, '2023-06-01 16:12:04.141', '2023-06-05 15:43:19.592', NULL, 1, 0, NULL, NULL),
(16, NULL, 'V0006', NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-05 15:01:26.344', '2023-06-05 15:43:23.199', NULL, 1, 0, NULL, NULL),
(17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-05 15:47:23.763', '2023-06-05 15:47:23.763', NULL, 1, 0, NULL, NULL),
(18, 'hello', '501', 'testing', 1, NULL, 'videoFile-1685985422725-876000116.mp4', 'test', NULL, '2023-06-05 17:17:02.796', '2023-06-05 17:17:02.796', NULL, 1, 0, NULL, NULL),
(20, 'hello', '502', 'testing', 1, 'thumbnailFile-1685985895763-648739243.ico', 'videoFile-1685985895754-708446516.mp4', 'test', NULL, '2023-06-05 17:24:55.766', '2023-06-05 17:24:55.766', NULL, 1, 0, NULL, NULL),
(21, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-06-05 17:26:59.920', '2023-06-05 17:26:59.920', NULL, 1, 0, NULL, NULL),
(22, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-06-05 17:27:11.072', '2023-06-05 17:27:11.072', NULL, 1, 0, NULL, NULL),
(24, 'hello', '504', 'testing', 1, NULL, 'videoFile-1685986091878-791426719.mp4', 'test', NULL, '2023-06-05 17:28:11.890', '2023-06-05 17:28:11.890', NULL, 1, 0, NULL, NULL),
(25, 'hey', 'v121', 'dumm', 1, NULL, 'videoFile-1692617821757-335828352.mp4', 'www.google.com', NULL, '2023-08-21 11:37:02.292', '2023-08-21 11:37:02.292', NULL, 1, 0, NULL, NULL),
(28, 'hey1', 'v1211', 'dummy', 1, NULL, '71--.mp4', 'www.google.com', NULL, '2023-08-21 11:51:21.566', '2023-08-21 11:51:21.566', NULL, 1, 0, NULL, NULL),
(30, 'hey2', 'v1212', 'dummy2', 1, NULL, 'videoFile.mp4', 'www.google.com', NULL, '2023-08-21 11:57:45.810', '2023-08-21 11:57:45.810', NULL, 1, 0, NULL, NULL),
(31, 'hey2', 'v1213', 'dummy2', 1, NULL, 'DIGO Home for Auto.mp4.mp4', 'www.google.com', NULL, '2023-08-21 11:58:40.100', '2023-08-21 11:58:40.100', NULL, 1, 0, NULL, NULL),
(32, 'hey2', 'v12114', 'dummy2', 1, NULL, 'DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 11:59:36.283', '2023-08-21 11:59:36.283', NULL, 1, 0, NULL, NULL),
(33, 'hey2', 'v12115', 'dummy2', 1, NULL, 'DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 12:01:12.821', '2023-08-21 12:01:12.821', NULL, 1, 0, NULL, NULL),
(37, 'hey2', 'v12116', 'dummy2', 1, NULL, 'DIGO Home for Auto-1692619368025-955709837.mp4', 'www.google.com', NULL, '2023-08-21 12:02:48.049', '2023-08-21 12:02:48.049', NULL, 1, 0, NULL, NULL),
(38, 'hey2', 'v12117', 'dummy2', 1, NULL, 'DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 12:04:28.983', '2023-08-21 12:04:28.983', NULL, 1, 0, NULL, NULL),
(41, 'hey2', 'v12118', 'dummy2', 1, NULL, 'DIGO Home for Auto(2).mp4', 'www.google.com', NULL, '2023-08-21 12:07:44.002', '2023-08-21 12:07:44.002', NULL, 1, 0, NULL, NULL),
(43, 'hey2', 'v12119', 'dummy2', 1, NULL, 'DIGO Home for Auto-1.mp4', 'www.google.com', NULL, '2023-08-21 12:14:44.046', '2023-08-21 12:14:44.046', NULL, 1, 0, NULL, NULL),
(45, 'hey2', 'v121188', 'dummy2', 1, NULL, 'DIGO Home for Auto-2.mp4', 'www.google.com', NULL, '2023-08-21 12:15:08.573', '2023-08-21 12:15:08.573', NULL, 1, 0, NULL, NULL),
(46, 'hey2', 'v121177', 'dummy2', 1, NULL, 'DIGO Home for Auto-3.mp4', 'www.google.com', NULL, '2023-08-21 12:15:29.947', '2023-08-21 12:15:29.947', NULL, 1, 0, NULL, NULL),
(51, 'DIGO Home for Auto-4.mp4', 'v121178', 'dummy2', 1, NULL, 'DIGO Home for Auto-4.mp4', 'www.google.com', NULL, '2023-08-21 12:32:06.876', '2023-08-21 12:32:06.876', NULL, 1, 0, NULL, NULL),
(53, 'DIGO Home for Auto-5.mp4', 'v1211781', 'dummy2', 1, NULL, 'D:\\wamp64\\www\\product-interactive-video\\nodejs-api\\routes\\uploads\\DIGO Home for Auto-5.mp4', 'www.google.com', NULL, '2023-08-21 12:37:47.799', '2023-08-21 12:37:47.799', NULL, 1, 0, NULL, NULL),
(55, 'DIGO Home for Auto-6.mp4', 'v1211722', 'dummy2', 1, NULL, 'uploads/DIGO Home for Auto-6.mp4', 'www.google.com', NULL, '2023-08-21 12:45:02.938', '2023-08-21 12:45:02.938', NULL, 1, 0, NULL, NULL),
(60, 'DIGO Home for Auto-7.mp4', 'v12117221', 'dummy21', 1, NULL, 'uploads/DIGO Home for Auto-7.mp4', 'www.google.com', NULL, '2023-08-21 12:58:11.727', '2023-08-21 12:58:11.727', NULL, 1, 0, NULL, NULL),
(70, 'DIGO Home for Auto-8.mp4', 'v121172112', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto-8.mp4', 'www.google.com', NULL, '2023-08-21 13:26:29.802', '2023-08-21 13:26:29.802', NULL, 1, 0, NULL, NULL),
(73, 'DIGO Home for Auto-8.mp4', 'v15', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto-8.mp4', 'www.google.com', NULL, '2023-08-21 13:27:04.726', '2023-08-21 13:27:04.726', NULL, 1, 0, NULL, NULL),
(76, 'DIGO Home for Auto.mp4', 'v16', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:28:02.253', '2023-08-21 13:28:02.253', NULL, 1, 0, NULL, NULL),
(79, 'DIGO Home for Auto.mp4', 'v167', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:30:16.097', '2023-08-21 13:30:16.097', NULL, 1, 0, NULL, NULL),
(82, 'DIGO Home for Auto.mp4', 'v57', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:30:42.690', '2023-08-21 13:30:42.690', NULL, 1, 0, NULL, NULL),
(83, 'DIGO Home for Auto.mp4', 'v571', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:30:49.104', '2023-08-21 13:30:49.104', NULL, 1, 0, NULL, NULL),
(87, 'DIGO Home for Auto.mp4', 'v5711', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:33:51.356', '2023-08-21 13:33:51.356', NULL, 1, 0, NULL, NULL),
(88, 'DIGO Home for Auto.mp4', 'v57111', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:33:55.567', '2023-08-21 13:33:55.567', NULL, 1, 0, NULL, NULL),
(91, 'DIGO Home for Auto.mp4', 'v522111', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:34:27.276', '2023-08-21 13:34:27.276', NULL, 1, 0, NULL, NULL),
(92, 'DIGO Home for Auto.mp4', 'v5221', 'dummy21', 1, NULL, 'uploads/2023/08/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:34:39.746', '2023-08-21 13:34:39.746', NULL, 1, 0, NULL, NULL),
(94, 'DIGO Home for Auto.mp4', 'v5221112', 'dummy21', 1, NULL, 'uploads/DIGO Home for Auto.mp4', 'www.google.com', NULL, '2023-08-21 13:37:36.428', '2023-08-21 13:37:36.428', NULL, 1, 0, NULL, NULL),
(95, 'DIGO Home for Auto-1.mp4', 'v52111', 'dummy21', 1, NULL, 'uploads/DIGO Home for Auto-1.mp4', 'www.google.com', NULL, '2023-08-21 13:37:46.540', '2023-08-21 13:37:46.540', NULL, 1, 0, NULL, NULL);

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

--
-- 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` varchar(40) DEFAULT NULL,
  `icon_width` varchar(10) DEFAULT NULL,
  `icon_height` varchar(10) DEFAULT NULL,
  `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,
  `text_left_pos` varchar(10) DEFAULT NULL,
  `text_top_pos` varchar(10) DEFAULT NULL,
  `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,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=328 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `video_click` (`id`, `title`, `default_icon`, `icon`, `icon_width`, `icon_height`, `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`, `text_left_pos`, `text_top_pos`, `ref_video_id`, `open_in_pop_up`, `action_video_loop`, `open_in_zoom_in`, `zoom_in_top_per`, `zoom_in_left_per`, `video_language_id`, `modified_date_time`) VALUES
(1, 'Move - Overview video', 0, NULL, NULL, NULL, '36', '14.4', '150', '70', 100, 1, '1', '', 0, 6, 100, NULL, NULL, 'usecase-3.png', 'lorem', NULL, NULL, 7, 0, 1, 0, 0, 0, NULL, NULL),
(2, 'Back - Overview video', 0, NULL, NULL, NULL, '5', '92.5', '55', '55', 16, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(3, 'Security connectivity & endpoint', 0, NULL, '40', '40', '2', '54.3', '168', '65', 1, 1, NULL, NULL, 0, 5, 1, NULL, 'https://www.w3schools.com/', 'image-panel.jpg', 'Lorem ipsum', NULL, NULL, 1, 0, 1, 0, 0, 0, NULL, NULL),
(4, 'SOTA Updates', 0, NULL, NULL, NULL, '25', '62.2', '168', '60', 1, 1, '', '', 0, 1, 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(5, 'Intelligent Connectivity', 0, NULL, NULL, NULL, '54', '55.6', '168', '60', 1, 1, NULL, NULL, 0, 1, 11, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(6, 'End-point Security', 0, NULL, NULL, NULL, '24', '53.5', '126', '56', 2, 1, '', '', 0, 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 26, 13, NULL, NULL),
(7, 'Data Privacy and Regulations', 0, NULL, NULL, NULL, '42.5', '59', '126', '56', 2, 1, NULL, NULL, 0, 1, 4, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 1, 24, 12, NULL, NULL),
(8, 'Secure data, Secure network', 0, NULL, NULL, NULL, '68.8', '75', '126', '56', 2, 1, NULL, NULL, 0, 1, 5, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 1, 33, 23, NULL, NULL),
(9, 'Back - Security', 0, NULL, NULL, NULL, '5', '92.5', '55', '55', 2, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(10, 'Ensuring SOTA success', 1, NULL, NULL, NULL, '19.6', '41', '126', '56', 6, 1, NULL, NULL, 0, 1, 7, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 7, 18, NULL, NULL),
(11, 'Move Renewal Assure', 1, NULL, NULL, NULL, '37.6', '46.6', '165', '56', 6, 1, NULL, NULL, 0, 1, 9, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 7, 18, NULL, NULL),
(12, 'Secure updates', 1, NULL, NULL, NULL, '40.4', '59', '126', '56', 6, 1, NULL, NULL, 0, 1, 10, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 6, 19, NULL, NULL),
(13, 'Back - SOTA', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 6, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(14, 'eSIM hub', 1, NULL, NULL, NULL, '37', '45', '126', '56', 11, 1, NULL, NULL, 0, 1, 12, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 1, 19.4, 20.3, NULL, NULL),
(15, 'Single pane of glass', 1, NULL, NULL, NULL, '54', '50.6', '126', '56', 11, 1, NULL, NULL, 0, 1, 13, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 1, 19.4, 20.3, NULL, NULL),
(16, 'Bring your own agreement', 1, NULL, NULL, NULL, '25', '55.6', '126', '56', 11, 1, NULL, NULL, 0, 1, 14, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 19.4, 20.3, NULL, NULL),
(17, 'Uniterrupted connectivity', 1, NULL, NULL, NULL, '7.6', '68', '126', '56', 11, 1, NULL, NULL, 0, 1, 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 25.6, 3.6, NULL, NULL),
(18, 'Back - Intelligent connectivity', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 11, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '', NULL, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL, NULL),
(19, 'Enhance Car Service', 1, NULL, NULL, NULL, '5', '22', '250', '195', 17, 1, NULL, NULL, 0, 3, NULL, NULL, 'https://www.google.com/', '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(20, 'Enhance Pre-purchase experience', 1, NULL, NULL, NULL, '5', '56', '275', '195', 17, 1, NULL, NULL, 0, 1, 26, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(21, 'U1 - Automatic home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(22, 'U1 - Automatic here backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(23, 'U1 - Automatic here forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 18, 1, NULL, NULL, NULL, 1, 19, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(24, 'U1 - IVR call', 1, NULL, NULL, NULL, '10.5', '74', '215', '140', 19, 0, '2.2', '2.7', 1, 2, NULL, '3', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(25, 'U1 - IVR call home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(26, 'U1 - IVR call backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 18, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(27, 'U1 - IVR call forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 19, 1, NULL, NULL, NULL, 1, 20, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(28, 'U1 -Schedule now', 1, NULL, NULL, NULL, '18.5', '49', '250', '125', 20, 0, '3.5', '4', 1, 2, NULL, '4.7', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(29, 'U1 - Schedule now home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(30, 'U1 - Schedule now backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 19, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(31, 'U1 - Schedule now forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 20, 1, NULL, NULL, NULL, 1, 21, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(32, 'U1 - Dent repair', 1, NULL, NULL, NULL, '17.5', '50.9', '235', '140', 21, 0, '5.2', '5.7', 1, 2, NULL, '6.2', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(35, 'U1 - Dent repair home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(36, 'U1 - Dent repair backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 20, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(37, 'U1 - Dent repair forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 21, 1, NULL, NULL, NULL, 1, 22, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(38, 'U1 - Join video chat', 1, NULL, NULL, NULL, '9.5', '68', '235', '140', 22, 0, '14.7', '15', 1, 1, 23, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(39, 'U1 - Join video chat home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(40, 'U1 - Join video chat backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 21, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(41, 'U1 - Join video chat forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 22, 1, NULL, NULL, NULL, 1, 23, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(42, 'U1 - video call home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(43, 'U1 - video call backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 22, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(44, 'U1 - video call forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 23, 1, NULL, NULL, NULL, 1, 24, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(45, 'U1 - ETA home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(46, 'U1 - ETA backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 23, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(47, 'U1 - ETA forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 24, 1, NULL, NULL, NULL, 1, 25, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(48, 'U1 - Explore more use cases', 1, NULL, NULL, NULL, '6', '19', '180', '75', 25, 1, NULL, NULL, 0, 1, 17, '', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(49, 'U1 - Explore more home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 25, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(50, 'U1 - Explore more backward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 25, 1, NULL, NULL, NULL, 1, 24, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(51, 'U2 - find out more', 1, NULL, NULL, NULL, '12', '60', '171', '150', 26, 0, '9.5', '10', 1, 1, 27, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(52, 'U2 - find out more home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 26, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(53, 'U2 - find out more backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 26, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(54, 'U2 - find out more forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 26, 1, NULL, NULL, 0, 1, 27, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(55, 'U2 - Car brochures', 1, NULL, NULL, NULL, '14', '55', '230', '125', 27, 0, '3.8', '4', 1, 2, NULL, '5.2', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(56, 'U2 - Car brochures home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(57, 'U2 - Car brochures backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 26, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(58, 'U2 - Car brochures forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 27, 1, NULL, NULL, NULL, 1, 28, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(59, 'U2 - Sendan model 1', 1, NULL, NULL, NULL, '14.7', '50', '225', '100', 28, 0, '4', '4.5', 1, 2, NULL, '5.2', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(60, 'U2 - Sendan model 1 home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(61, 'U2 - Sendan model 1 backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 27, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(62, 'U2 - Sendan model 1 forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 28, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(63, 'U2 - Auto co sales rep - video call', 1, NULL, NULL, NULL, '13', '75', '230', '180', 29, 0, '2.5', '3', 1, 2, NULL, '3.5', NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(64, 'U2 - Book test drive', 1, NULL, NULL, NULL, '11.5', '70', '235', '195', 29, 0, '12.8', '13.2', 1, 1, 30, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(65, 'U2 - Auto co sales rep - video call home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(66, 'U2 - Auto co sales rep - video call backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 28, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(67, 'U2 - Auto co sales rep - video call forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 29, 1, NULL, NULL, NULL, 1, 30, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(68, 'U2 - Fast query home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(69, 'U2 - Fast query backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(70, 'U2 - Fast query forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 30, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(71, 'U2 - Confirmation home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(72, 'U2 - Confirmation backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 30, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(73, 'U2 - Confirmation forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 31, 1, NULL, NULL, NULL, 1, 32, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(74, 'U2 -  Explore more use cases', 1, NULL, NULL, NULL, '6', '19', '180', '75', 32, 1, NULL, NULL, 0, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(75, 'U2 - Explore more home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 32, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(76, 'U2 - Explore more backward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 32, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(77, 'Retail- usecase 1', 1, NULL, NULL, NULL, '5', '22', '260', '185', 33, 1, NULL, NULL, 0, 1, 34, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(78, 'Retail- usecase 2', 1, NULL, NULL, NULL, '5', '56', '335', '185', 33, 1, NULL, NULL, 0, 1, 33, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(79, 'U1 - Shopping home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(80, 'U1 - Shopping backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(81, 'U1 - Shopping forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 34, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(82, 'U1 - Cart view home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(83, 'U1 - Cart view backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(84, 'U1 - Cart view forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 35, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(85, 'U1 - Message', 1, NULL, NULL, NULL, '15', '45', '245', '180', 36, NULL, '18', '19', 1, 2, NULL, '19.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(86, 'U1 - Message home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(87, 'U1 - Message backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(88, 'U1 - Message forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 36, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(89, 'U1 - Add to cart', 1, NULL, NULL, NULL, '15', '62', '245', '140', 37, NULL, '30.5', '31.5', 1, 2, NULL, '32', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(90, 'U1 - Add to cart home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(91, 'U1 - Add to cart backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(92, 'U1 - Add to cart forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 37, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(93, 'U1 - Complete purchase', 1, NULL, NULL, NULL, '15', '73', '245', '110', 38, NULL, '35', '36', 1, 2, NULL, '36.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(94, 'U1 - Complete purchase home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(95, 'U1 - Complete purchase backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(96, 'U1 - Complete purchase forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 38, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(97, 'U1 - Success home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(98, 'U1 - Success purchase backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(99, 'U1 - Success purchase forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 39, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(100, 'U1 - Whatsapp chat', 1, NULL, NULL, NULL, '15', '50', '245', '180', 40, NULL, '47', '48', 1, 2, NULL, '48.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(101, 'U1 - Feedback chat', 1, NULL, NULL, NULL, '15', '57', '245', '180', 40, NULL, '55', '56', 1, 2, NULL, '56.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(102, 'U1 - Whatsapp chat home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(103, 'U1 - Whatsapp chat backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(104, 'U1 - Whatsapp chat forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 40, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(105, 'U1 - Ratings home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(106, 'U1 - Ratings backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(107, 'U1 - Ratings forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 41, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(108, 'U1 - Explore more', 1, NULL, NULL, NULL, '5.5', '22.5', '245', '90', 42, NULL, '70', '73', 1, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(109, 'U1 - Explore more home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 42, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(110, 'U1 - Explore more backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 42, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(111, 'U2 - Options home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 43, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(112, 'U2 - Options backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 43, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(113, 'U2 - Options forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 43, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(114, 'U2 - Consult with experts', 1, NULL, NULL, NULL, '27.5', '31', '245', '160', 44, NULL, '10', '11', 1, 2, NULL, '11.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(115, 'U2 - Initiate video call', 1, NULL, NULL, NULL, '18', '65', '245', '135', 44, NULL, '14.7', '15.5', 1, 2, NULL, '16', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(116, 'U2 - Consult with experts home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(117, 'U2 - Consult with experts backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(118, 'U2 - Consult with experts forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 44, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(119, 'U2 - Add to basket', 1, NULL, NULL, NULL, '18', '63', '245', '155', 45, NULL, '28.5', '29', 1, 2, NULL, '29.8', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(120, 'U2 - Add to basket home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(121, 'U2 - Add to basket backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(122, 'U2 - Add to basket forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 45, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(123, 'U2 - Yes, Waiting item', 1, NULL, NULL, NULL, '18', '41', '245', '195', 46, NULL, '34.5', '35', 1, 2, NULL, '35.5', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(124, 'U2 - Yes, Waiting item home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(125, 'U2 - Yes, Waiting item backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(126, 'U2 - Yes, Waiting item forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 46, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(127, 'U2 - Complete purchase', 1, NULL, NULL, NULL, '18', '74', '245', '125', 47, NULL, '42.6', '43', 1, 2, NULL, '43.2', NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(128, 'U2 - Complete purchase home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 47, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(129, 'U2 - Complete purchase backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 47, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(130, 'U2 - Complete purchase forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 47, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(131, 'U2 - Ratings home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 48, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(132, 'U2 - Ratings backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 48, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(133, 'U2 - Ratings forward', 1, NULL, NULL, NULL, '85', '92.5', '55', '55', 48, 1, NULL, NULL, NULL, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(134, 'U2 - Explore more', 1, NULL, NULL, NULL, '5.5', '22.5', '245', '90', 49, NULL, '52.5', '56', 1, 1, 31, NULL, NULL, '', NULL, NULL, NULL, 3, 0, 0, 0, 0, 0, NULL, NULL),
(135, 'U2 - Explore more home', 1, NULL, NULL, NULL, '5', '92.5', '55', '55', 49, 1, NULL, NULL, NULL, 1, 17, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(136, 'U2 - Explore more backward', 1, NULL, NULL, NULL, '74', '92.5', '55', '55', 49, 1, NULL, NULL, NULL, 1, 29, NULL, NULL, '', NULL, NULL, NULL, 2, 0, 0, 0, 0, 0, NULL, NULL),
(202, 'L - Move - Overview video', NULL, NULL, NULL, NULL, '44', '18.4', '206', '75', 71, 1, NULL, NULL, 0, 1, 72, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(203, 'L - Back - Overview video', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 72, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(204, 'L - Security connectivity & endpoint', NULL, NULL, NULL, NULL, '8', '46.6', '200', '80', 71, 1, NULL, NULL, 0, 1, 73, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(205, 'L - SOTA Updates', NULL, NULL, NULL, NULL, '15.7', '57', '200', '80', 71, 1, '', '', 0, 1, 77, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(206, 'L - Intelligent Connectivity', NULL, NULL, NULL, NULL, '29.5', '55.6', '200', '80', 71, 1, NULL, NULL, 0, 1, 81, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(207, 'L - End-point Security', NULL, NULL, NULL, NULL, '36.5', '45.5', '170', '95', 73, 1, '', '', 0, 1, 74, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27, 18, NULL, NULL),
(208, 'L - Data Privacy and Regulations', NULL, NULL, NULL, NULL, '48.5', '53', '170', '95', 73, 1, NULL, NULL, 0, 1, 75, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 1, 27, 18, NULL, NULL),
(209, 'L - Secure data, Secure network', NULL, NULL, NULL, NULL, '61.3', '72', '170', '95', 73, 1, NULL, NULL, 0, 1, 76, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 1, 27, 18, NULL, NULL),
(210, 'L - Back - Security', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 73, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(211, 'L - Ensuring SOTA success', NULL, NULL, NULL, NULL, '37', '45', '175', '100', 77, 1, NULL, NULL, 0, 1, 78, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18, NULL, NULL),
(212, 'L - Move Renewal Assure', NULL, NULL, NULL, NULL, '47.5', '50', '248', '100', 77, 1, NULL, NULL, 0, 1, 79, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18, NULL, NULL),
(213, 'L - Secure updates', NULL, NULL, NULL, NULL, '46', '67', '192', '100', 77, 1, NULL, NULL, 0, 1, 80, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 25, 18, NULL, NULL),
(214, 'L - Back - SOTA', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 77, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(215, 'L - eSIM hub', NULL, NULL, NULL, NULL, '43', '43', '210', '100', 81, 1, NULL, NULL, 0, 1, 82, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 1, 27.4, 16.3, NULL, NULL),
(216, 'L - Single pane of glass', NULL, NULL, NULL, NULL, '55', '51.5', '195', '105', 81, 1, NULL, NULL, 0, 1, 83, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 1, 27.4, 16.3, NULL, NULL),
(217, 'L - Bring your own agreement', NULL, NULL, NULL, NULL, '36', '57', '195', '100', 81, 1, NULL, NULL, 0, 1, 84, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27.4, 16.3, NULL, NULL),
(218, 'L - Uniterrupted connectivity', NULL, NULL, NULL, NULL, '28.7', '75', '195', '100', 81, 1, NULL, NULL, 0, 1, 85, NULL, NULL, NULL, NULL, NULL, NULL, 7, 0, 0, 1, 27.5, 15.2, NULL, NULL),
(219, 'L - Back - Intelligent connectivity', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 81, 1, NULL, NULL, 0, 1, 71, NULL, NULL, '', NULL, NULL, NULL, 7, 0, 0, 0, 0, 0, NULL, NULL),
(220, 'L - Enhance Car Service', NULL, NULL, NULL, NULL, '5.5', '32', '380', '335', 86, 1, NULL, NULL, 0, 1, 87, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(221, 'L - Enhance Pre-purchase experience', NULL, NULL, NULL, NULL, '51', '32', '420', '335', 86, 1, NULL, NULL, 0, 1, 95, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(222, 'L - U1 - Automatic home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 87, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(223, 'L - U1 - Automatic here backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 87, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(224, 'L - U1 - Automatic here forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 87, 1, NULL, NULL, NULL, 1, 88, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(225, 'L - U1 - IVR call', NULL, NULL, NULL, NULL, '33.5', '68', '345', '240', 88, 0, '2.2', '2.7', 1, 2, NULL, '3', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(226, 'L - U1 - IVR call home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 88, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(227, 'L - U1 - IVR call backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 88, 1, NULL, NULL, NULL, 1, 87, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(228, 'L - U1 - IVR call forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 88, 1, NULL, NULL, NULL, 1, 89, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(229, 'L - U1 -Schedule now', NULL, NULL, NULL, NULL, '43', '31', '300', '210', 89, 0, '3.5', '4', 1, 2, NULL, '4.7', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(230, 'L - U1 - Schedule now home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 89, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(231, 'L - U1 - Schedule now backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 89, 1, NULL, NULL, NULL, 1, 88, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(232, 'L - U1 - Schedule now forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 89, 1, NULL, NULL, NULL, 1, 90, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(233, 'L - U1 - Dent repair', NULL, NULL, NULL, NULL, '43', '30', '280', '260', 90, 0, '5.2', '5.7', 1, 2, NULL, '6.2', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(234, 'L - U1 - Dent repair home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 90, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(235, 'L - U1 - Dent repair backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 90, 1, NULL, NULL, NULL, 1, 89, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(236, 'L - U1 - Dent repair forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 90, 1, NULL, NULL, NULL, 1, 91, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(237, 'L - U1 - Join video chat', NULL, NULL, NULL, NULL, '39', '58', '300', '220', 91, 0, '14.7', '15', 1, 1, 92, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(238, 'L - U1 - Join video chat home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 91, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(239, 'L - U1 - Join video chat backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 91, 1, NULL, NULL, NULL, 1, 90, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(240, 'L - U1 - Join video chat forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 91, 1, NULL, NULL, NULL, 1, 92, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(241, 'L - U1 - video call home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 92, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(242, 'L - U1 - video call backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 92, 1, NULL, NULL, NULL, 1, 91, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(243, 'L - U1 - video call forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 92, 1, NULL, NULL, NULL, 1, 93, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(244, 'L - U1 - ETA home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 93, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(245, 'L - U1 - ETA backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 93, 1, NULL, NULL, NULL, 1, 92, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(246, 'L - U1 - ETA forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 93, 1, NULL, NULL, NULL, 1, 94, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(247, 'L - U1 - Explore more use cases', NULL, NULL, NULL, NULL, '9', '26', '360', '115', 94, 1, NULL, NULL, 0, 1, 86, '', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(248, 'L - U1 - Explore more home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 94, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(249, 'L - U1 - Explore more backward', NULL, '2', NULL, NULL, '94', '92.5', '55', '55', 94, 1, NULL, NULL, NULL, 1, 93, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(250, 'L - U2 - find out more', NULL, NULL, NULL, NULL, '18', '57', '322', '245', 95, 0, '9.5', '10', 1, 1, 96, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(251, 'L - U2 - find out more home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 95, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(252, 'L - U2 - find out more backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 95, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(253, 'L - U2 - find out more forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 95, 1, NULL, NULL, 0, 1, 96, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(254, 'L - U2 - Car brochures', NULL, NULL, NULL, NULL, '44', '38', '300', '235', 96, 0, '3.8', '4', 1, 2, NULL, '5.2', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(255, 'L - U2 - Car brochures home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 96, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(256, 'L - U2 - Car brochures backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 96, 1, NULL, NULL, NULL, 1, 95, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(257, 'L - U2 - Car brochures forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 96, 1, NULL, NULL, NULL, 1, 97, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(258, 'L - U2 - Sendan model 1', NULL, NULL, NULL, NULL, '44', '33', '300', '210', 97, 0, '4', '4.5', 1, 2, NULL, '5.2', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(259, 'L - U2 - Sendan model 1 home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 97, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(260, 'L - U2 - Sendan model 1 backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 97, 1, NULL, NULL, NULL, 1, 96, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(261, 'L - U2 - Sendan model 1 forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 97, 1, NULL, NULL, NULL, 1, 98, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(262, 'L - U2 - Auto co sales rep - video call', NULL, NULL, NULL, NULL, '43', '63', '305', '235', 98, 0, '2.5', '3', 1, 2, NULL, '3.5', NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(263, 'L - U2 - Book test drive', NULL, NULL, NULL, NULL, '43', '64', '310', '245', 98, 0, '12.8', '13.2', 1, 1, 99, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(264, 'L - U2 - Auto co sales rep - video call home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 98, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(265, 'L - U2 - Auto co sales rep - video call backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 98, 1, NULL, NULL, NULL, 1, 97, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(266, 'L - U2 - Auto co sales rep - video call forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 98, 1, NULL, NULL, NULL, 1, 99, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(267, 'L - U2 - Fast query home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 99, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(268, 'L - U2 - Fast query backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 99, 1, NULL, NULL, NULL, 1, 98, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(269, 'L - U2 - Fast query forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 99, 1, NULL, NULL, NULL, 1, 100, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(270, 'L - U2 - Confirmation home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 100, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(271, 'L - U2 - Confirmation backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 100, 1, NULL, NULL, NULL, 1, 99, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(272, 'L - U2 - Confirmation forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 100, 1, NULL, NULL, NULL, 1, 101, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(273, 'L - U2 -  Explore more use cases', NULL, NULL, NULL, NULL, '9', '26', '360', '115', 101, 1, NULL, NULL, 0, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(274, 'L - U2 - Explore more home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 101, 1, NULL, NULL, NULL, 1, 86, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(275, 'L - U2 - Explore more backward', NULL, '2', NULL, NULL, '94', '92.5', '55', '55', 101, 1, NULL, NULL, NULL, 1, 100, NULL, NULL, '', NULL, NULL, NULL, 8, 0, 0, 0, 0, 0, NULL, NULL),
(276, 'L - Retail- usecase 1', NULL, NULL, NULL, NULL, '5', '30', '400', '378', 102, 1, NULL, NULL, 0, 1, 103, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(277, 'L - Retail- usecase 2', NULL, NULL, NULL, NULL, '51', '30', '410', '378', 102, 1, NULL, NULL, 0, 1, 113, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(278, 'L - U1 - Shopping home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 103, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(279, 'L - U1 - Shopping backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 103, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(280, 'L - U1 - Shopping forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 103, 1, NULL, NULL, NULL, 1, 104, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(281, 'L - U1 - Cart view home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 104, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(282, 'L - U1 - Cart view backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 104, 1, NULL, NULL, NULL, 1, 103, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(283, 'L - U1 - Cart view forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 104, 1, NULL, NULL, NULL, 1, 105, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(284, 'L - U1 - Message click', NULL, NULL, NULL, NULL, '19', '32', '425', '300', 105, NULL, '3', '4', 1, 2, NULL, '4.5', NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(285, 'L - U1 - Message home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 105, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(286, 'L - U1 - Message backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 105, 1, NULL, NULL, NULL, 1, 104, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(287, 'L - U1 - Message forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 105, 1, NULL, NULL, NULL, 1, 106, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(288, 'L - U1 - Add to cart click', NULL, NULL, NULL, NULL, '19', '59', '430', '215', 106, NULL, '4.4', '5', 1, 1, 107, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(289, 'L - U1 - Add to cart home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 106, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(290, 'L - U1 - Add to cart backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 106, 1, NULL, NULL, NULL, 1, 105, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(291, 'L - U1 - Add to cart forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 106, 1, NULL, NULL, NULL, 1, 107, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(292, 'L - U1 - Complete purchase click', NULL, NULL, NULL, NULL, '19', '74', '418', '150', 107, NULL, '2', '3', 1, 2, NULL, '3.5', NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(293, 'L - U1 - Complete purchase home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 107, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(294, 'L - U1 - Complete purchase backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 107, 1, NULL, NULL, NULL, 1, 106, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(295, 'L - U1 - Complete purchase forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 107, 1, NULL, NULL, NULL, 1, 108, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(296, 'L - U1 - Support experience home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 108, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(297, 'L - U1 - Support experience backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 108, 1, NULL, NULL, NULL, 1, 107, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(298, 'L - U1 - Support experience forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 108, 1, NULL, NULL, NULL, 1, 109, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(299, 'L - U1 - Support experience click', NULL, NULL, NULL, NULL, '19', '39', '430', '275', 108, NULL, '7.2', '8', 1, 1, 109, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(300, 'L - U1 - Chat with agent home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 109, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(301, 'L - U1 - Chat with agent  backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 109, 1, NULL, NULL, NULL, 1, 108, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(302, 'L - U1 - Chat with agent forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 109, 1, NULL, NULL, NULL, 1, 110, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(303, 'L - U1 - Collect feedback home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 110, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(304, 'L - U1 - Collect feedback backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 110, 1, NULL, NULL, NULL, 1, 109, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(305, 'L - U1 - Collect feedback forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 110, 1, NULL, NULL, NULL, 1, 111, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(306, 'L - U1 - Process request home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 111, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(307, 'L - U1 - Process request backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 111, 1, NULL, NULL, NULL, 1, 110, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(308, 'L - U1 - Process request forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 111, 1, NULL, NULL, NULL, 1, 112, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(309, 'L - U1 - Explore more click', NULL, NULL, NULL, NULL, '43.5', '28.5', '525', '120', 112, NULL, '4', '9', 1, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(310, 'L - U1 - Explore more home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 112, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(311, 'L - U1 - Explore more backward', NULL, '2', NULL, NULL, '94', '92.5', '55', '55', 112, 1, NULL, NULL, NULL, 1, 111, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(312, 'L - U2 - Options click', NULL, NULL, NULL, NULL, '62', '22', '395', '345', 113, NULL, '6', '7', 1, 2, NULL, '7.5', NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(313, 'L - U2 - Options home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 113, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(314, 'L - U2 - Options backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 113, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(315, 'L - U2 - Options forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 113, 1, NULL, NULL, NULL, 1, 114, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(316, 'L - U2 - Initiate video call click', NULL, NULL, NULL, NULL, '62', '56', '395', '225', 113, NULL, '13.3', '14', 1, 1, 114, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(317, 'L - U2 - 2 way virtual basket click', NULL, NULL, NULL, NULL, '61', '55', '415', '230', 114, NULL, '14.2', '16', 1, 1, 115, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(318, 'L - U2 - 2 way virtual basket home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 114, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(319, 'L - U2 - 2 way virtual basket backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 114, 1, NULL, NULL, NULL, 1, 113, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(320, 'L - U2 - 2 way virtual basket forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 114, 1, NULL, NULL, NULL, 1, 115, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(321, 'L - U2 - Complete purchase click', NULL, NULL, NULL, NULL, '61', '65', '415', '230', 115, NULL, '7.9', '8.8', 1, 2, NULL, '9', NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(322, 'L - U2 - Complete purchase home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 115, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(323, 'L - U2 - Complete purchase backward', NULL, '2', NULL, NULL, '90', '92.5', '55', '55', 115, 1, NULL, NULL, NULL, 1, 114, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(324, 'L - U2 - Complete purchase forward', NULL, '3', NULL, NULL, '94', '92.5', '55', '55', 115, 1, NULL, NULL, NULL, 1, 116, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(325, 'L - U2 - Explore more click', NULL, NULL, NULL, NULL, '42.5', '28.5', '538', '124', 116, NULL, '4', '9', 1, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(326, 'L - U2 - Explore more home', NULL, '1', NULL, NULL, '3', '92.5', '55', '55', 116, 1, NULL, NULL, NULL, 1, 102, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL),
(327, 'L - U2 - Explore more backward', NULL, '2', NULL, NULL, '94', '92.5', '55', '55', 116, 1, NULL, NULL, NULL, 1, 115, NULL, NULL, '', NULL, NULL, NULL, 9, 0, 0, 0, 0, 0, NULL, NULL);

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

--
-- 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,
  `icon_width` varchar(10) DEFAULT NULL,
  `icon_height` varchar(10) 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,
  `text_left_pos` varchar(10) DEFAULT NULL,
  `text_top_pos` varchar(10) DEFAULT NULL,
  `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) DEFAULT NULL,
  `zoom_in_top_per` float DEFAULT NULL,
  `zoom_in_left_per` float DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  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`, `icon_width`, `icon_height`, `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`, `text_left_pos`, `text_top_pos`, `ref_video_id`, `open_in_pop_up`, `action_video_loop`, `open_in_zoom_in`, `zoom_in_top_per`, `zoom_in_left_per`, `video_language_id`, `modified_date_time`) VALUES
(1, 'First', 1, NULL, '34', '34', '10', '50', 1, 1, '', '', 0, 3, 1, '2', 'https://www.google.com/', '1.svg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna.', '5', '50', 1, 0, 1, 0, 10, 20, NULL, '2023-08-21 15:56:37.568'),
(2, 'Second', 1, '0', '34', '34', '20', '85', 1, 1, NULL, NULL, 0, 5, NULL, NULL, 'https://www.google.com/', 'image-bg.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '48', '75', 1, 0, 0, 0, NULL, NULL, NULL, '2023-08-21 15:56:37.568');

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

--
-- 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,
  `image_file` varchar(25) DEFAULT NULL,
  `is_image_uploaded` tinyint(1) DEFAULT NULL,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) 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,
  `add_class` varchar(40) DEFAULT NULL,
  `add_css` varchar(500) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_image`
--

INSERT INTO `video_image` (`id`, `title`, `image_file`, `is_image_uploaded`, `x_axis_start`, `y_axis_start`, `image_width`, `padding`, `margin`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `ref_video_id`, `add_class`, `add_css`, `video_language_id`, `modified_date_time`) VALUES
(1, 'image1', '1.svg', 1, '68', '30', 20, 10, 10, 1, 1, '1', '2', 0, 1, 'imgt', '    font-size: 29rem;\r\n    line-height: 29rem;\r\n    color: white;', 0, '2023-08-21 15:57:16.846'),
(2, 'image2', 'image-panel.jpg', 0, '20', '20', 30, 10, 10, 1, 1, NULL, NULL, 0, 1, NULL, NULL, 0, '2023-08-21 15:57:16.846');

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

--
-- 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,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`video_language_id`),
  KEY `f_video_id_idx` (`video_id`),
  KEY `f_language_id_idx` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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,
  `icon_width` varchar(10) DEFAULT NULL,
  `icon_height` varchar(10) 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: open in new tab, 2: open in popup',
  `action_url` varchar(500) DEFAULT NULL,
  `ref_video_id` varchar(45) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_link`
--

INSERT INTO `video_link` (`id`, `title`, `default_icon`, `icon`, `icon_width`, `icon_height`, `x_axis_start`, `y_axis_start`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `onclick_action`, `action_url`, `ref_video_id`, `video_language_id`, `modified_date_time`) VALUES
(1, 'test', 0, '', '50', '50', '10', '10', 1, 1, NULL, NULL, 0, 0, 'http://www.google.com/', '1', 0, '2023-08-21 15:58:15.213'),
(2, 'te2st', 0, '', '10', '50', '10', '20', 1, 1, NULL, NULL, 0, 1, 'https://w3schools.com/', '1', 0, '2023-08-21 15:58:15.213'),
(3, 'te3', 0, '', '60', '60', '10', '30', 1, 1, NULL, NULL, 0, 2, 'http://localhost/product-interactive-video/frontend/index.php?v=1', '1', 0, '2023-08-21 15:58:15.213');

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

--
-- 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,
  `media_name` varchar(255) DEFAULT NULL,
  `media_path` varchar(400) 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',
  `video_language_id` int(11) DEFAULT NULL,
  `Date modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `video_media` (`id`, `title`, `media_name`, `media_path`, `ref_video_id`, `on_end_media_type`, `on_end_media_id`, `show_play_pause_btn`, `replay_btn`, `video_language_id`, `Date modified`) VALUES
(1, 'Clip 1', 'video.mp4', 'video.mp4', '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(2, 'Clip 2', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(3, 'Clip 3', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(4, 'Clip 4', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(5, 'Clip 5', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(6, 'Clip 6', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(7, 'Clip 7', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(8, 'Clip 8', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(9, 'Clip 9', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(10, 'Clip 10', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(11, 'Clip 11', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(12, 'Clip 12', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(13, 'Clip 13', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(14, 'Clip 14', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(15, 'Clip 15', 'mp4', NULL, '1', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(16, 'Clip 16', 'mp4', NULL, '1', NULL, NULL, 1, 0, NULL, '2023-08-17 05:13:30'),
(17, 'Clip 17', 'mp4', NULL, '2', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(18, 'Clip 18', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(19, 'Clip 19', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(20, 'Clip 20', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(21, 'Clip 21', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(22, 'Clip 22', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(23, 'Clip 23', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(24, 'Clip 24', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(25, 'Clip 25', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(26, 'Clip 26', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(27, 'Clip 27', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(28, 'Clip 28', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(29, 'Clip 29', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(31, 'Clip 31', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(32, 'Clip 32', 'mp4', NULL, '2', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(33, 'Clip 33', 'mp4', NULL, '3', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(34, 'Clip 34', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(35, 'Clip 35', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(36, 'Clip 36', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(37, 'Clip 37', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(38, 'Clip 38', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(39, 'Clip 39', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(40, 'Clip 40', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(41, 'Clip 41', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(42, 'Clip 42', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(43, 'Clip 43', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(44, 'Clip 44', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(45, 'Clip 45', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(46, 'Clip 46', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(47, 'Clip 47', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(48, 'Clip 48', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(49, 'Clip 49', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(50, 'Clip 50', 'mp4', NULL, '3', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(71, 'Clip 71', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(72, 'Clip 72', 'mp4', NULL, '7', NULL, NULL, 1, 0, NULL, '2023-08-17 05:13:30'),
(73, 'Clip 73', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(74, 'Clip 74', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(75, 'Clip 75', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(76, 'Clip 76', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(77, 'Clip 77', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(78, 'Clip 78', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(79, 'Clip 79', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(80, 'Clip 80', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(81, 'Clip 81', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(82, 'Clip 82', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(83, 'Clip 83', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(84, 'Clip 84', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(85, 'Clip 85', 'mp4', NULL, '7', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(86, 'Clip 86', 'mp4', NULL, '8', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(87, 'Clip 87', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(88, 'Clip 89', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(89, 'Clip 90', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(90, 'Clip 91', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(91, 'Clip 92', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(92, 'Clip 93', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(93, 'Clip 94', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(94, 'Clip 95', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(95, 'Clip 96', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(96, 'Clip 97', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(97, 'Clip 98', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(98, 'Clip 98', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(99, 'Clip 99', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(100, 'Clip 100', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(101, 'Clip 101', 'mp4', NULL, '8', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(102, 'Clip 102', 'mp4', NULL, '9', NULL, NULL, 0, 0, NULL, '2023-08-17 05:13:30'),
(103, 'Clip 103', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(104, 'Clip 104', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(105, 'Clip 105', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(106, 'Clip 106', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(107, 'Clip 107', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(108, 'Clip 108', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(109, 'Clip 109', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(110, 'Clip 110', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(111, 'Clip 111', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(112, 'Clip 112', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(113, 'Clip 113', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(114, 'Clip 114', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(115, 'Clip 115', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30'),
(116, 'Clip 116', 'mp4', NULL, '9', NULL, NULL, 0, 1, NULL, '2023-08-17 05:13:30');

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

--
-- Table structure for table `video_picture`
--

DROP TABLE IF EXISTS `video_picture`;
CREATE TABLE IF NOT EXISTS `video_picture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `picture_file` varchar(25) DEFAULT NULL,
  `is_picture_uploaded` tinyint(1) DEFAULT NULL,
  `x_axis_start` varchar(10) DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `video_width` int(11) DEFAULT NULL,
  `video_height` 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,
  `add_class` varchar(40) DEFAULT NULL,
  `add_css` varchar(500) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_picture`
--

INSERT INTO `video_picture` (`id`, `title`, `picture_file`, `is_picture_uploaded`, `x_axis_start`, `y_axis_start`, `video_width`, `video_height`, `padding`, `margin`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `ref_video_id`, `add_class`, `add_css`, `video_language_id`, `modified_date_time`) VALUES
(1, 'video1', '1.mp4', 1, '40', '20', 50, 50, 10, 10, 1, 1, '1', '', 0, 1, 'vd-g', NULL, NULL, '2023-08-21 15:58:50.537');

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

--
-- Table structure for table `video_question`
--

DROP TABLE IF EXISTS `video_question`;
CREATE TABLE IF NOT EXISTS `video_question` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `question_text` varchar(255) DEFAULT NULL,
  `answer_text` json NOT NULL,
  `x_axis_start` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_estonian_ci DEFAULT NULL,
  `y_axis_start` varchar(10) DEFAULT NULL,
  `width` varchar(10) DEFAULT NULL,
  `height` varchar(10) DEFAULT NULL,
  `padding` int(10) DEFAULT NULL,
  `margin` int(10) DEFAULT NULL,
  `font_size` int(10) DEFAULT '20',
  `font_weight` varchar(10) DEFAULT NULL,
  `font_color` varchar(40) DEFAULT NULL,
  `background_color` varchar(40) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `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) NOT NULL DEFAULT '1' COMMENT '1: goto video, 2: goto time, 3: goto url, 4:show image, 5:show text, 6: show text+ image 7: goto question	',
  `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,
  `text_left_pos` varchar(10) NOT NULL,
  `text_top_pos` varchar(10) NOT NULL,
  `action_question_id` int(11) DEFAULT NULL,
  `action_video_loop` tinyint(1) NOT NULL DEFAULT '0',
  `ref_video_id` int(11) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_question`
--

INSERT INTO `video_question` (`id`, `question_text`, `answer_text`, `x_axis_start`, `y_axis_start`, `width`, `height`, `padding`, `margin`, `font_size`, `font_weight`, `font_color`, `background_color`, `created_at`, `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`, `text_left_pos`, `text_top_pos`, `action_question_id`, `action_video_loop`, `ref_video_id`, `video_language_id`, `modified_date_time`) VALUES
(1, 'What is the budget allocation level of your company?', '{\"common\": {\"score\": {\"0\": \"1\", \"1\": \"2\", \"2\": \"3\", \"3\": \"4\", \"4\": \"5\", \"5\": \"1\"}}, \"optionsText\": {\"1\": {\"0\": \"No budget allocated\", \"1\": \"Small budget allocated\", \"2\": \"Moderate budget allocated\", \"3\": \"Significant budget allocated\", \"4\": \"Large budget allocated with continuous investments planned\", \"5\": \"Don\'t Know\"}}}', '3', '66', '94', '29.5', 25, 0, 20, '600', NULL, '#ffffffdb', '2023-07-20 22:22:39', 100, 0, '2', '3', 1, 1, 101, '2.5', 'https://www.example.com/', 'usecase-3.png', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. ', '40', '30', 3, 1, 7, NULL, '2023-08-21 15:59:23.760'),
(2, 'What is the budget allocation level?', '{\"common\": {\"score\": {\"0\": \"1\", \"1\": \"2\", \"2\": \"3\", \"3\": \"4\", \"4\": \"5\", \"5\": \"1\"}}, \"optionsText\": {\"2\": {\"0\": \"No budget allocated\", \"1\": \"Small budget allocated\", \"2\": \"Moderate budget allocated\", \"3\": \"Significant budget allocated\", \"4\": \"Large budget allocated with continuous investments planned\", \"5\": \"Don\'t Know\"}}}', '3', '66', '94', '29.5', 25, 0, 20, '600', NULL, '#ffffffdb', '2023-07-20 22:22:39', 100, 0, '0', '1', 0, 1, 102, NULL, NULL, NULL, NULL, '', '', NULL, 0, 7, NULL, '2023-08-21 15:59:23.760'),
(3, 'What is the budget?', '{\"common\": {\"score\": {\"0\": \"1\", \"1\": \"2\", \"2\": \"3\", \"3\": \"4\", \"4\": \"5\", \"5\": \"1\"}}, \"optionsText\": {\"1\": {\"0\": \"No budget allocated\", \"1\": \"Small budget allocated\", \"2\": \"Moderate budget allocated\", \"3\": \"Significant budget allocated\", \"4\": \"Large budget allocated with continuous investments planned\", \"5\": \"Don\'t Know\"}}}', '3', '66', '94', '29.5', 25, 0, 20, '600', NULL, '#ffffffdb', '2023-07-20 22:22:39', 100, 0, '3.2', '5', 1, 7, NULL, '2', 'https://www.example.com/', 'usecase-3.png', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. ', '40', '30', 1, 1, 7, NULL, '2023-08-21 15:59:23.760');

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

--
-- Table structure for table `video_question_response`
--

DROP TABLE IF EXISTS `video_question_response`;
CREATE TABLE IF NOT EXISTS `video_question_response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(40) DEFAULT NULL,
  `question_id` int(11) NOT NULL,
  `response_id` int(11) NOT NULL,
  `response` varchar(400) NOT NULL,
  `score` int(11) NOT NULL,
  `ref_video_id` int(11) NOT NULL,
  `add_date_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `video_language_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_question_response`
--

INSERT INTO `video_question_response` (`id`, `user_id`, `question_id`, `response_id`, `response`, `score`, `ref_video_id`, `add_date_time`, `video_language_id`) VALUES
(12, '1', 1, 2, 'Test', 4, 6, '2023-08-16 21:12:17', NULL),
(13, '2', 1, 2, 'test', 6, 1, '2023-08-16 21:12:17', NULL),
(14, '3', 1, 2, 'test', 6, 1, '2023-08-16 21:12:35', NULL),
(15, '4', 1, 2, 'test', 6, 1, '2023-08-16 21:14:25', NULL),
(16, '5', 1, 2, 'test1', 6, 1, '2023-08-16 21:24:25', NULL),
(17, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:24:40', NULL),
(18, '7', 1, 2, 'test1', 6, 1, '2023-08-16 21:24:56', NULL),
(19, '8', 1, 2, 'test1', 6, 1, '2023-08-16 21:25:17', NULL),
(20, '9', 1, 2, 'test1', 6, 1, '2023-08-16 21:25:54', NULL),
(21, '10', 1, 2, 'test1', 6, 1, '2023-08-16 21:26:46', NULL),
(22, '11', 1, 2, 'test1', 6, 1, '2023-08-16 21:27:24', NULL),
(23, '5', 1, 2, 'test1', 6, 1, '2023-08-16 21:31:42', NULL),
(24, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:32:03', NULL),
(25, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:32:21', NULL),
(26, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:34:18', NULL),
(27, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:35:50', NULL),
(28, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:35:57', NULL),
(29, '6', 1, 2, 'test1', 6, 1, '2023-08-16 21:37:53', NULL);

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

--
-- Table structure for table `video_question_users`
--

DROP TABLE IF EXISTS `video_question_users`;
CREATE TABLE IF NOT EXISTS `video_question_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(40) CHARACTER SET utf8mb4 DEFAULT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 NOT NULL,
  `ref_video_id` int(11) NOT NULL,
  `add_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `user_id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_question_users`
--

INSERT INTO `video_question_users` (`user_id`, `id`, `name`, `email`, `ref_video_id`, `add_date_time`) VALUES
(1, NULL, 'test', 'test@gmail.com', 0, '2023-05-08 08:47:40.795'),
(9, NULL, 'User1', 'testNew@gmail.com', 0, '2023-05-08 12:43:37.726'),
(10, NULL, 'test12311', 'Hello2@gmail.com', 0, '2023-05-08 13:14:50.505'),
(11, NULL, 'test', 'test@gmail', 0, '2023-08-14 14:59:49.149'),
(12, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:10:32.542'),
(13, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:11:43.433'),
(14, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:12:52.519'),
(15, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:14:20.865'),
(16, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:14:27.330'),
(17, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:14:58.451'),
(18, NULL, 'test', 'test@gmail', 0, '2023-08-14 15:15:24.075'),
(19, NULL, 'test', 'test@gmail', 0, '2023-08-16 05:04:28.830'),
(20, NULL, 'test', 'test@gmail', 0, '2023-08-16 05:04:32.614'),
(21, NULL, 'test1', 'test@gmail', 0, '2023-08-16 05:04:50.881'),
(22, NULL, 'test11', 'test@gmail1', 0, '2023-08-16 05:57:45.410'),
(23, NULL, 'test11', 'test@gmail1', 7, '2023-08-16 07:20:36.071'),
(24, NULL, 'test11', 'test@gmail1', 8, '2023-08-16 08:50:25.212'),
(25, NULL, 'test11', 'test@gmail1', 8, '2023-08-16 09:26:10.695'),
(26, NULL, 'testnew', 'test@gmail', 9, '2023-08-16 09:26:33.719'),
(27, NULL, 'testnew', 'test@gmail', 9, '2023-08-16 09:30:23.344'),
(28, NULL, 'Test', 'test@a.com', 1, '2023-08-16 16:19:35.904'),
(29, NULL, 'Test', 'test@a.com', 100, '2023-08-16 16:20:32.216'),
(30, NULL, 'Test', 'megha@digitalapple.in', 100, '2023-08-16 16:21:16.364'),
(31, NULL, 'Test', 'megha@digitalapple.in', 100, '2023-08-16 16:21:17.344'),
(32, NULL, 'Test', 'megha@digitalapple.in', 100, '2023-08-16 16:21:18.202'),
(33, NULL, 't', 'tt@gm', 100, '2023-08-16 16:22:02.275'),
(34, NULL, 't', 'tt@gm', 100, '2023-08-16 16:22:03.054'),
(35, NULL, 't', 'tt@gm', 100, '2023-08-16 16:22:03.351'),
(36, NULL, 'Test', 'test@a.com', 100, '2023-08-16 16:23:02.272'),
(37, NULL, 'Hello', 'Hi@gmail.com', 100, '2023-08-16 16:23:31.735'),
(38, NULL, 'Test', 'test@a.com', 100, '2023-08-17 04:38:35.375'),
(40, NULL, 'Test', 'test@gg.com', 100, '2023-08-21 04:49:20.993'),
(41, NULL, 'Hello', 'Hello@g', 100, '2023-08-21 11:42:31.933'),
(42, NULL, 'Test', 'test@a.com', 100, '2023-08-21 14:23:56.879'),
(43, NULL, 'Test', 'test@a11.com', 100, '2023-08-21 15:23:50.194'),
(44, NULL, 'Test', 'test@a.com', 100, '2023-08-21 15:51:38.483'),
(45, NULL, 'Test', 'test@a.com', 100, '2023-08-21 16:01:38.665');

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

--
-- 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,
  `font_color` varchar(10) DEFAULT NULL,
  `line_height` int(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,
  `add_class` varchar(40) DEFAULT NULL,
  `add_css` varchar(500) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_subtitle`
--

INSERT INTO `video_subtitle` (`id`, `subtitle`, `x_axis_start`, `y_axis_start`, `font_size`, `font_color`, `line_height`, `text_box_width`, `padding`, `margin`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `ref_video_id`, `add_class`, `add_css`, `video_language_id`, `modified_date_time`) VALUES
(2, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', '5', '90', '14', '#ffffff', 21, '90', 10, 5, 1, 1, NULL, NULL, 0, 1, 'sub', '', NULL, '2023-08-21 16:00:02.881');

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

--
-- 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(25) DEFAULT NULL,
  `line_height` varchar(10) DEFAULT NULL,
  `font_color` 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,
  `add_class` varchar(40) DEFAULT NULL,
  `add_css` varchar(500) DEFAULT NULL,
  `video_language_id` int(11) DEFAULT NULL,
  `modified_date_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3),
  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`, `line_height`, `font_color`, `text_box_width`, `padding`, `margin`, `video_id`, `show_in_whole_video`, `show_start_time`, `show_end_time`, `pause_video`, `ref_video_id`, `add_class`, `add_css`, `video_language_id`, `modified_date_time`) VALUES
(1, 'accordion-tabs', ' <div id=\"\" class=\"\">\r\n <div class=\"accordion-body\">\r\n Plus relevant, data-driven insights\r\n </div>', '0', '72', '20', '24', 'white', '80', 10, 15, 1, 1, '1', '3', 0, '1', 'text', '    font-size: 29rem;\r\n    line-height: 29rem;\r\n    color: white;', NULL, '2023-08-21 16:00:28.322');

--
-- 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 */;
