Ferreteria/sql/user permit: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (updated syntax highlight tags)
(module link)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': a list of access permits (permissions) that groups (and therefore users) can have
* '''Purpose''': a list of access permits (permissions) that groups (and therefore users) can have
* '''Module''': {{l/ferreteria/module|users}}
* '''Used by''': {{l/same|ugroup_x_upermit}}
* '''Used by''': {{l/same|ugroup_x_upermit}}
* '''History''':
* '''History''':

Revision as of 20:22, 12 November 2018

About

  • Purpose: a list of access permits (permissions) that groups (and therefore users) can have
  • Module: Template:L/ferreteria/module
  • Used by: ugroup_x_upermit
  • History:
    • 2013-11-27 written
    • 2017-01-29 moved from VbzCart to Ferreteria a few days ago; renamed from uperm to user_permit; changed MYISAM to InnoDB
    • 2017-03-25 added unique key for Name

SQL

CREATE TABLE `user_permit` (
  `ID`       INT              NOT NULL AUTO_INCREMENT,
  `Name`     VARCHAR(31)      NOT NULL COMMENT "name of permission",
  `Descr`    VARCHAR(255) DEFAULT NULL COMMENT "description/usage",
  `WhenCreated` DATETIME      NOT NULL COMMENT "when this uperm was created",
  PRIMARY KEY(`ID`),
  UNIQUE KEY `Name_UNIQUE` (`Name`)
)
ENGINE = InnoDB;