p20UkF5s

1-- hango 데이터 베이스 생성
2CREATE DATABASE IF NOT EXISTS hango;
3
4-- hango 데이터 베이스 사용
5USE hango;
6
7-- 유저 테이블 생성
8CREATE TABLE `users` (
9  `user_id` varchar(30) NOT NULL,
10  `user_name` varchar(30) NOT NULL,
11  `user_email` varchar(60) NOT NULL,
12  `user_passwd` varchar(128) NOT NULL,
13  `user_in_date` datetime DEFAULT CURRENT_TIMESTAMP,
14  `user_salt` varchar(128) NOT NULL,
15  PRIMARY KEY (`user_id`)
16);
17
18-- 자판기 테이블 생성
19CREATE TABLE `vendings` (
20  `serial_number` varchar(20) NOT NULL,
21  `user_id` varchar(30) NOT NULL,
22  `vending_name` varchar(255) NOT NULL,
23  `vending_description` varchar(255) NOT NULL DEFAULT '',
24  `vending_full_size` tinyint(2) NOT NULL DEFAULT '10',
25  `vending_in_date` datetime DEFAULT CURRENT_TIMESTAMP,
26  `vending_update_date` datetime DEFAULT CURRENT_TIMESTAMP,
27  PRIMARY KEY (`serial_number`),
28  KEY `user_id` (`user_id`),
29  CONSTRAINT `vendings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
30);
31
32-- 음료수 테이블 생성
33CREATE TABLE `drinks` (
34  `serial_number` varchar(20) NOT NULL,
35  `drink_position` tinyint(4) NOT NULL,
36  `drink_name` varchar(30) NOT NULL,
37  `drink_price` int(2) NOT NULL,
38  `drink_count` int(2) DEFAULT '10',
39  `drink_max_count` int(2) DEFAULT '10',
40  PRIMARY KEY (`serial_number`,`drink_position`),
41  CONSTRAINT `drinks_ibfk_1` FOREIGN KEY (`serial_number`) REFERENCES `vendings` (`serial_number`) ON DELETE CASCADE ON UPDATE CASCADE
42);
43
44-- Hango 운영자 테이블 생성
45CREATE TABLE `managers` (
46  `manager_id` varchar(30) NOT NULL,
47  `manager_name` varchar(30) NOT NULL,
48  `manager_email` varchar(60) NOT NULL,
49  `manager_passwd` varchar(128) NOT NULL,
50  `manager_in_date` datetime DEFAULT CURRENT_TIMESTAMP,
51  `manager_salt` varchar(128) NOT NULL,
52  `manager_approbation_flag` int(1) NOT NULL DEFAULT '0',
53  PRIMARY KEY (`manager_id`)
54);
55
56-- 판매 테이블 생성
57CREATE TABLE `sales` (
58  `sale_seq` int(4) NOT NULL AUTO_INCREMENT,
59  `user_id` varchar(30) NOT NULL,
60  `serial_number` varchar(20) NOT NULL,
61  `drink_name` varchar(30) NOT NULL,
62  `drink_price` int(2) NOT NULL,
63  `sale_date` datetime DEFAULT CURRENT_TIMESTAMP,
64  PRIMARY KEY (`sale_seq`),
65  KEY `serial_number` (`serial_number`),
66  KEY `user_id` (`user_id`),
67  CONSTRAINT `sales_ibfk_1` FOREIGN KEY (`serial_number`) REFERENCES `vendings` (`serial_number`) ON UPDATE CASCADE,
68  CONSTRAINT `sales_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE
69);
70
71-- 유저 데이터 삽입
72INSERT INTO `users` VALUES ('changetestid','changetestname','changetest@naver.com','','2020-10-13 15:31:23','b21f96d0352eeb3670e46a19e641079208cab76a4d55dffd3b3248b94296503b52d6a1d3d42b965473b7b046c4b0cab4d4dd9962a0448fa9bad8f362cddc3b28'),('golagola','골라골라','golagola@naver.com','12341234','2020-08-22 06:07:17',''),('kingWoangZZang','나는야 골목대장','test@gmail.com','1234','2020-10-03 18:25:21',''),('lasttest','test','lasttest@naver.com','1787cc95c5dc5dac88681b57d58d381a7c889a9b6d49ebdbf5b13a450b6dc6cfb1f24f0070c09b2ab2cc2614a5adfddd587c321441e860a36902bd7771b7a6fe','2020-10-16 13:42:43','2a3264011b6dc25c05cbda5bec764d1cbd57e8088811a9d7f9fee11ce8faff143199444ec765cfb065f35dd8888fc11091e69c1e447f8c39631fb8142dc49f69'),('rltn','rltn','rltn@naver.com','f59e1d8d3a7ad532e878483f0b414ffff43a82db6eb27247ce85bcf6c456de734889c48394bd39b1cd6d63bff6064f9afb49927aa257e0aaf033695adeef09ca','2020-10-14 19:35:08','c7f6bd125dc06874f7caad577df25691c2e72f9460eced40bc37b88383e42f724a7a850d985dc320cb81c7b9aa877fa8c83d136f2f1f14879ed707c4437d6649'),('rltn123','송기수','rltn123@naver.com','39e752f2236ef9a0fae59c76361bd1609d8e1003f8fd737a237c53b1303946bc08987b538af6df93b57eb3ca79836f7d39c923c6485c3a9087a7e6a898a8bdb7','2020-08-14 04:25:26','cc1521f379bf4e2367f0c7d07d97fc9d35869644bd1effdd0933d8d8f2955d2d279b70a242a57b5d0c6f19ee68ddbae3f729f13461af210803ec4503a597263b'),('test','테스트','test@gmail.com','1234','2020-10-03 18:25:06',''),('test10','테스트10','test@gmail.com','1234','2020-10-03 18:25:54',''),('test12','테스트12','test@gmail.com','1234','2020-10-03 18:31:23',''),('test14','테스트14','test@gmail.com','1234','2020-10-03 18:31:30',''),('test15','테스트15','앜','1234','2020-10-03 18:31:33',''),('test16','테스트','test@gmail.com','1234','2020-10-03 18:31:36',''),('test17','테스트','test@gmail.com','1234','2020-10-03 18:31:39',''),('test18','테스트','test@gmail.com','1234','2020-10-03 18:31:40',''),('test19','테스트','test@gmail.com','1234','2020-10-03 18:31:41',''),('test2','테스트2','test@gmail.com','1234','2020-10-03 18:25:11',''),('test20','테스트','test@gmail.com','1234','2020-10-03 18:31:42',''),('test21','테스트','test@gmail.com','1234','2020-10-03 18:31:44',''),('test22','테스트','test@gmail.com','1234','2020-10-03 18:31:45',''),('test23','테스트','test@gmail.com','1234','2020-10-03 18:31:46',''),('test24','테스트','test@gmail.com','1234','2020-10-03 18:31:47',''),('test3','테스트3','test@gmail.com','1234','2020-10-03 18:25:15',''),('test5','테스트5','test@gmail.com','1234','2020-10-03 18:25:26',''),('test7','테스트7','test@gmail.com','1234','2020-10-03 18:25:40',''),('test8','테스트8','test@gmail.com','1234','2020-10-03 18:25:47',''),('test9','테스트9','test@gmail.com','1234','2020-10-03 18:25:51',''),('tt','tt','tt@naver.com','3c062103d55e5870c260719230c12a9675bb84687abbb90d7d10ceceda2d2e8952dfaeed1be8278b190cc428010e8984152649324ce7bb10fe018b0b214b6975','2020-10-16 14:34:49','e047925a933053ae9550b5170d12696684e0ced1f6e7f2f5dff68663660a2e7490cbfce694c1a0e7f9a8cd0d53ffa689ca335e12a144305fe70f417d278feac7'),('ttt','ttt','ttt@naver.com','fdea5a3e5dbbbc34c0b82127a6e9368d76a1034cdc8ffdc6a38d2602ca93c9e45ca0e5e0c28c5152ae9adc030aca4152d159e330348f2bcf9ca958b37420236e','2020-10-14 19:36:30','10db9f47876f496104307e16143f1257624804472890e01ce09bb17d86323f9c2141c3c20766f5b0e49f9d33f9c0284b6a9bb1636af81c79d0389e566b65f6f5'),('tttt','tttt','tttt@naver.com','6a7c10305dc74f1f707f03d6ea6b7a7b467fd6aa949be818576c44cb07c6a7cd2cdf5f7cd79ccb3fce69e49f64a0aa2055ad23bbc0f8524897f873d655d8e525','2020-10-16 13:47:46','e0384eeafebbc30fc9d7a0ea53b67b6207dfcf037ded2e88034d67eb3ce9811e2335f189e608d74b1ed06a259a29434f20d2c1ce00611b137d58fb9ccfeab7c3'),('devleopkim','김개발','developkim@gmail.com','1234','2020-10-03 18:24:54','');
73
74-- 자판기 데이터 삽입
75INSERT INTO `vendings` VALUES ('20200814042555141','rltn123','사탕발린 꼬북이','홍대입구역 지하 1층 1번',8,'2020-08-14 04:25:55','2020-10-03 16:49:19'),('20200814042556159','rltn123','빨간 곡괭이','홍대입구역 2번출구',10,'2020-08-14 04:25:56','2020-10-03 16:48:31'),('20200814042556372','rltn123','뿔달린 하얀 바나나','이대역 3번출구',10,'2020-08-14 04:25:56','2020-08-14 04:25:56'),('20200814042556381','rltn123','오정동 금이빨','오정동',10,'2020-08-14 04:25:56','2020-08-14 04:25:56'),('20200814042556791','rltn123','세상 푸른 붉은 여왕개미','대전 중리동 312-8',10,'2020-08-14 04:25:56','2020-08-14 04:25:56'),('20200814042557678','rltn123','파란 가위손','월계역 1번 출구',10,'2020-08-14 04:25:57','2020-08-14 04:25:57'),('20200814042557757','rltn123','일개미 여행','노원역 1번출구',12,'2020-08-14 04:25:57','2020-08-14 04:25:57'),('20200927151826673','rltn123','곱게 살고 싶은가','그럼 나를 따르라',99,'2020-09-27 15:18:26','2020-10-03 17:23:53'),('20200928151655292','rltn123','수정하기 편해졌다','아싸',10,'2020-09-28 15:16:55','2020-10-03 17:24:10'),('20200928151733783','rltn123','자판기 관리 구현','완료',10,'2020-09-28 15:17:33','2020-10-03 17:24:33'),('20201001153456779','golagola','세상 빛나는 조각턱','얄라리 얄라 얄라셩',12,'2020-10-01 15:34:56','2020-10-16 12:56:18'),('2020100115350213','golagola','굿맨','굿걸',10,'2020-10-01 15:35:02','2020-10-05 15:23:08'),('20201001192221957','golagola','수정 잘 되나요','네 잘됩니다',127,'2020-10-01 19:22:21','2020-10-03 18:32:57'),('20201001204026937','golagola','20201001204026937','나는야 골목대장',10,'2020-10-01 20:40:26','2020-10-05 17:41:12'),('20201001225027482','golagola','피나는 종이비행기의 서른 두살','hangout',10,'2020-10-01 22:50:27','2020-10-03 17:25:25'),('20201001225031754','golagola','20201001225031754','',10,'2020-10-01 22:50:31','2020-10-01 22:50:31'),('20201001225040322','rltn123','123123123','122222',12,'2020-10-01 22:50:40','2020-10-01 22:50:40'),('20201001225044348','rltn123','20201001225044348','',10,'2020-10-01 22:50:44','2020-10-01 22:50:44'),('20201001225048773','golagola','20201001225048773','',10,'2020-10-01 22:50:48','2020-10-01 22:50:48'),('20201001225051821','golagola','20201001225051821','',10,'2020-10-01 22:50:51','2020-10-01 22:50:51'),('20201003154147389','golagola','수정 테스트','수정이 잘 되었나요',127,'2020-10-03 15:41:47','2020-10-03 17:03:54'),('20201014160134979','changetestid','20201014160134979','',10,'2020-10-14 16:01:34','2020-10-14 16:01:34'),('20201014160139939','changetestid','20201014160139939','',10,'2020-10-14 16:01:39','2020-10-14 16:01:39'),('20201014194354965','rltn123','20201014194354965','',10,'2020-10-14 19:43:54','2020-10-14 19:43:54'),('20201014194727886','rltn123','변경','뱐경',12,'2020-10-14 19:47:27','2020-10-14 19:47:27'),('20201016140548127','tttt','20201016140548127','',10,'2020-10-16 14:05:48','2020-10-16 14:05:48');
76
77-- 음료수 데이터 삽입
78INSERT INTO `drinks` VALUES ('20200814042555141',1,'펩시 콜라',1500,9,12),('20200814042555141',2,'데자와',2000,7,10),('20200814042555141',3,'파워에이드',5500,9,12),('20200814042555141',4,'스프라이트',1200,18,20),('20200814042555141',5,'초록 매실',500,33,35),('20200814042555141',6,'갈아만든 배',800,16,18),('20200814042555141',7,'박카스',700,21,23),('20200814042555141',8,'비타 500',100,23,23),('20200814042556159',1,'아침 햇살',1000,10,10),('20200814042556159',2,'솔의 눈',800,10,10),('20200814042556159',3,'코카 콜라',1000,10,10),('20200814042556159',4,'초코에몽',1200,10,10),('20200814042556159',5,'바나나우유',1300,10,10),('20200814042556159',6,'비락 식혜',600,10,10),('20200814042556159',7,'칠성 사이다',500,10,10),('20200814042556159',8,'물',1000,10,10),('20200814042556159',9,'물',1500,10,10),('20200814042556159',10,'test',1200,12,12),('20200814042556372',1,'삼다수',2000,10,10),('20200814042556372',2,'코카 콜라',2200,10,10),('20200814042556372',3,'딸기 우유',1800,10,10),('20200814042556381',1,'초코 우유',1500,10,10),('20200814042556381',2,'바나나 우유',2000,10,10),('20200814042556381',3,'코카 콜라',5200,10,10),('20200814042556381',4,'펩시 콜라',3000,10,10),('20200814042557678',1,'코카 콜라',1200,12,12),('20200814042557757',1,'123123',1222,0,12),('20200814042557757',2,'1222',1234,0,12),('20200814042557757',3,'1111',1111,0,12),('20200814042557757',4,'11233',1211,0,12),('20200814042557757',5,'11sd',1233,12,12),('20200814042557757',6,'tess',1233,0,12),('20200814042557757',7,'lasttest',1234,12,12),('20200814042557757',8,'lastlasttest',12222,0,12),('20200814042557757',9,'tesststst',11111,12,12),('20200814042557757',10,'123123',1200,0,12),('20200814042557757',11,'testest',1200,0,12),('20201001153456779',1,'코카 콜라',1500,0,10),('20201001153456779',2,'코카 콜라',1500,10,10),('20201001153456779',3,'코카 콜라',1500,0,10),('20201001153456779',4,'스프라이트',1500,10,10),('20201001153456779',5,'물',1500,0,10),('20201001153456779',6,'초록 매실',1500,10,10),('2020100115350213',1,'바나나 우유',1500,0,10),('2020100115350213',2,'바나나 우유',1500,0,10),('2020100115350213',3,'딸기 우유',1500,0,10),('2020100115350213',4,'딸기 우유',1500,10,10),('2020100115350213',5,'초코 우유',1500,0,10),('2020100115350213',6,'초코 우유',1500,10,10);
79
80-- Hango 운영자 데이터 삽입
81INSERT INTO `managers` VALUES ('admin','관리자','woorimprog@gmail.com','e1fc97f7df34d5501ea6c00abf75babb058ae19f54293e5062b4c52c23397663d10a7036e9f40f86ef45c400fbc213e5df68fa57a8e6011fc9ae4b9a740adce2','2020-10-06 23:59:52','cc1521f379bf4e2367f0c7d07d97fc9d35869644bd1effdd0933d8d8f2955d2d279b70a242a57b5d0c6f19ee68ddbae3f729f13461af210803ec4503a597263b',1),('asdasd','Hango','asdasd@naver.com','d6e23454f17b7b10428c3389f4dbffb8f77a522d06fe11478fae8fd07353d2abac5458e7d50124ee0e0dbb6d47abfb6f864b4bc231249432212a86e750c902cb','2020-10-15 11:04:40','38470fb33cec58821dff20c32f569090a8587ca3b34ec075109bd1e09b6487b40b8730631dbcf3fc928cd56b2a2638e371164342c389c6d52f9b619355ad76c8',1);
82
83-- 판매 데이터 삽입
84INSERT INTO `sales` VALUES (60,'rltn123','20200814042555141','펩시 콜라',1500,'2020-06-01 15:27:05'),(61,'rltn123','20200814042555141','펩시 콜라',1500,'2020-08-02 15:27:06'),(62,'rltn123','20200814042555141','펩시 콜라',1500,'2020-09-03 15:27:06'),(63,'rltn123','20200814042555141','펩시 콜라',1500,'2020-09-03 15:27:07'),(64,'rltn123','20200814042555141','펩시 콜라',1500,'2020-09-04 15:27:07'),(65,'rltn123','20200814042555141','펩시 콜라',1500,'2020-09-11 15:27:07'),(66,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-01 15:27:08'),(67,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-01 15:27:08'),(68,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-01 15:27:08'),(69,'rltn123','20200814042555141','파워 에이드',5500,'2020-07-01 15:27:43'),(70,'rltn123','20200814042555141','파워 에이드',5500,'2020-08-01 15:27:43'),(71,'rltn123','20200814042555141','파워 에이드',5500,'2020-08-03 15:27:44'),(72,'rltn123','20200814042555141','파워 에이드',5500,'2020-09-01 15:27:44'),(73,'rltn123','20200814042555141','파워 에이드',5500,'2020-09-02 15:27:44'),(74,'rltn123','20200814042555141','파워 에이드',5500,'2020-09-03 15:27:44'),(75,'rltn123','20200814042555141','파워 에이드',5500,'2020-09-04 15:27:44'),(76,'rltn123','20200814042555141','파워 에이드',5500,'2020-09-11 15:27:45'),(77,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:27:45'),(78,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:27:45'),(79,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:27:45'),(80,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:29:06'),(81,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:29:07'),(82,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:29:07'),(83,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:29:07'),(84,'rltn123','20200814042555141','파워 에이드',5500,'2020-10-01 15:29:07'),(85,'rltn123','20200814042555141','스프라이트',1200,'2020-06-01 15:29:40'),(86,'rltn123','20200814042555141','스프라이트',1200,'2020-06-01 15:29:40'),(87,'rltn123','20200814042555141','스프라이트',1200,'2020-06-01 15:29:41'),(88,'rltn123','20200814042555141','스프라이트',1200,'2020-07-01 15:29:41'),(89,'rltn123','20200814042555141','스프라이트',1200,'2020-07-01 15:29:41'),(90,'rltn123','20200814042555141','스프라이트',1200,'2020-07-01 15:29:41'),(91,'rltn123','20200814042555141','스프라이트',1200,'2020-08-01 15:29:41'),(92,'rltn123','20200814042555141','스프라이트',1200,'2020-08-01 15:29:41'),(93,'rltn123','20200814042555141','스프라이트',1200,'2020-09-01 15:29:42'),(94,'rltn123','20200814042555141','스프라이트',1200,'2020-09-01 15:29:42'),(95,'rltn123','20200814042555141','스프라이트',1200,'2020-09-01 15:29:42'),(96,'rltn123','20200814042555141','스프라이트',1200,'2020-10-01 15:29:42'),(97,'rltn123','20200814042555141','박카스',700,'2020-05-01 15:30:07'),(98,'rltn123','20200814042555141','박카스',700,'2020-06-01 15:30:07'),(99,'rltn123','20200814042555141','박카스',700,'2020-06-01 15:30:07'),(100,'rltn123','20200814042555141','박카스',700,'2020-08-01 15:30:07'),(101,'rltn123','20200814042555141','박카스',700,'2020-10-01 15:30:07'),(102,'rltn123','20200814042555141','박카스',700,'2020-10-01 15:30:07'),(103,'rltn123','20200814042555141','비타 500',100,'2020-04-01 15:30:26'),(104,'rltn123','20200814042555141','비타 500',100,'2020-09-01 15:30:26'),(105,'rltn123','20200814042555141','비타 500',100,'2020-09-01 15:30:26'),(106,'rltn123','20200814042555141','비타 500',100,'2020-09-01 15:30:27'),(107,'rltn123','20200814042555141','비타 500',100,'2020-10-01 15:30:27'),(108,'rltn123','20200814042555141','비타 500',100,'2020-10-01 15:30:27'),(109,'rltn123','20200814042555141','비타 500',100,'2020-10-01 15:30:27'),(110,'rltn123','20200814042555141','비타 500',100,'2020-10-01 15:30:28'),(111,'rltn123','20200814042556159','아침 햇살',1000,'2020-04-01 15:31:47'),(112,'rltn123','20200814042556159','아침 햇살',1000,'2020-08-01 15:31:47'),(113,'rltn123','20200814042556159','아침 햇살',1000,'2020-09-01 15:31:47'),(114,'rltn123','20200814042556159','아침 햇살',1000,'2020-10-01 15:31:47'),(115,'rltn123','20200814042556159','솔의 눈',800,'2020-04-01 15:32:06'),(116,'rltn123','20200814042556159','솔의 눈',800,'2020-05-01 15:32:07'),(117,'rltn123','20200814042556159','솔의 눈',800,'2020-10-01 15:32:07'),(118,'rltn123','20200814042556159','솔의 눈',800,'2020-10-01 15:32:07'),(119,'rltn123','20200814042556159','초코에몽',1200,'2020-07-01 15:32:27'),(120,'rltn123','20200814042556159','초코에몽',1200,'2020-07-01 15:32:27'),(121,'rltn123','20200814042556159','초코에몽',1200,'2020-08-01 15:32:27'),(122,'rltn123','20200814042556159','초코에몽',1200,'2020-10-01 15:32:27'),(123,'rltn123','20200814042556159','초코에몽',1200,'2020-10-01 15:32:28'),(124,'rltn123','20200814042556159','초코에몽',1200,'2020-10-01 15:32:28'),(125,'rltn123','20200814042556159','바나나우유',1300,'2020-08-01 15:32:44'),(126,'rltn123','20200814042556159','바나나우유',1300,'2020-08-01 15:32:45'),(127,'rltn123','20200814042556159','바나나우유',1300,'2020-08-01 15:32:45'),(128,'rltn123','20200814042556159','바나나우유',1300,'2020-08-01 15:32:45'),(129,'rltn123','20200814042556159','바나나우유',1300,'2020-08-01 15:32:45'),(130,'rltn123','20200814042556159','바나나우유',1300,'2020-09-01 15:32:46'),(131,'rltn123','20200814042556159','바나나우유',1300,'2020-09-01 15:32:46'),(132,'rltn123','20200814042556159','바나나우유',1300,'2020-10-01 15:32:46'),(133,'rltn123','20200814042556159','바나나우유',1300,'2020-10-01 15:32:46'),(134,'rltn123','20200814042556159','바나나우유',1300,'2020-10-01 15:32:47'),(135,'rltn123','20200814042556372','딸기우유',1800,'2019-12-01 15:33:28'),(136,'rltn123','20200814042556372','딸기우유',1800,'2020-01-01 15:33:29'),(137,'rltn123','20200814042556372','딸기우유',1800,'2020-02-01 15:33:30'),(138,'rltn123','20200814042556372','딸기우유',1800,'2020-10-01 15:33:30'),(139,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:30:59'),(140,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:34:21'),(141,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:35:08'),(142,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:37:27'),(143,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:37:32'),(144,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:37:32'),(145,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:37:44'),(146,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:37:45'),(147,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:37:49'),(148,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:37:50'),(149,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:37:51'),(150,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:37:51'),(151,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:38:07'),(152,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:38:07'),(153,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:38:44'),(154,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:38:44'),(155,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:38:52'),(156,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:38:53'),(157,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:38:54'),(158,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:38:55'),(159,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:38:56'),(160,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:39:01'),(161,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:39:05'),(162,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:39:06'),(163,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:39:10'),(164,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:39:11'),(165,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:39:57'),(166,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:39:57'),(167,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:10'),(168,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:10'),(169,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:15'),(170,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:15'),(171,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:20'),(172,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:20'),(173,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:25'),(174,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:26'),(175,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:34'),(176,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:35'),(177,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:40:43'),(178,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:40:44'),(179,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:04'),(180,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:04'),(181,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:05'),(182,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:06'),(183,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:07'),(184,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:07'),(185,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:16'),(186,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:16'),(187,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:28'),(188,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:28'),(189,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:41:36'),(190,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:41:36'),(191,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:32'),(192,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:32'),(193,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:32'),(194,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:32'),(195,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:32'),(196,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:32'),(197,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:32'),(198,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:49'),(199,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:50'),(200,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:51'),(201,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:52'),(202,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:57'),
85(203,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:57'),(204,'rltn123','20200814042555141','박카스',700,'2020-10-13 19:42:58'),(205,'rltn123','20200814042555141','데자와',2000,'2020-10-13 19:42:59'),(206,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:24:09'),(207,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:24:21'),(208,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:24:26'),(209,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:24:32'),(210,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:24:38'),(211,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:25:01'),(212,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:25:06'),(213,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:25:23'),(214,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:25:29'),(215,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:25:35'),(216,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:25:40'),(217,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:25:46'),(218,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:25:52'),(219,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:25:58'),(220,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:26:03'),(221,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:26:09'),(222,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:26:15'),(223,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:26:22'),(224,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:26:28'),(225,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:26:33'),(226,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:26:39'),(227,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:26:45'),(228,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:26:51'),(229,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:26:56'),(230,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:27:02'),(231,'rltn123','20200814042555141','초록 매실',500,'2020-10-13 20:27:45'),(232,'rltn123','20200814042555141','스프라이트',1200,'2020-10-13 20:27:51'),(233,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 02:27:41'),(234,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:28:03'),(235,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 02:28:04'),(236,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:29:29'),(237,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 02:29:30'),(238,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 02:29:36'),(239,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:29:42'),(240,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 02:29:43'),(241,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:29:49'),(242,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 02:29:49'),(243,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:29:55'),(244,'rltn123','20200814042555141','박카스',700,'2020-10-14 02:30:13'),(245,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:30:14'),(246,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 02:30:15'),(247,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:30:21'),(248,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 02:30:33'),(249,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 02:30:39'),(250,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:30:39'),(251,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 02:30:40'),(252,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 02:30:41'),(253,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:30:46'),(254,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 02:30:47'),(255,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 02:30:53'),(256,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 02:30:59'),(257,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:31:04'),(258,'rltn123','20200814042555141','박카스',700,'2020-10-14 02:31:05'),(259,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:31:06'),(260,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 02:31:06'),(261,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:31:12'),(262,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 02:31:13'),(263,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:31:18'),(264,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:34:17'),(265,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:47'),(266,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:48'),(267,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:49'),(268,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:49'),(269,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:50'),(270,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:50'),(271,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:51'),(272,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:35:54'),(273,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:09'),(274,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:10'),(275,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:10'),(276,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:11'),(277,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:12'),(278,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:38:13'),(279,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:39:17'),(280,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:39:19'),(281,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:00'),(282,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:00'),(283,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:01'),(284,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:01'),(285,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:02'),(286,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:02'),(287,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:05'),(288,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:05'),(289,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:06'),(290,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:06'),(291,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:08'),(292,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:08'),(293,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:09'),(294,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:09'),(295,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:30'),(296,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:31'),(297,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:32'),(298,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:33'),(299,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:34'),(300,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:48:35'),(301,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:50:01'),(302,'rltn123','20200814042555141','데자와',2000,'2020-10-14 02:50:10'),(303,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:44:54'),(304,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:44:55'),(305,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:44:57'),(306,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:45:41'),(307,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:45:47'),(308,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:13'),(309,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:14'),(310,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:17'),(311,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:19'),(312,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:47:21'),(313,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:47:27'),(314,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:35'),(315,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:36'),(316,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:47:37'),(317,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 03:47:37'),(318,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:47:43'),(319,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:47:49'),(320,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:53:19'),(321,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:53:25'),(322,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:53:31'),(323,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:53:37'),(324,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 03:54:43'),(325,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:54:54'),(326,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 03:55:00'),(327,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 03:55:11'),(328,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 03:55:31'),(329,'rltn123','20200814042555141','데자와',2000,'2020-10-14 03:55:41'),(330,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 03:56:09'),(331,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:57:55'),(332,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:00'),(333,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:06'),(334,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:12'),(335,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:18'),(336,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:24'),(337,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:30'),(338,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:36'),(339,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:42'),(340,'rltn123','20200814042555141','비타 500',100,'2020-10-14 06:58:48'),(341,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:27:57'),(342,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:33:53'),(343,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:33:59'),(344,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:34:05'),(345,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:34:11'),
86(346,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:34:37'),(347,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:36:05'),(348,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:36:26'),(349,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:36:32'),(350,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:36:38'),(351,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:36:50'),(352,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:36:56'),(353,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:37:33'),(354,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:37:39'),(355,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:37:45'),(356,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:37:50'),(357,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:37:56'),(358,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 07:38:02'),(359,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:38:08'),(360,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:38:13'),(361,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:38:19'),(362,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:38:25'),(363,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:38:31'),(364,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:38:37'),(365,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:38:43'),(366,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:38:49'),(367,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:38:55'),(368,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:39:00'),(369,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:39:11'),(370,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:39:16'),(371,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:39:30'),(372,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:39:38'),(373,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:39:43'),(374,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:40:55'),(375,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:41:01'),(376,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:41:06'),(377,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:41:16'),(378,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:53:58'),(379,'rltn123','20200814042555141','데자와',2000,'2020-10-14 07:54:04'),(380,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 07:57:29'),(381,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 07:57:35'),(382,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 07:57:40'),(383,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 07:57:46'),(384,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:57:52'),(385,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:57:58'),(386,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:58:04'),(387,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 07:58:31'),(388,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:03:52'),(389,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:36:46'),(390,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:36:51'),(391,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 08:37:20'),(392,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:45:49'),(393,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 08:46:43'),(394,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 08:46:49'),(395,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 08:46:54'),(396,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:46:59'),(397,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:47:04'),(398,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:47:08'),(399,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 08:47:13'),(400,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:47:18'),(401,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:47:23'),(402,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 08:47:27'),(403,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:47:32'),(404,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:53:20'),(405,'rltn123','20200814042555141','데자와',2000,'2020-10-14 08:53:37'),(406,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 08:53:42'),(407,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 09:19:45'),(408,'rltn123','20200814042555141','데자와',2000,'2020-10-14 09:19:51'),(409,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 09:19:57'),(410,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 09:20:02'),(411,'rltn123','20200814042555141','스프라이트',1200,'2020-10-14 09:20:14'),(412,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 09:20:21'),(413,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 09:20:26'),(414,'rltn123','20200814042555141','박카스',700,'2020-10-14 09:20:32'),(415,'rltn123','20200814042555141','비타 500',100,'2020-10-14 09:20:37'),(416,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 09:20:53'),(417,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-14 10:58:29'),(418,'rltn123','20200814042555141','데자와',2000,'2020-10-14 10:58:35'),(419,'rltn123','20200814042555141','파워에이드',5500,'2020-10-14 10:58:41'),(420,'rltn123','20200814042555141','초록 매실',500,'2020-10-14 10:58:47'),(421,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-14 10:58:53'),(422,'rltn123','20200814042555141','박카스',700,'2020-10-14 10:58:59'),(423,'rltn123','20200814042555141','비타 500',100,'2020-10-14 10:59:04'),(424,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-17 11:14:13'),(425,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-17 11:16:27'),(426,'rltn123','20200814042555141','데자와',2000,'2020-10-17 11:16:33'),(427,'rltn123','20200814042555141','파워에이드',5500,'2020-10-17 11:16:40'),(428,'rltn123','20200814042555141','스프라이트',1200,'2020-10-17 11:16:45'),(429,'rltn123','20200814042555141','초록 매실',500,'2020-10-17 11:16:51'),(430,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-17 11:17:00'),(431,'rltn123','20200814042555141','박카스',700,'2020-10-17 11:17:09'),(432,'rltn123','20200814042555141','비타 500',100,'2020-10-17 11:17:15'),(433,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-17 14:03:23'),(434,'rltn123','20200814042555141','데자와',2000,'2020-10-17 14:03:29'),(435,'rltn123','20200814042555141','파워에이드',5500,'2020-10-17 14:03:37'),(436,'rltn123','20200814042555141','초록 매실',500,'2020-10-17 14:04:15'),(437,'rltn123','20200814042555141','갈아만든 배',800,'2020-10-17 14:04:20'),(438,'rltn123','20200814042555141','스프라이트',1200,'2020-10-17 14:04:26'),(439,'rltn123','20200814042555141','박카스',700,'2020-10-17 14:04:48'),(440,'rltn123','20200814042555141','비타 500',100,'2020-10-17 14:04:54'),(441,'rltn123','20200814042555141','파워에이드',5500,'2020-10-17 14:04:59'),(442,'rltn123','20200814042555141','데자와',2000,'2020-10-17 14:05:04'),(443,'rltn123','20200814042555141','펩시 콜라',1500,'2020-10-17 14:05:12'),(444,'rltn123','20200814042555141','스프라이트',1200,'2020-10-17 14:06:55');
87
88