迅睿CMS创建新的内容附表MYSQL语句

CREATE TABLE `dr_1_news_data_2` (

  `id` int unsigned NOT NULL,

  `uid` mediumint unsigned NOT NULL COMMENT '作者uid',

  `catid` smallint unsigned NOT NULL COMMENT '栏目id',

  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容',

  UNIQUE KEY `id` (`id`),

  KEY `uid` (`uid`),

  KEY `catid` (`catid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='内容附表';