Fixed some file types

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/athena@172 54d463be-8e91-2dee-dedb-b68131a5f0ec

1 files changed, 140 insertions, 140 deletions

diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index 3cd854dd8..b52951aa6 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -1,141 +1,141 @@
-#Database: log

-#Table: branchlog

-CREATE TABLE `branchlog` (

-  `branch_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `branch_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `account_id` int(11) NOT NULL default '0',

-  `char_id` int(11) NOT NULL default '0',

-  `char_name` varchar(30) NOT NULL default '',

-  `map` varchar(20) NOT NULL default '',

-  PRIMARY KEY  (`branch_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: droplog

-CREATE TABLE `droplog` (

-  `drop_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `drop_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `kill_char_id` int(11) NOT NULL default '0',

-  `monster_id` smallint(6) NOT NULL default '0',

-  `item1` int(11) NOT NULL default '0',

-  `item2` int(11) NOT NULL default '0',

-  `item3` int(11) NOT NULL default '0',

-  `item4` int(11) NOT NULL default '0',

-  `item5` int(11) NOT NULL default '0',

-  `item6` int(11) NOT NULL default '0',

-  `item7` int(11) NOT NULL default '0',

-  `item8` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  PRIMARY KEY  (`drop_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: mvplog

-CREATE TABLE `mvplog` (

-  `mvp_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `kill_char_id` int(11) NOT NULL default '0',

-  `monster_id` smallint(6) NOT NULL default '0',

-  `prize` int(11) NOT NULL default '0',

-  `mvpexp` mediumint(9) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  PRIMARY KEY  (`mvp_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-

-#Database: log

-#Table: presentlog

-CREATE TABLE `presentlog` (

-  `present_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `present_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `src_id` tinyint(1) NOT NULL default '0',

-  `account_id` int(11) NOT NULL default '0',

-  `char_id` int(11) NOT NULL default '0',

-  `char_name` varchar(30) NOT NULL default '',

-  `nameid` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  PRIMARY KEY  (`present_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: producelog

-CREATE TABLE `producelog` (

-  `produce_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `produce_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `account_id` int(11) NOT NULL default '0',

-  `char_id` int(11) NOT NULL default '0',

-  `char_name` varchar(30) NOT NULL default '',

-  `nameid` int(11) NOT NULL default '0',

-  `slot1` int(11) NOT NULL default '0',

-  `slot2` int(11) NOT NULL default '0',

-  `slot3` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  `success` tinyint(1) NOT NULL default '0',

-  PRIMARY KEY  (`produce_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: refinelog

-CREATE TABLE `refinelog` (

-  `refine_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `refine_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `account_id` int(11) NOT NULL default '0',

-  `char_id` int(11) NOT NULL default '0',

-  `char_name` varchar(30) NOT NULL default '',

-  `nameid` int(11) NOT NULL default '0',

-  `refine` tinyint(2) NOT NULL default '0',

-  `card0` int(11) NOT NULL default '0',

-  `card1` int(11) NOT NULL default '0',

-  `card2` int(11) NOT NULL default '0',

-  `card3` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  `success` tinyint(1) NOT NULL default '0',

-  `item_level` tinyint(2) NOT NULL default '0',

-  PRIMARY KEY  (`refine_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: tradelog

-CREATE TABLE `tradelog` (

-  `trade_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `trade_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `src_account_id` int(11) NOT NULL default '0',

-  `src_char_id` int(11) NOT NULL default '0',

-  `src_char_name` varchar(30) NOT NULL default '',

-  `des_account_id` int(11) NOT NULL default '0',

-  `des_char_id` int(11) NOT NULL default '0',

-  `des_char_name` varchar(30) NOT NULL default '',

-  `nameid` int(11) NOT NULL default '0',

-  `amount` int(11) NOT NULL default '0',

-  `refine` tinyint(4) NOT NULL default '0',

-  `card0` int(11) NOT NULL default '0',

-  `card1` int(11) NOT NULL default '0',

-  `card2` int(11) NOT NULL default '0',

-  `card3` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  `zeny` int(11) NOT NULL default '0',

-  PRIMARY KEY  (`trade_id`)

-) TYPE=MyISAM AUTO_INCREMENT=1 ;

-

-#Database: log

-#Table: vendlog

-CREATE TABLE `vendlog` (

-  `vend_id` mediumint(9) unsigned NOT NULL auto_increment,

-  `vend_date` datetime NOT NULL default '0000-00-00 00:00:00',

-  `vend_account_id` int(11) NOT NULL default '0',

-  `vend_char_id` int(11) NOT NULL default '0',

-  `vend_char_name` varchar(30) NOT NULL default '',

-  `buy_account_id` int(11) NOT NULL default '0',

-  `buy_char_id` int(11) NOT NULL default '0',

-  `buy_char_name` varchar(30) NOT NULL default '',

-  `nameid` int(11) NOT NULL default '0',

-  `amount` int(11) NOT NULL default '0',

-  `refine` tinyint(4) NOT NULL default '0',

-  `card0` int(11) NOT NULL default '0',

-  `card1` int(11) NOT NULL default '0',

-  `card2` int(11) NOT NULL default '0',

-  `card3` int(11) NOT NULL default '0',

-  `map` varchar(20) NOT NULL default '',

-  `zeny` int(11) NOT NULL default '0',

-  KEY `vend_id` (`vend_id`)

+#Database: log
+#Table: branchlog
+CREATE TABLE `branchlog` (
+  `branch_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `branch_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `account_id` int(11) NOT NULL default '0',
+  `char_id` int(11) NOT NULL default '0',
+  `char_name` varchar(30) NOT NULL default '',
+  `map` varchar(20) NOT NULL default '',
+  PRIMARY KEY  (`branch_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: droplog
+CREATE TABLE `droplog` (
+  `drop_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `drop_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `kill_char_id` int(11) NOT NULL default '0',
+  `monster_id` smallint(6) NOT NULL default '0',
+  `item1` int(11) NOT NULL default '0',
+  `item2` int(11) NOT NULL default '0',
+  `item3` int(11) NOT NULL default '0',
+  `item4` int(11) NOT NULL default '0',
+  `item5` int(11) NOT NULL default '0',
+  `item6` int(11) NOT NULL default '0',
+  `item7` int(11) NOT NULL default '0',
+  `item8` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  PRIMARY KEY  (`drop_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: mvplog
+CREATE TABLE `mvplog` (
+  `mvp_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `kill_char_id` int(11) NOT NULL default '0',
+  `monster_id` smallint(6) NOT NULL default '0',
+  `prize` int(11) NOT NULL default '0',
+  `mvpexp` mediumint(9) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  PRIMARY KEY  (`mvp_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+
+#Database: log
+#Table: presentlog
+CREATE TABLE `presentlog` (
+  `present_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `present_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `src_id` tinyint(1) NOT NULL default '0',
+  `account_id` int(11) NOT NULL default '0',
+  `char_id` int(11) NOT NULL default '0',
+  `char_name` varchar(30) NOT NULL default '',
+  `nameid` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  PRIMARY KEY  (`present_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: producelog
+CREATE TABLE `producelog` (
+  `produce_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `produce_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `account_id` int(11) NOT NULL default '0',
+  `char_id` int(11) NOT NULL default '0',
+  `char_name` varchar(30) NOT NULL default '',
+  `nameid` int(11) NOT NULL default '0',
+  `slot1` int(11) NOT NULL default '0',
+  `slot2` int(11) NOT NULL default '0',
+  `slot3` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  `success` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`produce_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: refinelog
+CREATE TABLE `refinelog` (
+  `refine_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `refine_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `account_id` int(11) NOT NULL default '0',
+  `char_id` int(11) NOT NULL default '0',
+  `char_name` varchar(30) NOT NULL default '',
+  `nameid` int(11) NOT NULL default '0',
+  `refine` tinyint(2) NOT NULL default '0',
+  `card0` int(11) NOT NULL default '0',
+  `card1` int(11) NOT NULL default '0',
+  `card2` int(11) NOT NULL default '0',
+  `card3` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  `success` tinyint(1) NOT NULL default '0',
+  `item_level` tinyint(2) NOT NULL default '0',
+  PRIMARY KEY  (`refine_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: tradelog
+CREATE TABLE `tradelog` (
+  `trade_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `trade_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `src_account_id` int(11) NOT NULL default '0',
+  `src_char_id` int(11) NOT NULL default '0',
+  `src_char_name` varchar(30) NOT NULL default '',
+  `des_account_id` int(11) NOT NULL default '0',
+  `des_char_id` int(11) NOT NULL default '0',
+  `des_char_name` varchar(30) NOT NULL default '',
+  `nameid` int(11) NOT NULL default '0',
+  `amount` int(11) NOT NULL default '0',
+  `refine` tinyint(4) NOT NULL default '0',
+  `card0` int(11) NOT NULL default '0',
+  `card1` int(11) NOT NULL default '0',
+  `card2` int(11) NOT NULL default '0',
+  `card3` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  `zeny` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`trade_id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;
+
+#Database: log
+#Table: vendlog
+CREATE TABLE `vendlog` (
+  `vend_id` mediumint(9) unsigned NOT NULL auto_increment,
+  `vend_date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `vend_account_id` int(11) NOT NULL default '0',
+  `vend_char_id` int(11) NOT NULL default '0',
+  `vend_char_name` varchar(30) NOT NULL default '',
+  `buy_account_id` int(11) NOT NULL default '0',
+  `buy_char_id` int(11) NOT NULL default '0',
+  `buy_char_name` varchar(30) NOT NULL default '',
+  `nameid` int(11) NOT NULL default '0',
+  `amount` int(11) NOT NULL default '0',
+  `refine` tinyint(4) NOT NULL default '0',
+  `card0` int(11) NOT NULL default '0',
+  `card1` int(11) NOT NULL default '0',
+  `card2` int(11) NOT NULL default '0',
+  `card3` int(11) NOT NULL default '0',
+  `map` varchar(20) NOT NULL default '',
+  `zeny` int(11) NOT NULL default '0',
+  KEY `vend_id` (`vend_id`)
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
\ No newline at end of file