summaryrefslogtreecommitdiff
path: root/sql-files/item_db2.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/item_db2.sql')
-rw-r--r--sql-files/item_db2.sql9
1 files changed, 6 insertions, 3 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql
index 3819d0fdf..9d6c1386f 100644
--- a/sql-files/item_db2.sql
+++ b/sql-files/item_db2.sql
@@ -1,7 +1,7 @@
-- This file is part of Hercules.
-- http://herc.ws - http://github.com/HerculesWS/Hercules
--
--- Copyright (C) 2013-2016 Hercules Dev Team
+-- Copyright (C) 2013-2017 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
@@ -21,6 +21,8 @@
-- please consider modifying the corresponding .conf file inside
-- the db folder, and then re-run the db2sql plugin.
+-- GENERATED FILE DO NOT EDIT --
+
--
-- Table structure for table `item_db2`
--
@@ -39,14 +41,15 @@ CREATE TABLE `item_db2` (
`defence` smallint(5) UNSIGNED DEFAULT NULL,
`range` tinyint(2) UNSIGNED DEFAULT NULL,
`slots` tinyint(2) UNSIGNED DEFAULT NULL,
- `equip_jobs` int(12) 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,
+ `equip_locations` mediumint(8) 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,
+ `disable_options` tinyint(1) UNSIGNED DEFAULT NULL,
`view` smallint(3) UNSIGNED DEFAULT NULL,
`bindonequip` tinyint(1) UNSIGNED DEFAULT NULL,
`forceserial` tinyint(1) UNSIGNED DEFAULT NULL,