ZongYue / ChinaPortEnergy

8.1.1 to 8.2.sql 128 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 
/*
 change.sql 说明
 1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql  文件
 2.sql 语句验证正确后再提交
*/
-- jjx 2023-4-24 同步mysql脚本到4月24日
alter table BPM_DEFINITION  add DESIGN_PATTERN_ VARCHAR(20);
comment on column BPM_DEFINITION.DESIGN_PATTERN_ is '设计模式';

create table BPM_CHECK_RECORD(
    ID_             VARCHAR(64)   primary key  unique,
    TENANT_ID_      VARCHAR(64),
    CREATE_TIME_    DATE,
    UPDATE_TIME_    date,
    CREATE_BY_      VARCHAR(64),
    TASK_ID_        VARCHAR(64),
    INST_ID_        VARCHAR(64),
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64)
);
comment on table BPM_CHECK_RECORD is '任务阅读记录';
comment on column BPM_CHECK_RECORD.TENANT_ID_ is '租户ID';
comment on column BPM_CHECK_RECORD.CREATE_TIME_ is '创建时间';
comment on column BPM_CHECK_RECORD.UPDATE_TIME_ is '更新时间';
comment on column BPM_CHECK_RECORD.CREATE_BY_ is '创建人';
comment on column BPM_CHECK_RECORD.TASK_ID_ is '任务ID';
comment on column BPM_CHECK_RECORD.INST_ID_ is '实例ID';


UPDATE portal_sys_properties SET NAME = '待办列表字段显示配置', ALIAS = 'taskListFiledConf', GROUP_ = NULL,
                                   VALUE = 'MvLiL4mE1+YRNj4cfPOGzXCMA5F/amaoWCA2iUnRVhcK9aZEof2/M5Ii3zWaCcQBtNG6T6/bDsspNohzSqq8MBg+UkEo+A+fojqBP9nm9s/mxAH5v+HcvPi7H00ryd0W0eMInCQ2rplU+UgHvJNr0D8+1FkL/EyQPsOG5SazUTWOWI14OS+R1tHUvVzGk6jSxrZqAz5Pi5RTNDitHrypfbF9nas8LjVzqrnYGrRimXaSaPX7zmNtlm+NoKRpX0ckQDyjgSvwAgnLtSbyqiTS4AMBxjGgbzHEtD+UwDcyWFD/y99DaWyKe1CkC/kfZ4mr5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzDENJLO7IPN9bixemLAj38RGZf+/2+uFRZx/WKKiVUHYuBxrvZN/E9Qxxg0JMpXPC4srBSSngEFv72KDwc1t7lpQ8+nOduRG5dkZcl9Do+qRj7JH6CouiXEyXZybr7hItFKZiClQgfDGd5wldTxTZ0apGjFB8lNecOIvY+DelsMAKG5+8VqplSVF3S6zJ6+kxqIt4OcPTIm+MPUgIFeLbm9XJ1Kn0tdEk5PhsiWdYBVrrhFafpPzw/AXsQAYZgh7T1TCnYGUidLOis1G8khS4T7QDyjgSvwAgnLtSbyqiTS4HtJ/Yl9yGzl/94R0THof8UO6B1Ej+GnOnQEFRi2izAf5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzAa38uRHjrujYZ4pZX1yWAEpGjFB8lNecOIvY+DelsMANq/cufeuL275D7sZygkW0WQ57F5AtPCv6Wki5lAM0CBL25Enrb6+rlNuY32fRM0z7OMt4w6vXJHgjkO4Txe4/srk4QuiRDQvyq9K+wGQLQNuVl7HPlrJDfOPnb2xbCOxzoWCUKQpYW9tKqrx692LMILy5x9J/NfUxSi3gtHMI1RX6LfluBuGRpjhcDsxxaxeuSZGrk7zbVgoGRM49OtyaS/GnH7v+Xskxs4/geWWITXL/QE10IQ2v6ewmFdLAPwdZF2NNzjnuS+GkbyHPVH0bsP/eux6jbu1R2wK9GjI4MP/iYjy9b7jaqbc/XYGtFM6EigZrL18hlemzh/Fvu7/oIQD2Pe+5+2JS2EmXX4zF29VG5OCoeL5VM11eDDbZn4a0A8o4Er8AIJy7Um8qok0uCjZmgZKQ6XiFCyp9UNkumLJA32CqzvKUNEPNLwf+CR7eXEU6zlFrBiBwbB58/gs8dyKerUMXksRZtwOMZ9GFswB3chkFVZb6XCc45/PdrIYfl4c0Vbog/TuxP3MMXBpXbiEGklcBZ0q1FsT2tSEMBwOd6njPSzdZF2cVWQSvZ+IUA8dxrZx2EGWpBF11V6cfBWup6zeRqkyJTBIaVQzubzEs/ZpNz8lKFyCEBsdEgalnVPakFyhb8G0ea5P3CAlreN6TBxepcUHthlX77p5CuPGOA+8yi2NynjMKDXg9Awklca0dcpoMR1Ofat3kj4YuzTzbMrfilpzvg8cWw3e1wpZQtx04v+/jzDBbCC8JXJz7lZexz5ayQ3zj529sWwjsfyIJ/lSzTXRC7Kp1P1uBBn/vFT7Gy1mpBZk9tpUGzLVbuNtUx7/8H2OaeT73vqems4Z5KEjTP+oIX9LWzRxee0UaHFyfk6CgnGeF4CwTIdw0A8o4Er8AIJy7Um8qok0uCjmdwbIcTthJHSl8xgXePabA8lXEkV/j2ESgV5AS/N8lhJyDS5ZqlumY28Bawy49EQD2Pe+5+2JS2EmXX4zF29an1LjdWEv13RH3vqxzFW2+IQaSVwFnSrUWxPa1IQwHB/eigOQncmnJkQFuV61QidQDx3GtnHYQZakEXXVXpx8Fa6nrN5GqTIlMEhpVDO5vMSz9mk3PyUoXIIQGx0SBqWEbFvnZzHRIliGHlLOUY3cA==',
                                   ENCRYPT = 1,
                                   DESCRIPTION = '应用端待办列表字段显示配置',
                                   UPDATE_TIME_ = '2022-11-09 15:53:45',
                                   CREATE_BY_ = '1',
                                   CREATE_TIME_ = '2021-10-14 16:41:40',
                                   CREATE_ORG_ID_ = '',
                                   UPDATE_BY_ = '1',
                                   TENANT_ID_ = NULL
                               WHERE ID = '1448569683989442560';



alter table BPM_DEFINITION add DESIGN_PATTERN_ VARCHAR(20);
comment on column BPM_DEFINITION.DESIGN_PATTERN_ is '设计模式 normal simple';

alter table BPM_DEFINITION add FLOW_TYPE_ int;
comment on column BPM_DEFINITION.FLOW_TYPE_ is '流程类型';


alter table BPM_TASK_REMINDER add TRANSFER_ID_ VARCHAR(64);
comment on column BPM_TASK_REMINDER.TRANSFER_ID_ is '转办人ID';

alter table BPM_TASK_REMINDER add TRANSFER_NAME_ VARCHAR(255);
comment on column BPM_TASK_REMINDER.TRANSFER_NAME_ is '转办人名称';

alter table BPM_TASK_REMINDER add DIRECT_LEADER_ int;
comment on column BPM_TASK_REMINDER.DIRECT_LEADER_ is '催办直接上级';

alter table BPM_TASK_REMINDER add MAIN_ORG_LEADER_ int;
comment on column BPM_TASK_REMINDER.MAIN_ORG_LEADER_ is '催办主组织负责人';

alter table BPM_TASK_REMINDER add DIRECT_USER_IDS_ VARCHAR(1000);
comment on column BPM_TASK_REMINDER.DIRECT_USER_IDS_ is '指定用户ID';

alter table BPM_TASK_REMINDER add DIRECT_USER_NAMES_ VARCHAR(1000);
comment on column BPM_TASK_REMINDER.DIRECT_USER_NAMES_ is '指定用户名称';

alter table BPM_TASK_REMINDER add DIRECT_USER_ int;
comment on column BPM_TASK_REMINDER.DIRECT_USER_ is '催办指定用户';


alter table PORTAL_SYS_LOGS_SETTINGS add FROM_ VARCHAR(1);
comment on column PORTAL_SYS_LOGS_SETTINGS.FROM_ is '1:初始化。2:手动添加';

alter table PORTAL_SYS_LOGS_SETTINGS add MODULE_NAME_ VARCHAR(200);
comment on column PORTAL_SYS_LOGS_SETTINGS.MODULE_NAME_ is '模块名称';


UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1318030354614980608';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338367741324824576';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338375124944031744';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338377219818524672';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338379764150439936';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338381406014935040';

alter table PORTAL_SYS_DIC add CREATE_TIME_ DATE;
comment on column PORTAL_SYS_DIC.CREATE_TIME_ is '创建时间';

alter table PORTAL_SYS_DIC add CREATE_BY_ VARCHAR(255);
comment on column PORTAL_SYS_DIC.CREATE_BY_ is '创建人ID';


alter table PORTAL_SYS_LOGS add ELAPSED_TIME_ decimal(10, 3);
comment on column PORTAL_SYS_LOGS.ELAPSED_TIME_ is '接口耗时（单位：秒）';

alter table BPM_CALL_LOG add ELAPSED_TIME_ DECIMAL(10, 3);
comment on column BPM_CALL_LOG.ELAPSED_TIME_ is '接口耗时（单位：秒）';

alter table BPM_TASK_SIGNDATA  add FROM_ VARCHAR(64);
comment on column BPM_TASK_SIGNDATA.FROM_ is '来源。assign由指定历史会签处理人产生的';


INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_) VALUES ('1572106298114183168', '3641025', '简易流程', 'simpleFlowTable', '', '', 1, 2, '', '-1.1.3641025.1572106298114183168.', '', '-1', '{\"path\":\"/simpleFlowTable\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"简易流程\"}}', NULL);



create table FORM_SIMPLE_DESIGN
(
    ID_             VARCHAR(50)   primary key,
    CATEGORY_ID_    VARCHAR(50),
    CATEGORY_NAME_  VARCHAR(255),
    ALIAS_          VARCHAR(50),
    NAME_           VARCHAR(150),
    CREATE_BY_      VARCHAR(50),
    CREATE_TIME_    DATE,
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64),
    UPDATE_TIME_    DATE,
    DESC_           VARCHAR(255),
    TENANT_ID_      VARCHAR(64)
);
comment on table FORM_SIMPLE_DESIGN is '简易设计';
comment on column FORM_SIMPLE_DESIGN.CATEGORY_ID_ is '分类ID';
comment on column FORM_SIMPLE_DESIGN.CATEGORY_NAME_ is '分类名称';
comment on column FORM_SIMPLE_DESIGN.ALIAS_ is '别名';
comment on column FORM_SIMPLE_DESIGN.NAME_ is '名称';
comment on column FORM_SIMPLE_DESIGN.CREATE_BY_ is '创建人ID';
comment on column FORM_SIMPLE_DESIGN.CREATE_TIME_ is '创建时间';
comment on column FORM_SIMPLE_DESIGN.UPDATE_BY_ is '更新人ID';
comment on column FORM_SIMPLE_DESIGN.UPDATE_TIME_ is '更新时间';
comment on column FORM_SIMPLE_DESIGN.DESC_ is '描述';
comment on column FORM_SIMPLE_DESIGN.TENANT_ID_ is '租户ID';
create index IDX_FORM_BO_DEF_ALIAS_TENANT_ID_   on FORM_SIMPLE_DESIGN (ALIAS_, TENANT_ID_);



INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_, IS_REFRESH_, token_Enabled_, TOKEN_TYPE_, TOKEN_KEY_, TOKEN_API_) 
VALUES ('1631183759799828480', '1441341228585766912', '个人信息', 'information', '', '', NULL, 1, '', '-1.3.1441341228585766912.1631183759799828480.', '', '-1', '{\"path\":\"information\",\"component\":\"@/views/personal/information\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"个人信息\",\"isChildren\":true,\"icon\":\"\"}}', 'page', 1, 0, 0, NULL, NULL);

INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) 
VALUES ('1630743663304851456', 'en', 'Personal.center', 'Personal center', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');

INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_)
 VALUES ('1630743663363571712', 'zh-TW', 'Personal.center', '個人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');
 
INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) 
VALUES ('1630743663392931840', 'zh-CN', 'Personal.center', '个人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');


alter table FORM_HISTORY_RECORD add FORM_CSS_ CLOB;
comment on column FORM_HISTORY_RECORD.FORM_CSS_ is '表单CSS脚本';

alter table FORM_DEFINITION add FORM_CSS_ CLOB;
comment on column FORM_DEFINITION.FORM_CSS_ is '表单CSS脚本';


create table BPM_FREE_PROCESS_DEF
(
    ID_            	VARCHAR(64)  primary key   unique,
    SOURCE_DEF_ID_ 	VARCHAR(64),
    PROC_INST_ID_  	VARCHAR(255),
    BPMN_XML_      	CLOB,
    TENANT_ID_     	VARCHAR(255)
);
comment on table BPM_FREE_PROCESS_DEF is '自由流程定义备份表';
comment on column BPM_FREE_PROCESS_DEF.ID_ is '新流程定义ID';
comment on column BPM_FREE_PROCESS_DEF.SOURCE_DEF_ID_ is '原流程定义ID';
comment on column BPM_FREE_PROCESS_DEF.PROC_INST_ID_ is '实例ID';
comment on column BPM_FREE_PROCESS_DEF.BPMN_XML_ is 'XML';
comment on column BPM_FREE_PROCESS_DEF.TENANT_ID_ is '租户ID';


create table BPM_SERVICE_LOG(
    ID_           	VARCHAR(64)  primary key  unique,
    SUBJECT_      	VARCHAR(600),
    PROC_DEF_ID_  	VARCHAR(64),
    PROC_INST_ID_ 	VARCHAR(64),
    NODE_ID_      	VARCHAR(64),
    STATUS_       	INT,
    CREATE_TIME_  	DATE,
    TENANT_ID_    	VARCHAR(64)
);
comment on table BPM_SERVICE_LOG is '服务节点执行日志';
comment on column BPM_SERVICE_LOG.SUBJECT_ is '流程标题';
comment on column BPM_SERVICE_LOG.PROC_DEF_ID_ is '流程定义ID';
comment on column BPM_SERVICE_LOG.PROC_INST_ID_ is '流程实例ID';
comment on column BPM_SERVICE_LOG.NODE_ID_ is '节点ID';
comment on column BPM_SERVICE_LOG.STATUS_ is '处理结果：1.处理成功  0.处理失败';
comment on column BPM_SERVICE_LOG.TENANT_ID_ is '租户ID';
create index PROC_INST_ID_  on BPM_SERVICE_LOG (PROC_INST_ID_);



