[MYSQL] dodanie indexu Opcje

[jancu]

witam.

mam tabele, ktora zostala utworzona nastepujacym poleceniem:

[SQL] pobierz, plaintext 
CREATE TABLE `namemap` (
  `info_hash` varchar(40) NOT NULL DEFAULT '',
  `filename` varchar(250) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `info` varchar(250) NOT NULL DEFAULT '',
  `data` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `size` bigint(20) NOT NULL DEFAULT '0',
  `comment` text,
  `category` int(10) UNSIGNED NOT NULL DEFAULT '6',
  `external` enum('yes','no') NOT NULL DEFAULT 'no',
  `announce_url` varchar(100) NOT NULL DEFAULT '',
  `uploader` int(10) NOT NULL DEFAULT '1',
  `lastupdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `anonymous` enum('true','false') NOT NULL DEFAULT 'false',
  `lastsuccess` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  (`info_hash`),
  KEY `filename` (`filename`),
  KEY `category` (`category`),
  KEY `uploader` (`uploader`)
) TYPE=MyISAM;
[SQL] pobierz, plaintext 

ma ona juz wiele wpisow. jak teraz dodac do tej tabeli jakis index autoincrement?

[melkorm]

Bo możesz mieć tylko 1 pole podstawowe,a pole auto_increment (jak sypie błędem mysql) musi być primary.