MySQL创建表语句包含主键、索引、约束

最新推荐文章于 2024-04-09 23:17:56 发布

FeelTouch Labs

最新推荐文章于 2024-04-09 23:17:56 发布

阅读量8.5k

点赞数 1

分类专栏：大数据-云计算-数据库

本文链接：https://blog.csdn.net/feeltouch/article/details/52653851

版权

大数据-云计算-数据库专栏收录该内容

74 篇文章 3 订阅

订阅专栏

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;