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 LASTconfiguration_id IN configuration AND add in LAST1 and LAST2 below.
example your last number is 143, you add in 144 and 145.

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

Add Configuration Items:


INSERT INTO `configuration` VALUES ('LAST1', 'Minimum Spend', 'FREE_GIFT_MINIMUM_SPEND', '30.00', 'Minimum Spend to Qualify For The Free Gift', 'ID', '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', 'ID', '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...