@@ -23,7 +23,7 @@ SET FOREIGN_KEY_CHECKS = 0;
23
23
DROP TABLE IF EXISTS ` code_column_config` ;
24
24
CREATE TABLE `code_column_config ` (
25
25
` column_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
26
- ` table_name` varchar (255 ) DEFAULT NULL ,
26
+ ` table_name` varchar (180 ) DEFAULT NULL ,
27
27
` column_name` varchar (255 ) DEFAULT NULL ,
28
28
` column_type` varchar (255 ) DEFAULT NULL ,
29
29
` dict_name` varchar (255 ) DEFAULT NULL ,
@@ -35,10 +35,9 @@ CREATE TABLE `code_column_config` (
35
35
` not_null` bit (1 ) DEFAULT NULL ,
36
36
` query_type` varchar (255 ) DEFAULT NULL ,
37
37
` remark` varchar (255 ) DEFAULT NULL ,
38
- ` date_annotation` varchar (255 ) DEFAULT NULL ,
39
38
PRIMARY KEY (` column_id` ) USING BTREE,
40
39
KEY ` idx_table_name` (` table_name` )
41
- ) ENGINE= InnoDB AUTO_INCREMENT= 191 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 代码生成字段信息存储' ;
40
+ ) ENGINE= InnoDB AUTO_INCREMENT= 191 ROW_FORMAT= COMPACT COMMENT= ' 代码生成字段信息存储' ;
42
41
43
42
-- ----------------------------
44
43
-- Table structure for code_gen_config
@@ -57,7 +56,7 @@ CREATE TABLE `code_gen_config` (
57
56
` api_alias` varchar (255 ) DEFAULT NULL COMMENT ' 接口名称' ,
58
57
PRIMARY KEY (` config_id` ) USING BTREE,
59
58
KEY ` idx_table_name` (` table_name` (100 ))
60
- ) ENGINE= InnoDB AUTO_INCREMENT= 7 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 代码生成器配置' ;
59
+ ) ENGINE= InnoDB AUTO_INCREMENT= 7 ROW_FORMAT= COMPACT COMMENT= ' 代码生成器配置' ;
61
60
62
61
-- ----------------------------
63
62
-- Table structure for mnt_app
@@ -77,7 +76,7 @@ CREATE TABLE `mnt_app` (
77
76
` create_time` datetime DEFAULT NULL COMMENT ' 创建日期' ,
78
77
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
79
78
PRIMARY KEY (` app_id` ) USING BTREE
80
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 应用管理' ;
79
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 应用管理' ;
81
80
82
81
-- ----------------------------
83
82
-- Records of mnt_app
@@ -100,7 +99,7 @@ CREATE TABLE `mnt_database` (
100
99
` create_time` datetime DEFAULT NULL COMMENT ' 创建时间' ,
101
100
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
102
101
PRIMARY KEY (` db_id` ) USING BTREE
103
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 数据库管理' ;
102
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 数据库管理' ;
104
103
105
104
-- ----------------------------
106
105
-- Records of mnt_database
@@ -121,7 +120,7 @@ CREATE TABLE `mnt_deploy` (
121
120
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
122
121
PRIMARY KEY (` deploy_id` ) USING BTREE,
123
122
KEY ` FK6sy157pseoxx4fmcqr1vnvvhy` (` app_id` ) USING BTREE
124
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 部署管理' ;
123
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 部署管理' ;
125
124
126
125
-- ----------------------------
127
126
-- Records of mnt_deploy
@@ -141,7 +140,7 @@ CREATE TABLE `mnt_deploy_history` (
141
140
` ip` varchar (20 ) NOT NULL COMMENT ' 服务器IP' ,
142
141
` deploy_id` bigint (20 ) DEFAULT NULL COMMENT ' 部署编号' ,
143
142
PRIMARY KEY (` history_id` ) USING BTREE
144
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 部署历史管理' ;
143
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 部署历史管理' ;
145
144
146
145
-- ----------------------------
147
146
-- Records of mnt_deploy_history
@@ -158,7 +157,7 @@ CREATE TABLE `mnt_deploy_server` (
158
157
` server_id` bigint (20 ) NOT NULL COMMENT ' 服务ID' ,
159
158
PRIMARY KEY (` deploy_id` ,` server_id` ) USING BTREE,
160
159
KEY ` FKeaaha7jew9a02b3bk9ghols53` (` server_id` ) USING BTREE
161
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 应用与服务器关联' ;
160
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 应用与服务器关联' ;
162
161
163
162
-- ----------------------------
164
163
-- Records of mnt_deploy_server
@@ -183,7 +182,7 @@ CREATE TABLE `mnt_server` (
183
182
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
184
183
PRIMARY KEY (` server_id` ) USING BTREE,
185
184
KEY ` idx_ip` (` ip` )
186
- ) ENGINE= InnoDB AUTO_INCREMENT= 2 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 服务器管理' ;
185
+ ) ENGINE= InnoDB AUTO_INCREMENT= 2 ROW_FORMAT= COMPACT COMMENT= ' 服务器管理' ;
187
186
188
187
-- ----------------------------
189
188
-- Table structure for sys_dept
@@ -203,7 +202,7 @@ CREATE TABLE `sys_dept` (
203
202
PRIMARY KEY (` dept_id` ) USING BTREE,
204
203
KEY ` inx_pid` (` pid` ),
205
204
KEY ` inx_enabled` (` enabled` )
206
- ) ENGINE= InnoDB AUTO_INCREMENT= 18 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 部门' ;
205
+ ) ENGINE= InnoDB AUTO_INCREMENT= 18 ROW_FORMAT= COMPACT COMMENT= ' 部门' ;
207
206
208
207
-- ----------------------------
209
208
-- Records of sys_dept
@@ -231,7 +230,7 @@ CREATE TABLE `sys_dict` (
231
230
` create_time` datetime DEFAULT NULL COMMENT ' 创建日期' ,
232
231
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
233
232
PRIMARY KEY (` dict_id` ) USING BTREE
234
- ) ENGINE= InnoDB AUTO_INCREMENT= 6 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 数据字典' ;
233
+ ) ENGINE= InnoDB AUTO_INCREMENT= 6 ROW_FORMAT= COMPACT COMMENT= ' 数据字典' ;
235
234
236
235
-- ----------------------------
237
236
-- Records of sys_dict
@@ -258,7 +257,7 @@ CREATE TABLE `sys_dict_detail` (
258
257
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
259
258
PRIMARY KEY (` detail_id` ) USING BTREE,
260
259
KEY ` FK5tpkputc6d9nboxojdbgnpmyb` (` dict_id` ) USING BTREE
261
- ) ENGINE= InnoDB AUTO_INCREMENT= 7 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 数据字典详情' ;
260
+ ) ENGINE= InnoDB AUTO_INCREMENT= 7 ROW_FORMAT= COMPACT COMMENT= ' 数据字典详情' ;
262
261
263
262
-- ----------------------------
264
263
-- Records of sys_dict_detail
@@ -278,7 +277,7 @@ COMMIT;
278
277
DROP TABLE IF EXISTS ` sys_job` ;
279
278
CREATE TABLE `sys_job ` (
280
279
` job_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
281
- ` name` varchar (255 ) NOT NULL COMMENT ' 岗位名称' ,
280
+ ` name` varchar (180 ) NOT NULL COMMENT ' 岗位名称' ,
282
281
` enabled` bit (1 ) NOT NULL COMMENT ' 岗位状态' ,
283
282
` job_sort` int (5 ) DEFAULT NULL COMMENT ' 排序' ,
284
283
` create_by` varchar (255 ) DEFAULT NULL COMMENT ' 创建者' ,
@@ -288,7 +287,7 @@ CREATE TABLE `sys_job` (
288
287
PRIMARY KEY (` job_id` ) USING BTREE,
289
288
UNIQUE KEY ` uniq_name` (` name` ),
290
289
KEY ` inx_enabled` (` enabled` )
291
- ) ENGINE= InnoDB AUTO_INCREMENT= 13 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 岗位' ;
290
+ ) ENGINE= InnoDB AUTO_INCREMENT= 13 ROW_FORMAT= COMPACT COMMENT= ' 岗位' ;
292
291
293
292
-- ----------------------------
294
293
-- Records of sys_job
@@ -307,7 +306,7 @@ DROP TABLE IF EXISTS `sys_log`;
307
306
CREATE TABLE `sys_log ` (
308
307
` log_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
309
308
` description` varchar (255 ) DEFAULT NULL ,
310
- ` log_type` varchar (255 ) DEFAULT NULL ,
309
+ ` log_type` varchar (10 ) DEFAULT NULL ,
311
310
` method` varchar (255 ) DEFAULT NULL ,
312
311
` params` text DEFAULT NULL ,
313
312
` request_ip` varchar (255 ) DEFAULT NULL ,
@@ -320,7 +319,7 @@ CREATE TABLE `sys_log` (
320
319
PRIMARY KEY (` log_id` ) USING BTREE,
321
320
KEY ` log_create_time_index` (` create_time` ),
322
321
KEY ` inx_log_type` (` log_type` )
323
- ) ENGINE= InnoDB AUTO_INCREMENT= 3537 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 系统日志' ;
322
+ ) ENGINE= InnoDB AUTO_INCREMENT= 3537 ROW_FORMAT= COMPACT COMMENT= ' 系统日志' ;
324
323
325
324
-- ----------------------------
326
325
-- Table structure for sys_menu
@@ -331,8 +330,8 @@ CREATE TABLE `sys_menu` (
331
330
` pid` bigint (20 ) DEFAULT NULL COMMENT ' 上级菜单ID' ,
332
331
` sub_count` int (5 ) DEFAULT 0 COMMENT ' 子菜单数目' ,
333
332
` type` int (11 ) DEFAULT NULL COMMENT ' 菜单类型' ,
334
- ` title` varchar (255 ) DEFAULT NULL COMMENT ' 菜单标题' ,
335
- ` name` varchar (255 ) DEFAULT NULL COMMENT ' 组件名称' ,
333
+ ` title` varchar (100 ) DEFAULT NULL COMMENT ' 菜单标题' ,
334
+ ` name` varchar (100 ) DEFAULT NULL COMMENT ' 组件名称' ,
336
335
` component` varchar (255 ) DEFAULT NULL COMMENT ' 组件' ,
337
336
` menu_sort` int (5 ) DEFAULT NULL COMMENT ' 排序' ,
338
337
` icon` varchar (255 ) DEFAULT NULL COMMENT ' 图标' ,
@@ -349,7 +348,7 @@ CREATE TABLE `sys_menu` (
349
348
UNIQUE KEY ` uniq_title` (` title` ),
350
349
UNIQUE KEY ` uniq_name` (` name` ),
351
350
KEY ` inx_pid` (` pid` )
352
- ) ENGINE= InnoDB AUTO_INCREMENT= 118 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 系统菜单' ;
351
+ ) ENGINE= InnoDB AUTO_INCREMENT= 118 ROW_FORMAT= COMPACT COMMENT= ' 系统菜单' ;
353
352
354
353
-- ----------------------------
355
354
-- Records of sys_menu
@@ -456,7 +455,7 @@ CREATE TABLE `sys_quartz_job` (
456
455
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
457
456
PRIMARY KEY (` job_id` ) USING BTREE,
458
457
KEY ` inx_is_pause` (` is_pause` )
459
- ) ENGINE= InnoDB AUTO_INCREMENT= 7 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 定时任务' ;
458
+ ) ENGINE= InnoDB AUTO_INCREMENT= 7 ROW_FORMAT= COMPACT COMMENT= ' 定时任务' ;
460
459
461
460
-- ----------------------------
462
461
-- Records of sys_quartz_job
@@ -484,16 +483,16 @@ CREATE TABLE `sys_quartz_log` (
484
483
` params` varchar (255 ) DEFAULT NULL ,
485
484
` time` bigint (20 ) DEFAULT NULL ,
486
485
PRIMARY KEY (` log_id` ) USING BTREE
487
- ) ENGINE= InnoDB AUTO_INCREMENT= 151 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 定时任务日志' ;
486
+ ) ENGINE= InnoDB AUTO_INCREMENT= 151 ROW_FORMAT= COMPACT COMMENT= ' 定时任务日志' ;
488
487
489
488
-- ----------------------------
490
489
-- Table structure for sys_role
491
490
-- ----------------------------
492
491
DROP TABLE IF EXISTS ` sys_role` ;
493
492
CREATE TABLE `sys_role ` (
494
493
` role_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
495
- ` name` varchar (255 ) NOT NULL COMMENT ' 名称' ,
496
- ` level` int (255 ) DEFAULT NULL COMMENT ' 角色级别' ,
494
+ ` name` varchar (100 ) NOT NULL COMMENT ' 名称' ,
495
+ ` level` int (50 ) DEFAULT NULL COMMENT ' 角色级别' ,
497
496
` description` varchar (255 ) DEFAULT NULL COMMENT ' 描述' ,
498
497
` data_scope` varchar (255 ) DEFAULT NULL COMMENT ' 数据权限' ,
499
498
` create_by` varchar (255 ) DEFAULT NULL COMMENT ' 创建者' ,
@@ -503,7 +502,7 @@ CREATE TABLE `sys_role` (
503
502
PRIMARY KEY (` role_id` ) USING BTREE,
504
503
UNIQUE KEY ` uniq_name` (` name` ),
505
504
KEY ` role_name_index` (` name` )
506
- ) ENGINE= InnoDB AUTO_INCREMENT= 3 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 角色表' ;
505
+ ) ENGINE= InnoDB AUTO_INCREMENT= 3 ROW_FORMAT= COMPACT COMMENT= ' 角色表' ;
507
506
508
507
-- ----------------------------
509
508
-- Records of sys_role
@@ -522,7 +521,7 @@ CREATE TABLE `sys_roles_depts` (
522
521
` dept_id` bigint (20 ) NOT NULL ,
523
522
PRIMARY KEY (` role_id` ,` dept_id` ) USING BTREE,
524
523
KEY ` FK7qg6itn5ajdoa9h9o78v9ksur` (` dept_id` ) USING BTREE
525
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 角色部门关联' ;
524
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 角色部门关联' ;
526
525
527
526
-- ----------------------------
528
527
-- Table structure for sys_roles_menus
@@ -533,7 +532,7 @@ CREATE TABLE `sys_roles_menus` (
533
532
` role_id` bigint (20 ) NOT NULL COMMENT ' 角色ID' ,
534
533
PRIMARY KEY (` menu_id` ,` role_id` ) USING BTREE,
535
534
KEY ` FKcngg2qadojhi3a651a5adkvbq` (` role_id` ) USING BTREE
536
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 角色菜单关联' ;
535
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 角色菜单关联' ;
537
536
538
537
-- ----------------------------
539
538
-- Records of sys_roles_menus
@@ -649,11 +648,11 @@ DROP TABLE IF EXISTS `sys_user`;
649
648
CREATE TABLE `sys_user ` (
650
649
` user_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
651
650
` dept_id` bigint (20 ) DEFAULT NULL COMMENT ' 部门名称' ,
652
- ` username` varchar (255 ) DEFAULT NULL COMMENT ' 用户名' ,
651
+ ` username` varchar (180 ) DEFAULT NULL COMMENT ' 用户名' ,
653
652
` nick_name` varchar (255 ) DEFAULT NULL COMMENT ' 昵称' ,
654
653
` gender` varchar (2 ) DEFAULT NULL COMMENT ' 性别' ,
655
654
` phone` varchar (255 ) DEFAULT NULL COMMENT ' 手机号码' ,
656
- ` email` varchar (255 ) DEFAULT NULL COMMENT ' 邮箱' ,
655
+ ` email` varchar (180 ) DEFAULT NULL COMMENT ' 邮箱' ,
657
656
` avatar_name` varchar (255 ) DEFAULT NULL COMMENT ' 头像地址' ,
658
657
` avatar_path` varchar (255 ) DEFAULT NULL COMMENT ' 头像真实路径' ,
659
658
` password` varchar (255 ) DEFAULT NULL COMMENT ' 密码' ,
@@ -670,9 +669,8 @@ CREATE TABLE `sys_user` (
670
669
UNIQUE KEY ` uniq_username` (` username` ),
671
670
UNIQUE KEY ` uniq_email` (` email` ),
672
671
KEY ` FK5rwmryny6jthaaxkogownknqp` (` dept_id` ) USING BTREE,
673
- KEY ` FKpq2dhypk2qgt68nauh2by22jb` (` avatar_name` ) USING BTREE,
674
672
KEY ` inx_enabled` (` enabled` )
675
- ) ENGINE= InnoDB AUTO_INCREMENT= 3 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 系统用户' ;
673
+ ) ENGINE= InnoDB AUTO_INCREMENT= 3 ROW_FORMAT= COMPACT COMMENT= ' 系统用户' ;
676
674
677
675
-- ----------------------------
678
676
-- Records of sys_user
@@ -709,7 +707,7 @@ CREATE TABLE `sys_users_roles` (
709
707
` role_id` bigint (20 ) NOT NULL COMMENT ' 角色ID' ,
710
708
PRIMARY KEY (` user_id` ,` role_id` ) USING BTREE,
711
709
KEY ` FKq4eq273l04bpu4efj0jd0jb98` (` role_id` ) USING BTREE
712
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 用户角色关联' ;
710
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 用户角色关联' ;
713
711
714
712
-- ----------------------------
715
713
-- Records of sys_users_roles
@@ -736,7 +734,7 @@ CREATE TABLE `tool_alipay_config` (
736
734
` sign_type` varchar (255 ) DEFAULT NULL COMMENT ' 签名方式' ,
737
735
` sys_service_provider_id` varchar (255 ) DEFAULT NULL COMMENT ' 商户号' ,
738
736
PRIMARY KEY (` config_id` ) USING BTREE
739
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 支付宝配置类' ;
737
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 支付宝配置类' ;
740
738
741
739
-- ----------------------------
742
740
-- Records of tool_alipay_config
@@ -757,7 +755,7 @@ CREATE TABLE `tool_email_config` (
757
755
` port` varchar (255 ) DEFAULT NULL COMMENT ' 端口' ,
758
756
` user` varchar (255 ) DEFAULT NULL COMMENT ' 发件者用户名' ,
759
757
PRIMARY KEY (` config_id` ) USING BTREE
760
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 邮箱配置' ;
758
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 邮箱配置' ;
761
759
762
760
-- ----------------------------
763
761
-- Table structure for tool_local_storage
@@ -776,7 +774,7 @@ CREATE TABLE `tool_local_storage` (
776
774
` create_time` datetime DEFAULT NULL COMMENT ' 创建日期' ,
777
775
` update_time` datetime DEFAULT NULL COMMENT ' 更新时间' ,
778
776
PRIMARY KEY (` storage_id` ) USING BTREE
779
- ) ENGINE= InnoDB AUTO_INCREMENT= 10 DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 本地存储' ;
777
+ ) ENGINE= InnoDB AUTO_INCREMENT= 10 ROW_FORMAT= COMPACT COMMENT= ' 本地存储' ;
780
778
781
779
-- ----------------------------
782
780
-- Records of tool_local_storage
@@ -797,7 +795,7 @@ CREATE TABLE `tool_qiniu_config` (
797
795
` type` varchar (255 ) DEFAULT NULL COMMENT ' 空间类型' ,
798
796
` zone` varchar (255 ) DEFAULT NULL COMMENT ' 机房' ,
799
797
PRIMARY KEY (` config_id` ) USING BTREE
800
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 七牛云配置' ;
798
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 七牛云配置' ;
801
799
802
800
-- ----------------------------
803
801
-- Table structure for tool_qiniu_content
@@ -806,20 +804,20 @@ DROP TABLE IF EXISTS `tool_qiniu_content`;
806
804
CREATE TABLE `tool_qiniu_content ` (
807
805
` content_id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
808
806
` bucket` varchar (255 ) DEFAULT NULL COMMENT ' Bucket 识别符' ,
809
- ` name` varchar (255 ) DEFAULT NULL COMMENT ' 文件名称' ,
807
+ ` name` varchar (180 ) DEFAULT NULL COMMENT ' 文件名称' ,
810
808
` size` varchar (255 ) DEFAULT NULL COMMENT ' 文件大小' ,
811
809
` type` varchar (255 ) DEFAULT NULL COMMENT ' 文件类型:私有或公开' ,
812
810
` url` varchar (255 ) DEFAULT NULL COMMENT ' 文件url' ,
813
811
` suffix` varchar (255 ) DEFAULT NULL COMMENT ' 文件后缀' ,
814
812
` update_time` datetime DEFAULT NULL COMMENT ' 上传或同步的时间' ,
815
813
PRIMARY KEY (` content_id` ) USING BTREE,
816
814
UNIQUE KEY ` uniq_name` (` name` )
817
- ) ENGINE= InnoDB DEFAULT CHARSET = utf8 ROW_FORMAT= COMPACT COMMENT= ' 七牛云文件存储' ;
815
+ ) ENGINE= InnoDB ROW_FORMAT= COMPACT COMMENT= ' 七牛云文件存储' ;
818
816
819
817
-- ----------------------------
820
818
-- Records of tool_qiniu_content
821
819
-- ----------------------------
822
820
BEGIN ;
823
821
COMMIT ;
824
822
825
- SET FOREIGN_KEY_CHECKS = 1 ;
823
+ SET FOREIGN_KEY_CHECKS = 1 ;
0 commit comments