schema.rb 24.8 KB
Newer Older
Andrew8xx8's avatar
Andrew8xx8 committed
1 2 3 4 5 6 7 8 9 10 11
# encoding: UTF-8
# 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).
#
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
12
# It's strongly recommended that you check this file into your version control system.
Andrew8xx8's avatar
Andrew8xx8 committed
13

14
ActiveRecord::Schema.define(version: 20150717130904) do
15 16 17

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"
18

19 20 21 22 23 24 25 26
  create_table "application_settings", force: true do |t|
    t.integer  "default_projects_limit"
    t.boolean  "signup_enabled"
    t.boolean  "signin_enabled"
    t.boolean  "gravatar_enabled"
    t.text     "sign_in_text"
    t.datetime "created_at"
    t.datetime "updated_at"
27
    t.string   "home_page_url"
28 29 30
    t.integer  "default_branch_protection",    default: 2
    t.boolean  "twitter_sharing_enabled",      default: true
    t.text     "restricted_visibility_levels"
31
    t.boolean  "version_check_enabled",        default: true
32
    t.integer  "max_attachment_size",          default: 10,    null: false
Vinnie Okada's avatar
Vinnie Okada committed
33 34
    t.integer  "default_project_visibility"
    t.integer  "default_snippet_visibility"
35
    t.text     "restricted_signup_domains"
36
    t.boolean  "user_oauth_applications",      default: true
37
    t.string   "after_sign_out_path"
38
    t.integer  "session_expire_delay",         default: 10080, null: false
39 40
  end

41 42 43 44 45 46 47 48 49 50 51 52 53 54
  create_table "audit_events", force: true do |t|
    t.integer  "author_id",   null: false
    t.string   "type",        null: false
    t.integer  "entity_id",   null: false
    t.string   "entity_type", null: false
    t.text     "details"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "audit_events", ["author_id"], name: "index_audit_events_on_author_id", using: :btree
  add_index "audit_events", ["entity_id", "entity_type"], name: "index_audit_events_on_entity_id_and_entity_type", using: :btree
  add_index "audit_events", ["type"], name: "index_audit_events_on_type", using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
55 56
  create_table "broadcast_messages", force: true do |t|
    t.text     "message",    null: false
57 58 59
    t.datetime "starts_at"
    t.datetime "ends_at"
    t.integer  "alert_type"
60 61
    t.datetime "created_at"
    t.datetime "updated_at"
62 63
    t.string   "color"
    t.string   "font"
64
  end
65

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
66 67 68
  create_table "deploy_keys_projects", force: true do |t|
    t.integer  "deploy_key_id", null: false
    t.integer  "project_id",    null: false
69 70
    t.datetime "created_at"
    t.datetime "updated_at"
71
  end
72

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
73
  add_index "deploy_keys_projects", ["project_id"], name: "index_deploy_keys_projects_on_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
74

75 76 77 78 79 80 81 82 83 84
  create_table "emails", force: true do |t|
    t.integer  "user_id",    null: false
    t.string   "email",      null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "emails", ["email"], name: "index_emails_on_email", unique: true, using: :btree
  add_index "emails", ["user_id"], name: "index_emails_on_user_id", using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
85
  create_table "events", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
86 87 88 89 90
    t.string   "target_type"
    t.integer  "target_id"
    t.string   "title"
    t.text     "data"
    t.integer  "project_id"
91 92
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
93 94 95 96
    t.integer  "action"
    t.integer  "author_id"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
97 98 99 100 101 102 103 104 105 106
  add_index "events", ["action"], name: "index_events_on_action", using: :btree
  add_index "events", ["author_id"], name: "index_events_on_author_id", using: :btree
  add_index "events", ["created_at"], name: "index_events_on_created_at", using: :btree
  add_index "events", ["project_id"], name: "index_events_on_project_id", using: :btree
  add_index "events", ["target_id"], name: "index_events_on_target_id", using: :btree
  add_index "events", ["target_type"], name: "index_events_on_target_type", using: :btree

  create_table "forked_project_links", force: true do |t|
    t.integer  "forked_to_project_id",   null: false
    t.integer  "forked_from_project_id", null: false
107 108
    t.datetime "created_at"
    t.datetime "updated_at"
109 110
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
111
  add_index "forked_project_links", ["forked_to_project_id"], name: "index_forked_project_links_on_forked_to_project_id", unique: true, using: :btree
112

113
  create_table "identities", force: true do |t|
114 115 116 117 118
    t.string   "extern_uid"
    t.string   "provider"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
119 120
  end

121
  add_index "identities", ["created_at", "id"], name: "index_identities_on_created_at_and_id", using: :btree
122 123
  add_index "identities", ["user_id"], name: "index_identities_on_user_id", using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
124
  create_table "issues", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
125 126 127 128
    t.string   "title"
    t.integer  "assignee_id"
    t.integer  "author_id"
    t.integer  "project_id"
129 130
    t.datetime "created_at"
    t.datetime "updated_at"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
131
    t.integer  "position",     default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
132 133 134 135
    t.string   "branch_name"
    t.text     "description"
    t.integer  "milestone_id"
    t.string   "state"
136
    t.integer  "iid"
Andrew8xx8's avatar
Andrew8xx8 committed
137 138
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
139 140
  add_index "issues", ["assignee_id"], name: "index_issues_on_assignee_id", using: :btree
  add_index "issues", ["author_id"], name: "index_issues_on_author_id", using: :btree
141
  add_index "issues", ["created_at", "id"], name: "index_issues_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
142 143
  add_index "issues", ["created_at"], name: "index_issues_on_created_at", using: :btree
  add_index "issues", ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
144
  add_index "issues", ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
145 146
  add_index "issues", ["project_id"], name: "index_issues_on_project_id", using: :btree
  add_index "issues", ["title"], name: "index_issues_on_title", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
147

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
148
  create_table "keys", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
149
    t.integer  "user_id"
150 151
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
152 153
    t.text     "key"
    t.string   "title"
154
    t.string   "type"
155
    t.string   "fingerprint"
156
    t.boolean  "public",      default: false, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
157 158
  end

159
  add_index "keys", ["created_at", "id"], name: "index_keys_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
160
  add_index "keys", ["user_id"], name: "index_keys_on_user_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
161

162 163 164 165 166 167 168 169
  create_table "label_links", force: true do |t|
    t.integer  "label_id"
    t.integer  "target_id"
    t.string   "target_type"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
170 171 172
  add_index "label_links", ["label_id"], name: "index_label_links_on_label_id", using: :btree
  add_index "label_links", ["target_id", "target_type"], name: "index_label_links_on_target_id_and_target_type", using: :btree

173 174 175 176 177 178 179 180
  create_table "labels", force: true do |t|
    t.string   "title"
    t.string   "color"
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
181 182
  add_index "labels", ["project_id"], name: "index_labels_on_project_id", using: :btree

183 184 185 186
  create_table "members", force: true do |t|
    t.integer  "access_level",       null: false
    t.integer  "source_id",          null: false
    t.string   "source_type",        null: false
Douwe Maan's avatar
Douwe Maan committed
187
    t.integer  "user_id"
188 189 190 191
    t.integer  "notification_level", null: false
    t.string   "type"
    t.datetime "created_at"
    t.datetime "updated_at"
Douwe Maan's avatar
Douwe Maan committed
192 193 194 195
    t.integer  "created_by_id"
    t.string   "invite_email"
    t.string   "invite_token"
    t.datetime "invite_accepted_at"
196 197
  end

198
  add_index "members", ["access_level"], name: "index_members_on_access_level", using: :btree
199
  add_index "members", ["created_at", "id"], name: "index_members_on_created_at_and_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
200
  add_index "members", ["invite_token"], name: "index_members_on_invite_token", unique: true, using: :btree
201 202 203 204
  add_index "members", ["source_id", "source_type"], name: "index_members_on_source_id_and_source_type", using: :btree
  add_index "members", ["type"], name: "index_members_on_type", using: :btree
  add_index "members", ["user_id"], name: "index_members_on_user_id", using: :btree

205
  create_table "merge_request_diffs", force: true do |t|
206
    t.string   "state"
207 208
    t.text     "st_commits"
    t.text     "st_diffs"
209
    t.integer  "merge_request_id", null: false
210 211 212 213
    t.datetime "created_at"
    t.datetime "updated_at"
  end

