19.05.2009, 15:08
da steht aber dann das
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