schema.rb 79 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: 20170901071411) 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
    t.integer "reporter_id"
    t.integer "user_id"
    t.text "message"
24 25
    t.datetime "created_at"
    t.datetime "updated_at"
26
    t.text "message_html"
27
    t.integer "cached_markdown_version"
28 29
  end

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

Valery Sizov's avatar
Valery Sizov committed
41
  create_table "application_settings", force: :cascade do |t|
42 43 44 45
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
46 47
    t.datetime "created_at"
    t.datetime "updated_at"
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
    t.string "home_page_url"
    t.integer "default_branch_protection", default: 2
    t.text "restricted_visibility_levels"
    t.boolean "version_check_enabled", default: true
    t.integer "max_attachment_size", default: 10, null: false
    t.integer "default_project_visibility"
    t.integer "default_snippet_visibility"
    t.text "domain_whitelist"
    t.boolean "user_oauth_applications", default: true
    t.string "after_sign_out_path"
    t.integer "session_expire_delay", default: 10080, null: false
    t.text "import_sources"
    t.text "help_page_text"
    t.string "admin_notification_email"
    t.boolean "shared_runners_enabled", default: true, null: false
    t.integer "max_artifacts_size", default: 100, null: false
    t.string "runners_registration_token"
65
    t.integer "max_pages_size", default: 100, null: false
66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
    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
    t.string "recaptcha_site_key"
    t.string "recaptcha_private_key"
    t.integer "metrics_port", default: 8089
    t.boolean "akismet_enabled", default: false
    t.string "akismet_api_key"
    t.integer "metrics_sample_interval", default: 15
    t.boolean "sentry_enabled", default: false
    t.string "sentry_dsn"
    t.boolean "email_author_in_body", default: false
    t.integer "default_group_visibility"
    t.boolean "repository_checks_enabled", default: false
    t.text "shared_runners_text"
    t.integer "metrics_packet_size", default: 1
    t.text "disabled_oauth_sign_in_sources"
    t.string "health_check_access_token"
    t.boolean "send_user_confirmation_email", default: false
    t.integer "container_registry_token_expire_delay", default: 5
    t.text "after_sign_up_text"
Valery Sizov's avatar
Valery Sizov committed
92
    t.boolean "user_default_external", default: false, null: false
93
    t.string "repository_storages", default: "default"
94 95 96
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
97
    t.boolean "usage_ping_enabled", default: true, null: false
98 99 100 101 102 103
    t.boolean "koding_enabled"
    t.string "koding_url"
    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"
104 105 106 107 108
    t.boolean "housekeeping_enabled", default: true, null: false
    t.boolean "housekeeping_bitmaps_enabled", default: true, null: false
    t.integer "housekeeping_incremental_repack_period", default: 10, null: false
    t.integer "housekeeping_full_repack_period", default: 50, null: false
    t.integer "housekeeping_gc_period", default: 200, null: false
109 110 111
    t.boolean "sidekiq_throttling_enabled", default: false
    t.string "sidekiq_throttling_queues"
    t.decimal "sidekiq_throttling_factor"
112
    t.boolean "html_emails_enabled", default: true
113 114
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
115
    t.integer "terminal_max_session_time", default: 0, null: false
116 117 118
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
119 120
    t.string "default_artifacts_expire_in", default: "0", null: false
    t.string "uuid"
121
    t.decimal "polling_interval_multiplier", default: 1.0, null: false
122
    t.integer "cached_markdown_version"
123 124
    t.boolean "clientside_sentry_enabled", default: false, null: false
    t.string "clientside_sentry_dsn"
Pawel Chojnacki's avatar
Pawel Chojnacki committed
125
    t.boolean "prometheus_metrics_enabled", default: false, null: false
126 127
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
128
    t.integer "performance_bar_allowed_group_id"
129
    t.boolean "password_authentication_enabled"
130
    t.boolean "project_export_enabled", default: true, null: false
131
    t.boolean "hashed_storage_enabled", default: false, null: false
132 133 134 135
    t.integer "rsa_key_restriction", default: 0, null: false
    t.integer "dsa_key_restriction", default: 0, null: false
    t.integer "ecdsa_key_restriction", default: 0, null: false
    t.integer "ed25519_key_restriction", default: 0, null: false
136 137
  end

Valery Sizov's avatar
Valery Sizov committed
138
  create_table "audit_events", force: :cascade do |t|
139 140 141 142 143
    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"
144 145 146 147 148 149
    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

150
  create_table "award_emoji", force: :cascade do |t|
151 152 153 154
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
155 156 157 158
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Z.J. van de Weg's avatar
Z.J. van de Weg committed
159
  add_index "award_emoji", ["awardable_type", "awardable_id"], name: "index_award_emoji_on_awardable_type_and_awardable_id", using: :btree
160
  add_index "award_emoji", ["user_id", "name"], name: "index_award_emoji_on_user_id_and_name", using: :btree
161

162
  create_table "boards", force: :cascade do |t|
163
    t.integer "project_id", null: false
164 165 166 167 168 169
    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
170
  create_table "broadcast_messages", force: :cascade do |t|
171
    t.text "message", null: false
172 173 174 175
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
176 177
    t.string "color"
    t.string "font"
178
    t.text "message_html", null: false
179
    t.integer "cached_markdown_version"
180
  end
181

182 183
  add_index "broadcast_messages", ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id", using: :btree

184 185 186
  create_table "chat_names", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "service_id", null: false
187
    t.string "team_id", null: false
188
    t.string "team_domain"
189
    t.string "chat_id", null: false
190
    t.string "chat_name"
191
    t.datetime "last_used_at"
192 193
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
194
  end
195

196
  add_index "chat_names", ["service_id", "team_id", "chat_id"], name: "index_chat_names_on_service_id_and_team_id_and_chat_id", unique: true, using: :btree
197 198
  add_index "chat_names", ["user_id", "service_id"], name: "index_chat_names_on_user_id_and_service_id", unique: true, using: :btree

199
  create_table "chat_teams", force: :cascade do |t|
200
    t.integer "namespace_id", null: false
201 202 203 204
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
205 206
  end

207
  add_index "chat_teams", ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true, using: :btree
208

Valery Sizov's avatar
Valery Sizov committed
209
  create_table "ci_builds", force: :cascade do |t|
210
    t.string "status"
211
    t.datetime "finished_at"
212
    t.text "trace"
213 214 215
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232
    t.integer "runner_id"
    t.float "coverage"
    t.integer "commit_id"
    t.text "commands"
    t.string "name"
    t.text "options"
    t.boolean "allow_failure", default: false, null: false
    t.string "stage"
    t.integer "trigger_request_id"
    t.integer "stage_idx"
    t.boolean "tag"
    t.string "ref"
    t.integer "user_id"
    t.string "type"
    t.string "target_url"
    t.string "description"
    t.text "artifacts_file"
233
    t.integer "project_id"
234 235
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
236
    t.datetime "erased_at"
237
    t.datetime "artifacts_expire_at"
238 239 240 241
    t.string "environment"
    t.integer "artifacts_size", limit: 8
    t.string "when"
    t.text "yaml_variables"
242
    t.datetime "queued_at"
243
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
244
    t.integer "lock_version"
245
    t.string "coverage_regex"
246
    t.integer "auto_canceled_by_id"
247
    t.boolean "retried"
248
    t.integer "stage_id"
249
    t.boolean "protected"
250 251
  end

252
  add_index "ci_builds", ["auto_canceled_by_id"], name: "index_ci_builds_on_auto_canceled_by_id", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
253
  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
254
  add_index "ci_builds", ["commit_id", "status", "type"], name: "index_ci_builds_on_commit_id_and_status_and_type", using: :btree
255 256
  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
257
  add_index "ci_builds", ["project_id"], name: "index_ci_builds_on_project_id", using: :btree
258
  add_index "ci_builds", ["protected"], name: "index_ci_builds_on_protected", using: :btree
259
  add_index "ci_builds", ["runner_id"], name: "index_ci_builds_on_runner_id", using: :btree
260
  add_index "ci_builds", ["stage_id"], name: "index_ci_builds_on_stage_id", using: :btree
261
  add_index "ci_builds", ["status", "type", "runner_id"], name: "index_ci_builds_on_status_and_type_and_runner_id", using: :btree
262
  add_index "ci_builds", ["status"], name: "index_ci_builds_on_status", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
263
  add_index "ci_builds", ["token"], name: "index_ci_builds_on_token", unique: true, using: :btree
264
  add_index "ci_builds", ["updated_at"], name: "index_ci_builds_on_updated_at", using: :btree
265
  add_index "ci_builds", ["user_id"], name: "index_ci_builds_on_user_id", using: :btree
266

Shinya Maeda's avatar
fix  
Shinya Maeda committed
267
  create_table "ci_group_variables", force: :cascade do |t|
268 269 270 271 272
    t.string "key", null: false
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
Shinya Maeda's avatar
fix  
Shinya Maeda committed
273 274
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
275 276 277 278
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
279
  add_index "ci_group_variables", ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true, using: :btree
280

Shinya Maeda's avatar
fix  
Shinya Maeda committed
281
  create_table "ci_pipeline_schedule_variables", force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
282 283 284 285 286
    t.string "key", null: false
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
Shinya Maeda's avatar
fix  
Shinya Maeda committed
287 288 289
    t.integer "pipeline_schedule_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
