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

Felipe Artur's avatar
Felipe Artur committed
13
ActiveRecord::Schema.define(version: 20190131122559) do
Felipe Artur's avatar
Felipe Artur committed
14

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

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

Valery Sizov's avatar
Valery Sizov committed
29
  create_table "appearances", force: :cascade do |t|
30 31
    t.string "title", null: false
    t.text "description", null: false
32 33
    t.string "logo"
    t.integer "updated_by"
34
    t.string "header_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 43 44
    t.text "header_message"
    t.text "header_message_html"
    t.text "footer_message"
    t.text "footer_message_html"
45 46
    t.text "message_background_color"
    t.text "message_font_color"
47
    t.string "favicon"
Valery Sizov's avatar
Valery Sizov committed
48 49
  end

50 51 52 53 54 55
  create_table "application_setting_terms", force: :cascade do |t|
    t.integer "cached_markdown_version"
    t.text "terms", null: false
    t.text "terms_html"
  end

Valery Sizov's avatar
Valery Sizov committed
56
  create_table "application_settings", force: :cascade do |t|
57 58 59 60
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
61 62
    t.datetime "created_at"
    t.datetime "updated_at"
63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
    t.string "home_page_url"
    t.integer "default_branch_protection", default: 2
    t.text "help_text"
    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"
    t.integer "max_pages_size", default: 100, null: false
    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"
    t.boolean "user_default_external", default: false, null: false
    t.boolean "elasticsearch_indexing", default: false, null: false
    t.boolean "elasticsearch_search", default: false, null: false
111
    t.string "repository_storages", default: "default"
112 113 114 115 116 117 118 119
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
    t.boolean "usage_ping_enabled", default: true, null: false
    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"
120
    t.integer "rsa_key_restriction", default: 0, null: false
121
    t.integer "dsa_key_restriction", default: -1, null: false
122 123
    t.integer "ecdsa_key_restriction", default: 0, null: false
    t.integer "ed25519_key_restriction", default: 0, null: false
124 125 126 127 128
    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
129
    t.boolean "html_emails_enabled", default: true
130 131
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
132
    t.integer "shared_runners_minutes", default: 0, null: false
133
    t.bigint "repository_size_limit", default: 0
134
    t.integer "terminal_max_session_time", default: 0, null: false
135 136 137
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
138 139 140 141 142 143
    t.string "default_artifacts_expire_in", default: "0", null: false
    t.string "elasticsearch_url", default: "http://localhost:9200"
    t.boolean "elasticsearch_aws", default: false, null: false
    t.string "elasticsearch_aws_region", default: "us-east-1"
    t.string "elasticsearch_aws_access_key"
    t.string "elasticsearch_aws_secret_access_key"
144
    t.integer "geo_status_timeout", default: 10
145
    t.string "uuid"
146
    t.decimal "polling_interval_multiplier", default: "1.0", null: false
147
    t.boolean "elasticsearch_experimental_indexer"
148
    t.integer "cached_markdown_version"
149 150
    t.boolean "clientside_sentry_enabled", default: false, null: false
    t.string "clientside_sentry_dsn"
151
    t.boolean "check_namespace_plan", default: false, null: false
152
    t.integer "mirror_max_delay", default: 300, null: false
153 154
    t.integer "mirror_max_capacity", default: 100, null: false
    t.integer "mirror_capacity_threshold", default: 50, null: false
155
    t.boolean "prometheus_metrics_enabled", default: true, null: false
156
    t.boolean "authorized_keys_enabled", default: true, null: false
157 158
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
Valery Sizov's avatar
Valery Sizov committed
159 160 161 162
    t.boolean "slack_app_enabled", default: false
    t.string "slack_app_id"
    t.string "slack_app_secret"
    t.string "slack_app_verification_token"
163
    t.integer "performance_bar_allowed_group_id"
164
    t.boolean "allow_group_owners_to_manage_ldap", default: true, null: false
165
    t.boolean "hashed_storage_enabled", default: false, null: false
166
    t.boolean "project_export_enabled", default: true, null: false
167
    t.boolean "auto_devops_enabled", default: true, null: false
168 169 170 171 172 173 174 175 176
    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
177 178 179
    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
180
    t.boolean "mirror_available", default: true, null: false
181
    t.integer "default_project_creation", default: 2, null: false
182 183
    t.boolean "password_authentication_enabled_for_web"
    t.boolean "password_authentication_enabled_for_git", default: true, null: false
184
    t.string "auto_devops_domain"
185 186 187
    t.boolean "external_authorization_service_enabled", default: false, null: false
    t.string "external_authorization_service_url"
    t.string "external_authorization_service_default_label"
188
    t.boolean "pages_domain_verification_enabled", default: true, null: false
189
    t.string "user_default_internal_regex"
190
    t.boolean "allow_local_requests_from_hooks_and_services", default: false, null: false
191
    t.float "external_authorization_service_timeout", default: 0.5
192 193 194 195 196
    t.text "external_auth_client_cert"
    t.text "encrypted_external_auth_client_key"
    t.string "encrypted_external_auth_client_key_iv"
    t.string "encrypted_external_auth_client_key_pass"
    t.string "encrypted_external_auth_client_key_pass_iv"
197
    t.string "email_additional_text"
198
    t.boolean "enforce_terms", default: false
199
    t.integer "file_template_project_id"
200
    t.boolean "pseudonymizer_enabled", default: false, null: false
201
    t.boolean "hide_third_party_offers", default: false, null: false
Imre Farkas's avatar
Imre Farkas committed
202 203 204 205
    t.boolean "snowplow_enabled", default: false, null: false
    t.string "snowplow_collector_uri"
    t.string "snowplow_site_id"
    t.string "snowplow_cookie_domain"
Luke Bennett's avatar
Luke Bennett committed
206
    t.boolean "instance_statistics_visibility_private", default: false, null: false
207
    t.boolean "web_ide_clientside_preview_enabled", default: false, null: false
208
    t.boolean "user_show_add_ssh_key_message", default: true, null: false
Luke Bennett's avatar
Luke Bennett committed
209
    t.integer "custom_project_templates_group_id"
210
    t.integer "usage_stats_set_by_user_id"
211
    t.integer "receive_max_input_size"
212
    t.integer "diff_max_patch_bytes", default: 102400, null: false
213
    t.integer "archive_builds_in_seconds"
214
    t.string "commit_email_hostname"
215
    t.boolean "protected_ci_variables", default: false, null: false
216
    t.string "runners_registration_token_encrypted"
Kamil Trzciński's avatar
Kamil Trzciński committed
217 218 219
    t.index ["custom_project_templates_group_id"], name: "index_application_settings_on_custom_project_templates_group_id", using: :btree
    t.index ["file_template_project_id"], name: "index_application_settings_on_file_template_project_id", using: :btree
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
220 221
  end

222 223 224 225 226 227 228
  create_table "approval_merge_request_rule_sources", id: :bigserial, force: :cascade do |t|
    t.bigint "approval_merge_request_rule_id", null: false
    t.bigint "approval_project_rule_id", null: false
    t.index ["approval_merge_request_rule_id"], name: "index_approval_merge_request_rule_sources_1", unique: true, using: :btree
    t.index ["approval_project_rule_id"], name: "index_approval_merge_request_rule_sources_2", using: :btree
  end

229 230 231 232 233 234 235
  create_table "approval_merge_request_rules", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "merge_request_id", null: false
    t.integer "approvals_required", limit: 2, default: 0, null: false
    t.boolean "code_owner", default: false, null: false
    t.string "name", null: false
Mark Chao's avatar
Mark Chao committed
236
    t.index ["merge_request_id", "code_owner"], name: "index_approval_merge_request_rules_1", using: :btree
237 238
  end

239
  create_table "approval_merge_request_rules_approved_approvers", id: :bigserial, force: :cascade do |t|
240
    t.bigint "approval_merge_request_rule_id", null: false
241 242 243
    t.integer "user_id", null: false
    t.index ["approval_merge_request_rule_id", "user_id"], name: "index_approval_merge_request_rules_approved_approvers_1", unique: true, using: :btree
    t.index ["user_id"], name: "index_approval_merge_request_rules_approved_approvers_2", using: :btree
244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282
  end

  create_table "approval_merge_request_rules_groups", id: :bigserial, force: :cascade do |t|
    t.bigint "approval_merge_request_rule_id", null: false
    t.integer "group_id", null: false
    t.index ["approval_merge_request_rule_id", "group_id"], name: "index_approval_merge_request_rules_groups_1", unique: true, using: :btree
    t.index ["group_id"], name: "index_approval_merge_request_rules_groups_2", using: :btree
  end

  create_table "approval_merge_request_rules_users", id: :bigserial, force: :cascade do |t|
    t.bigint "approval_merge_request_rule_id", null: false
    t.integer "user_id", null: false
    t.index ["approval_merge_request_rule_id", "user_id"], name: "index_approval_merge_request_rules_users_1", unique: true, using: :btree
    t.index ["user_id"], name: "index_approval_merge_request_rules_users_2", using: :btree
  end

  create_table "approval_project_rules", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id", null: false
    t.integer "approvals_required", limit: 2, default: 0, null: false
    t.string "name", null: false
    t.index ["project_id"], name: "index_approval_project_rules_on_project_id", using: :btree
  end

  create_table "approval_project_rules_groups", id: :bigserial, force: :cascade do |t|
    t.bigint "approval_project_rule_id", null: false
    t.integer "group_id", null: false
    t.index ["approval_project_rule_id", "group_id"], name: "index_approval_project_rules_groups_1", unique: true, using: :btree
    t.index ["group_id"], name: "index_approval_project_rules_groups_2", using: :btree
  end

  create_table "approval_project_rules_users", id: :bigserial, force: :cascade do |t|
    t.bigint "approval_project_rule_id", null: false
    t.integer "user_id", null: false
    t.index ["approval_project_rule_id", "user_id"], name: "index_approval_project_rules_users_1", unique: true, using: :btree
    t.index ["user_id"], name: "index_approval_project_rules_users_2", using: :btree
  end

Valery Sizov's avatar
Valery Sizov committed
283
  create_table "approvals", force: :cascade do |t|
284 285
    t.integer "merge_request_id", null: false
    t.integer "user_id", null: false
Valery Sizov's avatar
Valery Sizov committed
286 287
    t.datetime "created_at"
    t.datetime "updated_at"
288
    t.index ["merge_request_id"], name: "index_approvals_on_merge_request_id", using: :btree
289 290
  end

Valery Sizov's avatar
Valery Sizov committed
291
  create_table "approver_groups", force: :cascade do |t|
292 293 294
    t.integer "target_id", null: false
    t.string "target_type", null: false
    t.integer "group_id", null: false
Valery Sizov's avatar
Valery Sizov committed
295 296
    t.datetime "created_at"
    t.datetime "updated_at"
297 298
    t.index ["group_id"], name: "index_approver_groups_on_group_id", using: :btree
    t.index ["target_id", "target_type"], name: "index_approver_groups_on_target_id_and_target_type", using: :btree
Valery Sizov's avatar
Valery Sizov committed
299 300
  end

Valery Sizov's avatar
Valery Sizov committed
301
  create_table "approvers", force: :cascade do |t|
302 303 304
    t.integer "target_id", null: false
    t.string "target_type"
    t.integer "user_id", null: false
Valery Sizov's avatar
Valery Sizov committed
305 306
    t.datetime "created_at"
    t.datetime "updated_at"
307 308
    t.index ["target_id", "target_type"], name: "index_approvers_on_target_id_and_target_type", using: :btree
    t.index ["user_id"], name: "index_approvers_on_user_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
309 310 311
  end

  create_table "audit_events", force: :cascade do |t|
312 313 314 315 316
    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"
Marin Jankovski's avatar
Marin Jankovski committed
317 318
    t.datetime "created_at"
    t.datetime "updated_at"
319
    t.index ["entity_id", "entity_type"], name: "index_audit_events_on_entity_id_and_entity_type", using: :btree
Marin Jankovski's avatar
Marin Jankovski committed
320 321
  end

322
  create_table "award_emoji", force: :cascade do |t|
323 324 325 326
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
327 328
    t.datetime "created_at"
    t.datetime "updated_at"
329 330
    t.index ["awardable_type", "awardable_id"], name: "index_award_emoji_on_awardable_type_and_awardable_id", using: :btree
    t.index ["user_id", "name"], name: "index_award_emoji_on_user_id_and_name", using: :btree
331 332
  end

333 334 335 336 337 338 339 340
  create_table "badges", force: :cascade do |t|
    t.string "link_url", null: false
    t.string "image_url", null: false
    t.integer "project_id"
    t.integer "group_id"
    t.string "type", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
341 342
    t.index ["group_id"], name: "index_badges_on_group_id", using: :btree
    t.index ["project_id"], name: "index_badges_on_project_id", using: :btree
343 344
  end

345 346 347
  create_table "board_assignees", force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
Kamil Trzciński's avatar
Kamil Trzciński committed
348
    t.index ["assignee_id"], name: "index_board_assignees_on_assignee_id", using: :btree
349
    t.index ["board_id", "assignee_id"], name: "index_board_assignees_on_board_id_and_assignee_id", unique: true, using: :btree
350 351
  end

352 353 354 355 356 357
  create_table "board_group_recent_visits", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "user_id"
    t.integer "board_id"
    t.integer "group_id"
358 359 360 361
    t.index ["board_id"], name: "index_board_group_recent_visits_on_board_id", using: :btree
    t.index ["group_id"], name: "index_board_group_recent_visits_on_group_id", using: :btree
    t.index ["user_id", "group_id", "board_id"], name: "index_board_group_recent_visits_on_user_group_and_board", unique: true, using: :btree
    t.index ["user_id"], name: "index_board_group_recent_visits_on_user_id", using: :btree
362 363
  end

364
  create_table "board_labels", force: :cascade do |t|
365
    t.integer "board_id", null: false
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
366
    t.integer "label_id", null: false
367
    t.index ["board_id", "label_id"], name: "index_board_labels_on_board_id_and_label_id", unique: true, using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
368
    t.index ["label_id"], name: "index_board_labels_on_label_id", using: :btree
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
369 370
  end

371 372 373 374 375 376
  create_table "board_project_recent_visits", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "user_id"
    t.integer "project_id"
    t.integer "board_id"
377 378 379 380
    t.index ["board_id"], name: "index_board_project_recent_visits_on_board_id", using: :btree
    t.index ["project_id"], name: "index_board_project_recent_visits_on_project_id", using: :btree
    t.index ["user_id", "project_id", "board_id"], name: "index_board_project_recent_visits_on_user_project_and_board", unique: true, using: :btree
    t.index ["user_id"], name: "index_board_project_recent_visits_on_user_id", using: :btree
381 382
  end

383
  create_table "boards", force: :cascade do |t|
384
    t.integer "project_id"
385 386
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
387
    t.string "name", default: "Development", null: false
388
    t.integer "milestone_id"
Felipe Artur's avatar
Felipe Artur committed
389
    t.integer "group_id"
390
    t.integer "weight"
391 392 393
    t.index ["group_id"], name: "index_boards_on_group_id", using: :btree
    t.index ["milestone_id"], name: "index_boards_on_milestone_id", using: :btree
    t.index ["project_id"], name: "index_boards_on_project_id", using: :btree
394 395
  end

Valery Sizov's avatar
Valery Sizov committed
396
  create_table "broadcast_messages", force: :cascade do |t|
397
    t.text "message", null: false
398 399 400 401
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
402 403
    t.string "color"
    t.string "font"
404
    t.text "message_html", null: false
405
    t.integer "cached_markdown_version"
406
    t.index ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id", using: :btree
407
  end
408

409 410 411
  create_table "chat_names", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "service_id", null: false
412
    t.string "team_id", null: false
413
    t.string "team_domain"
414
    t.string "chat_id", null: false
415
    t.string "chat_name"
416
    t.datetime "last_used_at"
417 418
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
419 420
    t.index ["service_id", "team_id", "chat_id"], name: "index_chat_names_on_service_id_and_team_id_and_chat_id", unique: true, using: :btree
    t.index ["user_id", "service_id"], name: "index_chat_names_on_user_id_and_service_id", unique: true, using: :btree
421 422
  end

423
  create_table "chat_teams", force: :cascade do |t|
424
    t.integer "namespace_id", null: false
425 426 427 428
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
429
    t.index ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true, using: :btree
430 431
  end

432 433 434 435 436
  create_table "ci_build_trace_chunks", id: :bigserial, force: :cascade do |t|
    t.integer "build_id", null: false
    t.integer "chunk_index", null: false
    t.integer "data_store", null: false
    t.binary "raw_data"
437
    t.index ["build_id", "chunk_index"], name: "index_ci_build_trace_chunks_on_build_id_and_chunk_index", unique: true, using: :btree
438 439
  end

440 441 442
  create_table "ci_build_trace_section_names", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
443
    t.index ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true, using: :btree
444 445 446
  end

  create_table "ci_build_trace_sections", force: :cascade do |t|
447
    t.integer "project_id", null: false
448 449
    t.datetime "date_start", null: false
    t.datetime "date_end", null: false
450 451
    t.bigint "byte_start", null: false
    t.bigint "byte_end", null: false
452 453
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
454 455 456
    t.index ["build_id", "section_name_id"], name: "index_ci_build_trace_sections_on_build_id_and_section_name_id", unique: true, using: :btree
    t.index ["project_id"], name: "index_ci_build_trace_sections_on_project_id", using: :btree
    t.index ["section_name_id"], name: "index_ci_build_trace_sections_on_section_name_id", using: :btree
457 458
  end

Valery Sizov's avatar
Valery Sizov committed
459
  create_table "ci_builds", force: :cascade do |t|
460
    t.string "status"
461
    t.datetime "finished_at"
462
    t.text "trace"
463 464 465
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482
    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"
483
    t.integer "project_id"
484 485
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
486
    t.datetime "erased_at"
487
    t.datetime "artifacts_expire_at"
488
    t.string "environment"
489
    t.bigint "artifacts_size"
490 491
    t.string "when"
    t.text "yaml_variables"
492
    t.datetime "queued_at"
493
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
494
    t.integer "lock_version"
495
    t.string "coverage_regex"
496
    t.integer "auto_canceled_by_id"
497
    t.boolean "retried"
498
    t.integer "stage_id"
Rémy Coutable's avatar
Rémy Coutable committed
499 500
    t.integer "artifacts_file_store"
    t.integer "artifacts_metadata_store"
501
    t.boolean "protected"
502
    t.integer "failure_reason"
Shinya Maeda's avatar
Shinya Maeda committed
503
    t.datetime_with_timezone "scheduled_at"
504
    t.string "token_encrypted"
505 506
    t.index ["artifacts_expire_at"], name: "index_ci_builds_on_artifacts_expire_at", where: "(artifacts_file <> ''::text)", using: :btree
    t.index ["auto_canceled_by_id"], name: "index_ci_builds_on_auto_canceled_by_id", using: :btree
Andreas Brandl's avatar
Andreas Brandl committed
507
    t.index ["commit_id", "artifacts_expire_at", "id"], name: "index_ci_builds_on_commit_id_and_artifacts_expireatandidpartial", where: "(((type)::text = 'Ci::Build'::text) AND ((retried = false) OR (retried IS NULL)) AND ((name)::text = ANY (ARRAY[('sast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('sast:container'::character varying)::text, ('container_scanning'::character varying)::text, ('dast'::character varying)::text])))", using: :btree
