1 -- @(#) $Id: postgresql.schema,v 1.4 2009/06/24 17:06:30 dcid Exp $ */
3 -- Copyright (C) 2009 Trend Micro Inc.
4 -- All rights reserved.
6 -- This program is a free software; you can redistribute it
7 -- and/or modify it under the terms of the GNU General Public
8 -- License (version 3) as published by the FSF - Free Software
11 -- License details at the LICENSE file included with OSSEC or
12 -- online at: http://www.ossec.net/en/licensing.html
19 cat_id SERIAL NOT NULL,
20 cat_name VARCHAR(32) NOT NULL UNIQUE,
23 CREATE INDEX cat_name ON category (cat_name);
25 CREATE TABLE signature
28 rule_id INT8 NOT NULL UNIQUE,
30 description VARCHAR(255) NOT NULL,
33 CREATE INDEX level ON signature (level);
34 CREATE INDEX rule_id ON signature (rule_id);
36 CREATE TABLE signature_category_mapping
39 rule_id INT8 NOT NULL,
41 PRIMARY KEY (id, rule_id, cat_id)
47 last_contact INT8 NOT NULL,
48 version VARCHAR(32) NOT NULL,
49 hostname VARCHAR(64) NOT NULL UNIQUE,
50 information VARCHAR(128) NOT NULL,
57 server_id INT8 NOT NULL,
58 last_contact INT8 NOT NULL,
59 ip_address INT8 NOT NULL,
60 version VARCHAR(32) NOT NULL,
61 name VARCHAR(64) NOT NULL,
62 information VARCHAR(128) NOT NULL,
63 PRIMARY KEY (id, server_id)
69 server_id INT8 NOT NULL,
70 name VARCHAR(128) NOT NULL,
71 PRIMARY KEY (id, server_id)
77 server_id INT4 NOT NULL,
79 full_log TEXT NOT NULL,
80 PRIMARY KEY (id, server_id)
86 server_id INT4 NOT NULL,
87 rule_id INT8 NOT NULL,
88 timestamp INT8 NOT NULL,
89 location_id INT4 NOT NULL,
94 PRIMARY KEY (id, server_id)
96 CREATE INDEX time on alert(timestamp);
97 CREATE INDEX ruleid on alert(rule_id);
98 CREATE INDEX src_ip on alert(src_ip);