--
-- Host: localhost    Database: tcddbase
-- ------------------------------------------------------


--
-- Table structure for table `wp_cn_social_icon`
--

CREATE TABLE `wp_cn_social_icon` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `sortorder` int(11) NOT NULL DEFAULT '0',
  `date_upload` varchar(100) DEFAULT NULL,
  `target` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp_cn_social_icon`
--

INSERT INTO `wp_cn_social_icon` VALUES (1,'facebook','https://www.facebook.com/tavis.bradley.9','1379957991_facebook.png',4,'1381392403',1),(2,'twitter','https://twitter.com/TavisBradley','1379958049_twitter.png',3,'1381392433',1),(4,'linkedin','http://www.linkedin.com/profile/view?id=238291217&authType=NAME_SEARCH&authToken=b6LX&locale=en_US&srchid=7193381381355620487&srchindex=1&srchtotal=10&trk=vsrp_people_res_name&trkInfo=VSRPsearchId%3A7193381381355620487%2CVSRPtargetId%3A238291217%2CVSRPcmp','1379958108_linkin.png',2,'1381392464',1),(5,'youtube','http://www.youtube.com/channel/UCiefj04X7IL3mygtMz_sjHA','1379957939_youtube.png',1,'1381392490',1);

--
-- 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=InnoDB 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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_comments` VALUES (1,1,'Mr WordPress','','http://wordpress.org/','','2013-07-25 23:20:07','2013-07-25 23:20:07','Hi, this is a comment.\nTo delete a comment, just log in and view the post&#039;s comments. There you will have the option to edit or delete them.',0,'0','','',0,0);

--
-- Table structure for table `wp_events_rec`
--

