[mholtum]

Ok, I was ablew to get all of the queries to work except the first one. When I run it I get this error:

SQL-query: 

CREATE TABLE affiliatesaffiliate_id int( 10 ) NOT NULL AUTO_INCREMENT ,
sitename varchar( 50 ) NOT NULL ,
siteurl varchar( 250 ) NOT NULL ,
sitedesc mediumtext NOT NULL ,
buttonurl varchar( 150 ) NOT NULL ,
TYPE tinyint( 4 ) NOT NULL ,
email varchar( 250 ) NOT NULL ,
clicksout int( 20 ) NOT NULL ,
clicksin int( 20 ) NOT NULL ,
active tinyint( 4 ) NOT NULL ,
totalrating bigint( 20 ) NOT NULL ,
totalvotes bigint( 20 ) NOT NULL ,
approved tinyint( 4 ) NOT NULL ,
PRIMARY KEY ( affiliate_id ) ,
KEY sitename( sitename ) ,
KEY siteurl( siteurl ) ,
KEY email( email )

MySQL said:  

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'affiliate_id int(10) NOT NULL auto_increment,
     sitename varch