View Single Post
  #1  
Old 02-15-2003, 12:55 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default ALTER TABLE variables ADD COLUMN ts timestamp NULL;

** Added 12:55am 2/15/2003**
If you are upgrading your server, do not forget to run this command in mysql:

ALTER TABLE variables ADD COLUMN ts timestamp NULL;

This will update your table structure to work with the new files.

--------------------------------------------------------------------------------

A little feed back from my server. I upgraded from 4.1 without doing a rebuild put this SQL command in, and all of my NPC disappeared. Went back to a db without the alter table in there and i got a few errors on server boot, but now all my npc's are back. Is this a bug or just issues with my server/sql?
Reply With Quote