-- Your SQL goes here

CREATE TABLE public.token
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY,
    secret_key text NOT NULL,
    "user" integer NOT NULL,
    created timestamp(0) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    name text,
    PRIMARY KEY (id),
    UNIQUE (secret_key),
    FOREIGN KEY ("user")
        REFERENCES public."user" (id) MATCH SIMPLE
        ON UPDATE CASCADE
        ON DELETE CASCADE
        NOT VALID
);