--- @(#) $Id: postgresql.schema,v 1.4 2009/06/24 17:06:30 dcid Exp $ */
+-- @(#) $Id: ./src/os_dbd/postgresql.schema, 2011/09/08 dcid Exp $
--
-- 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 3) as published by the FSF - Free Software
+-- License (version 2) as published by the FSF - Free Software
-- Foundation.
--
-- License details at the LICENSE file included with OSSEC or
dst_ip INT8,
src_port INT4,
dst_port INT4,
+ alertid TEXT DEFAULT NULL,
PRIMARY KEY (id, server_id)
);
CREATE INDEX time on alert(timestamp);