DML (test data)

[kwj3682]

insert into tb_category_map (category_dist_no, category_dist_name) values (1,'재료');

insert into tb_category_map (category_dist_no, category_dist_name) values (2,'양식');

insert into tb_category_map (category_dist_no, category_dist_name) values (3,'종류');

insert into tb_category_map (category_dist_no, category_dist_name) values (4,'열량');

insert into tb_category_map (category_dist_no, category_dist_name) values (5,'조리시간');

insert into tb_category_map (category_dist_no, category_dist_name) values (6,'난이도');

insert into tb_category_map (category_dist_no, category_dist_name) values (7,'날씨');

insert into tb_category_map (category_dist_no, category_dist_name) values (8,'주의사항');

[kwj3682]

재료 목록 import

[kwj3682]

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'한식',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'양식',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'중식',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'일식',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'동남아',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'기타아시아',2);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'기타',2);

[kwj3682]

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'국/탕류',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'찌개',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'반찬',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'면',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'만두',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'밥',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'샐러드',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'스프',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'음료',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'빵/디저트',3);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'기타',3);

[kwj3682]

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'1',4);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'2',4);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'3',4);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'4',4);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'5',4);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'1',5);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'2',5);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'3',5);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'4',5);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'5',5);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'매우 쉬움',6);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'쉬움',6);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'보통',6);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'어려움',6);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'매우 어려움',6);

[kwj3682]

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'맑음',7);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'흐림/비',7);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'눈',7);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'더워요',7);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'추워요',7);

[kwj3682]

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'고열량',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'당뇨병',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'채식',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'육식',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'할랄',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'임산부',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'고염',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'영유아',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'패스트푸드',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'견과류',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'알러지 유발 식품',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'고열량',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'많이 매움',8);

insert into tb_category (category_no, category_name,category_dist_no) values (s_category_no.nextval,'무염',8);

[kwj3682]

insert into tb_member ( mem_no,mem_id,mem_password, mem_email, mem_favor1, mem_favor2, mem_favor3) values ( s_mem_no.nextval, 'admin', CryptString.encrypt('1234','key'), 'kwj3682@naver.com', '찌개', '쉬움', '채식');

[Koo-Bon-Young]

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 2, '아보카도 명란 비빔밥', '산뜻한 아보카도 색감과 입맛 돋우는 명란젓이 더해져 침이 꼴깍 삼켜지는 메뉴!', 2, 10, 10, 4908, 4920, 300, 10, 4936, 4941, 4.5, 1, 'f1' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 2, '인도 커리 스톡', '환절기의 헛헛한 속을 채워 줄 나만의 자양 강장제, 약으로도 쓰이는 각종 향신료들이 한 곳에 모여 피워낸 꽃과도 같은 음식!', 2, 200, 100, 4913, 4922, 279, 20, 4937, 4944, 3, 1, 'f2' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 3, '사워 크림 바게트', '바게트 특유의 바삭함과 크림이 들어가 씹을수록 부드러운 크림향을 느낄 수 있고, 버터를 곁들여 즐길 수 있는 디저트', 2, 200, 100, 4909, 4924, 368, 5, 4936, 4941, 1, 1, 'f3' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 4, '캘리포니아 피자', '신선한 야채를 풍성하게 토핑한 후 화덕에 구워 느끼한 맛이 없고, 독특한 레시피와 숙성법으로 만들어진 피자 도우는 솜털처럼 부드러우면서도 쫄깃한 맛이 특징', 2, 1000, 5, 4909, 4924, 350, 40, 4939, 4942, 5, 1, 'f4' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 5, '스노우 와플', '생크림의 부드러움이 크림의 풍미와 향을 한껏 살려 더 맛있는 와플', 2, 100, 50, 4913, 4922, 200, 15, 4937, 4941, 2.5, 1, 'f5' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 6, '미트볼 스파게티', '육즙 가득 미트볼과 진항 풍미를 가진 볼로냐 스파게티 소스를 활용한 미트볼 스파게티', 2, 300, 150, 4913, 4918, 160, 20, 4938, 4941, 3.5, 1, 'f6' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 7, '티벳 툭바', '티벳이나 네팔을 여행해본 사람중에서 이 뚝바를 모르면, 제대로 여행을 해보지 못한거라는 소리가 있을 정도로 뚝바는 네팔의 명물이자, 가장 서민적인 요리!', 2, 270, 50, 4912, 4918, 300, 20, 4939, 4944, 3.3, 1, 'f7' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo )values( 8, '아메리칸 수제 버거', '아메리칸 싱글 버거는 바삭하고 육즙이 꽉 찬 패티, 일본식 베이커리 번과 특제소스까지 더해져 생긴 건 귀엽고 심플하지만 풍성한 버거 ', 2, 50, 10, 4909, 4924, 490, 30, 4938, 4944, 3.8, 1, 'f8' );

insert into tb_recipe( recipe_no, recipe_title, recipe_summary, mem_no, recipe_view_cnt, recipe_like_cnt, recipe_country, recipe_type, recipe_kcal, recipe_time, recipe_level, recipe_weather, recipe_grade, recipe_grade_count, recipe_photo
)values( 9, '연회장 전용 핑거 푸드', '이번 파티 음식으로는 손으로 쏙 집어 한입에 쏙 넣기 좋은 핑거푸드 어때요?', 2, 2, 1, 4914, 4924, 50, 15, 2, 4936, 2.7, 1, 'f9' );