schema.rb 205 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

Heinrich Lee Yu's avatar
Heinrich Lee Yu committed
13
ActiveRecord::Schema.define(version: 2019_07_03_130053) do
14

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

Jasper Maes's avatar
Jasper Maes committed
19
  create_table "abuse_reports", id: :serial, 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

Jasper Maes's avatar
Jasper Maes committed
29
  create_table "appearances", id: :serial, force: :cascade do |t|
30 31
    t.string "title", null: false
    t.text "description", null: false
32 33
    t.string "header_logo"
    t.string "logo"
34 35
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
36
    t.text "description_html"
37
    t.integer "cached_markdown_version"
38 39
    t.text "new_project_guidelines"
    t.text "new_project_guidelines_html"
40 41 42 43 44 45
    t.text "header_message"
    t.text "header_message_html"
    t.text "footer_message"
    t.text "footer_message_html"
    t.text "message_background_color"
    t.text "message_font_color"
46
    t.string "favicon"
47
    t.boolean "email_header_and_footer_enabled", default: false, null: false
48
    t.integer "updated_by"
49 50
  end

Jasper Maes's avatar
Jasper Maes committed
51
  create_table "application_setting_terms", id: :serial, force: :cascade do |t|
52 53 54 55 56
    t.integer "cached_markdown_version"
    t.text "terms", null: false
    t.text "terms_html"
  end

Jasper Maes's avatar
Jasper Maes committed
57
  create_table "application_settings", id: :serial, force: :cascade do |t|
58 59 60 61
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
62 63
    t.datetime "created_at"
    t.datetime "updated_at"
64 65
    t.string "home_page_url"
    t.integer "default_branch_protection", default: 2
66
    t.text "help_text"
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
    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"
82
    t.integer "max_pages_size", default: 100, null: false
83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106
    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 "email_author_in_body", default: false
    t.integer "default_group_visibility"
    t.boolean "repository_checks_enabled", default: false
    t.text "shared_runners_text"
    t.integer "metrics_packet_size", default: 1
    t.text "disabled_oauth_sign_in_sources"
    t.string "health_check_access_token"
    t.boolean "send_user_confirmation_email", default: false
    t.integer "container_registry_token_expire_delay", default: 5
    t.text "after_sign_up_text"
Valery Sizov's avatar
Valery Sizov committed
107
    t.boolean "user_default_external", default: false, null: false
108 109
    t.boolean "elasticsearch_indexing", default: false, null: false
    t.boolean "elasticsearch_search", default: false, null: false
110
    t.string "repository_storages", default: "default"
111 112 113
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
114
    t.boolean "usage_ping_enabled", default: true, null: false
115 116 117 118
    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"
119
    t.integer "rsa_key_restriction", default: 0, null: false
120
    t.integer "dsa_key_restriction", default: -1, null: false
121 122
    t.integer "ecdsa_key_restriction", default: 0, null: false
    t.integer "ed25519_key_restriction", default: 0, null: false
123 124 125 126 127
    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
128
    t.boolean "html_emails_enabled", default: true
129 130
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
131 132
    t.integer "shared_runners_minutes", default: 0, null: false
    t.bigint "repository_size_limit", default: 0
133
    t.integer "terminal_max_session_time", default: 0, null: false
134 135 136
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
137
    t.string "default_artifacts_expire_in", default: "0", null: false
138 139 140 141 142 143
    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"
    t.integer "geo_status_timeout", default: 10
144
    t.string "uuid"
145
    t.decimal "polling_interval_multiplier", default: "1.0", null: false
146
    t.boolean "elasticsearch_experimental_indexer"
147
    t.integer "cached_markdown_version"
148 149 150 151
    t.boolean "check_namespace_plan", default: false, null: false
    t.integer "mirror_max_delay", default: 300, null: false
    t.integer "mirror_max_capacity", default: 100, null: false
    t.integer "mirror_capacity_threshold", default: 50, null: false
152
    t.boolean "prometheus_metrics_enabled", default: true, null: false
153
    t.boolean "authorized_keys_enabled", default: true, null: false
154 155
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
156 157 158 159
    t.boolean "slack_app_enabled", default: false
    t.string "slack_app_id"
    t.string "slack_app_secret"
    t.string "slack_app_verification_token"
160
    t.integer "performance_bar_allowed_group_id"
161
    t.boolean "allow_group_owners_to_manage_ldap", default: true, null: false
162
    t.boolean "hashed_storage_enabled", default: true, null: false
163
    t.boolean "project_export_enabled", default: true, null: false
164
    t.boolean "auto_devops_enabled", default: true, null: false
165 166 167 168 169 170 171 172 173
    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
174 175 176
    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
177 178 179
    t.boolean "mirror_available", default: true, null: false
    t.boolean "password_authentication_enabled_for_web"
    t.boolean "password_authentication_enabled_for_git", default: true, null: false
180
    t.string "auto_devops_domain"
181 182 183
    t.boolean "external_authorization_service_enabled", default: false, null: false
    t.string "external_authorization_service_url"
    t.string "external_authorization_service_default_label"
184
    t.boolean "pages_domain_verification_enabled", default: true, null: false
185
    t.string "user_default_internal_regex"
186
    t.boolean "allow_local_requests_from_hooks_and_services", default: false, null: false
187 188 189 190 191 192 193
    t.float "external_authorization_service_timeout", default: 0.5
    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"
    t.string "email_additional_text"
194
    t.boolean "enforce_terms", default: false
195 196
    t.integer "file_template_project_id"
    t.boolean "pseudonymizer_enabled", default: false, null: false
197
    t.boolean "hide_third_party_offers", default: false, null: false
198 199 200 201
    t.boolean "snowplow_enabled", default: false, null: false
    t.string "snowplow_collector_uri"
    t.string "snowplow_site_id"
    t.string "snowplow_cookie_domain"
202
    t.boolean "instance_statistics_visibility_private", default: false, null: false
Phil Hughes's avatar
Phil Hughes committed
203
    t.boolean "web_ide_clientside_preview_enabled", default: false, null: false
204
    t.boolean "user_show_add_ssh_key_message", default: true, null: false
205
    t.integer "custom_project_templates_group_id"
206
    t.integer "usage_stats_set_by_user_id"
207
    t.integer "receive_max_input_size"
208
    t.integer "diff_max_patch_bytes", default: 102400, null: false
209
    t.integer "archive_builds_in_seconds"
210
    t.string "commit_email_hostname"
211
    t.boolean "protected_ci_variables", default: false, null: false
212
    t.string "runners_registration_token_encrypted"
Jan Provaznik's avatar
Jan Provaznik committed
213
    t.integer "local_markdown_version", default: 0, null: false
214
    t.integer "first_day_of_week", default: 0, null: false
215
    t.boolean "elasticsearch_limit_indexing", default: false, null: false
Gosia Ksionek's avatar
Gosia Ksionek committed
216
    t.integer "default_project_creation", default: 2, null: false
217 218
    t.string "lets_encrypt_notification_email"
    t.boolean "lets_encrypt_terms_of_service_accepted", default: false, null: false
219
    t.string "geo_node_allowed_ips", default: "0.0.0.0/0, ::/0"
220 221
    t.integer "elasticsearch_shards", default: 5, null: false
    t.integer "elasticsearch_replicas", default: 1, null: false
222 223
    t.text "encrypted_lets_encrypt_private_key"
    t.text "encrypted_lets_encrypt_private_key_iv"
Matija Čupić's avatar
Matija Čupić committed
224
    t.string "required_instance_ci_template"
225
    t.boolean "dns_rebinding_protection_enabled", default: true, null: false
Małgorzata Ksionek's avatar
Małgorzata Ksionek committed
226
    t.boolean "default_project_deletion_protection", default: false, null: false
227
    t.boolean "grafana_enabled", default: false, null: false
228
    t.boolean "lock_memberships_to_ldap", default: false, null: false
229
    t.boolean "time_tracking_limit_to_hours", default: false, null: false
230
    t.string "grafana_url", default: "/-/grafana", null: false
231 232
    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
233
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id", using: :btree
234 235
  end

236 237 238 239 240 241 242 243 244 245 246 247 248 249 250
  create_table "approval_merge_request_rule_sources", 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

  create_table "approval_merge_request_rules", 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
    t.integer "rule_type", limit: 2, default: 1, null: false
251
    t.integer "report_type", limit: 2
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 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330
    t.index ["merge_request_id", "code_owner", "name"], name: "approval_rule_name_index_for_code_owners", unique: true, where: "(code_owner = true)", using: :btree
    t.index ["merge_request_id", "code_owner"], name: "index_approval_merge_request_rules_1", using: :btree
    t.index ["merge_request_id", "rule_type", "name"], name: "index_approval_rule_name_for_code_owners_rule_type", unique: true, where: "(rule_type = 2)", using: :btree
    t.index ["merge_request_id", "rule_type"], name: "index_approval_rules_code_owners_rule_type", where: "(rule_type = 2)", using: :btree
  end

  create_table "approval_merge_request_rules_approved_approvers", 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_approved_approvers_1", unique: true, using: :btree
    t.index ["user_id"], name: "index_approval_merge_request_rules_approved_approvers_2", using: :btree
  end

  create_table "approval_merge_request_rules_groups", 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", 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", 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", 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", 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

  create_table "approvals", id: :serial, force: :cascade do |t|
    t.integer "merge_request_id", null: false
    t.integer "user_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["merge_request_id"], name: "index_approvals_on_merge_request_id", using: :btree
    t.index ["user_id", "merge_request_id"], name: "index_approvals_on_user_id_and_merge_request_id", unique: true, using: :btree
  end

  create_table "approver_groups", id: :serial, force: :cascade do |t|
    t.integer "target_id", null: false
    t.string "target_type", null: false
    t.integer "group_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    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
  end

  create_table "approvers", id: :serial, force: :cascade do |t|
    t.integer "target_id", null: false
    t.string "target_type"
    t.integer "user_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    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
  end

Jasper Maes's avatar
Jasper Maes committed
331
  create_table "audit_events", id: :serial, force: :cascade do |t|
332 333 334 335 336
    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"
337 338
    t.datetime "created_at"
    t.datetime "updated_at"
339
    t.index ["created_at", "author_id"], name: "analytics_index_audit_events_on_created_at_and_author_id", using: :btree
340
    t.index ["entity_id", "entity_type"], name: "index_audit_events_on_entity_id_and_entity_type", using: :btree
341 342
  end

Jasper Maes's avatar
Jasper Maes committed
343
  create_table "award_emoji", id: :serial, force: :cascade do |t|
344 345 346 347
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
348 349
    t.datetime "created_at"
    t.datetime "updated_at"
350 351
    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
352 353
  end

Jasper Maes's avatar
Jasper Maes committed
354
  create_table "badges", id: :serial, force: :cascade do |t|
355 356 357 358 359 360 361
    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
362 363
    t.index ["group_id"], name: "index_badges_on_group_id", using: :btree
    t.index ["project_id"], name: "index_badges_on_project_id", using: :btree
364 365
  end

366 367 368 369 370 371 372
  create_table "board_assignees", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
    t.index ["assignee_id"], name: "index_board_assignees_on_assignee_id", using: :btree
    t.index ["board_id", "assignee_id"], name: "index_board_assignees_on_board_id_and_assignee_id", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
373
  create_table "board_group_recent_visits", force: :cascade do |t|
374 375 376 377 378
    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"
379 380 381 382
    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
383 384
  end

385 386 387 388 389 390 391
  create_table "board_labels", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "label_id", null: false
    t.index ["board_id", "label_id"], name: "index_board_labels_on_board_id_and_label_id", unique: true, using: :btree
    t.index ["label_id"], name: "index_board_labels_on_label_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
392
  create_table "board_project_recent_visits", force: :cascade do |t|
393 394 395 396 397
    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"
398 399 400 401
    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
402 403
  end

Jasper Maes's avatar
Jasper Maes committed
404
  create_table "boards", id: :serial, force: :cascade do |t|
Felipe Artur's avatar
Felipe Artur committed
405
    t.integer "project_id"
406 407
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
408
    t.string "name", default: "Development", null: false
409
    t.integer "milestone_id"
410
    t.integer "group_id"
411
    t.integer "weight"
412
    t.index ["group_id"], name: "index_boards_on_group_id", using: :btree
413
    t.index ["milestone_id"], name: "index_boards_on_milestone_id", using: :btree
414
    t.index ["project_id"], name: "index_boards_on_project_id", using: :btree
415 416
  end

Jasper Maes's avatar
Jasper Maes committed
417
  create_table "broadcast_messages", id: :serial, force: :cascade do |t|
418
    t.text "message", null: false
419 420 421 422
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
423 424
    t.string "color"
    t.string "font"
425
    t.text "message_html", null: false
426
    t.integer "cached_markdown_version"
427
    t.index ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id", using: :btree
428
  end
429

Jasper Maes's avatar
Jasper Maes committed
430
  create_table "chat_names", id: :serial, force: :cascade do |t|
431 432
    t.integer "user_id", null: false
    t.integer "service_id", null: false
433
    t.string "team_id", null: false
434
    t.string "team_domain"
435
    t.string "chat_id", null: false
436
    t.string "chat_name"
437
    t.datetime "last_used_at"
438 439
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
440 441
    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
442
  end
443

Jasper Maes's avatar
Jasper Maes committed
444
  create_table "chat_teams", id: :serial, force: :cascade do |t|
445
    t.integer "namespace_id", null: false
446 447 448 449
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
450
    t.index ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true, using: :btree
451 452
  end

Jasper Maes's avatar
Jasper Maes committed
453
  create_table "ci_build_trace_chunks", force: :cascade do |t|
454 455 456 457
    t.integer "build_id", null: false
    t.integer "chunk_index", null: false
    t.integer "data_store", null: false
    t.binary "raw_data"
458
    t.index ["build_id", "chunk_index"], name: "index_ci_build_trace_chunks_on_build_id_and_chunk_index", unique: true, using: :btree
459 460
  end

Jasper Maes's avatar
Jasper Maes committed
461
  create_table "ci_build_trace_section_names", id: :serial, force: :cascade do |t|
462 463
    t.integer "project_id", null: false
    t.string "name", null: false
464
    t.index ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true, using: :btree
465 466
  end

Jasper Maes's avatar
Jasper Maes committed
467
  create_table "ci_build_trace_sections", id: :serial, force: :cascade do |t|
468
    t.integer "project_id", null: false
469 470
    t.datetime_with_timezone "date_start", null: false
    t.datetime_with_timezone "date_end", null: false
471 472
    t.bigint "byte_start", null: false
    t.bigint "byte_end", null: false
473 474
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
475 476 477
    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
478 479
  end

Jasper Maes's avatar
Jasper Maes committed
480
  create_table "ci_builds", id: :serial, force: :cascade do |t|
481
    t.string "status"
482
    t.datetime "finished_at"
483
    t.text "trace"
484 485 486
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503
    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"
504
    t.integer "project_id"
505 506
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
507
    t.datetime "erased_at"
508
    t.datetime "artifacts_expire_at"
509
    t.string "environment"
510
    t.bigint "artifacts_size"
511 512
    t.string "when"
    t.text "yaml_variables"
513
    t.datetime "queued_at"
514
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
515
    t.integer "lock_version"
516
    t.string "coverage_regex"
517
    t.integer "auto_canceled_by_id"
518
    t.boolean "retried"
519
    t.integer "stage_id"
520 521
    t.integer "artifacts_file_store"
    t.integer "artifacts_metadata_store"
522
    t.boolean "protected"
523
    t.integer "failure_reason"
524
    t.datetime_with_timezone "scheduled_at"
525
    t.string "token_encrypted"
526
    t.integer "upstream_pipeline_id"
527 528
    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
529
    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
530 531 532 533
    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
534
    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
535
    t.index ["project_id", "id"], name: "index_ci_builds_on_project_id_and_id", using: :btree
536
    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
537
    t.index ["protected"], name: "index_ci_builds_on_protected", using: :btree
538
    t.index ["queued_at"], name: "index_ci_builds_on_queued_at", using: :btree
539 540 541 542 543 544
    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
545
    t.index ["token_encrypted"], name: "index_ci_builds_on_token_encrypted", unique: true, where: "(token_encrypted IS NOT NULL)", using: :btree
546
    t.index ["updated_at"], name: "index_ci_builds_on_updated_at", using: :btree
547
    t.index ["upstream_pipeline_id"], name: "index_ci_builds_on_upstream_pipeline_id", where: "(upstream_pipeline_id IS NOT NULL)", using: :btree
548
    t.index ["user_id"], name: "index_ci_builds_on_user_id", using: :btree
549 550
  end

Jasper Maes's avatar
Jasper Maes committed
551
  create_table "ci_builds_metadata", id: :serial, force: :cascade do |t|
552
    t.integer "build_id", null: false
553
    t.integer "project_id", null: false
554
    t.integer "timeout"
555
    t.integer "timeout_source", default: 1, null: false
556 557
    t.jsonb "config_options"
    t.jsonb "config_variables"
558 559
    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
560 561
  end

Jasper Maes's avatar
Jasper Maes committed
562
  create_table "ci_builds_runner_session", force: :cascade do |t|
563 564 565 566
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
567
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true, using: :btree
568 569
  end

Jasper Maes's avatar
Jasper Maes committed
570
  create_table "ci_group_variables", id: :serial, force: :cascade do |t|
571 572 573 574 575
    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
576 577
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
578 579
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
580
    t.boolean "masked", default: false, null: false
581
    t.integer "variable_type", limit: 2, default: 1, null: false
582
    t.index ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true, using: :btree
583 584
  end

Jasper Maes's avatar
Jasper Maes committed
585
  create_table "ci_job_artifacts", id: :serial, force: :cascade do |t|
586
    t.integer "project_id", null: false
587
    t.integer "job_id", null: false
588
    t.integer "file_type", null: false
589
    t.integer "file_store"
590
    t.bigint "size"
591 592
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
593
    t.datetime_with_timezone "expire_at"
