-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `restoran`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `order` int(11) DEFAULT 0,
  `status` enum('active','passive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `order`, `status`, `created_at`) VALUES
(1, 'Ana Yemekler', 1, 'active', '2025-04-06 17:23:23'),
(4, 'İçecekler', 3, 'active', '2025-04-06 17:23:23'),
(6, 'Sanatçı', 4, 'active', '2025-04-06 17:44:00'),
(7, 'Eğlence', 5, 'active', '2025-04-06 17:44:08'),
(9, 'Mezeler', 6, 'active', '2025-04-06 17:50:40');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `table_id` int(11) NOT NULL,
  `status` enum('beklemede','hazirlaniyor','tamamlandi','iptal') NOT NULL DEFAULT 'beklemede',
  `total_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `completed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `table_id`, `status`, `total_amount`, `created_at`, `completed_at`) VALUES
(10, 1, 'iptal', 1679.00, '2025-04-06 17:40:28', '2025-04-06 17:41:33'),
(11, 1, 'tamamlandi', 16500.00, '2025-04-06 17:49:33', '2025-04-06 18:02:52'),
(12, 2, 'iptal', 18000.00, '2025-04-06 17:49:49', '2025-04-06 18:02:58'),
(13, 3, 'iptal', 1500.00, '2025-04-06 17:51:07', '2025-04-06 18:03:01'),
(14, 4, 'iptal', 24500.00, '2025-04-06 17:54:48', '2025-04-06 17:54:54'),
(15, 6, 'iptal', 13500.00, '2025-04-06 17:56:37', '2025-04-06 18:02:50'),
(16, 6, 'iptal', 20000.00, '2025-04-06 18:03:41', '2025-04-06 18:04:12'),
(17, 7, 'tamamlandi', 1500.00, '2025-04-06 18:03:55', '2025-04-06 19:06:07'),
(18, 8, 'iptal', 10500.00, '2025-04-06 18:04:00', '2025-04-07 06:26:59'),
(19, 6, 'tamamlandi', 2000.00, '2025-04-06 18:40:49', '2025-04-06 18:42:00'),
(20, 1, 'iptal', 1500.00, '2025-04-06 18:41:14', '2025-04-07 06:27:09'),
(21, 6, 'iptal', 245650.00, '2025-04-06 18:55:35', '2025-04-06 18:56:07'),
(22, 6, 'iptal', 54000.00, '2025-04-06 19:06:16', '2025-04-07 06:27:02'),
(23, 7, 'iptal', 5000.00, '2025-04-06 19:28:50', '2025-04-07 06:26:55'),
(24, 6, 'iptal', 3000.00, '2025-04-10 17:40:16', '2025-04-10 17:41:04'),
(25, 6, 'iptal', 21000.00, '2025-04-14 10:30:02', '2025-04-14 10:30:49'),
(26, 6, 'iptal', 9250.00, '2025-04-14 10:50:56', '2025-04-14 12:07:50'),
(27, 8, 'beklemede', 18000.00, '2025-04-14 10:51:05', NULL),
(29, 6, 'iptal', 8750.00, '2025-04-14 12:07:53', '2025-04-14 12:08:10');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` decimal(10,2) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `total_price`, `created_at`) VALUES
(79, 11, 13, 1, 10000.00, 10000.00, '2025-04-06 17:49:33'),
(80, 11, 11, 1, 1500.00, 1500.00, '2025-04-06 17:49:33'),
(81, 11, 12, 1, 5000.00, 5000.00, '2025-04-06 17:49:34'),
(82, 12, 11, 1, 1500.00, 1500.00, '2025-04-06 17:49:49'),
(83, 12, 13, 1, 10000.00, 10000.00, '2025-04-06 17:49:50'),
(84, 12, 12, 1, 5000.00, 5000.00, '2025-04-06 17:49:50'),
(85, 12, 11, 1, 1500.00, 1500.00, '2025-04-06 17:49:50'),
(86, 13, 14, 1, 500.00, 500.00, '2025-04-06 17:51:07'),
(87, 13, 15, 1, 500.00, 500.00, '2025-04-06 17:51:08'),
(88, 13, 14, 1, 500.00, 500.00, '2025-04-06 17:51:08'),
(89, 14, 11, 1, 1500.00, 1500.00, '2025-04-06 17:54:48'),
(90, 14, 12, 1, 5000.00, 5000.00, '2025-04-06 17:54:48'),
(91, 14, 13, 1, 10000.00, 10000.00, '2025-04-06 17:54:49'),
(92, 14, 11, 1, 1500.00, 1500.00, '2025-04-06 17:54:49'),
(93, 14, 12, 1, 5000.00, 5000.00, '2025-04-06 17:54:49'),
(94, 14, 11, 1, 1500.00, 1500.00, '2025-04-06 17:54:49'),
(95, 15, 16, 1, 1000.00, 1000.00, '2025-04-06 17:56:37'),
(96, 15, 17, 1, 1500.00, 1500.00, '2025-04-06 17:56:38'),
(97, 15, 13, 1, 10000.00, 10000.00, '2025-04-06 17:56:41'),
(98, 15, 15, 1, 500.00, 500.00, '2025-04-06 17:56:44'),
(99, 15, 14, 1, 500.00, 500.00, '2025-04-06 17:56:44'),
(100, 16, 13, 1, 10000.00, 10000.00, '2025-04-06 18:03:41'),
(101, 16, 11, 1, 1500.00, 1500.00, '2025-04-06 18:03:42'),
(102, 16, 12, 1, 5000.00, 5000.00, '2025-04-06 18:03:42'),
(103, 16, 17, 1, 1500.00, 1500.00, '2025-04-06 18:03:45'),
(104, 16, 16, 1, 1000.00, 1000.00, '2025-04-06 18:03:46'),
(105, 16, 15, 1, 500.00, 500.00, '2025-04-06 18:03:49'),
(106, 16, 14, 1, 500.00, 500.00, '2025-04-06 18:03:49'),
(107, 17, 14, 1, 500.00, 500.00, '2025-04-06 18:03:55'),
(108, 17, 15, 1, 500.00, 500.00, '2025-04-06 18:03:55'),
(109, 17, 14, 1, 500.00, 500.00, '2025-04-06 18:03:56'),
(110, 18, 15, 1, 500.00, 500.00, '2025-04-06 18:04:00'),
(111, 18, 14, 1, 500.00, 500.00, '2025-04-06 18:04:01'),
(112, 18, 15, 1, 500.00, 500.00, '2025-04-06 18:04:01'),
(113, 18, 16, 1, 1000.00, 1000.00, '2025-04-06 18:04:03'),
(114, 18, 17, 1, 1500.00, 1500.00, '2025-04-06 18:04:03'),
(115, 18, 11, 1, 1500.00, 1500.00, '2025-04-06 18:04:04'),
(116, 18, 12, 1, 5000.00, 5000.00, '2025-04-06 18:04:05'),
(117, 19, 15, 1, 500.00, 500.00, '2025-04-06 18:40:49'),
(118, 19, 14, 1, 500.00, 500.00, '2025-04-06 18:40:49'),
(119, 19, 15, 1, 500.00, 500.00, '2025-04-06 18:40:49'),
(120, 19, 14, 1, 500.00, 500.00, '2025-04-06 18:40:50'),
(121, 20, 11, 1, 1500.00, 1500.00, '2025-04-06 18:41:14'),
(122, 21, 26, 1, 450.00, 450.00, '2025-04-06 18:55:35'),
(123, 21, 25, 1, 450.00, 450.00, '2025-04-06 18:55:35'),
(124, 21, 23, 1, 5000.00, 5000.00, '2025-04-06 18:55:38'),
(125, 21, 22, 1, 2000.00, 2000.00, '2025-04-06 18:55:38'),
(126, 21, 12, 1, 5000.00, 5000.00, '2025-04-06 18:55:39'),
(127, 21, 11, 1, 1500.00, 1500.00, '2025-04-06 18:55:39'),
(128, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:40'),
(129, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:41'),
(130, 21, 20, 1, 2000.00, 2000.00, '2025-04-06 18:55:41'),
(131, 21, 18, 1, 750.00, 750.00, '2025-04-06 18:55:41'),
(132, 21, 11, 1, 1500.00, 1500.00, '2025-04-06 18:55:42'),
(133, 21, 21, 1, 1000.00, 1000.00, '2025-04-06 18:55:42'),
(134, 21, 22, 1, 2000.00, 2000.00, '2025-04-06 18:55:42'),
(135, 21, 12, 1, 5000.00, 5000.00, '2025-04-06 18:55:42'),
(136, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:43'),
(137, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:43'),
(138, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:43'),
(139, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:44'),
(140, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:44'),
(141, 21, 16, 1, 1000.00, 1000.00, '2025-04-06 18:55:44'),
(142, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:44'),
(143, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:44'),
(144, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:44'),
(145, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(146, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(147, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(148, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(149, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(150, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(151, 21, 17, 1, 1500.00, 1500.00, '2025-04-06 18:55:45'),
(152, 21, 15, 1, 500.00, 500.00, '2025-04-06 18:55:49'),
(153, 21, 15, 1, 500.00, 500.00, '2025-04-06 18:55:49'),
(154, 21, 15, 1, 500.00, 500.00, '2025-04-06 18:55:49'),
(155, 21, 14, 1, 500.00, 500.00, '2025-04-06 18:55:50'),
(156, 21, 14, 1, 500.00, 500.00, '2025-04-06 18:55:50'),
(157, 21, 14, 1, 500.00, 500.00, '2025-04-06 18:55:50'),
(158, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:52'),
(159, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(160, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(161, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(162, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(163, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(164, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:53'),
(165, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:54'),
(166, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:54'),
(167, 21, 24, 1, 5000.00, 5000.00, '2025-04-06 18:55:54'),
(168, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:54'),
(169, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:54'),
(170, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:55'),
(171, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:55'),
(172, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:55'),
(173, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:55'),
(174, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:55'),
(175, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:56'),
(176, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:56'),
(177, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:56'),
(178, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:56'),
(179, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:56'),
(180, 21, 13, 1, 10000.00, 10000.00, '2025-04-06 18:55:57'),
(181, 22, 24, 1, 5000.00, 5000.00, '2025-04-06 19:06:16'),
(182, 22, 21, 1, 1000.00, 1000.00, '2025-04-06 19:06:16'),
(183, 22, 11, 1, 1500.00, 1500.00, '2025-04-06 19:06:17'),
(184, 22, 13, 1, 10000.00, 10000.00, '2025-04-06 19:06:17'),
(185, 22, 20, 1, 2000.00, 2000.00, '2025-04-06 19:06:18'),
(186, 22, 18, 1, 750.00, 750.00, '2025-04-06 19:06:18'),
(187, 22, 19, 1, 1000.00, 1000.00, '2025-04-06 19:06:18'),
(188, 22, 12, 1, 5000.00, 5000.00, '2025-04-06 19:06:18'),
(189, 22, 12, 1, 5000.00, 5000.00, '2025-04-06 19:06:18'),
(190, 22, 22, 1, 2000.00, 2000.00, '2025-04-06 19:06:19'),
(191, 22, 23, 1, 5000.00, 5000.00, '2025-04-06 19:06:19'),
(192, 23, 21, 1, 1000.00, 1000.00, '2025-04-06 19:28:50'),
(193, 23, 21, 1, 1000.00, 1000.00, '2025-04-06 19:28:50'),
(194, 23, 21, 1, 1000.00, 1000.00, '2025-04-06 19:28:50'),
(195, 23, 21, 1, 1000.00, 1000.00, '2025-04-06 19:28:50'),
(196, 23, 21, 1, 1000.00, 1000.00, '2025-04-06 19:28:50'),
(197, 22, 28, 1, 750.00, 750.00, '2025-04-06 20:03:42'),
(198, 22, 13, 1, 10000.00, 10000.00, '2025-04-06 21:03:05'),
(199, 22, 12, 1, 5000.00, 5000.00, '2025-04-06 21:03:08'),
(200, 24, 28, 1, 750.00, 750.00, '2025-04-10 17:40:16'),
(201, 24, 27, 1, 250.00, 250.00, '2025-04-10 17:40:17'),
(202, 24, 22, 1, 2000.00, 2000.00, '2025-04-10 17:40:27'),
(203, 25, 24, 1, 5000.00, 5000.00, '2025-04-14 10:30:02'),
(204, 25, 24, 1, 5000.00, 5000.00, '2025-04-14 10:30:03'),
(205, 25, 21, 1, 1000.00, 1000.00, '2025-04-14 10:30:04'),
(206, 25, 13, 1, 10000.00, 10000.00, '2025-04-14 10:30:04'),
(207, 26, 24, 1, 5000.00, 5000.00, '2025-04-14 10:50:56'),
(208, 26, 11, 1, 1500.00, 1500.00, '2025-04-14 10:50:57'),
(209, 26, 18, 1, 750.00, 750.00, '2025-04-14 10:50:57'),
(210, 26, 20, 1, 2000.00, 2000.00, '2025-04-14 10:50:58'),
(211, 27, 24, 1, 5000.00, 5000.00, '2025-04-14 10:51:05'),
(212, 27, 13, 1, 10000.00, 10000.00, '2025-04-14 10:51:05'),
(213, 27, 20, 1, 2000.00, 2000.00, '2025-04-14 10:51:05'),
(214, 27, 14, 1, 500.00, 500.00, '2025-04-14 10:51:05'),
(215, 27, 15, 1, 500.00, 500.00, '2025-04-14 10:51:06'),
(219, 29, 24, 1, 5000.00, 5000.00, '2025-04-14 12:07:53'),
(220, 29, 15, 1, 500.00, 500.00, '2025-04-14 12:07:57'),
(221, 29, 14, 1, 500.00, 500.00, '2025-04-14 12:07:58'),
(222, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:00'),
(223, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(224, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(225, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(226, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(227, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(228, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:01'),
(229, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:02'),
(230, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:02'),
(231, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:02'),
(232, 29, 27, 1, 250.00, 250.00, '2025-04-14 12:08:02');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','passive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`id`, `category_id`, `name`, `price`, `stock`, `status`, `created_at`) VALUES
(11, 4, 'Chivas Regal 50C', 1500.00, 49, 'active', '2025-04-06 17:48:50'),
(12, 4, 'Chivas Regal 70C', 5000.00, 49, 'active', '2025-04-06 17:49:04'),
(13, 4, 'Chivas Regal 100C', 10000.00, 48, 'active', '2025-04-06 17:49:23'),
(14, 9, 'Karışık Çerez', 500.00, 45, 'active', '2025-04-06 17:50:50'),
(15, 9, 'Rakı Tabağı', 500.00, 46, 'active', '2025-04-06 17:51:01'),
(16, 6, 'Küçül İçecek', 1000.00, 9999, 'active', '2025-04-06 17:56:22'),
(17, 6, 'Büyük İçeçek', 1500.00, 9999, 'active', '2025-04-06 17:56:33'),
(18, 4, 'Johnnie Walker 35C', 750.00, 50, 'active', '2025-04-06 18:51:16'),
(19, 4, 'Johnnie Walker 50C', 1000.00, 50, 'active', '2025-04-06 18:51:31'),
(20, 4, 'Johnnie Walker 100C', 2000.00, 49, 'active', '2025-04-06 18:51:41'),
(21, 4, 'Beylerbeyi Göbel 35C', 1000.00, 50, 'active', '2025-04-06 18:53:13'),
(22, 4, 'Beylerbeyi Göbel 50C', 2000.00, 50, 'active', '2025-04-06 18:53:27'),
(23, 4, 'Beylerbeyi Göbel 70C', 5000.00, 50, 'active', '2025-04-06 18:54:28'),
(24, 4, 'Beylerbeyi Göbel 100C', 5000.00, 111, 'active', '2025-04-06 18:54:37'),
(25, 4, 'Tuborg Bira', 450.00, 100, 'active', '2025-04-06 18:55:11'),
(26, 4, 'Efes Bira', 450.00, 50, 'active', '2025-04-06 18:55:21'),
(27, 7, 'Konfeti', 250.00, 9999, 'active', '2025-04-06 19:43:39'),
(28, 1, 'Et Sote', 750.00, 9999, 'active', '2025-04-06 19:44:04');

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

--
-- Table structure for table `stock_movements`
--

CREATE TABLE `stock_movements` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `type` enum('giris','cikis') NOT NULL,
  `quantity` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_movements`
