-CREATE INDEX time on alert(timestamp);
-CREATE INDEX ruleid on alert(rule_id);
-CREATE INDEX src_ip on alert(src_ip);
-
+CREATE INDEX alertid on alert(alertid);
+CREATE INDEX alert_level on alert(level);
+CREATE INDEX timestamp on alert(timestamp);
+CREATE INDEX alert_rule_id on alert(rule_id);
+CREATE INDEX src_ip on alert(src_ip);
+CREATE INDEX tld on alert(tld);
+