Starbound, Frackin' Universe: Gene Extraction SQL

gene_extraction.sql

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