Read about our upcoming Code of Conduct on this issue

schema.rb 243 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_12_04_070713) 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
    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.integer "metrics_port", default: 8089
    t.boolean "akismet_enabled", default: false
    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
196
    t.boolean "user_default_external", default: false, null: false
197
198
    t.boolean "elasticsearch_indexing", default: false, null: false
    t.boolean "elasticsearch_search", default: false, null: false
199
    t.string "repository_storages", default: "default"
200
201
202
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
203
    t.boolean "usage_ping_enabled", default: true, null: false
204
205
206
207
    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"
208
    t.integer "rsa_key_restriction", default: 0, null: false
209
    t.integer "dsa_key_restriction", default: -1, null: false
210
211
    t.integer "ecdsa_key_restriction", default: 0, null: false
    t.integer "ed25519_key_restriction", default: 0, null: false
Jacob Vosmaer's avatar
Jacob Vosmaer committed
212
213
214
215
216
    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
217
    t.boolean "html_emails_enabled", default: true
218
219
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
220
221
    t.integer "shared_runners_minutes", default: 0, null: false
    t.bigint "repository_size_limit", default: 0
222
    t.integer "terminal_max_session_time", default: 0, null: false
223
224
225
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
226
    t.string "default_artifacts_expire_in", default: "0", null: false
227
228
229
230
231
    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.integer "geo_status_timeout", default: 10
232
    t.string "uuid"
233
    t.decimal "polling_interval_multiplier", default: "1.0", null: false
234
    t.boolean "elasticsearch_experimental_indexer"
235
    t.integer "cached_markdown_version"
236
237
238
239
    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
240
    t.boolean "prometheus_metrics_enabled", default: true, null: false
241
    t.boolean "authorized_keys_enabled", default: true, null: false
242
243
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
244
245
    t.boolean "slack_app_enabled", default: false
    t.string "slack_app_id"
246
    t.integer "performance_bar_allowed_group_id"
247
    t.boolean "allow_group_owners_to_manage_ldap", default: true, null: false
248
    t.boolean "hashed_storage_enabled", default: true, null: false
249
    t.boolean "project_export_enabled", default: true, null: false
250
    t.boolean "auto_devops_enabled", default: true, null: false
251
252
253
254
255
256
257
258
259
    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
260
261
262
    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
263
264
265
    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
266
    t.string "auto_devops_domain"
267
268
269
    t.boolean "external_authorization_service_enabled", default: false, null: false
    t.string "external_authorization_service_url"
    t.string "external_authorization_service_default_label"
270
    t.boolean "pages_domain_verification_enabled", default: true, null: false
271
    t.string "user_default_internal_regex"
272
273
274
275
276
277
278
    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"
279
    t.boolean "enforce_terms", default: false
280
281
    t.integer "file_template_project_id"
    t.boolean "pseudonymizer_enabled", default: false, null: false
282
    t.boolean "hide_third_party_offers", default: false, null: false
283
    t.boolean "snowplow_enabled", default: false, null: false
284
    t.string "snowplow_collector_hostname"
285
    t.string "snowplow_cookie_domain"
286
    t.boolean "instance_statistics_visibility_private", default: false, null: false
Phil Hughes's avatar
Phil Hughes committed
287
    t.boolean "web_ide_clientside_preview_enabled", default: false, null: false
288
    t.boolean "user_show_add_ssh_key_message", default: true, null: false
289
    t.integer "custom_project_templates_group_id"
290
    t.integer "usage_stats_set_by_user_id"
291
    t.integer "receive_max_input_size"
292
    t.integer "diff_max_patch_bytes", default: 102400, null: false
293
    t.integer "archive_builds_in_seconds"
294
    t.string "commit_email_hostname"
295
    t.boolean "protected_ci_variables", default: false, null: false
296
    t.string "runners_registration_token_encrypted"
Jan Provaznik's avatar
Jan Provaznik committed
297
    t.integer "local_markdown_version", default: 0, null: false
