홈 탐색 도움말
가입하기 로그인
java
/
cdss-core
2
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: b698889242
브랜치 태그
cdss-core
/
doc
/
004.20210225知识库迁移到Mysql
/
sys-user_init.sql

sys-user_init.sql 9.9 KB
히스토리 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 
  1. use `sys-user`;
    2. 

  2. 

  3. UPDATE `sys-user`.`sys_menu` SET `is_deleted` = 'Y' WHERE `id` = '82';
    4. 

  4. UPDATE `sys-user`.`sys_menu` SET `is_deleted` = 'Y' WHERE `id` = '89';
    5. 

  5. 

  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','知识库基础维护','-1','LT-ZSKJCWH','120','朗通-知识库基础维护');
    7. 

  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-JCSYWH','1','朗通-知识库基础维护-基础术语维护');
    8. 

  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','基础术语类型维护','93','LT-ZSKJCWH-JCSYLXWH','2','朗通-知识库基础维护-基础术语类型维护');
    9. 

  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','基础关系类型维护','93','LT-ZSKJCWH-JCGXLXWH','3','朗通-知识库基础维护-基础关系类型维护');
    10. 

  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','知识库扩展维护','-1','LT-ZSKKZWH','121','朗通-知识库扩展维护-知识库扩展维护');
    11. 

  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-SXJGWH','1','朗通-知识库扩展维护-树形结构维护');
    12. 

  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-JBXGWH','2','朗通-知识库扩展维护-疾病相关维护');
    13. 

  13. 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','朗通-知识库扩展维护-静态信息维护');
    14. 

  14. 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','朗通-知识库扩展维护-规则维护');
    15. 

  15. 

  16. 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);
    17. 

  17. 

  18. 

  19. 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
    20. 

  20.   WHERE a.name IN (
    21. 

  21.       "知识库基础维护",
    22. 

  22.       "基础术语维护",
    23. 

  23.       "基础术语类型维护",
    24. 

  24.       "基础关系类型维护",
    25. 

  25.       "知识库扩展维护",
    26. 

  26.       "树形结构维护",
    27. 

  27.       "疾病相关维护",
    28. 

  28.       "静态信息维护",
    29. 

  29.       "规则维护") AND a.is_deleted = "N"  AND a.creator = - 1  AND c.name = "CDSS知识库";
    30. 

  30. 

  31. 

  32. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 

  36. 

  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', 'cdsszsk', '{bcrypt}$2a$10$TPhFrVA7nEF86WnVNnnUB.FXeQflUktxgNDtnE5IFuIKuCwdrjz2.', 'CDSS知识库维护', '13700000008', '医学人员', '医学人员', 'sadfsd@163.com', '0', '1970-01-01 12:00:00', '1', '');
    38. 

  38. 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', '');
    39. 

  39. 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', '');
    40. 

  40. 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', '');
    41. 

  41. 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', '');
    42. 

  42. 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', '');
    43. 

  43. 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', '');
    44. 

  44. 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', '');
    45. 

  45. 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', '');
    46. 

  46. 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', '');
    47. 

  47. 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', '');
    48. 

  48. 

  49. 

  50. INSERT INTO sys_user_role (user_id,role_id)
    51. 

  51. SELECT
    52. 

  52.     a.id,
    53. 

  53.    c.id
    54. 

  54.   FROM
    55. 

  55.     sys_user a
    56. 

  56.     INNER JOIN sys_role c
    57. 

  57.   WHERE a.username IN (
    58. 

  58.       "cdsszsk",
    59. 

  59.       "cdsszsk1",
    60. 

  60.       "cdsszsk2",
    61. 

  61.       "cdsszsk3",
    62. 

  62.       "cdsszsk4",
    63. 

  63.       "cdsszsk5",
    64. 

  64.       "cdsszsk6",
    65. 

  65.       "cdsszsk7",
    66. 

  66.       "cdsszsk8",
    67. 

  67.       "cdsszsk9",
    68. 

  68.       "cdsszsk10"
    69. 

  69.     )
    70. 

  70.     AND a.is_deleted = "N"
    71. 

  71.     AND a.creator = - 1
    72. 

  72.     AND c.name = "CDSS知识库";
    73.