Ferreteria/sql/user group: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
** '''2017-01-26''' moved to Ferreteria, renamed from ugroup to user_group, changed from MYISAM to InnoDB | ** '''2017-01-26''' moved to Ferreteria, renamed from ugroup to user_group, changed from MYISAM to InnoDB | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `user_group` ( | <source lang=mysql>CREATE TABLE `user_group` ( | ||
`ID` | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`Name` | `Name` VARCHAR(31) NOT NULL COMMENT "name of group", | ||
`Descr` | `Descr` VARCHAR(255) DEFAULT NULL COMMENT "description/usage", | ||
`WhenCreated` DATETIME | `WhenCreated` DATETIME NOT NULL COMMENT "when group was created", | ||
`WhenEdited` DATETIME DEFAULT NULL COMMENT "when group was last modified", | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = InnoDB;</ | ENGINE = InnoDB;</source> | ||
Revision as of 18:44, 14 January 2020
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
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",
`WhenEdited` DATETIME DEFAULT NULL COMMENT "when group was last modified",
PRIMARY KEY(`ID`)
)
ENGINE = InnoDB;