Skip to content

Instantly share code, notes, and snippets.

@queertypes

queertypes/gene_extraction.sql

Created September 5, 2017 18:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save queertypes/25d1279be242d3de698b06134e2a8eff to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save queertypes/25d1279be242d3de698b06134e2a8eff to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. queertypes created this gist Sep 5, 2017.
    399 changes: 399 additions & 0 deletions gene_extraction.sql
    View file
    Original 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');