schema.rb
上传用户:netsea168
上传日期:2022-07-22
资源大小:4652k
文件大小:7k
- # This file is auto-generated from the current state of the database. Instead of editing this file,
- # please use the migrations feature of Active Record to incrementally modify your database, and
- # then regenerate this schema definition.
- #
- # Note that this schema.rb definition is the authoritative source for your database schema. If you need
- # to create the application database on another system, you should be using db:schema:load, not running
- # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
- # you'll amass, the slower it'll run and the greater likelihood for issues).
- #
- # It's strongly recommended to check this file into your version control system.
- ActiveRecord::Schema.define(:version => 88) do
- 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 "cache_informations", :force => true do |t|
- t.string "path"
- t.datetime "created_at"
- t.datetime "updated_at"
- end
- add_index "cache_informations", ["path"], :name => "index_cache_informations_on_path"
- create_table "categories", :force => true do |t|
- t.string "name"
- t.integer "position", :default => 0, :null => false
- t.string "permalink"
- t.text "keywords"
- t.text "description"
- t.integer "parent_id"
- end
- add_index "categories", ["permalink"], :name => "categories_permalink_index"
- 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.string "keywords"
- 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"
- end
- add_index "contents", ["published"], :name => "contents_published_index"
- add_index "contents", ["text_filter_id"], :name => "contents_text_filter_id_index"
- 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"
- end
- add_index "feedback", ["article_id"], :name => "feedback_article_id_index"
- add_index "feedback", ["text_filter_id"], :name => "feedback_text_filter_id_index"
- create_table "notifications", :force => true do |t|
- t.integer "content_id"
- t.integer "user_id"
- t.datetime "created_at"
- t.datetime "updated_at"
- end
- create_table "page_caches", :force => true do |t|
- t.string "name", :null => false
- end
- add_index "page_caches", ["name"], :name => "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"], :name => "article_id"
- create_table "profiles", :force => true do |t|
- t.string "label"
- t.string "nicename"
- t.text "modules"
- end
- create_table "profiles_rights", :force => true do |t|
- t.integer "profile_id"
- t.integer "right_id"
- end
- create_table "redirects", :force => true do |t|
- t.string "from_path"
- t.string "to_path"
- end
- create_table "resources", :force => true do |t|
- t.integer "size"
- t.string "filename"
- 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 "rights", :force => true do |t|
- t.string "name"
- t.string "description"
- end
- create_table "sidebars", :force => true do |t|
- t.integer "active_position"
- t.text "config"
- t.integer "staged_position"
- t.datetime "updated_at"
- 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 "text_link_ads_rss", :force => true do |t|
- t.string "html", :limit => 1024
- t.integer "post_id"
- 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", :limit => 80
- t.string "password", :limit => 40
- t.string "name", :limit => 80
- t.string "email", :limit => 80
- t.boolean "notify_via_email"
- t.boolean "notify_on_new_articles"
- t.boolean "notify_on_comments"
- t.boolean "notify_watch_my_articles"
- t.string "jabber"
- t.integer "profile_id"
- t.string "remember_token"
- t.datetime "remember_token_expires_at"
- t.string "text_filter_id", :default => "1"
- t.string "editor", :default => "simple"
- t.string "state", :default => "active"
- t.string "firstname"
- t.string "lastname"
- t.string "nickname"
- t.string "url"
- t.string "msn"
- t.string "aim"
- t.string "yahoo"
- t.string "twitter"
- t.text "description"
- t.boolean "show_url"
- t.boolean "show_msn"
- t.boolean "show_aim"
- t.boolean "show_yahoo"
- t.boolean "show_twitter"
- t.boolean "show_jabber"
- t.datetime "last_connection"
- end
- add_index "users", ["login"], :name => "login", :unique => true
- end