2
this is the correct sql command:
CREATE TABLE banner (
bid smallint(5) unsigned NOT NULL auto_increment,
cid tinyint(3) unsigned NOT NULL default '0',
imptotal mediumint(8) unsigned NOT NULL default '0',
impmade mediumint(8) unsigned NOT NULL default '0',
clicks mediumint(8) unsigned NOT NULL default '0',
imageurl varchar(255) NOT NULL default '',
clickurl varchar(255) NOT NULL default '',
date int(10) NOT NULL default '0',
htmlbanner tinyint(1) NOT NULL default '0',
htmlcode text NOT NULL,
PRIMARY KEY (bid),
KEY idxbannercid (cid),
KEY idxbannerbidcid (bid,cid)
) TYPE=MyISAM;
