Conversion

/* categories */
DELETE FROM configuration WHERE configuration_key = 'SHOW_COUNTS';

/* counter */
DROP TABLE IF EXISTS counter;
DROP TABLE IF EXISTS counter_history;

/* store name */
UPDATE configuration SET configuration_description = 'The name of my store, used online and on printable documents' WHERE configuration_key = 'STORE_NAME';

/* store address */
UPDATE configuration SET configuration_key = 'STORE_ADDRESS'  WHERE configuration_key = 'STORE_NAME_ADDRESS';
UPDATE configuration SET configuration_title = 'Store Address' WHERE configuration_key = 'STORE_ADDRESS';
UPDATE configuration SET configuration_description = 'This is the Address of my store used on printable documents and displayed online' WHERE configuration_key = 'STORE_ADDRESS';

/* store phone */
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Store Phone', 'STORE_PHONE', '555-1234', 'This is the phone number of my store used on printable documents and displayed online', '1', '19', 'tep_cfg_textarea(', now());

/* stock */
UPDATE configuration SET configuration_value = '<i class="glyphicon glyphicon-asterisk"></i>' WHERE configuration_key = 'STOCK_MARK_PRODUCT_OUT_OF_STOCK';

/* logo */
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Logo', 'STORE_LOGO', 'store_logo.png', 'This is the filename of your Store Logo.  This should be updated at admin > configuration > Store Logo', 6, 1000, now());

/* bootstrap config */
SELECT @next_id:=MAX(configuration_group_id) FROM configuration_group;
INSERT INTO configuration_group VALUES (@next_id+1, 'Bootstrap Setup', 'Basic Bootstrap Options', @next_id+1, '1');

SELECT @this_id:=MAX(configuration_group_id) FROM configuration_group;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Bootstrap Container', 'BOOTSTRAP_CONTAINER', 'container-fluid', 'What type of container should the page content be shown in? See http://getbootstrap.com/css/#overview-container', @this_id, '1', 'tep_cfg_select_option(array(\'container-fluid\', \'container\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Bootstrap Content', 'BOOTSTRAP_CONTENT', '8', 'What width should the page content default to?  (8 = two thirds width, 6 = half width, 4 = one third width) Note that the Side Column(s) will adjust automatically.', @this_id, '2', 'tep_cfg_select_option(array(\'8\', \'6\', \'4\'), ', now());