text: CREATE TABLE submit_log ( `msgid` VARCHAR(45) PRIMARY KEY, `source_connector` VARCHAR(15), `routed_cid` VARCHAR(30), `source_addr` VARCHAR(40), `destination_addr` VARCHAR(40) NOT NULL CHECK (`destination_addr` <> ''), `rate` DECIMAL(12, 7), `pdu_count` TINYINT(3) DEFAULT 1, `short_message` BLOB, `binary_message` BLOB, `status` VARCHAR(15) NOT NULL CHECK (`status` <> ''), `uid` VARCHAR(15) NOT NULL CHECK (`uid` <> ''), `trials` TINYINT(4) DEFAULT 1, `created_at` DATETIME NOT NULL, `status_at` DATETIME NOT NULL, INDEX `sms_log_1` (`status`), INDEX `sms_log_2` (`uid`), INDEX `sms_log_3` (`routed_cid`), INDEX `sms_log_4` (`created_at`), INDEX `sms_log_5` (`created_at`, `uid`), INDEX `sms_log_6` (`created_at`, `uid`, `status`) )
  UPDATE submit_log SET status = %s, status_at = %s  WHERE msgid = %s
  SELECT COUNT(msisdn) FROM blacklisted_numbers WHERE msisdn = %s
  