CREATE TABLE gemma_schema_version (
    version int PRIMARY KEY,
    update_date timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
    LANGUAGE plpgsql
    AS $$
    BEGIN
        RETURN ( SELECT max(version) FROM gemma_schema_version );
    END;
$$;