Advertisement
Guest User

wp_users table

a guest
Dec 10th, 2015
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.37 KB | None | 0 0
  1. Sure. Standard WP Users TABLE.
  2.  
  3. --
  4. -- Table structure for table `wp_users`
  5. --
  6.  
  7. CREATE TABLE `wp_users` (
  8. `ID` BIGINT(20) UNSIGNED NOT NULL,
  9.   `user_login` VARCHAR(60) NOT NULL DEFAULT '',
  10.   `user_pass` VARCHAR(64) NOT NULL DEFAULT '',
  11.   `user_nicename` VARCHAR(50) NOT NULL DEFAULT '',
  12.   `user_email` VARCHAR(100) NOT NULL DEFAULT '',
  13.   `user_url` VARCHAR(100) NOT NULL DEFAULT '',
  14.   `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  15.   `user_activation_key` VARCHAR(60) NOT NULL DEFAULT '',
  16.   `user_status` INT(11) NOT NULL DEFAULT '0',
  17.   `display_name` VARCHAR(250) NOT NULL DEFAULT ''
  18. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  19.  
  20. --
  21. -- Dumping data for table `wp_users`
  22. --
  23.  
  24. 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
  25. (1, 'steve1', 'aabbccddeeff', 'steve', 'steve1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve1'),
  26. (2, 'steve2', 'aabbccddeeff', 'steve', 'steve2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve2'),
  27. (3, 'steve3', 'aabbccddeeff', 'steve', 'steve3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve3');
  28.  
  29. -- --------------------------------------------------------
  30.  
  31. --
  32. -- Table structure for table `wp_users2`
  33. --
  34.  
  35. CREATE TABLE `wp_users2` (
  36. `ID` BIGINT(20) UNSIGNED NOT NULL,
  37.   `user_login` VARCHAR(60) NOT NULL DEFAULT '',
  38.   `user_pass` VARCHAR(64) NOT NULL DEFAULT '',
  39.   `user_nicename` VARCHAR(50) NOT NULL DEFAULT '',
  40.   `user_email` VARCHAR(100) NOT NULL DEFAULT '',
  41.   `user_url` VARCHAR(100) NOT NULL DEFAULT '',
  42.   `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  43.   `user_activation_key` VARCHAR(60) NOT NULL DEFAULT '',
  44.   `user_status` INT(11) NOT NULL DEFAULT '0',
  45.   `display_name` VARCHAR(250) NOT NULL DEFAULT ''
  46. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  47.  
  48. --
  49. -- Dumping data for table `wp_users2`
  50. --
  51.  
  52. INSERT INTO `wp_users2` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
  53. (1, 'steve1', 'aabbccddeeff', 'steve', 'steve1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve1'),
  54. (2, 'steve2', 'aabbccddeeff', 'steve', 'steve2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve2'),
  55. (3, 'steve3', 'aabbccddeeff', 'steve', 'steve3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve3');
  56. (4, 'jones1', 'aabbccddeeff', 'jones', 'jones1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones1'),
  57. (5, 'jones2', 'aabbccddeeff', 'jones', 'jones2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones2'),
  58. (6, 'jones3', 'aabbccddeeff', 'jones', 'jones3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones3');
  59.  
  60.  
  61. --
  62. -- Indexes for table `wp_users`
  63. --
  64. ALTER TABLE `wp_users`
  65.  ADD PRIMARY KEY (`ID`), ADD KEY `user_login_key` (`user_login`), ADD KEY `user_nicename` (`user_nicename`);
  66.  
  67. --
  68. -- Indexes for table `wp_users2`
  69. --
  70. ALTER TABLE `wp_users2`
  71.  ADD PRIMARY KEY (`ID`), ADD KEY `user_login_key` (`user_login`), ADD KEY `user_nicename` (`user_nicename`);
  72.  
  73. --
  74. -- AUTO_INCREMENT for table `wp_users`
  75. --
  76. ALTER TABLE `wp_users`
  77. MODIFY `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
  78. --
  79. -- AUTO_INCREMENT for table `wp_users2`
  80. --
  81. ALTER TABLE `wp_users2`
  82. MODIFY `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement