The CREATE TABLE is there for completeness. Also if you upgrade from a version prior to v1.03a then it's a requirement. Unfortunately MySQL does not have a IF TABLE NOT EXIST directive. Don't worry about it, it will fail gracefully.
To just apply the single change for this version copy and paste the following into Admin->Tools->SQL Patch.
PHP Code:
SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';
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 , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);
Bookmarks