Simple Table Creation Instructions

[Guest]

I'm trying to install oscAffiliate and am having a heck of a time creating tables properly. Through intense study in the forums and google, I've come up with no step by step instruction on the procedure for creating tables. Can someone walk me through creating the following table in phpmyadmin?

 

DROP TABLE IF EXISTS affiliate_clickthroughs;
CREATE TABLE affiliate_clickthroughs (
 affiliate_clickthrough_id int(11) NOT NULL auto_increment,
 affiliate_id int(11) NOT NULL default '0',
 affiliate_clientdate datetime NOT NULL default '0000-00-00 00:00:00',
 affiliate_clientbrowser varchar(200) default 'Could Not Find This Data',
 affiliate_clientip varchar(50) default 'Could Not Find This Data',
 affiliate_clientreferer varchar(200) default 'none detected (maybe a direct link)',
 affiliate_products_id int(11) default '0',
 affiliate_banner_id int(11) NOT NULL default '0',
 PRIMARY KEY  (affiliate_clickthrough_id),
 KEY refid (affiliate_id)
);

 

Furthermore, I need help creating the following parameters in some tables. Instructions would be greatly appreciated!

 

KEY idx_affiliate_payment_status_name (affiliate_payment_status_name)

 

And finally...

 

TYPE=MyISAM AUTO_INCREMENT=3

[Guest]

I figured this out.

[Lao]

How? I have the same problem.