Advertisement
Guest User

Wordpress User and User Meta Tables

a guest
Aug 18th, 2011
372
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.62 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.4.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Aug 19, 2011 at 04:10 AM
  7. -- Server version: 5.1.44
  8. -- PHP Version: 5.3.1
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `wp`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `wp_usermeta`
  21. --
  22.  
  23. DROP TABLE IF EXISTS `wp_usermeta`;
  24. CREATE TABLE IF NOT EXISTS `wp_usermeta` (
  25.   `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  26.   `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  27.   `meta_key` varchar(255) DEFAULT NULL,
  28.   `meta_value` longtext,
  29.   PRIMARY KEY (`umeta_id`),
  30.   KEY `user_id` (`user_id`),
  31.   KEY `meta_key` (`meta_key`)
  32. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
  33.  
  34. --
  35. -- Dumping data for table `wp_usermeta`
  36. --
  37.  
  38. INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
  39. (1, 1, 'first_name', ''),
  40. (2, 1, 'last_name', ''),
  41. (3, 1, 'nickname', 'admin'),
  42. (4, 1, 'description', ''),
  43. (5, 1, 'rich_editing', 'true'),
  44. (6, 1, 'comment_shortcuts', 'false'),
  45. (7, 1, 'admin_color', 'fresh'),
  46. (8, 1, 'use_ssl', '0'),
  47. (9, 1, 'show_admin_bar_front', 'true'),
  48. (10, 1, 'show_admin_bar_admin', 'false'),
  49. (11, 1, 'aim', ''),
  50. (12, 1, 'yim', ''),
  51. (13, 1, 'jabber', ''),
  52. (14, 1, 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'),
  53. (15, 1, 'wp_user_level', '10');
  54.  
  55. -- --------------------------------------------------------
  56.  
  57. --
  58. -- Table structure for table `wp_users`
  59. --
  60.  
  61. DROP TABLE IF EXISTS `wp_users`;
  62. CREATE TABLE IF NOT EXISTS `wp_users` (
  63.   `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  64.   `user_login` varchar(60) NOT NULL DEFAULT '',
  65.   `user_pass` varchar(64) NOT NULL DEFAULT '',
  66.   `user_nicename` varchar(50) NOT NULL DEFAULT '',
  67.   `user_email` varchar(100) NOT NULL DEFAULT '',
  68.   `user_url` varchar(100) NOT NULL DEFAULT '',
  69.   `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  70.   `user_activation_key` varchar(60) NOT NULL DEFAULT '',
  71.   `user_status` int(11) NOT NULL DEFAULT '0',
  72.   `display_name` varchar(250) NOT NULL DEFAULT '',
  73.   PRIMARY KEY (`ID`),
  74.   KEY `user_login_key` (`user_login`),
  75.   KEY `user_nicename` (`user_nicename`)
  76. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  77.  
  78. --
  79. -- Dumping data for table `wp_users`
  80. --
  81.  
  82. INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
  83. (1, 'admin', '$P$BIMg6qYzsT/hAvJsiJ97t1lv1UBPfM.', 'admin', 'test@test.com', '', '2011-08-19 04:08:25', '', 0, 'admin');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement