Ferreteria/sql/user permit: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': a list of access permissions to that groups (and therefore users) can have * '''Used by''': {{l/same|user_x_uperm}} * '''History''': ** '''2013-11-2...") |
(corrected table name in SQL; corrected "used by") |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': a list of access permissions to that groups (and therefore users) can have | * '''Purpose''': a list of access permissions to that groups (and therefore users) can have | ||
* '''Used by''': {{l/same| | * '''Used by''': {{l/same|ugroup_x_uperm}} | ||
* '''History''': | * '''History''': | ||
** '''2013-11-27''' written | ** '''2013-11-27''' written | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `uperm` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`Name` VARCHAR(31) NOT NULL COMMENT "name of permission", | `Name` VARCHAR(31) NOT NULL COMMENT "name of permission", | ||
Revision as of 03:23, 1 December 2013
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>