Open zip file and Install Program

Downloaded 'Counter' and opened the zip file.
A Note Book page opened. A portion of the script in it is here:

DROP TABLE IF EXISTS __prefix__hits;
CREATE TABLE __prefix__hits (
hit_id int(11) unsigned NOT NULL auto_increment,
ipaddr int(11) unsigned NOT NULL default '0',
visitor_id int(11) unsigned NOT NULL default '0',
page_id int(11) unsigned NOT NULL default '0',
hitdate datetime NOT NULL default '0000-00-00 00:00:00',
page_gen int(11) unsigned NOT NULL default '0',
page_loaded tinyint(1) unsigned default '0',
PRIMARY KEY (hit_id),
KEY visitor_id (visitor_id,page_id,hitdate,page_gen)
) TYPE=MyISAM;

I have not presented the balance considering the space here.

Please tell me what I do with this and how I should complete the
installation of the program.

Thank you,
ben aloysius