594
    t.string "file"
595
    t.binary "file_sha256"
596
    t.integer "file_format", limit: 2
597
    t.integer "file_location", limit: 2
598 599 600 601
    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
602 603
  end

Jasper Maes's avatar
Jasper Maes committed
604
  create_table "ci_pipeline_chat_data", force: :cascade do |t|
605 606 607 608 609 610 611
    t.integer "pipeline_id", null: false
    t.integer "chat_name_id", null: false
    t.text "response_url", null: false
    t.index ["chat_name_id"], name: "index_ci_pipeline_chat_data_on_chat_name_id", using: :btree
    t.index ["pipeline_id"], name: "index_ci_pipeline_chat_data_on_pipeline_id", unique: true, using: :btree
  end

Shinya Maeda's avatar
fix  
Shinya Maeda committed
612
  create_table "ci_pipeline_schedule_variables", force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
613 614 615 616 617
    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
618
    t.integer "pipeline_schedule_id", null: false
619 620
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
621
    t.integer "variable_type", limit: 2, default: 1, null: false
622
    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
623 624
  end

Jasper Maes's avatar
Jasper Maes committed
625
  create_table "ci_pipeline_schedules", id: :serial, force: :cascade do |t|
626 627 628 629 630 631 632 633
    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
634 635
    t.datetime "created_at"
    t.datetime "updated_at"
636
    t.index ["next_run_at", "active"], name: "index_ci_pipeline_schedules_on_next_run_at_and_active", using: :btree
637
    t.index ["owner_id"], name: "index_ci_pipeline_schedules_on_owner_id", using: :btree
638
    t.index ["project_id"], name: "index_ci_pipeline_schedules_on_project_id", using: :btree
639 640
  end

Jasper Maes's avatar
Jasper Maes committed
641
  create_table "ci_pipeline_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
init  
Shinya Maeda committed
642 643 644 645 646 647
    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
648
    t.integer "variable_type", limit: 2, default: 1, null: false
649
    t.index ["pipeline_id", "key"], name: "index_ci_pipeline_variables_on_pipeline_id_and_key", unique: true, using: :btree
Shinya Maeda's avatar
init  
Shinya Maeda committed
650 651
  end

Jasper Maes's avatar
Jasper Maes committed
652
  create_table "ci_pipelines", id: :serial, force: :cascade do |t|
653 654 655
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
656 657
    t.datetime "created_at"
    t.datetime "updated_at"
658 659
    t.boolean "tag", default: false
    t.text "yaml_errors"
660
    t.datetime "committed_at"
661
    t.integer "project_id"
662
    t.string "status"
663 664
    t.datetime "started_at"
    t.datetime "finished_at"
665 666
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
667
    t.integer "lock_version"
668
    t.integer "auto_canceled_by_id"
669
    t.integer "pipeline_schedule_id"
670
    t.integer "source"
671
    t.integer "config_source"
672
    t.boolean "protected"
673
    t.integer "failure_reason"
Shinya Maeda's avatar
Shinya Maeda committed
674
    t.integer "iid"
Shinya Maeda's avatar
Shinya Maeda committed
675
    t.integer "merge_request_id"
676 677
    t.binary "source_sha"
    t.binary "target_sha"
678
    t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id", using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
679
    t.index ["merge_request_id"], name: "index_ci_pipelines_on_merge_request_id", where: "(merge_request_id IS NOT NULL)", using: :btree
680 681
    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
682
    t.index ["project_id", "ref", "id"], name: "index_ci_pipelines_on_project_idandrefandiddesc", order: { id: :desc }, using: :btree
683 684 685 686 687 688 689
    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
690 691
  end

Jasper Maes's avatar
Jasper Maes committed
692
  create_table "ci_runner_namespaces", id: :serial, force: :cascade do |t|
693
    t.integer "runner_id"
694
    t.integer "namespace_id"
695 696
    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
697 698
  end

Jasper Maes's avatar
Jasper Maes committed
699
  create_table "ci_runner_projects", id: :serial, force: :cascade do |t|
700
    t.integer "runner_id", null: false
701 702
    t.datetime "created_at"
    t.datetime "updated_at"
703
    t.integer "project_id"
704 705
    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
706 707
  end

Jasper Maes's avatar
Jasper Maes committed
708
  create_table "ci_runners", id: :serial, force: :cascade do |t|
709
    t.string "token"
710 711
    t.datetime "created_at"
    t.datetime "updated_at"
712
    t.string "description"
713
    t.datetime "contacted_at"
714 715 716 717 718 719 720 721 722
    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
723
    t.integer "access_level", default: 0, null: false
724
    t.string "ip_address"
725
    t.integer "maximum_timeout"
726
    t.integer "runner_type", limit: 2, null: false
727
    t.string "token_encrypted"
728 729 730 731 732
    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
733
    t.index ["token_encrypted"], name: "index_ci_runners_on_token_encrypted", using: :btree
734 735
  end

736 737 738 739 740 741 742 743 744 745 746 747 748
  create_table "ci_sources_pipelines", id: :serial, 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"
    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
  end

Jasper Maes's avatar
Jasper Maes committed
749
  create_table "ci_stages", id: :serial, force: :cascade do |t|
750 751
    t.integer "project_id"
    t.integer "pipeline_id"
752 753
    t.datetime "created_at"
    t.datetime "updated_at"
754
    t.string "name"
755
    t.integer "status"
756
    t.integer "lock_version"
757
    t.integer "position"
758 759 760 761
    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
762 763
  end

Jasper Maes's avatar
Jasper Maes committed
764
  create_table "ci_trigger_requests", id: :serial, force: :cascade do |t|
765 766
    t.integer "trigger_id", null: false
    t.text "variables"
767 768
    t.datetime "created_at"
    t.datetime "updated_at"
769
    t.integer "commit_id"
770
    t.index ["commit_id"], name: "index_ci_trigger_requests_on_commit_id", using: :btree
771
    t.index ["trigger_id"], name: "index_ci_trigger_requests_on_trigger_id", using: :btree
772 773
  end

Jasper Maes's avatar
Jasper Maes committed
774
  create_table "ci_triggers", id: :serial, force: :cascade do |t|
775
    t.string "token"
776 777
    t.datetime "created_at"
    t.datetime "updated_at"
778
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
779 780
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
781
    t.string "ref"
782
    t.index ["owner_id"], name: "index_ci_triggers_on_owner_id", using: :btree
783
    t.index ["project_id"], name: "index_ci_triggers_on_project_id", using: :btree
784 785
  end

Jasper Maes's avatar
Jasper Maes committed
786
  create_table "ci_variables", id: :serial, force: :cascade do |t|
787
    t.string "key", null: false
788 789 790 791
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
792
    t.integer "project_id", null: false
793
    t.boolean "protected", default: false, null: false
794
    t.string "environment_scope", default: "*", null: false
795
    t.boolean "masked", default: false, null: false
796
    t.integer "variable_type", limit: 2, default: 1, null: false
797
    t.index ["project_id", "key", "environment_scope"], name: "index_ci_variables_on_project_id_and_key_and_environment_scope", unique: true, using: :btree
798 799
  end

Jasper Maes's avatar
Jasper Maes committed
800
  create_table "cluster_groups", id: :serial, force: :cascade do |t|
801 802
    t.integer "cluster_id", null: false
    t.integer "group_id", null: false
803 804
    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
805 806
  end

Jasper Maes's avatar
Jasper Maes committed
807
  create_table "cluster_platforms_kubernetes", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
808
    t.integer "cluster_id", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
809 810 811
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.text "api_url"
Shinya Maeda's avatar
Shinya Maeda committed
812 813 814 815 816 817 818
    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"
819
    t.integer "authorization_type", limit: 2
820
    t.index ["cluster_id"], name: "index_cluster_platforms_kubernetes_on_cluster_id", unique: true, using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
821 822
  end

Jasper Maes's avatar
Jasper Maes committed
823
  create_table "cluster_projects", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
824 825
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
826 827
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
828 829
    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
830 831
  end

Jasper Maes's avatar
Jasper Maes committed
832
  create_table "cluster_providers_gcp", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
833 834
    t.integer "cluster_id", null: false
    t.integer "status"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
835 836 837
    t.integer "num_nodes", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
838 839 840 841 842 843 844 845
    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"
846
    t.boolean "legacy_abac", default: false, null: false
847
    t.index ["cluster_id"], name: "index_cluster_providers_gcp_on_cluster_id", unique: true, using: :btree
Shinya Maeda's avatar
Shinya Maeda committed
848 849
  end

Jasper Maes's avatar
Jasper Maes committed
850
  create_table "clusters", id: :serial, force: :cascade do |t|
851
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
852 853 854 855
    t.integer "provider_type"
    t.integer "platform_type"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
856 857
    t.boolean "enabled", default: true
    t.string "name", null: false
858
    t.string "environment_scope", default: "*", null: false
859
    t.integer "cluster_type", limit: 2, default: 3, null: false
860
    t.string "domain"
861
    t.boolean "managed", default: true, null: false
862 863
    t.index ["enabled"], name: "index_clusters_on_enabled", using: :btree
    t.index ["user_id"], name: "index_clusters_on_user_id", using: :btree
Amit Rathi's avatar
Amit Rathi committed
864 865
  end

Jasper Maes's avatar
Jasper Maes committed
866
  create_table "clusters_applications_cert_managers", id: :serial, force: :cascade do |t|
867 868 869 870 871 872 873
    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"
874
    t.index ["cluster_id"], name: "index_clusters_applications_cert_managers_on_cluster_id", unique: true, using: :btree
875 876
  end

Jasper Maes's avatar
Jasper Maes committed
877
  create_table "clusters_applications_helm", id: :serial, force: :cascade do |t|
878 879 880 881 882 883
    t.integer "cluster_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
884 885 886
    t.text "encrypted_ca_key"
    t.text "encrypted_ca_key_iv"
    t.text "ca_cert"
887
    t.index ["cluster_id"], name: "index_clusters_applications_helm_on_cluster_id", unique: true, using: :btree
888
  end
889

Jasper Maes's avatar
Jasper Maes committed
890
  create_table "clusters_applications_ingress", id: :serial, force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
891 892 893 894 895 896 897 898
    t.integer "cluster_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "status", null: false
    t.integer "ingress_type", null: false
    t.string "version", null: false
    t.string "cluster_ip"
    t.text "status_reason"
899
    t.string "external_ip"
900
    t.string "external_hostname"
901
    t.index ["cluster_id"], name: "index_clusters_applications_ingress_on_cluster_id", unique: true, using: :btree
Kamil Trzcinski's avatar
Kamil Trzcinski committed
902 903
  end

Jasper Maes's avatar
Jasper Maes committed
904
  create_table "clusters_applications_jupyter", id: :serial, force: :cascade do |t|
905
    t.integer "cluster_id", null: false
906
    t.integer "oauth_application_id"
907 908 909 910 911
    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
912
    t.text "status_reason"
913 914
    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
915 916
  end

Jasper Maes's avatar
Jasper Maes committed
917
  create_table "clusters_applications_knative", id: :serial, force: :cascade do |t|
Chris Baumbauer's avatar
Chris Baumbauer committed
918 919 920 921 922
    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
923
    t.string "hostname"
Chris Baumbauer's avatar
Chris Baumbauer committed
924
    t.text "status_reason"
925
    t.string "external_ip"
926
    t.string "external_hostname"
927
    t.index ["cluster_id"], name: "index_clusters_applications_knative_on_cluster_id", unique: true, using: :btree
Chris Baumbauer's avatar
Chris Baumbauer committed
928 929
  end

Jasper Maes's avatar
Jasper Maes committed
930
  create_table "clusters_applications_prometheus", id: :serial, force: :cascade do |t|
931 932 933 934 935 936
    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
937 938 939
    t.string "encrypted_alert_manager_token"
    t.string "encrypted_alert_manager_token_iv"
    t.datetime_with_timezone "last_update_started_at"
940
    t.index ["cluster_id"], name: "index_clusters_applications_prometheus_on_cluster_id", unique: true, using: :btree
941 942
  end

Jasper Maes's avatar
Jasper Maes committed
943
  create_table "clusters_applications_runners", id: :serial, force: :cascade do |t|
944 945 946 947 948 949 950
    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"
951
    t.boolean "privileged", default: true, null: false
952 953
    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
954 955
  end

Jasper Maes's avatar
Jasper Maes committed
956
  create_table "clusters_kubernetes_namespaces", force: :cascade do |t|
957 958 959 960 961 962 963 964 965
    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"
966 967 968 969
    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
970 971
  end

Jasper Maes's avatar
Jasper Maes committed
972
  create_table "container_repositories", id: :serial, force: :cascade do |t|
973 974 975 976
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
977 978
    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
979 980
  end

Jasper Maes's avatar
Jasper Maes committed
981
  create_table "conversational_development_index_metrics", id: :serial, force: :cascade do |t|
982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003
    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
1004 1005 1006 1007 1008 1009 1010 1011 1012 1013
    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
1014
  end
1015

1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034
  create_table "dependency_proxy_blobs", id: :serial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.text "file", null: false
    t.string "file_name", null: false
    t.integer "file_store"
    t.integer "group_id", null: false
    t.bigint "size"
    t.datetime_with_timezone "updated_at", null: false
    t.index ["group_id", "file_name"], name: "index_dependency_proxy_blobs_on_group_id_and_file_name", using: :btree
  end

  create_table "dependency_proxy_group_settings", id: :serial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.boolean "enabled", default: false, null: false
    t.integer "group_id", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["group_id"], name: "index_dependency_proxy_group_settings_on_group_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1035
  create_table "deploy_keys_projects", id: :serial, force: :cascade do |t|
1036 1037
    t.integer "deploy_key_id", null: false
    t.integer "project_id", null: false
1038 1039
    t.datetime "created_at"
    t.datetime "updated_at"
1040
    t.boolean "can_push", default: false, null: false
1041
    t.index ["project_id"], name: "index_deploy_keys_projects_on_project_id", using: :btree
1042
  end
1043

Jasper Maes's avatar
Jasper Maes committed
1044
  create_table "deploy_tokens", id: :serial, force: :cascade do |t|
1045
    t.boolean "revoked", default: false
1046 1047
    t.boolean "read_repository", default: false, null: false
    t.boolean "read_registry", default: false, null: false
1048
    t.datetime_with_timezone "expires_at", null: false
1049
    t.datetime_with_timezone "created_at", null: false
1050 1051
    t.string "name", null: false
    t.string "token", null: false
1052
    t.string "username"
1053 1054
    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
1055 1056
  end

Jasper Maes's avatar
Jasper Maes committed
1057
  create_table "deployments", id: :serial, force: :cascade do |t|
Valery Sizov's avatar
Valery Sizov committed
1058 1059 1060 1061 1062 1063
    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
1064
    t.integer "user_id"
Valery Sizov's avatar
Valery Sizov committed
1065 1066
    t.integer "deployable_id"
    t.string "deployable_type"
1067 1068
    t.datetime "created_at"
    t.datetime "updated_at"
1069
    t.string "on_stop"
1070
    t.integer "status", limit: 2, null: false
Amit Rathi's avatar
Amit Rathi committed
1071
    t.datetime_with_timezone "finished_at"
1072 1073
    t.integer "cluster_id"
    t.index ["cluster_id"], name: "index_deployments_on_cluster_id", using: :btree
1074 1075 1076 1077 1078 1079 1080 1081 1082
    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
1083 1084
  end

1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133
  create_table "design_management_designs", force: :cascade do |t|
    t.integer "project_id", null: false
    t.integer "issue_id", null: false
    t.string "filename", null: false
    t.index ["issue_id", "filename"], name: "index_design_management_designs_on_issue_id_and_filename", unique: true, using: :btree
    t.index ["project_id"], name: "index_design_management_designs_on_project_id", using: :btree
  end

  create_table "design_management_designs_versions", id: false, force: :cascade do |t|
    t.bigint "design_id", null: false
    t.bigint "version_id", null: false
    t.index ["design_id", "version_id"], name: "design_management_designs_versions_uniqueness", unique: true, using: :btree
    t.index ["design_id"], name: "index_design_management_designs_versions_on_design_id", using: :btree
    t.index ["version_id"], name: "index_design_management_designs_versions_on_version_id", using: :btree
  end

  create_table "design_management_versions", force: :cascade do |t|
    t.binary "sha", null: false
    t.index ["sha"], name: "index_design_management_versions_on_sha", unique: true, using: :btree
  end

  create_table "draft_notes", 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"
    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
  end

  create_table "elasticsearch_indexed_namespaces", id: false, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "namespace_id"
    t.index ["namespace_id"], name: "index_elasticsearch_indexed_namespaces_on_namespace_id", unique: true, using: :btree
  end

  create_table "elasticsearch_indexed_projects", id: false, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id"
    t.index ["project_id"], name: "index_elasticsearch_indexed_projects_on_project_id", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1134
  create_table "emails", id: :serial, force: :cascade do |t|
1135 1136
    t.integer "user_id", null: false
    t.string "email", null: false
1137 1138
    t.datetime "created_at"
    t.datetime "updated_at"
1139
    t.string "confirmation_token"
1140 1141
    t.datetime_with_timezone "confirmed_at"
    t.datetime_with_timezone "confirmation_sent_at"
1142 1143 1144
    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
1145 1146
  end

Jasper Maes's avatar
Jasper Maes committed
1147
  create_table "environments", id: :serial, force: :cascade do |t|
1148
    t.integer "project_id", null: false
1149
    t.string "name", null: false
1150 1151
    t.datetime "created_at"
    t.datetime "updated_at"
1152 1153
    t.string "external_url"
    t.string "environment_type"
1154
    t.string "state", default: "available", null: false
Nick Thomas's avatar
Nick Thomas committed
1155
    t.string "slug", null: false
1156
    t.index ["name"], name: "index_environments_on_name_varchar_pattern_ops", using: :btree, opclasses: {"name"=>"varchar_pattern_ops"}
