style24.doc/산출물/4.구축/데이터처리/03.전시카테고리생성(TB_CATE_4SRCH).sql

DROP TABLE TMP_CATE;

CREATE TABLE TMP_CATE AS
SELECT 9000 AS CATE1_NO
     , '여성' AS CATE1_NM
     , 9001 AS CATE2_NO
     , '니트/가디건/베스트' AS CATE2_NM
     , 9002 AS CATE3_NO
     , '티셔츠/셔츠/블라우스' AS CATE3_NM
     , 9003 AS CATE4_NO
     , '배냇저고리/배냇가운' AS CATE4_NM
FROM   DUAL
;

ALTER TABLE TMP_CATE MODIFY COLUMN CATE1_NM VARCHAR(50);
ALTER TABLE TMP_CATE MODIFY COLUMN CATE2_NM VARCHAR(50);
ALTER TABLE TMP_CATE MODIFY COLUMN CATE3_NM VARCHAR(50);
ALTER TABLE TMP_CATE MODIFY COLUMN CATE4_NM VARCHAR(50);

INSERT INTO TMP_CATE VALUES (1100, '여성', 1101, '니트/가디건/베스트', 1102, '가디건', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1101, '니트/가디건/베스트', 1103, '니트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1101, '니트/가디건/베스트', 1103, '니트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1101, '니트/가디건/베스트', 1103, '니트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1101, '니트/가디건/베스트', 1104, '베스트/조끼', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1106, '부츠컷/와이드', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1106, '부츠컷/와이드', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1107, '쇼츠/반바지/9부', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1107, '쇼츠/반바지/9부', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1108, '슬림/스키니', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1108, '슬림/스키니', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1109, '일자/스트레이트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1109, '일자/스트레이트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1110, '테이퍼드/배기/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1105, '데님', 1110, '테이퍼드/배기/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1112, '기타 언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1113, '브라', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1113, '브라', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1114, '세트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1115, '팬티', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1111, '언더웨어', 1115, '팬티', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1117, '가방/지갑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1117, '가방/지갑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1118, '모자/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1118, '모자/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1119, '벨트/기타잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1119, '벨트/기타잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1120, '슈즈', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1121, '스카프/머플러/워머', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1121, '스카프/머플러/워머', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1121, '스카프/머플러/워머', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1122, '양말/스타킹', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 1122, '양말/스타킹', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1116, '여성 잡화', 3400, '드레스/한복/기타의류', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1123, '원피스/스커트', 1124, '스커트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1123, '원피스/스커트', 1124, '스커트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1123, '원피스/스커트', 1125, '원피스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1123, '원피스/스커트', 1125, '원피스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1127, '자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1127, '자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1128, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1128, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1128, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1128, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1129, '코트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1126, '자켓/점퍼/코트', 1129, '코트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1131, '상의', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1132, '세트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1133, '스포츠잡화', 1134, '가방/모자/잡화');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1133, '스포츠잡화', 1135, '운동화/등산화');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1133, '스포츠잡화', 1135, '운동화/등산화');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1136, '시즌스포츠의류', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1130, '트레이닝/스포츠', 1137, '하의', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1139, '셔츠/블라우스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1139, '셔츠/블라우스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1139, '셔츠/블라우스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1139, '셔츠/블라우스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1139, '셔츠/블라우스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1140, '슬리브리스/탑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1140, '슬리브리스/탑', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1141, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1141, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1141, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1141, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1138, '티셔츠/셔츠', 1141, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1143, '레깅스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1143, '레깅스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1143, '레깅스', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1144, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1144, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1144, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1144, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1100, '여성', 1142, '팬츠/레깅스', 1145, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1202, '가방', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1203, '기타 잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1204, '모자/머플러/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1204, '모자/머플러/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1204, '모자/머플러/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1204, '모자/머플러/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1204, '모자/머플러/장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1205, '운동화/슈즈', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1206, '양말', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1207, '지갑/벨트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 1207, '지갑/벨트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1201, '남성 잡화', 3401, '한복/기타의류', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1209, '가디건', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1209, '가디건', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1210, '니트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1210, '니트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1211, '베스트/조끼', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1208, '니트/가디건/베스트', 1211, '베스트/조끼', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1213, '부츠컷/와이드', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1213, '부츠컷/와이드', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1214, '쇼츠/반바지/9부', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1214, '쇼츠/반바지/9부', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1215, '슬림/스키니', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1215, '슬림/스키니', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1216, '일자/스트레이트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1216, '일자/스트레이트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1217, '테이퍼드/배기/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1212, '데님', 1217, '테이퍼드/배기/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1218, '셔츠', 0, '', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1218, '셔츠', 0, '', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1218, '셔츠', 0, '', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1219, '언더웨어', 1220, '러닝/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1219, '언더웨어', 1220, '러닝/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1219, '언더웨어', 1220, '러닝/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1219, '언더웨어', 1220, '러닝/기타', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1219, '언더웨어', 1221, '팬티', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1223, '자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1223, '자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1224, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1224, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1224, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1224, '점퍼/야상', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1225, '코트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1222, '자켓/점퍼/코트', 1225, '코트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1227, '상의', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1228, '세트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1229, '스포츠잡화', 1230, '가방/모자/잡화');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1229, '스포츠잡화', 1231, '운동화/등산화');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1229, '스포츠잡화', 1231, '운동화/등산화');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1232, '시즌스포츠의류', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1226, '트레이닝/스포츠', 1233, '하의', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1235, '나시/탑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1235, '나시/탑', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1236, '반팔/7부 티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1236, '반팔/7부 티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1237, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1234, '티셔츠', 1237, '티셔츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1239, '면/팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1239, '면/팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1240, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1240, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1240, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1240, '반바지/점프수트', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1241, '정장/슬랙스', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1241, '정장/슬랙스', 0, '');
INSERT INTO TMP_CATE VALUES (1200, '남성', 1238, '팬츠', 1241, '정장/슬랙스', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1302, '니트/가디건/베스트', 1303, '가디건');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1302, '니트/가디건/베스트', 1304, '니트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1302, '니트/가디건/베스트', 1305, '베스트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1306, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1307, '시즌/테마 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1308, '신생아의류', 1309, '배냇저고리/배냇가운');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1308, '신생아의류', 1309, '배냇저고리/배냇가운');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1308, '신생아의류', 1310, '선물세트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1308, '신생아의류', 1311, '우주복/바디슈트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1308, '신생아의류', 1311, '우주복/바디슈트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1313, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1313, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1313, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1314, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1314, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1312, '실내복/속옷', 1314, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1315, '원피스/스커트', 1316, '스커트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1315, '원피스/스커트', 1317, '원피스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1318, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1318, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1318, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1319, '티셔츠/셔츠/블라우스', 1320, '셔츠/블라우스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1319, '티셔츠/셔츠/블라우스', 1321, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1322, '팬츠/레깅스', 1323, '레깅스/치랭스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1322, '팬츠/레깅스', 1323, '레깅스/치랭스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1301, '베이비', 1322, '팬츠/레깅스', 1324, '팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1327, '교구/완구');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1326, '교구/완구/도서', 1328, '도서');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1329, '목욕/위생용품', 1330, '목욕 용품');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1329, '목욕/위생용품', 1331, '스킨케어');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1329, '목욕/위생용품', 1332, '위생 용품');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1333, '외출/안전용품', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1334, '유아 가구/라이프', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1334, '유아 가구/라이프', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1335, '유아 식기', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1335, '유아 식기', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1336, '유아 침구', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1336, '유아 침구', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1336, '유아 침구', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1337, '출산용품', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1337, '출산용품', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1325, '유아 용품', 1337, '출산용품', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1339, '가방', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1340, '모자', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1341, '스카프/머플러/장갑', 1342, '머플러');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1341, '스카프/머플러/장갑', 1342, '머플러');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1341, '스카프/머플러/장갑', 1343, '스카프');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1341, '스카프/머플러/장갑', 1344, '장갑');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1345, '신발', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1346, '양말/타이즈', 1347, '양말');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1346, '양말/타이즈', 1348, '타이즈');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1346, '양말/타이즈', 1348, '타이즈');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1349, '우산/우비/장화', 1350, '우산/우비');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1349, '우산/우비/장화', 1350, '우산/우비');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1349, '우산/우비/장화', 1351, '장화');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1352, '헤어/기타잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1338, '유아 잡화', 1352, '헤어/기타잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1354, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1354, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1355, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1355, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1355, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1356, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1356, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1356, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1358, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1358, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1359, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1359, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1359, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1357, '티셔츠/셔츠', 1359, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1361, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1361, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1361, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1361, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1362, '트레이닝팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 1360, '팬츠', 1362, '트레이닝팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 3402, '니트/가디건/베스트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1353, '주니어 남아', 3403, '언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1364, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1364, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1365, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1365, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1365, '시즌 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1366, '원피스/스커트', 1367, '스커트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1366, '원피스/스커트', 1368, '원피스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1369, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1369, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1369, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1369, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1371, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1371, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1372, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1372, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1372, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1370, '티셔츠/셔츠', 1372, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1374, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1374, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1374, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1374, '면/데님팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1375, '트레이닝팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 1373, '팬츠', 1375, '트레이닝팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 3404, '니트/가디건/베스트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1363, '주니어 여아', 3405, '언더웨어', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1378, '가디건');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1378, '가디건');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1379, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1379, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1379, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1377, '가디건/조끼', 1379, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1380, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1380, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1381, '시즌/테마 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1381, '시즌/테마 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1383, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1384, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1382, '실내복/속옷', 1384, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1385, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1386, '티셔츠/셔츠', 1387, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1386, '티셔츠/셔츠', 1387, '셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1386, '티셔츠/셔츠', 1388, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1386, '티셔츠/셔츠', 1388, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1376, '키즈 남아', 1389, '팬츠', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1392, '가디건');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1392, '가디건');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1393, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1393, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1393, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1391, '가디건/조끼', 1393, '조끼');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1394, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1394, '상하복/세트', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1395, '시즌/테마 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1395, '시즌/테마 의류', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1397, '내의/실내복');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1398, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1396, '실내복/속옷', 1398, '속옷');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1399, '원피스/스커트', 1400, '스커트');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1399, '원피스/스커트', 1401, '원피스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1402, '점퍼/자켓', 0, '');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1403, '티셔츠/셔츠/블라우스', 1404, '셔츠/블라우스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1403, '티셔츠/셔츠/블라우스', 1404, '셔츠/블라우스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1403, '티셔츠/셔츠/블라우스', 1405, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1403, '티셔츠/셔츠/블라우스', 1405, '티셔츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1407, '레깅스/치랭스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1407, '레깅스/치랭스');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1408, '팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1408, '팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1408, '팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1408, '팬츠');
INSERT INTO TMP_CATE VALUES (1300, '유아동', 1390, '키즈 여아', 1406, '팬츠/레깅스', 1408, '팬츠');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1502, '골프 모자', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1503, '골프 벨트/백', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1503, '골프 벨트/백', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1504, '골프 양말', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1505, '골프 장갑', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1506, '골프화', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1501, '골프 잡화', 1507, '기타 골프잡화', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1509, '골프 바지', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1510, '골프 상의', 1511, '골프 셔츠');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1510, '골프 상의', 1512, '골프 조끼');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1510, '골프 상의', 1513, '골프 티셔츠');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1514, '골프 점퍼/자켓', 1515, '골프 자켓');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1508, '남성골프의류', 1514, '골프 점퍼/자켓', 1516, '골프 점퍼');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1517, '골프 바지', 0, '');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1519, '골프 상의', 1520, '골프 셔츠');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1519, '골프 상의', 1521, '골프 조끼');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1519, '골프 상의', 1522, '골프 티셔츠');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1523, '골프 점퍼/자켓', 1524, '골프 자켓');
INSERT INTO TMP_CATE VALUES (1500, '골프', 1518, '여성골프의류', 1523, '골프 점퍼/자켓', 1525, '골프 점퍼');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1602, '디지털/사운드', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1603, '생활가전', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1603, '생활가전', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1603, '생활가전', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1601, '가전/테크', 1604, '휴대폰용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1606, '도서/DVD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1607, '문구/취미용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1605, '문구/취미', 1608, '애완/반려', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1610, '그루밍', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1611, '메이크업', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1612, '바디케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1613, '뷰티/관리용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1614, '스킨케어', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1615, '쥬얼리', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1609, '뷰티', 1615, '쥬얼리', 0, '');

