[Marco van Herwaarden]

Try running the following queries, insert table prefix if needed:
[sql]CREATE TABLE maf_application (
appid int(10) NOT NULL auto_increment,
userid int(10) NOT NULL default 0,
email varchar(250) NOT NULL default '',
fullname varchar(250) NOT NULL default '',
age tinyint(4) NOT NULL default 0,
location varchar(250) NOT NULL default '',
timezone varchar(25) NOT NULL default '',
position varchar(250) NOT NULL default '',
why_them mediumtext NOT NULL,
what_they_bring mediumtext NOT NULL,
pactivity mediumtext NOT NULL,
globally_pactivity mediumtext NOT NULL,
plus_site mediumtext NOT NULL,
neg_site mediumtext NOT NULL,
better_than_rest mediumtext NOT NULL,
more mediumtext NOT NULL,
application_time int(10) NOT NULL default 0,
auto_mailed tinyint(4) default NULL,
PRIMARY KEY (appid)
);[/sql]
[sql]CREATE TABLE maf_ratings (
ratingid int(10) NOT NULL auto_increment,
appid int(10) NOT NULL default 0,
userid int(10) NOT NULL default 0,
rating tinyint(4) NOT NULL default 0,
additional_comments mediumtext NOT NULL,
timestamp int(10) NOT NULL default 0,
PRIMARY KEY (ratingid),
KEY appid (appid),
KEY appid_2 (appid)
);[/sql]

@sabre
Why are you not using TABLE_PREFIX? and why the same KEY twice on the second table?