Forums / Cotonti / Core Labs / Ideas / Groups without rights table

esclkm
#1 2009-02-14 17:56
In the LDU groups was fictitiously, user can add his own private groups. were open groups
In Seditio it was removed. Every seditio group was it own rights. I think some times it is not good. For example on my site: more 150 categories, 20 sections in the forum, 60 plugins, 20 groups, although the rights table only different in 5 groups. Calculate:
20x230-5x230 = 4600-1150 = 3450 blank SQL entries, which are not needed in the database, which will not be used.
Proposal:
Add additional field to the database "group type": normal, "rightsfree" or group that created by users

Admins, Developers, Designers - please write your opinion
littledev.ru - мой маленький зарождающийся блог о котонти.
снижение стоимости программирования и снижение стоимости производства разные вещи. Первое можно скорее сравнить с раздачей работникам дешевых инструментов, чем со снижением зарплаты
This post was edited by esclkm (2009-02-14 22:51, 15 years ago)
Trustmaster
#2 2009-04-03 22:50
Yes, I think this would save a lot of space in sed_auth table, because on large sites there are a lot of groups which are added for "Status", not for permissions.
May the Source be with you!
GHengeveld
#3 2009-04-27 15:51
This could be implemented in combination with this hack, as Trustmaster pointed out.
This hack adds grp_type to the sed_groups table, with possible values of 'both' and 'sub'. If set to 'sub', this group can only be set as a subgroup (not main).
It shouln't be too hard to add the option 'rightsfree' (or similar) for groups which don't require a sed_auth row.