File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/db.tar
Back
rating_system_schema.sql 0000644 00000107416 15024716427 0011516 0 ustar 00 -- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.29 - MySQL Community Server - GPL -- Server OS: Win64 -- HeidiSQL Version: 12.5.0.6677 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping structure for table autohub_rating_system.abilities DROP TABLE IF EXISTS `abilities`; CREATE TABLE IF NOT EXISTS `abilities` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_id` bigint unsigned DEFAULT NULL, `entity_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `only_owned` tinyint(1) NOT NULL DEFAULT '0', `options` json DEFAULT NULL, `scope` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `abilities_scope_index` (`scope`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.abilities: ~21 rows (approximately) INSERT INTO `abilities` (`id`, `name`, `title`, `entity_id`, `entity_type`, `only_owned`, `options`, `scope`, `created_at`, `updated_at`) VALUES (1, 'create-system', 'Create System', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (2, 'edit-system', 'Edit System', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (3, 'delete-system', 'Delete System', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (4, 'view-system', 'View System', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (5, 'create-template', 'Create Template', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (6, 'edit-template', 'Edit Template', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (7, 'delete-template', 'Delete Template', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (8, 'view-template', 'View Template', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (9, 'create-question', 'Create Question', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (10, 'edit-question', 'Edit Question', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (11, 'delete-question', 'Delete Question', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (12, 'view-question', 'View Question', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (13, 'create-questionnaire', 'Create Questionnaire', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (14, 'edit-questionnaire', 'Edit Questionnaire', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (15, 'delete-questionnaire', 'Delete Questionnaire', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (16, 'view-questionnaire', 'View Questionnaire', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (17, 'generate-report', 'Generate Report', NULL, NULL, 0, NULL, NULL, '2023-07-24 06:04:40', '2023-07-24 06:04:40'), (18, 'update-user', 'Update User', NULL, NULL, 0, NULL, NULL, '2023-07-26 17:59:47', '2023-07-26 17:59:47'), (19, '*', 'All abilities', NULL, '*', 0, NULL, NULL, '2023-07-26 18:07:07', '2023-07-26 18:07:07'), (20, 'view-email', 'View Email', NULL, NULL, 0, NULL, NULL, '2023-07-27 08:10:08', '2023-07-27 08:10:08'), (21, 'setup-company', 'Setup Company', NULL, NULL, 0, NULL, NULL, '2023-07-27 08:10:08', '2023-07-27 08:10:08'); -- Dumping structure for table autohub_rating_system.answers DROP TABLE IF EXISTS `answers`; CREATE TABLE IF NOT EXISTS `answers` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `qstnn_id` int DEFAULT NULL, `tmpt_id` int NOT NULL, `qst_id` varchar(455) NOT NULL, `syst_id` int DEFAULT NULL, `rating` varchar(455) NOT NULL, `comment` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`,`qstnn_id`,`tmpt_id`,`syst_id`), KEY `qstnn_id` (`qstnn_id`), KEY `syst_id` (`syst_id`), KEY `tmpt_id` (`tmpt_id`), CONSTRAINT `qstnn_id` FOREIGN KEY (`qstnn_id`) REFERENCES `questionnaires` (`id`), CONSTRAINT `syst_id` FOREIGN KEY (`syst_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.answers: ~1 rows (approximately) INSERT INTO `answers` (`id`, `user_id`, `qstnn_id`, `tmpt_id`, `qst_id`, `syst_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES (52, 11, 2, 1, '[1,2,3,4,5]', 1, '[4,4,5,4,5]', NULL, '2023-08-01 15:22:23', '2023-08-01 15:22:23'), (53, 15, 2, 1, '[1,2,3,4,5]', 1, '[4,5,4,4,4]', 'nice', '2023-08-27 22:18:28', '2023-08-27 22:18:28'); -- Dumping structure for table autohub_rating_system.assigned_roles DROP TABLE IF EXISTS `assigned_roles`; CREATE TABLE IF NOT EXISTS `assigned_roles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `role_id` bigint unsigned NOT NULL, `entity_id` bigint unsigned NOT NULL, `entity_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `restricted_to_id` bigint unsigned DEFAULT NULL, `restricted_to_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scope` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `assigned_roles_entity_index` (`entity_id`,`entity_type`,`scope`), KEY `assigned_roles_role_id_index` (`role_id`), KEY `assigned_roles_scope_index` (`scope`), CONSTRAINT `assigned_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.assigned_roles: ~5 rows (approximately) INSERT INTO `assigned_roles` (`id`, `role_id`, `entity_id`, `entity_type`, `restricted_to_id`, `restricted_to_type`, `scope`) VALUES (2, 3, 1, 'App\\Models\\User', NULL, NULL, NULL), (3, 3, 7, 'App\\Models\\User', NULL, NULL, NULL), (5, 1, 10, 'App\\Models\\User', NULL, NULL, NULL), (6, 1, 13, 'App\\Models\\User', NULL, NULL, NULL), (7, 1, 14, 'App\\Models\\User', NULL, NULL, NULL); -- Dumping structure for table autohub_rating_system.audit_trail DROP TABLE IF EXISTS `audit_trail`; CREATE TABLE IF NOT EXISTS `audit_trail` ( `id` int NOT NULL AUTO_INCREMENT, `usr` int unsigned NOT NULL, `action` varchar(100) NOT NULL, `created_at` datetime DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `usr_idx` (`usr`), CONSTRAINT `usr` FOREIGN KEY (`usr`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.audit_trail: ~52 rows (approximately) INSERT INTO `audit_trail` (`id`, `usr`, `action`, `created_at`, `updated_at`, `deleted_at`) VALUES (10, 10, '60543 has logged in.', '2023-07-27 13:53:47', NULL, NULL), (11, 10, '60543 has logged in.', '2023-07-27 13:58:15', NULL, NULL), (12, 1, '0 has logged in.', '2023-07-27 15:30:20', NULL, NULL), (13, 10, '60543 has logged in.', '2023-07-27 15:45:49', NULL, NULL), (14, 1, '0 has logged in.', '2023-07-27 15:50:41', NULL, NULL), (15, 1, '1 has logged in.', '2023-07-27 17:57:35', NULL, NULL), (16, 1, '1 has logged in.', '2023-07-27 23:42:48', NULL, NULL), (17, 1, '1 has created a questionnaire.', '2023-07-27 23:49:52', NULL, NULL), (18, 1, '1 has logged in.', '2023-07-28 00:04:48', NULL, NULL), (19, 10, '10 has logged in.', '2023-08-01 15:13:42', NULL, NULL), (20, 1, '1 has logged in.', '2023-08-01 15:16:32', NULL, NULL), (21, 10, '10 has logged in.', '2023-08-03 15:18:36', NULL, NULL), (22, 1, '1 has logged in.', '2023-08-03 15:20:28', NULL, NULL), (23, 10, '10 has logged in.', '2023-08-07 09:19:21', NULL, NULL), (24, 10, '10 has logged in.', '2023-08-07 10:30:03', NULL, NULL), (25, 1, '1 has logged in.', '2023-08-07 10:32:47', NULL, NULL), (26, 10, '10 has logged in.', '2023-08-08 13:12:13', NULL, NULL), (27, 10, '10 has logged in.', '2023-08-08 13:27:15', NULL, NULL), (28, 1, '1 has logged in.', '2023-08-08 13:36:23', NULL, NULL), (29, 10, '10 has logged in.', '2023-08-08 13:38:35', NULL, NULL), (30, 1, '1 has logged in.', '2023-08-08 15:29:45', NULL, NULL), (31, 1, '1 has logged in.', '2023-08-09 08:29:17', NULL, NULL), (32, 10, '10 has logged in.', '2023-08-10 13:30:37', NULL, NULL), (33, 10, '10 has logged in.', '2023-08-11 08:16:02', NULL, NULL), (34, 10, '10 has logged in.', '2023-08-11 09:34:40', NULL, NULL), (35, 10, '10 has logged in.', '2023-08-13 21:17:09', NULL, NULL), (36, 10, '10 has logged in.', '2023-08-14 08:37:58', NULL, NULL), (37, 10, '10 has created a template.', '2023-08-14 15:51:43', NULL, NULL), (38, 10, '10 has updated a template.', '2023-08-14 15:52:00', NULL, NULL), (39, 10, '10 has created a questionnaire.', '2023-08-14 15:55:47', NULL, NULL), (40, 10, '10 has logged in.', '2023-08-16 10:45:57', NULL, NULL), (41, 10, '10 has logged in.', '2023-08-17 08:20:26', NULL, NULL), (42, 10, '10 has logged in.', '2023-08-17 09:58:18', NULL, NULL), (43, 10, '10 has logged in.', '2023-08-17 10:20:42', NULL, NULL), (44, 10, '10 has logged in.', '2023-08-17 13:31:06', NULL, NULL), (45, 10, '10 has updated a questionnaire.', '2023-08-17 13:39:18', NULL, NULL), (46, 10, '10 has logged in.', '2023-08-17 14:02:22', NULL, NULL), (47, 10, '10 has logged in.', '2023-08-17 16:32:14', NULL, NULL), (48, 10, '10 has logged in.', '2023-08-24 14:20:16', NULL, NULL), (49, 10, '10 has logged in.', '2023-08-25 08:33:18', NULL, NULL), (50, 10, '10 has logged in.', '2023-08-25 08:41:05', NULL, NULL), (51, 10, '10 has logged in.', '2023-08-25 14:02:47', NULL, NULL), (52, 10, '10 has logged in.', '2023-08-27 21:51:18', NULL, NULL), (53, 10, '10 has logged in.', '2023-08-29 09:59:08', NULL, NULL), (54, 10, '10 has logged in.', '2023-08-29 10:34:50', NULL, NULL), (55, 10, '10 has logged in.', '2023-08-30 10:17:57', NULL, NULL), (56, 10, '10 has logged in.', '2023-08-30 15:12:26', NULL, NULL), (57, 10, '10 has updated a questionnaire.', '2023-08-30 15:13:43', NULL, NULL), (58, 10, '10 has logged in.', '2023-08-30 15:49:22', NULL, NULL), (59, 10, '10 has logged in.', '2023-08-31 08:36:23', NULL, NULL), (60, 10, '10 has logged in.', '2023-08-31 13:00:35', NULL, NULL), (61, 10, '10 has logged in.', '2023-08-31 13:21:06', NULL, NULL), (62, 10, '10 has logged in.', '2023-08-31 13:54:04', NULL, NULL), (63, 10, '10 has logged in.', '2023-08-31 15:49:45', NULL, NULL), (64, 10, '10 has logged in.', '2023-09-21 10:42:20', NULL, NULL), (65, 10, '10 has logged in.', '2023-09-21 13:24:23', NULL, NULL), (66, 10, '10 has logged in.', '2023-09-22 08:45:12', NULL, NULL), (67, 10, '10 has logged in.', '2023-09-22 13:19:17', NULL, NULL), (68, 10, '10 has logged in.', '2023-09-25 15:27:21', NULL, NULL), (69, 10, '10 has logged in.', '2023-09-27 13:27:20', NULL, NULL); -- Dumping structure for table autohub_rating_system.companies DROP TABLE IF EXISTS `companies`; CREATE TABLE IF NOT EXISTS `companies` ( `id` int NOT NULL, `comp_code` varchar(45) NOT NULL, `comp_name` varchar(45) NOT NULL, `created_at` datetime NOT NULL, `active` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.companies: ~25 rows (approximately) INSERT INTO `companies` (`id`, `comp_code`, `comp_name`, `created_at`, `active`, `status`) VALUES (11, 'AHG', 'Autohub Group of Companies Inc.', '2023-07-24 03:41:34', '1', '1'), (12, 'APE', 'Autoitalia Philippines Ent.', '2023-07-24 03:41:34', '1', '1'), (13, 'BBAI', 'British Bespoke Automobiles Inc.', '2023-07-24 03:41:34', '1', '1'), (14, 'BUAI', 'British United Automobile Inc.', '2023-07-24 03:41:34', '1', '1'), (16, 'GCASI', 'Global City Auto Sales Inc', '2023-07-24 03:41:34', '1', '1'), (17, 'GCCLTC', 'Global City Car Lease & Transport Corp.', '2023-07-24 03:41:34', '1', '1'), (19, 'MGM', 'MGM Motor Trading', '2023-07-24 03:41:34', '1', '1'), (20, 'MOTO', 'Motoitalia Phil. Inc.', '2023-07-24 03:41:34', '1', '1'), (21, 'SAPI', 'Supreme Autozone Phil. Inc', '2023-07-24 03:41:34', '1', '1'), (22, 'VKOOL', 'VKool Phil. Inc', '2023-07-24 03:41:34', '1', '1'), (24, 'AIT', 'Autohub Institute of Technology Inc.', '2023-07-24 03:41:34', '1', '1'), (25, 'AUTOPR', 'Autopremium Inc.', '2023-07-24 03:41:34', '1', '1'), (26, 'LEAP', 'Leading Edge Automobile Phil. Inc', '2023-07-24 03:41:34', '1', '1'), (27, 'BICI', 'BRITISH ICONIC CARS INC.', '2023-07-24 03:41:34', '1', '1'), (28, 'BRCI', 'BRITISH RACING CARS, INC', '2023-07-24 03:41:34', '1', '1'), (29, 'MGMMI', 'MGM MOTORS MINDANAO INC.', '2023-07-24 03:41:34', '1', '1'), (30, 'MCMI', 'MILLENIUM CARS MINDANAO INC.', '2023-07-24 03:41:34', '1', '1'), (31, 'PGBVI', 'PALAWAN GLOBAL BUSINESS VENTURES, INC.', '2023-07-24 03:41:34', '1', '1'), (32, 'RENTH', 'RENTHUB, INC.', '2023-07-24 03:41:34', '1', '1'), (33, 'TMPI', 'TRIUMPH MOTORCYCLES PHILIPPINES, INC.', '2023-07-24 03:41:34', '1', '1'), (34, 'ZOOMHUB', 'ZOOMHUB INC', '2023-07-24 03:41:34', '1', '1'), (38, 'MGMI', ' Millenium Gallery Motors Inc.,', '2023-07-24 03:41:34', '1', '1'), (39, 'GEM', 'GLOBAL EXCELLENCE MOTORS INC', '2023-07-24 03:41:34', '1', '1'), (40, 'EXTDEALER', 'VESPA EXTERNAL DEALERS', '2023-07-24 03:41:34', '1', '1'), (41, 'SAPI-VAL', 'SUPREME AUTOZONE PHIL. INC- VAL', '2023-07-24 03:41:34', '1', '1'); -- Dumping structure for table autohub_rating_system.device_access DROP TABLE IF EXISTS `device_access`; CREATE TABLE IF NOT EXISTS `device_access` ( `id` int NOT NULL AUTO_INCREMENT, `tablet` int NOT NULL DEFAULT '0', `mobile` int NOT NULL DEFAULT '0', `pc` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.device_access: ~0 rows (approximately) INSERT INTO `device_access` (`id`, `tablet`, `mobile`, `pc`) VALUES (1, 0, 20, 12); -- Dumping structure for table autohub_rating_system.disclaimer DROP TABLE IF EXISTS `disclaimer`; CREATE TABLE IF NOT EXISTS `disclaimer` ( `id` int NOT NULL, `content` varchar(1000) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.disclaimer: ~1 rows (approximately) INSERT INTO `disclaimer` (`id`, `content`) VALUES (1, 'We at Autohub-Group of Companies Inc. take the protection of your personal information seriously. The information you provide on our establishment’s customer kiosk, including your first name, last name, email, mobile number, and optional photograph, is collected solely for the purpose of monitoring your account transactions and providing you with better customer service, including promotions, newsletters, and product information. By providing your personal information, you consent to the collection, use, processing, storage, and retention of all personal information you hereby freely provide to AutoHub Group of Companies Inc. doing business as AGC.\n \nBy consenting to this data privacy notice, you acknowledge that we will share the information you provide through this devise exclusively within the Autohub Group, including its affiliates and subsidiaries, for the specified purposes only. We shall implement reasonable and appropriate organizational, physical, and technical security meas'); -- Dumping structure for table autohub_rating_system.email_responses DROP TABLE IF EXISTS `email_responses`; CREATE TABLE IF NOT EXISTS `email_responses` ( `id` int NOT NULL AUTO_INCREMENT, `user` int unsigned NOT NULL, `ans` int NOT NULL, `email` varchar(45) NOT NULL, `created_at` datetime NOT NULL, `status` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_idx` (`user`), KEY `ans_idx` (`ans`), CONSTRAINT `ans` FOREIGN KEY (`ans`) REFERENCES `answers` (`id`), CONSTRAINT `user` FOREIGN KEY (`user`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.email_responses: ~0 rows (approximately) INSERT INTO `email_responses` (`id`, `user`, `ans`, `email`, `created_at`, `status`) VALUES (1, 11, 52, 'first@autohubgroup.com', '2023-08-01 07:22:25', 0), (2, 15, 53, 'try@autohubgroup.com', '2023-08-27 14:18:30', 0); -- Dumping structure for table autohub_rating_system.failed_jobs DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.failed_jobs: ~0 rows (approximately) -- Dumping structure for table autohub_rating_system.forget_password DROP TABLE IF EXISTS `forget_password`; CREATE TABLE IF NOT EXISTS `forget_password` ( `id` int NOT NULL AUTO_INCREMENT, `email` varchar(45) DEFAULT NULL, `token` varchar(45) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `expires_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 KEY_BLOCK_SIZE=2; -- Dumping data for table autohub_rating_system.forget_password: ~0 rows (approximately) -- Dumping structure for table autohub_rating_system.links DROP TABLE IF EXISTS `links`; CREATE TABLE IF NOT EXISTS `links` ( `id` int NOT NULL AUTO_INCREMENT, `sys_id` int NOT NULL, `tmp_id` int NOT NULL, `link` varchar(255) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `active` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), KEY `sys_id_idx` (`sys_id`), KEY `tmp_id_idx` (`tmp_id`), CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `templates` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.links: ~0 rows (approximately) INSERT INTO `links` (`id`, `sys_id`, `tmp_id`, `link`, `created_at`, `updated_at`, `active`, `status`) VALUES (1, 3, 1, 'http://127.0.0.1:8000/search/s/3/tid/1', '2023-03-28 01:52:25', '2023-03-28 01:52:25', '1', '1'), (2, 1, 1, 'http://127.0.0.1:8000/search/s/1/tid/1', '2023-07-27 15:49:52', '2023-07-27 15:49:52', '1', '1'), (3, 3, 2, 'http://127.0.0.1:8000/search/s/3/tid/2', '2023-08-14 07:55:47', '2023-08-14 07:55:47', '1', '1'); -- Dumping structure for table autohub_rating_system.migrations DROP TABLE IF EXISTS `migrations`; CREATE TABLE IF NOT EXISTS `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.migrations: ~2 rows (approximately) INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2023_07_24_023608_create_bouncer_tables', 1), (2, '2023_07_24_031700_create_bouncer_tables', 2); -- Dumping structure for table autohub_rating_system.password_resets DROP TABLE IF EXISTS `password_resets`; CREATE TABLE IF NOT EXISTS `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.password_resets: ~0 rows (approximately) -- Dumping structure for table autohub_rating_system.permissions DROP TABLE IF EXISTS `permissions`; CREATE TABLE IF NOT EXISTS `permissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `ability_id` bigint unsigned NOT NULL, `entity_id` bigint unsigned DEFAULT NULL, `entity_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `forbidden` tinyint(1) NOT NULL DEFAULT '0', `scope` int DEFAULT NULL, PRIMARY KEY (`id`), KEY `permissions_entity_index` (`entity_id`,`entity_type`,`scope`), KEY `permissions_ability_id_index` (`ability_id`), KEY `permissions_scope_index` (`scope`), CONSTRAINT `permissions_ability_id_foreign` FOREIGN KEY (`ability_id`) REFERENCES `abilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=226 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.permissions: ~42 rows (approximately) INSERT INTO `permissions` (`id`, `ability_id`, `entity_id`, `entity_type`, `forbidden`, `scope`) VALUES (184, 21, 3, 'roles', 0, NULL), (185, 1, 1, 'roles', 0, NULL), (186, 2, 1, 'roles', 0, NULL), (187, 3, 1, 'roles', 0, NULL), (188, 4, 1, 'roles', 0, NULL), (189, 5, 1, 'roles', 0, NULL), (190, 6, 1, 'roles', 0, NULL), (191, 7, 1, 'roles', 0, NULL), (192, 8, 1, 'roles', 0, NULL), (193, 9, 1, 'roles', 0, NULL), (194, 10, 1, 'roles', 0, NULL), (195, 11, 1, 'roles', 0, NULL), (196, 12, 1, 'roles', 0, NULL), (197, 13, 1, 'roles', 0, NULL), (198, 14, 1, 'roles', 0, NULL), (199, 15, 1, 'roles', 0, NULL), (200, 16, 1, 'roles', 0, NULL), (201, 17, 1, 'roles', 0, NULL), (202, 18, 1, 'roles', 0, NULL), (203, 20, 1, 'roles', 0, NULL), (204, 21, 1, 'roles', 0, NULL), (205, 1, 4, 'roles', 0, NULL), (206, 2, 4, 'roles', 0, NULL), (207, 3, 4, 'roles', 0, NULL), (208, 4, 4, 'roles', 0, NULL), (209, 5, 4, 'roles', 0, NULL), (210, 6, 4, 'roles', 0, NULL), (211, 7, 4, 'roles', 0, NULL), (212, 8, 4, 'roles', 0, NULL), (213, 9, 4, 'roles', 0, NULL), (214, 10, 4, 'roles', 0, NULL), (215, 11, 4, 'roles', 0, NULL), (216, 12, 4, 'roles', 0, NULL), (217, 13, 4, 'roles', 0, NULL), (218, 14, 4, 'roles', 0, NULL), (219, 15, 4, 'roles', 0, NULL), (220, 16, 4, 'roles', 0, NULL), (221, 17, 4, 'roles', 0, NULL), (222, 18, 4, 'roles', 0, NULL), (223, 19, 4, 'roles', 0, NULL), (224, 20, 4, 'roles', 0, NULL), (225, 21, 4, 'roles', 0, NULL); -- Dumping structure for table autohub_rating_system.personal_access_tokens DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.personal_access_tokens: ~0 rows (approximately) -- Dumping structure for table autohub_rating_system.questionnaires DROP TABLE IF EXISTS `questionnaires`; CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` int NOT NULL AUTO_INCREMENT, `s_id` int NOT NULL, `t_id` int NOT NULL, `instruction` text CHARACTER SET utf8mb3 COLLATE utf8_general_ci, `created_at` datetime DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `status` varchar(45) DEFAULT NULL, `active` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `s_id` (`s_id`,`t_id`), KEY `system_id_idx` (`s_id`), KEY `t_id_idx` (`t_id`), CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `templates` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.questionnaires: ~3 rows (approximately) INSERT INTO `questionnaires` (`id`, `s_id`, `t_id`, `instruction`, `created_at`, `updated_at`, `status`, `active`) VALUES (1, 3, 1, 'rate 5 star being the highest, 1 being the lowest', '2023-03-28 09:52:25', '2023-07-24 08:22:10', NULL, '1'), (2, 1, 1, 'The objective of this survey to assess the effectiveness of our system and to focus on which sides to improve further.\n\nThis will take 2-3 mins. your time. We highly appreciate your response. Thank You.', '2023-07-27 23:49:52', NULL, '1', '1'), (3, 3, 2, 'We at Autohub-Group of Companies Inc. take the protection of your personal information seriously. The information you provide on our establishment’s customer kiosk, including your first name, last name, email, mobile number, and optional photograph, is collected solely for the purpose of monitoring your account transactions and providing you with better customer service, including promotions, newsletters, and product information. By providing your personal information, you consent to the collection, use, processing, storage, and retention of all personal information you hereby freely provide to AutoHub Group of Companies Inc. doing business as AGC.\r\n \r\nBy consenting to this data privacy notice, you acknowledge that we will share the information you provide through this devise exclusively within the Autohub Group, including its affiliates and subsidiaries, for the specified purposes only. We shall implement reasonable and appropriate organizational, physical, and technical security meas', '2023-08-14 15:55:47', '2023-08-30 07:13:43', '1', '1'); -- Dumping structure for table autohub_rating_system.questions DROP TABLE IF EXISTS `questions`; CREATE TABLE IF NOT EXISTS `questions` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, `active` varchar(45) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.questions: ~17 rows (approximately) INSERT INTO `questions` (`id`, `title`, `status`, `active`, `created_at`, `updated_at`) VALUES (1, 'How easy was it to navigate the system?\\n(1 - very difficult, 5 - very easy)', '1', '1', '2023-03-28 01:46:32', '2023-03-28 01:46:32'), (2, 'How intuitive was the system? (1 - not at all, 5 - very intuitive)', '1', '1', '2023-03-28 01:46:41', '2023-03-28 01:46:41'), (3, 'How fast did the system respond to your inputs? (1 - very slow, 5 - very fast)', '1', '1', '2023-03-28 01:47:10', '2023-03-28 01:47:10'), (4, 'How reliable was the system? (1 - not at all, 5 - extremely reliable)', '1', '1', '2023-03-28 01:47:18', '2023-03-28 01:47:18'), (5, 'How well did the system meet your needs? (1 - not at all, 5 - exceeded my expectations)', '1', '1', '2023-03-28 01:47:26', '2023-03-28 01:47:26'), (6, 'How visually appealing was the system? (1 - very unattractive, 5 - very attractive)', '1', '1', '2023-03-28 01:47:37', '2023-03-28 01:47:37'), (7, 'How well did the system perform its intended function? (1 - poorly, 5 - perfectly)', '1', '1', '2023-03-28 01:47:44', '2023-03-28 01:47:44'), (8, 'How well did the system integrate with other tools? (1 - not at all, 5 - seamlessly)', '1', '1', '2023-03-28 01:47:52', '2023-03-28 01:47:52'), (9, 'How informative were the system\'s error messages? (1 - not at all, 5 - very informative)', '1', '1', '2023-03-28 01:48:00', '2023-03-28 01:48:00'), (10, 'How easy was it to find the information you needed in the system? (1 - very difficult, 5 - very easy)', '1', '1', '2023-03-28 01:48:08', '2023-03-28 01:48:08'), (11, 'How well did the system support collaboration with others? (1 - not at all, 5 - very well)', '1', '1', '2023-03-28 01:48:18', '2023-03-28 01:48:18'), (12, 'How secure did you feel using the system? (1 - very insecure, 5 - very secure)', '1', '1', '2023-03-28 01:48:26', '2023-03-28 01:48:26'), (13, 'How well did the system handle large amounts of data? (1 - poorly, 5 - flawlessly)', '1', '1', '2023-03-28 01:48:34', '2023-03-28 01:48:34'), (14, 'How easy was it to customize the system to your preferences? (1 - very difficult, 5 - very easy)', '1', '1', '2023-03-28 01:48:41', '2023-03-28 01:48:41'), (15, 'How well did the system integrate with your workflow? (1 - not at all, 5 - seamlessly)', '1', '1', '2023-03-28 01:48:48', '2023-03-28 01:48:48'), (16, 'How well did the system handle unexpected situations? (1 - poorly, 5 - very well)', '1', '1', '2023-03-28 01:49:01', '2023-03-28 01:49:01'), (17, 'How user-friendly was the system\'s interface? (1 - not at all, 5 - extremely user-friendly)', '1', '1', '2023-03-28 01:49:09', '2023-03-28 01:49:09'), (18, 'How well did the system scale with increasing usage? (1 - poorly, 5 - flawlessly)', '1', '1', '2023-03-28 01:49:17', '2023-03-28 01:49:17'), (19, 'How easy was it to learn to use the system? (1 - very difficult, 5 - very easy)', NULL, NULL, '2023-03-28 01:49:26', '2023-08-17 05:08:35'), (20, 'How well did the system meet industry standards and best practices? (1 - not at all, 5 - exceeded industry standards)', NULL, NULL, '2023-03-28 01:49:34', '2023-08-17 05:07:48'); -- Dumping structure for table autohub_rating_system.roles DROP TABLE IF EXISTS `roles`; CREATE TABLE IF NOT EXISTS `roles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scope` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`,`scope`), KEY `roles_scope_index` (`scope`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.roles: ~3 rows (approximately) INSERT INTO `roles` (`id`, `name`, `title`, `scope`, `created_at`, `updated_at`) VALUES (1, 'system-admin', 'System Administrator', NULL, '2023-07-25 01:36:35', '2023-07-25 01:36:35'), (2, 'admin1', 'Administrator1', NULL, '2023-07-25 01:36:35', '2023-07-25 01:36:35'), (3, 'admin2', 'Administrator2', NULL, '2023-07-25 01:36:35', '2023-07-25 01:36:35'), (4, 'new-role', 'New role', NULL, '2023-09-21 18:26:58', '2023-09-21 18:26:58'); -- Dumping structure for table autohub_rating_system.systems DROP TABLE IF EXISTS `systems`; CREATE TABLE IF NOT EXISTS `systems` ( `id` int NOT NULL AUTO_INCREMENT, `system_name` varchar(45) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `active` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.systems: ~2 rows (approximately) INSERT INTO `systems` (`id`, `system_name`, `created_at`, `updated_at`, `active`, `status`) VALUES (1, 'HRIS', '2023-03-28 01:51:03', '2023-03-28 01:51:03', '1', '1'), (2, 'DataCon', '2023-03-28 01:51:12', '2023-03-28 01:51:12', '1', '1'), (3, 'E-com', '2023-03-28 01:51:17', '2023-03-28 01:51:17', '1', '1'); -- Dumping structure for table autohub_rating_system.templates DROP TABLE IF EXISTS `templates`; CREATE TABLE IF NOT EXISTS `templates` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(45) DEFAULT NULL, `q_id` varchar(999) DEFAULT NULL, `created_at` datetime DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, `active` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; -- Dumping data for table autohub_rating_system.templates: ~0 rows (approximately) INSERT INTO `templates` (`id`, `title`, `q_id`, `created_at`, `updated_at`, `active`, `status`) VALUES (1, 'Generic', '["1","2","3","4","5"]', '2023-03-28 01:51:36', '2023-03-30 05:18:57', '1', '1'), (2, 'Template 2', '["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"]', '2023-08-14 07:51:43', '2023-08-14 07:52:00', '1', '1'); -- Dumping structure for table autohub_rating_system.users DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `asa_id` int DEFAULT NULL, `f_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL, `l_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comp_id` int DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `type` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table autohub_rating_system.users: ~6 rows (approximately) INSERT INTO `users` (`id`, `asa_id`, `f_name`, `l_name`, `email`, `comp_id`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `type`) VALUES (1, 60544, 'admin', 'account', 'admin@email.com', 11, NULL, '$2a$12$geDODwlww8WwTOqV18zkX.lwaYqJYSjHRILAV0cKg32dM3fEKac8S', NULL, '2023-03-28 00:50:45', '2023-03-28 00:50:45', 'admin'), (7, NULL, 'Liezle', 'Mangada', 'lmangada@autohubgroup.com', 11, NULL, '$2y$10$LRNYsNGUoZxhBKbi3TOxWO4MH6wJC9/cu25YnAU7XRkAwNm/k2tla', NULL, '2023-04-25 18:34:08', '2023-04-25 18:34:08', 'admin'), (10, 60543, 'Adrian', 'Pusana', 'apusana2@autohubgroup.com', 11, NULL, '$2y$10$YYZT.DSFN21FvLnnkn5go.aCPs0BRmDWqigRA59sAI1mUG1qNRrCy', NULL, '2023-07-26 21:53:47', '2023-09-26 21:27:20', 'admin'), (11, NULL, 'First', 'Last', 'first@autohubgroup.com', 11, NULL, ' ', NULL, '2023-07-31 23:21:57', '2023-07-31 23:21:57', 'ratee'), (13, NULL, 'Adrian', 'Pusana', 'aguilaradrian423@autohubgroup.com', 11, NULL, ' ', NULL, '2023-08-08 17:35:52', '2023-08-08 17:35:52', 'ratee'), (14, NULL, 'Adrian', 'Pusana', 'a2@autohubgroup.com', 11, NULL, ' ', NULL, '2023-08-08 17:42:13', '2023-08-08 17:42:13', 'ratee'), (15, NULL, 'Try', 'Try', 'try@autohubgroup.com', 12, NULL, ' ', NULL, '2023-08-27 06:18:13', '2023-08-27 06:18:13', 'ratee'), (16, NULL, 'Adrina', 'Pusana', 'adrian@autohubgroup.com', 11, NULL, ' ', NULL, '2023-08-30 16:56:10', '2023-08-30 16:56:10', 'ratee'); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; ratings.sql 0000644 00000017557 15024716427 0006763 0 ustar 00 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `autohub_rating_system` DEFAULT CHARACTER SET utf8mb3 ; USE `autohub_rating_system` ; -- ----------------------------------------------------- -- Table `templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `user_id` (`user_id` ASC, `tmpt_id` ASC, `qst_id` ASC) VISIBLE, INDEX `t_id_idx` (`tmpt_id` ASC) VISIBLE, CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `systems` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `systems` ( `id` INT NOT NULL AUTO_INCREMENT, `system_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `links` ( `id` INT NOT NULL AUTO_INCREMENT, `sys_id` INT NOT NULL, `tmp_id` INT NOT NULL, `link` VARCHAR(255) NOT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sys_id_idx` (`sys_id` ASC) VISIBLE, INDEX `tmp_id_idx` (`tmp_id` ASC) VISIBLE, CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC) VISIBLE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `q_id` VARCHAR(455) NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `s_id` (`s_id` ASC, `t_id` ASC, `q_id` ASC) VISIBLE, INDEX `system_id_idx` (`s_id` ASC) VISIBLE, INDEX `t_id_idx` (`t_id` ASC) VISIBLE, CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 11 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `type` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; rating_system_with_passport.sql 0000644 00000103765 15024716427 0013167 0 ustar 00 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `autohub_rating_system` DEFAULT CHARACTER SET utf8mb3 ; -- ----------------------------------------------------- -- Schema autohub_ticketing -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_ticketing -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `autohub_ticketing` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ; USE `autohub_rating_system` ; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`abilities` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`abilities` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `only_owned` TINYINT(1) NOT NULL DEFAULT '0', `options` JSON NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `abilities_scope_index` (`scope` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 22 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`systems` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`systems` ( `id` INT NOT NULL AUTO_INCREMENT, `system_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `q_id` VARCHAR(999) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `instruction` VARCHAR(499) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `s_id` (`s_id` ASC, `t_id` ASC) VISIBLE, INDEX `system_id_idx` (`s_id` ASC) VISIBLE, INDEX `t_id_idx` (`t_id` ASC) VISIBLE, CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `autohub_rating_system`.`systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `autohub_rating_system`.`templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `qstnn_id` INT NULL DEFAULT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `syst_id` INT NULL DEFAULT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `user_id` (`user_id` ASC, `qstnn_id` ASC, `tmpt_id` ASC, `syst_id` ASC) VISIBLE, INDEX `qstnn_id` (`qstnn_id` ASC) VISIBLE, INDEX `syst_id` (`syst_id` ASC) VISIBLE, INDEX `tmpt_id` (`tmpt_id` ASC) VISIBLE, CONSTRAINT `qstnn_id` FOREIGN KEY (`qstnn_id`) REFERENCES `autohub_rating_system`.`questionnaires` (`id`), CONSTRAINT `syst_id` FOREIGN KEY (`syst_id`) REFERENCES `autohub_rating_system`.`systems` (`id`), CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `autohub_rating_system`.`templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 53 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `roles_name_unique` (`name` ASC, `scope` ASC) VISIBLE, INDEX `roles_scope_index` (`scope` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`assigned_roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`assigned_roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `role_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NOT NULL, `entity_type` VARCHAR(255) NOT NULL, `restricted_to_id` BIGINT UNSIGNED NULL DEFAULT NULL, `restricted_to_type` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `assigned_roles_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC) VISIBLE, INDEX `assigned_roles_role_id_index` (`role_id` ASC) VISIBLE, INDEX `assigned_roles_scope_index` (`scope` ASC) VISIBLE, CONSTRAINT `assigned_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `autohub_rating_system`.`roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `asa_id` INT NULL DEFAULT NULL, `f_name` VARCHAR(45) NOT NULL, `l_name` VARCHAR(45) NULL DEFAULT NULL, `email` VARCHAR(255) NOT NULL, `comp_id` INT NULL DEFAULT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `type` VARCHAR(45) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci' NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 12 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`audit_trail` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`audit_trail` ( `id` INT NOT NULL AUTO_INCREMENT, `usr` INT UNSIGNED NOT NULL, `action` VARCHAR(100) NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `usr_idx` (`usr` ASC) VISIBLE, CONSTRAINT `usr` FOREIGN KEY (`usr`) REFERENCES `autohub_rating_system`.`users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`companies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`companies` ( `id` INT NOT NULL, `comp_code` VARCHAR(45) NOT NULL, `comp_name` VARCHAR(45) NOT NULL, `created_at` DATETIME NOT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`device_access` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`device_access` ( `id` INT NOT NULL AUTO_INCREMENT, `tablet` INT NOT NULL DEFAULT '0', `mobile` INT NOT NULL DEFAULT '0', `pc` INT NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`disclaimer` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`disclaimer` ( `id` INT NOT NULL, `content` VARCHAR(1000) NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`email_responses` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`email_responses` ( `id` INT NOT NULL AUTO_INCREMENT, `user` INT UNSIGNED NOT NULL, `ans` INT NOT NULL, `email` VARCHAR(45) NOT NULL, `created_at` DATETIME NOT NULL, `status` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `user_idx` (`user` ASC) VISIBLE, INDEX `ans_idx` (`ans` ASC) VISIBLE, CONSTRAINT `ans` FOREIGN KEY (`ans`) REFERENCES `autohub_rating_system`.`answers` (`id`), CONSTRAINT `user` FOREIGN KEY (`user`) REFERENCES `autohub_rating_system`.`users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`forget_password` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`forget_password` ( `id` INT NOT NULL AUTO_INCREMENT, `email` VARCHAR(45) NULL DEFAULT NULL, `token` VARCHAR(45) NULL DEFAULT NULL, `link` VARCHAR(255) NULL DEFAULT NULL, `expires_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3 KEY_BLOCK_SIZE = 2; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`links` ( `id` INT NOT NULL AUTO_INCREMENT, `sys_id` INT NOT NULL, `tmp_id` INT NOT NULL, `link` VARCHAR(255) NOT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sys_id_idx` (`sys_id` ASC) VISIBLE, INDEX `tmp_id_idx` (`tmp_id` ASC) VISIBLE, CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `autohub_rating_system`.`systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `autohub_rating_system`.`templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`permissions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`permissions` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `ability_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `forbidden` TINYINT(1) NOT NULL DEFAULT '0', `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `permissions_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC) VISIBLE, INDEX `permissions_ability_id_index` (`ability_id` ASC) VISIBLE, INDEX `permissions_scope_index` (`scope` ASC) VISIBLE, CONSTRAINT `permissions_ability_id_foreign` FOREIGN KEY (`ability_id`) REFERENCES `autohub_rating_system`.`abilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 81 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC) VISIBLE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_rating_system`.`questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_rating_system`.`questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARACTER SET = utf8mb3; USE `autohub_ticketing` ; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`abilities` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`abilities` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `only_owned` TINYINT(1) NOT NULL DEFAULT '0', `options` JSON NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `abilities_scope_index` (`scope` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `roles_name_unique` (`name` ASC, `scope` ASC) VISIBLE, INDEX `roles_scope_index` (`scope` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`assigned_roles` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`assigned_roles` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `role_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NOT NULL, `entity_type` VARCHAR(255) NOT NULL, `restricted_to_id` BIGINT UNSIGNED NULL DEFAULT NULL, `restricted_to_type` VARCHAR(255) NULL DEFAULT NULL, `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `assigned_roles_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC) VISIBLE, INDEX `assigned_roles_role_id_index` (`role_id` ASC) VISIBLE, INDEX `assigned_roles_scope_index` (`scope` ASC) VISIBLE, CONSTRAINT `assigned_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `autohub_ticketing`.`roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 28 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`users` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `asa_id` VARCHAR(45) NULL DEFAULT NULL, `f_name` VARCHAR(255) NOT NULL, `l_name` VARCHAR(45) NULL DEFAULT NULL, `email` VARCHAR(255) NOT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `position` VARCHAR(45) NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, `department_id` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC) VISIBLE, INDEX `department_id_idx` (`department_id` ASC) VISIBLE, CONSTRAINT `department_id` FOREIGN KEY (`department_id`) REFERENCES `autohub_ticketing`.`departments` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 22 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`departments` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`departments` ( `id` INT NOT NULL, `dept_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `u_id` BIGINT UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `u_id_idx` (`u_id` ASC) VISIBLE, CONSTRAINT `u_id` FOREIGN KEY (`u_id`) REFERENCES `autohub_ticketing`.`users` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`service_level_agreement` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`service_level_agreement` ( `id` INT NOT NULL AUTO_INCREMENT, `content` INT NOT NULL, `type` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 9 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`categories` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`categories` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NOT NULL, `sla_id` INT NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `dept_id` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sla_id_idx` (`sla_id` ASC) VISIBLE, INDEX `dept_id_idx` (`dept_id` ASC) VISIBLE, CONSTRAINT `dept_id` FOREIGN KEY (`dept_id`) REFERENCES `autohub_ticketing`.`departments` (`id`), CONSTRAINT `sla_id` FOREIGN KEY (`sla_id`) REFERENCES `autohub_ticketing`.`service_level_agreement` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 51 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`companies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`companies` ( `id` INT NOT NULL, `comp_code` VARCHAR(45) NULL DEFAULT NULL, `comp_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`dealers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`dealers` ( `id` INT NOT NULL, `comp_id` INT NOT NULL, `dealer_code` VARCHAR(45) NULL DEFAULT NULL, `dealer_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `comp_id_idx` (`comp_id` ASC) VISIBLE, CONSTRAINT `comp_id` FOREIGN KEY (`comp_id`) REFERENCES `autohub_ticketing`.`companies` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`messages` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`messages` ( `id` INT NOT NULL AUTO_INCREMENT, `content` VARCHAR(1000) NOT NULL, `sender_id` BIGINT UNSIGNED NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `sender_id_idx` (`sender_id` ASC) VISIBLE, CONSTRAINT `sender_id` FOREIGN KEY (`sender_id`) REFERENCES `autohub_ticketing`.`users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 84 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`ticket` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`ticket` ( `id` INT NOT NULL AUTO_INCREMENT, `ticket_no` VARCHAR(45) NOT NULL, `subject` INT NOT NULL, `file` VARCHAR(45) NULL DEFAULT NULL, `description` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, `start_date` DATETIME NULL DEFAULT NULL, `end_date` DATETIME NULL DEFAULT NULL, `status` ENUM('active', 'pending', 'ongoing', 'closed') NULL DEFAULT NULL, `level` VARCHAR(45) NULL DEFAULT NULL, `active` INT NULL DEFAULT NULL, `ticket_creator` BIGINT UNSIGNED NOT NULL, `time_elapsed` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `subject_idx` (`subject` ASC) VISIBLE, INDEX `ticket_creator_idx` (`ticket_creator` ASC) VISIBLE, CONSTRAINT `subject` FOREIGN KEY (`subject`) REFERENCES `autohub_ticketing`.`categories` (`id`), CONSTRAINT `ticket_creator` FOREIGN KEY (`ticket_creator`) REFERENCES `autohub_ticketing`.`users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 74 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`message_ticket` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`message_ticket` ( `m_id` INT NOT NULL, `t_id` INT NOT NULL, INDEX `m_id_idx` (`m_id` ASC) VISIBLE, INDEX `t_id_idx` (`t_id` ASC) VISIBLE, CONSTRAINT `m_id` FOREIGN KEY (`m_id`) REFERENCES `autohub_ticketing`.`messages` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `autohub_ticketing`.`ticket` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 11 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`oauth_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`oauth_access_tokens` ( `id` VARCHAR(100) NOT NULL, `user_id` BIGINT UNSIGNED NULL DEFAULT NULL, `client_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NULL DEFAULT NULL, `scopes` TEXT NULL DEFAULT NULL, `revoked` TINYINT(1) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `oauth_access_tokens_user_id_index` (`user_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`oauth_auth_codes` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`oauth_auth_codes` ( `id` VARCHAR(100) NOT NULL, `user_id` BIGINT UNSIGNED NOT NULL, `client_id` BIGINT UNSIGNED NOT NULL, `scopes` TEXT NULL DEFAULT NULL, `revoked` TINYINT(1) NOT NULL, `expires_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `oauth_auth_codes_user_id_index` (`user_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`oauth_clients` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`oauth_clients` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` BIGINT UNSIGNED NULL DEFAULT NULL, `name` VARCHAR(255) NOT NULL, `secret` VARCHAR(100) NULL DEFAULT NULL, `provider` VARCHAR(255) NULL DEFAULT NULL, `redirect` TEXT NOT NULL, `personal_access_client` TINYINT(1) NOT NULL, `password_client` TINYINT(1) NOT NULL, `revoked` TINYINT(1) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `oauth_clients_user_id_index` (`user_id` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`oauth_personal_access_clients` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`oauth_personal_access_clients` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `client_id` BIGINT UNSIGNED NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`oauth_refresh_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`oauth_refresh_tokens` ( `id` VARCHAR(100) NOT NULL, `access_token_id` VARCHAR(100) NOT NULL, `revoked` TINYINT(1) NOT NULL, `expires_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `oauth_refresh_tokens_access_token_id_index` (`access_token_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`permissions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`permissions` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `ability_id` BIGINT UNSIGNED NOT NULL, `entity_id` BIGINT UNSIGNED NULL DEFAULT NULL, `entity_type` VARCHAR(255) NULL DEFAULT NULL, `forbidden` TINYINT(1) NOT NULL DEFAULT '0', `scope` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `permissions_entity_index` (`entity_id` ASC, `entity_type` ASC, `scope` ASC) VISIBLE, INDEX `permissions_ability_id_index` (`ability_id` ASC) VISIBLE, INDEX `permissions_scope_index` (`scope` ASC) VISIBLE, CONSTRAINT `permissions_ability_id_foreign` FOREIGN KEY (`ability_id`) REFERENCES `autohub_ticketing`.`abilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB AUTO_INCREMENT = 64 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC) VISIBLE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `autohub_ticketing`.`ticket_user` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `autohub_ticketing`.`ticket_user` ( `id` INT NOT NULL AUTO_INCREMENT, `tix_id` INT NOT NULL, `usr_id` BIGINT UNSIGNED NOT NULL, `assigned_to` BIGINT UNSIGNED NULL DEFAULT NULL, `assigned_dept` INT NOT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `remarks` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `start_date` DATETIME NULL DEFAULT NULL, `end_date` DATETIME NULL DEFAULT NULL, `time_elapsed` INT NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `tix_id_idx` (`tix_id` ASC) VISIBLE, INDEX `usr_id_idx` (`usr_id` ASC) VISIBLE, INDEX `assigned_to_idx` (`assigned_to` ASC) VISIBLE, INDEX `assigned_dept_idx` (`assigned_dept` ASC) VISIBLE, CONSTRAINT `assigned_dept` FOREIGN KEY (`assigned_dept`) REFERENCES `autohub_ticketing`.`departments` (`id`), CONSTRAINT `assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `autohub_ticketing`.`users` (`id`), CONSTRAINT `tix_id` FOREIGN KEY (`tix_id`) REFERENCES `autohub_ticketing`.`ticket` (`id`), CONSTRAINT `usr_id` FOREIGN KEY (`usr_id`) REFERENCES `autohub_ticketing`.`users` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 22 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; rating-systemV2.sql 0000644 00000022153 15024716427 0010316 0 ustar 00 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Table `systems` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `systems` ( `id` INT NOT NULL AUTO_INCREMENT, `system_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `q_id` VARCHAR(999) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `instruction` VARCHAR(499) NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `s_id` (`s_id` ASC, `t_id` ASC) VISIBLE, INDEX `system_id_idx` (`s_id` ASC) VISIBLE, INDEX `t_id_idx` (`t_id` ASC) VISIBLE, CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `qstnn_id` INT NULL DEFAULT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `syst_id` INT NULL DEFAULT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `user_id` (`user_id` ASC, `qstnn_id` ASC, `tmpt_id` ASC, `qst_id` ASC, `syst_id` ASC) VISIBLE, INDEX `t_id_idx` (`tmpt_id` ASC) VISIBLE, INDEX `syst_id_idx` (`syst_id` ASC) VISIBLE, INDEX `qstnn_id_idx` (`qstnn_id` ASC) VISIBLE, CONSTRAINT `qstnn_id` FOREIGN KEY (`qstnn_id`) REFERENCES `questionnaires` (`id`), CONSTRAINT `syst_id` FOREIGN KEY (`syst_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `device_access` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `device_access` ( `id` INT NOT NULL AUTO_INCREMENT, `tablet` INT NOT NULL DEFAULT '0', `mobile` INT NOT NULL DEFAULT '0', `pc` INT NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `forget_password` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `forget_password` ( `id` INT NOT NULL AUTO_INCREMENT, `email` VARCHAR(45) NULL DEFAULT NULL, `token` VARCHAR(45) NULL, `link` VARCHAR(255) NULL DEFAULT NULL, `expires_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3 KEY_BLOCK_SIZE = 2; -- ----------------------------------------------------- -- Table `links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `links` ( `id` INT NOT NULL AUTO_INCREMENT, `sys_id` INT NOT NULL, `tmp_id` INT NOT NULL, `link` VARCHAR(255) NOT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sys_id_idx` (`sys_id` ASC) VISIBLE, INDEX `tmp_id_idx` (`tmp_id` ASC) VISIBLE, CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC) VISIBLE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `f_name` VARCHAR(45) NOT NULL, `l_name` VARCHAR(45) NULL DEFAULT NULL, `email` VARCHAR(255) NOT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `type` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; rating_system_v5.mwb.bak 0000644 00000064516 15024716427 0011335 0 ustar 00 PK �[�V���hf f� document.mwb.xml�[sG�5�¡�0���M�苼�Q|�ڣ�L�"!m`�m���ER%�DU$���1�! c3Q����Y��������w�M���b�����y��?��'�/�����?����-�O�����?�������/������������`�=>{�����&'���.?�x�����w���p ��i}�Q�OW��w���x��NQH�%$�����TR1atQI��>;�ez����?��?���{�.F��Ndz���W��b L��jF# ����NF)�� �恼G!�4��:��Ϯ�_ƾۧ�����3�"JmUV����>����u�@��W���f�����j,G��V�~�4�(�r4k��E����zq���D[#���洹d�4Y�:]^��Ӌ��o�M�_���l�6��X��l~|��6�x�����>��'���wM��.��z���>���nf��M��|��~��}L���u��l��ϓy�.�~��O�쎡��P�~����/���͋�V�n�{���q/�9��� �Ϲ�l6lF �����u��[����4�6�9z����?O��u�Ez5 �"ZW ��=`* ���ȳ�7�ɑD�?.ϫ���t� �z����8.���_����I��[��چd���Ѽ�W�tr5��ŋ����`���1��m*,[�!T�M�#XLb��9��[@A�w��j w"����Z��g�/n���[_ݜ �E�F��`������2��y���z��)}ܣ��/�G �6��8�O�𦾹�5*�,����G���|��8���f����EY7�o9�����"��P�}7P�����:�2YN�������8_��_1���''���|up<�lcrrp8�;�M3&t�J��1�i�+4��.N�`z���l�r��N�Ӻx��k����][��y$'�Us��ǭF�u�`���|��"\���G�n�h��L���k+�r����zzzvPW���=��3;|rqr��&j���ܑ0��u.�I�*��Ig06ԋ�]L�DBb��0�X a���v���#eI�5��J�{U�0|=��V�U��E�D�h�)U-������2Qef�-U *�(�䆱ܕ�&��Z���t~����|w�^ �vT�{�r���t�t�){7/V7^���諨�żD����k5X"��5����1��;�nb�T��[t륝��/�\b���}���-��f'��;|�P.�_%Qw�滇�)��b99�n7�/���.�M9��^�.06w:.�������Ԇ{|��w�DGW�;�qv2;���\��vxY�W��Σ�1^�^�����P7�:wwU���ߟL�W�.�����/_���˜6 q��1[�\�/��-��Uچ?_����2/�bu8����� ���^�N�N�_ӎ�7���y��W�yy��tu��Ǚ����q��uBw�߶J���S��9Ʈ� Z��.��\��/�0� �W�eP.e���e��Wpe���v���lk��Ã��pq4�}g�ඩ/7<p�nx4HJ&VL�m�l��c�b�;,���g�X���r��cb॓�:(V��L!��11�� Ɨo��?p�3������z�>�[��/xDnR)@ �2Y��Z مXk���m'��]7ڔ1z�'��6f�fc�Ƙ�?�?�:�~��.Ls� ���m6Pq��R*戦p�nG�QQ5�W #U�T�v����{�6��*�q<��� ����`b� /x�Dž*�g�c��L���� aj=�G�=�{����� �����A9=T��c�&_���8�\�+<��@:�G�ha�11&��XLL�����z���X-���r=�a�@��1:���euT��e1���TZ+�"��#rG`8f04�#�����Eۥ���:)Btʂ�E j^ �����y�s�⠢��1� z��m��NW��������K՜��ɺ;(���_�(� R+ ���:*�r`M-��:m3Fd��q�b&d$d��ώzC�����mņ�� �yf��������N���w�)h�Ӌ�f��ɇ�;����Y�����K}�p��r:;��|Lq�%��Ud�!��b~4��c���=h?]�ܪO�i%*�B!c��@�>�F�="�e���]]1�����|rr��w���.LC���� [�\�/�of��� ��X>�F$�k%2�n!�Zh����;Fv�Ph3��Jh�p���sɯ��#ق���/��r�~�l� ���~�N)�nn�}|��`�Պ��z�M���Ϛ�g��؍���dq����N��WM��]<��u$�U�وv�����Zi����{u������u���l����������W/~�g��������C�{��:��R��Ow.b�I7����%�7ai�*�m��[��v���Si�m2��:͝��Nz�[Fmfm_{vי����T�7_X�"��9(��@��*cd��`⩹�9� �E�3�CB�c��È)�)�:5l��j�S$�xoL��˔�ޙ'��<��;ͦ���3,$֨� �8ָ��{w��|�S������v��ty<}1�9r�%���TG�ټ��O�X����;F8��z������d��50盞��A�s�R?K����/~�z�������U�6n�`����u���]��c�V�/�w3�6��gg�X�<9��x�XNfG��y��)ƪC�7a���\���z�^5Y���prr�%�ύ�j����� �z�<��yr�<�b;9�C^��]�m�^���ʽ�ü�p�iXU�-��������|���q.VDZ��x��z���Ջ��rv|��&y}�� `\/4^����4��G?�w���T~�Xn,q�&�^7�p'���I�bD���N����p�(Qݾ(�~�;(�+�.�~�}a'�]��Uq�m�b����0���n.hF�l���U�!2�A[�!��y�F�}rA�����C��I��K�A2tP�n�;S@yV\�,���m�g�=�I�L� 4�"R�FԱ�l�Z1�����$Q���UZ��J�drN-���1�_&Q����H�Џ�o�.��tً|�@�����*����uT�A�S(ֺD�E#�A� qg*/�:S ������y/`�6�~��OEG�JU��9J�Bp������PQU8֪0K� �E��ٺ lh�pP��� �r�jAz�h[T�B88>"���vG�|���V����§W��J�^�T�0{��Ya�dԎ�p�%a��c� ��AJe�H�����_Xh�oOBt)2m�G�@k�E�*{GX8ƲP���X�B#�,��p'0�������ٳs3��\� ��o5iJ� 2�cYhA�x�B��x�BAp8$8��Ӄ�I�@��!*D�:��a_��b�F(��Ό�6ddq� Ʒ�^�o�)�~��y�"w�6MG��-H�yBF`{Q6&L��V�&�F�֢��("���#DI� %�%���Bɧa v�(9`S0٣)�cY��o����z�����!�ʸJ�������%˛�a���~�.Y�y����/�}�����8��0) ����s���8�� ӢM�Ґ��k�]��/���v�� �U�뚜����OZ��3�+#����?mT�0iA[���L!�1ffg��mij���M�([�}�Ç{����� ��~��[�_{cl�>��(���� J��q����~������q>}��.�K��o��}�|�QH�"+�<j@�5Xm�:��f-R`R<2��:� ���<�t��d�cE ���KU�� ��D�}�eO@E̓A,�M�� &U�#b�B�$�# ��8 e6+QS!�o����F-9,�:k�¬/�C>8}o�� ot�(j��,�%� U&+Sd����g��(�P�:{��� ,1f'J1�3ݜ>�hl�|�t�t%K�m��!Xp��e��6�� T> |r> �4,��N��Nf��&��RӬ�H�9d9�N{�7n5��e?���ᴇ�뎽�g��M�j���SNژ\��ұ��0F�^����Ħ��u��BMe`M�0�T!�co�+���&��V��v�m��ɱ�{�ͱ��;}�^ޑ_t�>��VR��]z�+V�٥�ͬ�k/�:S�*�y��-rV��2$��\�y�LQd?F��ұz��V� *N�Y�g �$��`�b+��a3�V+�#S�H|��|s�-QC����b�2�"�"��X-���DZ-�����H��Y� �"��V�H�Hzx�C�d�"�F眥�c�I|��G�o ʹ4�XZ$�]$��=�EBs�1w���ۗ/��m�/�ޜ��}9��r�Ӿ�X�����ؗk�!1�'�ގ� ��E.��\�w-U�����8_ 9�Di��b=QD�(v �/^���G牻�'���LDq,D�A��3�V�@�d�|�L1fSg�d�S�TC{N�z��-F��M�iK�b���)��)�Ј��D10"�c!��y�'��y$O4y�<�i��H(.V�!X�12Bf�� �L�N���{�=t�O$�8z��C���D)�'��'�{{� �˜�S������v��ty<}1�yp�%���t~G�ټ��O�X�K��gϕ�)�����K���U�&����8�$r~G��3=P�?�%M����}=��r�r�]W�*FnG7]�z��j��x箂]�ߎ1V��˻yQ{���Zg��ڈ u���,'�����K�c�!@���\�^��ɮYh���WMx5=��v���t��Kp��M�� �zҨ��<9nt&�A���Wn�B�u[��#��r���0o֍`Nä�l�%D��� ���)��b�w��G��Ǎ@�z �7���qeoW��|�0������v�����;���o*'\,72w�ʋ �g;���/B� � ̀��8�7�Ǩ��5��-������ܱ(�TN���|��w�4E�\�F��5:yIg06�����NHު��Ѣ�t�n���۷WBg��}yt��'�}_���H�-)t��$TQ�ɳ����Zq|ܳ�ay_ aW��C�!Io����e��(���P'��7%(#��Q�c�j��2�~,�YF� ��e� �$n���y��'��}���__��トݧ8�O��>�nV��c;O�!/�9Ʈ��Z��c����)}4�7� (�����=�&?�!�+φ�u���Q��\���i/�-�̢n�~9��ܴ��Q�F�JX��"O0;B�5TÎ����`�`v`0[c��z�֡�j�r2qQ@� �X��ꨘ2Rٔ83��v�P+퐡��W�������pF�{�����ã�P��"�o�e���Ϳ��m��Lڈ�kNDkL[Y��QJ��>Ue�*��A����y� �'U)��t6�͛5A���oqϞ����5jL\a �� ;-=m�|�Q��Op,�y�:�Q��Gu��O��}�Δ|.�y�Qԡq�۠@f���1�D�9F�t���W���&���@�������m�6a���;�W��u�u�����)�U����"�S�eǭ��dҴ���r�����$L�e��Ύ��� ��=�>]�~Ay� S`����3h���\;Yn�(0lb�"{�%�|�)��l��u�DcP��d��C�Bd��ͤ����ʍ�a���m����5y���/��|��R�!�ӿ�S]����y3�}�=��u�Q�z��ΖE���\����J�B-�|��k;�yE����_D����굻�L{�;g�-ί���^�^e�L�K��]��LS6Ax�A��2��6~�O;Χ/�Y���ºw�6����|ztМ�^\��>�¾�$�C�N���)�/���ylv8�\�v�Zk����4��&E����q>PiWaGi���|s��9,�b�#W����d�fX[��$��JF`�Ү�V<I����I�����O��tw��H�q쑸�Ўܢ��p�Yܵͬ���}��qP�x� &5�̥��q�LQ�12�D��PL6����6!�PE�91�2�Vͺ�f��V|G��q�4Np�' �k���~B尲��Q��`G�d ��U�-����s�V� K���p���,AiOH2�E��-�s�=����|�|�cs}3Lڅ0�ib,����ؙh�`���1�qg�x���j�Ԫ6�[I����%>9X>��9���=�!>I|r����.D(/k];�K�r\���T�Fi��.�W�A�#��0��yL�H6�SQe���1���r�Z5�C�L�1���kb��Cy���Պ'FI��i1ʋ�8�W��<���'�Nd���-�HM�yD2��sS�����L���L�7�� Sl2ž�:a���bA���/=Hf�-s�,m��`���y�N� x��e���8,�-w�3��{LP��A���ݨ�2t:���,:E�x���5���$�"�7l�V��Ea�:�F�����PJ%�dL]̜DaG�~<���� sMB�!!�j�Z[�/l�I`�e$h��!��C�i�-ل�[%ل�[�Oe�# �'��B8��#:���Y�U��z�95��E5M�w>j��ZMP8B(�ɺƷ�^�o�)�~��y�(�$#��Ac�u���N�?6:^>�?:���#d�X���RK銗�,�(iRP�\Dd� Zg��7c��(9�.�ȡ��q��C�~��}���bM(I!d���a`���Z�e1[���4d]9b`D� w�K�~��}�!〽,e�^���\ɓ�sePJ�9���W�`S�����?�s%�!F ���x: ����W�g+��&�l��^>�se��q��\)E�#p��'��R���"$fd�JR �� ���pm �dYy�eeg�����4 �J�����1@�5���K�]q�-GgY��^�rԫw�� ��:镴#��`���f�,�az ���t���8� �(�{^7�-9��c)���z��j_���Zu� [_�Պ'}5�W#�ɻƱGrjRH����+R��u�U<H���(]'uEb�,$�D���@��@*<3&�b`��{ة{l��Þ1Eb���0�x�W˃���JQHvw4<�ͬ%�]���_cWG�{���q�4vIc�4vIcw�1��Hc�4vo,Er|*��G��As���vw�mq �V��N��P���:A.E�R���8u�(���H�9�}�B�� ϕ����s�#u�l߹3���H]wd];�����Y+��}���![)!+�`^��SrX���ω�V�(�`I]w��ޏ�P� G ��9;8\M{P8jj��08V� ���9�su��k�����#�%<)�HxHx�36����mB��ą����� �uřL)K%�"<!�@x8��Q�iwtdxH*����,V8�� (�/P���p'|��I�8�G��(n��Q�5#��Bqh�)�M�qN�퉕�^H��� d*�����L}-�e<!#4�*nj� wAæ��|� ��"���}��ʬ�[�-G����Ek�X��i.�Bs�-%��Ȣ+R�Rt�Dz3b40y>�Ԝ �̡�ْ<_�\�-�n]iu�آ+�V<���� ���5�}�]Q��:s����� ɮ�Zd�L�+{.�ґ�� ɮ�� ɮl::�Iv�dWn*E�ODv�9�=�Ϧ+]�Mte��[r�x� k<x�f��sp\���\�b�$W����&��S�Nu���;/ zk�zb�Ӊ�{91��N����@2j*�i�\���x���9ɽ��*�C���L[���K����B����_ؿ �! $ � /v�zh�kg�������.���QCB&�C��'���!�s" $ �O�f'=tе��_@�l`�x\� �Z���.C 2X�L�( ���P?����B�m���;n�1D ���{m�nhMs��4W<J�*�<��x�K啐)��S9�16�ǝT1�լ@M+\���Śr���47ئ�V�3�T�f�S�5�Q��Si�s���;sj�����Msb�]shȬ|�:�Cꚣ�9ꚣ�� �c�P�u��T�4[(O�k�h���pz09<���:�v�kw��"�&D�Fh.ip�0<�K��^uϡe��KY�] SlcQ�X�<�lP�5㚺�F�?Ȣn��s�z:*BGE��{�xx��QX[*��0� ��KLp��dK����O�B�7N��Rl�~-��\}�ۗ�_��eN=>�'d�gd=_M�ݱ�M��BW͌�@��ld%A�.C��svd>Ft���u�芅�Y�F�ɼ�A���/LqW�� y��R���`���¿����o�ե���ݐ|즧��Iwlf�pP� ���0{6[ XT��Xy���')"Ձc���t=;��l(�<�vt0�A��}��Eƍ����������I�u���!P��(�;��P�Ε+�1:'`��8L�� I��>�ZD����ҙ�\�~��4SE�a���2!*%E���o�8�M�CdϺ��/��%Pq���?�`� ��i� Cd`��u�)e̓6���b� K|��[�|{M��{����&ϋ�M�q��&�������L�Ju��^gV�%(k�Qg��|�5�Z/R̢��Le���L��[+:|�Ç{T���� ��\�\��*����z}J�u@"�d�j��I@�g�ɒ�hɾ�m�<�v�O_���f{�݊ڏ��}� |�5m:UQ �������m���AE�\�G�Mԡbe� ���E�:k�˺�x��ڤ�(S�����l�'�ͩT>� !�AP@k>T6i�0+��ǀM���' VK���|L�%��f]��l�s�M���4J9�P��� m�l^���,x�R�lAe�KAR9Ty=F�P���<�X< �Z���D�b�ĘH9��'>ml�rh���a+��Z�Jʡ�z�8�I94��C�+S���;SlS�)j3F��Lq6X3��db��bF[0'���{ث{t��}�"1�L��˔�ޙ'�v�fGQ̙QQl5m�)�:d0H7�����ԩ��`π9�ĜJp�&�`�b���)�p���"1��3��|ED�(FKDq,D�ͬ%/�A{�ԊH�BVD{nE��y3Y�Y�ц��Ɋ���n,ED|"VD"N5ٝU�3%3�͈�^ƾ�"�U)�J�h$X�zm���'n�^�)��aG$�ad��D� ����P�(�~';�J��H�([�I*�2d ��Oj+�f��v��)]+���c*cdh@�������dp.jΕ�@�c#�$���"<xp>�����pFp{��4v<ʜB�D��$�����6Q����Y� @��<K��(,'�G�c��{���d��pq=���+���=�U���_ YPc �TƀgFA��Th'�1d���S9@@n��<��O�cc�0��:re9w |��*�`��>Xk�%X!,zA��7�����`�dQ/� ��l��d1�aO�e���Gμ2\%�d��X�(� ��`��q�����c���;�����Y?;��C�D���U��YoDj���h�g��H9��λn���W�囃7/~ʯ��~B&O9�}���t����=�Y���'��֡��6� ��>��2PUFqϖ�?l7"-�������FE9�;͵\�A��i;J���g4������Nd�S�D�z'�m�x��Z���a���Z�$�F�jd�p�8�HV�����e�:W�n�����xy,�f�F������de�i�LQ�k<�5w���߭ <�PXF�21��2�V���f��V<1Eb���߾|�o���^mE�c�nu�4\��nđ�/DGCw�Ť�K�����*�H�w�y;n3�>/��>/��n �I���yo��v����^�����у���A���S&NJ 9��J2ڼO����Hty��LI�@2S �i�� e}J!G�\�.���)=�Se�N0,ѱ�K&��M'��0����!0�+�k��x=D#��N!I�h��g=�����?���������")�H)��y����6a���L�@�"C��Ri$��b�ji5�ȏ�L��p�XhB$,$,�_�=(8� �gX�jAX4%�,>�7, ��HR� GXJ��\�<,$�A�a�ca�({�"��x�$��ҁG+�YF�Ȋ��#,5��c.��C�$��L��Ǘ.��qVSc/�E�c�0�5k��m�Sj���'�]"`!0zC�8��gF���hz2]�$��>��q��~�GU����VL�/X�Ơᗂ0"i ����j0�I����Y*��cTf)�c��܅A �1B�*����Z�2Kﴻ-�nRfiu���,�V<)��2i��5�=����K�t�#���AzE��ʓ�^�5M$�=�^�HI{��WH{��W6��礽B�+7�"��S�^YTB�>�줿���J��ط�c"hV�"�� K�ZCr)5��~�4X��qh��<���:�u�)����\Em�' ��$Q�N�l�d,����N���&��6��Q��l!X� JpVe(�F���3��!�1M�7N�h ���E�Շ�A�.�~���)hm8� j6g��M�Igj�cǹq��#��&$�קg��`�8���M��b��������ˠ ��]����ըi't�(�q<(H�+���0T � | l��� ��ީ��`p�Š�-������Z�w�˓g������g��̖����D�5ݍ�*�,RFM�8������;��Qo��>�~#��ֱT`�^f���fh��(�r��FY1 E�8f`td�@{���bM �ߦ��]��BCt��b`0 ��ڈ��XKh8�2Q�4�ѰBCBÝ���ᜯz8Z�*�ѐ�8�U�Ӛ����Lq�G�<-eLI `ԮҜ��Jc!2'3KAyq�{�a��ٳ.���/�}�gY�D��( V��@W�>�y��T�n��$5�����<o���*��c�E��K��W�'-XQ�����l�����E�ՠ�Ӏ�p��9o���]m�vM.a2���Z��>ܣ�\�v��go8u7��V�ג�[�Of�"@oU���-�z�¬/��ϯo����|�bE]nl�[Q������7�Yg�M�j�f��ubh,*��e���)Q Ӣ�B���m�P*�C�%ǘ�(��L�������� <�gO<} �^:|K��'�XN�T ��x>xbxBD'@�\� k�߳S�-�i&d����괝p�kE�GD0>1�r��{3c�s����b� � �#���1zDH_+|UK�Z͛z�y��,HH��X����'��ޟ���M��dž��jœGyD�G�]��'����T�G��L��&� ��r#S�Δd�kBjLK"8VJ�m.�eQ�/��{x��L���F��)v`�/^����<������D�E��c��-'�6OM��#[�M��9�+�h��$��p&,������>:[���"��ѳ��g��/�dKlq,l��Ľ_�Y���h?+F�?��%��=����g���g�v���,���\�(�D�g]���n��w_���f=���B- �Z�od9K�r-�~y͚4�٨S�^'�4{�:�9�) ���fG(�� I�l!;0$�=��zf�nW�|����}�S�O"�È|l�Ƕ�xpѱ�U0 d})�a���A1��E�U�$:6B N6h�K <8��k�up8#���&yFnFcāh��Ύ��;6��_i�K�DQ1��o&���V�T�,�AK$�!DJ��k�i��R��-���鎃���Ɖ=�qnU\ܫ>�J���Ö;�AE(��FN��O`�s������f�Z(��1�,X�r�<@���Ķ^j�R�l����Yl�B��c��Yh��g�zH婴,��|�B�j`$Z(ԯ� r�� �3�W��~����_���_a�A� ԯpc-���W��vlZhq��\Ȣ$4�^Q�Yc��:@EQ��)�۴��ٹe���\�.z��d�ԉ��s��#��3�{I�+�wx$J�|�'��I:_I�+wڮ��Nf'�O[���Z+z���*�E�m��yld�x�`I�s%���w>BhD^�Q"A#A�Nи^�:��U���F'\��i�K�1�Ŝ��x-MBG�8Bh��Z�o��?0�;�>U�����t�����l<�|*qt0Yw�����Ԉ�Q&7�F�( C#�A�Md��0��u�dQID�ud#B�ޏ��e:<�Ȃ�x��v��o�F�4"�z�5�F�V+����H#/�LY;WԈ@�-�ه�w3�!�gBGvH}ԇ@}ԇ�io�P�!�X�d�D�>"�A�w�55#�،�2�ݑ��i�gT����Vjϥ2���H0F��K��ģ� �����c�+���u J"/��-)6�ْQ�L�+�R�3+�ά�����t�ƃ�L�NJ&�Xd �L)�y~�t�%IA�~�ך�#��8��O�J�:0p�:2p�ȶ��_`�M�^s �;v){�Y0�`RGŭ%c�����%1�.�$"�������/�mj�j�,��R�(�F���x�Y��CH1nc�~�}`��x��gXr6���{o@�&�~A%�%=��ke�|���E-M�.��r|P�%��t{`��/C� ��>)���ޟ@�~�|7;:�Cͦu��BD���g���(�� 2��p.|�E���(QJC�8�R�#E��a� �p����I�f�|Ճ~��n�ۙ�\�~Ay��)J[�����MҐϥ��`�M�CdϺ��/��%�q���?�( 3 �ʀ�5FsրB�LT�e�uu߀-�w���Vw��k��y� _pW�B4�ـ��&ꚜ���Λ9���S�c��?���4_�5��:��A� -l�J6�Z��d^q����:|�G�z�/�� �N�WL��k%���)��T]����<T�ћ|��7F�L����G�ӎ�鋅u~Vcl���M�����uu���u'q�wbX7�`9;Q9�T�G�E�J*29W_�(�V��i��r���c�����Y�l]|�l46�XM�D�z�k�}���4,[T�Պ'Q9�#Q��ƱO�B��\ΰE�vf�DE�P"��C�@��(�5\��0���cd�M�N{��7FT� ��� "��)�)�j6Sl��;2Ŏ�$�����Y(�[X��1gYjA-��.�V�i�t\$VJ� �KC7H�m�Q@JA2�c����HZW�EB{��p��Ë�)�������νf��!��-��lA�4��cO��#�a�I���(�^U�V�����C6�1��$&9�r�� ��f�=�!&ILr��䵓.�&/�;Flr�lr��|��es��EXd�ǚ�� X�|ʥ�#�&k�K�X�7W�|c�)�s(E��u�����^�C�Y��(�Q>!Fy�Gd�#���Q�$�mg1Yp�g���'���sΎg�ɂ�,8ɂ�,8�+�,8ɂ��� '���g^O���Z=���P)�#��Ф�d��2!J*�f�O֛u��qXoʨ�d���P���ZЍ8�v�a�zst"x�yM"x��,x����zs��w�ƃ+�b4%��AjUG���*�L2:�c1�ې��5�H�$��1��H��5ɠ�I_����ɝd�x��N��a��k*�d����Y�s�K��˄�*�qBcN�*Q�DV�~�>j�m��� eQF��Z���V��`�q3� � ��to X�N�:� (����M��F�J`�8@l�mUi���mK�A:�9Ye��&`�`b<���pq`��=U�O9OF�7�/�ٞU*gt6X�'d2f���D3��d�92t\O�x��ˎ��t�[��3��"�`0k5`�C�)x��s�!Q�8>��\Ez�9b@,� ql�8;��֓ӳ�����MC��jzt0Yw��m��:��E�F@���!k�[��;B�1��:�7��::ށ�55�jn���ڳ㯙��ـm��ѕ�(Jf�VJ6*����Fd���E�P�&d$d�/�>�����/d���:Y�:��8���J�d����#<��!�xkF#!#!��x~v�2��5Dd�Qj>�ì3�U+�Na�RB�&�_����!�[3�ɤ����l=�Q�)�Rz�f*��tv�&~Lq�[N�T}�6|��N{��n��Ca�J�mT����B*���B�Sy����2FST�#��%`�,G���m��� �b���ۂ�&S�V�j�6�h����L1����W/~��-�HW;�c�l0r�O��s5�P6mf�}ا�`�-Q�����nF�J2Y�n�2�) ��sӊa���8-8Xk(�}�� m1�2�V �Cg�-V<1Eb���߾|�o���V����`rxX��E���;�$��H$��Km4$�댾�i����Z� �A pJP�k����ALdr�[�Aj�D��.��,z��7Vf�`�`��6�l��;̎�Df�$��$_�|(`��5�ce�)y�8-��.�V��H� �*l&ַR�O��ץ?��2s������Ӝl���w�`�'�=���xZ�l���l��{�E6�d�}S풘~:6�7r�K�eԃ�c�ȭO�Kh��`��/y�(<�^�>�c�Gb����(�1G 0K��q���F$s��i2(%��t���Ⱦ�[��#�N]�]��^��]+���Նe��\T���A��DY��0>�3�� ��~�)B?B�m�oՋS���! G�LT �t0��e\[�c-Iyh�h�%'�` �E�u?^�O}�Z�!9���8p�z0Rq��F#!�k@N;�; �@���vJs��{���p�/g��/V�k{���0��}Ig�6�Z�~U�R3220&���d`�o_��/��y�S~�������,H�vd ��6*�$ݾ���� �m-�c�s�5�+����cCɚY�'�k�X���>F$`�/`�r�0�ѱ���R`�W�F ���Y�x�T㐁Q�ٚQ#�U�p�U����U�lZ��/4,!� ������D���d�!4a��L3EhHh��2�m� ��"��K���H^F�Wg�s=��n���c�(^��X������[,�[T� ����6�Z��<�J����&�UJ@D���`�ȠM�>�y����i�10��R��k�]Sӆ/�����؋�Z�~uMN��W�'-XQ����]�����Cl �:�*���J�]N6c�,�6�j�4&� ��]~�����=���kw}}��Sw�ʤl��kYխ�'�Y �B�m͑�%%Z�5wX�Y3^zY�_���#�i��Ŋ���n���������o��ِ%2,�;x��)�E4"%!�����щТ�B�la4)�9��������(J]��g�^�{N����GY� *H*@]���!����1�κ*]2y@�i*q�X�������@p�)�X c� Y"�0ۆ:m#�P�"��'ͣw�$ ��T��O`K�`���U���'�pj�&.6��-7��P� !X� ������E��h�F6l�V+��)ȟ�����>N #+��ʔ=��n�y<L����ϐ�m6��TCj0%yc�%1�2�r=6S��q�}���R��C Y7g�5�J�Т�P�6Y�"�"�aC�),*�����8��U��Rj,�ԃ=M�^G1!�wY+�6f�!����0 ����1�Q�y��34Mc��u^��N`�w���"�Z�D�"�#���p����l�/N�UUl=w�3�:6H�h�9cQVdVX��dA{&:L�g�9qF�V�?��ÉS��G��D?v��Ltq,tqݑ)���eV�)���W��W�~z�<����L����|+��/����|���_ʒ<{.v q69���wy���O^�qq>_�ؗe�8��ǒ��g�߾��Ym��)Fn�7]�z��r��x箂]�ߎ1V��˻�Q�~����.!����|���/��̎�/��.I�S�U� n�r�{Y,O'�&�F�iդ�W����a�(?O����2H�&j҄x=i�G~�7�;�ݯ���Wn�B�u[��#��r���0o�M�Zä�l�%D��� ���)��b�w��G���M@�� �7���qeoW��|�0������v����;w;~�M儋��J�nRy���l'���EH�D0!���&v�Q��v)F�"ۏrǢdSZ��U�W�Y�x]P�����sp �H�zӻ�tcJ�]L�譪�n�-ꡖW�h��{Ճ|��+\�JF�; ���Ns%�t�ݼ��J# >y����v\ˏ�[�;,��!��������V��r��y��.i�Y��&G�����2��{���$7ٿ�d��9�M� 80[�z� [�6�ٺ~�e׃:�Y��b �\�\хy�R>�R����0F�脕ő���O����7��E��-Ej�R[^��'=�-� �_`E�D���a]Ge*�T��+Fu#â2��x�0'G���;���0ѐ�*���t>�8��jJ�E���CÔ4���P���&f�l��9 c" �|�L�Rt�鐬@B�ֆ���1a�� �c\~y���u��G_�(hE�$�-�""c�(��顴�#.�O�H�80`��\���"0�k�=��F����Ö#�vN9��zH.$@^ X�<d��6.�l� 5X�ƨ��tI�k ���U8� x��Ɣ�p�4Xz��m���S����vn��I��4X�)�q����י���)�4X���G*�b#�=a��I��DXH��DX6쎕B",$�rS1� >1�_騿�p�+��*�W�Ir��J���F3)c�#镄9�qH�x�Y�2A%�c�"B�&��5�Ize��G���#�<S�7H��pt��S��O>���̩��t^�ގ�����ˆ�s��÷�U���Y(�@�,rAG���Q Ig3Gذ�Ր���x��g���:8���q3�O�������D�/`�:�%Sh��%\��uI&Ƶ�N�1V�*0�W�� 4ǝ�q"hÄ��(:G�E8@�4�(k��r��2A'Rc��$mʎs����a� vNW�9���ڄ�/� �:�ͦ������$����&a���pp�8(���p��k_�'�g������L)��G�J��,@�ATP,�hC�8Bd,��q��XD"d$d|�/����}�e_�z uB0���Lˣ�Iu�#� �e��O2A�A7�{�g5H!���`PL��76��0��<��R1�b�I�w&��7 ��j7�L�OB0$CB0w�c��`D���t�F"�3SD�H���X�v�/,��A*⹘��9�A2�Z��)�T�e�C�sL`�� }��C��2S,Sl�;3l��j�wd�IF�X���0X 6hIJ��3�DO�d����AAZ$TNQ9u{9���|�;WS�c5�\�LW����Q����C]�,�Uc������QaYQ+����p%*� 2j4%xk�f���+,�r*A[p�RԱ�s�-$b�D�<�yl��<y�7��e�w��8���3��;��;���$�>h��Q��'LE�H����w;�A"�$�N"�$Ҿ��#�H;��ߴ���""�����{9�`��Id��g@�4X%2h���Af��~��6qvfk�.R ���N�P�]٪U�5���G��i2uyn��9qv_ƣK�C� �zz+��<��j� �C�X�~ ��)�lEv��3B�+���W� [5�$E�)®.���QM�"�~�"���3s��� 2f��1&�@�8ª0��1�b$ퟑ�b#���(�>