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

Timestamp:

11/23/2005 12:38:56 AM (19 years ago)

Author:

ryan

Message:

Add some defaults to avoid MySQL warnings.

File:

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

trunk/wp-admin/upgrade-schema.php

@@ -6 +6 @@
   cat_name varchar(55) NOT NULL default '',
   category_nicename varchar(200) NOT NULL default '',
-  category_description longtext NOT NULL,
+  category_description longtext NOT NULL default '',
   category_parent bigint(20) NOT NULL default '0',
   category_count bigint(20) NOT NULL default '0',
@@ -61 +61 @@
   link_updated datetime NOT NULL default '0000-00-00 00:00:00',
   link_rel varchar(255) NOT NULL default '',
-  link_notes mediumtext NOT NULL,
+  link_notes mediumtext NOT NULL default '',
   link_rss varchar(255) NOT NULL default '',
   PRIMARY KEY  (link_id),
@@ -106 +106 @@
   post_title text NOT NULL,
   post_category int(4) NOT NULL default '0',
-  post_excerpt text NOT NULL,
+  post_excerpt text NOT NULL default '',
   post_status enum('publish','draft','private','static','object','attachment') NOT NULL default 'publish',
   comment_status enum('open','closed','registered_only') NOT NULL default 'open',
@@ -112 +112 @@
   post_password varchar(20) NOT NULL default '',
   post_name varchar(200) NOT NULL default '',
-  to_ping text NOT NULL,
-  pinged text NOT NULL,
+  to_ping text NOT NULL default '',
+  pinged text NOT NULL default '',
   post_modified datetime NOT NULL default '0000-00-00 00:00:00',
   post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
-  post_content_filtered text NOT NULL,
+  post_content_filtered text NOT NULL default '',
   post_parent bigint(20) NOT NULL default '0',
   guid varchar(255) NOT NULL default '',
   menu_order int(11) NOT NULL default '0',
-  post_type varchar(100) NOT NULL,
-  post_mime_type varchar(100) NOT NULL,
+  post_type varchar(100) NOT NULL default '',
+  post_mime_type varchar(100) NOT NULL default '',
   comment_count bigint(20) NOT NULL default '0',
   PRIMARY KEY  (ID),