[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ossec-cvs] ossec-hids: mysql.schema (HEAD) [dcid]



Module name:	ossec-hids
Changes by:	dcid	07/08/19 10:32:12

Modified files:
	mysql.schema

Log message:
Description: Small change to the db schema.
Reviewed by: dcid
Bug:

Index: mysql.schema
===================================================================
RCS file: /usr/cvsroot/ossec-hids/src/os_dbd/mysql.schema,v
diff -u -r1.3 -r1.4
--- mysql.schema	18 Aug 2007 03:38:34 -0000	1.3
+++ mysql.schema	19 Aug 2007 13:32:11 -0000	1.4
@@ -75,8 +75,9 @@
     dst_ip          INT         UNSIGNED,
     src_port        SMALLINT    UNSIGNED,
     dst_port        SMALLINT    UNSIGNED,
-    PRIMARY KEY (id, rule_id, server_id),
+    PRIMARY KEY (id, server_id),
     INDEX       time (timestamp),
+    INDEX       (rule_id),
     INDEX       (src_ip)
     );
     


OSSEC home | Main Index | Thread Index


OSSEC project: www.ossec.net.
Mailling list information: http://www.ossec.net/en/mailing_lists.html.