zdh_web
zdh_web copied to clipboard
大数据采集,抽取平台,zdh_web是zdh系列服务的可视化管理平台,包含数据采集,调度,权限,审批流,私域营销等模块
Table of Contents generated with DocToc
- READ MORE
- æ°æ®éé,å¤ç,çæ§,è°åº¦,管çä¸ä½åå¹³å°
- å¼æº/éæºçæ¬
- ä¸è½½ç¼è¯å
- å¨çº¿é¢è§
- æ示
- ç¹è²
- 使ç¨åºæ¯
- 主è¦åè½
- ç¨å°çææ¯ä½ç³»
- ä¸è½½ä¿®æ¹åºç¡é ç½®
- åºç¡ç¯å¢
- æºç èªå®ä¹æå
- è¿è¡
- FAQ
- åè½å¾
- çæ¬æ´æ°è¯´æ
- 4.7.15è¿ç§»4.7.16
- 4.7.16è¿ç§»4.7.17
- 4.7.17è¿ç§»4.7.18
- 4.7.18è¿ç§»5.0.0
- æªå®æçåè½
- æ¯æçæ°æ®æº
- æ¯æçè°åº¦å¯¹è±¡
- æ¯æçè°åº¦å¨æ¨¡å¼
- æ¯æè°åº¦å¨ææ¥æåæ°
- çæ¬è®¡å
- 个人èç³»æ¹å¼
- çé¢é¢è§
READ MORE
English description
æ°æ®éé,å¤ç,çæ§,è°åº¦,管çä¸ä½åå¹³å°
å æ¬é¡¹ç®æ²¡æå
¶ä»ææ¡£,请使ç¨è
åå¼åè
详ç»é
读å®æ¬readme ææ¡£,åæä¼ä»¥å客çå½¢å¼å¯¹æ¬é¡¹ç®è¿è¡è¯¦ç»åè½è¯´æ
å客ç®å½å°åï¼ https://blog.csdn.net/zhaoyachao123/article/details/113913947
欢è¿ä½ 对æ¬é¡¹ç®æåºç¸å ³issue
æ¬å¹³å°ä¸»è¦ç®ç
- é«æçè¿è¡æ°æ®éé,æ建èªå·±ç大æ°æ®å¹³å°
- ç»ä¸æ°æ®ç®¡ç,对æ°æ®è¿è¡é«æåæå对å¤è¾åº
- éè¿å·¥å ·å®æ大é¨åå·¥ä½,åå°å¼åè çå·¥ä½é
- éä½ä½¿ç¨è æ å,éè¿æææ½å®ç°æ°æ®çéé(ä»»å¡ä¾èµå ³ç³»ç±èªå¸¦è°åº¦å®æ-ä¼å¿)
- æ¬å¹³å°çåè¡·åç®çå°½éåå°å¼åè çå·¥ä½éåéä½æ°æ®å¼åè ç使ç¨é¨æ§
å¼æº/éæºçæ¬
- 4.7.10以åä¹åççæ¬-代ç å¼æºä¸å è´¹
- 4.7.11以åä¹åççæ¬-æä¾ç¼è¯å¥½çå å 费使ç¨,ä½æ¯ä¸å¼æ¾æºç
ä¸è½½ç¼è¯å
-
ç¼è¯å ä¸è½½å°å(åªæä¾4.7.11ä¹åççæ¬,å 4.7.11ä¹åä¸æä¾æºç ä¸è½½)ï¼
-
æ§è¡ç¼è¯å¥½çå éè¦æåå®è£ mysql8,redis
-
åå²çæ¬(>4.7.11)åªæä¾æè¿2个çæ¬ç®å½ä¸è½½,ä¸è½½åå²çæ¬,ç¹å»ä¸æ¹ä¸è½½è¿æ¥,ä¿®æ¹é¾æ¥ä¸ççæ¬å·,å¯ä¸è½½åå²çæ¬ å»ºè®®ä½¿ç¨ææ°çæ¬(åè½æ´å¤)
-
4.7.18çæ¬å ¨é¨éç¨maven管ç,并éæquartzæºç ,4.7.18ä¸å¯åä¹åä»»ä½åå²çæ¬éç¨
-
4.7.18为4.xæåä¸ä¸ªçæ¬,5.xçæ¬ä¼éæææ代ç ,èª2022-02-06~2022-06-01ä¸è¿è¡æ°åè½å¼å,æ¤æ®µæ¶é´ä¼å®å使ç¨ææ¡£
-
4.7.18
-
5.0.0
-
5.0.1
-
å¦æé¾æ¥å¤±æ,å¯éè¿é®ä»¶æ¹å¼(è§åºé¨)éç¥ä½è ,ä½è ä¼éè¿é®ä»¶åéç¼è¯å ,ä¹å¯ç»éZDHé¢è§é¡µé¢ä¸è½½
å¨çº¿é¢è§
ç¨æ·åï¼zyc
å¯ç ï¼123456
æå¡å¨èµæºæé,çé¢åªä¾é¢è§,ä¸å
å«æ°æ®å¤çé¨å,è°¢ç å们æä¸çæ
æ示
zdh å2é¨å,å端é
ç½®+å端æ°æ®ETLå¤ç,æ¤é¨ååªå
å«å端é
ç½®
å端æ°æ®etl 请åè§é¡¹ç® https://github.com/zhaoyachao/zdh_server.git
zdh_web åzdh_server ä¿æåæ¥ å¤§çæ¬ä¼åæ¥å
¼å®¹ å¦æzdh_web éæ©çæ¬1.0 ,zdh_server 使ç¨1.x é½å¯å
¼å®¹
äºæ¬¡å¼ååå¦ è¯·éæ©dev åæ¯,dev åæ¯åªææµè¯éè¿æä¼å并master,æ以master å¯è½ä¸æ¯ææ°ç,ä½æ¯å¯ä¿è¯å¯ç¨æ§
ç¹è²
å¼ç®±å³ç¨
æ¯æå¤æ°æ®æº
é«æ§è½æ°æ®éé
åç¬çè°åº¦å¨,è°åº¦ä¹å¯åä¸æ¹è°åº¦å¨å¯¹æ¥airflow,azkaban
äºæ¬¡å¼å
使ç¨åºæ¯
- æ°æ®éé(æ¬å°ä¸ä¼ æ°æ®,hdfs,jdbc,http,cassandra,mongodb,redis,kafka,hbase,es,sftp,hive)
- æ°æ®å å¯
- æ°æ®è½¬æ¢,æ°æ®ç¦»çº¿åæ¥,å®æ¶æ°æ®åæ¥
- æ°æ®è¿ç§»
- è´¨éæ£æµ
- å æ°æ®,ææ 管ç
- droolsçµæ´»å¨æçæ°æ®æ¸ æ´
主è¦åè½
zdh 主è¦çä½ç¨ æ¯ä»hdfs,hive,jdbc,http-jsonæ¥å£ çæ°æ®æºæåæ°æ®,并转åå°hdfs,hive,jdbcçå ¶ä»æ°æ®æº æ¯æé群å¼é¨ç½²
- æ¯æsqlæ åå½æ°
- æ¯æçé¢éæ©é ç½®
- æ¯æå¿«éå¤å¶å·²æä»»å¡
- æ¯æå¤é¨è°åº¦å·¥å ·(éè¦ä¿®æ¹,æ°å¢ç¹å®æ¥å£)
- å¼¹æ§æ©å±(å¯åæº,å¯é群)
- æ¯æ客æ·çº§æé
- ç®åæç¨æ¯æäºæ¬¡å¼å
- èªå¸¦ç®åè°åº¦å·¥å ·,å¯é ç½®å®æ¶ä»»å¡,æ¶é´åºåä»»å¡,设å®æ¬¡æ°
- è°åº¦ä¾èµ
- SQLæ°æ®ä»åºæ°æ®å¤ç(åä¸æ°ä»)
- è´¨éæ£æµ,å对åºæ¥å
- æ¯æSHELL å½ä»¤,SHELL èæ¬,JDBCæ¥è¯¢è°åº¦,HDFSæ¥è¯¢è°åº¦
- æ¯ææ¬å°ä¸ä¼ ,ä¸è½½æ件
- æ¯æå¤æºETL
- ä»»å¡çæ§
- çµæ´»å¨ædroolsè§åæ¸ ç
ç¨å°çææ¯ä½ç³»
å端ï¼Bootstrap
å端ï¼Springboot+shiro+redis+mybatis
æ°æ®ETLå¼æ:Spark(hadoop,hive å¯éæ©é¨ç½²)
ä¸è½½ä¿®æ¹åºç¡é ç½®
æå¼resources/application-dev.properties
1 ä¿®æ¹æå¡å¨ç«¯å£é»è®¤8081
2 ä¿®æ¹æ°æ®æºè¿æ¥(é»è®¤æ¯æmysql8),å¤é¨æ°æ®åºå¿
é¡»å¼å
¥
3 ä¿®æ¹redisé
ç½®
4 ä¿®æ¹application-*é
ç½®æ件ä¸myid(å¤ä¸ªé群ä¾æ¬¡1,2,3,...)
å建éè¦çæ°æ®åºé
ç½®
1 æ§è¡sqlèæ¬db.sql
ä¾èµ
1 å¿
é¡»æåå®è£
redis
åºç¡ç¯å¢
1 æ§è¡ç¼è¯å¥½çå
éè¦æåå®è£
mysql8,redis
2 jdk1.8
æºç èªå®ä¹æå
æ¸
çå½ä»¤ mvn clean
æå
å½ä»¤ mvn package -Dmaven.test.skip=true
è¿è¡
4.7.13 ä¹å
å¨target ç®å½ä¸æ¾å°zdh_web.jar
æ§è¡ java -Dfile.encoding=utf-8 -jar zdh_web.jar
4.7.13åä¹å
è¿å
¥å¨xxx-RELEASE ç®å½ä¸
æ§è¡ java -jar -Dfile.encoding=utf-8 -Dloader.path=libs/,conf zdh_web.jar
FAQ
-
sqlç»ææ¥é éå°sql ç»ææ¥é,å¯ç´æ¥å¨resourceç®å½ä¸æ¾db.sql æ件对æ¯æ¯å¦å¢å äºå段,db.sql æ件ä¼ä½¿ç¨alter æ¹å¼å¢å å段 quartz ç¸å ³çè¡¨å¿ é¡»å¤§å
-
æ¥å¿çº§å«ä¿®æ¹ ä¿®æ¹æ¥å¿æ件logback ç¸å ³ç级å³å¯
-
è°åº¦ä¸²è¡å¹¶è¡æ¨¡å¼ 串è¡æ¨¡å¼:ä¼å¤æä¸æ¬¡ä»»å¡è¿è¡ç¶æ 并è¡æ¨¡å¼:ä¸å¤æä¸æ¬¡ä»»å¡ç¶æ,æ¶é´ä¼èªå¨çæ
-
æ°æ®è¡¨ç»æ以src/main/resources/db.sql 为å
-
æä¸æ¯æ读åkerberos 认è¯çhadoop,hive,hbase æå¡,é¢è®¡å¨5.x çæ¬å®ç°kerberos 认è¯
åè½å¾
çæ¬æ´æ°è¯´æ
-
v1.0 æ¯æ常ç¨æ°æ®jdbc,hive,kafka,http,flume,redis,es,kudu,mongodb,hbase,cassandra,hdfs(csv,json,orc,parquet,xml,excel...),æ¬å°ä¸ä¼ æ°æ®(csv)
-
v1.0 è°åº¦æ¯æä»»å¡ä¾èµç
-
v1.1 æ¯æclickhouse-jdbc
-
v1.2 æ¯æå¤é¨jar etlä»»å¡(ä»»å¡ç¶æéè¦å¤é¨jar èªå·±è·è¸ª)
-
v1.3 æ¯ædrools æ°æ®æ¸ ç
-
v1.4 æ¯ægreenplum-jdbc
-
v2.0 å é¤å¤é¨jar ä»»å¡ä½¿ç¨ssh ä»»å¡ä»£æ¿,sshä»»å¡åè½æ°å¢
-
v2.0 drools ä»»å¡å¢å æ¯æå¤æºåsqlä»»å¡
-
v2.0 clickhouse,hive sparkæ°æ®æºä¼å
-
v2.0 spark sftpæ°æ®æ¡æ¶æ¹å¨,å¢å sftp excel åå¤åé符æ¯æ
-
v2.0 è°åº¦éè¯æºå¶ä¼å,å¢å èç¹å¤±è´¥éååè½(ä»»å¡éå¯)
-
v2.0 å¢å è°åº¦åç¬åè¦æºå¶
-
v2.0 server 模åé«å¯ç¨æºå¶æ¹å¨ä¸ºè´è½½é«å¯ç¨
-
v2.0 hbase,drools jarå²çªbug ä¿®å¤
-
v2.0 æ¯æssh ä»»å¡éæèæ¬,å¨æèæ¬
-
v2.0 kafka,flumeå®æ¶æ°æ®æºå é¤å¿ 须使ç¨jdbcè¾åºæºéå¶
-
v2.0 ä¿®å¤spark çæ§bug,移å¨sparkçæ§å°æ»çæ§
-
v2.1 zdh_web æ·»å redis cluster æ¯æ
-
v2.1 å¢å jdbcæ¯æpresto,mariadb,memsql,å为dws,é¿éAnalyticDB,kylin,gbase,kingbase,redshift
-
v2.2 è°åº¦æºå¶å¢å ack,æ ææ é转移
-
v2.2 ä¼åææå端çé¢,å¢å ç¶æé«äº®
-
v2.2 sql ç¼è¾æ¯æé«äº®æ¾ç¤º
-
v2.2 æå¨æ§è¡è°åº¦æ¹ä¸ºå¼æ¥æ§è¡
-
v2.2 ä»»å¡æ¥å¿è·åæ¹å¼æ¹åï¼æ¶é´è·åæ¹ä¸ºæ è¯ç¬¦+æ¶é´è·åï¼
-
v3.0 å端çé¢ç¶æå¯è§åä¼å
-
v3.0 å»é¤task_logs ä»»å¡æ¥å¿è¡¨,å¢å task_log_instance 表ä½ä¸ºæ¿æ¢(大åå¨2.0 çæ¬å3.0 å®å ¨ä¸å ¼å®¹)
-
v3.0 ä¿®å¤faviconæ¾ç¤ºbug
-
v3.0 å¢å è°åº¦å¨ç«¯çæ é转移
-
v3.0 çæ§çé¢å¢å æå¨éè¯åè½
-
v3.0 æåquartz_job_info è°åº¦ä»»å¡è¡¨,æ¯æ¬¡æ§è¡è°åº¦ä»»å¡ä¼çæä¸ä¸ªå½åç¶æçå®ä¾è¡¨(éè¯,æ é转移,ackçé½åºäºå®ä¾è¡¨å®æé»è¾æä½)
-
v3.0 å¢å åä»»å¡å¹¶è¡å¤çæºå¶æ¥å£(åªçäºå®ç°æ¥å£,并æªåå ·ä½å®ç°,æä¸æ¯æåä»»å¡å¹¶è¡)
-
v3.0 zdh_web项ç®å¢å è°åº¦å¨id(主è¦ç¨åæ é转移,å¤æä»»å¡æ¯å¦æ¯æ é转移触å)
-
v3.0 æå¨æ§è¡å é¤éç½®åè½(ä¼çæä¸ä¸ªå®ä¾,æ以å»æéç½®åè½)
-
v3.0 æå¨æ§è¡,è°åº¦æ§è¡é½ä¼å é¤ä¹åçå®ä¾ä¾èµ(æå¨æ§è¡å,å¿ é¡»æå¨è®¾ç½®æ£ç¡®çè°åº¦æ¶é´)
-
v3.0 å¢å æ°æ®ééå端任å¡ææ»åè½
-
v3.0 å¢å è¶ æ¶åè¦ä»»å¡-åªåè¦ä¸ææ»
-
v3.0 hbase å é¤jerseyç¸å ³jar,解å³jarå²çª
-
v3.0 æ¹éå é¤å¢å 确认å é¤å¼¹æ¡
-
v3.0 ä¿®æ¹spark ä»»å¡jobç»è¯´ææ ¼å¼
-
v3.1 ä»»å¡ä¾èµæ£æ¥å®ç°æ¹å¼ä¿®æ¹
-
v3.1 å¢å cron 表达å¼çæ页é¢
-
v3.1 æ件åå¢å å¨æ设置(æ ¹æ®æ¶é´çæç¹å®è§åæ件å)
-
v3.1 å¯å¨æ¶åºç¡åæ°æ ¡éª
-
v3.1 quartz ä»»å¡ä¼å 级设å®
-
v3.1 å¢å æ¯æquartzæ¶é´è§¦å(串è¡+并è¡æ¹å¼é½æ¯æ)
-
v3.1 æ°å¢dag å·¥å ·ç±»(计å3.2çæ¬æ¯ædagè°åº¦)
-
v4.0 å®ç°è°åº¦æææ½
-
v4.0 éæ°å®ç°ä»»å¡åç°æºå¶
-
v4.0 å¢å ä»»å¡ç»,åä»»å¡æ¦å¿µå®ç°ç»ä»»å¡
-
v4.0 å®ç°dagè°åº¦
-
v4.0 å®ç°è°åº¦æµç¨å¾
-
v4.0 éæ°å®ç°ä»»å¡ç±»å(4.xä¹åçæ¬ä¸å ¼å®¹)
-
v4.0 å¢å greenplum-sparkè¿æ¥å¨
-
v4.0 å ¨æ°é»è¾,å¼å¾ä¸è¯
-
v4.1 ä¿®å¤4.0 è°åº¦éè¯bug
-
v4.1 ä¿®å¤4.0 è°åº¦çé¢bug
-
v4.1 éæ°å®ç°æ¶é´éåæºå¶,è°åº¦æ§è½æé«
-
v4.1 ä¿®æ¹çæ§çé¢å»é¤ç»ä»»å¡çæ§æé®æ·»å åä»»å¡çæ§çé¢
-
v4.2 ä¿®å¤4.1bug
-
v4.2 sqlèæ¬å¢å ä¸æ说æ
-
v4.3 å¢å é¨ååä»»å¡éè¯æºå¶
-
v4.3 å¢å æå¨æ§è¡é¨ååä»»å¡æºå¶
-
v4.3 å¢å åä»»å¡è¿è¡æ¶ä¾èµå¾å±ç¤º
-
v4.3 ä»»å¡ç¶æå¢å è·³è¿ç¶æ
-
v4.3 ä¼ålogbackæ¥å¿é ç½®
-
v4.3 ä¿®å¤æå¨éè¯æ°çbug
-
v4.3 å é¤zookeeperå·¥å ·å
-
v4.3 å é¤[éå¤æ§è¡]è°åº¦ä»»å¡æ¨¡å¼
-
v4.3 å é¤mqé 置信æ¯
-
v4.3 å é¤nettyå·¥å ·å
-
v4.4 ä¼åå端çé¢,æ¥å¿çé¢æ¯æ¬¡æå¼æ°æ ç¾é¡µ
-
v4.4 ä¼åè¶ æ¶åè¦
-
v4.4 ä¿®å¤SSHæªç»æå¼å¸¸
-
v4.4 å é¤å¤ä½çdebug
-
v4.4 è°æ´quartz延è¿å¯å¨60s->20s
-
v4.4 å é¤çº¿ç¨æ± (å½±åSSHä»»å¡-å¾ ä¼å)
-
v4.5 ä¿®å¤æ£æ¥ä»»å¡ç»æ¶ç©ºç±»åå¼å¸¸
-
v4.6 ä¼åæ¥å¿è®°å½çé¢,å¢å æ¥å¿ä¸è½½,ä¼åæ¥å¿å±ç¤ºé£æ ¼
-
v4.6 è¡¥å tidbä»»å¡è¯´æ
-
v4.6 å¢å èªå®ä¹æ¶é´åæ°(é«çº§ä½¿ç¨)
-
v4.6 ä¼åè°åº¦ææ½é»è¾,ç®åæ°æ®ç»æ
-
v4.6 ä¿®æ¹jinjava çæ¬ä¸º2.5.6
-
v4.6 å¢å è°åº¦ä»»å¡ç¦ç¨åè½
-
v4.6 å¢å è°åº¦ä»»å¡ç»æ¨¡å
-
v4.6 å¢å æé管çåè½,åè½èåæé
-
v4.6 å¢å å¤é¨jdbcä»»å¡ä¾èµæ£æ¥
-
v4.7 ä¿®å¤4.6jdbcä¾èµæ£æ¥ææ»é®é¢
-
v4.7 ä¿®å¤æ§è¡å¨æ»äº¡æ£æµä¸å°é®é¢
-
v4.7 ä¿®å¤çæ§ä¸»çé¢ææ»ä»»å¡ç»é®é¢
-
v4.7 计åæ¯ææ»å¨å级(ç®åæ»å¨å级åªå®æäºä¸é®é¨ç½²åæ©å®¹åè½,æªå®ç°å¨æ管çwebèç¹ä¸ä¸çº¿)
-
v4.7 å级jsch çæ¬ä¸º0.1.55
-
v4.7 ä¼åä»»å¡çé¢æ¨¡ç³æ¥è¯¢
-
v4.7 ä¼åæ¥å¿çé¢æ¶é´
-
v4.7 ä¼åshellèæ¬ç¹æ®ç¬¦å·
-
v4.7.1 æ°å¢ä¸é®é¨ç½²åä¼å
-
v4.7.2 ä¿®å¤jsä¸å¤ä½alert
-
v4.7.2 ä¿®å¤jdbcä»»å¡ä¾èµæ¶æ æbug
-
v4.7.3 å¢å ä»»å¡è§¦å模å¼(ä¸æ¸¸æå触å?ä¸æ¸¸å¤±è´¥è§¦å)
-
v4.7.3 task_log_instance å¢å depend_level å段(ä½ç¨å¤æä»»å¡è§¦åç¶æ)
-
v4.7.3 ä¼åä»»å¡ç»çæ§çé¢è¿åº¦ä¸æ注éä¿¡æ¯
-
v4.7.4 ä¿®å¤ä»»å¡ç»ææ»æ¶é¨åä»»å¡ä¾æ§æ¾ç¤ºè¿è¡ä¸bug
-
v4.7.5 å¢å ééä»»å¡æå®é群æ§è¡(ä» æ¯æetlééä»»å¡,对jdbc,shell,groupçæ£æ¥ä¾èµä»»å¡æ æ¤åè½,åæ¢è°åº¦é群æ´æ¹ä¾¿å¦yarn)
-
v4.7.6 æ 大修æ¹,ä¼ålogback é ç½®æ件å¯ç¨æ»å¨æ¥å¿
-
v4.7.7 ä¼åjdbcä»»å¡ç¦ç¨æé®
-
v4.7.7 å¢å jdbcä¾èµä»»å¡åå ¥åè½(ä¹åçæ¬åªæ¯ææ¥è¯¢ä¸æ¯æåå ¥-ææ å®ææ è¯åè½è¡å)
-
v4.7.8 å¢å ç»ä½è æbug(èç³»ä½è )åè½
-
v4.7.9 åºå¼JdbcJob,HdfsJob,以任å¡æµä¾èµæ£æ¥æ¨¡åå®ç°ä¾èµæ£æ¥
-
v4.7.9 åºå¼InstanceStatus,ç»ä¸ä½¿ç¨JobStatus 管çä»»å¡ç¶æ
-
v4.7.9 ä¼åjinjava åæ°,ç»ä¸æ¶é´åæ°
-
v4.7.9 ä¼åshell job æ¶é´åæ°,å¢å å®æ¶æ¥å¿å±ç¤º
-
v4.7.10 ä¼åæ°æ®è¡¨å段注é
-
v4.7.10 ä¼åçæserver端任å¡æ¥å¿
-
v4.7.10 å端å¢å æ°æ®æºå¯ç©ºåè½
-
v4.7.10 æ°å¢æ°æ®æºé»è¾å é¤åè½(æ°æ®æºè¡¨ç»æåå¨)
-
v4.7.11 ä¼åspark-jdbcæ§è½å¢å æåè¿æ»¤åè½
-
v4.7.11 å¢å 请æ±çæ¬å·url(http://xxx:port/version)
-
v4.7.11 è°åº¦çé¢ä¼å-å¢å é»è®¤å¼,åä¸å¯ä¸ºç©ºæ ¡éª
-
v4.7.11 å¢å hdfsè°åº¦ç»ä»¶è§£å³æ£æ¥hdfsæ件æ¯å¦åå¨
-
v4.7.11 ä¼åéç¥çé¢,æ¾ç¤ºéç¥ä¿¡æ¯
-
v4.7.11 ä¼åææ»ä»»å¡æ¶å¼å¸¸
-
v4.7.11 å¢å æ°æ®åå¸,ç³è¯·,审æ¹åè½
-
v4.7.11 æ°å¢ç³è¯·æºETL(使ç¨ä»äººåå¸çæ°æ®ä½ä¸ºè¾å ¥æ°æ®æº)
-
v4.7.11 å¢å æ°ç表ç»æapply_info,etl_apply_task_info
-
v4.7.11 ä¼å串è¡ä½ä¸ç»ææ»åè½,ä¸æ¸¸ææ»,å对åºä¸æ¸¸ä»»å¡ç´æ¥ææ»
-
v4.7.11 å¢å åå¸æ°æ®-å¢å æ¹æ¥åè½
-
v4.7.11 å¢å quartz并ååæ°é ç½®
-
v4.7.11 å¼å¯è°åº¦æ¶è¶ è¿æ大è°åº¦æ¶é´å¼¹æ¡æ示
-
v4.7.11 ä½ä¸ç»ä¸ºç©ºæ¶,ä¼åä½ä¸ç»ç»æç¶æ
-
v4.7.11 åè¦ä½ä¸éå¶åªæ£æ¥æè¿2天å ç失败ä½ä¸
-
v4.7.11 ä¼åshellèæ¬å端ç¼è¾å¨
-
v4.7.11 ä¿®å¤è°åº¦èªå®ä¹è¡¨è¾¾å¼å¤©çº§è¡¨è¾¾å¼
-
v4.7.11 ä¿®å¤ç©ºä½ä¸ç»ææ»æ¶ç¶ææªæ¹åbug
-
v4.7.11 ä¿®å¤shellä»»å¡pingå½ä»¤ææ»å¼å¸¸
-
v4.7.11 æå¨æ§è¡ä»»å¡,éè¯ä»»å¡ä¸éå¶è°åº¦æ¥ææ£æ¥
-
v4.7.11 db.sqlèæ¬å¢å èå表,æé表æ°æ®
-
v4.7.11 task_log_instance,task_group_log_instance å¢å è°åº¦æ¥æºå段æ è¯ä»»å¡è§¦åæ¥æº
-
v4.7.11 æ°æ®æºé»è¾å é¤ä¿®å¤æ´æ°æ¶å¼å¸¸bug
-
v4.7.11 ä¼åæ¥å¿çé¢ç¶æå¤è§
-
v4.7.11 å¢å etlä»»å¡é ç½®æ¶,æ°æ®å¾æ,ååº,å并å°æ件,åå ¥æ¨¡å¼åæ°
-
v4.7.11 ä¿®å¤etlä»»å¡è¡¨è¾¾å¼å表å¤æ¬¡å¢å é®é¢(å端ä¼å)
-
v4.7.11 ä¿®å¤shellä»»å¡è°åº¦æ»æèªå¨éè¯
-
v4.7.11 åä»»å¡çé¢æ¾ç¤ºjob_id
-
v4.7.11 zdh_serverå¢å hdfsè¾åºæ°æ®æºzkè·¯å¾è§£æåè½
-
v4.7.11 ä¿®æ¹å¤æºä»»å¡ä¸´æ¶è¡¨å®ç°
-
v4.7.11 ä¿®å¤å¤æºä»»å¡å端bug(表头信æ¯æ´æ°ä¸æå)
-
v4.7.11 ä¼ååä»»å¡çé¢ç¶ææ¾ç¤º
-
v4.7.11 ä¼åæéçé¢ç»ä¸è¿åå¼æ°æ®ç»æ
-
v4.7.11 ä¼åetlä»»å¡çé¢ç»ä¸è¿åå¼æ°æ®ç»æ
-
v4.7.11 ä¼ååè¦æ¨¡å-å¢å 失败åè¦,å®æéç¥,è¶ æ¶éç¥
-
v4.7.11 å¹³å°æ¶æ¯éç¥éæ,ç»ä¸å¢å æ¶æ¯ç®¡ç模å
-
v4.7.11 ä¿®å¤shiro è·åç¨æ·ä¿¡æ¯å¼å¸¸
-
v4.7.11 ç»ä¸è¿åæ°æ®ç»æ,并éæcontrollerå±
-
v4.7.11 å¢å FLINKéé模å
-
v4.7.11 ä¼åç»é模å-å¢å éªè¯ç shiroæ´å
-
v4.7.11 FLINKå¢å checkpointæºå¶
-
v4.7.11 éæhtmlå¼å ¥é¡¹ç®æ ¹ç®å½
-
v4.7.11 å级springbootçæ¬1.5.7è³1.5.22
-
v4.7.11 éæç»é页é¢,注å页é¢
-
v4.7.11 å¢å è´¦æ·ç¦ç¨å¯ç¨åè½
-
v4.7.11 åºå¼æ§çæé模å-æ¹å¨ä¸º ç¨æ·->è§è²->èµæº 模å模å¼
-
v4.7.11 è°åº¦ä»»å¡é ç½®é¦é¡µå¢å cron表达å¼çæé¾æ¥
-
v4.7.11 é¦é¡µå»é¤è§è²æ¾ç¤º,使ç¨ç¾åæ¿æ¢
-
v4.7.11 èå管ç-æ°å¢èµæºç±»å,æ¯ææ¥å£æé
-
v4.7.11 éæ审æ¹æµ-æ¯æå¤äººå®¡æ¹,å é¤æ§çæ°æ®å®¡æ¹æ¨¡å
-
v4.7.11 ä¿®å¤shiro æ¥è¯¢ç¨æ·ä¿¡æ¯æ¶æ æbug
-
v4.7.11 å¢å æåèµ·çæµç¨,æµç¨è¿åº¦ä¿¡æ¯
-
v4.7.11 æ°æ®ç³è¯·ä½¿ç¨å®¡æ¹æµéæ
-
v4.7.11 ä¿®å¤éç¥ä¿¡æ¯-éå¤æ¾ç¤ºé®é¢(å é¤é¡µé¢ä¸æé¢æ¿)
-
v4.7.11 ç¦ç¨shiroææç¼å
-
v4.7.11 æ´æ°åå¸æ°æ®æ¶,éç¥ä¸æ¸¸å ·ä½ä¿®æ¹å 容
-
v4.7.11 ä¿®æ¹èåç±»å,å¢å å 置页é¢ç±»å
-
v4.7.11 ç»ä¸controllerå±æ å°è§å
-
v4.7.11 å¼å¯æ¥å£æééªè¯
-
v4.7.11 flinkç¶æçæ§åæ´æ°
-
v4.7.11 ä¿®å¤server_ackæºå¶
-
v4.7.11 ä¿®å¤éè¯-æ¾ç¤ºç¦ç¨ä»»å¡bug
-
v4.7.11 webæ¯æflinkå¢å ææ»,éè¯æºå¶
-
v4.7.11 éè¯æ¶,è³å°æä¸ä¸ªåä»»å¡,å¦åæ æ³éè¯
-
v4.7.11 flink端å¤å®ä»»å¡ç¶ææ£æ¥
-
v4.7.12 ä¼åquartz è¶ å¤§éä»»å¡å¼èµ·çéå¤æ§è¡é®é¢
-
v4.7.12 å¢å ãjdbcå¼æETLã,使ç¨presto,clickhouseçjdbcå¼æETLæ¶,å¯åç¬ä½¿ç¨zdh_webå®æ,ä¸éæzdh_server
-
v4.7.12 åå²ãjdbcä¾èµãä¼å
-
v4.7.13 springboot jar å离
-
v4.7.14 å¢å ãdataxå¼æã,éè¿è°åº¦å®ç°å¯è§åé ç½®
-
v4.7.14 è°åº¦é¡µé¢åè¦ç¨æ·è´¦æ·ç±è¾å ¥æ¡æ¹ä¸ºå¤éä¸ææ¡(模ç³å¹é )
-
v4.7.14 ä¼åä»»å¡ç»æ´æ°æ¶é´,ä»»å¡æ´æ°æ¶é´
-
v4.7.14 ä¼åmybatis-generatoræ件é ç½®,å¯ç¨èªå¨çæ
-
v4.7.14 ä¿®å¤æ°æ®æºæ°å¢æéé®é¢
-
v4.7.15 ä¿®å¤æ°æ®æºå段è·åæé,ä¸ä¼ æ件æé
-
v4.7.15 åç¬æåæ°æ®è´¨éæ£æµæ¨¡å,æ°å¢æ°æ®è´¨éè§å
-
v4.7.15 ä¿®å¤v4.7.12è³4.7.14ä¸åéä»»å¡æ¨¡åå°server(spark)失败bug
-
v4.7.15 ä¼åå è½½éç¥ææ¯10ç§æ¹ä¸ºæ¯60ç§å è½½
-
v4.7.16 æ£æ¥æ¯å¦åå¨log4j2æ¼æ´(æ )
-
v4.7.16 ä¼åè°åº¦æ°å¢é¡µé¢,å¢å åè¦è´¦å·ä¸å¯ä¸ºç©ºéå¶
-
v4.7.16 å¢å è¡æºåæ(ç®ååªæ¯æ1å±ä¸ä¸æ¸¸å ³ç³»-å¾ ä¼å)
-
v4.7.16 ä¿®å¤task_group_logs_deleteæé
-
v4.7.16 æ°å¢æédispatch_task_execute_time
-
v4.7.16 æ°å¢è°åº¦æ¶é´é¢æ¥ç
-
v4.7.16 å¢å æ°æ®æºé»è¾å é¤
-
v4.7.16 èåèµæºé¡µé¢,è§è²é ç½®é¡µé¢ å¢å æ æ¥è¯¢åè½
-
v4.7.16 è°åº¦é¡µé¢-å¤å¶åè½bugä¿®å¤
-
v4.7.16 æ°æ®æºå¢å æ´æ°å段
-
v4.7.16 å é¤åå²æ°æ®æºé»è¾å±,使ç¨Daoå±ä»£æ¿
-
v4.7.16 ä¿®å¤ssh页é¢å ³éæ æbug
-
v4.7.16 åæºETL,å¤æºETL,SSH,SQL,FLINK_SQL,JDBC_SQL,ç³è¯·æºETL å¢å é»è¾å é¤åæ´æ°æ¶é´
-
v4.7.17 æ¥å£æ æé-å¢å ZDHåè¦
-
v4.7.17 ä¿®å¤every_day_noticeæ¥å£,æ æ°æ®å¼å¸¸bug
-
v4.7.17 ä¿®å¤æä½æ¥å¿åå ¥å符个æ°
-
v4.7.17 å¢å æ¹éä»»å¡çæå·¥å ·
-
v4.7.17 ä¼åZDHç®å½çæ,æ¯æå¤å±çº§ç®å½çæ
-
v4.7.17 æ°å¢å·¥å ·ç®±ç®å½,è¿ç§»Cron,æä½æ¥å¿,æ´åºè¿ç§»å°å·¥å ·ç®±ä¸
-
v4.7.17 åæ¶æædataSourcesServiceå±,ç´æ¥ä½¿ç¨daoå±ä»£æ¿
-
v4.7.17 ä¼åéç¥ä¿¡æ¯,å¢å é»è¾å é¤
-
v4.7.17 ä¼åç®å½-å¢å æ示è¯
-
v4.7.17 ä¿®å¤è°åº¦é¡µé¢Shellæ¾ç¤ºbug
-
v4.7.17 æ¿æ¢å ¨å±editor为monaco editor(çé¢æ´å æ¸ æ°ç¾è§)
-
v4.7.17 ä¼åè°åº¦æ°å¢é¡µé¢js(å é¤æ ç¨js)
-
v4.7.17 ç³è¯·æºETLå¢å æç»æ¥è¯¢æé
-
v4.7.17 å é¤æææ¥å¿æå°,ç»ä¸ä½¿ç¨logger管ç
-
v4.7.17 å¢å ZDH项ç®ä¸è½½å°å
-
v4.7.18 æ¿æ¢ç¼è¾å¨ä¸ºmonaco editor
-
v4.7.18 ä¿®æ¹fastjson:1.2.44å级为1.2.69
-
v4.7.18 ä¿®æ¹shiro:1.4.0å级1.7.1
-
v4.7.18 mysql:8.0.11å级为8.0.13
-
v4.7.18 commons-io:2.6å级2.7
-
v4.7.18 httpclient:4.5.5å级4.5.13
-
v4.7.18 å é¤shiroèªå¨sessionéªè¯,éç¨zdhèªå¸¦quartzä»»å¡éåsessionæ ¡éª
-
v4.7.18 å¢å è°åº¦å¨ç®¡ç-å¯å¯¹çº¿ä¸å·²å¼å¯çè°åº¦å¨-èªå¨ä¸çº¿ä¸çº¿
-
v4.7.18 æ°å¢èåæ¶-å¢å å¾æ æ¥çç½å
-
v4.7.18 ä¿®å¤flinkä»»å¡ææ»bug
-
v4.7.18 zdh_serveræ´å为zdh_spark,zdh_flinkæ´å为zdh_flinkx 项ç®ç®¡çå·¥å ·ä½¿ç¨maven代æ¿gradle
-
v4.7.18 éæzdh_flinkx 项ç®æ¶æ
-
v4.7.18 è°åº¦ä»»å¡-è°åº¦æ¶é´çç¥-使ç¨quartz触åæ¶é´ä¸ºé»è®¤çç¥
-
v4.7.18 å®ç°èªå®ä¹quartz instance_id çæçç¥
-
v4.7.18 è°åº¦ä»»å¡å¢å quartz missçç¥
-
v4.7.18 è°åº¦ä»»å¡ä¿®æ¹quartz触åé»è¾-ä¿®å¤quartz触åæ¶é´åquartzé»è¾è°åº¦æ¶é´
-
v4.7.18 å¢å ç³»ç»çæ§api
-
v4.7.18 ä¼å审æ¹æµ-å¨æ使ç¨å®¡æ¹èç¹
-
v4.7.18 å¢å æ举管ç
-
v4.7.18 SSH,SFTPå¢å å å¯ç»å½
-
v4.7.18 ä¿®å¤æ°æ®è´¨éæ£æµæ示é误
-
v4.7.18 åºå¼js/jsplumb/index2.js
-
v4.7.18 å¢å tomcat线ç¨é ç½®åæ°
-
v4.7.18 ä¿®æ¹mysql8é»è®¤å¯ç éªè¯ä¸ºmysql_native_password模å¼
-
v4.7.18 ä¿®å¤ç¨æ·ä¸å¿æ¥å£å°å请æ±,æ¯æå¤é¡¹ç®å
-
v4.7.18 ä¿®å¤æ°æ®ä»åºä¿¡æ¯æ´æ°æ¶,åå¸ç¶æå¼å¸¸bug
-
v4.7.18 ä¼åèµæºé 置页é¢,交äºæ´å å好
-
v4.7.18 ä¿®å¤å¢å æ ¹é¡¹ç®å,é¨å页é¢æ æ³è·åæ°æ®bug
-
v4.7.18 æ°æ®æºå¢å æéæ§å¶
-
v4.7.18 ç³»ç»éæµçå¨æåæ°é ç½®
-
v5.0.0 å¢å æ°æ®èµäº§å¯¼åºåè½
-
v5.0.0 å¢å è°åº¦å¨èªå¨å¯å¨é ç½®
-
v5.0.0 å¢å æ°æ®èµäº§æ¥è¯¢
-
v5.0.0 æ¥å¿ä¸è½½å¢å ç½åå
-
v5.0.0 å®ç°éç»æåæ°æ®å½å ¥-并èªå¨çæ对åºå ³ç³»
-
v5.0.0 å®ç°éç»æåæ°æ®å½å ¥æ°æ®æº-åªæ¯æsftp,ftp,hdfs
-
v5.0.0 [zdh_spark]ä¿®å¤hbaseåå ¥å¨ææ´æ°è¿åº¦bug
-
v5.0.0 [zdh_spark]ä¿®å¤hbaseåå ¥æ¶,åå§æ°æ®ä¸ºç©ºæ¶æ æ³åå ¥bug
-
v5.0.0 [zdh_spark]ä¼åkafkaæ°æ®åå ¥
-
v5.0.0 ä¼å404页é¢,å¢å 403æ æé页é¢
-
v5.0.0 åè½æé(è§è²,èµæº)-å¢å 产åç»å®
-
v5.0.0 [zdh_spark]å级hudi-sparkçæ¬0.5.1==>0.10.1
-
v5.0.0 éæzdh_spark è¿åº¦çæ§
-
v5.0.0 ä¼åç»å½é¡µé¢-éªè¯ç ,åéªè¯ç æ ææ示
-
v5.0.0 ä¼åå表页é¢æ æéæ示
-
v5.0.0 ä¿®å¤web端ç»å½å,å次使ç¨login页é¢æ 跳转é¦é¡µbug
-
v5.0.0 å é¤èªå®ä¹StringUtils使ç¨common-lang3.StringUtils
-
v5.0.0 requestmapping注解ä¸è¡¥å ¨è¯·æ±ç±»å
-
v5.0.0 æ´åspringdoc,å½åä¸å®å,å json解æå²çª,ä¼åºç°jsoné误æ¥å¿(ä¸å½±åç³»ç»)
-
v5.0.0 ä¼åæ举,å¢å æ举类å«æ¾ç¤º
-
v5.0.0 å¢å ç³»ç»çæ§ä»»å¡å表,å¯ç¨,ç¦ç¨
-
v5.0.0 ä¼åæ¥å¿æå°
-
v5.0.0 æ°æ®èµäº§é¡µé¢å¢å å页大å°
-
v5.0.0 ä¼åæ°æ®èµäº§è·åæ ç¾é»è¾,æ¹ç¨éè¿è·åæ举类å«è·åæ°æ®èµäº§çæ ç¾
-
v5.0.0 è¿ç§»éªè¯ç æ¥å£å°LoginControllerå±
-
v5.0.0 æä½æ¥å¿å¢å èæ¶
-
v5.0.0 æ æéå¢å æä½æ¥å¿
-
v5.0.0 æ¥å¿æå¼æ¶é´æ¡ä»¶æ¥è¯¢,ä¿®å¤çæ§é¡µé¢ç»æ¥å¿æ¥ææ æbug
-
v5.0.0 审æ¹é¡µé¢-å¢å è·³è¿æµç¨,ç³è¯·é¡µé¢-å¢å è·³è¿æµç¨
-
v5.0.0 ç³è¯·é¡µé¢bugä¿®å¤
-
v5.0.0 ä¼åç»å½é¡µé¢èæ¯
-
v5.0.0 appicationç¸å ³é ç½®æ件修æ¹ç¼ç 为utf-8
-
v5.0.0 å¢å sparkæ°æ®æºè§£æ
-
v5.0.0 pomå¢å screwæ°æ®åºææ¡£çææ件
-
v5.0.0 å¢å ç³»ç»è®¿é®éå¶(zdh_is_pass)
-
v5.0.0 ä¼åç³»ç»åæ°é ç½®,åæ¥rediså¢å 失æéå¶
-
v5.0.0 ä¼åmybatis like æ¥è¯¢
-
v5.0.0 ä¿®å¤é¨å页é¢æ¥è¯¢æ¡ä»¶æ æ
-
v5.0.0 ä¿®å¤å®¡æ¹æµé ç½®-æ¥è¯¢æ¡ä»¶æ æ
-
v5.0.0 æ°æ®åºtimestampç±»åæ¹ä¸ºdatetimeç±»å
-
v5.0.0 ä¼åæ°æ®èµäº§å页
-
v5.0.0 å¢å é¦é¡µå ¬åå¼¹æ¡,åå±ç¤ºç±»å(å¼¹æ¡,æå)
-
v5.0.0 å¢å ipé»ååéå¶è®¿é®
-
v5.0.0 æä½æ¥å¿å¢å ipè®°å½
-
v5.0.0 å¢å ç³»ç»åå¯ä¿®æ¹
-
v5.0.0 ä¼åé¦é¡µä¸»é¢,å¢å 主é¢è®°ä½åè½
-
v5.0.0 å¢å http,emailä»»å¡è°åº¦åè½
-
v5.0.0 ä¿®å¤èµæºæ´æ°ç¶èç¹,å±çº§æªä¿®æ¹bug
-
v5.0.0 å¢å èªå©SQLæ¥è¯¢æå¡
-
v5.0.0 å¼å¯druidçæ§
-
v5.0.0 ä¼åcontrollerå±æææ¥å£,å¢å 请æ±ç±»å
-
v5.0.0 å é¤jdbcä»»å¡è¾åºæºé ç½®
-
v5.0.0 ä¼åè°åº¦é ç½®JDBC模å-æ¿æ¢ç¼è¾å¨ç»ä»¶
-
v5.0.0 ä¼åéè¯ä»»å¡ç»é¡µé¢-å¢å å¾å ³ç³»å±ç¤º
-
v5.0.0 ä¿®å¤ç»æ¥å¿æ¥çæ¶æ¶é´ä¸ºç©ºé®é¢
-
v5.0.0 ä¼åæ¥å¿æå°-å¢å ç¨æ·å,æåsqlæ¥å¿
-
v5.0.0 å¢å ç¨æ·é»ååéå¶
-
v5.0.0 å é¤quartz模ååé¢
-
v5.0.0 ä¼åè°åº¦éè¯çé¢,ææ»ä»»å¡å¢å é»è®¤éè¯
-
v5.0.0 éè¯ææ°æ§è¡,å¢å ä»»å¡ä¿¡æ¯ææ°ç
-
v5.0.1 ä¿®å¤greenplumæ°æ®æºè¯»å表信æ¯bug
-
v5.1.0 å¢å æ ç¾æ¨¡å(为ç¨æ·ç»å,æºè½è¥éååºç¡)ãå¼åä¸ã
-
v5.0.1 å¢å æ¥å£é»ååéå¶ãåºå¼ã
-
v5.0.1 æéåç¬åºSDKååé 身份ç (身份ç å产åidå å¯è§£å¯ç»å®)ãå¼åä¸ã
-
v5.0.1 æ°æ®èµäº§-ç³è¯·ç»ä¿¡æ¯ãå¼åä¸ã
-
v5.0.1 wemock ãå¼åä¸ã
-
v5.0.1 flinkå¢å æå¨checkpointåè½ ãå¼åä¸ã
4.7.15è¿ç§»4.7.16
alter table data_sources_info add column update_time timestamp default null comment 'æ´æ°æ¶é´';
alter table etl_task_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table etl_task_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table etl_more_task_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table etl_more_task_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table sql_task_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table sql_task_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table ssh_task_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table ssh_task_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table etl_task_flink_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table etl_task_jdbc_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table etl_task_jdbc_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table etl_task_datax_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
alter table etl_task_datax_info add column is_delete varchar(16) default "0" comment 'æ¯å¦å é¤,0:æªå é¤,1:å é¤';
alter table etl_apply_task_info add column update_time timestamp default current_timestamp() comment 'æ´æ°æ¶é´';
CREATE TABLE `alarm_sms_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`title` varchar(500) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`msg` text COMMENT 'ä¿¡æ¯',
`msg_type` varchar(100) DEFAULT NULL COMMENT 'ä¿¡æ¯ç±»åï¼éç¥,è¥é',
`msg_url` varchar(500) DEFAULT NULL COMMENT 'çä¿¡é带è¿æ¥',
`phone` varchar(100) DEFAULT NULL COMMENT 'ææºå·',
`status` varchar(8) DEFAULT '0' COMMENT 'ç¶æ,0:æªå¤ç,1:å¤çä¸,2:失败,3:æå,4:ä¸å¤ç',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;
CREATE TABLE `user_operate_log` (
`id` bigint NOT NULL AUTO_INCREMENT,
`owner` varchar(500) DEFAULT NULL COMMENT 'è´¦å·',
`user_name` varchar(500) DEFAULT NULL COMMENT 'ç¨æ·å',
`operate_url` varchar(500) COMMENT 'æä½url',
`operate_context` varchar(500) COMMENT 'æä½è¯´æ',
`operate_input` text COMMENT 'è¾å
¥åæ°',
`operate_output` text COMMENT 'è¾åºç»æ',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;
4.7.16è¿ç§»4.7.17
CREATE TABLE `etl_task_batch_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`etl_pre_context` varchar(200) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`etl_suffix_context` varchar(200) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`data_sources_choose_input` varchar(100) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºid',
`data_source_type_input` varchar(100) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºç±»å',
`data_sources_table_name_input` varchar(100) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºè¡¨å',
`data_sources_file_name_input` varchar(100) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºæ件å',
`data_sources_params_input` varchar(500) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºåæ°',
`data_sources_filter_input` varchar(500) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºè¿æ»¤æ¡ä»¶',
`data_sources_choose_output` varchar(100) DEFAULT NULL COMMENT 'è¾åºæ°æ®æºid',
`data_source_type_output` varchar(100) DEFAULT NULL COMMENT 'è¾åºæ°æ®æºç±»å',
`data_sources_table_name_output` varchar(100) DEFAULT NULL COMMENT 'è¾åºæ°æ®æºè¡¨å',
`data_sources_file_name_output` varchar(100) DEFAULT NULL COMMENT 'è¾åºæ°æ®æºæ件å',
`data_sources_params_output` varchar(500) DEFAULT NULL COMMENT 'è¾åºæ°æ®æºåæ°',
`data_sources_clear_output` varchar(500) DEFAULT NULL COMMENT 'æ°æ®æºæ°æ®æºå é¤æ¡ä»¶',
`owner` varchar(100) DEFAULT NULL COMMENT 'æ¥æè
',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`company` varchar(100) DEFAULT NULL COMMENT '表æå±å
¬å¸',
`section` varchar(100) DEFAULT NULL COMMENT '表æå±é¨é¨',
`service` varchar(100) DEFAULT NULL COMMENT '表æå±æå¡',
`update_context` varchar(100) DEFAULT NULL COMMENT 'æ´æ°è¯´æ',
`file_type_input` varchar(10) DEFAULT NULL COMMENT 'è¾å
¥æ件类å',
`encoding_input` varchar(10) DEFAULT NULL COMMENT 'è¾å
¥æ件ç¼ç ',
`sep_input` varchar(10) DEFAULT NULL COMMENT 'è¾å
¥åå²ç¬¦',
`file_type_output` varchar(10) DEFAULT NULL COMMENT 'è¾åºæ件类å',
`encoding_output` varchar(10) DEFAULT NULL COMMENT 'è¾åºæ件ç¼ç ',
`sep_output` varchar(10) DEFAULT NULL COMMENT 'è¾åºæ件åå²ç¬¦',
`header_input` varchar(10) DEFAULT NULL COMMENT 'è¾å
¥æ¯å¦å
å«è¡¨å¤´',
`header_output` varchar(10) DEFAULT NULL COMMENT 'è¾åºæ¯å¦å
å«è¡¨å¤´',
`repartition_num_input` varchar(64) NOT NULL DEFAULT '' COMMENT 'æ´ç个æ°é»è®¤ç©º',
`repartition_cols_input` varchar(256) NOT NULL DEFAULT '' COMMENT 'æ´çå段é»è®¤ç©º',
`model_output` varchar(64) NOT NULL DEFAULT '' COMMENT 'åå
¥æ¨¡å¼é»è®¤ç©º',
`partition_by_output` varchar(256) NOT NULL DEFAULT '' COMMENT 'ååºå段é»è®¤ç©º',
`merge_output` varchar(256) NOT NULL DEFAULT '-1' COMMENT 'å并å°æ件é»è®¤-1 ä¸å并',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`status` varchar(8) not null default '0' comment '0:æªæ§è¡,1:æ§è¡ä¸,2:æ§è¡å¤±è´¥,3:æ§è¡æå',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
alter table resource_tree_info add column notice_title varchar(8) not null default '' comment 'æ示è¯';
4.7.17è¿ç§»4.7.18
CREATE TABLE `quartz_executor_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`instance_name` varchar(512) DEFAULT NULL COMMENT 'è°åº¦å¨å¯ä¸å®ä¾å',
`status` varchar(200) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`is_handle` varchar(100) DEFAULT NULL COMMENT 'æ¯å¦å¤çè¿,true/false',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- æ¤å¤qrtz表åç¡®å®æ¯å¦å¤§å,å¦ææ°æ®åºå¼å¯ä¸åºå大å°å,å¯å°å,å¦åå¿
须使ç¨QRTZ_SCHEDULER_STATE
alter table qrtz_scheduler_state add column STATUS varchar(16) not null default 'online' comment 'ç¶æï¼ä¸çº¿offline,ä¸çº¿online';
-- è°åº¦å¢å çç¥æ¨¡å¼
alter table quartz_job_info add column misfire varchar(8) not null default '0' comment 'æ¢å¤çç¥,0:æ æä½,1:ææåå²éæ°æ§è¡,2:æè¿ä¸æ¬¡åå²éæ°æ§è¡';
-- å¢å 审æ¹æµä¼å
alter table resource_tree_info add column event_code varchar(64) not null default '' comment 'ç»å®äºä»¶';
update resource_tree_info set event_code='data_pub' where url='issue_data_add';
update resource_tree_info set event_code='data_apply' where url='data_apply_add';
-- å¢å æ举管ç
CREATE TABLE `enum_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`enum_code` varchar(512) DEFAULT NULL COMMENT 'æ举æ è¯',
`enum_context` varchar(200) DEFAULT NULL COMMENT 'æ举说æ',
`enum_type` varchar(100) DEFAULT NULL COMMENT 'æ举类å',
`enum_json` text comment 'æ举æç»',
`owner` varchar(64) default null COMMENT 'æ¥æè
',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934820298253930496, '802848818109353984', 'æ举管ç', '2', '1', 'fa fa-cubes', '', '10', '1', '2022-01-23 14:42:07', '2022-01-23 14:42:41', 'enum_index', '2', '', '');
INSERT INTOresource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934820739683454976, '934820298253930496', 'æ¥è¯¢', '3', '1', 'fa fa-coffee', '', '1', '1', '2022-01-23 14:43:52', '2022-01-23 14:43:52', 'enum_list', '5', '', '');
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934899005698084864, '934820298253930496', 'æ°å¢é¡µé¢', '3', '1', 'fa fa-coffee', '', '2', '1', '2022-01-23 19:54:53', '2022-01-23 19:54:53', 'enum_add_index', '3', '', '');
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934899134614212608, '934820298253930496', 'æ°å¢', '3', '1', 'fa fa-coffee', '', '3', '1', '2022-01-23 19:55:23', '2022-01-23 19:55:23', 'enum_add', '5', '', '');
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934899250242785280, '934820298253930496', 'å é¤', '3', '1', 'fa fa-coffee', '', '4', '1', '2022-01-23 19:55:51', '2022-01-23 19:55:51', 'enum_delete', '5', '', '');
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934899352286007296, '934820298253930496', 'æ´æ°', '3', '1', 'fa fa-coffee', '', '5', '1', '2022-01-23 19:56:15', '2022-01-23 19:56:15', 'enum_update', '5', '', '');
INSERT INTO resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934926419119575040, '934820298253930496', 'æç»', '3', '1', 'fa fa-coffee', '', '6', '1', '2022-01-23 21:43:48', '2022-01-23 21:43:48', 'enum_detail', '5', '', '');
CREATE TABLE `param_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`param_name` varchar(512) DEFAULT NULL COMMENT 'åæ°å称',
`param_value` text COMMENT 'åæ°å称',
`param_context` varchar(200) DEFAULT NULL COMMENT 'åæ°è¯´æ',
`param_type` varchar(100) DEFAULT NULL COMMENT 'åæ°ç±»å',
`param_timeout` varchar(200) DEFAULT NULL COMMENT 'ç¼åè¶
æ¶æ¶é´,åä½ç§',
`owner` varchar(64) default null COMMENT 'æ¥æè
',
`status` varchar(64) default null COMMENT 'ç¶æ,å¯ç¨:on, å
³é:off',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` timestamp DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER USER 'zyc'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'zyc'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
alter table issue_data_info add column label_params text comment 'æ°æ®æ ç¾,å¤ä¸ªéå·åå²';
CREATE TABLE `data_tag_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`tag_code` varchar(512) DEFAULT NULL COMMENT 'æ è¯code',
`tag_name` varchar(200) DEFAULT NULL COMMENT 'æ è¯å称',
`product_code` varchar(100) DEFAULT NULL COMMENT '产åcode',
`owner` varchar(64) default null COMMENT 'æ¥æè
',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `product_tag_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`product_code` varchar(512) DEFAULT NULL COMMENT '产åæ è¯code',
`product_name` varchar(200) DEFAULT NULL COMMENT '产åå称',
`owner` varchar(64) default null COMMENT 'æ¥æè
',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `data_tag_group_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`tag_group_code` varchar(512) DEFAULT NULL COMMENT 'æ è¯ç»code',
`tag_group_name` varchar(200) DEFAULT NULL COMMENT 'æ è¯ç»å称',
`tag_codes` varchar(512) DEFAULT NULL COMMENT 'æ è¯codeå表,éå·åå²',
`product_code` varchar(100) DEFAULT NULL COMMENT '产åcode',
`owner` varchar(64) default null COMMENT 'æ¥æè
',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
alter table account_info add column tag_group_code varchar(512) not null default '' comment 'æ°æ®ç»æ è¯,å¤ä¸ªéå·åå²';
alter table data_sources_info add column tag_group_code varchar(512) not null default '' comment 'æ°æ®ç»æ è¯,å¤ä¸ªéå·åå²';
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(934940905796800512, '802848818109353984', 'WEMOCK', '2', '1', 'fa fa-cube', '', '150', '1', '2022-01-23 22:41:22', '2022-01-23 22:41:22', 'abc.html', '2', 'å¼åä¸', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936723230184443904, '802919157430489088', 'SparkSqlæ¥è¯¢è¡¨ç»æ', '4', '1', 'fa fa-coffee', '', '7', '1', '2022-01-28 20:43:42', '2022-01-28 20:43:42', 'desc_table', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936943441596649472, '926763179978002432', 'åæ°é
ç½®', '3', '1', 'fa fa-diamond', '', '4', '1', '2022-01-29 11:18:44', '2022-01-29 11:18:44', 'param_index', '2', '管çå', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936943543832809472, '936943441596649472', 'æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '1', '1', '2022-01-29 11:19:08', '2022-01-29 11:19:08', 'param_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936943806161358848, '936943441596649472', 'æ´æ°é¡µé¢', '4', '1', 'fa fa-coffee', '', '2', '1', '2022-01-29 11:20:11', '2022-01-29 11:20:11', 'param_add_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936943897400053760, '936943441596649472', 'æ°å¢', '4', '1', 'fa fa-coffee', '', '3', '1', '2022-01-29 11:20:33', '2022-01-29 11:20:33', 'param_add', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936943979792961536, '936943441596649472', 'æ´æ°', '4', '1', 'fa fa-coffee', '', '4', '1', '2022-01-29 11:20:52', '2022-01-29 11:20:52', 'param_update', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936944089763418112, '936943441596649472', 'å é¤', '4', '1', 'fa fa-coffee', '', '5', '1', '2022-01-29 11:21:19', '2022-01-29 11:21:19', 'param_delete', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(936956093823717376, '936943441596649472', 'æ¥è¯¢æç»', '4', '1', 'fa fa-coffee', '', '6', '1', '2022-01-29 12:09:01', '2022-01-29 12:09:01', 'param_detail', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(937123552732123136, '810817759893000192', 'æ°æ®èµäº§', '3', '1', 'fa fa-coffee', '', '4', '1', '2022-01-29 23:14:26', '2022-01-29 23:14:26', 'data_ware_house_index_plus', '2', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938782846959489024, '802932548165439488', 'åè½æé', '3', '1', 'fa fa-cog', '', '1', '1', '2022-02-03 13:07:52', '2022-02-03 13:08:07', '', '1', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938783170151583744, '802932548165439488', 'æ°æ®æé', '3', '1', 'fa fa-cog', '', '2', '1', '2022-02-03 13:09:10', '2022-02-03 13:09:10', '', '1', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938783478181269504, '938783170151583744', 'æ°æ®æ è¯', '4', '1', 'fa fa-cog', '', '1', '1', '2022-02-03 13:10:23', '2022-02-03 13:11:33', 'data_tag_index', '2', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938783882944188416, '938783478181269504', 'æ¥è¯¢', '5', '1', 'fa fa-coffee', '', '1', '1', '2022-02-03 13:11:59', '2022-02-03 13:11:59', 'data_tag_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938784014171377664, '938783478181269504', 'æ°å¢é¡µé¢', '5', '1', 'fa fa-coffee', '', '2', '1', '2022-02-03 13:12:31', '2022-02-03 13:12:31', 'data_tag_add_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938784115174412288, '938783478181269504', 'æ°å¢', '5', '1', 'fa fa-coffee', '', '3', '1', '2022-02-03 13:12:55', '2022-02-03 13:12:55', 'data_tag_add', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938784216877895680, '938783478181269504', 'æ´æ°', '5', '1', 'fa fa-coffee', '', '4', '1', '2022-02-03 13:13:19', '2022-02-03 13:13:19', 'data_tag_update', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938784333840257024, '938783478181269504', 'å é¤', '5', '1', 'fa fa-coffee', '', '5', '1', '2022-02-03 13:13:47', '2022-02-03 13:13:47', 'data_tag_delete', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938785006883442688, '938783170151583744', '产åæ è¯', '4', '1', 'fa fa-cog', '', '2', '1', '2022-02-03 13:16:27', '2022-02-03 13:19:15', 'product_tag_index', '2', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938785227138928640, '938785006883442688', 'æ¥è¯¢', '5', '1', 'fa fa-coffee', '', '1', '1', '2022-02-03 13:17:20', '2022-02-03 13:17:20', 'product_tag_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938785661765292032, '938785006883442688', 'æ°å¢é¡µé¢', '5', '1', 'fa fa-coffee', '', '2', '1', '2022-02-03 13:19:04', '2022-02-03 13:19:04', 'product_tag_add_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938785831097733120, '938785006883442688', 'æ°å¢', '5', '1', 'fa fa-coffee', '', '3', '1', '2022-02-03 13:19:44', '2022-02-03 13:19:44', 'product_tag_add', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938785942548779008, '938785006883442688', 'æ´æ°', '5', '1', 'fa fa-coffee', '', '4', '1', '2022-02-03 13:20:11', '2022-02-03 13:20:11', 'product_tag_update', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938786051592294400, '938785006883442688', 'å é¤', '5', '1', 'fa fa-coffee', '', '5', '1', '2022-02-03 13:20:37', '2022-02-03 13:20:37', 'product_tag_delete', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938879140692496384, '938783478181269504', 'æç»', '5', '1', 'fa fa-coffee', '', '6', '1', '2022-02-03 19:30:31', '2022-02-03 19:30:31', 'data_tag_detail', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(938879269428269056, '938785006883442688', 'æç»', '5', '1', 'fa fa-coffee', '', '6', '1', '2022-02-03 19:31:01', '2022-02-03 19:31:01', 'product_tag_detail', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939102606079299584, '938783170151583744', 'æ è¯ç»', '4', '1', 'fa fa-cog', '', '3', '1', '2022-02-04 10:18:29', '2022-02-04 10:18:29', 'data_tag_group_index', '2', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939102720999034880, '939102606079299584', 'æ¥è¯¢', '5', '1', 'fa fa-coffee', '', '1', '1', '2022-02-04 10:18:56', '2022-02-04 10:18:56', 'data_tag_group_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939102954936340480, '939102606079299584', 'æ°å¢é¡µé¢', '5', '1', 'fa fa-coffee', '', '2', '1', '2022-02-04 10:19:52', '2022-02-04 10:19:52', 'data_tag_group_add_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939103070598467584, '939102606079299584', 'æ°å¢', '5', '1', 'fa fa-coffee', '', '3', '1', '2022-02-04 10:20:20', '2022-02-04 10:20:20', 'data_tag_group_add', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939103467824222208, '939102606079299584', 'æ´æ°', '5', '1', 'fa fa-coffee', '', '4', '1', '2022-02-04 10:21:54', '2022-02-04 10:21:54', 'data_tag_group_update', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939103572845400064, '939102606079299584', 'å é¤', '5', '1', 'fa fa-coffee', '', '5', '1', '2022-02-04 10:22:19', '2022-02-04 10:22:19', 'data_tag_group_delete', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939103663475920896, '939102606079299584', 'æç»', '5', '1', 'fa fa-coffee', '', '6', '1', '2022-02-04 10:22:41', '2022-02-04 10:22:41', 'data_tag_group_detail', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939113343006806016, '938783478181269504', '产åcodeæ¥è¯¢', '5', '1', 'fa fa-coffee', '', '7', '1', '2022-02-04 11:01:09', '2022-02-04 11:01:09', 'data_tag_by_product_code', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939830350585008128, '802918652050411520', 'æ¥è¯¢æ°æ®ç»æ è¯', '3', '1', 'fa fa-coffee', '', '10', '1', '2022-02-06 10:30:17', '2022-02-06 10:30:17', 'user_tag_group_code', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(939848526425231360, '936943441596649472', 'åæ¥redis', '4', '1', 'fa fa-coffee', '', '7', '1', '2022-02-06 11:42:30', '2022-02-06 11:42:30', 'param_to_redis', '5', '', '');
4.7.18è¿ç§»5.0.0
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(942052856712663040, '937123552732123136', 'æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '1', '1', '2022-02-12 13:41:44', '2022-02-12 13:41:44', 'data_ware_house_list6', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(942052978712383488, '937123552732123136', 'æ ç¾æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '2', '1', '2022-02-12 13:42:13', '2022-02-12 13:42:13', 'data_ware_house_label', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(942053081317642240, '937123552732123136', 'æ ·æ¬æ°æ®æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '3', '1', '2022-02-12 13:42:37', '2022-02-12 13:43:08', 'data_ware_house_sample', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(942053175202942976, '937123552732123136', 'æ ·æ¬æ°æ®å¯¼åº', '4', '1', 'fa fa-coffee', '', '4', '1', '2022-02-12 13:42:59', '2022-02-12 13:42:59', 'data_ware_house_export', '5', '', '');
CREATE TABLE `etl_task_unstructure_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`unstructure_context` varchar(200) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`project_id` varchar(100) DEFAULT NULL,
`data_sources_choose_file_input` varchar(100) DEFAULT null comment 'è¾å
¥æ°æ®æº',
`input_path` varchar(512) DEFAULT null comment 'æ件读åè·¯å¾',
`data_sources_choose_file_output` varchar(100) DEFAULT NULL,
`data_sources_choose_jdbc_output` varchar(100) DEFAULT NULL,
`output_path` varchar(512) DEFAULT null comment 'æ件åå
¥è·¯å¾',
`etl_sql` text,
`unstructure_params_output` varchar(500) DEFAULT NULL,
`owner` varchar(100) DEFAULT NULL COMMENT 'æ¥æè
',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`company` varchar(100) DEFAULT NULL COMMENT '表æå±å
¬å¸',
`section` varchar(100) DEFAULT NULL COMMENT '表æå±é¨é¨',
`service` varchar(100) DEFAULT NULL COMMENT '表æå±æå¡',
`update_context` varchar(100) DEFAULT NULL COMMENT 'æ´æ°è¯´æ',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `etl_task_unstructure_log_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`unstructure_id` varchar(100) DEFAULT null comment 'éç»æåä»»å¡ID',
`unstructure_context` varchar(200) DEFAULT NULL COMMENT 'ä»»å¡è¯´æ',
`project_id` varchar(100) DEFAULT NULL,
`data_sources_choose_file_input` varchar(100) DEFAULT null comment 'è¾å
¥æ°æ®æº',
`input_path` varchar(512) DEFAULT null comment 'æ件读åè·¯å¾',
`data_sources_choose_file_output` varchar(100) DEFAULT NULL,
`data_sources_choose_jdbc_output` varchar(100) DEFAULT NULL,
`output_path` varchar(512) DEFAULT null comment 'æ件åå
¥è·¯å¾',
`etl_sql` text,
`unstructure_params_output` varchar(500) DEFAULT NULL,
`msg` text comment 'æ§è¡æ¥å¿',
`status` varchar(64) default null COMMENT 'ç¶æ,true/false',
`owner` varchar(100) DEFAULT NULL COMMENT 'æ¥æè
',
`create_time` timestamp NULL DEFAULT NULL COMMENT 'å建æ¶é´',
`company` varchar(100) DEFAULT NULL COMMENT '表æå±å
¬å¸',
`section` varchar(100) DEFAULT NULL COMMENT '表æå±é¨é¨',
`service` varchar(100) DEFAULT NULL COMMENT '表æå±æå¡',
`update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943266657919307776, '802852358580080640', 'éç»æåéé', '3', '1', 'non', '', '11', '1', '2022-02-15 22:04:56', '2022-02-15 22:05:37', 'etl_task_unstructure_index', '2', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943266905408409600, '943266657919307776', 'æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '1', '1', '2022-02-15 22:05:55', '2022-02-15 22:05:55', 'etl_task_unstructure_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943267015571804160, '943266657919307776', 'æ°å¢é¡µé¢', '4', '1', 'fa fa-coffee', '', '2', '1', '2022-02-15 22:06:22', '2022-02-15 22:06:22', 'etl_task_unstructure_add_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943267126561476608, '943266657919307776', 'æ°å¢', '4', '1', 'fa fa-coffee', '', '3', '1', '2022-02-15 22:06:48', '2022-02-15 22:06:48', 'etl_task_unstructure_add', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943267228420149248, '943266657919307776', 'æ´æ°', '4', '1', 'fa fa-coffee', '', '4', '1', '2022-02-15 22:07:12', '2022-02-15 22:07:12', 'etl_task_unstructure_update', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943267317154844672, '943266657919307776', 'å é¤', '4', '1', 'fa fa-coffee', '', '5', '1', '2022-02-15 22:07:33', '2022-02-15 22:07:33', 'etl_task_unstructure_delete', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943633847528984576, '943266657919307776', 'ä¸ä¼ æ件页é¢', '4', '1', 'fa fa-coffee', '', '6', '1', '2022-02-16 22:24:01', '2022-02-16 22:24:01', 'etl_task_unstructure_upload_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(943633913723490304, '943266657919307776', 'ä¸ä¼ æ件', '4', '1', 'fa fa-coffee', '', '7', '1', '2022-02-16 22:24:17', '2022-02-16 22:24:17', 'etl_task_unstructure_upload', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(944568364485840896, '943266657919307776', 'æ¥å¿é¡µé¢', '4', '1', 'fa fa-coffee', '', '8', '1', '2022-02-19 12:17:27', '2022-02-19 12:17:27', 'etl_task_unstructure_log_index', '3', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(944568478025650176, '943266657919307776', 'æ¥å¿æ¥è¯¢', '4', '1', 'fa fa-coffee', '', '9', '1', '2022-02-19 12:17:54', '2022-02-19 12:17:54', 'etl_task_unstructure_log_list', '5', '', '');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code)
VALUES(944718135569682432, '943266657919307776', 'æ¥å¿å é¤', '4', '1', 'fa fa-coffee', '', '10', '1', '2022-02-19 22:12:36', '2022-02-19 22:12:36', 'etl_task_unstructure_log_delete', '5', '', '');
alter table resource_tree_info add column product_code varchar(100) not null default '' comment '产åcode';
update resource_tree_info set product_code='zdh';
alter table role_info add column product_code varchar(100) not null default '' comment '产åcode';
update role_info set product_code='zdh';
INSERT INTO zdh.resource_tree_info
(id, parent, text, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(958858421291978752, '930966518835974144', 'æ¥è¯¢ç³»ç»ä»»å¡', '4', '1', 'fa fa-coffee', '', '3', '1', '2022-03-30 22:41:02', '2022-03-30 22:41:02', 'dispatch_system_task_list', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, text, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(958858522265653248, '930966518835974144', 'å¯ç¨ç³»ç»ä»»å¡', '4', '1', 'fa fa-coffee', '', '4', '1', '2022-03-30 22:41:26', '2022-03-30 22:41:26', 'dispatch_system_task_create', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, text, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(958858665077510144, '930966518835974144', 'ç¦ç¨ç³»ç»ä»»å¡', '4', '1', 'fa fa-coffee', '', '5', '1', '2022-03-30 22:42:00', '2022-03-30 22:42:00', 'dispatch_system_task_delete', '5', '', '', 'zdh');
alter table user_operate_log add column `time` varchar(100) not null default '' comment '请æ±ååºèæ¶';
alter table QRTZ_SCHEDULER_STATE add column RUNNING varchar(16) not null default '' comment 'æ£å¨æ§è¡ä¸çä»»å¡æ°';
alter table approval_event_info add column `update_time` timestamp NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´'
alter table approval_event_info add column `skip_account` text comment 'å¯è·³è¿å®¡æ¹çç¨æ·';
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(960131981750833152, '930966518835974144', 'æ°å¢ç³»ç»ä»»å¡é¡µé¢', '4', '1', 'fa fa-coffee', '', '6', '1', '2022-04-03 11:01:43', '2022-04-03 11:02:13', 'dispatch_system_task_add_index', '3', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(960132057952948224, '930966518835974144', 'æ°å¢ç³»ç»ä»»å¡', '4', '1', 'fa fa-coffee', '', '7', '1', '2022-04-03 11:02:01', '2022-04-03 11:02:01', 'dispatch_system_task_add', '5', '', '', 'zdh');
alter table blood_source_info add column `input_json` text comment 'è¾å
¥æºé
ç½®';
alter table blood_source_info add column `output_json` text comment 'è¾åºæºé
ç½®';
INSERT INTO zdh.param_info
(id, param_name, param_value, param_context, param_type, param_timeout, owner, status, is_delete, create_time, update_time)
VALUES(4, 'zdh_is_pass', 'false', 'ç³»ç»è®¿é®æ§å¶', '1', '120', '1', 'on', '0', '2022-04-05 18:27:30', '2022-04-05 19:57:47');
ALTER TABLE apply_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE apply_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE approval_auditor_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE approval_config_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE approval_event_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE approval_event_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE blood_source_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE data_tag_group_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE data_tag_group_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE data_tag_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE data_tag_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE enum_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE enum_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE etl_task_update_logs MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE issue_data_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE jar_file_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE jar_task_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE notice_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE notice_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE param_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE param_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE process_flow_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE product_tag_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE product_tag_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE quality MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE quality_rule_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE quality_rule_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE quality_task_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE quality_task_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE quartz_executor_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE quartz_executor_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE quartz_job_info MODIFY COLUMN start_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å¼å§æ¶é´';
ALTER TABLE quartz_job_info MODIFY COLUMN end_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ç»ææ¶é´';
ALTER TABLE quartz_job_info MODIFY COLUMN last_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE quartz_job_info MODIFY COLUMN next_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE quartz_job_info MODIFY COLUMN quartz_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾è§¦åæ¶é´';
ALTER TABLE resource_tree_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE resource_tree_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE role_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE role_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE role_resource_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE role_resource_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE server_task_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE server_task_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE server_task_instance MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE server_task_instance MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN cur_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾é»è¾è°åº¦æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN run_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾å¼å§æ§è¡æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾æ´æ°æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN start_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å¼å§æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN end_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ç»ææ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN last_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN next_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE task_group_log_instance MODIFY COLUMN quartz_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾è§¦åæ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN cur_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾é»è¾è°åº¦æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN run_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾å¼å§æ§è¡æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾æ´æ°æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN start_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å¼å§æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN end_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ç»ææ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN last_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN next_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'ä¸æ¬¡è°åº¦æ¶é´';
ALTER TABLE task_log_instance MODIFY COLUMN quartz_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å®ä¾è§¦åæ¶é´';
ALTER TABLE user_group_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE user_group_info MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE user_operate_log MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE user_operate_log MODIFY COLUMN update_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ´æ°æ¶é´';
ALTER TABLE zdh_download_info MODIFY COLUMN create_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'å建æ¶é´';
ALTER TABLE zdh_logs MODIFY COLUMN log_time DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT 'æ¥å¿çææ¶é´';
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(962422175220895744, '937123552732123136', 'ç³è¯·äººæ¥è¯¢', '4', '1', 'fa fa-coffee', '', '5', '1', '2022-04-09 18:42:08', '2022-04-09 18:42:08', 'data_ware_house_apply', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(962774453505232896, '904058054746574848', 'HTTP页é¢', '5', '1', 'fa fa-coffee', '', '7', '1', '2022-04-10 18:01:57', '2022-04-10 18:01:57', 'http_detail.html', '3', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(962774552792797184, '904058054746574848', 'EMAIL页é¢', '5', '1', 'fa fa-coffee', '', '8', '1', '2022-04-10 18:02:21', '2022-04-10 18:02:21', 'email_detail.html', '3', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963925904835219456, '802848818109353984', 'æºè½è¥é', '2', '1', 'fa fa-coffee', '', '1', '1', '2022-04-13 22:17:25', '2022-04-13 22:56:59', '', '1', 'é«çº§', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963926116140060672, '963925904835219456', 'æ ç¾ç®¡ç', '3', '1', 'fa fa-coffee', '', '1', '1', '2022-04-13 22:18:15', '2022-04-13 22:41:37', '', '1', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963932648793706496, '963925904835219456', 'æºè½çç¥', '3', '1', 'fa fa-coffee', '', '5', '1', '2022-04-13 22:44:12', '2022-04-13 22:49:01', '', '1', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963933243336298496, '963925904835219456', 'æºè½è°åº¦', '3', '1', 'fa fa-coffee', '', '8', '1', '2022-04-13 22:46:34', '2022-04-13 22:49:09', '', '1', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963933821948923904, '963925904835219456', 'æºè½å人', '3', '1', 'fa fa-coffee', '', '2', '1', '2022-04-13 22:48:52', '2022-04-13 22:48:52', '', '1', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(963934828250533888, '963925904835219456', 'ææåæ', '3', '1', 'fa fa-coffee', '', '9', '1', '2022-04-13 22:52:52', '2022-04-13 22:53:12', '', '1', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964797665709658112, '802848818109353984', 'èªå©æå¡', '2', '1', 'fa fa-coffee', '', '5', '1', '2022-04-16 08:01:29', '2022-04-16 08:14:44', 'self_service_index.html', '2', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964801146247974912, '964797665709658112', 'æ°å¢é¡µé¢', '3', '1', 'fa fa-coffee', '', '1', '1', '2022-04-16 08:15:18', '2022-04-16 08:15:18', 'self_service_add_index', '3', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964801241953603584, '964797665709658112', 'æ°å¢', '3', '1', 'fa fa-coffee', '', '2', '1', '2022-04-16 08:15:41', '2022-04-16 08:15:41', 'self_service_add', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964801341513797632, '964797665709658112', 'æ´æ°', '3', '1', 'fa fa-coffee', '', '3', '1', '2022-04-16 08:16:05', '2022-04-16 08:16:05', 'self_service_update', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964801483776200704, '964797665709658112', 'å é¤', '3', '1', 'fa fa-coffee', '', '4', '1', '2022-04-16 08:16:39', '2022-04-16 08:16:39', 'self_service_delete', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(964801562897551360, '964797665709658112', 'æ¥è¯¢', '3', '1', 'fa fa-coffee', '', '5', '1', '2022-04-16 08:16:58', '2022-04-16 08:16:58', 'self_service_list', '5', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(965011294216261632, '964797665709658112', 'æç»', '3', '1', 'fa fa-coffee', '', '6', '1', '2022-04-16 22:10:22', '2022-04-16 22:10:22', 'self_service_detail', '4', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(965206803035983872, '964797665709658112', 'æ§è¡SQL', '3', '1', 'fa fa-coffee', '', '7', '1', '2022-04-17 11:07:15', '2022-04-17 11:07:15', 'self_service_execute', '5', '', '', 'zdh');
CREATE TABLE `self_history` (
`id` bigint NOT NULL AUTO_INCREMENT,
`history_context` varchar(200) DEFAULT NULL COMMENT '说æ',
`etl_sql` text COMMENT 'sql',
`data_sources_choose_input` varchar(100) DEFAULT NULL COMMENT 'è¾å
¥æ°æ®æºid',
`owner` varchar(500) DEFAULT NULL COMMENT 'è´¦å·',
`is_delete` varchar(16) DEFAULT '0' COMMENT 'æ¯å¦å é¤,0:æªå é¤,1:å é¤',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'å建æ¶é´',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(967380640318099456, '802852358580080640', 'æ¥å¿éé', '3', '1', 'non', '', '13', '1', '2022-04-23 11:05:18', '2022-04-23 11:05:52', 'etl_task_log_index.html', '2', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(967465655009808384, '926763179978002432', 'æ°æ®åºçæ§', '3', '1', 'fa fa-coffee', '', '5', '1', '2022-04-23 16:43:07', '2022-04-23 16:43:07', 'druid', '2', '', '', 'zdh');
INSERT INTO zdh.resource_tree_info
(id, parent, `text`, `level`, owner, icon, resource_desc, `order`, is_enable, create_time, update_time, url, resource_type, notice_title, event_code, product_code)
VALUES(969710130591436800, '964797665709658112', '导åº', '3', '1', 'fa fa-coffee', '', '8', '1', '2022-04-29 21:21:51', '2022-04-29 21:21:51', 'self_service_export', '5', '', '', 'zdh');
æªå®æçåè½
- v4.7.x å¢å æ°æ®æºå ±äº«åè½(ç»å å ±äº«,åæåå ±äº«,为è¡ç¼åæååºç¡) å¼åä¸
- v4.7.x æ¥å ¥flinkå¼æ,å®ç°æµéé å·²å®æ
- v4.8 ä¼åæ»å¨å级é¨å å¼åä¸
- v4.8 计åæ¯æè¡ç¼åæ å·²å®æ(4.7.xçæ¬ä»¥æ¯æ)
æ¯æçæ°æ®æº
- æ¬å°æ件
- hive(åé群使ç¨å¤ä¸ªè¿ç¨hive,以åå å¤é¨è¡¨)
- hdfs(csv,txt,json,orc,parquet,avro)
- jdbc (ææçjdbc,å å«ç¹æ®jdbcå¦hbase-phoenix,spark-jdbc,click-house,greenplum,presto,mariadb,memsql,å为dws,é¿éAnalyticDB,kylin,gbase,kingbase,redshift)
- hbase
- mongodb
- es
- kafka
- http
- sftp
- cassandra
- redis
- flume
- greenplum
- kudu
- tidb
æ¯æçè°åº¦å¯¹è±¡
- shell å½ä»¤
- æ°æ®åºæ¥è¯¢
- ç¹è²å¼åjar
æ¯æçè°åº¦å¨æ¨¡å¼
- æ¶é´åºå(æ¶é´éå¶,次æ°éå¶)
- å次æ§è¡
æ¯æè°åº¦å¨ææ¥æåæ°
详è§è¯´æææ¡£
çæ¬è®¡å
- 1.1 计åæ¯æFTP è°åº¦
- 1.1 计åæ¯æHFILE ç´æ¥è¯»ååè½
- 1.1 docker é¨ç½²
- 2.X åä»»å¡å¤æ°æ®æºå¤ç
- 5.X 计åæ¯ækerberos 认è¯
个人èç³»æ¹å¼
é®ä»¶ï¼[email protected]