-- phpMyAdmin SQL Dump -- version 2.10.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 29, 2008 at 12:11 AM -- Server version: 5.0.37 -- PHP Version: 5.2.1 -- -------------------------------------------------------- -- -- Table structure for table `#__osc_address_book` -- CREATE TABLE `#__osc_address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `entry_gender` char(1) NOT NULL, `entry_company` varchar(32) default NULL, `entry_company_tax_id` varchar(32) default NULL, `entry_firstname` varchar(32) NOT NULL, `entry_lastname` varchar(32) NOT NULL, `entry_street_address` varchar(64) NOT NULL, `entry_suburb` varchar(32) default NULL, `entry_postcode` varchar(10) NOT NULL, `entry_city` varchar(32) NOT NULL, `entry_state` varchar(32) default NULL, `entry_country_id` int(11) NOT NULL default '0', `entry_zone_id` int(11) NOT NULL default '0', PRIMARY KEY (`address_book_id`), KEY `idx_address_book_customers_id` (`customers_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_address_book` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_address_format` -- CREATE TABLE `#__osc_address_format` ( `address_format_id` int(11) NOT NULL auto_increment, `address_format` varchar(128) NOT NULL, `address_summary` varchar(48) NOT NULL, PRIMARY KEY (`address_format_id`) ) AUTO_INCREMENT=6 ; -- -- Dumping data for table `#__osc_address_format` -- INSERT INTO `#__osc_address_format` (`address_format_id`, `address_format`, `address_summary`) VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country'), (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country'), (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'), (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'), (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_affiliate` -- CREATE TABLE `#__osc_affiliate_affiliate` ( `affiliate_id` int(11) NOT NULL auto_increment, `affiliate_gender` char(1) NOT NULL, `affiliate_firstname` varchar(32) NOT NULL, `affiliate_lastname` varchar(32) NOT NULL, `affiliate_dob` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_email_address` varchar(96) NOT NULL, `affiliate_telephone` varchar(32) NOT NULL, `affiliate_fax` varchar(32) NOT NULL, `affiliate_password` varchar(40) NOT NULL, `affiliate_homepage` varchar(96) NOT NULL, `affiliate_street_address` varchar(64) NOT NULL, `affiliate_suburb` varchar(64) NOT NULL, `affiliate_city` varchar(32) NOT NULL, `affiliate_postcode` varchar(10) NOT NULL, `affiliate_state` varchar(32) NOT NULL, `affiliate_country_id` int(11) NOT NULL default '0', `affiliate_zone_id` int(11) NOT NULL default '0', `affiliate_agb` tinyint(4) NOT NULL default '0', `affiliate_company` varchar(60) NOT NULL, `affiliate_company_taxid` varchar(64) NOT NULL, `affiliate_commission_percent` decimal(4,2) NOT NULL default '0.00', `affiliate_payment_check` varchar(100) NOT NULL, `affiliate_payment_paypal` varchar(64) NOT NULL, `affiliate_payment_bank_name` varchar(64) NOT NULL, `affiliate_payment_bank_branch_number` varchar(64) NOT NULL, `affiliate_payment_bank_swift_code` varchar(64) NOT NULL, `affiliate_payment_bank_account_name` varchar(64) NOT NULL, `affiliate_payment_bank_account_number` varchar(64) NOT NULL, `affiliate_date_of_last_logon` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_number_of_logons` int(11) NOT NULL default '0', `affiliate_date_account_created` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_date_account_last_modified` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_lft` int(11) NOT NULL default '0', `affiliate_rgt` int(11) NOT NULL default '0', `affiliate_root` int(11) NOT NULL default '0', `affiliate_newsletter` char(1) NOT NULL default '1', PRIMARY KEY (`affiliate_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_affiliate` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_banners` -- CREATE TABLE `#__osc_affiliate_banners` ( `affiliate_banners_id` int(11) NOT NULL auto_increment, `affiliate_banners_title` varchar(64) NOT NULL, `affiliate_products_id` int(11) NOT NULL default '0', `affiliate_category_id` int(11) NOT NULL default '0', `affiliate_banners_image` varchar(64) NOT NULL, `affiliate_banners_group` varchar(10) NOT NULL, `affiliate_banners_html_text` text, `affiliate_expires_impressions` int(7) default '0', `affiliate_expires_date` datetime default NULL, `affiliate_date_scheduled` datetime default NULL, `affiliate_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_date_status_change` datetime default NULL, `affiliate_status` int(1) NOT NULL default '1', PRIMARY KEY (`affiliate_banners_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_banners` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_banners_history` -- CREATE TABLE `#__osc_affiliate_banners_history` ( `affiliate_banners_history_id` int(11) NOT NULL auto_increment, `affiliate_banners_products_id` int(11) NOT NULL default '0', `affiliate_banners_id` int(11) NOT NULL default '0', `affiliate_banners_affiliate_id` int(11) NOT NULL default '0', `affiliate_banners_shown` int(11) NOT NULL default '0', `affiliate_banners_clicks` tinyint(4) NOT NULL default '0', `affiliate_banners_history_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`affiliate_banners_history_id`,`affiliate_banners_products_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_banners_history` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_clickthroughs` -- CREATE TABLE `#__osc_affiliate_clickthroughs` ( `affiliate_clickthrough_id` int(11) NOT NULL auto_increment, `affiliate_id` int(11) NOT NULL default '0', `affiliate_clientdate` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_clientbrowser` varchar(200) default 'Could Not Find This Data', `affiliate_clientip` varchar(50) default 'Could Not Find This Data', `affiliate_clientreferer` varchar(200) default 'none detected (maybe a direct link)', `affiliate_products_id` int(11) default '0', `affiliate_banner_id` int(11) NOT NULL default '0', PRIMARY KEY (`affiliate_clickthrough_id`), KEY `refid` (`affiliate_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_clickthroughs` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_news` -- CREATE TABLE `#__osc_affiliate_news` ( `news_id` int(11) NOT NULL auto_increment, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `news_status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`news_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_news` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_newsletters` -- CREATE TABLE `#__osc_affiliate_newsletters` ( `affiliate_newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(245) NOT NULL, `content` text NOT NULL, `module` varchar(245) NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', PRIMARY KEY (`affiliate_newsletters_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_newsletters` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_news_contents` -- CREATE TABLE `#__osc_affiliate_news_contents` ( `affiliate_news_contents_id` int(11) NOT NULL auto_increment, `affiliate_news_id` int(11) NOT NULL default '0', `affiliate_news_languages_id` int(11) NOT NULL default '0', `affiliate_news_headlines` varchar(245) NOT NULL, `affiliate_news_contents` text NOT NULL, PRIMARY KEY (`affiliate_news_contents_id`), KEY `affiliate_news_id` (`affiliate_news_id`), KEY `affiliate_news_languages_id` (`affiliate_news_languages_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_news_contents` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_payment` -- CREATE TABLE `#__osc_affiliate_payment` ( `affiliate_payment_id` int(11) NOT NULL auto_increment, `affiliate_id` int(11) NOT NULL default '0', `affiliate_payment` decimal(15,2) NOT NULL default '0.00', `affiliate_payment_tax` decimal(15,2) NOT NULL default '0.00', `affiliate_payment_total` decimal(15,2) NOT NULL default '0.00', `affiliate_payment_date` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_payment_last_modified` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_payment_status` int(5) NOT NULL default '0', `affiliate_firstname` varchar(32) NOT NULL, `affiliate_lastname` varchar(32) NOT NULL, `affiliate_street_address` varchar(64) NOT NULL, `affiliate_suburb` varchar(64) NOT NULL, `affiliate_city` varchar(32) NOT NULL, `affiliate_postcode` varchar(10) NOT NULL, `affiliate_country` varchar(32) NOT NULL default '0', `affiliate_company` varchar(60) NOT NULL, `affiliate_state` varchar(32) NOT NULL default '0', `affiliate_address_format_id` int(5) NOT NULL default '0', `affiliate_last_modified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`affiliate_payment_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_payment` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_payment_status` -- CREATE TABLE `#__osc_affiliate_payment_status` ( `affiliate_payment_status_id` int(11) NOT NULL default '0', `affiliate_language_id` int(11) NOT NULL default '1', `affiliate_payment_status_name` varchar(32) NOT NULL, PRIMARY KEY (`affiliate_payment_status_id`,`affiliate_language_id`), KEY `idx_affiliate_payment_status_name` (`affiliate_payment_status_name`) ) ; -- -- Dumping data for table `#__osc_affiliate_payment_status` -- INSERT INTO `#__osc_affiliate_payment_status` (`affiliate_payment_status_id`, `affiliate_language_id`, `affiliate_payment_status_name`) VALUES (1, 1, 'Paid'), (0, 1, 'Pending'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_payment_status_history` -- CREATE TABLE `#__osc_affiliate_payment_status_history` ( `affiliate_status_history_id` int(11) NOT NULL auto_increment, `affiliate_payment_id` int(11) NOT NULL default '0', `affiliate_new_value` int(5) NOT NULL default '0', `affiliate_old_value` int(5) default NULL, `affiliate_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_notified` int(1) default '0', PRIMARY KEY (`affiliate_status_history_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_affiliate_payment_status_history` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_affiliate_sales` -- CREATE TABLE `#__osc_affiliate_sales` ( `affiliate_id` int(11) NOT NULL default '0', `affiliate_date` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_browser` varchar(100) NOT NULL, `affiliate_ipaddress` varchar(20) NOT NULL, `affiliate_orders_id` int(11) NOT NULL default '0', `affiliate_value` decimal(15,2) NOT NULL default '0.00', `affiliate_payment` decimal(15,2) NOT NULL default '0.00', `affiliate_clickthroughs_id` int(11) NOT NULL default '0', `affiliate_billing_status` int(5) NOT NULL default '0', `affiliate_payment_date` datetime NOT NULL default '0000-00-00 00:00:00', `affiliate_payment_id` int(11) NOT NULL default '0', `affiliate_percent` decimal(4,2) NOT NULL default '0.00', `affiliate_salesman` int(11) NOT NULL default '0', PRIMARY KEY (`affiliate_orders_id`,`affiliate_id`) ) ; -- -- Dumping data for table `#__osc_affiliate_sales` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_auctions` -- CREATE TABLE `#__osc_auctions` ( `auctions_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `auctions_starting_price` decimal(15,4) NOT NULL default '0.0000', `auctions_date_added` datetime default NULL, `auctions_last_modified` datetime default NULL, `expires_date` datetime NOT NULL default '2006-11-01 00:00:00', `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', `overbid_amount` float(10,2) NOT NULL default '0.00', `notified` int(1) NOT NULL default '1', PRIMARY KEY (`auctions_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_auctions` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_auctions_bids` -- CREATE TABLE `#__osc_auctions_bids` ( `auctions_bids_id` int(11) NOT NULL auto_increment, `auctions_id` int(11) NOT NULL default '0', `customers_id` int(11) NOT NULL default '0', `bid_price` float(10,2) NOT NULL default '0.00', `bid_status` varchar(10) default NULL, `bid_date_added` datetime NOT NULL, PRIMARY KEY (`auctions_bids_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_auctions_bids` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_banners` -- CREATE TABLE `#__osc_banners` ( `banners_id` int(11) NOT NULL auto_increment, `banners_title` varchar(64) NOT NULL, `banners_url` varchar(245) NOT NULL, `banners_image` varchar(64) NOT NULL, `banners_group` varchar(10) NOT NULL, `banners_html_text` text, `expires_impressions` int(7) default '0', `expires_date` datetime default NULL, `date_scheduled` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', PRIMARY KEY (`banners_id`), KEY `idx_banners_group` (`banners_group`) ) AUTO_INCREMENT=3 ; -- -- Dumping data for table `#__osc_banners` -- INSERT INTO `#__osc_banners` (`banners_id`, `banners_title`, `banners_url`, `banners_image`, `banners_group`, `banners_html_text`, `expires_impressions`, `expires_date`, `date_scheduled`, `date_added`, `date_status_change`, `status`) VALUES (2, 'ECJC Online Shop', 'http://www.joomla-host.co.za', 'banners/ecjc.png', '468x50', '', 0, NULL, NULL, '2008-03-28 16:58:10', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_banners_history` -- CREATE TABLE `#__osc_banners_history` ( `banners_history_id` int(11) NOT NULL auto_increment, `banners_id` int(11) NOT NULL default '0', `banners_shown` int(5) NOT NULL default '0', `banners_clicked` int(5) NOT NULL default '0', `banners_history_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`banners_history_id`), KEY `idx_banners_history_banners_id` (`banners_id`) ) AUTO_INCREMENT=28 ; -- -- Dumping data for table `#__osc_banners_history` -- INSERT INTO `#__osc_banners_history` (`banners_history_id`, `banners_id`, `banners_shown`, `banners_clicked`, `banners_history_date`) VALUES (26, 2, 65, 7, '2008-03-28 17:14:03'), (27, 2, 2, 0, '2008-03-29 00:08:40'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_categories` -- CREATE TABLE `#__osc_categories` ( `categories_id` int(11) NOT NULL auto_increment, `categories_image` varchar(64) default NULL, `parent_id` int(11) NOT NULL default '0', `sort_order` int(3) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `categories_hide_from_groups` varchar(255) NOT NULL default '@', `supplier_id` tinyint(4) NOT NULL default '0', PRIMARY KEY (`categories_id`), KEY `idx_categories_parent_id` (`parent_id`) ) AUTO_INCREMENT=10 ; -- -- Dumping data for table `#__osc_categories` -- INSERT INTO `#__osc_categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`, `categories_hide_from_groups`, `supplier_id`) VALUES (1, 'playlogo.jpg', 0, 0, '2008-03-28 20:31:05', NULL, '@', 0), (2, 'laptop.jpg', 0, 0, '2008-03-28 20:31:55', NULL, '@', 0), (3, 'software.jpg', 0, 0, '2008-03-28 20:39:29', NULL, '@', 0), (4, 'pcgames.jpg', 3, 0, '2008-03-28 20:41:32', NULL, '@', 0), (5, 'officesoft.jpg', 3, 0, '2008-03-28 20:42:03', NULL, '@', 0), (6, 'laptop.jpg', 2, 0, '2008-03-28 20:42:50', NULL, '@', 0), (7, 'flashdrive.jpg', 2, 0, '2008-03-28 20:43:12', NULL, '@', 0), (8, 'play crash.jpg', 1, 0, '2008-03-28 20:45:48', NULL, '@', 0), (9, 'AlbumArt_Large.jpg', 0, 0, '2008-03-28 23:43:21', NULL, '@', 0); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_categories_description` -- CREATE TABLE `#__osc_categories_description` ( `categories_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `categories_name` varchar(32) NOT NULL, `categories_description` text NOT NULL, PRIMARY KEY (`categories_id`,`language_id`), KEY `idx_categories_name` (`categories_name`) ) ; -- -- Dumping data for table `#__osc_categories_description` -- INSERT INTO `#__osc_categories_description` (`categories_id`, `language_id`, `categories_name`, `categories_description`) VALUES (1, 1, 'Playstation', 'Playstation Games and Equipment'), (2, 1, 'Computers', 'Computers, laptops and hardware'), (3, 1, 'Software', 'Software, from games to office'), (4, 1, 'PC Games', 'Games for all tastes'), (5, 1, 'General Software', 'Software for professionals or home use'), (6, 1, 'Machines', 'Laptops and desktops'), (7, 1, 'Hardware', ''), (8, 1, 'PS3 Games', 'Games for all tastes'), (9, 1, 'Music', 'Music of all tastes'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_categories_to_suppliers` -- CREATE TABLE `#__osc_categories_to_suppliers` ( `categories_id` int(11) NOT NULL default '-1', `suppliers_id` int(11) NOT NULL default '0', PRIMARY KEY (`categories_id`,`suppliers_id`) ) ; -- -- Dumping data for table `#__osc_categories_to_suppliers` -- -- -------------------------------------------------------- -- -- removed cip and cip_depend -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_compbuild_categories` -- CREATE TABLE `#__osc_compbuild_categories` ( `pc_category_id` int(11) NOT NULL, `pc_category_name` varchar(32) NOT NULL, `pc_category_image` varchar(32) NOT NULL, `osc_category_id` int(11) NOT NULL, `pc_depends_on` int(11) NOT NULL, `pc_system_id` int(11) NOT NULL, `pc_preset_ids` int(11) NOT NULL, `pc_language` int(11) NOT NULL ) ; -- -- Dumping data for table `#__osc_compbuild_categories` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_compbuild_options` -- CREATE TABLE `#__osc_compbuild_options` ( `pc_system_id` int(11) NOT NULL, `pc_system_name` varchar(255) NOT NULL, `pc_system_image` varchar(255) NOT NULL, `pc_system_language` int(11) NOT NULL, `pc_system_assembly` decimal(4,2) NOT NULL, `pc_template` int(11) NOT NULL, `pc_use_osc_cart` int(11) NOT NULL, `pc_add_tax` int(11) NOT NULL, `pc_use_dependence` int(11) NOT NULL, `pc_use_software` int(11) NOT NULL, `pc_currency` varchar(255) NOT NULL ) ; -- -- Dumping data for table `#__osc_compbuild_options` -- INSERT INTO `#__osc_compbuild_options` (`pc_system_id`, `pc_system_name`, `pc_system_image`, `pc_system_language`, `pc_system_assembly`, `pc_template`, `pc_use_osc_cart`, `pc_add_tax`, `pc_use_dependence`, `pc_use_software`, `pc_currency`) VALUES (1, 'Desktop', 'noimg.gif', 0, '0.00', 2, 0, 0, 0, 0, 'USD'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_configuration` -- CREATE TABLE `#__osc_configuration` ( `configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) NOT NULL, `configuration_key` varchar(64) NOT NULL, `configuration_value` varchar(245) NOT NULL, `configuration_description` varchar(245) NOT NULL, `configuration_group_id` int(11) NOT NULL default '0', `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `use_function` varchar(245) default NULL, `set_function` varchar(245) default NULL, PRIMARY KEY (`configuration_id`) ) AUTO_INCREMENT=756 ; -- -- Dumping data for table `#__osc_configuration` -- INSERT INTO `#__osc_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 (1, 'Store Name', 'STORE_NAME', 'ECJC Dev', 'The name of my store', 1, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (2, 'Store Owner', 'STORE_OWNER', 'Craig G Smith', 'The name of my store owner', 1, 2, '2006-08-10 20:26:38', '2005-03-19 02:32:40', '', ''), (3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'craig@ecddesigns.co.za', 'The e-mail address of my store owner', 1, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (4, 'E-Mail From', 'EMAIL_FROM', 'ECJC Dev ', 'The e-mail address used in (sent) e-mails', 1, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (5, 'Country', 'STORE_COUNTRY', '193', 'The country my store is located in

Note: Please remember to update the store zone.', 1, 5, '2006-07-13 21:08:20', '2005-03-19 02:32:40', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('), (6, 'Zone', 'STORE_ZONE', '183', 'The zone my store is located in', 1, 6, '2006-07-13 21:08:26', '2005-03-19 02:32:40', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list('), (7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', 1, 37, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''asc'', ''desc''),'), (8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', 1, 38, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''products_name'', ''date_expected''),'), (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language`s currency when it is changed', 1, 11, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (10, 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 , Name 2 ', 1, 8, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (11, 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', 1, 12, '2008-03-28 18:20:01', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (12, 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', 1, 14, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (13, 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', 1, 34, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (14, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 1, 39, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''and'', ''or''),'), (15, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Store NameAddressCountryPhone', 'This is the Store Name, Address and Phone used on printable documents and displayed online', 1, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_textarea('), (16, 'Show Category Counts', 'SHOW_COUNTS', 'true', 'Count recursively how many products are in each category', 1, 27, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (17, 'Show Hit Counter', 'SHOW_HIT_COUNTER', 'false', 'Display the # of Hits since the Catalog was installed', 1, 23, '2005-03-21 22:35:45', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (18, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 1, 17, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (19, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 18, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (20, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (21, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (22, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (23, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (24, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (25, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', 2, 6, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (26, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (27, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (28, 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', 2, 9, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (29, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (30, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', 2, 11, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (31, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (32, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (33, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (34, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (35, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the ''This Customer Also Purchased'' box', 2, 16, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (36, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (37, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', 3, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (38, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of ''number'' links use for page-sets', 3, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (39, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', 3, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (40, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', 3, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (41, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', 3, 6, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (42, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (43, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is ''1'' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (44, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 8, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (45, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 3, 9, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (46, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', 3, 10, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (47, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', 3, 11, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (48, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', 3, 12, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (49, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', 3, 13, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (50, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', 3, 14, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (51, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', 3, 15, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (52, 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the ''This Customer Also Purchased'' box', 3, 16, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (53, 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', 3, 17, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (54, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 3, 18, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (55, 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', 4, 1, '2008-03-26 00:20:48', '2005-03-19 02:32:40', '', ''), (56, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '100', 'The pixel height of small images', 4, 2, '2008-03-26 00:20:42', '2005-03-19 02:32:40', '', ''), (57, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', 4, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (58, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', 4, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (59, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', 4, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (60, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', 4, 6, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (61, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', 4, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (62, 'Image Required', 'IMAGE_REQUIRED', 'false', 'Enable to display broken images. Good for development.', 4, 8, '2008-03-14 00:18:42', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (63, 'Gender', 'ACCOUNT_GENDER', 'true', 'Display gender in the customers account', 5, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (64, 'Date of Birth', 'ACCOUNT_DOB', 'true', 'Display date of birth in the customers account', 5, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (65, 'Company', 'ACCOUNT_COMPANY', 'true', 'Display company in the customers account', 5, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (66, 'Suburb', 'ACCOUNT_SUBURB', 'true', 'Display suburb in the customers account', 5, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (67, 'State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', 5, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (68, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', '', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, '2008-03-28 18:18:08', '2005-03-19 02:32:40', '', ''), (69, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_loworderfee.php;ot_gv.php;ot_coupon.php;ot_redemptions.php;ot_paydiscount.php;ot_payfee.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, '2008-02-22 16:36:42', '2005-03-19 02:32:40', '', ''), (70, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, '2008-03-28 18:19:04', '2005-03-19 02:32:40', '', ''), (85, 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', 6, 0, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (86, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (87, 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', 6, 0, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (88, 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', 6, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (89, 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '2', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (90, 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', 6, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (91, 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', 6, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', 'currencies->format', ''), (92, 'Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', 6, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''national'', ''international'', ''both''),'), (93, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', 6, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (94, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (95, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', 6, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (96, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '3', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (97, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', 6, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (98, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '99', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (99, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', 7, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('), (100, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (101, 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (102, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', 7, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (103, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (104, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', 8, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (105, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 8, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (106, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', 8, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (107, 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', 8, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (108, 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', 8, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (109, 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 8, 6, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (110, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 8, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (111, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column?', 8, 8, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (112, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 8, 9, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (113, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 8, 10, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (114, 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', 9, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (115, 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', 9, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (116, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', 9, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (117, 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', 9, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (118, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', 9, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (119, 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', 10, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (120, 'Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', 10, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (121, 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', 10, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (122, 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'true', 'Display the page parse time (store page parse time must be enabled)', 10, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (123, 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', 10, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (124, 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', 10, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (125, 'Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', 10, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (126, 'E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', 12, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''sendmail'', ''smtp''),'), (127, 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', 12, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''LF'', ''CRLF''),'), (128, 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', 12, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (129, 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', 12, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (130, 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', 12, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (131, 'Enable download', 'DOWNLOAD_ENABLED', 'true', 'Enable the products download functions.', 13, 1, '2006-07-13 22:00:11', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (132, 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'false', 'Use browser redirection for download. Disable on non-Unix systems.', 13, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (133, 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', 13, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (134, 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', 13, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (135, 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', 15, 1, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', ''), (136, 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'False', 'Force the use of sessions when cookies are only enabled.', 15, 2, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (137, 'Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', 15, 3, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (138, 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', 15, 4, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (139, 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', 15, 5, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (140, 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', 15, 6, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (141, 'Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', 15, 7, '0000-00-00 00:00:00', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (142, 'Use Categories on Home', 'CATEGORIES_BLOCK', 'true', 'This is the flag for the categories block on the home page.', 1, 30, '2006-06-25 13:29:15', '2006-06-25 10:07:04', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (143, 'Welcome Gift Voucher Amount', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Welcome Gift Voucher Amount: If you do not wish to send a Gift Voucher in your create account email put 0 for no amount else if you do place the amount here i.e. 10.00 or 50.00 no currency signs', 1, 32, '0000-00-00 00:00:00', '2003-12-05 05:01:41', '', ''), (144, 'Welcome Discount Coupon Code', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'Welcome Discount Coupon Code: if you do not want to send a coupon in your create account email leave blank else place the coupon code you wish to use', 1, 33, '0000-00-00 00:00:00', '2003-12-05 05:01:41', '', ''), (145, 'Display Total', 'MODULE_ORDER_TOTAL_COUPON_STATUS', 'true', 'Do you want to display the Discount Coupon value?', 6, 1, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (146, 'Sort Order', 'MODULE_ORDER_TOTAL_COUPON_SORT_ORDER', '9', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (147, 'Include Shipping', 'MODULE_ORDER_TOTAL_COUPON_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (148, 'Include Tax', 'MODULE_ORDER_TOTAL_COUPON_INC_TAX', 'true', 'Include Tax in calculation.', 6, 6, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (149, 'Re-calculate Tax', 'MODULE_ORDER_TOTAL_COUPON_CALC_TAX', 'None', 'Re-Calculate Tax', 6, 7, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''None'', ''Standard'', ''Credit Note''),'), (150, 'Tax Class', 'MODULE_ORDER_TOTAL_COUPON_TAX_CLASS', '0', 'Use the following tax class when treating Discount Coupon as Credit Note.', 6, 0, '0000-00-00 00:00:00', '2006-07-02 19:24:22', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes('), (151, 'Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', 6, 1, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (152, 'Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '8', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (153, 'Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', 6, 3, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (154, 'Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (155, 'Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'true', 'Include Tax in calculation.', 6, 6, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (156, 'Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', 6, 7, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''None'', ''Standard'', ''Credit Note''),'), (157, 'Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', 6, 0, '0000-00-00 00:00:00', '2006-07-02 19:24:22', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes('), (158, 'Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', 6, 8, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (159, 'Show Header Bar', 'SHOW_HEADER_BAR', 'true', 'Display the Header Bar above all pages', 1, 21, '2007-01-04 20:47:17', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (160, 'Show Footer Bar', 'SHOW_FOOTER_BAR', 'false', 'Display the Footer Bar below all pages', 1, 22, '2006-06-08 22:23:21', '2005-03-19 02:32:40', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (161, 'Installed Modules', 'MODULE_THEMES_INSTALLED', 'joomlastyle.php', 'This is automatically updated. No need to edit.', 6, 0, '2006-08-10 21:07:28', '2006-06-30 18:10:42', '', ''), (163, 'Theme Path', 'THEME_CURRENT_CONFIG', 'themes/joomlastyle/themeconfig.php', 'Path to the theme files', 0, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (164, 'Enable Points system', 'USE_POINTS_SYSTEM', 'true', 'Enable the system so customers can earn points for orders made?', 22, 1, '2008-02-22 00:14:04', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (165, 'Enable Redemptions system', 'USE_REDEEM_SYSTEM', 'true', 'Enable customers to Redeem points at checkout?', 22, 2, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (166, 'Points per $store_currency purchase', 'POINTS_PER_AMOUNT_PURCHASE', '1', 'No. of points awarded for each $store_currency spent.
(currency defined according to admin default currency)', 22, 3, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (167, 'Currency Redeem per point', 'REDEEM_POINT_VALUE', '0.1', 'The value of one point.
(pointvalue currency defined according to admin default currency)', 22, 4, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (168, 'Auto Credit Pending Points', 'POINTS_AUTO_ON', '', 'Enable Auto Credit Pending Points and set a days period before the reward points will actually added to customers account.
For same day set to 0(zero).
To disable this option leave empty.', 22, 6, '2006-07-07 21:12:36', '2006-07-02 19:24:22', '', ''), (169, 'Award points for shipping', 'USE_POINTS_FOR_SHIPPING', 'false', 'Enable customers to earn points for shipping fees?', 22, 9, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (170, 'Award points for Tax', 'USE_POINTS_FOR_TAX', 'false', 'Enable customers to earn points for Tax?', 22, 10, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (171, 'Award points for Specials', 'USE_POINTS_FOR_SPECIALS', 'true', 'Enable customers to earn points for items already discounted?
When set to false, Points awarded only on items with full price', 22, 11, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (172, 'Award points for order with redeemed points', 'USE_POINTS_FOR_REDEEMED', 'true', 'When order made with Redeemed Points. Enable customers to earn points for the amount spend other then points?
When set to false, customers will NOT awarded even if only part of the payment made by points.', 22, 12, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (174, 'Enable Products Model Restriction', 'RESTRICTION_MODEL', '', 'Restriction Products by model.
Set product model Allowed or leave empty to disable it.', 22, 15, '2008-02-22 00:13:08', '2006-07-02 19:24:22', '', ''), (175, 'Enable Products ID Restriction', 'RESTRICTION_PID', '', 'Restriction Products by Product ID.
Set a comma separated list of Products ID Allowed or leave empty to disable it.', 22, 16, '2008-02-22 00:13:23', '2006-07-02 19:24:22', '', ''), (176, 'Enable Categories ID Restriction', 'RESTRICTION_PATH', '', 'Restriction Products by Categories ID.
Set a comma separated list of Cpaths Allowed or leave empty to disable it.', 22, 17, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (177, 'Enable Products Price Restriction', 'REDEMPTION_DISCOUNTED', 'false', 'When customers redeem points, do you want to exclude items already discounted ?
Redeemptions enabled only on items with full price', 22, 18, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (178, 'If you wish to limit points before Redemptions, set points limit', 'POINTS_LIMIT_VALUE', '0', 'Set the No. of points nedded before they can be redeemed. set to 0 if you wish to disable it', 22, 19, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (179, 'If you wish to limit points to be use per order, set points Max', 'POINTS_MAX_VALUE', '1000', 'Set the Maximum No. of points customer can redeem per order. to avoid points maximum limit, set to high No.', 22, 20, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (182, 'Restrict Points Redemption For Minimum Purchase Amount', 'POINTS_MIN_AMOUNT', '', 'Enter the Minimum Purchase Amount(total cart contain) required before Redemptions enabled.
Leave empty for no Restriction', 22, 21, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (183, 'New signup customers Welcome Points amount', 'NEW_SIGNUP_POINT_AMOUNT', '0', 'Set the Welcome Points amount to be auto-credited for New signup customers. set to 0 if you wish to disable it', 22, 22, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (184, 'Maximum number of points records to display', 'MAX_DISPLAY_POINTS_RECORD', '20', 'Set the Maximum number of points records to display per page in my_points.php page', 22, 23, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (185, 'Display Points information in Product info page', 'DISPLAY_POINTS_INFO', 'true', 'Do you want to show Points information Product info page?', 22, 24, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (186, 'Keep Records of Redeemed Points', 'DISPLAY_POINTS_REDEEMED', 'true', 'Do you want to keep records of all Points redeemed?', 22, 25, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (187, 'Sort Order', 'MODULE_ORDER_TOTAL_REDEMPTIONS_SORT_ORDER', '11', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2006-07-02 19:24:22', '', ''), (188, 'Show empty new products', 'NEW_PRODUCTS_OLD_SHOW', '1', 'Show the box if no new products in period, 2 = show, 1 = hide.', 8, NULL, '2008-03-28 18:21:23', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''1'', ''2''),'), (189, 'Products new for', 'NEW_PRODUCTS_OLD_DAYS', '30', 'How many days a product is shown as being new.', 8, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (190, 'Text to display if now new products', 'NEW_PRODUCTS_OLD_TEXT', 'Sorry, We have no new products this month', 'Text to display on the page if there are now new products for the period of time specified, ignored if showbox switched off.', 8, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (191, 'E-Mail Address', 'AFFILIATE_EMAIL_ADDRESS', '', 'The E Mail Address for the Affiliate Program', 900, 1, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (192, 'Affiliate Pay Per Sale Payment % Rate', 'AFFILIATE_PERCENT', '10.0000', 'Percentage Rate for the Affiliate Program', 900, 2, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (193, 'Payment Threshold', 'AFFILIATE_THRESHOLD', '50.00', 'Payment Threshold for paying affiliates', 900, 3, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (194, 'Cookie Lifetime', 'AFFILIATE_COOKIE_LIFETIME', '7200', 'How long does the click count (seconds) if customer comes back', 900, 4, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (195, 'Billing Time', 'AFFILIATE_BILLING_TIME', '30', 'Orders billed must be at least `30` days old.
This is needed if a order is refunded', 900, 5, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (196, 'Order Min Status', 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS', '3', 'The status an order must have at least, to be billed', 900, 6, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (197, 'Pay Affiliates with check', 'AFFILIATE_USE_CHECK', 'true', 'Pay Affiliates with check', 900, 7, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (198, 'Pay Affiliates with PayPal', 'AFFILIATE_USE_PAYPAL', 'true', 'Pay Affiliates with PayPal', 900, 8, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (199, 'Pay Affiliates by Bank', 'AFFILIATE_USE_BANK', 'true', 'Pay Affiliates by Bank', 900, 9, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (200, 'Individual Affiliate Percentage', 'AFFILATE_INDIVIDUAL_PERCENTAGE', 'true', 'Allow per Affiliate provision', 900, 10, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (201, 'Use Affiliate-tier', 'AFFILATE_USE_TIER', 'false', 'Multilevel Affiliate provisions', 900, 11, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (202, 'Number of Tierlevels', 'AFFILIATE_TIER_LEVELS', '0', 'Number of Tierlevels', 900, 12, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (203, 'Percentage Rate for the Tierlevels', 'AFFILIATE_TIER_PERCENTAGE', '8.00;5.00;1.00', 'Percent Rates for the tierlevels
Example: 8.00;5.00;1.00', 900, 13, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (204, 'Affiliate News', 'MAX_DISPLAY_AFFILIATE_NEWS', '3', 'Maximum number of items to display on the Affiliate News page', 900, 14, '0000-00-00 00:00:00', '2006-07-02 19:33:25', '', ''), (205, 'Down for Maintenance: ON/OFF', 'DOWN_FOR_MAINTENANCE', 'false', 'Down for Maintenance
(true=on false=off)', 25, 1, '2008-03-25 23:51:56', '2006-07-04 23:28:33', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (207, 'Down for Maintenance: Hide Header', 'DOWN_FOR_MAINTENANCE_HEADER_OFF', 'false', 'Down for Maintenance: Hide Header
(true=hide false=show)', 25, 3, '0000-00-00 00:00:00', '2006-07-04 23:28:33', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (210, 'Down for Maintenance: Hide Footer', 'DOWN_FOR_MAINTENANCE_FOOTER_OFF', 'false', 'Down for Maintenance: Hide Footer
(true=hide false=show)', 25, 6, '0000-00-00 00:00:00', '2006-07-04 23:28:33', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (211, 'Down for Maintenance: Hide Prices', 'DOWN_FOR_MAINTENANCE_PRICES_OFF', 'true', 'Down for Maintenance: Hide Prices
(true=hide false=show)', 25, 7, '2006-07-04 23:37:20', '2006-07-04 23:28:33', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (212, 'Down For Maintenance (exclude this IP-Address)', 'EXCLUDE_ADMIN_IP_FOR_MAINTENANCE', '127.0.0.2', 'This IP Address is able to access the website while it is Down For Maintenance (like webmaster)', 25, 8, '2008-03-15 15:39:54', '2003-03-21 21:20:07', '', ''), (213, 'NOTIFY PUBLIC Before going Down for Maintenance: ON/OFF', 'WARN_BEFORE_DOWN_FOR_MAINTENANCE', 'false', 'Give a WARNING some time before you put your website Down for Maintenance
(true=on false=off)
If you set the ''Down For Maintenance: ON/OFF'' to true this will automaticly be updated to false', 25, 9, '2003-03-21 13:08:25', '2003-03-21 11:42:47', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (214, 'Date and hours for notice before maintenance', 'PERIOD_BEFORE_DOWN_FOR_MAINTENANCE', '16/05/2003 between the hours of 2-3 PM', 'Date and hours for notice before maintenance website, enter date and hours for maintenance website', 25, 10, '2003-03-21 13:08:25', '2003-03-21 11:42:47', '', ''), (215, 'Display when webmaster has enabled maintenance', 'DISPLAY_MAINTENANCE_TIME', 'false', 'Display when Webmaster has enabled maintenance
(true=on false=off)
', 25, 11, '2003-03-21 13:08:25', '2003-03-21 11:42:47', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (216, 'Display website maintenance period', 'DISPLAY_MAINTENANCE_PERIOD', 'false', 'Display Website maintenance period
(true=on false=off)
', 25, 12, '2003-03-21 13:08:25', '2003-03-21 11:42:47', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (217, 'Website maintenance period', 'TEXT_MAINTENANCE_PERIOD_TIME', '2h00', 'Enter Website Maintenance period (hh:mm)', 25, 13, '2003-03-21 13:08:25', '2003-03-21 11:42:47', '', ''), (218, 'Down for Maintenance: Hide Column Left', 'DOWN_FOR_MAINTENANCE_COLUMN_LEFT_OFF', 'false', 'Down for Maintenance: Hide Column Left
(true=hide false=show)', 245, 4, '0000-00-00 00:00:00', '2006-07-04 23:57:16', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (219, 'Down for Maintenance: Hide Column Right', 'DOWN_FOR_MAINTENANCE_COLUMN_RIGHT_OFF', 'false', 'Down for Maintenance: Hide Column Right
(true=hide false=show)r', 245, 5, '0000-00-00 00:00:00', '2006-07-04 23:57:16', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (220, 'Down for Maintenance: filename', 'DOWN_FOR_MAINTENANCE_FILENAME', 'down_for_maintenance.php', 'Down for Maintenance filename Default=down_for_maintenance.php', 245, 2, '0000-00-00 00:00:00', '2006-07-04 23:59:36', '', ''), (224, 'Points Decimal Places', 'POINTS_DECIMAL_PLACES', '0', 'Pad the points value this amount of decimal places', 0, 5, '2006-07-07 21:12:36', '2006-07-07 21:12:36', '', ''), (225, 'Auto Expires Points', 'POINTS_AUTO_EXPIRES', '12', 'Set a month period before points will auto Expires.
To disable this option leave empty.', 0, 7, '2006-07-07 21:12:36', '2006-07-07 21:12:36', '', ''), (226, 'Points Expires Auto Remainder', 'POINTS_EXPIRES_REMIND', '30', 'Enable Points Expires Auto Remainder and set the numbers of days prior points expiration for the script to run.(Auto Expires Points must be enabled)
To disable this option leave empty.', 0, 8, '2006-07-07 21:12:36', '2006-07-07 21:12:36', '', ''), (227, 'Award points for Products Reviews', 'USE_POINTS_FOR_REVIEWS', '50', 'If you want to award points when customers add Product Review, set the points amount to be given or leave empty to disable this option', 0, 13, '2006-07-07 21:12:59', '2006-07-07 21:12:59', '', ''), (228, 'Enable and set points for Referral System', 'USE_REFERRAL_SYSTEM', '100', 'Do you want to Enable the Referral System and award points when customers refer someone?
Set the amount of points to be given or leave empty to disable this option.', 0, 14, '2006-07-07 21:12:59', '2006-07-07 21:12:59', '', ''), (229, 'Header Text', 'FAMILY_HEADER_TEXT', 'Similar Products', 'The text that will appear as the header of the Family Products v3.0 module.', 16, 1, '2008-03-28 23:13:32', '0000-00-00 00:00:00', '', ''), (230, 'Family Header Format', 'FAMILY_HEADER_FORMAT', 'Family Text', 'Please choose whether your headers of your families will be your default text or the actual name of the family.', 16, 2, '2008-03-28 23:13:56', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''Family Text'', ''Family Name''),'), (231, 'Family Display Type', 'FAMILY_DISPLAY_TYPE', 'Box', 'Please choose whether you would like to display an infoBox or a list.', 16, 3, '2003-09-09 11:14:45', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''Box'', ''List'', ''None''),'), (232, 'Family Display Format', 'FAMILY_DISPLAY_FORMAT', 'Seperate', 'Please choose whether you would like to randomly select products frm all matching families, or if you would like to display seperate families.', 16, 4, '2008-03-28 23:14:17', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''Random'', ''Seperate''),'), (233, 'Display Low Order Fee', 'MODULE_ORDER_TOTAL_LOWORDERFEE_STATUS', 'true', 'Do you want to display the low order fee?', 6, 1, '0000-00-00 00:00:00', '2006-07-07 23:45:32', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (234, 'Sort Order', 'MODULE_ORDER_TOTAL_LOWORDERFEE_SORT_ORDER', '4', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '2006-07-07 23:45:32', '', ''), (235, 'Allow Low Order Fee', 'MODULE_ORDER_TOTAL_LOWORDERFEE_LOW_ORDER_FEE', 'false', 'Do you want to allow low order fees?', 6, 3, '0000-00-00 00:00:00', '2006-07-07 23:45:32', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (236, 'Order Fee For Orders Under', 'MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER', '50', 'Add the low order fee to orders under this amount.', 6, 4, '0000-00-00 00:00:00', '2006-07-07 23:45:32', 'currencies->format', ''), (237, 'Order Fee', 'MODULE_ORDER_TOTAL_LOWORDERFEE_FEE', '5', 'Low order fee.', 6, 5, '0000-00-00 00:00:00', '2006-07-07 23:45:32', 'currencies->format', ''), (238, 'Attach Low Order Fee On Orders Made', 'MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION', 'both', 'Attach low order fee for orders sent to the set destination.', 6, 6, '0000-00-00 00:00:00', '2006-07-07 23:45:32', '', 'tep_cfg_select_option(array(''national'', ''international'', ''both''),'), (239, 'Tax Class', 'MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS', '0', 'Use the following tax class on the low order fee.', 6, 7, '0000-00-00 00:00:00', '2006-07-07 23:45:32', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes('), (240, 'Show Prize Giveaways', 'CONTEST_SHOW', 'true', 'Show Prize Giveaways in the store. [ True / False ]', 50, 1, '2006-07-08 00:47:17', '2006-07-08 00:26:04', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (241, 'Display Contestant Entries', 'CONTEST_MAX_DISPLAY_ENTRIES', '6', 'Maximum number of contest entries to display in prize contestants page.', 50, 2, '0000-00-00 00:00:00', '2006-07-08 00:26:04', '', ''), (242, 'Number of Contest Page Links', 'CONTEST_MAX_DISPLAY_PAGE_LINKS', '5', 'Number of ''number'' links use for page-sets on prize contestants page.', 50, 3, '0000-00-00 00:00:00', '2006-07-08 00:26:04', '', ''), (243, 'Min. Length of Contestants Name ''Full Name''', 'ENTRANTS_NAME_MIN_LENGTH', '4', 'Minimum length of ''Full Name'' on enter contest page.', 50, 4, '0000-00-00 00:00:00', '2006-07-08 00:26:04', '', ''), (244, 'Min. Length of Contestants ''Comments''', 'CONTEST_TEXT_MIN_LENGTH', '25', 'Minimum length of ''Comments'' text on enter contest page.', 50, 5, '0000-00-00 00:00:00', '2006-07-08 00:26:04', '', ''), (245, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'CONTEST_PREV_NEXT_BAR_LOCATION', '3', 'Sets the location of the Prev/Next Navigation Bar on the Prize Contestants page.
[ 1-top
2-bottom
3-both ]', 50, 6, '0000-00-00 00:00:00', '2006-07-08 00:26:04', '', ''), (246, 'Minimum Account Age', 'MIN_AGE', '', 'Defines the minimum age at which an account can be opened.', 2, 600, '2002-03-21 13:33:50', '2002-03-21 13:25:53', '', ''), (247, 'Require Minimum Age for Contest', 'REQUIRE_DOB', 'false', 'Require a minimum age to enter contest. Uses the Store create account minimum age setting. [ True / False ]', 50, 8, '0000-00-00 00:00:00', '2006-07-08 00:29:29', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (248, 'Display Product Dimensions', 'PRODUCT_LIST_DIMENSIONS', '0', 'Do you want to display the Product Dimensions ?(0-No, 1-Yes)', 8, 11, '0000-00-00 00:00:00', '2006-07-08 01:20:15', '', ''), (249, 'Disable Checkout', 'DISABLE_CHECKOUT', 'false', 'select true to disable checkout', 1, 19, '2006-07-08 02:42:33', '2006-07-08 01:37:16', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (250, 'Domain Checker', 'DOMAINS_SHOW', 'true', 'Use the domain check and purchace facility', 1, 26, '2006-07-08 20:26:28', '2006-07-08 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (309, 'EPDQ OID', 'MODULE_PAYMENT_EPDQ_OID', '1234567', 'Helps create a unique OID.', 6, 6, '0000-00-00 00:00:00', '2006-07-09 19:21:19', '', ''), (311, 'EPDQ return URL limit', 'MODULE_PAYMENT_EPDQ_LIMIT', '100', 'The wait before EPDQ re-directs back to ReturnURL (1000 == 1 second)', 6, 8, '0000-00-00 00:00:00', '2006-07-09 19:21:19', '', ''), (314, 'Ip to exclude from tracking', 'TRACKER_EXCLUDE_IP', '', 'Put your IP here to exclude yourself from the tracking reports.', 17, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (315, 'Exlcude Bots', 'TRACKER_EXCLUDE_BOTS', 'true', 'Exclude Bots from tracking report', 17, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''''true'''', ''''false''''),'), (316, 'Use Pay Per click', 'SUPERTRACKER_USE_PPC', 'false', 'Use pay per click tracking (untested)', 17, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (317, 'Use Tracking', 'TRACKING_USE', 'False', 'Enable tracking of visitors to the site?', 17, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO `#__osc_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 (326, 'Use Gift Vouchers', 'SHOW_GIFT_VOUCHER', 'false', 'Use gift voucher system?', 1, 31, '2008-03-28 18:20:28', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (327, 'Use Community Builder for joomla?', 'USE_JOOMLA_CB', 'false', 'Set this to true if you are using community builder in joomla.', 1, 13, '2006-08-07 20:04:18', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (328, 'Hide Prices', 'SHOW_HIDE_PRICES', 'false', 'Hide prices in the store?', 1, 16, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (329, 'Only Logged in user prices', 'SHOW_HIDE_USERPRICE', 'false', 'allow only registered users to see prices?', 1, 15, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (330, 'Image Popup width', 'POP_WIN_WIDTH', '300', 'The width of the popup window of product', 4, 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (331, 'Image Popup Height', 'POP_WIN_HIGHT', '300', 'Height of the popup window of product', 4, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (395, 'Enable JoomlaStyle Theme?', 'MODULE_THEMES_JOOMLASTYLE_STATUS', 'True', 'Enable JoomlaStyle Theme?', 6, 0, '0000-00-00 00:00:00', '2006-08-10 21:07:26', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (396, 'Show Status Scroller', 'SHOW_STATUS_SCROLLER', 'false', 'Show the status bar scroller of current items in the shopping cart.', 1, 28, '2007-01-04 20:49:11', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (397, 'Use Pricematch?', 'SHOW_PRICEMATCH', 'false', 'Use Pricematch system?', 1, 29, '2007-01-11 23:02:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (398, 'Agree to terms on checkout?', 'USE_TERMS_CONFIRM', 'false', 'Force client to agree to terms on each checkout?', 1, 20, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (399, 'Use System As Catalogue?', 'USE_AS_CATALOGUE', 'false', 'Use the sytem as a catalogue?', 1, 9, '2007-01-04 17:46:06', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (400, 'Show current specials on the cataloge front page?', 'SHOW_SPECIALS_INDEX', 'true', 'Show current specials on the cataloge front page?', 1, 24, NULL, '2006-08-16 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (401, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', 6501, 10, NULL, '2006-09-15 23:35:14', '', ''), (402, 'Skip days', 'RCS_SKIP_DAYS', '5', 'Number of days to skip when looking for abandoned carts.', 6501, 11, NULL, '2006-09-15 23:35:14', '', ''), (403, 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', 'Number of days the sales results report takes into account. The more days the longer the SQL queries!.', 6501, 15, NULL, '2006-09-15 23:35:14', '', ''), (404, 'Use Calculated taxes', 'RCS_INCLUDE_TAX_IN_PRICES', 'false', 'Try to calculate the taxes when determining prices. This may not be 100% correct as determing location being shopped from, etc. may be incorrect.', 6501, 16, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (405, 'Use Fixed tax rate', 'RCS_USE_FIXED_TAX_IN_PRICES', 'false', 'Use a fixed tax rate when determining prices (rate set below). Overridden if ''Use Calculated taxes'' is true.', 6501, 17, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (406, 'Fixed Tax Rate', 'RCS_FIXED_TAX_RATE', '.10', 'The fixed tax rate for use when ''Use Fixed tax rate'' is true and ''Use Calculated taxes'' is false.

Use decimal values, ie: 0.10 for 10%', 6501, 18, NULL, '2006-09-15 23:35:14', '', ''), (407, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', 6501, 20, NULL, '2006-09-15 23:35:14', '', ''), (408, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer`s name will be used in the greeting. If false then a generic greeting will be used.', 6501, 30, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (409, 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', 'If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent', 6501, 35, NULL, '2006-09-15 23:35:14', '', ''), (410, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.

Some sites have attributes for their items.

Set this to true if yours does and you want to show them, otherwise set to false.', 6501, 40, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (411, 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', 'If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to true.

Setting this to false will operate in the default manner of ignoring session data & using less resources.', 6501, 40, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (412, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer

A current customer is someone who has purchased items from your store in the past.', 6501, 50, NULL, '2006-09-15 23:35:14', '', ''), (413, 'Uncontacted highlight color', 'RCS_UNCONTACTED_COLOR', '9FFF9F', 'Row highlight color for uncontacted customers.

An uncontacted customer is one that you have not used this tool to send an email to before.', 6501, 60, NULL, '2006-09-15 23:35:14', '', ''), (414, 'Contacted highlight color', 'RCS_CONTACTED_COLOR', 'FF9F9F', 'Row highlight color for contacted customers.

An contacted customer is one that you have used this tool to send an email to before.', 6501, 70, NULL, '2006-09-15 23:35:14', '', ''), (415, 'Matching Order Highlight', 'RCS_MATCHED_ORDER_COLOR', '9FFFFF', 'Row highlight color for entrees that may have a matching order.

An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart`s customer email address or datab', 6501, 72, NULL, '2006-09-15 23:35:14', '', ''), (416, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.

Setting this to false will cause entries with a matching order to show, along with the matching order`s status.

See documentation for details.', 6501, 80, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (417, 'Autocheck ''safe'' carts to email', 'RCS_AUTO_CHECK', 'true', 'To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to true.

Setting this to false will leave all entries unchecked (must manually check entries to send an', 6501, 82, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (418, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.

If false only orders placed after the abandoned cart are considered.', 6501, 84, NULL, '2006-09-15 23:35:14', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (419, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', 6501, 90, NULL, '2006-09-15 23:35:14', '', ''), (420, 'Short description length - Module', 'SHORT_DISC_IN_PROD', '80', 'Length of the short discription you would like to show in side modules, set to 0 to disable', 1, 35, NULL, '0000-00-00 00:00:00', NULL, NULL), (421, 'Short description length - Main', 'SHORT_DISC_IN_PROD2', '0', 'Length of the short discription you would like to show in main window, set to 0 to disable', 1, 36, '2007-01-04 19:47:16', '0000-00-00 00:00:00', NULL, NULL), (422, 'Contribution Directory', 'DIR_FS_CIP', 'C:/www/webroot/ecjc/administrator/components/com_oscommerce/contributions', 'Location of contribution files', 6502, 5, '2006-09-17 13:43:25', '2006-09-17 13:43:25', NULL, NULL), (423, 'Backup Database Before Install Each CIP', 'ALLOW_SQL_BACKUP', 'true', 'Choose TRUE and database will be backuped before each CIP install.
CIP.NET.UA Advise:
Do backup if database isn`t huge or for debugging.', 6502, 10, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (424, 'Restore Database When Remove Each CIP', 'ALLOW_SQL_RESTORE', 'false', 'Choose TRUE and files will be restored from backup.\n
CIP.NET.UA Advise:
Backup doesn`t contain changes made after CIP installation.
Use restoring only when build a new store or debug.', 6502, 20, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (425, 'Backup Files Before Install Each CIP', 'ALLOW_FILES_BACKUP', 'true', 'Choose TRUE and files will be backuped.
Backup contain only files which CIP will modify.
CIP.NET.UA Advise:
We recommend to do a files backup.', 6502, 15, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (426, 'Restore Files When Remove Each CIP', 'ALLOW_FILES_RESTORE', 'false', 'Choose TRUE and files will be restored from backup.\n
CIP.NET.UA Advise:
Backup doesn`t contain changes made after CIP installation.
Use restoring only when build a new store or debug.', 6502, 25, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (427, 'Allow Overwrite Existing Modified Files', 'ALLOW_OVERWRITE_MODIFIED', 'false', 'Choose TRUE and ADDFILE will overwrite even files with changes.
CIP.NET.UA Advise:
All changes will be lost. Use only for testing and debugging.', 6502, 30, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (428, 'Forum Link', 'TEXT_LINK_FORUM', 'http://www.vxd-hosting.co.za/forums.html', 'URL for support forum at vxd-hosting.co.za', 6502, 50, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, NULL), (429, 'URL to the Contribution''s page', 'TEXT_LINK_CONTR', 'http://www.vxd-hosting.co.za/forum/User-Contributions/', 'URL for contrib''s page at VXD-Hosting', 6502, 130, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, NULL), (430, 'Always Display Remove-Button', 'ALWAYS_DISPLAY_REMOVE_BUTTON', 'false', 'Choose TRUE and REMOVE button will be displayed for both installed and NOT installed CIPs.', 6502, 30, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (431, 'Always Display Install-Button', 'ALWAYS_DISPLAY_INSTALL_BUTTON', 'false', 'Choose TRUE and INSTALL button will be displayed for both installed and NOT installed CIPs.', 6502, 30, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (432, 'Show User/Group Column', 'SHOW_PERMISSIONS_COLUMN', 'true', 'Choose TRUE and permissions column will be shown.', 6502, 300, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (433, 'Show Permissions Column', 'SHOW_USER_GROUP_COLUMN', 'true', 'Choose TRUE and User/Group column will be shown.', 6502, 300, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (434, 'Show Uploader Column', 'SHOW_UPLOADER_COLUMN', 'false', 'Choose TRUE and Uploader column will be shown.', 6502, 300, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (435, 'Show Date Uploaded Column', 'SHOW_UPLOADED_COLUMN', 'false', 'Choose TRUE and Date Uploaded column will be shown.', 6502, 300, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (436, 'Show Size Column', 'SHOW_SIZE_COLUMN', 'false', 'Choose TRUE and Size column will be shown.', 6502, 300, '2006-09-17 13:43:26', '2006-09-17 13:43:26', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (437, 'Use the wishlist functions?', 'SHOW_WISHLIST', 'false', 'Do you want to display the add to wishlist button?', 1, 25, '2006-12-24 19:31:46', '2005-04-25 11:00:43', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (438, 'Enable Vendor Shipping', 'SELECT_VENDOR_SHIPPING', 'false', 'Enable Multi-Vendor shipping-(true/false)', 7, 6, '2008-03-28 18:21:06', '2004-05-04 14:43:03', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (439, 'Use Optional Confirmation Email', 'SELECT_VENDOR_EMAIL_OPTION', 'false', 'Use the email showing a seperated list of Vendor`s group of products-(true/false)', 7, 10, '2005-03-16 08:10:45', '2004-05-04 14:43:03', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (440, 'When to send the Vendor Email', 'SELECT_VENDOR_EMAIL_WHEN', 'Admin', 'Select when in the checkout process to send the email to the Vendors. You can also disable automatic email. See the readme.txt file for details on these options.', 7, 11, NULL, '2005-04-25 11:00:43', NULL, 'tep_cfg_select_option(array(''Catalog'', ''Admin'', ''Both'', ''Not at all''),'), (449, 'Show GA', 'SHOW_GA', '', 'show GA', 1, NULL, NULL, '0000-00-00 00:00:00', NULL, NULL), (450, 'Current Version', 'ECJC_CURR_VERSION', '1.1.99', 'this should be hidden?', 9001, NULL, NULL, '0000-00-00 00:00:00', NULL, NULL), (451, 'Purchase without account', 'PURCHASE_WITHOUT_ACCOUNT', 'no', 'Do you allow customers to purchase without an account?', 5, 10, NULL, '2008-02-21 22:13:01', NULL, 'tep_cfg_select_option(array(''yes'', ''no''), '), (452, 'Purchase without account shippingaddress', 'PURCHASE_WITHOUT_ACCOUNT_SEPARATE_SHIPPING', 'no', 'Do you allow customers without account to create separately shipping address?', 5, 11, NULL, '2008-02-21 22:13:01', NULL, 'tep_cfg_select_option(array(''yes'', ''no''), '), (453, 'Use Css Instead of button images?', 'USE_CSS_BUTTONS', 'no', 'Do you want to use css buttons or image buttons?', 1, 10, '2008-03-28 18:19:48', '2008-02-21 22:13:01', NULL, 'tep_cfg_select_option(array(''yes'', ''no''), '), (454, 'Use Resampling', 'THUMBNAIL_USE_RESAMPLING', 'true', 'Set the value to true to generate resampled thumbnails resulting in smoother-looking images. (Not supported in GD versions < 2.0.1)', 4, 10, '2008-03-26 00:11:09', '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (455, 'Use True Colour', 'THUMBNAIL_TRUE_COLOUR', 'true', 'Create true colour thumbnails. Provides better overall quality but set to false if GD version < 2.0.1 or if creating transparent thumbnails.', 4, 11, NULL, '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (456, 'Output GIF as JPEG', 'THUMBNAIL_OUTPUT_JPEG', 'false', 'Output GIF as JPEG instead of GIF or PNG. Note that your GIF transparencies will not be retained. Requires GD version > 1.6. Set the ''Background matte colour'' below if setting this option to true.', 4, 12, NULL, '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (457, 'Background matte colour (GIF as JPEG)', 'THUMBNAIL_BACKGROUND_MATTE', '255,255,255', 'Define RGB colour value for background matte if outputting GIF as JPEG in the format 255,255,255 (comma delimited). An example of the RGB colour system: WHITE=255,255,255; BLACK=0,0,0; RED=255,0,0.', 4, 13, NULL, '2007-06-04 22:15:44', NULL, NULL), (458, 'Cache images on the server', 'THUMBNAIL_CACHE_SERVER', 'true', 'Save requested thumbnails on the server. Recommended setting is ''true''. This will use slightly more disk space but save processor and bandwidth.', 4, 14, NULL, '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (459, 'Thumbnail path', 'THUMBNAIL_PATH', '', 'Specify a sub-directory for the thumbnail cache. Leave blank for the catalog/images/ directory (default). Use ''thumbnails/'' syntax (with trailing slash) to create a separate directory and chmod it to 777.', 4, 15, NULL, '2007-06-04 22:15:44', NULL, NULL), (460, 'Cache images in browser', 'THUMBNAIL_CACHE_BROWSER', 'false', 'Allow browsers to cache thumbnails locally. This will save having to transfer another copy of the same file for each successive view. Recommended setting is ''true''.', 4, 16, '2008-03-26 00:13:14', '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (461, 'JPEG Compression Level', 'THUMBNAIL_JPEG_COMPRESSION', '70', 'Set the JPEG compression quality for resampled images. The default is 100. Recommended setting is 70.', 4, 17, NULL, '2007-06-04 22:15:44', NULL, NULL), (462, 'Allow larger', 'THUMBNAIL_ALLOW_LARGER', 'true', 'Allow the creation of thumbnail images that are larger than their original counterpart. This causes upsampling and can make the images distorted.', 4, 18, '2008-03-10 19:40:25', '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (463, 'Show original', 'THUMBNAIL_SHOW_ORIGINAL', 'true', 'If ''Allow larger'' is set to false, you can opt to output the original image. Better leave it true if you want pixel_trans_* to work as expected.', 4, 19, '2008-03-26 00:12:15', '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (464, 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', 12, 0, '2008-03-01 23:13:28', '2008-02-21 22:13:01', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (465, 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 'The time zone difference between your store and the server. Enter +h, 0 or -h where ''h'' is the number of hours. If your store time zone is ahead of the server time zone, use +', 1, 7, NULL, '0001-01-01 00:00:00', NULL, NULL), (466, 'Display Add Multiples column', 'PRODUCT_LIST_MULTIPLE', '0', 'Do you want to display the Multiple Quantity with Attributes column?', 8, 15, NULL, '2008-02-21 22:13:02', NULL, NULL), (467, 'Display Add Multiples with Buy Now column', 'PRODUCT_LIST_BUY_NOW_MULTIPLE', '0', 'Do you want to display the Multiple Quantity Buy Now with Attributes column?', 8, 16, NULL, '2008-02-21 22:13:02', NULL, NULL), (468, 'Display column count', 'PRODUCT_LIST_MULTIPLE_COLS', '2', 'How many columns to display', 8, 16, NULL, '2008-02-21 22:13:02', NULL, NULL), (469, 'Auto-Login', '_AUTO_LOGIN', 'true', 'Automatically log customers in on account creation, Joomla account confirmation must be set to no.', 1, 10, '2008-02-22 19:00:15', '2007-06-04 22:15:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (470, 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(''false'', ''true''),'), (471, 'Award points for Products Reviews', 'USE_POINTS_FOR_REVIEWS', '50', 'If you want to award points when customers add Product Review, set the points amount to be given or leave empty to disable this option', 22, 13, '2008-02-21 22:13:07', '2008-02-21 22:13:07', NULL, NULL), (472, 'Use Lightbox', 'IMAGE_LIGHTBOX', 'true', 'Enable to use a lightbox for images in the product info pages.', 4, 9, '2008-03-26 00:26:13', '2008-02-21 22:13:07', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (473, 'Product Quantities In Shopping Cart', 'MAX_QTY_IN_CART', '99', 'Maximum number of product quantities that can be added to the shopping cart (0 for no limit)', 3, 19, NULL, '2008-02-21 22:13:07', NULL, NULL), (474, 'Use Quote system', 'GALLARY_QUOTE', 'false', 'Use Quote System, if false will not display the quote button but rather the add to cart button', 9, 9, '2008-03-28 23:30:38', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(''false'', ''true''),'), (488, 'Calculate Tax', 'MODULE_PAYMENT_DISC_CALC_TAX', 'false', 'Re-calculate Tax on discounted amount.', 6, 5, NULL, '2008-02-22 16:32:52', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (487, 'Discount Percentage', 'MODULE_PAYMENT_DISC_PERCENTAGE', '2', 'Amount of Discount(percentage).', 6, 7, NULL, '2008-02-22 16:32:52', NULL, NULL), (486, 'Include Tax', 'MODULE_PAYMENT_DISC_INC_TAX', 'true', 'Include Tax in calculation.', 6, 6, NULL, '2008-02-22 16:32:52', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (484, 'Sort Order', 'MODULE_PAYMENT_DISC_SORT_ORDER', '15', 'Sort order of display.', 6, 2, NULL, '2008-02-22 16:32:52', NULL, NULL), (485, 'Include Shipping', 'MODULE_PAYMENT_DISC_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, NULL, '2008-02-22 16:32:52', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (483, 'Display Total', 'MODULE_PAYMENT_DISC_STATUS', 'true', 'Do you want to enable the Order Discount?', 6, 1, NULL, '2008-02-22 16:32:52', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (489, 'Minimum Amount', 'MODULE_PAYMENT_DISC_MINIMUM', '500', 'Minimum order before discount', 6, 2, NULL, '2008-02-22 16:32:52', NULL, NULL), (490, 'Payment Type', 'MODULE_PAYMENT_DISC_TYPE', 'cod', 'Payment Type to get discount', 6, 2, NULL, '2008-02-22 16:32:52', NULL, NULL), (491, 'Display Total', 'MODULE_PAYMENT_FEE_STATUS', 'true', 'Do you want to enable the Order Fee?', 6, 1, NULL, '2008-02-22 16:36:13', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (492, 'Sort Order', 'MODULE_PAYMENT_FEE_SORT_ORDER', '16', 'Sort order of display.', 6, 2, NULL, '2008-02-22 16:36:13', NULL, NULL), (493, 'Include Shipping', 'MODULE_PAYMENT_FEE_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, NULL, '2008-02-22 16:36:13', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (494, 'Include Tax', 'MODULE_PAYMENT_FEE_INC_TAX', 'true', 'Include Tax in calculation.', 6, 6, NULL, '2008-02-22 16:36:13', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (495, 'Fee Percentage', 'MODULE_PAYMENT_FEE_PERCENTAGE', '3', 'Amount of Fee(percentage).', 6, 7, NULL, '2008-02-22 16:36:13', NULL, NULL), (496, 'Calculate Tax', 'MODULE_PAYMENT_FEE_CALC_TAX', 'false', 'Re-calculate Tax on new amount.', 6, 5, NULL, '2008-02-22 16:36:13', NULL, 'tep_cfg_select_option(array(''true'', ''false''), '), (497, 'Minimum Amount', 'MODULE_PAYMENT_FEE_MINIMUM', '20', 'Minimum order before Fee', 6, 2, NULL, '2008-02-22 16:36:13', NULL, NULL), (498, 'Payment Type', 'MODULE_PAYMENT_FEE_TYPE', 'cod', 'Payment Type to get Fee', 6, 2, NULL, '2008-02-22 16:36:13', NULL, NULL), (499, 'Show Subscriptions', 'SHOW_SUBS', 'false', 'Show subscriptions section under the my account section', 1, 20, '2008-02-25 21:37:42', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (500, 'Display the model', 'DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 400, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (501, 'Modify the model', 'MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 400, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (502, 'Modify the name of the products', 'MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 400, 3, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (503, 'Modify the status of the products', 'DISPLAY_STATUT', 'true', 'Allow/Disallow the Status displaying and modification', 400, 4, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (504, 'Modify the weight of the products', 'DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 400, 5, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (505, 'Modify the quantity of the products', 'DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 400, 6, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (506, 'Modify the image of the products', 'DISPLAY_IMAGE', 'false', 'Allow/Disallow the Image displaying and modification', 400, 7, '2003-06-04 05:06:52', '2003-06-04 04:36:57', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (507, 'Modify the manufacturer of the products', 'MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 400, 8, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (508, 'Modify the class of tax of the products', 'MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 400, 9, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (509, 'Display price with all included of tax', 'DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 400, 10, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (510, 'Display price with all included of tax', 'DISPLAY_TVA_UP', 'true', 'Enable/Disable the displaying of the Price with all tax included when you are typing the price?', 400, 11, '2003-06-04 05:07:06', '2003-06-04 04:40:12', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (511, 'Display the link towards the products information page', 'DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 400, 12, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (512, 'Display the link towards the page where you will be able to edit', 'DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 400, 13, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (513, 'Display the manufacturer', 'DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 400, 7, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (514, 'Display the tax', 'DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 400, 8, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (515, 'Activate or desactivate the commercial margin', 'ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want that the commercial margin be activate or not ?', 400, 14, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (753, 'End of Auction - Options', 'AUCTION_END_OPTIONS', '1', 'How do you want your auctions to end, select an option:
0 - Auction goes inactive
1 - Auction remains active but can''t be bid on', 1984, 1, '2006-11-13 19:26:24', '2006-11-11 13:23:56', NULL, 'tep_cfg_select_option(array(''0'', ''1''), '), (754, 'Price Tax setting', 'EP_PRICE_WITH_TAX', '1', '0 If you want the price without the tax included
1 if you want the price to be defined for import & export including tax.', 1985, 1, '2008-03-28 19:26:24', '2008-03-28 13:23:56', NULL, 'tep_cfg_select_option(array(''0'', ''1''),'), (755, 'Price Tax setting', 'EP_REPLACE_QUOTES', '1', 'If you have extensive html in your descriptions and it''s getting mangled on upload, turn this off
0 off
1 on.', 1985, 1, '2008-03-28 19:26:24', '2008-03-28 13:23:56', NULL, 'tep_cfg_select_option(array(''0'', ''1''),'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_configuration_group` -- CREATE TABLE `#__osc_configuration_group` ( `configuration_group_id` int(11) NOT NULL auto_increment, `configuration_group_title` varchar(64) NOT NULL, `configuration_group_description` varchar(245) NOT NULL, `sort_order` int(5) default NULL, `visible` int(1) default '1', `configuration_group_key` varchar(64) NOT NULL, PRIMARY KEY (`configuration_group_id`) ) AUTO_INCREMENT=6503 ; -- -- Dumping data for table `#__osc_configuration_group` -- INSERT INTO `#__osc_configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`, `configuration_group_key`) VALUES (1, 'My Store', 'General information about my store', 1, 1, 'CG_MY_SHOP'), (2, 'Minimum Values', 'The minimum values for functions / data', 2, 1, 'CG_MINIMAL_VALUES'), (3, 'Maximum Values', 'The maximum values for functions / data', 3, 1, 'CG_MAXIMAL_VALUES'), (4, 'Images', 'Image parameters', 4, 1, 'CG_PICTURES_PARAMETERS'), (5, 'Customer Details', 'Customer account configuration', 5, 1, 'CG_CUSTOMERS'), (6, 'Module Options', 'Hidden from configuration', 6, 0, 'CG_MODULES'), (7, 'Shipping/Packaging', 'Shipping options available at my store', 7, 1, 'CG_SHIPPING'), (8, 'Product Listing', 'Product Listing configuration options', 8, 1, 'CG_PRODUCTS'), (9, 'Stock', 'Stock configuration options', 9, 1, 'CG_WAREHOUSE'), (10, 'Logging / Cache', 'Logging / Cache configuration options', 10, 1, 'CG_LOGGING'), (1984, 'Auction Listing', 'All configuration settings for the auctions module should go here', 1984, 1, ''), (12, 'E-Mail Options', 'General setting for E-Mail transport and HTML E-Mails', 12, 1, 'CG_EMAIL'), (13, 'Download', 'Downloadable products options', 13, 1, 'CG_DOWNLOAD'), (15, 'Sessions', 'Session options', 15, 1, 'CG_SESSIONS'), (16, 'Family Products', 'The options for the Family Products v3.4', 16, 1, ''), (17, 'Tracking', 'Settings for tracking of frontend users', 17, 1, ''), (22, 'Points/Rewards', 'Points/Rewards System Configuration', 22, 1, ''), (25, 'Site Maintenance', 'Site Maintenance Options', 25, 1, ''), (50, 'Promo Prize Giveaways', 'Enter settings for promotional Prize Contests.', 50, 1, ''), (900, 'Affiliate Program', 'Options for the Affiliate Program', 50, 1, ''), (6501, 'Recover Cart Sales', 'Recover Cart Sales (RCS) Configuration Values', 15, 1, ''), (400, 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', 400, 1, ''), (1985, 'Excel Import', 'All configuration settings for the Excel import export should go here', 1985, 1, ''); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_contest` -- CREATE TABLE `#__osc_contest` ( `entry_id` int(11) NOT NULL auto_increment, `contestants_name` varchar(32) NOT NULL, `contestants_email` varchar(96) default NULL, `dob` datetime NOT NULL default '0000-00-00 00:00:00', `contestants_location` varchar(96) default NULL, `entry_rating` int(1) default NULL, `entry_status` int(1) default '1', `date_added` datetime default NULL, `last_modified` datetime default NULL, `entry_read` int(5) NOT NULL default '0', PRIMARY KEY (`entry_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_contest` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_counter` -- CREATE TABLE `#__osc_counter` ( `startdate` char(8) default NULL, `counter` int(12) default NULL ) ; -- -- Dumping data for table `#__osc_counter` -- INSERT INTO `#__osc_counter` (`startdate`, `counter`) VALUES ('20050319', 4788); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_counter_history` -- CREATE TABLE `#__osc_counter_history` ( `month` char(8) default NULL, `counter` int(12) default NULL ) ; -- -- Dumping data for table `#__osc_counter_history` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_countries` -- CREATE TABLE `#__osc_countries` ( `countries_id` int(11) NOT NULL auto_increment, `countries_name` varchar(64) NOT NULL, `countries_iso_code_2` char(2) NOT NULL, `countries_iso_code_3` char(3) NOT NULL, `address_format_id` int(11) NOT NULL default '0', PRIMARY KEY (`countries_id`), KEY `IDX_COUNTRIES_NAME` (`countries_name`) ) AUTO_INCREMENT=240 ; -- -- Dumping data for table `#__osc_countries` -- INSERT INTO `#__osc_countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES (1, 'Afghanistan', 'AF', 'AFG', 1), (2, 'Albania', 'AL', 'ALB', 1), (3, 'Algeria', 'DZ', 'DZA', 1), (4, 'American Samoa', 'AS', 'ASM', 1), (5, 'Andorra', 'AD', 'AND', 1), (6, 'Angola', 'AO', 'AGO', 1), (7, 'Anguilla', 'AI', 'AIA', 1), (8, 'Antarctica', 'AQ', 'ATA', 1), (9, 'Antigua and Barbuda', 'AG', 'ATG', 1), (10, 'Argentina', 'AR', 'ARG', 1), (11, 'Armenia', 'AM', 'ARM', 1), (12, 'Aruba', 'AW', 'ABW', 1), (13, 'Australia', 'AU', 'AUS', 1), (14, 'Austria', 'AT', 'AUT', 5), (15, 'Azerbaijan', 'AZ', 'AZE', 1), (16, 'Bahamas', 'BS', 'BHS', 1), (17, 'Bahrain', 'BH', 'BHR', 1), (18, 'Bangladesh', 'BD', 'BGD', 1), (19, 'Barbados', 'BB', 'BRB', 1), (20, 'Belarus', 'BY', 'BLR', 1), (21, 'Belgium', 'BE', 'BEL', 1), (22, 'Belize', 'BZ', 'BLZ', 1), (23, 'Benin', 'BJ', 'BEN', 1), (24, 'Bermuda', 'BM', 'BMU', 1), (25, 'Bhutan', 'BT', 'BTN', 1), (26, 'Bolivia', 'BO', 'BOL', 1), (27, 'Bosnia and Herzegowina', 'BA', 'BIH', 1), (28, 'Botswana', 'BW', 'BWA', 1), (29, 'Bouvet Island', 'BV', 'BVT', 1), (30, 'Brazil', 'BR', 'BRA', 1), (31, 'British Indian Ocean Territory', 'IO', 'IOT', 1), (32, 'Brunei Darussalam', 'BN', 'BRN', 1), (33, 'Bulgaria', 'BG', 'BGR', 1), (34, 'Burkina Faso', 'BF', 'BFA', 1), (35, 'Burundi', 'BI', 'BDI', 1), (36, 'Cambodia', 'KH', 'KHM', 1), (37, 'Cameroon', 'CM', 'CMR', 1), (38, 'Canada', 'CA', 'CAN', 1), (39, 'Cape Verde', 'CV', 'CPV', 1), (40, 'Cayman Islands', 'KY', 'CYM', 1), (41, 'Central African Republic', 'CF', 'CAF', 1), (42, 'Chad', 'TD', 'TCD', 1), (43, 'Chile', 'CL', 'CHL', 1), (44, 'China', 'CN', 'CHN', 1), (45, 'Christmas Island', 'CX', 'CXR', 1), (46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 1), (47, 'Colombia', 'CO', 'COL', 1), (48, 'Comoros', 'KM', 'COM', 1), (49, 'Congo', 'CG', 'COG', 1), (50, 'Cook Islands', 'CK', 'COK', 1), (51, 'Costa Rica', 'CR', 'CRI', 1), (52, 'Cote D`Ivoire', 'CI', 'CIV', 1), (53, 'Croatia', 'HR', 'HRV', 1), (54, 'Cuba', 'CU', 'CUB', 1), (55, 'Cyprus', 'CY', 'CYP', 1), (56, 'Czech Republic', 'CZ', 'CZE', 1), (57, 'Denmark', 'DK', 'DNK', 1), (58, 'Djibouti', 'DJ', 'DJI', 1), (59, 'Dominica', 'DM', 'DMA', 1), (60, 'Dominican Republic', 'DO', 'DOM', 1), (61, 'East Timor', 'TP', 'TMP', 1), (62, 'Ecuador', 'EC', 'ECU', 1), (63, 'Egypt', 'EG', 'EGY', 1), (64, 'El Salvador', 'SV', 'SLV', 1), (65, 'Equatorial Guinea', 'GQ', 'GNQ', 1), (66, 'Eritrea', 'ER', 'ERI', 1), (67, 'Estonia', 'EE', 'EST', 1), (68, 'Ethiopia', 'ET', 'ETH', 1), (69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1), (70, 'Faroe Islands', 'FO', 'FRO', 1), (71, 'Fiji', 'FJ', 'FJI', 1), (72, 'Finland', 'FI', 'FIN', 1), (73, 'France', 'FR', 'FRA', 1), (74, 'France, Metropolitan', 'FX', 'FXX', 1), (75, 'French Guiana', 'GF', 'GUF', 1), (76, 'French Polynesia', 'PF', 'PYF', 1), (77, 'French Southern Territories', 'TF', 'ATF', 1), (78, 'Gabon', 'GA', 'GAB', 1), (79, 'Gambia', 'GM', 'GMB', 1), (80, 'Georgia', 'GE', 'GEO', 1), (81, 'Germany', 'DE', 'DEU', 5), (82, 'Ghana', 'GH', 'GHA', 1), (83, 'Gibraltar', 'GI', 'GIB', 1), (84, 'Greece', 'GR', 'GRC', 1), (85, 'Greenland', 'GL', 'GRL', 1), (86, 'Grenada', 'GD', 'GRD', 1), (87, 'Guadeloupe', 'GP', 'GLP', 1), (88, 'Guam', 'GU', 'GUM', 1), (89, 'Guatemala', 'GT', 'GTM', 1), (90, 'Guinea', 'GN', 'GIN', 1), (91, 'Guinea-bissau', 'GW', 'GNB', 1), (92, 'Guyana', 'GY', 'GUY', 1), (93, 'Haiti', 'HT', 'HTI', 1), (94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 1), (95, 'Honduras', 'HN', 'HND', 1), (96, 'Hong Kong', 'HK', 'HKG', 1), (97, 'Hungary', 'HU', 'HUN', 1), (98, 'Iceland', 'IS', 'ISL', 1), (99, 'India', 'IN', 'IND', 1), (100, 'Indonesia', 'ID', 'IDN', 1), (101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1), (102, 'Iraq', 'IQ', 'IRQ', 1), (103, 'Ireland', 'IE', 'IRL', 1), (104, 'Israel', 'IL', 'ISR', 1), (105, 'Italy', 'IT', 'ITA', 1), (106, 'Jamaica', 'JM', 'JAM', 1), (107, 'Japan', 'JP', 'JPN', 1), (108, 'Jordan', 'JO', 'JOR', 1), (109, 'Kazakhstan', 'KZ', 'KAZ', 1), (110, 'Kenya', 'KE', 'KEN', 1), (111, 'Kiribati', 'KI', 'KIR', 1), (112, 'Korea, Democratic People`s Republic of', 'KP', 'PRK', 1), (113, 'Korea, Republic of', 'KR', 'KOR', 1), (114, 'Kuwait', 'KW', 'KWT', 1), (115, 'Kyrgyzstan', 'KG', 'KGZ', 1), (116, 'Lao People`s Democratic Republic', 'LA', 'LAO', 1), (117, 'Latvia', 'LV', 'LVA', 1), (118, 'Lebanon', 'LB', 'LBN', 1), (119, 'Lesotho', 'LS', 'LSO', 1), (120, 'Liberia', 'LR', 'LBR', 1), (121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 1), (122, 'Liechtenstein', 'LI', 'LIE', 1), (123, 'Lithuania', 'LT', 'LTU', 1), (124, 'Luxembourg', 'LU', 'LUX', 1), (125, 'Macau', 'MO', 'MAC', 1), (126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 1), (127, 'Madagascar', 'MG', 'MDG', 1), (128, 'Malawi', 'MW', 'MWI', 1), (129, 'Malaysia', 'MY', 'MYS', 1), (130, 'Maldives', 'MV', 'MDV', 1), (131, 'Mali', 'ML', 'MLI', 1), (132, 'Malta', 'MT', 'MLT', 1), (133, 'Marshall Islands', 'MH', 'MHL', 1), (134, 'Martinique', 'MQ', 'MTQ', 1), (135, 'Mauritania', 'MR', 'MRT', 1), (136, 'Mauritius', 'MU', 'MUS', 1), (137, 'Mayotte', 'YT', 'MYT', 1), (138, 'Mexico', 'MX', 'MEX', 1), (139, 'Micronesia, Federated States of', 'FM', 'FSM', 1), (140, 'Moldova, Republic of', 'MD', 'MDA', 1), (141, 'Monaco', 'MC', 'MCO', 1), (142, 'Mongolia', 'MN', 'MNG', 1), (143, 'Montserrat', 'MS', 'MSR', 1), (144, 'Morocco', 'MA', 'MAR', 1), (145, 'Mozambique', 'MZ', 'MOZ', 1), (146, 'Myanmar', 'MM', 'MMR', 1), (147, 'Namibia', 'NA', 'NAM', 1), (148, 'Nauru', 'NR', 'NRU', 1), (149, 'Nepal', 'NP', 'NPL', 1), (150, 'Netherlands', 'NL', 'NLD', 1), (151, 'Netherlands Antilles', 'AN', 'ANT', 1), (152, 'New Caledonia', 'NC', 'NCL', 1), (153, 'New Zealand', 'NZ', 'NZL', 1), (154, 'Nicaragua', 'NI', 'NIC', 1), (155, 'Niger', 'NE', 'NER', 1), (156, 'Nigeria', 'NG', 'NGA', 1), (157, 'Niue', 'NU', 'NIU', 1), (158, 'Norfolk Island', 'NF', 'NFK', 1), (159, 'Northern Mariana Islands', 'MP', 'MNP', 1), (160, 'Norway', 'NO', 'NOR', 1), (161, 'Oman', 'OM', 'OMN', 1), (162, 'Pakistan', 'PK', 'PAK', 1), (163, 'Palau', 'PW', 'PLW', 1), (164, 'Panama', 'PA', 'PAN', 1), (165, 'Papua New Guinea', 'PG', 'PNG', 1), (166, 'Paraguay', 'PY', 'PRY', 1), (167, 'Peru', 'PE', 'PER', 1), (168, 'Philippines', 'PH', 'PHL', 1), (169, 'Pitcairn', 'PN', 'PCN', 1), (170, 'Poland', 'PL', 'POL', 1), (171, 'Portugal', 'PT', 'PRT', 1), (172, 'Puerto Rico', 'PR', 'PRI', 1), (173, 'Qatar', 'QA', 'QAT', 1), (174, 'Reunion', 'RE', 'REU', 1), (175, 'Romania', 'RO', 'ROM', 1), (176, 'Russian Federation', 'RU', 'RUS', 1), (177, 'Rwanda', 'RW', 'RWA', 1), (178, 'Saint Kitts and Nevis', 'KN', 'KNA', 1), (179, 'Saint Lucia', 'LC', 'LCA', 1), (180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1), (181, 'Samoa', 'WS', 'WSM', 1), (182, 'San Marino', 'SM', 'SMR', 1), (183, 'Sao Tome and Principe', 'ST', 'STP', 1), (184, 'Saudi Arabia', 'SA', 'SAU', 1), (185, 'Senegal', 'SN', 'SEN', 1), (186, 'Seychelles', 'SC', 'SYC', 1), (187, 'Sierra Leone', 'SL', 'SLE', 1), (188, 'Singapore', 'SG', 'SGP', 4), (189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 1), (190, 'Slovenia', 'SI', 'SVN', 1), (191, 'Solomon Islands', 'SB', 'SLB', 1), (192, 'Somalia', 'SO', 'SOM', 1), (193, 'South Africa', 'ZA', 'ZAF', 1), (194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 1), (195, 'Spain', 'ES', 'ESP', 3), (196, 'Sri Lanka', 'LK', 'LKA', 1), (197, 'St. Helena', 'SH', 'SHN', 1), (198, 'St. Pierre and Miquelon', 'PM', 'SPM', 1), (199, 'Sudan', 'SD', 'SDN', 1), (200, 'Suriname', 'SR', 'SUR', 1), (201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1), (202, 'Swaziland', 'SZ', 'SWZ', 1), (203, 'Sweden', 'SE', 'SWE', 1), (204, 'Switzerland', 'CH', 'CHE', 1), (205, 'Syrian Arab Republic', 'SY', 'SYR', 1), (206, 'Taiwan', 'TW', 'TWN', 1), (207, 'Tajikistan', 'TJ', 'TJK', 1), (208, 'Tanzania, United Republic of', 'TZ', 'TZA', 1), (209, 'Thailand', 'TH', 'THA', 1), (210, 'Togo', 'TG', 'TGO', 1), (211, 'Tokelau', 'TK', 'TKL', 1), (212, 'Tonga', 'TO', 'TON', 1), (213, 'Trinidad and Tobago', 'TT', 'TTO', 1), (214, 'Tunisia', 'TN', 'TUN', 1), (215, 'Turkey', 'TR', 'TUR', 1), (216, 'Turkmenistan', 'TM', 'TKM', 1), (217, 'Turks and Caicos Islands', 'TC', 'TCA', 1), (218, 'Tuvalu', 'TV', 'TUV', 1), (219, 'Uganda', 'UG', 'UGA', 1), (220, 'Ukraine', 'UA', 'UKR', 1), (221, 'United Arab Emirates', 'AE', 'ARE', 1), (222, 'United Kingdom', 'GB', 'GBR', 1), (223, 'United States', 'US', 'USA', 2), (224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1), (225, 'Uruguay', 'UY', 'URY', 1), (226, 'Uzbekistan', 'UZ', 'UZB', 1), (227, 'Vanuatu', 'VU', 'VUT', 1), (228, 'Vatican City State (Holy See)', 'VA', 'VAT', 1), (229, 'Venezuela', 'VE', 'VEN', 1), (230, 'Viet Nam', 'VN', 'VNM', 1), (231, 'Virgin Islands (British)', 'VG', 'VGB', 1), (232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 1), (233, 'Wallis and Futuna Islands', 'WF', 'WLF', 1), (234, 'Western Sahara', 'EH', 'ESH', 1), (235, 'Yemen', 'YE', 'YEM', 1), (236, 'Yugoslavia', 'YU', 'YUG', 1), (237, 'Zaire', 'ZR', 'ZAR', 1), (238, 'Zambia', 'ZM', 'ZMB', 1), (239, 'Zimbabwe', 'ZW', 'ZWE', 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupons` -- CREATE TABLE `#__osc_coupons` ( `coupon_id` int(11) NOT NULL auto_increment, `coupon_type` char(1) NOT NULL default 'F', `coupon_code` varchar(32) NOT NULL, `coupon_amount` decimal(8,4) NOT NULL default '0.0000', `coupon_minimum_order` decimal(8,4) NOT NULL default '0.0000', `coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00', `coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00', `uses_per_coupon` int(5) NOT NULL default '1', `uses_per_user` int(5) NOT NULL default '0', `restrict_to_products` varchar(245) default NULL, `restrict_to_categories` varchar(245) default NULL, `restrict_to_customers` text, `coupon_active` char(1) NOT NULL default 'Y', `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`coupon_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_coupons` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupons_description` -- CREATE TABLE `#__osc_coupons_description` ( `coupon_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `coupon_name` varchar(32) NOT NULL, `coupon_description` text, KEY `coupon_id` (`coupon_id`) ) ; -- -- Dumping data for table `#__osc_coupons_description` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupon_email_track` -- CREATE TABLE `#__osc_coupon_email_track` ( `unique_id` int(11) NOT NULL auto_increment, `coupon_id` int(11) NOT NULL default '0', `customer_id_sent` int(11) NOT NULL default '0', `sent_firstname` varchar(32) default NULL, `sent_lastname` varchar(32) default NULL, `emailed_to` varchar(32) default NULL, `date_sent` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`unique_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_coupon_email_track` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupon_gv_customer` -- CREATE TABLE `#__osc_coupon_gv_customer` ( `customer_id` int(5) NOT NULL default '0', `amount` decimal(8,4) NOT NULL default '0.0000', PRIMARY KEY (`customer_id`), KEY `customer_id` (`customer_id`) ) ; -- -- Dumping data for table `#__osc_coupon_gv_customer` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupon_gv_queue` -- CREATE TABLE `#__osc_coupon_gv_queue` ( `unique_id` int(5) NOT NULL auto_increment, `customer_id` int(5) NOT NULL default '0', `order_id` int(5) NOT NULL default '0', `amount` decimal(8,4) NOT NULL default '0.0000', `date_created` datetime NOT NULL default '0000-00-00 00:00:00', `ipaddr` varchar(32) NOT NULL, `release_flag` char(1) NOT NULL default 'N', PRIMARY KEY (`unique_id`), KEY `uid` (`unique_id`,`customer_id`,`order_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_coupon_gv_queue` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_coupon_redeem_track` -- CREATE TABLE `#__osc_coupon_redeem_track` ( `unique_id` int(11) NOT NULL auto_increment, `coupon_id` int(11) NOT NULL default '0', `customer_id` int(11) NOT NULL default '0', `redeem_date` datetime NOT NULL default '0000-00-00 00:00:00', `redeem_ip` varchar(32) NOT NULL, `order_id` int(11) NOT NULL default '0', PRIMARY KEY (`unique_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_coupon_redeem_track` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_currencies` -- CREATE TABLE `#__osc_currencies` ( `currencies_id` int(11) NOT NULL auto_increment, `title` varchar(32) NOT NULL, `code` char(3) NOT NULL, `symbol_left` varchar(12) default NULL, `symbol_right` varchar(12) default NULL, `decimal_point` char(1) default NULL, `thousands_point` char(1) default NULL, `decimal_places` char(1) default NULL, `value` float(13,8) default NULL, `last_updated` datetime default NULL, PRIMARY KEY (`currencies_id`), KEY `idx_currencies_code` (`code`) ) AUTO_INCREMENT=4 ; -- -- Dumping data for table `#__osc_currencies` -- INSERT INTO `#__osc_currencies` (`currencies_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_point`, `thousands_point`, `decimal_places`, `value`, `last_updated`) VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', 1.00000000, '2005-03-19 02:32:41'), (2, 'Euro', 'EUR', '', 'EUR', '.', ',', '2', 1.10360003, '2005-03-19 02:32:41'), (3, 'South African Rand', 'ZAR', 'R', '', '.', ',', '2', 1.00000000, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers` -- CREATE TABLE `#__osc_customers` ( `customers_id` int(11) NOT NULL auto_increment, `customers_gender` char(1) NOT NULL, `customers_firstname` varchar(32) NOT NULL, `customers_lastname` varchar(32) NOT NULL, `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00', `customers_email_address` varchar(96) NOT NULL, `customers_default_address_id` int(11) NOT NULL default '0', `customers_telephone` varchar(32) NOT NULL, `customers_fax` varchar(32) default NULL, `customers_password` varchar(100) NOT NULL, `customers_ap` int(11) default NULL, `customers_newsletter` char(1) default NULL, `customers_shopping_points` decimal(15,2) NOT NULL default '0.00', `customers_points_expires` date default NULL, `customers_group_id` smallint(5) unsigned NOT NULL default '0', `customers_group_ra` enum('0','1') NOT NULL, `customers_payment_allowed` varchar(245) NOT NULL, `customers_shipment_allowed` varchar(245) NOT NULL, PRIMARY KEY (`customers_id`), KEY `idx_customers_email_address` (`customers_email_address`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customers` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_basket` -- CREATE TABLE `#__osc_customers_basket` ( `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` int(2) NOT NULL default '0', `final_price` decimal(15,4) NOT NULL default '0.0000', `customers_basket_date_added` varchar(8) default NULL, `auction_product` int(1) NOT NULL default '1', PRIMARY KEY (`customers_basket_id`), KEY `idx_customers_basket_customers_id` (`customers_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customers_basket` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_basket_attributes` -- CREATE TABLE `#__osc_customers_basket_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` int(11) NOT NULL default '0', `products_options_value_id` int(11) NOT NULL default '0', `products_options_value_text` text, PRIMARY KEY (`customers_basket_attributes_id`), KEY `idx_customers_basket_att_customers_id` (`customers_id`) ) AUTO_INCREMENT=7 ; -- -- Dumping data for table `#__osc_customers_basket_attributes` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_basket_wishlist` -- CREATE TABLE `#__osc_customers_basket_wishlist` ( `customers_basket_id` int(5) NOT NULL auto_increment, `customers_id` int(5) NOT NULL default '0', `products_id` int(5) NOT NULL default '0', `customers_basket_quantity` int(2) 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 `customers_id` (`customers_id`), KEY `products_id` (`products_id`), KEY `customers_basket_quantity` (`customers_basket_quantity`), KEY `final_price` (`final_price`), KEY `customers_basket_date_added` (`customers_basket_date_added`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customers_basket_wishlist` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_basket_wishlist_attributes` -- CREATE TABLE `#__osc_customers_basket_wishlist_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` int(11) NOT NULL default '0', `products_options_value_id` int(11) NOT NULL default '0', `products_options_value_text` text, PRIMARY KEY (`customers_basket_attributes_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customers_basket_wishlist_attributes` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_groups` -- CREATE TABLE `#__osc_customers_groups` ( `customers_group_id` smallint(5) unsigned NOT NULL, `customers_group_name` varchar(32) NOT NULL, `customers_group_show_tax` enum('1','0') NOT NULL, `customers_group_tax_exempt` enum('0','1') NOT NULL, `group_payment_allowed` varchar(245) NOT NULL, `group_shipment_allowed` varchar(245) NOT NULL, PRIMARY KEY (`customers_group_id`) ) ; -- -- Dumping data for table `#__osc_customers_groups` -- INSERT INTO `#__osc_customers_groups` (`customers_group_id`, `customers_group_name`, `customers_group_show_tax`, `customers_group_tax_exempt`, `group_payment_allowed`, `group_shipment_allowed`) VALUES (0, 'Retail', '1', '0', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_info` -- CREATE TABLE `#__osc_customers_info` ( `customers_info_id` int(11) NOT NULL default '0', `customers_info_date_of_last_logon` datetime default NULL, `customers_info_number_of_logons` int(5) default NULL, `customers_info_date_account_created` datetime default NULL, `customers_info_date_account_last_modified` datetime default NULL, `global_product_notifications` int(1) default '0', PRIMARY KEY (`customers_info_id`) ) ; -- -- Dumping data for table `#__osc_customers_info` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_points_pending` -- CREATE TABLE `#__osc_customers_points_pending` ( `unique_id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `orders_id` int(11) NOT NULL default '0', `points_pending` decimal(15,2) NOT NULL default '0.00', `points_comment` varchar(200) default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `points_status` int(1) default '1', `points_type` char(2) NOT NULL default 'SP', PRIMARY KEY (`unique_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customers_points_pending` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customers_to_extra_fields` -- CREATE TABLE `#__osc_customers_to_extra_fields` ( `customers_id` int(11) NOT NULL default '0', `fields_id` int(11) NOT NULL default '0', `value` text ) ; -- -- Dumping data for table `#__osc_customers_to_extra_fields` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_customer_testimonials` -- CREATE TABLE `#__osc_customer_testimonials` ( `testimonials_title` varchar(64) NOT NULL, `testimonials_id` int(5) NOT NULL auto_increment, `testimonials_html_text` longtext NOT NULL, `testimonials_name` varchar(50) NOT NULL, `testimonials_url` varchar(150) NOT NULL, `testimonials_url_title` varchar(150) NOT NULL, `date_added` varchar(50) NOT NULL, `status` tinyint(1) NOT NULL default '1', PRIMARY KEY (`testimonials_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_customer_testimonials` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_domains` -- CREATE TABLE `#__osc_domains` ( `domid` int(5) NOT NULL auto_increment, `domain` char(64) NOT NULL, `avail` int(1) NOT NULL default '0', `date` date default '0000-00-00', PRIMARY KEY (`domid`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_domains` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_domain_price` -- CREATE TABLE `#__osc_domain_price` ( `tld_id` int(3) NOT NULL auto_increment, `tld` char(10) NOT NULL, `price` decimal(15,2) NOT NULL default '0.00', PRIMARY KEY (`tld_id`) ) AUTO_INCREMENT=19 ; -- -- Dumping data for table `#__osc_domain_price` -- INSERT INTO `#__osc_domain_price` (`tld_id`, `tld`, `price`) VALUES (1, '.co.uk', '4.99'), (2, '.org.uk', '4.99'), (3, '.com', '12.99'), (4, '.net', '12.99'), (5, '.org', '12.99'), (6, '.name', '12.99'), (7, '.info', '15.99'), (8, '.biz', '25.99'), (9, '.tv', '38.99'), (10, '.cc', '38.99'), (11, '.eu.com', '12.99'), (12, '.uk.com', '12.99'), (13, '.gb.com', '12.99'), (14, '.gb.net', '12.99'), (15, '.uk.net', '12.99'), (16, '.me.uk', '4.99'), (18, '.co.za', '25.99'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_enter_contest_description` -- CREATE TABLE `#__osc_enter_contest_description` ( `entry_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `entry_text` text NOT NULL, PRIMARY KEY (`entry_id`,`languages_id`) ) ; -- -- Dumping data for table `#__osc_enter_contest_description` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_epdq_session` -- CREATE TABLE `#__osc_epdq_session` ( `oid` int(11) default NULL, `session` text ) ; -- -- Dumping data for table `#__osc_epdq_session` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_epdq_transactions` -- CREATE TABLE `#__osc_epdq_transactions` ( `oid` varchar(30) NOT NULL, `transaction_status` varchar(30) default NULL, `transaction_time` datetime default NULL, PRIMARY KEY (`oid`) ) ; -- -- Dumping data for table `#__osc_epdq_transactions` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_epdq_txnlog` -- CREATE TABLE `#__osc_epdq_txnlog` ( `oid` varchar(30) NOT NULL, `txn_status` varchar(30) default NULL, `txn_time` datetime default NULL ) ; -- -- Dumping data for table `#__osc_epdq_txnlog` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_extra_fields` -- CREATE TABLE `#__osc_extra_fields` ( `fields_id` int(11) NOT NULL auto_increment, `fields_input_type` int(11) NOT NULL default '0', `fields_input_value` text NOT NULL, `fields_status` tinyint(2) NOT NULL default '0', `fields_required_status` tinyint(2) NOT NULL default '0', `fields_size` int(5) NOT NULL default '0', `fields_required_email` tinyint(2) NOT NULL default '0', PRIMARY KEY (`fields_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_extra_fields` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_extra_fields_info` -- CREATE TABLE `#__osc_extra_fields_info` ( `fields_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `fields_name` varchar(32) NOT NULL default '' ) ; -- -- Dumping data for table `#__osc_extra_fields_info` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_families` -- CREATE TABLE `#__osc_families` ( `family_id` smallint(3) NOT NULL auto_increment, `family_name` varchar(20) NOT NULL, PRIMARY KEY (`family_id`) ) AUTO_INCREMENT=2 ; -- -- Dumping data for table `#__osc_families` -- INSERT INTO `#__osc_families` (`family_id`, `family_name`) VALUES (1, 'Games'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_geo_zones` -- CREATE TABLE `#__osc_geo_zones` ( `geo_zone_id` int(11) NOT NULL auto_increment, `geo_zone_name` varchar(32) NOT NULL, `geo_zone_description` varchar(245) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`geo_zone_id`) ) AUTO_INCREMENT=2 ; -- -- Dumping data for table `#__osc_geo_zones` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_languages` -- CREATE TABLE `#__osc_languages` ( `languages_id` int(11) NOT NULL auto_increment, `name` varchar(32) NOT NULL, `code` char(2) NOT NULL, `image` varchar(64) default NULL, `directory` varchar(32) default NULL, `sort_order` int(3) default NULL, PRIMARY KEY (`languages_id`), KEY `IDX_LANGUAGES_NAME` (`name`) ) AUTO_INCREMENT=2 ; -- -- Dumping data for table `#__osc_languages` -- INSERT INTO `#__osc_languages` (`languages_id`, `name`, `code`, `image`, `directory`, `sort_order`) VALUES (1, 'English', 'en', 'icon.gif', 'english', 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_manufacturers` -- CREATE TABLE `#__osc_manufacturers` ( `manufacturers_id` int(11) NOT NULL auto_increment, `manufacturers_name` varchar(32) NOT NULL, `manufacturers_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`manufacturers_id`), KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`) ) AUTO_INCREMENT=3 ; -- -- Dumping data for table `#__osc_manufacturers` -- INSERT INTO `#__osc_manufacturers` (`manufacturers_id`, `manufacturers_name`, `manufacturers_image`, `date_added`, `last_modified`) VALUES (1, 'IBM', 'ibm logo.jpg', '2008-03-28 20:47:44', NULL), (2, 'HP', 'hplogo.jpg', '2008-03-28 20:48:03', NULL); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_manufacturers_info` -- CREATE TABLE `#__osc_manufacturers_info` ( `manufacturers_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `manufacturers_url` varchar(245) NOT NULL, `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`manufacturers_id`,`languages_id`) ) ; -- -- Dumping data for table `#__osc_manufacturers_info` -- INSERT INTO `#__osc_manufacturers_info` (`manufacturers_id`, `languages_id`, `manufacturers_url`, `url_clicked`, `date_last_click`) VALUES (1, 1, 'http://www.ibm.com', 0, NULL), (2, 1, 'http://www.hp.com', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_newsletters` -- CREATE TABLE `#__osc_newsletters` ( `newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(245) NOT NULL, `content` text NOT NULL, `module` varchar(245) NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', PRIMARY KEY (`newsletters_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_newsletters` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders` -- CREATE TABLE `#__osc_orders` ( `orders_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `customers_name` varchar(64) NOT NULL, `customers_company` varchar(32) default NULL, `customers_street_address` varchar(64) NOT NULL, `customers_suburb` varchar(32) default NULL, `customers_city` varchar(32) NOT NULL, `customers_postcode` varchar(10) NOT NULL, `customers_state` varchar(32) default NULL, `customers_country` varchar(32) NOT NULL, `customers_telephone` varchar(32) NOT NULL, `customers_email_address` varchar(96) NOT NULL, `customers_address_format_id` int(5) NOT NULL default '0', `delivery_name` varchar(64) NOT NULL, `delivery_company` varchar(32) default NULL, `delivery_street_address` varchar(64) NOT NULL, `delivery_suburb` varchar(32) default NULL, `delivery_city` varchar(32) NOT NULL, `delivery_postcode` varchar(10) NOT NULL, `delivery_state` varchar(32) default NULL, `delivery_country` varchar(32) NOT NULL, `delivery_address_format_id` int(5) NOT NULL default '0', `billing_name` varchar(64) NOT NULL, `billing_company` varchar(32) default NULL, `billing_street_address` varchar(64) NOT NULL, `billing_suburb` varchar(32) default NULL, `billing_city` varchar(32) NOT NULL, `billing_postcode` varchar(10) NOT NULL, `billing_state` varchar(32) default NULL, `billing_country` varchar(32) NOT NULL, `billing_address_format_id` int(5) NOT NULL default '0', `payment_method` varchar(255) NOT NULL, `cc_type` varchar(20) default NULL, `cc_owner` varchar(64) default NULL, `cc_number` varchar(32) default NULL, `cc_expires` varchar(4) default NULL, `last_modified` datetime default NULL, `date_purchased` datetime default NULL, `orders_status` int(5) NOT NULL default '0', `orders_date_finished` datetime default NULL, `currency` char(3) default NULL, `currency_value` decimal(14,6) default NULL, PRIMARY KEY (`orders_id`), KEY `idx_orders_customers_id` (`customers_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders` -- ALTER TABLE `#__osc_orders` ADD `ip_address` VARCHAR(50) NOT NULL; -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_products` -- CREATE TABLE `#__osc_orders_products` ( `orders_products_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_name` varchar(64) NOT NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `final_price` decimal(15,4) NOT NULL default '0.0000', `products_tax` decimal(7,4) NOT NULL default '0.0000', `products_quantity` int(2) NOT NULL default '0', `vendors_id` int(11) NOT NULL default '1', PRIMARY KEY (`orders_products_id`), KEY `idx_orders_products_orders_id` (`orders_id`), KEY `idx_orders_products_products_id` (`products_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_products` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_products_attributes` -- CREATE TABLE `#__osc_orders_products_attributes` ( `orders_products_attributes_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `products_options` varchar(32) NOT NULL, `products_options_values` varchar(32) NOT NULL, `options_values_price` decimal(15,4) NOT NULL default '0.0000', `price_prefix` char(1) NOT NULL, PRIMARY KEY (`orders_products_attributes_id`), KEY `idx_orders_products_att_orders_id` (`orders_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_products_attributes` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_products_download` -- CREATE TABLE `#__osc_orders_products_download` ( `orders_products_download_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `orders_products_filename` varchar(245) NOT NULL, `download_maxdays` int(2) NOT NULL default '0', `download_count` int(2) NOT NULL default '0', `archived` char(3) NOT NULL default 'no', PRIMARY KEY (`orders_products_download_id`), KEY `idx_orders_products_download_orders_id` (`orders_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_products_download` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_shipping` -- CREATE TABLE `#__osc_orders_shipping` ( `orders_shipping_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `vendors_id` int(11) NOT NULL default '1', `shipping_module` varchar(16) NOT NULL, `shipping_method` varchar(128) NOT NULL, `shipping_cost` decimal(15,4) NOT NULL default '0.0000', `shipping_tax` decimal(15,4) NOT NULL default '0.0000', `vendors_name` varchar(64) NOT NULL, `vendor_order_sent` varchar(3) NOT NULL default 'no', PRIMARY KEY (`orders_shipping_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_shipping` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_status` -- CREATE TABLE `#__osc_orders_status` ( `orders_status_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `orders_status_name` varchar(32) NOT NULL, `public_flag` int(11) default '1', `downloads_flag` int(11) default '0', PRIMARY KEY (`orders_status_id`,`language_id`), KEY `idx_orders_status_name` (`orders_status_name`) ) ; -- -- Dumping data for table `#__osc_orders_status` -- INSERT INTO `#__osc_orders_status` (`orders_status_id`, `language_id`, `orders_status_name`, `public_flag`, `downloads_flag`) VALUES (3, 1, 'Delivered', 1, 0), (1, 1, 'Pending', 1, 0), (2, 1, 'Processing', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_status_history` -- CREATE TABLE `#__osc_orders_status_history` ( `orders_status_history_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_status_id` int(5) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `customer_notified` int(1) default '0', `comments` text, PRIMARY KEY (`orders_status_history_id`), KEY `idx_orders_status_history_orders_id` (`orders_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_status_history` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_orders_total` -- CREATE TABLE `#__osc_orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `title` varchar(245) NOT NULL, `text` varchar(245) NOT NULL, `value` decimal(15,4) NOT NULL default '0.0000', `class` varchar(32) NOT NULL, `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_orders_total` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_prizes` -- CREATE TABLE `#__osc_prizes` ( `prizes_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `prizes_value` decimal(15,4) NOT NULL default '0.0000', `prizes_date_added` datetime default NULL, `last_modified` datetime default NULL, `expires_date` datetime default NULL, `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', PRIMARY KEY (`prizes_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_prizes` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products` -- CREATE TABLE `#__osc_products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `Featured_product` int(4) NOT NULL default '0', `products_image` varchar(64) default NULL, `products_fileupload` varchar(64) default NULL, `products_vidupload` varchar(255) default NULL, `products_mp3` varchar(255) default NULL, `products_pdfupload` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `customer_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', `products_length` int(11) default NULL, `products_width` int(11) default NULL, `products_depth` int(11) default NULL, `vendors_id` int(11) default '1', `vendors_product_price` decimal(15,4) NOT NULL default '0.0000', `vendors_prod_id` varchar(24) NOT NULL, `vendors_prod_comments` text, `products_hide_from_groups` varchar(245) NOT NULL default '@', `supplier_id` tinyint(4) NOT NULL default '0', `suppliers_id` int(11) NOT NULL default '0', `cost_price` int(11) NOT NULL default '0', `products_price_myself` decimal(15,4) NOT NULL default '0.0000', `affiliate_allow_product` tinyint(1) NOT NULL default '1', `products_price1` decimal(15,4) NOT NULL default '0.0000', `products_price2` decimal(15,4) NOT NULL default '0.0000', `products_price3` decimal(15,4) NOT NULL default '0.0000', `products_price4` decimal(15,4) NOT NULL default '0.0000', `products_price5` decimal(15,4) NOT NULL default '0.0000', `products_price6` decimal(15,4) NOT NULL default '0.0000', `products_price7` decimal(15,4) NOT NULL default '0.0000', `products_price8` decimal(15,4) NOT NULL default '0.0000', `products_price1_qty` int(11) NOT NULL default '0', `products_price2_qty` int(11) NOT NULL default '0', `products_price3_qty` int(11) NOT NULL default '0', `products_price4_qty` int(11) NOT NULL default '0', `products_price5_qty` int(11) NOT NULL default '0', `products_price6_qty` int(11) NOT NULL default '0', `products_price7_qty` int(11) NOT NULL default '0', `products_price8_qty` int(11) NOT NULL default '0', `products_qty_blocks` int(11) NOT NULL default '1', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`), KEY `idx_products_model` (`products_model`) ) AUTO_INCREMENT=16 ; -- -- Dumping data for table `#__osc_products` -- INSERT INTO `#__osc_products` (`products_id`, `products_quantity`, `products_model`, `Featured_product`, `products_image`, `products_fileupload`, `products_vidupload`, `products_mp3`, `products_pdfupload`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `customer_id`, `products_ordered`, `products_length`, `products_width`, `products_depth`, `vendors_id`, `vendors_product_price`, `vendors_prod_id`, `vendors_prod_comments`, `products_hide_from_groups`, `supplier_id`, `suppliers_id`, `cost_price`, `products_price_myself`, `affiliate_allow_product`, `products_price1`, `products_price2`, `products_price3`, `products_price4`, `products_price5`, `products_price6`, `products_price7`, `products_price8`, `products_price1_qty`, `products_price2_qty`, `products_price3_qty`, `products_price4_qty`, `products_price5_qty`, `products_price6_qty`, `products_price7_qty`, `products_price8_qty`, `products_qty_blocks`) VALUES (1, 1000, 'HPT42P', 0, 'ibm-tp-t42p-350x300.gif', NULL, NULL, NULL, NULL, '10000.0000', '2008-03-28 20:56:34', '2008-03-28 21:05:15', NULL, '2.40', 1, 0, 2, NULL, 0, 300, 250, 30, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '9750.0000', '9500.0000', '9250.0000', '9000.0000', '0.0000', '0.0000', '0.0000', '0.0000', 10, 25, 50, 100, 0, 0, 0, 0, 1), (2, 25, 'PSCOM01', 0, 'ps3.jpg', NULL, NULL, NULL, NULL, '5000.0000', '2008-03-28 21:22:18', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (3, 60, 'ECJC0002', 0, 'WWL07706081.jpg', NULL, NULL, NULL, NULL, '300.0000', '2008-03-28 22:43:56', '2008-03-28 23:02:44', NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (4, 100, 'ECJC0003', 0, 'MXJ07705984.jpg', NULL, NULL, NULL, NULL, '295.0000', '2008-03-28 22:45:21', '2008-03-28 23:01:42', NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (5, 99, 'ECJC0004', 0, '6003805082640.jpg', NULL, NULL, NULL, NULL, '297.0000', '2008-03-28 23:05:04', '2008-03-28 23:06:53', '2009-03-17 00:00:00', '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (6, 100, 'ECJC0005', 0, '3307210263599.jpg', NULL, NULL, NULL, NULL, '325.0000', '2008-03-28 23:09:00', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (7, 120, 'ECJC0006', 0, '5030930059361.jpg', NULL, NULL, NULL, NULL, '595.0000', '2008-03-28 23:16:43', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (8, 300, 'ECJC0007', 1, 'thawk.jpg', NULL, NULL, NULL, NULL, '515.0000', '2008-03-28 23:18:57', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (9, 0, '', 0, 'sinstar.jpg', NULL, NULL, NULL, NULL, '778.9800', '2008-03-28 23:20:19', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (10, 0, 'ECJC0008', 1, 'burn.jpg', NULL, NULL, NULL, NULL, '575.9500', '2008-03-28 23:21:56', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (11, 20, 'ECJC0009', 0, 'lost.jpg', NULL, NULL, NULL, NULL, '465.9000', '2008-03-28 23:23:27', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (12, 5, 'ECJC0010', 0, 'BRIT-0818SA.jpg', NULL, NULL, NULL, NULL, '999.0000', '2008-03-28 23:28:25', '2008-03-28 23:31:35', NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (13, 100, 'ECJC0011', 1, '0923.jpg', NULL, NULL, NULL, NULL, '399.9500', '2008-03-28 23:32:50', '2008-03-28 23:33:33', NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (14, 0, 'ECJC0012', 0, 'AlbumArt_Large.jpg', NULL, NULL, '002001sample.mp3', NULL, '199.0000', '2008-03-28 23:49:00', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1), (15, 111, 'ECJC0013', 0, '1085778365_01.jpg', NULL, 'TheAnnoyingThing.flv', NULL, NULL, '10.0000', '2008-03-29 00:08:35', NULL, NULL, '0.00', 1, 0, 0, NULL, 0, 0, 0, 0, 1, '0.0000', '', '', '@', 1, 0, 1, '0.0000', 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', 0, 0, 0, 0, 0, 0, 0, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_attributes` -- CREATE TABLE `#__osc_products_attributes` ( `products_attributes_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `options_id` int(11) NOT NULL default '0', `options_values_id` int(11) NOT NULL default '0', `options_values_price` decimal(15,4) NOT NULL default '0.0000', `price_prefix` char(1) NOT NULL, PRIMARY KEY (`products_attributes_id`), KEY `idx_products_attributes_products_id` (`products_id`) ) AUTO_INCREMENT=3 ; -- -- Dumping data for table `#__osc_products_attributes` -- INSERT INTO `#__osc_products_attributes` (`products_attributes_id`, `products_id`, `options_id`, `options_values_id`, `options_values_price`, `price_prefix`) VALUES (1, 12, 1, 2, '15.0000', '+'), (2, 12, 1, 1, '0.0000', '+'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_attributes_download` -- CREATE TABLE `#__osc_products_attributes_download` ( `products_attributes_id` int(11) NOT NULL default '0', `products_attributes_filename` varchar(245) NOT NULL, `products_attributes_maxdays` int(2) default '0', `products_attributes_maxcount` int(2) default '0', PRIMARY KEY (`products_attributes_id`) ) ; -- -- Dumping data for table `#__osc_products_attributes_download` -- INSERT INTO `#__osc_products_attributes_download` (`products_attributes_id`, `products_attributes_filename`, `products_attributes_maxdays`, `products_attributes_maxcount`) VALUES (2, 'game.zip', 7, 5); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_description` -- CREATE TABLE `#__osc_products_description` ( `products_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '1', `products_name` varchar(64) NOT NULL, `products_description` text, `products_url` varchar(245) default NULL, `products_viewed` int(5) default '0', PRIMARY KEY (`products_id`,`language_id`), KEY `products_name` (`products_name`) ) AUTO_INCREMENT=16 ; -- -- Dumping data for table `#__osc_products_description` -- INSERT INTO `#__osc_products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`) VALUES (1, 1, 'HP Thinkpad T42p', '

IBM's new ThinkPad T42 series comprises the mainstream T42 and the workstation-class T42p. As well as featuring the new Pentium M Processor 735 (1.7GHz), 745 (1.8GHz) and 755 (2GHz), plus a range of wireless connectivity options, the T42 series will be the first ThinkPads to offer a 15in. display. Another first for the range is a 9.5mm multi-format DVD burner, the snappily named ThinkPad Multi-Burner UltraBay Slim Drive.

The 2.4kg (15in. screen) or 2.1 kg (14in. screen) T42 comes with either a Dothan processor featuring 2MB of Level 2 cache or the older 1MB-cache Pentium M running at 1.5GHz. Graphics are handled by ATI's Radeon M10 (with up to 64MB of video RAM) or M7 (with up to 32MB) chipsets, while hard disk sizes top out at 80GB (5,400rpm).

Wireless networking options for the T42 include single-band 802.11b or b/g, dual-band a/b/g or "wireless ready" (i.e. no wireless module fitted). IBM uses two antennae fitted in the screen bezel to provide isolation from electromagnetic interference. Gigabit wired Ethernet is standard on all models, as is infrared (not a given these days), while Bluetooth is offered on selected models.

IBM's ThinkPads generally deliver good battery life, and the company's claims for the T42 are impressive: 5.5 hours with a 6-cell battery, 7.2 hours with a 9-cell extended battery and 9.5 hours ("all day computing") with the extended battery plus a second battery in the UltraBay.

', 'http://reviews.zdnet.co.uk/hardware/notebooks/0,1000000333,39154222,00.htm', 3), (2, 1, 'PS3 Combo', '
You get this awsome deal:
PS3 40 GB console
2 x SixAxis controllers
Games included
Uncharted: Drake's Fortune
Ratchet and Clank: Tools of Destruction
', '', 0), (3, 1, 'Command & Conquer: Kane''s Wrath', 'The single player campaign will allow players to experience a new story that spans 20 years from the rebirth of the Brotherhood of Nod after the Second Tiberium War through the dramatic events of the Third Tiberium War and beyond.', '', 5), (4, 1, 'The Sims 2: Free Time', 'Now your Sims can rediscover the joys of leisure time! Awaken your Sims' true passions in life as they discover and excel at all-new activities. Whether they're tossing a football with the family, practicing ballet, restoring cars with friends, or building train sets, your Sims now have more ways to build skills, enhance friendships, and make their lives more successful. Craft new, unique items for your Sims to use in their daily lives including clothing, pottery, and more. Your Sims will even unlock secret rewards by mastering their hobbies and advancing all-new careers. Explore a wide variety of new hobbies that will change your Sims' lives!', '', 6), (5, 1, 'Conflict: Denied Ops', 'Conflict: Denied Ops features two agents from the CIA's Special Activities Division (SAD). Their mission: to prevent a third-world dictatorship from gaining nuclear weapons; a mission which will take them across three continents and pit them against the ambitious, powerful and dangerous men who control the nuclear arms smuggling trade.

With the ability to play as either agent, you can switch between two very different characters, manoeuvre them rapidly into position and take full advantage of their individual skills and weapons. This is the essence of the game: each agent working with and protecting the other to create the perfect Denied Ops team.

Conflict: Denied Ops Minimum PC System Requirements:

 

  • Microsoft Windows 2000/ Microsoft Windows XP/ Microsoft Windows Vista
  • Processor: Pentium 4 2GHz or Athlon XP equivalent
  • RAM: 1024MB system Memory
  • Video Card: 128mb Direct X 9.0c card with full Shader 3.0 support
  • Sound Card: Direct X 9.0c compatible sound card
  • DVD-ROM: DVD-ROM drive
  • Hard Drive Space: 7 GB Free Space

    Special Features
    • Explore a great variety of real-world locations as you fight in 10 hotspots around the world.
    • Use your AI partner as an extension of your own weaponry and to provide cover as you chase your target.
    • Swap between your two main characters at any point in time with the touch of a button.
    • Team up with a friend and experience the co-op single player campaign online or split screen.
    • Call-in air strikes, take control or armed vehicles and upgrade your weapons for increased firepower.
    • Take cover as your surroundings are blown to pieces in real time thanks to the unique Puncture Technology.
    • Experience realistic and massively destructible environments where carnage is permanent.
    • ', '', 3), (6, 1, 'Assassin''s Creed', 'Assassin’s Creed is the next-gen game developed by Ubisoft Montreal that will redefine the action genre. While other games claim to be next-gen with impressive graphics and physics, Assassin’s Creed merges technology, game design, theme, and emotions into a world where you instigate chaos and become a vulnerable, yet powerful, agent of change.

    The setting is 1191 AD. The Third Crusade is tearing the Holy Land apart. You, Altair, intend to stop the hostilities by suppressing both sides of the conflict. You are an Assassin, a warrior shrouded in secrecy and feared for your ruthlessness. Your actions can throw your immediate environment into chaos, and your existence will shape events during this pivotal moment in history.

    Minimum System Requirements

     

  • Supported OS: Windows XP / Vista (only)
  • Processor: Dual core processor 2.6 GHz Intel Pentium D or AMD Athlon 64 X2 3800+ (Intel Core 2 Duo 2.2 GHz or AMD Athlon 64 X2 4400+ or better recommended)
  • RAM: 2 GB (3 GB recommended)
  • Video Card: 256 MB DirectX 10.0–compliant video card or DirectX 9.0–compliant card with Shader Model 3.0 or higher (512 MB video card recommended) (see supported list)*
  • Sound Card: DirectX 9.0 or 10.0 compliant sound card (5.1 sound card recommended)
  • DirectX Version: DirectX 10.0 libraries (included on disc)
  • DVD-ROM: DVD-ROM dual-layer drive
  • Hard Drive Space: 12 GB

    Features
    • Be an Assassin: Master the skills, tactics, and weapons of history’s deadliest and most secretive clan of warriors. Plan your attacks, strike without mercy, and fight your way to escape.
    • Realistic and responsive environments: Crowds react to your moves and will either help or hinder you on your quests.
    • Action with a new dimension - total freedom: Eliminate your targets wherever, whenever, and however. Stalk your prey through richly detailed, historically accurate, open-ended environments. Scale buildings, mount horses, blend in with crowds. Do whatever it takes to achieve your objectives.
    • Relive the epic times of the Crusades: Assassin’s Creed immerses you in the realistic and historical Holy Land of the 12th century, featuring life-like graphics, ambience, and the subtle, yet detailed nuances of a living world.
    • Intense action rooted in reality: Experience heavy action blended with fluid and precise animations. Use a wide range of medieval weapons, and face your enemies in realistic swordfight duels.
    • Next-gen gameplay: The proprietary engine developed from the ground up for the next-gen console allows organic game design featuring open gameplay, intuitive control scheme, realistic interaction with environment, and a fluid, yet sharp, combat mechanic.
    • ', '', 2), (7, 1, 'Need for Speed Pro Street', 'Need For Speed: ProStreet boasts impeccable precision and impressively detailed photo-real graphics, effectively transporting you to the center of the action. It pushes the "Autosculpt" technology to a new level, allowing you to directly impact your car's performance for the first time as well as personalise its appearance.

    Need For Speed: ProStreet is a true taste of raw adrenaline and racing with consequences. Every dent, every scratch and every crumpled body panel is a battle scar, proof of your commitment and competitive mettle. With an aggressive and skilled AI system, you become immersed in an unmatched believable race experience. Add in a revolutionary online mode that will redefine the meaning of competitive social play, and Need For Speed: ProStreet is the ultimate formula for an emotionally charged street racing showdown.

    Features:

  • From the Show to the Go: At the forefront of the shift in car culture to performance racing.
  • Real Street Racing Locations: 7 licensed tracks, 5 real world inspired street racing locations, 90+ track variations in total.
  • Performance Customisation: Visual customisation affects performance. Includes unique cross platform online offering.
  • Realistic Racing: Damage with consequences, believable physics and smoke.
    • ', '', 2), (8, 1, 'Tony Hawk Proving Ground', 'Each skater has his story - create yours! Tony Hawk's Proving Ground lets you explore the different pathways to skateboarding stardom. Choose your character, take on challenges, develop your specific skill-set and reap the rewards to earn respect. Show off you skills and rewards through features like instand online gameplay and your own customisable "room."', '', 1), (9, 1, 'SingStar Next Generation', 'Whether you're a reluctant star or a born entertainer, SingStar is guaranteed to get any party going. And with loads of online features, including an ever-expanding library of the hottest songs, there's really no excuse not to join in.

    Key features:Blu-Ray launch disc - Packed with 30 original recordings - complete with HD videos from some of the hottest names in music, including Scissor Sisters, U2, Britney Spears, Gorillaz, Gwen Stefani, Razorlight and more.

    Download new songs via the SingStore - Access the genre-spanning SingStore straight from the game, purchase those treasured tracks and let the competition begin.

    My SingStar online - The fun continues with My SingStar Online upload your own photos and performances via the EyeToy Camera, browse and rate videos and find all the latest news and views.

    ', '', 1), (10, 1, 'Burnout Paradise', 'Burnout: Paradise gives players license to wreak havoc in Paradise City, the ultimate seamless racing battleground, with a massive infrastructure of traffic-heavy roads to abuse. Gone is the need to jump in and out of menus and aimlessly search for fun like many open world games - in Burnout: Paradise, every inch of the world is built to deliver heart-stopping Burnout-style gameplay. Every intersection is a potential crash junction and every alleyway is an opportunity to rack up moving violations.

    Of course, rules are made to be broken, and when gamers enter Paradise City, they're assigned a Drivers License that quickly begins to amass a record of player's most aggressive, reckless and destructive exploits behind the wheel. But it's not the law that's eyeing player's progress... when gamers push things too hard they'll be squaring off against the city's most infamous burners, and these legends aren't interested in who crosses the finish line first. Burnout: Paradise also delivers the next level of speed and destruction, with brand new next-generation technology allowing gamers to literally rip their cars in half, in the most explosive pile-ups in the series' history.

    ', '', 0), (11, 1, 'Lost', 'Based on the award-winning television series, Lost: The Video Game will allow players to experience an untold adventure of Lost in an immersive, interactive world.

    As a passenger of Oceanic flight 815, you survived the crash and find yourself on an uncharted island somewhere in the Pacific Ocean. As you begin to unravel mysteries of the island, you begin to discover secrets of your own. You will have to understand your past mistakes in order to survive and find your way home...

    Features

    • Play as a Survivor of Oceanic Flight 815 - Confront your dark past, seek your redemption, and ultimately find a way home.
    • Authentic 'Lost' Experience - Explore familiar locations, unravel mysteries, and interact with the main characters from the show.
    • Survive the Challenges that the Island throws at You - Solve puzzles, outsmart enemies, battle the smoke monster, and overcome many other challenges to survive the island and come out alive.
    ', '', 0), (12, 1, 'Britannica 2008 Children''s CD', '', '', 5), (13, 1, 'BitDefender Total Security V2008', 'ANTIVIRUS & ANTISPYWARE
  • Protects your PC in real time from known viruses, spyware and other malware with hourly updates
  • Blocks unknown viruses using advanced proactive detection techniques
  • Monitors and prevents spyware threats in real-time
  • Detects and removes the newest breed of hidden threats known as rootkits
  • Provides a smooth gaming experience by reducing the system load to a minimum

    ANTI-PHISHING

  • Protects against phishing attacks by filtering all accessed web pages for fraud attempts
  • RReduces the risk of identity theft by preventing personal information leaks via e-mail or web.

    FIREWALL

  • Controls applications’ access to the Internet while “hiding” your computer from hackers
  • Helps prevent unauthorized access to your Wi-Fi network by notifying you when computers log in to the network.

    ANTISPAM

  • Prevents different types of spam and scam e-mails from reaching your Inbox
  • Now responds faster to new spamming techniques with new adaptive engines

    PARENTAL CONTROL

  • Blocks access to inappropriate websites and e-mail
  • Allows or blocks web access during specified time periods

    BACKUP

  • Safeguards your data by creating backup copies to local and removable drives, CD-R/RW or DVD-R/RW
  • Automatically backs up only new files, based on a pre-set schedule. TUNE-UP
  • Improves your PC performance by removing unnecessary files and registry entries
  • Completely erases files and "traces" of files from disk to prevent recovery
    • ', '', 3), (14, 1, 'Dio - Lock Up The Wolves', '

    Lock up the Wolves was released May 15, 1990 and is Dio's fifth album. The working title of the album was "Metallic Blue."

    All lyrics by Ronnie James Dio

    1. "Wild One" (Dio, Rowan Robertson) – 3:57
    2. "Born on the Sun" (Dio, Robertson, Jimmy Bain, Vinny Appice) – 5:30
    3. "Hey Angel" (Dio, Robertson) – 4:50
    4. "Between Two Hearts" (Dio, Robertson) – 6:16
    5. "Night Music" (Dio, Robertson, Bain) – 4:56
    6. "Lock up the Wolves" (Dio, Robertson, Bain) – 8:18
    7. "Evil on Queen Street" (Dio, Robertson, Teddy Cook) – 5:51
    8. "Walk on Water" (Dio, Robertson, Jens Johansson) – 3:36
    9. "Twisted" (Dio, Robertson, Bain, Appice) – 4:35
    10. "Why Are They Watching Me" (Dio, Robertson) – 5:00
    11. "My Eyes" (Dio, Robertson, Johansson) – 6:24

     

     

    ', '', 1), (15, 1, 'Crazy Frg Video', 'Crazy Frog is an animated character used in the marketing of a ring tone based on The Annoying Thing, a computer animation created by Erik Wernquist. Marketed by the ringtone provider Jamba!, the animation was originally created to accompany a sound effect produced by Daniel Malmedahl while attempting to imitate the sound of a two-stroke moped engine. The Crazy Frog spawned a worldwide hit single with a remix of "Axel F", which reached the number one spot in the United Kingdom, Japan, Turkey, New Zealand, Australia and most of Europe. The subsequent album Crazy Frog Presents Crazy Hits and second single "Popcorn" also enjoyed worldwide chart success, and a second album entitled Crazy Frog Presents More Crazy Hits was released in 2006. The Crazy Frog has also spawned a range of merchandise and toys, and two video games.', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_extra_fields` -- CREATE TABLE `#__osc_products_extra_fields` ( `products_extra_fields_id` int(11) NOT NULL auto_increment, `products_extra_fields_name` varchar(64) NOT NULL default '', `products_extra_fields_order` int(3) NOT NULL default '0', `products_extra_fields_status` tinyint(1) NOT NULL default '1', `languages_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_extra_fields_id`) ) AUTO_INCREMENT=4 ; -- -- Dumping data for table `#__osc_products_extra_fields` -- INSERT INTO `#__osc_products_extra_fields` (`products_extra_fields_id`, `products_extra_fields_name`, `products_extra_fields_order`, `products_extra_fields_status`, `languages_id`) VALUES (1, 'Format', 0, 1, 0), (2, 'Age Restriction', 1, 1, 0), (3, 'Platform', 2, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_extra_images` -- CREATE TABLE `#__osc_products_extra_images` ( `products_extra_images_id` int(11) NOT NULL auto_increment, `products_id` int(11) default NULL, `products_extra_image` varchar(64) default NULL, KEY `products_extra_images_id` (`products_extra_images_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_products_extra_images` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_families` -- CREATE TABLE `#__osc_products_families` ( `family_id` smallint(3) NOT NULL default '0', `products_id` smallint(3) NOT NULL default '0' ) ; -- -- Dumping data for table `#__osc_products_families` -- INSERT INTO `#__osc_products_families` (`family_id`, `products_id`) VALUES (1, 6), (1, 3), (1, 5), (1, 4); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_groups` -- CREATE TABLE `#__osc_products_groups` ( `customers_group_id` smallint(5) unsigned NOT NULL default '0', `customers_group_price` decimal(15,4) NOT NULL default '0.0000', `products_id` int(11) NOT NULL default '0', `products_price1` decimal(15,4) NOT NULL default '0.0000', `products_price2` decimal(15,4) NOT NULL default '0.0000', `products_price3` decimal(15,4) NOT NULL default '0.0000', `products_price4` decimal(15,4) NOT NULL default '0.0000', `products_price5` decimal(15,4) NOT NULL default '0.0000', `products_price6` decimal(15,4) NOT NULL default '0.0000', `products_price7` decimal(15,4) NOT NULL default '0.0000', `products_price8` decimal(15,4) NOT NULL default '0.0000', `products_price1_qty` int(11) NOT NULL default '0', `products_price2_qty` int(11) NOT NULL default '0', `products_price3_qty` int(11) NOT NULL default '0', `products_price4_qty` int(11) NOT NULL default '0', `products_price5_qty` int(11) NOT NULL default '0', `products_price6_qty` int(11) NOT NULL default '0', `products_price7_qty` int(11) NOT NULL default '0', `products_price8_qty` int(11) NOT NULL default '0', `products_qty_blocks` int(11) NOT NULL default '1', PRIMARY KEY (`customers_group_id`,`products_id`) ) ; -- -- Dumping data for table `#__osc_products_groups` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_notifications` -- CREATE TABLE `#__osc_products_notifications` ( `products_id` int(11) NOT NULL default '0', `customers_id` int(11) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`products_id`,`customers_id`) ) ; -- -- Dumping data for table `#__osc_products_notifications` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_options` -- CREATE TABLE `#__osc_products_options` ( `products_options_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_name` varchar(32) NOT NULL, `products_options_type` int(5) NOT NULL, `products_options_length` smallint(2) NOT NULL default '32', `products_options_comment` varchar(32) default NULL, PRIMARY KEY (`products_options_id`,`language_id`) ) ; -- -- Dumping data for table `#__osc_products_options` -- INSERT INTO `#__osc_products_options` (`products_options_id`, `language_id`, `products_options_name`, `products_options_type`, `products_options_length`, `products_options_comment`) VALUES (1, 1, 'Delivery', 2, 32, ''); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_options_values` -- CREATE TABLE `#__osc_products_options_values` ( `products_options_values_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_values_name` varchar(64) NOT NULL, PRIMARY KEY (`products_options_values_id`,`language_id`) ) ; -- -- Dumping data for table `#__osc_products_options_values` -- INSERT INTO `#__osc_products_options_values` (`products_options_values_id`, `language_id`, `products_options_values_name`) VALUES (1, 1, 'Download'), (2, 1, 'CD'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_options_values_to_products_options` -- CREATE TABLE `#__osc_products_options_values_to_products_options` ( `products_options_values_to_products_options_id` int(11) NOT NULL auto_increment, `products_options_id` int(11) NOT NULL default '0', `products_options_values_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_options_values_to_products_options_id`) ) AUTO_INCREMENT=3 ; -- -- Dumping data for table `#__osc_products_options_values_to_products_options` -- INSERT INTO `#__osc_products_options_values_to_products_options` (`products_options_values_to_products_options_id`, `products_options_id`, `products_options_values_id`) VALUES (1, 1, 1), (2, 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_to_categories` -- CREATE TABLE `#__osc_products_to_categories` ( `products_id` int(11) NOT NULL default '0', `categories_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`,`categories_id`) ) ; -- -- Dumping data for table `#__osc_products_to_categories` -- INSERT INTO `#__osc_products_to_categories` (`products_id`, `categories_id`) VALUES (1, 7), (2, 1), (3, 4), (4, 4), (5, 4), (6, 4), (7, 8), (8, 8), (9, 8), (10, 8), (11, 8), (12, 5), (13, 5), (14, 9), (15, 9); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_products_to_products_extra_fields` -- CREATE TABLE `#__osc_products_to_products_extra_fields` ( `products_id` int(11) NOT NULL, `products_extra_fields_id` int(11) NOT NULL, `products_extra_fields_value` varchar(64) default NULL, PRIMARY KEY (`products_id`,`products_extra_fields_id`) ) ; -- -- Dumping data for table `#__osc_products_to_products_extra_fields` -- INSERT INTO `#__osc_products_to_products_extra_fields` (`products_id`, `products_extra_fields_id`, `products_extra_fields_value`) VALUES (4, 1, 'PC-DVD'), (4, 2, 'All Ages'), (4, 3, 'PC'), (3, 1, 'PC-DVD'), (3, 2, '13+'), (3, 3, 'PC'), (5, 1, 'PC-DVD'), (5, 2, '16+'), (5, 3, 'PC'), (6, 1, 'PC-DVD'), (6, 2, '16+'), (6, 3, 'PC'), (7, 1, 'PS3'), (7, 2, '16+'), (7, 3, 'Playstation 3'), (8, 1, 'PS3'), (8, 2, '12+'), (8, 3, 'Playstation 3'), (9, 1, 'PS3'), (9, 2, 'All Ages'), (9, 3, 'Playstation 3'), (10, 1, 'PS3'), (10, 3, 'Playstation 3'), (11, 1, 'PS3'), (11, 2, '16+'), (11, 3, 'Playstation 3'), (12, 1, 'CD'), (12, 2, 'All Ages'), (12, 3, 'PC / MAC'), (13, 1, 'CD'), (13, 3, 'PC'), (14, 1, 'CD'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_reviews` -- CREATE TABLE `#__osc_reviews` ( `reviews_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `customers_id` int(11) default NULL, `customers_name` varchar(64) NOT NULL, `reviews_rating` int(1) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `reviews_read` int(5) NOT NULL default '0', `approved` tinyint(3) unsigned default '0', PRIMARY KEY (`reviews_id`), KEY `idx_reviews_products_id` (`products_id`), KEY `idx_reviews_customers_id` (`customers_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_reviews` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_reviews_description` -- CREATE TABLE `#__osc_reviews_description` ( `reviews_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `reviews_text` text NOT NULL, PRIMARY KEY (`reviews_id`,`languages_id`) ) ; -- -- Dumping data for table `#__osc_reviews_description` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_scart` -- CREATE TABLE `#__osc_scart` ( `scartid` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `dateadded` varchar(8) NOT NULL, `datemodified` varchar(8) NOT NULL, PRIMARY KEY (`scartid`), UNIQUE KEY `scartid` (`scartid`), UNIQUE KEY `customers_id` (`customers_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_scart` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_sessions` -- CREATE TABLE `#__osc_sessions` ( `sesskey` varchar(32) NOT NULL, `expiry` int(11) unsigned NOT NULL default '0', `value` text NOT NULL, PRIMARY KEY (`sesskey`) ) ; -- -- Dumping data for table `#__osc_sessions` -- INSERT INTO `#__osc_sessions` (`sesskey`, `expiry`, `value`) VALUES ('jghfgsmlqjbfkceesm38achmn2', 1206733682, 'cart|O:12:"shoppingCart":7:{s:8:"contents";a:0:{}s:5:"total";d:97500;s:6:"weight";d:24;s:6:"cartID";s:5:"14901";s:12:"content_type";b:0;s:13:"total_virtual";d:0;s:14:"weight_virtual";d:0;}wishlist|O:14:"wishlist_class":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"USD";navigation|O:17:"navigationHistory":3:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:4:{s:6:"option";s:14:"com_oscommerce";s:5:"osMod";s:5:"index";s:6:"Itemid";s:2:"26";s:5:"catID";s:1:"3";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}s:5:"osMod";N;}affiliate_ref|N;affiliate_clickthroughs_id|N;new_products_id_in_cart|s:1:"1";'), ('4g1k1srabg7sdee90pat3trd11', 1206743563, 'cart|O:12:"shoppingCart":7:{s:8:"contents";a:2:{i:2;a:1:{s:3:"qty";i:1;}s:6:"12{1}1";a:2:{s:3:"qty";i:1;s:10:"attributes";a:1:{i:1;s:1:"1";}}}s:5:"total";d:5499;s:6:"weight";d:0;s:6:"cartID";s:5:"79433";s:12:"content_type";b:0;s:13:"total_virtual";d:0;s:14:"weight_virtual";d:0;}wishlist|O:14:"wishlist_class":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"USD";navigation|O:17:"navigationHistory":3:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:4:{s:6:"option";s:14:"com_oscommerce";s:5:"osMod";s:5:"index";s:6:"Itemid";s:2:"26";s:5:"catID";s:1:"9";}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:5:{s:6:"option";s:14:"com_oscommerce";s:5:"osMod";s:12:"product_info";s:6:"Itemid";s:2:"26";s:5:"catID";s:1:"9";s:11:"products_id";s:2:"15";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}s:5:"osMod";N;}affiliate_ref|N;affiliate_clickthroughs_id|N;new_products_id_in_cart|s:6:"12{1}1";'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_setcom` -- CREATE TABLE `#__osc_setcom` ( `s_setcom_id` int(11) NOT NULL auto_increment, `s_date_today` varchar(245) default NULL, `s_order_id` int(11) NOT NULL, `s_customers_id` int(11) NOT NULL, `s_status` varchar(245) default NULL, `s_otransid` varchar(245) default NULL, `s_identi` varchar(245) default NULL, `s_musername` varchar(245) default NULL, `s_mreference` varchar(245) default NULL, `s_busername` varchar(245) default NULL, `s_semailadd` varchar(245) default NULL, `s_bemailadd` varchar(245) default NULL, `s_ptype` varchar(245) default NULL, `s_brand` varchar(245) default NULL, `s_cardname` varchar(245) default NULL, `s_cardnum` varchar(245) default NULL, `s_famount` varchar(245) default NULL, `s_currency` varchar(245) default NULL, `s_sku` varchar(245) default NULL, `s_description` varchar(245) default NULL, `s_price` varchar(245) default NULL, `s_ttransID` varchar(245) default NULL, `s_ttype` varchar(245) default NULL, `s_sellreference` varchar(245) default NULL, `s_stype` varchar(245) default NULL, `s_dateadded` varchar(245) default NULL, `s_sreference` varchar(245) default NULL, `s_errorcode` varchar(245) default NULL, `s_authonum` varchar(245) default NULL, `s_transactionkey` varchar(245) default NULL, `s_samount` varchar(245) default NULL, `s_fee` varchar(245) default NULL, `s_tax` varchar(245) default NULL, `s_rollreserve` varchar(245) default NULL, `s_nett` varchar(245) default NULL, `s_balance` varchar(245) default NULL, `s_rollreservebal` varchar(245) default NULL, `s_fundsavail` varchar(245) default NULL, `s_rollreserveavail` varchar(245) default NULL, `s_curlerror` varchar(245) default NULL, PRIMARY KEY (`s_setcom_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_setcom` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_site_language` -- CREATE TABLE `#__osc_site_language` ( `id` int(10) NOT NULL auto_increment, `lkey` varchar(245) NOT NULL, `lvalue` longtext NOT NULL, `language` varchar(50) NOT NULL, `lpage` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_site_language` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_specials` -- CREATE TABLE `#__osc_specials` ( `specials_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000', `specials_date_added` datetime default NULL, `specials_last_modified` datetime default NULL, `expires_date` datetime default NULL, `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', `customers_group_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`specials_id`), KEY `idx_specials_products_id` (`products_id`) ) AUTO_INCREMENT=2 ; -- -- Dumping data for table `#__osc_specials` -- INSERT INTO `#__osc_specials` (`specials_id`, `products_id`, `specials_new_products_price`, `specials_date_added`, `specials_last_modified`, `expires_date`, `date_status_change`, `status`, `customers_group_id`) VALUES (1, 2, '4500.0000', '2008-03-28 22:40:01', NULL, '2017-03-30 00:00:00', NULL, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_specials_retail_prices` -- CREATE TABLE `#__osc_specials_retail_prices` ( `products_id` int(11) NOT NULL default '0', `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000', `status` tinyint(4) default NULL, `customers_group_id` smallint(6) default NULL, PRIMARY KEY (`products_id`) ) ; -- -- Dumping data for table `#__osc_specials_retail_prices` -- INSERT INTO `#__osc_specials_retail_prices` (`products_id`, `specials_new_products_price`, `status`, `customers_group_id`) VALUES (2, '4500.0000', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_subscription` -- CREATE TABLE `#__osc_subscription` ( `que_id` int(10) unsigned NOT NULL auto_increment, `client_id` int(233) unsigned default '0', `product_id` int(233) unsigned default '0', `o_order_id` int(233) unsigned default NULL, `bill_date` varchar(60) default '0', `status` varchar(6) default '0', `order_id` int(233) unsigned default NULL, `pay_date` varchar(20) default NULL, PRIMARY KEY (`que_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_subscription` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_subscriptions` -- CREATE TABLE `#__osc_subscriptions` ( `productid` int(11) NOT NULL default '0', `pay_period_type` varchar(64) NOT NULL default 'Monthly', `price_period` decimal(15,4) NOT NULL default '0.0000', `oneday_price` decimal(15,4) NOT NULL default '0.0000', `days_as_period` int(11) NOT NULL default '0', `pay_dates` text, PRIMARY KEY ( `productid` ), KEY `productid` (`productid`) ) ; -- -- Dumping data for table `#__osc_subscriptions` -- INSERT INTO `#__osc_subscriptions` (`productid`, `pay_period_type`, `price_period`, `oneday_price`, `days_as_period`, `pay_dates`) VALUES (1, 'Annually', '0.0000', '0.0000', 0, NULL), (2, 'Annually', '0.0000', '0.0000', 0, NULL), (3, 'Annually', '0.0000', '0.0000', 0, NULL), (4, 'Annually', '0.0000', '0.0000', 0, NULL), (5, 'Annually', '0.0000', '0.0000', 0, NULL), (6, 'Annually', '0.0000', '0.0000', 0, NULL), (7, 'Annually', '0.0000', '0.0000', 0, NULL), (8, 'Annually', '0.0000', '0.0000', 0, NULL), (9, 'Annually', '0.0000', '0.0000', 0, NULL), (10, 'Annually', '0.0000', '0.0000', 0, NULL), (11, 'Annually', '0.0000', '0.0000', 0, NULL), (12, 'Annually', '0.0000', '0.0000', 0, NULL), (13, 'Annually', '0.0000', '0.0000', 0, NULL), (14, 'Annually', '0.0000', '0.0000', 0, NULL), (15, 'Annually', '0.0000', '0.0000', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_subscription_config` -- CREATE TABLE `#__osc_subscription_config` ( `warning` int(6) unsigned default '0', `notice1_days` tinyint(3) unsigned default '0', `notice1_notice` text, `notice2_days` tinyint(3) unsigned default '0', `notice2_notice` text, `go` char(1) NOT NULL default '1' ) ; -- -- Dumping data for table `#__osc_subscription_config` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_subscription_customers` -- CREATE TABLE `#__osc_subscription_customers` ( `last_payed_date` int(11) NOT NULL default '0', `orderid` int(11) NOT NULL default '0', `productid` int(11) NOT NULL default '0', `login` varchar(32) NOT NULL default '', `last_payed_orderid` int(11) NOT NULL default '0', `subscriptionid` int(11) NOT NULL auto_increment, `subscription_status` varchar(50) NOT NULL default 'Active', PRIMARY KEY (`subscriptionid`), KEY `last_payed_date` (`last_payed_date`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_subscription_customers` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_subscription_que` -- CREATE TABLE `#__osc_subscription_que` ( `que_id` int(10) unsigned NOT NULL default '0', `client_id` int(233) unsigned default '0', `product_id` int(233) unsigned default '0', `o_order_id` int(233) unsigned default NULL, `bill_date` varchar(60) default '0', `status` varchar(6) default '0', `order_id` int(233) unsigned default NULL, `pay_date` varchar(20) default NULL, PRIMARY KEY (`que_id`) ) ; -- -- Dumping data for table `#__osc_subscription_que` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_supertracker` -- CREATE TABLE `#__osc_supertracker` ( `tracking_id` bigint(20) NOT NULL auto_increment, `ip_address` varchar(15) NOT NULL, `browser_string` varchar(245) NOT NULL, `country_code` char(2) NOT NULL, `country_name` varchar(100) NOT NULL, `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `referrer` varchar(245) NOT NULL, `referrer_query_string` varchar(245) NOT NULL, `landing_page` varchar(245) NOT NULL, `exit_page` varchar(100) NOT NULL, `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00', `last_click` datetime NOT NULL default '0000-00-00 00:00:00', `num_clicks` int(11) NOT NULL default '1', `added_cart` varchar(5) NOT NULL default 'false', `completed_purchase` varchar(5) NOT NULL default 'false', `categories_viewed` varchar(245) NOT NULL, `products_viewed` varchar(245) NOT NULL, `cart_contents` mediumtext NOT NULL, `cart_total` int(11) NOT NULL default '0', PRIMARY KEY (`tracking_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_supertracker` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_suppliers` -- CREATE TABLE `#__osc_suppliers` ( `suppliers_id` int(11) NOT NULL auto_increment, `suppliers_group_name` varchar(27) default NULL, `suppliers_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `suppliers_group_id` int(11) NOT NULL default '0', `suppliers_name` varchar(30) NOT NULL default '', `suppliers_password` varchar(32) NOT NULL default '', `suppliers_percentage` int(11) NOT NULL default '0', PRIMARY KEY (`suppliers_id`) ) PACK_KEYS=0 AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_suppliers` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_suppliers_info` -- CREATE TABLE `#__osc_suppliers_info` ( `suppliers_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `suppliers_url` varchar(255) NOT NULL default '', `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`suppliers_id`,`languages_id`) ) ; -- -- Dumping data for table `#__osc_suppliers_info` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_suppliers_products_groups` -- CREATE TABLE `#__osc_suppliers_products_groups` ( `products_groups_id` int(11) NOT NULL auto_increment, `suppliers_group_id` int(11) NOT NULL default '0', `suppliers_group_price` decimal(15,4) NOT NULL default '0.0000', `products_id` int(11) NOT NULL default '0', `products_price` decimal(15,4) NOT NULL default '0.0000', PRIMARY KEY (`products_groups_id`) ) AUTO_INCREMENT=100 ; -- -- Dumping data for table `#__osc_suppliers_products_groups` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_tax_class` -- CREATE TABLE `#__osc_tax_class` ( `tax_class_id` int(11) NOT NULL auto_increment, `tax_class_title` varchar(32) NOT NULL, `tax_class_description` varchar(245) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_class_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_tax_class` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_tax_rates` -- CREATE TABLE `#__osc_tax_rates` ( `tax_rates_id` int(11) NOT NULL auto_increment, `tax_zone_id` int(11) NOT NULL default '0', `tax_class_id` int(11) NOT NULL default '0', `tax_priority` int(5) default '1', `tax_rate` decimal(7,4) NOT NULL default '0.0000', `tax_description` varchar(245) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_rates_id`) ) AUTO_INCREMENT=1 ; -- -- Dumping data for table `#__osc_tax_rates` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_vendors` -- CREATE TABLE `#__osc_vendors` ( `vendors_id` int(11) NOT NULL auto_increment, `vendors_contact` varchar(32) NOT NULL, `vendors_name` varchar(32) NOT NULL, `vendors_phone1` varchar(20) NOT NULL, `vendors_phone2` varchar(20) NOT NULL, `vendors_fax` varchar(20) NOT NULL, `vendors_email` varchar(64) NOT NULL, `vendors_url` varchar(64) NOT NULL, `vendors_comments` text, `date_added` datetime default NULL, `last_modified` datetime default NULL, `vendors_image` varchar(32) default NULL, `vendors_send_email` tinyint(1) default '0', `vendors_status_send` int(11) NOT NULL default '2', `vendors_zipcode` varchar(11) NOT NULL, `vendor_street` varchar(32) default NULL, `vendor_add2` varchar(32) default NULL, `vendor_city` varchar(32) NOT NULL, `vendor_state` varchar(32) default NULL, `vendor_country` varchar(32) default NULL, `vendor_add_info` text, `account_number` varchar(32) default NULL, `handling_charge` decimal(5,2) NOT NULL default '0.00', `handling_per_box` decimal(5,3) NOT NULL default '0.000', `tare_weight` decimal(5,2) NOT NULL default '0.00', `max_box_weight` decimal(15,3) unsigned NOT NULL default '0.000', `percent_tare_weight` int(3) NOT NULL default '0', `zones` int(3) NOT NULL default '1', PRIMARY KEY (`vendors_id`) ) AUTO_INCREMENT=3 ; -- -- Dumping data for table `#__osc_vendors` -- INSERT INTO `#__osc_vendors` (`vendors_id`, `vendors_contact`, `vendors_name`, `vendors_phone1`, `vendors_phone2`, `vendors_fax`, `vendors_email`, `vendors_url`, `vendors_comments`, `date_added`, `last_modified`, `vendors_image`, `vendors_send_email`, `vendors_status_send`, `vendors_zipcode`, `vendor_street`, `vendor_add2`, `vendor_city`, `vendor_state`, `vendor_country`, `vendor_add_info`, `account_number`, `handling_charge`, `handling_per_box`, `tare_weight`, `max_box_weight`, `percent_tare_weight`, `zones`) VALUES (1, 'Store Owner', 'ECJC', '555-543-9988', '555-543-9989', '', 'owner@mystore.com', 'www.mvs.com', '', '2005-03-09 19:51:22', '2005-03-09 19:51:22', NULL, 1, 2, 'change', '889977 Astreet', 'Address line 2', 'Somewhere', 'MV', '193', '', '9999999', '0.00', '0.000', '0.00', '40.000', 0, 3); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_vendors_info` -- CREATE TABLE `#__osc_vendors_info` ( `vendors_id` int(16) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `vendors_url` varchar(245) NOT NULL, `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`vendors_id`,`languages_id`) ) ; -- -- Dumping data for table `#__osc_vendors_info` -- -- -------------------------------------------------------- -- -- Table structure for table `#__osc_vendor_configuration` -- CREATE TABLE `#__osc_vendor_configuration` ( `vendor_configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) NOT NULL, `configuration_key` varchar(64) NOT NULL, `configuration_value` text, `configuration_description` varchar(245) NOT NULL, `configuration_group_id` int(11) NOT NULL default '0', `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `use_function` varchar(245) default NULL, `set_function` text, `vendors_id` int(11) NOT NULL default '0', PRIMARY KEY (`vendor_configuration_id`) ) AUTO_INCREMENT=17 ; -- -- Dumping data for table `#__osc_vendor_configuration` -- INSERT INTO `#__osc_vendor_configuration` (`vendor_configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`, `vendors_id`) VALUES (1, 'Installed Modules', 'MODULE_VENDOR_SHIPPING_INSTALLED_1', 'freeamount.php', 'This is automatically updated. No need to edit.', 6, 0, '2007-01-11 21:00:32', '2006-12-25 06:55:15', NULL, NULL, 1), (2, 'Enable Free Shipping with Minimum Purchase', 'MODULE_SHIPPING_FREEAMOUNT_STATUS_1', 'True', 'Do you want to offer minimum order free shipping?', 6, 7, NULL, '2007-01-11 21:00:31', NULL, 'tep_cfg_select_option(array(''True'', ''False''), ', 1), (3, 'Maximum Weight', 'MODULE_SHIPPING_FREEAMOUNT_WEIGHT_MAX_1', '10', 'What is the maximum weight you will ship?', 6, 8, NULL, '2007-01-11 21:00:31', NULL, NULL, 1), (4, 'Enable Display', 'MODULE_SHIPPING_FREEAMOUNT_DISPLAY_1', 'True', 'Do you want to display text way if the minimum amount is not reached?', 6, 7, NULL, '2007-01-11 21:00:32', NULL, 'tep_cfg_select_option(array(''True'', ''False''), ', 1), (5, 'Minimum Cost', 'MODULE_SHIPPING_FREEAMOUNT_AMOUNT_1', '1.00', 'Minimum order amount purchased before shipping is free?', 6, 8, NULL, '2007-01-11 21:00:32', NULL, NULL, 1), (6, 'Sort Order', 'MODULE_SHIPPING_FREEAMOUNT_SORT_ORDER_1', '0', 'Sort order of display.', 6, 0, NULL, '2007-01-11 21:00:32', NULL, NULL, 1), (7, 'Tax Class', 'MODULE_SHIPPING_FREEAMOUNT_TAX_CLASS_1', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2007-01-11 21:00:32', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', 1), (8, 'Shipping Zone', 'MODULE_SHIPPING_FREEAMOUNT_ZONE_1', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2007-01-11 21:00:32', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', 1); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_whos_online` -- CREATE TABLE `#__osc_whos_online` ( `customer_id` int(11) default NULL, `full_name` varchar(64) NOT NULL, `session_id` varchar(128) NOT NULL, `ip_address` varchar(15) NOT NULL, `time_entry` varchar(14) NOT NULL, `time_last_click` varchar(14) NOT NULL, `last_page_url` text NOT NULL, `http_referer` VARCHAR(255) NOT NULL, `user_agent` VARCHAR(255) NOT NULL ) ; -- -- Dumping data for table `#__osc_whos_online` -- INSERT INTO `#__osc_whos_online` (`customer_id`, `full_name`, `session_id`, `ip_address`, `time_entry`, `time_last_click`, `last_page_url`) VALUES (0, 'Guest', '4g1k1srabg7sdee90pat3trd11', '127.0.0.1', '1206742120', '1206742123', '/ecjc/index.php?option=com_oscommerce&osMod=product_info&Itemid=26&catID=9&products_id=15'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_zones` -- CREATE TABLE `#__osc_zones` ( `zone_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL default '0', `zone_code` varchar(32) NOT NULL, `zone_name` varchar(32) NOT NULL, PRIMARY KEY (`zone_id`), KEY `idx_zones_to_geo_zones_country_id` (`zone_country_id`) ) AUTO_INCREMENT=191 ; -- -- Dumping data for table `#__osc_zones` -- INSERT INTO `#__osc_zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (1, 223, 'AL', 'Alabama'), (2, 223, 'AK', 'Alaska'), (3, 223, 'AS', 'American Samoa'), (4, 223, 'AZ', 'Arizona'), (5, 223, 'AR', 'Arkansas'), (6, 223, 'AF', 'Armed Forces Africa'), (7, 223, 'AA', 'Armed Forces Americas'), (8, 223, 'AC', 'Armed Forces Canada'), (9, 223, 'AE', 'Armed Forces Europe'), (10, 223, 'AM', 'Armed Forces Middle East'), (11, 223, 'AP', 'Armed Forces Pacific'), (12, 223, 'CA', 'California'), (13, 223, 'CO', 'Colorado'), (14, 223, 'CT', 'Connecticut'), (15, 223, 'DE', 'Delaware'), (16, 223, 'DC', 'District of Columbia'), (17, 223, 'FM', 'Federated States Of Micronesia'), (18, 223, 'FL', 'Florida'), (19, 223, 'GA', 'Georgia'), (20, 223, 'GU', 'Guam'), (21, 223, 'HI', 'Hawaii'), (22, 223, 'ID', 'Idaho'), (23, 223, 'IL', 'Illinois'), (24, 223, 'IN', 'Indiana'), (25, 223, 'IA', 'Iowa'), (26, 223, 'KS', 'Kansas'), (27, 223, 'KY', 'Kentucky'), (28, 223, 'LA', 'Louisiana'), (29, 223, 'ME', 'Maine'), (30, 223, 'MH', 'Marshall Islands'), (31, 223, 'MD', 'Maryland'), (32, 223, 'MA', 'Massachusetts'), (33, 223, 'MI', 'Michigan'), (34, 223, 'MN', 'Minnesota'), (35, 223, 'MS', 'Mississippi'), (36, 223, 'MO', 'Missouri'), (37, 223, 'MT', 'Montana'), (38, 223, 'NE', 'Nebraska'), (39, 223, 'NV', 'Nevada'), (40, 223, 'NH', 'New Hampshire'), (41, 223, 'NJ', 'New Jersey'), (42, 223, 'NM', 'New Mexico'), (43, 223, 'NY', 'New York'), (44, 223, 'NC', 'North Carolina'), (45, 223, 'ND', 'North Dakota'), (46, 223, 'MP', 'Northern Mariana Islands'), (47, 223, 'OH', 'Ohio'), (48, 223, 'OK', 'Oklahoma'), (49, 223, 'OR', 'Oregon'), (50, 223, 'PW', 'Palau'), (51, 223, 'PA', 'Pennsylvania'), (52, 223, 'PR', 'Puerto Rico'), (53, 223, 'RI', 'Rhode Island'), (54, 223, 'SC', 'South Carolina'), (55, 223, 'SD', 'South Dakota'), (56, 223, 'TN', 'Tennessee'), (57, 223, 'TX', 'Texas'), (58, 223, 'UT', 'Utah'), (59, 223, 'VT', 'Vermont'), (60, 223, 'VI', 'Virgin Islands'), (61, 223, 'VA', 'Virginia'), (62, 223, 'WA', 'Washington'), (63, 223, 'WV', 'West Virginia'), (64, 223, 'WI', 'Wisconsin'), (65, 223, 'WY', 'Wyoming'), (66, 38, 'AB', 'Alberta'), (67, 38, 'BC', 'British Columbia'), (68, 38, 'MB', 'Manitoba'), (69, 38, 'NF', 'Newfoundland'), (70, 38, 'NB', 'New Brunswick'), (71, 38, 'NS', 'Nova Scotia'), (72, 38, 'NT', 'Northwest Territories'), (73, 38, 'NU', 'Nunavut'), (74, 38, 'ON', 'Ontario'), (75, 38, 'PE', 'Prince Edward Island'), (76, 38, 'QC', 'Quebec'), (77, 38, 'SK', 'Saskatchewan'), (78, 38, 'YT', 'Yukon Territory'), (79, 81, 'NDS', 'Niedersachsen'), (80, 81, 'BAW', 'Baden-Württemberg'), (81, 81, 'BAY', 'Bayern'), (82, 81, 'BER', 'Berlin'), (83, 81, 'BRG', 'Brandenburg'), (84, 81, 'BRE', 'Bremen'), (85, 81, 'HAM', 'Hamburg'), (86, 81, 'HES', 'Hessen'), (87, 81, 'MEC', 'Mecklenburg-Vorpommern'), (88, 81, 'NRW', 'Nordrhein-Westfalen'), (89, 81, 'RHE', 'Rheinland-Pfalz'), (90, 81, 'SAR', 'Saarland'), (91, 81, 'SAS', 'Sachsen'), (92, 81, 'SAC', 'Sachsen-Anhalt'), (93, 81, 'SCN', 'Schleswig-Holstein'), (94, 81, 'THE', 'Thüringen'), (95, 14, 'WI', 'Wien'), (96, 14, 'NO', 'Niederösterreich'), (97, 14, 'OO', 'Oberösterreich'), (98, 14, 'SB', 'Salzburg'), (99, 14, 'KN', 'Kärnten'), (100, 14, 'ST', 'Steiermark'), (101, 14, 'TI', 'Tirol'), (102, 14, 'BL', 'Burgenland'), (103, 14, 'VB', 'Voralberg'), (104, 204, 'AG', 'Aargau'), (105, 204, 'AI', 'Appenzell Innerrhoden'), (106, 204, 'AR', 'Appenzell Ausserrhoden'), (107, 204, 'BE', 'Bern'), (108, 204, 'BL', 'Basel-Landschaft'), (109, 204, 'BS', 'Basel-Stadt'), (110, 204, 'FR', 'Freiburg'), (111, 204, 'GE', 'Genf'), (112, 204, 'GL', 'Glarus'), (113, 204, 'JU', 'Graubünden'), (114, 204, 'JU', 'Jura'), (115, 204, 'LU', 'Luzern'), (116, 204, 'NE', 'Neuenburg'), (117, 204, 'NW', 'Nidwalden'), (118, 204, 'OW', 'Obwalden'), (119, 204, 'SG', 'St. Gallen'), (120, 204, 'SH', 'Schaffhausen'), (121, 204, 'SO', 'Solothurn'), (122, 204, 'SZ', 'Schwyz'), (123, 204, 'TG', 'Thurgau'), (124, 204, 'TI', 'Tessin'), (125, 204, 'UR', 'Uri'), (126, 204, 'VD', 'Waadt'), (127, 204, 'VS', 'Wallis'), (128, 204, 'ZG', 'Zug'), (129, 204, 'ZH', 'Zürich'), (130, 195, 'A Coruña', 'A Coruña'), (131, 195, 'Alava', 'Alava'), (132, 195, 'Albacete', 'Albacete'), (133, 195, 'Alicante', 'Alicante'), (134, 195, 'Almeria', 'Almeria'), (135, 195, 'Asturias', 'Asturias'), (136, 195, 'Avila', 'Avila'), (137, 195, 'Badajoz', 'Badajoz'), (138, 195, 'Baleares', 'Baleares'), (139, 195, 'Barcelona', 'Barcelona'), (140, 195, 'Burgos', 'Burgos'), (141, 195, 'Caceres', 'Caceres'), (142, 195, 'Cadiz', 'Cadiz'), (143, 195, 'Cantabria', 'Cantabria'), (144, 195, 'Castellon', 'Castellon'), (145, 195, 'Ceuta', 'Ceuta'), (146, 195, 'Ciudad Real', 'Ciudad Real'), (147, 195, 'Cordoba', 'Cordoba'), (148, 195, 'Cuenca', 'Cuenca'), (149, 195, 'Girona', 'Girona'), (150, 195, 'Granada', 'Granada'), (151, 195, 'Guadalajara', 'Guadalajara'), (152, 195, 'Guipuzcoa', 'Guipuzcoa'), (153, 195, 'Huelva', 'Huelva'), (154, 195, 'Huesca', 'Huesca'), (155, 195, 'Jaen', 'Jaen'), (156, 195, 'La Rioja', 'La Rioja'), (157, 195, 'Las Palmas', 'Las Palmas'), (158, 195, 'Leon', 'Leon'), (159, 195, 'Lleida', 'Lleida'), (160, 195, 'Lugo', 'Lugo'), (161, 195, 'Madrid', 'Madrid'), (162, 195, 'Malaga', 'Malaga'), (163, 195, 'Melilla', 'Melilla'), (164, 195, 'Murcia', 'Murcia'), (165, 195, 'Navarra', 'Navarra'), (166, 195, 'Ourense', 'Ourense'), (167, 195, 'Palencia', 'Palencia'), (168, 195, 'Pontevedra', 'Pontevedra'), (169, 195, 'Salamanca', 'Salamanca'), (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife'), (171, 195, 'Segovia', 'Segovia'), (172, 195, 'Sevilla', 'Sevilla'), (173, 195, 'Soria', 'Soria'), (174, 195, 'Tarragona', 'Tarragona'), (175, 195, 'Teruel', 'Teruel'), (182, 193, 'WP', 'Western Cape'), (183, 193, 'GP', 'Gauteng'), (184, 193, 'KZN', 'Kwazulu Natal'), (185, 193, 'NC', 'Northern Cape'), (186, 193, 'EC', 'Eastern Cape'), (187, 193, 'MP', 'Mpumalanga'), (188, 193, 'NW', 'North West'), (189, 193, 'FS', 'Free State'), (190, 193, 'LIM', 'Limpopo'); -- -------------------------------------------------------- -- -- Table structure for table `#__osc_zones_to_geo_zones` -- CREATE TABLE `#__osc_zones_to_geo_zones` ( `association_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL default '0', `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`association_id`) ) AUTO_INCREMENT=2 ; -- -- Dumping data for table `#__osc_zones_to_geo_zones` -- -- 12.04.2008 Featured products on frontpage addition -- INSERT into #__osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Maximum Display of Featured', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'This is the maximum amount of items to display on the front page, 0 to disable', '1', '18', '2008-03-13 19:26:24', '2008-03-13 19:26:24'); --rc3 fixes Update #__osc_configuration set configuration_title='Licence Code', configuration_description='Your Licence code to remove limitations and google ads' where configuration_title='Show GA'; ALTER TABLE `#__osc_affiliate_affiliate` CHANGE `affiliate_email_address` `affiliate_email_address` VARCHAR( 200 ) NOT NULL ,CHANGE `affiliate_password` `affiliate_password` VARCHAR( 100 ) NOT NULL; --1.2 INSERT INTO `#__osc_configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('End of Auction - Options', 'AUCTION_END_PRODUCT', '1', 'How do you want your auctions to end, select an option:
    0 - Product goes inactive
    1 - Product remains active but can''t be bid on', 1984, 1, '2006-11-13 19:26:24', '2006-11-11 13:23:56', NULL, 'tep_cfg_select_option(array(''0'', ''1''), '); INSERT INTO `#__osc_configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Enable SSL Mode', 'ENABLE_SSL', 'False', 'Enable SSL Mode', 1, 1, '2006-11-13 19:26:24', '2006-11-11 13:23:56', NULL, 'tep_cfg_select_option(array(''True'', ''False''), '); INSERT INTO `#__osc_configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Tax info and Shipping info', 'TAX_INFO_ONOFF', 'Disabled', 'Show info of Tax and shippping', 8, 18, '2004-06-29 07:10:52', '2004-06-29 07:10:52', NULL, 'tep_cfg_select_option(array(''Enabled'', ''Disabled''),'); ALTER TABLE `#__osc_customers` ADD customers_credit_account_status varchar(9) NOT NULL default '0', ADD customers_credit_status varchar(9) NOT NULL default '0', ADD customers_credit_amount decimal(9,2) NOT NULL default '0250.00', ADD customers_credit_left decimal(9,2) NOT NULL default '0250.00'; ALTER TABLE `#__osc_orders` ADD `purchase_order_number` VARCHAR( 20 ), ADD `customers_credit_amount` decimal(9,2) NOT NULL default '0.00', ADD `customers_credit_left` decimal(9,2) NOT NULL default '0.00'; ALTER TABLE `#__osc_orders` ADD INDEX ( `purchase_order_number` ) ;