编辑 | blame | 历史 | 原始文档
//添加最近上传文件夹
INSERT INTO `lb-boot`.`desk_file` (`id`, `pid`, `name`, `type`, `file_name`, `file_path`, `file_size`, `file_type`, `order_no`, `create_by`, `create_time`, `update_by`, `update_time`, `tag`) VALUES ('1', '', '最近上传', 2, NULL, NULL, NULL, NULL, NULL, 'all', '2022-05-18 00:00:00', 'admin', '2022-05-18 16:12:31', 'desk');
//为所有用户添加初始文件件
INSERT INTO `lb-boot`.`desk_file` (`id`, `type`,    `name`,    `create_by`,`create_time` ,   `tag` )
SELECT id  , 2, username as `name` ,username as create_by ,'2022-05-20 00:00:00' ,'desk' from sys_user2, username as `name` ,username as create_by ,'desk' from sys_user