Changeset 2631 for trunk/wp-admin/upgrade-schema.php

Timestamp:

06/12/2005 08:49:13 PM (20 years ago)

Author:

matt

Message:

Beginning of user system overhaul, TODO: update all code that deals with user data

File:

• trunk/wp-admin/upgrade-schema.php (modified) (2 diffs)

trunk/wp-admin/upgrade-schema.php

@@ -92 +92 @@
   post_id bigint(20) NOT NULL default '0',
   meta_key varchar(255) default NULL,
-  meta_value text,
+  meta_value longtext,
   PRIMARY KEY  (meta_id),
   KEY post_id (post_id),
@@ -145 +145 @@
   user_status int(11) NOT NULL default '0',
   user_description longtext NOT NULL default '',
+  display_name varchar(250) NOT NULL default '',
   PRIMARY KEY  (ID),
   UNIQUE KEY user_login (user_login)
+);
+CREATE TABLE $wpdb->usermeta (
+  umeta_id bigint(20) NOT NULL auto_increment,
+  user_id bigint(20) NOT NULL default '0',
+  meta_key varchar(255) default NULL,
+  meta_value longtext,
+  PRIMARY KEY  (umeta_id),
+  KEY user_id (user_id),
+  KEY meta_key (meta_key)
 );";