CREATE TABLE `filerecord` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' , `filepath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称' , INDEX `r_id` (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ROW_FORMAT=COMPACT ;