consentFatima/mplus-fatima/script/sample_Data_Oracle_Table_For_MPlus.sql

--------------------------------------------------------
--  샘플 데이터
--  EX : 테스트 등을 위한 샘플 데이터 이며 SEQ를 맞추는 작업 및 실데이터 정리 작업 등 필요
--------------------------------------------------------
REM INSERTING into MP_API_CATEGORY
SET DEFINE OFF;
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (1,'가셔야 할 곳',null,null,'roadlist',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (2,'검사결과','검사결과 ',null,'totalexam',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (4,'도우미 화면','도우미에서 사용할 용도 만드는 API 집합',null,'helper',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (5,'도우미용 Push','도우미 push 관련 ',null,'helperpush',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (7,'동의서','동의서 카테고리',null,'agreement',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (9,'사용자관리','사용자 관리를 위한 API집합',null,'user',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (11,'앱관리','등록된 최신 앱 버전 확인',null,'app',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (13,'전화번호',null,null,'telno',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (21,'로그인',null,9,'login',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (22,'비밀번호',null,9,'password',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (23,'사용자정보',null,9,'userinfo',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (24,'토큰',null,9,'tokens',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (29,'_실험용모음','언제 없어질지 모르는 실험용 API들의 모임 ',null,'test',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)');
REM INSERTING into MP_API
SET DEFINE OFF;
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (9,'SQL','mplusExtDataSource',null,'PUT','30_결제알림',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, 
FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) 
VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'', 
''paymentSuccess'', :userId, :userName, :messageValue, :stageOrder, :senderId)','INT','payment',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (34,'SQL','mplusDataSource',null,'POST','토큰추가',null,'INSERT INTO MNS_RECEIVER_DEVICE (RECEIVER_ID, DEVICE_TOKEN_ID, PLATFORM_TYPE, CERT_TYPE) 
VALUES (:receiverId, :deviceTokenId, :platformType, :certType)','INT','saveDeviceToken',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (2,'WEB_SERVICE',null,'examResult : 검사결과 
examNm : 검사명 
examGrpNm : 검사분류 
referenceVal : 참고치 
date : 검사날짜 ','POST','검사결과목록',null,null,'LIST','getExamList','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00017&business_id=com&hospitalCd=031&userId={userId}&startDt={startDt}&endDt={endDt}
',2,'/totalexam/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (4,'SQL','mplusDataSource',null,'GET','Action 가져오기',null,'SELECT  USER_MSG  
FROM MP_HELPER_CONTENTS 
WHERE HELPER_SEQ=:accessSeq AND TO_CHAR(SEND_DT, ''ss'')=:accessKey','MAP','getAction',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (19,'SQL','mplusDataSource',null,'PUT','로그인실패횟수증가',null,'UPDATE MP_USER 
SET LOGIN_FAIL_CNT = (SELECT LOGIN_FAIL_CNT + 1 FROM MP_USER WHERE USER_ID=:userId) 
WHERE USER_ID =:userId','INT','incLoginFailCnt',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (23,'SQL','mplusDataSource',null,'GET','비밀번호 확인',null,'SELECT 
CASE WHEN COUNT(*) = 0 THEN ''false''
           ELSE ''true'' END AS validPassword 
FROM MP_USER 
WHERE USER_ID=:userId 
AND PASSWORD_VALUE=:passwordValue','MAP','checkPWD',null,22,'/user/password/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (36,'SQL','mplusDataSource',null,'GET','앱이름과 버전확인',null,'SELECT 
  PLATFORM_TYPE, CERT_TYPE, VERSION_ORDER, VERSION_ORDER AS VERSION_VALUE, 
  APP_NAME, MARKET_URL 
FROM MP_VERSION 
WHERE PLATFORM_TYPE=:platformType AND APP_NAME=:appName AND CERT_TYPE=:certType','MAP','checkAppNameVersion',null,11,'/app/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (51,'SQL','mplusExtDataSource',null,'PUT','PUSH_텍스트전송',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, 
FORM_ID, HOSPITAL_VALUE, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) 
VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, 
:guide, ''031'', :userId, :userName, :messageValue, :stageOrder, :pgubn)','INT','sendPushText',null,29,'/test/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (1,'WEB_SERVICE',null,null,'POST','가셔야할곳',null,null,'LIST','getVisitInfo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00015&business_id=com&hospitalCd=031&userId={userId}',1,'/roadlist/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (8,'WEB_SERVICE',null,null,'POST','10_웰컴처리',null,null,'MAP','arrival','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00035&business_id=com&hospitalCd=031&userId={userId}',5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (13,'SQL','mplusDataSource',null,'GET','14세 미만 최신동의서 조회',null,'SELECT
AGREEMENT_SEQ,
AGREEMENT_ID,
VERSION_NUMBER,
AGREEMENT_ORDER,
AGREEMENT_NAME,
AGREEMENT_CL,
ENABLED_YN,
REQUIRED_YN,
NEW_YN, 
TYPE_NAME 
FROM MP_AGREEMENT
WHERE NEW_YN = ''Y'' AND 
      ENABLED_YN = ''Y'' AND
      TYPE_NAME = ''UNDER14'' AND
      AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ 
                            FROM MP_USER_AGREEMENT 
                            WHERE USER_ID=:userId)','LIST','getUnder14NewAgreementList',null,7,'/agreement/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (24,'SQL','mplusDataSource',null,'GET','M_사용자 동의서 조회',null,'SELECT
    AGREE.AGREEMENT_SEQ,
    AGREE.AGREEMENT_ORDER,
    AGREE.AGREEMENT_NAME,
    AGREE.AGREEMENT_CL,
    AGREE.AGREEMENT_ID,
    AGREE.VERSION_NUMBER,
    AGREE.REQUIRED_YN,
    AGREE.ENABLED_YN,
    AGREE.NEW_YN,
    AGREE.TYPE_NAME,
    USERAGREE.AGREEMENT_YN,
    USERAGREE.REGISTER_DT
  FROM
    MP_AGREEMENT AGREE,
    (
      SELECT
        USERAGR.USER_AGREEMENT_SEQ,
        USERAGR.AGREEMENT_SEQ,
        USERAGR.USER_ID,
        USERAGR.AGREEMENT_YN,
        USERAGR.REGISTER_DT
      FROM
        MP_USER_AGREEMENT USERAGR,
        (
          SELECT
            AGREEMENT_ID, MAX(USER_AGREEMENT_SEQ) AS USER_AGREEMENT_SEQ
          FROM
            MP_USER_AGREEMENT
          WHERE
            USER_ID=:userId
          GROUP BY AGREEMENT_ID
        ) NEWUSERAGR
      WHERE
        USERAGR.USER_AGREEMENT_SEQ = NEWUSERAGR.USER_AGREEMENT_SEQ
    ) USERAGREE
  WHERE
    AGREE.AGREEMENT_SEQ = USERAGREE.AGREEMENT_SEQ','LIST','getUserAgreementList',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (25,'SQL','mplusDataSource','사용자 ID를 이용해서 등록된 사용자 정보를 조회한다. ','GET','M_사용자 등록정보 조회',null,'SELECT USER_ID, LOGIN_FAIL_CNT, PASSWORD_VALUE, PASSWORD_UPDATE_DT, LOCAL_CIPHER_KEY_VALUE, USE_ATTR_ORDER 
FROM MP_USER 
WHERE USER_ID=:userId','MAP','getLoginInfo',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (26,'SQL','mplusDataSource','- 등록된 모든 사용자 ID를 조회 
- 이 API는 통계에서 사용됨','GET','M_사용자 ID목록',null,'SELECT USER_ID 
FROM MP_USER','LIST','getUserIdList',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/08/08','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (27,'WEB_SERVICE',null,'3개의 값은 선택적으로 입력됨 ','POST','사용자 ID 찾기',null,null,'MAP','findPid','SELECT * 
FROM MP_DEMO_USER
WHERE USER_NAME=:userName AND TELNO_VALUE=:cellphoneNo',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (28,'SQL','mplusDataSource',null,'GET','사용자 정보 조회',null,'SELECT 
  USER_ID, 
  USER_NAME AS USER_NAME, 
  TELNO_VALUE AS CELLPHONE_NO, 
  INHOSPITAL_YN AS IN_HOSPITAL_YN, 
  ZIPCODE_TXT_VALUE AS ZIP_CODE_TXT, 
  ZIPCODE_VALUE AS ZIP_CODE, 
  ADDR_VALUE AS ADDRESS, 
  GENDER_VALUE AS GENDER_CD, 
  TO_CHAR(BIRTHDAY_DT, ''yyyyMMdd'') AS BIRTH_DT, 
  CARNO_VALUE AS VEHICLE_NO 
FROM MP_DEMO_USER
WHERE USER_ID=:userId','MAP','getUserInfo','SELECT * 
FROM MP_DEMO_USER 
WHERE USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/08/08','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (29,'SQL','mplusDataSource',null,'PUT','사용자 주소 수정',null,'UPDATE MP_DEMO_USER 
  SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address 
WHERE 
  USER_ID=:userId','INT','updateAddress','UPDATE MP_DEMO_USER 
  SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address 
WHERE 
  USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (30,'SQL','mplusDataSource',null,'PUT','사용자 전화번호 수정',null,'UPDATE MP_DEMO_USER
  SET TELNO_VALUE=:cellphoneNo 
WHERE USER_ID=:userId','INT','updateTelNo','UPDATE MP_DEMO_USER 
  SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address 
WHERE 
  USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (31,'SQL','mplusDataSource','사용자의 차량번호 수정 ','PUT','차량번호 수정',null,'UPDATE MP_DEMO_USER 
SET CARNO_VALUE=:vehicleNo  
WHERE USER_ID=:userId ','INT','updateVehicleNo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TXZIF00010&business_id=com&hospitalCd=031&userId={userId}&vehicleNo={vehicleNo}',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (44,'SQL','mplusDataSource',null,'GET','전화번호 목록',null,'SELECT BUILDING_DESC, ROOM_DESC, TEL_VALUE, TELNO_ORDER 
FROM MP_TELNO 
ORDER BY TELNO_ORDER ASC ','LIST','getList',null,13,'/telno/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (3,'WEB_SERVICE',null,null,'POST','혈당_키_몸무게',null,null,'MAP','getPersonHealthInfo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00018&hospitalCd=031&business_id=com&userId={userId}',2,'/totalexam/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (5,'SQL','mplusDataSource',null,'GET','도우미메시지',null,'SELECT  HELPER_SEQ, USER_MSG, TO_CHAR(SEND_DT, ''yyyy-MM-dd HH24:MI:ss'') AS SEND_DT 
FROM MP_HELPER_CONTENTS  
WHERE USER_ID=:userId AND TO_CHAR(SEND_DT, ''yyyyMMdd'') BETWEEN :startDate AND :endDate 
ORDER BY SEND_DT ASC','LIST','messageList',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (6,'SQL','mplusDataSource',null,'DELETE','메시지 삭제',null,'DELETE FROM MP_HELPER_CONTENTS 
WHERE TO_CHAR(SEND_DT, ''yyyyMMdd'')<=:deleteDay','INT','deleteContents',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (7,'SQL','mplusDataSource',null,'PUT','00_탈퇴안내',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, 
FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) 
VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, 
''SEOUL'', ''guide'',  :userId, :userName, :messageValue, 0, :senderId)','INT','withdrawal',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (10,'SQL','mplusExtDataSource',null,'PUT','30_결제취소알림',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, 
FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) 
VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'', 
''paymentCancelSuccess'', :userId, :userName, :messageValue, :stageOrder, :senderId)','INT','paymentCancel',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (14,'SQL','mplusDataSource',null,'GET','최신 동의서 조회',null,'SELECT
AGREEMENT_SEQ,
AGREEMENT_ID,
VERSION_NUMBER,
AGREEMENT_ORDER,
AGREEMENT_NAME,
AGREEMENT_CL,
ENABLED_YN,
REQUIRED_YN,
NEW_YN,
TYPE_NAME 
FROM MP_AGREEMENT
WHERE NEW_YN = ''Y'' AND 
      ENABLED_YN = ''Y'' AND
      TYPE_NAME = ''ALL'' AND
      AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ 
                            FROM MP_USER_AGREEMENT 
                            WHERE USER_ID=:userId)','LIST','getNewAgreementList',null,7,'/agreement/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (20,'SQL','mplusDataSource',null,'PUT','로그인실패횟수초기화',null,'UPDATE MP_USER
SET LOGIN_FAIL_CNT=0
WHERE USER_ID=:userId','INT','clearLoginFailCnt',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (21,'SQL','mplusDataSource',null,'GET','최근로그인조회',null,'SELECT 
  A.USER_ID, A.LAST_ACCESS_DAY, A.REGISTER_DAY 
FROM (
  SELECT 
    U.USER_ID, 
    CAST(SYSDATE - HJ.ACCESS_DT AS INTEGER) AS LAST_ACCESS_DAY,  
    CAST(SYSDATE - U.REGISTER_DT AS INTEGER) AS REGISTER_DAY 
  FROM MP_USER U 
  LEFT JOIN (
    SELECT DISTINCT(H.USER_ID) AS USER_ID, MAX(H.ACCESS_DT) AS ACCESS_DT   
    FROM MP_ACCESS_HISTORY H 
    GROUP BY H.USER_ID ) HJ 
  ON U.USER_ID=HJ.USER_ID) A 
WHERE A.LAST_ACCESS_DAY = :baseDay OR A.REGISTER_DAY = :baseDay','LIST','getAccessDay',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin');
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (22,'SQL','mplusDataSource',null,'PUT','비밀번호 변경',null,'UPDATE MP_USER
SET PASSWORD_VALUE=:passwordValue,
       LOGIN_FAIL_CNT=0,
       PASSWORD_UPDATE_DT=SYSDATE
WHERE
       USER_ID=:userId','INT','resetPWD',null,22,'/user/password/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (32,'SQL','mplusDataSource',null,'GET','사용자 토큰조회',null,'SELECT DEVICE_TOKEN_ID 
FROM MNS_RECEIVER_DEVICE 
WHERE RECEIVER_ID=:userId','LIST','getUserDeviceTokens',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (33,'SQL','mplusDataSource',null,'GET','토큰등록여부확인',null,'SELECT COUNT(1)  AS USER_CNT 
FROM MNS_RECEIVER_DEVICE 
WHERE 
DEVICE_TOKEN_ID=:deviceTokenId AND 
RECEIVER_ID=:receiverId AND 
PLATFORM_TYPE=:platformType AND 
CERT_TYPE=:certType','MAP','checkDeviceToken',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (35,'SQL','mplusDataSource',null,'GET','버전확인',null,'SELECT * 
FROM MP_VERSION 
WHERE PLATFORM_TYPE=:platformType','MAP','checkAppVersion',null,11,'/app/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (82,'SQL','mplusDataSource',null,'GET','사용자 속성 목록',null,'SELECT 
    MAU.USER_ID AS USER_ID,
    (SELECT USER_NAME FROM MP_USER WHERE USER_ID = MAU.USER_ID) AS USER_NAME,
    MAU.USER_ATTR_ORDER AS USER_ATTR_ORDER,
    MAU.HOSPITAL_ID AS HOSPITAL_ID,
    (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''hospital'' AND MP_ATTR.ATTR_ID = MAU.HOSPITAL_ID) AS HOSPITAL_NAME,
		MAU.DUTY_ID AS DUTY_ID,
    (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''duty'' AND MP_ATTR.ATTR_ID = MAU.DUTY_ID) AS DUTY_NAME,
    MAU.WORK_ID AS WORK_ID,
    (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''work'' AND MP_ATTR.ATTR_ID = MAU.WORK_ID) AS WORK_NAME
FROM 
    MP_USER_ATTR MAU
WHERE
    MAU.USER_ID = :userId','LIST','getUserAttrList',null,23,'/user/userinfo/',to_date('16/08/08','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),null);
Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (162,'SQL','mplusDataSource',null,'POST','사용자 속성 정보 수정',null,'UPDATE 
       MP_USER
SET
     USE_ATTR_ORDER = :useAttrOrder
WHERE
    USER_ID = :userId','INT','updateUseAttrOrder',null,23,'/user/userinfo/',to_date('16/08/10','RR/MM/DD'),'admin',to_date('16/08/10','RR/MM/DD'),'admin');

REM INSERTING into MP_API_HEADER
SET DEFINE OFF;
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (6,2,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (8,8,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (7,3,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (36,29,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (38,31,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (5,1,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (1,27,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (2,30,'Accept','application/json');
Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (21,28,'Accept','application/json');

REM INSERTING into MP_API_PARAM
SET DEFINE OFF;
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,25,'STRING',null,'userId','1512202');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,23,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,23,'STRING','SHA256해쉬(솔트적용)','passwordValue',null);
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,13,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,14,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,2,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,8,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,2,'STRING',null,'startDt','20160101');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,2,'STRING',null,'endDt','20160317');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,3,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,24,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,29,'STRING',null,'userId','1512201');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (85,29,'STRING',null,'zipCode','1234');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (86,29,'STRING',null,'zipCodeTxt','서울 금천구 ');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (87,29,'STRING',null,'address','삼성리더스타워 ');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (90,31,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (91,31,'STRING',null,'vehicleNo','실험1234');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,5,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,5,'STRING','시작날짜 ','startDate','20160101');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,5,'STRING','종료날짜 ','endDate','20160101');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (11,6,'STRING','삭제할날짜','deleteDay','20160101');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (56,22,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (57,22,'STRING','SHA256 해쉬 (솔트적용)','passwordValue',null);
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (72,32,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (81,35,'STRING','플랫폼유형','platformType','I');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (5,1,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,4,'STRING','접근할 도우미 메시지 시퀀스','accessSeq','123');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,4,'STRING','접근할 도우미 시퀀스 접근 키 ','accessKey','abcdefg');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (82,36,'STRING','플랫폼 유형 ','platformType','I');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (83,36,'STRING','앱이름','appName','mcare-hyumc-seoul');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,36,'STRING','인증서유형','certType','AppStore');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (37,10,'STRING','사용자 이름','userName','홍길동');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (38,10,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (39,10,'STRING','누가 보냈는지 ','senderId','WEB_ADMIN_CONSOLE');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (40,10,'STRING','단계 ','stageOrder','30');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (27,7,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (28,7,'STRING','사용자 이름','userName','홍길동');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (29,7,'STRING','보낼 메시지','messageValue','가내두루평안하신지요?');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (30,7,'STRING','표시방식 ','senderId','WEB_ADMIN_CONSOLE');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (31,9,'STRING','사용자 ID ','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (32,9,'STRING','사용자 이름','userName','홍길동');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (33,9,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (34,9,'STRING','누가 보냈는지 ','senderId','WEB_ADMIN_CONSOLE');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (35,9,'STRING','단계 ','stageOrder','30');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (36,10,'STRING','사용자 ID ','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (73,33,'STRING','토큰','deviceTokenId','dyxgA1Gar8k:APA91bEz7xQOOHZh4F6aMIqQ6xUugagyi4eKdAUoOf1-xjC3EpwmvOgZFssLTGdoY-wJoXw_YpYAEa8K2APUYU7cP2KRLlmbNBmeSilKzQKalNiwwmF2f4FqKmvmxElIt3mVNx23Ez21');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (74,33,'STRING','사용자 ID','receiverId','111');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (75,33,'STRING','플랫폼 유형 ','platformType','A:Android, I:iOS');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (76,33,'STRING','인증서 유형 ','certType','InHouse');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (77,34,'STRING','토큰','deviceTokenId','111');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (78,34,'STRING','사용자 ID','receiverId','111');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (79,34,'STRING','android:A, iOS:I','platformType','A');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (80,34,'STRING','인증서 유형 ','certType','InHouse');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (183,51,'STRING','메시지 형식','guide','guide');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (184,51,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (185,51,'STRING','사용자 이름','userName','홍길동');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (186,51,'STRING','보낼 메시지 ','messageValue','실험입니다.');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (187,51,'STRING','어떤 단계의 메시지인지','stageOrder','10');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (188,51,'STRING','푸쉬로 전달유무','pgubn','WEB_ADMIN_CONSOLE');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1,27,'STRING','이름','userName','권혜은');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,27,'STRING','전화번호','cellphoneNo','01020125023');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,30,'STRING',null,'userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,30,'STRING',null,'cellphoneNo','01011112222');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (21,19,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (22,20,'STRING','사용자 ID','userId','03000000');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (23,21,'STRING','조회할기준일','baseDay','10');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (24,28,'STRING','사용자 ID','userId','1512202');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (25,82,'STRING',null,'userId','1512202');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1683,162,'NUMBER',null,'useAttrOrder','0');
Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1870,162,'STRING',null,'userId','1512202');

REM INSERTING into MP_ATTR_TYPE
SET DEFINE OFF;
Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (1,'hospital','소속');
Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (2,'duty','직무');
Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (3,'work','업무');
Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (21,'extra','추가속성');
REM INSERTING into MP_ATTR
SET DEFINE OFF;
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (1,'hospital','seoul','서울','none');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (2,'hospital','guri','구리','none');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (3,'duty','medical','의료','none');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (4,'duty','nurse','간호','none');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (5,'duty','general','일반','none');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (6,'work','treatment','진료의','medical');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (7,'work','doctor','주치의','medical');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (8,'work','ward_nurse','병동 간호','nurse');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (9,'work','treatment_nurse','진료 간호','nurse');
Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (10,'work','normal','일반','general');

REM INSERTING into MP_AUTH
SET DEFINE OFF;
Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (1,'auth02','권한1','권한1');
Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (2,'auth01','권한2','권한2');
REM INSERTING into MP_AUTH_ATTR
SET DEFINE OFF;
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (1,'auth01','add','hospital','seoul');
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (2,'auth01','add','hospital','guri');
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (3,'auth02','add','hospital','seoul');
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (4,'auth02','add','work','doctor');
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (5,'auth02','add','duty','medical');
Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (6,'auth02','minus','work','normal');
REM INSERTING into MP_DEMO_USER
SET DEFINE OFF;
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1603220','김우석','01063910582','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512186','김홍섭','01092240010','Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512205','김해동','01048308110','Y','02무0233','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1602001','강영길','01090437309','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1602002','복중효','01020738643','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('15122022','김희성2','01029502538','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512001','홍병진','01028034513','Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512201','권혜은','01020125023','Y','서울 1234','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M','1234','서울 금천구 ','삼성리더스타워 ');
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512197','서영일','01033661397','Y','31나 3456','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M','04417','서울 용산구 다산로 8-11 (한남동, 응봉공원 숲속 유아쉼터)','테스트');
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512202','김희성','01029502538','Y','내차1234','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512207','안성철','01030187371','Y','17모1869','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512047','김준현',null,'Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512119','연제봉 ',null,'Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null);
REM INSERTING into MP_HELPER_CONTENTS
SET DEFINE OFF;
REM INSERTING into MP_I18N
SET DEFINE OFF;
REM INSERTING into MP_INF_NURSE
SET DEFINE OFF;
REM INSERTING into MP_INF_PUSH_MSG
SET DEFINE OFF;
Insert into MP_INF_PUSH_MSG (PUSH_SEQ,FORM_ID,HOSPITAL_VALUE,USER_ID,USER_NAME,MESSAGE_VALUE,PARAM_VALUE,STAGE_ORDER,REQ_DT,SENDER_ID,PUMPING_DT,SEND_YN,RESERVE_SEND_DT) values (1,'guide','031','03000000','홍길동','실험입니다.',null,10,to_date('16/08/03','RR/MM/DD'),'WEB_ADMIN_CONSOLE',null,'N',to_date('16/08/03','RR/MM/DD'));
REM INSERTING into MP_LOGIN_HISTORY
SET DEFINE OFF;
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (2,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (3,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (4,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (21,'1512202',to_date('16/08/08','RR/MM/DD'),'Y','5bced8e6a97d646394f3c4d0634e7f86be195883024551afac945ac423d8e546');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (22,'1512207',to_date('16/08/08','RR/MM/DD'),'Y','64968e8c931e8d9789821d739363891b8a1324f146a7ff899783e9c0a7f99482');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (5,'1512207',to_date('16/07/27','RR/MM/DD'),'Y','31c62c7ef9bf671a66608ec29e2a04ecf9b5d8a47abde04b3cba5caaa48d91a2');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (23,'1512202',to_date('16/08/08','RR/MM/DD'),'Y','5bced8e6a97d646394f3c4d0634e7f86be195883024551afac945ac423d8e546');
Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (1,'1512202',to_date('16/07/21','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79');
REM INSERTING into MP_MANAGER
SET DEFINE OFF;
Insert into MP_MANAGER (USER_ID,USER_NAME,ENABLED_YN,DEPT_NAME,PWD_VALUE,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values ('admin','knuh1_admin','Y','DBS','4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/08','RR/MM/DD'),'DBS(Console)',to_date('16/07/08','RR/MM/DD'),'DBS(Console)');
REM INSERTING into MP_MENU
SET DEFINE OFF;
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkAgreementList','myInfo',166,'CONT','서비스약관','Y','/mobile/agreement/agreement.page','/resources/css/images/mobile/main/agreement.png','- 이미 동의한 서비스 약과 보기 및 철회','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('inpatientExam',null,180,'CONT','입원환자 검사안내','Y','/mobile/inpatientExam/inpatientExam.page','/resources/css/images/mobile/main/inpatientExam.png',null,'Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('hospital',null,910,'SIDE','병원선택_실험용','N','/hospital.page',null,null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('address','myInfo',162,'CONT','주소','Y','/mobile/user/address.page',null,'사용자 주소 설정 화면','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('telephone','myInfo',161,'CONT','전화번호','Y','/mobile/user/telephone.page',null,'사용자 전화번호 변경 화면','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('inpatientBrochure',null,170,'CONT','입원진료안내','N','/mobile/inpatientBrochure/inpatientBrochure.page','/resources/css/images/mobile/main/inpatientBrochure.png',null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('brochureDetail','inpatientBrochure',922,'CONT','입원안내문상세','Y','/mobile/inpatientBrochure/brochureDetail.page',null,null,'N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('mobileHomepage',null,911,'SIDE','병원모바일홈','Y','javascript:goHomepage(''http://www.idatabank.com/'')',null,'병원 모바일 홈','N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('outpatientBrochure',null,160,'CONT','외래진료안내','Y','/mobile/outpatientBrochure/outpatientBrochure.page','/resources/css/images/mobile/main/outpatientBrochure.png','내원안내문','N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkProgramVersion',null,950,'SIDE','프로그램 정보','Y','javascript:checkProgramVersion();',null,'프로그램 정보 보여주기','N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('receipt','payment',30,'CONT','영수증','Y','/mobile/pay/receipt.page',null,'영수증 테스트 화면','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('medicineSearch',null,940,'SIDE','의약품백과사전','Y','javascript:medicineSearch()',null,'의약품 백과사전','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payment',null,20,'CONT','스마트 결제','Y','/mobile/pay/payment.page','/resources/css/images/mobile/main/payment.png',null,'Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payDetail','payment',21,'CONT','결제상세','Y','/mobile/pay/payDetail.page',null,'결제 상세 화면','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('myCar','myInfo',163,'CONT','차량번호','Y','/mobile/parking/parking.page','/resources/css/images/mobile/main/parking.png',null,'Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payCancel','payment',22,'CONT','결제취소','Y','/mobile/pay/payCancel.page',null,'결제취소 화면','Y','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('gMap',null,1,'CONT','찾아오시는길','Y','/mobile/map/map.page','/resources/css/images/mobile/main/openMap.png',null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payManagement','myInfo',164,'CONT','병원비 카드','Y','/mobile/user/payManagement.page',null,'결제정보관리','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('setUserPwd','findPidPwd',933,'CONT','비밀번호설정','Y','/mobile/user/setUserPwd.page',null,'본인인증 후에 비밀번호를 설정하는 페이지','N','N','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('openMap',null,120,'CONT','길찾기','Y','javascript:openMap()','/resources/css/images/mobile/main/openMap.png',null,'N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('exitApp',null,990,'SIDE','종료','Y','javascript:exitApp()',null,'앱종료','N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('myInfo',null,130,'NAVI','내 정보관리','Y','/navigation.page','/resources/css/images/mobile/main/myInfo.png',null,'Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('withdrawal','myInfo',169,'CONT','회원탈퇴','Y','/mobile/user/withdrawal.page',null,null,'Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('changeMyPwd','myInfo',165,'CONT','비밀번호 변경','Y','/mobile/user/changeMyPwd.page',null,'비밀번호를 변경한다.','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('findPidPwd',null,1100,'NAVI','_사용자 ID 및 비번찾기','N','/navigation.page',null,'- 로그인 화면에 있는 사용자 ID 찾기와 비밀번호 찾기를 위한 메뉴 
- 이 메뉴는 보이지 않지만, 하위의 사용자 ID 찾기와 비밀번호 찾기는 접근할 수 있는 메뉴임','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('certificationResult','certification',40,'CONT','인증결과','Y','/mobile/user/certificationResult.page',null,'휴대폰 인증, iPin 인증의 인증 결과를 반환 받는다.','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('appointmentSearchDetail','appointmentSearch',71,'CONT','예약조회상세','Y','/mobile/appointmentSearch/appointmentSearchDetail.page',null,'예약조회 상세','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('searchId','userRegister',22,'CONT','사용자 ID찾기','Y','/mobile/user/searchPId.page',null,'사용자 등록(userRegister) 에서 사용자 ID 찾기로 넘어가는 화면.','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('registerPWD','userRegister',21,'CONT','비밀번호 설정','Y','/mobile/user/registerPWD.page',null,null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userAgreement','userRegister',27,'CONT','서비스약관 동의','Y','/mobile/user/userAgreement.page',null,'- 사용등록 후 최초로 약관 동의하는 페이지 
- 로그인하다가 추가로 동의할게 있으면 오는 페이지 
- 사용등록 시 가입은 되었으나, 로그인은 하지 않은 상태로 사용자가 여기에 오게 됨','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('treatmentHistoryDetail','treatmentHistory',91,'CONT','진료이력','Y','/mobile/history/treatmentHistoryDetail.page',null,'이력조회상세','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('resultExam',null,110,'CONT','검사결과','Y','/mobile/resultExam/resultExam.page','/resources/css/images/mobile/main/resultExam.png','검사결과조회','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('prescription',null,100,'CONT','처방조회','Y','/mobile/prescription/prescription.page','/resources/css/images/mobile/main/prescription.png','처방조회','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('ticket',null,30,'CONT','번호표발급','Y','/mobile/ticket/ticket.page','/resources/css/images/mobile/main/ticket.png','번호표발급 - 번호표발급기 목록','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('issueTicket','ticket',31,'CONT','번호표발급','Y','/mobile/ticket/issueTicket.page',null,'번호표발급','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('help',null,170,'CONT','도움말','N','/mobile/help/help.page',null,'로그인 하지 않았을 때, 시작화면에 표시되는 도움말','N','N','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('paymentDetail','treatmentHistoryDetail',10,'CONT','진료비 상세내역','Y','/mobile/history/paymentDetail.page',null,'진료비 내역 상세','Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('nextLocation',null,50,'CONT','가야할곳','Y','/mobile/nextLocation/nextLocation.page','/resources/css/images/mobile/main/navigation.png','가셔야 할 곳','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('nurse',null,150,'CONT','간호요청','N','/mobile/nurse/nurse.page','/resources/css/images/mobile/main/nurse.png','간호호출','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('sidehelp',null,960,'SIDE','도움말','Y','/mobile/help/help.page','/resources/css/images/mobile/main/help.png','로그인 후 사이드 메뉴에 표시되는 도움말
이었는데.. 시작메뉴에 아이콘이 너무 많아서 도움말은 사이드로 배치','N','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('smsCertification','certification',34,'CONT','SMS인증 코드','Y','/mobile/user/smsCertification.page',null,'SMS인증 대기 화면','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('telNo',null,150,'CONT','전화번호안내','Y','/mobile/telNo/telNo.page','/resources/css/images/mobile/main/telNo.png','주요전화번호','N','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('authUserInfo','findPidPwd',932,'CONT','본인인증','Y','/mobile/user/authUserInfo.page',null,'- 비밀번호 설정 시작하는 페이지로 본인인증을 먼저하고 비밀번호를 바꿔줌','N','N','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('mobileCard',null,10,'CONT','진료카드','Y','/mobile/mobileCard/mobileCard.page','/resources/css/images/mobile/main/mobileCard.png','환자카드','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('appointmentSearch',null,70,'CONT','예약조회','Y','/mobile/appointmentSearch/appointmentSearch.page','/resources/css/images/mobile/main/appointmentSearch.png','예약조회','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('sms','certification',30,'CONT','SMS','Y','/mobile/user/sms.page',null,'병원에 등록한 휴대폰 번호','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('certification','userRegister',20,'CONT','본인인증','Y','/mobile/user/certification.page',null,'- 사용등록 화면에서 사용자 ID를 입력한 다음 "다음" 버튼 누르면 열리는 화면임','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('iPin','certification',40,'CONT','i-Pin','Y','/mobile/user/iPin.page',null,'i-Pin 인증','N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('searchPNumber','findPidPwd',1120,'CONT','사용자 ID 찾기','Y','/mobile/user/searchPId.page',null,'- 로그인 화면에 있는 사용자 ID찾기','N','N','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('helper',null,0,'CONT','도우미','Y','/mobile/helper/helper.page','/resources/css/images/mobile/main/helper.png','도우미ㅋㅋㅋ','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('treatmentHistory',null,90,'CONT','진료이력','Y','/mobile/history/treatmentHistory.page','/resources/css/images/mobile/main/treatmentHistory.png','이력조회','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('waitingTime',null,50,'CONT','진료대기순서','Y','/mobile/waitingTime/waitingTime.page','/resources/css/images/mobile/main/waitingTime.png','진료대기조회','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userRegister',null,0,'CONT','사용등록','Y','/mobile/user/register.page','/resources/css/images/mobile/main/register.png',null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbook',null,140,'CONT','건강수첩','Y','/mobile/resultExam/resultExam.page','/resources/css/images/mobile/main/healthHandbook.png','건강수첩','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbookInsert','healthHandbook',162,'CONT','건강수첩등록','Y','/mobile/healthHandbook/healthHandbookInsert.page',null,null,'Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbookUpdate','healthHandbook',152,'CONT','건강수첩수정','Y','/mobile/healthHandbook/healthHandbookUpdate.page',null,null,'Y','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('reservation',null,80,'CONT','진료예약','Y','/mobile/reservation/reservation.page','/resources/css/images/mobile/main/reservation.png','예약','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('announceArrival',null,40,'CONT','진료도착확인','Y','/mobile/announceArrival/announceArrival.page','/resources/css/images/mobile/main/announceArrival.png','진료도착확인','Y','Y','Y');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkPlusFailed','certification',20,'CONT','휴대폰 인증실패','Y','/mobile/user/checkPlusFailed.page',null,null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkPlusSuccess','certification',10,'CONT','휴대폰 인증성공','Y','/mobile/user/checkPlusSuccess.page',null,null,'N','N','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('iPinSuccess','certification',41,'CONT','iPin인증성공','Y','/mobile/user/iPinSuccess.page',null,null,'N','Y','N');
Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userAuthList',null,1400,'CONT','권한 목록','Y','/mobile/auth/userAuthList.page',null,null,'Y','Y','N');
REM INSERTING into MP_MENU_AUTH
SET DEFINE OFF;
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (16,'waitingTime','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (24,'payment','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (15,'helper','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (17,'nextLocation','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (32,'reservation','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (23,'mobileCard','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (28,'announceArrival','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (29,'prescription','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (33,'treatmentHistory','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (2,'telNo','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (26,'openMap','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (27,'resultExam','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (18,'gMap','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (19,'help','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (21,'checkProgramVersion','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (8,'ticket','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (9,'outpatientBrochure','auth02');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (10,'outpatientBrochure','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (31,'medicineSearch','auth01');
Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (34,'inpatientExam','auth02');
REM INSERTING into MP_MENU_PARAM
SET DEFINE OFF;
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (1,'ticket','sendTimeNum','STRING','3','호출 횟수');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (2,'appointmentSearch','periodDay','NUMBER','30','기본 검색기간 (일)');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (43,'prescription','periodDay','NUMBER','30','기본 검색기간 (일)');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (44,'treatmentHistory','periodDay','NUMBER','30','기본 검색기간 (일)');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (6,'checkAgreementList','minimum','NUMBER','3','전체동의 보이는 최저 갯수');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (7,'userAgreement','minimum','NUMBER','3','전체동의 보이는 최저 갯수');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (42,'resultExam','periodDay','NUMBER','30','기본 검색기간 (일)');
Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (41,'healthHandbook','periodDay','NUMBER','30','기본 검색기간 (일)');
REM INSERTING into MP_MNS_MSGMAPPING
SET DEFINE OFF;
REM INSERTING into MP_PAYMENT_MASTER
SET DEFINE OFF;
REM INSERTING into MP_PUBLIC_DEVICE
SET DEFINE OFF;
REM INSERTING into MP_PUSH_FORM
SET DEFINE OFF;
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('welcome','GUIDE','Y',null,'Y','웹컴',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('guide','GUIDE','Y',null,'Y','일반 text 전송',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('medicineSearch','PAGE','Y','medicineSearch','Y','의약품백과사전 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('openMap','MAP','Y','openMap','Y','길찾기 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('resultExam','PAGE','Y','resultExam','Y','검사결과 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('prescription','PAGE','Y','prescription','Y','처방조회 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('ticket','PAGE','Y','ticket','Y','번호표발급 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('myCar','PAGE','Y','myCar','Y','주차관리 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('nextLocation','PAGE','Y','nextLocation','Y','가야할곳 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('sidehelp','PAGE','Y','sidehelp','Y','도움말_시작메뉴 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('telNo','PAGE','Y','telNo','Y','주요전화번호 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('mobileCard','PAGE','Y','mobileCard','Y','진료카드 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('appointmentSearch','PAGE','Y','appointmentSearch','Y','예약조회 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('treatmentHistory','PAGE','Y','treatmentHistory','Y','진료이력 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('waitingTime','PAGE','Y','waitingTime','Y','진료대기순서 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('reservation','PAGE','Y','reservation','Y','진료예약 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('announceArrival','PAGE','Y','announceArrival','Y','진료도착확인 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('paymentSuccess','PAGE','Y','treatmentHistory','Y','진료이력에서 결제결과 보기 가능함',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('paymentCancelSuccess','PAGE','Y','treatmentHistory','Y','진료이력에서 결제결과 보기 가능하여 일단 연결',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('outpatientBrochure','PAGE','Y','outpatientBrochure','Y','DBS에서 한땀한땀 입력',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('inpatientBrochure','PAGE','Y','inpatientBrochure','Y','DB에서 한땀한땀 입력함',to_date('16/06/21','RR/MM/DD'));
Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('inpatientExam','PAGE','Y','inpatientExam','Y','DBS에서 한땀한땀 입력함',to_date('16/06/21','RR/MM/DD'));
REM INSERTING into MP_TELNO
SET DEFINE OFF;
Insert into MP_TELNO (TELNO_SEQ,BUILDING_DESC,ROOM_DESC,TEL_VALUE,TELNO_ORDER) values (1,'건물1','1호','02-123-4567',13);
REM INSERTING into MP_USER
SET DEFINE OFF;
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (1,'1512201','권혜은',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (2,'1603220','김우석',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (3,'1512186','김홍섭',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (4,'1512205','김해동',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (5,'1602001','강영길',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (6,'1602002','복중효',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (7,'15122022','김희성2',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (8,'1512001','홍병진',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (9,'1512197','서영일',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (10,'1512202','김희성',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (11,'1512207','안성철',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (12,'1512047','김준현',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (13,'1512119','연제봉',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0);
REM INSERTING into MP_USER_ATTR
SET DEFINE OFF;
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (1,1,'1512202','seoul','medical','doctor');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (2,1,'1512119','guri','general','normal');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (3,1,'1512201','seoul','medical','treatment');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (4,1,'1603220','seoul','nurse','ward_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (5,1,'1512205','seoul','nurse','treatment_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (6,1,'1602001','guri','nurse','ward_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (7,1,'1602002','guri','nurse','treatment_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (8,1,'15122022','seoul','medical','doctor');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (9,1,'1512001','guri','nurse','treatment_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (10,1,'1512197','seoul','medical','doctor');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (11,1,'1512207','seoul','nurse','ward_nurse');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (12,1,'1512047','seoul','medical','treatment');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (13,1,'1512186','guri','medical','doctor');
Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (14,2,'1512202','seoul','general','normal');
REM INSERTING into MP_VERSION
SET DEFINE OFF;
Insert into MP_VERSION (PLATFORM_TYPE,CERT_TYPE,VERSION_ORDER,APP_NAME,MARKET_URL) values ('I','InHouse',1,'M-Care (Demo)',null);
REM INSERTING into MP_EVENT_LOG
SET DEFINE OFF;
REM INSERTING into MP_EXTRA_ATTR
SET DEFINE OFF;
Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (1,'extraAttr01','추가 속성1','테스트');
Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (2,'extraAttr02','추가 속성2','2');
Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (21,'extraAttr03','추가 속성3','테스트03');
REM INSERTING into MP_EXTRA_ATTR_USER
SET DEFINE OFF;
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (1,'extraAttr03','1512202',1);
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (2,'extraAttr01','1512119',1);
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (3,'extraAttr01','1512201',2);
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (4,'extraAttr01','1512202',3);
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (5,'extraAttr02','1512119',1);
Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (6,'extraAttr02','1512202',2);

commit;