zf

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

20211110080000_create_all_tables.exs (2205B)

      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.SQL.Repo.Migrations.Create_all_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("zf_file")
     27 
     28 	create table("vf_unit")
     29 	create table("vf_spatial_thing")
     30 	create table("vf_process_specification")
     31 	create table("vf_resource_specification")
     32 	create table("vf_recipe_resource")
     33 	create table("vf_recipe_process")
     34 	create table("vf_recipe_exchange")
     35 	create table("vf_recipe_flow")
     36 	#create table("vf_accounting_scope")
     37 	create table("vf_agent")
     38 	create table("vf_role_behavior")
     39 	create table("vf_agent_relationship_role")
     40 	create table("vf_agent_relationship")
     41 	create table("vf_agreement")
     42 	create table("vf_scenario_definition")
     43 	create table("vf_scenario")
     44 	create table("vf_plan")
     45 	create table("vf_process")
     46 	create table("vf_product_batch")
     47 	create table("vf_economic_resource")
     48 	create table("vf_economic_event")
     49 	create table("vf_appreciation")
     50 	create table("vf_intent")
     51 	create table("vf_commitment")
     52 	create table("vf_fulfillment")
     53 	create table("vf_satisfaction")
     54 	create table("vf_claim")
     55 	create table("vf_settlement")
     56 	create table("vf_proposal")
     57 	create table("vf_proposed_intent")
     58 	create table("vf_proposed_to")
     59 end
     60 end