TPS
/
edms2023
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
edms2023/my.sql

1042 lines
48 KiB
MySQL
Raw Permalink Normal View History

all
2023-09-14 20:59:46 +00:00
-- 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