eagle-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jjt...@apache.org
Subject eagle git commit: [MINOR] Add analysis_jobs, analysis_email metadata into metadata-ddl file
Date Thu, 16 Mar 2017 07:54:58 GMT
Repository: eagle
Updated Branches:
  refs/heads/master b1f6b3528 -> b31b5470e


[MINOR] Add analysis_jobs, analysis_email metadata into metadata-ddl file

Author: chitin <chitin1027@gmail.com>

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 <chitin1027@gmail.com>
Authored: Thu Mar 16 07:54:42 2017 +0000
Committer: r7raul1984 <tangjijun@yhd.com>
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"}]}'),


Mime
View raw message