Need uninstall sql file for this mod

[coucho]

I installed the where did you hear about us mod but it didn't work as planned and now my customers cant get past the log in page. It did not come with an uninstall sql file.

The file is as follows:
DROP TABLE IF EXISTS sources;
CREATE TABLE sources (
sources_id int NOT NULL auto_increment,
sources_name varchar(64) NOT NULL,
PRIMARY KEY (sources_id),
KEY IDX_SOURCES_NAME (sources_name)
);

INSERT INTO sources VALUES (1, 'Google');
INSERT INTO sources VALUES (2, 'Yahoo!');
INSERT INTO sources VALUES (3, 'AOL');
INSERT INTO sources VALUES (4, 'MSN');
INSERT INTO sources VALUES (5, 'ZenCart');

DROP TABLE IF EXISTS sources_other;
CREATE TABLE sources_other (
customers_id int NOT NULL default '0',
sources_other_name varchar(64) NOT NULL,
PRIMARY KEY (customers_id)
);

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Referral', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

[kobra]

I suppose that you did not make a backup of the DB before you added this mod?

Might try to contact the mod author

[coucho]

I have a backup but I hate to reinstall the database just to get rid of one mod.

[kobra]

I have a backup but I hate to reinstall the database just to get rid of one mod.

If this was taken riht before you added the mod then this is what it is for - to get you back to where you were as far as the DB is concerned - additionally,remove/delete the added files and backout any edits

[coucho]

Well, I got it to work but I will have to say that it does not have the best interface. It could use a facelift. Considering it was originally designed for v1.2 I shouldn't complain too much. It was just recently updated for v 1.3.8

[kobra]

It could use a facelift. Considering it was originally designed for v1.2 I shouldn't complain too much.

If you are up to it you can re-write it and contribute