aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorMachiavelli <none@none>2009-04-14 12:38:12 +0200
committerMachiavelli <none@none>2009-04-14 12:38:12 +0200
commit2b52663e421a4dd51f8aa6166cf7105d7e782d9a (patch)
tree9109b1872e9e5983bef9fbc089b3ddb7653d3e01 /sql/updates
parent2104356342943b69e141c3fd0a7e4e149931345a (diff)
Ticket system changes by Disassembler: (TC1 rev 1358)
- Change uint16 closed guid to uint64 - Add createtime field --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/2683_characters.sql1
-rw-r--r--sql/updates/2683_world.sql3
2 files changed, 4 insertions, 0 deletions
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);