508 509 510 511 512 513
    t.index ["commit_id", "stage_idx", "created_at"], name: "index_ci_builds_on_commit_id_and_stage_idx_and_created_at", using: :btree
    t.index ["commit_id", "status", "type"], name: "index_ci_builds_on_commit_id_and_status_and_type", using: :btree
    t.index ["commit_id", "type", "name", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_name_and_ref", using: :btree
    t.index ["commit_id", "type", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_ref", using: :btree
    t.index ["name"], name: "index_ci_builds_on_name_for_security_products_values", where: "((name)::text = ANY (ARRAY[('container_scanning'::character varying)::text, ('dast'::character varying)::text, ('dependency_scanning'::character varying)::text, ('license_management'::character varying)::text, ('sast'::character varying)::text]))", using: :btree
    t.index ["project_id", "id"], name: "index_ci_builds_on_project_id_and_id", using: :btree
514
    t.index ["project_id", "status"], name: "index_ci_builds_project_id_and_status_for_live_jobs_partial2", where: "(((type)::text = 'Ci::Build'::text) AND ((status)::text = ANY (ARRAY[('running'::character varying)::text, ('pending'::character varying)::text, ('created'::character varying)::text])))", using: :btree
515 516 517 518 519 520 521
    t.index ["protected"], name: "index_ci_builds_on_protected", using: :btree
    t.index ["runner_id"], name: "index_ci_builds_on_runner_id", using: :btree
    t.index ["scheduled_at"], name: "partial_index_ci_builds_on_scheduled_at_with_scheduled_jobs", where: "((scheduled_at IS NOT NULL) AND ((type)::text = 'Ci::Build'::text) AND ((status)::text = 'scheduled'::text))", using: :btree
    t.index ["stage_id", "stage_idx"], name: "tmp_build_stage_position_index", where: "(stage_idx IS NOT NULL)", using: :btree
    t.index ["stage_id"], name: "index_ci_builds_on_stage_id", using: :btree
    t.index ["status", "type", "runner_id"], name: "index_ci_builds_on_status_and_type_and_runner_id", using: :btree
    t.index ["token"], name: "index_ci_builds_on_token", unique: true, using: :btree
522
    t.index ["token_encrypted"], name: "index_ci_builds_on_token_encrypted", unique: true, where: "(token_encrypted IS NOT NULL)", using: :btree
523 524
    t.index ["updated_at"], name: "index_ci_builds_on_updated_at", using: :btree
    t.index ["user_id"], name: "index_ci_builds_on_user_id", using: :btree
525 526
  end

527 528 529 530 531
  create_table "ci_builds_metadata", force: :cascade do |t|
    t.integer "build_id", null: false
    t.integer "project_id", null: false
    t.integer "timeout"
    t.integer "timeout_source", default: 1, null: false
532 533
    t.jsonb "config_options"
    t.jsonb "config_variables"
534 535
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id", unique: true, using: :btree
    t.index ["project_id"], name: "index_ci_builds_metadata_on_project_id", using: :btree
536 537
  end

538
  create_table "ci_builds_runner_session", id: :bigserial, force: :cascade do |t|
539 540 541 542
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
543
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true, using: :btree
544 545
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
546
  create_table "ci_group_variables", force: :cascade do |t|
547 548 549 550 551
    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
552 553
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
554 555
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
556
    t.index ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true, using: :btree
557 558
  end

559 560
  create_table "ci_job_artifacts", force: :cascade do |t|
    t.integer "project_id", null: false
561
    t.integer "job_id", null: false
562
    t.integer "file_type", null: false
563
    t.bigint "size"
564 565
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
566
    t.datetime_with_timezone "expire_at"
567
    t.string "file"
568
    t.integer "file_store"
569
    t.binary "file_sha256"
570
    t.integer "file_format", limit: 2
571
    t.integer "file_location", limit: 2
572 573 574 575
    t.index ["expire_at", "job_id"], name: "index_ci_job_artifacts_on_expire_at_and_job_id", using: :btree
    t.index ["file_store"], name: "index_ci_job_artifacts_on_file_store", using: :btree
    t.index ["job_id", "file_type"], name: "index_ci_job_artifacts_on_job_id_and_file_type", unique: true, using: :btree
    t.index ["project_id"], name: "index_ci_job_artifacts_on_project_id", using: :btree
576 577
  end

578 579 580 581
  create_table "ci_pipeline_chat_data", id: :bigserial, force: :cascade do |t|
    t.integer "pipeline_id", null: false
    t.integer "chat_name_id", null: false
    t.text "response_url", null: false
Kamil Trzciński's avatar
Kamil Trzciński committed
582
    t.index ["chat_name_id"], name: "index_ci_pipeline_chat_data_on_chat_name_id", using: :btree
583
    t.index ["pipeline_id"], name: "index_ci_pipeline_chat_data_on_pipeline_id", unique: true, using: :btree
584 585
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
586
  create_table "ci_pipeline_schedule_variables", force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
587 588 589 590 591
    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
592
    t.integer "pipeline_schedule_id", null: false
593 594
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
595
    t.index ["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
596 597
  end

598 599 600 601 602 603 604 605 606 607 608
  create_table "ci_pipeline_schedules", force: :cascade do |t|
    t.string "description"
    t.string "ref"
    t.string "cron"
    t.string "cron_timezone"
    t.datetime "next_run_at"
    t.integer "project_id"
    t.integer "owner_id"
    t.boolean "active", default: true
    t.datetime "created_at"
    t.datetime "updated_at"
609
    t.index ["next_run_at", "active"], name: "index_ci_pipeline_schedules_on_next_run_at_and_active", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
610
    t.index ["owner_id"], name: "index_ci_pipeline_schedules_on_owner_id", using: :btree
611
    t.index ["project_id"], name: "index_ci_pipeline_schedules_on_project_id", using: :btree
612 613
  end

614 615 616 617 618 619 620
  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
621
    t.index ["pipeline_id", "key"], name: "index_ci_pipeline_variables_on_pipeline_id_and_key", unique: true, using: :btree
622 623
  end

624
  create_table "ci_pipelines", force: :cascade do |t|
625 626 627
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
628 629
    t.datetime "created_at"
    t.datetime "updated_at"
630 631
    t.boolean "tag", default: false
    t.text "yaml_errors"
632
    t.datetime "committed_at"
633
    t.integer "project_id"
634
    t.string "status"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
635 636
    t.datetime "started_at"
    t.datetime "finished_at"
637 638
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
639
    t.integer "lock_version"
640
    t.integer "auto_canceled_by_id"
641
    t.integer "pipeline_schedule_id"
642
    t.integer "source"
643
    t.integer "config_source"
644
    t.boolean "protected"
645
    t.integer "failure_reason"
Micaël Bergeron's avatar
Micaël Bergeron committed
646
    t.integer "iid"
Shinya Maeda's avatar
Shinya Maeda committed
647
    t.integer "merge_request_id"
648
    t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id", using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
649
    t.index ["merge_request_id"], name: "index_ci_pipelines_on_merge_request_id", where: "(merge_request_id IS NOT NULL)", using: :btree
650 651
    t.index ["pipeline_schedule_id"], name: "index_ci_pipelines_on_pipeline_schedule_id", using: :btree
    t.index ["project_id", "iid"], name: "index_ci_pipelines_on_project_id_and_iid", unique: true, where: "(iid IS NOT NULL)", using: :btree
Andreas Brandl's avatar
Andreas Brandl committed
652
    t.index ["project_id", "ref", "id"], name: "index_ci_pipelines_on_project_idandrefandiddesc", order: { id: :desc }, using: :btree
653 654 655 656 657 658 659
    t.index ["project_id", "ref", "status", "id"], name: "index_ci_pipelines_on_project_id_and_ref_and_status_and_id", using: :btree
    t.index ["project_id", "sha"], name: "index_ci_pipelines_on_project_id_and_sha", using: :btree
    t.index ["project_id", "source"], name: "index_ci_pipelines_on_project_id_and_source", using: :btree
    t.index ["project_id", "status", "config_source"], name: "index_ci_pipelines_on_project_id_and_status_and_config_source", using: :btree
    t.index ["project_id"], name: "index_ci_pipelines_on_project_id", using: :btree
    t.index ["status"], name: "index_ci_pipelines_on_status", using: :btree
    t.index ["user_id"], name: "index_ci_pipelines_on_user_id", using: :btree
660 661
  end

662
  create_table "ci_runner_namespaces", force: :cascade do |t|
663
    t.integer "runner_id"
664
    t.integer "namespace_id"
665 666
    t.index ["namespace_id"], name: "index_ci_runner_namespaces_on_namespace_id", using: :btree
    t.index ["runner_id", "namespace_id"], name: "index_ci_runner_namespaces_on_runner_id_and_namespace_id", unique: true, using: :btree
667 668
  end

Valery Sizov's avatar
Valery Sizov committed
669
  create_table "ci_runner_projects", force: :cascade do |t|
670
    t.integer "runner_id", null: false
671 672
    t.datetime "created_at"
    t.datetime "updated_at"
673
    t.integer "project_id"
674 675
    t.index ["project_id"], name: "index_ci_runner_projects_on_project_id", using: :btree
    t.index ["runner_id"], name: "index_ci_runner_projects_on_runner_id", using: :btree
676 677
  end

Valery Sizov's avatar
Valery Sizov committed
678
  create_table "ci_runners", force: :cascade do |t|
679
    t.string "token"
680 681
    t.datetime "created_at"
    t.datetime "updated_at"
682
    t.string "description"
683
    t.datetime "contacted_at"
684 685 686 687 688 689 690 691 692
    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
693
    t.integer "access_level", default: 0, null: false
694
    t.string "ip_address"
695
    t.integer "maximum_timeout"
696
    t.integer "runner_type", limit: 2, null: false
697
    t.string "token_encrypted"
698 699 700 701 702
    t.index ["contacted_at"], name: "index_ci_runners_on_contacted_at", using: :btree
    t.index ["is_shared"], name: "index_ci_runners_on_is_shared", using: :btree
    t.index ["locked"], name: "index_ci_runners_on_locked", using: :btree
    t.index ["runner_type"], name: "index_ci_runners_on_runner_type", using: :btree
    t.index ["token"], name: "index_ci_runners_on_token", using: :btree
703 704
  end

Kamil Trzcinski's avatar
Kamil Trzcinski committed
705 706 707 708 709 710
  create_table "ci_sources_pipelines", force: :cascade do |t|
    t.integer "project_id"
    t.integer "pipeline_id"
    t.integer "source_project_id"
    t.integer "source_job_id"
    t.integer "source_pipeline_id"
711 712 713 714 715
    t.index ["pipeline_id"], name: "index_ci_sources_pipelines_on_pipeline_id", using: :btree
    t.index ["project_id"], name: "index_ci_sources_pipelines_on_project_id", using: :btree
    t.index ["source_job_id"], name: "index_ci_sources_pipelines_on_source_job_id", using: :btree
    t.index ["source_pipeline_id"], name: "index_ci_sources_pipelines_on_source_pipeline_id", using: :btree
    t.index ["source_project_id"], name: "index_ci_sources_pipelines_on_source_project_id", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
716 717
  end

718 719 720 721 722
  create_table "ci_stages", force: :cascade do |t|
    t.integer "project_id"
    t.integer "pipeline_id"
    t.datetime "created_at"
    t.datetime "updated_at"
723
    t.string "name"
724
    t.integer "status"
725
    t.integer "lock_version"
726
    t.integer "position"
727 728 729 730
    t.index ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", unique: true, using: :btree
    t.index ["pipeline_id", "position"], name: "index_ci_stages_on_pipeline_id_and_position", using: :btree
    t.index ["pipeline_id"], name: "index_ci_stages_on_pipeline_id", using: :btree
    t.index ["project_id"], name: "index_ci_stages_on_project_id", using: :btree
731 732
  end

Valery Sizov's avatar
Valery Sizov committed
733
  create_table "ci_trigger_requests", force: :cascade do |t|
734 735
    t.integer "trigger_id", null: false
    t.text "variables"
736 737
    t.datetime "created_at"
    t.datetime "updated_at"
738
    t.integer "commit_id"
739
    t.index ["commit_id"], name: "index_ci_trigger_requests_on_commit_id", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
740
    t.index ["trigger_id"], name: "index_ci_trigger_requests_on_trigger_id", using: :btree
741 742
  end

Valery Sizov's avatar
Valery Sizov committed
743
  create_table "ci_triggers", force: :cascade do |t|
744
    t.string "token"
745 746
    t.datetime "created_at"
    t.datetime "updated_at"
747
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
748 749
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
750
    t.string "ref"
Kamil Trzciński's avatar
Kamil Trzciński committed
751
    t.index ["owner_id"], name: "index_ci_triggers_on_owner_id", using: :btree
752
    t.index ["project_id"], name: "index_ci_triggers_on_project_id", using: :btree
753 754
  end

Valery Sizov's avatar
Valery Sizov committed
755
  create_table "ci_variables", force: :cascade do |t|
756
    t.string "key", null: false
757 758 759 760
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
761
    t.integer "project_id", null: false
762
    t.boolean "protected", default: false, null: false
763
    t.string "environment_scope", default: "*", null: false
764
    t.index ["project_id", "key", "environment_scope"], name: "index_ci_variables_on_project_id_and_key_and_environment_scope", unique: true, using: :btree
765 766
  end

767 768 769
  create_table "cluster_groups", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "group_id", null: false
770 771
    t.index ["cluster_id", "group_id"], name: "index_cluster_groups_on_cluster_id_and_group_id", unique: true, using: :btree
    t.index ["group_id"], name: "index_cluster_groups_on_group_id", using: :btree
772 773
  end

Shinya Maeda's avatar
Shinya Maeda committed
774 775
  create_table "cluster_platforms_kubernetes", force: :cascade do |t|
    t.integer "cluster_id", null: false
776 777
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
778
    t.text "api_url"
Shinya Maeda's avatar
Shinya Maeda committed
779 780 781 782 783 784 785
    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"
786
    t.integer "authorization_type", limit: 2
787
    t.index ["cluster_id"], name: "index_cluster_platforms_kubernetes_on_cluster_id", unique: true, using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
788 789 790 791 792
  end

  create_table "cluster_projects", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
793 794
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
795 796
    t.index ["cluster_id"], name: "index_cluster_projects_on_cluster_id", using: :btree
    t.index ["project_id"], name: "index_cluster_projects_on_project_id", using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
797 798 799 800 801
  end

  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
802
    t.integer "num_nodes", null: false
803 804
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
805 806 807 808 809 810 811 812
    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"
813
    t.boolean "legacy_abac", default: false, null: false
814
    t.index ["cluster_id"], name: "index_cluster_providers_gcp_on_cluster_id", unique: true, using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
815 816 817
  end

  create_table "clusters", force: :cascade do |t|
818
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
819 820
    t.integer "provider_type"
    t.integer "platform_type"
821 822
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
823 824
    t.boolean "enabled", default: true
    t.string "name", null: false
825
    t.string "environment_scope", default: "*", null: false
826
    t.integer "cluster_type", limit: 2, default: 3, null: false
827
    t.string "domain"
828 829
    t.index ["enabled"], name: "index_clusters_on_enabled", using: :btree
    t.index ["user_id"], name: "index_clusters_on_user_id", using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
830 831
  end

832 833 834 835 836 837 838 839
  create_table "clusters_applications_cert_managers", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "status", null: false
    t.string "version", null: false
    t.string "email", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.text "status_reason"
840
    t.index ["cluster_id"], name: "index_clusters_applications_cert_managers_on_cluster_id", unique: true, using: :btree
841 842
  end

843 844
  create_table "clusters_applications_helm", force: :cascade do |t|
    t.integer "cluster_id", null: false
845 846
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
847 848 849
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
850 851 852
    t.text "encrypted_ca_key"
    t.text "encrypted_ca_key_iv"
    t.text "ca_cert"
Kamil Trzciński's avatar
Kamil Trzciński committed
853
    t.index ["cluster_id"], name: "index_clusters_applications_helm_on_cluster_id", unique: true, using: :btree
854
  end
855

Kamil Trzcinski's avatar
Kamil Trzcinski committed
856 857
  create_table "clusters_applications_ingress", force: :cascade do |t|
    t.integer "cluster_id", null: false
858 859
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
860 861 862 863 864
    t.integer "status", null: false
    t.integer "ingress_type", null: false
    t.string "version", null: false
    t.string "cluster_ip"
    t.text "status_reason"
865
    t.string "external_ip"
Kamil Trzciński's avatar
Kamil Trzciński committed
866
    t.index ["cluster_id"], name: "index_clusters_applications_ingress_on_cluster_id", unique: true, using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
867 868
  end

869
  create_table "clusters_applications_jupyter", force: :cascade do |t|
870
    t.integer "cluster_id", null: false
871
    t.integer "oauth_application_id"
872 873 874 875 876
    t.integer "status", null: false
    t.string "version", null: false
    t.string "hostname"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
877
    t.text "status_reason"
Kamil Trzciński's avatar
Kamil Trzciński committed
878 879
    t.index ["cluster_id"], name: "index_clusters_applications_jupyter_on_cluster_id", unique: true, using: :btree
    t.index ["oauth_application_id"], name: "index_clusters_applications_jupyter_on_oauth_application_id", using: :btree
880 881
  end

Chris Baumbauer's avatar
Chris Baumbauer committed
882 883 884 885 886 887
  create_table "clusters_applications_knative", 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
888
    t.string "hostname"
Chris Baumbauer's avatar
Chris Baumbauer committed
889
    t.text "status_reason"
890
    t.string "external_ip"
891
    t.index ["cluster_id"], name: "index_clusters_applications_knative_on_cluster_id", unique: true, using: :btree
Chris Baumbauer's avatar
Chris Baumbauer committed
892 893
  end

894 895 896 897 898 899 900
  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
901
    t.datetime_with_timezone "last_update_started_at"
902 903
    t.string "encrypted_alert_manager_token"
    t.string "encrypted_alert_manager_token_iv"
Kamil Trzciński's avatar
Kamil Trzciński committed
904
    t.index ["cluster_id"], name: "index_clusters_applications_prometheus_on_cluster_id", unique: true, using: :btree
905 906
  end

907 908 909 910 911 912 913 914
  create_table "clusters_applications_runners", force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "runner_id"
    t.integer "status", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "version", null: false
    t.text "status_reason"
915
    t.boolean "privileged", default: true, null: false
916 917
    t.index ["cluster_id"], name: "index_clusters_applications_runners_on_cluster_id", unique: true, using: :btree
    t.index ["runner_id"], name: "index_clusters_applications_runners_on_runner_id", using: :btree
918 919
  end

920 921 922 923 924 925 926 927 928 929
  create_table "clusters_kubernetes_namespaces", id: :bigserial, force: :cascade do |t|
    t.integer "cluster_id", null: false
    t.integer "project_id"
    t.integer "cluster_project_id"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.text "encrypted_service_account_token"
    t.string "encrypted_service_account_token_iv"
    t.string "namespace", null: false
    t.string "service_account_name"
930 931 932 933
    t.index ["cluster_id", "namespace"], name: "kubernetes_namespaces_cluster_and_namespace", unique: true, using: :btree
    t.index ["cluster_id"], name: "index_clusters_kubernetes_namespaces_on_cluster_id", using: :btree
    t.index ["cluster_project_id"], name: "index_clusters_kubernetes_namespaces_on_cluster_project_id", using: :btree
    t.index ["project_id"], name: "index_clusters_kubernetes_namespaces_on_project_id", using: :btree
934 935
  end

936 937 938 939 940
  create_table "container_repositories", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
941 942
    t.index ["project_id", "name"], name: "index_container_repositories_on_project_id_and_name", unique: true, using: :btree
    t.index ["project_id"], name: "index_container_repositories_on_project_id", using: :btree
943 944
  end

945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967
  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
968 969 970 971 972 973 974 975 976 977
    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
978 979
  end

Valery Sizov's avatar
Valery Sizov committed
980
  create_table "deploy_keys_projects", force: :cascade do |t|
981 982
    t.integer "deploy_key_id", null: false
    t.integer "project_id", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
983 984
    t.datetime "created_at"
    t.datetime "updated_at"
985
    t.boolean "can_push", default: false, null: false
986
    t.index ["project_id"], name: "index_deploy_keys_projects_on_project_id", using: :btree
987
  end
988

989 990
  create_table "deploy_tokens", force: :cascade do |t|
    t.boolean "revoked", default: false
991 992
    t.boolean "read_repository", default: false, null: false
    t.boolean "read_registry", default: false, null: false
993
    t.datetime_with_timezone "expires_at", null: false
994
    t.datetime_with_timezone "created_at", null: false
995 996
    t.string "name", null: false
    t.string "token", null: false
997 998
    t.index ["token", "expires_at", "id"], name: "index_deploy_tokens_on_token_and_expires_at_and_id", where: "(revoked IS FALSE)", using: :btree
    t.index ["token"], name: "index_deploy_tokens_on_token", unique: true, using: :btree
999 1000
  end

1001
  create_table "deployments", force: :cascade do |t|
1002 1003 1004 1005 1006 1007 1008 1009 1010
    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
    t.integer "user_id"
    t.integer "deployable_id"
    t.string "deployable_type"
1011 1012
    t.datetime "created_at"
    t.datetime "updated_at"
1013
    t.string "on_stop"
1014
    t.integer "status", limit: 2, null: false
1015
    t.datetime_with_timezone "finished_at"
1016 1017 1018 1019 1020 1021 1022 1023 1024
    t.index ["created_at"], name: "index_deployments_on_created_at", using: :btree
    t.index ["deployable_type", "deployable_id"], name: "index_deployments_on_deployable_type_and_deployable_id", using: :btree
    t.index ["environment_id", "id"], name: "index_deployments_on_environment_id_and_id", using: :btree
    t.index ["environment_id", "iid", "project_id"], name: "index_deployments_on_environment_id_and_iid_and_project_id", using: :btree
    t.index ["environment_id", "status"], name: "index_deployments_on_environment_id_and_status", using: :btree
    t.index ["id"], name: "partial_index_deployments_for_legacy_successful_deployments", where: "((finished_at IS NULL) AND (status = 2))", using: :btree
    t.index ["project_id", "iid"], name: "index_deployments_on_project_id_and_iid", unique: true, using: :btree
    t.index ["project_id", "status", "created_at"], name: "index_deployments_on_project_id_and_status_and_created_at", using: :btree
    t.index ["project_id", "status"], name: "index_deployments_on_project_id_and_status", using: :btree
1025 1026
  end

1027 1028 1029 1030 1031 1032 1033 1034 1035
  create_table "draft_notes", id: :bigserial, force: :cascade do |t|
    t.integer "merge_request_id", null: false
    t.integer "author_id", null: false
    t.boolean "resolve_discussion", default: false, null: false
    t.string "discussion_id"
    t.text "note", null: false
    t.text "position"
    t.text "original_position"
    t.text "change_position"
1036 1037 1038
    t.index ["author_id"], name: "index_draft_notes_on_author_id", using: :btree
    t.index ["discussion_id"], name: "index_draft_notes_on_discussion_id", using: :btree
    t.index ["merge_request_id"], name: "index_draft_notes_on_merge_request_id", using: :btree
1039 1040
  end

Valery Sizov's avatar
Valery Sizov committed
1041
  create_table "emails", force: :cascade do |t|
1042 1043
    t.integer "user_id", null: false
    t.string "email", null: false
1044 1045
    t.datetime "created_at"
    t.datetime "updated_at"
1046
    t.string "confirmation_token"
1047 1048
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
1049 1050 1051
    t.index ["confirmation_token"], name: "index_emails_on_confirmation_token", unique: true, using: :btree
    t.index ["email"], name: "index_emails_on_email", unique: true, using: :btree
    t.index ["user_id"], name: "index_emails_on_user_id", using: :btree
1052 1053
  end

1054
  create_table "environments", force: :cascade do |t|
1055
    t.integer "project_id", null: false
1056
    t.string "name", null: false
1057 1058
    t.datetime "created_at"
    t.datetime "updated_at"
1059 1060
    t.string "external_url"
    t.string "environment_type"
1061
    t.string "state", default: "available", null: false
Nick Thomas's avatar
Nick Thomas committed
1062
    t.string "slug", null: false
1063 1064 1065
    t.index ["name"], name: "index_environments_on_name_varchar_pattern_ops", using: :btree, opclasses: {"name"=>"varchar_pattern_ops"}
    t.index ["project_id", "name"], name: "index_environments_on_project_id_and_name", unique: true, using: :btree
    t.index ["project_id", "slug"], name: "index_environments_on_project_id_and_slug", unique: true, using: :btree
1066 1067
  end

1068 1069 1070
  create_table "epic_issues", force: :cascade do |t|
    t.integer "epic_id", null: false
    t.integer "issue_id", null: false
1071
    t.integer "relative_position", default: 1073741823, null: false
1072 1073
    t.index ["epic_id"], name: "index_epic_issues_on_epic_id", using: :btree
    t.index ["issue_id"], name: "index_epic_issues_on_issue_id", unique: true, using: :btree
1074 1075
  end

Clement Ho's avatar
Clement Ho committed
1076 1077
  create_table "epic_metrics", force: :cascade do |t|
    t.integer "epic_id", null: false
1078 1079
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1080
    t.index ["epic_id"], name: "index_epic_metrics", using: :btree
Clement Ho's avatar
Clement Ho committed
1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094
  end

  create_table "epics", force: :cascade do |t|
    t.integer "milestone_id"
    t.integer "group_id", null: false
    t.integer "author_id", null: false
    t.integer "assignee_id"
    t.integer "iid", null: false
    t.integer "cached_markdown_version"
    t.integer "updated_by_id"
    t.integer "last_edited_by_id"
    t.integer "lock_version"
    t.date "start_date"
    t.date "end_date"
1095 1096 1097
    t.datetime "last_edited_at"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Clement Ho's avatar
Clement Ho committed
1098 1099 1100 1101
    t.string "title", null: false
    t.string "title_html", null: false
    t.text "description"
    t.text "description_html"
1102 1103
    t.integer "start_date_sourcing_milestone_id"
    t.integer "due_date_sourcing_milestone_id"
Mark Chao's avatar
Mark Chao committed
1104 1105 1106 1107
    t.date "start_date_fixed"
    t.date "due_date_fixed"
    t.boolean "start_date_is_fixed"
    t.boolean "due_date_is_fixed"
1108 1109 1110
    t.integer "state", limit: 2, default: 1, null: false
    t.integer "closed_by_id"
    t.datetime "closed_at"
Jarka Košanová's avatar
Jarka Košanová committed
1111
    t.integer "parent_id"
1112 1113 1114 1115 1116 1117 1118
    t.index ["assignee_id"], name: "index_epics_on_assignee_id", using: :btree
    t.index ["author_id"], name: "index_epics_on_author_id", using: :btree
    t.index ["closed_by_id"], name: "index_epics_on_closed_by_id", using: :btree
    t.index ["end_date"], name: "index_epics_on_end_date", using: :btree
    t.index ["group_id"], name: "index_epics_on_group_id", using: :btree
    t.index ["iid"], name: "index_epics_on_iid", using: :btree
    t.index ["milestone_id"], name: "index_milestone", using: :btree
Jarka Košanová's avatar
Jarka Košanová committed
1119
    t.index ["parent_id"], name: "index_epics_on_parent_id", using: :btree
1120
    t.index ["start_date"], name: "index_epics_on_start_date", using: :btree
Clement Ho's avatar
Clement Ho committed
1121 1122
  end

Valery Sizov's avatar
Valery Sizov committed
1123
  create_table "events", force: :cascade do |t|
1124 1125 1126
    t.integer "project_id"
    t.integer "author_id", null: false
    t.integer "target_id"
1127 1128
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1129 1130
    t.integer "action", limit: 2, null: false
    t.string "target_type"
1131 1132
    t.index ["action"], name: "index_events_on_action", using: :btree
    t.index ["author_id", "project_id"], name: "index_events_on_author_id_and_project_id", using: :btree
1133
    t.index ["project_id", "created_at"], name: "index_events_on_project_id_and_created_at", using: :btree
1134 1135
    t.index ["project_id", "id"], name: "index_events_on_project_id_and_id", using: :btree
    t.index ["target_type", "target_id"], name: "index_events_on_target_type_and_target_id", using: :btree
1136 1137
  end

1138 1139 1140 1141 1142 1143
  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
1144
    t.index ["feature_key", "key", "value"], name: "index_feature_gates_on_feature_key_and_key_and_value", unique: true, using: :btree
1145 1146 1147 1148 1149 1150
  end

  create_table "features", force: :cascade do |t|
    t.string "key", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1151
    t.index ["key"], name: "index_features_on_key", unique: true, using: :btree
1152 1153
  end

1154 1155 1156 1157
  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"
1158
    t.index ["fork_network_id"], name: "index_fork_network_members_on_fork_network_id", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1159
    t.index ["forked_from_project_id"], name: "index_fork_network_members_on_forked_from_project_id", using: :btree
1160
    t.index ["project_id"], name: "index_fork_network_members_on_project_id", unique: true, using: :btree
1161 1162
  end

1163 1164 1165
  create_table "fork_networks", force: :cascade do |t|
    t.integer "root_project_id"
    t.string "deleted_root_project_name"
1166
    t.index ["root_project_id"], name: "index_fork_networks_on_root_project_id", unique: true, using: :btree
1167 1168
  end

Valery Sizov's avatar
Valery Sizov committed
1169
  create_table "forked_project_links", force: :cascade do |t|
1170 1171
    t.integer "forked_to_project_id", null: false
    t.integer "forked_from_project_id", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1172 1173
    t.datetime "created_at"
    t.datetime "updated_at"
1174
    t.index ["forked_to_project_id"], name: "index_forked_project_links_on_forked_to_project_id", unique: true, using: :btree
1175 1176
  end

1177 1178 1179 1180
  create_table "geo_cache_invalidation_events", id: :bigserial, force: :cascade do |t|
    t.string "key", null: false
  end

1181
  create_table "geo_event_log", id: :bigserial, force: :cascade do |t|
1182
    t.datetime "created_at", null: false
1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207
    t.bigint "repository_updated_event_id"
    t.bigint "repository_deleted_event_id"
    t.bigint "repository_renamed_event_id"
    t.bigint "repositories_changed_event_id"
    t.bigint "repository_created_event_id"
    t.bigint "hashed_storage_migrated_event_id"
    t.bigint "lfs_object_deleted_event_id"
    t.bigint "hashed_storage_attachments_event_id"
    t.bigint "upload_deleted_event_id"
    t.bigint "job_artifact_deleted_event_id"
    t.bigint "reset_checksum_event_id"
    t.bigint "cache_invalidation_event_id"
    t.index ["cache_invalidation_event_id"], name: "index_geo_event_log_on_cache_invalidation_event_id", where: "(cache_invalidation_event_id IS NOT NULL)", using: :btree
    t.index ["hashed_storage_attachments_event_id"], name: "index_geo_event_log_on_hashed_storage_attachments_event_id", where: "(hashed_storage_attachments_event_id IS NOT NULL)", using: :btree
    t.index ["hashed_storage_migrated_event_id"], name: "index_geo_event_log_on_hashed_storage_migrated_event_id", where: "(hashed_storage_migrated_event_id IS NOT NULL)", using: :btree
    t.index ["job_artifact_deleted_event_id"], name: "index_geo_event_log_on_job_artifact_deleted_event_id", where: "(job_artifact_deleted_event_id IS NOT NULL)", using: :btree
    t.index ["lfs_object_deleted_event_id"], name: "index_geo_event_log_on_lfs_object_deleted_event_id", where: "(lfs_object_deleted_event_id IS NOT NULL)", using: :btree
    t.index ["repositories_changed_event_id"], name: "index_geo_event_log_on_repositories_changed_event_id", where: "(repositories_changed_event_id IS NOT NULL)", using: :btree
    t.index ["repository_created_event_id"], name: "index_geo_event_log_on_repository_created_event_id", where: "(repository_created_event_id IS NOT NULL)", using: :btree
    t.index ["repository_deleted_event_id"], name: "index_geo_event_log_on_repository_deleted_event_id", where: "(repository_deleted_event_id IS NOT NULL)", using: :btree
    t.index ["repository_renamed_event_id"], name: "index_geo_event_log_on_repository_renamed_event_id", where: "(repository_renamed_event_id IS NOT NULL)", using: :btree
    t.index ["repository_updated_event_id"], name: "index_geo_event_log_on_repository_updated_event_id", where: "(repository_updated_event_id IS NOT NULL)", using: :btree
    t.index ["reset_checksum_event_id"], name: "index_geo_event_log_on_reset_checksum_event_id", where: "(reset_checksum_event_id IS NOT NULL)", using: :btree
    t.index ["upload_deleted_event_id"], name: "index_geo_event_log_on_upload_deleted_event_id", where: "(upload_deleted_event_id IS NOT NULL)", using: :btree
  end
1208

1209 1210 1211 1212
  create_table "geo_hashed_storage_attachments_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "old_attachments_path", null: false
    t.text "new_attachments_path", null: false
1213
    t.index ["project_id"], name: "index_geo_hashed_storage_attachments_events_on_project_id", using: :btree
1214 1215
  end

1216 1217 1218 1219 1220 1221 1222 1223 1224
  create_table "geo_hashed_storage_migrated_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "repository_storage_name", null: false
    t.text "old_disk_path", null: false
    t.text "new_disk_path", null: false
    t.text "old_wiki_disk_path", null: false
    t.text "new_wiki_disk_path", null: false
    t.integer "old_storage_version", limit: 2
    t.integer "new_storage_version", limit: 2, null: false
1225
    t.index ["project_id"], name: "index_geo_hashed_storage_migrated_events_on_project_id", using: :btree
1226 1227
  end

1228 1229 1230
  create_table "geo_job_artifact_deleted_events", id: :bigserial, force: :cascade do |t|
    t.integer "job_artifact_id", null: false
    t.string "file_path", null: false
1231
    t.index ["job_artifact_id"], name: "index_geo_job_artifact_deleted_events_on_job_artifact_id", using: :btree
1232 1233
  end

1234 1235 1236 1237
  create_table "geo_lfs_object_deleted_events", id: :bigserial, force: :cascade do |t|
    t.integer "lfs_object_id", null: false
    t.string "oid", null: false
    t.string "file_path", null: false
1238
    t.index ["lfs_object_id"], name: "index_geo_lfs_object_deleted_events_on_lfs_object_id", using: :btree
1239 1240
  end

1241
  create_table "geo_node_namespace_links", force: :cascade do |t|
1242
    t.integer "geo_node_id", null: false
1243
    t.integer "namespace_id", null: false
1244 1245
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1246 1247
    t.index ["geo_node_id", "namespace_id"], name: "index_geo_node_namespace_links_on_geo_node_id_and_namespace_id", unique: true, using: :btree
    t.index ["geo_node_id"], name: "index_geo_node_namespace_links_on_geo_node_id", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1248
    t.index ["namespace_id"], name: "index_geo_node_namespace_links_on_namespace_id", using: :btree
1249 1250
  end

1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262
  create_table "geo_node_statuses", force: :cascade do |t|
    t.integer "geo_node_id", null: false
    t.integer "db_replication_lag_seconds"
    t.integer "repositories_synced_count"
    t.integer "repositories_failed_count"
    t.integer "lfs_objects_count"
    t.integer "lfs_objects_synced_count"
    t.integer "lfs_objects_failed_count"
    t.integer "attachments_count"
    t.integer "attachments_synced_count"
    t.integer "attachments_failed_count"
    t.integer "last_event_id"
1263
    t.datetime "last_event_date"
1264
    t.integer "cursor_last_event_id"
1265 1266 1267 1268
    t.datetime "cursor_last_event_date"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.datetime "last_successful_status_check_at"
1269
    t.string "status_message"
1270 1271
    t.integer "replication_slots_count"
    t.integer "replication_slots_used_count"
1272
    t.bigint "replication_slots_max_retained_wal_bytes"
1273 1274
    t.integer "wikis_synced_count"
    t.integer "wikis_failed_count"
1275 1276 1277
    t.integer "job_artifacts_count"
    t.integer "job_artifacts_synced_count"
    t.integer "job_artifacts_failed_count"
1278 1279
    t.string "version"
    t.string "revision"
1280 1281 1282 1283
    t.integer "repositories_verified_count"
    t.integer "repositories_verification_failed_count"
    t.integer "wikis_verified_count"
    t.integer "wikis_verification_failed_count"
1284 1285 1286
    t.integer "lfs_objects_synced_missing_on_primary_count"
    t.integer "job_artifacts_synced_missing_on_primary_count"
    t.integer "attachments_synced_missing_on_primary_count"
1287 1288 1289 1290 1291 1292
    t.integer "repositories_checksummed_count"
    t.integer "repositories_checksum_failed_count"
    t.integer "repositories_checksum_mismatch_count"
    t.integer "wikis_checksummed_count"
    t.integer "wikis_checksum_failed_count"
    t.integer "wikis_checksum_mismatch_count"
1293
    t.binary "storage_configuration_digest"
1294 1295
    t.integer "repositories_retrying_verification_count"
    t.integer "wikis_retrying_verification_count"
1296
    t.integer "projects_count"
1297
    t.index ["geo_node_id"], name: "index_geo_node_statuses_on_geo_node_id", unique: true, using: :btree
1298 1299
  end

1300 1301
  create_table "geo_nodes", force: :cascade do |t|
    t.boolean "primary"
1302
    t.integer "oauth_application_id"
1303
    t.boolean "enabled", default: true, null: false
1304 1305 1306
    t.string "access_key"
    t.string "encrypted_secret_access_key"
    t.string "encrypted_secret_access_key_iv"
1307
    t.string "clone_url_prefix"
1308 1309
    t.integer "files_max_capacity", default: 10, null: false
    t.integer "repos_max_capacity", default: 25, null: false
1310
    t.string "url", null: false
1311 1312
    t.string "selective_sync_type"
    t.text "selective_sync_shards"
1313
    t.integer "verification_max_capacity", default: 100, null: false
1314
    t.integer "minimum_reverification_interval", default: 7, null: false
1315 1316 1317
    t.index ["access_key"], name: "index_geo_nodes_on_access_key", using: :btree
    t.index ["primary"], name: "index_geo_nodes_on_primary", using: :btree
    t.index ["url"], name: "index_geo_nodes_on_url", unique: true, using: :btree
1318 1319
  end

1320 1321
  create_table "geo_repositories_changed_events", id: :bigserial, force: :cascade do |t|
    t.integer "geo_node_id", null: false
1322
    t.index ["geo_node_id"], name: "index_geo_repositories_changed_events_on_geo_node_id", using: :btree
1323 1324
  end

1325 1326 1327 1328 1329 1330
  create_table "geo_repository_created_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "repository_storage_name", null: false
    t.text "repo_path", null: false
    t.text "wiki_path"
    t.text "project_name", null: false
1331
    t.index ["project_id"], name: "index_geo_repository_created_events_on_project_id", using: :btree
1332 1333
  end

Stan Hu's avatar
Stan Hu committed
1334 1335
  create_table "geo_repository_deleted_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
1336
    t.text "repository_storage_name", null: false
Stan Hu's avatar
Stan Hu committed
1337 1338 1339
    t.text "deleted_path", null: false
    t.text "deleted_wiki_path"
    t.text "deleted_project_name", null: false
1340
    t.index ["project_id"], name: "index_geo_repository_deleted_events_on_project_id", using: :btree
Stan Hu's avatar
Stan Hu committed
1341 1342
  end

1343 1344 1345
  create_table "geo_repository_renamed_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "repository_storage_name", null: false
1346 1347
    t.text "old_path_with_namespace", null: false
    t.text "new_path_with_namespace", null: false
1348 1349
    t.text "old_wiki_path_with_namespace", null: false
    t.text "new_wiki_path_with_namespace", null: false
1350 1351
    t.text "old_path", null: false
    t.text "new_path", null: false
1352
    t.index ["project_id"], name: "index_geo_repository_renamed_events_on_project_id", using: :btree
1353 1354
  end

1355
  create_table "geo_repository_updated_events", id: :bigserial, force: :cascade do |t|
1356 1357
    t.integer "branches_affected", null: false
    t.integer "tags_affected", null: false
1358
    t.integer "project_id", null: false
1359
    t.integer "source", limit: 2, null: false
1360 1361
    t.boolean "new_branch", default: false, null: false
    t.boolean "remove_branch", default: false, null: false
1362
    t.text "ref"
1363 1364
    t.index ["project_id"], name: "index_geo_repository_updated_events_on_project_id", using: :btree
    t.index ["source"], name: "index_geo_repository_updated_events_on_source", using: :btree
1365 1366
  end

1367 1368
  create_table "geo_reset_checksum_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
1369
    t.index ["project_id"], name: "index_geo_reset_checksum_events_on_project_id", using: :btree
1370 1371
  end

1372 1373 1374 1375 1376 1377
  create_table "geo_upload_deleted_events", id: :bigserial, force: :cascade do |t|
    t.integer "upload_id", null: false
    t.string "file_path", null: false
    t.integer "model_id", null: false
    t.string "model_type", null: false
    t.string "uploader", null: false
1378
    t.index ["upload_id"], name: "index_geo_upload_deleted_events_on_upload_id", using: :btree
1379 1380
  end

1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395
  create_table "gitlab_subscriptions", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.date "start_date"
    t.date "end_date"
    t.date "trial_ends_on"
    t.integer "namespace_id"
    t.integer "hosted_plan_id"
    t.integer "max_seats_used", default: 0
    t.integer "seats", default: 0
    t.boolean "trial", default: false
    t.index ["hosted_plan_id"], name: "index_gitlab_subscriptions_on_hosted_plan_id", using: :btree
    t.index ["namespace_id"], name: "index_gitlab_subscriptions_on_namespace_id", unique: true, using: :btree
  end

1396
  create_table "gpg_key_subkeys", force: :cascade do |t|
1397
    t.integer "gpg_key_id", null: false
1398 1399
    t.binary "keyid"
    t.binary "fingerprint"
1400 1401 1402
    t.index ["fingerprint"], name: "index_gpg_key_subkeys_on_fingerprint", unique: true, using: :btree
    t.index ["gpg_key_id"], name: "index_gpg_key_subkeys_on_gpg_key_id", using: :btree
    t.index ["keyid"], name: "index_gpg_key_subkeys_on_keyid", unique: true, using: :btree
1403 1404
  end

Alexis Reigel's avatar
Alexis Reigel committed
1405
  create_table "gpg_keys", force: :cascade do |t|
1406 1407
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1408
    t.integer "user_id"
1409 1410
    t.binary "primary_keyid"
    t.binary "fingerprint"
1411
    t.text "key"
1412 1413 1414
    t.index ["fingerprint"], name: "index_gpg_keys_on_fingerprint", unique: true, using: :btree
    t.index ["primary_keyid"], name: "index_gpg_keys_on_primary_keyid", unique: true, using: :btree
    t.index ["user_id"], name: "index_gpg_keys_on_user_id", using: :btree
Alexis Reigel's avatar
Alexis Reigel committed
1415 1416
  end

1417
  create_table "gpg_signatures", force: :cascade do |t|
1418 1419
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1420 1421
    t.integer "project_id"
    t.integer "gpg_key_id"
1422 1423
    t.binary "commit_sha"
    t.binary "gpg_key_primary_keyid"
1424 1425
    t.text "gpg_key_user_name"
    t.text "gpg_key_user_email"
1426
    t.integer "verification_status", limit: 2, default: 0, null: false
1427
    t.integer "gpg_key_subkey_id"
1428 1429 1430 1431 1432
    t.index ["commit_sha"], name: "index_gpg_signatures_on_commit_sha", unique: true, using: :btree
    t.index ["gpg_key_id"], name: "index_gpg_signatures_on_gpg_key_id", using: :btree
    t.index ["gpg_key_primary_keyid"], name: "index_gpg_signatures_on_gpg_key_primary_keyid", using: :btree
    t.index ["gpg_key_subkey_id"], name: "index_gpg_signatures_on_gpg_key_subkey_id", using: :btree
    t.index ["project_id"], name: "index_gpg_signatures_on_project_id", using: :btree
1433 1434
  end

1435
  create_table "group_custom_attributes", force: :cascade do |t|
1436 1437
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1438 1439 1440
    t.integer "group_id", null: false
    t.string "key", null: false
    t.string "value", null: false
1441 1442
    t.index ["group_id", "key"], name: "index_group_custom_attributes_on_group_id_and_key", unique: true, using: :btree
    t.index ["key", "value"], name: "index_group_custom_attributes_on_key_and_value", using: :btree
1443 1444
  end

1445 1446 1447 1448 1449 1450 1451
  create_table "historical_data", force: :cascade do |t|
    t.date "date", null: false
    t.integer "active_user_count"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Valery Sizov's avatar
Valery Sizov committed
1452
  create_table "identities", force: :cascade do |t|
1453 1454 1455
    t.string "extern_uid"
    t.string "provider"
    t.integer "user_id"
1456 1457
    t.datetime "created_at"
    t.datetime "updated_at"
1458
    t.string "secondary_extern_uid"
1459
    t.integer "saml_provider_id"
1460 1461
    t.index ["saml_provider_id"], name: "index_identities_on_saml_provider_id", where: "(saml_provider_id IS NOT NULL)", using: :btree
    t.index ["user_id"], name: "index_identities_on_user_id", using: :btree
1462 1463
  end

1464 1465 1466 1467 1468
  create_table "import_export_uploads", force: :cascade do |t|
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id"
    t.text "import_file"
    t.text "export_file"
1469 1470
    t.index ["project_id"], name: "index_import_export_uploads_on_project_id", using: :btree
    t.index ["updated_at"], name: "index_import_export_uploads_on_updated_at", using: :btree
1471 1472
  end

Valery Sizov's avatar
Valery Sizov committed
1473
  create_table "index_statuses", force: :cascade do |t|
1474
    t.integer "project_id", null: false
Valery Sizov's avatar
Valery Sizov committed
1475
    t.datetime "indexed_at"
1476 1477 1478 1479
    t.text "note"
    t.string "last_commit"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1480
    t.index ["project_id"], name: "index_index_statuses_on_project_id", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
1481 1482
  end

1483
  create_table "internal_ids", id: :bigserial, force: :cascade do |t|
1484
    t.integer "project_id"
1485 1486
    t.integer "usage", null: false
    t.integer "last_value", null: false
1487
    t.integer "namespace_id"
Kamil Trzciński's avatar
Kamil Trzciński committed
1488 1489
    t.index ["namespace_id"], name: "index_internal_ids_on_namespace_id", using: :btree
    t.index ["project_id"], name: "index_internal_ids_on_project_id", using: :btree
1490 1491
    t.index ["usage", "namespace_id"], name: "index_internal_ids_on_usage_and_namespace_id", unique: true, where: "(namespace_id IS NOT NULL)", using: :btree
    t.index ["usage", "project_id"], name: "index_internal_ids_on_usage_and_project_id", unique: true, where: "(project_id IS NOT NULL)", using: :btree
1492 1493
  end

1494
  create_table "issue_assignees", id: false, force: :cascade do |t|
1495 1496
    t.integer "user_id", null: false
    t.integer "issue_id", null: false
1497 1498
    t.index ["issue_id", "user_id"], name: "index_issue_assignees_on_issue_id_and_user_id", unique: true, using: :btree
    t.index ["user_id"], name: "index_issue_assignees_on_user_id", using: :btree
1499 1500
  end

1501 1502 1503 1504 1505
  create_table "issue_links", force: :cascade do |t|
    t.integer "source_id", null: false
    t.integer "target_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
1506 1507 1508
    t.index ["source_id", "target_id"], name: "index_issue_links_on_source_id_and_target_id", unique: true, using: :btree
    t.index ["source_id"], name: "index_issue_links_on_source_id", using: :btree
    t.index ["target_id"], name: "index_issue_links_on_target_id", using: :btree
1509 1510
  end

1511
  create_table "issue_metrics", force: :cascade do |t|
1512
    t.integer "issue_id", null: false
1513
    t.datetime "first_mentioned_in_commit_at"
1514 1515
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
1516 1517
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1518
    t.index ["issue_id"], name: "index_issue_metrics", using: :btree
1519 1520
  end

Valery Sizov's avatar
Valery Sizov committed
1521
  create_table "issues", force: :cascade do |t|
1522 1523 1524
    t.string "title"
    t.integer "author_id"
    t.integer "project_id"
1525 1526
    t.datetime "created_at"
    t.datetime "updated_at"
1527 1528 1529 1530 1531 1532
    t.text "description"
    t.integer "milestone_id"
    t.string "state"
    t.integer "iid"
    t.integer "updated_by_id"
    t.integer "weight"
1533
    t.boolean "confidential", default: false, null: false
1534 1535 1536 1537 1538
    t.date "due_date"
    t.integer "moved_to_id"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
1539
    t.integer "time_estimate"
1540
    t.integer "relative_position"
1541
    t.string "service_desk_reply_to"
1542
    t.integer "cached_markdown_version"
1543 1544
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1545
    t.boolean "discussion_locked"
1546
    t.datetime_with_timezone "closed_at"
haseeb's avatar
haseeb committed
1547
    t.integer "closed_by_id"
1548
    t.index ["author_id"], name: "index_issues_on_author_id", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1549
    t.index ["closed_by_id"], name: "index_issues_on_closed_by_id", using: :btree
1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562
    t.index ["confidential"], name: "index_issues_on_confidential", using: :btree
    t.index ["description"], name: "index_issues_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
    t.index ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
    t.index ["moved_to_id"], name: "index_issues_on_moved_to_id", where: "(moved_to_id IS NOT NULL)", using: :btree
    t.index ["project_id", "created_at", "id", "state"], name: "index_issues_on_project_id_and_created_at_and_id_and_state", using: :btree
    t.index ["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
    t.index ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
    t.index ["project_id", "updated_at", "id", "state"], name: "index_issues_on_project_id_and_updated_at_and_id_and_state", using: :btree
    t.index ["relative_position"], name: "index_issues_on_relative_position", using: :btree
    t.index ["state"], name: "index_issues_on_state", using: :btree
    t.index ["title"], name: "index_issues_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
    t.index ["updated_at"], name: "index_issues_on_updated_at", using: :btree
    t.index ["updated_by_id"], name: "index_issues_on_updated_by_id", where: "(updated_by_id IS NOT NULL)", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1563 1564
  end

Valery Sizov's avatar
Valery Sizov committed
1565
  create_table "keys", force: :cascade do |t|
1566
    t.integer "user_id"
1567 1568
    t.datetime "created_at"
    t.datetime "updated_at"
1569 1570 1571 1572 1573
    t.text "key"
    t.string "title"
    t.string "type"
    t.string "fingerprint"
    t.boolean "public", default: false, null: false
1574
    t.datetime "last_used_at"
1575 1576
    t.index ["fingerprint"], name: "index_keys_on_fingerprint", unique: true, using: :btree
    t.index ["user_id"], name: "index_keys_on_user_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1577 1578
  end

Valery Sizov's avatar
Valery Sizov committed
1579
  create_table "label_links", force: :cascade do |t|
1580 1581 1582
    t.integer "label_id"
    t.integer "target_id"
    t.string "target_type"
1583 1584
    t.datetime "created_at"
    t.datetime "updated_at"
1585 1586
    t.index ["label_id"], name: "index_label_links_on_label_id", using: :btree
    t.index ["target_id", "target_type"], name: "index_label_links_on_target_id_and_target_type", using: :btree
1587 1588
  end

1589 1590 1591 1592 1593 1594
  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
Kamil Trzciński's avatar
Kamil Trzciński committed
1595
    t.index ["label_id"], name: "index_label_priorities_on_label_id", using: :btree
1596 1597
    t.index ["priority"], name: "index_label_priorities_on_priority", using: :btree
    t.index ["project_id", "label_id"], name: "index_label_priorities_on_project_id_and_label_id", unique: true, using: :btree
1598 1599
  end

Valery Sizov's avatar
Valery Sizov committed
1600
  create_table "labels", force: :cascade do |t|
1601 1602 1603
    t.string "title"
    t.string "color"
    t.integer "project_id"
1604 1605
    t.datetime "created_at"
    t.datetime "updated_at"
1606 1607 1608
    t.boolean "template", default: false
    t.string "description"
    t.text "description_html"
1609 1610
    t.string "type"
    t.integer "group_id"
1611
    t.integer "cached_markdown_version"
1612 1613 1614 1615 1616
    t.index ["group_id", "project_id", "title"], name: "index_labels_on_group_id_and_project_id_and_title", unique: true, using: :btree
    t.index ["project_id"], name: "index_labels_on_project_id", using: :btree
    t.index ["template"], name: "index_labels_on_template", where: "template", using: :btree
    t.index ["title"], name: "index_labels_on_title", using: :btree
    t.index ["type", "project_id"], name: "index_labels_on_type_and_project_id", using: :btree
1617 1618
  end

Valery Sizov's avatar
Valery Sizov committed
1619
  create_table "ldap_group_links", force: :cascade do |t|
1620
    t.string "cn"
1621 1622
    t.integer "group_access", null: false
    t.integer "group_id", null: false
Valery Sizov's avatar
Valery Sizov committed
1623 1624
    t.datetime "created_at"
    t.datetime "updated_at"
1625
    t.string "provider"
1626
    t.string "filter"
Valery Sizov's avatar
Valery Sizov committed
1627 1628
  end

1629 1630 1631 1632
  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
1633
    t.string "path", limit: 511
1634 1635
    t.index ["project_id", "path"], name: "index_lfs_file_locks_on_project_id_and_path", unique: true, using: :btree
    t.index ["user_id"], name: "index_lfs_file_locks_on_user_id", using: :btree
1636 1637
  end

Valery Sizov's avatar
Valery Sizov committed
1638
  create_table "lfs_objects", force: :cascade do |t|
1639
    t.string "oid", null: false
1640
    t.bigint "size", null: false
Marin Jankovski's avatar
Marin Jankovski committed
1641 1642
    t.datetime "created_at"
    t.datetime "updated_at"
1643
    t.string "file"
1644
    t.integer "file_store"
1645 1646
    t.index ["file_store"], name: "index_lfs_objects_on_file_store", using: :btree
    t.index ["oid"], name: "index_lfs_objects_on_oid", unique: true, using: :btree
Marin Jankovski's avatar
Marin Jankovski committed
1647 1648
  end

Valery Sizov's avatar
Valery Sizov committed
1649
  create_table "lfs_objects_projects", force: :cascade do |t|
1650 1651
    t.integer "lfs_object_id", null: false
    t.integer "project_id", null: false
Marin Jankovski's avatar
Marin Jankovski committed
1652 1653
    t.datetime "created_at"
    t.datetime "updated_at"
1654
    t.index ["project_id"], name: "index_lfs_objects_projects_on_project_id", using: :btree
Marin Jankovski's avatar
Marin Jankovski committed
1655 1656
  end

Valery Sizov's avatar
Valery Sizov committed
1657
  create_table "licenses", force: :cascade do |t|
1658
    t.text "data", null: false
Valery Sizov's avatar
Valery Sizov committed
1659 1660 1661 1662
    t.datetime "created_at"
    t.datetime "updated_at"
  end

1663
  create_table "lists", force: :cascade do |t|
1664 1665 1666 1667 1668 1669
    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
1670
    t.integer "user_id"
1671
    t.integer "milestone_id"
1672 1673 1674 1675 1676
    t.index ["board_id", "label_id"], name: "index_lists_on_board_id_and_label_id", unique: true, using: :btree
    t.index ["label_id"], name: "index_lists_on_label_id", using: :btree
    t.index ["list_type"], name: "index_lists_on_list_type", using: :btree
    t.index ["milestone_id"], name: "index_lists_on_milestone_id", using: :btree
    t.index ["user_id"], name: "index_lists_on_user_id", using: :btree
1677 1678
  end

Valery Sizov's avatar
Valery Sizov committed
1679
  create_table "members", force: :cascade do |t|
1680 1681 1682 1683 1684 1685
    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"
1686 1687
    t.datetime "created_at"
    t.datetime "updated_at"
1688 1689 1690
    t.integer "created_by_id"
    t.string "invite_email"
    t.string "invite_token"
Douwe Maan's avatar
Douwe Maan committed
1691
    t.datetime "invite_accepted_at"
1692
    t.datetime "requested_at"
1693 1694 1695
    t.date "expires_at"
    t.boolean "ldap", default: false, null: false
    t.boolean "override", default: false, null: false
1696 1697 1698 1699 1700
    t.index ["access_level"], name: "index_members_on_access_level", using: :btree
    t.index ["invite_token"], name: "index_members_on_invite_token", unique: true, using: :btree
    t.index ["requested_at"], name: "index_members_on_requested_at", using: :btree
    t.index ["source_id", "source_type"], name: "index_members_on_source_id_and_source_type", using: :btree
    t.index ["user_id"], name: "index_members_on_user_id", using: :btree
1701 1702
  end

1703
  create_table "merge_request_diff_commits", id: false, force: :cascade do |t|
1704 1705
    t.datetime "authored_date"
    t.datetime "committed_date"
1706 1707 1708 1709 1710 1711 1712 1713
    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"
1714 1715
    t.index ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_commits_on_mr_diff_id_and_order", unique: true, using: :btree
    t.index ["sha"], name: "index_merge_request_diff_commits_on_sha", using: :btree
1716 1717
  end

1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729
  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
1730
    t.boolean "binary"
1731
    t.index ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_files_on_mr_diff_id_and_order", unique: true, using: :btree
1732 1733
  end

Valery Sizov's avatar
Valery Sizov committed
1734
  create_table "merge_request_diffs", force: :cascade do |t|
1735 1736
    t.string "state"
    t.integer "merge_request_id", null: false
1737 1738
    t.datetime "created_at"
    t.datetime "updated_at"
1739 1740 1741 1742
    t.string "base_commit_sha"
    t.string "real_size"
    t.string "head_commit_sha"
    t.string "start_commit_sha"
1743
    t.integer "commits_count"
1744
    t.index ["merge_request_id", "id"], name: "index_merge_request_diffs_on_merge_request_id_and_id", using: :btree
1745 1746
  end

1747
  create_table "merge_request_metrics", force: :cascade do |t|
1748
    t.integer "merge_request_id", null: false
1749 1750 1751 1752
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
1753 1754
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1755
    t.integer "pipeline_id"
1756 1757 1758
    t.integer "merged_by_id"
    t.integer "latest_closed_by_id"
    t.datetime_with_timezone "latest_closed_at"
1759
    t.index ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1760
    t.index ["latest_closed_by_id"], name: "index_merge_request_metrics_on_latest_closed_by_id", using: :btree
1761
    t.index ["merge_request_id"], name: "index_merge_request_metrics", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1762
    t.index ["merged_by_id"], name: "index_merge_request_metrics_on_merged_by_id", using: :btree
1763
    t.index ["pipeline_id"], name: "index_merge_request_metrics_on_pipeline_id", using: :btree
1764 1765
  end

Valery Sizov's avatar
Valery Sizov committed
1766
  create_table "merge_requests", force: :cascade do |t|
1767 1768
    t.string "target_branch", null: false
    t.string "source_branch", null: false
1769
    t.integer "source_project_id"
1770 1771 1772
    t.integer "author_id"
    t.integer "assignee_id"
    t.string "title"
1773 1774
    t.datetime "created_at"
    t.datetime "updated_at"
1775
    t.integer "milestone_id"
1776 1777
    t.string "state", default: "opened", null: false
    t.string "merge_status", default: "unchecked", null: false
1778 1779 1780 1781 1782 1783
    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"
1784
    t.boolean "merge_when_pipeline_succeeds", default: false, null: false
1785 1786 1787 1788 1789 1790 1791 1792
    t.integer "merge_user_id"
    t.string "merge_commit_sha"
    t.integer "approvals_before_merge"
    t.string "rebase_commit_sha"
    t.string "in_progress_merge_commit_sha"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
1793
    t.integer "time_estimate"
1794
    t.boolean "squash", default: false, null: false
1795
    t.integer "cached_markdown_version"
1796 1797
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1798
    t.integer "head_pipeline_id"
1799
    t.string "merge_jid"
1800
    t.boolean "discussion_locked"
1801
    t.integer "latest_merge_request_diff_id"
1802
    t.boolean "allow_maintainer_to_push"
1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821
    t.index ["assignee_id"], name: "index_merge_requests_on_assignee_id", using: :btree
    t.index ["author_id"], name: "index_merge_requests_on_author_id", using: :btree
    t.index ["created_at"], name: "index_merge_requests_on_created_at", using: :btree
    t.index ["description"], name: "index_merge_requests_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
    t.index ["head_pipeline_id"], name: "index_merge_requests_on_head_pipeline_id", using: :btree
    t.index ["id", "merge_jid"], name: "index_merge_requests_on_id_and_merge_jid", where: "((merge_jid IS NOT NULL) AND ((state)::text = 'locked'::text))", using: :btree
    t.index ["latest_merge_request_diff_id"], name: "index_merge_requests_on_latest_merge_request_diff_id", using: :btree
    t.index ["merge_user_id"], name: "index_merge_requests_on_merge_user_id", where: "(merge_user_id IS NOT NULL)", using: :btree
    t.index ["milestone_id"], name: "index_merge_requests_on_milestone_id", using: :btree
    t.index ["source_branch"], name: "index_merge_requests_on_source_branch", using: :btree
    t.index ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_and_branch_state_opened", where: "((state)::text = 'opened'::text)", using: :btree
    t.index ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_id_and_source_branch", using: :btree
    t.index ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
    t.index ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid", unique: true, using: :btree
    t.index ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid_opened", where: "((state)::text = 'opened'::text)", using: :btree
    t.index ["target_project_id", "merge_commit_sha", "id"], name: "index_merge_requests_on_tp_id_and_merge_commit_sha_and_id", using: :btree
    t.index ["title"], name: "index_merge_requests_on_title", using: :btree
    t.index ["title"], name: "index_merge_requests_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
    t.index ["updated_by_id"], name: "index_merge_requests_on_updated_by_id", where: "(updated_by_id IS NOT NULL)", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1822 1823
  end

1824
  create_table "merge_requests_closing_issues", force: :cascade do |t|
1825 1826 1827 1828
    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
1829 1830
    t.index ["issue_id"], name: "index_merge_requests_closing_issues_on_issue_id", using: :btree
    t.index ["merge_request_id"], name: "index_merge_requests_closing_issues_on_merge_request_id", using: :btree
1831 1832
  end

Valery Sizov's avatar
Valery Sizov committed
1833
  create_table "milestones", force: :cascade do |t|
1834
    t.string "title", null: false
Felipe Artur's avatar
Felipe Artur committed
1835
    t.integer "project_id"
1836 1837
    t.text "description"
    t.date "due_date"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1838 1839
    t.datetime "created_at"
    t.datetime "updated_at"
1840 1841 1842 1843
    t.string "state"
    t.integer "iid"
    t.text "title_html"
    t.text "description_html"
1844
    t.date "start_date"
1845
    t.integer "cached_markdown_version"
Felipe Artur's avatar
Felipe Artur committed
1846
    t.integer "group_id"
1847 1848 1849 1850 1851 1852
    t.index ["description"], name: "index_milestones_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
    t.index ["due_date"], name: "index_milestones_on_due_date", using: :btree
    t.index ["group_id"], name: "index_milestones_on_group_id", using: :btree
    t.index ["project_id", "iid"], name: "index_milestones_on_project_id_and_iid", unique: true, using: :btree
    t.index ["title"], name: "index_milestones_on_title", using: :btree
    t.index ["title"], name: "index_milestones_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
1853 1854
  end

1855 1856
  create_table "namespace_statistics", force: :cascade do |t|
    t.integer "namespace_id", null: false
1857 1858
    t.integer "shared_runners_seconds", default: 0, null: false
    t.datetime "shared_runners_seconds_last_reset"
1859
    t.index ["namespace_id"], name: "index_namespace_statistics_on_namespace_id", unique: true, using: :btree
1860 1861
  end

Valery Sizov's avatar
Valery Sizov committed
1862
  create_table "namespaces", force: :cascade do |t|
1863 1864 1865
    t.string "name", null: false
    t.string "path", null: false
    t.integer "owner_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1866 1867
    t.datetime "created_at"
    t.datetime "updated_at"
1868 1869 1870 1871 1872 1873
    t.string "type"
    t.string "description", default: "", null: false
    t.string "avatar"
    t.boolean "membership_lock", default: false
    t.boolean "share_with_group_lock", default: false
    t.integer "visibility_level", default: 20, null: false
1874
    t.boolean "request_access_enabled", default: false, null: false
1875 1876
    t.string "ldap_sync_status", default: "ready", null: false
    t.string "ldap_sync_error"
1877 1878 1879
    t.datetime "ldap_sync_last_update_at"
    t.datetime "ldap_sync_last_successful_update_at"
    t.datetime "ldap_sync_last_sync_at"
Nick Thomas's avatar
Nick Thomas committed
1880
    t.text "description_html"
1881
    t.boolean "lfs_enabled"
1882
    t.integer "parent_id"
1883
    t.integer "shared_runners_minutes_limit"
1884
    t.bigint "repository_size_limit"
1885 1886
    t.boolean "require_two_factor_authentication", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
1887
    t.integer "cached_markdown_version"
1888
    t.integer "plan_id"
1889
    t.integer "project_creation_level"
1890
    t.string "runners_token"
1891
    t.datetime_with_timezone "trial_ends_on"
Nick Thomas's avatar
Nick Thomas committed
1892
    t.integer "file_template_project_id"
1893
    t.string "saml_discovery_token"
1894
    t.string "runners_token_encrypted"
1895
    t.integer "custom_project_templates_group_id"
1896
    t.index ["created_at"], name: "index_namespaces_on_created_at", using: :btree
1897
    t.index ["custom_project_templates_group_id", "type"], name: "index_namespaces_on_custom_project_templates_group_id_and_type", where: "(custom_project_templates_group_id IS NOT NULL)", using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
1898
    t.index ["file_template_project_id"], name: "index_namespaces_on_file_template_project_id", using: :btree
1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911
    t.index ["ldap_sync_last_successful_update_at"], name: "index_namespaces_on_ldap_sync_last_successful_update_at", using: :btree
    t.index ["ldap_sync_last_update_at"], name: "index_namespaces_on_ldap_sync_last_update_at", using: :btree
    t.index ["name", "parent_id"], name: "index_namespaces_on_name_and_parent_id", unique: true, using: :btree
    t.index ["name"], name: "index_namespaces_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
    t.index ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
    t.index ["parent_id", "id"], name: "index_namespaces_on_parent_id_and_id", unique: true, using: :btree
    t.index ["path"], name: "index_namespaces_on_path", using: :btree
    t.index ["path"], name: "index_namespaces_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
    t.index ["plan_id"], name: "index_namespaces_on_plan_id", using: :btree
    t.index ["require_two_factor_authentication"], name: "index_namespaces_on_require_two_factor_authentication", using: :btree
    t.index ["runners_token"], name: "index_namespaces_on_runners_token", unique: true, using: :btree
    t.index ["trial_ends_on"], name: "index_namespaces_on_trial_ends_on", where: "(trial_ends_on IS NOT NULL)", using: :btree
    t.index ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1912 1913
  end

1914 1915 1916 1917 1918 1919 1920 1921 1922 1923
  create_table "note_diff_files", force: :cascade do |t|
    t.integer "diff_note_id", null: false
    t.text "diff", null: false
    t.boolean "new_file", null: false
    t.boolean "renamed_file", null: false
    t.boolean "deleted_file", 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
1924
    t.index ["diff_note_id"], name: "index_note_diff_files_on_diff_note_id", unique: true, using: :btree
1925 1926
  end

Valery Sizov's avatar
Valery Sizov committed
1927
  create_table "notes", force: :cascade do |t|
1928 1929 1930
    t.text "note"
    t.string "noteable_type"
    t.integer "author_id"
1931 1932
    t.datetime "created_at"
    t.datetime "updated_at"
1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943
    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"
1944
    t.datetime "resolved_at"
1945 1946 1947
    t.integer "resolved_by_id"
    t.string "discussion_id"
    t.text "note_html"
1948
    t.integer "cached_markdown_version"
1949
    t.text "change_position"
1950
    t.boolean "resolved_by_push"
1951
    t.bigint "review_id"
1952 1953 1954 1955 1956 1957 1958 1959 1960
    t.index ["author_id"], name: "index_notes_on_author_id", using: :btree
    t.index ["commit_id"], name: "index_notes_on_commit_id", using: :btree
    t.index ["created_at"], name: "index_notes_on_created_at", using: :btree
    t.index ["discussion_id"], name: "index_notes_on_discussion_id", using: :btree
    t.index ["line_code"], name: "index_notes_on_line_code", using: :btree
    t.index ["note"], name: "index_notes_on_note_trigram", using: :gin, opclasses: {"note"=>"gin_trgm_ops"}
    t.index ["noteable_id", "noteable_type"], name: "index_notes_on_noteable_id_and_noteable_type", using: :btree
    t.index ["noteable_type"], name: "index_notes_on_noteable_type", using: :btree
    t.index ["project_id", "noteable_type"], name: "index_notes_on_project_id_and_noteable_type", using: :btree
1961
    t.index ["review_id"], name: "index_notes_on_review_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
1962 1963
  end

1964
  create_table "notification_settings", force: :cascade do |t|
1965 1966 1967 1968 1969 1970
    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
1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982
    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"
1983
    t.boolean "push_to_merge_request"
1984
    t.boolean "issue_due"
1985
    t.boolean "new_epic"
1986 1987 1988
    t.index ["source_id", "source_type"], name: "index_notification_settings_on_source_id_and_source_type", using: :btree
    t.index ["user_id", "source_id", "source_type"], name: "index_notifications_on_user_id_and_source_id_and_source_type", unique: true, using: :btree
    t.index ["user_id"], name: "index_notification_settings_on_user_id", using: :btree
1989 1990
  end

Valery Sizov's avatar
Valery Sizov committed
1991
  create_table "oauth_access_grants", force: :cascade do |t|
1992 1993 1994 1995 1996 1997
    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
1998
    t.datetime "revoked_at"
1999
    t.string "scopes"
2000
    t.index ["token"], name: "index_oauth_access_grants_on_token", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
2001 2002
  end

Valery Sizov's avatar
Valery Sizov committed
2003
  create_table "oauth_access_tokens", force: :cascade do |t|
2004 2005 2006 2007 2008
    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
2009
    t.datetime "revoked_at"
2010 2011
    t.datetime "created_at", null: false
    t.string "scopes"
2012 2013 2014
    t.index ["refresh_token"], name: "index_oauth_access_tokens_on_refresh_token", unique: true, using: :btree
    t.index ["resource_owner_id"], name: "index_oauth_access_tokens_on_resource_owner_id", using: :btree
    t.index ["token"], name: "index_oauth_access_tokens_on_token", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
2015 2016
  end

Valery Sizov's avatar
Valery Sizov committed
2017
  create_table "oauth_applications", force: :cascade do |t|
2018 2019 2020 2021 2022
    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
2023 2024
    t.datetime "created_at"
    t.datetime "updated_at"
2025 2026
    t.integer "owner_id"
    t.string "owner_type"
2027
    t.boolean "trusted", default: false, null: false
2028 2029
    t.index ["owner_id", "owner_type"], name: "index_oauth_applications_on_owner_id_and_owner_type", using: :btree
    t.index ["uid"], name: "index_oauth_applications_on_uid", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
2030 2031
  end

2032 2033 2034
  create_table "oauth_openid_requests", force: :cascade do |t|
    t.integer "access_grant_id", null: false
    t.string "nonce", null: false
Kamil Trzciński's avatar
Kamil Trzciński committed
2035
    t.index ["access_grant_id"], name: "index_oauth_openid_requests_on_access_grant_id", using: :btree
2036 2037
  end

2038 2039 2040 2041 2042 2043 2044 2045 2046
  create_table "operations_feature_flag_scopes", id: :bigserial, force: :cascade do |t|
    t.bigint "feature_flag_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.boolean "active", null: false
    t.string "environment_scope", default: "*", null: false
    t.index ["feature_flag_id", "environment_scope"], name: "index_feature_flag_scopes_on_flag_id_and_environment_scope", unique: true, using: :btree
  end

2047
  create_table "operations_feature_flags", id: :bigserial, force: :cascade do |t|
2048
    t.integer "project_id", null: false
2049
    t.boolean "active", null: false
2050 2051 2052 2053
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "name", null: false
    t.text "description"
2054
    t.index ["project_id", "name"], name: "index_operations_feature_flags_on_project_id_and_name", unique: true, using: :btree
2055 2056
  end

2057
  create_table "operations_feature_flags_clients", id: :bigserial, force: :cascade do |t|
2058 2059
    t.integer "project_id", null: false
    t.string "token", null: false
2060
    t.index ["project_id", "token"], name: "index_operations_feature_flags_clients_on_project_id_and_token", unique: true, using: :btree
2061 2062
  end

2063
  create_table "packages_maven_metadata", id: :bigserial, force: :cascade do |t|
2064
    t.bigint "package_id", null: false
2065 2066
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2067 2068
    t.string "app_group", null: false
    t.string "app_name", null: false
2069
    t.string "app_version"
2070
    t.string "path", limit: 512, null: false
2071
    t.index ["package_id", "path"], name: "index_packages_maven_metadata_on_package_id_and_path", using: :btree
2072 2073
  end

2074
  create_table "packages_package_files", id: :bigserial, force: :cascade do |t|
2075
    t.bigint "package_id", null: false
2076 2077
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2078
    t.bigint "size"
2079 2080 2081 2082
    t.integer "file_type"
    t.integer "file_store"
    t.binary "file_md5"
    t.binary "file_sha1"
2083
    t.string "file_name", null: false
2084
    t.text "file", null: false
2085
    t.index ["package_id", "file_name"], name: "index_packages_package_files_on_package_id_and_file_name", using: :btree
2086 2087
  end

2088
  create_table "packages_packages", id: :bigserial, force: :cascade do |t|
2089
    t.integer "project_id", null: false
2090 2091
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2092
    t.string "name", null: false
2093
    t.string "version"
2094
    t.integer "package_type", limit: 2, null: false
2095
    t.index ["project_id"], name: "index_packages_packages_on_project_id", using: :btree
2096 2097
  end

Kamil Trzcinski's avatar
Kamil Trzcinski committed
2098 2099
  create_table "pages_domains", force: :cascade do |t|
    t.integer "project_id"
2100 2101 2102 2103 2104
    t.text "certificate"
    t.text "encrypted_key"
    t.string "encrypted_key_iv"
    t.string "encrypted_key_salt"
    t.string "domain"
2105 2106 2107
    t.datetime_with_timezone "verified_at"
    t.string "verification_code", null: false
    t.datetime_with_timezone "enabled_until"
2108 2109 2110 2111 2112
    t.index ["domain"], name: "index_pages_domains_on_domain", unique: true, using: :btree
    t.index ["project_id", "enabled_until"], name: "index_pages_domains_on_project_id_and_enabled_until", using: :btree
    t.index ["project_id"], name: "index_pages_domains_on_project_id", using: :btree
    t.index ["verified_at", "enabled_until"], name: "index_pages_domains_on_verified_at_and_enabled_until", using: :btree
    t.index ["verified_at"], name: "index_pages_domains_on_verified_at", using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2113 2114
  end

Valery Sizov's avatar
Valery Sizov committed
2115
  create_table "path_locks", force: :cascade do |t|
2116 2117 2118
    t.string "path", null: false
    t.integer "project_id"
    t.integer "user_id"
Valery Sizov's avatar
Valery Sizov committed
2119 2120
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2121 2122 2123
    t.index ["path"], name: "index_path_locks_on_path", using: :btree
    t.index ["project_id"], name: "index_path_locks_on_project_id", using: :btree
    t.index ["user_id"], name: "index_path_locks_on_user_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
2124 2125
  end

2126
  create_table "personal_access_tokens", force: :cascade do |t|
2127
    t.integer "user_id", null: false
2128
    t.string "token"
2129 2130
    t.string "name", null: false
    t.boolean "revoked", default: false
2131
    t.date "expires_at"
2132 2133
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2134
    t.string "scopes", default: "--- []\n", null: false
Simon Vocella's avatar
Simon Vocella committed
2135
    t.boolean "impersonation", default: false, null: false
2136
    t.string "token_digest"
2137 2138 2139
    t.index ["token"], name: "index_personal_access_tokens_on_token", unique: true, using: :btree
    t.index ["token_digest"], name: "index_personal_access_tokens_on_token_digest", unique: true, using: :btree
    t.index ["user_id"], name: "index_personal_access_tokens_on_user_id", using: :btree
2140 2141
  end

2142
  create_table "plans", force: :cascade do |t|
2143 2144
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2145 2146
    t.string "name"
    t.string "title"
2147 2148
    t.integer "active_pipelines_limit"
    t.integer "pipeline_size_limit"
2149
    t.index ["name"], name: "index_plans_on_name", using: :btree
2150 2151
  end

2152 2153 2154
  create_table "pool_repositories", id: :bigserial, force: :cascade do |t|
    t.integer "shard_id", null: false
    t.string "disk_path"
2155 2156
    t.string "state"
    t.integer "source_project_id"
2157 2158
    t.index ["disk_path"], name: "index_pool_repositories_on_disk_path", unique: true, using: :btree
    t.index ["shard_id"], name: "index_pool_repositories_on_shard_id", using: :btree
2159
    t.index ["source_project_id"], name: "index_pool_repositories_on_source_project_id", unique: true, using: :btree
2160 2161
  end

2162 2163 2164 2165
  create_table "programming_languages", force: :cascade do |t|
    t.string "name", null: false
    t.string "color", null: false
    t.datetime_with_timezone "created_at", null: false
2166
    t.index ["name"], name: "index_programming_languages_on_name", unique: true, using: :btree
2167 2168
  end

2169 2170 2171 2172 2173
  create_table "project_alerting_settings", primary_key: "project_id", id: :integer, force: :cascade do |t|
    t.string "encrypted_token", null: false
    t.string "encrypted_token_iv", null: false
  end

2174
  create_table "project_authorizations", id: false, force: :cascade do |t|
2175 2176 2177
    t.integer "user_id", null: false
    t.integer "project_id", null: false
    t.integer "access_level", null: false
2178 2179
    t.index ["project_id"], name: "index_project_authorizations_on_project_id", using: :btree
    t.index ["user_id", "project_id", "access_level"], name: "index_project_authorizations_on_user_id_project_id_access_level", unique: true, using: :btree
2180 2181
  end

2182
  create_table "project_auto_devops", force: :cascade do |t|
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
2183
    t.integer "project_id", null: false
2184 2185
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2186 2187
    t.boolean "enabled"
    t.string "domain"
2188
    t.integer "deploy_strategy", default: 0, null: false
2189
    t.index ["project_id"], name: "index_project_auto_devops_on_project_id", unique: true, using: :btree
2190 2191
  end

2192 2193 2194
  create_table "project_ci_cd_settings", force: :cascade do |t|
    t.integer "project_id", null: false
    t.boolean "group_runners_enabled", default: true, null: false
2195
    t.index ["project_id"], name: "index_project_ci_cd_settings_on_project_id", unique: true, using: :btree
2196 2197
  end

2198
  create_table "project_custom_attributes", force: :cascade do |t|
2199 2200
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2201 2202 2203
    t.integer "project_id", null: false
    t.string "key", null: false
    t.string "value", null: false
2204 2205
    t.index ["key", "value"], name: "index_project_custom_attributes_on_key_and_value", using: :btree
    t.index ["project_id", "key"], name: "index_project_custom_attributes_on_project_id_and_key", unique: true, using: :btree
2206 2207
  end

2208 2209 2210
  create_table "project_deploy_tokens", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "deploy_token_id", null: false
2211
    t.datetime_with_timezone "created_at", null: false
2212 2213
    t.index ["deploy_token_id"], name: "index_project_deploy_tokens_on_deploy_token_id", using: :btree
    t.index ["project_id", "deploy_token_id"], name: "index_project_deploy_tokens_on_project_id_and_deploy_token_id", unique: true, using: :btree
2214 2215
  end

2216
  create_table "project_error_tracking_settings", primary_key: "project_id", id: :integer, force: :cascade do |t|
2217 2218
    t.boolean "enabled", default: false, null: false
    t.string "api_url"
2219 2220
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
2221 2222
    t.string "project_name"
    t.string "organization_name"
2223 2224
  end

2225 2226 2227 2228 2229 2230 2231 2232
  create_table "project_feature_usages", primary_key: "project_id", id: :integer, force: :cascade do |t|
    t.datetime "jira_dvcs_cloud_last_sync_at"
    t.datetime "jira_dvcs_server_last_sync_at"
    t.index ["jira_dvcs_cloud_last_sync_at", "project_id"], name: "idx_proj_feat_usg_on_jira_dvcs_cloud_last_sync_at_and_proj_id", where: "(jira_dvcs_cloud_last_sync_at IS NOT NULL)", using: :btree
    t.index ["jira_dvcs_server_last_sync_at", "project_id"], name: "idx_proj_feat_usg_on_jira_dvcs_server_last_sync_at_and_proj_id", where: "(jira_dvcs_server_last_sync_at IS NOT NULL)", using: :btree
    t.index ["project_id"], name: "index_project_feature_usages_on_project_id", using: :btree
  end

2233
  create_table "project_features", force: :cascade do |t|
2234
    t.integer "project_id", null: false
2235 2236 2237
    t.integer "merge_requests_access_level"
    t.integer "issues_access_level"
    t.integer "wiki_access_level"
2238
    t.integer "snippets_access_level", default: 20, null: false
2239
    t.integer "builds_access_level"
2240 2241
    t.datetime "created_at"
    t.datetime "updated_at"
2242
    t.integer "repository_access_level", default: 20, null: false
2243
    t.integer "pages_access_level", default: 20, null: false
2244
    t.index ["project_id"], name: "index_project_features_on_project_id", unique: true, using: :btree
2245 2246
  end

Valery Sizov's avatar
Valery Sizov committed
2247
  create_table "project_group_links", force: :cascade do |t|
2248 2249
    t.integer "project_id", null: false
    t.integer "group_id", null: false
Valery Sizov's avatar
Valery Sizov committed
2250 2251
    t.datetime "created_at"
    t.datetime "updated_at"
2252 2253
    t.integer "group_access", default: 30, null: false
    t.date "expires_at"
2254 2255
    t.index ["group_id"], name: "index_project_group_links_on_group_id", using: :btree
    t.index ["project_id"], name: "index_project_group_links_on_project_id", using: :btree
Valery Sizov's avatar
Valery Sizov committed
2256 2257 2258
  end

  create_table "project_import_data", force: :cascade do |t|
2259
    t.integer "project_id"
2260 2261 2262 2263
    t.text "data"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
2264
    t.index ["project_id"], name: "index_project_import_data_on_project_id", using: :btree
2265 2266
  end

2267
  create_table "project_mirror_data", force: :cascade do |t|
2268
    t.integer "project_id", null: false
2269 2270 2271
    t.integer "retry_count", default: 0, null: false
    t.datetime "last_update_started_at"
    t.datetime "last_update_scheduled_at"
2272
    t.datetime "next_execution_timestamp"
2273 2274
    t.string "status"
    t.string "jid"
2275
    t.text "last_error"
2276 2277
    t.datetime_with_timezone "last_update_at"
    t.datetime_with_timezone "last_successful_update_at"
2278 2279 2280 2281 2282
    t.index ["jid"], name: "index_project_mirror_data_on_jid", using: :btree
    t.index ["last_successful_update_at"], name: "index_project_mirror_data_on_last_successful_update_at", using: :btree
    t.index ["next_execution_timestamp", "retry_count"], name: "index_mirror_data_on_next_execution_and_retry_count", using: :btree
    t.index ["project_id"], name: "index_project_mirror_data_on_project_id", unique: true, using: :btree
    t.index ["status"], name: "index_project_mirror_data_on_status", using: :btree
2283 2284
  end

2285 2286 2287
  create_table "project_repositories", id: :bigserial, force: :cascade do |t|
    t.integer "shard_id", null: false
    t.string "disk_path", null: false
2288
    t.integer "project_id", null: false
2289
    t.index ["disk_path"], name: "index_project_repositories_on_disk_path", unique: true, using: :btree
2290
    t.index ["project_id"], name: "index_project_repositories_on_project_id", unique: true, using: :btree
2291 2292 2293
    t.index ["shard_id"], name: "index_project_repositories_on_shard_id", using: :btree
  end

2294 2295 2296 2297 2298 2299
  create_table "project_repository_states", force: :cascade do |t|
    t.integer "project_id", null: false
    t.binary "repository_verification_checksum"
    t.binary "wiki_verification_checksum"
    t.string "last_repository_verification_failure"
    t.string "last_wiki_verification_failure"
2300 2301 2302 2303
    t.datetime_with_timezone "repository_retry_at"
    t.datetime_with_timezone "wiki_retry_at"
    t.integer "repository_retry_count"
    t.integer "wiki_retry_count"
2304 2305
    t.datetime_with_timezone "last_repository_verification_ran_at"
    t.datetime_with_timezone "last_wiki_verification_ran_at"
2306 2307
    t.index ["last_repository_verification_failure"], name: "idx_repository_states_on_repository_failure_partial", where: "(last_repository_verification_failure IS NOT NULL)", using: :btree
    t.index ["last_wiki_verification_failure"], name: "idx_repository_states_on_wiki_failure_partial", where: "(last_wiki_verification_failure IS NOT NULL)", using: :btree
2308 2309
    t.index ["project_id", "last_repository_verification_ran_at"], name: "idx_repository_states_on_last_repository_verification_ran_at", where: "((repository_verification_checksum IS NOT NULL) AND (last_repository_verification_failure IS NULL))", using: :btree
    t.index ["project_id", "last_wiki_verification_ran_at"], name: "idx_repository_states_on_last_wiki_verification_ran_at", where: "((wiki_verification_checksum IS NOT NULL) AND (last_wiki_verification_failure IS NULL))", using: :btree
2310 2311
    t.index ["project_id"], name: "idx_repository_states_outdated_checksums", where: "(((repository_verification_checksum IS NULL) AND (last_repository_verification_failure IS NULL)) OR ((wiki_verification_checksum IS NULL) AND (last_wiki_verification_failure IS NULL)))", using: :btree
    t.index ["project_id"], name: "index_project_repository_states_on_project_id", unique: true, using: :btree
2312 2313
  end

2314 2315 2316
  create_table "project_statistics", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "namespace_id", null: false
2317 2318 2319 2320 2321 2322
    t.bigint "commit_count", default: 0, null: false
    t.bigint "storage_size", default: 0, null: false
    t.bigint "repository_size", default: 0, null: false
    t.bigint "lfs_objects_size", default: 0, null: false
    t.bigint "build_artifacts_size", default: 0, null: false
    t.bigint "shared_runners_seconds", default: 0, null: false
2323
    t.datetime "shared_runners_seconds_last_reset"
2324 2325
    t.index ["namespace_id"], name: "index_project_statistics_on_namespace_id", using: :btree
    t.index ["project_id"], name: "index_project_statistics_on_project_id", unique: true, using: :btree
2326 2327
  end

Simon Knox's avatar
Simon Knox committed
2328 2329 2330 2331 2332
  create_table "project_tracing_settings", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id", null: false
    t.string "external_url", null: false
2333
    t.index ["project_id"], name: "index_project_tracing_settings_on_project_id", unique: true, using: :btree
Simon Knox's avatar
Simon Knox committed
2334 2335
  end

Valery Sizov's avatar
Valery Sizov committed
2336
  create_table "projects", force: :cascade do |t|
2337 2338 2339
    t.string "name"
    t.string "path"
    t.text "description"
2340 2341
    t.datetime "created_at"
    t.datetime "updated_at"
2342
    t.integer "creator_id"
2343
    t.integer "namespace_id", null: false
2344
    t.datetime "last_activity_at"
2345 2346 2347 2348
    t.string "import_url"
    t.integer "visibility_level", default: 0, null: false
    t.boolean "archived", default: false, null: false
    t.string "avatar"
Tiago Botelho's avatar
Tiago Botelho committed
2349
    t.string "import_status"
2350 2351
    t.text "merge_requests_template"
    t.integer "star_count", default: 0, null: false
2352
    t.boolean "merge_requests_rebase_enabled", default: false
2353 2354 2355 2356
    t.string "import_type"
    t.string "import_source"
    t.integer "approvals_before_merge", default: 0, null: false
    t.boolean "reset_approvals_on_push", default: true
2357
    t.boolean "merge_requests_ff_only_enabled", default: false
2358 2359
    t.text "issues_template"
    t.boolean "mirror", default: false, null: false
Tiago Botelho's avatar
Tiago Botelho committed
2360 2361
    t.datetime "mirror_last_update_at"
    t.datetime "mirror_last_successful_update_at"
2362
    t.integer "mirror_user_id"
Tiago Botelho's avatar
Tiago Botelho committed
2363
    t.text "import_error"
2364 2365 2366 2367 2368 2369 2370 2371 2372 2373
    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 "mirror_trigger_builds", default: false, null: false
    t.boolean "pending_delete", default: false
    t.boolean "public_builds", default: true, null: false
    t.boolean "last_repository_check_failed"
2374
    t.datetime "last_repository_check_at"
2375
    t.boolean "container_registry_enabled"
2376
    t.boolean "only_allow_merge_if_pipeline_succeeds", default: false, null: false
2377 2378
    t.boolean "has_external_issue_tracker"
    t.string "repository_storage", default: "default", null: false
2379
    t.boolean "repository_read_only"
2380
    t.boolean "request_access_enabled", default: false, null: false
2381
    t.boolean "has_external_wiki"
2382
    t.string "ci_config_path"
2383 2384
    t.boolean "lfs_enabled"
    t.text "description_html"
2385
    t.boolean "only_allow_merge_if_all_discussions_are_resolved"
2386
    t.bigint "repository_size_limit"
2387
    t.boolean "printing_merge_request_link_enabled", default: true, null: false
2388
    t.integer "auto_cancel_pending_pipelines", default: 1, null: false
2389
    t.boolean "service_desk_enabled", default: true
Tiago Botelho's avatar
Tiago Botelho committed
2390
    t.string "import_jid"
2391
    t.integer "cached_markdown_version"
2392
    t.text "delete_error"
2393
    t.datetime "last_repository_updated_at"
Simon Knox's avatar
Simon Knox committed
2394
    t.boolean "disable_overriding_approvers_per_merge_request"
2395
    t.integer "storage_version", limit: 2
Sean McGivern's avatar
Sean McGivern committed
2396
    t.boolean "resolve_outdated_diff_discussions"
2397
    t.boolean "remote_mirror_available_overridden"
2398
    t.boolean "only_mirror_protected_branches"
2399
    t.boolean "pull_mirror_available_overridden"
2400
    t.integer "jobs_cache_index"
2401
    t.string "external_authorization_classification_label"
2402
    t.boolean "mirror_overwrites_diverged_branches"
Rob Watson's avatar
Rob Watson committed
2403
    t.boolean "pages_https_only", default: true
2404
    t.string "external_webhook_token"
2405
    t.boolean "packages_enabled"
2406
    t.boolean "merge_requests_author_approval"
2407
    t.bigint "pool_repository_id"
2408
    t.string "runners_token_encrypted"
2409
    t.string "bfg_object_map"
2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433
    t.index ["ci_id"], name: "index_projects_on_ci_id", using: :btree
    t.index ["created_at"], name: "index_projects_on_created_at", using: :btree
    t.index ["creator_id"], name: "index_projects_on_creator_id", using: :btree
    t.index ["description"], name: "index_projects_on_description_trigram", using: :gin, opclasses: {"description"=>"gin_trgm_ops"}
    t.index ["id", "repository_storage", "last_repository_updated_at"], name: "idx_projects_on_repository_storage_last_repository_updated_at", using: :btree
    t.index ["id"], name: "index_projects_on_id_partial_for_visibility", unique: true, where: "(visibility_level = ANY (ARRAY[10, 20]))", using: :btree
    t.index ["id"], name: "index_projects_on_mirror_and_mirror_trigger_builds_both_true", where: "((mirror IS TRUE) AND (mirror_trigger_builds IS TRUE))", using: :btree
    t.index ["last_activity_at"], name: "index_projects_on_last_activity_at", using: :btree
    t.index ["last_repository_check_at"], name: "index_projects_on_last_repository_check_at", where: "(last_repository_check_at IS NOT NULL)", using: :btree
    t.index ["last_repository_check_failed"], name: "index_projects_on_last_repository_check_failed", using: :btree
    t.index ["last_repository_updated_at"], name: "index_projects_on_last_repository_updated_at", using: :btree
    t.index ["mirror_last_successful_update_at"], name: "index_projects_on_mirror_last_successful_update_at", using: :btree
    t.index ["name"], name: "index_projects_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
    t.index ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
    t.index ["path"], name: "index_projects_on_path", using: :btree
    t.index ["path"], name: "index_projects_on_path_trigram", using: :gin, opclasses: {"path"=>"gin_trgm_ops"}
    t.index ["pending_delete"], name: "index_projects_on_pending_delete", using: :btree
    t.index ["pool_repository_id"], name: "index_projects_on_pool_repository_id", where: "(pool_repository_id IS NOT NULL)", using: :btree
    t.index ["repository_storage", "created_at"], name: "idx_project_repository_check_partial", where: "(last_repository_check_at IS NULL)", using: :btree
    t.index ["repository_storage"], name: "index_projects_on_repository_storage", using: :btree
    t.index ["runners_token"], name: "index_projects_on_runners_token", using: :btree
    t.index ["star_count"], name: "index_projects_on_star_count", using: :btree
    t.index ["visibility_level"], name: "index_projects_on_visibility_level", using: :btree
  end
Andrew8xx8's avatar
Andrew8xx8 committed
2434

2435 2436 2437 2438 2439 2440 2441
  create_table "prometheus_alert_events", id: :bigserial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "prometheus_alert_id", null: false
    t.datetime_with_timezone "started_at", null: false
    t.datetime_with_timezone "ended_at"
    t.integer "status", limit: 2
    t.string "payload_key"
2442 2443
    t.index ["project_id", "status"], name: "index_prometheus_alert_events_on_project_id_and_status", using: :btree
    t.index ["prometheus_alert_id", "payload_key"], name: "index_prometheus_alert_event_scoped_payload_key", unique: true, using: :btree
2444 2445
  end

2446 2447 2448 2449 2450 2451 2452 2453
  create_table "prometheus_alerts", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.float "threshold", null: false
    t.integer "operator", null: false
    t.integer "environment_id", null: false
    t.integer "project_id", null: false
    t.integer "prometheus_metric_id", null: false
2454 2455 2456
    t.index ["environment_id"], name: "index_prometheus_alerts_on_environment_id", using: :btree
    t.index ["project_id", "prometheus_metric_id"], name: "index_prometheus_alerts_on_project_id_and_prometheus_metric_id", unique: true, using: :btree
    t.index ["prometheus_metric_id"], name: "index_prometheus_alerts_on_prometheus_metric_id", using: :btree
2457 2458
  end

2459
  create_table "prometheus_metrics", force: :cascade do |t|
2460
    t.integer "project_id"
2461 2462
    t.string "title", null: false
    t.string "query", null: false
2463 2464 2465
    t.string "y_label"
    t.string "unit"
    t.string "legend"
2466
    t.integer "group", null: false
2467 2468
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2469 2470
    t.boolean "common", default: false, null: false
    t.string "identifier"
2471 2472 2473 2474
    t.index ["common"], name: "index_prometheus_metrics_on_common", using: :btree
    t.index ["group"], name: "index_prometheus_metrics_on_group", using: :btree
    t.index ["identifier"], name: "index_prometheus_metrics_on_identifier", unique: true, using: :btree
    t.index ["project_id"], name: "index_prometheus_metrics_on_project_id", using: :btree
2475 2476
  end

2477
  create_table "protected_branch_merge_access_levels", force: :cascade do |t|
2478
    t.integer "protected_branch_id", null: false
2479
    t.integer "access_level", default: 40
2480 2481 2482
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "user_id"
2483
    t.integer "group_id"
Kamil Trzciński's avatar
Kamil Trzciński committed
2484
    t.index ["group_id"], name: "index_protected_branch_merge_access_levels_on_group_id", using: :btree
2485 2486
    t.index ["protected_branch_id"], name: "index_protected_branch_merge_access", using: :btree
    t.index ["user_id"], name: "index_protected_branch_merge_access_levels_on_user_id", using: :btree
2487 2488 2489
  end

  create_table "protected_branch_push_access_levels", force: :cascade do |t|
2490
    t.integer "protected_branch_id", null: false
2491
    t.integer "access_level", default: 40
2492 2493 2494
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "user_id"
2495
    t.integer "group_id"
Kamil Trzciński's avatar
Kamil Trzciński committed
2496
    t.index ["group_id"], name: "index_protected_branch_push_access_levels_on_group_id", using: :btree
2497 2498
    t.index ["protected_branch_id"], name: "index_protected_branch_push_access", using: :btree
    t.index ["user_id"], name: "index_protected_branch_push_access_levels_on_user_id", using: :btree
2499 2500
  end

2501 2502 2503 2504 2505
  create_table "protected_branch_unprotect_access_levels", force: :cascade do |t|
    t.integer "protected_branch_id", null: false
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
2506 2507 2508
    t.index ["group_id"], name: "index_protected_branch_unprotect_access_levels_on_group_id", using: :btree
    t.index ["protected_branch_id"], name: "index_protected_branch_unprotect_access", using: :btree
    t.index ["user_id"], name: "index_protected_branch_unprotect_access_levels_on_user_id", using: :btree
2509 2510
  end

Valery Sizov's avatar
Valery Sizov committed
2511
  create_table "protected_branches", force: :cascade do |t|
2512 2513
    t.integer "project_id", null: false
    t.string "name", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2514 2515
    t.datetime "created_at"
    t.datetime "updated_at"
2516
    t.index ["project_id"], name: "index_protected_branches_on_project_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2517 2518
  end

2519 2520 2521 2522 2523 2524 2525
  create_table "protected_environment_deploy_access_levels", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "access_level", default: 40
    t.integer "protected_environment_id", null: false
    t.integer "user_id"
    t.integer "group_id"
2526 2527 2528
    t.index ["group_id"], name: "index_protected_environment_deploy_access_levels_on_group_id", using: :btree
    t.index ["protected_environment_id"], name: "index_protected_environment_deploy_access", using: :btree
    t.index ["user_id"], name: "index_protected_environment_deploy_access_levels_on_user_id", using: :btree
2529 2530 2531 2532 2533 2534 2535
  end

  create_table "protected_environments", force: :cascade do |t|
    t.integer "project_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "name", null: false
2536 2537
    t.index ["project_id", "name"], name: "index_protected_environments_on_project_id_and_name", unique: true, using: :btree
    t.index ["project_id"], name: "index_protected_environments_on_project_id", using: :btree
2538 2539
  end

2540
  create_table "protected_tag_create_access_levels", force: :cascade do |t|
2541 2542 2543 2544 2545 2546
    t.integer "protected_tag_id", null: false
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzciński's avatar
Kamil Trzciński committed
2547
    t.index ["group_id"], name: "index_protected_tag_create_access_levels_on_group_id", using: :btree
2548 2549
    t.index ["protected_tag_id"], name: "index_protected_tag_create_access", using: :btree
    t.index ["user_id"], name: "index_protected_tag_create_access_levels_on_user_id", using: :btree
2550 2551 2552 2553 2554 2555 2556
  end

  create_table "protected_tags", force: :cascade do |t|
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2557 2558
    t.index ["project_id", "name"], name: "index_protected_tags_on_project_id_and_name", unique: true, using: :btree
    t.index ["project_id"], name: "index_protected_tags_on_project_id", using: :btree
2559 2560
  end

2561
  create_table "push_event_payloads", id: false, force: :cascade do |t|
2562
    t.bigint "commit_count", null: false
2563 2564 2565 2566 2567 2568 2569
    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
2570
    t.index ["event_id"], name: "index_push_event_payloads_on_event_id", unique: true, using: :btree
2571 2572
  end

2573
  create_table "push_rules", force: :cascade do |t|
2574 2575 2576 2577 2578
    t.string "force_push_regex"
    t.string "delete_branch_regex"
    t.string "commit_message_regex"
    t.boolean "deny_delete_tag"
    t.integer "project_id"
2579 2580
    t.datetime "created_at"
    t.datetime "updated_at"
2581 2582 2583 2584 2585 2586
    t.string "author_email_regex"
    t.boolean "member_check", default: false, null: false
    t.string "file_name_regex"
    t.boolean "is_sample", default: false
    t.integer "max_file_size", default: 0, null: false
    t.boolean "prevent_secrets", default: false, null: false
2587
    t.string "branch_name_regex"
2588
    t.boolean "reject_unsigned_commits"
2589
    t.boolean "commit_committer_check"
2590
    t.boolean "regexp_uses_re2", default: true
2591
    t.string "commit_message_negative_regex"
2592 2593
    t.index ["is_sample"], name: "index_push_rules_on_is_sample", where: "is_sample", using: :btree
    t.index ["project_id"], name: "index_push_rules_on_project_id", using: :btree
2594 2595
  end

2596 2597 2598 2599 2600 2601
  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
2602 2603
    t.index ["path"], name: "index_redirect_routes_on_path", unique: true, using: :btree
    t.index ["source_type", "source_id"], name: "index_redirect_routes_on_source_type_and_source_id", using: :btree
2604 2605
  end

2606 2607 2608 2609 2610 2611 2612 2613 2614 2615
  create_table "release_links", id: :bigserial, force: :cascade do |t|
    t.integer "release_id", null: false
    t.string "url", null: false
    t.string "name", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["release_id", "name"], name: "index_release_links_on_release_id_and_name", unique: true, using: :btree
    t.index ["release_id", "url"], name: "index_release_links_on_release_id_and_url", unique: true, using: :btree
  end

Valery Sizov's avatar
Valery Sizov committed
2616
  create_table "releases", force: :cascade do |t|
2617 2618 2619
    t.string "tag"
    t.text "description"
    t.integer "project_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
2620 2621
    t.datetime "created_at"
    t.datetime "updated_at"
2622
    t.text "description_html"
2623
    t.integer "cached_markdown_version"
2624 2625 2626 2627
    t.integer "author_id"
    t.string "name"
    t.string "sha"
    t.index ["author_id"], name: "index_releases_on_author_id", using: :btree
2628 2629
    t.index ["project_id", "tag"], name: "index_releases_on_project_id_and_tag", using: :btree
    t.index ["project_id"], name: "index_releases_on_project_id", using: :btree
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
2630 2631
  end

2632
  create_table "remote_mirrors", force: :cascade do |t|
2633 2634 2635 2636
    t.integer "project_id"
    t.string "url"
    t.boolean "enabled", default: false
    t.string "update_status"
2637 2638
    t.datetime "last_update_at"
    t.datetime "last_successful_update_at"
2639 2640 2641 2642 2643 2644
    t.string "last_error"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2645
    t.datetime "last_update_started_at"
2646
    t.boolean "only_protected_branches", default: false, null: false
2647
    t.string "remote_name"
2648
    t.boolean "error_notification_sent"
2649 2650
    t.index ["last_successful_update_at"], name: "index_remote_mirrors_on_last_successful_update_at", using: :btree
    t.index ["project_id"], name: "index_remote_mirrors_on_project_id", using: :btree
2651 2652
  end

2653 2654 2655 2656
  create_table "repository_languages", id: false, force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "programming_language_id", null: false
    t.float "share", null: false
2657
    t.index ["project_id", "programming_language_id"], name: "index_repository_languages_on_project_and_languages_id", unique: true, using: :btree
2658 2659
  end

2660 2661 2662 2663
  create_table "resource_label_events", id: :bigserial, force: :cascade do |t|
    t.integer "action", null: false
    t.integer "issue_id"
    t.integer "merge_request_id"
Jan Provaznik's avatar
Jan Provaznik committed
2664
    t.integer "epic_id"
2665 2666 2667
    t.integer "label_id"
    t.integer "user_id"
    t.datetime_with_timezone "created_at", null: false
2668 2669 2670
    t.integer "cached_markdown_version"
    t.text "reference"
    t.text "reference_html"
2671 2672 2673 2674 2675
    t.index ["epic_id"], name: "index_resource_label_events_on_epic_id", using: :btree
    t.index ["issue_id"], name: "index_resource_label_events_on_issue_id", using: :btree
    t.index ["label_id"], name: "index_resource_label_events_on_label_id", using: :btree
    t.index ["merge_request_id"], name: "index_resource_label_events_on_merge_request_id", using: :btree
    t.index ["user_id"], name: "index_resource_label_events_on_user_id", using: :btree
2676 2677
  end

2678 2679 2680 2681 2682 2683 2684 2685 2686 2687
  create_table "reviews", id: :bigserial, force: :cascade do |t|
    t.integer "author_id"
    t.integer "merge_request_id", null: false
    t.integer "project_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.index ["author_id"], name: "index_reviews_on_author_id", using: :btree
    t.index ["merge_request_id"], name: "index_reviews_on_merge_request_id", using: :btree
    t.index ["project_id"], name: "index_reviews_on_project_id", using: :btree
  end

2688 2689 2690 2691 2692 2693
  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"
2694
    t.string "name"
2695 2696 2697
    t.index ["path"], name: "index_routes_on_path", unique: true, using: :btree
    t.index ["path"], name: "index_routes_on_path_text_pattern_ops", using: :btree, opclasses: {"path"=>"varchar_pattern_ops"}
    t.index ["source_type", "source_id"], name: "index_routes_on_source_type_and_source_id", unique: true, using: :btree
2698 2699
  end

2700 2701 2702 2703 2704
  create_table "saml_providers", force: :cascade do |t|
    t.integer "group_id", null: false
    t.boolean "enabled", null: false
    t.string "certificate_fingerprint", null: false
    t.string "sso_url", null: false
2705
    t.boolean "enforced_sso", default: false, null: false
2706
    t.index ["group_id"], name: "index_saml_providers_on_group_id", using: :btree
2707 2708
  end

Valery Sizov's avatar
Valery Sizov committed
2709
  create_table "sent_notifications", force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
2710 2711
    t.integer "project_id"
    t.integer "noteable_id"
2712
    t.string "noteable_type"
Douwe Maan's avatar
Douwe Maan committed
2713
    t.integer "recipient_id"
2714 2715 2716 2717 2718
    t.string "commit_id"
    t.string "reply_key", null: false
    t.string "line_code"
    t.string "note_type"
    t.text "position"
2719
    t.string "in_reply_to_discussion_id"
2720
    t.index ["reply_key"], name: "index_sent_notifications_on_reply_key", unique: true, using: :btree
Douwe Maan's avatar
Douwe Maan committed
2721 2722
  end

Valery Sizov's avatar
Valery Sizov committed
2723
  create_table "services", force: :cascade do |t|
2724 2725 2726
    t.string "type"
    t.string "title"
    t.integer "project_id"
2727 2728
    t.datetime "created_at"
    t.datetime "updated_at"
2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741
    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
2742
    t.boolean "commit_events", default: true, null: false
2743
    t.boolean "job_events", default: false, null: false
2744
    t.boolean "confidential_note_events", default: true
2745 2746
    t.index ["project_id"], name: "index_services_on_project_id", using: :btree
    t.index ["template"], name: "index_services_on_template", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2747 2748
  end

2749 2750
  create_table "shards", force: :cascade do |t|
    t.string "name", null: false
2751
    t.index ["name"], name: "index_shards_on_name", unique: true, using: :btree
2752 2753
  end

Valery Sizov's avatar
Valery Sizov committed
2754 2755 2756 2757 2758 2759
  create_table "slack_integrations", force: :cascade do |t|
    t.integer "service_id", null: false
    t.string "team_id", null: false
    t.string "team_name", null: false
    t.string "alias", null: false
    t.string "user_id", null: false
2760 2761
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2762 2763
    t.index ["service_id"], name: "index_slack_integrations_on_service_id", using: :btree
    t.index ["team_id", "alias"], name: "index_slack_integrations_on_team_id_and_alias", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
2764 2765
  end

2766 2767 2768 2769 2770 2771 2772
  create_table "smartcard_identities", id: :bigserial, force: :cascade do |t|
    t.integer "user_id", null: false
    t.string "subject", null: false
    t.string "issuer", null: false
    t.index ["subject", "issuer"], name: "index_smartcard_identities_on_subject_and_issuer", unique: true, using: :btree
    t.index ["user_id"], name: "index_smartcard_identities_on_user_id", using: :btree
  end
2773

Valery Sizov's avatar
Valery Sizov committed
2774
  create_table "snippets", force: :cascade do |t|
2775 2776 2777 2778
    t.string "title"
    t.text "content"
    t.integer "author_id", null: false
    t.integer "project_id"
2779 2780
    t.datetime "created_at"
    t.datetime "updated_at"
2781 2782 2783 2784 2785
    t.string "file_name"
    t.string "type"
    t.integer "visibility_level", default: 0, null: false
    t.text "title_html"
    t.text "content_html"
2786
    t.integer "cached_markdown_version"
2787 2788
    t.text "description"
    t.text "description_html"
2789 2790 2791 2792 2793 2794
    t.index ["author_id"], name: "index_snippets_on_author_id", using: :btree
    t.index ["file_name"], name: "index_snippets_on_file_name_trigram", using: :gin, opclasses: {"file_name"=>"gin_trgm_ops"}
    t.index ["project_id"], name: "index_snippets_on_project_id", using: :btree
    t.index ["title"], name: "index_snippets_on_title_trigram", using: :gin, opclasses: {"title"=>"gin_trgm_ops"}
    t.index ["updated_at"], name: "index_snippets_on_updated_at", using: :btree
    t.index ["visibility_level"], name: "index_snippets_on_visibility_level", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2795 2796
  end

2797 2798 2799 2800
  create_table "software_license_policies", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "software_license_id", null: false
    t.integer "approval_status", default: 0, null: false
2801
    t.index ["project_id", "software_license_id"], name: "index_software_license_policies_unique_per_project", unique: true, using: :btree
Kamil Trzciński's avatar
Kamil Trzciński committed
2802
    t.index ["software_license_id"], name: "index_software_license_policies_on_software_license_id", using: :btree
2803 2804 2805 2806
  end

  create_table "software_licenses", force: :cascade do |t|
    t.string "name", null: false
2807
    t.index ["name"], name: "index_software_licenses_on_name", using: :btree
2808 2809
  end

2810
  create_table "spam_logs", force: :cascade do |t|
2811 2812 2813 2814 2815 2816 2817 2818 2819 2820
    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
2821
    t.boolean "recaptcha_verified", default: false, null: false
2822 2823
  end

Valery Sizov's avatar
Valery Sizov committed
2824
  create_table "subscriptions", force: :cascade do |t|
2825 2826 2827 2828
    t.integer "user_id"
    t.integer "subscribable_id"
    t.string "subscribable_type"
    t.boolean "subscribed"
Valery Sizov's avatar
Valery Sizov committed
2829 2830
    t.datetime "created_at"
    t.datetime "updated_at"
2831
    t.integer "project_id"
Kamil Trzciński's avatar
Kamil Trzciński committed
2832
    t.index ["project_id"], name: "index_subscriptions_on_project_id", using: :btree
2833
    t.index ["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
2834 2835
  end

2836 2837 2838 2839 2840 2841 2842 2843 2844 2845
  create_table "suggestions", id: :bigserial, force: :cascade do |t|
    t.integer "note_id", null: false
    t.integer "relative_order", limit: 2, null: false
    t.boolean "applied", default: false, null: false
    t.string "commit_id"
    t.text "from_content", null: false
    t.text "to_content", null: false
    t.index ["note_id", "relative_order"], name: "index_suggestions_on_note_id_and_relative_order", unique: true, using: :btree
  end

2846 2847 2848
  create_table "system_note_metadata", force: :cascade do |t|
    t.integer "note_id", null: false
    t.integer "commit_count"
2849
    t.string "action"
2850 2851
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2852
    t.index ["note_id"], name: "index_system_note_metadata_on_note_id", unique: true, using: :btree
2853 2854
  end

Valery Sizov's avatar
Valery Sizov committed
2855
  create_table "taggings", force: :cascade do |t|
2856 2857 2858 2859 2860 2861
    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
2862
    t.datetime "created_at"
2863 2864 2865 2866
    t.index ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true, using: :btree
    t.index ["tag_id"], name: "index_taggings_on_tag_id", using: :btree
    t.index ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree
    t.index ["taggable_id", "taggable_type"], name: "index_taggings_on_taggable_id_and_taggable_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2867 2868
  end

Valery Sizov's avatar
Valery Sizov committed
2869
  create_table "tags", force: :cascade do |t|
2870
    t.string "name"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2871
    t.integer "taggings_count", default: 0
2872
    t.index ["name"], name: "index_tags_on_name", unique: true, using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2873 2874
  end

2875 2876 2877 2878 2879 2880
  create_table "term_agreements", force: :cascade do |t|
    t.integer "term_id", null: false
    t.integer "user_id", null: false
    t.boolean "accepted", default: false, null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2881 2882 2883
    t.index ["term_id"], name: "index_term_agreements_on_term_id", using: :btree
    t.index ["user_id", "term_id"], name: "term_agreements_unique_index", unique: true, using: :btree
    t.index ["user_id"], name: "index_term_agreements_on_user_id", using: :btree
2884 2885
  end

2886 2887
  create_table "timelogs", force: :cascade do |t|
    t.integer "time_spent", null: false
2888
    t.integer "user_id"
2889 2890
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2891 2892
    t.integer "issue_id"
    t.integer "merge_request_id"
2893
    t.datetime "spent_at"
2894 2895 2896
    t.index ["issue_id"], name: "index_timelogs_on_issue_id", using: :btree
    t.index ["merge_request_id"], name: "index_timelogs_on_merge_request_id", using: :btree
    t.index ["user_id"], name: "index_timelogs_on_user_id", using: :btree
2897 2898
  end

2899
  create_table "todos", force: :cascade do |t|
2900
    t.integer "user_id", null: false
2901
    t.integer "project_id"
2902 2903
    t.integer "target_id"
    t.string "target_type", null: false
2904
    t.integer "author_id", null: false
2905 2906
    t.integer "action", null: false
    t.string "state", null: false
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
2907 2908
    t.datetime "created_at"
    t.datetime "updated_at"
2909 2910
    t.integer "note_id"
    t.string "commit_id"
2911
    t.integer "group_id"
2912 2913 2914 2915 2916 2917 2918 2919 2920
    t.index ["author_id"], name: "index_todos_on_author_id", using: :btree
    t.index ["commit_id"], name: "index_todos_on_commit_id", using: :btree
    t.index ["group_id"], name: "index_todos_on_group_id", using: :btree
    t.index ["note_id"], name: "index_todos_on_note_id", using: :btree
    t.index ["project_id"], name: "index_todos_on_project_id", using: :btree
    t.index ["target_type", "target_id"], name: "index_todos_on_target_type_and_target_id", using: :btree
    t.index ["user_id", "id"], name: "index_todos_on_user_id_and_id_done", where: "((state)::text = 'done'::text)", using: :btree
    t.index ["user_id", "id"], name: "index_todos_on_user_id_and_id_pending", where: "((state)::text = 'pending'::text)", using: :btree
    t.index ["user_id"], name: "index_todos_on_user_id", using: :btree
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
2921 2922
  end

2923 2924
  create_table "trending_projects", force: :cascade do |t|
    t.integer "project_id", null: false
2925
    t.index ["project_id"], name: "index_trending_projects_on_project_id", unique: true, using: :btree
2926 2927
  end

2928
  create_table "u2f_registrations", force: :cascade do |t|
2929 2930 2931 2932 2933 2934 2935 2936
    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"
2937 2938
    t.index ["key_handle"], name: "index_u2f_registrations_on_key_handle", using: :btree
    t.index ["user_id"], name: "index_u2f_registrations_on_user_id", using: :btree
2939 2940
  end

2941
  create_table "uploads", force: :cascade do |t|
2942
    t.bigint "size", null: false
2943
    t.string "path", limit: 511, null: false
2944 2945 2946 2947 2948
    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
2949
    t.integer "store"
Micaël Bergeron's avatar
Micaël Bergeron committed
2950 2951
    t.string "mount_point"
    t.string "secret"
2952 2953 2954 2955
    t.index ["checksum"], name: "index_uploads_on_checksum", using: :btree
    t.index ["model_id", "model_type"], name: "index_uploads_on_model_id_and_model_type", using: :btree
    t.index ["store"], name: "index_uploads_on_store", using: :btree
    t.index ["uploader", "path"], name: "index_uploads_on_uploader_and_path", using: :btree
2956 2957
  end

2958
  create_table "user_agent_details", force: :cascade do |t|
2959 2960 2961 2962 2963 2964 2965
    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
2966
    t.index ["subject_id", "subject_type"], name: "index_user_agent_details_on_subject_id_and_subject_type", using: :btree
2967 2968
  end

2969
  create_table "user_callouts", force: :cascade do |t|
2970
    t.integer "feature_name", null: false
2971
    t.integer "user_id", null: false
2972 2973
    t.index ["user_id", "feature_name"], name: "index_user_callouts_on_user_id_and_feature_name", unique: true, using: :btree
    t.index ["user_id"], name: "index_user_callouts_on_user_id", using: :btree
2974 2975
  end

2976
  create_table "user_custom_attributes", force: :cascade do |t|
2977 2978
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2979 2980 2981
    t.integer "user_id", null: false
    t.string "key", null: false
    t.string "value", null: false
2982 2983
    t.index ["key", "value"], name: "index_user_custom_attributes_on_key_and_value", using: :btree
    t.index ["user_id", "key"], name: "index_user_custom_attributes_on_user_id_and_key", unique: true, using: :btree
2984 2985
  end

2986 2987 2988
  create_table "user_interacted_projects", id: false, force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "project_id", null: false
2989 2990
    t.index ["project_id", "user_id"], name: "index_user_interacted_projects_on_project_id_and_user_id", unique: true, using: :btree
    t.index ["user_id"], name: "index_user_interacted_projects_on_user_id", using: :btree
2991 2992
  end

2993 2994 2995 2996 2997 2998
  create_table "user_preferences", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "issue_notes_filter", limit: 2, default: 0, null: false
    t.integer "merge_request_notes_filter", limit: 2, default: 0, null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
Felipe Artur's avatar
Felipe Artur committed
2999
    t.string "epics_sort"
3000
    t.integer "roadmap_epics_state"
Felipe Artur's avatar
Felipe Artur committed
3001
    t.integer "epic_notes_filter", limit: 2, default: 0, null: false
3002 3003
    t.string "issues_sort"
    t.string "merge_requests_sort"
3004
    t.string "roadmaps_sort"
3005
    t.index ["user_id"], name: "index_user_preferences_on_user_id", unique: true, using: :btree
3006 3007
  end

3008 3009 3010 3011 3012
  create_table "user_statuses", primary_key: "user_id", force: :cascade do |t|
    t.integer "cached_markdown_version"
    t.string "emoji", default: "speech_balloon", null: false
    t.string "message", limit: 100
    t.string "message_html"
Kamil Trzciński's avatar
Kamil Trzciński committed
3013
    t.index ["user_id"], name: "index_user_statuses_on_user_id", using: :btree
3014 3015
  end

3016 3017 3018 3019 3020 3021
  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"
3022
    t.index ["user_id"], name: "index_user_synced_attributes_metadata_on_user_id", unique: true, using: :btree
3023 3024
  end

Valery Sizov's avatar
Valery Sizov committed
3025
  create_table "users", force: :cascade do |t|
3026 3027 3028
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
Andrew8xx8's avatar
Andrew8xx8 committed
3029 3030
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
3031
    t.integer "sign_in_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
3032 3033
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
3034 3035
    t.string "current_sign_in_ip"
    t.string "last_sign_in_ip"
3036 3037
    t.datetime "created_at"
    t.datetime "updated_at"
3038 3039
    t.string "name"
    t.boolean "admin", default: false, null: false
3040
    t.integer "projects_limit", null: false
3041 3042 3043 3044 3045
    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
3046
    t.datetime "locked_at"
3047 3048 3049 3050 3051
    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
3052
    t.datetime "password_expires_at"
3053
    t.integer "created_by_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
3054
    t.datetime "last_credential_check_at"
3055 3056
    t.string "avatar"
    t.string "confirmation_token"
3057 3058
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
3059 3060 3061
    t.string "unconfirmed_email"
    t.boolean "hide_no_ssh_key", default: false
    t.string "website_url", default: "", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
3062
    t.datetime "admin_email_unsubscribed_at"
3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079
    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.text "note"
    t.string "unlock_token"
3080
    t.datetime "otp_grace_period_started_at"
3081
    t.boolean "external", default: false
Nick Thomas's avatar
Nick Thomas committed
3082
    t.string "incoming_email_token"
3083
    t.string "organization"
3084
    t.boolean "auditor", default: false, null: false
3085 3086
    t.boolean "require_two_factor_authentication_from_group", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
3087
    t.boolean "ghost"
3088
    t.date "last_activity_on"
3089
    t.boolean "notified_of_own_activity"
3090
    t.boolean "support_bot"
3091
    t.string "preferred_language"
3092 3093
    t.boolean "email_opted_in"
    t.string "email_opted_in_ip"
3094
    t.integer "email_opted_in_source_id"
3095
    t.datetime "email_opted_in_at"
3096
    t.integer "theme_id", limit: 2
3097
    t.integer "accepted_term_id"
Micaël Bergeron's avatar
Micaël Bergeron committed
3098
    t.string "feed_token"
3099
    t.boolean "private_profile"
Mark Chao's avatar
Mark Chao committed
3100
    t.integer "roadmap_layout", limit: 2
3101
    t.boolean "include_private_contributions"
3102
    t.string "commit_email"
Kamil Trzciński's avatar
Kamil Trzciński committed
3103
    t.index ["accepted_term_id"], name: "index_users_on_accepted_term_id", using: :btree
3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119
    t.index ["admin"], name: "index_users_on_admin", using: :btree
    t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true, using: :btree
    t.index ["created_at"], name: "index_users_on_created_at", using: :btree
    t.index ["email"], name: "index_users_on_email", unique: true, using: :btree
    t.index ["email"], name: "index_users_on_email_trigram", using: :gin, opclasses: {"email"=>"gin_trgm_ops"}
    t.index ["feed_token"], name: "index_users_on_feed_token", using: :btree
    t.index ["ghost"], name: "index_users_on_ghost", using: :btree
    t.index ["incoming_email_token"], name: "index_users_on_incoming_email_token", using: :btree
    t.index ["name"], name: "index_users_on_name", using: :btree
    t.index ["name"], name: "index_users_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
    t.index ["state"], name: "index_users_on_state", using: :btree
    t.index ["state"], name: "index_users_on_state_and_internal_attrs", where: "((ghost <> true) AND (support_bot <> true))", using: :btree
    t.index ["support_bot"], name: "index_users_on_support_bot", using: :btree
    t.index ["username"], name: "index_users_on_username", using: :btree
    t.index ["username"], name: "index_users_on_username_trigram", using: :gin, opclasses: {"username"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
3120 3121
  end

3122 3123 3124 3125 3126
  create_table "users_ops_dashboard_projects", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "user_id", null: false
    t.integer "project_id", null: false
3127 3128
    t.index ["project_id"], name: "index_users_ops_dashboard_projects_on_project_id", using: :btree
    t.index ["user_id", "project_id"], name: "index_users_ops_dashboard_projects_on_user_id_and_project_id", unique: true, using: :btree
3129 3130
  end

Valery Sizov's avatar
Valery Sizov committed
3131
  create_table "users_star_projects", force: :cascade do |t|
3132 3133
    t.integer "project_id", null: false
    t.integer "user_id", null: false
Ciro Santilli's avatar
Ciro Santilli committed
3134 3135
    t.datetime "created_at"
    t.datetime "updated_at"
3136 3137
    t.index ["project_id"], name: "index_users_star_projects_on_project_id", using: :btree
    t.index ["user_id", "project_id"], name: "index_users_star_projects_on_user_id_and_project_id", unique: true, using: :btree
Ciro Santilli's avatar
Ciro Santilli committed
3138 3139
  end

3140 3141 3142 3143 3144 3145 3146 3147 3148 3149
  create_table "vulnerability_feedback", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "feedback_type", limit: 2, null: false
    t.integer "category", limit: 2, null: false
    t.integer "project_id", null: false
    t.integer "author_id", null: false
    t.integer "pipeline_id"
    t.integer "issue_id"
    t.string "project_fingerprint", limit: 40, null: false
3150 3151 3152 3153
    t.index ["author_id"], name: "index_vulnerability_feedback_on_author_id", using: :btree
    t.index ["issue_id"], name: "index_vulnerability_feedback_on_issue_id", using: :btree
    t.index ["pipeline_id"], name: "index_vulnerability_feedback_on_pipeline_id", using: :btree
    t.index ["project_id", "category", "feedback_type", "project_fingerprint"], name: "vulnerability_feedback_unique_idx", unique: true, using: :btree
3154 3155
  end

3156 3157 3158 3159 3160 3161 3162 3163 3164
  create_table "vulnerability_identifiers", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id", null: false
    t.binary "fingerprint", null: false
    t.string "external_type", null: false
    t.string "external_id", null: false
    t.string "name", null: false
    t.text "url"
3165
    t.index ["project_id", "fingerprint"], name: "index_vulnerability_identifiers_on_project_id_and_fingerprint", unique: true, using: :btree
3166 3167 3168 3169 3170
  end

  create_table "vulnerability_occurrence_identifiers", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
3171 3172 3173 3174
    t.bigint "occurrence_id", null: false
    t.bigint "identifier_id", null: false
    t.index ["identifier_id"], name: "index_vulnerability_occurrence_identifiers_on_identifier_id", using: :btree
    t.index ["occurrence_id", "identifier_id"], name: "index_vulnerability_occurrence_identifiers_on_unique_keys", unique: true, using: :btree
3175 3176
  end

3177 3178 3179
  create_table "vulnerability_occurrence_pipelines", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
3180
    t.bigint "occurrence_id", null: false
3181
    t.integer "pipeline_id", null: false
3182 3183
    t.index ["occurrence_id", "pipeline_id"], name: "vulnerability_occurrence_pipelines_on_unique_keys", unique: true, using: :btree
    t.index ["pipeline_id"], name: "index_vulnerability_occurrence_pipelines_on_pipeline_id", using: :btree
3184 3185
  end

3186 3187 3188 3189 3190 3191 3192
  create_table "vulnerability_occurrences", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "severity", limit: 2, null: false
    t.integer "confidence", limit: 2, null: false
    t.integer "report_type", limit: 2, null: false
    t.integer "project_id", null: false
3193 3194
    t.bigint "scanner_id", null: false
    t.bigint "primary_identifier_id", null: false
3195 3196
    t.binary "project_fingerprint", null: false
    t.binary "location_fingerprint", null: false
3197
    t.string "uuid", limit: 36, null: false
3198 3199 3200
    t.string "name", null: false
    t.string "metadata_version", null: false
    t.text "raw_metadata", null: false
3201 3202 3203 3204
    t.index ["primary_identifier_id"], name: "index_vulnerability_occurrences_on_primary_identifier_id", using: :btree
    t.index ["project_id", "primary_identifier_id", "location_fingerprint", "scanner_id"], name: "index_vulnerability_occurrences_on_unique_keys", unique: true, using: :btree
    t.index ["scanner_id"], name: "index_vulnerability_occurrences_on_scanner_id", using: :btree
    t.index ["uuid"], name: "index_vulnerability_occurrences_on_uuid", unique: true, using: :btree
3205 3206 3207 3208 3209 3210 3211 3212
  end

  create_table "vulnerability_scanners", id: :bigserial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id", null: false
    t.string "external_id", null: false
    t.string "name", null: false
3213
    t.index ["project_id", "external_id"], name: "index_vulnerability_scanners_on_project_id_and_external_id", unique: true, using: :btree
3214 3215
  end

3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228
  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
3229 3230
    t.index ["created_at", "web_hook_id"], name: "index_web_hook_logs_on_created_at_and_web_hook_id", using: :btree
    t.index ["web_hook_id"], name: "index_web_hook_logs_on_web_hook_id", using: :btree
3231 3232
  end

Valery Sizov's avatar
Valery Sizov committed
3233
  create_table "web_hooks", force: :cascade do |t|
3234
    t.integer "project_id"
3235 3236
    t.datetime "created_at"
    t.datetime "updated_at"
3237 3238 3239 3240 3241 3242 3243 3244 3245
    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.integer "group_id"
    t.boolean "note_events", default: false, null: false
    t.boolean "enable_ssl_verification", default: true
3246
    t.boolean "wiki_page_events", default: false, null: false
3247 3248
    t.boolean "pipeline_events", default: false, null: false
    t.boolean "confidential_issues_events", default: false, null: false
3249
    t.boolean "repository_update_events", default: false, null: false
Luke "Jared" Bennett's avatar
Luke "Jared" Bennett committed
3250
    t.boolean "job_events", default: false, null: false
3251
    t.boolean "confidential_note_events"
3252
    t.text "push_events_branch_filter"
3253 3254 3255 3256
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
    t.string "encrypted_url"
    t.string "encrypted_url_iv"
3257 3258
    t.index ["project_id"], name: "index_web_hooks_on_project_id", using: :btree
    t.index ["type"], name: "index_web_hooks_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
3259 3260
  end

3261
  add_foreign_key "application_settings", "namespaces", column: "custom_project_templates_group_id", on_delete: :nullify
3262
  add_foreign_key "application_settings", "projects", column: "file_template_project_id", name: "fk_ec757bd087", on_delete: :nullify
3263
  add_foreign_key "application_settings", "users", column: "usage_stats_set_by_user_id", name: "fk_964370041d", on_delete: :nullify
3264 3265
  add_foreign_key "approval_merge_request_rule_sources", "approval_merge_request_rules", on_delete: :cascade
  add_foreign_key "approval_merge_request_rule_sources", "approval_project_rules", on_delete: :cascade
3266
  add_foreign_key "approval_merge_request_rules", "merge_requests", on_delete: :cascade
3267 3268
  add_foreign_key "approval_merge_request_rules_approved_approvers", "approval_merge_request_rules", on_delete: :cascade
  add_foreign_key "approval_merge_request_rules_approved_approvers", "users", on_delete: :cascade
3269 3270 3271 3272 3273 3274 3275 3276 3277
  add_foreign_key "approval_merge_request_rules_groups", "approval_merge_request_rules", on_delete: :cascade
  add_foreign_key "approval_merge_request_rules_groups", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "approval_merge_request_rules_users", "approval_merge_request_rules", on_delete: :cascade
  add_foreign_key "approval_merge_request_rules_users", "users", on_delete: :cascade
  add_foreign_key "approval_project_rules", "projects", on_delete: :cascade
  add_foreign_key "approval_project_rules_groups", "approval_project_rules", on_delete: :cascade
  add_foreign_key "approval_project_rules_groups", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "approval_project_rules_users", "approval_project_rules", on_delete: :cascade
  add_foreign_key "approval_project_rules_users", "users", on_delete: :cascade
3278
  add_foreign_key "approvals", "merge_requests", name: "fk_310d714958", on_delete: :cascade
Valery Sizov's avatar
Valery Sizov committed
3279
  add_foreign_key "approver_groups", "namespaces", column: "group_id", on_delete: :cascade
3280 3281
  add_foreign_key "badges", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "badges", "projects", on_delete: :cascade
3282 3283
  add_foreign_key "board_assignees", "boards", on_delete: :cascade
  add_foreign_key "board_assignees", "users", column: "assignee_id", on_delete: :cascade
3284 3285 3286
  add_foreign_key "board_group_recent_visits", "boards", on_delete: :cascade
  add_foreign_key "board_group_recent_visits", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "board_group_recent_visits", "users", on_delete: :cascade
3287 3288
  add_foreign_key "board_labels", "boards", on_delete: :cascade
  add_foreign_key "board_labels", "labels", on_delete: :cascade
3289 3290 3291
  add_foreign_key "board_project_recent_visits", "boards", on_delete: :cascade
  add_foreign_key "board_project_recent_visits", "projects", on_delete: :cascade
  add_foreign_key "board_project_recent_visits", "users", on_delete: :cascade
Felipe Artur's avatar
Felipe Artur committed
3292
  add_foreign_key "boards", "namespaces", column: "group_id", name: "fk_1e9a074a35", on_delete: :cascade
3293
  add_foreign_key "boards", "projects", name: "fk_f15266b5f9", on_delete: :cascade
3294
  add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
3295
  add_foreign_key "ci_build_trace_chunks", "ci_builds", column: "build_id", on_delete: :cascade
3296 3297 3298 3299
  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
3300
  add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
3301
  add_foreign_key "ci_builds", "ci_pipelines", column: "commit_id", name: "fk_d3130c9a7f", on_delete: :cascade
3302
  add_foreign_key "ci_builds", "ci_stages", column: "stage_id", name: "fk_3a9eaa254d", on_delete: :cascade
3303
  add_foreign_key "ci_builds", "projects", name: "fk_befce0568a", on_delete: :cascade
3304 3305
  add_foreign_key "ci_builds_metadata", "ci_builds", column: "build_id", on_delete: :cascade
  add_foreign_key "ci_builds_metadata", "projects", on_delete: :cascade
3306
  add_foreign_key "ci_builds_runner_session", "ci_builds", column: "build_id", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
3307
  add_foreign_key "ci_group_variables", "namespaces", column: "group_id", name: "fk_33ae4d58d8", on_delete: :cascade
3308 3309
  add_foreign_key "ci_job_artifacts", "ci_builds", column: "job_id", on_delete: :cascade
  add_foreign_key "ci_job_artifacts", "projects", on_delete: :cascade
3310 3311
  add_foreign_key "ci_pipeline_chat_data", "chat_names", on_delete: :cascade
  add_foreign_key "ci_pipeline_chat_data", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
Shinya Maeda's avatar
fix  
Shinya Maeda committed
3312
  add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade
3313
  add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade
3314
  add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify
3315
  add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade
Kamil Trzcinski's avatar
Kamil Trzcinski committed
3316 3317
  add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify
  add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify
Shinya Maeda's avatar
Shinya Maeda committed
3318
  add_foreign_key "ci_pipelines", "merge_requests", name: "fk_a23be95014", on_delete: :cascade
3319
  add_foreign_key "ci_pipelines", "projects", name: "fk_86635dbd80", on_delete: :cascade
3320
  add_foreign_key "ci_runner_namespaces", "ci_runners", column: "runner_id", on_delete: :cascade
3321
  add_foreign_key "ci_runner_namespaces", "namespaces", on_delete: :cascade
3322
  add_foreign_key "ci_runner_projects", "projects", name: "fk_4478a6f1e4", on_delete: :cascade
3323 3324 3325 3326 3327
  add_foreign_key "ci_sources_pipelines", "ci_builds", column: "source_job_id", name: "fk_be5624bf37", on_delete: :cascade
  add_foreign_key "ci_sources_pipelines", "ci_pipelines", column: "pipeline_id", name: "fk_e1bad85861", on_delete: :cascade
  add_foreign_key "ci_sources_pipelines", "ci_pipelines", column: "source_pipeline_id", name: "fk_d4e29af7d7", on_delete: :cascade
  add_foreign_key "ci_sources_pipelines", "projects", column: "source_project_id", name: "fk_acd9737679", on_delete: :cascade
  add_foreign_key "ci_sources_pipelines", "projects", name: "fk_1e53c97c0a", on_delete: :cascade
3328
  add_foreign_key "ci_stages", "ci_pipelines", column: "pipeline_id", name: "fk_fb57e6cc56", on_delete: :cascade
3329
  add_foreign_key "ci_stages", "projects", name: "fk_2360681d1d", on_delete: :cascade
3330
  add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
3331
  add_foreign_key "ci_triggers", "projects", name: "fk_e3e63f966e", on_delete: :cascade
3332
  add_foreign_key "ci_triggers", "users", column: "owner_id", name: "fk_e8e10d1964", on_delete: :cascade
3333
  add_foreign_key "ci_variables", "projects", name: "fk_ada5eb64b3", on_delete: :cascade
3334 3335
  add_foreign_key "cluster_groups", "clusters", on_delete: :cascade
  add_foreign_key "cluster_groups", "namespaces", column: "group_id", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
3336 3337 3338 3339 3340
  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
Amit Rathi's avatar
Amit Rathi committed
3341
  add_foreign_key "clusters_applications_cert_managers", "clusters", on_delete: :cascade
3342
  add_foreign_key "clusters_applications_helm", "clusters", on_delete: :cascade
3343
  add_foreign_key "clusters_applications_ingress", "clusters", on_delete: :cascade
Micaël Bergeron's avatar
Micaël Bergeron committed
3344 3345
  add_foreign_key "clusters_applications_jupyter", "clusters", on_delete: :cascade
  add_foreign_key "clusters_applications_jupyter", "oauth_applications", on_delete: :nullify
Chris Baumbauer's avatar
Chris Baumbauer committed
3346
  add_foreign_key "clusters_applications_knative", "clusters", on_delete: :cascade
3347
  add_foreign_key "clusters_applications_prometheus", "clusters", name: "fk_557e773639", on_delete: :cascade
3348 3349
  add_foreign_key "clusters_applications_runners", "ci_runners", column: "runner_id", name: "fk_02de2ded36", on_delete: :nullify
  add_foreign_key "clusters_applications_runners", "clusters", on_delete: :cascade
3350 3351 3352
  add_foreign_key "clusters_kubernetes_namespaces", "cluster_projects", on_delete: :nullify
  add_foreign_key "clusters_kubernetes_namespaces", "clusters", on_delete: :cascade
  add_foreign_key "clusters_kubernetes_namespaces", "projects", on_delete: :nullify
Valery Sizov's avatar
Valery Sizov committed
3353
  add_foreign_key "container_repositories", "projects"
3354 3355
  add_foreign_key "deploy_keys_projects", "projects", name: "fk_58a901ca7e", on_delete: :cascade
  add_foreign_key "deployments", "projects", name: "fk_b9a3851b82", on_delete: :cascade
3356 3357
  add_foreign_key "draft_notes", "merge_requests", on_delete: :cascade
  add_foreign_key "draft_notes", "users", column: "author_id", on_delete: :cascade
3358
  add_foreign_key "environments", "projects", name: "fk_d1c8c1da6a", on_delete: :cascade
3359 3360
  add_foreign_key "epic_issues", "epics", on_delete: :cascade
  add_foreign_key "epic_issues", "issues", on_delete: :cascade
Clement Ho's avatar
Clement Ho committed
3361
  add_foreign_key "epic_metrics", "epics", on_delete: :cascade
Jarka Košanová's avatar
Jarka Košanová committed
3362
  add_foreign_key "epics", "epics", column: "parent_id", name: "fk_25b99c1be3", on_delete: :cascade
Clement Ho's avatar
Clement Ho committed
3363 3364 3365 3366
  add_foreign_key "epics", "milestones", on_delete: :nullify
  add_foreign_key "epics", "namespaces", column: "group_id", name: "fk_f081aa4489", on_delete: :cascade
  add_foreign_key "epics", "users", column: "assignee_id", name: "fk_dccd3f98fc", on_delete: :nullify
  add_foreign_key "epics", "users", column: "author_id", name: "fk_3654b61b03", on_delete: :cascade
3367
  add_foreign_key "epics", "users", column: "closed_by_id", name: "fk_aa5798e761", on_delete: :nullify
3368 3369
  add_foreign_key "events", "projects", on_delete: :cascade
  add_foreign_key "events", "users", column: "author_id", name: "fk_edfd187b6f", on_delete: :cascade
3370 3371 3372
  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
3373
  add_foreign_key "fork_networks", "projects", column: "root_project_id", name: "fk_e7b436b2b5", on_delete: :nullify
3374
  add_foreign_key "forked_project_links", "projects", column: "forked_to_project_id", name: "fk_434510edb0", on_delete: :cascade
3375
  add_foreign_key "geo_event_log", "geo_cache_invalidation_events", column: "cache_invalidation_event_id", name: "fk_42c3b54bed", on_delete: :cascade
3376
  add_foreign_key "geo_event_log", "geo_hashed_storage_migrated_events", column: "hashed_storage_migrated_event_id", name: "fk_27548c6db3", on_delete: :cascade
3377
  add_foreign_key "geo_event_log", "geo_job_artifact_deleted_events", column: "job_artifact_deleted_event_id", name: "fk_176d3fbb5d", on_delete: :cascade
3378
  add_foreign_key "geo_event_log", "geo_lfs_object_deleted_events", column: "lfs_object_deleted_event_id", name: "fk_d5af95fcd9", on_delete: :cascade
3379
  add_foreign_key "geo_event_log", "geo_repositories_changed_events", column: "repositories_changed_event_id", name: "fk_4a99ebfd60", on_delete: :cascade
3380
  add_foreign_key "geo_event_log", "geo_repository_created_events", column: "repository_created_event_id", name: "fk_9b9afb1916", on_delete: :cascade
Stan Hu's avatar
Stan Hu committed
3381
  add_foreign_key "geo_event_log", "geo_repository_deleted_events", column: "repository_deleted_event_id", name: "fk_c4b1c1f66e", on_delete: :cascade
3382
  add_foreign_key "geo_event_log", "geo_repository_renamed_events", column: "repository_renamed_event_id", name: "fk_86c84214ec", on_delete: :cascade
3383
  add_foreign_key "geo_event_log", "geo_repository_updated_events", column: "repository_updated_event_id", name: "fk_78a6492f68", on_delete: :cascade
3384
  add_foreign_key "geo_event_log", "geo_reset_checksum_events", column: "reset_checksum_event_id", name: "fk_cff7185ad2", on_delete: :cascade
3385
  add_foreign_key "geo_event_log", "geo_upload_deleted_events", column: "upload_deleted_event_id", name: "fk_c1f241c70d", on_delete: :cascade
3386
  add_foreign_key "geo_hashed_storage_attachments_events", "projects", on_delete: :cascade
3387
  add_foreign_key "geo_hashed_storage_migrated_events", "projects", on_delete: :cascade
3388
  add_foreign_key "geo_node_namespace_links", "geo_nodes", on_delete: :cascade
3389
  add_foreign_key "geo_node_namespace_links", "namespaces", on_delete: :cascade
3390
  add_foreign_key "geo_node_statuses", "geo_nodes", on_delete: :cascade
3391
  add_foreign_key "geo_repositories_changed_events", "geo_nodes", on_delete: :cascade
3392
  add_foreign_key "geo_repository_created_events", "projects", on_delete: :cascade
3393
  add_foreign_key "geo_repository_renamed_events", "projects", on_delete: :cascade
3394
  add_foreign_key "geo_repository_updated_events", "projects", on_delete: :cascade
3395
  add_foreign_key "geo_reset_checksum_events", "projects", on_delete: :cascade
3396
  add_foreign_key "gitlab_subscriptions", "namespaces", name: "fk_e2595d00a1", on_delete: :cascade
3397
  add_foreign_key "gitlab_subscriptions", "plans", column: "hosted_plan_id", name: "fk_bd0c4019c3", on_delete: :cascade
3398
  add_foreign_key "gpg_key_subkeys", "gpg_keys", on_delete: :cascade
3399
  add_foreign_key "gpg_keys", "users", on_delete: :cascade
3400
  add_foreign_key "gpg_signatures", "gpg_key_subkeys", on_delete: :nullify
3401 3402
  add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify
  add_foreign_key "gpg_signatures", "projects", on_delete: :cascade
3403
  add_foreign_key "group_custom_attributes", "namespaces", column: "group_id", on_delete: :cascade
3404
  add_foreign_key "identities", "saml_providers", name: "fk_aade90f0fc", on_delete: :cascade
3405
  add_foreign_key "import_export_uploads", "projects", on_delete: :cascade
3406
  add_foreign_key "index_statuses", "projects", name: "fk_74b2492545", on_delete: :cascade
3407
  add_foreign_key "internal_ids", "namespaces", name: "fk_162941d509", on_delete: :cascade
3408
  add_foreign_key "internal_ids", "projects", on_delete: :cascade
3409 3410
  add_foreign_key "issue_assignees", "issues", name: "fk_b7d881734a", on_delete: :cascade
  add_foreign_key "issue_assignees", "users", name: "fk_5e0c8d9154", on_delete: :cascade
3411 3412
  add_foreign_key "issue_links", "issues", column: "source_id", name: "fk_c900194ff2", on_delete: :cascade
  add_foreign_key "issue_links", "issues", column: "target_id", name: "fk_e71bb44f1f", on_delete: :cascade
3413
  add_foreign_key "issue_metrics", "issues", on_delete: :cascade
3414 3415
  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
3416
  add_foreign_key "issues", "projects", name: "fk_899c8f3231", on_delete: :cascade
3417
  add_foreign_key "issues", "users", column: "author_id", name: "fk_05f1e72feb", on_delete: :nullify
haseeb's avatar
haseeb committed
3418
  add_foreign_key "issues", "users", column: "closed_by_id", name: "fk_c63cbf6c25", on_delete: :nullify
3419
  add_foreign_key "issues", "users", column: "updated_by_id", name: "fk_ffed080f01", on_delete: :nullify
Stan Hu's avatar
Stan Hu committed
3420
  add_foreign_key "label_links", "labels", name: "fk_d97dd08678", on_delete: :cascade
3421 3422
  add_foreign_key "label_priorities", "labels", on_delete: :cascade
  add_foreign_key "label_priorities", "projects", on_delete: :cascade
3423
  add_foreign_key "labels", "namespaces", column: "group_id", on_delete: :cascade
3424
  add_foreign_key "labels", "projects", name: "fk_7de4989a69", on_delete: :cascade
3425 3426
  add_foreign_key "lfs_file_locks", "projects", on_delete: :cascade
  add_foreign_key "lfs_file_locks", "users", on_delete: :cascade
3427 3428
  add_foreign_key "lists", "boards", name: "fk_0d3f677137", on_delete: :cascade
  add_foreign_key "lists", "labels", name: "fk_7a5553d60f", on_delete: :cascade
3429
  add_foreign_key "lists", "milestones", on_delete: :cascade
3430
  add_foreign_key "lists", "users", name: "fk_d6cf4279f7", on_delete: :cascade
3431
  add_foreign_key "members", "users", name: "fk_2e88fb7ce9", on_delete: :cascade
3432
  add_foreign_key "merge_request_diff_commits", "merge_request_diffs", on_delete: :cascade
3433
  add_foreign_key "merge_request_diff_files", "merge_request_diffs", on_delete: :cascade
3434
  add_foreign_key "merge_request_diffs", "merge_requests", name: "fk_8483f3258f", on_delete: :cascade
3435
  add_foreign_key "merge_request_metrics", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
3436
  add_foreign_key "merge_request_metrics", "merge_requests", on_delete: :cascade
3437 3438
  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
3439
  add_foreign_key "merge_requests", "ci_pipelines", column: "head_pipeline_id", name: "fk_fd82eae0b9", on_delete: :nullify
3440
  add_foreign_key "merge_requests", "merge_request_diffs", column: "latest_merge_request_diff_id", name: "fk_06067f5644", on_delete: :nullify
3441 3442
  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
3443
  add_foreign_key "merge_requests", "projects", column: "target_project_id", name: "fk_a6963e8447", on_delete: :cascade
3444 3445 3446 3447
  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
3448 3449
  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
3450
  add_foreign_key "milestones", "namespaces", column: "group_id", name: "fk_95650a40d4", on_delete: :cascade
3451
  add_foreign_key "milestones", "projects", name: "fk_9bd0a0c791", on_delete: :cascade
3452
  add_foreign_key "namespace_statistics", "namespaces", on_delete: :cascade
3453
  add_foreign_key "namespaces", "namespaces", column: "custom_project_templates_group_id", name: "fk_e7a0b20a6b", on_delete: :nullify
3454
  add_foreign_key "namespaces", "plans", name: "fk_fdd12e5b80", on_delete: :nullify
Nick Thomas's avatar
Nick Thomas committed
3455
  add_foreign_key "namespaces", "projects", column: "file_template_project_id", name: "fk_319256d87a", on_delete: :nullify
3456
  add_foreign_key "note_diff_files", "notes", column: "diff_note_id", on_delete: :cascade
3457
  add_foreign_key "notes", "projects", name: "fk_99e097b079", on_delete: :cascade
3458
  add_foreign_key "notes", "reviews", name: "fk_2e82291620", on_delete: :nullify
3459
  add_foreign_key "notification_settings", "users", name: "fk_0c95e91db7", on_delete: :cascade
Nick Thomas's avatar
Nick Thomas committed
3460
  add_foreign_key "oauth_openid_requests", "oauth_access_grants", column: "access_grant_id", name: "fk_oauth_openid_requests_oauth_access_grants_access_grant_id"
3461
  add_foreign_key "operations_feature_flag_scopes", "operations_feature_flags", column: "feature_flag_id", on_delete: :cascade
3462
  add_foreign_key "operations_feature_flags", "projects", on_delete: :cascade
3463
  add_foreign_key "operations_feature_flags_clients", "projects", on_delete: :cascade
3464 3465
  add_foreign_key "packages_maven_metadata", "packages_packages", column: "package_id", name: "fk_be88aed360", on_delete: :cascade
  add_foreign_key "packages_package_files", "packages_packages", column: "package_id", name: "fk_86f0f182f8", on_delete: :cascade
3466
  add_foreign_key "packages_packages", "projects", on_delete: :cascade
3467
  add_foreign_key "pages_domains", "projects", name: "fk_ea2f6dfc6f", on_delete: :cascade
3468
  add_foreign_key "path_locks", "projects", name: "fk_5265c98f24", on_delete: :cascade
Valery Sizov's avatar
Valery Sizov committed
3469
  add_foreign_key "path_locks", "users"
3470
  add_foreign_key "personal_access_tokens", "users"
3471
  add_foreign_key "pool_repositories", "projects", column: "source_project_id", on_delete: :nullify
3472
  add_foreign_key "pool_repositories", "shards", on_delete: :restrict
3473
  add_foreign_key "project_alerting_settings", "projects", on_delete: :cascade
3474 3475
  add_foreign_key "project_authorizations", "projects", on_delete: :cascade
  add_foreign_key "project_authorizations", "users", on_delete: :cascade
3476
  add_foreign_key "project_auto_devops", "projects", on_delete: :cascade
3477
  add_foreign_key "project_ci_cd_settings", "projects", name: "fk_24c15d2f2e", on_delete: :cascade
3478
  add_foreign_key "project_custom_attributes", "projects", on_delete: :cascade
3479 3480
  add_foreign_key "project_deploy_tokens", "deploy_tokens", on_delete: :cascade
  add_foreign_key "project_deploy_tokens", "projects", on_delete: :cascade
3481
  add_foreign_key "project_error_tracking_settings", "projects", on_delete: :cascade
3482
  add_foreign_key "project_feature_usages", "projects", on_delete: :cascade
3483 3484 3485
  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
3486
  add_foreign_key "project_mirror_data", "projects", name: "fk_d1aad367d7", on_delete: :cascade
3487
  add_foreign_key "project_repositories", "projects", on_delete: :cascade
3488
  add_foreign_key "project_repositories", "shards", on_delete: :restrict
3489
  add_foreign_key "project_repository_states", "projects", on_delete: :cascade
3490
  add_foreign_key "project_statistics", "projects", on_delete: :cascade
Simon Knox's avatar
Simon Knox committed
3491
  add_foreign_key "project_tracing_settings", "projects", on_delete: :cascade
3492
  add_foreign_key "projects", "pool_repositories", name: "fk_6e5c14658a", on_delete: :nullify
3493 3494
  add_foreign_key "prometheus_alert_events", "projects", on_delete: :cascade
  add_foreign_key "prometheus_alert_events", "prometheus_alerts", on_delete: :cascade
3495 3496 3497
  add_foreign_key "prometheus_alerts", "environments", on_delete: :cascade
  add_foreign_key "prometheus_alerts", "projects", on_delete: :cascade
  add_foreign_key "prometheus_alerts", "prometheus_metrics", on_delete: :cascade
3498
  add_foreign_key "prometheus_metrics", "projects", on_delete: :cascade
3499
  add_foreign_key "protected_branch_merge_access_levels", "namespaces", column: "group_id", name: "fk_98f3d044fe", on_delete: :cascade
3500
  add_foreign_key "protected_branch_merge_access_levels", "protected_branches", name: "fk_8a3072ccb3", on_delete: :cascade
3501
  add_foreign_key "protected_branch_merge_access_levels", "users"
3502
  add_foreign_key "protected_branch_push_access_levels", "namespaces", column: "group_id", name: "fk_7111b68cdb", on_delete: :cascade
3503
  add_foreign_key "protected_branch_push_access_levels", "protected_branches", name: "fk_9ffc86a3d9", on_delete: :cascade
3504
  add_foreign_key "protected_branch_push_access_levels", "users"
3505 3506 3507
  add_foreign_key "protected_branch_unprotect_access_levels", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "protected_branch_unprotect_access_levels", "protected_branches", on_delete: :cascade
  add_foreign_key "protected_branch_unprotect_access_levels", "users", on_delete: :cascade
3508
  add_foreign_key "protected_branches", "projects", name: "fk_7a9c6d93e7", on_delete: :cascade
3509 3510 3511 3512
  add_foreign_key "protected_environment_deploy_access_levels", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "protected_environment_deploy_access_levels", "protected_environments", on_delete: :cascade
  add_foreign_key "protected_environment_deploy_access_levels", "users", on_delete: :cascade
  add_foreign_key "protected_environments", "projects", on_delete: :cascade
3513
  add_foreign_key "protected_tag_create_access_levels", "namespaces", column: "group_id", name: "fk_b4eb82fe3c", on_delete: :cascade
3514
  add_foreign_key "protected_tag_create_access_levels", "protected_tags", name: "fk_f7dfda8c51", on_delete: :cascade
3515
  add_foreign_key "protected_tag_create_access_levels", "users"
3516
  add_foreign_key "protected_tags", "projects", name: "fk_8e4af87648", on_delete: :cascade
3517
  add_foreign_key "push_event_payloads", "events", name: "fk_36c74129da", on_delete: :cascade
Rémy Coutable's avatar
Rémy Coutable committed
3518
  add_foreign_key "push_rules", "projects", name: "fk_83b29894de", on_delete: :cascade
3519
  add_foreign_key "release_links", "releases", on_delete: :cascade
3520
  add_foreign_key "releases", "projects", name: "fk_47fe2a0596", on_delete: :cascade
Yorick Peterse's avatar
Yorick Peterse committed
3521
  add_foreign_key "releases", "users", column: "author_id", name: "fk_8e4456f90f", on_delete: :nullify
3522
  add_foreign_key "remote_mirrors", "projects", name: "fk_43a9aa4ca8", on_delete: :cascade
3523
  add_foreign_key "repository_languages", "projects", on_delete: :cascade
Jan Provaznik's avatar
Jan Provaznik committed
3524
  add_foreign_key "resource_label_events", "epics", on_delete: :cascade
3525 3526 3527 3528
  add_foreign_key "resource_label_events", "issues", on_delete: :cascade
  add_foreign_key "resource_label_events", "labels", on_delete: :nullify
  add_foreign_key "resource_label_events", "merge_requests", on_delete: :cascade
  add_foreign_key "resource_label_events", "users", on_delete: :nullify
3529 3530 3531
  add_foreign_key "reviews", "merge_requests", on_delete: :cascade
  add_foreign_key "reviews", "projects", on_delete: :cascade
  add_foreign_key "reviews", "users", column: "author_id", on_delete: :nullify
3532
  add_foreign_key "saml_providers", "namespaces", column: "group_id", on_delete: :cascade
3533
  add_foreign_key "services", "projects", name: "fk_71cce407f9", on_delete: :cascade
Valery Sizov's avatar
Valery Sizov committed
3534
  add_foreign_key "slack_integrations", "services", on_delete: :cascade
3535
  add_foreign_key "smartcard_identities", "users", on_delete: :cascade
3536
  add_foreign_key "snippets", "projects", name: "fk_be41fd4bb7", on_delete: :cascade
3537 3538
  add_foreign_key "software_license_policies", "projects", on_delete: :cascade
  add_foreign_key "software_license_policies", "software_licenses", on_delete: :cascade
3539
  add_foreign_key "subscriptions", "projects", on_delete: :cascade
3540
  add_foreign_key "suggestions", "notes", on_delete: :cascade
3541
  add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade
3542 3543
  add_foreign_key "term_agreements", "application_setting_terms", column: "term_id"
  add_foreign_key "term_agreements", "users", on_delete: :cascade
3544 3545
  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
3546
  add_foreign_key "todos", "namespaces", column: "group_id", on_delete: :cascade
3547
  add_foreign_key "todos", "notes", name: "fk_91d1f47b13", on_delete: :cascade
3548
  add_foreign_key "todos", "projects", name: "fk_45054f9c45", on_delete: :cascade
3549 3550
  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
3551
  add_foreign_key "trending_projects", "projects", on_delete: :cascade
3552
  add_foreign_key "u2f_registrations", "users"
3553
  add_foreign_key "user_callouts", "users", on_delete: :cascade
3554
  add_foreign_key "user_custom_attributes", "users", on_delete: :cascade
3555 3556
  add_foreign_key "user_interacted_projects", "projects", name: "fk_722ceba4f7", on_delete: :cascade
  add_foreign_key "user_interacted_projects", "users", name: "fk_0894651f08", on_delete: :cascade
3557
  add_foreign_key "user_preferences", "users", on_delete: :cascade
3558
  add_foreign_key "user_statuses", "users", on_delete: :cascade
3559
  add_foreign_key "user_synced_attributes_metadata", "users", on_delete: :cascade
3560
  add_foreign_key "users", "application_setting_terms", column: "accepted_term_id", name: "fk_789cd90b35", on_delete: :cascade
3561 3562
  add_foreign_key "users_ops_dashboard_projects", "projects", on_delete: :cascade
  add_foreign_key "users_ops_dashboard_projects", "users", on_delete: :cascade
3563
  add_foreign_key "users_star_projects", "projects", name: "fk_22cd27ddfc", on_delete: :cascade
3564 3565 3566 3567
  add_foreign_key "vulnerability_feedback", "ci_pipelines", column: "pipeline_id", on_delete: :nullify
  add_foreign_key "vulnerability_feedback", "issues", on_delete: :nullify
  add_foreign_key "vulnerability_feedback", "projects", on_delete: :cascade
  add_foreign_key "vulnerability_feedback", "users", column: "author_id", on_delete: :cascade
3568 3569 3570
  add_foreign_key "vulnerability_identifiers", "projects", on_delete: :cascade
  add_foreign_key "vulnerability_occurrence_identifiers", "vulnerability_identifiers", column: "identifier_id", on_delete: :cascade
  add_foreign_key "vulnerability_occurrence_identifiers", "vulnerability_occurrences", column: "occurrence_id", on_delete: :cascade
3571 3572
  add_foreign_key "vulnerability_occurrence_pipelines", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
  add_foreign_key "vulnerability_occurrence_pipelines", "vulnerability_occurrences", column: "occurrence_id", on_delete: :cascade
3573
  add_foreign_key "vulnerability_occurrences", "projects", on_delete: :cascade
3574
  add_foreign_key "vulnerability_occurrences", "vulnerability_identifiers", column: "primary_identifier_id", on_delete: :cascade
3575 3576
  add_foreign_key "vulnerability_occurrences", "vulnerability_scanners", column: "scanner_id", on_delete: :cascade
  add_foreign_key "vulnerability_scanners", "projects", on_delete: :cascade
3577
  add_foreign_key "web_hook_logs", "web_hooks", on_delete: :cascade
3578
  add_foreign_key "web_hooks", "projects", name: "fk_0c8ca6d9d1", on_delete: :cascade
3579
end