-# @(#) $Id: mysql.schema,v 1.8 2009/06/24 17:06:30 dcid Exp $ */
+# @(#) $Id$ */
#
# 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
(