Rouslan
The One
Posts : 65
Join date : 2008-03-20
Location : Your BIOS
 |  Subject: Latest SQL updates Thu Mar 20, 2008 8:22 pm | |
| All updates in 1 File.Latest SQl updates in oneSQL file
-------- For revisions 4042 + -----------------
[FIX] World_Quest
Query - Quote :
- ALTER TABLE `quests` ADD COLUMN `RequiredTradeskillValue` INT(5) UNSIGNED DEFAULT 0 NOT NULL AFTER `RequiredTradeskill`;
[FIX] World_Totem_Spells - Quote :
- UPDATE totemspells set castspell1=39610 WHERE spell=16190;
[FIX] World_disenchantingloot
- Quote :
- DROP TABLE IF EXISTS `disenchantingloot`;
CREATE TABLE `disenchantingloot` (
`index` int(11) NOT NULL AUTO_INCREMENT,
`entryid` int(11) unsigned NOT NULL DEFAULT '0',
`itemid` int(11) unsigned NOT NULL DEFAULT '25',
`percentchance` float NOT NULL DEFAULT '0',
`heroicpercentchance` float DEFAULT '0',
`mincount` int(30) DEFAULT '1',
`maxcount` int(30) DEFAULT '1',
`ffa_loot` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[FIX] World_ProspectingLoot - Quote :
- DROP TABLE IF EXISTS `prospectingloot`;
CREATE TABLE `prospectingloot` (
`index` int(11) NOT NULL AUTO_INCREMENT,
`entryid` int(11) unsigned NOT NULL DEFAULT '0',
`itemid` int(11) unsigned NOT NULL DEFAULT '25',
`percentchance` float NOT NULL DEFAULT '0',
`heroicpercentchance` float DEFAULT '0',
`mincount` int(30) DEFAULT '1',
`maxcount` int(30) DEFAULT '1',
`ffa_loot` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
| |
|
