File: src/Installer/sql/pgsql/40-user-extra.sql

CREATE TABLE IF NOT EXISTS airship_user_preferences (
    preferenceid BIGSERIAL PRIMARY KEY,
    userid BIGINT REFERENCES airship_users (userid),
    preferences JSONB NULL,
    created TIMESTAMP DEFAULT NOW(),
    modified TIMESTAMP DEFAULT NOW()
);

DROP TRIGGER IF EXISTS update_airship_user_preferences_modtime ON airship_user_preferences;
CREATE TRIGGER update_airship_user_preferences_modtime
    BEFORE UPDATE ON airship_user_preferences
    FOR EACH ROW EXECUTE PROCEDURE update_modtime();