From 1624d1d57db3cfde3b4f42a55580f5a1e742f28e Mon Sep 17 00:00:00 2001
From: ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Sat, 26 Jul 2008 20:45:57 +0000
Subject: Merged the /loginmerge branch (topic:192754)  * the login server
 storage, ipban and logging systems have been abstracted and now provide a
 common interface; the rest has been merged into a single login server core
 (no more login/login_sql duplicity)  * storage systems are now added via
 compiler options (WITH_SQL / WITH_TXT)  * multiple storage engines can be
 compiled in at the same time, and the config option account.engine defines
 which one will be used.  * due to MySQL autoincrement limitations, accounts
 with id '0' will not be supported; account IDs from this point on should
 start from '1'.  * login_log() functions now again record IP addresses in
 dotted format, not as 4-byte integers (undo from r6868).  * removed config
 options that defined column names in the login table  * removed `memo` and
 `error message` columns from login db/savefile  * moved `loginlog` table to
 the logs database  * added sql files upgrade_svn12975.sql and
 upgrade_svn12975_log.sql  * due to changes to the login table layout, I added
 an !optional! sql file (upgrade_svn12975_view.sql) that will provide a
 certain degree of backwards compatibility with existing software; read the
 instructions inside carefully!  * moved third-party includes/libs to a
 separate directory  * updated project files / makefiles

Changed the way GM levels are handled
 * removed conf/gm_account.txt
 * added the gm level column to the txt savefile (after 'email' column)
 * gm level information is now transferred along with account data

For open problems see bugreport:1889.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13000 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/logs.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'sql-files/logs.sql')

diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index 09895263b..b46b34355 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -113,3 +113,15 @@ CREATE TABLE `chatlog` (
   INDEX (`src_accountid`),
   INDEX (`src_charid`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: loginlog
+CREATE TABLE `loginlog` (
+  `time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `ip` varchar(15) NOT NULL default '',
+  `user` varchar(23) NOT NULL default '',
+  `rcode` tinyint(4) NOT NULL default '0',
+  `log` varchar(255) NOT NULL default '',
+  INDEX (`ip`)
+) ENGINE=MyISAM ;
+
-- 
cgit v1.2.3-70-g09d2