create table BPM_DOCUMENTATION_CONFIG
(
    ID_             VARCHAR(255)   primary key unique,
    DATA_KEY_       VARCHAR(255),
    AUTORUN_        VARCHAR(10),
    AUTORUN_CONFIG_ VARCHAR(255),
    DELETE_DATA_    VARCHAR(10),
    LIMIT_          VARCHAR(10),
    LIMIT_NUMBER_   VARCHAR(255),
    UPDATE_BY_      VARCHAR(255),
    UPDATE_TIME_    DATE,
    BEFORE_MONTH_   VARCHAR(255),
    JOB_NAME_       VARCHAR(255),
    TENANT_ID_      VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_CONFIG is '数据归档配置表';
comment on column BPM_DOCUMENTATION_CONFIG.DATA_KEY_ is '数据源key';
comment on column BPM_DOCUMENTATION_CONFIG.AUTORUN_ is '是否自动执行';
comment on column BPM_DOCUMENTATION_CONFIG.AUTORUN_CONFIG_ is '自动执行配置';
comment on column BPM_DOCUMENTATION_CONFIG.DELETE_DATA_ is '是否删除数据';
comment on column BPM_DOCUMENTATION_CONFIG.LIMIT_ is '是否限制数据';
comment on column BPM_DOCUMENTATION_CONFIG.LIMIT_NUMBER_ is '限制数量';
comment on column BPM_DOCUMENTATION_CONFIG.UPDATE_BY_ is '修改人';
comment on column BPM_DOCUMENTATION_CONFIG.UPDATE_TIME_ is '修改时间';
comment on column BPM_DOCUMENTATION_CONFIG.BEFORE_MONTH_ is '同步时间';
comment on column BPM_DOCUMENTATION_CONFIG.JOB_NAME_ is '定时任务名称';
comment on column BPM_DOCUMENTATION_CONFIG.TENANT_ID_ is '租户ID';

create table BPM_DOCUMENTATION_ERROR_LOG
(
    ID_         VARCHAR(255) primary key unique,
    TABLE_NAME_ VARCHAR(255),
    DATA_ID_    VARCHAR(255),
    DATA_       VARCHAR(1000),
    REASON_     CLOB,
    TABLE_ID_   VARCHAR(255),
    TIME_       date,
    TENANT_ID_  VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_ERROR_LOG is '同步错误日志表';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TABLE_NAME_ is '表名';
comment on column BPM_DOCUMENTATION_ERROR_LOG.DATA_ID_ is '数据ID';
comment on column BPM_DOCUMENTATION_ERROR_LOG.DATA_ is '数据';
comment on column BPM_DOCUMENTATION_ERROR_LOG.REASON_ is '失败原因';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TABLE_ID_ is '数据表ID';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TIME_ is '时间';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TENANT_ID_ is '租户ID';


create table BPM_DOCUMENTATION_TABLE
(
    ID_           VARCHAR(255)   primary key   unique,
    TABLE_NAME_   VARCHAR(255),
    DML_          CLOB,
    DDL_          CLOB,
    SYSTEM_       VARCHAR(10),
    START_        VARCHAR(255),
    INFO_         VARCHAR(255),
    ORDER_        VARCHAR(255),
    UPDATE_BY_    VARCHAR(64),
    PARENT_FIELD_ VARCHAR(255),
    FIELD_        VARCHAR(255),
    TIME_KEY_     VARCHAR(255),
    PARENT_ID_    VARCHAR(255),
    UPDATE_TIME_  DATE,
    TENANT_ID_    VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_TABLE is '同步数据目标表';
comment on column BPM_DOCUMENTATION_TABLE.TABLE_NAME_ is '表名';
comment on column BPM_DOCUMENTATION_TABLE.DML_ is '表查询语句';
comment on column BPM_DOCUMENTATION_TABLE.DDL_ is '表定义语句';
comment on column BPM_DOCUMENTATION_TABLE.SYSTEM_ is '是否系统默认表';
comment on column BPM_DOCUMENTATION_TABLE.START_ is '是否启动';
comment on column BPM_DOCUMENTATION_TABLE.INFO_ is '说明';
comment on column BPM_DOCUMENTATION_TABLE.ORDER_ is '同步顺序';
comment on column BPM_DOCUMENTATION_TABLE.UPDATE_BY_ is '创建人';
comment on column BPM_DOCUMENTATION_TABLE.PARENT_FIELD_ is '主表字段';
comment on column BPM_DOCUMENTATION_TABLE.FIELD_ is '子表字段';
comment on column BPM_DOCUMENTATION_TABLE.TIME_KEY_ is '同步表时间字段';
comment on column BPM_DOCUMENTATION_TABLE.PARENT_ID_ is '父表ID';
comment on column BPM_DOCUMENTATION_TABLE.UPDATE_TIME_ is '创建时间';
comment on column BPM_DOCUMENTATION_TABLE.TENANT_ID_ is '租户';

alter table FORM_DATA_TEMPLATE add SHOW_TYPE_ VARCHAR(20);
comment on column FORM_DATA_TEMPLATE.SHOW_TYPE_ is '展示类型';

alter table FORM_DATA_TEMPLATE add GANTT_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.GANTT_CONFIG_ is '甘特图独有一些配置';

alter table FORM_DATA_TEMPLATE add KANBAN_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.KANBAN_CONFIG_ is '看板独有一些配置';

alter table FORM_DATA_TEMPLATE add XMIND_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.XMIND_CONFIG_ is '思维导图的配置';


-- 2023-04-26 jjx  同步脚本
alter table PORTAL_SYS_COLUMN ADD SNAPSHOT_ID_ VARCHAR(64);
comment on column PORTAL_SYS_COLUMN.SNAPSHOT_ID_ is '快照图片id';

alter table  PORTAL_SYS_COLUMN ADD TEMPLATE_STYLE_ CLOB;
comment on column PORTAL_SYS_COLUMN.TEMPLATE_STYLE_ is '模板样式';

create table PORTAL_RECENTLY_APP
(
    ID_             VARCHAR(64)   primary key   unique,
    APP_ID_         VARCHAR(64),
    ACCOUNT_        VARCHAR(64),
    COUNT_          INT,
    CREATE_TIME_    DATE,
    UPDATE_TIME_    DATE,
    CREATE_BY_      VARCHAR(64),
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64),
    TENANT_ID_      int
);
comment on table PORTAL_RECENTLY_APP is '用户最近应用点击记录表';
comment on column PORTAL_RECENTLY_APP.APP_ID_ is '应用ID';
comment on column PORTAL_RECENTLY_APP.ACCOUNT_ is '用户账号';
comment on column PORTAL_RECENTLY_APP.COUNT_ is '点击次数';
comment on column PORTAL_RECENTLY_APP.CREATE_TIME_ is '创建时间';
comment on column PORTAL_RECENTLY_APP.UPDATE_TIME_ is '更新时间';
comment on column PORTAL_RECENTLY_APP.CREATE_BY_ is '创建人';
comment on column PORTAL_RECENTLY_APP.UPDATE_BY_ is '更新人';


-- 2023-05-05 jjx  同步脚本
alter table PORTAL_SYS_LAYOUT_MANAGE add BANNER_TYPE_IDS_ CLOB;
comment on column PORTAL_SYS_LAYOUT_MANAGE.BANNER_TYPE_IDS_ is '轮播图分类IDS';

alter table FORM_DATA_TEMPLATE add MOBILE_DISPLAY_FIELD_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_DISPLAY_FIELD_ is '移动端显示字段';

alter table FORM_DATA_TEMPLATE add MOBILE_MANAGE_FIELD_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_MANAGE_FIELD_ is '移动端功能按钮';


-- 2023-05-10 jjx 同步脚本
INSERT INTO portal_sys_column (ID,NAME,ALIAS,CATALOG,COL_TYPE,DATA_MODE,DATA_FROM,DS_ALIAS,DS_NAME,COL_HEIGHT,COL_URL,TEMPLATE_HTML,IS_PUBLIC,SUPPORT_REFESH,REFESH_TIME,
    SHOW_EFFECT,MEMO,DATA_PARAM,NEEDPAGE,ORG_ID,CREATOR,CREATE_BY_,UPDATE_BY_,CREATE_TIME_,UPDATE_TIME_,REQUEST_TYPE,
                                CATALOG_NAME,CREATE_ORG_ID_,TENANT_ID_,SHOW_TITLE_,CONTAIN_COL_,APPID_,
                                SECRET_,TEMPLATE_JAVA_SCRIPT_,STYLE_,is_init_,SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651467475169812480', '个人信息栏目移动端', 'grxxlmydd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, 0, '',
        'ICA8ZGl2IGNsYXNzPSJhbGxIb21lIj4KICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfaGVhZGVycyI+CiAgICAgIDx0ZW1wbGF0ZSB2LWlmPSJkYXRhLnVzZXIucGhvdG8iPgogICAgICAgIDxpbWcKICAgICAgICAgIDpzcmM9IiRyZXF1ZXN0Q29uZmlnLmdldEltZ1NyYyhkYXRhLnVzZXIucGhvdG8pIgogICAgICAgICAgYWx0PSIiCiAgICAgICAgICB3aWR0aD0iNTIiCiAgICAgICAgICBoZWlnaHQ9IjUyIgogICAgICAgIC8+CiAgICAgIDwvdGVtcGxhdGU+CgogICAgICA8aSB2LWVsc2UgY2xhc3M9Imljb24temhhbmdoYW8iIHN0eWxlPSJmb250LXNpemU6IDM2cHg7IGNvbG9yOiAjZmZmIj48L2k+CiAgICAgIDxkaXYgY2xhc3M9InRpdGxlIj4KICAgICAgICA8ZGl2IGNsYXNzPSJ0aXRsZV90b3AiPgogICAgICAgICAge3sgdGl0bGUgfX0KICAgICAgICA8L2Rpdj4KCiAgICAgICAgPGRpdiBjbGFzcz0idGl0bGVfYm90dG9tIj4KICAgICAgICAgIOS9oOWlve+8gSB7eyBkYXRhLnVzZXIuZnVsbG5hbWUgfX0s56Wd5L2g5byA5b+D5q+P5LiA5aSpCiAgICAgICAgPC9kaXY+CiAgICAgIDwvZGl2PgogICAgPC9kaXY+CiAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnQiPgogICAgICA8ZGl2IHYtZm9yPSIoaXRlbSwgaSkgb2YgbGlzdERhdGEiIDprZXk9ImkiIGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbSIgQGNsaWNrPSdjbGlja0l0ZW0oaXRlbSknPgogICAgICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfY29udGVudF9pdGVtX251bSI+CiAgICAgICAgICB7eyBpdGVtLm51bSA+PSA5OSA/ICI5OSsiIDogaXRlbS5udW0gfX0KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbV9uYW1lIj4KICAgICAgICAgIHt7IGl0ZW0ubmFtZSB9fQogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pg==',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"${bpmRunTime}/runtime/instance/v1/getDefaultInfoMap\",\"model\":\"upDown\",\"colHeightType\":\"custom\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\",\"dataMode\":3,\"requestType\":\"GET\"}',
        0, NULL, NULL, '1', '1', '2023-04-27 14:05:04', '2023-05-04 16:08:15', NULL, '', '', '-1', 0, NULL, '', '',
        'ewogIGRhdGEoKSB7CiAgICByZXR1cm4gewogICAgICBuYW1lOiAi6LaF57qn566h55CG5ZGYIiwKICAgICAgdGl0bGU6ICLmrKLov47kvb/nlKjlro/lpKlFSVAiLAogICAgICBpbWc6ICIiLAoKICAgICAgbGlzdERhdGE6IFsKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5b6F5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMCIsCiAgICAgICAgICBpZDogIm15VGFrcyIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5bey5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMSIsCiAgICAgICAgICBpZDogIm15QWxyZWFkeSIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5oiR55qE55Sz6K+3IiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVJlcXVlc3QiLAogICAgICAgICAgaWQ6ICJteVJlcXVlc3QiLAogICAgICAgICAKICAgICAgICB9LAogICAgICAgIHsKICAgICAgICAgIG5hbWU6ICLmiJHnmoTovazlip4iLAogICAgICAgICAgbnVtOiAwLAogICAgICAgICAgdG86ICIvbWF0dGVyL215RGVsZWdhdGUiLAogICAgICAgICAgaWQ6ICJteUFjY29yZGluZ01hdHRlcnMiLAogICAgICAgIH0sCiAgICAgIF0sCiAgICB9OwogIH0sCiAgbW91bnRlZCgpIHsKICAgIAogICAgZm9yIChsZXQgaXRlbT0wOyAgaXRlbSA8IHRoaXMubGlzdERhdGEubGVuZ3RoOyBpdGVtKyspIHsKICAKICAgICAgdGhpcy5saXN0RGF0YVtpdGVtXS5udW0gPSB0aGlzLmRhdGFbdGhpcy5saXN0RGF0YVtpdGVtXS5pZF0uZGF0YVRleHQgfHwgMDsKICAgIH0KICB9LAogIG1ldGhvZHM6IHsKICAgIGNsaWNrSXRlbShpdGVtKSB7CiAgICAgY29uc29sZS5sb2coaXRlbSkKICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS50byk7CiAgICB9LAogIH0sCn0=',
        '', 0, '1654035192534351872',
        'LmFsbEhvbWUgewoKICB3aWR0aDogY2FsYygxMDAlIC0gMjRweCk7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGp1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2VlbjsKICBoZWlnaHQ6IDExOHB4OwogIGJhY2tncm91bmQ6ICNmZmZmZmY7CiAgYm9yZGVyLXJhZGl1czogMTJweCAxMnB4IDEycHggMTJweDsKICBwYWRkaW5nOiAxNnB4IDEycHg7Cn0KIC5hbGxIb21lX2hlYWRlcnMgewogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBmbGV4LXN0YXJ0OwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0KLmFsbEhvbWUgLmFsbEhvbWVfaGVhZGVycyBpbWcgewogIG1hcmdpbi1yaWdodDogOHB4OwogIGJvcmRlci1yYWRpdXM6IDUwJTsKfQouYWxsSG9tZSAuYWxsSG9tZV9oZWFkZXJzIC50aXRsZSAudGl0bGVfdG9wIAp7ICAgIG1hcmdpbi1ib3R0b206IDdweDsKICBjb2xvcjogIzI2MjYyNjsKICBmb250LXdlaWdodDogODAwOwogIGZvbnQtc2l6ZTogMThweDsKfQoKLmFsbEhvbWUgLmFsbEhvbWVfY29udGVudCAuYWxsSG9tZV9jb250ZW50X2l0ZW1fbnVtewogIG1hcmdpbi10b3A6MTZweDsKaGVpZ2h0OiAzMHB4Owpjb2xvcjogIzI2MjYyNjsKZm9udC13ZWlnaHQ6IDkwMDsKZm9udC1zaXplOiAyNHB4OwptYXJnaW4tYm90dG9tOiA2cHg7dGV4dC1hbGlnbjogY2VudGVyOwp9Ci5hbGxIb21lIC5hbGxIb21lX2hlYWRlcnMgLnRpdGxlIC50aXRsZV9ib3R0b20gewogIGNvbG9yOiAjNTg1ODU4OwogIGZvbnQtd2VpZ2h0OiA0MDA7CiAgZm9udC1zaXplOiAxNHB4Owp9Ci5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnQgLmFsbEhvbWVfY29udGVudF9pdGVtX25hbWV7CiAgCmZvbnQtc2l6ZTogMTFweDsKZm9udC13ZWlnaHQ6IDQwMDsKY29sb3I6ICM4QzhDOEM7Cn0KCi5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnR7CgogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0=');




INSERT INTO portal_sys_column(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS,
                                DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH,
                                REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR,
                                CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE,
                                CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_, SHOW_TITLE_, CONTAIN_COL_, APPID_,
                                SECRET_, TEMPLATE_JAVA_SCRIPT_, STYLE_, is_init_, SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651134508916514816', '常用功能', 'cygnsjd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '',
        'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
        0, NULL, NULL, '1', '1', '2023-04-26 16:01:58', '2023-05-05 17:09:33', NULL, '', '', '-1', 1, NULL, '', '',
        'e30=', '', 0, '1654413008396435456',
        'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1hcm91bmQ7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KICA=');

INSERT INTO portal_sys_column(ID, NAME,ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS,
                                DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH,
                                REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR,
                                CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE,
                                CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_, SHOW_TITLE_, CONTAIN_COL_, APPID_,
                                SECRET_, TEMPLATE_JAVA_SCRIPT_, STYLE_, is_init_, SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651056986864828416', '数据台', 'sjt', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '',
        'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
        0, NULL, NULL, '1', '1', '2023-04-26 10:53:55', '2023-05-05 15:05:57', NULL, '', '', '-1', 1, NULL, '', '',
        'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lyg6ZiFJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=',
        '', 0, '1654381902993375232',
        'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IHNwYWNlLWFyb3VuZDsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9');

INSERT INTO BPM_DOCUMENTATION_config(ID_, DATA_KEY_, AUTORUN_, AUTORUN_CONFIG_, DELETE_DATA_, LIMIT_,
                                          LIMIT_NUMBER_, UPDATE_BY_, UPDATE_TIME_, BEFORE_MONTH_, JOB_NAME_,
                                         TENANT_ID_)
VALUES ('1', NULL, '1', '{\"type\":4,\"timeInterval\":\"MON,TUE,WED,SUN|11:49:20\"}', '2', '1', '500', '1',
        '2023-03-23 15:46:12', '0', '流程归档数据同步', '-1');
		

alter table FORM_DATA_TEMPLATE  add MOBILE_TEMPLATE_ALIAS_ VARCHAR(128);
comment on column FORM_DATA_TEMPLATE.MOBILE_TEMPLATE_ALIAS_ is '移动端数据模板别名';

alter table FORM_DATA_TEMPLATE add MOBILE_TEMPLATE_HTML_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_TEMPLATE_HTML_ is '移动端数据模板代码'; 
 
ALTER TABLE PORTAL_SYS_APP  ADD ALIAS_ VARCHAR(64);
comment on column PORTAL_SYS_APP.ALIAS_ is '应用别名';

ALTER TABLE PORTAL_SYS_APP_MENU  ADD MENU_TYPE_ VARCHAR(64);
comment on column PORTAL_SYS_APP_MENU.MENU_TYPE_ is '菜单类型';

ALTER TABLE PORTAL_SYS_APP_MENU  ADD ICON_ VARCHAR(64);
comment on column PORTAL_SYS_APP_MENU.ICON_ is '图标';

alter table PORTAL_SYS_APP_MENU modify SN_ INT;
alter table PORTAL_SYS_APP_MENU alter column SN_ set not null;

-- 2023-05-10 jjx 修改PC模块菜单别名	
UPDATE PORTAL_SYS_MENU  SET ALIAS_ = 'pcAppCenter' WHERE ID_ LIKE '1296282423985836032';	
	
-- 2023-05-17 jjx 同步脚本
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656920738508091392', '1651467475169812480', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656921529427996672', '1651134508916514816', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656921540433850368', '1651056986864828416', NULL, NULL, 'everyone', 'indexColumn', '-1');

alter table BPM_DEFINITION  add DEPLOY_DESC_ VARCHAR(500);
comment on column BPM_DEFINITION.DEPLOY_DESC_ is '发布说明';

create table BPM_SHOW_RECORD(
    ID_            VARCHAR(32)	 not null   primary key unique,
    ACCOUNT_       VARCHAR(32)	 not null,
    FULL_NAME_     VARCHAR(32)	 not null,
    SHOW_TIME_     DATE       	 not null,
    TASK_ID_       VARCHAR(32),
    ACTION_        VARCHAR(32),
    SHOW_TYPE_     VARCHAR(20),
    REASONS_       CLOB       	 not null,
    CREATE_BY_     VARCHAR(32),
    CREATE_TIME_   DATE,
    CREATE_ORG_ID_ VARCHAR(32),
    UPDATE_BY_     VARCHAR(32),
    UPDATE_TIME_   DATE,
    TENANT_ID_     VARCHAR(32)
);
comment on table BPM_SHOW_RECORD is '流程实例和流程任务查阅记录';
comment on column BPM_SHOW_RECORD.ID_ is '主键ID';
comment on column BPM_SHOW_RECORD.ACCOUNT_ is '查阅人账号';
comment on column BPM_SHOW_RECORD.FULL_NAME_ is '查阅人名称';
comment on column BPM_SHOW_RECORD.SHOW_TIME_ is '查阅时间';
comment on column BPM_SHOW_RECORD.TASK_ID_ is '流程实例ID或任务ID';
comment on column BPM_SHOW_RECORD.ACTION_ is '流程定义中的动作：发布新版本/保存';
comment on column BPM_SHOW_RECORD.SHOW_TYPE_ is '展示类型：实例/任务/流程定义';
comment on column BPM_SHOW_RECORD.REASONS_ is '查阅原因';
comment on column BPM_SHOW_RECORD.CREATE_BY_ is '创建人';
comment on column BPM_SHOW_RECORD.CREATE_TIME_ is '创建时间';
comment on column BPM_SHOW_RECORD.UPDATE_BY_ is '更新人';
comment on column BPM_SHOW_RECORD.UPDATE_TIME_ is '更新时间';
comment on column BPM_SHOW_RECORD.TENANT_ID_ is '租户ID';
create index SHOW_RECORD_TASK_ID__SHOW_TYPE__INDEX   on BPM_SHOW_RECORD (TASK_ID_, SHOW_TYPE_);

-- 2023-05-18 jjx 同步脚本
alter table FORM_DATA_TEMPLATE  add INNER_BTN_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.INNER_BTN_CONFIG_ is '页内按钮的配置';


create table BPM_PRO_PUBLICITY_READ
(
    ID_  VARCHAR(64) 	not null   primary key  unique,
    PROC_INST_ID_ 	VARCHAR(64),
    USER_ID_      	VARCHAR(64),
    TENANT_ID_    	VARCHAR(64)
);
comment on table BPM_PRO_PUBLICITY_READ is '流程公示阅读记录';
comment on column BPM_PRO_PUBLICITY_READ.PROC_INST_ID_ is '实例ID';
comment on column BPM_PRO_PUBLICITY_READ.USER_ID_ is '用户ID';
create index IDX_USER_ID_USER_ID   on BPM_PRO_PUBLICITY_READ (USER_ID_);
create index BPM_PRO_PUBLICITY_READ_PROC_INST_ID_   on BPM_PRO_PUBLICITY_READ (PROC_INST_ID_);

-- 2023-05-19 JJX 添加流程归档菜单

INSERT INTO PORTAL_SYS_MENU (ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_, TOKEN_ENABLED_, TOKEN_TYPE_, TOKEN_KEY_, TOKEN_API_, IS_REFRESH_) VALUES ('1643794670103810048', '4291768', '流程归档', 'historyDataConfig', '', '', null, 7, '', '-1.1.3641025.4291768.1643794670103810048.', '', '-1', '{\"path\":\"historyDataConfig\",\"component\":\"MultilevelMenuLayout\",\"redirect\":\"\",\"alwaysShow\":true,\"caseSensitive\":false,\"meta\":{\"title\":\"流程归档\",\"icon\":\"\",\"isChildren\":true}}', 'catalog', 0, 0, null, null, 1);
-- 2023-05-22 删除移动端流程分类菜单
delete from portal_sys_menu where NAME_ = '移动端流程分类';


-- 2023-05-22 lizhenxing 流程归档定时任务初始数据
INSERT INTO qrtz_job_details(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES ('quartzScheduler', '数据归档定时任务', '-1', '数据归档定时任务', 'com.hotent.job.job.DocumentationJob', '1', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800);

-- 2023-05-23 lizhenxing 流程归档初始化表数据
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644250277726375936', 'bpm_pro_inst', '', 'CREATE TABLE bpm_pro_inst (
	ID_ VARCHAR(64) NOT NULL primary key unique,
	SUBJECT_ VARCHAR2(256) NOT NULL,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	BPMN_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_DEF_KEY_ VARCHAR(128) DEFAULT NULL,
	PROC_DEF_NAME_ VARCHAR(128) NOT NULL,
	BIZ_KEY_ VARCHAR(64) DEFAULT NULL,
	SYS_CODE_ VARCHAR(64) DEFAULT NULL,
	FORM_KEY_ VARCHAR(64) DEFAULT NULL,
	STATUS_ VARCHAR(40) DEFAULT NULL,
	END_TIME_ DATETIME,
	DURATION_ INTEGER DEFAULT NULL,
	TYPE_ID_ VARCHAR(64) DEFAULT NULL,
	RESULT_TYPE_ VARCHAR(40) DEFAULT NULL,
	BPMN_INST_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_BY_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	CREATE_ORG_ID_ VARCHAR(64) DEFAULT NULL,
	UPDATE_BY_ VARCHAR(64) DEFAULT NULL,
	UPDATE_TIME_ DATETIME,
	IS_FORMMAL_ CHAR(1) NOT NULL,
	PARENT_INST_ID_ VARCHAR(64) DEFAULT NULL,
	IS_FORBIDDEN_ SMALLINT DEFAULT NULL,
	DATA_MODE_ VARCHAR(20) DEFAULT NULL,
	CREATOR_ VARCHAR(64) DEFAULT NULL,
	SUPPORT_MOBILE_ INTEGER DEFAULT 0,
	SUPER_NODE_ID_ VARCHAR(64) DEFAULT NULL,
	IS_DELE_ INTEGER DEFAULT 0 NOT NULL,
	URGENT_STATE_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_ORG_PATH_ CLOB,
	PC_INST_URL_ VARCHAR(200),
	MOBILE_INST_URL_ VARCHAR(200),
	CREATE_ACCOUNT_ VARCHAR(64)
);', '1', '1', NULL, '1', '1', NULL, NULL, 'UPDATE_TIME_', '0', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644251197944090624', 'bpm_bus_link', NULL, 'CREATE TABLE bpm_bus_link(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY  unique,
	DEF_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) DEFAULT NULL,
	BUSINESSKEY_ INTEGER DEFAULT NULL,
	BUSINESSKEY_STR_ VARCHAR(64) DEFAULT NULL,
	SYS_CODE_ VARCHAR(64) DEFAULT NULL,
	FORM_IDENTIFY_ VARCHAR(64) NOT NULL,
	START_ID_ VARCHAR(64) DEFAULT NULL,
	STARTOR_ VARCHAR(128) DEFAULT NULL,
	CREATE_DATE_ DATETIME,
	START_GROUP_ID_ VARCHAR(64) DEFAULT NULL,
	START_GROUP_ VARCHAR(128) DEFAULT NULL,
	IS_MAIN_ SMALLINT DEFAULT NULL,
	BO_DEF_CODE_ VARCHAR(64) DEFAULT NULL,
	SAVE_MODE_ VARCHAR(50) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '1', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644251940189097984', 'bpm_pro_status', NULL, 'CREATE TABLE bpm_pro_status(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PROC_INST_ID_ VARCHAR(64) NOT NULL,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	NODE_ID_ VARCHAR(255) NOT NULL,
	NODE_NAME_ VARCHAR(255) DEFAULT NULL,
	STATUS_ VARCHAR(50) NOT NULL,
	LAST_UPDATE_ DATETIME,
	LAST_USERID_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	RECYCLE_NODE_ VARCHAR2(2) DEFAULT ''''''''''''''''0''''''''''''''''
);', '1', '0', NULL, '2', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644252316812431360', 'bpm_check_opinion', NULL, 'CREATE TABLE bpm_check_opinion(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	SUP_INST_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) NOT NULL,
	TASK_ID_ VARCHAR(64) DEFAULT NULL,
	TASK_KEY_ VARCHAR(64) DEFAULT NULL,
	TASK_NAME_ VARCHAR(255) DEFAULT NULL,
	TOKEN_ VARCHAR(64) DEFAULT NULL,
	QUALFIEDS_ CLOB DEFAULT NULL,
	QUALFIED_NAMES_ CLOB DEFAULT NULL,
	AUDITOR_ VARCHAR(64) DEFAULT NULL,
	AUDITOR_NAME_ VARCHAR(64) DEFAULT NULL,
	ORG_ID_ VARCHAR(64) DEFAULT NULL,
	ORG_PATH_ VARCHAR(600) DEFAULT NULL,
	OPINION_ VARCHAR(4000) DEFAULT NULL,
	STATUS_ VARCHAR(40) NOT NULL,
	FORM_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	FORM_NAME_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	ASSIGN_TIME_ DATETIME,
	COMPLETE_TIME_ DATETIME,
	DUR_MS_ INTEGER DEFAULT NULL,
	FILES_ VARCHAR(4000) DEFAULT NULL,
	INTERPOSE_ SMALLINT DEFAULT NULL,
	IS_DELE_ INTEGER DEFAULT 0 NOT NULL,
	IS_READ_ INTEGER DEFAULT 0 NOT NULL,
	AGENT_LEADER_ID_ VARCHAR(64) DEFAULT NULL,
	PROP1_ VARCHAR(200) DEFAULT NULL,
	PROP2_ VARCHAR(200) DEFAULT NULL,
	PROP3_ VARCHAR(200) DEFAULT NULL,
	PROP4_ VARCHAR(200) DEFAULT NULL,
	PROP5_ VARCHAR(200) DEFAULT NULL,
	PROP6_ CLOB,
	Z_FILES_ VARCHAR(1000) DEFAULT NULL,
	FORM_DATA_ CLOB,
	PARENT_TASK_ID_ VARCHAR(64) DEFAULT NULL,
	SIGN_TYPE_ VARCHAR(64) DEFAULT NULL,
	SKIP_TYPE_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	VARS_ CLOB,
	QUALFIEDS_ACCOUNT_ CLOB,
	AUDITOR_ACCOUNT_ VARCHAR(255)
);', '1', '0', NULL, '3', '1', 'id_', 'proc_inst_id_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644253067093725184', 'bpm_exe_stack', NULL, 'CREATE TABLE BPM_EXE_STACK (
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PRCO_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	NODE_ID_ VARCHAR(64) NOT NULL,
	NODE_NAME_ VARCHAR(128) DEFAULT NULL,
	START_TIME_ DATETIME,
	END_TIME DATETIME,
	IS_MULITI_TASK_ SMALLINT NOT NULL,
	PARENT_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) DEFAULT NULL,
	NODE_PATH_ VARCHAR(1024) DEFAULT NULL,
	DEPTH_ SMALLINT DEFAULT NULL,
	TASK_TOKEN_ VARCHAR(255) DEFAULT NULL,
	NODE_TYPE_ VARCHAR(255) DEFAULT NULL,
	TARGET_NODE_ VARCHAR2(200) DEFAULT NULL,
	TARGET_TOKEN_ VARCHAR(255) DEFAULT NULL,
	INTERPOSE_ SMALLINT DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '4', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644254426346016768', 'bpm_flow_mq_log', NULL, 'CREATE TABLE bpm_flow_mq_log(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	TYPE_ VARCHAR(40) NOT NULL,
	TITLE_ VARCHAR(300),
	CONTENT_ CLOB,
	STATUS_ INT NOT NULL,
	TRY_TIME_ INT,
	EXCEPTION_ VARCHAR(2000),
	LOG_TIME_ DATE,
	TARGET_ VARCHAR(64),
	PROC_INST_ID_ VARCHAR(64),
	TASK_ID_ VARCHAR(64),
	OWNER_ID_ VARCHAR(64),
	OWNER_NAME_ VARCHAR(64),
	TENANT_ID_ VARCHAR(64),
	YEARS_PARTITION_ INT
);', '1', '0', NULL, '5', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644254843394052096', 'bpm_read_record', NULL, 'CREATE TABLE bpm_read_record(
	ID_ VARCHAR(255) NOT NULL PRIMARY KEY unique ,
	PROC_DEF_ID_ VARCHAR(255) DEFAULT NULL,
	SUP_INST_ID_ VARCHAR(255) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(255) DEFAULT NULL,
	TASK_ID_ VARCHAR(255) DEFAULT NULL,
	TASK_KEY_ VARCHAR(255) DEFAULT NULL,
	TASK_NAME_ VARCHAR(255) DEFAULT NULL,
	READER_ VARCHAR(255) DEFAULT NULL,
	READER_NAME_ VARCHAR(255) DEFAULT NULL,
	READ_TIME_ DATETIME,
	ORG_ID_ VARCHAR(255) DEFAULT NULL,
	ORG_PATH_ VARCHAR(255) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '6', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_, DML_)
