# Basic RCSSMS type + 1 BUTTON

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     AGENCY_ID,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘kakaoenterprise’,
      ‘01012345678’,
      ‘1544-0000’,
      ‘SS000000’,                  # Message template code
      ‘RCSSMS’,                       # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                    # 0 : for Info, 1 : for ad
      ‘080-0000-0000’,        # Required in case of ‘1(for ad)’
      true,
      ‘{ "title": "","description":"This is a general RCSSMS test message.\\n" }’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# Basic RCSLMS type + 1 button

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     AGENCY_ID,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘kakaoenterprise’,
      ‘01012345678’,
      ‘1544-0000’,
      ‘SL000000’,                 # Message template code
      ‘RCSLMS’,                      # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                   # 0 : for Info, 1 : for ad
      ‘080-0000-0000’,       # Required in case of ‘1(for ad)’
      true,
      ‘{"title": "RCSLMS title","description":" This is a general RCSLMS message."}’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# Basic RCSMMS type  + 1 attachment + 1 button

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/test.jpg’,
    ‘image/jpg’,
    ‘Upload test image’
);

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     MMS_TITLE1,
     MMS_MSG1,
     MMG_IMG_URL1
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SM000000’,                  # Message template code
      ‘RCSMMS’,                       # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                    # 0 : for Info, 1 : for ad
      ‘080-0000-0000’,        # Required in case of ‘1(for ad)’
      true,
      ‘20220608000001’,
      ‘1’,
      ‘MMS title’,
      ‘This is a general RCSMMS test message.’,
      ‘maapfile://testImgUrl’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# You can insert up to 5 carousels, with a maximum of 2 buttons per carousel.

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_001.jpg’,
    ‘image/jpg’,
    ‘Upload test image1’
);

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_002.jpg’,
    ‘image/jpg’,
    ‘Upload test image2’
);

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_003.jpg’,
    ‘image/jpg’,
    ‘Upload test image3’
);

INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     IMG_GROUP_CODE,
     IMG_CNT,
     MMS_TITLE1,
     MMS_MSG1,
     MMG_IMG_URL1,
     MMS_TITLE2,
     MMS_MSG2,
     MMG_IMG_URL2,
     MMS_TITLE3,
     MMS_MSG3,
     MMG_IMG_URL3,
     BUTTONS
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SMwMgM0300’,                # Message template code
      ‘RCSMMS’                            # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                        # 0 : for Info, 1 : for ad
      ‘080-0000-0000’,            # Required in case of ‘1(for ad)’
      true,
      ‘20220608000001’,
      ‘1’,
      ‘MMS title1’,
      ‘1st Carousel message’’,
      ‘maapfile://testImgUrl_001’,
      ‘MMS title2’,
      ‘2nd Carousel meassage’’,
      ‘maapfile://testImgUrl_002’,
      ‘MMS title3’,
      ‘3rd Carousel message’’,
      ‘maapfile://testImgUrl_003’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            },    # Button of 1st Carousel (1 button)
           {},   # Button of  2nd Carousel  (0 button)
           {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }    # Button of 3rd Carousel (1 button)
        ]’
);

# RCSTMPL
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     BODY
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘RCS_TMPL001’,            # Message template code
      ‘RCSTMPL’,                      # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      true,
      ‘{"description":"Hello. KRW 1,000 has been deposited from Gildong Hong."}’  # Modifiable section of the template
  );

# RCSTMPL
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     BODY
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘RCS_TMPL001’,           # Message template code
      ‘RCSTMPL’,                     # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      true,
      ‘{
         "Name of variable 1”:”Variable value”,
         “Name of variable 2”:”Variable value”
      }’
  );

– RCSSMS + Alternative Message(SMS/LMS)
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     FALLBACK_YN,
     FALLBACK_TYPE,
     FALLBACK_CALLBACK,
     FALLBACK_SUBJECT,
     FALLBACK_MESSAGE
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SS000000’,
      ‘RCSSMS’                    # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                        # 0 : for Info, 1 : for ad
      ‘080-0000-0000’,            # Required in case of ‘1(for ad)’
      true,
      ‘{ "title": "","description":"This is a general RCSSMS test message." }’,
      true,
      ‘SM’,                       # [SM, LM]
     ‘1544-0000’,
     ‘’,
     ‘Alternative Message.’
);