Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sure. Standard WP Users TABLE.
- --
- -- Table structure for table `wp_users`
- --
- CREATE TABLE `wp_users` (
- `ID` BIGINT(20) UNSIGNED NOT NULL,
- `user_login` VARCHAR(60) NOT NULL DEFAULT '',
- `user_pass` VARCHAR(64) NOT NULL DEFAULT '',
- `user_nicename` VARCHAR(50) NOT NULL DEFAULT '',
- `user_email` VARCHAR(100) NOT NULL DEFAULT '',
- `user_url` VARCHAR(100) NOT NULL DEFAULT '',
- `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `user_activation_key` VARCHAR(60) NOT NULL DEFAULT '',
- `user_status` INT(11) NOT NULL DEFAULT '0',
- `display_name` VARCHAR(250) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `wp_users`
- --
- 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
- (1, 'steve1', 'aabbccddeeff', 'steve', 'steve1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve1'),
- (2, 'steve2', 'aabbccddeeff', 'steve', 'steve2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve2'),
- (3, 'steve3', 'aabbccddeeff', 'steve', 'steve3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve3');
- -- --------------------------------------------------------
- --
- -- Table structure for table `wp_users2`
- --
- CREATE TABLE `wp_users2` (
- `ID` BIGINT(20) UNSIGNED NOT NULL,
- `user_login` VARCHAR(60) NOT NULL DEFAULT '',
- `user_pass` VARCHAR(64) NOT NULL DEFAULT '',
- `user_nicename` VARCHAR(50) NOT NULL DEFAULT '',
- `user_email` VARCHAR(100) NOT NULL DEFAULT '',
- `user_url` VARCHAR(100) NOT NULL DEFAULT '',
- `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `user_activation_key` VARCHAR(60) NOT NULL DEFAULT '',
- `user_status` INT(11) NOT NULL DEFAULT '0',
- `display_name` VARCHAR(250) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `wp_users2`
- --
- 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
- (1, 'steve1', 'aabbccddeeff', 'steve', 'steve1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve1'),
- (2, 'steve2', 'aabbccddeeff', 'steve', 'steve2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve2'),
- (3, 'steve3', 'aabbccddeeff', 'steve', 'steve3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'steve3');
- (4, 'jones1', 'aabbccddeeff', 'jones', 'jones1@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones1'),
- (5, 'jones2', 'aabbccddeeff', 'jones', 'jones2@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones2'),
- (6, 'jones3', 'aabbccddeeff', 'jones', 'jones3@gmail.com', '', '2014-12-02 22:15:31', '', 0, 'jones3');
- --
- -- Indexes for table `wp_users`
- --
- ALTER TABLE `wp_users`
- ADD PRIMARY KEY (`ID`), ADD KEY `user_login_key` (`user_login`), ADD KEY `user_nicename` (`user_nicename`);
- --
- -- Indexes for table `wp_users2`
- --
- ALTER TABLE `wp_users2`
- ADD PRIMARY KEY (`ID`), ADD KEY `user_login_key` (`user_login`), ADD KEY `user_nicename` (`user_nicename`);
- --
- -- AUTO_INCREMENT for table `wp_users`
- --
- ALTER TABLE `wp_users`
- MODIFY `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `wp_users2`
- --
- ALTER TABLE `wp_users2`
- MODIFY `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement