-- Softaculous SQL Dump
-- http://www.softaculous.com
--




--
-- Database: `mitchp5_gavinp`
--

-- --------------------------------------------------------

--
-- Table structure for table `gavinpcommentmeta`
--

CREATE TABLE `gavinpcommentmeta` (
  `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`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gavinpcomments`
--

CREATE TABLE `gavinpcomments` (
  `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`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gavinpcomments`
--

INSERT INTO `gavinpcomments` VALUES
(1, 1, 'A WordPress Commenter', 'wapuu@wordpress.example', 'https://wordpress.org/', '', '2017-06-26 01:07:52', '2017-06-26 01:07:52', 'Hi, this is a comment.\nTo get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.\nCommenter avatars come from <a href="https://gravatar.com">Gravatar</a>.', 0, '1', '', '', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `gavinplinks`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `gavinploginizer_logs`
--

CREATE TABLE `gavinploginizer_logs` (
  `username` varchar(255) NOT NULL DEFAULT '',
  `time` int(10) NOT NULL DEFAULT '0',
  `count` int(10) NOT NULL DEFAULT '0',
  `lockout` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gavinploginizer_logs`
--

INSERT INTO `gavinploginizer_logs` VALUES
('test', 1499178814, 1, 0, '189.6.234.32'),
('test', 1499178036, 1, 0, '77.77.249.214'),
('test', 1499176688, 1, 0, '122.174.23.190'),
('test', 1499175183, 1, 0, '197.128.20.201'),
('admin', 1499087336, 18, 6, '81.24.247.41'),
('test', 1499159912, 1, 0, '185.96.69.229'),
('test', 1499173213, 1, 0, '103.193.200.165'),
('test', 1499173216, 1, 0, '77.217.118.153'),
('test', 1499173668, 1, 0, '42.113.166.22'),
('test', 1499140885, 1, 0, '171.228.23.51'),
('test', 1499139695, 1, 0, '84.9.85.155'),
('test', 1499144121, 2, 0, '174.102.200.40'),
('test', 1499132780, 1, 0, '81.165.39.75'),
('test', 1499130393, 1, 0, '194.228.20.252'),
('test', 1499129923, 1, 0, '117.228.66.6'),
('test', 1499129230, 1, 0, '36.72.128.125'),
('test', 1499126340, 1, 0, '181.137.92.107'),
('test', 1499123919, 1, 0, '109.166.135.73'),
('test', 1499123916, 1, 0, '177.200.159.2'),
('test', 1499118341, 1, 0, '86.123.32.94'),
('test', 1499117679, 1, 0, '187.79.34.240'),
('test', 1499116411, 1, 0, '91.128.68.57'),
('test', 1499109601, 1, 0, '77.28.237.155'),
('test', 1499109155, 1, 0, '124.106.133.31'),
('test', 1499105828, 1, 0, '189.105.168.12'),
('test', 1499102164, 1, 0, '174.23.115.16'),
('test', 1499096294, 1, 0, '173.200.185.218'),
('test', 1499093918, 1, 0, '200.28.60.30'),
('test', 1499093341, 1, 0, '84.117.96.102'),
('test', 1499089520, 1, 0, '153.151.156.158'),
('test', 1499088286, 1, 0, '210.195.142.24'),
('test', 1499087725, 1, 0, '101.177.15.250'),
('test', 1499085446, 1, 0, '203.76.123.226'),
('test', 1499083724, 1, 0, '200.115.229.59'),
('test', 1499158653, 1, 0, '103.54.16.210'),
('test', 1499153592, 1, 0, '191.205.117.98'),
('test', 1499151383, 1, 0, '124.106.245.177'),
('test', 1499150584, 1, 0, '112.134.65.122'),
('test', 1499149748, 1, 0, '210.146.172.220'),
('test', 1499147017, 1, 0, '158.181.185.58'),
('test', 1499144257, 1, 0, '177.42.154.170'),
('test', 1499078036, 1, 0, '197.245.115.211'),
('test', 1499077402, 1, 0, '110.136.230.223'),
('test', 1499077400, 1, 0, '182.64.164.234'),
('test', 1499071347, 1, 0, '101.108.54.171'),
('test', 1499070346, 1, 0, '81.225.72.165'),
('test', 1499069171, 1, 0, '125.62.98.125'),
('test', 1499068646, 1, 0, '103.9.115.212'),
('test', 1499067666, 1, 0, '64.119.192.29'),
('test', 1499061570, 1, 0, '107.171.246.121');

-- --------------------------------------------------------

--
-- Table structure for table `gavinpoptions`
--

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



-- --------------------------------------------------------

--
-- Table structure for table `gavinppostmeta`
--

CREATE TABLE `gavinppostmeta` (
  `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`(191))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gavinppostmeta`
--

INSERT INTO `gavinppostmeta` VALUES
(1, 2, '_wp_page_template', 'default');

-- --------------------------------------------------------

--
-- Table structure for table `gavinptermmeta`
--

CREATE TABLE `gavinptermmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gavinpterms`
--

CREATE TABLE `gavinpterms` (
  `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`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gavinpterms`
--

INSERT INTO `gavinpterms` VALUES
(1, 'Uncategorized', 'uncategorized', 0);

-- --------------------------------------------------------

--
-- Table structure for table `gavinpterm_relationships`
--

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

--
-- Dumping data for table `gavinpterm_relationships`
--

INSERT INTO `gavinpterm_relationships` VALUES
(1, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `gavinpterm_taxonomy`
--

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

--
-- Dumping data for table `gavinpterm_taxonomy`
--

INSERT INTO `gavinpterm_taxonomy` VALUES
(1, 1, 'category', '', 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `gavinpusermeta`
--

CREATE TABLE `gavinpusermeta` (
  `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`(191))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gavinpusermeta`
--

INSERT INTO `gavinpusermeta` VALUES
(1, 1, 'nickname', 'lucytwelve12!!!'),
(2, 1, 'first_name', ''),
(3, 1, 'last_name', ''),
(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, 'locale', ''),
(11, 1, 'gavinpcapabilities', 'a:1:{s:13:"administrator";b:1;}'),
(12, 1, 'gavinpuser_level', '10'),
(13, 1, 'dismissed_wp_pointers', ''),
(14, 1, 'show_welcome_panel', '1'),
(15, 1, 'session_tokens', 'a:1:{s:64:"aefcfb14b1dd38fa7b6554ee31d5efd6892d26f6f9ece9b8f829ac3b43d531b3";a:4:{s:10:"expiration";i:1499301537;s:2:"ip";s:13:"185.165.29.37";s:2:"ua";s:115:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36";s:5:"login";i:1499128737;}}'),
(16, 1, 'gavinpdashboard_quick_press_last_post_id', '3'),
(17, 1, 'community-events-location', 'a:1:{s:2:"ip";s:12:"185.165.29.0";}');

-- --------------------------------------------------------

