[php_mysql] mysql table help

[Wade Smart]

12062006 1947 GMT-6

Im working on a tutorial and Im a bit confused. 
Im using phpmysadmin 2.8.1 and I have this column titled Collation -
which I have not seen before. I just installed mysql and phpmyadmin on
this new computer so I just a bit confused as to what that is. Its
apparently set to default to latin1_swidish_ci. 

I can set the primary key but the KEY 'name' ('name'), is that the
Unique or Index keys?

Also, on TYPE=MyISAM, how do you set up Auto_increment=2?

wade

CREATE TABLE `people` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `street1` varchar(70) NOT NULL default '',
  `street2` varchar(70) NOT NULL default '',
  `city` varchar(70) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;