rnagle
/ wpdb_default_tables.sql
Last active
March 28, 2024 22:37
Default WordPress Database Table Create Statements
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP TABLE IF EXISTS wp_users; | |
| CREATE TABLE wp_users ( | |
| ID bigint(20) unsigned NOT NULL auto_increment, | |
| 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 '', |