-- MySQL dump 10.13 Distrib 5.7.37, for Linux (x86_64) -- -- Host: 127.0.0.1 Database: development -- ------------------------------------------------------ -- Server version 5.6.51 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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 */; -- -- Table structure for table `apikey` -- DROP TABLE IF EXISTS `apikey`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `apikey` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `can_create_users` tinyint(1) unsigned DEFAULT NULL, `can_create_tickets` tinyint(1) unsigned DEFAULT NULL, `can_check_tickets` tinyint(1) unsigned DEFAULT NULL, `should_return_ticket_number` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `article` -- DROP TABLE IF EXISTS `article`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `article` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_edited` double DEFAULT NULL, `position` tinyint(1) unsigned DEFAULT NULL, `topic_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_article_topic` (`topic_id`), CONSTRAINT `c_fk_article_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `topic` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ban` -- DROP TABLE IF EXISTS `ban`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ban` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customfield` -- DROP TABLE IF EXISTS `customfield`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfield` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customfieldoption` -- DROP TABLE IF EXISTS `customfieldoption`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfieldoption` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `customfield_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_customfieldoption_customfield` (`customfield_id`), CONSTRAINT `c_fk_customfieldoption_customfield_id` FOREIGN KEY (`customfield_id`) REFERENCES `customfield` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customfieldvalue` -- DROP TABLE IF EXISTS `customfieldvalue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfieldvalue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int(11) unsigned DEFAULT NULL, `customfield_id` int(11) unsigned DEFAULT NULL, `customfieldoption_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_customfieldvalue_user` (`user_id`), KEY `index_foreignkey_customfieldvalue_customfield` (`customfield_id`), KEY `index_foreignkey_customfieldvalue_customfieldoption` (`customfieldoption_id`), CONSTRAINT `c_fk_customfieldvalue_customfield_id` FOREIGN KEY (`customfield_id`) REFERENCES `customfield` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_customfieldvalue_customfieldoption_id` FOREIGN KEY (`customfieldoption_id`) REFERENCES `customfieldoption` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_customfieldvalue_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customresponse` -- DROP TABLE IF EXISTS `customresponse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customresponse` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `department` -- DROP TABLE IF EXISTS `department`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `owners` int(11) unsigned DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `private` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `department_staff` -- DROP TABLE IF EXISTS `department_staff`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_staff` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `department_id` int(11) unsigned DEFAULT NULL, `staff_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UQ_f2a19cacc73eb380315c104650ebc8c42d1b75a0` (`department_id`,`staff_id`), KEY `index_foreignkey_department_staff_department` (`department_id`), KEY `index_foreignkey_department_staff_staff` (`staff_id`), CONSTRAINT `c_fk_department_staff_department_id` FOREIGN KEY (`department_id`) REFERENCES `department` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `c_fk_department_staff_staff_id` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `language` -- DROP TABLE IF EXISTS `language`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `language` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `allowed` int(11) unsigned DEFAULT NULL, `supported` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `to` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` double DEFAULT NULL, `author_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `author_staff_id` int(11) unsigned DEFAULT NULL, `author_user_id` int(11) unsigned DEFAULT NULL, `author_staff` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_log_author_staff` (`author_staff_id`), KEY `index_foreignkey_log_author_user` (`author_user_id`), CONSTRAINT `c_fk_log_author_staff_id` FOREIGN KEY (`author_staff_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_log_author_user_id` FOREIGN KEY (`author_user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mailtemplate` -- DROP TABLE IF EXISTS `mailtemplate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mailtemplate` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `recoverpassword` -- DROP TABLE IF EXISTS `recoverpassword`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `recoverpassword` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sessioncookie` -- DROP TABLE IF EXISTS `sessioncookie`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessioncookie` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `creation_date` double DEFAULT NULL, `expiration_date` double DEFAULT NULL, `user_id` int(11) unsigned DEFAULT NULL, `is_staff` tinyint(1) unsigned DEFAULT NULL, `staff` tinyint(1) unsigned DEFAULT NULL, `user` tinyint(1) unsigned DEFAULT NULL, `staff_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_sessioncookie_user` (`user_id`), KEY `index_foreignkey_sessioncookie_staff` (`staff_id`), CONSTRAINT `c_fk_sessioncookie_staff_id` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_sessioncookie_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `setting` -- DROP TABLE IF EXISTS `setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `setting` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `staff` -- DROP TABLE IF EXISTS `staff`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `level` int(11) unsigned DEFAULT NULL, `send_email_on_new_ticket` int(11) unsigned DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profile_pic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `verification_token` tinyint(1) unsigned DEFAULT NULL, `disabled` tinyint(1) unsigned DEFAULT NULL, `last_login` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `staff_ticket` -- DROP TABLE IF EXISTS `staff_ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_ticket` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ticket_id` int(11) unsigned DEFAULT NULL, `staff_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UQ_8a53d6ad25611e7060ab030785c3c0cef48bc533` (`staff_id`,`ticket_id`), KEY `index_foreignkey_staff_ticket_ticket` (`ticket_id`), KEY `index_foreignkey_staff_ticket_staff` (`staff_id`), CONSTRAINT `c_fk_staff_ticket_staff_id` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `c_fk_staff_ticket_ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `supervisedrelation` -- DROP TABLE IF EXISTS `supervisedrelation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supervisedrelation` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `supervisedrelation_user` -- DROP TABLE IF EXISTS `supervisedrelation_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `supervisedrelation_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned DEFAULT NULL, `supervisedrelation_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UQ_0c5228cfadd3dca1357880bf711030ed41da30f9` (`supervisedrelation_id`,`user_id`), KEY `index_foreignkey_supervisedrelation_user_user` (`user_id`), KEY `index_foreignkey_supervisedrelation_user_supervisedrelation` (`supervisedrelation_id`), CONSTRAINT `c_fk_supervisedrelation_user_supervisedrelation_id` FOREIGN KEY (`supervisedrelation_id`) REFERENCES `supervisedrelation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `c_fk_supervisedrelation_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tag` -- DROP TABLE IF EXISTS `tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tag` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tag_ticket` -- DROP TABLE IF EXISTS `tag_ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tag_ticket` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `tag_id` int(11) unsigned DEFAULT NULL, `ticket_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UQ_79dc4901a5620abff6d65219e6aef86fe9ab63bc` (`tag_id`,`ticket_id`), KEY `index_foreignkey_tag_ticket_tag` (`tag_id`), KEY `index_foreignkey_tag_ticket_ticket` (`ticket_id`), CONSTRAINT `c_fk_tag_ticket_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `c_fk_tag_ticket_ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ticket` -- DROP TABLE IF EXISTS `ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ticket` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ticket_number` int(11) unsigned DEFAULT NULL, `unread` tinyint(1) unsigned DEFAULT NULL, `unread_staff` tinyint(1) unsigned DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text COLLATE utf8mb4_unicode_ci, `language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` double DEFAULT NULL, `closed` tinyint(1) unsigned DEFAULT NULL, `author_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `author_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `department_id` int(11) unsigned DEFAULT NULL, `author` tinyint(1) unsigned DEFAULT NULL, `author_id` int(11) unsigned DEFAULT NULL, `author_staff` tinyint(1) unsigned DEFAULT NULL, `author_staff_id` int(11) unsigned DEFAULT NULL, `owner_id` int(11) unsigned DEFAULT NULL, `owner` tinyint(1) unsigned DEFAULT NULL, `edited_content` tinyint(1) unsigned DEFAULT NULL, `edited_title` tinyint(1) unsigned DEFAULT NULL, `total_departments` int(11) unsigned DEFAULT NULL, `total_owners` int(11) unsigned DEFAULT NULL, `first_closed_at` double DEFAULT NULL, `last_closed_at` double DEFAULT NULL, `reopened` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_ticket_department` (`department_id`), KEY `index_foreignkey_ticket_author` (`author_id`), KEY `index_foreignkey_ticket_author_staff` (`author_staff_id`), KEY `index_foreignkey_ticket_owner` (`owner_id`), CONSTRAINT `c_fk_ticket_author_id` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_ticket_author_staff_id` FOREIGN KEY (`author_staff_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_ticket_department_id` FOREIGN KEY (`department_id`) REFERENCES `department` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_ticket_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ticket_user` -- DROP TABLE IF EXISTS `ticket_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ticket_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ticket_id` int(11) unsigned DEFAULT NULL, `user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UQ_f73b0a7296c1f9101e14c7c4bd6476b9f9a6a2b7` (`ticket_id`,`user_id`), KEY `index_foreignkey_ticket_user_ticket` (`ticket_id`), KEY `index_foreignkey_ticket_user_user` (`user_id`), CONSTRAINT `c_fk_ticket_user_ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `c_fk_ticket_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ticketevent` -- DROP TABLE IF EXISTS `ticketevent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ticketevent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` double DEFAULT NULL, `ticket_id` int(11) unsigned DEFAULT NULL, `author_staff_id` int(11) unsigned DEFAULT NULL, `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `private` int(11) unsigned DEFAULT NULL, `author_user_id` int(11) unsigned DEFAULT NULL, `edited_content` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_ticketevent_ticket` (`ticket_id`), KEY `index_foreignkey_ticketevent_author_staff` (`author_staff_id`), KEY `index_foreignkey_ticketevent_author_user` (`author_user_id`), CONSTRAINT `c_fk_ticketevent_author_staff_id` FOREIGN KEY (`author_staff_id`) REFERENCES `staff` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_ticketevent_author_user_id` FOREIGN KEY (`author_user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `c_fk_ticketevent_ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `topic` -- DROP TABLE IF EXISTS `topic`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `topic` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icon_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `private` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signup_date` double DEFAULT NULL, `tickets` int(11) unsigned DEFAULT NULL, `verification_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `disabled` int(11) unsigned DEFAULT NULL, `not_registered` tinyint(1) unsigned DEFAULT NULL, `supervisedrelation_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_foreignkey_user_supervisedrelation` (`supervisedrelation_id`), CONSTRAINT `c_fk_user_supervisedrelation_id` FOREIGN KEY (`supervisedrelation_id`) REFERENCES `supervisedrelation` (`id`) ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-03-23 12:28:30