1 files changed, 20 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn12975_log.sql b/sql-files/upgrade_svn12975_log.sql
new file mode 100644
index 000000000..c6900e606
--- /dev/null
+++ b/sql-files/upgrade_svn12975_log.sql
@@ -0,0 +1,20 @@
+-- NOTE: change `ragnarok` and `log` to whatever your database names are.
+
+START TRANSACTION;
+
+CREATE TABLE `log`.`loginlog` (
+  `time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `ip` varchar( 15 ) NOT NULL ,
+  `user` varchar( 23 ) NOT NULL default '',
+  `rcode` tinyint( 4 ) NOT NULL default '0',
+  `log` varchar( 255 ) NOT NULL default '',
+  KEY `ip` ( `ip` ) 
+) ENGINE = MYISAM;
+
+INSERT INTO `log`.`loginlog` 
+  SELECT * 
+  FROM `ragnarok`.`loginlog` ;
+
+DROP TABLE `ragnarok`.`loginlog` ;
+
+COMMIT;