diff options
| author | Yehonal <yehonal.azeroth@gmail.com> | 2016-09-04 14:41:03 +0200 |
|---|---|---|
| committer | Yehonal <yehonal.azeroth@gmail.com> | 2016-09-04 14:41:03 +0200 |
| commit | ce219ce7e45cef460e806394431ef71802f7677b (patch) | |
| tree | 132f5f41e1ef37b69a7ab55940d354037b70ce98 | |
| parent | 3db4c1717b5962e93a364dce37f1ca1a21b9bac5 (diff) | |
Created auth logs table for db logging system
Fixed server startup
| -rw-r--r-- | data/sql/updates/db_auth/2016_09_04_00.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/data/sql/updates/db_auth/2016_09_04_00.sql b/data/sql/updates/db_auth/2016_09_04_00.sql new file mode 100644 index 0000000000..32cc1df42a --- /dev/null +++ b/data/sql/updates/db_auth/2016_09_04_00.sql @@ -0,0 +1,13 @@ +START TRANSACTION; + +ALTER TABLE version_db_auth CHANGE COLUMN 2016_08_25_01 2016_09_04_00 bit; + +CREATE TABLE `logs` ( + `time` int(10) unsigned NOT NULL, + `realm` int(10) unsigned NOT NULL, + `type` varchar(250) NOT NULL, + `level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `string` text CHARACTER SET latin1 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +COMMIT; |