1-- phpMyAdmin SQL Dump 2-- version 4.0.10.7 3-- http://www.phpmyadmin.net 4-- 5-- Host: localhost:3306 6-- Generation Time: Feb 10, 2016 at 02:02 PM 7-- Server version: 10.0.23-MariaDB 8-- PHP Version: 5.4.31 9 10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 11SET time_zone = "+00:00"; 12 13 14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17/*!40101 SET NAMES utf8 */; 18 19-- 20-- Database: `dokuwiki_wp240` 21-- 22 23-- -------------------------------------------------------- 24 25-- 26-- Table structure for table `wpvk_usermeta` 27-- 28 29CREATE TABLE IF NOT EXISTS `wpvk_usermeta` ( 30 `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 31 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', 32 `meta_key` varchar(255) DEFAULT NULL, 33 `meta_value` longtext, 34 PRIMARY KEY (`umeta_id`), 35 KEY `user_id` (`user_id`), 36 KEY `meta_key` (`meta_key`(191)) 37) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ; 38 39-- 40-- Dumping data for table `wpvk_usermeta` 41-- 42 43INSERT INTO `wpvk_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES 44(1, 1, 'nickname', 'admin'), 45(2, 1, 'first_name', 'First'), 46(3, 1, 'last_name', 'Last'), 47(4, 1, 'description', ''), 48(5, 1, 'rich_editing', 'true'), 49(6, 1, 'comment_shortcuts', 'false'), 50(7, 1, 'admin_color', 'fresh'), 51(8, 1, 'use_ssl', '0'), 52(9, 1, 'show_admin_bar_front', 'true'), 53(10, 1, 'wpvk_capabilities', 'a:1:{s:13:"administrator";b:1;}'), 54(11, 1, 'wpvk_user_level', '10'), 55(12, 1, 'dismissed_wp_pointers', ''), 56(13, 1, 'show_welcome_panel', '1'), 57(14, 1, 'session_tokens', 'a:1:{s:64:"3e9f99a7068bf3fb79f50e111b6ef10f599beb466c27152205d4b89360c5004d";a:4:{s:10:"expiration";i:1456340157;s:2:"ip";s:12:"86.56.56.217";s:2:"ua";s:104:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.82 Safari/537.36";s:5:"login";i:1455130557;}}'), 58(15, 1, 'wpvk_dashboard_quick_press_last_post_id', '3'), 59(16, 2, 'nickname', 'test1'), 60(17, 2, 'first_name', 'Test1'), 61(18, 2, 'last_name', 'Subscriber'), 62(19, 2, 'description', ''), 63(20, 2, 'rich_editing', 'true'), 64(21, 2, 'comment_shortcuts', 'false'), 65(22, 2, 'admin_color', 'fresh'), 66(23, 2, 'use_ssl', '0'), 67(24, 2, 'show_admin_bar_front', 'true'), 68(25, 2, 'wpvk_capabilities', 'a:1:{s:10:"subscriber";b:1;}'), 69(26, 2, 'wpvk_user_level', '0'), 70(27, 2, 'dismissed_wp_pointers', ''), 71(28, 3, 'nickname', 'test2'), 72(29, 3, 'first_name', 'Test2'), 73(30, 3, 'last_name', 'Contributor'), 74(31, 3, 'description', ''), 75(32, 3, 'rich_editing', 'true'), 76(33, 3, 'comment_shortcuts', 'false'), 77(34, 3, 'admin_color', 'fresh'), 78(35, 3, 'use_ssl', '0'), 79(36, 3, 'show_admin_bar_front', 'true'), 80(37, 3, 'wpvk_capabilities', 'a:1:{s:11:"contributor";b:1;}'), 81(38, 3, 'wpvk_user_level', '1'), 82(39, 3, 'dismissed_wp_pointers', ''), 83(40, 4, 'nickname', 'test3'), 84(41, 4, 'first_name', 'Test3'), 85(42, 4, 'last_name', 'Author'), 86(43, 4, 'description', ''), 87(44, 4, 'rich_editing', 'true'), 88(45, 4, 'comment_shortcuts', 'false'), 89(46, 4, 'admin_color', 'fresh'), 90(47, 4, 'use_ssl', '0'), 91(48, 4, 'show_admin_bar_front', 'true'), 92(49, 4, 'wpvk_capabilities', 'a:1:{s:6:"author";b:1;}'), 93(50, 4, 'wpvk_user_level', '2'), 94(51, 4, 'dismissed_wp_pointers', ''); 95 96-- -------------------------------------------------------- 97 98-- 99-- Table structure for table `wpvk_users` 100-- 101 102CREATE TABLE IF NOT EXISTS `wpvk_users` ( 103 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 104 `user_login` varchar(60) NOT NULL DEFAULT '', 105 `user_pass` varchar(255) NOT NULL DEFAULT '', 106 `user_nicename` varchar(50) NOT NULL DEFAULT '', 107 `user_email` varchar(100) NOT NULL DEFAULT '', 108 `user_url` varchar(100) NOT NULL DEFAULT '', 109 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 110 `user_activation_key` varchar(255) NOT NULL DEFAULT '', 111 `user_status` int(11) NOT NULL DEFAULT '0', 112 `display_name` varchar(250) NOT NULL DEFAULT '', 113 PRIMARY KEY (`ID`), 114 KEY `user_login_key` (`user_login`), 115 KEY `user_nicename` (`user_nicename`) 116) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; 117 118-- 119-- Dumping data for table `wpvk_users` 120-- 121 122INSERT INTO `wpvk_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES 123(1, 'admin', '$P$BlO2X5nM.djjfsPjOBHz97GHZmpBRr.', 'admin', 'admin@example.com', '', '2016-02-10 18:55:26', '', 0, 'admin'), 124(2, 'test1', '$P$B3BfWySh.ymDeURK0OXMFo4vh4JprO0', 'test1', 'test1@example.com', '', '2016-02-10 18:57:47', '', 0, 'Test1 Subscriber'), 125(3, 'test2', '$P$BMNEUEo5nalKEswryuP69KXEfz8Y.z.', 'test2', 'test2@example.com', '', '2016-02-10 18:58:32', '', 0, 'Test2 Contributor'), 126(4, 'test3', '$P$B2PP3AP6NF/jLO0HYu3xf577rBnp2j.', 'test3', 'test3@example.com', '', '2016-02-10 18:59:19', '', 0, 'Test3 Author'); 127 128/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 129/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 130/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 131