-- --------------------------------------------------------
-- Хост:                         127.0.0.1
-- Версия сервера:               8.0.24 - MySQL Community Server - GPL
-- Операционная система:         Win64
-- HeidiSQL Версия:              11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;


-- Дамп структуры базы данных laravel_rekamore
--CREATE DATABASE IF NOT EXISTS `laravel_rekamore` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
--USE `laravel_rekamore`;

-- Дамп структуры для таблица laravel_rekamore.ad_employers
CREATE TABLE IF NOT EXISTS `ad_employers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `employer_id` bigint NOT NULL,
  `category_id` int NOT NULL DEFAULT '1',
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int 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;

-- Дамп данных таблицы laravel_rekamore.ad_employers: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `ad_employers` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_employers` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.ad_jobs
CREATE TABLE IF NOT EXISTS `ad_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ad_employer_id` bigint NOT NULL,
  `job_title_id` bigint 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;

-- Дамп данных таблицы laravel_rekamore.ad_jobs: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `ad_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_jobs` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) 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;

-- Дамп данных таблицы laravel_rekamore.categories: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.employers
CREATE TABLE IF NOT EXISTS `employers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `name_company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate` double(8,2) NOT NULL DEFAULT '0.00',
  `text` text COLLATE utf8mb4_unicode_ci,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.employers: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `employers` DISABLE KEYS */;
/*!40000 ALTER TABLE `employers` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.failed_jobs: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.group_users
CREATE TABLE IF NOT EXISTS `group_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.group_users: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `group_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_users` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.group_works
CREATE TABLE IF NOT EXISTS `group_works` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group_user_id` bigint NOT NULL,
  `user_id` bigint 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;

-- Дамп данных таблицы laravel_rekamore.group_works: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `group_works` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_works` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.job_titles
CREATE TABLE IF NOT EXISTS `job_titles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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;

-- Дамп данных таблицы laravel_rekamore.job_titles: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `job_titles` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_titles` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.messages
CREATE TABLE IF NOT EXISTS `messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `to_user_id` bigint NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.messages: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.migrations: ~21 rows (приблизительно)
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_resets_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2023_05_15_102620_alter_users_table', 2),
	(6, '2023_05_16_062924_alter_users_table2', 3),
	(7, '2023_05_16_080855_create_workers_table', 3),
	(8, '2023_05_16_080945_create_employers_table', 3),
	(9, '2023_05_16_081048_create_ad_employers_table', 3),
	(10, '2023_05_16_081113_create_categories_table', 3),
	(11, '2023_05_16_081142_create_group_users_table', 3),
	(12, '2023_05_16_081213_create_job_titles_table', 3),
	(13, '2023_05_16_081237_create_messages_table', 3),
	(14, '2023_05_16_081308_create_static_workers_table', 3),
	(15, '2023_05_16_081330_create_static_ads_table', 3),
	(16, '2023_05_16_092746_alter_ad_jobs_table', 4),
	(17, '2023_05_16_092836_alter_group_work_table', 4),
	(18, '2023_05_17_090650_alter_group_users_table', 5),
	(19, '2023_05_17_090749_alter_messages_table', 5),
	(20, '2023_05_17_090923_alter_employers_table', 5),
	(21, '2023_05_17_090944_alter_workers_table', 5),
	(22, '2023_05_17_095512_alter_users_table', 6);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.password_resets: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.personal_access_tokens: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.static_ads
CREATE TABLE IF NOT EXISTS `static_ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ad_employer_id` bigint NOT NULL,
  `lookin` int NOT NULL DEFAULT '0',
  `month_year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` int 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;

-- Дамп данных таблицы laravel_rekamore.static_ads: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `static_ads` DISABLE KEYS */;
/*!40000 ALTER TABLE `static_ads` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.static_workers
CREATE TABLE IF NOT EXISTS `static_workers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `lookin` int NOT NULL DEFAULT '0',
  `month_year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` int 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;