Shinya Maeda's avatar
Shinya Maeda committed
290 291
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
292
  add_index "ci_pipeline_schedule_variables", ["pipeline_schedule_id", "key"], name: "index_ci_pipeline_schedule_variables_on_schedule_id_and_key", unique: true, using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
293

294 295 296 297 298 299 300 301 302 303
  create_table "ci_pipeline_schedules", force: :cascade do |t|
    t.string "description"
    t.string "ref"
    t.string "cron"
    t.string "cron_timezone"
    t.datetime "next_run_at"
    t.integer "project_id"
    t.integer "owner_id"
    t.boolean "active", default: true
    t.datetime "deleted_at"
304 305 306 307
    t.datetime "created_at"
    t.datetime "updated_at"
  end

308 309
  add_index "ci_pipeline_schedules", ["next_run_at", "active"], name: "index_ci_pipeline_schedules_on_next_run_at_and_active", using: :btree
  add_index "ci_pipeline_schedules", ["project_id"], name: "index_ci_pipeline_schedules_on_project_id", using: :btree
310

Shinya Maeda's avatar
init  
Shinya Maeda committed
311 312 313 314 315 316 317 318 319 320 321
  create_table "ci_pipeline_variables", force: :cascade do |t|
    t.string "key", null: false
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
    t.integer "pipeline_id", null: false
  end

  add_index "ci_pipeline_variables", ["pipeline_id", "key"], name: "index_ci_pipeline_variables_on_pipeline_id_and_key", unique: true, using: :btree

322
  create_table "ci_pipelines", force: :cascade do |t|
323 324 325
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
326 327
    t.datetime "created_at"
    t.datetime "updated_at"
328 329
    t.boolean "tag", default: false
    t.text "yaml_errors"
330
    t.datetime "committed_at"
331
    t.integer "project_id"
332
    t.string "status"
333 334
    t.datetime "started_at"
    t.datetime "finished_at"
335 336
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
337
    t.integer "lock_version"
338
    t.integer "auto_canceled_by_id"
339
    t.integer "pipeline_schedule_id"
340
    t.integer "source"
341
    t.boolean "protected"
342 343
  end

344
  add_index "ci_pipelines", ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id", using: :btree
345
  add_index "ci_pipelines", ["pipeline_schedule_id"], name: "index_ci_pipelines_on_pipeline_schedule_id", using: :btree
346 347 348 349 350
  add_index "ci_pipelines", ["project_id", "ref", "status"], name: "index_ci_pipelines_on_project_id_and_ref_and_status", using: :btree
  add_index "ci_pipelines", ["project_id", "sha"], name: "index_ci_pipelines_on_project_id_and_sha", using: :btree
  add_index "ci_pipelines", ["project_id"], name: "index_ci_pipelines_on_project_id", using: :btree
  add_index "ci_pipelines", ["status"], name: "index_ci_pipelines_on_status", using: :btree
  add_index "ci_pipelines", ["user_id"], name: "index_ci_pipelines_on_user_id", using: :btree
351

Valery Sizov's avatar
Valery Sizov committed
352
  create_table "ci_runner_projects", force: :cascade do |t|
353
    t.integer "runner_id", null: false
354 355
    t.datetime "created_at"
    t.datetime "updated_at"
356
    t.integer "project_id"
357 358
  end

359
  add_index "ci_runner_projects", ["project_id"], name: "index_ci_runner_projects_on_project_id", using: :btree
360 361
  add_index "ci_runner_projects", ["runner_id"], name: "index_ci_runner_projects_on_runner_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
362
  create_table "ci_runners", force: :cascade do |t|
363
    t.string "token"
364 365
    t.datetime "created_at"
    t.datetime "updated_at"
366
    t.string "description"
367
    t.datetime "contacted_at"
368 369 370 371 372 373 374 375 376
    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"
    t.boolean "run_untagged", default: true, null: false
    t.boolean "locked", default: false, null: false
377
    t.integer "access_level", default: 0, null: false
378 379
  end

380
  add_index "ci_runners", ["contacted_at"], name: "index_ci_runners_on_contacted_at", using: :btree
381
  add_index "ci_runners", ["is_shared"], name: "index_ci_runners_on_is_shared", using: :btree
382
  add_index "ci_runners", ["locked"], name: "index_ci_runners_on_locked", using: :btree
James Lopez's avatar
James Lopez committed
383
  add_index "ci_runners", ["token"], name: "index_ci_runners_on_token", using: :btree
384

385 386 387
  create_table "ci_stages", force: :cascade do |t|
    t.integer "project_id"
    t.integer "pipeline_id"
388 389
    t.datetime "created_at"
    t.datetime "updated_at"
390
    t.string "name"
391
    t.integer "status"
392
    t.integer "lock_version"
393 394
  end

395
  add_index "ci_stages", ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", using: :btree
396 397
  add_index "ci_stages", ["pipeline_id"], name: "index_ci_stages_on_pipeline_id", using: :btree
  add_index "ci_stages", ["project_id"], name: "index_ci_stages_on_project_id", using: :btree
398

Valery Sizov's avatar
Valery Sizov committed
399
  create_table "ci_trigger_requests", force: :cascade do |t|
400 401
    t.integer "trigger_id", null: false
    t.text "variables"
402 403
    t.datetime "created_at"
    t.datetime "updated_at"
404
    t.integer "commit_id"
405 406
  end

407 408
  add_index "ci_trigger_requests", ["commit_id"], name: "index_ci_trigger_requests_on_commit_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
409
  create_table "ci_triggers", force: :cascade do |t|
410
    t.string "token"
411 412 413
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
414
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
415 416
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
417
    t.string "ref"
418 419
  end

420
  add_index "ci_triggers", ["project_id"], name: "index_ci_triggers_on_project_id", using: :btree
421

Valery Sizov's avatar
Valery Sizov committed
422
  create_table "ci_variables", force: :cascade do |t|
423
    t.string "key", null: false
424 425 426 427
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
428
    t.integer "project_id", null: false
429
    t.boolean "protected", default: false, null: false
430
    t.string "environment_scope", default: "*", null: false
431 432
  end

433
  add_index "ci_variables", ["project_id", "key", "environment_scope"], name: "index_ci_variables_on_project_id_and_key_and_environment_scope", unique: true, using: :btree
434

435
  create_table "container_repositories", force: :cascade do |t|
436 437 438 439
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
440 441
  end

442 443 444
  add_index "container_repositories", ["project_id", "name"], name: "index_container_repositories_on_project_id_and_name", unique: true, using: :btree
  add_index "container_repositories", ["project_id"], name: "index_container_repositories_on_project_id", using: :btree

445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467
  create_table "conversational_development_index_metrics", force: :cascade do |t|
    t.float "leader_issues", null: false
    t.float "instance_issues", null: false
    t.float "leader_notes", null: false
    t.float "instance_notes", null: false
    t.float "leader_milestones", null: false
    t.float "instance_milestones", null: false
    t.float "leader_boards", null: false
    t.float "instance_boards", null: false
    t.float "leader_merge_requests", null: false
    t.float "instance_merge_requests", null: false
    t.float "leader_ci_pipelines", null: false
    t.float "instance_ci_pipelines", null: false
    t.float "leader_environments", null: false
    t.float "instance_environments", null: false
    t.float "leader_deployments", null: false
    t.float "instance_deployments", null: false
    t.float "leader_projects_prometheus_active", null: false
    t.float "instance_projects_prometheus_active", null: false
    t.float "leader_service_desk_issues", null: false
    t.float "instance_service_desk_issues", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
468 469 470 471 472 473 474 475 476 477
    t.float "percentage_boards", default: 0.0, null: false
    t.float "percentage_ci_pipelines", default: 0.0, null: false
    t.float "percentage_deployments", default: 0.0, null: false
    t.float "percentage_environments", default: 0.0, null: false
    t.float "percentage_issues", default: 0.0, null: false
    t.float "percentage_merge_requests", default: 0.0, null: false
    t.float "percentage_milestones", default: 0.0, null: false
    t.float "percentage_notes", default: 0.0, null: false
    t.float "percentage_projects_prometheus_active", default: 0.0, null: false
    t.float "percentage_service_desk_issues", default: 0.0, null: false
478
  end
479

Valery Sizov's avatar
Valery Sizov committed
480
  create_table "deploy_keys_projects", force: :cascade do |t|
481 482
    t.integer "deploy_key_id", null: false
    t.integer "project_id", null: false
483 484
    t.datetime "created_at"
    t.datetime "updated_at"
485
  end
486

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

489
  create_table "deployments", force: :cascade do |t|
Valery Sizov's avatar
Valery Sizov committed
490 491 492 493 494 495
    t.integer "iid", null: false
    t.integer "project_id", null: false
    t.integer "environment_id", null: false
    t.string "ref", null: false
    t.boolean "tag", null: false
    t.string "sha", null: false
496
    t.integer "user_id"
Valery Sizov's avatar
Valery Sizov committed
497 498
    t.integer "deployable_id"
    t.string "deployable_type"
499 500
    t.datetime "created_at"
    t.datetime "updated_at"
501
    t.string "on_stop"
502 503
  end

504
  add_index "deployments", ["created_at"], name: "index_deployments_on_created_at", using: :btree
505
  add_index "deployments", ["project_id", "environment_id", "iid"], name: "index_deployments_on_project_id_and_environment_id_and_iid", using: :btree
506
  add_index "deployments", ["project_id", "iid"], name: "index_deployments_on_project_id_and_iid", unique: true, using: :btree
507

