20211111111357_fill_vf_recipe_process.exs (1527B)
1 # Zenflows is designed to implement the Valueflows vocabulary, 2 # written and maintained by srfsh <info@dyne.org>. 3 # Copyright (C) 2021-2023 Dyne.org foundation <foundation@dyne.org>. 4 # 5 # This program is free software: you can redistribute it and/or modify 6 # it under the terms of the GNU Affero General Public License as published by 7 # the Free Software Foundation, either version 3 of the License, or 8 # (at your option) any later version. 9 # 10 # This program is distributed in the hope that it will be useful, 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 # GNU Affero General Public License for more details. 14 # 15 # You should have received a copy of the GNU Affero General Public License 16 # along with this program. If not, see <https://www.gnu.org/licenses/>. 17 18 defmodule Zenflows.DB.Repo.Migrations.Fill_vf_recipe_process do 19 use Ecto.Migration 20 21 @check """ 22 (has_duration_unit_type IS NULL AND has_duration_numeric_duration IS NULL) 23 OR 24 (has_duration_unit_type IS NOT NULL AND has_duration_numeric_duration IS NOT NULL) 25 """ 26 27 def change() do 28 alter table("vf_recipe_process") do 29 add :name, :text, null: false 30 add :note, :text 31 add :process_conforms_to_id, references("vf_process_specification"), null: false 32 add :process_classified_as, {:array, :text} 33 add :has_duration_unit_type, :vf_time_unit 34 add :has_duration_numeric_duration, :decimal 35 timestamps() 36 end 37 38 create constraint("vf_recipe_process", :has_duration, check: @check) 39 end 40 end