diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1358_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/1358_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/1362_world.sql | 10 | ||||
| -rw-r--r-- | sql/updates/1366_characters.sql | 4 | ||||
| -rw-r--r-- | sql/updates/1366_world.sql | 1 |
5 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/1358_characters.sql b/sql/updates/1358_characters.sql new file mode 100644 index 00000000000..688e151b430 --- /dev/null +++ b/sql/updates/1358_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`; diff --git a/sql/updates/1358_world.sql b/sql/updates/1358_world.sql new file mode 100644 index 00000000000..ead79e05b61 --- /dev/null +++ b/sql/updates/1358_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry`=2025; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +('2025','|cff00ff00Created|r:|cff00ccff %s ago|r ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/updates/1362_world.sql b/sql/updates/1362_world.sql new file mode 100644 index 00000000000..a6d786871d6 --- /dev/null +++ b/sql/updates/1362_world.sql @@ -0,0 +1,10 @@ +DROP TABLE IF EXISTS `creature_linked_respawn`; +CREATE TABLE `creature_linked_respawn` ( + `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature', + `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System'; + +DELETE FROM `trinity_string` WHERE `entry` = '750'; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +('750', 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/1366_characters.sql b/sql/updates/1366_characters.sql new file mode 100644 index 00000000000..8a8d61c2b91 --- /dev/null +++ b/sql/updates/1366_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `map` INT NOT NULL DEFAULT '0' AFTER `createtime`; +ALTER TABLE `gm_tickets` ADD COLUMN `posX` FLOAT NOT NULL DEFAULT '0' AFTER `map`; +ALTER TABLE `gm_tickets` ADD COLUMN `posY` FLOAT NOT NULL DEFAULT '0' AFTER `posX`; +ALTER TABLE `gm_tickets` ADD COLUMN `posZ` FLOAT NOT NULL DEFAULT '0' AFTER `posY`; diff --git a/sql/updates/1366_world.sql b/sql/updates/1366_world.sql new file mode 100644 index 00000000000..a22254a9d2a --- /dev/null +++ b/sql/updates/1366_world.sql @@ -0,0 +1 @@ +insert into `command` (`name`, `security`, `help`) values('go ticket','1','Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.'); |