QGIS user log table

qgis_userlogs.sql

-- Table: public.qgis_log_table

-- DROP TABLE IF EXISTS public.qgis_log_table;

CREATE TABLE IF NOT EXISTS public.qgis_log_table
(
    log_id integer NOT NULL DEFAULT nextval('qgis_log_table_log_id_seq'::regclass),
    "timestamp" timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    username character varying(255) COLLATE pg_catalog."default" NOT NULL,
    message text COLLATE pg_catalog."default" NOT NULL,
    tag character varying(50) COLLATE pg_catalog."default",
    level character varying(10) COLLATE pg_catalog."default",
    plugin_name character varying COLLATE pg_catalog."default",
    qgis_version character varying COLLATE pg_catalog."default",
    CONSTRAINT qgis_log_table_pkey PRIMARY KEY (log_id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.qgis_log_table
    OWNER to qgis_log;