공통코드

-- common code
INSERT INTO `common_code` (`common_code`, `name`) VALUES ("A", "회원상태"), ("B", "보상조건"), ("C", "미션진행"), ("D", "게시글유형");

-- code
INSERT INTO `code` (`common_code`, `code`, `name`, `use_yn`) VALUES ("A", "A01", "일반회원", 1), ("A", "A02", "탈퇴회원", 1);
INSERT INTO `code` (`common_code`, `code`, `name`, `use_yn`) VALUES ("B", "B01", "맵 확장", 1), ("B", "B02", "동물획득", 1);
INSERT INTO `code` (`common_code`, `code`, `name`, `use_yn`) VALUES ("C", "C01", "비활성화", 1),("C", "C02", "미션 직전", 1), ("C", "C03", "미션 진행", 1), ("C", "C04", "미션 완료", 1);
INSERT INTO `code` (`common_code`, `code`, `name`, `use_yn`) VALUES ("D", "D01", "자유게시판", 1),("D", "D02", "얼룩말과 함께", 1), ("D", "D03", "텀블러101", 1), ("D", "D04", "동물도감 자랑", 1), ("D", "D05", "환경일기", 1), ("D", "D06", "환경관심도 측정", 1);

맵/동물/미션

-- map
INSERT INTO `map` (`id`, `name`) VALUES ("M001", "숲/초원"), ("M002", "북극/남극"), ("M003", "해안");

-- animals
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001001","굴토끼","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001002","얼룩말","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001003","기린","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001004","고릴라","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001005","자이언트 판다","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001006","엘드사슴","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001007","난쟁이가지뿔영양","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001008","라쿤","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001009","퓨마","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001010","코끼리","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001011","회색늑대","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001012","나무늘보","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001013","야생물소","M001");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A001014","사자","M001");

INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002001","북극곰","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002002","바다코끼리","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002003","황제펭귄","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002004","북극토끼","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002005","볏왕관펭귄","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002006","순록","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002007","북극여우","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002008","남극물개","M002");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A002009","극제비갈매기","M002");

INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003001","켐프각시바다거북","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003002","듀공","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003003","흑범고래","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003004","백상아리","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003005","큰귀상어","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003006","개복치","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003007","황소상어","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003008","대왕쥐가오리","M003");
INSERT INTO `animals` (`id`, `name`, `map_id`) VALUES ("A003009","헥토르돌고래","M003");

-- mission
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1000","safers의 시작","S1010/S2010","A001002/A001009", "굴토끼");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1010","얼룩말과 인생한컷","S1020","A001003", "얼룩말");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1020","부끄럼쟁이 기린","S1030","A001004", "기린");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1030","텀블러 101","S1040","A001005", "고릴라");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1040","집을 잃은 북극곰","S1050","M002/A002001", "자이언트 판다");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1050","에어컨을 부탁해","S1060","A002002", "북극곰");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1060","띠띠띠- 영상을 잘 봐","S1070","A002003", "바다코끼리");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1070","저탄소 친환경 생활로 지구를 구해줘","S1080","A002004", "황제펭귄");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1080","명예볏왕관 만들기 ","S1090","A002005", "코뿔바다오리");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1090","새친구 퀴즈\n 볏왕관 펭귄을 맞혀봐","S1100","A002006", "볏왕관 펭귄");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1100","#근황체크#인싸의_길은_멀고도_험난하다","S1110","A001006", "순록");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1110","파티 참가 조건","S1120","A001007", "엘드사슴");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1120","로켓배송","S1130","A001008", "난쟁이가지뿔영양");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1130","너에 대한 모든게 궁금해","S1140","A002007", "라쿤");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1140","나의 환경 관심도는 몇 점","S1150","A002008", "북극여우");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S1150","감사의 인사","","A002009", "남극물개");

INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2010","초원의 스핑크스","S2020","A001010", "퓨마");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2020","환경일기 시작하기","S2030","A001011", "코끼리");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2030","에너지 절약의 첫걸음","S2040","A001012", "회색늑대");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2040","배고픈 나무늘보의 부탁","S2050","M003/A003001", "나무늘보");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2050","답답한 마스크","S2060","A003002", "켐프각시바다거북");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2060","울고 있는 듀공","S2070","A003003", "듀공");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2070","에너지 절약의 첫걸음2","S2080","A003004", "흑범고래");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2080","잃어버린 진주를 찾아서","S2090","A003005", "백상아리");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2090","고마움의 표시","S2100","A003006", "큰귀상어");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2100","돌연사를 막아라","S2110","A001013", "개복치");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2110","새로운 친구 사귀기","S2120","A001014", "켐프각시바다거북");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2120","심심한 사자의 부탁","S2130","A003007", "사자");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2130","너의 도감을 자랑해봐!","S2140","A003008", "황소상어");
INSERT INTO `mission` (`id`, `title`, `next_mission`, `result_id`, `animal_name`) VALUES ("S2140","감사의 인사2","","A003009", "대왕쥐가오리");

설문조사