RES: Renaming the group table
Hello Janos, We are using de group tables to redirect alias accounts to physical adresses. Maybe renaming group to alias could be an option. Best regards Wolfgang -Mensagem original- De: s...@acts.hu Enviada em: sexta-feira, 26 de fevereiro de 2021 13:21 Para: Piler User Assunto: 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 in sql, so you need to backtick it in a query like select * from `group`; 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'. I've just looked up https://www.thesaurus.com/browse/group?s=t and search for synonyms, but I'm stuck. I don't want to come up with a silly word instead of 'group'. So I'd like you to vote to either keep the table name as group and use `group` in your queries or recommend a better word. In the latter case we need to rename the group table to the new name which is a trivial task, though still some manual intervention at an upgrade to the upcoming 1.3.12 (I haven't started working on it yet). Janos
Re: Renaming the group table
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 the future if it proofs feasible. The reason why it came to my mind : I had a few mediawiki installations in the past few months and they are using table prefix over there. This would allow multiple installations of piler if your are limited to use one single database. Don't know if that applies to someone building a mailarchive ... regards, Mario > > > 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 query like select * from `group`; > > 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'. > > I've just looked up https://www.thesaurus.com/browse/group?s=t > and search for synonyms, but I'm stuck. I don't want to come up > with a silly word instead of 'group'. > > So I'd like you to vote to either keep the table name as group > and use `group` in your queries or recommend a better word. In > the latter case we need to rename the group table to the new name > which is a trivial task, though still some manual intervention > at an upgrade to the upcoming 1.3.12 (I haven't started working > on it yet). > > Janos >
Re: Renaming the group table
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-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 query like select * from `group`; > > 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'. > > I've just looked up https://www.thesaurus.com/browse/group?s=t > and search for synonyms, but I'm stuck. I don't want to come up > with a silly word instead of 'group'. > > So I'd like you to vote to either keep the table name as group > and use `group` in your queries or recommend a better word. In > the latter case we need to rename the group table to the new name > which is a trivial task, though still some manual intervention > at an upgrade to the upcoming 1.3.12 (I haven't started working > on it yet). > > Janos > >
Re: Renaming the group table
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
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 query like select * from `group`; 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'. I've just looked up https://www.thesaurus.com/browse/group?s=t and search for synonyms, but I'm stuck. I don't want to come up with a silly word instead of 'group'. So I'd like you to vote to either keep the table name as group and use `group` in your queries or recommend a better word. In the latter case we need to rename the group table to the new name which is a trivial task, though still some manual intervention at an upgrade to the upcoming 1.3.12 (I haven't started working on it yet). Janos