-- 이것만 품목-카테고리매핑 정보가 없어 매핑하지 못함. 확인 필요
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1623, '생활용품', 0, '');

INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 1617, '위생용품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1616, '생활/위생', 3406, 'FOOD', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1619, '가구/수납', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1619, '가구/수납', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1619, '가구/수납', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1619, '가구/수납', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1620, '조명/소품', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1621, '침구/페브릭', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1621, '침구/페브릭', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1621, '침구/페브릭', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1621, '침구/페브릭', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1621, '침구/페브릭', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');
INSERT INTO TMP_CATE VALUES (1600, '라이프', 1618, '홈인테리어', 1622, '키친', 0, '');

DELETE FROM TMP_CATE WHERE CATE1_NO = 9000;

COMMIT;

SELECT * FROM TMP_CATE;

TRUNCATE TABLE TB_CATE1;
INSERT INTO TB_CATE1
SELECT CATE1_NO
     , CATE1_NM
     , 'G000_10'  AS SITE_CD
     , 'G032_101' AS CATE_GB
     , 'G031_10'  AS CATE_TYPE
     , 'N'        AS LEAF_YN
     , CATE1_NO   AS DISP_ORD
     , 'G009_10'  AS FORMAL_GB
     , NULL       AS CONTENTS_LOC
     , 'Y'        AS DISP_YN
     , 'Y'        AS USE_YN
     , 1          AS REG_NO
     , NOW()      AS REG_DT
     , 1          AS UPD_NO
     , NOW()      AS UPD_DT
FROM   (
        SELECT DISTINCT
               CATE1_NO
             , CATE1_NM
        FROM   TMP_CATE
        WHERE  CATE1_NO > 0
       ) Z
;

SELECT * FROM TB_CATE1;

TRUNCATE TABLE TB_CATE2;
INSERT INTO TB_CATE2
SELECT CATE2_NO
     , CATE2_NM
     , 'G000_10'  AS SITE_CD
     , 'G032_101' AS CATE_GB
     , CATE1_NO
     , 'G031_10'  AS CATE_TYPE
     , 'N'        AS LEAF_YN
     , CATE2_NO   AS DISP_ORD
     , 'G009_10'  AS FORMAL_GB
     , NULL       AS CONTENTS_LOC
     , 'Y'        AS DISP_YN
     , 'Y'        AS USE_YN
     , 1          AS REG_NO
     , NOW()      AS REG_DT
     , 1          AS UPD_NO
     , NOW()      AS UPD_DT
FROM   (
        SELECT DISTINCT
               CATE1_NO
             , CATE2_NO
             , CATE2_NM
        FROM   TMP_CATE
        WHERE  CATE2_NO > 0
       ) Z
;

SELECT * FROM TB_CATE2;

TRUNCATE TABLE TB_CATE3;
INSERT INTO TB_CATE3
SELECT CATE3_NO
     , CATE3_NM
     , 'G000_10'  AS SITE_CD
     , 'G032_101' AS CATE_GB
     , CATE1_NO
     , CATE2_NO
     , 'G031_10'  AS CATE_TYPE
     , LEAF_YN
     , CATE3_NO   AS DISP_ORD
     , 'G009_10'  AS FORMAL_GB
     , NULL       AS CONTENTS_LOC
     , 'Y'        AS DISP_YN
     , 'Y'        AS USE_YN
     , 1          AS REG_NO
     , NOW()      AS REG_DT
     , 1          AS UPD_NO
     , NOW()      AS UPD_DT
