· 8 years ago · May 23, 2018, 03:22 PM
1CREATE TABLE IF NOT EXISTS `wp_users` (
2`ID` bigint(20) unsigned NOT NULL,
3 `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
4 `user_pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
5 `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
6 `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
7 `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
8 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9 `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
10 `user_status` int(11) NOT NULL DEFAULT '0',
11 `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
12) ENGINE=InnoDB AUTO_INCREMENT=478 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;