CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE OR REPLACE FUNCTION updated_datetime()
RETURNS TRIGGER AS $$
BEGIN
    NEW.updated_at = now();
    RETURN NEW;
END;
$$ language 'plpgsql';

CREATE OR REPLACE FUNCTION UUID() RETURNS uuid AS $$
BEGIN
    RETURN uuid_generate_v4();
END;
$$ LANGUAGE 'plpgsql';

CREATE TABLE jwk_keys
(
    id uuid NOT NULL DEFAULT uuid(),
    private_key jsonb NOT NULL,
    public_key jsonb NOT NULL,
    updated_at timestamp without time zone NOT NULL DEFAULT NOW(),
    created_at timestamp without time zone NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id)
);

CREATE TRIGGER updated_jwk_keys
    BEFORE UPDATE
    ON jwk_keys
    FOR EACH ROW
    EXECUTE PROCEDURE updated_datetime();