Loggin-Fehler

[Tayflore]

KK....

Users

id int(11) Nein auto_increment
username varchar(150) utf8_unicode_ci Ja NULL
password varchar(32) utf8_unicode_ci Nein
banned enum('Y', 'N') utf8_unicode_ci Nein N
villages int(10) Nein
points int(20) Nein
ennobled_by varchar(90) utf8_unicode_ci Nein
ally int(11) Nein -1
ally_titel varchar(200) utf8_unicode_ci Nein
ally_found int(1) Nein 0
ally_lead int(1) Nein 0
ally_invite int(1) Nein 0
ally_diplomacy int(1) Nein 0
ally_mass_mail int(1) Nein 0
rang int(11) Nein
villages_mode varchar(25) utf8_unicode_ci Nein prod
attacks int(5) Ja 0
new_report int(1) Nein 0
new_mail int(1) Ja 0
market_sell varchar(10) utf8_unicode_ci Nein all
market_buy varchar(10) utf8_unicode_ci Nein all
market_ratio_max varchar(5) utf8_unicode_ci Nein 3
killed_units_att int(25) Nein
killed_units_att_rank int(11) Nein
killed_units_def int(25) Nein
killed_units_def_rank int(25) Nein
killed_units_altogether int(25) Nein
killed_units_altogether_rank int(11) Nein
do_action varchar(32) utf8_unicode_ci Nein
last_activity int(35) Nein
birthday varchar(10) utf8_unicode_ci Nein
vacation_id int(11) Nein -1
vacation_name varchar(150) utf8_unicode_ci Nein
vacation_accept int(1) Nein 0
b_day int(2) Nein
b_month int(2) Nein
b_year int(4) Nein
sex enum('f', 'm', 'x') utf8_unicode_ci Nein x
home varchar(150) utf8_unicode_ci Nein
image varchar(20) utf8_unicode_ci Nein
personal_text text utf8_unicode_ci Nein
window_width int(4) Nein 840
show_toolbar int(1) Nein 1
dyn_menu int(1) Nein 1
confirm_queue int(1) Nein 1
map_size int(2) Nein 9
memo text utf8_unicode_ci Nein
map_reload text utf8_unicode_ci Nein
graphical_overwiev tinyint(1) Nein 1
overview varchar(5) utf8_unicode_ci Nein new
stufen varchar(5) utf8_unicode_ci Nein yes
winter varchar(30) utf8_unicode_ci Nein

Alle auswählen / Auswahl entfernen markierte:

Unnd bei Village:

Code:

Fehler

SQL-Befehl:  

SHOW INDEX FROM `villages` ;


MySQL meldet:  
#145 - Table '.\lan\villages' is marked as crashed and should be repaired