refresh - g-market/b-shop-backend GitHub Wiki

INSERT INTO item (id, created_at, updated_at, base_price, deleted, description, item_status, name, open_at, thumbnail, year, category_id) VALUES (26, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 5800, 0, '', 'PUBLIC', '스테이플러', '2023-01-01 15:09:10.333745', "d4214824-bc42-4377-b357-f5b6153ec71c", 2023, 8),

(27, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 12600, 0, '', 'PUBLIC', '테이프 디스펜서', '2023-01-01 15:09:10.333745', "ae7132e9-071c-4175-b65d-91ac022e0fb1", 2023, 8),

(28, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 6100, 0, '', 'PUBLIC', '휴대용 가위 (칼 겸용)', '2023-01-01 15:09:10.333745', "210c105e-b870-4efd-a175-24e04ec71ac3", 2023, 8),

(29, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 9300, 0, '', 'PUBLIC', '멀티 정리함', '2023-01-01 15:09:10.333745', "973c0e6c-fde3-479e-abc5-4469e99ae5c9", 2023, 8),

(30, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 8600, 0, '', 'PUBLIC', '2칸 연필꽂이/펜꽂이', '2023-01-01 15:09:10.333745', "409737eb-5aaf-471b-a906-a028ba820fc9", 2023, 8),

(31, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 11000, 0, '', 'PUBLIC', '방수 가죽 데스크 패드', '2023-01-01 15:09:10.333745', "7355a1dd-3b40-406b-96d7-0333a3cc7d54", 2023, 2),

(32, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 12600, 0, '', 'PUBLIC', '무선충전 손목보호 마우스패드', '2023-01-01 15:09:10.333745', "c81a006a-105e-4cee-b685-9835951db91e", 2023, 2),

(33, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 22600, 0, '', 'PUBLIC', '원목 모니터 스탠드', '2023-01-01 15:09:10.333745', "0f9491ae-618b-4273-935e-6359c40a807f", 2023, 8),

(34, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 22600, 0, '', 'PUBLIC', '친환경 실내용 슬리퍼', '2023-01-01 15:09:10.333745', "e0321ba4-de1f-4e32-99ea-735a201cd453", 2023, 8),

(35, '2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 22600, 0, '', 'PUBLIC', '3단 자동 우산', '2023-01-01 15:09:10.333745', "11011881-a653-4a22-9b53-c60725849566", 2023, 2), ;

INSERT INTO item_option (created_at, updated_at, deleted, description, option_price, stock_quantity, item_id) VALUES ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '퓨어화이트', 0, 200, 26), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '이브닝섀도우', 0, 200, 26), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙스모크', 0, 200, 26),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '레드', 0, 200, 27), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '옐로우', 0, 200, 27), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '화이트', 0, 200, 27), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '베이지', 0, 200, 27),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '핑크', 0, 200, 28), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '화이트핑크', 0, 200, 28), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블루', 0, 200, 28), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '화이트블루', 0, 200, 28),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '화이트', 0, 200, 29), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블루', 0, 200, 29), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그레이', 0, 200, 29), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그린', 0, 200, 29),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '화이트', 0, 200, 30), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블루', 0, 200, 30), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '핑크', 0, 200, 30), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙', 0, 200, 30),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙-소형', 0, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙-중형', 2000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙-대형', 4000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그린-소형', 0, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그린-중형', 2000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그린-대형', 4000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '브라운-소형', 0, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '브라운-중형', 2000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '브라운-대형', 4000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '베이지-소형', 0, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '베이지-중형', 2000, 200, 31), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '베이지-대형', 4000, 200, 31),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '브라운', 0, 200, 32), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙', 0, 200, 32), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그레이', 0, 200, 32),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '브라운', 0, 200, 32), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '블랙', 0, 200, 32), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '그레이', 0, 200, 32),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '기본', 0, 200, 33),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '기본', 0, 200, 34),

('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '빨강', 0, 200, 35), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '주황', 0, 200, 35), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '노랑', 0, 200, 35), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '초록', 0, 200, 35), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '파랑', 0, 200, 35), ('2023-03-08 15:09:10.487028', '2023-03-08 15:09:10.487028', 0, '검정', 0, 200, 35), ;

INSERT INTO item_image (created_at, updated_at, deleted, image_name, item_id) VALUES ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'd4214824-bc42-4377-b357-f5b6153ec71c', 26),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'ae7132e9-071c-4175-b65d-91ac022e0fb1', 27), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '120088ef-9617-4283-898c-7ed1cb3569a2', 27), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '9cfdd0c6-882b-4a09-8c76-d27902ba4364', 27), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '1b1f0672-3ac4-4730-9295-74cc7f098be2', 27),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '210c105e-b870-4efd-a175-24e04ec71ac3', 28), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'ab539940-9e03-4d64-bfcc-6f04377a760d', 28),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '973c0e6c-fde3-479e-abc5-4469e99ae5c9', 29),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '409737eb-5aaf-471b-a906-a028ba820fc9', 30),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '7355a1dd-3b40-406b-96d7-0333a3cc7d54', 31),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'c81a006a-105e-4cee-b685-9835951db91e', 32),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '0f9491ae-618b-4273-935e-6359c40a807f', 33), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'df047106-8d11-488f-8e5a-05aee4901a6b', 33), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '0b6731fc-b008-420f-be6f-11a7baa61599', 33), ('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '194d1d84-3fb2-406f-8f2d-f175aa2a3786', 33),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, 'e0321ba4-de1f-4e32-99ea-735a201cd453', 34),

('2023-03-08 15:09:10.543639', '2023-03-08 15:09:10.543639', 0, '11011881-a653-4a22-9b53-c60725849566', 35) ;