florian.berthold
896b364b09
Backend: add 6 new columns to Species and CreateSpecies structs, update INSERT/UPDATE queries, add migration 010. Frontend: add fields to Species type, use pick_desc() for language-aware display in species detail and cultivar species-info card.
7 lines
396 B
SQL
7 lines
396 B
SQL
ALTER TABLE species ADD COLUMN IF NOT EXISTS food_uses_de TEXT;
|
|
ALTER TABLE species ADD COLUMN IF NOT EXISTS food_uses_en TEXT;
|
|
ALTER TABLE species ADD COLUMN IF NOT EXISTS medicinal_uses_de TEXT;
|
|
ALTER TABLE species ADD COLUMN IF NOT EXISTS medicinal_uses_en TEXT;
|
|
ALTER TABLE species ADD COLUMN IF NOT EXISTS other_uses_de TEXT;
|
|
ALTER TABLE species ADD COLUMN IF NOT EXISTS other_uses_en TEXT;
|