Uninstall SQL Patch

[CharInLasVegas]

I installed a mod that required a sql patch, but I need to uninstall because I have an error and I need to see if this caused it or not. But there's no uninstall patch...how would I do this? (there's also no support thread for the mod and No, I did not back up my db )

This is the install patch:

DROP TABLE IF EXISTS customers_basket_later;
CREATE TABLE customers_basket_later (
customers_basket_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
products_id tinytext NOT NULL,
customers_basket_quantity float NOT NULL default '0',
final_price decimal(15,4) NOT NULL default '0.0000',
customers_basket_date_added varchar(8) default NULL,
PRIMARY KEY (customers_basket_id),
KEY idx_customers_id_zen (customers_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table 'customers_basket_attributes'
#

DROP TABLE IF EXISTS customers_basket_later_attributes;
CREATE TABLE customers_basket_later_attributes (
customers_basket_attributes_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
products_id tinytext NOT NULL,
products_options_id varchar(64) NOT NULL default '0',
products_options_value_id int(11) NOT NULL default '0',
products_options_value_text BLOB NULL,
products_options_sort_order text NOT NULL,
PRIMARY KEY (customers_basket_attributes_id),
KEY idx_cust_id_prod_id_zen (customers_id,products_id(36))
) TYPE=MyISAM;

[Steven300]

DROP TABLE IF EXISTS customers_basket_later;
DROP TABLE IF EXISTS customers_basket_later_attributes;

[CharInLasVegas]

Thank you!

[barracuda]

I also made the same mistake and installed a mod that required a sql patch without making a backup . I want to uninstall it but there is no uninstall patch. Can anyone help please. Here is the sql patch:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Product Short Descriptions', 'PRODUCT_LIST_SHORT_DESC', '3', 'Set to 0 to disable, set to 1-99 to enable.', 8, 11, now(), now(), NULL, NULL);


ALTER TABLE products_description ADD products_short_desc VARCHAR( 255 ) DEFAULT NULL AFTER products_description ;



INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Info - Display Product Short Descriptions', 'PRODUCT_INFO_SHORT_DESC', '1', 'Show Product''s short Description<br />0= off<br />1= on', 18, 30, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');

[Steven300]

DELETE FROM configuration WHERE configuration_key = 'PRODUCT_LIST_SHORT_DESC';

ALTER TABLE products_description DROP COLUMN products_short_desc;

DELETE FROM configuration WHERE configuration_key = 'PRODUCT_INFO_SHORT_DESC';

[barracuda]

Thank you .

[greengreetings]

Will someone post the entire uninstall SQL patch. I don't want to make any mistakes by copying and pasting parts of the uinstall patch. Thank you so much.

[kuroi]

Will someone post the entire uninstall SQL patch. I don't want to make any mistakes by copying and pasting parts of the uinstall patch. Thank you so much.

The uninstall SQL patch for what?