anyone can help ? O_o

daryl · #1 10-09-2007, 10:46 PM

i got my tables updated but the colums are in the wrong places i tried dragging them to right places using navicat but when i reaload the db the fuckers gone back to how they was before i sorted it grrrrrrrrrr
any clues how to sort it plz ?

Angelox · #2 10-09-2007, 11:05 PM

You would use AFTER, example;

Code:

ALTER TABLE npc_types ADD walkspeed float DEFAULT '0.67'AFTER d_meele_texture2;

this is just an Example, walkspeed is not used anymore, so if you have you can drop it;

Code:

ALTER TABLE `npc_types` DROP walkspeed;

Changes in the MySql commandline are permanent and do not ask you if you are "sure you want to do this?", so once committed, it's over and done with.
Be sure to have a backup before you start making changes.

EDIT;
Go to GeorgeS home page, he has posted a list of all these changes needed.
http://66.159.225.58/eqemu/eq.html
you can just copy/paste what you need.

daryl · #3 10-09-2007, 11:11 PM

thanks Angelox you the man

am starting to have fun messing with mysql

daryl · #4 10-09-2007, 11:38 PM

dang guess ill have to start fresh again lol sniff :(
but hey all part of the learning experiance i guess