update-1.1.0.sql 593 B

123456789101112131415
  1. use 4dkankan_v4;
  2. ALTER TABLE `4dkankan_v4`.`jy_scene_user_auth`
  3. ADD COLUMN `author_id` int NULL COMMENT '授权者 jy_user_id' AFTER `can_edit_look`;
  4. ALTER TABLE `4dkankan_v4`.`jy_scene_user_auth`
  5. ADD COLUMN `can_del` int NULL DEFAULT 0 COMMENT '0后台添加可以删除,1api调用添加不可删除' AFTER `update_time`;
  6. ALTER TABLE `4dkankan_v4`.`jy_user`
  7. ADD COLUMN `status` int NULL DEFAULT 1 COMMENT '0禁用,1正常' AFTER `update_time`;
  8. ALTER TABLE `4dkankan_v4`.`sys_log`
  9. MODIFY COLUMN `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL AFTER `browser`;