Something went wrong. Try again.
Perl game server for TLE Community
Something went wrong. Try again.
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783478447854786478747884789479047914792479347944795479647974798479948004801480248034804480548064807480848094810481148124813481448154816481748184819482048214822482348244825482648274828482948304831483248334834483548364837483848394840484148424843484448454846484748484849485048514852485348544855485648574858485948604861486248634864486548664867486848694870487148724873487448754876487748784879488048814882488348844885488648874888488948904891489248934894489548964897489848994900490149024903490449054906490749084909491049114912491349144915491649174918491949204921492249234924492549264927492849294930493149324933493449354936493749384939494049414942494349444945494649474948494949504951495249534954495549564957495849594960496149624963496449654966496749684969497049714972497349744975497649774978497949804981498249834984498549864987498849894990499149924993499449954996499749984999500050015002500350045005500650075008500950105011501250135014501550165017501850195020502150225023502450255026502750285029503050315032503350345035503650375038503950405041504250435044504550465047504850495050505150525053505450555056505750585059506050615062506350645065506650675068506950705071507250735074507550765077507850795080508150825083508450855086508750885089509050915092509350945095509650975098509951005101510251035104510551065107510851095110511151125113511451155116511751185119512051215122512351245125512651275128512951305131513251335134513551365137513851395140514151425143514451455146514751485149515051515152515351545155515651575158515951605161516251635164516551665167516851695170517151725173517451755176517751785179518051815182518351845185518651875188518951905191519251935194519551965197519851995200520152025203520452055206520752085209521052115212521352145215521652175218521952205221522252235224522552265227522852295230523152325233523452355236523752385239524052415242524352445245524652475248524952505251525252535254525552565257525852595260526152625263526452655266526752685269527052715272527352745275527652775278527952805281528252835284528552865287528852895290529152925293529452955296529752985299530053015302530353045305530653075308530953105311531253135314531553165317531853195320532153225323532453255326532753285329533053315332533353345335533653375338533953405341534253435344534553465347534853495350535153525353535453555356535753585359536053615362536353645365536653675368536953705371537253735374537553765377537853795380538153825383538453855386538753885389539053915392539353945395539653975398539954005401540254035404540554065407540854095410541154125413541454155416541754185419542054215422542354245425542654275428542954305431543254335434543554365437543854395440544154425443544454455446544754485449545054515452545354545455545654575458545954605461546254635464546554665467546854695470547154725473547454755476547754785479548054815482548354845485548654875488548954905491549254935494549554965497549854995500550155025503550455055506550755085509551055115512551355145515551655175518551955205521552255235524552555265527552855295530553155325533553455355536553755385539554055415542554355445545554655475548554955505551555255535554555555565557555855595560556155625563556455655566556755685569557055715572557355745575557655775578557955805581558255835584558555865587558855895590559155925593559455955596559755985599560056015602560356045605560656075608560956105611561256135614561556165617561856195620562156225623562456255626562756285629563056315632563356345635563656375638563956405641564256435644564556465647564856495650565156525653565456555656565756585659566056615662566356645665566656675668566956705671567256735674567556765677567856795680568156825683568456855686568756885689569056915692569356945695569656975698569957005701570257035704570557065707570857095710571157125713571457155716571757185719572057215722572357245725572657275728572957305731573257335734573557365737573857395740574157425743574457455746574757485749575057515752575357545755575657575758575957605761576257635764576557665767576857695770577157725773577457755776577757785779578057815782578357845785578657875788578957905791579257935794579557965797579857995800580158025803580458055806580758085809581058115812581358145815581658175818581958205821582258235824582558265827582858295830583158325833583458355836583758385839584058415842584358445845584658475848584958505851585258535854585558565857585858595860586158625863586458655866586758685869587058715872587358745875587658775878587958805881588258835884588558865887588858895890589158925893589458955896589758985899590059015902590359045905590659075908590959105911591259135914591559165917591859195920592159225923592459255926592759285929593059315932593359345935593659375938593959405941594259435944594559465947594859495950595159525953595459555956595759585959596059615962596359645965596659675968596959705971597259735974597559765977597859795980598159825983598459855986598759885989599059915992599359945995599659975998599960006001600260036004600560066007600860096010601160126013601460156016601760186019602060216022602360246025602660276028602960306031603260336034603560366037603860396040604160426043604460456046604760486049605060516052605360546055605660576058605960606061606260636064606560666067606860696070607160726073607460756076607760786079608060816082608360846085608660876088608960906091609260936094609560966097609860996100610161026103610461056106610761086109611061116112611361146115611661176118611961206121612261236124612561266127612861296130613161326133613461356136613761386139614061416142614361446145614661476148614961506151615261536154615561566157615861596160616161626163616461656166616761686169617061716172617361746175617661776178617961806181618261836184618561866187618861896190619161926193619461956196619761986199620062016202620362046205620662076208620962106211621262136214621562166217621862196220622162226223622462256226622762286229623062316232623362346235623662376238623962406241624262436244624562466247624862496250625162526253625462556256625762586259626062616262626362646265626662676268626962706271627262736274627562766277627862796280628162826283628462856286628762886289629062916292629362946295629662976298629963006301630263036304630563066307630863096310631163126313631463156316631763186319632063216322632363246325632663276328632963306331633263336334633563366337633863396340634163426343634463456346634763486349635063516352635363546355635663576358635963606361636263636364636563666367636863696370637163726373637463756376637763786379638063816382638363846385638663876388638963906391639263936394639563966397639863996400640164026403640464056406640764086409641064116412641364146415641664176418641964206421642264236424642564266427642864296430643164326433643464356436643764386439644064416442644364446445644664476448644964506451645264536454645564566457645864596460646164626463646464656466646764686469647064716472647364746475647664776478647964806481648264836484648564866487648864896490649164926493649464956496649764986499650065016502650365046505650665076508650965106511651265136514651565166517651865196520652165226523652465256526652765286529653065316532653365346535653665376538653965406541654265436544654565466547654865496550655165526553655465556556655765586559656065616562656365646565656665676568656965706571657265736574657565766577657865796580658165826583658465856586658765886589659065916592659365946595659665976598659966006601660266036604660566066607660866096610661166126613661466156616661766186619662066216622662366246625662666276628662966306631663266336634663566366637663866396640664166426643664466456646664766486649665066516652665366546655665666576658665966606661666266636664666566666667666866696670667166726673667466756676667766786679668066816682668366846685668666876688668966906691669266936694669566966697669866996700670167026703670467056706670767086709671067116712671367146715671667176718671967206721672267236724672567266727672867296730673167326733673467356736673767386739674067416742674367446745674667476748674967506751675267536754675567566757675867596760676167626763676467656766676767686769677067716772677367746775677667776778677967806781678267836784678567866787678867896790679167926793679467956796679767986799680068016802680368046805680668076808680968106811681268136814681568166817681868196820682168226823682468256826682768286829683068316832683368346835683668376838683968406841684268436844684568466847684868496850685168526853685468556856685768586859686068616862686368646865686668676868686968706871687268736874687568766877687868796880688168826883688468856886688768886889689068916892689368946895689668976898689969006901690269036904690569066907690869096910691169126913691469156916691769186919692069216922692369246925692669276928692969306931693269336934693569366937693869396940694169426943694469456946694769486949695069516952695369546955695669576958695969606961696269636964696569666967696869696970697169726973697469756976697769786979698069816982698369846985698669876988698969906991699269936994699569966997699869997000700170027003700470057006700770087009701070117012701370147015701670177018701970207021702270237024702570267027702870297030703170327033703470357036703770387039704070417042704370447045704670477048704970507051705270537054705570567057705870597060706170627063706470657066706770687069707070717072707370747075707670777078707970807081708270837084708570867087708870897090709170927093709470957096709770987099710071017102710371047105710671077108710971107111711271137114711571167117711871197120712171227123712471257126712771287129713071317132713371347135713671377138713971407141714271437144714571467147714871497150715171527153715471557156715771587159716071617162716371647165716671677168716971707171717271737174717571767177717871797180718171827183718471857186718771887189719071917192719371947195719671977198719972007201720272037204720572067207720872097210721172127213721472157216721772187219722072217222722372247225722672277228722972307231723272337234723572367237723872397240724172427243724472457246724772487249725072517252725372547255725672577258725972607261726272637264726572667267726872697270727172727273727472757276727772787279728072817282728372847285728672877288728972907291729272937294729572967297729872997300730173027303730473057306730773087309731073117312731373147315731673177318731973207321732273237324732573267327732873297330733173327333733473357336733773387339734073417342734373447345734673477348734973507351735273537354735573567357735873597360736173627363736473657366736773687369737073717372737373747375737673777378737973807381738273837384738573867387738873897390739173927393739473957396739773987399740074017402740374047405740674077408740974107411741274137414741574167417741874197420742174227423742474257426742774287429743074317432743374347435743674377438743974407441744274437444744574467447744874497450745174527453745474557456745774587459746074617462746374647465746674677468746974707471747274737474747574767477747874797480748174827483748474857486748774887489749074917492749374947495749674977498749975007501750275037504750575067507750875097510751175127513751475157516751775187519752075217522752375247525752675277528752975307531753275337534753575367537753875397540754175427543754475457546754775487549755075517552755375547555755675577558755975607561756275637564756575667567756875697570757175727573757475757576757775787579758075817582758375847585758675877588758975907591759275937594759575967597759875997600760176027603760476057606760776087609761076117612761376147615761676177618761976207621762276237624762576267627762876297630763176327633763476357636763776387639764076417642764376447645764676477648764976507651765276537654765576567657765876597660766176627663766476657666766776687669767076717672767376747675767676777678767976807681768276837684768576867687768876897690769176927693769476957696769776987699770077017702770377047705770677077708770977107711771277137714771577167717771877197720772177227723772477257726772777287729773077317732773377347735773677377738773977407741774277437744774577467747774877497750775177527753775477557756775777587759776077617762776377647765776677677768776977707771777277737774777577767777777877797780778177827783778477857786778777887789779077917792779377947795779677977798779978007801780278037804780578067807780878097810781178127813781478157816781778187819782078217822782378247825782678277828782978307831783278337834783578367837783878397840784178427843784478457846784778487849785078517852785378547855785678577858785978607861786278637864786578667867786878697870787178727873787478757876787778787879788078817882788378847885788678877888788978907891789278937894789578967897789878997900790179027903790479057906790779087909791079117912791379147915791679177918791979207921792279237924792579267927792879297930793179327933793479357936793779387939794079417942794379447945794679477948794979507951795279537954795579567957795879597960796179627963796479657966796779687969797079717972797379747975797679777978797979807981798279837984798579867987798879897990799179927993799479957996799779987999800080018002800380048005800680078008800980108011801280138014801580168017801880198020802180228023802480258026802780288029803080318032803380348035803680378038803980408041804280438044804580468047804880498050805180528053805480558056805780588059806080618062806380648065806680678068806980708071807280738074807580768077807880798080808180828083808480858086808780888089809080918092809380948095809680978098809981008101810281038104810581068107810881098110811181128113811481158116811781188119812081218122812381248125812681278128812981308131813281338134813581368137813881398140814181428143814481458146814781488149815081518152815381548155815681578158815981608161816281638164816581668167816881698170817181728173817481758176817781788179818081818182818381848185818681878188818981908191819281938194819581968197819881998200820182028203820482058206820782088209821082118212821382148215821682178218821982208221822282238224822582268227822882298230823182328233823482358236823782388239824082418242824382448245824682478248824982508251825282538254825582568257825882598260826182628263826482658266826782688269827082718272827382748275827682778278827982808281828282838284828582868287828882898290829182928293829482958296829782988299830083018302830383048305830683078308830983108311831283138314831583168317831883198320832183228323832483258326832783288329833083318332833383348335833683378338833983408341834283438344834583468347834883498350835183528353835483558356835783588359836083618362836383648365836683678368836983708371837283738374837583768377837883798380838183828383838483858386838783888389839083918392839383948395839683978398839984008401840284038404840584068407840884098410841184128413841484158416841784188419842084218422842384248425842684278428842984308431843284338434843584368437843884398440844184428443844484458446844784488449845084518452845384548455845684578458845984608461846284638464846584668467846884698470847184728473847484758476847784788479848084818482848384848485848684878488848984908491849284938494849584968497849884998500850185028503850485058506850785088509851085118512851385148515851685178518851985208521852285238524852585268527852885298530853185328533853485358536853785388539854085418542854385448545854685478548854985508551855285538554855585568557855885598560856185628563856485658566856785688569857085718572857385748575857685778578857985808581858285838584858585868587858885898590859185928593859485958596859785988599860086018602860386048605860686078608860986108611861286138614861586168617861886198620862186228623862486258626862786288629863086318632863386348635863686378638863986408641864286438644864586468647864886498650865186528653865486558656865786588659866086618662866386648665866686678668866986708671867286738674867586768677867886798680868186828683868486858686868786888689869086918692869386948695869686978698869987008701870287038704870587068707870887098710871187128713871487158716871787188719872087218722872387248725872687278728872987308731873287338734873587368737873887398740874187428743874487458746874787488749875087518752875387548755875687578758875987608761876287638764876587668767876887698770877187728773877487758776877787788779878087818782878387848785878687878788878987908791879287938794879587968797879887998800880188028803880488058806880788088809881088118812881388148815881688178818881988208821882288238824882588268827882888298830883188328833883488358836883788388839884088418842884388448845884688478848884988508851885288538854885588568857885888598860886188628863886488658866886788688869887088718872887388748875887688778878887988808881888288838884888588868887888888898890889188928893889488958896889788988899890089018902890389048905890689078908890989108911891289138914891589168917891889198920892189228923892489258926892789288929893089318932893389348935893689378938893989408941894289438944894589468947894889498950895189528953895489558956895789588959896089618962896389648965896689678968896989708971897289738974897589768977897889798980898189828983898489858986898789888989899089918992899389948995899689978998899990009001900290039004900590069007900890099010901190129013901490159016901790189019902090219022902390249025902690279028902990309031903290339034903590369037903890399040904190429043904490459046904790489049905090519052905390549055905690579058905990609061906290639064906590669067906890699070907190729073907490759076907790789079908090819082908390849085908690879088908990909091909290939094909590969097909890999100910191029103910491059106910791089109911091119112911391149115911691179118911991209121912291239124912591269127912891299130913191329133913491359136913791389139914091419142914391449145914691479148914991509151915291539154915591569157915891599160916191629163916491659166916791689169917091719172917391749175917691779178917991809181918291839184918591869187918891899190919191929193919491959196919791989199920092019202920392049205920692079208920992109211921292139214921592169217921892199220922192229223922492259226922792289229923092319232923392349235923692379238923992409241924292439244924592469247924892499250925192529253925492559256925792589259926092619262926392649265926692679268926992709271927292739274927592769277927892799280928192829283928492859286928792889289929092919292929392949295929692979298929993009301930293039304930593069307930893099310931193129313931493159316931793189319932093219322932393249325932693279328932993309331933293339334933593369337933893399340934193429343934493459346934793489349935093519352935393549355935693579358935993609361936293639364936593669367936893699370937193729373937493759376937793789379938093819382938393849385938693879388938993909391939293939394939593969397939893999400940194029403940494059406940794089409941094119412941394149415941694179418941994209421942294239424942594269427942894299430943194329433943494359436943794389439944094419442944394449445944694479448944994509451945294539454945594569457945894599460946194629463946494659466946794689469947094719472947394749475947694779478947994809481948294839484948594869487948894899490949194929493949494959496949794989499950095019502950395049505950695079508950995109511951295139514951595169517951895199520952195229523952495259526952795289529953095319532953395349535953695379538953995409541954295439544954595469547954895499550955195529553955495559556955795589559956095619562956395649565956695679568956995709571957295739574957595769577957895799580958195829583958495859586958795889589959095919592959395949595959695979598959996009601960296039604960596069607960896099610961196129613961496159616961796189619962096219622962396249625962696279628962996309631963296339634963596369637963896399640964196429643964496459646964796489649965096519652965396549655965696579658965996609661966296639664966596669667966896699670967196729673967496759676967796789679968096819682968396849685968696879688968996909691969296939694969596969697969896999700970197029703970497059706970797089709971097119712971397149715971697179718971997209721972297239724972597269727972897299730973197329733973497359736973797389739974097419742974397449745974697479748974997509751975297539754975597569757975897599760976197629763976497659766976797689769977097719772977397749775977697779778977997809781978297839784978597869787978897899790979197929793979497959796979797989799980098019802980398049805980698079808980998109811981298139814981598169817981898199820982198229823982498259826982798289829983098319832983398349835983698379838983998409841984298439844984598469847984898499850985198529853985498559856985798589859986098619862986398649865986698679868986998709871987298739874987598769877987898799880988198829883988498859886988798889889989098919892989398949895989698979898989999009901990299039904990599069907990899099910991199129913991499159916991799189919992099219922992399249925992699279928992999309931993299339934993599369937993899399940994199429943994499459946994799489949995099519952995399549955995699579958995999609961996299639964996599669967996899699970997199729973997499759976997799789979998099819982998399849985998699879988998999909991999299939994999599969997999899991000010001100021000310004100051000610007100081000910010100111001210013100141001510016100171001810019100201002110022100231002410025100261002710028100291003010031100321003310034100351003610037100381003910040100411004210043100441004510046100471004810049100501005110052100531005410055100561005710058100591006010061100621006310064100651006610067100681006910070100711007210073100741007510076100771007810079100801008110082100831008410085100861008710088100891009010091100921009310094100951009610097100981009910100101011010210103101041010510106101071010810109101101011110112101131011410115101161011710118101191012010121101221012310124101251012610127101281012910130101311013210133101341013510136101371013810139101401014110142101431014410145101461014710148101491015010151101521015310154101551015610157101581015910160101611016210163101641016510166101671016810169101701017110172101731017410175101761017710178101791018010181101821018310184101851018610187101881018910190101911019210193101941019510196101971019810199102001020110202102031020410205102061020710208102091021010211102121021310214102151021610217102181021910220102211022210223102241022510226102271022810229102301023110232102331023410235102361023710238102391024010241102421024310244102451024610247102481024910250102511025210253102541025510256102571025810259102601026110262102631026410265102661026710268102691027010271102721027310274102751027610277102781027910280102811028210283102841028510286102871028810289102901029110292102931029410295102961029710298102991030010301103021030310304103051030610307103081030910310103111031210313103141031510316103171031810319103201032110322103231032410325103261032710328103291033010331103321033310334103351033610337103381033910340103411034210343103441034510346103471034810349103501035110352103531035410355103561035710358103591036010361103621036310364103651036610367103681036910370103711037210373103741037510376103771037810379103801038110382103831038410385103861038710388103891039010391103921039310394103951039610397103981039910400104011040210403104041040510406104071040810409104101041110412104131041410415104161041710418104191042010421104221042310424104251042610427104281042910430104311043210433104341043510436104371043810439104401044110442104431044410445104461044710448104491045010451104521045310454104551045610457104581045910460104611046210463104641046510466104671046810469104701047110472104731047410475104761047710478104791048010481104821048310484104851048610487104881048910490104911049210493104941049510496104971049810499105001050110502105031050410505105061050710508105091051010511105121051310514105151051610517105181051910520105211052210523105241052510526105271052810529105301053110532105331053410535105361053710538105391054010541105421054310544105451054610547105481054910550105511055210553105541055510556105571055810559105601056110562105631056410565105661056710568105691057010571105721057310574105751057610577105781057910580105811058210583105841058510586105871058810589105901059110592105931059410595105961059710598105991060010601106021060310604106051060610607106081060910610106111061210613106141061510616106171061810619106201062110622106231062410625106261062710628106291063010631106321063310634106351063610637106381063910640106411064210643106441064510646106471064810649106501065110652106531065410655106561065710658106591066010661106621066310664106651066610667106681066910670106711067210673106741067510676106771067810679106801068110682106831068410685106861068710688106891069010691106921069310694106951069610697106981069910700107011070210703107041070510706107071070810709107101071110712107131071410715107161071710718107191072010721107221072310724107251072610727107281072910730107311073210733107341073510736107371073810739107401074110742107431074410745107461074710748107491075010751107521075310754107551075610757107581075910760107611076210763107641076510766107671076810769107701077110772107731077410775107761077710778107791078010781107821078310784107851078610787107881078910790107911079210793107941079510796107971079810799108001080110802108031080410805108061080710808108091081010811108121081310814108151081610817108181081910820108211082210823108241082510826108271082810829108301083110832108331083410835108361083710838108391084010841108421084310844108451084610847108481084910850108511085210853108541085510856108571085810859108601086110862108631086410865108661086710868108691087010871108721087310874108751087610877108781087910880108811088210883108841088510886108871088810889108901089110892108931089410895108961089710898108991090010901109021090310904109051090610907109081090910910109111091210913109141091510916109171091810919109201092110922109231092410925109261092710928109291093010931109321093310934109351093610937109381093910940109411094210943109441094510946109471094810949109501095110952109531095410955109561095710958109591096010961109621096310964109651096610967109681096910970109711097210973109741097510976109771097810979109801098110982109831098410985109861098710988109891099010991109921099310994109951099610997109981099911000110011100211003110041100511006110071100811009110101101111012110131101411015110161101711018110191102011021110221102311024110251102611027110281102911030110311103211033110341103511036110371103811039110401104111042110431104411045110461104711048110491105011051110521105311054---schema: procedures: {} tables: ai_battle_summary: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - attacking_empire_id match_type: '' name: ai_battle_summary_fk_attacking_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - defending_empire_id match_type: '' name: ai_battle_summary_fk_defending_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: attack_spy_hours: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attack_spy_hours order: 6 size: - 11 attack_victories: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attack_victories order: 4 size: - 11 attacking_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_id order: 2 size: - 11 defending_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_empire_id order: 3 size: - 11 defense_victories: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_victories order: 5 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - attacking_empire_id name: ai_battle_summary_idx_attacking_empire_id options: [] type: NORMAL - fields: - defending_empire_id name: ai_battle_summary_idx_defending_empire_id options: [] type: NORMAL name: ai_battle_summary options: [] order: 34 ai_scratch_pad: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - ai_empire_id match_type: '' name: ai_scratch_pad_fk_ai_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: ai_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ai_empire_id order: 2 size: - 11 body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 pad: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: pad order: 4 size: - 0 indices: - fields: - ai_empire_id name: ai_scratch_pad_idx_ai_empire_id options: [] type: NORMAL name: ai_scratch_pad options: [] order: 35 alliance: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - leader_id match_type: '' name: alliance_fk_leader_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: announcements: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: announcements order: 6 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 5 size: - 0 forum_uri: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: forum_uri order: 4 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 image: data_type: varchar default_value: default is_nullable: 0 is_primary_key: 0 is_unique: 0 name: image order: 9 size: - 255 leader_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: leader_id order: 3 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 stash: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: stash order: 8 size: - 0 indices: - fields: - leader_id name: alliance_idx_leader_id options: [] type: NORMAL name: alliance options: [] order: 29 alliance_invite: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: alliance_invite_fk_alliance_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: alliance_invite_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 2 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - alliance_id name: alliance_invite_idx_alliance_id options: [] type: NORMAL - fields: - empire_id name: alliance_invite_idx_empire_id options: [] type: NORMAL name: alliance_invite options: [] order: 36 alliance_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 3 size: - 0 alliance_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_name order: 4 size: - 30 average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 17 size: - 5 - 2 average_empire_size: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_empire_size order: 13 size: - 0 average_empire_size_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_empire_size_rank order: 14 size: - 0 average_university_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_university_level order: 15 size: - 5 - 2 building_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 16 size: - 0 colony_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count order: 10 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 21 size: - 6 - 6 defense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_rank order: 22 size: - 11 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 23 size: - 11 dirtiest_rank: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 24 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 8 size: - 0 influence_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence_rank order: 9 size: - 0 member_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: member_count order: 5 size: - 0 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 19 size: - 6 - 6 offense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_rank order: 20 size: - 11 population: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 11 size: - 0 population_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_rank order: 12 size: - 0 space_station_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count order: 6 size: - 0 space_station_count_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count_rank order: 7 size: - 0 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 18 size: - 11 indices: - fields: - average_empire_size_rank name: idx_average_empire_size_rank options: [] type: NORMAL - fields: - offense_success_rate_rank name: idx_offense_success_rate_rank options: [] type: NORMAL - fields: - defense_success_rate_rank name: idx_defense_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL - fields: - population_rank name: idx_population_rank options: [] type: NORMAL - fields: - influence_rank name: idx_influence_rank options: [] type: NORMAL name: alliance_log options: [] order: 1 api_key: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 7 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 6 size: - 15 name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: name order: 5 size: - 30 private_key: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: private_key order: 4 size: - 36 public_key: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: public_key order: 3 size: - 36 indices: - fields: - private_key name: idx_private_key options: [] type: NORMAL - fields: - public_key name: idx_public_key options: [] type: NORMAL name: api_key options: [] order: 2 battle_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: attacked_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacked_body_id order: 18 size: - 11 attacked_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacked_body_name order: 19 size: - 30 attacked_empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attacked_empire_id order: 20 size: - 11 attacked_empire_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attacked_empire_name order: 21 size: - 30 attacking_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_body_id order: 5 size: - 11 attacking_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_body_name order: 6 size: - 30 attacking_empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_id order: 3 size: - 11 attacking_empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_empire_name order: 4 size: - 30 attacking_number: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_number order: 9 size: - 11 attacking_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_type order: 8 size: - 60 attacking_unit_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: attacking_unit_name order: 7 size: - 60 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defending_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_body_id order: 12 size: - 11 defending_body_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_body_name order: 13 size: - 30 defending_empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: defending_empire_id order: 10 size: - 11 defending_empire_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: defending_empire_name order: 11 size: - 30 defending_number: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_number order: 16 size: - 11 defending_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_type order: 15 size: - 60 defending_unit_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defending_unit_name order: 14 size: - 60 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 victory_to: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: victory_to order: 17 size: - 8 indices: - fields: - date_stamp name: idx_datestamp options: [] type: NORMAL - fields: - attacking_empire_id name: idx_attacking_empire_id options: [] type: NORMAL - fields: - attacking_empire_name name: idx_attacking_empire_name options: [] type: NORMAL - fields: - attacking_body_id name: idx_attacking_body_id options: [] type: NORMAL - fields: - attacking_body_name name: idx_attacking_body_name options: [] type: NORMAL - fields: - defending_empire_id name: idx_defending_empire_id options: [] type: NORMAL - fields: - defending_empire_name name: idx_defending_empire_name options: [] type: NORMAL - fields: - defending_body_id name: idx_defending_body_id options: [] type: NORMAL - fields: - defending_body_name name: idx_defending_body_name options: [] type: NORMAL name: battle_log options: [] order: 3 body: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: body_fk_alliance_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: body_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: body_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: algae_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: algae_production_hour order: 84 size: - 0 algae_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: algae_stored order: 108 size: - 0 alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 7 size: - 0 anthracite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_hour order: 60 size: - 0 anthracite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_stored order: 40 size: - 0 apple_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: apple_production_hour order: 72 size: - 0 apple_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: apple_stored order: 96 size: - 0 bauxite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_hour order: 53 size: - 0 bauxite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_stored order: 33 size: - 0 bean_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bean_production_hour order: 90 size: - 0 bean_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bean_stored order: 93 size: - 0 beetle_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beetle_production_hour order: 89 size: - 0 beetle_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beetle_stored order: 113 size: - 0 beryl_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_hour order: 65 size: - 0 beryl_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_stored order: 45 size: - 0 boost_enabled: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: boost_enabled order: 114 size: - 0 bread_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bread_production_hour order: 77 size: - 0 bread_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bread_stored order: 101 size: - 0 burger_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: burger_production_hour order: 87 size: - 0 burger_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: burger_stored order: 111 size: - 0 chalcopyrite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_hour order: 49 size: - 0 chalcopyrite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_stored order: 29 size: - 0 cheese_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cheese_production_hour order: 91 size: - 0 cheese_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cheese_stored order: 92 size: - 0 chip_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chip_production_hour order: 79 size: - 0 chip_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chip_stored order: 103 size: - 0 chromite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_hour order: 48 size: - 0 chromite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_stored order: 28 size: - 0 cider_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cider_production_hour order: 75 size: - 0 cider_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cider_stored order: 99 size: - 0 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 9 size: - 255 corn_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: corn_production_hour order: 74 size: - 0 corn_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: corn_stored order: 98 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: empire_id order: 13 size: - 0 energy_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_capacity order: 22 size: - 0 energy_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 20 size: - 0 energy_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_stored order: 21 size: - 0 fluorite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_hour order: 64 size: - 0 fluorite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_stored order: 44 size: - 0 food_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_capacity order: 68 size: - 0 food_consumption_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_consumption_hour order: 69 size: - 0 fungus_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fungus_production_hour order: 86 size: - 0 fungus_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fungus_stored order: 110 size: - 0 galena_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_hour order: 50 size: - 0 galena_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_stored order: 30 size: - 0 goethite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_hour order: 54 size: - 0 goethite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_stored order: 34 size: - 0 gold_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_hour order: 51 size: - 0 gold_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_stored order: 31 size: - 0 gypsum_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_hour order: 56 size: - 0 gypsum_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_stored order: 36 size: - 0 halite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_hour order: 55 size: - 0 halite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_stored order: 35 size: - 0 happiness: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness order: 16 size: - 0 happiness_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 kerogen_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_hour order: 58 size: - 0 kerogen_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_stored order: 38 size: - 0 lapis_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: lapis_production_hour order: 70 size: - 0 lapis_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: lapis_stored order: 94 size: - 0 last_tick: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_tick order: 14 size: - 0 magnetite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_hour order: 66 size: - 0 magnetite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_stored order: 46 size: - 0 max_berth: data_type: tinyint default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_berth order: 120 size: - 0 meal_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: meal_production_hour order: 83 size: - 0 meal_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: meal_stored order: 107 size: - 0 methane_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_hour order: 59 size: - 0 methane_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_stored order: 39 size: - 0 milk_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: milk_production_hour order: 82 size: - 0 milk_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: milk_stored order: 106 size: - 0 monazite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_hour order: 63 size: - 0 monazite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_stored order: 43 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 needs_recalc: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_recalc order: 115 size: - 0 needs_surface_refresh: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_surface_refresh order: 116 size: - 0 neutral_entry: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: neutral_entry order: 124 size: - 0 notes: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: notes order: 125 size: - 0 orbit: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: orbit order: 8 size: - 0 ore_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_capacity order: 26 size: - 0 ore_consumption_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_consumption_hour order: 67 size: - 0 pancake_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pancake_production_hour order: 81 size: - 0 pancake_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pancake_stored order: 105 size: - 0 pie_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pie_production_hour order: 80 size: - 0 pie_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: pie_stored order: 104 size: - 0 plots_available: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: plots_available order: 118 size: - 0 potato_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: potato_production_hour order: 71 size: - 0 potato_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: potato_stored order: 95 size: - 0 propaganda_boost: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: propaganda_boost order: 123 size: - 0 restrict_coverage: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: restrict_coverage order: 117 size: - 0 root_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: root_production_hour order: 73 size: - 0 root_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: root_stored order: 97 size: - 0 rutile_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_hour order: 47 size: - 0 rutile_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_stored order: 27 size: - 0 shake_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shake_production_hour order: 88 size: - 0 shake_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shake_stored order: 112 size: - 0 size: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: size order: 10 size: - 0 soup_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: soup_production_hour order: 78 size: - 0 soup_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: soup_stored order: 102 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 6 size: - 0 sulfur_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_hour order: 61 size: - 0 sulfur_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_stored order: 41 size: - 0 surface_version: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: surface_version order: 119 size: - 0 syrup_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: syrup_production_hour order: 85 size: - 0 syrup_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: syrup_stored order: 109 size: - 0 trona_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_hour order: 57 size: - 0 trona_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_stored order: 37 size: - 0 unhappy: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: unhappy order: 122 size: - 0 unhappy_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: unhappy_date order: 121 size: - 0 uraninite_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_hour order: 52 size: - 0 uraninite_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_stored order: 32 size: - 0 usable_as_starter: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: usable_as_starter order: 11 size: - 0 usable_as_starter_enabled: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: usable_as_starter_enabled order: 12 size: - 0 waste_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_capacity order: 19 size: - 0 waste_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 17 size: - 0 waste_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_stored order: 18 size: - 0 water_capacity: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_capacity order: 25 size: - 0 water_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 23 size: - 0 water_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_stored order: 24 size: - 0 wheat_production_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: wheat_production_hour order: 76 size: - 0 wheat_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: wheat_stored order: 100 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 3 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 4 size: - 11 zircon_hour: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_hour order: 62 size: - 0 zircon_stored: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_stored order: 42 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 5 size: - 16 indices: - fields: - alliance_id name: body_idx_alliance_id options: [] type: NORMAL - fields: - empire_id name: body_idx_empire_id options: [] type: NORMAL - fields: - star_id name: body_idx_star_id options: [] type: NORMAL - fields: - x - y name: idx_x_y options: [] type: NORMAL - fields: - zone name: idx_zone options: [] type: NORMAL - fields: - name name: idx_name options: [] type: NORMAL - fields: - class name: idx_class options: [] type: NORMAL - fields: - usable_as_starter name: idx_usable_as_starter options: [] type: NORMAL - fields: - usable_as_starter_enabled name: idx_usable_as_starter_enabled options: [] type: NORMAL - fields: - usable_as_starter_enabled - usable_as_starter name: idx_planet_search options: [] type: NORMAL name: body options: [] order: 32 building: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: building_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 7 size: - 255 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 2 size: - 0 efficiency: data_type: int default_value: 100 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: efficiency order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 is_upgrading: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_upgrading order: 10 size: - 0 is_working: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_working order: 13 size: - 0 last_check: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_check order: 16 size: - 0 level: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 6 size: - 11 upgrade_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: upgrade_ends order: 9 size: - 0 upgrade_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: upgrade_started order: 8 size: - 0 work: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: work order: 14 size: - 0 work_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: work_ends order: 12 size: - 0 work_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: work_started order: 11 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 4 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 5 size: - 11 indices: - fields: - body_id name: building_idx_body_id options: [] type: NORMAL - fields: - x - y name: idx_x_y options: [] type: NORMAL - fields: - class name: idx_class options: [] type: NORMAL - fields: - is_upgrading name: idx_is_upgrading options: [] type: NORMAL - fields: - is_working name: idx_is_working options: [] type: NORMAL name: building options: [] order: 37 captcha: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: created order: 5 size: - 0 guid: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: guid order: 4 size: - 36 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 riddle: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: riddle order: 2 size: - 12 solution: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: solution order: 3 size: - 5 indices: [] name: captcha options: [] order: 4 cargo_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 5 size: - 0 data: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: data order: 7 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 message: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: message order: 6 size: - 255 object_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: object_id order: 4 size: - 0 object_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: object_type order: 3 size: - 255 indices: [] name: cargo_log options: [] order: 5 colony_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 11 size: - 5 - 2 average_spy_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_spy_success_rate order: 20 size: - 6 - 6 body_id: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 31 size: - 11 building_count: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 10 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 23 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 24 size: - 6 - 6 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 25 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 26 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 energy_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 14 size: - 11 food_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_hour order: 13 size: - 11 happiness_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 18 size: - 11 highest_building_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: highest_building_level order: 12 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 28 size: - 11 is_space_station: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_space_station order: 27 size: - 11 offense_success_rate: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 21 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 22 size: - 6 - 6 ore_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_hour order: 16 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 5 size: - 11 planet_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_name order: 6 size: - 30 population: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 7 size: - 11 population_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_delta order: 9 size: - 11 population_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_rank order: 8 size: - 11 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 19 size: - 11 waste_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 15 size: - 11 water_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 17 size: - 11 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 29 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 30 size: - 11 zone: data_type: varchar default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 32 size: - 16 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - population_rank name: idx_population_rank options: [] type: NORMAL - fields: - planet_id name: idx_planet_id options: [] type: NORMAL - fields: - planet_name name: idx_planet_name options: [] type: NORMAL name: colony_log options: [] order: 6 config: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 value: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: value order: 3 size: - 256 indices: - fields: - name name: c_idx_key options: [] type: NORMAL name: config options: [] order: 7 economy_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: date default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_mission: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_mission order: 15 size: - 0 in_other: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_other order: 16 size: - 0 in_purchase: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_purchase order: 9 size: - 0 in_redemption: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_redemption order: 11 size: - 0 in_trade: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_trade order: 10 size: - 0 in_tutorial: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_tutorial order: 14 size: - 0 in_vein: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_vein order: 12 size: - 0 in_vote: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_vote order: 13 size: - 0 out_boost: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_boost order: 17 size: - 0 out_building: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_building order: 24 size: - 0 out_delete: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_delete order: 26 size: - 0 out_glyph: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_glyph order: 22 size: - 0 out_mission: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_mission order: 18 size: - 0 out_other: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_other order: 27 size: - 0 out_party: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_party order: 23 size: - 0 out_recycle: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_recycle order: 19 size: - 0 out_ship: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_ship order: 20 size: - 0 out_spy: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_spy order: 21 size: - 0 out_trade: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: out_trade order: 25 size: - 0 purchases_100: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_100 order: 5 size: - 0 purchases_1300: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_1300 order: 8 size: - 0 purchases_200: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_200 order: 6 size: - 0 purchases_30: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_30 order: 4 size: - 0 purchases_600: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: purchases_600 order: 7 size: - 0 total_users: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: total_users order: 3 size: - 0 indices: - fields: - date_stamp name: idx_date_stamp options: [] type: NORMAL name: economy_log options: [] order: 8 empire: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - name match_type: '' name: name on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: UNIQUE - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: empire_fk_alliance_id on_delete: SET NULL on_update: CASCADE options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - home_planet_id match_type: '' name: empire_fk_home_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - latest_message_id match_type: '' name: empire_fk_latest_message_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: message type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 35 size: - 0 building_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_boost order: 33 size: - 0 city: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: city order: 14 size: - 100 country: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: country order: 15 size: - 100 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 deception_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: deception_affinity order: 41 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 7 size: - 0 dont_replace_excavator: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dont_replace_excavator order: 67 size: - 0 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 13 size: - 255 energy_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_boost order: 31 size: - 0 environmental_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: environmental_affinity order: 47 size: - 0 essentia_free: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_free order: 20 size: - 11 - 1 essentia_game: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_game order: 21 size: - 11 - 1 essentia_paid: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: essentia_paid order: 22 size: - 11 - 1 farming_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: farming_affinity order: 44 size: - 0 food_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_boost order: 28 size: - 0 growth_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: growth_affinity order: 50 size: - 0 happiness_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_boost order: 32 size: - 0 home_planet_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: home_planet_id order: 9 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_stasis: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: in_stasis order: 70 size: - 0 is_admin: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_admin order: 55 size: - 0 is_isolationist: data_type: tinyint default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_isolationist order: 26 size: - 0 is_mission_curator: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_mission_curator order: 56 size: - 0 last_login: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: last_login order: 19 size: - 0 latest_message_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: latest_message_id order: 68 size: - 0 management_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: management_affinity order: 43 size: - 0 manufacturing_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: manufacturing_affinity order: 40 size: - 0 max_orbit: data_type: tinyint default_value: 3 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_orbit order: 39 size: - 0 min_orbit: data_type: tinyint default_value: 3 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: min_orbit order: 38 size: - 0 mining_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mining_affinity order: 45 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 1 name: name order: 2 size: - 30 notes: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: notes order: 8 size: - 0 ore_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_boost order: 30 size: - 0 outlaw: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: outlaw order: 72 size: - 0 outlaw_date: data_type: datetime default_value: 2010-10-03 18:17:26 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: outlaw_date order: 73 size: - 0 password: data_type: char default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: password order: 11 size: - 43 password_recovery_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: password_recovery_key order: 18 size: - 36 player_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: player_name order: 17 size: - 100 political_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: political_affinity order: 48 size: - 0 research_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: research_affinity order: 42 size: - 0 science_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: science_affinity order: 46 size: - 0 self_destruct_active: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: self_destruct_active order: 6 size: - 0 self_destruct_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: self_destruct_date order: 5 size: - 0 sitter_password: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sitter_password order: 12 size: - 30 skip_attack_messages: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_attack_messages order: 63 size: - 0 skip_excavator_artifact: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_artifact order: 64 size: - 0 skip_excavator_destroyed: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_destroyed order: 65 size: - 0 skip_excavator_glyph: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_glyph order: 59 size: - 0 skip_excavator_plan: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_plan order: 60 size: - 0 skip_excavator_replace_msg: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_replace_msg order: 66 size: - 0 skip_excavator_resources: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_excavator_resources order: 58 size: - 0 skip_found_nothing: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_found_nothing order: 57 size: - 0 skip_happiness_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_happiness_warnings order: 54 size: - 0 skip_incoming_ships: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_incoming_ships order: 69 size: - 0 skip_medal_messages: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_medal_messages order: 51 size: - 0 skip_pollution_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_pollution_warnings order: 52 size: - 0 skip_probe_detected: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_probe_detected order: 62 size: - 0 skip_resource_warnings: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_resource_warnings order: 53 size: - 0 skip_spy_recovery: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_spy_recovery order: 61 size: - 0 skype: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: skype order: 16 size: - 100 species_description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: species_description order: 37 size: - 0 species_name: data_type: varchar default_value: Human is_nullable: 0 is_primary_key: 0 is_unique: 0 name: species_name order: 36 size: - 30 spy_training_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_training_boost order: 34 size: - 0 stage: data_type: varchar default_value: new is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stage order: 3 size: - 30 status_message: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: status_message order: 10 size: - 255 storage_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: storage_boost order: 27 size: - 0 timeout: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: timeout order: 71 size: - 0 trade_affinity: data_type: tinyint default_value: 4 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trade_affinity order: 49 size: - 0 tutorial_scratch: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: tutorial_scratch order: 25 size: - 0 tutorial_stage: data_type: varchar default_value: explore_the_ui is_nullable: 0 is_primary_key: 0 is_unique: 0 name: tutorial_stage order: 24 size: - 30 university_level: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level order: 23 size: - 0 water_boost: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_boost order: 29 size: - 0 indices: - fields: - alliance_id name: empire_idx_alliance_id options: [] type: NORMAL - fields: - home_planet_id name: empire_idx_home_planet_id options: [] type: NORMAL - fields: - latest_message_id name: empire_idx_latest_message_id options: [] type: NORMAL - fields: - self_destruct_active - self_destruct_date name: idx_self_destruct options: [] type: NORMAL - fields: - password_recovery_key name: idx_password_recovery_key options: [] type: NORMAL - fields: - last_login - self_destruct_active name: idx_inactives options: [] type: NORMAL - fields: - name - is_admin name: idx_admins options: [] type: NORMAL name: empire options: [] order: 33 empire_admin_notes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: creator: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: creator order: 6 size: - 30 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 notes: data_type: text default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: notes order: 5 size: - 0 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_admin_notes options: [] order: 9 empire_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 33 size: - 0 alliance_name: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_name order: 34 size: - 30 average_building_level: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: average_building_level order: 15 size: - 5 - 2 building_count: data_type: smallint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_count order: 12 size: - 0 colony_count: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count order: 5 size: - 0 colony_count_delta: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: colony_count_delta order: 6 size: - 0 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 27 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 29 size: - 6 - 6 defense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_rank order: 28 size: - 11 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 30 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 32 size: - 11 dirtiest_rank: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 31 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 empire_size: data_type: bigint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size order: 9 size: - 11 empire_size_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size_delta order: 10 size: - 11 empire_size_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_size_rank order: 11 size: - 11 energy_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: energy_hour order: 18 size: - 11 food_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: food_hour order: 17 size: - 11 happiness_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: happiness_hour order: 22 size: - 11 highest_building_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: highest_building_level order: 16 size: - 3 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 36 size: - 11 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 24 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 26 size: - 6 - 6 offense_success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_rank order: 25 size: - 11 ore_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ore_hour order: 20 size: - 11 population: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population order: 7 size: - 11 population_delta: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: population_delta order: 8 size: - 11 space_station_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: space_station_count order: 35 size: - 11 spy_count: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_count order: 23 size: - 11 university_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level order: 13 size: - 0 university_level_rank: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: university_level_rank order: 14 size: - 0 waste_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 19 size: - 11 water_hour: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: water_hour order: 21 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - empire_size_rank name: idx_empire_size_rank options: [] type: NORMAL - fields: - university_level_rank name: idx_university_level_rank options: [] type: NORMAL - fields: - offense_success_rate_rank name: idx_offense_success_rate_rank options: [] type: NORMAL - fields: - defense_success_rate_rank name: idx_defense_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL name: empire_log options: [] order: 10 empire_name_change_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 old_empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: old_empire_name order: 5 size: - 30 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_name_change_log options: [] order: 11 empire_rpc_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 limits: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: limits order: 6 size: - 11 rpc: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rpc order: 5 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: empire_rpc_log options: [] order: 12 essentia_code: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: amount: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: amount order: 3 size: - 11 - 1 code: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: code order: 2 size: - 36 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 4 size: - 0 description: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: description order: 5 size: - 50 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 7 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 used: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: used order: 6 size: - 0 indices: - fields: - code name: idx_code options: [] type: NORMAL name: essentia_code options: [] order: 13 essentia_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: amount: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: amount order: 6 size: - 11 - 1 api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 description: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: description order: 7 size: - 90 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 from_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_id order: 9 size: - 11 from_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_name order: 10 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 transaction_id: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: transaction_id order: 8 size: - 36 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - transaction_id name: idx_transaction_id options: [] type: NORMAL - fields: - empire_id - description - amount name: idx_essentiacode options: [] type: NORMAL name: essentia_log options: [] order: 14 excavators: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: excavators_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: excavators_fk_empire_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: excavators_fk_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 11 date_landed: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_landed order: 5 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 4 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 indices: - fields: - body_id name: excavators_idx_body_id options: [] type: NORMAL - fields: - empire_id name: excavators_idx_empire_id options: [] type: NORMAL - fields: - planet_id name: excavators_idx_planet_id options: [] type: NORMAL name: excavators options: [] order: 51 fleet: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: fleet_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_body_id match_type: '' name: fleet_fk_foreign_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_star_id match_type: '' name: fleet_fk_foreign_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: berth_level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: berth_level order: 20 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 combat: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: combat order: 12 size: - 0 date_available: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_available order: 6 size: - 0 date_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_started order: 5 size: - 0 direction: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: direction order: 16 size: - 3 fleet_speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fleet_speed order: 19 size: - 0 foreign_body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_body_id order: 17 size: - 0 foreign_star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_star_id order: 18 size: - 0 hold_size: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: hold_size order: 13 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 mark: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mark order: 3 size: - 10 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 9 size: - 30 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 14 size: - 0 roundtrip: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: roundtrip order: 15 size: - 0 shipyard_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shipyard_id order: 4 size: - 0 speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 10 size: - 0 stealth: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stealth order: 11 size: - 0 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 8 size: - 30 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 7 size: - 30 indices: - fields: - body_id name: fleet_idx_body_id options: [] type: NORMAL - fields: - foreign_body_id name: fleet_idx_foreign_body_id options: [] type: NORMAL - fields: - foreign_star_id name: fleet_idx_foreign_star_id options: [] type: NORMAL name: fleet options: [] order: 38 glyph: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: glyph_fk_body_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 quantity: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: quantity order: 4 size: - 0 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 3 size: - 20 indices: - fields: - body_id name: glyph_idx_body_id options: [] type: NORMAL name: glyph options: [] order: 39 invite: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - invitee_id match_type: '' name: invite_fk_invitee_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - inviter_id match_type: '' name: invite_fk_inviter_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: accept_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: accept_date order: 8 size: - 0 code: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: code order: 6 size: - 36 email: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: email order: 5 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 invite_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: invite_date order: 7 size: - 0 invitee_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: invitee_id order: 4 size: - 0 inviter_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: inviter_id order: 2 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - invitee_id name: invite_idx_invitee_id options: [] type: NORMAL - fields: - inviter_id name: invite_idx_inviter_id options: [] type: NORMAL name: invite options: [] order: 40 laws: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: laws_fk_star_id on_delete: SET NULL on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: laws_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: date_enacted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_enacted order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: star_id order: 8 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 5 size: - 30 indices: - fields: - star_id name: laws_idx_star_id options: [] type: NORMAL - fields: - station_id name: laws_idx_station_id options: [] type: NORMAL - fields: - date_enacted name: idx_date_enacted options: [] type: NORMAL name: laws options: [] order: 41 login_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 36 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 extended: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: extended order: 9 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 7 size: - 15 is_sitter: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: is_sitter order: 10 size: - 1 log_out_date: data_type: datetime default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: log_out_date order: 8 size: - 0 session_id: data_type: char default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: session_id order: 6 size: - 36 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - session_id name: idx_session_id options: [] type: NORMAL name: login_log options: [] order: 15 lottery_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 ip_address: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ip_address order: 7 size: - 15 url: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: url order: 6 size: - 255 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - url name: idx_url options: [] type: NORMAL - fields: - ip_address name: idx_ip_address options: [] type: NORMAL name: lottery_log options: [] order: 16 market: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: market_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - ship_id match_type: '' name: market_fk_ship_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: ships type: FOREIGN KEY fields: ask: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ask order: 6 size: - 11 - 1 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 0 date_offered: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_offered order: 2 size: - 0 has_energy: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_energy order: 10 size: - 0 has_food: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_food order: 11 size: - 0 has_glyph: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_glyph order: 16 size: - 0 has_ore: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_ore order: 13 size: - 0 has_plan: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_plan order: 17 size: - 0 has_prisoner: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_prisoner order: 15 size: - 0 has_ship: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_ship order: 14 size: - 0 has_waste: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_waste order: 12 size: - 0 has_water: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_water order: 9 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_university: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: max_university order: 22 size: - 0 offer_cargo_space_needed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offer_cargo_space_needed order: 8 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 ship_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: ship_id order: 5 size: - 0 speed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 20 size: - 0 trade_range: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trade_range order: 21 size: - 0 transfer_type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: transfer_type order: 4 size: - 16 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 18 size: - 0 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 19 size: - 0 indices: - fields: - body_id name: market_idx_body_id options: [] type: NORMAL - fields: - ship_id name: market_idx_ship_id options: [] type: NORMAL - fields: - body_id - transfer_type name: idx_market_zone options: [] type: NORMAL name: market options: [] order: 52 medals: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: medals_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: datestamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: datestamp order: 5 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 public: data_type: bit default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: public order: 4 size: - 0 times_earned: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_earned order: 6 size: - 11 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 2 size: - 30 indices: - fields: - empire_id name: medals_idx_empire_id options: [] type: NORMAL name: medals options: [] order: 42 mercenary_market: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: mercenary_market_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: ask: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ask order: 5 size: - 11 - 1 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 3 size: - 0 cost: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: cost order: 6 size: - 11 - 1 date_offered: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_offered order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 ship_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: ship_id order: 4 size: - 0 indices: - fields: - body_id name: mercenary_market_idx_body_id options: [] type: NORMAL name: mercenary_market options: [] order: 43 message: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - to_id match_type: '' name: message_fk_to_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - from_id match_type: '' name: message_fk_from_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: attachments: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: attachments order: 16 size: - 0 body: data_type: mediumtext default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: body order: 4 size: - 0 date_sent: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_sent order: 5 size: - 0 from_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_id order: 6 size: - 11 from_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_name order: 7 size: - 30 has_archived: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_archived order: 14 size: - 0 has_read: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_read order: 12 size: - 0 has_replied: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_replied order: 13 size: - 0 has_trashed: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: has_trashed order: 15 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 in_reply_to: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: in_reply_to order: 2 size: - 11 recipients: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: recipients order: 10 size: - 0 repeat_check: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: repeat_check order: 17 size: - 30 subject: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: subject order: 3 size: - 64 tag: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: tag order: 11 size: - 15 to_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: to_id order: 8 size: - 11 to_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: to_name order: 9 size: - 30 indices: - fields: - to_id name: message_idx_to_id options: [] type: NORMAL - fields: - from_id name: message_idx_from_id options: [] type: NORMAL - fields: - repeat_check - date_sent name: idx_repeat_check_date_sent options: [] type: NORMAL - fields: - has_archived - has_read - to_id - date_sent name: idx_recent_messages options: [] type: NORMAL - fields: - has_archived - to_id - date_sent name: idx_inbox_only options: [] type: NORMAL - fields: - has_trashed - to_id - date_sent name: idx_trash_only options: [] type: NORMAL name: message options: [] order: 30 mining_platforms: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - asteroid_id match_type: '' name: mining_platforms_fk_asteroid_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: mining_platforms_fk_planet_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: anthracite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: anthracite_hour order: 17 size: - 11 asteroid_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: asteroid_id order: 3 size: - 11 bauxite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: bauxite_hour order: 10 size: - 11 beryl_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: beryl_hour order: 22 size: - 11 chalcopyrite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chalcopyrite_hour order: 6 size: - 11 chromite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: chromite_hour order: 5 size: - 11 fluorite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fluorite_hour order: 21 size: - 11 galena_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: galena_hour order: 7 size: - 11 goethite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: goethite_hour order: 11 size: - 11 gold_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gold_hour order: 8 size: - 11 gypsum_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: gypsum_hour order: 13 size: - 11 halite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: halite_hour order: 12 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 kerogen_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: kerogen_hour order: 15 size: - 11 magnetite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: magnetite_hour order: 23 size: - 11 methane_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: methane_hour order: 16 size: - 11 monazite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: monazite_hour order: 20 size: - 11 percent_ship_capacity: data_type: int default_value: -1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_ship_capacity order: 24 size: - 0 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 rutile_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: rutile_hour order: 4 size: - 11 sulfur_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: sulfur_hour order: 18 size: - 11 trona_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: trona_hour order: 14 size: - 11 uraninite_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: uraninite_hour order: 9 size: - 11 zircon_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zircon_hour order: 19 size: - 11 indices: - fields: - asteroid_id name: mining_platforms_idx_asteroid_id options: [] type: NORMAL - fields: - planet_id name: mining_platforms_idx_planet_id options: [] type: NORMAL name: mining_platforms options: [] order: 44 mission: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_posted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_posted order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_university_level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: max_university_level order: 5 size: - 0 mission_file_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mission_file_name order: 2 size: - 100 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - zone - date_posted name: idx_zone_date_posted options: [] type: NORMAL name: mission options: [] order: 17 mission_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: complete_uni_level: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: complete_uni_level order: 7 size: - 0 completes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: completes order: 6 size: - 0 filename: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: filename order: 2 size: - 255 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 incompletes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: incompletes order: 9 size: - 0 offers: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offers order: 3 size: - 0 seconds_to_complete: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seconds_to_complete order: 8 size: - 0 skip_uni_level: data_type: bigint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skip_uni_level order: 5 size: - 0 skips: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: skips order: 4 size: - 0 indices: [] name: mission_log options: [] order: 18 news: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_posted: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_posted order: 4 size: - 0 headline: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: headline order: 2 size: - 140 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 3 size: - 16 indices: - fields: - zone - date_posted name: idx_zone_date_posted options: [] type: NORMAL - fields: - date_posted name: idx_date_posted options: [] type: NORMAL name: news options: [] order: 19 noexist_with_empire_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: noexist_with_empire_log options: [] order: 22 plan: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: plan_fk_body_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 11 class: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: class order: 3 size: - 255 extra_build_level: data_type: tinyint default_value: 0 is_nullable: 1 is_primary_key: 0 is_unique: 0 name: extra_build_level order: 5 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 level: data_type: tinyint default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 4 size: - 0 quantity: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: quantity order: 6 size: - 11 indices: - fields: - body_id name: plan_idx_body_id options: [] type: NORMAL name: plan options: [] order: 45 probes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: probes_fk_alliance_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: probes_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: probes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: probes_fk_star_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: alliance_id order: 5 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 4 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 0 virtual: data_type: int default_value: 0 is_nullable: 1 is_primary_key: 0 is_unique: 0 name: virtual order: 6 size: - 0 indices: - fields: - alliance_id name: probes_idx_alliance_id options: [] type: NORMAL - fields: - body_id name: probes_idx_body_id options: [] type: NORMAL - fields: - empire_id name: probes_idx_empire_id options: [] type: NORMAL - fields: - star_id name: probes_idx_star_id options: [] type: NORMAL name: probes options: [] order: 53 promotion: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: end_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: end_date order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 max_purchase: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: max_purchase order: 6 size: - 0 min_purchase: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: min_purchase order: 5 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 7 size: - 0 start_date: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: start_date order: 2 size: - 0 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 4 size: - 30 indices: [] name: promotion options: [] order: 23 propositions: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - proposed_by_id match_type: '' name: propositions_fk_proposed_by_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: propositions_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: date_ends: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_ends order: 7 size: - 0 description: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: description order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 proposed_by_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: proposed_by_id order: 8 size: - 11 scratch: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: scratch order: 6 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 status: data_type: varchar default_value: Pending is_nullable: 0 is_primary_key: 0 is_unique: 0 name: status order: 9 size: - 10 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 5 size: - 30 indices: - fields: - proposed_by_id name: propositions_idx_proposed_by_id options: [] type: NORMAL - fields: - station_id name: propositions_idx_station_id options: [] type: NORMAL - fields: - status - date_ends name: idx_status_date_ends options: [] type: NORMAL name: propositions options: [] order: 54 rpc_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: api_key: data_type: varchar default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: api_key order: 5 size: - 40 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 module: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: module order: 6 size: - 255 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - api_key name: idx_api_key options: [] type: NORMAL - fields: - module name: idx_module options: [] type: NORMAL name: rpc_log options: [] order: 24 schedule: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: args: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: args order: 9 size: - 0 delivery: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: delivery order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 job_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: job_id order: 3 size: - 11 parent_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: parent_id order: 7 size: - 11 parent_table: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: parent_table order: 6 size: - 30 priority: data_type: int default_value: 1000 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: priority order: 5 size: - 11 queue: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: queue order: 2 size: - 30 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 8 size: - 30 indices: [] name: schedule options: [] order: 25 ships: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - body_id match_type: '' name: ships_fk_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_body_id match_type: '' name: ships_fk_foreign_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - foreign_star_id match_type: '' name: ships_fk_foreign_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: berth_level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: berth_level order: 19 size: - 0 body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: body_id order: 2 size: - 0 combat: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: combat order: 11 size: - 0 date_available: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_available order: 5 size: - 0 date_started: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_started order: 4 size: - 0 direction: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: direction order: 15 size: - 3 fleet_speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: fleet_speed order: 18 size: - 0 foreign_body_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_body_id order: 16 size: - 0 foreign_star_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: foreign_star_id order: 17 size: - 0 hold_size: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: hold_size order: 12 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 8 size: - 30 number_of_docks: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: number_of_docks order: 20 size: - 0 payload: data_type: mediumblob default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: payload order: 13 size: - 0 roundtrip: data_type: bit default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: roundtrip order: 14 size: - 0 shipyard_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: shipyard_id order: 3 size: - 0 speed: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: speed order: 9 size: - 0 stealth: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stealth order: 10 size: - 0 task: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 7 size: - 30 type: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: type order: 6 size: - 30 indices: - fields: - body_id name: ships_idx_body_id options: [] type: NORMAL - fields: - foreign_body_id name: ships_idx_foreign_body_id options: [] type: NORMAL - fields: - foreign_star_id name: ships_idx_foreign_star_id options: [] type: NORMAL - fields: - type name: idx_shiptype options: [] type: NORMAL name: ships options: [] order: 46 sitter_auths: constraints: - deferrable: 1 expression: '' fields: - baby_id - sitter_id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - baby_id match_type: '' name: sitter_auths_fk_baby_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - sitter_id match_type: '' name: sitter_auths_fk_sitter_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: baby_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: baby_id order: 1 size: - 0 expiry: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: expiry order: 3 size: - 0 sitter_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: sitter_id order: 2 size: - 0 indices: - fields: - baby_id name: sitter_auths_idx_baby_id options: [] type: NORMAL - fields: - sitter_id name: sitter_auths_idx_sitter_id options: [] type: NORMAL name: sitter_auths options: [] order: 47 spies: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: spies_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - from_body_id match_type: '' name: spies_fk_from_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - on_body_id match_type: '' name: spies_fk_on_body_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: available_on: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: available_on order: 8 size: - 0 date_created: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_created order: 11 size: - 0 defense: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense order: 10 size: - 0 defense_mission_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_mission_count order: 13 size: - 0 defense_mission_successes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_mission_successes order: 15 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 0 from_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: from_body_id order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 intel_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: intel_xp order: 24 size: - 0 level: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 28 size: - 0 mayhem_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: mayhem_xp order: 25 size: - 0 name: data_type: varchar default_value: Agent Null is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 3 size: - 30 next_task: data_type: varchar default_value: Idle is_nullable: 0 is_primary_key: 0 is_unique: 0 name: next_task order: 29 size: - 30 offense: data_type: int default_value: 1 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense order: 9 size: - 0 offense_mission_count: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_mission_count order: 12 size: - 0 offense_mission_successes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_mission_successes order: 14 size: - 0 on_body_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: on_body_id order: 5 size: - 0 politics_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: politics_xp order: 26 size: - 0 seeds_planted: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seeds_planted order: 18 size: - 0 spies_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_captured order: 20 size: - 0 spies_killed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_killed order: 19 size: - 0 spies_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_turned order: 21 size: - 0 started_assignment: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: started_assignment order: 7 size: - 0 task: data_type: varchar default_value: Idle is_nullable: 0 is_primary_key: 0 is_unique: 0 name: task order: 6 size: - 30 theft_xp: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: theft_xp order: 27 size: - 0 things_destroyed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_destroyed order: 22 size: - 0 things_stolen: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_stolen order: 23 size: - 0 times_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_captured order: 16 size: - 0 times_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_turned order: 17 size: - 0 indices: - fields: - empire_id name: spies_idx_empire_id options: [] type: NORMAL - fields: - from_body_id name: spies_idx_from_body_id options: [] type: NORMAL - fields: - on_body_id name: spies_idx_on_body_id options: [] type: NORMAL name: spies options: [] order: 55 spy_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: age: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: age order: 19 size: - 11 date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 defense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate order: 14 size: - 6 - 6 defense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: defense_success_rate_delta order: 15 size: - 6 - 6 dirtiest: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest order: 28 size: - 11 dirtiest_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_delta order: 30 size: - 11 dirtiest_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: dirtiest_rank order: 29 size: - 11 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 level: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level order: 9 size: - 11 level_delta: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level_delta order: 11 size: - 11 level_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: level_rank order: 10 size: - 11 offense_success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate order: 12 size: - 6 - 6 offense_success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: offense_success_rate_delta order: 13 size: - 6 - 6 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 8 size: - 11 planet_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_name order: 7 size: - 30 seeds_planted: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: seeds_planted order: 22 size: - 11 spies_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_captured order: 24 size: - 11 spies_killed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_killed order: 23 size: - 11 spies_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spies_turned order: 25 size: - 11 spy_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_id order: 6 size: - 11 spy_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: spy_name order: 5 size: - 30 success_rate: data_type: float default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate order: 16 size: - 6 - 6 success_rate_delta: data_type: float default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate_delta order: 18 size: - 6 - 6 success_rate_rank: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: success_rate_rank order: 17 size: - 11 things_destroyed: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_destroyed order: 26 size: - 11 things_stolen: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: things_stolen order: 27 size: - 11 times_captured: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_captured order: 20 size: - 11 times_turned: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_turned order: 21 size: - 11 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL - fields: - level_rank name: idx_level_rank options: [] type: NORMAL - fields: - success_rate_rank name: idx_success_rate_rank options: [] type: NORMAL - fields: - dirtiest_rank name: idx_dirtiest_rank options: [] type: NORMAL - fields: - planet_id name: idx_planet_id options: [] type: NORMAL - fields: - planet_name name: idx_planet_name options: [] type: NORMAL - fields: - spy_id name: idx_spy_id options: [] type: NORMAL - fields: - spy_name name: idx_spy_name options: [] type: NORMAL name: spy_log options: [] order: 26 star: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: star_fk_station_id on_delete: SET NULL on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: color: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: color order: 6 size: - 7 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: influence order: 8 size: - 0 name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: name order: 2 size: - 30 needs_recalc: data_type: tinyint default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: needs_recalc order: 9 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: station_id order: 7 size: - 0 x: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: x order: 3 size: - 11 y: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: y order: 4 size: - 11 zone: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: zone order: 5 size: - 16 indices: - fields: - station_id name: star_idx_station_id options: [] type: NORMAL - fields: - needs_recalc name: idx_recalc options: [] type: NORMAL name: star options: [] order: 31 stationinfluence: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - alliance_id match_type: '' name: stationinfluence_fk_alliance_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: alliance type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: stationinfluence_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: stationinfluence_fk_station_id on_delete: CASCADE on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: alliance_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: alliance_id order: 4 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 influence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: influence order: 7 size: - 0 oldinfluence: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: oldinfluence order: 5 size: - 0 oldstart: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: oldstart order: 6 size: - 0 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 0 started_influence: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: started_influence order: 8 size: - 0 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 2 size: - 0 indices: - fields: - alliance_id name: stationinfluence_idx_alliance_id options: [] type: NORMAL - fields: - star_id name: stationinfluence_idx_star_id options: [] type: NORMAL - fields: - station_id name: stationinfluence_idx_station_id options: [] type: NORMAL name: stationinfluence options: [] order: 48 supply_chain: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - building_id match_type: '' name: supply_chain_fk_building_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: building type: FOREIGN KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: supply_chain_fk_planet_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - target_id match_type: '' name: supply_chain_fk_target_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: building_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: building_id order: 3 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 percent_transferred: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_transferred order: 7 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 resource_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: resource_hour order: 5 size: - 11 resource_type: data_type: varchar default_value: '' is_nullable: 0 is_primary_key: 0 is_unique: 0 name: resource_type order: 6 size: - 0 stalled: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: stalled order: 8 size: - 11 target_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: target_id order: 4 size: - 11 indices: - fields: - building_id name: supply_chain_idx_building_id options: [] type: NORMAL - fields: - planet_id name: supply_chain_idx_planet_id options: [] type: NORMAL - fields: - target_id name: supply_chain_idx_target_id options: [] type: NORMAL name: supply_chain options: [] order: 56 survey: constraints: - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: survey_fk_empire_id on_delete: CASCADE on_update: '' options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY fields: choice: data_type: int default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: choice order: 2 size: - 0 comment: data_type: text default_value: ~ is_nullable: 1 is_primary_key: 0 is_unique: 0 name: comment order: 3 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 1 is_unique: 0 name: empire_id order: 1 size: - 0 indices: [] name: survey options: [] order: 49 taxes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: taxes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - station_id match_type: '' name: taxes_fk_station_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: body type: FOREIGN KEY fields: empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 2 size: - 11 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 paid_0: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_0 order: 10 size: - 11 paid_1: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_1 order: 9 size: - 11 paid_2: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_2 order: 8 size: - 11 paid_3: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_3 order: 7 size: - 11 paid_4: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_4 order: 6 size: - 11 paid_5: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_5 order: 5 size: - 11 paid_6: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: paid_6 order: 4 size: - 11 station_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: station_id order: 3 size: - 11 indices: - fields: - empire_id name: taxes_idx_empire_id options: [] type: NORMAL - fields: - station_id name: taxes_idx_station_id options: [] type: NORMAL name: taxes options: [] order: 57 viral_log: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: abandons: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: abandons order: 8 size: - 0 accepts: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: accepts order: 6 size: - 0 active_duration: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: active_duration order: 9 size: - 0 creates: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: creates order: 4 size: - 0 date_stamp: data_type: date default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 deletes: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: deletes order: 7 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 invites: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: invites order: 5 size: - 0 total_users: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: total_users order: 3 size: - 0 indices: - fields: - date_stamp name: idx_date_stamp options: [] type: NORMAL name: viral_log options: [] order: 27 votes: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - empire_id match_type: '' name: votes_fk_empire_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: empire type: FOREIGN KEY - deferrable: 1 expression: '' fields: - proposition_id match_type: '' name: votes_fk_proposition_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: propositions type: FOREIGN KEY fields: empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 0 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 proposition_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: proposition_id order: 2 size: - 0 vote: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: vote order: 4 size: - 0 indices: - fields: - empire_id name: votes_idx_empire_id options: [] type: NORMAL - fields: - proposition_id name: votes_idx_proposition_id options: [] type: NORMAL name: votes options: [] order: 58 waste_chain: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY - deferrable: 1 expression: '' fields: - planet_id match_type: '' name: waste_chain_fk_planet_id on_delete: CASCADE on_update: CASCADE options: [] reference_fields: - id reference_table: body type: FOREIGN KEY - deferrable: 1 expression: '' fields: - star_id match_type: '' name: waste_chain_fk_star_id on_delete: '' on_update: '' options: [] reference_fields: - id reference_table: star type: FOREIGN KEY fields: id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 percent_transferred: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: percent_transferred order: 5 size: - 11 planet_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: planet_id order: 2 size: - 11 star_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: star_id order: 3 size: - 11 waste_hour: data_type: int default_value: 0 is_nullable: 0 is_primary_key: 0 is_unique: 0 name: waste_hour order: 4 size: - 11 indices: - fields: - planet_id name: waste_chain_idx_planet_id options: [] type: NORMAL - fields: - star_id name: waste_chain_idx_star_id options: [] type: NORMAL name: waste_chain options: [] order: 50 weekly_medal_winner: constraints: - deferrable: 1 expression: '' fields: - id match_type: '' name: '' on_delete: '' on_update: '' options: [] reference_fields: [] reference_table: '' type: PRIMARY KEY fields: date_stamp: data_type: datetime default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: date_stamp order: 2 size: - 0 empire_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_id order: 3 size: - 11 empire_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: empire_name order: 4 size: - 30 id: data_type: int default_value: ~ is_auto_increment: 1 is_nullable: 0 is_primary_key: 1 is_unique: 0 name: id order: 1 size: - 11 medal_id: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_id order: 5 size: - 0 medal_image: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_image order: 8 size: - 50 medal_name: data_type: varchar default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: medal_name order: 6 size: - 50 times_earned: data_type: int default_value: ~ is_nullable: 0 is_primary_key: 0 is_unique: 0 name: times_earned order: 7 size: - 0 indices: - fields: - empire_id name: idx_empire_id options: [] type: NORMAL - fields: - empire_name name: idx_empire_name options: [] type: NORMAL name: weekly_medal_winner options: [] order: 28 triggers: stationinfluence_cleanup: action: UPDATE star s SET s.needs_recalc = 1 WHERE s.id = OLD.star_id; database_events: - delete fields: ~ name: stationinfluence_cleanup on_table: stationinfluence order: 1 perform_action_when: after scope: row views: {}translator: add_drop_table: 1 filename: ~ no_comments: 0 parser_args: sources: - AIBattleSummary - AIScratchPad - Alliance - AllianceInvite - ApiKey - Building - Building::Archaeology - Building::Capitol - Building::CloakingLab - Building::DeployedBleeder - Building::Development - Building::DistributionCenter - Building::Embassy - Building::Energy - Building::Energy::Fission - Building::Energy::Fusion - Building::Energy::Geo - Building::Energy::Hydrocarbon - Building::Energy::Reserve - Building::Energy::Singularity - Building::Energy::Waste - Building::EntertainmentDistrict - Building::Espionage - Building::Food - Building::Food::Algae - Building::Food::Apple - Building::Food::Bean - Building::Food::Beeldeban - Building::Food::Bread - Building::Food::Burger - Building::Food::Cheese - Building::Food::Chip - Building::Food::Cider - Building::Food::Corn - Building::Food::CornMeal - Building::Food::Dairy - Building::Food::Lapis - Building::Food::Malcud - Building::Food::Pancake - Building::Food::Pie - Building::Food::Potato - Building::Food::Reserve - Building::Food::Root - Building::Food::Shake - Building::Food::Soup - Building::Food::Syrup - Building::Food::Wheat - Building::GasGiantLab - Building::GeneticsLab - Building::IntelTraining - Building::Intelligence - Building::LCOTa - Building::LCOTb - Building::LCOTc - Building::LCOTd - Building::LCOTe - Building::LCOTf - Building::LCOTg - Building::LCOTh - Building::LCOTi - Building::LuxuryHousing - Building::MayhemTraining - Building::MercenariesGuild - Building::MissionCommand - Building::Module - Building::Module::ArtMuseum - Building::Module::CulinaryInstitute - Building::Module::IBS - Building::Module::OperaHouse - Building::Module::Parliament - Building::Module::PoliceStation - Building::Module::StationCommand - Building::Module::Warehouse - Building::MunitionsLab - Building::Network19 - Building::Observatory - Building::Ore - Building::Ore::Mine - Building::Ore::Ministry - Building::Ore::Refinery - Building::Ore::Storage - Building::Oversight - Building::Park - Building::Permanent - Building::Permanent::AlgaePond - Building::Permanent::AmalgusMeadow - Building::Permanent::Beach1 - Building::Permanent::Beach10 - Building::Permanent::Beach11 - Building::Permanent::Beach12 - Building::Permanent::Beach13 - Building::Permanent::Beach2 - Building::Permanent::Beach3 - Building::Permanent::Beach4 - Building::Permanent::Beach5 - Building::Permanent::Beach6 - Building::Permanent::Beach7 - Building::Permanent::Beach8 - Building::Permanent::Beach9 - Building::Permanent::BeeldebanNest - Building::Permanent::BlackHoleGenerator - Building::Permanent::CitadelOfKnope - Building::Permanent::CrashedShipSite - Building::Permanent::Crater - Building::Permanent::DentonBrambles - Building::Permanent::EssentiaVein - Building::Permanent::Fissure - Building::Permanent::GasGiantPlatform - Building::Permanent::GeoThermalVent - Building::Permanent::GratchsGauntlet - Building::Permanent::GreatBallOfJunk - Building::Permanent::Grove - Building::Permanent::HallsOfVrbansk - Building::Permanent::InterDimensionalRift - Building::Permanent::JunkHengeSculpture - Building::Permanent::KalavianRuins - Building::Permanent::KasternsKeep - Building::Permanent::Lagoon - Building::Permanent::Lake - Building::Permanent::LapisForest - Building::Permanent::LibraryOfJith - Building::Permanent::MalcudField - Building::Permanent::MassadsHenge - Building::Permanent::MetalJunkArches - Building::Permanent::NaturalSpring - Building::Permanent::OracleOfAnid - Building::Permanent::PantheonOfHagness - Building::Permanent::PyramidJunkSculpture - Building::Permanent::Ravine - Building::Permanent::RockyOutcrop - Building::Permanent::Sand - Building::Permanent::SpaceJunkPark - Building::Permanent::TempleOfTheDrajilites - Building::Permanent::TerraformingPlatform - Building::Permanent::TheDillonForge - Building::Permanent::Volcano - Building::PilotTraining - Building::PlanetaryCommand - Building::PoliticsTraining - Building::Propulsion - Building::SAW - Building::SSLa - Building::SSLb - Building::SSLc - Building::SSLd - Building::Security - Building::Shipyard - Building::SpacePort - Building::Stockpile - Building::SubspaceSupplyDepot - Building::SupplyPod - Building::TerraformingLab - Building::TheftTraining - Building::ThemePark - Building::Trade - Building::Transporter - Building::University - Building::Waste - Building::Waste::Digester - Building::Waste::Exchanger - Building::Waste::Recycling - Building::Waste::Sequestration - Building::Waste::Treatment - Building::Water - Building::Water::AtmosphericEvaporator - Building::Water::Production - Building::Water::Purification - Building::Water::Reclamation - Building::Water::Storage - Captcha - Config - Empire - EssentiaCode - Excavators - Fleet - Fleet::Barge - Fleet::Bleeder - Fleet::CargoShip - Fleet::ColonyShip - Fleet::Detonator - Fleet::Dory - Fleet::Drone - Fleet::Excavator - Fleet::Fighter - Fleet::Freighter - Fleet::Galleon - Fleet::GasGiantSettlementPlatformShip - Fleet::Hulk - Fleet::HulkFast - Fleet::HulkHuge - Fleet::MiningPlatformShip - Fleet::ObservatorySeeker - Fleet::Placebo - Fleet::Placebo2 - Fleet::Placebo3 - Fleet::Placebo4 - Fleet::Placebo5 - Fleet::Placebo6 - Fleet::Probe - Fleet::Scanner - Fleet::Scow - Fleet::ScowFast - Fleet::ScowLarge - Fleet::ScowMega - Fleet::SecurityMinistrySeeker - Fleet::ShortRangeColonyShip - Fleet::SmugglerShip - Fleet::Snark - Fleet::Snark2 - Fleet::Snark3 - Fleet::SpacePortSeeker - Fleet::SpaceStation - Fleet::SpyPod - Fleet::SpyShuttle - Fleet::Stake - Fleet::SupplyPod - Fleet::SupplyPod2 - Fleet::SupplyPod3 - Fleet::SupplyPod4 - Fleet::Surveyor - Fleet::Sweeper - Fleet::TerraformingPlatformShip - Fleet::Thud - Glyph - Invite - Laws - Laws::BHGNeutralized - Laws::BHGPassport - Laws::MembersOnlyColonization - Laws::MembersOnlyExcavation - Laws::MembersOnlyMiningRights - Laws::MembersOnlyStations - Laws::Taxation - Laws::Writ - Log - Log::Alliance - Log::Battles - Log::Cargo - Log::Colony - Log::Economy - Log::Empire - Log::EmpireAdminNotes - Log::EmpireNameChange - Log::EmpireRPC - Log::Essentia - Log::Login - Log::Lottery - Log::Mission - Log::RPC - Log::Spies - Log::Viral - Log::WeeklyMedalWinner - Log::WithEmpire - Map - Map::Body - Map::Body::Asteroid - Map::Body::Asteroid::A1 - Map::Body::Asteroid::A10 - Map::Body::Asteroid::A11 - Map::Body::Asteroid::A12 - Map::Body::Asteroid::A13 - Map::Body::Asteroid::A14 - Map::Body::Asteroid::A15 - Map::Body::Asteroid::A16 - Map::Body::Asteroid::A17 - Map::Body::Asteroid::A18 - Map::Body::Asteroid::A19 - Map::Body::Asteroid::A2 - Map::Body::Asteroid::A20 - Map::Body::Asteroid::A21 - Map::Body::Asteroid::A22 - Map::Body::Asteroid::A23 - Map::Body::Asteroid::A24 - Map::Body::Asteroid::A25 - Map::Body::Asteroid::A26 - Map::Body::Asteroid::A3 - Map::Body::Asteroid::A4 - Map::Body::Asteroid::A5 - Map::Body::Asteroid::A6 - Map::Body::Asteroid::A7 - Map::Body::Asteroid::A8 - Map::Body::Asteroid::A9 - Map::Body::Planet - Map::Body::Planet::GasGiant - Map::Body::Planet::GasGiant::G1 - Map::Body::Planet::GasGiant::G2 - Map::Body::Planet::GasGiant::G3 - Map::Body::Planet::GasGiant::G4 - Map::Body::Planet::GasGiant::G5 - Map::Body::Planet::P1 - Map::Body::Planet::P10 - Map::Body::Planet::P11 - Map::Body::Planet::P12 - Map::Body::Planet::P13 - Map::Body::Planet::P14 - Map::Body::Planet::P15 - Map::Body::Planet::P16 - Map::Body::Planet::P17 - Map::Body::Planet::P18 - Map::Body::Planet::P19 - Map::Body::Planet::P2 - Map::Body::Planet::P20 - Map::Body::Planet::P21 - Map::Body::Planet::P22 - Map::Body::Planet::P23 - Map::Body::Planet::P24 - Map::Body::Planet::P25 - Map::Body::Planet::P26 - Map::Body::Planet::P27 - Map::Body::Planet::P28 - Map::Body::Planet::P29 - Map::Body::Planet::P3 - Map::Body::Planet::P30 - Map::Body::Planet::P31 - Map::Body::Planet::P32 - Map::Body::Planet::P33 - Map::Body::Planet::P34 - Map::Body::Planet::P35 - Map::Body::Planet::P36 - Map::Body::Planet::P37 - Map::Body::Planet::P38 - Map::Body::Planet::P39 - Map::Body::Planet::P4 - Map::Body::Planet::P40 - Map::Body::Planet::P5 - Map::Body::Planet::P6 - Map::Body::Planet::P7 - Map::Body::Planet::P8 - Map::Body::Planet::P9 - Map::Body::Planet::Station - Map::Star - Map::StarLite - Market - Medals - MercenaryMarket - Message - MiningPlatforms - Mission - News - Plan - Probes - Promotion - Promotion::Bonus50 - Promotion::BonusEssentia - Promotion::ECode50 - Promotion::EssentiaCode - Promotion::Valentine50 - Propositions - Propositions::AbandonStation - Propositions::BHGNeutralized - Propositions::BHGPassport - Propositions::BroadcastOnNetwork19 - Propositions::DemolishModule - Propositions::DowngradeModule - Propositions::ElectNewLeader - Propositions::EnactWrit - Propositions::EvictExcavator - Propositions::EvictMiningPlatform - Propositions::ExpelMember - Propositions::FireBfg - Propositions::ForeignAid - Propositions::InductMember - Propositions::InstallModule - Propositions::MembersOnlyColonization - Propositions::MembersOnlyExcavation - Propositions::MembersOnlyMiningRights - Propositions::MembersOnlyStations - Propositions::RenameAsteroid - Propositions::RenameStar - Propositions::RenameStation - Propositions::RenameUninhabited - Propositions::RepairModule - Propositions::RepealLaw - Propositions::Taxation - Propositions::TransferStationOwnership - Propositions::UpgradeModule - Schedule - Ships - Ships::AttackGroup - Ships::Barge - Ships::Bleeder - Ships::CargoShip - Ships::ColonyShip - Ships::Detonator - Ships::Dory - Ships::Drone - Ships::Excavator - Ships::Fighter - Ships::FissureSealer - Ships::Freighter - Ships::Galleon - Ships::GasGiantSettlementPlatformShip - Ships::Hulk - Ships::HulkFast - Ships::HulkHuge - Ships::MiningPlatformShip - Ships::ObservatorySeeker - Ships::Placebo - Ships::Placebo2 - Ships::Placebo3 - Ships::Placebo4 - Ships::Placebo5 - Ships::Placebo6 - Ships::Probe - Ships::Scanner - Ships::Scow - Ships::ScowFast - Ships::ScowLarge - Ships::ScowMega - Ships::SecurityMinistrySeeker - Ships::ShortRangeColonyShip - Ships::SmugglerShip - Ships::Snark - Ships::Snark2 - Ships::Snark3 - Ships::SpacePortSeeker - Ships::SpaceStation - Ships::SpyPod - Ships::SpyShuttle - Ships::Stake - Ships::SupplyPod - Ships::SupplyPod2 - Ships::SupplyPod3 - Ships::SupplyPod4 - Ships::SupplyPod5 - Ships::Surveyor - Ships::Sweeper - Ships::TerraformingPlatformShip - Ships::Thud - SitterAuths - Spies - StationInfluence - SupplyChain - Survey - Taxes - Votes - WasteChain parser_type: SQL::Translator::Parser::DBIx::Class producer_args: {} producer_type: SQL::Translator::Producer::YAML show_warnings: 0 trace: 0 version: 1.66