1 -- Copyright (C) 2009 Trend Micro Inc.
2 -- All rights reserved.
4 -- This program is a free software; you can redistribute it
5 -- and/or modify it under the terms of the GNU General Public
6 -- License (version 2) as published by the FSF - Free Software
13 cat_id SERIAL NOT NULL,
14 cat_name VARCHAR(32) NOT NULL UNIQUE,
17 CREATE INDEX cat_name ON category (cat_name);
19 CREATE TABLE signature
22 rule_id INT8 NOT NULL UNIQUE,
24 description VARCHAR(255) NOT NULL,
27 CREATE INDEX signature_level ON signature (level);
28 CREATE INDEX signature_rule_id ON signature (rule_id);
30 CREATE TABLE signature_category_mapping
33 rule_id INT8 NOT NULL,
35 PRIMARY KEY (id, rule_id, cat_id)
41 last_contact INT8 NOT NULL,
42 version VARCHAR(32) NOT NULL,
43 hostname VARCHAR(64) NOT NULL UNIQUE,
44 information TEXT NOT NULL,
51 server_id INT8 NOT NULL,
52 last_contact INT8 NOT NULL,
53 ip_address VARCHAR(46) NOT NULL,
54 version VARCHAR(32) NOT NULL,
55 name VARCHAR(64) NOT NULL,
56 information VARCHAR(128) NOT NULL,
57 PRIMARY KEY (id, server_id)
63 server_id INT8 NOT NULL,
64 name VARCHAR(128) NOT NULL,
65 PRIMARY KEY (id, server_id)
71 server_id INT4 NOT NULL,
73 full_log TEXT NOT NULL,
74 PRIMARY KEY (id, server_id)
79 id bigserial NOT NULL,
80 server_id INT4 NOT NULL,
81 rule_id INT8 NOT NULL,
83 timestamp INT8 NOT NULL,
84 location_id INT4 NOT NULL,
89 alertid TEXT DEFAULT NULL,
91 full_log TEXT NOT NULL,
92 is_hidden INT2 NOT NULL DEFAULT '0',
93 tld VARCHAR(32) NOT NULL DEFAULT '',
94 PRIMARY KEY (id, server_id)
96 CREATE INDEX alertid on alert(alertid);
97 CREATE INDEX alert_level on alert(level);
98 CREATE INDEX timestamp on alert(timestamp);
99 CREATE INDEX alert_rule_id on alert(rule_id);
100 CREATE INDEX src_ip on alert(src_ip);
101 CREATE INDEX tld on alert(tld);