From b3bca2743ef2312d443055e9389dc9f999215563 Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Sat, 31 Jul 2010 06:22:40 +0200
Subject: 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
---
 sql/base/world_database.sql                      | 1 +
 sql/updates/9108_world_battleground_template.sql | 1 +
 2 files changed, 2 insertions(+)
 create mode 100644 sql/updates/9108_world_battleground_template.sql

(limited to 'sql')

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 ;
-- 
cgit v1.2.3