298
    t.integer "first_day_of_week", default: 0, null: false
299
    t.boolean "elasticsearch_limit_indexing", default: false, null: false
Gosia Ksionek's avatar
Gosia Ksionek committed
300
    t.integer "default_project_creation", default: 2, null: false
301
302
    t.string "lets_encrypt_notification_email"
    t.boolean "lets_encrypt_terms_of_service_accepted", default: false, null: false
303
    t.string "geo_node_allowed_ips", default: "0.0.0.0/0, ::/0"
304
305
    t.integer "elasticsearch_shards", default: 5, null: false
    t.integer "elasticsearch_replicas", default: 1, null: false
306
307
    t.text "encrypted_lets_encrypt_private_key"
    t.text "encrypted_lets_encrypt_private_key_iv"
Matija Čupić's avatar
Matija Čupić committed
308
    t.string "required_instance_ci_template"
309
    t.boolean "dns_rebinding_protection_enabled", default: true, null: false
Małgorzata Ksionek's avatar
Małgorzata Ksionek committed
310
    t.boolean "default_project_deletion_protection", default: false, null: false
311
    t.boolean "grafana_enabled", default: false, null: false
312
    t.boolean "lock_memberships_to_ldap", default: false, null: false
313
    t.boolean "time_tracking_limit_to_hours", default: false, null: false
314
    t.string "grafana_url", default: "/-/grafana", null: false
315
    t.boolean "login_recaptcha_protection_enabled", default: false, null: false
316
    t.string "outbound_local_requests_whitelist", limit: 255, default: [], null: false, array: true
317
    t.integer "raw_blob_request_limit", default: 300, null: false
318
    t.boolean "allow_local_requests_from_web_hooks_and_services", default: false, null: false
319
    t.boolean "allow_local_requests_from_system_hooks", default: true, null: false
320
    t.bigint "instance_administration_project_id"
321
322
323
324
325
    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"
326
327
    t.string "static_objects_external_storage_url", limit: 255
    t.string "static_objects_external_storage_auth_token", limit: 255
328
    t.integer "max_personal_access_token_lifetime"
329
    t.boolean "throttle_protected_paths_enabled", default: false, null: false
330
331
    t.integer "throttle_protected_paths_requests_per_period", default: 10, null: false
    t.integer "throttle_protected_paths_period_in_seconds", default: 60, null: false
332
    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", "/admin/session"], array: true
333
334
335
    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
336
    t.string "snowplow_iglu_registry_url", limit: 255
337
    t.integer "push_event_hooks_limit", default: 3, null: false
338
    t.integer "push_event_activities_limit", default: 3, null: false
339
    t.string "custom_http_clone_url_root", limit: 511
340
    t.integer "deletion_adjourned_period", default: 7, null: false
341
    t.date "license_trial_ends_on"
342
343
344
345
346
    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"
347
348
    t.string "snowplow_app_id"
    t.datetime_with_timezone "productivity_analytics_start_date"
349
    t.string "default_ci_config_path", limit: 255
350
351
352
    t.boolean "sourcegraph_enabled", default: false, null: false
    t.string "sourcegraph_url", limit: 255
    t.boolean "sourcegraph_public_only", default: true, null: false
353
    t.bigint "snippet_size_limit", default: 52428800, null: false
354
355
356
357
358
359
360
361
362
363
364
365
    t.text "encrypted_akismet_api_key"
    t.string "encrypted_akismet_api_key_iv", limit: 255
    t.text "encrypted_elasticsearch_aws_secret_access_key"
    t.string "encrypted_elasticsearch_aws_secret_access_key_iv", limit: 255
    t.text "encrypted_recaptcha_private_key"
    t.string "encrypted_recaptcha_private_key_iv", limit: 255
    t.text "encrypted_recaptcha_site_key"
    t.string "encrypted_recaptcha_site_key_iv", limit: 255
    t.text "encrypted_slack_app_secret"
    t.string "encrypted_slack_app_secret_iv", limit: 255
    t.text "encrypted_slack_app_verification_token"
    t.string "encrypted_slack_app_verification_token_iv", limit: 255
366
367
    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"
368
    t.index ["instance_administration_project_id"], name: "index_applicationsettings_on_instance_administration_project_id"
369
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id"
370
371
  end

372
373
374
  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
375
376
    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"
377
378
379
380
381
382
383
384
385
386
  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
387
    t.integer "report_type", limit: 2
388
389
    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"
390
391
392
    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)"
393
394
395
396
397
  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
398
399
    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"
400
401
402
403
404
  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
405
406
    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"
407
408
409
410
411
  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
412
413
    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"
414
415
416
417
418
419
420
421
  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
422
    t.integer "rule_type", limit: 2, default: 0, null: false
423
    t.index ["project_id"], name: "any_approver_project_rule_type_unique_index", unique: true, where: "(rule_type = 3)"
424
425
    t.index ["project_id"], name: "index_approval_project_rules_on_project_id"
    t.index ["rule_type"], name: "index_approval_project_rules_on_rule_type"
426
427
428
429
430
  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
431
432
    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"
433
434
435
436
437
  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
438
439
    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"
440
441
442
443
444
445
446
  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"
447
448
    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
449
450
451
452
453
454
455
456
  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"
457
458
    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"
459
460
461
462
463
464
465
466
  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"
467
468
    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"
469
470
  end

Jasper Maes's avatar
Jasper Maes committed
471
  create_table "audit_events", id: :serial, force: :cascade do |t|
472
473
474
475
476
    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"
477
478
    t.datetime "created_at"
    t.datetime "updated_at"
479
480
    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"
481
482
  end

Jasper Maes's avatar
Jasper Maes committed
483
  create_table "award_emoji", id: :serial, force: :cascade do |t|
484
485
486
487
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
488
489
    t.datetime "created_at"
    t.datetime "updated_at"
490
491
    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"
492
493
  end

494
495
496
497
498
499
500
501
502
  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
503
  create_table "badges", id: :serial, force: :cascade do |t|
504
505
506
507
508
    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
509
    t.string "name", limit: 255
510
511
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
512
513
    t.index ["group_id"], name: "index_badges_on_group_id"
    t.index ["project_id"], name: "index_badges_on_project_id"
514
515
  end

516
517
518
  create_table "board_assignees", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
519
520
    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
521
522
  end

Jasper Maes's avatar
Jasper Maes committed
523
  create_table "board_group_recent_visits", force: :cascade do |t|
524
525
526
527
528
    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"
529
530
531
532
    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"
533
534
  end

535
536
537
  create_table "board_labels", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "label_id", null: false
538
539
    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"
540
541
  end

Jasper Maes's avatar
Jasper Maes committed
542
  create_table "board_project_recent_visits", force: :cascade do |t|
543
544
545
546
547
    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"
548
549
550
551
    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"
552
553
  end

Jasper Maes's avatar
Jasper Maes committed
554
  create_table "boards", id: :serial, force: :cascade do |t|
Felipe Artur's avatar
Felipe Artur committed
555
    t.integer "project_id"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
556
557
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
558
    t.string "name", default: "Development", null: false
559
    t.integer "milestone_id"
560
    t.integer "group_id"
561
    t.integer "weight"
562
563
564
    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"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
565
566
  end

Jasper Maes's avatar
Jasper Maes committed
567
  create_table "broadcast_messages", id: :serial, force: :cascade do |t|
568
    t.text "message", null: false
569
570
571
572
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
573
574
    t.string "color"
    t.string "font"
575
    t.text "message_html", null: false
576
    t.integer "cached_markdown_version"
577
    t.string "target_path", limit: 255
578
    t.index ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id"
579
  end
580

Jasper Maes's avatar
Jasper Maes committed
581
  create_table "chat_names", id: :serial, force: :cascade do |t|
582
583
    t.integer "user_id", null: false
    t.integer "service_id", null: false
584
    t.string "team_id", null: false
585
    t.string "team_domain"
586
    t.string "chat_id", null: false
587
    t.string "chat_name"
588
    t.datetime "last_used_at"
589
590
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
591
592
    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
593
  end
594

Jasper Maes's avatar
Jasper Maes committed
595
  create_table "chat_teams", id: :serial, force: :cascade do |t|
596
    t.integer "namespace_id", null: false
597
598
599
600
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
601
    t.index ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true
Douwe Maan's avatar
Douwe Maan committed
602
603
  end

Kamil Trzciński's avatar
Kamil Trzciński committed
604
605
606
  create_table "ci_build_needs", id: :serial, force: :cascade do |t|
    t.integer "build_id", null: false
    t.text "name", null: false
607
    t.boolean "artifacts", default: true, null: false
Kamil Trzciński's avatar
Kamil Trzciński committed
608
609
610
    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
611
  create_table "ci_build_trace_chunks", force: :cascade do |t|
612
613
614
615
    t.integer "build_id", null: false
    t.integer "chunk_index", null: false
    t.integer "data_store", null: false
    t.binary "raw_data"
616
    t.index ["build_id", "chunk_index"], name: "index_ci_build_trace_chunks_on_build_id_and_chunk_index", unique: true
617
618
  end

Jasper Maes's avatar
Jasper Maes committed
619
  create_table "ci_build_trace_section_names", id: :serial, force: :cascade do |t|
620
621
    t.integer "project_id", null: false
    t.string "name", null: false
622
    t.index ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true
623
624
  end

625
  create_table "ci_build_trace_sections", id: false, force: :cascade do |t|
Alessio Caiazza's avatar
Alessio Caiazza committed
626
    t.integer "project_id", null: false
627
628
    t.datetime "date_start", null: false
    t.datetime "date_end", null: false
629
630
    t.bigint "byte_start", null: false
    t.bigint "byte_end", null: false
631
632
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
633
634
635
    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"
636
637
  end

Jasper Maes's avatar
Jasper Maes committed
638
  create_table "ci_builds", id: :serial, force: :cascade do |t|
639
    t.string "status"
Douwe Maan's avatar
Douwe Maan committed
640
    t.datetime "finished_at"
641
    t.text "trace"
Douwe Maan's avatar
Douwe Maan committed
642
643
644
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
    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"
Kamil Trzciński's avatar
Kamil Trzciński committed
662
    t.integer "project_id"
663
664
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
665
    t.datetime "erased_at"
666
    t.datetime "artifacts_expire_at"
667
    t.string "environment"
668
    t.bigint "artifacts_size"
669
670
    t.string "when"
    t.text "yaml_variables"
671
    t.datetime "queued_at"
672
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
673
    t.integer "lock_version"
674
    t.string "coverage_regex"
675
    t.integer "auto_canceled_by_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
676
    t.boolean "retried"
677
    t.integer "stage_id"
678
679
    t.integer "artifacts_file_store"
    t.integer "artifacts_metadata_store"
680
    t.boolean "protected"
681
    t.integer "failure_reason"
682
    t.datetime_with_timezone "scheduled_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
683
    t.string "token_encrypted"
684
    t.integer "upstream_pipeline_id"
685
686
687
688
689
690
691
692
693
694
    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])))"
695
    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))"
696
697
698
699
700
701
    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"
702
    t.index ["status", "created_at", "project_id"], name: "ci_builds_gitlab_monitor_metrics", where: "((type)::text = 'Ci::Build'::text)"
703
704
705
706
707
708
    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"
Douwe Maan's avatar
Douwe Maan committed
709
710
  end

Jasper Maes's avatar
Jasper Maes committed
711
  create_table "ci_builds_metadata", id: :serial, force: :cascade do |t|
712
    t.integer "build_id", null: false
713
    t.integer "project_id", null: false
714
    t.integer "timeout"
715
    t.integer "timeout_source", default: 1, null: false
716
    t.boolean "interruptible"
717
718
    t.jsonb "config_options"
    t.jsonb "config_variables"
719
    t.boolean "has_exposed_artifacts"
720
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id", unique: true
721
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id_and_has_exposed_artifacts", where: "(has_exposed_artifacts IS TRUE)"
722
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id_and_interruptible", where: "(interruptible = true)"
723
    t.index ["project_id"], name: "index_ci_builds_metadata_on_project_id"
724
725
  end

Jasper Maes's avatar
Jasper Maes committed
726
  create_table "ci_builds_runner_session", force: :cascade do |t|
727
728
729
730
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
731
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true
732
733
  end

Jasper Maes's avatar
Jasper Maes committed
734
  create_table "ci_group_variables", id: :serial, force: :cascade do |t|
735
736
737
738
739
    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
740
741
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
742
743
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
744
    t.boolean "masked", default: false, null: false
745
    t.integer "variable_type", limit: 2, default: 1, null: false
746
    t.index ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true
747
748
  end

Jasper Maes's avatar
Jasper Maes committed
749
  create_table "ci_job_artifacts", id: :serial, force: :cascade do |t|
750
    t.integer "project_id", null: false
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
751
    t.integer "job_id", null: false
752
    t.integer "file_type", null: false
753
    t.bigint "size"
754
755
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
756
    t.datetime_with_timezone "expire_at"
757
    t.string "file"
758
    t.integer "file_store"
759
    t.binary "file_sha256"
760
    t.integer "file_format", limit: 2
761
    t.integer "file_location", limit: 2
762
763
764
765
    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"
766
    t.index ["project_id"], name: "index_ci_job_artifacts_on_project_id_for_security_reports", where: "(file_type = ANY (ARRAY[5, 6, 7, 8]))"
767
768
  end

Matija Čupić's avatar
Matija Čupić committed
769
770
771
772
773
774
775
776
777
778
  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
779
  create_table "ci_pipeline_chat_data", force: :cascade do |t|
780
781
782
    t.integer "pipeline_id", null: false
    t.integer "chat_name_id", null: false
    t.text "response_url", null: false
783
784
    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
785
786
  end

787
  create_table "ci_pipeline_schedule_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
788
789
790
791
792
    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
793
    t.integer "pipeline_schedule_id", null: false
794
795
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
796
    t.integer "variable_type", limit: 2, default: 1, null: false
797
    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
798
799
  end

Jasper Maes's avatar
Jasper Maes committed
800
  create_table "ci_pipeline_schedules", id: :serial, force: :cascade do |t|
801
802
803
804
805
806
807
808
    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
Douwe Maan's avatar
Douwe Maan committed
809
810
    t.datetime "created_at"
    t.datetime "updated_at"
811
812
813
    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"
Douwe Maan's avatar
Douwe Maan committed
814
815
  end

Jasper Maes's avatar
Jasper Maes committed
816
  create_table "ci_pipeline_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
init    
Shinya Maeda committed
817
818
819
820
821
822
    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
823
    t.integer "variable_type", limit: 2, default: 1, null: false
824
    t.index ["pipeline_id", "key"], name: "index_ci_pipeline_variables_on_pipeline_id_and_key", unique: true
825
    t.index ["pipeline_id"], name: "index_ci_pipeline_variables_on_pipeline_id", where: "((key)::text = 'AUTO_DEVOPS_MODSECURITY_SEC_RULE_ENGINE'::text)"
Shinya Maeda's avatar
init    
Shinya Maeda committed
826
827
  end

Jasper Maes's avatar
Jasper Maes committed
828
  create_table "ci_pipelines", id: :serial, force: :cascade do |t|
829
830
831
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
Douwe Maan's avatar
Douwe Maan committed
832
833
    t.datetime "created_at"
    t.datetime "updated_at"
834
835
    t.boolean "tag", default: false
    t.text "yaml_errors"
Douwe Maan's avatar
Douwe Maan committed
836
    t.datetime "committed_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
837
    t.integer "project_id"
838
    t.string "status"
839
840
    t.datetime "started_at"
    t.datetime "finished_at"
841
842
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
843
    t.integer "lock_version"
844
    t.integer "auto_canceled_by_id"
845
    t.integer "pipeline_schedule_id"
846
    t.integer "source"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
847
    t.integer "config_source"
848
    t.boolean "protected"
849
    t.integer "failure_reason"
Shinya Maeda's avatar
Shinya Maeda committed
850
    t.integer "iid"
Shinya Maeda's avatar
Shinya Maeda committed
851
    t.integer "merge_request_id"
852
853
    t.binary "source_sha"
    t.binary "target_sha"
854
    t.bigint "external_pull_request_id"
855
    t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id"
856
    t.index ["external_pull_request_id"], name: "index_ci_pipelines_on_external_pull_request_id", where: "(external_pull_request_id IS NOT NULL)"
857
858
859
860
861
862
863
864
    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"
865
    t.index ["project_id", "status", "updated_at"], name: "index_ci_pipelines_on_project_id_and_status_and_updated_at"
866
867
868
    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"
Douwe Maan's avatar
Douwe Maan committed
869
870
  end

Jasper Maes's avatar
Jasper Maes committed
871
  create_table "ci_runner_namespaces", id: :serial, force: :cascade do |t|
Alexis Reigel's avatar
Alexis Reigel committed
872
    t.integer "runner_id"
873
    t.integer "namespace_id"
874
875
    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
Alexis Reigel's avatar
Alexis Reigel committed
876
877
  end

Jasper Maes's avatar
Jasper Maes committed
878
  create_table "ci_runner_projects", id: :serial, force: :cascade do |t|
879
    t.integer "runner_id", null: false
Douwe Maan's avatar
Douwe Maan committed
880
881
    t.datetime "created_at"
    t.datetime "updated_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
882
    t.integer "project_id"
883
884
    t.index ["project_id"], name: "index_ci_runner_projects_on_project_id"
    t.index ["runner_id"], name: "index_ci_runner_projects_on_runner_id"
Douwe Maan's avatar
Douwe Maan committed
885
886
  end

Jasper Maes's avatar
Jasper Maes committed
887
  create_table "ci_runners", id: :serial, force: :cascade do |t|
888
    t.string "token"
Douwe Maan's avatar
Douwe Maan committed
889
890
    t.datetime "created_at"
    t.datetime "updated_at"
891
    t.string "description"
Douwe Maan's avatar
Douwe Maan committed
892
    t.datetime "contacted_at"
893
894
895
896
897
898
899
900
901
    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
902
    t.integer "access_level", default: 0, null: false
903
    t.string "ip_address"
904
    t.integer "maximum_timeout"
905
    t.integer "runner_type", limit: 2, null: false
906
    t.string "token_encrypted"
907
908
909
910
911
912
    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"
Douwe Maan's avatar
Douwe Maan committed
913
914
  end

915
916
917
918
919
920
  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"
921
922
923
924
925
    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"
926
927
  end

Jasper Maes's avatar
Jasper Maes committed
928
  create_table "ci_stages", id: :serial, force: :cascade do |t|
929
930
    t.integer "project_id"
    t.integer "pipeline_id"
Douwe Maan's avatar
Douwe Maan committed
931
932
    t.datetime "created_at"
    t.datetime "updated_at"
933
    t.string "name"
934
    t.integer "status"
935
    t.integer "lock_version"
936
    t.integer "position"
937
938
939
940
    t.index ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", unique: true
    t.index ["pipeline_id",