-- MySQL dump 10.13 Distrib 5.6.41-84.1, for Linux (x86_64) -- -- Host: localhost Database: clintsow_wrdp2 -- ------------------------------------------------------ -- Server version 5.6.41-84.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `wp_afflctable_link` -- DROP TABLE IF EXISTS `wp_afflctable_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_afflctable_link` ( `id` int(11) NOT NULL AUTO_INCREMENT, `linktitle` text COLLATE utf8_unicode_ci, `cloaklink` text COLLATE utf8_unicode_ci, `afflink` text COLLATE utf8_unicode_ci, `autoshortlink` tinyint(4) DEFAULT '1', `createdate` datetime DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_afflctable_link` -- LOCK TABLES `wp_afflctable_link` WRITE; /*!40000 ALTER TABLE `wp_afflctable_link` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_afflctable_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_afflctable_statistics_daily` -- DROP TABLE IF EXISTS `wp_afflctable_statistics_daily`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_afflctable_statistics_daily` ( `id` int(11) NOT NULL AUTO_INCREMENT, `statistics_date` date DEFAULT NULL, `hits` int(11) DEFAULT NULL, `uniquevisitors` int(11) DEFAULT NULL, `linktableid` int(11) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_afflctable_statistics_daily` -- LOCK TABLES `wp_afflctable_statistics_daily` WRITE; /*!40000 ALTER TABLE `wp_afflctable_statistics_daily` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_afflctable_statistics_daily` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_afflctable_track` -- DROP TABLE IF EXISTS `wp_afflctable_track`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_afflctable_track` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clientip` text COLLATE utf8_unicode_ci, `visittime` datetime DEFAULT NULL, `referrer` text COLLATE utf8_unicode_ci, `useragent` text COLLATE utf8_unicode_ci, `robot` tinyint(4) DEFAULT NULL, `visitorcookie` text COLLATE utf8_unicode_ci, `linktableid` int(11) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_afflctable_track` -- LOCK TABLES `wp_afflctable_track` WRITE; /*!40000 ALTER TABLE `wp_afflctable_track` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_afflctable_track` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_commentmeta` -- DROP TABLE IF EXISTS `wp_commentmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_commentmeta` -- LOCK TABLES `wp_commentmeta` WRITE; /*!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_commentmeta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_comments` -- DROP TABLE IF EXISTS `wp_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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 COLLATE utf8mb4_unicode_ci NOT NULL, `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT '0', `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci 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`), KEY `comment_author_email` (`comment_author_email`(10)) ) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_comments` -- LOCK TABLES `wp_comments` WRITE; /*!40000 ALTER TABLE `wp_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_links` -- DROP TABLE IF EXISTS `wp_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`link_id`), KEY `link_visible` (`link_visible`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_links` -- LOCK TABLES `wp_links` WRITE; /*!40000 ALTER TABLE `wp_links` DISABLE KEYS */; INSERT INTO `wp_links` VALUES (1,'http://codex.wordpress.org/','Documentation','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(2,'http://wordpress.org/news/','WordPress Blog','','','','Y',1,0,'0000-00-00 00:00:00','','','http://wordpress.org/news/feed/'),(3,'http://wordpress.org/extend/ideas/','Suggest Ideas','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(4,'http://wordpress.org/support/','Support Forum','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(5,'http://wordpress.org/extend/plugins/','Plugins','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(6,'http://wordpress.org/extend/themes/','Themes','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(7,'http://planet.wordpress.org/','WordPress Planet','','','','Y',1,0,'0000-00-00 00:00:00','','',''); /*!40000 ALTER TABLE `wp_links` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_options` -- DROP TABLE IF EXISTS `wp_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_options` ( `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `option_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes', PRIMARY KEY (`option_id`), UNIQUE KEY `option_name` (`option_name`) ) ENGINE=MyISAM AUTO_INCREMENT=59791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_options` -- LOCK TABLES `wp_options` WRITE; /*!40000 ALTER TABLE `wp_options` DISABLE KEYS */; INSERT INTO `wp_options` VALUES (1,'siteurl','http://panda-hat.net','yes'),(2,'blogname','The Panda Hat site','yes'),(3,'blogdescription','The best place to buy a panda hat','yes'),(4,'users_can_register','0','yes'),(5,'admin_email','clint_sowray@yahoo.com','yes'),(6,'start_of_week','1','yes'),(7,'use_balanceTags','0','yes'),(8,'use_smilies','1','yes'),(9,'require_name_email','1','yes'),(10,'comments_notify','1','yes'),(11,'posts_per_rss','10','yes'),(12,'rss_use_excerpt','0','yes'),(13,'mailserver_url','mail.example.com','yes'),(14,'mailserver_login','login@example.com','yes'),(15,'mailserver_pass','password','yes'),(16,'mailserver_port','110','yes'),(17,'default_category','1','yes'),(18,'default_comment_status','open','yes'),(19,'default_ping_status','open','yes'),(20,'default_pingback_flag','1','yes'),(22,'posts_per_page','10','yes'),(23,'date_format','F j, Y','yes'),(24,'time_format','g:i a','yes'),(25,'links_updated_date_format','F j, Y g:i a','yes'),(29,'comment_moderation','0','yes'),(30,'moderation_notify','1','yes'),(31,'permalink_structure','/%postname%/','yes'),(33,'hack_file','0','yes'),(34,'blog_charset','UTF-8','yes'),(35,'moderation_keys','','no'),(36,'active_plugins','a:19:{i:0;s:49:\"affiliate-link-cloaking/affiliatelinkcloaking.php\";i:1;s:43:\"all-in-one-seo-pack/all_in_one_seo_pack.php\";i:2;s:65:\"amazon-associates-link-builder/amazon-associates-link-builder.php\";i:3;s:45:\"ckeditor-for-wordpress/ckeditor_wordpress.php\";i:4;s:36:\"contact-form-7/wp-contact-form-7.php\";i:5;s:39:\"custom-post-order/custom-post-order.php\";i:6;s:33:\"duplicate-post/duplicate-post.php\";i:7;s:62:\"easy-google-analytics-for-wordpress/isoft-google-analytics.php\";i:8;s:31:\"exclude-pages/exclude_pages.php\";i:9;s:36:\"google-sitemap-generator/sitemap.php\";i:10;s:9:\"hello.php\";i:11;s:29:\"my-page-order/mypageorder.php\";i:12;s:33:\"my-posts-order/my-posts-order.php\";i:13;s:74:\"official-statcounter-plugin-for-wordpress/StatCounter-Wordpress-Plugin.php\";i:14;s:40:\"sexybookmarks-4.0.6.7/sexy-bookmarks.php\";i:15;s:47:\"thumbnail-for-excerpts/thumbnailforexcerpts.php\";i:16;s:61:\"webmaster-tools-verification/webmaster-tools-verification.php\";i:17;s:43:\"wp-realtime-sitemap/wp-realtime-sitemap.php\";i:18;s:19:\"wptouch/wptouch.php\";}','yes'),(20454,'custom_meta_description_key','meta_description','yes'),(20453,'sm_rewrite_done','$Id: sitemap-loader.php 937300 2014-06-23 18:04:11Z arnee $','yes'),(37,'home','http://panda-hat.net','yes'),(38,'category_base','','yes'),(39,'ping_sites','http://rpc.pingomatic.com/','yes'),(41,'comment_max_links','2','yes'),(42,'gmt_offset','0','yes'),(43,'default_email_category','1','yes'),(44,'recently_edited','a:5:{i:0;s:80:\"/home1/clintsow/public_html/panda-hat.net/wp-content/plugins/wptouch/wptouch.php\";i:1;s:106:\"/home1/clintsow/public_html/panda-hat.net/wp-content/plugins/ckeditor-for-wordpress/ckeditor_wordpress.php\";i:2;s:82:\"/home/clintsow/public_html/panda-hat.net/wp-content/themes/flexibility3/header.php\";i:3;s:81:\"/home/clintsow/public_html/panda-hat.net/wp-content/themes/flexibility3/style.css\";i:4;s:82:\"/home/clintsow/public_html/panda-hat.net/wp-content/themes/flexibility3/footer.php\";}','no'),(45,'template','flexibility3','yes'),(46,'stylesheet','flexibility3','yes'),(47,'comment_whitelist','1','yes'),(48,'blacklist_keys','','no'),(49,'comment_registration','0','yes'),(51,'html_type','text/html','yes'),(52,'use_trackback','0','yes'),(53,'default_role','subscriber','yes'),(54,'db_version','38590','yes'),(55,'uploads_use_yearmonth_folders','1','yes'),(56,'upload_path','','yes'),(57,'blog_public','1','yes'),(58,'default_link_category','2','yes'),(59,'show_on_front','page','yes'),(60,'tag_base','','yes'),(61,'show_avatars','1','yes'),(62,'avatar_rating','G','yes'),(63,'upload_url_path','','yes'),(64,'thumbnail_size_w','150','yes'),(65,'thumbnail_size_h','150','yes'),(66,'thumbnail_crop','1','yes'),(67,'medium_size_w','300','yes'),(68,'medium_size_h','300','yes'),(69,'avatar_default','mystery','yes'),(72,'large_size_w','1024','yes'),(73,'large_size_h','1024','yes'),(74,'image_default_link_type','file','yes'),(75,'image_default_size','','yes'),(76,'image_default_align','','yes'),(77,'close_comments_for_old_posts','0','yes'),(78,'close_comments_days_old','14','yes'),(79,'thread_comments','1','yes'),(80,'thread_comments_depth','5','yes'),(81,'page_comments','0','yes'),(82,'comments_per_page','50','yes'),(83,'default_comments_page','newest','yes'),(84,'comment_order','asc','yes'),(85,'sticky_posts','a:0:{}','yes'),(86,'widget_categories','a:1:{s:12:\"_multiwidget\";i:1;}','yes'),(87,'widget_text','a:8:{i:2;a:0:{}i:3;a:3:{s:5:\"title\";s:13:\"More sponsors\";s:4:\"text\";s:309:\"\r\n\";s:6:\"filter\";b:0;}i:4;a:3:{s:5:\"title\";s:0:\"\";s:4:\"text\";s:0:\"\";s:6:\"filter\";b:0;}i:5;a:3:{s:5:\"title\";s:15:\"Sponsored Links\";s:4:\"text\";s:309:\"\r\n\";s:6:\"filter\";b:0;}i:7;a:3:{s:5:\"title\";s:11:\"Other Links\";s:4:\"text\";s:505:\"
\r\nPrivacy Policy\r\n
\r\n\r\n