--

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

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `status` enum('bos','dolu','hazirlaniyor','beklemede','tamamlandi','iptal') NOT NULL DEFAULT 'bos',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tables`
--

INSERT INTO `tables` (`id`, `name`, `status`, `created_at`) VALUES
(1, 'Masa 1', 'bos', '2025-04-06 17:23:23'),
(2, 'Masa 2', 'bos', '2025-04-06 17:23:23'),
(3, 'Masa 3', 'bos', '2025-04-06 17:23:23'),
(4, 'Masa 4', 'bos', '2025-04-06 17:23:23'),
(5, 'Masa 5', 'bos', '2025-04-06 17:23:23'),
(6, 'Loca 10', 'bos', '2025-04-06 17:55:47'),
(7, 'Loca 11', 'bos', '2025-04-06 17:55:52'),
(8, 'Loca 12', 'dolu', '2025-04-06 17:55:56'),
(9, 'LOCA11', 'bos', '2025-04-10 17:42:26');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `table_id` (`table_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `stock_movements`
--
ALTER TABLE `stock_movements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `tables`
--
ALTER TABLE `tables`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `stock_movements`
--
ALTER TABLE `stock_movements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=442;

--
-- AUTO_INCREMENT for table `tables`
--
ALTER TABLE `tables`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`);

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `stock_movements`
--
ALTER TABLE `stock_movements`
  ADD CONSTRAINT `stock_movements_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
COMMIT;