CREATE TABLE `wp_events_rec` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `text` varchar(255) NOT NULL,
  `rec_type` varchar(64) NOT NULL,
  `event_pid` int(11) NOT NULL,
  `event_length` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `lat` float(10,6) DEFAULT NULL,
  `lng` float(10,6) DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_events_rec`
--

INSERT INTO `wp_events_rec` VALUES (1,'2013-12-03 12:36:06','2013-12-03 12:41:06','The Scheduler Calendar was installed!','',0,0,0,NULL,NULL);

--
-- 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=InnoDB 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=InnoDB AUTO_INCREMENT=3588 DEFAULT CHARSET=utf8;

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



--
-- 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=InnoDB AUTO_INCREMENT=275 DEFAULT CHARSET=utf8;

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



--
-- Table structure for table `wp_sfauthcats`
--

CREATE TABLE `wp_sfauthcats` (
  `authcat_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `authcat_name` varchar(50) NOT NULL,
  `authcat_slug` varchar(50) NOT NULL,
  `authcat_desc` tinytext,
  PRIMARY KEY (`authcat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfauthcats`
--

INSERT INTO `wp_sfauthcats` VALUES (1,'General','general','auth category for general auths'),(2,'Viewing','viewing','auth category for viewing auths'),(3,'Creating','creating','auth category for creating auths'),(4,'Editing','editing','auth category for editing auths'),(5,'Deleting','deleting','auth category for deleting auths'),(6,'Moderation','moderation','auth category for moderation auths'),(7,'Tools','tools','auth category for tools auths'),(8,'Uploading','uploading','auth category for uploading auths');

--
-- Table structure for table `wp_sfauths`
--

CREATE TABLE `wp_sfauths` (
  `auth_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `auth_name` varchar(50) NOT NULL,
  `auth_desc` text,
  `active` smallint(1) NOT NULL DEFAULT '0',
  `ignored` smallint(1) NOT NULL DEFAULT '0',
  `enabling` smallint(1) NOT NULL DEFAULT '0',
  `admin_negate` smallint(1) NOT NULL DEFAULT '0',
  `auth_cat` bigint(20) NOT NULL DEFAULT '1',
  `warning` tinytext,
  PRIMARY KEY (`auth_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfauths`
--

INSERT INTO `wp_sfauths` VALUES (1,'view_forum','Can view a forum',1,0,0,0,2,NULL),(2,'view_forum_lists','Can view a list of forums only',1,0,0,0,2,NULL),(3,'view_forum_topic_lists','Can view a list of forums and list of topics only',1,0,0,0,2,NULL),(4,'view_admin_posts','Can view posts by an administrator',1,0,0,0,2,NULL),(5,'view_own_admin_posts','Can view only own posts and admin/mod posts',1,0,0,1,2,NULL),(6,'start_topics','Can start new topics in a forum',1,0,0,0,3,NULL),(7,'reply_topics','Can reply to existing topics in a forum',1,0,0,0,3,NULL),(8,'reply_own_topics','Can only reply to own topics',1,0,0,1,3,NULL),(9,'edit_own_topic_titles','Can edit own topic titles',1,0,0,0,4,NULL),(10,'edit_any_topic_titles','Can edit any topic title',1,0,0,0,4,NULL),(11,'pin_topics','Can pin topics in a forum',1,0,0,0,7,NULL),(12,'move_topics','Can move topics from a forum',1,0,0,0,7,NULL),(13,'move_posts','Can move posts from a topic',1,0,0,0,7,NULL),(14,'lock_topics','Can lock topics in a forum',1,0,0,0,7,NULL),(15,'delete_topics','Can delete topics in forum',1,0,0,0,5,NULL),(16,'edit_own_posts_forever','Can edit own posts forever',1,0,0,0,4,NULL),(17,'edit_own_posts_reply','Can edit own posts until there has been a reply',1,0,0,0,4,NULL),(18,'edit_any_post','Can edit any post',1,0,0,0,4,NULL),(19,'delete_own_posts','Can delete own posts',1,0,0,0,5,NULL),(20,'delete_any_post','Can delete any post',1,0,0,0,5,NULL),(21,'pin_posts','Can pin posts within a topic',1,0,0,0,7,NULL),(22,'reassign_posts','Can reassign posts to a different user',1,0,0,0,7,NULL),(23,'view_email','Can view email and IP addresses of members',1,0,0,0,2,NULL),(24,'view_profiles','Can view profiles of members',1,0,0,0,2,NULL),(25,'view_members_list','Can view the members lists',1,0,0,0,2,NULL),(26,'bypass_math_question','Can bypass the math question',1,0,0,0,6,NULL),(27,'bypass_moderation','Can bypass all post moderation',1,0,0,0,6,NULL),(28,'bypass_moderation_once','Can bypass first post moderation',1,0,0,0,6,NULL),(29,'moderate_posts','Can moderate pending posts',1,0,0,0,6,NULL),(30,'use_spoilers','Can use spoilers in posts',1,0,0,0,3,NULL),(31,'view_links','Can view links within posts',1,0,0,0,2,NULL),(32,'use_signatures','Can attach a signature to posts',1,1,0,0,3,NULL),(33,'upload_avatars','Can upload avatars',1,1,1,0,8,NULL),(34,'create_links','Can create links in posts',1,0,0,0,3,NULL),(35,'can_use_smileys','Can use smileys in posts',1,0,0,0,3,NULL),(36,'can_use_iframes','Can use iframes in posts',1,0,0,0,3,NULL);

--
-- Table structure for table `wp_sfdefpermissions`
--

CREATE TABLE `wp_sfdefpermissions` (
  `permission_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) NOT NULL DEFAULT '0',
  `usergroup_id` bigint(20) NOT NULL DEFAULT '0',
  `permission_role` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `group_idx` (`group_id`),
  KEY `usergroup_idx` (`usergroup_id`),
  KEY `perm_role_idx` (`permission_role`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfdefpermissions`
--

INSERT INTO `wp_sfdefpermissions` VALUES (1,1,1,2),(2,1,2,4),(3,1,3,2);

--
-- Table structure for table `wp_sferrorlog`
--

CREATE TABLE `wp_sferrorlog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `error_date` datetime NOT NULL,
  `error_type` varchar(10) NOT NULL,
  `error_text` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sferrorlog`
--

INSERT INTO `wp_sferrorlog` VALUES (1,'2013-10-04 20:36:19','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: closedir<br />Warning | closedir() expects parameter 1 to be resource, null given'),(2,'2013-10-04 20:36:19','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: Unavailable<br />Warning | closedir() expects parameter 1 to be resource, null given'),(3,'2013-10-08 21:40:46','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: closedir<br />Warning | closedir() expects parameter 1 to be resource, null given'),(4,'2013-10-08 21:40:47','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: Unavailable<br />Warning | closedir() expects parameter 1 to be resource, null given'),(5,'2013-12-04 22:20:27','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: closedir<br />Warning | closedir() expects parameter 1 to be resource, null given'),(6,'2013-12-04 22:20:28','php','file: /simple-press/sp-api/sp-api-plugins.php<br />line: 82<br />function: Unavailable<br />Warning | closedir() expects parameter 1 to be resource, null given');

--
-- Table structure for table `wp_sfforums`
--

CREATE TABLE `wp_sfforums` (
  `forum_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `forum_name` varchar(200) NOT NULL,
  `group_id` bigint(20) NOT NULL,
  `forum_seq` int(4) DEFAULT NULL,
  `forum_desc` text,
  `forum_status` int(4) NOT NULL DEFAULT '0',
  `forum_disabled` smallint(1) NOT NULL DEFAULT '0',
  `forum_slug` varchar(200) NOT NULL,
  `forum_rss` text,
  `forum_icon` varchar(50) DEFAULT NULL,
  `forum_icon_new` varchar(50) DEFAULT NULL,
  `topic_icon` varchar(50) DEFAULT NULL,
  `topic_icon_new` varchar(50) DEFAULT NULL,
  `post_id` bigint(20) DEFAULT NULL,
  `post_id_held` bigint(20) DEFAULT NULL,
  `topic_count` mediumint(8) DEFAULT '0',
  `post_count` mediumint(8) DEFAULT '0',
  `post_count_held` mediumint(8) DEFAULT '0',
  `forum_rss_private` smallint(1) NOT NULL DEFAULT '0',
  `parent` bigint(20) NOT NULL DEFAULT '0',
  `children` text,
  `forum_message` text,
  `keywords` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`forum_id`),
  KEY `groupf_idx` (`group_id`),
  KEY `fslug_idx` (`forum_slug`),
  KEY `post_idx` (`post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfforums`
--

INSERT INTO `wp_sfforums` VALUES (1,'Inspiring a life of Deep Stillness and True Energy',1,1,'Inspiring a life of Deep Stillness and True Energy',0,0,'inspiring-a-life-of-deep-stillness-and-true-energy',NULL,'','','','',NULL,NULL,0,0,0,0,0,'','','');

--
-- Table structure for table `wp_sfgroups`
--

CREATE TABLE `wp_sfgroups` (
  `group_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_name` text,
  `group_seq` int(4) DEFAULT NULL,
  `group_desc` text,
  `group_rss` text,
  `group_icon` varchar(50) DEFAULT NULL,
  `group_message` text,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfgroups`
--

INSERT INTO `wp_sfgroups` VALUES (1,'Diet',1,'Diet sample description',NULL,'','');

--
-- Table structure for table `wp_sflog`
--

CREATE TABLE `wp_sflog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `install_date` date NOT NULL,
  `release_type` varchar(20) DEFAULT NULL,
  `version` varchar(10) NOT NULL,
  `build` int(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_idx` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sflog`
--

INSERT INTO `wp_sflog` VALUES (1,1,'2013-09-27','Release','5.3.1',10616);

--
-- Table structure for table `wp_sflogmeta`
--

CREATE TABLE `wp_sflogmeta` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(10) DEFAULT NULL,
  `log_data` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sflogmeta`
--


--
-- Table structure for table `wp_sfmembers`
--

CREATE TABLE `wp_sfmembers` (
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `display_name` varchar(100) DEFAULT NULL,
  `moderator` smallint(1) NOT NULL DEFAULT '0',
  `avatar` longtext,
  `signature` text,
  `posts` int(4) DEFAULT NULL,
  `lastvisit` datetime DEFAULT NULL,
  `newposts` longtext,
  `checktime` datetime DEFAULT NULL,
  `admin` smallint(1) NOT NULL DEFAULT '0',
  `feedkey` varchar(36) DEFAULT NULL,
  `admin_options` longtext,
  `user_options` longtext,
  `auths` longtext,
  `memberships` longtext,
  `special_ranks` text,
  PRIMARY KEY (`user_id`),
  KEY `admin_idx` (`admin`),
  KEY `moderator_idx` (`moderator`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfmembers`
--

INSERT INTO `wp_sfmembers` VALUES (1,'admin',0,'a:1:{s:8:\"uploaded\";s:0:\"\";}','',0,'2013-11-26 04:46:32','','2013-09-27 05:05:05',1,'21db72db-5f50-43d5-8df6-b6a0062ab81f','a:3:{s:8:\"sfnotify\";b:0;s:15:\"sfstatusmsgtext\";s:0:\"\";s:13:\"notify-edited\";b:1;}','a:6:{s:10:\"hidestatus\";i:0;s:8:\"timezone\";i:0;s:15:\"timezone_string\";s:3:\"UTC\";s:6:\"editor\";i:1;s:8:\"namesync\";i:1;s:11:\"unreadposts\";i:50;}','a:2:{i:1;a:36:{i:1;i:1;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:1;i:10;i:1;i:11;i:1;i:12;i:1;i:13;i:1;i:14;i:1;i:15;i:1;i:16;i:1;i:17;i:1;i:18;i:1;i:19;i:1;i:20;i:1;i:21;i:1;i:22;i:1;i:23;i:1;i:24;i:1;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:29;i:1;i:30;i:1;i:31;i:1;i:32;i:1;i:33;i:1;i:34;i:1;i:35;i:1;i:36;i:1;}s:6:\"global\";a:36:{i:1;i:1;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:1;i:10;i:1;i:11;i:1;i:12;i:1;i:13;i:1;i:14;i:1;i:15;i:1;i:16;i:1;i:17;i:1;i:18;i:1;i:19;i:1;i:20;i:1;i:21;i:1;i:22;i:1;i:23;i:1;i:24;i:1;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:29;i:1;i:30;i:1;i:31;i:1;i:32;i:1;i:33;i:1;i:34;i:1;i:35;i:1;i:36;i:1;}}','',NULL),(2,'techd',0,'a:1:{s:8:\"uploaded\";s:0:\"\";}','',-1,'2013-09-27 05:05:05','','2013-09-27 05:05:05',0,'839e064c-12e4-4f77-aa73-7cb8e9bb5379','','a:6:{s:10:\"hidestatus\";i:0;s:8:\"timezone\";i:0;s:15:\"timezone_string\";s:3:\"UTC\";s:6:\"editor\";i:1;s:8:\"namesync\";i:1;s:11:\"unreadposts\";i:50;}','a:2:{s:6:\"global\";a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:1;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:1;i:25;i:1;i:26;i:0;i:27;i:1;i:28;i:1;i:32;i:1;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:1;}i:1;a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:1;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:1;i:25;i:1;i:26;i:0;i:27;i:1;i:28;i:1;i:32;i:1;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:1;}}','a:1:{i:0;a:5:{s:12:\"usergroup_id\";s:1:\"2\";s:14:\"usergroup_name\";s:7:\"Members\";s:14:\"usergroup_desc\";s:51:\"Default Usergroup for registered users of the forum\";s:15:\"usergroup_badge\";s:0:\"\";s:14:\"usergroup_join\";s:1:\"0\";}}',NULL);

--
-- Table structure for table `wp_sfmemberships`
--

CREATE TABLE `wp_sfmemberships` (
  `membership_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `usergroup_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`membership_id`),
  KEY `user_idx` (`user_id`),
  KEY `usergroup_idx` (`usergroup_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfmemberships`
--

INSERT INTO `wp_sfmemberships` VALUES (2,2,2);

--
-- Table structure for table `wp_sfmeta`
--

CREATE TABLE `wp_sfmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `meta_type` varchar(20) NOT NULL,
  `meta_key` varchar(100) DEFAULT NULL,
  `meta_value` longtext,
  `autoload` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`meta_id`),
  KEY `meta_type_idx` (`meta_type`),
  KEY `autoload_idx` (`autoload`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfmeta`
--

INSERT INTO `wp_sfmeta` VALUES (1,'default usergroup','sfguests','1',0),(2,'default usergroup','sfmembers','2',0),(3,'default usergroup','administrator','2',0),(4,'default usergroup','editor','2',0),(5,'default usergroup','author','2',0),(6,'default usergroup','contributor','2',0),(7,'default usergroup','subscriber','2',0),(8,'default usergroup','backwpup_admin','2',0),(9,'default usergroup','backwpup_check','2',0),(10,'default usergroup','backwpup_helper','2',0),(11,'default usergroup','customer','2',0),(12,'default usergroup','shop_manager','2',0),(13,'forum_rank','New Member','a:3:{s:5:\"posts\";i:2;s:9:\"usergroup\";s:4:\"none\";s:5:\"image\";s:4:\"none\";}',1),(14,'forum_rank','Member','a:3:{s:5:\"posts\";i:1000;s:9:\"usergroup\";s:4:\"none\";s:5:\"image\";s:4:\"none\";}',1),(15,'sort_order','forum','',1),(16,'sort_order','topic','',1),(17,'autoupdate','user','a:2:{i:0;s:13:\"spjUserUpdate\";i:1;s:93:\"http://theconductivitydiet.primaryhub.com/index.php?sp_ahah=autoupdate&amp;sfnonce=dc900c359f\";}',0),(18,'smileys','smileys','a:11:{s:8:\"Confused\";a:5:{i:0;s:15:\"sf-confused.gif\";i:1;s:5:\":???:\";i:2;i:1;i:3;i:0;i:4;i:0;}s:4:\"Cool\";a:5:{i:0;s:11:\"sf-cool.gif\";i:1;s:6:\":cool:\";i:2;i:1;i:3;i:1;i:4;i:0;}s:3:\"Cry\";a:5:{i:0;s:10:\"sf-cry.gif\";i:1;s:5:\":cry:\";i:2;i:1;i:3;i:2;i:4;i:0;}s:10:\"Embarassed\";a:5:{i:0;s:17:\"sf-embarassed.gif\";i:1;s:6:\":oops:\";i:2;i:1;i:3;i:3;i:4;i:0;}s:5:\"Frown\";a:5:{i:0;s:12:\"sf-frown.gif\";i:1;s:7:\":frown:\";i:2;i:1;i:3;i:4;i:4;i:0;}s:4:\"Kiss\";a:5:{i:0;s:11:\"sf-kiss.gif\";i:1;s:6:\":kiss:\";i:2;i:1;i:3;i:5;i:4;i:0;}s:5:\"Laugh\";a:5:{i:0;s:12:\"sf-laugh.gif\";i:1;s:5:\":lol:\";i:2;i:1;i:3;i:6;i:4;i:0;}s:5:\"Smile\";a:5:{i:0;s:12:\"sf-smile.gif\";i:1;s:7:\":smile:\";i:2;i:1;i:3;i:7;i:4;i:0;}s:9:\"Surprised\";a:5:{i:0;s:16:\"sf-surprised.gif\";i:1;s:5:\":eek:\";i:2;i:1;i:3;i:8;i:4;i:0;}s:4:\"Wink\";a:5:{i:0;s:11:\"sf-wink.gif\";i:1;s:6:\":wink:\";i:2;i:1;i:3;i:9;i:4;i:0;}s:4:\"Yell\";a:5:{i:0;s:11:\"sf-yell.gif\";i:1;s:6:\":yell:\";i:2;i:1;i:3;i:10;i:4;i:0;}}',1),(19,'profile','tabs','a:4:{i:0;a:5:{s:4:\"name\";s:7:\"Profile\";s:4:\"slug\";s:7:\"profile\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";s:5:\"menus\";a:7:{i:0;a:5:{s:4:\"name\";s:8:\"Overview\";s:4:\"slug\";s:8:\"overview\";s:4:\"form\";s:116:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-overview.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:1;a:5:{s:4:\"name\";s:12:\"Edit Profile\";s:4:\"slug\";s:12:\"edit-profile\";s:4:\"form\";s:115:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-profile.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:2;a:5:{s:4:\"name\";s:15:\"Edit Identities\";s:4:\"slug\";s:15:\"edit-identities\";s:4:\"form\";s:118:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-identities.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:3;a:5:{s:4:\"name\";s:11:\"Edit Avatar\";s:4:\"slug\";s:11:\"edit-avatar\";s:4:\"form\";s:114:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-avatar.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:4;a:5:{s:4:\"name\";s:14:\"Edit Signature\";s:4:\"slug\";s:14:\"edit-signature\";s:4:\"form\";s:117:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-signature.php\";s:7:\"display\";i:1;s:4:\"auth\";s:14:\"use_signatures\";}i:5;a:5:{s:4:\"name\";s:11:\"Edit Photos\";s:4:\"slug\";s:11:\"edit-photos\";s:4:\"form\";s:114:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-photos.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:6;a:5:{s:4:\"name\";s:16:\"Account Settings\";s:4:\"slug\";s:16:\"account-settings\";s:4:\"form\";s:115:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-account.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}}}i:1;a:5:{s:4:\"name\";s:7:\"Options\";s:4:\"slug\";s:7:\"options\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";s:5:\"menus\";a:3:{i:0;a:5:{s:4:\"name\";s:19:\"Edit Global Options\";s:4:\"slug\";s:19:\"edit-global-options\";s:4:\"form\";s:122:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-global-options.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:1;a:5:{s:4:\"name\";s:20:\"Edit Posting Options\";s:4:\"slug\";s:20:\"edit-posting-options\";s:4:\"form\";s:123:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-posting-options.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}i:2;a:5:{s:4:\"name\";s:20:\"Edit Display Options\";s:4:\"slug\";s:20:\"edit-display-options\";s:4:\"form\";s:123:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-display-options.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}}}i:2;a:5:{s:4:\"name\";s:10:\"Usergroups\";s:4:\"slug\";s:10:\"usergroups\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";s:5:\"menus\";a:1:{i:0;a:5:{s:4:\"name\";s:16:\"Show Memberships\";s:4:\"slug\";s:16:\"show-memberships\";s:4:\"form\";s:119:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-memberships.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}}}i:3;a:5:{s:4:\"name\";s:11:\"Permissions\";s:4:\"slug\";s:11:\"permissions\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";s:5:\"menus\";a:1:{i:0;a:5:{s:4:\"name\";s:16:\"Show Permissions\";s:4:\"slug\";s:16:\"show-permissions\";s:4:\"form\";s:119:\"/var/www/sites/theconductivitydiet.com/root/wp-content/plugins/simple-press/forum/profile/forms/sp-form-permissions.php\";s:7:\"display\";i:1;s:4:\"auth\";s:0:\"\";}}}}',0),(20,'news','news','a:3:{s:2:\"id\";s:2:\"13\";s:4:\"show\";i:1;s:4:\"news\";s:572:\"\n        \n        <h4><b>Announcing Release of a New Plugin</b></h4>\n        <p>Now available to download - the following new plugin is now released and available for use on your Simple:Press forum. Thd plugin does require Version 5.3.4 of Simple Press.</p>\n        <p><b>Warnings and Suspensions</b>: Allows for for warning, susupending and banning users</p>\n        <p>Just download, install, activate and add any necessary template display tags to your theme. Available on our Plugins Download Page:  http://simple-press.com/download-plugins/</a>.</p>\n        \n        \";}',0),(21,'mysql','search','a:2:{s:3:\"min\";s:1:\"4\";s:3:\"max\";s:2:\"84\";}',1);

--
-- Table structure for table `wp_sfnotices`
--

CREATE TABLE `wp_sfnotices` (
  `notice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `guest_email` varchar(50) DEFAULT NULL,
  `post_id` bigint(20) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `link_text` varchar(200) DEFAULT NULL,
  `message` varchar(255) NOT NULL DEFAULT '',
  `expires` int(4) DEFAULT NULL,
  PRIMARY KEY (`notice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfnotices`
--


--
-- Table structure for table `wp_sfoptions`
--

CREATE TABLE `wp_sfoptions` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(64) NOT NULL DEFAULT '',
  `option_value` longtext NOT NULL,
  PRIMARY KEY (`option_name`),
  KEY `option_id` (`option_id`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfoptions`
--

INSERT INTO `wp_sfoptions` VALUES (1,'installed_tables','a:20:{i:0;s:11:\"wp_sfforums\";i:1;s:11:\"wp_sfgroups\";i:2;s:12:\"wp_sfmembers\";i:3;s:12:\"wp_sfoptions\";i:4;s:16:\"wp_sfmemberships\";i:5;s:9:\"wp_sfmeta\";i:6;s:16:\"wp_sfpermissions\";i:7;s:19:\"wp_sfdefpermissions\";i:8;s:10:\"wp_sfposts\";i:9;s:10:\"wp_sfauths\";i:10;s:13:\"wp_sfauthcats\";i:11;s:10:\"wp_sfroles\";i:12;s:11:\"wp_sftopics\";i:13;s:10:\"wp_sftrack\";i:14;s:15:\"wp_sfusergroups\";i:15;s:12:\"wp_sfwaiting\";i:16;s:8:\"wp_sflog\";i:17;s:12:\"wp_sflogmeta\";i:18;s:13:\"wp_sferrorlog\";i:19;s:12:\"wp_sfnotices\";}'),(2,'sf_guest_auths','a:2:{s:6:\"global\";a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:0;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:0;i:25;i:0;i:26;i:0;i:27;i:0;i:28;i:0;i:32;i:0;i:33;i:0;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:0;}i:1;a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:0;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:0;i:25;i:0;i:26;i:0;i:27;i:0;i:28;i:0;i:32;i:0;i:33;i:0;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:0;}}'),(3,'sfslug','forum'),(4,'sfpage','34'),(5,'sfuninstall',''),(6,'sfdates','F j, Y'),(7,'sftimes','g:i a'),(8,'sfpermalink','http://theconductivitydiet.primaryhub.com/forum/'),(9,'sflockdown',''),(10,'sfimage','a:6:{s:7:\"enlarge\";b:1;s:7:\"process\";b:1;s:9:\"thumbsize\";i:100;s:5:\"style\";s:4:\"left\";s:9:\"constrain\";b:1;s:10:\"forceclear\";b:0;}'),(11,'sfbadwords',''),(12,'sfreplacementwords',''),(13,'sfeditormsg',''),(14,'sfmail','a:4:{s:12:\"sfmailsender\";s:21:\"The Conductivity Diet\";s:10:\"sfmailfrom\";s:6:\"mickey\";s:12:\"sfmaildomain\";s:14:\"primaryhub.com\";s:9:\"sfmailuse\";b:1;}'),(15,'sfnewusermail','a:3:{s:11:\"sfusespfreg\";b:1;s:16:\"sfnewusersubject\";s:21:\"Welcome to %BLOGNAME%\";s:13:\"sfnewusertext\";s:159:\"Welcome %USERNAME% to %BLOGNAME% %NEWLINE%Please find below your login details: %NEWLINE%Username: %USERNAME% %NEWLINE%Password: %PASSWORD% %NEWLINE%%LOGINURL%\";}'),(16,'sfpostmsg','a:3:{s:13:\"sfpostmsgtext\";s:0:\"\";s:14:\"sfpostmsgtopic\";b:0;s:13:\"sfpostmsgpost\";b:0;}'),(17,'sflogin','a:6:{s:9:\"sfregmath\";b:1;s:10:\"sfloginurl\";s:50:\"http://theconductivitydiet.primaryhub.com/forum-2/\";s:11:\"sflogouturl\";s:50:\"http://theconductivitydiet.primaryhub.com/forum-2/\";s:13:\"sfregisterurl\";s:0:\"\";s:15:\"sfloginemailurl\";s:54:\"http://theconductivitydiet.primaryhub.com/wp-login.php\";s:9:\"sptimeout\";i:20;}'),(18,'sfadminsettings','a:5:{s:16:\"sfdashboardstats\";b:1;s:14:\"sfadminapprove\";b:0;s:14:\"sfmoderapprove\";b:0;s:10:\"editnotice\";b:1;s:10:\"movenotice\";b:1;}'),(19,'sfauto','a:2:{s:12:\"sfautoupdate\";b:0;s:10:\"sfautotime\";i:300;}'),(20,'sffilters','a:9:{s:10:\"sfnofollow\";b:0;s:8:\"sftarget\";b:1;s:10:\"sfurlchars\";i:40;s:11:\"sffilterpre\";b:0;s:10:\"sfmaxlinks\";i:0;s:12:\"sfnolinksmsg\";s:55:\"<b>** you don\'t have permission to see this link **</b>\";s:12:\"sfdupemember\";i:0;s:11:\"sfdupeguest\";i:0;s:12:\"sfmaxsmileys\";i:0;}'),(21,'sfseo','a:8:{s:15:\"sfseo_overwrite\";b:0;s:14:\"sfseo_blogname\";b:0;s:14:\"sfseo_pagename\";b:0;s:11:\"sfseo_topic\";b:1;s:11:\"sfseo_forum\";b:1;s:13:\"sfseo_noforum\";b:0;s:10:\"sfseo_page\";b:1;s:9:\"sfseo_sep\";s:1:\"|\";}'),(22,'sfsigimagesize','a:2:{s:10:\"sfsigwidth\";i:0;s:11:\"sfsigheight\";i:0;}'),(23,'sfmemberopts','a:3:{s:16:\"sfcheckformember\";b:1;s:18:\"sfsinglemembership\";b:0;s:12:\"sfhidestatus\";b:1;}'),(24,'sfcontrols','a:5:{s:12:\"showtopcount\";i:10;s:12:\"shownewcount\";i:10;s:16:\"sfdefunreadposts\";i:50;s:13:\"sfusersunread\";b:0;s:16:\"sfmaxunreadposts\";i:50;}'),(25,'sfblockadmin','a:3:{s:10:\"blockadmin\";b:0;s:10:\"blockroles\";s:13:\"administrator\";s:13:\"blockredirect\";s:50:\"http://theconductivitydiet.primaryhub.com/forum-2/\";}'),(26,'sfmetatags','a:4:{s:7:\"sfdescr\";s:0:\"\";s:10:\"sfdescruse\";i:1;s:13:\"sfusekeywords\";i:2;s:8:\"keywords\";s:5:\"forum\";}'),(27,'sfdisplay','a:4:{s:9:\"pagetitle\";a:2:{s:7:\"notitle\";b:0;s:6:\"banner\";s:0:\"\";}s:6:\"forums\";a:1:{s:11:\"singleforum\";b:0;}s:6:\"topics\";a:2:{s:7:\"perpage\";i:12;s:10:\"sortnewtop\";b:1;}s:5:\"posts\";a:2:{s:7:\"perpage\";i:20;s:8:\"sortdesc\";b:0;}}'),(28,'sfguests','a:2:{s:8:\"reqemail\";b:1;s:11:\"storecookie\";b:1;}'),(29,'sfprofile','a:17:{s:10:\"nameformat\";b:1;s:18:\"fixeddisplayformat\";i:0;s:11:\"profilelink\";i:3;s:7:\"weblink\";i:3;s:11:\"displaymode\";i:1;s:11:\"displaypage\";s:0:\"\";s:12:\"displayquery\";s:0:\"\";s:8:\"formmode\";i:1;s:8:\"formpage\";s:0:\"\";s:9:\"formquery\";s:0:\"\";s:9:\"photosmax\";i:0;s:11:\"photoswidth\";i:0;s:12:\"photosheight\";i:0;s:10:\"firstvisit\";b:1;s:7:\"forcepw\";b:0;s:14:\"profileinstats\";b:1;s:13:\"sfprofiletext\";s:162:\"Welcome to the User Profile Overview Panel. From here you can view and update your profile and options as well as view your Usergroup Memberships and Permissions.\";}'),(30,'sfavatars','a:10:{s:13:\"sfshowavatars\";b:1;s:15:\"sfavataruploads\";b:1;s:12:\"sfavatarpool\";b:0;s:14:\"sfavatarremote\";b:0;s:12:\"sfgmaxrating\";i:1;s:12:\"sfavatarsize\";i:50;s:14:\"sfavatarresize\";b:1;s:21:\"sfavatarresizequality\";i:90;s:16:\"sfavatarfilesize\";i:10240;s:16:\"sfavatarpriority\";a:6:{i:0;i:0;i:1;i:2;i:2;i:3;i:3;i:1;i:4;i:4;i:5;i:5;}}'),(31,'sfrss','a:4:{s:10:\"sfrsscount\";i:15;s:10:\"sfrsswords\";i:0;s:14:\"sfrsstopicname\";b:0;s:12:\"sfrssfeedkey\";b:1;}'),(32,'sffiltershortcodes','1'),(33,'sfpostwrap','a:2:{s:8:\"postwrap\";b:0;s:9:\"postwidth\";i:0;}'),(34,'sfwplistpages','1'),(35,'sfscriptfoot',''),(36,'sfinloop',''),(37,'sfmultiplecontent','1'),(38,'sfwpheadbypass',''),(39,'spukey','w3c02c0155'),(40,'sp_current_theme','a:3:{s:5:\"theme\";s:7:\"default\";s:5:\"style\";s:11:\"default.php\";s:5:\"color\";s:10:\"black-gold\";}'),(41,'sp_mobile_theme','a:7:{s:6:\"active\";b:0;s:5:\"theme\";s:7:\"default\";s:5:\"style\";s:11:\"default.php\";s:5:\"color\";s:6:\"silver\";s:11:\"usetemplate\";b:0;s:12:\"pagetemplate\";s:0:\"\";s:7:\"notitle\";b:1;}'),(42,'sp_tablet_theme','a:7:{s:6:\"active\";b:0;s:5:\"theme\";s:7:\"default\";s:5:\"style\";s:11:\"default.php\";s:5:\"color\";s:6:\"silver\";s:11:\"usetemplate\";b:0;s:12:\"pagetemplate\";s:0:\"\";s:7:\"notitle\";b:1;}'),(43,'account-name',''),(44,'display-name',''),(45,'guest-name',''),(46,'sp_stats_interval','3600'),(47,'poststamp','2013-09-27 05:05:03'),(48,'combinecss',''),(49,'combinejs',''),(50,'post_count_delete',''),(51,'spForumStats','O:8:\"stdClass\":4:{s:6:\"groups\";i:1;s:6:\"forums\";i:1;s:6:\"topics\";i:0;s:5:\"posts\";i:0;}'),(52,'spMembershipStats','a:4:{s:6:\"admins\";s:1:\"1\";s:4:\"mods\";s:1:\"0\";s:7:\"members\";i:1;s:6:\"guests\";s:1:\"0\";}'),(53,'spPosterStats','a:0:{}'),(54,'spModStats','a:0:{}'),(55,'spAdminStats','a:1:{i:0;a:4:{s:7:\"user_id\";s:1:\"1\";s:12:\"display_name\";s:5:\"admin\";s:5:\"posts\";s:1:\"0\";s:5:\"admin\";s:1:\"1\";}}'),(69,'spMostOnline','2'),(60,'sfconfig','a:10:{s:7:\"avatars\";s:26:\"sp-resources/forum-avatars\";s:11:\"avatar-pool\";s:30:\"sp-resources/forum-avatar-pool\";s:7:\"smileys\";s:26:\"sp-resources/forum-smileys\";s:5:\"ranks\";s:25:\"sp-resources/forum-badges\";s:12:\"custom-icons\";s:31:\"sp-resources/forum-custom-icons\";s:11:\"language-sp\";s:40:\"sp-resources/forum-language/simple-press\";s:19:\"language-sp-plugins\";s:38:\"sp-resources/forum-language/sp-plugins\";s:18:\"language-sp-themes\";s:37:\"sp-resources/forum-language/sp-themes\";s:7:\"plugins\";s:26:\"sp-resources/forum-plugins\";s:6:\"themes\";s:25:\"sp-resources/forum-themes\";}'),(68,'sf_guest_memberships','a:1:{i:0;a:6:{s:12:\"usergroup_id\";s:1:\"1\";s:14:\"usergroup_name\";s:6:\"Guests\";s:14:\"usergroup_desc\";s:41:\"Default Usergroup for guests of the forum\";s:15:\"usergroup_badge\";s:0:\"\";s:14:\"usergroup_join\";s:1:\"0\";s:22:\"usergroup_is_moderator\";s:1:\"0\";}}'),(65,'spRecentMembers','a:2:{i:0;a:2:{s:2:\"id\";s:1:\"2\";s:4:\"name\";s:5:\"techd\";}i:1;a:2:{s:2:\"id\";s:1:\"1\";s:4:\"name\";s:5:\"admin\";}}'),(66,'sfversion','5.3.1'),(67,'sfbuild','10616');

--
-- Table structure for table `wp_sfpermissions`
--

CREATE TABLE `wp_sfpermissions` (
  `permission_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `forum_id` bigint(20) NOT NULL DEFAULT '0',
  `usergroup_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `permission_role` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `forum_idx` (`forum_id`),
  KEY `usergroup_idx` (`usergroup_id`),
  KEY `perm_role_idx` (`permission_role`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfpermissions`
--

INSERT INTO `wp_sfpermissions` VALUES (1,1,1,2),(2,1,2,4),(3,1,3,2);

--
-- Table structure for table `wp_sfposts`
--

CREATE TABLE `wp_sfposts` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_content` longtext,
  `post_date` datetime NOT NULL,
  `topic_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `forum_id` bigint(20) NOT NULL,
  `guest_name` varchar(20) DEFAULT NULL,
  `guest_email` varchar(50) DEFAULT NULL,
  `post_status` int(4) NOT NULL DEFAULT '0',
  `post_pinned` smallint(1) NOT NULL DEFAULT '0',
  `post_index` mediumint(8) DEFAULT '0',
  `post_edit` mediumtext,
  `poster_ip` varchar(39) NOT NULL DEFAULT '0.0.0.0',
  `comment_id` bigint(20) DEFAULT NULL,
  `source` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `topicp_idx` (`topic_id`),
  KEY `forump_idx` (`forum_id`),
  KEY `user_idx` (`user_id`),
  KEY `guest_name_idx` (`guest_name`),
  KEY `comment_idx` (`comment_id`),
  KEY `post_date_idx` (`post_date`),
  FULLTEXT KEY `post_content` (`post_content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfposts`
--


--
-- Table structure for table `wp_sfroles`
--

CREATE TABLE `wp_sfroles` (
  `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) NOT NULL DEFAULT '',
  `role_desc` varchar(150) NOT NULL DEFAULT '',
  `role_auths` longtext NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfroles`
--

INSERT INTO `wp_sfroles` VALUES (1,'No Access','Permission with no access to any Forum features','a:34:{i:1;i:0;i:2;i:0;i:3;i:0;i:4;i:0;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:0;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:0;i:25;i:0;i:26;i:0;i:27;i:0;i:28;i:0;i:32;i:0;i:33;i:0;i:30;i:0;i:31;i:0;i:29;i:0;i:34;i:0;}'),(2,'Read Only Access','Permission with access to only view the Forum','a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:0;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:0;i:25;i:0;i:26;i:0;i:27;i:0;i:28;i:0;i:32;i:0;i:33;i:0;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:0;}'),(3,'Limited Access','Permission with access to reply and start topics but with limited features','a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:0;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:1;i:25;i:1;i:26;i:0;i:27;i:0;i:28;i:0;i:32;i:0;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:1;}'),(4,'Standard Access','Permission with access to reply and start topics with advanced features such as signatures','a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:0;i:17;i:1;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:1;i:25;i:1;i:26;i:0;i:27;i:1;i:28;i:1;i:32;i:1;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:1;}'),(5,'Full Access','Permission with Standard Access features and math question bypass','a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:9;i:1;i:10;i:0;i:11;i:0;i:12;i:0;i:13;i:0;i:14;i:0;i:15;i:0;i:16;i:1;i:17;i:1;i:18;i:0;i:19;i:0;i:20;i:0;i:21;i:0;i:22;i:0;i:23;i:0;i:24;i:1;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:32;i:1;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:0;i:34;i:1;}'),(6,'Moderator Access','Permission with access to all Forum features','a:34:{i:1;i:1;i:2;i:0;i:3;i:0;i:4;i:1;i:5;i:0;i:6;i:1;i:7;i:1;i:8;i:0;i:10;i:1;i:9;i:1;i:11;i:1;i:12;i:1;i:13;i:1;i:14;i:1;i:15;i:1;i:16;i:1;i:17;i:1;i:18;i:1;i:19;i:0;i:20;i:1;i:21;i:1;i:22;i:1;i:23;i:1;i:24;i:1;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:32;i:1;i:33;i:1;i:30;i:1;i:31;i:1;i:29;i:1;i:34;i:1;}');

--
-- Table structure for table `wp_sftopics`
--

CREATE TABLE `wp_sftopics` (
  `topic_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `topic_name` varchar(200) NOT NULL,
  `topic_date` datetime NOT NULL,
  `topic_status` int(4) NOT NULL DEFAULT '0',
  `forum_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `topic_pinned` smallint(1) NOT NULL DEFAULT '0',
  `topic_opened` bigint(20) NOT NULL DEFAULT '0',
  `topic_slug` varchar(200) NOT NULL,
  `post_id` bigint(20) DEFAULT NULL,
  `post_id_held` bigint(20) DEFAULT NULL,
  `post_count` mediumint(8) DEFAULT '0',
  `post_count_held` mediumint(8) DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forumt_idx` (`forum_id`),
  KEY `tslug_idx` (`topic_slug`),
  KEY `user_idx` (`user_id`),
  KEY `post_idx` (`post_id`),
  FULLTEXT KEY `topic_name_idx` (`topic_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sftopics`
--


--
-- Table structure for table `wp_sftrack`
--

CREATE TABLE `wp_sftrack` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `trackuserid` bigint(20) DEFAULT '0',
  `trackname` varchar(50) NOT NULL,
  `trackdate` datetime NOT NULL,
  `forum_id` bigint(20) DEFAULT NULL,
  `topic_id` bigint(20) DEFAULT NULL,
  `pageview` varchar(50) NOT NULL,
  `notification` varchar(1024) DEFAULT NULL,
  `device` char(1) DEFAULT 'D',
  PRIMARY KEY (`id`),
  KEY `user_idx` (`trackuserid`),
  KEY `forum_idx` (`forum_id`),
  KEY `topic_idx` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sftrack`
--

INSERT INTO `wp_sftrack` VALUES (16,0,'24.156.96.141','2013-11-27 16:52:18',0,0,'group',NULL,'D');

--
-- Table structure for table `wp_sfusergroups`
--

CREATE TABLE `wp_sfusergroups` (
  `usergroup_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `usergroup_name` text NOT NULL,
  `usergroup_desc` text,
  `usergroup_badge` varchar(50) DEFAULT NULL,
  `usergroup_join` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `usergroup_is_moderator` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`usergroup_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfusergroups`
--

INSERT INTO `wp_sfusergroups` VALUES (1,'Guests','Default Usergroup for guests of the forum','',0,0),(2,'Members','Default Usergroup for registered users of the forum','',0,0),(3,'Moderators','Default Usergroup for moderators of the forum','',0,1);

--
-- Table structure for table `wp_sfwaiting`
--

CREATE TABLE `wp_sfwaiting` (
  `topic_id` bigint(20) NOT NULL,
  `forum_id` bigint(20) NOT NULL,
  `post_count` int(4) NOT NULL,
  `post_id` bigint(20) NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned DEFAULT '0',
  PRIMARY KEY (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_sfwaiting`
--


--
-- 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=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_term_relationships` VALUES (1,1,0),(38,13,0),(39,13,0),(40,13,0),(41,13,0),(42,13,0),(43,13,0),(44,13,0),(45,13,0),(133,2,0),(133,14,0),(133,15,0),(133,16,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=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'product_type','',0,1),(3,3,'product_type','',0,0),(4,4,'product_type','',0,0),(5,5,'product_type','',0,0),(6,6,'shop_order_status','',0,0),(7,7,'shop_order_status','',0,0),(8,8,'shop_order_status','',0,0),(9,9,'shop_order_status','',0,0),(10,10,'shop_order_status','',0,0),(11,11,'shop_order_status','',0,0),(12,12,'shop_order_status','',0,0),(13,13,'nav_menu','',0,8),(14,14,'product_tag','',0,1),(15,15,'product_tag','',0,1),(16,16,'product_tag','',0,1);

--
-- 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=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'simple','simple',0),(3,'grouped','grouped',0),(4,'variable','variable',0),(5,'external','external',0),(6,'pending','pending',0),(7,'failed','failed',0),(8,'on-hold','on-hold',0),(9,'processing','processing',0),(10,'completed','completed',0),(11,'refunded','refunded',0),(12,'cancelled','cancelled',0),(13,'Main','main',0),(14,'Private health Consultation','private-health-consultation',0),(15,'Conductivity Diet Consult','conductivity-diet-consult',0),(16,'Health Coaching','health-coaching',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=InnoDB AUTO_INCREMENT=101 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:13:{s:13:\"administrator\";b:1;s:14:\"backwpup_admin\";b:1;s:18:\"SPF Manage Options\";b:1;s:17:\"SPF Manage Forums\";b:1;s:22:\"SPF Manage User Groups\";b:1;s:22:\"SPF Manage Permissions\";b:1;s:21:\"SPF Manage Components\";b:1;s:17:\"SPF Manage Admins\";b:1;s:16:\"SPF Manage Users\";b:1;s:19:\"SPF Manage Profiles\";b:1;s:18:\"SPF Manage Toolbox\";b:1;s:18:\"SPF Manage Plugins\";b:1;s:17:\"SPF Manage Themes\";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,jwl_utmce_pointer,wp360_revisions'),(13,1,'show_welcome_panel','1'),(14,1,'wp_dashboard_quick_press_last_post_id','242'),(15,2,'first_name','techd'),(16,2,'last_name',''),(17,2,'nickname','techd'),(18,2,'description',''),(19,2,'rich_editing','true'),(20,2,'comment_shortcuts','false'),(21,2,'admin_color','fresh'),(22,2,'use_ssl','0'),(23,2,'show_admin_bar_front','true'),(24,2,'wp_capabilities','a:2:{s:13:\"administrator\";b:1;s:14:\"backwpup_admin\";b:1;}'),(25,2,'wp_user_level','10'),(26,2,'dismissed_wp_pointers','wp330_toolbar,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link,wp350_media,jwl_utmce_pointer,easyrecipe-fooderific,wp360_revisions'),(27,2,'wp_dashboard_quick_press_last_post_id','243'),(28,1,'managenav-menuscolumnshidden','a:4:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";}'),(29,1,'metaboxhidden_nav-menus','a:5:{i:0;s:8:\"add-post\";i:1;s:11:\"add-product\";i:2;s:12:\"add-post_tag\";i:3;s:15:\"add-product_cat\";i:4;s:15:\"add-product_tag\";}'),(30,1,'wp_user-settings','libraryContent=browse&imgsize=full&editor=tinymce&align=right'),(31,1,'wp_user-settings-time','1382711486'),(32,1,'nav_menu_recently_edited','13'),(33,1,'_woocommerce_persistent_cart','a:1:{s:4:\"cart\";a:0:{}}'),(34,1,'meta-box-order_genesis_page_ap-settings','a:1:{s:7:\"column1\";s:45:\"ap-settings-features_1,ap-settings-features_2\";}'),(35,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(36,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(37,1001001,'wp_user_level','10'),(38,1001001,'wp_user_level','10'),(39,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(40,1001001,'wp_user_level','10'),(41,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(42,1001001,'wp_user_level','10'),(43,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(44,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(45,1001001,'wp_user_level','10'),(46,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(47,1001001,'wp_user_level','10'),(48,1001001,'wp_user_level','10'),(49,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(50,1001001,'wp_user_level','10'),(51,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(52,1001001,'wp_user_level','10'),(53,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(54,1001001,'wp_user_level','10'),(55,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(56,1001001,'wp_user_level','10'),(57,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(58,1001001,'wp_user_level','10'),(59,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(60,1001001,'wp_user_level','10'),(61,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(62,1001001,'wp_user_level','10'),(63,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(64,1001001,'wp_user_level','10'),(65,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(66,1001001,'wp_user_level','10'),(67,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(68,1001001,'wp_user_level','10'),(69,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(70,1001001,'wp_user_level','10'),(71,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(72,1001001,'wp_user_level','10'),(73,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(74,1001001,'wp_user_level','10'),(75,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(76,1001001,'wp_user_level','10'),(77,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(78,1001001,'wp_user_level','10'),(79,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(80,1001001,'wp_user_level','10'),(81,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(82,1001001,'wp_user_level','10'),(83,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(84,1001001,'wp_user_level','10'),(85,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(86,1001001,'wp_user_level','10'),(87,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(88,1001001,'wp_user_level','10'),(89,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(90,1001001,'wp_user_level','10'),(91,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(92,1001001,'wp_user_level','10'),(93,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(94,1001001,'wp_user_level','10'),(95,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(96,1001001,'wp_user_level','10'),(97,1001001,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(98,1001001,'wp_user_level','10'),(99,101010,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(100,101010,'wp_user_level','10');

--
-- Table structure for table `wp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wp_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) NOT NULL,
  `attribute_label` longtext,
  `attribute_type` varchar(200) NOT NULL,
  `attribute_orderby` varchar(200) NOT NULL,
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_attribute_taxonomies`
--


--
-- Table structure for table `wp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wp_woocommerce_downloadable_product_permissions` (
  `download_id` varchar(32) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `order_key` varchar(200) NOT NULL,
  `user_email` varchar(200) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `downloads_remaining` varchar(9) DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`,`order_id`,`order_key`,`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wp_woocommerce_order_itemmeta`
--

CREATE TABLE `wp_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_order_itemmeta`
--


--
-- Table structure for table `wp_woocommerce_order_items`
--

CREATE TABLE `wp_woocommerce_order_items` (
  `order_item_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_item_name` longtext NOT NULL,
  `order_item_type` varchar(200) NOT NULL DEFAULT '',
  `order_id` bigint(20) NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_order_items`
--


--
-- Table structure for table `wp_woocommerce_tax_rate_locations`
--

CREATE TABLE `wp_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `location_code` varchar(255) NOT NULL,
  `tax_rate_id` bigint(20) NOT NULL,
  `location_type` varchar(40) NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_type` (`location_type`),
  KEY `location_type_code` (`location_type`,`location_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wp_woocommerce_tax_rates`
--

CREATE TABLE `wp_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(200) NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) NOT NULL DEFAULT '',
  `tax_rate` varchar(200) NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
  `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
  `tax_rate_order` bigint(20) NOT NULL,
  `tax_rate_class` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`),
  KEY `tax_rate_state` (`tax_rate_state`),
  KEY `tax_rate_class` (`tax_rate_class`),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_tax_rates`
--


--
-- Table structure for table `wp_woocommerce_termmeta`
--

CREATE TABLE `wp_woocommerce_termmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `woocommerce_term_id` bigint(20) NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `woocommerce_term_id` (`woocommerce_term_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_woocommerce_termmeta`
--

INSERT INTO `wp_woocommerce_termmeta` VALUES (1,13,'order','0'),(2,14,'order','0'),(3,15,'order','0'),(4,16,'order','0'),(5,14,'product_count_product_tag','1'),(6,15,'product_count_product_tag','1'),(7,16,'product_count_product_tag','1');

--
-- Dumping events for database 'tcddbase'
--

--
-- Dumping routines for database 'tcddbase'
--


