class InitialSchema < ActiveRecord::Migration[4.2]
  def change
    create_table 'articles_tags', id: false, force: true do |t|
      t.integer 'article_id'
      t.integer 'tag_id'
    end

    create_table 'blogs', force: true do |t|
      t.text   'settings'
      t.string 'base_url'
    end

    create_table 'categories', force: true do |t|
      t.string  'name'
      t.integer 'position'
      t.string  'permalink'
      t.text    'keywords'
      t.text    'description'
      t.integer 'parent_id'
    end

    add_index 'categories', ['permalink']

    create_table 'categorizations', force: true do |t|
      t.integer 'article_id'
      t.integer 'category_id'
      t.boolean 'is_primary'
    end

    create_table 'contents', force: true do |t|
      t.string   'type'
      t.string   'title'
      t.string   'author'
      t.text     'body'
      t.text     'extended'
      t.text     'excerpt'
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.integer  'user_id'
      t.string   'permalink'
      t.string   'guid'
      t.integer  'text_filter_id'
      t.text     'whiteboard'
      t.string   'name'
      t.boolean  'published', default: false
      t.boolean  'allow_pings'
      t.boolean  'allow_comments'
      t.datetime 'published_at'
      t.string   'state'
      t.integer  'parent_id'
      t.text     'settings'
      t.string   'post_type', default: 'read'
    end

    add_index 'contents', ['published']
    add_index 'contents', ['text_filter_id']

    create_table 'feedback', force: true do |t|
      t.string   'type'
      t.string   'title'
      t.string   'author'
      t.text     'body'
      t.text     'excerpt'
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.integer  'user_id'
      t.string   'guid'
      t.integer  'text_filter_id'
      t.text     'whiteboard'
      t.integer  'article_id'
      t.string   'email'
      t.string   'url'
      t.string   'ip', limit: 40
      t.string   'blog_name'
      t.boolean  'published', default: false
      t.datetime 'published_at'
      t.string   'state'
      t.boolean  'status_confirmed'
      t.string   'user_agent'
    end

    add_index 'feedback', ['article_id']
    add_index 'feedback', ['text_filter_id']

    create_table 'page_caches', force: true do |t|
      t.string 'name'
    end

    add_index 'page_caches', ['name']

    create_table 'pings', force: true do |t|
      t.integer  'article_id'
      t.string   'url'
      t.datetime 'created_at'
    end

    add_index 'pings', ['article_id']

    create_table 'post_types', force: true do |t|
      t.string 'name'
      t.string 'permalink'
      t.string 'description'
    end

    create_table 'profiles', force: true do |t|
      t.string 'label'
      t.string 'nicename'
      t.text   'modules'
    end

    create_table 'profiles_rights', id: false, force: true do |t|
      t.integer 'profile_id'
      t.integer 'right_id'
    end

    create_table 'redirections', force: true do |t|
      t.integer 'content_id'
      t.integer 'redirect_id'
    end

    create_table 'redirects', force: true do |t|
      t.string   'from_path'
      t.string   'to_path'
      t.string   'origin'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    create_table 'resources', force: true do |t|
      t.integer  'size'
      t.string   'upload'
      t.string   'mime'
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.integer  'article_id'
      t.boolean  'itunes_metadata'
      t.string   'itunes_author'
      t.string   'itunes_subtitle'
      t.integer  'itunes_duration'
      t.text     'itunes_summary'
      t.string   'itunes_keywords'
      t.string   'itunes_category'
      t.boolean  'itunes_explicit'
    end

    create_table 'sidebars', force: true do |t|
      t.integer 'active_position'
      t.text    'config'
      t.integer 'staged_position'
      t.string  'type'
    end

    create_table 'sitealizer', force: true do |t|
      t.string   'path'
      t.string   'ip'
      t.string   'referer'
      t.string   'language'
      t.string   'user_agent'
      t.datetime 'created_at'
      t.date     'created_on'
    end

    create_table 'tags', force: true do |t|
      t.string   'name'
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.string   'display_name'
    end

    create_table 'text_filters', force: true do |t|
      t.string 'name'
      t.string 'description'
      t.string 'markup'
      t.text   'filters'
      t.text   'params'
    end

    create_table 'triggers', force: true do |t|
      t.integer  'pending_item_id'
      t.string   'pending_item_type'
      t.datetime 'due_at'
      t.string   'trigger_method'
    end

    create_table 'users', force: true do |t|
      t.string   'login'
      t.string   'password'
      t.text     'email'
      t.text     'name'
      t.boolean  'notify_via_email'
      t.boolean  'notify_on_new_articles'
      t.boolean  'notify_on_comments'
      t.integer  'profile_id'
      t.string   'remember_token'
      t.datetime 'remember_token_expires_at'
      t.string   'text_filter_id',            default: '1'
      t.string   'state',                     default: 'active'
      t.datetime 'last_connection'
      t.text     'settings'
      t.integer  'resource_id'
    end
  end
end