diff options
Diffstat (limited to 'sql-files/upgrade_svn12975_log.sql')
-rw-r--r-- | sql-files/upgrade_svn12975_log.sql | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/sql-files/upgrade_svn12975_log.sql b/sql-files/upgrade_svn12975_log.sql deleted file mode 100644 index 3c9aa5cff..000000000 --- a/sql-files/upgrade_svn12975_log.sql +++ /dev/null @@ -1,20 +0,0 @@ --- 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; |