Gitlab::Schema::Validation::Validators::ExtraTables |
Table |
wal_file_size |
wal_file_size |
|
CREATE TABLE wal_file_size (?column? integer NOT NULL) |
Gitlab::Schema::Validation::Validators::ExtraTables |
Table |
personal_access_tokens_restored_from_backup |
personal_access_tokens_restored_from_backup |
|
CREATE TABLE personal_access_tokens_restored_from_backup (id integer, user_id integer, name character varying, revoked boolean, expires_at date, created_at timestamp without time zone, updated_at timestamp without time zone, scopes character varying, impersonation boolean, token_digest character varying, expire_notification_delivered boolean, last_used_at timestamp with time zone, after_expiry_notification_delivered boolean, previous_personal_access_token_id bigint) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
index_boards_epic_board_recent_visits_on_user_id |
boards_epic_board_recent_visits |
|
CREATE INDEX index_boards_epic_board_recent_visits_on_user_id ON public.boards_epic_board_recent_visits USING btree (user_id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
index_e4a5307529 |
ci_builds |
|
CREATE INDEX index_e4a5307529 ON public.ci_builds USING btree (project_id, id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
index_c2e24a89ff |
ci_builds |
|
CREATE INDEX index_c2e24a89ff ON public.ci_builds USING btree (runner_id, id DESC) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
index_ci_job_artifacts_on_project_id |
ci_job_artifacts |
|
CREATE INDEX index_ci_job_artifacts_on_project_id ON public.ci_job_artifacts USING btree (project_id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
idx_p_catalog_resource_component_usages_on_catalog_resource_id |
p_catalog_resource_component_usages |
|
CREATE INDEX idx_p_catalog_resource_component_usages_on_catalog_resource_id ON ONLY public.p_catalog_resource_component_usages USING btree (catalog_resource_id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_builds_stage_id_convert_to_bigint_idx |
p_ci_builds |
|
CREATE INDEX p_ci_builds_stage_id_convert_to_bigint_idx ON ONLY public.p_ci_builds USING btree (stage_id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_builds_metadata_build_id_convert_to_bigint_idx |
p_ci_builds_metadata |
|
CREATE INDEX p_ci_builds_metadata_build_id_convert_to_bigint_idx ON ONLY public.p_ci_builds_metadata USING btree (build_id) WHERE has_exposed_artifacts IS TRUE |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_builds_metadata_build_id_convert_to_bigint_id_convert__idx |
p_ci_builds_metadata |
|
CREATE INDEX p_ci_builds_metadata_build_id_convert_to_bigint_id_convert__idx ON ONLY public.p_ci_builds_metadata USING btree (build_id) INCLUDE (id) WHERE interruptible = true |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_stages_pipeline_id_convert_to_bigint_idx |
p_ci_stages |
|
CREATE INDEX p_ci_stages_pipeline_id_convert_to_bigint_idx ON ONLY public.p_ci_stages USING btree (pipeline_id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_stages_pipeline_id_convert_to_bigint_id_idx |
p_ci_stages |
|
CREATE INDEX p_ci_stages_pipeline_id_convert_to_bigint_id_idx ON ONLY public.p_ci_stages USING btree (pipeline_id, id) WHERE status = ANY(ARRAY[0, 1, 2, 8, 9, 10]) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
p_ci_stages_pipeline_id_convert_to_bigint_position_idx |
p_ci_stages |
|
CREATE INDEX p_ci_stages_pipeline_id_convert_to_bigint_position_idx ON ONLY public.p_ci_stages USING btree (pipeline_id, "position") |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
personal_access_tokens_restored_from_backup_id_idx |
personal_access_tokens_restored_from_backup |
|
CREATE INDEX personal_access_tokens_restored_from_backup_id_idx ON public.personal_access_tokens_restored_from_backup USING btree (id) |
Gitlab::Schema::Validation::Validators::ExtraIndexes |
Index |
index_vulnerability_occurrences_prim_iden_id_and_vuln_id |
vulnerability_occurrences |
|
CREATE INDEX index_vulnerability_occurrences_prim_iden_id_and_vuln_id ON public.vulnerability_occurrences USING btree (primary_identifier_id, vulnerability_id) |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_builds |
ci_builds |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_builds BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_builds EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipelines |
ci_pipelines |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipelines BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipelines EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_runner_projects |
ci_runner_projects |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_runner_projects BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_runner_projects EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_runners |
ci_runners |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_runners BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_runners EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_trigger_requests |
ci_trigger_requests |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_trigger_requests BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_trigger_requests EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_triggers |
ci_triggers |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_triggers BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_triggers EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_variables |
ci_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_taggings |
taggings |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_taggings BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.taggings EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_tags |
tags |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_tags BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.tags EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_schedules |
ci_pipeline_schedules |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_schedules BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_schedules EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_stages |
ci_stages |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_stages BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_stages EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_sources_pipelines |
ci_sources_pipelines |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_sources_pipelines BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_sources_pipelines EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_group_variables |
ci_group_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_group_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_group_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_schedule_variables |
ci_pipeline_schedule_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_schedule_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_schedule_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_variables |
ci_pipeline_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_job_artifacts |
ci_job_artifacts |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_job_artifacts BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_job_artifacts EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_chat_data |
ci_pipeline_chat_data |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_chat_data BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_chat_data EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_builds_metadata |
ci_builds_metadata |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_builds_metadata BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_builds_metadata EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_runner_namespaces |
ci_runner_namespaces |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_runner_namespaces BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_runner_namespaces EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_build_trace_chunks |
ci_build_trace_chunks |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_build_trace_chunks BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_build_trace_chunks EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_builds_runner_session |
ci_builds_runner_session |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_builds_runner_session BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_builds_runner_session EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_job_variables |
ci_job_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_job_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_job_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_build_needs |
ci_build_needs |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_build_needs BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_build_needs EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_external_pull_requests |
external_pull_requests |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_external_pull_requests BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.external_pull_requests EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_subscriptions_projects |
ci_subscriptions_projects |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_subscriptions_projects BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_subscriptions_projects EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_resource_groups |
ci_resource_groups |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_resource_groups BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_resource_groups EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_resources |
ci_resources |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_resources BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_resources EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipelines_config |
ci_pipelines_config |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipelines_config BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipelines_config EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_sources_projects |
ci_sources_projects |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_sources_projects BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_sources_projects EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_instance_variables |
ci_instance_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_instance_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_instance_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_daily_build_group_report_res |
ci_daily_build_group_report_results |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_daily_build_group_report_res BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_daily_build_group_report_results EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_freeze_periods |
ci_freeze_periods |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_freeze_periods BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_freeze_periods EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_build_report_results |
ci_build_report_results |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_build_report_results BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_build_report_results EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_refs |
ci_refs |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_refs BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_refs EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_messages |
ci_pipeline_messages |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_messages BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_messages EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_artifacts |
ci_pipeline_artifacts |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_artifacts BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_artifacts EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_pipeline_variables |
p_ci_pipeline_variables |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_pipeline_variables BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_pipeline_variables EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_platform_metrics |
ci_platform_metrics |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_platform_metrics BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_platform_metrics EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_build_pending_states |
ci_build_pending_states |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_build_pending_states BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_build_pending_states EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_job_token_group_scope_links |
ci_job_token_group_scope_links |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_job_token_group_scope_links BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_job_token_group_scope_links EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_deleted_objects |
ci_deleted_objects |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_deleted_objects BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_deleted_objects EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_job_artifacts |
p_ci_job_artifacts |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_job_artifacts BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_job_artifacts EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_namespace_monthly_usages |
ci_namespace_monthly_usages |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_namespace_monthly_usages BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_namespace_monthly_usages EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_project_monthly_usages |
ci_project_monthly_usages |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_project_monthly_usages BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_project_monthly_usages EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_stages |
p_ci_stages |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_stages BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_stages EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_unit_tests |
ci_unit_tests |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_unit_tests BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_unit_tests EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_unit_test_failures |
ci_unit_test_failures |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_unit_test_failures BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_unit_test_failures EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pending_builds |
ci_pending_builds |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pending_builds BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pending_builds EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_minutes_additional_packs |
ci_minutes_additional_packs |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_minutes_additional_packs BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_minutes_additional_packs EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_job_token_project_scope_link |
ci_job_token_project_scope_links |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_job_token_project_scope_link BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_job_token_project_scope_links EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_build_names |
p_ci_build_names |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_build_names BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_build_names EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_running_builds |
ci_running_builds |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_running_builds BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_running_builds EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_build_trace_metadata |
ci_build_trace_metadata |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_build_trace_metadata BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_build_trace_metadata EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_namespace_mirrors |
ci_namespace_mirrors |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_namespace_mirrors BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_namespace_mirrors EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_project_mirrors |
ci_project_mirrors |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_project_mirrors BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_project_mirrors EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_builds_execution_configs |
p_ci_builds_execution_configs |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_builds_execution_configs BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_builds_execution_configs EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_secure_files |
ci_secure_files |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_secure_files BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_secure_files EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_job_artifact_states |
ci_job_artifact_states |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_job_artifact_states BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_job_artifact_states EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_build_sources |
p_ci_build_sources |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_build_sources BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_build_sources EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_secure_file_states |
ci_secure_file_states |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_secure_file_states BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_secure_file_states EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_runner_versions |
ci_runner_versions |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_runner_versions BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_runner_versions EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_partitions |
ci_partitions |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_partitions BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_partitions EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_pipeline_metadata |
ci_pipeline_metadata |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_pipeline_metadata BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_pipeline_metadata EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_builds_metadata |
p_ci_builds_metadata |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_builds_metadata BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_builds_metadata EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_runner_machines |
ci_runner_machines |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_runner_machines BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_runner_machines EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_runner_machine_builds |
p_ci_runner_machine_builds |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_runner_machine_builds BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_runner_machine_builds EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_ci_cost_settings |
ci_cost_settings |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_ci_cost_settings BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.ci_cost_settings EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_builds |
p_ci_builds |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_builds BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_builds EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_job_annotations |
p_ci_job_annotations |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_job_annotations BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_job_annotations EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraTriggers |
Trigger |
gitlab_schema_write_trigger_for_p_ci_finished_build_ch_sync_eve |
p_ci_finished_build_ch_sync_events |
|
CREATE TRIGGER gitlab_schema_write_trigger_for_p_ci_finished_build_ch_sync_eve BEFORE INSERT OR DELETE OR UPDATE OR TRUNCATE ON public.p_ci_finished_build_ch_sync_events EXECUTE FUNCTION gitlab_schema_prevent_write() |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_e344cb2d35 |
approval_policy_rules |
|
FOREIGN KEY (security_policy_management_project_id) REFERENCES projects(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_rails_03c671965c |
design_management_designs_versions |
|
FOREIGN KEY (design_id) REFERENCES design_management_designs(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_rails_f4d25ba00c |
design_management_designs_versions |
|
FOREIGN KEY (version_id) REFERENCES design_management_versions(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_rails_2b18ae9256 |
packages_tags |
|
FOREIGN KEY (package_id) REFERENCES packages_packages(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_rails_95a99c2d56 |
pool_repositories |
|
FOREIGN KEY (shard_id) REFERENCES shards(id) ON DELETE RESTRICT |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_0a31cca0b8 |
projects |
|
FOREIGN KEY (marked_for_deletion_by_user_id) REFERENCES users(id) ON DELETE SET NULL |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_08722e8ac7 |
security_policies |
|
FOREIGN KEY (security_policy_management_project_id) REFERENCES projects(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::ExtraForeignKeys |
ForeignKey |
public.fk_a27c483435 |
todos |
|
FOREIGN KEY (group_id) REFERENCES namespaces(id) ON DELETE CASCADE |
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
idx_component_usages_on_catalog_resource_used_by_proj_used_date |
p_catalog_resource_component_usages |
CREATE INDEX idx_component_usages_on_catalog_resource_used_by_proj_used_date ON ONLY public.p_catalog_resource_component_usages USING btree (catalog_resource_id, used_by_project_id, used_date) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
idx_projects_id_created_at_disable_overriding_approvers_false |
projects |
CREATE INDEX idx_projects_id_created_at_disable_overriding_approvers_false ON public.projects USING btree (id, created_at) WHERE disable_overriding_approvers_per_merge_request = false OR disable_overriding_approvers_per_merge_request IS NULL |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
idx_projects_id_created_at_disable_overriding_approvers_true |
projects |
CREATE INDEX idx_projects_id_created_at_disable_overriding_approvers_true ON public.projects USING btree (id, created_at) WHERE disable_overriding_approvers_per_merge_request = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_catalog_resources_on_last_30_day_usage_count_updated_at |
catalog_resources |
CREATE INDEX index_catalog_resources_on_last_30_day_usage_count_updated_at ON public.catalog_resources USING btree (last_30_day_usage_count_updated_at) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_builds_metadata_build_id_idx |
p_ci_builds_metadata |
CREATE INDEX p_ci_builds_metadata_build_id_idx ON ONLY public.p_ci_builds_metadata USING btree (build_id) WHERE has_exposed_artifacts IS TRUE |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_builds_metadata_build_id_id_idx |
p_ci_builds_metadata |
CREATE INDEX p_ci_builds_metadata_build_id_id_idx ON ONLY public.p_ci_builds_metadata USING btree (build_id) INCLUDE (id) WHERE interruptible = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_ci_builds_on_project_id_and_id |
ci_builds |
CREATE INDEX index_ci_builds_on_project_id_and_id ON public.ci_builds USING btree (project_id, id) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_ci_builds_on_runner_id_and_id_desc |
ci_builds |
CREATE INDEX index_ci_builds_on_runner_id_and_id_desc ON public.ci_builds USING btree (runner_id, id DESC) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_builds_stage_id_idx |
p_ci_builds |
CREATE INDEX p_ci_builds_stage_id_idx ON ONLY public.p_ci_builds USING btree (stage_id) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_ci_job_artifacts_on_project_id_for_security_reports |
ci_job_artifacts |
CREATE INDEX index_ci_job_artifacts_on_project_id_for_security_reports ON public.ci_job_artifacts USING btree (project_id) WHERE file_type = ANY(ARRAY[5, 6, 7, 8]) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_stages_pipeline_id_idx |
p_ci_stages |
CREATE INDEX p_ci_stages_pipeline_id_idx ON ONLY public.p_ci_stages USING btree (pipeline_id) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_stages_pipeline_id_id_idx |
p_ci_stages |
CREATE INDEX p_ci_stages_pipeline_id_id_idx ON ONLY public.p_ci_stages USING btree (pipeline_id, id) WHERE status = ANY(ARRAY[0, 1, 2, 8, 9, 10]) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
p_ci_stages_pipeline_id_position_idx |
p_ci_stages |
CREATE INDEX p_ci_stages_pipeline_id_position_idx ON ONLY public.p_ci_stages USING btree (pipeline_id, "position") |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_emails_on_email_trigram |
emails |
CREATE INDEX index_emails_on_email_trigram ON public.emails USING gin (email gin_trgm_ops) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_namespaces_on_created_at |
namespaces |
CREATE INDEX index_namespaces_on_created_at ON public.namespaces USING btree (created_at) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_namespaces_on_ldap_sync_last_successful_update_at |
namespaces |
CREATE INDEX index_namespaces_on_ldap_sync_last_successful_update_at ON public.namespaces USING btree (ldap_sync_last_successful_update_at) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_projects_on_id_service_desk_enabled |
projects |
CREATE INDEX index_projects_on_id_service_desk_enabled ON public.projects USING btree (id) WHERE service_desk_enabled = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_projects_on_mirror_creator_id_created_at |
projects |
CREATE INDEX index_projects_on_mirror_creator_id_created_at ON public.projects USING btree (creator_id, created_at) WHERE mirror = true AND mirror_trigger_builds = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_projects_on_mirror_id_where_mirror_and_trigger_builds |
projects |
CREATE INDEX index_projects_on_mirror_id_where_mirror_and_trigger_builds ON public.projects USING btree (id) WHERE mirror = true AND mirror_trigger_builds = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_sbom_occurrences_vulnerabilities_on_project_id |
sbom_occurrences_vulnerabilities |
CREATE INDEX index_sbom_occurrences_vulnerabilities_on_project_id ON public.sbom_occurrences_vulnerabilities USING btree (project_id) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_service_desk_enabled_projects_on_id_creator_id_created_at |
projects |
CREATE INDEX index_service_desk_enabled_projects_on_id_creator_id_created_at ON public.projects USING btree (id, creator_id, created_at) WHERE service_desk_enabled = true |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_users_for_auditors |
users |
CREATE INDEX index_users_for_auditors ON public.users USING btree (id) WHERE auditor IS TRUE |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_users_on_email_trigram |
users |
CREATE INDEX index_users_on_email_trigram ON public.users USING gin (email gin_trgm_ops) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_users_on_id_and_last_activity_on_for_active_human_service |
users |
CREATE INDEX index_users_on_id_and_last_activity_on_for_active_human_service ON public.users USING btree (id, last_activity_on) WHERE state::text = 'active'::text AND user_type = ANY(ARRAY[0, 4]) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_users_on_public_email_trigram |
users |
CREATE INDEX index_users_on_public_email_trigram ON public.users USING gin (public_email gin_trgm_ops) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
index_vulnerability_issue_links_on_project_id |
vulnerability_issue_links |
CREATE INDEX index_vulnerability_issue_links_on_project_id ON public.vulnerability_issue_links USING btree (project_id) |
|
Gitlab::Schema::Validation::Validators::MissingIndexes |
Index |
tmp_index_project_statistics_updated_at |
project_statistics |
CREATE INDEX tmp_index_project_statistics_updated_at ON public.project_statistics USING btree (project_id, updated_at) WHERE repository_size > 0 |
|
Gitlab::Schema::Validation::Validators::MissingTriggers |
Trigger |
trigger_25fe4f7da510 |
vulnerability_issue_links |
CREATE TRIGGER trigger_25fe4f7da510 BEFORE INSERT OR UPDATE ON public.vulnerability_issue_links FOR EACH ROW EXECUTE FUNCTION trigger_25fe4f7da510() |
|
Gitlab::Schema::Validation::Validators::MissingTriggers |
Trigger |
trigger_4ad9a52a6614 |
sbom_occurrences_vulnerabilities |
CREATE TRIGGER trigger_4ad9a52a6614 BEFORE INSERT OR UPDATE ON public.sbom_occurrences_vulnerabilities FOR EACH ROW EXECUTE FUNCTION trigger_4ad9a52a6614() |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_03c671965c |
design_management_designs_versions |
FOREIGN KEY (design_id) REFERENCES design_management_designs(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_058f258503 |
sbom_occurrences_vulnerabilities |
FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_081e11030b |
vulnerability_issue_links |
FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_f4d25ba00c |
design_management_designs_versions |
FOREIGN KEY (version_id) REFERENCES design_management_versions(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_rails_08722e8ac7 |
security_policies |
FOREIGN KEY (security_policy_management_project_id) REFERENCES projects(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_rails_1dfc868911 |
packages_tags |
FOREIGN KEY (package_id) REFERENCES packages_packages(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_rails_a27c483435 |
todos |
FOREIGN KEY (group_id) REFERENCES namespaces(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_rails_af3f8c5d62 |
pool_repositories |
FOREIGN KEY (shard_id) REFERENCES shards(id) ON DELETE RESTRICT |
|
Gitlab::Schema::Validation::Validators::MissingForeignKeys |
ForeignKey |
public.fk_rails_e344cb2d35 |
approval_policy_rules |
FOREIGN KEY (security_policy_management_project_id) REFERENCES projects(id) ON DELETE CASCADE |
|
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespaces |
namespaces |
CREATE TABLE namespaces (name character varying(510) NOT NULL, path character varying(510) NOT NULL, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, type character varying(510) DEFAULT 'User'::character varying NOT NULL, description character varying(510) DEFAULT ''::character varying NOT NULL, avatar character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE namespaces (name character varying NOT NULL, path character varying NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, type character varying DEFAULT 'User'::character varying NOT NULL, description character varying DEFAULT ''::character varying NOT NULL, avatar character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
projects |
projects |
CREATE TABLE projects (name character varying(510) DEFAULT NULL::character varying, path character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, last_activity_at timestamp with time zone, import_url character varying(510) DEFAULT NULL::character varying, archived boolean NOT NULL, avatar character varying(255), import_type character varying(255), import_source character varying(255)) |
CREATE TABLE projects (name character varying, path character varying, created_at timestamp without time zone, updated_at timestamp without time zone, last_activity_at timestamp without time zone, import_url character varying, archived boolean DEFAULT false NOT NULL, avatar character varying, import_type character varying, import_source character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
users |
users |
CREATE TABLE users (email character varying(510) DEFAULT ''::character varying NOT NULL, encrypted_password character varying(256) DEFAULT ''::character varying NOT NULL, reset_password_token character varying(510) DEFAULT NULL::character varying, reset_password_sent_at timestamp with time zone, remember_created_at timestamp with time zone, current_sign_in_at timestamp with time zone, last_sign_in_at timestamp with time zone, current_sign_in_ip character varying(510) DEFAULT NULL::character varying, last_sign_in_ip character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, name character varying(510) DEFAULT NULL::character varying, admin boolean NOT NULL, locked_at timestamp with time zone, username character varying(510) DEFAULT NULL::character varying, can_create_group boolean NOT NULL, can_create_team boolean NOT NULL, state character varying(510) DEFAULT NULL::character varying, password_expires_at timestamp with time zone, last_credential_check_at timestamp with time zone, avatar character varying(510) DEFAULT NULL::character varying, confirmation_token character varying(510) DEFAULT NULL::character varying, confirmed_at timestamp with time zone, confirmation_sent_at timestamp with time zone, unconfirmed_email character varying(510) DEFAULT NULL::character varying, hide_no_ssh_key boolean, notification_email character varying(255), encrypted_otp_secret character varying(255), encrypted_otp_secret_iv character varying(255), encrypted_otp_secret_salt character varying(255), public_email character varying(255)) |
CREATE TABLE users (email character varying DEFAULT ''::character varying NOT NULL, encrypted_password character varying DEFAULT ''::character varying NOT NULL, reset_password_token character varying, reset_password_sent_at timestamp without time zone, remember_created_at timestamp without time zone, current_sign_in_at timestamp without time zone, last_sign_in_at timestamp without time zone, current_sign_in_ip character varying, last_sign_in_ip character varying, created_at timestamp without time zone, updated_at timestamp without time zone, name character varying, admin boolean DEFAULT false NOT NULL, locked_at timestamp without time zone, username character varying, can_create_group boolean DEFAULT true NOT NULL, can_create_team boolean DEFAULT true NOT NULL, state character varying, password_expires_at timestamp without time zone, last_credential_check_at timestamp without time zone, avatar character varying, confirmation_token character varying, confirmed_at timestamp without time zone, confirmation_sent_at timestamp without time zone, unconfirmed_email character varying, hide_no_ssh_key boolean DEFAULT false, notification_email character varying, encrypted_otp_secret character varying, encrypted_otp_secret_iv character varying, encrypted_otp_secret_salt character varying, public_email character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
audit_events |
audit_events |
CREATE TABLE audit_events (entity_type character varying(255) NOT NULL) |
CREATE TABLE audit_events (entity_type character varying NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
p_ci_build_names |
p_ci_build_names |
CREATE TABLE p_ci_build_names (search_vector tsvector DEFAULT to_tsvector('english'::regconfig, COALESCE(name, ''::text))) |
CREATE TABLE p_ci_build_names (search_vector tsvector) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
p_ci_builds |
p_ci_builds |
CREATE TABLE p_ci_builds (status character varying(255), name character varying(255), stage character varying(255), ref character varying(255), type character varying(255), target_url character varying(255), description character varying(255)) |
CREATE TABLE p_ci_builds (status character varying, name character varying, stage character varying, ref character varying, type character varying, target_url character varying, description character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
loose_foreign_keys_deleted_records |
loose_foreign_keys_deleted_records |
CREATE TABLE loose_foreign_keys_deleted_records () |
CREATE TABLE loose_foreign_keys_deleted_records () |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
merge_request_diff_commits_b5377a7a34 |
merge_request_diff_commits_b5377a7a34 |
CREATE TABLE merge_request_diff_commits_b5377a7a34 (authored_date timestamp with time zone, committed_date timestamp with time zone) |
CREATE TABLE merge_request_diff_commits_b5377a7a34 (authored_date timestamp without time zone, committed_date timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
p_catalog_resource_sync_events |
p_catalog_resource_sync_events |
CREATE TABLE p_catalog_resource_sync_events () |
CREATE TABLE p_catalog_resource_sync_events () |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
security_findings |
security_findings |
CREATE TABLE security_findings () |
CREATE TABLE security_findings () |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
zoekt_tasks |
zoekt_tasks |
CREATE TABLE zoekt_tasks () |
CREATE TABLE zoekt_tasks () |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants |
namespace_descendants |
CREATE TABLE namespace_descendants (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants (self_and_descendant_group_ids bigint[] DEFAULT '111967'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '112032'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '112095'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_00 |
namespace_descendants_00 |
CREATE TABLE namespace_descendants_00 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_00 (self_and_descendant_group_ids bigint[] DEFAULT '112395'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '112460'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '112523'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_01 |
namespace_descendants_01 |
CREATE TABLE namespace_descendants_01 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_01 (self_and_descendant_group_ids bigint[] DEFAULT '112790'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '112855'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '112918'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_02 |
namespace_descendants_02 |
CREATE TABLE namespace_descendants_02 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_02 (self_and_descendant_group_ids bigint[] DEFAULT '113185'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '113250'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '113313'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_03 |
namespace_descendants_03 |
CREATE TABLE namespace_descendants_03 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_03 (self_and_descendant_group_ids bigint[] DEFAULT '113580'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '113645'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '113708'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_04 |
namespace_descendants_04 |
CREATE TABLE namespace_descendants_04 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_04 (self_and_descendant_group_ids bigint[] DEFAULT '113975'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '114040'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '114103'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_05 |
namespace_descendants_05 |
CREATE TABLE namespace_descendants_05 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_05 (self_and_descendant_group_ids bigint[] DEFAULT '114370'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '114435'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '114498'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_06 |
namespace_descendants_06 |
CREATE TABLE namespace_descendants_06 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_06 (self_and_descendant_group_ids bigint[] DEFAULT '114765'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '114830'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '114893'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_07 |
namespace_descendants_07 |
CREATE TABLE namespace_descendants_07 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_07 (self_and_descendant_group_ids bigint[] DEFAULT '115160'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '115225'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '115288'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_08 |
namespace_descendants_08 |
CREATE TABLE namespace_descendants_08 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_08 (self_and_descendant_group_ids bigint[] DEFAULT '115555'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '115620'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '115683'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_09 |
namespace_descendants_09 |
CREATE TABLE namespace_descendants_09 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_09 (self_and_descendant_group_ids bigint[] DEFAULT '115950'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '116015'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '116078'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_10 |
namespace_descendants_10 |
CREATE TABLE namespace_descendants_10 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_10 (self_and_descendant_group_ids bigint[] DEFAULT '116345'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '116410'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '116473'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_11 |
namespace_descendants_11 |
CREATE TABLE namespace_descendants_11 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_11 (self_and_descendant_group_ids bigint[] DEFAULT '116740'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '116805'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '116868'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_12 |
namespace_descendants_12 |
CREATE TABLE namespace_descendants_12 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_12 (self_and_descendant_group_ids bigint[] DEFAULT '117135'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '117200'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '117263'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_13 |
namespace_descendants_13 |
CREATE TABLE namespace_descendants_13 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_13 (self_and_descendant_group_ids bigint[] DEFAULT '117530'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '117595'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '117658'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_14 |
namespace_descendants_14 |
CREATE TABLE namespace_descendants_14 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_14 (self_and_descendant_group_ids bigint[] DEFAULT '117925'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '117990'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '118053'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_15 |
namespace_descendants_15 |
CREATE TABLE namespace_descendants_15 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_15 (self_and_descendant_group_ids bigint[] DEFAULT '118320'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '118385'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '118448'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_16 |
namespace_descendants_16 |
CREATE TABLE namespace_descendants_16 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_16 (self_and_descendant_group_ids bigint[] DEFAULT '118715'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '118780'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '118843'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_17 |
namespace_descendants_17 |
CREATE TABLE namespace_descendants_17 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_17 (self_and_descendant_group_ids bigint[] DEFAULT '119110'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '119175'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '119238'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_18 |
namespace_descendants_18 |
CREATE TABLE namespace_descendants_18 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_18 (self_and_descendant_group_ids bigint[] DEFAULT '119505'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '119570'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '119633'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_19 |
namespace_descendants_19 |
CREATE TABLE namespace_descendants_19 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_19 (self_and_descendant_group_ids bigint[] DEFAULT '119900'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '119965'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '120028'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_20 |
namespace_descendants_20 |
CREATE TABLE namespace_descendants_20 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_20 (self_and_descendant_group_ids bigint[] DEFAULT '120295'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '120360'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '120423'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_21 |
namespace_descendants_21 |
CREATE TABLE namespace_descendants_21 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_21 (self_and_descendant_group_ids bigint[] DEFAULT '120690'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '120755'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '120818'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_22 |
namespace_descendants_22 |
CREATE TABLE namespace_descendants_22 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_22 (self_and_descendant_group_ids bigint[] DEFAULT '121085'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '121150'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '121213'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_23 |
namespace_descendants_23 |
CREATE TABLE namespace_descendants_23 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_23 (self_and_descendant_group_ids bigint[] DEFAULT '121480'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '121545'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '121608'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_24 |
namespace_descendants_24 |
CREATE TABLE namespace_descendants_24 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_24 (self_and_descendant_group_ids bigint[] DEFAULT '121875'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '121940'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '122003'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_25 |
namespace_descendants_25 |
CREATE TABLE namespace_descendants_25 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_25 (self_and_descendant_group_ids bigint[] DEFAULT '122270'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '122335'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '122398'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_26 |
namespace_descendants_26 |
CREATE TABLE namespace_descendants_26 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_26 (self_and_descendant_group_ids bigint[] DEFAULT '122665'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '122730'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '122793'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_27 |
namespace_descendants_27 |
CREATE TABLE namespace_descendants_27 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_27 (self_and_descendant_group_ids bigint[] DEFAULT '123060'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '123125'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '123188'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_28 |
namespace_descendants_28 |
CREATE TABLE namespace_descendants_28 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_28 (self_and_descendant_group_ids bigint[] DEFAULT '123455'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '123520'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '123583'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_29 |
namespace_descendants_29 |
CREATE TABLE namespace_descendants_29 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_29 (self_and_descendant_group_ids bigint[] DEFAULT '123850'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '123915'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '123978'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_30 |
namespace_descendants_30 |
CREATE TABLE namespace_descendants_30 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_30 (self_and_descendant_group_ids bigint[] DEFAULT '124245'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '124310'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '124373'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
namespace_descendants_31 |
namespace_descendants_31 |
CREATE TABLE namespace_descendants_31 (self_and_descendant_group_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT ARRAY[]::bigint[] NOT NULL) |
CREATE TABLE namespace_descendants_31 (self_and_descendant_group_ids bigint[] DEFAULT '124640'::bigint[] NOT NULL, all_project_ids bigint[] DEFAULT '124705'::bigint[] NOT NULL, traversal_ids bigint[] DEFAULT '124768'::bigint[] NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
appearances |
appearances |
CREATE TABLE appearances (title character varying(255) NOT NULL, logo character varying(255), header_logo character varying(255)) |
CREATE TABLE appearances (title character varying NOT NULL, logo character varying, header_logo character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
application_settings |
application_settings |
CREATE TABLE application_settings (home_page_url character varying(255), after_sign_out_path character varying(255), polling_interval_multiplier numeric DEFAULT 1 NOT NULL, kroki_url text, kroki_enabled boolean DEFAULT false NOT NULL, abuse_notification_email character varying(255)) |
CREATE TABLE application_settings (home_page_url character varying, after_sign_out_path character varying, polling_interval_multiplier numeric DEFAULT 1.0 NOT NULL, kroki_url character varying, kroki_enabled boolean, abuse_notification_email character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
approvers |
approvers |
CREATE TABLE approvers (target_type character varying(255)) |
CREATE TABLE approvers (target_type character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ar_internal_metadata |
ar_internal_metadata |
CREATE TABLE ar_internal_metadata (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
CREATE TABLE ar_internal_metadata (created_at timestamp(6) without time zone NOT NULL, updated_at timestamp(6) without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
broadcast_messages |
broadcast_messages |
CREATE TABLE broadcast_messages (starts_at timestamp with time zone NOT NULL, ends_at timestamp with time zone NOT NULL, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, color character varying(510) DEFAULT NULL::character varying, font character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE broadcast_messages (starts_at timestamp without time zone NOT NULL, ends_at timestamp without time zone NOT NULL, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, color character varying, font character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
catalog_resources |
catalog_resources |
CREATE TABLE catalog_resources (search_vector tsvector DEFAULT (setweight(to_tsvector('english'::regconfig, (COALESCE(name, ''::character varying))::text), 'A'::"char") |
|
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_builds |
ci_builds |
CREATE TABLE ci_builds (status character varying(255), name character varying(255), stage character varying(255), ref character varying(255), type character varying(255), target_url character varying(255), description character varying(255)) |
CREATE TABLE ci_builds (status character varying, name character varying, stage character varying, ref character varying, type character varying, target_url character varying, description character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_freeze_periods |
ci_freeze_periods |
CREATE TABLE ci_freeze_periods (freeze_start text NOT NULL, freeze_end text NOT NULL, cron_timezone text NOT NULL) |
CREATE TABLE ci_freeze_periods (freeze_start character varying(998) NOT NULL, freeze_end character varying(998) NOT NULL, cron_timezone character varying(255) NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_pipelines |
ci_pipelines |
CREATE TABLE ci_pipelines (ref character varying(255), sha character varying(255), before_sha character varying(255)) |
CREATE TABLE ci_pipelines (ref character varying, sha character varying, before_sha character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_runners |
ci_runners |
CREATE TABLE ci_runners (token character varying(255), description character varying(255), name character varying(255)) |
CREATE TABLE ci_runners (token character varying, description character varying, name character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_triggers |
ci_triggers |
CREATE TABLE ci_triggers (token character varying(255)) |
CREATE TABLE ci_triggers (token character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ci_variables |
ci_variables |
CREATE TABLE ci_variables (encrypted_value_salt character varying(255), encrypted_value_iv character varying(255)) |
CREATE TABLE ci_variables (encrypted_value_salt character varying, encrypted_value_iv character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
cluster_platforms_kubernetes |
cluster_platforms_kubernetes |
CREATE TABLE cluster_platforms_kubernetes (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE cluster_platforms_kubernetes (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
cluster_projects |
cluster_projects |
CREATE TABLE cluster_projects (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE cluster_projects (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
cluster_providers_gcp |
cluster_providers_gcp |
CREATE TABLE cluster_providers_gcp (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE cluster_providers_gcp (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
clusters |
clusters |
CREATE TABLE clusters (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE clusters (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
deploy_keys_projects |
deploy_keys_projects |
CREATE TABLE deploy_keys_projects (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE deploy_keys_projects (created_at timestamp without time zone, updated_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
emails |
emails |
CREATE TABLE emails (email character varying(510) NOT NULL, created_at timestamp with time zone, updated_at timestamp with time zone, confirmed_at timestamp with time zone, confirmation_sent_at timestamp with time zone) |
CREATE TABLE emails (email character varying NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, confirmed_at timestamp without time zone, confirmation_sent_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
epic_metrics |
epic_metrics |
CREATE TABLE epic_metrics (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE epic_metrics (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
epics |
epics |
CREATE TABLE epics (last_edited_at timestamp with time zone, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, closed_at timestamp with time zone) |
CREATE TABLE epics (last_edited_at timestamp without time zone, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, closed_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
geo_node_namespace_links |
geo_node_namespace_links |
CREATE TABLE geo_node_namespace_links (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE geo_node_namespace_links (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
geo_node_statuses |
geo_node_statuses |
CREATE TABLE geo_node_statuses (last_event_date timestamp with time zone, cursor_last_event_date timestamp with time zone, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, last_successful_status_check_at timestamp with time zone) |
CREATE TABLE geo_node_statuses (last_event_date timestamp without time zone, cursor_last_event_date timestamp without time zone, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL, last_successful_status_check_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
identities |
identities |
CREATE TABLE identities (extern_uid character varying(255), provider character varying(255)) |
CREATE TABLE identities (extern_uid character varying, provider character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
integrations |
integrations |
CREATE TABLE integrations (created_at timestamp with time zone, updated_at timestamp with time zone, active boolean NOT NULL) |
CREATE TABLE integrations (created_at timestamp without time zone, updated_at timestamp without time zone, active boolean DEFAULT false NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
issues |
issues |
CREATE TABLE issues (title character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE issues (title character varying, created_at timestamp without time zone, updated_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
keys |
keys |
CREATE TABLE keys (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, title character varying(510) DEFAULT NULL::character varying, type character varying(510) DEFAULT NULL::character varying, fingerprint character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE keys (created_at timestamp without time zone, updated_at timestamp without time zone, title character varying, type character varying, fingerprint character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
label_links |
label_links |
CREATE TABLE label_links (target_type character varying(255)) |
CREATE TABLE label_links (target_type character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
labels |
labels |
CREATE TABLE labels (title character varying(255), color character varying(255)) |
CREATE TABLE labels (title character varying, color character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
ldap_group_links |
ldap_group_links |
CREATE TABLE ldap_group_links (cn character varying(255), provider character varying(255)) |
CREATE TABLE ldap_group_links (cn character varying, provider character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
lfs_objects |
lfs_objects |
CREATE TABLE lfs_objects (oid character varying(255) NOT NULL, file character varying(255)) |
CREATE TABLE lfs_objects (oid character varying NOT NULL, file character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
members |
members |
CREATE TABLE members (source_type character varying(255) NOT NULL, type character varying(255), invite_email character varying(255), invite_token character varying(255)) |
CREATE TABLE members (source_type character varying NOT NULL, type character varying, invite_email character varying, invite_token character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
merge_request_assignees |
merge_request_assignees |
CREATE TABLE merge_request_assignees (id integer NOT NULL) |
CREATE TABLE merge_request_assignees (id bigint NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
merge_request_diff_commits |
merge_request_diff_commits |
CREATE TABLE merge_request_diff_commits (authored_date timestamp with time zone, committed_date timestamp with time zone) |
CREATE TABLE merge_request_diff_commits (authored_date timestamp without time zone, committed_date timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
merge_request_diffs |
merge_request_diffs |
CREATE TABLE merge_request_diffs (state character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone, updated_at timestamp with time zone) |
CREATE TABLE merge_request_diffs (state character varying, created_at timestamp without time zone, updated_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
merge_requests |
merge_requests |
CREATE TABLE merge_requests (target_branch character varying(510) NOT NULL, source_branch character varying(510) NOT NULL, title character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, merge_status character varying(510) DEFAULT 'unchecked'::character varying NOT NULL) |
CREATE TABLE merge_requests (target_branch character varying NOT NULL, source_branch character varying NOT NULL, title character varying, created_at timestamp without time zone, updated_at timestamp without time zone, merge_status character varying DEFAULT 'unchecked'::character varying NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
milestones |
milestones |
CREATE TABLE milestones (title character varying(510) NOT NULL, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, state character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE milestones (title character varying NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone, state character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
notes |
notes |
CREATE TABLE notes (noteable_type character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, attachment character varying(510) DEFAULT NULL::character varying, line_code character varying(510) DEFAULT NULL::character varying, commit_id character varying(510) DEFAULT NULL::character varying, system boolean NOT NULL) |
CREATE TABLE notes (noteable_type character varying, created_at timestamp without time zone, updated_at timestamp without time zone, attachment character varying, line_code character varying, commit_id character varying, system boolean DEFAULT false NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
oauth_access_grants |
oauth_access_grants |
CREATE TABLE oauth_access_grants (token character varying(255) NOT NULL, scopes character varying(255)) |
CREATE TABLE oauth_access_grants (token character varying NOT NULL, scopes character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
oauth_access_tokens |
oauth_access_tokens |
CREATE TABLE oauth_access_tokens (token character varying(255) NOT NULL, refresh_token character varying(255), scopes character varying(255)) |
CREATE TABLE oauth_access_tokens (token character varying NOT NULL, refresh_token character varying, scopes character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
oauth_applications |
oauth_applications |
CREATE TABLE oauth_applications (name character varying(255) NOT NULL, uid character varying(255) NOT NULL, secret character varying(255) NOT NULL, scopes character varying(255) DEFAULT ''::character varying NOT NULL, owner_type character varying(255)) |
CREATE TABLE oauth_applications (name character varying NOT NULL, uid character varying NOT NULL, secret character varying NOT NULL, scopes character varying DEFAULT ''::character varying NOT NULL, owner_type character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
plans |
plans |
CREATE TABLE plans (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE plans (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
project_mirror_data |
project_mirror_data |
CREATE TABLE project_mirror_data (next_execution_timestamp timestamp with time zone) |
CREATE TABLE project_mirror_data (next_execution_timestamp timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
protected_branches |
protected_branches |
CREATE TABLE protected_branches (name character varying(510) NOT NULL, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE protected_branches (name character varying NOT NULL, created_at timestamp without time zone, updated_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
releases |
releases |
CREATE TABLE releases (tag character varying(255)) |
CREATE TABLE releases (tag character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
schema_migrations |
schema_migrations |
CREATE TABLE schema_migrations (version character varying(510) NOT NULL) |
CREATE TABLE schema_migrations (version character varying NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
sent_notifications |
sent_notifications |
CREATE TABLE sent_notifications (noteable_type character varying(255), commit_id character varying(255), reply_key character varying(255) NOT NULL) |
CREATE TABLE sent_notifications (noteable_type character varying, commit_id character varying, reply_key character varying NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
slack_integrations |
slack_integrations |
CREATE TABLE slack_integrations (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE slack_integrations (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
snippets |
snippets |
CREATE TABLE snippets (title character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, file_name character varying(510) DEFAULT NULL::character varying, type character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE snippets (title character varying, created_at timestamp without time zone, updated_at timestamp without time zone, file_name character varying, type character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
subscriptions |
subscriptions |
CREATE TABLE subscriptions (subscribable_type character varying(255)) |
CREATE TABLE subscriptions (subscribable_type character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
taggings |
taggings |
CREATE TABLE taggings (taggable_type character varying(510) DEFAULT NULL::character varying, tagger_type character varying(510) DEFAULT NULL::character varying, context character varying(510) DEFAULT NULL::character varying, created_at timestamp with time zone) |
CREATE TABLE taggings (taggable_type character varying, tagger_type character varying, context character varying, created_at timestamp without time zone) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
tags |
tags |
CREATE TABLE tags (name character varying(510) DEFAULT NULL::character varying) |
CREATE TABLE tags (name character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
timelogs |
timelogs |
CREATE TABLE timelogs (spent_at timestamp with time zone DEFAULT now()) |
CREATE TABLE timelogs (spent_at timestamp without time zone DEFAULT now()) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
user_custom_attributes |
user_custom_attributes |
CREATE TABLE user_custom_attributes (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL) |
CREATE TABLE user_custom_attributes (created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionTables |
Table |
web_hooks |
web_hooks |
CREATE TABLE web_hooks (created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, type character varying(510) DEFAULT 'ProjectHook'::character varying) |
CREATE TABLE web_hooks (created_at timestamp without time zone, updated_at timestamp without time zone, type character varying DEFAULT 'ProjectHook'::character varying) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionIndexes |
Index |
p_ci_job_artifacts_project_id_idx1 |
p_ci_job_artifacts |
CREATE INDEX p_ci_job_artifacts_project_id_idx1 ON ONLY public.p_ci_job_artifacts USING btree (project_id) WHERE file_type = ANY(ARRAY[5, 6, 7, 8]) |
CREATE INDEX p_ci_job_artifacts_project_id_idx1 ON ONLY public.p_ci_job_artifacts USING btree (project_id) |
Gitlab::Schema::Validation::Validators::DifferentDefinitionForeignKeys |
ForeignKey |
public.fk_rails_25dc49c011 |
ci_builds |
FOREIGN KEY (partition_id, execution_config_id) REFERENCES p_ci_builds_execution_configs(partition_id, id) ON UPDATE CASCADE ON DELETE SET NULL NOT VALID |
FOREIGN KEY (partition_id, execution_config_id) REFERENCES p_ci_builds_execution_configs(partition_id, id) ON UPDATE CASCADE ON DELETE SET NULL |