From 2b52663e421a4dd51f8aa6166cf7105d7e782d9a Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Tue, 14 Apr 2009 12:38:12 +0200 Subject: Ticket system changes by Disassembler: (TC1 rev 1358) - Change uint16 closed guid to uint64 - Add createtime field --HG-- branch : trunk --- sql/updates/2683_characters.sql | 1 + sql/updates/2683_world.sql | 3 +++ 2 files changed, 4 insertions(+) create mode 100644 sql/updates/2683_characters.sql create mode 100644 sql/updates/2683_world.sql (limited to 'sql') diff --git a/sql/updates/2683_characters.sql b/sql/updates/2683_characters.sql new file mode 100644 index 00000000000..688e151b430 --- /dev/null +++ b/sql/updates/2683_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`; diff --git a/sql/updates/2683_world.sql b/sql/updates/2683_world.sql new file mode 100644 index 00000000000..ead79e05b61 --- /dev/null +++ b/sql/updates/2683_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); -- cgit v1.2.3