-- MySQL dump 10.13 Distrib 8.0.23, for Linux (x86_64) -- -- Host: localhost Database: edms1 -- ------------------------------------------------------ -- Server version 8.0.23-0ubuntu0.20.04.1 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 `absents` -- DROP TABLE IF EXISTS `absents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `absents` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL DEFAULT '0', `start_date` date DEFAULT NULL, `end_date` date 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `absents` -- LOCK TABLES `absents` WRITE; /*!40000 ALTER TABLE `absents` DISABLE KEYS */; /*!40000 ALTER TABLE `absents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `admins` -- DROP TABLE IF EXISTS `admins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `admins` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `picture` varchar(255) COLLATE utf8mb4_unicode_ci 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 NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `admins_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admins` -- LOCK TABLES `admins` WRITE; /*!40000 ALTER TABLE `admins` DISABLE KEYS */; INSERT INTO `admins` VALUES (1,'Admin','systemadmin','admin@gmail.com','admin/profile/23ece6e2ef473dc0c2a0bfcffd0b1128.png','$2y$10$sVy2civ27Jv0EmFjGKO9mO.P936WJOMp/VLAkzWeJN.zTYewQaux2',NULL,'2021-03-10 05:02:38',NULL); /*!40000 ALTER TABLE `admins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assign_absences` -- DROP TABLE IF EXISTS `assign_absences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `assign_absences` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `absent_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `assign_absences_user_id_unique` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_absences` -- LOCK TABLES `assign_absences` WRITE; /*!40000 ALTER TABLE `assign_absences` DISABLE KEYS */; /*!40000 ALTER TABLE `assign_absences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `contacts` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `organization_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `alternative_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `telephone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `status` tinyint unsigned NOT NULL DEFAULT '1', `is_approved` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; INSERT INTO `contacts` VALUES (1,'Organization AAA','AAA','adress A','101010',NULL,1,1,NULL,NULL),(2,'Organization BBB','BBB','adress B','202020',NULL,1,1,NULL,NULL); /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `delivery_types` -- DROP TABLE IF EXISTS `delivery_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `delivery_types` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `delivery_types_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `delivery_types` -- LOCK TABLES `delivery_types` WRITE; /*!40000 ALTER TABLE `delivery_types` DISABLE KEYS */; INSERT INTO `delivery_types` VALUES (1,'{\"en\":\"Courier\", \"ru\":\"Курьер\", \"tm\":\"Kurýer\"}',NULL,'2021-03-10 05:02:39',NULL),(2,'{\"en\":\"Electronic Email\", \"ru\":\"Электронная почта\", \"tm\":\"Elektron poçta\"}',NULL,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `delivery_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departments` -- DROP TABLE IF EXISTS `departments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `departments` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned NOT NULL DEFAULT '0', `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint unsigned NOT NULL DEFAULT '0', `responsible_user_id` int unsigned NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departments` -- LOCK TABLES `departments` WRITE; /*!40000 ALTER TABLE `departments` DISABLE KEYS */; INSERT INTO `departments` VALUES (1,0,'{\"en\":\"Assistant\", \"tm\":\"Kömekçi\", \"ru\":\"Помошник\"}',1,1,'2021-03-10 05:02:38',NULL),(2,0,'{\"en\":\"Registry\", \"tm\":\"Kanselýariýa\", \"ru\":\"Канцелярия\"}',1,1,'2021-03-10 05:02:38',NULL),(3,0,'{\"en\":\"Department1\", \"tm\":\"Department1\", \"ru\":\"Department1\"}',1,1,'2021-03-10 05:02:38',NULL),(4,0,'{\"en\":\"Department2\", \"tm\":\"Department2\", \"ru\":\"Department2\"}',1,1,'2021-03-10 05:02:38',NULL),(5,0,'{\"en\":\"SubDepartment of Dep1\", \"tm\":\"SubDepartment of Dep1\", \"ru\":\"SubDepartment of Dep1\"}',1,1,'2021-03-10 05:02:38',NULL); /*!40000 ALTER TABLE `departments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `directories` -- DROP TABLE IF EXISTS `directories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `directories` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` int unsigned DEFAULT NULL, `user_id` int unsigned DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `by_admin` int unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `directories` -- LOCK TABLES `directories` WRITE; /*!40000 ALTER TABLE `directories` DISABLE KEYS */; /*!40000 ALTER TABLE `directories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `document_types` -- DROP TABLE IF EXISTS `document_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `document_types` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `document_types` -- LOCK TABLES `document_types` WRITE; /*!40000 ALTER TABLE `document_types` DISABLE KEYS */; INSERT INTO `document_types` VALUES (1,'{\"en\":\"Microsoft Word\", \"ru\":\"Microsoft Word\", \"tm\":\"Microsoft Word\"}','',1,'2021-03-10 05:02:39',NULL),(2,'{\"en\":\"Microsoft Excel\", \"ru\":\"Microsoft Excel\", \"tm\":\"Microsoft Excel\"}','',1,'2021-03-10 05:02:39',NULL),(3,'{\"en\":\"Law & Regulation\", \"ru\":\"Закон и регулирование\", \"tm\":\"Kanun we düzgünnama\"}','',1,'2021-03-10 05:02:39',NULL),(4,'{\"en\":\"Complaint Letter\", \"ru\":\"Письмо с жалобой\", \"tm\":\"Şikaýat haty\"}','',1,'2021-03-10 05:02:39',NULL),(5,'{\"en\":\"All general Letter types\", \"ru\":\"Все типы документов\", \"tm\":\"Umumy hatlar\"}','',1,'2021-03-10 05:02:39',NULL),(6,'{\"en\":\"Greeting Letter\", \"ru\":\"Поздравительные Письма\", \"tm\":\"Gutlag Hatlary\"}','',1,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `document_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `events` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `link` text COLLATE utf8mb4_unicode_ci NOT NULL, `start_date_time` datetime DEFAULT NULL, `end_date_time` datetime 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `languages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `short_name` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `serial_no` int NOT NULL DEFAULT '0', `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `languages` -- LOCK TABLES `languages` WRITE; /*!40000 ALTER TABLE `languages` DISABLE KEYS */; INSERT INTO `languages` VALUES (1,'English','en',1,1,'2021-03-10 05:02:39',NULL),(2,'Русский','ru',4,1,'2021-03-10 05:02:39',NULL),(3,'Türkmençe','tm',2,1,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_100000_create_password_resets_table',1),(2,'2020_04_16_043659_create_admins_table',1),(3,'2020_04_16_094318_entrust_setup_tables',1),(4,'2021_03_06_101908_create_roles_table',1),(5,'2021_03_06_101918_create_users_table',1),(6,'2021_03_06_101938_create_role_user_table',1),(7,'2021_03_06_101956_create_permissions_table',1),(8,'2021_03_06_102003_create_permission_role_table',1),(9,'2021_03_08_060432_create_absents_table',1),(10,'2021_03_08_062621_create_assign_absences_table',1),(11,'2021_03_08_062758_create_contacts_table',1),(12,'2021_03_08_064800_create_delivery_types_table',1),(13,'2021_03_08_064825_create_departments_table',1),(14,'2021_03_08_071657_create_directories_table',1),(15,'2021_03_08_071706_create_document_types_table',1),(16,'2021_03_08_071713_create_events_table',1),(17,'2021_03_08_071725_create_languages_table',1),(18,'2021_03_08_073216_create_my_files_table',1),(19,'2021_03_08_073239_create_notifications_table',1),(20,'2021_03_08_073302_create_priorities_table',1),(21,'2021_03_08_074528_create_promotions_table',1),(22,'2021_03_08_074542_create_reset_document_numbers_table',1),(23,'2021_03_08_074601_create_settings_table',1),(24,'2021_03_08_081600_create_workflow_types_table',1),(25,'2021_03_08_081633_create_shared_files_table',1),(26,'2021_03_08_081636_create_workflow_documents_table',1),(27,'2021_03_08_085536_create_user_notifications_table',1),(28,'2021_03_08_085553_create_workflow_document_files_table',1),(29,'2021_03_08_085605_create_workflow_document_process_table',1),(30,'2021_03_08_085617_create_workflow_document_senders_table',1),(31,'2021_03_08_085626_create_workflow_document_users_table',1),(32,'2021_03_08_085651_create_workflow_free_no_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `my_files` -- DROP TABLE IF EXISTS `my_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `my_files` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `directory_id` int unsigned NOT NULL DEFAULT '0', `user_id` int unsigned NOT NULL DEFAULT '0', `tags` longtext COLLATE utf8mb4_unicode_ci, `files_name` longtext COLLATE utf8mb4_unicode_ci, `place_of_the_files` text COLLATE utf8mb4_unicode_ci NOT NULL, `is_temp` tinyint unsigned NOT NULL DEFAULT '1', `file_size` double(10,5) NOT NULL DEFAULT '0.00000', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `my_files` -- LOCK TABLES `my_files` WRITE; /*!40000 ALTER TABLE `my_files` DISABLE KEYS */; /*!40000 ALTER TABLE `my_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title_tm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title_ru` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `text_tm` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `text_ru` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `users` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permission_role` -- DROP TABLE IF EXISTS `permission_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permission_role` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `role_id` int unsigned NOT NULL DEFAULT '0', `department_id` int unsigned NOT NULL DEFAULT '0', `permission_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permission_role` -- LOCK TABLES `permission_role` WRITE; /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */; INSERT INTO `permission_role` VALUES (1,8,2,'[\"1\",\"2\",\"3\",\"4\",\"5\",\"7\",\"10\",\"11\"]','2021-03-10 05:02:39',NULL),(2,9,2,'[\"1\",\"2\",\"3\",\"4\",\"5\",\"7\",\"10\",\"11\"]','2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'Register Incoming Document',NULL,'Register Incoming Document','2021-03-10 05:02:39',NULL),(2,'Register Outgoing Document without Workflow',NULL,'Register Outgoing Document without Workflow','2021-03-10 05:02:39',NULL),(3,'Upload Scanned version of Outgoing Document',NULL,'Upload Scanned version of Outgoing Document (Final Approved)','2021-03-10 05:02:39',NULL),(4,'Add Contact',NULL,'Add Contact','2021-03-10 05:02:39',NULL),(5,'Edit Contact',NULL,'Edit Contact','2021-03-10 05:02:39',NULL),(6,'Delete Contact',NULL,'Delete Contact','2021-03-10 05:02:39',NULL),(7,'Approve Contact',NULL,'Approve Contact','2021-03-10 05:02:39',NULL),(8,'Outgoing Document Workflow – Final Approval',NULL,'Outgoing Workflow(Outgoing Document) – Final Approval','2021-03-10 05:02:39',NULL),(9,'Manage Share Folders',NULL,'Create Share Folder in Shared Folders (and give access rights to users or Departments)','2021-03-10 05:02:39',NULL),(10,'Add Related Document',NULL,'NULL','2021-03-10 05:02:39',NULL),(11,'Remove/Edit Related Document',NULL,'NULL','2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `priorities` -- DROP TABLE IF EXISTS `priorities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `priorities` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `completion_day` int unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `priorities` -- LOCK TABLES `priorities` WRITE; /*!40000 ALTER TABLE `priorities` DISABLE KEYS */; INSERT INTO `priorities` VALUES (1,'{\"en\":\"Low\", \"ru\":\"Низкий\", \"tm\":\"Pes\"}',1,'2021-03-10 05:02:39',NULL),(2,'{\"en\":\"Medium\", \"ru\":\"Средний\", \"tm\":\"Orta\"}',1,'2021-03-10 05:02:39',NULL),(3,'{\"en\":\"High\", \"ru\":\"Высокий\", \"tm\":\"Ýokary\"}',1,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `priorities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `promotions` -- DROP TABLE IF EXISTS `promotions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `promotions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL DEFAULT '0', `last_user_id` int unsigned DEFAULT NULL, `till_date` date 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `promotions` -- LOCK TABLES `promotions` WRITE; /*!40000 ALTER TABLE `promotions` DISABLE KEYS */; /*!40000 ALTER TABLE `promotions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reset_document_numbers` -- DROP TABLE IF EXISTS `reset_document_numbers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reset_document_numbers` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `workflow_type_id` int unsigned DEFAULT NULL, `status` tinyint unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reset_document_numbers` -- LOCK TABLES `reset_document_numbers` WRITE; /*!40000 ALTER TABLE `reset_document_numbers` DISABLE KEYS */; /*!40000 ALTER TABLE `reset_document_numbers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_user` -- DROP TABLE IF EXISTS `role_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_user` ( `user_id` int unsigned NOT NULL, `role_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_id`), KEY `role_user_role_id_foreign` (`role_id`), CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`), CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_user` -- LOCK TABLES `role_user` WRITE; /*!40000 ALTER TABLE `role_user` DISABLE KEYS */; INSERT INTO `role_user` VALUES (1,1,'2021-03-10 05:02:39',NULL),(2,2,'2021-03-10 05:02:39',NULL),(3,8,'2021-03-10 05:02:39',NULL),(4,9,'2021-03-10 05:02:39',NULL),(5,3,'2021-03-10 05:02:39',NULL),(6,3,'2021-03-10 05:02:39',NULL),(7,6,'2021-03-10 05:02:39',NULL),(8,3,'2021-03-10 05:02:39',NULL),(9,6,'2021-03-10 05:02:39',NULL),(10,5,'2021-03-10 05:02:39',NULL),(11,4,'2021-03-10 05:02:39',NULL),(12,7,'2021-03-10 05:02:39',NULL),(13,5,'2021-03-10 05:02:39',NULL),(14,5,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `role_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'{\"en\":\"CEO\", \"ru\":\"Ген.Директор\", \"tm\":\"Başlyk\"}',NULL,'2021-03-10 05:02:38',NULL),(2,'{\"en\":\"Deputy CEO\", \"ru\":\"Зам.Директор\", \"tm\":\"Başlygyň Orunbasary\"}',NULL,'2021-03-10 05:02:38',NULL),(3,'{\"en\":\"Department Director/Head\", \"ru\":\"Начальник/Head\", \"tm\":\"Bölüm müdiri/Müdir\"}',NULL,'2021-03-10 05:02:38',NULL),(4,'{\"en\":\"Sub Department Head\", \"ru\":\"Sub Department Head\", \"tm\":\"Sub Department Head\"}',NULL,'2021-03-10 05:02:38',NULL),(5,'{\"en\":\"Employee\", \"ru\":\"Специалист\", \"tm\":\"Hünärmen\"}',NULL,'2021-03-10 05:02:38',NULL),(6,'{\"en\":\"Deputy Director of Department\", \"ru\":\"Bölüm müdiriniň orunbasary\", \"tm\":\"Bölüm müdiriniň orunbasary\"}',NULL,'2021-03-10 05:02:38',NULL),(7,'{\"en\":\"Sub Department Deputy Head\", \"ru\":\"Sub Department Deputy Head\", \"tm\":\"Sub Department Deputy Head\"}',NULL,'2021-03-10 05:02:38',NULL),(8,'{\"en\":\"Registry\", \"ru\":\"Канцелярия\", \"tm\":\"Kanselýariýa\"}',NULL,'2021-03-10 05:02:38',NULL),(9,'{\"en\":\"Reg Employee\", \"ru\":\"Reg Employee\", \"tm\":\"Kanselýariýa Hünärmen\"}',NULL,'2021-03-10 05:02:38',NULL); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `website_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fabicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `organization_phone` longtext COLLATE utf8mb4_unicode_ci, `organization_address` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `copyright_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `document_name_prefix` text COLLATE utf8mb4_unicode_ci NOT NULL, `temporary_document_name_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `incoming_document_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `out_going_document_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `internal_document_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes_document_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_sequential_number_start_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_random_number_range` text COLLATE utf8mb4_unicode_ci NOT NULL, `comment_text_limit` text COLLATE utf8mb4_unicode_ci NOT NULL, `topic_text_limit` text COLLATE utf8mb4_unicode_ci NOT NULL, `additional_notes_text_limit` text COLLATE utf8mb4_unicode_ci NOT NULL, `allowed_uploaded_file_type` text COLLATE utf8mb4_unicode_ci NOT NULL, `registration_number_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `outgoing_registration_number_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `internal_registration_number_prefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_registration_number_with_date` tinyint unsigned NOT NULL DEFAULT '1', `default_language` tinyint unsigned NOT NULL DEFAULT '1', `data_limit_per_page` tinyint unsigned NOT NULL DEFAULT '25', `dashboard_data_limit` tinyint unsigned NOT NULL DEFAULT '25', `default_disk_quota` int unsigned NOT NULL DEFAULT '500', `user_file_size_limit` int unsigned NOT NULL DEFAULT '5', `notification_refreshing_time` tinyint unsigned NOT NULL DEFAULT '10', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'profile_1591818785.png','profile_1587650411.ico','{\"en\":\"EDMS Organization\", \"ru\":\"Организация EDMS\", \"tm\":\"EDMS Guramasy\"}','2545454','{\"en\":\"E-dms\",\"tm\":\"\",\"ru\":\"\"}','{\"en\":\"E-dms\",\"tm\":\"\",\"ru\":\"\"}','EDMS','EDMS','EDMS','EDMS','EDMS','EDMS','1','EDMS','500','500','500','pdf,jpeg,jpg,png,doc,docx,xls,xlsx','REG-GEL','REG-GID','REG-INT',1,1,25,25,500,5,10,'0000-00-00 00:00:00','0000-00-00 00:00:00'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `shared_files` -- DROP TABLE IF EXISTS `shared_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `shared_files` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `type` enum('F','D') COLLATE utf8mb4_unicode_ci NOT NULL, `file_id` int unsigned NOT NULL DEFAULT '0', `directory_id` int unsigned NOT NULL DEFAULT '0', `user_id` int unsigned NOT NULL DEFAULT '0', `department_id` int unsigned NOT NULL DEFAULT '0', `permission` enum('1','2','3') COLLATE utf8mb4_unicode_ci NOT NULL, `by_admin` int unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `shared_files` -- LOCK TABLES `shared_files` WRITE; /*!40000 ALTER TABLE `shared_files` DISABLE KEYS */; /*!40000 ALTER TABLE `shared_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_notifications` -- DROP TABLE IF EXISTS `user_notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_notifications` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `notification_id` bigint unsigned NOT NULL DEFAULT '0', `type` enum('A','N') COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int unsigned NOT NULL DEFAULT '0', `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `descriptions` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `destination_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_seen` tinyint unsigned NOT NULL DEFAULT '0', `is_delete` tinyint unsigned NOT NULL DEFAULT '0', `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_notifications` -- LOCK TABLES `user_notifications` WRITE; /*!40000 ALTER TABLE `user_notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `user_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned NOT NULL DEFAULT '0', `department_id` int unsigned NOT NULL DEFAULT '0', `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cell_phone_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `home_address` text COLLATE utf8mb4_unicode_ci, `status` tinyint unsigned NOT NULL DEFAULT '1', `working_status` tinyint unsigned NOT NULL DEFAULT '1', `is_log_in` tinyint unsigned NOT NULL DEFAULT '0', `user_language` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en', `user_disk_quota` int unsigned NOT NULL DEFAULT '500', `user_disk_uses` int unsigned 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, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,0,0,'ceo','ceo','ceo@online.tm','ceo',NULL,'$2y$10$aGe46Ck87QTuWCqtNh9giuLwsgrpZP6njA8vePTiBJF.Dwee5ixyG',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(2,0,0,'dyceo','dyceo','dyceo@online.tm','dyceo',NULL,'$2y$10$s071iVn15YU7F8mhuWtI9Orx/hYrsVesiu6VCBC7NgprXDsrfjGNS',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(3,0,2,'registryHead','registry','reg@online.tm','registry',NULL,'$2y$10$dfyJZDY/7qEcfw.pFnk6zOj54.X4KjKwa0s/P0er2xQRDjOcZ71gO',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(4,0,2,'registry2','registry2','registry2@online.tm','registry2',NULL,'$2y$10$L1hCAOpIGUqEkHAky6AIMeAUjPTJAQUMKajw5WuGx5VyHvkalV/rq',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(5,0,1,'Assistant','Assistant','assistant@online.tm','assistant',NULL,'$2y$10$2Eik78k5PiNTC1.VSOIcIuAbNhBpCR/CSkEXqIyWh.S6l4p1.f/3m',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(6,0,4,'Department2 - Director','Department2 - Director','dep2director@online.tm','dep2director',NULL,'$2y$10$s4mytJdX/me8sxuX1PCTiO/f7JkSjs.Iwq.o80zZSicNyfhf2YtkO',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(7,0,4,'dep2dydirector','dep2dydirector','dep2dydirector@online.tm','dep2dydirector',NULL,'$2y$10$7jkdTN8pGK6XX7VpEag09ugJn9roakf1zIe9bsZqgeLu8lgPaIiDe',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(8,0,3,'dep1director','dep1director','dep1director@online.tm','dep1director',NULL,'$2y$10$sQRFX42MEs7CTWQa/9Ehx.W44yFBrDkp7x5eh6Mc7xrieChDnbN/W',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(9,0,3,'dep1dydirector','dep1dydirector','dep1dydirector@online.tm','dep1dydirector',NULL,'$2y$10$vmHCfawgW0r5SFRy2ylimOqQ/qxOqNiKxlZSKsePJIRraAwPSEQhy',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(10,0,3,'Department1 Emp','Department1 Emp','dep1emp@online.tm','dep1emp',NULL,'$2y$10$78NZlgRiN4ItjJ1iToQmbeP7DrqCDmMDLfkrrtXCMRK/8PAHBHfH.',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(11,0,5,'sub1head','sub1head','sub1head@online.tm','sub1head',NULL,'$2y$10$8gOmFjrG2.WlatDTA8zNu.qgZ4AJ/ajOb6PzfWQD/25V0S5zP2/ve',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(12,0,5,'sub1dyhead','sub1dyhead','sub1dyhead@online.tm','sub1dyhead',NULL,'$2y$10$On4wunK31vGarbuTqkQg0..u2vYyMmogYHnsM8OVRRb4b.zpsLzcq',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(13,0,5,'sub1emp1','sub1emp1','sub1emp1@online.tm','sub1emp1',NULL,'$2y$10$LTX8E2slQeI.14ridF0Fk.H7k4X1hRYtG6Bxmbad9YHcVygvSdXDG',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL),(14,0,5,'sub1emp2','sub1emp2','sub1emp2@online.tm','sub1emp2',NULL,'$2y$10$2NG.gzEZc/3kC36rLMmEK.uVsr9IzXiiC3Cxux5yaolQopBqy1KFi',NULL,NULL,NULL,1,1,0,'en',500,0,NULL,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_document_files` -- DROP TABLE IF EXISTS `workflow_document_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_document_files` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `workflow_document_id` int unsigned NOT NULL DEFAULT '0', `document_type` enum('R','S') COLLATE utf8mb4_unicode_ci NOT NULL, `document_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `place_of_the_documents` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('Y','N') COLLATE utf8mb4_unicode_ci NOT NULL, `uploaded_by` int unsigned NOT NULL DEFAULT '0', `uploader_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `version` tinyint unsigned NOT NULL DEFAULT '1', `process_id` int NOT NULL DEFAULT '0', `is_temp` tinyint unsigned NOT NULL DEFAULT '1', `is_signed` tinyint unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_document_files` -- LOCK TABLES `workflow_document_files` WRITE; /*!40000 ALTER TABLE `workflow_document_files` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_document_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_document_process` -- DROP TABLE IF EXISTS `workflow_document_process`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_document_process` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned NOT NULL DEFAULT '0', `workflow_document_id` int unsigned NOT NULL DEFAULT '0', `user_id` int unsigned NOT NULL DEFAULT '0', `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assign_by` int unsigned DEFAULT NULL, `assigner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigner_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigner_role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigner_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assign_date` date DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('P','W','CO','D','CA','R','SA','A','RE') COLLATE utf8mb4_unicode_ci NOT NULL, `is_approved` tinyint unsigned NOT NULL DEFAULT '0', `user_type` enum('R','S') COLLATE utf8mb4_unicode_ci NOT NULL, `supporter_action` enum('P','A','N') 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_document_process` -- LOCK TABLES `workflow_document_process` WRITE; /*!40000 ALTER TABLE `workflow_document_process` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_document_process` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_document_senders` -- DROP TABLE IF EXISTS `workflow_document_senders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_document_senders` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `workflow_document_id` int unsigned NOT NULL DEFAULT '0', `contact_id` int unsigned NOT NULL DEFAULT '0', `contact_organization_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_alternative_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_address` text COLLATE utf8mb4_unicode_ci NOT NULL, `contact_telephone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('Y','N') 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_document_senders` -- LOCK TABLES `workflow_document_senders` WRITE; /*!40000 ALTER TABLE `workflow_document_senders` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_document_senders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_document_users` -- DROP TABLE IF EXISTS `workflow_document_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_document_users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `workflow_document_id` int unsigned NOT NULL DEFAULT '0', `process_id` int unsigned NOT NULL DEFAULT '0', `user_id` int unsigned NOT NULL DEFAULT '0', `user_type` enum('R','S') COLLATE utf8mb4_unicode_ci NOT NULL, `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('Y','N') COLLATE utf8mb4_unicode_ci NOT NULL, `is_read` tinyint unsigned NOT NULL DEFAULT '0', `added_by` int unsigned NOT NULL DEFAULT '0', `is_approved` enum('P','N','Y') COLLATE utf8mb4_unicode_ci NOT NULL, `promotion_id` int unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_document_users` -- LOCK TABLES `workflow_document_users` WRITE; /*!40000 ALTER TABLE `workflow_document_users` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_document_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_documents` -- DROP TABLE IF EXISTS `workflow_documents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_documents` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `workflow_type_id` int unsigned NOT NULL DEFAULT '0', `workflow_type_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `due_date` date DEFAULT NULL, `priority_id` int unsigned NOT NULL DEFAULT '0', `priority_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `max_completion_days` int unsigned NOT NULL DEFAULT '0', `temporary_registration_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `registration_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `registration_date` date DEFAULT NULL, `delivery_type_id` int unsigned NOT NULL DEFAULT '0', `delivery_type_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `document_type_id` int unsigned NOT NULL DEFAULT '0', `document_type_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `sender_letter_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sender_letter_date` date DEFAULT NULL, `topic` text COLLATE utf8mb4_unicode_ci NOT NULL, `additional_notes` text COLLATE utf8mb4_unicode_ci, `place_of_the_documents` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment` text COLLATE utf8mb4_unicode_ci, `creator_id` int unsigned NOT NULL DEFAULT '0', `creator_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_documents` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_for` int NOT NULL DEFAULT '0', `is_deleted` tinyint unsigned NOT NULL DEFAULT '0', `is_rejected` tinyint unsigned NOT NULL DEFAULT '0', `is_workflow_free` int unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_documents` -- LOCK TABLES `workflow_documents` WRITE; /*!40000 ALTER TABLE `workflow_documents` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_free_no` -- DROP TABLE IF EXISTS `workflow_free_no`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_free_no` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `reg_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int unsigned 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_free_no` -- LOCK TABLES `workflow_free_no` WRITE; /*!40000 ALTER TABLE `workflow_free_no` DISABLE KEYS */; /*!40000 ALTER TABLE `workflow_free_no` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `workflow_types` -- DROP TABLE IF EXISTS `workflow_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `workflow_types` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `assigned_deadline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint unsigned NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `workflow_types` -- LOCK TABLES `workflow_types` WRITE; /*!40000 ALTER TABLE `workflow_types` DISABLE KEYS */; INSERT INTO `workflow_types` VALUES (1,'{\"en\":\"Incoming\", \"ru\":\"Входящие\", \"tm\":\"Gelen\"}',NULL,1,'2021-03-10 05:02:39',NULL),(2,'{\"en\":\"Outgoing\", \"ru\":\"Исходящие\", \"tm\":\"Giden\"}',NULL,1,'2021-03-10 05:02:39',NULL),(3,'{\"en\":\"Internal\", \"ru\":\"Внутренние\", \"tm\":\"Içki\"}',NULL,1,'2021-03-10 05:02:39',NULL),(4,'{\"en\":\"Note\", \"ru\":\"Note\", \"tm\":\"Note\"}',NULL,1,'2021-03-10 05:02:39',NULL); /*!40000 ALTER TABLE `workflow_types` ENABLE KEYS */; UNLOCK TABLES; /*!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 2021-03-10 15:03:00