aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorjoschiwald <joschiwald@online.de>2013-06-02 19:28:53 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2013-06-02 19:41:27 +0200
commit3e108f068026e6bc54828c2f829c728928c349c7 (patch)
tree9190a7e65f58ca8e4f2c454f36ffd2993769f08f /sql/base
parent15b055fe87b381c143341dca1686bfe0f9aef152 (diff)
DB/Autobroadcast: Update correct db struktur and auth base
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 05e680f94eb..bf2d3f9256d 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -110,6 +110,20 @@ LOCK TABLES `account_banned` WRITE;
UNLOCK TABLES;
--
+-- Dumping data for table `autobroadcast`
+--
+
+DROP TABLE IF EXISTS `autobroadcast`;
+
+CREATE TABLE `autobroadcast` (
+ `realmid` int(11) NOT NULL DEFAULT '-1',
+ `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
+ `weight` tinyint(3) unsigned DEFAULT '1',
+ `text` longtext NOT NULL,
+ PRIMARY KEY (`id`,`realmid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `ip_banned`
--