diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-04-14 10:06:13 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-04-14 10:06:13 +0100 |
| commit | d69f77d59eefc1ca577d6df0cfe6d8cd46742b82 (patch) | |
| tree | 86dd2c86d984dcbb49741e4852407af66587d2a8 /sqitch/revert | |
| parent | 70faad04371ff441793da4e6213ae0855723b019 (diff) | |
| download | data-service-d69f77d59eefc1ca577d6df0cfe6d8cd46742b82.tar data-service-d69f77d59eefc1ca577d6df0cfe6d8cd46742b82.tar.gz | |
Add some initial Sqitch migrations
These are based on the state of the current manually managed database.
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; |