MVP Ranking AnnieRuru script

[FearlesS 1]

Using AnniRuru Weekly_MVP_Reward_1.0r script,

its working fine on mysql server (windows) but not working on CentOs mysql server.

 

below  error showing while creating tables

"rank" is not valid at this position, expecting an identifier.

 

/*
create table mvp_rank (
char_id int(11) primary key,
name varchar(23) default '',
mvp_kills int(11) default 0,
key (mvp_kills)
) engine = innodb;

create table mvp_rank_archive (
weekindex int(11),
rank tinyint(4) unsigned,
char_id int(11) unsigned default 0,
name varchar(23) default '',
points int(11) unsigned not null,
key (weekindex)
) engine = myisam;

create table mvp_rank_reward (
char_id int(11),
weekindex int(11),
rank tinyint(4) unsigned,
key (char_id)
) engine = innodb;
*/