Harthas hat geschrieben:
[php]ALTER TABLE accounts ADD `kf_spiel` tinyint(4) NOT NULL default '0',
ADD `kf_lvl` tinyint(4) NOT NULL default '1',
ADD `kf_titel` text NOT NULL,
ADD `kf_day` int(11) NOT NULL default '0',
ADD `kf_newday` tinyint(4) NOT NULL default '0',
ADD `kf_tagesbericht` text NOT NULL,
ADD `kf_tagrelation` tinyint(4) NOT NULL default '0',
ADD `kf_einwohner` int(11) NOT NULL default '1000',
ADD `kf_palast` tinyint(4) NOT NULL default '0',
ADD `kf_kathedrale` tinyint(4) NOT NULL default '0',
ADD `kf_land` int(11) NOT NULL default '10000',
ADD `kf_landnutzung` int(11) NOT NULL default '0',
ADD `kf_land_kauf` tinyint(4) NOT NULL default '0',
ADD `kf_taler` int(11) NOT NULL default '2000',
ADD `kf_muehle` tinyint(4) NOT NULL default '1',
ADD `kf_marktplatz` tinyint(4) NOT NULL default '1',
ADD `kf_lagerhalle` tinyint(4) NOT NULL default '0',
ADD `kf_schmiede` tinyint(4) NOT NULL default '0',
ADD `kf_eisenmine` tinyint(4) NOT NULL default '0',
ADD `kf_kohlenmine` tinyint(4) NOT NULL default '0',
ADD `kf_salzmine` tinyint(4) NOT NULL default '0',
ADD `kf_steinbruch` tinyint(4) NOT NULL default '0',
ADD `kf_jaeger` tinyint(4) NOT NULL default '0',
ADD `kf_holzfaeller` tinyint(4) NOT NULL default '1',
ADD `kf_schaffarm` tinyint(4) NOT NULL default '0',
ADD `kf_tuchfabrik` tinyint(4) NOT NULL default '0',
ADD `kf_kleiderfabrik` tinyint(4) NOT NULL default '0',
ADD `kf_schweinefarm` tinyint(4) NOT NULL default '0',
ADD `kf_weinberg` tinyint(4) NOT NULL default '0',
ADD `kf_brennerei` tinyint(4) NOT NULL default '0',
ADD `kf_waffenfabrik` tinyint(4) NOT NULL default '0',
ADD `kf_goldmine` tinyint(4) NOT NULL default '0',
ADD `kf_edelsteinmine` tinyint(4) NOT NULL default '0',
ADD `kf_goldschmied` tinyint(4) NOT NULL default '0',
ADD `kf_korn` int(11) NOT NULL default '5000',
ADD `kf_salz` tinyint(4) NOT NULL default '0',
ADD `kf_alkohol` tinyint(4) NOT NULL default '0',
ADD `kf_waffen` tinyint(4) NOT NULL default '0',
ADD `kf_wildfleisch` tinyint(4) NOT NULL default '0',
ADD `kf_schweinefleisch` tinyint(4) NOT NULL default '0',
ADD `kf_wolle` tinyint(4) NOT NULL default '0',
ADD `kf_tuch` tinyint(4) NOT NULL default '0',
ADD `kf_kleider` tinyint(4) NOT NULL default '0',
ADD `kf_wein` tinyint(4) NOT NULL default '0',
ADD `kf_stahl` tinyint(4) NOT NULL default '0',
ADD `kf_stein` tinyint(4) NOT NULL default '0',
ADD `kf_eisen` tinyint(4) NOT NULL default '0',
ADD `kf_kohle` tinyint(4) NOT NULL default '0',
ADD `kf_holz` int(11) NOT NULL default '100',
ADD `kf_gold` tinyint(4) NOT NULL default '0',
ADD `kf_edelsteine` tinyint(4) NOT NULL default '0',
ADD `kf_schmuck` tinyint(4) NOT NULL default '0',
ADD `kf_justiz` tinyint(4) NOT NULL default '5',
ADD `kf_zoll` tinyint(4) NOT NULL default '10',
ADD `kf_steuer` tinyint(4) NOT NULL default '10',
ADD `kf_scout` tinyint(4) NOT NULL default '1',
ADD `kf_miliz` tinyint(4) NOT NULL default '3',
ADD `kf_infanterie` tinyint(4) NOT NULL default '0',
ADD `kf_kavallerie` tinyint(4) NOT NULL default '0',
ADD `kf_artellerie` tinyint(4) NOT NULL default '0',
ADD `kf_garde` tinyint(4) NOT NULL default '0',
ADD `kf_manoever` tinyint(4) NOT NULL default '0',
ADD `kf_krieg` tinyint(4) NOT NULL default '0',
ADD `kf_gegner` text NOT NULL;[/php]
Mal etwas anderes...
Wenn ich mir das oben so anschaue, wird mir ehrlich gesagt, verdammt schlecht... Wäre das alles nicht in einer seperaten Tabelle wesentlich besser aufgehoben, als dies alles noch in die Accountstabelle zu quetschen????
_________________
Das schwarze Schaf der LotGD-Community, 2. platzierter, beim Giga.de Homepage-Award 2007 und 1. platzierter beim German Web Award 2008.
PC-ACTION meint: "Sehr gut" für MotWD!
Mind of the White Dragon =>
http://my-logd.com/motwd