diff options
| author | hukl <contact@smyck.org> | 2009-08-16 00:38:27 +0200 |
|---|---|---|
| committer | hukl <contact@smyck.org> | 2009-08-16 00:38:27 +0200 |
| commit | 88a34849c415688846659a350d634d9ac566024f (patch) | |
| tree | 20ffc3a2804eaa6a89b0c933f5c0a91d1934fcd8 /db | |
| parent | 8c202e546b43298b1ea4d2ad8cf378aaa4647a51 (diff) | |
consolidated migration
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20090815220058_migrate_tagging_tables.rb | 29 |
1 files changed, 10 insertions, 19 deletions
diff --git a/db/migrate/20090815220058_migrate_tagging_tables.rb b/db/migrate/20090815220058_migrate_tagging_tables.rb index 59e054f..e28a16e 100644 --- a/db/migrate/20090815220058_migrate_tagging_tables.rb +++ b/db/migrate/20090815220058_migrate_tagging_tables.rb | |||
| @@ -3,27 +3,18 @@ class MigrateTaggingTables < ActiveRecord::Migration | |||
| 3 | add_column :tags, :taggings_count, :integer, :default => 0, :null => false | 3 | add_column :tags, :taggings_count, :integer, :default => 0, :null => false |
| 4 | add_column :taggings, :user_id, :integer | 4 | add_column :taggings, :user_id, :integer |
| 5 | 5 | ||
| 6 | add_index :tags, :name | 6 | add_index :tags, :name |
| 7 | add_index :tags, :taggings_count | 7 | add_index :tags, :taggings_count |
| 8 | 8 | add_index :taggings, [:user_id, :tag_id, :taggable_type] | |
| 9 | Find objects for a tag | 9 | add_index :taggings, [:user_id, :taggable_id, :taggable_type] |
| 10 | add_index :taggings, [:user_id, :tag_id, :taggable_type] | ||
| 11 | |||
| 12 | Find tags for an object | ||
| 13 | add_index :taggings, [:user_id, :taggable_id, :taggable_type] | ||
| 14 | end | 10 | end |
| 15 | 11 | ||
| 16 | def self.down | 12 | def self.down |
| 17 | remove_column :tags, :taggings_count | 13 | remove_column :tags, :taggings_count |
| 18 | remove_column :taggings, :user_id | 14 | remove_column :taggings, :user_id |
| 19 | 15 | remove_index :tags, :name | |
| 20 | remove_index :tags, :name | 16 | remove_index :tags, :taggings_count |
| 21 | remove_index :tags, :taggings_count | 17 | remove_index :taggings, [:user_id, :tag_id, :taggable_type] |
| 22 | 18 | remove_index :taggings, [:user_id, :taggable_id, :taggable_type] | |
| 23 | # Find objects for a tag | ||
| 24 | remove_index :taggings, [:user_id, :tag_id, :taggable_type] | ||
| 25 | |||
| 26 | # Find tags for an object | ||
| 27 | remove_index :taggings, [:user_id, :taggable_id, :taggable_type] | ||
| 28 | end | 19 | end |
| 29 | end | 20 | end |
