SQL layout

[Arjan]

sure, but some of the tables need to be removed, like: Character_data and Lieutenants_data.

and other tables need to be reviewed.

perhaps we can make a thread per table with the fields in it, and discuss IF we need certain field, or if we perhaps need new ones (and for what reason)

[Dyark]

send me an email so i have your address.

do you use outlook ??

[Arjan]

how do you handle a regent who also rule with a secret organization (country and organization with holding) ?

PS we can talk be email also if you want, it may be simpler

info@deismaar.com ps i am 6 hours earlier than you

well as stated in the books is that all regents know about all the existing holdings.

and that is why i wanted to have lieutenants seperated from regents.
so in case of when a Regent wants to create a second domain (and even want to make it a secret one) then just assign a puppet lieutenant as its ruler.

but perhaps we need a extra column in the domain table.. thats why we should discuss table per table

[Arjan]

send me an email so i have your address.

do you use outlook ??

gmail i use

but i prefer to have these discussions here on BRnet, so the other guys can chip in when they want or have an opinion

[Dyark]

perfect i will keep it here

[Dyark]

i made a page in which i can show the progression of the database and answer questions also from the forum.

http://www.deismaar.com/correctiondatabase/index.php

do Orog receive stat bonus ?

do the class still have free action ?

i foresee a problem with your domains table, if you have an organization that becomes a ruler of provinces, how will you handle that ?

[Arjan]

i foresee a problem with your domains table, if you have an organization that becomes a ruler of provinces, how will you handle that ?

why is that a problem? the provinces table has a regent id... and a realmid.
so when a regent gets his first province and wants to start a new realm, he will get a new row in the realm table and update the regentid from the province

[Dyark]

ok, i wasn't handling it that way since i was getting the none province domain from the holding table.

[Dyark]

Treasury and regency are in both domain and regent table, which one do you use ??

the Prov_coords from province are for what kind of application ??

do you want to include the prestige classes ??

do you want to develop a character builder also ??

[Arjan]

the provinces table in my sql is limited, not all aspects are there.

i think the one in your sql file is more complete, and the fields look fine to me

only fields i know i wouldnt use are:
InGame
DeleteThis
GBIn (in domain table)
GBOut (in domain table)
RPIn (in domain table)
RPOut (in domain table)
Facade (whats this for?)
CentreX and CentreY (i am going to replace all drawing data by FXG files)
PillagedLevels (do we need this?)
LevyLevels (do we need this?)
MapArea
TurnOfLastBattle (whats this for?)
RealProvince (whats this for?)
OccupierLastTurn (do we need this?)


and ofc change:
OccupyingCharacter - occupying_regent
CharOwnerID - regentid

about char dev, i am not thinking about it now, but is the reason why i made the class system flexible by creating the many2many table regent_classes