-- SMS 발송
INSERT INTO MUNJAON_MSG (
    MSG_TYPE
    , SEND_STATUS
    , REQUEST_DATE
    , RECV_PHONE
    , SEND_PHONE
    , MESSAGE
) VALUES ('S', '0', NOW(), '01012345678', '01043219876', 'message test 20240708');

--LMS 발송
INSERT INTO MUNJAON_MSG (
    MSG_TYPE
    , SEND_STATUS
    , REQUEST_DATE
    , RECV_PHONE
    , SEND_PHONE
    , MESSAGE
    , SUBJECT
) VALUES ('L', '0', NOW(), '01012345678', '01043219876', 'LMS message test 20240708', 'subject');

--MMS 발송
INSERT INTO MUNJAON_MSG (
    MSG_TYPE
    , SEND_STATUS
    , REQUEST_DATE
    , RECV_PHONE
    , SEND_PHONE
    , MESSAGE
    , SUBJECT
    , FILENAME01
) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject', 'send.png');

--알림톡발송
INSERT INTO MUNJAON_MSG (
    MSG_TYPE
    , SEND_STATUS
    , REQUEST_DATE
    , RECV_PHONE
    , SEND_PHONE
    , MESSAGE
    , SUBJECT
    , KAKAO_SENDER_KEY
    , KAKAO_TEMPLATE_CODE
    , KAKAO_JSON_FILE
) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');

--친구톡발송
INSERT INTO MUNJAON_MSG (
    MSG_TYPE
    , SEND_STATUS
    , REQUEST_DATE
    , RECV_PHONE
    , SEND_PHONE
    , MESSAGE
    , SUBJECT
    , KAKAO_SENDER_KEY
    , KAKAO_TEMPLATE_CODE
    , KAKAO_JSON_FILE
) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');