FROM   (
        SELECT DISTINCT
               CATE1_NO
             , CATE2_NO
             , CATE3_NO
             , CATE3_NM
             , CASE WHEN IFNULL((SELECT COUNT(*)
                                 FROM   TMP_CATE
                                 WHERE  CATE3_NO = A.CATE3_NO
                                 AND    CATE4_NO > 0
                                ),0) > 0 THEN 'N'
                    ELSE 'Y'
               END      AS LEAF_YN
        FROM   TMP_CATE A
        WHERE  CATE3_NO > 0
       ) Z
;

SELECT * FROM TB_CATE3;

TRUNCATE TABLE TB_CATE4;
INSERT INTO TB_CATE4
SELECT CATE4_NO
     , CATE4_NM
     , 'G000_10'  AS SITE_CD
     , 'G032_101' AS CATE_GB
     , CATE1_NO
     , CATE2_NO
     , CATE3_NO
     , 'G031_10'  AS CATE_TYPE
     , 'Y'        AS LEAF_YN
     , CATE4_NO   AS DISP_ORD
     , 'G009_10'  AS FORMAL_GB
     , NULL       AS CONTENTS_LOC
     , 'Y'        AS DISP_YN
     , 'Y'        AS USE_YN
     , 1          AS REG_NO
     , NOW()      AS REG_DT
     , 1          AS UPD_NO
     , NOW()      AS UPD_DT
