MySQL schema sig_class - duplicate index

[Vipul M Sawant <vipul.sawant () gmail com>]

Hello,

The mysql schema version 1.07 (vseq = 107) contains following defination for
sig_class table.

CREATE TABLE sig_class ( sig_class_id        INT    UNSIGNED NOT NULL
AUTO_INCREMENT,
                         sig_class_name      VARCHAR(60) NOT NULL,
                         PRIMARY KEY (sig_class_id),
                         INDEX       (sig_class_id),
                         INDEX       (sig_class_name));


Here, the sig_class_id field is a primary key. Also Index is also created
for the same field. For MySQL table the primary key functions like an index
with additional constraint that only unique values will be stored. The INDEX
(sig_class_id) is redundant.

Is the INDEX (sig_class_id) added for compatibility with other database
systems or older versions?

Thanks,
Vipul

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users