VALUES('1644272017298935808', 'bpm_exe_stack_executor', 'CREATE TABLE BPM_EXE_STACK_EXECUTOR (
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	STACK_ID_ VARCHAR(64) DEFAULT NULL,
	TASK_ID_ VARCHAR(64) DEFAULT NULL,
	ASSIGNEE_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	END_TIME_ DATETIME,
	STATUS_ SMALLINT DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	TARGET_NODE_ VARCHAR2(64)
);', NULL, '1', NULL, '7', '1', 'id_', 'STACK_ID_', '', '1644253067093725184', '2023-06-06', '-1', NULL);


-- 2023-5-25 jjx 修改date类型为datetime
ALTER TABLE ACT_HI_ACTINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_ACTINST MODIFY END_TIME_ DATETIME(6);

ALTER TABLE ACT_HI_ATTACHMENT MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_COMMENT MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_DETAIL MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_PROCINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_PROCINST MODIFY END_TIME_ DATETIME(6);

ALTER TABLE ACT_HI_TASKINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY CLAIM_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY END_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY DUE_DATE_ DATETIME(6);

ALTER TABLE ACT_HI_VARINST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_VARINST MODIFY LAST_UPDATED_TIME_ DATETIME(6);

ALTER TABLE ACT_RU_TASK MODIFY DUE_DATE_ DATETIME(6);

