schema.rb 97 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: 20180216121030) 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
    t.string "header_logo"
    t.string "logo"
35 36
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
37
    t.text "description_html"
38
    t.integer "cached_markdown_version"
39 40
    t.text "new_project_guidelines"
    t.text "new_project_guidelines_html"
41 42
  end

Valery Sizov's avatar
Valery Sizov committed
43
  create_table "application_settings", force: :cascade do |t|
44 45 46 47
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
48 49
    t.datetime "created_at"
    t.datetime "updated_at"
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
    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"
67
    t.integer "max_pages_size", default: 100, null: false
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
    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
94
    t.boolean "user_default_external", default: false, null: false
95
    t.string "repository_storages", default: "default"
96 97 98
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
99
    t.boolean "usage_ping_enabled", default: true, null: false
100 101 102 103 104 105
    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"
106 107 108 109
    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
110 111 112 113 114
    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
115 116 117
    t.boolean "sidekiq_throttling_enabled", default: false
    t.string "sidekiq_throttling_queues"
    t.decimal "sidekiq_throttling_factor"
118
    t.boolean "html_emails_enabled", default: true
119 120
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
121
    t.integer "terminal_max_session_time", default: 0, null: false
122 123 124
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
125 126
    t.string "default_artifacts_expire_in", default: "0", null: false
    t.string "uuid"
127
    t.decimal "polling_interval_multiplier", default: 1.0, null: false
128
    t.integer "cached_markdown_version"
129 130
    t.boolean "clientside_sentry_enabled", default: false, null: false
    t.string "clientside_sentry_dsn"
Pawel Chojnacki's avatar
Pawel Chojnacki committed
131
    t.boolean "prometheus_metrics_enabled", default: false, null: false
132 133
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
134
    t.integer "performance_bar_allowed_group_id"
135
    t.boolean "hashed_storage_enabled", default: false, null: false
136 137
    t.boolean "project_export_enabled", default: true, null: false
    t.boolean "auto_devops_enabled", default: false, null: false
138
    t.integer "circuitbreaker_failure_count_threshold", default: 3
139
    t.integer "circuitbreaker_failure_reset_time", default: 1800
140
    t.integer "circuitbreaker_storage_timeout", default: 15
141
    t.integer "circuitbreaker_access_retries", default: 3
142 143 144 145 146 147 148 149 150
    t.boolean "throttle_unauthenticated_enabled", default: false, null: false
    t.integer "throttle_unauthenticated_requests_per_period", default: 3600, null: false
    t.integer "throttle_unauthenticated_period_in_seconds", default: 3600, null: false
    t.boolean "throttle_authenticated_api_enabled", default: false, null: false
    t.integer "throttle_authenticated_api_requests_per_period", default: 7200, null: false
    t.integer "throttle_authenticated_api_period_in_seconds", default: 3600, null: false
    t.boolean "throttle_authenticated_web_enabled", default: false, null: false
    t.integer "throttle_authenticated_web_requests_per_period", default: 7200, null: false
    t.integer "throttle_authenticated_web_period_in_seconds", default: 3600, null: false
151
    t.integer "circuitbreaker_check_interval", default: 1, null: false
152 153
    t.boolean "password_authentication_enabled_for_web"
    t.boolean "password_authentication_enabled_for_git", default: true
154 155 156
    t.integer "gitaly_timeout_default", default: 55, null: false
    t.integer "gitaly_timeout_medium", default: 30, null: false
    t.integer "gitaly_timeout_fast", default: 10, null: false
157
    t.boolean "authorized_keys_enabled", default: true, null: false
158
    t.string "auto_devops_domain"
159
    t.boolean "pages_domain_verification_enabled", default: true, null: false
160 161
  end

Valery Sizov's avatar
Valery Sizov committed
162
  create_table "audit_events", force: :cascade do |t|
163 164 165 166 167
    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"
168 169 170 171 172 173
    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

174
  create_table "award_emoji", force: :cascade do |t|
175 176 177 178
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
179 180 181 182
    t.datetime "created_at"
    t.datetime "updated_at"
  end

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

186
  create_table "boards", force: :cascade do |t|
187
    t.integer "project_id", null: false
188 189 190 191 192 193
    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
194
  create_table "broadcast_messages", force: :cascade do |t|
195
    t.text "message", null: false
196 197 198 199
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
200 201
    t.string "color"
    t.string "font"
202
    t.text "message_html", null: false
203
    t.integer "cached_markdown_version"
204
  end
205

206 207
  add_index "broadcast_messages", ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id", using: :btree

208 209 210
  create_table "chat_names", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "service_id", null: false
211
    t.string "team_id", null: false
212
    t.string "team_domain"
213
    t.string "chat_id", null: false
214
    t.string "chat_name"
215
    t.datetime "last_used_at"
216 217
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
218
  end
219

220
  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
221 222
  add_index "chat_names", ["user_id", "service_id"], name: "index_chat_names_on_user_id_and_service_id", unique: true, using: :btree

223
  create_table "chat_teams", force: :cascade do |t|
224
    t.integer "namespace_id", null: false
225 226 227 228
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
229 230
  end

231
  add_index "chat_teams", ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true, using: :btree
232

233 234 235 236 237 238 239 240
  create_table "ci_build_trace_section_names", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
  end

  add_index "ci_build_trace_section_names", ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true, using: :btree

  create_table "ci_build_trace_sections", force: :cascade do |t|
241
    t.integer "project_id", null: false
242 243 244 245 246 247 248 249 250 251 252
    t.datetime_with_timezone "date_start", null: false
    t.datetime_with_timezone "date_end", null: false
    t.integer "byte_start", limit: 8, null: false
    t.integer "byte_end", limit: 8, null: false
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
  end

  add_index "ci_build_trace_sections", ["build_id", "section_name_id"], name: "index_ci_build_trace_sections_on_build_id_and_section_name_id", unique: true, using: :btree
  add_index "ci_build_trace_sections", ["project_id"], name: "index_ci_build_trace_sections_on_project_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
253
  create_table "ci_builds", force: :cascade do |t|
254
    t.string "status"
255
    t.datetime "finished_at"
256
    t.text "trace"
257 258 259
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276
    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"
277
    t.integer "project_id"
278 279
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
280
    t.datetime "erased_at"
281
    t.datetime "artifacts_expire_at"
282 283 284 285
    t.string "environment"
    t.integer "artifacts_size", limit: 8
    t.string "when"
    t.text "yaml_variables"
286
    t.datetime "queued_at"
287
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
288
    t.integer "lock_version"
289
    t.string "coverage_regex"
290
    t.integer "auto_canceled_by_id"
291
    t.boolean "retried"
292
    t.integer "stage_id"
293
    t.boolean "protected"
294
    t.integer "failure_reason"
295 296
  end

297
  add_index "ci_builds", ["artifacts_expire_at"], name: "index_ci_builds_on_artifacts_expire_at", where: "(artifacts_file <> ''::text)", using: :btree
298
  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
299
  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
300
  add_index "ci_builds", ["commit_id", "status", "type"], name: "index_ci_builds_on_commit_id_and_status_and_type", using: :btree
301 302
  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
303
  add_index "ci_builds", ["project_id", "id"], name: "index_ci_builds_on_project_id_and_id", using: :btree
304
  add_index "ci_builds", ["protected"], name: "index_ci_builds_on_protected", using: :btree
305
  add_index "ci_builds", ["runner_id"], name: "index_ci_builds_on_runner_id", using: :btree
306
  add_index "ci_builds", ["stage_id"], name: "index_ci_builds_on_stage_id", using: :btree
307
  add_index "ci_builds", ["status", "type", "runner_id"], name: "index_ci_builds_on_status_and_type_and_runner_id", using: :btree
308
  add_index "ci_builds", ["status"], name: "index_ci_builds_on_status", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
309
  add_index "ci_builds", ["token"], name: "index_ci_builds_on_token", unique: true, using: :btree
310
  add_index "ci_builds", ["updated_at"], name: "index_ci_builds_on_updated_at", using: :btree
311
  add_index "ci_builds", ["user_id"], name: "index_ci_builds_on_user_id", using: :btree
312

Shinya Maeda's avatar
fix  
Shinya Maeda committed
313
  create_table "ci_group_variables", force: :cascade do |t|
314 315 316 317 318
    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
319 320
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
321 322
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
323 324
  end

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

327 328
  create_table "ci_job_artifacts", force: :cascade do |t|
    t.integer "project_id", null: false
329
    t.integer "job_id", null: false
330
    t.integer "file_type", null: false
331
    t.integer "size", limit: 8
332 333
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
334
    t.datetime_with_timezone "expire_at"
335 336 337
    t.string "file"
  end

338
  add_index "ci_job_artifacts", ["expire_at", "job_id"], name: "index_ci_job_artifacts_on_expire_at_and_job_id", using: :btree
339
  add_index "ci_job_artifacts", ["job_id", "file_type"], name: "index_ci_job_artifacts_on_job_id_and_file_type", unique: true, using: :btree
340 341
  add_index "ci_job_artifacts", ["project_id"], name: "index_ci_job_artifacts_on_project_id", using: :btree

Shinya Maeda's avatar
fix  
Shinya Maeda committed
342
  create_table "ci_pipeline_schedule_variables", force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
343 344 345 346 347
    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
348
    t.integer "pipeline_schedule_id", null: false
349 350
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
Shinya Maeda's avatar
Shinya Maeda committed
351 352
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
353
  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
354

355 356 357 358 359 360 361 362 363
  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
364 365 366 367
    t.datetime "created_at"
    t.datetime "updated_at"
  end

368 369
  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
370

Shinya Maeda's avatar
init  
Shinya Maeda committed
371 372 373 374 375 376 377 378 379 380 381
  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

382
  create_table "ci_pipelines", force: :cascade do |t|
383 384 385
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
386 387
    t.datetime "created_at"
    t.datetime "updated_at"
388 389
    t.boolean "tag", default: false
    t.text "yaml_errors"
390
    t.datetime "committed_at"
391
    t.integer "project_id"
392
    t.string "status"
393 394
    t.datetime "started_at"
    t.datetime "finished_at"
395 396
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
397
    t.integer "lock_version"
398
    t.integer "auto_canceled_by_id"
399
    t.integer "pipeline_schedule_id"
400
    t.integer "source"
401
    t.integer "config_source"
402
    t.boolean "protected"
403
    t.integer "failure_reason"
404 405
  end

406
  add_index "ci_pipelines", ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id", using: :btree
407
  add_index "ci_pipelines", ["pipeline_schedule_id"], name: "index_ci_pipelines_on_pipeline_schedule_id", using: :btree
408
  add_index "ci_pipelines", ["project_id", "ref", "status", "id"], name: "index_ci_pipelines_on_project_id_and_ref_and_status_and_id", using: :btree
409 410 411 412
  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
413

Valery Sizov's avatar
Valery Sizov committed
414
  create_table "ci_runner_projects", force: :cascade do |t|
415
    t.integer "runner_id", null: false
416 417
    t.datetime "created_at"
    t.datetime "updated_at"
418
    t.integer "project_id"
419 420
  end

421
  add_index "ci_runner_projects", ["project_id"], name: "index_ci_runner_projects_on_project_id", using: :btree
422 423
  add_index "ci_runner_projects", ["runner_id"], name: "index_ci_runner_projects_on_runner_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
424
  create_table "ci_runners", force: :cascade do |t|
425
    t.string "token"
426 427
    t.datetime "created_at"
    t.datetime "updated_at"
428
    t.string "description"
429
    t.datetime "contacted_at"
430 431 432 433 434 435 436 437 438
    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
439
    t.integer "access_level", default: 0, null: false
440 441
  end

442
  add_index "ci_runners", ["contacted_at"], name: "index_ci_runners_on_contacted_at", using: :btree
443
  add_index "ci_runners", ["is_shared"], name: "index_ci_runners_on_is_shared", using: :btree
444
  add_index "ci_runners", ["locked"], name: "index_ci_runners_on_locked", using: :btree
James Lopez's avatar
James Lopez committed
445
  add_index "ci_runners", ["token"], name: "index_ci_runners_on_token", using: :btree
446

447 448 449
  create_table "ci_stages", force: :cascade do |t|
    t.integer "project_id"
    t.integer "pipeline_id"
450 451
    t.datetime "created_at"
    t.datetime "updated_at"
452
    t.string "name"
453
    t.integer "status"
454
    t.integer "lock_version"
455 456
  end

457
  add_index "ci_stages", ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", unique: true, using: :btree
458 459
  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
460

Valery Sizov's avatar
Valery Sizov committed
461
  create_table "ci_trigger_requests", force: :cascade do |t|
462 463
    t.integer "trigger_id", null: false
    t.text "variables"
464 465
    t.datetime "created_at"
    t.datetime "updated_at"
466
    t.integer "commit_id"
467 468
  end

469 470
  add_index "ci_trigger_requests", ["commit_id"], name: "index_ci_trigger_requests_on_commit_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
471
  create_table "ci_triggers", force: :cascade do |t|
472
    t.string "token"
473 474
    t.datetime "created_at"
    t.datetime "updated_at"
475
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
476 477
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
478
    t.string "ref"
479 480
  end

481
  add_index "ci_triggers", ["project_id"], name: "index_ci_triggers_on_project_id", using: :btree
482

Valery Sizov's avatar
Valery Sizov committed
483
  create_table "ci_variables", force: :cascade do |t|
484
    t.string "key", null: false
485 486 487 488
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
489
    t.integer "project_id", null: false
490
    t.boolean "protected", default: false, null: false
491
    t.string "environment_scope", default: "*", null: false
492 493
  end

494
  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
495

Shinya Maeda's avatar
Shinya Maeda committed
496 497
  create_table "cluster_platforms_kubernetes", force: :cascade do |t|
    t.integer "cluster_id", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
498 499 500
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.text "api_url"
Shinya Maeda's avatar
Shinya Maeda committed
501 502 503 504 505 506 507 508 509 510 511 512 513 514
    t.text "ca_cert"
    t.string "namespace"
    t.string "username"
    t.text "encrypted_password"
    t.string "encrypted_password_iv"
    t.text "encrypted_token"
    t.string "encrypted_token_iv"
  end

  add_index "cluster_platforms_kubernetes", ["cluster_id"], name: "index_cluster_platforms_kubernetes_on_cluster_id", unique: true, using: :btree

  create_table "cluster_projects", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
515 516
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
517 518 519 520 521 522 523 524
  end

  add_index "cluster_projects", ["cluster_id"], name: "index_cluster_projects_on_cluster_id", using: :btree
  add_index "cluster_projects", ["project_id"], name: "index_cluster_projects_on_project_id", using: :btree

  create_table "cluster_providers_gcp", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "status"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
525 526 527
    t.integer "num_nodes", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
528 529 530 531 532 533 534 535 536 537 538 539 540
    t.text "status_reason"
    t.string "gcp_project_id", null: false
    t.string "zone", null: false
    t.string "machine_type"
    t.string "operation_id"
    t.string "endpoint"
    t.text "encrypted_access_token"
    t.string "encrypted_access_token_iv"
  end

  add_index "cluster_providers_gcp", ["cluster_id"], name: "index_cluster_providers_gcp_on_cluster_id", unique: true, using: :btree

  create_table "clusters", force: :cascade do |t|
541
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
542 543 544 545
    t.integer "provider_type"
    t.integer "platform_type"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
546 547
    t.boolean "enabled", default: true
    t.string "name", null: false
548
    t.string "environment_scope", default: "*", null: false
Shinya Maeda's avatar
Shinya Maeda committed
549 550
  end

Alessio Caiazza's avatar
Alessio Caiazza committed
551 552 553
  add_index "clusters", ["enabled"], name: "index_clusters_on_enabled", using: :btree
  add_index "clusters", ["user_id"], name: "index_clusters_on_user_id", using: :btree

554 555 556 557 558 559 560 561
  create_table "clusters_applications_helm", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
  end
562

Kamil Trzcinski's avatar
Kamil Trzcinski committed
563 564 565 566 567 568 569 570 571 572 573
  create_table "clusters_applications_ingress", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "status", null: false
    t.integer "ingress_type", null: false
    t.string "version", null: false
    t.string "cluster_ip"
    t.text "status_reason"
  end

574 575 576 577 578 579 580 581 582
  create_table "clusters_applications_prometheus", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
  end

583
  create_table "container_repositories", force: :cascade do |t|
584 585 586 587
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
588 589
  end

590 591 592
  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

593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615
  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
616 617 618 619 620 621 622 623 624 625
    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
626
  end
627

Valery Sizov's avatar
Valery Sizov committed
628
  create_table "deploy_keys_projects", force: :cascade do |t|
629 630
    t.integer "deploy_key_id", null: false
    t.integer "project_id", null: false
631 632
    t.datetime "created_at"
    t.datetime "updated_at"
633
    t.boolean "can_push", default: false, null: false
634
  end
635

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

638
  create_table "deployments", force: :cascade do |t|
Valery Sizov's avatar
Valery Sizov committed
639 640 641 642 643 644
    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
645
    t.integer "user_id"
Valery Sizov's avatar
Valery Sizov committed
646 647
    t.integer "deployable_id"
    t.string "deployable_type"
648 649
    t.datetime "created_at"
    t.datetime "updated_at"
650
    t.string "on_stop"
651 652
  end

653
  add_index "deployments", ["created_at"], name: "index_deployments_on_created_at", using: :btree
654 655
  add_index "deployments", ["environment_id", "id"], name: "index_deployments_on_environment_id_and_id", using: :btree
  add_index "deployments", ["environment_id", "iid", "project_id"], name: "index_deployments_on_environment_id_and_iid_and_project_id", using: :btree
656
  add_index "deployments", ["project_id", "iid"], name: "index_deployments_on_project_id_and_iid", unique: true, using: :btree
657

Valery Sizov's avatar
Valery Sizov committed
658
  create_table "emails", force: :cascade do |t|
659 660
    t.integer "user_id", null: false
    t.string "email", null: false
661 662
    t.datetime "created_at"
    t.datetime "updated_at"
663
    t.string "confirmation_token"
664 665
    t.datetime_with_timezone "confirmed_at"
    t.datetime_with_timezone "confirmation_sent_at"
666 667
  end

