Quote:
L 09/23/2011 - 23:26:17: [AMXX] Plugin says: Incorrect table definition; there can be only one auto column and it must be defined as a key
L 09/23/2011 - 23:26:17: [AMXX] Run time error 1 (plugin "acommands.amxx") - forced exit
|
PHP Code:
new const szQuery[] =
"CREATE TABLE IF NOT EXISTS players ( player_id INT(6) NOT NULL AUTO_INCREMENT,\
player_ip varchar(32),\
player_name varchar(32),\
player_auth varchar(32),\
player_country varchar(3),\
player_privileges int(2),\
rank_kills int(6),\
rank_deaths int(6),\
rank_headshots int(6),\
rank_skill int(6),\
rank_points int(6),\
ban_time int(6),\
ban_reason varchar(64),\
ban_admin varchar(32),\
mute_time int(6),\
mute_reason varchar(64),\
mute_admin varchar(32),\
last_online varchar(32))"