[GUIDE]TNDB 8 SQL Structure update

[kounelos]

Just a little guide for those who wanna test 1141 core and they need a DB structure update:

1)open SQLyog (recommended) find you database like 'ascent' right click and
choose 'restore from sql dump' and use this file:
fixes.sql
if you already have a 'pickpocketingloot' table you can delete it and make an empty one and then apply the fixes.sql
2)In the query box of SQLyog paste the below text

alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;

then select edit-execute-execute all queries
and you are ready for the 1141 core :)

3)Execute this update for 1149.sql for the 1149 core


I hope i helped..post your comments
ATTENTION:these fixes are not made by me i am just putting them all together

[MentaL]

[masterweb2]

some erorr while executing query like unknow column minlevel , maxlevel ....

[Nosferatuuk]

used your fix there kounelos, EXCELLENT!!

Fixed all the warnings i was getting cheers :)
Also just loaded up ascent 1149 and still no probs! going well!

[kounelos]

some erorr while executing query like unknow column minlevel , maxlevel ....

first execute the sql file and make sure your pickpocketingloot table is empty if you dont have just make an empty one and after the sql file execute the query and make sure u are using TNDB 8 i dont know if this works in previous ver

used your fix there kounelos, EXCELLENT!!

Fixed all the warnings i was getting cheers :)
Also just loaded up ascent 1149 and still no probs! going well!

im glad i helped but u should use the latest fix for 1149

[vincentprovo]

Lol i just lost all my Vendors -.-
and yes im sure im using TNDB 8 :p
any suggestions ? :)
EDIT : It works Fine thx !!!!!! :D my bad xD

[kounelos]

Updated for the 1149 core which i tested and runs smooth :)

[rocko1000]

thanks !!!