REDROOM

Navigation

Breadcrumbs

Create

Preview: postgresql.schema Size: 2.93 KB

//usr/share/ossec/contrib/postgresql.schema

-- Copyright (C) 2009 Trend Micro Inc.
-- All rights reserved.
--
-- This program is a free software; you can redistribute it
-- and/or modify it under the terms of the GNU General Public
-- License (version 2) as published by the FSF - Free Software
-- Foundation.

BEGIN;

CREATE TABLE category
    (
    cat_id      SERIAL  NOT NULL,
    cat_name    VARCHAR(32) NOT NULL    UNIQUE,
    PRIMARY KEY (cat_id)
    );
CREATE INDEX cat_name ON category (cat_name);

CREATE TABLE signature
    (
    id          SERIAL          NOT NULL,
    rule_id     INT8           NOT NULL UNIQUE,
    level       INT4,
    description VARCHAR(255)    NOT NULL,
    PRIMARY KEY (id)
    );
CREATE INDEX signature_level ON signature (level);
CREATE INDEX signature_rule_id ON signature (rule_id);

CREATE TABLE signature_category_mapping
    (
    id          SERIAL      NOT NULL,
    rule_id     INT8       NOT NULL,
    cat_id      INT4       NOT NULL,
    PRIMARY KEY  (id, rule_id, cat_id)
    );

CREATE TABLE server
    (
    id              SERIAL               NOT NULL,
    last_contact    INT8                 NOT NULL,
    version         VARCHAR(32)          NOT NULL,
    hostname        VARCHAR(64)          NOT NULL   UNIQUE,
    information     TEXT                 NOT NULL,
    PRIMARY KEY  (id)
    );

CREATE TABLE agent
    (
    id              SERIAL       NOT NULL,
    server_id       INT8         NOT NULL,
    last_contact    INT8         NOT NULL,
    ip_address      VARCHAR(46)  NOT NULL,
    version         VARCHAR(32)  NOT NULL,
    name            VARCHAR(64)  NOT NULL,
    information     VARCHAR(128) NOT NULL,
    PRIMARY KEY  (id, server_id)
    );

CREATE TABLE location
    (
    id              SERIAL          NOT NULL,
    server_id       INT8            NOT NULL,
    name            VARCHAR(128)    NOT NULL,
    PRIMARY KEY  (id, server_id)
    );

CREATE TABLE data
    (
    id              INT8        NOT NULL,
    server_id       INT4        NOT NULL,
    "user"          TEXT        NOT NULL,
    full_log        TEXT        NOT NULL,
    PRIMARY KEY  (id, server_id)
    );

CREATE TABLE alert
    (
     id             bigserial   NOT NULL,
    server_id       INT4        NOT NULL,
    rule_id         INT8        NOT NULL,
    level           INT2,
    timestamp       INT8        NOT NULL,
    location_id     INT4        NOT NULL,
    src_ip          VARCHAR(46),
    dst_ip          VARCHAR(46),
    src_port        INT4,
    dst_port        INT4,
    alertid         TEXT        DEFAULT NULL,
    "user"          TEXT,
    full_log        TEXT        NOT NULL,
    is_hidden       INT2        NOT NULL DEFAULT '0',
    tld             VARCHAR(32)  NOT NULL DEFAULT '',
    PRIMARY KEY (id, server_id)
    );
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);

COMMIT;

Name	Size	Perms	Modified	Actions
active-list.pl	2.66 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
add_localfile.sh	787 B	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
compile_alerts.pl	2.97 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
compile_alerts.txt	8.81 KB	lrw-r-----	2025-10-01 13:11:36	Edit Download recursive recursive
config2xml	5.31 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
mysql.schema	2.97 KB	lrw-r--r--	2025-10-01 13:11:36	Edit Download recursive recursive
ossec-batch-manager.pl	10.69 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossec-eps.sh	853 B	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossec-pcre2-config.pl	1.88 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossec2mysql.conf	188 B	lrw-r-----	2025-10-01 13:11:36	Edit Download recursive recursive
ossec2mysql.pl	14.12 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossec2mysql.sql	2.69 KB	lrw-r-----	2025-10-01 13:11:36	Edit Download recursive recursive
ossec2mysqld.pl	14.80 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossecmysql.pm	1.73 KB	lrw-r-----	2025-10-01 13:11:36	Edit Download recursive recursive
ossectop.pl	7.02 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
ossec_report.txt	1.04 KB	lrw-r-----	2025-10-01 13:11:36	Edit Download recursive recursive
ossec_report_contrib.pl	4.93 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
postgresql.schema	2.93 KB	lrw-r--r--	2025-10-01 13:11:36	Edit Download recursive recursive
rename_agent.sh	1.30 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
renumber_agent.sh	1.26 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
util.sh	4.40 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive
version_bump.sh	1.24 KB	lrwxr-x---	2025-10-01 13:11:36	Edit Download recursive recursive

Directory Contents