-# @(#) $Id: mysql.schema,v 1.8 2009/06/24 17:06:30 dcid Exp $ */
+# @(#) $Id: ./src/os_dbd/mysql.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
server_id SMALLINT UNSIGNED NOT NULL,
user TEXT NOT NULL,
full_log TEXT NOT NULL,
- PRIMARY KEY (id, server_id)
+ timestamp TIMESTAMP NOT NULL,
+ PRIMARY KEY (id, server_id),
+ INDEX time (timestamp)
);
+
CREATE TABLE alert
(
dst_ip INT UNSIGNED,
src_port SMALLINT UNSIGNED,
dst_port SMALLINT UNSIGNED,
+ alertid TINYTEXT DEFAULT NULL,
PRIMARY KEY (id, server_id),
INDEX time (timestamp),
INDEX (rule_id),