sys-user_init.sql 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. use `sys-user`;
  2. UPDATE `sys-user`.`sys_menu` SET `is_deleted` = 'Y' WHERE `id` = '82';
  3. UPDATE `sys-user`.`sys_menu` SET `is_deleted` = 'Y' WHERE `id` = '89';
  4. INSERT INTO `sys_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','知识库基础维护','-1','LT-ZSKJCWH','120','朗通-知识库基础维护');
  5. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','基础术语维护','93','LT-ZSKJCWH-JCSYWH','1','朗通-知识库基础维护-基础术语维护');
  6. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','基础术语类型维护','93','LT-ZSKJCWH-JCSYLXWH','2','朗通-知识库基础维护-基础术语类型维护');
  7. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','基础关系类型维护','93','LT-ZSKJCWH-JCGXLXWH','3','朗通-知识库基础维护-基础关系类型维护');
  8. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','知识库扩展维护','-1','LT-ZSKKZWH','121','朗通-知识库扩展维护-知识库扩展维护');
  9. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','树形结构维护','97','LT-ZSKKZWH-SXJGWH','1','朗通-知识库扩展维护-树形结构维护');
  10. INSERT INTO `sys_menu` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','疾病相关维护','97','LT-ZSKKZWH-JBXGWH','2','朗通-知识库扩展维护-疾病相关维护');
  11. INSERT INTO `sys_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','静态信息维护','97','LT-ZSKKZWH-JTXXWH','3','朗通-知识库扩展维护-静态信息维护');
  12. INSERT INTO `sys_menu` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `parent_id`, `code`, `order_no`, `remark`) VALUES('N','1970-01-01 12:00:00','1970-01-01 12:00:00','-1','0','规则维护','97','LT-ZSKKZWH-GZWH','4','朗通-知识库扩展维护-规则维护');
  13. INSERT INTO `sys-user`.`sys_role` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `roleLevel`, `descritpion`, `menuItems`, `remark`) VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'CDSS知识库', '0', '', '', NULL);
  14. INSERT INTO sys_role_menu (role_id, menu_id,remark) SELECT c.id, a.id,a.remark FROM sys_menu a INNER JOIN sys_role c
  15. WHERE a.name IN (
  16. "知识库基础维护",
  17. "基础术语维护",
  18. "基础术语类型维护",
  19. "基础关系类型维护",
  20. "知识库扩展维护",
  21. "树形结构维护",
  22. "疾病相关维护",
  23. "静态信息维护",
  24. "规则维护") AND a.is_deleted = "N" AND a.creator = - 1 AND c.name = "CDSS知识库";
  25. INSERT INTO `sys-user`.`sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '18', '48', NULL);
  26. INSERT INTO `sys-user`.`sys_role_permission` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `role_id`, `permission_id`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '18', '63', NULL);
  27. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  28. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk1', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护1', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  29. INSERT INTO `sys-user`.`sys_user` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk2', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护2', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  30. INSERT INTO `sys-user`.`sys_user` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk3', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护3', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  31. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk4', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护4', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  32. INSERT INTO `sys-user`.`sys_user` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk5', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护5', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  33. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk6', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护6', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  34. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk7', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护7', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  35. INSERT INTO `sys-user`.`sys_user` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk8', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护8', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  36. INSERT INTO `sys-user`.`sys_user` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk9', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护9', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  37. INSERT INTO `sys-user`.`sys_user` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `username`, `password`, `linkman`, `phone`, `position`, `dept`, `email`, `auth_status`, `passauth_time`, `type`, `remark`) VALUES ( 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '-1', '0', 'cdsszsk10', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护10', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
  38. INSERT INTO sys_user_role (user_id,role_id)
  39. SELECT
  40. a.id,
  41. c.id
  42. FROM
  43. sys_user a
  44. INNER JOIN sys_role c
  45. WHERE a.username IN (
  46. "cdsszsk",
  47. "cdsszsk1",
  48. "cdsszsk2",
  49. "cdsszsk3",
  50. "cdsszsk4",
  51. "cdsszsk5",
  52. "cdsszsk6",
  53. "cdsszsk7",
  54. "cdsszsk8",
  55. "cdsszsk9",
  56. "cdsszsk10"
  57. )
  58. AND a.is_deleted = "N"
  59. AND a.creator = - 1
  60. AND c.name = "CDSS知识库";