1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| --minlo 新建一个bucketName名为template的桶
|
| --将基础模板直接上传到template的桶中
|
| --导入模块字典的脚本
| INSERT INTO sys_dict(type,description,remarks,system,tenant_id,active) VALUES ('template_upload','导入模板下载','导入模板下载',0,1,TRUE);
|
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'设备.xlsx','equipment','template_upload','设备模板',7,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'部门.xlsx','division','template_upload','部门模板',0,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'仓库.xlsx','warehouse','template_upload','仓库模板',1,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'工序.xlsx','operation','template_upload','工序模板',2,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'工序参数.xlsx','param','template_upload','参数的模板',3,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'工作站.xlsx','workstation','template_upload','工作站模板',4,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'库位.xlsx','location','template_upload','库位模板',5,1,TRUE);
| INSERT INTO sys_dict_item(dict_id,value,label,type,description,sort,tenant_id,active) VALUES (currval('sys_dict_id_seq'),'零件.xlsx','part','template_upload','零件模板',6,1,TRUE);
|
|
