USE [% osc %];

ALTER TABLE `address_book`
CHANGE COLUMN `entry_firstname`
`entry_firstname` varchar(255) NOT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_suburb`
`entry_suburb` varchar(255) DEFAULT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_state`
`entry_state` varchar(255) DEFAULT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_postcode`
`entry_postcode` varchar(255) NOT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_gender`
`entry_gender` char(1) DEFAULT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_street_address`
`entry_street_address` varchar(255) NOT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_company`
`entry_company` varchar(255) DEFAULT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_lastname`
`entry_lastname` varchar(255) NOT NULL;

ALTER TABLE `address_book`
CHANGE COLUMN `entry_city`
`entry_city` varchar(255) NOT NULL;

ALTER TABLE `administrators`
CHANGE COLUMN `user_password`
`user_password` varchar(60) NOT NULL;

ALTER TABLE `administrators`
CHANGE COLUMN `user_name`
`user_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;

ALTER TABLE `configuration`
CHANGE COLUMN `configuration_value`
`configuration_value` text NOT NULL;

ALTER TABLE `countries`
CHANGE COLUMN `countries_name`
`countries_name` varchar(255) NOT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_lastname`
`customers_lastname` varchar(255) NOT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_email_address`
`customers_email_address` varchar(255) NOT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_password`
`customers_password` varchar(60) NOT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_gender`
`customers_gender` char(1) DEFAULT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_firstname`
`customers_firstname` varchar(255) NOT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_fax`
`customers_fax` varchar(255) DEFAULT NULL;

