Ferreteria/v0.5/sql/user permit

From Woozle Writes Code
< Ferreteria‎ | v0.5‎ | sql
Revision as of 21:34, 30 March 2022 by htyp>Woozle (Created page with "==SQL== <syntaxhighlight lang=mysql> CREATE TABLE `user_permit` ( `ID` int NOT NULL AUTO_INCREMENT, `Name` varchar(31) NOT NULL COMMENT 'name of perm...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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`)
) ENGINE=InnoDB;