Read about our upcoming Code of Conduct on this issue

schema.rb 213 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_09_27_074328) do
14

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

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

29
30
31
32
33
34
35
36
37
  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

38
39
40
41
42
43
44
45
  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

46
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
  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

84
85
86
87
88
89
90
91
92
93
94
95
  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

96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
  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

  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
111
  create_table "appearances", id: :serial, force: :cascade do |t|
112
113
    t.string "title", null: false
    t.text "description", null: false
114
    t.string "logo"
115
116
    t.integer "updated_by"
    t.string "header_logo"
117
118
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
119
    t.text "description_html"
120
    t.integer "cached_markdown_version"
121
122
    t.text "new_project_guidelines"
    t.text "new_project_guidelines_html"
123
124
125
126
127
128
    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"
129
    t.string "favicon"
130
    t.boolean "email_header_and_footer_enabled", default: false, null: false
131
132
  end

Jasper Maes's avatar
Jasper Maes committed
133
  create_table "application_setting_terms", id: :serial, force: :cascade do |t|
134
135
136
137
138
    t.integer "cached_markdown_version"
    t.text "terms", null: false
    t.text "terms_html"
  end

Jasper Maes's avatar
Jasper Maes committed
139
  create_table "application_settings", id: :serial, force: :cascade do |t|
140
141
142
143
    t.integer "default_projects_limit"
    t.boolean "signup_enabled"
    t.boolean "gravatar_enabled"
    t.text "sign_in_text"
144
145
    t.datetime "created_at"
    t.datetime "updated_at"
146
147
    t.string "home_page_url"
    t.integer "default_branch_protection", default: 2
148
    t.text "help_text"
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
    t.text "restricted_visibility_levels"
    t.boolean "version_check_enabled", default: true
    t.integer "max_attachment_size", default: 10, null: false
    t.integer "default_project_visibility"
    t.integer "default_snippet_visibility"
    t.text "domain_whitelist"
    t.boolean "user_oauth_applications", default: true
    t.string "after_sign_out_path"
    t.integer "session_expire_delay", default: 10080, null: false
    t.text "import_sources"
    t.text "help_page_text"
    t.string "admin_notification_email"
    t.boolean "shared_runners_enabled", default: true, null: false
    t.integer "max_artifacts_size", default: 100, null: false
    t.string "runners_registration_token"
164
    t.integer "max_pages_size", default: 100, null: false
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
    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
189
    t.boolean "user_default_external", default: false, null: false
190
191
    t.boolean "elasticsearch_indexing", default: false, null: false
    t.boolean "elasticsearch_search", default: false, null: false
192
    t.string "repository_storages", default: "default"
193
194
195
    t.string "enabled_git_access_protocol"
    t.boolean "domain_blacklist_enabled", default: false
    t.text "domain_blacklist"
196
    t.boolean "usage_ping_enabled", default: true, null: false
197
198
199
200
    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"
201
    t.integer "rsa_key_restriction", default: 0, null: false
202
    t.integer "dsa_key_restriction", default: -1, null: false
203
204
    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
205
206
207
208
209
    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
210
    t.boolean "html_emails_enabled", default: true
211
212
    t.string "plantuml_url"
    t.boolean "plantuml_enabled"
213
214
    t.integer "shared_runners_minutes", default: 0, null: false
    t.bigint "repository_size_limit", default: 0
215
    t.integer "terminal_max_session_time", default: 0, null: false
216
217
218
    t.integer "unique_ips_limit_per_user"
    t.integer "unique_ips_limit_time_window"
    t.boolean "unique_ips_limit_enabled", default: false, null: false
219
    t.string "default_artifacts_expire_in", default: "0", null: false
220
221
222
223
224
225
    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
226
    t.string "uuid"
227
    t.decimal "polling_interval_multiplier", default: "1.0", null: false
228
    t.boolean "elasticsearch_experimental_indexer"
229
    t.integer "cached_markdown_version"
230
231
232
233
    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
234
    t.boolean "prometheus_metrics_enabled", default: true, null: false
235
    t.boolean "authorized_keys_enabled", default: true, null: false
236
237
    t.boolean "help_page_hide_commercial_content", default: false
    t.string "help_page_support_url"
238
239
240
241
    t.boolean "slack_app_enabled", default: false
    t.string "slack_app_id"
    t.string "slack_app_secret"
    t.string "slack_app_verification_token"
242
    t.integer "performance_bar_allowed_group_id"
243
    t.boolean "allow_group_owners_to_manage_ldap", default: true, null: false
244
    t.boolean "hashed_storage_enabled", default: true, null: false
245
    t.boolean "project_export_enabled", default: true, null: false
246
    t.boolean "auto_devops_enabled", default: true, null: false
247
248
249
250
251
252
253
254
255
    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
256
257
258
    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
259
260
261
    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
262
    t.string "auto_devops_domain"
263
264
265
    t.boolean "external_authorization_service_enabled", default: false, null: false
    t.string "external_authorization_service_url"
    t.string "external_authorization_service_default_label"
266
    t.boolean "pages_domain_verification_enabled", default: true, null: false
267
    t.string "user_default_internal_regex"
268
269
270
271
272
273
274
    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"
275
    t.boolean "enforce_terms", default: false
276
277
    t.integer "file_template_project_id"
    t.boolean "pseudonymizer_enabled", default: false, null: false
278
    t.boolean "hide_third_party_offers", default: false, null: false
279
    t.boolean "snowplow_enabled", default: false, null: false
280
    t.string "snowplow_collector_hostname"
281
282
    t.string "snowplow_site_id"
    t.string "snowplow_cookie_domain"
283
    t.boolean "instance_statistics_visibility_private", default: false, null: false
Phil Hughes's avatar
Phil Hughes committed
284
    t.boolean "web_ide_clientside_preview_enabled", default: false, null: false
285
    t.boolean "user_show_add_ssh_key_message", default: true, null: false
286
    t.integer "custom_project_templates_group_id"
287
    t.integer "usage_stats_set_by_user_id"
288
    t.integer "receive_max_input_size"
289
    t.integer "diff_max_patch_bytes", default: 102400, null: false
290
    t.integer "archive_builds_in_seconds"
291
    t.string "commit_email_hostname"
292
    t.boolean "protected_ci_variables", default: false, null: false
293
    t.string "runners_registration_token_encrypted"
Jan Provaznik's avatar
Jan Provaznik committed
294
    t.integer "local_markdown_version", default: 0, null: false
295
    t.integer "first_day_of_week", default: 0, null: false
296
    t.boolean "elasticsearch_limit_indexing", default: false, null: false
Gosia Ksionek's avatar
Gosia Ksionek committed
297
    t.integer "default_project_creation", default: 2, null: false
298
299
    t.string "lets_encrypt_notification_email"
    t.boolean "lets_encrypt_terms_of_service_accepted", default: false, null: false
300
    t.string "geo_node_allowed_ips", default: "0.0.0.0/0, ::/0"
301
302
    t.integer "elasticsearch_shards", default: 5, null: false
    t.integer "elasticsearch_replicas", default: 1, null: false
303
304
    t.text "encrypted_lets_encrypt_private_key"
    t.text "encrypted_lets_encrypt_private_key_iv"
Matija Čupić's avatar
Matija Čupić committed
305
    t.string "required_instance_ci_template"
306
    t.boolean "dns_rebinding_protection_enabled", default: true, null: false
Małgorzata Ksionek's avatar
Małgorzata Ksionek committed
307
    t.boolean "default_project_deletion_protection", default: false, null: false
308
    t.boolean "grafana_enabled", default: false, null: false
309
    t.boolean "lock_memberships_to_ldap", default: false, null: false
310
    t.boolean "time_tracking_limit_to_hours", default: false, null: false
311
    t.string "grafana_url", default: "/-/grafana", null: false
312
    t.boolean "login_recaptcha_protection_enabled", default: false, null: false
313
    t.string "outbound_local_requests_whitelist", limit: 255, default: [], null: false, array: true
314
    t.integer "raw_blob_request_limit", default: 300, null: false
315
    t.boolean "allow_local_requests_from_web_hooks_and_services", default: false, null: false
316
    t.boolean "allow_local_requests_from_system_hooks", default: true, null: false
317
    t.bigint "instance_administration_project_id"
318
319
320
321
322
    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"
323
324
    t.string "static_objects_external_storage_url", limit: 255
    t.string "static_objects_external_storage_auth_token", limit: 255
325
326
327
328
    t.boolean "throttle_protected_paths_enabled", default: true, null: false
    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
329
330
    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"
331
    t.index ["instance_administration_project_id"], name: "index_applicationsettings_on_instance_administration_project_id"
332
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id"
333
334
  end

335
336
337
  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
338
339
    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"
340
341
342
343
344
345
346
347
348
349
  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
350
    t.integer "report_type", limit: 2
351
352
    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"
353
354
355
    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)"
356
357
358
359
360
  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
361
362
    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"
363
364
365
366
367
  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
368
369
    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"
370
371
372
373
374
  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
375
376
    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"
377
378
379
380
381
382
383
384
  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
385
    t.integer "rule_type", limit: 2, default: 0, null: false
386
    t.index ["project_id"], name: "any_approver_project_rule_type_unique_index", unique: true, where: "(rule_type = 3)"
387
388
    t.index ["project_id"], name: "index_approval_project_rules_on_project_id"
    t.index ["rule_type"], name: "index_approval_project_rules_on_rule_type"
389
390
391
392
393
  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
394
395
    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"
396
397
398
399
400
  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
401
402
    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"
403
404
405
406
407
408
409
  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"
410
411
    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
412
413
414
415
416
417
418
419
  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"
420
421
    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"
422
423
424
425
426
427
428
429
  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"
430
431
    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"
432
433
  end

Jasper Maes's avatar
Jasper Maes committed
434
  create_table "audit_events", id: :serial, force: :cascade do |t|
435
436
437
438
439
    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"
440
441
    t.datetime "created_at"
    t.datetime "updated_at"
442
443
    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"
444
445
  end

Jasper Maes's avatar
Jasper Maes committed
446
  create_table "award_emoji", id: :serial, force: :cascade do |t|
447
448
449
450
    t.string "name"
    t.integer "user_id"
    t.integer "awardable_id"
    t.string "awardable_type"
451
452
    t.datetime "created_at"
    t.datetime "updated_at"
453
454
    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"
455
456
  end

Jasper Maes's avatar
Jasper Maes committed
457
  create_table "badges", id: :serial, force: :cascade do |t|
458
459
460
461
462
463
464
    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
465
466
    t.index ["group_id"], name: "index_badges_on_group_id"
    t.index ["project_id"], name: "index_badges_on_project_id"
467
468
  end

469
470
471
  create_table "board_assignees", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
472
473
    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
474
475
  end

Jasper Maes's avatar
Jasper Maes committed
476
  create_table "board_group_recent_visits", force: :cascade do |t|
477
478
479
480
481
    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"
482
483
484
485
    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"
486
487
  end

488
489
490
  create_table "board_labels", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "label_id", null: false
491
492
    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"
493
494
  end

Jasper Maes's avatar
Jasper Maes committed
495
  create_table "board_project_recent_visits", force: :cascade do |t|
496
497
498
499
500
    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"
501
502
503
504
    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"
505
506
  end

Jasper Maes's avatar
Jasper Maes committed
507
  create_table "boards", id: :serial, force: :cascade do |t|
Felipe Artur's avatar
Felipe Artur committed
508
    t.integer "project_id"
Douglas Barbosa Alexandre's avatar
Douglas Barbosa Alexandre committed
509
510
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
511
    t.string "name", default: "Development", null: false
512
    t.integer "milestone_id"
513
    t.integer "group_id"
