diff options
author | Valaris <Valaris@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-01-29 16:00:45 +0000 |
---|---|---|
committer | Valaris <Valaris@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-01-29 16:00:45 +0000 |
commit | a2675f07d7da22a7c6ae11f545bf8f671e785a82 (patch) | |
tree | 4b825dc642cb6eb9a060e54bf8d69288fbee4904 /sql-files/logs.sql | |
parent | b8801ae9585201eaaf9fdf80d9c7117ee18f52e2 (diff) | |
download | hercules-a2675f07d7da22a7c6ae11f545bf8f671e785a82.tar.gz hercules-a2675f07d7da22a7c6ae11f545bf8f671e785a82.tar.bz2 hercules-a2675f07d7da22a7c6ae11f545bf8f671e785a82.tar.xz hercules-a2675f07d7da22a7c6ae11f545bf8f671e785a82.zip |
Clearing trunk.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5091 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/logs.sql')
-rw-r--r-- | sql-files/logs.sql | 169 |
1 files changed, 0 insertions, 169 deletions
diff --git a/sql-files/logs.sql b/sql-files/logs.sql deleted file mode 100644 index 8dc764ec5..000000000 --- a/sql-files/logs.sql +++ /dev/null @@ -1,169 +0,0 @@ -#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', - `item9` int(11) NOT NULL default '0', - `itemCard` 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 ; - -#Database: log -#Table: atcommandlog -CREATE TABLE `atcommandlog` ( - `atcommand_id` mediumint(9) unsigned NOT NULL auto_increment, - `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00', - `account_id` int(11) unsigned NOT NULL default '0', - `char_id` int(11) unsigned NOT NULL default '0', - `char_name` varchar(30) NOT NULL default '', - `map` varchar(20) NOT NULL default '', - `command` varchar(50) NOT NULL default '', - PRIMARY KEY (`atcommand_id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; - -#Database: log -#Table: npclog -CREATE TABLE `npclog` ( - `npc_id` mediumint(9) unsigned NOT NULL auto_increment, - `npc_date` datetime NOT NULL default '0000-00-00 00:00:00', - `account_id` int(11) unsigned NOT NULL default '0', - `char_id` int(11) unsigned NOT NULL default '0', - `char_name` varchar(30) NOT NULL default '', - `map` varchar(20) NOT NULL default '', - `mes` varchar(255) NOT NULL default '', - PRIMARY KEY (`npc_id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ;
\ No newline at end of file |