summaryrefslogtreecommitdiff
path: root/sql-files/item_db2.sql
diff options
context:
space:
mode:
authorAndrei Karas <akaras@inbox.ru>2014-10-05 11:34:32 +0300
committerAndrei Karas <akaras@inbox.ru>2016-03-14 19:17:18 +0300
commit301445891719c8021b5acb658674950e018ed327 (patch)
treeb219dc12e15a840cdb021fdb03ee229e0c2b7338 /sql-files/item_db2.sql
parent6a2f148a511255c4566c65b0aa1757fc26e018b7 (diff)
downloadhercules-301445891719c8021b5acb658674950e018ed327.tar.gz
hercules-301445891719c8021b5acb658674950e018ed327.tar.bz2
hercules-301445891719c8021b5acb658674950e018ed327.tar.xz
hercules-301445891719c8021b5acb658674950e018ed327.zip
Remove conf dir.
Diffstat (limited to 'sql-files/item_db2.sql')
-rw-r--r--sql-files/item_db2.sql67
1 files changed, 0 insertions, 67 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql
deleted file mode 100644
index de2c541e3..000000000
--- a/sql-files/item_db2.sql
+++ /dev/null
@@ -1,67 +0,0 @@
--- This file is part of Hercules.
--- http://herc.ws - http://github.com/HerculesWS/Hercules
---
--- Copyright (C) 2013-2016 Hercules Dev Team
---
--- 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 <http://www.gnu.org/licenses/>.
-
--- NOTE: This file was auto-generated and should never be manually edited,
--- as it will get overwritten. If you need to modify this file,
--- please consider modifying the corresponding .conf file inside
--- the db folder, and then re-run the db2sql plugin.
-
---
--- Table structure for table `item_db2`
---
-
-DROP TABLE IF EXISTS `item_db2`;
-CREATE TABLE `item_db2` (
- `id` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
- `name_english` varchar(50) NOT NULL DEFAULT '',
- `name_japanese` varchar(50) NOT NULL DEFAULT '',
- `type` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
- `price_buy` mediumint(10) DEFAULT NULL,
- `price_sell` mediumint(10) DEFAULT NULL,
- `weight` smallint(5) UNSIGNED DEFAULT NULL,
- `atk` smallint(5) UNSIGNED DEFAULT NULL,
- `matk` smallint(5) UNSIGNED DEFAULT NULL,
- `defence` smallint(5) UNSIGNED DEFAULT NULL,
- `range` tinyint(2) UNSIGNED DEFAULT NULL,
- `slots` tinyint(2) UNSIGNED DEFAULT NULL,
- `equip_jobs` bigint(20) UNSIGNED DEFAULT NULL,
- `equip_upper` tinyint(8) UNSIGNED DEFAULT NULL,
- `equip_genders` tinyint(2) UNSIGNED DEFAULT NULL,
- `equip_locations` smallint(4) UNSIGNED DEFAULT NULL,
- `weapon_level` tinyint(2) UNSIGNED DEFAULT NULL,
- `equip_level_min` smallint(5) UNSIGNED DEFAULT NULL,
- `equip_level_max` smallint(5) UNSIGNED DEFAULT NULL,
- `refineable` tinyint(1) UNSIGNED DEFAULT NULL,
- `view` smallint(3) UNSIGNED DEFAULT NULL,
- `bindonequip` tinyint(1) UNSIGNED DEFAULT NULL,
- `forceserial` tinyint(1) UNSIGNED DEFAULT NULL,
- `buyingstore` tinyint(1) UNSIGNED DEFAULT NULL,
- `delay` mediumint(9) UNSIGNED DEFAULT NULL,
- `trade_flag` smallint(4) UNSIGNED DEFAULT NULL,
- `trade_group` smallint(3) UNSIGNED DEFAULT NULL,
- `nouse_flag` smallint(4) UNSIGNED DEFAULT NULL,
- `nouse_group` smallint(4) UNSIGNED DEFAULT NULL,
- `stack_amount` mediumint(6) UNSIGNED DEFAULT NULL,
- `stack_flag` tinyint(2) UNSIGNED DEFAULT NULL,
- `sprite` mediumint(6) UNSIGNED DEFAULT NULL,
- `script` text,
- `equip_script` text,
- `unequip_script` text,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM;
-