How can I create a table with custom prefix like wp_bms_products

Question

How can I create a table with custom prefix like wp_bms_products

Closed this issue a year ago · 3 comments

I am trying to figure how to do this in order to keep my tables together and prefixed via the plugin. Right now, I can only do wp_products and I would like to do wp_bms_products. The views throws an error that field name doesn't exists and I am sure it's because of the naming of the table. Thank you.

Answer 1 · 2023-10-23T18:37:35.000Z

I looked into the core and found you can override the table name by setting $table = '{prefix}bms_products' in my modle.

Answer 2 · 2023-10-23T18:40:27.000Z

Specify the table name in the class Sent from Gmail Mobile

…

On Mon, 23 Oct 2023 at 19:32, Jose Martinez ***@***.***> wrote: I am trying to figure how to do this in order to keep my tables together and prefixed via the plugin. Right now, I can only do wp_products and I would like to do wp_bms_products. The views throws an error that field name doesn't exists and I am sure it's because of the naming of the table. Thank you. — Reply to this email directly, view it on GitHub <#262>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAFJLZL7TQT5AJLLA5XBILDYA2Z3XAVCNFSM6AAAAAA6MQGVRCVHI2DSMVQWIX3LMV43ASLTON2WKOZRHE2TONZXGEYDQOA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

Answer 3 · 2023-10-23T20:12:46.000Z

@cyberscribe Thank you, I went into the core and saw that you can do that. Either way thank you so much!