PDA

View Full Version : lootdrop_entries => Disabled Chance? & zone => Type?


Irreverent
02-17-2013, 08:41 AM
I just did a refresh to the DB and code and noticed that there was no .sql in the code nor DB sql folders that specified this change.

If you don't do a drop/define here is the fix:
ALTER TABLE `lootdrop_entries` ADD `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT '0';


fix to zone table:

ALTER TABLE `zone` ADD COLUMN `type` tinyint(3) NOT NULL DEFAULT 0 AFTER `suspendbuffs`;


I know there is quite a few moves to tools going on, but these two seemed to either missed or changed where they report the required DB updates (either in code /utils/sql or db /updates)

Was this an oops or should I start looking at other folders?

Irreverent
02-17-2013, 09:58 AM
FIX FIX! Couldn't edit message above, do not use it!

Use below:

ALTER TABLE `lootdrop_entries` ADD `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT '0' after `chance`;