Valery Sizov's avatar
Valery Sizov committed
508
  create_table "emails", force: :cascade do |t|
509 510
    t.integer "user_id", null: false
    t.string "email", null: false
511 512 513 514 515 516 517
    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

518
  create_table "environments", force: :cascade do |t|
519 520
    t.integer "project_id"
    t.string "name", null: false
521 522
    t.datetime "created_at"
    t.datetime "updated_at"
523 524
    t.string "external_url"
    t.string "environment_type"
525
    t.string "state", default: "available", null: false
Nick Thomas's avatar
Nick Thomas committed
526
    t.string "slug", null: false
527 528
  end

529
  add_index "environments", ["project_id", "name"], name: "index_environments_on_project_id_and_name", unique: true, using: :btree
Nick Thomas's avatar
Nick Thomas committed
530
  add_index "environments", ["project_id", "slug"], name: "index_environments_on_project_id_and_slug", unique: true, using: :btree
531

Valery Sizov's avatar
Valery Sizov committed
532
  create_table "events", force: :cascade do |t|
533 534 535 536 537
    t.string "target_type"
    t.integer "target_id"
    t.string "title"
    t.text "data"
    t.integer "project_id"
538 539
    t.datetime "created_at"
    t.datetime "updated_at"
540 541
    t.integer "action"
    t.integer "author_id"
Andrew8xx8's avatar
Andrew8xx8 committed
542 543
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
544 545 546
  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
547
  add_index "events", ["project_id", "id"], name: "index_events_on_project_id_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
548 549 550
  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

551 552 553 554 555 556 557 558 559 560 561 562
  create_table "events_for_migration", force: :cascade do |t|
    t.integer "project_id"
    t.integer "author_id", null: false
    t.integer "target_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "action", limit: 2, null: false
    t.string "target_type"
  end

  add_index "events_for_migration", ["action"], name: "index_events_for_migration_on_action", using: :btree
  add_index "events_for_migration", ["author_id"], name: "index_events_for_migration_on_author_id", using: :btree
563
  add_index "events_for_migration", ["project_id", "id"], name: "index_events_for_migration_on_project_id_and_id", using: :btree
564 565
  add_index "events_for_migration", ["target_type", "target_id"], name: "index_events_for_migration_on_target_type_and_target_id", using: :btree

566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583
  create_table "feature_gates", force: :cascade do |t|
    t.string "feature_key", null: false
    t.string "key", null: false
    t.string "value"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "feature_gates", ["feature_key", "key", "value"], name: "index_feature_gates_on_feature_key_and_key_and_value", unique: true, using: :btree

  create_table "features", force: :cascade do |t|
    t.string "key", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "features", ["key"], name: "index_features_on_key", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
584
  create_table "forked_project_links", force: :cascade do |t|
585 586
    t.integer "forked_to_project_id", null: false
    t.integer "forked_from_project_id", null: false
587 588
    t.datetime "created_at"
    t.datetime "updated_at"
589 590
  end

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

Alexis Reigel's avatar
Alexis Reigel committed
593 594 595
  create_table "gpg_keys", force: :cascade do |t|
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
596
    t.integer "user_id"
597 598
    t.binary "primary_keyid"
    t.binary "fingerprint"
599
    t.text "key"
Alexis Reigel's avatar
Alexis Reigel committed
600 601
  end

602 603
  add_index "gpg_keys", ["fingerprint"], name: "index_gpg_keys_on_fingerprint", unique: true, using: :btree
  add_index "gpg_keys", ["primary_keyid"], name: "index_gpg_keys_on_primary_keyid", unique: true, using: :btree
Alexis Reigel's avatar
Alexis Reigel committed
604 605
  add_index "gpg_keys", ["user_id"], name: "index_gpg_keys_on_user_id", using: :btree

606
  create_table "gpg_signatures", force: :cascade do |t|
607 608
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
609 610 611
    t.integer "project_id"
    t.integer "gpg_key_id"
    t.boolean "valid_signature"
612 613
    t.binary "commit_sha"
    t.binary "gpg_key_primary_keyid"
614 615
    t.text "gpg_key_user_name"
    t.text "gpg_key_user_email"
616 617
  end

618
  add_index "gpg_signatures", ["commit_sha"], name: "index_gpg_signatures_on_commit_sha", unique: true, using: :btree
619 620 621 622
  add_index "gpg_signatures", ["gpg_key_id"], name: "index_gpg_signatures_on_gpg_key_id", using: :btree
  add_index "gpg_signatures", ["gpg_key_primary_keyid"], name: "index_gpg_signatures_on_gpg_key_primary_keyid", using: :btree
  add_index "gpg_signatures", ["project_id"], name: "index_gpg_signatures_on_project_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
623
  create_table "identities", force: :cascade do |t|
624 625 626
    t.string "extern_uid"
    t.string "provider"
    t.integer "user_id"
627 628
    t.datetime "created_at"
    t.datetime "updated_at"
629 630 631 632
  end

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

633
  create_table "issue_assignees", id: false, force: :cascade do |t|
634 635 636 637 638 639 640
    t.integer "user_id", null: false
    t.integer "issue_id", null: false
  end

  add_index "issue_assignees", ["issue_id", "user_id"], name: "index_issue_assignees_on_issue_id_and_user_id", unique: true, using: :btree
  add_index "issue_assignees", ["user_id"], name: "index_issue_assignees_on_user_id", using: :btree

641
  create_table "issue_metrics", force: :cascade do |t|
642
    t.integer "issue_id", null: false
643
    t.datetime "first_mentioned_in_commit_at"
644 645
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
646 647
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
648 649 650 651
  end

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

Valery Sizov's avatar
Valery Sizov committed
652
  create_table "issues", force: :cascade do |t|
653 654 655 656
    t.string "title"
    t.integer "assignee_id"
    t.integer "author_id"
    t.integer "project_id"
657 658
    t.datetime "created_at"
    t.datetime "updated_at"
659 660 661 662 663 664 665
    t.string "branch_name"
    t.text "description"
    t.integer "milestone_id"
    t.string "state"
    t.integer "iid"
    t.integer "updated_by_id"
    t.boolean "confidential", default: false
666
    t.datetime "deleted_at"
667 668 669 670 671
    t.date "due_date"
    t.integer "moved_to_id"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
672
    t.integer "time_estimate"
673
    t.integer "relative_position"
674
    t.datetime "closed_at"
675
    t.integer "cached_markdown_version"
676 677
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
Andrew8xx8's avatar
Andrew8xx8 committed
678 679
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
680 681
  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
682
  add_index "issues", ["confidential"], name: "index_issues_on_confidential", using: :btree
683
  add_index "issues", ["deleted_at"], name: "index_issues_on_deleted_at", using: :btree
684
  add_index "issues", ["description"], name: "index_issues_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
685
  add_index "issues", ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
686 687
  add_index "issues", ["project_id", "created_at", "id", "state"], name: "index_issues_on_project_id_and_created_at_and_id_and_state", using: :btree
  add_index "issues", ["project_id", "due_date", "id", "state"], name: "index_issues_on_project_id_and_due_date_and_id_and_state", using: :btree
688
  add_index "issues", ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
689
  add_index "issues", ["project_id", "updated_at", "id", "state"], name: "index_issues_on_project_id_and_updated_at_and_id_and_state", using: :btree
690
  add_index "issues", ["relative_position"], name: "index_issues_on_relative_position", using: :btree
691
  add_index "issues", ["state"], name: "index_issues_on_state", using: :btree
692
  add_index "issues", ["title"], name: "index_issues_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
693

Valery Sizov's avatar
Valery Sizov committed
694
  create_table "keys", force: :cascade do |t|
695
    t.integer "user_id"
696 697
    t.datetime "created_at"
    t.datetime "updated_at"
698 699 700 701 702
    t.text "key"
    t.string "title"
    t.string "type"
    t.string "fingerprint"
    t.boolean "public", default: false, null: false
703
    t.boolean "can_push", default: false, null: false
704
    t.datetime "last_used_at"
Andrew8xx8's avatar
Andrew8xx8 committed
705 706
  end

707
  add_index "keys", ["fingerprint"], name: "index_keys_on_fingerprint", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
708
  add_index "keys", ["user_id"], name: "index_keys_on_user_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
709

Valery Sizov's avatar
Valery Sizov committed
710
  create_table "label_links", force: :cascade do |t|
711 712 713
    t.integer "label_id"
    t.integer "target_id"
    t.string "target_type"
714 715 716 717
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
718 719 720
  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

721 722 723 724 725 726 727 728 729 730 731
  create_table "label_priorities", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "label_id", null: false
    t.integer "priority", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "label_priorities", ["priority"], name: "index_label_priorities_on_priority", using: :btree
  add_index "label_priorities", ["project_id", "label_id"], name: "index_label_priorities_on_project_id_and_label_id", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
732
  create_table "labels", force: :cascade do |t|
733 734 735
    t.string "title"
    t.string "color"
    t.integer "project_id"
736 737
    t.datetime "created_at"
    t.datetime "updated_at"
738 739 740
    t.boolean "template", default: false
    t.string "description"
    t.text "description_html"
741 742
    t.string "type"
    t.integer "group_id"
743
    t.integer "cached_markdown_version"
744 745
  end

746
  add_index "labels", ["group_id", "project_id", "title"], name: "index_labels_on_group_id_and_project_id_and_title", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
747
  add_index "labels", ["project_id"], name: "index_labels_on_project_id", using: :btree
