首页 发现 帮助
登录
ztf
/
db_mcyc
0
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
分支: master
分支列表 标签列表
db_mcyc
/
sql
/
20250915sys_file.sql

20250915sys_file.sql 11 KB
永久链接 文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113 
  1. /*
    2. 

  2.  Navicat Premium Dump SQL
    3. 

  3. 

  4.  Source Server         : db_mcyc
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 100508 (10.5.8-MariaDB)
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : db_mcyc
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 100508 (10.5.8-MariaDB)
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 15/09/2025 14:23:40
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for sys_file
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `sys_file`;
    24. 

  24. CREATE TABLE `sys_file`  (
    25. 

  25.   `file_id` bigint NOT NULL AUTO_INCREMENT COMMENT '文件ID',
    26. 

  26.   `folder_id` int NULL DEFAULT NULL,
    27. 

  27.   `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    28. 

  28.   `file_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件类型',
    29. 

  29.   `file_size` bigint NULL DEFAULT 0 COMMENT '文件大小（字节）',
    30. 

  30.   `file_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件存储路径',
    31. 

  31.   `download_count` int NULL DEFAULT 0 COMMENT '下载次数',
    32. 

  32.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    33. 

  33.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0存在 2删除）',
    34. 

  34.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    35. 

  35.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    36. 

  36.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    37. 

  37.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    38. 

  38.   `dept_id` bigint NOT NULL COMMENT '部门ID',
    39. 

  39.   PRIMARY KEY (`file_id`) USING BTREE,
    40. 

  40.   INDEX `idx_folder_id`(`folder_id` ASC) USING BTREE
    41. 

  41. ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件表' ROW_FORMAT = Dynamic;
    42. 

  42. 

  43. -- ----------------------------
    44. 

  44. -- Records of sys_file
    45. 

  45. -- ----------------------------
    46. 

  46. INSERT INTO `sys_file` VALUES (1, 2, '11111.txt', 'txt', 29736, 'files/machengzhishiku/huiyijilu/11111.txt', 2, '0', '0', 'XZL', '2025-07-02 14:15:07', 'XZL', '2025-07-03 11:11:30', 103);
    47. 

  47. INSERT INTO `sys_file` VALUES (2, 2, '11111(1).txt', 'txt', 29736, 'files/machengzhishiku/huiyijilu/11111(1).txt', 1, '0', '0', 'XZL', '2025-07-02 14:15:19', '', NULL, 103);
    48. 

  48. INSERT INTO `sys_file` VALUES (3, 1, '模板.doc', 'doc', 9216, 'files/machengzhishiku/模板.doc', 2, '0', '0', 'XZL', '2025-07-02 14:22:15', 'XZL', '2025-07-02 16:13:49', 103);
    49. 

  49. INSERT INTO `sys_file` VALUES (4, 1, '11111.txt', 'txt', 29736, 'files/machengzhishiku/11111.txt', 1, '0', '0', 'XZL', '2025-07-02 14:22:23', '', NULL, 103);
    50. 

  50. INSERT INTO `sys_file` VALUES (5, 1, '11.bmp', 'bmp', 0, 'files/machengzhishiku/11.bmp', 2, '0', '0', 'XZL', '2025-07-02 14:22:28', '', NULL, 103);
    51. 

  51. INSERT INTO `sys_file` VALUES (7, 9, '666.ppt', 'ppt', 20992, 'files/machengzhishiku/huiyijilu/bumenhuiyi/xiaozuhuiyi/666.ppt', 1, '1', '0', '小李', '2025-07-03 11:21:29', '小李', '2025-07-03 11:22:22', 201);
    52. 

  52. INSERT INTO `sys_file` VALUES (8, 9, '222.docx', 'docx', 0, 'files/machengzhishiku/huiyijilu/bumenhuiyi/xiaozuhuiyi/222.docx', 2, '0', '0', '小李', '2025-07-03 11:21:40', '', NULL, 201);
    53. 

  53. INSERT INTO `sys_file` VALUES (9, 9, '4.xls', 'xls', 18432, 'files/machengzhishiku/huiyijilu/bumenhuiyi/xiaozuhuiyi/4.xls', 2, '0', '0', '小李', '2025-07-03 11:21:49', '', NULL, 201);
    54. 

  54. INSERT INTO `sys_file` VALUES (25, 8, '11111.txt', 'txt', 29736, 'files/machengzhishiku/huiyijilu/bumenhuiyi/11111.txt', 0, '0', '0', 'XZL', '2025-07-03 16:03:06', '', NULL, 103);
    55. 

  55. INSERT INTO `sys_file` VALUES (28, 8, '666.ppt', 'ppt', 41984, 'files/machengzhishiku/huiyijilu/bumenhuiyi/666.ppt', 0, '0', '0', 'XZL', '2025-07-03 16:05:48', '', NULL, 103);
    56. 

  56. INSERT INTO `sys_file` VALUES (29, 8, '666(1).ppt', 'ppt', 41984, 'files/machengzhishiku/huiyijilu/bumenhuiyi/666(1).ppt', 0, '0', '0', 'XZL', '2025-07-03 16:06:18', '', NULL, 103);
    57. 

  57. INSERT INTO `sys_file` VALUES (30, 8, '222.docx', 'docx', 13809, 'files/machengzhishiku/huiyijilu/bumenhuiyi/222.docx', 0, '0', '0', 'XZL', '2025-07-03 16:07:18', '', NULL, 103);
    58. 

  58. INSERT INTO `sys_file` VALUES (31, 8, '模板.doc', 'doc', 9216, 'files/machengzhishiku/huiyijilu/bumenhuiyi/模板.doc', 0, '0', '0', 'XZL', '2025-07-03 16:07:58', '', NULL, 103);
    59. 

  59. INSERT INTO `sys_file` VALUES (32, 19, '模板.doc', 'doc', 9216, 'files/machengzhishiku/caiwuguanli/caiwu/模板.doc', 1, '0', '0', 'XZL', '2025-08-12 17:32:59', '', NULL, 103);
    60. 

  60. INSERT INTO `sys_file` VALUES (33, 19, '麻城市局需求.doc', 'doc', 794169, 'files/machengzhishiku/caiwuguanli/caiwu/麻城市局需求.doc', 1, '0', '0', 'XZL', '2025-08-12 17:33:31', '', NULL, 103);
    61. 

  61. INSERT INTO `sys_file` VALUES (34, 22, '麻城市局需求.doc', 'doc', 794169, 'files/machengzhishiku/lingdaoxinxi/bumenlingdao/xinxi/麻城市局需求.doc', 2, '1', '0', 'XZL', '2025-08-13 10:08:09', 'XZL', '2025-08-13 10:12:41', 103);
    62. 

  62. 

  63. -- ----------------------------
    64. 

  64. -- Table structure for sys_file_folder
    65. 

  65. -- ----------------------------
    66. 

  66. DROP TABLE IF EXISTS `sys_file_folder`;
    67. 

  67. CREATE TABLE `sys_file_folder`  (
    68. 

  68.   `folder_id` bigint NOT NULL AUTO_INCREMENT COMMENT '文件夹ID',
    69. 

  69.   `parent_id` bigint NULL DEFAULT 0 COMMENT '父文件夹ID（0表示顶级）',
    70. 

  70.   `ancestors` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '祖级列表（格式：,1,5,15,）',
    71. 

  71.   `folder_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    72. 

  72.   `level` tinyint NULL DEFAULT 1 COMMENT '层级（1麻城知识库 2二级 3三级 4四级）',
    73. 

  73.   `order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
    74. 

  74.   `full_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '完整路径（如/麻城知识库/部门文档/财务部/预算）',
    75. 

  75.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    76. 

  76.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0存在 2删除）',
    77. 

  77.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    78. 

  78.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    79. 

  79.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    80. 

  80.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    81. 

  81.   `dept_id` bigint NOT NULL,
    82. 

  82.   PRIMARY KEY (`folder_id`) USING BTREE,
    83. 

  83.   INDEX `idx_ancestors`(`ancestors`(20) ASC) USING BTREE,
    84. 

  84.   INDEX `idx_parent_id`(`parent_id` ASC) USING BTREE
    85. 

  85. ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '文件文件夹表（麻城知识库四级结构）' ROW_FORMAT = Dynamic;
    86. 

  86. 

  87. -- ----------------------------
    88. 

  88. -- Records of sys_file_folder
    89. 

  89. -- ----------------------------
    90. 

  90. INSERT INTO `sys_file_folder` VALUES (1, 0, '', '麻城知识库', 1, 1, 'files/machengzhishiku', '0', '0', 'XZL', NULL, '', NULL, 103);
    91. 

  91. INSERT INTO `sys_file_folder` VALUES (2, 1, ',1', '会议记录', 2, 2, 'files/machengzhishiku/会议记录', '0', '0', 'XZL', '2025-07-02 12:01:13', '', NULL, 201);
    92. 

  92. INSERT INTO `sys_file_folder` VALUES (3, 1, ',1', '领导信息', 2, 2, 'files/machengzhishiku/领导会议', '0', '0', 'XZL', '2025-07-02 14:43:42', 'XZL', '2025-07-02 15:09:10', 200);
    93. 

  93. INSERT INTO `sys_file_folder` VALUES (4, 1, ',1', '综合档案', 2, 2, 'files/machengzhishiku/综合档案', '0', '0', 'XZL', '2025-07-02 14:43:58', '', NULL, 202);
    94. 

  94. INSERT INTO `sys_file_folder` VALUES (5, 1, ',1', '政策汇总', 2, 2, 'files/machengzhishiku/政策汇总', '0', '0', 'XZL', '2025-07-02 14:44:14', '', NULL, 204);
    95. 

  95. INSERT INTO `sys_file_folder` VALUES (6, 1, ',1', '安全守则', 2, 2, 'files/machengzhishiku/安全手册', '0', '0', 'XZL', '2025-07-02 14:44:27', 'XZL', '2025-07-04 09:10:57', 205);
    96. 

  96. INSERT INTO `sys_file_folder` VALUES (7, 1, ',1', '财务管理', 2, 2, 'files/machengzhishiku/财务管理', '0', '0', 'XZL', '2025-07-02 14:44:39', '', NULL, 206);
    97. 

  97. INSERT INTO `sys_file_folder` VALUES (8, 2, ',1,2', '部门会议', 3, 3, 'files/machengzhishiku/会议记录/部门会议', '0', '0', 'XZL', '2025-07-02 15:08:31', '小李', '2025-07-04 09:12:05', 201);
    98. 

  98. INSERT INTO `sys_file_folder` VALUES (9, 8, ',1,2,8', '小组会议', 4, 4, 'files/machengzhishiku/会议记录/部门会议/小组会议', '0', '0', 'XZL', '2025-07-02 15:08:41', '', NULL, 201);
    99. 

  99. INSERT INTO `sys_file_folder` VALUES (10, 3, ',1,3', '部门领导', 3, 3, 'files/machengzhishiku/领导会议/部门领导', '0', '0', 'XZL', '2025-07-02 15:09:20', '', NULL, 200);
    100. 

  100. INSERT INTO `sys_file_folder` VALUES (11, 4, ',1,4', '工作档案', 3, 3, 'files/machengzhishiku/综合档案/工作档案', '0', '0', 'XZL', '2025-07-02 15:10:12', '', NULL, 202);
    101. 

  101. INSERT INTO `sys_file_folder` VALUES (12, 11, ',1,4,11', '小组档案', 4, 4, 'files/machengzhishiku/综合档案/工作档案/小组档案', '0', '0', 'XZL', '2025-07-02 15:10:34', '', NULL, 202);
    102. 

  102. INSERT INTO `sys_file_folder` VALUES (13, 4, ',1,4', '活动档案', 3, 3, 'files/machengzhishiku/综合档案/活动档案', '0', '0', 'XZL', '2025-07-02 15:10:44', '', NULL, 202);
    103. 

  103. INSERT INTO `sys_file_folder` VALUES (14, 13, ',1,4,13', '周年庆', 4, 4, 'files/machengzhishiku/综合档案/活动档案/周年庆', '0', '0', 'XZL', '2025-07-02 15:10:57', '', NULL, 202);
    104. 

  104. INSERT INTO `sys_file_folder` VALUES (15, 5, ',1,5', '省政策', 3, 3, 'files/machengzhishiku/政策汇总/省政策', '0', '0', 'XZL', '2025-07-02 15:11:10', '', NULL, 204);
    105. 

  105. INSERT INTO `sys_file_folder` VALUES (16, 15, ',1,5,15', '区政策', 4, 4, 'files/machengzhishiku/政策汇总/省政策/区政策', '0', '0', 'XZL', '2025-07-02 15:11:19', '', NULL, 204);
    106. 

  106. INSERT INTO `sys_file_folder` VALUES (17, 15, ',1,5,15', '乡镇政策', 4, 4, 'files/machengzhishiku/政策汇总/省政策/乡镇政策', '0', '0', 'XZL', '2025-07-02 15:11:36', '', NULL, 204);
    107. 

  107. INSERT INTO `sys_file_folder` VALUES (18, 8, ',1,2,8', '项目会议', 4, 4, 'files/machengzhishiku/会议记录/部门会议/直属领导会议', '0', '0', '小李', '2025-07-04 09:24:55', 'XZL', '2025-07-04 09:25:56', 201);
    108. 

  108. INSERT INTO `sys_file_folder` VALUES (19, 7, ',1,7', '财务', 3, 3, 'files/machengzhishiku/财务管理/财务', '0', '0', 'XZL', '2025-08-12 17:32:37', '', NULL, 206);
    109. 

  109. INSERT INTO `sys_file_folder` VALUES (20, 19, ',1,7,19', '111', 4, 4, 'files/machengzhishiku/财务管理/财务/111', '0', '0', 'XZL', '2025-08-12 17:32:46', '', NULL, 206);
    110. 

  110. INSERT INTO `sys_file_folder` VALUES (21, 6, ',1,6', '安全', 3, 3, 'files/machengzhishiku/安全手册/安全', '0', '0', 'XZL', '2025-08-13 09:09:22', '', NULL, 205);
    111. 

  111. INSERT INTO `sys_file_folder` VALUES (22, 10, ',1,3,10', '信息', 4, 4, 'files/machengzhishiku/领导会议/部门领导/信息', '0', '0', 'XZL', '2025-08-13 10:06:25', '', NULL, 200);
    112. 

  112. 

  113. SET FOREIGN_KEY_CHECKS = 1;
    114.