mysql建表语句主键索引_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;