test/rails_root/db/schema.rb in muck-raker-0.1.15 vs test/rails_root/db/schema.rb in muck-raker-0.1.16
- old
+ new
@@ -7,103 +7,305 @@
# 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 => 20090704220120) do
+ActiveRecord::Schema.define(:version => 20090723050510) do
- create_table "activities", :force => true do |t|
- t.integer "item_id"
- t.string "item_type"
- t.string "template"
- t.integer "source_id"
- t.string "source_type"
- t.text "content"
+ create_table "action_types", :force => true do |t|
+ t.string "action_type"
+ t.integer "weight"
+ end
+
+ create_table "aggregation_feeds", :force => true do |t|
+ t.integer "aggregation_id"
+ t.integer "feed_id"
+ end
+
+ add_index "aggregation_feeds", ["aggregation_id"], :name => "index_aggregation_feeds_on_aggregation_id"
+ add_index "aggregation_feeds", ["feed_id"], :name => "index_aggregation_feeds_on_feed_id"
+
+ create_table "aggregations", :force => true do |t|
+ t.string "name"
t.string "title"
- t.boolean "is_status_update", :default => false
- t.boolean "is_public", :default => true
+ t.text "description"
+ t.text "top_tags"
+ t.integer "user_id"
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "activities", ["item_id", "item_type"], :name => "index_activities_on_item_id_and_item_type"
+ add_index "aggregations", ["user_id"], :name => "index_aggregations_on_user_id"
- create_table "activity_feeds", :force => true do |t|
- t.integer "activity_id"
- t.integer "ownable_id"
- t.string "ownable_type"
+ create_table "attentions", :force => true do |t|
+ t.integer "attentionable_id"
+ t.string "attentionable_type"
+ t.integer "entry_id"
+ t.string "action_type"
+ t.float "weight"
end
- add_index "activity_feeds", ["activity_id"], :name => "index_activity_feeds_on_activity_id"
- add_index "activity_feeds", ["ownable_id", "ownable_type"], :name => "index_activity_feeds_on_ownable_id_and_ownable_type"
+ create_table "clicks", :force => true do |t|
+ t.integer "recommendation_id"
+ t.datetime "when", :null => false
+ t.string "referrer", :limit => 2083
+ t.string "requester"
+ t.string "user_agent", :limit => 2083
+ end
- create_table "content_permissions", :force => true do |t|
- t.integer "content_id"
- t.integer "user_id"
- t.datetime "created_at"
- t.datetime "updated_at"
+ add_index "clicks", ["recommendation_id"], :name => "index_clicks_on_recommendation_id"
+ add_index "clicks", ["referrer"], :name => "index_clicks_on_referrer"
+ add_index "clicks", ["requester"], :name => "index_clicks_on_requester"
+ add_index "clicks", ["user_agent"], :name => "index_clicks_on_user_agent"
+ add_index "clicks", ["when"], :name => "index_clicks_on_when"
+
+ create_table "countries", :force => true do |t|
+ t.string "name", :limit => 128, :default => "", :null => false
+ t.string "abbreviation", :limit => 3, :default => "", :null => false
+ t.integer "sort", :default => 1000, :null => false
end
- add_index "content_permissions", ["content_id", "user_id"], :name => "index_content_permissions_on_content_id_and_user_id"
+ add_index "countries", ["abbreviation"], :name => "index_countries_on_abbreviation"
+ add_index "countries", ["name"], :name => "index_countries_on_name"
- create_table "content_translations", :force => true do |t|
- t.integer "content_id"
- t.string "title"
- t.text "body"
- t.string "locale"
- t.boolean "user_edited"
+ create_table "entries", :force => true do |t|
+ t.integer "feed_id", :null => false
+ t.string "permalink", :limit => 2083, :default => "", :null => false
+ t.string "author", :limit => 2083
+ t.text "title", :null => false
+ t.text "description"
+ t.text "content"
+ t.boolean "unique_content", :default => false
+ t.datetime "published_at", :null => false
+ t.datetime "entry_updated_at"
+ t.datetime "harvested_at"
+ t.string "oai_identifier", :limit => 2083
+ t.integer "language_id"
+ t.string "direct_link", :limit => 2083
+ t.datetime "indexed_at", :default => '1971-01-01 01:01:01', :null => false
+ t.datetime "relevance_calculated_at", :default => '1971-01-01 01:01:01', :null => false
+ t.text "popular"
+ t.text "relevant"
+ t.text "other"
+ t.string "grain_size", :default => "unknown"
+ end
+
+ add_index "entries", ["direct_link"], :name => "index_entries_on_direct_link"
+ add_index "entries", ["feed_id"], :name => "index_entries_on_feed_id"
+ add_index "entries", ["grain_size"], :name => "index_entries_on_grain_size"
+ add_index "entries", ["indexed_at"], :name => "index_entries_on_indexed_at"
+ add_index "entries", ["language_id"], :name => "index_entries_on_language_id"
+ add_index "entries", ["oai_identifier"], :name => "index_entries_on_oai_identifier"
+ add_index "entries", ["permalink"], :name => "index_entries_on_permalink"
+ add_index "entries", ["published_at"], :name => "index_entries_on_published_at"
+ add_index "entries", ["relevance_calculated_at"], :name => "index_entries_on_relevance_calculated_at"
+
+ create_table "entries_subjects", :id => false, :force => true do |t|
+ t.integer "subject_id", :default => 0, :null => false
+ t.integer "entry_id", :default => 0, :null => false
+ t.boolean "autogenerated", :default => false
+ end
+
+ add_index "entries_subjects", ["autogenerated"], :name => "index_entries_subjects_on_autogenerated"
+ add_index "entries_subjects", ["entry_id"], :name => "index_entries_subjects_on_entry_id"
+ add_index "entries_subjects", ["subject_id"], :name => "index_entries_subjects_on_subject_id"
+
+ create_table "entries_users", :force => true do |t|
+ t.integer "entry_id", :null => false
+ t.integer "user_id", :default => 0
+ t.boolean "clicked_through", :default => false
t.datetime "created_at"
- t.datetime "updated_at"
end
- add_index "content_translations", ["content_id"], :name => "index_content_translations_on_content_id"
- add_index "content_translations", ["locale"], :name => "index_content_translations_on_locale"
+ add_index "entries_users", ["entry_id", "user_id"], :name => "index_entries_users_on_entry_id_and_user_id"
+ add_index "entries_users", ["entry_id"], :name => "index_entries_users_on_entry_id"
+ add_index "entries_users", ["user_id"], :name => "index_entries_users_on_user_id"
- create_table "contents", :force => true do |t|
- t.integer "creator_id"
- t.string "title"
- t.text "body"
- t.string "locale"
- t.text "body_raw"
- t.integer "contentable_id"
- t.string "contentable_type"
- t.integer "parent_id"
- t.integer "lft"
- t.integer "rgt"
- t.boolean "is_public"
- t.string "state"
+ create_table "entry_images", :force => true do |t|
+ t.integer "entry_id"
+ t.string "uri", :limit => 2083
+ t.string "link", :limit => 2083
+ t.string "alt"
+ t.string "title"
+ t.integer "width"
+ t.integer "height"
+ end
+
+ add_index "entry_images", ["entry_id"], :name => "index_entry_images_on_entry_id"
+
+ create_table "feed_parents", :force => true do |t|
+ t.integer "feed_id"
+ t.integer "ownable_id"
+ t.string "ownable_type"
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "contents", ["creator_id"], :name => "index_contents_on_creator_id"
- add_index "contents", ["parent_id"], :name => "index_contents_on_parent_id"
+ add_index "feed_parents", ["feed_id"], :name => "index_feed_parents_on_feed_id"
+ add_index "feed_parents", ["ownable_id", "ownable_type"], :name => "index_feed_parents_on_ownable_id_and_ownable_type"
- create_table "friends", :force => true do |t|
- t.integer "inviter_id"
- t.integer "invited_id"
- t.integer "status", :default => 0
+ create_table "feeds", :force => true do |t|
+ t.string "uri", :limit => 2083
+ t.string "display_uri", :limit => 2083
+ t.string "title", :limit => 1000
+ t.string "short_title", :limit => 100
+ t.text "description"
+ t.string "tag_filter", :limit => 1000
+ t.text "top_tags"
+ t.integer "priority", :default => 10
+ t.integer "status", :default => 1
+ t.datetime "last_requested_at"
+ t.datetime "last_harvested_at"
+ t.integer "harvest_interval", :default => 86400
+ t.integer "failed_requests", :default => 0
+ t.text "error_message"
+ t.integer "service_id", :default => 0
+ t.string "login"
+ t.string "password"
t.datetime "created_at"
t.datetime "updated_at"
+ t.datetime "entries_changed_at"
+ t.string "harvested_from_display_uri", :limit => 2083
+ t.string "harvested_from_title", :limit => 1000
+ t.string "harvested_from_short_title", :limit => 100
+ t.integer "entries_count"
+ t.integer "default_language_id", :default => 0
+ t.string "default_grain_size", :default => "unknown"
+ t.integer "contributor_id"
end
- add_index "friends", ["invited_id", "inviter_id"], :name => "index_friends_on_invited_id_and_inviter_id"
- add_index "friends", ["inviter_id", "invited_id"], :name => "index_friends_on_inviter_id_and_invited_id"
+ add_index "feeds", ["service_id"], :name => "index_feeds_on_service_id"
+ add_index "feeds", ["uri"], :name => "index_feeds_on_uri"
+ create_table "languages", :force => true do |t|
+ t.string "name"
+ t.string "english_name"
+ t.string "locale"
+ t.boolean "supported", :default => true
+ t.integer "is_default", :default => 0
+ t.boolean "muck_raker_supported", :default => false
+ t.integer "indexed_records", :default => 0
+ end
+
+ add_index "languages", ["locale"], :name => "index_languages_on_locale"
+ add_index "languages", ["muck_raker_supported"], :name => "index_languages_on_muck_raker_supported"
+ add_index "languages", ["name"], :name => "index_languages_on_name"
+
+ create_table "micro_concerts", :force => true do |t|
+ t.integer "micro_event_id"
+ t.string "performer"
+ t.string "ticket_url", :limit => 2083
+ end
+
+ add_index "micro_concerts", ["micro_event_id"], :name => "index_micro_concerts_on_micro_event_id"
+
+ create_table "micro_conferences", :force => true do |t|
+ t.integer "micro_event_id"
+ t.string "theme"
+ t.datetime "register_by"
+ t.datetime "submit_by"
+ end
+
+ add_index "micro_conferences", ["micro_event_id"], :name => "index_micro_conferences_on_micro_event_id"
+
+ create_table "micro_event_links", :force => true do |t|
+ t.integer "micro_event_id"
+ t.string "uri"
+ t.string "title"
+ end
+
+ add_index "micro_event_links", ["micro_event_id"], :name => "index_micro_event_links_on_micro_event_id"
+
+ create_table "micro_event_people", :force => true do |t|
+ t.integer "micro_event_id"
+ t.string "name"
+ t.string "role"
+ t.string "email"
+ t.string "link", :limit => 2083
+ t.string "phone"
+ end
+
+ add_index "micro_event_people", ["micro_event_id"], :name => "index_micro_event_people_on_micro_event_id"
+
+ create_table "micro_events", :force => true do |t|
+ t.integer "entry_id", :null => false
+ t.string "name", :null => false
+ t.text "description"
+ t.string "price"
+ t.text "image"
+ t.text "address"
+ t.text "subaddress"
+ t.string "city"
+ t.string "state"
+ t.string "postcode"
+ t.string "country"
+ t.datetime "begins", :null => false
+ t.datetime "ends"
+ t.text "tags"
+ t.string "duration"
+ t.text "location"
+ end
+
+ add_index "micro_events", ["entry_id"], :name => "index_micro_events_on_entry_id"
+
+ create_table "oai_endpoints", :force => true do |t|
+ t.string "uri", :limit => 2083
+ t.string "display_uri", :limit => 2083
+ t.string "metadata_prefix"
+ t.string "title", :limit => 1000
+ t.string "short_title", :limit => 100
+ end
+
create_table "permissions", :force => true do |t|
t.integer "role_id", :null => false
t.integer "user_id", :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
+ create_table "personal_recommendations", :force => true do |t|
+ t.integer "personal_recommendable_id"
+ t.string "personal_recommendable_type"
+ t.integer "destination_id"
+ t.string "destination_type"
+ t.integer "rank"
+ t.float "relevance"
+ end
+
+ create_table "queries", :force => true do |t|
+ t.text "name"
+ t.integer "frequency"
+ end
+
+ create_table "recommendations", :force => true do |t|
+ t.integer "entry_id"
+ t.integer "dest_entry_id"
+ t.integer "rank"
+ t.decimal "relevance", :precision => 8, :scale => 6, :default => 0.0
+ t.integer "clicks", :default => 0
+ t.integer "avg_time_at_dest", :default => 60
+ end
+
+ add_index "recommendations", ["dest_entry_id"], :name => "index_recommendations_on_dest_entry_id"
+ add_index "recommendations", ["entry_id"], :name => "index_recommendations_on_entry_id"
+
create_table "roles", :force => true do |t|
t.string "rolename"
t.datetime "created_at"
t.datetime "updated_at"
end
+ create_table "services", :force => true do |t|
+ t.string "uri", :limit => 2083, :default => ""
+ t.string "name", :limit => 1000, :default => ""
+ t.string "api_uri", :limit => 2083, :default => ""
+ t.string "uri_template", :limit => 2083, :default => ""
+ t.string "icon", :limit => 2083, :default => "rss.gif"
+ t.integer "sequence"
+ t.boolean "requires_password", :default => false
+ end
+
create_table "slugs", :force => true do |t|
t.string "name"
t.integer "sluggable_id"
t.integer "sequence", :default => 1, :null => false
t.string "sluggable_type", :limit => 40
@@ -112,10 +314,33 @@
end
add_index "slugs", ["name", "sluggable_type", "scope", "sequence"], :name => "index_slugs_on_name_and_sluggable_type_and_scope_and_sequence", :unique => true
add_index "slugs", ["sluggable_id"], :name => "index_slugs_on_sluggable_id"
+ create_table "states", :force => true do |t|
+ t.string "name", :limit => 128, :default => "", :null => false
+ t.string "abbreviation", :limit => 3, :default => "", :null => false
+ t.integer "country_id", :limit => 8, :null => false
+ end
+
+ add_index "states", ["abbreviation"], :name => "index_states_on_abbreviation"
+ add_index "states", ["country_id"], :name => "index_states_on_country_id"
+ add_index "states", ["name"], :name => "index_states_on_name"
+
+ create_table "subjects", :force => true do |t|
+ t.string "name"
+ end
+
+ create_table "tag_clouds", :force => true do |t|
+ t.integer "language_id"
+ t.string "filter"
+ t.string "tag_list", :limit => 5000
+ t.string "grain_size", :default => "all"
+ end
+
+ add_index "tag_clouds", ["grain_size", "language_id", "filter"], :name => "index_tag_clouds_on_grain_size_and_language_id_and_filter", :unique => true
+
create_table "taggings", :force => true do |t|
t.integer "tag_id"
t.integer "taggable_id"
t.integer "tagger_id"
t.string "tagger_type"
@@ -160,7 +385,17 @@
add_index "users", ["last_request_at"], :name => "index_users_on_last_request_at"
add_index "users", ["login"], :name => "index_users_on_login"
add_index "users", ["perishable_token"], :name => "index_users_on_perishable_token"
add_index "users", ["persistence_token"], :name => "index_users_on_persistence_token"
add_index "users", ["single_access_token"], :name => "index_users_on_single_access_token"
+
+ create_table "watched_pages", :force => true do |t|
+ t.integer "entry_id"
+ t.datetime "harvested_at"
+ t.boolean "has_microformats", :default => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ add_index "watched_pages", ["entry_id"], :name => "index_watched_pages_on_entry_id"
end