From cadd6115604d80158fc532eb23209975cebf334a Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Sat, 31 May 2014 02:30:43 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 61 ++++++++++++++++++++++++++---------------------- sql-files/item_db2.sql | 61 ++++++++++++++++++++++++++---------------------- sql-files/item_db_re.sql | 61 ++++++++++++++++++++++++++---------------------- 3 files changed, 99 insertions(+), 84 deletions(-) (limited to 'sql-files') 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; -- cgit v1.2.3-60-g2f50