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

     1  BEGIN;
     2    CREATE TABLE users (
     3      "id" serial NOT NULL PRIMARY KEY,
     4      "sub" text NOT NULL,
     5      "username" text NOT NULL,
     6      "connector" text NOT NULL,
     7      "last_login" timestamp with time zone DEFAULT now() NOT NULL
     8    );
     9    ALTER TABLE ONLY users ADD CONSTRAINT user_unique UNIQUE (sub);
    10  COMMIT;