Changeset 2200

Timestamp:

02/02/2005 09:41:06 AM (21 years ago)

Author:

saxmatt

Message:

We didn't know how big it'd get :)

Location:

trunk/wp-admin

Files:

• upgrade-functions.php (modified) (1 diff)
• upgrade-schema.php (modified) (3 diffs)

trunk/wp-admin/upgrade-functions.php

@@ -135 +135 @@
     }
 
-    // First we need to enlarge option_value so it can hold larger values:
-    $wpdb->query("ALTER TABLE `$wpdb->options` CHANGE `option_value` `option_value` TEXT NOT NULL");
-
-    $wpdb->query("ALTER TABLE `$wpdb->comments` CHANGE `comment_author_url` `comment_author_url` VARCHAR( 200 ) NOT NULL");
 }
 

trunk/wp-admin/upgrade-schema.php

@@ -6 +6 @@
   cat_name varchar(55) NOT NULL default '',
   category_nicename varchar(200) NOT NULL default '',
-  category_description text NOT NULL,
+  category_description lengtext NOT NULL,
   category_parent int(4) NOT NULL default '0',
   PRIMARY KEY  (cat_ID),
-  UNIQUE KEY cat_name (cat_name),
   KEY category_nicename (category_nicename)
 );
@@ -103 +102 @@
   post_date datetime NOT NULL default '0000-00-00 00:00:00',
   post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
-  post_content text NOT NULL,
+  post_content longtext NOT NULL,
   post_title text NOT NULL,
   post_category int(4) NOT NULL default '0',
@@ -145 +144 @@
   user_activation_key varchar(60) NOT NULL default '',
   user_status int(11) NOT NULL default '0',
-  user_description TEXT NOT NULL default '',
+  user_description longtext NOT NULL default '',
   PRIMARY KEY  (ID),
   UNIQUE KEY user_login (user_login)