20211110080000_create_all_vf_tables.exs (2218B)
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.SQL.Repo.Migrations.Create_vf_tables do 19 # New tables can be added on top of these as anoter migration files. 20 # The point of this migration is to just prevent circular references. 21 use Ecto.Migration 22 23 def change() do 24 execute "CREATE EXTENSION citext", "DROP EXTENSION citext" 25 26 create table("vf_unit") 27 create table("vf_spatial_thing") 28 create table("vf_process_specification") 29 create table("vf_resource_specification") 30 create table("vf_recipe_resource") 31 create table("vf_recipe_process") 32 create table("vf_recipe_exchange") 33 create table("vf_recipe_flow") 34 #create table("vf_accounting_scope") 35 create table("vf_agent") 36 create table("vf_role_behavior") 37 create table("vf_agent_relationship_role") 38 create table("vf_agent_relationship") 39 create table("vf_agreement") 40 create table("vf_scenario_definition") 41 create table("vf_scenario") 42 create table("vf_plan") 43 create table("vf_process") 44 create table("vf_product_batch") 45 create table("vf_economic_resource") 46 create table("vf_economic_event") 47 create table("vf_appreciation") 48 create table("vf_intent") 49 create table("vf_commitment") 50 create table("vf_fulfillment") 51 create table("vf_event_or_commitment") 52 create table("vf_satisfaction") 53 create table("vf_claim") 54 create table("vf_settlement") 55 create table("vf_proposal") 56 create table("vf_proposed_intent") 57 create table("vf_proposed_to") 58 end 59 end