diff options
| author |   Kate Hsuan <kate.hsuan@qct.io> | 2019-05-01 22:30:16 +0800 |
|---|---|---|
| committer | Kate Hsuan <kate.hsuan@qct.io> | 2019-05-07 15:50:18 +0800 |
| commit | 55072522875beca6ed2cc0bc6604369715c2252c (patch) | |
| tree | 6513fd8c7d86c7ed93493494f7232293cc29e97d /components/datalake-handler/feeder/src/assembly | |
| parent | 2920426bd0f8369a178895138e97b0b19372c413 (diff) | |
Add dashboard template configuration schema
Issue-ID: DCAEGEN2-1329
Change-Id: I29ef46a44a61ef7adceeabe6b65d406d07902be2
Signed-off-by: Kate Hsuan <kate.hsuan@qct.io>
Diffstat (limited to 'components/datalake-handler/feeder/src/assembly')
| -rw-r--r-- | components/datalake-handler/feeder/src/assembly/scripts/init_db.sql | 38 |
1 files changed, 38 insertions, 0 deletions
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 e201242d..6688d684 100644 --- a/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql +++ b/components/datalake-handler/feeder/src/assembly/scripts/init_db.sql @@ -17,6 +17,7 @@ CREATE TABLE `topic` ( CREATE TABLE `db` (
`name` varchar(255) NOT NULL,
+ `enabled` bit(1) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
`port` int(11) DEFAULT NULL,
`database_name` varchar(255) DEFAULT NULL,
@@ -39,6 +40,43 @@ CREATE TABLE `map_db_topic` ( CONSTRAINT `FK_db_name` FOREIGN KEY (`db_name`) REFERENCES `db` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+CREATE TABLE `dashboard_template` (
+ `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) NOT NULL,
+ `body` text DEFAULT NULL,
+ `note` text DEFAULT NULL,
+ `topic` varchar(255) DEFAULT NULL,
+ `type` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `FK_topic` (`topic`),
+ KEY `FK_type` (`type`),
+ CONSTRAINT `FK_topic` FOREIGN KEY (`topic`) REFERENCES `topic` (`name`) ON DELETE SET NULL,
+ CONSTRAINT `FK_type` FOREIGN KEY (`type`) REFERENCES `dashboard_type` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `dashboard_type` (
+ `name` varchar(255) NOT NULL,
+ `dashboard` varchar(255) DEFAULT NULL,
+ `note` text DEFAULT NULL,
+ PRIMARY KEY (`name`),
+ KEY `FK_dashboard` (`dashboard`),
+ CONSTRAINT `FK_dashboard` FOREIGN KEY (`dashboard`) REFERENCES `dashboard` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `dashboard` (
+ `name` varchar(255) NOT NULL DEFAULT '',
+ `type` varchar(255) DEFAULT NULL,
+ `address` varchar(500) DEFAULT NULL,
+ `port` int(5) unsigned DEFAULT NULL,
+ `username` varchar(255) DEFAULT NULL,
+ `password` varchar(255) DEFAULT NULL,
+ `related_db` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`name`),
+ KEY `FK_related_db` (`related_db`),
+ CONSTRAINT `FK_related_db` FOREIGN KEY (`related_db`) REFERENCES `db` (`name`) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
insert into db (`name`,`host`,`login`,`pass`,`database_name`) values ('Couchbase','dl_couchbase','dl','dl1234','datalake');
insert into db (`name`,`host`) values ('Elasticsearch','dl_es');
|