mana DB specs (?)
Forum rules
This forum houses many years of development, tracing back to some of the earliest posts that exist on the board.
Its current use is for the continued development of the server and game it has always served: TMW Classic.
mana DB specs (?)
Some points to the current specs available from manaserv's git repository.....
There's a one-to-many relation between tmw_characters & tmw_guild_members table. So, a character can join multiple parties/guilds and vice versa ?
And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not. Instead have multiple items or slots. So "tmw_inventories" could rather be "tmw_charitems" or "tmw_charslots".
And where's table for storage, bank ? how's that implemented?
(Assuming the attached DataBase specification is applicable for both mana & tmw since table names do hold "tmw". And would be grateful if someone clarifies manaserv's feature intention.)
There's a one-to-many relation between tmw_characters & tmw_guild_members table. So, a character can join multiple parties/guilds and vice versa ?
And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not. Instead have multiple items or slots. So "tmw_inventories" could rather be "tmw_charitems" or "tmw_charslots".
And where's table for storage, bank ? how's that implemented?
(Assuming the attached DataBase specification is applicable for both mana & tmw since table names do hold "tmw". And would be grateful if someone clarifies manaserv's feature intention.)
- Attachments
-
- DB specs
- database_specification_.png (80.29 KiB) Viewed 2504 times
Lets Chase MDGs...
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
Re: mana DB specs (?)
Hi,
About the rest, you should maybe also ask bjorn or exceptionFault about it.
Regards.
What ?!? That's false!! Each character in an account can have its own gender (I just tested it) and I can't see why it shouldn't be that way.And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
About the rest, you should maybe also ask bjorn or exceptionFault about it.
Regards.
Re: mana DB specs (?)
All chars of an eAthena account must have the same gender.iceslice wrote:And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
Seems it's not so on manaserv.Bertram wrote: What ?!? That's false!! Each character in an account can have its own gender (I just tested it) and I can't see why it shouldn't be that way.
Re: mana DB specs (?)
First off, tmwserv is now manaserv, please use that repository in the future. eAthena is completely separate.
Re: mana DB specs (?)
There's a one-to-many relation between tmw_characters & tmw_guild_members table. So, a character can join multiple parties/guilds and vice versa ?
Yes. On Manaserv you can be in multiple guilds at the same time. How this will affect guild wars has not been determined yet, but I think we will force people to choose one side and abandon the other when two guilds they are member of declare war on each other.
Being in multiple parties is supressed on the application layer, afaik.
Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not.
A character can indeed have multiple inventories. The inventory on the character and the item storage are already two. I could also imagine other persistent item containers which work like an inventory and aren't related to any character. Guild storages or other shared storages, for example.
But this is also still under construction.
Yes. On Manaserv you can be in multiple guilds at the same time. How this will affect guild wars has not been determined yet, but I think we will force people to choose one side and abandon the other when two guilds they are member of declare war on each other.
Being in multiple parties is supressed on the application layer, afaik.
Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not.
A character can indeed have multiple inventories. The inventory on the character and the item storage are already two. I could also imagine other persistent item containers which work like an inventory and aren't related to any character. Guild storages or other shared storages, for example.
But this is also still under construction.
- former Manasource Programmer
- former TMW Pixel artist
- NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Re: mana DB specs (?)
Thanks, making sense but storage mechanism still confusing to me =/
edit: I got the specification from manaserv. neither from tmwserv nor original eA
edit: I got the specification from manaserv. neither from tmwserv nor original eA
Lets Chase MDGs...
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
Re: mana DB specs (?)
Then where are you getting tables prefixed with "tmw"? My local repository only has "mana" prefixes. There have been changes since the prefixes were updated, so it would help if you used the latest.iceslice wrote:Thanks, making sense but storage mechanism still confusing to me =/
edit: I got the specification from manaserv. neither from tmwserv nor original eA
Re: mana DB specs (?)
He very likely found this graphic on wiki.themanaworld.org
http://wiki.themanaworld.org/index.php/ ... oposal.png
http://wiki.themanaworld.org/index.php/ ... oposal.png
- former Manasource Programmer
- former TMW Pixel artist
- NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Re: mana DB specs (?)
Lets Chase MDGs...
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
Re: mana DB specs (?)
...like everything in our doc directories
- former Manasource Programmer
- former TMW Pixel artist
- NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Re: mana DB specs (?)
example.mana is fully up to date.Crush wrote:...like everything in our doc directories
Re: mana DB specs (?)
anyone knows if our existing accounts/characters with items will be lost on switching to the new manaserv from tmwserv?
Lets Chase MDGs...
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably
http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com
Re: mana DB specs (?)
The game systems are fundamentally different. There is just no way to convert characters or items from the eAthena system to the Manaserv system.
Besides it would not really be fun. The first Manaserv content release will have content for levels 1-20. You wouldn't find anything meaningful to do with an 80+ character anyway.
Besides it would not really be fun. The first Manaserv content release will have content for levels 1-20. You wouldn't find anything meaningful to do with an 80+ character anyway.
- former Manasource Programmer
- former TMW Pixel artist
- NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.