mysql mi javi napako

ko hocem naloziti bazo podatkov na hosterja mi javi sledece

Napaka

SQL-poizvedba :

CREATE TABLE e107_banner(
banner_id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
banner_clientname varchar( 100 ) NOT NULL ,
banner_clientlogin varchar( 20 ) NOT NULL ,
banner_clientpassword varchar( 50 ) NOT NULL ,
banner_image varchar( 150 ) NOT NULL ,
banner_clickurl varchar( 150 ) NOT NULL ,
banner_impurchased int( 10 ) unsigned NOT NULL ,
banner_startdate int( 10 ) unsigned NOT NULL ,
banner_enddate int( 10 ) unsigned NOT NULL ,
banner_active tinyint( 1 ) unsigned NOT NULL ,
banner_clicks int( 10 ) unsigned NOT NULL ,
banner_impressions int( 10 ) unsigned NOT NULL ,
banner_ip text NOT NULL ,
banner_campaign varchar( 150 ) NOT NULL
)

MySQL je vrnil:

#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

[Dokumentacija] · [Nazaj]

kaj delam narobe?

sem zrihtal
hvala ti.
ajde