%syntax-version=1.0.0 %project=guix-data-service %uri=https://git.cbaines.net/guix/data-service/ appschema 2019-04-13T11:43:59Z Christopher Baines # Add schema for the Guix Data Service buildstatus_enum [appschema] 2019-04-13T11:56:37Z Christopher Baines # Creates the buildstatus enum initial_import 2019-04-13T13:06:28Z Christopher Baines # Import the manually managed database schema git_repositories 2019-05-04T19:03:38Z Christopher Baines # Add a git_repositories table git_branches 2019-05-05T14:53:12Z Christopher Baines # Add a git_branches table remove_package_metadata_sha1_hash 2019-05-12T10:37:40Z Christopher Baines # Remove the sha1_hash field from package_metadata add_location_information 2019-05-12T20:27:48Z Christopher Baines # Add locations table and location to package_metadata add_git_repositories_cgit_url_base 2019-05-13T18:45:14Z Christopher Baines # Add cgit_url_base to git_repositories license_support 2019-05-13T20:37:40Z Christopher Baines # Add support for storing license information dates_to_load_new_guix_revision_jobs 2019-06-02T07:39:49Z Christopher Baines # Add dates to the load_new_guix_revision_jobs table load_new_guix_revision_job_events 2019-06-02T15:44:41Z Christopher Baines # Add new table for guix_revision_job_events load_new_guix_revision_job_logs 2019-06-21T14:33:09Z chris # Add load_new_guix_revision_job_logs change_load_new_guix_revision_job_logs_contents_to_be_nullable 2019-07-07T20:10:54Z Christopher Baines # Change the contents field in the load_new_guix_revision_job_logs table\nto be nullable.\n\nwith '#' will # be ignored, and an empty message aborts the add. #\nChange to add: # #\nchange_load_new_guix_revision_job_logs_contents_to_be_nullable #\nsqitch/deploy/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql\nsqitch/revert/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql\nsqitch/verify/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql fix_duplicated_licenses 2019-07-30T05:48:17Z Christopher Baines # Fix duplicated licenses, and add constraints change_git_branches_primary_key 2019-08-05T18:57:41Z Christopher Baines # Change the git_branches primary key to include the git_repository_id,\nas this will allow having the same branch in different repositories. remove_duplicate_load_new_guix_revision_jobs 2019-08-05T19:06:36Z Christopher Baines # Remove duplicate load_new_guix_revision_jobs lint_warnings 2019-08-18T17:10:12Z Christopher Baines # Store lint warnings guix_revision_lint_checkers 2019-09-01T12:17:38Z chris # Associate lint_checkers to guix_revisions package_versions_by_guix_revision_range 2019-09-26T20:23:15Z Christopher Baines # Add package_versions_by_guix_revision_range table index_on_load_new_guix_revision_job_events_job_id 2019-09-29T10:39:04Z Christopher Baines # Add index on load_new_guix_revision_job_events.job_id fix_null_values_in_git_branches 2019-09-29T11:06:12Z Christopher Baines # Fix the NULL values in git_branches add_retry_value_to_job_event_enum 2019-10-02T19:13:52Z Christopher Baines # Add retry value to job_event enum remove_guix_revision_duplicates 2019-10-05T08:00:14Z Christopher Baines # Remove duplicates in the guix_revisions table package_derivations_by_guix_revision_range 2019-11-09T19:09:48Z Christopher Baines # Add package_derivations_by_guix_revision_range channel_news_tables 2019-11-15T07:32:07Z Christopher Baines # Add tables to store channel news build_server_token_seeds 2019-11-23T09:26:48Z Christopher Baines # Add build_server_token_seeds table rework_builds 2019-11-23T20:41:20Z Christopher Baines # Rework the build tables nar_related_tables 2019-11-29T20:28:19Z Christopher Baines # Add nar related tables add_index_on_builds_derivation_file_name 2019-12-03T16:23:55Z # Add index on builds_derivation_file_name narinfo_fetch_record 2019-12-03T20:53:28Z # Add a table to describe fetching a narinfo change_nars_size_to_bigint 2019-12-04T21:24:21Z # Change nars.size to bigint change_nar_urls_size_to_bigint 2019-12-04T21:49:07Z # Change nar_urls.size to bigint sort_out_duplicate_builds 2019-12-05T12:43:53Z # Sort out duplicate builds add_some_database_indexes 2019-12-05T15:53:04Z Christopher Baines # Add some indexes derivation_output_sets 2019-12-05T23:19:05Z Christopher Baines # Describe the sets of derivation outputs builds_add_derivation_output_details_set_id 2019-12-07T18:25:38Z Christopher Baines # Add a derivation_output_details_set_id column to builds derivations_hash_index 2019-12-24T22:54:19Z Christopher Baines # Add index on derivations for the hash component of the filename add_derivation_source_file_nars 2019-12-28T20:37:06Z Christopher Baines # Add table for derivation source file nars derivation_source_files_store_path_hash_index 2019-12-29T17:53:08Z Christopher Baines # Add index on the hash part of the derivation source files store path build_servers_build_config 2020-01-05T12:06:13Z Christopher Baines # Add build_servers_build_config table git-repositories-x-git-repo-header 2020-01-11T16:39:32Z Christopher Baines # Add x_git_repo_header to git_repositories system_test_tables 2020-02-02T11:36:20Z Christopher Baines # Add tables for storing system tests change_package_derivations_target 2020-02-07T19:29:50Z Christopher Baines # Change package_derivations target remove_old_cross_derivations 2020-02-07T19:42:54Z Christopher Baines # Remove old cross derivations increase_fillfactor_for_some_indexes 2020-02-07T20:49:17Z Christopher Baines # Increase the fillfactor for some btree indexes change_package_derivations_by_guix_revision_range_target 2020-02-08T10:13:07Z Christopher Baines # Change the values for package_derivations_by_guix_revision_range target allow_including_and_excluding_branches_for_repositories 2020-02-08T11:30:02Z Christopher Baines # Allow including and excluding branches for repositories channel_instance_derivations 2020-02-10T07:59:03Z Christopher Baines # Add tables to store derivations for channel instances update_build_servers_build_config 2020-02-13T20:07:19Z Christopher Baines # Update build_servers_build_config values make_some_constraints_deferrable 2020-02-16T10:54:22Z Christopher Baines # Make some constraints deferrable guix_revision_system_test_derivations_add_system 2020-03-19T21:30:33Z Christopher Baines # Add a system column to the guix_revision_system_test_derivations table drop_package_versions_by_guix_revision_range 2020-03-24T20:40:38Z Christopher Baines # Drop package_versions_by_guix_revision_range create_narinfo_fetch_records_index 2020-03-25T19:07:28Z Christopher Baines # Create an index on narinfo_fetch_records load_new_guix_revision_jobs_make_commits_unique 2020-03-27T21:38:42Z Christopher Baines # Make load_new_guix_revision_jobs commits unique remove_odd_package_derivations 2020-04-24T20:36:06Z Christopher Baines # Remove odd package derivations build_servers_lookup_builds 2020-05-24T15:18:09Z Christopher Baines # Add build_servers.lookup_builds make_nar_urls_file_size_optional 2020-06-03T05:27:29Z Christopher Baines # Make the nar_urls.file_size optional translations_for_lint_checker_descriptions 2020-05-22T19:49:37Z daniela # Support translations for lint checker descriptions translations_for_package_synopsis_and_descriptions 2020-06-09T12:42:54Z daniela # Support translations for package synopsis and descriptions build_status_nullable_timestamp 2020-06-27T12:34:29Z Christopher Baines # Make build_status.timestamp nullable build_add_build_server_build_id 2020-06-27T12:48:57Z Christopher Baines # Add builds.build_server_build_id build_status_add_unique_index 2020-06-30T17:19:30Z Christopher Baines # Add a unique index to the build_status table builds_remove_build_server_id_derivation_unique_constraint 2020-06-30T20:17:48Z Christopher Baines # Allow multiple builds of the same derivation per build server derivation_output_details_sets_derivation_output_details_ids_index 2020-07-04T07:56:49Z Christopher Baines # Add GIN index on derivation_output_details_ids add-tsvectors-per-locale 2020-07-16T18:19:44Z daniela # Add tsvectors per locale change_package_descriptions_index 2020-08-23T11:56:00Z Christopher Baines # Change the package_descriptions index change_locale_values 2020-09-26T10:20:22Z Christopher Baines # Change locale values change_autovacuum_config 2020-10-01T21:24:46Z Christopher Baines # Change autovacuum config change_derivation_source_file_nars_constraint 2020-10-02T17:12:58Z Christopher Baines # Change derivation source file nars constraint add_derivation_sources_derivation_source_file_id_index 2020-10-02T19:11:59Z Christopher Baines # Add derivation_sources.derivation_source_file_id index git_repositories_add_fetch_with_authentication_field 2020-10-07T17:31:20Z Christopher Baines # Add git_repositories.fetch_with_authentication create_latest_build_status 2020-10-13T17:22:39Z Christopher Baines # Create the latest_build_status table regenerate_latest_build_status 2020-10-21T18:39:03Z Christopher Baines # Regenerate the latest_build_status table guix_revision_package_derivations_add_package_derivation_index 2020-10-27T16:58:08Z Christopher Baines # Add index for guix_revision_package_derivations.package_derivation_id increase_derivation_inputs_statistics_targets 2020-12-27T10:34:58Z Christopher Baines # Increase stats targets on derivation_inputs fields remove_guix_revisions_store_path 2021-02-02T20:06:18Z Christopher Baines # Drop guix_revisions.store_path systems_table 2021-04-22T08:12:10Z Christopher Baines # Add a systems table some_indexes 2021-05-17T17:36:38Z Christopher Baines # Add some indexes package_metadata_location_id_index 2021-05-27T19:51:13Z Canan Talayhan # Add index for location id packages_replacement 2021-04-24T04:52:57Z Christopher Baines # Add packages.replacement_package_id package_derivations_not_null_hash_index 2021-07-11T14:19:32Z Christopher Baines # Add an index to package_derivations git_branch_id 2022-05-23T18:11:14Z Chris # Add git_branch.id partition_package_derivations_by_guix_revision_range 2022-05-23T18:20:37Z Chris # Partition package_derivations_by_guix_revision_range package_range_index 2022-06-17T10:39:31Z Chris # Add index on package_derivations_by_guix_revision_range.package_name fix_git_commits_duplicates 2022-06-17T10:39:50Z Chris # Fix git_commits duplicates git_repositories_query_substitutes 2022-09-09T11:35:16Z Chris # Add git_repositories.query_substitutes package_derivations_id_package_id_idx 2022-09-14T09:24:30Z Chris # Add index on package_derivations id and package_id blocked_builds 2022-11-07T11:27:28Z Chris # Add blocked_builds package_derivations_extended_statistics 2022-11-12T10:40:18Z Chris # Add extended statistics on package_derivations derivation_outputs_id_and_derivation_id_idx 2022-11-12T10:41:42Z Chris # Add index on derivation_outputs id and derivation_id blocked_builds_blocked_builds_blocked_derivation_output_details_set_id_2 2023-03-05T10:19:53Z Chris # Add index on blocked_builds_blocked_derivation_output_details_set_id guix_revision_package_derivation_distribution_counts 2023-03-08T16:53:44Z Chris # Add guix_revision_package_derivation_distribution_counts table cascade_nar_foreign_keys 2023-08-01T09:42:33Z Chris # Make it easier to delete nars entries nar_indexes 2023-08-01T11:37:35Z Chris # Add nar related indexes git_repositories_poll_interval 2023-10-08T20:36:09Z Chris # Add git_repositories.poll_interval