FROM   (
        SELECT DISTINCT
               CATE1_NO
             , CATE2_NO
             , CATE3_NO
             , CATE4_NO
             , CATE4_NM
        FROM   TMP_CATE A
        WHERE  CATE4_NO > 0
       ) Z
;

SELECT * FROM TB_CATE4;

COMMIT;

-- 컨텐츠카테고리 생성
INSERT INTO TB_CATE1
(CATE1_NO,CATE1_NM,SITE_CD,CATE_GB,CATE_TYPE,LEAF_YN,DISP_ORD,FORMAL_GB,CONTENTS_LOC,DISP_YN,USE_YN,REG_NO,REG_DT,UPD_NO,UPD_DT)
VALUES
(1700,'몰메인','G000_10','G032_101','G031_20','N',1700,'G009_10',NULL,'Y','Y',12,NOW(),12,NOW()),
(2100,'브랜드메인','G000_10','G032_102','G031_20','N',2100,'G009_10',NULL,'Y','Y',12,NOW(),12,NOW()),
(3000,'아울렛','G000_10','G032_103','G031_20','N',3000,'G009_20',NULL,'Y','Y',12,NOW(),12,NOW())
;

INSERT INTO TB_CATE2 (CATE2_NO,CATE2_NM,SITE_CD,CATE_GB,CATE1_NO,CATE_TYPE,LEAF_YN,DISP_ORD,FORMAL_GB,CONTENTS_LOC,DISP_YN,USE_YN,REG_NO,REG_DT,UPD_NO,UPD_DT)
VALUES
	 (2001,'신상품','G000_10','G032_101',1100,'G031_20','Y',2001,'G009_10','SCM001','Y','Y',12,NOW(),12,NOW()),
	 (2002,'베스트','G000_10','G032_101',1100,'G031_20','Y',2002,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2003,'신상품','G000_10','G032_101',1200,'G031_20','Y',2003,'G009_10','SCM001','Y','Y',12,NOW(),12,NOW()),
	 (2004,'베스트','G000_10','G032_101',1200,'G031_20','Y',2004,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2005,'신상품','G000_10','G032_101',1300,'G031_20','Y',2005,'G009_10','SCM001','Y','Y',12,NOW(),12,NOW()),
	 (2006,'베스트','G000_10','G032_101',1300,'G031_20','Y',2006,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2007,'신상품','G000_10','G032_101',1500,'G031_20','Y',2007,'G009_10','SCM001','Y','Y',12,NOW(),12,NOW()),
	 (2008,'베스트','G000_10','G032_101',1500,'G031_20','Y',2008,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2009,'신상품','G000_10','G032_101',1600,'G031_20','Y',2009,'G009_10','SCM001','Y','Y',12,NOW(),12,NOW()),
	 (2010,'베스트','G000_10','G032_101',1600,'G031_20','Y',2010,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (1701,'기획전','G000_10','G032_101',1700,'G031_20','Y',1701,'G009_10','SMM002','Y','Y',12,NOW(),12,NOW()),
	 (2001,'신상품','G000_10','G032_101',1100,'G031_20','Y',2001,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2002,'베스트','G000_10','G032_101',1100,'G031_20','Y',2002,'G009_10','SCM003','Y','Y',12,NOW(),12,NOW()),
	 (2003,'신상품','G000_10','G032_101',1200,'G031_20','Y',2003,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2004,'베스트','G000_10','G032_101',1200,'G031_20','Y',2004,'G009_10','SCM003','Y','Y',12,NOW(),12,NOW()),
	 (2005,'신상품','G000_10','G032_101',1300,'G031_20','Y',2005,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2006,'베스트','G000_10','G032_101',1300,'G031_20','Y',2006,'G009_10','SCM003','Y','Y',12,NOW(),12,NOW()),
	 (2007,'신상품','G000_10','G032_101',1500,'G031_20','Y',2007,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2008,'베스트','G000_10','G032_101',1500,'G031_20','Y',2008,'G009_10','SCM003','Y','Y',12,NOW(),12,NOW()),
	 (2009,'신상품','G000_10','G032_101',1600,'G031_20','Y',2009,'G009_10','SCM002','Y','Y',12,NOW(),12,NOW()),
	 (2010,'베스트','G000_10','G032_101',1600,'G031_20','Y',2010,'G009_10','SCM003','Y','Y',12,NOW(),12,NOW()),
	 (1701,'기획전','G000_10','G032_101',1700,'G031_20','Y',1701,'G009_10','SMM002','Y','Y',12,NOW(),12,NOW()),	 
	 (1702,'신상품','G000_10','G032_101',1700,'G031_20','Y',1702,'G009_10','SMM003','Y','Y',12,NOW(),12,NOW()),
	 (1703,'베스트타이틀','G000_10','G032_101',1700,'G031_20','Y',1703,'G009_10','SMM004','Y','Y',12,NOW(),12,NOW()),
	 (1704,'핫딜','G000_10','G032_101',1700,'G031_20','Y',1704,'G009_10','SMM006','Y','Y',12,NOW(),12,NOW()),
	 (1705,'브랜드픽','G000_10','G032_101',1700,'G031_20','Y',1705,'G009_10','SMM007','Y','Y',12,NOW(),12,NOW()),
	 (1706,'MD추천','G000_10','G032_101',1700,'G031_20','Y',1706,'G009_10','SMM009','Y','Y',12,NOW(),12,NOW()),
	 (1707,'추천상품','G000_10','G032_101',1700,'G031_20','Y',1707,'G009_10','SMM010','Y','Y',12,NOW(),12,NOW()),
	 (1708,'TV타이틀','G000_10','G032_101',1700,'G031_20','Y',1708,'G009_10','SMM011','Y','Y',12,NOW(),12,NOW()),
	 (1709,'MD추천(mobile)','G000_10','G032_101',1700,'G031_20','Y',1709,'G009_10','SMM012','Y','Y',12,NOW(),12,NOW()),
	 (2101,'GNB 추천상품','G000_10','G032_102',2100,'G031_20','Y',2101,'G009_10','SBM003','Y','Y',12,NOW(),12,NOW()),
	 (2102,'신상품','G000_10','G032_102',2100,'G031_20','Y',2102,'G009_10','SBM007','Y','Y',12,NOW(),12,NOW()),
	 (2103,'베스트','G000_10','G032_102',2100,'G031_20','Y',2103,'G009_10','SBM008','Y','Y',12,NOW(),12,NOW()),
	 (2104,'MD추천','G000_10','G032_102',2100,'G031_20','Y',2104,'G009_10','SBM009','Y','Y',12,NOW(),12,NOW()),
	 (2105,'브랜드상품','G000_10','G032_102',2100,'G031_20','Y',2105,'G009_10','SBM013','Y','Y',12,NOW(),12,NOW()),
	 (2106,'추천상품1','G000_10','G032_102',2100,'G031_20','Y',2106,'G009_10','SBM017','Y','Y',12,NOW(),12,NOW()),
	 (2107,'추천상품2','G000_10','G032_102',2100,'G031_20','Y',2107,'G009_10','SBM018','Y','Y',12,NOW(),12,NOW()),
	 (2108,'추천상품3','G000_10','G032_102',2100,'G031_20','Y',2108,'G009_10','SBM019','Y','Y',12,NOW(),12,NOW()),
	 (2111,'GNB 추천상품(M)','G000_10','G032_102',2100,'G031_20','Y',2111,'G009_10','SBMM003','Y','Y',12,NOW(),12,NOW()),
	 (2112,'신상품(M)','G000_10','G032_102',2100,'G031_20','Y',2112,'G009_10','SBMM007','Y','Y',12,NOW(),12,NOW()),
	 (2113,'베스트(M)','G000_10','G032_102',2100,'G031_20','Y',2113,'G009_10','SBMM008','Y','Y',12,NOW(),12,NOW()),
	 (2114,'MD추천(M)','G000_10','G032_102',2100,'G031_20','Y',2114,'G009_10','SBMM009','Y','Y',12,NOW(),12,NOW()),
	 (2115,'브랜드상품(M)','G000_10','G032_102',2100,'G031_20','Y',2115,'G009_10','SBMM013','Y','Y',12,NOW(),12,NOW()),
	 (2116,'추천상품1(M)','G000_10','G032_102',2100,'G031_20','Y',2116,'G009_10','SBMM017','Y','Y',12,NOW(),12,NOW()),
	 (2117,'추천상품2(M)','G000_10','G032_102',2100,'G031_20','Y',2117,'G009_10','SBMM018','Y','Y',12,NOW(),12,NOW()),
	 (2118,'추천상품3(M)','G000_10','G032_102',2100,'G031_20','Y',2118,'G009_10','SBMM019','Y','Y',12,NOW(),12,NOW()),
	 (3010,'MD추천','G000_10','G032_103',3000,'G031_20','Y',3010,'G009_20','SOM002','Y','Y',12,NOW(),12,NOW()),
	 (3020,'베스트','G000_10','G032_103',3000,'G031_20','Y',3020,'G009_20','SOM003','Y','Y',12,NOW(),12,NOW())
;

-- CATE_4SRCH 생성
TRUNCATE TABLE TB_CATE_4SRCH;

INSERT INTO TB_CATE_4SRCH
SELECT *
FROM   VW_CATE_4SRCH
;

SELECT * FROM TB_CATE_4SRCH;

--시퀀스맞춰주기
SELECT MAX(CATE_NO)
FROM (
    SELECT MAX(CATE1_NO) AS CATE_NO FROM TB_CATE1
UNION SELECT MAX(CATE2_NO) AS CATE_NO FROM TB_CATE2
UNION SELECT MAX(CATE3_NO) AS CATE_NO FROM TB_CATE3
UNION SELECT MAX(CATE4_NO) AS CATE_NO FROM TB_CATE4
UNION SELECT MAX(CATE5_NO) AS CATE_NO FROM TB_CATE5
) X
;

INSERT INTO tb_sequence VALUES ('SEQ_CATE',3021);