aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql1
-rw-r--r--sql/updates/auth/2015_04_11_01_auth.sql1
2 files changed, 1 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 866088cf4ac..ca4e56f75e7 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -180,7 +180,6 @@ CREATE TABLE `battlenet_account_bans` (
`unbandate` int(10) unsigned NOT NULL DEFAULT '0',
`bannedby` varchar(50) NOT NULL,
`banreason` varchar(255) NOT NULL,
- `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`bandate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/auth/2015_04_11_01_auth.sql b/sql/updates/auth/2015_04_11_01_auth.sql
new file mode 100644
index 00000000000..3d205b86298
--- /dev/null
+++ b/sql/updates/auth/2015_04_11_01_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `battlenet_account_bans` DROP COLUMN `active`;