SQL updates for Antrix/Ascent since rev943

[gmaze]

All database table changes, and the revisions they apply too:

revision 736 +

ALTER TABLE  `creature_proto` ADD COLUMN `money` INT (30) DEFAULT '0' NOT NULL  AFTER`boss`;

revision 941 +

CREATE TABLE `creature_staticspawns` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`entry` int(30) NOT NULL,
`map` int(11) NOT NULL DEFAULT '0',
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`0` float NOT NULL,
`movetype` int(11) NOT NULL DEFAULT '0',
`displayid` int(11) NOT NULL,
`factionid` int(11) NOT NULL DEFAULT '0',
`flags` int(30) NOT NULL DEFAULT '0',
`bytes` int(30) NOT NULL DEFAULT '0',
`bytes2` int(30) NOT NULL DEFAULT '0',
`emote_state` int(11) NOT NULL DEFAULT '0',
`respawnNpcLink` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `gameobject_staticspawns` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`entry` int(30) NOT NULL,
`map` int(11) NOT NULL DEFAULT '0',
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`facing` float NOT NULL,
`0` float NOT NULL,
`01` float NOT NULL,
`02` float NOT NULL,
`03` float NOT NULL,
`state` int(11) NOT NULL DEFAULT '0',
`flags` int(30) NOT NULL DEFAULT '0',
`faction` int(11) NOT NULL DEFAULT '0',
`scale` float NOT NULL,
`respawnNpcLink` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
alter table worldmap_info add column required_quest int(30) not null default 0 after lvl_mod_a;
alter table worldmap_info add column required_itemid int(30) not null default 0 after lvl_mod_a;

revision 1071 +

ALTER TABLE creatureloot DROP heroicchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;
ALTER TABLE fishingloot DROP heroicchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;
ALTER TABLE itemloot DROP heroicchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;
ALTER TABLE objectloot DROP heroicchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;
ALTER TABLE pickpocketingloot DROP heroicchance;
ALTER TABLE pickpocketingloot DROP mincount;
ALTER TABLE pickpocketingloot DROP maxcount;
ALTER TABLE prospectingloot DROP heroicchance;
ALTER TABLE prospectingloot DROP mincount;
ALTER TABLE prospectingloot DROP maxcount;
ALTER TABLE skinningloot DROP heroicchance;
ALTER TABLE skinningloot DROP mincount;
ALTER TABLE skinningloot DROP maxcount;
ALTER TABLE creatureloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE creatureloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE creatureloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE creatureloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE fishingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE fishingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE fishingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE fishingloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE itemloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE itemloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE itemloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE itemloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE objectloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE objectloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE objectloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE objectloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE pickpocketingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE pickpocketingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE pickpocketingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE pickpocketingloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE prospectingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE prospectingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE prospectingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE prospectingloot ADD column maxcount int(30) NOT NULL default 1;
ALTER TABLE skinningloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE skinningloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE skinningloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE skinningloot ADD column maxcount int(30) NOT NULL default 1;

revision 1132 +

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;

revision 1143 +