214 215
  add_index "merge_request_diffs", ["merge_request_id"], name: "index_merge_request_diffs_on_merge_request_id", unique: true, using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
216
  create_table "merge_requests", force: true do |t|
217 218 219
    t.string   "target_branch",                 null: false
    t.string   "source_branch",                 null: false
    t.integer  "source_project_id",             null: false
Andrew8xx8's avatar
Andrew8xx8 committed
220 221 222
    t.integer  "author_id"
    t.integer  "assignee_id"
    t.string   "title"
223 224
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
225 226 227
    t.integer  "milestone_id"
    t.string   "state"
    t.string   "merge_status"
228
    t.integer  "target_project_id",             null: false
229
    t.integer  "iid"
230
    t.text     "description"
231
    t.integer  "position",          default: 0
232
    t.datetime "locked_at"
Andrew8xx8's avatar
Andrew8xx8 committed
233 234
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
235 236
  add_index "merge_requests", ["assignee_id"], name: "index_merge_requests_on_assignee_id", using: :btree
  add_index "merge_requests", ["author_id"], name: "index_merge_requests_on_author_id", using: :btree
237
  add_index "merge_requests", ["created_at", "id"], name: "index_merge_requests_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
238 239 240
  add_index "merge_requests", ["created_at"], name: "index_merge_requests_on_created_at", using: :btree
  add_index "merge_requests", ["milestone_id"], name: "index_merge_requests_on_milestone_id", using: :btree
  add_index "merge_requests", ["source_branch"], name: "index_merge_requests_on_source_branch", using: :btree
241
  add_index "merge_requests", ["source_project_id"], name: "index_merge_requests_on_source_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
242
  add_index "merge_requests", ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
243
  add_index "merge_requests", ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
244 245 246 247 248
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title", using: :btree

  create_table "milestones", force: true do |t|
    t.string   "title",       null: false
    t.integer  "project_id",  null: false
Andrew8xx8's avatar
Andrew8xx8 committed
249 250
    t.text     "description"
    t.date     "due_date"
251 252
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
253
    t.string   "state"
254
    t.integer  "iid"
Andrew8xx8's avatar
Andrew8xx8 committed
255 256
  end

257
  add_index "milestones", ["created_at", "id"], name: "index_milestones_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
258
  add_index "milestones", ["due_date"], name: "index_milestones_on_due_date", using: :btree
259
  add_index "milestones", ["project_id", "iid"], name: "index_milestones_on_project_id_and_iid", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
260
  add_index "milestones", ["project_id"], name: "index_milestones_on_project_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
261

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
262 263 264
  create_table "namespaces", force: true do |t|
    t.string   "name",                     null: false
    t.string   "path",                     null: false
265
    t.integer  "owner_id"
266 267
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
268
    t.string   "type"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
269
    t.string   "description", default: "", null: false
Steven Thonus's avatar
Steven Thonus committed
270
    t.string   "avatar"
Andrew8xx8's avatar
Andrew8xx8 committed
271 272
  end

273
  add_index "namespaces", ["created_at", "id"], name: "index_namespaces_on_created_at_and_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
274
  add_index "namespaces", ["name"], name: "index_namespaces_on_name", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
275
  add_index "namespaces", ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
276
  add_index "namespaces", ["path"], name: "index_namespaces_on_path", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
277
  add_index "namespaces", ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
278

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
279
  create_table "notes", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
280 281 282
    t.text     "note"
    t.string   "noteable_type"
    t.integer  "author_id"
283 284
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
285 286 287 288 289
    t.integer  "project_id"
    t.string   "attachment"
    t.string   "line_code"
    t.string   "commit_id"
    t.integer  "noteable_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
290
    t.boolean  "system",        default: false, null: false
291
    t.text     "st_diff"
Andrew8xx8's avatar
Andrew8xx8 committed
292 293
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
294 295
  add_index "notes", ["author_id"], name: "index_notes_on_author_id", using: :btree
  add_index "notes", ["commit_id"], name: "index_notes_on_commit_id", using: :btree
296
  add_index "notes", ["created_at", "id"], name: "index_notes_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
