 MODIFY COLUMN id_msg INT(10) UNSIGNED NOT NULL DEFAULT '0';
 ---#
 
----# Updating log_errors url
-ALTER TABLE {$db_prefix}log_errors
-MODIFY COLUMN url TEXT NOT NULL;
----#
-
----# Updating log_errors message
-ALTER TABLE {$db_prefix}log_errors
-MODIFY COLUMN message TEXT NOT NULL;
----#
-
----# Updating log_group_requests
-ALTER TABLE {$db_prefix}log_group_requests
-MODIFY COLUMN reason TEXT NOT NULL;
----#
-
----# Updating log_member_notices
-ALTER TABLE {$db_prefix}log_member_notices
-MODIFY COLUMN body TEXT NOT NULL;
----#
-
----# Updating log_packages steps
-ALTER TABLE {$db_prefix}log_packages
-MODIFY COLUMN failed_steps TEXT NOT NULL;
----#
-
----# Updating log_packages db_changes
-ALTER TABLE {$db_prefix}log_packages
-MODIFY COLUMN db_changes TEXT NOT NULL;
----#
-
 ---# Updating log_reported
 ALTER TABLE {$db_prefix}log_reported
 MODIFY COLUMN body MEDIUMTEXT NOT NULL;

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';

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

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