首页 发现 帮助
注册 登录
bowintek
/
GHSCPartyBuild
17
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: 70dd17931a
分支列表 标签列表
GHSCPartyBuild
/
lib
/
数据更新脚本.txt

数据更新脚本.txt 28 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229 
  1. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    2. 

  2. VALUES ('9912122b-15d2-4e93-ac5e-06e4b091ee65', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, null, 20, '大数据分析', '大数据分析', null, 'trending_up', null, 1, 0, null);
    3. 

  3. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    4. 

  4. VALUES ('9cbf8369-9b94-4baf-b75d-3e3bf045a4d1', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 10, 'home.bigdataList', '大数据维护', null, null, null, 1, 1, null);
    5. 

  5. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    6. 

  6. VALUES ('432db382-6a35-4788-b6d8-2b0e85785f49', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 2, '../main/index-dsj.html#!/showDjdsj', '党建概况', null, null, null, 1, 1, 1);
    7. 

  7. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    8. 

  8. VALUES ('67ddad23-18a3-4336-b3ca-f148ff220589', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 4, '../main/index-dsj.html#!/showDjdsj_dwgzz', '党务工作者', null, null, null, 1, 1, 1);
    9. 

  9. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    10. 

  10. VALUES ('3c57eec8-fcb7-4cbd-a910-92633f2d8874', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 3, '../main/index-dsj.html#!/teams', '党员队伍', null, null, null, 1, 1, 1);
    11. 

  11. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    12. 

  12. VALUES ('e1c6f537-cc54-4f39-939a-afb65ae7086b', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 5, '../main/index-dsj.html#!/showDjdsj_dwdt', '党务动态', null, null, null, 1, 1, 1);
    13. 

  13. 

  14. --7.05
    15. 

  15. update cf_menu set MENUNO='home.reportDataScore',MENUNAME='述职评议评分' where MENUID='2237844c-2194-430f-bef7-ea68469c9f33';
    16. 

  16. 

  17. --7.06
    18. 

  18. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    19. 

  19. VALUES ('4c6f7f03-453e-4fd1-af0e-61f702ee649b', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1137844c-2194-430f-bef7-ea68469c9f33', null, 1, 'reportData.generate', '生成述职名单', null, null, '', 0, 1, null);
    20. 

  20. INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
    21. 

  21. VALUES ('56f0b4b0-467a-4b15-b394-e5f86542921c', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1137844c-2194-430f-bef7-ea68469c9f33', null, 2, 'reportData.downZip', '打包下载', null, null, '', 0, 1, null);
    22. 

  22. 

  23. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`)
    24. 

  24. VALUES ('23f5e615-b16a-re1c-829d-cc85c2a00001', 1, '优秀', 'reportResult', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
    25. 

  25. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`)
    26. 

  26. VALUES ('23f5e615-b16a-re2c-829d-dd85c2a00002', 2, '好', 'reportResult', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
    27. 

  27. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`)
    28. 

  28. VALUES ('23f5e615-b16a-re3c-829d-dd85c2a00002', 3, '一般', 'reportResult', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
    29. 

  29. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`)
    30. 

  30. VALUES ('23f5e615-b16a-re4c-829d-dd85c2a00002', 4, '差', 'reportResult', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
    31. 

  31. 

  32. 

  33. 

  34. -- 2024.7.11 专题建设
    35. 

  35. -- ----------------------------
    36. 

  36. -- Table structure for zz_mzpyxx
    37. 

  37. -- ----------------------------
    38. 

  38. DROP TABLE IF EXISTS `pf_dnjzjy`;
    39. 

  39. CREATE TABLE `pf_dnjzjy`  (
    40. 

  40.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
    41. 

  41.   `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '面向对象（选择党组织）',
    42. 

  42.   `jykssj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育开始时间',
    43. 

  43.   `jyjssj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育结束时间',
    44. 

  44.   `zt` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主题',
    45. 

  45.   `zygzbz` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主要工作步骤',
    46. 

  46.   `qddcx` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '取得的成效',
    47. 

  47.   `create_time` datetime NULL  DEFAULT NULL COMMENT '创建时间',
    48. 

  48.   `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    49. 

  49.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    50. 

  50.   `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
    51. 

  51.   PRIMARY KEY (`id`) USING BTREE
    52. 

  52. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党内集中教育';
    53. 

  53. 

  54. SET FOREIGN_KEY_CHECKS = 1;
    55. 

  55. 

  56. -- 党建“双创”工作
    57. 

  57. DROP TABLE IF EXISTS `pf_djscgz`;
    58. 

  58. CREATE TABLE `pf_djscgz`  (
    59. 

  59.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
    60. 

  60.   `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '党组织（工作室）名称',
    61. 

  61.   `pxqdsj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评选启动时间',
    62. 

  62.   `pxjgqdsj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评选结果确定时间',
    63. 

  63.   `pxjb` int NULL DEFAULT NULL COMMENT '评选级别 pxjbType',
    64. 

  64.   `pxlb` int NULL DEFAULT NULL COMMENT '评选类别 pxlbType',
    65. 

  65.   `zygzbz` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主要工作步骤',
    66. 

  66.   `create_time` datetime NULL  DEFAULT NULL COMMENT '创建时间',
    67. 

  67.   `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    68. 

  68.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    69. 

  69.   `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
    70. 

  70.   PRIMARY KEY (`id`) USING BTREE
    71. 

  71. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党建“双创”工作';
    72. 

  72. 

  73. SET FOREIGN_KEY_CHECKS = 1;
    74. 

  74. 

  75. 

  76. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0001-0000-bdb74a278a72', 1, '国家级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N');
    77. 

  77. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0002-0000-bdb74a278a72', 2, '省级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N');
    78. 

  78. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0003-0000-bdb74a278a72', 3, '市级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N');
    79. 

  79. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0004-0000-bdb74a278a72', 4, '校级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N');
    80. 

  80. 

  81. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0011-0000-bdb74a278a72', 1, '示范高校', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N');
    82. 

  82. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0022-0000-bdb74a278a72', 2, '标杆院系', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N');
    83. 

  83. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0033-0000-bdb74a278a72', 3, '样板支部', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N');
    84. 

  84. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0044-0000-bdb74a278a72', 4, '“双带头人”教师党支部书记工作室', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N');
    85. 

  85. 

  86. 

  87. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-43db-8946-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 6, '专题建设', '专题建设', '', '', '', 1, 0, NULL);
    88. 

  88. 

  89. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-0000-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 2, 'home.pf_dnjzjyAdd', '新增党内集中教育', '', '', '', 0, 0, 1);
    90. 

  90. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-0001-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 3, 'home.pf_dnjzjyDetail', '查看党内集中教育详情', '', '', '', 0, 0, 1);
    91. 

  91. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-435c-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 1, 'home.pf_dnjzjyEdit', '编辑党内集中教育', '', '', '', 0, 0, 1);
    92. 

  92. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-28bf-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-43db-8946-b24618f90175', NULL, 1, 'home.pf_dnjzjyList', '党内集中教育', '', '', '', 1, 0, 0);
    93. 

  93. 

  94. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0003-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 2, 'home.pf_djscgzAdd', '新增党建“双创”工作', '', '', '', 0, 0, 1);
    95. 

  95. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0002-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 3, 'home.pf_djscgzDetail', '查看党建“双创”工作详情', '', '', '', 0, 0, 1);
    96. 

  96. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0001-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 1, 'home.pf_djscgzEdit', '编辑党建“双创”工作', '', '', '', 0, 0, 1);
    97. 

  97. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0000-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-43db-8946-b24618f90175', NULL, 2, 'home.pf_djscgzList', '党建“双创”工作', '', '', '', 1, 0, 0);
    98. 

  98. 

  99. 

  100. -- 2024.7.11 党风廉政建设
    101. 

  101. -- 纪律教育学习月活动
    102. 

  102. DROP TABLE IF EXISTS `pf_jljyxxyhd`;
    103. 

  103. CREATE TABLE `pf_jljyxxyhd`  (
    104. 

  104.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
    105. 

  105.   `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属党组织',
    106. 

  106.   `hdmc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '活动名称',
    107. 

  107.   `rq` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '日期',
    108. 

  108.   `create_time` datetime NULL  DEFAULT NULL COMMENT '创建时间',
    109. 

  109.   `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    110. 

  110.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    111. 

  111.   `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
    112. 

  112.   PRIMARY KEY (`id`) USING BTREE
    113. 

  113. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'纪律教育学习月活动';
    114. 

  114. SET FOREIGN_KEY_CHECKS = 1;
    115. 

  115. 

  116. -- 纪律教育学习月活动-统计明细表
    117. 

  117. DROP TABLE IF EXISTS `pf_jljyxxyhd_fb`;
    118. 

  118. CREATE TABLE `pf_jljyxxyhd_fb`  (
    119. 

  119.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
    120. 

  120.   `jljyxxyhd_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '纪律教育学习月活动id',
    121. 

  121.   `zdgz` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '重点工作',
    122. 

  122.   `mc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
    123. 

  123.   `sj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时间',
    124. 

  124.   `jydx` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育对象',
    125. 

  125.   `cjrs` int NULL DEFAULT NULL COMMENT '参加人数',
    126. 

  126.   `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    127. 

  127.   `create_time` datetime NULL  DEFAULT NULL COMMENT '创建时间',
    128. 

  128.   `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    129. 

  129.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    130. 

  130.   `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
    131. 

  131.   PRIMARY KEY (`id`) USING BTREE
    132. 

  132. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'纪律教育学习月活动-统计明细表';
    133. 

  133. SET FOREIGN_KEY_CHECKS = 1;
    134. 

  134. 

  135. 

  136. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-8946-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 7, '党风廉政建设', '党风廉政建设', '', '', '', 1, 0, NULL);
    137. 

  137. 

  138. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0003-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 3, 'home.pf_jljyxxyhdDetail', '查看纪律教育学习月活动详情', '', '', '', 0, 0, 1);
    139. 

  139. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0002-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 2, 'home.pf_jljyxxyhdAdd', '新增纪律教育学习月活动', '', '', '', 0, 0, 1);
    140. 

  140. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0001-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 1, 'home.pf_jljyxxyhdEdit', '编辑纪律教育学习月活动', '', '', '', 0, 0, 1);
    141. 

  141. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0000-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-8946-b24618f90175', NULL, 1, 'home.pf_jljyxxyhdList', '纪律教育学习月活动', '', '', '', 1, 0, 0);
    142. 

  142. 

  143. 

  144. 

  145.  -- 2024.7.12 听取党风廉政管理
    146. 

  146. alter table pf_partylifemeeting add meetingType int COMMENT '会议类型 meetingType';
    147. 

  147. 

  148. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0001-9999-bdb74a278a72', 1, '听取党风廉政会议', 'meetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '会议类型', '2019-09-26 15:13:15', 'M', 'N');
    149. 

  149. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0002-9999-bdb74a278a72', 2, '其他党风廉政', 'meetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '会议类型', '2019-09-26 15:13:15', 'M', 'N');
    150. 

  150. 

  151. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-829d-7085c2a00007', 7, '听取党风廉政管理', 'PartyLifeMeetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
    152. 

  152. 

  153. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0003-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 3, 'home.pf_tqdflzhyMeetingDetail', '查看听取党风廉政管理详情', '', '', '', 0, 0, 1);
    154. 

  154. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0002-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 2, 'home.pf_tqdflzhyMeetingAdd', '新增听取党风廉政管理', '', '', '', 0, 0, 1);
    155. 

  155. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0001-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 1, 'home.pf_tqdflzhyMeetingEdit', '编辑听取党风廉政管理', '', '', '', 0, 0, 1);
    156. 

  156. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0000-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-8946-b24618f90175', NULL, 1, 'home.pf_tqdflzhyMeetingList', '听取党风廉政管理', '', '', '', 1, 0, 0);
    157. 

  157. 

  158. 

  159. 

  160. -- 2024.7.15 党员学习教育-党组织风采
    161. 

  161. DROP TABLE IF EXISTS `pub_dzzfc`;
    162. 

  162. CREATE TABLE `pub_dzzfc`  (
    163. 

  163.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
    164. 

  164.   `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所在组织',
    165. 

  165.   `ztmc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主题名称',
    166. 

  166.   `fc_type` int NULL DEFAULT NULL COMMENT '类型 fcType',
    167. 

  167.   `jj` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '简介',
    168. 

  168.   `nr` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内容',
    169. 

  169.   `sj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时间',
    170. 

  170.   `lj` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '链接',
    171. 

  171.   `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    172. 

  172.   `create_time` datetime NULL  DEFAULT NULL COMMENT '创建时间',
    173. 

  173.   `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    174. 

  174.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    175. 

  175.   `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
    176. 

  176.   PRIMARY KEY (`id`) USING BTREE
    177. 

  177. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党组织风采';
    178. 

  178. SET FOREIGN_KEY_CHECKS = 1;
    179. 

  179. 

  180. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1b7e571e-0000-4475-9e24-98636ba0bd76', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '70958848-d81c-4679-9d89-11b5a5998060', NULL, 4, 'home.pub_dzzfcList', '党组织风采', '', '', '', 1, 1, NULL);
    181. 

  181. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('15c3ea7a-0000-4914-a17d-c985164e9428', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 1, 'pub_dzzfcList.btnAdd', '新增', NULL, NULL, NULL, 0, 1, NULL);
    182. 

  182. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('cb3e03df-0000-4e66-b8d8-93f707dbdaa1', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 2, 'pub_dzzfcList.btnUpdate', '编辑', NULL, NULL, NULL, 0, 1, NULL);
    183. 

  183. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('2067919a-0000-4a95-ba14-b84bf6100ced', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 3, 'pub_dzzfcList.btnDelete', '删除', NULL, NULL, NULL, 0, 1, NULL);
    184. 

  184. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('cd7e7a09-0000-4bbc-8246-36f7b0f62bcd', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 11, 'home.pub_dzzfcAdd', '新增党组织风采信息', NULL, NULL, NULL, 0, 0, NULL);
    185. 

  185. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('8638ba30-0000-4487-8c78-2e953857e6d4', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 12, 'home.pub_dzzfcEdit', '修改党组织风采信息', NULL, NULL, NULL, 0, 0, NULL);
    186. 

  186. INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f6ec1d5a-0000-47c0-bb7e-ce03f7eaf575', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 13, 'home.pub_dzzfcDetail', '查看党组织风采信息', NULL, NULL, NULL, 0, 0, NULL);
    187. 

  187. 

  188. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-0001-9999-bdb74a278a72', 1, '媒体报道', 'fcType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '风采类型', '2019-09-26 15:13:15', 'M', 'N');
    189. 

  189. INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-0002-9999-bdb74a278a72', 2, '其他', 'fcType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '风采类型', '2019-09-26 15:13:15', 'M', 'N');
    190. 

  190. 

  191. ---7.18
    192. 

  192. INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('3e8addee-6666-4c46-94d8-111138164863', 1, '待考试', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N');
    193. 

  193. INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-7777-4710-90fd-222e6bb77993', 2, '考试中', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N');
    194. 

  194. INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-8888-4710-90fd-222e6bb77993', 3, '已交卷', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N');
    195. 

  195. INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-9999-4710-90fd-333e6bb77993', 4, '缺考', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N');
    196. 

  196. INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-0000-4710-90fd-333e6bb77993', 5, '已公布成绩', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N');
    197. 

  197. 

  198. -- 2024.7.19
    199. 

  199. alter table cf_users add wxUserId varchar(50);
    200. 

  200. 

  201. -- 2024.7.22
    202. 

  202. delete from zzzd_jczzflnew;
    203. 

  203. 

  204. insert into zzzd_jczzflnew
    205. 

  205. values('100','党委',10,null,null,null);
    206. 

  206. insert into zzzd_jczzflnew
    207. 

  207. values('200','院系',20,null,null,null);
    208. 

  208. insert into zzzd_jczzflnew
    209. 

  209. values('300','综合',30,null,null,null);
    210. 

  210. insert into zzzd_jczzflnew
    211. 

  211. values('400','离退休',40,null,null,null);
    212. 

  212. insert into zzzd_jczzflnew
    213. 

  213. values('500','其他',50,null,null,null);
    214. 

  214. 

  215. update zz_zzqkxxfb set JCZZFL=null;
    216. 

  216. 

  217. update zz_zzqkxxfb fb
    218. 

  218. inner join zz_zzqkxx p on  p.dzzdm = fb.dzzdm
    219. 

  219. set fb.JCZZFL='100' where p.dzzmc like '%党委%';
    220. 

  220. update zz_zzqkxxfb fb
    221. 

  221. inner join zz_zzqkxx p on  p.dzzdm = fb.dzzdm
    222. 

  222. set fb.JCZZFL='300' where p.dzzmc like '%综合%';
    223. 

  223. update zz_zzqkxxfb fb
    224. 

  224. inner join zz_zzqkxx p on  p.dzzdm = fb.dzzdm
    225. 

  225. set fb.JCZZFL='400' where p.dzzmc like '%离退休%';
    226. 

  226. update zz_zzqkxxfb fb
    227. 

  227. inner join zz_zzqkxx p on  p.dzzdm = fb.dzzdm
    228. 

  228. set fb.JCZZFL='200' where fb.JCZZFL is null;
    229. 

  229.