Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. /* Dump of table `users`
  2. * ------------------------------------------------------------*/
  3.  
  4. DROP TABLE IF EXISTS `users`;
  5.  
  6. CREATE 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.  
  22. LOCK TABLES `users` WRITE;
  23. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  24.  
  25. INSERT 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, '' );
  26. INSERT 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, '' );
  27. INSERT 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 */;
  30. UNLOCK TABLES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement