error when sql for mod get_1_free_1.2.zip

[ATise]

I am installing the get_1_free_1.2.zip mod but when I try to install the QSL for this mod I get the following message:

 

SQL query:

 

CREATE TABLE `get_1_free` (

 

`get_1_free_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`products_id` int( 11 ) NOT NULL default '0',

`products_qualify_quantity` int( 11 ) NOT NULL default '0',

`products_multiple` int( 11 ) NOT NULL default '0',

`products_free_id` int( 11 ) NOT NULL default '0',

`products_free_quantity` int( 11 ) NOT NULL default '0',

`get_1_free_date_added` datetime default NULL ,

`get_1_free_last_modified` datetime default NULL ,

`get_1_free_expires_date` datetime default NULL ,

`date_status_change` datetime default NULL ,

`status` int( 1 ) NOT NULL default '1',

PRIMARY KEY ( `get_1_free_id` )

) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 14

 

 

Can someone help. Am I loading it to the wrong place to create the file or is there an error in the SQL file. Or maybe I have missed a set.

[Roaddoctor]

try this

 

CREATE TABLE `get_1_free` (
 `get_1_free_id` int(11) NOT NULL auto_increment,
 `products_id` int(11) NOT NULL default '0',
 `products_qualify_quantity` int(11) NOT NULL default '0',
 `products_multiple` int(11) NOT NULL default '0',
 `products_free_id` int(11) NOT NULL default '0',
 `products_free_quantity` int(11) NOT NULL default '0',
 `get_1_free_date_added` datetime default NULL,
 `get_1_free_last_modified` datetime default NULL,
 `get_1_free_expires_date` datetime default NULL,
 `date_status_change` datetime default NULL,
 `status` int(1) NOT NULL default '1',
 PRIMARY KEY  (`get_1_free_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;