From 3e108f068026e6bc54828c2f829c728928c349c7 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Sun, 2 Jun 2013 19:28:53 +0200 Subject: DB/Autobroadcast: Update correct db struktur and auth base --- sql/base/auth_database.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'sql/base') 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 @@ -109,6 +109,20 @@ LOCK TABLES `account_banned` WRITE; /*!40000 ALTER TABLE `account_banned` ENABLE KEYS */; 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` -- -- cgit v1.2.3