Ferreteria/sql/user group

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 00:34, 27 January 2017 by htyp>Woozle (Woozle moved page VbzCart/tables/ugroup to Ferreteria/sql/user group without leaving a redirect: this has been a ferreteria table for awhile now too)
Jump to navigation Jump to search

About

  • Purpose: a list of access-control groups to which users can belong
  • Used by: user_x_ugroup
  • History:
    • 2013-11-27 written

SQL

<mysql>CREATE TABLE `ugroup` ( 

 `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 ugroup was created",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/user_group&oldid=1782"