File name
Commit message
Commit date
File name
Commit message
Commit date
-- 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');