514
    t.integer "weight"
515
516
517
    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
518
519
  end

Jasper Maes's avatar
Jasper Maes committed
520
  create_table "broadcast_messages", id: :serial, force: :cascade do |t|
521
    t.text "message", null: false
522
523
524
525
    t.datetime "starts_at", null: false
    t.datetime "ends_at", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
526
527
    t.string "color"
    t.string "font"
528
    t.text "message_html", null: false
529
    t.integer "cached_markdown_version"
530
    t.index ["starts_at", "ends_at", "id"], name: "index_broadcast_messages_on_starts_at_and_ends_at_and_id"
531
  end
532

Jasper Maes's avatar
Jasper Maes committed
533
  create_table "chat_names", id: :serial, force: :cascade do |t|
534
535
    t.integer "user_id", null: false
    t.integer "service_id", null: false
536
    t.string "team_id", null: false
537
    t.string "team_domain"
538
    t.string "chat_id", null: false
539
    t.string "chat_name"
540
    t.datetime "last_used_at"
541
542
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
543
544
    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
545
  end
546

Jasper Maes's avatar
Jasper Maes committed
547
  create_table "chat_teams", id: :serial, force: :cascade do |t|
548
    t.integer "namespace_id", null: false
549
550
551
552
    t.string "team_id"
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
553
    t.index ["namespace_id"], name: "index_chat_teams_on_namespace_id", unique: true
Douwe Maan's avatar
Douwe Maan committed
554
555
  end

Kamil Trzciński's avatar
Kamil Trzciński committed
556
557
558
559
560
561
  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
562
  create_table "ci_build_trace_chunks", force: :cascade do |t|
563
564
565
566
    t.integer "build_id", null: false
    t.integer "chunk_index", null: false
    t.integer "data_store", null: false
    t.binary "raw_data"
567
    t.index ["build_id", "chunk_index"], name: "index_ci_build_trace_chunks_on_build_id_and_chunk_index", unique: true
568
569
  end

Jasper Maes's avatar
Jasper Maes committed
570
  create_table "ci_build_trace_section_names", id: :serial, force: :cascade do |t|
571
572
    t.integer "project_id", null: false
    t.string "name", null: false
573
    t.index ["project_id", "name"], name: "index_ci_build_trace_section_names_on_project_id_and_name", unique: true
574
575
  end

Jasper Maes's avatar
Jasper Maes committed
576
  create_table "ci_build_trace_sections", id: :serial, force: :cascade do |t|
Alessio Caiazza's avatar
Alessio Caiazza committed
577
    t.integer "project_id", null: false
578
579
    t.datetime "date_start", null: false
    t.datetime "date_end", null: false
580
581
    t.bigint "byte_start", null: false
    t.bigint "byte_end", null: false
582
583
    t.integer "build_id", null: false
    t.integer "section_name_id", null: false
584
585
586
    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"
587
588
  end

Jasper Maes's avatar
Jasper Maes committed
589
  create_table "ci_builds", id: :serial, force: :cascade do |t|
590
    t.string "status"
Douwe Maan's avatar
Douwe Maan committed
591
    t.datetime "finished_at"
592
    t.text "trace"
Douwe Maan's avatar
Douwe Maan committed
593
594
595
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
    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
613
    t.integer "project_id"
614
615
    t.text "artifacts_metadata"
    t.integer "erased_by_id"
616
    t.datetime "erased_at"
617
    t.datetime "artifacts_expire_at"
618
    t.string "environment"
619
    t.bigint "artifacts_size"
620
621
    t.string "when"
    t.text "yaml_variables"
622
    t.datetime "queued_at"
623
    t.string "token"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
624
    t.integer "lock_version"
625
    t.string "coverage_regex"
626
    t.integer "auto_canceled_by_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
627
    t.boolean "retried"
628
    t.integer "stage_id"
629
630
    t.integer "artifacts_file_store"
    t.integer "artifacts_metadata_store"
631
    t.boolean "protected"
632
    t.integer "failure_reason"
633
    t.datetime_with_timezone "scheduled_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
634
    t.string "token_encrypted"
635
    t.integer "upstream_pipeline_id"
636
637
638
639
640
641
642
643
644
645
    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])))"
646
    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))"
647
648
649
650
651
652
    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"
653
    t.index ["status", "created_at", "project_id"], name: "ci_builds_gitlab_monitor_metrics", where: "((type)::text = 'Ci::Build'::text)"
654
655
656
657
658
659
    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
660
661
  end

Jasper Maes's avatar
Jasper Maes committed
662
  create_table "ci_builds_metadata", id: :serial, force: :cascade do |t|
663
    t.integer "build_id", null: false
664
    t.integer "project_id", null: false
665
    t.integer "timeout"
666
    t.integer "timeout_source", default: 1, null: false
667
    t.boolean "interruptible"
668
669
    t.jsonb "config_options"
    t.jsonb "config_variables"
670
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id", unique: true
671
    t.index ["build_id"], name: "index_ci_builds_metadata_on_build_id_and_interruptible", where: "(interruptible = true)"
672
    t.index ["project_id"], name: "index_ci_builds_metadata_on_project_id"
673
674
  end

Jasper Maes's avatar
Jasper Maes committed
675
  create_table "ci_builds_runner_session", force: :cascade do |t|
676
677
678
679
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
680
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true
681
682
  end

Jasper Maes's avatar
Jasper Maes committed
683
  create_table "ci_group_variables", id: :serial, force: :cascade do |t|
684
685
686
687
688
    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
689
690
    t.integer "group_id", null: false
    t.boolean "protected", default: false, null: false
691
692
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
693
    t.boolean "masked", default: false, null: false
694
    t.integer "variable_type", limit: 2, default: 1, null: false
695
    t.index ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true
696
697
  end

Jasper Maes's avatar
Jasper Maes committed
698
  create_table "ci_job_artifacts", id: :serial, force: :cascade do |t|
699
    t.integer "project_id", null: false
Zeger-Jan van de Weg's avatar
Zeger-Jan van de Weg committed
700
    t.integer "job_id", null: false
701
    t.integer "file_type", null: false
702
    t.bigint "size"
703
704
    t.datetime_with_timezone "created_at", null: false
    t.datetime_with_timezone "updated_at", null: false
705
    t.datetime_with_timezone "expire_at"
706
    t.string "file"
707
    t.integer "file_store"
708
    t.binary "file_sha256"
709
    t.integer "file_format", limit: 2
710
    t.integer "file_location", limit: 2
711
712
713
714
    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"
715
    t.index ["project_id"], name: "index_ci_job_artifacts_on_project_id_for_security_reports", where: "(file_type = ANY (ARRAY[5, 6, 7, 8]))"
716
717
  end

Matija Čupić's avatar
Matija Čupić committed
718
719
720
721
722
723
724
725
726
727
  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
728
  create_table "ci_pipeline_chat_data", force: :cascade do |t|
729
730
731
    t.integer "pipeline_id", null: false
    t.integer "chat_name_id", null: false
    t.text "response_url", null: false
732
733
    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
734
735
  end

736
  create_table "ci_pipeline_schedule_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
737
738
739
740
741
    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
742
    t.integer "pipeline_schedule_id", null: false
743
744
    t.datetime_with_timezone "created_at"
    t.datetime_with_timezone "updated_at"
745
    t.integer "variable_type", limit: 2, default: 1, null: false
746
    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
747
748
  end

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

Jasper Maes's avatar
Jasper Maes committed
765
  create_table "ci_pipeline_variables", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
init    
Shinya Maeda committed
766
767
768
769
770
771
    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
772
    t.integer "variable_type", limit: 2, default: 1, null: false
773
    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
774
775
  end

Jasper Maes's avatar
Jasper Maes committed
776
  create_table "ci_pipelines", id: :serial, force: :cascade do |t|
777
778
779
    t.string "ref"
    t.string "sha"
    t.string "before_sha"
Douwe Maan's avatar
Douwe Maan committed
780
781
    t.datetime "created_at"
    t.datetime "updated_at"
782
783
    t.boolean "tag", default: false
    t.text "yaml_errors"
Douwe Maan's avatar
Douwe Maan committed
784
    t.datetime "committed_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
785
    t.integer "project_id"
786
    t.string "status"
787
788
    t.datetime "started_at"
    t.datetime "finished_at"
789
790
    t.integer "duration"
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
791
    t.integer "lock_version"
792
    t.integer "auto_canceled_by_id"
793
    t.integer "pipeline_schedule_id"
794
    t.integer "source"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
795
    t.integer "config_source"
796
    t.boolean "protected"
797
    t.integer "failure_reason"
Shinya Maeda's avatar
Shinya Maeda committed
798
    t.integer "iid"
Shinya Maeda's avatar
Shinya Maeda committed
799
    t.integer "merge_request_id"
800
801
    t.binary "source_sha"
    t.binary "target_sha"
802
    t.bigint "external_pull_request_id"
803
    t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id"
804
    t.index ["external_pull_request_id"], name: "index_ci_pipelines_on_external_pull_request_id", where: "(external_pull_request_id IS NOT NULL)"
805
806
807
808
809
810
811
812
813
814
815
    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"
Douwe Maan's avatar
Douwe Maan committed
816
817
  end

Jasper Maes's avatar
Jasper Maes committed
818
  create_table "ci_runner_namespaces", id: :serial, force: :cascade do |t|
Alexis Reigel's avatar
Alexis Reigel committed
819
    t.integer "runner_id"
820
    t.integer "namespace_id"
821
822
    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
823
824
  end

Jasper Maes's avatar
Jasper Maes committed
825
  create_table "ci_runner_projects", id: :serial, force: :cascade do |t|
826
    t.integer "runner_id", null: false
Douwe Maan's avatar
Douwe Maan committed
827
828
    t.datetime "created_at"
    t.datetime "updated_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
829
    t.integer "project_id"
830
831
    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
832
833
  end

Jasper Maes's avatar
Jasper Maes committed
834
  create_table "ci_runners", id: :serial, force: :cascade do |t|
835
    t.string "token"
Douwe Maan's avatar
Douwe Maan committed
836
837
    t.datetime "created_at"
    t.datetime "updated_at"
838
    t.string "description"
Douwe Maan's avatar
Douwe Maan committed
839
    t.datetime "contacted_at"
840
841
842
843
844
845
846
847
848
    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
849
    t.integer "access_level", default: 0, null: false
850
    t.string "ip_address"
851
    t.integer "maximum_timeout"
852
    t.integer "runner_type", limit: 2, null: false
853
    t.string "token_encrypted"
854
855
856
857
858
859
    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
860
861
  end

862
863
864
865
866
867
  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"
868
869
870
871
872
    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"
873
874
  end

Jasper Maes's avatar
Jasper Maes committed
875
  create_table "ci_stages", id: :serial, force: :cascade do |t|
876
877
    t.integer "project_id"
    t.integer "pipeline_id"
Douwe Maan's avatar
Douwe Maan committed
878
879
    t.datetime "created_at"
    t.datetime "updated_at"
880
    t.string "name"
881
    t.integer "status"
882
    t.integer "lock_version"
883
    t.integer "position"
884
885
886
887
    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"
Douwe Maan's avatar
Douwe Maan committed
888
889
  end

Jasper Maes's avatar
Jasper Maes committed
890
  create_table "ci_trigger_requests", id: :serial, force: :cascade do |t|
891
892
    t.integer "trigger_id", null: false
    t.text "variables"
Douwe Maan's avatar
Douwe Maan committed
893
894
    t.datetime "created_at"
    t.datetime "updated_at"
895
    t.integer "commit_id"
896
897
    t.index ["commit_id"], name: "index_ci_trigger_requests_on_commit_id"
    t.index ["trigger_id"], name: "index_ci_trigger_requests_on_trigger_id"
Douwe Maan's avatar
Douwe Maan committed
898
899
  end

Jasper Maes's avatar
Jasper Maes committed
900
  create_table "ci_triggers", id: :serial, force: :cascade do |t|
901
    t.string "token"
Douwe Maan's avatar
Douwe Maan committed
902
903
    t.datetime "created_at"
    t.datetime "updated_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
904
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
905
906
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
907
    t.string "ref"
908
909
    t.index ["owner_id"], name: "index_ci_triggers_on_owner_id"
    t.index ["project_id"], name: "index_ci_triggers_on_project_id"
Douwe Maan's avatar
Douwe Maan committed
910
911
  end

Jasper Maes's avatar
Jasper Maes committed
912
  create_table "ci_variables", id: :serial, force: :cascade do |t|
913
    t.string "key", null: false
914
915
916
917
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
918
    t.integer "project_id", null: false
919
    t.boolean "protected", default: false, null: false
920
    t.string "environment_scope", default: "*", null: false
921
    t.boolean "masked", default: false, null: false
922
    t.integer "variable_type", limit: 2, default: 1, null: false
923
    t.index ["project_id", "key", "environment_scope"], name: "index_ci_variables_on_project_id_and_key_and_environment_scope", unique: true
Douwe Maan's avatar
Douwe Maan committed
924
925
  end

Jasper Maes's avatar
Jasper Maes committed
926
  create_table "cluster_groups", id: :serial, force: :cascade do |t|
927
928
    t.integer "cluster_id", null: false
    t.integer "group_id", null: false
929
930
    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"
931
932
  end

Jasper Maes's avatar
Jasper Maes committed
933
  create_table "cluster_platforms_kubernetes", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
934
    t.integer "cluster_id", null: false
935
936
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
937
    t.text "api_url"
Shinya Maeda's avatar
Shinya Maeda committed
938
939
940
941
942
943
944
    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"
945
    t.integer "authorization_type", limit: 2
946
    t.index ["cluster_id"], name: "index_cluster_platforms_kubernetes_on_cluster_id", unique: true
Shinya Maeda's avatar
Shinya Maeda committed
947
948
  end

Jasper Maes's avatar
Jasper Maes committed
949
  create_table "cluster_projects", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
950
951
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
952
953
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
954
955
    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
956
957
  end

Jasper Maes's avatar
Jasper Maes committed
958
  create_table "cluster_providers_gcp", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
959
960
    t.integer "cluster_id", null: false
    t.integer "status"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
961
    t.integer "num_nodes", null: false
962
963
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Shinya Maeda's avatar
Shinya Maeda committed
964
965
966
967
968
969
970
971
    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"
972
    t.boolean "legacy_abac", default: false, null: false
973
974
    t.boolean "cloud_run", default: false, null: false
    t.index ["cloud_run"], name: "index_cluster_providers_gcp_on_cloud_run"
975
    t.index ["cluster_id"], name: "index_cluster_providers_gcp_on_cluster_id", unique: true
Shinya Maeda's avatar
Shinya Maeda committed
976
977
  end

Jasper Maes's avatar
Jasper Maes committed
978
  create_table "clusters", id: :serial, force: :cascade do |t|
979
    t.integer "user_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
980
981
    t.integer "provider_type"
    t.integer "platform_type"
982
983
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
984
985
    t.boolean "enabled", default: true
    t.string "name", null: false
986
    t.string "environment_scope", default: "*", null: false
987
    t.integer "cluster_type", limit: 2, default: 3, null: false
988
    t.string "domain"
989
    t.boolean "managed", default: true, null: false
990
    t.boolean "namespace_per_environment", default: true, null: false
991
992
    t.index ["enabled"], name: "index_clusters_on_enabled"
    t.index ["user_id"], name: "index_clusters_on_user_id"
Amit Rathi's avatar
Amit Rathi committed
993
994
  end

Jasper Maes's avatar
Jasper Maes committed
995
  create_table "clusters_applications_cert_managers", id: :serial, force: :cascade do |t|
996
997
998
999
1000
1001
1002
    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"
1003
    t.index ["cluster_id"], name: "index_clusters_applications_cert_managers_on_cluster_id", unique: true
1004
1005
  end

Jasper Maes's avatar
Jasper Maes committed
1006
  create_table "clusters_applications_helm", id: :serial, force: :cascade do |t|
1007
    t.integer "cluster_id", null: false
1008
1009
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
1010
1011
1012
    t.integer "status", null: false
    t.string "version", null: false
    t.text "status_reason"
1013
1014
1015
    t.text "encrypted_ca_key"
    t.text "encrypted_ca_key_iv"
    t.text "ca_cert"
1016
    t.index ["cluster_id"], name: "index_clusters_applications_helm_on_cluster_id", unique: true
1017
  end
1018

Jasper Maes's avatar
Jasper Maes committed
1019
  create_table "clusters_applications_ingress", id: :serial, force: :cascade do |t|
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1020
    t.integer "cluster_id", null: false
1021
1022
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1023
1024
1025
1026
1027
    t.integer "status", null: false
    t.integer "ingress_type", null: false
    t.string "version", null: false
    t.string "cluster_ip"
    t.text "status_reason"
1028
    t.string "external_ip"
1029
    t.string "external_hostname"
1030
    t.index ["cluster_id"], name: "index_clusters_applications_ingress_on_cluster_id", unique: true
Kamil Trzcinski's avatar
Kamil Trzcinski committed
1031
1032
  end

Jasper Maes's avatar
Jasper Maes committed
1033
  create_table "clusters_applications_jupyter", id: :serial, force: :cascade do |t|
1034
    t.integer "cluster_id", null: false
1035
    t.integer "oauth_application_id"
1036
1037
1038
1039
1040
    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
1041
    t.text "status_reason"
1042
1043
    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"
1044
1045
  end

Jasper Maes's avatar
Jasper Maes committed
1046
  create_table "clusters_applications_knative", id: :serial, force: :cascade do |t|
Chris Baumbauer's avatar
Chris Baumbauer committed
1047
1048
1049
1050
1051
    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
1052
    t.string "hostname"
Chris Baumbauer's avatar
Chris Baumbauer committed
1053
    t.text "status_reason"
1054
    t.string "external_ip"
1055
    t.string "external_hostname"
1056
    t.index ["cluster_id"], name: "index_clusters_applications_knative_on_cluster_id", unique: true
Chris Baumbauer's avatar
Chris Baumbauer committed
1057
1058
  end

Jasper Maes's avatar
Jasper Maes committed
1059
  create_table "clusters_applications_prometheus", id: :serial, force: :cascade do |t|
1060
1061
1062
1063
1064
1065
    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
1066
    t.datetime_with_timezone "last_update_started_at"
1067
1068
    t.string "encrypted_alert_manager_token"
    t.string "encrypted_alert_manager_token_iv"
1069
    t.index ["cluster_id"], name: "index_clusters_applications_prometheus_on_cluster_id", unique: true
1070
1071
  end

Jasper Maes's avatar
Jasper Maes committed
1072
  create_table "clusters_applications_runners", id: :serial, force: :cascade do |t|
1073
1074
1075
1076
1077
1078
1079
    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"
1080
    t.boolean "privileged", default: true, null: false
1081
1082
    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"
1083
1084
  end

Jasper Maes's avatar
Jasper Maes committed
1085
  create_table "clusters_kubernetes_namespaces", force: :cascade do |t|
1086
1087
1088
1089
1090
1091
1092
1093
1094
    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"
1095
    t.bigint "environment_id"
1096
    t.index ["cluster_id", "namespace"], name: "kubernetes_namespaces_cluster_and_namespace", unique: true
1097
    t.index ["cluster_id", "project_id", "environment_id"], name: "index_kubernetes_namespaces_on_cluster_project_environment_id", unique: true