297 298 299 300 301
  add_index "notes", ["created_at"], name: "index_notes_on_created_at", using: :btree
  add_index "notes", ["noteable_id", "noteable_type"], name: "index_notes_on_noteable_id_and_noteable_type", using: :btree
  add_index "notes", ["noteable_type"], name: "index_notes_on_noteable_type", using: :btree
  add_index "notes", ["project_id", "noteable_type"], name: "index_notes_on_project_id_and_noteable_type", using: :btree
  add_index "notes", ["project_id"], name: "index_notes_on_project_id", using: :btree
302
  add_index "notes", ["updated_at"], name: "index_notes_on_updated_at", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
303

Valery Sizov's avatar
Valery Sizov committed
304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346
  create_table "oauth_access_grants", force: true do |t|
    t.integer  "resource_owner_id", null: false
    t.integer  "application_id",    null: false
    t.string   "token",             null: false
    t.integer  "expires_in",        null: false
    t.text     "redirect_uri",      null: false
    t.datetime "created_at",        null: false
    t.datetime "revoked_at"
    t.string   "scopes"
  end

  add_index "oauth_access_grants", ["token"], name: "index_oauth_access_grants_on_token", unique: true, using: :btree

  create_table "oauth_access_tokens", force: true do |t|
    t.integer  "resource_owner_id"
    t.integer  "application_id"
    t.string   "token",             null: false
    t.string   "refresh_token"
    t.integer  "expires_in"
    t.datetime "revoked_at"
    t.datetime "created_at",        null: false
    t.string   "scopes"
  end

  add_index "oauth_access_tokens", ["refresh_token"], name: "index_oauth_access_tokens_on_refresh_token", unique: true, using: :btree
  add_index "oauth_access_tokens", ["resource_owner_id"], name: "index_oauth_access_tokens_on_resource_owner_id", using: :btree
  add_index "oauth_access_tokens", ["token"], name: "index_oauth_access_tokens_on_token", unique: true, using: :btree

  create_table "oauth_applications", force: true do |t|
    t.string   "name",                      null: false
    t.string   "uid",                       null: false
    t.string   "secret",                    null: false
    t.text     "redirect_uri",              null: false
    t.string   "scopes",       default: "", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "owner_id"
    t.string   "owner_type"
  end

  add_index "oauth_applications", ["owner_id", "owner_type"], name: "index_oauth_applications_on_owner_id_and_owner_type", using: :btree
  add_index "oauth_applications", ["uid"], name: "index_oauth_applications_on_uid", unique: true, using: :btree

347 348 349 350 351
  create_table "project_import_data", force: true do |t|
    t.integer "project_id"
    t.text    "data"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
352
  create_table "projects", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
353 354 355
    t.string   "name"
    t.string   "path"
    t.text     "description"
356 357
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
358
    t.integer  "creator_id"
359 360 361 362
    t.boolean  "issues_enabled",         default: true,     null: false
    t.boolean  "wall_enabled",           default: true,     null: false
    t.boolean  "merge_requests_enabled", default: true,     null: false
    t.boolean  "wiki_enabled",           default: true,     null: false
Andrew8xx8's avatar
Andrew8xx8 committed
363
    t.integer  "namespace_id"
364
    t.string   "issues_tracker",         default: "gitlab", null: false
Andrew8xx8's avatar
Andrew8xx8 committed
365
    t.string   "issues_tracker_id"
366
    t.boolean  "snippets_enabled",       default: true,     null: false
367
    t.datetime "last_activity_at"
368
    t.string   "import_url"
369 370
    t.integer  "visibility_level",       default: 0,        null: false
    t.boolean  "archived",               default: false,    null: false
371
    t.string   "avatar"
372
    t.string   "import_status"
373 374
    t.float    "repository_size",        default: 0.0
    t.integer  "star_count",             default: 0,        null: false
Valery Sizov's avatar
Valery Sizov committed
375 376
    t.string   "import_type"
    t.string   "import_source"
377
    t.integer  "commit_count",           default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
378 379
  end

380
  add_index "projects", ["created_at", "id"], name: "index_projects_on_created_at_and_id", using: :btree
381
  add_index "projects", ["creator_id"], name: "index_projects_on_creator_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
382 383
  add_index "projects", ["last_activity_at"], name: "index_projects_on_last_activity_at", using: :btree
  add_index "projects", ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
384
  add_index "projects", ["star_count"], name: "index_projects_on_star_count", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
385

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
386
  create_table "protected_branches", force: true do |t|
387 388
    t.integer  "project_id",                          null: false
    t.string   "name",                                null: false
389 390
    t.datetime "created_at"
    t.datetime "updated_at"
391
    t.boolean  "developers_can_push", default: false, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
392 393
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
394
  add_index "protected_branches", ["project_id"], name: "index_protected_branches_on_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
395

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
396
  create_table "services", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
397 398
    t.string   "type"
    t.string   "title"
399
    t.integer  "project_id"
400 401
    t.datetime "created_at"
    t.datetime "updated_at"
402
    t.boolean  "active",                default: false, null: false
403
    t.text     "properties"
404 405 406 407 408
    t.boolean  "template",              default: false
    t.boolean  "push_events",           default: true
    t.boolean  "issues_events",         default: true
    t.boolean  "merge_requests_events", default: true
    t.boolean  "tag_push_events",       default: true
409
    t.boolean  "note_events",           default: true,  null: false
Andrew8xx8's avatar
Andrew8xx8 committed
410 411
  end

412
  add_index "services", ["created_at", "id"], name: "index_services_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
413
  add_index "services", ["project_id"], name: "index_services_on_project_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
414

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
415
  create_table "snippets", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
416
    t.string   "title"
417
    t.text     "content"
418
    t.integer  "author_id",                    null: false
419
    t.integer  "project_id"
420 421
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
422 423
    t.string   "file_name"
    t.datetime "expires_at"
424
    t.string   "type"
425
    t.integer  "visibility_level", default: 0, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
426 427
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
428
  add_index "snippets", ["author_id"], name: "index_snippets_on_author_id", using: :btree
429
  add_index "snippets", ["created_at", "id"], name: "index_snippets_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
430 431 432
  add_index "snippets", ["created_at"], name: "index_snippets_on_created_at", using: :btree
  add_index "snippets", ["expires_at"], name: "index_snippets_on_expires_at", using: :btree
  add_index "snippets", ["project_id"], name: "index_snippets_on_project_id", using: :btree
433
  add_index "snippets", ["visibility_level"], name: "index_snippets_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
434

435
  create_table "subscriptions", force: true do |t|
Valery Sizov's avatar
Valery Sizov committed
436
    t.integer  "user_id"
437 438
    t.integer  "subscribable_id"
    t.string   "subscribable_type"
Valery Sizov's avatar
Valery Sizov committed
439 440 441 442 443
    t.boolean  "subscribed"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

444
  add_index "subscriptions", ["subscribable_id", "subscribable_type", "user_id"], name: "subscriptions_user_id_and_ref_fields", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
445

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
446
  create_table "taggings", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
447 448 449 450 451 452 453 454 455
    t.integer  "tag_id"
    t.integer  "taggable_id"
    t.string   "taggable_type"
    t.integer  "tagger_id"
    t.string   "tagger_type"
    t.string   "context"
    t.datetime "created_at"
  end

456
  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true, using: :btree
457 458
  add_index "taggings", ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
459
  create_table "tags", force: true do |t|
460 461
    t.string  "name"
    t.integer "taggings_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
462 463
  end

464 465
  add_index "tags", ["name"], name: "index_tags_on_name", unique: true, using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
466
  create_table "users", force: true do |t|
Douwe Maan's avatar
Douwe Maan committed
467 468
    t.string   "email",                         default: "",    null: false
    t.string   "encrypted_password",            default: "",    null: false
Andrew8xx8's avatar
Andrew8xx8 committed
469 470 471
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
Douwe Maan's avatar
Douwe Maan committed
472
    t.integer  "sign_in_count",                 default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
473 474 475 476
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
477 478
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
479
    t.string   "name"
Douwe Maan's avatar
Douwe Maan committed
480 481 482 483 484
    t.boolean  "admin",                         default: false, null: false
    t.integer  "projects_limit",                default: 10
    t.string   "skype",                         default: "",    null: false
    t.string   "linkedin",                      default: "",    null: false
    t.string   "twitter",                       default: "",    null: false
Andrew8xx8's avatar
Andrew8xx8 committed
485
    t.string   "authentication_token"
