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;