Removing addition to database

[TanPimp]

I just tried installing a mod which didn't work for me. Luckily I backed up everything so i could just restore the files. Unfortunately I didn't back up my database, so there is some stuff added in there that I don't need. My store still works fine and everything, I was just wondering if it was ok to leave the additions in the database and if not, how do i remove them? Here is the sql file I added:

 

 

 

# New Low Price. V1.0

# SQL Script for 'New Low Price'

# Author: Quentin Bennett, standing on the shoulders of giants.

#

# Don't forget - Backup, Backup and Backup again!

 

# Add 'products_old_price' and 'products_price_changed' columns to products table

ALTER TABLE `products` ADD `products_old_price` DECIMAL( 15, 4 ) , ADD `products_price_changed` DATE;

 

# Add to 'My Store' configuration - change sort_order (32 and 33) to suit

#

# NLP_PERCENT_DIFF - the percentage that a new price has to be below the old price

# to trigger the 'New Low Price' display

#

# NLP_DAYS - the number of days after the price is changed that the new price is

# highlighted as a 'New Low Price!'

#

INSERT 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 (

'', 'New Low Price Limit', 'NLP_PERCENT_DIFF', '10', 'Percentage difference to trigger ''new low price''', '1', '32', NOW( ) , NOW( ) , NULL , NULL),

( '', 'New Low Price Days', 'NLP_DAYS', '31', 'Number of days to show ''new low price''', '1', '33', NOW( ) , NOW( ) , NULL , NULL);

[Guest]

you can use the phpmyadmin tool and eliminate the extra columns added on the products table. Same for the configuration entry. If you do not trust writing sql to delete them use the x icons of the phpmyadmin gui

[kgt]

1. BACKUP. ;) I don't guarantee these will work, due to oversights, misspellings, asteroids, etc.

2. ALTER TABLE `products` DROP `products_old_price`, DROP `products_price_changed`;

3. DELETE FROM `configuration` WHERE ( `configuration_title`='New Low Price Limit' AND `configuration_key` = 'NLP_PERCENT_DIFF' ) OR ( `configuration_title`='New Low Price Days' AND `configuration_key` = 'NLP_DAYS' );