USE THIS.

================================

Database Modifications:

Add Configuration Group:

INSERT INTO `configuration_group` VALUES ('', 'Free Gift', 'Free Gift Configuration', '17', '1');

Please get the configuration_id that the db has generated, as it will be required for the next step! AND CHECK THE LAST configuration_id IN configuration AND add in LAST1 and LAST2 below.
example your last number is 143, you add in 144 and 145.

Add Configuration Items:

Please replace 'ID' with the id generated from stage 1


INSERT INTO `configuration` VALUES ('LAST1', 'Minimum Spend', 'FREE_GIFT_MINIMUM_SPEND', '30.00', 'Minimum Spend to Qualify For The Free Gift', '16', '1', '2007-08-08 15:24:50', '2007-08-07 19:16:00', null, null);

INSERT INTO `configuration` VALUES ('LAST2', 'Free Gift Category', 'FREE_GIFT_CATEGORY', '96', 'The category that contains all of the potentially free items', '16', '2', '2007-08-11 11:02:05', '2007-08-07 19:16:00', 'tep_cfg_get_cat_name', 'tep_cfg_pull_down_cat_list(');


Add Free Gift Orders Table

CREATE TABLE `orders_freegift` (
`orders_freegift_id` int(11) NOT NULL auto_increment,
`orders_id` int(11) default NULL,
`products_id` int(11) default NULL,
`products_model` varchar(12) default NULL,
`products_name` varchar(64) default NULL,
PRIMARY KEY (`orders_freegift_id`)
) TYPE=MyISAM;




Database Modifications Complete

More...