Ferreteria/sql/user permit: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(corrected table name in SQL; corrected "used by")
m (Woozle moved page VbzCart/tables/uperm to Ferreteria/sql/user permit without leaving a redirect: also part of Ferreteria for awhile now)
(No difference)

Revision as of 00:39, 27 January 2017

About

  • Purpose: a list of access permissions to that groups (and therefore users) can have
  • Used by: ugroup_x_uperm
  • History:
    • 2013-11-27 written

SQL

<mysql>CREATE TABLE `uperm` (

 `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`)

) ENGINE = MYISAM;</mysql>