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 ++++++++++++++ sql/updates/auth/2013_06_02_00_auth_autobroadcast.sql | 5 +++++ 2 files changed, 19 insertions(+) create mode 100644 sql/updates/auth/2013_06_02_00_auth_autobroadcast.sql (limited to 'sql') 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` -- diff --git a/sql/updates/auth/2013_06_02_00_auth_autobroadcast.sql b/sql/updates/auth/2013_06_02_00_auth_autobroadcast.sql new file mode 100644 index 00000000000..2e689ffd64d --- /dev/null +++ b/sql/updates/auth/2013_06_02_00_auth_autobroadcast.sql @@ -0,0 +1,5 @@ +ALTER TABLE `autobroadcast` + CHANGE `realmid` `realmid` INT(11) NOT NULL DEFAULT '-1', + CHANGE `id` `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, + CHANGE `weight` `weight` TINYINT(3) UNSIGNED DEFAULT '1', + ENGINE=INNODB; -- cgit v1.2.3