1 ALTER TABLE db_version CHANGE COLUMN required_7034_01_mangos_spell_proc_event required_7040_01_mangos_achievement_reward bit;
3 DROP TABLE IF EXISTS `achievement_reward`;
4 CREATE TABLE `achievement_reward` (
5 `entry` mediumint(8) unsigned NOT NULL default '0',
6 `title_A` mediumint(8) unsigned NOT NULL default '0',
7 `title_H` mediumint(8) unsigned NOT NULL default '0',
8 `item` mediumint(8) unsigned NOT NULL default '0',
9 `sender` mediumint(8) unsigned NOT NULL default '0',
10 `subject` varchar(255) default NULL,
13 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
16 DROP TABLE IF EXISTS `locales_achievement_reward`;
17 CREATE TABLE `locales_achievement_reward` (
18 `entry` mediumint(8) unsigned NOT NULL default '0',
19 `subject_loc1` varchar(100) NOT NULL default '',
20 `subject_loc2` varchar(100) NOT NULL default '',
21 `subject_loc3` varchar(100) NOT NULL default '',
22 `subject_loc4` varchar(100) NOT NULL default '',
23 `subject_loc5` varchar(100) NOT NULL default '',
24 `subject_loc6` varchar(100) NOT NULL default '',
25 `subject_loc7` varchar(100) NOT NULL default '',
26 `subject_loc8` varchar(100) NOT NULL default '',
27 `text_loc1` text default NULL,
28 `text_loc2` text default NULL,
29 `text_loc3` text default NULL,
30 `text_loc4` text default NULL,
31 `text_loc5` text default NULL,
32 `text_loc6` text default NULL,
33 `text_loc7` text default NULL,
34 `text_loc8` text default NULL,
36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;