-- ****************************************************************** -- 表 kku_file_imgs 的创建SQL -- 对应的Model: App\Module\File\Models\FileImg -- 警告: 此文件由系统自动生成,禁止修改! -- ****************************************************************** CREATE TABLE `kku_file_imgs` ( `id` bigint NOT NULL AUTO_INCREMENT, `storage_disk` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '储存 disk', `path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '储存目录', `user_id` bigint unsigned DEFAULT '0' COMMENT '用户iD', `admin_id` bigint unsigned DEFAULT '0' COMMENT '管理员ID', `re_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '关联类型', `re_id` int NOT NULL COMMENT '关联ID', `o_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原名', `fsize` bigint DEFAULT '0' COMMENT '文件大小', `width` int DEFAULT '0' COMMENT '图片宽度', `height` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片高度', `type1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片类型', `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `private` tinyint unsigned DEFAULT '0' COMMENT '私人的; 0:公共的 ,1 私人的', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件 - 图片';