ALTER TABLE BPM_AGENT_SETTING MODIFY START_DATE_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY END_DATE_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY UPDATE_TIME_ DATETIME(6);


ALTER TABLE BPM_APPROVAL_ITEM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_APPROVAL_ITEM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_APPROVAL_ORG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_APPROVAL_ORG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_BUS_LINK MODIFY CREATE_DATE_ DATETIME(6);

ALTER TABLE BPM_CALL_LOG MODIFY CALL_TIME_ DATETIME(6);

ALTER TABLE BPM_CHECK_OPINION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_CHECK_OPINION_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION_HI MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION_HI MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_COMMU_RECEIVER MODIFY RECEIVE_TIME_ DATETIME(6);
ALTER TABLE BPM_COMMU_RECEIVER MODIFY FEEDBACK_TIME_ DATETIME(6);

ALTER TABLE BPM_CPTO_RECEIVER MODIFY READ_TIME_ DATETIME(6);
ALTER TABLE BPM_CPTO_RECEIVER MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DEF_AUTHORIZE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DEFINITION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DEFINITION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK MODIFY END_TIME DATETIME(6);

ALTER TABLE BPM_EXE_STACK_EXECUTOR MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK_EXECUTOR MODIFY END_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK_HIS MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK_HIS MODIFY END_TIME DATETIME(6);

ALTER TABLE BPM_EXE_STACK_RELATION MODIFY CREATED_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK_RELATION_HIS MODIFY CREATED_TIME_ DATETIME(6);

ALTER TABLE BPM_EXTEND_JAR MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_EXTEND_JAR MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_FLOW_COLLECT MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_FLOW_MQ_LOG MODIFY LOG_TIME_ DATETIME(6);

ALTER TABLE BPM_FORM_MODIFY_RECORD MODIFY MODIFY_TIME_ DATETIME(6);

ALTER TABLE BPM_INST_DELETE_LOG MODIFY DELETE_TIME_ DATETIME(6);

ALTER TABLE BPM_INTERPOSE_RECORED MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_INTERPOSE_RECORED MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_MEETINGROOM_APPOINTMENT MODIFY APPOINTMENT_BEG_TIME_ DATETIME(6);
ALTER TABLE BPM_MEETINGROOM_APPOINTMENT MODIFY APPOINTMENT_END_TIME_ DATETIME(6);

