Repository: eagle Updated Branches: refs/heads/master b1f6b3528 -> b31b5470e
[MINOR] Add analysis_jobs, analysis_email metadata into metadata-ddl file Author: chitin <[email protected]> Closes #878 from chitin/sqlfix. Project: http://git-wip-us.apache.org/repos/asf/eagle/repo Commit: http://git-wip-us.apache.org/repos/asf/eagle/commit/b31b5470 Tree: http://git-wip-us.apache.org/repos/asf/eagle/tree/b31b5470 Diff: http://git-wip-us.apache.org/repos/asf/eagle/diff/b31b5470 Branch: refs/heads/master Commit: b31b5470ec8a58fc97b7b02909cf69221c50eda0 Parents: b1f6b35 Author: chitin <[email protected]> Authored: Thu Mar 16 07:54:42 2017 +0000 Committer: r7raul1984 <[email protected]> Committed: Thu Mar 16 07:54:42 2017 +0000 ---------------------------------------------------------------------- .../src/main/bin/metadata-ddl.sql | 21 ++++++++++++++++++++ 1 file changed, 21 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/eagle/blob/b31b5470/eagle-server-assembly/src/main/bin/metadata-ddl.sql ---------------------------------------------------------------------- diff --git a/eagle-server-assembly/src/main/bin/metadata-ddl.sql b/eagle-server-assembly/src/main/bin/metadata-ddl.sql index 44101a3..0334623 100644 --- a/eagle-server-assembly/src/main/bin/metadata-ddl.sql +++ b/eagle-server-assembly/src/main/bin/metadata-ddl.sql @@ -144,6 +144,27 @@ CREATE TABLE IF NOT EXISTS alert_event ( alertData mediumtext DEFAULT NULL ); +CREATE TABLE IF NOT EXISTS analysis_jobs ( + uuid varchar(50) PRIMARY KEY, + jobDefId varchar(100) NOT NULL, + siteId varchar(50) NOT NULL, + configuration mediumtext NOT NULL, + evaluators mediumtext NOT NULL, + createdtime bigint(20) DEFAULT NULL, + modifiedtime bigint(20) DEFAULT NULL, + UNIQUE (siteId, jobDefId) +); + +CREATE TABLE IF NOT EXISTS analysis_email ( + uuid varchar(50) PRIMARY KEY, + userId varchar(100) NOT NULL, + siteId varchar(50) NOT NULL, + mailAddress mediumtext NOT NULL, + createdtime bigint(20) DEFAULT NULL, + modifiedtime bigint(20) DEFAULT NULL, + UNIQUE (siteId, userId) +); + INSERT INTO publishment_type(id, content) VALUES ('Kafka', '{"name":"Kafka","type":"org.apache.eagle.alert.engine.publisher.impl.AlertKafkaPublisher","description":null,"fields":[{"name":"kafka_broker","value":"sandbox.hortonworks.com:6667"},{"name":"topic"}]}'), ('Email', '{"name":"Email","type":"org.apache.eagle.alert.engine.publisher.impl.AlertEmailPublisher","description":null,"fields":[{"name":"subject"},{"name":"sender"}, {"name":"recipients"}]}'),
