MySQL作成テーブル文には、プライマリ・キー、インデックス、制約が含まれます.

CREATE TABLE `t_result_play_user_stat_by_realtime` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `playtime` int(11) NOT NULL DEFAULT 0,
  `streamid` char(40) DEFAULT '0',
  `streamid_type` char(6) DEFAULT '0',
  `playtimes` int(11) DEFAULT 0,
  `playtimes_success` int(11) DEFAULT 0,
  `playtimes_fail` int(11) DEFAULT 0,
  `appid` int(11) DEFAULT 101,
  PRIMARY KEY (`id`),
  KEY `playtime` (`playtime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS  lcloud_t_result_internal_distribute_fluence(
         rtime_ts  UNSIGNED_INT NOT NULL,
         ip VARCHAR NOT NULL,
         role VARCHAR NOT NULL,
         app_id UNSIGNED_INT NOT NULL,
         media_type_id UNSIGNED_INT NOT NULL,
         alias VARCHAR,
         in_kbps UNSIGNED_LONG,
         out_kbps UNSIGNED_LONG,
         rtime VARCHAR
         CONSTRAINT lridfsk PRIMARY KEY (rtime_ts, ip, role, app_id, media_type_id))
salt_buckets = 30,versions=1;