summaryrefslogtreecommitdiff
path: root/sql-files/logs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/logs.sql')
-rw-r--r--sql-files/logs.sql280
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