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

diff --git a/src/os_dbd/mysql.schema b/src/os_dbd/mysql.schema
index c8fa067..e5f1aeb 100644
--- 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
-# 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
@@ -75,8 +75,11 @@ CREATE TABLE data
     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 
     (
@@ -89,6 +92,7 @@ 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),