diff options
author | Uģis Ozols <ugis.ozolss@gmail.com> | 2012-11-23 15:16:46 +0200 |
---|---|---|
committer | Uģis Ozols <ugis.ozolss@gmail.com> | 2012-11-23 15:17:07 +0200 |
commit | f906ef024ee39c31148edb49c6511f007735ce5a (patch) | |
tree | 987ea38a6bd57288ec66a2ed3cfde85e130b7241 /db/migrate/20110803223522_create_blog_structure.rb | |
parent | 788f9579c341f72d4bc2c34230deb7f5f6b6b06e (diff) | |
download | refinerycms-blog-f906ef024ee39c31148edb49c6511f007735ce5a.tar.gz refinerycms-blog-f906ef024ee39c31148edb49c6511f007735ce5a.tar.bz2 refinerycms-blog-f906ef024ee39c31148edb49c6511f007735ce5a.zip |
Squash migrations.
This also makes sure tags and taggings tables doesn't exist before
trying to create them.
Diffstat (limited to 'db/migrate/20110803223522_create_blog_structure.rb')
-rw-r--r-- | db/migrate/20110803223522_create_blog_structure.rb | 51 |
1 files changed, 39 insertions, 12 deletions
diff --git a/db/migrate/20110803223522_create_blog_structure.rb b/db/migrate/20110803223522_create_blog_structure.rb index 010102f..a59b90f 100644 --- a/db/migrate/20110803223522_create_blog_structure.rb +++ b/db/migrate/20110803223522_create_blog_structure.rb @@ -1,17 +1,26 @@ class CreateBlogStructure < ActiveRecord::Migration def up - create_table Refinery::Blog::Post.table_name, :id => true do |t| + create_table :refinery_blog_posts do |t| t.string :title t.text :body t.boolean :draft t.datetime :published_at + t.integer :user_id + t.string :slug + t.string :custom_url + t.text :custom_teaser + t.string :source_url + t.string :source_url_title + t.integer :access_count, :default => 0 t.timestamps end - add_index Refinery::Blog::Post.table_name, :id + add_index :refinery_blog_posts, :id + add_index :refinery_blog_posts, :access_count + add_index :refinery_blog_posts, :slug - create_table Refinery::Blog::Comment.table_name, :id => true do |t| + create_table :refinery_blog_comments do |t| t.integer :blog_post_id t.boolean :spam t.string :name @@ -21,21 +30,36 @@ class CreateBlogStructure < ActiveRecord::Migration t.timestamps end - add_index Refinery::Blog::Comment.table_name, :id + add_index :refinery_blog_comments, :id - create_table Refinery::Blog::Category.table_name, :id => true do |t| + create_table :refinery_blog_categories do |t| t.string :title + t.string :slug t.timestamps end - add_index Refinery::Blog::Category.table_name, :id + add_index :refinery_blog_categories, :id + add_index :refinery_blog_categories, :slug - create_table Refinery::Categorization.table_name, :id => true do |t| + create_table :refinery_blog_categories_blog_posts do |t| + t.primary_key :id t.integer :blog_category_id t.integer :blog_post_id end - add_index Refinery::Categorization.table_name, [:blog_category_id, :blog_post_id], :name => 'index_blog_categories_blog_posts_on_bc_and_bp' + add_index :refinery_blog_categories_blog_posts, [:blog_category_id, :blog_post_id], :name => 'index_blog_categories_blog_posts_on_bc_and_bp' + + Refinery::Blog::Post.create_translation_table!({ + :body => :text, + :custom_teaser => :text, + :custom_url => :string, + :slug => :string, + :title => :string + }) + Refinery::Blog::Category.create_translation_table!({ + :title => :string, + :slug => :string + }) end def down @@ -43,10 +67,13 @@ class CreateBlogStructure < ActiveRecord::Migration Refinery::Page.delete_all({:link_url => "/blog"}) - drop_table Refinery::Blog::Post.table_name - drop_table Refinery::Blog::Comment.table_name - drop_table Refinery::Blog::Category.table_name - drop_table Refinery::Categorization.table_name + drop_table :refinery_blog_posts + drop_table :refinery_blog_comments + drop_table :refinery_blog_categories + drop_table :refinery_blog_categories_blog_posts + + Refinery::Blog::Post.drop_translation_table! + Refinery::Blog::Category.drop_translation_table! end end |