GUIDs stored in non-unsigned fields, why?

[Toinan67]

Hi,

I noticed something in some tables of the mangos database.

Some GUIDs fields are not unsigned, but I don't understand why. A GUID is always positive, am I right?

Examples.

Table creature : `guid` INT( 11 ) NOT NULL AUTO_INCREMENT

Table gameobject : `guid` INT( 11 ) NOT NULL AUTO_INCREMENT

Moreover, in other tables, those GUIDs are unsigned

Table creature_respawn : `guid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

Is there any reason for not making those fields unsigned?

Thanks

[VladimirMangos]

I don't know what mangos DB you use, but this mostly meaning DB creators fail.

In mangos.sql you can see:

`guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',

for `creature` for example. So this not mangos team problem

[Toinan67]

Shame on me!

I'm using YTDB.

Well thanks for the answer

[zergtmn]

In creature_addon guid is signed currently.

[VladimirMangos]

Fix for `creature_addon` added in [10286].