Ahmad Sherif's avatar
Ahmad Sherif committed
748
  add_index "labels", ["title"], name: "index_labels_on_title", using: :btree
749
  add_index "labels", ["type", "project_id"], name: "index_labels_on_type_and_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
750

Valery Sizov's avatar
Valery Sizov committed
751
  create_table "lfs_objects", force: :cascade do |t|
752 753
    t.string "oid", null: false
    t.integer "size", limit: 8, null: false
Marin Jankovski's avatar
Marin Jankovski committed
754 755
    t.datetime "created_at"
    t.datetime "updated_at"
756
    t.string "file"
Marin Jankovski's avatar
Marin Jankovski committed
757 758
  end

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

Valery Sizov's avatar
Valery Sizov committed
761
  create_table "lfs_objects_projects", force: :cascade do |t|
762 763
    t.integer "lfs_object_id", null: false
    t.integer "project_id", null: false
Marin Jankovski's avatar
Marin Jankovski committed
764 765 766 767 768 769
    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

770
  create_table "lists", force: :cascade do |t|
771 772 773 774 775 776
    t.integer "board_id", null: false
    t.integer "label_id"
    t.integer "list_type", default: 1, null: false
    t.integer "position"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
777 778
  end

779
  add_index "lists", ["board_id", "label_id"], name: "index_lists_on_board_id_and_label_id", unique: true, using: :btree
780 781
  add_index "lists", ["label_id"], name: "index_lists_on_label_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
782
  create_table "members", force: :cascade do |t|
783 784 785 786 787 788
    t.integer "access_level", null: false
    t.integer "source_id", null: false
    t.string "source_type", null: false
    t.integer "user_id"
    t.integer "notification_level", null: false
    t.string "type"
789 790
    t.datetime "created_at"
    t.datetime "updated_at"
791 792 793
    t.integer "created_by_id"
    t.string "invite_email"
    t.string "invite_token"
Douwe Maan's avatar
Douwe Maan committed
794
    t.datetime "invite_accepted_at"
795
    t.datetime "requested_at"
796
    t.date "expires_at"
797 798
  end

799
  add_index "members", ["access_level"], name: "index_members_on_access_level", using: :btree
Douwe Maan's avatar
Douwe Maan committed
800
  add_index "members", ["invite_token"], name: "index_members_on_invite_token", unique: true, using: :btree
801
  add_index "members", ["requested_at"], name: "index_members_on_requested_at", using: :btree
802 803 804
  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

805 806 807 808 809 810 811 812 813 814 815 816 817 818 819
  create_table "merge_request_diff_commits", id: false, force: :cascade do |t|
    t.datetime "authored_date"
    t.datetime "committed_date"
    t.integer "merge_request_diff_id", null: false
    t.integer "relative_order", null: false
    t.binary "sha", null: false
    t.text "author_name"
    t.text "author_email"
    t.text "committer_name"
    t.text "committer_email"
    t.text "message"
  end

  add_index "merge_request_diff_commits", ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_commits_on_mr_diff_id_and_order", unique: true, using: :btree

820 821 822 823 824 825 826 827 828 829 830 831
  create_table "merge_request_diff_files", id: false, force: :cascade do |t|
    t.integer "merge_request_diff_id", null: false
    t.integer "relative_order", null: false
    t.boolean "new_file", null: false
    t.boolean "renamed_file", null: false
    t.boolean "deleted_file", null: false
    t.boolean "too_large", null: false
    t.string "a_mode", null: false
    t.string "b_mode", null: false
    t.text "new_path", null: false
    t.text "old_path", null: false
    t.text "diff", null: false
832
    t.boolean "binary"
833 834 835 836
  end

  add_index "merge_request_diff_files", ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_files_on_mr_diff_id_and_order", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
837
  create_table "merge_request_diffs", force: :cascade do |t|
838 839 840 841
    t.string "state"
    t.text "st_commits"
    t.text "st_diffs"
    t.integer "merge_request_id", null: false
842 843
    t.datetime "created_at"
    t.datetime "updated_at"
844 845 846 847
    t.string "base_commit_sha"
    t.string "real_size"
    t.string "head_commit_sha"
    t.string "start_commit_sha"
848 849
  end

850
  add_index "merge_request_diffs", ["merge_request_id"], name: "index_merge_request_diffs_on_merge_request_id", using: :btree
851

852
  create_table "merge_request_metrics", force: :cascade do |t|
853
    t.integer "merge_request_id", null: false
854 855
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
Timothy Andrew's avatar
Timothy Andrew committed
856 857
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
858 859
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
860
    t.integer "pipeline_id"
861 862
  end

863
  add_index "merge_request_metrics", ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at", using: :btree
864
  add_index "merge_request_metrics", ["merge_request_id"], name: "index_merge_request_metrics", using: :btree
865
  add_index "merge_request_metrics", ["pipeline_id"], name: "index_merge_request_metrics_on_pipeline_id", using: :btree
866

Valery Sizov's avatar
Valery Sizov committed
867
  create_table "merge_requests", force: :cascade do |t|
868 869 870 871 872 873
    t.string "target_branch", null: false
    t.string "source_branch", null: false
    t.integer "source_project_id", null: false
    t.integer "author_id"
    t.integer "assignee_id"
    t.string "title"
874 875
    t.datetime "created_at"
    t.datetime "updated_at"
876 877 878 879 880 881 882 883 884
    t.integer "milestone_id"
    t.string "state"
    t.string "merge_status"
    t.integer "target_project_id", null: false
    t.integer "iid"
    t.text "description"
    t.integer "updated_by_id"
    t.text "merge_error"
    t.text "merge_params"
885
    t.boolean "merge_when_pipeline_succeeds", default: false, null: false
886 887
    t.integer "merge_user_id"
    t.string "merge_commit_sha"
888
    t.datetime "deleted_at"
889
    t.string "in_progress_merge_commit_sha"
Valery Sizov's avatar
Valery Sizov committed
890
    t.integer "lock_version"
891 892
    t.text "title_html"
    t.text "description_html"
893
    t.integer "time_estimate"
894
    t.integer "cached_markdown_version"
895 896
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
897
    t.integer "head_pipeline_id"
898
    t.boolean "ref_fetched"
899
    t.string "merge_jid"
Andrew8xx8's avatar
Andrew8xx8 committed
900
  end
tiagonbotelho's avatar
tiagonbotelho committed
901

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
902 903 904
  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
905
  add_index "merge_requests", ["deleted_at"], name: "index_merge_requests_on_deleted_at", using: :btree
906
  add_index "merge_requests", ["description"], name: "index_merge_requests_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
907
  add_index "merge_requests", ["head_pipeline_id"], name: "index_merge_requests_on_head_pipeline_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
908 909
  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
910
  add_index "merge_requests", ["source_project_id"], name: "index_merge_requests_on_source_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
911
  add_index "merge_requests", ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
912
  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
913
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title", using: :btree
914
  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
915

916
  create_table "merge_requests_closing_issues", force: :cascade do |t|
917 918 919 920
    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
921 922
  end

Timothy Andrew's avatar
Timothy Andrew committed
923 924 925
  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
926
  create_table "milestones", force: :cascade do |t|
927
    t.string "title", null: false
Felipe Artur's avatar
Felipe Artur committed
928
    t.integer "project_id"
929 930
    t.text "description"
    t.date "due_date"
931 932
    t.datetime "created_at"
    t.datetime "updated_at"
933 934 935 936
    t.string "state"
    t.integer "iid"
    t.text "title_html"
    t.text "description_html"
937
    t.date "start_date"
938
    t.integer "cached_markdown_version"
Felipe Artur's avatar
Felipe Artur committed
939
    t.integer "group_id"
Andrew8xx8's avatar
Andrew8xx8 committed
940 941
  end

942
  add_index "milestones", ["description"], name: "index_milestones_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
943
  add_index "milestones", ["due_date"], name: "index_milestones_on_due_date", using: :btree
Felipe Artur's avatar
Felipe Artur committed
944
  add_index "milestones", ["group_id"], name: "index_milestones_on_group_id", using: :btree
945
  add_index "milestones", ["project_id", "iid"], name: "index_milestones_on_project_id_and_iid", unique: true, using: :btree
946
  add_index "milestones", ["title"], name: "index_milestones_on_title", using: :btree
947
  add_index "milestones", ["title"], name: "index_milestones_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
948

Valery Sizov's avatar
Valery Sizov committed
949
  create_table "namespaces", force: :cascade do |t|
950 951 952
    t.string "name", null: false
    t.string "path", null: false
    t.integer "owner_id"
953 954
    t.datetime "created_at"
    t.datetime "updated_at"
955 956 957 958 959
    t.string "type"
    t.string "description", default: "", null: false
    t.string "avatar"
    t.boolean "share_with_group_lock", default: false
    t.integer "visibility_level", default: 20, null: false
960
    t.boolean "request_access_enabled", default: false, null: false
961
    t.datetime "deleted_at"
Nick Thomas's avatar
Nick Thomas committed
962
    t.text "description_html"
963
    t.boolean "lfs_enabled"
964
    t.integer "parent_id"
965 966
    t.boolean "require_two_factor_authentication", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
967
    t.integer "cached_markdown_version"
Andrew8xx8's avatar
Andrew8xx8 committed
968 969
  end

970
  add_index "namespaces", ["created_at"], name: "index_namespaces_on_created_at", using: :btree
971
  add_index "namespaces", ["deleted_at"], name: "index_namespaces_on_deleted_at", using: :btree