668
  add_index "emails", ["confirmation_token"], name: "index_emails_on_confirmation_token", unique: true, using: :btree
669 670 671
  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

672
  create_table "environments", force: :cascade do |t|
673
    t.integer "project_id", null: false
674
    t.string "name", null: false
675 676
    t.datetime "created_at"
    t.datetime "updated_at"
677 678
    t.string "external_url"
    t.string "environment_type"
679
    t.string "state", default: "available", null: false
Nick Thomas's avatar
Nick Thomas committed
680
    t.string "slug", null: false
681 682
  end

683
  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
684
  add_index "environments", ["project_id", "slug"], name: "index_environments_on_project_id_and_slug", unique: true, using: :btree
685

Valery Sizov's avatar
Valery Sizov committed
686
  create_table "events", force: :cascade do |t|
687 688 689
    t.integer "project_id"
    t.integer "author_id", null: false
    t.integer "target_id"
690 691
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
692 693 694 695
    t.integer "action", limit: 2, null: false
    t.string "target_type"
  end

696 697 698 699
  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", ["project_id", "id"], name: "index_events_on_project_id_and_id", using: :btree
  add_index "events", ["target_type", "target_id"], name: "index_events_on_target_type_and_target_id", using: :btree
700

701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718
  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

719 720 721 722 723 724 725 726 727
  create_table "fork_network_members", force: :cascade do |t|
    t.integer "fork_network_id", null: false
    t.integer "project_id", null: false
    t.integer "forked_from_project_id"
  end

  add_index "fork_network_members", ["fork_network_id"], name: "index_fork_network_members_on_fork_network_id", using: :btree
  add_index "fork_network_members", ["project_id"], name: "index_fork_network_members_on_project_id", unique: true, using: :btree

728 729 730 731 732 733 734
  create_table "fork_networks", force: :cascade do |t|
    t.integer "root_project_id"
    t.string "deleted_root_project_name"
  end

  add_index "fork_networks", ["root_project_id"], name: "index_fork_networks_on_root_project_id", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
735
  create_table "forked_project_links", force: :cascade do |t|
736 737
    t.integer "forked_to_project_id", null: false
    t.integer "forked_from_project_id", null: false
738 739
    t.datetime "created_at"
    t.datetime "updated_at"
740 741
  end

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

744 745
  create_table "gcp_clusters", force: :cascade do |t|
    t.integer "project_id", null: false
746
    t.integer "user_id"
747 748
    t.integer "service_id"
    t.integer "status"
749 750 751 752
    t.integer "gcp_cluster_size", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.boolean "enabled", default: true
753
    t.text "status_reason"
754 755 756
    t.string "project_namespace"
    t.string "endpoint"
    t.text "ca_cert"
757
    t.text "encrypted_kubernetes_token"
758 759
    t.string "encrypted_kubernetes_token_iv"
    t.string "username"
760
    t.text "encrypted_password"
761 762
    t.string "encrypted_password_iv"
    t.string "gcp_project_id", null: false
763 764 765
    t.string "gcp_cluster_zone", null: false
    t.string "gcp_cluster_name", null: false
    t.string "gcp_machine_type"
766
    t.string "gcp_operation_id"
767
    t.text "encrypted_gcp_token"
768 769 770 771 772
    t.string "encrypted_gcp_token_iv"
  end

  add_index "gcp_clusters", ["project_id"], name: "index_gcp_clusters_on_project_id", unique: true, using: :btree

773
  create_table "gpg_key_subkeys", force: :cascade do |t|
774
    t.integer "gpg_key_id", null: false
775 776 777 778
    t.binary "keyid"
    t.binary "fingerprint"
  end

779
  add_index "gpg_key_subkeys", ["fingerprint"], name: "index_gpg_key_subkeys_on_fingerprint", unique: true, using: :btree
780
  add_index "gpg_key_subkeys", ["gpg_key_id"], name: "index_gpg_key_subkeys_on_gpg_key_id", using: :btree
781
  add_index "gpg_key_subkeys", ["keyid"], name: "index_gpg_key_subkeys_on_keyid", unique: true, using: :btree
782

Alexis Reigel's avatar
Alexis Reigel committed
783
  create_table "gpg_keys", force: :cascade do |t|
784 785
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
786
    t.integer "user_id"
787 788
    t.binary "primary_keyid"
    t.binary "fingerprint"
789
    t.text "key"
Alexis Reigel's avatar
Alexis Reigel committed
790 791
  end

792 793
  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
794 795
  add_index "gpg_keys", ["user_id"], name: "index_gpg_keys_on_user_id", using: :btree

796
  create_table "gpg_signatures", force: :cascade do |t|
797 798
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
799 800
    t.integer "project_id"
    t.integer "gpg_key_id"
801 802
    t.binary "commit_sha"
    t.binary "gpg_key_primary_keyid"
803 804
    t.text "gpg_key_user_name"
    t.text "gpg_key_user_email"
805
    t.integer "verification_status", limit: 2, default: 0, null: false
806
    t.integer "gpg_key_subkey_id"
807 808
  end

809
  add_index "gpg_signatures", ["commit_sha"], name: "index_gpg_signatures_on_commit_sha", unique: true, using: :btree
810 811
  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
812
  add_index "gpg_signatures", ["gpg_key_subkey_id"], name: "index_gpg_signatures_on_gpg_key_subkey_id", using: :btree
813 814
  add_index "gpg_signatures", ["project_id"], name: "index_gpg_signatures_on_project_id", using: :btree

815 816 817 818 819 820 821 822 823 824 825
  create_table "group_custom_attributes", force: :cascade do |t|
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "group_id", null: false
    t.string "key", null: false
    t.string "value", null: false
  end

  add_index "group_custom_attributes", ["group_id", "key"], name: "index_group_custom_attributes_on_group_id_and_key", unique: true, using: :btree
  add_index "group_custom_attributes", ["key", "value"], name: "index_group_custom_attributes_on_key_and_value", using: :btree

Valery Sizov's avatar
Valery Sizov committed
826
  create_table "identities", force: :cascade do |t|
827 828 829
    t.string "extern_uid"
    t.string "provider"
    t.integer "user_id"
830 831
    t.datetime "created_at"
    t.datetime "updated_at"
832 833 834 835
  end

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

836
  create_table "issue_assignees", id: false, force: :cascade do |t|
837 838 839 840 841 842 843
    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

844
  create_table "issue_metrics", force: :cascade do |t|
845
    t.integer "issue_id", null: false
846
    t.datetime "first_mentioned_in_commit_at"
847 848
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
849 850
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
851 852 853 854
  end

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

Valery Sizov's avatar
Valery Sizov committed
855
  create_table "issues", force: :cascade do |t|
856 857 858
    t.string "title"
    t.integer "author_id"
    t.integer "project_id"
859 860
    t.datetime "created_at"
    t.datetime "updated_at"
861 862 863 864 865
    t.text "description"
    t.integer "milestone_id"
    t.string "state"
    t.integer "iid"
    t.integer "updated_by_id"
866
    t.boolean "confidential", default: false, null: false
867 868 869 870 871
    t.date "due_date"
    t.integer "moved_to_id"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
872
    t.integer "time_estimate"
873
    t.integer "relative_position"
874
    t.integer "cached_markdown_version"
875 876
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
877
    t.boolean "discussion_locked"
878
    t.datetime_with_timezone "closed_at"
Andrew8xx8's avatar
Andrew8xx8 committed
879 880
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
881
  add_index "issues", ["author_id"], name: "index_issues_on_author_id", using: :btree
882
  add_index "issues", ["confidential"], name: "index_issues_on_confidential", using: :btree
883
  add_index "issues", ["description"], name: "index_issues_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
884
  add_index "issues", ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
885
  add_index "issues", ["moved_to_id"], name: "index_issues_on_moved_to_id", where: "(moved_to_id IS NOT NULL)", using: :btree
886
  add_index "issues", ["project_id", "created_at", "id", "state"], name: "index_issues_on_project_id_and_created_at_and_id_and_state", using: :btree
887
  add_index "issues", ["project_id", "due_date", "id", "state"], name: "idx_issues_on_project_id_and_due_date_and_id_and_state_partial", where: "(due_date IS NOT NULL)", using: :btree
888
  add_index "issues", ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
889
  add_index "issues", ["project_id", "updated_at", "id", "state"], name: "index_issues_on_project_id_and_updated_at_and_id_and_state", using: :btree
890
  add_index "issues", ["relative_position"], name: "index_issues_on_relative_position", using: :btree
891
  add_index "issues", ["state"], name: "index_issues_on_state", using: :btree
892
  add_index "issues", ["title"], name: "index_issues_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
893
  add_index "issues", ["updated_at"], name: "index_issues_on_updated_at", using: :btree
894
  add_index "issues", ["updated_by_id"], name: "index_issues_on_updated_by_id", where: "(updated_by_id IS NOT NULL)", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
895

Valery Sizov's avatar
Valery Sizov committed
896
  create_table "keys", force: :cascade do |t|
897
    t.integer "user_id"
898 899
    t.datetime "created_at"
    t.datetime "updated_at"
900 901 902 903 904
    t.text "key"
    t.string "title"
    t.string "type"
    t.string "fingerprint"
    t.boolean "public", default: false, null: false
905
    t.datetime "last_used_at"
Andrew8xx8's avatar
Andrew8xx8 committed
906 907
  end

908
  add_index "keys", ["fingerprint"], name: "index_keys_on_fingerprint", unique: true, using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
909
  add_index "keys", ["user_id"], name: "index_keys_on_user_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
910

Valery Sizov's avatar
Valery Sizov committed
911
  create_table "label_links", force: :cascade do |t|
912 913 914
    t.integer "label_id"
    t.integer "target_id"
    t.string "target_type"
915 916 917 918
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
919 920 921
  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

922 923 924 925 926 927 928 929 930 931 932
  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
933
  create_table "labels", force: :cascade do |t|
934 935 936
    t.string "title"
    t.string "color"
    t.integer "project_id"
937 938
    t.datetime "created_at"
    t.datetime "updated_at"
939 940 941
    t.boolean "template", default: false
    t.string "description"
    t.text "description_html"
942 943
    t.string "type"
    t.integer "group_id"
944
    t.integer "cached_markdown_version"
945 946
  end

947
  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
948
  add_index "labels", ["project_id"], name: "index_labels_on_project_id", using: :btree
949
  add_index "labels", ["template"], name: "index_labels_on_template", where: "template", using: :btree
Ahmad Sherif's avatar
Ahmad Sherif committed
950
  add_index "labels", ["title"], name: "index_labels_on_title", using: :btree
951
  add_index "labels", ["type", "project_id"], name: "index_labels_on_type_and_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
952

953 954 955 956 957 958 959 960 961 962
  create_table "lfs_file_locks", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "user_id", null: false
    t.datetime "created_at", null: false
    t.string "path", limit: 511
  end

  add_index "lfs_file_locks", ["project_id", "path"], name: "index_lfs_file_locks_on_project_id_and_path", unique: true, using: :btree
  add_index "lfs_file_locks", ["user_id"], name: "index_lfs_file_locks_on_user_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
963
  create_table "lfs_objects", force: :cascade do |t|
964 965
    t.string "oid", null: false
    t.integer "size", limit: 8, null: false
Marin Jankovski's avatar
Marin Jankovski committed
966 967
    t.datetime "created_at"
    t.datetime "updated_at"
968
    t.string "file"
Marin Jankovski's avatar
Marin Jankovski committed
969 970
  end

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

Valery Sizov's avatar
Valery Sizov committed
973
  create_table "lfs_objects_projects", force: :cascade do |t|
974 975
    t.integer "lfs_object_id", null: false
    t.integer "project_id", null: false
Marin Jankovski's avatar
Marin Jankovski committed
976 977 978 979 980 981
    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

982
  create_table "lists", force: :cascade do |t|
983 984 985 986 987 988
    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
989 990
  end

991
  add_index "lists", ["board_id", "label_id"], name: "index_lists_on_board_id_and_label_id", unique: true, using: :btree
992 993
  add_index "lists", ["label_id"], name: "index_lists_on_label_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
994
  create_table "members", force: :cascade do |t|
995 996 997 998 999 1000
    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"
1001 1002
    t.datetime "created_at"
    t.datetime "updated_at"
1003 1004 1005
    t.integer "created_by_id"
    t.string "invite_email"
    t.string "invite_token"
Douwe Maan's avatar
Douwe Maan committed
1006
    t.datetime "invite_accepted_at"
1007
    t.datetime "requested_at"
1008
    t.date "expires_at"
1009 1010
  end

1011
  add_index "members", ["access_level"], name: "index_members_on_access_level", using: :btree
Douwe Maan's avatar
Douwe Maan committed
1012
  add_index "members", ["invite_token"], name: "index_members_on_invite_token", unique: true, using: :btree
1013
  add_index "members", ["requested_at"], name: "index_members_on_requested_at", using: :btree
1014 1015 1016
  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

1017
  create_table "merge_request_diff_commits", id: false, force: :cascade do |t|
1018 1019
    t.datetime_with_timezone "authored_date"
    t.datetime_with_timezone "committed_date"
1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030
    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
1031
  add_index "merge_request_diff_commits", ["sha"], name: "index_merge_request_diff_commits_on_sha", using: :btree
1032

1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044
  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
1045
    t.boolean "binary"
1046 1047 1048 1049
  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
1050
  create_table "merge_request_diffs", force: :cascade do |t|
1051 1052
    t.string "state"
    t.integer "merge_request_id", null: false
1053 1054
    t.datetime "created_at"
    t.datetime "updated_at"
1055 1056 1057 1058
    t.string "base_commit_sha"
    t.string "real_size"
    t.string "head_commit_sha"
    t.string "start_commit_sha"
1059
    t.integer "commits_count"
1060 1061
  end

1062
  add_index "merge_request_diffs", ["merge_request_id", "id"], name: "index_merge_request_diffs_on_merge_request_id_and_id", using: :btree
1063

1064
  create_table "merge_request_metrics", force: :cascade do |t|
1065
    t.integer "merge_request_id", null: false
1066 1067
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
Timothy Andrew's avatar
Timothy Andrew committed
1068 1069
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
1070 1071
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1072
    t.integer "pipeline_id"
1073 1074 1075
    t.integer "merged_by_id"
    t.integer "latest_closed_by_id"
    t.datetime_with_timezone "latest_closed_at"
1076 1077
  end

1078
  add_index "merge_request_metrics", ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at", using: :btree
1079
  add_index "merge_request_metrics", ["merge_request_id"], name: "index_merge_request_metrics", using: :btree
1080
  add_index "merge_request_metrics", ["pipeline_id"], name: "index_merge_request_metrics_on_pipeline_id", using: :btree
1081

Valery Sizov's avatar
Valery Sizov committed
1082
  create_table "merge_requests", force: :cascade do |t|
1083 1084
    t.string "target_branch", null: false
    t.string "source_branch", null: false
1085
    t.integer "source_project_id"
1086 1087 1088
    t.integer "author_id"
    t.integer "assignee_id"
    t.string "title"
1089 1090
    t.datetime "created_at"
    t.datetime "updated_at"
1091
    t.integer "milestone_id"
1092 1093
    t.string "state", default: "opened", null: false
    t.string "merge_status", default: "unchecked", null: false
1094 1095 1096 1097 1098 1099
    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"
1100
    t.boolean "merge_when_pipeline_succeeds", default: false, null: false
1101 1102
    t.integer "merge_user_id"
    t.string "merge_commit_sha"
1103
    t.string "in_progress_merge_commit_sha"
Valery Sizov's avatar
Valery Sizov committed
1104
    t.integer "lock_version"
1105 1106
    t.text "title_html"
    t.text "description_html"
1107
    t.integer "time_estimate"
1108
    t.integer "cached_markdown_version"
1109 1110
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1111
    t.integer "head_pipeline_id"
1112
    t.string "merge_jid"
1113
    t.boolean "discussion_locked"
1114
    t.integer "latest_merge_request_diff_id"
1115
    t.string "rebase_commit_sha"
Andrew8xx8's avatar
Andrew8xx8 committed
1116
  end
tiagonbotelho's avatar
tiagonbotelho committed
1117

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1118 1119 1120
  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
1121
  add_index "merge_requests", ["description"], name: "index_merge_requests_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
1122
  add_index "merge_requests", ["head_pipeline_id"], name: "index_merge_requests_on_head_pipeline_id", using: :btree
1123
  add_index "merge_requests", ["latest_merge_request_diff_id"], name: "index_merge_requests_on_latest_merge_request_diff_id", using: :btree
1124
  add_index "merge_requests", ["merge_user_id"], name: "index_merge_requests_on_merge_user_id", where: "(merge_user_id IS NOT NULL)", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1125 1126
  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
1127
  add_index "merge_requests", ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_and_branch_state_opened", where: "((state)::text = 'opened'::text)", using: :btree
1128
  add_index "merge_requests", ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_id_and_source_branch", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1129
  add_index "merge_requests", ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
1130
  add_index "merge_requests", ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid", unique: true, using: :btree
1131
  add_index "merge_requests", ["target_project_id", "merge_commit_sha", "id"], name: "index_merge_requests_on_tp_id_and_merge_commit_sha_and_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1132
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title", using: :btree
1133
  add_index "merge_requests", ["title"], name: "index_merge_requests_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
1134
  add_index "merge_requests", ["updated_by_id"], name: "index_merge_requests_on_updated_by_id", where: "(updated_by_id IS NOT NULL)", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1135

1136
  create_table "merge_requests_closing_issues", force: :cascade do |t|
1137 1138 1139 1140
    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
1141 1142
  end

Timothy Andrew's avatar
Timothy Andrew committed
1143 1144 1145
  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
1146
  create_table "milestones", force: :cascade do |t|
1147
    t.string "title", null: false
Felipe Artur's avatar
Felipe Artur committed
1148
    t.integer "project_id"
1149 1150
    t.text "description"
    t.date "due_date"
1151 1152
    t.datetime "created_at"
    t.datetime "updated_at"
1153 1154 1155 1156
    t.string "state"
    t.integer "iid"
    t.text "title_html"
    t.text "description_html"
1157
    t.date "start_date"
1158
    t.integer "cached_markdown_version"
Felipe Artur's avatar
Felipe Artur committed
1159
    t.integer "group_id"
