-- https://www.phpmyadmin.net/
--
-- 생성 시간: 24-07-13 21:05
-- 서버 버전: 10.11.6-MariaDB-0+deb12u1
-- PHP 버전: 8.2.20

START TRANSACTION;



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

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

--
-- 테이블 구조 `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', 'ENABLE'),
(132, '김치칼국수', '', '', '', '7500', '', 9, '20', 'images/1050x700c.png', 'DISABLE'),
(133, '만두5개', '고기', '김치', '섞어', '7500', '', 9, '50', 'images/1050x700e.png', 'ENABLE'),
(134, '음료', '콜라', '사이다', '', '1500', '', 9, '70', 'images/300x200g.png', 'ENABLE'),
(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'),
(219, '미키비누', '블루', '핑크', '투명', '5000', '手제품', 11, '3', 'images/1.png', 'ENABLE'),
(220, '시계', '', '', '', '10000', '3333', 11, '4', 'images/sbgx009.jpg', 'DISABLE'),
(221, '케이크', '', '', '', '20000', 'Homemade', 11, '7', 'images/xO65488ed5.jpeg', 'DISENABLE');

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

--
-- 테이블 구조 `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(11) 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
(1320, '1328.19', '음료', '콜라', '9', 1500, 1, '1671510489', '관리자', '04', '01022223333', '1500', 134, 9, '', '70'),
(1321, '1659.70', '공기밥', '', '9', 1000, 1, '1671523157', '관리자', '13', '01022223333', '1000', 123, 9, '', '60'),
(1340, '1352.83', '칼국수', '', '9', 7000, 1, '1672375946', '관리자', '07', '01022223333', '7000', 120, 9, '', '10'),
(1341, '1352.83', '만두5개', '김치', '9', 7500, 2, '1672375946', '관리자', '07', '01022223333', '15000', 133, 9, '', '50'),
(1342, '0557.43', '한우버섯샤브', '매운', '2', 25000, 1, '1672433850', '단골 손님', '17', '01052545944', '25000', 204, 26, NULL, '999'),
(1343, '0615.45', '만두5개', '고기', '9', 7500, 1, '1672434928', '관리자', '12', '01022223333', '7500', 133, 9, NULL, '999'),
(1344, '1222.85', '칼국수', '', '9', 7000, 1, '1674012173', '단골 손님', '03', '01052545944', '7000', 120, 9, '', '10'),
(1345, '1222.85', '수제비', '', '9', 7500, 1, '1674012173', '단골 손님', '03', '01052545944', '7500', 119, 9, '', '30'),
(1346, '1257.86', '칼국수', '', '9', 7000, 1, '1674014221', '관리자', '05', '01022223333', '7000', 120, 9, NULL, '10'),
(1347, '1938.87', '칼국수', '', '9', 7000, 1, '1674297539', '관리자', '05', '01022223333', '7000', 120, 9, '', '10'),
(1348, '1938.87', '만두5개', '섞어', '9', 7500, 2, '1674297539', '관리자', '05', '01022223333', '15000', 133, 9, '', '50'),
(1349, '1941.88', '수제비', '', '9', 7500, 1, '1674297693', '관리자', '07', '01022223333', '7500', 119, 9, NULL, '30'),
(1350, '2110.90', '수제비', '', '9', 7500, 1, '1675599024', '관리자', '10', '01022223333', '7500', 119, 9, '', '30'),
(1351, '2110.90', '칼국수', '', '9', 7000, 1, '1675599024', '관리자', '10', '01022223333', '7000', 120, 9, '', '10'),
(1352, '0227.92', '칼국수', '', '9', 7000, 1, '1680197259', '관리자', '03', '01022223333', '7000', 120, 9, '', '10'),
(1353, '0227.92', '만두5개', '김치', '9', 7500, 1, '1680197259', '관리자', '03', '01022223333', '7500', 133, 9, '', '50'),
(1354, '0234.94', '수제비', '', '9', 7500, 1, '1680197652', '관리자', '05', '01022223333', '7500', 119, 9, NULL, '30'),
(1355, '0234.94', '음료', '사이다', '9', 1500, 1, '1680197652', '관리자', '05', '01022223333', '1500', 134, 9, NULL, '70'),
(1356, '1239.95', '칼국수', '', '9', 7000, 1, '1680233949', '단골 손님', 'i', '01052545944', '7000', 120, 9, '', '10'),
(1357, '1239.96', '칼국수', '', '9', 7000, 5, '1680233982', '단골 손님', 'i', '01052545944', '35000', 120, 9, '', '10'),
(1358, '1545.97', '칼국수', '', '9', 7000, 1, '1680245135', '관리자', '電', '01022223333', '7000', 120, 9, '', '10'),
(1359, '1545.97', '만두5개', '섞어', '9', 7500, 1, '1680245135', '관리자', '電', '01022223333', '7500', 133, 9, '', '50'),
(1360, '1151.99', '칼국수', '', '0', 7000, 1, '1680663111', '관리자', '04', '01022223333', '7000', 120, 9, '', '10'),
(1361, '1151.99', '만두5개', '섞어', '2', 7500, 1, '1680663111', '관리자', '04', '01022223333', '7500', 133, 9, '', '50'),
(1362, '1152.00', '칼국수', '', '9', 7000, 1, '1680663145', '관리자', '07', '01022223333', '7000', 120, 9, NULL, '10'),
(1363, '1448.03', '칼국수', '', '9', 7000, 1, '1698212903', '관리자', '09', '01022223333', '7000', 120, 9, '', '10'),
(1364, '1448.03', '만두5개', '섞어', '9', 7500, 2, '1698212903', '관리자', '09', '01022223333', '15000', 133, 9, '', '50'),
(1365, '0047.03', '칼국수', '', '9', 7000, 1, '1700754432', '관리자', '10', '01022223333', '7000', 120, 9, '', '10'),
(1366, '0047.03', '수제비', '', '9', 7500, 1, '1700754432', '관리자', '10', '01022223333', '7500', 119, 9, '', '30'),
(1367, '1609.03', '칼국수', '', '9', 7000, 1, '1703747393', '관리자', '05', '01022223333', '7000', 120, 9, '', '10'),
(1368, '1609.03', '수제비', '', '9', 7500, 2, '1703747393', '관리자', '05', '01022223333', '15000', 119, 9, '', '30'),
(1369, '1759.03', '칼국수', '', '9', 7000, 2, '1704185986', '관리자', '02', '01022223333', '14000', 120, 9, '', '10'),
(1370, '1759.03', '만두5개', '김치', '9', 7500, 2, '1704185986', '관리자', '02', '01022223333', '15000', 133, 9, '', '50'),
(1371, '1801.03', '칼국수', '', '9', 7000, 1, '1704186096', '관리자', '13', '01022223333', '7000', 120, 9, NULL, '10'),
(1372, '1448.03', '칼국수', '', '9', 7000, 3, '1704433720', '관리자', '08', '01022223333', '21000', 120, 9, '', '10'),
(1373, '1448.03', '만두5개', '김치', '9', 7500, 2, '1704433720', '관리자', '08', '01022223333', '15000', 133, 9, '', '50'),
(1374, '1221.03', '칼국수', '', '9', 7000, 2, '1704856866', '관리자', '03', '01022223333', '14000', 120, 9, '', '10'),
(1375, '1221.03', '만두5개', '김치', '9', 7500, 2, '1704856866', '관리자', '03', '01022223333', '15000', 133, 9, '', '50'),
(1376, '1226.03', '수제비', '', '9', 7500, 1, '1704857205', '단골 손님', 'W', '01052545944', '7500', 119, 9, '3', '30'),
(1377, '1222.03', '만두5개', '김치', '0', 7500, 1, '1705375355', '관리자', '02', '01022223333', '7500', 133, 9, '', '50'),
(1378, '1222.03', '수제비', '', '0', 7500, 1, '1705375355', '관리자', '02', '01022223333', '7500', 119, 9, '', '30'),
(1379, '1414.03', '칼국수', '', '0', 7000, 2, '1705382084', '관리자', '05', '01022223333', '14000', 120, 9, '', '10'),
(1380, '1414.03', '만두5개', '김치', '0', 7500, 1, '1705382084', '관리자', '05', '01022223333', '7500', 133, 9, '', '50'),
(1381, '0852.1', '음료', '콜라', '0', 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'),
(1384, '1709.1', '칼국수', '', '9', 7000, 1, '1707725375', '관리자', '09', '01022223333', '7000', 120, 9, '', '10'),
(1385, '1709.1', '만두5개', '김치', '9', 7500, 2, '1707725375', '관리자', '09', '01022223333', '15000', 133, 9, '', '50'),
(1386, '1847.1', '칼국수', '', '9', 7000, 1, '1710496042', '관리자', '11', '01022223333', '7000', 120, 9, '', '10'),
(1387, '1847.1', '수제비', '', '9', 7500, 2, '1710496042', '관리자', '11', '01022223333', '15000', 119, 9, '', '30'),
(1388, '0630.1', '칼국수', '', '9', 7000, 1, '1710797437', '관리자', '08', '01022223333', '7000', 120, 9, '', '10'),
(1389, '0630.1', '수제비', '', '9', 7500, 2, '1710797437', '관리자', '08', '01022223333', '15000', 119, 9, '', '30'),
(1390, '1524.1', '칼국수', '', '9', 7000, 1, '1712903070', '관리자', '06', '01022223333', '7000', 120, 9, '', '10'),
(1391, '1524.1', '수제비', '', '9', 7500, 2, '1712903070', '관리자', '06', '01022223333', '15000', 119, 9, '', '30'),
(1392, '1815.1', '칼국수', '', '0', 7000, 1, '1713604508', '관리자', '10', '01022223333', '7000', 120, 9, '', '10'),
(1393, '1815.1', '수제비', '', '0', 7500, 2, '1713604508', '관리자', '10', '01022223333', '15000', 119, 9, '', '30'),
(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'),
(1396, '2133.47', '소고기버섯샤브', '보통', '9', 19000, 1, '1716035582', '단골 손님', '대', '01052545944', '19000', 203, 26, NULL, '999'),
(1397, '2133.48', '소고기버섯샤브', '보통', '9', 19000, 1, '1716035610', '단골 손님', '대', '01052545944', '19000', 203, 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', '한우버섯샤브', '보통', '2', 25000, 3, '1716073895', '단골 손님', '8', '01052545944', '75000', 204, 26, NULL, '999'),
(1402, '0913.4', '바지락칼국수', '', '0', 10000, 1, '1716077598', '단골 손님', '10', '01052545944', '10000', 202, 26, NULL, '999'),
(1403, '0943.5', '바지락칼국수', '', '0', 10000, 1, '1716079390', '단골 손님', '7', '01052545944', '10000', 202, 26, NULL, '999'),
(1404, '0943.5', '버섯만두전골', '', '0', 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', '버섯만두전골', '', '0', 16000, 1, '1716080059', '단골 손님', '14', '01052545944', '16000', 205, 26, NULL, '999'),
(1407, '1011.9', '버섯만두전골', '', '9', 16000, 1, '1716081086', '단골 손님', '대', '01052545944', '16000', 205, 26, NULL, '999'),
(1408, '1711.10', '버섯만두전골', '', '9', 16000, 1, '1716106282', '단골 손님', '대', '01052545944', '16000', 205, 26, NULL, '999'),
(1438, '1830.48', '미키비누', '블루', '0', 5000, 1, '1716370247', '단골 손님', '祖父', '01052545944', '5000', 219, 11, NULL, '999'),
(1440, '0818.50', '미키비누', '투명', '0', 5000, 1, '1716419889', '단골 손님', '祖父', '01052545944', '5000', 219, 11, NULL, '999'),
(1441, '0915.51', '미키비누', '블루', '9', 5000, 1, '1717892137', '단골 손님', '2', '01052545944', '5000', 219, 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(11) 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);

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

--
-- 테이블 구조 `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=224;

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

--
-- 테이블의 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;

