mana DB specs (?)

iceslice · Post by **iceslice** » 13 Apr 2010, 21:39

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.)

Bertram · Post by **Bertram** » 13 Apr 2010, 21:49

Hi,

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)

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.

About the rest, you should maybe also ask bjorn or exceptionFault about it.

Regards.

Post by **enchilado** » 13 Apr 2010, 22:32

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)

All chars of an eAthena account must have the same gender.

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.

Seems it's not so on manaserv.

Jaxad0127 · Post by **Jaxad0127** » 14 Apr 2010, 04:36

First off, tmwserv is now manaserv, please use that repository in the future. eAthena is completely separate.

Post by **Crush** » 14 Apr 2010, 08:26

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.

iceslice · Post by **iceslice** » 14 Apr 2010, 23:32

Thanks, making sense but storage mechanism still confusing to me =/

edit: I got the specification from manaserv. neither from tmwserv nor original eA

Jaxad0127 · Post by **Jaxad0127** » 15 Apr 2010, 04:55

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

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.

Post by **Crush** » 15 Apr 2010, 07:01

He very likely found this graphic on wiki.themanaworld.org
http://wiki.themanaworld.org/index.php/ ... oposal.png

iceslice · Post by **iceslice** » 15 Apr 2010, 07:32

lol
check the link.....

http://gitorious.com/mana/manaserv/blob ... cation.png

isnt that manaserv?

Jaxad0127 · Post by **Jaxad0127** » 15 Apr 2010, 14:02

That graphic is very old, and out of date.

Post by **Crush** » 15 Apr 2010, 18:21

...like everything in our doc directories

Jaxad0127 · Post by **Jaxad0127** » 15 Apr 2010, 19:42

Crush wrote:...like everything in our doc directories

example.mana is fully up to date.

Post by **Dark_Mag** » 18 Apr 2010, 01:33

Ha... It really looks very funny...

(^_^)

iceslice · Post by **iceslice** » 18 Apr 2010, 10:29

anyone knows if our existing accounts/characters with items will be lost on switching to the new manaserv from tmwserv?

Post by **Crush** » 18 Apr 2010, 11:00

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.

mana DB specs (?)

mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)

Re: mana DB specs (?)