member_roles

Column NameTypeCommentsDefaultNullRemark
idint UNSIGNEDPrimary IDNOAUTO_INCREMENT
namevarchar(128)角色名NO多语言
typetinyint UNSIGNED角色类型3NO1.管理人员类:管理员、版主
2.系统设置类:待审核用户、禁止用户
3.用户运营类:普通会员、高级会员
icon_file_idbigint UNSIGNED角色图标文件 IDYES关联字段 files > id
icon_file_urlvarchar(255)图标文件完整 URLNO“images_bucket_domain”键值
拼接成的完整 URL 地址
is_display_nametinyint UNSIGNED是否显示文字标识00.不显示 / 1.显示
is_display_icontinyint UNSIGNED是否显示图标标识00.不显示 / 1.显示
nickname_colorchar(7)成员昵称颜色值YES
permissionjson权限参数NO
rank_numsmallint UNSIGNED排列顺序99NO升序排序
is_enabletinyint UNSIGNED是否启用1NO0=Disable(false) / 1=Enable(true)
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES

角色类型介绍

  • 管理人员类,在后台“用户配置”页面,选择“默认用户角色”和“禁言用户角色”时,不供选择,无法作为配置项。

权限参数 permission 字段内容介绍

[
    //基础设置
    {
        "permKey": "content_view", //浏览权限
        "permValue": true,  //false=无权;true=有权
        "permStatus": "" //为空代表用不到,有值代表有用,具体由插件和客户端决定,以下所有都是这个用途。
    },
    {
        "permKey": "dialog", //会话权限
        "permValue": true, //false=无权;true=有权
        "permStatus": ""
    },
    //发表帖子设置
    {
        "permKey": "post_publish", //发表帖子权限
        "permValue": true, //false=无权;true=有权
        "permStatus": ""
    },
    {
        "permKey": "post_review", //发表帖子是否需要审核
        "permValue": false, //false=不需要;true=需要
        "permStatus": ""
    },
    {
        "permKey": "post_email_verify", //发表帖子要求-邮箱
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "post_phone_verify", //发表帖子要求-手机号
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "post_prove_verify", //发表帖子要求-实名制
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "post_limit_status", //发表帖子特殊规则
        "permValue": false, //false=关闭;true=开启
        "permStatus": ""
    },
    {
        "permKey": "post_limit_type", //规则类型,当 post_limit_status=true 时有效
        "permValue": 1, //1.指定某个时间段范围内生效 2.指定每天的某个时间段范围内循环生效
        "permStatus": ""
    },
    {
        "permKey": "post_limit_period_start", //post_limit_type=1 专用
        "permValue": "2021-08-01 22:30:00", //开始日期和时间
        "permStatus": ""
    },
    {
        "permKey": "post_limit_period_end", //post_limit_type=1 专用
        "permValue": "2021-08-02 08:00:00", //结束日期和时间
        "permStatus": ""
    },
    {
        "permKey": "post_limit_cycle_start", //post_limit_type=2 专用
        "permValue": "23:00:00", //开始时间
        "permStatus": ""
    },
    {
        "permKey": "post_limit_cycle_end", //post_limit_type=2 专用
        "permValue": "08:30:00", //结束时间
        "permStatus": ""
    },
    {
        "permKey": "post_limit_rule", //限制规则
        "permValue": 1, //1.可以发表,但是需要审核 2.禁止发表
        "permStatus": ""
    },
    //发表评论设置
    {
        "permKey": "comment_publish", //发表评论权限
        "permValue": true, //false=无权;true=有权
        "permStatus": ""
    },
    {
        "permKey": "comment_review", //发表评论是否需要审核
        "permValue": false, //false=不需要;true=需要
        "permStatus": ""
    },
    {
        "permKey": "comment_email_verify", //发表评论要求-邮箱
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "comment_phone_verify", //发表评论要求-手机号
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "comment_prove_verify", //发表评论要求-实名制
        "permValue": false, //false=不要求;true=要求
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_status", //发表评论特殊规则
        "permValue": false, //false=关闭;true=开启
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_type", //规则类型,当 comment_limit_status=true 时有效
        "permValue": 1, //1.指定某个时间段范围内生效 2.指定每天的某个时间段范围内循环生效
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_period_start", //comment_limit_type=1 专用
        "permValue": "2021-08-01 22:30:00", //开始日期和时间
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_period_end", //comment_limit_type=1 专用
        "permValue": "2021-08-02 08:00:00", //结束日期和时间
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_cycle_start", //comment_limit_type=2 专用
        "permValue": "23:00:00", //开始时间
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_cycle_end", //comment_limit_type=2 专用
        "permValue": "08:30:00", //结束时间
        "permStatus": ""
    },
    {
        "permKey": "comment_limit_rule", //限制规则
        "permValue": 1, //1.可以发表,但是需要审核 2.禁止发表
        "permStatus": ""
    },
    //上传权限设置
    {
        "permKey": "post_editor_image", //上传图片
        "permValue": true, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "post_editor_video", //上传视频
        "permValue": true, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "post_editor_audio", //上传音频
        "permValue": true, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "post_editor_doc", //上传文档
        "permValue": true, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "comment_editor_image", //上传图片
        "permValue": true, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "comment_editor_video", //上传视频
        "permValue": false, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "comment_editor_audio", //上传音频
        "permValue": false, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    {
        "permKey": "comment_editor_doc", //上传文档
        "permValue": false, //false=不可上传;true=可以上传
        "permStatus": ""
    },
    //上传配置值
    {
        "permKey": "images_max_size", //上传图片,支持的最大尺寸
        "permValue": 5, //单位 MB
        "permStatus": ""
    },
    {
        "permKey": "videos_max_size", //上传视频,支持的最大尺寸
        "permValue": 50, //单位 MB
        "permStatus": ""
    },
    {
        "permKey": "videos_max_time", //上传视频,视频支持的最大时长
        "permValue": 15, //单位 秒
        "permStatus": ""
    },
    {
        "permKey": "audios_max_size", //上传音频,支持的最大尺寸
        "permValue": 50, //单位 MB
        "permStatus": ""
    },
    {
        "permKey": "audios_max_time", //上传音频,音频支持的最大时长
        "permValue": 60, //单位 秒
        "permStatus": ""
    },
    {
        "permKey": "docs_max_size", //上传文档,支持的最大尺寸
        "permValue": 10, //单位 MB
        "permStatus": ""
    },
    //下载设置
    {
        "permKey": "download_file_count", //下载文件
        "permValue": 999, //24 小时内允许下载次数
        "permStatus": ""
    },
]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213

权限参数默认值(压缩后)

//正常角色
[{"permKey":"content_view","permValue":true,"permStatus":""},{"permKey":"dialog","permValue":true,"permStatus":""},{"permKey":"post_publish","permValue":true,"permStatus":""},{"permKey":"post_review","permValue":false,"permStatus":""},{"permKey":"post_email_verify","permValue":false,"permStatus":""},{"permKey":"post_phone_verify","permValue":false,"permStatus":""},{"permKey":"post_prove_verify","permValue":false,"permStatus":""},{"permKey":"post_limit_status","permValue":false,"permStatus":""},{"permKey":"post_limit_type","permValue":1,"permStatus":""},{"permKey":"post_limit_period_start","permValue":"2021-08-01 22:30:00","permStatus":""},{"permKey":"post_limit_period_end","permValue":"2021-08-02 08:00:00","permStatus":""},{"permKey":"post_limit_cycle_start","permValue":"23:00:00","permStatus":""},{"permKey":"post_limit_cycle_end","permValue":"08:30:00","permStatus":""},{"permKey":"post_limit_rule","permValue":1,"permStatus":""},{"permKey":"comment_publish","permValue":true,"permStatus":""},{"permKey":"comment_review","permValue":false,"permStatus":""},{"permKey":"comment_email_verify","permValue":false,"permStatus":""},{"permKey":"comment_phone_verify","permValue":false,"permStatus":""},{"permKey":"comment_prove_verify","permValue":false,"permStatus":""},{"permKey":"comment_limit_status","permValue":false,"permStatus":""},{"permKey":"comment_limit_type","permValue":1,"permStatus":""},{"permKey":"comment_limit_period_start","permValue":"2021-08-01 22:30:00","permStatus":""},{"permKey":"comment_limit_period_end","permValue":"2021-08-02 08:00:00","permStatus":""},{"permKey":"comment_limit_cycle_start","permValue":"23:00:00","permStatus":""},{"permKey":"comment_limit_cycle_end","permValue":"08:30:00","permStatus":""},{"permKey":"comment_limit_rule","permValue":1,"permStatus":""},{"permKey":"post_editor_image","permValue":true,"permStatus":""},{"permKey":"post_editor_video","permValue":true,"permStatus":""},{"permKey":"post_editor_audio","permValue":true,"permStatus":""},{"permKey":"post_editor_doc","permValue":true,"permStatus":""},{"permKey":"comment_editor_image","permValue":true,"permStatus":""},{"permKey":"comment_editor_video","permValue":false,"permStatus":""},{"permKey":"comment_editor_audio","permValue":false,"permStatus":""},{"permKey":"comment_editor_doc","permValue":false,"permStatus":""},{"permKey":"images_max_size","permValue":5,"permStatus":""},{"permKey":"videos_max_size","permValue":50,"permStatus":""},{"permKey":"videos_max_time","permValue":15,"permStatus":""},{"permKey":"audios_max_size","permValue":50,"permStatus":""},{"permKey":"audios_max_time","permValue":60,"permStatus":""},{"permKey":"docs_max_size","permValue":10,"permStatus":""},{"permKey":"download_file_count","permValue":999,"permStatus":""}]

//禁言或待审核角色
[{"permKey":"content_view","permValue":true,"permStatus":""},{"permKey":"dialog","permValue":false,"permStatus":""},{"permKey":"post_publish","permValue":false,"permStatus":""},{"permKey":"post_review","permValue":false,"permStatus":""},{"permKey":"post_email_verify","permValue":false,"permStatus":""},{"permKey":"post_phone_verify","permValue":false,"permStatus":""},{"permKey":"post_prove_verify","permValue":false,"permStatus":""},{"permKey":"post_limit_status","permValue":false,"permStatus":""},{"permKey":"post_limit_type","permValue":1,"permStatus":""},{"permKey":"post_limit_period_start","permValue":"2021-08-01 22:30:00","permStatus":""},{"permKey":"post_limit_period_end","permValue":"2021-08-02 08:00:00","permStatus":""},{"permKey":"post_limit_cycle_start","permValue":"23:00:00","permStatus":""},{"permKey":"post_limit_cycle_end","permValue":"08:30:00","permStatus":""},{"permKey":"post_limit_rule","permValue":1,"permStatus":""},{"permKey":"comment_publish","permValue":false,"permStatus":""},{"permKey":"comment_review","permValue":false,"permStatus":""},{"permKey":"comment_email_verify","permValue":false,"permStatus":""},{"permKey":"comment_phone_verify","permValue":false,"permStatus":""},{"permKey":"comment_prove_verify","permValue":false,"permStatus":""},{"permKey":"comment_limit_status","permValue":false,"permStatus":""},{"permKey":"comment_limit_type","permValue":1,"permStatus":""},{"permKey":"comment_limit_period_start","permValue":"2021-08-01 22:30:00","permStatus":""},{"permKey":"comment_limit_period_end","permValue":"2021-08-02 08:00:00","permStatus":""},{"permKey":"comment_limit_cycle_start","permValue":"23:00:00","permStatus":""},{"permKey":"comment_limit_cycle_end","permValue":"08:30:00","permStatus":""},{"permKey":"comment_limit_rule","permValue":1,"permStatus":""},{"permKey":"post_editor_image","permValue":false,"permStatus":""},{"permKey":"post_editor_video","permValue":false,"permStatus":""},{"permKey":"post_editor_audio","permValue":false,"permStatus":""},{"permKey":"post_editor_doc","permValue":false,"permStatus":""},{"permKey":"comment_editor_image","permValue":true,"permStatus":""},{"permKey":"comment_editor_video","permValue":false,"permStatus":""},{"permKey":"comment_editor_audio","permValue":false,"permStatus":""},{"permKey":"comment_editor_doc","permValue":false,"permStatus":""},{"permKey":"images_max_size","permValue":5,"permStatus":""},{"permKey":"videos_max_size","permValue":50,"permStatus":""},{"permKey":"videos_max_time","permValue":15,"permStatus":""},{"permKey":"audios_max_size","permValue":50,"permStatus":""},{"permKey":"audios_max_time","permValue":60,"permStatus":""},{"permKey":"docs_max_size","permValue":10,"permStatus":""},{"permKey":"download_file_count","permValue":0,"permStatus":""}]
1
2
3
4
5