1157 1158
    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
1159 1160
  end

1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 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 1208 1209 1210 1211 1212 1213 1214 1215 1216
  create_table "epic_issues", id: :serial, force: :cascade do |t|
    t.integer "epic_id", null: false
    t.integer "issue_id", null: false
    t.integer "relative_position", default: 1073741823, null: false
    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
  end

  create_table "epic_metrics", id: :serial, force: :cascade do |t|
    t.integer "epic_id", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["epic_id"], name: "index_epic_metrics", using: :btree
  end

  create_table "epics", id: :serial, 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"
    t.datetime "last_edited_at"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "title", null: false
    t.string "title_html", null: false
    t.text "description"
    t.text "description_html"
    t.integer "start_date_sourcing_milestone_id"
    t.integer "due_date_sourcing_milestone_id"
    t.date "start_date_fixed"
    t.date "due_date_fixed"
    t.boolean "start_date_is_fixed"
    t.boolean "due_date_is_fixed"
    t.integer "state", limit: 2, default: 1, null: false
    t.integer "closed_by_id"
    t.datetime "closed_at"
    t.integer "parent_id"
    t.integer "relative_position"
    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
    t.index ["parent_id"], name: "index_epics_on_parent_id", using: :btree
    t.index ["start_date"], name: "index_epics_on_start_date", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1217
  create_table "events", id: :serial, force: :cascade do |t|
1218 1219 1220
    t.integer "project_id"
    t.integer "author_id", null: false
    t.integer "target_id"
1221 1222
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1223 1224
    t.integer "action", limit: 2, null: false
    t.string "target_type"
1225 1226
    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
1227
    t.index ["created_at", "author_id"], name: "analytics_index_events_on_created_at_and_author_id", using: :btree
1228
    t.index ["project_id", "created_at"], name: "index_events_on_project_id_and_created_at", using: :btree
1229 1230
    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
1231 1232
  end

Jasper Maes's avatar
Jasper Maes committed
1233
  create_table "feature_gates", id: :serial, force: :cascade do |t|
1234 1235 1236 1237 1238
    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
1239
    t.index ["feature_key", "key", "value"], name: "index_feature_gates_on_feature_key_and_key_and_value", unique: true, using: :btree
1240 1241
  end

Jasper Maes's avatar
Jasper Maes committed
1242
  create_table "features", id: :serial, force: :cascade do |t|
1243 1244 1245
    t.string "key", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1246
    t.index ["key"], name: "index_features_on_key", unique: true, using: :btree
1247 1248
  end

Jasper Maes's avatar
Jasper Maes committed
1249
  create_table "fork_network_members", id: :serial, force: :cascade do |t|
1250 1251 1252
    t.integer "fork_network_id", null: false
    t.integer "project_id", null: false
    t.integer "forked_from_project_id"
1253
    t.index ["fork_network_id"], name: "index_fork_network_members_on_fork_network_id", using: :btree
1254
    t.index ["forked_from_project_id"], name: "index_fork_network_members_on_forked_from_project_id", using: :btree
1255
    t.index ["project_id"], name: "index_fork_network_members_on_project_id", unique: true, using: :btree
1256 1257
  end

Jasper Maes's avatar
Jasper Maes committed
1258
  create_table "fork_networks", id: :serial, force: :cascade do |t|
1259 1260
    t.integer "root_project_id"
    t.string "deleted_root_project_name"
1261
    t.index ["root_project_id"], name: "index_fork_networks_on_root_project_id", unique: true, using: :btree
1262 1263
  end

Jasper Maes's avatar
Jasper Maes committed
1264
  create_table "forked_project_links", id: :serial, force: :cascade do |t|
1265 1266
    t.integer "forked_to_project_id", null: false
    t.integer "forked_from_project_id", null: false
1267 1268
    t.datetime "created_at"
    t.datetime "updated_at"
1269
    t.index ["forked_to_project_id"], name: "index_forked_project_links_on_forked_to_project_id", unique: true, using: :btree
1270 1271
  end

1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395
  create_table "geo_cache_invalidation_events", force: :cascade do |t|
    t.string "key", null: false
  end

  create_table "geo_event_log", force: :cascade do |t|
    t.datetime "created_at", null: false
    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

  create_table "geo_hashed_storage_attachments_events", force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "old_attachments_path", null: false
    t.text "new_attachments_path", null: false
    t.index ["project_id"], name: "index_geo_hashed_storage_attachments_events_on_project_id", using: :btree
  end

  create_table "geo_hashed_storage_migrated_events", 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
    t.index ["project_id"], name: "index_geo_hashed_storage_migrated_events_on_project_id", using: :btree
  end

  create_table "geo_job_artifact_deleted_events", force: :cascade do |t|
    t.integer "job_artifact_id", null: false
    t.string "file_path", null: false
    t.index ["job_artifact_id"], name: "index_geo_job_artifact_deleted_events_on_job_artifact_id", using: :btree
  end

  create_table "geo_lfs_object_deleted_events", force: :cascade do |t|
    t.integer "lfs_object_id", null: false
    t.string "oid", null: false
    t.string "file_path", null: false
    t.index ["lfs_object_id"], name: "index_geo_lfs_object_deleted_events_on_lfs_object_id", using: :btree
  end

  create_table "geo_node_namespace_links", id: :serial, force: :cascade do |t|
    t.integer "geo_node_id", null: false
    t.integer "namespace_id", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    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
    t.index ["namespace_id"], name: "index_geo_node_namespace_links_on_namespace_id", using: :btree
  end

  create_table "geo_node_statuses", id: :serial, 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"
    t.datetime "last_event_date"
    t.integer "cursor_last_event_id"
    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"
    t.string "status_message"
    t.integer "replication_slots_count"
    t.integer "replication_slots_used_count"
    t.bigint "replication_slots_max_retained_wal_bytes"
    t.integer "wikis_synced_count"
    t.integer "wikis_failed_count"
    t.integer "job_artifacts_count"
    t.integer "job_artifacts_synced_count"
    t.integer "job_artifacts_failed_count"
    t.string "version"
    t.string "revision"
    t.integer "repositories_verified_count"
    t.integer "repositories_verification_failed_count"
    t.integer "wikis_verified_count"
    t.integer "wikis_verification_failed_count"
    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"
    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"
    t.binary "storage_configuration_digest"
    t.integer "repositories_retrying_verification_count"
    t.integer "wikis_retrying_verification_count"
    t.integer "projects_count"
    t.index ["geo_node_id"], name: "index_geo_node_statuses_on_geo_node_id", unique: true, using: :btree
  end

  create_table "geo_nodes", id: :serial, force: :cascade do |t|
1396
    t.boolean "primary", default: false, null: false
1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492
    t.integer "oauth_application_id"
    t.boolean "enabled", default: true, null: false
    t.string "access_key"
    t.string "encrypted_secret_access_key"
    t.string "encrypted_secret_access_key_iv"
    t.string "clone_url_prefix"
    t.integer "files_max_capacity", default: 10, null: false
    t.integer "repos_max_capacity", default: 25, null: false
    t.string "url", null: false
    t.string "selective_sync_type"
    t.text "selective_sync_shards"
    t.integer "verification_max_capacity", default: 100, null: false
    t.integer "minimum_reverification_interval", default: 7, null: false
    t.string "internal_url"
    t.string "name", null: false
    t.index ["access_key"], name: "index_geo_nodes_on_access_key", using: :btree
    t.index ["name"], name: "index_geo_nodes_on_name", unique: true, using: :btree
    t.index ["primary"], name: "index_geo_nodes_on_primary", using: :btree
  end

  create_table "geo_repositories_changed_events", force: :cascade do |t|
    t.integer "geo_node_id", null: false
    t.index ["geo_node_id"], name: "index_geo_repositories_changed_events_on_geo_node_id", using: :btree
  end

  create_table "geo_repository_created_events", 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
    t.index ["project_id"], name: "index_geo_repository_created_events_on_project_id", using: :btree
  end

  create_table "geo_repository_deleted_events", force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "repository_storage_name", null: false
    t.text "deleted_path", null: false
    t.text "deleted_wiki_path"
    t.text "deleted_project_name", null: false
    t.index ["project_id"], name: "index_geo_repository_deleted_events_on_project_id", using: :btree
  end

  create_table "geo_repository_renamed_events", force: :cascade do |t|
    t.integer "project_id", null: false
    t.text "repository_storage_name", null: false
    t.text "old_path_with_namespace", null: false
    t.text "new_path_with_namespace", null: false
    t.text "old_wiki_path_with_namespace", null: false
    t.text "new_wiki_path_with_namespace", null: false
    t.text "old_path", null: false
    t.text "new_path", null: false
    t.index ["project_id"], name: "index_geo_repository_renamed_events_on_project_id", using: :btree
  end

  create_table "geo_repository_updated_events", force: :cascade do |t|
    t.integer "branches_affected", null: false
    t.integer "tags_affected", null: false
    t.integer "project_id", null: false
    t.integer "source", limit: 2, null: false
    t.boolean "new_branch", default: false, null: false
    t.boolean "remove_branch", default: false, null: false
    t.text "ref"
    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
  end

  create_table "geo_reset_checksum_events", force: :cascade do |t|
    t.integer "project_id", null: false
    t.index ["project_id"], name: "index_geo_reset_checksum_events_on_project_id", using: :btree
  end

  create_table "geo_upload_deleted_events", 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
    t.index ["upload_id"], name: "index_geo_upload_deleted_events_on_upload_id", using: :btree
  end

  create_table "gitlab_subscriptions", 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

Jasper Maes's avatar
Jasper Maes committed
1493
  create_table "gpg_key_subkeys", id: :serial, force: :cascade do |t|
1494
    t.integer "gpg_key_id", null: false
1495 1496
    t.binary "keyid"
    t.binary "fingerprint"
1497 1498 1499
    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
1500 1501
  end

Jasper Maes's avatar
Jasper Maes committed
1502
  create_table "gpg_keys", id: :serial, force: :cascade do |t|
1503 1504
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1505
    t.integer "user_id"
1506 1507
    t.binary "primary_keyid"
    t.binary "fingerprint"
1508
    t.text "key"
1509 1510 1511
    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
1512 1513
  end

Jasper Maes's avatar
Jasper Maes committed
1514
  create_table "gpg_signatures", id: :serial, force: :cascade do |t|
1515 1516
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1517 1518
    t.integer "project_id"
    t.integer "gpg_key_id"
1519 1520
    t.binary "commit_sha"
    t.binary "gpg_key_primary_keyid"
1521 1522
    t.text "gpg_key_user_name"
    t.text "gpg_key_user_email"
1523
    t.integer "verification_status", limit: 2, default: 0, null: false
1524
    t.integer "gpg_key_subkey_id"
1525 1526 1527 1528 1529
    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
1530 1531
  end

Jasper Maes's avatar
Jasper Maes committed
1532
  create_table "group_custom_attributes", id: :serial, force: :cascade do |t|
1533 1534
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1535 1536 1537
    t.integer "group_id", null: false
    t.string "key", null: false
    t.string "value", null: false
1538 1539
    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
1540 1541
  end

1542 1543 1544 1545 1546 1547 1548
  create_table "historical_data", id: :serial, force: :cascade do |t|
    t.date "date", null: false
    t.integer "active_user_count"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Jasper Maes's avatar
Jasper Maes committed
1549
  create_table "identities", id: :serial, force: :cascade do |t|
1550 1551 1552
    t.string "extern_uid"
    t.string "provider"
    t.integer "user_id"
1553 1554
    t.datetime "created_at"
    t.datetime "updated_at"
1555 1556 1557
    t.integer "saml_provider_id"
    t.string "secondary_extern_uid"
    t.index ["saml_provider_id"], name: "index_identities_on_saml_provider_id", where: "(saml_provider_id IS NOT NULL)", using: :btree
1558
    t.index ["user_id"], name: "index_identities_on_user_id", using: :btree
1559 1560
  end

Jasper Maes's avatar
Jasper Maes committed
1561
  create_table "import_export_uploads", id: :serial, force: :cascade do |t|
1562 1563 1564 1565
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id"
    t.text "import_file"
    t.text "export_file"
1566 1567
    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
1568 1569
  end

1570 1571 1572 1573 1574 1575 1576
  create_table "index_statuses", id: :serial, force: :cascade do |t|
    t.integer "project_id", null: false
    t.datetime "indexed_at"
    t.text "note"
    t.string "last_commit"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1577 1578
    t.binary "last_wiki_commit"
    t.datetime_with_timezone "wiki_indexed_at"
1579 1580 1581 1582 1583 1584 1585 1586 1587 1588
    t.index ["project_id"], name: "index_index_statuses_on_project_id", unique: true, using: :btree
  end

  create_table "insights", id: :serial, force: :cascade do |t|
    t.integer "namespace_id", null: false
    t.integer "project_id", null: false
    t.index ["namespace_id"], name: "index_insights_on_namespace_id", using: :btree
    t.index ["project_id"], name: "index_insights_on_project_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1589
  create_table "internal_ids", force: :cascade do |t|
1590
    t.integer "project_id"
1591 1592
    t.integer "usage", null: false
    t.integer "last_value", null: false
1593
    t.integer "namespace_id"
1594 1595
    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
1596 1597
    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
1598 1599
  end

1600 1601 1602 1603 1604 1605
  create_table "ip_restrictions", force: :cascade do |t|
    t.integer "group_id", null: false
    t.string "range", null: false
    t.index ["group_id"], name: "index_ip_restrictions_on_group_id", using: :btree
  end

1606
  create_table "issue_assignees", id: false, force: :cascade do |t|
1607 1608
    t.integer "user_id", null: false
    t.integer "issue_id", null: false
1609 1610
    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
1611 1612
  end

1613 1614 1615 1616 1617 1618 1619 1620 1621 1622
  create_table "issue_links", id: :serial, force: :cascade do |t|
    t.integer "source_id", null: false
    t.integer "target_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    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
  end

Jasper Maes's avatar
Jasper Maes committed
1623
  create_table "issue_metrics", id: :serial, force: :cascade do |t|
1624
    t.integer "issue_id", null: false
1625
    t.datetime "first_mentioned_in_commit_at"
1626 1627
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
1628 1629
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1630
    t.index ["issue_id"], name: "index_issue_metrics", using: :btree
1631 1632
  end

1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645
  create_table "issue_tracker_data", force: :cascade do |t|
    t.integer "service_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "encrypted_project_url"
    t.string "encrypted_project_url_iv"
    t.string "encrypted_issues_url"
    t.string "encrypted_issues_url_iv"
    t.string "encrypted_new_issue_url"
    t.string "encrypted_new_issue_url_iv"
    t.index ["service_id"], name: "index_issue_tracker_data_on_service_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1646
  create_table "issues", id: :serial, force: :cascade do |t|
1647 1648 1649
    t.string "title"
    t.integer "author_id"
    t.integer "project_id"
1650 1651
    t.datetime "created_at"
    t.datetime "updated_at"
1652 1653 1654 1655 1656
    t.text "description"
    t.integer "milestone_id"
    t.string "state"
    t.integer "iid"
    t.integer "updated_by_id"
1657
    t.boolean "confidential", default: false, null: false
1658 1659 1660 1661 1662
    t.date "due_date"
    t.integer "moved_to_id"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
1663
    t.integer "time_estimate"
1664
    t.integer "relative_position"
1665
    t.integer "cached_markdown_version"
1666 1667
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1668
    t.boolean "discussion_locked"
1669
    t.datetime_with_timezone "closed_at"
haseeb's avatar
haseeb committed
1670
    t.integer "closed_by_id"
1671
    t.integer "state_id", limit: 2
1672 1673
    t.string "service_desk_reply_to"
    t.integer "weight"
1674
    t.index ["author_id"], name: "index_issues_on_author_id", using: :btree
1675
    t.index ["closed_by_id"], name: "index_issues_on_closed_by_id", using: :btree
1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688
    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
1689 1690
  end

1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708
  create_table "jira_connect_installations", force: :cascade do |t|
    t.string "client_key"
    t.string "encrypted_shared_secret"
    t.string "encrypted_shared_secret_iv"
    t.string "base_url"
    t.index ["client_key"], name: "index_jira_connect_installations_on_client_key", unique: true, using: :btree
  end

  create_table "jira_connect_subscriptions", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.bigint "jira_connect_installation_id", null: false
    t.integer "namespace_id", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["jira_connect_installation_id", "namespace_id"], name: "idx_jira_connect_subscriptions_on_installation_id_namespace_id", unique: true, using: :btree
    t.index ["jira_connect_installation_id"], name: "idx_jira_connect_subscriptions_on_installation_id", using: :btree
    t.index ["namespace_id"], name: "index_jira_connect_subscriptions_on_namespace_id", using: :btree
  end

1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724
  create_table "jira_tracker_data", force: :cascade do |t|
    t.integer "service_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "encrypted_url"
    t.string "encrypted_url_iv"
    t.string "encrypted_api_url"
    t.string "encrypted_api_url_iv"
    t.string "encrypted_username"
    t.string "encrypted_username_iv"
    t.string "encrypted_password"
    t.string "encrypted_password_iv"
    t.string "jira_issue_transition_id"
    t.index ["service_id"], name: "index_jira_tracker_data_on_service_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
1725
  create_table "keys", id: :serial, force: :cascade do |t|
1726
    t.integer "user_id"
1727 1728
    t.datetime "created_at"
    t.datetime "updated_at"
1729 1730 1731 1732 1733
    t.text "key"
    t.string "title"
    t.string "type"
    t.string "fingerprint"
    t.boolean "public", default: false, null: false
1734
    t.datetime "last_used_at"
1735 1736
    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
1737 1738
  end

Jasper Maes's avatar
Jasper Maes committed
1739
  create_table "label_links", id: :serial, force: :cascade do |t|
1740 1741 1742
    t.integer "label_id"
    t.integer "target_id"
    t.string "target_type"
