Ferreteria/sql/user group

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< Ferreteria‎ | sql
Revision as of 01:02, 27 January 2017 by Woozle (talk | contribs)
Jump to: navigation, search

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>