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, type 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);

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

CREATE TABLE IF NOT EXISTS k_guild_skill(id INT, skill_group INT, level INT, effect TEXT);

CREATE TABLE IF NOT EXISTS k_rune_craft_type(id INT, name TEXT, gem INT, inmemorial INT, ancient INT);

CREATE TABLE IF NOT EXISTS k_rune_craft_range(gem INT, ancient INT, quality INT, stat INT, min INT, max INT);

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

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

INSERT INTO k_area_type VALUES (1, 'Scenario', null);
INSERT INTO k_area_type VALUES (2, 'Cairos Dungeons', 2);
INSERT INTO k_area_type VALUES (3, 'Rift Elemental Dungeon', 2);
INSERT INTO k_area_type VALUES (4, 'Rift Raid', null);
INSERT INTO k_area_type VALUES (5, 'Dimensional Hole', 2);
INSERT INTO k_area_type VALUES (6, 'Arena', 3);
INSERT INTO k_area_type VALUES (7, 'Guild War', 5);
INSERT INTO k_area_type VALUES (8, 'Guild Siege', 5);
INSERT INTO k_area_type VALUES (9, 'Tartarus Labyrinth', 5);
INSERT INTO k_area_type VALUES (10, 'Trial of Ascension', null);
INSERT INTO k_area_type VALUES (11, 'World Boss', null);
INSERT INTO k_area_type VALUES (12, 'Dimensional Rift', null);

