 #
 
 CREATE TABLE {$db_prefix}background_tasks (
-  id_task int(10) unsigned NOT NULL auto_increment,
-  task_file varchar(255) NOT NULL default '',
-  task_class varchar(255) NOT NULL default '',
-  task_data mediumtext NOT NULL,
-  claimed_time int(10) unsigned NOT NULL default '0',
+  id_task INT(10) UNSIGNED AUTO_INCREMENT,
+  task_file VARCHAR(255) NOT NULL DEFAULT '',
+  task_class VARCHAR(255) NOT NULL DEFAULT '',
+  task_data MEDIUMTEXT NOT NULL,
+  claimed_time INT(10) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (id_task)
 ) ENGINE={$engine};
 

#

CREATE TABLE {$db_prefix}log_banned (
  id_ban_log mediumint(8) unsigned NOT NULL auto_increment,
  id_member mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  email varchar(255) NOT NULL default '',
  log_time int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_ban_log),
  KEY log_time (log_time)
) ENGINE={$engine};

#

#

CREATE TABLE {$db_prefix}message_icons (
  id_icon SMALLINT(5) UNSIGNED AUTO_INCREMENT,
  title VARCHAR(80) NOT NULL DEFAULT '',
  filename VARCHAR(80) NOT NULL DEFAULT '',
  id_board SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  icon_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (id_icon),
  INDEX idx_id_board (id_board)
) ENGINE={$engine};

#
