Database/databaseproject.sql - master - Zeylxxddd/IPUP

Database/databaseproject.sql
503 строки21 KB
Zeylxxddd
update: databaseproject.sql
28 май 2026, 03:18
28 май 2026, 03:181ab2b6c
-- --------------------------------------------------------
-- Хост:                         127.0.0.1
-- Версия сервера:               10.4.32-MariaDB - mariadb.org binary distribution
-- Операционная система:         Win64
-- HeidiSQL Версия:              12.16.0.7229
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;


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

-- Дамп структуры для таблица ipup.hourly_stats
CREATE TABLE IF NOT EXISTS `hourly_stats` (
  `stat_id` int(11) NOT NULL AUTO_INCREMENT,
  `pvz_id` int(11) NOT NULL,
  `stats_date` date NOT NULL,
  `stats_hour` int(11) NOT NULL CHECK (`stats_hour` between 0 and 23),
  `in_ops_count` int(11) NOT NULL DEFAULT 0,
  `out_ops_count` int(11) NOT NULL DEFAULT 0,
  `return_ops_count` int(11) NOT NULL DEFAULT 0,
  `total_ops_count` int(11) GENERATED ALWAYS AS (`in_ops_count` + `out_ops_count` + `return_ops_count`) STORED,
  PRIMARY KEY (`stat_id`),
  UNIQUE KEY `unique_pvz_hour` (`pvz_id`,`stats_date`,`stats_hour`),
  CONSTRAINT `hourly_stats_ibfk_1` FOREIGN KEY (`pvz_id`) REFERENCES `pickup_points` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=421 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Дамп данных таблицы ipup.hourly_stats: ~420 rows (приблизительно)
DELETE FROM `hourly_stats`;
INSERT INTO `hourly_stats` (`stat_id`, `pvz_id`, `stats_date`, `stats_hour`, `in_ops_count`, `out_ops_count`, `return_ops_count`) VALUES
	(1, 1, '2026-04-06', 9, 12, 28, 3),
	(2, 1, '2026-04-06', 10, 15, 32, 2),
	(3, 1, '2026-04-06', 11, 18, 35, 4),
	(4, 1, '2026-04-06', 12, 22, 40, 3),
	(5, 1, '2026-04-06', 13, 20, 38, 2),
	(6, 1, '2026-04-06', 14, 25, 45, 5),
	(7, 1, '2026-04-06', 15, 28, 48, 4),
	(8, 1, '2026-04-06', 16, 30, 52, 6),
	(9, 1, '2026-04-06', 17, 32, 55, 5),
	(10, 1, '2026-04-06', 18, 35, 58, 7),
	(11, 1, '2026-04-06', 19, 28, 50, 4),
	(12, 1, '2026-04-06', 20, 24, 42, 3),
	(13, 1, '2026-04-07', 9, 14, 30, 2),
	(14, 1, '2026-04-07', 10, 16, 34, 3),
	(15, 1, '2026-04-07', 11, 20, 38, 3),
	(16, 1, '2026-04-07', 12, 24, 42, 4),
	(17, 1, '2026-04-07', 13, 22, 40, 3),
	(18, 1, '2026-04-07', 14, 27, 46, 5),
	(19, 1, '2026-04-07', 15, 30, 50, 6),
	(20, 1, '2026-04-07', 16, 33, 54, 5),
	(21, 1, '2026-04-07', 17, 35, 58, 6),
	(22, 1, '2026-04-07', 18, 38, 62, 8),
	(23, 1, '2026-04-07', 19, 30, 52, 5),
	(24, 1, '2026-04-07', 20, 26, 44, 4),
	(25, 1, '2026-04-08', 9, 13, 29, 2),
	(26, 1, '2026-04-08', 10, 17, 35, 3),
	(27, 1, '2026-04-08', 11, 21, 39, 4),
	(28, 1, '2026-04-08', 12, 25, 43, 5),
	(29, 1, '2026-04-08', 13, 23, 41, 3),
	(30, 1, '2026-04-08', 14, 28, 47, 6),
	(31, 1, '2026-04-08', 15, 31, 51, 5),
	(32, 1, '2026-04-08', 16, 34, 55, 7),
	(33, 1, '2026-04-08', 17, 36, 59, 6),
	(34, 1, '2026-04-08', 18, 39, 63, 9),
	(35, 1, '2026-04-08', 19, 31, 53, 5),
	(36, 1, '2026-04-08', 20, 27, 45, 4),
	(37, 1, '2026-04-09', 9, 12, 28, 2),
	(38, 1, '2026-04-09', 10, 15, 33, 3),
	(39, 1, '2026-04-09', 11, 19, 37, 4),
	(40, 1, '2026-04-09', 12, 23, 41, 3),
	(41, 1, '2026-04-09', 13, 21, 39, 2),
	(42, 1, '2026-04-09', 14, 26, 45, 5),
	(43, 1, '2026-04-09', 15, 29, 49, 6),
	(44, 1, '2026-04-09', 16, 32, 53, 5),
	(45, 1, '2026-04-09', 17, 34, 57, 6),
	(46, 1, '2026-04-09', 18, 37, 61, 8),
	(47, 1, '2026-04-09', 19, 29, 51, 4),
	(48, 1, '2026-04-09', 20, 25, 43, 3),
	(49, 1, '2026-04-10', 9, 14, 31, 3),
	(50, 1, '2026-04-10', 10, 17, 36, 4),
	(51, 1, '2026-04-10', 11, 22, 40, 5),
	(52, 1, '2026-04-10', 12, 26, 44, 5),
	(53, 1, '2026-04-10', 13, 24, 42, 4),
	(54, 1, '2026-04-10', 14, 29, 48, 7),
	(55, 1, '2026-04-10', 15, 32, 52, 6),
	(56, 1, '2026-04-10', 16, 35, 56, 7),
	(57, 1, '2026-04-10', 17, 37, 60, 8),
	(58, 1, '2026-04-10', 18, 40, 64, 9),
	(59, 1, '2026-04-10', 19, 32, 54, 6),
	(60, 1, '2026-04-10', 20, 28, 46, 4),
	(61, 1, '2026-04-11', 9, 10, 26, 2),
	(62, 1, '2026-04-11', 10, 13, 30, 3),
	(63, 1, '2026-04-11', 11, 16, 34, 3),
	(64, 1, '2026-04-11', 12, 20, 38, 4),
	(65, 1, '2026-04-11', 13, 18, 36, 2),
	(66, 1, '2026-04-11', 14, 22, 42, 5),
	(67, 1, '2026-04-11', 15, 25, 45, 4),
	(68, 1, '2026-04-11', 16, 28, 48, 6),
	(69, 1, '2026-04-11', 17, 30, 51, 5),
	(70, 1, '2026-04-11', 18, 33, 54, 7),
	(71, 1, '2026-04-11', 19, 26, 44, 4),
	(72, 1, '2026-04-11', 20, 22, 38, 3),
	(73, 1, '2026-04-12', 9, 9, 24, 2),
	(74, 1, '2026-04-12', 10, 12, 28, 2),
	(75, 1, '2026-04-12', 11, 15, 32, 3),
	(76, 1, '2026-04-12', 12, 18, 36, 3),
	(77, 1, '2026-04-12', 13, 16, 34, 2),
	(78, 1, '2026-04-12', 14, 20, 40, 4),
	(79, 1, '2026-04-12', 15, 23, 43, 4),
	(80, 1, '2026-04-12', 16, 26, 46, 5),
	(81, 1, '2026-04-12', 17, 28, 48, 5),
	(82, 1, '2026-04-12', 18, 31, 51, 6),
	(83, 1, '2026-04-12', 19, 24, 40, 3),
	(84, 1, '2026-04-12', 20, 20, 36, 2),
	(85, 2, '2026-04-06', 9, 10, 24, 2),
	(86, 2, '2026-04-06', 10, 13, 27, 3),
	(87, 2, '2026-04-06', 11, 16, 30, 3),
	(88, 2, '2026-04-06', 12, 19, 34, 4),
	(89, 2, '2026-04-06', 13, 18, 32, 2),
	(90, 2, '2026-04-06', 14, 22, 38, 5),
	(91, 2, '2026-04-06', 15, 24, 40, 4),
	(92, 2, '2026-04-06', 16, 27, 43, 6),
	(93, 2, '2026-04-06', 17, 29, 46, 5),
	(94, 2, '2026-04-06', 18, 32, 49, 7),
	(95, 2, '2026-04-06', 19, 26, 42, 4),
	(96, 2, '2026-04-06', 20, 22, 37, 3),
	(97, 2, '2026-04-07', 9, 12, 26, 2),
	(98, 2, '2026-04-07', 10, 14, 29, 3),
	(99, 2, '2026-04-07', 11, 17, 33, 4),
	(100, 2, '2026-04-07', 12, 20, 37, 4),
	(101, 2, '2026-04-07', 13, 19, 35, 3),
	(102, 2, '2026-04-07', 14, 23, 41, 5),
	(103, 2, '2026-04-07', 15, 25, 43, 5),
	(104, 2, '2026-04-07', 16, 28, 46, 6),
	(105, 2, '2026-04-07', 17, 30, 49, 6),
	(106, 2, '2026-04-07', 18, 33, 52, 8),
	(107, 2, '2026-04-07', 19, 27, 44, 4),
	(108, 2, '2026-04-07', 20, 23, 39, 3),
	(109, 2, '2026-04-08', 9, 11, 25, 2),
	(110, 2, '2026-04-08', 10, 14, 28, 3),
	(111, 2, '2026-04-08', 11, 18, 32, 4),
	(112, 2, '2026-04-08', 12, 21, 36, 4),
	(113, 2, '2026-04-08', 13, 20, 34, 3),
	(114, 2, '2026-04-08', 14, 24, 40, 6),
	(115, 2, '2026-04-08', 15, 26, 42, 5),
	(116, 2, '2026-04-08', 16, 29, 45, 7),
	(117, 2, '2026-04-08', 17, 31, 48, 6),
	(118, 2, '2026-04-08', 18, 34, 51, 8),
	(119, 2, '2026-04-08', 19, 28, 43, 5),
	(120, 2, '2026-04-08', 20, 24, 38, 4),
	(121, 2, '2026-04-09', 9, 12, 27, 2),
	(122, 2, '2026-04-09', 10, 15, 30, 3),
	(123, 2, '2026-04-09', 11, 19, 34, 5),
	(124, 2, '2026-04-09', 12, 22, 38, 5),
	(125, 2, '2026-04-09', 13, 21, 36, 4),
	(126, 2, '2026-04-09', 14, 25, 42, 7),
	(127, 2, '2026-04-09', 15, 27, 44, 6),
	(128, 2, '2026-04-09', 16, 30, 47, 7),
	(129, 2, '2026-04-09', 17, 32, 50, 7),
	(130, 2, '2026-04-09', 18, 35, 53, 9),
	(131, 2, '2026-04-09', 19, 29, 45, 5),
	(132, 2, '2026-04-09', 20, 25, 40, 4),
	(133, 2, '2026-04-10', 9, 14, 29, 3),
	(134, 2, '2026-04-10', 10, 17, 32, 4),
	(135, 2, '2026-04-10', 11, 20, 36, 5),
	(136, 2, '2026-04-10', 12, 23, 40, 6),
	(137, 2, '2026-04-10', 13, 22, 38, 4),
	(138, 2, '2026-04-10', 14, 26, 44, 7),
	(139, 2, '2026-04-10', 15, 28, 46, 6),
	(140, 2, '2026-04-10', 16, 31, 49, 8),
	(141, 2, '2026-04-10', 17, 33, 52, 7),
	(142, 2, '2026-04-10', 18, 36, 55, 9),
	(143, 2, '2026-04-10', 19, 30, 47, 6),
	(144, 2, '2026-04-10', 20, 26, 42, 5),
	(145, 2, '2026-04-11', 9, 10, 23, 2),
	(146, 2, '2026-04-11', 10, 13, 26, 2),
	(147, 2, '2026-04-11', 11, 16, 30, 4),
	(148, 2, '2026-04-11', 12, 19, 33, 4),
	(149, 2, '2026-04-11', 13, 18, 31, 3),
	(150, 2, '2026-04-11', 14, 22, 37, 5),
	(151, 2, '2026-04-11', 15, 24, 39, 5),
	(152, 2, '2026-04-11', 16, 27, 42, 6),
	(153, 2, '2026-04-11', 17, 29, 44, 6),
	(154, 2, '2026-04-11', 18, 32, 47, 7),
	(155, 2, '2026-04-11', 19, 26, 40, 4),
	(156, 2, '2026-04-11', 20, 22, 36, 3),
	(157, 2, '2026-04-12', 9, 9, 21, 1),
	(158, 2, '2026-04-12', 10, 12, 24, 2),
	(159, 2, '2026-04-12', 11, 15, 27, 3),
	(160, 2, '2026-04-12', 12, 18, 30, 3),
	(161, 2, '2026-04-12', 13, 17, 29, 2),
	(162, 2, '2026-04-12', 14, 21, 35, 4),
	(163, 2, '2026-04-12', 15, 23, 37, 4),
	(164, 2, '2026-04-12', 16, 26, 40, 5),
	(165, 2, '2026-04-12', 17, 28, 42, 5),
	(166, 2, '2026-04-12', 18, 31, 45, 6),
	(167, 2, '2026-04-12', 19, 25, 38, 3),
	(168, 2, '2026-04-12', 20, 21, 34, 2),
	(169, 3, '2026-04-06', 9, 8, 20, 2),
	(170, 3, '2026-04-06', 10, 10, 22, 2),
	(171, 3, '2026-04-06', 11, 13, 25, 3),
	(172, 3, '2026-04-06', 12, 16, 28, 3),
	(173, 3, '2026-04-06', 13, 15, 27, 2),
	(174, 3, '2026-04-06', 14, 18, 30, 4),
	(175, 3, '2026-04-06', 15, 20, 33, 4),
	(176, 3, '2026-04-06', 16, 22, 35, 5),
	(177, 3, '2026-04-06', 17, 24, 37, 5),
	(178, 3, '2026-04-06', 18, 27, 40, 6),
	(179, 3, '2026-04-06', 19, 22, 34, 4),
	(180, 3, '2026-04-06', 20, 18, 30, 3),
	(181, 3, '2026-04-07', 9, 9, 21, 2),
	(182, 3, '2026-04-07', 10, 11, 23, 3),
	(183, 3, '2026-04-07', 11, 14, 26, 3),
	(184, 3, '2026-04-07', 12, 17, 29, 4),
	(185, 3, '2026-04-07', 13, 16, 28, 3),
	(186, 3, '2026-04-07', 14, 19, 32, 5),
	(187, 3, '2026-04-07', 15, 21, 34, 5),
	(188, 3, '2026-04-07', 16, 23, 37, 6),
	(189, 3, '2026-04-07', 17, 25, 39, 6),
	(190, 3, '2026-04-07', 18, 28, 42, 7),
	(191, 3, '2026-04-07', 19, 23, 35, 4),
	(192, 3, '2026-04-07', 20, 19, 31, 3),
	(193, 3, '2026-04-08', 9, 10, 22, 2),
	(194, 3, '2026-04-08', 10, 12, 24, 3),
	(195, 3, '2026-04-08', 11, 15, 27, 4),
	(196, 3, '2026-04-08', 12, 18, 30, 4),
	(197, 3, '2026-04-08', 13, 17, 29, 3),
	(198, 3, '2026-04-08', 14, 20, 33, 5),
	(199, 3, '2026-04-08', 15, 22, 35, 5),
	(200, 3, '2026-04-08', 16, 25, 38, 6),
	(201, 3, '2026-04-08', 17, 27, 41, 7),
	(202, 3, '2026-04-08', 18, 30, 60, 5),
	(203, 3, '2026-04-08', 19, 24, 36, 4),
	(204, 3, '2026-04-08', 20, 20, 32, 3),
	(205, 3, '2026-04-09', 9, 9, 20, 2),
	(206, 3, '2026-04-09', 10, 11, 22, 2),
	(207, 3, '2026-04-09', 11, 14, 25, 3),
	(208, 3, '2026-04-09', 12, 17, 28, 4),
	(209, 3, '2026-04-09', 13, 16, 27, 3),
	(210, 3, '2026-04-09', 14, 19, 31, 5),
	(211, 3, '2026-04-09', 15, 21, 33, 5),
	(212, 3, '2026-04-09', 16, 24, 36, 6),
	(213, 3, '2026-04-09', 17, 26, 38, 6),
	(214, 3, '2026-04-09', 18, 29, 41, 7),
	(215, 3, '2026-04-09', 19, 23, 34, 4),
	(216, 3, '2026-04-09', 20, 19, 30, 3),
	(217, 3, '2026-04-10', 9, 10, 22, 2),
	(218, 3, '2026-04-10', 10, 12, 25, 3),
	(219, 3, '2026-04-10', 11, 15, 28, 4),
	(220, 3, '2026-04-10', 12, 18, 31, 4),
	(221, 3, '2026-04-10', 13, 17, 30, 3),
	(222, 3, '2026-04-10', 14, 20, 34, 5),
	(223, 3, '2026-04-10', 15, 22, 36, 5),
	(224, 3, '2026-04-10', 16, 25, 39, 6),
	(225, 3, '2026-04-10', 17, 27, 41, 6),
	(226, 3, '2026-04-10', 18, 30, 44, 7),
	(227, 3, '2026-04-10', 19, 24, 37, 4),
	(228, 3, '2026-04-10', 20, 20, 33, 3),
	(229, 3, '2026-04-11', 9, 8, 18, 2),
	(230, 3, '2026-04-11', 10, 10, 21, 2),
	(231, 3, '2026-04-11', 11, 13, 24, 3),
	(232, 3, '2026-04-11', 12, 16, 27, 3),
	(233, 3, '2026-04-11', 13, 15, 26, 2),
	(234, 3, '2026-04-11', 14, 18, 30, 4),
	(235, 3, '2026-04-11', 15, 20, 32, 4),
	(236, 3, '2026-04-11', 16, 22, 35, 5),
	(237, 3, '2026-04-11', 17, 24, 37, 5),
	(238, 3, '2026-04-11', 18, 27, 40, 6),
	(239, 3, '2026-04-11', 19, 22, 33, 4),
	(240, 3, '2026-04-11', 20, 18, 29, 3),
	(241, 3, '2026-04-12', 9, 7, 17, 1),
	(242, 3, '2026-04-12', 10, 9, 20, 2),
	(243, 3, '2026-04-12', 11, 12, 23, 2),
	(244, 3, '2026-04-12', 12, 15, 25, 3),
	(245, 3, '2026-04-12', 13, 14, 24, 2),
	(246, 3, '2026-04-12', 14, 17, 28, 4),
	(247, 3, '2026-04-12', 15, 19, 30, 4),
	(248, 3, '2026-04-12', 16, 21, 33, 5),
	(249, 3, '2026-04-12', 17, 23, 35, 5),
	(250, 3, '2026-04-12', 18, 26, 38, 6),
	(251, 3, '2026-04-12', 19, 21, 32, 3),
	(252, 3, '2026-04-12', 20, 17, 28, 2),
	(253, 4, '2026-04-06', 9, 11, 26, 2),
	(254, 4, '2026-04-06', 10, 14, 30, 3),
	(255, 4, '2026-04-06', 11, 17, 34, 4),
	(256, 4, '2026-04-06', 12, 21, 38, 4),
	(257, 4, '2026-04-06', 13, 19, 36, 3),
	(258, 4, '2026-04-06', 14, 24, 42, 6),
	(259, 4, '2026-04-06', 15, 27, 45, 5),
	(260, 4, '2026-04-06', 16, 29, 48, 7),
	(261, 4, '2026-04-06', 17, 32, 51, 6),
	(262, 4, '2026-04-06', 18, 35, 54, 8),
	(263, 4, '2026-04-06', 19, 28, 46, 5),
	(264, 4, '2026-04-06', 20, 24, 40, 4),
	(265, 4, '2026-04-07', 9, 12, 28, 3),
	(266, 4, '2026-04-07', 10, 15, 32, 3),
	(267, 4, '2026-04-07', 11, 18, 36, 5),
	(268, 4, '2026-04-07', 12, 22, 40, 5),
	(269, 4, '2026-04-07', 13, 21, 38, 4),
	(270, 4, '2026-04-07', 14, 25, 44, 7),
	(271, 4, '2026-04-07', 15, 28, 47, 6),
	(272, 4, '2026-04-07', 16, 30, 50, 7),
	(273, 4, '2026-04-07', 17, 33, 53, 7),
	(274, 4, '2026-04-07', 18, 36, 56, 9),
	(275, 4, '2026-04-07', 19, 29, 48, 6),
	(276, 4, '2026-04-07', 20, 25, 42, 4),
	(277, 4, '2026-04-08', 9, 10, 25, 2),
	(278, 4, '2026-04-08', 10, 13, 29, 3),
	(279, 4, '2026-04-08', 11, 16, 33, 4),
	(280, 4, '2026-04-08', 12, 20, 37, 4),
	(281, 4, '2026-04-08', 13, 18, 35, 3),
	(282, 4, '2026-04-08', 14, 22, 41, 6),
	(283, 4, '2026-04-08', 15, 25, 44, 5),
	(284, 4, '2026-04-08', 16, 27, 47, 6),
	(285, 4, '2026-04-08', 17, 30, 50, 6),
	(286, 4, '2026-04-08', 18, 33, 53, 8),
	(287, 4, '2026-04-08', 19, 26, 45, 5),
	(288, 4, '2026-04-08', 20, 22, 39, 4),
	(289, 4, '2026-04-09', 9, 13, 29, 3),
	(290, 4, '2026-04-09', 10, 16, 33, 4),
	(291, 4, '2026-04-09', 11, 19, 37, 5),
	(292, 4, '2026-04-09', 12, 23, 41, 6),
	(293, 4, '2026-04-09', 13, 21, 39, 4),
	(294, 4, '2026-04-09', 14, 26, 45, 7),
	(295, 4, '2026-04-09', 15, 29, 48, 7),
	(296, 4, '2026-04-09', 16, 31, 51, 8),
	(297, 4, '2026-04-09', 17, 34, 54, 8),
	(298, 4, '2026-04-09', 18, 37, 57, 10),
	(299, 4, '2026-04-09', 19, 30, 49, 6),
	(300, 4, '2026-04-09', 20, 26, 43, 5),
	(301, 4, '2026-04-10', 9, 14, 30, 3),
	(302, 4, '2026-04-10', 10, 17, 34, 4),
	(303, 4, '2026-04-10', 11, 20, 38, 6),
	(304, 4, '2026-04-10', 12, 24, 42, 6),
	(305, 4, '2026-04-10', 13, 22, 40, 5),
	(306, 4, '2026-04-10', 14, 27, 46, 8),
	(307, 4, '2026-04-10', 15, 30, 49, 7),
	(308, 4, '2026-04-10', 16, 32, 52, 8),
	(309, 4, '2026-04-10', 17, 35, 55, 8),
	(310, 4, '2026-04-10', 18, 38, 58, 10),
	(311, 4, '2026-04-10', 19, 31, 50, 7),
	(312, 4, '2026-04-10', 20, 27, 44, 5),
	(313, 4, '2026-04-11', 9, 10, 24, 2),
	(314, 4, '2026-04-11', 10, 13, 28, 3),
	(315, 4, '2026-04-11', 11, 16, 32, 4),
	(316, 4, '2026-04-11', 12, 20, 36, 4),
	(317, 4, '2026-04-11', 13, 18, 34, 3),
	(318, 4, '2026-04-11', 14, 22, 40, 6),
	(319, 4, '2026-04-11', 15, 25, 43, 5),
	(320, 4, '2026-04-11', 16, 27, 46, 6),
	(321, 4, '2026-04-11', 17, 30, 49, 6),
	(322, 4, '2026-04-11', 18, 33, 52, 8),
	(323, 4, '2026-04-11', 19, 26, 44, 5),
	(324, 4, '2026-04-11', 20, 22, 38, 4),
	(325, 4, '2026-04-12', 9, 9, 22, 2),
	(326, 4, '2026-04-12', 10, 12, 26, 2),
	(327, 4, '2026-04-12', 11, 15, 30, 3),
	(328, 4, '2026-04-12', 12, 18, 34, 4),
	(329, 4, '2026-04-12', 13, 17, 32, 3),
	(330, 4, '2026-04-12', 14, 21, 38, 5),
	(331, 4, '2026-04-12', 15, 23, 41, 5),
	(332, 4, '2026-04-12', 16, 26, 44, 6),
	(333, 4, '2026-04-12', 17, 28, 47, 6),
	(334, 4, '2026-04-12', 18, 31, 50, 7),
	(335, 4, '2026-04-12', 19, 24, 42, 4),
	(336, 4, '2026-04-12', 20, 20, 36, 3),
	(337, 5, '2026-04-06', 9, 9, 22, 2),
	(338, 5, '2026-04-06', 10, 11, 24, 2),
	(339, 5, '2026-04-06', 11, 14, 27, 3),
	(340, 5, '2026-04-06', 12, 17, 30, 4),
	(341, 5, '2026-04-06', 13, 15, 28, 3),
	(342, 5, '2026-04-06', 14, 19, 33, 5),
	(343, 5, '2026-04-06', 15, 21, 35, 5),
	(344, 5, '2026-04-06', 16, 24, 38, 6),
	(345, 5, '2026-04-06', 17, 26, 40, 6),
	(346, 5, '2026-04-06', 18, 29, 43, 7),
	(347, 5, '2026-04-06', 19, 23, 36, 4),
	(348, 5, '2026-04-06', 20, 19, 32, 3),
	(349, 5, '2026-04-07', 9, 10, 23, 2),
	(350, 5, '2026-04-07', 10, 12, 25, 3),
	(351, 5, '2026-04-07', 11, 15, 28, 4),
	(352, 5, '2026-04-07', 12, 18, 31, 4),
	(353, 5, '2026-04-07', 13, 16, 29, 3),
	(354, 5, '2026-04-07', 14, 20, 34, 6),
	(355, 5, '2026-04-07', 15, 22, 36, 5),
	(356, 5, '2026-04-07', 16, 25, 39, 7),
	(357, 5, '2026-04-07', 17, 27, 41, 7),
	(358, 5, '2026-04-07', 18, 30, 44, 8),
	(359, 5, '2026-04-07', 19, 24, 37, 5),
	(360, 5, '2026-04-07', 20, 20, 33, 4),
	(361, 5, '2026-04-08', 9, 9, 21, 2),
	(362, 5, '2026-04-08', 10, 11, 23, 2),
	(363, 5, '2026-04-08', 11, 14, 26, 3),
	(364, 5, '2026-04-08', 12, 17, 29, 4),
	(365, 5, '2026-04-08', 13, 15, 27, 3),
	(366, 5, '2026-04-08', 14, 19, 32, 5),
	(367, 5, '2026-04-08', 15, 21, 34, 5),
	(368, 5, '2026-04-08', 16, 24, 37, 6),
	(369, 5, '2026-04-08', 17, 26, 39, 6),
	(370, 5, '2026-04-08', 18, 29, 42, 7),
	(371, 5, '2026-04-08', 19, 23, 35, 4),
	(372, 5, '2026-04-08', 20, 19, 31, 3),
	(373, 5, '2026-04-09', 9, 10, 24, 2),
	(374, 5, '2026-04-09', 10, 12, 26, 3),
	(375, 5, '2026-04-09', 11, 15, 29, 4),
	(376, 5, '2026-04-09', 12, 18, 32, 5),
	(377, 5, '2026-04-09', 13, 16, 30, 3),
	(378, 5, '2026-04-09', 14, 20, 35, 6),
	(379, 5, '2026-04-09', 15, 22, 37, 5),
	(380, 5, '2026-04-09', 16, 25, 40, 7),
	(381, 5, '2026-04-09', 17, 27, 42, 7),
	(382, 5, '2026-04-09', 18, 30, 45, 8),
	(383, 5, '2026-04-09', 19, 24, 38, 5),
	(384, 5, '2026-04-09', 20, 20, 34, 4),
	(385, 5, '2026-04-10', 9, 11, 25, 3),
	(386, 5, '2026-04-10', 10, 13, 27, 3),
	(387, 5, '2026-04-10', 11, 16, 30, 5),
	(388, 5, '2026-04-10', 12, 19, 33, 5),
	(389, 5, '2026-04-10', 13, 17, 31, 4),
	(390, 5, '2026-04-10', 14, 21, 36, 7),
	(391, 5, '2026-04-10', 15, 23, 38, 6),
	(392, 5, '2026-04-10', 16, 26, 41, 8),
	(393, 5, '2026-04-10', 17, 28, 43, 8),
	(394, 5, '2026-04-10', 18, 31, 46, 9),
	(395, 5, '2026-04-10', 19, 25, 39, 6),
	(396, 5, '2026-04-10', 20, 21, 35, 5),
	(397, 5, '2026-04-11', 9, 9, 21, 2),
	(398, 5, '2026-04-11', 10, 11, 23, 3),
	(399, 5, '2026-04-11', 11, 14, 26, 3),
	(400, 5, '2026-04-11', 12, 17, 29, 4),
	(401, 5, '2026-04-11', 13, 15, 27, 3),
	(402, 5, '2026-04-11', 14, 19, 32, 5),
	(403, 5, '2026-04-11', 15, 21, 34, 5),
	(404, 5, '2026-04-11', 16, 24, 37, 6),
	(405, 5, '2026-04-11', 17, 26, 39, 6),
	(406, 5, '2026-04-11', 18, 29, 42, 7),
	(407, 5, '2026-04-11', 19, 30, 65, 7),
	(408, 5, '2026-04-11', 20, 22, 36, 4),
	(409, 5, '2026-04-12', 9, 8, 20, 1),
	(410, 5, '2026-04-12', 10, 10, 22, 2),
	(411, 5, '2026-04-12', 11, 13, 25, 3),
	(412, 5, '2026-04-12', 12, 16, 28, 3),
	(413, 5, '2026-04-12', 13, 14, 26, 2),
	(414, 5, '2026-04-12', 14, 18, 31, 5),
	(415, 5, '2026-04-12', 15, 20, 33, 4),
	(416, 5, '2026-04-12', 16, 23, 36, 5),
	(417, 5, '2026-04-12', 17, 25, 38, 5),
	(418, 5, '2026-04-12', 18, 28, 41, 6),
	(419, 5, '2026-04-12', 19, 22, 34, 4),
	(420, 5, '2026-04-12', 20, 18, 30, 3);

-- Дамп структуры для таблица ipup.pickup_points
CREATE TABLE IF NOT EXISTS `pickup_points` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) NOT NULL,
  `open_time` time NOT NULL,
  `close_time` time NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `capacity_per_hour` int(11) NOT NULL DEFAULT 100,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Дамп данных таблицы ipup.pickup_points: ~5 rows (приблизительно)
