[Project] 개발 DB에서 운영 DB로 마이그레이션 중 발생한 문제 해결 과정
FoodyMoody 프로젝트에 대한 설명입니다.
문제 발생
원래 개발 DB에서는 ddl의 create-drop 옵션으로 data.sql을 생성하여 서버를 실행할 때마다 dummy를 INSERT 해주도록 했었지만, 운영 DB에서도 같은 짓을 했다가는 큰일날 수도 있다.
개발 서버 data.sql
INSERT INTO store_mood (id, name)
VALUES ('1', '가족과 함께'),
('2', '혼밥'),
('3', '감성'),
('4', '데이트'),
('5', '루프탑'),
('6', '특별한 테마'),
('7', '친구와 함께'),
('8', '비즈니스 미팅'),
('9', '파티'),
('10', '휴식'),
('11', '스포츠 시청'),
('12', '야경'),
('13', '바다 전망'),
('14', '산 전망'),
('15', '도시 전망'),
('16', '자연 친화적'),
('17', '아침 식사'),
('18', '점심 식사'),
('19', '저녁 식사'),
('20', '야식');
INSERT INTO taste_mood (id, name)
VALUES ('1', '매운맛'),
('2', '단맛'),
('3', '짠맛'),
('4', '신맛'),
('5', '쓴맛'),
('6', '기름진맛'),
('7', '가벼운맛'),
('8', '무거운맛'),
('9', '새콤한맛'),
('10', '담백한맛'),
('11', '풍부한맛'),
('12', '깔끔한맛'),
('13', '부드러운맛'),
('14', '칼칼한맛'),
('15', '짭짤한맛'),
('16', '달큰한맛'),
('17', '향긋한맛'),
('18', '고소한맛'),
('19', '시원한맛'),
('20', '따뜻한맛');
insert into foodymoody.oauth_provider (name)
values ('GOOGLE');
insert into image (id, url, uploader_id, created_at, deleted)
values ('member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg',
'2023-03-04 14:23:04',
'2023-07-01 17:22:34', false)
, (1, 'https://cdn.pixabay.com/photo/2015/05/02/00/57/aluminous-749358_1280.jpg', '2023-03-04 14:23:04',
'2023-07-01 17:22:34', false)
, (2, 'https://cdn.pixabay.com/photo/2017/07/27/16/45/i-2545938_1280.jpg', '2022-11-21 22:10:20',
'2023-06-08 11:22:38', false)
, (3, 'https://cdn.pixabay.com/photo/2016/07/22/05/07/delicious-1534207_1280.jpg', '2023-04-21 07:09:30',
'2023-08-21 00:50:05', false)
, (4, 'https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg', '2023-05-11 19:45:32',
'2023-12-31 12:46:07', false)
, (5, 'https://cdn.pixabay.com/photo/2016/10/13/19/15/bibimbap-1738580_1280.jpg', '2023-05-05 10:27:28',
'2023-06-22 18:05:26', false)
, (6, 'https://cdn.pixabay.com/photo/2017/08/08/09/44/food-photography-2610863_1280.jpg', '2022-05-09 08:49:09',
'2023-03-27 13:49:19', false)
, (7, 'https://cdn.pixabay.com/photo/2017/06/12/15/02/of-2395811_1280.jpg', '2023-03-30 07:59:57',
'2024-01-15 20:15:45', false)
, (8, 'https://cdn.pixabay.com/photo/2017/08/14/15/52/bachelor-business-2640909_1280.jpg', '2023-12-10 14:33:41',
'2024-02-10 23:12:03', false)
, (9, 'https://cdn.pixabay.com/photo/2016/04/22/18/52/chicken-soup-1346310_1280.jpg', '2023-10-05 08:04:12',
'2023-12-19 21:14:45', false)
, (10, 'https://cdn.pixabay.com/photo/2017/08/08/09/44/food-photography-2610864_1280.jpg', '2023-03-25 06:56:42',
'2023-12-18 19:36:51', false)
, (11, 'https://cdn.pixabay.com/photo/2016/01/15/06/57/vegetarian-1141242_1280.jpg', '2023-11-10 01:58:37',
'2023-12-09 14:21:21', false)
, (12, 'https://cdn.pixabay.com/photo/2014/01/09/10/14/kimchi-fried-rice-241051_1280.jpg', '2023-10-29 15:44:10',
'2024-01-27 17:59:14', false)
, (13, 'https://cdn.pixabay.com/photo/2017/01/11/08/30/market-1971125_1280.jpg', '2023-01-08 18:45:17',
'2023-02-17 20:33:10', false)
, (14, 'https://cdn.pixabay.com/photo/2017/06/28/03/58/kimchi-2449656_1280.jpg', '2022-07-11 18:31:22',
'2023-02-28 06:12:55', false)
, (15, 'https://cdn.pixabay.com/photo/2016/01/04/07/07/korean-cabbage-in-chili-sauce-1120406_1280.jpg',
'2023-10-16 02:05:02', '2024-02-01 23:52:09', false)
, (16, 'https://cdn.pixabay.com/photo/2019/11/23/15/30/ramen-4647411_1280.jpg', '2022-12-07 05:29:40',
'2023-07-06 04:34:26', false)
, (17, 'https://cdn.pixabay.com/photo/2015/04/22/06/57/gopchang-734303_1280.jpg', '2023-10-08 03:44:22',
'2023-11-06 02:27:22', false)
, (18, 'https://cdn.pixabay.com/photo/2015/03/27/15/36/bob-694825_1280.jpg', '2023-06-11 16:06:44',
'2023-12-20 17:24:34', false)
, (19, 'https://cdn.pixabay.com/photo/2015/05/02/00/59/herbs-749360_1280.jpg', '2023-04-17 21:16:54',
'2023-07-06 12:20:23', false)
, (20, 'https://cdn.pixabay.com/photo/2014/04/17/05/18/namdaemun-market-326146_1280.jpg', '2023-07-01 11:07:58',
'2023-10-05 16:12:48', false)
, (21, 'https://cdn.pixabay.com/photo/2017/03/20/09/06/food-2158540_1280.jpg', '2022-12-25 00:18:54',
'2023-06-04 14:59:48', false)
, (22, 'https://cdn.pixabay.com/photo/2016/08/10/10/28/vegetable-1582920_1280.jpg', '2023-01-04 12:22:05',
'2023-08-25 10:45:29', false)
, (23, 'https://cdn.pixabay.com/photo/2016/01/05/09/48/pork-1122171_1280.jpg', '2023-06-06 05:06:19',
'2023-08-03 09:14:24', false)
, (24, 'https://cdn.pixabay.com/photo/2017/07/27/16/48/toppokki-2545943_1280.jpg', '2023-07-11 11:58:39',
'2023-08-04 07:19:57', false)
, (25, 'https://cdn.pixabay.com/photo/2015/04/06/16/29/noodles-709609_1280.jpg', '2023-07-20 23:33:50',
'2023-09-03 01:01:07', false)
, (26, 'https://cdn.pixabay.com/photo/2018/12/10/00/27/tang-fish-cakes-3866061_1280.jpg', '2023-02-17 08:30:05',
'2023-09-13 10:49:40', false)
, (27, 'https://cdn.pixabay.com/photo/2015/02/16/17/59/side-dish-638660_1280.jpg', '2023-07-16 19:12:03',
'2023-08-09 07:50:01', false)
, (28, 'https://cdn.pixabay.com/photo/2019/07/25/01/35/kimchi-4361465_1280.jpg', '2023-04-24 08:29:24',
'2023-08-01 21:43:08', false)
, (29, 'https://cdn.pixabay.com/photo/2017/07/19/03/17/gopchang-2517774_1280.jpg', '2023-11-25 23:19:33',
'2023-12-08 19:11:12', false)
, (30, 'https://cdn.pixabay.com/photo/2015/06/26/02/58/korean-food-822092_1280.jpg', '2023-05-21 07:05:54',
'2023-08-01 12:52:16', false)
, (31, 'https://cdn.pixabay.com/photo/2017/03/20/09/08/food-2158543_1280.jpg', '2023-02-09 15:09:15',
'2023-08-01 11:58:47', false)
, (32, 'https://cdn.pixabay.com/photo/2015/12/18/13/00/pork-1098553_1280.jpg', '2023-04-10 04:06:09',
'2023-09-20 10:56:05', false)
, (33, 'https://cdn.pixabay.com/photo/2015/05/03/13/51/korean-tteokgalbi-751205_1280.jpg', '2023-07-17 00:32:38',
'2023-09-05 15:27:29', false)
, (34, 'https://cdn.pixabay.com/photo/2016/08/10/10/27/pork-1582916_1280.jpg', '2023-03-12 04:09:14',
'2023-03-19 22:23:12', false)
, (35, 'https://cdn.pixabay.com/photo/2017/03/22/06/53/food-2164202_1280.jpg', '2023-08-28 06:01:41',
'2023-10-26 21:00:11', false)
, (36, 'https://cdn.pixabay.com/photo/2015/04/06/16/34/kimchi-photos-709623_1280.jpg', '2023-12-09 13:03:58',
'2023-12-23 03:15:24', false)
, (37, 'https://cdn.pixabay.com/photo/2017/07/19/03/14/lures-and-buy-new-desktop-2517767_1280.jpg',
'2023-05-26 07:49:07', '2023-07-27 06:37:31', false)
, (38, 'https://cdn.pixabay.com/photo/2017/11/06/13/18/skate-2923636_1280.jpg', '2023-05-17 01:59:23',
'2023-08-09 18:56:45', false)
, (39, 'https://cdn.pixabay.com/photo/2017/01/19/05/14/korean-cuisine-1991580_1280.jpg', '2023-10-06 07:32:30',
'2023-11-18 04:27:09', false)
, (40, 'https://cdn.pixabay.com/photo/2016/07/22/05/10/delicious-1534220_1280.jpg', '2023-12-24 22:56:21',
'2023-02-02 11:12:12', false)
, (41, 'https://cdn.pixabay.com/photo/2016/04/22/18/40/kimchi-pizza-1346290_1280.jpg', '2023-09-25 12:03:39',
'2023-03-25 18:19:28', false)
, (42, 'https://cdn.pixabay.com/photo/2018/12/03/01/04/kimchi-3852526_1280.jpg', '2023-04-30 00:17:21',
'2023-09-30 08:32:03', false)
, (43, 'https://cdn.pixabay.com/photo/2017/12/20/03/52/noodles-3029172_1280.jpg', '2023-07-12 19:34:22',
'2023-03-18 20:04:26', false)
, (44, 'https://cdn.pixabay.com/photo/2019/03/26/01/14/tofu-4081697_1280.jpg', '2023-03-16 06:54:58',
'2023-04-13 00:23:45', false)
, (45, 'https://cdn.pixabay.com/photo/2020/02/28/12/40/bibimbap-4887394_1280.jpg', '2023-02-23 06:51:08',
'2023-05-02 13:23:31', false)
, (46, 'https://cdn.pixabay.com/photo/2018/12/03/01/04/mandu-3852527_1280.jpg', '2023-10-07 07:33:50',
'2023-01-11 17:59:53', false)
, (47, 'https://cdn.pixabay.com/photo/2015/04/06/16/27/feast-noodles-709608_1280.jpg', '2023-07-26 12:29:48',
'2023-11-23 05:23:21', false)
, (48, 'https://cdn.pixabay.com/photo/2015/11/20/08/17/meat-1052571_1280.jpg', '2023-09-04 10:11:58',
'2023-08-20 00:19:30', false)
, (49, 'https://cdn.pixabay.com/photo/2018/12/10/00/27/tang-fish-cakes-3866060_1280.jpg', '2023-07-03 21:10:46',
'2023-07-15 15:04:58', false)
, (50, 'https://cdn.pixabay.com/photo/2021/10/16/12/50/hotpot-6714953_1280.jpg', '2023-05-10 11:36:24',
'2023-11-24 07:41:37', false)
, (51, 'https://cdn.pixabay.com/photo/2017/08/10/08/39/snow-crab-2620060_1280.jpg', '2023-05-16 12:18:17',
'2023-11-27 10:04:33', false)
, (52, 'https://cdn.pixabay.com/photo/2015/04/28/07/40/korean-743153_1280.jpg', '2023-04-20 20:26:45',
'2023-11-18 13:26:31', false)
, (53, 'https://cdn.pixabay.com/photo/2017/07/22/11/09/food-2528411_1280.jpg', '2023-10-01 23:16:53',
'2023-12-03 15:19:40', false)
, (54, 'https://cdn.pixabay.com/photo/2019/11/23/15/26/ramen-4647408_1280.jpg', '2023-12-14 16:10:26',
'2023-12-30 06:42:39', false)
, (55, 'https://cdn.pixabay.com/photo/2019/09/30/03/07/buckwheat-subtitles-chinese-4514719_1280.jpg',
'2023-02-13 19:31:50', '2023-12-26 11:19:58', false)
, (56, 'https://cdn.pixabay.com/photo/2016/07/22/05/11/delicious-1534227_1280.jpg', '2023-06-01 13:50:08',
'2023-12-08 06:04:09', false)
, (57, 'https://cdn.pixabay.com/photo/2015/06/26/02/52/korean-food-822082_1280.jpg', '2023-01-23 15:38:29',
'2023-12-17 12:20:39', false)
, (58, 'https://cdn.pixabay.com/photo/2021/01/22/06/05/kimchi-5939198_1280.jpg', '2023-03-30 23:09:48',
'2023-12-09 11:58:56', false)
, (59, 'https://cdn.pixabay.com/photo/2017/06/12/15/01/skewers-2395810_1280.jpg', '2023-08-02 09:31:06',
'2023-12-22 05:58:55', false)
, (60, 'https://cdn.pixabay.com/photo/2015/06/26/02/57/korean-food-822090_1280.jpg', '2023-02-08 16:11:27',
'2023-12-26 13:13:54', false)
, (61, 'https://cdn.pixabay.com/photo/2019/11/21/18/28/garlic-ribs-4643142_1280.jpg', '2023-07-11 00:24:22',
'2023-12-12 22:02:32', false);
insert into foodymoody.member (id, created_at, email, nickname, password, profile_image_id, profile_image_url, taste_mood_id)
values ('1', '2024-02-16 06:32:06.000000', 'albert@albert.com', '알버트', 'test123!', 'member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '1'),
('2', '2024-02-16 06:32:06.000000', 'sully@sully.com', '설리', 'test123!', 'member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '2'),
('3', '2024-02-16 06:32:06.000000', 'bono@bono.com', '보노보노', 'test123!', 'member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '7'),
('4', '2024-02-16 06:32:06.000000', 'ati@ati.com', '아티', 'test123!', 'member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '4'),
('5', '2024-02-16 06:32:06.000000', 'puban@puban.com', '푸반', 'test123!', 'member-profile-default', 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '5');
insert into foodymoody.image_menu (id, display_order, image_id, menu_id)
values ('1', 1, '2', '1'),
('2', 2, '3', '2'),
('3', 3, '4', '3'),
('4', 4, '5', '4'),
('5', 5, '6', '5'),
('6', 6, '7', '6'),
('a1c1eb6300000014b611c33f', 0, '2', 'a1c1eaf700000014b611c33c'),
('a1c1eb6300000014b611c340', 1, '4', 'a1c1eb0700000014b611c33d'),
('a1c1ed3100000014b611c34a', 0, '2', 'a1c1ed0600000014b611c347'),
('a1c1ed3100000014b611c34b', 1, '4', 'a1c1ed0900000014b611c348');
insert into foodymoody.feed (id, created_at, like_count, member_id, profile_image_url, review, store_id, updated_at)
values ('1', '2023-11-07 11:11:11.000000', 10, '2', 'https://cdn.pixabay.com/photo/2015/05/02/00/57/aluminous-749358_1280.jpg', '맛있어요!', '1', '2023-11-08 14:11:11.000000'),
('10', '2023-10-29 02:02:02.000000', 0, '5', 'https://cdn.pixabay.com/photo/2017/08/08/09/44/food-photography-2610864_1280.jpg', '다시 오고 싶어요!', '1', '2023-10-30 05:02:02.000000'),
('11', '2023-10-28 01:01:01.000000', 9, '2', 'https://cdn.pixabay.com/photo/2016/01/15/06/57/vegetarian-1141242_1280.jpg', '최악이었어요', '1', '2023-10-29 04:01:01.000000'),
('12', '2023-10-27 15:15:15.000000', 7, '2', 'https://cdn.pixabay.com/photo/2014/01/09/10/14/kimchi-fried-rice-241051_1280.jpg', '정말 괜찮았어요!', '1', '2023-10-28 08:15:15.000000'),
('13', '2023-10-26 14:14:14.000000', 0, '1', 'https://cdn.pixabay.com/photo/2017/01/11/08/30/market-1971125_1280.jpg', '다시는 안 가고 싶어요', '1', '2023-10-27 09:14:14.000000'),
('14', '2023-10-25 13:13:13.000000', 16, '2', 'https://cdn.pixabay.com/photo/2017/06/28/03/58/kimchi-2449656_1280.jpg', '평이하네요', '1', '2023-10-26 10:13:13.000000'),
('15', '2023-10-24 12:12:12.000000', 0, '3', 'https://cdn.pixabay.com/photo/2016/01/04/07/07/korean-cabbage-in-chili-sauce-1120406_1280.jpg', '최고예요!', '1', '2023-10-25 11:12:12.000000'),
('16', '2023-10-23 11:11:11.000000', 14, '2', 'https://cdn.pixabay.com/photo/2019/11/23/15/30/ramen-4647411_1280.jpg', '볼만해요', '1', '2023-10-24 12:11:11.000000'),
('17', '2023-10-22 10:10:10.000000', 0, '5', 'https://cdn.pixabay.com/photo/2015/04/22/06/57/gopchang-734303_1280.jpg', '기대 이하였어요', '1', '2023-10-23 13:10:10.000000'),
('18', '2023-10-21 09:09:09.000000', 0, '2', 'https://cdn.pixabay.com/photo/2015/03/27/15/36/bob-694825_1280.jpg', '추천드려요!', '1', '2023-10-22 14:09:09.000000'),
('19', '2023-10-20 08:08:08.000000', 0, '4', 'https://cdn.pixabay.com/photo/2015/05/02/00/59/herbs-749360_1280.jpg', '그럭저럭이에요', '1', '2023-10-21 15:08:08.000000'),
('2', '2023-11-06 10:10:10.000000', 0, '1', 'https://cdn.pixabay.com/photo/2017/07/27/16/45/i-2545938_1280.jpg', '좋아요!', '2', '2023-11-07 13:10:10.000000'),
('20', '2023-10-19 07:07:07.000000', 22, '2', 'https://cdn.pixabay.com/photo/2014/04/17/05/18/namdaemun-market-326146_1280.jpg', '별로였어요', '1', '2023-10-20 16:07:07.000000'),
('21', '2023-10-18 06:06:06.000000', 0, '1', 'https://cdn.pixabay.com/photo/2017/03/20/09/06/food-2158540_1280.jpg', '최고의 맛!', '1', '2023-10-19 17:06:06.000000'),
('22', '2023-10-17 05:05:05.000000', 17, '2', 'https://cdn.pixabay.com/photo/2016/08/10/10/28/vegetable-1582920_1280.jpg', '가볼만 합니다', '1', '2023-10-18 18:05:05.000000'),
('23', '2023-10-16 04:04:04.000000', 0, '1', 'https://cdn.pixabay.com/photo/2016/01/05/09/48/pork-1122171_1280.jpg', '평균 이상이에요', '1', '2023-10-17 19:04:04.000000'),
('24', '2023-10-15 03:03:03.000000', 6, '2', 'https://cdn.pixabay.com/photo/2017/07/27/16/48/toppokki-2545943_1280.jpg', '다시 방문하고 싶네요', '1', '2023-10-16 20:03:03.000000'),
('25', '2023-10-14 02:02:02.000000', 0, '5', 'https://cdn.pixabay.com/photo/2015/04/06/16/29/noodles-709609_1280.jpg', '별로 추천하고 싶지 않아요', '1', '2023-10-15 21:02:02.000000'),
('26', '2023-10-13 01:01:01.000000', 9, '3', 'https://cdn.pixabay.com/photo/2018/12/10/00/27/tang-fish-cakes-3866061_1280.jpg', '매우 만족스러워요', '1', '2023-10-14 22:01:01.000000'),
('27', '2023-10-12 00:00:00.000000', 0, '2', 'https://cdn.pixabay.com/photo/2015/02/16/17/59/side-dish-638660_1280.jpg', '기대했던 것보다 덜해요', '1', '2023-10-13 23:00:00.000000'),
('28', '2023-10-11 23:23:23.000000', 5, '2', 'https://cdn.pixabay.com/photo/2019/07/25/01/35/kimchi-4361465_1280.jpg', '정말 최악이었어요', '1', '2023-10-12 22:23:23.000000'),
('29', '2023-10-10 22:22:22.000000', 0, '4', 'https://cdn.pixabay.com/photo/2017/07/19/03/17/gopchang-2517774_1280.jpg', '훌륭합니다!', '1', '2023-10-11 21:22:22.000000'),
('3', '2023-11-05 09:09:09.000000', 20, '2', 'https://cdn.pixabay.com/photo/2016/07/22/05/07/delicious-1534207_1280.jpg', '아주 맛있습니다!', '2', '2023-11-06 12:09:09.000000'),
('30', '2023-10-09 21:21:21.000000', 24, '1', 'https://cdn.pixabay.com/photo/2015/06/26/02/58/korean-food-822092_1280.jpg', '보통이에요', '1', '2023-10-10 20:21:21.000000'),
('31', '2023-10-08 20:20:20.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/03/20/09/08/food-2158543_1280.jpg', '맛있습니다!', '1', '2023-10-09 19:20:20.000000'),
('32', '2023-10-07 19:19:19.000000', 15, '5', 'https://cdn.pixabay.com/photo/2015/12/18/13/00/pork-1098553_1280.jpg', '맛있어요!', '1', '2023-10-08 18:19:19.000000'),
('33', '2023-10-06 18:18:18.000000', 0, '2', 'https://cdn.pixabay.com/photo/2015/05/03/13/51/korean-tteokgalbi-751205_1280.jpg', '별로였어요', '1', '2023-10-07 17:18:18.000000'),
('34', '2023-10-05 17:17:17.000000', 25, '2', 'https://cdn.pixabay.com/photo/2016/08/10/10/27/pork-1582916_1280.jpg', '괜찮았어요', '1', '2023-10-06 16:17:17.000000'),
('35', '2023-10-04 16:16:16.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/03/22/06/53/food-2164202_1280.jpg', '추천합니다!', '1', '2023-10-05 15:16:16.000000'),
('36', '2023-10-03 15:15:15.000000', 20, '3', 'https://cdn.pixabay.com/photo/2015/04/06/16/34/kimchi-photos-709623_1280.jpg', '다시 방문할게요', '1', '2023-10-04 14:15:15.000000'),
('37', '2023-10-02 14:14:14.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/07/19/03/14/lures-and-buy-new-desktop-2517767_1280.jpg', '별로 추천하고 싶지 않아요', '1', '2023-10-03 13:14:14.000000'),
('38', '2023-10-01 13:13:13.000000', 18, '2', 'https://cdn.pixabay.com/photo/2017/11/06/13/18/skate-2923636_1280.jpg', '아주 좋았어요!', '1', '2023-10-02 12:13:13.000000'),
('39', '2023-09-30 12:12:12.000000', 0, '5', 'https://cdn.pixabay.com/photo/2017/01/19/05/14/korean-cuisine-1991580_1280.jpg', '평범해요', '1', '2023-10-01 11:12:12.000000'),
('4', '2023-11-04 08:08:08.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg', '평범해요', '4', '2023-11-05 11:08:08.000000'),
('40', '2023-09-29 11:11:11.000000', 22, '2', 'https://cdn.pixabay.com/photo/2016/07/22/05/10/delicious-1534220_1280.jpg', '좋았습니다!', '1', '2023-09-30 10:11:11.000000'),
('41', '2023-09-28 10:10:10.000000', 0, '2', 'https://cdn.pixabay.com/photo/2016/04/22/18/40/kimchi-pizza-1346290_1280.jpg', '기대 이하였어요', '1', '2023-09-29 09:10:10.000000'),
('42', '2023-09-27 09:09:09.000000', 16, '1', 'https://cdn.pixabay.com/photo/2018/12/03/01/04/kimchi-3852526_1280.jpg', '다시 오고 싶어요!', '1', '2023-09-28 08:09:09.000000'),
('43', '2023-09-26 08:08:08.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/12/20/03/52/noodles-3029172_1280.jpg', '훌륭합니다!', '1', '2023-09-27 07:08:08.000000'),
('44', '2023-09-25 07:07:07.000000', 11, '4', 'https://cdn.pixabay.com/photo/2019/03/26/01/14/tofu-4081697_1280.jpg', '그저 그래요', '1', '2023-09-26 06:07:07.000000'),
('45', '2023-09-24 06:06:06.000000', 0, '3', 'https://cdn.pixabay.com/photo/2019/03/26/01/14/tofu-4081697_1280.jpg', '매우 만족스러워요', '1', '2023-09-25 05:06:06.000000'),
('46', '2023-09-23 05:05:05.000000', 21, '2', 'https://cdn.pixabay.com/photo/2018/12/03/01/04/mandu-3852527_1280.jpg', '정말 최고!', '1', '2023-09-24 04:05:05.000000'),
('47', '2023-09-22 04:04:04.000000', 0, '5', 'https://cdn.pixabay.com/photo/2015/04/06/16/27/feast-noodles-709608_1280.jpg', '가볼만 합니다', '1', '2023-09-23 03:04:04.000000'),
('48', '2023-09-21 03:03:03.000000', 13, '2', 'https://cdn.pixabay.com/photo/2015/11/20/08/17/meat-1052571_1280.jpg', '평균 이상이에요', '1', '2023-09-22 02:03:03.000000'),
('49', '2023-09-20 02:02:02.000000', 0, '1', 'https://cdn.pixabay.com/photo/2018/12/10/00/27/tang-fish-cakes-3866060_1280.jpg', '최악이었어요', '1', '2023-09-21 01:02:02.000000'),
('5', '2023-11-03 07:07:07.000000', 30, '4', 'https://cdn.pixabay.com/photo/2016/10/13/19/15/bibimbap-1738580_1280.jpg', '정말 최고!', '5', '2023-11-04 10:07:07.000000'),
('50', '2023-09-19 01:01:01.000000', 23, '2', 'https://cdn.pixabay.com/photo/2021/10/16/12/50/hotpot-6714953_1280.jpg', '보통이에요', '1', '2023-09-20 00:01:01.000000'),
('51', '2023-09-18 00:00:00.000000', 0, '3', 'https://cdn.pixabay.com/photo/2017/08/10/08/39/snow-crab-2620060_1280.jpg', '추천드려요!', '1', '2023-09-19 23:00:00.000000'),
('52', '2023-09-17 23:23:23.000000', 22, '2', 'https://cdn.pixabay.com/photo/2015/04/28/07/40/korean-743153_1280.jpg', '매우 좋았어요!', '1', '2023-09-18 22:23:23.000000'),
('53', '2023-09-16 22:22:22.000000', 0, '5', 'https://cdn.pixabay.com/photo/2017/07/22/11/09/food-2528411_1280.jpg', '보통이에요', '1', '2023-09-17 21:22:22.000000'),
('54', '2023-09-15 21:21:21.000000', 14, '2', 'https://cdn.pixabay.com/photo/2019/11/23/15/26/ramen-4647408_1280.jpg', '평균 이상이에요', '1', '2023-09-16 20:21:21.000000'),
('55', '2023-09-14 20:20:20.000000', 0, '1', 'https://cdn.pixabay.com/photo/2019/09/30/03/07/buckwheat-subtitles-chinese-4514719_1280.jpg', '다시 오고 싶어요!', '1', '2023-09-15 19:20:20.000000'),
('56', '2023-09-13 19:19:19.000000', 6, '2', 'https://cdn.pixabay.com/photo/2016/07/22/05/11/delicious-1534227_1280.jpg', '좋았습니다!', '1', '2023-09-14 18:19:19.000000'),
('57', '2023-09-12 18:18:18.000000', 0, '3', 'https://cdn.pixabay.com/photo/2015/06/26/02/52/korean-food-822082_1280.jpg', '별로였어요', '1', '2023-09-13 17:18:18.000000'),
('58', '2023-09-11 17:17:17.000000', 13, '1', 'https://cdn.pixabay.com/photo/2021/01/22/06/05/kimchi-5939198_1280.jpg', '추천합니다!', '1', '2023-09-12 16:17:17.000000'),
('59', '2023-09-10 16:16:16.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/06/12/15/01/skewers-2395810_1280.jpg', '평범해요', '1', '2023-09-11 15:16:16.000000'),
('6', '2023-11-02 06:06:06.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/08/08/09/44/food-photography-2610863_1280.jpg', '별로예요', '5', '2023-11-03 09:06:06.000000'),
('60', '2023-09-09 15:15:15.000000', 11, '5', 'https://cdn.pixabay.com/photo/2015/06/26/02/57/korean-food-822090_1280.jpg', '맛있어요!', '1', '2023-09-10 14:15:15.000000'),
('61', '2023-09-08 14:14:14.000000', 0, '1', 'https://cdn.pixabay.com/photo/2019/11/21/18/28/garlic-ribs-4643142_1280.jpg', '기대 이하였어요', '1', '2023-09-09 13:14:14.000000'),
('7', '2023-11-01 05:05:05.000000', 18, '3', 'https://cdn.pixabay.com/photo/2017/06/12/15/02/of-2395811_1280.jpg', '추천합니다!', '1', '2023-11-02 08:05:05.000000'),
('8', '2023-10-31 04:04:04.000000', 0, '2', 'https://cdn.pixabay.com/photo/2017/08/14/15/52/bachelor-business-2640909_1280.jpg', '괜찮아요', '1', '2023-11-01 07:04:04.000000'),
('9', '2023-10-30 03:03:03.000000', 8, '2', 'https://cdn.pixabay.com/photo/2016/04/22/18/52/chicken-soup-1346310_1280.jpg', '그저 그래요', '1', '2023-10-31 06:03:03.000000'),
('a1c1eb5e00000014b611c33e', null, 0, '5', 'https://cdn.pixabay.com/photo/2016/10/13/19/15/bibimbap-1738580_1280.jpg', '맛있어요!', '1', null),
('a1c1ed3100000014b611c349', null, 1, '4', 'https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg', '맛있어요!', '1', null);
insert into foodymoody.menu (id, name, rating)
values ('1', '짜장면', 1),
('2', '감자탕', 2),
('3', '불고기', 3),
('4', '비빔밥', 4),
('5', '비빔밥', 5),
('6', '호박전', 6),
('a1c1eaf700000014b611c33c', '감자탕', 4),
('a1c1eb0700000014b611c33d', '비빔밥', 3),
('a1c1ed0600000014b611c347', '감자탕', 4),
('a1c1ed0900000014b611c348', '비빔밥', 3);
insert into foodymoody.feed_image_menus_list (feed_id, image_menus_list_id)
values ('1', '1'),
('1', '2'),
('1', '3'),
('1', '4'),
('2', '5'),
('2', '6'),
('a1c1eb5e00000014b611c33e', 'a1c1eb6300000014b611c33f'),
('a1c1eb5e00000014b611c33e', 'a1c1eb6300000014b611c340'),
('a1c1ed3100000014b611c349', 'a1c1ed3100000014b611c34a'),
('a1c1ed3100000014b611c349', 'a1c1ed3100000014b611c34b');
insert into foodymoody.feed_store_moods (feed_id, store_moods_id)
values ('1', '1'),
('2', '2'),
('3', '3'),
('4', '4'),
('5', '5'),
('6', '6'),
('a1c1eb5e00000014b611c33e', '1'),
('a1c1eb5e00000014b611c33e', '3'),
('a1c1eb5e00000014b611c33e', '4'),
('a1c1ed3100000014b611c349', '1'),
('a1c1ed3100000014b611c349', '3'),
('a1c1ed3100000014b611c349', '4');
insert into foodymoody.feed_comment (id, content, created_at, deleted, feed_id, has_reply, member_id, updated_at)
values ('1', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', false, '1', true, '1', '2023-11-07 11:11:11.000000'),
('10', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', false, '1', false, '5', '2023-11-07 11:20:11.000000'),
('11', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', false, '1', false, '1', '2023-11-07 11:11:11.000000'),
('12', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', true, '1', false, '2', '2023-11-07 11:12:11.000000'),
('13', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', true, '1', false, '3', '2023-11-07 11:13:11.000000'),
('14', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', true, '1', false, '4', '2023-11-07 11:14:11.000000'),
('15', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', true, '1', false, '5', '2023-11-07 11:15:11.000000'),
('16', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', true, '1', false, '1', '2023-11-07 11:16:11.000000'),
('17', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', true, '1', false, '2', '2023-11-07 11:17:11.000000'),
('18', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', true, '1', false, '3', '2023-11-07 11:18:11.000000'),
('19', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', true, '1', false, '4', '2023-11-07 11:19:11.000000'),
('2', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', false, '1', false, '2', '2023-11-07 11:12:11.000000'),
('20', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', true, '1', false, '5', '2023-11-07 11:20:11.000000'),
('21', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', true, '1', false, '1', '2023-11-07 11:11:11.000000'),
('22', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', true, '1', false, '2', '2023-11-07 11:12:11.000000'),
('23', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', true, '1', false, '3', '2023-11-07 11:13:11.000000'),
('24', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', true, '1', false, '4', '2023-11-07 11:14:11.000000'),
('25', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', true, '1', false, '5', '2023-11-07 11:15:11.000000'),
('26', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', true, '1', false, '1', '2023-11-07 11:16:11.000000'),
('27', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', true, '1', false, '2', '2023-11-07 11:17:11.000000'),
('28', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', true, '1', false, '3', '2023-11-07 11:18:11.000000'),
('29', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', true, '1', false, '4', '2023-11-07 11:19:11.000000'),
('3', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', false, '1', false, '3', '2023-11-07 11:13:11.000000'),
('30', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', true, '1', false, '5', '2023-11-07 11:20:11.000000'),
('31', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', true, '1', false, '1', '2023-11-07 11:11:11.000000'),
('32', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', true, '1', false, '2', '2023-11-07 11:12:11.000000'),
('33', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', true, '1', false, '3', '2023-11-07 11:13:11.000000'),
('34', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', true, '1', false, '4', '2023-11-07 11:14:11.000000'),
('35', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', true, '1', false, '5', '2023-11-07 11:15:11.000000'),
('36', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', true, '1', false, '1', '2023-11-07 11:16:11.000000'),
('37', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', true, '1', false, '2', '2023-11-07 11:17:11.000000'),
('38', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', true, '1', false, '3', '2023-11-07 11:18:11.000000'),
('39', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', true, '1', false, '4', '2023-11-07 11:19:11.000000'),
('4', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', false, '1', false, '4', '2023-11-07 11:14:11.000000'),
('40', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', true, '1', false, '5', '2023-11-07 11:20:11.000000'),
('41', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', true, '1', false, '1', '2023-11-07 11:11:11.000000'),
('42', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', true, '1', false, '2', '2023-11-07 11:12:11.000000'),
('43', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', true, '1', false, '3', '2023-11-07 11:13:11.000000'),
('44', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', true, '1', false, '4', '2023-11-07 11:14:11.000000'),
('45', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', true, '1', false, '5', '2023-11-07 11:15:11.000000'),
('46', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', true, '1', false, '1', '2023-11-07 11:16:11.000000'),
('47', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', true, '1', false, '2', '2023-11-07 11:17:11.000000'),
('48', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', true, '1', false, '3', '2023-11-07 11:18:11.000000'),
('49', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', true, '1', false, '4', '2023-11-07 11:19:11.000000'),
('5', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', false, '1', false, '5', '2023-11-07 11:15:11.000000'),
('50', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', true, '1', false, '5', '2023-11-07 11:20:11.000000'),
('51', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', true, '1', false, '1', '2023-11-07 11:11:11.000000'),
('52', '여기 다시 올 거예요!', '2023-11-07 11:12:11.000000', true, '1', false, '2', '2023-11-07 11:12:11.000000'),
('53', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11.000000', true, '1', false, '3', '2023-11-07 11:13:11.000000'),
('54', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11.000000', true, '1', false, '4', '2023-11-07 11:14:11.000000'),
('55', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11.000000', true, '1', false, '5', '2023-11-07 11:15:11.000000'),
('56', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', true, '1', false, '1', '2023-11-07 11:16:11.000000'),
('57', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', true, '1', false, '2', '2023-11-07 11:17:11.000000'),
('58', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', true, '1', false, '3', '2023-11-07 11:18:11.000000'),
('59', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', true, '1', false, '4', '2023-11-07 11:19:11.000000'),
('6', '가격 대비 훌륭해요!', '2023-11-07 11:16:11.000000', false, '1', false, '1', '2023-11-07 11:16:11.000000'),
('60', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11.000000', true, '1', false, '5', '2023-11-07 11:20:11.000000'),
('61', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11.000000', true, '1', false, '1', '2023-11-07 11:11:11.000000'),
('62', '매콤한 음식이 끝내줬어요!', '2023-11-07 12:12:11.000000', true, '1', false, '2', '2023-11-07 12:12:11.000000'),
('63', '해산물이 신선해서 계속 생각나네요.', '2023-11-07 12:13:11.000000', true, '1', false, '3', '2023-11-07 12:13:11.000000'),
('64', '이렇게 부드러운 스테이크는 처음이에요!', '2023-11-07 12:14:11.000000', true, '1', false, '4', '2023-11-07 12:14:11.000000'),
('65', '디자인이 멋진 카페였어요.', '2023-11-07 12:15:11.000000', true, '1', false, '5', '2023-11-07 12:15:11.000000'),
('66', '전통 음식의 진수를 보여주는 곳!', '2023-11-07 12:16:11.000000', true, '1', false, '1', '2023-11-07 12:16:11.000000'),
('67', '감자튀김이 너무 바삭바삭해요!', '2023-11-07 12:17:11.000000', true, '1', false, '2', '2023-11-07 12:17:11.000000'),
('68', '와인 선택이 훌륭했어요!', '2023-11-07 12:18:11.000000', true, '1', false, '3', '2023-11-07 12:18:11.000000'),
('69', '음식이 너무 늦게 나와서 아쉬웠어요.', '2023-11-07 12:19:11.000000', true, '1', false, '4', '2023-11-07 12:19:11.000000'),
('7', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11.000000', false, '1', false, '2', '2023-11-07 11:17:11.000000'),
('70', '이런 맛집을 이제야 발견하다니!', '2023-11-07 12:20:11.000000', true, '1', false, '5', '2023-11-07 12:20:11.000000'),
('8', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11.000000', false, '1', false, '3', '2023-11-07 11:18:11.000000'),
('9', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11.000000', false, '1', false, '4', '2023-11-07 11:19:11.000000'),
('a1c1ee3100000014b611c350', '저도 가보고 싶어요!!', '2024-02-13 18:17:37.714155', false, 'a1c1ed3100000014b611c349', false, '5', '2024-02-13 18:17:37.714155'),
('a1c1eece00000014b611c353', '저도 가보고 싶어요!!', '2024-02-13 18:17:37.870306', false, 'a1c1ed3100000014b611c349', true, '4', '2024-02-13 18:17:38.194472');
insert into feed_reply (id, content, created_at, member_id, deleted, updated_at)
values ('1', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('2', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('3', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('4', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('5', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('6', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('7', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('8', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('9', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('10', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('11', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('12', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('13', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('14', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('15', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('16', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('17', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('18', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('19', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('20', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('21', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('22', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('23', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('24', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('25', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('26', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('27', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('28', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('29', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('30', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('31', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('32', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('33', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('34', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('35', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('36', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('37', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('38', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('39', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('40', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('41', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('42', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('43', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('44', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('45', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('46', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('47', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('48', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('49', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('50', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('51', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('52', '여기 다시 올 거예요!', '2023-11-07 11:12:11', 2, 1, '2023-11-07 11:12:11'),
('53', '친절한 서비스가 인상적이었어요.', '2023-11-07 11:13:11', 3, 1, '2023-11-07 11:13:11'),
('54', '분위기가 아늑하고 좋았습니다.', '2023-11-07 11:14:11', 4, 1, '2023-11-07 11:14:11'),
('55', '음식이 너무 맛있어서 놀랐어요!', '2023-11-07 11:15:11', 5, 1, '2023-11-07 11:15:11'),
('56', '가격 대비 훌륭해요!', '2023-11-07 11:16:11', 1, 1, '2023-11-07 11:16:11'),
('57', '재료가 신선해서 좋았어요.', '2023-11-07 11:17:11', 2, 1, '2023-11-07 11:17:11'),
('58', '아이와 함께 방문하기 좋은 곳이에요.', '2023-11-07 11:18:11', 3, 1, '2023-11-07 11:18:11'),
('59', '다양한 메뉴가 매력적이었어요.', '2023-11-07 11:19:11', 4, 1, '2023-11-07 11:19:11'),
('60', '디저트가 정말 일품이었습니다!', '2023-11-07 11:20:11', 5, 1, '2023-11-07 11:20:11'),
('61', '정말 맛있는 음식이었어요!', '2023-11-07 11:11:11', 1, 1, '2023-11-07 11:11:11'),
('62', '매콤한 음식이 끝내줬어요!', '2023-11-07 12:12:11', 2, 1, '2023-11-07 12:12:11'),
('63', '해산물이 신선해서 계속 생각나네요.', '2023-11-07 12:13:11', 3, 1, '2023-11-07 12:13:11'),
('64', '이렇게 부드러운 스테이크는 처음이에요!', '2023-11-07 12:14:11', 4, 1, '2023-11-07 12:14:11'),
('65', '디자인이 멋진 카페였어요.', '2023-11-07 12:15:11', 5, 1, '2023-11-07 12:15:11'),
('66', '전통 음식의 진수를 보여주는 곳!', '2023-11-07 12:16:11', 1, 1, '2023-11-07 12:16:11'),
('67', '감자튀김이 너무 바삭바삭해요!', '2023-11-07 12:17:11', 2, 1, '2023-11-07 12:17:11'),
('68', '와인 선택이 훌륭했어요!', '2023-11-07 12:18:11', 3, 1, '2023-11-07 12:18:11'),
('69', '음식이 너무 늦게 나와서 아쉬웠어요.', '2023-11-07 12:19:11', 4, 1, '2023-11-07 12:19:11'),
('70', '이런 맛집을 이제야 발견하다니!', '2023-11-07 12:20:11', 5, 1, '2023-11-07 12:20:11'),
('a1c1ef3100000014b611c356', '정말 한번 가보세요!', '2024-02-13 18:17:37.970342', '5',false, '2024-02-13 18:17:37.970342'),
('a1c1f01200000014b611c359', '정말 한번 가보세요!', '2024-02-13 18:17:38.194472', '4', false, '2024-02-13 18:17:38.194472');
insert into feed_comment_comment_list (feed_comment_id, comment_list_id)
values (1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
('a1c1eece00000014b611c353', 'a1c1ef3100000014b611c356'),
('a1c1eece00000014b611c353', 'a1c1f01200000014b611c359');
insert into notification_setting (id, member_id, is_collection_comment, is_collection_like, is_comment_like,
is_feed_comment, is_feed_like, is_follow)
values (1, 1, true, true, true, true, true, true),
(2, 2, true, true, true, true, true, true),
(3, 3, true, true, true, true, true, true),
(4, 4, true, true, true, true, true, true),
(5, 5, true, true, true, true, true, true);
insert into feed_comment_like_count(id, comment_id, count)
values (1, 1, 0),
(2, 2, 0),
(3, 3, 0),
(4, 4, 0),
(5, 5, 0),
(6, 6, 0),
(7, 7, 0),
(8, 8, 0),
(9, 9, 0),
(10, 10, 0),
(11, 11, 0),
(12, 12, 0),
(13, 13, 0),
(14, 14, 0),
(15, 15, 0),
(16, 16, 0),
(17, 17, 0),
(18, 18, 0),
(19, 19, 0),
(20, 20, 0),
(21, 21, 0),
(22, 22, 0),
(23, 23, 0),
(24, 24, 0),
(25, 25, 0),
(26, 26, 0),
(27, 27, 0),
(28, 28, 0),
(29, 29, 0),
(30, 30, 0),
(31, 31, 0),
(32, 32, 0),
(33, 33, 0),
(34, 34, 0),
(35, 35, 0),
(36, 36, 0),
(37, 37, 0),
(38, 38, 0),
(39, 39, 0),
(40, 40, 0),
(41, 41, 0),
(42, 42, 0),
(43, 43, 0),
(44, 44, 0),
(45, 45, 0),
(46, 46, 0),
(47, 47, 0),
(48, 48, 0),
(49, 49, 0),
(50, 50, 0),
(51, 51, 0),
(52, 52, 0),
(53, 53, 0),
(54, 54, 0),
(55, 55, 0),
(56, 56, 0),
(57, 57, 0),
(58, 58, 0),
(59, 59, 0),
(60, 60, 0),
(61, 61, 0),
(62, 62, 0),
(63, 63, 0),
(64, 64, 0),
(65, 65, 0),
(66, 66, 0),
(67, 67, 0),
(68, 68, 0),
(69, 69, 0),
(70, 70, 0),
('a1c1ee9100000014b611c351', 'a1c1ee3100000014b611c350',0),
('a1c1eeee00000014b611c354', 'a1c1eece00000014b611c353',0);
insert into foodymoody.feed_reply_like (id, created_at, feed_comment_id, reply_id, member_id, updated_at)
values ('a1c1f0a300000014b611c35c', '2024-02-13 18:17:38.339930', 'a1c1eece00000014b611c353',
'a1c1f01200000014b611c359', '5', '2024-02-13 18:17:38.339930');
insert into foodymoody.feed_reply_like_count (id, count, reply_id)
values ('1', 0, '0'),
('10', 0, '10'),
('11', 0, '11'),
('12', 0, '12'),
('13', 0, '13'),
('14', 0, '14'),
('15', 0, '15'),
('16', 0, '16'),
('17', 0, '17'),
('18', 0, '18'),
('19', 0, '19'),
('2', 0, '2'),
('20', 0, '20'),
('21', 0, '21'),
('22', 0, '22'),
('23', 0, '23'),
('24', 0, '24'),
('25', 0, '25'),
('26', 0, '26'),
('27', 0, '27'),
('28', 0, '28'),
('29', 0, '29'),
('3', 0, '3'),
('30', 0, '30'),
('31', 0, '31'),
('32', 0, '32'),
('33', 0, '33'),
('34', 0, '34'),
('35', 0, '35'),
('36', 0, '36'),
('37', 0, '37'),
('38', 0, '38'),
('39', 0, '39'),
('4', 0, '4'),
('40', 0, '40'),
('41', 0, '41'),
('42', 0, '42'),
('43', 0, '43'),
('44', 0, '44'),
('45', 0, '45'),
('46', 0, '46'),
('47', 0, '47'),
('48', 0, '48'),
('49', 0, '49'),
('5', 0, '5'),
('50', 0, '50'),
('51', 0, '51'),
('52', 0, '52'),
('53', 0, '53'),
('54', 0, '54'),
('55', 0, '55'),
('56', 0, '56'),
('57', 0, '57'),
('58', 0, '58'),
('59', 0, '59'),
('6', 0, '6'),
('60', 0, '60'),
('61', 0, '61'),
('62', 0, '62'),
('63', 0, '63'),
('64', 0, '64'),
('65', 0, '65'),
('66', 0, '66'),
('67', 0, '67'),
('68', 0, '68'),
('69', 0, '69'),
('7', 0, '7'),
('70', 0, '70'),
('8', 0, '8'),
('9', 0, '9'),
('a1c1ef9500000014b611c357', 0, 'a1c1ef3100000014b611c356'),
('a1c1f04300000014b611c35a', 1, 'a1c1f01200000014b611c359');
INSERT INTO feed_collection_mood (id, name, created_at, updated_at)
VALUES ('1', '행복', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('2', '슬픔', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('3', '기쁨', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('4', '화남', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('5', '놀람', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('6', '공포', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('7', '혐오', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('8', '기대', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('9', '사랑', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('10', '흥미', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('11', '감동', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('12', '안도', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('13', '자부', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('14', '후회', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('15', '설렘', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('16', '긴장', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('17', '불안', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('18', '희망', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('19', '외로움', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('20', '편안', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('21', '비오는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('22', '맑은 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('23', '흐린 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('24', '눈오는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('25', '폭풍우의 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('26', '태풍이 오는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('27', '안개 낀 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('28', '무더운 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('29', '추운 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('30', '바람이 부는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('31', '가을 날씨', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('32', '봄날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('33', '겨울 날씨', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('34', '여름 날씨', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('35', '습한 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('36', '건조한 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('37', '일몰이 보이는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('38', '일출이 보이는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('39', '별이 보이는 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('40', '구름이 많은 날', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
insert into foodymoody.feed_collection_moods (id, created_at, updated_at)
values ('1', '2000-03-12 07:34:59.000000', '2012-09-28 01:10:54.000000'),
('10', '2015-11-27 07:22:02.000000', '2021-07-31 01:16:29.000000'),
('100', '2000-12-24 10:33:39.000000', '2015-10-07 21:29:13.000000'),
('11', '2002-04-08 13:18:06.000000', '2013-01-17 21:36:06.000000'),
('12', '2009-05-21 06:42:40.000000', '2023-07-25 06:00:19.000000'),
('13', '2007-08-17 20:04:31.000000', '2015-11-04 07:59:21.000000'),
('14', '2009-06-02 18:49:48.000000', '2007-04-24 08:52:47.000000'),
('15', '2011-12-29 14:05:36.000000', '2013-07-19 02:34:24.000000'),
('16', '2019-09-23 23:35:03.000000', '2023-10-13 18:59:14.000000'),
('17', '2000-10-26 11:27:09.000000', '2012-03-11 09:58:50.000000'),
('18', '2014-09-16 00:55:46.000000', '2020-04-11 21:00:04.000000'),
('19', '2001-05-04 20:16:48.000000', '2007-03-19 00:37:47.000000'),
('2', '2021-04-03 03:42:12.000000', '2013-07-29 12:51:14.000000'),
('20', '2017-09-04 12:18:56.000000', '2004-07-07 02:35:43.000000'),
('21', '2022-06-01 13:13:48.000000', '2010-07-27 18:09:14.000000'),
('22', '2013-01-30 07:33:43.000000', '2015-02-25 09:59:17.000000'),
('23', '2022-05-15 02:44:57.000000', '2004-11-19 02:04:28.000000'),
('24', '2013-05-05 11:08:10.000000', '2019-03-22 12:27:13.000000'),
('25', '2012-06-01 09:07:06.000000', '2003-03-13 06:51:46.000000'),
('26', '2011-04-05 04:40:44.000000', '2015-12-27 10:49:20.000000'),
('27', '2021-07-15 08:50:03.000000', '2010-12-25 18:32:28.000000'),
('28', '2021-02-10 09:24:19.000000', '2004-07-19 09:45:27.000000'),
('29', '2008-08-27 17:18:18.000000', '2004-04-01 06:09:04.000000'),
('3', '2009-06-08 03:13:53.000000', '2000-10-21 23:23:32.000000'),
('30', '2004-06-13 20:37:02.000000', '2016-01-19 21:25:57.000000'),
('31', '2018-07-03 06:17:38.000000', '2003-11-15 11:21:02.000000'),
('32', '2022-02-10 09:58:59.000000', '2005-10-18 12:08:25.000000'),
('33', '2020-01-05 00:26:18.000000', '2004-05-30 07:03:41.000000'),
('34', '2008-08-13 20:32:58.000000', '2015-12-16 15:55:38.000000'),
('35', '2013-10-02 03:09:31.000000', '2014-05-28 21:26:28.000000'),
('36', '2007-01-03 13:45:14.000000', '2002-03-16 21:42:23.000000'),
('37', '2020-11-14 14:52:36.000000', '2018-04-04 19:05:03.000000'),
('38', '2000-06-29 04:47:43.000000', '2020-07-11 11:08:04.000000'),
('39', '2017-11-18 23:06:00.000000', '2011-12-28 17:25:07.000000'),
('4', '2009-12-06 06:39:44.000000', '2021-03-28 06:46:47.000000'),
('40', '2013-01-17 06:24:52.000000', '2016-04-07 06:18:48.000000'),
('41', '2011-06-29 03:41:03.000000', '2016-11-21 01:44:12.000000'),
('42', '2004-11-02 02:01:37.000000', '2003-09-13 15:59:35.000000'),
('43', '2002-08-23 23:26:31.000000', '2007-03-12 04:10:36.000000'),
('44', '2022-11-14 01:46:33.000000', '2005-07-14 08:24:29.000000'),
('45', '2021-07-31 01:36:09.000000', '2009-01-19 11:44:26.000000'),
('46', '2006-01-20 04:28:42.000000', '2015-01-12 05:12:49.000000'),
('47', '2008-09-12 07:57:54.000000', '2015-08-04 17:03:16.000000'),
('48', '2011-01-09 12:08:27.000000', '2016-03-03 17:08:51.000000'),
('49', '2010-05-30 09:15:19.000000', '2006-01-11 03:33:48.000000'),
('5', '2019-02-02 10:50:15.000000', '2008-11-15 11:04:00.000000'),
('50', '2013-01-21 02:04:27.000000', '2015-01-06 19:15:43.000000'),
('51', '2007-01-10 13:46:41.000000', '2019-08-02 04:11:29.000000'),
('52', '2020-04-27 10:50:33.000000', '2023-03-02 01:08:12.000000'),
('53', '2015-06-28 06:19:59.000000', '2007-12-03 21:08:18.000000'),
('54', '2016-10-03 01:06:26.000000', '2001-08-16 20:12:51.000000'),
('55', '2005-08-21 14:45:10.000000', '2021-08-09 17:10:15.000000'),
('56', '2022-07-10 08:53:42.000000', '2015-08-04 04:50:47.000000'),
('57', '2007-05-24 10:11:22.000000', '2012-01-09 02:14:52.000000'),
('58', '2016-05-02 02:38:31.000000', '2014-10-17 13:10:10.000000'),
('59', '2018-06-16 18:30:04.000000', '2014-06-12 14:49:24.000000'),
('6', '2014-08-28 16:06:14.000000', '2000-03-13 02:27:49.000000'),
('60', '2015-01-19 07:02:33.000000', '2022-04-05 01:01:54.000000'),
('61', '2014-11-28 15:03:01.000000', '2023-08-30 19:26:47.000000'),
('62', '2001-08-15 16:58:26.000000', '2015-08-25 13:25:54.000000'),
('63', '2017-01-29 02:21:18.000000', '2001-11-09 01:03:54.000000'),
('64', '2017-09-15 09:13:14.000000', '2000-12-25 19:00:05.000000'),
('65', '2006-02-23 11:13:49.000000', '2023-03-14 14:49:10.000000'),
('66', '2020-06-09 00:43:17.000000', '2023-02-06 20:45:31.000000'),
('67', '2020-09-19 07:51:59.000000', '2005-02-12 01:42:03.000000'),
('68', '2018-02-12 06:21:43.000000', '2000-07-10 21:33:54.000000'),
('69', '2001-07-07 04:49:55.000000', '2010-04-18 04:53:27.000000'),
('7', '2004-10-22 13:33:27.000000', '2001-12-13 14:32:23.000000'),
('70', '2022-01-09 06:44:57.000000', '2001-08-23 15:05:52.000000'),
('71', '2009-01-18 09:13:01.000000', '2002-06-29 13:01:17.000000'),
('72', '2014-12-27 22:19:00.000000', '2002-03-26 15:11:33.000000'),
('73', '2021-03-27 15:51:27.000000', '2006-10-02 06:47:13.000000'),
('74', '2009-02-04 20:58:00.000000', '2003-05-13 19:26:59.000000'),
('75', '2016-02-10 11:18:22.000000', '2007-07-26 20:18:10.000000'),
('76', '2001-11-30 16:42:11.000000', '2000-03-03 13:58:21.000000'),
('77', '2021-02-27 15:26:06.000000', '2020-05-30 18:22:40.000000'),
('78', '2012-12-03 04:52:04.000000', '2012-09-24 14:50:11.000000'),
('79', '2012-08-15 14:17:30.000000', '2012-10-06 03:53:21.000000'),
('8', '2009-11-09 04:03:08.000000', '2002-05-25 16:36:24.000000'),
('80', '2012-08-14 04:24:33.000000', '2007-03-04 16:26:48.000000'),
('81', '2020-11-02 15:43:57.000000', '2017-05-08 14:38:06.000000'),
('82', '2004-06-17 03:08:27.000000', '2010-04-30 21:03:55.000000'),
('83', '2015-06-25 17:13:33.000000', '2000-10-07 08:43:44.000000'),
('84', '2018-12-13 13:20:58.000000', '2012-06-09 20:24:06.000000'),
('85', '2014-07-24 09:00:55.000000', '2010-06-07 19:16:25.000000'),
('86', '2009-03-15 17:23:37.000000', '2003-09-22 14:42:08.000000'),
('87', '2004-08-21 10:49:16.000000', '2022-06-02 17:53:04.000000'),
('88', '2017-05-15 14:37:19.000000', '2008-10-23 17:52:47.000000'),
('89', '2012-02-23 13:37:14.000000', '2015-10-22 13:37:31.000000'),
('9', '2007-05-05 05:51:14.000000', '2023-10-20 15:34:43.000000'),
('90', '2000-01-01 19:22:29.000000', '2014-10-13 18:11:27.000000'),
('91', '2009-12-23 07:43:01.000000', '2005-12-16 07:55:08.000000'),
('92', '2005-01-13 03:51:45.000000', '2020-03-22 17:41:56.000000'),
('93', '2022-10-29 06:56:45.000000', '2007-03-15 08:45:34.000000'),
('94', '2021-04-25 05:32:43.000000', '2004-01-26 17:10:39.000000'),
('95', '2007-08-28 19:38:49.000000', '2000-03-06 13:59:33.000000'),
('96', '2002-11-12 13:56:08.000000', '2023-05-11 02:53:30.000000'),
('97', '2003-11-26 01:07:56.000000', '2003-04-24 22:18:58.000000'),
('98', '2013-04-27 14:54:23.000000', '2003-08-16 03:14:20.000000'),
('99', '2020-11-07 05:10:11.000000', '2022-08-06 14:45:44.000000'),
('a1c1ec8300000014b611c344', '2024-02-13 18:17:37.283130', '2024-02-13 18:17:37.283130'),
('a1c1f0e100000014b611c35f', '2024-02-13 18:17:38.401434', '2024-02-13 18:17:38.401434');
insert into foodymoody.feed_collection_mood_list (feed_collection_moods_id, feed_collection_mood_id)
values ('1', '1'),
('2', '2'),
('3', '3'),
('4', '4'),
('5', '5'),
('6', '6'),
('7', '7'),
('8', '8'),
('9', '9'),
('10', '10'),
('11', '11'),
('12', '12'),
('13', '13'),
('14', '14'),
('15', '15'),
('16', '16'),
('17', '17'),
('18', '18'),
('19', '19'),
('20', '20'),
('21', '21'),
('22', '22'),
('23', '23'),
('24', '24'),
('25', '25'),
('26', '26'),
('27', '27'),
('28', '28'),
('29', '29'),
('30', '30'),
('31', '31'),
('32', '32'),
('33', '33'),
('34', '34'),
('35', '35'),
('36', '36'),
('37', '37'),
('38', '38'),
('39', '39'),
('40', '40'),
('41', '1'),
('42', '2'),
('43', '3'),
('44', '4'),
('45', '5'),
('46', '6'),
('47', '7'),
('48', '8'),
('49', '9'),
('50', '10'),
('51', '11'),
('52', '12'),
('53', '13'),
('54', '14'),
('55', '15'),
('56', '16'),
('57', '17'),
('58', '18'),
('59', '19'),
('60', '20'),
('61', '21'),
('62', '22'),
('63', '23'),
('64', '24'),
('65', '25'),
('66', '26'),
('67', '27'),
('68', '28'),
('69', '29'),
('70', '30'),
('71', '31'),
('72', '32'),
('73', '33'),
('74', '34'),
('75', '35'),
('76', '36'),
('77', '37'),
('78', '38'),
('79', '39'),
('80', '40'),
('81', '1'),
('82', '2'),
('83', '3'),
('84', '4'),
('85', '5'),
('86', '6'),
('87', '7'),
('88', '8'),
('89', '9'),
('90', '10'),
('91', '11'),
('92', '12'),
('93', '13'),
('94', '14'),
('95', '15'),
('96', '16'),
('97', '17'),
('98', '18'),
('99', '19'),
('100', '20'),
('a1c1ec8300000014b611c344', '1'),
('a1c1ec8300000014b611c344', '19'),
('a1c1ec8300000014b611c344', '2');
insert into foodymoody.feed_collection_comment (id, content, created_at, deleted, feed_id, member_id, updated_at)
values ('1', '정말 좋아요!', '2022-11-21 13:03:58.000000', false, '1', '1', '2022-11-21 13:03:58.000000'),
('10', '주차공간이 넓어요!', '2022-11-21 13:03:58.000000', false, '1', '3', '2022-11-21 13:03:58.000000'),
('11', '메뉴가 다양해요!', '2022-11-21 13:03:58.000000', false, '1', '4', '2022-11-21 13:03:58.000000'),
('12', '음식이 신선해요!', '2022-11-21 13:03:58.000000', false, '1', '5', '2022-11-21 13:03:58.000000'),
('13', '직원들이 친절해요!', '2022-11-21 13:03:58.000000', false, '1', '2', '2022-11-21 13:03:58.000000'),
('14', '가성비가 좋아요!', '2022-11-21 13:03:58.000000', false, '1', '3', '2022-11-21 13:03:58.000000'),
('15', '포장도 가능해요!', '2022-11-21 13:03:58.000000', false, '1', '4', '2022-11-21 13:03:58.000000'),
('16', '다음에 또 방문할게요!', '2022-11-21 13:03:58.000000', false, '1', '6', '2022-11-21 13:03:58.000000'),
('17', '여기 다시 올 거예요!', '2022-11-21 13:03:58.000000', false, '1', '2', '2022-11-21 13:03:58.000000'),
('18', '분위기가 좋았어요!', '2022-11-21 13:03:58.000000', false, '1', '3', '2022-11-21 13:03:58.000000'),
('19', '서비스가 좋았어요!', '2022-11-21 13:03:58.000000', false, '1', '4', '2022-11-21 13:03:58.000000'),
('2', '다음에 또 방문할게요!', '2022-11-21 13:03:58.000000', false, '1', '2', '2022-11-21 13:03:58.000000'),
('20', '가격이 저렴해요!', '2022-11-21 13:03:58.000000', false, '1', '5', '2022-11-21 13:03:58.000000'),
('3', '분위기가 좋았어요!', '2022-11-21 13:03:58.000000', false, '1', '3', '2022-11-21 13:03:58.000000'),
('4', '서비스가 좋았어요!', '2022-11-21 13:03:58.000000', false, '1', '4', '2022-11-21 13:03:58.000000'),
('5', '가격이 저렴해요!', '2022-11-21 13:03:58.000000', false, '1', '5', '2022-11-21 13:03:58.000000'),
('6', '음식이 맛있어요!', '2022-11-21 13:03:58.000000', false, '1', '2', '2022-11-21 13:03:58.000000'),
('7', '다음에 또 올게요!', '2022-11-21 13:03:58.000000', false, '1', '3', '2022-11-21 13:03:58.000000'),
('8', '친구들에게 추천할게요!', '2022-11-21 13:03:58.000000', false, '1', '5', '2022-11-21 13:03:58.000000'),
('9', '재방문 의사 있어요!', '2022-11-21 13:03:58.000000', false, '1', '2', '2022-11-21 13:03:58.000000'),
('a1c1f1e200000014b611c364', '댓글 내용', '2024-02-13 18:17:38.659002', false, 'a1c1f0e100000014b611c35e', '5', '2024-02-13 18:17:38.659002'),
('a1c1f23000000014b611c366', '댓글 내용', '2024-02-13 18:17:38.737037', false, 'a1c1f0e100000014b611c35e', '4', '2024-02-13 18:17:38.737037');
insert into foodymoody.feed_collection_reply (id, comment_id, value, created_at, deleted, member_id, updated_at)
values ('1', '1', '맞아요!!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('10', '1', '음식이 맛있어요!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('11', '1', '다음에 또 올게요!', '2021-04-06 13:03:58.000000', false, '3', '2022-11-21 03:50:47.000000'),
('12', '1', '친구들에게 추천할게요!', '2021-04-06 13:03:58.000000', false, '4', '2022-11-21 03:50:47.000000'),
('13', '1', '재방문 의사 있어요!', '2021-04-06 13:03:58.000000', false, '5', '2022-11-21 03:50:47.000000'),
('14', '1', '주차공간이 넓어요!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('15', '1', '메뉴가 다양해요!', '2021-04-06 13:03:58.000000', false, '3', '2022-11-21 03:50:47.000000'),
('16', '1', '음식이 신선해요!', '2021-04-06 13:03:58.000000', false, '4', '2022-11-21 03:50:47.000000'),
('17', '1', '직원들이 친절해요!', '2021-04-06 13:03:58.000000', false, '5', '2022-11-21 03:50:47.000000'),
('18', '1', '가성비가 좋아요!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('19', '1', '포장도 가능해요!', '2021-04-06 13:03:58.000000', false, '3', '2022-11-21 03:50:47.000000'),
('2', '1', '저도 추천이요!!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('20', '1', '다음에 또 방문할게요!', '2021-04-06 13:03:58.000000', false, '4', '2022-11-21 03:50:47.000000'),
('3', '1', '정말 맛있어요!', '2021-04-06 13:03:58.000000', false, '3', '2022-11-21 03:50:47.000000'),
('4', '1', '여기 다시 올 거예요!', '2021-04-06 13:03:58.000000', false, '4', '2022-11-21 03:50:47.000000'),
('5', '1', '분위기가 아늑하고 좋았습니다.', '2021-04-06 13:03:58.000000', false, '5', '2022-11-21 03:50:47.000000'),
('6', '1', '서비스가 좋았어요!', '2021-04-06 13:03:58.000000', false, '2', '2022-11-21 03:50:47.000000'),
('7', '1', '가격이 저렴해요!', '2021-04-06 13:03:58.000000', false, '3', '2022-11-21 03:50:47.000000'),
('8', '1', '위치가 좋아요!', '2021-04-06 13:03:58.000000', false, '4', '2022-11-21 03:50:47.000000'),
('9', '1', '인테리어가 멋져요!', '2021-04-06 13:03:58.000000', false, '5', '2022-11-21 03:50:47.000000'),
('a1c1f2f100000014b611c36c', 'a1c1f23000000014b611c366', '대댓글입니다.', '2024-02-13 18:17:38.929168', false, '4', '2024-02-13 18:17:38.929168'),
('a1c1f33400000014b611c36e', 'a1c1f23000000014b611c366', '대댓글입니다.', '2024-02-13 18:17:38.996091', false, '4', '2024-02-13 18:17:38.996091');
insert into foodymoody.feed_collection_reply_ids (comment_id, reply_id, reply_order)
values ('1', '1', 1),
('1', '2', 2),
('1', '3', 3),
('1', '4', 4),
('1', '5', 5),
('1', '6', 6),
('1', '7', 7),
('1', '8', 8),
('1', '9', 9),
('1', '10', 10),
('1', '11', 11),
('1', '12', 12),
('1', '13', 13),
('1', '14', 14),
('1', '15', 15),
('1', '16', 16),
('1', '17', 17),
('1', '18', 18),
('1', '19', 19),
('1', '20', 20),
('a1c1f23000000014b611c366','a1c1f2f100000014b611c36c', 0),
('a1c1f23000000014b611c366','a1c1f33400000014b611c36e', 1);
insert into foodymoody.feed_collection (id, author_id, created_at, description, follower_count, like_count, is_deleted, is_private, thumbnail_url, title, updated_at, moods_id)
values ('1', '1', '2021-04-06 13:03:58.000000', '내돈 내산 맛집 추천!!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '나의 BEST', '2022-11-21 03:50:47.000000', '1'),
('2', '2', '2019-07-10 15:36:15.000000', '내돈 내산 맛집 추천!!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/11/21/18/28/garlic-ribs-4643142_1280.jpg', '나의 BEST', '2020-06-06 13:21:27.000000', '2'),
('3', '3', '2017-08-25 19:22:23.000000', '내돈 내산 맛집 추천!!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2017/06/12/15/01/skewers-2395810_1280.jpg', '나의 BEST', '2018-05-22 11:24:03.000000', '3'),
('4', '4', '2010-02-13 21:10:28.000000', '내돈 내산 맛집 추천!!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2021/01/22/06/05/kimchi-5939198_1280.jpg', '나의 BEST', '2012-12-25 05:31:36.000000', '4'),
('5', '5', '2022-12-13 13:51:32.000000', '내돈 내산 맛집 추천!!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2015/06/26/02/52/korean-food-822082_1280.jpg', '나의 BEST', '2013-09-27 00:36:51.000000', '5'),
('6', '1', '2021-04-06 13:03:58.000000', '서울의 최고 맛집!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '서울 맛집', '2022-11-21 03:50:47.000000', '1'),
('7', '1', '2021-04-06 13:03:58.000000', '부산의 히든 맛집!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '부산 맛집', '2022-11-21 03:50:47.000000', '2'),
('8', '1', '2021-04-06 13:03:58.000000', '대구의 맛집 탐방!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '대구 맛집', '2022-11-21 03:50:47.000000', '3'),
('9', '1', '2021-04-06 13:03:58.000000', '인천의 맛집 리스트!', 0, 0, true, false, 'https://cdn.pixabay.com/photo/2019/03/29/05/03/dog-4088555_1280.jpg', '인천 맛집', '2022-11-21 03:50:47.000000', '4'),
('a1c1ec8200000014b611c343', '5', '2024-02-13 18:17:37.283130', '비빔밥이 맛있는 집이에요. 꼭 가보세요!', 0, 0, false, false, null, '이 집 비빔밥 맛있어요!! 꼭 가야 함!!', '2024-02-13 18:17:37.283130', 'a1c1ec8300000014b611c344'),
('a1c1f0e100000014b611c35e', '4', '2024-02-13 18:17:38.401434', '비빔밥이 맛있는 집이에요. 꼭 가보세요!', 0, 0, false, false, null, '이 집 비빔밥 맛있어요!! 꼭 가야 함!!', '2024-02-13 18:17:38.401434', 'a1c1f0e100000014b611c35f');
insert into foodymoody.feed_collection_like_count (id, count, created_at, feed_collection_id, updated_at)
values ('1', 0, '2005-01-22 18:58:10.000000', '1', '2014-10-10 12:00:11.000000'),
('2', 0, '2000-10-18 03:04:32.000000', '2', '2011-10-13 10:41:57.000000'),
('3', 0, '2009-09-10 05:12:37.000000', '3', '2002-10-26 06:15:00.000000'),
('4', 0, '2010-12-15 10:10:28.000000', '4', '2017-04-22 22:48:32.000000'),
('5', 0, '2023-09-14 10:58:50.000000', '5', '2001-06-28 02:06:29.000000'),
('a1c1ecbc00000014b611c345', 0, '2024-02-13 18:17:37.340535', 'a1c1ec8200000014b611c343', '2024-02-13 18:17:37.340535'),
('a1c1f0f400000014b611c360', 1, '2024-02-13 18:17:38.420116', 'a1c1f0e100000014b611c35e', '2024-02-13 18:17:38.420116');
INSERT INTO store_status(code, type)
VALUES (1, 'OPEN'),
(2, 'TEMPORARILY_CLOSED'),
(3, 'CLOSED'),
(4, 'ETC');
insert into foodymoody.store (id, address, mgt_no, opn_sf_team_code, opn_svc_id, name, phone, road_address, updated_at,
x, y, status)
values ('1', '서울특별시 은평구 녹번동 162-39번지 1층', '3110000-101-1996-01174', '3110000', '07_24_04_P', '중국관', '02 3563831',
'서울특별시 은평구 진흥로 70, 1층 (녹번동)', null, 193008.663820573, 455647.024463152, 1),
('2', '서울특별시 관악구 남현동 1058-6', '3200000-101-2023-00249', '3200000', '07_24_04_P', '본죽&비빔밥사당남현점', '',
'서울특별시 관악구 남현길 7, 1층 103호 (남현동)', null, 197958.524057933, 441542.490987188, 1),
('3', '서울특별시 용산구 이태원동 119-29', '3020000-101-2023-00500', '3020000', '07_24_04_P', '볼빨간삼춘빠', '',
'서울특별시 용산구 이태원로 165-6, 지하1층 (이태원동)', null, 199269.056052683, 448055.156196532, 1),
('4', '서울특별시 강동구 명일동 48-2', '3240000-101-1995-07328', '3240000', '07_24_04_P', '큰마루', '02 4290535',
'서울특별시 강동구 동남로73길 23 (명일동)', null, 213620.683279907, 450050.909479909, 1),
('5', '서울특별시 동작구 노량진동 117-16번지', '3190000-101-2007-00156', '3190000', '07_24_04_P', '노량진 생고기', '000208176111',
'서울특별시 동작구 만양로 108 (노량진동)', null, 195020.065726607, 445651.858121299, 1),
('6', '서울특별시 중구 을지로6가 58-5 20층', '3010000-101-2018-00212', '3010000', '07_24_04_P', '고메바', '0234258000',
'서울특별시 중구 을지로 238, 20층 (을지로6가)', null, 200314.646974736, 451554.066925226, 1),
('7', '서울특별시 강서구 방화동 180-19번지 (지상 1층)', '3150000-101-2006-00159', '3150000', '07_24_04_P', '돈자루', '0226645455',
'서울특별시 강서구 양천로26길 10-2, 1층 (방화동, 1동)', null, 183807.937902145, 452316.134904751, 1),
('8', '서울특별시 용산구 이태원동 62-0 (지상1층)', '3020000-101-1995-05787', '3020000', '07_24_04_P', '월산동아지트', '',
'서울특별시 용산구 보광로59길 57 (이태원동,(지상1층))', null, 199125.063117303, 447942.37841349, 1),
('9', '서울특별시 성북구 장위동 64-8번지 1층', '3070000-101-2011-00128', '3070000', '07_24_04_P', '직화짬뽕 전문점', '',
'서울특별시 성북구 돌곶이로 105 (장위동,1층)', null, 204812.657781087, 456654.871159366, 1),
('10', '서울특별시 마포구 망원동 377-1 마포로얄프라자', '3130000-101-2021-00651', '3130000', '07_24_04_P', '무세이키친', '',
'서울특별시 마포구 월드컵로 87, 마포로얄프라자 1층 107, 108호 (망원동)', null, 191904.25617187, 450473.93544408, 1),
('11', '서울특별시 은평구 갈현동 503-1', '3110000-101-2022-00222', '3110000', '07_24_04_P', '푸드딜리버리 은평점', '',
'서울특별시 은평구 갈현로29길 5, 1층 (갈현동)', null, 192402.698792116, 457436.114768359, 1),
('12', '서울특별시 광진구 광장동 185-6', '3040000-101-2003-00374', '3040000', '07_24_04_P', '이백', '02 4548880',
'서울특별시 광진구 아차산로78길 175 (광장동)', null, 209512.089430461, 449491.155494168, 1),
('13', '서울특별시 강남구 논현동 248-7 지하2층', '3220000-101-2005-01187', '3220000', '07_24_04_P', '아이피호텔휘트니스', '0234408233',
'서울특별시 강남구 언주로 640 (논현동,지하2층)', null, 203102.074986325, 445751.652027981, 1),
('14', '서울특별시 중구 회현동1가 92-16 (지상1,2층)', '3010000-101-2006-00132', '3010000', '07_24_04_P', '야레향', '02 7523991',
'서울특별시 중구 퇴계로10길 14 (회현동1가,(지상1,2층))', null, 198178.465503048, 450713.513681395, 1),
('15', '서울특별시 성북구 종암동 131-2 종암2차아이파크 상가동 104호', '3070000-101-2013-00104', '3070000', '07_24_04_P', '탐스비어', '',
'서울특별시 성북구 종암로9길 86, 상가동 1층 104호 (종암동, 종암2차아이파크)', null, 202854.230690052, 455038.993896321, 1),
('16', '서울특별시 마포구 도화동 251-1', '3130000-101-2023-00944', '3130000', '07_24_04_P', '크림라벨', '',
'서울특별시 마포구 삼개로 20, 별관 1층 102호 (도화동)', null, 195254.758704781, 448476.859046692, 1),
('17', '서울특별시 강남구 신사동 648-24번지', '3220000-101-2019-01418', '3220000', '07_24_04_P', '클랩피자 청담점', '',
'서울특별시 강남구 압구정로46길 71, 지상1층 (신사동)', null, 203164.773811596, 446874.689704741, 1),
('18', '서울특별시 양천구 목동 607-43', '3140000-101-2023-00151', '3140000', '07_24_04_P', 'SOOT숯', '',
'서울특별시 양천구 목동중앙북로7가길 58, 2층 (목동)', null, 187966.115402403, 449743.050416144, 1),
('19', '서울특별시 성동구 송정동 73-225', '3030000-101-2023-00410', '3030000', '07_24_04_P', '1유로펍', '',
'서울특별시 성동구 송정18길 1-1, 1층 101호 (송정동)', null, 205940.779396411, 450100.588859321, 1),
('20', '서울특별시 도봉구 방학동 669 1층', '3090000-101-2017-00135', '3090000', '07_24_04_P', '윤짬뽕', '02 61050211',
'서울특별시 도봉구 방학로 183, 1동 1층 (방학동)', null, 202764.917530564, 462169.731321838, 1);
insert into store_like_count (store_id, count, version)
values (1, 0, 1),
(2, 0, 1),
(3, 0, 1),
(4, 0, 1),
(5, 0, 1),
(6, 0, 1),
(7, 0, 1),
(8, 0, 1),
(9, 0, 1),
(10, 0, 1),
(11, 0, 1),
(12, 0, 1),
(13, 0, 1),
(14, 0, 1),
(15, 0, 1),
(16, 0, 1),
(17, 0, 1),
(18, 0, 1),
(19, 0, 1),
(20, 0, 1);
insert into foodymoody.notification (id, created_at, details, from_member_id, is_deleted, is_read, to_member_id, type,
updated_at)
values ('a1c1ea2600000014b611c33a', '2024-02-13 18:17:36.461253', '{
"@type": "MemberFollowedNotificationDetails",
"followed": false
}', '4', false, false, '5', 'MEMBER_FOLLOWED_EVENT', '2024-02-13 18:17:36.461253'),
('a1c1ea2600000014b611c33b', '2024-02-13 18:17:36.636024', '{
"@type": "MemberFollowedNotificationDetails",
"followed": true
}', '5', false, false, '4', 'MEMBER_FOLLOWED_EVENT', '2024-02-13 18:17:36.636024'),
('a1c1ec5400000014b611c342', null, '{
"@type": "FeedNotificationDetails",
"feedId": "a1c1eb5e00000014b611c33e",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2016/10/13/19/15/bibimbap-1738580_1280.jpg"
}', '5', false, false, '4', 'FEED_ADDED_EVENT', null),
('a1c1ecdd00000014b611c346', '2024-02-13 18:17:37.283130', '{
"@type": "FeedCollectionNotificationDetails",
"feedCollectionId": "a1c1ec8200000014b611c343",
"feedCollectionTitle": "이 집 비빔밥 맛있어요!! 꼭 가야 함!!",
"feedCollectionThumbnailUrl": null
}', '5', false, false, '4', 'FEED_COLLECTION_ADDED_EVENT', '2024-02-13 18:17:37.283130'),
('a1c1ed8c00000014b611c34d', null, '{
"@type": "FeedNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg"
}', '4', false, false, '5', 'FEED_ADDED_EVENT', null),
('a1c1ee0d00000014b611c34f', '2024-02-13 18:17:37.600209', '{
"@type": "FeedLikeNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg"
}', '5', false, false, '4', 'FEED_LIKED_ADDED_EVENT', '2024-02-13 18:17:37.600209'),
('a1c1eec200000014b611c352', '2024-02-13 18:17:37.714155', '{
"@type": "FeedCommentNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedCommentId": "a1c1ee3100000014b611c350",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg",
"feedCommentContent": "저도 가보고 싶어요!!"
}', '5', false, false, '4', 'FEED_COMMENT_ADDED_EVENT', '2024-02-13 18:17:37.714155'),
('a1c1ef0800000014b611c355', '2024-02-13 18:17:37.870306', '{
"@type": "FeedCommentNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedCommentId": "a1c1eece00000014b611c353",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg",
"feedCommentContent": "저도 가보고 싶어요!!"
}', '4', false, false, '4', 'FEED_COMMENT_ADDED_EVENT', '2024-02-13 18:17:37.870306'),
('a1c1efa200000014b611c358', '2024-02-13 18:17:37.970342', '{
"@type": "FeedCommentReplyNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedReplyId": "a1c1ef3100000014b611c356",
"feedCommentId": "a1c1eece00000014b611c353",
"feedReplyContent": "정말 한번 가보세요!",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg"
}', '5', false, false, '4', 'FEED_COMMENT_REPLY_ADDED_EVENT', '2024-02-13 18:17:37.970342'),
('a1c1f05300000014b611c35b', '2024-02-13 18:17:38.194472', '{
"@type": "FeedCommentReplyNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedReplyId": "a1c1f01200000014b611c359",
"feedCommentId": "a1c1eece00000014b611c353",
"feedReplyContent": "정말 한번 가보세요!",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg"
}', '4', false, false, '4', 'FEED_COMMENT_REPLY_ADDED_EVENT', '2024-02-13 18:17:38.194472'),
('a1c1f0d600000014b611c35d', '2024-02-13 18:17:38.339930', '{
"@type": "FeedCommentReplyLikeNotificationDetails",
"feedId": "a1c1ed3100000014b611c349",
"feedReplyId": "a1c1f01200000014b611c359",
"feedCommentId": "a1c1eece00000014b611c353",
"feedReplyContent": "정말 한번 가보세요!",
"feedThumbnailUrl": "https://cdn.pixabay.com/photo/2017/07/19/03/13/pot-2517765_1280.jpg"
}', '5', false, false, '4', 'FEED_COMMENT_REPLY_LIKED_ADDED_EVENT', '2024-02-13 18:17:38.339930'),
('a1c1f11500000014b611c361', '2024-02-13 18:17:38.401434', '{
"@type": "FeedCollectionNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionTitle": "이 집 비빔밥 맛있어요!! 꼭 가야 함!!",
"feedCollectionThumbnailUrl": null
}', '4', false, false, '5', 'FEED_COLLECTION_ADDED_EVENT', '2024-02-13 18:17:38.401434'),
('a1c1f1b500000014b611c363', '2024-02-13 18:17:38.525256', '{
"@type": "FeedCollectionLikeNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionThumbnailUrl": null
}', '5', false, false, '4', 'FEED_COLLECTION_LIKED_ADDED_EVENT', '2024-02-13 18:17:38.525256'),
('a1c1f24e00000014b611c367', '2024-02-13 18:17:38.659002', '{
"@type": "FeedCollectionCommentNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionCommentId": "a1c1f1e200000014b611c364",
"feedCollectionThumbnailUrl": null,
"feedCollectionCommentContent": "댓글 내용"
}', '5', false, false, '4', 'FEED_COLLECTION_COMMENT_ADDED_EVENT', '2024-02-13 18:17:38.659002'),
('a1c1f27f00000014b611c369', '2024-02-13 18:17:38.737037', '{
"@type": "FeedCollectionCommentNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionCommentId": "a1c1f23000000014b611c366",
"feedCollectionThumbnailUrl": null,
"feedCollectionCommentContent": "댓글 내용"
}', '4', false, false, '4', 'FEED_COLLECTION_COMMENT_ADDED_EVENT', '2024-02-13 18:17:38.737037'),
('a1c1f2e700000014b611c36b', '2024-02-13 18:17:38.865573', '{
"@type": "FeedCollectionCommentLikeNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionCommentId": "a1c1f23000000014b611c366",
"feedCollectionThumbnailUrl": null,
"feedCollectionCommentContent": "댓글 내용"
}', '5', false, false, '4', 'FEED_COLLECTION_COMMENT_LIKED_ADDED_EVENT', '2024-02-13 18:17:38.865573'),
('a1c1f33800000014b611c36f', '2024-02-13 18:17:38.929168', '{
"@type": "FeedCollectionReplyNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionReplyId": "a1c1f2f100000014b611c36c",
"feedCollectionCommentId": "a1c1f23000000014b611c366",
"feedCollectionReplyContent": "대댓글입니다.",
"feedCollectionThumbnailUrl": null
}', '4', false, false, '4', 'FEED_COLLECTION_COMMENT_REPLY_ADDED_EVENT', '2024-02-13 18:17:38.929168'),
('a1c1f36000000014b611c371', '2024-02-13 18:17:38.996091', '{
"@type": "FeedCollectionReplyNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionReplyId": "a1c1f33400000014b611c36e",
"feedCollectionCommentId": "a1c1f23000000014b611c366",
"feedCollectionReplyContent": "대댓글입니다.",
"feedCollectionThumbnailUrl": null
}', '4', false, false, '4', 'FEED_COLLECTION_COMMENT_REPLY_ADDED_EVENT', '2024-02-13 18:17:38.996091'),
('a1c1f39c00000014b611c373', '2024-02-13 18:17:39.065178', '{
"@type": "FeedCollectionReplyLikeNotificationDetails",
"feedCollectionId": "a1c1f0e100000014b611c35e",
"feedCollectionReplyId": "a1c1f33400000014b611c36e",
"feedCollectionCommentId": "a1c1f23000000014b611c366",
"feedCollectionReplyContent": "대댓글입니다.",
"feedCollectionThumbnailUrl": null
}', '5', false, false, '4', 'FEED_COLLECTION_COMMENT_REPLY_LIKED_ADDED_EVENT', '2024-02-13 18:17:39.065178');
insert into foodymoody.follow (id, created_at, followed_id, follower_id)
values (1, null, '4', '5'),
(2, null, '5', '4');
insert into foodymoody.feed_like_count (id, count, feed_id, version)
values ('a1c1eb9900000014b611c341', 0, 'a1c1eb5e00000014b611c33e', 0),
('a1c1ed3b00000014b611c34c', 1, 'a1c1ed3100000014b611c349', 0);
insert into foodymoody.feed_like (id, feed_id, is_liked, member_id)
values ('a1c1edbf00000014b611c34e', 'a1c1ed3100000014b611c349', true, '5');
insert into foodymoody.feed_collection_reply_like_count (id, count, created_at, feed_collection_reply_id, updated_at)
values ('a1c1f32500000014b611c36d', 0, '2024-02-13 18:17:38.929168', 'a1c1f2f100000014b611c36c', '2024-02-13 18:17:38.929168'),
('a1c1f34300000014b611c370', 1, '2024-02-13 18:17:38.996091', 'a1c1f33400000014b611c36e', '2024-02-13 18:17:38.996091');
insert into foodymoody.feed_collection_reply_like (id, created_at, feed_collection_comment_id, feed_collection_id, member_id)
values ('a1c1f37800000014b611c372', '2024-02-13 18:17:39.065178', 'a1c1f23000000014b611c366', 'a1c1f33400000014b611c36e', '5');
insert into foodymoody.feed_collection_like (id, created_at, feed_collection_id, member_id)
values ('a1c1f15d00000014b611c362', '2024-02-13 18:17:38.525256', 'a1c1f0e100000014b611c35e', '5');
insert into foodymoody.feed_collection_feed_ids (feed_collection_id, feed_id, feed_order)
values ('1','1',1),
('1','2',2),
('1','3',3),
('1','4',4),
('1','5',5),
('2','6',1),
('2','7',2),
('2','8',3),
('2','9',4),
('2','10',5),
('3','11',1),
('3','12',2),
('3','13',3),
('3','14',4),
('3','15',5),
('4','16',1),
('4','17',2),
('4','18',3),
('4','19',4),
('4','20',5);
insert into foodymoody.feed_collection_comment_like_count (id, count, feed_collection_comment_id)
values ('a1c1f21600000014b611c365', 0, 'a1c1f1e200000014b611c364'),
('a1c1f26300000014b611c368', 1, 'a1c1f23000000014b611c366');
insert into foodymoody.feed_collection_comment_like (id, comment_id, created_at, member_id, updated_at)
values ('a1c1f2b100000014b611c36a', 'a1c1f23000000014b611c366', '2024-02-13 18:17:38.865573', '5', '2024-02-13 18:17:38.865573');
insert into foodymoody.feed_collection_comment_ids (feed_collection_id, comment_id, comment_order)
values ('a1c1f0e100000014b611c35e', 'a1c1f1e200000014b611c364', 0),
('a1c1f0e100000014b611c35e', 'a1c1f23000000014b611c366', 1),
('a1c1f0e100000014b611c35e', '1', 2),
('a1c1f0e100000014b611c35e', '2', 3),
('a1c1f0e100000014b611c35e', '3', 4),
('a1c1f0e100000014b611c35e', '4', 5),
('a1c1f0e100000014b611c35e', '5', 6),
('a1c1f0e100000014b611c35e', '6', 7),
('a1c1f0e100000014b611c35e', '7', 8),
('a1c1f0e100000014b611c35e', '8', 9),
('a1c1f0e100000014b611c35e', '9', 10),
('a1c1f0e100000014b611c35e', '10', 11),
('a1c1f0e100000014b611c35e', '11', 12),
('a1c1f0e100000014b611c35e', '12', 13),
('a1c1f0e100000014b611c35e', '13', 14),
('a1c1f0e100000014b611c35e', '14', 15),
('a1c1f0e100000014b611c35e', '15', 16),
('a1c1f0e100000014b611c35e', '16', 17),
('a1c1f0e100000014b611c35e', '17', 18),
('a1c1f0e100000014b611c35e', '18', 19),
('a1c1f0e100000014b611c35e', '19', 20),
('a1c1f0e100000014b611c35e', '20', 21);
문제 해결 과정
일단 create 옵션으로 테이블을 생성한 후, 서버측에 필요한 데이터는 어떤 것들이 있었는지 다시 되짚어봤다.
- 가게의 mood인
store_mood - 각자 좋아하는 mood인
taste_mood - 가게 데이터를 저장하는 (임시)
store- 이 데이터는 naver map api와 연동하여 개선할 예정
- OAuth 제공자를 저장하는
oauth_provider- 현재는 GOOGLE만 존재한다.
아무리 되짚어 봐도 이것들 외에는 단순한 더미 데이터밖에 없었다. 그렇기에 옵션을 update로 바꾸고, 운영 서버에 업데이트를 진행했다.
역시나 한 번에 되는 일이 없다더니, 바로 개발자들이 제일 싫어한다는 NullPointException이 터져버렸다. 회원가입과 로그인은 가능했다. 그 후 피드를 업로드할 때 s3와의 연동도 문제 없었다.
첫 번째 시도 당시, 피드가 등록은 되었지만 막상 전체 조회가 되지 않았다. 그래서 조회쪽 문제인가 싶어 db를 보니 feed 관련 데이터에 아무것도 들어오지 않았다. s3와 연동된 image 데이터만이 살아 있었다.
이때 당시부터 4시간 이상을 소요하여 얻어낸 허무한 결과를 말해 보겠다.
첫 번째 시도 당시에는 피드가 등록은 되었다고 착각은 할 수 있었지만, 두 번쨰 시도 당시부터는 “이미지 id가 없습니다”라는 에러가 발생했다. 그 당시의 나는 s3에 잘 업로드가 되었는데 왜 이런 에러가 발생할까?라는 생각만 하고 가장 기본적인 생각을 하지 못했다.
그렇다. 회원의 “기본 이미지”를 고려하지 못한 것이다.
INSERT INTO image (id, url, deleted)
VALUES ('member-profile-default', 'https://foodymoody-s3.s3.ap-northeast-2.amazonaws.com/images/custom/logoSmall.svg', 0);
이는 아주 허무하게 이전 테스트 코드를 다시 복기하다가 깨닫게 됐다. 테스트 돌리기 전 기본 데이터를 항상 초기화해주는 로직을 생성했었는데, 그 이미지 데이터 중에 마지막에 이 기본 이미지를 넣어주는 게 있었다.
이전 주소도 새로운 logo를 넣어 내 s3 버킷에 넣어 바꿔놓았다.
결론
혹여나 서버 데이터베이스를 날리는 한이 있더라도, 아래의 데이터만 넣는다면 서버 운영 측면에서는 문제가 없는 꼭 필요한 sql문이 아래와 같이 완성되었다. 엄밀히 말하면 아직 map과의 연동이 완료되지 않아서 store와 같은 데이터를 임의로 넣어줘야 하지만, 어찌 됐든 해결은 됐으니 다음 OAuth의 401 문제를 해결해 봐야겠다.
INSERT INTO store_mood (id, name)
VALUES ('1', '가족과 함께'),
('2', '혼밥'),
('3', '감성'),
('4', '데이트'),
('5', '루프탑'),
('6', '특별한 테마'),
('7', '친구와 함께'),
('8', '비즈니스 미팅'),
('9', '파티'),
('10', '휴식'),
('11', '스포츠 시청'),
('12', '야경'),
('13', '바다 전망'),
('14', '산 전망'),
('15', '도시 전망'),
('16', '자연 친화적'),
('17', '아침 식사'),
('18', '점심 식사'),
('19', '저녁 식사'),
('20', '야식');
INSERT INTO taste_mood (id, name)
VALUES ('1', '매운맛'),
('2', '단맛'),
('3', '짠맛'),
('4', '신맛'),
('5', '쓴맛'),
('6', '기름진맛'),
('7', '가벼운맛'),
('8', '무거운맛'),
('9', '새콤한맛'),
('10', '담백한맛'),
('11', '풍부한맛'),
('12', '깔끔한맛'),
('13', '부드러운맛'),
('14', '칼칼한맛'),
('15', '짭짤한맛'),
('16', '달큰한맛'),
('17', '향긋한맛'),
('18', '고소한맛'),
('19', '시원한맛'),
('20', '따뜻한맛');
INSERT INTO store_status(code, type)
VALUES (1, 'OPEN'),
(2, 'TEMPORARILY_CLOSED'),
(3, 'CLOSED'),
(4, 'ETC');
INSERT INTO foodymoody.store (id, address, mgt_no, opn_sf_team_code, opn_svc_id, name, phone, road_address, updated_at, x, y, status)
VALUES
('1', '서울특별시 은평구 녹번동 162-39번지 1층', '3110000-101-1996-01174', '3110000', '07_24_04_P', '중국관', '02 3563831', '서울특별시 은평구 진흥로 70, 1층 (녹번동)', NULL, 193008.663820573, 455647.024463152, 1),
('2', '서울특별시 관악구 남현동 1058-6', '3200000-101-2023-00249', '3200000', '07_24_04_P', '본죽&비빔밥사당남현점', '', '서울특별시 관악구 남현길 7, 1층 103호 (남현동)', NULL, 197958.524057933, 441542.490987188, 1),
('3', '서울특별시 용산구 이태원동 119-29', '3020000-101-2023-00500', '3020000', '07_24_04_P', '볼빨간삼춘빠', '', '서울특별시 용산구 이태원로 165-6, 지하1층 (이태원동)', NULL, 199269.056052683, 448055.156196532, 1),
('4', '서울특별시 강동구 명일동 48-2', '3240000-101-1995-07328', '3240000', '07_24_04_P', '큰마루', '02 4290535', '서울특별시 강동구 동남로73길 23 (명일동)', NULL, 213620.683279907, 450050.909479909, 1),
('5', '서울특별시 동작구 노량진동 117-16번지', '3190000-101-2007-00156', '3190000', '07_24_04_P', '노량진 생고기', '000208176111', '서울특별시 동작구 만양로 108 (노량진동)', NULL, 195020.065726607, 445651.858121299, 1),
('6', '서울특별시 중구 을지로6가 58-5 20층', '3010000-101-2018-00212', '3010000', '07_24_04_P', '고메바', '0234258000', '서울특별시 중구 을지로 238, 20층 (을지로6가)', NULL, 200314.646974736, 451554.066925226, 1),
('7', '서울특별시 강서구 방화동 180-19번지 (지상 1층)', '3150000-101-2006-00159', '3150000', '07_24_04_P', '돈자루', '0226645455', '서울특별시 강서구 양천로26길 10-2, 1층 (방화동, 1동)', NULL, 183807.937902145, 452316.134904751, 1),
('8', '서울특별시 용산구 이태원동 62-0 (지상1층)', '3020000-101-1995-05787', '3020000', '07_24_04_P', '월산동아지트', '', '서울특별시 용산구 보광로59길 57 (이태원동,(지상1층))', NULL, 199125.063117303, 447942.37841349, 1),
('9', '서울특별시 성북구 장위동 64-8번지 1층', '3070000-101-2011-00128', '3070000', '07_24_04_P', '직화짬뽕 전문점', '', '서울특별시 성북구 돌곶이로 105 (장위동,1층)', NULL, 204812.657781087, 456654.871159366, 1),
('10', '서울특별시 마포구 망원동 377-1 마포로얄프라자', '3130000-101-2021-00651', '3130000', '07_24_04_P', '무세이키친', '', '서울특별시 마포구 월드컵로 87, 마포로얄프라자 1층 107, 108호 (망원동)', NULL, 191904.25617187, 450473.93544408, 1),
('11', '서울특별시 은평구 갈현동 503-1', '3110000-101-2022-00222', '3110000', '07_24_04_P', '푸드딜리버리 은평점', '', '서울특별시 은평구 갈현로29길 5, 1층 (갈현동)', NULL, 192402.698792116, 457436.114768359, 1),
('12', '서울특별시 광진구 광장동 185-6', '3040000-101-2003-00374', '3040000', '07_24_04_P', '이백', '02 4548880', '서울특별시 광진구 아차산로78길 175 (광장동)', NULL, 209512.089430461, 449491.155494168, 1),
('13', '서울특별시 강남구 논현동 248-7 지하2층', '3220000-101-2005-01187', '3220000', '07_24_04_P', '아이피호텔휘트니스', '0234408233', '서울특별시 강남구 언주로 640 (논현동,지하2층)', NULL, 203102.074986325, 445751.652027981, 1),
('14', '서울특별시 중구 회현동1가 92-16 (지상1,2층)', '3010000-101-2006-00132', '3010000', '07_24_04_P', '야레향', '02 7523991', '서울특별시 중구 퇴계로10길 14 (회현동1가,(지상1,2층))', NULL, 198178.465503048, 450713.513681395, 1),
('15', '서울특별시 성북구 종암동 131-2 종암2차아이파크 상가동 104호', '3070000-101-2013-00104', '3070000', '07_24_04_P', '탐스비어', '', '서울특별시 성북구 종암로9길 86, 상가동 1층 104호 (종암동, 종암2차아이파크)', NULL, 202854.230690052, 455038.993896321, 1),
('16', '서울특별시 마포구 도화동 251-1', '3130000-101-2023-00944', '3130000', '07_24_04_P', '크림라벨', '', '서울특별시 마포구 삼개로 20, 별관 1층 102호 (도화동)', NULL, 195254.758704781, 448476.859046692, 1),
('17', '서울특별시 강남구 신사동 648-24번지', '3220000-101-2019-01418', '3220000', '07_24_04_P', '클랩피자 청담점', '', '서울특별시 강남구 압구정로46길 71, 지상1층 (신사동)', NULL, 203164.773811596, 446874.689704741, 1),
('18', '서울특별시 양천구 목동 607-43', '3140000-101-2023-00151', '3140000', '07_24_04_P', 'SOOT숯', '', '서울특별시 양천구 목동중앙북로7가길 58, 2층 (목동)', NULL, 187966.115402403, 449743.050416144, 1),
('19', '서울특별시 성동구 송정동 73-225', '3030000-101-2023-00410', '3030000', '07_24_04_P', '1유로펍', '', '서울특별시 성동구 송정18길 1-1, 1층 101호 (송정동)', NULL, 205940.779396411, 450100.588859321, 1),
('20', '서울특별시 도봉구 방학동 669 1층', '3090000-101-2017-00135', '3090000', '07_24_04_P', '윤짬뽕', '02 61050211', '서울특별시 도봉구 방학로 183, 1동 1층 (방학동)', NULL, 202764.917530564, 462169.731321838, 1);
insert into foodymoody.oauth_provider (name)
values ('GOOGLE');
INSERT INTO image (id, url, deleted)
VALUES ('member-profile-default', 'https://foodymoody-s3.s3.ap-northeast-2.amazonaws.com/images/custom/logoSmall.svg', 0);
Leave a comment