X-Git-Url: http://ftp.carnet.hr/carnet-debian/scm?p=ossec-hids.git;a=blobdiff_plain;f=src%2Fos_dbd%2Fpostgresql.schema;h=73736a5698ad90249becc5c01ccd7f6e3f087e0c;hp=6544d95e8c290518b73a0cec1a9a8f00ef4fc212;hb=6ef2f786c6c8ead94841b5f93baf9f43421f08c8;hpb=914feba5d54f979cd5d7e69c349c3d01f630042a

diff --git a/src/os_dbd/postgresql.schema b/src/os_dbd/postgresql.schema
index 6544d95..73736a5 100644
--- a/src/os_dbd/postgresql.schema
+++ b/src/os_dbd/postgresql.schema
@@ -1,11 +1,11 @@
--- @(#) $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
@@ -91,6 +91,7 @@ CREATE TABLE alert
     dst_ip          INT8,
     src_port        INT4,
     dst_port        INT4,
+    alertid         TEXT        DEFAULT NULL,
     PRIMARY KEY (id, server_id)
     );
 CREATE INDEX time on alert(timestamp);