DROp TABLE IF EXISTS CUSTOMER_BAK;
SELECT * INTO CUSTOMER_BAK FROM CUSTOMER;
DROp TABLE IF EXISTS tsoc_report_bak;
SELECT * INTO tsoc_report_bak FROM tsoc_report;
DROp TABLE IF EXISTS "public"."work_order" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_alarm_info" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_attachment" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_comment" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_config" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_content" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_field" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_msg_error" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_notifierid" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_notify_flag" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_operation" CASCADE ;
DROP TABLE IF EXISTS "public"."work_order_relation";
DROP TABLE IF EXISTS "public"."work_order_update";
DROP TABLE IF EXISTS "public"."work_order_user_config";
DROP TABLE IF EXISTS "public"."work_order_user_update";
DROP TABLE IF EXISTS "public"."work_order_view";
DROP TABLE IF EXISTS "public"."workorder_config_verify_info";
DROP TABLE IF EXISTS "public"."workorder_content";
DROP TABLE IF EXISTS "public"."workorder_display_fields";
DROP TABLE IF EXISTS "public"."workorder_vul_info";
delete from "flyway_history_table_workorder-service" where installed_rank >1;
delete from "flyway_history_table_alarmInPg-service" where installed_rank >1;
创建topic
切换到kafka目录: cd /opt/xinghai/kafka/software/kafka/bin/
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_attack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_ioc --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_virus --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.flow_td_webattack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.heartdata --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.ngsoc_alert_info --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_webattack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_virus --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_ioc --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.td_attack --partitions 6 --replication-factor 2
sh kafka-topics.sh --create --zookeeper localhost:2181 --topic tsoc.sendsummarydata --partitions 3 --replication-factor 2
sh kafka-topics.sh --zookeeper localhost:2181 --create --replication-factor 3 --partitions 1 --topic tsoc.audit
sh kafka-topics.sh --zookeeper localhost:2181 --create --replication-factor 3 --partitions 2 --topic tsoc.advice
sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 1 --topic project-service-change
sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 1 --topic project-service-terminate
sh kafka-topics.sh --create --zookeeper 127.0.0.1:2181 --replication-factor 3 --partitions 2 --topic workerOrderReport



