--
-- Host: localhost    Database: ossnblog
-- ------------------------------------------------------


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

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` int(11) 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) NOT NULL DEFAULT '0',
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_comments` VALUES (1,1,'Mr WordPress','','http://wordpress.org/','','2008-07-16 18:34:47','2008-07-17 00:34:47','Hi, this is a comment.<br />To 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,'1','','',0,0);

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

CREATE TABLE `wp_links` (
  `link_id` bigint(20) 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_category` bigint(20) NOT NULL DEFAULT '0',
  `link_description` varchar(255) NOT NULL DEFAULT '',
  `link_visible` varchar(20) NOT NULL DEFAULT 'Y',
  `link_owner` int(11) 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_category` (`link_category`),
  KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

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


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

CREATE TABLE `wp_options` (
  `option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL DEFAULT '0',
  `option_name` varchar(64) NOT NULL DEFAULT '',
  `option_value` longtext NOT NULL,
  `autoload` varchar(20) NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`,`blog_id`,`option_name`),
  KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;

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



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

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) 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=40 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_postmeta` VALUES (1,1,'_edit_lock','1216748987'),(2,1,'_edit_last','3'),(5,3,'_wp_attached_file','/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/1.jpg'),(6,3,'_wp_attachment_metadata','a:6:{s:5:\"width\";i:280;s:6:\"height\";i:300;s:14:\"hwstring_small\";s:22:\"height=\'96\' width=\'89\'\";s:4:\"file\";s:60:\"/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/1.jpg\";s:5:\"sizes\";a:1:{s:9:\"thumbnail\";a:3:{s:4:\"file\";s:13:\"1-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;}}s:10:\"image_meta\";a:10:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";}}'),(13,2,'_edit_lock','1216749165'),(27,8,'_wp_attachment_metadata','a:6:{s:5:\"width\";i:298;s:6:\"height\";i:100;s:14:\"hwstring_small\";s:23:\"height=\'42\' width=\'128\'\";s:4:\"file\";s:61:\"/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/11.jpg\";s:5:\"sizes\";a:1:{s:9:\"thumbnail\";a:3:{s:4:\"file\";s:14:\"11-150x100.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:100;}}s:10:\"image_meta\";a:10:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";}}'),(14,2,'_edit_last','3'),(15,2,'_wp_page_template','default'),(26,8,'_wp_attached_file','/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/11.jpg'),(25,7,'_edit_last','2'),(24,7,'_edit_lock','1221681846'),(20,6,'_wp_attached_file','/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/2.jpg'),(21,6,'_wp_attachment_metadata','a:6:{s:5:\"width\";i:301;s:6:\"height\";i:180;s:14:\"hwstring_small\";s:23:\"height=\'76\' width=\'128\'\";s:4:\"file\";s:60:\"/usr/home/www/ossnblog/root/wp-content/uploads/2008/07/2.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:3:{s:4:\"file\";s:13:\"2-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;}s:6:\"medium\";a:3:{s:4:\"file\";s:13:\"2-300x179.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:179;}}s:10:\"image_meta\";a:10:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";}}'),(30,9,'_edit_lock','1219417390'),(31,9,'_edit_last','3'),(32,10,'_wp_attached_file','/usr/home/www/ossnblog/root/wp-content/uploads/2008/08/travel-911-full-spread-proof.jpg'),(33,10,'_wp_attachment_metadata','a:6:{s:5:\"width\";i:1625;s:6:\"height\";i:1500;s:14:\"hwstring_small\";s:23:\"height=\'96\' width=\'104\'\";s:4:\"file\";s:87:\"/usr/home/www/ossnblog/root/wp-content/uploads/2008/08/travel-911-full-spread-proof.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:3:{s:4:\"file\";s:40:\"travel-911-full-spread-proof-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;}s:6:\"medium\";a:3:{s:4:\"file\";s:40:\"travel-911-full-spread-proof-300x276.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:276;}}s:10:\"image_meta\";a:10:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";}}'),(34,11,'_wp_attached_file','/usr/home/www/ossnblog/root/wp-content/uploads/2008/08/travel-911-full-spread-proof1.jpg'),(35,11,'_wp_attachment_metadata','a:6:{s:5:\"width\";i:1625;s:6:\"height\";i:1500;s:14:\"hwstring_small\";s:23:\"height=\'96\' width=\'104\'\";s:4:\"file\";s:88:\"/usr/home/www/ossnblog/root/wp-content/uploads/2008/08/travel-911-full-spread-proof1.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:3:{s:4:\"file\";s:41:\"travel-911-full-spread-proof1-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;}s:6:\"medium\";a:3:{s:4:\"file\";s:41:\"travel-911-full-spread-proof1-300x276.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:276;}}s:10:\"image_meta\";a:10:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";}}'),(36,12,'_edit_lock','1221682328'),(37,12,'_edit_last','2'),(38,13,'_edit_lock','1221669135'),(39,13,'_edit_last','6');

--
-- Table structure for table `wp_posts`
--

CREATE TABLE `wp_posts` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint(20) NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext NOT NULL,
  `post_title` text NOT NULL,
  `post_category` int(4) NOT NULL DEFAULT '0',
  `post_excerpt` text NOT NULL,
  `post_status` varchar(20) NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) NOT NULL DEFAULT 'open',
  `post_password` varchar(20) NOT NULL DEFAULT '',
  `post_name` varchar(200) NOT NULL DEFAULT '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` text NOT NULL,
  `post_parent` bigint(20) NOT NULL DEFAULT '0',
  `guid` varchar(255) NOT NULL DEFAULT '',
  `menu_order` int(11) NOT NULL DEFAULT '0',
  `post_type` varchar(20) NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) NOT NULL DEFAULT '',
  `comment_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_posts`
