Read about our upcoming Code of Conduct on this issue

schema.rb 53.6 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: 20160926145521) do
15

Kamil Trzcinski's avatar
Kamil Trzcinski committed
16
17
  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"
18
  enable_extension "pg_trgm"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
19

Valery Sizov's avatar
Valery Sizov committed
20
  create_table "abuse_reports", force: :cascade do |t|
21
22
23
24
25
    t.integer  "reporter_id"
    t.integer  "user_id"
    t.text     "message"
    t.datetime "created_at"
    t.datetime "updated_at"
26
    t.text     "message_html"
27
28
  end

29
30
31
32
33
  create_table "appearances", force: :cascade do |t|
    t.string   "title"
    t.text     "description"
    t.string   "header_logo"
    t.string   "logo"
34
35
36
    t.datetime "created_at",       null: false
    t.datetime "updated_at",       null: false
    t.text     "description_html"
37
38
  end

Valery Sizov's avatar
Valery Sizov committed
39
  create_table "application_settings", force: :cascade do |t|
40
41
42
43
44
45
46
    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"
47
    t.string   "home_page_url"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
48
    t.integer  "default_branch_protection",             default: 2
49
    t.text     "restricted_visibility_levels"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
50
51
    t.boolean  "version_check_enabled",                 default: true
    t.integer  "max_attachment_size",                   default: 10,          null: false
Vinnie Okada's avatar
Vinnie Okada committed
52
53
    t.integer  "default_project_visibility"
    t.integer  "default_snippet_visibility"
54
    t.text     "domain_whitelist"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
55
    t.boolean  "user_oauth_applications",               default: true
56
    t.string   "after_sign_out_path"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
57
    t.integer  "session_expire_delay",                  default: 10080,       null: false
58
    t.text     "import_sources"
Kamil Trzcinski's avatar
WIP    
Kamil Trzcinski committed
59
    t.text     "help_page_text"
60
    t.string   "admin_notification_email"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
61
62
    t.boolean  "shared_runners_enabled",                default: true,        null: false
    t.integer  "max_artifacts_size",                    default: 100,         null: false
63
    t.string   "runners_registration_token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
64
65
66
67
68
69
70
71
    t.boolean  "require_two_factor_authentication",     default: false
    t.integer  "two_factor_grace_period",               default: 48
    t.boolean  "metrics_enabled",                       default: false
    t.string   "metrics_host",                          default: "localhost"
    t.integer  "metrics_pool_size",                     default: 16
    t.integer  "metrics_timeout",                       default: 10
    t.integer  "metrics_method_call_threshold",         default: 10
    t.boolean  "recaptcha_enabled",                     default: false
72
73
    t.string   "recaptcha_site_key"
    t.string   "recaptcha_private_key"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
74
    t.integer  "metrics_port",                          default: 8089
75
76
    t.boolean  "akismet_enabled",                       default: false
    t.string   "akismet_api_key"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
77
78
    t.integer  "metrics_sample_interval",               default: 15
    t.boolean  "sentry_enabled",                        default: false
Jeroen Nijhof's avatar
Jeroen Nijhof committed
79
    t.string   "sentry_dsn"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
80
    t.boolean  "email_author_in_body",                  default: false
Douwe Maan's avatar
Douwe Maan committed
81
    t.integer  "default_group_visibility"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
82
    t.boolean  "repository_checks_enabled",             default: false
83
    t.text     "shared_runners_text"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
84
    t.integer  "metrics_packet_size",                   default: 1
85
    t.text     "disabled_oauth_sign_in_sources"
86
    t.string   "health_check_access_token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
87
    t.boolean  "send_user_confirmation_email",          default: false
88
    t.integer  "container_registry_token_expire_delay", default: 5
89
    t.text     "after_sign_up_text"
90
    t.boolean  "user_default_external",                 default: false,       null: false
91
    t.string   "repository_storage",                    default: "default"
92
    t.string   "enabled_git_access_protocol"
93
94
    t.boolean  "domain_blacklist_enabled",              default: false
    t.text     "domain_blacklist"
95
96
    t.boolean  "koding_enabled"
    t.string   "koding_url"
97
98
99
100
    t.text     "sign_in_text_html"
    t.text     "help_page_text_html"
    t.text     "shared_runners_text_html"
    t.text     "after_sign_up_text_html"
101
102
  end

Valery Sizov's avatar
Valery Sizov committed
103
  create_table "audit_events", force: :cascade do |t|
104
105
106
107
    t.integer  "author_id",   null: false
    t.string   "type",        null: false
    t.integer  "entity_id",   null: false
    t.string   "entity_type", null: false
108
109
110
111
112
113
114
    t.text     "details"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "audit_events", ["entity_id", "entity_type"], name: "index_audit_events_on_entity_id_and_entity_type", using: :btree

