-- DROP ALL TABLES AND ALL SEQUENCES!
/*
BEGIN
  --Bye Sequences!
  FOR i IN (SELECT us.sequence_name FROM USER_SEQUENCES us WHERE sequence_name LIKE 'ECMS_%') LOOP
    EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||'';
  END LOOP;
  --Bye Tables!
  FOR i IN (SELECT ut.table_name FROM USER_TABLES ut WHERE table_name LIKE 'ECMS_%') LOOP
    EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS ';
  END LOOP;
END;
*/
﻿-- DDL

CREATE TABLE ECMS_ARCHIVE (
  ARC_ID NUMBER NOT NULL,
  ARC_CUSTOM_TYPE VARCHAR2(45) NOT NULL,
  MEM_ID VARCHAR2(50) DEFAULT NULL,
  ARC_TITLE VARCHAR2(200 CHAR) NOT NULL,
  ARC_SLUG VARCHAR2(100 CHAR) NOT NULL,
  ARC_TEMPLATE VARCHAR2(100) DEFAULT NULL,
  ARC_CONTENT_HTML CLOB,
  ARC_PLAIN_TEXT CLOB,
  ARC_EXCERPT VARCHAR2(300 CHAR) DEFAULT NULL,
  ARC_CREATED DATE NOT NULL,
  ARC_LAST_UPDATED DATE NOT NULL,
  THUMB_FILE_ID NUMBER DEFAULT NULL,
  ARC_STATUS VARCHAR2(10) DEFAULT NULL,
  ARC_HIT NUMBER DEFAULT NULL,
  ARC_RECOMMEND NUMBER DEFAULT NULL,
  ARC_SUPPORT_COMMENT NUMBER DEFAULT '1',
  ARC_COMMENT_TOTAL NUMBER DEFAULT NULL,
  ARC_META_CODE_1 VARCHAR2(20) DEFAULT NULL,
  ARC_META_CODE_2 VARCHAR2(20) DEFAULT NULL,
  ARC_META_CODE_3 VARCHAR2(20) DEFAULT NULL,
  ARC_SUB_TEXT CLOB,	--자막등 부가텍스트
  PRIMARY KEY (ARC_ID)
) ;

CREATE TABLE ECMS_ARCHIVE_CATEGORY (
  CAT_ID NUMBER NOT NULL,
  CAT_NAME VARCHAR2(100 CHAR) NOT NULL,
  CAT_SLUG VARCHAR2(100 CHAR) NOT NULL UNIQUE,
  CAT_TEMPLATE VARCHAR2(100) DEFAULT NULL,
  CAT_VIEW_TEMPLATE VARCHAR2(100) DEFAULT NULL,	--싱글뷰파일 템플릿
  CAT_ADMIN_LIST_SKIN VARCHAR2(100) DEFAULT NULL,	--관리자 목록 스킨
  CAT_ADMIN_FORM_SKIN VARCHAR2(100) DEFAULT NULL,	--관리자 폼 스킨  
  CAT_CUSTOM_TYPE VARCHAR2(45) DEFAULT NULL,	--
  CAT_PAGE_SIZE NUMBER DEFAULT NULL,
  CAT_META_CODE_1 VARCHAR2(20) DEFAULT NULL,
  CAT_META_CODE_2 VARCHAR2(20) DEFAULT NULL,
  CAT_META_CODE_3 VARCHAR2(20) DEFAULT NULL,
  CAT_SORT_ORDER VARCHAR2(20) DEFAULT NULL,	--기본정렬필드
  CAT_SORT_DIRECTION VARCHAR2(20) DEFAULT NULL,	--기본 정렬 방향
  CAT_FORCE_NAME VARCHAR2(50) DEFAULT NULL,	--작성자 표시 강제변경
  PRIMARY KEY (CAT_ID)
) ;

CREATE TABLE ECMS_ARCHIVE_CATEGORY_REL (
  ARC_ID NUMBER NOT NULL,
  CAT_ID NUMBER NOT NULL,
  PRIMARY KEY (ARC_ID,CAT_ID),
  CONSTRAINT ECMS_ARC_CAT_REL_FK1 FOREIGN KEY (ARC_ID) REFERENCES ECMS_ARCHIVE (ARC_ID) ON DELETE CASCADE,
  CONSTRAINT ECMS_ARC_CAT_REL_FK2 FOREIGN KEY (CAT_ID) REFERENCES ECMS_ARCHIVE_CATEGORY (CAT_ID) ON DELETE CASCADE
) ;
CREATE INDEX ECMS_ARC_CAT_REL_IDX1 ON ECMS_ARCHIVE_CATEGORY_REL(ARC_ID);
CREATE INDEX ECMS_ARC_CAT_REL_IDX2 ON ECMS_ARCHIVE_CATEGORY_REL(CAT_ID);

CREATE TABLE ECMS_ARCHIVE_TAG (
  TAG_ID NUMBER NOT NULL,
  TAG_NAME VARCHAR2(100 CHAR) NOT NULL,
  TAG_SLUG VARCHAR2(100 CHAR) NOT NULL UNIQUE,
  PRIMARY KEY (TAG_ID)
) ;

