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

13
ActiveRecord::Schema.define(version: 2019_11_12_232338) 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
    t.index ["user_id"], name: "index_abuse_reports_on_user_id"
28 29
  end

30 31 32 33 34 35 36 37 38
  create_table "alerts_service_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_token", limit: 255
    t.string "encrypted_token_iv", limit: 255
    t.index ["service_id"], name: "index_alerts_service_data_on_service_id"
  end

39 40 41 42 43 44 45 46
  create_table "allowed_email_domains", 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 "domain", limit: 255, null: false
    t.index ["group_id"], name: "index_allowed_email_domains_on_group_id"
  end

47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
  create_table "analytics_cycle_analytics_group_stages", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "relative_position"
    t.integer "start_event_identifier", null: false
    t.integer "end_event_identifier", null: false
    t.bigint "group_id", null: false
    t.bigint "start_event_label_id"
    t.bigint "end_event_label_id"
    t.boolean "hidden", default: false, null: false
    t.boolean "custom", default: true, null: false
    t.string "name", limit: 255, null: false
    t.index ["end_event_label_id"], name: "index_analytics_ca_group_stages_on_end_event_label_id"
    t.index ["group_id", "name"], name: "index_analytics_ca_group_stages_on_group_id_and_name", unique: true
    t.index ["group_id"], name: "index_analytics_ca_group_stages_on_group_id"
    t.index ["relative_position"], name: "index_analytics_ca_group_stages_on_relative_position"
    t.index ["start_event_label_id"], name: "index_analytics_ca_group_stages_on_start_event_label_id"
  end

  create_table "analytics_cycle_analytics_project_stages", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "relative_position"
    t.integer "start_event_identifier", null: false
    t.integer "end_event_identifier", null: false
    t.bigint "project_id", null: false
    t.bigint "start_event_label_id"
    t.bigint "end_event_label_id"
    t.boolean "hidden", default: false, null: false
    t.boolean "custom", default: true, null: false
    t.string "name", limit: 255, null: false
    t.index ["end_event_label_id"], name: "index_analytics_ca_project_stages_on_end_event_label_id"
    t.index ["project_id", "name"], name: "index_analytics_ca_project_stages_on_project_id_and_name", unique: true
    t.index ["project_id"], name: "index_analytics_ca_project_stages_on_project_id"
    t.index ["relative_position"], name: "index_analytics_ca_project_stages_on_relative_position"
    t.index ["start_event_label_id"], name: "index_analytics_ca_project_stages_on_start_event_label_id"
  end

85 86 87 88 89 90 91 92 93 94 95 96
  create_table "analytics_language_trend_repository_languages", id: false, force: :cascade do |t|
    t.integer "file_count", default: 0, null: false
    t.bigint "programming_language_id", null: false
    t.bigint "project_id", null: false
    t.integer "loc", default: 0, null: false
    t.integer "bytes", default: 0, null: false
    t.integer "percentage", limit: 2, default: 0, null: false
    t.date "snapshot_date", null: false
    t.index ["programming_language_id", "project_id", "snapshot_date"], name: "analytics_repository_languages_unique_index", unique: true
    t.index ["project_id"], name: "analytics_repository_languages_on_project_id"
  end

97
  create_table "analytics_repository_file_commits", force: :cascade do |t|
98
    t.bigint "analytics_repository_file_id", null: false
99
    t.bigint "project_id", null: false
100
    t.date "committed_date", null: false
101 102 103
    t.integer "commit_count", limit: 2, null: false
    t.index ["analytics_repository_file_id"], name: "index_analytics_repository_file_commits_file_id"
    t.index ["project_id", "committed_date", "analytics_repository_file_id"], name: "index_file_commits_on_committed_date_file_id_and_project_id", unique: true
104 105
  end

106 107 108 109 110 111 112 113 114
  create_table "analytics_repository_file_edits", force: :cascade do |t|
    t.bigint "project_id", null: false
    t.bigint "analytics_repository_file_id", null: false
    t.date "committed_date", null: false
    t.integer "num_edits", default: 0, null: false
    t.index ["analytics_repository_file_id", "committed_date", "project_id"], name: "index_file_edits_on_committed_date_file_id_and_project_id", unique: true
    t.index ["project_id"], name: "index_analytics_repository_file_edits_on_project_id"
  end

115 116 117 118 119 120
  create_table "analytics_repository_files", force: :cascade do |t|
    t.bigint "project_id", null: false
    t.string "file_path", limit: 4096, null: false
    t.index ["project_id", "file_path"], name: "index_analytics_repository_files_on_project_id_and_file_path", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
121
  create_table "appearances", id: :serial, force: :cascade do |t|
122 123
    t.string "title", null: false
    t.text "description", null: false
124
    t.string "logo"
125 126
    t.integer "updated_by"
    t.string "header_logo"
127 128
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
129
    t.text "description_html"
130
    t.integer "cached_markdown_version"
131 132
    t.text "new_project_guidelines"
    t.text "new_project_guidelines_html"
133 134 135 136 137 138
    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"
139
    t.string "favicon"
140
    t.boolean "email_header_and_footer_enabled", default: false, null: false
141 142
  end

Jasper Maes's avatar
Jasper Maes committed
143
  create_table "application_setting_terms", id: :serial, force: :cascade do |t|
144 145 146 147 148
    t.integer "cached_markdown_version"
    t.text "terms", null: false
    t.text "terms_html"
  end

Jasper Maes's avatar
Jasper Maes committed
149
  create_table "application_settings", id: :serial, force: :cascade do |t|
150 151 152 153
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
154 155
    t.datetime "created_at"
    t.datetime "updated_at"
156 157
    t.string "home_page_url"
    t.integer "default_branch_protection", default: 2
158
    t.text "help_text"
159 160 161
    t.text "restricted_visibility_levels"
    t.boolean "version_check_enabled", default: true
    t.integer "max_attachment_size", default: 10, null: false
162 163
    t.integer "default_project_visibility", default: 0, null: false
    t.integer "default_snippet_visibility", default: 0, null: false
164 165 166 167 168 169 170 171 172 173
    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"
174
    t.integer "max_pages_size", default: 100, null: false
175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198
    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
199
    t.boolean "user_default_external", default: false, null: false
200 201
    t.boolean "elasticsearch_indexing", default: false, null: false
    t.boolean "elasticsearch_search", default: false, null: false
202
    t.string "repository_storages", default: "default"
203 204 205
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
206
    t.boolean "usage_ping_enabled", default: true, null: false
207 208 209 210
    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"
211
    t.integer "rsa_key_restriction", default: 0, null: false
212
    t.integer "dsa_key_restriction", default: -1, null: false
213 214
    t.integer "ecdsa_key_restriction", default: 0, null: false
    t.integer "ed25519_key_restriction", default: 0, null: false
215 216 217 218 219
    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
220
    t.boolean "html_emails_enabled", default: true
221 222
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
223 224
    t.integer "shared_runners_minutes", default: 0, null: false
    t.bigint "repository_size_limit", default: 0
225
    t.integer "terminal_max_session_time", default: 0, null: false
226 227 228
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
229
    t.string "default_artifacts_expire_in", default: "0", null: false
230 231 232 233 234 235
    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
236
    t.string "uuid"
237
    t.decimal "polling_interval_multiplier", default: "1.0", null: false
238
    t.boolean "elasticsearch_experimental_indexer"
239
    t.integer "cached_markdown_version"
240 241 242 243
    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
244
    t.boolean "prometheus_metrics_enabled", default: true, null: false
245
    t.boolean "authorized_keys_enabled", default: true, null: false
246 247
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
248 249 250 251
    t.boolean "slack_app_enabled", default: false
    t.string "slack_app_id"
    t.string "slack_app_secret"
    t.string "slack_app_verification_token"
252
    t.integer "performance_bar_allowed_group_id"
253
    t.boolean "allow_group_owners_to_manage_ldap", default: true, null: false
254
    t.boolean "hashed_storage_enabled", default: true, null: false
255
    t.boolean "project_export_enabled", default: true, null: false
256
    t.boolean "auto_devops_enabled", default: true, null: false
257 258 259 260 261 262 263 264 265
    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
266 267 268
    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
269 270 271
    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
272
    t.string "auto_devops_domain"
273 274 275
    t.boolean "external_authorization_service_enabled", default: false, null: false
    t.string "external_authorization_service_url"
    t.string "external_authorization_service_default_label"
276
    t.boolean "pages_domain_verification_enabled", default: true, null: false
277
    t.string "user_default_internal_regex"
278 279 280 281 282 283 284
    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"
285
    t.boolean "enforce_terms", default: false
286 287
    t.integer "file_template_project_id"
    t.boolean "pseudonymizer_enabled", default: false, null: false
288
    t.boolean "hide_third_party_offers", default: false, null: false
289
    t.boolean "snowplow_enabled", default: false, null: false
290
    t.string "snowplow_collector_hostname"
291
    t.string "snowplow_cookie_domain"
292
    t.boolean "instance_statistics_visibility_private", default: false, null: false
Phil Hughes's avatar
Phil Hughes committed
293
    t.boolean "web_ide_clientside_preview_enabled", default: false, null: false
294
    t.boolean "user_show_add_ssh_key_message", default: true, null: false
295
    t.integer "custom_project_templates_group_id"
296
    t.integer "usage_stats_set_by_user_id"
297
    t.integer "receive_max_input_size"
298
    t.integer "diff_max_patch_bytes", default: 102400, null: false
299
    t.integer "archive_builds_in_seconds"
300
    t.string "commit_email_hostname"
301
    t.boolean "protected_ci_variables", default: false, null: false
302
    t.string "runners_registration_token_encrypted"
Jan Provaznik's avatar
Jan Provaznik committed
303
    t.integer "local_markdown_version", default: 0, null: false
304
    t.integer "first_day_of_week", default: 0, null: false
305
    t.boolean "elasticsearch_limit_indexing", default: false, null: false
Gosia Ksionek's avatar
Gosia Ksionek committed
306
    t.integer "default_project_creation", default: 2, null: false
307 308
    t.string "lets_encrypt_notification_email"
    t.boolean "lets_encrypt_terms_of_service_accepted", default: false, null: false
309
    t.string "geo_node_allowed_ips", default: "0.0.0.0/0, ::/0"
310 311
    t.integer "elasticsearch_shards", default: 5, null: false
    t.integer "elasticsearch_replicas", default: 1, null: false
312 313
    t.text "encrypted_lets_encrypt_private_key"
    t.text "encrypted_lets_encrypt_private_key_iv"
Matija Čupić's avatar
Matija Čupić committed
314
    t.string "required_instance_ci_template"
315
    t.boolean "dns_rebinding_protection_enabled", default: true, null: false
Małgorzata Ksionek's avatar
Małgorzata Ksionek committed
316
    t.boolean "default_project_deletion_protection", default: false, null: false
317
    t.boolean "grafana_enabled", default: false, null: false
318
    t.boolean "lock_memberships_to_ldap", default: false, null: false
319
    t.boolean "time_tracking_limit_to_hours", default: false, null: false
320
    t.string "grafana_url", default: "/-/grafana", null: false
321
    t.boolean "login_recaptcha_protection_enabled", default: false, null: false
322
    t.string "outbound_local_requests_whitelist", limit: 255, default: [], null: false, array: true
323
    t.integer "raw_blob_request_limit", default: 300, null: false
324
    t.boolean "allow_local_requests_from_web_hooks_and_services", default: false, null: false
325
    t.boolean "allow_local_requests_from_system_hooks", default: true, null: false
326
    t.bigint "instance_administration_project_id"
327 328 329 330 331
    t.boolean "asset_proxy_enabled", default: false, null: false
    t.string "asset_proxy_url"
    t.text "asset_proxy_whitelist"
    t.text "encrypted_asset_proxy_secret_key"
    t.string "encrypted_asset_proxy_secret_key_iv"
332 333
    t.string "static_objects_external_storage_url", limit: 255
    t.string "static_objects_external_storage_auth_token", limit: 255
334
    t.boolean "throttle_protected_paths_enabled", default: false, null: false
335 336 337
    t.integer "throttle_protected_paths_requests_per_period", default: 10, null: false
    t.integer "throttle_protected_paths_period_in_seconds", default: 60, null: false
    t.string "protected_paths", limit: 255, default: ["/users/password", "/users/sign_in", "/api/v3/session.json", "/api/v3/session", "/api/v4/session.json", "/api/v4/session", "/users", "/users/confirmation", "/unsubscribes/", "/import/github/personal_access_token"], array: true
338 339 340
    t.boolean "throttle_incident_management_notification_enabled", default: false, null: false
    t.integer "throttle_incident_management_notification_period_in_seconds", default: 3600
    t.integer "throttle_incident_management_notification_per_period", default: 3600
341
    t.string "snowplow_iglu_registry_url", limit: 255
342
    t.integer "push_event_hooks_limit", default: 3, null: false
343
    t.integer "push_event_activities_limit", default: 3, null: false
344
    t.string "custom_http_clone_url_root", limit: 511
345
    t.integer "deletion_adjourned_period", default: 7, null: false
346
    t.date "license_trial_ends_on"
347 348 349 350 351
    t.boolean "eks_integration_enabled", default: false, null: false
    t.string "eks_account_id", limit: 128
    t.string "eks_access_key_id", limit: 128
    t.string "encrypted_eks_secret_access_key_iv", limit: 255
    t.text "encrypted_eks_secret_access_key"
352 353
    t.string "snowplow_app_id"
    t.datetime_with_timezone "productivity_analytics_start_date"
354
    t.string "default_ci_config_path", limit: 255
355 356
    t.index ["custom_project_templates_group_id"], name: "index_application_settings_on_custom_project_templates_group_id"
    t.index ["file_template_project_id"], name: "index_application_settings_on_file_template_project_id"
357
    t.index ["instance_administration_project_id"], name: "index_applicationsettings_on_instance_administration_project_id"
358
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id"
359 360
  end

361 362 363
  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
364 365
    t.index ["approval_merge_request_rule_id"], name: "index_approval_merge_request_rule_sources_1", unique: true
    t.index ["approval_project_rule_id"], name: "index_approval_merge_request_rule_sources_2"
366 367 368 369 370 371 372 373 374 375
  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
376
    t.integer "report_type", limit: 2
377 378
    t.index ["merge_request_id", "code_owner", "name"], name: "approval_rule_name_index_for_code_owners", unique: true, where: "(code_owner = true)"
    t.index ["merge_request_id", "code_owner"], name: "index_approval_merge_request_rules_1"
379 380 381
    t.index ["merge_request_id", "name"], name: "index_approval_rule_name_for_code_owners_rule_type", unique: true, where: "(rule_type = 2)"
    t.index ["merge_request_id", "rule_type"], name: "any_approver_merge_request_rule_type_unique_index", unique: true, where: "(rule_type = 4)"
    t.index ["merge_request_id"], name: "index_approval_rules_code_owners_rule_type", where: "(rule_type = 2)"
382 383 384 385 386
  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
387 388
    t.index ["approval_merge_request_rule_id", "user_id"], name: "index_approval_merge_request_rules_approved_approvers_1", unique: true
    t.index ["user_id"], name: "index_approval_merge_request_rules_approved_approvers_2"
389 390 391 392 393
  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
394 395
    t.index ["approval_merge_request_rule_id", "group_id"], name: "index_approval_merge_request_rules_groups_1", unique: true
    t.index ["group_id"], name: "index_approval_merge_request_rules_groups_2"
396 397 398 399 400
  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
401 402
    t.index ["approval_merge_request_rule_id", "user_id"], name: "index_approval_merge_request_rules_users_1", unique: true
    t.index ["user_id"], name: "index_approval_merge_request_rules_users_2"
403 404 405 406 407 408 409 410
  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
411
    t.integer "rule_type", limit: 2, default: 0, null: false
412
    t.index ["project_id"], name: "any_approver_project_rule_type_unique_index", unique: true, where: "(rule_type = 3)"
413 414
    t.index ["project_id"], name: "index_approval_project_rules_on_project_id"
    t.index ["rule_type"], name: "index_approval_project_rules_on_rule_type"
415 416 417 418 419
  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
420 421
    t.index ["approval_project_rule_id", "group_id"], name: "index_approval_project_rules_groups_1", unique: true
    t.index ["group_id"], name: "index_approval_project_rules_groups_2"
422 423 424 425 426
  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
427 428
    t.index ["approval_project_rule_id", "user_id"], name: "index_approval_project_rules_users_1", unique: true
    t.index ["user_id"], name: "index_approval_project_rules_users_2"
429 430 431 432 433 434 435
  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"
436 437
    t.index ["merge_request_id"], name: "index_approvals_on_merge_request_id"
    t.index ["user_id", "merge_request_id"], name: "index_approvals_on_user_id_and_merge_request_id", unique: true
438 439 440 441 442 443 444 445
  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"
446 447
    t.index ["group_id"], name: "index_approver_groups_on_group_id"
    t.index ["target_id", "target_type"], name: "index_approver_groups_on_target_id_and_target_type"
448 449 450 451 452 453 454 455
  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"
456 457
    t.index ["target_id", "target_type"], name: "index_approvers_on_target_id_and_target_type"
    t.index ["user_id"], name: "index_approvers_on_user_id"
458 459
  end

Jasper Maes's avatar
Jasper Maes committed
460
  create_table "audit_events", id: :serial, force: :cascade do |t|
461 462 463 464 465
    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"
466 467
    t.datetime "created_at"
    t.datetime "updated_at"
468 469
    t.index ["created_at", "author_id"], name: "analytics_index_audit_events_on_created_at_and_author_id"
    t.index ["entity_id", "entity_type"], name: "index_audit_events_on_entity_id_and_entity_type"
470 471
  end

Jasper Maes's avatar
Jasper Maes committed
472
  create_table "award_emoji", id: :serial, force: :cascade do |t|
473 474 475 476
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
477 478
    t.datetime "created_at"
    t.datetime "updated_at"
479 480
    t.index ["awardable_type", "awardable_id"], name: "index_award_emoji_on_awardable_type_and_awardable_id"
    t.index ["user_id", "name"], name: "index_award_emoji_on_user_id_and_name"
481 482
  end

483 484 485 486 487 488 489 490 491
  create_table "aws_roles", primary_key: "user_id", id: :integer, default: nil, force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "role_arn", limit: 2048, null: false
    t.string "role_external_id", limit: 64, null: false
    t.index ["role_external_id"], name: "index_aws_roles_on_role_external_id", unique: true
    t.index ["user_id"], name: "index_aws_roles_on_user_id", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
492
  create_table "badges", id: :serial, force: :cascade do |t|
493 494 495 496 497 498 499
    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
500 501
    t.index ["group_id"], name: "index_badges_on_group_id"
    t.index ["project_id"], name: "index_badges_on_project_id"
502 503
  end

504 505 506
  create_table "board_assignees", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
507 508
    t.index ["assignee_id"], name: "index_board_assignees_on_assignee_id"
    t.index ["board_id", "assignee_id"], name: "index_board_assignees_on_board_id_and_assignee_id", unique: true
509 510
  end

Jasper Maes's avatar
Jasper Maes committed
511
  create_table "board_group_recent_visits", force: :cascade do |t|
512 513 514 515 516
    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"
517 518 519 520
    t.index ["board_id"], name: "index_board_group_recent_visits_on_board_id"
    t.index ["group_id"], name: "index_board_group_recent_visits_on_group_id"
    t.index ["user_id", "group_id", "board_id"], name: "index_board_group_recent_visits_on_user_group_and_board", unique: true
    t.index ["user_id"], name: "index_board_group_recent_visits_on_user_id"
521 522
  end

523 524 525
  create_table "board_labels", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "label_id", null: false
526 527
    t.index ["board_id", "label_id"], name: "index_board_labels_on_board_id_and_label_id", unique: true
    t.index ["label_id"], name: "index_board_labels_on_label_id"
528 529
  end

Jasper Maes's avatar
Jasper Maes committed
530
  create_table "board_project_recent_visits", force: :cascade do |t|
531 532 533 534 535
    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"
536 537 538 539
    t.index ["board_id"], name: "index_board_project_recent_visits_on_board_id"
    t.index ["project_id"], name: "index_board_project_recent_visits_on_project_id"
    t.index ["user_id", "project_id", "board_id"], name: "index_board_project_recent_visits_on_user_project_and_board", unique: true
    t.index ["user_id"], name: "index_board_project_recent_visits_on_user_id"
540 541
  end

Jasper Maes's avatar
Jasper Maes committed
542
  create_table "boards", id: :serial, force: :cascade do |t|
Felipe Artur's avatar
Felipe Artur committed
543
    t.integer "project_id"
544 545
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
546
    t.string "name", default: "Development", null: false
547
    t.integer "milestone_id"
548
    t.integer "group_id"
549
    t.integer "weight"
550 551 552
    t.index ["group_id"], name: "index_boards_on_group_id"
    t.index ["milestone_id"], name: "index_boards_on_milestone_id"
    t.index ["project_id"], name: "index_boards_on_project_id"
553 554
  end

Jasper Maes's avatar
Jasper Maes committed
555
  create_table "broadcast_messages", id: :serial, force: :cascade do |t|
556
    t.text "message", null: false
557 558 559 560
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
561 562
    t.string "color"
    t.string "font"
563
    t.text "message_html", null: false
564
    t.integer "cached_markdown_version"
565
    t.index ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id"
566
  end
567

Jasper Maes's avatar
Jasper Maes committed
568
  create_table "chat_names", id: :serial, force: :cascade do |t|
569 570
    t.integer "user_id", null: false
    t.integer "service_id", null: false
571
    t.string "team_id", null: false
572
    t.string "team_domain"
573
    t.string "chat_id", null: false
574
    t.string "chat_name"
575
    t.datetime "last_used_at"
576 577
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
578 579
    t.index ["service_id", "team_id", "chat_id"], name: "index_chat_names_on_service_id_and_team_id_and_chat_id", unique: true
    t.index ["user_id", "service_id"], name: "index_chat_names_on_user_id_and_service_id", unique: true
580
  end
581

Jasper Maes's avatar
Jasper Maes committed
582
  create_table "chat_teams", id: :serial, force: :cascade do |t|
583
    t.integer "namespace_id", null: false
584 585 586 587
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
588
    t.index ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true
589 590
  end

Kamil Trzciński's avatar
Kamil Trzciński committed
591 592 593 594 595 596
  create_table "ci_build_needs", id: :serial, force: :cascade do |t|
    t.integer "build_id", null: false
    t.text "name", null: false
    t.index ["build_id", "name"], name: "index_ci_build_needs_on_build_id_and_name", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
597
  create_table "ci_build_trace_chunks", force: :cascade do |t|
598 599 600 601
    t.integer "build_id", null: false
    t.integer "chunk_index", null: false
    t.integer "data_store", null: false
    t.binary "raw_data"
602
    t.index ["build_id", "chunk_index"], name: "index_ci_build_trace_chunks_on_build_id_and_chunk_index", unique: true
603 604
  end

Jasper Maes's avatar
Jasper Maes committed
605
  create_table "ci_build_trace_section_names", id: :serial, force: :cascade do |t|
606 607
    t.integer "project_id", null: false
    t.string "name", null: false
608
    t.index ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true
609 610
  end

611
  create_table "ci_build_trace_sections", id: false, force: :cascade do |t|
612
    t.integer "project_id", null: false
613 614
    t.datetime "date_start", null: false
    t.datetime "date_end", null: false
615 616
    t.bigint "byte_start", null: false
    t.bigint "byte_end", null: false
617 618
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
619 620 621
    t.index ["build_id", "section_name_id"], name: "index_ci_build_trace_sections_on_build_id_and_section_name_id", unique: true
    t.index ["project_id"], name: "index_ci_build_trace_sections_on_project_id"
    t.index ["section_name_id"], name: "index_ci_build_trace_sections_on_section_name_id"
622 623
  end

Jasper Maes's avatar
Jasper Maes committed
624
  create_table "ci_builds", id: :serial, force: :cascade do |t|
625
    t.string "status"
626
    t.datetime "finished_at"
627
    t.text "trace"
628 629 630
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647
    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"
648
    t.integer "project_id"
649 650
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
651
    t.datetime "erased_at"
652
    t.datetime "artifacts_expire_at"
653
    t.string "environment"
654
    t.bigint "artifacts_size"
655 656
    t.string "when"
    t.text "yaml_variables"
657
    t.datetime "queued_at"
658
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
659
    t.integer "lock_version"
660
    t.string "coverage_regex"
661
    t.integer "auto_canceled_by_id"
662
    t.boolean "retried"
663
    t.integer "stage_id"
664 665
    t.integer "artifacts_file_store"
    t.integer "artifacts_metadata_store"
666
    t.boolean "protected"
667
    t.integer "failure_reason"
668
    t.datetime_with_timezone "scheduled_at"
669
    t.string "token_encrypted"
670
    t.integer "upstream_pipeline_id"