Douwe Maan's avatar
Douwe Maan committed
486
    t.integer  "theme_id",                      default: 1,     null: false
Andrew8xx8's avatar
Andrew8xx8 committed
487
    t.string   "bio"
Douwe Maan's avatar
Douwe Maan committed
488
    t.integer  "failed_attempts",               default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
489 490
    t.datetime "locked_at"
    t.string   "username"
Douwe Maan's avatar
Douwe Maan committed
491 492
    t.boolean  "can_create_group",              default: true,  null: false
    t.boolean  "can_create_team",               default: true,  null: false
493
    t.string   "state"
Douwe Maan's avatar
Douwe Maan committed
494 495
    t.integer  "color_scheme_id",               default: 1,     null: false
    t.integer  "notification_level",            default: 1,     null: false
496
    t.datetime "password_expires_at"
497
    t.integer  "created_by_id"
498
    t.datetime "last_credential_check_at"
499
    t.string   "avatar"
500 501 502 503
    t.string   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "unconfirmed_email"
Douwe Maan's avatar
Douwe Maan committed
504 505
    t.boolean  "hide_no_ssh_key",               default: false
    t.string   "website_url",                   default: "",    null: false
Valery Sizov's avatar
Valery Sizov committed
506
    t.string   "github_access_token"
507
    t.string   "gitlab_access_token"
508
    t.string   "notification_email"
Douwe Maan's avatar
Douwe Maan committed
509 510 511 512
    t.boolean  "hide_no_password",              default: false
    t.boolean  "password_automatically_set",    default: false
    t.string   "bitbucket_access_token"
    t.string   "bitbucket_access_token_secret"
513
    t.string   "location"
514 515 516
    t.string   "encrypted_otp_secret"
    t.string   "encrypted_otp_secret_iv"
    t.string   "encrypted_otp_secret_salt"
517
    t.boolean  "otp_required_for_login",        default: false, null: false
518
    t.text     "otp_backup_codes"
519
    t.string   "public_email",                  default: "",    null: false
520
    t.integer  "dashboard",                     default: 0
521
    t.integer  "project_view",                  default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
522 523
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
524 525 526
  add_index "users", ["admin"], name: "index_users_on_admin", using: :btree
  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
527
  add_index "users", ["created_at", "id"], name: "index_users_on_created_at_and_id", using: :btree
528
  add_index "users", ["current_sign_in_at"], name: "index_users_on_current_sign_in_at", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
529 530 531 532 533
  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
  add_index "users", ["name"], name: "index_users_on_name", using: :btree
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
  add_index "users", ["username"], name: "index_users_on_username", using: :btree

Ciro Santilli's avatar
Ciro Santilli committed
534 535 536 537 538 539 540 541 542 543 544
  create_table "users_star_projects", force: true do |t|
    t.integer  "project_id", null: false
    t.integer  "user_id",    null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "users_star_projects", ["project_id"], name: "index_users_star_projects_on_project_id", using: :btree
  add_index "users_star_projects", ["user_id", "project_id"], name: "index_users_star_projects_on_user_id_and_project_id", unique: true, using: :btree
  add_index "users_star_projects", ["user_id"], name: "index_users_star_projects_on_user_id", using: :btree

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
545
  create_table "web_hooks", force: true do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
546 547
    t.string   "url"
    t.integer  "project_id"
548 549
    t.datetime "created_at"
    t.datetime "updated_at"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
550
    t.string   "type",                  default: "ProjectHook"
Andrew8xx8's avatar
Andrew8xx8 committed
551
    t.integer  "service_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
552 553 554
    t.boolean  "push_events",           default: true,          null: false
    t.boolean  "issues_events",         default: false,         null: false
    t.boolean  "merge_requests_events", default: false,         null: false
555
    t.boolean  "tag_push_events",       default: false
556
    t.boolean  "note_events",           default: false,         null: false
Andrew8xx8's avatar
Andrew8xx8 committed
557 558
  end

559
  add_index "web_hooks", ["created_at", "id"], name: "index_web_hooks_on_created_at_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
560
  add_index "web_hooks", ["project_id"], name: "index_web_hooks_on_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
561

Andrew8xx8's avatar
Andrew8xx8 committed
562
end