File manager - Edit - /home/autoph/public_html/tasks/autoph_cc (19).sql.tar
Back
home/autoph/public_html/tasks/db/autoph_cc (19).sql 0000644 00000216503 15024752625 0016050 0 ustar 00 -- phpMyAdmin SQL Dump -- version 5.0.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 15, 2022 at 06:35 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=utf8; -- -- 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=utf8; -- -- 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -- 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=utf8; -- -- 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 (177, 3, 2, 4, 101, '2022-01-13 10:01:09', 1, 1, 1), (178, 3, 2, 4, 102, '2022-01-13 10:46:39', 1, 1, 1), (179, 4, 2, 4, 103, '2022-01-15 13:21:52', 1, 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=utf8; -- -- 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', '<user> Created a ticket,\nTitle: <title>\nCase ID: <ref_no>\nBrand: <brand>\nModel: <model>\nPriority: <priority>', NULL, 0, 1), (2, 'Reply Ticket SMS', '<user> reply to your ticket <title>\nCase ID: <ref_no>', NULL, 0, 1), (3, 'Create Ticket Expert System', '<user> create <brand> ticket <title>', NULL, 1, 1), (4, 'Reply Ticket System', '<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=utf8; -- -- 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', 0), (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', 0), (10, 'TEST 1', 1, '2021-12-11 09:22:17', 0), (11, 'SADASDASDS', 1, '2021-12-11 09:23:39', 0), (12, 'TEST 1ASD', 1, '2021-12-11 09:24:25', 0), (13, 'ADMIN', 1, '2021-12-11 09:29:56', 1), (14, 'AAAAA', 1, '2021-12-11 09:30:27', 0), (15, 'ZXCZ', 1, '2021-12-11 15:20:07', 0), (16, 'TECHNICIAN 1', 2, '2022-01-12 10:41:50', 1), (17, 'EXPERT 1', 2, '2022-01-12 11:28:52', 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=utf8; -- -- 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_8\",\"2_6\",\"2_7\",\"2_3\",\"2_4\",\"2_5\"],\"3\":[\"3_1\",\"3_2\",\"3_4\",\"3_8\",\"3_9\"],\"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, 3), (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), (17, 16, '{\"1\":[],\"2\":[\"2_3\",\"2_4\",\"2_5\"],\"3\":[\"3_1\",\"3_2\"],\"4\":[\"4_1\"],\"5\":[\"5_1\"]}', '[\"121\",\"122\",\"123\",\"124\",\"125\",\"126\",\"127\",\"128\",\"129\",\"130\",\"131\",\"132\",\"134\",\"133\",\"135\",\"136\",\"137\",\"138\"]', NULL, 1), (18, 17, '{\"1\":[],\"2\":[\"2_8\",\"2_3\",\"2_4\",\"2_5\"],\"3\":[\"3_1\",\"3_2\",\"3_4\",\"3_8\"],\"4\":[\"4_1\",\"4_2\"],\"5\":[\"5_1\",\"5_2\"]}', '[\"121\",\"122\",\"123\",\"124\",\"125\",\"126\",\"127\",\"128\",\"129\",\"130\",\"131\",\"132\",\"133\",\"134\",\"135\",\"138\",\"137\",\"136\"]', NULL, 2); -- -------------------------------------------------------- -- -- 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=utf8; -- -- 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', 1, 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=utf8; -- -- 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=utf8; -- -- 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=utf8; -- -- 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=utf8; -- -- 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, `fault_codes` text, `date_added` datetime DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `knowledgebase` -- INSERT INTO `knowledgebase` (`id`, `user_id`, `sub_category_id`, `title`, `description`, `fault_codes`, `date_added`, `status`) VALUES (28, 2, 5, 'sdsadsa', '<p>dsadsadad</p>', 'fcode2', '2022-01-13 11:26:59', 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -- Dumping data for table `knowledgebase_type_vehicles` -- INSERT INTO `knowledgebase_type_vehicles` (`id`, `knowledgebase_id`, `brand_id`, `model_id`, `model_variant_id`, `status`) VALUES (20, 28, 123, 814, 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=utf8; -- -------------------------------------------------------- -- -- Table structure for table `log` -- CREATE TABLE `log` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `description` text, `target_id` int DEFAULT NULL, `date_added` datetime DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `log` -- INSERT INTO `log` (`id`, `user_id`, `description`, `target_id`, `date_added`, `type`, `status`) VALUES (1, 2, 'User has login.', NULL, '2022-01-10 16:39:14', 1, 1), (2, 2, 'Created a ticket', 89, '2022-01-10 16:43:35', 2, 1), (3, 2, 'Reply to ticket', 85, '2022-01-10 16:48:20', 3, 1), (4, 4, 'User has login', NULL, '2022-01-10 16:50:22', 1, 1), (5, 4, 'Reply to ticket', 89, '2022-01-10 16:50:35', 3, 1), (6, 4, 'Change case status', 89, '2022-01-10 16:53:18', 3, 1), (7, 4, 'Change case status to Close', 89, '2022-01-10 16:54:00', 3, 1), (8, 4, 'Change case status to Escalated (In Progress)', 89, '2022-01-10 16:54:20', 3, 1), (9, 4, 'Reply to ticket', 89, '2022-01-10 16:54:30', 3, 1), (10, 4, 'Change case status to Escalated (Close)', 89, '2022-01-10 16:54:56', 4, 1), (11, 2, 'User has login', NULL, '2022-01-10 19:59:55', 1, 1), (12, 2, 'Reply to ticket', 84, '2022-01-10 20:46:12', 3, 1), (13, 2, 'Reply to ticket', 80, '2022-01-10 20:58:58', 3, 1), (14, 2, 'Reply to ticket', 80, '2022-01-10 20:59:04', 3, 1), (15, 2, 'Reply to ticket', 80, '2022-01-10 20:59:20', 3, 1), (16, 2, 'Reply to ticket', 80, '2022-01-10 21:00:43', 3, 1), (17, 4, 'User has login', NULL, '2022-01-11 08:27:47', 1, 1), (18, 4, 'Reply to ticket', 84, '2022-01-11 08:32:02', 3, 1), (19, 2, 'User has login', NULL, '2022-01-11 08:54:36', 1, 1), (20, 2, 'Reply to ticket', 84, '2022-01-11 08:54:49', 3, 1), (21, 4, 'Reply to ticket', 80, '2022-01-11 08:55:25', 3, 1), (22, 2, 'Reply to ticket', 80, '2022-01-11 08:55:36', 3, 1), (23, 4, 'Reply to ticket', 80, '2022-01-11 08:55:44', 3, 1), (24, 2, 'User has login', NULL, '2022-01-12 08:32:56', 1, 1), (25, 4, 'User has login', NULL, '2022-01-12 10:42:36', 1, 1), (26, 4, 'Created a ticket', 98, '2022-01-12 10:47:43', 2, 1), (27, 4, 'User has login', NULL, '2022-01-12 11:24:08', 1, 1), (28, 2, 'User has login', NULL, '2022-01-12 11:24:56', 1, 1), (29, 4, 'User has login', NULL, '2022-01-12 11:30:06', 1, 1), (30, 4, 'User has login', NULL, '2022-01-12 14:06:14', 1, 1), (31, 2, 'Reply to ticket', 98, '2022-01-12 15:37:47', 3, 1), (32, 2, 'Reply to ticket', 98, '2022-01-12 15:42:49', 3, 1), (33, 2, 'User has login', NULL, '2022-01-13 08:19:19', 1, 1), (34, 2, 'Created a ticket', 101, '2022-01-13 10:01:09', 2, 1), (35, 2, 'Change status to Close', 101, '2022-01-13 10:08:43', 4, 1), (36, 2, 'Created a ticket', 102, '2022-01-13 10:46:39', 2, 1), (37, 2, 'User has login', NULL, '2022-01-13 15:25:03', 1, 1), (38, 2, 'Reply to ticket', 101, '2022-01-13 15:50:55', 3, 1), (39, 4, 'User has login', NULL, '2022-01-14 08:17:53', 1, 1), (40, 4, 'User has login', NULL, '2022-01-14 08:17:54', 1, 1), (41, 2, 'User has login', NULL, '2022-01-14 08:51:54', 1, 1), (42, 2, 'User has login', NULL, '2022-01-14 11:06:44', 1, 1), (43, 2, 'User has login', NULL, '2022-01-15 08:23:52', 1, 1), (44, 2, 'Change status to Escalated (Close)', 101, '2022-01-15 11:10:56', 4, 1), (45, 2, 'Change status to Close', 101, '2022-01-15 11:11:01', 4, 1), (46, 2, 'Change status to Escalated (In Progress)', 101, '2022-01-15 11:11:22', 4, 1), (47, 2, 'Change status to Close', 101, '2022-01-15 11:11:38', 4, 1), (48, 2, 'Change status to Escalated (In Progress)', 101, '2022-01-15 11:14:20', 4, 1), (49, 2, 'Change status to Close', 101, '2022-01-15 11:25:40', 4, 1), (50, 4, 'User has login', NULL, '2022-01-15 13:14:45', 1, 1), (51, 4, 'Created a ticket', 103, '2022-01-15 13:15:25', 2, 1), (52, 2, 'User has login', NULL, '2022-01-15 13:15:34', 1, 1), (53, 2, 'Change status to Close', 103, '2022-01-15 13:15:46', 4, 1), (54, 4, 'User has login', NULL, '2022-01-15 13:16:11', 1, 1), (55, 2, 'Change status to Escalated (Close)', 103, '2022-01-15 13:17:44', 4, 1), (56, 4, 'Change status to Escalated (In Progress)', 103, '2022-01-15 13:18:25', 4, 1), (57, 4, 'Change status to Escalated (Close)', 103, '2022-01-15 13:19:59', 4, 1), (58, 4, 'Change status to Close', 103, '2022-01-15 13:20:02', 4, 1), (59, 4, 'Change status to Escalated (In Progress)', 103, '2022-01-15 13:20:05', 4, 1), (60, 4, 'Change status to Close', 103, '2022-01-15 13:20:27', 4, 1), (61, 2, 'Reply to ticket', 103, '2022-01-15 13:21:52', 3, 1), (62, 4, 'Reply to ticket', 103, '2022-01-15 13:22:21', 3, 1), (63, 4, 'Rate a ticket with 3 stars.', 103, '2022-01-15 13:30:50', 5, 1), (64, 4, 'Rate a ticket with 4 star/s.', 103, '2022-01-15 13:31:39', 5, 1), (65, 4, 'Rate a ticket with 3 stars.', 103, '2022-01-15 13:33:41', 5, 1), (66, 4, 'Rate a ticket with 5 stars.', 103, '2022-01-15 13:33:49', 5, 1); -- -------------------------------------------------------- -- -- 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=utf8; -- -- Dumping data for table `priority_levels` -- INSERT INTO `priority_levels` (`id`, `name`, `level`, `status`) VALUES (1, 'Info', 1, 1), (2, 'Reply Requested', 2, 0), (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=utf8; -- -- 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, `work_performed` text, `complaint` text, `fault_codes` text, `date_added` datetime DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tickets` -- INSERT INTO `tickets` (`id`, `user_id`, `sub_category_id`, `priority_level_id`, `reference_no`, `title`, `description`, `work_performed`, `complaint`, `fault_codes`, `date_added`, `type`, `status`) VALUES (100, 2, 4, 3, 1100, 'test ticket 1', '', 'lorem \nipsum\nddolor\namet', 'lorem \nipsum\nddolor\namet', 'code1,code2,code3', '2022-01-13 08:51:05', NULL, 0), (101, 2, 4, 3, 1101, 'test data 2', '', 'lorem \nipsum\ndolor', 'lorem \nipsum\ndolor', 'code1,fcode2', '2022-01-13 10:01:09', NULL, 1), (102, 2, 4, 3, 1102, 'test ticket 3', '', 'lorem \ntest \nipsum\namet', 'lorem \ntest \nipsum\namet', 'test1,test2', '2022-01-13 10:46:39', NULL, 1), (103, 4, 4, 3, 1103, 'test ticket 321', '', 'asdsa\nasd\nasd', 'asdsadsa\nasd\nasd\nasd', 'asd,asdasd,asd', '2022-01-15 13:15:25', 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=utf8; -- -- Dumping data for table `ticket_attachments` -- INSERT INTO `ticket_attachments` (`id`, `ticket_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES (103, 100, '0c496602-740b-11ec-bf18-00ff70631b9a.mp4', 'piper.mp4', '2022-01-13 08:56:28', 1), (104, 100, '0f260c37-740b-11ec-bf18-00ff70631b9a.txt', 'Clearance.txt', '2022-01-13 08:56:28', 1), (105, 101, 'a45601e0-7414-11ec-bf18-00ff70631b9a.txt', 'Clearance.txt', '2022-01-13 10:00:55', 1), (107, 102, 'f49a55ba-741a-11ec-bf18-00ff70631b9a.png', 'Untitled.png', '2022-01-13 10:46:17', 1), (108, 102, 'fa6d6a5d-741a-11ec-bf18-00ff70631b9a.txt', 'mysql.txt', '2022-01-13 10:46:17', 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=utf8; -- -- Dumping data for table `ticket_progress_status` -- INSERT INTO `ticket_progress_status` (`id`, `ticket_id`, `user_id`, `ticket_status_id`, `date_added`, `status`) VALUES (60, 100, 2, 1, '2022-01-13 08:51:05', 1), (61, 101, 2, 1, '2022-01-13 09:09:54', 1), (62, 101, 2, 3, '2022-01-13 10:08:43', 1), (63, 102, 2, 1, '2022-01-13 10:45:41', 1), (64, 101, 2, 5, '2022-01-15 11:10:56', 1), (65, 101, 2, 3, '2022-01-15 11:11:01', 1), (66, 101, 2, 4, '2022-01-15 11:11:22', 1), (67, 101, 2, 3, '2022-01-15 11:11:38', 1), (68, 101, 2, 4, '2022-01-15 11:14:20', 1), (69, 101, 2, 3, '2022-01-15 11:25:40', 1), (70, 103, 4, 1, '2022-01-15 13:15:10', 1), (71, 103, 2, 3, '2022-01-15 13:15:46', 1), (72, 103, 2, 5, '2022-01-15 13:17:44', 1), (73, 103, 4, 4, '2022-01-15 13:18:25', 1), (74, 103, 4, 5, '2022-01-15 13:19:59', 1), (75, 103, 4, 3, '2022-01-15 13:20:02', 1), (76, 103, 4, 4, '2022-01-15 13:20:05', 1), (77, 103, 4, 3, '2022-01-15 13:20:27', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket_ratings` -- CREATE TABLE `ticket_ratings` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `rating` int DEFAULT NULL COMMENT 'stars given', `rating_comment` text COMMENT 'additional rate cpomment if available', `date_added` datetime DEFAULT NULL, `progress_status_id` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ticket_ratings` -- INSERT INTO `ticket_ratings` (`id`, `user_id`, `rating`, `rating_comment`, `date_added`, `progress_status_id`, `status`) VALUES (1, 2, 3, NULL, '2022-01-15 11:07:58', 62, 1), (2, 2, 2, NULL, '2022-01-15 11:07:58', 62, 1), (3, 2, 4, NULL, '2022-01-15 11:09:22', 62, 1), (4, 2, 4, NULL, '2022-01-15 11:11:08', 65, 1), (5, 2, 4, NULL, '2022-01-15 11:25:42', 69, 1), (6, 2, 3, NULL, '2022-01-15 11:25:46', 69, 1), (7, 2, 4, NULL, '2022-01-15 12:50:50', 69, 1), (8, 2, 2, NULL, '2022-01-15 12:50:54', 69, 1), (9, 2, 4, NULL, '2022-01-15 12:53:19', 69, 1), (10, 2, 5, NULL, '2022-01-15 12:53:23', 69, 1), (11, 2, 2, NULL, '2022-01-15 12:53:28', 69, 1), (12, 2, 1, NULL, '2022-01-15 12:53:30', 69, 1), (13, 2, 4, NULL, '2022-01-15 13:07:28', 69, 1), (14, 4, 1, NULL, '2022-01-15 13:16:39', 71, 1), (15, 4, 2, NULL, '2022-01-15 13:16:51', 71, 1), (16, 4, 4, NULL, '2022-01-15 13:17:17', 71, 1), (17, 4, 5, NULL, '2022-01-15 13:17:28', 71, 1), (18, 4, 4, NULL, '2022-01-15 13:17:32', 71, 1), (19, 4, 2, NULL, '2022-01-15 13:20:35', 77, 1), (20, 4, 3, NULL, '2022-01-15 13:30:50', 77, 1), (21, 4, 4, NULL, '2022-01-15 13:31:39', 77, 1), (22, 4, 3, NULL, '2022-01-15 13:33:41', 77, 1), (23, 4, 5, NULL, '2022-01-15 13:33:49', 77, 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=utf8; -- -- Dumping data for table `ticket_replies` -- INSERT INTO `ticket_replies` (`id`, `user_id`, `ticket_id`, `description`, `ticket_status_id`, `date_added`, `status`) VALUES (115, 2, 101, 'asd', 3, '2022-01-13 15:50:55', 1), (116, 2, 103, 'test', 3, '2022-01-15 13:21:52', 1), (117, 4, 103, 'testttt', 3, '2022-01-15 13:22:21', 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -- 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, `breakdown` int DEFAULT NULL, `on_site` int DEFAULT NULL, `workshop_visit_count` int DEFAULT NULL, `status` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 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`, `breakdown`, `on_site`, `workshop_visit_count`, `status`) VALUES (73, 100, 797, NULL, NULL, 'ABC1232', '34', '2342', 137, '34', NULL, 1, 45, 0), (74, 101, 797, NULL, NULL, 'ASDSA', 'AXCVCXV', '2342', 138, '23423', NULL, 1, NULL, 1), (75, 102, 813, NULL, NULL, 'ASDSAD', NULL, NULL, NULL, '324', NULL, 1, NULL, 1), (76, 103, 797, NULL, NULL, 'CS2323', 'SFDSDDSD', '2012', 142, '23', NULL, 1, NULL, 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=utf8; -- -- 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=utf8; -- -- Dumping data for table `user_accounts` -- INSERT INTO `user_accounts` (`id`, `user_id`, `role_id`, `username`, `password`, `is_active`) VALUES (1, 1, 13, '1', '$2y$10$qiWtgjgBBvJsGyOGuSG9U.ib7WHso7WYwWM1EuY1LmbF1WOId1L1y', 1), (2, 2, 13, 'arnel', '$2y$10$0.csmSGYg7pt2kdKw60r1.fAn4FqOveXL1o2f2DQSv6zLh7nm7fcC', 1), (3, 3, 13, '2374', '$2y$10$WFasrhDkCP8lMmLpptXw/urZWsfjH5VupQpFBRpjg6u.BgNF9Nu46', 1), (4, 4, 17, '60418', '$2y$10$YhjqmeJ64sFL8Rw0tQxKMO5SdnQFhhZelHg/7NX4rVIdVzmQ/5MbG', 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=utf8; -- -- Dumping data for table `user_categories` -- INSERT INTO `user_categories` (`id`, `name`, `status`) VALUES (1, 'Technician', 1), (2, 'Expert', 1), (3, 'Admin', 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=utf8; -- -- 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=utf8; -- -- 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), (47, 4, 98, '89b5fbb6-737a-11ec-b2af-00ff70631b9a', 2, '2022-01-12 15:37:47', 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=utf8; -- -- 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=utf8; -- -- 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=utf8; -- -- 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=utf8; -- -- 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), (137, 797, '34', 1), (138, 797, 'SDFDSFSD', 1), (139, 831, 'ASDASDA', 1), (140, 797, 'ASD', 1), (141, 815, 'ASDASDSA', 1), (142, 797, 'DSADASD', 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, `fault_codes` text, `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=utf8; -- -- Dumping data for table `videos` -- INSERT INTO `videos` (`id`, `user_id`, `sub_category_id`, `title`, `description`, `fault_codes`, `original_name`, `attachment_name`, `date_added`, `status`) VALUES (77, 2, 4, 'dasdasd', 'asdsadsad', 'xxxx,yyyy', 'piper.mp4', '1ed26fcd-7432-11ec-bf18-00ff70631b9a.mp4', '2022-01-13 13:31:55', 1), (78, 2, 7, 'test video 2', 'lorem\nipsum\ndolor\namet', 'test1,test2', 'piper.mp4', '3cda3caf-743a-11ec-bf18-00ff70631b9a.mp4', '2022-01-13 14:30:01', 1); -- -------------------------------------------------------- -- -- 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=utf8; -- -- Dumping data for table `video_attachments` -- INSERT INTO `video_attachments` (`id`, `video_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES (31, 78, '443c5527-743a-11ec-bf18-00ff70631b9a.txt', 'Clearance.txt', '2022-01-13 14:30:14', 1); -- -------------------------------------------------------- -- -- 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -------------------------------------------------------- -- -- 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=utf8; -- -- Dumping data for table `video_type_vehicles` -- INSERT INTO `video_type_vehicles` (`id`, `video_id`, `brand_id`, `model_id`, `model_variant_id`, `status`) VALUES (40, 77, 123, 815, 141, 1), (41, 78, 123, 814, NULL, 1); -- -------------------------------------------------------- -- -- 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=utf8; -- -- 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 `log` -- ALTER TABLE `log` ADD PRIMARY KEY (`id`), ADD KEY `index2` (`target_id`), ADD KEY `log_fk1_idx` (`user_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_ratings` -- ALTER TABLE `ticket_ratings` ADD PRIMARY KEY (`id`), ADD KEY `ticket_ratings_fk1_idx` (`user_id`), ADD KEY `ticket_ratings_fk2_idx` (`progress_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=180; -- -- AUTO_INCREMENT for table `cnf_roles` -- ALTER TABLE `cnf_roles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `cnf_role_access` -- ALTER TABLE `cnf_role_access` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- 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=29; -- -- AUTO_INCREMENT for table `knowledgebase_attachments` -- ALTER TABLE `knowledgebase_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- 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=21; -- -- AUTO_INCREMENT for table `knowledgebase_views` -- ALTER TABLE `knowledgebase_views` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `log` -- ALTER TABLE `log` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67; -- -- 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=104; -- -- AUTO_INCREMENT for table `ticket_attachments` -- ALTER TABLE `ticket_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109; -- -- AUTO_INCREMENT for table `ticket_progress_status` -- ALTER TABLE `ticket_progress_status` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78; -- -- AUTO_INCREMENT for table `ticket_ratings` -- ALTER TABLE `ticket_ratings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `ticket_replies` -- ALTER TABLE `ticket_replies` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118; -- -- AUTO_INCREMENT for table `ticket_reply_attachments` -- ALTER TABLE `ticket_reply_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- 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=77; -- -- 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=4; -- -- 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=48; -- -- 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=143; -- -- AUTO_INCREMENT for table `videos` -- ALTER TABLE `videos` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79; -- -- AUTO_INCREMENT for table `video_attachments` -- ALTER TABLE `video_attachments` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- 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=42; -- -- 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 `log` -- ALTER TABLE `log` ADD CONSTRAINT `log_fk1` 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_ratings` -- ALTER TABLE `ticket_ratings` ADD CONSTRAINT `ticket_ratings_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `ticket_ratings_fk2` FOREIGN KEY (`progress_status_id`) REFERENCES `ticket_progress_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 |
proxy
|
phpinfo
|
Settings