-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 13, 2026 at 04:07 PM
-- Wersja serwera: 10.4.32-MariaDB
-- Wersja PHP: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `atelier_20260227`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `todo_daily_close`
--

CREATE TABLE `todo_daily_close` (
  `id` int(11) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `day` date NOT NULL,
  `closed_at` datetime NOT NULL DEFAULT current_timestamp(),
  `closed_by_employee_id` int(11) DEFAULT NULL,
  `close_trigger` varchar(64) DEFAULT NULL,
  `generated_skipped` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `todo_daily_close`
--

INSERT INTO `todo_daily_close` (`id`, `shop_id`, `employee_id`, `day`, `closed_at`, `closed_by_employee_id`, `close_trigger`, `generated_skipped`) VALUES
(1, 2, 75, '2026-01-18', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(2, 2, 75, '2026-01-17', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(3, 2, 75, '2026-01-16', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(4, 2, 75, '2026-01-15', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(5, 2, 75, '2026-01-14', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(6, 2, 75, '2026-01-13', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(7, 2, 75, '2026-01-12', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(8, 2, 75, '2026-01-11', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(9, 2, 75, '2026-01-10', '2026-01-19 21:05:02', NULL, 'tasks:list', 1),
(10, 2, 75, '2026-01-09', '2026-01-19 21:05:03', NULL, 'tasks:list', 1),
(11, 2, 75, '2026-01-08', '2026-01-19 21:05:03', NULL, 'tasks:list', 1),
(12, 2, 75, '2026-01-07', '2026-01-19 21:05:03', NULL, 'tasks:list', 1),
(13, 2, 75, '2026-01-06', '2026-01-19 21:05:03', NULL, 'tasks:list', 1),
(14, 2, 75, '2026-01-05', '2026-01-19 21:05:03', NULL, 'tasks:list', 1),
(43, 2, 75, '2026-01-19', '2026-01-20 09:01:17', NULL, 'tasks:list', 1),
(71, 2, 75, '2026-01-20', '2026-01-21 22:27:02', NULL, 'tasks:list', 1),
(211, 2, 75, '2026-01-21', '2026-01-22 08:22:51', NULL, 'tasks:list', 1),
(225, 2, 16, '2026-01-21', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(226, 2, 16, '2026-01-20', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(227, 2, 16, '2026-01-19', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(228, 2, 16, '2026-01-18', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(229, 2, 16, '2026-01-17', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(230, 2, 16, '2026-01-16', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(231, 2, 16, '2026-01-15', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(232, 2, 16, '2026-01-14', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(233, 2, 16, '2026-01-13', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(234, 2, 16, '2026-01-12', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(235, 2, 16, '2026-01-11', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(236, 2, 16, '2026-01-10', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(237, 2, 16, '2026-01-09', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(238, 2, 16, '2026-01-08', '2026-01-22 08:23:07', NULL, 'tasks:list', 1),
(281, 3, 76, '2026-01-21', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(282, 3, 76, '2026-01-20', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(283, 3, 76, '2026-01-19', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(284, 3, 76, '2026-01-18', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(285, 3, 76, '2026-01-17', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(286, 3, 76, '2026-01-16', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(287, 3, 76, '2026-01-15', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(288, 3, 76, '2026-01-14', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(289, 3, 76, '2026-01-13', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(290, 3, 76, '2026-01-12', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(291, 3, 76, '2026-01-11', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(292, 3, 76, '2026-01-10', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(293, 3, 76, '2026-01-09', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(294, 3, 76, '2026-01-08', '2026-01-22 08:23:55', NULL, 'tasks:list', 1),
(561, 4, 90, '2026-01-21', '2026-01-22 13:56:15', NULL, 'tasks:list', 1),
(562, 4, 90, '2026-01-20', '2026-01-22 13:56:15', NULL, 'tasks:list', 1),
(563, 4, 90, '2026-01-19', '2026-01-22 13:56:15', NULL, 'tasks:list', 1),
(564, 4, 90, '2026-01-18', '2026-01-22 13:56:15', NULL, 'tasks:list', 1),
(565, 4, 90, '2026-01-17', '2026-01-22 13:56:15', NULL, 'tasks:list', 1),
(566, 4, 90, '2026-01-16', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(567, 4, 90, '2026-01-15', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(568, 4, 90, '2026-01-14', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(569, 4, 90, '2026-01-13', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(570, 4, 90, '2026-01-12', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(571, 4, 90, '2026-01-11', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(572, 4, 90, '2026-01-10', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(573, 4, 90, '2026-01-09', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(574, 4, 90, '2026-01-08', '2026-01-22 13:56:16', NULL, 'tasks:list', 1),
(1191, 4, 90, '2026-01-22', '2026-01-23 17:20:13', NULL, 'tasks:list', 1),
(1387, 2, 75, '2026-01-22', '2026-01-23 22:39:40', NULL, 'tasks:list', 1),
(1457, 4, 90, '2026-01-26', '2026-01-27 07:02:31', NULL, 'tasks:list', 1),
(1458, 4, 90, '2026-01-25', '2026-01-27 07:02:31', NULL, 'tasks:list', 1),
(1459, 4, 90, '2026-01-24', '2026-01-27 07:02:31', NULL, 'tasks:list', 1),
(1460, 4, 90, '2026-01-23', '2026-01-27 07:02:32', NULL, 'tasks:list', 1),
(1625, 4, 90, '2026-01-27', '2026-01-28 19:00:24', NULL, 'tasks:list', 1),
(1667, 4, 90, '2026-01-28', '2026-01-29 17:32:02', NULL, 'tasks:list', 1),
(1681, 4, 90, '2026-01-29', '2026-01-30 06:21:06', NULL, 'tasks:list', 1),
(1765, 4, 90, '2026-02-05', '2026-02-06 06:33:29', NULL, 'tasks:list', 1),
(1766, 4, 90, '2026-02-04', '2026-02-06 06:33:29', NULL, 'tasks:list', 1),
(1767, 4, 90, '2026-02-03', '2026-02-06 06:33:29', NULL, 'tasks:list', 1),
(1768, 4, 90, '2026-02-02', '2026-02-06 06:33:29', NULL, 'tasks:list', 1),
(1769, 4, 90, '2026-02-01', '2026-02-06 06:33:29', NULL, 'tasks:list', 1),
(1770, 4, 90, '2026-01-31', '2026-02-06 06:33:30', NULL, 'tasks:list', 1),
(1771, 4, 90, '2026-01-30', '2026-02-06 06:33:30', NULL, 'tasks:list', 1),
(1779, 4, 90, '2026-02-11', '2026-02-12 15:28:23', NULL, 'tasks:list', 1),
(1780, 4, 90, '2026-02-10', '2026-02-12 15:28:23', NULL, 'tasks:list', 1),
(1781, 4, 90, '2026-02-09', '2026-02-12 15:28:24', NULL, 'tasks:list', 1),
(1782, 4, 90, '2026-02-08', '2026-02-12 15:28:24', NULL, 'tasks:list', 1),
(1783, 4, 90, '2026-02-07', '2026-02-12 15:28:24', NULL, 'tasks:list', 1),
(1784, 4, 90, '2026-02-06', '2026-02-12 15:28:24', NULL, 'tasks:list', 1),
(1807, 4, 90, '2026-02-15', '2026-02-16 20:03:03', NULL, 'tasks:list', 1),
(1808, 4, 90, '2026-02-14', '2026-02-16 20:03:03', NULL, 'tasks:list', 1),
(1809, 4, 90, '2026-02-13', '2026-02-16 20:03:04', NULL, 'tasks:list', 1),
(1810, 4, 90, '2026-02-12', '2026-02-16 20:03:04', NULL, 'tasks:list', 1),
(1821, 4, 90, '2026-02-19', '2026-02-20 09:22:23', NULL, 'tasks:list', 1),
(1822, 4, 90, '2026-02-18', '2026-02-20 09:22:23', NULL, 'tasks:list', 1),
(1823, 4, 90, '2026-02-17', '2026-02-20 09:22:23', NULL, 'tasks:list', 1),
(1824, 4, 90, '2026-02-16', '2026-02-20 09:22:23', NULL, 'tasks:list', 1),
(1891, 3, 90, '2026-02-22', '2026-02-23 10:12:55', NULL, 'tasks:list', 1),
(1892, 3, 90, '2026-02-21', '2026-02-23 10:12:55', NULL, 'tasks:list', 1),
(1893, 3, 90, '2026-02-20', '2026-02-23 10:12:56', NULL, 'tasks:list', 1),
(2031, 4, 90, '2026-02-24', '2026-02-25 17:06:22', NULL, 'tasks:list', 1),
(2032, 4, 90, '2026-02-23', '2026-02-25 17:06:23', NULL, 'tasks:list', 1);

--
-- Indeksy dla zrzutów tabel
--

--
-- Indeksy dla tabeli `todo_daily_close`
--
ALTER TABLE `todo_daily_close`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_employee_day` (`employee_id`,`day`),
  ADD UNIQUE KEY `uniq_close` (`shop_id`,`employee_id`,`day`),
  ADD KEY `idx_shop_day` (`shop_id`,`day`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `todo_daily_close`
--
ALTER TABLE `todo_daily_close`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2227;
COMMIT;

/*!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 */;
