aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorMachiavelli <none@none>2009-04-14 01:27:43 +0200
committerMachiavelli <none@none>2009-04-14 01:27:43 +0200
commite2a4b4d1789be393060874c0253e56e5ee0b3a42 (patch)
tree05b8f3b2df8deedcf9cf62bab7a8b21bc924e47b /sql/updates
parent57b33b244f281119e41f83f8b8655bb0042ec24d (diff)
Ticket system changes by Disassembler:
- Change uint16 closed guid to uint64 - Add createtime field --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/1358_characters.sql1
-rw-r--r--sql/updates/1358_world.sql3
2 files changed, 4 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);