Andrew8xx8's avatar
Andrew8xx8 committed
1160 1161
  end

1162
  add_index "milestones", ["description"], name: "index_milestones_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1163
  add_index "milestones", ["due_date"], name: "index_milestones_on_due_date", using: :btree
Felipe Artur's avatar
Felipe Artur committed
1164
  add_index "milestones", ["group_id"], name: "index_milestones_on_group_id", using: :btree
1165
  add_index "milestones", ["project_id", "iid"], name: "index_milestones_on_project_id_and_iid", unique: true, using: :btree
1166
  add_index "milestones", ["title"], name: "index_milestones_on_title", using: :btree
1167
  add_index "milestones", ["title"], name: "index_milestones_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
1168

Valery Sizov's avatar
Valery Sizov committed
1169
  create_table "namespaces", force: :cascade do |t|
1170 1171 1172
    t.string "name", null: false
    t.string "path", null: false
    t.integer "owner_id"
1173 1174
    t.datetime "created_at"
    t.datetime "updated_at"
1175 1176 1177 1178 1179
    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
1180
    t.boolean "request_access_enabled", default: false, null: false
Nick Thomas's avatar
Nick Thomas committed
1181
    t.text "description_html"
1182
    t.boolean "lfs_enabled"
1183
    t.integer "parent_id"
1184 1185
    t.boolean "require_two_factor_authentication", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
1186
    t.integer "cached_markdown_version"
Andrew8xx8's avatar
Andrew8xx8 committed
1187 1188
  end

1189
  add_index "namespaces", ["created_at"], name: "index_namespaces_on_created_at", using: :btree
1190
  add_index "namespaces", ["name", "parent_id"], name: "index_namespaces_on_name_and_parent_id", unique: true, using: :btree
1191
  add_index "namespaces", ["name"], name: "index_namespaces_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1192
  add_index "namespaces", ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
1193
  add_index "namespaces", ["parent_id", "id"], name: "index_namespaces_on_parent_id_and_id", unique: true, using: :btree
1194
  add_index "namespaces", ["path"], name: "index_namespaces_on_path", using: :btree
1195
  add_index "namespaces", ["path"], name: "index_namespaces_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
1196
  add_index "namespaces", ["require_two_factor_authentication"], name: "index_namespaces_on_require_two_factor_authentication", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1197
  add_index "namespaces", ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1198

Valery Sizov's avatar
Valery Sizov committed
1199
  create_table "notes", force: :cascade do |t|
1200 1201 1202
    t.text "note"
    t.string "noteable_type"
    t.integer "author_id"
1203 1204
    t.datetime "created_at"
    t.datetime "updated_at"
1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215
    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"
1216
    t.datetime "resolved_at"
1217 1218 1219
    t.integer "resolved_by_id"
    t.string "discussion_id"
    t.text "note_html"
1220
    t.integer "cached_markdown_version"
1221
    t.text "change_position"
1222
    t.boolean "resolved_by_push"
Andrew8xx8's avatar
Andrew8xx8 committed
1223 1224
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1225 1226 1227
  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
1228
  add_index "notes", ["discussion_id"], name: "index_notes_on_discussion_id", using: :btree
1229
  add_index "notes", ["line_code"], name: "index_notes_on_line_code", using: :btree
1230
  add_index "notes", ["note"], name: "index_notes_on_note_trigram", using: :gin, opclasses: {"note"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1231 1232 1233
  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
1234
  add_index "notes", ["updated_at"], name: "index_notes_on_updated_at", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1235

1236
  create_table "notification_settings", force: :cascade do |t|
1237 1238 1239 1240 1241 1242
    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
1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254
    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"
1255 1256
  end

1257
  add_index "notification_settings", ["source_id", "source_type"], name: "index_notification_settings_on_source_id_and_source_type", using: :btree
1258
  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
1259 1260
  add_index "notification_settings", ["user_id"], name: "index_notification_settings_on_user_id", using: :btree

Valery Sizov's avatar
Valery Sizov committed
1261
  create_table "oauth_access_grants", force: :cascade do |t|
1262 1263 1264 1265 1266 1267
    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
1268
    t.datetime "revoked_at"
1269
    t.string "scopes"
Valery Sizov's avatar
Valery Sizov committed
1270 1271 1272 1273
  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
1274
  create_table "oauth_access_tokens", force: :cascade do |t|
1275 1276 1277 1278 1279
    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
1280
    t.datetime "revoked_at"
1281 1282
    t.datetime "created_at", null: false
    t.string "scopes"
Valery Sizov's avatar
Valery Sizov committed
1283 1284 1285 1286 1287 1288
  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
1289
  create_table "oauth_applications", force: :cascade do |t|
1290 1291 1292 1293 1294
    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
1295 1296
    t.datetime "created_at"
    t.datetime "updated_at"
1297 1298
    t.integer "owner_id"
    t.string "owner_type"
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
1299
    t.boolean "trusted", default: false, null: false
Valery Sizov's avatar
Valery Sizov committed
1300 1301 1302 1303 1304
  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

1305 1306 1307 1308 1309
  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
1310 1311
  create_table "pages_domains", force: :cascade do |t|
    t.integer "project_id"
1312 1313 1314 1315 1316
    t.text "certificate"
    t.text "encrypted_key"
    t.string "encrypted_key_iv"
    t.string "encrypted_key_salt"
    t.string "domain"
1317 1318 1319
    t.datetime_with_timezone "verified_at"
    t.string "verification_code", null: false
    t.datetime_with_timezone "enabled_until"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1320 1321 1322
  end

  add_index "pages_domains", ["domain"], name: "index_pages_domains_on_domain", unique: true, using: :btree
1323
  add_index "pages_domains", ["project_id", "enabled_until"], name: "index_pages_domains_on_project_id_and_enabled_until", using: :btree
1324
  add_index "pages_domains", ["project_id"], name: "index_pages_domains_on_project_id", using: :btree
1325 1326
  add_index "pages_domains", ["verified_at", "enabled_until"], name: "index_pages_domains_on_verified_at_and_enabled_until", using: :btree
  add_index "pages_domains", ["verified_at"], name: "index_pages_domains_on_verified_at", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1327

1328
  create_table "personal_access_tokens", force: :cascade do |t|
1329 1330 1331 1332
    t.integer "user_id", null: false
    t.string "token", null: false
    t.string "name", null: false
    t.boolean "revoked", default: false
1333
    t.date "expires_at"
1334 1335
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1336
    t.string "scopes", default: "--- []\n", null: false
Simon Vocella's avatar
Simon Vocella committed
1337
    t.boolean "impersonation", default: false, null: false
1338 1339 1340 1341 1342
  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

1343
  create_table "project_authorizations", id: false, force: :cascade do |t|
1344 1345 1346 1347 1348
    t.integer "user_id"
    t.integer "project_id"
    t.integer "access_level"
  end

1349
  add_index "project_authorizations", ["project_id"], name: "index_project_authorizations_on_project_id", using: :btree
1350 1351
  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

1352
  create_table "project_auto_devops", force: :cascade do |t|
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
1353
    t.integer "project_id", null: false
1354 1355
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1356 1357
    t.boolean "enabled"
    t.string "domain"
1358 1359
  end

Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
1360
  add_index "project_auto_devops", ["project_id"], name: "index_project_auto_devops_on_project_id", unique: true, using: :btree
1361

1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372
  create_table "project_custom_attributes", force: :cascade do |t|
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "project_id", null: false
    t.string "key", null: false
    t.string "value", null: false
  end

  add_index "project_custom_attributes", ["key", "value"], name: "index_project_custom_attributes_on_key_and_value", using: :btree
  add_index "project_custom_attributes", ["project_id", "key"], name: "index_project_custom_attributes_on_project_id_and_key", unique: true, using: :btree

1373
  create_table "project_features", force: :cascade do |t|
1374 1375 1376 1377 1378 1379
    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"
1380 1381
    t.datetime "created_at"
    t.datetime "updated_at"
1382
    t.integer "repository_access_level", default: 20, null: false
1383 1384 1385 1386
  end

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

1387
  create_table "project_group_links", force: :cascade do |t|
1388 1389
    t.integer "project_id", null: false
    t.integer "group_id", null: false
1390 1391
    t.datetime "created_at"
    t.datetime "updated_at"
1392 1393
    t.integer "group_access", default: 30, null: false
    t.date "expires_at"
1394 1395
  end

1396
  add_index "project_group_links", ["group_id"], name: "index_project_group_links_on_group_id", using: :btree
1397
  add_index "project_group_links", ["project_id"], name: "index_project_group_links_on_project_id", using: :btree
1398

Valery Sizov's avatar
Valery Sizov committed
1399
  create_table "project_import_data", force: :cascade do |t|
1400
    t.integer "project_id"
1401 1402 1403 1404
    t.text "data"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
1405 1406
  end

1407 1408
  add_index "project_import_data", ["project_id"], name: "index_project_import_data_on_project_id", using: :btree

1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421
  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
1422
  create_table "projects", force: :cascade do |t|
1423 1424 1425
    t.string "name"
    t.string "path"
    t.text "description"
1426 1427
    t.datetime "created_at"
    t.datetime "updated_at"
1428 1429
    t.integer "creator_id"
    t.integer "namespace_id"
1430
    t.datetime "last_activity_at"
1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448
    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"
1449
    t.datetime "last_repository_check_at"
1450
    t.boolean "container_registry_enabled"
1451
    t.boolean "only_allow_merge_if_pipeline_succeeds", default: false, null: false
1452 1453
    t.boolean "has_external_issue_tracker"
    t.string "repository_storage", default: "default", null: false
1454
    t.boolean "request_access_enabled", default: false, null: false
1455
    t.boolean "has_external_wiki"
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
1456
    t.string "ci_config_path"
1457 1458
    t.boolean "lfs_enabled"
    t.text "description_html"
Valery Sizov's avatar
Valery Sizov committed
1459
    t.boolean "only_allow_merge_if_all_discussions_are_resolved"
1460
    t.boolean "printing_merge_request_link_enabled", default: true, null: false
1461
    t.integer "auto_cancel_pending_pipelines", default: 1, null: false
1462
    t.string "import_jid"
1463
    t.integer "cached_markdown_version"
1464
    t.text "delete_error"
1465
    t.datetime "last_repository_updated_at"
1466
    t.integer "storage_version", limit: 2
Sean McGivern's avatar
Sean McGivern committed
1467
    t.boolean "resolve_outdated_diff_discussions"
1468
    t.boolean "repository_read_only"
1469
    t.boolean "merge_requests_ff_only_enabled", default: false
1470
    t.boolean "merge_requests_rebase_enabled", default: false, null: false
1471
    t.integer "jobs_cache_index"
Andrew8xx8's avatar
Andrew8xx8 committed
1472 1473
  end

1474
  add_index "projects", ["ci_id"], name: "index_projects_on_ci_id", using: :btree
1475
  add_index "projects", ["created_at"], name: "index_projects_on_created_at", using: :btree
1476
  add_index "projects", ["creator_id"], name: "index_projects_on_creator_id", using: :btree
1477
  add_index "projects", ["description"], name: "index_projects_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
1478
  add_index "projects", ["id"], name: "index_projects_on_id_partial_for_visibility", unique: true, where: "(visibility_level = ANY (ARRAY[10, 20]))", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1479
  add_index "projects", ["last_activity_at"], name: "index_projects_on_last_activity_at", using: :btree
1480
  add_index "projects", ["last_repository_check_failed"], name: "index_projects_on_last_repository_check_failed", using: :btree
1481
  add_index "projects", ["last_repository_updated_at"], name: "index_projects_on_last_repository_updated_at", using: :btree
1482
  add_index "projects", ["name"], name: "index_projects_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1483
  add_index "projects", ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1484
  add_index "projects", ["path"], name: "index_projects_on_path", using: :btree
1485
  add_index "projects", ["path"], name: "index_projects_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
James Lopez's avatar
James Lopez committed
1486
  add_index "projects", ["pending_delete"], name: "index_projects_on_pending_delete", using: :btree
1487
  add_index "projects", ["repository_storage"], name: "index_projects_on_repository_storage", using: :btree
1488
  add_index "projects", ["runners_token"], name: "index_projects_on_runners_token", using: :btree
1489
  add_index "projects", ["star_count"], name: "index_projects_on_star_count", using: :btree
1490
  add_index "projects", ["visibility_level"], name: "index_projects_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1491

1492
  create_table "protected_branch_merge_access_levels", force: :cascade do |t|
1493 1494 1495 1496
    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
1497 1498 1499 1500 1501
  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|
1502 1503 1504 1505
    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
1506 1507 1508 1509
  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
1510
  create_table "protected_branches", force: :cascade do |t|
1511 1512
    t.integer "project_id", null: false
    t.string "name", null: false
1513 1514
    t.datetime "created_at"
    t.datetime "updated_at"
Andrew8xx8's avatar
Andrew8xx8 committed
1515 1516
  end

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

1519
  create_table "protected_tag_create_access_levels", force: :cascade do |t|
1520
    t.integer "protected_tag_id", null: false
1521 1522 1523
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
1524 1525 1526 1527
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

1528 1529
  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
1530 1531 1532 1533

  create_table "protected_tags", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
1534 1535
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1536 1537 1538 1539
  end

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

1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552
  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

1553 1554 1555 1556 1557 1558
  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
1559
    t.boolean "permanent"
1560 1561
  end

1562 1563 1564
  add_index "redirect_routes", ["path"], name: "index_redirect_routes_on_path", unique: true, using: :btree
  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
1565
  create_table "releases", force: :cascade do |t|
1566 1567 1568
    t.string "tag"
    t.text "description"
    t.integer "project_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1569 1570
    t.datetime "created_at"
    t.datetime "updated_at"
1571
    t.text "description_html"
1572
    t.integer "cached_markdown_version"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1573 1574 1575 1576 1577
  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

1578 1579 1580 1581 1582 1583
  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"
1584
    t.string "name"
1585 1586 1587
  end

  add_index "routes", ["path"], name: "index_routes_on_path", unique: true, using: :btree
1588
  add_index "routes", ["path"], name: "index_routes_on_path_text_pattern_ops", using: :btree, opclasses: {"path"=>"varchar_pattern_ops"}
1589 1590
  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
1591
  create_table "sent_notifications", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
1592 1593
    t.integer "project_id"
    t.integer "noteable_id"
1594
    t.string "noteable_type"
Douwe Maan's avatar
Douwe Maan committed
1595
    t.integer "recipient_id"
1596 1597 1598 1599 1600
    t.string "commit_id"
    t.string "reply_key", null: false
    t.string "line_code"
    t.string "note_type"
    t.text "position"
1601
    t.string "in_reply_to_discussion_id"
Douwe Maan's avatar
Douwe Maan committed
1602 1603 1604 1605
  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
1606
  create_table "services", force: :cascade do |t|
1607 1608 1609
    t.string "type"
    t.string "title"
    t.integer "project_id"
1610 1611
    t.datetime "created_at"
    t.datetime "updated_at"
1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624
    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
1625
    t.boolean "commit_events", default: true, null: false
1626
    t.boolean "job_events", default: false, null: false
1627 1628
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1629
  add_index "services", ["project_id"], name: "index_services_on_project_id", using: :btree
1630
  add_index "services", ["template"], name: "index_services_on_template", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1631

Valery Sizov's avatar
Valery Sizov committed
1632
  create_table "snippets", force: :cascade do |t|
1633 1634 1635 1636
    t.string "title"
    t.text "content"
    t.integer "author_id", null: false
    t.integer "project_id"
1637 1638
    t.datetime "created_at"
    t.datetime "updated_at"
1639 1640 1641 1642 1643
    t.string "file_name"
    t.string "type"
    t.integer "visibility_level", default: 0, null: false
    t.text "title_html"
    t.text "content_html"
1644
    t.integer "cached_markdown_version"
1645 1646
    t.text "description"
    t.text "description_html"
Andrew8xx8's avatar
Andrew8xx8 committed
1647 1648
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1649
  add_index "snippets", ["author_id"], name: "index_snippets_on_author_id", using: :btree
1650
  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
1651
  add_index "snippets", ["project_id"], name: "index_snippets_on_project_id", using: :btree
1652
  add_index "snippets", ["title"], name: "index_snippets_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
1653
  add_index "snippets", ["updated_at"], name: "index_snippets_on_updated_at", using: :btree
1654
  add_index "snippets", ["visibility_level"], name: "index_snippets_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1655

1656
  create_table "spam_logs", force: :cascade do |t|
1657 1658 1659 1660 1661 1662 1663 1664 1665 1666
    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
1667
    t.boolean "recaptcha_verified", default: false, null: false
1668 1669
  end

Valery Sizov's avatar
Valery Sizov committed
1670
  create_table "subscriptions", force: :cascade do |t|
1671 1672 1673 1674
    t.integer "user_id"
    t.integer "subscribable_id"
    t.string "subscribable_type"
    t.boolean "subscribed"
Valery Sizov's avatar
Valery Sizov committed
1675 1676
    t.datetime "created_at"
    t.datetime "updated_at"
1677
    t.integer "project_id"
Valery Sizov's avatar
Valery Sizov committed
1678 1679
  end

1680
  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
1681

1682 1683 1684
  create_table "system_note_metadata", force: :cascade do |t|
    t.integer "note_id", null: false
    t.integer "commit_count"
1685
    t.string "action"
1686 1687
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Valery Sizov's avatar
Valery Sizov committed
1688 1689
  end

1690
  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
1691

Valery Sizov's avatar
Valery Sizov committed
1692
  create_table "taggings", force: :cascade do |t|
1693 1694 1695 1696 1697 1698
    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
1699 1700 1701
    t.datetime "created_at"
  end

1702
  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true, using: :btree
1703 1704
  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
1705
  create_table "tags", force: :cascade do |t|
1706
    t.string "name"
1707
    t.integer "taggings_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1708 1709
  end

1710 1711
  add_index "tags", ["name"], name: "index_tags_on_name", unique: true, using: :btree

1712 1713 1714 1715 1716
  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
1717 1718
    t.integer "issue_id"
    t.integer "merge_request_id"
1719
    t.datetime_with_timezone "spent_at"
1720 1721
  end

1722 1723
  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
1724 1725
  add_index "timelogs", ["user_id"], name: "index_timelogs_on_user_id", using: :btree

1726
  create_table "todos", force: :cascade do |t|
1727 1728 1729 1730
    t.integer "user_id", null: false
    t.integer "project_id", null: false
    t.integer "target_id"
    t.string "target_type", null: false
1731
    t.integer "author_id", null: false
1732 1733
    t.integer "action", null: false
    t.string "state", null: false
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
1734 1735
    t.datetime "created_at"
    t.datetime "updated_at"
1736 1737
    t.integer "note_id"
    t.string "commit_id"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
1738 1739
  end

1740
  add_index "todos", ["author_id"], name: "index_todos_on_author_id", using: :btree
James Lopez's avatar
James Lopez committed
1741
  add_index "todos", ["commit_id"], name: "index_todos_on_commit_id", using: :btree
1742 1743 1744 1745
  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
1746

1747 1748 1749 1750
  create_table "trending_projects", force: :cascade do |t|
    t.integer "project_id", null: false
  end

1751
  add_index "trending_projects", ["project_id"], name: "index_trending_projects_on_project_id", unique: true, using: :btree
1752

1753
  create_table "u2f_registrations", force: :cascade do |t|
1754 1755 1756 1757 1758 1759 1760 1761
    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"
1762 1763 1764 1765 1766
  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

1767 1768
  create_table "uploads", force: :cascade do |t|
    t.integer "size", limit: 8, null: false
1769
    t.string "path", limit: 511, null: false
1770 1771 1772 1773 1774
    t.string "checksum", limit: 64
    t.integer "model_id"
    t.string "model_type"
    t.string "uploader", null: false
    t.datetime "created_at", null: false
Micaël Bergeron's avatar
Micaël Bergeron committed
1775 1776
    t.string "mount_point"
    t.string "secret"
1777 1778 1779 1780
  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
Micaël Bergeron's avatar
Micaël Bergeron committed
1781
  add_index "uploads", ["uploader", "path"], name: "index_uploads_on_uploader_and_path", using: :btree
1782

1783
  create_table "user_agent_details", force: :cascade do |t|
1784 1785 1786 1787 1788 1789 1790
    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
1791 1792
  end

1793 1794
  add_index "user_agent_details", ["subject_id", "subject_type"], name: "index_user_agent_details_on_subject_id_and_subject_type", using: :btree

1795
  create_table "user_callouts", force: :cascade do |t|
1796
    t.integer "feature_name", null: false
1797 1798 1799 1800 1801 1802
    t.integer "user_id", null: false
  end

  add_index "user_callouts", ["user_id", "feature_name"], name: "index_user_callouts_on_user_id_and_feature_name", unique: true, using: :btree
  add_index "user_callouts", ["user_id"], name: "index_user_callouts_on_user_id", using: :btree

1803
  create_table "user_custom_attributes", force: :cascade do |t|
1804 1805
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1806 1807 1808 1809 1810 1811 1812 1813
    t.integer "user_id", null: false
    t.string "key", null: false
    t.string "value", null: false
  end

  add_index "user_custom_attributes", ["key", "value"], name: "index_user_custom_attributes_on_key_and_value", using: :btree
  add_index "user_custom_attributes", ["user_id", "key"], name: "index_user_custom_attributes_on_user_id_and_key", unique: true, using: :btree

1814 1815 1816 1817 1818 1819 1820 1821 1822 1823
  create_table "user_synced_attributes_metadata", force: :cascade do |t|
    t.boolean "name_synced", default: false
    t.boolean "email_synced", default: false
    t.boolean "location_synced", default: false
    t.integer "user_id", null: false
    t.string "provider"
  end

  add_index "user_synced_attributes_metadata", ["user_id"], name: "index_user_synced_attributes_metadata_on_user_id", unique: true, using: :btree

Valery Sizov's avatar
Valery Sizov committed
1824
  create_table "users", force: :cascade do |t|
1825 1826 1827
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
Andrew8xx8's avatar
Andrew8xx8 committed
1828 1829
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
1830
    t.integer "sign_in_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1831 1832
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
1833 1834
    t.string "current_sign_in_ip"
    t.string "last_sign_in_ip"
1835 1836
    t.datetime "created_at"
    t.datetime "updated_at"
1837 1838
    t.string "name"
    t.boolean "admin", default: false, null: false
1839
    t.integer "projects_limit", null: false
1840 1841 1842 1843 1844
    t.string "skype", default: "", null: false
    t.string "linkedin", default: "", null: false
    t.string "twitter", default: "", null: false
    t.string "bio"
    t.integer "failed_attempts", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
1845
    t.datetime "locked_at"
1846 1847 1848 1849 1850
    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
1851
    t.datetime "password_expires_at"
1852
    t.integer "created_by_id"
1853
    t.datetime "last_credential_check_at"
1854 1855
    t.string "avatar"
    t.string "confirmation_token"
1856 1857
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876
    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"
1877
    t.datetime "otp_grace_period_started_at"
1878
    t.boolean "external", default: false
Nick Thomas's avatar
Nick Thomas committed
1879
    t.string "incoming_email_token"
1880
    t.string "organization"
1881 1882
    t.boolean "require_two_factor_authentication_from_group", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
1883
    t.boolean "ghost"
1884
    t.date "last_activity_on"
1885
    t.boolean "notified_of_own_activity"
1886
    t.string "preferred_language"
1887
    t.string "rss_token"
1888
    t.integer "theme_id", limit: 2
Andrew8xx8's avatar
Andrew8xx8 committed
1889 1890
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1891 1892
  add_index "users", ["admin"], name: "index_users_on_admin", using: :btree
  add_index "users", ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true, using: :btree
1893
  add_index "users", ["created_at"], name: "index_users_on_created_at", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1894
  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
1895
  add_index "users", ["email"], name: "index_users_on_email_trigram", using: :gin, opclasses: {"email"=>"gin_trgm_ops"}
1896
  add_index "users", ["ghost"], name: "index_users_on_ghost", using: :btree
1897
  add_index "users", ["incoming_email_token"], name: "index_users_on_incoming_email_token", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1898
  add_index "users", ["name"], name: "index_users_on_name", using: :btree
1899
  add_index "users", ["name"], name: "index_users_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1900
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
1901
  add_index "users", ["rss_token"], name: "index_users_on_rss_token", using: :btree
Stan Hu's avatar
Stan Hu committed
1902
  add_index "users", ["state"], name: "index_users_on_state", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1903
  add_index "users", ["username"], name: "index_users_on_username", using: :btree
1904
  add_index "users", ["username"], name: "index_users_on_username_trigram", using: :gin, opclasses: {"username"=>"gin_trgm_ops"}
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1905

Valery Sizov's avatar
Valery Sizov committed
1906
  create_table "users_star_projects", force: :cascade do |t|
1907 1908
    t.integer "project_id", null: false
    t.integer "user_id", null: false
Ciro Santilli's avatar
Ciro Santilli committed
1909 1910 1911 1912 1913 1914 1915
    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

1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931
  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
1932

Valery Sizov's avatar
Valery Sizov committed
1933
  create_table "web_hooks", force: :cascade do |t|
1934 1935
    t.string "url", limit: 2000
    t.integer "project_id"
1936 1937
    t.datetime "created_at"
    t.datetime "updated_at"
1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949
    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
1950
    t.boolean "repository_update_events", default: false, null: false
Luke "Jared" Bennett's avatar
Luke "Jared" Bennett committed
1951
    t.boolean "job_events", default: false, null: false
Andrew8xx8's avatar
Andrew8xx8 committed
1952 1953
  end

Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1954
  add_index "web_hooks", ["project_id"], name: "index_web_hooks_on_project_id", using: :btree
1955
  add_index "web_hooks", ["type"], name: "index_web_hooks_on_type", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
1956

1957
  add_foreign_key "boards", "projects", name: "fk_f15266b5f9", on_delete: :cascade
1958
  add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
1959 1960 1961 1962
  add_foreign_key "ci_build_trace_section_names", "projects", on_delete: :cascade
  add_foreign_key "ci_build_trace_sections", "ci_build_trace_section_names", column: "section_name_id", name: "fk_264e112c66", on_delete: :cascade
  add_foreign_key "ci_build_trace_sections", "ci_builds", column: "build_id", name: "fk_4ebe41f502", on_delete: :cascade
  add_foreign_key "ci_build_trace_sections", "projects", on_delete: :cascade
1963
  add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
1964
  add_foreign_key "ci_builds", "ci_stages", column: "stage_id", name: "fk_3a9eaa254d", on_delete: :cascade
1965
  add_foreign_key "ci_builds", "projects", name: "fk_befce0568a", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
1966
  add_foreign_key "ci_group_variables", "namespaces", column: "group_id", name: "fk_33ae4d58d8", on_delete: :cascade
1967
  add_foreign_key "ci_job_artifacts", "ci_builds", column: "job_id", on_delete: :cascade
1968
  add_foreign_key "ci_job_artifacts", "projects", on_delete: :cascade
Shinya Maeda's avatar
fix  
Shinya Maeda committed
1969
  add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade
1970
  add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade
1971
  add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify
Shinya Maeda's avatar
init  
Shinya Maeda committed
1972
  add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade
1973
  add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify
1974
  add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify
1975 1976
  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
1977
  add_foreign_key "ci_stages", "ci_pipelines", column: "pipeline_id", name: "fk_fb57e6cc56", on_delete: :cascade
1978
  add_foreign_key "ci_stages", "projects", name: "fk_2360681d1d", on_delete: :cascade
1979
  add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
1980
  add_foreign_key "ci_triggers", "projects", name: "fk_e3e63f966e", on_delete: :cascade
1981
  add_foreign_key "ci_triggers", "users", column: "owner_id", name: "fk_e8e10d1964", on_delete: :cascade
1982
  add_foreign_key "ci_variables", "projects", name: "fk_ada5eb64b3", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
1983 1984 1985 1986 1987
  add_foreign_key "cluster_platforms_kubernetes", "clusters", on_delete: :cascade
  add_foreign_key "cluster_projects", "clusters", on_delete: :cascade
  add_foreign_key "cluster_projects", "projects", on_delete: :cascade
  add_foreign_key "cluster_providers_gcp", "clusters", on_delete: :cascade
  add_foreign_key "clusters", "users", on_delete: :nullify
1988
  add_foreign_key "clusters_applications_helm", "clusters", on_delete: :cascade
1989
  add_foreign_key "container_repositories", "projects"
1990 1991 1992
  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
1993 1994
  add_foreign_key "events", "projects", on_delete: :cascade
  add_foreign_key "events", "users", column: "author_id", name: "fk_edfd187b6f", on_delete: :cascade
1995 1996 1997
  add_foreign_key "fork_network_members", "fork_networks", on_delete: :cascade
  add_foreign_key "fork_network_members", "projects", column: "forked_from_project_id", name: "fk_b01280dae4", on_delete: :nullify
  add_foreign_key "fork_network_members", "projects", on_delete: :cascade
1998
  add_foreign_key "fork_networks", "projects", column: "root_project_id", name: "fk_e7b436b2b5", on_delete: :nullify
1999
  add_foreign_key "forked_project_links", "projects", column: "forked_to_project_id", name: "fk_434510edb0", on_delete: :cascade
2000
  add_foreign_key "gcp_clusters", "projects", on_delete: :cascade
2001 2002
  add_foreign_key "gcp_clusters", "services", on_delete: :nullify
  add_foreign_key "gcp_clusters", "users", on_delete: :nullify
2003
  add_foreign_key "gpg_key_subkeys", "gpg_keys", on_delete: :cascade
2004
  add_foreign_key "gpg_keys", "users", on_delete: :cascade
2005
  add_foreign_key "gpg_signatures", "gpg_key_subkeys", on_delete: :nullify
2006 2007
  add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify
  add_foreign_key "gpg_signatures", "projects", on_delete: :cascade
2008
  add_foreign_key "group_custom_attributes", "namespaces", column: "group_id", on_delete: :cascade
2009 2010
  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
2011
  add_foreign_key "issue_metrics", "issues", on_delete: :cascade
2012 2013
  add_foreign_key "issues", "issues", column: "moved_to_id", name: "fk_a194299be1", on_delete: :nullify
  add_foreign_key "issues", "milestones", name: "fk_96b1dd429c", on_delete: :nullify
2014
  add_foreign_key "issues", "projects", name: "fk_899c8f3231", on_delete: :cascade
2015
  add_foreign_key "issues", "users", column: "author_id", name: "fk_05f1e72feb", on_delete: :nullify
2016
  add_foreign_key "issues", "users", column: "updated_by_id", name: "fk_ffed080f01", on_delete: :nullify
2017 2018
  add_foreign_key "label_priorities", "labels", on_delete: :cascade
  add_foreign_key "label_priorities", "projects", on_delete: :cascade
2019
  add_foreign_key "labels", "namespaces", column: "group_id", on_delete: :cascade
2020
  add_foreign_key "labels", "projects", name: "fk_7de4989a69", on_delete: :cascade
2021 2022
  add_foreign_key "lfs_file_locks", "projects", on_delete: :cascade
  add_foreign_key "lfs_file_locks", "users", on_delete: :cascade
2023 2024
  add_foreign_key "lists", "boards", name: "fk_0d3f677137", on_delete: :cascade
  add_foreign_key "lists", "labels", name: "fk_7a5553d60f", on_delete: :cascade
2025
  add_foreign_key "members", "users", name: "fk_2e88fb7ce9", on_delete: :cascade
2026
  add_foreign_key "merge_request_diff_commits", "merge_request_diffs", on_delete: :cascade
2027
  add_foreign_key "merge_request_diff_files", "merge_request_diffs", on_delete: :cascade
2028
  add_foreign_key "merge_request_diffs", "merge_requests", name: "fk_8483f3258f", on_delete: :cascade
2029
  add_foreign_key "merge_request_metrics", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
2030
  add_foreign_key "merge_request_metrics", "merge_requests", on_delete: :cascade
2031 2032
  add_foreign_key "merge_request_metrics", "users", column: "latest_closed_by_id", name: "fk_ae440388cc", on_delete: :nullify
  add_foreign_key "merge_request_metrics", "users", column: "merged_by_id", name: "fk_7f28d925f3", on_delete: :nullify
2033
  add_foreign_key "merge_requests", "ci_pipelines", column: "head_pipeline_id", name: "fk_fd82eae0b9", on_delete: :nullify
2034
  add_foreign_key "merge_requests", "merge_request_diffs", column: "latest_merge_request_diff_id", name: "fk_06067f5644", on_delete: :nullify
2035 2036
  add_foreign_key "merge_requests", "milestones", name: "fk_6a5165a692", on_delete: :nullify
  add_foreign_key "merge_requests", "projects", column: "source_project_id", name: "fk_3308fe130c", on_delete: :nullify
2037
  add_foreign_key "merge_requests", "projects", column: "target_project_id", name: "fk_a6963e8447", on_delete: :cascade
2038 2039 2040 2041
  add_foreign_key "merge_requests", "users", column: "assignee_id", name: "fk_6149611a04", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "author_id", name: "fk_e719a85f8a", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "merge_user_id", name: "fk_ad525e1f87", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "updated_by_id", name: "fk_641731faff", on_delete: :nullify
Timothy Andrew's avatar
Timothy Andrew committed
2042 2043
  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
2044
  add_foreign_key "milestones", "namespaces", column: "group_id", name: "fk_95650a40d4", on_delete: :cascade
2045 2046
  add_foreign_key "milestones", "projects", name: "fk_9bd0a0c791", on_delete: :cascade
  add_foreign_key "notes", "projects", name: "fk_99e097b079", on_delete: :cascade
2047
  add_foreign_key "oauth_openid_requests", "oauth_access_grants", column: "access_grant_id", name: "fk_oauth_openid_requests_oauth_access_grants_access_grant_id"
2048
  add_foreign_key "pages_domains", "projects", name: "fk_ea2f6dfc6f", on_delete: :cascade
2049
  add_foreign_key "personal_access_tokens", "users"
2050 2051
  add_foreign_key "project_authorizations", "projects", on_delete: :cascade
  add_foreign_key "project_authorizations", "users", on_delete: :cascade
2052
  add_foreign_key "project_auto_devops", "projects", on_delete: :cascade
2053
  add_foreign_key "project_custom_attributes", "projects", on_delete: :cascade
2054 2055 2056
  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
2057
  add_foreign_key "project_statistics", "projects", on_delete: :cascade
2058 2059 2060
  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
2061
  add_foreign_key "protected_tag_create_access_levels", "namespaces", column: "group_id"
2062
  add_foreign_key "protected_tag_create_access_levels", "protected_tags", name: "fk_f7dfda8c51", on_delete: :cascade
2063
  add_foreign_key "protected_tag_create_access_levels", "users"
2064
  add_foreign_key "protected_tags", "projects", name: "fk_8e4af87648", on_delete: :cascade
2065
  add_foreign_key "push_event_payloads", "events", name: "fk_36c74129da", on_delete: :cascade
2066 2067 2068
  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
2069
  add_foreign_key "subscriptions", "projects", on_delete: :cascade
2070
  add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade
2071 2072
  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
2073
  add_foreign_key "todos", "notes", name: "fk_91d1f47b13", on_delete: :cascade
2074
  add_foreign_key "todos", "projects", name: "fk_45054f9c45", on_delete: :cascade
2075 2076
  add_foreign_key "todos", "users", column: "author_id", name: "fk_ccf0373936", on_delete: :cascade
  add_foreign_key "todos", "users", name: "fk_d94154aa95", on_delete: :cascade
2077
  add_foreign_key "trending_projects", "projects", on_delete: :cascade
2078
  add_foreign_key "u2f_registrations", "users"
2079
  add_foreign_key "user_callouts", "users", on_delete: :cascade
2080
  add_foreign_key "user_custom_attributes", "users", on_delete: :cascade
2081
  add_foreign_key "user_synced_attributes_metadata", "users", on_delete: :cascade
2082
  add_foreign_key "users_star_projects", "projects", name: "fk_22cd27ddfc", on_delete: :cascade
2083
  add_foreign_key "web_hook_logs", "web_hooks", on_delete: :cascade
2084
  add_foreign_key "web_hooks", "projects", name: "fk_0c8ca6d9d1", on_delete: :cascade
2085
end