I installed this in my SQL and need a uninstall for this but not sure the correct way to write it.
the fist couple lines. I want it to read default...
should be define('DB_PREFIX', 'zen_'); f Im correct.
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: raindrop
--
-- Table structure for table bsk_newsletter_subscribers
DROP TABLE IF EXISTS bsk_newsletter_subscribers;
CREATE TABLE IF NOT EXISTS bsk_newsletter_subscribers (
id int(11) NOT NULL AUTO_INCREMENT,
email varchar(1000) NOT NULL COMMENT 'email of subscribers to newsletter from home page',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table query_builder
INSERT IGNORE INTO query_builder (query_category, query_name, query_description, query_string, query_keys_list) VALUES
('email,newsletters', 'Subscribers from Home Page', 'Newsletter subscribers from Home Page', 'select ''Dear'' as customers_firstname, ''Subscriber'' as customers_lastname, email as customers_email_address from bsk_newsletter_subscribers', '');
--
-- create Theme Options under Back office > Tools
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('bskThemeOptions', 'BOX_BSK_THEME_OPTIONS', 'FILENAME_BSK_THEME_OPTIONS_TPL', '', 'tools', 'Y', 200);
--
-- table for theme options
DROP TABLE IF EXISTS bsk_theme_options;
CREATE TABLE IF NOT EXISTS bsk_theme_options (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(1000) NOT NULL,
val varchar(10000) NOT NULL,
description varchar(10000) DEFAULT NULL,
PRIMARY KEY (id)
);
INSERT INTO bsk_theme_options (name, val, description) VALUES ('bkgColor', 'rgba(0,0,0,0)', 'the background color'),
('bkgImg', '1', 'the background image, if value is 0 than use the root/images/raindrop/bkgimg.(jpg, png, gif) else use the file pattern{value}.png from root/includes/templates/raindrop/images/bkg/'),
('linksColor', '#08C', 'the color of general links'),
('priceColor', '#ff4848', 'color for displaying price'),
('add2CartBkgColor', '#167db2', 'background color for add to cart button'),
('add2CartTextColor', '#fff', 'text color for add to cart button'),
('btnImpBkgColor', '#167db2', 'background color for button important (.rdBtn)'),
('btnImpTextColor', '#fff', 'text color for button important (.rdBtn)'),
('fnbBkgColor', '#000', 'background color for first navigation bar'),
('fnbLinksColor', '#fff', 'links color for first navigation bar'),
('fnbLinksHoverColor', '#fff', 'links hover color for first navigation bar'),
('fnbShowLogo', '1', 'show logo on first navigation bar'),
('fnbShowSearch', '1', 'show search on first navigation bar'),
('snbBkgColor', '#fff', 'background color for secondary top navigation bar'),
('snbShowLogo', '0', 'show logo on secondary top navigation bar'),
('snbMenuLinksColor', '#167db2', 'menu links color'),
('snbLineHoverColor', '#ff4848', 'menu line hover color'),
('snbSubmenuBkgColor', '#fff', 'background color for submenu'),
('snbSubmenuBkgHoverColor', '#fff', 'background hover color for submenu'),
('snbSubmenuLinksColor', '#167db2', 'links color for submenu'),
('snbCartLinksColor', '#000', 'link color for cart in secondary top navigation bar'),
('sectionTabColor', '#000', 'title or tab color in content section'),
('sectionTabLineColor', '#000', 'bottom border for title or tab in content section'),
('footerDelimColor', '#000', 'top border for footer'),
('footerBkgColor', 'rgba(0,0,0,0.1)', 'footer background color'),
('footerTitleColor', '#000', 'title color for sections in footer'),
('footerTextColor', '#000', 'text color in footer'),
('footerLinksColor', '#0088cc', 'links color in footer'),
('footerLinksHoverColor', '#005580', 'links hover color in footer'),
('advBlocksEnable', '1', 'display adv blocks'),
('advLink1', '#', 'link for first adv block'),
('advLink1Tab', '0', 'open link for first adv block in new tab'),
('advLink2', '#', 'link for second adv block'),
('advLink2Tab', '0', 'open link for second adv block in new tab'),
('advLink3', '#', 'link for third adv block'),
('advLink3Tab', '0', 'open link for third adv block in new tab');
--
-- create Slider under Back office > Tools
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('bskSlider', 'BOX_BSK_SLIDER', 'FILENAME_BSK_SLIDER_TPL', '', 'tools', 'Y', 210);
--
-- table for slider
DROP TABLE IF EXISTS bsk_slides;
CREATE TABLE IF NOT EXISTS bsk_slides (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
img varchar(1000) NOT NULL,
text varchar(1000) NOT NULL,
link varchar(10000) DEFAULT NULL,
PRIMARY KEY (id)
);
--
-- table for slider options
DROP TABLE IF EXISTS bsk_slider_options;
CREATE TABLE IF NOT EXISTS bsk_slider_options (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(1000) NOT NULL,
val varchar(1000) NOT NULL,
description varchar(1000) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO bsk_slider_options (name, val) VALUES ('enableThumbs', '0');