: Renaming the group table
Dear piler users,
I'd like to get your help with
https://bitbucket.org/jsuto/piler/issues/1058/database-table-name-group-rese
rved-keyword
The issue is about finding a better name for the group table.
The problem is that "group" is a reserved keyword
Hi Janos and list,
maybe it's a bit overkill but can also be an interesting way to handle
this :
why not use database table prefix?
Maybe "piler_" as a default value.
Or a custom prefix defined in config?
You could start using it with the problematic "group" table and extend
that concept in t
Janos-
collection? I also like Carsten's usergroup suggestion because it maintains
the word group inside of it.
Steve
On Fri, Feb 26, 2021 at 8:21 AM wrote:
>
>
> Dear piler users,
>
> I'd like to get your help with
>
> https://bitbucket.org/jsuto/piler/issues/1058/database-table-name-group-re
Hi Janos,
> The reason that I picked this reserved word back then is because
> I didn't find a better word for describing a group of users than
> 'group'.
why don't you name the table just "usergroup"?
Carsten
Dear piler users,
I'd like to get your help with
https://bitbucket.org/jsuto/piler/issues/1058/database-table-name-group-reserved-keyword
The issue is about finding a better name for the group table.
The problem is that "group" is a reserved keyword in sql, so
you need to backtick it in a