671 672 673 674 675 676 677 678 679 680
    t.index ["artifacts_expire_at"], name: "index_ci_builds_on_artifacts_expire_at", where: "(artifacts_file <> ''::text)"
    t.index ["auto_canceled_by_id"], name: "index_ci_builds_on_auto_canceled_by_id"
    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])))"
    t.index ["commit_id", "stage_idx", "created_at"], name: "index_ci_builds_on_commit_id_and_stage_idx_and_created_at"
    t.index ["commit_id", "status", "type"], name: "index_ci_builds_on_commit_id_and_status_and_type"
    t.index ["commit_id", "type", "name", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_name_and_ref"
    t.index ["commit_id", "type", "ref"], name: "index_ci_builds_on_commit_id_and_type_and_ref"
    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]))"
    t.index ["project_id", "id"], name: "index_ci_builds_on_project_id_and_id"
    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])))"
681
    t.index ["project_id"], name: "index_ci_builds_on_project_id_for_successfull_pages_deploy", where: "(((type)::text = 'GenericCommitStatus'::text) AND ((stage)::text = 'deploy'::text) AND ((name)::text = 'pages:deploy'::text) AND ((status)::text = 'success'::text))"
682 683 684 685 686 687
    t.index ["protected"], name: "index_ci_builds_on_protected"
    t.index ["queued_at"], name: "index_ci_builds_on_queued_at"
    t.index ["runner_id"], name: "index_ci_builds_on_runner_id"
    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))"
    t.index ["stage_id", "stage_idx"], name: "tmp_build_stage_position_index", where: "(stage_idx IS NOT NULL)"
    t.index ["stage_id"], name: "index_ci_builds_on_stage_id"
688
    t.index ["status", "created_at", "project_id"], name: "ci_builds_gitlab_monitor_metrics", where: "((type)::text = 'Ci::Build'::text)"
689 690 691 692 693 694
    t.index ["status", "type", "runner_id"], name: "index_ci_builds_on_status_and_type_and_runner_id"
    t.index ["token"], name: "index_ci_builds_on_token", unique: true
    t.index ["token_encrypted"], name: "index_ci_builds_on_token_encrypted", unique: true, where: "(token_encrypted IS NOT NULL)"
    t.index ["updated_at"], name: "index_ci_builds_on_updated_at"
    t.index ["upstream_pipeline_id"], name: "index_ci_builds_on_upstream_pipeline_id", where: "(upstream_pipeline_id IS NOT NULL)"
    t.index ["user_id"], name: "index_ci_builds_on_user_id"
695 696
  end

Jasper Maes's avatar
Jasper Maes committed
697
  create_table "ci_builds_metadata", id: :serial, force: :cascade do |t|
698
    t.integer "build_id", null: false
699
    t.integer "project_id", null: false
700
    t.integer "timeout"
701
    t.integer "timeout_source", default: 1, null: false
702
    t.boolean "interruptible"
703 704
    t.jsonb "config_options"
    t.jsonb "config_variables"
705
    t.boolean "has_exposed_artifacts"
706
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id", unique: true
707
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id_and_has_exposed_artifacts", where: "(has_exposed_artifacts IS TRUE)"
708
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id_and_interruptible", where: "(interruptible = true)"
709
    t.index ["project_id"], name: "index_ci_builds_metadata_on_project_id"
710 711
  end

Jasper Maes's avatar
Jasper Maes committed
712
  create_table "ci_builds_runner_session", force: :cascade do |t|
713 714 715 716
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
717
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true
718 719
  end

Jasper Maes's avatar
Jasper Maes committed
720
  create_table "ci_group_variables", id: :serial, force: :cascade do |t|
721 722 723 724 725
    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
726 727
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
728 729
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
730
    t.boolean "masked", default: false, null: false
731
    t.integer "variable_type", limit: 2, default: 1, null: false
732
    t.index ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true
733 734
  end

Jasper Maes's avatar
Jasper Maes committed
735
  create_table "ci_job_artifacts", id: :serial, force: :cascade do |t|
736
    t.integer "project_id", null: false
737
    t.integer "job_id", null: false
738
    t.integer "file_type", null: false
739
    t.bigint "size"
740 741
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
742
    t.datetime_with_timezone "expire_at"
743
    t.string "file"
744
    t.integer "file_store"
745
    t.binary "file_sha256"
746
    t.integer "file_format", limit: 2
747
    t.integer "file_location", limit: 2
748 749 750 751
    t.index ["expire_at", "job_id"], name: "index_ci_job_artifacts_on_expire_at_and_job_id"
    t.index ["file_store"], name: "index_ci_job_artifacts_on_file_store"
    t.index ["job_id", "file_type"], name: "index_ci_job_artifacts_on_job_id_and_file_type", unique: true
    t.index ["project_id"], name: "index_ci_job_artifacts_on_project_id"
752
    t.index ["project_id"], name: "index_ci_job_artifacts_on_project_id_for_security_reports", where: "(file_type = ANY (ARRAY[5, 6, 7, 8]))"
753 754
  end

755 756 757 758 759 760 761 762 763 764
  create_table "ci_job_variables", force: :cascade do |t|
    t.string "key", null: false
    t.text "encrypted_value"
    t.string "encrypted_value_iv"
    t.bigint "job_id", null: false
    t.integer "variable_type", limit: 2, default: 1, null: false
    t.index ["job_id"], name: "index_ci_job_variables_on_job_id"
    t.index ["key", "job_id"], name: "index_ci_job_variables_on_key_and_job_id", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
765
  create_table "ci_pipeline_chat_data", force: :cascade do |t|
766 767 768
    t.integer "pipeline_id", null: false
    t.integer "chat_name_id", null: false
    t.text "response_url", null: false
769 770
    t.index ["chat_name_id"], name: "index_ci_pipeline_chat_data_on_chat_name_id"
    t.index ["pipeline_id"], name: "index_ci_pipeline_chat_data_on_pipeline_id", unique: true
771 772
  end

773
  create_table "ci_pipeline_schedule_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
774 775 776 777 778
    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
779
    t.integer "pipeline_schedule_id", null: false
780 781
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
782
    t.integer "variable_type", limit: 2, default: 1, null: false
783
    t.index ["pipeline_schedule_id", "key"], name: "index_ci_pipeline_schedule_variables_on_schedule_id_and_key", unique: true
Shinya Maeda's avatar
Shinya Maeda committed
784 785
  end

Jasper Maes's avatar
Jasper Maes committed
786
  create_table "ci_pipeline_schedules", id: :serial, force: :cascade do |t|
787 788 789 790 791 792 793 794
    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
795 796
    t.datetime "created_at"
    t.datetime "updated_at"
797 798 799
    t.index ["next_run_at", "active"], name: "index_ci_pipeline_schedules_on_next_run_at_and_active"
    t.index ["owner_id"], name: "index_ci_pipeline_schedules_on_owner_id"
    t.index ["project_id"], name: "index_ci_pipeline_schedules_on_project_id"
800 801
  end

Jasper Maes's avatar
Jasper Maes committed
802
  create_table "ci_pipeline_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
init  
Shinya Maeda committed
803 804 805 806 807 808
    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
809
    t.integer "variable_type", limit: 2, default: 1, null: false
810
    t.index ["pipeline_id", "key"], name: "index_ci_pipeline_variables_on_pipeline_id_and_key", unique: true
Shinya Maeda's avatar
init  
Shinya Maeda committed
811 812
  end

Jasper Maes's avatar
Jasper Maes committed
813
  create_table "ci_pipelines", id: :serial, force: :cascade do |t|
814 815 816
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
817 818
    t.datetime "created_at"
    t.datetime "updated_at"
819 820
    t.boolean "tag", default: false
    t.text "yaml_errors"
821
    t.datetime "committed_at"
822
    t.integer "project_id"
823
    t.string "status"
824 825
    t.datetime "started_at"
    t.datetime "finished_at"
826 827
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
828
    t.integer "lock_version"
829
    t.integer "auto_canceled_by_id"
830
    t.integer "pipeline_schedule_id"
831
    t.integer "source"
832
    t.integer "config_source"
833
    t.boolean "protected"
834
    t.integer "failure_reason"
Shinya Maeda's avatar
Shinya Maeda committed
835
    t.integer "iid"
Shinya Maeda's avatar
Shinya Maeda committed
836
    t.integer "merge_request_id"
837 838
    t.binary "source_sha"
    t.binary "target_sha"
839
    t.bigint "external_pull_request_id"
840
    t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id"
841
    t.index ["external_pull_request_id"], name: "index_ci_pipelines_on_external_pull_request_id", where: "(external_pull_request_id IS NOT NULL)"
842 843 844 845 846 847 848 849 850 851 852
    t.index ["merge_request_id"], name: "index_ci_pipelines_on_merge_request_id", where: "(merge_request_id IS NOT NULL)"
    t.index ["pipeline_schedule_id"], name: "index_ci_pipelines_on_pipeline_schedule_id"
    t.index ["project_id", "iid"], name: "index_ci_pipelines_on_project_id_and_iid", unique: true, where: "(iid IS NOT NULL)"
    t.index ["project_id", "ref", "id"], name: "index_ci_pipelines_on_project_idandrefandiddesc", order: { id: :desc }
    t.index ["project_id", "ref", "status", "id"], name: "index_ci_pipelines_on_project_id_and_ref_and_status_and_id"
    t.index ["project_id", "sha"], name: "index_ci_pipelines_on_project_id_and_sha"
    t.index ["project_id", "source"], name: "index_ci_pipelines_on_project_id_and_source"
    t.index ["project_id", "status", "config_source"], name: "index_ci_pipelines_on_project_id_and_status_and_config_source"
    t.index ["project_id"], name: "index_ci_pipelines_on_project_id"
    t.index ["status"], name: "index_ci_pipelines_on_status"
    t.index ["user_id"], name: "index_ci_pipelines_on_user_id"
853 854
  end

Jasper Maes's avatar
Jasper Maes committed
855
  create_table "ci_runner_namespaces", id: :serial, force: :cascade do |t|
856
    t.integer "runner_id"
857
    t.integer "namespace_id"
858 859
    t.index ["namespace_id"], name: "index_ci_runner_namespaces_on_namespace_id"
    t.index ["runner_id", "namespace_id"], name: "index_ci_runner_namespaces_on_runner_id_and_namespace_id", unique: true
860 861
  end

Jasper Maes's avatar
Jasper Maes committed
862
  create_table "ci_runner_projects", id: :serial, force: :cascade do |t|
863
    t.integer "runner_id", null: false
864 865
    t.datetime "created_at"
    t.datetime "updated_at"
866
    t.integer "project_id"
867 868
    t.index ["project_id"], name: "index_ci_runner_projects_on_project_id"
    t.index ["runner_id"], name: "index_ci_runner_projects_on_runner_id"
869 870
  end

Jasper Maes's avatar
Jasper Maes committed
871
  create_table "ci_runners", id: :serial, force: :cascade do |t|
872
    t.string "token"
873 874
    t.datetime "created_at"
    t.datetime "updated_at"
875
    t.string "description"
876
    t.datetime "contacted_at"
877 878 879 880 881 882 883 884 885
    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
886
    t.integer "access_level", default: 0, null: false
887
    t.string "ip_address"
888
    t.integer "maximum_timeout"
889
    t.integer "runner_type", limit: 2, null: false
890
    t.string "token_encrypted"
891 892 893 894 895 896
    t.index ["contacted_at"], name: "index_ci_runners_on_contacted_at"
    t.index ["is_shared"], name: "index_ci_runners_on_is_shared"
    t.index ["locked"], name: "index_ci_runners_on_locked"
    t.index ["runner_type"], name: "index_ci_runners_on_runner_type"
    t.index ["token"], name: "index_ci_runners_on_token"
    t.index ["token_encrypted"], name: "index_ci_runners_on_token_encrypted"
897 898
  end

899 900 901 902 903 904
  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"
905 906 907 908 909
    t.index ["pipeline_id"], name: "index_ci_sources_pipelines_on_pipeline_id"
    t.index ["project_id"], name: "index_ci_sources_pipelines_on_project_id"
    t.index ["source_job_id"], name: "index_ci_sources_pipelines_on_source_job_id"
    t.index ["source_pipeline_id"], name: "index_ci_sources_pipelines_on_source_pipeline_id"
    t.index ["source_project_id"], name: "index_ci_sources_pipelines_on_source_project_id"
910 911
  end

Jasper Maes's avatar
Jasper Maes committed
912
  create_table "ci_stages", id: :serial, force: :cascade do |t|
913 914
    t.integer "project_id"
    t.integer "pipeline_id"
915 916
    t.datetime "created_at"
    t.datetime "updated_at"
917
    t.string "name"
918
    t.integer "status"
919
    t.integer "lock_version"
920
    t.integer "position"
921 922 923 924
    t.index ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", unique: true
    t.index ["pipeline_id", "position"], name: "index_ci_stages_on_pipeline_id_and_position"
    t.index ["pipeline_id"], name: "index_ci_stages_on_pipeline_id"
    t.index ["project_id"], name: "index_ci_stages_on_project_id"
925 926
  end

927 928 929 930 931 932 933
  create_table "ci_subscriptions_projects", force: :cascade do |t|
    t.bigint "downstream_project_id", null: false
    t.bigint "upstream_project_id", null: false
    t.index ["downstream_project_id", "upstream_project_id"], name: "index_ci_subscriptions_projects_unique_subscription", unique: true
    t.index ["upstream_project_id"], name: "index_ci_subscriptions_projects_on_upstream_project_id"
  end

Jasper Maes's avatar
Jasper Maes committed
934
  create_table "ci_trigger_requests", id: :serial, force: :cascade do |t|
935 936
    t.integer "trigger_id", null: false
    t.text "variables"
937 938
    t.datetime "created_at"
    t.datetime "updated_at"
939
    t.integer "commit_id"
940
    t.index ["commit_id"], name: "index_ci_trigger_requests_on_commit_id"
941
    t.index ["trigger_id", "id"], name: "index_ci_trigger_requests_on_trigger_id_and_id", order: { id: :desc }
942 943
  end

Jasper Maes's avatar
Jasper Maes committed
944
  create_table "ci_triggers", id: :serial, force: :cascade do |t|
945
    t.string "token"
946 947
    t.datetime "created_at"
    t.datetime "updated_at"
948
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
949 950
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
951
    t.string "ref"
952 953
    t.index ["owner_id"], name: "index_ci_triggers_on_owner_id"
    t.index ["project_id"], name: "index_ci_triggers_on_project_id"
954 955
  end

Jasper Maes's avatar
Jasper Maes committed
956
  create_table "ci_variables", id: :serial, force: :cascade do |t|
957
    t.string "key", null: false
958 959 960 961
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
962
    t.integer "project_id", null: false
963
    t.boolean "protected", default: false, null: false
964
    t.string "environment_scope", default: "*", null: false
965
    t.boolean "masked", default: false, null: false
966
    t.integer "variable_type", limit: 2, default: 1, null: false
967
    t.index ["project_id", "key", "environment_scope"], name: "index_ci_variables_on_project_id_and_key_and_environment_scope", unique: true
968 969
  end

Jasper Maes's avatar
Jasper Maes committed
970
  create_table "cluster_groups", id: :serial, force: :cascade do |t|
971 972
    t.integer "cluster_id", null: false
    t.integer "group_id", null: false
973 974
    t.index ["cluster_id", "group_id"], name: "index_cluster_groups_on_cluster_id_and_group_id", unique: true
    t.index ["group_id"], name: "index_cluster_groups_on_group_id"
975 976
  end

Jasper Maes's avatar
Jasper Maes committed
977
  create_table "cluster_platforms_kubernetes", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
978
    t.integer "cluster_id", null: false
979 980
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
981
    t.text "api_url"
Shinya Maeda's avatar
Shinya Maeda committed
982 983 984 985 986 987 988
    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"
989
    t.integer "authorization_type", limit: 2
990
    t.index ["cluster_id"], name: "index_cluster_platforms_kubernetes_on_cluster_id", unique: true
Shinya Maeda's avatar
Shinya Maeda committed
991 992
  end

Jasper Maes's avatar
Jasper Maes committed
993
  create_table "cluster_projects", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
994 995
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
996 997
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
998 999
    t.index ["cluster_id"], name: "index_cluster_projects_on_cluster_id"
    t.index ["project_id"], name: "index_cluster_projects_on_project_id"
Shinya Maeda's avatar
Shinya Maeda committed
1000 1001
  end

1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025
  create_table "cluster_providers_aws", force: :cascade do |t|
    t.bigint "cluster_id", null: false
    t.integer "created_by_user_id"
    t.integer "num_nodes", null: false
    t.integer "status", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "key_name", limit: 255, null: false
    t.string "role_arn", limit: 2048, null: false
    t.string "region", limit: 255, null: false
    t.string "vpc_id", limit: 255, null: false
    t.string "subnet_ids", limit: 255, default: [], null: false, array: true
    t.string "security_group_id", limit: 255, null: false
    t.string "instance_type", limit: 255, null: false
    t.string "access_key_id", limit: 255
    t.string "encrypted_secret_access_key_iv", limit: 255
    t.text "encrypted_secret_access_key"
    t.text "session_token"
    t.text "status_reason"
    t.index ["cluster_id", "status"], name: "index_cluster_providers_aws_on_cluster_id_and_status"
    t.index ["cluster_id"], name: "index_cluster_providers_aws_on_cluster_id", unique: true
    t.index ["created_by_user_id"], name: "index_cluster_providers_aws_on_created_by_user_id"
  end

Jasper Maes's avatar
Jasper Maes committed
1026
  create_table "cluster_providers_gcp", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
1027 1028
    t.integer "cluster_id", null: false
    t.integer "status"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1029
    t.integer "num_nodes", null: false
1030 1031
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
1032 1033 1034 1035 1036 1037 1038 1039
    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"
1040
    t.boolean "legacy_abac", default: false, null: false
1041 1042
    t.boolean "cloud_run", default: false, null: false
    t.index ["cloud_run"], name: "index_cluster_providers_gcp_on_cloud_run"
1043
    t.index ["cluster_id"], name: "index_cluster_providers_gcp_on_cluster_id", unique: true
Shinya Maeda's avatar
Shinya Maeda committed
1044 1045
  end

Jasper Maes's avatar
Jasper Maes committed
1046
  create_table "clusters", id: :serial, force: :cascade do |t|
1047
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1048 1049
    t.integer "provider_type"
    t.integer "platform_type"
1050 1051
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1052 1053
    t.boolean "enabled", default: true
    t.string "name", null: false
1054
    t.string "environment_scope", default: "*", null: false
1055
    t.integer "cluster_type", limit: 2, default: 3, null: false
1056
    t.string "domain"
1057
    t.boolean "managed", default: true, null: false
1058
    t.boolean "namespace_per_environment", default: true, null: false
1059
    t.integer "management_project_id"
1060 1061
    t.integer "cleanup_status", limit: 2, default: 1, null: false
    t.text "cleanup_status_reason"
1062
    t.index ["enabled"], name: "index_clusters_on_enabled"
1063
    t.index ["management_project_id"], name: "index_clusters_on_management_project_id", where: "(management_project_id IS NOT NULL)"
1064
    t.index ["user_id"], name: "index_clusters_on_user_id"
Amit Rathi's avatar
Amit Rathi committed
1065 1066
  end

Jasper Maes's avatar
Jasper Maes committed
1067
  create_table "clusters_applications_cert_managers", id: :serial, force: :cascade do |t|
1068 1069 1070 1071 1072 1073 1074
    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"
1075
    t.index ["cluster_id"], name: "index_clusters_applications_cert_managers_on_cluster_id", unique: true
1076 1077
  end

1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088
  create_table "clusters_applications_elastic_stacks", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "cluster_id", null: false
    t.integer "status", null: false
    t.string "version", limit: 255, null: false
    t.string "kibana_hostname", limit: 255
    t.text "status_reason"
    t.index ["cluster_id"], name: "index_clusters_applications_elastic_stacks_on_cluster_id", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
1089
  create_table "clusters_applications_helm", id: :serial, force: :cascade do |t|
1090
    t.integer "cluster_id", null: false
1091 1092
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1093 1094 1095
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
1096 1097 1098
    t.text "encrypted_ca_key"
    t.text "encrypted_ca_key_iv"
    t.text "ca_cert"
1099
    t.index ["cluster_id"], name: "index_clusters_applications_helm_on_cluster_id", unique: true
1100
  end
1101

Jasper Maes's avatar
Jasper Maes committed
1102
  create_table "clusters_applications_ingress", id: :serial, force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1103
    t.integer "cluster_id", null: false
1104 1105
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1106 1107 1108 1109 1110
    t.integer "status", null: false
    t.integer "ingress_type", null: false
    t.string "version", null: false
    t.string "cluster_ip"
    t.text "status_reason"
1111
    t.string "external_ip"
1112
    t.string "external_hostname"
1113
    t.index ["cluster_id"], name: "index_clusters_applications_ingress_on_cluster_id", unique: true
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1114 1115
  end

Jasper Maes's avatar
Jasper Maes committed
1116
  create_table "clusters_applications_jupyter", id: :serial, force: :cascade do |t|
1117
    t.integer "cluster_id", null: false
1118
    t.integer "oauth_application_id"
1119 1120 1121 1122 1123
    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
1124
    t.text "status_reason"
1125 1126
    t.index ["cluster_id"], name: "index_clusters_applications_jupyter_on_cluster_id", unique: true
    t.index ["oauth_application_id"], name: "index_clusters_applications_jupyter_on_oauth_application_id"
1127 1128
  end

Jasper Maes's avatar
Jasper Maes committed
1129
  create_table "clusters_applications_knative", id: :serial, force: :cascade do |t|
Chris Baumbauer's avatar
Chris Baumbauer committed
1130 1131 1132 1133 1134
    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
1135
    t.string "hostname"
Chris Baumbauer's avatar
Chris Baumbauer committed
1136
    t.text "status_reason"
1137
    t.string "external_ip"
1138
    t.string "external_hostname"
1139
    t.index ["cluster_id"], name: "index_clusters_applications_knative_on_cluster_id", unique: true
Chris Baumbauer's avatar
Chris Baumbauer committed
1140 1141
  end

Jasper Maes's avatar
Jasper Maes committed
1142
  create_table "clusters_applications_prometheus", id: :serial, force: :cascade do |t|
1143 1144 1145 1146 1147 1148
    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
1149
    t.datetime_with_timezone "last_update_started_at"
1150 1151
    t.string "encrypted_alert_manager_token"
    t.string "encrypted_alert_manager_token_iv"
1152
    t.index ["cluster_id"], name: "index_clusters_applications_prometheus_on_cluster_id", unique: true
1153 1154
  end

Jasper Maes's avatar
Jasper Maes committed
1155
  create_table "clusters_applications_runners", id: :serial, force: :cascade do |t|
1156 1157 1158 1159 1160 1161 1162
    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"
1163
    t.boolean "privileged", default: true, null: false
1164 1165
    t.index ["cluster_id"], name: "index_clusters_applications_runners_on_cluster_id", unique: true
    t.index ["runner_id"], name: "index_clusters_applications_runners_on_runner_id"
1166 1167
  end

Jasper Maes's avatar
Jasper Maes committed
1168
  create_table "clusters_kubernetes_namespaces", force: :cascade do |t|
1169 1170 1171 1172 1173 1174 1175 1176 1177
    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"
1178
    t.bigint "environment_id"
1179
    t.index ["cluster_id", "namespace"], name: "kubernetes_namespaces_cluster_and_namespace", unique: true
1180
    t.index ["cluster_id", "project_id", "environment_id"], name: "index_kubernetes_namespaces_on_cluster_project_environment_id", unique: true
1181 1182
    t.index ["cluster_id"], name: "index_clusters_kubernetes_namespaces_on_cluster_id"
    t.index ["cluster_project_id"], name: "index_clusters_kubernetes_namespaces_on_cluster_project_id"
1183
    t.index ["environment_id"], name: "index_clusters_kubernetes_namespaces_on_environment_id"
1184
    t.index ["project_id"], name: "index_clusters_kubernetes_namespaces_on_project_id"
1185 1186
  end

Jasper Maes's avatar
Jasper Maes committed
1187
  create_table "container_repositories", id: :serial, force: :cascade do |t|
1188 1189 1190 1191
    t.integer "project_id", null: false
    t.string "name", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1192 1193
    t.index ["project_id", "name"], name: "index_container_repositories_on_project_id_and_name", unique: true
    t.index ["project_id"], name: "index_container_repositories_on_project_id"
1194 1195
  end

Jasper Maes's avatar
Jasper Maes committed
1196
  create_table "conversational_development_index_metrics", id: :serial, force: :cascade do |t|
1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218
    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
1219 1220 1221 1222 1223 1224 1225 1226 1227 1228
    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
1229
  end
1230

1231 1232
  create_table "dependency_proxy_blobs", id: :serial, force: :cascade do |t|
    t.integer "group_id", null: false
1233
    t.datetime_with_timezone "created_at", null: false
1234
    t.datetime_with_timezone "updated_at", null: false
1235 1236 1237 1238
    t.bigint "size"
    t.integer "file_store"
    t.string "file_name", null: false
    t.text "file", null: false
1239
    t.index ["group_id", "file_name"], name: "index_dependency_proxy_blobs_on_group_id_and_file_name"
1240 1241 1242 1243
  end

  create_table "dependency_proxy_group_settings", id: :serial, force: :cascade do |t|
    t.integer "group_id", null: false
1244
    t.datetime_with_timezone "created_at", null: false
1245
    t.datetime_with_timezone "updated_at", null: false
1246
    t.boolean "enabled", default: false, null: false
1247
    t.index ["group_id"], name: "index_dependency_proxy_group_settings_on_group_id"