ALTER TABLE BPM_MESSAGE_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_MESSAGE_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_MOBILE_CATEGORY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_MOBILE_CATEGORY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_NODE_SETTING MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_NODE_SETTING MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRINT_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRINT_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_CPTO MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_INST MODIFY END_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_INST_HI MODIFY END_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST_HI MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_STATUS MODIFY LAST_UPDATE_ DATETIME(6);

ALTER TABLE BPM_PRO_STATUS_HI MODIFY LAST_UPDATE_ DATETIME(6);

ALTER TABLE BPM_READ_RECORD MODIFY READ_TIME_ DATETIME(6);

ALTER TABLE BPM_REMINDER_HISTORY MODIFY EXECUTE_DATE_ DATETIME(6);

ALTER TABLE BPM_SAVE_OPINION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SAVE_OPINION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_SCRIPT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SCRIPT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK MODIFY DUE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_COMMU MODIFY CREATETIME_ DATETIME(6);

ALTER TABLE BPM_TASK_DUE_TIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_DUE_TIME MODIFY EXPIRATION_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_DUE_TIME MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_NOTICE MODIFY DUE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY COMPLETE_TIME_ DATETIME(6);


ALTER TABLE BPM_TASK_REMINDER MODIFY REL_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY DUE_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY MSG_SEND_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY TRIGGER_DATE_ DATETIME(6);

ALTER TABLE BPM_TASK_SIGNDATA MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_SIGNDATA MODIFY VOTE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TRANS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY TRANS_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TURN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TURN MODIFY FINISH_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_URGENT MODIFY URGRNT_DATE_ DATETIME(6);

ALTER TABLE BPM_TEST_CASE_LOGS MODIFY EXECUTION_TIME_ DATETIME(6);

ALTER TABLE BPM_TRANS_RECEIVER MODIFY RECEIVER_TIME_ DATETIME(6);
ALTER TABLE BPM_TRANS_RECEIVER MODIFY CHECK_TIME_ DATETIME(6);

ALTER TABLE BPM_TRANS_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TRANS_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_WATERMARK MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_WATERMARK MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_BO_DEF MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_BO_DEF MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_BO_INT MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CODEGEN_LOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CODEGEN_LOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_CHART MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_CHART MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_COMPONENT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_COMPONENT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_DIALOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_DIALOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_QUERY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_QUERY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DATA_TEMPLATE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE_DRAFT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DATA_TEMPLATE_DRAFT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE_IMPORT_LOG MODIFY IMPORT_TIME_ DATETIME(6);

ALTER TABLE FORM_DEFINITION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DEFINITION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DEFINITION_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DEFINITION_HI MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_FIELD_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_FIELD_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_HISTORY_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_HISTORY_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_META MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_META MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_PRINT_TEMPLATE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_PRINT_TEMPLATE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_URL_FORM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_URL_FORM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_AGENDA_DAY MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_APP MODIFY UPDATE_TIME_ DATETIME(6);


ALTER TABLE PORTAL_APP_PARAM MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_BIZ_SYSTEM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CAL_ABSENCE MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CAL_ABSENCE MODIFY END_TIME_ DATETIME(6);


ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY YEAR_BEGIN_ DATETIME(6);
ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY YEAR_END_ DATETIME(6);
ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY SPECIFY_DATE_ DATETIME(6);

ALTER TABLE PORTAL_CAL_OVERTIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CAL_OVERTIME MODIFY END_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CONNECTION_MANAGER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CONNECTION_MANAGER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_DB_INTERFACE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_DB_INTERFACE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_FLOW_UPLOAD_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_FLOW_UPLOAD_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_I18N_MESSAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_I18N_MESSAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_INTERFACE_MANAGER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_INTERFACE_MANAGER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_APPLY MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_CONFIG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_ROOM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MESSAGE_LOG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MSG_SEND_LOG MODIFY SEND_TIME DATETIME(6);

ALTER TABLE PORTAL_MY_SCHEDULE MODIFY DATE_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY PUBLISH_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_TAG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_TAG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_TREE_ MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_TREE_ MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RESTFUL_INTERFACE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RESTFUL_INTERFACE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RESTFUL_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RESTFUL_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SERVICE_CHOREOGRAPHY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SERVICE_CHOREOGRAPHY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SERVICE_LOG MODIFY CALL_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY LOSE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_APP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_APP_MENU MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_APP_MENU MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_COLUMN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_COLUMN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_DATASOURCE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_DATASOURCE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_FILE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_FILE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_FILE_CLASSIFY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_FILE_CLASSIFY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_IDENTITY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_IDENTITY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_JOBLOG MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_JOBLOG MODIFY END_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LAYOUT_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_LAYOUT_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LAYOUT_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_LAYOUT_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LOGS MODIFY EXECUTION_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL MODIFY SEND_DATE_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL_LINKMAN MODIFY SENDTIME DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL_SETTING MODIFY LAST_RECEIVE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MODULE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MODULE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MSG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MSG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MSG_READ MODIFY RECEIVER_TIME_ DATETIME(6);


ALTER TABLE PORTAL_SYS_MSG_TPL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MSG_TPL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_POPUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_POPUP MODIFY VALIDITY_START_ DATETIME(6);
ALTER TABLE PORTAL_SYS_POPUP MODIFY VALIDITY_END_ DATETIME(6);

ALTER TABLE PORTAL_SYS_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_SIGNET MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_SIGNET MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TOOLS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TOOLS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TYPE_GROUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TYPE_GROUP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_URL_PERMISSION MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_USER_LAYOUT_CONFIG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY CREATE_TIME DATETIME(6);
ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY UPDATE_TIME DATETIME(6);
ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY PULL_TIME DATETIME(6);

ALTER TABLE UC_BATCH_SYNC MODIFY EXECUTE_TIME_ DATETIME(6);
ALTER TABLE UC_BATCH_SYNC MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_BATCH_SYNC MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_DEMENSION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_DEMENSION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ELECTRONIC_SEAL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ELECTRONIC_SEAL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_GROUP MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_HOLIDAY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_HOLIDAY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_HOLIDAY_TIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE UC_HOLIDAY_TIME MODIFY END_TIME_ DATETIME(6);

ALTER TABLE UC_LOGIN_LOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_LOGIN_LOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX_COL_DEF MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX_COL_DEF MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ONE_TIME_CODE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_OPERATE_LOG MODIFY START_TIME_ DATETIME(6);
ALTER TABLE UC_OPERATE_LOG MODIFY END_TIME_ DATETIME(6);

ALTER TABLE UC_ORG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_JOB MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_JOB MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_POST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_POST MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_UNITE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_UNITE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_USER MODIFY START_DATE_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY END_DATE_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORGAN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORGAN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_REL_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_REL_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_REL_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_SHIFT_RULE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_SHIFT_RULE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_SHIFT_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_SHIFT_USER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_IGNORE_MENU MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_IGNORE_MENU MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_LOGS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_LOGS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_MAIL_SERVER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_MAIL_SERVER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER MODIFY BIRTHDAY_ DATETIME(6);
ALTER TABLE UC_USER MODIFY ENTRY_DATE_ DATETIME(6);
ALTER TABLE UC_USER MODIFY LEAVE_DATE_ DATETIME(6);
ALTER TABLE UC_USER MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER MODIFY PWD_CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_GROUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_GROUP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_REL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_REL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_UNDER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_UNDER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_BO MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TURNASSIGN MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DOCUMENTATION_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_RECORD MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_ERROR_LOG MODIFY TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_TABLE MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SERVICE_LOG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE FORM_SIMPLE_DESIGN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_SIMPLE_DESIGN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CUSTOM_TODO MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY COMPLETE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY DEAD_LINE_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY REPEAT_START_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RECENTLY_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RECENTLY_APP MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_DIC MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY SYNC_STARTING_TIME DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY REPEAT_START_TIME_ DATETIME(6);



-- 2023-05-29 jjx 同步脚本
update portal_sys_menu set tabs_style_='' where alias_='demension';

create table FORM_AUTHORIZE
(
    ID_    				VARCHAR(64) not null    primary key unique,
    AUTHORIZE_DESC_  	VARCHAR(255),
    CREATE_BY_       	VARCHAR(64),
    CREATOR_         	VARCHAR(64),
    CREATE_TIME_     	DATETIME(6),
    MULTI_PLE        	VARCHAR(64),
    TENANT_ID_       	VARCHAR(64),
    AUTHORIZE_MODEL_ 	VARCHAR(64)
);
comment on table FORM_AUTHORIZE is '表单模块相关授权主表';
comment on column FORM_AUTHORIZE.AUTHORIZE_DESC_ is '授权说明';
comment on column FORM_AUTHORIZE.CREATE_BY_ is '创建人ID';
comment on column FORM_AUTHORIZE.CREATOR_ is '创建人';
comment on column FORM_AUTHORIZE.AUTHORIZE_MODEL_ is '授权对象';


create table FORM_AUTHORIZE_ACT
(
    ID_    			VARCHAR(64) not null    primary key unique,
    AUTHORIZE_ID_  	VARCHAR(64),
	MODEL_KEY_		VARCHAR(64),
	MODEL_NAME_		VARCHAR(128),
	RIGHT_CONTENT_	VARCHAR(128),
	TYPE_			VARCHAR(64),
	TENANT_ID_ 		VARCHAR(64)
);
comment on table FORM_AUTHORIZE_ACT is '表单相关授权定义';
comment on column FORM_AUTHORIZE_ACT.AUTHORIZE_ID_ is '授权主表ID';
comment on column FORM_AUTHORIZE_ACT.MODEL_KEY_ is '授权KEY';
comment on column FORM_AUTHORIZE_ACT.MODEL_NAME_ is '授权名称';
comment on column FORM_AUTHORIZE_ACT.RIGHT_CONTENT_ is '授权内容';
comment on column FORM_AUTHORIZE_ACT.TYPE_ is '1,对象。2，对象分类';
create index IDX_AUTHDEF_AUTHID_FORM_AUTHORIZE_ACT on FORM_AUTHORIZE_ACT (AUTHORIZE_ID_);

