Page History

-- eaglesitedesc_eaglesitedesc
drop table eaglesitedesc_eaglesitedesc;
create table eaglesitedesc_eaglesitedesc(uuid varchar(100), timestamp bigint, site varchar(100),enabled bool);
 
-- eagleapplicationdesc_eagleapplicationdesc
drop table eagleapplicationdesc_eagleapplicationdesc;
create table eagleapplicationdesc_eagleapplicationdesc(`uuid` varchar(100), `timestamp` bigint, application varchar(100),`desc` varchar(1024), `alias` varchar(100), `group` varchar(100), `features` varchar(1024), `config` varchar(1024));


-- alertdatasource
drop table alertdatasource_alertdatasource;
create table alertdatasource_alertdatasource(uuid varchar(100), timestamp bigint, enabled bool, config varchar(1000), description varchar(100), site varchar(10),datasource varchar(100));
 
-- alertstream
drop table alertstream_alertstream;
create table alertstream_alertstream(uuid varchar(100), timestamp bigint, datasource varchar(100), streamname varchar(100), description varchar(200));
insert into alertstream_alertstream(uuid, timestamp, datasource, streamname, description) values("uuid-1",  0, 'hdfsAuditLog', "hiveAccessLogStream", "alert event stream from hdfs audit log");
 
-- alertdef_alertdef
drop table alertdef_alertdef;
create table alertdef_alertdef(uuid varchar(100), timestamp bigint, site varchar(100), datasource varchar(100), alertexecutorid varchar(100), policyid varchar(100), policytype varchar(100), description varchar(200), policydef varchar(1000), dedupedef varchar(1000), notificationdef varchar(1000), remediationdef varchar(1000), enabled bool, owner varchar(100), lastmodifieddate bigint, severity bigint, createdtime bigint);
insert into alertdef_alertdef(uuid, timestamp, site, datasource, alertexecutorid, policyid, policytype, description, policydef, dedupedef, notificationdef, remediationdef, enabled, owner, lastmodifieddate, severity, createdtime) values("uuid-1", 0, "sandbox", "hdfsAuditLog", "testalertexecutorid", "testpolicyid", "siddhiCEPEngine", "testdescription", "{\"expression\":\"from teststream[(testattrname == 'testvalue')] select * insert into outputStream;\",\"type\":\"siddhiCEPEngine\"}", "","","",true,"testowner", 0, 0, 0);
 
-- alertexecutor
drop table alertexecutor_alertexecutor;
create table alertexecutor_alertexecutor(uuid varchar(100), timestamp bigint, datasource varchar(100), alertexecutorid varchar(100), streamname varchar(100), description varchar(100));
insert into alertexecutor_alertexecutor(uuid, timestamp, datasource, alertexecutorid, streamname, description) values ("uuid-1", 0, "hdfsAuditLog", "testalertexecutorid", "teststream", "testdesc");
 
-- alertdetail
drop table alertdetail_hadoop;
create table alertdetail_hadoop(uuid varchar(100), timestamp bigint, site varchar(100), datasource varchar(100), hostname varchar(100), policyid varchar(100), alertsource varchar(100), sourcestreams varchar(100),  alertexecutorid varchar(100), description varchar(100), remediationid varchar(100), remediationcallback varchar(100), alertcontext varchar(1000), streamid varchar(100));
insert into alertdetail_hadoop(uuid, timestamp, site, datasource, hostname, policyid, alertsource, sourcestreams, alertexecutorid, description, remediationid, remediationcallback, alertcontext, streamid) values("uuid-1", 0, "sandbox", "hdfsAuditLog", "testhost", 'testpolicyid', "testalertsource", "testsourcestreams", "testalertexecutorid", "testdesc", "", "", "", "teststreamid");
 
-- alertstreamschema
drop table alertstreamschema_alertstreamschema;
create table alertstreamschema_alertstreamschema(uuid varchar(100), timestamp bigint, datasource varchar(100), streamname varchar(100), attrname varchar(100), attrtype varchar(20), category varchar(20), attrValueResolver varchar(100), usedastag bool, attrdescription varchar(100), attrdisplayname varchar(100), defaultvalue varchar(100));
insert into alertstreamschema_alertstreamschema(uuid, timestamp, datasource, streamname, attrname, attrtype, category, attrValueResolver, usedastag, attrdescription, attrdisplayname, defaultvalue) values("uuid-1", 0, "hdfsAuditLog", "teststream", "testattrname", "string", "testcategory", "testattrvalueresolver", "testusedastag", "testattrdescription", "testattrdisplayname", "testdefaultvalue");