1743 1744
    t.datetime "created_at"
    t.datetime "updated_at"
1745 1746
    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
1747 1748
  end

Jasper Maes's avatar
Jasper Maes committed
1749
  create_table "label_priorities", id: :serial, force: :cascade do |t|
1750 1751 1752 1753 1754
    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
1755
    t.index ["label_id"], name: "index_label_priorities_on_label_id", using: :btree
1756 1757
    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
1758 1759
  end

Jasper Maes's avatar
Jasper Maes committed
1760
  create_table "labels", id: :serial, force: :cascade do |t|
1761 1762 1763
    t.string "title"
    t.string "color"
    t.integer "project_id"
1764 1765
    t.datetime "created_at"
    t.datetime "updated_at"
1766 1767 1768
    t.boolean "template", default: false
    t.string "description"
    t.text "description_html"
1769 1770
    t.string "type"
    t.integer "group_id"
1771
    t.integer "cached_markdown_version"
1772 1773 1774 1775 1776
    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
1777 1778
  end

1779 1780 1781 1782 1783 1784 1785 1786 1787 1788
  create_table "ldap_group_links", id: :serial, force: :cascade do |t|
    t.string "cn"
    t.integer "group_access", null: false
    t.integer "group_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "provider"
    t.string "filter"
  end

Jasper Maes's avatar
Jasper Maes committed
1789
  create_table "lfs_file_locks", id: :serial, force: :cascade do |t|
1790 1791 1792 1793
    t.integer "project_id", null: false
    t.integer "user_id", null: false
    t.datetime "created_at", null: false
    t.string "path", limit: 511
1794 1795
    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
1796 1797
  end

Jasper Maes's avatar
Jasper Maes committed
1798
  create_table "lfs_objects", id: :serial, force: :cascade do |t|
1799
    t.string "oid", null: false
1800
    t.bigint "size", null: false
Marin Jankovski's avatar
Marin Jankovski committed
1801 1802
    t.datetime "created_at"
    t.datetime "updated_at"
1803
    t.string "file"
1804
    t.integer "file_store"
1805 1806
    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
1807 1808
  end

Jasper Maes's avatar
Jasper Maes committed
1809
  create_table "lfs_objects_projects", id: :serial, force: :cascade do |t|
1810 1811
    t.integer "lfs_object_id", null: false
    t.integer "project_id", null: false
Marin Jankovski's avatar
Marin Jankovski committed
1812 1813
    t.datetime "created_at"
    t.datetime "updated_at"
1814 1815
    t.integer "repository_type", limit: 2
    t.index ["lfs_object_id"], name: "index_lfs_objects_projects_on_lfs_object_id", using: :btree
1816
    t.index ["project_id"], name: "index_lfs_objects_projects_on_project_id", using: :btree
Marin Jankovski's avatar
Marin Jankovski committed
1817 1818
  end

1819 1820 1821 1822 1823 1824
  create_table "licenses", id: :serial, force: :cascade do |t|
    t.text "data", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

Jasper Maes's avatar
Jasper Maes committed
1825
  create_table "lists", id: :serial, force: :cascade do |t|
1826 1827 1828 1829 1830 1831
    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
1832 1833
    t.integer "milestone_id"
    t.integer "user_id"
1834 1835 1836
    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
1837 1838
    t.index ["milestone_id"], name: "index_lists_on_milestone_id", using: :btree
    t.index ["user_id"], name: "index_lists_on_user_id", using: :btree
1839 1840
  end

Jasper Maes's avatar
Jasper Maes committed
1841
  create_table "members", id: :serial, force: :cascade do |t|
1842 1843 1844 1845 1846 1847
    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"
1848 1849
    t.datetime "created_at"
    t.datetime "updated_at"
1850 1851 1852
    t.integer "created_by_id"
    t.string "invite_email"
    t.string "invite_token"
Douwe Maan's avatar
Douwe Maan committed
1853
    t.datetime "invite_accepted_at"
1854
    t.datetime "requested_at"
1855
    t.date "expires_at"
1856 1857
    t.boolean "ldap", default: false, null: false
    t.boolean "override", default: false, null: false
1858
    t.index ["access_level"], name: "index_members_on_access_level", using: :btree
1859
    t.index ["invite_email"], name: "index_members_on_invite_email", using: :btree
1860 1861 1862 1863
    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
1864 1865
  end

1866 1867 1868 1869 1870 1871 1872 1873
  create_table "merge_request_assignees", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "merge_request_id", null: false
    t.index ["merge_request_id", "user_id"], name: "index_merge_request_assignees_on_merge_request_id_and_user_id", unique: true, using: :btree
    t.index ["merge_request_id"], name: "index_merge_request_assignees_on_merge_request_id", using: :btree
    t.index ["user_id"], name: "index_merge_request_assignees_on_user_id", using: :btree
  end

1874 1875 1876 1877 1878 1879 1880 1881 1882
  create_table "merge_request_blocks", force: :cascade do |t|
    t.integer "blocking_merge_request_id", null: false
    t.integer "blocked_merge_request_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["blocked_merge_request_id"], name: "index_merge_request_blocks_on_blocked_merge_request_id", using: :btree
    t.index ["blocking_merge_request_id", "blocked_merge_request_id"], name: "index_mr_blocks_on_blocking_and_blocked_mr_ids", unique: true, using: :btree
  end

1883
  create_table "merge_request_diff_commits", id: false, force: :cascade do |t|
1884 1885
    t.datetime_with_timezone "authored_date"
    t.datetime_with_timezone "committed_date"
1886 1887 1888 1889 1890 1891 1892 1893
    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"
1894 1895
    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
1896 1897
  end

1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908
  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
1909
    t.text "diff"
1910
    t.boolean "binary"
1911 1912
    t.integer "external_diff_offset"
    t.integer "external_diff_size"
1913
    t.index ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_files_on_mr_diff_id_and_order", unique: true, using: :btree
1914 1915
  end

Jasper Maes's avatar
Jasper Maes committed
1916
  create_table "merge_request_diffs", id: :serial, force: :cascade do |t|
1917 1918
    t.string "state"
    t.integer "merge_request_id", null: false
1919 1920
    t.datetime "created_at"
    t.datetime "updated_at"
1921 1922 1923 1924
    t.string "base_commit_sha"
    t.string "real_size"
    t.string "head_commit_sha"
    t.string "start_commit_sha"
1925
    t.integer "commits_count"
1926 1927 1928
    t.string "external_diff"
    t.integer "external_diff_store"
    t.boolean "stored_externally"
1929
    t.index ["merge_request_id", "id"], name: "index_merge_request_diffs_on_merge_request_id_and_id", using: :btree
1930
    t.index ["merge_request_id", "id"], name: "index_merge_request_diffs_on_merge_request_id_and_id_partial", where: "((NOT stored_externally) OR (stored_externally IS NULL))", using: :btree
1931 1932
  end

Jasper Maes's avatar
Jasper Maes committed
1933
  create_table "merge_request_metrics", id: :serial, force: :cascade do |t|
1934
    t.integer "merge_request_id", null: false
1935 1936
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
Timothy Andrew's avatar
Timothy Andrew committed
1937 1938
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
1939 1940
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1941
    t.integer "pipeline_id"
1942 1943 1944
    t.integer "merged_by_id"
    t.integer "latest_closed_by_id"
    t.datetime_with_timezone "latest_closed_at"
1945
    t.index ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at", using: :btree
1946
    t.index ["latest_closed_at"], name: "index_merge_request_metrics_on_latest_closed_at", where: "(latest_closed_at IS NOT NULL)", using: :btree
1947
    t.index ["latest_closed_by_id"], name: "index_merge_request_metrics_on_latest_closed_by_id", using: :btree
1948
    t.index ["merge_request_id", "merged_at"], name: "index_merge_request_metrics_on_merge_request_id_and_merged_at", where: "(merged_at IS NOT NULL)", using: :btree
1949
    t.index ["merge_request_id"], name: "index_merge_request_metrics", using: :btree
1950
    t.index ["merged_by_id"], name: "index_merge_request_metrics_on_merged_by_id", using: :btree
1951
    t.index ["pipeline_id"], name: "index_merge_request_metrics_on_pipeline_id", using: :btree
1952 1953
  end

Jasper Maes's avatar
Jasper Maes committed
1954
  create_table "merge_requests", id: :serial, force: :cascade do |t|
1955 1956
    t.string "target_branch", null: false
    t.string "source_branch", null: false
1957
    t.integer "source_project_id"
1958 1959 1960
    t.integer "author_id"
    t.integer "assignee_id"
    t.string "title"
1961 1962
    t.datetime "created_at"
    t.datetime "updated_at"
1963
    t.integer "milestone_id"
1964 1965
    t.string "state", default: "opened", null: false
    t.string "merge_status", default: "unchecked", null: false
1966 1967 1968 1969 1970 1971
    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"
1972
    t.boolean "merge_when_pipeline_succeeds", default: false, null: false
1973 1974
    t.integer "merge_user_id"
    t.string "merge_commit_sha"
1975
    t.string "in_progress_merge_commit_sha"
Valery Sizov's avatar
Valery Sizov committed
1976
    t.integer "lock_version"
1977 1978
    t.text "title_html"
    t.text "description_html"
1979
    t.integer "time_estimate"
1980
    t.integer "cached_markdown_version"
1981 1982
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1983
    t.integer "head_pipeline_id"
1984
    t.string "merge_jid"
1985
    t.boolean "discussion_locked"
1986
    t.integer "latest_merge_request_diff_id"
1987
    t.string "rebase_commit_sha"
1988
    t.boolean "squash", default: false, null: false
1989
    t.boolean "allow_maintainer_to_push"
1990
    t.integer "state_id", limit: 2
1991
    t.integer "approvals_before_merge"
1992
    t.string "rebase_jid"
1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004
    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
2005
    t.index ["state", "merge_status"], name: "index_merge_requests_on_state_and_merge_status", where: "(((state)::text = 'opened'::text) AND ((merge_status)::text = 'can_be_merged'::text))", using: :btree
2006 2007 2008 2009 2010 2011 2012
    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
2013
  end
tiagonbotelho's avatar
tiagonbotelho committed
2014

Jasper Maes's avatar
Jasper Maes committed
2015
  create_table "merge_requests_closing_issues", id: :serial, force: :cascade do |t|
2016 2017 2018 2019
    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
2020 2021
    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
2022 2023
  end

2024 2025 2026 2027 2028 2029
  create_table "merge_trains", force: :cascade do |t|
    t.integer "merge_request_id", null: false
    t.integer "user_id", null: false
    t.integer "pipeline_id"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2030 2031
    t.integer "target_project_id", null: false
    t.text "target_branch", null: false
2032 2033
    t.index ["merge_request_id"], name: "index_merge_trains_on_merge_request_id", unique: true, using: :btree
    t.index ["pipeline_id"], name: "index_merge_trains_on_pipeline_id", using: :btree
2034
    t.index ["target_project_id"], name: "index_merge_trains_on_target_project_id", using: :btree
2035 2036 2037
    t.index ["user_id"], name: "index_merge_trains_on_user_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2038
  create_table "milestones", id: :serial, force: :cascade do |t|
2039
    t.string "title", null: false
Felipe Artur's avatar
Felipe Artur committed
2040
    t.integer "project_id"
2041 2042
    t.text "description"
    t.date "due_date"
2043 2044
    t.datetime "created_at"
    t.datetime "updated_at"
2045 2046 2047 2048
    t.string "state"
    t.integer "iid"
    t.text "title_html"
    t.text "description_html"
2049
    t.date "start_date"
2050
    t.integer "cached_markdown_version"
Felipe Artur's avatar
Felipe Artur committed
2051
    t.integer "group_id"
2052 2053 2054 2055 2056 2057
    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
2058 2059
  end

2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074
  create_table "namespace_aggregation_schedules", primary_key: "namespace_id", id: :integer, default: nil, force: :cascade do |t|
    t.index ["namespace_id"], name: "index_namespace_aggregation_schedules_on_namespace_id", unique: true, using: :btree
  end

  create_table "namespace_root_storage_statistics", primary_key: "namespace_id", id: :integer, default: nil, force: :cascade do |t|
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "repository_size", default: 0, null: false
    t.bigint "lfs_objects_size", default: 0, null: false
    t.bigint "wiki_size", default: 0, null: false
    t.bigint "build_artifacts_size", default: 0, null: false
    t.bigint "storage_size", default: 0, null: false
    t.bigint "packages_size", default: 0, null: false
    t.index ["namespace_id"], name: "index_namespace_root_storage_statistics_on_namespace_id", unique: true, using: :btree
  end

2075 2076 2077 2078 2079 2080 2081
  create_table "namespace_statistics", id: :serial, force: :cascade do |t|
    t.integer "namespace_id", null: false
    t.integer "shared_runners_seconds", default: 0, null: false
    t.datetime "shared_runners_seconds_last_reset"
    t.index ["namespace_id"], name: "index_namespace_statistics_on_namespace_id", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2082
  create_table "namespaces", id: :serial, force: :cascade do |t|
2083 2084 2085
    t.string "name", null: false
    t.string "path", null: false
    t.integer "owner_id"
2086 2087
    t.datetime "created_at"
    t.datetime "updated_at"
2088 2089 2090 2091 2092
    t.string "type"
    t.string "description", default: "", null: false
    t.string "avatar"
    t.boolean "share_with_group_lock", default: false
    t.integer "visibility_level", default: 20, null: false
2093
    t.boolean "request_access_enabled", default: false, null: false
Nick Thomas's avatar
Nick Thomas committed
2094
    t.text "description_html"
2095
    t.boolean "lfs_enabled"
2096
    t.integer "parent_id"
2097 2098
    t.boolean "require_two_factor_authentication", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
2099
    t.integer "cached_markdown_version"
2100
    t.string "runners_token"
2101
    t.string "runners_token_encrypted"
Gosia Ksionek's avatar
Gosia Ksionek committed
2102
    t.integer "project_creation_level"
2103
    t.boolean "auto_devops_enabled"
2104
    t.datetime_with_timezone "last_ci_minutes_notification_at"
2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118
    t.integer "custom_project_templates_group_id"
    t.integer "file_template_project_id"
    t.string "ldap_sync_error"
    t.datetime "ldap_sync_last_successful_update_at"
    t.datetime "ldap_sync_last_sync_at"
    t.datetime "ldap_sync_last_update_at"
    t.integer "plan_id"
    t.bigint "repository_size_limit"
    t.string "saml_discovery_token"
    t.integer "shared_runners_minutes_limit"
    t.datetime_with_timezone "trial_ends_on"
    t.integer "extra_shared_runners_minutes_limit"
    t.string "ldap_sync_status", default: "ready", null: false
    t.boolean "membership_lock", default: false
2119
    t.integer "last_ci_minutes_usage_notification_level"
2120
    t.index ["created_at"], name: "index_namespaces_on_created_at", using: :btree
2121 2122 2123 2124
    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
    t.index ["file_template_project_id"], name: "index_namespaces_on_file_template_project_id", using: :btree
    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
2125 2126 2127 2128 2129 2130
    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"}
2131
    t.index ["plan_id"], name: "index_namespaces_on_plan_id", using: :btree
2132 2133
    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
2134
    t.index ["runners_token_encrypted"], name: "index_namespaces_on_runners_token_encrypted", unique: true, using: :btree
2135 2136
    t.index ["shared_runners_minutes_limit", "extra_shared_runners_minutes_limit"], name: "index_namespaces_on_shared_and_extra_runners_minutes_limit", using: :btree
    t.index ["trial_ends_on"], name: "index_namespaces_on_trial_ends_on", where: "(trial_ends_on IS NOT NULL)", using: :btree
2137
    t.index ["type"], name: "index_namespaces_on_type", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2138 2139
  end

Jasper Maes's avatar
Jasper Maes committed
2140
  create_table "note_diff_files", id: :serial, force: :cascade do |t|
2141 2142 2143 2144 2145 2146 2147 2148 2149
    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
2150
    t.index ["diff_note_id"], name: "index_note_diff_files_on_diff_note_id", unique: true, using: :btree
2151 2152
  end

Jasper Maes's avatar
Jasper Maes committed
2153
  create_table "notes", id: :serial, force: :cascade do |t|
2154 2155 2156
    t.text "note"
    t.string "noteable_type"
    t.integer "author_id"
2157 2158
    t.datetime "created_at"
    t.datetime "updated_at"
2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169
    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"
2170
    t.datetime "resolved_at"
2171 2172 2173
    t.integer "resolved_by_id"
    t.string "discussion_id"
    t.text "note_html"
2174
    t.integer "cached_markdown_version"
2175
    t.text "change_position"
2176
    t.boolean "resolved_by_push"
2177
    t.bigint "review_id"
2178 2179 2180 2181 2182 2183 2184 2185 2186
    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
2187
    t.index ["review_id"], name: "index_notes_on_review_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2188 2189
  end

Jasper Maes's avatar
Jasper Maes committed
2190
  create_table "notification_settings", id: :serial, force: :cascade do |t|
2191 2192 2193 2194 2195 2196
    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
2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208
    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"
2209
    t.boolean "push_to_merge_request"
2210
    t.boolean "issue_due"
2211
    t.string "notification_email"
2212
    t.boolean "new_epic"
2213 2214 2215
    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
2216 2217
  end

Jasper Maes's avatar
Jasper Maes committed
2218
  create_table "oauth_access_grants", id: :serial, force: :cascade do |t|
2219 2220 2221 2222 2223 2224
    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
2225
    t.datetime "revoked_at"
2226
    t.string "scopes"
2227
    t.index ["token"], name: "index_oauth_access_grants_on_token", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
2228 2229
  end

Jasper Maes's avatar
Jasper Maes committed
2230
  create_table "oauth_access_tokens", id: :serial, force: :cascade do |t|
2231 2232 2233 2234 2235
    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
2236
    t.datetime "revoked_at"
2237 2238
    t.datetime "created_at", null: false
    t.string "scopes"
2239 2240 2241
    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
2242 2243
  end

Jasper Maes's avatar
Jasper Maes committed
2244
  create_table "oauth_applications", id: :serial, force: :cascade do |t|
2245 2246 2247 2248 2249
    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
2250 2251
    t.datetime "created_at"
    t.datetime "updated_at"
2252 2253
    t.integer "owner_id"
    t.string "owner_type"
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
2254
    t.boolean "trusted", default: false, null: false
2255 2256
    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
2257 2258
  end

Jasper Maes's avatar
Jasper Maes committed
2259
  create_table "oauth_openid_requests", id: :serial, force: :cascade do |t|
2260 2261
    t.integer "access_grant_id", null: false
    t.string "nonce", null: false
2262
    t.index ["access_grant_id"], name: "index_oauth_openid_requests_on_access_grant_id", using: :btree
2263 2264
  end

2265 2266 2267 2268 2269 2270
  create_table "operations_feature_flag_scopes", 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
2271
    t.jsonb "strategies", default: [{"name"=>"default", "parameters"=>{}}], null: false
2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286
    t.index ["feature_flag_id", "environment_scope"], name: "index_feature_flag_scopes_on_flag_id_and_environment_scope", unique: true, using: :btree
  end

  create_table "operations_feature_flags", force: :cascade do |t|
    t.integer "project_id", null: false
    t.boolean "active", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "name", null: false
    t.text "description"
    t.index ["project_id", "name"], name: "index_operations_feature_flags_on_project_id_and_name", unique: true, using: :btree
  end

  create_table "operations_feature_flags_clients", force: :cascade do |t|
    t.integer "project_id", null: false
2287 2288
    t.string "token"
    t.string "token_encrypted"
2289
    t.index ["project_id", "token"], name: "index_operations_feature_flags_clients_on_project_id_and_token", unique: true, using: :btree
2290
    t.index ["project_id", "token_encrypted"], name: "index_feature_flags_clients_on_project_id_and_token_encrypted", unique: true, using: :btree
2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327
  end

  create_table "packages_maven_metadata", force: :cascade do |t|
    t.bigint "package_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "app_group", null: false
    t.string "app_name", null: false
    t.string "app_version"
    t.string "path", limit: 512, null: false
    t.index ["package_id", "path"], name: "index_packages_maven_metadata_on_package_id_and_path", using: :btree
  end

  create_table "packages_package_files", force: :cascade do |t|
    t.bigint "package_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "size"
    t.integer "file_type"
    t.integer "file_store"
    t.binary "file_md5"
    t.binary "file_sha1"
    t.string "file_name", null: false
    t.text "file", null: false
    t.index ["package_id", "file_name"], name: "index_packages_package_files_on_package_id_and_file_name", using: :btree
  end

  create_table "packages_packages", 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
    t.string "version"
    t.integer "package_type", limit: 2, null: false
    t.index ["project_id"], name: "index_packages_packages_on_project_id", using: :btree
  end

2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341
  create_table "pages_domain_acme_orders", force: :cascade do |t|
    t.integer "pages_domain_id", null: false
    t.datetime_with_timezone "expires_at", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "url", null: false
    t.string "challenge_token", null: false
    t.text "challenge_file_content", null: false
    t.text "encrypted_private_key", null: false
    t.text "encrypted_private_key_iv", null: false
    t.index ["challenge_token"], name: "index_pages_domain_acme_orders_on_challenge_token", using: :btree
    t.index ["pages_domain_id"], name: "index_pages_domain_acme_orders_on_pages_domain_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2342
  create_table "pages_domains", id: :serial, force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2343
    t.integer "project_id"
2344 2345 2346 2347 2348
    t.text "certificate"
    t.text "encrypted_key"
    t.string "encrypted_key_iv"
    t.string "encrypted_key_salt"
    t.string "domain"
2349 2350 2351
    t.datetime_with_timezone "verified_at"
    t.string "verification_code", null: false
    t.datetime_with_timezone "enabled_until"
2352
    t.datetime_with_timezone "remove_at"
2353
    t.boolean "auto_ssl_enabled", default: false, null: false
2354 2355
    t.datetime_with_timezone "certificate_valid_not_before"
    t.datetime_with_timezone "certificate_valid_not_after"
2356
    t.integer "certificate_source", limit: 2, default: 0, null: false
2357
    t.index ["certificate_source", "certificate_valid_not_after"], name: "index_pages_domains_need_auto_ssl_renewal", where: "(auto_ssl_enabled = true)", using: :btree
2358 2359 2360
    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
2361
    t.index ["remove_at"], name: "index_pages_domains_on_remove_at", using: :btree
2362 2363
    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
2364 2365
  end

2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376
  create_table "path_locks", id: :serial, force: :cascade do |t|
    t.string "path", null: false
    t.integer "project_id"
    t.integer "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    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
  end

Jasper Maes's avatar
Jasper Maes committed
2377
  create_table "personal_access_tokens", id: :serial, force: :cascade do |t|
2378 2379 2380
    t.integer "user_id", null: false
    t.string "name", null: false
    t.boolean "revoked", default: false
2381
    t.date "expires_at"
2382 2383
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2384
    t.string "scopes", default: "--- []\n", null: false
Simon Vocella's avatar
Simon Vocella committed
2385
    t.boolean "impersonation", default: false, null: false
2386
    t.string "token_digest"
2387 2388
    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
2389 2390
  end

2391 2392 2393 2394 2395 2396 2397 2398 2399 2400
  create_table "plans", id: :serial, force: :cascade do |t|
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "name"
    t.string "title"
    t.integer "active_pipelines_limit"
    t.integer "pipeline_size_limit"
    t.index ["name"], name: "index_plans_on_name", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2401
  create_table "pool_repositories", force: :cascade do |t|
2402 2403
    t.integer "shard_id", null: false
    t.string "disk_path"
2404 2405
    t.string "state"
    t.integer "source_project_id"
2406 2407
    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
2408
    t.index ["source_project_id"], name: "index_pool_repositories_on_source_project_id", unique: true, using: :btree
2409 2410
  end

Jasper Maes's avatar
Jasper Maes committed
2411
  create_table "programming_languages", id: :serial, force: :cascade do |t|
2412 2413 2414
    t.string "name", null: false
    t.string "color", null: false
    t.datetime_with_timezone "created_at", null: false
2415
    t.index ["name"], name: "index_programming_languages_on_name", unique: true, using: :btree
2416 2417
  end

2418 2419 2420 2421 2422
  create_table "project_alerting_settings", primary_key: "project_id", id: :integer, default: nil, force: :cascade do |t|
    t.string "encrypted_token", null: false
    t.string "encrypted_token_iv", null: false
  end

2423 2424 2425 2426 2427 2428 2429 2430 2431
  create_table "project_aliases", force: :cascade do |t|
    t.integer "project_id", 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 ["name"], name: "index_project_aliases_on_name", unique: true, using: :btree
    t.index ["project_id"], name: "index_project_aliases_on_project_id", using: :btree
  end

2432
  create_table "project_authorizations", id: false, force: :cascade do |t|
2433 2434 2435
    t.integer "user_id", null: false
    t.integer "project_id", null: false
    t.integer "access_level", null: false
2436 2437
    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
2438 2439
  end

Jasper Maes's avatar
Jasper Maes committed
2440
  create_table "project_auto_devops", id: :serial, force: :cascade do |t|
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
2441
    t.integer "project_id", null: false
2442 2443
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2444
    t.boolean "enabled"
2445
    t.integer "deploy_strategy", default: 0, null: false
2446
    t.index ["project_id"], name: "index_project_auto_devops_on_project_id", unique: true, using: :btree
2447 2448
  end

Jasper Maes's avatar
Jasper Maes committed
2449
  create_table "project_ci_cd_settings", id: :serial, force: :cascade do |t|
2450 2451
    t.integer "project_id", null: false
    t.boolean "group_runners_enabled", default: true, null: false
2452
    t.boolean "merge_pipelines_enabled"
2453
    t.boolean "merge_trains_enabled", default: false, null: false
2454
    t.integer "default_git_depth"
2455
    t.index ["project_id"], name: "index_project_ci_cd_settings_on_project_id", unique: true, using: :btree
2456 2457
  end

Jasper Maes's avatar
Jasper Maes committed
2458
  create_table "project_custom_attributes", id: :serial, force: :cascade do |t|
2459 2460
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2461 2462 2463
    t.integer "project_id", null: false
    t.string "key", null: false
    t.string "value", null: false
2464 2465
    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
2466 2467
  end

Jasper Maes's avatar
Jasper Maes committed
2468
  create_table "project_daily_statistics", force: :cascade do |t|
2469 2470 2471 2472 2473 2474
    t.integer "project_id", null: false
    t.integer "fetch_count", null: false
    t.date "date"
    t.index ["project_id", "date"], name: "index_project_daily_statistics_on_project_id_and_date", unique: true, order: { date: :desc }, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2475
  create_table "project_deploy_tokens", id: :serial, force: :cascade do |t|
2476 2477
    t.integer "project_id", null: false
    t.integer "deploy_token_id", null: false
2478
    t.datetime_with_timezone "created_at", null: false
2479 2480
    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
2481 2482
  end

Jasper Maes's avatar
Jasper Maes committed
2483
  create_table "project_error_tracking_settings", primary_key: "project_id", id: :integer, default: nil, force: :cascade do |t|
2484 2485
    t.boolean "enabled", default: false, null: false
    t.string "api_url"
2486 2487
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
2488 2489
    t.string "project_name"
    t.string "organization_name"
2490 2491
  end

2492 2493 2494 2495 2496 2497 2498 2499
  create_table "project_feature_usages", primary_key: "project_id", id: :integer, default: nil, 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

Jasper Maes's avatar
Jasper Maes committed
2500
  create_table "project_features", id: :serial, force: :cascade do |t|
2501
    t.integer "project_id", null: false
2502 2503 2504
    t.integer "merge_requests_access_level"
    t.integer "issues_access_level"
    t.integer "wiki_access_level"
2505
    t.integer "snippets_access_level", default: 20, null: false
2506
    t.integer "builds_access_level"
2507 2508
    t.datetime "created_at"
    t.datetime "updated_at"
2509
    t.integer "repository_access_level", default: 20, null: false
2510
    t.integer "pages_access_level", default: 20, null: false
2511
    t.index ["project_id"], name: "index_project_features_on_project_id", unique: true, using: :btree
2512 2513
  end

Jasper Maes's avatar
Jasper Maes committed
2514
  create_table "project_group_links", id: :serial, force: :cascade do |t|
2515 2516
    t.integer "project_id", null: false
    t.integer "group_id", null: false
2517 2518
    t.datetime "created_at"
    t.datetime "updated_at"
2519 2520
    t.integer "group_access", default: 30, null: false
    t.date "expires_at"
2521 2522
    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
2523 2524
  end

Jasper Maes's avatar
Jasper Maes committed
2525
  create_table "project_import_data", id: :serial, force: :cascade do |t|
2526
    t.integer "project_id"
2527 2528 2529 2530
    t.text "data"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
2531
    t.index ["project_id"], name: "index_project_import_data_on_project_id", using: :btree
2532 2533
  end

2534 2535 2536
  create_table "project_incident_management_settings", primary_key: "project_id", id: :serial, force: :cascade do |t|
    t.boolean "create_issue", default: true, null: false
    t.boolean "send_email", default: false, null: false
2537 2538 2539
    t.text "issue_template_key"
  end

2540 2541 2542 2543
  create_table "project_metrics_settings", primary_key: "project_id", id: :integer, default: nil, force: :cascade do |t|
    t.string "external_dashboard_url", null: false
  end

Jasper Maes's avatar
Jasper Maes committed
2544
  create_table "project_mirror_data", id: :serial, force: :cascade do |t|
2545
    t.integer "project_id", null: false
2546 2547 2548
    t.string "status"
    t.string "jid"
    t.text "last_error"
2549 2550 2551 2552 2553 2554
    t.datetime_with_timezone "last_successful_update_at"
    t.datetime_with_timezone "last_update_at"
    t.datetime "last_update_scheduled_at"
    t.datetime "last_update_started_at"
    t.datetime "next_execution_timestamp"
    t.integer "retry_count", default: 0, null: false
2555
    t.index ["jid"], name: "index_project_mirror_data_on_jid", using: :btree
2556 2557 2558
    t.index ["last_successful_update_at"], name: "index_project_mirror_data_on_last_successful_update_at", using: :btree
    t.index ["last_update_at", "retry_count"], name: "index_project_mirror_data_on_last_update_at_and_retry_count", using: :btree
    t.index ["next_execution_timestamp", "retry_count"], name: "index_mirror_data_on_next_execution_and_retry_count", using: :btree
2559 2560
    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
2561 2562
  end

Jasper Maes's avatar
Jasper Maes committed
2563
  create_table "project_repositories", force: :cascade do |t|
2564 2565 2566 2567 2568 2569 2570 2571
    t.integer "shard_id", null: false
    t.string "disk_path", null: false
    t.integer "project_id", null: false
    t.index ["disk_path"], name: "index_project_repositories_on_disk_path", unique: true, using: :btree
    t.index ["project_id"], name: "index_project_repositories_on_project_id", unique: true, using: :btree
    t.index ["shard_id"], name: "index_project_repositories_on_shard_id", using: :btree
  end

2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591
  create_table "project_repository_states", id: :serial, 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"
    t.datetime_with_timezone "repository_retry_at"
    t.datetime_with_timezone "wiki_retry_at"
    t.integer "repository_retry_count"
    t.integer "wiki_retry_count"
    t.datetime_with_timezone "last_repository_verification_ran_at"
    t.datetime_with_timezone "last_wiki_verification_ran_at"
    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
    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
    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
  end

Jasper Maes's avatar
Jasper Maes committed
2592
  create_table "project_statistics", id: :serial, force: :cascade do |t|
2593 2594
    t.integer "project_id", null: false
    t.integer "namespace_id", null: false
2595 2596 2597 2598 2599
    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
2600
    t.bigint "packages_size", default: 0, null: false
2601
    t.bigint "wiki_size"
2602 2603
    t.bigint "shared_runners_seconds", default: 0, null: false
    t.datetime "shared_runners_seconds_last_reset"
2604 2605
    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
2606 2607
  end

2608 2609 2610 2611 2612 2613 2614 2615
  create_table "project_tracing_settings", 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
    t.index ["project_id"], name: "index_project_tracing_settings_on_project_id", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2616
  create_table "projects", id: :serial, force: :cascade do |t|
2617 2618 2619
    t.string "name"
    t.string "path"
    t.text "description"
2620 2621
    t.datetime "created_at"
    t.datetime "updated_at"
2622
    t.integer "creator_id"
2623
    t.integer "namespace_id", null: false
2624
    t.datetime "last_activity_at"
2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639
    t.string "import_url"
    t.integer "visibility_level", default: 0, null: false
    t.boolean "archived", default: false, null: false
    t.string "avatar"
    t.integer "star_count", default: 0, null: false
    t.string "import_type"
    t.string "import_source"
    t.boolean "shared_runners_enabled", default: true, null: false
    t.string "runners_token"
    t.string "build_coverage_regex"
    t.boolean "build_allow_git_fetch", default: true, null: false
    t.integer "build_timeout", default: 3600, null: false
    t.boolean "pending_delete", default: false
    t.boolean "public_builds", default: true, null: false
    t.boolean "last_repository_check_failed"
2640
    t.datetime "last_repository_check_at"
2641
    t.boolean "container_registry_enabled"
2642
    t.boolean "only_allow_merge_if_pipeline_succeeds", default: false, null: false
2643 2644
    t.boolean "has_external_issue_tracker"
    t.string "repository_storage", default: "default", null: false
2645
    t.boolean "request_access_enabled", default: false, null: false
2646
    t.boolean "has_external_wiki"
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
2647
    t.string "ci_config_path"
2648 2649
    t.boolean "lfs_enabled"
    t.text "description_html"
Valery Sizov's avatar
Valery Sizov committed
2650
    t.boolean "only_allow_merge_if_all_discussions_are_resolved"
2651
    t.boolean "printing_merge_request_link_enabled", default: true, null: false
2652
    t.integer "auto_cancel_pending_pipelines", default: 1, null: false
2653
    t.integer "cached_markdown_version"
2654
    t.text "delete_error"
2655
    t.datetime "last_repository_updated_at"
2656
    t.integer "storage_version", limit: 2
Sean McGivern's avatar
Sean McGivern committed
2657
    t.boolean "resolve_outdated_diff_discussions"
2658
    t.boolean "repository_read_only"
2659
    t.boolean "merge_requests_ff_only_enabled", default: false
2660
    t.boolean "merge_requests_rebase_enabled", default: false
2661
    t.integer "jobs_cache_index"
Rob Watson's avatar
Rob Watson committed
2662
    t.boolean "pages_https_only", default: true
2663
    t.boolean "remote_mirror_available_overridden"
2664
    t.bigint "pool_repository_id"
2665
    t.string "runners_token_encrypted"
2666
    t.string "bfg_object_map"
2667
    t.boolean "detected_repository_languages"
2668
    t.string "external_authorization_classification_label"
2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690
    t.boolean "disable_overriding_approvers_per_merge_request"
    t.string "external_webhook_token"
    t.text "issues_template"
    t.boolean "merge_requests_author_approval"
    t.boolean "merge_requests_disable_committers_approval"
    t.boolean "merge_requests_require_code_owner_approval"
    t.text "merge_requests_template"
    t.datetime "mirror_last_successful_update_at"
    t.datetime "mirror_last_update_at"
    t.boolean "mirror_overwrites_diverged_branches"
    t.integer "mirror_user_id"
    t.boolean "only_mirror_protected_branches"
    t.boolean "packages_enabled"
    t.boolean "pull_mirror_available_overridden"
    t.bigint "repository_size_limit"
    t.boolean "require_password_to_approve"
    t.boolean "mirror", default: false, null: false
    t.boolean "mirror_trigger_builds", default: false, null: false
    t.boolean "reset_approvals_on_push", default: true
    t.boolean "service_desk_enabled", default: true
    t.integer "approvals_before_merge", default: 0, null: false
    t.index ["archived", "pending_delete", "merge_requests_require_code_owner_approval"], name: "projects_requiring_code_owner_approval", where: "((pending_delete = false) AND (archived = false) AND (merge_requests_require_code_owner_approval = true))", using: :btree
2691 2692 2693
    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"}
2694
    t.index ["id", "repository_storage", "last_repository_updated_at"], name: "idx_projects_on_repository_storage_last_repository_updated_at", using: :btree
2695
    t.index ["id"], name: "index_projects_on_id_partial_for_visibility", unique: true, where: "(visibility_level = ANY (ARRAY[10, 20]))", using: :btree
2696
    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
2697 2698 2699 2700
    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
2701 2702
    t.index ["mirror_last_successful_update_at"], name: "index_projects_on_mirror_last_successful_update_at", using: :btree
    t.index ["mirror_user_id"], name: "index_projects_on_mirror_user_id", using: :btree
2703 2704 2705 2706 2707 2708 2709 2710 2711
    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
2712
    t.index ["runners_token_encrypted"], name: "index_projects_on_runners_token_encrypted", using: :btree
2713 2714 2715
    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
2716

2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740
  create_table "prometheus_alert_events", 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"
    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
  end

  create_table "prometheus_alerts", id: :serial, 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
    t.index ["environment_id"], name: "index_prometheus_alerts_on_environment_id", using: :btree
    t.index ["project_id", "prometheus_metric_id", "environment_id"], name: "index_prometheus_alerts_metric_environment", unique: true, using: :btree
    t.index ["prometheus_metric_id"], name: "index_prometheus_alerts_on_prometheus_metric_id", using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
2741
  create_table "prometheus_metrics", id: :serial, force: :cascade do |t|
2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752
    t.integer "project_id"
    t.string "title", null: false
    t.string "query", null: false
    t.string "y_label"
    t.string "unit"
    t.string "legend"
    t.integer "group", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.boolean "common", default: false, null: false
    t.string "identifier"
2753 2754 2755 2756
    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
2757 2758
  end

Jasper Maes's avatar
Jasper Maes committed
2759
  create_table "protected_branch_merge_access_levels", id: :serial, force: :cascade do |t|
2760
    t.integer "protected_branch_id", null: false
2761
    t.integer "access_level", default: 40
2762 2763
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2764 2765 2766
    t.integer "group_id"
    t.integer "user_id"
    t.index ["group_id"], name: "index_protected_branch_merge_access_levels_on_group_id", using: :btree
2767
    t.index ["protected_branch_id"], name: "index_protected_branch_merge_access", using: :btree
2768
    t.index ["user_id"], name: "index_protected_branch_merge_access_levels_on_user_id", using: :btree
2769 2770
  end

Jasper Maes's avatar
Jasper Maes committed
2771
  create_table "protected_branch_push_access_levels", id: :serial, force: :cascade do |t|
2772
    t.integer "protected_branch_id", null: false
2773
    t.integer "access_level", default: 40
2774 2775
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2776 2777 2778
    t.integer "group_id"
    t.integer "user_id"
    t.index ["group_id"], name: "index_protected_branch_push_access_levels_on_group_id", using: :btree
2779
    t.index ["protected_branch_id"], name: "index_protected_branch_push_access", using: :btree
2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790
    t.index ["user_id"], name: "index_protected_branch_push_access_levels_on_user_id", using: :btree
  end

  create_table "protected_branch_unprotect_access_levels", id: :serial, 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"
    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
2791 2792
  end

Jasper Maes's avatar
Jasper Maes committed
2793
  create_table "protected_branches", id: :serial, force: :cascade do |t|
2794 2795
    t.integer "project_id", null: false
    t.string "name", null: false
2796 2797
    t.datetime "created_at"
    t.datetime "updated_at"
2798
    t.index ["project_id"], name: "index_protected_branches_on_project_id", using: :btree
Andrew8xx8's avatar
Andrew8xx8 committed
2799 2800
  end

2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821
  create_table "protected_environment_deploy_access_levels", id: :serial, 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"
    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
  end

  create_table "protected_environments", id: :serial, 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
    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
  end

Jasper Maes's avatar
Jasper Maes committed
2822
  create_table "protected_tag_create_access_levels", id: :serial, force: :cascade do |t|
2823
    t.integer "protected_tag_id", null: false
2824 2825 2826
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
2827 2828
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2829
    t.index ["group_id"], name: "index_protected_tag_create_access_levels_on_group_id", using: :btree
2830 2831
    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
2832 2833
  end

Jasper Maes's avatar
Jasper Maes committed
2834
  create_table "protected_tags", id: :serial, force: :cascade do |t|
2835 2836
    t.integer "project_id", null: false
    t.string "name", null: false
2837 2838
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2839 2840
    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
2841 2842
  end

2843
  create_table "push_event_payloads", id: false, force: :cascade do |t|
2844
    t.bigint "commit_count", null: false
2845 2846 2847 2848 2849 2850 2851
    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
2852
    t.index ["event_id"], name: "index_push_event_payloads_on_event_id", unique: true, using: :btree
2853 2854
  end

2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875 2876 2877
  create_table "push_rules", id: :serial, force: :cascade do |t|
    t.string "force_push_regex"
    t.string "delete_branch_regex"
    t.string "commit_message_regex"
    t.boolean "deny_delete_tag"
    t.integer "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    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
    t.string "branch_name_regex"
    t.boolean "reject_unsigned_commits"
    t.boolean "commit_committer_check"
    t.boolean "regexp_uses_re2", default: true
    t.string "commit_message_negative_regex"
    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
  end

Jasper Maes's avatar
Jasper Maes committed
2878
  create_table "redirect_routes", id: :serial, force: :cascade do |t|
2879 2880 2881 2882 2883
    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
2884 2885
    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
2886 2887
  end

Jasper Maes's avatar
Jasper Maes committed
2888
  create_table "release_links", force: :cascade do |t|
2889 2890 2891 2892 2893 2894
    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
2895
    t.index ["release_id", "url"], name: "index_release_links_on_release_id_and_url", unique: true, using: :btree
2896 2897
  end

Jasper Maes's avatar
Jasper Maes committed
2898
  create_table "releases", id: :serial, force: :cascade do |t|
2899 2900 2901
    t.string "tag"
    t.text "description"
    t.integer "project_id"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
2902 2903
    t.datetime "created_at"
    t.datetime "updated_at"
2904
    t.text "description_html"
2905
    t.integer "cached_markdown_version"
2906 2907 2908
    t.integer "author_id"
    t.string "name"
    t.string "sha"
2909
    t.datetime_with_timezone "released_at", null: false
2910
    t.index ["author_id"], name: "index_releases_on_author_id", using: :btree
2911 2912
    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
2913 2914
  end

Jasper Maes's avatar
Jasper Maes committed
2915
  create_table "remote_mirrors", id: :serial, force: :cascade do |t|
2916 2917
    t.integer "project_id"
    t.string "url"
2918
    t.boolean "enabled", default: false
2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930
    t.string "update_status"
    t.datetime "last_update_at"
    t.datetime "last_successful_update_at"
    t.datetime "last_update_started_at"
    t.string "last_error"
    t.boolean "only_protected_branches", default: false, null: false
    t.string "remote_name"
    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
2931
    t.boolean "error_notification_sent"
2932 2933
    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
2934 2935
  end

2936 2937 2938 2939
  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
2940
    t.index ["project_id", "programming_language_id"], name: "index_repository_languages_on_project_and_languages_id", unique: true, using: :btree
2941 2942
  end

Jasper Maes's avatar
Jasper Maes committed
2943
  create_table "resource_label_events", force: :cascade do |t|
Jan Provaznik's avatar
Jan Provaznik committed
2944 2945 2946 2947 2948 2949
    t.integer "action", null: false
    t.integer "issue_id"
    t.integer "merge_request_id"
    t.integer "label_id"
    t.integer "user_id"
    t.datetime_with_timezone "created_at", null: false
2950 2951 2952
    t.integer "cached_markdown_version"
    t.text "reference"
    t.text "reference_html"
2953 2954
    t.integer "epic_id"
    t.index ["epic_id"], name: "index_resource_label_events_on_epic_id", using: :btree
2955 2956 2957 2958
    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
Jan Provaznik's avatar
Jan Provaznik committed
2959 2960
  end

2961 2962 2963 2964 2965 2966 2967 2968 2969 2970
  create_table "reviews", 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

Jasper Maes's avatar
Jasper Maes committed
2971
  create_table "routes", id: :serial, force: :cascade do |t|
2972 2973 2974 2975 2976
    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"
2977
    t.string "name"
2978 2979 2980
    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
2981 2982
  end

2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000
  create_table "saml_providers", id: :serial, 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
    t.boolean "enforced_sso", default: false, null: false
    t.boolean "enforced_group_managed_accounts", default: false, null: false
    t.index ["group_id"], name: "index_saml_providers_on_group_id", using: :btree
  end

  create_table "scim_oauth_access_tokens", id: :serial, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "group_id", null: false
    t.string "token_encrypted", null: false
    t.index ["group_id", "token_encrypted"], name: "index_scim_oauth_access_tokens_on_group_id_and_token_encrypted", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
3001
  create_table "sent_notifications", id: :serial, force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
3002 3003
    t.integer "project_id"
    t.integer "noteable_id"
3004
    t.string "noteable_type"
Douwe Maan's avatar
Douwe Maan committed
3005
    t.integer "recipient_id"
3006 3007 3008 3009 3010
    t.string "commit_id"
    t.string "reply_key", null: false
    t.string "line_code"
    t.string "note_type"
    t.text "position"
3011
    t.string "in_reply_to_discussion_id"
3012
    t.index ["reply_key"], name: "index_sent_notifications_on_reply_key", unique: true, using: :btree
Douwe Maan's avatar
Douwe Maan committed
3013 3014
  end

Jasper Maes's avatar
Jasper Maes committed
3015
  create_table "services", id: :serial, force: :cascade do |t|
3016 3017 3018
    t.string "type"
    t.string "title"
    t.integer "project_id"
3019 3020
    t.datetime "created_at"
    t.datetime "updated_at"
3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032 3033
    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
3034
    t.boolean "commit_events", default: true, null: false
3035
    t.boolean "job_events", default: false, null: false
3036
    t.boolean "confidential_note_events", default: true
3037
    t.boolean "deployment_events", default: false, null: false
3038
    t.string "description", limit: 500
3039 3040
    t.index ["project_id"], name: "index_services_on_project_id", using: :btree
    t.index ["template"], name: "index_services_on_template", using: :btree
3041
    t.index ["type"], name: "index_services_on_type", using: :btree
3042 3043
  end

Jasper Maes's avatar
Jasper Maes committed
3044
  create_table "shards", id: :serial, force: :cascade do |t|
3045
    t.string "name", null: false
3046
    t.index ["name"], name: "index_shards_on_name", unique: true, using: :btree
3047 3048
  end

3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068
  create_table "slack_integrations", id: :serial, 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
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    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
  end

  create_table "smartcard_identities", 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

Jasper Maes's avatar
Jasper Maes committed
3069
  create_table "snippets", id: :serial, force: :cascade do |t|
3070 3071 3072 3073
    t.string "title"
    t.text "content"
    t.integer "author_id", null: false
    t.integer "project_id"
3074 3075
    t.datetime "created_at"
    t.datetime "updated_at"
3076 3077 3078 3079 3080
    t.string "file_name"
    t.string "type"
    t.integer "visibility_level", default: 0, null: false
    t.text "title_html"
    t.text "content_html"
3081
    t.integer "cached_markdown_version"
3082 3083
    t.text "description"
    t.text "description_html"
3084 3085 3086 3087 3088 3089
    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
3090 3091
  end

3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104
  create_table "software_license_policies", id: :serial, 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
    t.index ["project_id", "software_license_id"], name: "index_software_license_policies_unique_per_project", unique: true, using: :btree
    t.index ["software_license_id"], name: "index_software_license_policies_on_software_license_id", using: :btree
  end

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

Jasper Maes's avatar
Jasper Maes committed
3105
  create_table "spam_logs", id: :serial, force: :cascade do |t|
3106 3107 3108 3109 3110 3111 3112 3113 3114 3115
    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
3116
    t.boolean "recaptcha_verified", default: false, null: false
3117 3118
  end

Jasper Maes's avatar
Jasper Maes committed
3119
  create_table "subscriptions", id: :serial, force: :cascade do |t|
3120 3121 3122 3123
    t.integer "user_id"
    t.integer "subscribable_id"
    t.string "subscribable_type"
    t.boolean "subscribed"
Valery Sizov's avatar
Valery Sizov committed
3124 3125
    t.datetime "created_at"
    t.datetime "updated_at"
3126
    t.integer "project_id"
3127
    t.index ["project_id"], name: "index_subscriptions_on_project_id", using: :btree
3128
    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
3129 3130
  end

Jasper Maes's avatar
Jasper Maes committed
3131
  create_table "suggestions", force: :cascade do |t|
3132 3133 3134 3135 3136 3137
    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
3138 3139
    t.integer "lines_above", default: 0, null: false
    t.integer "lines_below", default: 0, null: false
3140
    t.boolean "outdated", default: false, null: false
3141 3142 3143
    t.index ["note_id", "relative_order"], name: "index_suggestions_on_note_id_and_relative_order", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
3144
  create_table "system_note_metadata", id: :serial, force: :cascade do |t|
3145 3146
    t.integer "note_id", null: false
    t.integer "commit_count"
3147
    t.string "action"
3148 3149
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3150
    t.index ["note_id"], name: "index_system_note_metadata_on_note_id", unique: true, using: :btree
Valery Sizov's avatar
Valery Sizov committed
3151 3152
  end

Jasper Maes's avatar
Jasper Maes committed
3153
  create_table "taggings", id: :serial, force: :cascade do |t|
3154 3155 3156 3157 3158 3159
    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
3160
    t.datetime "created_at"
3161 3162 3163 3164
    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
3165 3166
  end

Jasper Maes's avatar
Jasper Maes committed
3167
  create_table "tags", id: :serial, force: :cascade do |t|
3168
    t.string "name"
3169
    t.integer "taggings_count", default: 0
3170
    t.index ["name"], name: "index_tags_on_name", unique: true, using: :btree
3171
    t.index ["name"], name: "index_tags_on_name_trigram", using: :gin, opclasses: {"name"=>"gin_trgm_ops"}
Andrew8xx8's avatar
Andrew8xx8 committed
3172 3173
  end

Jasper Maes's avatar
Jasper Maes committed
3174
  create_table "term_agreements", id: :serial, force: :cascade do |t|
3175 3176 3177 3178 3179
    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
3180 3181 3182
    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
3183 3184
  end

Jasper Maes's avatar
Jasper Maes committed
3185
  create_table "timelogs", id: :serial, force: :cascade do |t|
3186 3187 3188 3189
    t.integer "time_spent", null: false
    t.integer "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3190 3191
    t.integer "issue_id"
    t.integer "merge_request_id"
3192
    t.datetime_with_timezone "spent_at"
3193 3194 3195
    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
3196 3197
  end

Jasper Maes's avatar
Jasper Maes committed
3198
  create_table "todos", id: :serial, force: :cascade do |t|
3199
    t.integer "user_id", null: false
3200
    t.integer "project_id"
3201 3202
    t.integer "target_id"
    t.string "target_type", null: false
3203
    t.integer "author_id", null: false
3204 3205
    t.integer "action", null: false
    t.string "state", null: false
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
3206 3207
    t.datetime "created_at"
    t.datetime "updated_at"
3208 3209
    t.integer "note_id"
    t.string "commit_id"
3210
    t.integer "group_id"
3211 3212 3213 3214 3215 3216 3217 3218 3219
    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
3220 3221
  end

Jasper Maes's avatar
Jasper Maes committed
3222
  create_table "trending_projects", id: :serial, force: :cascade do |t|
3223
    t.integer "project_id", null: false
3224
    t.index ["project_id"], name: "index_trending_projects_on_project_id", unique: true, using: :btree
3225 3226
  end

Jasper Maes's avatar
Jasper Maes committed
3227
  create_table "u2f_registrations", id: :serial, force: :cascade do |t|
3228 3229 3230 3231 3232 3233 3234 3235
    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"
3236 3237
    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
3238 3239
  end

Jasper Maes's avatar
Jasper Maes committed
3240
  create_table "uploads", id: :serial, force: :cascade do |t|
3241
    t.bigint "size", null: false
3242
    t.string "path", limit: 511, null: false
3243 3244 3245 3246 3247
    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
3248 3249
    t.string "mount_point"
    t.string "secret"
3250
    t.integer "store"
3251 3252 3253 3254
    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
3255 3256
  end

Jasper Maes's avatar
Jasper Maes committed
3257
  create_table "user_agent_details", id: :serial, force: :cascade do |t|
3258 3259 3260 3261 3262 3263 3264
    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
3265
    t.index ["subject_id", "subject_type"], name: "index_user_agent_details_on_subject_id_and_subject_type", using: :btree
3266 3267
  end

Jasper Maes's avatar
Jasper Maes committed
3268
  create_table "user_callouts", id: :serial, force: :cascade do |t|
3269
    t.integer "feature_name", null: false
3270
    t.integer "user_id", null: false
3271 3272
    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
3273 3274
  end

Jasper Maes's avatar
Jasper Maes committed
3275
  create_table "user_custom_attributes", id: :serial, force: :cascade do |t|
3276 3277
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
3278 3279 3280
    t.integer "user_id", null: false
    t.string "key", null: false
    t.string "value", null: false
3281 3282
    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
3283 3284
  end

3285 3286 3287
  create_table "user_interacted_projects", id: false, force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "project_id", null: false
3288 3289
    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
3290 3291
  end

Jasper Maes's avatar
Jasper Maes committed
3292
  create_table "user_preferences", id: :serial, force: :cascade do |t|
3293 3294 3295 3296 3297
    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
3298
    t.integer "first_day_of_week"
3299 3300
    t.string "issues_sort"
    t.string "merge_requests_sort"
3301 3302 3303
    t.string "timezone"
    t.boolean "time_display_relative"
    t.boolean "time_format_in_24h"
3304 3305 3306 3307
    t.integer "epic_notes_filter", limit: 2, default: 0, null: false
    t.string "epics_sort"
    t.integer "roadmap_epics_state"
    t.string "roadmaps_sort"
3308
    t.index ["user_id"], name: "index_user_preferences_on_user_id", unique: true, using: :btree
3309 3310
  end

Jasper Maes's avatar
Jasper Maes committed
3311
  create_table "user_statuses", primary_key: "user_id", id: :serial, force: :cascade do |t|
3312 3313 3314 3315
    t.integer "cached_markdown_version"
    t.string "emoji", default: "speech_balloon", null: false
    t.string "message", limit: 100
    t.string "message_html"
3316
    t.index ["user_id"], name: "index_user_statuses_on_user_id", using: :btree
3317 3318
  end

Jasper Maes's avatar
Jasper Maes committed
3319
  create_table "user_synced_attributes_metadata", id: :serial, force: :cascade do |t|
3320 3321 3322 3323 3324
    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"
3325
    t.index ["user_id"], name: "index_user_synced_attributes_metadata_on_user_id", unique: true, using: :btree
3326 3327
  end

Jasper Maes's avatar
Jasper Maes committed
3328
  create_table "users", id: :serial, force: :cascade do |t|
3329 3330 3331
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
Andrew8xx8's avatar
Andrew8xx8 committed
3332 3333
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
3334
    t.integer "sign_in_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
3335 3336
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
3337 3338
    t.string "current_sign_in_ip"
    t.string "last_sign_in_ip"
3339 3340
    t.datetime "created_at"
    t.datetime "updated_at"
3341 3342
    t.string "name"
    t.boolean "admin", default: false, null: false
3343
    t.integer "projects_limit", null: false
3344 3345 3346 3347 3348
    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
3349
    t.datetime "locked_at"
3350 3351 3352 3353 3354
    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
3355
    t.datetime "password_expires_at"
3356
    t.integer "created_by_id"
3357
    t.datetime "last_credential_check_at"
3358 3359
    t.string "avatar"
    t.string "confirmation_token"
3360 3361
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373 3374 3375 3376 3377 3378 3379 3380
    t.string "unconfirmed_email"
    t.boolean "hide_no_ssh_key", default: false
    t.string "website_url", default: "", null: false
    t.string "notification_email"
    t.boolean "hide_no_password", default: false
    t.boolean "password_automatically_set", default: false
    t.string "location"
    t.string "encrypted_otp_secret"
    t.string "encrypted_otp_secret_iv"
    t.string "encrypted_otp_secret_salt"
    t.boolean "otp_required_for_login", default: false, null: false
    t.text "otp_backup_codes"
    t.string "public_email", default: "", null: false
    t.integer "dashboard", default: 0
    t.integer "project_view", default: 0
    t.integer "consumed_timestep"
    t.integer "layout", default: 0
    t.boolean "hide_project_limit", default: false
    t.string "unlock_token"
3381
    t.datetime "otp_grace_period_started_at"
3382
    t.boolean "external", default: false
Nick Thomas's avatar
Nick Thomas committed
3383
    t.string "incoming_email_token"
3384
    t.string "organization"
3385 3386
    t.boolean "require_two_factor_authentication_from_group", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
3387
    t.boolean "ghost"
3388
    t.date "last_activity_on"
3389
    t.boolean "notified_of_own_activity"
3390
    t.string "preferred_language"
3391
    t.integer "theme_id", limit: 2
3392
    t.integer "accepted_term_id"
3393
    t.string "feed_token"
3394
    t.boolean "private_profile"
3395
    t.boolean "include_private_contributions"
3396
    t.string "commit_email"
3397 3398 3399 3400 3401 3402 3403 3404 3405 3406 3407
    t.boolean "auditor", default: false, null: false
    t.datetime "admin_email_unsubscribed_at"
    t.boolean "email_opted_in"
    t.datetime "email_opted_in_at"
    t.string "email_opted_in_ip"
    t.integer "email_opted_in_source_id"
    t.integer "group_view"
    t.integer "managing_group_id"
    t.text "note"
    t.integer "roadmap_layout", limit: 2
    t.integer "bot_type", limit: 2
3408
    t.index ["accepted_term_id"], name: "index_users_on_accepted_term_id", using: :btree
3409
    t.index ["admin"], name: "index_users_on_admin", using: :btree
3410
    t.index ["bot_type"], name: "index_users_on_bot_type", using: :btree
3411 3412 3413 3414 3415 3416
    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
3417
    t.index ["group_view"], name: "index_users_on_group_view", using: :btree
3418
    t.index ["incoming_email_token"], name: "index_users_on_incoming_email_token", using: :btree
3419
    t.index ["managing_group_id"], name: "index_users_on_managing_group_id", using: :btree
3420 3421
    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"}
3422
    t.index ["public_email"], name: "index_users_on_public_email", where: "((public_email)::text <> ''::text)", using: :btree
3423 3424
    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
3425
    t.index ["state"], name: "index_users_on_state_and_internal", where: "((ghost <> true) AND (bot_type IS NULL))", using: :btree
3426 3427
    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
3428 3429
  end

3430 3431 3432 3433 3434 3435 3436 3437 3438
  create_table "users_ops_dashboard_projects", 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
    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
  end

Jasper Maes's avatar
Jasper Maes committed
3439
  create_table "users_star_projects", id: :serial, force: :cascade do |t|
3440 3441
    t.integer "project_id", null: false
    t.integer "user_id", null: false
Ciro Santilli's avatar
Ciro Santilli committed
3442 3443
    t.datetime "created_at"
    t.datetime "updated_at"
3444 3445
    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
3446 3447
  end

3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507 3508 3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527 3528 3529
  create_table "vulnerability_feedback", id: :serial, 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
    t.integer "merge_request_id"
    t.integer "comment_author_id"
    t.text "comment"
    t.datetime_with_timezone "comment_timestamp"
    t.index ["author_id"], name: "index_vulnerability_feedback_on_author_id", using: :btree
    t.index ["comment_author_id"], name: "index_vulnerability_feedback_on_comment_author_id", using: :btree
    t.index ["issue_id"], name: "index_vulnerability_feedback_on_issue_id", using: :btree
    t.index ["merge_request_id"], name: "index_vulnerability_feedback_on_merge_request_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
  end

  create_table "vulnerability_identifiers", 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"
    t.index ["project_id", "fingerprint"], name: "index_vulnerability_identifiers_on_project_id_and_fingerprint", unique: true, using: :btree
  end

  create_table "vulnerability_occurrence_identifiers", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    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
  end

  create_table "vulnerability_occurrence_pipelines", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "occurrence_id", null: false
    t.integer "pipeline_id", null: false
    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
  end

  create_table "vulnerability_occurrences", 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
    t.bigint "scanner_id", null: false
    t.bigint "primary_identifier_id", null: false
    t.binary "project_fingerprint", null: false
    t.binary "location_fingerprint", null: false
    t.string "uuid", limit: 36, null: false
    t.string "name", null: false
    t.string "metadata_version", null: false
    t.text "raw_metadata", null: false
    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
  end

  create_table "vulnerability_scanners", 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
    t.index ["project_id", "external_id"], name: "index_vulnerability_scanners_on_project_id_and_external_id", unique: true, using: :btree
  end

Jasper Maes's avatar
Jasper Maes committed
3530
  create_table "web_hook_logs", id: :serial, force: :cascade do |t|
3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542
    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
3543 3544
    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
3545 3546
  end

Jasper Maes's avatar
Jasper Maes committed
3547
  create_table "web_hooks", id: :serial, force: :cascade do |t|
3548
    t.integer "project_id"
3549 3550
    t.datetime "created_at"
    t.datetime "updated_at"
3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561
    t.string "type", default: "ProjectHook"
    t.integer "service_id"
    t.boolean "push_events", default: true, null: false
    t.boolean "issues_events", default: false, null: false
    t.boolean "merge_requests_events", default: false, null: false
    t.boolean "tag_push_events", default: false
    t.boolean "note_events", default: false, null: false
    t.boolean "enable_ssl_verification", default: true
    t.boolean "wiki_page_events", default: false, null: false
    t.boolean "pipeline_events", default: false, null: false
    t.boolean "confidential_issues_events", default: false, null: false
3562
    t.boolean "repository_update_events", default: false, null: false
Luke "Jared" Bennett's avatar
Luke "Jared" Bennett committed
3563
    t.boolean "job_events", default: false, null: false
3564
    t.boolean "confidential_note_events"
3565
    t.text "push_events_branch_filter"
3566 3567 3568 3569
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
    t.string "encrypted_url"
    t.string "encrypted_url_iv"
3570
    t.integer "group_id"
3571 3572
    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
3573 3574
  end

3575 3576
  add_foreign_key "application_settings", "namespaces", column: "custom_project_templates_group_id", on_delete: :nullify
  add_foreign_key "application_settings", "projects", column: "file_template_project_id", name: "fk_ec757bd087", on_delete: :nullify
3577
  add_foreign_key "application_settings", "users", column: "usage_stats_set_by_user_id", name: "fk_964370041d", on_delete: :nullify
3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593
  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
  add_foreign_key "approval_merge_request_rules", "merge_requests", on_delete: :cascade
  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
  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
  add_foreign_key "approvals", "merge_requests", name: "fk_310d714958", on_delete: :cascade
  add_foreign_key "approver_groups", "namespaces", column: "group_id", on_delete: :cascade
3594 3595
  add_foreign_key "badges", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "badges", "projects", on_delete: :cascade
3596 3597
  add_foreign_key "board_assignees", "boards", on_delete: :cascade
  add_foreign_key "board_assignees", "users", column: "assignee_id", on_delete: :cascade
3598 3599 3600
  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
3601 3602
  add_foreign_key "board_labels", "boards", on_delete: :cascade
  add_foreign_key "board_labels", "labels", on_delete: :cascade
3603 3604 3605
  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
3606
  add_foreign_key "boards", "namespaces", column: "group_id", on_delete: :cascade
3607
  add_foreign_key "boards", "projects", name: "fk_f15266b5f9", on_delete: :cascade
3608
  add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
3609
  add_foreign_key "ci_build_trace_chunks", "ci_builds", column: "build_id", on_delete: :cascade
3610 3611 3612 3613
  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
3614
  add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
3615
  add_foreign_key "ci_builds", "ci_pipelines", column: "commit_id", name: "fk_d3130c9a7f", on_delete: :cascade
3616
  add_foreign_key "ci_builds", "ci_pipelines", column: "upstream_pipeline_id", name: "fk_87f4cefcda", on_delete: :cascade
3617
  add_foreign_key "ci_builds", "ci_stages", column: "stage_id", name: "fk_3a9eaa254d", on_delete: :cascade
3618
  add_foreign_key "ci_builds", "projects", name: "fk_befce0568a", on_delete: :cascade
3619
  add_foreign_key "ci_builds_metadata", "ci_builds", column: "build_id", on_delete: :cascade
3620
  add_foreign_key "ci_builds_metadata", "projects", on_delete: :cascade
3621
  add_foreign_key "ci_builds_runner_session", "ci_builds", column: "build_id", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
3622
  add_foreign_key "ci_group_variables", "namespaces", column: "group_id", name: "fk_33ae4d58d8", on_delete: :cascade
3623
  add_foreign_key "ci_job_artifacts", "ci_builds", column: "job_id", on_delete: :cascade
3624
  add_foreign_key "ci_job_artifacts", "projects", on_delete: :cascade
3625 3626
  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
3627
  add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade
3628
  add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade
3629
  add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify
Shinya Maeda's avatar
init  
Shinya Maeda committed
3630
  add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade
3631
  add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify
3632
  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
3633
  add_foreign_key "ci_pipelines", "merge_requests", name: "fk_a23be95014", on_delete: :cascade
3634
  add_foreign_key "ci_pipelines", "projects", name: "fk_86635dbd80", on_delete: :cascade
3635
  add_foreign_key "ci_runner_namespaces", "ci_runners", column: "runner_id", on_delete: :cascade
3636
  add_foreign_key "ci_runner_namespaces", "namespaces", on_delete: :cascade
3637
  add_foreign_key "ci_runner_projects", "projects", name: "fk_4478a6f1e4", on_delete: :cascade
3638 3639 3640 3641 3642
  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
3643
  add_foreign_key "ci_stages", "ci_pipelines", column: "pipeline_id", name: "fk_fb57e6cc56", on_delete: :cascade
3644
  add_foreign_key "ci_stages", "projects", name: "fk_2360681d1d", on_delete: :cascade
3645
  add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
3646
  add_foreign_key "ci_triggers", "projects", name: "fk_e3e63f966e", on_delete: :cascade
3647
  add_foreign_key "ci_triggers", "users", column: "owner_id", name: "fk_e8e10d1964", on_delete: :cascade
3648
  add_foreign_key "ci_variables", "projects", name: "fk_ada5eb64b3", on_delete: :cascade
3649 3650
  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
3651 3652 3653 3654 3655
  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
3656
  add_foreign_key "clusters_applications_cert_managers", "clusters", on_delete: :cascade
3657
  add_foreign_key "clusters_applications_helm", "clusters", on_delete: :cascade
3658
  add_foreign_key "clusters_applications_ingress", "clusters", name: "fk_753a7b41c1", on_delete: :cascade
3659 3660
  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
3661
  add_foreign_key "clusters_applications_knative", "clusters", on_delete: :cascade
3662
  add_foreign_key "clusters_applications_prometheus", "clusters", name: "fk_557e773639", on_delete: :cascade
3663 3664
  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
3665 3666 3667
  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
3668
  add_foreign_key "container_repositories", "projects"
3669 3670
  add_foreign_key "dependency_proxy_blobs", "namespaces", column: "group_id", name: "fk_db58bbc5d7", on_delete: :cascade
  add_foreign_key "dependency_proxy_group_settings", "namespaces", column: "group_id", name: "fk_616ddd680a", on_delete: :cascade
3671
  add_foreign_key "deploy_keys_projects", "projects", name: "fk_58a901ca7e", on_delete: :cascade
3672
  add_foreign_key "deployments", "clusters", name: "fk_289bba3222", on_delete: :nullify
3673
  add_foreign_key "deployments", "projects", name: "fk_b9a3851b82", on_delete: :cascade
3674 3675 3676 3677 3678 3679 3680 3681
  add_foreign_key "design_management_designs", "issues", on_delete: :cascade
  add_foreign_key "design_management_designs", "projects", on_delete: :cascade
  add_foreign_key "design_management_designs_versions", "design_management_designs", column: "design_id", name: "fk_03c671965c", on_delete: :cascade
  add_foreign_key "design_management_designs_versions", "design_management_versions", column: "version_id", name: "fk_f4d25ba00c", on_delete: :cascade
  add_foreign_key "draft_notes", "merge_requests", on_delete: :cascade
  add_foreign_key "draft_notes", "users", column: "author_id", on_delete: :cascade
  add_foreign_key "elasticsearch_indexed_namespaces", "namespaces", on_delete: :cascade
  add_foreign_key "elasticsearch_indexed_projects", "projects", on_delete: :cascade
3682
  add_foreign_key "environments", "projects", name: "fk_d1c8c1da6a", on_delete: :cascade
3683 3684 3685 3686 3687 3688 3689 3690 3691
  add_foreign_key "epic_issues", "epics", on_delete: :cascade
  add_foreign_key "epic_issues", "issues", on_delete: :cascade
  add_foreign_key "epic_metrics", "epics", on_delete: :cascade
  add_foreign_key "epics", "epics", column: "parent_id", name: "fk_25b99c1be3", on_delete: :cascade
  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
  add_foreign_key "epics", "users", column: "closed_by_id", name: "fk_aa5798e761", on_delete: :nullify
3692 3693
  add_foreign_key "events", "projects", on_delete: :cascade
  add_foreign_key "events", "users", column: "author_id", name: "fk_edfd187b6f", on_delete: :cascade
3694 3695 3696
  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
3697
  add_foreign_key "fork_networks", "projects", column: "root_project_id", name: "fk_e7b436b2b5", on_delete: :nullify
3698
  add_foreign_key "forked_project_links", "projects", column: "forked_to_project_id", name: "fk_434510edb0", on_delete: :cascade
3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721
  add_foreign_key "geo_event_log", "geo_cache_invalidation_events", column: "cache_invalidation_event_id", name: "fk_42c3b54bed", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_hashed_storage_migrated_events", column: "hashed_storage_migrated_event_id", name: "fk_27548c6db3", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_job_artifact_deleted_events", column: "job_artifact_deleted_event_id", name: "fk_176d3fbb5d", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_lfs_object_deleted_events", column: "lfs_object_deleted_event_id", name: "fk_d5af95fcd9", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_repositories_changed_events", column: "repositories_changed_event_id", name: "fk_4a99ebfd60", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_repository_created_events", column: "repository_created_event_id", name: "fk_9b9afb1916", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_repository_deleted_events", column: "repository_deleted_event_id", name: "fk_c4b1c1f66e", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_repository_renamed_events", column: "repository_renamed_event_id", name: "fk_86c84214ec", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_repository_updated_events", column: "repository_updated_event_id", name: "fk_78a6492f68", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_reset_checksum_events", column: "reset_checksum_event_id", name: "fk_cff7185ad2", on_delete: :cascade
  add_foreign_key "geo_event_log", "geo_upload_deleted_events", column: "upload_deleted_event_id", name: "fk_c1f241c70d", on_delete: :cascade
  add_foreign_key "geo_hashed_storage_attachments_events", "projects", on_delete: :cascade
  add_foreign_key "geo_hashed_storage_migrated_events", "projects", on_delete: :cascade
  add_foreign_key "geo_node_namespace_links", "geo_nodes", on_delete: :cascade
  add_foreign_key "geo_node_namespace_links", "namespaces", on_delete: :cascade
  add_foreign_key "geo_node_statuses", "geo_nodes", on_delete: :cascade
  add_foreign_key "geo_repositories_changed_events", "geo_nodes", on_delete: :cascade
  add_foreign_key "geo_repository_created_events", "projects", on_delete: :cascade
  add_foreign_key "geo_repository_renamed_events", "projects", on_delete: :cascade
  add_foreign_key "geo_repository_updated_events", "projects", on_delete: :cascade
  add_foreign_key "geo_reset_checksum_events", "projects", on_delete: :cascade
  add_foreign_key "gitlab_subscriptions", "namespaces", name: "fk_e2595d00a1", on_delete: :cascade
  add_foreign_key "gitlab_subscriptions", "plans", column: "hosted_plan_id", name: "fk_bd0c4019c3", on_delete: :cascade
3722
  add_foreign_key "gpg_key_subkeys", "gpg_keys", on_delete: :cascade
3723
  add_foreign_key "gpg_keys", "users", on_delete: :cascade
3724
  add_foreign_key "gpg_signatures", "gpg_key_subkeys", on_delete: :nullify
3725 3726
  add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify
  add_foreign_key "gpg_signatures", "projects", on_delete: :cascade
3727
  add_foreign_key "group_custom_attributes", "namespaces", column: "group_id", on_delete: :cascade
3728
  add_foreign_key "identities", "saml_providers", name: "fk_aade90f0fc", on_delete: :cascade
3729
  add_foreign_key "import_export_uploads", "projects", on_delete: :cascade
3730 3731 3732
  add_foreign_key "index_statuses", "projects", name: "fk_74b2492545", on_delete: :cascade
  add_foreign_key "insights", "namespaces", on_delete: :cascade
  add_foreign_key "insights", "projects", on_delete: :cascade
3733
  add_foreign_key "internal_ids", "namespaces", name: "fk_162941d509", on_delete: :cascade
3734
  add_foreign_key "internal_ids", "projects", on_delete: :cascade
3735
  add_foreign_key "ip_restrictions", "namespaces", column: "group_id", on_delete: :cascade
3736 3737
  add_foreign_key "issue_assignees", "issues", name: "fk_b7d881734a", on_delete: :cascade
  add_foreign_key "issue_assignees", "users", name: "fk_5e0c8d9154", on_delete: :cascade
3738 3739
  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
Timothy Andrew's avatar
Timothy Andrew committed
3740
  add_foreign_key "issue_metrics", "issues", on_delete: :cascade
3741
  add_foreign_key "issue_tracker_data", "services", on_delete: :cascade
3742 3743
  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
3744
  add_foreign_key "issues", "projects", name: "fk_899c8f3231", on_delete: :cascade
3745
  add_foreign_key "issues", "users", column: "author_id", name: "fk_05f1e72feb", on_delete: :nullify
haseeb's avatar
haseeb committed
3746
  add_foreign_key "issues", "users", column: "closed_by_id", name: "fk_c63cbf6c25", on_delete: :nullify
3747
  add_foreign_key "issues", "users", column: "updated_by_id", name: "fk_ffed080f01", on_delete: :nullify
3748 3749
  add_foreign_key "jira_connect_subscriptions", "jira_connect_installations", name: "fk_f1d617343f", on_delete: :cascade
  add_foreign_key "jira_connect_subscriptions", "namespaces", name: "fk_a3c10bcf7d", on_delete: :cascade
3750
  add_foreign_key "jira_tracker_data", "services", on_delete: :cascade
Stan Hu's avatar
Stan Hu committed
3751
  add_foreign_key "label_links", "labels", name: "fk_d97dd08678", on_delete: :cascade
3752 3753
  add_foreign_key "label_priorities", "labels", on_delete: :cascade
  add_foreign_key "label_priorities", "projects", on_delete: :cascade
3754
  add_foreign_key "labels", "namespaces", column: "group_id", on_delete: :cascade
3755
  add_foreign_key "labels", "projects", name: "fk_7de4989a69", on_delete: :cascade
3756 3757
  add_foreign_key "lfs_file_locks", "projects", on_delete: :cascade
  add_foreign_key "lfs_file_locks", "users", on_delete: :cascade
3758 3759
  add_foreign_key "lists", "boards", name: "fk_0d3f677137", on_delete: :cascade
  add_foreign_key "lists", "labels", name: "fk_7a5553d60f", on_delete: :cascade
3760 3761
  add_foreign_key "lists", "milestones", on_delete: :cascade
  add_foreign_key "lists", "users", name: "fk_d6cf4279f7", on_delete: :cascade
3762
  add_foreign_key "members", "users", name: "fk_2e88fb7ce9", on_delete: :cascade
3763 3764
  add_foreign_key "merge_request_assignees", "merge_requests", on_delete: :cascade
  add_foreign_key "merge_request_assignees", "users", on_delete: :cascade
3765 3766
  add_foreign_key "merge_request_blocks", "merge_requests", column: "blocked_merge_request_id", on_delete: :cascade
  add_foreign_key "merge_request_blocks", "merge_requests", column: "blocking_merge_request_id", on_delete: :cascade
3767
  add_foreign_key "merge_request_diff_commits", "merge_request_diffs", on_delete: :cascade
3768
  add_foreign_key "merge_request_diff_files", "merge_request_diffs", on_delete: :cascade
3769
  add_foreign_key "merge_request_diffs", "merge_requests", name: "fk_8483f3258f", on_delete: :cascade
3770
  add_foreign_key "merge_request_metrics", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
3771
  add_foreign_key "merge_request_metrics", "merge_requests", on_delete: :cascade
3772 3773
  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
3774
  add_foreign_key "merge_requests", "ci_pipelines", column: "head_pipeline_id", name: "fk_fd82eae0b9", on_delete: :nullify
3775
  add_foreign_key "merge_requests", "merge_request_diffs", column: "latest_merge_request_diff_id", name: "fk_06067f5644", on_delete: :nullify
3776 3777
  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
3778
  add_foreign_key "merge_requests", "projects", column: "target_project_id", name: "fk_a6963e8447", on_delete: :cascade
3779 3780 3781 3782
  add_foreign_key "merge_requests", "users", column: "assignee_id", name: "fk_6149611a04", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "author_id", name: "fk_e719a85f8a", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "merge_user_id", name: "fk_ad525e1f87", on_delete: :nullify
  add_foreign_key "merge_requests", "users", column: "updated_by_id", name: "fk_641731faff", on_delete: :nullify
Timothy Andrew's avatar
Timothy Andrew committed
3783 3784
  add_foreign_key "merge_requests_closing_issues", "issues", on_delete: :cascade
  add_foreign_key "merge_requests_closing_issues", "merge_requests", on_delete: :cascade
3785 3786
  add_foreign_key "merge_trains", "ci_pipelines", column: "pipeline_id", on_delete: :nullify
  add_foreign_key "merge_trains", "merge_requests", on_delete: :cascade
3787
  add_foreign_key "merge_trains", "projects", column: "target_project_id", on_delete: :cascade
3788
  add_foreign_key "merge_trains", "users", on_delete: :cascade
Felipe Artur's avatar
Felipe Artur committed
3789
  add_foreign_key "milestones", "namespaces", column: "group_id", name: "fk_95650a40d4", on_delete: :cascade
3790
  add_foreign_key "milestones", "projects", name: "fk_9bd0a0c791", on_delete: :cascade
3791 3792
  add_foreign_key "namespace_aggregation_schedules", "namespaces", on_delete: :cascade
  add_foreign_key "namespace_root_storage_statistics", "namespaces", on_delete: :cascade
3793 3794 3795 3796
  add_foreign_key "namespace_statistics", "namespaces", on_delete: :cascade
  add_foreign_key "namespaces", "namespaces", column: "custom_project_templates_group_id", name: "fk_e7a0b20a6b", on_delete: :nullify
  add_foreign_key "namespaces", "plans", name: "fk_fdd12e5b80", on_delete: :nullify
  add_foreign_key "namespaces", "projects", column: "file_template_project_id", name: "fk_319256d87a", on_delete: :nullify
3797
  add_foreign_key "note_diff_files", "notes", column: "diff_note_id", on_delete: :cascade
3798
  add_foreign_key "notes", "projects", name: "fk_99e097b079", on_delete: :cascade
3799
  add_foreign_key "notes", "reviews", name: "fk_2e82291620", on_delete: :nullify
3800
  add_foreign_key "notification_settings", "users", name: "fk_0c95e91db7", on_delete: :cascade
3801
  add_foreign_key "oauth_openid_requests", "oauth_access_grants", column: "access_grant_id", name: "fk_oauth_openid_requests_oauth_access_grants_access_grant_id"
3802 3803 3804 3805 3806 3807
  add_foreign_key "operations_feature_flag_scopes", "operations_feature_flags", column: "feature_flag_id", on_delete: :cascade
  add_foreign_key "operations_feature_flags", "projects", on_delete: :cascade
  add_foreign_key "operations_feature_flags_clients", "projects", on_delete: :cascade
  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
  add_foreign_key "packages_packages", "projects", on_delete: :cascade
3808
  add_foreign_key "pages_domain_acme_orders", "pages_domains", on_delete: :cascade
3809
  add_foreign_key "pages_domains", "projects", name: "fk_ea2f6dfc6f", on_delete: :cascade
3810 3811
  add_foreign_key "path_locks", "projects", name: "fk_5265c98f24", on_delete: :cascade
  add_foreign_key "path_locks", "users"
3812
  add_foreign_key "personal_access_tokens", "users"
3813
  add_foreign_key "pool_repositories", "projects", column: "source_project_id", on_delete: :nullify
3814
  add_foreign_key "pool_repositories", "shards", on_delete: :restrict
3815
  add_foreign_key "project_alerting_settings", "projects", on_delete: :cascade
3816
  add_foreign_key "project_aliases", "projects", on_delete: :cascade
3817 3818
  add_foreign_key "project_authorizations", "projects", on_delete: :cascade
  add_foreign_key "project_authorizations", "users", on_delete: :cascade
3819
  add_foreign_key "project_auto_devops", "projects", on_delete: :cascade
3820
  add_foreign_key "project_ci_cd_settings", "projects", name: "fk_24c15d2f2e", on_delete: :cascade
3821
  add_foreign_key "project_custom_attributes", "projects", on_delete: :cascade
3822
  add_foreign_key "project_daily_statistics", "projects", on_delete: :cascade
3823 3824
  add_foreign_key "project_deploy_tokens", "deploy_tokens", on_delete: :cascade
  add_foreign_key "project_deploy_tokens", "projects", on_delete: :cascade
3825
  add_foreign_key "project_error_tracking_settings", "projects", on_delete: :cascade
3826
  add_foreign_key "project_feature_usages", "projects", on_delete: :cascade
3827 3828 3829
  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
3830
  add_foreign_key "project_incident_management_settings", "projects", on_delete: :cascade
3831
  add_foreign_key "project_metrics_settings", "projects", on_delete: :cascade
3832
  add_foreign_key "project_mirror_data", "projects", on_delete: :cascade
3833 3834
  add_foreign_key "project_repositories", "projects", on_delete: :cascade
  add_foreign_key "project_repositories", "shards", on_delete: :restrict
3835
  add_foreign_key "project_repository_states", "projects", on_delete: :cascade
3836
  add_foreign_key "project_statistics", "projects", on_delete: :cascade
3837
  add_foreign_key "project_tracing_settings", "projects", on_delete: :cascade
3838
  add_foreign_key "projects", "pool_repositories", name: "fk_6e5c14658a", on_delete: :nullify
3839 3840 3841 3842 3843
  add_foreign_key "prometheus_alert_events", "projects", on_delete: :cascade
  add_foreign_key "prometheus_alert_events", "prometheus_alerts", on_delete: :cascade
  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
3844
  add_foreign_key "prometheus_metrics", "projects", on_delete: :cascade
3845
  add_foreign_key "protected_branch_merge_access_levels", "namespaces", column: "group_id", name: "fk_98f3d044fe", on_delete: :cascade
3846
  add_foreign_key "protected_branch_merge_access_levels", "protected_branches", name: "fk_8a3072ccb3", on_delete: :cascade
3847 3848
  add_foreign_key "protected_branch_merge_access_levels", "users"
  add_foreign_key "protected_branch_push_access_levels", "namespaces", column: "group_id", name: "fk_7111b68cdb", on_delete: :cascade
3849
  add_foreign_key "protected_branch_push_access_levels", "protected_branches", name: "fk_9ffc86a3d9", on_delete: :cascade
3850 3851 3852 3853
  add_foreign_key "protected_branch_push_access_levels", "users"
  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
3854
  add_foreign_key "protected_branches", "projects", name: "fk_7a9c6d93e7", on_delete: :cascade
3855 3856 3857 3858 3859
  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
  add_foreign_key "protected_tag_create_access_levels", "namespaces", column: "group_id", name: "fk_b4eb82fe3c", on_delete: :cascade
3860
  add_foreign_key "protected_tag_create_access_levels", "protected_tags", name: "fk_f7dfda8c51", on_delete: :cascade
3861
  add_foreign_key "protected_tag_create_access_levels", "users"
3862
  add_foreign_key "protected_tags", "projects", name: "fk_8e4af87648", on_delete: :cascade
3863
  add_foreign_key "push_event_payloads", "events", name: "fk_36c74129da", on_delete: :cascade
3864
  add_foreign_key "push_rules", "projects", name: "fk_83b29894de", on_delete: :cascade
3865
  add_foreign_key "release_links", "releases", on_delete: :cascade
3866
  add_foreign_key "releases", "projects", name: "fk_47fe2a0596", on_delete: :cascade
3867
  add_foreign_key "releases", "users", column: "author_id", name: "fk_8e4456f90f", on_delete: :nullify
3868
  add_foreign_key "remote_mirrors", "projects", on_delete: :cascade
3869
  add_foreign_key "repository_languages", "projects", on_delete: :cascade
3870
  add_foreign_key "resource_label_events", "epics", on_delete: :cascade
Jan Provaznik's avatar
Jan Provaznik committed
3871 3872 3873 3874
  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
3875 3876 3877 3878 3879
  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
  add_foreign_key "saml_providers", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "scim_oauth_access_tokens", "namespaces", column: "group_id", on_delete: :cascade
3880
  add_foreign_key "services", "projects", name: "fk_71cce407f9", on_delete: :cascade
3881 3882
  add_foreign_key "slack_integrations", "services", on_delete: :cascade
  add_foreign_key "smartcard_identities", "users", on_delete: :cascade
3883
  add_foreign_key "snippets", "projects", name: "fk_be41fd4bb7", on_delete: :cascade
3884 3885
  add_foreign_key "software_license_policies", "projects", on_delete: :cascade
  add_foreign_key "software_license_policies", "software_licenses", on_delete: :cascade
3886
  add_foreign_key "subscriptions", "projects", on_delete: :cascade
3887
  add_foreign_key "suggestions", "notes", on_delete: :cascade
3888
  add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade
3889 3890
  add_foreign_key "term_agreements", "application_setting_terms", column: "term_id"
  add_foreign_key "term_agreements", "users", on_delete: :cascade
3891 3892
  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
3893
  add_foreign_key "todos", "namespaces", column: "group_id", on_delete: :cascade
3894
  add_foreign_key "todos", "notes", name: "fk_91d1f47b13", on_delete: :cascade
3895
  add_foreign_key "todos", "projects", name: "fk_45054f9c45", on_delete: :cascade
3896 3897
  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
3898
  add_foreign_key "trending_projects", "projects", on_delete: :cascade
3899
  add_foreign_key "u2f_registrations", "users"
3900
  add_foreign_key "user_callouts", "users", on_delete: :cascade
3901
  add_foreign_key "user_custom_attributes", "users", on_delete: :cascade
3902 3903
  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
3904
  add_foreign_key "user_preferences", "users", on_delete: :cascade
3905
  add_foreign_key "user_statuses", "users", on_delete: :cascade
3906
  add_foreign_key "user_synced_attributes_metadata", "users", on_delete: :cascade
3907
  add_foreign_key "users", "application_setting_terms", column: "accepted_term_id", name: "fk_789cd90b35", on_delete: :cascade
3908 3909 3910
  add_foreign_key "users", "namespaces", column: "managing_group_id", name: "fk_a4b8fefe3e", on_delete: :nullify
  add_foreign_key "users_ops_dashboard_projects", "projects", on_delete: :cascade
  add_foreign_key "users_ops_dashboard_projects", "users", on_delete: :cascade
3911
  add_foreign_key "users_star_projects", "projects", name: "fk_22cd27ddfc", on_delete: :cascade
3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926
  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", "merge_requests", name: "fk_563ff1912e", on_delete: :nullify
  add_foreign_key "vulnerability_feedback", "projects", on_delete: :cascade
  add_foreign_key "vulnerability_feedback", "users", column: "author_id", on_delete: :cascade
  add_foreign_key "vulnerability_feedback", "users", column: "comment_author_id", name: "fk_94f7c8a81e", on_delete: :nullify
  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
  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
  add_foreign_key "vulnerability_occurrences", "projects", on_delete: :cascade
  add_foreign_key "vulnerability_occurrences", "vulnerability_identifiers", column: "primary_identifier_id", on_delete: :cascade
  add_foreign_key "vulnerability_occurrences", "vulnerability_scanners", column: "scanner_id", on_delete: :cascade
  add_foreign_key "vulnerability_scanners", "projects", on_delete: :cascade
3927
  add_foreign_key "web_hook_logs", "web_hooks", on_delete: :cascade
3928
  add_foreign_key "web_hooks", "projects", name: "fk_0c8ca6d9d1", on_delete: :cascade
3929
end