changelog .. for database !

[Salam]

ahem, i'm not sure to post at the right place *cough*
would it be possible to see a changelog including "db" changes ?

that would kinda help the world builders out there :)

ie: what exactly changed between 3.2 and 3.3 ? like, ehm, do i have to fire up "diff" to find out ? but then, one of the db.sql file is a mysql dump, while the other seems to be exported another way *headache inc!*

thanks !

[Lurker_005]

The only real change between the 3.2 and 3.3 DB is that npc_types reverted back to how it was in 3.1

And yea, I just run a diff program to find out. It only hurts when the tables are in different orders :p

[Salam]

yah well, you and i know what changed, but still .. some may not be aware of this.

it would rock to have hints about this for fast & easy conversion of tables so we can easily convert it and post them for the serverops :)

ie:

structure has changed in table npc_types :

< usedspells char(70) NOT NULL default '',
---
> usedspells varchar(70) NOT NULL default '',


< fixedz tinyint(2) unsigned NOT NULL default '0',
< d_meele_texture1 int(10) unsigned NOT NULL default '0',
< d_meele_texture2 int(10) unsigned NOT NULL default '0',
< walkspeed float NOT NULL default '0',
< runspeed float NOT NULL default '0',

wont hurt anyone in changelog :)