Ferreteria/sql/user group

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;