diff options
| author | leak <leak@bitmx.net> | 2012-03-25 21:22:53 +0200 |
|---|---|---|
| committer | leak <leak@bitmx.net> | 2012-03-25 21:23:27 +0200 |
| commit | ffbee169f49d2eba408d76a1e181a3e4589dd8ab (patch) | |
| tree | 08294058274ac02cc7aed2b66ed1c0193cc80045 /sql | |
| parent | fa1d3f305b6a31c11b068a3d10924d2adc9d8279 (diff) | |
Core/DBLayer: Restore pinfo ban info output
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/auth/2012_03_25_00_auth_misc.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/auth/2012_03_25_00_auth_misc.sql b/sql/updates/auth/2012_03_25_00_auth_misc.sql new file mode 100644 index 00000000000..f34882af8f6 --- /dev/null +++ b/sql/updates/auth/2012_03_25_00_auth_misc.sql @@ -0,0 +1,8 @@ +ALTER TABLE `account_banned` + CHANGE `bandate` `bandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `unbandate` `unbandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `ip_banned` + CHANGE `ip` `ip` VARCHAR(15) CHARSET utf8 COLLATE utf8_general_ci DEFAULT '127.0.0.1' NOT NULL, + CHANGE `bandate` `bandate` INT(10) UNSIGNED NOT NULL, + CHANGE `unbandate` `unbandate` INT(10) UNSIGNED NOT NULL; |