 MODIFY COLUMN processed TINYINT NOT NULL DEFAULT '0';
 ---#
 
----# Updating log_subscribed
-ALTER TABLE {$db_prefix}log_subscribed
-MODIFY COLUMN pending_details TEXT NOT NULL;
----#
-
----# Updating mail_queue
-ALTER TABLE {$db_prefix}mail_queue
-MODIFY COLUMN headers TEXT NOT NULL;
----#
-
----# Updating membergroups
-ALTER TABLE {$db_prefix}membergroups
-MODIFY COLUMN description TEXT NOT NULL;
----#
-
 ---# Updating members new_pm
 ALTER TABLE {$db_prefix}members
 MODIFY COLUMN new_pm TINYINT UNSIGNED NOT NULL DEFAULT '0';
 ---#
 
----# Updating members buddy_list
-ALTER TABLE {$db_prefix}members
-MODIFY COLUMN buddy_list TEXT NOT NULL;
----#
-
 ---# Updating members pm_ignore_list
 ALTER TABLE {$db_prefix}members
 MODIFY COLUMN pm_ignore_list VARCHAR(255) NOT NULL DEFAULT '';
 ---#
 
----# Updating members signature
-ALTER TABLE {$db_prefix}members
-MODIFY COLUMN signature TEXT NOT NULL;
----#
-
 ---# Updating member_logins id_member
 ALTER TABLE {$db_prefix}member_logins
 MODIFY COLUMN id_member MEDIUMINT NOT NULL DEFAULT '0';

---#

/******************************************************************************/
--- Legacy column data
/******************************************************************************/
---# Updating admin_info_files
ALTER TABLE {$db_prefix}admin_info_files
MODIFY COLUMN data TEXT NOT NULL;
---#

---# Updating ban_groups
ALTER TABLE {$db_prefix}ban_groups
MODIFY COLUMN notes TEXT NOT NULL;
---#

---# Updating boards
ALTER TABLE {$db_prefix}boards
MODIFY COLUMN description TEXT NOT NULL;
---#

---# Updating board_permissions
ALTER TABLE {$db_prefix}board_permissions
MODIFY COLUMN id_profile SMALLINT UNSIGNED NOT NULL DEFAULT '0';
---#

---# Updating custom_fields
ALTER TABLE {$db_prefix}custom_fields
MODIFY COLUMN enclose TEXT NOT NULL;
---#

---# Updating log_actions
ALTER TABLE {$db_prefix}log_actions
MODIFY COLUMN extra TEXT NOT NULL;
---#

---# Updating log_comments
ALTER TABLE {$db_prefix}log_comments
MODIFY COLUMN body TEXT NOT NULL;
---#

---# Updating log_digest id_topic
ALTER TABLE {$db_prefix}log_digest
MODIFY COLUMN id_topic MEDIUMINT UNSIGNED NOT NULL DEFAULT '0';

MODIFY COLUMN last_update INT UNSIGNED NOT NULL DEFAULT '0';
---#

/******************************************************************************/
--- Clean up indexes
/******************************************************************************/
