projects
/
ossec-hids.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
- fortify/harden the compile
[ossec-hids.git]
/
src
/
os_dbd
/
mysql.schema
diff --git
a/src/os_dbd/mysql.schema
b/src/os_dbd/mysql.schema
index
c8fa067
..
e5f1aeb
100644
(file)
--- a/
src/os_dbd/mysql.schema
+++ b/
src/os_dbd/mysql.schema
@@
-1,11
+1,11
@@
-# @(#) $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
#
# 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
# Foundation.
#
# License details at the LICENSE file included with OSSEC or
@@
-75,8
+75,11
@@
CREATE TABLE data
server_id SMALLINT UNSIGNED NOT NULL,
user TEXT NOT NULL,
full_log TEXT NOT NULL,
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
(
CREATE TABLE alert
(
@@
-89,6
+92,7
@@
CREATE TABLE alert
dst_ip INT UNSIGNED,
src_port SMALLINT UNSIGNED,
dst_port SMALLINT UNSIGNED,
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),
PRIMARY KEY (id, server_id),
INDEX time (timestamp),
INDEX (rule_id),