cirandas.net

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

class CreateTeamsPluginTeams < ActiveRecord::Migration

  def change
    create_table :teams_plugin_teams do |t|
      t.string :type
      t.integer :context_id
      t.string :context_type
      t.integer :code
      t.string :name
      t.text :description
    end
    add_index :teams_plugin_teams, [:context_id]
    add_index :teams_plugin_teams, [:context_type]
    add_index :teams_plugin_teams, [:context_id, :context_type]
    add_index :teams_plugin_teams, [:code]

    create_table :teams_plugin_members do |t|
      t.integer :team_id
      t.integer :profile_id
    end
    add_index :teams_plugin_members, [:team_id]
    add_index :teams_plugin_members, [:profile_id]

    add_foreign_key :teams_plugin_members, :teams_plugin_teams, column: :team_id

    create_table :teams_plugin_works do |t|
      t.integer :team_id
      t.integer :work_id
      t.string :work_type
    end
    add_index :teams_plugin_works, [:team_id]
    add_index :teams_plugin_works, [:work_id, :work_type]
  end

end