 /******************************************************************************/
 ---# 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...

/******************************************************************************/
---# Creating likes table.
CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes (
  id_member mediumint(8) unsigned NOT NULL default '0',
  content_type char(6) default '',
  content_id int(10) unsigned NOT NULL default '0',
  like_time int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (content_id, content_type, id_member),
  INDEX content (content_id, content_type),
  INDEX liker (id_member)
) ENGINE=MyISAM;
---#

---# Adding count to the messages table.
ALTER TABLE {$db_prefix}messages
ADD COLUMN likes smallint(5) unsigned NOT NULL DEFAULT '0';
---#

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

INSERT INTO {$db_prefix}settings (variable, value) VALUES ('additional_options_collapsable', '1');
---#

---# Adding new "DEFAULTMaxListItems" setting
INSERT INTO {$db_prefix}settings (variable, value) VALUES ('DEFAULTMaxListItems', '15');
---#

---# Adding new "loginHistoryDays" setting