ALTER TABLE `customers`
CHANGE COLUMN `customers_telephone`
`customers_telephone` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_email_address`
`customers_email_address` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_name`
`delivery_name` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_state`
`billing_state` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_suburb`
`billing_suburb` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `cc_owner`
`cc_owner` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_postcode`
`delivery_postcode` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_city`
`customers_city` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_postcode`
`customers_postcode` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_name`
`billing_name` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_country`
`delivery_country` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_state`
`delivery_state` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_street_address`
`billing_street_address` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_telephone`
`customers_telephone` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_country`
`billing_country` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_company`
`delivery_company` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_street_address`
`delivery_street_address` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_city`
`delivery_city` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_city`
`billing_city` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_company`
`billing_company` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_state`
`customers_state` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `billing_postcode`
`billing_postcode` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_name`
`customers_name` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_street_address`
`customers_street_address` varchar(255) NOT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_suburb`
`customers_suburb` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_company`
`customers_company` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `delivery_suburb`
`delivery_suburb` varchar(255) DEFAULT NULL;

ALTER TABLE `orders`
CHANGE COLUMN `customers_country`
`customers_country` varchar(255) NOT NULL;

ALTER TABLE `reviews`
CHANGE COLUMN `customers_name`
`customers_name` varchar(255) NOT NULL;

ALTER TABLE `reviews`
ADD COLUMN `reviews_status` tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE `whos_online`
CHANGE COLUMN `full_name`
`full_name` varchar(255) NOT NULL;

ALTER TABLE `zones`
CHANGE COLUMN `zone_name`
`zone_name` varchar(255) NOT NULL;


CREATE TABLE `action_recorder` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `module` varchar(255) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `user_name` varchar(255) DEFAULT NULL,
    `identifier` varchar(255) NOT NULL,
    `success` char(1) DEFAULT NULL,
    `date_added` datetime NOT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_action_recorder_module` (`module`),
    KEY `idx_action_recorder_user_id` (`user_id`),
    KEY `idx_action_recorder_identifier` (`identifier`),
    KEY `idx_action_recorder_date_added` (`date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `products_images` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `products_id` int(11) NOT NULL,
    `image` varchar(64) DEFAULT NULL,
    `htmlcontent` text,
    `sort_order` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `products_images_prodid` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE `sec_directory_whitelist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `directory` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;


UPDATE `configuration`
SET `configuration_title` = 'Use Search-Engine Safe URLs'
WHERE `configuration_key` = 'SEARCH_ENGINE_FRIENDLY_URLS';


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Modules', 'MODULE_ACTION_RECORDER_INSTALLED', 'ar_admin_login.php;ar_contact_us.php;ar_tell_a_friend.php', 'List of action recorder module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ACTION_RECORDER_INSTALLED'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Modules', 'MODULE_SOCIAL_BOOKMARKS_INSTALLED', 'sb_email.php;sb_facebook.php;sb_twitter.php;sb_google_buzz.php;sb_digg.php', 'List of social bookmark module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_INSTALLED'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Minimum Minutes Per E-Mail', 'MODULE_ACTION_RECORDER_CONTACT_US_EMAIL_MINUTES', '15', 'Minimum number of minutes to allow 1 e-mail to be sent (eg, 15 for 1 e-mail every 15 minutes)', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ACTION_RECORDER_CONTACT_US_EMAIL_MINUTES'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Minimum Minutes Per E-Mail', 'MODULE_ACTION_RECORDER_TELL_A_FRIEND_EMAIL_MINUTES', '15', 'Minimum number of minutes to allow 1 e-mail to be sent (eg, 15 for 1 e-mail every 15 minutes)', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ACTION_RECORDER_TELL_A_FRIEND_EMAIL_MINUTES'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Allowed Minutes', 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_MINUTES', '5', 'Number of minutes to allow login attempts to occur.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_MINUTES'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Allowed Attempts', 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_ATTEMPTS', '3', 'Number of login attempts to allow within the specified period.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ACTION_RECORDER_ADMIN_LOGIN_ATTEMPTS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable E-Mail Module', 'MODULE_SOCIAL_BOOKMARKS_EMAIL_STATUS', 'True', 'Do you want to allow products to be shared through e-mail?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_EMAIL_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_SOCIAL_BOOKMARKS_EMAIL_SORT_ORDER', '10', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_EMAIL_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Facebook Module', 'MODULE_SOCIAL_BOOKMARKS_FACEBOOK_STATUS', 'True', 'Do you want to allow products to be shared through Facebook?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_FACEBOOK_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_SOCIAL_BOOKMARKS_FACEBOOK_SORT_ORDER', '20', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_FACEBOOK_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Twitter Module', 'MODULE_SOCIAL_BOOKMARKS_TWITTER_STATUS', 'True', 'Do you want to allow products to be shared through Twitter?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_TWITTER_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_SOCIAL_BOOKMARKS_TWITTER_SORT_ORDER', '30', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_TWITTER_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Google Buzz Module', 'MODULE_SOCIAL_BOOKMARKS_GOOGLE_BUZZ_STATUS', 'True', 'Do you want to allow products to be shared through Google Buzz?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_GOOGLE_BUZZ_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_SOCIAL_BOOKMARKS_GOOGLE_BUZZ_SORT_ORDER', '40', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_GOOGLE_BUZZ_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Digg Module', 'MODULE_SOCIAL_BOOKMARKS_DIGG_STATUS', 'True', 'Do you want to allow products to be shared through Digg?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_DIGG_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_SOCIAL_BOOKMARKS_DIGG_SORT_ORDER', '50', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_SOCIAL_BOOKMARKS_DIGG_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Last Update Check Time', 'LAST_UPDATE_CHECK_TIME', '', 'Last time a check for new versions of osCommerce was run', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'LAST_UPDATE_CHECK_TIME'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable PayPal Express Checkout', 'MODULE_PAYMENT_PAYPAL_EXPRESS_STATUS', 'True', 'Do you want to accept PayPal Express Checkout payments?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Seller Account', 'MODULE_PAYMENT_PAYPAL_EXPRESS_SELLER_ACCOUNT', '[% email %]', 'The email address of the seller account if no API credentials has been setup.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_SELLER_ACCOUNT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'API Username', 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_USERNAME', '', 'The username to use for the PayPal API service', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_USERNAME'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'API Password', 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_PASSWORD', '', 'The password to use for the PayPal API service', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_PASSWORD'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'API Signature', 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_SIGNATURE', '', 'The signature to use for the PayPal API service', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_API_SIGNATURE'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Transaction Server', 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTION_SERVER', 'Live', 'Use the live or testing (sandbox) gateway server to process transactions?', 6, 0, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Live'', ''Sandbox''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTION_SERVER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Transaction Method', 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTION_METHOD', 'Sale', 'The processing method to use for each transaction.', 6, 0, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Authorization'', ''Sale''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTION_METHOD'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'PayPal Account Optional', 'MODULE_PAYMENT_PAYPAL_EXPRESS_ACCOUNT_OPTIONAL', 'False', 'This must also be enabled in your PayPal account, in Profile > Website Payment Preferences.', 6, 0, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_ACCOUNT_OPTIONAL'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'PayPal Instant Update', 'MODULE_PAYMENT_PAYPAL_EXPRESS_INSTANT_UPDATE', 'True', 'Support PayPal shipping and tax calculations on the PayPal.com site during Express Checkout.', 6, 0, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_INSTANT_UPDATE'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'PayPal Checkout Image', 'MODULE_PAYMENT_PAYPAL_EXPRESS_CHECKOUT_IMAGE', 'Static', 'Use static or dynamic Express Checkout image buttons. Dynamic images are used with PayPal campaigns.', 6, 0, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Static'', ''Dynamic''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_CHECKOUT_IMAGE'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Debug E-Mail Address', 'MODULE_PAYMENT_PAYPAL_EXPRESS_DEBUG_EMAIL', '', 'All parameters of an invalid transaction will be sent to this email address.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_DEBUG_EMAIL'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Payment Zone', 'MODULE_PAYMENT_PAYPAL_EXPRESS_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, NOW(), 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_ZONE'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort order of display.', 'MODULE_PAYMENT_PAYPAL_EXPRESS_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Set Order Status', 'MODULE_PAYMENT_PAYPAL_EXPRESS_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, NOW(), 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_ORDER_STATUS_ID'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'PayPal Transactions Order Status Level', 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTIONS_ORDER_STATUS_ID', '4', 'Include PayPal transaction information in this order status level', 6, 0, NULL, NOW(), 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_TRANSACTIONS_ORDER_STATUS_ID'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'cURL Program Location', 'MODULE_PAYMENT_PAYPAL_EXPRESS_CURL', '/usr/bin/curl', 'The location to the cURL program application.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_PAYMENT_PAYPAL_EXPRESS_CURL'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Modules', 'MODULE_HEADER_TAGS_INSTALLED', 'ht_manufacturer_title.php;ht_category_title.php;ht_product_title.php', 'List of header tag module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_INSTALLED'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Category Title Module', 'MODULE_HEADER_TAGS_CATEGORY_TITLE_STATUS', 'True', 'Do you want to allow category titles to be added to the page title?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_CATEGORY_TITLE_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_HEADER_TAGS_CATEGORY_TITLE_SORT_ORDER', '200', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_CATEGORY_TITLE_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Manufacturer Title Module', 'MODULE_HEADER_TAGS_MANUFACTURER_TITLE_STATUS', 'True', 'Do you want to allow manufacturer titles to be added to the page title?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_MANUFACTURER_TITLE_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_HEADER_TAGS_MANUFACTURER_TITLE_SORT_ORDER', '100', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_MANUFACTURER_TITLE_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Product Title Module', 'MODULE_HEADER_TAGS_PRODUCT_TITLE_STATUS', 'True', 'Do you want to allow product titles to be added to the page title?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_PRODUCT_TITLE_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_HEADER_TAGS_PRODUCT_TITLE_SORT_ORDER', '300', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_HEADER_TAGS_PRODUCT_TITLE_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Modules', 'MODULE_ADMIN_DASHBOARD_INSTALLED', 'd_total_revenue.php;d_total_customers.php;d_orders.php;d_customers.php;d_admin_logins.php;d_security_checks.php;d_latest_news.php;d_latest_addons.php;d_version_check.php;d_reviews.php', 'List of Administration Tool Dashboard module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_INSTALLED'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Administrator Logins Module', 'MODULE_ADMIN_DASHBOARD_ADMIN_LOGINS_STATUS', 'True', 'Do you want to show the latest administrator logins on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_ADMIN_LOGINS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_ADMIN_LOGINS_SORT_ORDER', '500', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_ADMIN_LOGINS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Customers Module', 'MODULE_ADMIN_DASHBOARD_CUSTOMERS_STATUS', 'True', 'Do you want to show the newest customers on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_CUSTOMERS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_CUSTOMERS_SORT_ORDER', '400', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_CUSTOMERS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Latest Add-Ons Module', 'MODULE_ADMIN_DASHBOARD_LATEST_ADDONS_STATUS', 'True', 'Do you want to show the latest osCommerce Add-Ons on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_LATEST_ADDONS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_LATEST_ADDONS_SORT_ORDER', '800', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_LATEST_ADDONS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Latest News Module', 'MODULE_ADMIN_DASHBOARD_LATEST_NEWS_STATUS', 'True', 'Do you want to show the latest osCommerce News on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_LATEST_NEWS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_LATEST_NEWS_SORT_ORDER', '700', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_LATEST_NEWS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Orders Module', 'MODULE_ADMIN_DASHBOARD_ORDERS_STATUS', 'True', 'Do you want to show the latest orders on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_ORDERS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_ORDERS_SORT_ORDER', '300', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_ORDERS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Security Checks Module', 'MODULE_ADMIN_DASHBOARD_SECURITY_CHECKS_STATUS', 'True', 'Do you want to run the security checks for this installation?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_SECURITY_CHECKS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_SECURITY_CHECKS_SORT_ORDER', '600', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_SECURITY_CHECKS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Total Customers Module', 'MODULE_ADMIN_DASHBOARD_TOTAL_CUSTOMERS_STATUS', 'True', 'Do you want to show the total customers chart on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_TOTAL_CUSTOMERS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_TOTAL_CUSTOMERS_SORT_ORDER', '200', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_TOTAL_CUSTOMERS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Total Revenue Module', 'MODULE_ADMIN_DASHBOARD_TOTAL_REVENUE_STATUS', 'True', 'Do you want to show the total revenue chart on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_TOTAL_REVENUE_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_TOTAL_REVENUE_SORT_ORDER', '100', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_TOTAL_REVENUE_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Version Check Module', 'MODULE_ADMIN_DASHBOARD_VERSION_CHECK_STATUS', 'True', 'Do you want to show the version check results on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_VERSION_CHECK_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_VERSION_CHECK_SORT_ORDER', '900', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_VERSION_CHECK_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Latest Reviews Module', 'MODULE_ADMIN_DASHBOARD_REVIEWS_STATUS', 'True', 'Do you want to show the latest reviews on the dashboard?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_REVIEWS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_ADMIN_DASHBOARD_REVIEWS_SORT_ORDER', '1000', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_ADMIN_DASHBOARD_REVIEWS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Modules', 'MODULE_BOXES_INSTALLED', 'bm_categories.php;bm_manufacturers.php;bm_search.php;bm_whats_new.php;bm_information.php;bm_shopping_cart.php;bm_manufacturer_info.php;bm_order_history.php;bm_best_sellers.php;bm_product_notifications.php;bm_product_social_bookmarks.php;bm_specials.php;bm_reviews.php;bm_languages.php;bm_currencies.php', 'List of box module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_INSTALLED'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Best Sellers Module', 'MODULE_BOXES_BEST_SELLERS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_BEST_SELLERS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_BEST_SELLERS_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_BEST_SELLERS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_BEST_SELLERS_SORT_ORDER', '5030', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_BEST_SELLERS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Categories Module', 'MODULE_BOXES_CATEGORIES_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CATEGORIES_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_CATEGORIES_SORT_ORDER', '1000', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CATEGORIES_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Currencies Module', 'MODULE_BOXES_CURRENCIES_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CURRENCIES_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_CURRENCIES_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CURRENCIES_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_CURRENCIES_SORT_ORDER', '5090', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_CURRENCIES_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Information Module', 'MODULE_BOXES_INFORMATION_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_INFORMATION_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_INFORMATION_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_INFORMATION_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_INFORMATION_SORT_ORDER', '1050', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_INFORMATION_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Languages Module', 'MODULE_BOXES_LANGUAGES_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_LANGUAGES_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_LANGUAGES_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_LANGUAGES_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_LANGUAGES_SORT_ORDER', '5080', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_LANGUAGES_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Manufacturer Info Module', 'MODULE_BOXES_MANUFACTURER_INFO_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURER_INFO_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_MANUFACTURER_INFO_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURER_INFO_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_MANUFACTURER_INFO_SORT_ORDER', '5010', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURER_INFO_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Manufacturers Module', 'MODULE_BOXES_MANUFACTURERS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURERS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_MANUFACTURERS_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURERS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_MANUFACTURERS_SORT_ORDER', '1020', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_MANUFACTURERS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Order History Module', 'MODULE_BOXES_ORDER_HISTORY_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_ORDER_HISTORY_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_ORDER_HISTORY_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_ORDER_HISTORY_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_ORDER_HISTORY_SORT_ORDER', '5020', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_ORDER_HISTORY_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Product Notifications Module', 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_SORT_ORDER', '5040', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_NOTIFICATIONS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Product Social Bookmarks Module', 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_SORT_ORDER', '5050', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_PRODUCT_SOCIAL_BOOKMARKS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Reviews Module', 'MODULE_BOXES_REVIEWS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_REVIEWS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_REVIEWS_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_REVIEWS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_REVIEWS_SORT_ORDER', '5070', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_REVIEWS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Search Module', 'MODULE_BOXES_SEARCH_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SEARCH_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_SEARCH_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SEARCH_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_SEARCH_SORT_ORDER', '1030', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SEARCH_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Shopping Cart Module', 'MODULE_BOXES_SHOPPING_CART_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SHOPPING_CART_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_SHOPPING_CART_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SHOPPING_CART_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_SHOPPING_CART_SORT_ORDER', '5000', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SHOPPING_CART_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable Specials Module', 'MODULE_BOXES_SPECIALS_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SPECIALS_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_SPECIALS_CONTENT_PLACEMENT', 'Right Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SPECIALS_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_SPECIALS_SORT_ORDER', '5060', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_SPECIALS_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Enable What''s New Module', 'MODULE_BOXES_WHATS_NEW_STATUS', 'True', 'Do you want to add the module to your shop?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''True'', ''False''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_WHATS_NEW_STATUS'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Content Placement', 'MODULE_BOXES_WHATS_NEW_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', 6, 1, NULL, NOW(), NULL, 'tep_cfg_select_option(array(''Left Column'', ''Right Column''), '
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_WHATS_NEW_CONTENT_PLACEMENT'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Sort Order', 'MODULE_BOXES_WHATS_NEW_SORT_ORDER', '1040', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'MODULE_BOXES_WHATS_NEW_SORT_ORDER'
)
LIMIT 1;


INSERT INTO `configuration` (
    `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`
)
SELECT 'Installed Template Block Groups', 'TEMPLATE_BLOCK_GROUPS', 'boxes;header_tags', 'This is automatically updated. No need to edit.', 6, 0, NULL, NOW(), NULL, NULL
FROM `configuration`
WHERE NOT EXISTS (
    SELECT `configuration_key`
    FROM `configuration`
    WHERE `configuration_key` = 'TEMPLATE_BLOCK_GROUPS'
)
LIMIT 1;
