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