CREATE DATABASE  IF NOT EXISTS `wsr2025` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `wsr2025`;
-- MySQL dump 10.13  Distrib 8.0.45, for Win64 (x86_64)
--
-- Host: localhost    Database: wsr2025
-- ------------------------------------------------------
-- Server version	5.5.5-10.11.14-MariaDB

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `companies`
--

DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companies`
--

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES (1,'ВендингПро','Иванов Иван','+7 (495) 123-45-67','ivanov@vendingpro.ru'),(2,'СмартВенд','Петрова Анна','+7 (495) 234-56-78','petrova@smartvend.ru'),(3,'АвтоТорг','Сидоров Петр','+7 (495) 345-67-89','sidorov@avtotorg.ru');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `position` varchar(50) DEFAULT NULL,
  `models_can_service` text DEFAULT NULL COMMENT 'Модели через запятую, которые может обслуживать',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES (1,'Иванов Иван','ivanov@service.com','+7-900-111-22-33','Инженер','VM-2000X,VM-3000Y,VM-4000Z'),(2,'Петров Петр','petrov@service.com','+7-900-222-33-44','Инженер','VM-3000Y,VM-5000A,VM-6000B'),(3,'Сидоров Алексей','sidorov@service.com','+7-900-333-44-55','Техник','VM-2000X,VM-4000Z'),(4,'Смирнова Анна','smirnova@service.com','+7-900-444-55-66','Инженер','VM-3000Y,VM-6000B');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `incomes`
--

DROP TABLE IF EXISTS `incomes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `incomes` (
  `id` int(11) NOT NULL,
  `vending_machine_id` int(11) DEFAULT NULL,
  `income_date` date DEFAULT NULL,
  `amount` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `incomes`
--

LOCK TABLES `incomes` WRITE;
/*!40000 ALTER TABLE `incomes` DISABLE KEYS */;
INSERT INTO `incomes` VALUES (1,1,'2026-01-15',12500),(2,2,'2026-01-15',15300),(3,3,'2026-01-15',11800),(4,4,'2026-01-15',8900),(5,5,'2026-01-15',14200),(6,6,'2026-01-15',13600),(7,7,'2026-01-15',5400),(8,8,'2026-01-15',16700),(9,9,'2026-01-15',15100),(10,10,'2026-01-15',18200),(11,1,'2025-12-15',13200),(12,2,'2025-12-15',16100),(13,3,'2025-12-15',12300),(14,4,'2025-12-15',9800),(15,5,'2025-12-15',14800),(16,6,'2025-12-15',14100),(17,7,'2025-12-15',11200),(18,8,'2025-12-15',17300),(19,9,'2025-12-15',15800),(20,10,'2025-12-15',19100),(21,1,'2026-02-04',4200),(22,2,'2026-02-04',5100),(23,3,'2026-02-04',3900),(24,4,'2026-02-04',2800),(25,5,'2026-02-04',4700),(26,6,'2026-02-04',4500),(27,7,'2026-02-04',1800),(28,8,'2026-02-04',5600),(29,9,'2026-02-04',5000),(30,10,'2026-02-04',6100),(31,1,'2026-01-27',3200),(32,2,'2026-01-27',4100),(33,3,'2026-01-27',2900),(34,1,'2026-01-28',5500),(35,2,'2026-01-28',6200),(36,1,'2026-01-29',11500),(37,2,'2026-01-29',12200),(38,3,'2026-01-29',10800),(39,1,'2026-01-30',12100),(40,2,'2026-01-30',13800),(41,1,'2026-01-31',11700),(42,2,'2026-01-31',12900),(50,1,'2026-02-01',4500),(51,2,'2026-02-01',5200),(52,3,'2026-02-01',3800),(53,4,'2026-02-01',2900),(54,5,'2026-02-01',4100),(55,1,'2026-02-02',4700),(56,2,'2026-02-02',5400),(57,3,'2026-02-02',4000),(58,4,'2026-02-02',3100),(59,5,'2026-02-02',4300),(60,1,'2026-02-03',4600),(61,2,'2026-02-03',5300),(62,3,'2026-02-03',3900),(63,4,'2026-02-03',3000),(64,5,'2026-02-03',4200),(65,1,'2026-02-04',4800),(66,2,'2026-02-04',5600),(67,3,'2026-02-04',4100),(68,4,'2026-02-04',3200),(69,5,'2026-02-04',4400),(70,6,'2026-02-04',4900),(71,7,'2026-02-04',2100),(72,8,'2026-02-04',6100),(73,9,'2026-02-04',2300),(74,10,'2026-02-04',6800),(75,1,'2026-02-05',5100),(76,2,'2026-02-05',5900),(77,3,'2026-02-05',4400),(78,4,'2026-02-05',3500),(79,5,'2026-02-05',4700),(80,6,'2026-02-05',5200),(81,7,'2026-02-05',2300),(82,8,'2026-02-05',6400),(83,9,'2026-02-05',5800),(84,10,'2026-02-05',7100),(85,1,'2026-02-05',1200),(86,2,'2026-02-05',1500),(87,3,'2026-02-05',900),(88,4,'2026-02-05',800),(89,5,'2026-02-05',1100),(90,1,'2026-01-30',4300),(91,2,'2026-01-30',5100),(92,3,'2026-01-30',3700),(93,1,'2026-01-31',4400),(94,2,'2026-01-31',5200),(95,1,'2026-02-01',4500),(96,2,'2026-02-01',5300),(97,1,'2026-02-02',4600),(98,2,'2026-02-02',5400),(99,1,'2026-02-03',4700),(100,2,'2026-02-03',5500);
/*!40000 ALTER TABLE `incomes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `modems`
--

DROP TABLE IF EXISTS `modems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `modems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(50) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'active',
  PRIMARY KEY (`id`),
  UNIQUE KEY `serial_number` (`serial_number`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modems`
--

LOCK TABLES `modems` WRITE;
/*!40000 ALTER TABLE `modems` DISABLE KEYS */;
INSERT INTO `modems` VALUES (1,'MDM-001','Huawei E3372','+7 (900) 111-11-11','active'),(2,'MDM-002','ZTE MF833','+7 (900) 222-22-22','active'),(3,'MDM-003','Huawei E3372','+7 (900) 333-33-33','active'),(4,'MDM-004','TP-Link M7350','+7 (900) 444-44-44','active'),(5,'MDM-005','Huawei E8372','+7 (900) 555-55-55','active'),(6,'MDM-006','ZTE MF833','+7 (900) 666-66-66','active'),(7,'MDM-007','Huawei E3372','+7 (900) 777-77-77','active'),(8,'MDM-008','TP-Link M7350','+7 (900) 888-88-88','active'),(9,'MDM-009','Huawei E8372','+7 (900) 999-99-99','active'),(10,'MDM-010','ZTE MF833','+7 (900) 000-00-00','active');
/*!40000 ALTER TABLE `modems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `min_stock` int(11) DEFAULT NULL,
  `sales_tendency` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'Coca-Cola 0.5л','Газированный напиток',80.00,3,5,'high'),(2,'Snickers','Шоколадный батончик',65.00,0,10,'high'),(3,'Lays Original','Чипсы классические',90.00,2,5,'medium'),(4,'Pepsi 0.5л','Газированный напиток',75.00,140,20,'high'),(5,'Mars','Шоколадный батончик',60.00,190,30,'medium'),(6,'Kitkat','Вафельный батончик',70.00,160,25,'medium'),(7,'Fanta 0.5л','Газированный напиток',75.00,130,20,'medium'),(8,'Bounty','Шоколадный батончик с кокосом',65.00,170,30,'low'),(9,'Sprite 0.5л','Газированный напиток',75.00,145,20,'high'),(10,'Twix','Шоколадный батончик с печеньем',70.00,185,30,'medium'),(11,'Кофе Americano','Черный кофе',120.00,80,15,'high'),(12,'Кофе Cappuccino','Кофе с молоком',150.00,75,15,'high'),(13,'Вода Aqua Minerale','Минеральная вода 0.5л',50.00,250,40,'high'),(14,'Сок Добрый','Апельсиновый сок 0.33л',85.00,120,20,'medium'),(15,'Энергетик RedBull','Энергетический напиток',180.00,100,15,'low');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `service_requests`
--

DROP TABLE IF EXISTS `service_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `service_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vending_machine_id` int(11) NOT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Новая' COMMENT 'Новая, В работе, Завершена, Авария',
  `priority` varchar(20) DEFAULT 'Обычная' COMMENT 'Обычная, Авария',
  `scheduled_date` date DEFAULT NULL,
  `scheduled_time` time DEFAULT NULL,
  `service_duration_hours` int(11) DEFAULT 1,
  `travel_time_hours` int(11) DEFAULT 2 COMMENT '1 час туда + 1 час обратно',
  `description` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_vending_machine` (`vending_machine_id`),
  KEY `idx_employee` (`employee_id`),
  KEY `idx_status` (`status`),
  KEY `idx_scheduled_date` (`scheduled_date`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_requests`
--

LOCK TABLES `service_requests` WRITE;
/*!40000 ALTER TABLE `service_requests` DISABLE KEYS */;
INSERT INTO `service_requests` VALUES (1,1,1,'В работе','Обычная','2026-02-07','10:00:00',1,2,'Плановое ТО','2026-02-07 21:52:38'),(2,2,2,'В работе','Обычная','2026-02-07','14:00:00',1,2,'Плановое ТО','2026-02-07 21:52:38'),(3,3,NULL,'Новая','Обычная','2026-02-09','09:00:00',1,2,'Плановое ТО','2026-02-07 21:52:38'),(4,7,3,'Авария','Обычная','2026-02-07','08:00:00',1,2,'Критическая поломка','2026-02-07 21:52:38');
/*!40000 ALTER TABLE `service_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `vending_machine_id` int(11) DEFAULT NULL,
  `service_date` date DEFAULT NULL,
  `duration_hours` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `services`
--

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES (1,1,'2025-12-15',2,'Плановое ТО'),(2,2,'2025-12-20',3,'Ремонт'),(3,3,'2026-01-10',2,'Плановое ТО'),(4,4,'2026-01-15',4,'Капитальный ремонт'),(5,5,'2026-01-20',2,'Плановое ТО'),(6,6,'2025-11-25',3,'Замена детали'),(7,7,'2026-01-28',5,'Капитальный ремонт'),(8,8,'2025-12-30',2,'Плановое ТО'),(9,9,'2026-01-05',3,'Ремонт'),(10,10,'2025-11-18',2,'Плановое ТО'),(11,1,'2026-02-01',2,'Плановое ТО'),(12,2,'2026-02-01',3,'Плановое ТО'),(13,3,'2026-02-02',2,'Плановое ТО'),(14,5,'2026-02-03',2,'Плановое ТО'),(15,6,'2026-02-03',3,'Плановое ТО'),(16,7,'2026-02-01',5,'Капитальный ремонт'),(17,4,'2026-02-02',4,'Ремонт'),(18,8,'2026-02-03',3,'Замена детали'),(19,9,'2026-02-04',2,'Ремонт'),(20,10,'2026-02-05',1,'Ремонт'),(21,7,'2026-02-05',2,'Ремонт'),(22,4,'2026-02-05',3,'Замена детали');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status_history`
--

DROP TABLE IF EXISTS `status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'request или equipment',
  `entity_id` int(11) NOT NULL,
  `old_status` varchar(50) DEFAULT NULL,
  `new_status` varchar(50) DEFAULT NULL,
  `changed_by` int(11) DEFAULT NULL COMMENT 'user_id',
  `changed_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_entity` (`entity_type`,`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status_history`
--

LOCK TABLES `status_history` WRITE;
/*!40000 ALTER TABLE `status_history` DISABLE KEYS */;
INSERT INTO `status_history` VALUES (1,'request',1,'Новая','В работе',1,'2026-02-08 21:33:17'),(2,'request',2,'Новая','В работе',1,'2026-02-08 21:33:17'),(3,'equipment',2,'working','В ремонте/на обслуживании',1,'2026-02-08 21:33:17');
/*!40000 ALTER TABLE `status_history` 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` (
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `role` varchar(100) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password_hash` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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 ('','test@example.com',NULL,1,'$2b$12$tnzKdN9hFD7CvGELd599.Owgo4DVe1tjRXXeyMPyT1VWSjuBtP.ZO'),('','test2@ex222ample.com',NULL,2,'$2b$12$tbLvJ1refG/7h22hXhmAwOgxiwJ5WjkSMVZDtIRz69WXicJOOvZLm'),('','aaa',NULL,3,'$2b$12$sFwWoboHeOQh3MUPsOV3buONz3M/rWyPNiCogGu5VwmYbTD98AJdm'),('','1',NULL,4,'$2b$12$gewlJTXwCFO/gUPFl/aQcuB2whbYCFwkI0okgw9.X6efhM5iJCWk2'),('','newuser@example.com',NULL,5,'$2b$12$nWyrXMdT/UNL1PdZ6DrnH.0jeczOs3G5qw6hzIVQEplfB1VNi.mvi');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vending_machines`
--

DROP TABLE IF EXISTS `vending_machines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vending_machines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `serial_number` int(11) DEFAULT NULL,
  `inventory_number` int(11) DEFAULT NULL,
  `model` varchar(45) DEFAULT NULL,
  `manufacturer` varchar(45) DEFAULT NULL,
  `country` varchar(45) DEFAULT NULL,
  `resource_hours` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `modem_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `installation_date` date DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `franchisee_id` int(11) DEFAULT NULL,
  `last_service_date` date DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `service_interval_months` int(11) DEFAULT 6,
  `hours_worked` int(11) DEFAULT 0 COMMENT 'Наработка часов',
  `equipment_status` varchar(50) DEFAULT 'Работает',
  PRIMARY KEY (`id`),
  UNIQUE KEY `serial_number_UNIQUE` (`serial_number`),
  UNIQUE KEY `inventory_number_UNIQUE` (`inventory_number`),
  KEY `fk_vending_machines_company` (`company_id`),
  KEY `fk_vending_machines_modem` (`modem_id`),
  CONSTRAINT `fk_vending_machines_company` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_vending_machines_modem` FOREIGN KEY (`modem_id`) REFERENCES `modems` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vending_machines`
--

LOCK TABLES `vending_machines` WRITE;
/*!40000 ALTER TABLE `vending_machines` DISABLE KEYS */;
INSERT INTO `vending_machines` VALUES (2,'Автомат №2',1002,2002,'VM-3000Y','AutoVend','Germany',12000,'Drinks',1,2,'Офисный центр Альфа, холл 2 этажа','2023-02-20','Офисный центр Альфа',1,'2025-10-07','2026-04-07',6,5174,'В ремонте/на обслуживании'),(3,'Автомат №3',1003,2003,'VM-2000X','VendoTech','Japan',18000,'Snacks',1,3,'Вокзал, зал ожидания №1','2023-03-10','Вокзал, зал ожидания',1,'2025-10-07','2026-04-07',6,3626,'working'),(4,'Автомат №4',1004,2004,'VM-4000Z','SmartVend','USA',20000,'Coffee',2,4,'Университет, корпус А, 1 этаж','2023-04-05','Университет, корпус А',1,'2025-10-07','2026-04-07',6,2607,'maintenance'),(5,'Автомат №5',1005,2005,'VM-3000Y','AutoVend','Germany',14000,'Drinks',2,5,'Больница №5, главный корпус, холл','2023-05-12','Больница, холл',1,'2025-10-07','2026-04-07',6,2159,'working'),(6,'Автомат №6',1006,2006,'VM-2000X','VendoTech','Japan',16000,'Snacks',2,6,'Бизнес-центр Омега, 3 этаж','2023-06-18','Бизнес-центр Омега',1,'2025-10-07','2026-04-07',6,2975,'working'),(7,'Автомат №7',1007,2007,'VM-5000A','MegaVend','China',10000,'Mixed',2,7,'ТЦ Ритейл, фуд-корт','2023-07-22','Торговый центр Ритейл',1,'2025-10-07','2026-04-07',6,399,'broken'),(8,'Автомат №8',1008,2008,'VM-4000Z','SmartVend','USA',22000,'Coffee',3,8,'Метро Центр, вестибюль','2023-08-30','Метро станция Центр',1,'2025-10-07','2026-04-07',6,1070,'broken'),(9,'Автомат №9',1009,2009,'VM-3000Y','AutoVend','Germany',13000,'Drinks',3,9,'Аэропорт, терминал 2, зона вылета','2023-09-14','Аэропорт, терминал 2',1,'2025-10-07','2026-04-07',6,4155,'working'),(10,'Автомат №10',1010,2010,'VM-6000B','UltraVend','Korea',25000,'Premium',3,10,'Парк культуры, главный вход','2023-10-25','Парк культуры',1,'2025-10-07','2026-04-07',6,1563,'working'),(11,NULL,2001,3001,'VM-2000X','VendoTech','Japan',15000,'Snacks',NULL,NULL,NULL,NULL,'ТЦ Галерея вход 2',1,'2026-02-08','2026-08-07',6,0,'Работает'),(12,NULL,2002,3002,'VM-3000Y','AutoVend','Germany',12000,'Drinks',NULL,NULL,NULL,NULL,'Офис БЦ Альфа 5 этаж',1,'2026-02-08','2026-08-07',6,0,'Работает'),(13,NULL,2003,3003,'VM-4000Z','SmartVend','USA',20000,'Coffee',NULL,NULL,NULL,NULL,'Университет МГТУ главный корпус',1,'2026-02-08','2026-08-07',6,0,'Работает'),(14,NULL,2004,3004,'VM-5000A','MegaVend','China',10000,'Mixed',NULL,NULL,NULL,NULL,'Аэропорт Домодедово терминал 2',1,'2026-02-08','2026-08-07',6,0,'Работает'),(15,NULL,2005,3005,'VM-6000B','UltraVend','Korea',25000,'Premium',NULL,NULL,NULL,NULL,'ТЦ Атриум фудкорт',1,'2026-02-08','2026-08-07',6,0,'Работает'),(16,NULL,2006,3006,'VM-2000X','VendoTech','Japan',15000,'Snacks',NULL,NULL,NULL,NULL,'Метро Маяковская выход 3',1,'2026-02-08','2026-08-07',6,0,'Работает'),(17,NULL,2007,3007,'VM-3000Y','AutoVend','Germany',12000,'Drinks',NULL,NULL,NULL,NULL,'Бизнес-центр Омега лобби',1,'2026-02-08','2026-08-07',6,0,'Работает'),(18,NULL,2008,3008,'VM-4000Z','SmartVend','USA',20000,'Coffee',NULL,NULL,NULL,NULL,'Больница им. Боткина холл',1,'2026-02-08','2026-08-07',6,0,'Работает'),(19,NULL,2009,3009,'VM-5000A','MegaVend','China',10000,'Mixed',NULL,NULL,NULL,NULL,'Вокзал Казанский зал ожидания',1,'2026-02-08','2026-08-07',6,0,'Работает'),(20,NULL,2010,3010,'VM-6000B','UltraVend','Korea',25000,'Premium',NULL,NULL,NULL,NULL,'Парк Горького центральный вход',1,'2026-02-08','2026-08-07',6,0,'Работает'),(21,NULL,2011,3011,'VM-2000X','VendoTech','Japan',15000,'Snacks',NULL,NULL,NULL,NULL,'ТЦ Европейский 3 этаж',1,'2026-02-08','2026-08-07',6,0,'Работает'),(22,NULL,2012,3012,'VM-3000Y','AutoVend','Germany',12000,'Drinks',NULL,NULL,NULL,NULL,'Офис Яндекс корпус Б',1,'2026-02-08','2026-08-07',6,0,'Работает');
/*!40000 ALTER TABLE `vending_machines` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vending_maintenance`
--

DROP TABLE IF EXISTS `vending_maintenance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vending_maintenance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `comissioning_date` date DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `service_duration_hours` int(11) DEFAULT NULL,
  `service_request_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vending_maintenance`
--

LOCK TABLES `vending_maintenance` WRITE;
/*!40000 ALTER TABLE `vending_maintenance` DISABLE KEYS */;
INSERT INTO `vending_maintenance` VALUES (1,'ТЦ Мега, 1 этаж','working','2023-01-15','2026-03-15',2,NULL),(2,'Офисный центр Альфа','working','2023-02-20','2026-03-20',3,NULL),(3,'Вокзал, зал ожидания','working','2023-03-10','2026-04-10',2,NULL),(4,'Университет, корпус А','maintenance','2023-04-05','2026-02-15',4,NULL),(5,'Больница, холл','working','2023-05-12','2026-04-12',2,NULL),(6,'Бизнес-центр Омега','working','2023-06-18','2026-05-18',3,NULL),(7,'Торговый центр Ритейл','broken','2023-07-22','2026-02-10',5,NULL),(8,'Метро станция Центр','broken','2023-08-30','2026-06-30',2,NULL),(9,'Аэропорт, терминал 2','working','2023-09-14','2026-07-14',3,NULL),(10,'Парк культуры','working','2023-10-25','2026-08-25',2,NULL);
/*!40000 ALTER TABLE `vending_maintenance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `verifications`
--

DROP TABLE IF EXISTS `verifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `verifications` (
  `id` int(11) NOT NULL,
  `vending_machine_id` int(11) DEFAULT NULL,
  `verification_date` date DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `interval_months` int(11) DEFAULT NULL,
  `next_verification_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `verifications`
--

LOCK TABLES `verifications` WRITE;
/*!40000 ALTER TABLE `verifications` DISABLE KEYS */;
INSERT INTO `verifications` VALUES (1,1,'2025-01-15',1,12,'2026-01-15'),(2,2,'2025-02-20',1,12,'2026-02-20'),(3,3,'2025-03-10',2,12,'2026-03-10'),(4,4,'2025-04-05',2,12,'2026-04-05'),(5,5,'2025-05-12',1,12,'2026-05-12'),(6,6,'2025-06-18',3,12,'2026-06-18'),(7,7,'2025-07-22',3,12,'2026-07-22'),(8,8,'2025-08-30',2,12,'2026-08-30'),(9,9,'2025-09-14',1,12,'2026-09-14'),(10,10,'2025-10-25',3,12,'2026-10-25');
/*!40000 ALTER TABLE `verifications` 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 2026-02-09 14:38:05