create table  FORM_AUTHORIZE_USER
(
    ID_            VARCHAR(64) not null   primary key  unique,
    AUTHORIZE_ID_  VARCHAR(64),
    OWNER_NAME_    VARCHAR(128),
	OWNER_ID_      VARCHAR(64),
    RIGHT_TYPE_    VARCHAR(20),
    OBJ_TYPE_      VARCHAR(64),
    AUTH_ORG_      VARCHAR(255),
    AUTH_ORG_NAME_ VARCHAR(255),
    TENANT_ID_     VARCHAR(64)
);
comment on table  FORM_AUTHORIZE_USER is '表单相关授权的用户';
comment on column  FORM_AUTHORIZE_USER.ID_ is '流程授权主表ID';
comment on column  FORM_AUTHORIZE_USER.AUTHORIZE_ID_ is '流程授权主表ID';
comment on column  FORM_AUTHORIZE_USER.OWNER_NAME_ is '授权对象名称';
comment on column  FORM_AUTHORIZE_USER.RIGHT_TYPE_ is '授权对象类型(角色,用户,岗位等)';
comment on column  FORM_AUTHORIZE_USER.OWNER_ID_ is '授权对象ID';
create index  IDX_DEFUSER_AUTHID_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (AUTHORIZE_ID_);
create index  IDX_DEFUSER_OBJTYPE_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (OBJ_TYPE_);
create index  IDX_DEFUSER_RIGHTTYPE_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (RIGHT_TYPE_);

INSERT INTO portal_sys_menu(ID_,PARENT_ID_,NAME_,ALIAS_,ACTIVE_TAB_,MENU_ICON_,OPENED_,SN_,TABS_STYLE_,PATH_,HREF_,TENANT_ID_,ROUTE_EXTEND_,TYPE_,IS_REFRESH_,token_Enabled_,TOKEN_TYPE_,TOKEN_KEY_,TOKEN_API_) VALUES ('1660521382890016768', '3391046', '资源授权', 'formAuthorizeManager', '', '', NULL, 6, '', '-1.1.3441002.3391046.1660521382890016768.', '', '-1', '{\"path\":\"formAuthorizeManager\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"资源授权\",\"isChildren\":true,\"icon\":\"\"}}', 'catalog', 1, 0, 0, NULL, NULL);
-- 2023-06-02 jjx 同步脚本
UPDATE portal_sys_column SET NAME = '数据台', ALIAS = 'sjt', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '', TEMPLATE_HTML = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=', IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '', DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 10:53:55', UPDATE_TIME_ = '2023-06-01 17:16:52', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1, CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=', STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '1664199322310361088', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9' WHERE ID = '1651056986864828416';

UPDATE portal_sys_column SET NAME = '常用功能', ALIAS = 'cygnsjd', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '', TEMPLATE_HTML = 'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==', IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '', DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 16:01:58', UPDATE_TIME_ = '2023-06-01 17:20:53', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1, CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'e30=', STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KLm1vYmlsZS1jdXN0b20taXRlbSBzcGFuewogIHBhZGRpbmctdG9wOjhweDsKfQogIA==' WHERE ID = '1651134508916514816';

-- 2023-06-14 liangjc 修复portal_sys_dic旧数据字典排序sn_为空的数据
UPDATE portal_sys_dic SET sn_ = ROWNUM WHERE sn_ IS NULL;

-- 2023-06-16 jjx 更新个人信息栏目mobile和数据台栏目的初始化脚本
UPDATE portal_sys_column SET NAME = '个人信息栏目mobile', ALIAS = 'grxxlmmobile', CATALOG = NULL, COL_TYPE = 'HtCustom',
UPDATE portal_sys_column SET NAME = '个人信息栏目mobile', ALIAS = 'grxxlmmobile', CATALOG = NULL, COL_TYPE = 'HtCustom',
                             DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL,
                             COL_URL = NULL,
                             TEMPLATE_HTML = 'ICA8ZGl2IGNsYXNzPSJhbGxIb21lIj4KICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfaGVhZGVycyI+CiAgICAgIDx0ZW1wbGF0ZSB2LWlmPSJkYXRhLnVzZXIucGhvdG8iPgogICAgICAgIDxpbWcKICAgICAgICAgIDpzcmM9ImltZyIKICAgICAgICAgIGFsdD0iIgogICAgICAgICAgd2lkdGg9IjUyIgogICAgICAgICAgaGVpZ2h0PSI1MiIKICAgICAgICAvPgogICAgICA8L3RlbXBsYXRlPgoKICAgICAgPGkgdi1lbHNlIGNsYXNzPSJpY29uLXpoYW5naGFvIiBzdHlsZT0iZm9udC1zaXplOiAzNnB4OyBjb2xvcjogI2ZmZiI+PC9pPgogICAgICA8ZGl2IGNsYXNzPSJ0aXRsZSI+CiAgICAgICAgPGRpdiBjbGFzcz0idGl0bGVfdG9wIj4KICAgICAgICAgIHt7IHRpdGxlIH19CiAgICAgICAgPC9kaXY+CgogICAgICAgIDxkaXYgY2xhc3M9InRpdGxlX2JvdHRvbSI+CiAgICAgICAgICDkvaDlpb3vvIEge3sgZGF0YS51c2VyLmZ1bGxuYW1lIH19LOelneS9oOW8gOW/g+avj+S4gOWkqQogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogICAgPGRpdiBjbGFzcz0iYWxsSG9tZV9jb250ZW50Ij4KICAgICAgPGRpdiB2LWZvcj0iKGl0ZW0sIGkpIG9mIGxpc3REYXRhIiA6a2V5PSJpIiBjbGFzcz0iYWxsSG9tZV9jb250ZW50X2l0ZW0iIEBjbGljaz0nY2xpY2tJdGVtKGl0ZW0pJz4KICAgICAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbV9udW0iPgogICAgICAgICAge3sgaXRlbS5udW0gPj0gOTkgPyAiOTkrIiA6IGl0ZW0ubnVtIH19CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdiBjbGFzcz0iYWxsSG9tZV9jb250ZW50X2l0ZW1fbmFtZSI+CiAgICAgICAgICB7eyBpdGVtLm5hbWUgfX0KICAgICAgICA8L2Rpdj4KICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICA8L2Rpdj4=',
                             IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '',
                             DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"${bpmRunTime}/runtime/instance/v1/getDefaultInfoMap\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"formTable\",\"dataType\":\"\",\"dataMode\":3,\"requestType\":\"GET\"}',
                             NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-05-12 14:07:38',
                             UPDATE_TIME_ = '2023-06-16 10:42:06', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 0, CONTAIN_COL_ = NULL,
                             APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogIGRhdGEoKSB7CiAgICByZXR1cm4gewogICAgICBuYW1lOiAi6LaF57qn566h55CG5ZGYIiwKICAgICAgdGl0bGU6ICLmrKLov47kvb/nlKjlro/lpKlFSVAiLAogICAgICBpbWc6ICIiLAoKICAgICAgbGlzdERhdGE6IFsKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5b6F5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMCIsCiAgICAgICAgICBpZDogIm15VGFrcyIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5bey5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMSIsCiAgICAgICAgICBpZDogIm15QWxyZWFkeSIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5oiR55qE55Sz6K+3IiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVJlcXVlc3QiLAogICAgICAgICAgaWQ6ICJteVJlcXVlc3QiLAogICAgICAgIH0sCiAgICAgICAgewogICAgICAgICAgbmFtZTogIuaIkeeahOi9rOWKniIsCiAgICAgICAgICBudW06IDAsCiAgICAgICAgICB0bzogIi9tYXR0ZXIvbXlUYXNrLzMiLAogICAgICAgICAgaWQ6ICJteUFjY29yZGluZ01hdHRlcnMiLAogICAgICAgIH0sCiAgICAgIF0sCiAgICB9OwogIH0sCiAgbW91bnRlZCgpIHsKICAgIGZvciAobGV0IGl0ZW0gPSAwOyBpdGVtIDwgdGhpcy5saXN0RGF0YS5sZW5ndGg7IGl0ZW0rKykgewogICAgICB0aGlzLmxpc3REYXRhW2l0ZW1dLm51bSA9IHRoaXMuZGF0YVt0aGlzLmxpc3REYXRhW2l0ZW1dLmlkXS5kYXRhVGV4dCB8fCAwOwogICAgfQogIH0sCiAgd2F0Y2g6IHsKICAgIGRhdGE6IHsKICAgICAgaGFuZGxlcih2YWwpIHsKICAgICAgIAogICAgICAgIGlmICh2YWwgJiYgdmFsLnVzZXIgJiYgdmFsLnVzZXIucGhvdG8pIHsKICAgICAgICAKICAgICAgICAgICB0aGlzLmltZyA9ICB0aGlzLiRyZXF1ZXN0Q29uZmlnLmdldEltZ1NyYyh2YWwudXNlci5waG90bykKICAgICAgICB9CiAgICAgIH0sCiAgICBkZWVwOnRydWUgLCBpbW1lZGlhdGU6dHJ1ZSwKICAgIH0sCiAgfSwKICBtZXRob2RzOiB7CiAgICBjbGlja0l0ZW0oaXRlbSkgewogICAgICBjb25zb2xlLmxvZyhpdGVtKTsKICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS50byk7CiAgICB9LAogIH0sCn0=',
                             STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '',
                             TEMPLATE_STYLE_ = 'LmFsbEhvbWUgewoKICB3aWR0aDogY2FsYygxMDAlIC0gMjRweCk7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGp1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2VlbjsKICBoZWlnaHQ6IDExOHB4OwogIGJhY2tncm91bmQ6ICNmZmZmZmY7CiAgYm9yZGVyLXJhZGl1czogMTJweCAxMnB4IDEycHggMTJweDsKICBwYWRkaW5nOiAxNnB4IDEycHg7Cn0KIC5hbGxIb21lX2hlYWRlcnMgewogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBmbGV4LXN0YXJ0OwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0KLmFsbEhvbWUgLmFsbEhvbWVfaGVhZGVycyBpbWcgewogIG1hcmdpbi1yaWdodDogOHB4OwogIGJvcmRlci1yYWRpdXM6IDUwJTsKfQouYWxsSG9tZSAuYWxsSG9tZV9oZWFkZXJzIC50aXRsZSAudGl0bGVfdG9wIAp7ICAgIG1hcmdpbi1ib3R0b206IDdweDsKICBjb2xvcjogIzI2MjYyNjsKICBmb250LXdlaWdodDogODAwOwogIGZvbnQtc2l6ZTogMThweDsKfQoKLmFsbEhvbWUgLmFsbEhvbWVfY29udGVudCAuYWxsSG9tZV9jb250ZW50X2l0ZW1fbnVtewogIG1hcmdpbi10b3A6MTZweDsKaGVpZ2h0OiAzMHB4Owpjb2xvcjogIzI2MjYyNjsKZm9udC13ZWlnaHQ6IDkwMDsKZm9udC1zaXplOiAyNHB4OwptYXJnaW4tYm90dG9tOiA2cHg7dGV4dC1hbGlnbjogY2VudGVyOwp9Ci5hbGxIb21lIC5hbGxIb21lX2hlYWRlcnMgLnRpdGxlIC50aXRsZV9ib3R0b20gewogIGNvbG9yOiAjNTg1ODU4OwogIGZvbnQtd2VpZ2h0OiA0MDA7CiAgZm9udC1zaXplOiAxNHB4Owp9Ci5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnQgLmFsbEhvbWVfY29udGVudF9pdGVtX25hbWV7CiAgCmZvbnQtc2l6ZTogMTFweDsKZm9udC13ZWlnaHQ6IDQwMDsKY29sb3I6ICM4QzhDOEM7Cn0KCi5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnR7CgogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0=' WHERE ALIAS = 'grxxlmmobile';