-- Дамп данных таблицы laravel_rekamore.static_workers: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `static_workers` DISABLE KEYS */;
/*!40000 ALTER TABLE `static_workers` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_man` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surname2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_worker` tinyint(1) NOT NULL DEFAULT '0',
  `is_lookin` tinyint(1) NOT NULL DEFAULT '1',
  `is_message` tinyint(1) NOT NULL DEFAULT '1',
  `is_public` tinyint(1) NOT NULL DEFAULT '1',
  `is_remove` tinyint(1) NOT NULL DEFAULT '0',
  `is_ban` tinyint(1) NOT NULL DEFAULT '0',
  `is_new` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.users: ~4 rows (приблизительно)
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `email`, `admin`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `telephone`, `surname`, `name_man`, `surname2`, `is_worker`, `is_lookin`, `is_message`, `is_public`, `is_remove`, `is_ban`, `is_new`) VALUES
	(1, 'Администратор', 'admin@mail.ru', 1, '2023-05-15 14:46:39', '$2y$10$4LrFVBjWy.Tjl2OJIuvfiOppobeQNA42bzJ5c1AJRgv1vm56N0/Yq', 'TqzY4yyIUyLJYRdSzGLqGTxNKL4E1x3EbCF2OLlI6bugbek0wRnYNThSMfUh', '2023-05-15 07:46:26', '2023-05-17 13:44:10', '+79131340942', NULL, 'Андрей', NULL, 0, 1, 1, 1, 0, 0, 0),
	(2, 'integralal', 'integralal@mail.ru', 0, '2023-05-15 20:35:12', '$2y$10$As4bkRP3XXiSZG3rERW4Uee05nD9bO8vABDpakx.xG8tuEuBvK9Qq', '9SuLE4Ig5j20yrJxLd3OcAXZ6AQB8hqbZwLlr6o6E3ld5BuTbwuz92kGK1xW', '2023-05-15 10:16:27', '2023-05-17 13:44:09', NULL, NULL, 'Александр', NULL, 1, 1, 1, 1, 0, 0, 0),
	(3, 'менеджер', 'info@renttorg.ru', 0, NULL, '$2y$10$avhr9OwECSHOtRDCE4Qe/uyq8MelzHKRiRT3NqEm/KApe.JcNSkAK', '5cZRhemIWOPFFQUtB0acF6vFvJVfS9WvSRXxxmTkoFiBiy1Gbv4ZbHQhMQWZ', '2023-05-17 06:45:07', '2023-05-17 13:46:17', NULL, NULL, 'Олег', NULL, 0, 1, 1, 1, 0, 0, 0),
	(4, 'Админ-менеджер', 'Info@vekprom.ru', 1, '2023-05-17 15:34:57', '$2y$10$9l3vgMBMFlqAt4xyY7v9EuWB0EdCOVTd1scM2a3FIcXzpI.JPCVmq', 'lPwraQgpzNn7uXB72f4jhvRkcORzmownmJEjFGfXfNPGoWHX44M9DDUm67YG', '2023-05-17 08:33:37', '2023-05-17 13:43:40', NULL, NULL, 'Наталья', NULL, 0, 1, 1, 1, 0, 0, 0);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

-- Дамп структуры для таблица laravel_rekamore.workers
CREATE TABLE IF NOT EXISTS `workers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `status_work` int NOT NULL DEFAULT '1',
  `position_work` int NOT NULL DEFAULT '1',
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persent_anketa` int NOT NULL DEFAULT '10',
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_data` tinyint(1) NOT NULL DEFAULT '0',
  `status_profile` int NOT NULL DEFAULT '1',
  `old_year` int DEFAULT NULL,
  `experience` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_is` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `interpassport` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mk` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vvp` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vlm` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reka_diplom` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `more_diplom` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mpss` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanker` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gmssb` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resume` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Дамп данных таблицы laravel_rekamore.workers: ~0 rows (приблизительно)
/*!40000 ALTER TABLE `workers` DISABLE KEYS */;
/*!40000 ALTER TABLE `workers` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;