oracle-update-2.0.7~2.1.0.sql 1.9 KB

12345678910111213141516171819202122232425
  1. -- ----------------------------
  2. -- 插入菜单数据
  3. -- ----------------------------
  4. INSERT INTO "BLADEX"."BLADE_MENU"("ID", "PARENT_ID", "CODE", "NAME", "ALIAS", "PATH", "SOURCE", "SORT", "CATEGORY", "ACTION", "IS_OPEN", "REMARK", "IS_DELETED")
  5. VALUES ('1164733121140551682', '1123598815738675217', 'form', '表单设计', 'form', 'https://form.avuejs.com/', 'iconfont iconicon_compile', 3, 1, 0, 2, '', 0);
  6. INSERT INTO "BLADEX"."BLADE_MENU"("ID", "PARENT_ID", "CODE", "NAME", "ALIAS", "PATH", "SOURCE", "SORT", "CATEGORY", "ACTION", "IS_OPEN", "REMARK", "IS_DELETED")
  7. VALUES ('1164733349637844993', '1123598815738675217', 'crud', '表格设计', 'crud', 'https://crud.avuejs.com/', 'iconfont iconicon_work', 4, 1, 0, 2, '', 0);
  8. -- ----------------------------
  9. -- 插入数据源角色权限数据
  10. -- ----------------------------
  11. INSERT INTO "BLADEX"."BLADE_ROLE_MENU"(ID,MENU_ID,ROLE_ID)
  12. VALUES ('1161272593873322996', '1164733121140551682', '1123598816738675201');
  13. INSERT INTO "BLADEX"."BLADE_ROLE_MENU"(ID,MENU_ID,ROLE_ID)
  14. VALUES ('1161272593873322997', '1164733349637844993', '1123598816738675201');
  15. -- ----------------------------
  16. -- 重新配置oss字典
  17. -- ----------------------------
  18. DELETE FROM "BLADEX"."BLADE_DICT" WHERE CODE = 'oss';
  19. INSERT INTO "BLADEX"."BLADE_DICT"(ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_DELETED) VALUES (1123598814738676224, 0, 'oss', -1, '对象存储类型', 6, NULL, 0);
  20. INSERT INTO "BLADEX"."BLADE_DICT"(ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_DELETED) VALUES (1123598814738676225, 1123598814738676224, 'oss', 1, 'minio', 1, NULL, 0);
  21. INSERT INTO "BLADEX"."BLADE_DICT"(ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_DELETED) VALUES (1123598814738676226, 1123598814738676224, 'oss', 2, 'qiniu', 2, NULL, 0);
  22. INSERT INTO "BLADEX"."BLADE_DICT"(ID, PARENT_ID, CODE, DICT_KEY, DICT_VALUE, SORT, REMARK, IS_DELETED) VALUES (1123598814738676227, 1123598814738676224, 'oss', 3, 'ali', 3, NULL, 0);