기존 데이터

-- 커피 INSERT INTO drink(name, img, price, type) VALUES ('아메리카노', 'imgurl1', 4000, 'coffee') INSERT INTO drink(name, img, price, type) VALUES ('콜드브루', 'imgurl2', 4500, 'coffee') INSERT INTO drink(name, img, price, type) VALUES ('에스프레소', 'imgurl3', 3000, 'coffee') INSERT INTO drink(name, img, price, type) VALUES ('카페모카', 'imgurl4', 4500, 'coffee')

-- 라떼 INSERT INTO drink(name, img, price, type) VALUES ('카라멜라떼', 'imgurl5', 3800, 'latte'); INSERT INTO drink(name, img, price, type) VALUES ('헤이즐넛라떼', 'imgurl6', 3500, 'latte'); INSERT INTO drink(name, img, price, type) VALUES ('밀크티라떼', 'imgurl7', 3800, 'latte'); INSERT INTO drink(name, img, price, type) VALUES ('카페라떼', 'imgurl8', 3200, 'latte');

-- 티 INSERT INTO drink(name, img, price, type) VALUES ('그린티', 'imgurl5', 3000, 'tea'); INSERT INTO drink(name, img, price, type) VALUES ('얼그레이', 'imgurl6', 2500, 'tea'); INSERT INTO drink(name, img, price, type) VALUES ('자몽차', 'imgurl7', 3500, 'tea'); INSERT INTO drink(name, img, price, type) VALUES ('페퍼민트', 'imgurl8', 3000, 'tea');

-- 쥬스 INSERT INTO drink(name, img, price, type) VALUES ('오렌지주스', 'imgurl9', 4000, 'juice'); INSERT INTO drink(name, img, price, type) VALUES ('키위주스', 'imgurl10', 3500, 'juice'); INSERT INTO drink(name, img, price, type) VALUES ('딸기주스', 'imgurl11', 3800, 'juice'); INSERT INTO drink(name, img, price, type) VALUES ('망고주스', 'imgurl12', 4200, 'juice');

-- 디카페인 INSERT INTO drink(name, img, price, type) VALUES ('아메리카노', 'imgurl13', 4500, 'decaffeine') INSERT INTO drink(name, img, price, type) VALUES ('콜드브루', 'imgurl14', 5000, 'decaffeine') INSERT INTO drink(name, img, price, type) VALUES ('에스프레소', 'imgurl13', 3500, 'decaffeine') INSERT INTO drink(name, img, price, type) VALUES ('카페모카', 'imgurl14', 5000, 'decaffeine')

-- 옵션 리스트 INSERT INTO drink_option(type, value) VALUES ('size', 'S') INSERT INTO drink_option(type, value) VALUES ('size', 'M') INSERT INTO drink_option(type, value) VALUES ('size', 'L') INSERT INTO drink_option(type, value) VALUES ('temperature', 'Hot') INSERT INTO drink_option(type, value) VALUES ('temperature', 'Ice')

-- 아메리카노 INSERT INTO available_option(drink_id, option_id) VALUES (1, 1) INSERT INTO available_option(drink_id, option_id) VALUES (1, 2) INSERT INTO available_option(drink_id, option_id) VALUES (1, 3) INSERT INTO available_option(drink_id, option_id) VALUES (1, 4) INSERT INTO available_option(drink_id, option_id) VALUES (1, 5)

-- 콜드브루 INSERT INTO available_option(drink_id, option_id) VALUES (2, 1) INSERT INTO available_option(drink_id, option_id) VALUES (2, 2) INSERT INTO available_option(drink_id, option_id) VALUES (2, 3) INSERT INTO available_option(drink_id, option_id) VALUES (2, 5)

-- 에스프레소 INSERT INTO available_option(drink_id, option_id) VALUES (3, 1) INSERT INTO available_option(drink_id, option_id) VALUES (3, 4)

-- 카페모카 INSERT INTO available_option(drink_id, option_id) VALUES (4, 1) INSERT INTO available_option(drink_id, option_id) VALUES (4, 2) INSERT INTO available_option(drink_id, option_id) VALUES (4, 3) INSERT INTO available_option(drink_id, option_id) VALUES (4, 4) INSERT INTO available_option(drink_id, option_id) VALUES (4, 5)

-- 카라멜라떼 INSERT INTO available_option(drink_id, option_id) VALUES (5, 1) INSERT INTO available_option(drink_id, option_id) VALUES (5, 2) INSERT INTO available_option(drink_id, option_id) VALUES (5, 3) INSERT INTO available_option(drink_id, option_id) VALUES (5, 4) INSERT INTO available_option(drink_id, option_id) VALUES (5, 5)

-- 헤이즐넛라떼 INSERT INTO available_option(drink_id, option_id) VALUES (6, 1) INSERT INTO available_option(drink_id, option_id) VALUES (6, 2) INSERT INTO available_option(drink_id, option_id) VALUES (6, 3) INSERT INTO available_option(drink_id, option_id) VALUES (6, 4) INSERT INTO available_option(drink_id, option_id) VALUES (6, 5)