--

INSERT INTO `wp_posts` VALUES (1,1,'2008-07-16 18:34:47','2008-07-17 00:34:47','<a href=\"http://blog.ossn.com\"><img class=\"alignnone size-medium wp-image-3\" title=\"1\" src=\"http://blog.ossn.com/wp-content/uploads/2008/07/1.jpg\" alt=\"OSSN Blog\" width=\"280\" height=\"300\" /></a>On <strong>Monday, August 4, 2008,</strong> we\'ll begin a \"soft launch\" of a brand-new conversation with North America\'s home-based travel agents. <span style=\"color: #0000ff;\"><strong>OSSN will be the first home-based agents association to offer a blog for its members!</strong></span> We\'re very proud to lead the way and open the lines of communication with our members this way.\r\n\r\nHere\'s our first post:\r\n\r\nWe\'d like to ask you a question:  What\'s the best sales advice you\'ve ever gotten from a travel supplier?\r\n\r\nTo send us your answer, go to <a href=\"http://www.ossn.com/secure/education/bbs/index.asp\">OSSN\'s bulletin board</a> and type in your reply!  We\'ll pull selected answers to feature in another blog post next week.\r\n\r\n(The OSSN bulletin board is for members only. If you\'re reading this, but you don\'t belong to OSSN, <a href=\"http://www.ossn.com/join.asp\" target=\"_blank\">find out what you\'re missing</a>!)\r\n\r\nThanks for your help -- and, watch for more updates as the new OSSN blog takes shape!','OSSN Launches Its Blog!',0,'','publish','open','open','','hello-world','','','2008-07-22 11:49:46','2008-07-22 17:49:46','',0,'http://blog.ossn.com/?p=1',0,'post','',1),(2,1,'2008-07-16 18:34:47','2008-07-17 00:34:47','Welcome to the Outside Sales Support Network (OSSN). OSSN is the Premier Travel Industry Trade Association representing and supporting the  <em><strong>Independent Travel Agents, Home Based Travel Agency, Independent Contractor Seller of Travel and the Outside Sales Travel Agent.</strong></em>\r\n\r\nOSSN\'s mission is to provide our members with every possible tool and unlimited travel agent training to help their business succeed in today\'s new travel environment. OSSN provides members with a variety of educational programs and networking communication platforms that allow members a professional forum to help ENSURE the success of your travel agent business.\r\n\r\nThe Outside Sales Support Network was founded in 1990. Today our travel Association has over 60 Chapters including our International Chapters with over 5800 members.','About OSSN',0,'','publish','open','open','','about','','','2008-07-22 11:52:44','2008-07-22 17:52:44','',0,'http://blog.ossn.com/?page_id=2',0,'page','',0),(3,3,'2008-07-22 11:48:00','2008-07-22 17:48:00','','1',0,'OSSN Blog','inherit','open','open','','1','','','2008-07-22 11:48:00','2008-07-22 17:48:00','',1,'http://blog.ossn.com/wp-content/uploads/2008/07/1.jpg',0,'attachment','image/jpeg',0),(11,3,'2008-08-22 09:01:39','2008-08-22 15:01:39','','travel-911-full-spread-proof1',0,'','inherit','open','open','','travel-911-full-spread-proof1','','','2008-08-22 09:01:39','2008-08-22 15:01:39','',9,'http://blog.ossn.com/wp-content/uploads/2008/08/travel-911-full-spread-proof1.jpg',0,'attachment','image/jpeg',0),(8,3,'2008-07-28 15:11:37','2008-07-28 21:11:37','','11',0,'','inherit','open','open','','11','','','2008-07-28 15:11:37','2008-07-28 21:11:37','',7,'http://blog.ossn.com/wp-content/uploads/2008/07/11.jpg',0,'attachment','image/jpeg',0),(9,3,'0000-00-00 00:00:00','0000-00-00 00:00:00','tehektet','',0,'','draft','open','open','','','','','2008-08-22 08:51:08','2008-08-22 14:51:08','',0,'http://blog.ossn.com/?p=9',0,'post','',0),(10,3,'2008-08-22 09:00:08','2008-08-22 15:00:08','','travel-911-full-spread-proof',0,'','inherit','open','open','','travel-911-full-spread-proof','','','2008-08-22 09:00:08','2008-08-22 15:00:08','',9,'http://blog.ossn.com/wp-content/uploads/2008/08/travel-911-full-spread-proof.jpg',0,'attachment','image/jpeg',0),(6,3,'2008-07-22 13:36:59','2008-07-22 19:36:59','','2',0,'','inherit','open','open','','2','','','2008-07-22 13:36:59','2008-07-22 19:36:59','',0,'http://blog.ossn.com/wp-content/uploads/2008/07/2.jpg',0,'attachment','image/jpeg',0),(7,6,'2008-07-28 15:15:20','2008-07-28 21:15:20','<a href=\"http://blog.ossn.com/wp-content/uploads/2008/07/11.jpg\"><img class=\"alignnone size-medium wp-image-8\" src=\"http://blog.ossn.com/wp-content/uploads/2008/07/11.jpg\" alt=\"\" width=\"298\" height=\"100\" /></a>The OSSN Memphis Chapter welcomed <a href=\"http://www.bookccl.com\"><em><strong>Carnival Cruise Lines</strong></em></a> to our July meeting!\r\n\r\nWe learned a lot about the line\'s new ships, and the agents who attended our meeting were given $1,000 bonus commission coupons.\r\n\r\nDuring the meeting, we saw:\r\n<ol>\r\n	<li>Videos</li>\r\n	<li>Photos</li>\r\n	<li>An in-person presentation</li>\r\n</ol>\r\nThanks to our friends at Carnival!\r\n\r\nPatricia Bannister\r\nOSSN Memphis Chapter Director\r\npbannister@bannistertravel.com','OSSN Memphis Welcomes Carnival!',0,'','publish','open','open','','ossn-memphis-welcomes-carnival','','','2008-07-28 15:15:20','2008-07-28 21:15:20','',0,'http://blog.ossn.com/?p=7',0,'post','',0),(12,14,'0000-00-00 00:00:00','0000-00-00 00:00:00','The South shall rise again!  And here we come. \n\nWe are starting out in the Greenville area, but have our sites are on covering the whole state.  We are currently meeting the last Tuesday of the month at Romano\'s Macaroni Grill in Greenville.  Come join the fun, education and networking. \n\nI am Linda Isbell, owner of Run Away Travels, Inc., a home-based travel agency. We are a full service travel agency with independent contractors in Alabama and Colorado.  We have specialist assigned to group cruising, Disney and Couples Resorts.  Run Away Travels been in business since 2003.  We hope you will visit our website at <a href=\"http://www.runawaytravels.com\">www.runawaytravels.com</a>. \n\n \n\n ','South Carolina-Greenville Chapter',0,'','draft','open','open','','','','','2008-09-16 14:10:43','2008-09-16 20:10:43','',0,'http://blog.ossn.com/?p=12',0,'post','',0),(13,6,'0000-00-00 00:00:00','0000-00-00 00:00:00','Hello,\r\n\r\nMy name is <em><strong>Patricia Bannister</strong></em> and I hold two titles with OSSN.  First, I am the <strong>Memphis &amp; Northern MS Director for OSSN</strong>.  I am also the <strong>Southeastern Regional Manager for OSSN</strong>.\r\n\r\nI began my career in travel as a member of a host agency.  The agency was in my town and gave all of us some wonderful travel education.  As with life, things began to change, and my host moved out of town and stopped paying commissions to those of us who were really trying to sell travel.  I later found out that my host was a card mill.  They issued cards to everyone who paid them a lot of money, and they didn\'t care whether you sold travel, memberships, or nothing.\r\n\r\nI went to an NCL breakfast one morning and met a director for OSSN.  OSSN helped me to save the business I had begun, and helped me to own my own agency.  They taught me all the things that I needed to know to follow the seller of travel laws in my state, they helped me with the forms that I needed for clients and to set up my office.  I found my E&amp;O insurance company on their site, as well as the company that I deal with now for taking credit cards.\r\n\r\nThen, I became the Memphis Chapter Director for them.  That was later expanded to N. MS and E. AR.  We hold meetings in Memphis once a month and we have various suppliers attend.  Those suppliers are OSSN allied suppliers who have stated that they want to work with you, the home-based agent to build your business to the level where you want to go.\r\n\r\nI have learned so much from my association with OSSN, and I truly believe that that association helped me more than anything else to save my business.\r\n\r\nIf I can ever help any of you, feel free to contact me at 662-288-9052 or at <a href=\"mailto:memphis@ossn.com\">memphis@ossn.com</a>.\r\n\r\nPatricia Bannister, Southeastern Regional Manager, OSSN\r\n\r\n ','Hello, I am the Southeastern Regional Manager for OSSN',0,'','pending','open','open','','hello-i-am-the-southeastern-regional-manager-for-ossn','','','2008-09-17 10:32:15','2008-09-17 16:32:15','',0,'http://blog.ossn.com/?p=13',0,'post','',0);

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

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) 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 (11,1,0),(13,1,0),(6,1,0),(8,1,0),(10,1,0),(7,1,0),(2,1,0),(1,3,0),(3,1,0);

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

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

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

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'link_category','',0,0),(3,3,'category','',0,1),(4,4,'category','',0,0),(5,5,'category','',0,0),(6,6,'category','',0,0);

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

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) 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`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Blogroll','blogroll',0),(3,'OSSN Info','ossn-info',0),(4,'Legal Issues','legal-issues',0),(5,'Supplier News','supplier-news',0),(6,'Sales &amp; Marketing','sales-marketing',0);

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

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) 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=136 DEFAULT CHARSET=utf8;

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

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'rich_editing','true'),(3,1,'admin_color','fresh'),(4,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(5,1,'wp_user_level','10'),(6,2,'first_name','Gary'),(7,2,'last_name','Fee'),(8,2,'nickname','OSSN'),(9,2,'rich_editing','true'),(10,2,'admin_color','fresh'),(11,2,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(12,2,'wp_user_level','10'),(13,3,'first_name','John'),(14,3,'last_name','Hawks'),(15,3,'nickname','johnhawks'),(16,3,'rich_editing','true'),(17,3,'admin_color','fresh'),(18,3,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(19,3,'wp_user_level','10'),(20,3,'closedpostboxes_post','a:7:{i:0;s:11:\"postexcerpt\";i:1;s:13:\"trackbacksdiv\";i:2;s:10:\"postcustom\";i:3;s:16:\"commentstatusdiv\";i:4;s:11:\"passworddiv\";i:5;s:7:\"slugdiv\";i:6;s:9:\"authordiv\";}'),(21,4,'first_name','Melody'),(22,4,'last_name','Fee'),(23,4,'nickname','melodyfee'),(24,4,'rich_editing','true'),(25,4,'admin_color','fresh'),(26,4,'wp_capabilities','a:1:{s:6:\"author\";b:1;}'),(27,4,'wp_user_level','2'),(28,5,'first_name','Sal'),(29,5,'last_name','Donato'),(30,5,'nickname','saldonato'),(31,5,'rich_editing','true'),(32,5,'admin_color','fresh'),(33,5,'wp_capabilities','a:1:{s:6:\"author\";b:1;}'),(34,5,'wp_user_level','2'),(35,6,'first_name','Patricia'),(36,6,'last_name','Bannister'),(37,6,'nickname','pbannister'),(38,6,'rich_editing','true'),(39,6,'admin_color','fresh'),(40,6,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(41,6,'wp_user_level','1'),(42,7,'first_name','Monique'),(43,7,'last_name','Peragine'),(44,7,'nickname','moe4665'),(45,7,'rich_editing','true'),(46,7,'admin_color','fresh'),(47,7,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(48,7,'wp_user_level','1'),(49,8,'first_name','Jeff'),(50,8,'last_name','Grieder'),(51,8,'nickname','jeffgrieder'),(52,8,'rich_editing','true'),(53,8,'admin_color','fresh'),(54,8,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(55,8,'wp_user_level','1'),(56,9,'first_name','John'),(57,9,'last_name','Grygalonis'),(58,9,'nickname','johngrygalonis'),(59,9,'rich_editing','true'),(60,9,'admin_color','fresh'),(61,9,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(62,9,'wp_user_level','1'),(63,10,'first_name','Robert'),(64,10,'last_name','Lane'),(65,10,'nickname','robertlane'),(66,10,'rich_editing','true'),(67,10,'admin_color','fresh'),(68,10,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(69,10,'wp_user_level','1'),(70,11,'first_name','Lois'),(71,11,'last_name','Osborne'),(72,11,'nickname','osbornl2'),(73,11,'rich_editing','true'),(74,11,'admin_color','fresh'),(75,11,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(76,11,'wp_user_level','1'),(77,12,'first_name','Yolanda'),(78,12,'last_name','Tatum'),(79,12,'nickname','yolandatatum'),(80,12,'rich_editing','true'),(81,12,'admin_color','fresh'),(82,12,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(83,12,'wp_user_level','1'),(84,6,'wp_autosave_draft_ids','a:4:{i:-1216751583;i:4;i:-1216754770;i:5;i:-1217278607;i:7;i:-1221667562;i:13;}'),(85,13,'first_name','Leona'),(86,13,'last_name','Olson'),(87,13,'nickname','LeonaOlson'),(88,13,'rich_editing','true'),(89,13,'admin_color','fresh'),(90,13,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(91,13,'wp_user_level','1'),(92,14,'first_name','Linda'),(93,14,'last_name','Isbell'),(94,14,'nickname','LindaIsbell'),(95,14,'rich_editing','true'),(96,14,'admin_color','fresh'),(97,14,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(98,14,'wp_user_level','1'),(99,15,'first_name','Helga'),(100,15,'last_name','Leonard'),(101,15,'nickname','HelgaLeonard'),(102,15,'rich_editing','true'),(103,15,'admin_color','fresh'),(104,15,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(105,15,'wp_user_level','1'),(106,16,'first_name','Bill'),(107,16,'last_name','Potuchek'),(108,16,'nickname','Connecticut'),(109,16,'rich_editing','true'),(110,16,'admin_color','fresh'),(111,16,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(112,16,'wp_user_level','1'),(113,17,'first_name','Paula'),(114,17,'last_name','Goldsmith'),(115,17,'nickname','PaulaGoldsmith'),(116,17,'rich_editing','true'),(117,17,'admin_color','fresh'),(118,17,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(119,17,'wp_user_level','1'),(120,18,'first_name','PJ'),(121,18,'last_name','Ott'),(122,18,'nickname','PJOtt'),(123,18,'rich_editing','true'),(124,18,'admin_color','fresh'),(125,18,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(126,18,'wp_user_level','1'),(127,19,'first_name','Sharon'),(128,19,'last_name','Scheideler'),(129,19,'nickname','SharonScheideler'),(130,19,'rich_editing','true'),(131,19,'admin_color','fresh'),(132,19,'wp_capabilities','a:1:{s:11:\"contributor\";b:1;}'),(133,19,'wp_user_level','1'),(134,3,'wp_autosave_draft_ids','a:1:{i:-1219416364;i:9;}'),(135,14,'wp_autosave_draft_ids','a:1:{i:-1221590114;i:12;}');

--
-- Table structure for table `wp_users`
--

CREATE TABLE `wp_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(64) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(60) NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_users`
--

INSERT INTO `wp_users` VALUES (1,'admin','$P$BKCBiFK0Xb7lXkLCG.1QQ3XxezC2YM1','admin','phil@primaryhub.com','','2008-07-17 00:34:47','',0,'admin'),(2,'OSSN','$P$B.p8NLMN3ZRBeKiujWTECpm7tDRR7Z0','ossn','info@ossn.com','http://www.ossn.com','2008-07-17 00:35:42','',0,'OSSN'),(3,'johnhawks','$P$Bout6e7sCdfAZ8rwgoFOJPoCJpzE.Z0','johnhawks','john@primaryhub.org','http://www.ossn.com','2008-07-17 00:36:32','',0,'johnhawks'),(4,'melodyfee','$P$BfuBuuiAxcRBXzcAG4TItRJ0PN49201','melodyfee','melodyfee@ossn.com','http://www.ossn.com','2008-07-22 18:04:20','',0,'melodyfee'),(5,'saldonato','$P$BduAspRgW4X6lFFlt8VwJREUda/yCb1','saldonato','adagency@ossn.com','http://www.ossn.com','2008-07-22 18:04:43','',0,'saldonato'),(6,'pbannister','$P$BIp2rG4RZJC5Q9zMI3CktiAeUAlLOA.','pbannister','patricia@bannistertravel.com','http://www.bannistertravel.com','2008-07-22 18:05:27','',0,'pbannister'),(7,'moe4665','$P$BEpqjmocj5D9SePqwH.Z.u8bXu6z5f/','moe4665','monique@tripsaplenty.com','http://www.tripsaplenty.com','2008-07-22 18:06:04','',0,'moe4665'),(8,'jeffgrieder','$P$BbfSrYkDps2zfNVi08obhCpZ6nDDM//','jeffgrieder','jeff@asapcruisevacations.com','http://www.asapcruisevacations.com','2008-07-22 18:06:33','',0,'jeffgrieder'),(9,'johngrygalonis','$P$BAn/DA9jhNY6LVSbUsRbVvLweqxl191','johngrygalonis','williamsburgva@ossn.com','http://www.vipleisuretravel.com','2008-07-22 18:07:23','',0,'johngrygalonis'),(10,'robertlane','$P$B5yzt0gAnCuKpUhZO1nIMGEWRC0pqP/','robertlane','northwesttravel@sbcglobal.net','http://','2008-07-22 18:08:04','',0,'robertlane'),(11,'osbornl2','$P$Bw4BpiaBOR4Fd0QBZFtaTA0gqe9ruc0','osbornl2','laosb625@msn.com','http://','2008-07-22 18:08:38','',0,'osbornl2'),(12,'yolandatatum','$P$BLaguYVyKeiH0L37j.qu2EvKxUFkQU.','yolandatatum','yolanda.tatum@sbcglobal.net','http://','2008-07-22 18:09:05','',0,'yolandatatum'),(13,'LeonaOlson','$P$BYTfnq/o/gCGEnPQdg/HDUNRc5m5MV0','leonaolson','mncruise@aol.com','http://','2008-08-19 18:12:38','',0,'LeonaOlson'),(14,'LindaIsbell','$P$BPqVcybH6NzIeMB.0Z2ivfsFJ7Emds.','lindaisbell','greenville-sc@ossn.com','http://','2008-08-19 18:13:15','',0,'LindaIsbell'),(15,'HelgaLeonard','$P$B/pyjPEAVxdThOf/H.BUIfZigsDDHR0','helgaleonard','helgaandrandy@zoom.internet.net','http://www.adreamtrip4u.com','2008-08-19 18:14:06','',0,'HelgaLeonard'),(16,'Connecticut','$P$BVIrEetFlp6Hz8lPs8C68Fnc1L5noc.','connecticut','dvtravels@hotmail.com','http://','2008-08-19 18:14:49','',0,'Connecticut'),(17,'PaulaGoldsmith','$P$BNO.y05kboXXNrwoiPgG8iRoGarqzB0','paulagoldsmith','wiinger@aol.com','http://','2008-08-19 18:15:33','',0,'PaulaGoldsmith'),(18,'PJOtt','$P$B3LgC4gBo70cp95QFgaGdC6JCsN3gU/','pjott','Jott399102@aol.com','http://','2008-08-19 18:16:11','',0,'PJOtt'),(19,'SharonScheideler','$P$BcCNFAlZfkfz/HKKD1h2beK07ZkVrS.','sharonscheideler','ourpersonaltouchplustravel@gmail.com','http://','2008-08-19 18:17:13','',0,'SharonScheideler');

--
-- Dumping events for database 'ossnblog'
--

--
-- Dumping routines for database 'ossnblog'
--