DELETE FROM `pickup_points`;
INSERT INTO `pickup_points` (`id`, `address`, `open_time`, `close_time`, `latitude`, `longitude`, `capacity_per_hour`) VALUES
	(1, 'Большая Пироговская улица, 37-43кА', '09:00:00', '21:00:00', 55.72875300, 37.56454500, 120),
	(2, 'Авиамоторная улица, 49/1', '09:00:00', '21:00:00', 55.74852300, 37.71997100, 100),
	(3, 'Большая Грузинская улица, 36с3', '09:00:00', '21:00:00', 55.76772200, 37.58016700, 80),
	(4, 'Коломенская улица, 23к2', '09:00:00', '21:00:00', 55.67658500, 37.69239300, 110),
	(5, 'улица Кравченко, 4к1', '09:00:00', '21:00:00', 55.67522000, 37.52162300, 90);

-- Дамп структуры для таблица ipup.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username_UNIQUE` (`username`),
  UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Дамп данных таблицы ipup.users: ~2 rows (приблизительно)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `username`, `email`, `password`) VALUES
	(1, '123123', 'pokatelka2@gmail.com', '$2b$10$Am1lQwYfh9kHVHCoTe2JWe9OcYnFNDuwZ.yyGTMxIJxfry7sPP8Ue'),
	(2, 'admin', 'admin@yandex.ru', '$2b$10$wKRo0/05XWpVC6LZJYQwreMA97wSC805w.b4u54WhLcEyO4Pa0zRO');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!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) */;