· 6 years ago · Mar 25, 2019, 07:02 PM
1/* Dump of table `users`
2 * ------------------------------------------------------------*/
3
4DROP TABLE IF EXISTS `users`;
5
6CREATE TABLE `users` (
7 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
8 `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
9 `user_pass` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
10 `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
11 `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
12 `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
13 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
14 `user_activation_key` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
15 `user_status` int(11) NOT NULL DEFAULT '0',
16 `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
17 PRIMARY KEY (`ID`),
18 KEY `user_login_key` (`user_login`),
19 KEY `user_nicename` (`user_nicename`)
20) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
21
22LOCK TABLES `users` WRITE;
23/*!40000 ALTER TABLE `users` DISABLE KEYS */;
24
25INSERT INTO `users` ( ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) VALUES ( 6, '', '', '', '', '', '', '', 0, '' );
26INSERT INTO `users` ( ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) VALUES ( 10, '', '', '', '', '', '', '', 0, '' );
27INSERT INTO `users` ( ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) VALUES ( 11, '', '', '', '', '', '', '', 0, '' );
28
29/*!40000 ALTER TABLE `users` ENABLE KEYS */;
30UNLOCK TABLES;