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

     1  BEGIN;
     2    CREATE TABLE pipes (
     3        id text NOT NULL,
     4        url text,
     5        team_id integer NOT NULL
     6    );
     7  
     8    ALTER TABLE ONLY pipes
     9        ADD CONSTRAINT pipes_pkey PRIMARY KEY (id);
    10  
    11    CREATE INDEX pipes_team_id ON pipes USING btree (team_id);
    12  
    13    ALTER TABLE ONLY pipes
    14        ADD CONSTRAINT pipes_team_id_fkey FOREIGN KEY (team_id) REFERENCES teams(id) ON DELETE CASCADE;
    15  COMMIT;