make_flaggable/spec/schema.rb at 2b4621fecd5d969de7944e75549915054c3c0a69 · medihack/make_flaggable · GitHub

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
36
37
38
39
40
ActiveRecord::Schema.define :version => 0 do
  create_table :flaggable_models, :force => true do |t|
    t.string :name
    t.integer :flaggings_count, default: 0
  end

  create_table :flagger_models, :force => true do |t|
    t.string :name
    t.integer :flaggings_count, default: 0
  end

  create_table :flagger_once_models, :force => true do |t|
    t.string :name
    t.integer :flaggings_count, default: 0
  end

  create_table :invalid_flaggable_models, :force => true do |t|
    t.string :name
    t.integer :flaggings_count, default: 0
  end

  create_table :another_flaggable_models, :force => true do |t|
    t.string :name
    t.integer :flaggings_count, default: 0
  end


  create_table :flaggings, :force => true do |t|
     t.string :flaggable_type
     t.integer :flaggable_id
     t.string :flagger_type
     t.integer :flagger_id
     t.text :reason

     t.timestamps
  end

  add_index :flaggings, [:flaggable_type, :flaggable_id]
  add_index :flaggings, [:flagger_type, :flagger_id, :flaggable_type, :flaggable_id], :name => "access_flaggings"
end