UPDATE portal_sys_column SET NAME = '数据台', ALIAS = 'sjt', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL,
                               DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '',
                               TEMPLATE_HTML = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=',
                               IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '',
                               DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
                               NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 10:53:55',
                               UPDATE_TIME_ = '2023-06-16 10:43:09', REQUEST_TYPE = NULL, CATALOG_NAME = '',CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1,
                               CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lu75YqhJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgIF0sCiAgICAgIH0KICAgfSwKICAgICBtZXRob2RzOiB7CiAgICAgIGhhbmRsZUNsaWNrKGl0ZW0pIHsKICAgICAgICBpZiAoaXRlbS5wYXRoKSB7CiAgICAgICAgICB0aGlzLiRyb3V0ZXIucHVzaChpdGVtLnBhdGgpCiAgICAgICAgfQogICAgICB9LAogICAgfSwKfQ==',
                               STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9'
                           WHERE ALIAS = 'sjt';


-- 2023-6-20 jjx 更新我的申请国际化内容
update portal_i18n_message set VALUE_ = '流程编号' where ID_ = '1613098875580936192';
update portal_i18n_message set VALUE_ = 'Process number' where ID_ = '1613099384089964544';
update portal_i18n_message set VALUE_ = '流程編號' where ID_ = '1613352041601921024';

-- 2023-6-20 jjx 更新门户配置椒，解决初始化图片加载失败问题
UPDATE portal_sys_layout_manage SET DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbXSwibGlzdCI6W3sidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Liq5Lq65L+h5oGv5qCP55uu566h55CG56uvIiwiYWxpYXMiOiJncnh4bG1nbGQiLCJrZXkiOiIxNjY3NDYwMjE4MDAwXzY3ODI5NDciLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTk4NDIwMDBfOTE4Mzk0OCJ9LHsidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Lu75Yqh6Z2i5p2/566h55CG56uvIiwiYWxpYXMiOiJyd21iZ2xkIiwia2V5IjoiMTY2NzQ2MDIyMjAwMF82NzYzMTIwIiwic25hcHNob3RJZCI6IiJ9XX1dLCJrZXkiOiIxNjY3NDYwMjIxMDAwXzgzMDk3MTcifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuWFs+S6juaIkeS7rOeuoeeQhuerryIsImFsaWFzIjoiZ3l3bWdsZCIsImtleSI6IjE2Njc0NjAyMjUwMDBfMjUzMDM1NiIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ2MDIyMzAwMF8xNzEyMDk0In1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0K' WHERE ID = '0';

UPDATE portal_sys_layout_manage SET  DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbeyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuaVsOaNruWPsCIsImFsaWFzIjoic2p0Iiwia2V5IjoiMTY4NjIxOTY3MTAwMF85NzA4ODU0In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW4uOeUqOWKn+iDvSIsImFsaWFzIjoiY3lnbnNqZCIsImtleSI6IjE2ODYyMTk2ODAwMDBfMTExNjQxNSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLlvoXlip7liIbmnpAiLCJhbGlhcyI6InlkZGRiZngiLCJrZXkiOiIxNjg2MjIwMzU1MDAwXzk0NDA4MTUifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5paw6Ze75Lit5b+DIiwiYWxpYXMiOiJ5ZGR4d3p4Iiwia2V5IjoiMTY4NzE0NTc5MTAwMF85MTkwNDg4In1dLCJsaXN0IjpbXSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE ID = '1';

UPDATE portal_sys_layout_manage SET  DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOlt7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSJ9LHsibmFtZSI6IuW4uOeUqOa1geeoiyIsImFsaWFzIjoidnVlT2Z0ZW5GbG93In0seyJuYW1lIjoi5Lu75Yqh6Z2i5p2/IiwiYWxpYXMiOiJyd21idnVlIn1dLCJjZW50ZXIiOltdLCJyaWdodCI6W3sibmFtZSI6IuaIkeeahOW+heWKniIsImFsaWFzIjoidnVlVG9kbyJ9LHsibmFtZSI6IuaIkeeahOivt+axgiIsImFsaWFzIjoidnVlTXlyZXF1ZXN0In0seyJuYW1lIjoi5pyA5paw6aG555uuIiwiYWxpYXMiOiJ6eHhtdnVlIn1dLCJsYXlvdXRDb2wiOiJ0d28ifSwiYm90dG9tIjpbXSwibW9iaWxlTGlzdCI6W10sImxpc3QiOlt7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sic25hcHNob3RJZCI6IiIsIm5hbWUiOiLova7mkq3lm74iLCJhbGlhcyI6ImxidCIsImtleSI6IjE2ODcxNDEzMzEwMDBfNjM1MDcyNyJ9XX1dLCJrZXkiOiIxNjg3MTQxMzI3MDAwXzI2Nzg4NTIifSx7InR5cGUiOiJ0d28iLCJuYW1lIjoi5LiA6KGM5Lik5YiXIiwiaWNvbiI6Imljb24teWloYW5nbGlhbmdsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoxNiwibGlzdCI6W3sibmFtZSI6IuS4quS6uuS/oeaBr+agj+ebriIsImFsaWFzIjoiZ3J4eGxtIiwia2V5IjoiMTY2NTI5OTk3MDAwMF8xMTQ5NzY0Iiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuW+heWKniIsImFsaWFzIjoiZGIiLCJrZXkiOiIxNjg2MjEyOTIyMDAwXzY0ODMzIiwic25hcHNob3RJZCI6IiJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLmtYHnqIvkuK3lv4MiLCJhbGlhcyI6ImxjengiLCJrZXkiOiIxNjg2MjIwNTM1MDAwXzcxNDM3MDMifSx7Im5hbWUiOiLml6XnqIsiLCJhbGlhcyI6InJjIiwia2V5IjoiMTY4NjIyMDU1NTAwMF81NzI1NTkyIiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuS8muiuriIsImFsaWFzIjoiaHkiLCJrZXkiOiIxNjg2MjEyOTc4MDAwXzgxMjg1MzUiLCJzbmFwc2hvdElkIjoiIn1dfSx7InNwYW4iOjgsImxpc3QiOlt7Im5hbWUiOiLluLjnlKjlip/og70iLCJhbGlhcyI6ImN5Z24iLCJrZXkiOiIxNjg2MjEyOTQwMDAwXzQ3NzMzNDAiLCJzbmFwc2hvdElkIjoiIn0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuS8geS4muaWsOmXuyIsImFsaWFzIjoicXl4dyIsImtleSI6IjE2ODYyMTQ1OTEwMDBfNDQ2NDg4OSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLluLjnlKjmtYHnqIsiLCJhbGlhcyI6ImN5bGMiLCJrZXkiOiIxNjg2MjIwMzk5MDAwXzQwMDk4NTIifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5Liq5Lq65LqL6aG5IiwiYWxpYXMiOiJncnN4Iiwia2V5IjoiMTY4NjIyMDU0NzAwMF81ODgxMzk2In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW+heWKnuWIhuaekCIsImFsaWFzIjoiZGJmeCIsImtleSI6IjE2ODYyMTI5NTAwMDBfOTQ1ODUxNiJ9XX1dLCJrZXkiOiIxNjY1Mjk5MjA4MDAwXzYwNjA0MjEifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuS7u+WKoemdouadv+W6lOeUqOerryIsImFsaWFzIjoicndtYnl5ZCIsImtleSI6IjE2Njc0NTkyNjQwMDBfMTE5NTkyNyIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ1OTI1OTAwMF81NzEyMTgyIn0seyJ0eXBlIjoib25lIiwibmFtZSI6IuS4gOihjOS4gOWIlyIsImljb24iOiJpY29uLXlpaGFuZ3lpbGllIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d20iLCJrZXkiOiIxNjY3NDU5MjcwMDAwXzYwMjUwODkiLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTkyNjcwMDBfMjM3NDY4MSJ9XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE ID = '2';

-- 2023-6-25 jjx 更新维度菜单接口
UPDATE portal_sys_method SET REQUEST_URL_ = '/api/demension/v1/dem/deleteDemByIds' WHERE ALIAS_ = 'uc_demension_del';

-- 2023-6-26 liangjc 默认平台的给人事管理员和系统管理员授权
INSERT INTO portal_sys_method(id_, ALIAS_, NAME_, MENU_ALIAS_, REQUEST_URL_, PATH_, TENANT_ID_) select '1666702693495816192', 'updateUserPsw', '修改密码接口权限', ALIAS_, '/api/user/v1/user/updateUserPsw', PATH_, TENANT_ID_ from portal_sys_menu where ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(id_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_)  select '1666702693495816192', 'rsgly',  ALIAS_,  '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(ID_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_)  select '1666702693495816193', 'xtgly',  ALIAS_,  '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';

-- 2023-7-3 jjx 修改字段长度
ALTER TABLE PORTAL_SYS_TAG MODIFY KEY_ VARCHAR(128);