class CreateEffectivePages < ActiveRecord::Migration[4.2]
  def self.up
    create_table <%= @pages_table_name %> do |t|
      t.integer :page_banner_id

      t.string :title
      t.string :meta_description

      t.boolean :draft, default: false

      t.string :layout, default: 'application'
      t.string :template

      t.string :slug

      t.boolean :authenticate_user, default: false
      t.integer :roles_mask, default: 0

      t.integer :menu_parent_id

      t.boolean :menu, default: false

      t.string :menu_name
      t.string :menu_group

      t.string :menu_title
      t.string :menu_url
      t.integer :menu_position

      t.boolean :banner, default: false
      t.boolean :banner_random, default: false

      t.datetime :updated_at
      t.datetime :created_at
    end

    add_index <%= @pages_table_name %>, :slug, :unique => true

    create_table <%= @page_banners_table_name %> do |t|
      t.string :name
      t.string :caption

      t.timestamps
    end

    add_index <%= @page_banners_table_name %>, :name, :unique => true

    create_table <%= @page_sections_table_name %> do |t|
      t.string :name
      t.text :hint

      t.string :title
      t.string :caption

      t.string :link_label
      t.string :link_url

      t.datetime :updated_at
      t.datetime :created_at
    end

    add_index <%= @page_sections_table_name %>, :name, :unique => true

    create_table <%= @carousel_items_table_name %> do |t|
      t.string :carousel

      t.string :title
      t.string :caption

      t.string :link_label
      t.string :link_url

      t.integer :position

      t.timestamps
    end

    create_table <%= @alerts_table_name %>, if_not_exists: true do |t|
      t.boolean :enabled

      t.timestamps
    end

    create_table <%= @permalinks_table_name %>, if_not_exists: true do |t|
      t.string :title
      t.string :slug
      t.string :url
      t.text   :summary

      t.timestamps
    end

    create_table <%= @tags_table_name %>, if_not_exists: true do |t|
      t.string :name

      t.timestamps
    end

    create_table <%= @taggings_table_name %>, if_not_exists: true do |t|
      t.integer :tag_id
      t.integer :taggable_id
      t.string :taggable_type

      t.timestamps
    end

  end

  def self.down
    drop_table <%= @pages_table_name %>
    drop_table <%= @page_banners_table_name %>
    drop_table <%= @page_sections_table_name %>
    drop_table <%= @carousel_items_table_name %>
    drop_table <%= @alerts_table_name %>
    drop_table <%= @permalinks_table_name %>
    drop_table <%= @tags_table_name %>
    drop_table <%= @taggings_table_name %>
  end

end