-- --liquibase formatted sql
--
-- --changeset 升职哦（sz）:20251013_1836
-- -- 以下为演示环境脚本，-- 仅供演示使用，实际业务请删除
--
-- ALTER TABLE `teacher_statistics` ADD COLUMN `url` json DEFAULT NULL COMMENT '文件地址(JSON)';
--
-- --changeset 升职哦（sz）:20251021_2100
-- UPDATE `teacher_statistics` SET  `url` = '[{\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/bg1.png\", \"etag\": \"73be62dc9778dc13478c59f0c236feca\", \"size\": 105636, \"dirTag\": \"teacher\", \"fileId\": 158, \"filename\": \"bg1.png\", \"metaData\": {\"original-filename\": \"bg1.png\"}, \"objectName\": \"teacher/20251021/bg1.png\", \"contextType\": \"image/png\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/bg7.png\", \"etag\": \"6b6857c36b4fded86645d0ed2662869b\", \"size\": 66861, \"dirTag\": \"teacher\", \"fileId\": 156, \"filename\": \"bg7.png\", \"metaData\": {\"original-filename\": \"bg7.png\"}, \"objectName\": \"teacher/20251021/bg7.png\", \"contextType\": \"image/png\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/bg10.png\", \"etag\": \"9a546cb494af380c9e2cf5efac2ae362\", \"size\": 87531, \"dirTag\": \"teacher\", \"fileId\": 157, \"filename\": \"bg10.png\", \"metaData\": {\"original-filename\": \"bg10.png\"}, \"objectName\": \"teacher/20251021/bg10.png\", \"contextType\": \"image/png\"}]' WHERE `id` = 26;
-- UPDATE `teacher_statistics` SET  `url` = '[{\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/bg4.png\", \"etag\": \"c4a227a6f24d5b818bf46a49d28cf282\", \"size\": 90015, \"dirTag\": \"teacher\", \"fileId\": 153, \"filename\": \"bg4.png\", \"metaData\": {\"original-filename\": \"bg4.png\"}, \"objectName\": \"teacher/20251021/bg4.png\", \"contextType\": \"image/png\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/bg5.png\", \"etag\": \"a6e547dcfe5a50a060d5f895857f0c9b\", \"size\": 70640, \"dirTag\": \"teacher\", \"fileId\": 152, \"filename\": \"bg5.png\", \"metaData\": {\"original-filename\": \"bg5.png\"}, \"objectName\": \"teacher/20251021/bg5.png\", \"contextType\": \"image/png\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/微信图片_20240420160033.jpg\", \"etag\": \"322e08e6b47cd85dec6a7b8dc9e88476\", \"size\": 20276, \"dirTag\": \"teacher\", \"fileId\": 151, \"filename\": \"微信图片_20240420160033.jpg\", \"metaData\": {\"original-filename\": \"微信图片_20240420160033.jpg\"}, \"objectName\": \"teacher/20251021/微信图片_20240420160033.jpg\", \"contextType\": \"image/jpeg\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/教师统计.xlsx\", \"etag\": \"47c4e1a9be3987a477d2c9672f761968\", \"size\": 5481, \"dirTag\": \"teacher\", \"fileId\": 154, \"filename\": \"教师统计.xlsx\", \"metaData\": {\"original-filename\": \"教师统计.xlsx\"}, \"objectName\": \"teacher/20251021/教师统计.xlsx\", \"contextType\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"}, {\"url\": \"https://minioapi.szadmin.cn/test/teacher/20251021/题库导入模板.xlsx\", \"etag\": \"54e2201ec376091aeb3f25581feba1c1\", \"size\": 13862, \"dirTag\": \"teacher\", \"fileId\": 155, \"filename\": \"题库导入模板.xlsx\", \"metaData\": {\"original-filename\": \"题库导入模板.xlsx\"}, \"objectName\": \"teacher/20251021/题库导入模板.xlsx\", \"contextType\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"}]' WHERE `id` = 27;