Comments on: Setting up the database for postfix http://switch.richard5.net How to build your Mac into a internet server using open source software Tue, 17 Jun 2008 18:25:42 +0000 hourly 1 http://wordpress.org/?v=3.2.1 By: Jeff Stubbs http://switch.richard5.net/isp-in-a-box-using-a-mac-mini/configuring-the-mail-server/setting-up-the-database-for-postfix/comment-page-1/#comment-38 Jeff Stubbs Wed, 28 Dec 2005 02:04:05 +0000 http://switch.richard5.net/isp-in-a-box-using-a-mac-mini/configuring-the-mail-server/setting-up-the-database-for-postfix/#comment-38 Greetings, I took the text of this page, stripped out the comments, just leaving the sql commands (ispinabox.sql). Using phpMyAdmin, I ran the sql file, and then checked the created tables. All the tables with both the 'PRIMARY KEY' and 'KEY' entries, resulted in this warning message: PRIMARY and INDEX keys should not both be set for column `offending column name` in phpMyAdmin. Not being a MySQL expert, I figured I'd raise a red flag. Something to worry about? Greetings,

I took the text of this page, stripped out the comments, just leaving the sql commands (ispinabox.sql). Using phpMyAdmin, I ran the sql file, and then checked the created tables. All the tables with both the ‘PRIMARY KEY’ and ‘KEY’ entries, resulted in this warning message: PRIMARY and INDEX keys should not both be set for column `offending column name` in phpMyAdmin. Not being a MySQL expert, I figured I’d raise a red flag.

Something to worry about?

]]>