update-1.6.0.sql 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. use 4dkankan_v4;
  2. DELETE FROM sys_menu WHERE rec_status = 'I';
  3. DELETE from sys_menu WHERE id = 225;
  4. DELETE from sys_menu WHERE id = 99;
  5. DELETE from sys_menu WHERE id = 104;
  6. DELETE from sys_menu WHERE id = 16;
  7. DELETE from sys_menu WHERE id = 23;
  8. DELETE from sys_menu WHERE id = 21;
  9. DELETE from sys_menu WHERE id = 96;
  10. DELETE from sys_menu WHERE id = 247;
  11. DELETE from sys_menu WHERE id = 18;
  12. DELETE from sys_menu WHERE id = 24;
  13. DELETE from sys_menu WHERE id = 20;
  14. CREATE TEMPORARY TABLE temp_menu AS
  15. SELECT id from sys_menu WHERE rec_status = 'A';
  16. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  17. DROP TEMPORARY TABLE temp_menu;
  18. CREATE TEMPORARY TABLE temp_menu AS
  19. SELECT id from sys_menu WHERE rec_status = 'A';
  20. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  21. DROP TEMPORARY TABLE temp_menu;
  22. CREATE TEMPORARY TABLE temp_menu AS
  23. SELECT id from sys_menu WHERE rec_status = 'A';
  24. DELETE from sys_menu WHERE parent_id not in (SELECT id from temp_menu);
  25. DROP TEMPORARY TABLE temp_menu;
  26. DELETE from sys_role_menu WHERE menu_id not in (SELECT id from sys_menu WHERE rec_status = 'A');
  27. ALTER TABLE `4dkankan_v4`.`jy_scene_auth`
  28. ADD COLUMN `case_id` int NULL AFTER `update_time`;
  29. ALTER TABLE `4dkankan_v4`.`jy_scene_user_auth`
  30. ADD COLUMN `case_id` int NULL AFTER `update_time`;
  31. UPDATE t_scene_plus_ext set thumb = '/oss/loading/thumb.jpg' WHERE thumb LIKE '%https://4dkk.4dage.com/loading/thumb.jpg%'
  32. USE fdkk_laser;
  33. SET GLOBAL character_set_server = 'utf8mb4';
  34. SET GLOBAL character_set_database = 'utf8mb4';
  35. SET GLOBAL collation_server = 'utf8mb4_0900_ai_ci';
  36. SELECT
  37. CONCAT('ALTER TABLE `', table_name, '` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;') AS alter_sql
  38. FROM
  39. information_schema.TABLES
  40. WHERE
  41. table_schema = 'fdkk_laser';