 /******************************************************************************/
 ---# Adding pm_labels table...
 CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labels (
-  id_label int(10) unsigned NOT NULL auto_increment,
-  id_member mediumint(8) unsigned NOT NULL default '0',
-  name varchar(30) NOT NULL default '',
+  id_label INT(10) UNSIGNED AUTO_INCREMENT,
+  id_member MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
+  name VARCHAR(30) NOT NULL DEFAULT '',
   PRIMARY KEY (id_label)
 ) ENGINE=MyISAM;
 ---#
 
 ---# Adding pm_labeled_messages table...
 CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labeled_messages (
-  id_label int(10) unsigned NOT NULL default '0',
-  id_pm int(10) unsigned NOT NULL default '0',
+  id_label INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  id_pm INT(10) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (id_label, id_pm)
 ) ENGINE=MyISAM;
 ---#
 
 ---# Adding "in_inbox" column to pm_recipients
 ALTER TABLE {$db_prefix}pm_recipients
-ADD COLUMN in_inbox tinyint(3) NOT NULL default '1';
+ADD COLUMN in_inbox TINYINT(3) NOT NULL DEFAULT '1';
 ---#
 
 ---# Moving label info to new tables and updating rules...

list ($step_progress['total']) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);

$_GET['a'] = isset($_GET['a']) ? (int) $_GET['a'] : 0;
$step_progress['name'] = 'Converting legacy attachments';
$step_progress['current'] = $_GET['a'];


/******************************************************************************/
---# Altering the session_id columns...
ALTER TABLE {$db_prefix}log_online
CHANGE `session` `session` VARCHAR(64) NOT NULL DEFAULT '';

ALTER TABLE {$db_prefix}log_errors
CHANGE `session` `session` CHAR(64) NOT NULL DEFAULT '                                                                ';

ALTER TABLE {$db_prefix}sessions
CHANGE `session_id` `session_id` CHAR(64) NOT NULL;
---#

/******************************************************************************/
