-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- ホスト: localhost:3306
-- 生成日時: 2024 年 1 月 25 日 21:46
-- サーバのバージョン： 10.3.39-MariaDB-cll-lve
-- PHP のバージョン: 8.1.26

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

--
-- データベース: `bsuihzhf_s1`
--
CREATE DATABASE IF NOT EXISTS `bsuihzhf_s1` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `bsuihzhf_s1`;

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

--
-- テーブルの構造 `check_dt1`
--

DROP TABLE IF EXISTS `check_dt1`;
CREATE TABLE `check_dt1` (
  `id` int(11) NOT NULL,
  `check_id` varchar(50) DEFAULT NULL,
  `room_no` tinyint(4) NOT NULL DEFAULT 0,
  `over_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '2 or 3 超過0分から',
  `leave_remain_time` int(11) NOT NULL DEFAULT 0 COMMENT '退出残り時間（分単位）',
  `entry_close_time` int(11) NOT NULL DEFAULT 0 COMMENT '入室時から閉店までの時間（分単位）',
  `people` tinyint(4) NOT NULL DEFAULT 0,
  `unit_price_kind` tinyint(4) NOT NULL DEFAULT 0 COMMENT '単価種類',
  `drink_free_kind` tinyint(4) NOT NULL DEFAULT 0 COMMENT '飲み放題種類',
  `drink_free_time` int(11) NOT NULL DEFAULT 0 COMMENT '飲み放題残り時間',
  `dt4_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'DT4 flag',
  `staff_call` tinyint(4) NOT NULL DEFAULT 0,
  `staff_call_time` datetime DEFAULT NULL,
  `up_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- テーブルのデータのダンプ `check_dt1`
--

INSERT INTO `check_dt1` (`id`, `check_id`, `room_no`, `over_flag`, `leave_remain_time`, `entry_close_time`, `people`, `unit_price_kind`, `drink_free_kind`, `drink_free_time`, `dt4_flag`, `staff_call`, `staff_call_time`, `up_date`) VALUES
(1, '27b974bcc4', 4, 2, 79, 1080, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 16:40:42'),
(3, '27b974bcc6', 6, 2, 300, 1080, 3, 0, 0, 0, 1, 0, NULL, '2024-01-25 15:32:59'),
(4, '27b974eba5', 5, 2, 297, 1078, 5, 0, 0, 0, 1, 0, NULL, '2024-01-25 13:04:58'),
(6, '27b9771e2d', 13, 2, 274, 1054, 3, 0, 0, 0, 1, 0, NULL, '2024-01-25 13:23:30'),
(8, '27b97bf857', 7, 2, 220, 1001, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 14:36:39'),
(9, '27b97c561b', 11, 2, 216, 997, 2, 0, 0, 0, 1, 0, NULL, '2024-01-25 14:27:44'),
(10, '27b97c6d88', 8, 2, 215, 996, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 14:08:12'),
(11, '27b9808c3c', 12, 2, 171, 951, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 14:39:57'),
(12, '27b980bb19', 9, 2, 168, 949, 2, 0, 0, 0, 1, 0, NULL, '2024-01-25 14:54:39'),
(13, '27b98a6f85', 21, 2, 242, 843, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 18:02:54'),
(14, '27b98f7881', 1, 2, 119, 788, 2, 0, 0, 0, 1, 0, NULL, '2024-01-25 20:14:22'),
(15, '27b99b3082', 2, 2, 186, 660, 5, 0, 0, 0, 1, 0, NULL, '2024-01-25 21:23:19');

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

--
-- テーブルの構造 `check_dt1_old`
--

DROP TABLE IF EXISTS `check_dt1_old`;
CREATE TABLE `check_dt1_old` (
  `id` int(11) NOT NULL,
  `check_id` varchar(50) DEFAULT NULL,
  `room_no` tinyint(4) NOT NULL DEFAULT 0,
  `over_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '2 or 3 超過0分から',
  `leave_remain_time` int(11) NOT NULL DEFAULT 0 COMMENT '退出残り時間（分単位）',
  `entry_close_time` int(11) NOT NULL DEFAULT 0 COMMENT '入室時から閉店までの時間（分単位）',
  `people` tinyint(4) NOT NULL DEFAULT 0,
  `unit_price_kind` tinyint(4) NOT NULL DEFAULT 0 COMMENT '単価種類',
  `drink_free_kind` tinyint(4) NOT NULL DEFAULT 0 COMMENT '飲み放題種類',
  `drink_free_time` int(11) NOT NULL DEFAULT 0 COMMENT '飲み放題残り時間',
  `dt4_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'DT4 flag',
  `staff_call` tinyint(4) NOT NULL DEFAULT 0,
  `staff_call_time` datetime DEFAULT NULL,
  `up_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- テーブルのデータのダンプ `check_dt1_old`
--

INSERT INTO `check_dt1_old` (`id`, `check_id`, `room_no`, `over_flag`, `leave_remain_time`, `entry_close_time`, `people`, `unit_price_kind`, `drink_free_kind`, `drink_free_time`, `dt4_flag`, `staff_call`, `staff_call_time`, `up_date`) VALUES
(1, '27af45dd62', 2, 2, 179, 754, 3, 0, 0, 0, 0, 0, NULL, '2024-01-05 17:26:33'),
(2, 's27b1eb5ba9', 1, 2, 300, 447, 3, 0, 0, 0, 0, 0, NULL, '2024-01-10 21:32:33'),
(3, '27b2483083', 3, 2, 178, 980, 3, 0, 0, 0, 0, 0, NULL, '2024-01-11 13:42:11'),
(4, '27b24876d4', 4, 2, 179, 977, 3, 0, 0, 109, 0, 0, NULL, '2024-01-11 13:44:12'),
(5, 's27b46dba89', 1, 2, 120, 677, 3, 0, 0, 60, 0, 0, NULL, '2024-01-15 17:42:28'),
(6, '27b471fdf4', 4, 2, 239, 691, 3, 0, 0, 0, 0, 0, NULL, '2024-01-15 18:30:01'),
(7, 's18d1ee0daec', 100, 2, 120, 1238, 3, 0, 0, 0, 0, 0, NULL, '2024-01-19 08:21:21'),
(8, '27b66394c3', 3, 2, 179, 1016, 3, 0, 0, 0, 0, 0, NULL, '2024-01-19 13:04:43'),
(9, '27b66682c4', 4, 2, 180, 984, 3, 0, 0, 110, 0, 0, NULL, '2024-01-19 13:36:27'),
(10, '27b7e969ae', 14, 2, 298, 1078, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 12:03:55'),
(11, '27b7eeff5e', 14, 2, 236, 1017, 1, 0, 0, 0, 1, 0, NULL, '2024-01-22 13:04:00'),
(12, '27b7ecfbbd', 13, 2, 259, 1039, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 13:08:49'),
(13, '27b7ed132a', 10, 2, 258, 1038, 3, 0, 0, 0, 1, 0, NULL, '2024-01-22 13:24:07'),
(14, '27b7ef748e', 14, 2, 231, 1012, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 13:41:36'),
(15, '27b7f2a8dd', 13, 2, 197, 977, 1, 0, 0, 0, 1, 1, '2024-01-22 13:47:33', '2024-01-22 14:07:40'),
(16, '27b7ec4036', 6, 2, 266, 1047, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 15:05:40'),
(17, '27b7eb9c28', 8, 2, 273, 1054, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 15:07:54'),
(18, '27b7e3bc9a', 26, 2, 539, 1140, 2, 0, 0, 0, 1, 0, NULL, '2024-01-22 18:16:33'),
(19, '27b80a3045', 5, 2, 27, 720, 6, 1, 0, 0, 1, 0, NULL, '2024-01-22 19:52:14'),
(20, '27b86dfb2b', 11, 2, 289, 1070, 1, 0, 0, 0, 1, 0, NULL, '2024-01-23 12:38:16'),
(21, '27b86ee58c', 12, 2, 280, 1060, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 12:54:12'),
(22, '27b86c3dd6', 6, 2, 308, 1089, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 12:46:08'),
(23, '27b86bc8a8', 8, 2, 314, 1094, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 12:45:25'),
(24, '27b86ce1ed', 13, 2, 302, 1082, 3, 0, 0, 0, 1, 0, NULL, '2024-01-23 13:28:44'),
(25, '27b87361fb', 11, 2, 230, 1011, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 13:59:34'),
(26, '27b8730439', 9, 2, 235, 1015, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 14:01:05'),
(27, '27b8747b35', 5, 2, 219, 999, 10, 0, 0, 0, 1, 0, NULL, '2024-01-23 14:02:32'),
(28, '27b874c18c', 12, 2, 216, 996, 1, 0, 0, 0, 1, 0, NULL, '2024-01-23 14:06:20'),
(29, '27b872d557', 7, 2, 237, 1017, 1, 0, 0, 0, 1, 0, NULL, '2024-01-23 14:14:30'),
(30, '27b875947e', 14, 2, 206, 987, 2, 0, 0, 0, 1, 0, NULL, '2024-01-23 14:19:31'),
(31, '27b87f8f26', 6, 2, 458, 878, 3, 0, 0, 0, 1, 1, '2024-01-23 15:30:47', '2024-01-23 19:34:30'),
(32, '27b8f0719b', 11, 2, 304, 1085, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:41:27'),
(33, '27b8ef6fcc', 12, 2, 316, 1096, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:03:22'),
(34, '27b8f1448e', 14, 2, 295, 1076, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:24:10'),
(35, '27b8ef2978', 8, 2, 319, 1099, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:25:27'),
(36, '27b8eeb446', 6, 2, 323, 1104, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:31:58'),
(37, '27b8f18add', 13, 2, 293, 1073, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 12:45:14'),
(38, '27b8f9b0cb', 11, 2, 203, 984, 2, 0, 0, 0, 1, 0, NULL, '2024-01-24 14:33:19'),
(39, '27b8f66505', 5, 2, 213, 1020, 10, 0, 0, 0, 1, 0, NULL, '2024-01-24 15:13:09'),
(40, '27b8effc6f', 15, 2, 488, 1090, 1, 0, 0, 0, 1, 0, NULL, '2024-01-24 17:12:07'),
(41, '27b9149b75', 21, 3, 1, 690, 47, 1, 0, 0, 1, 0, NULL, '2024-01-24 20:40:01'),
(5515, '27b975496b', 11, 2, 293, 1074, 3, 0, 0, 0, 1, 0, NULL, '2024-01-25 12:56:39'),
(5516, '27b972ff78', 8, 2, 318, 1099, 1, 0, 0, 0, 1, 0, NULL, '2024-01-25 12:37:42'),
(5517, '27b9777bec', 12, 2, 270, 1050, 2, 0, 0, 0, 1, 0, NULL, '2024-01-25 13:11:17');

--
-- ダンプしたテーブルのインデックス
--

--
-- テーブルのインデックス `check_dt1`
--
ALTER TABLE `check_dt1`
  ADD PRIMARY KEY (`id`);

--
-- テーブルのインデックス `check_dt1_old`
--
ALTER TABLE `check_dt1_old`
  ADD PRIMARY KEY (`id`);

--
-- ダンプしたテーブルの AUTO_INCREMENT
--

--
-- テーブルの AUTO_INCREMENT `check_dt1`
--
ALTER TABLE `check_dt1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- テーブルの AUTO_INCREMENT `check_dt1_old`
--
ALTER TABLE `check_dt1_old`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5518;
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 */;
