Sha256: 67ee2600c0f478ffb00d7c08a7bbf322edf1a5349910af5ca77c782a108798fc

Contents?: true

Size: 1.51 KB

Versions: 44

Compression:

Stored size: 1.51 KB

Contents

Sequel.migration do
  up do
    create_table(:dynflow_execution_plans) do
      column :uuid, String, primary_key: true, size: 36, fixed: true
      index :uuid, :unique => true

      column :data, String, text: true

      column :state, String
      column :result, String
      column :started_at, Time
      column :ended_at, Time
      column :real_time, Float
      column :execution_time, Float
    end

    create_table(:dynflow_actions) do
      foreign_key :execution_plan_uuid, :dynflow_execution_plans, type: String, size: 36, fixed: true
      index :execution_plan_uuid
      column :id, Fixnum
      primary_key [:execution_plan_uuid, :id]
      index [:execution_plan_uuid, :id], :unique => true

      column :data, String, text: true
    end

    create_table(:dynflow_steps) do
      foreign_key :execution_plan_uuid, :dynflow_execution_plans, type: String, size: 36, fixed: true
      index :execution_plan_uuid
      column :id, Fixnum
      primary_key [:execution_plan_uuid, :id]
      index [:execution_plan_uuid, :id], :unique => true
      column :action_id, Fixnum
      foreign_key [:execution_plan_uuid, :action_id], :dynflow_actions
      index [:execution_plan_uuid, :action_id]

      column :data, String, text: true

      column :state, String
      column :started_at, Time
      column :ended_at, Time
      column :real_time, Float
      column :execution_time, Float
    end
  end

  down do
    drop_table(:dynflow_steps)
    drop_table(:dynflow_actions)
    drop_table(:dynflow_execution_plans)
  end
end

Version data entries

44 entries across 44 versions & 1 rubygems

Version Path
dynflow-0.8.24 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.23 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.22 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.21 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.20 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.19 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.18 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.17 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.16 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.15 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.14 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.13 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.12 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.11 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.10 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.9 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.8 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.7 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.6 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb
dynflow-0.8.5 lib/dynflow/persistence_adapters/sequel_migrations/001_initial.rb