-
-
Notifications
You must be signed in to change notification settings - Fork 18
/
migration.rb
29 lines (26 loc) · 859 Bytes
/
migration.rb
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
class AddActsAsTaggableTables < ActiveRecord::Migration
def self.up
create_table :tags do |t|
t.column :name, :string
t.column :taggings_count, :integer, :default => 0, :null => false
end
add_index :tags, :name
add_index :tags, :taggings_count
create_table :taggings do |t|
t.column :tag_id, :integer
t.column :taggable_id, :integer
t.column :taggable_type, :string
t.column :user_id, :integer
end
# Find objects for a tag
add_index :taggings, [:tag_id, :taggable_type]
add_index :taggings, [:user_id, :tag_id, :taggable_type]
# Find tags for an object
add_index :taggings, [:taggable_id, :taggable_type]
add_index :taggings, [:user_id, :taggable_id, :taggable_type]
end
def self.down
drop_table :tags
drop_table :taggings
end
end