972
  add_index "namespaces", ["name", "parent_id"], name: "index_namespaces_on_name_and_parent_id", unique: true, using: :btree
973
  add_index "namespaces", ["name"], name: "index_namespaces_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
974
  add_index "namespaces", ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
975
  add_index "namespaces", ["parent_id", "id"], name: "index_namespaces_on_parent_id_and_id", unique: true, using: :btree
976
  add_index "namespaces", ["path"], name: "index_namespaces_on_path", using: :btree
977
  add_index "namespaces", ["path"], name: "index_namespaces_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
978
  add_index "namespaces", ["require_two_factor_authentication"], name: "index_namespaces_on_require_two_factor_authentication", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
979
  add_index "namespaces", ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
980

Valery Sizov's avatar
Valery Sizov committed
981
  create_table "notes", force: :cascade do |t|
982 983 984
    t.text "note"
    t.string "noteable_type"
    t.integer "author_id"
985 986
    t.datetime "created_at"
    t.datetime "updated_at"
987 988 989 990 991 992 993 994 995 996 997
    t.integer "project_id"
    t.string "attachment"
    t.string "line_code"
    t.string "commit_id"
    t.integer "noteable_id"
    t.boolean "system", default: false, null: false
    t.text "st_diff"
    t.integer "updated_by_id"
    t.string "type"
    t.text "position"
    t.text "original_position"
998
    t.datetime "resolved_at"
999 1000 1001
    t.integer "resolved_by_id"
    t.string "discussion_id"
    t.text "note_html"
1002
    t.integer "cached_markdown_version"
1003
    t.text "change_position"
Andrew8xx8's avatar
Andrew8xx8 committed
1004 1005
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1006 1007 1008
  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
1009
  add_index "notes", ["discussion_id"], name: "index_notes_on_discussion_id", using: :btree
1010
  add_index "notes", ["line_code"], name: "index_notes_on_line_code", using: :btree
