Quote Originally Posted by BlessIsaacola View Post
Andrew,
I am wondering if you can provide the best way to update our database. I noticed both your new.sql and the update.sql are the same file.

What's the best approach to just update our database with new configuration. It looks to me like this last line is the only thing new since last update:

Code:
REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
values (NULL, 'Advanced Reward Point Calculation Rules', 'REWARD_POINTS_ADVANCED_CALCULATE_TABLE', '-ot_gv,-ot_coupon', 'Advanced configuration of Reward Point calculations. This will be the figure that total Reward Points are adjusted by. This also affects the maximum value that any points can be redeemed against.', @group_id, '14', NULL, now(), 'UseRewardPointAdvancedCalculateTableFunction', 'SetRewardPointAdvancedCalculateTableFunction(');
I think the update.sql has a couple of IGNOREs but apart from that you are right. If you a updating from v1.27a then you don't have to apply the sql patch as there has been no changes to the tables.