From 20df2abc1aca00d6aa5dc78347133890f36b32f3 Mon Sep 17 00:00:00 2001 From: Saulc Date: Sat, 13 Jan 2018 20:50:42 +0100 Subject: Initial commit --- sql-files/logs.sql | 186 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 186 insertions(+) create mode 100644 sql-files/logs.sql (limited to 'sql-files/logs.sql') diff --git a/sql-files/logs.sql b/sql-files/logs.sql new file mode 100644 index 000000000..c75fc37d2 --- /dev/null +++ b/sql-files/logs.sql @@ -0,0 +1,186 @@ +-- This file is part of Hercules. +-- http://herc.ws - http://github.com/HerculesWS/Hercules +-- +-- Copyright (C) 2012-2015 Hercules Dev Team +-- Copyright (C) Athena Dev Teams +-- +-- Hercules is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program. If not, see . + +-- PickLog Types +-- (M)onsters Drop +-- (P)layers Drop/Take +-- Mobs Drop (L)oot Drop/Take +-- Players (T)rade Give/Take +-- Players (V)ending Sell/Take +-- (S)hop Sell/Take +-- (N)PC Give/Take +-- (C)onsumable Items +-- (A)dministrators Create/Delete +-- Sto(R)age +-- (G)uild Storage +-- (E)mail attachment +-- (B)uying Store +-- Pr(O)duced Items/Ingredients +-- Auct(I)oned Items +-- (X) Other +-- (D) Stolen from mobs +-- (U) MVP Prizes + +-- +-- Table structure for table `atcommandlog` +-- + +CREATE TABLE IF NOT EXISTS `atcommandlog` ( + `atcommand_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `atcommand_date` DATETIME NULL, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_name` VARCHAR(25) NOT NULL DEFAULT '', + `map` VARCHAR(11) NOT NULL DEFAULT '', + `command` VARCHAR(255) NOT NULL DEFAULT '', + PRIMARY KEY (`atcommand_id`), + INDEX (`account_id`), + INDEX (`char_id`) +) ENGINE=MyISAM AUTO_INCREMENT=1 ; + +-- +-- Table structure for table `branchlog` +-- + +CREATE TABLE IF NOT EXISTS `branchlog` ( + `branch_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `branch_date` DATETIME NULL, + `account_id` INT(11) NOT NULL DEFAULT '0', + `char_id` INT(11) NOT NULL DEFAULT '0', + `char_name` VARCHAR(25) NOT NULL DEFAULT '', + `map` VARCHAR(11) NOT NULL DEFAULT '', + PRIMARY KEY(`branch_id`), + INDEX (`account_id`), + INDEX (`char_id`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + +-- +-- Table structure for table `chatlog` +-- + +CREATE TABLE IF NOT EXISTS `chatlog` ( + `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `time` DATETIME NULL, + `type` ENUM('O','W','P','G','M') NOT NULL DEFAULT 'O', + `type_id` INT(11) NOT NULL DEFAULT '0', + `src_charid` INT(11) NOT NULL DEFAULT '0', + `src_accountid` INT(11) NOT NULL DEFAULT '0', + `src_map` VARCHAR(11) NOT NULL DEFAULT '', + `src_map_x` SMALLINT(4) NOT NULL DEFAULT '0', + `src_map_y` SMALLINT(4) NOT NULL DEFAULT '0', + `dst_charname` VARCHAR(25) NOT NULL DEFAULT '', + `message` VARCHAR(150) NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + INDEX (`src_accountid`), + INDEX (`src_charid`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + +-- +-- Table structure for table `loginlog` +-- + +CREATE TABLE IF NOT EXISTS `loginlog` ( + `time` DATETIME NULL, + `ip` VARCHAR(15) NOT NULL DEFAULT '', + `user` VARCHAR(23) NOT NULL DEFAULT '', + `rcode` TINYINT(4) NOT NULL DEFAULT '0', + `log` VARCHAR(255) NOT NULL DEFAULT '', + INDEX (`ip`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `mvplog` +-- + +CREATE TABLE IF NOT EXISTS `mvplog` ( + `mvp_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `mvp_date` DATETIME NULL, + `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(11) NOT NULL DEFAULT '', + PRIMARY KEY (`mvp_id`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + +-- +-- Table structure for table `npclog` +-- + +CREATE TABLE IF NOT EXISTS `npclog` ( + `npc_id` MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT, + `npc_date` DATETIME NULL, + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `char_name` VARCHAR(25) NOT NULL DEFAULT '', + `map` VARCHAR(11) NOT NULL DEFAULT '', + `mes` VARCHAR(255) NOT NULL DEFAULT '', + PRIMARY KEY (`npc_id`), + INDEX (`account_id`), + INDEX (`char_id`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + +-- +-- Table structure for table `picklog` +-- + +CREATE TABLE IF NOT EXISTS `picklog` ( + `id` INT(11) NOT NULL AUTO_INCREMENT, + `time` DATETIME NULL, + `char_id` INT(11) NOT NULL DEFAULT '0', + `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2') NOT NULL DEFAULT 'P', + `nameid` INT(11) NOT NULL DEFAULT '0', + `amount` INT(11) NOT NULL DEFAULT '1', + `refine` TINYINT(3) UNSIGNED 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', + `opt_idx0` smallint(5) unsigned NOT NULL default '0', + `opt_val0` smallint(5) unsigned NOT NULL default '0', + `opt_idx1` smallint(5) unsigned NOT NULL default '0', + `opt_val1` smallint(5) unsigned NOT NULL default '0', + `opt_idx2` smallint(5) unsigned NOT NULL default '0', + `opt_val2` smallint(5) unsigned NOT NULL default '0', + `opt_idx3` smallint(5) unsigned NOT NULL default '0', + `opt_val3` smallint(5) unsigned NOT NULL default '0', + `opt_idx4` smallint(5) unsigned NOT NULL default '0', + `opt_val4` smallint(5) unsigned NOT NULL default '0', + `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', + `map` VARCHAR(11) NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + INDEX (`type`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + +-- +-- Table structure for table `zenylog` +-- + +CREATE TABLE IF NOT EXISTS `zenylog` ( + `id` INT(11) NOT NULL AUTO_INCREMENT, + `time` DATETIME NULL, + `char_id` INT(11) NOT NULL DEFAULT '0', + `src_id` INT(11) NOT NULL DEFAULT '0', + `type` ENUM('T','V','P','M','S','N','D','C','A','E','I','B','K') NOT NULL DEFAULT 'S', + `amount` INT(11) NOT NULL DEFAULT '0', + `map` VARCHAR(11) NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + INDEX (`type`) +) ENGINE=MyISAM AUTO_INCREMENT=1; + -- cgit v1.2.3-60-g2f50