Custom table prefix

  • Resolved chelminski

    (@chelminski)


    7 months ago

    Hi :D,

    We are using the psmsc plugin across multiple WordPress installations that need to share the same helpdesk data. Currently, the plugin automatically prepends the WordPress site prefix to its tables, resulting in table names like site1_psmsc_…, site2_psmsc_…, etc. This makes it impossible to use the same tables across different sites.

    We would like to request an optional feature in the plugin to:

    Remove the WordPress site prefix from the plugin tables entirely, so all installations can use the same tables (e.g., psmsc_messages, psmsc_tickets).

    Allow changing the plugin prefix (psmsc_) to a custom value if needed.

    This optional setting would give full control over table naming and make it possible to synchronize helpdesk data across multiple WordPress sites while maintaining flexibility.

    Thank you for considering this improvement.

    Greetings,
    Dawid

Viewing 1 replies (of 1 total)
  • miliighe

    (@miliighe)

    6 months, 4 weeks ago

    Hi Dawid,

    Thank you for your detailed, developer-focused question.

    To answer your question directly, what you are asking for is not possible within the WordPress architecture.

    In a Multisite environment, WordPress itself automatically prepends a unique prefix (which includes the blog_id, e.g., wp_2_, wp_3_) to the database tables for each individual sub-site. This is a core function of WordPress designed to keep each site’s data separate and is not something that a plugin can edit or change.

    Because our plugin must adhere to these WordPress standards, we cannot offer an option to remove the site prefix to share tables across different sites.

    I hope this clarifies the technical reason for this limitation.

Viewing 1 replies (of 1 total)

The topic ‘Custom table prefix’ is closed to new replies.