LuckPerms

LuckPerms

Mods
41.4k Downloads

Support specific schema for PostgresSQL

misterquestions opened this issue ยท 2 comments

commented

Description

When using PostgreSQL as data storage it would be really handy to have an option to use an specific schema, that way a single database could be used on multiple purposes divided by schemas, for example in a network having a shared schema with permissions only could be really great.

Proposed Behaviour

Within configuration file being able to have some connection extra option for postgres like "schema" should be sufficient.

Extra Details

None.

commented

LuckPerms/bukkit/src/main/resources/config.yml

Lines 156 to 160 in c3802c2

# The prefix for all LuckPerms SQL tables.
#
# - This only applies for remote SQL storage types (MySQL, MariaDB, etc).
# - Change this if you want to use different tables for different servers.
table-prefix: 'luckperms_'

commented

The schema isn't the same as table prefix. In PostgreSQL schemas are like folders that contain other tables. By default its public, but what if I wanted to use something different but in the same database?