Ferreteria/sql/user group: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(post-move adjustments) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': a list of access-control groups to which users can belong | * '''Purpose''': a list of access-control groups to which users can belong | ||
* '''Used by''': {{l/same| | * '''Used by''': {{l/same|uacct_x_ugroup}} | ||
* '''History''': | * '''History''': | ||
** '''2013-11-27''' written | ** '''2013-11-27''' written | ||
** '''2017-01-26''' moved to Ferreteria, renamed from ugroup to user_group, changed from MYISAM to | ** '''2017-01-26''' moved to Ferreteria, renamed from ugroup to user_group, changed from MYISAM to InnoDB | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `user_group` ( | <mysql>CREATE TABLE `user_group` ( | ||
| Line 13: | Line 13: | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = | ENGINE = InnoDB;</mysql> | ||
Revision as of 01:02, 27 January 2017
About
- Purpose: a list of access-control groups to which users can belong
- Used by: uacct_x_ugroup
- History:
- 2013-11-27 written
- 2017-01-26 moved to Ferreteria, renamed from ugroup to user_group, changed from MYISAM to InnoDB
SQL
<mysql>CREATE TABLE `user_group` (
`ID` INT NOT NULL AUTO_INCREMENT, `Name` VARCHAR(31) NOT NULL COMMENT "name of group", `Descr` VARCHAR(255) DEFAULT NULL COMMENT "description/usage", `WhenCreated` DATETIME NOT NULL COMMENT "when group was created", PRIMARY KEY(`ID`)
) ENGINE = InnoDB;</mysql>