Aktion kann nicht ausgeführt werden!

Code:
Fehler



SQL-Befehl:



-- phpMyAdmin SQL Dump

-- version 2.9.0.1

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Erstellungszeit: 19. Mai 2009 um 16:03

-- Server Version: 5.0.24

-- PHP-Version: 4.4.4

-- 

-- Datenbank: `lan`

-- 

-- --------------------------------------------------------

-- 

-- Tabellenstruktur für Tabelle `users`

-- 

CREATE TABLE `users` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`username` varchar( 150 ) COLLATE utf8_unicode_ci default NULL ,

`password` varchar( 32 ) COLLATE utf8_unicode_ci NOT NULL default '',

`banned` enum( 'Y', 'N' ) COLLATE utf8_unicode_ci NOT NULL default 'N',

`villages` int( 10 ) NOT NULL ,

`points` int( 20 ) NOT NULL ,

`ennobled_by` varchar( 90 ) COLLATE utf8_unicode_ci NOT NULL ,

`ally` int( 11 ) NOT NULL default '-1',

`ally_titel` varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL ,

`ally_found` int( 1 ) NOT NULL default '0',

`ally_lead` int( 1 ) NOT NULL default '0',

`ally_invite` int( 1 ) NOT NULL default '0',

`ally_diplomacy` int( 1 ) NOT NULL default '0',

`ally_mass_mail` int( 1 ) NOT NULL default '0',

`rang` int( 11 ) NOT NULL ,

`villages_mode` varchar( 25 ) COLLATE utf8_unicode_ci NOT NULL default 'prod',

`attacks` int( 5 ) default '0',

`new_report` int( 1 ) NOT NULL default '0',

`new_mail` int( 1 ) default '0',

`market_sell` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL default 'all',

`market_buy` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL default 'all',

`market_ratio_max` varchar( 5 ) COLLATE utf8_unicode_ci NOT NULL default '3',

`killed_units_att` int( 25 ) NOT NULL ,

`killed_units_att_rank` int( 11 ) NOT NULL ,

`killed_units_def` int( 25 ) NOT NULL ,

`killed_units_def_rank` int( 25 ) NOT NULL ,

`killed_units_altogether` int( 25 ) NOT NULL ,

`killed_units_altogether_rank` int( 11 ) NOT NULL ,

`do_action` varchar( 32 ) COLLATE utf8_unicode_ci NOT NULL ,

`last_activity` int( 35 ) NOT NULL ,

`birthday` varchar( 10 ) COLLATE utf8_unicode_ci NOT NULL ,

`vacation_id` int( 11 ) NOT NULL default '-1',

`vacation_name` varchar( 150 ) COLLATE utf8_unicode_ci NOT NULL ,

`vacation_accept` int( 1 ) NOT NULL default '0',

`b_day` int( 2 ) NOT NULL ,

`b_month` int( 2 ) NOT NULL ,

`b_year` int( 4 ) NOT NULL ,

`sex` enum( 'f', 'm', 'x' ) COLLATE utf8_unicode_ci NOT NULL default 'x',

`home` varchar( 150 ) COLLATE utf8_unicode_ci NOT NULL ,

`image` varchar( 20 ) COLLATE utf8_unicode_ci NOT NULL ,

`personal_text` text COLLATE utf8_unicode_ci NOT NULL ,

`window_width` int( 4 ) NOT NULL default '840',

`show_toolbar` int( 1 ) NOT NULL default '1',

`dyn_menu` int( 1 ) NOT NULL default '1',

`confirm_queue` int( 1 ) NOT NULL default '1',

`map_size` int( 2 ) NOT NULL default '9',

`memo` text COLLATE utf8_unicode_ci NOT NULL ,

`map_reload` text COLLATE utf8_unicode_ci NOT NULL ,

`graphical_overwiev` tinyint( 1 ) NOT NULL default '1',

`overview` varchar( 5 ) COLLATE utf8_unicode_ci NOT NULL default 'new',

`stufen` varchar( 5 ) COLLATE utf8_unicode_ci NOT NULL default 'yes',

`winter` varchar( 30 ) COLLATE utf8_unicode_ci NOT NULL ,

PRIMARY KEY ( `id` ) ,

KEY `username` ( `username` ) ,

KEY `rang` ( `rang` ) ,

KEY `vacation_id` ( `vacation_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =5;



MySQL meldet: Dokumentation

#1050 - Table 'users' already exists