Advertisement
Guest User

Untitled

a guest
Mar 19th, 2013
1,413
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.07 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `wp_users` (
  2.   `ID` bigint(20) unsigned NOT NULL auto_increment,
  3.   `user_login` varchar(60) NOT NULL default '',
  4.   `user_pass` varchar(64) NOT NULL default '',
  5.   `user_nicename` varchar(50) NOT NULL default '',
  6.   `user_email` varchar(100) NOT NULL default '',
  7.   `user_url` varchar(100) NOT NULL default '',
  8.   `user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
  9.   `user_activation_key` varchar(60) NOT NULL default '',
  10.   `user_status` int(11) NOT NULL default '0',
  11.   `display_name` varchar(250) NOT NULL default '',
  12.   PRIMARY KEY  (`ID`),
  13.   KEY `user_login_key` (`user_login`),
  14.   KEY `user_nicename` (`user_nicename`)
  15. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=118 ;
  16.  
  17.  
  18. CREATE TABLE IF NOT EXISTS `wp_usermeta` (
  19.   `umeta_id` bigint(20) NOT NULL auto_increment,
  20.   `user_id` bigint(20) NOT NULL default '0',
  21.   `meta_key` varchar(255) default NULL,
  22.   `meta_value` longtext,
  23.   PRIMARY KEY  (`umeta_id`),
  24.   KEY `user_id` (`user_id`),
  25.   KEY `meta_key` (`meta_key`)
  26. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1127 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement