From f087c23c8600fe197d3a59f4a0cd839754459b37 Mon Sep 17 00:00:00 2001
From: Harald Eilertsen <haraldei@anduin.net>
Date: Fri, 25 Jan 2013 21:53:05 +0100
Subject: Initial commit.

---
 ...eate_refinerycms_pages_schema.refinery_pages.rb | 59 ++++++++++++++++++++++
 1 file changed, 59 insertions(+)
 create mode 100644 db/migrate/20130124232355_create_refinerycms_pages_schema.refinery_pages.rb

(limited to 'db/migrate/20130124232355_create_refinerycms_pages_schema.refinery_pages.rb')

diff --git a/db/migrate/20130124232355_create_refinerycms_pages_schema.refinery_pages.rb b/db/migrate/20130124232355_create_refinerycms_pages_schema.refinery_pages.rb
new file mode 100644
index 0000000..8a8f425
--- /dev/null
+++ b/db/migrate/20130124232355_create_refinerycms_pages_schema.refinery_pages.rb
@@ -0,0 +1,59 @@
+# This migration comes from refinery_pages (originally 20100913234708)
+class CreateRefinerycmsPagesSchema < ActiveRecord::Migration
+  def up
+    create_table :refinery_page_parts do |t|
+      t.integer  :refinery_page_id
+      t.string   :title
+      t.text     :body
+      t.integer  :position
+
+      t.timestamps
+    end
+
+    add_index :refinery_page_parts, :id
+    add_index :refinery_page_parts, :refinery_page_id
+
+    create_table :refinery_pages do |t|
+      t.integer   :parent_id
+      t.string    :path
+      t.string    :slug
+      t.boolean   :show_in_menu,        :default => true
+      t.string    :link_url
+      t.string    :menu_match
+      t.boolean   :deletable,           :default => true
+      t.boolean   :draft,               :default => false
+      t.boolean   :skip_to_first_child, :default => false
+      t.integer   :lft
+      t.integer   :rgt
+      t.integer   :depth
+      t.string    :view_template
+      t.string    :layout_template
+
+      t.timestamps
+    end
+
+    add_index :refinery_pages, :depth
+    add_index :refinery_pages, :id
+    add_index :refinery_pages, :lft
+    add_index :refinery_pages, :parent_id
+    add_index :refinery_pages, :rgt
+
+    Refinery::PagePart.create_translation_table!({
+      :body => :text
+    })
+
+    Refinery::Page.create_translation_table!({
+      :title => :string,
+      :custom_slug => :string,
+      :menu_title => :string,
+      :slug => :string
+    })
+  end
+
+  def down
+    drop_table :refinery_page_parts
+    drop_table :refinery_pages
+    Refinery::PagePart.drop_translation_table!
+    Refinery::Page.drop_translation_table!
+  end
+end
-- 
cgit v1.2.3