--
-- Host: 10.6.175.43    Database: bravendor416
-- ------------------------------------------------------


--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL auto_increment,
  `comment_id` bigint(20) unsigned NOT NULL default '0',
  `meta_key` varchar(255) default NULL,
  `meta_value` longtext,
  PRIMARY KEY  (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_commentmeta`
--


--
-- Table structure for table `wp_comments`
--

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,
  `comment_post_ID` bigint(20) unsigned NOT NULL default '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL default '',
  `comment_author_url` varchar(200) NOT NULL default '',
  `comment_author_IP` varchar(100) NOT NULL default '',
  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL default '0',
  `comment_approved` varchar(20) NOT NULL default '1',
  `comment_agent` varchar(255) NOT NULL default '',
  `comment_type` varchar(20) NOT NULL default '',
  `comment_parent` bigint(20) unsigned NOT NULL default '0',
  `user_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_comments`
--


--
-- Table structure for table `wp_links`
--

CREATE TABLE `wp_links` (
  `link_id` bigint(20) unsigned NOT NULL auto_increment,
  `link_url` varchar(255) NOT NULL default '',
  `link_name` varchar(255) NOT NULL default '',
  `link_image` varchar(255) NOT NULL default '',
  `link_target` varchar(25) NOT NULL default '',
  `link_description` varchar(255) NOT NULL default '',
  `link_visible` varchar(20) NOT NULL default 'Y',
  `link_owner` bigint(20) unsigned NOT NULL default '1',
  `link_rating` int(11) NOT NULL default '0',
  `link_updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `link_rel` varchar(255) NOT NULL default '',
  `link_notes` mediumtext NOT NULL,
  `link_rss` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_links`
--


--
-- Table structure for table `wp_options`
--

CREATE TABLE `wp_options` (
  `option_id` bigint(20) unsigned NOT NULL auto_increment,
  `option_name` varchar(64) NOT NULL default '',
  `option_value` longtext NOT NULL,
  `autoload` varchar(20) NOT NULL default 'yes',
  PRIMARY KEY  (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=393 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_options`
--



--
-- Table structure for table `wp_orderdata`
--

CREATE TABLE `wp_orderdata` (
  `autoid` mediumint(10) NOT NULL auto_increment,
  `cus_id` varchar(10) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `order_ip` varchar(100) NOT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL,
  `order_data` longtext NOT NULL,
  `order_items` longtext NOT NULL,
  `order_address` blob NOT NULL,
  `order_addressShip` blob NOT NULL,
  `order_country` varchar(150) NOT NULL,
  `order_email` varchar(255) NOT NULL,
  `order_total` varchar(10) NOT NULL,
  `order_subtotal` varchar(10) NOT NULL,
  `order_tax` varchar(10) NOT NULL,
  `order_coupon` varchar(10) NOT NULL,
  `order_couponcode` varchar(100) NOT NULL,
  `order_currencycode` varchar(10) NOT NULL,
  `order_shipping` varchar(10) NOT NULL,
  `order_status` int(1) NOT NULL default '0',
  `cus_name` varchar(100) NOT NULL,
  `payment_data` blob NOT NULL,
  PRIMARY KEY  (`autoid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_orderdata`
--


--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL auto_increment,
  `post_id` bigint(20) unsigned NOT NULL default '0',
  `meta_key` varchar(255) default NULL,
  `meta_value` longtext,
  PRIMARY KEY  (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=179 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_postmeta`
--

INSERT INTO `wp_postmeta` VALUES (125,23,'_wp_page_template','tpl-add.php'),(126,24,'_wp_page_template','tpl-messages.php'),(127,25,'_wp_page_template','tpl-edit.php'),(128,26,'_wp_page_template','tpl-articles.php'),(129,27,'_wp_page_template','tpl-contact.php'),(130,28,'_wp_page_template','tpl-myaccount.php'),(131,29,'_wp_page_template','tpl-callback.php'),(133,30,'bid','12'),(134,30,'url','http://www.premiumpress.com'),(135,30,'hits','0'),(136,30,'map_location','New York'),(137,30,'packageID','1'),(138,30,'featured','yes'),(140,31,'bid','9'),(141,31,'url','http://www.shopperpress.com'),(142,31,'hits','0'),(143,31,'map_location','New York'),(144,31,'packageID','1'),(145,31,'featured','yes'),(147,32,'bid','8'),(148,32,'url','http://www.directorypress.com'),(149,32,'hits','0'),(150,32,'map_location','New York'),(151,32,'packageID','1'),(152,32,'featured','yes'),(154,33,'bid','7'),(155,33,'url','http://www.couponpress.com'),(156,33,'hits','0'),(157,33,'map_location','New York'),(158,33,'packageID','1'),(159,33,'featured','no'),(161,34,'bid','6'),(162,34,'url','http://www.classifiedstheme.com'),(163,34,'hits','0'),(164,34,'map_location','New York'),(165,34,'packageID','1'),(166,34,'featured','no'),(178,30,'_edit_lock','1386134127:1'),(168,35,'bid','5'),(169,35,'url','http://www.markfail.com'),(170,35,'hits','0'),(171,35,'map_location','New York'),(172,35,'packageID','1'),(173,35,'featured','no'),(174,36,'type','article'),(175,36,'image','article.jpg'),(176,37,'type','article'),(177,37,'image','article.jpg');

--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL default '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL default '0',
  `term_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` VALUES (30,533,0),(30,553,0),(30,554,0),(30,555,0),(31,533,0),(31,553,0),(31,554,0),(31,555,0),(32,533,0),(32,553,0),(32,554,0),(32,555,0),(33,533,0),(33,553,0),(33,554,0),(33,555,0),(34,533,0),(34,553,0),(34,554,0),(34,555,0),(35,533,0),(35,553,0),(35,554,0),(35,555,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL auto_increment,
  `term_id` bigint(20) unsigned NOT NULL default '0',
  `taxonomy` varchar(32) NOT NULL default '',
  `description` longtext NOT NULL,
  `parent` bigint(20) unsigned NOT NULL default '0',
  `count` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=562 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` VALUES (529,529,'category','',0,0),(530,530,'category','',529,0),(531,531,'category','',529,0),(532,532,'category','',529,0),(533,533,'category','',0,6),(534,534,'category','',533,0),(535,535,'category','',533,0),(536,536,'category','',533,0),(537,537,'category','',0,0),(538,538,'category','',537,0),(539,539,'category','',537,0),(540,540,'category','',537,0),(541,541,'category','',0,0),(542,542,'category','',541,0),(543,543,'category','',541,0),(544,544,'category','',541,0),(545,545,'category','',0,0),(546,546,'category','',545,0),(547,547,'category','',545,0),(548,548,'category','',545,0),(549,549,'category','',0,0),(550,550,'category','',549,0),(551,551,'category','',549,0),(552,552,'category','',549,0),(553,553,'post_tag','',0,6),(554,554,'post_tag','',0,6),(555,555,'post_tag','',0,6),(556,556,'article','This is an example article category description',0,0),(557,557,'article','This is an example article category description',0,0),(558,558,'article','This is an example article category description',0,0),(559,559,'article','This is an example article category description',0,0),(560,560,'article','This is an example article category description',0,0),(561,561,'article','This is an example article category description',0,0);

--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `slug` varchar(200) NOT NULL default '',
  `term_group` bigint(10) NOT NULL default '0',
  PRIMARY KEY  (`term_id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=562 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` VALUES (529,'Automotive','automotive',0),(530,'Auto Accessories','auto-accessories',0),(531,'Engine Parts','engine-parts',0),(532,'Bearings','bearings',0),(533,'Business','business',0),(534,'Jobs','jobs',0),(535,'Real Estate','real-estate',0),(536,'Investing','investing',0),(537,'Fashion Products','fashion-products',0),(538,'Cosmetics','cosmetics',0),(539,'Bags','bags',0),(540,'Jewelry','jewelry',0),(541,'Home &amp; Garden','home-garden',0),(542,'Garden Products','garden-products',0),(543,'Wood Crafts','wood-crafts',0),(544,'Kitchen Ware','kitchen-ware',0),(545,'Building &amp; Construction','building-construction',0),(546,'Floorings','floorings',0),(547,'Bathroom Fittings','bathroom-fittings',0),(548,'Machinery','machinery',0),(549,'Medical &amp; Hospital','medical-hospital',0),(550,'Hospital Furniture','hospital-furniture',0),(551,'Medical Equipment','medical-equipment',0),(552,'Drugs &amp; Pharmaceuticals','drugs-pharmaceuticals',0),(553,'tag1','tag1',0),(554,'tag2','tag2',0),(555,'United Kingdom','united-kingdom',0),(556,'Sample Category 1','sample-category-1',0),(557,'Sample Category 2','sample-category-2',0),(558,'Sample Category 3','sample-category-3',0),(559,'Sample Category 4','sample-category-4',0),(560,'Sample Category 5','sample-category-5',0),(561,'Sample Category 6','sample-category-6',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL auto_increment,
  `user_id` bigint(20) unsigned NOT NULL default '0',
  `meta_key` varchar(255) default NULL,
  `meta_value` longtext,
  PRIMARY KEY  (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` VALUES (1,1,'first_name',''),(2,1,'last_name',''),(3,1,'nickname','admin'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'show_admin_bar_front','true'),(10,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(11,1,'wp_user_level','10'),(12,1,'dismissed_wp_pointers','wp330_toolbar,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link,wp350_media,wp360_revisions,wp360_locks'),(13,1,'show_welcome_panel','1'),(14,1,'wp_dashboard_quick_press_last_post_id','18'),(15,1,'last_login','2015-05-17 15:23:35'),(16,1,'last_ip','174.70.103.204');

--
-- Table structure for table `wp_wpbdp_fees`
--

CREATE TABLE `wp_wpbdp_fees` (
  `id` mediumint(9) NOT NULL auto_increment,
  `label` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL default '0.00',
  `days` smallint(5) unsigned NOT NULL default '0',
  `images` smallint(5) unsigned NOT NULL default '0',
  `categories` blob NOT NULL,
  `extra_data` blob,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpbdp_fees`
--


--
-- Table structure for table `wp_wpbdp_form_fields`
--

CREATE TABLE `wp_wpbdp_form_fields` (
  `id` mediumint(9) NOT NULL auto_increment,
  `label` varchar(255) NOT NULL,
  `description` varchar(255) default NULL,
  `field_type` varchar(100) NOT NULL,
  `association` varchar(100) NOT NULL,
  `validators` text,
  `weight` int(5) NOT NULL default '0',
  `display_flags` text,
  `field_data` blob,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpbdp_form_fields`
--

INSERT INTO `wp_wpbdp_form_fields` VALUES (1,'Business Name','','textfield','title','required',9,'excerpt,listing,search','a:0:{}'),(2,'Business Genre','','select','category','required',8,'excerpt,listing,search','a:1:{s:7:\"options\";a:0:{}}'),(3,'Short Business Description','','textarea','excerpt','',7,'excerpt,listing,search','a:0:{}'),(4,'Long Business Description','','textarea','content','required',6,'excerpt,listing,search','a:0:{}'),(5,'Business Website Address','','url','meta','url',5,'excerpt,listing,search','a:0:{}'),(6,'Business Phone Number','','textfield','meta','',4,'excerpt,listing,search','a:0:{}'),(7,'Business Fax','','textfield','meta','',3,'excerpt,listing,search','a:0:{}'),(8,'Business Contact Email','','textfield','meta','email,required',2,'excerpt,listing','a:0:{}'),(9,'Business Tags','','textfield','tags','',1,'excerpt,listing,search','a:0:{}');

--
-- Table structure for table `wp_wpbdp_listing_fees`
--

CREATE TABLE `wp_wpbdp_listing_fees` (
  `id` mediumint(9) NOT NULL auto_increment,
  `listing_id` mediumint(9) NOT NULL,
  `category_id` mediumint(9) NOT NULL,
  `fee` blob NOT NULL,
  `expires_on` timestamp NULL default NULL,
  `updated_on` timestamp NOT NULL default '0000-00-00 00:00:00',
  `charged` tinyint(1) NOT NULL default '0',
  `email_sent` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpbdp_listing_fees`
--

INSERT INTO `wp_wpbdp_listing_fees` VALUES (1,6,2,'a:7:{s:2:\"id\";i:0;s:5:\"label\";s:12:\"Free Listing\";s:6:\"amount\";d:0;s:6:\"images\";i:2;s:4:\"days\";i:365;s:10:\"categories\";a:2:{s:3:\"all\";b:1;s:10:\"categories\";a:0:{}}s:10:\"extra_data\";N;}','2014-11-12 08:56:12','0000-00-00 00:00:00',0,0),(2,7,3,'a:7:{s:2:\"id\";i:0;s:5:\"label\";s:12:\"Free Listing\";s:6:\"amount\";d:0;s:6:\"images\";i:2;s:4:\"days\";i:365;s:10:\"categories\";a:2:{s:3:\"all\";b:1;s:10:\"categories\";a:0:{}}s:10:\"extra_data\";N;}','2014-11-12 08:57:37','0000-00-00 00:00:00',0,0),(3,8,5,'a:7:{s:2:\"id\";i:0;s:5:\"label\";s:12:\"Free Listing\";s:6:\"amount\";d:0;s:6:\"images\";i:2;s:4:\"days\";i:365;s:10:\"categories\";a:2:{s:3:\"all\";b:1;s:10:\"categories\";a:0:{}}s:10:\"extra_data\";N;}','2014-11-12 08:58:21','0000-00-00 00:00:00',0,0),(4,9,5,'a:7:{s:2:\"id\";i:0;s:5:\"label\";s:12:\"Free Listing\";s:6:\"amount\";d:0;s:6:\"images\";i:2;s:4:\"days\";i:365;s:10:\"categories\";a:2:{s:3:\"all\";b:1;s:10:\"categories\";a:0:{}}s:10:\"extra_data\";N;}','2014-11-12 08:59:17','0000-00-00 00:00:00',0,0),(5,10,4,'a:7:{s:2:\"id\";i:0;s:5:\"label\";s:12:\"Free Listing\";s:6:\"amount\";d:0;s:6:\"images\";i:2;s:4:\"days\";i:365;s:10:\"categories\";a:2:{s:3:\"all\";b:1;s:10:\"categories\";a:0:{}}s:10:\"extra_data\";N;}','2014-11-12 09:00:07','0000-00-00 00:00:00',0,0);

--
-- Table structure for table `wp_wpbdp_payments`
--

CREATE TABLE `wp_wpbdp_payments` (
  `id` mediumint(9) NOT NULL auto_increment,
  `listing_id` mediumint(9) NOT NULL,
  `gateway` varchar(255) default NULL,
  `amount` decimal(10,2) NOT NULL default '0.00',
  `payment_type` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `processed_on` timestamp NULL default NULL,
  `processed_by` varchar(255) NOT NULL default 'gateway',
  `payerinfo` blob,
  `extra_data` blob,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpbdp_payments`
--

INSERT INTO `wp_wpbdp_payments` VALUES (1,6,NULL,0.00,'initial','approved','2013-11-12 08:55:22','2013-11-12 08:55:22','admin',NULL,NULL),(2,7,NULL,0.00,'initial','approved','2013-11-12 08:57:37','2013-11-12 08:57:37','admin',NULL,NULL),(3,8,NULL,0.00,'initial','approved','2013-11-12 08:58:21','2013-11-12 08:58:21','admin',NULL,NULL),(4,9,NULL,0.00,'initial','approved','2013-11-12 08:59:17','2013-11-12 08:59:17','admin',NULL,NULL),(5,10,NULL,0.00,'initial','approved','2013-11-12 09:00:07','2013-11-12 09:00:07','admin',NULL,NULL);


