sql-files/upgrade_svn12975_log.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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;