From 49c38f208b8a05cee49400ffababc49dfc431daa Mon Sep 17 00:00:00 2001
From: Philip Arndt <p@arndt.io>
Date: Sun, 14 Jul 2013 04:37:18 +1200
Subject: Revert f906ef0 but maintain table name improvements

---
 db/migrate/20110803223522_create_blog_structure.rb | 39 ++++------------------
 1 file changed, 6 insertions(+), 33 deletions(-)

(limited to 'db/migrate/20110803223522_create_blog_structure.rb')

diff --git a/db/migrate/20110803223522_create_blog_structure.rb b/db/migrate/20110803223522_create_blog_structure.rb
index 3be7eee..37f4bd7 100644
--- a/db/migrate/20110803223522_create_blog_structure.rb
+++ b/db/migrate/20110803223522_create_blog_structure.rb
@@ -1,26 +1,17 @@
 class CreateBlogStructure < ActiveRecord::Migration
 
   def up
-    create_table :refinery_blog_posts do |t|
+    create_table :refinery_blog_posts, :id => true 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_posts, :id
-    add_index :refinery_blog_posts, :access_count
-    add_index :refinery_blog_posts, :slug
 
-    create_table :refinery_blog_comments do |t|
+    create_table :refinery_blog_comments, :id => true do |t|
       t.integer :blog_post_id
       t.boolean :spam
       t.string :name
@@ -33,48 +24,30 @@ class CreateBlogStructure < ActiveRecord::Migration
     add_index :refinery_blog_comments, :id
     add_index :refinery_blog_comments, :blog_post_id
 
-    create_table :refinery_blog_categories do |t|
+    create_table :refinery_blog_categories, :id => true do |t|
       t.string :title
-      t.string :slug
       t.timestamps
     end
 
     add_index :refinery_blog_categories, :id
-    add_index :refinery_blog_categories, :slug
 
-    create_table :refinery_blog_categories_blog_posts do |t|
-      t.primary_key :id
+    create_table :refinery_blog_categories_blog_posts, :id => true do |t|
       t.integer :blog_category_id
       t.integer :blog_post_id
     end
 
     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
-    Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"})
+    Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"}) if defined?(Refinery::UserPlugin)
 
-    Refinery::Page.delete_all({:link_url => "/blog"})
+    Refinery::Page.delete_all({:link_url => "/blog"}) if defined?(Refinery::Page)
 
     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
-- 
cgit v1.2.3