text: CREATE TABLE IF NOT EXISTS sfrm_message
  (
    message_id varchar(200) NOT NULL,
    message_box varchar(200) NOT NULL,
    partnership_id varchar(200) NOT NULL, 
    partner_endpoint varchar(200) NOT NULL,
    total_segment int,
    total_size bigint,
    is_hostname_verified boolean,
    partner_cert_content varchar(200),
    sign_algorithm varchar(200),
    encrypt_algorithm varchar(200),
    status varchar(200) NOT NULL,
    status_desc varchar(200),
    created_timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
    proceed_timestamp timestamp,
    completed_timestamp timestamp,
    filename varchar(200),
    PRIMARY KEY (message_id, message_box)
  );
  
  CREATE TABLE IF NOT EXISTS sfrm_message_segment 
  (
     message_id varchar(200) NOT NULL,
     message_box varchar(200) NOT NULL,
     segment_no int NOT NULL,
     segment_type varchar(200) NOT NULL,
     segment_start bigint,
     segment_end bigint,
     retried int DEFAULT -1,
     md5_value varchar(200),
     status varchar(200),
     created_timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
     proceed_timestamp timestamp,
     completed_timestamp timestamp,
     PRIMARY KEY (message_id, message_box, segment_no, segment_type)
  );
  
  CREATE TABLE IF NOT EXISTS sfrm_partnership
  (
    partnership_seq int DEFAULT 1,
    partnership_id varchar(50) NOT NULL,
    description varchar(200),
    partner_endpoint varchar(200) NOT NULL,
    partner_cert_fingerprint varchar(200),
    is_hostname_verified boolean DEFAULT FALSE,
    sign_algorithm varchar(200),
    encrypt_algorithm varchar(200),
    retry_max int DEFAULT 3,
    retry_interval int DEFAULT 30000,
    is_disabled boolean DEFAULT FALSE NOT NULL,  
    created_timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
    modified_timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
    UNIQUE (partnership_id),
    PRIMARY KEY (partnership_seq)
  );
  