From a269c22b8d92b56a6b09bc2fa8375d1803cab909 Mon Sep 17 00:00:00 2001 From: brianluau Date: Mon, 27 Jul 2009 16:56:26 +0000 Subject: - Added svn:eol-style native for some conf/css/html/pl/sql/txt files. - Added svn:executable property for several batch/shell scripts. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13972 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/upgrade_svn12975_log.sql | 40 +++++++++++++++++++------------------- 1 file changed, 20 insertions(+), 20 deletions(-) (limited to 'sql-files/upgrade_svn12975_log.sql') diff --git a/sql-files/upgrade_svn12975_log.sql b/sql-files/upgrade_svn12975_log.sql index c6900e606..3c9aa5cff 100644 --- a/sql-files/upgrade_svn12975_log.sql +++ b/sql-files/upgrade_svn12975_log.sql @@ -1,20 +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; +-- 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; -- cgit v1.2.3-70-g09d2