Ferreteria/sql/user permit: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(post-move adjustments)
(one more thing)
Line 4: Line 4:
* '''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
** '''2017-01-29''' moved from [[VbzCart]] to Ferreteria a few days ago; renamed from uperm to user_permit; changed MYISAM to InnoDB
==SQL==
==SQL==
<mysql>CREATE TABLE `user_permit` (
<mysql>CREATE TABLE `user_permit` (
Line 13: Line 13:
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = InnoDB;</mysql>

Revision as of 14:26, 29 January 2017

About

  • Purpose: a list of access permissions to 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

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

) ENGINE = InnoDB;</mysql>