This is a Fan-Test-Site for MySQL for Birth-of-the-Emp. It's created by rainer = Reginald.

Table "buildings" - field definitons

`Nr` int(3) DEFAULT NULL,
`Race` int(1) DEFAULT NULL,
`BuildingNameGerman` varchar(37) DEFAULT NULL,
`BuildingNameEnglish` varchar(38) DEFAULT NULL,
`DescriptionGerman` varchar(543) DEFAULT NULL,
`DescriptionEnglish` varchar(465) DEFAULT NULL,
`upgradeable` int(1) DEFAULT NULL,
`GraphicFile` varchar(12) DEFAULT NULL,
`maxpersystemnumber` int(1) DEFAULT NULL,
`maxpersystemID` int(3) DEFAULT NULL,
`maxperempirenumber` int(1) DEFAULT NULL,
`maxperempireID` int(3) DEFAULT NULL,
`onlyhomesystem` int(1) DEFAULT NULL,
`onlyowncolony` int(1) DEFAULT NULL,
`onlyminorracesystem` int(1) DEFAULT NULL,
`onlyconqueredsystem` int(1) DEFAULT NULL,
`onlybuildableinSystem` varchar(12) DEFAULT NULL,
`needminhabitantsinsystem` int(3) DEFAULT NULL,
`minpersystemnumber` int(1) DEFAULT NULL,
`minpersystemID` int(3) DEFAULT NULL,
`minperempirenumber` int(1) DEFAULT NULL,
`minperempireID` int(1) DEFAULT NULL,
`reallyonlyrace` int(1) DEFAULT NULL,
`Aplanettype` int(1) DEFAULT NULL,
`Bplanettype` int(1) DEFAULT NULL,
`Cplanettype` int(1) DEFAULT NULL,
`Eplanettype` int(1) DEFAULT NULL,
`Fplanettype` int(1) DEFAULT NULL,
`Gplanettype` int(1) DEFAULT NULL,
`Hplanettype` int(1) DEFAULT NULL,
`Iplanettype` int(1) DEFAULT NULL,
`Jplanettype` int(1) DEFAULT NULL,
`Kplanettype` int(1) DEFAULT NULL,
`Lplanettype` int(1) DEFAULT NULL,
`Mplanettype` int(1) DEFAULT NULL,
`Nplanettype` int(1) DEFAULT NULL,
`Oplanettype` int(1) DEFAULT NULL,
`Pplanettype` int(1) DEFAULT NULL,
`Qplanettype` int(1) DEFAULT NULL,
`Rplanettype` int(1) DEFAULT NULL,
`Splanettype` int(1) DEFAULT NULL,
`Tplanettype` int(1) DEFAULT NULL,
`Yplanettype` int(1) DEFAULT NULL,
`Bio` int(2) DEFAULT NULL,
`Energy` int(2) DEFAULT NULL,
`Comp` int(2) DEFAULT NULL,
`Prop` int(1) DEFAULT NULL,
`Constr` int(1) DEFAULT NULL,
`Weap` int(2) DEFAULT NULL,
`Industryneedresources` int(5) DEFAULT NULL,
`Energyneedresources` int(4) DEFAULT NULL,
`Titanneedresources` int(5) DEFAULT NULL,
`Deuteriumneedresources` int(5) DEFAULT NULL,
`Duraniumneedresources` int(5) DEFAULT NULL,
`Crystalneedresources` int(5) DEFAULT NULL,
`Iridiumneedresources` int(5) DEFAULT NULL,
`Deritiumneedresources` int(2) DEFAULT NULL,
`foodproduction` int(3) DEFAULT NULL,
`industryproduction` int(3) DEFAULT NULL,
`energyproduction` int(3) DEFAULT NULL,
`securityproduction` int(3) DEFAULT NULL,
`researchproduction` int(4) DEFAULT NULL,
`titanproduction` int(3) DEFAULT NULL,
`deuteriumproduction` int(2) DEFAULT NULL,
`duraniumproduction` int(3) DEFAULT NULL,
`crystalproduction` int(2) DEFAULT NULL,
`iridiumproduction` int(2) DEFAULT NULL,
`deritiumproduction` int(2) DEFAULT NULL,
`creditsproduction` int(3) DEFAULT NULL,
`moralinsystem` int(2) DEFAULT NULL,
`moralempirewide` int(2) DEFAULT NULL,
`foodbonus` int(3) DEFAULT NULL,
`industrybonus` int(3) DEFAULT NULL,
`energybonus` int(3) DEFAULT NULL,
`securitybonus` int(3) DEFAULT NULL,
`researchbonus` int(3) DEFAULT NULL,
`titanbonus` int(3) DEFAULT NULL,
`deuteriumbonus` int(3) DEFAULT NULL,
`duraniumbonus` int(3) DEFAULT NULL,
`crystalbonus` int(3) DEFAULT NULL,
`iridiumbonus` int(3) DEFAULT NULL,
`deritiumbonus` int(3) DEFAULT NULL,
`bonustoallresources` int(2) DEFAULT NULL,
`creditsbonus` int(3) DEFAULT NULL,
`biotechbonuspercent` int(3) DEFAULT NULL,
`energytechbonuspercent` int(3) DEFAULT NULL,
`computertechbonuspercent` int(3) DEFAULT NULL,
`propulsiontechbonuspercent` int(3) DEFAULT NULL,
`constructiontechbonuspercent` int(2) DEFAULT NULL,
`weapontechbonuspercent` int(3) DEFAULT NULL,
`innersecurityintelligencebonipercent` int(3) DEFAULT NULL,
`economyspyintelligencebonipercent` int(2) DEFAULT NULL,
`economysabotageintelligencebonipercent` int(2) DEFAULT NULL,
`researchspyintelligencebonipercent` int(2) DEFAULT NULL,
`researchsabotageintelligencebonipercent` int(2) DEFAULT NULL,
`militaryspyintelligencebonipercent` int(2) DEFAULT NULL,
`militarysabotageintelligencebonipercent` int(2) DEFAULT NULL,
`shipyard` int(1) DEFAULT NULL,
`buildableshipsize` int(1) DEFAULT NULL,
`shipyardbuildspeedpercent` int(3) DEFAULT NULL,
`barracks` int(1) DEFAULT NULL,
`barracksbuildspeedpercent` int(2) DEFAULT NULL,
`hitpoints` int(5) DEFAULT NULL,
`shieldpowerdefence` int(4) DEFAULT NULL,
`bonustoshieldpower` int(3) DEFAULT NULL,
`shipdefence` int(5) DEFAULT NULL,
`bonustoshipdefence` int(3) DEFAULT NULL,
`grounddefence` int(2) DEFAULT NULL,
`bonusgrounddefence` int(3) DEFAULT NULL,
`scanpower` int(3) DEFAULT NULL,
`bonustoscanpowerpercent` int(3) DEFAULT NULL,
`scanrange` int(1) DEFAULT NULL,
`bonustoscanrangepercent` int(3) DEFAULT NULL,
`shiptraining` int(3) DEFAULT NULL,
`trooptraining` int(3) DEFAULT NULL,
`resistanceagainstcorruption` int(4) DEFAULT NULL,
`addedtraderoutes` int(2) DEFAULT NULL,
`incomeontraderoutesinpercent` int(3) DEFAULT NULL,
`shiprecylinginpercent` int(2) DEFAULT NULL,
`bonustobuilding-buildspeedinpercent` int(2) DEFAULT NULL,
`bonustoupgrade-buildspeedinpercent` int(2) DEFAULT NULL,
`bonustoship-buildspeedinpercent` int(3) DEFAULT NULL,
`bonustotroop-buildspeedinpercent` int(2) DEFAULT NULL,
`predecessorsID` int(3) DEFAULT NULL,
`allwaysonline` int(1) DEFAULT NULL,
`needsworkers` int(1) DEFAULT NULL,
`neverready` int(1) DEFAULT NULL,
`MajorRace1buildingequivalentID` int(3) DEFAULT NULL,
`MajorRace2buildingequivalentID` int(3) DEFAULT NULL,
`MajorRace3buildingequivalentID` int(3) DEFAULT NULL,
`MajorRace4buildingequivalentID` int(3) DEFAULT NULL,
`MajorRace5buildingequivalentID` int(3) DEFAULT NULL,
`MajorRace6buildingequivalentID` int(3) DEFAULT NULL,
`Titanresourcedistributor` int(1) DEFAULT NULL,
`deuteriumresourcedistributor` int(1) DEFAULT NULL,
`Duraniumresourcedistributor` int(1) DEFAULT NULL,
`Crystalresourcedistributor` int(1) DEFAULT NULL,
`Iridiumresourcedistributor` int(1) DEFAULT NULL,
`Deritiumresourcedistributor` int(1) DEFAULT NULL,
`neededsystems` int(2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;