artin/sourcegraph
1
0
Fork 0
mirror of https://github.com/sourcegraph/sourcegraph.git synced 2026-02-06 20:11:54 +00:00
Code Issues Packages Projects Releases Wiki Activity
main
sourcegraph/migrations/frontend
History
Keegan Carruthers-Smith 9981c14e40
migrations: avoid duplicate foreign key constraints when tenant_id re-run (#64465) 
ALTER TABLE with a foreign key constraint will _always_ add the
constraint, which means we always require a table lock even if this
migration has run. So we check if the column exists first.

The motivation for this change was me noticing slow migrations against
S2, even though it had been migrated already. This speeds it up since it
avoids a bunch of locks.

In testing I kept running into issues with the lsif_* tables. We agreed
we will only migrate them later.

Test Plan: ran against my local instance and S2 multiple times and CI.
Also manually ran the down and up migration against dotcom
2024-08-14 16:57:32 +02:00
..
1648051770_squashed_migrations_privileged migrations: Run squash targeting 4.0 (#41819) 2022-09-20 16:31:23 -05:00
1648195639_squashed_migrations_unprivileged Backend: remove enterprise/internal (#54872) 2023-07-12 22:51:02 +02:00
1648524019_int64-ids-user-pending-permissions migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1648628900_rename_localclone_worker_table migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1649159359_batch_spec_resolution_user_id migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1649253538_batch_spec_resolution_user_id_non_null migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1649269601_remove_unused_code_monitor_columns migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1649432863_no_hash_for_code_monitor_last_searched migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1649441222_lsif_uploads_audit_logging migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1649759318_change_default_invite_quota migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1650456734_configuration_policies_audit_logging migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1650637472_Add_codeintel_langugage_support_requests_table migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1651061363_lsif_uploads_audit_logging_reason migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1651077257_lsif_dirty_repo_timestamp migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1651159431_fix-maven-dependency-repos-name migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652143849_drop_constraint_from_filter_column_in_lsif_references_table migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652175864_add-unrestricted-to-repo-permissions migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652189866_Add_lockfiles_tables migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652228814_index_bitbucket_cloud_commit migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652707934_add_last_check_at_to_codeintel_lockfile_references migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1652946496_add_trigger_to_insert_gitserver_repo migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1652964210_add_last_lockfile_scan_table migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1653334014_Remove_default_from_out_of_band_migrations_created_timestamp migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1653472246_add_nps_survey_fields migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1653479179_audit_log_op_and_seq migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1653524883_Create_view_for_batch_spec_workspace_execution_worker migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1653596521_Add_column_detached_at_to_changesets_table Cleanup detached changesets (#36188) 2022-07-21 14:00:46 -06:00
1654116265_add_unique_index_to_external_services migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1654168174_add_explicit_permissions_bitbucket_projects_jobs_table migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1654770608_workspace_user_id_non_nullable codeintel: Lazily enqueue crate autoindexing jobs (#41101) 2022-09-16 09:30:25 -05:00
1654848945_add_explicit_permissions_bitbucket_projects_jobs_index migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1654872407_fast_cascade_delete_batch_specs_1 migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1654874148_fast_cascade_delete_batch_specs_2 migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1654874153_fast_cascade_delete_batch_specs_3 migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655037388_faster_changeset_spec_cleanup_1 migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655037391_faster_changeset_spec_cleanup_2 migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655067139_fixup_worker_fairness_view migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655105391_lockfile_dependency_graph migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655128668_add_indices_to_explicit_permissions_bitbucket_projects_jobs_table migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655157509_no_more_ssbc_access_tokens migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1655226733_hstore_aggregate_func migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655328928_fix_code_insights_failed_tcp_error migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655412173_code_insights_queue_missing_index migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655454264_add_lockfile_indexing_enabled_to_policy migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655481894_faster_ssbc_dequeue chore: Fix drop index name (#40204) 2022-08-10 21:45:36 +01:00
1655737737_drop_unused_idx_batch_spec_workspace_execution_jobs_user_id migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655763641_faster_workspace_batch_spec_lookup migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1655843069_insights_faster_job_status migrations: Update migration directory names (#38599) 2022-07-11 23:20:32 +00:00
1656447205_create_repo_description_trgm_idx search: create index on repo description (#37889) 2022-07-06 12:28:52 -05:00
1657106983_faster_failure_msg_query db: Improve performance of external service sync failure message (#38287) 2022-07-06 20:49:04 +02:00
1657107627_drop_duplicate_index_sync_jobs_state db: Improve performance of external service sync failure message (#38287) 2022-07-06 20:49:04 +02:00
1657279116_faster_dequeues_cm_action_jobs Add missing index on code monitor worker tables (#38469) 2022-07-08 11:31:56 +00:00
1657279170_faster_dequeues_cm_trigger_jobs Add missing index on code monitor worker tables (#38469) 2022-07-08 11:31:56 +00:00
1657635365_add_fidelity_to_lockfiles dependencies: add fidelity column to codeintel_lockfiles and populate (#38710) 2022-07-13 09:45:37 +00:00
1657663493_cancel_worker_feature Make worker cancellation a worker-native feature (#38752) 2022-07-19 13:46:27 +02:00
1658122170_add_batch_change_id_to_batch_spec batches: add limit to subquery for updating batch_specs.batch_change_id (#39732) 2022-08-01 15:17:16 +01:00
1658174103_workspace_execution_user_queues ssbc: Make computation of candidate queues faster (#38980) 2022-07-19 18:58:46 +02:00
1658225452_fast_cm_trigger_jobs_delete db: Faster SQL cleanup of cm_trigger_jobs (#39014) 2022-07-19 16:24:15 +02:00
1658255432_add_missing_constraints batches: Add missing non null constraints (#39101) 2022-07-19 19:03:44 +00:00
1658384388_normalize_product_licenseslicense_key_fields migration: normalize license key fields and record subscription account number (#39206) 2022-07-21 15:37:04 +08:00
1658484997_add_webhook_build_jobs_table Setting up the DB Schema to create background workers that will build webhooks (#39292) 2022-07-27 08:15:44 -07:00
1658503913_batches_changeset_state_computed batches: Add computed state value to DB (#39316) 2022-07-25 13:03:18 +02:00
1658512336_batches_changeset_state_index batches: Add computed state value to DB (#39316) 2022-07-25 13:03:18 +02:00
1658748822_add_timestamps_to_lockfiles dependencies: add updated_at/created_at to LockfileIndex (#39361) 2022-07-25 13:01:22 +00:00
1658837440_sync_jobs_missing_index Collection of multiple smaller clean ups in gitserver codebase (#39395) 2022-08-03 14:05:45 +02:00
1658856572_event_log_scrape_state usage-data: maintain state of progress when scraping events (#39472) 2022-07-27 12:31:54 -07:00
1658874734_normalized_changeset_specs Normalize changeset_specs database (#39525) 2022-08-16 15:51:12 +02:00
1658950366_event_log_scrape_allow_list usage-data: restrict scraped events to an allowlist (#39534) 2022-07-28 10:23:12 -07:00
1659085788_add_repo_stats_table Approach 2: add repo_statistics and gitserver_repos_statistics tables (#40577) 2022-08-19 14:09:44 +02:00
1659368926_cleanup_lsif_indexes_errored Fixup old lsif_indexes records that are in invalid errored state (#39761) 2022-08-01 16:03:59 +00:00
1659380538_event_log_dot_com_fields usage-data: missing event cols (#39907) 2022-08-05 10:37:25 -07:00
1659434035_alter_webhook_build_jobs_table Another schema change for webhook build worker (#39798) 2022-08-02 09:14:09 -07:00
1659459805_repo_key_value_pairs Search backend: add support for arbitrary repo key-value pairs (#40112) 2022-08-11 15:17:33 +00:00
1659721548_data_usage_seed_allowlist usage-data: seed allowlist event names (#40034) 2022-08-05 13:13:18 -07:00
1660132915_lsif_uploads_uncompressed_size codeintel: add dashboard for precide-code-intel-worker total in-progress upload size (#39690) 2022-08-11 21:43:14 +01:00
1660312877_add_aggregated_user_statistics_table admin-analytics: optimize user management data layer (#40301) 2022-08-15 13:55:48 +06:00
1660710812_update_reconciler_changeset_view batches: Change git diffstat to (added, deleted) from (added, modified, deleted) (#40454) 2022-09-19 13:57:49 +02:00
1660710916_remove_diff_stat_changed_changeset_specs batches: Change git diffstat to (added, deleted) from (added, modified, deleted) (#40454) 2022-09-19 13:57:49 +02:00
1660711451_remove_diff_stat_changed_changesets batches: Change git diffstat to (added, deleted) from (added, modified, deleted) (#40454) 2022-09-19 13:57:49 +02:00
1660742069_non_null_changeset_spec_type Use normalized changeset spec fields in database (#39471) 2022-08-24 14:59:50 +00:00
1661441160_batch_spec_remote_mounts batches: Remote Mount #1 - Database (#40795) 2022-09-27 07:26:37 -06:00
1661502186_fix_repo_stats_initial_state Repair repo_statistics/gitserver_repos_statistics in migration (#40910) 2022-08-29 09:50:16 +02:00
1661507724_update_repo_stats_trigger_to_avoid_all_zeros repo stats tables: fix migration to only update function (#41038) 2022-08-30 13:23:00 +02:00
1662467128_add_ondemand_autoindexing_queue codeintel: Lazily enqueue crate autoindexing jobs (#41101) 2022-09-16 09:30:25 -05:00
1662636054_autoindexing_custom_inference_script codeintel: add UI for setting auto-indexing inference script (#41517) 2022-10-10 14:21:27 +00:00
1663569995_update_username_valid_chars_contraint Update username constraint to allow underscores (#41723) 2022-09-26 09:00:25 +00:00
1663665519_perforce_merge_includes_excludes_columns [Perforce] Store all rules in one column and apply as last rule takes precedence (#41785) 2022-10-03 15:58:34 +02:00
1663871069_changeset_specs_null_published Normalize draft to "draft" (#43390) 2022-10-25 15:22:56 +02:00
1664300936_move_lsif_upload_reference_count_to_different_table codeintel: Offload reference counts to cold table (#42266) 2022-10-03 16:25:38 -05:00
1664897165_executor_secrets executors: Implement stores for secrets (#43257) 2022-10-24 23:44:15 +02:00
1664988036_create_webhooks_table webhooks: add webhooks table (#42582) 2022-10-06 09:48:01 +01:00
1665056530_autogeneratewebhookid migrations: Auto generated webhook.id column and make it primary key (#42633) 2022-10-06 15:59:42 +02:00
1665138849_addrandidtowebhooks webhooks: Add database Create method (#42639) 2022-10-10 07:31:44 +00:00
1665399117_webhooks_table_uuid_updates webhooks: add delete method of webhooks store. (#42672) 2022-10-10 15:25:31 +01:00
1665420690_persisted_repo_document_ranks ranking: Build basic index for repository path ranks (#42771) 2022-10-12 15:52:09 +00:00
1665477911_add_zoekt_repos_table Add zoekt_repos table, populate it in worker, add endpoint for Zoekt to update (#43289) 2022-10-27 14:07:19 +02:00
1665488828_add_columns_to_webhooks_table webhooks: add created_by_user_id, updated_by_user_id columns to webhooks table. (#42818) 2022-10-12 15:45:22 +01:00
1665524865_add_column_repo_status_to_gitserver_repos_table migrations/frontend: Add column repo_status to gitserver_repos table (#42846) 2022-10-12 05:51:32 +05:30
1665588249_rename_bad_fk_constraint codeintel: Remove API Docs from db schema (#42851) 2022-10-13 21:56:49 +00:00
1665646849_addcounterstoexternalservicesyncjob repos: Persist running repo counts during external service sync. (#42933) 2022-10-17 07:55:03 +00:00
1665770699_add_codeintel_commit_dates codeintel: Fix unique inserts for codeintel_commit_dates (#43131) 2022-10-19 00:45:55 +02:00
1666034720_add_lsif_upload_references_scan_timestamp codeintel: Remove reference counting technique for uploads (#43015) 2022-10-19 13:53:13 +00:00
1666131819_add_lsif_upload_traversal_scan_timestamp codeintel: Expire additional uploads via traversal (#43138) 2022-10-20 08:55:21 -05:00
1666145729_add_lsif_indexes_should_reindex codeintel: Support bulk reindexing of LSIF indexes (#42716) 2022-10-20 16:39:46 -06:00
1666344635_fill_zoekt_repos_table Add zoekt_repos table, populate it in worker, add endpoint for Zoekt to update (#43289) 2022-10-27 14:07:19 +02:00
1666398757_ensure_cancel_column worker: Combine heartbeats and cancellation (#43332) 2022-11-21 19:07:41 +01:00
1666524436_add_missing_state_index_lsif_dependency_indexes worker: Add missing state index to worker tables (#43341) 2022-10-24 14:13:31 +02:00
1666598814_add_missing_state_index_on_lsif_dependency_syncing_jobs_table worker: Add missing state index to worker tables (#43341) 2022-10-24 14:13:31 +02:00
1666598828_add_missing_state_index_on_batch_spec_resolution_jobs_table worker: Add missing state index to worker tables (#43341) 2022-10-24 14:13:31 +02:00
1666598983_add_missing_state_index_on_gitserver_relocator_jobs_table worker: Add missing state index to worker tables (#43341) 2022-10-24 14:13:31 +02:00
1666598987_add_missing_state_index_on_webhook_build_jobs_table worker: Add missing state index to worker tables (#43341) 2022-10-24 14:13:31 +02:00
1666598990_add_fk_to_webhook_logs_table add webhook_id foreign key constraint to webhook_logs table (#43380) 2022-10-25 14:36:17 -06:00
1666717223_add_codeintel_ranking_exports_table ranking: Export CSV graph from LSIF data (#43334) 2022-10-26 08:36:51 -05:00
1666886757_add_event_logs_user_id_timestamp_index [db] add index for event logs table user_id_timestamp (#43564) 2022-10-28 09:01:26 +00:00
1666904087_add_codeintel_path_rank_inputs_table ranking: Consume PageRank scores (#43566) 2022-10-28 10:14:20 -05:00
1666939263_add_index_on_event_logs_user_id_name Add index on event_logs(user_id, name) (#43582) 2022-10-28 07:02:23 +00:00
1667220502_add_precision_to_codeintel_path_ranks ranking: Improve ranking results (#43613) 2022-10-31 09:10:42 -05:00
1667220626_rename_codeintel_path_ranks_key migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1667220628_update_codeintel_path_ranks_unique_constraint_to_include_precision ranking: Improve ranking results (#43613) 2022-10-31 09:10:42 -05:00
1667220768_add_precision_to_codeintel_path_rank_inputs ranking: Improve ranking results (#43613) 2022-10-31 09:10:42 -05:00
1667222952_add_codeintel_ranking_timestamps ranking: Expose last updated timestamps (#43650) 2022-10-31 16:01:08 +00:00
1667259203_add_graph_key_to_codeintel_path_ranks ranking: Do not treat path ranks as append only (forever) (#43728) 2022-11-01 13:07:47 +00:00
1667313173_add_index_to_lsif_uploads_visible_at_tip codeintel: Add partial index to lsif_uploads_visible_at_tip (#43751) 2022-11-01 15:06:49 +00:00
1667395984_remove_filter_from_lsif_references codeintel: Remove unused filter column (#43806) 2022-11-02 08:49:36 -05:00
1667433265_add_last_reconcile_to_lsif_uploads_table codeintel: Add job to reconcile lsif_uploads records with missing codeintel-db data (#43838) 2022-11-04 07:47:19 -05:00
1667497565_fix_cascade_behavior_for_codeintel_ranking_exports ranking: Fix cascade behavior on codeintel_ranking_exports (#43895) 2022-11-05 10:15:51 -05:00
1667500111_fix_codeintel_path_ranks_trigger_condition codeintel: Fix overeager trigger (#43894) 2022-11-03 19:16:15 +00:00
1667825028_add_ssbc_execution_v2_flag Experiment: Natively run SSBC in docker (#44034) 2022-11-10 00:20:43 +01:00
1667848448_flip_index_field_order ranking: Merge by repository name to reduce number of fragmented updates (#44041) 2022-11-07 19:36:23 +00:00
1667863757_drop_old_index ranking: Drop unused index (#44052) 2022-11-07 23:46:26 +00:00
1667917030_fix_codeintel_ranking_exports_index_order ranking: Improve index (#44087) 2022-11-08 16:07:52 +01:00
1667950421_speed_up_listsourcegraphdotcomindexablerepos perf: Better optimize ListSourcegraphDotComIndexableRepos (#44129) 2022-11-09 14:46:33 +00:00
1667952974_speed_up_listsourcegraphdotcomindexablerepos_part_2 perf: Better optimize ListSourcegraphDotComIndexableRepos (#44129) 2022-11-09 14:46:33 +00:00
1668174127_add_gitserver_repos_last_changed_idx search: Speed up repo list (#44262) 2022-11-11 14:01:05 +00:00
1668179496_add_event_logs_name_timestamp event_logs: Create better name/timestamp index (#44292) 2022-11-11 17:16:57 +00:00
1668179619_drop_redundant_index event_logs: Create better name/timestamp index (#44292) 2022-11-11 17:16:57 +00:00
1668184279_remove_git_status_column_from_gitserver_repos_table Adds migration to remove repo_status from gitserver_repos (#44299) 2022-11-11 17:34:06 +00:00
1668603582_add_gitserverrepo_size_bytes_index Make repos sortable by size (#44360) 2022-11-17 15:45:38 +00:00
1668707631_add_unique_constraint_batch_specs_rand_id batches: add unique constraint {batch, changeset}_spec rand ids (#44601) 2022-11-28 20:15:34 +01:00
1668767882_add_unique_constraint_changeset_specs_rand_id batches: add unique constraint {batch, changeset}_spec rand ids (#44601) 2022-11-28 20:15:34 +01:00
1668808118_temp_codeinsights_trace_with_query insights: add trace id to queued query record (#44626) 2022-11-18 16:17:27 -08:00
1668813365_create_search_contexts_stars_defaults search contexts: backend for setting as default and starring (#44624) 2022-12-05 11:22:35 -08:00
1669184869_add_name_to_webhooks_table webhooks: add name column to webhooks table. (#44756) 2022-11-23 17:17:14 +04:00
1669297489_add_permission_sync_jobs Add feature-flagged database-backed permission sync worker (#44796) 2023-01-13 12:33:40 +01:00
1669576792_make_batch_spec_of_batch_change_nullable batches: partially revert making batch_spec_id nullable on batch change (#46341) 2023-01-13 10:31:54 -08:00
1669645608_make_batch_change_name_pattern Make draft batch change explicit in database (#44840) 2022-12-14 01:41:47 +00:00
1669836151_add_manager_to_lsif_packagereferences codeintel: Add manager to monikers/package information (#44958) 2022-11-30 14:26:58 -06:00
1670256530_add_content_type_to_lsif_uploads codeintel: Tag content type on precise code intel uploads (#45187) 2022-12-05 12:10:39 -06:00
1670350006_add_should_reindex_to_lsif_uploads [language-platform] adding should_reindex column to lsif_uploads (#45298) 2022-12-12 10:47:08 -07:00
1670539388_create_roles_table create roles and permissions table (#45462) 2022-12-09 20:11:35 +01:00
1670539913_create_permissions_table create roles and permissions table (#45462) 2022-12-09 20:11:35 +01:00
1670542168_create_user_roles_table Create join table for (user & roles) and (roles & permissions) (#45463) 2022-12-09 22:35:19 +01:00
1670543231_create_role_permissions_table Create join table for (user & roles) and (roles & permissions) (#45463) 2022-12-09 22:35:19 +01:00
1670600028_executor_secrets_accesslogs_codeintel_user codeintel: first implementation of auto-indexing secrets (#45580) 2022-12-15 22:32:16 +00:00
1670870072_add_read_only_column_roles Add readonly column to roles table (#45577) 2022-12-13 15:21:55 +01:00
1670934184_add_gitserver_corruption_columns migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1671159453_outbound_webhooks database: add outbound webhook tables (#46007) 2023-01-17 16:08:40 -08:00
1671463799_teams Implement database stores for teams (#46936) 2023-01-27 19:24:15 +00:00
1671543381_add_default_roles rbac: order columns for migration (#48001) 2023-02-21 16:26:19 -08:00
1672884222_create_namespace_permissions_table rbac: create table for namespace permissions (#46159) 2023-01-05 19:14:32 +01:00
1672897105_add_column_author_user_id_to_critical_and_site_config internal: Persist author in site config (#46150) 2023-01-09 12:14:06 +05:30
1673019611_lsif_uploads_audit_logs_bigint_upload_size codeintel: bring audit logs upload_size type in-line with lsif_uploads table (#46209) 2023-01-09 07:34:00 -06:00
1673351808_add_repo_corruption_stat repos: Add corrupted to repos statistics (#46410) 2023-01-16 16:36:23 +02:00
1673405886_make_batch_spec_of_batch_change_not_nullable_again batches: partially revert making batch_spec_id nullable on batch change (#46341) 2023-01-13 10:31:54 -08:00
1673871310_add_columns_to_permission_sync_jobs_table permissions-center: add reason and triggered_by_user_id columns to permission_sync_jobs table. (#46500) 2023-01-16 19:43:40 +04:00
1673897709_add_cascade_batch_spec_resolution_jobs batches: add delete cascade to foreign key constraint on batch_spec_resolution_jobs.initiator_id column (#46549) 2023-01-17 18:20:04 +01:00
1674035302_remove_webhook_build_jobs_table db: Migration to remove webhook_build_jobs table (#46625) 2023-01-23 11:17:29 +01:00
1674041632_add_constraints_to_permission_sync_jobs_table permissions-center: implement perms sync deduplication logic. (#46656) 2023-01-19 21:26:47 +04:00
1674047296_rename_roles_readonly_column_to_system rbac: add default roles to database and map existing users to roles (#45854) 2023-01-19 14:33:47 +01:00
1674455760_add_cancellation_reason_to_permission_sync_jobs_table migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1674480050_add_column_redacted_contents_to_critical_and_site_config Store redacted site config in DB (#46781) 2023-01-24 06:40:40 +00:00
1674642349_add_priority_to_permission_sync_jobs [Permissions] add numeric priority and fix order for sync worker dequeue (#46804) 2023-01-25 16:57:48 +05:30
1674669326_package_repos_separate_versions_table Packages: expose listing of package repo information in graphql (#47105) 2023-02-02 18:54:03 +00:00
1674669794_add_foreign_keys_to_permission_sync_jobs [Permissions] add foreign keys for subjects to sync jobs table (#46955) 2023-01-26 14:09:43 +05:30
1674754280_executor_job_tokens Executor Job Specific Tokens (#46792) 2023-02-28 18:40:22 +00:00
1674814035_add_unified_source_perms_table Add new src_permissions table to unify repository permissions (#47086) 2023-02-02 11:39:31 +00:00
1674952295_make_user_id_namespace_permissions_non_nullable rbac: make user_id field in namespace_permissions non-nullable (#47114) 2023-01-30 22:02:13 +01:00
1675155867_add_no_perms_column_to_permission_sync_jobs_table permissions-center: add no_perms column to permission_sync_jobs table. (#47164) 2023-01-31 09:53:12 +00:00
1675194688_fix_should_reindex_in_views codeintel: Collapse indexes and upload pages together (#46692) 2023-02-01 09:58:52 -07:00
1675257827_redis_key_value redispool: use postgres for redispool.Store in App (#47188) 2023-02-03 12:59:05 +00:00
1675277218_add_lsif_uploads_uploaded_at_id codeintel: Add useful indexes (#47286) 2023-02-01 19:22:44 +00:00
1675277500_drop_lsif_uploads_uploaded_at codeintel: Add useful indexes (#47286) 2023-02-01 19:22:44 +00:00
1675277968_drop_lsif_indexes_queued_at codeintel: Add useful indexes (#47286) 2023-02-01 19:22:44 +00:00
1675296942_add_column_to_changesets_for_external_fork_name batches: retain external fork name (#47397) 2023-02-13 13:35:55 -08:00
1675367314_add_results_to_permission_sync_jobs [Permissions] records result of added, removed and found permissions (#47354) 2023-02-03 14:16:45 +05:30
1675647612_remove_roles_deleted_at rbac: remove deleted_at from roles column (#47411) 2023-02-09 04:24:39 +01:00
1675850599_add_access_requests_table Add "request access" experimental feature (#47741) 2023-02-27 13:25:44 +03:00
1675864432_add_code_host_states_to_permission_sync_jobs_table permissions-center: add code_host_states to permission_sync_jobs. (#47461) 2023-02-13 12:08:38 +01:00
1675962678_remove_action_namespace_perms migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1676272751_add_repo_embedding_jobs embeddings: searcher and indexer (#48017) 2023-03-01 10:50:12 +01:00
1676328864_add_cached_available_indexers codeintel: Add global code intel status store methods (#47815) 2023-02-17 13:13:38 -06:00
1676420496_frontend migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1676584791_add_index codeintel: Add global code intel status store methods (#47815) 2023-02-17 13:13:38 -06:00
1676996650_package_repos_separate_versions_table_patch1 packages: fix parent migration number for patch migration (#47993) 2023-02-21 20:45:35 +00:00
1677003167_package_repos_separate_versions_table_stage2 migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1677005673_add_codeintel_rank_defintions_and_references ranking: Finalize v1 backend (vacuum+observability) (#48059) 2023-02-23 12:39:30 -06:00
1677008591_add_codeintel_rank_path_counts_inputs [rank] adds path count table for ranking (#47994) 2023-02-21 14:52:06 -07:00
1677073533_add_codeowners_table own: add database schema and store for codeowners manual ingestion (#47905) 2023-02-23 03:19:51 -08:00
1677104938_move_processed_flag_out_of_references_table ranking: Finalize v1 backend (vacuum+observability) (#48059) 2023-02-23 12:39:30 -06:00
1677166643_package_repos_allowblock_lists packages: allow-/block-list package repos [backend] (#48037) 2023-03-08 14:56:22 +00:00
1677242688_add_triggers_for_soft_deleted_perms_entities [feat] Adding a few DB triggers to delete permissions when items are soft deleted (#48189) 2023-02-27 09:29:26 +01:00
1677483453_add_auto_upgrade_to_versions add auto_upgrade column to versions table (#48260) 2023-03-02 10:38:30 -08:00
1677594756_add_better_index_to_ranking_path_counts_table ranking: Optimize reduce query (#48361) 2023-02-28 16:24:04 +00:00
1677607213_add_indexes_on_access_requests_create_at_and_status_columns [Request access] Add pings (#48026) 2023-03-02 11:39:33 +03:00
1677627515_add_scan_column_to_ranking_definitionsreferences ranking: Do incremental vacuuming, not all-or-nothing deletes (#48385) 2023-02-28 18:54:36 -06:00
1677627559_add_index_to_definition_scan_column ranking: Do incremental vacuuming, not all-or-nothing deletes (#48385) 2023-02-28 18:54:36 -06:00
1677627566_add_index_to_reference_scan_column ranking: Do incremental vacuuming, not all-or-nothing deletes (#48385) 2023-02-28 18:54:36 -06:00
1677694168_add_vulnerability_tables sentinel: Draft table schemas (#48478) 2023-03-01 19:14:14 +00:00
1677694170_add_vulnerability_match_tables sentinel: Draft table schemas (#48478) 2023-03-01 19:14:14 +00:00
1677700103_add_access_requests_decision_by_user_id_column [Request access] Add capturing of decision maker admin user id (#48496) 2023-03-02 12:31:39 +03:00
1677716184_add_columns_for_ranking_statistics ranking: Update API for document ranks (#48387) 2023-03-03 09:23:07 -08:00
1677716470_add_trigger_for_ranking_statistics ranking: Update API for document ranks (#48387) 2023-03-03 09:23:07 -08:00
1677803354_add_vulnerability_scan_log_table sentinel: Vulnerability matcher routine (#48582) 2023-03-03 10:20:58 -06:00
1677811663_make_team_creator_nullable teams: Allow creator to manage team (#48597) 2023-03-03 12:42:47 +01:00
1677878270_eric_is_bad_at_math ranking: Fix log(0) (#48655) 2023-03-03 21:56:26 +00:00
1677944569_drop_unused_types chore: Remove unused Postgres types (#48674) 2023-03-06 07:39:17 -06:00
1677944752_drop_unused_lockfiles_tables migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1677945580_drop_unused_ranking_table chore: Remove unused ranking table (#48675) 2023-03-06 14:15:25 +00:00
1677955553_update_ranking_repo_relations ranking: Simplify repository name usage in codeintel_ranking_ tables (#48677) 2023-03-06 14:24:14 +00:00
1677958359_simplify_path_ranks_table ranking: Cleanup path ranks table (#48678) 2023-03-06 07:38:50 -06:00
1678091683_add_migrated_column_to_user_permissions [feat] Prepare for permissions data model oob migration (#48709) 2023-03-06 11:21:44 +00:00
1678112318_add_external_accounts_scim_index SCIM: Add "is SCIM controlled" flag to site user, and "SCIM" badge on UI (#48727) 2023-03-07 14:15:39 +00:00
1678175532_index_github_topics Search: add repo:has.topic() predicate (#48875) 2023-03-09 15:48:05 -07:00
1678213774_sg_telemetry_allowlist Add setup wizard metrics/pings (#48782) 2023-03-09 15:01:50 -03:00
1678214530_fix_indexes_on_ranking_tables migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1678220614_sg_telemetry_allowlist Add setup wizard metrics/pings (#48782) 2023-03-09 15:01:50 -03:00
1678290792_drop_unused_index_event_logs_user_id Drop unused index on event_logs table (#48923) 2023-03-08 19:31:59 +01:00
1678291091_drop_unused_indexes_for_batch_changes_rand_id_columns Drop unused indexes on batch_changes rand_id columns (#48925) 2023-03-08 19:32:14 +01:00
1678291402_drop_unused_index_on_user_repo_permissionsuser_id Drop unused index on user_repo_permissions table (#48926) 2023-03-08 19:32:27 +01:00
1678291831_drop_unused_index_package_repo_versions_fk_idx Drop unused index on user_repo_permissions table (#48927) 2023-03-08 21:41:51 +01:00
1678320579_normalize_webhook_urns incoming webhooks: normalize webhook configuration URNs (#48968) 2023-03-09 10:10:32 -08:00
1678380933_comment_on_topic_index Search: add repo:has.topic() predicate (#48875) 2023-03-09 15:48:05 -07:00
1678409821_package_repos_missing_indexes packages: misc postgres performance + correctness improvements (#49063) 2023-03-10 14:25:45 +00:00
1678456448_make_role_name_citext migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1678601228_sg_telemetry_allowlist Add user management event logging (#49174) 2023-03-13 17:21:14 +00:00
1678832491_remove_sg_jsonb_concat_agg Ranking: replace custom aggregate with jsonb_object_agg (#49350) 2023-03-14 23:11:46 +00:00
1678899992_add_codeintel_ranking_paths [ranking] Adding initial path counts (#49343) 2023-03-16 11:46:54 -06:00
1678994673_package_repos_last_checked_at_index fixing stitch migration drift from backport-49550-to-5.0 (#49655) 2023-03-17 17:31:57 -07:00
1679058200_upsize_codeintel_ranking_references_processed_datatype migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1679404397_add_missing_index_for_vacuum ranking: Perf pass (#49763) 2023-03-21 11:29:09 -05:00
1679426934_soft_deleted_repository_name_reconciling_names Repo Delete always updates deleted_at and name (#49786) 2023-03-22 20:14:32 +00:00
1679428966_speed_up_deletes_from_ranking_table Add index to speed up deletions from codeintel_ranking_references (#49799) 2023-03-21 21:32:45 +01:00
1679432506_speed_up_deletes_from_cm_trigger_jobs Speed up deletes from cm_trigger_jobs table (#49804) 2023-03-21 22:23:36 +01:00
1679603787_keep_cloning_progress_in_gitserver_repos Cloning progress updates in the database (#49933) 2023-03-24 16:51:54 +00:00
1679690266_batch_initial_path_counts codeintel: Reduce row count for initial path ranks (#49984) 2023-03-27 09:26:12 -05:00
1680088638_add_is_partial_success_to_permission_sync_jobs permissions-center: add is_partial_success permissions sync job property. (#50114) 2023-03-30 16:55:06 +04:00
1680296731_package_repos_package_name_regex_match packages: move filter matching to postgres for name filter membership testing (#49940) 2023-06-16 16:46:45 +00:00
1680707560_sg_telemetry_allowlist fix migration parents for 5.0 backport (#50400) 2023-04-05 21:30:07 +02:00
1681300431_ownership_signals own: database and stores for aggregate recent contributors signal (#50947) 2023-04-26 15:02:06 -07:00
1681807446_add_github_apps_table Add DB store for github apps (#50796) 2023-04-20 11:38:22 +02:00
1681923094_sg_telemetry_allowlist Add Cody events to managed instance usage data pipeline allowlist (#50865) 2023-04-19 10:17:17 -07:00
1681982430_user_completions_quota Implement rate limiting for completions API (#50925) 2023-04-21 13:09:20 +00:00
1682012624_own_background_jobs own: basic auto-indexing for background signal calculations (#50951) 2023-04-24 14:15:19 -07:00
1682114198_product_license_access_tokens dotcom: add subscription-based license tokens (#51074) 2023-04-27 20:48:28 +00:00
1682598027_add_github_app_installations_table feat: add support for multiple github app installations (#51341) 2023-05-03 12:57:33 +02:00
1682604499_add_softdelete_timestamp_to_ranking_exports ranking: Make map and reduce steps atomic and non-continuous (#51214) 2023-05-09 17:00:06 -05:00
1682626931_subscription_llm_proxy_state dotcom: add llm-proxy access state (#51242) 2023-05-01 13:08:01 -07:00
1682683129_add_recent_view_ownership_signal own: add own_aggregate_recent_view table for recent view signal processing (#51293) 2023-05-04 20:46:00 +04:00
1682967255_add_ranking_graph_key_table ranking: Make map and reduce steps atomic and non-continuous (#51214) 2023-05-09 17:00:06 -05:00
1683053825_sg_telemetry_allowlist remove events SearchSubmitted, AccessRequest... from managed Instance allowList (#51379) 2023-05-03 14:07:42 +00:00
1683246005_llmproxynoaccesstokenenable Add subscription UIs for Cody services (#51524) 2023-05-09 02:36:12 +02:00
1683290474_user_code_completions_quota Use second rate limit bucket for code completions (#51514) 2023-05-05 17:15:32 +00:00
1683295546_add_app_url_column_for_github_apps [github apps] Add app_url to github_apps table (#51518) 2023-05-05 14:41:53 +00:00
1683561153_add_autoindexing_repo_exceptions_table codeintel: Add blocklist for autoindexing (#51578) 2023-05-09 16:35:51 -05:00
1683593618_add_table_for_storing_the_most_recent_output_from_gitserver_clones Address issue 51236 by storing the most recent output (#51598) 2023-06-15 21:42:37 +00:00
1683640362_expand_ranking_unique_key ranking: Make map and reduce steps atomic and non-continuous (#51214) 2023-05-09 17:00:06 -05:00
1683641757_sg_telemetry_allowlist friction allowlist (#51812) 2023-05-11 12:36:31 -04:00
1683670271_remove_ranking_object_prefix ranking: Optimize deletion of exported records (#51681) 2023-05-12 14:07:08 -05:00
1683670735_move_deleted_fields_for_ranking migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1683753933_move_upload_relation_in_ranking_export_data migrations: Add CI check detecting drift on downgrade (#52098) 2023-05-17 15:44:19 -05:00
1683782561_githubappwebhooks [github app] Allow webhook connection (#51769) 2023-05-11 12:00:41 +02:00
1683913757_add_ranking_progress_columns ranking: Show progress in UI (#51888) 2023-05-17 20:55:00 +00:00
1683924275_own_signal_state own: admin management page for inference signals (#51756) 2023-05-17 12:58:29 -07:00
1684180461_sg_telemetry_allowlist add events to allowList for Event level data (#51944) 2023-05-16 15:35:06 -07:00
1684207923_embeddings_proxy codygateway: Initial implementation of embeddings API (#52810) 2023-06-07 02:33:54 +02:00
1684217409_create_assigned_owners_table own: add assigned_owners table with insert and list functions. (#51981) 2023-05-16 19:46:41 +04:00
1684248574_upsize_id_columns codeintel: Fix ranking column size (#52010) 2023-05-16 16:27:31 +00:00
1684306784_make_assigned_owners_index_nonunique own: support deletion of assigned owners. (#52060) 2023-05-17 13:30:30 +02:00
1684396562_add_table_repo_commits_changelists database: Add table repo_commits_changelists to map perforce changelist IDs (#51872) 2023-05-22 14:31:03 +05:30
1684398004_drop_github_app_installs_table [github apps] drop github_app_installs table as it's unused (#52136) 2023-05-18 10:43:01 +00:00
1684429687_own_signal_config_view own: integrate signal configurations into resolvers and indexers (#52179) 2023-05-19 10:56:47 -07:00
1684632550_simplify_mapper_max_id codeintel: Simplify ranking max id comparison (#52240) 2023-05-22 07:59:19 -05:00
1684753192_set_repo_meta_empty_values_to_null (feat) add autocompletion for repo meta creation page (#51982) 2023-05-23 13:54:11 +06:00
1684771948_add_domain_to_github_app batches: implement commit signing via GitHub apps (#52333) 2023-06-14 11:12:15 -07:00
1684831743_switch_to_bigserial_on_user_repo_permissions_table [fix] switch id column of user_repo_permissions table to bigint (#52299) 2023-05-23 12:21:23 +00:00
1684854090_add_embeddings_to_policies embeddings: Extend policies from code intel (#52326) 2023-05-25 16:56:03 +02:00
1684854389_llm_proxy_separate_rate_limits Implement features in LLM Proxy layer (#52472) 2023-05-26 20:07:37 +00:00
1684858266_add_queuenames_column_to_executor_heartbeat Executors: enable dequeueing and heartbeating for multiple queues (#52016) 2023-06-04 13:25:05 +00:00
1684933018_add_ranking_mapper_index ranking: Optimize mapper select (#52362) 2023-05-24 15:52:17 +00:00
1685103392_add_ranking_export_hash_key ranking: Background job improvements (#52502) 2023-05-26 16:23:26 +00:00
1685105270_simplify_ranking_reducer_table ranking: Background job improvements (#52502) 2023-05-26 16:23:26 +00:00
1685453088_create_github_apps_install_tables batches: implement commit signing via GitHub apps (#52333) 2023-06-14 11:12:15 -07:00
1685495400_rename_llm_proxy_to_cody_gateway cody-gateway: rename llm_proxy DB components to cody-gateway (#52665) 2023-06-01 09:28:41 -07:00
1685525992_add_license_fields_to_support_auto_billing [license-checks] add new fields to product_licenses table (#52761) 2023-06-02 09:16:55 +02:00
1685562535_add_missing_ranking_index ranking: Fix missing index (#52721) 2023-05-31 20:04:40 +00:00
1685570436_add_ranking_graph_key_table ranking: Store current graph key in database (#52737) 2023-06-01 10:24:27 -05:00
1685645480_normalize_base_url batches: implement commit signing via GitHub apps (#52333) 2023-06-14 11:12:15 -07:00
1685695443_codeowners_stats_and_counts Database and repos for ownership analytics (#52832) 2023-06-05 07:20:02 +00:00
1685697346_add_unique_constraint_to_assigned_owners own: add a unique constraint so that it's impossible to create a duplicate owner for same user+path. (#52830) 2023-06-02 18:30:55 +04:00
1685712730_add_own_analytics_setting GraphQL API and UI for ownership analytics (#52854) 2023-06-05 10:45:31 +00:00
1685727930_junk_cleanup ranking: Fix junk in processed tables (#52876) 2023-06-06 14:10:24 +00:00
1685983690_make_path_count_inputs_unique_by_definition_id ranking: Make counts per definition unique (#52949) 2023-06-06 23:05:05 +00:00
1685984018_drop_duplicate_index ranking: Make counts per definition unique (#52949) 2023-06-06 23:05:05 +00:00
1685999719_add_additional_progress_tracking_for_ranking_mapper ranking: Lessen quadratic search behavior (#52964) 2023-06-06 23:53:58 +00:00
1686042710_add_assigned_teams_table own: add assigned_teams table and store. (#52997) 2023-06-06 14:50:20 +04:00
1686169273_add_verification_to_changesets batches: Surface commitVerification and tag verified to signed commits (#53135) 2023-06-16 09:48:26 -07:00
1686169626_add_stats_to_embeddings_jobs Embeddings: add progress updates during indexing (#53202) 2023-06-13 11:24:04 -06:00
1686208766_add_revoke_reason_to_product_licenses_table [license-checks] revoke license graphql endpoint + add revoke reason (#53146) 2023-06-08 15:07:28 +02:00
1686255261_add_own_analytics_setting_again Analytics background worker - counts & codeowners (#53150) 2023-06-09 12:58:52 +00:00
1686282228_add_installation_metadata batches: implement commit signing via GitHub apps (#52333) 2023-06-14 11:12:15 -07:00
1686287028_add_unique_github_app_install_constraint batches: implement commit signing via GitHub apps (#52333) 2023-06-14 11:12:15 -07:00
1686415661_change_product_subscriptions_cody_gateway_limits_to_int64 dotcom: migrate Cody Gateway rate limit to int64 (#53290) 2023-06-16 12:02:56 -04:00
1686580819_store_symbols_as_bytes ranking: Reduce symbol storage (#53310) 2023-06-12 18:34:49 -03:00
1686723014_own_analytics_assigned_ownership Assigned ownership path stats migration (#53439) 2023-06-14 09:24:28 +00:00
1686749117_add_last_indexed_at_to_zoekt_repos zoektrepos: Store last_indexed_at (#53480) 2023-06-14 17:37:44 -05:00
1687792857_generate_license_token_for_existing_v1_product_licenses [license-checks] Add migration to generate license_check_token (#54186) 2023-06-27 11:37:54 +02:00
1688649829_user_completed_post_signup graphql api: add user.completedPostSignup and setCompletedPostSignup (#54676) 2023-07-07 12:17:09 +02:00
1689176578_add_new_fields_to_event_logs_table Update event log structure (#55126) 2023-07-24 11:05:39 -07:00
1689692530_add_column_pool_repo_id_to_gitserver_repos gitserver: Introduce pool_repo_id and make AddrForRepo stateful (#55001) 2023-07-19 22:34:43 +05:30
1689886483_sg_telemetry_allowlist search: add events to simple search prototype (#55176) 2023-07-21 21:21:46 +00:00
1689942733_drop_path_includes_path_excludes_columns_from_sub_repo_permissions perforce: remove legacy path_includes and path_excludes columns. (#55195) 2023-07-21 18:56:51 +04:00
1690323910_add_chunks_excluded_embeddings_stats Update exclude chunks migration metadata to align with 5.1 release branch (#55528) 2023-08-02 11:51:14 -07:00
1690401277_exhaustive_search_jobs exhaustive: Add job workers (#55587) 2023-08-17 12:20:37 -06:00
1690460411_add_code_hosts_table Introduce code_hosts table (#55399) 2023-07-28 14:20:20 +00:00
1691043630_event_logs_indexing Add no-op migration to replace removed migration (#56207) 2023-08-24 17:52:39 +00:00
1691485365_sg_telemetry_allowlist Add cody web events to allowlist (#55635) 2023-08-18 22:27:00 +05:30
1691595214_autoindexing_manual_priority codeintel: prioritize manual autoindexing jobs (#55745) 2023-09-11 06:48:34 +00:00
1691759644_autoindexing_manual_priority_index codeintel: prioritize manual autoindexing jobs (#55745) 2023-09-11 06:48:34 +00:00
1692053282_content_library_onboarding_tour onboarding-tour: barebones json gql operations (#55849) 2023-08-16 15:22:24 -07:00
1692227847_make_stats_use_a_bigint Embeddings: make stats table use a bigint for bytes (#55949) 2023-08-16 23:58:22 +00:00
1692815296_delete_pool_repo Revert artifacts from git deduplication work (#56185) 2023-08-24 15:14:30 +02:00
1693825517_exhaustive_search_jobs_remove_constraint search jobs: remove constraint (#56348) 2023-09-05 10:03:08 +02:00
1694806099_add_telemetryeventsexportqueuestore telemetry: init internal APIs and events cache store layer (#56520) 2023-09-19 21:53:42 -07:00
1695152835_add_index_for_upload_indexers codeintel: Improve GetIndexers method (#56801) 2023-11-22 10:47:08 +00:00
1695152902_add_index_for_index_indexers codeintel: Improve GetIndexers method (#56801) 2023-11-22 10:47:08 +00:00
1695747321_remove_drift chore: Remove indexes that existed for a short time (#57054) 2023-09-26 17:24:40 +00:00
1695911110_remove_namespaced_external_services Remove unused user_id and org_id fields on external services and repos (#57271) 2024-02-20 16:35:59 +01:00
1695911128_remove_namespace_from_external_services Remove unused user_id and org_id fields on external services and repos (#57271) 2024-02-20 16:35:59 +01:00
1696003224_sg_telemetry_allowlist [telemetry] Add onboarding tour related events to allow list (#57199) 2023-09-30 18:10:29 +02:00
1697220815_add_creator_and_updater_to_external_services Add creator_id and last_updater_id to external_services (#57603) 2023-12-01 11:16:13 -08:00
1697489421_add_gitlab_topics Search: enable repo:has.topic() for GitLab (#57649) 2023-10-19 20:46:56 +00:00
1697535944_drop_users_tags_column Remove tags column from users table (#57660) 2023-10-19 06:27:25 +00:00
1697558292_comment_on_gitlab_topic_idx Search: enable repo:has.topic() for GitLab (#57649) 2023-10-19 20:46:56 +00:00
1697750425_topic_column Clean up querying of repository topics (#57755) 2023-10-25 11:58:10 -06:00
1697752805_index_topics_column Clean up querying of repository topics (#57755) 2023-10-25 11:58:10 -06:00
1697754648_drop_old_repo_topic_indexes Clean up querying of repository topics (#57755) 2023-10-25 11:58:10 -06:00
1698068529_make_repo_fork_false_by_default [UX] Move code host connection warnings and warn about unauthorized connections (#57766) 2023-10-30 11:04:12 +00:00
1698772485_sg_telemetry_allowlist add events to allowlist (#58019) 2023-10-31 15:10:56 -04:00
1698836192_add_cody_pro_enabled_at_to_users [Cody PLG] add mutation & gql field to upgrade users to Cody Pro (#58074) 2023-11-03 17:04:13 +05:30
1700613818_add_embeddings_jobs_index Embeddings: fix low-hanging issues with scheduling job (#58510) 2023-11-27 12:03:56 +01:00
1700645180_turn_gitserver_repos_statistics_into_append_only database: make gitserver_repos_statistics append-only (#58496) 2023-11-23 15:36:58 +01:00
1702500918_add_expiry_to_access_tokens Implement expiry for access tokens (#59565) 2024-01-18 18:54:07 -05:00
1706629185_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706629265_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706629302_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706629338_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706629375_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706629467_sg_telemetry_allowlist Search Results: Add telemetry for the new search result page UI (preview and filters panels) (#59985) 2024-01-31 12:15:16 -03:00
1706710430_add_syntactic_scip_indexes_table Syntactic indexing: add database schema and dbworker (#60055) 2024-02-08 18:00:21 +00:00
1707759188_drop_user_searchable Drop unused users.searchable DB column (#60429) 2024-02-14 15:09:55 +01:00
1708596613_access_tokens_double_hash_index Add double hash index for CodyGatewayDotcomUserByToken (#60695) 2024-02-22 13:05:13 +01:00
1709738515_add_syntactic_indexing_support_to_policies Extract reposcheduler and add support for syntactic indexes (#60958) 2024-04-02 11:37:30 +01:00
1711003437_remove_feature_flag_foreign_key Feature flags: relax some constraints (#61343) 2024-03-25 10:39:01 -06:00
1711538234_code_monitors_add_column_for_structured_logging code monitors: don't fail job if repo empty (#61367) 2024-04-02 09:30:59 +02:00
1713958707_search_jobs_add_index_on_state_col search jobs: add index on state column (#62145) 2024-04-25 09:17:09 +02:00
1717699555_fix_unique_index_for_scim_external_account_connection scim: Fix user updates when SCIM was previously enabled (#63135) 2024-06-06 22:24:00 +02:00
1719214941_notebooks_add_field_pattern_type notebooks: store default pattern type per notebook (#63472) 2024-07-01 10:45:46 +02:00
1719498032_add_github_app_batch_changes_site_credential feat: introduce database fields for github apps <-> batch changes integration, and update database layer (#63577) 2024-07-02 06:12:56 -05:00
1719498091_add_github_app_id_user_credentials feat: introduce database fields for github apps <-> batch changes integration, and update database layer (#63577) 2024-07-02 06:12:56 -05:00
1719498128_add_kind_column_github_app feat: introduce database fields for github apps <-> batch changes integration, and update database layer (#63577) 2024-07-02 06:12:56 -05:00
1719555230_deprecate_saved_searches_notifs various improvements to saved searches (#63539) 2024-07-15 20:12:34 +00:00
1719691538_add_prompts Prompt Library (#63872) 2024-07-18 16:04:55 -07:00
1720165387_notebooks_default_to_keyword_search notebooks: set default pattern type to keyword (#63662) 2024-07-09 09:36:20 +02:00
1720651147_add_ips_to_sub_repo_perms_table feature/db/sub_repo_perms: add IPs column to sub repo perms (#63771) 2024-07-18 12:54:54 -07:00
1721251474_create_gin_index_for_regex_kvps Search: add regex support to repo:has.meta() (#63891) 2024-07-19 11:53:24 -06:00
1721281606_saved_searches_metadata add saved search visibility, draft, and timestamps (#63909) 2024-07-18 13:37:41 -07:00
1721814902_github_app_creator_id fix(batches): switch github app installation handling from redirect flow to webhooks (#64036) 2024-07-26 11:53:34 +00:00
1722348497_exhaustive_search_jobs_add_column chore(search_jobs): add janitor job (#64186) 2024-08-01 15:29:10 +02:00
1722961262_add_tenants_table tenant: Introduce tenant table to frontend database (#64322) 2024-08-08 12:03:52 +02:00
1723016879_add_tenant_id_to_most_tables migrations: avoid duplicate foreign key constraints when tenant_id re-run (#64465) 2024-08-14 16:57:32 +02:00
1723557836_faster_soft_delete_trigger_for_permissions migrations: commit between table locks and use when condition for triggers (#64462) 2024-08-14 15:38:35 +02:00
BUILD.bazel bzl: rework migration schemas generation (#57511) 2023-10-10 17:19:47 +02:00
squashed.sql migrations: avoid duplicate foreign key constraints when tenant_id re-run (#64465) 2024-08-14 16:57:32 +02:00