## mysql 建表语句 ```sql CREATE TABLE `magic_api_file` ( `file_path` varchar(512) NOT NULL, `file_content` mediumtext, PRIMARY KEY (`file_path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ``` ## 备份表建表语句 ```sql CREATE TABLE `magic_api_backup` ( `id` varchar(32) NOT NULL COMMENT '原对象ID', `create_date` bigint(13) NOT NULL COMMENT '备份时间', `tag` varchar(32) DEFAULT NULL COMMENT '标签', `type` varchar(32) DEFAULT NULL COMMENT '类型', `name` varchar(64) DEFAULT NULL COMMENT '原名称', `content` blob COMMENT '备份内容', `create_by` varchar(64) DEFAULT NULL COMMENT '操作人', PRIMARY KEY (`id`,`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ```