1mqx3zVm

1CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
2
3CREATE OR REPLACE FUNCTION updated_datetime()
4RETURNS TRIGGER AS $$
5BEGIN
6    NEW.updated_at = now();
7    RETURN NEW;
8END;
9$$ language 'plpgsql';
10
11CREATE OR REPLACE FUNCTION UUID() RETURNS uuid AS $$
12BEGIN
13    RETURN uuid_generate_v4();
14END;
15$$ LANGUAGE 'plpgsql';
16
17CREATE TABLE jwk_keys
18(
19    id uuid NOT NULL DEFAULT uuid(),
20    private_key jsonb NOT NULL,
21    public_key jsonb NOT NULL,
22    updated_at timestamp without time zone NOT NULL DEFAULT NOW(),
23    created_at timestamp without time zone NOT NULL DEFAULT NOW(),
24    PRIMARY KEY (id)
25);
26
27CREATE TRIGGER updated_jwk_keys
28    BEFORE UPDATE
29    ON jwk_keys
30    FOR EACH ROW
31    EXECUTE PROCEDURE updated_datetime();