115
116
117
118
119
120
121
122
123
  create_table "award_emoji", force: :cascade do |t|
    t.string   "name"
    t.integer  "user_id"
    t.integer  "awardable_id"
    t.string   "awardable_type"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Z.J. van de Weg's avatar
Z.J. van de Weg committed
124
  add_index "award_emoji", ["awardable_type", "awardable_id"], name: "index_award_emoji_on_awardable_type_and_awardable_id", using: :btree
125
  add_index "award_emoji", ["user_id", "name"], name: "index_award_emoji_on_user_id_and_name", using: :btree
126
127
  add_index "award_emoji", ["user_id"], name: "index_award_emoji_on_user_id", using: :btree

Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
128
129
130
131
132
133
134
135
  create_table "boards", force: :cascade do |t|
    t.integer  "project_id", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "boards", ["project_id"], name: "index_boards_on_project_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
136
  create_table "broadcast_messages", force: :cascade do |t|
137
    t.text     "message",      null: false
138
139
    t.datetime "starts_at"
    t.datetime "ends_at"
140
141
    t.datetime "created_at"
    t.datetime "updated_at"
142
143
    t.string   "color"
    t.string   "font"
144
    t.text     "message_html"
145
  end
146

Valery Sizov's avatar
Valery Sizov committed
147
  create_table "ci_application_settings", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
148
149
150
151
152
153
    t.boolean  "all_broken_builds"
    t.boolean  "add_pusher"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Valery Sizov's avatar
Valery Sizov committed
154
  create_table "ci_builds", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
155
    t.integer  "project_id"
156
    t.string   "status"
Douwe Maan's avatar
Douwe Maan committed
157
    t.datetime "finished_at"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
158
    t.text     "trace"
Douwe Maan's avatar
Douwe Maan committed
159
160
161
162
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
    t.integer  "runner_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
163
    t.float    "coverage"
Douwe Maan's avatar
Douwe Maan committed
164
165
166
    t.integer  "commit_id"
    t.text     "commands"
    t.integer  "job_id"
167
    t.string   "name"
168
    t.boolean  "deploy",                        default: false
Douwe Maan's avatar
Douwe Maan committed
169
    t.text     "options"
170
    t.boolean  "allow_failure",                 default: false, null: false
171
    t.string   "stage"
Douwe Maan's avatar
Douwe Maan committed
172
    t.integer  "trigger_request_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
173
174
    t.integer  "stage_idx"
    t.boolean  "tag"
175
    t.string   "ref"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
176
    t.integer  "user_id"
177
178
179
    t.string   "type"
    t.string   "target_url"
    t.string   "description"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
180
    t.text     "artifacts_file"
181
    t.integer  "gl_project_id"
182
    t.text     "artifacts_metadata"
183
184
    t.integer  "erased_by_id"
    t.datetime "erased_at"
185
    t.datetime "artifacts_expire_at"
186
    t.string   "environment"
187
    t.integer  "artifacts_size",      limit: 8
188
189
    t.string   "when"
    t.text     "yaml_variables"
190
    t.datetime "queued_at"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
191
    t.string   "token"
Douwe Maan's avatar
Douwe Maan committed
192
193
  end

Kamil Trzcinski's avatar
Kamil Trzcinski committed
194
  add_index "ci_builds", ["commit_id", "stage_idx", "created_at"], name: "index_ci_builds_on_commit_id_and_stage_idx_and_created_at", using: :btree
195
  add_index "ci_builds", ["commit_id", "status", "type"], name: "index_ci_builds_on_commit_id_and_status_and_type", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
