Difference between revisions of "Ferreteria/sql/user group"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search
m
 
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`       INT              NOT NULL AUTO_INCREMENT,
+
   `ID`         INT              NOT NULL AUTO_INCREMENT,
   `Name`     VARCHAR(31)      NOT NULL COMMENT "name of group",
+
   `Name`       VARCHAR(31)      NOT NULL COMMENT "name of group",
   `Descr`   VARCHAR(255) DEFAULT NULL COMMENT "description/usage",
+
   `Descr`       VARCHAR(255) DEFAULT NULL COMMENT "description/usage",
   `WhenCreated` DATETIME     NOT NULL COMMENT "when group was created",
+
   `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;</mysql>
+
ENGINE = InnoDB;</source>

Latest 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;