INSERT INTO k_area VALUES (1, 1, 'Garen Forest');
INSERT INTO k_area VALUES (2, 1, 'Mt. Siz');
INSERT INTO k_area VALUES (3, 1, 'Kabir Ruins');
INSERT INTO k_area VALUES (4, 1, 'Mt. White Ragon');
INSERT INTO k_area VALUES (5, 1, 'Telain Forest');
INSERT INTO k_area VALUES (6, 1, 'Hydeni Ruins');
INSERT INTO k_area VALUES (7, 1, 'Tamor Desert');
INSERT INTO k_area VALUES (8, 1, 'Vrofagus Ruins');
INSERT INTO k_area VALUES (9, 1, 'Faimon Volcano');
INSERT INTO k_area VALUES (10, 1, 'Aiden Forest');
INSERT INTO k_area VALUES (11, 1, 'Ferun Castle');
INSERT INTO k_area VALUES (12, 1, 'Mt Runar');
INSERT INTO k_area VALUES (13, 1, 'Chiruka Remains');
INSERT INTO k_area VALUES (1001, 2, 'Hall of Dark');
INSERT INTO k_area VALUES (1101, 5, 'Sanctuary of Dreaming Fairies');
INSERT INTO k_area VALUES (1201, 5, 'Ellunia Remains (Fairy)');
INSERT INTO k_area VALUES (1202, 5, 'Ellunia Remains (Pixie)');
INSERT INTO k_area VALUES (2001, 2, 'Hall of Fire');
INSERT INTO k_area VALUES (2101, 5, 'Forest of Roaring Beasts');
INSERT INTO k_area VALUES (2201, 5, 'Karzhan Remains (Warbear)');
INSERT INTO k_area VALUES (2202, 5, 'Karzhan Remains (Inugami)');
INSERT INTO k_area VALUES (3001, 2, 'Hall of Water');
INSERT INTO k_area VALUES (4001, 2, 'Hall of Wind');
INSERT INTO k_area VALUES (5001, 2, 'Hall of Magic');
INSERT INTO k_area VALUES (6001, 2, 'Necropolis');
INSERT INTO k_area VALUES (7001, 2, 'Hall of Light');
INSERT INTO k_area VALUES (8001, 2, 'Giant''s Keep');
INSERT INTO k_area VALUES (9001, 2, 'Dragon''s Lair');
INSERT INTO k_area VALUES (1001, 3, 'Rift Dungeon - Ice Beast');
INSERT INTO k_area VALUES (2001, 3, 'Rift Dungeon - Fire Beast');
INSERT INTO k_area VALUES (3001, 3, 'Rift Dungeon - Wind Beast');
INSERT INTO k_area VALUES (4001, 3, 'Rift Dungeon - Light Beast');
INSERT INTO k_area VALUES (5001, 3, 'Rift Dungeon - Dark Beast');
INSERT INTO k_area VALUES (1, 4, 'Rift of Worlds - level 1');
INSERT INTO k_area VALUES (2, 4, 'Rift of Worlds - level 2');
INSERT INTO k_area VALUES (3, 4, 'Rift of Worlds - level 3');
INSERT INTO k_area VALUES (4, 4, 'Rift of Worlds - level 4');
INSERT INTO k_area VALUES (5, 4, 'Rift of Worlds - level 5');

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_decoration_level VALUES (4, 1, 2, 100);
INSERT INTO k_decoration_level VALUES (4, 2, 4, 280);
INSERT INTO k_decoration_level VALUES (4, 3, 6, 460);
INSERT INTO k_decoration_level VALUES (4, 4, 8, 640);
INSERT INTO k_decoration_level VALUES (4, 5, 10, 820);
INSERT INTO k_decoration_level VALUES (4, 6, 12, 1000);
INSERT INTO k_decoration_level VALUES (4, 7, 14, 1180);
INSERT INTO k_decoration_level VALUES (4, 8, 16, 1360);
INSERT INTO k_decoration_level VALUES (4, 9, 18, 1540);
INSERT INTO k_decoration_level VALUES (4, 10, 20, 1720);
INSERT INTO k_decoration_level VALUES (15, 1, 3, 120);
INSERT INTO k_decoration_level VALUES (15, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (15, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (15, 4, 9, 480);
INSERT INTO k_decoration_level VALUES (15, 5, 11, 600);
INSERT INTO k_decoration_level VALUES (15, 6, 13, 720);
INSERT INTO k_decoration_level VALUES (15, 7, 15, 840);
INSERT INTO k_decoration_level VALUES (15, 8, 17, 960);
INSERT INTO k_decoration_level VALUES (15, 9, 19, 1080);
INSERT INTO k_decoration_level VALUES (15, 10, 21, 1200);
INSERT INTO k_decoration_level VALUES (16, 1, 3, 120);
INSERT INTO k_decoration_level VALUES (16, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (16, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (16, 4, 9, 480);
INSERT INTO k_decoration_level VALUES (16, 5, 11, 600);
INSERT INTO k_decoration_level VALUES (16, 6, 13, 720);
INSERT INTO k_decoration_level VALUES (16, 7, 15, 840);
INSERT INTO k_decoration_level VALUES (16, 8, 17, 960);
INSERT INTO k_decoration_level VALUES (16, 9, 19, 1080);
INSERT INTO k_decoration_level VALUES (16, 10, 21, 1200);
INSERT INTO k_decoration_level VALUES (17, 1, 3, 120);
INSERT INTO k_decoration_level VALUES (17, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (17, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (17, 4, 9, 480);
INSERT INTO k_decoration_level VALUES (17, 5, 11, 600);
INSERT INTO k_decoration_level VALUES (17, 6, 13, 720);
INSERT INTO k_decoration_level VALUES (17, 7, 15, 840);
INSERT INTO k_decoration_level VALUES (17, 8, 17, 960);
INSERT INTO k_decoration_level VALUES (17, 9, 19, 1080);
INSERT INTO k_decoration_level VALUES (17, 10, 21, 1200);
INSERT INTO k_decoration_level VALUES (18, 1, 3, 120);
INSERT INTO k_decoration_level VALUES (18, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (18, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (18, 4, 9, 480);
INSERT INTO k_decoration_level VALUES (18, 5, 11, 600);
INSERT INTO k_decoration_level VALUES (18, 6, 13, 720);
INSERT INTO k_decoration_level VALUES (18, 7, 15, 840);
INSERT INTO k_decoration_level VALUES (18, 8, 17, 960);
INSERT INTO k_decoration_level VALUES (18, 9, 19, 1080);
INSERT INTO k_decoration_level VALUES (18, 10, 21, 1200);
INSERT INTO k_decoration_level VALUES (19, 1, 3, 120);
INSERT INTO k_decoration_level VALUES (19, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (19, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (19, 4, 9, 480);
INSERT INTO k_decoration_level VALUES (19, 5, 11, 600);
INSERT INTO k_decoration_level VALUES (19, 6, 13, 720);
INSERT INTO k_decoration_level VALUES (19, 7, 15, 840);
INSERT INTO k_decoration_level VALUES (19, 8, 17, 960);
INSERT INTO k_decoration_level VALUES (19, 9, 19, 1080);
INSERT INTO k_decoration_level VALUES (19, 10, 21, 1200);
INSERT INTO k_decoration_level VALUES (31, 1, 2, 120);
INSERT INTO k_decoration_level VALUES (31, 2, 5, 240);
INSERT INTO k_decoration_level VALUES (31, 3, 7, 360);
INSERT INTO k_decoration_level VALUES (31, 4, 10, 480);
INSERT INTO k_decoration_level VALUES (31, 5, 12, 600);
INSERT INTO k_decoration_level VALUES (31, 6, 15, 720);
INSERT INTO k_decoration_level VALUES (31, 7, 17, 840);
INSERT INTO k_decoration_level VALUES (31, 8, 20, 960);
INSERT INTO k_decoration_level VALUES (31, 9, 22, 1080);
INSERT INTO k_decoration_level VALUES (31, 10, 25, 1200);
INSERT INTO k_decoration_level VALUES (6, 1, 2, 240);
INSERT INTO k_decoration_level VALUES (6, 2, 3, 440);
INSERT INTO k_decoration_level VALUES (6, 3, 5, 640);
INSERT INTO k_decoration_level VALUES (6, 4, 6, 840);
INSERT INTO k_decoration_level VALUES (6, 5, 8, 1040);
INSERT INTO k_decoration_level VALUES (6, 6, 9, 1240);
INSERT INTO k_decoration_level VALUES (6, 7, 11, 1440);
INSERT INTO k_decoration_level VALUES (6, 8, 12, 1640);
INSERT INTO k_decoration_level VALUES (6, 9, 14, 1840);
INSERT INTO k_decoration_level VALUES (6, 10, 15, 2040);
INSERT INTO k_decoration_level VALUES (8, 1, 2, 200);
INSERT INTO k_decoration_level VALUES (8, 2, 4, 400);
INSERT INTO k_decoration_level VALUES (8, 3, 6, 600);
INSERT INTO k_decoration_level VALUES (8, 4, 8, 800);
INSERT INTO k_decoration_level VALUES (8, 5, 10, 1000);
INSERT INTO k_decoration_level VALUES (8, 6, 12, 1200);
INSERT INTO k_decoration_level VALUES (8, 7, 14, 1400);
INSERT INTO k_decoration_level VALUES (8, 8, 16, 1600);
INSERT INTO k_decoration_level VALUES (8, 9, 18, 1800);
INSERT INTO k_decoration_level VALUES (8, 10, 20, 2000);
INSERT INTO k_decoration_level VALUES (36, 1, 2, 280);
INSERT INTO k_decoration_level VALUES (36, 2, 4, 460);
INSERT INTO k_decoration_level VALUES (36, 3, 6, 800);
INSERT INTO k_decoration_level VALUES (36, 4, 8, 1250);
INSERT INTO k_decoration_level VALUES (36, 5, 10, 1810);
INSERT INTO k_decoration_level VALUES (36, 6, 12, 2320);
INSERT INTO k_decoration_level VALUES (36, 7, 14, 2910);
INSERT INTO k_decoration_level VALUES (36, 8, 16, 3590);
INSERT INTO k_decoration_level VALUES (36, 9, 18, 4350);
INSERT INTO k_decoration_level VALUES (36, 10, 20, 5200);
INSERT INTO k_decoration_level VALUES (37, 1, 2, 260);
INSERT INTO k_decoration_level VALUES (37, 2, 5, 410);
INSERT INTO k_decoration_level VALUES (37, 3, 7, 700);
INSERT INTO k_decoration_level VALUES (37, 4, 9, 1080);
INSERT INTO k_decoration_level VALUES (37, 5, 12, 1560);
INSERT INTO k_decoration_level VALUES (37, 6, 15, 1990);
INSERT INTO k_decoration_level VALUES (37, 7, 17, 2490);
INSERT INTO k_decoration_level VALUES (37, 8, 20, 3070);
INSERT INTO k_decoration_level VALUES (37, 9, 22, 3720);
INSERT INTO k_decoration_level VALUES (37, 10, 25, 4440);
INSERT INTO k_decoration_level VALUES (38, 1, 2, 330);
INSERT INTO k_decoration_level VALUES (38, 2, 4, 540);
INSERT INTO k_decoration_level VALUES (38, 3, 6, 930);
INSERT INTO k_decoration_level VALUES (38, 4, 8, 1450);
INSERT INTO k_decoration_level VALUES (38, 5, 10, 2100);
INSERT INTO k_decoration_level VALUES (38, 6, 12, 2680);
INSERT INTO k_decoration_level VALUES (38, 7, 14, 3360);
INSERT INTO k_decoration_level VALUES (38, 8, 16, 4140);
INSERT INTO k_decoration_level VALUES (38, 9, 18, 5020);
INSERT INTO k_decoration_level VALUES (38, 10, 20, 5990);
INSERT INTO k_decoration_level VALUES (39, 1, 2, 300);
INSERT INTO k_decoration_level VALUES (39, 2, 4, 460);
INSERT INTO k_decoration_level VALUES (39, 3, 6, 760);
INSERT INTO k_decoration_level VALUES (39, 4, 8, 1160);
INSERT INTO k_decoration_level VALUES (39, 5, 10, 1670);
INSERT INTO k_decoration_level VALUES (39, 6, 12, 2130);
INSERT INTO k_decoration_level VALUES (39, 7, 14, 2660);
INSERT INTO k_decoration_level VALUES (39, 8, 16, 3270);
INSERT INTO k_decoration_level VALUES (39, 9, 18, 3960);
INSERT INTO k_decoration_level VALUES (39, 10, 20, 4720);
INSERT INTO k_decoration_level VALUES (9, 1, 2, 150);
INSERT INTO k_decoration_level VALUES (9, 2, 4, 375);
INSERT INTO k_decoration_level VALUES (9, 3, 6, 600);
INSERT INTO k_decoration_level VALUES (9, 4, 8, 825);
INSERT INTO k_decoration_level VALUES (9, 5, 10, 1050);
INSERT INTO k_decoration_level VALUES (9, 6, 12, 1275);
INSERT INTO k_decoration_level VALUES (9, 7, 14, 1500);
INSERT INTO k_decoration_level VALUES (9, 8, 16, 1725);
INSERT INTO k_decoration_level VALUES (9, 9, 18, 1950);
INSERT INTO k_decoration_level VALUES (9, 10, 20, 2175);
INSERT INTO k_decoration_level VALUES (7, 1, 2, 80);
INSERT INTO k_decoration_level VALUES (7, 2, 4, 130);
INSERT INTO k_decoration_level VALUES (7, 3, 6, 180);
INSERT INTO k_decoration_level VALUES (7, 4, 8, 230);
INSERT INTO k_decoration_level VALUES (7, 5, 10, 280);
INSERT INTO k_decoration_level VALUES (7, 6, 12, 330);
INSERT INTO k_decoration_level VALUES (7, 7, 14, 380);
INSERT INTO k_decoration_level VALUES (7, 8, 16, 430);
INSERT INTO k_decoration_level VALUES (7, 9, 18, 480);
INSERT INTO k_decoration_level VALUES (7, 10, 20, 530);
INSERT INTO k_decoration_level VALUES (34, 1, 1, 80);
INSERT INTO k_decoration_level VALUES (34, 2, 2, 130);
INSERT INTO k_decoration_level VALUES (34, 3, 3, 180);
INSERT INTO k_decoration_level VALUES (34, 4, 4, 230);
INSERT INTO k_decoration_level VALUES (34, 5, 5, 280);
INSERT INTO k_decoration_level VALUES (34, 6, 6, 330);
INSERT INTO k_decoration_level VALUES (34, 7, 7, 380);
INSERT INTO k_decoration_level VALUES (34, 8, 8, 430);
INSERT INTO k_decoration_level VALUES (34, 9, 9, 480);
INSERT INTO k_decoration_level VALUES (34, 10, 10, 530);
INSERT INTO k_decoration_level VALUES (11, 1, 3, 50);
INSERT INTO k_decoration_level VALUES (11, 2, 6, 100);
INSERT INTO k_decoration_level VALUES (11, 3, 9, 150);
INSERT INTO k_decoration_level VALUES (11, 4, 12, 200);
INSERT INTO k_decoration_level VALUES (11, 5, 15, 250);
INSERT INTO k_decoration_level VALUES (11, 6, 18, 300);
INSERT INTO k_decoration_level VALUES (11, 7, 21, 350);
INSERT INTO k_decoration_level VALUES (11, 8, 24, 400);
INSERT INTO k_decoration_level VALUES (11, 9, 27, 450);
INSERT INTO k_decoration_level VALUES (11, 10, 30, 500);
INSERT INTO k_decoration_level VALUES (5, 1, 5, 40);
INSERT INTO k_decoration_level VALUES (5, 2, 10, 90);
INSERT INTO k_decoration_level VALUES (5, 3, 15, 140);
INSERT INTO k_decoration_level VALUES (5, 4, 20, 190);
INSERT INTO k_decoration_level VALUES (5, 5, 25, 240);
INSERT INTO k_decoration_level VALUES (5, 6, 30, 290);
INSERT INTO k_decoration_level VALUES (5, 7, 35, 340);
INSERT INTO k_decoration_level VALUES (5, 8, 40, 390);
INSERT INTO k_decoration_level VALUES (5, 9, 45, 440);
INSERT INTO k_decoration_level VALUES (5, 10, 50, 490);
INSERT INTO k_decoration_level VALUES (10, 1, 1, 30);
INSERT INTO k_decoration_level VALUES (10, 2, 2, 80);
INSERT INTO k_decoration_level VALUES (10, 3, 3, 140);
INSERT INTO k_decoration_level VALUES (10, 4, 4, 200);
INSERT INTO k_decoration_level VALUES (10, 5, 5, 260);
INSERT INTO k_decoration_level VALUES (10, 6, 6, 320);
INSERT INTO k_decoration_level VALUES (10, 7, 7, 380);
INSERT INTO k_decoration_level VALUES (10, 8, 8, 440);
INSERT INTO k_decoration_level VALUES (10, 9, 9, 500);
INSERT INTO k_decoration_level VALUES (10, 10, 10, 560);
INSERT INTO k_decoration_level VALUES (35, 1, 200, 30);
INSERT INTO k_decoration_level VALUES (35, 2, 400, 80);
INSERT INTO k_decoration_level VALUES (35, 3, 600, 130);
INSERT INTO k_decoration_level VALUES (35, 4, 800, 180);
INSERT INTO k_decoration_level VALUES (35, 5, 1000, 230);
INSERT INTO k_decoration_level VALUES (35, 6, 1200, 280);
INSERT INTO k_decoration_level VALUES (35, 7, 1400, 330);
INSERT INTO k_decoration_level VALUES (35, 8, 1600, 380);
INSERT INTO k_decoration_level VALUES (35, 9, 1800, 430);
INSERT INTO k_decoration_level VALUES (35, 10, 2000, 480);


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(1, 9, 'Unknown Scroll', '');
INSERT INTO k_inventory VALUES(2, 9, 'Social Points', '');
INSERT INTO k_inventory VALUES(3, 9, 'Mystical Scroll', '');
INSERT INTO k_inventory VALUES(4, 9, 'Mystical Summon', '');
INSERT INTO k_inventory VALUES(5, 9, 'Fire Scroll', '');
INSERT INTO k_inventory VALUES(6, 9, 'Water Scroll', '');
INSERT INTO k_inventory VALUES(7, 9, 'Wind Scroll', '');
INSERT INTO k_inventory VALUES(8, 9, 'Light and Dark Scroll', '');
INSERT INTO k_inventory VALUES(9, 9, 'Legendary Scroll', '');
INSERT INTO k_inventory VALUES(10, 9, 'Summon Stone', '');
INSERT INTO k_inventory VALUES(11, 9, 'Light and Dark Summon', '');
INSERT INTO k_inventory VALUES(12, 9, 'Legendary Summon Pieces', '');
INSERT INTO k_inventory VALUES(13, 9, 'Transcendance Scroll', '');
INSERT INTO k_inventory VALUES(14, 9, 'Legendary Water Scroll', '');
INSERT INTO k_inventory VALUES(15, 9, 'Legendary Fire Scroll', '');
INSERT INTO k_inventory VALUES(16, 9, 'Legendary Wind Scroll', '');
INSERT INTO k_inventory VALUES(11006, 11, 'Essence of Magic (low)', '');
INSERT INTO k_inventory VALUES(12006, 11, 'Essence of Magic (mid)', '');
INSERT INTO k_inventory VALUES(13006, 11, 'Essence of Magic (high)', '');
INSERT INTO k_inventory VALUES(11001, 11, 'Essence of Water (low)', '');
INSERT INTO k_inventory VALUES(12001, 11, 'Essence of Water (mid)', '');
INSERT INTO k_inventory VALUES(13001, 11, 'Essence of Water (high)', '');
INSERT INTO k_inventory VALUES(11002, 11, 'Essence of Fire (low)', '');
INSERT INTO k_inventory VALUES(12002, 11, 'Essence of Fire (mid)', '');
INSERT INTO k_inventory VALUES(13002, 11, 'Essence of Fire (high)', '');
INSERT INTO k_inventory VALUES(11003, 11, 'Essence of Wind (low)', '');
INSERT INTO k_inventory VALUES(12003, 11, 'Essence of Wind (mid)', '');
INSERT INTO k_inventory VALUES(13003, 11, 'Essence of Wind (high)', '');
INSERT INTO k_inventory VALUES(11004, 11, 'Essence of Light (low)', '');
INSERT INTO k_inventory VALUES(12004, 11, 'Essence of Light (mid)', '');
INSERT INTO k_inventory VALUES(13004, 11, 'Essence of Light (high)', '');
INSERT INTO k_inventory VALUES(11005, 11, 'Essence of Dark (low)', '');
INSERT INTO k_inventory VALUES(12005, 11, 'Essence of Dark (mid)', '');
INSERT INTO k_inventory VALUES(13005, 11, 'Essence of Dark (high)', '');
INSERT INTO k_inventory VALUES(1001, 29, 'Wood', '');
INSERT INTO k_inventory VALUES(1002, 29, 'Leather', '');
INSERT INTO k_inventory VALUES(1003, 29, 'Rock', '');
INSERT INTO k_inventory VALUES(1004, 29, 'Ore', '');
INSERT INTO k_inventory VALUES(1005, 29, 'Mithril', '');
INSERT INTO k_inventory VALUES(1006, 29, 'Cloth', '');
INSERT INTO k_inventory VALUES(2001, 27, 'Rune Piece', '');
INSERT INTO k_inventory VALUES(3001, 29, 'Powder', '');
INSERT INTO k_inventory VALUES(4001, 27, 'Symbol of Harmony', '');
INSERT INTO k_inventory VALUES(4002, 27, 'Symbol of Transcendance', '');
INSERT INTO k_inventory VALUES(4003, 27, 'Symbol of Chaos', '');
INSERT INTO k_inventory VALUES(5001, 29,  'Crystal of Water', '');
INSERT INTO k_inventory VALUES(5002, 29, 'Crystal of Fire', '');
INSERT INTO k_inventory VALUES(5003, 29, 'Crystal of Wind', '');
INSERT INTO k_inventory VALUES(5004, 29, 'Crystal of Light', '');
INSERT INTO k_inventory VALUES(5005, 29, 'Crystal of Dark', '');
INSERT INTO k_inventory VALUES(6001, 29, 'Crystal of Magic', '');
INSERT INTO k_inventory VALUES(7001, 29, 'Crystal of Pure', '');
INSERT INTO k_inventory VALUES(8002, 29, 'Ancient Magic Origin', '');
INSERT INTO k_inventory VALUES(9002, 27, 'Karzhan''s Rune Ore', '');
INSERT INTO k_inventory VALUES(8001, 27, 'Ancient Magic Stone', '');
INSERT INTO k_inventory VALUES(142110115, 61, 'Water Angelmon', '');
INSERT INTO k_inventory VALUES(142120115, 61, 'Fire Angelmon', '');
INSERT INTO k_inventory VALUES(142130115, 61, 'Wind Angelmon', '');
INSERT INTO k_inventory VALUES(142140115, 61, 'Light Angelmon', '');
INSERT INTO k_inventory VALUES(142150115, 61, 'Dark Angelmon', '');
INSERT INTO k_inventory VALUES(182110115, 61, 'Water King Angelmon', '');
INSERT INTO k_inventory VALUES(182120115, 61, 'Fire King Angelmon', '');
INSERT INTO k_inventory VALUES(182130115, 61, 'Wind King Angelmon', '');
INSERT INTO k_inventory VALUES(182140115, 61, 'Light King Angelmon', '');
INSERT INTO k_inventory VALUES(182150115, 61, 'Dark King Angelmon', '');
INSERT INTO k_inventory VALUES(143140220, 61, 'Rainbowmon (2* MAX)', '');
INSERT INTO k_inventory VALUES(143140301, 61, 'Rainbowmon (3*)', '');
INSERT INTO k_inventory VALUES(143140325, 61, 'Rainbowmon (3* MAX)', '');
INSERT INTO k_inventory VALUES(143140401, 61, 'Rainbowmon (4*)', '');
INSERT INTO k_inventory VALUES(143140430, 61, 'Rainbowmon (4* MAX)', '');
INSERT INTO k_inventory VALUES(143140501, 61, 'Rainbowmon (5*)', '');
INSERT INTO k_inventory VALUES(151050101, 61, 'Devilmon', '');
INSERT INTO k_inventory VALUES(217140115, 61, 'Super Angelmon', '');

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);

INSERT INTO k_guild_skill_group VALUES (1, 'Crest of Punishment', 'Increases the stats of ally Monsters in Cairos Dungeon');
INSERT INTO k_guild_skill_group VALUES (2, 'Aura of Purification', 'Increases the stats of ally Monsters in Rift Beast Battles');
INSERT INTO k_guild_skill_group VALUES (3, 'Pavement of Ancient', 'Increases the stats of ally Monsters in Labyrinths');
INSERT INTO k_guild_skill_group VALUES (4, 'Pledge of Faith', 'Increases the stats of ally Monsters in Rift Raid Battles');
INSERT INTO k_guild_skill_group VALUES (5, 'Trade association Alliance', 'Unlocks an aditional slot in the Guild Magic Shop');
INSERT INTO k_guild_skill_group VALUES (6, 'Mana Purifier', 'Increases the amount of Mana Stones you acquire in all battles');
INSERT INTO k_guild_skill_group VALUES (7, 'EXP Amplifier', 'Increases the amount of EXP  that all Monsters acquire in battles');

INSERT INTO k_guild_skill VALUES (1, 1, 1, 'HP +2%');
INSERT INTO k_guild_skill VALUES (2, 1, 6, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (3, 1, 11, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (4, 1, 16, 'HP +2%');
INSERT INTO k_guild_skill VALUES (5, 1, 21, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (6, 1, 26, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (7, 2, 2, 'HP +2%');
INSERT INTO k_guild_skill VALUES (8, 2, 7, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (9, 2, 12, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (10, 2, 17, 'HP +2%');
INSERT INTO k_guild_skill VALUES (11, 2, 22, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (12, 2, 27, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (13, 3, 3, 'HP +2%');
INSERT INTO k_guild_skill VALUES (14, 3, 8, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (15, 3, 13, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (16, 3, 18, 'HP +2%');
INSERT INTO k_guild_skill VALUES (17, 3, 23, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (18, 3, 28, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (19, 4, 4, 'HP +2%');
INSERT INTO k_guild_skill VALUES (20, 4, 9, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (21, 4, 14, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (22, 4, 19, 'HP +2%');
INSERT INTO k_guild_skill VALUES (23, 4, 24, 'DEF +2%');
INSERT INTO k_guild_skill VALUES (24, 4, 29, 'ATK +2%');
INSERT INTO k_guild_skill VALUES (25, 5, 5, 'Add 1 more Guild Magic Shop slot');
INSERT INTO k_guild_skill VALUES (26, 5, 10, 'Add 1 more Guild Magic Shop slot');
INSERT INTO k_guild_skill VALUES (27, 5, 15, 'Add 1 more Guild Magic Shop slot');
INSERT INTO k_guild_skill VALUES (28, 5, 20, 'Add 1 more Guild Magic Shop slot');
INSERT INTO k_guild_skill VALUES (29, 6, 15, 'Gain 5% additional Mana Stones');
INSERT INTO k_guild_skill VALUES (30, 7, 30, 'Gain 5% additional EXP');

INSERT INTO k_rune_craft_type VALUES (1, 'Enchant Gem', 1, 0, 0);
INSERT INTO k_rune_craft_type VALUES (2, 'Grindstone', 0, 0, 0);
INSERT INTO k_rune_craft_type VALUES (3, 'Inmemorial Gem', 1, 1, 0);
INSERT INTO k_rune_craft_type VALUES (4, 'Inmemorial Grindstone', 0, 1, 0);
INSERT INTO k_rune_craft_type VALUES (5, 'Ancient Gem', 1, 0, 1);
INSERT INTO k_rune_craft_type VALUES (6, 'Ancient Grindstone', 0, 0, 1);

INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 1, 80, 120);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 1, 100, 200);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 1, 180, 250);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 1, 230, 450);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 1, 430, 550);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 2, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 2, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 2, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 2, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 2, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 3, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 3, 6, 12);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 3, 10, 18);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 3, 12, 22);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 3, 18, 30);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 4, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 4, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 4, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 4, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 4, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 5, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 5, 6, 12);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 5, 10, 18);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 5, 12, 22);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 5, 18, 30);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 6, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 6, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 6, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 6, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 6, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 8, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 8, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 8, 2, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 8, 3, 4);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 8, 4, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 9, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 9, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 9, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 9, 3, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 9, 4, 6);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 10, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 10, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 10, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 10, 3, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 10, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 11, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 11, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 11, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 11, 3, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 11, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 0, 1, 12, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 0, 2, 12, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 0, 3, 12, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 0, 4, 12, 3, 7);
INSERT INTO k_rune_craft_range VALUES (0, 0, 5, 12, 4, 8);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 1, 100, 150);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 1, 130, 220);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 1, 200, 310);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 1, 290, 420);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 1, 400, 580);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 2, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 2, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 2, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 2, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 2, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 3, 8, 12);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 3, 10, 16);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 3, 15, 23);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 3, 20, 30);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 3, 28, 40);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 4, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 4, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 4, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 4, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 4, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 5, 8, 12);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 5, 10, 16);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 5, 15, 23);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 5, 20, 30);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 5, 28, 40);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 6, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 6, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 6, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 6, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 6, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 8, 1, 3);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 8, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 8, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 8, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 8, 7, 10);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 9, 1, 3);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 9, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 9, 3, 5);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 9, 4, 7);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 9, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 10, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 10, 3, 5);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 10, 4, 6);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 10, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 10, 7, 10);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 11, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 11, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 11, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 11, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 11, 8, 11);
INSERT INTO k_rune_craft_range VALUES (1, 0, 1, 12, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 0, 2, 12, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 0, 3, 12, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 0, 4, 12, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 0, 5, 12, 8, 11);
-- TODO: Fix ancient ranges
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 1, 80, 120);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 1, 100, 200);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 1, 180, 250);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 1, 230, 450);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 1, 430, 550);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 2, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 2, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 2, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 2, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 2, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 3, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 3, 6, 12);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 3, 10, 18);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 3, 12, 22);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 3, 18, 30);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 4, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 4, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 4, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 4, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 4, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 5, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 5, 6, 12);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 5, 10, 18);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 5, 12, 22);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 5, 18, 30);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 6, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 6, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 6, 3, 6);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 6, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 6, 5, 10);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 8, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 8, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 8, 2, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 8, 3, 4);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 8, 4, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 9, 1, 2);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 9, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 9, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 9, 3, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 9, 4, 6);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 10, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 10, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 10, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 10, 3, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 10, 4, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 11, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 11, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 11, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 11, 3, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 11, 4, 8);
INSERT INTO k_rune_craft_range VALUES (0, 1, 1, 12, 1, 3);
INSERT INTO k_rune_craft_range VALUES (0, 1, 2, 12, 2, 4);
INSERT INTO k_rune_craft_range VALUES (0, 1, 3, 12, 2, 5);
INSERT INTO k_rune_craft_range VALUES (0, 1, 4, 12, 3, 7);
INSERT INTO k_rune_craft_range VALUES (0, 1, 5, 12, 4, 8);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 1, 100, 150);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 1, 130, 220);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 1, 200, 310);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 1, 290, 420);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 1, 400, 580);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 2, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 2, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 2, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 2, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 2, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 3, 8, 12);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 3, 10, 16);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 3, 15, 23);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 3, 20, 30);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 3, 28, 40);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 4, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 4, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 4, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 4, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 4, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 5, 8, 12);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 5, 10, 16);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 5, 15, 23);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 5, 20, 30);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 5, 28, 40);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 6, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 6, 3, 7);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 6, 5, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 6, 7, 11);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 6, 9, 13);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 8, 1, 3);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 8, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 8, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 8, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 8, 7, 10);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 9, 1, 3);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 9, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 9, 3, 5);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 9, 4, 7);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 9, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 10, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 10, 3, 5);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 10, 4, 6);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 10, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 10, 7, 10);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 11, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 11, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 11, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 11, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 11, 8, 11);
INSERT INTO k_rune_craft_range VALUES (1, 1, 1, 12, 2, 4);
INSERT INTO k_rune_craft_range VALUES (1, 1, 2, 12, 3, 6);
INSERT INTO k_rune_craft_range VALUES (1, 1, 3, 12, 5, 8);
INSERT INTO k_rune_craft_range VALUES (1, 1, 4, 12, 6, 9);
INSERT INTO k_rune_craft_range VALUES (1, 1, 5, 12, 8, 11);