CREATE TABLE `zoneguards` (
  `zoneId` int(10) unsigned NOT NULL,
  `hordeEntry` int(10) unsigned default NULL,
  `allianceEntry` int(10) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

revision 1360 +

DROP TABLE `playerpets`;
CREATE TABLE `playerpets` (
  `ownerguid` bigint(20) NOT NULL default '0',
  `petnumber` int(11) NOT NULL default '0',
  `name` varchar(21) NOT NULL default '',
  `entryid` bigint(20) NOT NULL default '0',
  `data` longtext NOT NULL,
  `xp` int(11) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `happiness` int(11) NOT NULL default '0',
  `actionbar` varchar(200) NOT NULL default '',
  `happinessupdate` int(11) NOT NULL default '0',
  `summon` int(11) NOT NULL default '0',
  `autocastspell` int(11) NOT NULL default '0',
  `loyaltypts` int(11) NOT NULL default '0',
  `loyaltyupdate` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

revision 1382 +

alter table playeritems drop column guid;
alter table playeritems add column guid bigint(10) NOT NULL auto_increment primary key after ownerguid;

revision 1393 +

CREATE TABLE `banned_names` (`name` varchar(30) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;

revision 1425 +

update ai_agents set spellCooldown=-1 where spellCooldown=0

revision 1472 +

INSERT INTO totemspells (spellId, spellToCast1, spellToCast2, spellToCast3) VALUES (2894, 32982, 0, 0);
INSERT INTO totemspells (spellId, spellToCast1, spellToCast2, spellToCast3) VALUES (2062, 33663, 0, 0);

revision 1542 +

CREATE TABLE `charters` (
  `charterId` int(30) NOT NULL,
  `charterType` int(30) NOT NULL default '0',
  `leaderGuid` int(20) unsigned NOT NULL default '0',
  `guildName` varchar(32) NOT NULL default '',
  `itemGuid` bigint(40) unsigned NOT NULL default '0',
  `signer1` int(10) unsigned NOT NULL default '0',
  `signer2` int(10) unsigned NOT NULL default '0',
  `signer3` int(10) unsigned NOT NULL default '0',
  `signer4` int(10) unsigned NOT NULL default '0',
  `signer5` int(10) unsigned NOT NULL default '0',
  `signer6` int(10) unsigned NOT NULL default '0',
  `signer7` int(10) unsigned NOT NULL default '0',
  `signer8` int(10) unsigned NOT NULL default '0',
  `signer9` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`charterId`),
  UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `arenateams` (
  `id` int(30) NOT NULL,
  `type` int(30) NOT NULL,
  `leader` int(30) NOT NULL,
  `name` varchar(150) NOT NULL,
  `emblemstyle` int(40) NOT NULL,
  `emblemcolour` bigint(40) NOT NULL,
  `borderstyle` int(40) NOT NULL,
  `bordercolour` bigint(40) NOT NULL,
  `backgroundcolour` bigint(40) NOT NULL,
  `rating` int(30) NOT NULL,
  `data` varchar(150) NOT NULL,
  `ranking` int(30) NOT NULL,
  `player_data1` varchar(60) NOT NULL,
  `player_data2` varchar(60) NOT NULL,
  `player_data3` varchar(60) NOT NULL,
  `player_data4` varchar(60) NOT NULL,
  `player_data5` varchar(60) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

revision 1602 +

CREATE TABLE `server_settings` (
  `setting_id` varchar(200) NOT NULL,
  `setting_value` int(50) NOT NULL,
  PRIMARY KEY  (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
alter table characters change lastDailyReset honorPointsToAdd INT(10) NOT NULL;
update characters set honorPointsToAdd = 0;
alter table characters change charterId arenaPoints INT(10) NOT NULL;
update characters set arenaPoints = 0;

revision 1603 +

alter table creature_names change displayid male_displayid int(30) not null;
alter table creature_names add column female_displayid int(30) not null after male_displayid;
alter table creature_names add column unknown_int1 int(30) not null default 0 after female_displayid;
alter table creature_names add column unknown_int2 int(30) not null default 0 after unknown_int1;
alter table creature_names change unk2 unknown_float1 float(0) not null;
alter table creature_names change unk3 unknown_float2 float(0) not null;
alter table creature_proto add column fly_speed float(0) default "14.0" not null;
alter table creature_proto add column extra_a9_flags int(30) default 0 not null;

revision 1730 +

alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;

revision 1743 +

CREATE TABLE `spell_proc_data` (
  `name_hash` int(30) NOT NULL,
  `proc_chance` int(30) NOT NULL,
  `forced_proc_flags` int(30) NOT NULL default '-1',
  PRIMARY KEY  (`name_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

revision 1786 +

alter table characters add column custom_faction int(30) default 0 not null after gender;

revision 1837 +

DROP TABLE IF EXISTS `trainer_spells`;
CREATE TABLE `trainer_spells` (
  `entry` int(11) unsigned NOT NULL DEFAULT '0',
  `cast_spell` int(11) unsigned NOT NULL DEFAULT '0',
  `spellcost` int(11) unsigned NOT NULL DEFAULT '0',
  `reqspell` int(11) unsigned NOT NULL DEFAULT '0',
  `reqskill` int(11) unsigned NOT NULL DEFAULT '0',
  `reqskillvalue` int(11) unsigned NOT NULL DEFAULT '0',
  `reqlevel` int(11) unsigned NOT NULL DEFAULT '0',
  `deletespell` int(11) unsigned NOT NULL DEFAULT '0',
  `is_prof` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry`,`cast_spell`),
  KEY `entry` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trainer System';
DROP TABLE IF EXISTS `trainer_defs`;
CREATE TABLE `trainer_defs` (
  `entry` int(11) unsigned NOT NULL DEFAULT '0',
  `required_skill` int(11) unsigned NOT NULL DEFAULT '0',
  `required_skillvalue` int(11) unsigned DEFAULT '0',
  `req_class` int(11) unsigned NOT NULL DEFAULT '0',
  `trainer_type` int(11) unsigned NOT NULL DEFAULT '0',
  `trainer_ui_window_message` text,
  `can_train_gossip_textid` int(11) NOT NULL,
  `cannot_train_gossip_textid` int(11) NOT NULL,
  PRIMARY KEY (`entry`),
  UNIQUE KEY `entry` (`entry`),
  KEY `entry_2` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trainer System';

revision 1844 +

ALTER TABLE playerpets DROP COLUMN autocastspell;
UPDATE playerpets SET actionbar="";

revision 1918 +

DROP TABLE IF EXISTS `item_randomprop_groups`;
CREATE TABLE `item_randomprop_groups` (
   `entry_id` int(30) NOT NULL,
   `randomprops_entryid` int(30) NOT NULL,
   `chance` float NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `item_randomsuffix_groups`;
CREATE TABLE `item_randomsuffix_groups` (
   `entry_id` int(30) NOT NULL,
   `randomsuffix_entryid` int(30) NOT NULL,
   `chance` float NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

revision 1923 +

alter table playeritems add column randomsuffix int(30) default 0 after randomprop;