Read about our upcoming Code of Conduct on this issue

schema.rb 211 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_19_162036) 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
    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"
327
    t.index ["instance_administration_project_id"], name: "index_applicationsettings_on_instance_administration_project_id"
328
    t.index ["usage_stats_set_by_user_id"], name: "index_application_settings_on_usage_stats_set_by_user_id"
329
330
  end

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

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

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

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

465
466
467
  create_table "board_assignees", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "assignee_id", null: false
468
469
    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
470
471
  end

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

484
485
486
  create_table "board_labels", id: :serial, force: :cascade do |t|
    t.integer "board_id", null: false
    t.integer "label_id", null: false
487
488
    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"
489
490
  end

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

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

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

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

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

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

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

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

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

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

Jasper Maes's avatar
Jasper Maes committed
670
  create_table "ci_builds_runner_session", force: :cascade do |t|
671
672
673
674
    t.integer "build_id", null: false
    t.string "url", null: false
    t.string "certificate"
    t.string "authorization"
675
    t.index ["build_id"], name: "index_ci_builds_runner_session_on_build_id", unique: true
676
677
  end

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

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

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

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

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

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

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

Jasper Maes's avatar
Jasper Maes committed
813
  create_table "ci_runner_namespaces", id: :serial, force: :cascade do |t|
Alexis Reigel's avatar
Alexis Reigel committed
814
    t.integer "runner_id"
815
    t.integer "namespace_id"
816
817
    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
818
819
  end

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

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

857
858
859
860
861
862
  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"
863
864
865
866
867
    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"
868
869
  end

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

Jasper Maes's avatar
Jasper Maes committed
885
  create_table "ci_trigger_requests", id: :serial, force: :cascade do |t|
886
887
    t.integer "trigger_id", null: false
    t.text "variables"
Douwe Maan's avatar
Douwe Maan committed
888
889
    t.datetime "created_at"
    t.datetime "updated_at"
890
    t.integer "commit_id"
891
892
    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
893
894
  end

Jasper Maes's avatar
Jasper Maes committed
895
  create_table "ci_triggers", id: :serial, force: :cascade do |t|
896
    t.string "token"
Douwe Maan's avatar
Douwe Maan committed
897
898
    t.datetime "created_at"
    t.datetime "updated_at"
Kamil Trzciński's avatar
Kamil Trzciński committed
899
    t.integer "project_id"
Kamil Trzcinski's avatar
Kamil Trzcinski committed
900
901
    t.integer "owner_id"
    t.string "description"
Shinya Maeda's avatar
Shinya Maeda committed
902
    t.string "ref"
903
904
    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
905
906
  end

Jasper Maes's avatar
Jasper Maes committed
907
  create_table "ci_variables", id: :serial, force: :cascade do |t|
908
    t.string "key", null: false
909
910
911
912
    t.text "value"
    t.text "encrypted_value"
    t.string "encrypted_value_salt"
    t.string "encrypted_value_iv"
913
    t.integer "project_id", null: false
914
    t.boolean "protected", default: false, null: false
915
    t.string "environment_scope", default: "*", null: false
916
    t.boolean "masked", default: false, null: false
917
    t.integer "variable_type", limit: 2, default: 1, null: false
918
    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
919
920
  end

Jasper Maes's avatar
Jasper Maes committed
921
  create_table "cluster_groups", id: :serial, force: :cascade do |t|
922
923
    t.integer "cluster_id", null: false
    t.integer "group_id", null: false
924
925
    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"
926
927
  end

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

Jasper Maes's avatar
Jasper Maes committed
944
  create_table "cluster_projects", id: :serial, force: :cascade do |t|
Shinya Maeda's avatar
Shinya Maeda committed
945
946
    t.integer "project_id", null: false
    t.integer "cluster_id", null: false
947
948
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
949
950
    t.index ["cluster_id"], name: "index_cluster_projects_on_cluster_id"
    t.index ["project_id"], name: "index_cluster_projects_on_project_id"