zf

zenflows testing
git clone https://s.sonu.ch/~srfsh/zf.git
Log | Files | Refs | Submodules | README | LICENSE

20211115074158_fill_vf_event_or_commitment.exs (1302B)

      1 # Zenflows is designed to implement the Valueflows vocabulary,
      2 # written and maintained by srfsh <info@dyne.org>.
      3 # Copyright (C) 2021-2022 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_event_or_commitment do
     19 use Ecto.Migration
     20 
     21 @check """
     22 (event_id IS NULL AND commitment_id IS NOT NULL)
     23 OR
     24 (event_id IS NOT NULL AND commitment_id IS NULL)
     25 """
     26 
     27 def change() do
     28 	alter table("vf_event_or_commitment") do
     29 		add :event_id, references("vf_economic_event")
     30 		add :commitment_id, references("vf_commitment")
     31 		timestamps()
     32 	end
     33 
     34 	create constraint("vf_event_or_commitment", :mutex, check: @check)
     35 end
     36 end