1248 1249
  end

Jasper Maes's avatar
Jasper Maes committed
1250
  create_table "deploy_keys_projects", id: :serial, force: :cascade do |t|
1251 1252
    t.integer "deploy_key_id", null: false
    t.integer "project_id", null: false
1253 1254
    t.datetime "created_at"
    t.datetime "updated_at"
1255
    t.boolean "can_push", default: false, null: false
1256
    t.index ["project_id"], name: "index_deploy_keys_projects_on_project_id"
1257
  end
1258

Jasper Maes's avatar
Jasper Maes committed
1259
  create_table "deploy_tokens", id: :serial, force: :cascade do |t|
1260
    t.boolean "revoked", default: false
1261 1262
    t.boolean "read_repository", default: false, null: false
    t.boolean "read_registry", default: false, null: false
1263
    t.datetime_with_timezone "expires_at", null: false
1264
    t.datetime_with_timezone "created_at", null: false
1265
    t.string "name", null: false
1266
    t.string "token"
1267
    t.string "username"
1268
    t.string "token_encrypted", limit: 255
1269 1270
    t.index ["token", "expires_at", "id"], name: "index_deploy_tokens_on_token_and_expires_at_and_id", where: "(revoked IS FALSE)"
    t.index ["token"], name: "index_deploy_tokens_on_token", unique: true
1271
    t.index ["token_encrypted"], name: "index_deploy_tokens_on_token_encrypted", unique: true
1272 1273
  end

1274 1275 1276 1277 1278 1279 1280
  create_table "deployment_merge_requests", id: false, force: :cascade do |t|
    t.integer "deployment_id", null: false
    t.integer "merge_request_id", null: false
    t.index ["deployment_id", "merge_request_id"], name: "idx_deployment_merge_requests_unique_index", unique: true
    t.index ["merge_request_id"], name: "index_deployment_merge_requests_on_merge_request_id"
  end

Jasper Maes's avatar
Jasper Maes committed
1281
  create_table "deployments", id: :serial, force: :cascade do |t|
Valery Sizov's avatar
Valery Sizov committed
1282 1283 1284 1285 1286 1287
    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
1288
    t.integer "user_id"
Valery Sizov's avatar
Valery Sizov committed
1289 1290
    t.integer "deployable_id"
    t.string "deployable_type"
1291 1292
    t.datetime "created_at"
    t.datetime "updated_at"
1293
    t.string "on_stop"
1294
    t.integer "status", limit: 2, null: false
Amit Rathi's avatar
Amit Rathi committed
1295
    t.datetime_with_timezone "finished_at"
1296
    t.integer "cluster_id"
1297
    t.index ["cluster_id", "status"], name: "index_deployments_on_cluster_id_and_status"
1298 1299 1300 1301 1302 1303 1304 1305 1306
    t.index ["created_at"], name: "index_deployments_on_created_at"
    t.index ["deployable_type", "deployable_id"], name: "index_deployments_on_deployable_type_and_deployable_id"
    t.index ["environment_id", "id"], name: "index_deployments_on_environment_id_and_id"
    t.index ["environment_id", "iid", "project_id"], name: "index_deployments_on_environment_id_and_iid_and_project_id"
    t.index ["environment_id", "status"], name: "index_deployments_on_environment_id_and_status"
    t.index ["id"], name: "partial_index_deployments_for_legacy_successful_deployments", where: "((finished_at IS NULL) AND (status = 2))"
    t.index ["project_id", "iid"], name: "index_deployments_on_project_id_and_iid", unique: true
    t.index ["project_id", "status", "created_at"], name: "index_deployments_on_project_id_and_status_and_created_at"
    t.index ["project_id", "status"], name: "index_deployments_on_project_id_and_status"
1307 1308
  end

1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320
  create_table "description_versions", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "issue_id"
    t.integer "merge_request_id"
    t.integer "epic_id"
    t.text "description"
    t.index ["epic_id"], name: "index_description_versions_on_epic_id", where: "(epic_id IS NOT NULL)"
    t.index ["issue_id"], name: "index_description_versions_on_issue_id", where: "(issue_id IS NOT NULL)"
    t.index ["merge_request_id"], name: "index_description_versions_on_merge_request_id", where: "(merge_request_id IS NOT NULL)"
  end

1321 1322
  create_table "design_management_designs", force: :cascade do |t|
    t.integer "project_id", null: false
1323
    t.integer "issue_id"
1324
    t.string "filename", null: false
1325 1326
    t.index ["issue_id", "filename"], name: "index_design_management_designs_on_issue_id_and_filename", unique: true
    t.index ["project_id"], name: "index_design_management_designs_on_project_id"
1327 1328 1329 1330 1331
  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
1332
    t.integer "event", limit: 2, default: 0, null: false
1333 1334
    t.index ["design_id", "version_id"], name: "design_management_designs_versions_uniqueness", unique: true
    t.index ["design_id"], name: "index_design_management_designs_versions_on_design_id"
1335
    t.index ["event"], name: "index_design_management_designs_versions_on_event"
1336
    t.index ["version_id"], name: "index_design_management_designs_versions_on_version_id"
1337 1338 1339 1340
  end

  create_table "design_management_versions", force: :cascade do |t|
    t.binary "sha", null: false
1341
    t.bigint "issue_id"
1342
    t.datetime_with_timezone "created_at"
1343 1344
    t.integer "author_id"
    t.index ["author_id"], name: "index_design_management_versions_on_author_id", where: "(author_id IS NOT NULL)"
1345 1346
    t.index ["issue_id"], name: "index_design_management_versions_on_issue_id"
    t.index ["sha", "issue_id"], name: "index_design_management_versions_on_sha_and_issue_id", unique: true
1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357
  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"
1358
    t.binary "commit_id"
1359 1360 1361
    t.index ["author_id"], name: "index_draft_notes_on_author_id"
    t.index ["discussion_id"], name: "index_draft_notes_on_discussion_id"
    t.index ["merge_request_id"], name: "index_draft_notes_on_merge_request_id"
1362 1363 1364 1365 1366 1367
  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"
1368
    t.index ["namespace_id"], name: "index_elasticsearch_indexed_namespaces_on_namespace_id", unique: true
1369 1370 1371 1372 1373 1374
  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"
1375
    t.index ["project_id"], name: "index_elasticsearch_indexed_projects_on_project_id", unique: true
1376 1377
  end

Jasper Maes's avatar
Jasper Maes committed
1378
  create_table "emails", id: :serial, force: :cascade do |t|
1379 1380
    t.integer "user_id", null: false
    t.string "email", null: false
1381 1382
    t.datetime "created_at"
    t.datetime "updated_at"
1383
    t.string "confirmation_token"
1384 1385
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
1386 1387 1388
    t.index ["confirmation_token"], name: "index_emails_on_confirmation_token", unique: true
    t.index ["email"], name: "index_emails_on_email", unique: true
    t.index ["user_id"], name: "index_emails_on_user_id"
1389 1390
  end

Jasper Maes's avatar
Jasper Maes committed
1391
  create_table "environments", id: :serial, force: :cascade do |t|
1392
    t.integer "project_id", null: false
1393
    t.string "name", null: false
1394 1395
    t.datetime "created_at"
    t.datetime "updated_at"
1396 1397
    t.string "external_url"
    t.string "environment_type"
1398
    t.string "state", default: "available", null: false
Nick Thomas's avatar
Nick Thomas committed
1399
    t.string "slug", null: false
1400 1401 1402
    t.index ["name"], name: "index_environments_on_name_varchar_pattern_ops", opclass: :varchar_pattern_ops
    t.index ["project_id", "name"], name: "index_environments_on_project_id_and_name", unique: true
    t.index ["project_id", "slug"], name: "index_environments_on_project_id_and_slug", unique: true
1403
    t.index ["project_id", "state"], name: "index_environments_on_project_id_and_state"
1404 1405
  end

1406 1407 1408
  create_table "epic_issues", id: :serial, force: :cascade do |t|
    t.integer "epic_id", null: false
    t.integer "issue_id", null: false
1409
    t.integer "relative_position"
1410 1411
    t.index ["epic_id"], name: "index_epic_issues_on_epic_id"
    t.index ["issue_id"], name: "index_epic_issues_on_issue_id", unique: true
1412 1413 1414 1415 1416 1417
  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
1418
    t.index ["epic_id"], name: "index_epic_metrics"
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
  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 "closed_by_id"
    t.datetime "closed_at"
    t.integer "parent_id"
    t.integer "relative_position"
1450
    t.integer "state_id", limit: 2, default: 1, null: false
1451 1452
    t.integer "start_date_sourcing_epic_id"
    t.integer "due_date_sourcing_epic_id"
1453 1454 1455
    t.index ["assignee_id"], name: "index_epics_on_assignee_id"
    t.index ["author_id"], name: "index_epics_on_author_id"
    t.index ["closed_by_id"], name: "index_epics_on_closed_by_id"
1456
    t.index ["due_date_sourcing_epic_id"], name: "index_epics_on_due_date_sourcing_epic_id", where: "(due_date_sourcing_epic_id IS NOT NULL)"
1457 1458 1459 1460 1461 1462
    t.index ["end_date"], name: "index_epics_on_end_date"
    t.index ["group_id"], name: "index_epics_on_group_id"
    t.index ["iid"], name: "index_epics_on_iid"
    t.index ["milestone_id"], name: "index_milestone"
    t.index ["parent_id"], name: "index_epics_on_parent_id"
    t.index ["start_date"], name: "index_epics_on_start_date"
1463
    t.index ["start_date_sourcing_epic_id"], name: "index_epics_on_start_date_sourcing_epic_id", where: "(start_date_sourcing_epic_id IS NOT NULL)"
1464 1465
  end

Jasper Maes's avatar
Jasper Maes committed
1466
  create_table "events", id: :serial, force: :cascade do |t|
1467 1468 1469
    t.integer "project_id"
    t.integer "author_id", null: false
    t.integer "target_id"
1470 1471
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1472 1473
    t.integer "action", limit: 2, null: false
    t.string "target_type"
1474
    t.bigint "group_id"
1475 1476 1477
    t.index ["action"], name: "index_events_on_action"
    t.index ["author_id", "project_id"], name: "index_events_on_author_id_and_project_id"
    t.index ["created_at", "author_id"], name: "analytics_index_events_on_created_at_and_author_id"
1478
    t.index ["group_id"], name: "index_events_on_group_id_partial", where: "(group_id IS NOT NULL)"
1479 1480 1481
    t.index ["project_id", "created_at"], name: "index_events_on_project_id_and_created_at"
    t.index ["project_id", "id"], name: "index_events_on_project_id_and_id"
    t.index ["target_type", "target_id"], name: "index_events_on_target_type_and_target_id"
1482 1483
  end

1484 1485 1486 1487 1488 1489 1490 1491 1492
  create_table "evidences", force: :cascade do |t|
    t.bigint "release_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.binary "summary_sha"
    t.jsonb "summary", default: {}, null: false
    t.index ["release_id"], name: "index_evidences_on_release_id"
  end

1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507
  create_table "external_pull_requests", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "project_id", null: false
    t.integer "pull_request_iid", null: false
    t.integer "status", limit: 2, null: false
    t.string "source_branch", limit: 255, null: false
    t.string "target_branch", limit: 255, null: false
    t.string "source_repository", limit: 255, null: false
    t.string "target_repository", limit: 255, null: false
    t.binary "source_sha", null: false
    t.binary "target_sha", null: false
    t.index ["project_id", "source_branch", "target_branch"], name: "index_external_pull_requests_on_project_and_branches", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
1508
  create_table "feature_gates", id: :serial, force: :cascade do |t|
1509 1510 1511 1512 1513
    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
1514
    t.index ["feature_key", "key", "value"], name: "index_feature_gates_on_feature_key_and_key_and_value", unique: true
1515 1516
  end

Jasper Maes's avatar
Jasper Maes committed
1517
  create_table "features", id: :serial, force: :cascade do |t|
1518 1519 1520
    t.string "key", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1521
    t.index ["key"], name: "index_features_on_key", unique: true
1522 1523
  end

Jasper Maes's avatar
Jasper Maes committed
1524
  create_table "fork_network_members", id: :serial, force: :cascade do |t|
1525 1526 1527
    t.integer "fork_network_id", null: false
    t.integer "project_id", null: false
    t.integer "forked_from_project_id"
1528 1529 1530
    t.index ["fork_network_id"], name: "index_fork_network_members_on_fork_network_id"
    t.index ["forked_from_project_id"], name: "index_fork_network_members_on_forked_from_project_id"
    t.index ["project_id"], name: "index_fork_network_members_on_project_id", unique: true
1531 1532
  end

Jasper Maes's avatar
Jasper Maes committed
1533
  create_table "fork_networks", id: :serial, force: :cascade do |t|
1534 1535
    t.integer "root_project_id"
    t.string "deleted_root_project_name"
1536
    t.index ["root_project_id"], name: "index_fork_networks_on_root_project_id", unique: true
1537 1538
  end

Jasper Maes's avatar
Jasper Maes committed
1539
  create_table "forked_project_links", id: :serial, force: :cascade do |t|
1540 1541
    t.integer "forked_to_project_id", null: false
    t.integer "forked_from_project_id", null: false
1542 1543
    t.datetime "created_at"
    t.datetime "updated_at"
1544
    t.index ["forked_to_project_id"], name: "index_forked_project_links_on_forked_to_project_id", unique: true
1545 1546
  end

1547 1548 1549 1550
  create_table "geo_cache_invalidation_events", force: :cascade do |t|
    t.string "key", null: false
  end

1551 1552 1553 1554 1555
  create_table "geo_container_repository_updated_events", force: :cascade do |t|
    t.integer "container_repository_id", null: false
    t.index ["container_repository_id"], name: "idx_geo_con_rep_updated_events_on_container_repository_id"
  end

1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569
  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"
1570
    t.bigint "container_repository_updated_event_id"
1571
    t.index ["cache_invalidation_event_id"], name: "index_geo_event_log_on_cache_invalidation_event_id", where: "(cache_invalidation_event_id IS NOT NULL)"
1572
    t.index ["container_repository_updated_event_id"], name: "index_geo_event_log_on_container_repository_updated_event_id"
1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583
    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)"
    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)"
    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)"
    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)"
    t.index ["repositories_changed_event_id"], name: "index_geo_event_log_on_repositories_changed_event_id", where: "(repositories_changed_event_id IS NOT NULL)"
    t.index ["repository_created_event_id"], name: "index_geo_event_log_on_repository_created_event_id", where: "(repository_created_event_id IS NOT NULL)"
    t.index ["repository_deleted_event_id"], name: "index_geo_event_log_on_repository_deleted_event_id", where: "(repository_deleted_event_id IS NOT NULL)"
    t.index ["repository_renamed_event_id"], name: "index_geo_event_log_on_repository_renamed_event_id", where: "(repository_renamed_event_id IS NOT NULL)"
    t.index ["repository_updated_event_id"], name: "index_geo_event_log_on_repository_updated_event_id", where: "(repository_updated_event_id IS NOT NULL)"
    t.index ["reset_checksum_event_id"], name: "index_geo_event_log_on_reset_checksum_event_id", where: "(reset_checksum_event_id IS NOT NULL)"
    t.index ["upload_deleted_event_id"], name: "index_geo_event_log_on_upload_deleted_event_id", where: "(upload_deleted_event_id IS NOT NULL)"
1584 1585 1586 1587 1588 1589
  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
1590
    t.index ["project_id"], name: "index_geo_hashed_storage_attachments_events_on_project_id"
1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601
  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
1602
    t.index ["project_id"], name: "index_geo_hashed_storage_migrated_events_on_project_id"
1603 1604 1605 1606 1607
  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
1608
    t.index ["job_artifact_id"], name: "index_geo_job_artifact_deleted_events_on_job_artifact_id"
1609 1610 1611 1612 1613 1614
  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
1615
    t.index ["lfs_object_id"], name: "index_geo_lfs_object_deleted_events_on_lfs_object_id"
1616 1617 1618 1619 1620 1621 1622
  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
1623 1624 1625
    t.index ["geo_node_id", "namespace_id"], name: "index_geo_node_namespace_links_on_geo_node_id_and_namespace_id", unique: true
    t.index ["geo_node_id"], name: "index_geo_node_namespace_links_on_geo_node_id"
    t.index ["namespace_id"], name: "index_geo_node_namespace_links_on_namespace_id"
1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673
  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"
1674 1675 1676 1677
    t.integer "container_repositories_count"
    t.integer "container_repositories_synced_count"
    t.integer "container_repositories_failed_count"
    t.integer "container_repositories_registry_count"
1678 1679 1680 1681
    t.integer "design_repositories_count"
    t.integer "design_repositories_synced_count"
    t.integer "design_repositories_failed_count"
    t.integer "design_repositories_registry_count"
1682
    t.index ["geo_node_id"], name: "index_geo_node_statuses_on_geo_node_id", unique: true
1683 1684 1685
  end

  create_table "geo_nodes", id: :serial, force: :cascade do |t|
1686
    t.boolean "primary", default: false, null: false
1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701
    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
1702
    t.integer "container_repositories_max_capacity", default: 10, null: false
1703 1704
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
1705
    t.boolean "sync_object_storage", default: false, null: false
1706 1707 1708
    t.index ["access_key"], name: "index_geo_nodes_on_access_key"
    t.index ["name"], name: "index_geo_nodes_on_name", unique: true
    t.index ["primary"], name: "index_geo_nodes_on_primary"
1709 1710 1711 1712
  end

  create_table "geo_repositories_changed_events", force: :cascade do |t|
    t.integer "geo_node_id", null: false
1713
    t.index ["geo_node_id"], name: "index_geo_repositories_changed_events_on_geo_node_id"
1714 1715 1716 1717 1718 1719 1720 1721
  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
1722
    t.index ["project_id"], name: "index_geo_repository_created_events_on_project_id"
1723 1724 1725 1726 1727 1728 1729 1730
  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
1731
    t.index ["project_id"], name: "index_geo_repository_deleted_events_on_project_id"
1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742
  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
1743
    t.index ["project_id"], name: "index_geo_repository_renamed_events_on_project_id"
1744 1745 1746 1747 1748 1749 1750 1751 1752 1753
  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"
1754 1755
    t.index ["project_id"], name: "index_geo_repository_updated_events_on_project_id"
    t.index ["source"], name: "index_geo_repository_updated_events_on_source"
1756 1757 1758 1759
  end

  create_table "geo_reset_checksum_events", force: :cascade do |t|
    t.integer "project_id", null: false
1760
    t.index ["project_id"], name: "index_geo_reset_checksum_events_on_project_id"
1761 1762 1763 1764 1765 1766 1767 1768
  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
1769
    t.index ["upload_id"], name: "index_geo_upload_deleted_events_on_upload_id"
1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782
  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
1783 1784
    t.index ["hosted_plan_id"], name: "index_gitlab_subscriptions_on_hosted_plan_id"
    t.index ["namespace_id"], name: "index_gitlab_subscriptions_on_namespace_id", unique: true
1785 1786
  end

Jasper Maes's avatar
Jasper Maes committed
1787
  create_table "gpg_key_subkeys", id: :serial, force: :cascade do |t|
1788
    t.integer "gpg_key_id", null: false
1789 1790
    t.binary "keyid"
    t.binary "fingerprint"
1791 1792 1793
    t.index ["fingerprint"], name: "index_gpg_key_subkeys_on_fingerprint", unique: true
    t.index ["gpg_key_id"], name: "index_gpg_key_subkeys_on_gpg_key_id"
    t.index ["keyid"], name: "index_gpg_key_subkeys_on_keyid", unique: true
1794 1795
  end

Jasper Maes's avatar
Jasper Maes committed
1796
  create_table "gpg_keys", id: :serial, force: :cascade do |t|
1797 1798
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1799
    t.integer "user_id"
1800 1801
    t.binary "primary_keyid"
    t.binary "fingerprint"
1802
    t.text "key"
1803 1804 1805
    t.index ["fingerprint"], name: "index_gpg_keys_on_fingerprint", unique: true
    t.index ["primary_keyid"], name: "index_gpg_keys_on_primary_keyid", unique: true
    t.index ["user_id"], name: "index_gpg_keys_on_user_id"
Alexis Reigel's avatar
Alexis Reigel committed
1806 1807
  end

Jasper Maes's avatar
Jasper Maes committed
1808
  create_table "gpg_signatures", id: :serial, force: :cascade do |t|
1809 1810
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1811 1812
    t.integer "project_id"
    t.integer "gpg_key_id"
1813 1814
    t.binary "commit_sha"
    t.binary "gpg_key_primary_keyid"
1815 1816
    t.text "gpg_key_user_name"
    t.text "gpg_key_user_email"
1817
    t.integer "verification_status", limit: 2, default: 0, null: false
1818
    t.integer "gpg_key_subkey_id"
1819 1820 1821 1822 1823
    t.index ["commit_sha"], name: "index_gpg_signatures_on_commit_sha", unique: true
    t.index ["gpg_key_id"], name: "index_gpg_signatures_on_gpg_key_id"
    t.index ["gpg_key_primary_keyid"], name: "index_gpg_signatures_on_gpg_key_primary_keyid"
    t.index ["gpg_key_subkey_id"], name: "index_gpg_signatures_on_gpg_key_subkey_id"
    t.index ["project_id"], name: "index_gpg_signatures_on_project_id"
1824 1825
  end

1826 1827 1828 1829 1830 1831 1832
  create_table "grafana_integrations", force: :cascade do |t|
    t.bigint "project_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "encrypted_token", limit: 255, null: false
    t.string "encrypted_token_iv", limit: 255, null: false
    t.string "grafana_url", limit: 1024, null: false
1833
    t.boolean "enabled", default: false, null: false
1834 1835 1836
    t.index ["project_id"], name: "index_grafana_integrations_on_project_id"
  end

Jasper Maes's avatar
Jasper Maes committed
1837
  create_table "group_custom_attributes", id: :serial, force: :cascade do |t|
1838 1839
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
1840 1841 1842
    t.integer "group_id", null: false
    t.string "key", null: false
    t.string "value", null: false
1843 1844
    t.index ["group_id", "key"], name: "index_group_custom_attributes_on_group_id_and_key", unique: true
    t.index ["key", "value"], name: "index_group_custom_attributes_on_key_and_value"
1845 1846
  end

1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857
  create_table "group_group_links", force: :cascade do |t|
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.bigint "shared_group_id", null: false
    t.bigint "shared_with_group_id", null: false
    t.date "expires_at"
    t.integer "group_access", limit: 2, default: 30, null: false
    t.index ["shared_group_id", "shared_with_group_id"], name: "index_group_group_links_on_shared_group_and_shared_with_group", unique: true
    t.index ["shared_with_group_id"], name: "index_group_group_links_on_shared_with_group_id"
  end

1858 1859 1860 1861 1862 1863 1864
  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
1865
  create_table "identities", id: :serial, force: :cascade do |t|
1866 1867 1868
    t.string "extern_uid"
    t.string "provider"
    t.integer "user_id"
1869 1870
    t.datetime "created_at"
    t.datetime "updated_at"
1871
    t.string "secondary_extern_uid"
1872
    t.integer "saml_provider_id"
1873
    t.index "lower((extern_uid)::text), provider", name: "index_on_identities_lower_extern_uid_and_provider"
1874 1875
    t.index ["saml_provider_id"], name: "index_identities_on_saml_provider_id", where: "(saml_provider_id IS NOT NULL)"
    t.index ["user_id"], name: "index_identities_on_user_id"
1876 1877
  end

Jasper Maes's avatar
Jasper Maes committed
1878
  create_table "import_export_uploads", id: :serial, force: :cascade do |t|
1879 1880 1881 1882
    t.datetime_with_timezone "updated_at", null: false
    t.integer "project_id"
    t.text "import_file"
    t.text "export_file"
1883 1884
    t.bigint "group_id"
    t.index ["group_id"], name: "index_import_export_uploads_on_group_id", unique: true, where: "(group_id IS NOT NULL)"
1885 1886
    t.index ["project_id"], name: "index_import_export_uploads_on_project_id"
    t.index ["updated_at"], name: "index_import_export_uploads_on_updated_at"
1887 1888
  end

1889 1890 1891 1892 1893 1894 1895
  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
1896 1897
    t.binary "last_wiki_commit"
    t.datetime_with_timezone "wiki_indexed_at"
1898
    t.index ["project_id"], name: "index_index_statuses_on_project_id", unique: true
1899 1900 1901 1902 1903
  end

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

Jasper Maes's avatar
Jasper Maes committed
1908
  create_table "internal_ids", force: :cascade do |t|
1909
    t.integer "project_id"
1910 1911
    t.integer "usage", null: false
    t.integer "last_value", null: false
1912
    t.integer "namespace_id"
1913 1914 1915 1916
    t.index ["namespace_id"], name: "index_internal_ids_on_namespace_id"
    t.index ["project_id"], name: "index_internal_ids_on_project_id"
    t.index ["usage", "namespace_id"], name: "index_internal_ids_on_usage_and_namespace_id", unique: true, where: "(namespace_id IS NOT NULL)"
    t.index ["usage", "project_id"], name: "index_internal_ids_on_usage_and_project_id", unique: true, where: "(project_id IS NOT NULL)"
