Edit file File name : handesk.sql Content : SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `script_nikita` -- -- -------------------------------------------------------- -- -- Table structure for table `attachments` -- CREATE TABLE `attachments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `attachable_id` int(10) unsigned NOT NULL, `attachable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ticket_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned DEFAULT NULL, `new_status` tinyint(4) NOT NULL, `private` tinyint(1) NOT NULL DEFAULT '0', `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ideas` -- CREATE TABLE `ideas` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `requester_id` int(10) unsigned NOT NULL, `status` tinyint(3) unsigned NOT NULL DEFAULT '1', `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `repository` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `issue_id` int(10) unsigned DEFAULT NULL, `due_date` date DEFAULT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `development_effort` tinyint(3) unsigned NOT NULL DEFAULT '0', `sales_impact` tinyint(3) unsigned NOT NULL DEFAULT '0', `current_impact` tinyint(3) unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `kpis` -- CREATE TABLE `kpis` ( `date` date NOT NULL, `type` tinyint(4) NOT NULL, `kpi` tinyint(4) NOT NULL, `relation_id` int(10) unsigned NOT NULL, `total` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`date`,`type`,`relation_id`,`kpi`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `leads` -- CREATE TABLE `leads` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', `team_id` int(10) unsigned DEFAULT NULL, `user_id` int(10) unsigned DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci, `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `lead_status_updates` -- CREATE TABLE `lead_status_updates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `new_status` int(11) NOT NULL DEFAULT '1', `body` text COLLATE utf8mb4_unicode_ci, `lead_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `memberships` -- CREATE TABLE `memberships` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `team_id` int(10) unsigned NOT NULL, `admin` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `merged_tickets` -- CREATE TABLE `merged_tickets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ticket_id` int(10) unsigned NOT NULL, `merged_ticket_id` int(10) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=29 ; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2017_08_03_123339_create_tickets_table', 1), (4, '2017_08_03_125106_create_tags_table', 1), (5, '2017_08_03_131508_create_comments_table', 1), (6, '2017_08_03_133638_create_teams_table', 1), (7, '2017_08_03_133910_create_memberships_table', 1), (8, '2017_08_04_125151_create_requester_table', 1), (9, '2017_08_09_125623_create_kpis_table', 1), (10, '2017_08_11_084301_create_leads_table', 1), (11, '2017_08_11_101207_create_lead_status_updates_table', 1), (12, '2017_08_16_105904_create_settings_table', 1), (13, '2017_08_17_143319_create_merged_tickets_table', 1), (14, '2017_08_17_162755_create_tasks_table', 1), (15, '2017_08_18_111900_create_user_settings_table', 1), (16, '2017_08_21_102217_create_attachments_table', 1), (17, '2017_09_20_135310_create_ticket_events_table', 1), (18, '2017_11_02_165749_create_ideas_table', 1), (19, '2018_03_22_160928_create_failed_jobs_table', 1), (20, '2018_11_11_112155_add_rating_to_tickets', 1), (21, '2019_03_05_142214_add_default_team_id_to_settings', 1), (22, '2019_03_19_162925_create_ticket_types_table', 1), (23, '2019_03_19_163352_add_type_id_to_tickets', 1), (24, '2019_04_25_151115_add_can_see_reports_key_to_users', 1), (25, '2019_07_03_150045_add_agents_token_field', 1), (26, '2019_08_22_070236_add_ticket_summary_fields', 1), (27, '2019_11_21_094049_added_escalated_tickets_notification_setting', 1), (28, '2020_01_13_082507_add_no_reply_field_to_requester', 1); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `requesters` -- CREATE TABLE `requesters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `no_reply` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `requesters_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `slack_webhook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `default_team_id` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `settings` -- INSERT INTO `settings` VALUES (1, NULL, NULL, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `taggables` -- CREATE TABLE `taggables` ( `tag_id` int(10) unsigned NOT NULL, `taggable_id` int(10) unsigned NOT NULL, `taggable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tasks` -- CREATE TABLE `tasks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `lead_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `datetime` datetime DEFAULT NULL, `completed` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `teams` -- CREATE TABLE `teams` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slack_webhook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tickets` -- CREATE TABLE `tickets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `public_token` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, `requester_id` int(10) unsigned NOT NULL, `team_id` int(10) unsigned DEFAULT NULL, `user_id` int(10) unsigned DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '1', `priority` tinyint(4) NOT NULL DEFAULT '2', `level` tinyint(4) NOT NULL DEFAULT '0', `rating` tinyint(4) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `ticket_type_id` int(10) unsigned DEFAULT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `summary` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `tickets_public_token_unique` (`public_token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ticket_events` -- CREATE TABLE `ticket_events` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ticket_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned DEFAULT NULL, `body` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ticket_types` -- CREATE TABLE `ticket_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `locale` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en', `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `admin` tinyint(1) NOT NULL DEFAULT '0', `assistant` tinyint(1) NOT NULL DEFAULT '0', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `can_see_reports` tinyint(1) NOT NULL DEFAULT '0', `token` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_token_unique` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, '[[admin_fname]] [[admin_lname]]', '[[admin_email]]', 'en', '[[admin_pass]]', 1, 0, '[[token]]', '[[regtime]]', '[[regtime]]', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_settings` -- CREATE TABLE `user_settings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `daily_tasks_notification` tinyint(1) NOT NULL DEFAULT '1', `tickets_signature` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `new_ticket_notification` tinyint(1) NOT NULL DEFAULT '1', `ticket_assigned_notification` tinyint(1) NOT NULL DEFAULT '1', `ticket_updated_notification` tinyint(1) NOT NULL DEFAULT '1', `new_lead_notification` tinyint(1) NOT NULL DEFAULT '1', `lead_assigned_notification` tinyint(1) NOT NULL DEFAULT '1', `new_idea_notification` tinyint(1) NOT NULL DEFAULT '1', `mention_notification` tinyint(1) NOT NULL DEFAULT '1', `ticket_rated_notification` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `escalated_ticket_notification` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;Save