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);