Ferreteria/sql/user permit

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 18:46, 25 March 2017 by htyp>Woozle (unique key)
Jump to navigation Jump to search

About

  • Purpose: a list of access permits (permissions) that groups (and therefore users) can have
  • 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

<mysql>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;</mysql>

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