RES: Renaming the group table

2021-03-01 Thread NetLink
: 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

Re: Renaming the group table

2021-02-28 Thread Mario Pastoor
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

Re: Renaming the group table

2021-02-27 Thread Stephen Ingram
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

Re: Renaming the group table

2021-02-26 Thread Carsten Pohle
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

Renaming the group table

2021-02-26 Thread sj
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