CREATE TABLE IF NOT EXISTS fusion_ranks (
rank_id smallint(5) unsigned NOT NULL auto_increment,
rank_title varchar(50) NOT NULL default '',
rank_image varchar(255) NOT NULL default '',
rank_post smallint(5) unsigned NOT NULL default '0',
rank_special tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (rank_id)
) TYPE=MyISAM;

ALTER TABLE fusion_users ADD user_rank smallint(5) unsigned NOT NULL default '0';