-- 바닐라라떼 INSERT INTO available_option(drink_id, option_id) VALUES (7, 1) INSERT INTO available_option(drink_id, option_id) VALUES (7, 2) INSERT INTO available_option(drink_id, option_id) VALUES (7, 3) INSERT INTO available_option(drink_id, option_id) VALUES (7, 4) INSERT INTO available_option(drink_id, option_id) VALUES (7, 5)

-- 카페라떼 INSERT INTO available_option(drink_id, option_id) VALUES (8, 1) INSERT INTO available_option(drink_id, option_id) VALUES (8, 2) INSERT INTO available_option(drink_id, option_id) VALUES (8, 3) INSERT INTO available_option(drink_id, option_id) VALUES (8, 4) INSERT INTO available_option(drink_id, option_id) VALUES (8, 5)

-- 그린티 INSERT INTO available_option(drink_id, option_id) VALUES (9, 3) INSERT INTO available_option(drink_id, option_id) VALUES (9, 4) INSERT INTO available_option(drink_id, option_id) VALUES (9, 5) INSERT INTO available_option(drink_id, option_id) VALUES (9, 1) INSERT INTO available_option(drink_id, option_id) VALUES (9, 2)

-- 얼그레이 INSERT INTO available_option(drink_id, option_id) VALUES (10, 1) INSERT INTO available_option(drink_id, option_id) VALUES (10, 2) INSERT INTO available_option(drink_id, option_id) VALUES (10, 3) INSERT INTO available_option(drink_id, option_id) VALUES (10, 4) INSERT INTO available_option(drink_id, option_id) VALUES (10, 5)

-- 자몽차 INSERT INTO available_option(drink_id, option_id) VALUES (11, 1) INSERT INTO available_option(drink_id, option_id) VALUES (11, 2) INSERT INTO available_option(drink_id, option_id) VALUES (11, 3) INSERT INTO available_option(drink_id, option_id) VALUES (11, 4) INSERT INTO available_option(drink_id, option_id) VALUES (11, 5)

-- 페퍼민트 INSERT INTO available_option(drink_id, option_id) VALUES (12, 1) INSERT INTO available_option(drink_id, option_id) VALUES (12, 2) INSERT INTO available_option(drink_id, option_id) VALUES (12, 3) INSERT INTO available_option(drink_id, option_id) VALUES (12, 4) INSERT INTO available_option(drink_id, option_id) VALUES (12, 5)

-- 오렌지쥬스 INSERT INTO available_option(drink_id, option_id) VALUES (13, 1) INSERT INTO available_option(drink_id, option_id) VALUES (13, 2) INSERT INTO available_option(drink_id, option_id) VALUES (13, 3) INSERT INTO available_option(drink_id, option_id) VALUES (13, 5)

-- 키위쥬스 INSERT INTO available_option(drink_id, option_id) VALUES (14, 1) INSERT INTO available_option(drink_id, option_id) VALUES (14, 2) INSERT INTO available_option(drink_id, option_id) VALUES (14, 3) INSERT INTO available_option(drink_id, option_id) VALUES (14, 5)

-- 딸기쥬스 INSERT INTO available_option(drink_id, option_id) VALUES (15, 1) INSERT INTO available_option(drink_id, option_id) VALUES (15, 2) INSERT INTO available_option(drink_id, option_id) VALUES (15, 3) INSERT INTO available_option(drink_id, option_id) VALUES (15, 5)

-- 망고쥬스 INSERT INTO available_option(drink_id, option_id) VALUES (16, 1) INSERT INTO available_option(drink_id, option_id) VALUES (16, 2) INSERT INTO available_option(drink_id, option_id) VALUES (16, 3) INSERT INTO available_option(drink_id, option_id) VALUES (16, 5)

-- 아메리카노 INSERT INTO available_option(drink_id, option_id) VALUES (17, 1) INSERT INTO available_option(drink_id, option_id) VALUES (17, 2) INSERT INTO available_option(drink_id, option_id) VALUES (17, 3) INSERT INTO available_option(drink_id, option_id) VALUES (17, 4) INSERT INTO available_option(drink_id, option_id) VALUES (17, 5)

-- 콜드브루 INSERT INTO available_option(drink_id, option_id) VALUES (18, 1) INSERT INTO available_option(drink_id, option_id) VALUES (18, 2) INSERT INTO available_option(drink_id, option_id) VALUES (18, 3) INSERT INTO available_option(drink_id, option_id) VALUES (18, 5)

-- 에스프레소 INSERT INTO available_option(drink_id, option_id) VALUES (19, 1) INSERT INTO available_option(drink_id, option_id) VALUES (19, 4)

-- 카페모카 INSERT INTO available_option(drink_id, option_id) VALUES (20, 1) INSERT INTO available_option(drink_id, option_id) VALUES (20, 2) INSERT INTO available_option(drink_id, option_id) VALUES (20, 3) INSERT INTO available_option(drink_id, option_id) VALUES (20, 4) INSERT INTO available_option(drink_id, option_id) VALUES (20, 5)