github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1569945021_add_components.up.sql (about)

     1  BEGIN;
     2  
     3    CREATE TABLE components (
     4        id serial PRIMARY KEY,
     5        name text NOT NULL,
     6        interval text NOT NULL,
     7        last_ran timestamp WITH TIME ZONE,
     8        paused boolean DEFAULT FALSE
     9    );
    10  
    11    CREATE UNIQUE INDEX components_name_key ON components (name);
    12  
    13  COMMIT;