SWDB/data.sql

CREATE TABLE IF NOT EXISTS k_difficulty(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_source(id INT, name TEXT, description TEXT, farmable_source INT);

CREATE TABLE IF NOT EXISTS k_element(id INT, name TEXT, strong_against INT, weak_against INT);

CREATE TABLE IF NOT EXISTS k_secret_dungeon(unit TEXT);

CREATE TABLE IF NOT EXISTS k_archetype(id INT, name TEXT, description TEXT);

CREATE TABLE IF NOT EXISTS k_stat(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_effect_area(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_decoration(id INT, area TEXT, affected_stat TEXT, element TEXT, name TEXT, description TEXT, max_level INT);

CREATE TABLE IF NOT EXISTS k_building(id INT, name TEXT, description TEXT);

CREATE TABLE IF NOT EXISTS k_inventory_type(id INT, name TEXT, description TEXT);

CREATE TABLE IF NOT EXISTS k_inventory(id INT, name TEXT, description TEXT);

CREATE TABLE IF NOT EXISTS k_enhance(id INT, name TEXT, description TEXT);

CREATE TABLE IF NOT EXISTS k_rune_set(id INT, name TEXT, amount INT, description TEXT);

CREATE TABLE IF NOT EXISTS k_rune_stat(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_quality(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_craft(id INT, name TEXT);

CREATE TABLE IF NOT EXISTS k_experience(stars INT, level INT, exp INT);


INSERT INTO k_difficulty VALUES (0, 'Easy');
INSERT INTO k_difficulty VALUES (1, 'Normal');
INSERT INTO k_difficulty VALUES (2, 'Hard');
INSERT INTO k_difficulty VALUES (3, 'Hell');

INSERT INTO k_source VALUES (1, 'Unknow Scroll', '', 1);
INSERT INTO k_source VALUES (2, 'Mystical Scroll', '', 1);
INSERT INTO k_source VALUES (3, 'Light & Dark Scroll', '', 1);
INSERT INTO k_source VALUES (4, 'Water Scroll', '', 1);
INSERT INTO k_source VALUES (5, 'Fire Scroll', '', 1);
INSERT INTO k_source VALUES (6, 'Wind Scroll', '', 1);
INSERT INTO k_source VALUES (7, 'Legendary Scroll', '', 1);
INSERT INTO k_source VALUES (8, 'Summon Stones', '', 1);
INSERT INTO k_source VALUES (9, 'Summon Pieces', '', 1);
INSERT INTO k_source VALUES (10, 'Light & Dark Pieces', '', 1);
INSERT INTO k_source VALUES (11, 'Transcendence Scroll', '', 1);
INSERT INTO k_source VALUES (12, 'Legendary Water Scroll', '', 1);
INSERT INTO k_source VALUES (13, 'Legendary Fire Scroll', '', 1);
INSERT INTO k_source VALUES (14, 'Legendary Wind Scroll', '', 1);

INSERT INTO k_secret_dungeon VALUES ('10103');
INSERT INTO k_secret_dungeon VALUES ('10105');
INSERT INTO k_secret_dungeon VALUES ('10201');
INSERT INTO k_secret_dungeon VALUES ('10202');
INSERT INTO k_secret_dungeon VALUES ('10203');
INSERT INTO k_secret_dungeon VALUES ('10204');
INSERT INTO k_secret_dungeon VALUES ('10205');
INSERT INTO k_secret_dungeon VALUES ('10301');
INSERT INTO k_secret_dungeon VALUES ('10302');
INSERT INTO k_secret_dungeon VALUES ('10303');
INSERT INTO k_secret_dungeon VALUES ('10304');
INSERT INTO k_secret_dungeon VALUES ('10305');
INSERT INTO k_secret_dungeon VALUES ('10401');
INSERT INTO k_secret_dungeon VALUES ('10402');
INSERT INTO k_secret_dungeon VALUES ('10403');
INSERT INTO k_secret_dungeon VALUES ('10404');
INSERT INTO k_secret_dungeon VALUES ('10601');
INSERT INTO k_secret_dungeon VALUES ('10602');
INSERT INTO k_secret_dungeon VALUES ('10603');
INSERT INTO k_secret_dungeon VALUES ('10604');
INSERT INTO k_secret_dungeon VALUES ('10702');
INSERT INTO k_secret_dungeon VALUES ('10703');
INSERT INTO k_secret_dungeon VALUES ('10705');
INSERT INTO k_secret_dungeon VALUES ('10801');
INSERT INTO k_secret_dungeon VALUES ('10802');
INSERT INTO k_secret_dungeon VALUES ('10803');
INSERT INTO k_secret_dungeon VALUES ('10901');
INSERT INTO k_secret_dungeon VALUES ('10902');
INSERT INTO k_secret_dungeon VALUES ('10903');
INSERT INTO k_secret_dungeon VALUES ('10905');
INSERT INTO k_secret_dungeon VALUES ('11101');
INSERT INTO k_secret_dungeon VALUES ('11103');
INSERT INTO k_secret_dungeon VALUES ('11104');
INSERT INTO k_secret_dungeon VALUES ('11105');
INSERT INTO k_secret_dungeon VALUES ('12101');
INSERT INTO k_secret_dungeon VALUES ('12102');
INSERT INTO k_secret_dungeon VALUES ('12103');
INSERT INTO k_secret_dungeon VALUES ('13201');
INSERT INTO k_secret_dungeon VALUES ('13202');
INSERT INTO k_secret_dungeon VALUES ('13203');
INSERT INTO k_secret_dungeon VALUES ('13204');
INSERT INTO k_secret_dungeon VALUES ('13205');
INSERT INTO k_secret_dungeon VALUES ('14801');
INSERT INTO k_secret_dungeon VALUES ('14802');
INSERT INTO k_secret_dungeon VALUES ('14803');
INSERT INTO k_secret_dungeon VALUES ('14804');
INSERT INTO k_secret_dungeon VALUES ('15201');
INSERT INTO k_secret_dungeon VALUES ('15203');
INSERT INTO k_secret_dungeon VALUES ('13604');
INSERT INTO k_secret_dungeon VALUES ('13605');
INSERT INTO k_secret_dungeon VALUES ('12605');
INSERT INTO k_secret_dungeon VALUES ('12814');
INSERT INTO k_secret_dungeon VALUES ('10101');
INSERT INTO k_secret_dungeon VALUES ('10102');
INSERT INTO k_secret_dungeon VALUES ('10104');
INSERT INTO k_secret_dungeon VALUES ('10405');
INSERT INTO k_secret_dungeon VALUES ('10501');
INSERT INTO k_secret_dungeon VALUES ('10502');
INSERT INTO k_secret_dungeon VALUES ('10503');
INSERT INTO k_secret_dungeon VALUES ('10504');
INSERT INTO k_secret_dungeon VALUES ('10505');
INSERT INTO k_secret_dungeon VALUES ('10605');
INSERT INTO k_secret_dungeon VALUES ('10701');
INSERT INTO k_secret_dungeon VALUES ('10704');
INSERT INTO k_secret_dungeon VALUES ('10804');
INSERT INTO k_secret_dungeon VALUES ('10805');
INSERT INTO k_secret_dungeon VALUES ('10904');
INSERT INTO k_secret_dungeon VALUES ('11001');
INSERT INTO k_secret_dungeon VALUES ('11002');
INSERT INTO k_secret_dungeon VALUES ('11003');
INSERT INTO k_secret_dungeon VALUES ('11004');
INSERT INTO k_secret_dungeon VALUES ('11005');
INSERT INTO k_secret_dungeon VALUES ('11102');
INSERT INTO k_secret_dungeon VALUES ('11301');
INSERT INTO k_secret_dungeon VALUES ('11302');
INSERT INTO k_secret_dungeon VALUES ('11303');
INSERT INTO k_secret_dungeon VALUES ('11304');
INSERT INTO k_secret_dungeon VALUES ('11305');
INSERT INTO k_secret_dungeon VALUES ('11401');
INSERT INTO k_secret_dungeon VALUES ('11402');
INSERT INTO k_secret_dungeon VALUES ('11403');
INSERT INTO k_secret_dungeon VALUES ('11404');
INSERT INTO k_secret_dungeon VALUES ('11405');
INSERT INTO k_secret_dungeon VALUES ('11501');
INSERT INTO k_secret_dungeon VALUES ('11502');
INSERT INTO k_secret_dungeon VALUES ('11503');
INSERT INTO k_secret_dungeon VALUES ('11504');
INSERT INTO k_secret_dungeon VALUES ('11505');
INSERT INTO k_secret_dungeon VALUES ('11701');
INSERT INTO k_secret_dungeon VALUES ('11702');
INSERT INTO k_secret_dungeon VALUES ('11703');
INSERT INTO k_secret_dungeon VALUES ('11704');
INSERT INTO k_secret_dungeon VALUES ('11705');
INSERT INTO k_secret_dungeon VALUES ('12001');
INSERT INTO k_secret_dungeon VALUES ('12002');
INSERT INTO k_secret_dungeon VALUES ('12003');
INSERT INTO k_secret_dungeon VALUES ('12004');
INSERT INTO k_secret_dungeon VALUES ('12005');
INSERT INTO k_secret_dungeon VALUES ('12104');
INSERT INTO k_secret_dungeon VALUES ('12105');
INSERT INTO k_secret_dungeon VALUES ('13701');
INSERT INTO k_secret_dungeon VALUES ('13702');
INSERT INTO k_secret_dungeon VALUES ('13703');
INSERT INTO k_secret_dungeon VALUES ('13704');
INSERT INTO k_secret_dungeon VALUES ('13705');
INSERT INTO k_secret_dungeon VALUES ('14001');
INSERT INTO k_secret_dungeon VALUES ('14002');
INSERT INTO k_secret_dungeon VALUES ('14003');
INSERT INTO k_secret_dungeon VALUES ('14004');
INSERT INTO k_secret_dungeon VALUES ('14005');
INSERT INTO k_secret_dungeon VALUES ('14805');
INSERT INTO k_secret_dungeon VALUES ('15001');
INSERT INTO k_secret_dungeon VALUES ('15002');
INSERT INTO k_secret_dungeon VALUES ('15003');
INSERT INTO k_secret_dungeon VALUES ('15004');
INSERT INTO k_secret_dungeon VALUES ('15005');
INSERT INTO k_secret_dungeon VALUES ('15202');
INSERT INTO k_secret_dungeon VALUES ('15204');
INSERT INTO k_secret_dungeon VALUES ('15205');
INSERT INTO k_secret_dungeon VALUES ('15301');
INSERT INTO k_secret_dungeon VALUES ('15303');
INSERT INTO k_secret_dungeon VALUES ('15305');
INSERT INTO k_secret_dungeon VALUES ('15401');
INSERT INTO k_secret_dungeon VALUES ('15402');
INSERT INTO k_secret_dungeon VALUES ('15403');
INSERT INTO k_secret_dungeon VALUES ('16001');
INSERT INTO k_secret_dungeon VALUES ('16002');
INSERT INTO k_secret_dungeon VALUES ('16003');
INSERT INTO k_secret_dungeon VALUES ('16004');
INSERT INTO k_secret_dungeon VALUES ('16005');
INSERT INTO k_secret_dungeon VALUES ('14901');
INSERT INTO k_secret_dungeon VALUES ('14902');
INSERT INTO k_secret_dungeon VALUES ('14903');
INSERT INTO k_secret_dungeon VALUES ('14904');
INSERT INTO k_secret_dungeon VALUES ('14905');
INSERT INTO k_secret_dungeon VALUES ('15601');
INSERT INTO k_secret_dungeon VALUES ('15602');
INSERT INTO k_secret_dungeon VALUES ('15603');
INSERT INTO k_secret_dungeon VALUES ('15604');
INSERT INTO k_secret_dungeon VALUES ('15605');
INSERT INTO k_secret_dungeon VALUES ('16501');
INSERT INTO k_secret_dungeon VALUES ('16502');
INSERT INTO k_secret_dungeon VALUES ('16503');
INSERT INTO k_secret_dungeon VALUES ('16504');
INSERT INTO k_secret_dungeon VALUES ('16505');
INSERT INTO k_secret_dungeon VALUES ('15901');
INSERT INTO k_secret_dungeon VALUES ('15902');
INSERT INTO k_secret_dungeon VALUES ('15903');
INSERT INTO k_secret_dungeon VALUES ('15904');
INSERT INTO k_secret_dungeon VALUES ('15905');
INSERT INTO k_secret_dungeon VALUES ('17201');
INSERT INTO k_secret_dungeon VALUES ('17202');
INSERT INTO k_secret_dungeon VALUES ('17203');
INSERT INTO k_secret_dungeon VALUES ('17204');
INSERT INTO k_secret_dungeon VALUES ('17205');
INSERT INTO k_secret_dungeon VALUES ('17701');
INSERT INTO k_secret_dungeon VALUES ('17702');
INSERT INTO k_secret_dungeon VALUES ('17703');
INSERT INTO k_secret_dungeon VALUES ('17704');
INSERT INTO k_secret_dungeon VALUES ('17705');
INSERT INTO k_secret_dungeon VALUES ('17801');
INSERT INTO k_secret_dungeon VALUES ('17802');
INSERT INTO k_secret_dungeon VALUES ('17803');
INSERT INTO k_secret_dungeon VALUES ('17804');
INSERT INTO k_secret_dungeon VALUES ('17805');
INSERT INTO k_secret_dungeon VALUES ('12705');
INSERT INTO k_secret_dungeon VALUES ('12905');
INSERT INTO k_secret_dungeon VALUES ('13005');
INSERT INTO k_secret_dungeon VALUES ('13105');
INSERT INTO k_secret_dungeon VALUES ('12805');
INSERT INTO k_secret_dungeon VALUES ('15801');
INSERT INTO k_secret_dungeon VALUES ('15802');
INSERT INTO k_secret_dungeon VALUES ('15803');
INSERT INTO k_secret_dungeon VALUES ('15804');
INSERT INTO k_secret_dungeon VALUES ('15805');
INSERT INTO k_secret_dungeon VALUES ('18501');
INSERT INTO k_secret_dungeon VALUES ('18502');
INSERT INTO k_secret_dungeon VALUES ('18503');
INSERT INTO k_secret_dungeon VALUES ('18504');
INSERT INTO k_secret_dungeon VALUES ('18505');
INSERT INTO k_secret_dungeon VALUES ('18402');
INSERT INTO k_secret_dungeon VALUES ('18405');
INSERT INTO k_secret_dungeon VALUES ('18701');
INSERT INTO k_secret_dungeon VALUES ('18702');
INSERT INTO k_secret_dungeon VALUES ('18703');
INSERT INTO k_secret_dungeon VALUES ('18704');
INSERT INTO k_secret_dungeon VALUES ('18705');
INSERT INTO k_secret_dungeon VALUES ('19001');
INSERT INTO k_secret_dungeon VALUES ('19002');
INSERT INTO k_secret_dungeon VALUES ('19003');
INSERT INTO k_secret_dungeon VALUES ('19004');
INSERT INTO k_secret_dungeon VALUES ('19005');
INSERT INTO k_secret_dungeon VALUES ('19501');
INSERT INTO k_secret_dungeon VALUES ('19502');
INSERT INTO k_secret_dungeon VALUES ('19503');
INSERT INTO k_secret_dungeon VALUES ('19504');
INSERT INTO k_secret_dungeon VALUES ('19505');
INSERT INTO k_secret_dungeon VALUES ('20201');
INSERT INTO k_secret_dungeon VALUES ('20202');
INSERT INTO k_secret_dungeon VALUES ('20203');
INSERT INTO k_secret_dungeon VALUES ('20204');
INSERT INTO k_secret_dungeon VALUES ('20205');
INSERT INTO k_secret_dungeon VALUES ('20701');
INSERT INTO k_secret_dungeon VALUES ('20702');
INSERT INTO k_secret_dungeon VALUES ('20703');
INSERT INTO k_secret_dungeon VALUES ('20704');
INSERT INTO k_secret_dungeon VALUES ('20705');
INSERT INTO k_secret_dungeon VALUES ('20801');
INSERT INTO k_secret_dungeon VALUES ('20802');
INSERT INTO k_secret_dungeon VALUES ('20803');
INSERT INTO k_secret_dungeon VALUES ('20804');
INSERT INTO k_secret_dungeon VALUES ('20805');
INSERT INTO k_secret_dungeon VALUES ('20301');
INSERT INTO k_secret_dungeon VALUES ('20302');
INSERT INTO k_secret_dungeon VALUES ('20303');
INSERT INTO k_secret_dungeon VALUES ('20304');
INSERT INTO k_secret_dungeon VALUES ('20305');

INSERT INTO k_element VALUES (1, 'Water', 2, 3);
INSERT INTO k_element VALUES (2, 'Fire', 3, 1);
INSERT INTO k_element VALUES (3, 'Wind', 1, 2);
INSERT INTO k_element VALUES (4, 'Light', 5, 5);
INSERT INTO k_element VALUES (5, 'Dark', 4, 4);
INSERT INTO k_element VALUES (6, 'Pure', null, null);

INSERT INTO k_archetype VALUES (0, 'None', '');
INSERT INTO k_archetype VALUES (1, 'Attack', '');
INSERT INTO k_archetype VALUES (2, 'Defense', '');
INSERT INTO k_archetype VALUES (3, 'HP', '');
INSERT INTO k_archetype VALUES (4, 'Support', '');
INSERT INTO k_archetype VALUES (5, 'Material', '');

INSERT INTO k_stat VALUES (1, 'HP');
INSERT INTO k_stat VALUES (2, 'ATK');
INSERT INTO k_stat VALUES (3, 'DEF');
INSERT INTO k_stat VALUES (4, 'SPD');
INSERT INTO k_stat VALUES (5, 'CRIT_RATE');
INSERT INTO k_stat VALUES (6, 'CRIT_DMG');
INSERT INTO k_stat VALUES (7, 'RES');
INSERT INTO k_stat VALUES (8, 'ACC');

INSERT INTO k_effect_area VALUES (1, 'General');
INSERT INTO k_effect_area VALUES (1, 'Arena');
INSERT INTO k_effect_area VALUES (2, 'Dungeon');
INSERT INTO k_effect_area VALUES (5, 'Guild');

INSERT INTO k_decoration VALUES (4, 1, 3, null, 'Guardstone', '', 10);
INSERT INTO k_decoration VALUES (15, 1, 2, 2, 'Fire Sanctuary', '', 10);
INSERT INTO k_decoration VALUES (16, 1, 2, 1, 'Water Sanctuary', '', 10);
INSERT INTO k_decoration VALUES (17, 1, 2, 3, 'Wind Sanctuary', '', 10);
INSERT INTO k_decoration VALUES (18, 1, 2, 4, 'Light Sanctuary', '', 10);
INSERT INTO k_decoration VALUES (19, 1, 2, 5, 'Dark Sanctuary', '', 10);
INSERT INTO k_decoration VALUES (31, 1, 6, null, 'Fallen Ancient Guardian', '', 10);
INSERT INTO k_decoration VALUES (6, 1, 4, null, 'Sky Tribe Totem', '', 10);
INSERT INTO k_decoration VALUES (8, 1, 1, null, 'Crystal Altar', '', 10);
INSERT INTO k_decoration VALUES (36, 5, 2, null, 'Flag of Battle', '', 10);
INSERT INTO k_decoration VALUES (37, 5, 6, null, 'Flag of Rage', '', 10);
INSERT INTO k_decoration VALUES (38, 5, 1, null, 'Flag of Hope', '', 10);
INSERT INTO k_decoration VALUES (39, 5, 3, null, 'Flag of Will', '', 10);
INSERT INTO k_decoration VALUES (9, 1, 2, null, 'Ancient Sword', '', 10);
INSERT INTO k_decoration VALUES (7, 1, null, null, 'Arcane Booster Tower', '', 10);
INSERT INTO k_decoration VALUES (34, 1, null, null, 'Crystal Rock', '', 10);
INSERT INTO k_decoration VALUES (11, 1, null, null, 'Mysterious Plant', '', 10);
INSERT INTO k_decoration VALUES (5, 1, null, null, 'Mana Fountain', '', 10);
INSERT INTO k_decoration VALUES (10, 1, null, null, 'Sanctum of Energy', '', 10);
INSERT INTO k_decoration VALUES (35, 1, null, null, 'Fairy Tree', '', 10);

INSERT INTO k_building VALUES(1, 'Summoners Tower', '');
INSERT INTO k_building VALUES(2, 'Summonhenge', '');
INSERT INTO k_building VALUES(3, 'Pond of Mana', '');
INSERT INTO k_building VALUES(4, 'Crystal Mine', '');
INSERT INTO k_building VALUES(8, 'Gateway', '');
INSERT INTO k_building VALUES(10, 'Temple of Wishes', '');
INSERT INTO k_building VALUES(11, 'Magic Shop', '');
INSERT INTO k_building VALUES(12, 'Ancient Stones', '');
INSERT INTO k_building VALUES(14, 'Arcane Tower', '');
INSERT INTO k_building VALUES(15, 'Crystal Titan', '');
INSERT INTO k_building VALUES(16, 'Fusion Hexagram', '');
INSERT INTO k_building VALUES(17, 'Fuse Center', '');
INSERT INTO k_building VALUES(20, 'Power Up Circle', '');
INSERT INTO k_building VALUES(22, 'Tranquil Forest', '');
INSERT INTO k_building VALUES(23, 'Gusty Cliffs', '');
INSERT INTO k_building VALUES(24, 'Deep Forest Ent', '');
INSERT INTO k_building VALUES(25, 'Monster Storage', '');
INSERT INTO k_building VALUES(27, 'Transmogrification Building', '');

INSERT INTO k_inventory_type VALUES(1, 'Monster', '');
INSERT INTO k_inventory_type VALUES(6, 'Currency', '');
INSERT INTO k_inventory_type VALUES(8, 'Rune', '');
INSERT INTO k_inventory_type VALUES(9, 'Scroll', '');
INSERT INTO k_inventory_type VALUES(10, 'Booster', '');
INSERT INTO k_inventory_type VALUES(11, 'Essences', '');
INSERT INTO k_inventory_type VALUES(12, 'Monster Piece', '');
INSERT INTO k_inventory_type VALUES(15, 'UNKNOWN', 'Appears in inventory_info with qty 0');
INSERT INTO k_inventory_type VALUES(19, 'Guild Monster Piece', '');
INSERT INTO k_inventory_type VALUES(19, 'Rainbowmon', ''); -- Possibly material monsters in general. Appears when wish returns a rainbowmon.
INSERT INTO k_inventory_type VALUES(27, 'Rune Craft', '');
INSERT INTO k_inventory_type VALUES(29, 'Craft Stuff', '');
INSERT INTO k_inventory_type VALUES(61, 'Enhancing Monster', '');

INSERT INTO k_inventory VALUES(11006, 'Essence of Magic (low)', '');
INSERT INTO k_inventory VALUES(12006, 'Essence of Magic (mid)', '');
INSERT INTO k_inventory VALUES(13006, 'Essence of Magic (high)', '');
INSERT INTO k_inventory VALUES(11001, 'Essence of Water (low)', '');
INSERT INTO k_inventory VALUES(12001, 'Essence of Water (mid)', '');
INSERT INTO k_inventory VALUES(13001, 'Essence of Water (high)', '');
INSERT INTO k_inventory VALUES(11002, 'Essence of Fire (low)', '');
INSERT INTO k_inventory VALUES(12002, 'Essence of Fire (mid)', '');
INSERT INTO k_inventory VALUES(13002, 'Essence of Fire (high)', '');
INSERT INTO k_inventory VALUES(11003, 'Essence of Wind (low)', '');
INSERT INTO k_inventory VALUES(12003, 'Essence of Wind (mid)', '');
INSERT INTO k_inventory VALUES(13003, 'Essence of Wind (high)', '');
INSERT INTO k_inventory VALUES(11004, 'Essence of Light (low)', '');
INSERT INTO k_inventory VALUES(12004, 'Essence of Light (mid)', '');
INSERT INTO k_inventory VALUES(13004, 'Essence of Light (high)', '');
INSERT INTO k_inventory VALUES(11005, 'Essence of Dark (low)', '');
INSERT INTO k_inventory VALUES(12005, 'Essence of Dark (mid)', '');
INSERT INTO k_inventory VALUES(13005, 'Essence of Dark (high)', '');
INSERT INTO k_inventory VALUES(1001, 'Wood', '');
INSERT INTO k_inventory VALUES(1002, 'Leather', '');
INSERT INTO k_inventory VALUES(1003, 'Rock', '');
INSERT INTO k_inventory VALUES(1004, 'Ore', '');
INSERT INTO k_inventory VALUES(1005, 'Mithril', '');
INSERT INTO k_inventory VALUES(1006, 'Cloth', '');
INSERT INTO k_inventory VALUES(2001, 'Rune Piece', '');
INSERT INTO k_inventory VALUES(3001, 'Powder', '');
INSERT INTO k_inventory VALUES(4001, 'Symbol of Harmony', '');
INSERT INTO k_inventory VALUES(4002, 'Symbol of Transcendance', '');
INSERT INTO k_inventory VALUES(4003, 'Symbol of Chaos', '');
INSERT INTO k_inventory VALUES(5001, 'Crystal of Water', '');
INSERT INTO k_inventory VALUES(5002, 'Crystal of Fire', '');
INSERT INTO k_inventory VALUES(5003, 'Crystal of Wind', '');
INSERT INTO k_inventory VALUES(5004, 'Crystal of Light', '');
INSERT INTO k_inventory VALUES(5005, 'Crystal of Dark', '');
INSERT INTO k_inventory VALUES(6001, 'Crystal of Magic', '');
INSERT INTO k_inventory VALUES(7001, 'Crystal of Pure', '');

--    $ENHANCE_MONSTER = [
--        "WATER_ANGELMON" => 142110115,
--        "FIRE_ANGELMON" => 142120115,
--        "WIND_ANGELMON" => 142130115,
--        "LIGHT_ANGELMON" => 142140115,
--        "DARK_ANGELMON" => 142150115,
--        "WATER_KING_ANGELMON" => 182110115,
--        "FIRE_KING_ANGELMON" => 182120115,
--        "WIND_KING_ANGELMON" => 182130115,
--        "LIGHT_KING_ANGELMON" => 182140115,
--        "DARK_KING_ANGELMON" => 182150115,
--        "RAINBOWMON_2_20" => 143140220,
--        "RAINBOWMON_3_1" => 143140301,
--        "RAINBOWMON_3_25" => 143140325,
--        "RAINBOWMON_4_1" => 143140401,
--        "RAINBOWMON_4_30" => 143140430,
--        "RAINBOWMON_5_1" => 143140501,
--        "DEVILMON" => 151050101,
--        'SUPER_ANGELMON' => 217140115
--    ];

INSERT INTO k_rune_set VALUES(1, 'Energy', 2, '');
INSERT INTO k_rune_set VALUES(2, 'Guard', 2, '');
INSERT INTO k_rune_set VALUES(3, 'Swift', 2, '');
INSERT INTO k_rune_set VALUES(4, 'Blade', 2, '');
INSERT INTO k_rune_set VALUES(5, 'Rage', 2, '');
INSERT INTO k_rune_set VALUES(6, 'Focus', 2, '');
INSERT INTO k_rune_set VALUES(7, 'Endure', 2, '');
INSERT INTO k_rune_set VALUES(8, 'Fatal', 2, '');
INSERT INTO k_rune_set VALUES(10, 'Despair', 2, '');
INSERT INTO k_rune_set VALUES(11, 'Vampire', 2, '');
INSERT INTO k_rune_set VALUES(13, 'Violent', 2, '');
INSERT INTO k_rune_set VALUES(14, 'Nemesis', 2, '');
INSERT INTO k_rune_set VALUES(15, 'Will', 2, '');
INSERT INTO k_rune_set VALUES(16, 'Shield', 2, '');
INSERT INTO k_rune_set VALUES(17, 'Revenge', 2, '');
INSERT INTO k_rune_set VALUES(18, 'Destroy', 2, '');
INSERT INTO k_rune_set VALUES(19, 'Fight', 2, '');
INSERT INTO k_rune_set VALUES(20, 'Determination', 2, '');
INSERT INTO k_rune_set VALUES(21, 'Enhance', 2, '');
INSERT INTO k_rune_set VALUES(22, 'Accuracy', 2, '');
INSERT INTO k_rune_set VALUES(23, 'Tolerance', 2, '');

INSERT INTO k_rune_stat VALUES(1, 'HP');
INSERT INTO k_rune_stat VALUES(2, 'HP%');
INSERT INTO k_rune_stat VALUES(3, 'ATK');
INSERT INTO k_rune_stat VALUES(4, 'ATK%');
INSERT INTO k_rune_stat VALUES(5, 'DEF');
INSERT INTO k_rune_stat VALUES(6, 'DEF%');
INSERT INTO k_rune_stat VALUES(8, 'SPD');
INSERT INTO k_rune_stat VALUES(9, 'CRIT_RATE');
INSERT INTO k_rune_stat VALUES(10, 'CRIT_DMG');
INSERT INTO k_rune_stat VALUES(11, 'RES');
INSERT INTO k_rune_stat VALUES(12, 'ACC');

INSERT INTO k_quality VALUES(1, 'Normal');
INSERT INTO k_quality VALUES(2, 'Magic');
INSERT INTO k_quality VALUES(3, 'Rare');
INSERT INTO k_quality VALUES(4, 'Hero');
INSERT INTO k_quality VALUES(5, 'Legend');

INSERT INTO k_craft VALUES(1, 'Enchant_gem');
INSERT INTO k_craft VALUES(2, 'Grindstone');
INSERT INTO k_craft VALUES(3, 'Immemorial_gem');
INSERT INTO k_craft VALUES(4, 'Immemorial_grindstone');

INSERT INTO k_experience VALUES (1, 1, 460);
INSERT INTO k_experience VALUES (2, 1, 552);
INSERT INTO k_experience VALUES (3, 1, 662);
INSERT INTO k_experience VALUES (4, 1, 796);
INSERT INTO k_experience VALUES (5, 1, 952);
INSERT INTO k_experience VALUES (6, 1, 1150);
INSERT INTO k_experience VALUES (1, 2, 516);
INSERT INTO k_experience VALUES (2, 2, 619);
INSERT INTO k_experience VALUES (3, 2, 743);
INSERT INTO k_experience VALUES (4, 2, 892);
INSERT INTO k_experience VALUES (5, 2, 1068);
INSERT INTO k_experience VALUES (6, 2, 1290);
INSERT INTO k_experience VALUES (1, 3, 579);
INSERT INTO k_experience VALUES (2, 3, 695);
INSERT INTO k_experience VALUES (3, 3, 834);
INSERT INTO k_experience VALUES (4, 3, 1002);
INSERT INTO k_experience VALUES (5, 3, 1199);
INSERT INTO k_experience VALUES (6, 3, 1447);
INSERT INTO k_experience VALUES (1, 4, 650);
INSERT INTO k_experience VALUES (2, 4, 779);
INSERT INTO k_experience VALUES (3, 4, 936);
INSERT INTO k_experience VALUES (4, 4, 1124);
INSERT INTO k_experience VALUES (5, 4, 1344);
INSERT INTO k_experience VALUES (6, 4, 1624);
INSERT INTO k_experience VALUES (1, 5, 728);
INSERT INTO k_experience VALUES (2, 5, 875);
INSERT INTO k_experience VALUES (3, 5, 1049);
INSERT INTO k_experience VALUES (4, 5, 1261);
INSERT INTO k_experience VALUES (5, 5, 1509);
INSERT INTO k_experience VALUES (6, 5, 1823);
INSERT INTO k_experience VALUES (1, 6, 818);
INSERT INTO k_experience VALUES (2, 6, 981);
INSERT INTO k_experience VALUES (3, 6, 1178);
INSERT INTO k_experience VALUES (4, 6, 1415);
INSERT INTO k_experience VALUES (5, 6, 1693);
INSERT INTO k_experience VALUES (6, 6, 2044);
INSERT INTO k_experience VALUES (1, 7, 918);
INSERT INTO k_experience VALUES (2, 7, 1102);
INSERT INTO k_experience VALUES (3, 7, 1321);
INSERT INTO k_experience VALUES (4, 7, 1587);
INSERT INTO k_experience VALUES (5, 7, 1899);
INSERT INTO k_experience VALUES (6, 7, 2294);
INSERT INTO k_experience VALUES (1, 8, 1029);
INSERT INTO k_experience VALUES (2, 8, 1235);
INSERT INTO k_experience VALUES (3, 8, 1483);
INSERT INTO k_experience VALUES (4, 8, 1781);
INSERT INTO k_experience VALUES (5, 8, 2131);
INSERT INTO k_experience VALUES (6, 8, 2574);
INSERT INTO k_experience VALUES (1, 9, 1155);
INSERT INTO k_experience VALUES (2, 9, 1386);
INSERT INTO k_experience VALUES (3, 9, 1663);
INSERT INTO k_experience VALUES (4, 9, 1998);
INSERT INTO k_experience VALUES (5, 9, 2392);
INSERT INTO k_experience VALUES (6, 9, 2888);
INSERT INTO k_experience VALUES (1, 10, 1296);
INSERT INTO k_experience VALUES (2, 10, 1555);
INSERT INTO k_experience VALUES (3, 10, 1866);
INSERT INTO k_experience VALUES (4, 10, 2243);
INSERT INTO k_experience VALUES (5, 10, 2682);
INSERT INTO k_experience VALUES (6, 10, 3240);
INSERT INTO k_experience VALUES (1, 11, 1455);
INSERT INTO k_experience VALUES (2, 11, 1745);
INSERT INTO k_experience VALUES (3, 11, 2094);
INSERT INTO k_experience VALUES (4, 11, 2515);
INSERT INTO k_experience VALUES (5, 11, 3010);
INSERT INTO k_experience VALUES (6, 11, 3635);
INSERT INTO k_experience VALUES (1, 12, 1631);
INSERT INTO k_experience VALUES (2, 12, 1958);
INSERT INTO k_experience VALUES (3, 12, 2350);
INSERT INTO k_experience VALUES (4, 12, 2823);
INSERT INTO k_experience VALUES (5, 12, 3378);
INSERT INTO k_experience VALUES (6, 12, 4079);
INSERT INTO k_experience VALUES (1, 13, 1831);
INSERT INTO k_experience VALUES (2, 13, 2197);
INSERT INTO k_experience VALUES (3, 13, 2636);
INSERT INTO k_experience VALUES (4, 13, 3167);
INSERT INTO k_experience VALUES (5, 13, 3789);
INSERT INTO k_experience VALUES (6, 13, 4576);
INSERT INTO k_experience VALUES (1, 14, 2054);
INSERT INTO k_experience VALUES (2, 14, 2465);
INSERT INTO k_experience VALUES (3, 14, 2957);
INSERT INTO k_experience VALUES (4, 14, 3553);
INSERT INTO k_experience VALUES (5, 14, 4252);
INSERT INTO k_experience VALUES (6, 14, 5135);
INSERT INTO k_experience VALUES (1, 15, 0);
INSERT INTO k_experience VALUES (2, 15, 2765);
INSERT INTO k_experience VALUES (3, 15, 3319);
INSERT INTO k_experience VALUES (4, 15, 3987);
INSERT INTO k_experience VALUES (5, 15, 4770);
INSERT INTO k_experience VALUES (6, 15, 5762);
INSERT INTO k_experience VALUES (2, 16, 3103);
INSERT INTO k_experience VALUES (3, 16, 3723);
INSERT INTO k_experience VALUES (4, 16, 4473);
INSERT INTO k_experience VALUES (5, 16, 5352);
INSERT INTO k_experience VALUES (6, 16, 6464);
INSERT INTO k_experience VALUES (2, 17, 3481);
INSERT INTO k_experience VALUES (3, 17, 4178);
INSERT INTO k_experience VALUES (4, 17, 5019);
INSERT INTO k_experience VALUES (5, 17, 6006);
INSERT INTO k_experience VALUES (6, 17, 7252);
INSERT INTO k_experience VALUES (2, 18, 3906);
INSERT INTO k_experience VALUES (3, 18, 4687);
INSERT INTO k_experience VALUES (4, 18, 5631);
INSERT INTO k_experience VALUES (5, 18, 6738);
INSERT INTO k_experience VALUES (6, 18, 8138);
INSERT INTO k_experience VALUES (2, 19, 4423);
INSERT INTO k_experience VALUES (3, 19, 5307);
INSERT INTO k_experience VALUES (4, 19, 6376);
INSERT INTO k_experience VALUES (5, 19, 7628);
INSERT INTO k_experience VALUES (6, 19, 9214);
INSERT INTO k_experience VALUES (2, 20, 0);
INSERT INTO k_experience VALUES (3, 20, 6009);
INSERT INTO k_experience VALUES (4, 20, 7219);
INSERT INTO k_experience VALUES (5, 20, 8638);
INSERT INTO k_experience VALUES (6, 20, 10431);
INSERT INTO k_experience VALUES (3, 21, 6802);
INSERT INTO k_experience VALUES (4, 21, 8172);
INSERT INTO k_experience VALUES (5, 21, 9779);
INSERT INTO k_experience VALUES (6, 21, 11811);
INSERT INTO k_experience VALUES (3, 22, 7703);
INSERT INTO k_experience VALUES (4, 22, 9254);
INSERT INTO k_experience VALUES (5, 22, 11072);
INSERT INTO k_experience VALUES (6, 22, 13371);
INSERT INTO k_experience VALUES (3, 23, 8720);
INSERT INTO k_experience VALUES (4, 23, 10476);
INSERT INTO k_experience VALUES (5, 23, 12535);
INSERT INTO k_experience VALUES (6, 23, 15140);
INSERT INTO k_experience VALUES (3, 24, 9962);
INSERT INTO k_experience VALUES (4, 24, 11969);
INSERT INTO k_experience VALUES (5, 24, 14321);
INSERT INTO k_experience VALUES (6, 24, 17296);
INSERT INTO k_experience VALUES (3, 25, 0);
INSERT INTO k_experience VALUES (4, 25, 13673);
INSERT INTO k_experience VALUES (5, 25, 16360);
INSERT INTO k_experience VALUES (6, 25, 19758);
INSERT INTO k_experience VALUES (4, 26, 15619);
INSERT INTO k_experience VALUES (5, 26, 18690);
INSERT INTO k_experience VALUES (6, 26, 22572);
INSERT INTO k_experience VALUES (4, 27, 17844);
INSERT INTO k_experience VALUES (5, 27, 21350);
INSERT INTO k_experience VALUES (6, 27, 25786);
INSERT INTO k_experience VALUES (4, 28, 20386);
INSERT INTO k_experience VALUES (5, 28, 24392);
INSERT INTO k_experience VALUES (6, 28, 29458);
INSERT INTO k_experience VALUES (4, 29, 23495);
INSERT INTO k_experience VALUES (5, 29, 28113);
INSERT INTO k_experience VALUES (6, 29, 33954);
INSERT INTO k_experience VALUES (4, 30, 0);
INSERT INTO k_experience VALUES (5, 30, 32404);
INSERT INTO k_experience VALUES (6, 30, 39134);
INSERT INTO k_experience VALUES (5, 31, 37348);
INSERT INTO k_experience VALUES (6, 31, 45107);
INSERT INTO k_experience VALUES (5, 32, 43048);
INSERT INTO k_experience VALUES (6, 32, 51990);
INSERT INTO k_experience VALUES (5, 33, 49617);
INSERT INTO k_experience VALUES (6, 33, 59924);
INSERT INTO k_experience VALUES (5, 34, 57188);
INSERT INTO k_experience VALUES (6, 34, 69068);
INSERT INTO k_experience VALUES (5, 35, 0);
INSERT INTO k_experience VALUES (6, 35, 76085);
INSERT INTO k_experience VALUES (6, 36, 83816);
INSERT INTO k_experience VALUES (6, 37, 92332);
INSERT INTO k_experience VALUES (6, 38, 101712);
INSERT INTO k_experience VALUES (6, 39, 112046);
INSERT INTO k_experience VALUES (6, 40, 0);