Ferreteria/sql/user permit: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(one more thing) |
(unique key) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': a list of access permissions | * '''Purpose''': a list of access permits (permissions) that groups (and therefore users) can have | ||
* '''Used by''': {{l/same|ugroup_x_upermit}} | * '''Used by''': {{l/same|ugroup_x_upermit}} | ||
* '''History''': | * '''History''': | ||
** '''2013-11-27''' written | ** '''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-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== | ==SQL== | ||
<mysql>CREATE TABLE `user_permit` ( | <mysql>CREATE TABLE `user_permit` ( | ||
| Line 11: | Line 12: | ||
`Descr` VARCHAR(255) DEFAULT NULL COMMENT "description/usage", | `Descr` VARCHAR(255) DEFAULT NULL COMMENT "description/usage", | ||
`WhenCreated` DATETIME NOT NULL COMMENT "when this uperm was created", | `WhenCreated` DATETIME NOT NULL COMMENT "when this uperm was created", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`), | ||
UNIQUE KEY `Name_UNIQUE` (`Name`) | |||
) | ) | ||
ENGINE = InnoDB;</mysql> | ENGINE = InnoDB;</mysql> | ||
Revision as of 18:46, 25 March 2017
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>