github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1510262030_initial_schema.down.sql (about)

     1  BEGIN;
     2  
     3    DROP MATERIALIZED VIEW
     4      latest_completed_builds_per_job,
     5      next_builds_per_job,
     6      transition_builds_per_job
     7      CASCADE;
     8  
     9    DROP SEQUENCE
    10      config_version_seq,
    11      one_off_name;
    12  
    13    DROP TABLE
    14      base_resource_types,
    15      build_events,
    16      build_image_resource_caches,
    17      build_inputs,
    18      build_outputs,
    19      builds,
    20      cache_invalidator,
    21      containers,
    22      independent_build_inputs,
    23      jobs,
    24      jobs_serial_groups,
    25      next_build_inputs,
    26      pipelines,
    27      pipes,
    28      resource_cache_uses,
    29      resource_caches,
    30      resource_config_check_sessions,
    31      resource_configs,
    32      resource_types,
    33      resources,
    34      teams,
    35      versioned_resources,
    36      volumes,
    37      worker_base_resource_types,
    38      worker_resource_caches,
    39      worker_resource_config_check_sessions,
    40      worker_task_caches,
    41      workers
    42      CASCADE;
    43  
    44    DROP TYPE
    45      build_status,
    46      container_state,
    47      container_stage,
    48      container_state_old,
    49      volume_state,
    50      volume_state_old,
    51      worker_state;
    52  
    53  COMMIT;