system_cache_algorithm.sql 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. /*
  2. Navicat Premium Dump SQL
  3. Source Server : 国航
  4. Source Server Type : MySQL
  5. Source Server Version : 80030 (8.0.30-commercial)
  6. Source Host : 10.211.67.169:3306
  7. Source Schema : UNIDIA
  8. Target Server Type : MySQL
  9. Target Server Version : 80030 (8.0.30-commercial)
  10. File Encoding : 65001
  11. Date: 18/06/2025 07:58:58
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for system_cache_algorithm
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `system_cache_algorithm`;
  19. CREATE TABLE `system_cache_algorithm` (
  20. `algorithm_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  21. `service_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  22. `key_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  23. `last_value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  24. PRIMARY KEY (`algorithm_code`, `service_code`, `key_name`) USING BTREE
  25. ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
  26. SET FOREIGN_KEY_CHECKS = 1;