tornado_jwt_db.sql

-- Creates the user table
CREATE TABLE IF NOT EXISTS public.users
(
    username character varying COLLATE pg_catalog."default" NOT NULL,
    pwd character varying COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone NOT NULL DEFAULT now(),
    CONSTRAINT users_pkey PRIMARY KEY (username)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

-- Creates the blacklisted token table
CREATE TABLE IF NOT EXISTS public.blacklist_tokens
(
    blacklist_id SERIAL,
    token_str character varying COLLATE pg_catalog."default" NOT NULL,
    blacklisted_on timestamp with time zone NOT NULL DEFAULT now(),
    CONSTRAINT blacklist_tokens_pkey PRIMARY KEY (blacklist_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;