If you're using the Install SQL Patches, the backticks should be removed, too
Code:
# Add the following to your database via Zen Cart Admin.
# NOTE...IF YOU USE A DATABASE PREFIX YOU MUST ADD IT INTO THESE TABLE UPDATES - FOR EXAMPLE:
# If your db prefix is zen_, then change
# CREATE TABLE free_gifts (
# to
# CREATE TABLE zen_free_gifts (
CREATE TABLE free_gifts (
gift_id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
threshold mediumint( 9 ) NOT NULL default '0',
products_id mediumint( 9 ) NOT NULL default '0',
PRIMARY KEY ( gift_id )
) ENGINE= MyISAM ;
Bookmarks