aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorclick <none@none>2010-07-31 06:22:40 +0200
committerclick <none@none>2010-07-31 06:22:40 +0200
commitb3bca2743ef2312d443055e9389dc9f999215563 (patch)
tree6625bc5f378b78a191017b4df013edee63dc03a2
parent60b119e0cafc1d0bc89bf81e81be00856b0ae42d (diff)
Core/SQL: Add commentfield in battleground_template
Support-data found on TDB : http://forum.trinitycore.org/forum/122-core-related-db-content/ --HG-- branch : trunk
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/9108_world_battleground_template.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index efca1c78603..d4af498680a 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -241,6 +241,7 @@ CREATE TABLE `battleground_template` (
`AllianceStartO` float NOT NULL,
`HordeStartLoc` mediumint(8) unsigned NOT NULL,
`HordeStartO` float NOT NULL,
+ `Comment` char(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/9108_world_battleground_template.sql b/sql/updates/9108_world_battleground_template.sql
new file mode 100644
index 00000000000..bd01fcbc14f
--- /dev/null
+++ b/sql/updates/9108_world_battleground_template.sql
@@ -0,0 +1 @@
+ALTER TABLE `battleground_template` ADD `Comment` CHAR(32) NOT NULL ;