Snort mailing list archives
MySQL schema sig_class - duplicate index
From: Vipul M Sawant <vipul.sawant () gmail com>
Date: Tue, 5 Jan 2010 19:22:54 +0530
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
Current thread:
- MySQL schema sig_class - duplicate index Vipul M Sawant (Jan 05)