Created
September 5, 2017 18:32
-
-
Save queertypes/25d1279be242d3de698b06134e2a8eff to your computer and use it in GitHub Desktop.
Revisions
-
queertypes created this gist
Sep 5, 2017 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,399 @@ create type gene as enum ( 'adaptive_cells', 'agility', 'aquatic_celerity', 'aquatic_homeostasis', 'assimilation', 'avian', 'bioluminescent', 'chloroplast_boost', 'corrosive', 'cryogenic', 'electrogenic', 'energy_stores', 'epinephrine', 'hardened_shell', 'immunization', 'insectoid', 'mammalian', 'mimicry', 'musculature', 'natural_defense', 'nerve_bundle', 'nether_touched', 'optics', 'osteichthyes', 'poisonous', 'pyrogenic', 'reactive', 'regenerative', 'reproductive_boost', 'resistance', 'skeletal_structure', 'stealth', 'stimulant' ); create type seed as enum ( 'adv_ignus_chili', 'aenema_flower', 'algae_pod', 'aquapod_bud', 'arkean_bush', 'automato', 'avesmingo', 'banana', 'battery_stem', 'beakseed', 'beeflower', 'beetle_sprout', 'bella_morte', 'bioluminescent_spore', 'biscorn', 'black_flower', 'black_orchid', 'blade_tree', 'blex_cactus', 'blister_pod', 'blizzberry', 'blood_root', 'blue_flower', 'blue_melon', 'blue_orchid', 'bolbohn', 'boltbulb', 'boneboo', 'bracken_tree', 'brown_flower', 'capriole', 'carrot', 'cellpod', 'chili', 'cinnamon_seed', 'cocoa', 'coffee', 'coffee_beans', 'coralcreep', 'corn', 'corvex_sprout', 'cotton', 'crystal_plant', 'crystallite', 'currentcorn', 'darkflight_flower', 'deathblossom', 'dioda_hybrid', 'diodia', 'dirturchin', 'dragonsbeard', 'dunestalk', 'eggshoot', 'energiflower', 'erithian_algae', 'fayshroom_spore', 'feathercrown', 'fletchweed', 'floralyt', 'garik_leaf', 'garp_berry', 'gazelemon', 'gemglow', 'genesiberry', 'ghost_mushroom', 'glarestalk_gib', 'gold_shroom', 'golden_root', 'goldenglow', 'goldensea_sponge', 'grape', 'green_flower', 'greenleaf', 'grey_flower', 'gurn_onion', 'haleflower', 'heartroot', 'helkat', 'hellfire_plant', 'herrod_bush', 'hops', 'ighant', 'ignus_chili', 'ita_flower', 'jilly_root', 'kadavan_cactus', 'kadavan_spice_plant', 'kamaran_pod', 'kiwi', 'kramil', 'lactarius_indigo', 'lasher', 'leafshell', 'little_good_berry', 'lumivine', 'meatvine_bulb', 'melodistar', 'micro_bamboo', 'minkocoa', 'miracle_grass', 'mireurchin', 'mushroom', 'mushroom_seed', 'mutavisk', 'nailery', 'nakati_bark', 'nakati_ovoid', 'neonmelon', 'neuropod', 'niss', 'oculemon', 'oonforta', 'orange_flower', 'pasaka_vine', 'pearlpea', 'pekkit', 'pineapple', 'pink_flower', 'pinkloom', 'piru_colony', 'poe_tree', 'porphis_bulb', 'potato', 'purple_flower', 'purple_orchid', 'pussplum', 'quell_stem', 'rad_grass', 'red_flower', 'reeds', 'reefpod', 'rice', 'rockroot', 'sapling', 'shadow_root', 'shock_shroom', 'silverleaf', 'slime_glob_bush', 'snowberry', 'spongeweed', 'sporing_kiri_fruit', 'spring_flower', 'springvault', 'star_mint', 'strangler_vine', 'sugarcane', 'sweet_scoop', 'talonseed', 'teratomato', 'tetherhook_weed', 'thornitox', 'tinselbush', 'tomato', 'toxictop', 'tyvokk_dart', 'uri', 'vanus_flower', 'varan_berry_bush', 'vashta', 'vextongue', 'victorleaf', 'vorit', 'wartweed', 'wheat', 'white_flower', 'whitespine', 'wretchel', 'writhing_vine', 'wubstem', 'xax', 'yellow_flower', 'yellowfoot', 'zathi' ); create table if not exists gene_from_seed ( gene_type gene not null, seed_type seed not null, unique (gene_type, seed_type) ); insert into gene_from_seed (gene_type, seed_type) values ('adaptive_cells', 'pearlpea'), ('adaptive_cells', 'wubstem'), ('agility', 'herrod_bush'), ('agility', 'star_mint'), ('agility', 'mireurchin'), ('agility', 'mutavisk'), ('agility', 'gurn_onion'), ('agility', 'piru_colony'), ('aquatic_celerity', 'aquapod_bud'), ('aquatic_celerity', 'reefpod'), ('aquatic_celerity', 'vorit'), ('aquatic_homeostasis', 'aquapod_bud'), ('aquatic_homeostasis', 'coralcreep'), ('aquatic_homeostasis', 'pink_flower'), ('assimilation', 'diodia'), ('assimilation', 'purple_flower'), ('assimilation', 'genesiberry'), ('assimilation', 'neonmelon'), ('assimilation', 'poe_tree'), ('assimilation', 'reeds'), ('avian', 'beakseed'), ('avian', 'eggshoot'), ('avian', 'orange_flower'), ('avian', 'xax'), ('avian', 'zathi'), ('bioluminescent', 'bioluminescent_spore'), ('bioluminescent', 'blister_pod'), ('bioluminescent', 'goldenglow'), ('bioluminescent', 'oonforta'), ('chloroplast_boost', 'avesmingo'), ('chloroplast_boost', 'fletchweed'), ('chloroplast_boost', 'greenleaf'), ('chloroplast_boost', 'jilly_root'), ('chloroplast_boost', 'ita_flower'), ('chloroplast_boost', 'wheat'), ('corrosive', 'corvex_sprout'), ('corrosive', 'thornitox'), ('corrosive', 'wartweed'), ('cryogenic', 'blizzberry'), ('cryogenic', 'snowberry'), ('cryogenic', 'pekkit'), ('natural_defense', 'nakati_bark'), ('natural_defense', 'kadavan_cactus'), ('natural_defense', 'uri'), ('natural_defense', 'leafshell'), ('natural_defense', 'nakati_ovoid'), ('natural_defense', 'rice'), ('natural_defense', 'helkat'), ('natural_defense', 'vanus_flower'), ('electrogenic', 'battery_stem'), ('electrogenic', 'currentcorn'), ('electrogenic', 'shock_shroom'), ('energy_stores', 'aenema_flower'), ('energy_stores', 'blex_cactus'), ('energy_stores', 'blue_melon'), ('energy_stores', 'cocoa'), ('energy_stores', 'coffee'), ('energy_stores', 'energiflower'), ('energy_stores', 'brown_flower'), ('energy_stores', 'haleflower'), ('energy_stores', 'sporing_kiri_fruit'), ('energy_stores', 'melodistar'), ('energy_stores', 'silverleaf'), ('energy_stores', 'vextongue'), ('energy_stores', 'yellowfoot'), ('osteichthyes', 'spongeweed'), ('osteichthyes', 'goldensea_sponge'), ('hardened_shell', 'arkean_bush'), ('hardened_shell', 'automato'), ('hardened_shell', 'beetle_sprout'), ('hardened_shell', 'corn'), ('hardened_shell', 'gold_shroom'), ('hardened_shell', 'kiwi'), ('hardened_shell', 'pineapple'), ('hardened_shell', 'rockroot'), ('hardened_shell', 'sapling'), ('immunization', 'darkflight_flower'), ('immunization', 'rad_grass'), ('immunization', 'kramil'), ('immunization', 'niss'), ('immunization', 'tyvokk_dart'), ('immunization', 'whitespine'), ('insectoid', 'beetle_sprout'), ('insectoid', 'bolbohn'), ('insectoid', 'cellpod'), ('insectoid', 'erithian_algae'), ('insectoid', 'pasaka_vine'), ('insectoid', 'vashta'), ('mammalian', 'boneboo'), ('mammalian', 'meatvine_bulb'), ('mammalian', 'minkocoa'), ('mimicry', 'cotton'), ('mimicry', 'crystallite'), ('mimicry', 'dioda_hybrid'), ('mimicry', 'white_flower'), ('mimicry', 'kadavan_spice_plant'), ('mimicry', 'golden_root'), ('mimicry', 'kamaran_pod'), ('mimicry', 'neuropod'), ('musculature', 'capriole'), ('musculature', 'dirturchin'), ('musculature', 'black_flower'), ('musculature', 'porphis_bulb'), ('musculature', 'pussplum'), ('musculature', 'springvault'), ('musculature', 'victorleaf'), ('nerve_bundle', 'biscorn'), ('nerve_bundle', 'blue_flower'), ('nerve_bundle', 'dunestalk'), ('nerve_bundle', 'tomato'), ('optics', 'gazelemon'), ('optics', 'glarestalk_gib'), ('optics', 'oculemon'), ('poisonous', 'bella_morte'), ('poisonous', 'deathblossom'), ('poisonous', 'toxictop'), ('poisonous', 'mushroom'), ('pyrogenic', 'chili'), ('pyrogenic', 'dragonsbeard'), ('pyrogenic', 'hellfire_plant'), ('pyrogenic', 'adv_ignus_chili'), ('pyrogenic', 'ignus_chili'), ('epinephrine', 'lasher'), ('epinephrine', 'pinkloom'), ('reactive', 'adv_ignus_chili'), ('reactive', 'blade_tree'), ('reactive', 'boltbulb'), ('reactive', 'ignus_chili'), ('reactive', 'nailery'), ('reactive', 'strangler_vine'), ('reactive', 'tinselbush'), ('regenerative', 'beeflower'), ('regenerative', 'blood_root'), ('regenerative', 'floralyt'), ('regenerative', 'red_flower'), ('regenerative', 'garik_leaf'), ('regenerative', 'heartroot'), ('regenerative', 'little_good_berry'), ('regenerative', 'miracle_grass'), ('regenerative', 'mushroom_seed'), ('regenerative', 'teratomato'), ('regenerative', 'varan_berry_bush'), ('reproductive_boost', 'algae_pod'), ('reproductive_boost', 'micro_bamboo'), ('reproductive_boost', 'beeflower'), ('reproductive_boost', 'bracken_tree'), ('reproductive_boost', 'grey_flower'), ('reproductive_boost', 'spring_flower'), ('reproductive_boost', 'yellow_flower'), ('reproductive_boost', 'lactarius_indigo'), ('resistance', 'banana'), ('resistance', 'carrot'), ('resistance', 'blue_orchid'), ('resistance', 'purple_orchid'), ('resistance', 'black_orchid'), ('resistance', 'garp_berry'), ('resistance', 'grape'), ('resistance', 'potato'), ('resistance', 'quell_stem'), ('resistance', 'slime_glob_bush'), ('resistance', 'talonseed'), ('skeletal_structure', 'boneboo'), ('skeletal_structure', 'green_flower'), ('stealth', 'shadow_root'), ('stealth', 'crystal_plant'), ('stealth', 'fayshroom_spore'), ('stealth', 'gemglow'), ('stealth', 'ghost_mushroom'), ('stealth', 'lumivine'), ('stealth', 'sweet_scoop'), ('stimulant', 'cinnamon_seed'), ('stimulant', 'feathercrown'), ('stimulant', 'hops'), ('stimulant', 'ighant'), ('stimulant', 'sugarcane'), ('nether_touched', 'meatvine_bulb'), ('nether_touched', 'shadow_root'), ('nether_touched', 'tetherhook_weed'), ('nether_touched', 'wretchel');