aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10_world.sql6
-rw-r--r--sql/updates/40_world.sql4
-rw-r--r--sql/updates/45_characters.sql13
-rw-r--r--sql/updates/45_world.sql68
-rw-r--r--sql/updates/mangos_string_to_trinity_string.sql1
5 files changed, 88 insertions, 4 deletions
diff --git a/sql/updates/10_world.sql b/sql/updates/10_world.sql
index bfe967ad293..9f3f79ebfa9 100644
--- a/sql/updates/10_world.sql
+++ b/sql/updates/10_world.sql
@@ -15,9 +15,9 @@ INSERT INTO `command` (`name`, `security`, `help`) VALUES
('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.');
-DELETE FROM mangos_string WHERE entry IN (711,712);
-DELETE FROM mangos_string WHERE entry BETWEEN 730 AND 745;
-INSERT INTO mangos_string (entry, content_default) VALUES
+DELETE FROM trinity_string WHERE entry IN (711,712);
+DELETE FROM trinity_string WHERE entry BETWEEN 730 AND 745;
+INSERT INTO trinity_string (entry, content_default) VALUES
(711,'Your group is too large for this battleground. Please regroup to join.'),
(712,'Your group is too large for this arena. Please regroup to join.'),
(730,'Your group has members not in your arena team. Please regroup to join.'),
diff --git a/sql/updates/40_world.sql b/sql/updates/40_world.sql
index 9ad2709821f..123a8cbce2e 100644
--- a/sql/updates/40_world.sql
+++ b/sql/updates/40_world.sql
@@ -69,7 +69,9 @@ CREATE TABLE `IRC_AutoAnnounce` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IRC Module System';
-- Add ircpm command.
+delete from `command` WHERE `name`='ircpm';
insert into `command` (`name`, `security`, `help`) values ('ircpm', 0, 'Syntax: .ircpm <user> <text>\n\nSends a PM with <text> to <user> on IRC.');
-- Add auto announce string.
-insert into `mangos_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('746','|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+DELETE FROM `trinity_string` WHERE `entry`=746;
+insert into `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('746','|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/45_characters.sql b/sql/updates/45_characters.sql
new file mode 100644
index 00000000000..9f370ba909c
--- /dev/null
+++ b/sql/updates/45_characters.sql
@@ -0,0 +1,13 @@
+CREATE TABLE `game_event_save` (
+ `event_id` mediumint(8) unsigned NOT NULL,
+ `state` tinyint(3) unsigned NOT NULL default '1',
+ `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
+ PRIMARY KEY (`event_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_condition_save` (
+ `event_id` mediumint(8) unsigned NOT NULL,
+ `condition_id` mediumint(8) unsigned NOT NULL default '0',
+ `done` float default '0',
+ PRIMARY KEY (`event_id`,`condition_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/45_world.sql b/sql/updates/45_world.sql
new file mode 100644
index 00000000000..e5d94deecb2
--- /dev/null
+++ b/sql/updates/45_world.sql
@@ -0,0 +1,68 @@
+ALTER TABLE game_event ADD COLUMN world_event tinyint(3) unsigned not null default 0 comment '0 if normal event, 1 if world event';
+
+CREATE TABLE `game_event_quest_condition` (
+ `quest` mediumint(8) unsigned NOT NULL default '0',
+ `event_id` mediumint(8) unsigned NOT NULL default '0',
+ `condition_id` mediumint(8) unsigned NOT NULL default '0',
+ `num` float default '0',
+ PRIMARY KEY (`quest`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_condition` (
+ `event_id` mediumint(8) unsigned NOT NULL default '0',
+ `condition_id` mediumint(8) unsigned NOT NULL default '0',
+ `req_num` float default '0',
+ `max_world_state_field` smallint(5) unsigned NOT NULL default '0',
+ `done_world_state_field` smallint(5) unsigned NOT NULL default '0',
+ `description` varchar(25) NOT NULL default '',
+ PRIMARY KEY (`event_id`,`condition_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_npcflag` (
+ `guid` mediumint(8) unsigned NOT NULL default '0',
+ `event_id` mediumint(8) unsigned NOT NULL default '0',
+ `npcflag` int(10) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`event_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_prerequisite` (
+ `event_id` mediumint(8) unsigned NOT NULL,
+ `prerequisite_event` mediumint(8) unsigned NOT NULL,
+ PRIMARY KEY (`event_id`,`prerequisite_event`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_npc_gossip` (
+ `guid` int(10) unsigned NOT NULL,
+ `event_id` mediumint(8) unsigned NOT NULL default '0',
+ `textid` mediumint(8) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_gameobject_quest` (
+ `id` mediumint(8) unsigned NOT NULL default '0',
+ `quest` mediumint(8) unsigned NOT NULL default '0',
+ `event` smallint(5) unsigned NOT NULL default '0',
+ PRIMARY KEY (`quest`,`event`,`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE `game_event_npc_vendor` (
+ `event` mediumint(8) unsigned NOT NULL default '0',
+ `guid` mediumint(8) unsigned NOT NULL default '0',
+ `item` mediumint(8) unsigned NOT NULL default '0',
+ `maxcount` mediumint(8) unsigned NOT NULL default '0',
+ `incrtime` mediumint(8) unsigned NOT NULL default '0',
+ `ExtendedCost` mediumint(8) unsigned NOT NULL default '0',
+ PRIMARY KEY (`guid`,`item`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE game_event_creature_quest DROP PRIMARY KEY, ADD PRIMARY KEY (quest, event, id);
+
+ALTER TABLE game_event_creature DROP PRIMARY KEY, ADD PRIMARY KEY (guid, event);
+
+ALTER TABLE game_event_gameobject DROP PRIMARY KEY, ADD PRIMARY KEY (guid, event);
+
+DELETE FROM `command` WHERE `name` LIKE 'debug threatlist';
+DELETE FROM `command` WHERE `name` LIKE 'debug hostilrefs';
+INSERT INTO `command` VALUES
+('debug threatlist', 3, 'Syntax: .debug threatlist\n\n Prints out the current threatlist of the targetted creature.'),
+('debug hostilrefs', 3, 'Syntax: .debug hostilrefs\n\n Prints out the hostil refs of the targetted unit.');
diff --git a/sql/updates/mangos_string_to_trinity_string.sql b/sql/updates/mangos_string_to_trinity_string.sql
new file mode 100644
index 00000000000..0f5dc999628
--- /dev/null
+++ b/sql/updates/mangos_string_to_trinity_string.sql
@@ -0,0 +1 @@
+ALTER TABLE `mangos_string` RENAME TO `trinity_string`;