# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Nov 30, 2004 at 05:29 PM
# Server version: 4.00.04
# PHP Version: 4.2.3
# Database : `sbclassified_changed`
# --------------------------------------------------------
#
# Table structure for table `sbbanners_sizes`
#
DROP TABLE IF EXISTS `sbbanners_sizes`;
CREATE TABLE `sbbanners_sizes` (
`id` bigint(20) NOT NULL auto_increment,
`height` int(11) default NULL,
`width` int(11) default NULL,
`default_banner` varchar(255) default NULL,
`sborder` bigint(20) NOT NULL default '-1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbbanners_sizes`
#
INSERT INTO `sbbanners_sizes` (`id`, `height`, `width`, `default_banner`, `sborder`) VALUES (4, 60, 468, '36186898.gif', 3);
# --------------------------------------------------------
#
# Table structure for table `sbclassified_additional_fields`
#
DROP TABLE IF EXISTS `sbclassified_additional_fields`;
CREATE TABLE `sbclassified_additional_fields` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_type` varchar(255) default NULL,
`sb_name` varchar(255) default NULL,
`sb_label` varchar(255) default NULL,
`sb_int_value` longtext,
`sb_req` varchar(255) default NULL,
`sb_display` varchar(255) default NULL,
`sb_width` int(11) default NULL,
`sb_num_lines` int(11) default NULL,
`sb_is_num` varchar(255) default 'no',
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_additional_fields`
#
INSERT INTO `sbclassified_additional_fields` (`sb_id`, `sb_type`, `sb_name`, `sb_label`, `sb_int_value`, `sb_req`, `sb_display`, `sb_width`, `sb_num_lines`, `sb_is_num`) VALUES (9, 'text', 'sb_quantity', 'Quantity Available', '', 'yes', 'yes', 10, 0, 'yes');
INSERT INTO `sbclassified_additional_fields` (`sb_id`, `sb_type`, `sb_name`, `sb_label`, `sb_int_value`, `sb_req`, `sb_display`, `sb_width`, `sb_num_lines`, `sb_is_num`) VALUES (10, 'text', 'sb_ship_cost', 'Shipping Cost', '', 'no', 'yes', 10, 0, 'yes');
INSERT INTO `sbclassified_additional_fields` (`sb_id`, `sb_type`, `sb_name`, `sb_label`, `sb_int_value`, `sb_req`, `sb_display`, `sb_width`, `sb_num_lines`, `sb_is_num`) VALUES (11, 'select', 'sb_who_pay_sc', 'Who will pay shipping cost?', '+Buyer|Seller', 'yes', 'yes', 0, 0, 'no');
INSERT INTO `sbclassified_additional_fields` (`sb_id`, `sb_type`, `sb_name`, `sb_label`, `sb_int_value`, `sb_req`, `sb_display`, `sb_width`, `sb_num_lines`, `sb_is_num`) VALUES (8, 'text', 'sb_price', 'Price', '', 'yes', 'yes', 10, 0, 'yes');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_admin`
#
DROP TABLE IF EXISTS `sbclassified_admin`;
CREATE TABLE `sbclassified_admin` (
`id` bigint(20) NOT NULL auto_increment,
`admin_name` varchar(255) default NULL,
`pwd` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_admin`
#
INSERT INTO `sbclassified_admin` (`id`, `admin_name`, `pwd`) VALUES (1, 'admin', 'admin');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_ads`
#
DROP TABLE IF EXISTS `sbclassified_ads`;
CREATE TABLE `sbclassified_ads` (
`id` bigint(20) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`bannerurl` varchar(255) NOT NULL default '',
`adv_id` bigint(20) NOT NULL default '0',
`credits` bigint(20) NOT NULL default '0',
`displays` bigint(20) NOT NULL default '0',
`paid` varchar(255) NOT NULL default '',
`approved` varchar(255) NOT NULL default '',
`clicks` bigint(20) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_ads`
#
INSERT INTO `sbclassified_ads` (`id`, `url`, `bannerurl`, `adv_id`, `credits`, `displays`, `paid`, `approved`, `clicks`) VALUES (1, 'sdds', 'dss', 0, 1221, 1039, 'yes', 'no', 1);
INSERT INTO `sbclassified_ads` (`id`, `url`, `bannerurl`, `adv_id`, `credits`, `displays`, `paid`, `approved`, `clicks`) VALUES (3, 'http://www.vin.edu', 'http://www.v.e/ee.gif', 2, 1000, 1000, 'yes', 'yes', 4);
# --------------------------------------------------------
#
# Table structure for table `sbclassified_adv_transactions`
#
DROP TABLE IF EXISTS `sbclassified_adv_transactions`;
CREATE TABLE `sbclassified_adv_transactions` (
`id` bigint(20) NOT NULL auto_increment,
`description` varchar(255) default NULL,
`amount` decimal(10,2) default NULL,
`adv_id` bigint(20) default NULL,
`date_submitted` timestamp(14) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_adv_transactions`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_advertisers`
#
DROP TABLE IF EXISTS `sbclassified_advertisers`;
CREATE TABLE `sbclassified_advertisers` (
`id` bigint(20) NOT NULL auto_increment,
`uname` varchar(255) default NULL,
`email` varchar(255) default NULL,
`pwd` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_advertisers`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_auction_types`
#
DROP TABLE IF EXISTS `sbclassified_auction_types`;
CREATE TABLE `sbclassified_auction_types` (
`id` bigint(20) NOT NULL auto_increment,
`auction_name` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_auction_types`
#
INSERT INTO `sbclassified_auction_types` (`id`, `auction_name`) VALUES (3, 'fixed');
INSERT INTO `sbclassified_auction_types` (`id`, `auction_name`) VALUES (2, 'dutch');
INSERT INTO `sbclassified_auction_types` (`id`, `auction_name`) VALUES (1, 'auction');
INSERT INTO `sbclassified_auction_types` (`id`, `auction_name`) VALUES (4, 'classified');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_blocked`
#
DROP TABLE IF EXISTS `sbclassified_blocked`;
CREATE TABLE `sbclassified_blocked` (
`id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) default NULL,
`blocked_user` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_blocked`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_categories`
#
DROP TABLE IF EXISTS `sbclassified_categories`;
CREATE TABLE `sbclassified_categories` (
`id` bigint(20) NOT NULL auto_increment,
`cat_name` varchar(255) default NULL,
`pid` bigint(20) default NULL,
`clicks` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_categories`
#
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (16, 'Chemicals', 25, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (25, 'Energy', 0, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (41, 'Medical', 0, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (27, 'Computer', 0, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (28, 'Minerals & Materials', 25, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (37, 'Hardware Components', 27, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (40, 'Communication', 0, NULL);
INSERT INTO `sbclassified_categories` (`id`, `cat_name`, `pid`, `clicks`) VALUES (39, 'Application Softwares', 27, NULL);
# --------------------------------------------------------
#
# Table structure for table `sbclassified_config`
#
DROP TABLE IF EXISTS `sbclassified_config`;
CREATE TABLE `sbclassified_config` (
`id` bigint(20) NOT NULL auto_increment,
`admin_email` varchar(255) default NULL,
`sb_site_name` varchar(255) default NULL,
`sb_site_keywords` varchar(255) default NULL,
`sb_logo` varchar(255) default NULL,
`recperpage` int(11) default NULL,
`sb_paypal_id` varchar(255) default NULL,
`sb_seller_id` varchar(255) default '0',
`sb_enable_paypal` varchar(255) default NULL,
`sb_enable_checkout` varchar(255) default NULL,
`sb_enable_offline` varchar(255) default NULL,
`sb_billing_terms` longtext,
`sb_offline_details` longtext,
`no_of_images` int(11) default NULL,
`agreement` longtext,
`recinpanel` int(11) default NULL,
`null_char` varchar(255) default NULL,
`privacy` longtext,
`legal` longtext,
`terms` longtext,
`username_len` int(11) default NULL,
`pwd_len` int(11) default NULL,
`site_root` varchar(255) default NULL,
`featured_items` int(11) default NULL,
`fp_images` int(11) default '0',
`bonus` decimal(10,2) default NULL,
`bold_rate` decimal(10,2) default NULL,
`featured_rate` decimal(10,2) default NULL,
`highlight_rate` decimal(10,2) default NULL,
`free_images` int(10) default NULL,
`image_rate` decimal(10,2) default NULL,
`buy_images` int(10) default NULL,
`welcome_msg` longtext,
`max_period` int(10) default NULL,
`fp_featured_rate` decimal(10,2) default NULL,
`gallery_featured_rate` decimal(10,2) default NULL,
`item_fees` decimal(10,2) default '0.00',
`image_size` bigint(20) default '60',
`buy_now` decimal(10,2) default NULL,
`cur_id` bigint(20) default '1',
`max_ext_period` int(11) default '10',
`ext_cost` decimal(10,2) default '0.00',
`banner_approval` varchar(50) NOT NULL default 'admin',
`contact_info` varchar(50) default 'no',
`sb_date_format` bigint(20) default '5',
`sb_time_format` bigint(20) default '2',
`sb_style_list` bigint(20) default '2',
`sb_icon_list` bigint(20) default '2',
`featured_cnt` bigint(20) default NULL,
`elapsed_date` varchar(255) default 'yes',
`show_stat` varchar(255) default 'no',
`cat_choosen` varchar(255) default 'drop',
`image_magik` varchar(255) default NULL,
`water_marking` varchar(255) default NULL,
`th_width` bigint(20) default NULL,
`th_width2` bigint(20) default NULL,
`premium_cnt` int(11) default '5',
`layout_listing` int(11) default '1',
`sb_show_color` varchar(50) default 'yes',
`sb_default_image` varchar(255) default NULL,
`sb_prod_approval` varchar(255) default 'auto',
`sb_mem_approval` varchar(255) default 'auto',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_config`
#
INSERT INTO `sbclassified_config` (`id`, `admin_email`, `sb_site_name`, `sb_site_keywords`, `sb_logo`, `recperpage`, `sb_paypal_id`, `sb_seller_id`, `sb_enable_paypal`, `sb_enable_checkout`, `sb_enable_offline`, `sb_billing_terms`, `sb_offline_details`, `no_of_images`, `agreement`, `recinpanel`, `null_char`, `privacy`, `legal`, `terms`, `username_len`, `pwd_len`, `site_root`, `featured_items`, `fp_images`, `bonus`, `bold_rate`, `featured_rate`, `highlight_rate`, `free_images`, `image_rate`, `buy_images`, `welcome_msg`, `max_period`, `fp_featured_rate`, `gallery_featured_rate`, `item_fees`, `image_size`, `buy_now`, `cur_id`, `max_ext_period`, `ext_cost`, `banner_approval`, `contact_info`, `sb_date_format`, `sb_time_format`, `sb_style_list`, `sb_icon_list`, `featured_cnt`, `elapsed_date`, `show_stat`, `cat_choosen`, `image_magik`, `water_marking`, `th_width`, `th_width2`, `premium_cnt`, `layout_listing`, `sb_show_color`, `sb_default_image`, `sb_prod_approval`, `sb_mem_approval`) VALUES (1, '[email protected]', 'Softbiz Classified Ads PLUS Script', 'classified ads,classifieds, business ads, ads directory script', '41445720.gif', 10, '[email protected]', '1232', 'yes', 'yes', 'yes', 'Billing Terms Here Billing Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms HereBilling Terms Here', 'Please send DD/Cheque at the following address:<b>\r\nA/c No. -XXXXXXX \r\nXYZ Bank\r\nABC City</b>\r\nFunds will be transferred to your account as soon as payment has been confirmed, Thanks', 6, 'Your Agreement Here Your Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\nYour Agreement Here\r\n\r\n', 8, '--', '<font type=\'arial\' size=4><b>\'Privacy Policy</b></font>\r\n<font type=\'arial\' size=2><br>Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. <p>\r\nAdmin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. <p>Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. Admin privacy policies here. <p>\r\n</font>', '<font type=\'arial\' size=4><b>\'Legal Policy</b></font>\r\n<font type=\'arial\' size=2><br>Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.<p>Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.<p>Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.<p>Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.<p>Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.Legal privacy policies here.<p>', '<font type=\'arial\' size=4><b>\'Terms and Conditions</b></font>\r\n<font type=\'arial\' size=2><br>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>Terms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions hereTerms & Conditions here<p>', 3, 4, 'http://localhost/ClassifiedsPLUS', 5, 2, '1.00', '0.50', '0.75', '0.60', 3, '1.00', 3, '<font size="2" face="Arial, Helvetica, sans-serif"><strong>Welcome to Softbiz \r\nClassifieds PLUS Script </strong></font> \r\n<p><font size="2" face="Arial, Helvetica, sans-serif">Softbiz Online Classifieds \r\n PLUS Script is an Advanced PHP script to run your classifieds site. It is a \r\n COMPLETE SCRIPT with quality features like:</font></p>\r\n<ul>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">WYSIWYG editor for ad \r\n posting</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Full Internal Messaging \r\n system </font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> Support for contact \r\n list, block list</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Seller Stores</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Favorites management</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> Secure gateway integration</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Preconfigured for paypal, \r\n 2Checkout and offline payments</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Direct selling through \r\n paypal for sellers</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> Support for featured, \r\n highlightes and gallery featured its</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif">Premium stores</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> FULLY customizable site \r\n colors and graphics </font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> Script parameters are \r\n highly configurable through script admin panel.</font></li>\r\n <li><font size="2" face="Arial, Helvetica, sans-serif"> And of course great \r\n earning potential <br>\r\n PLUS lot more...You can see Full feature list <a href="http://www.softbizscripts.com/classified-ads-plus-script-features.php">here</a>.<br>\r\n All this for a price as low as just $99<br>\r\n </font><font face="Arial, Helvetica, sans-serif"> </font> </li>\r\n</ul>\r\n', 15, '0.70', '0.80', '1.00', 60000, '1.00', 1, 5, '0.05', 'admin', 'yes', 6, 1, 18, 2, 1, 'yes', 'yes', 'pop', 'disable', 'disable', 80, 50, 9, 1, 'yes', '14380446.gif', 'auto', 'auto');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_contacts`
#
DROP TABLE IF EXISTS `sbclassified_contacts`;
CREATE TABLE `sbclassified_contacts` (
`id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) default NULL,
`contact_user` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_contacts`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_counters`
#
DROP TABLE IF EXISTS `sbclassified_counters`;
CREATE TABLE `sbclassified_counters` (
`id` bigint(20) NOT NULL auto_increment,
`zero` varchar(255) default NULL,
`one` varchar(255) default NULL,
`two` varchar(255) default NULL,
`three` varchar(255) default NULL,
`four` varchar(255) default NULL,
`five` varchar(255) default NULL,
`six` varchar(255) default NULL,
`seven` varchar(255) default NULL,
`eight` varchar(255) default NULL,
`nine` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_counters`
#
INSERT INTO `sbclassified_counters` (`id`, `zero`, `one`, `two`, `three`, `four`, `five`, `six`, `seven`, `eight`, `nine`) VALUES (1, '0.gif', '1.gif', '2.gif', '3.gif', '4.gif', '5.gif', '6.gif', '7.gif', '8.gif', '9.gif');
INSERT INTO `sbclassified_counters` (`id`, `zero`, `one`, `two`, `three`, `four`, `five`, `six`, `seven`, `eight`, `nine`) VALUES (2, 'a0.gif', 'a1.gif', 'a2.gif', 'a3.gif', 'a4.gif', 'a5.gif', 'a6.gif', 'a7.gif', 'a8.gif', 'a9.gif');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_country`
#
DROP TABLE IF EXISTS `sbclassified_country`;
CREATE TABLE `sbclassified_country` (
`country` varchar(255) NOT NULL default '',
`id` bigint(20) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_country`
#
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Afghanistan', 1);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Albania', 2);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Algeria', 3);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Andorra', 4);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Angola', 5);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Anguilla', 6);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Antigua & Barbuda', 7);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Argentina', 8);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Armenia', 9);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Austria', 10);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Azerbaijan', 11);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bahamas', 12);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bahrain', 13);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bangladesh', 14);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Barbados', 15);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Belarus', 16);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Belgium', 17);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Belize', 18);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Belize', 19);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bermuda', 20);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bhutan', 21);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bolivia', 22);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bosnia and Herzegovina', 23);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Botswana', 24);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Brazil', 25);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Brunei', 26);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Bulgaria', 27);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Burkina Faso', 28);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Burundi', 29);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cambodia', 30);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cameroon', 31);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Canada', 32);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cape Verde', 33);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cayman Islands', 34);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Central African Republic', 35);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Chad', 36);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Chile', 37);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('China', 38);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Colombia', 39);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Comoros', 40);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Congo', 41);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Congo (DRC)', 42);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cook Islands', 43);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Costa Rica', 44);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cote d\'Ivoire', 45);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Croatia (Hrvatska)', 46);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cuba', 47);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Cyprus', 48);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Czech Republic', 49);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Denmark', 50);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Djibouti', 51);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Dominica', 52);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Dominican Republic', 53);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('East Timor', 54);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Ecuador', 55);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Egypt', 56);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('El Salvador', 57);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Equatorial Guinea', 58);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Eritrea', 59);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Estonia', 60);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Ethiopia', 61);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Falkland Islands', 62);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Faroe Islands', 63);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Fiji Islands', 64);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Finland', 65);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('France', 66);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('French Guiana', 67);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('French Polynesia', 68);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Gabon', 69);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Gambia', 70);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Georgia', 71);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Germany', 72);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Ghana', 73);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Gibraltar', 74);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Greece', 75);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Greenland', 76);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Grenada', 77);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guadeloupe', 78);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guam', 79);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guatemala', 80);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guinea', 81);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guinea-Bissau', 82);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Guyana', 83);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Haiti', 84);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Honduras', 85);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Hong Kong SAR', 86);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Hungary', 87);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Iceland', 88);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('India', 89);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Indonesia', 90);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Iran', 91);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Iraq', 92);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Ireland', 93);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Israel', 94);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Italy', 95);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Jamaica', 96);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Japan', 97);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Jordan', 98);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Kazakhstan', 99);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Kenya', 100);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Kiribati', 101);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Korea', 102);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Kuwait', 103);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Kyrgyzstan', 104);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Laos', 105);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Latvia', 106);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Lebanon', 107);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Lesotho', 108);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Liberia', 109);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Libya', 110);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Liechtenstein', 111);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Lithuania', 112);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Luxembourg', 113);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Macao SAR', 114);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Macedonia', 115);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Madagascar', 116);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Malawi', 117);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Malaysia', 118);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Maldives', 119);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mali', 120);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Malta', 121);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Martinique', 122);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mauritania', 123);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mauritius', 124);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mayotte', 125);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mexico', 126);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Micronesia', 127);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Moldova', 128);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Monaco', 129);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mongolia', 130);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Montserrat', 131);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Morocco', 132);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Mozambique', 133);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Myanmar', 134);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Namibia', 135);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Nauru', 136);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Nepal', 137);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Netherlands', 138);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Netherlands Antilles', 139);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('New Caledonia', 140);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('New Zealand', 141);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Nicaragua', 142);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Niger', 143);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Nigeria', 144);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Niue', 145);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Norfolk Island', 146);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('North Korea', 147);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Norway', 148);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Oman', 149);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Pakistan', 150);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Panama', 151);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Papua New Guinea', 152);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Paraguay', 153);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Peru', 154);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Philippines', 155);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Pitcairn Islands', 156);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Poland', 157);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Portugal', 158);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Puerto Rico', 159);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Qatar', 160);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Reunion', 161);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Romania', 162);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Russia', 163);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Rwanda', 164);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Samoa', 165);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('San Marino', 166);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Sao Tome and Principe', 167);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Saudi Arabia', 168);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Senegal', 169);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Serbia and Montenegro', 170);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Seychelles', 171);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Sierra Leone', 172);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Singapore', 173);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Slovakia', 174);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Slovenia', 175);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Solomon Islands', 176);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Somalia', 177);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('South Africa', 178);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Spain', 179);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Sri Lanka', 180);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('St. Helena', 181);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('St. Kitts and Nevis', 182);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('St. Lucia', 183);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('St. Pierre and Miquelon', 184);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('St. Vincent & Grenadines', 185);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Sudan', 186);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Suriname', 187);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Swaziland', 188);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Sweden', 189);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Switzerland', 190);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Syria', 191);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Taiwan', 192);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tajikistan', 193);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tanzania', 194);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Thailand', 195);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Togo', 196);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tokelau', 197);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tonga', 198);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Trinidad and Tobago', 199);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tunisia', 200);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Turkey', 201);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Turkmenistan', 202);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Turks and Caicos Islands', 203);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Tuvalu', 204);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Uganda', 205);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Ukraine', 206);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('United Arab Emirates', 207);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('United Kingdom', 208);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Uruguay', 209);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('USA', 210);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Uzbekistan', 211);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Vanuatu', 212);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Venezuela', 213);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Vietnam', 214);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Virgin Islands', 215);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Virgin Islands (British)', 216);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Wallis and Futuna', 217);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Yemen', 218);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Yugoslavia', 219);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Zambia', 220);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Zimbabwe', 221);
INSERT INTO `sbclassified_country` (`country`, `id`) VALUES ('Australia', 222);
# --------------------------------------------------------
#
# Table structure for table `sbclassified_currency`
#
DROP TABLE IF EXISTS `sbclassified_currency`;
CREATE TABLE `sbclassified_currency` (
`id` bigint(20) NOT NULL auto_increment,
`cur_name` varchar(255) default NULL,
`paypal_code` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_currency`
#
INSERT INTO `sbclassified_currency` (`id`, `cur_name`, `paypal_code`) VALUES (1, '$', 'USD');
INSERT INTO `sbclassified_currency` (`id`, `cur_name`, `paypal_code`) VALUES (2, '£', 'GBP');
INSERT INTO `sbclassified_currency` (`id`, `cur_name`, `paypal_code`) VALUES (3, '€', 'EUR');
INSERT INTO `sbclassified_currency` (`id`, `cur_name`, `paypal_code`) VALUES (4, '$', 'CAD');
INSERT INTO `sbclassified_currency` (`id`, `cur_name`, `paypal_code`) VALUES (5, '¥', 'JPY');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_dateformats`
#
DROP TABLE IF EXISTS `sbclassified_dateformats`;
CREATE TABLE `sbclassified_dateformats` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_format` varchar(255) default NULL,
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_dateformats`
#
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (1, '2004-06-29');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (2, '06-29-2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (3, '29-06-2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (4, '29 Jun 2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (5, '29 June 2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (6, 'Jun 29th,2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (7, 'Tue Jun 29th,2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (8, 'Tuesday Jun 29th,2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (9, 'Tuesday June 29th,2004');
INSERT INTO `sbclassified_dateformats` (`sb_id`, `sb_format`) VALUES (10, '29 June 2004 Tuesday');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_email_id`
#
DROP TABLE IF EXISTS `sbclassified_email_id`;
CREATE TABLE `sbclassified_email_id` (
`id` bigint(20) NOT NULL auto_increment,
`fname` varchar(255) default NULL,
`lname` varchar(255) default NULL,
`useremail` varchar(255) default NULL,
`friend_email` longtext,
`no_of_friends` int(11) default NULL,
`sid` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_email_id`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_favourites`
#
DROP TABLE IF EXISTS `sbclassified_favourites`;
CREATE TABLE `sbclassified_favourites` (
`id` bigint(20) NOT NULL auto_increment,
`pid` bigint(20) default NULL,
`uid` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_favourites`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_icons`
#
DROP TABLE IF EXISTS `sbclassified_icons`;
CREATE TABLE `sbclassified_icons` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_title` varchar(255) default NULL,
`sb_mem_opt` varchar(255) default NULL,
`sb_contact_seller` varchar(255) default NULL,
`sb_store` varchar(255) default NULL,
`sb_add_fav` varchar(255) default NULL,
`sb_buy_now` varchar(255) default NULL,
`sb_bar` varchar(255) default NULL,
`sb_details` varchar(255) default NULL,
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_icons`
#
INSERT INTO `sbclassified_icons` (`sb_id`, `sb_title`, `sb_mem_opt`, `sb_contact_seller`, `sb_store`, `sb_add_fav`, `sb_buy_now`, `sb_bar`, `sb_details`) VALUES (2, 'icon2', '74225399.gif', '85377896.gif', '60973420.gif', '90224797.gif', '57991888.gif', '15482334.gif', '58496072.gif');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_images`
#
DROP TABLE IF EXISTS `sbclassified_images`;
CREATE TABLE `sbclassified_images` (
`id` bigint(20) NOT NULL auto_increment,
`pid` bigint(20) default NULL,
`url` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_images`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_mails`
#
DROP TABLE IF EXISTS `sbclassified_mails`;
CREATE TABLE `sbclassified_mails` (
`id` bigint(20) NOT NULL auto_increment,
`mailid` bigint(20) NOT NULL default '0',
`fromid` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`mail` longtext NOT NULL,
`sb_status` varchar(255) default 'no',
`sb_html_format` varchar(255) default 'no',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_mails`
#
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (2, 2, '[email protected]', 'Your product has been Approved', 'Hi %fname% %lname%,\r<br>\r<br>Your product %productname% has been Approved for inclusion on the site.\r<br>You can view this product on %producturl%\r<br>\r<br>Regards,\r<br>Admin', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (3, 3, '[email protected]', 'Your product has been disapproved', '<FONT face="Arial, Helvetica, sans-serif" size=2>Hi %fname% %lname%, <BR><BR>Your product %productname% has been disapproved from inclusion on the site. <BR><BR><BR>Regards, <BR>Admin</FONT> ', 'no', 'yes');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (4, 4, '[email protected]', 'Your password', 'Hi %fname% %lname%,\r<br>\r<br>Here is your login information:\r<br>\r<br>Username: %username%\r<br>Password: %password%\r<br>Email: %email%\r<br>\r<br>\r<br>Thanks for being part of our website.\r<br>\r<br>Regards,\r<br>Admin\r<br>For login click %loginurl%', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (1, 1, '[email protected]', 'Welcome to classified.com', '<FONT face="Arial, Helvetica, sans-serif" size=2>Hi %fname% %lname%, <BR><BR>Welcome to sbclassified.com. <BR><BR>Your registration information is as follows: <BR><BR>Username: %username% <BR>Password: %password% <BR>Email: %email% <BR><BR>Thanks for being part of our website. <BR><BR>Regards, <BR>Admin <BR>For login click %loginurl% <BR></FONT>', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (5, 5, '[email protected]', 'Your product has been Posted', 'Hi %fname%%lname%,\r<br>\r<br>Your product %productname% has been Posted to our site.You can view this product at %producturl%.\r<br>\r<br>\r<br>Regards,\r<br>Admin', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (11, 11, '[email protected]', 'Send Stat Mail', 'Hi \r<br>\r<br>There are statistics information regarding your banner display on our site::\r<br>Banner ::%bannerurl%\r<br>Displays::%displays%\r<br>credits ::%credits%\r<br>balance ::%balance%\r<br>\r<br>Regards,\r<br>Admin', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (8, 8, '[email protected]', 'Message from user.', '<FONT face="Arial, Helvetica, sans-serif" size=2>Hi %fname% %lname%, <BR><BR>You have been recieved a message <BR>From :: %sender_username% <BR>Title :: %message_title% <BR>Message :: %message_text% <BR>Time :: %message_time% <BR>Date :: %message_date% <BR><BR><BR>Regards, <BR>Admin</FONT> ', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (6, 6, '[email protected]', 'Purchase Request', 'Hi <fname> <lname>, A purchase request for your product <productname>, cost <productcost> has been Posted to our site.You can view this product at <producturl>. Regards, Admin', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (7, 7, '[email protected]', 'Your password', 'Hi %fname% , <BR><BR>Here is your login information: <BR><BR>Password: %password% <BR>Email: %email% <BR><BR><BR>Thanks for being part of our website. <BR><BR>Regards, <BR>Admin <BR>For login click %loginurl% ', 'no', 'no');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (9, 9, '[email protected]', 'offline payment of members', '<P align=left>Hi admin,<BR> this user has selected offline payment mode for payment<BR>Details of user :<BR>Username : %username%<BR>Email : <FONT face=Arial size=2>%email%</FONT><BR>Password : %password%<BR>Payment method :Offline<BR>Amount : %payment%<BR><BR>Thanks</P>', 'yes', 'yes');
INSERT INTO `sbclassified_mails` (`id`, `mailid`, `fromid`, `subject`, `mail`, `sb_status`, `sb_html_format`) VALUES (10, 10, '[email protected]', 'offline payment of advertisers', '<P align=left>Hi admin,<BR> this advertiser has selected offline payment mode for payment<BR>Details of user :<BR>Username : %username%<BR>Email : <FONT face=Arial size=2>%email%</FONT><BR>Password : %password%<BR>Payment method :Offline<BR>Amount : %payment%<BR><BR>Thanks</P>', 'yes', 'yes');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_member_feedback`
#
DROP TABLE IF EXISTS `sbclassified_member_feedback`;
CREATE TABLE `sbclassified_member_feedback` (
`id` bigint(20) NOT NULL auto_increment,
`fname` varchar(255) default NULL,
`lname` varchar(255) default NULL,
`email` varchar(255) default NULL,
`url` varchar(255) default NULL,
`title` varchar(255) default NULL,
`comment` longtext,
`uid` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_member_feedback`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_members`
#
DROP TABLE IF EXISTS `sbclassified_members`;
CREATE TABLE `sbclassified_members` (
`id` bigint(20) NOT NULL auto_increment,
`c_name` varchar(255) default NULL,
`add1` varchar(255) default NULL,
`add2` varchar(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(255) default NULL,
`zip` varchar(50) default NULL,
`country` varchar(255) default NULL,
`home_phone` varchar(50) default NULL,
`email` varchar(255) default NULL,
`username` varchar(255) default NULL,
`pwd` varchar(255) default NULL,
`fname` varchar(255) default NULL,
`lname` varchar(255) default NULL,
`work_phone` varchar(50) default NULL,
`logo_url` varchar(255) default NULL,
`store_title` varchar(255) default NULL,
`store_desc` longtext,
`small_logo` varchar(255) default NULL,
`premium_status` varchar(255) default 'no',
`suspended` varchar(255) default 'no',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_members`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_messages`
#
DROP TABLE IF EXISTS `sbclassified_messages`;
CREATE TABLE `sbclassified_messages` (
`id` bigint(20) NOT NULL auto_increment,
`fid` bigint(20) NOT NULL default '0',
`tid` bigint(20) NOT NULL default '0',
`subject` mediumtext NOT NULL,
`message` longtext NOT NULL,
`tempdate` timestamp(14) NOT NULL,
`onstamp` timestamp(14) NOT NULL,
`msg_read` varchar(10) NOT NULL default '',
`f_del` varchar(10) NOT NULL default '',
`t_del` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_messages`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_online`
#
DROP TABLE IF EXISTS `sbclassified_online`;
CREATE TABLE `sbclassified_online` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_ip` varchar(255) NOT NULL default '',
`sb_ontime` timestamp(14) NOT NULL,
`sb_uid` bigint(20) default '0',
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_online`
#
INSERT INTO `sbclassified_online` (`sb_id`, `sb_ip`, `sb_ontime`, `sb_uid`) VALUES (1, '127.0.0.1', 20041130172934, -1);
# --------------------------------------------------------
#
# Table structure for table `sbclassified_plans`
#
DROP TABLE IF EXISTS `sbclassified_plans`;
CREATE TABLE `sbclassified_plans` (
`id` bigint(20) NOT NULL auto_increment,
`credits` bigint(20) NOT NULL default '0',
`price` decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_plans`
#
INSERT INTO `sbclassified_plans` (`id`, `credits`, `price`) VALUES (10, 1000, '9.00');
INSERT INTO `sbclassified_plans` (`id`, `credits`, `price`) VALUES (7, 10000, '35.00');
INSERT INTO `sbclassified_plans` (`id`, `credits`, `price`) VALUES (6, 5000, '20.00');
INSERT INTO `sbclassified_plans` (`id`, `credits`, `price`) VALUES (9, 20000, '69.00');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_products`
#
DROP TABLE IF EXISTS `sbclassified_products`;
CREATE TABLE `sbclassified_products` (
`id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL default '0',
`product_name` varchar(255) default NULL,
`cid` bigint(20) default NULL,
`aucid` bigint(20) default NULL,
`auction_period` varchar(255) default NULL,
`featured` varchar(10) default NULL,
`approved` varchar(10) default NULL,
`tmpdate` timestamp(14) NOT NULL,
`date_submitted` timestamp(14) NOT NULL,
`product_desc` longtext,
`location` varchar(255) default NULL,
`no_of_views` bigint(20) default NULL,
`status` varchar(255) default NULL,
`winner` varchar(255) default NULL,
`bold` varchar(10) default NULL,
`highlight` varchar(10) default NULL,
`purchased_images` int(10) default '0',
`fp_featured` varchar(10) default NULL,
`gallery_featured` varchar(10) default NULL,
`paypal_id` varchar(255) default NULL,
`counter_id` bigint(20) default '0',
`buy_price` decimal(10,2) default '0.00',
`additional_info` longtext,
`state` varchar(255) default NULL,
`country` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_products`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_purchased`
#
DROP TABLE IF EXISTS `sbclassified_purchased`;
CREATE TABLE `sbclassified_purchased` (
`id` bigint(20) NOT NULL auto_increment,
`pid` bigint(20) default NULL,
`uid` bigint(20) default NULL,
`quantity` bigint(20) default NULL,
`date_submitted` timestamp(14) NOT NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_purchased`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_ratings`
#
DROP TABLE IF EXISTS `sbclassified_ratings`;
CREATE TABLE `sbclassified_ratings` (
`id` bigint(20) NOT NULL auto_increment,
`sid` bigint(20) default NULL,
`rating` int(11) default NULL,
`ip` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_ratings`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_styles`
#
DROP TABLE IF EXISTS `sbclassified_styles`;
CREATE TABLE `sbclassified_styles` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_title` varchar(255) default NULL,
`sb_page_bg` varchar(255) default NULL,
`sb_table_bg` varchar(255) default NULL,
`sb_inner_table_bg` varchar(255) default NULL,
`sb_seperator` varchar(255) default NULL,
`sb_title_bg` varchar(255) default NULL,
`sb_title_font_color` varchar(255) default NULL,
`sb_title_font` varchar(255) default NULL,
`sb_title_font_size` varchar(255) default NULL,
`sb_normal_font_color` varchar(255) default NULL,
`sb_normal_font` varchar(255) default NULL,
`sb_normal_font_size` varchar(255) default NULL,
`sb_normal_table_bg` varchar(255) default NULL,
`sb_link_font` varchar(255) default NULL,
`sb_link_font_color` varchar(255) default NULL,
`sb_link_font_size` varchar(255) default NULL,
`sb_side_title_bg` varchar(255) default NULL,
`sb_side_title_font` varchar(255) default NULL,
`sb_side_title_font_color` varchar(255) default NULL,
`sb_side_title_font_size` varchar(255) default NULL,
`sb_sub_title_bg` varchar(255) default NULL,
`sb_highlighted` varchar(255) default 'FFFFCC',
`sb_highlighted1` varchar(255) default 'FFFFDD',
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_styles`
#
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (4, 'Red', 'FFFFFF', 'FFFFFF', 'F5F5F5', 'FFA8A8', 'FFD5D5', '990000', 'Arial', '12', '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '990000', '12', 'C33100', NULL, 'FFFFFF', NULL, 'EEEEEE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (13, 'Australia Theme', '00BB00', 'FFFFFF', 'FFFFBB', 'FFCC00', '00BB00', '000000', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '006600', '12', 'FFCC00', NULL, '000000', NULL, 'FFFF99', 'FFCCCC', 'FFDDDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (14, 'Green', 'FFFFFF', 'F4FFFA', 'F0FDE8', '0E6900', '0E6900', 'FFFFFF', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F0FDE8', 'Arial, Helvetica, sans-serif', '0E6900', '12', '073E00', NULL, 'FFFFFF', NULL, 'E7FCDA', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (15, 'Gray - Black', 'FFFFFF', 'FAFAFA', 'F5F5F5', 'cccccc', '363636', 'ffffff', 'Arial, Helvetica, sans-serif', '12', '000000', 'Arial, Helvetica, sans-serif', '12', 'FAFAFA', 'Arial, Helvetica, sans-serif', '990000', '12', '333333', NULL, 'FFFFFF', NULL, 'EEEEEE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (16, 'Blue', 'ECF5FF', 'FFFFFF', 'F5F5F5', '0078CC', '3C9DFF', 'FFFFFF', 'Courier New, Courier, mono', '18', '333333', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '0023CD', '12', '0068C3', NULL, 'FFFFFF', NULL, 'EEEEEE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (17, 'Blue Red', 'FFFFFF', 'FFFFFF', 'F5F5F5', 'CCCCCC', 'CF411D', 'FFFFFF', NULL, NULL, '333333', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '00509F', '12', '004080', NULL, 'FFFFFF', NULL, 'EEEEEE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (18, 'Yellow (Default)', 'FEFBEB', 'FEFBEB', 'FDF0D9', 'CC9933', 'E0AE2C', 'FFFFFF', NULL, NULL, '6B4418', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '004080', '12', '9B0000', NULL, 'FFFFFF', NULL, 'FCE7BE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (19, 'Canada,Dames,Swiss', 'FFF4F4', 'FFFFFF', 'FFF4F4', 'CE1D27', 'CE1D27', 'FFFFFF', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', 'CE1D27', '12', 'CE1D27', NULL, 'FFFFFF', NULL, 'FCEBEC', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (20, 'Germany Theme', 'EBAE18', 'FFFFFF', 'F5F5F5', 'CC2225', 'CC2225', 'FFFFFF', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', 'CC2225', '12', '000000', NULL, 'FFFFFF', NULL, 'EEEEEE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (21, 'US Theme', '1C237D', 'FFFFFF', 'E7E8FA', 'CE1D27', 'CE1D27', 'FFFFFF', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', 'CE1D27', '12', 'CE1D27', NULL, 'FFFFFF', NULL, 'CACCF4', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (22, 'UK Theme', 'FE0000', 'FFFFFF', 'FFF0F0', '0B4199', '0000D9', 'FFFFFF', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '0B4199', '12', '0000D9', NULL, 'FFFFFF', NULL, 'FFDFDF', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (23, 'Netherlands Theme', 'FFFFFF', 'FFFFFF', 'FFF3E8', 'FF8306', 'FF6D0D', 'FFFFFF', 'Arial', '12', '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', 'F0400D', '12', 'FF6D0D', NULL, 'FFFFFF', NULL, 'FFE7CE', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (24, 'Sweden Theme', '00009B', 'FEFCED', 'FDF9D9', 'EBCE10', 'EBCE10', '000000', NULL, NULL, '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '00009B', '12', 'EBCE10', NULL, '000000', NULL, 'FCF7C9', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (25, 'New Zealand Theme', 'FFFFFF', 'F5F5F5', 'E5E5E5', 'BBBBBB', '000000', 'FAFAFA', 'Arial, Helvetica, sans-serif', '12', '000000', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '990000', '12', '000000', NULL, 'FAFAFA', NULL, 'DDDDDD', 'FFFFCC', 'FFFFDD');
INSERT INTO `sbclassified_styles` (`sb_id`, `sb_title`, `sb_page_bg`, `sb_table_bg`, `sb_inner_table_bg`, `sb_seperator`, `sb_title_bg`, `sb_title_font_color`, `sb_title_font`, `sb_title_font_size`, `sb_normal_font_color`, `sb_normal_font`, `sb_normal_font_size`, `sb_normal_table_bg`, `sb_link_font`, `sb_link_font_color`, `sb_link_font_size`, `sb_side_title_bg`, `sb_side_title_font`, `sb_side_title_font_color`, `sb_side_title_font_size`, `sb_sub_title_bg`, `sb_highlighted`, `sb_highlighted1`) VALUES (26, 'France Theme', 'F2F7FF', 'FFFFFF', 'F2F7FF', '0078CC', '0236AE', 'FFFFFF', 'Courier New, Courier, mono', '18', '333333', 'Arial, Helvetica, sans-serif', '12', 'F5F5F5', 'Arial, Helvetica, sans-serif', '0023CD', '12', '0236AE', NULL, 'FFFFFF', NULL, 'DFE9FF', 'FFFFCC', 'FFFFDD');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_timeformats`
#
DROP TABLE IF EXISTS `sbclassified_timeformats`;
CREATE TABLE `sbclassified_timeformats` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_format` varchar(255) default NULL,
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_timeformats`
#
INSERT INTO `sbclassified_timeformats` (`sb_id`, `sb_format`) VALUES (1, '06:20 pm');
INSERT INTO `sbclassified_timeformats` (`sb_id`, `sb_format`) VALUES (2, '06:20 PM');
INSERT INTO `sbclassified_timeformats` (`sb_id`, `sb_format`) VALUES (3, '18:20');
# --------------------------------------------------------
#
# Table structure for table `sbclassified_transactions`
#
DROP TABLE IF EXISTS `sbclassified_transactions`;
CREATE TABLE `sbclassified_transactions` (
`id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) default NULL,
`amount` decimal(10,2) default NULL,
`date_submitted` timestamp(14) NOT NULL,
`description` longtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_transactions`
#
# --------------------------------------------------------
#
# Table structure for table `sbclassified_us_states`
#
DROP TABLE IF EXISTS `sbclassified_us_states`;
CREATE TABLE `sbclassified_us_states` (
`sb_id` bigint(20) NOT NULL auto_increment,
`sb_state` varchar(255) default NULL,
PRIMARY KEY (`sb_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbclassified_us_states`
#
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (1, 'Alabama');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (2, 'Alaska');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (3, 'Arizona');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (4, 'Arkansas');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (5, 'California');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (6, 'Colorado');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (7, 'Connecticut');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (8, 'Delaware');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (9, 'Florida');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (10, 'Georgia');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (11, 'Hawaii');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (12, 'Idaho');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (13, 'Illinois');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (14, 'Indiana');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (15, 'Iowa');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (16, 'Kansas');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (17, 'Kentucky');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (18, 'Louisiana');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (19, 'Maine');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (20, 'Maryland');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (21, 'Massachusetts');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (22, 'Michigan');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (23, 'Minnesota');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (24, 'Mississippi');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (25, 'Missouri');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (26, 'Montana');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (27, 'Nebraska');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (28, 'Nevada');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (29, 'New Hampshire');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (30, 'New Jersey');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (31, 'New Mexico');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (32, 'New York');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (33, 'North Carolina');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (34, 'North Dakota');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (35, 'Ohio');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (36, 'Oklahoma');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (37, 'Oregon');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (38, 'Pennsylvania');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (39, 'Rhode Island');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (40, 'South Carolina');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (41, 'South Dakota');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (42, 'Tennessee');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (43, 'Texas');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (44, 'Utah');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (45, 'Vermont');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (46, 'Virginia');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (47, 'Washington');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (48, 'Washington DC');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (49, 'West Virginia');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (50, 'Wisconsin');
INSERT INTO `sbclassified_us_states` (`sb_id`, `sb_state`) VALUES (51, 'Wyoming');
# --------------------------------------------------------
#
# Table structure for table `sbprj_ads`
#
DROP TABLE IF EXISTS `sbprj_ads`;
CREATE TABLE `sbprj_ads` (
`sbtitle` varchar(255) default NULL,
`id` bigint(20) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`bannerurl` varchar(255) NOT NULL default '',
`credits` bigint(20) NOT NULL default '0',
`displays` bigint(20) NOT NULL default '0',
`approved` varchar(255) NOT NULL default '',
`size_id` bigint(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbprj_ads`
#
# --------------------------------------------------------
#
# Table structure for table `sbprj_affiliate_banner`
#
DROP TABLE IF EXISTS `sbprj_affiliate_banner`;
CREATE TABLE `sbprj_affiliate_banner` (
`sbaff_id` bigint(20) NOT NULL auto_increment,
`sbaff_title` varchar(255) default NULL,
`sbaff_text` longtext,
`sbaff_active` varchar(255) NOT NULL default 'no',
`size_id` bigint(20) default NULL,
PRIMARY KEY (`sbaff_id`)
) TYPE=MyISAM;
#
# Dumping data for table `sbprj_affiliate_banner`
#
ALTER TABLE `sbclassified_categories` ADD `sb_fee` DECIMAL( 10, 2 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `sbclassified_config` ADD `sb_same_fee` VARCHAR( 255 ) DEFAULT 'yes' NOT NULL ;
CREATE TABLE sbclassified_types_fields (
sb_id bigint(20) NOT NULL auto_increment,
sb_type_id bigint(20) NOT NULL default '-1',
sb_field_id bigint(20) NOT NULL default '-1',
PRIMARY KEY (sb_id)
);
ALTER TABLE `sbclassified_additional_fields` ADD `sb_common` VARCHAR( 255 ) DEFAULT 'no' NOT NULL ;
ALTER TABLE `sbclassified_config` ADD `sb_signup_verification` VARCHAR( 255 ) DEFAULT 'no' NOT NULL ;
CREATE TABLE sbclassified_signups(
sb_id bigint( 20 ) NOT NULL auto_increment,
sb_rnum varchar( 255 ) default '',
sb_email varchar( 255 ) default '',
sb_onstamp timestamp( 14 ) NOT NULL ,
PRIMARY KEY ( sb_id )
);
INSERT INTO sbclassified_mails VALUES (25, 25, '[email protected]', 'Email verification mail', 'Hi,\r\n<br>\r\n<br>Your link for proceeding the signup is given below, please follow the link to complete the registration process, Thanks for being part of the site\r\n\r\nEmail::%email%\r\nLink is %signup_url%\r\n\r\n\r\n<br>\r\n\r\n<br>\r\n<br>Regards,\r\n<br>Admin', 'yes', 'no');
ALTER TABLE `sbclassified_members` ADD `sbtemp` TIMESTAMP, ADD `sb_signup_on` TIMESTAMP;
