summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2014-05-31 02:30:43 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2014-05-31 02:30:43 +0200
commitcadd6115604d80158fc532eb23209975cebf334a (patch)
tree86bd3927e6dda92acb3433dfff10d66523982e58 /sql-files
parent6904486965bbf76b9ddc60986a8ad6060e45651f (diff)
downloadhercules-cadd6115604d80158fc532eb23209975cebf334a.tar.gz
hercules-cadd6115604d80158fc532eb23209975cebf334a.tar.bz2
hercules-cadd6115604d80158fc532eb23209975cebf334a.tar.xz
hercules-cadd6115604d80158fc532eb23209975cebf334a.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db.sql61
-rw-r--r--sql-files/item_db2.sql61
-rw-r--r--sql-files/item_db_re.sql61
3 files changed, 99 insertions, 84 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index 2a0dd7f63..90dccd306 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -1,34 +1,39 @@
-#
-# Table structure for table `item_db`
-#
+-- 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_db`
+--
DROP TABLE IF EXISTS `item_db`;
CREATE TABLE `item_db` (
- `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` int(12) 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,
- `script` text,
- `equip_script` text,
- `unequip_script` text,
+ `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` int(12) 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,
+ `script` text,
+ `equip_script` text,
+ `unequip_script` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql
index 88c1b329b..747f925f0 100644
--- a/sql-files/item_db2.sql
+++ b/sql-files/item_db2.sql
@@ -1,34 +1,39 @@
-#
-# Table structure for table `item_db2`
-#
+-- 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` int(12) 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,
- `script` text,
- `equip_script` text,
- `unequip_script` text,
+ `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` int(12) 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,
+ `script` text,
+ `equip_script` text,
+ `unequip_script` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 217968210..3ef982c0a 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -1,34 +1,39 @@
-#
-# Table structure for table `item_db_re`
-#
+-- 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_db_re`
+--
DROP TABLE IF EXISTS `item_db_re`;
CREATE TABLE `item_db_re` (
- `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` int(12) 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,
- `script` text,
- `equip_script` text,
- `unequip_script` text,
+ `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` int(12) 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,
+ `script` text,
+ `equip_script` text,
+ `unequip_script` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;