1011
  add_index "notes", ["note"], name: "index_notes_on_note_trigram", using: :gin, opclasses: {"note"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1012 1013 1014
  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
1015
  add_index "notes", ["updated_at"], name: "index_notes_on_updated_at", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1016

1017
  create_table "notification_settings", force: :cascade do |t|
1018 1019 1020 1021 1022 1023
    t.integer "user_id", null: false
    t.integer "source_id"
    t.string "source_type"
    t.integer "level", default: 0, null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035
    t.boolean "new_note"
    t.boolean "new_issue"
    t.boolean "reopen_issue"
    t.boolean "close_issue"
    t.boolean "reassign_issue"
    t.boolean "new_merge_request"
    t.boolean "reopen_merge_request"
    t.boolean "close_merge_request"
    t.boolean "reassign_merge_request"
    t.boolean "merge_merge_request"
    t.boolean "failed_pipeline"
    t.boolean "success_pipeline"
1036 1037
  end

1038
  add_index "notification_settings", ["source_id", "source_type"], name: "index_notification_settings_on_source_id_and_source_type", using: :btree
1039
  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
1040 1041
  add_index "notification_settings", ["user_id"], name: "index_notification_settings_on_user_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1042
  create_table "oauth_access_grants", force: :cascade do |t|
1043 1044 1045 1046 1047 1048
    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
1049
    t.datetime "revoked_at"
1050
    t.string "scopes"
Valery Sizov's avatar
Valery Sizov committed
1051 1052 1053 1054
  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
1055
  create_table "oauth_access_tokens", force: :cascade do |t|
1056 1057 1058 1059 1060
    t.integer "resource_owner_id"
    t.integer "application_id"
    t.string "token", null: false
    t.string "refresh_token"
    t.integer "expires_in"
Valery Sizov's avatar
Valery Sizov committed
1061
    t.datetime "revoked_at"
1062 1063
    t.datetime "created_at", null: false
    t.string "scopes"
Valery Sizov's avatar
Valery Sizov committed
1064 1065 1066 1067 1068 1069
  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
1070
  create_table "oauth_applications", force: :cascade do |t|
1071 1072 1073 1074 1075
    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
1076 1077
    t.datetime "created_at"
    t.datetime "updated_at"
1078 1079
    t.integer "owner_id"
    t.string "owner_type"
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
1080
    t.boolean "trusted", default: false, null: false
Valery Sizov's avatar
Valery Sizov committed
1081 1082 1083 1084 1085
  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

1086 1087 1088 1089 1090
  create_table "oauth_openid_requests", force: :cascade do |t|
    t.integer "access_grant_id", null: false
    t.string "nonce", null: false
  end

Kamil Trzcinski's avatar
Kamil Trzcinski committed
1091 1092
  create_table "pages_domains", force: :cascade do |t|
    t.integer "project_id"
1093 1094 1095 1096 1097
    t.text "certificate"
    t.text "encrypted_key"
    t.string "encrypted_key_iv"
    t.string "encrypted_key_salt"
    t.string "domain"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1098 1099 1100
  end

  add_index "pages_domains", ["domain"], name: "index_pages_domains_on_domain", unique: true, using: :btree
1101
  add_index "pages_domains", ["project_id"], name: "index_pages_domains_on_project_id", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1102

1103
  create_table "personal_access_tokens", force: :cascade do |t|
1104 1105 1106 1107
    t.integer "user_id", null: false
    t.string "token", null: false
    t.string "name", null: false
    t.boolean "revoked", default: false
1108
    t.date "expires_at"
1109 1110
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1111
    t.string "scopes", default: "--- []\n", null: false
Simon Vocella's avatar
Simon Vocella committed
1112
    t.boolean "impersonation", default: false, null: false
1113 1114 1115 1116 1117
  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

1118
  create_table "project_authorizations", id: false, force: :cascade do |t|
1119 1120 1121 1122 1123
    t.integer "user_id"
    t.integer "project_id"
    t.integer "access_level"
  end

1124
  add_index "project_authorizations", ["project_id"], name: "index_project_authorizations_on_project_id", using: :btree
1125 1126
  add_index "project_authorizations", ["user_id", "project_id", "access_level"], name: "index_project_authorizations_on_user_id_project_id_access_level", unique: true, using: :btree

1127
  create_table "project_features", force: :cascade do |t|
1128 1129 1130 1131 1132 1133
    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"
1134 1135
    t.datetime "created_at"
    t.datetime "updated_at"
1136
    t.integer "repository_access_level", default: 20, null: false
1137 1138 1139 1140
  end

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

1141
  create_table "project_group_links", force: :cascade do |t|
1142 1143
    t.integer "project_id", null: false
    t.integer "group_id", null: false
1144 1145
    t.datetime "created_at"
    t.datetime "updated_at"
1146 1147
    t.integer "group_access", default: 30, null: false
    t.date "expires_at"
1148 1149
  end

1150
  add_index "project_group_links", ["group_id"], name: "index_project_group_links_on_group_id", using: :btree
1151
  add_index "project_group_links", ["project_id"], name: "index_project_group_links_on_project_id", using: :btree
1152

Valery Sizov's avatar
Valery Sizov committed
1153
  create_table "project_import_data", force: :cascade do |t|
1154
    t.integer "project_id"
1155 1156 1157 1158
    t.text "data"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
1159 1160
  end

1161 1162
  add_index "project_import_data", ["project_id"], name: "index_project_import_data_on_project_id", using: :btree

1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175
  create_table "project_statistics", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "namespace_id", null: false
    t.integer "commit_count", limit: 8, default: 0, null: false
    t.integer "storage_size", limit: 8, default: 0, null: false
    t.integer "repository_size", limit: 8, default: 0, null: false
    t.integer "lfs_objects_size", limit: 8, default: 0, null: false
    t.integer "build_artifacts_size", limit: 8, default: 0, null: false
  end

  add_index "project_statistics", ["namespace_id"], name: "index_project_statistics_on_namespace_id", using: :btree
  add_index "project_statistics", ["project_id"], name: "index_project_statistics_on_project_id", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
1176
  create_table "projects", force: :cascade do |t|
1177 1178 1179
    t.string "name"
    t.string "path"
    t.text "description"
1180 1181
    t.datetime "created_at"
    t.datetime "updated_at"
1182 1183
    t.integer "creator_id"
    t.integer "namespace_id"
1184
    t.datetime "last_activity_at"
1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202
    t.string "import_url"
    t.integer "visibility_level", default: 0, null: false
    t.boolean "archived", default: false, null: false
    t.string "avatar"
    t.string "import_status"
    t.integer "star_count", default: 0, null: false
    t.string "import_type"
    t.string "import_source"
    t.text "import_error"
    t.integer "ci_id"
    t.boolean "shared_runners_enabled", default: true, null: false
    t.string "runners_token"
    t.string "build_coverage_regex"
    t.boolean "build_allow_git_fetch", default: true, null: false
    t.integer "build_timeout", default: 3600, null: false
    t.boolean "pending_delete", default: false
    t.boolean "public_builds", default: true, null: false
    t.boolean "last_repository_check_failed"
1203
    t.datetime "last_repository_check_at"
1204
    t.boolean "container_registry_enabled"
1205
    t.boolean "only_allow_merge_if_pipeline_succeeds", default: false, null: false
1206 1207
    t.boolean "has_external_issue_tracker"
    t.string "repository_storage", default: "default", null: false
1208
    t.boolean "request_access_enabled", default: false, null: false
1209 1210 1211
    t.boolean "has_external_wiki"
    t.boolean "lfs_enabled"
    t.text "description_html"
Valery Sizov's avatar
Valery Sizov committed
1212
    t.boolean "only_allow_merge_if_all_discussions_are_resolved"
1213
    t.boolean "printing_merge_request_link_enabled", default: true, null: false
1214
    t.integer "auto_cancel_pending_pipelines", default: 1, null: false
1215
    t.string "import_jid"
1216
    t.integer "cached_markdown_version"
1217
    t.datetime "last_repository_updated_at"
1218
    t.string "ci_config_path"
1219
    t.text "delete_error"
1220
    t.integer "storage_version", limit: 2
Andrew8xx8's avatar
Andrew8xx8 committed
1221 1222
  end

1223
  add_index "projects", ["ci_id"], name: "index_projects_on_ci_id", using: :btree
1224
  add_index "projects", ["created_at"], name: "index_projects_on_created_at", using: :btree
1225
  add_index "projects", ["creator_id"], name: "index_projects_on_creator_id", using: :btree
1226
  add_index "projects", ["description"], name: "index_projects_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1227
  add_index "projects", ["last_activity_at"], name: "index_projects_on_last_activity_at", using: :btree
1228
  add_index "projects", ["last_repository_check_failed"], name: "index_projects_on_last_repository_check_failed", using: :btree
1229
  add_index "projects", ["last_repository_updated_at"], name: "index_projects_on_last_repository_updated_at", using: :btree
1230
  add_index "projects", ["name"], name: "index_projects_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1231
  add_index "projects", ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1232
  add_index "projects", ["path"], name: "index_projects_on_path", using: :btree
1233
  add_index "projects", ["path"], name: "index_projects_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
James Lopez's avatar
James Lopez committed
1234
  add_index "projects", ["pending_delete"], name: "index_projects_on_pending_delete", using: :btree
1235
  add_index "projects", ["runners_token"], name: "index_projects_on_runners_token", using: :btree
1236
  add_index "projects", ["star_count"], name: "index_projects_on_star_count", using: :btree
1237
  add_index "projects", ["visibility_level"], name: "index_projects_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1238

1239
  create_table "protected_branch_merge_access_levels", force: :cascade do |t|
1240 1241 1242 1243
    t.integer "protected_branch_id", null: false
    t.integer "access_level", default: 40, null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1244 1245 1246 1247 1248
  end

  add_index "protected_branch_merge_access_levels", ["protected_branch_id"], name: "index_protected_branch_merge_access", using: :btree

  create_table "protected_branch_push_access_levels", force: :cascade do |t|
1249 1250 1251 1252
    t.integer "protected_branch_id", null: false
    t.integer "access_level", default: 40, null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1253 1254 1255 1256
  end

  add_index "protected_branch_push_access_levels", ["protected_branch_id"], name: "index_protected_branch_push_access", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1257
  create_table "protected_branches", force: :cascade do |t|
1258 1259
    t.integer "project_id", null: false
    t.string "name", null: false
1260 1261
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
1262 1263
  end

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

1266
  create_table "protected_tag_create_access_levels", force: :cascade do |t|
1267
    t.integer "protected_tag_id", null: false
1268 1269 1270
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
1271 1272 1273 1274
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

1275 1276
  add_index "protected_tag_create_access_levels", ["protected_tag_id"], name: "index_protected_tag_create_access", using: :btree
  add_index "protected_tag_create_access_levels", ["user_id"], name: "index_protected_tag_create_access_levels_on_user_id", using: :btree
1277 1278 1279 1280

  create_table "protected_tags", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
1281 1282
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1283 1284 1285 1286
  end

  add_index "protected_tags", ["project_id"], name: "index_protected_tags_on_project_id", using: :btree

1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299
  create_table "push_event_payloads", id: false, force: :cascade do |t|
    t.integer "commit_count", limit: 8, null: false
    t.integer "event_id", null: false
    t.integer "action", limit: 2, null: false
    t.integer "ref_type", limit: 2, null: false
    t.binary "commit_from"
    t.binary "commit_to"
    t.text "ref"
    t.string "commit_title", limit: 70
  end

  add_index "push_event_payloads", ["event_id"], name: "index_push_event_payloads_on_event_id", unique: true, using: :btree

1300 1301 1302 1303 1304 1305 1306 1307
  create_table "redirect_routes", force: :cascade do |t|
    t.integer "source_id", null: false
    t.string "source_type", null: false
    t.string "path", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

1308
  add_index "redirect_routes", ["path"], name: "index_redirect_routes_on_path", unique: true, using: :btree
1309
  add_index "redirect_routes", ["path"], name: "index_redirect_routes_on_path_text_pattern_ops", using: :btree, opclasses: {"path"=>"varchar_pattern_ops"}
1310 1311
  add_index "redirect_routes", ["source_type", "source_id"], name: "index_redirect_routes_on_source_type_and_source_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1312
  create_table "releases", force: :cascade do |t|
1313 1314 1315
    t.string "tag"
    t.text "description"
    t.integer "project_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1316 1317
    t.datetime "created_at"
    t.datetime "updated_at"
1318
    t.text "description_html"
1319
    t.integer "cached_markdown_version"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1320 1321 1322 1323 1324
  end

  add_index "releases", ["project_id", "tag"], name: "index_releases_on_project_id_and_tag", using: :btree
  add_index "releases", ["project_id"], name: "index_releases_on_project_id", using: :btree

1325 1326 1327 1328 1329 1330
  create_table "routes", force: :cascade do |t|
    t.integer "source_id", null: false
    t.string "source_type", null: false
    t.string "path", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
1331
    t.string "name"
1332 1333 1334
  end

  add_index "routes", ["path"], name: "index_routes_on_path", unique: true, using: :btree
1335
  add_index "routes", ["path"], name: "index_routes_on_path_text_pattern_ops", using: :btree, opclasses: {"path"=>"varchar_pattern_ops"}
1336 1337
  add_index "routes", ["source_type", "source_id"], name: "index_routes_on_source_type_and_source_id", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
1338
  create_table "sent_notifications", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
1339 1340
    t.integer "project_id"
    t.integer "noteable_id"
1341
    t.string "noteable_type"
Douwe Maan's avatar
Douwe Maan committed
1342
    t.integer "recipient_id"
1343 1344 1345 1346 1347
    t.string "commit_id"
    t.string "reply_key", null: false
    t.string "line_code"
    t.string "note_type"
    t.text "position"
1348
    t.string "in_reply_to_discussion_id"
Douwe Maan's avatar
Douwe Maan committed
1349 1350 1351 1352
  end

  add_index "sent_notifications", ["reply_key"], name: "index_sent_notifications_on_reply_key", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
1353
  create_table "services", force: :cascade do |t|
1354 1355 1356
    t.string "type"
    t.string "title"
    t.integer "project_id"
1357 1358
    t.datetime "created_at"
    t.datetime "updated_at"
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371
    t.boolean "active", default: false, null: false
    t.text "properties"
    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
    t.boolean "note_events", default: true, null: false
    t.string "category", default: "common", null: false
    t.boolean "default", default: false
    t.boolean "wiki_page_events", default: true
    t.boolean "pipeline_events", default: false, null: false
    t.boolean "confidential_issues_events", default: true, null: false
1372
    t.boolean "commit_events", default: true, null: false
1373
    t.boolean "job_events", default: false, null: false
1374 1375
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1376
  add_index "services", ["project_id"], name: "index_services_on_project_id", using: :btree
1377
  add_index "services", ["template"], name: "index_services_on_template", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1378

Valery Sizov's avatar
Valery Sizov committed
1379
  create_table "snippets", force: :cascade do |t|
1380 1381 1382 1383
    t.string "title"
    t.text "content"
    t.integer "author_id", null: false
    t.integer "project_id"
1384 1385
    t.datetime "created_at"
    t.datetime "updated_at"
1386 1387 1388 1389 1390
    t.string "file_name"
    t.string "type"
    t.integer "visibility_level", default: 0, null: false
    t.text "title_html"
    t.text "content_html"
1391
    t.integer "cached_markdown_version"
1392 1393
    t.text "description"
    t.text "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
1394 1395
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1396
  add_index "snippets", ["author_id"], name: "index_snippets_on_author_id", using: :btree
1397
  add_index "snippets", ["file_name"], name: "index_snippets_on_file_name_trigram", using: :gin, opclasses: {"file_name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1398
  add_index "snippets", ["project_id"], name: "index_snippets_on_project_id", using: :btree
1399
  add_index "snippets", ["title"], name: "index_snippets_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
1400
  add_index "snippets", ["updated_at"], name: "index_snippets_on_updated_at", using: :btree
1401
  add_index "snippets", ["visibility_level"], name: "index_snippets_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1402

1403
  create_table "spam_logs", force: :cascade do |t|
1404 1405 1406 1407 1408 1409 1410 1411 1412 1413
    t.integer "user_id"
    t.string "source_ip"
    t.string "user_agent"
    t.boolean "via_api"
    t.string "noteable_type"
    t.string "title"
    t.text "description"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.boolean "submitted_as_ham", default: false, null: false
1414
    t.boolean "recaptcha_verified", default: false, null: false
1415 1416
  end

Valery Sizov's avatar
Valery Sizov committed
1417
  create_table "subscriptions", force: :cascade do |t|
1418 1419 1420 1421
    t.integer "user_id"
    t.integer "subscribable_id"
    t.string "subscribable_type"
    t.boolean "subscribed"
Valery Sizov's avatar
Valery Sizov committed
1422 1423
    t.datetime "created_at"
    t.datetime "updated_at"
1424
    t.integer "project_id"
Valery Sizov's avatar
Valery Sizov committed
1425 1426
  end

1427
  add_index "subscriptions", ["subscribable_id", "subscribable_type", "user_id", "project_id"], name: "index_subscriptions_on_subscribable_and_user_id_and_project_id", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
1428

1429 1430 1431
  create_table "system_note_metadata", force: :cascade do |t|
    t.integer "note_id", null: false
    t.integer "commit_count"
1432
    t.string "action"
1433 1434
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Valery Sizov's avatar
Valery Sizov committed
1435 1436
  end

1437
  add_index "system_note_metadata", ["note_id"], name: "index_system_note_metadata_on_note_id", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
1438

Valery Sizov's avatar
Valery Sizov committed
1439
  create_table "taggings", force: :cascade do |t|
1440 1441 1442 1443 1444 1445
    t.integer "tag_id"
    t.integer "taggable_id"
    t.string "taggable_type"
    t.integer "tagger_id"
    t.string "tagger_type"
    t.string "context"
Andrew8xx8's avatar
Andrew8xx8 committed
1446 1447 1448
    t.datetime "created_at"
  end

1449
  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true, using: :btree
1450 1451
  add_index "taggings", ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1452
  create_table "tags", force: :cascade do |t|
1453
    t.string "name"
1454
    t.integer "taggings_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1455 1456
  end

1457 1458
  add_index "tags", ["name"], name: "index_tags_on_name", unique: true, using: :btree

1459 1460 1461 1462 1463
  create_table "timelogs", force: :cascade do |t|
    t.integer "time_spent", null: false
    t.integer "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1464 1465
    t.integer "issue_id"
    t.integer "merge_request_id"
1466 1467
  end

1468 1469
  add_index "timelogs", ["issue_id"], name: "index_timelogs_on_issue_id", using: :btree
  add_index "timelogs", ["merge_request_id"], name: "index_timelogs_on_merge_request_id", using: :btree
1470 1471
  add_index "timelogs", ["user_id"], name: "index_timelogs_on_user_id", using: :btree

1472
  create_table "todos", force: :cascade do |t|
1473 1474 1475 1476 1477 1478 1479
    t.integer "user_id", null: false
    t.integer "project_id", null: false
    t.integer "target_id"
    t.string "target_type", null: false
    t.integer "author_id"
    t.integer "action", null: false
    t.string "state", null: false
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
1480 1481
    t.datetime "created_at"
    t.datetime "updated_at"
1482 1483
    t.integer "note_id"
    t.string "commit_id"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
1484 1485
  end

1486
  add_index "todos", ["author_id"], name: "index_todos_on_author_id", using: :btree
James Lopez's avatar
James Lopez committed
1487
  add_index "todos", ["commit_id"], name: "index_todos_on_commit_id", using: :btree
1488 1489 1490 1491
  add_index "todos", ["note_id"], name: "index_todos_on_note_id", using: :btree
  add_index "todos", ["project_id"], name: "index_todos_on_project_id", using: :btree
  add_index "todos", ["target_type", "target_id"], name: "index_todos_on_target_type_and_target_id", using: :btree
  add_index "todos", ["user_id"], name: "index_todos_on_user_id", using: :btree
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
1492

1493 1494 1495 1496 1497 1498
  create_table "trending_projects", force: :cascade do |t|
    t.integer "project_id", null: false
  end

  add_index "trending_projects", ["project_id"], name: "index_trending_projects_on_project_id", using: :btree

1499
  create_table "u2f_registrations", force: :cascade do |t|
1500 1501 1502 1503 1504 1505 1506 1507
    t.text "certificate"
    t.string "key_handle"
    t.string "public_key"
    t.integer "counter"
    t.integer "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "name"
1508 1509 1510 1511 1512
  end

  add_index "u2f_registrations", ["key_handle"], name: "index_u2f_registrations_on_key_handle", using: :btree
  add_index "u2f_registrations", ["user_id"], name: "index_u2f_registrations_on_user_id", using: :btree

1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526
  create_table "uploads", force: :cascade do |t|
    t.integer "size", limit: 8, null: false
    t.string "path", null: false
    t.string "checksum", limit: 64
    t.integer "model_id"
    t.string "model_type"
    t.string "uploader", null: false
    t.datetime "created_at", null: false
  end

  add_index "uploads", ["checksum"], name: "index_uploads_on_checksum", using: :btree
  add_index "uploads", ["model_id", "model_type"], name: "index_uploads_on_model_id_and_model_type", using: :btree
  add_index "uploads", ["path"], name: "index_uploads_on_path", using: :btree

1527
  create_table "user_agent_details", force: :cascade do |t|
1528 1529 1530 1531 1532 1533 1534
    t.string "user_agent", null: false
    t.string "ip_address", null: false
    t.integer "subject_id", null: false
    t.string "subject_type", null: false
    t.boolean "submitted", default: false, null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1535 1536
  end

1537 1538
  add_index "user_agent_details", ["subject_id", "subject_type"], name: "index_user_agent_details_on_subject_id_and_subject_type", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1539
  create_table "users", force: :cascade do |t|
1540 1541 1542
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
Andrew8xx8's avatar
Andrew8xx8 committed
1543 1544
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
1545
    t.integer "sign_in_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1546 1547
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
1548 1549
    t.string "current_sign_in_ip"
    t.string "last_sign_in_ip"
1550 1551
    t.datetime "created_at"
    t.datetime "updated_at"
1552 1553 1554 1555 1556 1557 1558 1559 1560
    t.string "name"
    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
    t.string "authentication_token"
    t.string "bio"
    t.integer "failed_attempts", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1561
    t.datetime "locked_at"
1562 1563 1564 1565 1566
    t.string "username"
    t.boolean "can_create_group", default: true, null: false
    t.boolean "can_create_team", default: true, null: false
    t.string "state"
    t.integer "color_scheme_id", default: 1, null: false
1567
    t.datetime "password_expires_at"
1568
    t.integer "created_by_id"
1569
    t.datetime "last_credential_check_at"
1570 1571
    t.string "avatar"
    t.string "confirmation_token"
1572 1573
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592
    t.string "unconfirmed_email"
    t.boolean "hide_no_ssh_key", default: false
    t.string "website_url", default: "", null: false
    t.string "notification_email"
    t.boolean "hide_no_password", default: false
    t.boolean "password_automatically_set", default: false
    t.string "location"
    t.string "encrypted_otp_secret"
    t.string "encrypted_otp_secret_iv"
    t.string "encrypted_otp_secret_salt"
    t.boolean "otp_required_for_login", default: false, null: false
    t.text "otp_backup_codes"
    t.string "public_email", default: "", null: false
    t.integer "dashboard", default: 0
    t.integer "project_view", default: 0
    t.integer "consumed_timestep"
    t.integer "layout", default: 0
    t.boolean "hide_project_limit", default: false
    t.string "unlock_token"
1593
    t.datetime "otp_grace_period_started_at"
1594
    t.boolean "external", default: false
Nick Thomas's avatar
Nick Thomas committed
1595
    t.string "incoming_email_token"
1596
    t.string "organization"
1597 1598
    t.boolean "require_two_factor_authentication_from_group", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
1599
    t.boolean "ghost"
1600
    t.date "last_activity_on"
1601
    t.boolean "notified_of_own_activity"
1602
    t.string "preferred_language"
1603
    t.string "rss_token"
1604 1605
    t.boolean "external_email", default: false, null: false
    t.string "email_provider"
Andrew8xx8's avatar
Andrew8xx8 committed
1606 1607
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1608 1609 1610
  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
1611
  add_index "users", ["created_at"], name: "index_users_on_created_at", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1612
  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
1613
  add_index "users", ["email"], name: "index_users_on_email_trigram", using: :gin, opclasses: {"email"=>"gin_trgm_ops"}
1614
  add_index "users", ["ghost"], name: "index_users_on_ghost", using: :btree
1615
  add_index "users", ["incoming_email_token"], name: "index_users_on_incoming_email_token", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1616
  add_index "users", ["name"], name: "index_users_on_name", using: :btree
1617
  add_index "users", ["name"], name: "index_users_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1618
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
1619
  add_index "users", ["rss_token"], name: "index_users_on_rss_token", using: :btree
Stan Hu's avatar
Stan Hu committed
1620
  add_index "users", ["state"], name: "index_users_on_state", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1621
  add_index "users", ["username"], name: "index_users_on_username", using: :btree
1622
  add_index "users", ["username"], name: "index_users_on_username_trigram", using: :gin, opclasses: {"username"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1623

Valery Sizov's avatar
Valery Sizov committed
1624
  create_table "users_star_projects", force: :cascade do |t|
1625 1626
    t.integer "project_id", null: false
    t.integer "user_id", null: false
Ciro Santilli's avatar
Ciro Santilli committed
1627 1628 1629 1630 1631 1632 1633
    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

1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649
  create_table "web_hook_logs", force: :cascade do |t|
    t.integer "web_hook_id", null: false
    t.string "trigger"
    t.string "url"
    t.text "request_headers"
    t.text "request_data"
    t.text "response_headers"
    t.text "response_body"
    t.string "response_status"
    t.float "execution_duration"
    t.string "internal_error_message"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "web_hook_logs", ["web_hook_id"], name: "index_web_hook_logs_on_web_hook_id", using: :btree
Ciro Santilli's avatar
Ciro Santilli committed
1650

Valery Sizov's avatar
Valery Sizov committed
1651
  create_table "web_hooks", force: :cascade do |t|
1652 1653
    t.string "url", limit: 2000
    t.integer "project_id"
1654 1655
    t.datetime "created_at"
    t.datetime "updated_at"
1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667
    t.string "type", default: "ProjectHook"
    t.integer "service_id"
    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
    t.boolean "tag_push_events", default: false
    t.boolean "note_events", default: false, null: false
    t.boolean "enable_ssl_verification", default: true
    t.boolean "wiki_page_events", default: false, null: false
    t.string "token"
    t.boolean "pipeline_events", default: false, null: false
    t.boolean "confidential_issues_events", default: false, null: false
1668
    t.boolean "repository_update_events", default: false, null: false
Luke "Jared" Bennett's avatar
Luke "Jared" Bennett committed
1669
    t.boolean "job_events", default: false, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
1670 1671
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1672
  add_index "web_hooks", ["project_id"], name: "index_web_hooks_on_project_id", using: :btree
1673
  add_index "web_hooks", ["type"], name: "index_web_hooks_on_type", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1674

1675
  add_foreign_key "boards", "projects", name: "fk_f15266b5f9", on_delete: :cascade
1676
  add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
1677
  add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
1678
  add_foreign_key "ci_builds", "ci_stages", column: "stage_id", name: "fk_3a9eaa254d", on_delete: :cascade
1679
  add_foreign_key "ci_builds", "projects", name: "fk_befce0568a", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
1680
  add_foreign_key "ci_group_variables", "namespaces", column: "group_id", name: "fk_33ae4d58d8", on_delete: :cascade
Shinya Maeda's avatar
fix  
Shinya Maeda committed
1681
  add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade
1682
  add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade
1683
  add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify
Shinya Maeda's avatar
init  
Shinya Maeda committed
1684
  add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade
1685
  add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify
1686
  add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify
1687 1688
  add_foreign_key "ci_pipelines", "projects", name: "fk_86635dbd80", on_delete: :cascade
  add_foreign_key "ci_runner_projects", "projects", name: "fk_4478a6f1e4", on_delete: :cascade
1689
  add_foreign_key "ci_stages", "ci_pipelines", column: "pipeline_id", name: "fk_fb57e6cc56", on_delete: :cascade
1690
  add_foreign_key "ci_stages", "projects", name: "fk_2360681d1d", on_delete: :cascade
1691
  add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
1692
  add_foreign_key "ci_triggers", "projects", name: "fk_e3e63f966e", on_delete: :cascade
1693
  add_foreign_key "ci_triggers", "users", column: "owner_id", name: "fk_e8e10d1964", on_delete: :cascade
1694
  add_foreign_key "ci_variables", "projects", name: "fk_ada5eb64b3", on_delete: :cascade
1695
  add_foreign_key "container_repositories", "projects"
1696 1697 1698 1699
  add_foreign_key "deploy_keys_projects", "projects", name: "fk_58a901ca7e", on_delete: :cascade
  add_foreign_key "deployments", "projects", name: "fk_b9a3851b82", on_delete: :cascade
  add_foreign_key "environments", "projects", name: "fk_d1c8c1da6a", on_delete: :cascade
  add_foreign_key "events", "projects", name: "fk_0434b48643", on_delete: :cascade
1700 1701
  add_foreign_key "events_for_migration", "projects", on_delete: :cascade
  add_foreign_key "events_for_migration", "users", column: "author_id", name: "fk_edfd187b6f", on_delete: :cascade
1702
  add_foreign_key "forked_project_links", "projects", column: "forked_to_project_id", name: "fk_434510edb0", on_delete: :cascade
1703 1704 1705
  add_foreign_key "gpg_keys", "users", on_delete: :cascade
  add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify
  add_foreign_key "gpg_signatures", "projects", on_delete: :cascade
1706 1707
  add_foreign_key "issue_assignees", "issues", name: "fk_b7d881734a", on_delete: :cascade
  add_foreign_key "issue_assignees", "users", name: "fk_5e0c8d9154", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
1708
  add_foreign_key "issue_metrics", "issues", on_delete: :cascade
1709
  add_foreign_key "issues", "projects", name: "fk_899c8f3231", on_delete: :cascade
1710
  add_foreign_key "issues", "users", column: "author_id", name: "fk_05f1e72feb", on_delete: :cascade
1711 1712
  add_foreign_key "label_priorities", "labels", on_delete: :cascade
  add_foreign_key "label_priorities", "projects", on_delete: :cascade
1713
  add_foreign_key "labels", "namespaces", column: "group_id", on_delete: :cascade
1714 1715 1716
  add_foreign_key "labels", "projects", name: "fk_7de4989a69", on_delete: :cascade
  add_foreign_key "lists", "boards", name: "fk_0d3f677137", on_delete: :cascade
  add_foreign_key "lists", "labels", name: "fk_7a5553d60f", on_delete: :cascade
1717
  add_foreign_key "merge_request_diff_commits", "merge_request_diffs", on_delete: :cascade
1718
  add_foreign_key "merge_request_diff_files", "merge_request_diffs", on_delete: :cascade
1719
  add_foreign_key "merge_request_diffs", "merge_requests", name: "fk_8483f3258f", on_delete: :cascade
1720
  add_foreign_key "merge_request_metrics", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
1721
  add_foreign_key "merge_request_metrics", "merge_requests", on_delete: :cascade
1722
  add_foreign_key "merge_requests", "ci_pipelines", column: "head_pipeline_id", name: "fk_fd82eae0b9", on_delete: :nullify
1723
  add_foreign_key "merge_requests", "projects", column: "target_project_id", name: "fk_a6963e8447", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
1724 1725
  add_foreign_key "merge_requests_closing_issues", "issues", on_delete: :cascade
  add_foreign_key "merge_requests_closing_issues", "merge_requests", on_delete: :cascade
Felipe Artur's avatar
Felipe Artur committed
1726
  add_foreign_key "milestones", "namespaces", column: "group_id", name: "fk_95650a40d4", on_delete: :cascade
1727 1728
  add_foreign_key "milestones", "projects", name: "fk_9bd0a0c791", on_delete: :cascade
  add_foreign_key "notes", "projects", name: "fk_99e097b079", on_delete: :cascade
1729
  add_foreign_key "oauth_openid_requests", "oauth_access_grants", column: "access_grant_id", name: "fk_oauth_openid_requests_oauth_access_grants_access_grant_id"
1730
  add_foreign_key "pages_domains", "projects", name: "fk_ea2f6dfc6f", on_delete: :cascade
1731
  add_foreign_key "personal_access_tokens", "users"
1732 1733
  add_foreign_key "project_authorizations", "projects", on_delete: :cascade
  add_foreign_key "project_authorizations", "users", on_delete: :cascade
1734 1735 1736
  add_foreign_key "project_features", "projects", name: "fk_18513d9b92", on_delete: :cascade
  add_foreign_key "project_group_links", "projects", name: "fk_daa8cee94c", on_delete: :cascade
  add_foreign_key "project_import_data", "projects", name: "fk_ffb9ee3a10", on_delete: :cascade
1737
  add_foreign_key "project_statistics", "projects", on_delete: :cascade
1738 1739 1740
  add_foreign_key "protected_branch_merge_access_levels", "protected_branches", name: "fk_8a3072ccb3", on_delete: :cascade
  add_foreign_key "protected_branch_push_access_levels", "protected_branches", name: "fk_9ffc86a3d9", on_delete: :cascade
  add_foreign_key "protected_branches", "projects", name: "fk_7a9c6d93e7", on_delete: :cascade
1741
  add_foreign_key "protected_tag_create_access_levels", "namespaces", column: "group_id"
1742
  add_foreign_key "protected_tag_create_access_levels", "protected_tags", name: "fk_f7dfda8c51", on_delete: :cascade
1743
  add_foreign_key "protected_tag_create_access_levels", "users"
1744
  add_foreign_key "protected_tags", "projects", name: "fk_8e4af87648", on_delete: :cascade
1745
  add_foreign_key "push_event_payloads", "events_for_migration", column: "event_id", name: "fk_36c74129da", on_delete: :cascade
1746 1747 1748
  add_foreign_key "releases", "projects", name: "fk_47fe2a0596", on_delete: :cascade
  add_foreign_key "services", "projects", name: "fk_71cce407f9", on_delete: :cascade
  add_foreign_key "snippets", "projects", name: "fk_be41fd4bb7", on_delete: :cascade
1749
  add_foreign_key "subscriptions", "projects", on_delete: :cascade
1750
  add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade
1751 1752
  add_foreign_key "timelogs", "issues", name: "fk_timelogs_issues_issue_id", on_delete: :cascade
  add_foreign_key "timelogs", "merge_requests", name: "fk_timelogs_merge_requests_merge_request_id", on_delete: :cascade
1753
  add_foreign_key "todos", "projects", name: "fk_45054f9c45", on_delete: :cascade
1754
  add_foreign_key "trending_projects", "projects", on_delete: :cascade
1755
  add_foreign_key "u2f_registrations", "users"
1756
  add_foreign_key "users_star_projects", "projects", name: "fk_22cd27ddfc", on_delete: :cascade
1757
  add_foreign_key "web_hook_logs", "web_hooks", on_delete: :cascade
1758
  add_foreign_key "web_hooks", "projects", name: "fk_0c8ca6d9d1", on_delete: :cascade
1759
end