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
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
| -- ============================================================
| -- 数据库变更脚本（全部变更统一记录在此文件）
| -- 按日期倒序排列，每次变更用日期注释块分隔
| -- ============================================================
|
|
| -- ============================================================
| -- 2026/04/15 订单表添加核销码字段
| -- ============================================================
|
| ALTER TABLE `orders` ADD COLUMN `MEMBER_VERIFY_CODE` VARCHAR(32) DEFAULT NULL COMMENT '会员订单核销码' AFTER `OVERDUE_STATUS`;
| ALTER TABLE `orders` ADD COLUMN `DRIVER_VERIFY_CODE` VARCHAR(32) DEFAULT NULL COMMENT '司机订单核销码' AFTER `MEMBER_VERIFY_CODE`;
|
|
| -- ============================================================
| -- 2026/04/15 订单表添加是否逾期字段
| -- ============================================================
|
| ALTER TABLE `orders` ADD COLUMN `OVERDUE_STATUS` TINYINT DEFAULT 0 COMMENT '是否逾期: 0=否 1=是 2=已支付' AFTER `OVERDUE_DAYS`;
|
|
| -- ============================================================
| -- 2026/04/15 订单物品明细表添加就地存取单价字段
| -- ============================================================
|
| ALTER TABLE `orders_detail` ADD COLUMN `LOCALLY_PRICE` BIGINT DEFAULT NULL COMMENT '就地存取单价(分/天)' AFTER `EXTRA_PRICE`;
|
|
| -- ============================================================
| -- 2026/04/14 门店营业类型字段
| -- ============================================================
|
| ALTER TABLE `shop_info` ADD COLUMN `BUSINESS_TYPE` INT DEFAULT 0 COMMENT '门店营业类型：0=非全天；1=全天' AFTER `SHOP_HOURS`;
|
|
| -- ============================================================
| -- 2026/04/14 门店信息维护字段
| -- ============================================================
|
| ALTER TABLE `shop_info` ADD COLUMN `COVER_IMG` VARCHAR(500) DEFAULT NULL COMMENT '门店头像' AFTER `PAY_MEMBER_OPEN_ID`;
| ALTER TABLE `shop_info` ADD COLUMN `CONTENT` TEXT DEFAULT NULL COMMENT '门店介绍' AFTER `COVER_IMG`;
| ALTER TABLE `shop_info` ADD COLUMN `DEPOSIT_TYPES` VARCHAR(500) DEFAULT NULL COMMENT '寄存类型（逗号分隔的category主键）' AFTER `CONTENT`;
| ALTER TABLE `shop_info` ADD COLUMN `FEE_STANDARD` VARCHAR(500) DEFAULT NULL COMMENT '收费标准' AFTER `DEPOSIT_TYPES`;
| ALTER TABLE `shop_info` ADD COLUMN `DELIVERY_AREA` DECIMAL(10,2) DEFAULT NULL COMMENT '配送范围(km)' AFTER `FEE_STANDARD`;
| ALTER TABLE `shop_info` ADD COLUMN `SHOP_HOURS` VARCHAR(100) DEFAULT NULL COMMENT '营业时间' AFTER `DELIVERY_AREA`;
|
|
| -- ============================================================
| -- 2026/04/13 提现申请用户类型字段
| -- ============================================================
|
| ALTER TABLE `withdrawal_orders` ADD COLUMN `MEMBER_TYPE` INT DEFAULT NULL COMMENT '用户类型：1=司机；2=店铺' AFTER `MEMBER_ID`;
|
|
| -- ============================================================
| -- 2026/04/13 提现申请审批字段 + 审批权限
| -- ============================================================
|
| ALTER TABLE `withdrawal_orders` ADD COLUMN `USER_ID` INT DEFAULT NULL COMMENT '审批操作人（关联system_user）' AFTER `ALI_ACCOUNT`;
| ALTER TABLE `withdrawal_orders` ADD COLUMN `APPROVE_TIME` DATETIME DEFAULT NULL COMMENT '审批时间' AFTER `USER_ID`;
| ALTER TABLE `withdrawal_orders` ADD COLUMN `APPROVE_REMARK` VARCHAR(500) DEFAULT NULL COMMENT '审批备注' AFTER `APPROVE_TIME`;
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:withdrawalOrders:create', '新建提现申请', '提现申请', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:withdrawalOrders:delete', '删除提现申请', '提现申请', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:withdrawalOrders:update', '修改提现申请', '提现申请', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:withdrawalOrders:query', '查询提现申请', '提现申请', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:withdrawalOrders:exportExcel', '导出提现申请(Excel)', '提现申请', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
| -- ============================================================
| -- 2026/04/13 订单退款记录权限
| -- ============================================================
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:ordersRefund:create', '新建订单退款记录', '订单退款记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:ordersRefund:delete', '删除订单退款记录', '订单退款记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:ordersRefund:update', '修改订单退款记录', '订单退款记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:ordersRefund:query', '查询订单退款记录', '订单退款记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
| -- ============================================================
| -- 2026/04/13 会员列表与详情权限
| -- ============================================================
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:list', '查询会员列表', '会员管理', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:listExport', '导出会员列表(Excel)', '会员管理', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
| -- ============================================================
| -- 2026/04/13 订单新增取消备注字段 + 订单文件路径字典
| -- ============================================================
|
| ALTER TABLE `orders` ADD COLUMN `CANCEL_REMARK` VARCHAR(500) DEFAULT NULL COMMENT '取消备注' AFTER `CANCEL_TIME`;
|
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 100, '/orders/', 'ORDERS_FILES', '订单文件路径', 22, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `system_dict_data` WHERE `DICT_ID` = 100 AND `LABEL` = 'ORDERS_FILES' AND `DELETED` = 0);
|
|
| -- ============================================================
| -- 2026/04/13 协议配置字典数据（隐私协议、用户协议新增，关于我们已存在）
| -- ============================================================
|
| -- 父级字典ID 100 (SYSTEM) 已存在，无需新建
|
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 100, '', 'PRIVACY_AGREEMENT', '隐私协议', 20, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `system_dict_data` WHERE `DICT_ID` = 100 AND `LABEL` = 'PRIVACY_AGREEMENT' AND `DELETED` = 0);
|
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 100, '', 'USER_AGREEMENT', '用户协议', 21, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `system_dict_data` WHERE `DICT_ID` = 100 AND `LABEL` = 'USER_AGREEMENT' AND `DELETED` = 0);
|
| -- 协议配置权限
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:agreementConfig:update', '修改协议配置', '协议配置', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
| -- ============================================================
| -- 2026/04/13 运营配置字典数据
| -- ============================================================
|
| -- 父级字典：运营配置（如果ID 105已存在则跳过）
| INSERT INTO `system_dict`(`ID`, `CODE`, `NAME`, `REMARK`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 105, 'OPERATION_CONFIG', '运营配置', '运营参数配置项', 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `system_dict` WHERE `ID` = 105);
|
| -- 字典子项
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '3', 'DRIVER_DAILY_CANCEL_LIMIT', '司机每日取消次数', 0, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '0.8', 'UNPICKED_DISCOUNT', '未取件折扣', 1, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '7', 'SETTLEMENT_DATE', '订单结算日期(天)', 2, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '1.5', 'URGENT_COEFFICIENT', '加急系数', 3, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '30', 'AUTO_CANCEL_TIME', '超时未支付自动取消时间(分钟)', 4, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '0.01', 'INSURANCE_RATE', '保费比率', 5, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '5', 'ORDER_ACCEPT_LIMIT', '接单数量', 6, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `system_dict_data`(`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| VALUES (105, '7', 'AUTO_CONFIRM_RECEIPT', '自动确认收货(天)', 7, 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 运营配置权限
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:operationConfig:query', '查询运营配置', '运营配置', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:operationConfig:update', '修改运营配置', '运营配置', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
| -- ============================================================
| -- 2026/04/13 支付宝提现账户字段
| -- ============================================================
|
| ALTER TABLE `withdrawal_orders` ADD COLUMN `ALI_ACCOUNT` VARCHAR(64) DEFAULT NULL COMMENT '支付宝提现账户' AFTER `OUT_BILL_NO`;
| ALTER TABLE `shop_info` ADD COLUMN `ALI_ACCOUNT` VARCHAR(64) DEFAULT NULL COMMENT '支付宝提现账户' AFTER `DELIVERY_AREA`;
|
|
| -- ============================================================
| -- 2026/04/13 轮播图业务调整
| -- ============================================================
|
| ALTER TABLE `banner` MODIFY COLUMN `TITLE` VARCHAR(255) DEFAULT NULL COMMENT '标题';
|
| INSERT INTO `SYSTEM_DICT_DATA`(`TYPE`, `CODE`, `NAME`, `VALUE`, `REMARK`, `CREATE_TIME`, `DELETED`)
| VALUES ('SYSTEM', 'BANNER_FILES', '轮播图文件路径', '/banner/', '轮播图图片存储子路径', CURRENT_TIMESTAMP, 0);
|
|
| -- ============================================================
| -- 2026/04/10 提现申请初始权限
| -- ============================================================
|
| -- 提现申请相关权限暂未录入，后续补充
|
|
| -- ============================================================
| -- 2026/04/08 各模块初始权限
| -- ============================================================
|
| -- 轮播图
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:banner:create', '新建轮播图', '轮播图', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:banner:delete', '删除轮播图', '轮播图', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:banner:update', '修改轮播图', '轮播图', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:banner:query', '查询轮播图', '轮播图', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:banner:exportExcel', '导出轮播图(Excel)', '轮播图', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 分类信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:category:create', '新建分类信息表', '分类信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:category:delete', '删除分类信息表', '分类信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:category:update', '修改分类信息表', '分类信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:category:query', '查询分类信息表', '分类信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:category:exportExcel', '导出分类信息表(Excel)', '分类信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 组织信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:company:create', '新建组织信息表', '组织信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:company:delete', '删除组织信息表', '组织信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:company:update', '修改组织信息表', '组织信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:company:query', '查询组织信息表', '组织信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:company:exportExcel', '导出组织信息表(Excel)', '组织信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 责任人信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:managers:create', '新建责任人信息表', '责任人信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:managers:delete', '删除责任人信息表', '责任人信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:managers:update', '修改责任人信息表', '责任人信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:managers:query', '查询责任人信息表', '责任人信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:managers:exportExcel', '导出责任人信息表(Excel)', '责任人信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 人员信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:create', '新建人员信息表', '人员信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:delete', '删除人员信息表', '人员信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:update', '修改人员信息表', '人员信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:query', '查询人员信息表', '人员信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:member:exportExcel', '导出人员信息表(Excel)', '人员信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 附件上传信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:multifile:create', '新建附件上传信息表', '附件上传信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:multifile:delete', '删除附件上传信息表', '附件上传信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:multifile:update', '修改附件上传信息表', '附件上传信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:multifile:query', '查询附件上传信息表', '附件上传信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:multifile:exportExcel', '导出附件上传信息表(Excel)', '附件上传信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 系统消息信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:notices:create', '新建系统消息信息表', '系统消息信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:notices:delete', '删除系统消息信息表', '系统消息信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:notices:update', '修改系统消息信息表', '系统消息信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:notices:query', '查询系统消息信息表', '系统消息信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:notices:exportExcel', '导出系统消息信息表(Excel)', '系统消息信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 工单信息表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorder:create', '新建工单信息表', '工单信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorder:delete', '删除工单信息表', '工单信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorder:update', '修改工单信息表', '工单信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorder:query', '查询工单信息表', '工单信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorder:exportExcel', '导出工单信息表(Excel)', '工单信息表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
| -- 工单操作历史表
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorderlog:create', '新建工单操作历史表', '工单操作历史表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorderlog:delete', '删除工单操作历史表', '工单操作历史表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorderlog:update', '修改工单操作历史表', '工单操作历史表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorderlog:query', '查询工单操作历史表', '工单操作历史表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:workorderlog:exportExcel', '导出工单操作历史表(Excel)', '工单操作历史表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
|
|
