summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authormo khan <mo@mokhan.ca>2013-12-30 08:08:47 -0700
committermo khan <mo@mokhan.ca>2013-12-30 08:08:47 -0700
commit99c87ab2e002f6c84fddc41ba9f9f0c408ff7676 (patch)
tree1f4a6beb0a0b2d5e604fff7313952c3bb07a3a30 /db
parent5eebdb6942e7a5ae291ab41b8e3906add0953b42 (diff)
bake db:migrate
Diffstat (limited to 'db')
-rw-r--r--db/schema.rb73
1 files changed, 35 insertions, 38 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 8590b526..55a7de41 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -13,17 +13,14 @@
ActiveRecord::Schema.define(version: 20131230013944) do
- # These are extensions that must be enabled in order to support this database
- enable_extension "plpgsql"
-
create_table "avatars", force: true do |t|
t.integer "user_id"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.string "avatar"
end
- add_index "avatars", ["user_id"], name: "index_avatars_on_user_id", using: :btree
+ add_index "avatars", ["user_id"], name: "index_avatars_on_user_id"
create_table "categories", force: true do |t|
t.string "name"
@@ -45,16 +42,16 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.integer "favorites_count", default: 0
end
- add_index "creations", ["created_at"], name: "index_creations_on_created_at", using: :btree
- add_index "creations", ["user_id"], name: "index_creations_on_user_id", using: :btree
+ add_index "creations", ["created_at"], name: "index_creations_on_created_at"
+ add_index "creations", ["user_id"], name: "index_creations_on_user_id"
create_table "creations_categories", id: false, force: true do |t|
t.integer "creation_id"
t.integer "category_id"
end
- add_index "creations_categories", ["category_id", "creation_id"], name: "index_creations_categories_on_category_id_and_creation_id", using: :btree
- add_index "creations_categories", ["creation_id", "category_id"], name: "index_creations_categories_on_creation_id_and_category_id", using: :btree
+ add_index "creations_categories", ["category_id", "creation_id"], name: "index_creations_categories_on_category_id_and_creation_id"
+ add_index "creations_categories", ["creation_id", "category_id"], name: "index_creations_categories_on_creation_id_and_category_id"
create_table "delayed_jobs", force: true do |t|
t.integer "priority", default: 0
@@ -66,11 +63,11 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.datetime "failed_at"
t.string "locked_by"
t.string "queue"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
- add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree
+ add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority"
create_table "favorites", force: true do |t|
t.integer "user_id"
@@ -79,13 +76,13 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.datetime "updated_at"
end
- add_index "favorites", ["creation_id"], name: "index_favorites_on_creation_id", using: :btree
- add_index "favorites", ["user_id"], name: "index_favorites_on_user_id", using: :btree
+ add_index "favorites", ["creation_id"], name: "index_favorites_on_creation_id"
+ add_index "favorites", ["user_id"], name: "index_favorites_on_user_id"
create_table "interests", force: true do |t|
t.string "name"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "photos", force: true do |t|
@@ -97,7 +94,7 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.boolean "image_processing"
end
- add_index "photos", ["creation_id"], name: "index_photos_on_creation_id", using: :btree
+ add_index "photos", ["creation_id"], name: "index_photos_on_creation_id"
create_table "taggings", force: true do |t|
t.integer "tag_id"
@@ -109,11 +106,11 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.datetime "created_at"
end
- add_index "taggings", ["tag_id"], name: "index_taggings_on_tag_id", using: :btree
- add_index "taggings", ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree
- add_index "taggings", ["taggable_type"], name: "index_taggings_on_taggable_type", using: :btree
- add_index "taggings", ["tagger_id"], name: "index_taggings_on_tagger_id", using: :btree
- add_index "taggings", ["tagger_type"], name: "index_taggings_on_tagger_type", using: :btree
+ add_index "taggings", ["tag_id"], name: "index_taggings_on_tag_id"
+ add_index "taggings", ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context"
+ add_index "taggings", ["taggable_type"], name: "index_taggings_on_taggable_type"
+ add_index "taggings", ["tagger_id"], name: "index_taggings_on_tagger_id"
+ add_index "taggings", ["tagger_type"], name: "index_taggings_on_tagger_type"
create_table "tags", force: true do |t|
t.string "name"
@@ -124,22 +121,22 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.text "description"
t.string "url"
t.integer "user_id"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.string "image_url"
t.string "author"
t.string "author_url"
end
- add_index "tutorials", ["user_id"], name: "index_tutorials_on_user_id", using: :btree
+ add_index "tutorials", ["user_id"], name: "index_tutorials_on_user_id"
create_table "users", force: true do |t|
- t.string "email", default: "", null: false
- t.string "encrypted_password", limit: 128, default: "", null: false
+ t.string "email", default: "", null: false
+ t.string "encrypted_password", default: "", null: false
t.string "reset_password_token"
t.datetime "reset_password_sent_at"
t.datetime "remember_created_at"
- t.integer "sign_in_count", default: 0
+ t.integer "sign_in_count", default: 0
t.datetime "current_sign_in_at"
t.datetime "last_sign_in_at"
t.string "current_sign_in_ip"
@@ -158,27 +155,27 @@ ActiveRecord::Schema.define(version: 20131230013944) do
t.datetime "confirmed_at"
t.datetime "confirmation_sent_at"
t.string "unconfirmed_email"
- t.integer "failed_attempts", default: 0
+ t.integer "failed_attempts", default: 0
t.string "unlock_token"
t.datetime "locked_at"
t.string "authentication_token"
t.string "invitation_token"
t.string "full_address"
- t.integer "creations_count", default: 0
+ t.integer "creations_count", default: 0
end
- add_index "users", ["authentication_token"], name: "index_users_on_authentication_token", unique: true, using: :btree
- add_index "users", ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true, using: :btree
- add_index "users", ["created_at"], name: "index_users_on_created_at", using: :btree
- add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
- add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
- add_index "users", ["unlock_token"], name: "index_users_on_unlock_token", unique: true, using: :btree
+ add_index "users", ["authentication_token"], name: "index_users_on_authentication_token", unique: true
+ add_index "users", ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
+ add_index "users", ["created_at"], name: "index_users_on_created_at"
+ add_index "users", ["email"], name: "index_users_on_email", unique: true
+ add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
+ add_index "users", ["unlock_token"], name: "index_users_on_unlock_token", unique: true
create_table "users_interests", id: false, force: true do |t|
t.integer "user_id"
t.integer "interest_id"
end
- add_index "users_interests", ["interest_id", "user_id"], name: "index_users_interests_on_interest_id_and_user_id", using: :btree
+ add_index "users_interests", ["interest_id", "user_id"], name: "index_users_interests_on_interest_id_and_user_id"
end