From 898e30a3c034c30ab26369a3cc322458e49aef49 Mon Sep 17 00:00:00 2001
From: Lupus <Lupus@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Sun, 7 May 2006 09:50:37 +0000
Subject: removed old logs

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6510 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/logs.sql | 120 -----------------------------------------------------
 1 file changed, 120 deletions(-)

(limited to 'sql-files')

diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index 296657934..aae128398 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -46,27 +46,6 @@ CREATE TABLE `branchlog` (
   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',
-  `item9` int(11) NOT NULL default '0',
-  `itemCard` int(11) NOT NULL default '0',
-  `map` varchar(20) NOT NULL default 'prontera.gat',
-  PRIMARY KEY  (`drop_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
-
 #Database: log
 #Table: mvplog
 CREATE TABLE `mvplog` (
@@ -80,104 +59,6 @@ CREATE TABLE `mvplog` (
   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 'prontera.gat',
-  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 'prontera.gat',
-  `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 'prontera.gat',
-  `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 '1',
-  `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 'prontera.gat',
-  `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 '1',
-  `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 'prontera.gat',
-  `zeny` int(11) NOT NULL default '0',
-  KEY `vend_id` (`vend_id`)
-) TYPE=MyISAM AUTO_INCREMENT=1 ;
-
 #Database: log
 #Table: atcommandlog
 CREATE TABLE `atcommandlog` (
@@ -204,7 +85,6 @@ CREATE TABLE `npclog` (
   PRIMARY KEY  (`npc_id`)
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
-
 #ChatLOG
 CREATE TABLE `chatlog` (
   `id` bigint(20) NOT NULL auto_increment,
-- 
cgit v1.2.3-70-g09d2