From 5d2cee1c2e67a492c19d440b1f997ca216f11d91 Mon Sep 17 00:00:00 2001 From: DDuarte Date: Tue, 6 Oct 2015 14:54:43 +0100 Subject: Rename SQL after PR merge --- sql/base/characters_database.sql | 2 +- sql/updates/characters/2015_10_03_03_characters.sql | 2 -- sql/updates/characters/2015_10_06_00_characters.sql | 2 ++ 3 files changed, 3 insertions(+), 3 deletions(-) delete mode 100644 sql/updates/characters/2015_10_03_03_characters.sql create mode 100644 sql/updates/characters/2015_10_06_00_characters.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index d8d2fe63b70..a11e0e55f07 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2510,7 +2510,7 @@ CREATE TABLE `updates` ( LOCK TABLES `updates` WRITE; /*!40000 ALTER TABLE `updates` DISABLE KEYS */; -INSERT INTO `updates` VALUES ('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0),('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0),('2015_10_03_03_characters.sql', '82DC1DC8C4104C8A2F523DD2D28E444E0D4E7482', 'ARCHIVED', '2015-10-03 16:06:38', 0); +INSERT INTO `updates` VALUES ('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0),('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0),('2015_10_06_00_characters.sql', '16842FDD7E8547F2260D3312F53EFF8761EFAB35', 'ARCHIVED', '2015-10-06 16:06:38', 0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/2015_10_03_03_characters.sql b/sql/updates/characters/2015_10_03_03_characters.sql deleted file mode 100644 index c8d8e3211f4..00000000000 --- a/sql/updates/characters/2015_10_03_03_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `gm_ticket` - ADD COLUMN `resolvedBy` INT(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket' AFTER `needMoreHelp`; diff --git a/sql/updates/characters/2015_10_06_00_characters.sql b/sql/updates/characters/2015_10_06_00_characters.sql new file mode 100644 index 00000000000..c8d8e3211f4 --- /dev/null +++ b/sql/updates/characters/2015_10_06_00_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `gm_ticket` + ADD COLUMN `resolvedBy` INT(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket' AFTER `needMoreHelp`; -- cgit v1.2.3