 MODIFY COLUMN time INT(10) NOT NULL DEFAULT '0';
 ---#
 
----# Updating messages body
-ALTER TABLE {$db_prefix}messages
-MODIFY COLUMN body TEXT NOT NULL;
----#
-
----# Updating personal_messages body
-ALTER TABLE {$db_prefix}personal_messages
-MODIFY COLUMN body TEXT NOT NULL;
----#
-
 ---# Updating pm_recipients is_new
 ALTER TABLE {$db_prefix}pm_recipients
 MODIFY COLUMN is_new TINYINT UNSIGNED NOT NULL DEFAULT '0';
 ---#
 
----# Updating pm_rules actions
-ALTER TABLE {$db_prefix}pm_rules
-MODIFY COLUMN actions TEXT NOT NULL;
----#
-
----# Updating pm_rules criteria
-ALTER TABLE {$db_prefix}pm_rules
-MODIFY COLUMN criteria TEXT NOT NULL;
----#
-
 ---# Updating pm_rules id_member
 ALTER TABLE {$db_prefix}pm_rules
 MODIFY COLUMN id_member MEDIUMINT UNSIGNED NOT NULL DEFAULT '0';

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

---# Updating sessions data
ALTER TABLE {$db_prefix}sessions
MODIFY COLUMN data TEXT NOT NULL;
---#

---# Updating settings value
ALTER TABLE {$db_prefix}settings
MODIFY COLUMN value TEXT NOT NULL;
---#

---# Updating subscriptions cost
ALTER TABLE {$db_prefix}subscriptions
MODIFY COLUMN cost TEXT NOT NULL;
---#

---# Updating subscriptions email_complete
ALTER TABLE {$db_prefix}subscriptions
MODIFY COLUMN email_complete TEXT NOT NULL;
---#

---# Updating themes value
ALTER TABLE {$db_prefix}themes
MODIFY COLUMN value TEXT NOT NULL;
---#

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

MODIFY COLUMN processed TINYINT NOT NULL DEFAULT '0';
---#

---# Updating members new_pm
ALTER TABLE {$db_prefix}members
MODIFY COLUMN new_pm TINYINT UNSIGNED NOT NULL DEFAULT '0';
---#

---# Updating members pm_ignore_list
ALTER TABLE {$db_prefix}members
MODIFY COLUMN pm_ignore_list VARCHAR(255) NOT NULL DEFAULT '';
---#

---# Updating member_logins id_member
ALTER TABLE {$db_prefix}member_logins
MODIFY COLUMN id_member MEDIUMINT NOT NULL DEFAULT '0';