1917 1918
  end

1919 1920 1921
  create_table "ip_restrictions", force: :cascade do |t|
    t.integer "group_id", null: false
    t.string "range", null: false
1922
    t.index ["group_id"], name: "index_ip_restrictions_on_group_id"
1923 1924
  end

1925
  create_table "issue_assignees", id: false, force: :cascade do |t|
1926 1927
    t.integer "user_id", null: false
    t.integer "issue_id", null: false
1928 1929
    t.index ["issue_id", "user_id"], name: "index_issue_assignees_on_issue_id_and_user_id", unique: true
    t.index ["user_id"], name: "index_issue_assignees_on_user_id"
1930 1931
  end

1932 1933 1934 1935 1936
  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"
1937 1938 1939
    t.index ["source_id", "target_id"], name: "index_issue_links_on_source_id_and_target_id", unique: true
    t.index ["source_id"], name: "index_issue_links_on_source_id"
    t.index ["target_id"], name: "index_issue_links_on_target_id"
1940 1941
  end

Jasper Maes's avatar
Jasper Maes committed
1942
  create_table "issue_metrics", id: :serial, force: :cascade do |t|
1943
    t.integer "issue_id", null: false
1944
    t.datetime "first_mentioned_in_commit_at"
1945 1946
    t.datetime "first_associated_with_milestone_at"
    t.datetime "first_added_to_board_at"
1947 1948
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1949
    t.index ["issue_id", "first_mentioned_in_commit_at", "first_associated_with_milestone_at", "first_added_to_board_at"], name: "index_issue_metrics_on_issue_id_and_timestamps"
1950
    t.index ["issue_id"], name: "index_issue_metrics"
1951 1952
  end

1953 1954 1955 1956 1957 1958 1959 1960 1961 1962
  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"
1963
    t.index ["service_id"], name: "index_issue_tracker_data_on_service_id"
1964 1965
  end

Jasper Maes's avatar
Jasper Maes committed
1966
  create_table "issues", id: :serial, force: :cascade do |t|
1967 1968 1969
    t.string "title"
    t.integer "author_id"
    t.integer "project_id"
1970 1971
    t.datetime "created_at"
    t.datetime "updated_at"
1972 1973 1974 1975 1976
    t.text "description"
    t.integer "milestone_id"
    t.string "state"
    t.integer "iid"
    t.integer "updated_by_id"
1977
    t.integer "weight"
1978
    t.boolean "confidential", default: false, null: false
1979 1980 1981 1982 1983
    t.date "due_date"
    t.integer "moved_to_id"
    t.integer "lock_version"
    t.text "title_html"
    t.text "description_html"
1984
    t.integer "time_estimate"
1985
    t.integer "relative_position"
1986
    t.string "service_desk_reply_to"
1987
    t.integer "cached_markdown_version"
1988 1989
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
1990
    t.boolean "discussion_locked"
1991
    t.datetime_with_timezone "closed_at"
haseeb's avatar
haseeb committed
1992
    t.integer "closed_by_id"
1993
    t.integer "state_id", limit: 2, default: 1, null: false
1994
    t.integer "duplicated_to_id"
1995 1996 1997 1998
    t.index ["author_id"], name: "index_issues_on_author_id"
    t.index ["closed_by_id"], name: "index_issues_on_closed_by_id"
    t.index ["confidential"], name: "index_issues_on_confidential"
    t.index ["description"], name: "index_issues_on_description_trigram", opclass: :gin_trgm_ops, using: :gin
1999
    t.index ["duplicated_to_id"], name: "index_issues_on_duplicated_to_id", where: "(duplicated_to_id IS NOT NULL)"
2000 2001 2002
    t.index ["milestone_id"], name: "index_issues_on_milestone_id"
    t.index ["moved_to_id"], name: "index_issues_on_moved_to_id", where: "(moved_to_id IS NOT NULL)"
    t.index ["project_id", "created_at", "id", "state"], name: "index_issues_on_project_id_and_created_at_and_id_and_state"
2003
    t.index ["project_id", "created_at", "id", "state_id"], name: "idx_issues_on_project_id_and_created_at_and_id_and_state_id"
2004
    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)"
2005
    t.index ["project_id", "due_date", "id", "state_id"], name: "idx_issues_on_project_id_and_due_date_and_id_and_state_id", where: "(due_date IS NOT NULL)"
2006
    t.index ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true
2007
    t.index ["project_id", "relative_position", "state", "id"], name: "index_issues_on_project_id_and_rel_position_and_state_and_id", order: { id: :desc }
2008
    t.index ["project_id", "relative_position", "state_id", "id"], name: "idx_issues_on_project_id_and_rel_position_and_state_id_and_id", order: { id: :desc }
2009
    t.index ["project_id", "updated_at", "id", "state"], name: "index_issues_on_project_id_and_updated_at_and_id_and_state"
2010
    t.index ["project_id", "updated_at", "id", "state_id"], name: "idx_issues_on_project_id_and_updated_at_and_id_and_state_id"
2011 2012
    t.index ["relative_position"], name: "index_issues_on_relative_position"
    t.index ["state"], name: "index_issues_on_state"
2013
    t.index ["state_id"], name: "idx_issues_on_state_id"
2014 2015 2016
    t.index ["title"], name: "index_issues_on_title_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["updated_at"], name: "index_issues_on_updated_at"
    t.index ["updated_by_id"], name: "index_issues_on_updated_by_id", where: "(updated_by_id IS NOT NULL)"
Andrew8xx8's avatar
Andrew8xx8 committed
2017 2018
  end

2019 2020 2021 2022 2023 2024 2025 2026 2027
  create_table "issues_prometheus_alert_events", id: false, force: :cascade do |t|
    t.bigint "issue_id", null: false
    t.bigint "prometheus_alert_event_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["issue_id", "prometheus_alert_event_id"], name: "issue_id_prometheus_alert_event_id_index", unique: true
    t.index ["prometheus_alert_event_id"], name: "issue_id_issues_prometheus_alert_events_index"
  end

2028 2029 2030 2031 2032 2033 2034 2035 2036
  create_table "issues_self_managed_prometheus_alert_events", id: false, force: :cascade do |t|
    t.bigint "issue_id", null: false
    t.bigint "self_managed_prometheus_alert_event_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.index ["issue_id", "self_managed_prometheus_alert_event_id"], name: "issue_id_self_managed_prometheus_alert_event_id_index", unique: true
    t.index ["self_managed_prometheus_alert_event_id"], name: "issue_id_issues_self_managed_rometheus_alert_events_index"
  end

2037 2038 2039 2040 2041
  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"
2042
    t.index ["client_key"], name: "index_jira_connect_installations_on_client_key", unique: true
2043 2044 2045 2046 2047
  end

  create_table "jira_connect_subscriptions", force: :cascade do |t|
    t.bigint "jira_connect_installation_id", null: false
    t.integer "namespace_id", null: false
2048
    t.datetime_with_timezone "created_at", null: false
2049
    t.datetime_with_timezone "updated_at", null: false
2050 2051 2052
    t.index ["jira_connect_installation_id", "namespace_id"], name: "idx_jira_connect_subscriptions_on_installation_id_namespace_id", unique: true
    t.index ["jira_connect_installation_id"], name: "idx_jira_connect_subscriptions_on_installation_id"
    t.index ["namespace_id"], name: "index_jira_connect_subscriptions_on_namespace_id"
2053 2054
  end

2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067
  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"
2068
    t.index ["service_id"], name: "index_jira_tracker_data_on_service_id"
2069 2070
  end

Jasper Maes's avatar
Jasper Maes committed
2071
  create_table "keys", id: :serial, force: :cascade do |t|
2072
    t.integer "user_id"
2073 2074
    t.datetime "created_at"
    t.datetime "updated_at"
2075 2076 2077 2078 2079
    t.text "key"
    t.string "title"
    t.string "type"
    t.string "fingerprint"
    t.boolean "public", default: false, null: false
2080
    t.datetime "last_used_at"
2081
    t.index ["fingerprint"], name: "index_keys_on_fingerprint", unique: true
2082
    t.index ["id", "type"], name: "index_on_deploy_keys_id_and_type_and_public", unique: true, where: "(public = true)"
2083
    t.index ["user_id"], name: "index_keys_on_user_id"
Andrew8xx8's avatar
Andrew8xx8 committed
2084 2085
  end

Jasper Maes's avatar
Jasper Maes committed
2086
  create_table "label_links", id: :serial, force: :cascade do |t|
2087 2088 2089
    t.integer "label_id"
    t.integer "target_id"
    t.string "target_type"
2090 2091
    t.datetime "created_at"
    t.datetime "updated_at"
2092 2093
    t.index ["label_id"], name: "index_label_links_on_label_id"
    t.index ["target_id", "target_type"], name: "index_label_links_on_target_id_and_target_type"
2094 2095
  end

Jasper Maes's avatar
Jasper Maes committed
2096
  create_table "label_priorities", id: :serial, force: :cascade do |t|
2097 2098 2099 2100 2101
    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
2102 2103 2104
    t.index ["label_id"], name: "index_label_priorities_on_label_id"
    t.index ["priority"], name: "index_label_priorities_on_priority"
    t.index ["project_id", "label_id"], name: "index_label_priorities_on_project_id_and_label_id", unique: true
2105 2106
  end

Jasper Maes's avatar
Jasper Maes committed
2107
  create_table "labels", id: :serial, force: :cascade do |t|
2108 2109 2110
    t.string "title"
    t.string "color"
    t.integer "project_id"
2111 2112
    t.datetime "created_at"
    t.datetime "updated_at"
2113 2114 2115
    t.boolean "template", default: false
    t.string "description"
    t.text "description_html"
2116 2117
    t.string "type"
    t.integer "group_id"
2118
    t.integer "cached_markdown_version"
2119 2120 2121 2122 2123
    t.index ["group_id", "project_id", "title"], name: "index_labels_on_group_id_and_project_id_and_title", unique: true
    t.index ["project_id"], name: "index_labels_on_project_id"
    t.index ["template"], name: "index_labels_on_template", where: "template"
    t.index ["title"], name: "index_labels_on_title"
    t.index ["type", "project_id"], name: "index_labels_on_type_and_project_id"
2124 2125
  end

2126 2127 2128 2129 2130 2131 2132 2133 2134 2135
  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
2136
  create_table "lfs_file_locks", id: :serial, force: :cascade do |t|
2137 2138 2139 2140
    t.integer "project_id", null: false
    t.integer "user_id", null: false
    t.datetime "created_at", null: false
    t.string "path", limit: 511
2141 2142
    t.index ["project_id", "path"], name: "index_lfs_file_locks_on_project_id_and_path", unique: true
    t.index ["user_id"], name: "index_lfs_file_locks_on_user_id"
2143 2144
  end

Jasper Maes's avatar
Jasper Maes committed
2145
  create_table "lfs_objects", id: :serial, force: :cascade do |t|
2146
    t.string "oid", null: false
2147
    t.bigint "size", null: false
Marin Jankovski's avatar
Marin Jankovski committed
2148 2149
    t.datetime "created_at"
    t.datetime "updated_at"
2150
    t.string "file"
2151
    t.integer "file_store"
2152 2153
    t.index ["file_store"], name: "index_lfs_objects_on_file_store"
    t.index ["oid"], name: "index_lfs_objects_on_oid", unique: true
Marin Jankovski's avatar
Marin Jankovski committed
2154 2155
  end

Jasper Maes's avatar
Jasper Maes committed
2156
  create_table "lfs_objects_projects", id: :serial, force: :cascade do |t|
2157 2158
    t.integer "lfs_object_id", null: false
    t.integer "project_id", null: false
Marin Jankovski's avatar
Marin Jankovski committed
2159 2160
    t.datetime "created_at"
    t.datetime "updated_at"
2161
    t.integer "repository_type", limit: 2
2162 2163
    t.index ["lfs_object_id"], name: "index_lfs_objects_projects_on_lfs_object_id"
    t.index ["project_id"], name: "index_lfs_objects_projects_on_project_id"
Marin Jankovski's avatar
Marin Jankovski committed
2164 2165
  end

2166 2167 2168 2169 2170 2171
  create_table "licenses", id: :serial, force: :cascade do |t|
    t.text "data", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182
  create_table "list_user_preferences", force: :cascade do |t|
    t.bigint "user_id", null: false
    t.bigint "list_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.boolean "collapsed"
    t.index ["list_id"], name: "index_list_user_preferences_on_list_id"
    t.index ["user_id", "list_id"], name: "index_list_user_preferences_on_user_id_and_list_id", unique: true
    t.index ["user_id"], name: "index_list_user_preferences_on_user_id"
  end

Jasper Maes's avatar
Jasper Maes committed
2183
  create_table "lists", id: :serial, force: :cascade do |t|
2184 2185 2186 2187 2188 2189
    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
2190
    t.integer "user_id"
2191
    t.integer "milestone_id"
2192
    t.integer "max_issue_count", default: 0, null: false
2193 2194 2195 2196 2197
    t.index ["board_id", "label_id"], name: "index_lists_on_board_id_and_label_id", unique: true
    t.index ["label_id"], name: "index_lists_on_label_id"
    t.index ["list_type"], name: "index_lists_on_list_type"
    t.index ["milestone_id"], name: "index_lists_on_milestone_id"
    t.index ["user_id"], name: "index_lists_on_user_id"
2198 2199
  end

Jasper Maes's avatar
Jasper Maes committed
2200
  create_table "members", id: :serial, force: :cascade do |t|
2201 2202 2203 2204 2205 2206
    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"
2207 2208
    t.datetime "created_at"
    t.datetime "updated_at"
2209 2210 2211
    t.integer "created_by_id"
    t.string "invite_email"
    t.string "invite_token"
Douwe Maan's avatar
Douwe Maan committed
2212
    t.datetime "invite_accepted_at"
2213
    t.datetime "requested_at"
2214
    t.date "expires_at"
2215 2216
    t.boolean "ldap", default: false, null: false
    t.boolean "override", default: false, null: false
2217
    t.index ["access_level"], name: "index_members_on_access_level"
2218
    t.index ["expires_at"], name: "index_members_on_expires_at"
2219 2220 2221 2222 2223
    t.index ["invite_email"], name: "index_members_on_invite_email"
    t.index ["invite_token"], name: "index_members_on_invite_token", unique: true
    t.index ["requested_at"], name: "index_members_on_requested_at"
    t.index ["source_id", "source_type"], name: "index_members_on_source_id_and_source_type"
    t.index ["user_id"], name: "index_members_on_user_id"
2224 2225
  end

2226 2227 2228
  create_table "merge_request_assignees", force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "merge_request_id", null: false
2229 2230 2231
    t.index ["merge_request_id", "user_id"], name: "index_merge_request_assignees_on_merge_request_id_and_user_id", unique: true
    t.index ["merge_request_id"], name: "index_merge_request_assignees_on_merge_request_id"
    t.index ["user_id"], name: "index_merge_request_assignees_on_user_id"
2232 2233
  end

2234 2235 2236 2237 2238
  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
2239 2240
    t.index ["blocked_merge_request_id"], name: "index_merge_request_blocks_on_blocked_merge_request_id"
    t.index ["blocking_merge_request_id", "blocked_merge_request_id"], name: "index_mr_blocks_on_blocking_and_blocked_mr_ids", unique: true
2241 2242
  end

2243
  create_table "merge_request_diff_commits", id: false, force: :cascade do |t|
2244 2245
    t.datetime "authored_date"
    t.datetime "committed_date"
2246 2247 2248 2249 2250 2251 2252 2253
    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"
2254 2255
    t.index ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_commits_on_mr_diff_id_and_order", unique: true
    t.index ["sha"], name: "index_merge_request_diff_commits_on_sha"
2256 2257
  end

2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268
  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
2269
    t.text "diff"
2270
    t.boolean "binary"
2271 2272
    t.integer "external_diff_offset"
    t.integer "external_diff_size"
2273
    t.index ["merge_request_diff_id", "relative_order"], name: "index_merge_request_diff_files_on_mr_diff_id_and_order", unique: true
2274 2275
  end

Jasper Maes's avatar
Jasper Maes committed
2276
  create_table "merge_request_diffs", id: :serial, force: :cascade do |t|
2277 2278
    t.string "state"
    t.integer "merge_request_id", null: false
2279 2280
    t.datetime "created_at"
    t.datetime "updated_at"
2281 2282 2283 2284
    t.string "base_commit_sha"
    t.string "real_size"
    t.string "head_commit_sha"
    t.string "start_commit_sha"
2285
    t.integer "commits_count"
2286 2287 2288
    t.string "external_diff"
    t.integer "external_diff_store"
    t.boolean "stored_externally"
2289 2290
    t.index ["merge_request_id", "id"], name: "index_merge_request_diffs_on_merge_request_id_and_id"
    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))"
2291 2292
  end

Jasper Maes's avatar
Jasper Maes committed
2293
  create_table "merge_request_metrics", id: :serial, force: :cascade do |t|
2294
    t.integer "merge_request_id", null: false
2295 2296
    t.datetime "latest_build_started_at"
    t.datetime "latest_build_finished_at"
Timothy Andrew's avatar
Timothy Andrew committed
2297 2298
    t.datetime "first_deployed_to_production_at"
    t.datetime "merged_at"
2299 2300
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2301
    t.integer "pipeline_id"
2302 2303 2304
    t.integer "merged_by_id"
    t.integer "latest_closed_by_id"
    t.datetime_with_timezone "latest_closed_at"
2305 2306 2307 2308 2309 2310
    t.datetime_with_timezone "first_comment_at"
    t.datetime_with_timezone "first_commit_at"
    t.datetime_with_timezone "last_commit_at"
    t.integer "diff_size"
    t.integer "modified_paths_size"
    t.integer "commits_count"
2311 2312 2313 2314 2315
    t.index ["first_deployed_to_production_at"], name: "index_merge_request_metrics_on_first_deployed_to_production_at"
    t.index ["latest_closed_at"], name: "index_merge_request_metrics_on_latest_closed_at", where: "(latest_closed_at IS NOT NULL)"
    t.index ["latest_closed_by_id"], name: "index_merge_request_metrics_on_latest_closed_by_id"
    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)"
    t.index ["merge_request_id"], name: "index_merge_request_metrics"
2316
    t.index ["merged_at"], name: "index_merge_request_metrics_on_merged_at"
2317 2318
    t.index ["merged_by_id"], name: "index_merge_request_metrics_on_merged_by_id"
    t.index ["pipeline_id"], name: "index_merge_request_metrics_on_pipeline_id"
2319 2320
  end

Jasper Maes's avatar
Jasper Maes committed
2321
  create_table "merge_requests", id: :serial, force: :cascade do |t|
2322 2323
    t.string "target_branch", null: false
    t.string "source_branch", null: false
2324
    t.integer "source_project_id"
2325 2326 2327
    t.integer "author_id"
    t.integer "assignee_id"
    t.string "title"
2328 2329
    t.datetime "created_at"
    t.datetime "updated_at"
2330
    t.integer "milestone_id"
2331 2332
    t.string "state", default: "opened", null: false
    t.string "merge_status", default: "unchecked", null: false
2333 2334 2335 2336 2337 2338
    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"
2339
    t.boolean "merge_when_pipeline_succeeds", default: false, null: false
2340 2341
    t.integer "merge_user_id"
    t.string "merge_commit_sha"
2342 2343
    t.integer "approvals_before_merge"
    t.string "rebase_commit_sha"
2344
    t.string "in_progress_merge_commit_sha"
Valery Sizov's avatar
Valery Sizov committed
2345
    t.integer "lock_version"
2346 2347
    t.text "title_html"
    t.text "description_html"
2348
    t.integer "time_estimate"
2349
    t.boolean "squash", default: false, null: false
2350
    t.integer "cached_markdown_version"
2351 2352
    t.datetime "last_edited_at"
    t.integer "last_edited_by_id"
2353
    t.integer "head_pipeline_id"
2354
    t.string "merge_jid"
2355
    t.boolean "discussion_locked"
2356
    t.integer "latest_merge_request_diff_id"
2357
    t.boolean "allow_maintainer_to_push"
2358
    t.integer "state_id", limit: 2, default: 1, null: false
2359
    t.string "rebase_jid"
2360
    t.binary "squash_commit_sha"
2361 2362 2363 2364 2365
    t.index ["assignee_id"], name: "index_merge_requests_on_assignee_id"
    t.index ["author_id"], name: "index_merge_requests_on_author_id"
    t.index ["created_at"], name: "index_merge_requests_on_created_at"
    t.index ["description"], name: "index_merge_requests_on_description_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["head_pipeline_id"], name: "index_merge_requests_on_head_pipeline_id"
2366
    t.index ["id", "merge_jid"], name: "idx_merge_requests_on_id_and_merge_jid", where: "((merge_jid IS NOT NULL) AND (state_id = 4))"
2367 2368 2369 2370 2371
    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))"
    t.index ["latest_merge_request_diff_id"], name: "index_merge_requests_on_latest_merge_request_diff_id"
    t.index ["merge_user_id"], name: "index_merge_requests_on_merge_user_id", where: "(merge_user_id IS NOT NULL)"
    t.index ["milestone_id"], name: "index_merge_requests_on_milestone_id"
    t.index ["source_branch"], name: "index_merge_requests_on_source_branch"
2372
    t.index ["source_project_id", "source_branch"], name: "idx_merge_requests_on_source_project_and_branch_state_opened", where: "(state_id = 1)"
2373 2374 2375
    t.index ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_and_branch_state_opened", where: "((state)::text = 'opened'::text)"
    t.index ["source_project_id", "source_branch"], name: "index_merge_requests_on_source_project_id_and_source_branch"
    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))"
2376
    t.index ["state_id", "merge_status"], name: "idx_merge_requests_on_state_id_and_merge_status", where: "((state_id = 1) AND ((merge_status)::text = 'can_be_merged'::text))"
2377
    t.index ["target_branch"], name: "index_merge_requests_on_target_branch"
2378
    t.index ["target_project_id", "created_at"], name: "index_merge_requests_target_project_id_created_at"
2379
    t.index ["target_project_id", "iid"], name: "idx_merge_requests_on_target_project_id_and_iid_opened", where: "(state_id = 1)"
2380 2381 2382
    t.index ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid", unique: true
    t.index ["target_project_id", "iid"], name: "index_merge_requests_on_target_project_id_and_iid_opened", where: "((state)::text = 'opened'::text)"
    t.index ["target_project_id", "merge_commit_sha", "id"], name: "index_merge_requests_on_tp_id_and_merge_commit_sha_and_id"
2383
    t.index ["target_project_id", "target_branch"], name: "index_merge_requests_on_target_project_id_and_target_branch", where: "((state_id = 1) AND (merge_when_pipeline_succeeds = true))"
2384 2385 2386
    t.index ["title"], name: "index_merge_requests_on_title"
    t.index ["title"], name: "index_merge_requests_on_title_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["updated_by_id"], name: "index_merge_requests_on_updated_by_id", where: "(updated_by_id IS NOT NULL)"
Andrew8xx8's avatar
Andrew8xx8 committed
2387
  end
tiagonbotelho's avatar
tiagonbotelho committed
2388

Jasper Maes's avatar
Jasper Maes committed
2389
  create_table "merge_requests_closing_issues", id: :serial, force: :cascade do |t|
2390 2391 2392 2393
    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
2394 2395
    t.index ["issue_id"], name: "index_merge_requests_closing_issues_on_issue_id"
    t.index ["merge_request_id"], name: "index_merge_requests_closing_issues_on_merge_request_id"
2396 2397
  end

2398 2399 2400 2401 2402 2403
  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
2404 2405
    t.integer "target_project_id", null: false
    t.text "target_branch", null: false
2406 2407 2408 2409
    t.index ["merge_request_id"], name: "index_merge_trains_on_merge_request_id", unique: true
    t.index ["pipeline_id"], name: "index_merge_trains_on_pipeline_id"
    t.index ["target_project_id"], name: "index_merge_trains_on_target_project_id"
    t.index ["user_id"], name: "index_merge_trains_on_user_id"
2410 2411
  end

2412
  create_table "milestone_releases", id: false, force: :cascade do |t|
2413 2414 2415 2416 2417 2418
    t.bigint "milestone_id", null: false
    t.bigint "release_id", null: false
    t.index ["milestone_id", "release_id"], name: "index_miletone_releases_on_milestone_and_release", unique: true
    t.index ["release_id"], name: "index_milestone_releases_on_release_id"
  end

Jasper Maes's avatar
Jasper Maes committed
2419
  create_table "milestones", id: :serial, force: :cascade do |t|
2420
    t.string "title", null: false
Felipe Artur's avatar
Felipe Artur committed
2421
    t.integer "project_id"
2422 2423
    t.text "description"
    t.date "due_date"
2424 2425
    t.datetime "created_at"
    t.datetime "updated_at"
2426 2427 2428 2429
    t.string "state"
    t.integer "iid"
    t.text "title_html"
    t.text "description_html"
2430
    t.date "start_date"
2431
    t.integer "cached_markdown_version"
Felipe Artur's avatar
Felipe Artur committed
2432
    t.integer "group_id"
2433 2434 2435 2436 2437 2438
    t.index ["description"], name: "index_milestones_on_description_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["due_date"], name: "index_milestones_on_due_date"
    t.index ["group_id"], name: "index_milestones_on_group_id"
    t.index ["project_id", "iid"], name: "index_milestones_on_project_id_and_iid", unique: true
    t.index ["title"], name: "index_milestones_on_title"
    t.index ["title"], name: "index_milestones_on_title_trigram", opclass: :gin_trgm_ops, using: :gin
Andrew8xx8's avatar
Andrew8xx8 committed
2439 2440
  end

2441
  create_table "namespace_aggregation_schedules", primary_key: "namespace_id", id: :integer, default: nil, force: :cascade do |t|
2442
    t.index ["namespace_id"], name: "index_namespace_aggregation_schedules_on_namespace_id", unique: true
2443 2444 2445 2446 2447 2448 2449 2450 2451 2452
  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
2453
    t.index ["namespace_id"], name: "index_namespace_root_storage_statistics_on_namespace_id", unique: true
2454 2455
  end

2456 2457 2458 2459
  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"
2460
    t.index ["namespace_id"], name: "index_namespace_statistics_on_namespace_id", unique: true
2461 2462
  end

Jasper Maes's avatar
Jasper Maes committed
2463
  create_table "namespaces", id: :serial, force: :cascade do |t|
2464 2465 2466
    t.string "name", null: false
    t.string "path", null: false
    t.integer "owner_id"
2467 2468
    t.datetime "created_at"
    t.datetime "updated_at"
2469 2470 2471
    t.string "type"
    t.string "description", default: "", null: false
    t.string "avatar"
2472
    t.boolean "membership_lock", default: false
2473 2474
    t.boolean "share_with_group_lock", default: false
    t.integer "visibility_level", default: 20, null: false
2475
    t.boolean "request_access_enabled", default: true, null: false
2476 2477 2478 2479 2480
    t.string "ldap_sync_status", default: "ready", null: false
    t.string "ldap_sync_error"
    t.datetime "ldap_sync_last_update_at"
    t.datetime "ldap_sync_last_successful_update_at"
    t.datetime "ldap_sync_last_sync_at"
Nick Thomas's avatar
Nick Thomas committed
2481
    t.text "description_html"
2482
    t.boolean "lfs_enabled"
2483
    t.integer "parent_id"
2484 2485
    t.integer "shared_runners_minutes_limit"
    t.bigint "repository_size_limit"
2486 2487
    t.boolean "require_two_factor_authentication", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
2488
    t.integer "cached_markdown_version"
2489
    t.integer "plan_id"
Gosia Ksionek's avatar
Gosia Ksionek committed
2490
    t.integer "project_creation_level"
2491 2492
    t.string "runners_token"
    t.datetime_with_timezone "trial_ends_on"
2493 2494
    t.integer "file_template_project_id"
    t.string "saml_discovery_token"
2495 2496 2497
    t.string "runners_token_encrypted"
    t.integer "custom_project_templates_group_id"
    t.boolean "auto_devops_enabled"
2498
    t.integer "extra_shared_runners_minutes_limit"
2499
    t.datetime_with_timezone "last_ci_minutes_notification_at"
2500
    t.integer "last_ci_minutes_usage_notification_level"
2501
    t.integer "subgroup_creation_level", default: 1
2502
    t.boolean "emails_disabled"
2503 2504
    t.integer "max_pages_size"
    t.integer "max_artifacts_size"
2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521
    t.index ["created_at"], name: "index_namespaces_on_created_at"
    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)"
    t.index ["file_template_project_id"], name: "index_namespaces_on_file_template_project_id"
    t.index ["ldap_sync_last_successful_update_at"], name: "index_namespaces_on_ldap_sync_last_successful_update_at"
    t.index ["ldap_sync_last_update_at"], name: "index_namespaces_on_ldap_sync_last_update_at"
    t.index ["name", "parent_id"], name: "index_namespaces_on_name_and_parent_id", unique: true
    t.index ["name"], name: "index_namespaces_on_name_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["owner_id"], name: "index_namespaces_on_owner_id"
    t.index ["parent_id", "id"], name: "index_namespaces_on_parent_id_and_id", unique: true
    t.index ["path"], name: "index_namespaces_on_path"
    t.index ["path"], name: "index_namespaces_on_path_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["plan_id"], name: "index_namespaces_on_plan_id"
    t.index ["require_two_factor_authentication"], name: "index_namespaces_on_require_two_factor_authentication"
    t.index ["runners_token"], name: "index_namespaces_on_runners_token", unique: true
    t.index ["runners_token_encrypted"], name: "index_namespaces_on_runners_token_encrypted", unique: true
    t.index ["shared_runners_minutes_limit", "extra_shared_runners_minutes_limit"], name: "index_namespaces_on_shared_and_extra_runners_minutes_limit"
    t.index ["trial_ends_on"], name: "index_namespaces_on_trial_ends_on", where: "(trial_ends_on IS NOT NULL)"
2522
    t.index ["type"], name: "index_namespaces_on_type_partial", where: "(type IS NOT NULL)"
Andrew8xx8's avatar
Andrew8xx8 committed
2523 2524
  end

Jasper Maes's avatar
Jasper Maes committed
2525
  create_table "note_diff_files", id: :serial, force: :cascade do |t|
2526 2527 2528 2529 2530 2531 2532 2533 2534
    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
2535
    t.index ["diff_note_id"], name: "index_note_diff_files_on_diff_note_id", unique: true
2536 2537
  end

Jasper Maes's avatar
Jasper Maes committed
2538
  create_table "notes", id: :serial, force: :cascade do |t|
2539 2540 2541
    t.text "note"
    t.string "noteable_type"
    t.integer "author_id"
2542 2543
    t.datetime "created_at"
    t.datetime "updated_at"
2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554
    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"
2555
    t.datetime "resolved_at"
2556 2557 2558
    t.integer "resolved_by_id"
    t.string "discussion_id"
    t.text "note_html"
2559
    t.integer "cached_markdown_version"
2560
    t.text "change_position"
2561
    t.boolean "resolved_by_push"
2562
    t.bigint "review_id"
2563 2564 2565 2566 2567 2568 2569
    t.index ["author_id"], name: "index_notes_on_author_id"
    t.index ["commit_id"], name: "index_notes_on_commit_id"
    t.index ["created_at"], name: "index_notes_on_created_at"
    t.index ["discussion_id"], name: "index_notes_on_discussion_id"
    t.index ["line_code"], name: "index_notes_on_line_code"
    t.index ["note"], name: "index_notes_on_note_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["noteable_id", "noteable_type"], name: "index_notes_on_noteable_id_and_noteable_type"
2570
    t.index ["project_id", "id"], name: "index_notes_on_project_id_and_id_and_system_false", where: "(NOT system)"
2571 2572
    t.index ["project_id", "noteable_type"], name: "index_notes_on_project_id_and_noteable_type"
    t.index ["review_id"], name: "index_notes_on_review_id"
Andrew8xx8's avatar
Andrew8xx8 committed
2573 2574
  end

Jasper Maes's avatar
Jasper Maes committed
2575
  create_table "notification_settings", id: :serial, force: :cascade do |t|
2576 2577 2578 2579 2580 2581
    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
2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593
    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"
2594
    t.boolean "push_to_merge_request"
2595
    t.boolean "issue_due"
2596
    t.boolean "new_epic"
2597
    t.string "notification_email"
2598
    t.boolean "new_release"
2599 2600 2601
    t.index ["source_id", "source_type"], name: "index_notification_settings_on_source_id_and_source_type"
    t.index ["user_id", "source_id", "source_type"], name: "index_notifications_on_user_id_and_source_id_and_source_type", unique: true
    t.index ["user_id"], name: "index_notification_settings_on_user_id"
2602 2603
  end

Jasper Maes's avatar
Jasper Maes committed
2604
  create_table "oauth_access_grants", id: :serial, force: :cascade do |t|
2605 2606 2607 2608 2609 2610
    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
2611
    t.datetime "revoked_at"
2612
    t.string "scopes"
2613
    t.index ["token"], name: "index_oauth_access_grants_on_token", unique: true
Valery Sizov's avatar
Valery Sizov committed
2614 2615
  end

Jasper Maes's avatar
Jasper Maes committed
2616
  create_table "oauth_access_tokens", id: :serial, force: :cascade do |t|
2617 2618 2619 2620 2621
    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
2622
    t.datetime "revoked_at"
2623 2624
    t.datetime "created_at", null: false
    t.string "scopes"
2625
    t.index ["application_id"], name: "index_oauth_access_tokens_on_application_id"
2626 2627 2628
    t.index ["refresh_token"], name: "index_oauth_access_tokens_on_refresh_token", unique: true
    t.index ["resource_owner_id"], name: "index_oauth_access_tokens_on_resource_owner_id"
    t.index ["token"], name: "index_oauth_access_tokens_on_token", unique: true
Valery Sizov's avatar
Valery Sizov committed
2629 2630
  end

Jasper Maes's avatar
Jasper Maes committed
2631
  create_table "oauth_applications", id: :serial, force: :cascade do |t|
2632 2633 2634 2635 2636
    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
2637 2638
    t.datetime "created_at"
    t.datetime "updated_at"
2639 2640
    t.integer "owner_id"
    t.string "owner_type"
Oswaldo Ferreira's avatar
Oswaldo Ferreira committed
2641
    t.boolean "trusted", default: false, null: false
2642 2643
    t.index ["owner_id", "owner_type"], name: "index_oauth_applications_on_owner_id_and_owner_type"
    t.index ["uid"], name: "index_oauth_applications_on_uid", unique: true
Valery Sizov's avatar
Valery Sizov committed
2644 2645
  end

Jasper Maes's avatar
Jasper Maes committed
2646
  create_table "oauth_openid_requests", id: :serial, force: :cascade do |t|
2647 2648
    t.integer "access_grant_id", null: false
    t.string "nonce", null: false
2649
    t.index ["access_grant_id"], name: "index_oauth_openid_requests_on_access_grant_id"
2650 2651
  end

2652 2653 2654 2655 2656 2657
  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
2658
    t.jsonb "strategies", default: [{"name"=>"default", "parameters"=>{}}], null: false
2659
    t.index ["feature_flag_id", "environment_scope"], name: "index_feature_flag_scopes_on_flag_id_and_environment_scope", unique: true
2660 2661 2662 2663 2664 2665 2666 2667 2668
  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"
2669
    t.index ["project_id", "name"], name: "index_operations_feature_flags_on_project_id_and_name", unique: true
2670 2671 2672 2673
  end

  create_table "operations_feature_flags_clients", force: :cascade do |t|
    t.integer "project_id", null: false
2674 2675
    t.string "token"
    t.string "token_encrypted"
2676 2677
    t.index ["project_id", "token"], name: "index_operations_feature_flags_clients_on_project_id_and_token", unique: true
    t.index ["project_id", "token_encrypted"], name: "index_feature_flags_clients_on_project_id_and_token_encrypted", unique: true
2678 2679
  end

2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699
  create_table "packages_conan_file_metadata", force: :cascade do |t|
    t.bigint "package_file_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "recipe_revision", limit: 255, default: "0", null: false
    t.string "package_revision", limit: 255
    t.string "conan_package_reference", limit: 255
    t.integer "conan_file_type", limit: 2, null: false
    t.index ["package_file_id"], name: "index_packages_conan_file_metadata_on_package_file_id", unique: true
  end

  create_table "packages_conan_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 "package_username", limit: 255, null: false
    t.string "package_channel", limit: 255, null: false
    t.index ["package_id"], name: "index_packages_conan_metadata_on_package_id", unique: true
  end

2700 2701 2702 2703 2704 2705 2706 2707
  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
2708
    t.index ["package_id", "path"], name: "index_packages_maven_metadata_on_package_id_and_path"
2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721
  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
2722
    t.index ["package_id", "file_name"], name: "index_packages_package_files_on_package_id_and_file_name"
2723 2724
  end

2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736
  create_table "packages_package_metadata", force: :cascade do |t|
    t.integer "package_id", null: false
    t.binary "metadata", null: false
    t.index ["package_id"], name: "index_packages_package_metadata_on_package_id", unique: true
  end

  create_table "packages_package_tags", force: :cascade do |t|
    t.integer "package_id", null: false
    t.string "name", limit: 255, null: false
    t.index ["package_id"], name: "index_packages_package_tags_on_package_id"
  end

2737 2738 2739 2740 2741 2742 2743
  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
2744
    t.index ["name"], name: "index_packages_packages_on_name_trigram", opclass: :gin_trgm_ops, using: :gin
2745
    t.index ["project_id"], name: "index_packages_packages_on_project_id"
2746 2747
  end

2748 2749 2750 2751 2752 2753 2754 2755 2756 2757
  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
2758 2759
    t.index ["challenge_token"], name: "index_pages_domain_acme_orders_on_challenge_token"
    t.index ["pages_domain_id"], name: "index_pages_domain_acme_orders_on_pages_domain_id"
2760 2761
  end

Jasper Maes's avatar
Jasper Maes committed
2762
  create_table "pages_domains", id: :serial, force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2763
    t.integer "project_id"
2764 2765 2766 2767 2768
    t.text "certificate"
    t.text "encrypted_key"
    t.string "encrypted_key_iv"
    t.string "encrypted_key_salt"
    t.string "domain"
2769 2770 2771
    t.datetime_with_timezone "verified_at"
    t.string "verification_code", null: false
    t.datetime_with_timezone "enabled_until"
2772
    t.datetime_with_timezone "remove_at"
2773
    t.boolean "auto_ssl_enabled", default: false, null: false
2774 2775
    t.datetime_with_timezone "certificate_valid_not_before"
    t.datetime_with_timezone "certificate_valid_not_after"
2776
    t.integer "certificate_source", limit: 2, default: 0, null: false
2777 2778 2779 2780 2781 2782 2783
    t.index ["certificate_source", "certificate_valid_not_after"], name: "index_pages_domains_need_auto_ssl_renewal", where: "(auto_ssl_enabled = true)"
    t.index ["domain"], name: "index_pages_domains_on_domain", unique: true
    t.index ["project_id", "enabled_until"], name: "index_pages_domains_on_project_id_and_enabled_until"
    t.index ["project_id"], name: "index_pages_domains_on_project_id"
    t.index ["remove_at"], name: "index_pages_domains_on_remove_at"
    t.index ["verified_at", "enabled_until"], name: "index_pages_domains_on_verified_at_and_enabled_until"
    t.index ["verified_at"], name: "index_pages_domains_on_verified_at"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
2784 2785
  end

2786 2787 2788 2789 2790 2791
  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
2792 2793 2794
    t.index ["path"], name: "index_path_locks_on_path"
    t.index ["project_id"], name: "index_path_locks_on_project_id"
    t.index ["user_id"], name: "index_path_locks_on_user_id"
2795 2796
  end

Jasper Maes's avatar
Jasper Maes committed
2797
  create_table "personal_access_tokens", id: :serial, force: :cascade do |t|
2798 2799 2800
    t.integer "user_id", null: false
    t.string "name", null: false
    t.boolean "revoked", default: false
2801
    t.date "expires_at"
2802 2803
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
2804
    t.string "scopes", default: "--- []\n", null: false
Simon Vocella's avatar
Simon Vocella committed
2805
    t.boolean "impersonation", default: false, null: false
2806
    t.string "token_digest"
2807 2808
    t.index ["token_digest"], name: "index_personal_access_tokens_on_token_digest", unique: true
    t.index ["user_id"], name: "index_personal_access_tokens_on_user_id"
2809 2810
  end

2811 2812 2813 2814 2815 2816 2817 2818
  create_table "plan_limits", force: :cascade do |t|
    t.bigint "plan_id", null: false
    t.integer "ci_active_pipelines", default: 0, null: false
    t.integer "ci_pipeline_size", default: 0, null: false
    t.integer "ci_active_jobs", default: 0, null: false
    t.index ["plan_id"], name: "index_plan_limits_on_plan_id", unique: true
  end

2819 2820 2821 2822 2823
  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"
2824
    t.index ["name"], name: "index_plans_on_name"
2825 2826
  end

Jasper Maes's avatar
Jasper Maes committed
2827
  create_table "pool_repositories", force: :cascade do |t|
2828 2829
    t.integer "shard_id", null: false
    t.string "disk_path"
2830 2831
    t.string "state"
    t.integer "source_project_id"
2832 2833 2834
    t.index ["disk_path"], name: "index_pool_repositories_on_disk_path", unique: true
    t.index ["shard_id"], name: "index_pool_repositories_on_shard_id"
    t.index ["source_project_id"], name: "index_pool_repositories_on_source_project_id", unique: true
2835 2836
  end

Jasper Maes's avatar
Jasper Maes committed
2837
  create_table "programming_languages", id: :serial, force: :cascade do |t|
2838 2839 2840
    t.string "name", null: false
    t.string "color", null: false
    t.datetime_with_timezone "created_at", null: false
2841
    t.index ["name"], name: "index_programming_languages_on_name", unique: true
2842 2843
  end

2844 2845 2846 2847 2848
  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

2849 2850 2851 2852 2853
  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
2854 2855
    t.index ["name"], name: "index_project_aliases_on_name", unique: true
    t.index ["project_id"], name: "index_project_aliases_on_project_id"
2856 2857
  end

2858
  create_table "project_authorizations", id: false, force: :cascade do |t|
2859 2860 2861
    t.integer "user_id", null: false
    t.integer "project_id", null: false
    t.integer "access_level", null: false
2862 2863
    t.index ["project_id"], name: "index_project_authorizations_on_project_id"
    t.index ["user_id", "project_id", "access_level"], name: "index_project_authorizations_on_user_id_project_id_access_level", unique: true
2864 2865
  end

Jasper Maes's avatar
Jasper Maes committed
2866
  create_table "project_auto_devops", id: :serial, force: :cascade do |t|
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
2867
    t.integer "project_id", null: false
2868 2869
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2870
    t.boolean "enabled"
2871
    t.integer "deploy_strategy", default: 0, null: false
2872
    t.index ["project_id"], name: "index_project_auto_devops_on_project_id", unique: true
2873 2874
  end

Jasper Maes's avatar
Jasper Maes committed
2875
  create_table "project_ci_cd_settings", id: :serial, force: :cascade do |t|
2876 2877
    t.integer "project_id", null: false
    t.boolean "group_runners_enabled", default: true, null: false
2878
    t.boolean "merge_pipelines_enabled"
2879
    t.boolean "merge_trains_enabled", default: false, null: false
2880
    t.integer "default_git_depth"
2881
    t.index ["project_id"], name: "index_project_ci_cd_settings_on_project_id", unique: true
2882 2883
  end

Jasper Maes's avatar
Jasper Maes committed
2884
  create_table "project_custom_attributes", id: :serial, force: :cascade do |t|
2885 2886
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
2887 2888 2889
    t.integer "project_id", null: false
    t.string "key", null: false
    t.string "value", null: false
2890 2891
    t.index ["key", "value"], name: "index_project_custom_attributes_on_key_and_value"
    t.index ["project_id", "key"], name: "index_project_custom_attributes_on_project_id_and_key", unique: true
2892 2893
  end

Jasper Maes's avatar
Jasper Maes committed
2894
  create_table "project_daily_statistics", force: :cascade do |t|
2895 2896 2897
    t.integer "project_id", null: false
    t.integer "fetch_count", null: false
    t.date "date"
2898
    t.index ["project_id", "date"], name: "index_project_daily_statistics_on_project_id_and_date", unique: true, order: { date: :desc }
2899 2900
  end

Jasper Maes's avatar
Jasper Maes committed
2901
  create_table "project_deploy_tokens", id: :serial, force: :cascade do |t|
2902 2903
    t.integer "project_id", null: false
    t.integer "deploy_token_id", null: false
2904
    t.datetime_with_timezone "created_at", null: false
2905 2906
    t.index ["deploy_token_id"], name: "index_project_deploy_tokens_on_deploy_token_id"
    t.index ["project_id", "deploy_token_id"], name: "index_project_deploy_tokens_on_project_id_and_deploy_token_id", unique: true
2907 2908
  end

Jasper Maes's avatar
Jasper Maes committed
2909
  create_table "project_error_tracking_settings", primary_key: "project_id", id: :integer, default: nil, force: :cascade do |t|
2910 2911
    t.boolean "enabled", default: false, null: false
    t.string "api_url"
2912 2913
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
2914 2915
    t.string "project_name"
    t.string "organization_name"
2916 2917
  end

2918 2919 2920
  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"
2921 2922 2923
    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)"
    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)"
    t.index ["project_id"], name: "index_project_feature_usages_on_project_id"
2924 2925
  end

Jasper Maes's avatar
Jasper Maes committed
2926
  create_table "project_features", id: :serial, force: :cascade do |t|
2927
    t.integer "project_id", null: false
2928 2929 2930
    t.integer "merge_requests_access_level"
    t.integer "issues_access_level"
    t.integer "wiki_access_level"
2931
    t.integer "snippets_access_level", default: 20, null: false
2932
    t.integer "builds_access_level"
2933 2934
    t.datetime "created_at"
    t.datetime "updated_at"
2935
    t.integer "repository_access_level", default: 20, null: false
2936
    t.integer "pages_access_level", null: false
2937
    t.index ["project_id"], name: "index_project_features_on_project_id", unique: true
2938 2939
  end

Jasper Maes's avatar
Jasper Maes committed
2940
  create_table "project_group_links", id: :serial, force: :cascade do |t|
2941 2942
    t.integer "project_id", null: false
    t.integer "group_id", null: false
2943 2944
    t.datetime "created_at"
    t.datetime "updated_at"
2945 2946
    t.integer "group_access", default: 30, null: false
    t.date "expires_at"
2947 2948
    t.index ["group_id"], name: "index_project_group_links_on_group_id"
    t.index ["project_id"], name: "index_project_group_links_on_project_id"
2949 2950
  end

Jasper Maes's avatar
Jasper Maes committed
2951
  create_table "project_import_data", id: :serial, force: :cascade do |t|
2952
    t.integer "project_id"
2953 2954 2955 2956
    t.text "data"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
2957
    t.index ["project_id"], name: "index_project_import_data_on_project_id"
2958 2959
  end

2960 2961 2962
  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
2963 2964 2965
    t.text "issue_template_key"
  end

2966 2967 2968 2969
  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
2970
  create_table "project_mirror_data", id: :serial, force: :cascade do |t|
2971
    t.integer "project_id", null: false
2972 2973 2974 2975
    t.integer "retry_count", default: 0, null: false
    t.datetime "last_update_started_at"
    t.datetime "last_update_scheduled_at"
    t.datetime "next_execution_timestamp"
2976 2977 2978
    t.string "status"
    t.string "jid"
    t.text "last_error"
2979
    t.datetime_with_timezone "last_update_at"
2980
    t.datetime_with_timezone "last_successful_update_at"
2981 2982 2983 2984 2985 2986
    t.index ["jid"], name: "index_project_mirror_data_on_jid"
    t.index ["last_successful_update_at"], name: "index_project_mirror_data_on_last_successful_update_at"
    t.index ["last_update_at", "retry_count"], name: "index_project_mirror_data_on_last_update_at_and_retry_count"
    t.index ["next_execution_timestamp", "retry_count"], name: "index_mirror_data_on_next_execution_and_retry_count"
    t.index ["project_id"], name: "index_project_mirror_data_on_project_id", unique: true
    t.index ["status"], name: "index_project_mirror_data_on_status"
2987 2988
  end

2989 2990 2991 2992 2993 2994 2995
  create_table "project_pages_metadata", id: false, force: :cascade do |t|
    t.bigint "project_id", null: false
    t.boolean "deployed", default: false, null: false
    t.index ["project_id"], name: "index_project_pages_metadata_on_project_id", unique: true
    t.index ["project_id"], name: "index_project_pages_metadata_on_project_id_and_deployed_is_true", where: "(deployed = true)"
  end

Jasper Maes's avatar
Jasper Maes committed
2996
  create_table "project_repositories", force: :cascade do |t|
2997 2998 2999
    t.integer "shard_id", null: false
    t.string "disk_path", null: false
    t.integer "project_id", null: false
3000 3001 3002
    t.index ["disk_path"], name: "index_project_repositories_on_disk_path", unique: true
    t.index ["project_id"], name: "index_project_repositories_on_project_id", unique: true
    t.index ["shard_id"], name: "index_project_repositories_on_shard_id"
3003 3004
  end

3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016
  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"
3017 3018 3019 3020 3021 3022
    t.index ["last_repository_verification_failure"], name: "idx_repository_states_on_repository_failure_partial", where: "(last_repository_verification_failure IS NOT NULL)"
    t.index ["last_wiki_verification_failure"], name: "idx_repository_states_on_wiki_failure_partial", where: "(last_wiki_verification_failure IS NOT NULL)"
    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))"
    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))"
    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)))"
    t.index ["project_id"], name: "index_project_repository_states_on_project_id", unique: true
3023 3024
  end

Jasper Maes's avatar
Jasper Maes committed
3025
  create_table "project_statistics", id: :serial, force: :cascade do |t|
3026 3027
    t.integer "project_id", null: false
    t.integer "namespace_id", null: false
3028 3029 3030 3031 3032
    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
3033 3034
    t.bigint "shared_runners_seconds", default: 0, null: false
    t.datetime "shared_runners_seconds_last_reset"
3035 3036
    t.bigint "packages_size", default: 0, null: false
    t.bigint "wiki_size"
3037 3038
    t.index ["namespace_id"], name: "index_project_statistics_on_namespace_id"
    t.index ["project_id"], name: "index_project_statistics_on_project_id", unique: true
3039 3040
  end

3041 3042 3043 3044 3045
  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
3046
    t.index ["project_id"], name: "index_project_tracing_settings_on_project_id", unique: true
3047 3048
  end

Jasper Maes's avatar
Jasper Maes committed
3049
  create_table "projects", id: :serial, force: :cascade do |t|
3050 3051 3052
    t.string "name"
    t.string "path"
    t.text "description"
3053 3054
    t.datetime "created_at"
    t.datetime "updated_at"
3055
    t.integer "creator_id"
3056
    t.integer "namespace_id", null: false
3057
    t.datetime "last_activity_at"
3058 3059 3060 3061
    t.string "import_url"
    t.integer "visibility_level", default: 0, null: false
    t.boolean "archived", default: false, null: false
    t.string "avatar"
3062
    t.text "merge_requests_template"
3063
    t.integer "star_count", default: 0, null: false
3064
    t.boolean "merge_requests_rebase_enabled", default: false
3065 3066
    t.string "import_type"
    t.string "import_source"
3067 3068 3069 3070 3071 3072 3073 3074
    t.integer "approvals_before_merge", default: 0, null: false
    t.boolean "reset_approvals_on_push", default: true
    t.boolean "merge_requests_ff_only_enabled", default: false
    t.text "issues_template"
    t.boolean "mirror", default: false, null: false
    t.datetime "mirror_last_update_at"
    t.datetime "mirror_last_successful_update_at"
    t.integer "mirror_user_id"
3075 3076 3077 3078 3079
    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
3080
    t.boolean "mirror_trigger_builds", default: false, null: false
3081 3082 3083
    t.boolean "pending_delete", default: false
    t.boolean "public_builds", default: true, null: false
    t.boolean "last_repository_check_failed"
3084
    t.datetime "last_repository_check_at"
3085
    t.boolean "container_registry_enabled"
3086
    t.boolean "only_allow_merge_if_pipeline_succeeds", default: false, null: false
3087 3088
    t.boolean "has_external_issue_tracker"
    t.string "repository_storage", default: "default", null: false
3089
    t.boolean "repository_read_only"
3090
    t.boolean "request_access_enabled", default: true, null: false
3091
    t.boolean "has_external_wiki"
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
3092
    t.string "ci_config_path"
3093 3094
    t.boolean "lfs_enabled"
    t.text "description_html"
Valery Sizov's avatar
Valery Sizov committed
3095
    t.boolean "only_allow_merge_if_all_discussions_are_resolved"
3096
    t.bigint "repository_size_limit"
3097
    t.boolean "printing_merge_request_link_enabled", default: true, null: false
3098
    t.integer "auto_cancel_pending_pipelines", default: 1, null: false
3099
    t.boolean "service_desk_enabled", default: true
3100
    t.integer "cached_markdown_version"
3101
    t.text "delete_error"
3102
    t.datetime "last_repository_updated_at"
3103
    t.boolean "disable_overriding_approvers_per_merge_request"
3104
    t.integer "storage_version", limit: 2
Sean McGivern's avatar
Sean McGivern committed
3105
    t.boolean "resolve_outdated_diff_discussions"
3106 3107 3108
    t.boolean "remote_mirror_available_overridden"
    t.boolean "only_mirror_protected_branches"
    t.boolean "pull_mirror_available_overridden"
3109
    t.integer "jobs_cache_index"
3110 3111
    t.string "external_authorization_classification_label"
    t.boolean "mirror_overwrites_diverged_branches"
Rob Watson's avatar
Rob Watson committed
3112
    t.boolean "pages_https_only", default: true
3113 3114 3115
    t.string "external_webhook_token"
    t.boolean "packages_enabled"
    t.boolean "merge_requests_author_approval"
3116
    t.bigint "pool_repository_id"
3117
    t.string "runners_token_encrypted"
3118
    t.string "bfg_object_map"
3119
    t.boolean "merge_requests_require_code_owner_approval"
3120
    t.boolean "detected_repository_languages"
3121 3122
    t.boolean "merge_requests_disable_committers_approval"
    t.boolean "require_password_to_approve"
3123
    t.boolean "emails_disabled"
3124 3125
    t.integer "max_pages_size"
    t.integer "max_artifacts_size"
3126
    t.string "pull_mirror_branch_prefix", limit: 50
3127
    t.boolean "remove_source_branch_after_merge"
3128 3129
    t.date "marked_for_deletion_at"
    t.integer "marked_for_deletion_by_user_id"
3130
    t.index "lower((name)::text)", name: "index_projects_on_lower_name"
3131
    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))"
3132
    t.index ["created_at", "id"], name: "index_projects_on_created_at_and_id"
3133 3134 3135 3136 3137 3138 3139 3140 3141
    t.index ["creator_id"], name: "index_projects_on_creator_id"
    t.index ["description"], name: "index_projects_on_description_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["id", "repository_storage", "last_repository_updated_at"], name: "idx_projects_on_repository_storage_last_repository_updated_at"
    t.index ["id"], name: "index_projects_on_id_partial_for_visibility", unique: true, where: "(visibility_level = ANY (ARRAY[10, 20]))"
    t.index ["id"], name: "index_projects_on_mirror_and_mirror_trigger_builds_both_true", where: "((mirror IS TRUE) AND (mirror_trigger_builds IS TRUE))"
    t.index ["last_activity_at"], name: "index_projects_on_last_activity_at"
    t.index ["last_repository_check_at"], name: "index_projects_on_last_repository_check_at", where: "(last_repository_check_at IS NOT NULL)"
    t.index ["last_repository_check_failed"], name: "index_projects_on_last_repository_check_failed"
    t.index ["last_repository_updated_at"], name: "index_projects_on_last_repository_updated_at"
3142
    t.index ["marked_for_deletion_at"], name: "index_projects_on_marked_for_deletion_at", where: "(marked_for_deletion_at IS NOT NULL)"
3143
    t.index ["marked_for_deletion_by_user_id"], name: "index_projects_on_marked_for_deletion_by_user_id", where: "(marked_for_deletion_by_user_id IS NOT NULL)"
3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156
    t.index ["mirror_last_successful_update_at"], name: "index_projects_on_mirror_last_successful_update_at"
    t.index ["mirror_user_id"], name: "index_projects_on_mirror_user_id"
    t.index ["name"], name: "index_projects_on_name_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["namespace_id"], name: "index_projects_on_namespace_id"
    t.index ["path"], name: "index_projects_on_path"
    t.index ["path"], name: "index_projects_on_path_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["pending_delete"], name: "index_projects_on_pending_delete"
    t.index ["pool_repository_id"], name: "index_projects_on_pool_repository_id", where: "(pool_repository_id IS NOT NULL)"
    t.index ["repository_storage", "created_at"], name: "idx_project_repository_check_partial", where: "(last_repository_check_at IS NULL)"
    t.index ["repository_storage"], name: "index_projects_on_repository_storage"
    t.index ["runners_token"], name: "index_projects_on_runners_token"
    t.index ["runners_token_encrypted"], name: "index_projects_on_runners_token_encrypted"
    t.index ["star_count"], name: "index_projects_on_star_count"
3157
    t.index ["visibility_level", "created_at", "id"], name: "index_projects_on_visibility_level_and_created_at_and_id"
3158
  end
Andrew8xx8's avatar
Andrew8xx8 committed
3159

3160 3161 3162 3163 3164 3165 3166
  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"
3167 3168
    t.index ["project_id", "status"], name: "index_prometheus_alert_events_on_project_id_and_status"
    t.index ["prometheus_alert_id", "payload_key"], name: "index_prometheus_alert_event_scoped_payload_key", unique: true
3169 3170 3171 3172 3173 3174 3175 3176 3177 3178
  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
3179 3180 3181
    t.index ["environment_id"], name: "index_prometheus_alerts_on_environment_id"
    t.index ["project_id", "prometheus_metric_id", "environment_id"], name: "index_prometheus_alerts_metric_environment", unique: true
    t.index ["prometheus_metric_id"], name: "index_prometheus_alerts_on_prometheus_metric_id"
3182 3183
  end

Jasper Maes's avatar
Jasper Maes committed
3184
  create_table "prometheus_metrics", id: :serial, force: :cascade do |t|
3185 3186 3187
    t.integer "project_id"
    t.string "title", null: false
    t.string "query", null: false
3188 3189
    t.string "y_label", null: false
    t.string "unit", null: false
3190 3191 3192 3193 3194 3195
    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"
3196 3197 3198 3199
    t.index ["common"], name: "index_prometheus_metrics_on_common"
    t.index ["group"], name: "index_prometheus_metrics_on_group"
    t.index ["identifier"], name: "index_prometheus_metrics_on_identifier", unique: true
    t.index ["project_id"], name: "index_prometheus_metrics_on_project_id"
3200 3201
  end

Jasper Maes's avatar
Jasper Maes committed
3202
  create_table "protected_branch_merge_access_levels", id: :serial, force: :cascade do |t|
3203
    t.integer "protected_branch_id", null: false
3204
    t.integer "access_level", default: 40
3205 3206
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3207
    t.integer "user_id"
3208
    t.integer "group_id"
3209 3210 3211
    t.index ["group_id"], name: "index_protected_branch_merge_access_levels_on_group_id"
    t.index ["protected_branch_id"], name: "index_protected_branch_merge_access"
    t.index ["user_id"], name: "index_protected_branch_merge_access_levels_on_user_id"
3212 3213
  end

Jasper Maes's avatar
Jasper Maes committed
3214
  create_table "protected_branch_push_access_levels", id: :serial, force: :cascade do |t|
3215
    t.integer "protected_branch_id", null: false
3216
    t.integer "access_level", default: 40
3217 3218
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3219
    t.integer "user_id"
3220
    t.integer "group_id"
3221 3222 3223
    t.index ["group_id"], name: "index_protected_branch_push_access_levels_on_group_id"
    t.index ["protected_branch_id"], name: "index_protected_branch_push_access"
    t.index ["user_id"], name: "index_protected_branch_push_access_levels_on_user_id"
3224 3225 3226 3227 3228 3229 3230
  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"
3231 3232 3233
    t.index ["group_id"], name: "index_protected_branch_unprotect_access_levels_on_group_id"
    t.index ["protected_branch_id"], name: "index_protected_branch_unprotect_access"
    t.index ["user_id"], name: "index_protected_branch_unprotect_access_levels_on_user_id"
3234 3235
  end

Jasper Maes's avatar
Jasper Maes committed
3236
  create_table "protected_branches", id: :serial, force: :cascade do |t|
3237 3238
    t.integer "project_id", null: false
    t.string "name", null: false
3239 3240
    t.datetime "created_at"
    t.datetime "updated_at"
3241 3242
    t.boolean "code_owner_approval_required", default: false, null: false
    t.index ["project_id", "code_owner_approval_required"], name: "code_owner_approval_required", where: "(code_owner_approval_required = true)"
3243
    t.index ["project_id"], name: "index_protected_branches_on_project_id"
Andrew8xx8's avatar
Andrew8xx8 committed
3244 3245
  end

3246 3247 3248 3249 3250 3251 3252
  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"
3253 3254 3255
    t.index ["group_id"], name: "index_protected_environment_deploy_access_levels_on_group_id"
    t.index ["protected_environment_id"], name: "index_protected_environment_deploy_access"
    t.index ["user_id"], name: "index_protected_environment_deploy_access_levels_on_user_id"
3256 3257 3258 3259 3260 3261 3262
  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
3263 3264
    t.index ["project_id", "name"], name: "index_protected_environments_on_project_id_and_name", unique: true
    t.index ["project_id"], name: "index_protected_environments_on_project_id"
3265 3266
  end

Jasper Maes's avatar
Jasper Maes committed
3267
  create_table "protected_tag_create_access_levels", id: :serial, force: :cascade do |t|
3268
    t.integer "protected_tag_id", null: false
3269 3270 3271
    t.integer "access_level", default: 40
    t.integer "user_id"
    t.integer "group_id"
3272 3273
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3274 3275 3276
    t.index ["group_id"], name: "index_protected_tag_create_access_levels_on_group_id"
    t.index ["protected_tag_id"], name: "index_protected_tag_create_access"
    t.index ["user_id"], name: "index_protected_tag_create_access_levels_on_user_id"
3277 3278
  end

Jasper Maes's avatar
Jasper Maes committed
3279
  create_table "protected_tags", id: :serial, force: :cascade do |t|
3280 3281
    t.integer "project_id", null: false
    t.string "name", null: false
3282 3283
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3284 3285
    t.index ["project_id", "name"], name: "index_protected_tags_on_project_id_and_name", unique: true
    t.index ["project_id"], name: "index_protected_tags_on_project_id"
3286 3287
  end

3288
  create_table "push_event_payloads", id: false, force: :cascade do |t|
3289
    t.bigint "commit_count", null: false
3290 3291 3292 3293 3294 3295 3296
    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
3297
    t.integer "ref_count"
3298
    t.index ["event_id"], name: "index_push_event_payloads_on_event_id", unique: true
3299 3300
  end

3301 3302 3303 3304 3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319
  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"
3320 3321
    t.index ["is_sample"], name: "index_push_rules_on_is_sample", where: "is_sample"
    t.index ["project_id"], name: "index_push_rules_on_project_id"
3322 3323
  end

Jasper Maes's avatar
Jasper Maes committed
3324
  create_table "redirect_routes", id: :serial, force: :cascade do |t|
3325 3326 3327 3328 3329
    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
3330
    t.index "lower((path)::text) varchar_pattern_ops", name: "index_redirect_routes_on_path_unique_text_pattern_ops", unique: true
3331 3332
    t.index ["path"], name: "index_redirect_routes_on_path", unique: true
    t.index ["source_type", "source_id"], name: "index_redirect_routes_on_source_type_and_source_id"
3333 3334
  end

Jasper Maes's avatar
Jasper Maes committed
3335
  create_table "release_links", force: :cascade do |t|
3336 3337 3338 3339 3340
    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
3341 3342
    t.index ["release_id", "name"], name: "index_release_links_on_release_id_and_name", unique: true
    t.index ["release_id", "url"], name: "index_release_links_on_release_id_and_url", unique: true
3343 3344
  end

Jasper Maes's avatar
Jasper Maes committed
3345
  create_table "releases", id: :serial, force: :cascade do |t|
3346 3347 3348
    t.string "tag"
    t.text "description"
    t.integer "project_id"
3349 3350
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3351
    t.text "description_html"
3352
    t.integer "cached_markdown_version"
3353 3354 3355
    t.integer "author_id"
    t.string "name"
    t.string "sha"
3356
    t.datetime_with_timezone "released_at", null: false
3357 3358
    t.index ["author_id"], name: "index_releases_on_author_id"
    t.index ["project_id", "tag"], name: "index_releases_on_project_id_and_tag"
Dmitriy Zaporozhets's avatar
Dmitriy Zaporozhets committed
3359 3360
  end

Jasper Maes's avatar
Jasper Maes committed
3361
  create_table "remote_mirrors", id: :serial, force: :cascade do |t|
3362 3363
    t.integer "project_id"
    t.string "url"
3364
    t.boolean "enabled", default: false
3365 3366 3367 3368 3369 3370 3371 3372 3373
    t.string "update_status"
    t.datetime "last_update_at"
    t.datetime "last_successful_update_at"
    t.string "last_error"
    t.text "encrypted_credentials"
    t.string "encrypted_credentials_iv"
    t.string "encrypted_credentials_salt"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3374 3375 3376
    t.datetime "last_update_started_at"
    t.boolean "only_protected_branches", default: false, null: false
    t.string "remote_name"
3377
    t.boolean "error_notification_sent"
3378 3379
    t.index ["last_successful_update_at"], name: "index_remote_mirrors_on_last_successful_update_at"
    t.index ["project_id"], name: "index_remote_mirrors_on_project_id"
3380 3381
  end

3382 3383 3384 3385
  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
3386
    t.index ["project_id", "programming_language_id"], name: "index_repository_languages_on_project_and_languages_id", unique: true
3387 3388
  end

Jasper Maes's avatar
Jasper Maes committed
3389
  create_table "resource_label_events", force: :cascade do |t|
Jan Provaznik's avatar
Jan Provaznik committed
3390 3391 3392
    t.integer "action", null: false
    t.integer "issue_id"
    t.integer "merge_request_id"
3393
    t.integer "epic_id"
Jan Provaznik's avatar
Jan Provaznik committed
3394 3395 3396
    t.integer "label_id"
    t.integer "user_id"
    t.datetime_with_timezone "created_at", null: false
3397 3398 3399
    t.integer "cached_markdown_version"
    t.text "reference"
    t.text "reference_html"
3400 3401 3402 3403 3404
    t.index ["epic_id"], name: "index_resource_label_events_on_epic_id"
    t.index ["issue_id"], name: "index_resource_label_events_on_issue_id"
    t.index ["label_id"], name: "index_resource_label_events_on_label_id"
    t.index ["merge_request_id"], name: "index_resource_label_events_on_merge_request_id"
    t.index ["user_id"], name: "index_resource_label_events_on_user_id"
Jan Provaznik's avatar
Jan Provaznik committed
3405 3406
  end

3407 3408 3409 3410 3411
  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
3412 3413 3414
    t.index ["author_id"], name: "index_reviews_on_author_id"
    t.index ["merge_request_id"], name: "index_reviews_on_merge_request_id"
    t.index ["project_id"], name: "index_reviews_on_project_id"
3415 3416
  end

Jasper Maes's avatar
Jasper Maes committed
3417
  create_table "routes", id: :serial, force: :cascade do |t|
3418 3419 3420 3421 3422
    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"
3423
    t.string "name"
3424 3425 3426
    t.index ["path"], name: "index_routes_on_path", unique: true
    t.index ["path"], name: "index_routes_on_path_text_pattern_ops", opclass: :varchar_pattern_ops
    t.index ["source_type", "source_id"], name: "index_routes_on_source_type_and_source_id", unique: true
3427 3428
  end

3429 3430 3431 3432 3433 3434 3435
  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
3436
    t.index ["group_id"], name: "index_saml_providers_on_group_id"
3437 3438 3439 3440 3441 3442 3443
  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
3444
    t.index ["group_id", "token_encrypted"], name: "index_scim_oauth_access_tokens_on_group_id_and_token_encrypted", unique: true
3445 3446
  end

3447 3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459
  create_table "self_managed_prometheus_alert_events", force: :cascade do |t|
    t.bigint "project_id", null: false
    t.bigint "environment_id"
    t.datetime_with_timezone "started_at", null: false
    t.datetime_with_timezone "ended_at"
    t.integer "status", limit: 2, null: false
    t.string "title", limit: 255, null: false
    t.string "query_expression", limit: 255
    t.string "payload_key", limit: 255, null: false
    t.index ["environment_id"], name: "index_self_managed_prometheus_alert_events_on_environment_id"
    t.index ["project_id", "payload_key"], name: "idx_project_id_payload_key_self_managed_prometheus_alert_events", unique: true
  end

Jasper Maes's avatar
Jasper Maes committed
3460
  create_table "sent_notifications", id: :serial, force: :cascade do |t|
Douwe Maan's avatar
Douwe Maan committed
3461 3462
    t.integer "project_id"
    t.integer "noteable_id"
3463
    t.string "noteable_type"
Douwe Maan's avatar
Douwe Maan committed
3464
    t.integer "recipient_id"
3465 3466 3467 3468 3469
    t.string "commit_id"
    t.string "reply_key", null: false
    t.string "line_code"
    t.string "note_type"
    t.text "position"
3470
    t.string "in_reply_to_discussion_id"
3471
    t.index ["reply_key"], name: "index_sent_notifications_on_reply_key", unique: true
Douwe Maan's avatar
Douwe Maan committed
3472 3473
  end

Jasper Maes's avatar
Jasper Maes committed
3474
  create_table "services", id: :serial, force: :cascade do |t|
3475 3476 3477
    t.string "type"
    t.string "title"
    t.integer "project_id"
3478 3479
    t.datetime "created_at"
    t.datetime "updated_at"
3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492
    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
3493
    t.boolean "commit_events", default: true, null: false
3494
    t.boolean "job_events", default: false, null: false
3495
    t.boolean "confidential_note_events", default: true
3496
    t.boolean "deployment_events", default: false, null: false
3497
    t.string "description", limit: 500
3498 3499 3500
    t.index ["project_id"], name: "index_services_on_project_id"
    t.index ["template"], name: "index_services_on_template"
    t.index ["type"], name: "index_services_on_type"
3501 3502
  end

Jasper Maes's avatar
Jasper Maes committed
3503
  create_table "shards", id: :serial, force: :cascade do |t|
3504
    t.string "name", null: false
3505
    t.index ["name"], name: "index_shards_on_name", unique: true
3506 3507
  end

3508 3509 3510 3511 3512 3513 3514 3515
  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
3516 3517
    t.index ["service_id"], name: "index_slack_integrations_on_service_id"
    t.index ["team_id", "alias"], name: "index_slack_integrations_on_team_id_and_alias", unique: true
3518 3519 3520 3521 3522 3523
  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
3524 3525
    t.index ["subject", "issuer"], name: "index_smartcard_identities_on_subject_and_issuer", unique: true
    t.index ["user_id"], name: "index_smartcard_identities_on_user_id"
3526 3527
  end

Jasper Maes's avatar
Jasper Maes committed
3528
  create_table "snippets", id: :serial, force: :cascade do |t|
3529 3530 3531 3532
    t.string "title"
    t.text "content"
    t.integer "author_id", null: false
    t.integer "project_id"
3533 3534
    t.datetime "created_at"
    t.datetime "updated_at"
3535 3536 3537 3538 3539
    t.string "file_name"
    t.string "type"
    t.integer "visibility_level", default: 0, null: false
    t.text "title_html"
    t.text "content_html"
3540
    t.integer "cached_markdown_version"
3541 3542
    t.text "description"
    t.text "description_html"
3543
    t.index ["author_id"], name: "index_snippets_on_author_id"
3544
    t.index ["content"], name: "index_snippets_on_content_trigram", opclass: :gin_trgm_ops, using: :gin
3545
    t.index ["file_name"], name: "index_snippets_on_file_name_trigram", opclass: :gin_trgm_ops, using: :gin
3546
    t.index ["project_id", "visibility_level"], name: "index_snippets_on_project_id_and_visibility_level"
3547 3548 3549
    t.index ["title"], name: "index_snippets_on_title_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["updated_at"], name: "index_snippets_on_updated_at"
    t.index ["visibility_level"], name: "index_snippets_on_visibility_level"
Andrew8xx8's avatar
Andrew8xx8 committed
3550 3551
  end

3552 3553 3554 3555
  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
3556 3557
    t.index ["project_id", "software_license_id"], name: "index_software_license_policies_unique_per_project", unique: true
    t.index ["software_license_id"], name: "index_software_license_policies_on_software_license_id"
3558 3559 3560 3561
  end

  create_table "software_licenses", id: :serial, force: :cascade do |t|
    t.string "name", null: false
3562
    t.string "spdx_identifier", limit: 255
3563
    t.index ["name"], name: "index_software_licenses_on_name"
3564
    t.index ["spdx_identifier"], name: "index_software_licenses_on_spdx_identifier"
3565 3566
  end

Jasper Maes's avatar
Jasper Maes committed
3567
  create_table "spam_logs", id: :serial, force: :cascade do |t|
3568 3569 3570 3571 3572 3573 3574 3575 3576 3577
    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
3578
    t.boolean "recaptcha_verified", default: false, null: false
3579 3580
  end

Jasper Maes's avatar
Jasper Maes committed
3581
  create_table "subscriptions", id: :serial, force: :cascade do |t|
3582 3583 3584 3585
    t.integer "user_id"
    t.integer "subscribable_id"
    t.string "subscribable_type"
    t.boolean "subscribed"
Valery Sizov's avatar
Valery Sizov committed
3586 3587
    t.datetime "created_at"
    t.datetime "updated_at"
3588
    t.integer "project_id"
3589 3590
    t.index ["project_id"], name: "index_subscriptions_on_project_id"
    t.index ["subscribable_id", "subscribable_type", "user_id", "project_id"], name: "index_subscriptions_on_subscribable_and_user_id_and_project_id", unique: true
Valery Sizov's avatar
Valery Sizov committed
3591 3592
  end

Jasper Maes's avatar
Jasper Maes committed
3593
  create_table "suggestions", force: :cascade do |t|
3594 3595 3596 3597 3598 3599
    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
3600 3601
    t.integer "lines_above", default: 0, null: false
    t.integer "lines_below", default: 0, null: false
3602
    t.boolean "outdated", default: false, null: false
3603
    t.index ["note_id", "relative_order"], name: "index_suggestions_on_note_id_and_relative_order", unique: true
3604 3605
  end

Jasper Maes's avatar
Jasper Maes committed
3606
  create_table "system_note_metadata", id: :serial, force: :cascade do |t|
3607 3608
    t.integer "note_id", null: false
    t.integer "commit_count"
3609
    t.string "action"
3610 3611
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3612 3613
    t.bigint "description_version_id"
    t.index ["description_version_id"], name: "index_system_note_metadata_on_description_version_id", unique: true, where: "(description_version_id IS NOT NULL)"
3614
    t.index ["note_id"], name: "index_system_note_metadata_on_note_id", unique: true
Valery Sizov's avatar
Valery Sizov committed
3615 3616
  end

Jasper Maes's avatar
Jasper Maes committed
3617
  create_table "taggings", id: :serial, force: :cascade do |t|
3618 3619 3620 3621 3622 3623
    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
3624
    t.datetime "created_at"
3625 3626 3627 3628
    t.index ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], name: "taggings_idx", unique: true
    t.index ["tag_id"], name: "index_taggings_on_tag_id"
    t.index ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context"
    t.index ["taggable_id", "taggable_type"], name: "index_taggings_on_taggable_id_and_taggable_type"
Andrew8xx8's avatar
Andrew8xx8 committed
3629 3630
  end

Jasper Maes's avatar
Jasper Maes committed
3631
  create_table "tags", id: :serial, force: :cascade do |t|
3632
    t.string "name"
3633
    t.integer "taggings_count", default: 0
3634 3635
    t.index ["name"], name: "index_tags_on_name", unique: true
    t.index ["name"], name: "index_tags_on_name_trigram", opclass: :gin_trgm_ops, using: :gin
Andrew8xx8's avatar
Andrew8xx8 committed
3636 3637
  end

Jasper Maes's avatar
Jasper Maes committed
3638
  create_table "term_agreements", id: :serial, force: :cascade do |t|
3639 3640 3641 3642 3643
    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
3644 3645 3646
    t.index ["term_id"], name: "index_term_agreements_on_term_id"
    t.index ["user_id", "term_id"], name: "term_agreements_unique_index", unique: true
    t.index ["user_id"], name: "index_term_agreements_on_user_id"
3647 3648
  end

Jasper Maes's avatar
Jasper Maes committed
3649
  create_table "timelogs", id: :serial, force: :cascade do |t|
3650 3651 3652 3653
    t.integer "time_spent", null: false
    t.integer "user_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3654 3655
    t.integer "issue_id"
    t.integer "merge_request_id"
3656
    t.datetime "spent_at"
3657 3658 3659
    t.index ["issue_id"], name: "index_timelogs_on_issue_id"
    t.index ["merge_request_id"], name: "index_timelogs_on_merge_request_id"
    t.index ["user_id"], name: "index_timelogs_on_user_id"
3660 3661
  end

Jasper Maes's avatar
Jasper Maes committed
3662
  create_table "todos", id: :serial, force: :cascade do |t|
3663
    t.integer "user_id", null: false
3664
    t.integer "project_id"
3665 3666
    t.integer "target_id"
    t.string "target_type", null: false
3667
    t.integer "author_id", null: false
3668 3669
    t.integer "action", null: false
    t.string "state", null: false
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
3670 3671
    t.datetime "created_at"
    t.datetime "updated_at"
3672 3673
    t.integer "note_id"
    t.string "commit_id"
3674
    t.integer "group_id"
3675 3676 3677 3678 3679 3680 3681 3682 3683
    t.index ["author_id"], name: "index_todos_on_author_id"
    t.index ["commit_id"], name: "index_todos_on_commit_id"
    t.index ["group_id"], name: "index_todos_on_group_id"
    t.index ["note_id"], name: "index_todos_on_note_id"
    t.index ["project_id"], name: "index_todos_on_project_id"
    t.index ["target_type", "target_id"], name: "index_todos_on_target_type_and_target_id"
    t.index ["user_id", "id"], name: "index_todos_on_user_id_and_id_done", where: "((state)::text = 'done'::text)"
    t.index ["user_id", "id"], name: "index_todos_on_user_id_and_id_pending", where: "((state)::text = 'pending'::text)"
    t.index ["user_id"], name: "index_todos_on_user_id"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
3684 3685
  end

Jasper Maes's avatar
Jasper Maes committed
3686
  create_table "trending_projects", id: :serial, force: :cascade do |t|
3687
    t.integer "project_id", null: false
3688
    t.index ["project_id"], name: "index_trending_projects_on_project_id", unique: true
3689 3690
  end

Jasper Maes's avatar
Jasper Maes committed
3691
  create_table "u2f_registrations", id: :serial, force: :cascade do |t|
3692 3693 3694 3695 3696 3697 3698 3699
    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"
3700 3701
    t.index ["key_handle"], name: "index_u2f_registrations_on_key_handle"
    t.index ["user_id"], name: "index_u2f_registrations_on_user_id"
3702 3703
  end

Jasper Maes's avatar
Jasper Maes committed
3704
  create_table "uploads", id: :serial, force: :cascade do |t|
3705
    t.bigint "size", null: false
3706
    t.string "path", limit: 511, null: false
3707 3708 3709 3710 3711
    t.string "checksum", limit: 64
    t.integer "model_id"
    t.string "model_type"
    t.string "uploader", null: false
    t.datetime "created_at", null: false
3712
    t.integer "store"
Micaël Bergeron's avatar
Micaël Bergeron committed
3713 3714
    t.string "mount_point"
    t.string "secret"
3715 3716 3717 3718
    t.index ["checksum"], name: "index_uploads_on_checksum"
    t.index ["model_id", "model_type"], name: "index_uploads_on_model_id_and_model_type"
    t.index ["store"], name: "index_uploads_on_store"
    t.index ["uploader", "path"], name: "index_uploads_on_uploader_and_path"
3719 3720
  end

Jasper Maes's avatar
Jasper Maes committed
3721
  create_table "user_agent_details", id: :serial, force: :cascade do |t|
3722 3723 3724 3725 3726 3727 3728
    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
3729
    t.index ["subject_id", "subject_type"], name: "index_user_agent_details_on_subject_id_and_subject_type"
3730 3731
  end

Jasper Maes's avatar
Jasper Maes committed
3732
  create_table "user_callouts", id: :serial, force: :cascade do |t|
3733
    t.integer "feature_name", null: false
3734
    t.integer "user_id", null: false
3735 3736
    t.index ["user_id", "feature_name"], name: "index_user_callouts_on_user_id_and_feature_name", unique: true
    t.index ["user_id"], name: "index_user_callouts_on_user_id"
3737 3738
  end

Jasper Maes's avatar
Jasper Maes committed
3739
  create_table "user_custom_attributes", id: :serial, force: :cascade do |t|
3740 3741
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
3742 3743 3744
    t.integer "user_id", null: false
    t.string "key", null: false
    t.string "value", null: false
3745 3746
    t.index ["key", "value"], name: "index_user_custom_attributes_on_key_and_value"
    t.index ["user_id", "key"], name: "index_user_custom_attributes_on_user_id_and_key", unique: true
3747 3748
  end

3749 3750 3751
  create_table "user_interacted_projects", id: false, force: :cascade do |t|
    t.integer "user_id", null: false
    t.integer "project_id", null: false
3752 3753
    t.index ["project_id", "user_id"], name: "index_user_interacted_projects_on_project_id_and_user_id", unique: true
    t.index ["user_id"], name: "index_user_interacted_projects_on_user_id"
3754 3755
  end

Jasper Maes's avatar
Jasper Maes committed
3756
  create_table "user_preferences", id: :serial, force: :cascade do |t|
3757 3758 3759 3760 3761
    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
3762 3763 3764
    t.string "epics_sort"
    t.integer "roadmap_epics_state"
    t.integer "epic_notes_filter", limit: 2, default: 0, null: false
3765 3766
    t.string "issues_sort"
    t.string "merge_requests_sort"
3767 3768
    t.string "roadmaps_sort"
    t.integer "first_day_of_week"
3769 3770 3771
    t.string "timezone"
    t.boolean "time_display_relative"
    t.boolean "time_format_in_24h"
3772
    t.string "projects_sort", limit: 64
3773
    t.boolean "show_whitespace_in_diffs", default: true, null: false
3774
    t.boolean "setup_for_company"
3775
    t.index ["user_id"], name: "index_user_preferences_on_user_id", unique: true
3776 3777
  end

Jasper Maes's avatar
Jasper Maes committed
3778
  create_table "user_statuses", primary_key: "user_id", id: :serial, force: :cascade do |t|
3779 3780 3781 3782
    t.integer "cached_markdown_version"
    t.string "emoji", default: "speech_balloon", null: false
    t.string "message", limit: 100
    t.string "message_html"
3783
    t.index ["user_id"], name: "index_user_statuses_on_user_id"
3784 3785
  end

Jasper Maes's avatar
Jasper Maes committed
3786
  create_table "user_synced_attributes_metadata", id: :serial, force: :cascade do |t|
3787 3788 3789 3790 3791
    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"
3792
    t.index ["user_id"], name: "index_user_synced_attributes_metadata_on_user_id", unique: true
3793 3794
  end

Jasper Maes's avatar
Jasper Maes committed
3795
  create_table "users", id: :serial, force: :cascade do |t|
3796 3797 3798
    t.string "email", default: "", null: false
    t.string "encrypted_password", default: "", null: false
    t.string "reset_password_token"
Andrew8xx8's avatar
Andrew8xx8 committed
3799 3800
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
3801
    t.integer "sign_in_count", default: 0
Andrew8xx8's avatar
Andrew8xx8 committed
3802 3803
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
3804 3805
    t.string "current_sign_in_ip"
    t.string "last_sign_in_ip"
3806 3807
    t.datetime "created_at"
    t.datetime "updated_at"
3808 3809
    t.string "name"
    t.boolean "admin", default: false, null: false
3810
    t.integer "projects_limit", null: false
3811 3812 3813 3814 3815
    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
3816
    t.datetime "locked_at"
3817 3818 3819 3820 3821
    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
3822
    t.datetime "password_expires_at"
3823
    t.integer "created_by_id"
3824
    t.datetime "last_credential_check_at"
3825 3826
    t.string "avatar"
    t.string "confirmation_token"
3827 3828
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
3829 3830 3831
    t.string "unconfirmed_email"
    t.boolean "hide_no_ssh_key", default: false
    t.string "website_url", default: "", null: false
3832
    t.datetime "admin_email_unsubscribed_at"
3833 3834 3835 3836 3837 3838 3839 3840 3841 3842 3843 3844 3845 3846 3847
    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
3848
    t.text "note"
3849
    t.string "unlock_token"
3850
    t.datetime "otp_grace_period_started_at"
3851
    t.boolean "external", default: false
Nick Thomas's avatar
Nick Thomas committed
3852
    t.string "incoming_email_token"
3853
    t.string "organization"
3854
    t.boolean "auditor", default: false, null: false
3855 3856
    t.boolean "require_two_factor_authentication_from_group", default: false, null: false
    t.integer "two_factor_grace_period", default: 48, null: false
3857
    t.boolean "ghost"
3858
    t.date "last_activity_on"
3859
    t.boolean "notified_of_own_activity"
3860
    t.string "preferred_language"
3861 3862 3863 3864
    t.boolean "email_opted_in"
    t.string "email_opted_in_ip"
    t.integer "email_opted_in_source_id"
    t.datetime "email_opted_in_at"
3865
    t.integer "theme_id", limit: 2
3866
    t.integer "accepted_term_id"
3867
    t.string "feed_token"
3868
    t.boolean "private_profile", default: false, null: false
3869
    t.integer "roadmap_layout", limit: 2
3870
    t.boolean "include_private_contributions"
3871
    t.string "commit_email"
3872 3873 3874
    t.integer "group_view"
    t.integer "managing_group_id"
    t.integer "bot_type", limit: 2
3875 3876
    t.string "first_name", limit: 255
    t.string "last_name", limit: 255
3877
    t.string "static_object_token", limit: 255
3878
    t.integer "role", limit: 2
3879
    t.index "lower((name)::text)", name: "index_on_users_name_lower"
3880 3881 3882 3883 3884 3885 3886 3887 3888 3889 3890 3891 3892 3893 3894 3895 3896
    t.index ["accepted_term_id"], name: "index_users_on_accepted_term_id"
    t.index ["admin"], name: "index_users_on_admin"
    t.index ["bot_type"], name: "index_users_on_bot_type"
    t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
    t.index ["created_at"], name: "index_users_on_created_at"
    t.index ["email"], name: "index_users_on_email", unique: true
    t.index ["email"], name: "index_users_on_email_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["feed_token"], name: "index_users_on_feed_token"
    t.index ["ghost"], name: "index_users_on_ghost"
    t.index ["group_view"], name: "index_users_on_group_view"
    t.index ["incoming_email_token"], name: "index_users_on_incoming_email_token"
    t.index ["managing_group_id"], name: "index_users_on_managing_group_id"
    t.index ["name"], name: "index_users_on_name"
    t.index ["name"], name: "index_users_on_name_trigram", opclass: :gin_trgm_ops, using: :gin
    t.index ["public_email"], name: "index_users_on_public_email", where: "((public_email)::text <> ''::text)"
    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
    t.index ["state"], name: "index_users_on_state"
3897 3898
    t.index ["state"], name: "index_users_on_state_and_internal", where: "(ghost IS NOT TRUE)"
    t.index ["state"], name: "index_users_on_state_and_internal_ee", where: "((ghost IS NOT TRUE) AND (bot_type IS NULL))"
3899
    t.index ["static_object_token"], name: "index_users_on_static_object_token", unique: true
3900
    t.index ["unconfirmed_email"], name: "index_users_on_unconfirmed_email", where: "(unconfirmed_email IS NOT NULL)"
3901 3902
    t.index ["username"], name: "index_users_on_username"
    t.index ["username"], name: "index_users_on_username_trigram", opclass: :gin_trgm_ops, using: :gin
Andrew8xx8's avatar
Andrew8xx8 committed
3903 3904
  end

3905 3906 3907 3908 3909
  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
3910 3911
    t.index ["project_id"], name: "index_users_ops_dashboard_projects_on_project_id"
    t.index ["user_id", "project_id"], name: "index_users_ops_dashboard_projects_on_user_id_and_project_id", unique: true
3912 3913
  end

3914 3915 3916 3917 3918 3919 3920
  create_table "users_security_dashboard_projects", id: false, force: :cascade do |t|
    t.bigint "user_id", null: false
    t.bigint "project_id", null: false
    t.index ["project_id", "user_id"], name: "users_security_dashboard_projects_unique_index", unique: true
    t.index ["user_id"], name: "index_users_security_dashboard_projects_on_user_id"
  end

Jasper Maes's avatar
Jasper Maes committed
3921
  create_table "users_star_projects", id: :serial, force: :cascade do |t|
3922 3923
    t.integer "project_id", null: false
    t.integer "user_id", null: false
Ciro Santilli's avatar
Ciro Santilli committed
3924 3925
    t.datetime "created_at"
    t.datetime "updated_at"
3926 3927
    t.index ["project_id"], name: "index_users_star_projects_on_project_id"
    t.index ["user_id", "project_id"], name: "index_users_star_projects_on_user_id_and_project_id", unique: true
Ciro Santilli's avatar
Ciro Santilli committed
3928 3929
  end

3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942
  create_table "vulnerabilities", force: :cascade do |t|
    t.bigint "milestone_id"
    t.bigint "epic_id"
    t.bigint "project_id", null: false
    t.bigint "author_id", null: false
    t.bigint "updated_by_id"
    t.bigint "last_edited_by_id"
    t.date "start_date"
    t.date "due_date"
    t.datetime_with_timezone "last_edited_at"
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.string "title", limit: 255, null: false
3943
    t.text "title_html"
3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954
    t.text "description"
    t.text "description_html"
    t.bigint "start_date_sourcing_milestone_id"
    t.bigint "due_date_sourcing_milestone_id"
    t.bigint "closed_by_id"
    t.datetime_with_timezone "closed_at"
    t.integer "state", limit: 2, default: 1, null: false
    t.integer "severity", limit: 2, null: false
    t.boolean "severity_overridden", default: false
    t.integer "confidence", limit: 2, null: false
    t.boolean "confidence_overridden", default: false
3955
    t.integer "report_type", limit: 2, null: false
3956
    t.integer "cached_markdown_version"
3957 3958 3959 3960 3961 3962 3963 3964 3965 3966 3967
    t.index ["author_id"], name: "index_vulnerabilities_on_author_id"
    t.index ["closed_by_id"], name: "index_vulnerabilities_on_closed_by_id"
    t.index ["due_date_sourcing_milestone_id"], name: "index_vulnerabilities_on_due_date_sourcing_milestone_id"
    t.index ["epic_id"], name: "index_vulnerabilities_on_epic_id"
    t.index ["last_edited_by_id"], name: "index_vulnerabilities_on_last_edited_by_id"
    t.index ["milestone_id"], name: "index_vulnerabilities_on_milestone_id"
    t.index ["project_id"], name: "index_vulnerabilities_on_project_id"
    t.index ["start_date_sourcing_milestone_id"], name: "index_vulnerabilities_on_start_date_sourcing_milestone_id"
    t.index ["updated_by_id"], name: "index_vulnerabilities_on_updated_by_id"
  end

3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981
  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"
3982 3983 3984 3985 3986 3987
    t.index ["author_id"], name: "index_vulnerability_feedback_on_author_id"
    t.index ["comment_author_id"], name: "index_vulnerability_feedback_on_comment_author_id"
    t.index ["issue_id"], name: "index_vulnerability_feedback_on_issue_id"
    t.index ["merge_request_id"], name: "index_vulnerability_feedback_on_merge_request_id"
    t.index ["pipeline_id"], name: "index_vulnerability_feedback_on_pipeline_id"
    t.index ["project_id", "category", "feedback_type", "project_fingerprint"], name: "vulnerability_feedback_unique_idx", unique: true
3988 3989 3990 3991 3992 3993 3994 3995 3996 3997 3998
  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"
3999
    t.index ["project_id", "fingerprint"], name: "index_vulnerability_identifiers_on_project_id_and_fingerprint", unique: true
4000 4001 4002 4003 4004 4005 4006
  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
4007 4008
    t.index ["identifier_id"], name: "index_vulnerability_occurrence_identifiers_on_identifier_id"
    t.index ["occurrence_id", "identifier_id"], name: "index_vulnerability_occurrence_identifiers_on_unique_keys", unique: true
4009 4010 4011 4012 4013 4014 4015
  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
4016 4017
    t.index ["occurrence_id", "pipeline_id"], name: "vulnerability_occurrence_pipelines_on_unique_keys", unique: true
    t.index ["pipeline_id"], name: "index_vulnerability_occurrence_pipelines_on_pipeline_id"
4018 4019 4020 4021 4022 4023 4024 4025 4026 4027 4028 4029 4030 4031 4032 4033 4034
  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
4035
    t.bigint "vulnerability_id"
4036 4037 4038 4039
    t.index ["primary_identifier_id"], name: "index_vulnerability_occurrences_on_primary_identifier_id"
    t.index ["project_id", "primary_identifier_id", "location_fingerprint", "scanner_id"], name: "index_vulnerability_occurrences_on_unique_keys", unique: true
    t.index ["scanner_id"], name: "index_vulnerability_occurrences_on_scanner_id"
    t.index ["uuid"], name: "index_vulnerability_occurrences_on_uuid", unique: true
4040
    t.index ["vulnerability_id"], name: "index_vulnerability_occurrences_on_vulnerability_id"
4041 4042 4043 4044 4045 4046 4047 4048
  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
4049
    t.index ["project_id", "external_id"], name: "index_vulnerability_scanners_on_project_id_and_external_id", unique: true
4050 4051
  end

Jasper Maes's avatar
Jasper Maes committed
4052
  create_table "web_hook_logs", id: :serial, force: :cascade do |t|
4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064
    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
4065 4066
    t.index ["created_at", "web_hook_id"], name: "index_web_hook_logs_on_created_at_and_web_hook_id"
    t.index ["web_hook_id"], name: "index_web_hook_logs_on_web_hook_id"
4067 4068
  end

Jasper Maes's avatar
Jasper Maes committed
4069
  create_table "web_hooks", id: :serial, force: :cascade do |t|
4070
    t.integer "project_id"
4071 4072
    t.datetime "created_at"
    t.datetime "updated_at"
4073 4074 4075 4076 4077 4078
    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
4079
    t.integer "group_id"
4080 4081 4082 4083 4084
    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
4085
    t.boolean "repository_update_events", default: false, null: false
Luke "Jared" Bennett's avatar
Luke "Jared" Bennett committed
4086
    t.boolean "job_events", default: false, null: false
4087
    t.boolean "confidential_note_events"
4088
    t.text "push_events_branch_filter"
4089 4090 4091 4092
    t.string "encrypted_token"
    t.string "encrypted_token_iv"
    t.string "encrypted_url"
    t.string "encrypted_url_iv"
4093 4094
    t.index ["project_id"], name: "index_web_hooks_on_project_id"
    t.index ["type"], name: "index_web_hooks_on_type"
Andrew8xx8's avatar
Andrew8xx8 committed
4095 4096
  end

4097 4098 4099 4100 4101 4102 4103 4104 4105
  create_table "zoom_meetings", force: :cascade do |t|
    t.bigint "project_id", null: false
    t.bigint "issue_id", null: false
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
    t.integer "issue_status", limit: 2, default: 1, null: false
    t.string "url", limit: 255
    t.index ["issue_id", "issue_status"], name: "index_zoom_meetings_on_issue_id_and_issue_status", unique: true, where: "(issue_status = 1)"
    t.index ["issue_id"], name: "index_zoom_meetings_on_issue_id"
4106
    t.index ["issue_status"], name: "index_zoom_meetings_on_issue_status"
4107 4108 4109
    t.index ["project_id"], name: "index_zoom_meetings_on_project_id"
  end

4110
  add_foreign_key "alerts_service_data", "services", on_delete: :cascade
4111
  add_foreign_key "allowed_email_domains", "namespaces", column: "group_id", on_delete: :cascade
4112 4113 4114 4115 4116 4117
  add_foreign_key "analytics_cycle_analytics_group_stages", "labels", column: "end_event_label_id", on_delete: :cascade
  add_foreign_key "analytics_cycle_analytics_group_stages", "labels", column: "start_event_label_id", on_delete: :cascade
  add_foreign_key "analytics_cycle_analytics_group_stages", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "analytics_cycle_analytics_project_stages", "labels", column: "end_event_label_id", on_delete: :cascade
  add_foreign_key "analytics_cycle_analytics_project_stages", "labels", column: "start_event_label_id", on_delete: :cascade
  add_foreign_key "analytics_cycle_analytics_project_stages", "projects", on_delete: :cascade
4118 4119
  add_foreign_key "analytics_language_trend_repository_languages", "programming_languages", on_delete: :cascade
  add_foreign_key "analytics_language_trend_repository_languages", "projects", on_delete: :cascade
4120 4121
  add_foreign_key "analytics_repository_file_commits", "analytics_repository_files", on_delete: :cascade
  add_foreign_key "analytics_repository_file_commits", "projects", on_delete: :cascade
4122 4123
  add_foreign_key "analytics_repository_file_edits", "analytics_repository_files", on_delete: :cascade
  add_foreign_key "analytics_repository_file_edits", "projects", on_delete: :cascade
4124
  add_foreign_key "analytics_repository_files", "projects", on_delete: :cascade
4125 4126
  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
4127
  add_foreign_key "application_settings", "projects", column: "instance_administration_project_id", on_delete: :nullify
4128
  add_foreign_key "application_settings", "users", column: "usage_stats_set_by_user_id", name: "fk_964370041d", on_delete: :nullify
4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 4140 4141 4142 4143 4144
  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
4145
  add_foreign_key "aws_roles", "users", on_delete: :cascade
4146 4147
  add_foreign_key "badges", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "badges", "projects", on_delete: :cascade
4148 4149
  add_foreign_key "board_assignees", "boards", on_delete: :cascade
  add_foreign_key "board_assignees", "users", column: "assignee_id", on_delete: :cascade
4150 4151 4152
  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
4153 4154
  add_foreign_key "board_labels", "boards", on_delete: :cascade
  add_foreign_key "board_labels", "labels", on_delete: :cascade
4155 4156 4157
  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
4158
  add_foreign_key "boards", "namespaces", column: "group_id", name: "fk_1e9a074a35", on_delete: :cascade
4159
  add_foreign_key "boards", "projects", name: "fk_f15266b5f9", on_delete: :cascade
4160
  add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
Kamil Trzciński's avatar
Kamil Trzciński committed
4161
  add_foreign_key "ci_build_needs", "ci_builds", column: "build_id", on_delete: :cascade
4162
  add_foreign_key "ci_build_trace_chunks", "ci_builds", column: "build_id", on_delete: :cascade
4163 4164 4165 4166
  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
4167
  add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
4168
  add_foreign_key "ci_builds", "ci_pipelines", column: "commit_id", name: "fk_d3130c9a7f", on_delete: :cascade
4169
  add_foreign_key "ci_builds", "ci_pipelines", column: "upstream_pipeline_id", name: "fk_87f4cefcda", on_delete: :cascade
4170
  add_foreign_key "ci_builds", "ci_stages", column: "stage_id", name: "fk_3a9eaa254d", on_delete: :cascade
4171
  add_foreign_key "ci_builds", "projects", name: "fk_befce0568a", on_delete: :cascade
4172
  add_foreign_key "ci_builds_metadata", "ci_builds", column: "build_id", on_delete: :cascade
4173
  add_foreign_key "ci_builds_metadata", "projects", on_delete: :cascade
4174
  add_foreign_key "ci_builds_runner_session", "ci_builds", column: "build_id", on_delete: :cascade
Shinya Maeda's avatar
Shinya Maeda committed
4175
  add_foreign_key "ci_group_variables", "namespaces", column: "group_id", name: "fk_33ae4d58d8", on_delete: :cascade
4176
  add_foreign_key "ci_job_artifacts", "ci_builds", column: "job_id", on_delete: :cascade
4177
  add_foreign_key "ci_job_artifacts", "projects", on_delete: :cascade
4178
  add_foreign_key "ci_job_variables", "ci_builds", column: "job_id", on_delete: :cascade
4179 4180
  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
4181
  add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade
4182
  add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade
4183
  add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify
Shinya Maeda's avatar
init  
Shinya Maeda committed
4184
  add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade
4185
  add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify
4186
  add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify
4187
  add_foreign_key "ci_pipelines", "external_pull_requests", name: "fk_190998ef09", on_delete: :nullify
Shinya Maeda's avatar
Shinya Maeda committed
4188
  add_foreign_key "ci_pipelines", "merge_requests", name: "fk_a23be95014", on_delete: :cascade
4189
  add_foreign_key "ci_pipelines", "projects", name: "fk_86635dbd80", on_delete: :cascade
4190
  add_foreign_key "ci_runner_namespaces", "ci_runners", column: "runner_id", on_delete: :cascade
4191
  add_foreign_key "ci_runner_namespaces", "namespaces", on_delete: :cascade
4192
  add_foreign_key "ci_runner_projects", "projects", name: "fk_4478a6f1e4", on_delete: :cascade
4193 4194 4195 4196 4197
  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
4198
  add_foreign_key "ci_stages", "ci_pipelines", column: "pipeline_id", name: "fk_fb57e6cc56", on_delete: :cascade
4199
  add_foreign_key "ci_stages", "projects", name: "fk_2360681d1d", on_delete: :cascade
4200 4201
  add_foreign_key "ci_subscriptions_projects", "projects", column: "downstream_project_id", on_delete: :cascade
  add_foreign_key "ci_subscriptions_projects", "projects", column: "upstream_project_id", on_delete: :cascade
4202
  add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
4203
  add_foreign_key "ci_triggers", "projects", name: "fk_e3e63f966e", on_delete: :cascade
4204
  add_foreign_key "ci_triggers", "users", column: "owner_id", name: "fk_e8e10d1964", on_delete: :cascade
4205
  add_foreign_key "ci_variables", "projects", name: "fk_ada5eb64b3", on_delete: :cascade
4206 4207
  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
4208 4209 4210
  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
4211 4212
  add_foreign_key "cluster_providers_aws", "clusters", on_delete: :cascade
  add_foreign_key "cluster_providers_aws", "users", column: "created_by_user_id", on_delete: :nullify
Shinya Maeda's avatar
Shinya Maeda committed
4213
  add_foreign_key "cluster_providers_gcp", "clusters", on_delete: :cascade
4214
  add_foreign_key "clusters", "projects", column: "management_project_id", name: "fk_f05c5e5a42", on_delete: :nullify
Shinya Maeda's avatar
Shinya Maeda committed
4215
  add_foreign_key "clusters", "users", on_delete: :nullify
Amit Rathi's avatar
Amit Rathi committed
4216
  add_foreign_key "clusters_applications_cert_managers", "clusters", on_delete: :cascade
4217
  add_foreign_key "clusters_applications_elastic_stacks", "clusters", on_delete: :cascade
4218
  add_foreign_key "clusters_applications_helm", "clusters", on_delete: :cascade
4219
  add_foreign_key "clusters_applications_ingress", "clusters", on_delete: :cascade
4220 4221
  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
4222
  add_foreign_key "clusters_applications_knative", "clusters", on_delete: :cascade
4223
  add_foreign_key "clusters_applications_prometheus", "clusters", name: "fk_557e773639", on_delete: :cascade
4224 4225
  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
4226 4227
  add_foreign_key "clusters_kubernetes_namespaces", "cluster_projects", on_delete: :nullify
  add_foreign_key "clusters_kubernetes_namespaces", "clusters", on_delete: :cascade
4228
  add_foreign_key "clusters_kubernetes_namespaces", "environments", on_delete: :nullify
4229
  add_foreign_key "clusters_kubernetes_namespaces", "projects", on_delete: :nullify
4230
  add_foreign_key "container_repositories", "projects"
4231 4232
  add_foreign_key "dependency_proxy_blobs", "namespaces", column: "group_id", on_delete: :cascade
  add_foreign_key "dependency_proxy_group_settings", "namespaces", column: "group_id", on_delete: :cascade
4233
  add_foreign_key "deploy_keys_projects", "projects", name: "fk_58a901ca7e", on_delete: :cascade
4234 4235
  add_foreign_key "deployment_merge_requests", "deployments", on_delete: :cascade
  add_foreign_key "deployment_merge_requests", "merge_requests", on_delete: :cascade
4236
  add_foreign_key "deployments", "clusters", name: "fk_289bba3222", on_delete: :nullify
4237
  add_foreign_key "deployments", "projects", name: "fk_b9a3851b82", on_delete: :cascade
4238 4239 4240
  add_foreign_key "description_versions", "epics", on_delete: :cascade
  add_foreign_key "description_versions", "issues", on_delete: :cascade
  add_foreign_key "description_versions", "merge_requests", on_delete: :cascade
4241 4242 4243 4244
  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
4245
  add_foreign_key "design_management_versions", "issues", on_delete: :cascade
4246
  add_foreign_key "design_management_versions", "users", column: "author_id", name: "fk_c1440b4896", on_delete: :nullify
4247 4248 4249 4250
  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
4251
  add_foreign_key "environments", "projects", name: "fk_d1c8c1da6a", on_delete: :cascade
4252 4253 4254
  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
4255
  add_foreign_key "epics", "epics", column: "due_date_sourcing_epic_id", name: "fk_013c9f36ca", on_delete: :nullify
4256
  add_foreign_key "epics", "epics", column: "parent_id", name: "fk_25b99c1be3", on_delete: :cascade
4257
  add_foreign_key "epics", "epics", column: "start_date_sourcing_epic_id", name: "fk_9d480c64b2", on_delete: :nullify
4258 4259 4260 4261 4262
  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
4263
  add_foreign_key "events", "namespaces", column: "group_id", name: "fk_61fbf6ca48", on_delete: :cascade
4264 4265
  add_foreign_key "events", "projects", on_delete: :cascade
  add_foreign_key "events", "users", column: "author_id", name: "fk_edfd187b6f", on_delete: :cascade
4266
  add_foreign_key "evidences", "releases", on_delete: :cascade
4267
  add_foreign_key "external_pull_requests", "projects", on_delete: :cascade
4268 4269 4270
  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
4271
  add_foreign_key "fork_networks", "projects", column: "root_project_id", name: "fk_e7b436b2b5", on_delete: :nullify
4272
  add_foreign_key "forked_project_links", "projects", column: "forked_to_project_id", name: "fk_434510edb0", on_delete: :cascade
4273
  add_foreign_key "geo_container_repository_updated_events", "container_repositories", name: "fk_212c89c706", on_delete: :cascade
4274
  add_foreign_key "geo_event_log", "geo_cache_invalidation_events", column: "cache_invalidation_event_id", name: "fk_42c3b54bed", on_delete: :cascade
4275
  add_foreign_key "geo_event_log", "geo_container_repository_updated_events", column: "container_repository_updated_event_id", name: "fk_6ada82d42a", on_delete: :cascade
4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290 4291 4292 4293 4294 4295 4296 4297
  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
4298
  add_foreign_key "gpg_key_subkeys", "gpg_keys", on_delete: :cascade
4299
  add_foreign_key "gpg_keys", "users", on_delete: :cascade
4300
  add_foreign_key "gpg_signatures", "gpg_key_subkeys", on_delete: :nullify
4301 4302
  add_foreign_key "gpg_signatures", "gpg_keys", on_delete: :nullify
  add_foreign_key "gpg_signatures", "projects", on_delete: :cascade
4303
  add_foreign_key "grafana_integrations", "projects", on_delete: :cascade
4304
  add_foreign_key "group_custom_attributes", "namespaces", column: "group_id", on_delete: :cascade
4305 4306
  add_foreign_key "group_group_links", "namespaces", column: "shared_group_id", on_delete: :cascade
  add_foreign_key "group_group_links", "namespaces", column: "shared_with_group_id", on_delete: :cascade
4307
  add_foreign_key "identities", "saml_providers", name: "fk_aade90f0fc", on_delete: :cascade
4308
  add_foreign_key "import_export_uploads", "namespaces", column: "group_id", name: "fk_83319d9721", on_delete: :cascade
4309
  add_foreign_key "import_export_uploads", "projects", on_delete: :cascade
4310 4311 4312
  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
4313
  add_foreign_key "internal_ids", "namespaces", name: "fk_162941d509", on_delete: :cascade
4314
  add_foreign_key "internal_ids", "projects", on_delete: :cascade
4315
  add_foreign_key "ip_restrictions", "namespaces", column: "group_id", on_delete: :cascade
4316 4317
  add_foreign_key "issue_assignees", "issues", name: "fk_b7d881734a", on_delete: :cascade
  add_foreign_key "issue_assignees", "users", name: "fk_5e0c8d9154", on_delete: :cascade
4318 4319
  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
4320
  add_foreign_key "issue_metrics", "issues", on_delete: :cascade
4321
  add_foreign_key "issue_tracker_data", "services", on_delete: :cascade
4322
  add_foreign_key "issues", "issues", column: "duplicated_to_id", name: "fk_9c4516d665", on_delete: :nullify
4323 4324
  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
4325
  add_foreign_key "issues", "projects", name: "fk_899c8f3231", on_delete: :cascade
4326
  add_foreign_key "issues", "users", column: "author_id", name: "fk_05f1e72feb", on_delete: :nullify
haseeb's avatar
haseeb committed
4327
  add_foreign_key "issues", "users", column: "closed_by_id", name: "fk_c63cbf6c25", on_delete: :nullify
4328
  add_foreign_key "issues", "users", column: "updated_by_id", name: "fk_ffed080f01", on_delete: :nullify
4329 4330
  add_foreign_key "issues_prometheus_alert_events", "issues", on_delete: :cascade
  add_foreign_key "issues_prometheus_alert_events", "prometheus_alert_events", on_delete: :cascade
4331 4332
  add_foreign_key "issues_self_managed_prometheus_alert_events", "issues", on_delete: :cascade
  add_foreign_key "issues_self_managed_prometheus_alert_events", "self_managed_prometheus_alert_events", on_delete: :cascade
4333 4334
  add_foreign_key "jira_connect_subscriptions", "jira_connect_installations", on_delete: :cascade
  add_foreign_key "jira_connect_subscriptions", "namespaces", on_delete: :cascade
4335
  add_foreign_key "jira_tracker_data", "services", on_delete: :cascade
Stan Hu's avatar
Stan Hu committed
4336
  add_foreign_key "label_links", "labels", name: "fk_d97dd08678", on_delete: :cascade
4337 4338
  add_foreign_key "label_priorities", "labels", on_delete: :cascade
  add_foreign_key "label_priorities", "projects", on_delete: :cascade
4339
  add_foreign_key "labels", "namespaces", column: "group_id", on_delete: :cascade
4340
  add_foreign_key "labels", "projects", name: "fk_7de4989a69", on_delete: :cascade
4341 4342
  add_foreign_key "lfs_file_locks", "projects", on_delete: :cascade
  add_foreign_key "lfs_file_locks", "users", on_delete: :cascade
4343 4344
  add_foreign_key "list_user_preferences", "lists", on_delete: :cascade
  add_foreign_key "list_user_preferences", "users", on_delete: :cascade
4345 4346
  add_foreign_key "lists", "boards", name: "fk_0d3f677137", on_delete: :cascade
  add_foreign_key "lists", "labels", name: "fk_7a5553d60f", on_delete: :cascade
4347 4348
  add_foreign_key "lists", "milestones", on_delete: :cascade
  add_foreign_key "lists", "users", name: "fk_d6cf4279f7", on_delete: :cascade
4349
  add_foreign_key "members", "users", name: "fk_2e88fb7ce9", on_delete: :cascade
4350 4351
  add_foreign_key "merge_request_assignees", "merge_requests", on_delete: :cascade
  add_foreign_key "merge_request_assignees", "users", on_delete: :cascade
4352 4353
  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
4354
  add_foreign_key "merge_request_diff_commits", "merge_request_diffs", on_delete: :cascade
4355
  add_foreign_key "merge_request_diff_files", "merge_request_diffs", on_delete: :cascade
4356
  add_foreign_key "merge_request_diffs", "merge_requests", name: "fk_8483f3258f", on_delete: :cascade
4357
  add_foreign_key "merge_request_metrics", "ci_pipelines", column: "pipeline_id", on_delete: :cascade
Timothy Andrew's avatar
Timothy Andrew committed
4358
  add_foreign_key "merge_request_metrics", "merge_requests", on_delete: :cascade
4359 4360
  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
4361
  add_foreign_key "merge_requests", "ci_pipelines", column: "head_pipeline_id", name: "fk_fd82eae0b9", on_delete: :nullify
4362
  add_foreign_key "merge_requests", "merge_request_diffs", column: "latest_merge_request_diff_id", name: "fk_06067f5644", on_delete: :nullify
4363 4364
  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
4365
  add_foreign_key "merge_requests", "projects", column: "target_project_id", name: "fk_a6963e8447", on_delete: :cascade
4366 4367 4368 4369
  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
4370 4371
  add_foreign_key "merge_requests_closing_issues", "issues", on_delete: :cascade
  add_foreign_key "merge_requests_closing_issues", "merge_requests", on_delete: :cascade
4372 4373
  add_foreign_key "merge_trains", "ci_pipelines", column: "pipeline_id", on_delete: :nullify
  add_foreign_key "merge_trains", "merge_requests", on_delete: :cascade
4374
  add_foreign_key "merge_trains", "projects", column: "target_project_id", on_delete: :cascade
4375
  add_foreign_key "merge_trains", "users", on_delete: :cascade
4376 4377
  add_foreign_key "milestone_releases", "milestones", on_delete: :cascade
  add_foreign_key "milestone_releases", "releases", on_delete: :cascade
Felipe Artur's avatar
Felipe Artur committed
4378
  add_foreign_key "milestones", "namespaces", column: "group_id", name: "fk_95650a40d4", on_delete: :cascade
4379
  add_foreign_key "milestones", "projects", name: "fk_9bd0a0c791", on_delete: :cascade
4380 4381
  add_foreign_key "namespace_aggregation_schedules", "namespaces", on_delete: :cascade
  add_foreign_key "namespace_root_storage_statistics", "namespaces", on_delete: :cascade
4382 4383 4384 4385
  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
4386
  add_foreign_key "note_diff_files", "notes", column: "diff_note_id", on_delete: :cascade
4387
  add_foreign_key "notes", "projects", name: "fk_99e097b079", on_delete: :cascade
4388
  add_foreign_key "notes", "reviews", name: "fk_2e82291620", on_delete: :nullify
4389
  add_foreign_key "notification_settings", "users", name: "fk_0c95e91db7", on_delete: :cascade
4390
  add_foreign_key "oauth_openid_requests", "oauth_access_grants", column: "access_grant_id", name: "fk_oauth_openid_requests_oauth_access_grants_access_grant_id"
4391 4392 4393
  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
4394 4395
  add_foreign_key "packages_conan_file_metadata", "packages_package_files", column: "package_file_id", on_delete: :cascade
  add_foreign_key "packages_conan_metadata", "packages_packages", column: "package_id", on_delete: :cascade
4396 4397
  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
4398 4399
  add_foreign_key "packages_package_metadata", "packages_packages", column: "package_id", on_delete: :cascade
  add_foreign_key "packages_package_tags", "packages_packages", column: "package_id", on_delete: :cascade
4400
  add_foreign_key "packages_packages", "projects", on_delete: :cascade
4401
  add_foreign_key "pages_domain_acme_orders", "pages_domains", on_delete: :cascade
4402
  add_foreign_key "pages_domains", "projects", name: "fk_ea2f6dfc6f", on_delete: :cascade
4403 4404
  add_foreign_key "path_locks", "projects", name: "fk_5265c98f24", on_delete: :cascade
  add_foreign_key "path_locks", "users"
4405
  add_foreign_key "personal_access_tokens", "users"
4406
  add_foreign_key "plan_limits", "plans", on_delete: :cascade
4407
  add_foreign_key "pool_repositories", "projects", column: "source_project_id", on_delete: :nullify
4408
  add_foreign_key "pool_repositories", "shards", on_delete: :restrict
4409
  add_foreign_key "project_alerting_settings", "projects", on_delete: :cascade
4410
  add_foreign_key "project_aliases", "projects", on_delete: :cascade
4411 4412
  add_foreign_key "project_authorizations", "projects", on_delete: :cascade
  add_foreign_key "project_authorizations", "users", on_delete: :cascade
4413
  add_foreign_key "project_auto_devops", "projects", on_delete: :cascade
4414
  add_foreign_key "project_ci_cd_settings", "projects", name: "fk_24c15d2f2e", on_delete: :cascade
4415
  add_foreign_key "project_custom_attributes", "projects", on_delete: :cascade
4416
  add_foreign_key "project_daily_statistics", "projects", on_delete: :cascade
4417 4418
  add_foreign_key "project_deploy_tokens", "deploy_tokens", on_delete: :cascade
  add_foreign_key "project_deploy_tokens", "projects", on_delete: :cascade
4419
  add_foreign_key "project_error_tracking_settings", "projects", on_delete: :cascade
4420
  add_foreign_key "project_feature_usages", "projects", on_delete: :cascade
4421 4422 4423
  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
4424
  add_foreign_key "project_incident_management_settings", "projects", on_delete: :cascade
4425
  add_foreign_key "project_metrics_settings", "projects", on_delete: :cascade
4426
  add_foreign_key "project_mirror_data", "projects", name: "fk_d1aad367d7", on_delete: :cascade
4427
  add_foreign_key "project_pages_metadata", "projects", on_delete: :cascade
4428 4429
  add_foreign_key "project_repositories", "projects", on_delete: :cascade
  add_foreign_key "project_repositories", "shards", on_delete: :restrict
4430
  add_foreign_key "project_repository_states", "projects", on_delete: :cascade
4431
  add_foreign_key "project_statistics", "projects", on_delete: :cascade
4432
  add_foreign_key "project_tracing_settings", "projects", on_delete: :cascade
4433
  add_foreign_key "projects", "pool_repositories", name: "fk_6e5c14658a", on_delete: :nullify
4434
  add_foreign_key "projects", "users", column: "marked_for_deletion_by_user_id", name: "fk_25d8780d11", on_delete: :nullify
4435 4436 4437 4438 4439
  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
4440
  add_foreign_key "prometheus_metrics", "projects", on_delete: :cascade
4441
  add_foreign_key "protected_branch_merge_access_levels", "namespaces", column: "group_id", name: "fk_98f3d044fe", on_delete: :cascade
4442
  add_foreign_key "protected_branch_merge_access_levels", "protected_branches", name: "fk_8a3072ccb3", on_delete: :cascade
4443 4444
  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
4445
  add_foreign_key "protected_branch_push_access_levels", "protected_branches", name: "fk_9ffc86a3d9", on_delete: :cascade
4446 4447 4448 4449
  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
4450
  add_foreign_key "protected_branches", "projects", name: "fk_7a9c6d93e7", on_delete: :cascade
4451 4452 4453 4454 4455
  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
4456
  add_foreign_key "protected_tag_create_access_levels", "protected_tags", name: "fk_f7dfda8c51", on_delete: :cascade
4457
  add_foreign_key "protected_tag_create_access_levels", "users"
4458
  add_foreign_key "protected_tags", "projects", name: "fk_8e4af87648", on_delete: :cascade
4459
  add_foreign_key "push_event_payloads", "events", name: "fk_36c74129da", on_delete: :cascade
4460
  add_foreign_key "push_rules", "projects", name: "fk_83b29894de", on_delete: :cascade
4461
  add_foreign_key "release_links", "releases", on_delete: :cascade
4462
  add_foreign_key "releases", "projects", name: "fk_47fe2a0596", on_delete: :cascade
4463
  add_foreign_key "releases", "users", column: "author_id", name: "fk_8e4456f90f", on_delete: :nullify
4464
  add_foreign_key "remote_mirrors", "projects", name: "fk_43a9aa4ca8", on_delete: :cascade
4465
  add_foreign_key "repository_languages", "projects", on_delete: :cascade
4466
  add_foreign_key "resource_label_events", "epics", on_delete: :cascade
Jan Provaznik's avatar
Jan Provaznik committed
4467 4468 4469 4470
  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
4471 4472 4473 4474 4475
  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
4476 4477
  add_foreign_key "self_managed_prometheus_alert_events", "environments", on_delete: :cascade
  add_foreign_key "self_managed_prometheus_alert_events", "projects", on_delete: :cascade
4478
  add_foreign_key "services", "projects", name: "fk_71cce407f9", on_delete: :cascade
4479 4480
  add_foreign_key "slack_integrations", "services", on_delete: :cascade
  add_foreign_key "smartcard_identities", "users", on_delete: :cascade
4481
  add_foreign_key "snippets", "projects", name: "fk_be41fd4bb7", on_delete: :cascade
4482 4483
  add_foreign_key "software_license_policies", "projects", on_delete: :cascade
  add_foreign_key "software_license_policies", "software_licenses", on_delete: :cascade
4484
  add_foreign_key "subscriptions", "projects", on_delete: :cascade
4485
  add_foreign_key "suggestions", "notes", on_delete: :cascade
4486
  add_foreign_key "system_note_metadata", "description_versions", name: "fk_fbd87415c9", on_delete: :nullify
4487
  add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade
4488 4489
  add_foreign_key "term_agreements", "application_setting_terms", column: "term_id"
  add_foreign_key "term_agreements", "users", on_delete: :cascade
4490 4491
  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
4492
  add_foreign_key "todos", "namespaces", column: "group_id", on_delete: :cascade
4493
  add_foreign_key "todos", "notes", name: "fk_91d1f47b13", on_delete: :cascade
4494
  add_foreign_key "todos", "projects", name: "fk_45054f9c45", on_delete: :cascade
4495 4496
  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
4497
  add_foreign_key "trending_projects", "projects", on_delete: :cascade
4498
  add_foreign_key "u2f_registrations", "users"
4499
  add_foreign_key "user_callouts", "users", on_delete: :cascade
4500
  add_foreign_key "user_custom_attributes", "users", on_delete: :cascade
4501 4502
  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
4503
  add_foreign_key "user_preferences", "users", on_delete: :cascade
4504
  add_foreign_key "user_statuses", "users", on_delete: :cascade
4505
  add_foreign_key "user_synced_attributes_metadata", "users", on_delete: :cascade
4506
  add_foreign_key "users", "application_setting_terms", column: "accepted_term_id", name: "fk_789cd90b35", on_delete: :cascade
4507 4508 4509
  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
4510 4511
  add_foreign_key "users_security_dashboard_projects", "projects", on_delete: :cascade
  add_foreign_key "users_security_dashboard_projects", "users", on_delete: :cascade
4512
  add_foreign_key "users_star_projects", "projects", name: "fk_22cd27ddfc", on_delete: :cascade
4513 4514 4515 4516 4517 4518 4519 4520 4521
  add_foreign_key "vulnerabilities", "epics", name: "fk_1d37cddf91", on_delete: :nullify
  add_foreign_key "vulnerabilities", "milestones", column: "due_date_sourcing_milestone_id", name: "fk_7c5bb22a22", on_delete: :nullify
  add_foreign_key "vulnerabilities", "milestones", column: "start_date_sourcing_milestone_id", name: "fk_88b4d546ef", on_delete: :nullify
  add_foreign_key "vulnerabilities", "milestones", name: "fk_131d289c65", on_delete: :nullify
  add_foreign_key "vulnerabilities", "projects", name: "fk_efb96ab1e2", on_delete: :cascade
  add_foreign_key "vulnerabilities", "users", column: "author_id", name: "fk_b1de915a15", on_delete: :nullify
  add_foreign_key "vulnerabilities", "users", column: "closed_by_id", name: "fk_cf5c60acbf", on_delete: :nullify
  add_foreign_key "vulnerabilities", "users", column: "last_edited_by_id", name: "fk_1302949740", on_delete: :nullify
  add_foreign_key "vulnerabilities", "users", column: "updated_by_id", name: "fk_7ac31eacb9", on_delete: :nullify
4522 4523 4524 4525 4526 4527 4528 4529 4530 4531 4532 4533
  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
4534
  add_foreign_key "vulnerability_occurrences", "vulnerabilities", name: "fk_97ffe77653", on_delete: :nullify
4535 4536 4537
  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
4538
  add_foreign_key "web_hook_logs", "web_hooks", on_delete: :cascade
4539
  add_foreign_key "web_hooks", "projects", name: "fk_0c8ca6d9d1", on_delete: :cascade
4540 4541
  add_foreign_key "zoom_meetings", "issues", on_delete: :cascade
  add_foreign_key "zoom_meetings", "projects", on_delete: :cascade
4542
end