Code:
#Testimonials Manager SQL Uninstall
#Designed for: Zen Cart v1.5.0
#Author: Clyde Jones
#Version: 1.5.3d
#Updated: By CountryCharm 4/15/2012
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS `testimonials_manager`;
DELETE FROM admin_pages WHERE page_key = 'configTestimonialsManager' LIMIT 1;
DELETE FROM admin_pages WHERE page_key = 'TestimonialsManager' LIMIT 1;
I am ready to run the uninstall.sql but stopped before I pushed send after seeing some strange inserts being run. What is the purpose of inserting the 4 configuration settings if I am uninstalling?
Bookmarks