Späher Tool - Finale Version

[schnuffel12]

Fehler

SQL-Befehl:

erst DROP TABLE IF EXISTS `reports` dann CREATE TABLE IF NOT EXISTS `reports` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 230 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`title_image` varchar( 200 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`time` int( 25 ) NOT NULL ,
`type` varchar( 40 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`a_units` varchar( 350 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`b_units` varchar( 350 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`c_units` varchar( 350 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`d_units` varchar( 350 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`e_units` varchar( 350 ) CHARACTER SET latin1 COLLATE latin1_german1_ci default NULL ,
`agreement` varchar( 20 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`ram` varchar( 15 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`catapult` varchar( 40 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`message` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`to_user` int( 11 ) NOT NULL ,
`from_user` int( 11 ) NOT NULL ,
`to_village` int( 11 ) NOT NULL ,
`from_village` int( 11 ) NOT NULL ,
`receiver_userid` int( 11 ) NOT NULL ,
`is_new` int( 1 ) NOT NULL default '1',
`in_group` varchar( 40 ) CHARACTER SET latin1 COLLATE latin1_german1_ci default NULL ,
`luck` varchar( 6 ) CHARACTER SET latin1 COLLATE latin1_german1_ci default NULL ,
`moral` int( 6 ) default NULL ,
`wins` varchar( 15 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`hives` varchar( 100 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`see_def_units` int( 1 ) NOT NULL default '1',
`ally` int( 11 ) NOT NULL ,
`allyname` varchar( 200 ) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL ,
`from_username` varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL ,
`to_username` varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL ,
`barracks` int( 2 ) default '-1',
`farm` int( 2 ) default '-1',
`garage` int( 2 ) default '-1',
`iron` int( 2 ) default '-1',
`main` int( 2 ) default '-1',
`market` int( 2 ) default '-1',
`place` int( 2 ) default '-1',
`smith` int( 2 ) default '-1',
`snob` int( 2 ) default '-1',
`stable` int( 2 ) default '-1',
`stone` int( 2 ) default '-1',
`storage` int( 2 ) default '-1',
`wall` int( 2 ) default '-1',
`wood` int( 2 ) default '-1',
`geprueft` varchar( 11 ) COLLATE utf8_unicode_ci NOT NULL default '0',
`hide` int( 2 ) default '-1',
`r_wood` int( 20 ) default '-1',
`r_stone` int( 20 ) default '-1',
`r_iron` int( 20 ) default '-1',
PRIMARY KEY ( `id` ) ,
KEY `receiver_userid` ( `receiver_userid` ) ,
KEY `group` ( `in_group` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =188

das bekomm ich dann also antwort aber bei tab steht immer noch das selbe
Gruß