Results 41 to 50 of 76
Thread: SQL layout
-
07-23-2010, 07:56 AM #41
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
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)Te audire non possum. Musa sapientum fixa est in aure.
-
07-23-2010, 07:58 AM #42
send me an email so i have your address.
do you use outlook ??
-
07-23-2010, 08:02 AM #43
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
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 tableTe audire non possum. Musa sapientum fixa est in aure.
-
07-23-2010, 08:03 AM #44
-
07-23-2010, 08:10 AM #45
perfect i will keep it here
-
07-23-2010, 09:22 AM #46
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 ?Last edited by Dyark; 07-23-2010 at 11:53 AM.
-
07-23-2010, 07:03 PM #47
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
Te audire non possum. Musa sapientum fixa est in aure.
-
07-23-2010, 08:42 PM #48
-
07-26-2010, 10:08 PM #49
-
07-27-2010, 02:03 AM #50
- Join Date
- Oct 2001
- Location
- Woerden, Netherlands
- Posts
- 10,373
- Downloads
- 48
- Uploads
- 1
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_classesTe audire non possum. Musa sapientum fixa est in aure.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks