main
1# encoding: UTF-8
2# This file is auto-generated from the current state of the database. Instead
3# of editing this file, please use the migrations feature of Active Record to
4# incrementally modify your database, and then regenerate this schema definition.
5#
6# Note that this schema.rb definition is the authoritative source for your
7# database schema. If you need to create the application database on another
8# system, you should be using db:schema:load, not running all the migrations
9# from scratch. The latter is a flawed and unsustainable approach (the more migrations
10# you'll amass, the slower it'll run and the greater likelihood for issues).
11#
12# It's strongly recommended to check this file into your version control system.
13
14ActiveRecord::Schema.define(:version => 20130624045542) do
15
16 create_table "active_admin_comments", :force => true do |t|
17 t.string "resource_id", :null => false
18 t.string "resource_type", :null => false
19 t.integer "author_id"
20 t.string "author_type"
21 t.text "body"
22 t.datetime "created_at", :null => false
23 t.datetime "updated_at", :null => false
24 t.string "namespace"
25 end
26
27 add_index "active_admin_comments", ["author_type", "author_id"], :name => "index_active_admin_comments_on_author_type_and_author_id"
28 add_index "active_admin_comments", ["namespace"], :name => "index_active_admin_comments_on_namespace"
29 add_index "active_admin_comments", ["resource_type", "resource_id"], :name => "index_admin_notes_on_resource_type_and_resource_id"
30
31 create_table "admin_users", :force => true do |t|
32 t.string "email", :default => "", :null => false
33 t.string "encrypted_password", :default => "", :null => false
34 t.string "reset_password_token"
35 t.datetime "reset_password_sent_at"
36 t.datetime "remember_created_at"
37 t.integer "sign_in_count", :default => 0
38 t.datetime "current_sign_in_at"
39 t.datetime "last_sign_in_at"
40 t.string "current_sign_in_ip"
41 t.string "last_sign_in_ip"
42 t.datetime "created_at", :null => false
43 t.datetime "updated_at", :null => false
44 end
45
46 add_index "admin_users", ["email"], :name => "index_admin_users_on_email", :unique => true
47 add_index "admin_users", ["reset_password_token"], :name => "index_admin_users_on_reset_password_token", :unique => true
48
49 create_table "links", :force => true do |t|
50 t.string "url"
51 t.string "title"
52 t.text "description"
53 t.string "thumbnail_url"
54 t.integer "user_id"
55 t.datetime "created_at", :null => false
56 t.datetime "updated_at", :null => false
57 end
58
59 create_table "needs", :force => true do |t|
60 t.text "description"
61 t.integer "user_id"
62 t.datetime "created_at", :null => false
63 t.datetime "updated_at", :null => false
64 t.string "address"
65 t.float "latitude"
66 t.float "longitude"
67 end
68
69 create_table "neighbourhoods", :force => true do |t|
70 t.string "name"
71 t.string "status"
72 t.datetime "created_at", :null => false
73 t.datetime "updated_at", :null => false
74 end
75
76 create_table "taggings", :force => true do |t|
77 t.integer "tag_id"
78 t.integer "taggable_id"
79 t.string "taggable_type"
80 t.integer "tagger_id"
81 t.string "tagger_type"
82 t.string "context", :limit => 128
83 t.datetime "created_at"
84 end
85
86 add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id"
87 add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context"
88
89 create_table "tags", :force => true do |t|
90 t.string "name"
91 end
92
93 create_table "users", :force => true do |t|
94 t.string "email", :default => "", :null => false
95 t.string "encrypted_password", :default => "", :null => false
96 t.string "reset_password_token"
97 t.datetime "reset_password_sent_at"
98 t.datetime "remember_created_at"
99 t.integer "sign_in_count", :default => 0
100 t.datetime "current_sign_in_at"
101 t.datetime "last_sign_in_at"
102 t.string "current_sign_in_ip"
103 t.string "last_sign_in_ip"
104 t.datetime "created_at", :null => false
105 t.datetime "updated_at", :null => false
106 t.string "name"
107 t.string "postal_code"
108 t.float "latitude"
109 t.float "longitude"
110 end
111
112 add_index "users", ["email"], :name => "index_users_on_email", :unique => true
113 add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true
114
115end