CREATE TABLE ECMS_ARCHIVE_TAG_REL (
  ARC_ID NUMBER NOT NULL,
  TAG_ID NUMBER NOT NULL,
  PRIMARY KEY (ARC_ID,TAG_ID),
  CONSTRAINT ECMS_ARC_TAG_REL_FK1 FOREIGN KEY (ARC_ID) REFERENCES ECMS_ARCHIVE (ARC_ID) ON DELETE CASCADE ,
  CONSTRAINT ECMS_ARC_TAG_REL_FK2 FOREIGN KEY (TAG_ID) REFERENCES ECMS_ARCHIVE_TAG (TAG_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_ARC_TAG_REL_IDX1 ON ECMS_ARCHIVE_TAG_REL(ARC_ID);
CREATE INDEX ECMS_ARC_TAG_REL_IDX2 ON ECMS_ARCHIVE_TAG_REL(TAG_ID);

CREATE TABLE ECMS_ARCHIVE_MEDIA_REL (
  ARC_ID NUMBER NOT NULL,
  FILE_ID NUMBER NOT NULL,
  PRIMARY KEY (ARC_ID,FILE_ID),
  CONSTRAINT ECMS_ARC_MEDIA_REL_FK1 FOREIGN KEY (ARC_ID) REFERENCES ECMS_ARCHIVE (ARC_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_ARC_MEDIA_REL_IDX1 ON ECMS_ARCHIVE_MEDIA_REL(ARC_ID);
CREATE INDEX ECMS_ARC_MEDIA_REL_IDX2 ON ECMS_ARCHIVE_MEDIA_REL(FILE_ID);

CREATE TABLE ECMS_BANNER (
  BN_ID NUMBER NOT NULL,
  BN_TYPE VARCHAR2(20) DEFAULT NULL,
  BN_ORDER NUMBER DEFAULT NULL,
  BN_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BN_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  BN_LINK VARCHAR2(1000 CHAR) DEFAULT NULL,
  BN_NEW_WIN NUMBER DEFAULT NULL,
  BN_START_DATE VARCHAR2(20) DEFAULT NULL,
  BN_END_DATE VARCHAR2(20) DEFAULT NULL,
  BN_REGDATE DATE DEFAULT NULL,
  BN_USE NUMBER DEFAULT NULL,
  BN_EXT VARCHAR2(10) DEFAULT NULL,
  BN_WIDTH NUMBER DEFAULT NULL,
  BN_HEIGHT NUMBER DEFAULT NULL,
  BN_POSITION VARCHAR2(100) DEFAULT NULL,
  PRIMARY KEY (BN_ID)
) ;

CREATE TABLE ECMS_BOARD_CONFIG (
  BC_ID VARCHAR2(100) NOT NULL,
  BC_STATUS VARCHAR2(20) DEFAULT NULL,
  BC_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BC_TYPE VARCHAR2(20) DEFAULT NULL,
  BC_CATEGORY1 VARCHAR2(20) DEFAULT NULL,
  BC_CATEGORY1_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BC_CATEGORY2 VARCHAR2(20) DEFAULT NULL,
  BC_CATEGORY2_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BC_CATEGORY3 VARCHAR2(20) DEFAULT NULL,
  BC_CATEGORY3_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BC_STATUS_CAT_ID VARCHAR2(20) DEFAULT NULL,
  BC_LIST_FILE VARCHAR2(500) DEFAULT NULL,
  BC_VIEW_FILE VARCHAR2(500) DEFAULT NULL,
  BC_FORM_FILE VARCHAR2(500) DEFAULT NULL,
  BC_MODERATOR_CAP VARCHAR2(100) DEFAULT NULL,
  BC_GROUP VARCHAR2(100) DEFAULT NULL,
  BC_ALLOW_MEMBER_LIST NUMBER DEFAULT '1',
  BC_ALLOW_MEMBER_VIEW NUMBER DEFAULT '1',
  BC_ALLOW_MEMBER_FORM NUMBER DEFAULT '1',
  BC_ALLOW_MEMBER_COMMENT NUMBER DEFAULT '1',
  BC_ALLOW_MEMBER_DOWNLOAD NUMBER DEFAULT '1',
  BC_ALLOW_GUEST_LIST NUMBER DEFAULT '1',
  BC_ALLOW_GUEST_VIEW NUMBER DEFAULT '1',
  BC_ALLOW_GUEST_FORM NUMBER DEFAULT '1',
  BC_ALLOW_GUEST_COMMENT NUMBER DEFAULT '1',
  BC_ALLOW_GUEST_DOWNLOAD NUMBER DEFAULT '1',
  BC_SUPPORT_NOTICE NUMBER DEFAULT '1',
  BC_NOTICE_EVERY_PAGE NUMBER DEFAULT '0',
  BC_SUPPORT_SECRET NUMBER DEFAULT '1',
  BC_SUPPORT_COMMENT NUMBER DEFAULT '1',
  BC_SUPPORT_THUMBNAIL NUMBER DEFAULT '1',
  BC_SUPPORT_RECOMMEND NUMBER DEFAULT '0',
  BC_THUMBNAIL_CROP NUMBER DEFAULT '0',
  BC_THUMBNAIL_WIDTH NUMBER DEFAULT '200',
  BC_THUMBNAIL_HEIGHT NUMBER DEFAULT '150',
  BC_UPLOAD_FILE_NUM NUMBER DEFAULT '5',
  BC_UPLOAD_SIZE_MAX NUMBER DEFAULT '10',
  BC_REGDATE DATE DEFAULT NULL,
  BC_PAGE_SIZE NUMBER DEFAULT '10',
  PRIMARY KEY (BC_ID)
) ;

CREATE TABLE ECMS_BOARD_ARTICLE (
  BA_ID NUMBER NOT NULL,
  BC_ID VARCHAR2(100) NOT NULL,
  BA_CATEGORY1 VARCHAR2(20) DEFAULT NULL,
  BA_CATEGORY2 VARCHAR2(20) DEFAULT NULL,
  BA_CATEGORY3 VARCHAR2(20) DEFAULT NULL,
  BA_TITLE VARCHAR2(1000 CHAR) DEFAULT NULL,
  BA_CONTENT_HTML CLOB,
  BA_CONTENT_PLAIN VARCHAR2(1500 CHAR) DEFAULT NULL,
  BA_ANSWER CLOB,
  BA_NOTICE NUMBER DEFAULT NULL,
  BA_NOTICE_STARTDATE VARCHAR2(20) DEFAULT NULL,
  BA_NOTICE_ENDDATE VARCHAR2(20) DEFAULT NULL,
  MEM_ID VARCHAR2(50) DEFAULT NULL,
  BA_GUEST_NAME VARCHAR2(200) DEFAULT NULL,
  BA_EMAIL VARCHAR2(200) DEFAULT NULL,
  BA_GUEST_PASSWORD VARCHAR2(200) DEFAULT NULL,
  BA_SECRET NUMBER DEFAULT NULL,
  BA_SECRET_PASSWORD VARCHAR2(200) DEFAULT NULL,
  BA_REGDATE DATE DEFAULT NULL,
  BA_STATUS VARCHAR2(20) DEFAULT NULL,
  BA_UPDATER_ID VARCHAR2(50) DEFAULT NULL,
  BA_LAST_MODIFIED DATE DEFAULT NULL,
  BA_HIT NUMBER DEFAULT NULL,
  BA_IP VARCHAR2(20) DEFAULT NULL,
  BA_COMMENT_TOTAL NUMBER DEFAULT '0',
  BA_RECOMMEND NUMBER DEFAULT '0',
  PRIMARY KEY (BA_ID),
  CONSTRAINT ECMS_BOARD_ARTICLE_FK1 FOREIGN KEY (BC_ID) REFERENCES ECMS_BOARD_CONFIG (BC_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_BOARD_ARTICLE_IDX1 ON ECMS_BOARD_ARTICLE(BC_ID);

CREATE TABLE ECMS_BULK_MAIL (
  BM_ID NUMBER NOT NULL,
  BM_MEMBER_ID VARCHAR2(100) NOT NULL,
  BM_FROM_ADDRESS VARCHAR2(200) NOT NULL,
  BM_FROM_NAME VARCHAR2(100) DEFAULT NULL,
  BM_SUBJECT VARCHAR2(500 CHAR) NOT NULL,
  BM_CONTENT CLOB NOT NULL,
  BM_CONTENT_TYPE VARCHAR2(10) NOT NULL,
  BM_ATTACHMENT_FILE_NAME VARCHAR2(500) DEFAULT NULL,
  BM_ATTACHMENT_FILE_SIZE NUMBER DEFAULT NULL,
  BM_STATUS VARCHAR2(10) NOT NULL,
  BM_SEND_TYPE VARCHAR2(20) NOT NULL,
  BM_SEND_DATE VARCHAR2(20) DEFAULT NULL,
  BM_SCHEDULED_DATE VARCHAR2(10) DEFAULT NULL,
  BM_SCHEDULED_HOUR VARCHAR2(10) DEFAULT NULL,
  BM_SCHEDULED_MIN VARCHAR2(10) DEFAULT NULL,
  BM_REG_DATE DATE NOT NULL,
  BM_SEND_TO_ALL NUMBER DEFAULT '0',
  BM_SEND_TO_ALL_TOTAL NUMBER DEFAULT '0',
  PRIMARY KEY (BM_ID)
) ;

CREATE TABLE ECMS_BULK_MAIL_TO (
  BMT_ID NUMBER NOT NULL,
  BM_ID NUMBER NOT NULL,
  BMT_ADDRESS VARCHAR2(200) NOT NULL,
  BMT_SERVICE VARCHAR2(100) NOT NULL,
  BMT_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  BMT_SENDED NUMBER NOT NULL,
  BMT_SEND_DATE VARCHAR2(20) DEFAULT NULL,
  PRIMARY KEY (BMT_ID),
  CONSTRAINT ECMS_BULK_MAIL_TO_FK1 FOREIGN KEY (BM_ID) REFERENCES ECMS_BULK_MAIL (BM_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_BULK_MAIL_TO_IDX1 ON ECMS_BULK_MAIL_TO(BM_ID);

CREATE TABLE ECMS_CAPABILITY (
  CAP_ID VARCHAR2(100) NOT NULL,
  CAP_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  CAP_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  CAP_VALUE VARCHAR2(255) DEFAULT NULL,
  CAP_PARAM1_KEY VARCHAR2(50) DEFAULT NULL,
  CAP_PARAM1_VALUE VARCHAR2(255) DEFAULT NULL,
  CAP_PARAM2_KEY VARCHAR2(50) DEFAULT NULL,
  CAP_PARAM2_VALUE VARCHAR2(255) DEFAULT NULL,
  CAP_HTTP_METHOD VARCHAR2(10) DEFAULT NULL,
  CAP_REGDATE DATE DEFAULT NULL,
  CAP_DEFAULT NUMBER DEFAULT 0,
  CAP_PRIORITY NUMBER DEFAULT NULL,
  CAP_HIDDEN NUMBER DEFAULT NULL,
  PRIMARY KEY (CAP_ID)
) ;

CREATE TABLE ECMS_CLEAN (
  CL_IDX NUMBER NOT NULL,
  CL_NAME VARCHAR2(200) NOT NULL,
  CL_MOBILE_1 VARCHAR2(100) NOT NULL,
  CL_MOBILE_2 VARCHAR2(100) NOT NULL,
  CL_MOBILE_3 VARCHAR2(100) NOT NULL,
  CL_EMAIL VARCHAR2(200) NOT NULL,
  CL_TITLE VARCHAR2(500) NOT NULL,
  CL_CONTENT CLOB NOT NULL,
  CL_CREATED DATE NOT NULL,
  CL_DUPINFO VARCHAR2(100) DEFAULT NULL,
  CL_ANSWER_1 VARCHAR2(4000) DEFAULT NULL,
  CL_ANSWER_1_DATE VARCHAR2(20) DEFAULT NULL,
  CL_ANSWER_2 VARCHAR2(4000) DEFAULT NULL,
  CL_ANSWER_2_DATE VARCHAR2(20) DEFAULT NULL,
  CL_ANSWER_3 VARCHAR2(4000) DEFAULT NULL,
  CL_ANSWER_3_DATE VARCHAR2(20) DEFAULT NULL,
  CL_ANSWER_4 VARCHAR2(4000) DEFAULT NULL,
  CL_ANSWER_4_DATE VARCHAR2(20) DEFAULT NULL,
  CL_ANSWER_5 VARCHAR2(4000) DEFAULT NULL,
  CL_ANSWER_5_DATE VARCHAR2(20) DEFAULT NULL,
  PRIMARY KEY (CL_IDX)
) ;
CREATE INDEX ECMS_CLEAN_IDX1 ON ECMS_CLEAN(CL_IDX);


CREATE TABLE ECMS_CODE (
  CODE_ID VARCHAR2(10) DEFAULT '',
  CAT_ID VARCHAR2(10) DEFAULT '',
  CODE_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  CODE_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  CODE_REGDATE DATE DEFAULT NULL,
  CODE_USE NUMBER DEFAULT '1',
  CODE_NAME_EN VARCHAR2(100) DEFAULT '',
  PRIMARY KEY (CODE_ID,CAT_ID)
) ;

CREATE TABLE ECMS_CODE_CATEGORY (
  CAT_ID VARCHAR2(10) DEFAULT '',
  CAT_NAME VARCHAR2(50 CHAR) DEFAULT NULL,
  CAT_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  CAT_REGDATE DATE DEFAULT SYSDATE,
  CAT_NAME_EN VARCHAR2(100) DEFAULT '',
  PRIMARY KEY (CAT_ID)
) ;

CREATE TABLE ECMS_COMMENT (
  CM_ID NUMBER NOT NULL,
  MENU_ID VARCHAR2(100) DEFAULT NULL,
  CM_BY VARCHAR2(50) DEFAULT NULL,
  CM_MODULE VARCHAR2(100) DEFAULT NULL,
  CM_MODULE_ID VARCHAR2(100) DEFAULT NULL,
  CM_MODULE_SUB VARCHAR2(100) DEFAULT NULL,
  CM_MODULE_SUB_ID VARCHAR2(100) DEFAULT NULL,
  MEM_ID VARCHAR2(100) DEFAULT NULL,
  CM_PARENT NUMBER DEFAULT NULL,
  CM_ORDER NUMBER DEFAULT NULL,
  CM_TITLE VARCHAR2(200 CHAR) DEFAULT NULL,
  CM_CONTENT VARCHAR2(1000 CHAR) DEFAULT NULL,
  CM_RATING NUMBER DEFAULT NULL,
  CM_PAGE_URL VARCHAR2(1000 CHAR) DEFAULT NULL,
  CM_SNS_USER_ID VARCHAR2(100) DEFAULT NULL,
  CM_SNS_USER_NAME VARCHAR2(100) DEFAULT NULL,
  CM_SNS_USER_HOME VARCHAR2(200) DEFAULT NULL,
  CM_SNS_ITEM_ID VARCHAR2(100) DEFAULT NULL,
  CM_PROFILE_IMAGE VARCHAR2(500) DEFAULT NULL,
  CM_AGREE NUMBER DEFAULT NULL,
  CM_DISAGREE NUMBER DEFAULT NULL,
  CM_RECOMMEND NUMBER DEFAULT NULL,
  CM_STATUS VARCHAR2(10) DEFAULT NULL,
  CM_MODERATE_CODE VARCHAR2(20) DEFAULT NULL,
  CM_MODERATE_ETC VARCHAR2(20) DEFAULT NULL,
  CM_REG_IP VARCHAR2(20) DEFAULT NULL,
  CM_REGDATE DATE DEFAULT NULL,
  CM_REPORT NUMBER DEFAULT NULL,
  CM_GUEST_PASSWORD  VARCHAR2(200) DEFAULT NULL,
  PRIMARY KEY (CM_ID)
) ;

CREATE TABLE ECMS_CONFIG_OPTION (
  CONF_ID VARCHAR2(20) NOT NULL,
  OPT_KEY VARCHAR2(100) NOT NULL,
  OPT_VALUE VARCHAR2(1000) DEFAULT NULL,
  OPT_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  OPT_TYPE VARCHAR2(20) DEFAULT NULL,
  OPT_HIDDEN NUMBER DEFAULT '0',
  OPT_UNIT_TEXT VARCHAR2(20 CHAR) DEFAULT NULL,
  OPT_HELP VARCHAR2(500 CHAR) DEFAULT NULL,
  PRIMARY KEY (CONF_ID,OPT_KEY)
) ;

CREATE TABLE ECMS_CONTENT (
  MENU_ID VARCHAR2(50) DEFAULT NULL,
  CONTENT CLOB DEFAULT NULL,
  CONTENT_PLAIN VARCHAR2(1500 CHAR) DEFAULT NULL,
  CONTENT_STATUS VARCHAR2(20) DEFAULT NULL,
  CONTENT_VER NUMBER DEFAULT NULL,
  CONTENT_REGDATE DATE DEFAULT NULL,
  CONTENT_LAST_MODIFIED DATE DEFAULT NULL,
  CONTENT_LAST_WORKER VARCHAR2(20) DEFAULT NULL,
  CONTENT_MEMO VARCHAR2(1000 CHAR) DEFAULT NULL,
  CONSTRAINT ECMS_CONTENT_ECMS_MENU_FK1 FOREIGN KEY (MENU_ID) REFERENCES ECMS_MENU (MENU_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_CONTENT_IDX1 ON ECMS_CONTENT(MENU_ID);

CREATE TABLE ECMS_FEED_CONFIG (
  FEED_CONFIG_ID NUMBER NOT NULL,
  FEED_URI_NAME VARCHAR2(100 CHAR) NOT NULL UNIQUE,
  FEED_TYPE VARCHAR2(20) DEFAULT NULL,
  FEED_VERSION VARCHAR2(20) DEFAULT NULL,
  FEED_CHANNEL_TITLE VARCHAR2(500 CHAR) NOT NULL,
  FEED_CHANNEL_LINK VARCHAR2(1000 CHAR) DEFAULT NULL,
  FEED_CHANNEL_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  FEED_CHANNEL_COPYRIGHT VARCHAR2(200 CHAR) DEFAULT NULL,
  FEED_TABLE VARCHAR2(100) DEFAULT NULL,
  FEED_PK_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_MODULE_ID_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_MODULE_SUB_ID_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_TITLE_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_LINK_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_DESCRIPTION_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_PUB_DATE_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_AUTHOR_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_GUID_COLUMN VARCHAR2(50) DEFAULT NULL,
  FEED_PAGE_SIZE NUMBER DEFAULT '20',
  FEED_DESCRIPTION_LENGTH NUMBER DEFAULT '200',
  FEED_MODULE VARCHAR2(50) DEFAULT NULL,
  FEED_MODULE_ID VARCHAR2(50) DEFAULT NULL,
  FEED_MODULE_SUB VARCHAR2(50) DEFAULT NULL,
  FEED_MODULE_SUB_ID VARCHAR2(50) DEFAULT NULL,
  FEED_CONFIG_REGDATE DATE DEFAULT NULL,
  FEED_EXTRA_CONDITION VARCHAR2(1000 CHAR) DEFAULT NULL,
  PRIMARY KEY (FEED_CONFIG_ID)
) ;

CREATE TABLE ECMS_FILEINFO (
  FILE_ID NUMBER NOT NULL,	--파일 아이디
  MEMBER_ID VARCHAR2(50) DEFAULT NULL,	--등록회원 아이디
  FILE_MODULE VARCHAR2(50) DEFAULT NULL,	--사용모듈
  FILE_MODULE_ID VARCHAR2(20) DEFAULT NULL,	--	사용모듈 아이디
  FILE_MODULE_SUB VARCHAR2(50) DEFAULT NULL,	--사용모듈 서브
  FILE_MODULE_SUB_ID VARCHAR2(50) DEFAULT NULL,	--사용모듈 서브 아이디
  FILE_ORIGINAL_NAME VARCHAR2(500 CHAR) DEFAULT NULL,	--원본파일명
  FILE_PATH VARCHAR2(1000) DEFAULT NULL,	--파일저장경로
  FILE_THUMBNAIL_PATH VARCHAR2(200) DEFAULT NULL,	--	썸네일 저장경로
  FILE_EXT VARCHAR2(10) DEFAULT NULL,	--	파일확장자
  FILE_MIME_TYPE VARCHAR2(200) DEFAULT NULL,	--MIMI타입
  FILE_MEDIA_TYPE VARCHAR2(10) DEFAULT NULL,	--	미디어 종류
  FILE_SIZE NUMBER DEFAULT NULL,	--파일크기
  FILE_REGDATE DATE DEFAULT NULL,	--등록일시
  FILE_ALT_TEXT VARCHAR2(500 CHAR) DEFAULT NULL,	--대체텍스트
  FILE_DOWNLOAD_COUNT NUMBER DEFAULT '0',	--다운로드회수
  FILE_UUID VARCHAR2(100 CHAR) DEFAULT NULL,	--파일UID
  FILE_ORI_IMAGE_WIDTH NUMBER DEFAULT NULL,		--이미지가로길이
  FILE_ORI_IMAGE_HEIGHT NUMBER DEFAULT NULL,		--이미지세로길이
  PRIMARY KEY (FILE_ID)
) ;

CREATE TABLE ECMS_MEMBER (
  MEM_ID VARCHAR2(50) NOT NULL,
  MEM_PASSWORD VARCHAR2(200) NOT NULL,
  MEM_LAST_NAME VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_FIRST_NAME VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_NAME VARCHAR2(500 CHAR) DEFAULT NULL,
  MEM_ACTIVE NUMBER DEFAULT '1',
  MEM_EMAIL VARCHAR2(500) DEFAULT NULL,
  MEM_REGDATE DATE DEFAULT NULL,
  MEM_ROLE VARCHAR2(50) DEFAULT NULL,
  MEM_TEL1 VARCHAR2(50) DEFAULT NULL,
  MEM_TEL2 VARCHAR2(50) DEFAULT NULL,
  MEM_TEL3 VARCHAR2(50) DEFAULT NULL,
  MEM_MOBILE1 VARCHAR2(50) DEFAULT NULL,
  MEM_MOBILE2 VARCHAR2(50) DEFAULT NULL,
  MEM_MOBILE3 VARCHAR2(50) DEFAULT NULL,
  MEM_DUP_INFO VARCHAR2(200) DEFAULT NULL,
  MEM_MAILING NUMBER DEFAULT NULL,
  MEM_SMS NUMBER DEFAULT NULL ,
  MEM_LEVEL VARCHAR2(20) DEFAULT NULL,
  MEM_SIGN_UP_KEY VARCHAR2(100) DEFAULT NULL,
  MEM_SIGN_UP_KEY_CHECKED NUMBER DEFAULT '0',
  MEM_LAST_LOGIN_DATE DATE DEFAULT NULL,
  MEM_TEL VARCHAR2(100) DEFAULT NULL,
  MEM_MOBILE VARCHAR2(100) DEFAULT NULL,
  MEM_GENDER VARCHAR2(10) DEFAULT NULL,
  MEM_BIRTHDAY VARCHAR2(10) DEFAULT NULL,
  MEM_BIRTHDAY_SOLAR NUMBER DEFAULT NULL,	--양력 음력
  MEM_ORGANIZATION VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_DEPARTMENT VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_POSITION VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_FAX VARCHAR2(20) DEFAULT NULL,
  MEM_ADDRESS VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_ADDRESS_SUB VARCHAR2(200 CHAR) DEFAULT NULL,
  MEM_CITY_AREA VARCHAR2(10 CHAR) DEFAULT NULL,	--구
  MEM_CITY_STATE VARCHAR2(100 CHAR) DEFAULT NULL,
  MEM_COUNTRY VARCHAR2(10) DEFAULT NULL,
  MEM_ZIP_CODE VARCHAR2(100) DEFAULT NULL,
  MEM_SNS VARCHAR2(20) DEFAULT NULL,
  MEM_SNS_ID VARCHAR2(100) DEFAULT NULL,
  MEM_SNS_HOME VARCHAR2(500) DEFAULT NULL,
  TERM_CHECK_DATE DATE DEFAULT NULL,
  TERM_CHECK_EMAIL_SENDED NUMBER NULL,
  MEM_PW_LAST_UPDATED DATE DEFAULT NULL,
  PRIMARY KEY (MEM_ID)
) ;

CREATE TABLE ECMS_GROUP (
  GROUP_ID VARCHAR2(50) DEFAULT '',
  GROUP_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  GROUP_PARENT VARCHAR2(50) DEFAULT NULL,
  GROUP_REGDATE DATE DEFAULT NULL,
  GROUP_ORDER NUMBER DEFAULT NULL,
  GROUP_DEPTH NUMBER DEFAULT NULL,
  PRIMARY KEY (GROUP_ID)
) ;

CREATE TABLE ECMS_GROUP_MEMBER (
  GROUP_ID VARCHAR2(50) NOT NULL,
  MEM_ID VARCHAR2(50) NOT NULL,
  PRIMARY KEY (MEM_ID,GROUP_ID),
  CONSTRAINT ECMS_GROUP_MEMBER_FK1 FOREIGN KEY (MEM_ID) REFERENCES ECMS_MEMBER (MEM_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_GROUP_MEMBER_IDX1 ON ECMS_GROUP_MEMBER(MEM_ID);

CREATE TABLE ECMS_MAIL_TRACK (
  MT_IDX NUMBER NOT NULL,
  MT_EMAIL VARCHAR2(100) NOT NULL,
  MT_SUBJECT VARCHAR2(200 CHAR) NOT NULL,
  MT_SEND_DATE DATE NOT NULL,
  MT_OPENED NUMBER DEFAULT 0,
  PRIMARY KEY (MT_IDX)
) ;
CREATE INDEX ECMS_MAIL_TRACK_IDX1 ON ECMS_MAIL_TRACK(MT_EMAIL);

CREATE TABLE ECMS_MEMBER_DELETE (
  MEM_DELETE_ID NUMBER NOT NULL,
  MEM_ID VARCHAR2(100) DEFAULT NULL,
  MEM_DELETED_BY VARCHAR2(100) DEFAULT NULL,
  MEM_REGDATE DATE DEFAULT NULL,
  MEM_DELETE_DATE DATE DEFAULT NULL,
  PRIMARY KEY (MEM_DELETE_ID)
) ;

CREATE TABLE ECMS_MENU (
  MENU_ID VARCHAR2(100) NOT NULL,
  MENU_NAME VARCHAR2(200 CHAR) DEFAULT NULL,
  MENU_TYPE VARCHAR2(20) DEFAULT NULL,
  MENU_GNB_TYPE VARCHAR2(20) DEFAULT NULL,
  MENU_GNB_EXT_ON VARCHAR2(20) DEFAULT NULL,
  MENU_GNB_EXT_OFF VARCHAR2(20) DEFAULT NULL,
  MENU_SNB_TYPE VARCHAR2(100) DEFAULT NULL,
  MENU_SNB_EXT_ON VARCHAR2(20) DEFAULT NULL,
  MENU_SNB_EXT_OFF VARCHAR2(20) DEFAULT NULL,
  MENU_TITLE_TYPE VARCHAR2(20) DEFAULT NULL,
  MENU_TITLE_EXT VARCHAR2(20) DEFAULT NULL,
  MENU_TITLE_SUB_TEXT VARCHAR2(200 CHAR) DEFAULT NULL,
  MENU_LINK VARCHAR2(1000 CHAR) DEFAULT NULL,
  MENU_NEW_WIN NUMBER DEFAULT NULL,
  MENU_PARENT VARCHAR2(100) DEFAULT NULL,
  MENU_DEPTH NUMBER DEFAULT NULL,
  MENU_ORDER NUMBER DEFAULT NULL,
  MENU_HEADER VARCHAR2(1000) DEFAULT NULL,
  MENU_TEMPLATE VARCHAR2(1000) DEFAULT NULL,
  MENU_FOOTER VARCHAR2(1000) DEFAULT NULL,
  MENU_STATUS VARCHAR2(20) DEFAULT NULL,
  MENU_MANAGER VARCHAR2(100 CHAR) DEFAULT NULL,
  MENU_DEPARTMENT VARCHAR2(100 CHAR) DEFAULT NULL,
  MENU_PHONE VARCHAR2(100 CHAR) DEFAULT NULL,
  MENU_EMAIL VARCHAR2(200) DEFAULT NULL,
  MENU_ETC VARCHAR2(1000 CHAR) DEFAULT NULL,
  MENU_REGDATE DATE DEFAULT NULL,
  MENU_USE_SATISFACTION NUMBER DEFAULT 1,
  MENU_LAST_MODIFIED DATE DEFAULT NULL,
  PRIMARY KEY (MENU_ID)
) ;
CREATE INDEX ECMS_MENU_IDX1 ON ECMS_MENU(MENU_PARENT);

CREATE TABLE ECMS_ORG_DEPARTMENT (
  DEP_IDX NUMBER NOT NULL,
  DEP_ORDER NUMBER DEFAULT 0,
  DEP_NAME VARCHAR2(500 CHAR) NOT NULL,
  DEP_TEL VARCHAR2(500 CHAR) NOT NULL,
  DEP_DESCRIPTION VARCHAR2(1000 CHAR) NOT NULL,
  DEP_REMARK VARCHAR2(1000 CHAR) NOT NULL,
  PRIMARY KEY (DEP_IDX)
) ;

CREATE TABLE ECMS_ORG_STAFF (
  ST_IDX NUMBER NOT NULL,
  ST_DEP_IDX NUMBER NOT NULL,
  ST_ORDER NUMBER DEFAULT 0,
  ST_RANK_CODE VARCHAR2(100 CHAR) NOT NULL,
  ST_NAME VARCHAR2(100 CHAR) NOT NULL,
  ST_WORK VARCHAR2(1000 CHAR) NOT NULL,
  ST_TEL VARCHAR2(500 CHAR) NOT NULL,
  ST_REMARK VARCHAR2(1000 CHAR) NOT NULL,
  ST_ACTIVE NUMBER DEFAULT 0,
  PRIMARY KEY (ST_IDX),
  CONSTRAINT ECMS_ORG_STAFF_FK1 FOREIGN KEY (ST_DEP_IDX) REFERENCES ECMS_ORG_DEPARTMENT (DEP_IDX) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_ORG_STAFF_IDX1 ON ECMS_ORG_STAFF(ST_DEP_IDX);

CREATE TABLE ECMS_POST (
  ARC_ID NUMBER NOT NULL,
  PO_SELECTED1 NUMBER DEFAULT 0,
  PO_SELECTED2 NUMBER DEFAULT 0,
  PO_STICKY NUMBER DEFAULT 0,
  PO_STICKY_SDATE VARCHAR2(20) DEFAULT NULL,
  PO_STICKY_EDATE VARCHAR2(20) DEFAULT NULL,
  PO_STICKY_ORDER NUMBER DEFAULT 0,
  PRIMARY KEY (ARC_ID),
  CONSTRAINT ECMS_POST_FK1 FOREIGN KEY (ARC_ID) REFERENCES ECMS_ARCHIVE (ARC_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_POST_IDX1 ON ECMS_POST(ARC_ID);

CREATE TABLE ECMS_POLL (
  PO_ID NUMBER NOT NULL,
  PO_QUESTION VARCHAR2(500 CHAR) NOT NULL,
  PO_DESCRIPTION VARCHAR2(1000 CHAR) NOT NULL,
  PO_TYPE VARCHAR2(10) NOT NULL,
  PO_USE_ETC NUMBER DEFAULT NULL,
  PO_MEMBER_ONLY NUMBER DEFAULT NULL,
  PO_ALLOW_DUPLICATE NUMBER DEFAULT NULL,
  PO_SHOW_RESULT_AFTER_VOTE NUMBER DEFAULT NULL,
  PO_SHOW_RESULT_BUTTON NUMBER DEFAULT NULL,
  PO_SHOW_ANSWER_NUM NUMBER DEFAULT NULL,
  PO_START_DATE VARCHAR2(10) DEFAULT NULL,
  PO_END_DATE VARCHAR2(10) DEFAULT NULL,
  PO_VOTE_LIMIT NUMBER DEFAULT NULL,
  PO_TEMPLATE VARCHAR2(100) DEFAULT NULL,
  PO_REG_DATE DATE DEFAULT NULL,
  PRIMARY KEY (PO_ID)
) ;

CREATE TABLE ECMS_POLL_ANSWER (
  PA_ID NUMBER NOT NULL,
  PO_ID NUMBER NOT NULL,
  PA_TEXT VARCHAR2(500 CHAR) NOT NULL,
  PA_ORDER NUMBER DEFAULT NULL,
  PRIMARY KEY (PA_ID),
  CONSTRAINT ECMS_POLL_ANSWER_FK1 FOREIGN KEY (PO_ID) REFERENCES ECMS_POLL (PO_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_POLL_ANSWER_IDX1 ON ECMS_POLL_ANSWER(PO_ID);

CREATE TABLE ECMS_POLL_VOTE (
  PV_ID NUMBER NOT NULL,
  PO_ID NUMBER NOT NULL,
  PA_ID NUMBER NOT NULL,
  PA_ETC VARCHAR2(500 CHAR) DEFAULT NULL,
  PV_UNIQUE VARCHAR2(100) NOT NULL,
  PRIMARY KEY (PV_ID),
  CONSTRAINT ECMS_POLL_VOTE_FK1 FOREIGN KEY (PO_ID) REFERENCES ECMS_POLL (PO_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_POLL_VOTE_IDX1 ON ECMS_POLL_VOTE(PO_ID);

CREATE TABLE ECMS_QNA (
  QNA_IDX NUMBER NOT NULL,
  QNA_FAMILY NUMBER NOT NULL,
  QNA_TITLE VARCHAR2(500 CHAR) NOT NULL,
  QNA_CONTENT CLOB,
  QNA_MEMBER VARCHAR2(200 CHAR) NOT NULL,
  QNA_SECRET NUMBER DEFAULT 0,
  QNA_EMAIL VARCHAR2(500 CHAR) NOT NULL,
  QNA_GUEST_NAME VARCHAR2(100 CHAR) DEFAULT NULL,
  QNA_GUEST_PASSWORD VARCHAR2(200 CHAR) DEFAULT NULL,
  QNA_IP VARCHAR2(20) NOT NULL,
  QNA_CREATED DATE DEFAULT NULL,
  QNA_OPEN NUMBER DEFAULT 1,
  QNA_HIT NUMBER DEFAULT 0,
  QNA_DELETED NUMBER DEFAULT 0,
  PRIMARY KEY (QNA_IDX)
) ;

CREATE TABLE ECMS_ROLE (
  ROLE_CODE VARCHAR2(50) NOT NULL,
  ROLE_NAME VARCHAR2(50 CHAR) DEFAULT NULL,
  ROLE_DESCRIPTION VARCHAR2(1000 CHAR) DEFAULT NULL,
  ROLE_REGDATE DATE DEFAULT NULL,
  ROLE_DEFAULT NUMBER DEFAULT 0,
  ROLE_ADMIN NUMBER DEFAULT 0,
  ROLE_JOIN NUMBER DEFAULT 0,
  PRIMARY KEY (ROLE_CODE)
) ;

CREATE TABLE ECMS_ROLE_CAP (
  ROLE_CODE VARCHAR2(50) NOT NULL ,
  CAP_ID VARCHAR2(50) NOT NULL ,
  PRIMARY KEY (ROLE_CODE,CAP_ID)
) ;

CREATE TABLE ECMS_SATISFACTION (
  MENU_ID VARCHAR2(100) NOT NULL,
  SAT_SCORE_50 NUMBER DEFAULT NULL,
  SAT_SCORE_40 NUMBER DEFAULT NULL,
  SAT_SCORE_30 NUMBER DEFAULT NULL,
  SAT_SCORE_20 NUMBER DEFAULT NULL,
  SAT_SCORE_10 NUMBER DEFAULT NULL,
  SAT_LAST_RATE_DATE DATE DEFAULT NULL,
  SAT_RESET_DATE DATE DEFAULT NULL,
  PRIMARY KEY (MENU_ID),
  CONSTRAINT ECMS_SATISFACTION_FK1 FOREIGN KEY (MENU_ID) REFERENCES ECMS_MENU (MENU_ID) ON DELETE CASCADE 
) ;
CREATE INDEX ECMS_SATISFACTION_IDX1 ON ECMS_SATISFACTION(MENU_ID);

CREATE TABLE ECMS_SCHEDULE_EVENT (
  SE_ID NUMBER NOT NULL,
  SE_START_DATE VARCHAR2(20) DEFAULT NULL,
  SE_START_HOUR NUMBER DEFAULT NULL,
  SE_START_MIN NUMBER DEFAULT NULL,
  SE_END_DATE VARCHAR2(20) DEFAULT NULL,
  SE_END_HOUR NUMBER DEFAULT NULL,
  SE_END_MIN NUMBER DEFAULT NULL,
  SE_TITLE_KR VARCHAR2(200 CHAR) DEFAULT NULL,
  SE_TITLE_EN VARCHAR2(200) DEFAULT NULL,
  SE_MEMO VARCHAR2(1000 CHAR) DEFAULT NULL,
  SE_COLOR VARCHAR2(20) DEFAULT NULL,
  SE_WHOLE_DAY NUMBER DEFAULT NULL,
  SE_LINK_URL VARCHAR2(500) DEFAULT NULL,
  SE_LINK_TARGET VARCHAR2(10) DEFAULT NULL,
  PRIMARY KEY (SE_ID)
) ;

CREATE TABLE ECMS_SCHEDULE_HOLIDAY (
  SH_ID NUMBER NOT NULL,
  SH_YEAR NUMBER DEFAULT NULL,
  SH_MONTH NUMBER DEFAULT NULL,
  SH_DAY NUMBER DEFAULT NULL,
  SH_TITLE_KR VARCHAR2(200 CHAR) DEFAULT NULL,
  SH_TITLE_EN VARCHAR2(200) DEFAULT NULL,
  SH_RECUR NUMBER DEFAULT NULL,
  SH_LUNAR NUMBER DEFAULT NULL,
  SH_MEMO VARCHAR2(1000) DEFAULT NULL,
  PRIMARY KEY (SH_ID)
) ;

CREATE TABLE ECMS_SECURITY_TOKEN (
  TIME_MILLIS VARCHAR2(20) DEFAULT NULL,
  TOKEN VARCHAR2(100) DEFAULT NULL
) ;

CREATE TABLE ECMS_SITE (
  SITE_ID VARCHAR2(10) NOT NULL,
  SITE_TYPE VARCHAR2(10) DEFAULT 'domain',
  SITE_DOMAIN VARCHAR2(500) DEFAULT '',
  SITE_NAME VARCHAR2(100 CHAR) NOT NULL,
  SITE_DESCRIPTION VARCHAR2(1000) NOT NULL,
  SITE_THEME VARCHAR2(100) NOT NULL,
  SITE_MAIN NUMBER DEFAULT NULL,
  SITE_LOCALE VARCHAR2(10) DEFAULT 'ko_KR',
  PRIMARY KEY (SITE_ID)
) ;

CREATE TABLE ECMS_STAT (
  STAT_ID NUMBER NOT NULL,
  STAT_ITEM_TYPE VARCHAR2(100) NOT NULL,
  STAT_ITEM_ID VARCHAR2(100) NOT NULL,
  STAT_YEAR NUMBER DEFAULT NULL,
  STAT_MONTH NUMBER DEFAULT NULL,
  STAT_DAY_01 NUMBER DEFAULT NULL,
  STAT_DAY_02 NUMBER DEFAULT NULL,
  STAT_DAY_03 NUMBER DEFAULT NULL,
  STAT_DAY_04 NUMBER DEFAULT NULL,
  STAT_DAY_05 NUMBER DEFAULT NULL,
  STAT_DAY_06 NUMBER DEFAULT NULL,
  STAT_DAY_07 NUMBER DEFAULT NULL,
  STAT_DAY_08 NUMBER DEFAULT NULL,
  STAT_DAY_09 NUMBER DEFAULT NULL,
  STAT_DAY_10 NUMBER DEFAULT NULL,
  STAT_DAY_11 NUMBER DEFAULT NULL,
  STAT_DAY_12 NUMBER DEFAULT NULL,
  STAT_DAY_13 NUMBER DEFAULT NULL,
  STAT_DAY_14 NUMBER DEFAULT NULL,
  STAT_DAY_15 NUMBER DEFAULT NULL,
  STAT_DAY_16 NUMBER DEFAULT NULL,
  STAT_DAY_17 NUMBER DEFAULT NULL,
  STAT_DAY_18 NUMBER DEFAULT NULL,
  STAT_DAY_19 NUMBER DEFAULT NULL,
  STAT_DAY_20 NUMBER DEFAULT NULL,
  STAT_DAY_21 NUMBER DEFAULT NULL,
  STAT_DAY_22 NUMBER DEFAULT NULL,
  STAT_DAY_23 NUMBER DEFAULT NULL,
  STAT_DAY_24 NUMBER DEFAULT NULL,
  STAT_DAY_25 NUMBER DEFAULT NULL,
  STAT_DAY_26 NUMBER DEFAULT NULL,
  STAT_DAY_27 NUMBER DEFAULT NULL,
  STAT_DAY_28 NUMBER DEFAULT NULL,
  STAT_DAY_29 NUMBER DEFAULT NULL,
  STAT_DAY_30 NUMBER DEFAULT NULL,
  STAT_DAY_31 NUMBER DEFAULT NULL,
  PRIMARY KEY (STAT_ID)
) ;

CREATE TABLE ECMS_SUBSCRIBER (
  SUBSCR_IDX NUMBER NOT NULL,
  SUBSCR_EMAIL VARCHAR2(200) NOT NULL UNIQUE,
  SUBSCR_SERVICE VARCHAR2(100) NOT NULL,
  SUBSCR_REGDATE DATE DEFAULT SYSDATE,
  PRIMARY KEY (SUBSCR_IDX)
) ;

CREATE TABLE ECMS_TEXT_DATA (
  TEXT_GROUP VARCHAR2(20) NOT NULL,
  TEXT_ID VARCHAR2(20) NOT NULL,
  TEXT_NAME VARCHAR2(100) DEFAULT NULL,
  TEXT_CONTENT CLOB,
  PRIMARY KEY (TEXT_ID,TEXT_GROUP)
) ;

CREATE TABLE ECMS_WATCHDOG_LOG (
  LOG_ID NUMBER NOT NULL,
  MEMBER_ID VARCHAR2(40) DEFAULT NULL,
  METHOD_NAME VARCHAR2(200) DEFAULT NULL,
  LOG_DATE DATE DEFAULT NULL,
  LOG_URI VARCHAR2(1000) DEFAULT NULL,
  LOG_REPORT VARCHAR2(1000) DEFAULT NULL,
  LOG_REMOTE_IP VARCHAR2(40) DEFAULT NULL,
  PRIMARY KEY (LOG_ID)
) ;

CREATE SEQUENCE ECMS_COMMON_SEQ INCREMENT BY 1 START WITH 100 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_ARCHIVE_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_BOARD_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_CLEAN_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_FILEINFO_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_STAT_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_WATCHDOG_LOG_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;
CREATE SEQUENCE ECMS_QNA_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE;

-- DML

--ECMS_FEED_CONFIG
INSERT INTO ECMS_FEED_CONFIG (FEED_CONFIG_ID, FEED_URI_NAME, FEED_TYPE, FEED_VERSION, FEED_CHANNEL_TITLE, FEED_CHANNEL_LINK, FEED_CHANNEL_DESCRIPTION, FEED_CHANNEL_COPYRIGHT, FEED_TABLE, FEED_PK_COLUMN, FEED_MODULE_ID_COLUMN, FEED_MODULE_SUB_ID_COLUMN, FEED_TITLE_COLUMN, FEED_LINK_COLUMN, FEED_DESCRIPTION_COLUMN, FEED_PUB_DATE_COLUMN, FEED_AUTHOR_COLUMN, FEED_GUID_COLUMN, FEED_PAGE_SIZE, FEED_DESCRIPTION_LENGTH, FEED_MODULE, FEED_MODULE_ID, FEED_MODULE_SUB, FEED_MODULE_SUB_ID, FEED_CONFIG_REGDATE, FEED_EXTRA_CONDITION) VALUES
(1,	'post',	'rss',	'2.0',	'포스트',	'/site/main/archive/post',	'포스트의 피드입니다.',	'Copyright ECMS DEVELOPMENT',	'ECMS_ARCHIVE',	'ARC_ID',	'ARC_CUSTOM_TYPE',	'',	'ARC_TITLE',	'ARC_SLUG',	'ARC_EXCERPT',	'ARC_CREATED',	'MEM_ID',	'ARC_ID',	20,	200,	'archive',	'post',	'',	'',	'2014-07-08 17:42:30',	'AND ARC_STATUS = \'publish\'');

--ECMS_GROUP
INSERT INTO ECMS_GROUP (GROUP_ID, GROUP_NAME, GROUP_PARENT, GROUP_REGDATE, GROUP_ORDER, GROUP_DEPTH) VALUES
('team_dev',	'개발팀2015',	'',	'2014-12-31 10:35:10',	0,	1);

--ECMS_GROUP_MEMBER
INSERT INTO ECMS_GROUP_MEMBER (GROUP_ID, MEM_ID) VALUES ('team_dev',	'cwsong');

--ECMS_POLL
INSERT INTO ECMS_POLL (PO_ID, PO_QUESTION, PO_DESCRIPTION, PO_TYPE, PO_USE_ETC, PO_MEMBER_ONLY, PO_ALLOW_DUPLICATE, PO_SHOW_RESULT_AFTER_VOTE, PO_SHOW_RESULT_BUTTON, PO_SHOW_ANSWER_NUM, PO_START_DATE, PO_END_DATE, PO_VOTE_LIMIT, PO_TEMPLATE, PO_REG_DATE) VALUES
(1,	'좋아하는 야구팀은?',	'',	'radio',	1,	1,	1,	1,	0,	0,	'',	'',	0,	'poll.jsp',	'2014-10-20 15:54:38');

-- SITE
--INSERT INTO ECMS_SITE (SITE_ID, SITE_TYPE, SITE_DOMAIN, SITE_NAME, SITE_DESCRIPTION, SITE_THEME, SITE_MAIN, SITE_LOCALE) VALUES ('child',	'dir',	'',	'CHILD SUB DIR DEMO SITE',	'CHILD SUB DIR DEMO SITE',	'bluebox',	0,	'ko_KR');
INSERT INTO ECMS_SITE (SITE_ID, SITE_TYPE, SITE_DOMAIN, SITE_NAME, SITE_DESCRIPTION, SITE_THEME, SITE_MAIN, SITE_LOCALE) VALUES ('ecms',	'domain',	'',	'ECMS DEMO SITE',	'ECMS DEMO SITE',	'bootstrap3',	1,	'ko_KR');

-- ROLE
INSERT INTO ECMS_ROLE (ROLE_CODE, ROLE_NAME, ROLE_DESCRIPTION, ROLE_REGDATE, ROLE_DEFAULT, ROLE_ADMIN, ROLE_JOIN) VALUES ('ROLE_ADMIN',	'관리자',	'관리자',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	1,	0);
INSERT INTO ECMS_ROLE (ROLE_CODE, ROLE_NAME, ROLE_DESCRIPTION, ROLE_REGDATE, ROLE_DEFAULT, ROLE_ADMIN, ROLE_JOIN) VALUES ('ROLE_GUEST',	'비회원',	'비회원',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	0,	0);
INSERT INTO ECMS_ROLE (ROLE_CODE, ROLE_NAME, ROLE_DESCRIPTION, ROLE_REGDATE, ROLE_DEFAULT, ROLE_ADMIN, ROLE_JOIN) VALUES ('ROLE_MEMBER',	'일반사용자',	'일반사용자',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	0,	1);

-- CAPABILITY
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_ADMIN_ACCESS',	'관리자>접속',	NULL,	'/site/[a-z0-9]+/admin/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	1,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_ARCHIVE',	'관리자>아카이브>분류체계',	'',	'/site/[a-z0-9]+/admin/archive/taxonomy/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BANNER',	'관리자>사이트>배너/팝업존',	NULL,	'/site/[a-z0-9]+/admin/banner/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BOARD_DELETE',	'관리자>게시판>삭제',	'관리자>게시판>삭제',	'/site/[a-z0-9]+/admin/board/config/delete.do',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BOARD_INSERT',	'관리자>게시판 >추가',	'관리자>게시판>추가',	'/site/[a-z0-9]+/admin/board/config/insert.do',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BOARD_LIST',	'관리자>게시판>목록조회',	'관리자>게시판>목록조회',	'/site/[a-z0-9]+/admin/board/config/list.do',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BOARD_UPDATE',	'관리자>게시판>수정',	'관리자>게시판>수정',	'/site/[a-z0-9]+/admin/board/config/update.do',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_BULKMAIL',	'관리자>사용자지원>메일발송',	'',	'/site/[a-z0-9]+/admin/bulkMail/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_CAPABILITY',	'관리자>보안>권한',	NULL,	'/site/[a-z0-9]+/admin/capability/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_CODE',	'관리자>시스템>코드',	NULL,	'/site/[a-z0-9]+/admin/code/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_COMMENT',	'관리자>토론>댓글',	NULL,	'/site/[a-z0-9]+/admin/comment/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_CONFIG',	'관리자>시스템>설정',	'관리자>시스템>설정',	'/site/[a-z0-9]+/admin/config/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_FEED',	'관리자>피드',	'관리자>피드',	'/site/[a-z0-9]+/admin/feed/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_GROUP',	'관리자>사용지지원>그룹',	NULL,	'/site/[a-z0-9]+/admin/group/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_LOG',	'관리자>시스템>관리자이력로그',	'관리자>시스템>관리자이력로그',	'/site/[a-z0-9]+/admin/watchdog/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_MAIL_TRACK',	'관리자>사용자지원>메일발송기록',	'',	'/site/[a-z0-9]+/admin/mail/track.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_MEDIA',	'관리자>미디어',	'',	'/site/[a-z0-9]+/admin/media/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_MEMBER',	'관리자>사용자지원>회원',	NULL,	'/site/[a-z0-9]+/admin/member/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_MENU',	'관리자>디자인>메뉴',	'관리자>디자인>메뉴',	'/site/[a-z0-9]+/admin/menu/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_ORGANIZATION',	'관리자>조직및업무',	'',	'/site/[a-z0-9]+/admin/organization/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_POLL',	'관리자>토론>투표',	'관리자>토론>투표',	'/site/[a-z0-9]+/admin/poll/*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_POST',	'관리자>아카이브>포스트',	'',	'/site/[a-z0-9]+/admin/archive/post/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_ROLE',	'관리자>보안>역할',	NULL,	'/site/[a-z0-9]+/admin/role/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_SCHEDULE',	'관리자>일정',	'관리자>일정',	'/site/[a-z0-9]+/admin/schedule/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_SITE',	'관리자>사이트관리',	'',	'/site/[a-z0-9]+/admin/site/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_STATISTICS',	'관리자>통계',	'',	'/site/[a-z0-9]+/admin/statistics/.*',	'',	'',	'',	'',	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);
INSERT INTO ECMS_CAPABILITY (CAP_ID, CAP_NAME, CAP_DESCRIPTION, CAP_VALUE, CAP_PARAM1_KEY, CAP_PARAM1_VALUE, CAP_PARAM2_KEY, CAP_PARAM2_VALUE, CAP_HTTP_METHOD, CAP_REGDATE, CAP_DEFAULT, CAP_PRIORITY, CAP_HIDDEN) VALUES ('CAP_THEME',	'관리자>디자인>테마',	'관리자>디자인>테마',	'/site/[a-z0-9]+/admin/theme/.*',	NULL,	NULL,	NULL,	NULL,	'ALL',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	100,	0);

-- MEMBER
INSERT INTO ECMS_MEMBER (MEM_ID, MEM_PASSWORD, MEM_LAST_NAME, MEM_FIRST_NAME, MEM_NAME, MEM_ACTIVE, MEM_EMAIL, MEM_REGDATE, MEM_ROLE, MEM_TEL1, MEM_TEL2, MEM_TEL3, MEM_MOBILE1, MEM_MOBILE2, MEM_MOBILE3, MEM_DUP_INFO, MEM_MAILING, MEM_LEVEL, MEM_SIGN_UP_KEY, MEM_SIGN_UP_KEY_CHECKED, MEM_LAST_LOGIN_DATE, MEM_TEL, MEM_MOBILE, MEM_GENDER, MEM_ORGANIZATION, MEM_DEPARTMENT, MEM_POSITION, MEM_FAX, MEM_ADDRESS, MEM_ADDRESS_SUB, MEM_CITY_STATE, MEM_COUNTRY, MEM_ZIP_CODE, MEM_SNS, MEM_SNS_ID, MEM_SNS_HOME) VALUES ('admin',	'G8Bzln9MJPAA0Pw0AGz43oN1Kp2P3mgnixjAM7u2jSw=',	'',	'',	'nVMjzelMb2VuTyWyDSnnSw==',	1,	'CXmXZyOoMCYTCqHHUPHcfw==',	TO_DATE('2014-09-16 16:56:59', 'YYYY-MM-DD HH24:MI:SS'),	'ROLE_ADMIN',	'',	'',	'',	'Ekdt5X9Xh9SojXbt4d9KAA==',	'4dCjc3bgo8CG0xO9NSRiOQ==',	'5zX5IwUSng+HYWUJciy0Bg==',	NULL,	0,	'BASIC',	NULL,	1,	TO_DATE('2015-05-20 19:04:57', 'YYYY-MM-DD HH24:MI:SS'),	NULL,	NULL,	'M',	'',	'',	'',	'',	'',	'',	'',	'KR',	'',	NULL,	NULL,	NULL);

-- MENU
INSERT INTO ECMS_MENU (MENU_ID, MENU_NAME, MENU_TYPE, MENU_GNB_TYPE, MENU_GNB_EXT_ON, MENU_GNB_EXT_OFF, MENU_SNB_TYPE, MENU_SNB_EXT_ON, MENU_SNB_EXT_OFF, MENU_TITLE_TYPE, MENU_TITLE_EXT, MENU_TITLE_SUB_TEXT, MENU_LINK, MENU_NEW_WIN, MENU_PARENT, MENU_DEPTH, MENU_ORDER, MENU_HEADER, MENU_TEMPLATE, MENU_FOOTER, MENU_STATUS, MENU_MANAGER, MENU_DEPARTMENT, MENU_PHONE, MENU_EMAIL, MENU_ETC, MENU_REGDATE, MENU_USE_SATISFACTION, MENU_LAST_MODIFIED) VALUES ('home',	'Home',	'program',	'text',	'',	'',	'text',	'',	'',	'text',	'',	'',	'/site/main/home',	0,	'',	1,	0,	'header.jsp',	'',	'footer.jsp',	'public',	'',	'',	'',	'',	'',	TO_DATE('2014-05-12 19:35:05', 'YYYY-MM-DD HH24:MI:SS'),	0,	TO_DATE('2015-05-19 13:00:42', 'YYYY-MM-DD HH24:MI:SS'));

-- CONFIG_OPTION
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('archive',	'post_content_tag',	'false',	'포스트 콘텐츠 본문 단어 태깅여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'daum_client_id',	'6083247572390422911',	'다음 Client ID',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'daum_client_secret',	'7e9cee4d3aa2884068def2e211dcf219',	'다음 Client Secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'facebook_app_id',	'787076231379494',	'페이스북 App ID',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'facebook_app_secret',	'8a4928861ad605481bde340a9b012297',	'페이스북 App Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'googleplus_client_id',	'503928239157-d4fcv1rqt6vteujese7ps4s41vsagd5q.apps.googleusercontent.com',	'구글플러스 Client ID',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'googleplus_client_secret',	'JeUnyjNGBVAavM30stqS7fM1',	'구글플러스 Client Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'naver_client_id',	'quGTdPX2dS5zHqdWIYXE',	'네이버 Client ID',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'naver_client_secret',	'H5KuS9hzhe',	'네이버 Client Secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'twitter_api_key',	'GrmrODU8EVvdjuWJ1NMIGderK',	'트위터 API Key',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'twitter_api_secret',	'2ijnielGkgWeU77KGVvDu4QGajld5vO3IQLS2fAzzynIGq46Hy',	'트위터 API Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('comment',	'use_moderate',	'false',	'댓글감독기능 사용유무',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('design',	'nav_gnb_display_depth',	'2',	'메인메뉴 출력 깊이 제한',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('design',	'nav_snb_display_depth',	'3',	'서브메뉴 출력 깊이 제한',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'admin_access_whitelist',	'',	'관리자단 접근가능IP',	'textarea',	0,	NULL,	'<br/>전체 아이피또는 아이피패턴형태 로 입력할 수 있습니다. (모든숫자는 *로 표시, 엔터로 구분 ex) 100.100.*.*)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'clean_email',	'',	'클린신고센터 이메일',	'text',	0,	NULL,	'클린신고센터 신고시 해당이메일로 메일이 발송됩니다.(공백일경우 미발송, 쉼표(,)로 복수이메일 구분)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'qna_email',	'',	'묻고답하기 이메일',	'text',	0,	NULL,	'묻고답하기 등록시 해당이메일로 메일이 발송됩니다.(공백일경우 미발송, 쉼표(,)로 복수이메일 구분)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'cookie_domain',	'.ecms.dev.com',	'쿠키도메인',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'default_member_level',	'BASIC',	'가입시 회원등급',	'text',	0,	NULL,	'시스템-코드관리의 상세코드값을 입력해주세요.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'display_error_detail',	'true',	'에러내용 표시여부',	'radio',	0,	NULL,	'False 일경우 에러의 세부내용은 표시되지 않습니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'fix_kor_active',	'true',	'한글깨짐 보정 사용여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'fix_kor_from',	'8859_1',	'한글깨짐 보정 읽을 문자셋',	'text',	0,	NULL,	'한글깨짐 보정 사용시에만 적용됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'fix_kor_to',	'UTF-8',	'한글깨짐 보정 쓸 문자셋',	'text',	0,	NULL,	'한글깨짐 보정 사용시에만 적용됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'signup_require_email_confirm',	'false',	'가입시 이메일인증 필요여부',	'radio',	0,	NULL,	'회원가입 후 가입확인 이메일을 확인해야 최종가입이 처리됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'use_captcha_secret_key',	'6LfFvyQTAAAAACK-obxnqwbMorkSFxHZSZeetjKY',	'캡차 시크릿키',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'use_captcha_signup',	'true',	'회원가입시 캡차사용여부',	'radio',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'use_captcha_site_key',	'6LfFvyQTAAAAABZm3Bwwf-A_ZtPKyxGEFhf07P_u',	'캡차 사이트키',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'use_cookie_sso',	'false',	'쿠키기반 SSO 사용여부',	'radio',	0,	NULL,	'서브도메인 사이트 운용시 사이트간 세션유지를 위해 필요합니다. 서브디렉토리 형태로 운영할 경우 false로 설해 주세요.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'use_db_encryption',	'true',	'CMS DB암호화기능 사용여부',	'radio',	1,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('global',	'stat_referer_item',	'NULL',	'유입경로 구분자 지정',	'textarea',	0,	NULL,	'유입경로 통계에서 리퍼러 문자열을 파싱할 기준. ex) 네이버^search.naver.com (복수데이터 엔터구분)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('google_analytics',	'ga_10_activate',	'false',	'구글애널리틱스 사용여부',	'radio',	0,	NULL,	'https://console.developers.google.com→프로젝트만들기→사용자인증정보만들기→서비스계정키');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('google_analytics',	'ga_10_uid',	'UA-XXXXXXXX-X',	'구글애널리틱스 UID',	'text',	0,	NULL,	'ex) UA-XXXXXXXX-X');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('google_analytics',	'ga_20_dashboard',	'false',	'대시보드 차트표시여부',	'radio',	0,	NULL,	'대시보드에 차트를 표시하기 위해서는, API콘솔에서 사용자인증정보 서비스계정키생성으로 Json다운로드 후 이 과정에서 생성된 서비스사용자 이메일 주소를 애널리틱스 보고서의 사용자관리에서 사용자로 등록해주어야 합니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('google_analytics',	'ga_20_view_id',	'애널리틱스 보고서 보기ID',	'애널리틱스 보고서 View ID',	'text',	0,	NULL,	'대시보드에 차트를 표시할 경우에만 필요. https://analytics.google.com→보고서→설정보기→보기ID');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'default_encoding',	'UTF-8',	'기본 인코딩',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'host',	'smtp.gmail.com',	'메일서버 호스트',	'text',	0,	NULL,	'메일서버호스트');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'mail.smtp.auth',	'true',	'mail.smtp.auth',	'radio',	0,	NULL,	'인증을 사용할지 여부');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'mail.smtp.ssl.enable',	'false',	'mail.smtp.ssl.enable',	'radio',	0,	NULL,	'암묵적으로 보안채널로 이메일을 전송할지 여부(gmail port : 465)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'mail.smtp.starttls.enable',	'true',	'mail.smtp.starttls.enable',	'radio',	0,	NULL,	'명시적으로 보안채널로 이메일을 전송할지 여부(mail.smtp.ssl.trust 프로퍼티에 자동으로 host의 값이 할당됨, gmail port : 587)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'mail.smtp.timeout',	'100000',	'mail.smtp.timeout',	'text',	0,	'ms',	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'password',	'master1234',	'Password',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'port',	'587',	'포트',	'text',	0,	NULL,	'ex) 25, 465, 587');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'protocal',	'smtp',	'프로토콜',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('mail',	'username',	'nopemailer@gmail.com',	'Username',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('media',	'upload_size_limit',	'100',	'미디어 업로드 용량 제한',	'text',	0,	'MB',	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('media',	'use_ffmpeg',	'false',	'FFmpeg 인코딩 사용여부',	'radio',	0,	NULL,	'동영상 또는 음악(음성)파일을 ffmpeg library를 이용해 mp4, mp3로 인코딩합니다. (서버자원이 여유가 있을 경우에만 사용해주세요.)');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'facebook_app_id',	'655891324506129',	'원격출판 Facebook App Id',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'facebook_app_secret',	'14fcfa2f42552d41266cd106bc77aaca',	'원격출판 Facebook App Sercet',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'facebook_page_access_token',	'CAAJUh5lokBEBALzQ0epUtsZAQ41LZCeZC4a4TcryltOaaild4ZB9UmsfFXAJ4SvJ5VBLmLj1dGFOkZAyafpVDiABOMaczGwSWqmNwELZC7Y66f0ugIVO7Y1ah6TmA9VnykNKeZC7kfcxlhPnuPBWAwxZCMxNohZChVpxXJgZAiuiZAvufgypNvB0b11',	'원격출판 Facebook Page Access Token',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'facebook_page_id',	'1476880385891320',	'원격출판 Facebook Page Id',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'facebook_use',	'false',	'원격출판 Facebook 사용여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'twitter_access_token',	'566891829-nJnXeTUfiz7TeZC5A3s17kQyHrgQCt6xtOxW1iZ1',	'원격출판 Twitter Access Token',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'twitter_access_token_secret',	'KC5EDSKiXjvR6wyihY7SsJh05fJlW6XAUz7LZF1GtFdXA',	'원격출판 Twitter Access Token Secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'twitter_api_key',	'EsiwiuUXWBs9xJaw1m8dLxMQg',	'원격출판 Twitter API key',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'twitter_api_secret',	'dnlDVWftom52O7iJMKwEQIzAFLo2S35jksXtEtv5ZdeXrcFJxt',	'원격출판 Twitter API secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('remote_publish',	'twitter_use',	'false',	'원격출판 Twitter 사용여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('security',	'ssl',	'false',	'SSL 적용여부',	'radio',	0,	NULL,	'주의! 서버에 SSL 인증서가 설치된 경우에만 사용가능합니다. 변경후 접속불가 상태가 될 경우 DB에서 직접 해당값을 수정해주어야 합니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('security',	'ssl_force_http',	'true',	'SSL 강제 HTTP 여부',	'radio',	0,	NULL,	'URL이 SSL적용 패턴에 해당하지 않을 경우, 강제로 HTTP로 리다이렉트 시킬지 여부입니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('security',	'ssl_pattern',	'.*/admin/.*',	'SSL 적용 URL 패턴',	'textarea',	0,	NULL,	'<br/>엔터로 구분되며, 정규식형태로 입력가능합니다.(/page/login.*). 패턴값이 없을 경우 적용여부가 true 이면 모든 url에 강제 적용됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('security',	'ssl_port',	'',	'SSL 포트',	'text',	0,	NULL,	'공백일 경우 443으로 처리됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'dashboard_sysinfo',	'true',	'대시보드 시스템정보 표시여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'force_redirect',	'false',	'사이트 접속시 강제 리다이렉트',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'force_redirect_url',	'http://www.google.co.kr',	'사이트 접속시 강제 리다이렉트주소',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'mobile_home_index',	'',	'모바일 홈페이지 주소',	'text',	0,	NULL,	'모바일 메인주소');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'mobile_home_redirect',	'false',	'모바일 디바이스 리다이렉트',	'radio',	0,	NULL,	'PC홈페이지 접속시 모바일디바이스 일 경우 모바일 홈페이지로 리다이렉트할것인지 여부');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'qna_allow_guest',	'false',	'Q&A 비회원 쓰기가능여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'site_email',	'cwsong@epart.com',	'사이트 대표이메일',	'text',	0,	NULL,	'공백일 경우 관리자계정의 이메일이 대신 사용됩니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'thumb_default_height',	'300',	'썸네일 생성 기본 세로길이',	'text',	0,	'px',	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'thumb_default_width',	'400',	'썸네일 생성 기본 가로길이',	'text',	0,	'px',	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'upload_white_list',	'jpg,jpeg,png,gif,bmp,ppt,pptx,xls,xlsx,doc,docx,pdf,txt,hwp,swf,wmv,mp4,flv,ogv,ogg,mp3,m4a,wav,wma',	'업로드 허용 확장자',	'textarea',	0,	NULL,	',로구분');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'user_form_allow_tag',	'a,b,blockquote,br,caption,cite,code,col,colgroup,dd,dl,dt,em,h1,h2,h3,h4,h5,h6,i,img,li,ol,p,pre,q,small,strike,strong,sub,sup,table,tbody,td,tfoot,th,thead,tr,u,ul',	'허용태그',	'textarea',	0,	NULL,	'프론트단 입력시 허용태그입니다.');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('site',	'use_content_revision',	'true',	'콘텐츠 개정이력 사용여부',	'radio',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'daum_client_id',	'6083247572390422911',	'다음 Client ID',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'daum_client_secret',	'7e9cee4d3aa2884068def2e211dcf219',	'다음 Client Secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'facebook_app_id',	'787076231379494',	'페이스북 App ID',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'facebook_app_secret',	'8a4928861ad605481bde340a9b012297',	'페이스북 App Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'googleplus_client_id',	'503928239157-d4fcv1rqt6vteujese7ps4s41vsagd5q.apps.googleusercontent.com',	'구글플러스 Client ID',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'googleplus_client_secret',	'JeUnyjNGBVAavM30stqS7fM1',	'구글플러스 Client Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'naver_client_id',	'E7ywQ0GZkbyqpK70cE4V',	'네이버 Client ID',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'naver_client_secret',	'YtS02sH4Dp',	'네이버 Client Secret',	'text',	0,	NULL,	NULL);
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'twitter_api_key',	'Qj2ZaREYiBeGnCzPHpEBXVExW',	'트위터 API Key',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('sns',	'twitter_api_secret',	'w2Rmn0ucwENz8OYBwwRR3GzLEtSpC8QgCIcxqR8d1uLy9YDIZn',	'트위터 API Secret',	'text',	0,	NULL,	'');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('watermark',	'watermark_image',	'/uploadfile/watermark/watermark.png',	'워터마크 이미지경로',	'text',	1,	'',	'워터마크 이미지경로');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('watermark',	'watermark_position',	'CENTER',	'워터마크 위치',	'text',	0,	NULL,	'TOP_LEFT, TOP_CENTER, TOP_RIGHT, CENTER_LEFT, CENTER, CENTER_RIGHT, BOTTOM_LEFT, BOTTOM_CENTER, BOTTOM_RIGHT');
INSERT INTO ECMS_CONFIG_OPTION (CONF_ID, OPT_KEY, OPT_VALUE, OPT_NAME, OPT_TYPE, OPT_HIDDEN, OPT_UNIT_TEXT, OPT_HELP) VALUES ('watermark',	'watermark_use',	'false',	'워터마크 기본사용 여부',	'radio',	0,	NULL,	'미디어 업로드시 기본적으로 워터마크를 삽입할지 여부.(배너같이 일괄 삽입하지 않는 경우도 있으며 개별 프로그램에서 워터마크를 삽입해야할 경우 별도 처리해주어야 함)');

-- TEXT_DATA
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('google_analytics',	'ga_oauth_json',	'구글애널리틱스 인증Json',	'대시보드에 차트를 표시할 경우에만 필요합니다. OAuth 서버인증용 Json. 구글 API 콘솔에서\\r\\n프로젝트 생성→사용자인증정보→서비스계정키생성으로 다운로드가능\', \'대시보드에 차트를 표시할 경우에만 필요. https://console.developers.google.com→프로젝트만들기→사용자인증정보만들기→서비스계정키');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('mail_form',	'password_reset_mail',	'비밀번호 재설정 메일',	'<p>\r\n	<h2>${SITE_NAME} - 비밀번호 초기화</h2>\r\n</p>\r\n<p>\r\n	<strong>안녕하세요. ${MEMBER_NAME}(${MEMBER_EMAIL})님.</strong>\r\n</p>\r\n<p>\r\n	${SITE_NAME}의 비밀번호가 재 설정되었습니다.\r\n</p>\r\n<p>\r\n	새 비밀번호 : <strong style=\"font-weight: bold; font-size: 20px; color: blue;\">${NEW_PASSWORD}</strong>\r\n</p>\r\n<p>\r\n	재 설정된 비밀번호를 이용해서 로그인해 주세요.\r\n</p>\r\n<p>\r\n	<br />\r\n	<a href=\"${LOGIN_URL}\">로그인하러 가기</a>\r\n	<br />\r\n</p>\r\n<p>\r\n	<br />\r\n	${SITE_NAME} 드림.\r\n</p>');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('join_terms',	'privacy_terms',	'개인정보 수집 및 이용동의',	'▣ 개인정보처리방침');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('mail_form',	'qna_email_code',	'묻고 답하기 이메일인증',	'<p>\r\n	<h2>${SITE_NAME} - 이메일 확인</h2>\r\n</p>\r\n<p>\r\n	<strong>안녕하세요. 고객님.</strong>\r\n</p>\r\n<p>\r\n        아래의 이메일 인증번호를 입력해 주세요.\r\n</p>\r\n<p>\r\n	인증번호 : <strong style=\"font-weight: bold; font-size: 20px; color: blue;\">${EMAIL_CODE}</strong>\r\n</p>\r\n<p>\r\n	<br />\r\n	${SITE_NAME} 드림.\r\n</p>');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('seo',	'robots_txt',	'robots.txt',	'User-agent: *\r\nDisallow: /asset/\r\nDisallow: /admin/\r\nDisallow: /design/\r\nDisallow: /uploadfile/\r\nDisallow: /site/main/file/\r\nDisallow: /site/main/board/\r\nDisallow: /site/main/admin/\r\nDisallow: /site/child/file/\r\nDisallow: /site/child/board/\r\nDisallow: /site/child/admin/\r\n#Disallow: /*? # block any URL that includes a ?');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('mail_form',	'signup_confirm_mail',	'가입확인 메일',	'<p>\r\n	<h2>${SITE_NAME} - 가입확인</h2>\r\n</p>\r\n<p>\r\n	<strong>안녕하세요. ${MEMBER_NAME}(${MEMBER_EMAIL})님.</strong>\r\n</p>\r\n<p>\r\n	${SITE_NAME}에 가입하신 것을 환영합니다.\r\n	<br />\r\n	본인 확인 및 이메일계정 확인을 위해 아래 링크를 클릭하여 인증을 완료해 주세요.\r\n</p>\r\n<p>\r\n	<br />\r\n	<a href=\"${CONFIRM_URL}\">이메일 인증하기</a>\r\n	<br />\r\n</p>\r\n<p>\r\n	<br />\r\n	${SITE_NAME} 드림.\r\n</p>');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('mail_form',	'signup_grats_mail',	'가입축하메일',	'<div style=\"border:solid 3px #65795b;padding:10px;width:681px;margin:0 auto;font-family:\'돋움\';line-height:1.5;\">\r\n			<div style=\"border:solid 1px #a39088;background:url(\'http://namu.sdm.go.kr/design/theme/namu/images/sub/mail_join_bg.jpg\') no-repeat;width:680px;height:420px;\">\r\n				<div style=\"color:#373737;font-size:20px;text-align:center;margin-top:135px;\">\r\n					회원가입을 <span style=\"color:#99b45f;font-weight:bold;font-size:26px;\">축하드립니다.</span>\r\n				</div>\r\n				<div style=\"color:#727272;font-size:14px;text-align:center;margin-top:25px;\">\r\n					<span style=\"color:#000;font-weight:bold;\">${MEMBER_NAME}</span> 회원님은 다음과 같이 가입하셨습니다.\r\n				</div>\r\n				<div style=\"color:#000;font-size:18px;text-align:center;margin-top:15px;\">\r\n					아이디 <span style=\"color:#117d9c;font-weight:bold;\">${MEMBER_ID}</span>\r\n				</div>\r\n				<div style=\"color:#727272;font-size:12px;text-align:center;margin-top:65px;\">\r\n					위 정보는 회원님의 서대문자연사박물관 이용 및 회원님이 가입시 작성하셨던<br/><span style=\"color:#000;font-size:13px;font-weight:bold;\">개인정보 보호를 위해 필수적인 정보</span>입니다.<br/>타인에게 노출되지 않도록 하시며, 서대문자연사박물관을 많이 이용하여 주세요.\r\n				</div>\r\n			</div>\r\n		</div>');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('join_terms',	'use_terms',	'이용약관',	'▣ 이용약관');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('word_filter',	'word_filter',	'금지어 필터',	'10창;10탱;10새;10새기;10새리;10세리;10쎄;10쉐이;10쉑;10스;10쌔;10쌔기;10알;18것;18년;18놈;18노;18넘;18뇬;18롬;18럼;18새;18새끼;18색;18세끼;18세리;18섹;18쉑;18스;18아;좇이;잡것;좇같;잡년;잡놈;잡넘;쥐랄;쥐롤;좌식;쪼다;쥬디;쪽발이;이년;찌랄;이새키;이새끼;쫍빱;이스키;이스끼;임마;asshole;저년;저미친년;저새끼;자슥;쳐박혀서;쳐발랐;주접;주접떨;주글;주글래;주둥이;주둥아리;주데이;주뎅;주뎅이;지랄;지롤;지럴;지미랄;접년;창녀;젖밥;짜식;짜아식;제길;젠장;젬병;짱깨이;육갑;육시랄;육시랄놈;육시럴;육시럴놈;처죽일;처먹어;조찐;조쟁이;조질래;조지;조지냐;조진다;조까;조까치;조낸;조또;조랭;조빠;조옷;존나;존나게;존니;존만;존만한;졸라;은년;을년;좀물;좁년;좁밥;좃찐;좃이;좃까;좃또;좃만;좃밥;좆찐;좆이;좆같;좆까;좆나;좆또;좆만;좆밥;죽을래;죽통;죽고잡;추천인;bitch;할망탱이;할망구;할망구탱이;할마시;cunt;dick;후라들;후라들년;후라들넘;후려쳤;후뢰;후래자식;후레;후레아들;호로;호로자식;호로놈;호로새끼;호로색;호로쉑;호로스키;호로스까이;화냥년;fuck;fucker;penis;pussy;sex;sexy;shit;suck;sucker;sux;탱구;팔럼;퍽큐;친구새끼;칠뜨기;카지노;캐년;캐놈;캐시키;캐스키;캐스끼;ㄱㅐ;ㄲㅑ;ㄲㅅㅂㄹㅁ;ㄲㅏ;ㅅㅐ;ㅆㅣ;ㅆㅂㄹㅁ;ㅆㅍ;ㅆ앙;ㅍㅏ가시내;걔새;걔수작;걔시키;걔시끼;걸레;고스톱;골로가;게색기;게색끼;가시나;갈보갈보년;갈아버려;갈아버려라;갈아버린다;강아지;같은년;같은뇬;개좌식;개자지;개자슥;개접;개좆;개차반;개허접;개같은;개구라;개년;개놈;개나발;개대중;개뇬;개돼중;개독;개랄;개망신;개보지;개뿔;개새;개새키;개새기;개새끼;개색히;개색키;개색기;개색끼;개뻥;개쇳기;개소리;개수작;개섀끼;개세;개세이;개세끼;개시키;개십새기;개십새끼;개쉐;개쉐이;개쉐리;개쉑;개쉽;개스끼;개씹;개아들;개쑈;광뇬;구녕;구라;구멍;그년;그새끼;깡패새끼;꼴아보;꺼벙이;꺼벙아;놈현;나쁜새끼;냄비;담보;대출;대가리;니기미;니귀미;니미;니미랄;니미럴;니미씹;니어매;니어메;니어미;니아배;니아비;니아베;닥쳐;뇬;눈깔;뉘미럴;닝기리;닝기미;되질래;디질래;디져라;디진다;등신;등신;뒤질래;딩시;따식;뎡신;도라이;돈놈;돌은놈;돌아이;뒈질;뒈져;뒈져라;뒈진;뒈진다;또라이;뙨놈;뙨넘;똘아이;띠팔;뙈놈;뙤놈;띨띨이;띠바;띠발;띠불;뚜쟁;때놈;망할년놈;모리배;멍청이;멍청아;멍텅구리;매춘부;메친놈;메친넘;뱅마;뱅신;미췬;미친;미친짓;미친년;미친놈;미친넘;미친새끼;미친스까이;미틴;미틴년;미틴놈;미틴넘;바랄년;바보;바보새끼;발작하네;븅;븅신;부랄;부럴;불할;불알;빌어먹;빙시;빙신;붙어먹;빠큐;빠가;빠구리;빠굴;뷰웅;벼엉신;병자;병신;병쉰;붕가;사이비;뽁큐;삿대질;새키;새갸;새꺄;상놈의;상놈이;상놈을;상넘이;새끼;새새끼;생쑈;색끼;뻐큐;뻑큐;쇼하네;세갸;세꺄;세끼;섹스;썅;썩을년;썩을놈;시팔;시팍;시펄;시궁창;썅년;썅놈;시끼;시댕;시뎅;시랄;시벌;써벌;시발;시브랄;시부랄;시부럴;시부리;시불;십8;십창;심탱;십탱;쎄꺄;십라;심발끈;십새;십새끼;십새끼;십세;십쉐;십쉐이;십스키;십쌔;쎄엑;싸가지;싸대기;싶알;싹아지;쌉년;쌕;신발끈;쌍년;쌍놈;쌍넘;쌍뇬;쉐;쉐키;쉐기;쉐끼;쉐리;쉐에기;쉑;쉬펄;쉬밸;쉬벌;쉬발;쉬뻘;쉽알;스패킹;스팽;쌔끼;쌩쑈;씹이;씹질;씹자지;씹창;씹할;씹헐;씹탱;씹팔;씹같;씸년;씹년;씸뇬;씹뇬;씹보지;씹새;씹새기;씸새끼;씹새끼;씹새리;씹세;씹쉐;씹스키;씹쌔;양년;양놈;양넘;양아치;얼간이;얼간아;아가리;아갈;아갈이;아갈통;아구창;아구통;아굴;얌마;엄창;쒸팔;쒸펄;쒸벌;쒸뻘;쓰팔;쓰바;쓰박;쓰벌;쓰발;씁새;씁얼;씌파;씨8;씨팔;씨팍;씨파;씨펄;씨끼;씨댕;씨뎅;씨뱅;씨밸;씨바;씨박;씨벌;씨바랄;씨방;씨방새;씨방세;씨발;씨발놈;씨봉;씨봉알;씨브랄;씨부랄;씨부럴;씨부렁;씨부리;씨불;씨빠;씨벨;씨붕;씨뽀랄;씨빨;씨알머리;씨앙;오입;욤병;우라질;욕쟁이;욕먹;왜년;왜놈;엠병;여물통;열라;염병;엿같;엿먹어;옘빙;옘병');
INSERT INTO ECMS_TEXT_DATA (TEXT_GROUP, TEXT_ID, TEXT_NAME, TEXT_CONTENT) VALUES ('mail_form', 	'term_check', '약관 재동의', '<p>\r\n 	<h2>${SITE_NAME}</h2>\r\n 	<p style="font-weight: bold;">\r\n 		안녕하세요. ${MEMBER_NAME} 님.\r\n 	</p>\r\n 	<p>\r\n 		${SITE_NAME} 사이트를 이용해 주셔서 감사합니다.개정된 개인정보 보호법에 따라 회원님께서는 사이트에 가입하신지 2년이 지난 관계로 약관 재동의가 필요합니다.\r\n 	</p>\r\n 	<p>\r\n 		아래의 링크를 통해 홈페이지로 이동하신 후 약관 재동의 절차의 진행을 부탁드립니다.\r\n 	</p>\r\n 	<p>\r\n 		<a href="${TERM_CHECK_URL}">홈페이지로 이동</a>\r\n 		<br>\r\n 	</p>\r\n 	<p>\r\n 		<br>\r\n 		${SITE_NAME} 드림\r\n 	</p>\r\n </p>');

-- SCHEDULE_HOLIDAY
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (1,	0,	1,	1,	'신정',	'New Years Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (2,	0,	1,	1,	'구정',	'Korean New Year',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (3,	0,	1,	2,	'구정',	'Korean New Year',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (4,	0,	12,	32,	'구정',	'Korean New Year',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (5,	0,	3,	1,	'3-1절',	'March 1st Movement',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (6,	0,	5,	1,	'근로자의 날',	'Labour Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (7,	0,	5,	5,	'어린이날',	'Childrens Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (8,	0,	4,	8,	'부처님 오신 날',	'Buddhas Birthday',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (9,	0,	6,	6,	'현충일',	'Memorial Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (10,	0,	8,	15,	'광복절',	'Liberation Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (11,	0,	8,	14,	'추석',	'Harvest Festival',	1,	1,	'');
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (12,	0,	8,	15,	'추석',	'Harvest Festival',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (13,	0,	8,	16,	'추석',	'Harvest Festival',	1,	1,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (14,	0,	10,	3,	'개천절',	'National Foundation Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (15,	0,	10,	9,	'한글날',	'Hangeul Day',	1,	0,	NULL);
INSERT INTO ECMS_SCHEDULE_HOLIDAY (SH_ID, SH_YEAR, SH_MONTH, SH_DAY, SH_TITLE_KR, SH_TITLE_EN, SH_RECUR, SH_LUNAR, SH_MEMO) VALUES (16,	0,	12,	25,	'크리스마스',	'Christmas Day',	1,	0,	NULL);

-- CODE_CATEGORY
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('AIRPORT',	'공항',	'',	TO_DATE('2014-08-18 09:59:35', 'YYYY-MM-DD HH24:MI:SS'),	'Airport');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('COUNTRY',	'국가코드',	'국가코드',	TO_DATE('2014-07-22 16:12:02', 'YYYY-MM-DD HH24:MI:SS'),	'Country');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('DDD_NO',	'전화번호 지역번호',	'전화번호 지역번호',	TO_DATE('2014-07-22 16:12:02', 'YYYY-MM-DD HH24:MI:SS'),	'');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('MEM_LEVEL',	'회원등급',	'회원등급',	TO_DATE('2014-05-26 14:42:00', 'YYYY-MM-DD HH24:MI:SS'),	'');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('MOBILE_NO',	'휴대번호앞자리',	'휴대번호앞자리',	TO_DATE('2014-05-26 14:42:00', 'YYYY-MM-DD HH24:MI:SS'),	'');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('STATS_CODE',	'테스트 상태코드',	'테스트 상태코드',	TO_DATE('2014-05-12 13:26:36', 'YYYY-MM-DD HH24:MI:SS'),	'');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('TEST_CAT1',	'테스트카테고리1',	'테스트카테고리1',	TO_DATE('2014-05-12 13:23:33', 'YYYY-MM-DD HH24:MI:SS'),	'');
INSERT INTO ECMS_CODE_CATEGORY (CAT_ID, CAT_NAME, CAT_DESCRIPTION, CAT_REGDATE, CAT_NAME_EN) VALUES ('TEST_CAT2',	'테스트카테고리2',	'테스트카테고리2',	TO_DATE('2014-05-12 13:23:44', 'YYYY-MM-DD HH24:MI:SS'),	'');

-- CODE
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('010','MOBILE_NO','010','010','2016-08-03 13:24:54',1,'010');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('011','MOBILE_NO','011','011','2016-08-03 13:24:54',1,'011');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('016','MOBILE_NO','016','016','2016-08-03 13:24:54',1,'016');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('017','MOBILE_NO','017','017','2016-08-03 13:24:54',1,'017');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('018','MOBILE_NO','018','018','2016-08-03 13:24:54',1,'018');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('019','MOBILE_NO','019','019','2016-08-03 13:24:54',1,'019');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('02','DDD_NO','02','','2016-08-22 13:52:09',1,'02');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('031','DDD_NO','031','','2016-08-22 13:52:17',1,'031');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('032','DDD_NO','032','','2016-08-22 13:52:27',1,'032');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('033','DDD_NO','033','','2016-08-22 13:52:34',1,'033');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('041','DDD_NO','041','','2016-08-22 13:53:04',1,'041');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('042','DDD_NO','042','','2016-08-22 13:53:12',1,'042');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('043','DDD_NO','043','','2016-08-22 13:53:21',1,'043');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('051','DDD_NO','051','','2016-08-22 13:53:30',1,'051');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('052','DDD_NO','052','','2016-08-22 13:53:41',1,'052');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('053','DDD_NO','053','','2016-08-22 13:55:35',1,'053');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('054','DDD_NO','054','','2016-08-22 13:55:51',1,'054');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('055','DDD_NO','055','','2016-08-22 13:55:57',1,'055');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('061','DDD_NO','061','','2016-08-22 13:56:11',1,'061');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('062','DDD_NO','062','','2016-08-22 14:00:51',1,'062');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('063','DDD_NO','063','','2016-08-22 14:00:57',1,'063');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('064','DDD_NO','064','','2016-08-22 14:01:03',1,'064');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('065','DDD_NO','065','','2016-08-22 14:01:10',1,'065');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('070','DDD_NO','070','','2016-08-22 14:01:10',1,'070');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AD',	'COUNTRY',	'안도라',	'Andorra',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Andorra');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AE',	'COUNTRY',	'아랍 에미리트 연합국',	'United Arab Emirates',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'United Arab Emirates');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AF',	'COUNTRY',	'아프가니스탄',	'Afghanistan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Afghanistan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AG',	'COUNTRY',	'안티과 바부다',	'Antigua and Barbuda',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Antigua and Barbuda');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AI',	'COUNTRY',	'앵귈라',	'Anguilla',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Anguilla');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AL',	'COUNTRY',	'알바니아',	'Albania',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Albania');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AM',	'COUNTRY',	'아르메니아',	'Armenia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Armenia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AO',	'COUNTRY',	'앙골라',	'Angola',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Angola');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AP',	'COUNTRY',	'아시아/태평양 지역',	'Asia/Pacific Region',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Asia/Pacific Region');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AQ',	'COUNTRY',	'남극',	'Antarctica',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Antarctica');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AR',	'COUNTRY',	'아르헨티나',	'Argentina',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Argentina');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AS',	'COUNTRY',	'미국령 사모아',	'American Samoa',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'American Samoa');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AT',	'COUNTRY',	'오스트리아',	'Austria',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Austria');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AU',	'COUNTRY',	'오스트레일리아',	'Australia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Australia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AW',	'COUNTRY',	'아루바',	'Aruba',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Aruba');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AX',	'COUNTRY',	'올란드 제도',	'Aland Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Aland Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('AZ',	'COUNTRY',	'아제르바이잔',	'Azerbaijan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Azerbaijan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BA',	'COUNTRY',	'보스니아헤르체고비나',	'Bosnia and Herzegovina',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bosnia and Herzegovina');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BASIC',	'MEM_LEVEL',	'일반회원',	'',	TO_DATE('2014-05-26 14:44:28', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Basic Membership');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BB',	'COUNTRY',	'바베이도스',	'Barbados',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Barbados');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BD',	'COUNTRY',	'방글라데시',	'Bangladesh',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bangladesh');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BE',	'COUNTRY',	'벨기에',	'Belgium',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Belgium');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BF',	'COUNTRY',	'부르키나 파소',	'Burkina Faso',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Burkina Faso');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BG',	'COUNTRY',	'불가리아',	'Bulgaria',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bulgaria');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BH',	'COUNTRY',	'바레인',	'Bahrain',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bahrain');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BI',	'COUNTRY',	'부룬디',	'Burundi',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Burundi');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BJ',	'COUNTRY',	'베닌',	'Benin',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Benin');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BL',	'COUNTRY',	'생 바르텔르미',	'Saint Barthelemey',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Barthelemey');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BM',	'COUNTRY',	'버뮤다 제도',	'Bermuda',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bermuda');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BN',	'COUNTRY',	'브루나이 다루살람',	'Brunei Darussalam',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Brunei Darussalam');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BO',	'COUNTRY',	'볼리비아',	'Bolivia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bolivia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BQ',	'COUNTRY',	'네덜란드령 카리브',	'Bonaire, Saint Eustatius and Saba',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bonaire, Saint Eustatius and Saba');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BR',	'COUNTRY',	'브라질',	'Brazil',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Brazil');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BS',	'COUNTRY',	'바하마 연방',	'Bahamas',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bahamas');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BT',	'COUNTRY',	'부탄',	'Bhutan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bhutan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BV',	'COUNTRY',	'부베 섬',	'Bouvet Island',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Bouvet Island');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BW',	'COUNTRY',	'보츠와나',	'Botswana',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Botswana');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BY',	'COUNTRY',	'벨로루시',	'Belarus',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Belarus');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('BZ',	'COUNTRY',	'벨리즈',	'Belize',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Belize');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CA',	'COUNTRY',	'캐나다',	'Canada',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Canada');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CAT_1',	'TEST_CAT2',	'카테고리 1',	'카테고리 1',	TO_DATE('2014-05-12 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CAT_2',	'TEST_CAT2',	'카테고리 2',	'카테고리 2',	TO_DATE('2014-05-12 13:25:05', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CAT_A',	'TEST_CAT1',	'카테고리 A',	'카테고리 A',	TO_DATE('2014-05-12 13:24:13', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CAT_B',	'TEST_CAT1',	'카테고리 B',	'카테고리 B',	TO_DATE('2014-05-12 13:24:29', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CC',	'COUNTRY',	'코코스(킬링) 제도',	'Cocos (Keeling) Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cocos (Keeling) Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CD',	'COUNTRY',	'콩고 민주 공화국',	'Congo, The Democratic Republic of the',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Congo, The Democratic Republic of the');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CF',	'COUNTRY',	'중앙 아프리카 공화국',	'Central African Republic',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Central African Republic');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CG',	'COUNTRY',	'콩고',	'Congo',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Congo');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CH',	'COUNTRY',	'스위스',	'Switzerland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Switzerland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CHECK',	'STATS_CODE',	'접수',	'접수',	TO_DATE('2014-05-12 13:27:06', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CI',	'COUNTRY',	'코트디부아르',	'Cote d''Ivoire',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cote d''Ivoire');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CK',	'COUNTRY',	'쿡 제도',	'Cook Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cook Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CL',	'COUNTRY',	'칠레',	'Chile',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Chile');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CM',	'COUNTRY',	'카메룬',	'Cameroon',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cameroon');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CN',	'COUNTRY',	'중국',	'China',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'China');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CO',	'COUNTRY',	'콜롬비아',	'Colombia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Colombia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('COMPLETE',	'STATS_CODE',	'완료',	'완료',	TO_DATE('2014-05-12 13:27:26', 'YYYY-MM-DD HH24:MI:SS'),	1,	'');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CR',	'COUNTRY',	'코스타리카',	'Costa Rica',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Costa Rica');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CU',	'COUNTRY',	'쿠바',	'Cuba',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cuba');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CV',	'COUNTRY',	'카보베르데',	'Cape Verde',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cape Verde');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CW',	'COUNTRY',	'큐라소',	'Curacao',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Curacao');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CX',	'COUNTRY',	'크리스마스 섬',	'Christmas Island',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Christmas Island');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CY',	'COUNTRY',	'키프로스',	'Cyprus',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cyprus');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('CZ',	'COUNTRY',	'체코',	'Czech Republic',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Czech Republic');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DE',	'COUNTRY',	'독일',	'Germany',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Germany');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DJ',	'COUNTRY',	'지부티',	'Djibouti',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Djibouti');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DK',	'COUNTRY',	'덴마크',	'Denmark',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Denmark');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DM',	'COUNTRY',	'도미니카 연방',	'Dominica',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Dominica');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DO',	'COUNTRY',	'도미니카 공화국',	'Dominican Republic',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Dominican Republic');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('DZ',	'COUNTRY',	'알제리',	'Algeria',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Algeria');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('EC',	'COUNTRY',	'에콰도르',	'Ecuador',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ecuador');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('EE',	'COUNTRY',	'에스토니아',	'Estonia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Estonia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('EG',	'COUNTRY',	'이집트',	'Egypt',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Egypt');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('EH',	'COUNTRY',	'서부 사하라',	'Western Sahara',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Western Sahara');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ER',	'COUNTRY',	'에리트레아',	'Eritrea',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Eritrea');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ES',	'COUNTRY',	'스페인',	'Spain',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Spain');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ET',	'COUNTRY',	'에티오피아',	'Ethiopia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ethiopia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('EU',	'COUNTRY',	'유럽',	'Europe',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Europe');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FI',	'COUNTRY',	'핀란드',	'Finland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Finland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FJ',	'COUNTRY',	'피지',	'Fiji',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Fiji');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FK',	'COUNTRY',	'포클랜드 제도',	'Falkland Islands (Malvinas)',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Falkland Islands (Malvinas)');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FM',	'COUNTRY',	'미크로네시아 연방',	'Micronesia, Federated States of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Micronesia, Federated States of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FO',	'COUNTRY',	'페로 제도',	'Faroe Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Faroe Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('FR',	'COUNTRY',	'프랑스',	'France',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'France');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GA',	'COUNTRY',	'가봉',	'Gabon',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gabon');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GB',	'COUNTRY',	'영국',	'United Kingdom',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'United Kingdom');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GD',	'COUNTRY',	'그레나다',	'Grenada',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Grenada');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GE',	'COUNTRY',	'그루지야',	'Georgia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Georgia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GF',	'COUNTRY',	'프랑스령 기아나',	'French Guiana',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'French Guiana');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GG',	'COUNTRY',	'건지 섬',	'Guernsey',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guernsey');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GH',	'COUNTRY',	'가나',	'Ghana',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ghana');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GI',	'COUNTRY',	'지브롤터',	'Gibraltar',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gibraltar');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GL',	'COUNTRY',	'그린란드',	'Greenland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Greenland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GM',	'COUNTRY',	'감비아',	'Gambia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gambia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GN',	'COUNTRY',	'기니',	'Guinea',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guinea');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GP',	'COUNTRY',	'과들루프',	'Guadeloupe',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guadeloupe');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GQ',	'COUNTRY',	'적도 기니',	'Equatorial Guinea',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Equatorial Guinea');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GR',	'COUNTRY',	'그리스',	'Greece',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Greece');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GS',	'COUNTRY',	'사우스 조지아 및 사우스 샌드위치 제도',	'South Georgia and the South Sandwich Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'South Georgia and the South Sandwich Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GT',	'COUNTRY',	'과테말라',	'Guatemala',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guatemala');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GU',	'COUNTRY',	'괌',	'Guam',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guam');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GW',	'COUNTRY',	'기니비사우',	'Guinea-Bissau',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guinea-Bissau');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('GY',	'COUNTRY',	'가이아나',	'Guyana',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Guyana');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HK',	'COUNTRY',	'홍콩',	'Hong Kong',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Hong Kong');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HM',	'COUNTRY',	'허드 섬 및 맥도널드 제도',	'Heard Island and McDonald Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Heard Island and McDonald Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HN',	'COUNTRY',	'온두라스',	'Honduras',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Honduras');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HR',	'COUNTRY',	'크로아티아',	'Croatia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Croatia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HT',	'COUNTRY',	'아이티',	'Haiti',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Haiti');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('HU',	'COUNTRY',	'헝가리',	'Hungary',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Hungary');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ID',	'COUNTRY',	'인도네시아',	'Indonesia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Indonesia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IE',	'COUNTRY',	'아일랜드',	'Ireland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ireland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IL',	'COUNTRY',	'이스라엘',	'Israel',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Israel');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IM',	'COUNTRY',	'만 섬',	'Isle of Man',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Isle of Man');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IN',	'COUNTRY',	'인도',	'India',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'India');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IO',	'COUNTRY',	'영국령 인도양 식민지',	'British Indian Ocean Territory',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'British Indian Ocean Territory');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IQ',	'COUNTRY',	'이라크',	'Iraq',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Iraq');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IR',	'COUNTRY',	'이란 이슬람 공화국',	'Iran, Islamic Republic of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Iran, Islamic Republic of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IS',	'COUNTRY',	'아이슬란드',	'Iceland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Iceland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('IT',	'COUNTRY',	'이탈리아',	'Italy',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Italy');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('JE',	'COUNTRY',	'저지 섬',	'Jersey',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Jersey');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('JM',	'COUNTRY',	'자메이카',	'Jamaica',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Jamaica');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('JO',	'COUNTRY',	'요르단',	'Jordan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Jordan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('JP',	'COUNTRY',	'일본',	'Japan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Japan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KE',	'COUNTRY',	'케냐',	'Kenya',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Kenya');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KG',	'COUNTRY',	'키르기스스탄',	'Kyrgyzstan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Kyrgyzstan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KH',	'COUNTRY',	'캄보디아',	'Cambodia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cambodia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KI',	'COUNTRY',	'키리바시',	'Kiribati',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Kiribati');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KM',	'COUNTRY',	'코모로',	'Comoros',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Comoros');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KN',	'COUNTRY',	'세인트 키츠 네비스',	'Saint Kitts and Nevis',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Kitts and Nevis');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KP',	'COUNTRY',	'조선 민주주의 인민공화국',	'Korea, Democratic People''s Republic of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Korea, Democratic People''s Republic of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KR',	'COUNTRY',	'대한민국',	'Korea, Republic of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Korea, Republic of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KW',	'COUNTRY',	'쿠웨이트',	'Kuwait',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Kuwait');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KY',	'COUNTRY',	'케이맨 제도',	'Cayman Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cayman Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('KZ',	'COUNTRY',	'카자흐스탄',	'Kazakhstan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Kazakhstan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LA',	'COUNTRY',	'라오스',	'Lao People''s Democratic Republic',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Lao People''s Democratic Republic');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LB',	'COUNTRY',	'레바논',	'Lebanon',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Lebanon');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LC',	'COUNTRY',	'세인트루시아',	'Saint Lucia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Lucia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LI',	'COUNTRY',	'리히텐슈타인',	'Liechtenstein',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Liechtenstein');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LK',	'COUNTRY',	'스리랑카',	'Sri Lanka',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sri Lanka');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LR',	'COUNTRY',	'라이베리아',	'Liberia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Liberia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LS',	'COUNTRY',	'레소토',	'Lesotho',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Lesotho');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LT',	'COUNTRY',	'리투아니아',	'Lithuania',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Lithuania');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LU',	'COUNTRY',	'룩셈부르크',	'Luxembourg',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Luxembourg');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LV',	'COUNTRY',	'라트비아',	'Latvia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Latvia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('LY',	'COUNTRY',	'리비아',	'Libyan Arab Jamahiriya',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Libyan Arab Jamahiriya');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MA',	'COUNTRY',	'모로코',	'Morocco',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Morocco');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MC',	'COUNTRY',	'모나코',	'Monaco',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Monaco');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MD',	'COUNTRY',	'몰도바',	'Moldova, Republic of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Moldova, Republic of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ME',	'COUNTRY',	'몬테크로',	'Montenegro',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Montenegro');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MF',	'COUNTRY',	'세인트 마틴',	'Saint Martin',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Martin');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MG',	'COUNTRY',	'마다가스카르',	'Madagascar',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Madagascar');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MH',	'COUNTRY',	'마샬 제도',	'Marshall Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Marshall Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MK',	'COUNTRY',	'마케도니아',	'Macedonia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Macedonia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ML',	'COUNTRY',	'말리',	'Mali',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mali');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MM',	'COUNTRY',	'미얀마',	'Myanmar',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Myanmar');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MN',	'COUNTRY',	'몽골',	'Mongolia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mongolia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MO',	'COUNTRY',	'마카오',	'Macao',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Macao');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MP',	'COUNTRY',	'북마리아나 제도',	'Northern Mariana Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Northern Mariana Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MQ',	'COUNTRY',	'마르티니크',	'Martinique',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Martinique');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MR',	'COUNTRY',	'모리타니아',	'Mauritania',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mauritania');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MS',	'COUNTRY',	'몬트세렛',	'Montserrat',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Montserrat');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MT',	'COUNTRY',	'몰타',	'Malta',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Malta');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MU',	'COUNTRY',	'모리셔스',	'Mauritius',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mauritius');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MV',	'COUNTRY',	'몰디브',	'Maldives',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Maldives');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MW',	'COUNTRY',	'말라위',	'Malawi',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Malawi');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MX',	'COUNTRY',	'멕시코',	'Mexico',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mexico');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MY',	'COUNTRY',	'말레이시아',	'Malaysia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Malaysia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('MZ',	'COUNTRY',	'모잠비크',	'Mozambique',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mozambique');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NA',	'COUNTRY',	'나미비아',	'Namibia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Namibia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NC',	'COUNTRY',	'뉴 칼레도니아 섬',	'New Caledonia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'New Caledonia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NE',	'COUNTRY',	'니제르',	'Niger',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Niger');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NF',	'COUNTRY',	'노퍽 섬',	'Norfolk Island',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Norfolk Island');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NG',	'COUNTRY',	'나이지리아',	'Nigeria',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Nigeria');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NI',	'COUNTRY',	'니카라과',	'Nicaragua',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Nicaragua');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NL',	'COUNTRY',	'네덜란드',	'Netherlands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Netherlands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NO',	'COUNTRY',	'노르웨이',	'Norway',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Norway');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NP',	'COUNTRY',	'네팔',	'Nepal',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Nepal');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NR',	'COUNTRY',	'나우루',	'Nauru',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Nauru');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NU',	'COUNTRY',	'니우에',	'Niue',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Niue');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('NZ',	'COUNTRY',	'뉴질랜드',	'New Zealand',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'New Zealand');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('O1',	'COUNTRY',	'기타',	'Other Country',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Other Country');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('OM',	'COUNTRY',	'오만',	'Oman',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Oman');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PA',	'COUNTRY',	'파나마',	'Panama',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Panama');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TEST',	'MEM_LEVEL',	'테스트회원',	'',	TO_DATE('2014-05-26 14:44:57', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Test Membership');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PE',	'COUNTRY',	'페루',	'Peru',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Peru');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PF',	'COUNTRY',	'프랑스령 폴리네시아',	'French Polynesia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'French Polynesia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PG',	'COUNTRY',	'파푸아뉴기니',	'Papua New Guinea',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Papua New Guinea');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PH',	'COUNTRY',	'필리핀',	'Philippines',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Philippines');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PK',	'COUNTRY',	'파키스탄',	'Pakistan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Pakistan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PL',	'COUNTRY',	'폴란드',	'Poland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Poland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PM',	'COUNTRY',	'생 피에르 미클롱',	'Saint Pierre and Miquelon',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Pierre and Miquelon');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PN',	'COUNTRY',	'핏케언 섬',	'Pitcairn',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Pitcairn');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PR',	'COUNTRY',	'푸에르토리코',	'Puerto Rico',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Puerto Rico');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PS',	'COUNTRY',	'팔레스타인',	'Palestinian Territory',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Palestinian Territory');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PT',	'COUNTRY',	'포르투갈',	'Portugal',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Portugal');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PW',	'COUNTRY',	'팔라우',	'Palau',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Palau');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('PY',	'COUNTRY',	'파라과이',	'Paraguay',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Paraguay');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('QA',	'COUNTRY',	'카타르',	'Qatar',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Qatar');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RE',	'COUNTRY',	'Reunion',	'Reunion',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Reunion');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKJB',	'AIRPORT',	'무안국제공항',	'',	TO_DATE('2014-08-18 10:01:02', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Muan International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKJJ',	'AIRPORT',	'광주공항',	'',	TO_DATE('2014-08-18 10:01:39', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gwangju Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKJK',	'AIRPORT',	'군산공항',	'',	TO_DATE('2014-08-18 10:02:15', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gunsan Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKJY',	'AIRPORT',	'여수공항',	'',	TO_DATE('2014-08-18 10:02:42', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Yeosu Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKNW',	'AIRPORT',	'원주공항',	'',	TO_DATE('2014-08-18 10:07:43', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Wonju Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKNY',	'AIRPORT',	'양양국제공항',	'',	TO_DATE('2014-08-18 10:07:12', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Yangyang International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKPC',	'AIRPORT',	'제주국제공항',	'',	TO_DATE('2014-08-18 10:03:05', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Jeju International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKPK',	'AIRPORT',	'김해국제공항',	'',	TO_DATE('2014-08-18 10:03:45', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gimhae International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKPS',	'AIRPORT',	'사천공항',	'',	TO_DATE('2014-08-18 10:04:09', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sacheon Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKPU',	'AIRPORT',	'울산공항',	'',	TO_DATE('2014-08-18 10:04:38', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ulsan Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKSI',	'AIRPORT',	'인천국제공항',	'',	TO_DATE('2014-08-18 10:04:58', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Incheon International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKSS',	'AIRPORT',	'김포국제공항',	'',	TO_DATE('2014-08-18 10:05:19', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Gimpo International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKTH',	'AIRPORT',	'포항공항',	'',	TO_DATE('2014-08-18 10:06:03', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Pohang Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKTN',	'AIRPORT',	'대구국제공항',	'',	TO_DATE('2014-08-18 10:06:27', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Daegu International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RKTU',	'AIRPORT',	'청주국제공항',	'',	TO_DATE('2014-08-18 10:06:48', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Cheongju International Airport');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RO',	'COUNTRY',	'루마니아',	'Romania',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Romania');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RS',	'COUNTRY',	'세르비아',	'Serbia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Serbia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RU',	'COUNTRY',	'러시아 연방',	'Russian Federation',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Russian Federation');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('RW',	'COUNTRY',	'르완다',	'Rwanda',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Rwanda');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SA',	'COUNTRY',	'사우디아라비아',	'Saudi Arabia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saudi Arabia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SB',	'COUNTRY',	'솔로몬 제도',	'Solomon Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Solomon Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SC',	'COUNTRY',	'세이셸',	'Seychelles',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Seychelles');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SD',	'COUNTRY',	'수단',	'Sudan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sudan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SE',	'COUNTRY',	'스웨덴',	'Sweden',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sweden');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SG',	'COUNTRY',	'싱가폴',	'Singapore',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Singapore');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SH',	'COUNTRY',	'세인트헬레나',	'Saint Helena',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Helena');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SI',	'COUNTRY',	'슬로베니아',	'Slovenia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Slovenia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SJ',	'COUNTRY',	'스발바르 얀마옌 제도',	'Svalbard and Jan Mayen',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Svalbard and Jan Mayen');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SK',	'COUNTRY',	'슬로바키아',	'Slovakia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Slovakia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SL',	'COUNTRY',	'시에라리온',	'Sierra Leone',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sierra Leone');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SM',	'COUNTRY',	'산마리노',	'San Marino',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'San Marino');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SN',	'COUNTRY',	'세네갈',	'Senegal',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Senegal');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SO',	'COUNTRY',	'소말리아',	'Somalia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Somalia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SOCIAL',	'MEM_LEVEL',	'소셜회원',	'소셜회원',	TO_DATE('2015-02-02 14:38:40', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Social MemberShip');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SR',	'COUNTRY',	'수리남',	'Suriname',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Suriname');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SS',	'COUNTRY',	'남수단',	'South Sudan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'South Sudan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ST',	'COUNTRY',	'상투메프린시페',	'Sao Tome and Principe',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sao Tome and Principe');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SV',	'COUNTRY',	'엘살바도르',	'El Salvador',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'El Salvador');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SX',	'COUNTRY',	'세인트 마틴(네덜란드)',	'Sint Maarten',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Sint Maarten');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SY',	'COUNTRY',	'시리아',	'Syrian Arab Republic',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Syrian Arab Republic');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('SZ',	'COUNTRY',	'스와질란드',	'Swaziland',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Swaziland');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TC',	'COUNTRY',	'터크스케이코스 제도',	'Turks and Caicos Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Turks and Caicos Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TD',	'COUNTRY',	'차드',	'Chad',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Chad');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TF',	'COUNTRY',	'프랑스령 남부와 남극 지역',	'French Southern Territories',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'French Southern Territories');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TG',	'COUNTRY',	'토고',	'Togo',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Togo');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TH',	'COUNTRY',	'태국',	'Thailand',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Thailand');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TJ',	'COUNTRY',	'타지키스탄',	'Tajikistan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tajikistan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TK',	'COUNTRY',	'토켈라우',	'Tokelau',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tokelau');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TL',	'COUNTRY',	'동티모르',	'Timor-Leste',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Timor-Leste');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TM',	'COUNTRY',	'투르크메니스탄',	'Turkmenistan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Turkmenistan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TN',	'COUNTRY',	'튀니지',	'Tunisia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tunisia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TO',	'COUNTRY',	'통가',	'Tonga',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tonga');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TR',	'COUNTRY',	'터비',	'Turkey',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Turkey');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TT',	'COUNTRY',	'트리니다드 토바고',	'Trinidad and Tobago',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Trinidad and Tobago');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TV',	'COUNTRY',	'투발루',	'Tuvalu',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tuvalu');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TW',	'COUNTRY',	'대만',	'Taiwan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Taiwan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('TZ',	'COUNTRY',	'탄자니아',	'Tanzania, United Republic of',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Tanzania, United Republic of');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('UA',	'COUNTRY',	'우크라이나',	'Ukraine',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Ukraine');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('UG',	'COUNTRY',	'우간다',	'Uganda',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Uganda');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('UM',	'COUNTRY',	'미국령 군소 제도',	'United States Minor Outlying Islands',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'United States Minor Outlying Islands');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('US',	'COUNTRY',	'미국',	'United States',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'United States');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('UY',	'COUNTRY',	'우루과이',	'Uruguay',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Uruguay');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('UZ',	'COUNTRY',	'우즈베키스탄',	'Uzbekistan',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Uzbekistan');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VA',	'COUNTRY',	'교황청(바티칸)',	'Holy See (Vatican City State)',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Holy See (Vatican City State)');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VC',	'COUNTRY',	'세인트 빈센트 그레나딘',	'Saint Vincent and the Grenadines',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Saint Vincent and the Grenadines');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VE',	'COUNTRY',	'베네수엘라',	'Venezuela',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Venezuela');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VG',	'COUNTRY',	'버진 아일랜드(영)',	'Virgin Islands, British',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Virgin Islands, British');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VI',	'COUNTRY',	'버진 아일랜드(미)',	'Virgin Islands, U.S.',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Virgin Islands, U.S.');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VIP',	'MEM_LEVEL',	'VIP',	'',	TO_DATE('2014-05-26 14:45:15', 'YYYY-MM-DD HH24:MI:SS'),	1,	'VIP Membership');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VN',	'COUNTRY',	'베트남',	'Vietnam',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Vietnam');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('VU',	'COUNTRY',	'바누아투',	'Vanuatu',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Vanuatu');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('WF',	'COUNTRY',	'월리스푸투나 제도',	'Wallis and Futuna',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Wallis and Futuna');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('WS',	'COUNTRY',	'사모아',	'Samoa',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Samoa');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('YE',	'COUNTRY',	'예맨',	'Yemen',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Yemen');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('YT',	'COUNTRY',	'마요트',	'Mayotte',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Mayotte');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ZA',	'COUNTRY',	'남아프리카 공화국',	'South Africa',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'South Africa');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ZM',	'COUNTRY',	'잠비아',	'Zambia',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Zambia');
INSERT INTO ECMS_CODE (CODE_ID, CAT_ID, CODE_NAME, CODE_DESCRIPTION, CODE_REGDATE, CODE_USE, CODE_NAME_EN) VALUES ('ZW',	'COUNTRY',	'짐바브웨',	'Zimbabwe',	TO_DATE('2014-07-21 13:24:54', 'YYYY-MM-DD HH24:MI:SS'),	1,	'Zimbabwe');

COMMIT;