73 lines
5.7 KiB
SQL
73 lines
5.7 KiB
SQL
DELETE FROM enchantment_attributes;
|
|
DELETE FROM enchantments;
|
|
|
|
INSERT INTO enchantments (name, min_tier, max_tier, image_url) VALUES
|
|
('Vital Enchantment', 1, 1, 'https://liquipedia.net/commons/images/thumb/8/8b/Vital_Enchantment_itemicon_dota2_gameasset.png/60px-Vital_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Alert Enchantment', 1, 4, 'https://liquipedia.net/commons/images/thumb/0/0b/Alert_Enchantment_itemicon_dota2_gameasset.png/60px-Alert_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Brawny Enchantment', 1, 4, 'https://liquipedia.net/commons/images/thumb/4/4e/Brawny_Enchantment_itemicon_dota2_gameasset.png/60px-Brawny_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Mystical Enchantment', 1, 4, 'https://liquipedia.net/commons/images/thumb/0/08/Mystical_Enchantment_itemicon_dota2_gameasset.png/60px-Mystical_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Quickened Enchantment', 1, 4, 'https://liquipedia.net/commons/images/thumb/8/84/Quickened_Enchantment_itemicon_dota2_gameasset.png/60px-Quickened_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Tough Enchantment', 1, 4, 'https://liquipedia.net/commons/images/thumb/1/1b/Tough_Enchantment_itemicon_dota2_gameasset.png/60px-Tough_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Greedy Enchantment', 2, 3, 'https://liquipedia.net/commons/images/thumb/e/ee/Greedy_Enchantment_itemicon_dota2_gameasset.png/60px-Greedy_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Crude Enchantment', 2, 4, 'https://liquipedia.net/commons/images/thumb/6/66/Crude_Enchantment_itemicon_dota2_gameasset.png/60px-Crude_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Keen-Eyed Enchantment', 2, 4, 'https://liquipedia.net/commons/images/thumb/0/01/Keen-Eyed_Enchantment_itemicon_dota2_gameasset.png/60px-Keen-Eyed_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Nimble Enchantment', 2, 4, 'https://liquipedia.net/commons/images/thumb/b/be/Nimble_Enchantment_itemicon_dota2_gameasset.png/60px-Nimble_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Titanic Enchantment', 2, 4, 'https://liquipedia.net/commons/images/thumb/7/70/Titanic_Enchantment_itemicon_dota2_gameasset.png/60px-Titanic_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Timeless Enchantment', 4, 5, 'https://liquipedia.net/commons/images/thumb/5/58/Timeless_Enchantment_itemicon_dota2_gameasset.png/60px-Timeless_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Audacious Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/5/58/Audacious_Enchantment_itemicon_dota2_gameasset.png/60px-Audacious_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Evolved Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/4/4e/Evolved_Enchantment_itemicon_dota2_gameasset.png/60px-Evolved_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Feverish Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/5/50/Feverish_Enchantment_itemicon_dota2_gameasset.png/60px-Feverish_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Fleetfooted Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/b/b5/Fleetfooted_Enchantment_itemicon_dota2_gameasset.png/60px-Fleetfooted_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Hulking Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/3/3f/Hulking_Enchantment_itemicon_dota2_gameasset.png/60px-Hulking_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Manic Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/c/cf/Manic_Enchantment_itemicon_dota2_gameasset.png/60px-Manic_Enchantment_itemicon_dota2_gameasset.png'),
|
|
('Vampiric Enchantment', 5, 5, 'https://liquipedia.net/commons/images/thumb/9/91/Vampiric_Enchantment_itemicon_dota2_gameasset.png/60px-Vampiric_Enchantment_itemicon_dota2_gameasset.png');
|
|
|
|
INSERT INTO enchantment_attributes (enchantment_id, attribute)
|
|
SELECT e.id, pairs.attribute::primary_attribute FROM (VALUES
|
|
('Vital Enchantment', 'agility'),
|
|
('Vital Enchantment', 'intelligence'),
|
|
('Vital Enchantment', 'strength'),
|
|
('Vital Enchantment', 'universal'),
|
|
('Alert Enchantment', 'agility'),
|
|
('Alert Enchantment', 'universal'),
|
|
('Brawny Enchantment', 'agility'),
|
|
('Brawny Enchantment', 'strength'),
|
|
('Mystical Enchantment', 'intelligence'),
|
|
('Mystical Enchantment', 'universal'),
|
|
('Quickened Enchantment', 'agility'),
|
|
('Quickened Enchantment', 'intelligence'),
|
|
('Quickened Enchantment', 'strength'),
|
|
('Quickened Enchantment', 'universal'),
|
|
('Tough Enchantment', 'intelligence'),
|
|
('Tough Enchantment', 'strength'),
|
|
('Greedy Enchantment', 'agility'),
|
|
('Greedy Enchantment', 'intelligence'),
|
|
('Greedy Enchantment', 'strength'),
|
|
('Greedy Enchantment', 'universal'),
|
|
('Crude Enchantment', 'strength'),
|
|
('Keen-Eyed Enchantment', 'intelligence'),
|
|
('Nimble Enchantment', 'agility'),
|
|
('Titanic Enchantment', 'universal'),
|
|
('Timeless Enchantment', 'agility'),
|
|
('Timeless Enchantment', 'intelligence'),
|
|
('Timeless Enchantment', 'strength'),
|
|
('Timeless Enchantment', 'universal'),
|
|
('Audacious Enchantment', 'agility'),
|
|
('Evolved Enchantment', 'agility'),
|
|
('Evolved Enchantment', 'intelligence'),
|
|
('Evolved Enchantment', 'strength'),
|
|
('Evolved Enchantment', 'universal'),
|
|
('Feverish Enchantment', 'intelligence'),
|
|
('Fleetfooted Enchantment', 'agility'),
|
|
('Fleetfooted Enchantment', 'intelligence'),
|
|
('Fleetfooted Enchantment', 'strength'),
|
|
('Fleetfooted Enchantment', 'universal'),
|
|
('Hulking Enchantment', 'strength'),
|
|
('Manic Enchantment', 'universal'),
|
|
('Vampiric Enchantment', 'agility'),
|
|
('Vampiric Enchantment', 'intelligence'),
|
|
('Vampiric Enchantment', 'strength'),
|
|
('Vampiric Enchantment', 'universal')
|
|
) AS pairs(enchantment_name, attribute)
|
|
JOIN enchantments e ON e.name = pairs.enchantment_name;
|