File manager - Edit - /home/autoph/public_html/tasks/autoph_cc (12).sql.tar
Back
home/autoph/public_html/tasks/db/autoph_cc (12).sql 0000644 00000206235 15024752625 0016042 0 ustar 00 -- phpMyAdmin SQL Dump -- version 5.0.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 08, 2022 at 10:45 AM -- Server version: 8.0.27 -- PHP Version: 7.4.14 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: `autoph_cc` -- -- -------------------------------------------------------- -- -- Table structure for table `api` -- CREATE TABLE `api` ( `id` int NOT NULL, `address` varchar(255) DEFAULT NULL, `key` varchar(255) DEFAULT NULL, `json_access` text, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `api` -- INSERT INTO `api` (`id`, `address`, `key`, `json_access`, `status`) VALUES (1, 'connect.autohub.ph', '4fdc94ab-6840-11ec-a574-00ff70631b9a', '[2,1,3]', 1); -- -------------------------------------------------------- -- -- Table structure for table `api_generated_keys` -- CREATE TABLE `api_generated_keys` ( `id` int NOT NULL, `key` text, `date_added` datetime DEFAULT NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `status` int DEFAULT NULL, `api_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `api_generated_keys` -- INSERT INTO `api_generated_keys` (`id`, `key`, `date_added`, `timestamp`, `status`, `api_id`) VALUES (27, '24327924313224714777476b57392f56694533775630787874436b6f65746773664a32514f4269415875704f67433070384838632e742e30336c712e', '2021-12-29 13:41:22', '2021-12-29 05:41:22', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `asigned_users` -- CREATE TABLE `asigned_users` ( `id` int NOT NULL, `ticket_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `show_vehicle` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `show_vehicle`, `status`) VALUES (1, 'General', 0, 1), (2, 'Technical Support', 1, 1), (3, 'Pickup & Delivery', 0, 1), (4, 'Vehicle Repair', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_notification_list` -- CREATE TABLE `cnf_notification_list` ( `id` int NOT NULL, `template_id` int DEFAULT NULL, `from_user_id` int DEFAULT NULL, `to_user_id` int DEFAULT NULL, `target_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `is_read` int DEFAULT NULL, `status` int DEFAULT NULL, `type` int DEFAULT NULL COMMENT 'for notif type e.g ticket,kb,vid, etc' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_notification_list` -- INSERT INTO `cnf_notification_list` (`id`, `template_id`, `from_user_id`, `to_user_id`, `target_id`, `date_added`, `is_read`, `status`, `type`) VALUES (139, 3, 2, 4, 80, '2022-01-08 09:21:22', 1, 1, 1), (140, 3, 2, 4, 81, '2022-01-08 09:46:33', 1, 1, NULL), (141, 3, 2, 4, 81, '2022-01-08 09:48:38', 1, 1, NULL), (142, 3, 2, 4, 81, '2022-01-08 09:49:13', 1, 1, NULL), (143, 3, 2, 4, 81, '2022-01-08 09:51:00', 1, 1, NULL), (144, 3, 2, 4, 82, '2022-01-08 09:52:38', 1, 1, NULL), (145, 3, 4, 2, 83, '2022-01-08 09:59:54', 1, 1, NULL), (146, 3, 2, 4, 84, '2022-01-08 10:04:12', 1, 1, 1), (147, 3, 2, 4, 85, '2022-01-08 10:16:03', 1, 1, 1), (148, 4, 4, 2, 84, '2022-01-08 11:42:21', 1, 1, 1), (149, 4, 4, 2, 84, '2022-01-08 11:42:52', 1, 1, 1), (150, 4, 4, 2, 84, '2022-01-08 11:43:38', 1, 1, 1), (151, 4, 4, 2, 84, '2022-01-08 11:45:09', 1, 1, 1), (152, 4, 4, 2, 84, '2022-01-08 11:48:01', 1, 1, 1), (153, 4, 4, 2, 84, '2022-01-08 11:48:04', 1, 1, 1), (154, 4, 4, 2, 84, '2022-01-08 11:56:25', 1, 1, 1), (155, 4, 4, 2, 84, '2022-01-08 11:56:31', 1, 1, 1), (156, 4, 4, 2, 84, '2022-01-08 11:57:07', 1, 1, 1), (157, 4, 4, 2, 84, '2022-01-08 12:08:28', 1, 1, 1), (158, 4, 2, 4, 83, '2022-01-08 12:08:59', 1, 1, 1), (159, 4, 2, 4, 83, '2022-01-08 12:11:11', 1, 1, 1), (160, 4, 2, 4, 83, '2022-01-08 12:11:43', 1, 1, 1), (161, 4, 2, 4, 83, '2022-01-08 12:13:33', 1, 1, 1), (162, 4, 2, 4, 83, '2022-01-08 16:17:51', 1, 1, 1), (163, 4, 2, 4, 83, '2022-01-08 16:23:03', 1, 1, 1), (164, 4, 2, 4, 83, '2022-01-08 16:30:44', 1, 1, 1), (165, 4, 2, 4, 83, '2022-01-08 16:33:48', 1, 1, 1), (166, 4, 2, 4, 83, '2022-01-08 16:36:21', 1, 1, 1), (167, 3, 4, 2, 86, '2022-01-08 17:41:57', 0, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_notification_templates` -- CREATE TABLE `cnf_notification_templates` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `description` longtext, `type` int DEFAULT NULL, `is_active` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_notification_templates` -- INSERT INTO `cnf_notification_templates` (`id`, `name`, `description`, `type`, `is_active`, `status`) VALUES (1, 'Create Ticket Expert SMS Notification', '<user> Created a ticket,\nTitle: <title>\nCase ID: <ref_no>\nBrand: <brand>\nModel: <model>\nPriority: <priority>', NULL, 1, 1), (2, 'Reply Ticket SMS Notification', '<user> reply to your ticket <title>\nRef. no.: <ref_no>', NULL, 1, 1), (3, 'Create Ticket Expert System Notification', '<user> create <brand> ticket <title>', NULL, 1, 1), (4, 'Reply Ticket System Notification', '<user> reply to your ticket (<title>)', NULL, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_roles` -- CREATE TABLE `cnf_roles` ( `id` int NOT NULL, `name` varchar(255) DEFAULT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_roles` -- INSERT INTO `cnf_roles` (`id`, `name`, `user_id`, `date_added`, `status`) VALUES (1, 'TEST 1', 1, '2021-12-10 15:01:45', 0), (2, 'TEST 2', 1, '2021-12-10 15:03:52', 0), (3, 'TEST 3', 1, '2021-12-10 15:05:38', 0), (4, 'TEST 4', 1, '2021-12-10 15:06:56', 0), (5, 'TEST1', 1, '2021-12-10 16:05:29', 1), (6, 'SDFSDF', 1, '2021-12-10 16:49:39', 0), (7, 'TEST 6', 1, '2021-12-10 16:50:28', 0), (8, 'TEST 7', 1, '2021-12-10 16:57:52', 0), (9, 'TEST 54', 1, '2021-12-10 20:05:08', 1), (10, 'TEST 1', 1, '2021-12-11 09:22:17', 1), (11, 'SADASDASDS', 1, '2021-12-11 09:23:39', 1), (12, 'TEST 1ASD', 1, '2021-12-11 09:24:25', 1), (13, 'ADMIN', 1, '2021-12-11 09:29:56', 1), (14, 'AAAAA', 1, '2021-12-11 09:30:27', 1), (15, 'ZXCZ', 1, '2021-12-11 15:20:07', 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_role_access` -- CREATE TABLE `cnf_role_access` ( `id` int NOT NULL, `role_id` int NOT NULL, `json_access` longtext, `json_brand` longtext, `json_dealer` longtext, `user_category_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_role_access` -- INSERT INTO `cnf_role_access` (`id`, `role_id`, `json_access`, `json_brand`, `json_dealer`, `user_category_id`) VALUES (2, 1, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, NULL), (3, 2, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, 1), (4, 3, '{\"1\":[\"1_1\",\"1_2\"],\"2\":[\"2_1\",\"2_2\"],\"3\":[\"3_1\",\"3_2\",\"3_3\",\"3_4\"],\"4\":[\"4_1\",\"4_2\"],\"5\":[\"5_1\",\"5_2\"]}', NULL, NULL, 2), (5, 4, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, 2), (6, 5, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', NULL, '', 2), (7, 6, '{\"1\":[\"1_1\"],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, 1), (8, 7, '{\"1\":[\"1_1\",\"1_2\"],\"2\":[\"2_1\"],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, 1), (9, 8, '{\"1\":[\"1_1\",\"1_2\"],\"2\":[\"2_1\"],\"3\":[],\"4\":[],\"5\":[]}', NULL, NULL, 2), (10, 9, '{\"1\":[\"1_1\",\"1_2\"],\"2\":[\"2_1\"],\"3\":[],\"4\":[],\"5\":[]}', NULL, '', 1), (11, 10, '{\"1\":[\"1_1\",\"1_2\"],\"2\":[\"2_1\",\"2_2\"],\"3\":[\"3_1\",\"3_2\",\"3_3\",\"3_4\"],\"4\":[\"4_1\",\"4_2\"],\"5\":[\"5_1\",\"5_2\"]}', '[\"2\",\"1\"]', NULL, 1), (12, 11, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', '[\"2\"]', NULL, 1), (13, 12, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', '[\"1\"]', NULL, 1), (14, 13, '{\"1\":[\"1_1\",\"1_5\",\"1_2\",\"1_3\",\"1_4\"],\"2\":[\"2_1\",\"2_2\"],\"3\":[\"3_1\",\"3_2\",\"3_4\",\"3_3\",\"3_5\",\"3_7\"],\"4\":[\"4_1\",\"4_2\"],\"5\":[\"5_1\",\"5_2\"]}', '[\"121\",\"122\",\"123\",\"124\",\"125\",\"126\",\"127\",\"128\",\"129\",\"130\",\"131\",\"134\",\"135\",\"133\",\"132\",\"136\",\"137\",\"138\"]', NULL, 2), (15, 14, '{\"1\":[],\"2\":[\"2_1\",\"2_2\"],\"3\":[\"3_1\",\"3_2\",\"3_4\",\"3_3\",\"3_5\"],\"4\":[\"4_1\",\"4_2\"],\"5\":[\"5_1\",\"5_2\"]}', '[\"2\"]', NULL, 2), (16, 15, '{\"1\":[],\"2\":[],\"3\":[],\"4\":[],\"5\":[]}', '[\"2\"]', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_sms_api` -- CREATE TABLE `cnf_sms_api` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `base_url` longtext, `json_parameters` longtext, `sent_response` varchar(45) DEFAULT NULL, `is_activated` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_sms_api` -- INSERT INTO `cnf_sms_api` (`id`, `name`, `base_url`, `json_parameters`, `sent_response`, `is_activated`, `status`) VALUES (1, 'iTextMo', 'https://www.itexmo.com/php_api/api.php', '{\"1\":\"[no]\",\"2\":\"[msg]\",\"3\":\"PR-AUTOH172111_IE74I\",\"passwd\":\"me}vfe3j#c\"}', '0', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_sms_templates` -- CREATE TABLE `cnf_sms_templates` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `description` longtext, `type` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_sms_templates` -- INSERT INTO `cnf_sms_templates` (`id`, `name`, `description`, `type`, `status`) VALUES (1, 'Expert Notification', '<user>', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `cnf_system` -- CREATE TABLE `cnf_system` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `value` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `cnf_system` -- INSERT INTO `cnf_system` (`id`, `name`, `value`) VALUES (1, 'url', 'https://localhost/AutoHub-CC/'), (2, 'is_maintenance', '0'), (3, 'name', 'T.A.S.K.S'), (4, 'favicon', 'fav3.png'); -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` int NOT NULL, `name` varchar(100) DEFAULT NULL, `code` varchar(45) DEFAULT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `source_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `companies` -- INSERT INTO `companies` (`id`, `name`, `code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (1, 'Global City Autosales Inc', 'GCASI', NULL, '2021-12-11 18:45:20', 1, 16), (2, 'Autohub Group of Companies Inc.', 'AHG', NULL, '2021-12-13 09:58:42', 1, 11); -- -------------------------------------------------------- -- -- Table structure for table `dealers` -- CREATE TABLE `dealers` ( `id` int NOT NULL, `company_id` int DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `code` varchar(45) DEFAULT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `source_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `dealers` -- INSERT INTO `dealers` (`id`, `company_id`, `name`, `code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (1, 1, 'FORD GLOBAL', 'FGC', NULL, '2021-12-11 18:56:04', 1, 5), (2, 2, 'AUTOHUB GROUP INC', 'AHGI', NULL, '2021-12-13 09:58:42', 1, 44); -- -------------------------------------------------------- -- -- Table structure for table `knowledgebase` -- CREATE TABLE `knowledgebase` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `sub_category_id` int DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` longtext, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `knowledgebase` -- INSERT INTO `knowledgebase` (`id`, `user_id`, `sub_category_id`, `title`, `description`, `date_added`, `status`) VALUES (24, 2, 7, 'asdasdsad', '<p>asdsadsadsa</p>', '2022-01-07 21:32:46', 1), (25, 2, 6, 'dfdsfdsfdsf', '<p>dsfdsfsfsdfsdfs</p>', '2022-01-07 22:56:17', 1); -- -------------------------------------------------------- -- -- Table structure for table `knowledgebase_attachments` -- CREATE TABLE `knowledgebase_attachments` ( `id` int NOT NULL, `knowledgebase_id` int DEFAULT NULL, `attachment_name` varchar(45) DEFAULT NULL, `original_name` varchar(255) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `knowledgebase_attachments` -- INSERT INTO `knowledgebase_attachments` (`id`, `knowledgebase_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES (11, 25, 'f74c5e95-6fc9-11ec-8e00-00ff70631b9a.txt', 'Clearance.txt', '2022-01-07 22:56:17', 1); -- -------------------------------------------------------- -- -- Table structure for table `knowledgebase_tags` -- CREATE TABLE `knowledgebase_tags` ( `id` int NOT NULL, `knowledgebase_id` int DEFAULT NULL, `tag` varchar(255) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `knowledgebase_type_vehicles` -- CREATE TABLE `knowledgebase_type_vehicles` ( `id` int NOT NULL, `knowledgebase_id` int DEFAULT NULL, `brand_id` int DEFAULT NULL, `model_id` int DEFAULT NULL, `model_variant_id` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `knowledgebase_type_vehicles` -- INSERT INTO `knowledgebase_type_vehicles` (`id`, `knowledgebase_id`, `brand_id`, `model_id`, `model_variant_id`, `status`) VALUES (16, 24, 124, 831, 129, 1), (17, 25, NULL, NULL, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `knowledgebase_views` -- CREATE TABLE `knowledgebase_views` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `knowledgebase_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `priority_levels` -- CREATE TABLE `priority_levels` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `level` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `priority_levels` -- INSERT INTO `priority_levels` (`id`, `name`, `level`, `status`) VALUES (1, 'Info', 1, 1), (2, 'Reply Requested', 2, 1), (3, 'Urgent', 3, 1); -- -------------------------------------------------------- -- -- Table structure for table `sub_categories` -- CREATE TABLE `sub_categories` ( `id` int NOT NULL, `category_id` int DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `sub_categories` -- INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `status`) VALUES (1, 1, 'Other', 1), (2, 2, 'Engine', 0), (3, 2, 'Aircon', 0), (4, 2, 'Body and Trim', 1), (5, 2, 'Chassis and Suspension', 1), (6, 2, 'Connected/Digital Services', 1), (7, 2, 'Electrics/Electronics', 1), (8, 2, 'High Voltage', 1), (9, 2, 'Powertrain', 1), (10, 2, 'Programming', 1), (11, 2, 'Rider Equipment/Accessories', 1), (12, 2, 'SNOOP', 1), (13, 2, 'Transmission', 1); -- -------------------------------------------------------- -- -- Table structure for table `tickets` -- CREATE TABLE `tickets` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `sub_category_id` int DEFAULT NULL, `priority_level_id` int DEFAULT NULL, `reference_no` int DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` longtext, `date_added` datetime DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `tickets` -- INSERT INTO `tickets` (`id`, `user_id`, `sub_category_id`, `priority_level_id`, `reference_no`, `title`, `description`, `date_added`, `type`, `status`) VALUES (80, 2, 5, 2, 1080, 'Test 1 for notification', '', '2022-01-08 09:21:22', NULL, 1), (81, 2, 4, 2, 1081, 'test 2 for sms notif', '', '2022-01-08 09:51:00', NULL, 1), (82, 2, 4, 2, 1082, 'test 3 for sms notif', '', '2022-01-08 09:52:38', NULL, 1), (83, 4, 4, 2, 1083, 'test 4 for sms notif', '', '2022-01-08 09:59:54', NULL, 4), (84, 2, 4, 2, 1084, 'test 5 for sms notif', '', '2022-01-08 10:04:12', NULL, 1), (85, 2, 4, 2, 1085, 'test 6 for sms notif', '', '2022-01-08 10:16:03', NULL, 1), (86, 4, 4, 2, 1086, 'test info ticket', '', '2022-01-08 17:41:57', NULL, 1), (87, 4, 4, 1, 1087, 'test info ticket 2', '', '2022-01-08 17:43:40', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_attachments` -- CREATE TABLE `ticket_attachments` ( `id` int NOT NULL, `ticket_id` int DEFAULT NULL, `attachment_name` varchar(45) DEFAULT NULL, `original_name` varchar(255) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_attachments` -- INSERT INTO `ticket_attachments` (`id`, `ticket_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES (93, 80, '6b49aac9-7020-11ec-92b3-00ff70631b9a.txt', 'company groups.txt', '2022-01-08 09:20:51', 1), (94, 81, 'c7ac5b7a-7024-11ec-92b3-00ff70631b9a.xlsx', 'Service.xlsx', '2022-01-08 09:46:22', 1), (95, 82, 'a4e2f13e-7025-11ec-92b3-00ff70631b9a.xlsx', 'OFFICIAL EPF_ANDAYA, CLARENEC_2ND SEM 2021_09.18.2021.xlsx', '2022-01-08 09:52:34', 1), (96, 84, '4290fb6a-7027-11ec-92b3-00ff70631b9a.txt', 'places.txt', '2022-01-08 10:04:07', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_progress_status` -- CREATE TABLE `ticket_progress_status` ( `id` int NOT NULL, `ticket_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `ticket_status_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_progress_status` -- INSERT INTO `ticket_progress_status` (`id`, `ticket_id`, `user_id`, `ticket_status_id`, `date_added`, `status`) VALUES (9, 80, 2, 1, '2022-01-08 09:14:44', 1), (10, 81, 2, 1, '2022-01-08 09:45:53', 1), (11, 82, 2, 1, '2022-01-08 09:52:04', 1), (12, 83, 4, 1, '2022-01-08 09:59:41', 1), (13, 84, 2, 1, '2022-01-08 10:03:51', 1), (14, 85, 2, 1, '2022-01-08 10:15:40', 1), (16, 84, 4, 2, '2022-01-08 12:07:16', 1), (17, 83, 2, 2, '2022-01-08 12:08:59', 1), (18, 82, 2, 2, '2022-01-08 16:41:09', 1), (19, 83, 4, 3, '2022-01-08 17:32:47', 1), (20, 83, 4, 2, '2022-01-08 17:32:52', 1), (21, 83, 4, 5, '2022-01-08 17:32:54', 1), (22, 83, 4, 4, '2022-01-08 17:32:59', 1), (23, 83, 4, 3, '2022-01-08 17:33:01', 1), (24, 83, 4, 4, '2022-01-08 17:33:10', 1), (25, 83, 4, 3, '2022-01-08 17:33:12', 1), (26, 83, 4, 5, '2022-01-08 17:33:22', 1), (27, 83, 4, 4, '2022-01-08 17:33:24', 1), (28, 83, 4, 2, '2022-01-08 17:33:25', 1), (29, 80, 4, 4, '2022-01-08 17:34:19', 1), (30, 80, 4, 2, '2022-01-08 17:34:20', 1), (31, 86, 4, 1, '2022-01-08 17:41:49', 1), (32, 87, 4, 1, '2022-01-08 17:43:32', 1), (33, 87, 4, 3, '2022-01-08 17:43:40', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_replies` -- CREATE TABLE `ticket_replies` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `ticket_id` int DEFAULT NULL, `description` longtext, `ticket_status_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_replies` -- INSERT INTO `ticket_replies` (`id`, `user_id`, `ticket_id`, `description`, `ticket_status_id`, `date_added`, `status`) VALUES (73, 4, 84, 'testsdf', 2, '2022-01-08 12:07:16', 1), (74, 4, 84, 'dsdsds', 2, '2022-01-08 12:08:28', 1), (75, 2, 83, 'asdasdasda', 2, '2022-01-08 12:08:59', 1), (76, 2, 83, 'test', 2, '2022-01-08 12:11:11', 1), (77, 2, 83, 'test', 2, '2022-01-08 12:11:43', 1), (78, 2, 83, 'test reply', 2, '2022-01-08 12:13:33', 1), (79, 4, 83, 'asdsa', 2, '2022-01-08 15:47:19', 1), (80, 4, 83, 'test\nasdas', 2, '2022-01-08 16:17:10', 1), (81, 2, 83, 'test\nsdsdsdds', 2, '2022-01-08 16:17:51', 1), (82, 4, 83, NULL, 2, '2022-01-08 16:22:32', 1), (83, 2, 83, NULL, 2, '2022-01-08 16:23:03', 1), (84, 4, 83, 'meow\nsdsd', 2, '2022-01-08 16:26:46', 1), (85, 2, 83, 'asdsa', 2, '2022-01-08 16:30:44', 1), (86, 2, 83, 'asdasdd', 2, '2022-01-08 16:33:48', 1), (87, 4, 83, 'testdfsafs', 2, '2022-01-08 16:34:52', 1), (88, 2, 83, 'test', 2, '2022-01-08 16:36:21', 1), (89, 4, 83, 'meow', 2, '2022-01-08 16:37:37', 1), (90, 2, 82, 'tets', 2, '2022-01-08 16:41:09', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_reply_attachments` -- CREATE TABLE `ticket_reply_attachments` ( `id` int NOT NULL, `ticket_reply_id` int DEFAULT NULL, `attachment_name` varchar(45) DEFAULT NULL, `original_name` varchar(255) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_reply_attachments` -- INSERT INTO `ticket_reply_attachments` (`id`, `ticket_reply_id`, `attachment_name`, `original_name`, `status`) VALUES (15, 79, '34e07a17-7057-11ec-92b3-00ff70631b9a.xlsx', 'Service.xlsx', 1), (16, 82, '2083241b-705c-11ec-92b3-00ff70631b9a.txt', 'places.txt', 1), (17, 83, '329ec1f1-705c-11ec-92b3-00ff70631b9a.docx', 'ANDAYA WFH 12-24-21.docx', 1), (18, 83, '32a128c0-705c-11ec-92b3-00ff70631b9a.jpg', 'PSA Cert.jpg', 1), (19, 83, '32cf825a-705c-11ec-92b3-00ff70631b9a.pdf', 'ANDAYA WFH 12-11-21.pdf', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_status` -- CREATE TABLE `ticket_status` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `level` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_status` -- INSERT INTO `ticket_status` (`id`, `name`, `level`, `status`) VALUES (1, 'On Hold', 1, 1), (2, 'In Progress', 2, 1), (3, 'Close', 5, 1), (4, 'Escalated (In Progress)', 3, 1), (5, 'Escalated (Close)', 4, 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_type_vehicles` -- CREATE TABLE `ticket_type_vehicles` ( `id` int NOT NULL, `ticket_id` int DEFAULT NULL, `model_id` int DEFAULT NULL, `plate_number` varchar(45) DEFAULT NULL, `conduction_sticker` varchar(45) DEFAULT NULL, `plate_cs` varchar(45) DEFAULT NULL, `vin` varchar(255) DEFAULT NULL, `year_model` varchar(45) DEFAULT NULL, `model_variant_id` int DEFAULT NULL, `mileage` varchar(45) DEFAULT NULL, `complaint` text, `work_performed` text, `fault_codes` text, `breakdown` int DEFAULT NULL, `on_site` int DEFAULT NULL, `workshop_visit_count` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `ticket_type_vehicles` -- INSERT INTO `ticket_type_vehicles` (`id`, `ticket_id`, `model_id`, `plate_number`, `conduction_sticker`, `plate_cs`, `vin`, `year_model`, `model_variant_id`, `mileage`, `complaint`, `work_performed`, `fault_codes`, `breakdown`, `on_site`, `workshop_visit_count`, `status`) VALUES (58, 80, 797, NULL, NULL, 'ABC123', 'XYZ123', '2021', 130, '12', 'lorem\nipsum\ndolor', 'lorem\nipsum\ndolor', 'c1,c2,c3', NULL, 1, 12, 1), (59, 81, 797, NULL, NULL, 'CDE321', 'VN34232', '2034', 131, '122', 'lorem\nipsum\ndolor\namet', 'lore\ndolor\namet', 'c5,c6', NULL, 1, 3, 1), (60, 82, 797, NULL, NULL, 'CDF123', 'VJMWDWE', '2022', 132, '54', 'lorem\n\namet', 'lorem \n\nipsum', 'c67,c23,c23', NULL, 1, 34, 1), (61, 83, 830, NULL, NULL, 'ABC12323', 'ASDASDAS', NULL, NULL, '343', 'loremm\nipusin', 'loremm\nipusin', NULL, NULL, 1, NULL, 1), (62, 84, 797, NULL, NULL, 'CBN341', 'DFSA2323', '2021', 133, '561', 'lorem\n\nipss', 'lorem \nips', NULL, NULL, 1, 34, 1), (63, 85, 802, NULL, NULL, 'BSD2332', 'KJDFJKSDF', '3422', 134, '322', 'lorem\nmuspi', 'dta\ngateher', NULL, 1, 1, 23, 1), (64, 86, 797, NULL, NULL, 'SADAS', 'WEKMDSKDF', NULL, 135, '23', 'asdasdsad', 'sadsadsad', '32423', NULL, 1, NULL, 1), (65, 87, 830, NULL, NULL, 'ASDAS', 'ASDSADS', '2323', 136, '23', 'asdsadsa\ndsa\nd\nsa\nd', 'asdsad\nad\nas\nd', NULL, NULL, 1, 213213, 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int NOT NULL, `id_number` varchar(45) DEFAULT NULL, `dealer_id` int DEFAULT NULL, `position_id` int DEFAULT NULL, `firstname` varchar(45) DEFAULT NULL, `middlename` varchar(45) DEFAULT NULL, `lastname` varchar(45) DEFAULT NULL, `birthday` date DEFAULT NULL, `avatar` varchar(45) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `gender_id` int DEFAULT NULL, `status` int DEFAULT NULL, `source` int DEFAULT NULL, `source_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `id_number`, `dealer_id`, `position_id`, `firstname`, `middlename`, `lastname`, `birthday`, `avatar`, `date_added`, `gender_id`, `status`, `source`, `source_id`) VALUES (1, '1', NULL, NULL, 'Admin', NULL, 'Account', '1997-05-20', NULL, NULL, NULL, 1, NULL, NULL), (2, '1274', 1, NULL, 'Arnel', 'E', 'Endaya', NULL, NULL, '2021-12-11 19:36:38', NULL, 1, 2, 1), (3, '2374', 2, NULL, 'Michael', NULL, 'Balibrea', NULL, NULL, '2021-12-13 09:58:42', NULL, 1, 2, 749), (4, '60418', 2, NULL, 'CLARENCE', NULL, 'ANDAYA', NULL, NULL, '2021-12-14 09:00:03', NULL, 1, 2, 1295); -- -------------------------------------------------------- -- -- Table structure for table `user_accounts` -- CREATE TABLE `user_accounts` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `role_id` int DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `is_active` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_accounts` -- INSERT INTO `user_accounts` (`id`, `user_id`, `role_id`, `username`, `password`, `is_active`) VALUES (1, 1, 14, '1', '$2y$10$qiWtgjgBBvJsGyOGuSG9U.ib7WHso7WYwWM1EuY1LmbF1WOId1L1y', 1), (2, 2, 13, 'arnel', '$2y$10$ZQTN.PL62oTkkhadZmYZre0eNjmkzfNt2d8/jt50mTUF6RB3fe5k2', 1), (3, 3, 14, '2374', '$2y$10$WFasrhDkCP8lMmLpptXw/urZWsfjH5VupQpFBRpjg6u.BgNF9Nu46', 1), (4, 4, 13, '60418', '$2y$10$mUVynhaHbrulnXpqWYOKBeauqnQr.8D/oHvgIZe1Rgc0BEuLEIC.C', 1); -- -------------------------------------------------------- -- -- Table structure for table `user_categories` -- CREATE TABLE `user_categories` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_categories` -- INSERT INTO `user_categories` (`id`, `name`, `status`) VALUES (1, 'Technician', 1), (2, 'Expert', 1); -- -------------------------------------------------------- -- -- Table structure for table `user_contacts` -- CREATE TABLE `user_contacts` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `address` text, `city_id` int DEFAULT NULL, `facebook` varchar(45) DEFAULT NULL, `instagram` varchar(45) DEFAULT NULL, `whatsapp` varchar(45) DEFAULT NULL, `viber` varchar(45) DEFAULT NULL, `linkedin` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_contacts` -- INSERT INTO `user_contacts` (`id`, `user_id`, `mobile`, `email`, `address`, `city_id`, `facebook`, `instagram`, `whatsapp`, `viber`, `linkedin`) VALUES (1, 1, '9123456789', 'candaya@autohubgroup.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2, 2, '9269172111', 'aendaya@autohubgroup.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3, 3, '9464023948', 'mbalibrea@autohubgroup.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4, 4, '9389592854', 'andayaworks@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_login_token` -- CREATE TABLE `user_login_token` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `source_id` int DEFAULT NULL, `token` varchar(255) NOT NULL, `type` int NOT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `added_by_user_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_login_token` -- INSERT INTO `user_login_token` (`id`, `user_id`, `source_id`, `token`, `type`, `date_added`, `status`, `added_by_user_id`) VALUES (25, 4, 203, '5ec6ca48-5ef9-11ec-9d24-00ff70631b9a', 1, '2021-12-17 13:22:47', 1, 2), (26, 4, 0, '2259774a-5f00-11ec-9d24-00ff70631b9a', 1, '2021-12-17 14:11:12', 1, 2), (27, 4, 0, '4dc17ecb-5f00-11ec-9d24-00ff70631b9a', 1, '2021-12-17 14:12:25', 1, 2), (28, 4, 0, '525fba5c-5f00-11ec-9d24-00ff70631b9a', 1, '2021-12-17 14:12:32', 1, 2), (29, 4, 0, 'abe587e1-5f00-11ec-9d24-00ff70631b9a', 1, '2021-12-17 14:15:03', 1, 2), (30, 4, 0, '5f266e60-5f10-11ec-9d24-00ff70631b9a', 1, '2021-12-17 16:07:26', 1, 2), (31, 4, 2, 'bb871183-66d3-11ec-b374-00ff70631b9a', 1, '2021-12-27 13:13:31', 1, 2), (32, 4, 3, 'c4b01f21-66d4-11ec-b374-00ff70631b9a', 1, '2021-12-27 13:20:56', 1, 2), (33, 1, 4, '6482ccb6-66d7-11ec-b374-00ff70631b9a', 1, '2021-12-27 13:39:43', 1, 2), (34, 3, 4, '6755d411-66d7-11ec-b374-00ff70631b9a', 1, '2021-12-27 13:39:47', 1, 2), (35, 4, 4, '6830b1cd-66d7-11ec-b374-00ff70631b9a', 1, '2021-12-27 13:39:49', 1, 2), (36, 4, 5, '78e2c955-66d8-11ec-b374-00ff70631b9a', 2, '2021-12-27 13:47:26', 1, 2), (37, 4, 82, 'a8659c86-7025-11ec-92b3-00ff70631b9a', 1, '2022-01-08 09:52:38', 1, 2), (38, 2, 83, 'ac29ba8d-7026-11ec-92b3-00ff70631b9a', 1, '2022-01-08 09:59:54', 1, 4), (39, 4, 84, '45e9a769-7027-11ec-92b3-00ff70631b9a', 1, '2022-01-08 10:04:12', 1, 2), (40, 4, 85, 'edfa4920-7028-11ec-92b3-00ff70631b9a', 1, '2022-01-08 10:16:03', 1, 2), (41, 2, 84, 'fc5518e6-7034-11ec-92b3-00ff70631b9a', 2, '2022-01-08 11:42:21', 1, 4), (42, 4, 83, '035c357b-7039-11ec-92b3-00ff70631b9a', 2, '2022-01-08 12:11:11', 1, 2), (43, 4, 83, '164bf56f-7039-11ec-92b3-00ff70631b9a', 2, '2022-01-08 12:11:43', 1, 2), (44, 4, 83, '58483cdc-7039-11ec-92b3-00ff70631b9a', 2, '2022-01-08 12:13:33', 1, 2), (45, 4, 83, '78bd1054-705b-11ec-92b3-00ff70631b9a', 2, '2022-01-08 16:17:51', 1, 2), (46, 4, 83, '32db38f8-705c-11ec-92b3-00ff70631b9a', 2, '2022-01-08 16:23:03', 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `user_source` -- CREATE TABLE `user_source` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_source` -- INSERT INTO `user_source` (`id`, `name`) VALUES (1, 'Default'), (2, 'ASA'); -- -------------------------------------------------------- -- -- Table structure for table `vehicle_brands` -- CREATE TABLE `vehicle_brands` ( `id` int NOT NULL, `name` varchar(45) DEFAULT NULL, `image` varchar(45) DEFAULT NULL, `source` int DEFAULT NULL, `source_id` varchar(45) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `vehicle_brands` -- INSERT INTO `vehicle_brands` (`id`, `name`, `image`, `source`, `source_id`, `status`) VALUES (121, 'CHERY', NULL, 1, '253', 1), (122, 'FORD', NULL, 1, '5', 1), (123, 'FOTON', NULL, 1, '9', 1), (124, 'GEELY', NULL, 1, '13', 1), (125, 'HYUNDAI', NULL, 1, '4', 1), (126, 'KAICENE', NULL, 1, '255', 1), (127, 'LOTUS', NULL, 1, '2', 1), (128, 'MAZDA', NULL, 1, '7', 1), (129, 'MG', NULL, 1, '6', 1), (130, 'MINI', NULL, 1, '8', 1), (131, 'MITSUBISHI', NULL, 1, '15', 1), (132, 'NISSAN', NULL, 1, '3', 1), (133, 'PIAGGIO', NULL, 1, '257', 1), (134, 'ROLLS-ROYCE', NULL, 1, '1', 1), (135, 'SSANGYONG', NULL, 1, '14', 1), (136, 'SUZUKI', NULL, 1, '289', 1), (137, 'TRIUMPH', NULL, 1, '256', 1), (138, 'VESPA', NULL, 1, '10', 1); -- -------------------------------------------------------- -- -- Table structure for table `vehicle_models` -- CREATE TABLE `vehicle_models` ( `id` int NOT NULL, `brand_id` int DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `image` varchar(45) DEFAULT NULL, `source` int DEFAULT NULL, `source_id` varchar(45) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `vehicle_models` -- INSERT INTO `vehicle_models` (`id`, `brand_id`, `name`, `image`, `source`, `source_id`, `status`) VALUES (797, 121, 'TIGGO 2', NULL, 1, '459', 1), (798, 121, 'TIGGO 5X', NULL, 1, '458', 1), (799, 121, 'TIGGO 7', NULL, 1, '457', 1), (800, 121, 'TIGGO 7 PRO', NULL, 1, '722', 1), (801, 121, 'TIGGO 8', NULL, 1, '460', 1), (802, 122, 'Ecosport', NULL, 1, '425', 1), (803, 122, 'EVEREST', NULL, 1, '22', 1), (804, 122, 'Expedition', NULL, 1, '37', 1), (805, 122, 'EXPLORER', NULL, 1, '41', 1), (806, 122, 'F150', NULL, 1, '39', 1), (807, 122, 'FIESTA', NULL, 1, '534', 1), (808, 122, 'MUSTANG', NULL, 1, '40', 1), (809, 122, 'RANGER', NULL, 1, '44', 1), (810, 122, 'RAPTOR', NULL, 1, '43', 1), (811, 122, 'TERRITORY', NULL, 1, '45', 1), (812, 122, 'TRANSIT', NULL, 1, '38', 1), (813, 123, 'EST-430', NULL, 1, '455', 1), (814, 123, 'ETX', NULL, 1, '509', 1), (815, 123, 'GRATOUR MT', NULL, 1, '442', 1), (816, 123, 'GRATOUR TM300', NULL, 1, '443', 1), (817, 123, 'GTL 8X4', NULL, 1, '456', 1), (818, 123, 'HURRICANE EST-M', NULL, 1, '454', 1), (819, 123, 'THUNDER', NULL, 1, '448', 1), (820, 123, 'TOANO', NULL, 1, '444', 1), (821, 123, 'TOPLANDER', NULL, 1, '447', 1), (822, 123, 'TORNADO 2.4C', NULL, 1, '450', 1), (823, 123, 'TORNADO 4.4C', NULL, 1, '449', 1), (824, 123, 'TORNADO 4.8C', NULL, 1, '453', 1), (825, 123, 'TORNADO M2.6C', NULL, 1, '451', 1), (826, 123, 'TORNADO M4.2C', NULL, 1, '452', 1), (827, 123, 'TORNADO M5.2C', NULL, 1, '535', 1), (828, 123, 'TRANSVAN', NULL, 1, '445', 1), (829, 123, 'TRAVELLER', NULL, 1, '446', 1), (830, 124, 'AZKARRA', NULL, 1, '723', 1), (831, 124, 'COOLRAY', NULL, 1, '513', 1), (832, 124, 'OKAVANGO', NULL, 1, '724', 1), (833, 125, 'Accent', NULL, 1, '97', 1), (834, 125, 'Grand Starex ', NULL, 1, '13', 1), (835, 125, 'H-100 ', NULL, 1, '15', 1), (836, 125, 'H100 ', NULL, 1, '14', 1), (837, 125, 'HD50S', NULL, 1, '21', 1), (838, 125, 'Ioniq', NULL, 1, '16', 1), (839, 125, 'Kona', NULL, 1, '98', 1), (840, 125, 'Reina ', NULL, 1, '17', 1), (841, 125, 'Santa Fe', NULL, 1, '18', 1), (842, 125, 'Tucson', NULL, 1, '19', 1), (843, 126, 'HONOR S 7-SEATER', NULL, 1, '471', 1), (844, 126, 'HONOR S 8-SEATER', NULL, 1, '472', 1), (845, 126, 'HONOR S 8-SEATER 1.5L MT', NULL, 1, '715', 1), (846, 126, 'HONOR S CARGO VAN', NULL, 1, '473', 1), (847, 126, 'STAR TRUCK EXPRESS', NULL, 1, '475', 1), (848, 126, 'STAR TRUCK ALUMINUM BOX', NULL, 1, '476', 1), (849, 126, 'STAR TRUCK DROP SIDE', NULL, 1, '474', 1), (850, 127, 'ELISE CUP 250', NULL, 1, '7', 1), (851, 127, 'ELISE SPORT 220', NULL, 1, '5', 1), (852, 127, 'ELISE SPRINT 220', NULL, 1, '6', 1), (853, 127, 'EVORA 400', NULL, 1, '714', 1), (854, 127, 'EVORA GT410', NULL, 1, '9', 1), (855, 127, 'EVORA GT430', NULL, 1, '10', 1), (856, 127, 'EXIGE SPORT 410', NULL, 1, '8', 1), (857, 128, '4X2 2.2L AT', NULL, 1, '529', 1), (858, 128, '4X2 2.2L MT', NULL, 1, '530', 1), (859, 128, 'BT-50', NULL, 1, '504', 1), (860, 128, 'CX-3', NULL, 1, '506', 1), (861, 128, 'CX-30', NULL, 1, '507', 1), (862, 128, 'CX-5', NULL, 1, '505', 1), (863, 128, 'CX-8', NULL, 1, '508', 1), (864, 128, 'MAZDA 2', NULL, 1, '503', 1), (865, 128, 'MAZDA 3', NULL, 1, '502', 1), (866, 128, 'MAZDA2', NULL, 1, '542', 1), (867, 128, 'MAZDA3', NULL, 1, '541', 1), (868, 128, 'PREMIUM SERIES', NULL, 1, '527', 1), (869, 128, 'V+ HATCHBACK', NULL, 1, '528', 1), (870, 129, 'MG 5', NULL, 1, '510', 1), (871, 129, 'MG ZS', NULL, 1, '511', 1), (872, 129, 'RX 5', NULL, 1, '512', 1), (873, 130, 'CLUBMAN S', NULL, 1, '427', 1), (874, 130, 'COOPER 3 DOOR', NULL, 1, '431', 1), (875, 130, 'COOPER 5 DOOR', NULL, 1, '429', 1), (876, 130, 'COOPER S 3 DOOR', NULL, 1, '432', 1), (877, 130, 'COOPER S 5 DOOR', NULL, 1, '430', 1), (878, 130, 'COUNTRYMAN S PURE', NULL, 1, '434', 1), (879, 130, 'COUNTRYMAN S SPORT', NULL, 1, '435', 1), (880, 130, 'COUNTRYMAN SD ALL4', NULL, 1, '426', 1), (881, 130, 'JCW 3 DOOR', NULL, 1, '433', 1), (882, 130, 'JCW CLUBMAN', NULL, 1, '428', 1), (883, 130, 'JCW COUNTRYMAN', NULL, 1, '436', 1), (884, 130, 'JCW GP INSPIRED', NULL, 1, '727', 1), (885, 131, 'L300', NULL, 1, '716', 1), (886, 131, 'MIRAGE', NULL, 1, '717', 1), (887, 131, 'MONTERO', NULL, 1, '718', 1), (888, 131, 'OUTLANDER', NULL, 1, '721', 1), (889, 131, 'STRADA', NULL, 1, '720', 1), (890, 131, 'XPANDER', NULL, 1, '719', 1), (891, 132, '370Z', NULL, 1, '440', 1), (892, 132, 'ALMERA', NULL, 1, '438', 1), (893, 132, 'CANTER', NULL, 1, '743', 1), (894, 132, 'FJ', NULL, 1, '744', 1), (895, 132, 'NP300 NAVARA', NULL, 1, '23', 1), (896, 132, 'NV350 URVAN', NULL, 1, '437', 1), (897, 132, 'TERRA', NULL, 1, '439', 1), (898, 132, 'X-TRAIL', NULL, 1, '734', 1), (899, 133, 'CITY', NULL, 1, '514', 1), (900, 133, 'DAC', NULL, 1, '517', 1), (901, 133, 'LD', NULL, 1, '516', 1), (902, 133, 'PASSENGER', NULL, 1, '544', 1), (903, 133, 'PORTER', NULL, 1, '518', 1), (904, 134, 'CULLINAN', NULL, 1, '441', 1), (905, 134, 'GHOST ', NULL, 1, '2', 1), (906, 134, 'PHANTOM', NULL, 1, '3', 1), (907, 134, 'WRAITH', NULL, 1, '1', 1), (908, 135, 'KORANDO DSL PREMIUM', NULL, 1, '470', 1), (909, 135, 'KORANDO DSL SPORT', NULL, 1, '469', 1), (910, 135, 'KORANDO GASOLINE SPORT', NULL, 1, '468', 1), (911, 135, 'MUSSO 4X2 (SWB)', NULL, 1, '463', 1), (912, 135, 'MUSSO GRAND 4X2', NULL, 1, '462', 1), (913, 135, 'MUSSO GRAND 4X4', NULL, 1, '461', 1), (914, 135, 'REXTON 4X2', NULL, 1, '467', 1), (915, 135, 'TIVOLI DSL PREMIUM SPORT', NULL, 1, '465', 1), (916, 135, 'TIVOLI DSL SPORT', NULL, 1, '464', 1), (917, 135, 'TIVOLI XLV', NULL, 1, '466', 1), (918, 136, 'CARRY', NULL, 1, '738', 1), (919, 136, 'CELERIO', NULL, 1, '737', 1), (920, 136, 'ERTIGA', NULL, 1, '741', 1), (921, 136, 'JIMNY', NULL, 1, '740', 1), (922, 136, 'S-PRESSO', NULL, 1, '739', 1), (923, 136, 'SWIFT', NULL, 1, '736', 1), (924, 136, 'VITARA', NULL, 1, '742', 1), (925, 137, 'Bobber TFC', NULL, 1, '478', 1), (926, 137, 'Bonneville Bobber', NULL, 1, '501', 1), (927, 137, 'Bonneville Speedmaster', NULL, 1, '479', 1), (928, 137, 'Bonneville T100', NULL, 1, '480', 1), (929, 137, 'Bonneville T120', NULL, 1, '481', 1), (930, 137, 'Bonneville T120 Black', NULL, 1, '482', 1), (931, 137, 'Bonneville T120 Bud Ekins', NULL, 1, '497', 1), (932, 137, 'Rocket 3 GT', NULL, 1, '484', 1), (933, 137, 'Rocket 3 R', NULL, 1, '498', 1), (934, 137, 'Rocket 3 TFC', NULL, 1, '483', 1), (935, 137, 'Scrambler 1200 XC', NULL, 1, '485', 1), (936, 137, 'Scrambler 1200 XE', NULL, 1, '486', 1), (937, 137, 'Speed Triple 1200 RS', NULL, 1, '726', 1), (938, 137, 'Speed Twin', NULL, 1, '487', 1), (939, 137, 'Street Scrambler', NULL, 1, '495', 1), (940, 137, 'Street Triple R LRH', NULL, 1, '499', 1), (941, 137, 'Street Triple RS', NULL, 1, '489', 1), (942, 137, 'Street Twin', NULL, 1, '490', 1), (943, 137, 'Thruxton RS', NULL, 1, '725', 1), (944, 137, 'Tiger 900 GT LRH', NULL, 1, '491', 1), (945, 137, 'Tiger 900 GT Pro', NULL, 1, '492', 1), (946, 137, 'Tiger 900 Rally Pro', NULL, 1, '493', 1), (947, 137, 'Trident 660', NULL, 1, '494', 1), (948, 138, 'GTS300 SUPERTECH', NULL, 1, '729', 1), (949, 138, 'GTV SEI GIORNI II', NULL, 1, '730', 1), (950, 138, 'PRIMAVERA', NULL, 1, '731', 1), (951, 138, 'PRIMAVERA S', NULL, 1, '532', 1), (952, 138, 'PRIMAVERA SEAN WOTHERSPOO', NULL, 1, '732', 1), (953, 138, 'PRIMAVERA SW', NULL, 1, '733', 1), (954, 138, 'SPRINT', NULL, 1, '728', 1), (955, 138, 'SPRINT S', NULL, 1, '533', 1), (956, 138, 'VESPA S', NULL, 1, '531', 1); -- -------------------------------------------------------- -- -- Table structure for table `vehicle_model_variants` -- CREATE TABLE `vehicle_model_variants` ( `id` int NOT NULL, `model_id` int DEFAULT NULL, `description` varchar(45) DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `vehicle_model_variants` -- INSERT INTO `vehicle_model_variants` (`id`, `model_id`, `description`, `status`) VALUES (95, 816, 'ASDASDSA', 1), (96, 803, 'VARIANT XYZ', 1), (97, 803, 'VARIANT XYZ', 1), (98, 803, 'VARIANT XYZ', 1), (99, 803, 'VARIANT XYZ', 1), (100, 803, 'VARIANT XYZ', 1), (101, 797, '2343242', 1), (102, 797, 'ASD', 1), (103, 797, 'ASD', 1), (104, 797, 'ASDASD', 1), (105, 797, 'ASDASD', 1), (106, 797, 'ASDASD', 1), (107, 797, 'ASDASD', 1), (108, 797, 'ASDASD', 1), (109, 797, 'ASDSADASD', 1), (110, 797, 'SDFSDF', 1), (111, 802, 'SFDSDF', 1), (112, 797, 'SDFSDFS', 1), (113, 797, 'DFDSFSSDFDSF', 1), (114, 797, 'DFDSFSSDFDSF', 1), (115, 797, 'ASDSADA', 1), (116, 797, 'SDFSDF', 1), (117, 797, 'SDFSDF', 1), (118, 797, 'SDFSDF', 1), (119, 797, 'ASD', 1), (120, 797, 'ASD', 1), (121, 797, 'ASD', 1), (122, 813, 'SDFSDF', 1), (123, 797, 'MV123', 1), (124, 797, 'SDF', 1), (125, 797, 'SDF', 1), (126, 816, '23', 1), (127, 802, '667676', 1), (128, 830, 'HJHJH', 1), (129, 831, 'ASDASDA', 1), (130, 797, 'MV123', 1), (131, 797, 'MV2321', 1), (132, 797, 'MV43431XYZ', 1), (133, 797, 'SDDSA1243', 1), (134, 802, 'DSFJKNSJF', 1), (135, 797, 'ASDSADSA', 1), (136, 830, 'ASDASDA', 1); -- -------------------------------------------------------- -- -- Table structure for table `videos` -- CREATE TABLE `videos` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `sub_category_id` int DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` longtext, `original_name` varchar(255) DEFAULT NULL, `attachment_name` varchar(45) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_attachments` -- CREATE TABLE `video_attachments` ( `id` int NOT NULL, `video_id` int DEFAULT NULL, `attachment_name` varchar(45) DEFAULT NULL, `original_name` varchar(255) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_comments` -- CREATE TABLE `video_comments` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `video_id` int DEFAULT NULL, `description` longtext ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_reactions` -- CREATE TABLE `video_reactions` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `video_id` int DEFAULT NULL, `reaction_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_tags` -- CREATE TABLE `video_tags` ( `id` int NOT NULL, `video_id` int DEFAULT NULL, `tag` varchar(255) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_type_vehicles` -- CREATE TABLE `video_type_vehicles` ( `id` int NOT NULL, `video_id` int DEFAULT NULL, `brand_id` int DEFAULT NULL, `model_id` int DEFAULT NULL, `model_variant_id` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `video_views` -- CREATE TABLE `video_views` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL, `video_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `api` -- ALTER TABLE `api` ADD PRIMARY KEY (`id`); -- -- Indexes for table `api_generated_keys` -- ALTER TABLE `api_generated_keys` ADD PRIMARY KEY (`id`), ADD KEY `api_generated_keys_idx` (`api_id`); -- -- Indexes for table `asigned_users` -- ALTER TABLE `asigned_users` ADD PRIMARY KEY (`id`), ADD KEY `asignee_fk1_idx` (`user_id`), ADD KEY `asignee_fk2_idx` (`ticket_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cnf_notification_list` -- ALTER TABLE `cnf_notification_list` ADD PRIMARY KEY (`id`), ADD KEY `cnf_notification_list_idx` (`template_id`), ADD KEY `cnf_notification_list_fk2_idx` (`from_user_id`), ADD KEY `cnf_notification_list_fk3_idx` (`to_user_id`); -- -- Indexes for table `cnf_notification_templates` -- ALTER TABLE `cnf_notification_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cnf_roles` -- ALTER TABLE `cnf_roles` ADD PRIMARY KEY (`id`), ADD KEY `cnf_roles_fk1_idx` (`user_id`); -- -- Indexes for table `cnf_role_access` -- ALTER TABLE `cnf_role_access` ADD PRIMARY KEY (`id`), ADD KEY `fk_cnf_role_access_cnf_roles1_idx` (`role_id`), ADD KEY `cnf_role_access_fk1_idx` (`user_category_id`); -- -- Indexes for table `cnf_sms_api` -- ALTER TABLE `cnf_sms_api` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cnf_sms_templates` -- ALTER TABLE `cnf_sms_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cnf_system` -- ALTER TABLE `cnf_system` ADD PRIMARY KEY (`id`); -- -- Indexes for table `companies` -- ALTER TABLE `companies` ADD PRIMARY KEY (`id`), ADD KEY `companies_fk1_idx` (`user_id`); -- -- Indexes for table `dealers` -- ALTER TABLE `dealers` ADD PRIMARY KEY (`id`), ADD KEY `companies_fk1_idx` (`user_id`), ADD KEY `companies_fk2_idx` (`company_id`); -- -- Indexes for table `knowledgebase` -- ALTER TABLE `knowledgebase` ADD PRIMARY KEY (`id`), ADD KEY `videos_fk1_idx` (`user_id`), ADD KEY `videos_fk2_idx` (`sub_category_id`); -- -- Indexes for table `knowledgebase_attachments` -- ALTER TABLE `knowledgebase_attachments` ADD PRIMARY KEY (`id`), ADD KEY `ticket_attachements0_idx` (`knowledgebase_id`); -- -- Indexes for table `knowledgebase_tags` -- ALTER TABLE `knowledgebase_tags` ADD PRIMARY KEY (`id`), ADD KEY `video_tags_fk10_idx` (`knowledgebase_id`); -- -- Indexes for table `knowledgebase_type_vehicles` -- ALTER TABLE `knowledgebase_type_vehicles` ADD PRIMARY KEY (`id`), ADD KEY `video_type_vehicles_fk2_idx` (`model_id`), ADD KEY `video_type_vehicles_fk3_idx` (`model_variant_id`), ADD KEY `video_type_vehicles_fk4_idx` (`brand_id`), ADD KEY `video_type_vehicles_fk10_idx` (`knowledgebase_id`); -- -- Indexes for table `knowledgebase_views` -- ALTER TABLE `knowledgebase_views` ADD PRIMARY KEY (`id`), ADD KEY `video_views_fk2_idx` (`user_id`), ADD KEY `video_views_fk11_idx` (`knowledgebase_id`); -- -- Indexes for table `priority_levels` -- ALTER TABLE `priority_levels` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`); -- -- Indexes for table `sub_categories` -- ALTER TABLE `sub_categories` ADD PRIMARY KEY (`id`), ADD KEY `ticket_sub_categories_fk1_idx` (`category_id`); -- -- Indexes for table `tickets` -- ALTER TABLE `tickets` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ticket_no_UNIQUE` (`reference_no`), ADD KEY `tickets_fk1_idx` (`sub_category_id`), ADD KEY `tickets_fK2_idx` (`priority_level_id`), ADD KEY `tickets_fK3_idx` (`user_id`); -- -- Indexes for table `ticket_attachments` -- ALTER TABLE `ticket_attachments` ADD PRIMARY KEY (`id`), ADD KEY `ticket_attachements_idx` (`ticket_id`); -- -- Indexes for table `ticket_progress_status` -- ALTER TABLE `ticket_progress_status` ADD PRIMARY KEY (`id`), ADD KEY `asignee_fk1_idx` (`user_id`), ADD KEY `asignee_fk2_idx` (`ticket_id`), ADD KEY `asignee_fk30_idx` (`ticket_status_id`); -- -- Indexes for table `ticket_replies` -- ALTER TABLE `ticket_replies` ADD PRIMARY KEY (`id`), ADD KEY `ticket_replies_fk1_idx` (`user_id`), ADD KEY `ticket_replies_fk2_idx` (`ticket_status_id`), ADD KEY `ticket_replies_fk3_idx` (`ticket_id`); -- -- Indexes for table `ticket_reply_attachments` -- ALTER TABLE `ticket_reply_attachments` ADD PRIMARY KEY (`id`), ADD KEY `ticket_reply_attachments_fk1_idx` (`ticket_reply_id`); -- -- Indexes for table `ticket_status` -- ALTER TABLE `ticket_status` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`); -- -- Indexes for table `ticket_type_vehicles` -- ALTER TABLE `ticket_type_vehicles` ADD PRIMARY KEY (`id`), ADD KEY `ticket_type_vehicle_fk1_idx` (`ticket_id`), ADD KEY `ticket_type_vehicle_fk2_idx` (`model_id`), ADD KEY `ticket_type_vehicle_fk3_idx` (`model_variant_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD KEY `users_fk1_idx` (`dealer_id`), ADD KEY `users_fk2_idx` (`source`); -- -- Indexes for table `user_accounts` -- ALTER TABLE `user_accounts` ADD PRIMARY KEY (`id`), ADD KEY `user_accounts_fk1_idx` (`user_id`), ADD KEY `user_accounts_fk2_idx` (`role_id`); -- -- Indexes for table `user_categories` -- ALTER TABLE `user_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_contacts` -- ALTER TABLE `user_contacts` ADD PRIMARY KEY (`id`), ADD KEY `user_contacts_idx` (`user_id`); -- -- Indexes for table `user_login_token` -- ALTER TABLE `user_login_token` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `token_UNIQUE` (`token`), ADD KEY `user_login_token_fk1_idx` (`user_id`), ADD KEY `user_login_token_fk2_idx` (`added_by_user_id`); -- -- Indexes for table `user_source` -- ALTER TABLE `user_source` ADD PRIMARY KEY (`id`); -- -- Indexes for table `vehicle_brands` -- ALTER TABLE `vehicle_brands` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`); -- -- Indexes for table `vehicle_models` -- ALTER TABLE `vehicle_models` ADD PRIMARY KEY (`id`), ADD KEY `vehicle_model_fk1_idx` (`brand_id`); -- -- Indexes for table `vehicle_model_variants` -- ALTER TABLE `vehicle_model_variants` ADD PRIMARY KEY (`id`), ADD KEY `vehicle_model_variant_fk1_idx` (`model_id`); -- -- Indexes for table `videos` -- ALTER TABLE `videos` ADD PRIMARY KEY (`id`), ADD KEY `videos_fk1_idx` (`user_id`), ADD KEY `videos_fk2_idx` (`sub_category_id`); -- -- Indexes for table `video_attachments` -- ALTER TABLE `video_attachments` ADD PRIMARY KEY (`id`), ADD KEY `ticket_attachements1_idx` (`video_id`); -- -- Indexes for table `video_comments` -- ALTER TABLE `video_comments` ADD PRIMARY KEY (`id`), ADD KEY `video_views_idx` (`video_id`), ADD KEY `video_views_fk2_idx` (`user_id`); -- -- Indexes for table `video_reactions` -- ALTER TABLE `video_reactions` ADD PRIMARY KEY (`id`), ADD KEY `video_views_idx` (`video_id`), ADD KEY `video_views_fk2_idx` (`user_id`); -- -- Indexes for table `video_tags` -- ALTER TABLE `video_tags` ADD PRIMARY KEY (`id`), ADD KEY `video_tags_fk1_idx` (`video_id`); -- -- Indexes for table `video_type_vehicles` -- ALTER TABLE `video_type_vehicles` ADD PRIMARY KEY (`id`), ADD KEY `video_type_vehicles_fk1_idx` (`video_id`), ADD KEY `video_type_vehicles_fk2_idx` (`model_id`), ADD KEY `video_type_vehicles_fk3_idx` (`model_variant_id`), ADD KEY `video_type_vehicles_fk4_idx` (`brand_id`); -- -- Indexes for table `video_views` -- ALTER TABLE `video_views` ADD PRIMARY KEY (`id`), ADD KEY `video_views_idx` (`video_id`), ADD KEY `video_views_fk2_idx` (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `api` -- ALTER TABLE `api` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `api_generated_keys` -- ALTER TABLE `api_generated_keys` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `asigned_users` -- ALTER TABLE `asigned_users` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `cnf_notification_list` -- ALTER TABLE `cnf_notification_list` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168; -- -- AUTO_INCREMENT for table `cnf_roles` -- ALTER TABLE `cnf_roles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `cnf_role_access` -- ALTER TABLE `cnf_role_access` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `cnf_sms_api` -- ALTER TABLE `cnf_sms_api` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cnf_sms_templates` -- ALTER TABLE `cnf_sms_templates` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `cnf_system` -- ALTER TABLE `cnf_system` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `companies` -- ALTER TABLE `companies` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `dealers` -- ALTER TABLE `dealers` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `knowledgebase` -- ALTER TABLE `knowledgebase` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `knowledgebase_attachments` -- ALTER TABLE `knowledgebase_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `knowledgebase_tags` -- ALTER TABLE `knowledgebase_tags` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `knowledgebase_type_vehicles` -- ALTER TABLE `knowledgebase_type_vehicles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `knowledgebase_views` -- ALTER TABLE `knowledgebase_views` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `priority_levels` -- ALTER TABLE `priority_levels` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `sub_categories` -- ALTER TABLE `sub_categories` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `tickets` -- ALTER TABLE `tickets` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88; -- -- AUTO_INCREMENT for table `ticket_attachments` -- ALTER TABLE `ticket_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97; -- -- AUTO_INCREMENT for table `ticket_progress_status` -- ALTER TABLE `ticket_progress_status` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `ticket_replies` -- ALTER TABLE `ticket_replies` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91; -- -- AUTO_INCREMENT for table `ticket_reply_attachments` -- ALTER TABLE `ticket_reply_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `ticket_status` -- ALTER TABLE `ticket_status` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `ticket_type_vehicles` -- ALTER TABLE `ticket_type_vehicles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `user_accounts` -- ALTER TABLE `user_accounts` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `user_categories` -- ALTER TABLE `user_categories` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `user_contacts` -- ALTER TABLE `user_contacts` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `user_login_token` -- ALTER TABLE `user_login_token` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47; -- -- AUTO_INCREMENT for table `user_source` -- ALTER TABLE `user_source` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `vehicle_brands` -- ALTER TABLE `vehicle_brands` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139; -- -- AUTO_INCREMENT for table `vehicle_models` -- ALTER TABLE `vehicle_models` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=957; -- -- AUTO_INCREMENT for table `vehicle_model_variants` -- ALTER TABLE `vehicle_model_variants` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137; -- -- AUTO_INCREMENT for table `videos` -- ALTER TABLE `videos` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -- AUTO_INCREMENT for table `video_attachments` -- ALTER TABLE `video_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `video_comments` -- ALTER TABLE `video_comments` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `video_reactions` -- ALTER TABLE `video_reactions` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `video_tags` -- ALTER TABLE `video_tags` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `video_type_vehicles` -- ALTER TABLE `video_type_vehicles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `video_views` -- ALTER TABLE `video_views` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `api_generated_keys` -- ALTER TABLE `api_generated_keys` ADD CONSTRAINT `api_generated_keys_fk1` FOREIGN KEY (`api_id`) REFERENCES `api` (`id`); -- -- Constraints for table `asigned_users` -- ALTER TABLE `asigned_users` ADD CONSTRAINT `asignee_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `asignee_fk2` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`); -- -- Constraints for table `cnf_notification_list` -- ALTER TABLE `cnf_notification_list` ADD CONSTRAINT `cnf_notification_list_fk1` FOREIGN KEY (`template_id`) REFERENCES `cnf_notification_templates` (`id`), ADD CONSTRAINT `cnf_notification_list_fk2` FOREIGN KEY (`from_user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `cnf_notification_list_fk3` FOREIGN KEY (`to_user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `cnf_roles` -- ALTER TABLE `cnf_roles` ADD CONSTRAINT `cnf_roles_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `cnf_role_access` -- ALTER TABLE `cnf_role_access` ADD CONSTRAINT `cnf_role_access_fk1` FOREIGN KEY (`user_category_id`) REFERENCES `user_categories` (`id`), ADD CONSTRAINT `fk_cnf_role_access_cnf_roles1` FOREIGN KEY (`role_id`) REFERENCES `cnf_roles` (`id`); -- -- Constraints for table `companies` -- ALTER TABLE `companies` ADD CONSTRAINT `companies_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `dealers` -- ALTER TABLE `dealers` ADD CONSTRAINT `companies_fk10` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `companies_fk2` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`); -- -- Constraints for table `knowledgebase` -- ALTER TABLE `knowledgebase` ADD CONSTRAINT `videos_fk10` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `videos_fk20` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`); -- -- Constraints for table `knowledgebase_attachments` -- ALTER TABLE `knowledgebase_attachments` ADD CONSTRAINT `ticket_attachements0` FOREIGN KEY (`knowledgebase_id`) REFERENCES `knowledgebase` (`id`); -- -- Constraints for table `knowledgebase_tags` -- ALTER TABLE `knowledgebase_tags` ADD CONSTRAINT `video_tags_fk10` FOREIGN KEY (`knowledgebase_id`) REFERENCES `knowledgebase` (`id`); -- -- Constraints for table `knowledgebase_type_vehicles` -- ALTER TABLE `knowledgebase_type_vehicles` ADD CONSTRAINT `video_type_vehicles_fk10` FOREIGN KEY (`knowledgebase_id`) REFERENCES `knowledgebase` (`id`), ADD CONSTRAINT `video_type_vehicles_fk20` FOREIGN KEY (`model_id`) REFERENCES `vehicle_models` (`id`), ADD CONSTRAINT `video_type_vehicles_fk30` FOREIGN KEY (`model_variant_id`) REFERENCES `vehicle_model_variants` (`id`), ADD CONSTRAINT `video_type_vehicles_fk40` FOREIGN KEY (`brand_id`) REFERENCES `vehicle_brands` (`id`); -- -- Constraints for table `knowledgebase_views` -- ALTER TABLE `knowledgebase_views` ADD CONSTRAINT `video_views_fk11` FOREIGN KEY (`knowledgebase_id`) REFERENCES `knowledgebase` (`id`), ADD CONSTRAINT `video_views_fk21` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `sub_categories` -- ALTER TABLE `sub_categories` ADD CONSTRAINT `ticket_sub_categories_fk1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`); -- -- Constraints for table `tickets` -- ALTER TABLE `tickets` ADD CONSTRAINT `tickets_fk1` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`), ADD CONSTRAINT `tickets_fK2` FOREIGN KEY (`priority_level_id`) REFERENCES `priority_levels` (`id`), ADD CONSTRAINT `tickets_fK3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `ticket_attachments` -- ALTER TABLE `ticket_attachments` ADD CONSTRAINT `ticket_attachements` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`); -- -- Constraints for table `ticket_progress_status` -- ALTER TABLE `ticket_progress_status` ADD CONSTRAINT `asignee_fk10` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `asignee_fk20` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`), ADD CONSTRAINT `asignee_fk30` FOREIGN KEY (`ticket_status_id`) REFERENCES `ticket_status` (`id`); -- -- Constraints for table `ticket_replies` -- ALTER TABLE `ticket_replies` ADD CONSTRAINT `ticket_replies_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `ticket_replies_fk2` FOREIGN KEY (`ticket_status_id`) REFERENCES `ticket_status` (`id`), ADD CONSTRAINT `ticket_replies_fk3` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`); -- -- Constraints for table `ticket_reply_attachments` -- ALTER TABLE `ticket_reply_attachments` ADD CONSTRAINT `ticket_reply_attachments_fk1` FOREIGN KEY (`ticket_reply_id`) REFERENCES `ticket_replies` (`id`); -- -- Constraints for table `ticket_type_vehicles` -- ALTER TABLE `ticket_type_vehicles` ADD CONSTRAINT `ticket_type_vehicle_fk1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`), ADD CONSTRAINT `ticket_type_vehicle_fk2` FOREIGN KEY (`model_id`) REFERENCES `vehicle_models` (`id`), ADD CONSTRAINT `ticket_type_vehicle_fk3` FOREIGN KEY (`model_variant_id`) REFERENCES `vehicle_model_variants` (`id`); -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_fk1` FOREIGN KEY (`dealer_id`) REFERENCES `dealers` (`id`), ADD CONSTRAINT `users_fk2` FOREIGN KEY (`source`) REFERENCES `user_source` (`id`); -- -- Constraints for table `user_accounts` -- ALTER TABLE `user_accounts` ADD CONSTRAINT `user_accounts_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `user_accounts_fk2` FOREIGN KEY (`role_id`) REFERENCES `cnf_roles` (`id`); -- -- Constraints for table `user_contacts` -- ALTER TABLE `user_contacts` ADD CONSTRAINT `user_contacts_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `user_login_token` -- ALTER TABLE `user_login_token` ADD CONSTRAINT `user_login_token_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `user_login_token_fk2` FOREIGN KEY (`added_by_user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `vehicle_models` -- ALTER TABLE `vehicle_models` ADD CONSTRAINT `vehicle_model_fk1` FOREIGN KEY (`brand_id`) REFERENCES `vehicle_brands` (`id`); -- -- Constraints for table `vehicle_model_variants` -- ALTER TABLE `vehicle_model_variants` ADD CONSTRAINT `vehicle_model_variant_fk1` FOREIGN KEY (`model_id`) REFERENCES `vehicle_models` (`id`); -- -- Constraints for table `videos` -- ALTER TABLE `videos` ADD CONSTRAINT `videos_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `videos_fk2` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`); -- -- Constraints for table `video_attachments` -- ALTER TABLE `video_attachments` ADD CONSTRAINT `ticket_attachements1` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`); -- -- Constraints for table `video_comments` -- ALTER TABLE `video_comments` ADD CONSTRAINT `video_views_fk100` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`), ADD CONSTRAINT `video_views_fk200` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `video_reactions` -- ALTER TABLE `video_reactions` ADD CONSTRAINT `video_views_fk10` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`), ADD CONSTRAINT `video_views_fk20` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `video_tags` -- ALTER TABLE `video_tags` ADD CONSTRAINT `video_tags_fk1` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`); -- -- Constraints for table `video_type_vehicles` -- ALTER TABLE `video_type_vehicles` ADD CONSTRAINT `video_type_vehicles_fk1` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`), ADD CONSTRAINT `video_type_vehicles_fk2` FOREIGN KEY (`model_id`) REFERENCES `vehicle_models` (`id`), ADD CONSTRAINT `video_type_vehicles_fk3` FOREIGN KEY (`model_variant_id`) REFERENCES `vehicle_model_variants` (`id`), ADD CONSTRAINT `video_type_vehicles_fk4` FOREIGN KEY (`brand_id`) REFERENCES `vehicle_brands` (`id`); -- -- Constraints for table `video_views` -- ALTER TABLE `video_views` ADD CONSTRAINT `video_views_fk1` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`), ADD CONSTRAINT `video_views_fk2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings