%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