Auto Increment columns are not displayed or exported properly

To reproduce the problem, create a new table called "test" in any database and 
add the fields 
test_id (int) as an auto incrementing primary key and another field called 
test_data as a varchar. 
First of all, note that there is no indication that the column is auto 
incrementing on the table 
structure edit page. Next, export the test table as SQL. You will get output 
like this:

CREATE TABLE `test` (
   `test_id` int(11),
   `test_data` varchar(100),
   PRIMARY KEY (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET latin1;

Notice that the auto increment data is missing. Export the exact same table 
through 
PHPMyAdmin and you get this:

CREATE TABLE `test` (
  `test_id` int(11) NOT NULL auto_increment,
  `test_data` varchar(100) default NULL,
  PRIMARY KEY  (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

The data is there, it just doesn't show up on the export. Results are unchanged 
if you drop the 
column and recreate it. It is always properly made, it just does not appear in 
the export. This was 
tested on the latest version of SQLBuddy as of this date (Feb 11, 2009). My 
computer is a Mac 
and SQLBuddy is running through MAMP. As a side note, it might be good to 
expose the version 
number on the home page for bug reports. Keep up the great work!

Original issue reported on code.google.com by barnabas...@gtempaccount.com on 11 Feb 2009 at 9:38

mattyhead / sql-buddy

Auto Increment columns are not displayed or exported properly #22