diff options
Diffstat (limited to 'sqitch/revert')
| -rw-r--r-- | sqitch/revert/appschema.sql | 7 | ||||
| -rw-r--r-- | sqitch/revert/buildstatus_enum.sql | 7 | ||||
| -rw-r--r-- | sqitch/revert/initial_import.sql | 21 |
3 files changed, 35 insertions, 0 deletions
diff --git a/sqitch/revert/appschema.sql b/sqitch/revert/appschema.sql new file mode 100644 index 0000000..1446dc7 --- /dev/null +++ b/sqitch/revert/appschema.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:appschema from pg + +BEGIN; + +DROP SCHEMA guix_data_service; + +COMMIT; diff --git a/sqitch/revert/buildstatus_enum.sql b/sqitch/revert/buildstatus_enum.sql new file mode 100644 index 0000000..08b321c --- /dev/null +++ b/sqitch/revert/buildstatus_enum.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:buildstatus_enum from pg + +BEGIN; + +DROP TYPE guix_data_service.buildstatus; + +COMMIT; diff --git a/sqitch/revert/initial_import.sql b/sqitch/revert/initial_import.sql new file mode 100644 index 0000000..2a24cb3 --- /dev/null +++ b/sqitch/revert/initial_import.sql @@ -0,0 +1,21 @@ +-- Revert guix-data-service:initial_import from pg + +BEGIN; + +DROP TABLE guix_data_service.build_servers; +DROP TABLE guix_data_service.build_status; +DROP TABLE guix_data_service.builds; +DROP TABLE guix_data_service.derivation_inputs; +DROP TABLE guix_data_service.derivation_output_details; +DROP TABLE guix_data_service.derivation_outputs; +DROP TABLE guix_data_service.derivation_source_files; +DROP TABLE guix_data_service.derivation_sources; +DROP TABLE guix_data_service.derivations; +DROP TABLE guix_data_service.guix_revision_package_derivations; +DROP TABLE guix_data_service.guix_revisions; +DROP TABLE guix_data_service.load_new_guix_revision_jobs; +DROP TABLE guix_data_service.package_derivations; +DROP TABLE guix_data_service.package_metadata; +DROP TABLE guix_data_service.packages; + +COMMIT; |