196
197
  add_index "ci_builds", ["commit_id", "type", "name", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_name_and_ref", using: :btree
  add_index "ci_builds", ["commit_id", "type", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_ref", using: :btree
Douwe Maan's avatar
Douwe Maan committed
198
  add_index "ci_builds", ["commit_id"], name: "index_ci_builds_on_commit_id", using: :btree
199
  add_index "ci_builds", ["gl_project_id"], name: "index_ci_builds_on_gl_project_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
200
201
  add_index "ci_builds", ["project_id"], name: "index_ci_builds_on_project_id", using: :btree
  add_index "ci_builds", ["runner_id"], name: "index_ci_builds_on_runner_id", using: :btree
202
  add_index "ci_builds", ["status"], name: "index_ci_builds_on_status", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
203
  add_index "ci_builds", ["token"], name: "index_ci_builds_on_token", unique: true, using: :btree
Douwe Maan's avatar
Douwe Maan committed
204

Valery Sizov's avatar
Valery Sizov committed
205
  create_table "ci_commits", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
206
    t.integer  "project_id"
207
208
209
    t.string   "ref"
    t.string   "sha"
    t.string   "before_sha"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
210
    t.text     "push_data"
Douwe Maan's avatar
Douwe Maan committed
211
212
    t.datetime "created_at"
    t.datetime "updated_at"
213
    t.boolean  "tag",           default: false
Douwe Maan's avatar
Douwe Maan committed
214
215
    t.text     "yaml_errors"
    t.datetime "committed_at"
Kamil Trzcinski's avatar
WIP    
Kamil Trzcinski committed
216
    t.integer  "gl_project_id"
217
218
219
220
    t.string   "status"
    t.datetime "started_at"
    t.datetime "finished_at"
    t.integer  "duration"
221
    t.integer  "user_id"
Douwe Maan's avatar
Douwe Maan committed
222
223
  end

224
225
  add_index "ci_commits", ["gl_project_id", "sha"], name: "index_ci_commits_on_gl_project_id_and_sha", using: :btree
  add_index "ci_commits", ["gl_project_id", "status"], name: "index_ci_commits_on_gl_project_id_and_status", using: :btree
226
  add_index "ci_commits", ["gl_project_id"], name: "index_ci_commits_on_gl_project_id", using: :btree
227
  add_index "ci_commits", ["status"], name: "index_ci_commits_on_status", using: :btree
228
  add_index "ci_commits", ["user_id"], name: "index_ci_commits_on_user_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
229

Valery Sizov's avatar
Valery Sizov committed
230
  create_table "ci_events", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
231
232
233
234
235
236
237
238
    t.integer  "project_id"
    t.integer  "user_id"
    t.integer  "is_admin"
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Valery Sizov's avatar
Valery Sizov committed
239
  create_table "ci_jobs", force: :cascade do |t|
240
    t.integer  "project_id",                          null: false
Douwe Maan's avatar
Douwe Maan committed
241
    t.text     "commands"
242
    t.boolean  "active",         default: true,       null: false
Douwe Maan's avatar
Douwe Maan committed
243
244
    t.datetime "created_at"
    t.datetime "updated_at"
245
246
247
248
249
    t.string   "name"
    t.boolean  "build_branches", default: true,       null: false
    t.boolean  "build_tags",     default: false,      null: false
    t.string   "job_type",       default: "parallel"
    t.string   "refs"
Douwe Maan's avatar
Douwe Maan committed
250
251
252
    t.datetime "deleted_at"
  end

Valery Sizov's avatar
Valery Sizov committed
253
  create_table "ci_projects", force: :cascade do |t|
254
255
    t.string   "name"
    t.integer  "timeout",                  default: 3600,  null: false
Douwe Maan's avatar
Douwe Maan committed
256
257
    t.datetime "created_at"
    t.datetime "updated_at"
258
259
260
261
    t.string   "token"
    t.string   "default_ref"
    t.string   "path"
    t.boolean  "always_build",             default: false, null: false
Douwe Maan's avatar
Douwe Maan committed
262
    t.integer  "polling_interval"
263
264
    t.boolean  "public",                   default: false, null: false
    t.string   "ssh_url_to_repo"
Douwe Maan's avatar
Douwe Maan committed
265
    t.integer  "gitlab_id"
266
267
268
269
270
271
272
    t.boolean  "allow_git_fetch",          default: true,  null: false
    t.string   "email_recipients",         default: "",    null: false
    t.boolean  "email_add_pusher",         default: true,  null: false
    t.boolean  "email_only_broken_builds", default: true,  null: false
    t.string   "skip_refs"
    t.string   "coverage_regex"
    t.boolean  "shared_runners_enabled",   default: false
Douwe Maan's avatar
Douwe Maan committed
273
274
275
    t.text     "generated_yaml_config"
  end

Valery Sizov's avatar
Valery Sizov committed
276
  create_table "ci_runner_projects", force: :cascade do |t|
277
278
    t.integer  "runner_id",     null: false
    t.integer  "project_id"
Douwe Maan's avatar
Douwe Maan committed
279
280
    t.datetime "created_at"
    t.datetime "updated_at"
281
    t.integer  "gl_project_id"
Douwe Maan's avatar
Douwe Maan committed
282
283
  end

284
  add_index "ci_runner_projects", ["gl_project_id"], name: "index_ci_runner_projects_on_gl_project_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
285
286
  add_index "ci_runner_projects", ["runner_id"], name: "index_ci_runner_projects_on_runner_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
287
  create_table "ci_runners", force: :cascade do |t|
288
    t.string   "token"
Douwe Maan's avatar
Douwe Maan committed
289
290
    t.datetime "created_at"
    t.datetime "updated_at"
291
    t.string   "description"
Douwe Maan's avatar
Douwe Maan committed
292
    t.datetime "contacted_at"
293
294
295
296
297
298
299
    t.boolean  "active",       default: true,  null: false
    t.boolean  "is_shared",    default: false
    t.string   "name"
    t.string   "version"
    t.string   "revision"
    t.string   "platform"
    t.string   "architecture"
300
    t.boolean  "run_untagged", default: true,  null: false
301
    t.boolean  "locked",       default: false, null: false
Douwe Maan's avatar
Douwe Maan committed
302
303
  end

304
  add_index "ci_runners", ["locked"], name: "index_ci_runners_on_locked", using: :btree
James Lopez's avatar
James Lopez committed
305
  add_index "ci_runners", ["token"], name: "index_ci_runners_on_token", using: :btree
306

Valery Sizov's avatar
Valery Sizov committed
307
  create_table "ci_sessions", force: :cascade do |t|
308
    t.string   "session_id", null: false
Douwe Maan's avatar
Douwe Maan committed
309
310
311
312
313
    t.text     "data"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Valery Sizov's avatar
Valery Sizov committed
314
  create_table "ci_taggings", force: :cascade do |t|
315
316
    t.integer  "tag_id"
    t.integer  "taggable_id"
317
    t.string   "taggable_type"
318
    t.integer  "tagger_id"
319
    t.string   "tagger_type"
320
321
322
323
324
325
    t.string   "context",       limit: 128
    t.datetime "created_at"
  end

  add_index "ci_taggings", ["taggable_id", "taggable_type", "context"], name: "index_ci_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree

Valery Sizov's avatar
Valery Sizov committed
326
  create_table "ci_tags", force: :cascade do |t|
327
328
    t.string  "name"
    t.integer "taggings_count", default: 0
329
330
  end

Valery Sizov's avatar
Valery Sizov committed
331
  create_table "ci_trigger_requests", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
332
333
334
335
336
337
338
    t.integer  "trigger_id", null: false
    t.text     "variables"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "commit_id"
  end

Valery Sizov's avatar
Valery Sizov committed
339
  create_table "ci_triggers", force: :cascade do |t|
340
    t.string   "token"
341
    t.integer  "project_id"
Douwe Maan's avatar
Douwe Maan committed
342
343
344
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
345
    t.integer  "gl_project_id"
Douwe Maan's avatar
Douwe Maan committed
346
347
  end

348
  add_index "ci_triggers", ["gl_project_id"], name: "index_ci_triggers_on_gl_project_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
349

Valery Sizov's avatar
Valery Sizov committed
350
  create_table "ci_variables", force: :cascade do |t|
351
    t.integer "project_id"
352
    t.string  "key"
Douwe Maan's avatar
Douwe Maan committed
353
354
    t.text    "value"
    t.text    "encrypted_value"
355
356
    t.string  "encrypted_value_salt"
    t.string  "encrypted_value_iv"
357
    t.integer "gl_project_id"
Douwe Maan's avatar
Douwe Maan committed
358
359
  end

360
  add_index "ci_variables", ["gl_project_id"], name: "index_ci_variables_on_gl_project_id", using: :btree
Douwe Maan's avatar
Douwe Maan committed
361

Valery Sizov's avatar
Valery Sizov committed
362
  create_table "deploy_keys_projects", force: :cascade do |t|
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
363
364
    t.integer  "deploy_key_id", null: false
    t.integer  "project_id",    null: false
365
366
    t.datetime "created_at"
    t.datetime "updated_at"
367
  end
368

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

371
  create_table "deployments", force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
372
    t.integer  "iid",             null: false
373
374
    t.integer  "project_id",      null: false
    t.integer  "environment_id",  null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
375
376
377
    t.string   "ref",             null: false
    t.boolean  "tag",             null: false
    t.string   "sha",             null: false
378
    t.integer  "user_id"
379
380
    t.integer  "deployable_id"
    t.string   "deployable_type"
381
382
383
384
385
386
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "deployments", ["project_id", "environment_id", "iid"], name: "index_deployments_on_project_id_and_environment_id_and_iid", using: :btree
  add_index "deployments", ["project_id", "environment_id"], name: "index_deployments_on_project_id_and_environment_id", using: :btree
387
  add_index "deployments", ["project_id", "iid"], name: "index_deployments_on_project_id_and_iid", unique: true, using: :btree
388
389
  add_index "deployments", ["project_id"], name: "index_deployments_on_project_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
390
  create_table "emails", force: :cascade do |t|
391
392
    t.integer  "user_id",    null: false
    t.string   "email",      null: false
393
394
395
396
397
398
399
    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

400
  create_table "environments", force: :cascade do |t|
401
    t.integer  "project_id"
402
    t.string   "name",             null: false
403
404
    t.datetime "created_at"
    t.datetime "updated_at"
405
    t.string   "external_url"
406
    t.string   "environment_type"
407
408
409
410
  end

  add_index "environments", ["project_id", "name"], name: "index_environments_on_project_id_and_name", using: :btree

Valery Sizov's avatar
Valery Sizov committed
411
  create_table "events", force: :cascade do |t|
412
    t.string   "target_type"
Andrew8xx8's avatar
Andrew8xx8 committed
413
    t.integer  "target_id"
414
    t.string   "title"
Andrew8xx8's avatar
Andrew8xx8 committed
415
416
    t.text     "data"
    t.integer  "project_id"
417
418
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
419
420
421
422
    t.integer  "action"
    t.integer  "author_id"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
423
424
425
426
427
428
429
  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

Valery Sizov's avatar
Valery Sizov committed
430
  create_table "forked_project_links", force: :cascade do |t|
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
431
432
    t.integer  "forked_to_project_id",   null: false
    t.integer  "forked_from_project_id", null: false
433
434
    t.datetime "created_at"
    t.datetime "updated_at"
435
436
  end

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

Valery Sizov's avatar
Valery Sizov committed
439
  create_table "identities", force: :cascade do |t|
440
441
    t.string   "extern_uid"
    t.string   "provider"
442
443
444
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
445
446
447
448
  end

  add_index "identities", ["user_id"], name: "index_identities_on_user_id", using: :btree

449
450
  create_table "issue_metrics", force: :cascade do |t|
    t.integer  "issue_id",                           null: false
451
    t.datetime "first_mentioned_in_commit_at"
452
453
454
455
456
457
458
459
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
    t.datetime "created_at",                         null: false
    t.datetime "updated_at",                         null: false
  end

  add_index "issue_metrics", ["issue_id"], name: "index_issue_metrics", using: :btree

Valery Sizov's avatar
Valery Sizov committed
460
  create_table "issues", force: :cascade do |t|
461
    t.string   "title"
Andrew8xx8's avatar
Andrew8xx8 committed
462
463
464
    t.integer  "assignee_id"
    t.integer  "author_id"
    t.integer  "project_id"
465
466
    t.datetime "created_at"
    t.datetime "updated_at"
467
    t.integer  "position",         default: 0
468
    t.string   "branch_name"
Andrew8xx8's avatar
Andrew8xx8 committed
469
470
    t.text     "description"
    t.integer  "milestone_id"
471
    t.string   "state"
472
    t.integer  "iid"
473
    t.integer  "updated_by_id"
474
    t.boolean  "confidential",     default: false
475
    t.datetime "deleted_at"
476
    t.date     "due_date"
477
    t.integer  "moved_to_id"
478
    t.integer  "lock_version"
479
480
    t.text     "title_html"
    t.text     "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
481
482
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
483
484
  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
485
  add_index "issues", ["confidential"], name: "index_issues_on_confidential", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
486
  add_index "issues", ["created_at"], name: "index_issues_on_created_at", using: :btree
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
487
  add_index "issues", ["deleted_at"], name: "index_issues_on_deleted_at", using: :btree
488
  add_index "issues", ["description"], name: "index_issues_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
489
  add_index "issues", ["due_date"], name: "index_issues_on_due_date", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
490
  add_index "issues", ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
491
  add_index "issues", ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
492
  add_index "issues", ["state"], name: "index_issues_on_state", using: :btree
493
  add_index "issues", ["title"], name: "index_issues_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
494

Valery Sizov's avatar
Valery Sizov committed
495
  create_table "keys", force: :cascade do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
496
    t.integer  "user_id"
497
498
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
499
    t.text     "key"
500
501
502
503
    t.string   "title"
    t.string   "type"
    t.string   "fingerprint"
    t.boolean  "public",      default: false, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
504
505
  end

506
  add_index "keys", ["fingerprint"], name: "index_keys_on_fingerprint", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
507
  add_index "keys", ["user_id"], name: "index_keys_on_user_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
508

Valery Sizov's avatar
Valery Sizov committed
509
  create_table "label_links", force: :cascade do |t|
510
511
    t.integer  "label_id"
    t.integer  "target_id"
512
    t.string   "target_type"
513
514
515
516
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
517
518
519
  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

Valery Sizov's avatar
Valery Sizov committed
520
  create_table "labels", force: :cascade do |t|
521
522
    t.string   "title"
    t.string   "color"
523
524
525
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
526
    t.boolean  "template",         default: false
Tap's avatar
Tap committed
527
    t.string   "description"
Thijs Wouters's avatar
Thijs Wouters committed
528
    t.integer  "priority"
529
    t.text     "description_html"
530
531
  end

Thijs Wouters's avatar
Thijs Wouters committed
532
  add_index "labels", ["priority"], name: "index_labels_on_priority", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
533
  add_index "labels", ["project_id"], name: "index_labels_on_project_id", using: :btree
Ahmad Sherif's avatar
Ahmad Sherif committed
534
  add_index "labels", ["title"], name: "index_labels_on_title", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
535

Valery Sizov's avatar
Valery Sizov committed
536
  create_table "lfs_objects", force: :cascade do |t|
537
538
    t.string   "oid",                  null: false
    t.integer  "size",       limit: 8, null: false
Marin Jankovski's avatar
Marin Jankovski committed
539
540
    t.datetime "created_at"
    t.datetime "updated_at"
541
    t.string   "file"
Marin Jankovski's avatar
Marin Jankovski committed
542
543
  end

544
  add_index "lfs_objects", ["oid"], name: "index_lfs_objects_on_oid", unique: true, using: :btree
Marin Jankovski's avatar
Marin Jankovski committed
545

Valery Sizov's avatar
Valery Sizov committed
546
  create_table "lfs_objects_projects", force: :cascade do |t|
Marin Jankovski's avatar
Marin Jankovski committed
547
548
549
550
551
552
553
554
    t.integer  "lfs_object_id", null: false
    t.integer  "project_id",    null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "lfs_objects_projects", ["project_id"], name: "index_lfs_objects_projects_on_project_id", using: :btree

Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
555
556
557
  create_table "lists", force: :cascade do |t|
    t.integer  "board_id",               null: false
    t.integer  "label_id"
558
559
    t.integer  "list_type",  default: 1, null: false
    t.integer  "position"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
560
561
562
563
    t.datetime "created_at",             null: false
    t.datetime "updated_at",             null: false
  end

564
  add_index "lists", ["board_id", "label_id"], name: "index_lists_on_board_id_and_label_id", unique: true, using: :btree
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
565
566
567
  add_index "lists", ["board_id"], name: "index_lists_on_board_id", using: :btree
  add_index "lists", ["label_id"], name: "index_lists_on_label_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
568
  create_table "members", force: :cascade do |t|
569
570
571
    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
572
    t.integer  "user_id"
573
574
    t.integer  "notification_level", null: false
    t.string   "type"
575
576
    t.datetime "created_at"
    t.datetime "updated_at"
Douwe Maan's avatar
Douwe Maan committed
577
    t.integer  "created_by_id"
578
579
    t.string   "invite_email"
    t.string   "invite_token"
Douwe Maan's avatar
Douwe Maan committed
580
    t.datetime "invite_accepted_at"
Rémy Coutable's avatar
Rémy Coutable committed
581
    t.datetime "requested_at"
582
    t.date     "expires_at"
583
584
  end

585
  add_index "members", ["access_level"], name: "index_members_on_access_level", using: :btree
Douwe Maan's avatar
Douwe Maan committed
586
  add_index "members", ["invite_token"], name: "index_members_on_invite_token", unique: true, using: :btree
587
  add_index "members", ["requested_at"], name: "index_members_on_requested_at", using: :btree
588
589
590
  add_index "members", ["source_id", "source_type"], name: "index_members_on_source_id_and_source_type", using: :btree
  add_index "members", ["user_id"], name: "index_members_on_user_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
591
  create_table "merge_request_diffs", force: :cascade do |t|
592
    t.string   "state"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
593
594
    t.text     "st_commits"
    t.text     "st_diffs"
595
    t.integer  "merge_request_id", null: false
596
597
    t.datetime "created_at"
    t.datetime "updated_at"
598
    t.string   "base_commit_sha"
599
    t.string   "real_size"
Douwe Maan's avatar
Douwe Maan committed
600
601
    t.string   "head_commit_sha"
    t.string   "start_commit_sha"
602
603
  end

604
  add_index "merge_request_diffs", ["merge_request_id"], name: "index_merge_request_diffs_on_merge_request_id", using: :btree
605

606
  create_table "merge_request_metrics", force: :cascade do |t|
Timothy Andrew's avatar
Timothy Andrew committed
607
    t.integer  "merge_request_id",                null: false
608
609
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
Timothy Andrew's avatar
Timothy Andrew committed
610
611
612
613
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
    t.datetime "created_at",                      null: false
    t.datetime "updated_at",                      null: false
614
615
  end

616
  add_index "merge_request_metrics", ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at", using: :btree
617
618
  add_index "merge_request_metrics", ["merge_request_id"], name: "index_merge_request_metrics", using: :btree

Valery Sizov's avatar
Valery Sizov committed
619
  create_table "merge_requests", force: :cascade do |t|
tiagonbotelho's avatar
tiagonbotelho committed
620
621
622
    t.string   "target_branch",                                null: false
    t.string   "source_branch",                                null: false
    t.integer  "source_project_id",                            null: false
Andrew8xx8's avatar
Andrew8xx8 committed
623
624
    t.integer  "author_id"
    t.integer  "assignee_id"
625
    t.string   "title"
626
627
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
628
    t.integer  "milestone_id"
629
630
    t.string   "state"
    t.string   "merge_status"
tiagonbotelho's avatar
tiagonbotelho committed
631
    t.integer  "target_project_id",                            null: false
632
    t.integer  "iid"
633
    t.text     "description"
tiagonbotelho's avatar
tiagonbotelho committed
634
    t.integer  "position",                     default: 0
635
    t.datetime "locked_at"
636
    t.integer  "updated_by_id"
637
    t.text     "merge_error"
638
    t.text     "merge_params"
tiagonbotelho's avatar
tiagonbotelho committed
639
    t.boolean  "merge_when_build_succeeds",    default: false, null: false
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
640
    t.integer  "merge_user_id"
641
    t.string   "merge_commit_sha"
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
642
    t.datetime "deleted_at"
643
    t.string   "in_progress_merge_commit_sha"
644
    t.integer  "lock_version"
645
646
    t.text     "title_html"
    t.text     "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
647
  end
tiagonbotelho's avatar
tiagonbotelho committed
648

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
649
650
651
  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
  add_index "merge_requests", ["created_at"], name: "index_merge_requests_on_created_at", using: :btree
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
652
  add_index "merge_requests", ["deleted_at"], name: "index_merge_requests_on_deleted_at", using: :btree
653
  add_index "merge_requests", ["description"], name: "index_merge_requests_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
654
655
  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
656
  add_index "merge_requests", ["source_project_id"], name: "index_merge_requests_on_source_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
657
  add_index "merge_requests", ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
658
  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
659
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title", using: :btree
660
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
661

662
663
664
665
666
667
668
  create_table "merge_requests_closing_issues", force: :cascade do |t|
    t.integer  "merge_request_id", null: false
    t.integer  "issue_id",         null: false
    t.datetime "created_at",       null: false
    t.datetime "updated_at",       null: false
  end

Timothy Andrew's avatar
Timothy Andrew committed
669
670
671
  add_index "merge_requests_closing_issues", ["issue_id"], name: "index_merge_requests_closing_issues_on_issue_id", using: :btree
  add_index "merge_requests_closing_issues", ["merge_request_id"], name: "index_merge_requests_closing_issues_on_merge_request_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
672
  create_table "milestones", force: :cascade do |t|
673
674
    t.string   "title",            null: false
    t.integer  "project_id",       null: false
Andrew8xx8's avatar
Andrew8xx8 committed
675
676
    t.text     "description"
    t.date     "due_date"
677
678
    t.datetime "created_at"
    t.datetime "updated_at"
679
    t.string   "state"
680
    t.integer  "iid"
681
682
    t.text     "title_html"
    t.text     "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
683
684
  end

685
  add_index "milestones", ["description"], name: "index_milestones_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
686
  add_index "milestones", ["due_date"], name: "index_milestones_on_due_date", using: :btree
687
  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
688
  add_index "milestones", ["project_id"], name: "index_milestones_on_project_id", using: :btree
689
  add_index "milestones", ["title"], name: "index_milestones_on_title", using: :btree
690
  add_index "milestones", ["title"], name: "index_milestones_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
691

Valery Sizov's avatar
Valery Sizov committed
692
  create_table "namespaces", force: :cascade do |t|
693
694
    t.string   "name",                                   null: false
    t.string   "path",                                   null: false
695
    t.integer  "owner_id"
696
697
    t.datetime "created_at"
    t.datetime "updated_at"
698
    t.string   "type"
699
    t.string   "description",            default: "",    null: false
700
    t.string   "avatar"
701
702
703
    t.boolean  "share_with_group_lock",  default: false
    t.integer  "visibility_level",       default: 20,    null: false
    t.boolean  "request_access_enabled", default: true,  null: false
704
    t.datetime "deleted_at"
705
    t.boolean  "lfs_enabled"
706
    t.text     "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
707
708
  end

709
  add_index "namespaces", ["created_at"], name: "index_namespaces_on_created_at", using: :btree
710
  add_index "namespaces", ["deleted_at"], name: "index_namespaces_on_deleted_at", using: :btree
711
  add_index "namespaces", ["name"], name: "index_namespaces_on_name", unique: true, using: :btree
712
  add_index "namespaces", ["name"], name: "index_namespaces_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
713
  add_index "namespaces", ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
714
  add_index "namespaces", ["path"], name: "index_namespaces_on_path", unique: true, using: :btree
715
  add_index "namespaces", ["path"], name: "index_namespaces_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
716
  add_index "namespaces", ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
717

Valery Sizov's avatar
Valery Sizov committed
718
  create_table "notes", force: :cascade do |t|
Andrew8xx8's avatar
Andrew8xx8 committed
719
    t.text     "note"
720
    t.string   "noteable_type"
Andrew8xx8's avatar
Andrew8xx8 committed
721
    t.integer  "author_id"
722
723
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
724
    t.integer  "project_id"
725
726
727
    t.string   "attachment"
    t.string   "line_code"
    t.string   "commit_id"
Andrew8xx8's avatar
Andrew8xx8 committed
728
    t.integer  "noteable_id"
729
    t.boolean  "system",                 default: false, null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
730
    t.text     "st_diff"
731
    t.integer  "updated_by_id"
732
    t.string   "type"
Douwe Maan's avatar
Douwe Maan committed
733
734
    t.text     "position"
    t.text     "original_position"
735
736
    t.datetime "resolved_at"
    t.integer  "resolved_by_id"
737
738
    t.string   "discussion_id"
    t.string   "original_discussion_id"
739
    t.text     "note_html"
Andrew8xx8's avatar
Andrew8xx8 committed
740
741
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
742
743
744
  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
  add_index "notes", ["created_at"], name: "index_notes_on_created_at", using: :btree
745
  add_index "notes", ["discussion_id"], name: "index_notes_on_discussion_id", using: :btree
746
  add_index "notes", ["line_code"], name: "index_notes_on_line_code", using: :btree
747
  add_index "notes", ["note"], name: "index_notes_on_note_trigram", using: :gin, opclasses: {"note"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
748
749
750
751
  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
752
  add_index "notes", ["updated_at"], name: "index_notes_on_updated_at", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
753

754
  create_table "notification_settings", force: :cascade do |t|
755
    t.integer  "user_id",                 null: false
756
757
    t.integer  "source_id"
    t.string   "source_type"
758
759
760
    t.integer  "level",       default: 0, null: false
    t.datetime "created_at",              null: false
    t.datetime "updated_at",              null: false
761
    t.text     "events"
762
763
  end

764
  add_index "notification_settings", ["source_id", "source_type"], name: "index_notification_settings_on_source_id_and_source_type", using: :btree
765
  add_index "notification_settings", ["user_id", "source_id", "source_type"], name: "index_notifications_on_user_id_and_source_id_and_source_type", unique: true, using: :btree
766
767
  add_index "notification_settings", ["user_id"], name: "index_notification_settings_on_user_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
768
  create_table "oauth_access_grants", force: :cascade do |t|
769
770
771
772
773
774
    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
Valery Sizov's avatar
Valery Sizov committed
775
    t.datetime "revoked_at"
776
    t.string   "scopes"
Valery Sizov's avatar
Valery Sizov committed
777
778
779
780
  end

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

Valery Sizov's avatar
Valery Sizov committed
781
  create_table "oauth_access_tokens", force: :cascade do |t|
Valery Sizov's avatar
Valery Sizov committed
782
783
    t.integer  "resource_owner_id"
    t.integer  "application_id"
784
785
    t.string   "token",             null: false
    t.string   "refresh_token"
Valery Sizov's avatar
Valery Sizov committed
786
787
    t.integer  "expires_in"
    t.datetime "revoked_at"
788
789
    t.datetime "created_at",        null: false
    t.string   "scopes"
Valery Sizov's avatar
Valery Sizov committed
790
791
792
793
794
795
  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

Valery Sizov's avatar
Valery Sizov committed
796
  create_table "oauth_applications", force: :cascade do |t|
797
798
799
800
801
    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
Valery Sizov's avatar
Valery Sizov committed
802
803
804
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "owner_id"
805
    t.string   "owner_type"
Valery Sizov's avatar
Valery Sizov committed
806
807
808
809
810
  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

811
812
813
814
  create_table "personal_access_tokens", force: :cascade do |t|
    t.integer  "user_id",                    null: false
    t.string   "token",                      null: false
    t.string   "name",                       null: false
815
816
    t.boolean  "revoked",    default: false
    t.datetime "expires_at"
817
818
    t.datetime "created_at",                 null: false
    t.datetime "updated_at",                 null: false
819
820
821
822
823
  end

  add_index "personal_access_tokens", ["token"], name: "index_personal_access_tokens_on_token", unique: true, using: :btree
  add_index "personal_access_tokens", ["user_id"], name: "index_personal_access_tokens_on_user_id", using: :btree

Felipe Artur's avatar
Felipe Artur committed
824
825
826
827
828
829
830
831
832
833
834
835
836
  create_table "project_features", force: :cascade do |t|
    t.integer  "project_id"
    t.integer  "merge_requests_access_level"
    t.integer  "issues_access_level"
    t.integer  "wiki_access_level"
    t.integer  "snippets_access_level"
    t.integer  "builds_access_level"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "project_features", ["project_id"], name: "index_project_features_on_project_id", using: :btree

837
838
839
840
841
842
  create_table "project_group_links", force: :cascade do |t|
    t.integer  "project_id",                null: false
    t.integer  "group_id",                  null: false