Use TopicConfig in backend

[dcaegen2/services.git] / components / datalake-handler / feeder / src / assembly / scripts / init_db.sql

diff --git a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql
index 44f4ef1..e201242 100644 (file)
--- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql
+++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql
@@ -11,10 +11,7 @@ CREATE TABLE `topic` (
   `save_raw` bit(1) DEFAULT NULL,\r
   `ttl` int(11) DEFAULT NULL,\r
   `data_format` varchar(255) DEFAULT NULL,\r
-  `default_topic` varchar(255) DEFAULT NULL,\r
-  PRIMARY KEY (`name`),\r
-  KEY `FK_default_topic` (`default_topic`),\r
-  CONSTRAINT `FK_default_topic` FOREIGN KEY (`default_topic`) REFERENCES `topic` (`name`)\r
+  PRIMARY KEY (`name`)\r
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r
 \r
 \r
@@ -52,7 +49,7 @@ insert into db (`name`,`host`) values ('Druid','dl_druid');
 -- in production, default enabled should be off\r
 insert into `topic`(`name`,`enabled`,`save_raw`,`ttl`,`data_format`) values ('_DL_DEFAULT_',1,0,3650,'JSON');\r
 insert into `topic`(`name`,`enabled`) values ('__consumer_offsets',0);\r
-insert into `topic`(`name`,correlate_cleared_message,`enabled`,default_topic, message_id_path) values ('unauthenticated.SEC_FAULT_OUTPUT',1,0,'_DL_DEFAULT_', '/event/commonEventHeader/eventName,/event/commonEventHeader/reportingEntityName,/event/faultFields/specificProblem');\r
+insert into `topic`(`name`,correlate_cleared_message,`enabled`, message_id_path) values ('unauthenticated.SEC_FAULT_OUTPUT',1,0,'/event/commonEventHeader/eventName,/event/commonEventHeader/reportingEntityName,/event/faultFields/specificProblem');\r
 \r
 \r
 insert into `map_db_topic`(`db_name`,`topic_name`) values ('Couchbase','_DL_DEFAULT_');\r