-- https://www.phpmyadmin.net/
--
-- 생성 시간: 25-03-12 10:54
-- 서버 버전: 10.11.6-MariaDB-0+deb12u1
-- PHP 버전: 8.2.20

START TRANSACTION;



--
-- 데이터베이스: `fleemarket`
--

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

--
-- 테이블 구조 `contact`
--

CREATE TABLE `contact` (
  `Id` int(11) NOT NULL,
  `Name` varchar(250) NOT NULL,
  `Email` varchar(250) NOT NULL,
  `Mobile` varchar(250) NOT NULL,
  `Subject` varchar(250) NOT NULL,
  `Message` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- 테이블의 덤프 데이터 `contact`
--

INSERT INTO `contact` (`Id`, `Name`, `Email`, `Mobile`, `Subject`, `Message`) VALUES
(3, 'BIRJU KUMAR', 'ckj40856@gmail.com', '8903079750', 'asd', 'asdasdasd'),
(4, 'CHANDAN KUMAR', 'ckj40856@gmail.com', '9487810674', 'asd', 'hfgdsfsx'),
(10, 'kskang3', 'kskang2@gmail.com', '01052545944', 'test1', 'test1 contents'),
(11, 'kskang3', 'kskang2@gmail.com', '01052545944', 'test1', 'test1 contents');

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

--
-- 테이블 구조 `food`
--

CREATE TABLE `food` (
  `F_ID` int(30) NOT NULL,
  `name` varchar(30) NOT NULL,
  `choice1` varchar(31) DEFAULT '0',
  `choice2` varchar(31) DEFAULT '0',
  `choice3` varchar(31) DEFAULT '0',
  `price` varchar(30) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `R_ID` int(30) NOT NULL,
  `display` varchar(11) DEFAULT '999',
  `images_path` varchar(200) DEFAULT NULL,
  `options` varchar(10) NOT NULL DEFAULT 'ENABLE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 테이블의 덤프 데이터 `food`
--

INSERT INTO `food` (`F_ID`, `name`, `choice1`, `choice2`, `choice3`, `price`, `description`, `R_ID`, `display`, `images_path`, `options`) VALUES
(119, '수제비', '', '', '', '7500', '', 9, '30', 'images/1050x700d.png', 'ENABLE'),
(120, '칼국수', '', '', '', '7000', '', 9, '10', 'images/1050x700a.png', 'ENABLE'),
(123, '공기밥', '', '', '', '1000', '', 9, '60', 'images/1050x700f.png', 'DISABLE'),
(132, '김치칼국수', '', '', '', '7500', '', 9, '20', 'images/1050x700c.png', 'DISABLE'),
(133, '만두5개', '고기', '김치', '섞어', '7500', '', 9, '50', 'images/1050x700e.png', 'ENABLE'),
(134, '음료', '콜라', '사이다', '', '1500', '', 9, '70', 'images/300x200g.png', 'DISABLE'),
(170, '김치수제비', '', '', '', '8000', '', 9, '40', 'images/food22.png', 'DISABLE'),
(173, '포도주', '국산', '칠레', '프랑스', '5000', '잔으로', 9, '777', 'images/wine2a.png', 'DISABLE'),
(202, '바지락칼국수', '', '', '', '10000', '', 26, '15', 'images/b3 (2).jpg', 'ENABLE'),
(203, '소고기버섯샤브', '보통', '매운', '', '19000', '', 26, '35', 'images/b3 (4).jpg', 'ENABLE'),
(204, '한우버섯샤브', '보통', '매운', '', '25000', '', 26, '45', 'images/b3 (1).jpg', 'ENABLE'),
(205, '버섯만두전골', '', '', '', '16000', '', 26, '25', 'images/b3 (3).jpg', 'ENABLE'),
(246, '하트비누', '', '', '', '4000', '', 11, '4', 'images/N72_2016a.png', 'ENABLE'),
(247, '꿀비누', '', '', '', '4000', '', 11, '5', 'images/N72_2016b.png', 'ENABLE'),
(253, '實驗品目', '', '', '', '5000', '', 11, '9', 'images/A11qqAAs.png', 'ENABLE'),
(254, '하트비누', '', '', '', '5000', '', 11, '1', 'images/1.png', 'ENABLE');

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

--
-- 테이블 구조 `orders`
--

CREATE TABLE `orders` (
  `order_ID` int(30) NOT NULL,
  `order_number` varchar(11) DEFAULT NULL,
  `foodname` varchar(30) NOT NULL,
  `choice` varchar(31) DEFAULT NULL,
  `status` varchar(11) DEFAULT '0',
  `price` int(30) NOT NULL,
  `quantity` int(30) NOT NULL,
  `order_date` varchar(31) NOT NULL,
  `username` varchar(30) NOT NULL,
  `table_nr` varchar(64) DEFAULT '先',
  `contact` varchar(31) DEFAULT NULL,
  `gtotal` varchar(11) DEFAULT NULL,
  `F_ID` int(30) NOT NULL,
  `R_ID` int(30) NOT NULL,
  `myung` varchar(11) DEFAULT NULL,
  `display` varchar(11) DEFAULT '999'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 테이블의 덤프 데이터 `orders`
--

INSERT INTO `orders` (`order_ID`, `order_number`, `foodname`, `choice`, `status`, `price`, `quantity`, `order_date`, `username`, `table_nr`, `contact`, `gtotal`, `F_ID`, `R_ID`, `myung`, `display`) VALUES
(1376, '1226.03', '수제비', '', '9', 7500, 1, '1704857205', '단골 손님', 'W', '01052545944', '7500', 119, 9, '3', '30'),
(1378, '1222.03', '수제비', '', '9', 7500, 1, '1705375355', '관리자', '02', '01022223333', '7500', 119, 9, '', '30'),
(1380, '1414.03', '만두5개', '김치', '9', 7500, 1, '1705382084', '관리자', '05', '01022223333', '7500', 133, 9, '', '50'),
(1381, '0852.1', '음료', '콜라', '9', 1500, 1, '1706399552', '관리자', 'i', '01022223333', '1500', 134, 9, '', '70'),
(1382, '1441.1', '칼국수', '', '9', 7000, 1, '1707543706', '관리자', '07', '01022223333', '7000', 120, 9, '', '10'),
(1383, '1441.1', '만두5개', '김치', '9', 7500, 2, '1707543706', '관리자', '07', '01022223333', '15000', 133, 9, '', '50'),
(1394, '2016.46', '바지락칼국수', '', '9', 10000, 1, '1716031000', '단골 손님', '1', '01052545944', '10000', 202, 26, NULL, '999'),
(1395, '2132.46', '바지락칼국수', '', '8', 10000, 1, '1716035553', '단골 손님', '대', '01052545944', '10000', 202, 26, NULL, '999'),
(1398, '2134.49', '버섯만두전골', '', '9', 16000, 1, '1716035643', '단골 손님', '대', '01052545944', '16000', 205, 26, NULL, '999'),
(1399, '0810.1', '버섯만두전골', '', '9', 16000, 3, '1716073816', '단골 손님', '9', '01052545944', '48000', 205, 26, NULL, '999'),
(1400, '0811.2', '바지락칼국수', '', '9', 10000, 3, '1716073862', '단골 손님', '11', '01052545944', '30000', 202, 26, NULL, '999'),
(1401, '0811.3', '한우버섯샤브', '보통', '9', 25000, 3, '1716073895', '단골 손님', '8', '01052545944', '75000', 204, 26, NULL, '999'),
(1402, '0913.4', '바지락칼국수', '', '9', 10000, 1, '1716077598', '단골 손님', '10', '01052545944', '10000', 202, 26, NULL, '999'),
(1404, '0943.5', '버섯만두전골', '', '9', 16000, 3, '1716079390', '단골 손님', '7', '01052545944', '58000', 205, 26, NULL, '999'),
(1405, '0950.6', '바지락칼국수', '', '9', 10000, 1, '1716079808', '단골 손님', '대', '01052545944', '10000', 202, 26, NULL, '999'),
(1406, '0954.8', '버섯만두전골', '', '9', 16000, 1, '1716080059', '단골 손님', '14', '01052545944', '16000', 205, 26, NULL, '999'),
(1442, '0714.53', '칼국수', '', '9', 7000, 1, '1726557297', '관리자', '4', '01022223333', '7000', 120, 9, NULL, '999'),
(1443, '0714.53', '수제비', '', '9', 7500, 1, '1726557297', '관리자', '4', '01022223333', '14500', 119, 9, NULL, '999'),
(1444, '0953.55', '만두5개', '김치', '8', 7500, 1, '1726566839', '단골 손님', '7', '01052545944', '7500', 133, 9, NULL, '999'),
(1446, '1005.03', '수제비', '', '9', 7500, 3, '1726567505', '단골 손님', '15', '01052545944', '22500', 119, 9, '', '30'),
(1447, '1006.04', '칼국수', '', '9', 7000, 6, '1726567562', '관리자', '16', '01022223333', '42000', 120, 9, '', '10'),
(1448, '1006.05', '만두5개', '섞어', '9', 7500, 4, '1726567611', '관리자', '17', '01022223333', '30000', 133, 9, '', '50'),
(1449, '1008.06', '만두5개', '섞어', '9', 7500, 1, '1726567704', '관리자', '14', '01022223333', '7500', 133, 9, '', '50'),
(1741, '0356.20', '칼국수', '', '8', 7000, 1, '1730951807', '단골 손님', '03', '01052545944', '7000', 120, 9, '', '10'),
(1742, '0358.22', '칼국수', '', '9', 7000, 1, '1730951898', '단골 손님', 'i', '01052545944', '7000', 120, 9, '', '10'),
(1743, '0816.24', '만두5개', '고기', '9', 7500, 1, '1730967380', '단골 손님', 'i', '01052545944', '7500', 133, 9, '', '50'),
(1744, '0817.26', '만두5개', '김치', '9', 7500, 3, '1730967460', '단골 손님', 'i', '01052545944', '22500', 133, 9, '', '50'),
(1745, '0818.28', '수제비', '', '9', 7500, 3, '1730967497', '관리자', '08', '01022223333', '22500', 119, 9, '', '30'),
(1746, '0820.29', '수제비', '', '9', 7500, 1, '1730967612', '관리자', '09', '01022223333', '7500', 119, 9, '', '30'),
(1747, '0820.30', '만두5개', '고기', '9', 7500, 1, '1730967630', '관리자', '10', '01022223333', '7500', 133, 9, '', '50'),
(1748, '0820.32', '칼국수', '', '9', 7000, 1, '1730967644', '관리자', '11', '01022223333', '7000', 120, 9, '', '10'),
(1749, '0832.34', '수제비', '', '9', 7500, 1, '1730968376', '관리자', '11', '01022223333', '7500', 119, 9, '', '30'),
(1750, '0833.35', '칼국수', '', '9', 7000, 1, '1730968391', '관리자', '12', '01022223333', '7000', 120, 9, '', '10'),
(1751, '0833.36', '칼국수', '', '9', 7000, 1, '1730968404', '단골 손님', 'i', '01052545944', '7000', 120, 9, '', '10'),
(1752, '0833.37', '수제비', '', '9', 7500, 1, '1730968416', '단골 손님', 'i', '01052545944', '7500', 119, 9, '', '30'),
(1753, '0834.38', '만두5개', '고기', '9', 7500, 1, '1730968440', '단골 손님', '13', '01052545944', '7500', 133, 9, '', '50'),
(1754, '0834.39', '만두5개', '고기', '9', 7500, 1, '1730968460', '관리자', '14', '01022223333', '7500', 133, 9, '', '50'),
(1755, '0839.40', '칼국수', '', '9', 7000, 1, '1730968798', '관리자', '11', '01022223333', '7000', 120, 9, '', '10'),
(1756, '0840.41', '칼국수', '', '9', 7000, 1, '1730968814', '관리자', '12', '01022223333', '7000', 120, 9, '', '10'),
(1757, '0840.42', '만두5개', '고기', '8', 7500, 1, '1730968826', '관리자', '13', '01022223333', '7500', 133, 9, '', '50'),
(1758, '0840.43', '만두5개', '고기', '9', 7500, 1, '1730968850', '관리자', '14', '01022223333', '7500', 133, 9, '', '50'),
(1759, '0840.43', '칼국수', '', '9', 7000, 1, '1730968850', '관리자', '14', '01022223333', '7000', 120, 9, '', '10'),
(1760, '0840.43', '수제비', '', '8', 7500, 1, '1730968850', '관리자', '14', '01022223333', '7500', 119, 9, '', '30'),
(1773, '2145.63', '만두5개', '고기', '8', 7500, 1, '1731015932', '관리자', '11', '01022223333', '7500', 133, 9, '', '50'),
(1774, '2147.65', '수제비', '', '8', 7500, 1, '1731016032', '관리자', '12', '01022223333', '7500', 119, 9, '', '30'),
(1775, '2147.66', '수제비', '', '8', 7500, 1, '1731016047', '관리자', '13', '01022223333', '7500', 119, 9, '', '30'),
(1783, '2156.78', '만두5개', '고기', '8', 7500, 1, '1731016580', '관리자', '12', '01022223333', '7500', 133, 9, '', '50'),
(1784, '2156.79', '수제비', '', '8', 7500, 1, '1731016619', '관리자', '13', '01022223333', '7500', 119, 9, '', '30'),
(1785, '2156.79', '만두5개', '고기', '8', 7500, 1, '1731016619', '관리자', '13', '01022223333', '7500', 133, 9, '', '50'),
(1786, '2157.80', '수제비', '', '9', 7500, 1, '1731016637', '관리자', '09', '01022223333', '7500', 119, 9, '', '30'),
(1788, '2157.82', '칼국수', '', '8', 7000, 1, '1731016671', '관리자', '13', '01022223333', '7000', 120, 9, '', '10'),
(1789, '0728.83', '수제비', '', '9', 7500, 1, '1731050911', '관리자', '11', '01022223333', '7500', 119, 9, '', '30'),
(1790, '0732.84', '만두5개', '고기', '9', 7500, 1, '1731051125', '관리자', '10', '01022223333', '7500', 133, 9, '', '50'),
(1791, '0734.85', '만두5개', '고기', '9', 7500, 1, '1731051270', '관리자', '11', '01022223333', '7500', 133, 9, '', '50'),
(1802, '2033.87', '수제비', '', '9', 7500, 1, '1731357225', '관리자', '15', '01022223333', '7500', 119, 9, '', '30'),
(1803, '0052.89', '수제비', '', '9', 7500, 1, '1731545527', '관리자', '15', '01022223333', '7500', 119, 9, '', '30'),
(1815, '1648.73', '하트비누', '', '9', 5000, 1, '1734940131', '단골 손님', '할아버지', '01052545944', '5000', 254, 11, NULL, '999'),
(1816, '0716.75', '하트비누', '', '0', 5000, 1, '1735683389', '단골 손님', '祖모', '01052545944', '5000', 254, 11, NULL, '999'),
(1817, '0716.76', '하트비누', '', '0', 4000, 1, '1735683405', '단골 손님', '할머니', '01052545944', '4000', 246, 11, NULL, '999'),
(1818, '0717.77', '꿀비누', '', '0', 4000, 1, '1735683420', '단골 손님', '할아버지', '01052545944', '4000', 247, 11, NULL, '999'),
(1819, '0717.78', '實驗品目', '', '9', 5000, 1, '1735683442', '단골 손님', 'ㄴㄴ', '01052545944', '5000', 253, 11, NULL, '999');

--
-- 트리거 `orders`
--
DELIMITER $$
CREATE TRIGGER `before_delete_orders` BEFORE DELETE ON `orders` FOR EACH ROW BEGIN
INSERT INTO orders_backup(order_ID, F_ID, order_number, foodname, choice, price,  quantity, order_date, username, table_nr, contact, gtotal, R_ID)
VALUES(OLD.order_ID, OLD.F_ID, OLD.order_number, OLD.foodname, OLD.choice, OLD.price,  OLD.quantity, OLD.order_date, OLD.username, OLD.table_nr, OLD.contact, OLD.gtotal,OLD.R_ID);
END
$$
DELIMITER ;

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

--
-- 테이블 구조 `orders_backup`
--

CREATE TABLE `orders_backup` (
  `order_ID` int(30) DEFAULT NULL,
  `order_number` varchar(11) DEFAULT NULL,
  `foodname` varchar(30) DEFAULT NULL,
  `choice` varchar(31) DEFAULT NULL,
  `status` varchar(11) DEFAULT NULL,
  `price` int(30) DEFAULT NULL,
  `quantity` int(30) DEFAULT NULL,
  `order_date` varchar(31) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `table_nr` varchar(64) DEFAULT NULL,
  `contact` varchar(31) DEFAULT NULL,
  `gtotal` varchar(11) DEFAULT NULL,
  `F_ID` int(30) DEFAULT NULL,
  `R_ID` int(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 테이블의 덤프 데이터 `orders_backup`
--

INSERT INTO `orders_backup` (`order_ID`, `order_number`, `foodname`, `choice`, `status`, `price`, `quantity`, `order_date`, `username`, `table_nr`, `contact`, `gtotal`, `F_ID`, `R_ID`) VALUES
(1029, '0845.09', '만두5개', '섞어', NULL, 7500, 2, '1670543159', '단골 손님', 'i', '01052545944', '51000', 133, 9),
(1031, '0857.13', '수제비', '', NULL, 7500, 1, '1670543874', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1060, '0937.17', '수제비', '', NULL, 7500, 1, '1670805450', '단골 손님', '08', '01052545944', '7500', 119, 9),
(1225, '1226.63', '수제비', '', NULL, 7500, 1, '1671161180', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1224, '1224.62', '칼국수', '', NULL, 7000, 1, '1671161090', '단골 손님', '02', '01052545944', '7000', 120, 9),
(1223, '1224.61', '수제비', '', NULL, 7500, 1, '1671161084', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1222, '1202.60', '칼국수', '', NULL, 7000, 1, '1671159750', '단골 손님', '02', '01052545944', '7000', 120, 9),
(1221, '1202.59', '수제비', '', NULL, 7500, 1, '1671159724', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1220, '1200.58', '수제비', '', NULL, 7500, 1, '1671159648', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1219, '1156.57', '칼국수', '', NULL, 7000, 1, '1671159413', '단골 손님', '02', '01052545944', '7000', 120, 9),
(1218, '1152.56', '수제비', '', NULL, 7500, 1, '1671159148', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1217, '1151.55', '수제비', '', NULL, 7500, 1, '1671159090', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1216, '1150.54', '수제비', '', NULL, 7500, 1, '1671159032', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1215, '1149.53', '수제비', '', NULL, 7500, 1, '1671158969', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1240, '1702.41', '칼국수', '', NULL, 7000, 1, '1671264177', '관리자', '05', '01022223333', '7000', 120, 9),
(1239, '1641.77', '공기밥', '', NULL, 1000, 1, '1671262908', '관리자', '10', '01022223333', '1000', 123, 9),
(1238, '1639.76', '수제비', '', NULL, 7500, 1, '1671262760', '관리자', '09', '01022223333', '7500', 119, 9),
(1237, '1638.75', '수제비', '', NULL, 7500, 1, '1671262697', '관리자', '08', '01022223333', '7500', 119, 9),
(1236, '1636.74', '칼국수', '', NULL, 7000, 1, '1671262593', '관리자', '04', '01022223333', '7000', 120, 9),
(1235, '1632.73', '칼국수', '', NULL, 7000, 1, '1671262363', '관리자', '05', '01022223333', '7000', 120, 9),
(1234, '1628.72', '칼국수', '', NULL, 7000, 1, '1671262109', '관리자', '06', '01022223333', '7000', 120, 9),
(1231, '1036.68', '수제비', '', NULL, 7500, 1, '1671240973', '관리자', '03', '01022223333', '7500', 119, 9),
(1230, '1036.68', '칼국수', '', NULL, 7000, 1, '1671240973', '관리자', '03', '01022223333', '7000', 120, 9),
(1211, '0745.46', '수제비', '', NULL, 7500, 1, '1671254000', '단골 손님', '07', '01052596944', '7500', 119, 9),
(1062, '0942.16', '칼국수', '', NULL, 7000, 1, '1670805722', '단골 손님', '05', '01052545944', '7000', 120, 9),
(1064, '0952.24', '음료', '콜라', NULL, 1500, 1, '1670806374', '단골 손님', '07', '01052545944', '1500', 134, 9),
(1076, '1108.30', '수제비', '', NULL, 7500, 1, '1670810904', '단골 손님', '05', '01052545944', '7500', 119, 9),
(1077, '1108.30', '칼국수', '', NULL, 7000, 1, '1670810904', '단골 손님', '05', '01052545944', '7000', 120, 9),
(1083, '1159.33', '음료', '사이다', NULL, 1500, 3, '1670813996', '단골 손님', '電', '01052545944', '4500', 134, 9),
(1084, '1159.33', '수제비', '', NULL, 7500, 1, '1670813996', '단골 손님', '電', '01052545944', '7500', 119, 9),
(1089, '1541.35', '수제비', '', NULL, 7500, 1, '1670827303', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1090, '1541.35', '만두5개', '고기', NULL, 7500, 2, '1670827303', '단골 손님', 'i', '01052545944', '15000', 133, 9),
(1091, '1607.36', '공기밥', '', NULL, 1000, 1, '1670828869', '단골 손님', 'i', '01052545944', '1000', 123, 9),
(1092, '1607.36', '음료', '콜라', NULL, 1500, 1, '1670828869', '단골 손님', 'i', '01052545944', '1500', 134, 9),
(1093, '1642.24', '음료', '콜라', NULL, 1500, 2, '1670830975', '단골 손님', '02', '01052545944', '3000', 134, 9),
(1094, '1642.24', '만두5개', '김치', NULL, 7500, 2, '1670830975', '단골 손님', '02', '01052545944', '18000', 133, 9),
(1095, '0509.35', '칼국수', '', NULL, 7000, 1, '1670875789', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1096, '0509.35', '수제비', '', NULL, 7500, 2, '1670875789', '단골 손님', '03', '01052545944', '15000', 119, 9),
(1097, '0606.37', '만두5개', '고기', NULL, 7500, 1, '1670879190', '단골 손님', 'i', '01052545944', '7500', 133, 9),
(1098, '0940.37', '수제비', '', NULL, 7500, 1, '1670892037', '단골 손님', '10', '01052545944', '7500', 119, 9),
(1099, '0941.39', '수제비', '', NULL, 7500, 1, '1670892072', '단골 손님', '10', '01052545944', '7500', 119, 9),
(1100, '0944.41', '만두5개', '고기', NULL, 7500, 1, '1670892245', '단골 손님', '10', '01052545944', '7500', 133, 9),
(1101, '0944.42', '만두5개', '고기', NULL, 7500, 1, '1670892298', '단골 손님', '10', '01052545944', '7500', 133, 9),
(1102, '0947.37', '만두5개', '고기', NULL, 7500, 1, '1670892431', '단골 손님', '11', '01052545944', '7500', 133, 9),
(1103, '1717.43', '칼국수', '', NULL, 7000, 1, '1670919457', '단골 손님', '07', '01052545944', '7000', 120, 9),
(1104, '1719.44', '만두5개', '섞어', NULL, 7500, 1, '1670919560', '단골 손님', 'W', '01052545944', '7500', 133, 9),
(1105, '1720.38', '만두5개', '김치', NULL, 7500, 2, '1670919648', '단골 손님', '7', '01052545944', '15000', 133, 9),
(1106, '1924.39', '만두5개', '고기', NULL, 7500, 1, '1670927070', '단골 손님', 'W', '01052545944', '7500', 133, 9),
(1107, '1924.45', '음료', '콜라', NULL, 1500, 1, '1670927086', '단골 손님', 'W', '01052545944', '1500', 134, 9),
(1108, '1925.41', '수제비', '', NULL, 7500, 1, '1670927140', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1109, '1925.41', '공기밥', '', NULL, 1000, 1, '1670927140', '단골 손님', 'W', '01052545944', '1000', 123, 9),
(1110, '0701.42', '음료', '콜라', NULL, 1500, 1, '1670968878', '단골 손님', '05', '01052545944', '1500', 134, 9),
(1111, '1609.43', '만두5개', '김치', NULL, 7500, 1, '1671001741', '단골 손님', '08', '01052545944', '7500', 133, 9),
(1112, '1609.43', '수제비', '', NULL, 7500, 1, '1671001741', '단골 손님', '08', '01052545944', '7500', 119, 9),
(1113, '1609.44', '칼국수', '', NULL, 7000, 1, '1671001759', '단골 손님', 'W', '01052545944', '7000', 120, 9),
(1114, '1609.44', '수제비', '', NULL, 7500, 1, '1671001759', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1115, '1609.45', '칼국수', '', NULL, 7000, 1, '1671001787', '단골 손님', '電', '01052545944', '7000', 120, 9),
(1116, '1609.45', '수제비', '', NULL, 7500, 1, '1671001787', '단골 손님', '電', '01052545944', '7500', 119, 9),
(1117, '1610.38', '칼국수', '', NULL, 7000, 1, '1671001810', '단골 손님', 'i', '01052545944', '7000', 120, 9),
(1118, '1610.39', '만두5개', '고기', NULL, 7500, 1, '1671001819', '단골 손님', 'i', '01052545944', '7500', 133, 9),
(1119, '1610.46', '공기밥', '', NULL, 1000, 1, '1671001855', '단골 손님', '7', '01052545944', '1000', 123, 9),
(1121, '1948.48', '만두5개', '고기', NULL, 7500, 1, '1671014937', '단골 손님', 'i', '01052545944', '7500', 133, 9),
(1124, '2021.49', '칼국수', '', NULL, 7000, 1, '1671016865', '단골 손님', '13', '01052545944', '7000', 120, 9),
(1125, '2021.49', '수제비', '', NULL, 7500, 1, '1671016865', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1126, '2021.49', '만두5개', '고기', NULL, 7500, 1, '1671016865', '단골 손님', '13', '01052545944', '7500', 133, 9),
(1127, '2021.49', '만두5개', '김치', NULL, 7500, 1, '1671016865', '단골 손님', 'W', '01052545944', '7500', 133, 9),
(1128, '2021.49', '만두5개', '섞어', NULL, 7500, 1, '1671016865', '단골 손님', '13', '01052545944', '7500', 133, 9),
(1129, '2021.51', '음료', '콜라', NULL, 1500, 1, '1671016898', '단골 손님', '13', '01052545944', '1500', 134, 9),
(1130, '2031.52', '음료', '사이다', NULL, 1500, 1, '1671017473', '단골 손님', 'W', '01052545944', '1500', 134, 9),
(1131, '0914.40', '수제비', '', NULL, 7500, 1, '1671063296', '단골 손님', '06', '01052545944', '7500', 119, 9),
(1134, '0940.51', '칼국수', '', NULL, 7000, 1, '1671064810', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1135, '0940.51', '수제비', '', NULL, 7500, 1, '1671064810', '단골 손님', '08', '01052545944', '7500', 119, 9),
(1136, '0940.51', '공기밥', '', NULL, 1000, 1, '1671064810', '단골 손님', '03', '01052545944', '1000', 123, 9),
(1137, '1329.52', '칼국수', '', NULL, 7000, 1, '1671078546', '단골 손님', '15', '01052545944', '7000', 120, 9),
(1138, '1329.52', '수제비', '', NULL, 7500, 1, '1671078546', '단골 손님', '15', '01052545944', '7500', 119, 9),
(1139, '1329.52', '공기밥', '', NULL, 1000, 1, '1671078546', '단골 손님', '15', '01052545944', '1000', 123, 9),
(1140, '1330.54', '수제비', '', NULL, 7500, 1, '1671078658', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1142, '1332.55', '만두5개', '고기', NULL, 7500, 1, '1671078743', '단골 손님', '04', '01052545944', '7500', 133, 9),
(1144, '1704.56', '수제비', '', NULL, 7500, 1, '1671091492', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1145, '1705.57', '수제비', '', NULL, 7500, 1, '1671091542', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1146, '1706.58', '수제비', '', NULL, 7500, 1, '1671091618', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1147, '1707.59', '칼국수', '', NULL, 7000, 1, '1671091651', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1148, '1719.60', '수제비', '', NULL, 7500, 1, '1671092362', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1149, '1724.61', '공기밥', '', NULL, 1000, 1, '1671092691', '단골 손님', '03', '01052545944', '1000', 123, 9),
(1150, '1726.62', '칼국수', '', NULL, 7000, 1, '1671092797', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1151, '1729.63', '칼국수', '', NULL, 7000, 1, '1671092997', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1152, '1730.64', '수제비', '', NULL, 7500, 1, '1671093026', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1153, '1730.65', '공기밥', '', NULL, 1000, 1, '1671093053', '단골 손님', '03', '01052545944', '1000', 123, 9),
(1154, '1731.66', '수제비', '', NULL, 7500, 1, '1671093102', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1155, '1732.67', '칼국수', '', NULL, 7000, 1, '1671093121', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1156, '1733.68', '수제비', '', NULL, 7500, 1, '1671093231', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1157, '1744.69', '수제비', '', NULL, 7500, 1, '1671093895', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1158, '1745.70', '만두5개', '고기', NULL, 7500, 1, '1671093919', '단골 손님', '03', '01052545944', '7500', 133, 9),
(1159, '1752.71', '칼국수', '', NULL, 7000, 1, '1671094360', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1160, '1752.72', '수제비', '', NULL, 7500, 1, '1671094379', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1163, '1759.58', '수제비', '', NULL, 7500, 1, '1671094790', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1164, '1800.74', '수제비', '', NULL, 7500, 1, '1671094816', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1165, '1804.75', '칼국수', '', NULL, 7000, 1, '1671095042', '단골 손님', '03', '', '7000', 120, 9),
(1166, '1805.76', '수제비', '', NULL, 7500, 1, '1671095111', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1167, '1806.77', '수제비', '', NULL, 7500, 1, '1671095180', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1168, '1837.78', '수제비', '', NULL, 7500, 1, '1671097060', '단골 손님', '07', '01052545944', '7500', 119, 9),
(1169, '1837.79', '수제비', '', NULL, 7500, 1, '1671097076', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1170, '1838.80', '수제비', '', NULL, 7500, 1, '1671097135', '단골 손님', '08', '01052545944', '7500', 119, 9),
(1171, '1849.82', '수제비', '', NULL, 7500, 1, '1671097767', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1172, '1850.83', '수제비', '', NULL, 7500, 1, '1671097800', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1173, '1850.84', '수제비', '', NULL, 7500, 1, '1671097832', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1174, '1852.85', '수제비', '', NULL, 7500, 1, '1671097924', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1175, '1857.86', '수제비', '', NULL, 7500, 1, '1671098256', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1176, '1858.87', '수제비', '', NULL, 7500, 1, '1671098288', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1177, '1858.88', '수제비', '', NULL, 7500, 1, '1671098310', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1178, '1858.89', '수제비', '', NULL, 7500, 1, '1671098331', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1179, '1859.90', '수제비', '', NULL, 7500, 1, '1671098363', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1180, '1901.91', '수제비', '', NULL, 7500, 1, '1671098498', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1181, '1902.92', '수제비', '', NULL, 7500, 1, '1671098520', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1182, '1902.93', '수제비', '', NULL, 7500, 1, '1671098563', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1183, '1906.94', '수제비', '', NULL, 7500, 1, '1671098813', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1184, '1947.95', '수제비', '', NULL, 7500, 1, '1671101250', '단골 손님', '05', '01052545944', '7500', 119, 9),
(1185, '1947.96', '수제비', '', NULL, 7500, 1, '1671101261', '단골 손님', '05', '01052545944', '7500', 119, 9),
(1186, '1950.98', '수제비', '', NULL, 7500, 1, '1671101411', '단골 손님', '05', '01052545944', '7500', 119, 9),
(1187, '1950.99', '수제비', '', NULL, 7500, 1, '1671101435', '단골 손님', '08', '01052545944', '7500', 119, 9),
(1188, '1952.00', '수제비', '', NULL, 7500, 1, '1671101523', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1189, '1952.01', '수제비', '', NULL, 7500, 1, '1671101538', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1190, '1955.02', '수제비', '', NULL, 7500, 1, '1671101704', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1191, '1955.02', '칼국수', '', NULL, 7000, 1, '1671101704', '단골 손님', '02', '01052545944', '7000', 120, 9),
(1192, '2002.04', '수제비', '', NULL, 7500, 1, '1671102154', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1193, '2002.05', '수제비', '', NULL, 7500, 1, '1671102170', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1194, '2003.06', '수제비', '', NULL, 7500, 1, '1671102216', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1195, '2003.07', '수제비', '', NULL, 7500, 1, '1671102239', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1196, '2004.08', '수제비', '', NULL, 7500, 1, '1671102283', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1197, '2005.09', '수제비', '', NULL, 7500, 1, '1671102331', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1201, '2009.13', '수제비', '', NULL, 7500, 1, '1671102598', '단골 손님', '14', '01052545944', '7500', 119, 9),
(1202, '2010.14', '수제비', '', NULL, 7500, 1, '1671102618', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1203, '2010.15', '칼국수', '', NULL, 7000, 1, '1671102655', '단골 손님', '13', '01052545944', '7000', 120, 9),
(1204, '2035.16', '수제비', '', NULL, 7500, 1, '1671104112', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1205, '2039.17', '만두5개', '고기', NULL, 7500, 1, '1671104359', '단골 손님', 'W', '01052545944', '7500', 133, 9),
(1206, '0627.59', '음료', '콜라', NULL, 1500, 1, '1671139658', '단골 손님', '01', '01052545944', '1500', 134, 9),
(1207, '0642.19', '만두5개', '고기', NULL, 7500, 1, '1671140543', '단골 손님', '01', '01052545944', '7500', 133, 9),
(1208, '0715.42', '수제비', '', NULL, 7500, 1, '1671142534', '단골 손님', '04', '01052545944', '7500', 119, 9),
(1209, '0716.44', '수제비', '', NULL, 7500, 1, '1671142606', '단골 손님', 'W', '01052545944', '7500', 119, 9),
(1210, '0728.45', '칼국수', '', NULL, 7000, 1, '1671143280', '단골 손님', '07', '01052545944', '7000', 120, 9),
(1212, '0756.47', '수제비', '', NULL, 7500, 1, '1671145597', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1213, '0758.49', '수제비', '', NULL, 7500, 1, '1671145092', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1214, '1122.51', '만두5개', '김치', NULL, 7500, 1, '1671157326', '단골 손님', '01', '01052545944', '7500', 133, 9),
(1226, '1516.64', '칼국수', '', NULL, 7000, 1, '1671171360', '단골 손님', '02', '01052545944', '7000', 120, 9),
(1227, '1517.65', '공기밥', '', NULL, 1000, 1, '1671171437', '단골 손님', '02', '01052545944', '1000', 123, 9),
(1228, '1613.40', '칼국수', '', NULL, 7000, 1, '1671174809', '단골 손님', '05', '01052545944', '7000', 120, 9),
(1229, '1713.67', '수제비', '', NULL, 7500, 1, '1671178403', '단골 손님', '02', '01052545944', '7500', 119, 9),
(1261, '1032.93', '수제비', '', NULL, 7500, 1, '1671327129', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1260, '1030.92', '수제비', '', NULL, 7500, 1, '1671327037', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1259, '1028.91', '수제비', '', NULL, 7500, 1, '1671326930', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1258, '1027.90', '수제비', '', NULL, 7500, 1, '1671326874', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1257, '1021.89', '수제비', '', NULL, 7500, 1, '1671326503', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1254, '1014.86', '공기밥', '', NULL, 1000, 1, '1671326070', '관리자', '電', '01022223333', '1000', 123, 9),
(1253, '1008.85', '공기밥', '', NULL, 1000, 1, '1671325734', '관리자', '電', '01022223333', '1000', 123, 9),
(1252, '1007.84', '공기밥', '', NULL, 1000, 1, '1671325668', '관리자', '電', '01022223333', '1000', 123, 9),
(1251, '1005.83', '공기밥', '', NULL, 1000, 1, '1671325548', '관리자', '電', '01022223333', '1000', 123, 9),
(1250, '1001.82', '공기밥', '', NULL, 1000, 1, '1671325318', '관리자', '電', '01022223333', '1000', 123, 9),
(1266, '1111.48', '공기밥', '', NULL, 1000, 1, '1671329494', '단골 손님', 'i', '01052545944', '1000', 123, 9),
(1265, '1110.47', '칼국수', '', NULL, 7000, 1, '1671329457', '단골 손님', 'i', '01052545944', '7000', 120, 9),
(1246, '2024.44', '만두5개', '고기', NULL, 7500, 1, '1671276248', '관리자', '04', '01022223333', '7500', 133, 9),
(1256, '1020.88', '만두5개', '고기', NULL, 7500, 1, '1671326446', '관리자', '電', '01022223333', '7500', 133, 9),
(1232, '1611.70', '수제비', '', NULL, 7500, 1, '1671261114', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1233, '1616.71', '수제비', '', NULL, 7500, 1, '1671261382', '관리자', 'W', '01022223333', '7500', 120, 9),
(1241, '1938.78', '만두5개', '고기', NULL, 7500, 1, '1671273499', '관리자', '03', '01022223333', '7500', 133, 9),
(1242, '2010.79', '만두5개', '고기', NULL, 7500, 1, '1671275443', '관리자', '03', '01022223333', '7500', 133, 9),
(1243, '2011.80', '음료', '콜라', NULL, 1500, 1, '1671275478', '관리자', '03', '01022223333', '1500', 134, 9),
(1244, '2022.42', '수제비', '', NULL, 7500, 1, '1671276167', '관리자', '03', '01022223333', '7500', 119, 9),
(1245, '2023.43', '음료', '콜라', NULL, 1500, 1, '1671276221', '관리자', '03', '01022223333', '1500', 134, 9),
(1247, '2027.81', '칼국수', '', NULL, 7000, 1, '1671276459', '관리자', '03', '01022223333', '7000', 120, 9),
(1248, '2028.45', '칼국수', '', NULL, 7000, 1, '1671276483', '관리자', '03', '01022223333', '7000', 120, 9),
(1249, '2028.46', '수제비', '', NULL, 7500, 1, '1671276527', '관리자', '05', '01022223333', '7500', 119, 9),
(1255, '1015.87', '공기밥', '', NULL, 1000, 1, '1671326129', '관리자', '電', '01022223333', '1000', 123, 9),
(1262, '1032.94', '수제비', '', NULL, 7500, 1, '1671327171', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1263, '1055.96', '칼국수', '', NULL, 7000, 1, '1671328553', '단골 손님', 'i', '01052545944', '7000', 120, 9),
(1264, '1056.97', '수제비', '', NULL, 7500, 1, '1671328603', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1267, '1114.49', '공기밥', '', NULL, 1000, 1, '1671329646', '단골 손님', 'i', '01052545944', '1000', 123, 9),
(1268, '1120.51', '만두5개', '고기', NULL, 7500, 1, '1671330029', '관리자', '電', '01022223333', '7500', 133, 9),
(1269, '1042.53', '공기밥', '', NULL, 1000, 1, '1671414123', '관리자', '09', '01022223333', '1000', 123, 9),
(1270, '1045.54', '수제비', '', NULL, 7500, 1, '1671414339', '관리자', 'W', '01022223333', '7500', 119, 9),
(1271, '1045.54', '칼국수', '', NULL, 7000, 1, '1671414339', '관리자', 'W', '01022223333', '7000', 120, 9),
(1272, '1600.56', '수제비', '', NULL, 7500, 1, '1671433205', '관리자', '03', '01022223333', '7500', 119, 9),
(1273, '1802.98', '만두5개', '고기', NULL, 7500, 1, '1671440557', '관리자', '09', '01022223333', '7500', 133, 9),
(1274, '1815.99', '칼국수', '', NULL, 7000, 1, '1671441313', '관리자', 'W', '01022223333', '7000', 120, 9),
(1275, '1815.99', '수제비', '', NULL, 7500, 1, '1671441313', '관리자', 'W', '01022223333', '7500', 119, 9),
(1276, '1815.99', '공기밥', '', NULL, 1000, 1, '1671441313', '관리자', 'W', '01022223333', '1000', 123, 9),
(1277, '1817.00', '칼국수', '', NULL, 7000, 1, '1671441469', '관리자', '01', '01022223333', '7000', 120, 9),
(1278, '1817.00', '수제비', '', NULL, 7500, 1, '1671441469', '관리자', '01', '01022223333', '7500', 119, 9),
(1279, '1817.00', '공기밥', '', NULL, 1000, 1, '1671441469', '관리자', '01', '01022223333', '1000', 123, 9),
(1280, '1858.01', '음료', '콜라', NULL, 1500, 1, '1671443893', '관리자', '03', '01022223333', '1500', 134, 9),
(1281, '1907.02', '만두5개', '고기', NULL, 7500, 1, '1671444427', '관리자', '09', '01022223333', '7500', 133, 9),
(1282, '1908.03', '칼국수', '', NULL, 7000, 1, '1671444496', '관리자', '09', '01022223333', '7000', 120, 9),
(1283, '1940.04', '칼국수', '', NULL, 7000, 1, '1671446430', '관리자', '03', '01022223333', '7000', 120, 9),
(1284, '1940.04', '수제비', '', NULL, 7500, 1, '1671446430', '관리자', '03', '01022223333', '7500', 119, 9),
(1285, '1940.04', '공기밥', '', NULL, 1000, 1, '1671446430', '관리자', '03', '01022223333', '1000', 123, 9),
(1286, '1942.05', '수제비', '', NULL, 7500, 1, '1671446551', '관리자', '03', '01022223333', '7500', 119, 9),
(1287, '1942.05', '칼국수', '', NULL, 7000, 1, '1671446551', '관리자', '03', '01022223333', '7000', 120, 9),
(1288, '1942.05', '만두5개', '고기', NULL, 7500, 1, '1671446551', '관리자', '03', '01022223333', '7500', 133, 9),
(1289, '1943.06', '수제비', '', NULL, 7500, 1, '1671446606', '관리자', '04', '01022223333', '7500', 119, 9),
(1290, '1943.07', '칼국수', '', NULL, 7000, 1, '1671446632', '관리자', '05', '01022223333', '7000', 120, 9),
(1291, '1944.08', '칼국수', '', NULL, 7000, 1, '1671446640', '관리자', '03', '01022223333', '7000', 120, 9),
(1292, '1944.57', '수제비', '', NULL, 7500, 1, '1671446659', '관리자', '04', '01022223333', '7500', 119, 9),
(1293, '1944.58', '수제비', '', NULL, 7500, 1, '1671446684', '관리자', '04', '01022223333', '7500', 119, 9),
(1294, '1945.09', '수제비', '', NULL, 7500, 1, '1671446743', '관리자', 'W', '01022223333', '7500', 119, 9),
(1295, '1945.09', '만두5개', '고기', NULL, 7500, 1, '1671446743', '관리자', 'W', '01022223333', '7500', 133, 9),
(1296, '1945.10', '수제비', '', NULL, 7500, 1, '1671446752', '관리자', '電', '01022223333', '7500', 119, 9),
(1297, '1945.10', '칼국수', '', NULL, 7000, 1, '1671446752', '관리자', '電', '01022223333', '7000', 120, 9),
(1298, '1946.11', '음료', '콜라', NULL, 1500, 1, '1671446773', '관리자', '05', '01022223333', '1500', 134, 9),
(1299, '1951.12', '수제비', '', NULL, 7500, 1, '1671447071', '관리자', '05', '01022223333', '7500', 119, 9),
(1300, '1951.12', '칼국수', '', NULL, 7000, 1, '1671447071', '관리자', '05', '01022223333', '7000', 120, 9),
(1301, '1951.13', '만두5개', '고기', NULL, 7500, 1, '1671447089', '관리자', '05', '01022223333', '7500', 133, 9),
(1302, '1951.13', '수제비', '', NULL, 7500, 1, '1671447089', '관리자', '05', '01022223333', '7500', 119, 9),
(1303, '1952.14', '수제비', '', NULL, 7500, 1, '1671447125', '관리자', '05', '01022223333', '7500', 119, 9),
(1304, '1958.59', '수제비', '', NULL, 7500, 1, '1671447494', '관리자', 'W', '01022223333', '7500', 119, 9),
(1305, '2024.60', '만두5개', '고기', NULL, 7500, 1, '1671449098', '관리자', '01', '01022223333', '7500', 133, 9),
(1306, '2025.61', '음료', '콜라', NULL, 1500, 1, '1671449121', '관리자', '05', '01022223333', '1500', 134, 9),
(1307, '2049.15', '칼국수', '', NULL, 7000, 1, '1671450547', '관리자', '02', '01022223333', '7000', 120, 9),
(1308, '2049.16', '칼국수', '', NULL, 7000, 1, '1671450569', '관리자', '02', '01022223333', '7000', 120, 9),
(1309, '2050.62', '칼국수', '', NULL, 7000, 1, '1671450625', '관리자', '03', '01022223333', '7000', 120, 9),
(1310, '2050.63', '칼국수', '', NULL, 7000, 1, '1671450645', '관리자', '03', '01022223333', '7000', 120, 9),
(1311, '2051.64', '공기밥', '', NULL, 1000, 1, '1671450661', '관리자', '03', '01022223333', '1000', 123, 9),
(1312, '2113.65', '만두5개', '김치', NULL, 7500, 15, '1671452035', '관리자', '04', '01022223333', '112500', 133, 9),
(1313, '2216.17', '음료', '콜라', NULL, 1500, 1, '1671455814', '관리자', '05', '01022223333', '1500', 134, 9),
(1314, '0716.66', '음료', '사이다', NULL, 1500, 1, '1671488200', '관리자', '04', '01022223333', '1500', 134, 9),
(1315, '0717.67', '칼국수', '', NULL, 7000, 1, '1671488247', '관리자', 'W', '01022223333', '7000', 120, 9),
(1316, '0717.67', '수제비', '', NULL, 7500, 1, '1671488247', '관리자', 'W', '01022223333', '7500', 119, 9),
(1317, '0920.18', '수제비', '', NULL, 7500, 1, '1671495603', '관리자', '02', '01022223333', '7500', 119, 9),
(1318, '0922.68', '만두5개', '고기', NULL, 7500, 1, '1671495746', '관리자', '電', '01022223333', '7500', 133, 9),
(1319, '1015.69', '수제비', '', NULL, 7500, 1, '1671498940', '관리자', '14', '01022223333', '7500', 119, 9),
(1322, '1208.71', '수제비', '', NULL, 7500, 1, '1671678520', '관리자', '06', '01022223333', '7500', 119, 9),
(1323, '1210.72', '공기밥', '', NULL, 1000, 1, '1671678638', '관리자', '05', '01022223333', '1000', 123, 9),
(1324, '1327.73', '만두5개', '김치', NULL, 7500, 3, '1671769634', '단골 손님', 'i', '01052545944', '22500', 133, 9),
(1325, '1327.73', '칼국수', '', NULL, 7000, 6, '1671769634', '단골 손님', 'i', '01052545944', '42000', 120, 9),
(1326, '1329.75', '칼국수', '', NULL, 7000, 1, '1671769755', '관리자', '05', '01022223333', '7000', 120, 9),
(1327, '1329.75', '수제비', '', NULL, 7500, 1, '1671769755', '관리자', '05', '01022223333', '7500', 119, 9),
(1328, '1801.77', '칼국수', '', NULL, 7000, 1, '1671786106', '단골 손님', 'i', '01052545944', '7000', 120, 9),
(1329, '1801.77', '수제비', '', NULL, 7500, 1, '1671786106', '단골 손님', 'i', '01052545944', '7500', 119, 9),
(1330, '1801.77', '만두5개', '김치', NULL, 7500, 1, '1671786106', '단골 손님', 'i', '01052545944', '7500', 133, 9),
(1331, '1801.77', '음료', '콜라', NULL, 1500, 1, '1671786106', '단골 손님', 'i', '01052545944', '1500', 134, 9),
(1332, '1344.78', '칼국수', '', NULL, 7000, 1, '1672029872', '관리자', '03', '01022223333', '7000', 120, 9),
(1333, '1344.78', '만두5개', '섞어', NULL, 7500, 2, '1672029872', '관리자', '03', '01022223333', '15000', 133, 9),
(1334, '1430.80', '칼국수', '', NULL, 7000, 1, '1672205459', '관리자', '電', '01022223333', '7000', 120, 9),
(1335, '1430.80', '만두5개', '섞어', NULL, 7500, 1, '1672205459', '관리자', '電', '01022223333', '7500', 133, 9),
(1336, '1702.81', '수제비', '', NULL, 7500, 1, '1672214548', '관리자', '02', '01022223333', '7500', 119, 9),
(1337, '1702.81', '칼국수', '', NULL, 7000, 1, '1672214548', '관리자', '02', '01022223333', '7000', 120, 9),
(1338, '1707.82', '칼국수', '', NULL, 7000, 1, '1672214839', '관리자', '07', '01022223333', '7000', 120, 9),
(1339, '1707.82', '수제비', '', NULL, 7500, 1, '1672214839', '관리자', '07', '01022223333', '7500', 119, 9),
(1437, '1345.47', '22', '2', NULL, 444444, 1, '1716353125', '단골 손님', '1', '01052545944', '444444', 223, 11),
(1426, '0727.34', '33', '', NULL, 5555, 1, '1716157621', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1424, '0726.33', '33', '', NULL, 5555, 1, '1716157602', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1423, '0726.32', '33', '', NULL, 5555, 1, '1716157572', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1422, '0723.31', '33', '', NULL, 5555, 1, '1716157386', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1421, '0722.30', '33', '', NULL, 5555, 1, '1716157356', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1420, '0722.29', '33', '', NULL, 5555, 1, '1716157339', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1419, '0718.27', '33', '', NULL, 5555, 1, '1716157131', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1418, '0714.26', '33', '', NULL, 5555, 1, '1716156867', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1417, '0709.24', '33', '', NULL, 5555, 1, '1716156556', '단골 손님', '2', '01052545944', '5555', 221, 11),
(1416, '0707.22', '33', '', NULL, 5555, 1, '1716156467', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1415, '0707.21', '33', '', NULL, 5555, 1, '1716156447', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1414, '0703.19', '33', '', NULL, 5555, 1, '1716156229', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1413, '0647.15', '33', '', NULL, 5555, 1, '1716155253', '단골 손님', '2', '01052545944', '5555', 221, 11),
(1412, '0646.14', '33', '', NULL, 5555, 1, '1716155217', '단골 손님', '대', '01052545944', '5555', 221, 11),
(1411, '0646.13', '33', '', NULL, 5555, 1, '1716155179', '단골 손님', '1', '01052545944', '5555', 221, 11),
(1410, '1948.12', '77', '', NULL, 7777, 1, '1716115711', '단골 손님', '2', '01052545944', '7777', 222, 11),
(1430, '0800.40', '미키비누', '', NULL, 5000, 1, '1716159608', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1429, '0759.38', '미키비누', '', NULL, 5000, 1, '1716159570', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1428, '0758.36', '미키비누', '', NULL, 5000, 1, '1716159518', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1427, '0730.35', '미키비누', '', NULL, 5000, 2, '1716157850', '단골 손님', '1', '01052545944', '10000', 219, 11),
(1425, '0726.33', '시계', '', NULL, 10000, 1, '1716157602', '단골 손님', '대', '01052545944', '15555', 220, 11),
(1439, '1843.49', '케이크', '', NULL, 20000, 1, '1716370988', '단골 손님', '祖母', '01052545944', '20000', 221, 11),
(1409, '1944.11', '시계', '', NULL, 10000, 1, '1716115493', '단골 손님', '1', '01052545944', '10000', 220, 11),
(1433, '1646.42', '미키비누', '투명', NULL, 5000, 1, '1716191182', '단골 손님', '3', '01052545944', '5000', 219, 11),
(1434, '1648.43', '미키비누', '블루', NULL, 5000, 5, '1716191305', '단골 손님', '대', '01052545944', '25000', 219, 11),
(1432, '1646.41', '케이크', '', NULL, 20000, 2, '1716191168', '단골 손님', '2', '01052545944', '45000', 221, 11),
(1431, '1646.41', '미키비누', '블루', NULL, 5000, 1, '1716191168', '단골 손님', '2', '01052545944', '5000', 219, 11),
(1435, '1649.44', '미키비누', '투명', NULL, 5000, 1, '1716191377', '단골 손님', '1', '01052545944', '5000', 219, 11),
(1436, '1959.45', '미키비누', '핑크', NULL, 5000, 1, '1716202757', '단골 손님', '2', '01052545944', '5000', 219, 11),
(1704, '0729.12', '미키비누', '블루', NULL, 5000, 1, '1730186983', '단골 손님', '할', '01052545944', '5000', 219, 11),
(1703, '0729.11', '미키비누', '블루', NULL, 5000, 1, '1730186963', '단골 손님', 'ㄷㄷㄷ', '01052545944', '5000', 219, 11),
(1702, '0052.10', '미키비누', '블루', NULL, 5000, 1, '1730163136', '단골 손님', 'ㅂ', '01052545944', '5000', 219, 11),
(1701, '0050.08', '미키비누', '블루', NULL, 5000, 1, '1730163059', '단골 손님', 'ㅂ', '01052545944', '5000', 219, 11),
(1700, '0050.07', '미키비누', '블루', NULL, 5000, 3, '1730163044', '단골 손님', '할아버지', '01052545944', '15000', 219, 11),
(1699, '0049.06', '미키비누', '블루', NULL, 5000, 1, '1730162972', '단골 손님', '할머니', '01052545944', '5000', 219, 11),
(1698, '0048.05', '미키비누', '블루', NULL, 5000, 1, '1730162926', '단골 손님', 'w', '01052545944', '5000', 219, 11),
(1697, '0046.04', '미키비누', '블루', NULL, 5000, 1, '1730162778', '단골 손님', 'www', '01052545944', '5000', 219, 11),
(1696, '0039.03', '미키비누', '블루', NULL, 5000, 1, '1730162396', '단골 손님', 'w', '01052545944', '5000', 219, 11),
(1695, '0038.02', '미키비누', '블루', NULL, 5000, 1, '1730162286', '단골 손님', '', '01052545944', '5000', 219, 11),
(1694, '0036.01', '미키비누', '블루', NULL, 5000, 1, '1730162160', '단골 손님', '', '01052545944', '5000', 219, 11),
(1693, '0032.00', '미키비누', '블루', NULL, 5000, 1, '1730161951', '단골 손님', 'qwww', '01052545944', '5000', 219, 11),
(1692, '0031.99', '미키비누', '블루', NULL, 5000, 1, '1730161915', '단골 손님', '', '01052545944', '5000', 219, 11),
(1691, '0027.98', '미키비누', '블루', NULL, 5000, 1, '1730161635', '단골 손님', '', '01052545944', '5000', 219, 11),
(1690, '0023.84', '미키비누', '블루', NULL, 5000, 1, '1730161403', '단골 손님', '', '01052545944', '5000', 219, 11),
(1689, '0020.77', '미키비누', '블루', NULL, 5000, 1, '1730161249', '단골 손님', '', '01052545944', '5000', 219, 11),
(1688, '0019.71', '미키비누', '블루', NULL, 5000, 1, '1730161144', '단골 손님', '', '01052545944', '5000', 219, 11),
(1687, '0018.69', '미키비누', '블루', NULL, 5000, 1, '1730161100', '단골 손님', '$abc2', '01052545944', '5000', 219, 11),
(1686, '0017.68', '미키비누', '블루', NULL, 5000, 1, '1730161047', '단골 손님', '$abc2', '01052545944', '5000', 219, 11),
(1685, '0016.67', '미키비누', '블루', NULL, 5000, 1, '1730161001', '단골 손님', '', '01052545944', '5000', 219, 11),
(1684, '0016.66', '미키비누', '블루', NULL, 5000, 1, '1730160969', '단골 손님', '', '01052545944', '5000', 219, 11),
(1683, '0015.65', '미키비누', '블루', NULL, 5000, 1, '1730160935', '단골 손님', '', '01052545944', '5000', 219, 11),
(1682, '0014.63', '미키비누', '블루', NULL, 5000, 1, '1730160860', '단골 손님', '', '01052545944', '5000', 219, 11),
(1681, '0007.55', '미키비누', '블루', NULL, 5000, 1, '1730160470', '단골 손님', '$abc', '01052545944', '5000', 219, 11),
(1680, '0006.54', '미키비누', '블루', NULL, 5000, 1, '1730160408', '단골 손님', '', '01052545944', '5000', 219, 11),
(1679, '0005.52', '미키비누', '블루', NULL, 5000, 1, '1730160340', '단골 손님', '', '01052545944', '5000', 219, 11),
(1678, '0003.50', '미키비누', '블루', NULL, 5000, 1, '1730160211', '단골 손님', '', '01052545944', '5000', 219, 11),
(1677, '0003.48', '미키비누', '블루', NULL, 5000, 1, '1730160186', '단골 손님', '', '01052545944', '5000', 219, 11),
(1676, '0002.47', '미키비누', '블루', NULL, 5000, 1, '1730160168', '단골 손님', '', '01052545944', '5000', 219, 11),
(1675, '0002.45', '미키비누', '블루', NULL, 5000, 1, '1730160136', '단골 손님', '', '01052545944', '5000', 219, 11),
(1674, '2348.34', '미키비누', '블루', NULL, 5000, 1, '1730159325', '단골 손님', '', '01052545944', '5000', 219, 11),
(1673, '2344.33', '미키비누', '블루', NULL, 5000, 1, '1730159083', '단골 손님', '111', '01052545944', '5000', 219, 11),
(1672, '2343.32', '미키비누', '블루', NULL, 5000, 1, '1730158985', '단골 손님', '111', '01052545944', '5000', 219, 11),
(1671, '2250.31', '미키비누', '블루', NULL, 5000, 1, '1730155842', '단골 손님', '1133', '01052545944', '5000', 219, 11),
(1670, '2250.30', '미키비누', '블루', NULL, 5000, 1, '1730155818', '단골 손님', '11', '01052545944', '5000', 219, 11),
(1669, '2248.29', '미키비누', '블루', NULL, 5000, 1, '1730155707', '단골 손님', '111', '01052545944', '5000', 219, 11),
(1668, '2241.28', '미키비누', '블루', NULL, 5000, 1, '1730155285', '단골 손님', '할아버지', '01052545944', '5000', 219, 11),
(1667, '2238.27', '미키비누', '블루', NULL, 5000, 1, '1730155125', '단골 손님', '2', '01052545944', '5000', 219, 11),
(1666, '2137.25', '미키비누', '블루', NULL, 5000, 1, '1730151429', '단골 손님', '할아버지', '01052545944', '5000', 219, 11),
(1665, '2136.22', '미키비누', '블루', NULL, 5000, 1, '1730151385', '단골 손님', 'aaa', '01052545944', '5000', 219, 11),
(1664, '2136.21', '미키비누', '블루', NULL, 5000, 1, '1730151373', '단골 손님', '할머니', '01052545944', '5000', 219, 11),
(1663, '2135.20', '미키비누', '블루', NULL, 5000, 1, '1730151355', '단골 손님', '사물함', '01052545944', '5000', 219, 11),
(1662, '1401.19', '미키비누', '블루', NULL, 5000, 1, '1730124108', '단골 손님', 'aaa', '01052545944', '5000', 219, 11),
(1661, '1401.18', '미키비누', '블루', NULL, 5000, 1, '1730124082', '단골 손님', '111', '01052545944', '5000', 219, 11),
(1660, '1358.17', '미키비누', '블루', NULL, 5000, 1, '1730123894', '단골 손님', 'qqqq', '01052545944', '5000', 219, 11),
(1659, '1333.16', '미키비누', '블루', NULL, 5000, 1, '1730122411', '단골 손님', '할머니', '01052545944', '5000', 219, 11),
(1658, '1310.15', '미키비누', '블루', NULL, 5000, 1, '1730121034', '단골 손님', 'abcdefg', '01052545944', '5000', 219, 11),
(1657, '1310.14', '미키비누', '블루', NULL, 5000, 1, '1730121002', '단골 손님', 'abcdefg', '01052545944', '5000', 219, 11),
(1656, '1303.13', '미키비누', '블루', NULL, 5000, 1, '1730120611', '단골 손님', 'ee', '01052545944', '5000', 219, 11),
(1655, '1301.12', '미키비누', '블루', NULL, 5000, 1, '1730120515', '단골 손님', 'ddd', '01052545944', '5000', 219, 11),
(1654, '1300.11', '미키비누', '블루', NULL, 5000, 1, '1730120450', '단골 손님', 'e', '01052545944', '5000', 219, 11),
(1653, '1259.10', '미키비누', '블루', NULL, 5000, 1, '1730120389', '단골 손님', '', '01052545944', '5000', 219, 11),
(1652, '1255.09', '미키비누', '블루', NULL, 5000, 1, '1730120146', '단골 손님', '', '01052545944', '5000', 219, 11),
(1651, '1255.07', '미키비누', '블루', NULL, 5000, 1, '1730120122', '단골 손님', '', '01052545944', '5000', 219, 11),
(1650, '1254.05', '미키비누', '블루', NULL, 5000, 1, '1730120099', '단골 손님', '', '01052545944', '5000', 219, 11),
(1649, '1252.03', '미키비누', '블루', NULL, 5000, 1, '1730119965', '단골 손님', '', '01052545944', '5000', 219, 11),
(1648, '1252.01', '미키비누', '블루', NULL, 5000, 1, '1730119948', '단골 손님', '', '01052545944', '5000', 219, 11),
(1647, '1247.99', '미키비누', '블루', NULL, 5000, 1, '1730119670', '단골 손님', '', '01052545944', '5000', 219, 11),
(1646, '1239.96', '미키비누', '블루', NULL, 5000, 1, '1730119173', '단골 손님', '', '01052545944', '5000', 219, 11),
(1645, '1036.94', '미키비누', '블루', NULL, 5000, 1, '1730111802', '단골 손님', '', '01052545944', '5000', 219, 11),
(1644, '1001.93', '미키비누', '블루', NULL, 5000, 1, '1730109686', '단골 손님', '', '01052545944', '5000', 219, 11),
(1643, '0953.92', '미키비누', '블루', NULL, 5000, 1, '1730109209', '단골 손님', 'q', '01052545944', '5000', 219, 11),
(1642, '0952.91', '미키비누', '블루', NULL, 5000, 1, '1730109146', '단골 손님', 'wwss', '01052545944', '5000', 219, 11),
(1641, '0952.90', '미키비누', '블루', NULL, 5000, 1, '1730109134', '단골 손님', '', '01052545944', '5000', 219, 11),
(1640, '0952.89', '미키비누', '블루', NULL, 5000, 1, '1730109126', '단골 손님', 'ww', '01052545944', '5000', 219, 11),
(1639, '0950.88', '미키비누', '블루', NULL, 5000, 1, '1730109029', '단골 손님', 'r', '01052545944', '5000', 219, 11),
(1638, '0950.87', '미키비누', '블루', NULL, 5000, 1, '1730109018', '단골 손님', '', '01052545944', '5000', 219, 11),
(1637, '0950.86', '미키비누', '블루', NULL, 5000, 1, '1730109003', '단골 손님', 'w', '01052545944', '5000', 219, 11),
(1636, '0949.85', '미키비누', '블루', NULL, 5000, 1, '1730108988', '단골 손님', 'w', '01052545944', '5000', 219, 11),
(1635, '0948.84', '미키비누', '블루', NULL, 5000, 1, '1730108896', '단골 손님', '', '01052545944', '5000', 219, 11),
(1634, '0947.83', '미키비누', '블루', NULL, 5000, 1, '1730108844', '단골 손님', '', '01052545944', '5000', 219, 11),
(1633, '0944.82', '미키비누', '블루', NULL, 5000, 1, '1730108685', '단골 손님', '', '01052545944', '5000', 219, 11),
(1632, '0942.81', '미키비누', '블루', NULL, 5000, 1, '1730108558', '단골 손님', '', '01052545944', '5000', 219, 11),
(1631, '0941.80', '미키비누', '블루', NULL, 5000, 1, '1730108462', '단골 손님', '', '01052545944', '5000', 219, 11),
(1630, '0940.79', '미키비누', '블루', NULL, 5000, 1, '1730108440', '단골 손님', 'www', '01052545944', '5000', 219, 11),
(1629, '0938.78', '미키비누', '블루', NULL, 5000, 1, '1730108321', '단골 손님', 'ww', '01052545944', '5000', 219, 11),
(1628, '0937.77', '미키비누', '블루', NULL, 5000, 1, '1730108259', '단골 손님', '', '01052545944', '5000', 219, 11),
(1627, '0935.76', '미키비누', '블루', NULL, 5000, 1, '1730108156', '단골 손님', 'a', '01052545944', '5000', 219, 11),
(1626, '0932.75', '미키비누', '블루', NULL, 5000, 1, '1730107920', '단골 손님', '', '01052545944', '5000', 219, 11),
(1625, '0931.74', '미키비누', '블루', NULL, 5000, 1, '1730107900', '단골 손님', '', '01052545944', '5000', 219, 11),
(1624, '0922.73', '미키비누', '블루', NULL, 5000, 1, '1730107360', '단골 손님', '', '01052545944', '5000', 219, 11),
(1623, '0918.72', '미키비누', '블루', NULL, 5000, 1, '1730107112', '단골 손님', '', '01052545944', '5000', 219, 11),
(1622, '0918.71', '미키비누', '블루', NULL, 5000, 1, '1730107097', '단골 손님', '', '01052545944', '5000', 219, 11),
(1621, '0917.70', '미키비누', '블루', NULL, 5000, 1, '1730107079', '단골 손님', 'q', '01052545944', '5000', 219, 11),
(1620, '0917.69', '미키비누', '블루', NULL, 5000, 1, '1730107064', '단골 손님', '', '01052545944', '5000', 219, 11),
(1619, '0917.68', '미키비누', '블루', NULL, 5000, 1, '1730107053', '단골 손님', 'qqq', '01052545944', '5000', 219, 11),
(1618, '0915.67', '미키비누', '블루', NULL, 5000, 1, '1730106922', '단골 손님', 'q', '01052545944', '5000', 219, 11),
(1617, '0914.66', '미키비누', '블루', NULL, 5000, 1, '1730106897', '단골 손님', '', '01052545944', '5000', 219, 11),
(1616, '0914.65', '미키비누', '블루', NULL, 5000, 1, '1730106866', '단골 손님', '', '01052545944', '5000', 219, 11),
(1615, '0911.64', '미키비누', '블루', NULL, 5000, 1, '1730106683', '단골 손님', 'q', '01052545944', '5000', 219, 11),
(1614, '0911.63', '미키비누', '블루', NULL, 5000, 1, '1730106667', '단골 손님', '', '01052545944', '5000', 219, 11),
(1613, '0907.62', '미키비누', '블루', NULL, 5000, 1, '1730106473', '단골 손님', '', '01052545944', '5000', 219, 11),
(1612, '0905.61', '미키비누', '블루', NULL, 5000, 1, '1730106309', '단골 손님', '', '01052545944', '5000', 219, 11),
(1611, '0904.60', '미키비누', '블루', NULL, 5000, 1, '1730106293', '단골 손님', '', '01052545944', '5000', 219, 11),
(1610, '0904.59', '미키비누', '블루', NULL, 5000, 1, '1730106259', '단골 손님', '6', '01052545944', '5000', 219, 11),
(1609, '0904.58', '미키비누', '블루', NULL, 5000, 1, '1730106241', '단골 손님', '', '01052545944', '5000', 219, 11),
(1608, '0903.57', '미키비누', '블루', NULL, 5000, 1, '1730106229', '단골 손님', '', '01052545944', '5000', 219, 11),
(1607, '0903.55', '미키비누', '블루', NULL, 5000, 1, '1730106210', '단골 손님', '5', '01052545944', '5000', 219, 11),
(1606, '0903.54', '미키비누', '블루', NULL, 5000, 1, '1730106197', '단골 손님', '', '01052545944', '5000', 219, 11),
(1605, '0903.53', '미키비누', '블루', NULL, 5000, 1, '1730106187', '단골 손님', '4', '01052545944', '5000', 219, 11),
(1604, '0902.52', '미키비누', '블루', NULL, 5000, 1, '1730106164', '단골 손님', '', '01052545944', '5000', 219, 11),
(1603, '0902.51', '미키비누', '블루', NULL, 5000, 1, '1730106121', '단골 손님', '22', '01052545944', '5000', 219, 11),
(1602, '0852.50', '미키비누', '블루', NULL, 5000, 1, '1730105547', '단골 손님', '222', '01052545944', '5000', 219, 11),
(1601, '0850.49', '미키비누', '블루', NULL, 5000, 1, '1730105444', '단골 손님', '', '01052545944', '5000', 219, 11),
(1600, '0849.48', '미키비누', '블루', NULL, 5000, 1, '1730105370', '단골 손님', '', '01052545944', '5000', 219, 11),
(1599, '0848.47', '미키비누', '블루', NULL, 5000, 1, '1730105322', '단골 손님', '', '01052545944', '5000', 219, 11),
(1598, '0848.46', '미키비누', '블루', NULL, 5000, 1, '1730105310', '단골 손님', '', '01052545944', '5000', 219, 11),
(1597, '0847.45', '미키비누', '블루', NULL, 5000, 1, '1730105262', '단골 손님', '', '01052545944', '5000', 219, 11),
(1596, '0846.44', '미키비누', '블루', NULL, 5000, 1, '1730105211', '단골 손님', '', '01052545944', '5000', 219, 11),
(1595, '0846.43', '미키비누', '블루', NULL, 5000, 1, '1730105200', '단골 손님', '', '01052545944', '5000', 219, 11),
(1594, '0845.42', '미키비누', '블루', NULL, 5000, 1, '1730105145', '단골 손님', '', '01052545944', '5000', 219, 11),
(1593, '0843.41', '미키비누', '블루', NULL, 5000, 1, '1730104983', '단골 손님', '', '01052545944', '5000', 219, 11),
(1592, '0842.40', '미키비누', '블루', NULL, 5000, 1, '1730104939', '단골 손님', '', '01052545944', '5000', 219, 11),
(1591, '0841.39', '미키비누', '블루', NULL, 5000, 1, '1730104871', '단골 손님', '', '01052545944', '5000', 219, 11),
(1590, '0840.38', '미키비누', '블루', NULL, 5000, 1, '1730104839', '단골 손님', '', '01052545944', '5000', 219, 11),
(1589, '0840.37', '미키비누', '블루', NULL, 5000, 1, '1730104817', '단골 손님', '', '01052545944', '5000', 219, 11),
(1588, '0839.36', '미키비누', '블루', NULL, 5000, 1, '1730104790', '단골 손님', '', '01052545944', '5000', 219, 11),
(1587, '0839.35', '미키비누', '블루', NULL, 5000, 1, '1730104776', '단골 손님', '', '01052545944', '5000', 219, 11),
(1586, '0838.34', '미키비누', '블루', NULL, 5000, 1, '1730104734', '단골 손님', '', '01052545944', '5000', 219, 11),
(1585, '0835.33', '미키비누', '블루', NULL, 5000, 1, '1730104525', '단골 손님', '', '01052545944', '5000', 219, 11),
(1584, '0834.32', '미키비누', '블루', NULL, 5000, 1, '1730104499', '단골 손님', '', '01052545944', '5000', 219, 11),
(1583, '0817.31', '미키비누', '블루', NULL, 5000, 1, '1730103451', '단골 손님', '', '01052545944', '5000', 219, 11),
(1582, '0816.30', '미키비누', '블루', NULL, 5000, 1, '1730103398', '단골 손님', '', '01052545944', '5000', 219, 11),
(1581, '0814.29', '미키비누', '블루', NULL, 5000, 1, '1730103285', '단골 손님', '', '01052545944', '5000', 219, 11),
(1580, '0810.28', '미키비누', '블루', NULL, 5000, 1, '1730103003', '단골 손님', '', '01052545944', '5000', 219, 11),
(1579, '0804.27', '미키비누', '블루', NULL, 5000, 1, '1730102661', '단골 손님', '778', '01052545944', '5000', 219, 11),
(1578, '0804.26', '미키비누', '블루', NULL, 5000, 1, '1730102649', '단골 손님', '', '01052545944', '5000', 219, 11),
(1577, '0803.25', '미키비누', '블루', NULL, 5000, 1, '1730102639', '단골 손님', '', '01052545944', '5000', 219, 11),
(1576, '0803.24', '미키비누', '블루', NULL, 5000, 1, '1730102582', '단골 손님', 'eeett', '01052545944', '5000', 219, 11),
(1575, '0802.23', '미키비누', '블루', NULL, 5000, 1, '1730102544', '단골 손님', '', '01052545944', '5000', 219, 11),
(1574, '0801.22', '미키비누', '블루', NULL, 5000, 1, '1730102488', '단골 손님', '', '01052545944', '5000', 219, 11),
(1573, '0801.21', '미키비누', '블루', NULL, 5000, 1, '1730102464', '단골 손님', '', '01052545944', '5000', 219, 11),
(1572, '0753.20', '미키비누', '블루', NULL, 5000, 1, '1730102009', '단골 손님', 'tt', '01052545944', '5000', 219, 11),
(1571, '0751.19', '미키비누', '블루', NULL, 5000, 1, '1730101874', '단골 손님', 'hhh', '01052545944', '5000', 219, 11),
(1570, '0750.18', '미키비누', '블루', NULL, 5000, 1, '1730101839', '단골 손님', '555', '01052545944', '5000', 219, 11),
(1569, '0750.17', '미키비누', '블루', NULL, 5000, 1, '1730101828', '단골 손님', 'kkkk', '01052545944', '5000', 219, 11),
(1568, '0741.12', '미키비누', '블루', NULL, 5000, 1, '1730101314', '단골 손님', 'aa', '01052545944', '5000', 219, 11),
(1567, '0739.16', '미키비누', '블루', NULL, 5000, 1, '1730101155', '단골 손님', 'hh', '01052545944', '5000', 219, 11),
(1566, '0737.15', '미키비누', '블루', NULL, 5000, 1, '1730101056', '단골 손님', 'kkkkk', '01052545944', '5000', 219, 11),
(1565, '0031.13', '미키비누', '블루', NULL, 5000, 1, '1730075519', '단골 손님', 'qqq', '01052545944', '5000', 219, 11),
(1564, '0031.12', '미키비누', '블루', NULL, 5000, 1, '1730075469', '단골 손님', 'qqq', '01052545944', '5000', 219, 11),
(1563, '2308.11', '미키비누', '블루', NULL, 5000, 1, '1730070527', '단골 손님', 'g', '01052545944', '5000', 219, 11),
(1562, '2308.10', '미키비누', '블루', NULL, 5000, 1, '1730070520', '단골 손님', 'f', '01052545944', '5000', 219, 11),
(1561, '2308.09', '미키비누', '블루', NULL, 5000, 1, '1730070511', '단골 손님', 'd', '01052545944', '5000', 219, 11),
(1560, '2308.08', '미키비누', '블루', NULL, 5000, 1, '1730070503', '단골 손님', 's', '01052545944', '5000', 219, 11),
(1559, '2308.07', '미키비누', '블루', NULL, 5000, 1, '1730070496', '단골 손님', 'a', '01052545944', '5000', 219, 11),
(1558, '2301.15', '미키비누', '블루', NULL, 5000, 3, '1730070105', '단골 손님', '7', '01052545944', '15000', 219, 11),
(1557, '2301.14', '미키비누', '블루', NULL, 5000, 2, '1730070097', '단골 손님', '7', '01052545944', '10000', 219, 11),
(1556, '2301.13', '미키비누', '블루', NULL, 5000, 1, '1730070087', '단골 손님', '7', '01052545944', '5000', 219, 11),
(1555, '2247.12', '미키비누', '블루', NULL, 5000, 3, '1730069223', '단골 손님', '3', '01052545944', '15000', 219, 11),
(1554, '2246.11', '미키비누', '블루', NULL, 5000, 2, '1730069215', '단골 손님', '2', '01052545944', '10000', 219, 11),
(1553, '2246.10', '미키비누', '블루', NULL, 5000, 1, '1730069206', '단골 손님', '1', '01052545944', '5000', 219, 11),
(1552, '2236.09', '미키비누', '블루', NULL, 5000, 2, '1730068568', '단골 손님', '9', '01052545944', '10000', 219, 11),
(1551, '2235.08', '미키비누', '블루', NULL, 5000, 1, '1730068559', '단골 손님', '3', '01052545944', '5000', 219, 11),
(1550, '2234.07', '미키비누', '블루', NULL, 5000, 1, '1730068458', '단골 손님', '5', '01052545944', '5000', 219, 11),
(1549, '2234.06', '미키비누', '블루', NULL, 5000, 2, '1730068449', '단골 손님', '7', '01052545944', '10000', 219, 11),
(1548, '2233.05', '미키비누', '블루', NULL, 5000, 1, '1730068399', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1547, '2223.04', '미키비누', '블루', NULL, 5000, 3, '1730067795', '단골 손님', '祖母', '01052545944', '15000', 219, 11),
(1546, '2221.05', '미키비누', '블루', NULL, 5000, 1, '1730067691', '단골 손님', 'ww', '01052545944', '5000', 219, 11),
(1545, '2216.04', '미키비누', '블루', NULL, 5000, 1, '1730067388', '단골 손님', 'www', '01052545944', '5000', 219, 11),
(1544, '2215.03', '미키비누', '블루', NULL, 5000, 1, '1730067334', '단골 손님', 'sss', '01052545944', '5000', 219, 11),
(1543, '2215.03', '미키비누', '블루', NULL, 5000, 1, '1730067301', '단골 손님', '9', '01052545944', '5000', 219, 11),
(1542, '2212.39', '미키비누', '블루', NULL, 5000, 1, '1730067153', '단골 손님', '祖母', '01052545944', '5000', 219, 11),
(1541, '2211.38', '미키비누', '블루', NULL, 5000, 2, '1730067061', '단골 손님', '7', '01052545944', '10000', 219, 11),
(1540, '0802.35', '미키비누', '블루', NULL, 5000, 1, '1730016122', '단골 손님', 'ww', '01052545944', '5000', 219, 11),
(1539, '0800.34', '미키비누', '블루', NULL, 5000, 1, '1730016008', '단골 손님', 'kang', '01052545944', '5000', 219, 11),
(1538, '0759.37', '미키비누', '블루', NULL, 5000, 1, '1730015971', '단골 손님', '6', '01052545944', '5000', 219, 11),
(1537, '0755.36', '미키비누', '블루', NULL, 5000, 1, '1730015757', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1536, '0755.35', '미키비누', '블루', NULL, 5000, 1, '1730015747', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1535, '0753.34', '미키비누', '블루', NULL, 5000, 1, '1730015584', '단골 손님', 'kk', '01052545944', '5000', 219, 11),
(1534, '0740.33', '미키비누', '블루', NULL, 5000, 1, '1730014821', '단골 손님', '', '01052545944', '5000', 219, 11),
(1533, '0739.32', '미키비누', '블루', NULL, 5000, 1, '1730014744', '단골 손님', 'klj', '01052545944', '5000', 219, 11),
(1532, '0728.31', '미키비누', '블루', NULL, 5000, 1, '1730014129', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1531, '0721.30', '미키비누', '블루', NULL, 5000, 1, '1730013661', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1530, '0711.29', '미키비누', '블루', NULL, 5000, 1, '1730013105', '단골 손님', 'kkkk', '01052545944', '5000', 219, 11),
(1529, '0711.28', '미키비누', '블루', NULL, 5000, 1, '1730013089', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1528, '0707.27', '미키비누', '블루', NULL, 5000, 1, '1730012861', '단골 손님', '9', '01052545944', '5000', 219, 11),
(1527, '0707.26', '미키비누', '블루', NULL, 5000, 1, '1730012839', '단골 손님', 'ffhh', '01052545944', '5000', 219, 11),
(1526, '0700.25', '미키비누', '블루', NULL, 5000, 1, '1730012434', '단골 손님', '5', '01052545944', '5000', 219, 11),
(1525, '0700.24', '미키비누', '블루', NULL, 5000, 1, '1730012415', '단골 손님', 'kkkh', '01052545944', '5000', 219, 11),
(1524, '0659.23', '미키비누', '블루', NULL, 5000, 1, '1730012397', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1523, '0659.22', '미키비누', '블루', NULL, 5000, 1, '1730012360', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1522, '0659.21', '미키비누', '블루', NULL, 5000, 1, '1730012341', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1521, '0658.20', '미키비누', '블루', NULL, 5000, 1, '1730012322', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1520, '0658.19', '미키비누', '블루', NULL, 5000, 1, '1730012311', '단골 손님', 'kkkk', '01052545944', '5000', 219, 11),
(1519, '0654.18', '미키비누', '블루', NULL, 5000, 1, '1730012043', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1518, '0653.17', '미키비누', '블루', NULL, 5000, 1, '1730012030', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1517, '0635.16', '미키비누', '블루', NULL, 5000, 1, '1730010953', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1516, '0627.15', '미키비누', '블루', NULL, 5000, 1, '1730010438', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1515, '0624.14', '미키비누', '블루', NULL, 5000, 1, '1730010277', '단골 손님', '10', '01052545944', '5000', 219, 11),
(1514, '0623.13', '미키비누', '블루', NULL, 5000, 1, '1730010208', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1513, '0619.12', '미키비누', '블루', NULL, 5000, 1, '1730009979', '단골 손님', 'www', '01052545944', '5000', 219, 11),
(1512, '0618.11', '미키비누', '블루', NULL, 5000, 1, '1730009894', '단골 손님', '', '01052545944', '5000', 219, 11),
(1511, '0615.10', '미키비누', '블루', NULL, 5000, 1, '1730009726', '단골 손님', '', '01052545944', '5000', 219, 11),
(1510, '0558.09', '미키비누', '블루', NULL, 5000, 1, '1730008686', '단골 손님', 'kkkk', '01052545944', '5000', 219, 11),
(1509, '0548.08', '미키비누', '블루', NULL, 5000, 1, '1730008126', '단골 손님', 'kkk', '01052545944', '5000', 219, 11),
(1508, '0214.07', '미키비누', '블루', NULL, 5000, 1, '1729995252', '단골 손님', 'ffff', '01052545944', '5000', 219, 11),
(1507, '0203.06', '미키비누', '블루', NULL, 5000, 1, '1729994591', '단골 손님', 'tttt', '01052545944', '5000', 219, 11),
(1506, '0158.05', '미키비누', '블루', NULL, 5000, 1, '1729994303', '단골 손님', 'sss', '01052545944', '5000', 219, 11),
(1505, '0154.04', '미키비누', '블루', NULL, 5000, 1, '1729994063', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1504, '0153.03', '미키비누', '블루', NULL, 5000, 1, '1729993980', '단골 손님', '대', '01052545944', '5000', 219, 11);
INSERT INTO `orders_backup` (`order_ID`, `order_number`, `foodname`, `choice`, `status`, `price`, `quantity`, `order_date`, `username`, `table_nr`, `contact`, `gtotal`, `F_ID`, `R_ID`) VALUES
(1503, '0152.02', '미키비누', '블루', NULL, 5000, 1, '1729993931', '단골 손님', '電', '01052545944', '5000', 219, 11),
(1502, '0148.01', '미키비누', '블루', NULL, 5000, 1, '1729993726', '단골 손님', '', '01052545944', '5000', 219, 11),
(1501, '0147.00', '미키비누', '블루', NULL, 5000, 1, '1729993630', '단골 손님', '', '01052545944', '5000', 219, 11),
(1500, '0146.99', '미키비누', '블루', NULL, 5000, 1, '1729993568', '단골 손님', 'fast', '01052545944', '5000', 219, 11),
(1499, '0145.98', '미키비누', '블루', NULL, 5000, 1, '1729993557', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1498, '0145.97', '미키비누', '블루', NULL, 5000, 1, '1729993535', '단골 손님', '9', '01052545944', '5000', 219, 11),
(1497, '0145.96', '미키비누', '블루', NULL, 5000, 1, '1729993520', '단골 손님', 'dddd', '01052545944', '5000', 219, 11),
(1496, '0142.95', '미키비누', '블루', NULL, 5000, 1, '1729993370', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1495, '0142.94', '미키비누', '블루', NULL, 5000, 1, '1729993357', '단골 손님', '', '01052545944', '5000', 219, 11),
(1494, '0142.93', '미키비누', '블루', NULL, 5000, 1, '1729993337', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1493, '0142.92', '미키비누', '블루', NULL, 5000, 1, '1729993322', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1492, '0141.91', '미키비누', '블루', NULL, 5000, 1, '1729993302', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1491, '0139.90', '미키비누', '블루', NULL, 5000, 1, '1729993174', '단골 손님', 'ㅎㅎ', '01052545944', '5000', 219, 11),
(1490, '0139.89', '미키비누', '블루', NULL, 5000, 1, '1729993161', '단골 손님', '', '01052545944', '5000', 219, 11),
(1489, '0139.88', '미키비누', '블루', NULL, 5000, 1, '1729993140', '단골 손님', 'ㅎㅎㅎㅎ', '01052545944', '5000', 219, 11),
(1488, '0131.87', '미키비누', '블루', NULL, 5000, 1, '1729992715', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1487, '0131.86', '미키비누', '블루', NULL, 5000, 1, '1729992675', '단골 손님', '', '01052545944', '5000', 219, 11),
(1486, '0130.85', '미키비누', '블루', NULL, 5000, 1, '1729992622', '단골 손님', '', '01052545944', '5000', 219, 11),
(1485, '0130.84', '미키비누', '블루', NULL, 5000, 1, '1729992610', '단골 손님', '', '01052545944', '5000', 219, 11),
(1484, '0130.83', '미키비누', '블루', NULL, 5000, 1, '1729992600', '단골 손님', 'ㄴㄴ', '01052545944', '5000', 219, 11),
(1483, '0128.82', '미키비누', '블루', NULL, 5000, 1, '1729992534', '단골 손님', 'ㄴㄴㄴ', '01052545944', '5000', 219, 11),
(1482, '0118.81', '미키비누', '블루', NULL, 5000, 1, '1729991912', '단골 손님', 'ㅇㅇㅇㅇㅇ', '01052545944', '5000', 219, 11),
(1481, '0055.80', '미키비누', '블루', NULL, 5000, 1, '1729990514', '단골 손님', '김영호가족', '01052545944', '5000', 219, 11),
(1480, '0015.79', '미키비누', '블루', NULL, 5000, 1, '1729988138', '단골 손님', '다', '01052545944', '5000', 219, 11),
(1479, '0003.78', '미키비누', '블루', NULL, 5000, 1, '1729987394', '단골 손님', '교', '01052545944', '5000', 219, 11),
(1478, '2358.77', '미키비누', '블루', NULL, 5000, 1, '1729987131', '단골 손님', '철수', '01052545944', '5000', 219, 11),
(1477, '2358.76', '미키비누', '블루', NULL, 5000, 1, '1729987107', '단골 손님', 'ddddd', '01052545944', '5000', 219, 11),
(1476, '2313.75', '미키비누', '블루', NULL, 5000, 1, '1729984411', '단골 손님', '1', '01052545944', '5000', 219, 11),
(1475, '2313.74', '미키비누', '블루', NULL, 5000, 1, '1729984397', '단골 손님', '1', '01052545944', '5000', 219, 11),
(1474, '2308.73', '미키비누', '블루', NULL, 5000, 1, '1729984103', '단골 손님', '母', '01052545944', '5000', 219, 11),
(1473, '2308.72', '미키비누', '블루', NULL, 5000, 2, '1729984095', '단골 손님', '祖父', '01052545944', '10000', 219, 11),
(1472, '2307.71', '미키비누', '블루', NULL, 5000, 4, '1729984040', '단골 손님', '', '01052545944', '20000', 219, 11),
(1471, '2306.70', '미키비누', '블루', NULL, 5000, 3, '1729984003', '단골 손님', '', '01052545944', '15000', 219, 11),
(1470, '2305.69', '미키비누', '블루', NULL, 5000, 1, '1729983925', '단골 손님', '', '01052545944', '5000', 219, 11),
(1469, '2305.68', '미키비누', '블루', NULL, 5000, 1, '1729983915', '단골 손님', '', '01052545944', '5000', 219, 11),
(1468, '2253.67', '미키비누', '블루', NULL, 5000, 1, '1729983192', '단골 손님', '電', '01052545944', '5000', 219, 11),
(1467, '2149.66', '미키비누', '블루', NULL, 5000, 1, '1729979387', '단골 손님', '', '01052545944', '5000', 219, 11),
(1466, '2145.65', '미키비누', '블루', NULL, 5000, 1, '1729979104', '단골 손님', '12', '01052545944', '5000', 219, 11),
(1465, '2144.64', '미키비누', '블루', NULL, 5000, 1, '1729979068', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1464, '2143.63', '미키비누', '블루', NULL, 5000, 1, '1729979035', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1463, '2143.62', '미키비누', '블루', NULL, 5000, 1, '1729979019', '단골 손님', '대', '01052545944', '5000', 219, 11),
(1462, '2142.61', '미키비누', '블루', NULL, 5000, 10, '1729978964', '단골 손님', '대', '01052545944', '50000', 219, 11),
(1461, '2127.59', '미키비누', '블루', NULL, 5000, 5, '1729978049', '단골 손님', '1', '01052545944', '25000', 219, 11),
(1459, '1937.19', '수제비', '', NULL, 7500, 1, '1726601872', '관리자', '16', '01022223333', '7500', 119, 9),
(1458, '1935.18', '수제비', '', NULL, 7500, 7, '1726601708', '관리자', '16', '01022223333', '52500', 119, 9),
(1457, '1136.16', '만두5개', '섞어', NULL, 7500, 3, '1726573008', '관리자', '15', '01022223333', '22500', 133, 9),
(1456, '1136.13', '만두5개', '고기', NULL, 7500, 3, '1726572978', '단골 손님', 'i', '01052545944', '22500', 133, 9),
(1455, '1136.12', '만두5개', '고기', NULL, 7500, 1, '1726572963', '단골 손님', 'i', '01052545944', '7500', 133, 9),
(1454, '1134.10', '만두5개', '고기', NULL, 7500, 1, '1726572895', '관리자', '14', '01022223333', '7500', 133, 9),
(1453, '1134.09', '칼국수', '', NULL, 7000, 1, '1726572876', '관리자', '15', '01022223333', '7000', 120, 9),
(1452, '1010.08', '칼국수', '', NULL, 7000, 1, '1726567813', '관리자', '14', '01022223333', '7000', 120, 9),
(1451, '1009.07', '만두5개', '김치', NULL, 7500, 3, '1726567767', '관리자', '14', '01022223333', '22500', 133, 9),
(1450, '1008.06', '만두5개', '김치', NULL, 7500, 1, '1726567704', '관리자', '14', '01022223333', '7500', 133, 9),
(1710, '0809.17', '꿀비누', '', NULL, 3000, 1, '1730189359', '단골 손님', '1', '01052545944', '3000', 226, 11),
(1708, '0800.15', '미키비누', '블루', NULL, 5000, 1, '1730188846', '단골 손님', '할머니', '01052545944', '9000', 219, 11),
(1707, '0800.15', '하트비누', '', NULL, 4000, 1, '1730188846', '단골 손님', '할머니', '01052545944', '4000', 224, 11),
(1705, '0731.13', '미키비누', '블루', NULL, 5000, 1, '1730187075', '단골 손님', '할머니가족', '01052545944', '5000', 219, 11),
(1709, '0807.16', '꿀비누', '', NULL, 4000, 1, '1730189253', '단골 손님', '할아버지', '01052545944', '4000', 225, 11),
(1712, '0834.19', '하트비누', '', NULL, 4000, 1, '1730190881', '단골 손님', '할아버지', '01052545944', '4000', 224, 11),
(1717, '0556.24', '미키비누', '블루', NULL, 5000, 1, '1730235390', '단골 손님', '7', '01052545944', '5000', 219, 11),
(1716, '0554.23', '미키비누', '블루', NULL, 5000, 1, '1730235241', '단골 손님', '8', '01052545944', '5000', 219, 11),
(1715, '2053.22', '꿀비누', '', NULL, 3000, 1, '1730235195', '단골 손님', '7', '01052545944', '3000', 226, 11),
(1714, '2046.21', '꿀비누', '', NULL, 3000, 1, '1730234762', '단골 손님', '2', '01052545944', '3000', 226, 11),
(1713, '2045.20', '미키비누', '블루', NULL, 5000, 1, '1730234753', '단골 손님', '2', '01052545944', '5000', 219, 11),
(1706, '0731.14', '미키비누', '블루', NULL, 5000, 1, '1730187117', '단골 손님', '할머니가족', '01052545944', '5000', 219, 11),
(1445, '0953.55', '미키비누', '블루', NULL, 5000, 1, '1726566839', '단골 손님', '7', '01052545944', '12500', 219, 11),
(1441, '0915.51', '미키비누', '블루', NULL, 5000, 1, '1717892137', '단골 손님', '2', '01052545944', '5000', 219, 11),
(1440, '0818.50', '미키비누', '투명', NULL, 5000, 1, '1716419889', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1438, '1830.48', '미키비누', '블루', NULL, 5000, 1, '1716370247', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1720, '0621.27', '하트비누', '', NULL, 4000, 1, '1730236915', '단골 손님', '祖부', '01052545944', '4000', 224, 11),
(1719, '0621.26', '미키비누', '블루', NULL, 5000, 1, '1730236893', '단골 손님', '祖모', '01052545944', '5000', 219, 11),
(1718, '0600.25', '미키비누', '블루', NULL, 5000, 1, '1730235617', '단골 손님', '할아버지', '01052545944', '5000', 219, 11),
(1460, '1938.57', '미키비누', '블루', NULL, 5000, 1, '1726601930', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1729, '0637.38', '미키비누', '블루', NULL, 5000, 1, '1730237877', '단골 손님', '라', '01052545944', '5000', 219, 11),
(1728, '0632.37', '미키비누', '블루', NULL, 5000, 1, '1730237535', '단골 손님', 'ㅂ', '01052545944', '5000', 219, 11),
(1363, '1448.03', '칼국수', '', NULL, 7000, 1, '1698212903', '관리자', '09', '01022223333', '7000', 120, 9),
(1364, '1448.03', '만두5개', '섞어', NULL, 7500, 2, '1698212903', '관리자', '09', '01022223333', '15000', 133, 9),
(1365, '0047.03', '칼국수', '', NULL, 7000, 1, '1700754432', '관리자', '10', '01022223333', '7000', 120, 9),
(1366, '0047.03', '수제비', '', NULL, 7500, 1, '1700754432', '관리자', '10', '01022223333', '7500', 119, 9),
(1367, '1609.03', '칼국수', '', NULL, 7000, 1, '1703747393', '관리자', '05', '01022223333', '7000', 120, 9),
(1368, '1609.03', '수제비', '', NULL, 7500, 2, '1703747393', '관리자', '05', '01022223333', '15000', 119, 9),
(1369, '1759.03', '칼국수', '', NULL, 7000, 2, '1704185986', '관리자', '02', '01022223333', '14000', 120, 9),
(1370, '1759.03', '만두5개', '김치', NULL, 7500, 2, '1704185986', '관리자', '02', '01022223333', '15000', 133, 9),
(1371, '1801.03', '칼국수', '', NULL, 7000, 1, '1704186096', '관리자', '13', '01022223333', '7000', 120, 9),
(1372, '1448.03', '칼국수', '', NULL, 7000, 3, '1704433720', '관리자', '08', '01022223333', '21000', 120, 9),
(1373, '1448.03', '만두5개', '김치', NULL, 7500, 2, '1704433720', '관리자', '08', '01022223333', '15000', 133, 9),
(1374, '1221.03', '칼국수', '', NULL, 7000, 2, '1704856866', '관리자', '03', '01022223333', '14000', 120, 9),
(1384, '1709.1', '칼국수', '', NULL, 7000, 1, '1707725375', '관리자', '09', '01022223333', '7000', 120, 9),
(1385, '1709.1', '만두5개', '김치', NULL, 7500, 2, '1707725375', '관리자', '09', '01022223333', '15000', 133, 9),
(1386, '1847.1', '칼국수', '', NULL, 7000, 1, '1710496042', '관리자', '11', '01022223333', '7000', 120, 9),
(1387, '1847.1', '수제비', '', NULL, 7500, 2, '1710496042', '관리자', '11', '01022223333', '15000', 119, 9),
(1388, '0630.1', '칼국수', '', NULL, 7000, 1, '1710797437', '관리자', '08', '01022223333', '7000', 120, 9),
(1389, '0630.1', '수제비', '', NULL, 7500, 2, '1710797437', '관리자', '08', '01022223333', '15000', 119, 9),
(1390, '1524.1', '칼국수', '', NULL, 7000, 1, '1712903070', '관리자', '06', '01022223333', '7000', 120, 9),
(1391, '1524.1', '수제비', '', NULL, 7500, 2, '1712903070', '관리자', '06', '01022223333', '15000', 119, 9),
(1392, '1815.1', '칼국수', '', NULL, 7000, 1, '1713604508', '관리자', '10', '01022223333', '7000', 120, 9),
(1393, '1815.1', '수제비', '', NULL, 7500, 2, '1713604508', '관리자', '10', '01022223333', '15000', 119, 9),
(1346, '1257.86', '칼국수', '', NULL, 7000, 1, '1674014221', '관리자', '05', '01022223333', '7000', 120, 9),
(1347, '1938.87', '칼국수', '', NULL, 7000, 1, '1674297539', '관리자', '05', '01022223333', '7000', 120, 9),
(1349, '1941.88', '수제비', '', NULL, 7500, 1, '1674297693', '관리자', '07', '01022223333', '7500', 119, 9),
(1352, '0227.92', '칼국수', '', NULL, 7000, 1, '1680197259', '관리자', '03', '01022223333', '7000', 120, 9),
(1354, '0234.94', '수제비', '', NULL, 7500, 1, '1680197652', '관리자', '05', '01022223333', '7500', 119, 9),
(1357, '1239.96', '칼국수', '', NULL, 7000, 5, '1680233982', '단골 손님', 'i', '01052545944', '35000', 120, 9),
(1359, '1545.97', '만두5개', '섞어', NULL, 7500, 1, '1680245135', '관리자', '電', '01022223333', '7500', 133, 9),
(1360, '1151.99', '칼국수', '', NULL, 7000, 1, '1680663111', '관리자', '04', '01022223333', '7000', 120, 9),
(1361, '1151.99', '만두5개', '섞어', NULL, 7500, 1, '1680663111', '관리자', '04', '01022223333', '7500', 133, 9),
(1362, '1152.00', '칼국수', '', NULL, 7000, 1, '1680663145', '관리자', '07', '01022223333', '7000', 120, 9),
(1320, '1328.19', '음료', '콜라', NULL, 1500, 1, '1671510489', '관리자', '04', '01022223333', '1500', 134, 9),
(1321, '1659.70', '공기밥', '', NULL, 1000, 1, '1671523157', '관리자', '13', '01022223333', '1000', 123, 9),
(1340, '1352.83', '칼국수', '', NULL, 7000, 1, '1672375946', '관리자', '07', '01022223333', '7000', 120, 9),
(1341, '1352.83', '만두5개', '김치', NULL, 7500, 2, '1672375946', '관리자', '07', '01022223333', '15000', 133, 9),
(1342, '0557.43', '한우버섯샤브', '매운', NULL, 25000, 1, '1672433850', '단골 손님', '17', '01052545944', '25000', 204, 26),
(1343, '0615.45', '만두5개', '고기', NULL, 7500, 1, '1672434928', '관리자', '12', '01022223333', '7500', 133, 9),
(1344, '1222.85', '칼국수', '', NULL, 7000, 1, '1674012173', '단골 손님', '03', '01052545944', '7000', 120, 9),
(1345, '1222.85', '수제비', '', NULL, 7500, 1, '1674012173', '단골 손님', '03', '01052545944', '7500', 119, 9),
(1348, '1938.87', '만두5개', '섞어', NULL, 7500, 2, '1674297539', '관리자', '05', '01022223333', '15000', 133, 9),
(1350, '2110.90', '수제비', '', NULL, 7500, 1, '1675599024', '관리자', '10', '01022223333', '7500', 119, 9),
(1351, '2110.90', '칼국수', '', NULL, 7000, 1, '1675599024', '관리자', '10', '01022223333', '7000', 120, 9),
(1353, '0227.92', '만두5개', '김치', NULL, 7500, 1, '1680197259', '관리자', '03', '01022223333', '7500', 133, 9),
(1355, '0234.94', '음료', '사이다', NULL, 1500, 1, '1680197652', '관리자', '05', '01022223333', '1500', 134, 9),
(1356, '1239.95', '칼국수', '', NULL, 7000, 1, '1680233949', '단골 손님', 'i', '01052545944', '7000', 120, 9),
(1358, '1545.97', '칼국수', '', NULL, 7000, 1, '1680245135', '관리자', '電', '01022223333', '7000', 120, 9),
(1375, '1221.03', '만두5개', '김치', NULL, 7500, 2, '1704856866', '관리자', '03', '01022223333', '15000', 133, 9),
(1377, '1222.03', '만두5개', '김치', NULL, 7500, 1, '1705375355', '관리자', '02', '01022223333', '7500', 133, 9),
(1726, '0629.35', '미키비누', '블루', NULL, 5000, 1, '1730237367', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1725, '0626.34', '미키비누', '블루', NULL, 5000, 1, '1730237200', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1724, '0626.33', '하트비누', '', NULL, 4000, 1, '1730237192', '단골 손님', '할아버지', '01052545944', '4000', 224, 11),
(1723, '0625.31', '미키비누', '블루', NULL, 5000, 1, '1730237139', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1722, '0623.29', '하트비누', '', NULL, 4000, 1, '1730237000', '단골 손님', '祖父', '01052545944', '4000', 224, 11),
(1796, '0831.57', '미니돼지', '', NULL, 4000, 1, '1731108687', '단골 손님', 'z', '01052545944', '4000', 226, 11),
(1795, '0831.55', '하트비누', '', NULL, 4000, 1, '1731108680', '단골 손님', 's', '01052545944', '4000', 224, 11),
(1794, '0829.54', '미니돼지', '', NULL, 4000, 1, '1731108562', '단골 손님', 's', '01052545944', '4000', 226, 11),
(1793, '0829.53', '미니돼지', '', NULL, 4000, 1, '1731108550', '단골 손님', 'a', '01052545944', '4000', 226, 11),
(1379, '1414.03', '칼국수', '', NULL, 7000, 2, '1705382084', '관리자', '05', '01022223333', '14000', 120, 9),
(1396, '2133.47', '소고기버섯샤브', '보통', NULL, 19000, 1, '1716035582', '단골 손님', '대', '01052545944', '19000', 203, 26),
(1397, '2133.48', '소고기버섯샤브', '보통', NULL, 19000, 1, '1716035610', '단골 손님', '대', '01052545944', '19000', 203, 26),
(1403, '0943.5', '바지락칼국수', '', NULL, 10000, 1, '1716079390', '단골 손님', '7', '01052545944', '10000', 202, 26),
(1407, '1011.9', '버섯만두전골', '', NULL, 16000, 1, '1716081086', '단골 손님', '대', '01052545944', '16000', 205, 26),
(1408, '1711.10', '버섯만두전골', '', NULL, 16000, 1, '1716106282', '단골 손님', '대', '01052545944', '16000', 205, 26),
(1761, '2127.44', '만두5개', '고기', NULL, 7500, 1, '1731014874', '관리자', '10', '01022223333', '7500', 133, 9),
(1762, '2128.45', '만두5개', '고기', NULL, 7500, 1, '1731014925', '관리자', '11', '01022223333', '7500', 133, 9),
(1763, '2129.46', '만두5개', '고기', NULL, 7500, 1, '1731014973', '관리자', '12', '01022223333', '7500', 133, 9),
(1764, '2129.48', '만두5개', '고기', NULL, 7500, 1, '1731014998', '관리자', '13', '01022223333', '7500', 133, 9),
(1765, '2131.49', '만두5개', '고기', NULL, 7500, 1, '1731015068', '관리자', '14', '01022223333', '7500', 133, 9),
(1766, '2131.51', '만두5개', '고기', NULL, 7500, 1, '1731015119', '관리자', '15', '01022223333', '7500', 133, 9),
(1767, '2132.53', '만두5개', '고기', NULL, 7500, 1, '1731015156', '관리자', '09', '01022223333', '7500', 133, 9),
(1768, '2134.54', '만두5개', '고기', NULL, 7500, 1, '1731015269', '관리자', '08', '01022223333', '7500', 133, 9),
(1769, '2135.56', '만두5개', '고기', NULL, 7500, 1, '1731015302', '관리자', '07', '01022223333', '7500', 133, 9),
(1770, '2135.58', '만두5개', '고기', NULL, 7500, 1, '1731015322', '관리자', '06', '01022223333', '7500', 133, 9),
(1771, '2138.60', '만두5개', '고기', NULL, 7500, 1, '1731015533', '관리자', 'i', '01022223333', '7500', 133, 9),
(1772, '2143.62', '만두5개', '고기', NULL, 7500, 1, '1731015836', '관리자', '04', '01022223333', '7500', 133, 9),
(1777, '2148.69', '만두5개', '고기', NULL, 7500, 1, '1731016098', '관리자', '15', '01022223333', '7500', 133, 9),
(1778, '2149.71', '만두5개', '고기', NULL, 7500, 1, '1731016140', '관리자', '10', '01022223333', '7500', 133, 9),
(1779, '2149.73', '만두5개', '고기', NULL, 7500, 1, '1731016188', '관리자', '09', '01022223333', '7500', 133, 9),
(1780, '2151.74', '만두5개', '고기', NULL, 7500, 1, '1731016261', '관리자', '08', '01022223333', '7500', 133, 9),
(1781, '2152.75', '만두5개', '고기', NULL, 7500, 1, '1731016350', '관리자', '07', '01022223333', '7500', 133, 9),
(1782, '2155.76', '만두5개', '고기', NULL, 7500, 1, '1731016557', '관리자', '11', '01022223333', '7500', 133, 9),
(1776, '2147.68', '만두5개', '고기', NULL, 7500, 1, '1731016068', '관리자', '14', '01022223333', '7500', 133, 9),
(1787, '2157.81', '만두5개', '고기', NULL, 7500, 1, '1731016648', '관리자', '13', '01022223333', '7500', 133, 9),
(1792, '0735.86', '만두5개', '고기', NULL, 7500, 1, '1731051337', '관리자', '12', '01022223333', '7500', 133, 9),
(1797, '0841.58', '하트비누', '', NULL, 4000, 1, '1731109269', '단골 손님', '할머니집', '01052545944', '4000', 224, 11),
(1711, '0813.18', '미키비누', '블루', NULL, 5000, 1, '1730189580', '단골 손님', '할머니', '01052545944', '5000', 219, 11),
(1721, '0622.28', '하트비누', '', NULL, 4000, 1, '1730236971', '단골 손님', '祖母', '01052545944', '4000', 224, 11),
(1727, '0629.36', '미키비누', '블루', NULL, 5000, 1, '1730237380', '단골 손님', '祖父', '01052545944', '5000', 219, 11),
(1730, '1728.39', '미키비누', '블루', NULL, 5000, 1, '1730276890', '단골 손님', '3', '01052545944', '5000', 219, 11),
(1731, '1728.40', '하트비누', '', NULL, 4000, 1, '1730276901', '단골 손님', '4', '01052545944', '4000', 224, 11),
(1732, '1729.41', '미키비누', '블루', NULL, 5000, 1, '1730276989', '단골 손님', '할머니', '01052545944', '5000', 219, 11),
(1733, '1730.42', '꿀비누', '', NULL, 4000, 1, '1730277020', '단골 손님', '2', '01052545944', '4000', 225, 11),
(1734, '0528.49', '미니돼지', '', NULL, 4000, 1, '1730406530', '단골 손님', '분 당구', '01052545944', '4000', 226, 11),
(1735, '0528.49', '미키비누', '블루', NULL, 5000, 1, '1730406530', '단골 손님', '분 당구', '01052545944', '9000', 219, 11),
(1736, '0535.50', '하트비누', '', NULL, 4000, 1, '1730406917', '단골 손님', '분당구 산운로135 714-201 강경석', '01052545944', '4000', 224, 11),
(1737, '0551.51', '하트비누', '', NULL, 4000, 1, '1730494265', '단골 손님', '222', '01052545944', '4000', 224, 11),
(1738, '0626.51', '꿀비누', '', NULL, 4000, 1, '1730496372', '단골 손님', '222', '01052545944', '4000', 225, 11),
(1739, '1254.52', '미키비누', '블루', NULL, 5000, 2, '1730951692', '단골 손님', '강', '01052545944', '10000', 219, 11),
(1740, '1254.52', '하트비누', '', NULL, 4000, 1, '1730951692', '단골 손님', '강', '01052545944', '14000', 224, 11),
(1801, '0806.61', '미키비누', '블루', NULL, 5000, 1, '1731280001', '단골 손님', '111', '01052545944', '5000', 219, 11),
(1798, '0619.59', '미키비누', '블루', NULL, 5000, 1, '1731273548', '단골 손님', '祖母', '01052545944', '5000', 219, 11),
(1799, '0619.60', '하트비누', '', NULL, 4000, 1, '1731273568', '단골 손님', '할머니', '01052545944', '4000', 224, 11),
(1800, '0619.60', '꿀비누', '', NULL, 4000, 1, '1731273568', '단골 손님', '할머니', '01052545944', '8000', 225, 11),
(1813, '1652.71', '實驗品目', '', NULL, 5000, 1, '1733989969', '단골 손님', '산운로', '01052545944', '5000', 253, 11),
(1805, '0643.63', '222', '', NULL, 222, 1, '1733953427', '단골 손님', '333', '01052545944', '222', 253, 11),
(1806, '0644.64', '222', '', NULL, 222, 2, '1733953451', '단골 손님', '44', '01052545944', '444', 253, 11),
(1807, '0647.65', '222', '', NULL, 222, 1, '1733953623', '단골 손님', '2', '01052545944', '222', 253, 11),
(1808, '0647.66', '222', '', NULL, 222, 2, '1733953634', '단골 손님', '3', '01052545944', '444', 253, 11),
(1809, '0647.67', '222', '', NULL, 222, 4, '1733953646', '단골 손님', '4', '01052545944', '888', 253, 11),
(1812, '1651.70', '實驗中', '', NULL, 5000, 1, '1733989891', '단골 손님', '항아버지', '01052545944', '5000', 253, 11),
(1804, '0229.62', '하트비누', '', NULL, 4000, 1, '1733938173', '단골 손님', '祖父', '01052545944', '4000', 246, 11),
(1810, '1649.68', '하트비누', '', NULL, 4000, 1, '1733989779', '단골 손님', '祖母', '01052545944', '4000', 246, 11),
(1811, '1650.69', '꿀비누', '', NULL, 4000, 2, '1733989801', '단골 손님', '할머니', '01052545944', '8000', 247, 11),
(1814, '1653.72', '實驗品目', '', NULL, 5000, 1, '1733990025', '단골 손님', '할아버지', '01052545944', '5000', 253, 11);

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

--
-- 테이블 구조 `restaurants`
--

CREATE TABLE `restaurants` (
  `R_ID` int(30) NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `contact` varchar(30) NOT NULL,
  `address` varchar(50) NOT NULL,
  `M_ID` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- 테이블의 덤프 데이터 `restaurants`
--

INSERT INTO `restaurants` (`R_ID`, `name`, `email`, `contact`, `address`, `M_ID`) VALUES
(7, 'ksrestaurant', 'kskang2@gmail.com', '1122223333', 'san', 'kskang'),
(9, 'Le Cafe\'', 'kskang2@gmail.com', '01052545944', 'Pankyo', '관리자'),
(11, '벼룩시장', 'kskang2@gmail.com', '11122223333', 'pankyo', 'admin'),
(13, 'Sandwich', 'kskang2@gmail.com', '11122223333', 'pankyo', 'testfood'),
(26, '산골면옥', 'kskang2@gmail.com', '11122223333', 'pankyo', 'adminu');

--
-- 덤프된 테이블의 인덱스
--

--
-- 테이블의 인덱스 `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`Id`);

--
-- 테이블의 인덱스 `food`
--
ALTER TABLE `food`
  ADD PRIMARY KEY (`F_ID`,`R_ID`),
  ADD KEY `R_ID` (`R_ID`);

--
-- 테이블의 인덱스 `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_ID`),
  ADD KEY `F_ID` (`F_ID`),
  ADD KEY `R_ID` (`R_ID`),
  ADD KEY `orders_ibfk_2` (`username`);

--
-- 테이블의 인덱스 `restaurants`
--
ALTER TABLE `restaurants`
  ADD PRIMARY KEY (`R_ID`),
  ADD UNIQUE KEY `M_ID_2` (`M_ID`),
  ADD KEY `M_ID` (`M_ID`);

--
-- 덤프된 테이블의 AUTO_INCREMENT
--

--
-- 테이블의 AUTO_INCREMENT `food`
--
ALTER TABLE `food`
  MODIFY `F_ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=255;

--
-- 테이블의 AUTO_INCREMENT `orders`
--
ALTER TABLE `orders`
  MODIFY `order_ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1820;

--
-- 테이블의 AUTO_INCREMENT `restaurants`
--
ALTER TABLE `restaurants`
  MODIFY `R_ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- 덤프된 테이블의 제약사항
--

--
-- 테이블의 제약사항 `food`
--
ALTER TABLE `food`
  ADD CONSTRAINT `food_ibfk_1` FOREIGN KEY (`R_ID`) REFERENCES `restaurants` (`R_ID`);

--
-- 테이블의 제약사항 `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`F_ID`) REFERENCES `food` (`F_ID`),
  ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`username`) REFERENCES `customer` (`username`),
  ADD CONSTRAINT `orders_ibfk_3` FOREIGN KEY (`R_ID`) REFERENCES `restaurants` (`R_ID`);

--
-- 테이블의 제약사항 `restaurants`
--
ALTER TABLE `restaurants`
  ADD CONSTRAINT `restaurants_ibfk_1` FOREIGN KEY (`M_ID`) REFERENCES `manager` (`username`);
COMMIT;

